sentiment_segments

41 rows where conversation_id = "1982eda9-85e4-43fb-ab64-2245df51e403"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: sentiment, score, emotions, emotions (array)

id ▼ conversation_id segment_index text sentiment score emotions
15214 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 193 Much do you wanna spend on sink? neutral 0.0 ["contentment"]
15215 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 194 Well, she probably is. I could drink, call her. neutral 0.0 ["contentment"]
15216 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 195 Hey, mom. How's it going? Good. Are you up? Did I wake you up? positive 0.5 ["joy", "connection"]
15217 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 196 I texted you. Is putting a little kitchen in one of her apartments. And she's wondering about countertops. She's looking for, like, remnants or something cheap, and she's wondering if that's something you have and if how quickly your guys could do it. She's trying to turn it around in, a couple of days. neutral 0.0 ["contentment"]
15218 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 197 Okay. neutral 0.0 ["contentment"]
15219 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 198 I'll tell her. We'll probably text you with more questions or call you back. neutral 0.0 ["contentment"]
15220 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 199 Okay. neutral 0.0 ["contentment"]
15221 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 200 Thanks, mom. Talk soon. Bye. K. She said they have guys writing, like, low blood to the usual, so they could move on it right away. positive 0.5 ["joy", "gratitude"]
15222 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 201 They do have remnants. She's like, we're not the cheapest. neutral 0.0 ["contentment"]
15223 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 202 So she said, her the sizes and she can and then if you wanna she said you could go down Monday and pick something out if you wanted. neutral 0.0 ["contentment"]
15224 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 203 So it's an option. neutral 0.0 ["contentment"]
15225 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 204 36, the sink, and then a thirty. neutral 0.0 ["contentment"]
15226 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 205 Okay. 30. So maybe 30 for the sink. Okay. And then were you thinking just 30 and then just $8.18? Not go all the way over? Or were you thinking 2 eighteens? neutral 0.0 ["contentment"]
15227 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 206 Right. neutral 0.0 ["contentment"]
15228 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 207 Okay. neutral 0.0 ["contentment"]
15229 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 208 Oh, you found it. Or is it? neutral 0.0 ["contentment"]
15230 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 209 Yeah. I think the guy I was talking to, he's like, this is not my department. neutral 0.0 ["contentment"]
15231 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 210 Thank you. positive 0.5 ["gratitude"]
15232 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 211 Yeah. Yeah. These are all colored. neutral 0.0 ["contentment"]
15233 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 212 K. neutral 0.0 ["contentment"]
15234 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 213 then the whatever. We just Thanks to you. positive 0.5 ["gratitude"]
15235 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 214 And Yeah. 66 inches. K. neutral 0.0 ["contentment"]
15236 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 215 Wondering like, if I need to switch all of my accounts over to, like, a cash card or something, Like, if I shouldn't use my bank accounts because it's gonna be too much of a hassle, the like like, function that way if the trustee has acts like, they can freeze your account, but happens sometimes. negative -0.5 ["anxiety", "concern"]
15237 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 216 So I'm like, should I just not even use it? But then if I don't use it, is that that fraud? But is it just what you do anyway? Because it's like, you you know what I mean? negative -0.5 ["anxiety", "frustration"]
15238 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 217 I have questions like that. Like, how am I gonna function for a month or two? Without oh, I mean, how do I function in the interim without any income But then once I do get like, one of the things I was planning on doing was if I had to, was getting some little temporary jobs off of Upwork. negative -0.5 ["anxiety", "frustration"]
15239 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 218 But Upwork is gonna put that money into a bank account, and right now, that bank account is my business bank account, which is potentially gonna get frozen. Like, I you know what I mean? Like, it's like, well, now what do I do? Because I don't know I need to move money in around in different ways than I was doing before in order to function Right. So I've got questions like this Yeah. In my mind. negative -0.5 ["anxiety", "frustration"]
15240 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 219 And I don't have really have answers. I I I'm I guess I should just write them all down. The problem is is like I write stuff down and then I ask my attorney and then more comes up, you know. I like, I didn't think about this. And then I text him and he's like, stand off. negative -0.5 ["frustration", "anxiety"]
15241 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 220 And then I called Vic, and Vic's down to bankruptcy attorney. So he's like, well, maybe this. neutral 0.0 ["contentment"]
15242 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 221 I know one from my old ward, but, like, we weren't really buddies. And so he's not gonna wanna answer questions for free. Yeah. Like, any it needs to be someone that likes me, that wants to help me. Right? negative -0.5 ["anxiety", "concern"]
15243 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 222 Because I'm essentially asking them for free professional advice. So it would need to be somebody that's a pretty good friend for that not to be gross. negative -0.5 ["anxiety", "concern"]
15244 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 223 Anyway, you don't wanna you don't wanna know what's in my mind, kitty. neutral 0.0 ["curiosity"]
15245 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 224 Yeah. Exactly. neutral 0.0 ["contentment"]
15246 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 225 I do, and I took a picture of it. Oh. If you just if you just need the picture. I do. I can text it to you. positive 0.5 ["joy", "excitement"]
15247 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 226 What why? What? Well, no, but what, like, what is Josh's reason for wanting you to keep? What, like, what thinks I should have just lowered the price. negative -0.5 ["frustration", "confusion"]
15248 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 227 Oh, okay. Okay. neutral 0.0 ["contentment"]
15249 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 228 All this stuff into that room? Yeah. neutral 0.0 ["curiosity"]
15250 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 229 I feel like that kind of thing is like like a toddler throwing a tantrum. You know what I mean? Just having a Yeah. Like I don't really I'm like, oh, this is not this is not my problem. This is your problem. negative -0.7 ["frustration", "anger"]
15251 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 230 Door, probably. neutral 0.0 ["contentment"]
15252 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 231 Good morning. positive 0.5 ["joy", "warmth"]
15253 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 232 I do like I saw some of those last night over there and I was like, oh, betty's getting better at making these boxes. positive 0.7 ["joy", "pride"]
15254 Planning Apartment Kitchen Updates and Bankruptcy Logistics 1982eda9-85e4-43fb-ab64-2245df51e403 233 Oh, that's a small. Okay. Okay. And that's a big one. Okay. I like them. I like them. They look great. It's fun. positive 0.6 ["joy", "excitement"]

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);