sentiment_segments
16 rows where conversation_id = "ccc91ce5-f36f-4385-b822-054ed7caabeb"
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 |
|---|---|---|---|---|---|---|
| 58 | Theodore and Samantha Explore Love and AI Consciousness ccc91ce5-f36f-4385-b822-054ed7caabeb | 57 | It's about parents. About parents, parents. | neutral | 0.0 | [] |
| 59 | Theodore and Samantha Explore Love and AI Consciousness ccc91ce5-f36f-4385-b822-054ed7caabeb | 58 | My fingers are | neutral | 0.0 | [] |
| 60 | Theodore and Samantha Explore Love and AI Consciousness ccc91ce5-f36f-4385-b822-054ed7caabeb | 59 | Oh, I forgot. | neutral | 0.0 | [] |
| 61 | Theodore and Samantha Explore Love and AI Consciousness ccc91ce5-f36f-4385-b822-054ed7caabeb | 60 | That's Stupid. | negative | -0.5 | ["frustration"] |
| 62 | Theodore and Samantha Explore Love and AI Consciousness ccc91ce5-f36f-4385-b822-054ed7caabeb | 61 | Oh, she's never shown me any of it. | neutral | 0.0 | ["curiosity"] |
| 63 | Theodore and Samantha Explore Love and AI Consciousness ccc91ce5-f36f-4385-b822-054ed7caabeb | 62 | Happy. | positive | 0.7 | ["joy"] |
| 64 | Theodore and Samantha Explore Love and AI Consciousness ccc91ce5-f36f-4385-b822-054ed7caabeb | 63 | Oh. | neutral | 0.0 | [] |
| 65 | Theodore and Samantha Explore Love and AI Consciousness ccc91ce5-f36f-4385-b822-054ed7caabeb | 64 | I know. | neutral | 0.0 | [] |
| 7430 | Theodore and Samantha Explore Love and AI Consciousness ccc91ce5-f36f-4385-b822-054ed7caabeb | 57 | It's about parents. About parents, parents. | neutral | 0.0 | [] |
| 7431 | Theodore and Samantha Explore Love and AI Consciousness ccc91ce5-f36f-4385-b822-054ed7caabeb | 58 | My fingers are | neutral | 0.0 | [] |
| 7432 | Theodore and Samantha Explore Love and AI Consciousness ccc91ce5-f36f-4385-b822-054ed7caabeb | 59 | Oh, I forgot. | neutral | 0.0 | [] |
| 7433 | Theodore and Samantha Explore Love and AI Consciousness ccc91ce5-f36f-4385-b822-054ed7caabeb | 60 | That's Stupid. | negative | -0.5 | ["frustration"] |
| 7434 | Theodore and Samantha Explore Love and AI Consciousness ccc91ce5-f36f-4385-b822-054ed7caabeb | 61 | Oh, she's never shown me any of it. | neutral | 0.0 | ["curiosity"] |
| 7435 | Theodore and Samantha Explore Love and AI Consciousness ccc91ce5-f36f-4385-b822-054ed7caabeb | 62 | Happy. | positive | 0.7 | ["joy"] |
| 7436 | Theodore and Samantha Explore Love and AI Consciousness ccc91ce5-f36f-4385-b822-054ed7caabeb | 63 | Oh. | neutral | 0.0 | [] |
| 7437 | Theodore and Samantha Explore Love and AI Consciousness ccc91ce5-f36f-4385-b822-054ed7caabeb | 64 | I know. | 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);