sentiment_segments
14 rows where conversation_id = "0308d873-fa97-4afb-8563-0014618d8fad"
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 |
|---|---|---|---|---|---|---|
| 1854 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | 299 | How's it going? | neutral | 0.0 | [] |
| 1855 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | 300 | I was just walking. Oh, why are you walking? | neutral | 0.0 | ["contentment"] |
| 1856 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | 301 | How long you been up? | neutral | 0.0 | ["curiosity"] |
| 1857 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | 302 | Okay. Is John still asleep? | neutral | 0.0 | ["concern"] |
| 1858 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | 303 | Okay. | neutral | 0.0 | [] |
| 1859 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | 304 | It's a lot of cats? Yeah. In just a few minutes? I forgot I left my drink out here. | neutral | 0.0 | [] |
| 1860 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | 305 | Also, Sharkey followed me Do you guys wanna go run around the track today? It's supposed to be, like, 55. | positive | 0.5 | ["excitement"] |
| 9226 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | 299 | How's it going? | neutral | 0.0 | [] |
| 9227 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | 300 | I was just walking. Oh, why are you walking? | neutral | 0.0 | ["contentment"] |
| 9228 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | 301 | How long you been up? | neutral | 0.0 | ["curiosity"] |
| 9229 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | 302 | Okay. Is John still asleep? | neutral | 0.0 | ["concern"] |
| 9230 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | 303 | Okay. | neutral | 0.0 | [] |
| 9231 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | 304 | It's a lot of cats? Yeah. In just a few minutes? I forgot I left my drink out here. | neutral | 0.0 | [] |
| 9232 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | 305 | Also, Sharkey followed me Do you guys wanna go run around the track today? It's supposed to be, like, 55. | positive | 0.5 | ["excitement"] |
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);