omi_transcript_segments

23 rows where conversation_id = "848ab702-0cc0-4106-976a-5f4bab501e1a"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: text, speaker_id, speaker_name

id ▼ conversation_id text speaker_id speaker_name start_time end_time
1 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a Hello? Hi. Is this Jacob? It is. 0 User -1.5808106468284677e-07 4.190009841918936
2 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a Hi. This is Elena giving you a call from Hannon Stone in Draper. Oh, yeah. I was just calling because I received a note you were looking at a company or membership. 2 Speaker 2 5.2299998419189535 13.240009841918948
3 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a Is that correct? That's right. Yes. 0 User 13.240009841918948 14.200009841918927
4 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a Okay. Perfect. Is there any particular reason to No. 2 Speaker 2 15.55000984191895 18.030009841918968
5 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a Just too expensive right now. 0 User 20.970009841918966 22.89002984191893
6 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a Okay. 2 Speaker 2 23.80000984191895 24.440009841918936
7 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a I do wanna make you aware of some other options that we can have in case they work better for you. Do offer free to be useful deposit, or we do also offer buy do monthly, which is every other month. 2 Speaker 2 32.170009841918954 40.75000984191894
8 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a No. I don't use them often. I like 20 packages that I have haven't used them. So Okay. We've got no word. And I'm not yeah. 0 User 45.420009841918954 53.46998984191896
9 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a Okay. There is a limit to how many I can to another person too. Right? 0 User 59.66000984191896 65.80000984191895
10 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a This is transfer up to three. 2 Speaker 2 67.96000984191892 69.72000984191897
11 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a Okay. In what time period? Done A year? Throughout the year. 0 User 69.72000984191897 73.78000984191897
12 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a Okay. It does look like you've done two for the year. 2 Speaker 2 73.78000984191897 76.22000984191897
13 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a Okay. 0 User 76.22000984191897 78.06000984191894
14 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a One more. Okay. 2 Speaker 2 78.06000984191894 78.78000984191897
15 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a K. 0 User 80.91000984191896 81.47000984191897
16 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a No worries. I'll go ahead and get you canceled then. 2 Speaker 2 81.47000984191897 83.71000984191892
17 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a And then is that a good email on file for my youth? 2 Speaker 2 85.96000984191892 88.76000984191893
18 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a Yes. 1 Speaker 1 89.14000984191892 89.46000984191892
19 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a K. Perfect. I'll go ahead and get some points sent over to that email. If you get them signed, you'll be good. 2 Speaker 2 90.57000984191893 94.89000984191892
20 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a Okay. Thank you. 0 User 95.06000984191894 95.86000984191895
21 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a Of course. Yeah. 2 Speaker 2 97.14000984191892 98.18000984191895
22 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a You a good one. You too. You too. 0 User 98.35000984191896 100.11002984191896
23 Jacob Cancels Hannon Stone Membership 848ab702-0cc0-4106-976a-5f4bab501e1a Bye bye. Alright. Bye bye. 1 Speaker 1 100.11002984191896 101.63000984191893

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