sentiment_segments
10 rows where conversation_id = "37fc6000-1ec8-4283-99ce-e430a300f371"
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 |
|---|---|---|---|---|---|---|
| 2874 | Family Game Night and Tina’s Work Reviews 37fc6000-1ec8-4283-99ce-e430a300f371 | 110 | If I'm remembering right. | neutral | 0.0 | ["curiosity"] |
| 2875 | Family Game Night and Tina’s Work Reviews 37fc6000-1ec8-4283-99ce-e430a300f371 | 111 | Basketball. | neutral | 0.0 | ["contentment"] |
| 2876 | Family Game Night and Tina’s Work Reviews 37fc6000-1ec8-4283-99ce-e430a300f371 | 112 | do this. | neutral | 0.0 | ["curiosity"] |
| 2877 | Family Game Night and Tina’s Work Reviews 37fc6000-1ec8-4283-99ce-e430a300f371 | 113 | Correct. | positive | 0.5 | ["determination"] |
| 2878 | Family Game Night and Tina’s Work Reviews 37fc6000-1ec8-4283-99ce-e430a300f371 | 114 | So Yeah. Yeah. That's that's sounds like It's intense. | neutral | 0.0 | ["concern"] |
| 10246 | Family Game Night and Tina’s Work Reviews 37fc6000-1ec8-4283-99ce-e430a300f371 | 110 | If I'm remembering right. | neutral | 0.0 | ["curiosity"] |
| 10247 | Family Game Night and Tina’s Work Reviews 37fc6000-1ec8-4283-99ce-e430a300f371 | 111 | Basketball. | neutral | 0.0 | ["contentment"] |
| 10248 | Family Game Night and Tina’s Work Reviews 37fc6000-1ec8-4283-99ce-e430a300f371 | 112 | do this. | neutral | 0.0 | ["curiosity"] |
| 10249 | Family Game Night and Tina’s Work Reviews 37fc6000-1ec8-4283-99ce-e430a300f371 | 113 | Correct. | positive | 0.5 | ["determination"] |
| 10250 | Family Game Night and Tina’s Work Reviews 37fc6000-1ec8-4283-99ce-e430a300f371 | 114 | So Yeah. Yeah. That's that's sounds like It's intense. | neutral | 0.0 | ["concern"] |
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);