omi_transcript_segments
32 rows where conversation_id = "16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e"
This data as json, CSV (advanced)
Suggested facets: speaker_id, speaker_name
| id ▼ | conversation_id | text | speaker_id | speaker_name | start_time | end_time |
|---|---|---|---|---|---|---|
| 92774 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | in progress. | 1 | Speaker 1 | 3.719329839668717e-07 | 0.6400003719329845 |
| 92775 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | Yes, I can hear you. Hi Tyler. | 0 | User | 51.112481899261475 | 85.45717277798471 |
| 92776 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | Nice to meet you. | 1 | Speaker 1 | 87.4171747779847 | 88.1371737779847 |
| 92777 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | Nice to meet you. I should be joined by Ryan here. So Here he is. Hey. Sorry. Who's wrapping up a conversation. No problem. Why we start with a little introduction I'm Tyler. | 0 | User | 88.1371737779847 | 106.69717477798471 |
| 92778 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | I lead desktop. I IOX, Android engineers here at Cricket. We have a we have a search team, so there's a lot of different places you can search for content in our main app. Application. So we maintain and build the features for that side of things. | 1 | Speaker 1 | 106.88717477798471 | 124.0571747779847 |
| 92779 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | The content content discovery side. And then we're gonna create it for about gosh. I think it's over four years now. So this is Ryan. | 1 | Speaker 1 | 124.57717477798471 | 135.2771807779847 |
| 92780 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | Hi, Ryan. I am on the subscriptions and commerce team. | 0 | User | 135.97717477798471 | 140.05717977798471 |
| 92781 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | The mobile lead I've been a quicker for just over a year. We handle everything for the in app purchases and subscriptions. Through all all the platforms. | 2 | Speaker 2 | 142.4971747779847 | 152.6571697779847 |
| 92782 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | Okay. | 0 | User | 154.05717977798471 | 154.3771787779847 |
| 92783 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | Doing I I kinda got into I I was playing around with game development, and so I learned And that kind of dovetailed into doing a lot of video processing and image processing apps where I was building shader based filters to do kind of live some some GPU and some shader stuff live edits on video. | 1 | Speaker 1 | 203.1392004776001 | 207.6192002776001 |
| 92784 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | So like real time video editing and stuff like that. Sure. So that was kind of my little niche for a long time. That was mostly what I did. I mean, I would any app has your standard UI stuff that it needs, it was always I always almost got hired or or brought on to to fix their video pipeline issues. And then and then Right. Once I was in there, they'd have me whatever, do whatever what's next. Right? | 0 | User | 225.62799710409547 | 251.54800010409545 |
| 92785 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | That's cool. That's an interesting area. Thanks for taking us in. Yeah. It was really fun. I really liked it. It was low level enough that it was Sure. Yeah. | 0 | User | 253.10799810409546 | 263.66799810409543 |
| 92786 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | You got to know a little bit about the hardware Yeah. And the software side. But Yeah. | 0 | User | 263.90799810409544 | 268.5479981040954 |
| 92787 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | We do have cricket's a big team, and we have lots of different people working on different things. We do have a we have a a shared layer between all our clients, which is, like, handling the heavy lifting for our canvas piece Uh-huh. | 1 | Speaker 1 | 270.71798810409547 | 281.75799810409546 |
| 92788 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | Which is basically a a big vector application. | 1 | Speaker 1 | 282.38799810409546 | 285.50799810409546 |
| 92789 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | So Yeah. | 0 | User | 285.9179981040955 | 286.2379981040955 |
| 92790 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | They're they're doing a lot of vector operations. They're also doing on images, and I don't think so as I know, they're not doing anything on video. But those are the guy those are the people in Cricket that kind of deal with, you know, the hardcore image processing and then performance and things like that. | 1 | Speaker 1 | 286.31799810409547 | 302.3279881040955 |
| 92791 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | So Yeah. | 0 | User | 302.56799810409547 | 302.8079981040955 |
| 92792 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | Yeah. | 1 | Speaker 1 | 303.18799810409547 | 303.4279981040955 |
| 92793 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | That makes sense. That makes sense. Yeah. | 0 | User | 303.8679931040955 | 305.78798810409546 |
| 92794 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | Cool. I'm curious to a lot of I think I think I haven't looked at the job listing, and I the cricket post for this now, but for this position, we're cricket's usually looking for, you know, mentoring and opportunities too. Like, quite a few of our engineers who work locally they have an expertise in, like, a particular platform Mhmm. Like back end or desktop or Android or whatever else. | 1 | Speaker 1 | 307.18799810409547 | 339.2379981040955 |
| 92795 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | But most of them also do to, like, mentor and lead. All types of engineers. Make the use of a lot of contractors. Mhmm. And so this position, it probably happen right away. But this is what cricket is really looking for to, like, lead and mentor people for all different tech parts of the tech stack. So tell us a little bit of your, like, leadership experience and how you mentored it and and, you collaborated with other engineers. | 1 | Speaker 1 | 340.26799810409545 | 367.6279881040955 |
| 92796 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | Yeah. Yeah. Sure. | 0 | User | 367.6279881040955 | 368.50799810409546 |
| 92797 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | I have mostly worked with small teams. But for a while now, I've been kind of the the old guy, you know. I've been doing it longer. Sure. | 0 | User | 371.5479981040954 | 378.7279981040955 |
| 92798 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | And I think the probably the best example I was at a company called Crikey for a while. They were start up out of San Francisco. | 0 | User | 379.26799810409545 | 388.17798810409545 |
| 92799 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | They were a little bit larger. They had like 20 people and we had Mhmm. We had internal back end people and and iOS and Android and it was a we were using Unity inside of an inside of iOS or Android, so we we had Unity people as well. | 0 | User | 388.62799810409547 | 403.3579981040955 |
| 92800 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | My job fits into the company's mission and everybody else kinda fits together. | 0 | User | 455.18781591415404 | 459.80781591415405 |
| 92801 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | I'm curious about how just authority and responsibility and personalities and like ideologies fit together because you got | 0 | User | 460.5278159141541 | 479.0717181491852 |
| 92802 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | Yeah. I've I've done things long enough to kind of | 0 | User | 541.9236660003662 | 544.6436660003662 |
| 92803 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | guess where things could break down | 0 | User | 545.5936658003662 | 546.9536657003662 |
| 92804 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | Down and kinda step in and be like, what do you guys think about this? | 0 | User | 560.3213934476013 | 562.8213939476013 |
| 92805 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | There was one client where | 0 | User | 651.484172706604 | 673.2766315841675 |
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);