sentiment_segments
2 rows where conversation_id = "0d6c6a96-e448-42d6-b957-71cbe659ba07"
This data as json, CSV (advanced)
Suggested facets: emotions (array)
| id ▼ | conversation_id | segment_index | text | sentiment | score | emotions |
|---|---|---|---|---|---|---|
| 1189 | Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 | 137 | So Ja? | neutral | 0.0 | ["neutral"] |
| 8561 | Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 | 137 | So Ja? | neutral | 0.0 | ["neutral"] |
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);