sentiment_segments
16 rows where conversation_id = "0f8708e9-7d5a-4688-b93f-464794c2d435"
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 |
|---|---|---|---|---|---|---|
| 1846 | Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 | 291 | Hey? Hey. Good morning. How are you? I'm good. How are you doing? Good. Good. You was? | positive | 0.6 | ["joy"] |
| 1847 | Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 | 292 | Okay. Okay. | neutral | 0.0 | [] |
| 1848 | Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 | 293 | Yeah. Do you sleep okay? | neutral | 0.0 | [] |
| 1849 | Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 | 294 | Okay. | neutral | 0.0 | [] |
| 1850 | Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 | 295 | I mean, | neutral | 0.0 | [] |
| 1851 | Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 | 296 | But I'd like to help you if I can. | positive | 0.4 | ["empathy"] |
| 1852 | Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 | 297 | More market y. Uh-huh. Yeah. Okay. | neutral | 0.0 | [] |
| 1853 | Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 | 298 | I'm gonna go to the store and get casted. | neutral | 0.0 | [] |
| 9218 | Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 | 291 | Hey? Hey. Good morning. How are you? I'm good. How are you doing? Good. Good. You was? | positive | 0.6 | ["joy"] |
| 9219 | Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 | 292 | Okay. Okay. | neutral | 0.0 | [] |
| 9220 | Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 | 293 | Yeah. Do you sleep okay? | neutral | 0.0 | [] |
| 9221 | Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 | 294 | Okay. | neutral | 0.0 | [] |
| 9222 | Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 | 295 | I mean, | neutral | 0.0 | [] |
| 9223 | Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 | 296 | But I'd like to help you if I can. | positive | 0.4 | ["empathy"] |
| 9224 | Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 | 297 | More market y. Uh-huh. Yeah. Okay. | neutral | 0.0 | [] |
| 9225 | Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 | 298 | I'm gonna go to the store and get casted. | 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);