omi_transcript_segments
3 rows where conversation_id = "a6d9ce77-909b-41f5-a044-e050da781681"
This data as json, CSV (advanced)
| id ▼ | conversation_id | text | speaker_id | speaker_name | start_time | end_time |
|---|---|---|---|---|---|---|
| 24455 | User Reflects On Aging And Body Image a6d9ce77-909b-41f5-a044-e050da781681 | That and I it naked, not literally. | 0 | User | -1.9073468138230965e-08 | 56.51004998092651 |
| 24456 | User Reflects On Aging And Body Image a6d9ce77-909b-41f5-a044-e050da781681 | But, it's gonna be worse for me than that. | 0 | User | 58.88999998092652 | 60.32999998092646 |
| 24457 | User Reflects On Aging And Body Image a6d9ce77-909b-41f5-a044-e050da781681 | Much more brutal. I'm in incredible shape. For forty seven, I'm in incredible shape. Physically naked, we'd be fine. | 0 | User | 69.98999998092654 | 80.51999998092651 |
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);