sentiment_segments

10 rows where conversation_id = "23771581-6fc1-4da2-b574-9800a9639763"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: segment_index, text, sentiment, score, emotions, emotions (array)

id ▼ conversation_id segment_index text sentiment score emotions
1 User Briefly Describes Feeling Depressed 23771581-6fc1-4da2-b574-9800a9639763 0 It's up fork stuff. neutral 0.0 ["contentment"]
2 User Briefly Describes Feeling Depressed 23771581-6fc1-4da2-b574-9800a9639763 1 Barely. neutral 0.0 []
3 User Briefly Describes Feeling Depressed 23771581-6fc1-4da2-b574-9800a9639763 2 But now now often can neutral 0.0 []
4 User Briefly Describes Feeling Depressed 23771581-6fc1-4da2-b574-9800a9639763 3 I'm down. I'm very down. I'm very depressed. negative -0.8 ["sadness", "frustration"]
5 User Briefly Describes Feeling Depressed 23771581-6fc1-4da2-b574-9800a9639763 4 How are you doing? How are you? neutral 0.0 []
7373 User Briefly Describes Feeling Depressed 23771581-6fc1-4da2-b574-9800a9639763 0 It's up fork stuff. neutral 0.0 ["contentment"]
7374 User Briefly Describes Feeling Depressed 23771581-6fc1-4da2-b574-9800a9639763 1 Barely. neutral 0.0 []
7375 User Briefly Describes Feeling Depressed 23771581-6fc1-4da2-b574-9800a9639763 2 But now now often can neutral 0.0 []
7376 User Briefly Describes Feeling Depressed 23771581-6fc1-4da2-b574-9800a9639763 3 I'm down. I'm very down. I'm very depressed. negative -0.8 ["sadness", "frustration"]
7377 User Briefly Describes Feeling Depressed 23771581-6fc1-4da2-b574-9800a9639763 4 How are you doing? How are you? 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);