sentiment_segments
20 rows where conversation_id = "16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e"
This data as json, CSV (advanced)
Suggested facets: text, sentiment, score, emotions, emotions (array)
| id ▼ | conversation_id | segment_index | text | sentiment | score | emotions |
|---|---|---|---|---|---|---|
| 22905 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | 175 | Yes, I can hear you. Hi Tyler. | neutral | 0.0 | ["contentment"] |
| 22906 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | 176 | Nice to meet you. I should be joined by Ryan here. So Here he is. Hey. Sorry. Who's wrapping up a conversation. No problem. Why we start with a little introduction I'm Tyler. | neutral | 0.0 | ["contentment"] |
| 22907 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | 177 | Hi, Ryan. I am on the subscriptions and commerce team. | neutral | 0.0 | ["contentment"] |
| 22908 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | 178 | Okay. | neutral | 0.0 | ["contentment"] |
| 22909 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | 179 | So like real time video editing and stuff like that. Sure. So that was kind of my little niche for a long time. That was mostly what I did. I mean, I would any app has your standard UI stuff that it needs, it was always I always almost got hired or or brought on to to fix their video pipeline issues. And then and then Right. Once I was in there, they'd have me whatever, do whatever what's next. Right? | neutral | 0.0 | ["contentment"] |
| 22910 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | 180 | That's cool. That's an interesting area. Thanks for taking us in. Yeah. It was really fun. I really liked it. It was low level enough that it was Sure. Yeah. | positive | 0.5 | ["joy"] |
| 22911 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | 181 | You got to know a little bit about the hardware Yeah. And the software side. But Yeah. | neutral | 0.0 | ["curiosity"] |
| 22912 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | 182 | So Yeah. | neutral | 0.0 | ["contentment"] |
| 22913 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | 183 | So Yeah. | neutral | 0.0 | ["contentment"] |
| 22914 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | 184 | That makes sense. That makes sense. Yeah. | neutral | 0.0 | ["contentment"] |
| 22915 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | 185 | Yeah. Yeah. Sure. | neutral | 0.0 | ["contentment"] |
| 22916 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | 186 | I have mostly worked with small teams. But for a while now, I've been kind of the the old guy, you know. I've been doing it longer. Sure. | neutral | 0.0 | ["contentment"] |
| 22917 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | 187 | And I think the probably the best example I was at a company called Crikey for a while. They were start up out of San Francisco. | neutral | 0.0 | ["contentment"] |
| 22918 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | 188 | They were a little bit larger. They had like 20 people and we had Mhmm. We had internal back end people and and iOS and Android and it was a we were using Unity inside of an inside of iOS or Android, so we we had Unity people as well. | neutral | 0.0 | ["contentment"] |
| 22919 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | 189 | My job fits into the company's mission and everybody else kinda fits together. | positive | 0.5 | ["pride"] |
| 22920 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | 190 | I'm curious about how just authority and responsibility and personalities and like ideologies fit together because you got | neutral | 0.0 | ["curiosity"] |
| 22921 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | 191 | Yeah. I've I've done things long enough to kind of | neutral | 0.0 | ["contentment"] |
| 22922 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | 192 | guess where things could break down | neutral | 0.0 | ["contentment"] |
| 22923 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | 193 | Down and kinda step in and be like, what do you guys think about this? | neutral | 0.0 | ["contentment"] |
| 22924 | Tyler and Ryan Interview Candidate for Mobile Role 16dfc3c1-34b0-41f7-ab89-8e46f85c4c0e | 194 | There was one client where | neutral | 0.0 | ["contentment"] |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE sentiment_segments (
id INTEGER PRIMARY KEY AUTOINCREMENT,
conversation_id TEXT NOT NULL,
segment_index INTEGER,
text TEXT,
sentiment TEXT,
score REAL,
emotions TEXT,
FOREIGN KEY (conversation_id) REFERENCES omi_conversations(id)
);
CREATE INDEX idx_sentiment_segments_conv ON sentiment_segments(conversation_id);