home / saraphina

sentiment_segments

38 rows where conversation_id = "05b59f9e-119e-4743-947b-3f651d885e83"

✎ 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
6200 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 0 Where'd they have you go? neutral 0.0 ["curiosity"]
6201 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 1 Are these the other sprinters? neutral 0.0 ["curiosity"]
6202 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 2 How come they're sprinting then? neutral 0.0 ["curiosity"]
6203 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 3 You guys were you guys were lifting weights? How long did you lift weights for? A mile. Was it good? Did you feel good? neutral 0.0 ["curiosity"]
6204 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 4 Okay. neutral 0.0 ["contentment"]
6205 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 5 What were they? neutral 0.0 ["curiosity"]
6206 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 6 K. neutral 0.0 ["neutral"]
6207 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 7 Okay. Okay. Cool. positive 0.5 ["contentment", "joy"]
6208 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 8 A notion in between everything, yourself, and home. You must be somewhere in London. neutral 0.0 ["curiosity"]
6209 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 9 Like a lot of bolt enough that it mismatch the body and shine. neutral 0.0 ["confusion"]
6210 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 10 That's too bad, but That the sage could hear the entire thing. Yeah. And she looked like visibly upset after the And you wanted to, like, say something, weren't sure what to do? Yeah. negative -0.5 ["frustration", "concern"]
6211 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 11 I'm like, yeah. You definitely should say something. I mean, you don't have to, like, tell him off. Right? He's your friend. But, like, I think I think I think him knowing you don't like that is worth is worth something. Yeah. positive 0.5 ["empathy", "support"]
6212 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 12 I was angry at first. Was probably better to just be like, You could also could you could talk to Sage and be like, I thought you were good? negative -0.5 ["anger", "frustration"]
6213 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 13 Maybe. neutral 0.0 ["uncertainty"]
6214 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 14 Dad Yeah. Are we going to your house? Yes. Okay. I know for how long, but yes. Let me see if I've seen a text from home. I think I have. No. neutral 0.0 ["neutral"]
6215 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 15 Other than yet. neutral 0.0 ["neutral"]
6216 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 16 What a notion that a river between everything yourself and home You must be somewhere in London. You must be loving your life in praying. neutral 0.0 ["curiosity"]
6217 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 17 You must be somewhere in London. Walking every lane. I don't even think to make I don't even think to make. I don't even think to make corrections. neutral 0.0 ["confusion"]
6218 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 18 What is he arrest with? How do you know him? Okay. neutral 0.0 ["curiosity"]
12722 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 0 Where'd they have you go? neutral 0.0 ["curiosity"]
12723 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 1 Are these the other sprinters? neutral 0.0 ["curiosity"]
12724 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 2 How come they're sprinting then? neutral 0.0 ["curiosity"]
12725 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 3 You guys were you guys were lifting weights? How long did you lift weights for? A mile. Was it good? Did you feel good? neutral 0.0 ["curiosity"]
12726 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 4 Okay. neutral 0.0 ["contentment"]
12727 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 5 What were they? neutral 0.0 ["curiosity"]
12728 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 6 K. neutral 0.0 ["neutral"]
12729 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 7 Okay. Okay. Cool. positive 0.5 ["contentment", "joy"]
12730 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 8 A notion in between everything, yourself, and home. You must be somewhere in London. neutral 0.0 ["curiosity"]
12731 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 9 Like a lot of bolt enough that it mismatch the body and shine. neutral 0.0 ["confusion"]
12732 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 10 That's too bad, but That the sage could hear the entire thing. Yeah. And she looked like visibly upset after the And you wanted to, like, say something, weren't sure what to do? Yeah. negative -0.5 ["frustration", "concern"]
12733 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 11 I'm like, yeah. You definitely should say something. I mean, you don't have to, like, tell him off. Right? He's your friend. But, like, I think I think I think him knowing you don't like that is worth is worth something. Yeah. positive 0.5 ["empathy", "support"]
12734 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 12 I was angry at first. Was probably better to just be like, You could also could you could talk to Sage and be like, I thought you were good? negative -0.5 ["anger", "frustration"]
12735 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 13 Maybe. neutral 0.0 ["uncertainty"]
12736 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 14 Dad Yeah. Are we going to your house? Yes. Okay. I know for how long, but yes. Let me see if I've seen a text from home. I think I have. No. neutral 0.0 ["neutral"]
12737 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 15 Other than yet. neutral 0.0 ["neutral"]
12738 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 16 What a notion that a river between everything yourself and home You must be somewhere in London. You must be loving your life in praying. neutral 0.0 ["curiosity"]
12739 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 17 You must be somewhere in London. Walking every lane. I don't even think to make I don't even think to make. I don't even think to make corrections. neutral 0.0 ["confusion"]
12740 Parent and Child Talk About Track, Friends, Music 05b59f9e-119e-4743-947b-3f651d885e83 18 What is he arrest with? How do you know him? 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 5.24ms