sentiment_segments
8 rows where conversation_id = "15affac1-294a-4eac-afae-2279aeb312f1"
This data as json, CSV (advanced)
Suggested facets: segment_index, text, emotions, emotions (array)
| id ▼ | conversation_id | segment_index | text | sentiment | score | emotions |
|---|---|---|---|---|---|---|
| 3086 | Call About Missed House Showing 15affac1-294a-4eac-afae-2279aeb312f1 | 0 | Hey. Did anyone come to see the house? No. Have have you been there the whole time since we were there? | neutral | 0.0 | ["contentment"] |
| 3087 | Call About Missed House Showing 15affac1-294a-4eac-afae-2279aeb312f1 | 1 | Okay. Okay. There was like a last minute showing request and I approved it and then I totally forgot about it. It was supposed to be between like 04:15 and five. | neutral | 0.0 | ["curiosity"] |
| 3088 | Call About Missed House Showing 15affac1-294a-4eac-afae-2279aeb312f1 | 2 | Anyway, if they didn't come, they didn't come, that's fine. So k. I just thought if you were there, you'd know if anyway. Alright. That's yeah. K. K. Cool. Thank you. | neutral | 0.0 | ["contentment"] |
| 3089 | Call About Missed House Showing 15affac1-294a-4eac-afae-2279aeb312f1 | 3 | Problem. Alright. See you. Talk to you later. | neutral | 0.0 | ["contentment"] |
| 10458 | Call About Missed House Showing 15affac1-294a-4eac-afae-2279aeb312f1 | 0 | Hey. Did anyone come to see the house? No. Have have you been there the whole time since we were there? | neutral | 0.0 | ["contentment"] |
| 10459 | Call About Missed House Showing 15affac1-294a-4eac-afae-2279aeb312f1 | 1 | Okay. Okay. There was like a last minute showing request and I approved it and then I totally forgot about it. It was supposed to be between like 04:15 and five. | neutral | 0.0 | ["curiosity"] |
| 10460 | Call About Missed House Showing 15affac1-294a-4eac-afae-2279aeb312f1 | 2 | Anyway, if they didn't come, they didn't come, that's fine. So k. I just thought if you were there, you'd know if anyway. Alright. That's yeah. K. K. Cool. Thank you. | neutral | 0.0 | ["contentment"] |
| 10461 | Call About Missed House Showing 15affac1-294a-4eac-afae-2279aeb312f1 | 3 | Problem. Alright. See you. Talk to you later. | neutral | 0.0 | ["contentment"] |
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);