omi_transcript_segments

8 rows where conversation_id = "e401eb62-983b-4113-9f27-0963cffd37e9"

✎ 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
76815 User Heads to Katie’s Construction Project e401eb62-983b-4113-9f27-0963cffd37e9 Hey, guys. What? I'm gonna go back over to Katie's. I'm helping her with a construction project. She's like re building one of her rooms. 0 User 9.400969247508328e-08 6.32999609400963
76816 User Heads to Katie’s Construction Project e401eb62-983b-4113-9f27-0963cffd37e9 Okay. I'll be back before. So so piano's at two. I'll be back before that, 01:45. There's close air to take showers. You got pizza for lunch. 0 User 6.759999094009686 16.919999094009654
76817 User Heads to Katie’s Construction Project e401eb62-983b-4113-9f27-0963cffd37e9 Guys need anything else? No. Okay. Have you got that phone? Go up wherever that phone is, go grab it and bring it down here in case I need to call you. 0 User 18.079999094009622 25.439999094009636
76818 User Heads to Katie’s Construction Project e401eb62-983b-4113-9f27-0963cffd37e9 K? 1 Speaker 1 25.439999094009636 25.599999094009718
76819 User Heads to Katie’s Construction Project e401eb62-983b-4113-9f27-0963cffd37e9 And she wants food. I'm not I might not have any. 0 User 26.399999094009672 30.839999094009613
76820 User Heads to Katie’s Construction Project e401eb62-983b-4113-9f27-0963cffd37e9 Sorry, shark. 1 Speaker 1 34.71999909400961 42.28115342414958
76821 User Heads to Katie’s Construction Project e401eb62-983b-4113-9f27-0963cffd37e9 What? 1 Speaker 1 46.60114842414953 80.45885172843964
76822 User Heads to Katie’s Construction Project e401eb62-983b-4113-9f27-0963cffd37e9 What was that? 0 User 81.53885172843957 82.17885172843967

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