omi_transcript_segments

6 rows where conversation_id = "0ce90240-397e-463a-a066-c66d3161c5aa"

✎ 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
245970 Discussing Advanced Illness and Limited Options 0ce90240-397e-463a-a066-c66d3161c5aa She was young. And the calves had spread already to her. 1 User -1.9074292367804446e-07 5.8199998092570695
245971 Discussing Advanced Illness and Limited Options 0ce90240-397e-463a-a066-c66d3161c5aa Body and her blood. There's nothing and 3 Speaker 3 5.989999809257085 9.85999980925709
245972 Discussing Advanced Illness and Limited Options 0ce90240-397e-463a-a066-c66d3161c5aa I don't see any of your stuff, Katie. 3 Speaker 3 37.48942302703415 39.08942302703417
245973 Discussing Advanced Illness and Limited Options 0ce90240-397e-463a-a066-c66d3161c5aa Just for kiki. 0 Speaker 0 40.84942302703416 42.289423027034104
245974 Discussing Advanced Illness and Limited Options 0ce90240-397e-463a-a066-c66d3161c5aa And the cans spread already. 3 Speaker 3 43.1694230270341 123.5460923957794
245975 Discussing Advanced Illness and Limited Options 0ce90240-397e-463a-a066-c66d3161c5aa And there's nothing we can do about it now. 1 User 127.86609239577933 131.1460923957793

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);