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
The dune.lens.publication_reaction table 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
