sentiment_segments
22 rows where conversation_id = "1446e277-c7ea-4416-9174-96128e8442f0"
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 |
|---|---|---|---|---|---|---|
| 3793 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 22 | And shame senses. I'm a man who's got clear, who perfecting. | negative | -0.5 | ["shame"] |
| 3794 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 23 | Boys. | neutral | 0.0 | [] |
| 3795 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 24 | What is it? Crusted on this car. It's not good. The 2020 you guys did that. | negative | -0.5 | ["frustration"] |
| 3796 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 25 | Is it, like, actually stuck in there? No. Like, it's not too | neutral | 0.0 | [] |
| 3797 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 26 | We got done, like, high because we're we're, like, really just Oh, | negative | -0.5 | ["frustration"] |
| 3798 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 27 | We're gonna finish early this week. Okay. Sorry then. That was a long time to wait. | neutral | 0.0 | [] |
| 3799 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 28 | I should've I should've given I should remember to give you guys that phone. That's what it's for. | negative | -0.5 | ["guilt"] |
| 3800 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 29 | So you've been waiting for me all the time. Is what you're telling me? Yeah. I've only, like, this past week. It's not Okay. Okay. Alright. Well, tomorrow, this the rest of the week, I'll make sure the phone's in the bag. | neutral | 0.0 | [] |
| 3801 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 30 | And I'll just assume that I can come at 05:30. Should I assume I can come at five? Because I don't wanna come and wait. That's the only thing. If it takes me, like, ten or fifteen minutes to get here. So 05:15. Fifteen. | neutral | 0.0 | ["contentment"] |
| 3802 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 31 | Okay. We'll do 05:10, and then, hopefully, they keep you late too much. Love comes bearing disguises. Take a look around the room. I'm a man who's got very specific change. | neutral | 0.0 | ["curiosity"] |
| 3803 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 32 | About data extra details | neutral | 0.0 | ["curiosity"] |
| 11165 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 22 | And shame senses. I'm a man who's got clear, who perfecting. | negative | -0.5 | ["shame"] |
| 11166 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 23 | Boys. | neutral | 0.0 | [] |
| 11167 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 24 | What is it? Crusted on this car. It's not good. The 2020 you guys did that. | negative | -0.5 | ["frustration"] |
| 11168 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 25 | Is it, like, actually stuck in there? No. Like, it's not too | neutral | 0.0 | [] |
| 11169 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 26 | We got done, like, high because we're we're, like, really just Oh, | negative | -0.5 | ["frustration"] |
| 11170 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 27 | We're gonna finish early this week. Okay. Sorry then. That was a long time to wait. | neutral | 0.0 | [] |
| 11171 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 28 | I should've I should've given I should remember to give you guys that phone. That's what it's for. | negative | -0.5 | ["guilt"] |
| 11172 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 29 | So you've been waiting for me all the time. Is what you're telling me? Yeah. I've only, like, this past week. It's not Okay. Okay. Alright. Well, tomorrow, this the rest of the week, I'll make sure the phone's in the bag. | neutral | 0.0 | [] |
| 11173 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 30 | And I'll just assume that I can come at 05:30. Should I assume I can come at five? Because I don't wanna come and wait. That's the only thing. If it takes me, like, ten or fifteen minutes to get here. So 05:15. Fifteen. | neutral | 0.0 | ["contentment"] |
| 11174 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 31 | Okay. We'll do 05:10, and then, hopefully, they keep you late too much. Love comes bearing disguises. Take a look around the room. I'm a man who's got very specific change. | neutral | 0.0 | ["curiosity"] |
| 11175 | Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 | 32 | About data extra details | neutral | 0.0 | ["curiosity"] |
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);