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

> Lens publication records — posts, comments, and mirrors with content references.

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_record` table holds all the SUCCESSFUL publication records, including Momoka publications; it also has a MIRROR|QUOTE|COMMENT|POST publication type, but the rest of the columns should explain itself. The definition of success to us is if it follows the metadata standard.

## Table Schema

| Column Name | Type | Description |
| - | - | - |
| publication\_id | varchar | Unique publication identifier (format: `profileId-pubId`) |
| contract\_publication\_id | varbinary | On-chain publication ID from the Lens Hub contract |
| publication\_type | varchar | Type of publication: `POST`, `COMMENT`, `MIRROR`, or `QUOTE` |
| profile\_id | varbinary | Profile ID of the publication author |
| content\_uri | varchar | URI pointing to the publication content/metadata |
| parent\_publication\_id | varchar | Publication ID of the parent (for comments, quotes, mirrors) |
| root\_publication\_id | varchar | Publication ID of the root post in the thread |
| is\_hidden | boolean | Whether the publication has been hidden |
| is\_momoka | boolean | Whether the publication was posted via Momoka (off-chain DA layer) |
| momoka\_proof | varchar | Momoka data availability proof (null for on-chain publications) |
| app | varchar | Application used to create the publication |
| gardener\_flagged | boolean | Whether the publication was flagged by a gardener for moderation |
| transaction\_executor | varbinary | Address that executed the publication transaction |
| tx\_hash | varbinary | Transaction hash (null for Momoka publications) |
| block\_hash | varbinary | Hash of the block containing the transaction |
| block\_number | integer | Block number of the transaction |
| log\_index | integer | Index of the event log within the transaction |
| tx\_index | integer | Index of the transaction within the block |
| block\_timestamp | timestamp | Timestamp of the block |
| is\_comment\_hidden\_by\_author | boolean | Whether a comment was hidden by the original post author |

## Table Sample

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


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