Farcaster
Casts
Farcaster
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 |