omi_transcript_segments

2 rows where conversation_id = "e3065334-d8aa-437c-a6d9-92e430377a9d"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ conversation_id text speaker_id speaker_name start_time end_time
77086 Planning Rides and Wake-Up Call for Piano e3065334-d8aa-437c-a6d9-92e430377a9d don't have to get it yet. I'm gonna go help Katie with something. I'll be back at, like, to give you guys a ride to piano. Will you go first at piano? 1 Speaker 1 5.7220404414692894e-08 10.060000057220464
77087 Planning Rides and Wake-Up Call for Piano e3065334-d8aa-437c-a6d9-92e430377a9d Yeah. Call me when you wake up, or I will call you at, like, 09:45 and wake you up. Okay? 1 Speaker 1 10.46000005722044 15.2599980572204

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