omi_transcript_segments
9 rows where conversation_id = "0d077d94-644d-4173-b8b3-3e08841bdec7"
This data as json, CSV (advanced)
Suggested facets: speaker_id, speaker_name
| id ▼ | conversation_id | text | speaker_id | speaker_name | start_time | end_time |
|---|---|---|---|---|---|---|
| 277450 | Anger Reveals Hidden Values 0d077d94-644d-4173-b8b3-3e08841bdec7 | Exploring it. Like, getting to the bottom of anger is enlightening. Right. Because usually there's some really powerful values at the bottom of it. | 0 | Speaker 0 | 2.479553222745068e-07 | 11.400000247955322 |
| 277451 | Anger Reveals Hidden Values 0d077d94-644d-4173-b8b3-3e08841bdec7 | Like something's being violated when we're angry. And to discover that about ourselves, why we're angry is really enlightening. | 0 | Speaker 0 | 13.440001247955323 | 23.480000247955324 |
| 277452 | Anger Reveals Hidden Values 0d077d94-644d-4173-b8b3-3e08841bdec7 | You can share it without being unkind in any way. | 0 | Speaker 0 | 29.119999247955324 | 33.96000024795532 |
| 277453 | Anger Reveals Hidden Values 0d077d94-644d-4173-b8b3-3e08841bdec7 | It takes a safe space to discover and understand it. And then you can share it. Like, oh, this makes me angry. Yeah. You can say it without any damage. Right. | 0 | Speaker 0 | 37.88000024795532 | 53.00000024795532 |
| 277454 | Anger Reveals Hidden Values 0d077d94-644d-4173-b8b3-3e08841bdec7 | It can be a Mhmm. | 0 | Speaker 0 | 57.80765919685467 | 59.647662196854675 |
| 277455 | Anger Reveals Hidden Values 0d077d94-644d-4173-b8b3-3e08841bdec7 | Oh, so anyway, I was crying, and then I was like, like, I wanted to scream. You know what I mean? Mhmm. And then I was like, and then it just like it like shifted inside me. | 1 | Speaker 1 | 84.82864682197686 | 98.10864682197686 |
| 277456 | Anger Reveals Hidden Values 0d077d94-644d-4173-b8b3-3e08841bdec7 | I was like, oh, I'm not sad. I'm angry. Keep trying to release this anger by crying about it. That's why it's not like, I'm not getting anywhere. I'm just circling the thing. Mhmm. I'm like, I'm mad. I'm I like I | 1 | Speaker 1 | 98.82864682197686 | 113.46864682197686 |
| 277457 | Anger Reveals Hidden Values 0d077d94-644d-4173-b8b3-3e08841bdec7 | I'm not okay that, like, this pattern with us. I'm okay with it. You know what I mean? I don't like it. I don't I don't like that I'm feel like I'm I have to, like, take it. You know what I mean? | 1 | Speaker 1 | 116.46864682197686 | 135.10864682197686 |
| 277458 | Anger Reveals Hidden Values 0d077d94-644d-4173-b8b3-3e08841bdec7 | Like, I have to accept it. To be in this relationship. I don't I don't like that. I don't like I don't like that I have | 1 | Speaker 1 | 135.38864682197686 | 143.14864682197685 |
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);