sentiment_segments
13 rows where conversation_id = "b69946f0-2713-413e-a538-7d3aa9314428"
This data as json, CSV (advanced)
Suggested facets: text, emotions (array)
| id ▼ | conversation_id | segment_index | text | sentiment | score | emotions |
|---|---|---|---|---|---|---|
| 14129 | Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 | 130 | Dad. What? Sorry. | neutral | 0.0 | ["contentment"] |
| 14130 | Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 | 131 | Yeah. | neutral | 0.0 | ["contentment"] |
| 14131 | Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 | 132 | A minute. | neutral | 0.0 | ["contentment"] |
| 14132 | Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 | 133 | Okay. | neutral | 0.0 | ["contentment"] |
| 14133 | Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 | 134 | Yeah. Yeah. | neutral | 0.0 | ["contentment"] |
| 14134 | Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 | 135 | I would've I should've sent you a message anyway. | neutral | 0.0 | ["contentment"] |
| 14135 | Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 | 136 | Okay. | neutral | 0.0 | ["contentment"] |
| 14136 | Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 | 137 | Okay. Okay. | neutral | 0.0 | ["contentment"] |
| 14137 | Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 | 138 | Yeah. Yeah. | neutral | 0.0 | ["contentment"] |
| 14138 | Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 | 139 | Yep. | neutral | 0.0 | ["contentment"] |
| 14139 | Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 | 140 | Okay. | neutral | 0.0 | ["contentment"] |
| 14140 | Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 | 141 | You know, I don't need anything. | neutral | 0.0 | ["contentment"] |
| 14141 | Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 | 142 | Okay. | 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);