home / saraphina

sentiment_segments

16 rows where conversation_id = "0f8708e9-7d5a-4688-b93f-464794c2d435"

✎ 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
1846 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 291 Hey? Hey. Good morning. How are you? I'm good. How are you doing? Good. Good. You was? positive 0.6 ["joy"]
1847 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 292 Okay. Okay. neutral 0.0 []
1848 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 293 Yeah. Do you sleep okay? neutral 0.0 []
1849 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 294 Okay. neutral 0.0 []
1850 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 295 I mean, neutral 0.0 []
1851 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 296 But I'd like to help you if I can. positive 0.4 ["empathy"]
1852 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 297 More market y. Uh-huh. Yeah. Okay. neutral 0.0 []
1853 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 298 I'm gonna go to the store and get casted. neutral 0.0 []
9218 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 291 Hey? Hey. Good morning. How are you? I'm good. How are you doing? Good. Good. You was? positive 0.6 ["joy"]
9219 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 292 Okay. Okay. neutral 0.0 []
9220 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 293 Yeah. Do you sleep okay? neutral 0.0 []
9221 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 294 Okay. neutral 0.0 []
9222 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 295 I mean, neutral 0.0 []
9223 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 296 But I'd like to help you if I can. positive 0.4 ["empathy"]
9224 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 297 More market y. Uh-huh. Yeah. Okay. neutral 0.0 []
9225 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 298 I'm gonna go to the store and get casted. 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 4.583ms