home / saraphina

omi_transcript_segments

46 rows where conversation_id = "929c6034-2583-46ec-a8c2-f7d03cb6407d"

✎ 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
8178 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d I feel like it's been millions days. I older. Millions days I get older. Millions days. I mean, I'm only three years 1 Speaker 1 1.039995183944697 7.470001183944703
8179 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d You're welcome. 1 Speaker 1 29.939995183944703 30.7399951839447
8180 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d I totally 1 Speaker 1 39.8999951839447 40.619995183944695
8181 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d It's probably just hard for me to see because I'm not short. Mama's as tall as you. 1 Speaker 1 52.400001183944696 58.0799951839447
8182 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Jennifer is taller than you. 1 Speaker 1 61.50999518394471 63.030005183944695
8183 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d But a little bit. 1 Speaker 1 66.3099951839447 67.90999518394472
8184 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d I know how to say it. He's like, blocked someone. 1 Speaker 1 76.0499951839447 85.1799951839447
8185 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Really? Yes. Because, like, what what what did they like what did it take for you to block him? 0 User 86.72999518394471 92.1499951839447
8186 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d He called like six times. 1 Speaker 1 92.1499951839447 93.5099851839447
8187 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Like through the Facebook phone call? 0 User 94.5799951839447 97.53999518394471
8188 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Six times. 1 Speaker 1 97.53999518394471 98.25999518394471
8189 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d That's ridiculous. 0 User 101.21999518394469 102.4199951839447
8190 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Yeah. 1 Speaker 1 102.4199951839447 102.65999518394472
8191 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d He shouldn't have even called once unless you, like, gave him a reason to think that was okay. 0 User 104.4599951839447 108.7699951839447
8192 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Yeah, I know. 1 Speaker 1 108.7699951839447 109.0099851839447
8193 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d But like, ugh. Yeah. I like that at all. But you also got one. So I Okay. You also got one, like, actual interest in party. Right? Or at least Yeah. Theoretically. 0 User 109.37999518394471 124.3299951839447
8194 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Theoretically. Okay. 1 Speaker 1 124.3299951839447 125.44999518394471
8195 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Is it worth it? 0 User 127.40999518394472 128.0499951839447
8196 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Yeah. K. Yeah? K. Don't do it. K. 1 Speaker 1 128.0499951839447 131.7099951839447
8197 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Totally worth it. If I get a client out of it, Okay. 1 Speaker 1 137.7199951839447 139.9599951839447
8198 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d No. That's kinda what I would have guessed, but I'm asking because I wanna show it. 0 User 140.5799951839447 144.0199951839447
8199 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d It is annoying. I keep Yeah. 1 Speaker 1 144.0199951839447 145.2699951839447
8200 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Like, random messages keep popping up. 2 Speaker 2 145.2699951839447 146.7899951839447
8201 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Yeah. 1 Speaker 1 146.7899951839447 147.9100151839447
8202 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Yeah. 0 User 148.0699951839447 148.2300051839447
8203 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d And today's a busy day. Right. 2 Speaker 2 149.1499851839447 151.0699851839447
8204 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d So it's like Right. Right. Stop. 1 Speaker 1 151.0699851839447 155.1999951839447
8205 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d But even on busy days, Jake, I'm pushing forward, like, on a bigger scale. Right. 2 Speaker 2 157.8699851839447 162.1700051839447
8206 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Right? Right. Oh, it's good. It is good. You're getting closer to where you wanna be. Yeah. Absolutely. 0 User 162.1700051839447 167.7099851839447
8207 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Yeah. 1 Speaker 1 169.3100051839447 169.8699951839447
8208 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Need a It's because I'm overwhelmed with what I have. Yeah. Doesn't mean I'm not pushing for more. 2 Speaker 2 170.0299951839447 174.5299951839447
8209 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d That's how you roll, Katie. 0 User 178.0299951839447 179.1499851839447
8210 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Because that's what you came in for. 2 Speaker 2 196.9799951839447 198.57999518394467
8211 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Then I came in to tell you that we needed Valentine's stuff. Oh, that's right. 1 Speaker 1 200.0499951839447 203.7299951839447
8212 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d You should be here when you wake up. She should be on the couch. 2 Speaker 2 203.81999518394468 207.6799951839447
8213 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Why is this not working? 0 User 207.6799951839447 208.95999518394473
8214 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Okay. Good night. 1 Speaker 1 214.1199951839447 215.4799951839447
8215 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d My turn. 1 Speaker 1 243.6899951839447 244.41001518394472
8216 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d K. Hold on just a second. 0 User 244.73996518394472 246.57999518394467
8217 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d To be my turn. 2 Speaker 2 246.89997518394472 247.8599951839447
8218 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Trying to be in respond to somebody that texted me today at two, and I've ignored them all day long. 0 User 247.93997518394468 252.6899951839447
8219 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Alright. 1 Speaker 1 283.9499951839447 284.4299951839447
8220 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d I have had busy months before, Jake. I think it didn't, like, five or six transactions in a month. 2 Speaker 2 284.4299951839447 291.5299951839447
8221 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Yeah. This was like one day 0 User 292.4799951839447 295.8699751839447
8222 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d Really? 2 Speaker 2 309.8899951839447 310.3699951839447
8223 Friends Vent About Overwhelm And Boundaries 929c6034-2583-46ec-a8c2-f7d03cb6407d And you like something whichever was that for? 0 User 313.0699951839447 314.1099951839447

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