omi_transcript_segments

2 rows where conversation_id = "0b2bad79-50fd-4302-97e9-d7848bcd56d4"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ conversation_id text speaker_id speaker_name start_time end_time
112417 Brief Phone Call About Bankruptcy Filing 0b2bad79-50fd-4302-97e9-d7848bcd56d4 Yes. Oh, yeah. 0 User 4.972686866722142e-07 1.700001497268687
112418 Brief Phone Call About Bankruptcy Filing 0b2bad79-50fd-4302-97e9-d7848bcd56d4 Yeah. Hi. Yes. I remember. I filed for bankruptcy yesterday. Yes. Yes. So yeah. K. Thank you. Yeah. Yeah. No problem. Okay. Bye bye. 1 Speaker 1 2.0600014972686864 20.540004497268683

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