> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# dune.neynar.dataset_farcaster_casts

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

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

## 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

<TableSample tableSchema="dune.neynar" tableName="dataset_farcaster_casts" />


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.