omi_transcript_segments

18 rows where conversation_id = "175ccd70-396e-44ba-be7a-bbd35a2167a1"

✎ 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
120403 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 Do we wanna, cut this this piece of baseboard this? 0 User 2.0431528469089244e-08 67.96287836074829
120404 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 Are you planning on putting that back in, and are you put it back in once after it's all we'll get a 0 User 71.64287836074828 143.69674811363228
120405 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 It might be easier to put it back in now if we're putting it back in at all. 0 User 147.6667481136323 163.32233296530177
120406 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 Wow. 0 User 173.8905310821537 174.3705310821537
120407 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 Can we just tuck it in? 1 Speaker 1 174.3705310821537 175.25053108215369
120408 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 Oh, is that what you're thinking? Was thinking we'd flip the cabinet upside down and, like, actually my nail it or something, glue it, put it back in. Shut it in. Okay. Shut it in. Yeah. 0 User 176.19053408215368 186.36053108215367
120409 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 A little bit of tension around this, Jake. 1 Speaker 1 236.19632126808168 237.95632126808167
120410 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 You and me? 0 User 238.27632126808166 238.67632026808167
120411 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 You're not you haven't driven out here yet. Okay. 0 User 270.22650933265686 273.8265093326569
120412 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 Okay. 0 User 291.35325346128843 291.6732544612885
120413 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 I I I I may I mean, I just wanted to see if Okay. 1 Speaker 1 292.25325446128846 294.81325446128847
120414 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 Alright. Bye. 0 User 326.03325176239014 327.6632516623901
120415 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 You good with that? Yeah. Thank you. 0 User 359.83988151686106 362.5598825168611
120416 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 Yeah. I don't know why there's a stud here. A stud there. Yep. 0 User 439.7119403089752 468.14834451675426
120417 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 Good. We wanna close this gap, are we good? 0 User 472.02834451675426 502.0999961280826
120418 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 And I didn't close the gap is because the back is broken. And that attachment's not so having that more secure to the back than to the cabinet is 2 Speaker 2 505.9499961280826 534.3820516014104
120419 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 Preferable? 0 User 535.0220556014103 535.6620546014103
120420 Jake and Team Adjust Kitchen Cabinet Baseboard 175ccd70-396e-44ba-be7a-bbd35a2167a1 Not can not productive. 2 Speaker 2 536.1420536014103 538.0220516014103

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