home / saraphina

omi_transcript_segments

20 rows where conversation_id = "1446e277-c7ea-4416-9174-96128e8442f0"

✎ 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
4177 Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 And shame senses. I'm a man who's got clear, who perfecting. 0 User 0.0 9.779999999999973
4178 Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 Hey, guys. 1 Speaker 1 28.49000000000001 29.049999999999955
4179 Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 Boys. 0 User 30.33000000000004 30.889999999999986
4180 Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 What is it? Crusted on this car. It's not good. The 2020 you guys did that. 0 User 63.08000000000004 71.25
4181 Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 Is it, like, actually stuck in there? No. Like, it's not too 0 User 81.25999999999999 85.01999999999998
4182 Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 We got done, like, high because we're we're, like, really just Oh, 0 User 93.49000000000001 97.00999999999999
4183 Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 Oh, yeah. 1 Speaker 1 97.14999999999998 97.71000000000004
4184 Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 We're gonna finish early this week. Okay. Sorry then. That was a long time to wait. 0 User 97.71000000000004 101.52999999999997
4185 Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 I should've I should've given I should remember to give you guys that phone. That's what it's for. 0 User 105.88999999999999 110.63
4186 Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 So you've been waiting for me all the time. Is what you're telling me? Yeah. I've only, like, this past week. It's not Okay. Okay. Alright. Well, tomorrow, this the rest of the week, I'll make sure the phone's in the bag. 0 User 119.16003 131.26
4187 Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 And I'll just assume that I can come at 05:30. Should I assume I can come at five? Because I don't wanna come and wait. That's the only thing. If it takes me, like, ten or fifteen minutes to get here. So 05:15. Fifteen. 0 User 132.50995 147.29999999999995
4188 Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 05:15? 1 Speaker 1 149.17999999999995 148.77999999999997
4189 Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 05:10. 1 Speaker 1 152.05999999999995 152.77997000000005
4190 Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 Okay. We'll do 05:10, and then, hopefully, they keep you late too much. Love comes bearing disguises. Take a look around the room. I'm a man who's got very specific change. 0 User 152.77997000000005 175.67003999999997
4191 Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 Because I know how and this kid named Timmy. Spoke. We called her at 1 Speaker 1 187.58000000000004 193.40999999999997
4192 Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 I almost, once time, got sent to an orphanage, but it stopped by me, brother? The horse is dead. Okay. 1 Speaker 1 209.85000000000002 216.29999999999995
4193 Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 That's the so I made this song. But, like, first song is hot. Hardest to be for a drain. So you wanna If my voice drops it's the very one that I had to actually see one up north. 1 Speaker 1 219.75995 234.23004000000003
4194 Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 Is that? 1 Speaker 1 283.04999999999995 284.25
4195 Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 About from just device to reset all the in the partner. 1 Speaker 1 307.92004 333.22002999999995
4196 Coordinating Daily Pickup Time 1446e277-c7ea-4416-9174-96128e8442f0 About data extra details 0 User 334.42999999999995 336.42999999999995

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