omi_transcript_segments

10 rows where conversation_id = "0c74ad34-c949-4575-a64f-a2f6bd030f2a"

✎ 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
195006 Driving To Friend’s Place For Pickleball 0c74ad34-c949-4575-a64f-a2f6bd030f2a oh, I should get my I have a pickleball paddle. That's okay. 1 User 2.670328740350669e-07 131.70405271530353
195007 Driving To Friend’s Place For Pickleball 0c74ad34-c949-4575-a64f-a2f6bd030f2a Or you're stupid. You know, you're stupid. I don't know. 1 User 136.32984639976485 140.2698863997648
195008 Driving To Friend’s Place For Pickleball 0c74ad34-c949-4575-a64f-a2f6bd030f2a Hey. 0 Speaker 0 144.37986639976498 206.1149517250019
195009 Driving To Friend’s Place For Pickleball 0c74ad34-c949-4575-a64f-a2f6bd030f2a So I am in my car. I'm coming to your place unless I should go somewhere else. 1 User 206.59493172500197 211.07495172500194
195010 Driving To Friend’s Place For Pickleball 0c74ad34-c949-4575-a64f-a2f6bd030f2a I I have a paddle with me. Yes. 1 User 218.13402838706088 219.81402838706094
195011 Driving To Friend’s Place For Pickleball 0c74ad34-c949-4575-a64f-a2f6bd030f2a Is that the sandy one? Is it, like, across from, like it's, like, a 106 south ish? 1 User 223.86400838706095 240.89752045630212
195012 Driving To Friend’s Place For Pickleball 0c74ad34-c949-4575-a64f-a2f6bd030f2a Yeah. Oh, okay. 0 Speaker 0 243.37752045630214 245.25752045630225
195013 Driving To Friend’s Place For Pickleball 0c74ad34-c949-4575-a64f-a2f6bd030f2a Got it. 1 User 245.85752045630215 246.33750045630222
195014 Driving To Friend’s Place For Pickleball 0c74ad34-c949-4575-a64f-a2f6bd030f2a K. Bye. 0 Speaker 0 246.6975204563023 247.49752045630225
195015 Driving To Friend’s Place For Pickleball 0c74ad34-c949-4575-a64f-a2f6bd030f2a Yep. 1 User 247.9375204563023 248.33752045630217

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