Casts

dune.neynar.dataset_farcaster_casts

This table contains all casts on the Farcaster protocol

Column name	Type	Description
id	bigint	Row id
created_at	timestamp without timezone	Timestamp of creation within database
updated_at	timestamp without timezone	Timestamp of update within database
deleted_at	timestamp without timezone	Timestamp of deletion on Farcaster protocol
timestamp	timestamp without timezone	Timestamp of creation on Farcaster protocol
fid	bigint	User ID of user on Farcaster protocol
hash	bytea	Hash of the cast
parent_hash	bytea	Hash of the cast that this cast is a reply to
parent_fid	bigint	FID of author or parent_hash
parent_url	varchar	Posting channel for the cast; can be null
text	text	Text of the cast
embeds	jsonb	Attachments inside the cast e.g. images, links, etc.
mentions	bigint[]	Array of FIDs for the users that were mentioned in the cast text
mentions_positions	smallint[]	Positions in the cast text where the users were mentioned
root_parent_hash	bytea	Hash of the parent cast that started the thread