omi_transcript_segments

1 row where conversation_id = "08a90a27-c4dc-4570-a536-c17a153004f8"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ conversation_id text speaker_id speaker_name start_time end_time
84263 User Plans Feeding the Cats 08a90a27-c4dc-4570-a536-c17a153004f8 Did you what? Did we feed cats yesterday? We didn't. Should we go do that? In a few minutes? 0 User 4.972686724613595e-07 5.98000149726866

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