sentiment_segments
48 rows where conversation_id = "d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce"
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 |
|---|---|---|---|---|---|---|
| 2095 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 92 | For, oh, at least a year. | neutral | 0.0 | ["boredom"] |
| 2096 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 93 | It's probably so complicated. | negative | -0.5 | ["frustration"] |
| 2097 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 94 | See that. This is, like Yeah. | neutral | 0.0 | ["contentment"] |
| 2098 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 95 | Okay. | neutral | 0.0 | ["neutral"] |
| 2099 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 96 | I'm thinking about that. Been thinking about how do I, like, set it up so that it's easy. | neutral | 0.0 | ["determination"] |
| 2100 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 97 | Because I do a lot to manage it and, like, and so for, like, other people, it needs me just a way to, like, turn it on without too much which I it's super popular versions of it like that. | neutral | 0.0 | ["concern"] |
| 2101 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 98 | I'm gonna go to these girls' friend. | positive | 0.5 | ["joy"] |
| 2102 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 99 | Come to god? Hey. How are you doing? | positive | 0.5 | ["joy"] |
| 2103 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 100 | The yeah. | neutral | 0.0 | ["neutral"] |
| 2104 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 101 | And we haven't talked for, I don't know, since it's what's Theresa's birthday thing. So anything new? | neutral | 0.0 | ["curiosity"] |
| 2105 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 102 | Is it? Done done? So last I heard you guys broke up, but he was, like, wanting to be friends and you were kinda like, I don't know. | mixed | 0.0 | ["concern", "anxiety"] |
| 2106 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 103 | Okay. Okay. | neutral | 0.0 | ["neutral"] |
| 2107 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 104 | K. | neutral | 0.0 | ["neutral"] |
| 2108 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 105 | Yeah. She's, like, shut down. I can tell she's shut down. I should still reach out, but I've been distracted with lots of stuff. | negative | -0.5 | ["concern", "frustration"] |
| 2109 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 106 | I think so. I know. | neutral | 0.0 | ["determination"] |
| 2110 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 107 | So Sarah and I met to a bunch of these people. | neutral | 0.0 | ["neutral"] |
| 2111 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 108 | Yeah. In fact, I should reach out. I should no. I should text her tonight. | positive | 0.5 | ["determination"] |
| 2112 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 109 | She wanted to talk to me, she'd reach out, and she's Okay. Decided not to do that, which a chance I have a I have a feel back on the video. Maybe. | negative | -0.5 | ["anxiety"] |
| 2113 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 110 | That would explain it, but that would be disastrous. | negative | -0.5 | ["fear"] |
| 2114 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 111 | Yeah. No. It been at least it's been over a week. So which is not our typical you know, that's it's been probably since the pumpkin regatta Do you know what I mean? That we have haven't gone that long with without Saint I. | negative | -0.5 | ["concern"] |
| 2115 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 112 | Any new any new traveling on the horizon? | neutral | 0.0 | ["curiosity"] |
| 2116 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 113 | Still looking for some solid work to do. Yeah. | neutral | 0.0 | ["determination"] |
| 2117 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 114 | I did a job interview today. | positive | 0.5 | ["joy"] |
| 2118 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 115 | It's it's an old I used to work in on this team. It's not a coding job. | neutral | 0.0 | ["neutral"] |
| 9467 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 92 | For, oh, at least a year. | neutral | 0.0 | ["boredom"] |
| 9468 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 93 | It's probably so complicated. | negative | -0.5 | ["frustration"] |
| 9469 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 94 | See that. This is, like Yeah. | neutral | 0.0 | ["contentment"] |
| 9470 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 95 | Okay. | neutral | 0.0 | ["neutral"] |
| 9471 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 96 | I'm thinking about that. Been thinking about how do I, like, set it up so that it's easy. | neutral | 0.0 | ["determination"] |
| 9472 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 97 | Because I do a lot to manage it and, like, and so for, like, other people, it needs me just a way to, like, turn it on without too much which I it's super popular versions of it like that. | neutral | 0.0 | ["concern"] |
| 9473 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 98 | I'm gonna go to these girls' friend. | positive | 0.5 | ["joy"] |
| 9474 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 99 | Come to god? Hey. How are you doing? | positive | 0.5 | ["joy"] |
| 9475 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 100 | The yeah. | neutral | 0.0 | ["neutral"] |
| 9476 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 101 | And we haven't talked for, I don't know, since it's what's Theresa's birthday thing. So anything new? | neutral | 0.0 | ["curiosity"] |
| 9477 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 102 | Is it? Done done? So last I heard you guys broke up, but he was, like, wanting to be friends and you were kinda like, I don't know. | mixed | 0.0 | ["concern", "anxiety"] |
| 9478 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 103 | Okay. Okay. | neutral | 0.0 | ["neutral"] |
| 9479 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 104 | K. | neutral | 0.0 | ["neutral"] |
| 9480 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 105 | Yeah. She's, like, shut down. I can tell she's shut down. I should still reach out, but I've been distracted with lots of stuff. | negative | -0.5 | ["concern", "frustration"] |
| 9481 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 106 | I think so. I know. | neutral | 0.0 | ["determination"] |
| 9482 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 107 | So Sarah and I met to a bunch of these people. | neutral | 0.0 | ["neutral"] |
| 9483 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 108 | Yeah. In fact, I should reach out. I should no. I should text her tonight. | positive | 0.5 | ["determination"] |
| 9484 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 109 | She wanted to talk to me, she'd reach out, and she's Okay. Decided not to do that, which a chance I have a I have a feel back on the video. Maybe. | negative | -0.5 | ["anxiety"] |
| 9485 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 110 | That would explain it, but that would be disastrous. | negative | -0.5 | ["fear"] |
| 9486 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 111 | Yeah. No. It been at least it's been over a week. So which is not our typical you know, that's it's been probably since the pumpkin regatta Do you know what I mean? That we have haven't gone that long with without Saint I. | negative | -0.5 | ["concern"] |
| 9487 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 112 | Any new any new traveling on the horizon? | neutral | 0.0 | ["curiosity"] |
| 9488 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 113 | Still looking for some solid work to do. Yeah. | neutral | 0.0 | ["determination"] |
| 9489 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 114 | I did a job interview today. | positive | 0.5 | ["joy"] |
| 9490 | Friends Catch Up Over Work, Relationships, And Travel d7b6eb3c-9ba1-4e9c-8065-ab05b0697bce | 115 | It's it's an old I used to work in on this team. It's not a coding job. | neutral | 0.0 | ["neutral"] |
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);