home / saraphina

omi_transcript_segments

23 rows where conversation_id = "0d6c6a96-e448-42d6-b957-71cbe659ba07"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: text, speaker_id, speaker_name

id ▼ conversation_id text speaker_id speaker_name start_time end_time
20072 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 Do I want one? Sure. 11 Speaker 11 2.9600004386902583 4.7900004386901855
20073 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 Okay. 1 Speaker 1 4.7900004386901855 5.190100438690024
20074 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 What color? 9 Speaker 9 5.98000043869024 6.300000438690404
20075 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 What colors are what are my options? 6 Speaker 6 6.630000438690331 8.630000438690331
20076 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 Blue. 9 Speaker 9 13.800000438690404 14.040000438690186
20077 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 K. See. 6 Speaker 6 18.590000438690367 18.590000438690367
20078 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 Light low. 6 Speaker 6 28.70000043869004 29.260000438689985
20079 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 Alright. 9 Speaker 9 37.70000043869004 38.18000043869006
20080 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 Eighteen o'clock? 1 Speaker 1 38.72000043869002 39.84000043869037
20081 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 Yes. 9 Speaker 9 39.84000043869037 40.240000438690004
20082 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 I don't know. What do you want me to like, do? 9 Speaker 9 45.990000438690004 47.910000438690076
20083 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 You do the things you have to do before you do screen? 1 Speaker 1 49.71000043869026 52.19000043869028
20084 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 Is that a good way to ask that? 12 Speaker 12 55.26020043869039 56.62000043869011
20085 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 Yeah. 9 Speaker 9 57.020000438690204 58.22000043869002
20086 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 Okay. 2 Speaker 2 58.22000043869002 59.89990043869011
20087 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 I totally forgot about that. Sorry. 9 Speaker 9 59.89990043869011 63.38990043869035
20088 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 Yeah. 9 Speaker 9 66.86000043869035 67.90000043869031
20089 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 And there's the one minute warning. 11 Speaker 11 69.0200004386902 70.78000043868997
20090 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 Okay. 8 Speaker 8 70.78000043868997 71.0200004386902
20091 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 It's five to two. 11 Speaker 11 71.72000043869002 72.76000043868999
20092 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 K. K. Kiddos, it's a school night. Come in to the bathroom. 10 Speaker 10 87.14990043869011 90.51000043868999
20093 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 So let me know what's 9 Speaker 9 109.83980043868996 110.87980043869038
20094 Family Prepares For School Night Routine 0d6c6a96-e448-42d6-b957-71cbe659ba07 So Ja? 0 User 198.8700004386901 199.19000043868982

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);
Powered by Datasette · Queries took 7.349ms