dune.neynar.dataset_farcaster_casts - Dune Docs

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