sentiment_segments

5 rows where conversation_id = "e401eb62-983b-4113-9f27-0963cffd37e9"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: sentiment, score, emotions (array)

id ▼ conversation_id segment_index text sentiment score emotions
15281 User Heads to Katie’s Construction Project e401eb62-983b-4113-9f27-0963cffd37e9 260 Hey, guys. What? I'm gonna go back over to Katie's. I'm helping her with a construction project. She's like re building one of her rooms. positive 0.6 ["joy", "determination"]
15282 User Heads to Katie’s Construction Project e401eb62-983b-4113-9f27-0963cffd37e9 261 Okay. I'll be back before. So so piano's at two. I'll be back before that, 01:45. There's close air to take showers. You got pizza for lunch. neutral 0.0 ["contentment"]
15283 User Heads to Katie’s Construction Project e401eb62-983b-4113-9f27-0963cffd37e9 262 Guys need anything else? No. Okay. Have you got that phone? Go up wherever that phone is, go grab it and bring it down here in case I need to call you. neutral 0.0 ["concern"]
15284 User Heads to Katie’s Construction Project e401eb62-983b-4113-9f27-0963cffd37e9 263 And she wants food. I'm not I might not have any. negative -0.4 ["frustration", "concern"]
15285 User Heads to Katie’s Construction Project e401eb62-983b-4113-9f27-0963cffd37e9 264 What was that? 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);