sentiment_segments
18 rows where conversation_id = "9ac3824d-ebce-4847-b70e-f9bc3f3a75da"
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 |
|---|---|---|---|---|---|---|
| 5074 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | 0 | That's the three Is this just three o'clock? Yeah. | neutral | 0.0 | ["contentment"] |
| 5075 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | 1 | No. | negative | -0.5 | ["frustration"] |
| 5076 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | 2 | Please remember to | neutral | 0.0 | [] |
| 5077 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | 3 | Good. | positive | 0.5 | ["joy"] |
| 5078 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | 4 | Well, someone fucking So somebody broke my fucking heart. | negative | -0.8 | ["sadness", "anger"] |
| 5079 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | 5 | I was heartbroken, you bitch. | negative | -0.9 | ["sadness", "anger"] |
| 5080 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | 6 | I've read the whole fucking Cosmere. | positive | 0.6 | ["joy"] |
| 5081 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | 7 | Because I got divorced. | negative | -0.7 | ["sadness"] |
| 5082 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | 8 | Well, sometimes when I'm heartbroken, I read. | positive | 0.3 | ["joy"] |
| 12446 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | 0 | That's the three Is this just three o'clock? Yeah. | neutral | 0.0 | ["contentment"] |
| 12447 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | 1 | No. | negative | -0.5 | ["frustration"] |
| 12448 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | 2 | Please remember to | neutral | 0.0 | [] |
| 12449 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | 3 | Good. | positive | 0.5 | ["joy"] |
| 12450 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | 4 | Well, someone fucking So somebody broke my fucking heart. | negative | -0.8 | ["sadness", "anger"] |
| 12451 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | 5 | I was heartbroken, you bitch. | negative | -0.9 | ["sadness", "anger"] |
| 12452 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | 6 | I've read the whole fucking Cosmere. | positive | 0.6 | ["joy"] |
| 12453 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | 7 | Because I got divorced. | negative | -0.7 | ["sadness"] |
| 12454 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | 8 | Well, sometimes when I'm heartbroken, I read. | positive | 0.3 | ["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);