sentiment_segments
10 rows where conversation_id = "01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb"
This data as json, CSV (advanced)
Suggested facets: text, sentiment, score, emotions, emotions (array)
| id ▼ | conversation_id | segment_index | text | sentiment | score | emotions |
|---|---|---|---|---|---|---|
| 24282 | User Checks In On Eli’s Recovery 01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb | 246 | How are you feeling, Eli? | neutral | 0.0 | ["concern"] |
| 24283 | User Checks In On Eli’s Recovery 01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb | 247 | Do you wanna go go run? | positive | 0.5 | ["joy", "excitement"] |
| 24284 | User Checks In On Eli’s Recovery 01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb | 248 | Okay. | neutral | 0.0 | [] |
| 24285 | User Checks In On Eli’s Recovery 01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb | 249 | Good. Good job. | positive | 0.6 | ["joy", "pride"] |
| 24286 | User Checks In On Eli’s Recovery 01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb | 250 | Oh, wow. Yeah. That's a ton of sleep. Okay. It's probably good for you. | positive | 0.5 | ["concern", "relief"] |
| 24287 | User Checks In On Eli’s Recovery 01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb | 251 | Yeah. | neutral | 0.0 | [] |
| 24288 | User Checks In On Eli’s Recovery 01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb | 252 | Yeah. | neutral | 0.0 | [] |
| 24289 | User Checks In On Eli’s Recovery 01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb | 253 | You guys go into my house? Yeah. Yeah. | neutral | 0.0 | [] |
| 24290 | User Checks In On Eli’s Recovery 01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb | 254 | Yeah. | neutral | 0.0 | [] |
| 24291 | User Checks In On Eli’s Recovery 01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb | 255 | Yeah. | neutral | 0.0 | [] |
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);