> ## 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.lens.publication_reaction

> Lens reactions — likes, mirrors, and other reactions on publications.

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>
  </>;

<Warning>
  **Deprecation Notice**: Lens data ingestion has been discontinued as of December 2025. Only historical data is available, and no new data will be added.
</Warning>

## Table description

The `dune.lens.publication_reaction` table holds the reaction type and who reacted.

## Table Schema

| Column Name               | Type      | Description                                                    |
| ------------------------- | --------- | -------------------------------------------------------------- |
| publication\_id           | varchar   | Publication ID that was reacted to (format: `profileId-pubId`) |
| actioned\_by\_profile\_id | varbinary | Profile ID of the user who reacted                             |
| type                      | varchar   | Type of reaction (e.g. `UPVOTE`, `DOWNVOTE`)                   |
| action\_at                | timestamp | Timestamp when the reaction was created                        |
| app                       | varchar   | Application used to create the reaction                        |

## Table Sample

<TableSample tableSchema="dune.lens" tableName="publication_reaction" />