omi_transcript_segments
8 rows where conversation_id = "0cf6e81b-e771-4d5a-a321-6445492728aa"
This data as json, CSV (advanced)
Suggested facets: speaker_id, speaker_name
| id ▼ | conversation_id | text | speaker_id | speaker_name | start_time | end_time |
|---|---|---|---|---|---|---|
| 273470 | Water Bottle Smash and Casual Banter 0cf6e81b-e771-4d5a-a321-6445492728aa | I'm gonna go smash a water bottle with a hammer. | 0 | Speaker 0 | -60.0 | -57.12 |
| 273471 | Water Bottle Smash and Casual Banter 0cf6e81b-e771-4d5a-a321-6445492728aa | Whose name is what? jeep? jeep. jeep? | 1 | Speaker 1 | -57.11999988555908 | -54.79999988555908 |
| 273472 | Water Bottle Smash and Casual Banter 0cf6e81b-e771-4d5a-a321-6445492728aa | Jeep. jeep. mom, what time is it? mom, can i go smash a frozen water bottle with a hammer? it's fun. college on to get a scholarship. do not do money water. we train in two majors and oh, you mean, like, one of the plastic. don't do it. | 0 | Speaker 0 | -54.799999952316284 | -27.68999995231628 |
| 273473 | Water Bottle Smash and Casual Banter 0cf6e81b-e771-4d5a-a321-6445492728aa | You tried. that's what counts. you tried. that's what counts. | 1 | Speaker 1 | -3.4100000858306885 | -0.21000008583069274 |
| 273474 | Water Bottle Smash and Casual Banter 0cf6e81b-e771-4d5a-a321-6445492728aa | Sing. didn't have the screen on. if i had known that was important, we could have. i'm glad we didn't. | 0 | Speaker 0 | 0.0 | 7.76 |
| 273475 | Water Bottle Smash and Casual Banter 0cf6e81b-e771-4d5a-a321-6445492728aa | Hello. hello, other people. | 0 | Speaker 0 | 55.63000011444092 | 59.150000114440914 |
| 273476 | Water Bottle Smash and Casual Banter 0cf6e81b-e771-4d5a-a321-6445492728aa | Jake. wait. did that girl play? i know. that's a good face. i don't think we'd recognize her. i would. i wonder how people do you want to go to eleven that one. mom, can we do | 0 | Speaker 0 | 61.0 | 112.11 |
| 273477 | Water Bottle Smash and Casual Banter 0cf6e81b-e771-4d5a-a321-6445492728aa | Leather beads on monday. you've what? becky. becky's disgusting. wait. so do you guys put out and do we do leatherbees. katie always, always, always do leatherbees. plus, we're gonna get leatherbees in a few days. what happened to your thumb? do know? i got hit with pickleball. oh, really? well, that's good then. that's a bad a wound. yeah. that's a that's a proud moment. yes. you don't have to eat. i can't bear it. the one broke my nail. yeah. yeah. cold stone and chick fil a maybe? not too expensive. more expensive than mother bees. really? | 0 | Speaker 0 | 120.0 | 179.89 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);