Deprecation Notice: Lens data ingestion has been discontinued as of December 2025. Only historical data is available, and no new data will be added.
Table description
This holds the reaction type and who reacted.
Table Schema
| Column Name | Type | Description |
|---|
| publication_id | varchar | Publication ID that was reacted to (format: profileId-pubId) |
| actioned_by_profile_id | varbinary | Profile ID of the user who reacted |
| type | varchar | Type of reaction (e.g. UPVOTE, DOWNVOTE) |
| action_at | timestamp | Timestamp when the reaction was created |
| app | varchar | Application used to create the reaction |
Table Sample
