omi_transcript_segments
5 rows where conversation_id = "99dea856-bd33-4aa4-856c-77f430932b57"
This data as json, CSV (advanced)
Suggested facets: speaker_id, speaker_name
| id ▼ | conversation_id | text | speaker_id | speaker_name | start_time | end_time |
|---|---|---|---|---|---|---|
| 20770 | Planning Next Costco Grocery Trip 99dea856-bd33-4aa4-856c-77f430932b57 | Those nuggets are from Costco, boys. So remind me when I go to Costco, next time. I'm gonna go to get protein or fair lives or whatever. | 0 | User | -2.424621641239355e-07 | 7.769989757537843 |
| 20771 | Planning Next Costco Grocery Trip 99dea856-bd33-4aa4-856c-77f430932b57 | That I should get stock up. On my nuggets. | 0 | User | 7.829989757537845 | 12.299999757537847 |
| 20772 | Planning Next Costco Grocery Trip 99dea856-bd33-4aa4-856c-77f430932b57 | Wait. Where do you normally get this from? | 1 | Speaker 1 | 13.499999757537836 | 15.729989757537851 |
| 20773 | Planning Next Costco Grocery Trip 99dea856-bd33-4aa4-856c-77f430932b57 | And I normally get the tenders from Hermits. And I'm guessing they're a lot cheaper. I guess they're a lot cheaper from | 0 | User | 15.729989757537851 | 24.629989757537828 |
| 20774 | Planning Next Costco Grocery Trip 99dea856-bd33-4aa4-856c-77f430932b57 | Gonna hop out and give you guys a hug. | 0 | User | 131.89998975753787 | 133.76000975753783 |
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);