omi_transcript_segments

3 rows where conversation_id = "be08c053-0ff8-4cca-b994-cce1ba9c494e"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ conversation_id text speaker_id speaker_name start_time end_time
19044 Family Morning Chores And Plans be08c053-0ff8-4cca-b994-cce1ba9c494e Sorry. He should let somebody know when that happens. 0 User -4.76837158203125e-07 5.199999523162842
19045 Family Morning Chores And Plans be08c053-0ff8-4cca-b994-cce1ba9c494e Get yourself some breakfast and I will Do you guys need clothes for today? Probably need to do laundry. 0 User 15.179998523162842 21.97000052316284
19046 Family Morning Chores And Plans be08c053-0ff8-4cca-b994-cce1ba9c494e I'm gonna take the bar. 0 User 61.39999952316284 62.44000152316284

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