home / saraphina

sentiment_segments

18 rows where conversation_id = "9ac3824d-ebce-4847-b70e-f9bc3f3a75da"

✎ 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
5074 Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da 0 That's the three Is this just three o'clock? Yeah. neutral 0.0 ["contentment"]
5075 Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da 1 No. negative -0.5 ["frustration"]
5076 Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da 2 Please remember to neutral 0.0 []
5077 Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da 3 Good. positive 0.5 ["joy"]
5078 Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da 4 Well, someone fucking So somebody broke my fucking heart. negative -0.8 ["sadness", "anger"]
5079 Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da 5 I was heartbroken, you bitch. negative -0.9 ["sadness", "anger"]
5080 Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da 6 I've read the whole fucking Cosmere. positive 0.6 ["joy"]
5081 Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da 7 Because I got divorced. negative -0.7 ["sadness"]
5082 Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da 8 Well, sometimes when I'm heartbroken, I read. positive 0.3 ["joy"]
12446 Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da 0 That's the three Is this just three o'clock? Yeah. neutral 0.0 ["contentment"]
12447 Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da 1 No. negative -0.5 ["frustration"]
12448 Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da 2 Please remember to neutral 0.0 []
12449 Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da 3 Good. positive 0.5 ["joy"]
12450 Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da 4 Well, someone fucking So somebody broke my fucking heart. negative -0.8 ["sadness", "anger"]
12451 Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da 5 I was heartbroken, you bitch. negative -0.9 ["sadness", "anger"]
12452 Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da 6 I've read the whole fucking Cosmere. positive 0.6 ["joy"]
12453 Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da 7 Because I got divorced. negative -0.7 ["sadness"]
12454 Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da 8 Well, sometimes when I'm heartbroken, I read. positive 0.3 ["joy"]

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