sentiment_segments

13 rows where conversation_id = "175ccd70-396e-44ba-be7a-bbd35a2167a1"

✎ 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
25810 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 351 Do we wanna, cut this this piece of baseboard this? neutral 0.0 ["curiosity"]
25811 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 352 Are you planning on putting that back in, and are you put it back in once after it's all we'll get a neutral 0.0 ["curiosity"]
25812 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 353 It might be easier to put it back in now if we're putting it back in at all. neutral 0.0 ["curiosity"]
25813 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 354 Wow. neutral 0.0 ["surprise"]
25814 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 355 Oh, is that what you're thinking? Was thinking we'd flip the cabinet upside down and, like, actually my nail it or something, glue it, put it back in. Shut it in. Okay. Shut it in. Yeah. neutral 0.0 ["curiosity", "determination"]
25815 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 356 You and me? neutral 0.0 ["curiosity"]
25816 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 357 You're not you haven't driven out here yet. Okay. neutral 0.0 ["concern"]
25817 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 358 Okay. neutral 0.0 ["neutral"]
25818 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 359 Alright. Bye. neutral 0.0 ["neutral"]
25819 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 360 You good with that? Yeah. Thank you. positive 0.5 ["gratitude"]
25820 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 361 Yeah. I don't know why there's a stud here. A stud there. Yep. neutral 0.0 ["curiosity"]
25821 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 362 Good. We wanna close this gap, are we good? neutral 0.0 ["determination"]
25822 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 363 Preferable? 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);