home / saraphina

sentiment_segments

10 rows where conversation_id = "37fc6000-1ec8-4283-99ce-e430a300f371"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: segment_index, text, sentiment, score, emotions, emotions (array)

id ▼ conversation_id segment_index text sentiment score emotions
2874 Family Game Night and Tina’s Work Reviews 37fc6000-1ec8-4283-99ce-e430a300f371 110 If I'm remembering right. neutral 0.0 ["curiosity"]
2875 Family Game Night and Tina’s Work Reviews 37fc6000-1ec8-4283-99ce-e430a300f371 111 Basketball. neutral 0.0 ["contentment"]
2876 Family Game Night and Tina’s Work Reviews 37fc6000-1ec8-4283-99ce-e430a300f371 112 do this. neutral 0.0 ["curiosity"]
2877 Family Game Night and Tina’s Work Reviews 37fc6000-1ec8-4283-99ce-e430a300f371 113 Correct. positive 0.5 ["determination"]
2878 Family Game Night and Tina’s Work Reviews 37fc6000-1ec8-4283-99ce-e430a300f371 114 So Yeah. Yeah. That's that's sounds like It's intense. neutral 0.0 ["concern"]
10246 Family Game Night and Tina’s Work Reviews 37fc6000-1ec8-4283-99ce-e430a300f371 110 If I'm remembering right. neutral 0.0 ["curiosity"]
10247 Family Game Night and Tina’s Work Reviews 37fc6000-1ec8-4283-99ce-e430a300f371 111 Basketball. neutral 0.0 ["contentment"]
10248 Family Game Night and Tina’s Work Reviews 37fc6000-1ec8-4283-99ce-e430a300f371 112 do this. neutral 0.0 ["curiosity"]
10249 Family Game Night and Tina’s Work Reviews 37fc6000-1ec8-4283-99ce-e430a300f371 113 Correct. positive 0.5 ["determination"]
10250 Family Game Night and Tina’s Work Reviews 37fc6000-1ec8-4283-99ce-e430a300f371 114 So Yeah. Yeah. That's that's sounds like It's intense. 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);
Powered by Datasette · Queries took 4.23ms