home / saraphina

sentiment_segments

30 rows where conversation_id = "0919c959-e1a0-4f18-971c-e0a2c49fb8ce"

✎ View and edit SQL

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

CSV options:

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);
Powered by Datasette · Queries took 4.773ms