sentiment_segments

20 rows where conversation_id = "848ab702-0cc0-4106-976a-5f4bab501e1a"

✎ 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
5064 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a 641 Hello? Hi. Is this Jacob? It is. neutral 0.0 ["curiosity"]
5065 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a 642 Is that correct? That's right. Yes. neutral 0.0 ["curiosity"]
5066 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a 643 Just too expensive right now. negative -0.5 ["frustration"]
5067 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a 644 No. I don't use them often. I like 20 packages that I have haven't used them. So Okay. We've got no word. And I'm not yeah. negative -0.5 ["frustration"]
5068 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a 645 Okay. There is a limit to how many I can to another person too. Right? neutral 0.0 ["curiosity"]
5069 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a 646 Okay. In what time period? Done A year? Throughout the year. neutral 0.0 ["curiosity"]
5070 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a 647 Okay. neutral 0.0 ["contentment"]
5071 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a 648 K. neutral 0.0 ["contentment"]
5072 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a 649 Okay. Thank you. positive 0.5 ["gratitude"]
5073 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a 650 You a good one. You too. You too. positive 0.5 ["joy"]
12436 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a 641 Hello? Hi. Is this Jacob? It is. neutral 0.0 ["curiosity"]
12437 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a 642 Is that correct? That's right. Yes. neutral 0.0 ["curiosity"]
12438 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a 643 Just too expensive right now. negative -0.5 ["frustration"]
12439 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a 644 No. I don't use them often. I like 20 packages that I have haven't used them. So Okay. We've got no word. And I'm not yeah. negative -0.5 ["frustration"]
12440 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a 645 Okay. There is a limit to how many I can to another person too. Right? neutral 0.0 ["curiosity"]
12441 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a 646 Okay. In what time period? Done A year? Throughout the year. neutral 0.0 ["curiosity"]
12442 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a 647 Okay. neutral 0.0 ["contentment"]
12443 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a 648 K. neutral 0.0 ["contentment"]
12444 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a 649 Okay. Thank you. positive 0.5 ["gratitude"]
12445 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a 650 You a good one. You too. You too. positive 0.5 ["joy"]

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