omi_transcript_segments

2 rows where conversation_id = "0efdc353-8d36-475f-a0e6-80dc46ae978e"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ conversation_id text speaker_id speaker_name start_time end_time
128981 User Questions Pointless Traffic Signal 0efdc353-8d36-475f-a0e6-80dc46ae978e That's pointless. The red light? Yeah. Because there's a green there's green lights there and there, but there's no roads in either place. 0 User -2.3841818119763047e-07 326.2939324283605
128982 User Questions Pointless Traffic Signal 0efdc353-8d36-475f-a0e6-80dc46ae978e I'm gonna ignore it. I'll be just testing it, like, just running it through it. Paces. 0 User 329.57393242836054 336.0062718486794

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