omi_transcript_segments
14 rows where conversation_id = "9ac3824d-ebce-4847-b70e-f9bc3f3a75da"
This data as json, CSV (advanced)
Suggested facets: speaker_id, speaker_name
| id ▼ | conversation_id | text | speaker_id | speaker_name | start_time | end_time |
|---|---|---|---|---|---|---|
| 24541 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | That's the three Is this just three o'clock? Yeah. | 0 | User | 2.5749204723979346e-07 | 2.0000002574920472 |
| 24542 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | No. | 0 | User | 10.830000257492088 | 11.07000025749204 |
| 24543 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | Please remember to | 0 | User | 69.69000025749204 | 70.57000025749204 |
| 24544 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | Good. | 0 | User | 79.36000025749206 | 79.76000025749204 |
| 24545 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | Well, someone fucking So somebody broke my fucking heart. | 0 | User | 117.64000025749209 | 121.93000025749205 |
| 24546 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | I was heartbroken, you bitch. | 0 | User | 131.2000002574921 | 133.44000025749204 |
| 24547 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | Was heartbroken, you bitch. | 1 | Speaker 1 | 138.73998025749205 | 140.10000025749207 |
| 24548 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | I've read the whole fucking Cosmere. | 0 | User | 146.67000025749206 | 148.67000025749206 |
| 24549 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | Because I got divorced. | 0 | User | 151.8300002574921 | 153.19002025749205 |
| 24550 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | Dumb bitch. You you're like, what is wrong with you? | 1 | Speaker 1 | 159.36998025749205 | 168.07000025749204 |
| 24551 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | Somebody broke my heart. | 1 | Speaker 1 | 190.88000025749204 | 195.57000025749204 |
| 24552 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | Well, sometimes when I'm heartbroken, I read. | 0 | User | 197.57998025749208 | 202.42998025749205 |
| 24553 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | Well, | 1 | Speaker 1 | 214.48000025749207 | 214.88000025749204 |
| 24554 | Processing Heartbreak Through Reading 9ac3824d-ebce-4847-b70e-f9bc3f3a75da | Wow. | 1 | Speaker 1 | 293.8200002574921 | 294.22005025749206 |
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);