omi_transcript_segments

11 rows where conversation_id = "83aa9d72-52eb-48a6-9046-3b6bad994cc5"

✎ 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
24414 User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 I'm just gonna wait for you to come back. 0 User 4.357909801910864e-07 1.7600404357909838
24415 User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 So you understand the shape of things. What I'm doing now is waiting for you to come back. 0 User 4.9400404357910475 11.25000043579098
24416 User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 Come back. 2 Speaker 2 27.750040435790993 29.91004043579096
24417 User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 So if you want to come back, come back. 0 User 30.14004043579098 33.100040435791016
24418 User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 I've got plenty of work to do. 0 User 41.31004043579105 42.51007043579102
24419 User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 And what have it What if it tastes? And holy us, 0 User 94.77004043579097 100.98999043579101
24420 User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 Och. 2 Speaker 2 115.38004043579099 115.860040435791
24421 User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 And I have my work. To make her. I have work to do. I have a dragon to slay. I have a dragon to slay. Monkey on my back. I have a lifelong monkey on my back. 0 User 167.20008043579105 180.29004043579107
24422 User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 Are you not entertained? 0 User 220.360040435791 221.72004043579102
24423 User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 Not entertained? Are you not entertained? 0 User 234.84004043579102 239.640080435791
24424 User Reflects On Work And Inner Struggle 83aa9d72-52eb-48a6-9046-3b6bad994cc5 Describing myself. Describing myself. I can't walk up. 0 User 321.860040435791 326.83004043579103

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