sentiment_segments
6 rows where conversation_id = "e5958c86-a55f-4811-8018-0b2c1ad58c56"
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 |
|---|---|---|---|---|---|---|
| 5562 | Family Reviews Mortgages And Gathers Tax Documents e5958c86-a55f-4811-8018-0b2c1ad58c56 | 213 | Not yet. | neutral | 0.0 | ["resignation"] |
| 5563 | Family Reviews Mortgages And Gathers Tax Documents e5958c86-a55f-4811-8018-0b2c1ad58c56 | 214 | K. | neutral | 0.0 | ["contentment"] |
| 5564 | Family Reviews Mortgages And Gathers Tax Documents e5958c86-a55f-4811-8018-0b2c1ad58c56 | 215 | That doesn't sound good. That's so good. | mixed | 0.5 | ["concern", "joy"] |
| 12692 | Family Reviews Mortgages And Gathers Tax Documents e5958c86-a55f-4811-8018-0b2c1ad58c56 | 213 | Not yet. | neutral | 0.0 | ["resignation"] |
| 12693 | Family Reviews Mortgages And Gathers Tax Documents e5958c86-a55f-4811-8018-0b2c1ad58c56 | 214 | K. | neutral | 0.0 | ["contentment"] |
| 12694 | Family Reviews Mortgages And Gathers Tax Documents e5958c86-a55f-4811-8018-0b2c1ad58c56 | 215 | That doesn't sound good. That's so good. | mixed | 0.5 | ["concern", "joy"] |
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);