home / saraphina

omi_transcript_segments

13 rows where conversation_id = "0e7a7b18-4831-4fae-9628-5bc81253a562"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speaker_id, speaker_name

id ▼ conversation_id text speaker_id speaker_name start_time end_time
246063 Flirty Conversation About Outfits And Appearance 0e7a7b18-4831-4fae-9628-5bc81253a562 E se oho 0 Speaker 0 4.863739064830952e-07 0.640000486373907
246064 Flirty Conversation About Outfits And Appearance 0e7a7b18-4831-4fae-9628-5bc81253a562 I haven't seen it. 0 Speaker 0 5.740000486373901 17.927674661090094
246065 Flirty Conversation About Outfits And Appearance 0e7a7b18-4831-4fae-9628-5bc81253a562 It felt good when you did it. I like it. 1 User 18.267674961090094 20.907674961090095
246066 Flirty Conversation About Outfits And Appearance 0e7a7b18-4831-4fae-9628-5bc81253a562 Parks. 1 User 24.747674961090084 77.4107614707948
246067 Flirty Conversation About Outfits And Appearance 0e7a7b18-4831-4fae-9628-5bc81253a562 What? 0 Speaker 0 81.27076147079478 83.164462823868
246068 Flirty Conversation About Outfits And Appearance 0e7a7b18-4831-4fae-9628-5bc81253a562 Already? Just from listing like guess, makes sense. But usually it happens quick. Yeah. Do you want me to close your blinds? 1 User 85.50446282386798 92.824462823868
246069 Flirty Conversation About Outfits And Appearance 0e7a7b18-4831-4fae-9628-5bc81253a562 Make to close your blinds. Is that okay to do that? 1 User 96.554462823868 100.06058278355457
246070 Flirty Conversation About Outfits And Appearance 0e7a7b18-4831-4fae-9628-5bc81253a562 Those are good. Yeah. Do I like them more or less than the other ones that you just had on? 1 User 172.73090576171944 201.30405068397602
246071 Flirty Conversation About Outfits And Appearance 0e7a7b18-4831-4fae-9628-5bc81253a562 Well, not I mean, those were the then I used to have. Last time you saw me in the thong. 0 Speaker 0 201.824050683976 208.024048683976
246072 Flirty Conversation About Outfits And Appearance 0e7a7b18-4831-4fae-9628-5bc81253a562 Yeah. 1 User 208.024048683976 208.264050683976
246073 Flirty Conversation About Outfits And Appearance 0e7a7b18-4831-4fae-9628-5bc81253a562 Not today. 0 Speaker 0 209.22405068397597 209.86405068397596
246074 Flirty Conversation About Outfits And Appearance 0e7a7b18-4831-4fae-9628-5bc81253a562 I would say it about the same. No strong preference. You look great. You look great. Look great. Mhmm. I like them. 1 User 212.46405068397598 220.54405068397597
246075 Flirty Conversation About Outfits And Appearance 0e7a7b18-4831-4fae-9628-5bc81253a562 You're very sexy. 2 Speaker 2 223.30405068397602 224.10405068397597

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE omi_transcript_segments (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    conversation_id TEXT NOT NULL,
    text TEXT,
    speaker_id INTEGER,
    speaker_name TEXT,
    start_time REAL,
    end_time REAL,
    FOREIGN KEY (conversation_id) REFERENCES omi_conversations(id)
);
CREATE INDEX idx_omi_segments_conv ON omi_transcript_segments(conversation_id);
Powered by Datasette · Queries took 4.839ms