Skip to content

Ens Names

The ethereum.ens_names table provides indexed views of all ENS names on a specific chain, with continuous background refreshing of ENS data and ownership.


Name Type Description
contract_address text The contract address of the ENS collection.
ens_name text The ENS name.
ens_node text The unique ENS nodehash which points to the ENS name.
expiration_timestamp timestamp without time zone The timestamp at which this ENS registration will expire (in ISO-8601 format).
last_refreshed timestamp without time zone The timestamp at which the ENS record was last refreshed by the Transpose backend (in ISO-8601 format).
owner_address text The address of the ENS name owner.
primary_address text The primary address of the ENS name.
registration_timestamp timestamp without time zone The timestamp at which this ENS name was registered (in ISO-8601 format).
resolved_address text The address that the ENS name resolves to.
resolver_address text The address of the resolver contract for the ENS name.
token_id numeric The token ID of the ENS name.
__block_number integer The block number at which the event took place in.
__confirmed boolean Flag indicating whether the transfer has been confirmed.
__last_modified timestamp The date at which this row was last updated (in ISO-8601 format).


resolved_address, ens_name
registration_timestamp, ens_name
token_id, ens_name
owner_address, ens_name
last_refreshed, ens_name
expiration_timestamp, ens_name
ens_node, ens_name
__indexer_id, __block_number
__indexer_id WHERE __confirmed = false

Got questions? Join our Discord

Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.