home / saraphina

omi_transcript_segments

2 rows where conversation_id = "17605f8c-0a2b-4036-9c47-123cfecec426"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ conversation_id text speaker_id speaker_name start_time end_time
6681 Clarifying Whether Items Must Stay 17605f8c-0a2b-4036-9c47-123cfecec426 Do they need to stay? Ask them. Ask them. I'm I'm just too 0 User 1.693724698270671e-07 4.239900169372504
6682 Clarifying Whether Items Must Stay 17605f8c-0a2b-4036-9c47-123cfecec426 Do they do they need them? 0 User 13.82990016937265 15.179900169372559

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.311ms