sentiment_segments

24 rows where conversation_id = "0f965216-9b33-4348-81f2-883376faa959"

✎ 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
2619 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 142 Do you want me to go do that? K. Did you bring the Chaparin back in. Do you want me to do that too? Okay. neutral 0.0 ["curiosity"]
2620 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 143 Oh, yeah. Yeah. positive 0.5 ["joy"]
2621 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 144 I'll call you when I get there if I can't find it. Like, I'll look on the table one if you in your in your room on the nightstand. neutral 0.0 ["concern"]
2622 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 145 If it's not there, I'll call you. neutral 0.0 ["contentment"]
2623 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 146 I drove by chaperone today, and I was almost so I was going to the orthodontist, and I almost stopped and did him. Should have. positive 0.6 ["excitement"]
2624 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 147 It's my main seven eight. M y m e a n. Seven eight. neutral 0.0 ["curiosity"]
2625 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 148 My Mean 78. neutral 0.0 ["contentment"]
2626 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 149 Mhmm. M y m e a n. $8 case. neutral 0.0 ["contentment"]
2627 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 150 My mean $7.08. neutral 0.0 ["contentment"]
2628 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 151 It's a it's you're you're gonna hate you're gonna I don't wanna tell you. It's a line for my patriarchal blessing. negative -0.5 ["frustration", "anxiety"]
2629 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 152 It's been my password since I was 16 years old. neutral 0.0 ["nostalgia"]
2630 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 153 78 is just because 7 because neutral 0.0 ["curiosity"]
9991 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 142 Do you want me to go do that? K. Did you bring the Chaparin back in. Do you want me to do that too? Okay. neutral 0.0 ["curiosity"]
9992 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 143 Oh, yeah. Yeah. positive 0.5 ["joy"]
9993 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 144 I'll call you when I get there if I can't find it. Like, I'll look on the table one if you in your in your room on the nightstand. neutral 0.0 ["concern"]
9994 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 145 If it's not there, I'll call you. neutral 0.0 ["contentment"]
9995 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 146 I drove by chaperone today, and I was almost so I was going to the orthodontist, and I almost stopped and did him. Should have. positive 0.6 ["excitement"]
9996 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 147 It's my main seven eight. M y m e a n. Seven eight. neutral 0.0 ["curiosity"]
9997 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 148 My Mean 78. neutral 0.0 ["contentment"]
9998 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 149 Mhmm. M y m e a n. $8 case. neutral 0.0 ["contentment"]
9999 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 150 My mean $7.08. neutral 0.0 ["contentment"]
10000 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 151 It's a it's you're you're gonna hate you're gonna I don't wanna tell you. It's a line for my patriarchal blessing. negative -0.5 ["frustration", "anxiety"]
10001 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 152 It's been my password since I was 16 years old. neutral 0.0 ["nostalgia"]
10002 Family Chat About Passwords And Errands 0f965216-9b33-4348-81f2-883376faa959 153 78 is just because 7 because 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);