home / saraphina

sentiment_segments

22 rows where conversation_id = "154615b6-30fc-486b-94fb-33bedf4a2592"

✎ 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
8 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 7 Okay. neutral 0.0 []
9 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 8 Ele fell as guilty. negative -0.5 ["guilt"]
10 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 9 Don't have the capacity for her. negative -0.6 ["frustration"]
11 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 10 I I'm raving a lot. neutral 0.0 []
12 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 11 You're a beautiful human being that deserves a lot of happiness. You deserve happiness. positive 0.8 ["love", "joy"]
13 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 12 Okay. neutral 0.0 []
14 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 13 How did you fuck who did you go off and fuck this time? negative -0.7 ["anger"]
15 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 14 Is so in question. neutral 0.0 []
16 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 15 Choir and the fidelity you offer are so wildly different. negative -0.4 ["concern"]
17 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 16 You require And the fidelity. You offer or so absurdly opposite. You don't offer that. negative -0.5 ["frustration"]
18 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 17 I still love her. I love her anyway. I love her anyway. positive 0.7 ["love"]
7380 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 7 Okay. neutral 0.0 []
7381 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 8 Ele fell as guilty. negative -0.5 ["guilt"]
7382 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 9 Don't have the capacity for her. negative -0.6 ["frustration"]
7383 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 10 I I'm raving a lot. neutral 0.0 []
7384 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 11 You're a beautiful human being that deserves a lot of happiness. You deserve happiness. positive 0.8 ["love", "joy"]
7385 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 12 Okay. neutral 0.0 []
7386 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 13 How did you fuck who did you go off and fuck this time? negative -0.7 ["anger"]
7387 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 14 Is so in question. neutral 0.0 []
7388 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 15 Choir and the fidelity you offer are so wildly different. negative -0.4 ["concern"]
7389 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 16 You require And the fidelity. You offer or so absurdly opposite. You don't offer that. negative -0.5 ["frustration"]
7390 Processing Guilt, Fidelity, And Lingering Love 154615b6-30fc-486b-94fb-33bedf4a2592 17 I still love her. I love her anyway. I love her anyway. positive 0.7 ["love"]

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