sentiment_segments
22 rows where conversation_id = "17623cdc-f551-4332-a8a8-4f857f2f4908"
This data as json, CSV (advanced)
Suggested facets: text, sentiment, score, emotions, emotions (array)
| id ▼ | conversation_id | segment_index | text | sentiment | score | emotions |
|---|---|---|---|---|---|---|
| 14092 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 93 | That's not the written. Right? No. Okay. | neutral | 0.0 | ["contentment"] |
| 14093 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 94 | Yeah. | neutral | 0.0 | ["contentment"] |
| 14094 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 95 | Yeah. Yeah. | neutral | 0.0 | ["contentment"] |
| 14095 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 96 | Right. | neutral | 0.0 | ["contentment"] |
| 14096 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 97 | That's funny. That's weird. | mixed | 0.2 | ["humor", "curiosity"] |
| 14097 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 98 | We're lovely. | positive | 0.6 | ["joy", "warmth"] |
| 14098 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 99 | You were both more lovely and more temperate. | positive | 0.6 | ["joy", "warmth"] |
| 14099 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 100 | Shall I compare you to a summer's day? Thou art both more lovely and more temperate. | positive | 0.8 | ["joy", "warmth"] |
| 14100 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 101 | Yeah. | neutral | 0.0 | ["contentment"] |
| 14101 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 102 | Yeah. | neutral | 0.0 | ["contentment"] |
| 14102 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 103 | Was | neutral | 0.0 | ["contentment"] |
| 14103 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 104 | Yeah. | neutral | 0.0 | ["contentment"] |
| 14104 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 105 | I mean, the set of transactions you have right now are, like, they're they've built like, it's, like, not | neutral | 0.0 | ["contentment"] |
| 14105 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 106 | Maybe they'll, like, like, marketing engine is not clear how well that's gonna work. Yeah. | neutral | 0.0 | ["contentment"] |
| 14106 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 107 | There's difference between Emily talking about what Matt gonna do and you talking about what you're gonna do for one thing. | neutral | 0.0 | ["contentment"] |
| 14107 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 108 | Would you prefer like, there is an element of, like, I don't wanna talk about what I'm gonna do because I wanna I know. I the I think I told you this. There's some podcasts where I was like, don't tell people what you're gonna do. | neutral | 0.0 | ["contentment"] |
| 14108 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 109 | Well, it, like, it, like, gives you a reward before you've actually done it. Like, there's a there's a reward when you like, it it sucks away motivation. Like, when you're hungry for something, then you say you're going to do it, it gives you some of the reward and it robs some of the motivation of it from the system psychologically. | mixed | 0.4 | ["frustration", "determination"] |
| 14109 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 110 | Yes. | positive | 0.6 | ["joy", "warmth"] |
| 14110 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 111 | I Right. | neutral | 0.0 | ["contentment"] |
| 14111 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 112 | Some people say you're supposed to, like, declare what you're gonna do in public because that that holds you accountable, and that creates motivation that this particular thing should the opposite. | mixed | 0.2 | ["curiosity", "frustration"] |
| 14112 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 113 | Tell anybody. Keep it to yourself. | positive | 0.6 | ["determination", "hope"] |
| 14113 | Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 | 114 | I know. I got you. Understand. | positive | 0.6 | ["empathy", "connection"] |
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);