dune.lens.publication_reaction

Lens reactions — likes, mirrors, and other reactions on publications.

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