home / saraphina

omi_transcript_segments

8 rows where conversation_id = "01b71a35-86d2-434d-a100-5dde1cdbde88"

✎ 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
319078 Dog Lost On Vegas Trip 01b71a35-86d2-434d-a100-5dde1cdbde88 Vegas to the bitcoin conference. yeah. and we're gone for, like, a day and a half. and oscar's like, where's ollie? is he with you? i'm like, why don't we take your dog to las vegas with us? so it took them, like, a whole almost two days before anybody realizes the dog's gone. 0 Speaker 0 0.0 12.8
319079 Dog Lost On Vegas Trip 01b71a35-86d2-434d-a100-5dde1cdbde88 Oh, no. 1 Speaker 1 12.8 13.44
319080 Dog Lost On Vegas Trip 01b71a35-86d2-434d-a100-5dde1cdbde88 I know. so one of the things are i wanna trail up the door open when they went to school, and it's roaring rain. so the pound picks him up. he's soaking wet. and i'm like, yeah. this is what my dog looks like. they're like, yeah. we we have this red looking thing, and he doesn't have a collar because his hair was screwed by the time he got there. and oscar's like, i'm going anyways. he goes to the pound and sure enough it's our dog and yes he does have on his collar. i was like, just so you know, your dog's red. and i'm like, just so you know, he's papered and he's a goldendoodle. maybe you should have looked at the pound. or look at the flipping 0 Speaker 0 13.44 42.28
319081 Dog Lost On Vegas Trip 01b71a35-86d2-434d-a100-5dde1cdbde88 Yeah. collar. 1 Speaker 1 42.36 43.0
319082 Dog Lost On Vegas Trip 01b71a35-86d2-434d-a100-5dde1cdbde88 Yeah. she said that he did have one, and he totally had it on. like, his like, they could have looked at his razy pads and, like, called us. like, instead they, like, almost put him to sleep, you know, because who knows how long they stay there. 0 Speaker 0 43.66 53.16
319083 Dog Lost On Vegas Trip 01b71a35-86d2-434d-a100-5dde1cdbde88 Right. right. right. they have a calendar on that. right. yeah. mhmm. yeah. 1 Speaker 1 53.16 56.75
319084 Dog Lost On Vegas Trip 01b71a35-86d2-434d-a100-5dde1cdbde88 Like, i'm like, you probably shouldn't work at the pound. 0 Speaker 0 56.75 58.91
319085 Dog Lost On Vegas Trip 01b71a35-86d2-434d-a100-5dde1cdbde88 Yeah. definitely. 1 Speaker 1 58.91 59.95

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