home / saraphina

sentiment_segments

6 rows where conversation_id = "a6d9ce77-909b-41f5-a044-e050da781681"

✎ 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
19 User Reflects On Aging And Body Image a6d9ce77-909b-41f5-a044-e050da781681 18 That and I it naked, not literally. neutral 0.0 []
20 User Reflects On Aging And Body Image a6d9ce77-909b-41f5-a044-e050da781681 19 But, it's gonna be worse for me than that. negative -0.6 ["fear"]
21 User Reflects On Aging And Body Image a6d9ce77-909b-41f5-a044-e050da781681 20 Much more brutal. I'm in incredible shape. For forty seven, I'm in incredible shape. Physically naked, we'd be fine. positive 0.6 ["pride"]
7391 User Reflects On Aging And Body Image a6d9ce77-909b-41f5-a044-e050da781681 18 That and I it naked, not literally. neutral 0.0 []
7392 User Reflects On Aging And Body Image a6d9ce77-909b-41f5-a044-e050da781681 19 But, it's gonna be worse for me than that. negative -0.6 ["fear"]
7393 User Reflects On Aging And Body Image a6d9ce77-909b-41f5-a044-e050da781681 20 Much more brutal. I'm in incredible shape. For forty seven, I'm in incredible shape. Physically naked, we'd be fine. positive 0.6 ["pride"]

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