omi_transcript_segments
8 rows where conversation_id = "0d047ae2-fb6c-49e1-a773-ecca2dadfd4d"
This data as json, CSV (advanced)
Suggested facets: speaker_id, speaker_name
| id ▼ | conversation_id | text | speaker_id | speaker_name | start_time | end_time |
|---|---|---|---|---|---|---|
| 83911 | Childhood Self-Image and Attractiveness Reflections 0d047ae2-fb6c-49e1-a773-ecca2dadfd4d | Yeah. I mean, I do like, I still wanna go. | 1 | Speaker 1 | -2.288843461428769e-07 | 2.5599947711157256 |
| 83912 | Childhood Self-Image and Attractiveness Reflections 0d047ae2-fb6c-49e1-a773-ecca2dadfd4d | Because my personal they are they just say that because I thought I was not, like, when I was allowed to be, like, When you were how old? | 1 | Speaker 1 | 129.74762603759427 | 151.56485278129094 |
| 83913 | Childhood Self-Image and Attractiveness Reflections 0d047ae2-fb6c-49e1-a773-ecca2dadfd4d | You think you were ugly? | 0 | User | 152.08485278129092 | 154.08485278129092 |
| 83914 | Childhood Self-Image and Attractiveness Reflections 0d047ae2-fb6c-49e1-a773-ecca2dadfd4d | Like if I look back at a picture of, like, six year old me, I'll be like, that kid is ugly. It's not really true. | 1 | Speaker 1 | 155.4548527812908 | 162.6048527812909 |
| 83915 | Childhood Self-Image and Attractiveness Reflections 0d047ae2-fb6c-49e1-a773-ecca2dadfd4d | Just, like, I think it's I was gonna say you've never been. You've always been a good looking kid. | 0 | User | 165.03486278129094 | 167.43485278129083 |
| 83916 | Childhood Self-Image and Attractiveness Reflections 0d047ae2-fb6c-49e1-a773-ecca2dadfd4d | That's probably easy. It's probably just the fact that I, like, know on my skin. It's like, I feel like no one was scared. | 1 | Speaker 1 | 169.04484278129098 | 177.04485278129096 |
| 83917 | Childhood Self-Image and Attractiveness Reflections 0d047ae2-fb6c-49e1-a773-ecca2dadfd4d | Like, how old? | 0 | User | 179.04485278129096 | 179.92485278129084 |
| 83918 | Childhood Self-Image and Attractiveness Reflections 0d047ae2-fb6c-49e1-a773-ecca2dadfd4d | Like, anywhere from zero to 12. | 1 | Speaker 1 | 181.04485278129096 | 183.2048527812908 |
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);