sentiment_segments

2 rows where conversation_id = "0efdc353-8d36-475f-a0e6-80dc46ae978e"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: emotions (array)

id ▼ conversation_id segment_index text sentiment score emotions
24003 User Questions Pointless Traffic Signal 0efdc353-8d36-475f-a0e6-80dc46ae978e 6 That's pointless. The red light? Yeah. Because there's a green there's green lights there and there, but there's no roads in either place. negative -0.5 ["frustration", "concern"]
24004 User Questions Pointless Traffic Signal 0efdc353-8d36-475f-a0e6-80dc46ae978e 7 I'm gonna ignore it. I'll be just testing it, like, just running it through it. Paces. neutral 0.0 ["determination"]

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