home / saraphina

sentiment_segments

12 rows where conversation_id = "61fe85ec-7843-4bfd-a85d-1776ac9490ad"

✎ 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
2321 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad 0 I'm 47 years old. neutral 0.0 ["contentment"]
2322 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad 1 I live in South Jordan, Utah. neutral 0.0 ["contentment"]
2323 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad 2 I am a software developer. neutral 0.0 ["contentment"]
2324 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad 3 To become rich and famous. positive 0.5 ["hope", "joy"]
2325 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad 4 This month I need to get a new job. neutral 0.0 ["concern"]
2326 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad 5 Today, we're gonna eat some burritos and go do a climbing go to a climbing gym. positive 0.6 ["joy", "excitement"]
9693 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad 0 I'm 47 years old. neutral 0.0 ["contentment"]
9694 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad 1 I live in South Jordan, Utah. neutral 0.0 ["contentment"]
9695 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad 2 I am a software developer. neutral 0.0 ["contentment"]
9696 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad 3 To become rich and famous. positive 0.5 ["hope", "joy"]
9697 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad 4 This month I need to get a new job. neutral 0.0 ["concern"]
9698 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad 5 Today, we're gonna eat some burritos and go do a climbing go to a climbing gym. positive 0.6 ["joy", "excitement"]

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