omi_transcript_segments

2 rows where conversation_id = "f9b7db2e-b723-4c92-81fd-c36f92e272a6"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ conversation_id text speaker_id speaker_name start_time end_time
21957 Amazon Refund Notification Read Aloud f9b7db2e-b723-4c92-81fd-c36f92e272a6 I like to read my notifications. 0 User 4.2915326048387215e-07 1.7600004291534788
21958 Amazon Refund Notification Read Aloud f9b7db2e-b723-4c92-81fd-c36f92e272a6 You have one new notification from Amazon shopping. From Amazon Shopping, two items were received and a refund of $342.21 was issued. 2 Speaker 2 3.440000429153315 12.960000429153297

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