dune.neynar.dataset_farcaster_reactions - Dune Docs

Table description

The dune.neynar.dataset_farcaster_reactions table contains data about likes and recast events on the Farcaster protocol. Each row represents a single reaction by a user to a cast or URL.

Table Schema

Column Name	Type	Description
`id`	`BIGINT`	Auto-incrementing row identifier
`created_at`	`TIMESTAMP`	Timestamp when the record was created in the database
`updated_at`	`TIMESTAMP`	Timestamp when the record was last updated in the database
`deleted_at`	`TIMESTAMP`	Timestamp when the reaction was removed on the Farcaster protocol
`timestamp`	`TIMESTAMP`	Timestamp when the reaction was created on the Farcaster protocol
`reaction_type`	`BIGINT`	Type of reaction (1 = like, 2 = recast)
`fid`	`BIGINT`	Farcaster user ID of the user who reacted
`hash`	`VARBINARY`	Unique hash of the reaction
`target_hash`	`VARBINARY`	Hash of the cast being reacted to
`target_fid`	`BIGINT`	Farcaster user ID of the author of the target cast
`target_url`	`VARCHAR`	URL being reacted to (for URL-targeted reactions)

Table Sample