sentiment_segments

4 rows where conversation_id = "0752aae1-2d9b-48b8-ab72-13f7e254462e"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: segment_index, text

id ▼ conversation_id segment_index text sentiment score emotions
349 User Seeks Guidance On Building Something 0752aae1-2d9b-48b8-ab72-13f7e254462e 13 How do I build? neutral 0.0 []
350 User Seeks Guidance On Building Something 0752aae1-2d9b-48b8-ab72-13f7e254462e 14 So know what to do about it. neutral 0.0 []
7721 User Seeks Guidance On Building Something 0752aae1-2d9b-48b8-ab72-13f7e254462e 13 How do I build? neutral 0.0 []
7722 User Seeks Guidance On Building Something 0752aae1-2d9b-48b8-ab72-13f7e254462e 14 So know what to do about it. neutral 0.0 []

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE sentiment_segments (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        conversation_id TEXT NOT NULL,
        segment_index INTEGER,
        text TEXT,
        sentiment TEXT,
        score REAL,
        emotions TEXT,
        FOREIGN KEY (conversation_id) REFERENCES omi_conversations(id)
    );
CREATE INDEX idx_sentiment_segments_conv ON sentiment_segments(conversation_id);