omi_transcript_segments

12 rows where conversation_id = "063d7a6a-f0b4-4634-a0e6-a2bfb9042d71"

✎ 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
216481 Tense Confrontation Over Mother’s Possible Crime 063d7a6a-f0b4-4634-a0e6-a2bfb9042d71 Because your mother killed somebody. Oh, is she not my mother? God give a shit what that woman did. 0 Speaker 0 2.47955313170678e-07 4.360000247955327
216482 Tense Confrontation Over Mother’s Possible Crime 063d7a6a-f0b4-4634-a0e6-a2bfb9042d71 You don't? 1 Speaker 1 4.360000247955327 5.16000024795531
216483 Tense Confrontation Over Mother’s Possible Crime 063d7a6a-f0b4-4634-a0e6-a2bfb9042d71 Well, something pulled you out of that chair just now, and I know it's not about me asking around. I got one 0 Speaker 0 5.880000247955309 11.840000247955317
216484 Tense Confrontation Over Mother’s Possible Crime 063d7a6a-f0b4-4634-a0e6-a2bfb9042d71 So I got shit to do. You have every right to be angry. But do you wanna feel if your mother winds up in prison or not because you're too scared to talk to her? 0 Speaker 0 14.9200002479553 24.96000024795532
216485 Tense Confrontation Over Mother’s Possible Crime 063d7a6a-f0b4-4634-a0e6-a2bfb9042d71 I need you. 0 Speaker 0 26.800000247955325 27.439999247955313
216486 Tense Confrontation Over Mother’s Possible Crime 063d7a6a-f0b4-4634-a0e6-a2bfb9042d71 I'm not I said no. 1 Speaker 1 28.11999924795532 30.040000247955305
216487 Tense Confrontation Over Mother’s Possible Crime 063d7a6a-f0b4-4634-a0e6-a2bfb9042d71 Left you in the room. Does not mean I will. 1 Speaker 1 47.790649029877244 49.85064702987725
216488 Tense Confrontation Over Mother’s Possible Crime 063d7a6a-f0b4-4634-a0e6-a2bfb9042d71 Last name. 0 Speaker 0 103.18833383560181 104.0683338356018
216489 Tense Confrontation Over Mother’s Possible Crime 063d7a6a-f0b4-4634-a0e6-a2bfb9042d71 Wait. I see major. 0 Speaker 0 107.24833383560181 159.8613735485077
216490 Tense Confrontation Over Mother’s Possible Crime 063d7a6a-f0b4-4634-a0e6-a2bfb9042d71 I know we've talk about this case. But I wanna tell you like an attorney present. With my son. I'm here in the capacity of the day. 0 Speaker 0 163.2913735485077 172.92481171607972
216491 Tense Confrontation Over Mother’s Possible Crime 063d7a6a-f0b4-4634-a0e6-a2bfb9042d71 Investigating out of the site. But that don't change what you want. Just tell him what. Walk down on a nutshell. 0 Speaker 0 173.40481071607974 181.99538072721901
216492 Tense Confrontation Over Mother’s Possible Crime 063d7a6a-f0b4-4634-a0e6-a2bfb9042d71 Situation. But after these years, we know being able to force myself to pick up a phone 0 Speaker 0 217.1375589752202 227.1375589752202

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