sentiment_segments
20 rows where conversation_id = "07866012-8053-4a65-a186-0e3bda935bc7"
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 |
|---|---|---|---|---|---|---|
| 2943 | Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 | 10 | Memphis barbecue chicken. Does that sound right? Okay. | neutral | 0.0 | [] |
| 2944 | Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 | 11 | We're just working on it. Might be Extra cheese on those? | neutral | 0.0 | [] |
| 2945 | Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 | 12 | On much. The barbecue chicken ones? It doesn't say how much it is. It doesn't say how much it is. | neutral | 0.0 | [] |
| 2946 | Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 | 13 | Oh, these are large. That's not what we wanted. We wanted mediums. Right? | neutral | 0.0 | [] |
| 2947 | Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 | 14 | Those those so just getting a barbecue. I need to find a deal. On those because those are like 25 a piece the way I order ordered them. That's too much. But I I'm sure I can I can sure I get them? | negative | -0.5 | ["frustration"] |
| 2948 | Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 | 15 | Maybe in a little bit. I don't know. And generically, yes, but right this minute, no. | neutral | 0.0 | [] |
| 2949 | Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 | 16 | What's What's your likely one ranches? Ranches? | neutral | 0.0 | [] |
| 2950 | Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 | 17 | I can't hear what you're saying. | neutral | 0.0 | ["frustration"] |
| 2951 | Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 | 18 | Most likely? I don't know. Either Cafe Rio or Domino's, think. | neutral | 0.0 | [] |
| 2952 | Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 | 19 | A little bit. | neutral | 0.0 | [] |
| 10315 | Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 | 10 | Memphis barbecue chicken. Does that sound right? Okay. | neutral | 0.0 | [] |
| 10316 | Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 | 11 | We're just working on it. Might be Extra cheese on those? | neutral | 0.0 | [] |
| 10317 | Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 | 12 | On much. The barbecue chicken ones? It doesn't say how much it is. It doesn't say how much it is. | neutral | 0.0 | [] |
| 10318 | Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 | 13 | Oh, these are large. That's not what we wanted. We wanted mediums. Right? | neutral | 0.0 | [] |
| 10319 | Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 | 14 | Those those so just getting a barbecue. I need to find a deal. On those because those are like 25 a piece the way I order ordered them. That's too much. But I I'm sure I can I can sure I get them? | negative | -0.5 | ["frustration"] |
| 10320 | Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 | 15 | Maybe in a little bit. I don't know. And generically, yes, but right this minute, no. | neutral | 0.0 | [] |
| 10321 | Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 | 16 | What's What's your likely one ranches? Ranches? | neutral | 0.0 | [] |
| 10322 | Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 | 17 | I can't hear what you're saying. | neutral | 0.0 | ["frustration"] |
| 10323 | Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 | 18 | Most likely? I don't know. Either Cafe Rio or Domino's, think. | neutral | 0.0 | [] |
| 10324 | Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 | 19 | A little bit. | neutral | 0.0 | [] |
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);