omi_transcript_segments
7 rows where conversation_id = "15affac1-294a-4eac-afae-2279aeb312f1"
This data as json, CSV (advanced)
Suggested facets: speaker_id, speaker_name
| id ▼ | conversation_id | text | speaker_id | speaker_name | start_time | end_time |
|---|---|---|---|---|---|---|
| 6683 | Call About Missed House Showing 15affac1-294a-4eac-afae-2279aeb312f1 | Hey. Did anyone come to see the house? No. Have have you been there the whole time since we were there? | 0 | User | -3.337860050578456e-07 | 8.929989666213999 |
| 6684 | Call About Missed House Showing 15affac1-294a-4eac-afae-2279aeb312f1 | Yeah. | 1 | Speaker 1 | 9.610009666213983 | 10.169999666213982 |
| 6685 | Call About Missed House Showing 15affac1-294a-4eac-afae-2279aeb312f1 | Okay. Okay. There was like a last minute showing request and I approved it and then I totally forgot about it. It was supposed to be between like 04:15 and five. | 0 | User | 10.169999666213982 | 17.499999666213995 |
| 6686 | Call About Missed House Showing 15affac1-294a-4eac-afae-2279aeb312f1 | Anyway, if they didn't come, they didn't come, that's fine. So k. I just thought if you were there, you'd know if anyway. Alright. That's yeah. K. K. Cool. Thank you. | 0 | User | 19.309999666213997 | 31.259999666213986 |
| 6687 | Call About Missed House Showing 15affac1-294a-4eac-afae-2279aeb312f1 | No problem. | 1 | Speaker 1 | 31.819999666213988 | 32.29999966621398 |
| 6688 | Call About Missed House Showing 15affac1-294a-4eac-afae-2279aeb312f1 | Problem. Alright. See you. Talk to you later. | 0 | User | 32.309999666214 | 33.750009666214 |
| 6689 | Call About Missed House Showing 15affac1-294a-4eac-afae-2279aeb312f1 | Bye. | 1 | Speaker 1 | 33.750009666214 | 34.229999666213985 |
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);