sentiment_segments
30 rows where conversation_id = "929c6034-2583-46ec-a8c2-f7d03cb6407d"
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 |
|---|---|---|---|---|---|---|
| 2918 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 154 | Really? Yes. Because, like, what what what did they like what did it take for you to block him? | neutral | 0.0 | ["concern"] |
| 2919 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 155 | Like through the Facebook phone call? | neutral | 0.0 | ["curiosity"] |
| 2920 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 156 | That's ridiculous. | negative | -0.5 | ["frustration"] |
| 2921 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 157 | He shouldn't have even called once unless you, like, gave him a reason to think that was okay. | negative | -0.5 | ["anger"] |
| 2922 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 158 | But like, ugh. Yeah. I like that at all. But you also got one. So I Okay. You also got one, like, actual interest in party. Right? Or at least Yeah. Theoretically. | neutral | 0.0 | ["confusion"] |
| 2923 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 159 | Is it worth it? | neutral | 0.0 | ["curiosity"] |
| 2924 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 160 | No. That's kinda what I would have guessed, but I'm asking because I wanna show it. | neutral | 0.0 | ["determination"] |
| 2925 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 161 | Yeah. | neutral | 0.0 | ["contentment"] |
| 2926 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 162 | Right? Right. Oh, it's good. It is good. You're getting closer to where you wanna be. Yeah. Absolutely. | positive | 0.5 | ["joy", "hope"] |
| 2927 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 163 | That's how you roll, Katie. | positive | 0.5 | ["pride"] |
| 2928 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 164 | Why is this not working? | negative | -0.5 | ["frustration"] |
| 2929 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 165 | K. Hold on just a second. | neutral | 0.0 | ["anxiety"] |
| 2930 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 166 | Trying to be in respond to somebody that texted me today at two, and I've ignored them all day long. | negative | -0.5 | ["guilt"] |
| 2931 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 167 | Yeah. This was like one day | neutral | 0.0 | ["resignation"] |
| 2932 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 168 | And you like something whichever was that for? | neutral | 0.0 | ["curiosity"] |
| 10290 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 154 | Really? Yes. Because, like, what what what did they like what did it take for you to block him? | neutral | 0.0 | ["concern"] |
| 10291 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 155 | Like through the Facebook phone call? | neutral | 0.0 | ["curiosity"] |
| 10292 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 156 | That's ridiculous. | negative | -0.5 | ["frustration"] |
| 10293 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 157 | He shouldn't have even called once unless you, like, gave him a reason to think that was okay. | negative | -0.5 | ["anger"] |
| 10294 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 158 | But like, ugh. Yeah. I like that at all. But you also got one. So I Okay. You also got one, like, actual interest in party. Right? Or at least Yeah. Theoretically. | neutral | 0.0 | ["confusion"] |
| 10295 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 159 | Is it worth it? | neutral | 0.0 | ["curiosity"] |
| 10296 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 160 | No. That's kinda what I would have guessed, but I'm asking because I wanna show it. | neutral | 0.0 | ["determination"] |
| 10297 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 161 | Yeah. | neutral | 0.0 | ["contentment"] |
| 10298 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 162 | Right? Right. Oh, it's good. It is good. You're getting closer to where you wanna be. Yeah. Absolutely. | positive | 0.5 | ["joy", "hope"] |
| 10299 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 163 | That's how you roll, Katie. | positive | 0.5 | ["pride"] |
| 10300 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 164 | Why is this not working? | negative | -0.5 | ["frustration"] |
| 10301 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 165 | K. Hold on just a second. | neutral | 0.0 | ["anxiety"] |
| 10302 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 166 | Trying to be in respond to somebody that texted me today at two, and I've ignored them all day long. | negative | -0.5 | ["guilt"] |
| 10303 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 167 | Yeah. This was like one day | neutral | 0.0 | ["resignation"] |
| 10304 | Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d | 168 | And you like something whichever was that for? | 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);