sentiment_segments

22 rows where conversation_id = "17623cdc-f551-4332-a8a8-4f857f2f4908"

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ conversation_id segment_index text sentiment score emotions
14092 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 93 That's not the written. Right? No. Okay. neutral 0.0 ["contentment"]
14093 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 94 Yeah. neutral 0.0 ["contentment"]
14094 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 95 Yeah. Yeah. neutral 0.0 ["contentment"]
14095 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 96 Right. neutral 0.0 ["contentment"]
14096 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 97 That's funny. That's weird. mixed 0.2 ["humor", "curiosity"]
14097 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 98 We're lovely. positive 0.6 ["joy", "warmth"]
14098 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 99 You were both more lovely and more temperate. positive 0.6 ["joy", "warmth"]
14099 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 100 Shall I compare you to a summer's day? Thou art both more lovely and more temperate. positive 0.8 ["joy", "warmth"]
14100 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 101 Yeah. neutral 0.0 ["contentment"]
14101 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 102 Yeah. neutral 0.0 ["contentment"]
14102 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 103 Was neutral 0.0 ["contentment"]
14103 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 104 Yeah. neutral 0.0 ["contentment"]
14104 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 105 I mean, the set of transactions you have right now are, like, they're they've built like, it's, like, not neutral 0.0 ["contentment"]
14105 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 106 Maybe they'll, like, like, marketing engine is not clear how well that's gonna work. Yeah. neutral 0.0 ["contentment"]
14106 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 107 There's difference between Emily talking about what Matt gonna do and you talking about what you're gonna do for one thing. neutral 0.0 ["contentment"]
14107 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 108 Would you prefer like, there is an element of, like, I don't wanna talk about what I'm gonna do because I wanna I know. I the I think I told you this. There's some podcasts where I was like, don't tell people what you're gonna do. neutral 0.0 ["contentment"]
14108 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 109 Well, it, like, it, like, gives you a reward before you've actually done it. Like, there's a there's a reward when you like, it it sucks away motivation. Like, when you're hungry for something, then you say you're going to do it, it gives you some of the reward and it robs some of the motivation of it from the system psychologically. mixed 0.4 ["frustration", "determination"]
14109 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 110 Yes. positive 0.6 ["joy", "warmth"]
14110 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 111 I Right. neutral 0.0 ["contentment"]
14111 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 112 Some people say you're supposed to, like, declare what you're gonna do in public because that that holds you accountable, and that creates motivation that this particular thing should the opposite. mixed 0.2 ["curiosity", "frustration"]
14112 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 113 Tell anybody. Keep it to yourself. positive 0.6 ["determination", "hope"]
14113 Friends Reflect On Dreams, Debt, And Doing The Work 17623cdc-f551-4332-a8a8-4f857f2f4908 114 I know. I got you. Understand. positive 0.6 ["empathy", "connection"]

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