omi_transcript_segments

12 rows where conversation_id = "83a1081f-a954-47d9-bf69-d99cc1447e32"

✎ 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
29878 Tired User Debates App Work Versus Napping 83a1081f-a954-47d9-bf69-d99cc1447e32 Got it. I give a shit what you think. I don't give a shit what you think. So you can say whatever you want. Say what you want. 0 User 7.133485269150697e-08 11.500200071334802
29879 Tired User Debates App Work Versus Napping 83a1081f-a954-47d9-bf69-d99cc1447e32 How's it going? 0 User 107.49020007133504 107.97020007133506
29880 Tired User Debates App Work Versus Napping 83a1081f-a954-47d9-bf69-d99cc1447e32 Do you wanna try and work on that app? 0 User 114.54020007133477 116.06020007133475
29881 Tired User Debates App Work Versus Napping 83a1081f-a954-47d9-bf69-d99cc1447e32 I'm feeling pretty tired too, but that would that particular task appeals to me. What's that? Yeah. So I would have the wherewithal to do that. The things that I probably should be doing I do not have the will to do at this moment. 0 User 121.1502000713349 135.38040007133486
29882 Tired User Debates App Work Versus Napping 83a1081f-a954-47d9-bf69-d99cc1447e32 I was doing a very similar thing in the the car. 0 User 155.77020007133478 157.89020007133468
29883 Tired User Debates App Work Versus Napping 83a1081f-a954-47d9-bf69-d99cc1447e32 Yeah. What book are you in now? 0 User 163.47020007133506 166.43040007133504
29884 Tired User Debates App Work Versus Napping 83a1081f-a954-47d9-bf69-d99cc1447e32 Remind me what it was you wanted to do. 0 User 180.39040007133462 182.31020007133475
29885 Tired User Debates App Work Versus Napping 83a1081f-a954-47d9-bf69-d99cc1447e32 Oh, workout tracker. 0 User 192.29000007133482 194.69020007133486
29886 Tired User Debates App Work Versus Napping 83a1081f-a954-47d9-bf69-d99cc1447e32 Oh, yeah. 2 Speaker 2 194.69020007133486 195.01000007133462
29887 Tired User Debates App Work Versus Napping 83a1081f-a954-47d9-bf69-d99cc1447e32 Should we just take a nap instead? Not together, but at the same time, separately. 0 User 231.33020007133473 235.6302000713349
29888 Tired User Debates App Work Versus Napping 83a1081f-a954-47d9-bf69-d99cc1447e32 I woke up early to not get back to sleep. 0 User 240.04020007133477 242.52020007133478
29889 Tired User Debates App Work Versus Napping 83a1081f-a954-47d9-bf69-d99cc1447e32 Maybe thirty minutes. Sixty minutes. Of a nap? Yeah. Yeah. Where did my my case go? I must be in the car. 0 User 260.2900000713348 272.8802000713349

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