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)