omi_transcript_segments

3 rows where conversation_id = "1757a9f6-025c-42ce-a025-fa91f184e301"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ conversation_id text speaker_id speaker_name start_time end_time
70383 Casual Chat About Food And Studying 1757a9f6-025c-42ce-a025-fa91f184e301 It got sleepy. 3 Speaker 3 0.4000099904619674 178.73092764854528
70384 Casual Chat About Food And Studying 1757a9f6-025c-42ce-a025-fa91f184e301 So I'm actually has like, 90, same hauls and, like, he has That's correct. 1 Speaker 1 183.13093764854534 195.89092764854536
70385 Casual Chat About Food And Studying 1757a9f6-025c-42ce-a025-fa91f184e301 He has ninety studying the safety of got him here for all of Do you guys want a pizza? Yes. You're hungry? K. 0 User 226.89953749657343 231.84953749657348

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