omi_transcript_segments

17 rows where conversation_id = "131dbe1b-b4b3-4d1f-abe9-7fc275ba7596"

✎ 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
282929 Family Plans Overnight Childcare 131dbe1b-b4b3-4d1f-abe9-7fc275ba7596 I thought she was gonna drive her. Oh, yeah. K. It is warmer upstairs. Yeah. So I never go up there, so I don't think about it. 0 User 1.335144048653092e-07 136.1915042509309
282930 Family Plans Overnight Childcare 131dbe1b-b4b3-4d1f-abe9-7fc275ba7596 But, yeah, we can 0 User 136.23150525093092 137.0315042509309
282931 Family Plans Overnight Childcare 131dbe1b-b4b3-4d1f-abe9-7fc275ba7596 If John comes and stays at my house, we we have four beds for five people. So I will propose that Lindsay sleeps with me, my bed. And that was all that for me. 0 User 163.58801556587218 174.6680155658722
282932 Family Plans Overnight Childcare 131dbe1b-b4b3-4d1f-abe9-7fc275ba7596 No. I like, I'm not sure I've got two twin mattresses downstairs, but my boys are probably gonna sleep on those. I mean, we could. 0 User 176.5080145658722 183.0680155658722
282933 Family Plans Overnight Childcare 131dbe1b-b4b3-4d1f-abe9-7fc275ba7596 We could pull I don't know. We could pull one of those twins upstairs and let John sleep on that. Yeah. And then have one of my kids sleep on a mattress and one of them sleep on it. I've got a big love sack downstairs. 0 User 183.4180155658722 194.9480145658722
282934 Family Plans Overnight Childcare 131dbe1b-b4b3-4d1f-abe9-7fc275ba7596 Too. So do you have your kids do you not have your kids this weekend? I I have them both. 0 User 194.9980155658722 205.02801756587218
282935 Family Plans Overnight Childcare 131dbe1b-b4b3-4d1f-abe9-7fc275ba7596 Tracy's leaving Oh, that's right. 1 Speaker 1 205.59801556587217 206.3980135658722
282936 Family Plans Overnight Childcare 131dbe1b-b4b3-4d1f-abe9-7fc275ba7596 She's going on her honeymoon. I have them Yeah. From Tuesday till a week from Sunday. 0 User 206.3980135658722 211.1880155658722
282937 Family Plans Overnight Childcare 131dbe1b-b4b3-4d1f-abe9-7fc275ba7596 That's right. 2 Speaker 2 211.6280155658722 212.02801756587218
282938 Family Plans Overnight Childcare 131dbe1b-b4b3-4d1f-abe9-7fc275ba7596 That's gonna be a little awkward. With kids around? 0 User 215.1880155658722 225.5659558105478
282939 Family Plans Overnight Childcare 131dbe1b-b4b3-4d1f-abe9-7fc275ba7596 Yeah. 1 Speaker 1 225.5659558105478 226.0459558105478
282940 Family Plans Overnight Childcare 131dbe1b-b4b3-4d1f-abe9-7fc275ba7596 A little bit. 0 User 226.0459558105478 226.5259558105478
282941 Family Plans Overnight Childcare 131dbe1b-b4b3-4d1f-abe9-7fc275ba7596 I had forgotten when she first when Lindsay first proposed that weekend I didn't look at Tracy's summer schedule. Yeah. That she because Tracy had sent it to me, but I just didn't think to look at it. 0 User 230.0259558105478 240.8059618105478
282942 Family Plans Overnight Childcare 131dbe1b-b4b3-4d1f-abe9-7fc275ba7596 And I they've got some friends. We'll try and we'll try and, like, see if they can sleep over. At friend's house a little bit. 0 User 248.0249817820736 254.9049867820736
282943 Family Plans Overnight Childcare 131dbe1b-b4b3-4d1f-abe9-7fc275ba7596 If there's, like, a summer camp thing they can do. Because it's not just where people sleep, it's also like I need to kinda you know what I mean? I just wanna I wanna spend the time with then and Zoe. Yeah. And, also, I need to take care of my kids. Like, I don't wanna them for three days a row. Yeah. 0 User 258.8749867820736 287.6505327892278
282944 Family Plans Overnight Childcare 131dbe1b-b4b3-4d1f-abe9-7fc275ba7596 Yesterday, Sunday afternoon at three or four, it was empty. Was great. Oh, the big 0 User 314.5697125311983 388.15381978034316
282945 Family Plans Overnight Childcare 131dbe1b-b4b3-4d1f-abe9-7fc275ba7596 There's plenty of uncool women. 0 User 395.51381978034317 407.2771676444929

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