omi_transcript_segments
10 rows where conversation_id = "0073d66e-0375-472d-ab87-40cdf5e9e84a"
This data as json, CSV (advanced)
Suggested facets: speaker_id, speaker_name
| id ▼ | conversation_id | text | speaker_id | speaker_name | start_time | end_time |
|---|---|---|---|---|---|---|
| 331847 | Melodramatic lyrics about the edge of the world 0073d66e-0375-472d-ab87-40cdf5e9e84a | Oh say say oh say i don't love you like i love you wait they don't love you like i love you wait they don't love you like i love you sweet they don't love you like i love you this is it. | 0 | Speaker 0 | -57.0 | -18.04 |
| 331848 | Melodramatic lyrics about the edge of the world 0073d66e-0375-472d-ab87-40cdf5e9e84a | Off the edge of the world. | 0 | Speaker 0 | 0.0 | 2.0 |
| 331849 | Melodramatic lyrics about the edge of the world 0073d66e-0375-472d-ab87-40cdf5e9e84a | I like melodramatic. | 1 | Speaker 1 | 5.8399999141693115 | 7.8399999141693115 |
| 331850 | Melodramatic lyrics about the edge of the world 0073d66e-0375-472d-ab87-40cdf5e9e84a | I'm melodramatic. | 2 | Speaker 2 | 7.920000076293945 | 9.440000076293945 |
| 331851 | Melodramatic lyrics about the edge of the world 0073d66e-0375-472d-ab87-40cdf5e9e84a | I am melodramatic. | 1 | Speaker 1 | 9.759999990463257 | 11.679999990463257 |
| 331852 | Melodramatic lyrics about the edge of the world 0073d66e-0375-472d-ab87-40cdf5e9e84a | Hang it in the sun. bow your heads the absence of nuns dark places. | 3 | Speaker 3 | 13.200000047683716 | 32.80000004768371 |
| 331853 | Melodramatic lyrics about the edge of the world 0073d66e-0375-472d-ab87-40cdf5e9e84a | And the kids fly out, spitting off the edge of the world. | 4 | Speaker 4 | 48.640000104904175 | 54.320000104904175 |
| 331854 | Melodramatic lyrics about the edge of the world 0073d66e-0375-472d-ab87-40cdf5e9e84a | Bow may it had no chance. | 0 | Speaker 0 | 60.0 | 63.36 |
| 331855 | Melodramatic lyrics about the edge of the world 0073d66e-0375-472d-ab87-40cdf5e9e84a | Man had no chance. | 1 | Speaker 1 | 77.27999997138977 | 79.35999997138977 |
| 331856 | Melodramatic lyrics about the edge of the world 0073d66e-0375-472d-ab87-40cdf5e9e84a | That's good. | 2 | Speaker 2 | 104.64000010490417 | 105.36000010490417 |
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);