sentiment_segments

52 rows where conversation_id = "27a11426-8e6f-4c4b-8ed1-1daf6cf64a18"

✎ 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
22 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 21 I don't know where you're at, buddy. I need to talk to you about Katie sometime. I don't know if you if you know it. I totally understand. I totally understand. neutral 0.0 []
23 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 22 I love her. I have no interest in throwing her into the bus, but I could sure use some insight from somebody who knows her really well. positive 0.5 ["love", "hope"]
24 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 23 Over to her. If if you. I see the weight on her. I hear the love in your voice. I don't care. I see the way you care for her. positive 0.6 ["empathy", "love"]
25 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 24 I think you are a good man. positive 0.5 ["pride"]
26 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 25 I think you are a good man. positive 0.5 ["pride"]
27 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 26 Not even a hit in resentment. neutral 0.0 []
28 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 27 I hear the affection in your voice. positive 0.6 ["empathy", "love"]
29 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 28 I don't know, mas eu quero ver. She's amazing. She's beautiful. She's beautiful. Delight fun, brilliant, driven. positive 0.7 ["joy", "admiration"]
30 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 29 She's She's amazing. And just crushing my soul. She's crushing my soul. She's crushing me. I do need to feed my mind. And I will. Here's the thing. I will. negative -0.7 ["sadness", "frustration"]
31 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 30 I will. This this period, this high atus, I have given myself permission to not freak out. She wants me to freak out. I haven't given myself permission to not freak out. neutral 0.0 ["contentment"]
32 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 31 This is the homework I think I settled into. The appointment and emerge. With the capacity, my gifts, neutral 0.0 ["curiosity"]
33 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 32 I need time and I need the failure. I need the failure and the humiliation and the I need it. At least. Some part of my intuition is whispering this to me. mixed -0.5 ["frustration", "anxiety", "determination"]
34 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 33 Or maybe I'm just neutral 0.0 []
35 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 34 I can't explain this to her. She's got guilty of her. Finances, but there's a reason. negative -0.5 ["guilt", "concern"]
36 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 35 I'm doing it now. My soul is my soul is whispering something to me that is a reason. I thought it was about timing. Software is transitioning. Software developing software is completely changing. neutral 0.0 ["curiosity"]
37 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 36 My old skills are worthless, are going to soon be worthless. negative -0.7 ["fear", "frustration"]
38 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 37 Painfully, could be us. This could be us. Hand and only us, And what came before wouldn't count any moral matter. mixed -0.3 ["sadness", "hope"]
39 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 38 What a it's you? What if it's me? neutral 0.0 ["curiosity"]
40 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 39 So the world falls away. What do you say? neutral 0.0 []
41 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 40 Gross. Gross. negative -0.8 ["disgust"]
42 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 41 Making any sense for my world. You know where eating I'm saying makes for. I have my own ass. She's they need to invest in her. negative -0.6 ["frustration", "confusion"]
43 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 42 This way. neutral 0.0 []
44 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 43 Hi. I get five? Absolutely. positive 0.5 ["joy"]
45 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 44 What do you say? neutral 0.0 []
46 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 45 You and I are not you and Jack. Some tensions negative -0.4 ["frustration", "concern"]
47 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 46 But it isn't. But it isn't. It isn't. negative -0.5 ["resignation"]
7394 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 21 I don't know where you're at, buddy. I need to talk to you about Katie sometime. I don't know if you if you know it. I totally understand. I totally understand. neutral 0.0 []
7395 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 22 I love her. I have no interest in throwing her into the bus, but I could sure use some insight from somebody who knows her really well. positive 0.5 ["love", "hope"]
7396 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 23 Over to her. If if you. I see the weight on her. I hear the love in your voice. I don't care. I see the way you care for her. positive 0.6 ["empathy", "love"]
7397 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 24 I think you are a good man. positive 0.5 ["pride"]
7398 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 25 I think you are a good man. positive 0.5 ["pride"]
7399 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 26 Not even a hit in resentment. neutral 0.0 []
7400 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 27 I hear the affection in your voice. positive 0.6 ["empathy", "love"]
7401 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 28 I don't know, mas eu quero ver. She's amazing. She's beautiful. She's beautiful. Delight fun, brilliant, driven. positive 0.7 ["joy", "admiration"]
7402 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 29 She's She's amazing. And just crushing my soul. She's crushing my soul. She's crushing me. I do need to feed my mind. And I will. Here's the thing. I will. negative -0.7 ["sadness", "frustration"]
7403 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 30 I will. This this period, this high atus, I have given myself permission to not freak out. She wants me to freak out. I haven't given myself permission to not freak out. neutral 0.0 ["contentment"]
7404 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 31 This is the homework I think I settled into. The appointment and emerge. With the capacity, my gifts, neutral 0.0 ["curiosity"]
7405 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 32 I need time and I need the failure. I need the failure and the humiliation and the I need it. At least. Some part of my intuition is whispering this to me. mixed -0.5 ["frustration", "anxiety", "determination"]
7406 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 33 Or maybe I'm just neutral 0.0 []
7407 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 34 I can't explain this to her. She's got guilty of her. Finances, but there's a reason. negative -0.5 ["guilt", "concern"]
7408 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 35 I'm doing it now. My soul is my soul is whispering something to me that is a reason. I thought it was about timing. Software is transitioning. Software developing software is completely changing. neutral 0.0 ["curiosity"]
7409 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 36 My old skills are worthless, are going to soon be worthless. negative -0.7 ["fear", "frustration"]
7410 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 37 Painfully, could be us. This could be us. Hand and only us, And what came before wouldn't count any moral matter. mixed -0.3 ["sadness", "hope"]
7411 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 38 What a it's you? What if it's me? neutral 0.0 ["curiosity"]
7412 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 39 So the world falls away. What do you say? neutral 0.0 []
7413 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 40 Gross. Gross. negative -0.8 ["disgust"]
7414 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 41 Making any sense for my world. You know where eating I'm saying makes for. I have my own ass. She's they need to invest in her. negative -0.6 ["frustration", "confusion"]
7415 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 42 This way. neutral 0.0 []
7416 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 43 Hi. I get five? Absolutely. positive 0.5 ["joy"]
7417 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 44 What do you say? neutral 0.0 []
7418 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 45 You and I are not you and Jack. Some tensions negative -0.4 ["frustration", "concern"]
7419 Reflections On Relationship With Katie 27a11426-8e6f-4c4b-8ed1-1daf6cf64a18 46 But it isn't. But it isn't. It isn't. negative -0.5 ["resignation"]

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);