home / saraphina

sentiment_segments

20 rows where conversation_id = "07866012-8053-4a65-a186-0e3bda935bc7"

✎ 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
2943 Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 10 Memphis barbecue chicken. Does that sound right? Okay. neutral 0.0 []
2944 Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 11 We're just working on it. Might be Extra cheese on those? neutral 0.0 []
2945 Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 12 On much. The barbecue chicken ones? It doesn't say how much it is. It doesn't say how much it is. neutral 0.0 []
2946 Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 13 Oh, these are large. That's not what we wanted. We wanted mediums. Right? neutral 0.0 []
2947 Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 14 Those those so just getting a barbecue. I need to find a deal. On those because those are like 25 a piece the way I order ordered them. That's too much. But I I'm sure I can I can sure I get them? negative -0.5 ["frustration"]
2948 Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 15 Maybe in a little bit. I don't know. And generically, yes, but right this minute, no. neutral 0.0 []
2949 Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 16 What's What's your likely one ranches? Ranches? neutral 0.0 []
2950 Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 17 I can't hear what you're saying. neutral 0.0 ["frustration"]
2951 Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 18 Most likely? I don't know. Either Cafe Rio or Domino's, think. neutral 0.0 []
2952 Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 19 A little bit. neutral 0.0 []
10315 Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 10 Memphis barbecue chicken. Does that sound right? Okay. neutral 0.0 []
10316 Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 11 We're just working on it. Might be Extra cheese on those? neutral 0.0 []
10317 Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 12 On much. The barbecue chicken ones? It doesn't say how much it is. It doesn't say how much it is. neutral 0.0 []
10318 Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 13 Oh, these are large. That's not what we wanted. We wanted mediums. Right? neutral 0.0 []
10319 Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 14 Those those so just getting a barbecue. I need to find a deal. On those because those are like 25 a piece the way I order ordered them. That's too much. But I I'm sure I can I can sure I get them? negative -0.5 ["frustration"]
10320 Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 15 Maybe in a little bit. I don't know. And generically, yes, but right this minute, no. neutral 0.0 []
10321 Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 16 What's What's your likely one ranches? Ranches? neutral 0.0 []
10322 Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 17 I can't hear what you're saying. neutral 0.0 ["frustration"]
10323 Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 18 Most likely? I don't know. Either Cafe Rio or Domino's, think. neutral 0.0 []
10324 Friends Debate Dinner and Pizza Order 07866012-8053-4a65-a186-0e3bda935bc7 19 A little bit. neutral 0.0 []

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