omi_transcript_segments

6 rows where conversation_id = "15aa4928-fcb0-48ef-8d29-2e5e56578cce"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ conversation_id text speaker_id speaker_name start_time end_time
242128 Reflecting On A Past Cancer Diagnosis 15aa4928-fcb0-48ef-8d29-2e5e56578cce Too often when she was young, and the cancer spread already. 0 Speaker 0 4.005432074905002e-07 6.600000200543214
242129 Reflecting On A Past Cancer Diagnosis 15aa4928-fcb0-48ef-8d29-2e5e56578cce There's nothing we can do about it now. 0 Speaker 0 11.340000400543211 14.220000400543213
242130 Reflecting On A Past Cancer Diagnosis 15aa4928-fcb0-48ef-8d29-2e5e56578cce Who? Oh, oh, I like that one. I like that. 0 Speaker 0 112.79675985336304 118.67675985336304
242131 Reflecting On A Past Cancer Diagnosis 15aa4928-fcb0-48ef-8d29-2e5e56578cce Were young. 0 Speaker 0 238.7842978382112 239.3442978382112
242132 Reflecting On A Past Cancer Diagnosis 15aa4928-fcb0-48ef-8d29-2e5e56578cce And there's nothing we can do about it now. 0 Speaker 0 246.0842978382112 249.3642978382112
242133 Reflecting On A Past Cancer Diagnosis 15aa4928-fcb0-48ef-8d29-2e5e56578cce To her body and her blood. 0 Speaker 0 279.3339169883735 281.17391698837355

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