sentiment_segments

8 rows where conversation_id = "99dea856-bd33-4aa4-856c-77f430932b57"

✎ 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
1052 Planning Next Costco Grocery Trip 99dea856-bd33-4aa4-856c-77f430932b57 0 Those nuggets are from Costco, boys. So remind me when I go to Costco, next time. I'm gonna go to get protein or fair lives or whatever. neutral 0.0 ["contentment"]
1053 Planning Next Costco Grocery Trip 99dea856-bd33-4aa4-856c-77f430932b57 1 That I should get stock up. On my nuggets. neutral 0.0 ["contentment"]
1054 Planning Next Costco Grocery Trip 99dea856-bd33-4aa4-856c-77f430932b57 2 And I normally get the tenders from Hermits. And I'm guessing they're a lot cheaper. I guess they're a lot cheaper from neutral 0.0 ["contentment"]
1055 Planning Next Costco Grocery Trip 99dea856-bd33-4aa4-856c-77f430932b57 3 Gonna hop out and give you guys a hug. positive 0.5 ["joy", "tenderness"]
8424 Planning Next Costco Grocery Trip 99dea856-bd33-4aa4-856c-77f430932b57 0 Those nuggets are from Costco, boys. So remind me when I go to Costco, next time. I'm gonna go to get protein or fair lives or whatever. neutral 0.0 ["contentment"]
8425 Planning Next Costco Grocery Trip 99dea856-bd33-4aa4-856c-77f430932b57 1 That I should get stock up. On my nuggets. neutral 0.0 ["contentment"]
8426 Planning Next Costco Grocery Trip 99dea856-bd33-4aa4-856c-77f430932b57 2 And I normally get the tenders from Hermits. And I'm guessing they're a lot cheaper. I guess they're a lot cheaper from neutral 0.0 ["contentment"]
8427 Planning Next Costco Grocery Trip 99dea856-bd33-4aa4-856c-77f430932b57 3 Gonna hop out and give you guys a hug. positive 0.5 ["joy", "tenderness"]

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