home / saraphina

omi_transcript_segments

18 rows where conversation_id = "03a8f645-9338-40b8-9338-fd594ff23d71"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: text, speaker_id, speaker_name

id ▼ conversation_id text speaker_id speaker_name start_time end_time
140941 Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 What'd you say? 0 User -6.675554686808027e-08 122.16559337616218
140942 Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 Imagine a ride. 2 Speaker 2 122.60559337616178 123.56559337616181
140943 Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 Been odd. Or Well, I I ran around the track a few weeks ago. A week or two ago. Okay. I haven't been jogging in the morning. I have When was the last time you, like, jumped to me? 0 User 151.69301403999634 161.28302403999623
140944 Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 Air? 2 Speaker 2 162.52301403999627 163.16302403999634
140945 Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 I've been jumping a little bit too. I been, like practicing jumping. Because my jumps are, like, weak. Probably a couple weeks ago too for that, I jumped. 1 Speaker 1 163.40301403999638 172.80301403999647
140946 Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 Okay. Yeah. I can jump higher than like, the same 2 Speaker 2 172.8830140399964 175.96301403999632
140947 Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 Yeah. 0 User 176.20301403999656 176.44302403999654
140948 Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 Was even like like, was even larger in eighth grade because I could touch Really? Wow. I did it once in my class, and I now I can't do anything. 2 Speaker 2 176.84301403999643 189.70388855935062
140949 Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 Anymore. 2 Speaker 2 189.78388855935054 190.18388855935063
140950 Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 Well, you should learn to dunk a basketball then. 0 User 192.30387855935032 194.86387855935027
140951 Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 Yeah. But back in the Can you can you basketball thing. One of my coaches said he you palm a basketball? 2 Speaker 2 195.2238885593506 199.42388855935042
140952 Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 Like, yearly, but it, like, falls out of my hand. 2 Speaker 2 205.86388855935047 208.66387855935045
140953 Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 If you get so you can a basketball and you can jump that high, that should be pretty easy for you to dunk. 0 User 212.94415087701282 217.32415087701293
140954 Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 That's fun. Do you wanna do some more basketball stuff? I don't know. 0 User 221.4241408770131 227.6210867500463
140955 Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 Your height would make you, like, kind of a strong player if you decided you were interested in that again. 1 Speaker 1 228.42108675004647 231.90106675004654
140956 Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 Do you need to pee? Do you have an infection? Sometimes bladders get infected. 0 User 239.26108675004616 246.77304906845893
140957 Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 Piano bucks? Laptops, retainers. K? For both you and Good to more than five minutes. 0 User 250.6630690684592 310.4178934478782
140958 Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 Yeah. 2 Speaker 2 311.05787344787814 312.97789344787816

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 3.846ms