dune.neynar.dataset_farcaster_casts

Farcaster casts — posts, replies, and threads across the Farcaster social protocol.

Table description

The dune.neynar.dataset_farcaster_casts table contains all casts (posts and replies) on the Farcaster protocol, including text content, embeds, mentions, and threading information.

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 cast was deleted on the Farcaster protocol
timestamp	TIMESTAMP	Timestamp when the cast was created on the Farcaster protocol
fid	BIGINT	Farcaster user ID of the cast author
hash	VARBINARY	Unique hash of the cast
parent_hash	VARBINARY	Hash of the parent cast (for replies)
parent_fid	BIGINT	Farcaster user ID of the parent cast author
parent_url	VARCHAR	Channel URL where the cast was posted (null for direct replies)
text	VARCHAR	Text content of the cast
embeds	VARCHAR	JSON-encoded attachments (images, links, frames, etc.)
mentions	ARRAY(BIGINT)	Array of Farcaster user IDs mentioned in the cast
mentions_positions	ARRAY(INTEGER)	Byte positions in the cast text where mentions are placed
root_parent_hash	VARBINARY	Hash of the root cast that started the thread
root_parent_url	VARCHAR	Channel URL of the root cast in the thread

Table Sample