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