home / saraphina

sentiment_segments

6 rows where conversation_id = "e5958c86-a55f-4811-8018-0b2c1ad58c56"

✎ 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
5562 Family Reviews Mortgages And Gathers Tax Documents e5958c86-a55f-4811-8018-0b2c1ad58c56 213 Not yet. neutral 0.0 ["resignation"]
5563 Family Reviews Mortgages And Gathers Tax Documents e5958c86-a55f-4811-8018-0b2c1ad58c56 214 K. neutral 0.0 ["contentment"]
5564 Family Reviews Mortgages And Gathers Tax Documents e5958c86-a55f-4811-8018-0b2c1ad58c56 215 That doesn't sound good. That's so good. mixed 0.5 ["concern", "joy"]
12692 Family Reviews Mortgages And Gathers Tax Documents e5958c86-a55f-4811-8018-0b2c1ad58c56 213 Not yet. neutral 0.0 ["resignation"]
12693 Family Reviews Mortgages And Gathers Tax Documents e5958c86-a55f-4811-8018-0b2c1ad58c56 214 K. neutral 0.0 ["contentment"]
12694 Family Reviews Mortgages And Gathers Tax Documents e5958c86-a55f-4811-8018-0b2c1ad58c56 215 That doesn't sound good. That's so good. mixed 0.5 ["concern", "joy"]

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.356ms