omi_transcript_segments

6 rows where conversation_id = "e579e856-0cff-4385-8f09-0c5254788f7f"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speaker_id, speaker_name

id ▼ conversation_id text speaker_id speaker_name start_time end_time
29897 Family Chats About Running Shoes And Pets e579e856-0cff-4385-8f09-0c5254788f7f Yeah. The traffic coach says we should like to get better running in shoes that aren't really bad for running his, like, the best fit or So Okay. 1 Speaker 1 2.2888184503244702e-07 11.45995022888178
29898 Family Chats About Running Shoes And Pets e579e856-0cff-4385-8f09-0c5254788f7f Does he have a recommendation of what shoes you need? Ask him again today. 0 User 11.690000228881786 17.420030228881842
29899 Family Chats About Running Shoes And Pets e579e856-0cff-4385-8f09-0c5254788f7f Have him He said track spikes. But he or he said something, like, used to eventually get spikes, but if you're but not for a while, if you tell me, I know. Okay. 1 Speaker 1 17.500000228881845 27.080000228881886
29900 Family Chats About Running Shoes And Pets e579e856-0cff-4385-8f09-0c5254788f7f But, like so I guess just somehow, I think, she can always can get your pair of running shoes. 1 Speaker 1 28.06000022888179 31.340000228881877
29901 Family Chats About Running Shoes And Pets e579e856-0cff-4385-8f09-0c5254788f7f Get that useless little dog. 0 User 86.25000022888185 87.5299602288818
29902 Family Chats About Running Shoes And Pets e579e856-0cff-4385-8f09-0c5254788f7f Might as well be a cat on a leak 0 User 90.91000022888181 92.51000022888184

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);