home / saraphina

omi_transcript_segments

12 rows where conversation_id = "61fe85ec-7843-4bfd-a85d-1776ac9490ad"

✎ 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
12904 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad How old are you? 99 Speaker 99 0.0 1.6
12905 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad I'm 47 years old. 0 User 1.1999999 2.6399999
12906 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad Where do you live? 99 Speaker 99 3.1399999 4.7399999
12907 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad I live in South Jordan, Utah. 0 User 30.9 32.66
12908 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad What do you do for work? 99 Speaker 99 33.16 35.559999999999995
12909 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad I am a software developer. 0 User 39.39 40.84
12910 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad What is your long-term goal? 99 Speaker 99 41.34 43.34
12911 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad To become rich and famous. 0 User 47.57 48.85
12912 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad What are your goals this month? 99 Speaker 99 49.35 51.75
12913 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad This month I need to get a new job. 0 User 54.93 56.45
12914 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad What do you have planned for today? 99 Speaker 99 56.95 59.75
12915 Conversation about personal background and plans 61fe85ec-7843-4bfd-a85d-1776ac9490ad Today, we're gonna eat some burritos and go do a climbing go to a climbing gym. 0 User 61.510002 65.57

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 4.689ms