omi_transcript_segments

16 rows where conversation_id = "14096228-b53d-42d4-b67a-33e0f84dd5b4"

✎ 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
143395 Casual Chat About Fasting And Diet Soda 14096228-b53d-42d4-b67a-33e0f84dd5b4 I just 0 User -3.8146975356312396e-08 0.35999996185302763
143396 Casual Chat About Fasting And Diet Soda 14096228-b53d-42d4-b67a-33e0f84dd5b4 They're too big? 0 User 11.439999961853026 12.239999961853023
143397 Casual Chat About Fasting And Diet Soda 14096228-b53d-42d4-b67a-33e0f84dd5b4 I'm I'm fasting. 0 User 18.919999961853023 20.27999996185303
143398 Casual Chat About Fasting And Diet Soda 14096228-b53d-42d4-b67a-33e0f84dd5b4 On day The most We actually better after I No. We're not doing it. Like, a week later, I'm, oh, I feel Becky does a better time. Yeah. Supposed to, like, get reinsured cell and, like, reset your blood blood glucose stuff. So you just drink water? Yeah. 1 Speaker 1 27.83999796185303 41.83999796185303
143399 Casual Chat About Fasting And Diet Soda 14096228-b53d-42d4-b67a-33e0f84dd5b4 Like, a leg? Yeah. 2 Speaker 2 41.999997961853026 42.719999961853034
143400 Casual Chat About Fasting And Diet Soda 14096228-b53d-42d4-b67a-33e0f84dd5b4 Like, I'd like, soda too. Because I the caffeine is, like, my normal stuff. 1 Speaker 1 42.95999996185303 47.64000496185302
143401 Casual Chat About Fasting And Diet Soda 14096228-b53d-42d4-b67a-33e0f84dd5b4 Okay. 2 Speaker 2 48.03999996185303 48.35999996185302
143402 Casual Chat About Fasting And Diet Soda 14096228-b53d-42d4-b67a-33e0f84dd5b4 But I just no calories. I lose, like, three or four or five pounds and We're diet's sort of choice? Diet Doctor Pepper. 1 Speaker 1 48.35999996185302 56.71999996185302
143403 Casual Chat About Fasting And Diet Soda 14096228-b53d-42d4-b67a-33e0f84dd5b4 Diet Doctor Pepper with Diet Coke. I love Diet Doctor Pepper. 0 User 60.30999996185301 62.78999996185303
143404 Casual Chat About Fasting And Diet Soda 14096228-b53d-42d4-b67a-33e0f84dd5b4 Free free people down here. This is not a whole 4 Speaker 4 66.39999996185301 67.67999996185301
143405 Casual Chat About Fasting And Diet Soda 14096228-b53d-42d4-b67a-33e0f84dd5b4 Hey. You're good. 3 Speaker 3 113.58716285705214 148.58098352292927
143406 Casual Chat About Fasting And Diet Soda 14096228-b53d-42d4-b67a-33e0f84dd5b4 How are you doing? Good. 1 Speaker 1 148.58098352292927 149.82098952292927
143407 Casual Chat About Fasting And Diet Soda 14096228-b53d-42d4-b67a-33e0f84dd5b4 Let me see here here. 0 User 150.78098952292925 151.42098952292926
143408 Casual Chat About Fasting And Diet Soda 14096228-b53d-42d4-b67a-33e0f84dd5b4 Oh, perfect. How has you been? I've been good. Good. 1 Speaker 1 151.42098952292926 218.7667565441078
143409 Casual Chat About Fasting And Diet Soda 14096228-b53d-42d4-b67a-33e0f84dd5b4 How are you? Good. Yeah? 3 Speaker 3 218.7667565441078 220.2067565441078
143410 Casual Chat About Fasting And Diet Soda 14096228-b53d-42d4-b67a-33e0f84dd5b4 Yeah. Yeah. Is this a thing? 1 Speaker 1 220.2067565441078 319.087108745569

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