omi_transcript_segments
18 rows where conversation_id = "03a8f645-9338-40b8-9338-fd594ff23d71"
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 |
|---|---|---|---|---|---|---|
| 140941 | Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 | What'd you say? | 0 | User | -6.675554686808027e-08 | 122.16559337616218 |
| 140942 | Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 | Imagine a ride. | 2 | Speaker 2 | 122.60559337616178 | 123.56559337616181 |
| 140943 | Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 | Been odd. Or Well, I I ran around the track a few weeks ago. A week or two ago. Okay. I haven't been jogging in the morning. I have When was the last time you, like, jumped to me? | 0 | User | 151.69301403999634 | 161.28302403999623 |
| 140944 | Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 | Air? | 2 | Speaker 2 | 162.52301403999627 | 163.16302403999634 |
| 140945 | Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 | I've been jumping a little bit too. I been, like practicing jumping. Because my jumps are, like, weak. Probably a couple weeks ago too for that, I jumped. | 1 | Speaker 1 | 163.40301403999638 | 172.80301403999647 |
| 140946 | Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 | Okay. Yeah. I can jump higher than like, the same | 2 | Speaker 2 | 172.8830140399964 | 175.96301403999632 |
| 140947 | Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 | Yeah. | 0 | User | 176.20301403999656 | 176.44302403999654 |
| 140948 | Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 | Was even like like, was even larger in eighth grade because I could touch Really? Wow. I did it once in my class, and I now I can't do anything. | 2 | Speaker 2 | 176.84301403999643 | 189.70388855935062 |
| 140949 | Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 | Anymore. | 2 | Speaker 2 | 189.78388855935054 | 190.18388855935063 |
| 140950 | Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 | Well, you should learn to dunk a basketball then. | 0 | User | 192.30387855935032 | 194.86387855935027 |
| 140951 | Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 | Yeah. But back in the Can you can you basketball thing. One of my coaches said he you palm a basketball? | 2 | Speaker 2 | 195.2238885593506 | 199.42388855935042 |
| 140952 | Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 | Like, yearly, but it, like, falls out of my hand. | 2 | Speaker 2 | 205.86388855935047 | 208.66387855935045 |
| 140953 | Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 | If you get so you can a basketball and you can jump that high, that should be pretty easy for you to dunk. | 0 | User | 212.94415087701282 | 217.32415087701293 |
| 140954 | Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 | That's fun. Do you wanna do some more basketball stuff? I don't know. | 0 | User | 221.4241408770131 | 227.6210867500463 |
| 140955 | Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 | Your height would make you, like, kind of a strong player if you decided you were interested in that again. | 1 | Speaker 1 | 228.42108675004647 | 231.90106675004654 |
| 140956 | Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 | Do you need to pee? Do you have an infection? Sometimes bladders get infected. | 0 | User | 239.26108675004616 | 246.77304906845893 |
| 140957 | Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 | Piano bucks? Laptops, retainers. K? For both you and Good to more than five minutes. | 0 | User | 250.6630690684592 | 310.4178934478782 |
| 140958 | Family Chat About Jumping and Basketball 03a8f645-9338-40b8-9338-fd594ff23d71 | Yeah. | 2 | Speaker 2 | 311.05787344787814 | 312.97789344787816 |
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);