home / saraphina

sentiment_segments

6 rows where conversation_id = "be08c053-0ff8-4cca-b994-cce1ba9c494e"

✎ 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
1861 Family Morning Chores And Plans be08c053-0ff8-4cca-b994-cce1ba9c494e 306 Sorry. He should let somebody know when that happens. negative -0.5 ["frustration"]
1862 Family Morning Chores And Plans be08c053-0ff8-4cca-b994-cce1ba9c494e 307 Get yourself some breakfast and I will Do you guys need clothes for today? Probably need to do laundry. neutral 0.0 []
1863 Family Morning Chores And Plans be08c053-0ff8-4cca-b994-cce1ba9c494e 308 I'm gonna take the bar. neutral 0.0 []
9233 Family Morning Chores And Plans be08c053-0ff8-4cca-b994-cce1ba9c494e 306 Sorry. He should let somebody know when that happens. negative -0.5 ["frustration"]
9234 Family Morning Chores And Plans be08c053-0ff8-4cca-b994-cce1ba9c494e 307 Get yourself some breakfast and I will Do you guys need clothes for today? Probably need to do laundry. neutral 0.0 []
9235 Family Morning Chores And Plans be08c053-0ff8-4cca-b994-cce1ba9c494e 308 I'm gonna take the bar. neutral 0.0 []

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 5.103ms