home / saraphina

sentiment_segments

13 rows where conversation_id = "b69946f0-2713-413e-a538-7d3aa9314428"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: text, emotions (array)

id ▼ conversation_id segment_index text sentiment score emotions
14129 Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 130 Dad. What? Sorry. neutral 0.0 ["contentment"]
14130 Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 131 Yeah. neutral 0.0 ["contentment"]
14131 Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 132 A minute. neutral 0.0 ["contentment"]
14132 Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 133 Okay. neutral 0.0 ["contentment"]
14133 Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 134 Yeah. Yeah. neutral 0.0 ["contentment"]
14134 Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 135 I would've I should've sent you a message anyway. neutral 0.0 ["contentment"]
14135 Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 136 Okay. neutral 0.0 ["contentment"]
14136 Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 137 Okay. Okay. neutral 0.0 ["contentment"]
14137 Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 138 Yeah. Yeah. neutral 0.0 ["contentment"]
14138 Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 139 Yep. neutral 0.0 ["contentment"]
14139 Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 140 Okay. neutral 0.0 ["contentment"]
14140 Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 141 You know, I don't need anything. neutral 0.0 ["contentment"]
14141 Katie and Jake Discuss Family, Fitness, and Remotion b69946f0-2713-413e-a538-7d3aa9314428 142 Okay. neutral 0.0 ["contentment"]

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