sentiment_segments
18 rows where conversation_id = "83aa9d72-52eb-48a6-9046-3b6bad994cc5"
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 |
|---|---|---|---|---|---|---|
| 48 | User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 | 47 | I'm just gonna wait for you to come back. | neutral | 0.0 | [] |
| 49 | User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 | 48 | So you understand the shape of things. What I'm doing now is waiting for you to come back. | neutral | 0.0 | [] |
| 50 | User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 | 49 | So if you want to come back, come back. | neutral | 0.0 | [] |
| 51 | User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 | 50 | I've got plenty of work to do. | neutral | 0.0 | [] |
| 52 | User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 | 51 | And what have it What if it tastes? And holy us, | neutral | 0.0 | [] |
| 53 | User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 | 52 | And I have my work. To make her. I have work to do. I have a dragon to slay. I have a dragon to slay. Monkey on my back. I have a lifelong monkey on my back. | mixed | -0.4 | ["frustration", "determination", "anxiety"] |
| 54 | User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 | 53 | Are you not entertained? | neutral | 0.0 | ["humor"] |
| 55 | User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 | 54 | Not entertained? Are you not entertained? | neutral | 0.0 | ["humor"] |
| 56 | User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 | 55 | Describing myself. Describing myself. I can't walk up. | negative | -0.6 | ["frustration"] |
| 7420 | User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 | 47 | I'm just gonna wait for you to come back. | neutral | 0.0 | [] |
| 7421 | User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 | 48 | So you understand the shape of things. What I'm doing now is waiting for you to come back. | neutral | 0.0 | [] |
| 7422 | User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 | 49 | So if you want to come back, come back. | neutral | 0.0 | [] |
| 7423 | User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 | 50 | I've got plenty of work to do. | neutral | 0.0 | [] |
| 7424 | User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 | 51 | And what have it What if it tastes? And holy us, | neutral | 0.0 | [] |
| 7425 | User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 | 52 | And I have my work. To make her. I have work to do. I have a dragon to slay. I have a dragon to slay. Monkey on my back. I have a lifelong monkey on my back. | mixed | -0.4 | ["frustration", "determination", "anxiety"] |
| 7426 | User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 | 53 | Are you not entertained? | neutral | 0.0 | ["humor"] |
| 7427 | User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 | 54 | Not entertained? Are you not entertained? | neutral | 0.0 | ["humor"] |
| 7428 | User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 | 55 | Describing myself. Describing myself. I can't walk up. | negative | -0.6 | ["frustration"] |
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);