home / saraphina

sentiment_segments

10 rows where conversation_id = "01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb"

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ conversation_id segment_index text sentiment score emotions
24282 User Checks In On Eli’s Recovery 01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb 246 How are you feeling, Eli? neutral 0.0 ["concern"]
24283 User Checks In On Eli’s Recovery 01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb 247 Do you wanna go go run? positive 0.5 ["joy", "excitement"]
24284 User Checks In On Eli’s Recovery 01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb 248 Okay. neutral 0.0 []
24285 User Checks In On Eli’s Recovery 01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb 249 Good. Good job. positive 0.6 ["joy", "pride"]
24286 User Checks In On Eli’s Recovery 01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb 250 Oh, wow. Yeah. That's a ton of sleep. Okay. It's probably good for you. positive 0.5 ["concern", "relief"]
24287 User Checks In On Eli’s Recovery 01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb 251 Yeah. neutral 0.0 []
24288 User Checks In On Eli’s Recovery 01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb 252 Yeah. neutral 0.0 []
24289 User Checks In On Eli’s Recovery 01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb 253 You guys go into my house? Yeah. Yeah. neutral 0.0 []
24290 User Checks In On Eli’s Recovery 01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb 254 Yeah. neutral 0.0 []
24291 User Checks In On Eli’s Recovery 01e722ae-9e9f-4d9d-a1a2-8050f5a6e1fb 255 Yeah. 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 15.263ms