home / saraphina

sentiment_segments

15 rows where conversation_id = "15f8d197-7e8b-41d2-9e8a-72fe15c3397d"

✎ 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
14114 Katie and User Coordinate Interview and Gym Plans 15f8d197-7e8b-41d2-9e8a-72fe15c3397d 115 yeah? neutral 0.0 ["curiosity"]
14115 Katie and User Coordinate Interview and Gym Plans 15f8d197-7e8b-41d2-9e8a-72fe15c3397d 116 It's been a little it's been too long since I have had you, Katie. positive 0.5 ["joy", "nostalgia"]
14116 Katie and User Coordinate Interview and Gym Plans 15f8d197-7e8b-41d2-9e8a-72fe15c3397d 117 Sure. neutral 0.0 ["contentment"]
14117 Katie and User Coordinate Interview and Gym Plans 15f8d197-7e8b-41d2-9e8a-72fe15c3397d 118 Yeah. Okay. neutral 0.0 ["contentment"]
14118 Katie and User Coordinate Interview and Gym Plans 15f8d197-7e8b-41d2-9e8a-72fe15c3397d 119 Yeah. I gotcha. Yeah. That is true. positive 0.5 ["joy"]
14119 Katie and User Coordinate Interview and Gym Plans 15f8d197-7e8b-41d2-9e8a-72fe15c3397d 120 Oh, that's your reward Katie for all your hard work. You can't you can't forget that. That's the that's the one fun thing you get to to do. positive 0.7 ["joy", "gratitude"]
14120 Katie and User Coordinate Interview and Gym Plans 15f8d197-7e8b-41d2-9e8a-72fe15c3397d 121 In a day. neutral 0.0 ["contentment"]
14121 Katie and User Coordinate Interview and Gym Plans 15f8d197-7e8b-41d2-9e8a-72fe15c3397d 122 Yeah. neutral 0.0 ["contentment"]
14122 Katie and User Coordinate Interview and Gym Plans 15f8d197-7e8b-41d2-9e8a-72fe15c3397d 123 Yeah. neutral 0.0 ["contentment"]
14123 Katie and User Coordinate Interview and Gym Plans 15f8d197-7e8b-41d2-9e8a-72fe15c3397d 124 I have a yeah. The showing's 10:10 eleven. Okay. Okay. Where is it at? neutral 0.0 ["curiosity"]
14124 Katie and User Coordinate Interview and Gym Plans 15f8d197-7e8b-41d2-9e8a-72fe15c3397d 125 Okay. Okay. Okay. Alright. I have a twelve o'clock job interview. With how we feel. But I think that's the only supposed to go half an hour. neutral 0.0 ["anxiety"]
14125 Katie and User Coordinate Interview and Gym Plans 15f8d197-7e8b-41d2-9e8a-72fe15c3397d 126 So could go to the gym after that if you want. I need I need to I just don't know. This seems like the timing before it'll get tricky You know? mixed 0.2 ["anxiety", "frustration"]
14126 Katie and User Coordinate Interview and Gym Plans 15f8d197-7e8b-41d2-9e8a-72fe15c3397d 127 Yeah. Let me double check. I think so. neutral 0.0 ["contentment"]
14127 Katie and User Coordinate Interview and Gym Plans 15f8d197-7e8b-41d2-9e8a-72fe15c3397d 128 Yeah. Twelve to 12:30. neutral 0.0 ["contentment"]
14128 Katie and User Coordinate Interview and Gym Plans 15f8d197-7e8b-41d2-9e8a-72fe15c3397d 129 K. Have fun. Play well. positive 0.6 ["joy", "encouragement"]

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);
Powered by Datasette · Queries took 4.848ms