omi_transcript_segments

10 rows where conversation_id = "0e40e7aa-2e07-40b4-8985-73e10a35ae2c"

✎ 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
176142 Relationship Conflict and Feelings of Betrayal 0e40e7aa-2e07-40b4-8985-73e10a35ae2c Oh, magically. 2 Speaker 2 3.434872724028537e-07 72.25906540887536
176143 Relationship Conflict and Feelings of Betrayal 0e40e7aa-2e07-40b4-8985-73e10a35ae2c Not a shitty girlfriend. 3 User 73.30906540887509 74.4290654088752
176144 Relationship Conflict and Feelings of Betrayal 0e40e7aa-2e07-40b4-8985-73e10a35ae2c Bullshit. You have to have more faith in me. 3 User 120.44745161073979 125.25745161073974
176145 Relationship Conflict and Feelings of Betrayal 0e40e7aa-2e07-40b4-8985-73e10a35ae2c Was angry. Today, I'm just sad. 3 User 163.82176342982393 165.3417634298239
176146 Relationship Conflict and Feelings of Betrayal 0e40e7aa-2e07-40b4-8985-73e10a35ae2c You are not my friend. You say you wanna be friends. 3 User 168.96176342982403 172.8717634298241
176147 Relationship Conflict and Feelings of Betrayal 0e40e7aa-2e07-40b4-8985-73e10a35ae2c But you are not friend. 1 Speaker 1 173.03172342982407 173.91172342982418
176148 Relationship Conflict and Feelings of Betrayal 0e40e7aa-2e07-40b4-8985-73e10a35ae2c Never have been. You've never been my friend. You've never been there when I needed you. 3 User 175.43176342982406 182.231763429824
176149 Relationship Conflict and Feelings of Betrayal 0e40e7aa-2e07-40b4-8985-73e10a35ae2c Actually, in a lead. I should not count on you. 3 User 186.231763429824 191.64707925816765
176150 Relationship Conflict and Feelings of Betrayal 0e40e7aa-2e07-40b4-8985-73e10a35ae2c Not to count on you. 3 User 195.19712925816793 196.31712925816782
176151 Relationship Conflict and Feelings of Betrayal 0e40e7aa-2e07-40b4-8985-73e10a35ae2c Not that important. 2 Speaker 2 200.19707925816783 202.1712283518077

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