sentiment_segments
24 rows where conversation_id = "0c9db4eb-0b0b-4a54-a660-37825ea74fe1"
This data as json, CSV (advanced)
Suggested facets: segment_index, text, sentiment, score, emotions, emotions (array)
| id ▼ | conversation_id | segment_index | text | sentiment | score | emotions |
|---|---|---|---|---|---|---|
| 3960 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 5 | Gonna be a little bit hot. | neutral | 0.0 | ["concern"] |
| 3961 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 6 | Alright. Ready? Yeah. | neutral | 0.0 | ["contentment"] |
| 3962 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 7 | Apple | neutral | 0.0 | [] |
| 3963 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 8 | Yeah. Hollywood movies are funny to watch because they're really ridiculous. Uh-huh. Yeah. They're very dramatic. Yeah. | positive | 0.5 | ["humor", "joy"] |
| 3964 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 9 | Just little clips. Okay. Never a whole movie, But light and brilliant scene in water. Okay. And also a lot of volume in absolutely ridiculous. | positive | 0.5 | ["humor", "joy"] |
| 3965 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 10 | There's a part where there are two main characters who are fighting. Yeah. And one of them is trying to arrest the other one for treason against the British government. | neutral | 0.0 | ["curiosity"] |
| 3966 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 11 | Do do you guys know how long you can stay at Wales? | neutral | 0.0 | ["curiosity"] |
| 3967 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 12 | Yeah. Yeah. | neutral | 0.0 | [] |
| 3968 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 13 | We can go driving if you guys want tomorrow. At should probably do some else together. We should go I don't know what. Go ice skating. Maybe we could to a movie. We could go as far as go. | positive | 0.5 | ["excitement", "joy"] |
| 3969 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 14 | Okay. | neutral | 0.0 | [] |
| 3970 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 15 | I forgot the phone, so I have to have to they'll text me. But will you have him text me how long you guys can stay? You're totally guys, they want you to leave, like, 08:30. So you can stay till ten as far as, I'm concerned, find out how long it works for them. | neutral | 0.0 | ["concern"] |
| 3971 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 16 | Oops. | neutral | 0.0 | ["humor"] |
| 11332 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 5 | Gonna be a little bit hot. | neutral | 0.0 | ["concern"] |
| 11333 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 6 | Alright. Ready? Yeah. | neutral | 0.0 | ["contentment"] |
| 11334 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 7 | Apple | neutral | 0.0 | [] |
| 11335 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 8 | Yeah. Hollywood movies are funny to watch because they're really ridiculous. Uh-huh. Yeah. They're very dramatic. Yeah. | positive | 0.5 | ["humor", "joy"] |
| 11336 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 9 | Just little clips. Okay. Never a whole movie, But light and brilliant scene in water. Okay. And also a lot of volume in absolutely ridiculous. | positive | 0.5 | ["humor", "joy"] |
| 11337 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 10 | There's a part where there are two main characters who are fighting. Yeah. And one of them is trying to arrest the other one for treason against the British government. | neutral | 0.0 | ["curiosity"] |
| 11338 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 11 | Do do you guys know how long you can stay at Wales? | neutral | 0.0 | ["curiosity"] |
| 11339 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 12 | Yeah. Yeah. | neutral | 0.0 | [] |
| 11340 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 13 | We can go driving if you guys want tomorrow. At should probably do some else together. We should go I don't know what. Go ice skating. Maybe we could to a movie. We could go as far as go. | positive | 0.5 | ["excitement", "joy"] |
| 11341 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 14 | Okay. | neutral | 0.0 | [] |
| 11342 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 15 | I forgot the phone, so I have to have to they'll text me. But will you have him text me how long you guys can stay? You're totally guys, they want you to leave, like, 08:30. So you can stay till ten as far as, I'm concerned, find out how long it works for them. | neutral | 0.0 | ["concern"] |
| 11343 | Friends Plan Tomorrow’s Evening Activities 0c9db4eb-0b0b-4a54-a660-37825ea74fe1 | 16 | Oops. | neutral | 0.0 | ["humor"] |
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);