sentiment_segments
6 rows where conversation_id = "be08c053-0ff8-4cca-b994-cce1ba9c494e"
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 |
|---|---|---|---|---|---|---|
| 1861 | Family Morning Chores And Plans be08c053-0ff8-4cca-b994-cce1ba9c494e | 306 | Sorry. He should let somebody know when that happens. | negative | -0.5 | ["frustration"] |
| 1862 | Family Morning Chores And Plans be08c053-0ff8-4cca-b994-cce1ba9c494e | 307 | Get yourself some breakfast and I will Do you guys need clothes for today? Probably need to do laundry. | neutral | 0.0 | [] |
| 1863 | Family Morning Chores And Plans be08c053-0ff8-4cca-b994-cce1ba9c494e | 308 | I'm gonna take the bar. | neutral | 0.0 | [] |
| 9233 | Family Morning Chores And Plans be08c053-0ff8-4cca-b994-cce1ba9c494e | 306 | Sorry. He should let somebody know when that happens. | negative | -0.5 | ["frustration"] |
| 9234 | Family Morning Chores And Plans be08c053-0ff8-4cca-b994-cce1ba9c494e | 307 | Get yourself some breakfast and I will Do you guys need clothes for today? Probably need to do laundry. | neutral | 0.0 | [] |
| 9235 | Family Morning Chores And Plans be08c053-0ff8-4cca-b994-cce1ba9c494e | 308 | I'm gonna take the bar. | 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);