sentiment_segments

3 rows where conversation_id = "0d047ae2-fb6c-49e1-a773-ecca2dadfd4d"

✎ 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
15821 Childhood Self-Image and Attractiveness Reflections 0d047ae2-fb6c-49e1-a773-ecca2dadfd4d 195 You think you were ugly? neutral 0.0 ["curiosity"]
15822 Childhood Self-Image and Attractiveness Reflections 0d047ae2-fb6c-49e1-a773-ecca2dadfd4d 196 Just, like, I think it's I was gonna say you've never been. You've always been a good looking kid. positive 0.8 ["joy", "warmth"]
15823 Childhood Self-Image and Attractiveness Reflections 0d047ae2-fb6c-49e1-a773-ecca2dadfd4d 197 Like, how old? 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);