omi_transcript_segments

4 rows where conversation_id = "31254262-1925-49d3-af76-f69d5945864e"

✎ 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
21959 Expressing Overwhelming Feelings of Loss 31254262-1925-49d3-af76-f69d5945864e You are my favorite thing in the world. I know you're gone. 0 User 3.242494130972773e-07 4.570200324249072
21960 Expressing Overwhelming Feelings of Loss 31254262-1925-49d3-af76-f69d5945864e Yeah. You're gone. Again. 1 Speaker 1 4.570200324249072 7.590000324249104
21961 Expressing Overwhelming Feelings of Loss 31254262-1925-49d3-af76-f69d5945864e If I'll cry, if I tell you, I really feel it. I can't contain my feelings. I tell you what I really feel. 1 Speaker 1 11.700000324249231 18.560100324249106
21962 Expressing Overwhelming Feelings of Loss 31254262-1925-49d3-af76-f69d5945864e I will cry if I tell you how I actually feel kidding. 1 Speaker 1 33.19000032424947 35.83000032424934

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