sentiment_segments
11 rows where conversation_id = "13c41037-a153-4fd4-934c-260afe109370"
This data as json, CSV (advanced)
Suggested facets: sentiment, score, emotions, emotions (array)
| id ▼ | conversation_id | segment_index | text | sentiment | score | emotions |
|---|---|---|---|---|---|---|
| 24633 | Affirmations Of Identity And Purpose 13c41037-a153-4fd4-934c-260afe109370 | 18 | Noble son of god. | positive | 0.8 | ["pride", "joy"] |
| 24634 | Affirmations Of Identity And Purpose 13c41037-a153-4fd4-934c-260afe109370 | 19 | I am stillness. I am that I seek connection. I am spiritually intelligent. I am free. | positive | 0.9 | ["joy", "determination"] |
| 24635 | Affirmations Of Identity And Purpose 13c41037-a153-4fd4-934c-260afe109370 | 20 | I am curious. | positive | 0.7 | ["curiosity", "joy"] |
| 24636 | Affirmations Of Identity And Purpose 13c41037-a153-4fd4-934c-260afe109370 | 21 | I am that I love everyone. I am that I seek mastery at my domain. I am that I am inspired. I'm an artist. I have unlimited potential. | positive | 0.9 | ["joy", "pride", "excitement"] |
| 24637 | Affirmations Of Identity And Purpose 13c41037-a153-4fd4-934c-260afe109370 | 22 | I'm an elegant man. I am that I know myself deeper. I am that I serve others in dignity and love. I'm a family man, a father, a husband. | positive | 0.8 | ["love", "pride"] |
| 24638 | Affirmations Of Identity And Purpose 13c41037-a153-4fd4-934c-260afe109370 | 23 | A a leader. I am a big strong monster of a man. I am the author of my reality. I am a healer. I am a teacher. I am that I see others. | positive | 0.9 | ["pride", "determination"] |
| 24639 | Affirmations Of Identity And Purpose 13c41037-a153-4fd4-934c-260afe109370 | 24 | I am that I choose to love others. I am fun. I am like my grandpa, Tom. My softness is my inheritance. The warmth that people loved in him lives in me, and I honor it. | positive | 0.9 | ["love", "warmth"] |
| 24640 | Affirmations Of Identity And Purpose 13c41037-a153-4fd4-934c-260afe109370 | 25 | Live large. I'm a creative powerhouse with capacity to spare. | positive | 0.8 | ["excitement", "joy"] |
| 24641 | Affirmations Of Identity And Purpose 13c41037-a153-4fd4-934c-260afe109370 | 26 | I am wise. | positive | 0.7 | ["pride", "determination"] |
| 24642 | Affirmations Of Identity And Purpose 13c41037-a153-4fd4-934c-260afe109370 | 27 | For this day and grateful to be able to do these practices to find myself | positive | 0.9 | ["gratitude", "joy"] |
| 24643 | Affirmations Of Identity And Purpose 13c41037-a153-4fd4-934c-260afe109370 | 28 | Moving closer to the you're farther away. | neutral | 0.0 | ["concern"] |
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);