sentiment_segments

6 rows where conversation_id = "e579e856-0cff-4385-8f09-0c5254788f7f"

✎ 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
5575 Family Chats About Running Shoes And Pets e579e856-0cff-4385-8f09-0c5254788f7f 226 Does he have a recommendation of what shoes you need? Ask him again today. neutral 0.0 ["curiosity"]
5576 Family Chats About Running Shoes And Pets e579e856-0cff-4385-8f09-0c5254788f7f 227 Get that useless little dog. negative -0.5 ["frustration"]
5577 Family Chats About Running Shoes And Pets e579e856-0cff-4385-8f09-0c5254788f7f 228 Might as well be a cat on a leak negative -0.5 ["frustration"]
12705 Family Chats About Running Shoes And Pets e579e856-0cff-4385-8f09-0c5254788f7f 226 Does he have a recommendation of what shoes you need? Ask him again today. neutral 0.0 ["curiosity"]
12706 Family Chats About Running Shoes And Pets e579e856-0cff-4385-8f09-0c5254788f7f 227 Get that useless little dog. negative -0.5 ["frustration"]
12707 Family Chats About Running Shoes And Pets e579e856-0cff-4385-8f09-0c5254788f7f 228 Might as well be a cat on a leak negative -0.5 ["frustration"]

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);