omi_transcript_segments
1 row where conversation_id = "f2aa723e-8ead-4d60-a133-db6cc4a2fcbb"
This data as json, CSV (advanced)
| id ▼ | conversation_id | text | speaker_id | speaker_name | start_time | end_time |
|---|---|---|---|---|---|---|
| 24413 | User Mentions Having Two Jobs f2aa723e-8ead-4d60-a133-db6cc4a2fcbb | I got two jobs, actually. | 0 | User | 5.7220461258111754e-08 | 2.480000057220451 |
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);