home / saraphina

omi_transcript_segments

11 rows where conversation_id = "0f8708e9-7d5a-4688-b93f-464794c2d435"

✎ 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
19061 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 Hey? Hey. Good morning. How are you? I'm good. How are you doing? Good. Good. You was? 0 User -1.907348590179936e-08 10.449999980926513
19062 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 Okay. Okay. 0 User 15.519999980926514 16.479999980926515
19063 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 Yeah. Do you sleep okay? 0 User 20.229999980926515 22.38999998092651
19064 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 Okay. 0 User 37.05999698092651 37.53999698092651
19065 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 I mean, 0 User 69.3700059809265 69.84999998092651
19066 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 But I'd like to help you if I can. 0 User 78.79000398092651 80.30999998092652
19067 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 More market y. Uh-huh. Yeah. Okay. 0 User 121.97999998092652 125.32999998092652
19068 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 Well, yeah, that one gets done. So Done is better than perfect. Exactly. Exactly. 1 Speaker 1 146.4299999809265 152.04999998092651
19069 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 I'm gonna go to the store and get casted. 0 User 163.4599999809265 165.30000998092652
19070 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 The cat is out of everything. 1 Speaker 1 167.16999998092652 169.0899899809265
19071 Quick Morning Chat And Errand Planning 0f8708e9-7d5a-4688-b93f-464794c2d435 Okay. That'd be helpful. Yeah. Yeah. K. Alright. 1 Speaker 1 178.1799999809265 182.3399999809265

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);
Powered by Datasette · Queries took 3.684ms