sentiment_segments
78 rows where conversation_id = "97b37177-b331-40a5-8fa8-ba73b2d315f8"
This data as json, CSV (advanced)
Suggested facets: sentiment, score, emotions, emotions (array)
| id ▼ | conversation_id | segment_index | text | sentiment | score | emotions |
|---|---|---|---|---|---|---|
| 1318 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 266 | Something's going on here. | negative | -0.5 | ["concern"] |
| 1319 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 267 | Mhmm. | neutral | 0.0 | ["contentment"] |
| 1320 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 268 | Oh, we were just chatting about nothing. You know what I mean? | neutral | 0.0 | ["contentment"] |
| 1321 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 269 | That's a wanted my opinion on your mom. I think she's being unrealistic. | negative | -0.5 | ["concern", "frustration"] |
| 1322 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 270 | Just that I think that she's been unrealistic and that I think she has she thinks she has more influence on the outcome than I think she does. That's all. | negative | -0.5 | ["frustration"] |
| 1323 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 271 | Right. | neutral | 0.0 | [] |
| 1324 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 272 | Right. Right. | neutral | 0.0 | [] |
| 1325 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 273 | Right. | neutral | 0.0 | [] |
| 1326 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 274 | Mhmm. | neutral | 0.0 | [] |
| 1327 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 275 | It's great. Right. | positive | 0.7 | ["joy"] |
| 1328 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 276 | Heard that I heard that part where he's like it was it came in they decided not to sell based on this and then I'm out $500. Right. | negative | -0.6 | ["frustration"] |
| 1329 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 277 | Yeah. | neutral | 0.0 | [] |
| 1330 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 278 | That's good to have a second head. | positive | 0.6 | ["contentment"] |
| 1331 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 279 | You can feel more, like, settled in the decisions we make. | positive | 0.5 | ["joy"] |
| 1332 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 280 | What's next on your agenda? | neutral | 0.0 | [] |
| 1333 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 281 | Thanks, Well, I don't feel the same way. I also think you're wonderful, but it's different. | mixed | 0.3 | ["love", "frustration"] |
| 1334 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 282 | I'm pretty sure what I like about you is than what you like about me. But I really really really like you. | positive | 0.8 | ["love", "joy"] |
| 1335 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 283 | Yeah. You just going over the same data over and over and over again. If there's not good comps, there's not good comps. It's just your gut at that point. | negative | -0.4 | ["frustration"] |
| 1336 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 284 | And so you could just go with your gut or you can get some other information, get an appraiser, you can go with five people's guts Well, I'm having Pick the average. Which I'm getting? Like like there isn't more information. There isn't better comps. There isn't a lever you can pull to get closer to you've done He does he does. | neutral | 0.0 | [] |
| 1337 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 285 | What there is to do you have done and there's this huge variance And so what do you do with that? Got a couple of choices. Other people You can get care other can pay someone to give you an opinion and maybe their opinion's better, hopefully it is, but maybe it's not. It might not be. | neutral | 0.0 | [] |
| 1338 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 286 | Right. You could you could you could throw it in front of Nate and Nathaniel and as many people as are willing to take a look at it and just those numbers into a hat and shuffle them around and and, you know, get a urine from them and figure that out that way. But again, it's gonna come down to on some level, I think, here's what I think Katie. On some level, it's a hard problem. You already have a gut opinion. | neutral | 0.0 | [] |
| 1339 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 287 | Sooner or later, you're just gonna go with your gut opinion. Maybe having the appraisal support that which would be nice because then you can be like Or it won't negate it. | neutral | 0.0 | [] |
| 1340 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 288 | And that's I that's a reasonable move. Like, it's for this level of housing, this amount of variance and the amount of money at stake, I think 500 whatever it is, 350. | positive | 0.5 | ["contentment"] |
| 1341 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 289 | Whatever it is. Makes sense. So that's a good choice. Mhmm. | positive | 0.6 | ["contentment"] |
| 1342 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 290 | But you and by extension your parents are looking for more confidence, it's not gonna come. | negative | -0.5 | ["concern"] |
| 1343 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 291 | It will if he shows up at the same level as you. Yeah. If he if he comes in the same numbers you, that will increase the confidence as it should. If he comes at a different number, if he comes up higher, great. Yeah. If he comes up lower, you're you're right. | positive | 0.5 | ["hope"] |
| 1344 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 292 | Between where he Which I guess in both those cases is more confidence than you have now. That's reasonable. But it's still gonna be like you and them are looking for more assurance that you on the right track. | negative | -0.4 | ["concern"] |
| 1345 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 293 | And in this particular case, it's not gonna come other than this appraiser. It's just not gonna come. It's there's just We | negative | -0.5 | ["frustration"] |
| 1346 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 294 | Right. If there's just too much there's too much variation There there's too few comps and too much variation in the price. And so everybody's gonna have their own gut opinion. | negative | -0.6 | ["frustration"] |
| 1347 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 295 | And it's their gut opinion, and it's you know what I mean? If there were if there was more better information somewhere to get that would be the move, but I think there is. | neutral | 0.0 | [] |
| 1348 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 296 | It's an opportunity, but it's irrelevant. | negative | -0.5 | ["frustration"] |
| 1349 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 297 | That's not one you're gonna willing to take because of the fallout Mhmm. Relationship fallout would cost you. Not worth it. | negative | -0.6 | ["concern"] |
| 1350 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 298 | That you've all paid. You have all taken money out of your pockets and paid them for opinions, so you will Got it. | neutral | 0.0 | [] |
| 1351 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 299 | But they also, like, have their own but that's still They they they see you as someone incredibly competent. However, like, there's these are the dynamics at play still. | positive | 0.4 | ["pride"] |
| 1352 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 300 | Just get an appraiser. Yep. Go from there. | neutral | 0.0 | ["contentment"] |
| 1353 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 301 | Material. Right. | neutral | 0.0 | ["contentment"] |
| 1354 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 302 | Important enough and and, like, this is a real situation. This has nothing to do with you. Like Right. I a home that's a Right. An outlier property is a thing Yeah. Where it's hard to value it. | neutral | 0.0 | ["concern"] |
| 1355 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 303 | Because because if you warm up the whole thing, by the time get to the second half, it's cooled off? That's some those are some tight tolerances Katie. | neutral | 0.0 | ["curiosity"] |
| 1356 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 304 | I think that you are exactly as picky as you should be. | positive | 0.5 | ["pride"] |
| 8690 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 266 | Something's going on here. | negative | -0.5 | ["concern"] |
| 8691 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 267 | Mhmm. | neutral | 0.0 | ["contentment"] |
| 8692 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 268 | Oh, we were just chatting about nothing. You know what I mean? | neutral | 0.0 | ["contentment"] |
| 8693 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 269 | That's a wanted my opinion on your mom. I think she's being unrealistic. | negative | -0.5 | ["concern", "frustration"] |
| 8694 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 270 | Just that I think that she's been unrealistic and that I think she has she thinks she has more influence on the outcome than I think she does. That's all. | negative | -0.5 | ["frustration"] |
| 8695 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 271 | Right. | neutral | 0.0 | [] |
| 8696 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 272 | Right. Right. | neutral | 0.0 | [] |
| 8697 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 273 | Right. | neutral | 0.0 | [] |
| 8698 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 274 | Mhmm. | neutral | 0.0 | [] |
| 8699 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 275 | It's great. Right. | positive | 0.7 | ["joy"] |
| 8700 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 276 | Heard that I heard that part where he's like it was it came in they decided not to sell based on this and then I'm out $500. Right. | negative | -0.6 | ["frustration"] |
| 8701 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 277 | Yeah. | neutral | 0.0 | [] |
| 8702 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 278 | That's good to have a second head. | positive | 0.6 | ["contentment"] |
| 8703 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 279 | You can feel more, like, settled in the decisions we make. | positive | 0.5 | ["joy"] |
| 8704 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 280 | What's next on your agenda? | neutral | 0.0 | [] |
| 8705 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 281 | Thanks, Well, I don't feel the same way. I also think you're wonderful, but it's different. | mixed | 0.3 | ["love", "frustration"] |
| 8706 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 282 | I'm pretty sure what I like about you is than what you like about me. But I really really really like you. | positive | 0.8 | ["love", "joy"] |
| 8707 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 283 | Yeah. You just going over the same data over and over and over again. If there's not good comps, there's not good comps. It's just your gut at that point. | negative | -0.4 | ["frustration"] |
| 8708 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 284 | And so you could just go with your gut or you can get some other information, get an appraiser, you can go with five people's guts Well, I'm having Pick the average. Which I'm getting? Like like there isn't more information. There isn't better comps. There isn't a lever you can pull to get closer to you've done He does he does. | neutral | 0.0 | [] |
| 8709 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 285 | What there is to do you have done and there's this huge variance And so what do you do with that? Got a couple of choices. Other people You can get care other can pay someone to give you an opinion and maybe their opinion's better, hopefully it is, but maybe it's not. It might not be. | neutral | 0.0 | [] |
| 8710 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 286 | Right. You could you could you could throw it in front of Nate and Nathaniel and as many people as are willing to take a look at it and just those numbers into a hat and shuffle them around and and, you know, get a urine from them and figure that out that way. But again, it's gonna come down to on some level, I think, here's what I think Katie. On some level, it's a hard problem. You already have a gut opinion. | neutral | 0.0 | [] |
| 8711 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 287 | Sooner or later, you're just gonna go with your gut opinion. Maybe having the appraisal support that which would be nice because then you can be like Or it won't negate it. | neutral | 0.0 | [] |
| 8712 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 288 | And that's I that's a reasonable move. Like, it's for this level of housing, this amount of variance and the amount of money at stake, I think 500 whatever it is, 350. | positive | 0.5 | ["contentment"] |
| 8713 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 289 | Whatever it is. Makes sense. So that's a good choice. Mhmm. | positive | 0.6 | ["contentment"] |
| 8714 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 290 | But you and by extension your parents are looking for more confidence, it's not gonna come. | negative | -0.5 | ["concern"] |
| 8715 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 291 | It will if he shows up at the same level as you. Yeah. If he if he comes in the same numbers you, that will increase the confidence as it should. If he comes at a different number, if he comes up higher, great. Yeah. If he comes up lower, you're you're right. | positive | 0.5 | ["hope"] |
| 8716 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 292 | Between where he Which I guess in both those cases is more confidence than you have now. That's reasonable. But it's still gonna be like you and them are looking for more assurance that you on the right track. | negative | -0.4 | ["concern"] |
| 8717 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 293 | And in this particular case, it's not gonna come other than this appraiser. It's just not gonna come. It's there's just We | negative | -0.5 | ["frustration"] |
| 8718 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 294 | Right. If there's just too much there's too much variation There there's too few comps and too much variation in the price. And so everybody's gonna have their own gut opinion. | negative | -0.6 | ["frustration"] |
| 8719 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 295 | And it's their gut opinion, and it's you know what I mean? If there were if there was more better information somewhere to get that would be the move, but I think there is. | neutral | 0.0 | [] |
| 8720 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 296 | It's an opportunity, but it's irrelevant. | negative | -0.5 | ["frustration"] |
| 8721 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 297 | That's not one you're gonna willing to take because of the fallout Mhmm. Relationship fallout would cost you. Not worth it. | negative | -0.6 | ["concern"] |
| 8722 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 298 | That you've all paid. You have all taken money out of your pockets and paid them for opinions, so you will Got it. | neutral | 0.0 | [] |
| 8723 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 299 | But they also, like, have their own but that's still They they they see you as someone incredibly competent. However, like, there's these are the dynamics at play still. | positive | 0.4 | ["pride"] |
| 8724 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 300 | Just get an appraiser. Yep. Go from there. | neutral | 0.0 | ["contentment"] |
| 8725 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 301 | Material. Right. | neutral | 0.0 | ["contentment"] |
| 8726 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 302 | Important enough and and, like, this is a real situation. This has nothing to do with you. Like Right. I a home that's a Right. An outlier property is a thing Yeah. Where it's hard to value it. | neutral | 0.0 | ["concern"] |
| 8727 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 303 | Because because if you warm up the whole thing, by the time get to the second half, it's cooled off? That's some those are some tight tolerances Katie. | neutral | 0.0 | ["curiosity"] |
| 8728 | Jake and Katie Decide To Hire an Appraiser 97b37177-b331-40a5-8fa8-ba73b2d315f8 | 304 | I think that you are exactly as picky as you should be. | positive | 0.5 | ["pride"] |
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);