dune.neynar.dataset_farcaster_reactions

Farcaster reactions — likes and recasts on posts.

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