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.
Columns
| 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). |
Indexes
| Index |
|---|
| resolved_address, ens_name |
| registration_timestamp, ens_name |
| primary_address |
| token_id, ens_name |
| owner_address, ens_name |
| last_refreshed, ens_name |
| expiration_timestamp, ens_name |
| ens_node, ens_name |
| __last_modified |
| __indexer_id, __block_number |
| __indexer_id WHERE __confirmed = false |
| ens_name |
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.