omi_transcript_segments
1 row where conversation_id = "15dc9cd2-2533-4a52-847e-dbe59da8bc96"
This data as json, CSV (advanced)
| id ▼ | conversation_id | text | speaker_id | speaker_name | start_time | end_time |
|---|---|---|---|---|---|---|
| 101775 | Friends Discuss Getting Five Guys 15dc9cd2-2533-4a52-847e-dbe59da8bc96 | Guys want five guys? Yeah. | 0 | User | 3.6239703149476554e-07 | 136.91497551918133 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);