omi_transcript_segments

5 rows where conversation_id = "00b7baf8-c053-463c-9c85-6b3578bdc203"

✎ 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
318997 Discuss Gangs, Cartels, And Property 00b7baf8-c053-463c-9c85-6b3578bdc203 When i had left there, there was, like, cribs and bloods, and they'd become a really big thing, and you couldn't wear, like, chicago bowl stuff and la stuff. and so then i go back there, like, twelve years later, and i was like, there's no gang, anything here. they clean up. and they're like, oh, no. 0 Speaker 0 0.0 15.91
318998 Discuss Gangs, Cartels, And Property 00b7baf8-c053-463c-9c85-6b3578bdc203 It's worse. 1 Speaker 1 15.91 16.48
318999 Discuss Gangs, Cartels, And Property 00b7baf8-c053-463c-9c85-6b3578bdc203 Cartel owns everything now. all the crimson bloods were given ultimatum, leave or die. some left, and some have never since been seen. it's, like, interesting. 0 Speaker 0 16.48 26.76
319000 Discuss Gangs, Cartels, And Property 00b7baf8-c053-463c-9c85-6b3578bdc203 Okay. new mexico was like like a ton of games. it was kinda crazy that you would not expect that out of but the state fair, sketchiest places i've ever been in my life. street. 1 Speaker 1 27.24 38.76
319001 Discuss Gangs, Cartels, And Property 00b7baf8-c053-463c-9c85-6b3578bdc203 We we lived yeah. when i was dating her, i was like, well, let's see if she's a if she's a gold digger because i had just bought a property from the wife of a guy who was in jail for selling drugs. ten minutes. and i bought it for $20,000. it's a little two bedroom, one bath that i was fixing up, and i plan to be single for a while. 0 Speaker 0 39.31 59.35

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);