sentiment_segments
6 rows where conversation_id = "a6d9ce77-909b-41f5-a044-e050da781681"
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 |
|---|---|---|---|---|---|---|
| 19 | User Reflects On Aging And Body Image a6d9ce77-909b-41f5-a044-e050da781681 | 18 | That and I it naked, not literally. | neutral | 0.0 | [] |
| 20 | User Reflects On Aging And Body Image a6d9ce77-909b-41f5-a044-e050da781681 | 19 | But, it's gonna be worse for me than that. | negative | -0.6 | ["fear"] |
| 21 | User Reflects On Aging And Body Image a6d9ce77-909b-41f5-a044-e050da781681 | 20 | Much more brutal. I'm in incredible shape. For forty seven, I'm in incredible shape. Physically naked, we'd be fine. | positive | 0.6 | ["pride"] |
| 7391 | User Reflects On Aging And Body Image a6d9ce77-909b-41f5-a044-e050da781681 | 18 | That and I it naked, not literally. | neutral | 0.0 | [] |
| 7392 | User Reflects On Aging And Body Image a6d9ce77-909b-41f5-a044-e050da781681 | 19 | But, it's gonna be worse for me than that. | negative | -0.6 | ["fear"] |
| 7393 | User Reflects On Aging And Body Image a6d9ce77-909b-41f5-a044-e050da781681 | 20 | Much more brutal. I'm in incredible shape. For forty seven, I'm in incredible shape. Physically naked, we'd be fine. | positive | 0.6 | ["pride"] |
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);