home / saraphina

sentiment_segments

30 rows where conversation_id = "929c6034-2583-46ec-a8c2-f7d03cb6407d"

✎ 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
2918 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 154 Really? Yes. Because, like, what what what did they like what did it take for you to block him? neutral 0.0 ["concern"]
2919 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 155 Like through the Facebook phone call? neutral 0.0 ["curiosity"]
2920 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 156 That's ridiculous. negative -0.5 ["frustration"]
2921 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 157 He shouldn't have even called once unless you, like, gave him a reason to think that was okay. negative -0.5 ["anger"]
2922 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 158 But like, ugh. Yeah. I like that at all. But you also got one. So I Okay. You also got one, like, actual interest in party. Right? Or at least Yeah. Theoretically. neutral 0.0 ["confusion"]
2923 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 159 Is it worth it? neutral 0.0 ["curiosity"]
2924 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 160 No. That's kinda what I would have guessed, but I'm asking because I wanna show it. neutral 0.0 ["determination"]
2925 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 161 Yeah. neutral 0.0 ["contentment"]
2926 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 162 Right? Right. Oh, it's good. It is good. You're getting closer to where you wanna be. Yeah. Absolutely. positive 0.5 ["joy", "hope"]
2927 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 163 That's how you roll, Katie. positive 0.5 ["pride"]
2928 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 164 Why is this not working? negative -0.5 ["frustration"]
2929 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 165 K. Hold on just a second. neutral 0.0 ["anxiety"]
2930 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 166 Trying to be in respond to somebody that texted me today at two, and I've ignored them all day long. negative -0.5 ["guilt"]
2931 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 167 Yeah. This was like one day neutral 0.0 ["resignation"]
2932 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 168 And you like something whichever was that for? neutral 0.0 ["curiosity"]
10290 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 154 Really? Yes. Because, like, what what what did they like what did it take for you to block him? neutral 0.0 ["concern"]
10291 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 155 Like through the Facebook phone call? neutral 0.0 ["curiosity"]
10292 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 156 That's ridiculous. negative -0.5 ["frustration"]
10293 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 157 He shouldn't have even called once unless you, like, gave him a reason to think that was okay. negative -0.5 ["anger"]
10294 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 158 But like, ugh. Yeah. I like that at all. But you also got one. So I Okay. You also got one, like, actual interest in party. Right? Or at least Yeah. Theoretically. neutral 0.0 ["confusion"]
10295 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 159 Is it worth it? neutral 0.0 ["curiosity"]
10296 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 160 No. That's kinda what I would have guessed, but I'm asking because I wanna show it. neutral 0.0 ["determination"]
10297 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 161 Yeah. neutral 0.0 ["contentment"]
10298 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 162 Right? Right. Oh, it's good. It is good. You're getting closer to where you wanna be. Yeah. Absolutely. positive 0.5 ["joy", "hope"]
10299 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 163 That's how you roll, Katie. positive 0.5 ["pride"]
10300 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 164 Why is this not working? negative -0.5 ["frustration"]
10301 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 165 K. Hold on just a second. neutral 0.0 ["anxiety"]
10302 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 166 Trying to be in respond to somebody that texted me today at two, and I've ignored them all day long. negative -0.5 ["guilt"]
10303 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 167 Yeah. This was like one day neutral 0.0 ["resignation"]
10304 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d 168 And you like something whichever was that for? 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.226ms