sentiment_segments
1 row where conversation_id = "15dc9cd2-2533-4a52-847e-dbe59da8bc96"
This data as json, CSV (advanced)
Suggested facets: emotions (array)
| id ▼ | conversation_id | segment_index | text | sentiment | score | emotions |
|---|---|---|---|---|---|---|
| 24582 | Friends Discuss Getting Five Guys 15dc9cd2-2533-4a52-847e-dbe59da8bc96 | 288 | Guys want five guys? Yeah. | positive | 0.5 | ["joy", "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);