sentiment_segments
15 rows where conversation_id = "15f8d197-7e8b-41d2-9e8a-72fe15c3397d"
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
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);