Deprecation Notice: Lens data ingestion has been discontinued as of December 2025. Only historical data is available, and no new data will be added.
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
