home / saraphina

omi_transcript_segments

5 rows where conversation_id = "003f4862-3932-439d-a281-10bd0df62b03"

✎ 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
319006 Questions About Kids And Dating 003f4862-3932-439d-a281-10bd0df62b03 That felt pretty nice. well and also girls can often reach farther than they can actually grasp and hold on to. 0 Speaker 0 0.0 7.2
319007 Questions About Kids And Dating 003f4862-3932-439d-a281-10bd0df62b03 Yeah. so it's like and 1 Speaker 1 7.2 8.32
319008 Questions About Kids And Dating 003f4862-3932-439d-a281-10bd0df62b03 And that's not even a very good reach, much less trying to grasp me. he's like, no. i don't know if i'm ready to take on other people's kids. 0 Speaker 0 8.32 15.7
319009 Questions About Kids And Dating 003f4862-3932-439d-a281-10bd0df62b03 Wasn't that what he was saying? 1 Speaker 1 16.59 18.11
319010 Questions About Kids And Dating 003f4862-3932-439d-a281-10bd0df62b03 Yeah. even though and i asked him in that when you're meeting, was like, okay. so, like, what's your because that's all i cared about. i was like, have you interacted with kids before? because they might not have been like, are you pedo? and i, like, i i was pretty, like, not aggressive, but just, like, very straightforward and forceful. right? and i was like, what's your experience with kids? has done as the daughter's phone call. yeah. yeah. you know? and i was like, have you ever had a small kids? like, what what else did i say? like i said, my friend who's an fbi agent looks up your porno history. what kinda history is he gonna see there? no. yeah. but but, basically, yeah, by the end, like, i just had walked away and stuff. and, like yeah. and then soon after that, they did a 0 Speaker 0 18.11 59.63

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.582ms