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

> Farcaster reactions — likes and recasts on posts.

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_reactions` table contains data about likes and recast events on the Farcaster protocol. Each row represents a single reaction by a user to a cast or URL.

## 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 reaction was removed on the Farcaster protocol |
| `timestamp`     | `TIMESTAMP` | Timestamp when the reaction was created on the Farcaster protocol |
| `reaction_type` | `BIGINT`    | Type of reaction (1 = like, 2 = recast)                           |
| `fid`           | `BIGINT`    | Farcaster user ID of the user who reacted                         |
| `hash`          | `VARBINARY` | Unique hash of the reaction                                       |
| `target_hash`   | `VARBINARY` | Hash of the cast being reacted to                                 |
| `target_fid`    | `BIGINT`    | Farcaster user ID of the author of the target cast                |
| `target_url`    | `VARCHAR`   | URL being reacted to (for URL-targeted reactions)                 |

## Table Sample

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