omi_transcript_segments
23 rows where conversation_id = "0d6c6a96-e448-42d6-b957-71cbe659ba07"
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
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);