sentiment_segments
12 rows where conversation_id = "61fe85ec-7843-4bfd-a85d-1776ac9490ad"
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 |
|---|---|---|---|---|---|---|
| 2321 | Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad | 0 | I'm 47 years old. | neutral | 0.0 | ["contentment"] |
| 2322 | Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad | 1 | I live in South Jordan, Utah. | neutral | 0.0 | ["contentment"] |
| 2323 | Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad | 2 | I am a software developer. | neutral | 0.0 | ["contentment"] |
| 2324 | Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad | 3 | To become rich and famous. | positive | 0.5 | ["hope", "joy"] |
| 2325 | Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad | 4 | This month I need to get a new job. | neutral | 0.0 | ["concern"] |
| 2326 | Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad | 5 | Today, we're gonna eat some burritos and go do a climbing go to a climbing gym. | positive | 0.6 | ["joy", "excitement"] |
| 9693 | Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad | 0 | I'm 47 years old. | neutral | 0.0 | ["contentment"] |
| 9694 | Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad | 1 | I live in South Jordan, Utah. | neutral | 0.0 | ["contentment"] |
| 9695 | Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad | 2 | I am a software developer. | neutral | 0.0 | ["contentment"] |
| 9696 | Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad | 3 | To become rich and famous. | positive | 0.5 | ["hope", "joy"] |
| 9697 | Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad | 4 | This month I need to get a new job. | neutral | 0.0 | ["concern"] |
| 9698 | Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad | 5 | Today, we're gonna eat some burritos and go do a climbing go to a climbing gym. | positive | 0.6 | ["joy", "excitement"] |
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);