dune.neynar.dataset_farcaster_user_data

Farcaster user data — profile fields like bio, display name, and avatar.

Table description

This table contains user profile data on the Farcaster protocol. Each row represents a single key-value pair of user information, such as display name, bio, or avatar URL. Join with the fids or fnames table for complete user profiles.

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 data was removed on the Farcaster protocol
timestamp	TIMESTAMP	Timestamp when the data was set on the Farcaster protocol
fid	BIGINT	Farcaster user ID the data belongs to
hash	VARBINARY	Unique hash of the user data message
type	BIGINT	Type of user data (1 = pfp URL, 2 = display name, 3 = bio, 5 = URL, 6 = preferred fname)
value	VARCHAR	The value of the user data field

Table Sample