sentiment_segments
2 rows where conversation_id = "f2aa723e-8ead-4d60-a133-db6cc4a2fcbb"
This data as json, CSV (advanced)
| id ▼ | conversation_id | segment_index | text | sentiment | score | emotions |
|---|---|---|---|---|---|---|
| 57 | User Mentions Having Two Jobs f2aa723e-8ead-4d60-a133-db6cc4a2fcbb | 56 | I got two jobs, actually. | neutral | 0.0 | [] |
| 7429 | User Mentions Having Two Jobs f2aa723e-8ead-4d60-a133-db6cc4a2fcbb | 56 | I got two jobs, actually. | 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);