home / saraphina

omi_transcript_segments

2 rows where conversation_id = "092b9391-490f-4e9d-9a70-09752e6a8543"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ conversation_id text speaker_id speaker_name start_time end_time
274235 Ex-Relationship Dynamics Discussion 092b9391-490f-4e9d-9a70-09752e6a8543 Right. right. right. but yeah, like that's i don't know. what was my point there? just oh, the the bigger we make the conversation leading up to me improvising, the better equipped i am potentially to to successfully navigate that improvisation. right? yeah. yeah. yeah. if it matters. right? and it's yeah. yeah. right. right. right. yeah. well, i have that i have that same experience too with people's recitation of their divorce story like, you know, single divorced people will all kind of get like, you know, you're on a date or you'd like talking to groups of people and you're like, you know, 0 Speaker 0 -58.0 -0.8800000000000026
274236 Ex-Relationship Dynamics Discussion 092b9391-490f-4e9d-9a70-09752e6a8543 Start talking about how did you end up here. right? and and yeah. yeah. and i i find that if people are like, yeah, my my ex is an is a jerk. you you know what i mean? like, and then they'll like yeah. and then they'll say like four or five things about like evidence of like, you know, the the the the verdict that they have decreed on their ex is, you you know, the the failing was the x. right? and i'm like, what i wanna know and and what i do and what i say to people is almost a live exploration of my own like of the dynamic including my culpability in it. right? like i will right. right. right. right. so i'll be like, you know, like i think we had this you know, i'll kinda characterize it like i think we had like kind of an anxious avoidant dynamic. that was my experience. like and then i'll be like, my ex doesn't agree with that. she she believes she's securely attached and 0 Speaker 0 0.0 61.24

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