omi_transcript_segments

2 rows where conversation_id = "0f3976e2-e499-4d73-adf4-9a6e1dbca713"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ conversation_id text speaker_id speaker_name start_time end_time
296142 Plans To Take Will Home 0f3976e2-e499-4d73-adf4-9a6e1dbca713 Yeah. The the Yes. 0 Speaker 0 -7.629394360719743e-08 1.999999723706054
296143 Plans To Take Will Home 0f3976e2-e499-4d73-adf4-9a6e1dbca713 Do you guys both wanna go with me to take Will home? I think so. K. 0 Speaker 0 6.0299999237060575 18.713559483123774

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