home / saraphina

omi_transcript_segments

14 rows where conversation_id = "9ac3824d-ebce-4847-b70e-f9bc3f3a75da"

✎ View and edit SQL

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

CSV options:

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);
Powered by Datasette · Queries took 4.394ms