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