omi_transcript_segments
14 rows where conversation_id = "0308d873-fa97-4afb-8563-0014618d8fad"
This data as json, CSV (advanced)
Suggested facets: speaker_id, speaker_name
| id ▼ | conversation_id | text | speaker_id | speaker_name | start_time | end_time |
|---|---|---|---|---|---|---|
| 19047 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | How's it going? | 0 | User | -5.81741346650233e-07 | 0.9599994182586613 |
| 19048 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | What are you up to? | 1 | Speaker 1 | 1.599999418258676 | 3.4399994182586795 |
| 19049 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | I was just walking. Oh, why are you walking? | 0 | User | 3.4399994182586795 | 5.700009418258674 |
| 19050 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | How long you been up? | 0 | User | 11.809999418258656 | 12.769999418258664 |
| 19051 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | Okay. Is John still asleep? | 0 | User | 18.489999418258662 | 20.329999418258666 |
| 19052 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | I saw it before. The cats that were Really? Yeah. That one. | 1 | Speaker 1 | 28.96999941825868 | 34.799999418258665 |
| 19053 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | Kinda. His house is like a little more than right to block away from Martin's and pulled two of the that they have were outside. Yeah. And then also near, like, the | 1 | Speaker 1 | 37.93999941825868 | 51.63999941825864 |
| 19054 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | You're like to be kind to the outside where there's, like, where, like, the houses end if you just feel like, that way and then that way Uh-huh. | 1 | Speaker 1 | 56.91999941825867 | 66.47999941825867 |
| 19055 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | They're when I started to go back, there was a house that enters these there's this one cat that, like, came that walked from one side of the street to the other, so I followed it because I was curious. | 1 | Speaker 1 | 67.92997941825865 | 81.85999941825867 |
| 19056 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | Uh-huh. And then I saw another cat, and it was, like, scary. Yeah. | 1 | Speaker 1 | 82.12999941825865 | 85.88999941825864 |
| 19057 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | Okay. | 0 | User | 86.40999941825868 | 86.88999941825864 |
| 19058 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | So I saw, like, four cats. | 1 | Speaker 1 | 86.88999941825864 | 88.08997941825868 |
| 19059 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | It's a lot of cats? Yeah. In just a few minutes? I forgot I left my drink out here. | 0 | User | 89.15999941825868 | 95.77999941825868 |
| 19060 | Family Chat About Walk And Outdoor Plans 0308d873-fa97-4afb-8563-0014618d8fad | Also, Sharkey followed me Do you guys wanna go run around the track today? It's supposed to be, like, 55. | 0 | User | 108.09999941825868 | 112.8299994182587 |
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);