sentiment_segments
30 rows where conversation_id = "0919c959-e1a0-4f18-971c-e0a2c49fb8ce"
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 |
|---|---|---|---|---|---|---|
| 2715 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 70 | This is barbaric behavior that cannot be tolerant. | negative | -0.7 | ["anger"] |
| 2716 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 71 | Do take time. No. | neutral | 0.0 | ["resignation"] |
| 2717 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 72 | Now I know Scott Sterling. Wait. That was pretty good. | positive | 0.5 | ["joy"] |
| 2718 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 73 | Oh, yeah. | positive | 0.6 | ["joy"] |
| 2719 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 74 | That'd be fun. | positive | 0.5 | ["excitement"] |
| 2720 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 75 | Is that yours, Bethy? Yeah. This. This? Yeah. | neutral | 0.0 | ["curiosity"] |
| 2721 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 76 | Is it good? | neutral | 0.0 | ["curiosity"] |
| 2722 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 77 | What did you think of the food? Have you ever have you ever had chicken teriyaki before? No. What'd you think of it? It's really good. You liked it? | positive | 0.7 | ["joy"] |
| 2723 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 78 | John? Have you ever had that? Sweet and sour chicken before? What'd you think of it? Yeah. | positive | 0.6 | ["joy"] |
| 2724 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 79 | I can see that. Is it compacting or is it just expanding back out as you it down? | neutral | 0.0 | ["curiosity"] |
| 2725 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 80 | I like to hear it. | positive | 0.5 | ["empathy"] |
| 2726 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 81 | It. I'll take the I'll take no credit for all of that. That's good. | positive | 0.5 | ["gratitude"] |
| 2727 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 82 | Oh, let me help you out with that. | positive | 0.6 | ["empathy"] |
| 2728 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 83 | This is another Do you guys wanna watch these games for a few minutes? Mom's gonna be home in a few minutes. I'm gonna take you guys. We'll leave in, like, half an hour. | positive | 0.7 | ["excitement"] |
| 2729 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 84 | Does that work? Okay. | neutral | 0.0 | ["curiosity"] |
| 10087 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 70 | This is barbaric behavior that cannot be tolerant. | negative | -0.7 | ["anger"] |
| 10088 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 71 | Do take time. No. | neutral | 0.0 | ["resignation"] |
| 10089 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 72 | Now I know Scott Sterling. Wait. That was pretty good. | positive | 0.5 | ["joy"] |
| 10090 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 73 | Oh, yeah. | positive | 0.6 | ["joy"] |
| 10091 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 74 | That'd be fun. | positive | 0.5 | ["excitement"] |
| 10092 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 75 | Is that yours, Bethy? Yeah. This. This? Yeah. | neutral | 0.0 | ["curiosity"] |
| 10093 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 76 | Is it good? | neutral | 0.0 | ["curiosity"] |
| 10094 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 77 | What did you think of the food? Have you ever have you ever had chicken teriyaki before? No. What'd you think of it? It's really good. You liked it? | positive | 0.7 | ["joy"] |
| 10095 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 78 | John? Have you ever had that? Sweet and sour chicken before? What'd you think of it? Yeah. | positive | 0.6 | ["joy"] |
| 10096 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 79 | I can see that. Is it compacting or is it just expanding back out as you it down? | neutral | 0.0 | ["curiosity"] |
| 10097 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 80 | I like to hear it. | positive | 0.5 | ["empathy"] |
| 10098 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 81 | It. I'll take the I'll take no credit for all of that. That's good. | positive | 0.5 | ["gratitude"] |
| 10099 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 82 | Oh, let me help you out with that. | positive | 0.6 | ["empathy"] |
| 10100 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 83 | This is another Do you guys wanna watch these games for a few minutes? Mom's gonna be home in a few minutes. I'm gonna take you guys. We'll leave in, like, half an hour. | positive | 0.7 | ["excitement"] |
| 10101 | Family Dinner, Jokes, And Getting Ready To Leave 0919c959-e1a0-4f18-971c-e0a2c49fb8ce | 84 | Does that work? Okay. | neutral | 0.0 | ["curiosity"] |
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);