sentiment_segments

14 rows where conversation_id = "0990cd0e-a1e6-4ad0-aca1-4e64a77b9c47"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: sentiment, score, emotions, emotions (array)

id ▼ conversation_id segment_index text sentiment score emotions
13871 Friends Discuss Family, Judgment, And Acceptance 0990cd0e-a1e6-4ad0-aca1-4e64a77b9c47 125 Oh, I meant to pay for the three of you. Some money. positive 0.5 ["gratitude"]
13872 Friends Discuss Family, Judgment, And Acceptance 0990cd0e-a1e6-4ad0-aca1-4e64a77b9c47 126 Your rental Mhmm. neutral 0.0 ["contentment"]
13873 Friends Discuss Family, Judgment, And Acceptance 0990cd0e-a1e6-4ad0-aca1-4e64a77b9c47 127 So they bought they were living in another house in the holiday area. And then they got that as a rental. And then the market fell apart in, like, 2008. And they were upside down in the house that they were living in. And so they Where like, short sold the house they were in and then moved into that one. neutral 0.0 ["nostalgia"]
13874 Friends Discuss Family, Judgment, And Acceptance 0990cd0e-a1e6-4ad0-aca1-4e64a77b9c47 128 Where where where But at the time when they first got it, it was going great. I mean, yeah. Everything was going great. Right? positive 0.5 ["joy"]
13875 Friends Discuss Family, Judgment, And Acceptance 0990cd0e-a1e6-4ad0-aca1-4e64a77b9c47 129 They are nice. I think so too. They're pretty chill. So easy. Open They're open open to people. So they don't have a lot of, like, positive 0.5 ["joy", "contentment"]
13876 Friends Discuss Family, Judgment, And Acceptance 0990cd0e-a1e6-4ad0-aca1-4e64a77b9c47 130 They're not that critical. You know what I mean? Like, they're not looking at, She could point to Yeah. positive 0.5 ["joy"]
13877 Friends Discuss Family, Judgment, And Acceptance 0990cd0e-a1e6-4ad0-aca1-4e64a77b9c47 131 They're like, oh, this is somebody that somebody new we can be friends with. You know what I mean? Like, that's that's their approach. positive 0.5 ["joy", "connection"]
13878 Friends Discuss Family, Judgment, And Acceptance 0990cd0e-a1e6-4ad0-aca1-4e64a77b9c47 132 Like They don't have they don't have like, a real strong agenda for me either. You know what I mean? Like, they don't need me to do certain things to make them feel okay. You know? positive 0.5 ["joy", "contentment"]
13879 Friends Discuss Family, Judgment, And Acceptance 0990cd0e-a1e6-4ad0-aca1-4e64a77b9c47 133 And so or, like, they're not worried about how is this gonna look for me with my friend. Yeah. There's nothing Yeah. There's none of any of that. positive 0.5 ["joy"]
13880 Friends Discuss Family, Judgment, And Acceptance 0990cd0e-a1e6-4ad0-aca1-4e64a77b9c47 134 Right. So, like, there's not they have no real reason to be like you know, critical. Looking for problems. positive 0.5 ["joy"]
13881 Friends Discuss Family, Judgment, And Acceptance 0990cd0e-a1e6-4ad0-aca1-4e64a77b9c47 135 I can tell you what Jesus says about that. So, he says, those are judgments. And we put judgments in boxes. neutral 0.0 ["curiosity"]
13882 Friends Discuss Family, Judgment, And Acceptance 0990cd0e-a1e6-4ad0-aca1-4e64a77b9c47 136 Like for me specifically? No. I just I don't really know. I don't have an answer for you. That's just what popped in my head first. neutral 0.0 ["confusion"]
13883 Friends Discuss Family, Judgment, And Acceptance 0990cd0e-a1e6-4ad0-aca1-4e64a77b9c47 137 Like like you were like quit that. Stop whatever it is you're doing. I hate it. negative -0.5 ["frustration"]
13884 Friends Discuss Family, Judgment, And Acceptance 0990cd0e-a1e6-4ad0-aca1-4e64a77b9c47 138 Yeah. neutral 0.0 ["contentment"]

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