omi_transcript_segments

9 rows where conversation_id = "03ffca0a-5796-48a4-a649-2598d11b03c4"

✎ 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
200069 Yard Work Weed Spraying Instructions 03ffca0a-5796-48a4-a649-2598d11b03c4 That's about as far as I would do K. Eyes. You wanna get these Yeah. There doesn't But if you're not ready to go, yeah, maybe we can spray all the brod leaf k. 5 User -1.700409484328702e-07 479.95709400341184
200070 Yard Work Weed Spraying Instructions 03ffca0a-5796-48a4-a649-2598d11b03c4 I got a few more minutes. 0 User 482.757094003412 484.03709400341177
200071 Yard Work Weed Spraying Instructions 03ffca0a-5796-48a4-a649-2598d11b03c4 Yeah. Just then. 5 User 484.71729400341246 485.6770940034121
200072 Yard Work Weed Spraying Instructions 03ffca0a-5796-48a4-a649-2598d11b03c4 Which one? 2 Speaker 2 491.60855798886405 492.2485579888653
200073 Yard Work Weed Spraying Instructions 03ffca0a-5796-48a4-a649-2598d11b03c4 And what? 5 User 493.96855798886463 494.60855798886405
200074 Yard Work Weed Spraying Instructions 03ffca0a-5796-48a4-a649-2598d11b03c4 Harm the law. I'll start with this one. Okay. You went out. Okay. 5 User 501.9956097882632 520.5657924382631
200075 Yard Work Weed Spraying Instructions 03ffca0a-5796-48a4-a649-2598d11b03c4 And I'm what? Spraying everything or just the wheat? Just the, like, dandelions and stuff? 4 User 521.3257924382624 524.2059924382629
200076 Yard Work Weed Spraying Instructions 03ffca0a-5796-48a4-a649-2598d11b03c4 Dandelions and anything that's not grass. 5 User 525.0357924382624 526.2357924382632
200077 Yard Work Weed Spraying Instructions 03ffca0a-5796-48a4-a649-2598d11b03c4 Okay. 0 User 526.2357924382632 526.7957924382627

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