sentiment_segments

16 rows where conversation_id = "0f581d26-7ba3-42f2-a5ea-bda95e058f0b"

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ conversation_id segment_index text sentiment score emotions
24584 Family Talks Wrestling, Bench Press, And Muscle Gains 0f581d26-7ba3-42f2-a5ea-bda95e058f0b 290 Hey. Do have an order for Jay That'd be forty second. neutral 0.0 ["contentment"]
24585 Family Talks Wrestling, Bench Press, And Muscle Gains 0f581d26-7ba3-42f2-a5ea-bda95e058f0b 291 Good. How about you? positive 0.5 ["joy"]
24586 Family Talks Wrestling, Bench Press, And Muscle Gains 0f581d26-7ba3-42f2-a5ea-bda95e058f0b 292 Good. positive 0.5 ["joy"]
24587 Family Talks Wrestling, Bench Press, And Muscle Gains 0f581d26-7ba3-42f2-a5ea-bda95e058f0b 293 No plans. Something might come up. neutral 0.0 ["contentment"]
24588 Family Talks Wrestling, Bench Press, And Muscle Gains 0f581d26-7ba3-42f2-a5ea-bda95e058f0b 294 You guys. Thank you. Thank you. Have a good one. positive 0.7 ["gratitude", "joy"]
24589 Family Talks Wrestling, Bench Press, And Muscle Gains 0f581d26-7ba3-42f2-a5ea-bda95e058f0b 295 Guys, going okay. Going home to eat it or do you wanna eat it here? Okay. If you guys want, you can have some of the fries. positive 0.6 ["warmth", "joy"]
24590 Family Talks Wrestling, Bench Press, And Muscle Gains 0f581d26-7ba3-42f2-a5ea-bda95e058f0b 296 Yeah? neutral 0.0 ["curiosity"]
24591 Family Talks Wrestling, Bench Press, And Muscle Gains 0f581d26-7ba3-42f2-a5ea-bda95e058f0b 297 See what it says. neutral 0.0 ["curiosity"]
24592 Family Talks Wrestling, Bench Press, And Muscle Gains 0f581d26-7ba3-42f2-a5ea-bda95e058f0b 298 One seventy. One seventy. Yeah. neutral 0.0 ["contentment"]
24593 Family Talks Wrestling, Bench Press, And Muscle Gains 0f581d26-7ba3-42f2-a5ea-bda95e058f0b 299 Uh-huh. neutral 0.0 ["contentment"]
24594 Family Talks Wrestling, Bench Press, And Muscle Gains 0f581d26-7ba3-42f2-a5ea-bda95e058f0b 300 Yeah. Yeah. neutral 0.0 ["contentment"]
24595 Family Talks Wrestling, Bench Press, And Muscle Gains 0f581d26-7ba3-42f2-a5ea-bda95e058f0b 301 Yeah. Yeah. neutral 0.0 ["contentment"]
24596 Family Talks Wrestling, Bench Press, And Muscle Gains 0f581d26-7ba3-42f2-a5ea-bda95e058f0b 302 Right. neutral 0.0 ["contentment"]
24597 Family Talks Wrestling, Bench Press, And Muscle Gains 0f581d26-7ba3-42f2-a5ea-bda95e058f0b 303 Yeah. neutral 0.0 ["contentment"]
24598 Family Talks Wrestling, Bench Press, And Muscle Gains 0f581d26-7ba3-42f2-a5ea-bda95e058f0b 304 Maybe. neutral 0.0 ["contentment"]
24599 Family Talks Wrestling, Bench Press, And Muscle Gains 0f581d26-7ba3-42f2-a5ea-bda95e058f0b 305 I I respect myself more. positive 0.5 ["pride"]

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);