sentiment_segments

6 rows where conversation_id = "524c7723-c4b1-4f57-86ef-010964a3c770"

✎ 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
15505 Family Chores, Gym Plans, And Tech Help 524c7723-c4b1-4f57-86ef-010964a3c770 61 Who took a shower and who did not? neutral 0.0 ["concern"]
15506 Family Chores, Gym Plans, And Tech Help 524c7723-c4b1-4f57-86ef-010964a3c770 62 You guys should go run out outside for a little bit. Because it's really nice. It's, like, 60 degrees. positive 0.6 ["joy", "warmth"]
15507 Family Chores, Gym Plans, And Tech Help 524c7723-c4b1-4f57-86ef-010964a3c770 63 And John, you should take a shower after that. neutral 0.0 ["concern"]
15508 Family Chores, Gym Plans, And Tech Help 524c7723-c4b1-4f57-86ef-010964a3c770 64 And I still kinda plan on going to the gym gym with you today, John. positive 0.5 ["determination", "excitement"]
15509 Family Chores, Gym Plans, And Tech Help 524c7723-c4b1-4f57-86ef-010964a3c770 65 What are Photon apps? neutral 0.0 ["curiosity"]
15510 Family Chores, Gym Plans, And Tech Help 524c7723-c4b1-4f57-86ef-010964a3c770 66 Have you restarted it recently? Try restarting it. neutral 0.0 ["concern"]

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