Ordinals Inscriptions
The bitcoin.nfts.ordinals_inscriptions table contains inscription data aggregated from various ordinals explorer/data sources.
BRC-20 Collections
The BRC-20 is a standard for creating fungible tokens that are stored on Bitcoin.
It uses Ordinals and Inscriptions to implement contract-like operations such as deploy tokens, mint new tokens, transfer tokens - all facilitated by encoding JSON data as Ordinal inscriptions.
Currently, BRC-20 inscriptions are traced by the is_brc20/is_token column, with their metadata columns prefixed with token_.
Token-like protocols
With brc-20 as the leading protocol for fungible tokens, an is_token column has been added to allow easy filtering of token-like protocols. Even though we consider only brc-20 and orc-20 to be token-like now, we are open to addition of new ones.
Table Columns
| Column Name | Description | Example |
|---|---|---|
index | Index of the inscription. | 4,051,600 |
inscription_id | Inscription ID assigned. https://ordinals.com/ | a997f335430dc852e42dddeca28ddb4b915cc09d07ed16794bee6d25aeee9db1i0 |
inscription_name | Inscription name, if available | BTC Moonbirds 4984 |
status | Status of the inscription. Often inclue the rarity of the inscription (Common, Uncommon, Rare, Legendary, Founders Edition, Lengendary), if applicable. | Uncommon |
rank | Rank of the inscription based on rarity, if applicable. | |
attributes | Attiributes of the inscription. | |
genesis_height | Block height at the genesis of inscription. | 788540 |
genesis_timestamp | Timestamp of the inscription | 2023-05-06 17:10:56 |
content_type | Type of content inscribed. Includes text, audio, image, video, application & etc. Note that there is no standard format enforced for the type of content inscribed. | image/webp |
content_tag | Content tag, which is a reclassification of the raw | image video application audio text model others |
content_length | Content length of the inscription in bytes | 420 |
parsed_inscription | The parsed output of the txwitness data. it would include fields such as |
|
parsed_content | (For textual inscriptions) The parsed content of the inscription, could be a utf-8 string or a json object |
|
content_protocol | (For json inscriptions with a | brc-20 |
is_unstable | Indicates if the inscription is considered unstable. The definition might change overtime as the ordinals ecosystem evolves Currently, an inscription is considered unstable is input index > 0 | true/false |
genesis_fee | The tx paid during the inscription of the ordinal, in satoshis | 19384 |
satoshi_timestamp | Timestamp where the satoshi was minted in the coinbase block | 2023-05-10 14:25:01 |
collection_name | Collection name of the inscription, if applicable. | ordfish |
collection_slug | Collection slug of the inscription, if applicable. The collection slug is a human-readable, unique identifier. | ordfish |
collection_supply | Collection supply, if applicable. | 100 |
collection_icon | Collection icon, if applicable. | 5b182278c42d5a74ab4dd9f43826a0a2fce0158000001ed3bdf44873f1378d93i0 |
collection_description | Description of the collection, if applicable. | Ordinary literary fish. Look up an ordfish by entering its satoshi code into ordinals.com or aesthetic.computer |
collection_twitter_link | Collection Twitter link, if applicable. | |
collection_discord_link | Collection Discord link, if applicable. | |
collection_website_link | Collection Website link, if applicable. | |
is_brc20 | Derived with | FALSE |
is_token | Used to identify token-like standards. Derived with | TRUE |
token_op | Operation: Type of event (mint, transfer, reg, deploy). | mint |
token_tick | The tick of the token-like inscription.
Derived with | ordi |
token_amt | The amout specified in the token-like inscription.
Derived with | 1000 |
domain_protocol | Domain name protocol used to parse the content | sns bitmap |
domain_name | the domain name (portion before the | abc |
domain_namespace | the domain namespace (portion after the | sats |
domain_valid | true/false - domains are invalid if they are not the first or are unstable inscriptions | true/false |
domain_meta | the metadata of the domain op, such as | {"avatar":"cfab194b924f7785c6e453728e1c264b89b74843633278cda3ad3f57576c1e93i0","op":"reg"} |
is_domain | true/false - whether the domain name/namespace fit the requirements of sns/bitmap protocols. Malformed/illegal formats of inscriptions are removed here. There may be some edge cases because sns allows text inscriptions which have lots of noise. | true/false |
output_address | The receiver address of the ordinal in the inscription tx | bc1pq5e2zyzc486jwzlnfxtxvg6qutgffeulp3meuyrfc24v3sdyta5s2juu6r |
output_utxo_id | The output utxo id of the ordinal in the inscription tx | 7dfc561a916935c6e27510e8a463b74bfa948ff1467f404b61892817d27804ca:0 |
spent_transaction_hash | The transaction_hash of the spent input utxo in the inscription tx | 80de7ec2cbcf7fa9b14a9833107efe5a453be772abb5e3e697668da9b755f6b1 |
spent_output_index | The output index of the spent input utxo in the inscription tx | 8 |
input_addresses | The owner(s) of the spent input utxo in the inscription tx | bc1p9qtz90zjg85s458uw453ycnlt32xq5tg5fau5cp7gn6nv0me6xsq70y8xr |
input_address0 |
| bc1p9qtz90zjg85s458uw453ycnlt32xq5tg5fau5cp7gn6nv0me6xsq70y8xr |
spent_utxo_id | The utxo id of the spent input utxo in the inscription tx | 80de7ec2cbcf7fa9b14a9833107efe5a453be772abb5e3e697668da9b755f6b1:8 |
value | The value of the spent input utxo | 853 |
transaction_hash | The transaction_hash of the inscription tx | 7dfc561a916935c6e27510e8a463b74bfa948ff1467f404b61892817d27804ca |
block_hash | The block_hash of the inscription tx | 00000000000000000003992047db606364ba3d7fda5d343fc9a3155961a4f976 |
block_number | The block_number of the inscription tx | 785817 |
block_timestamp | The block_timestamp of the inscription tx | 2023-04-17 14:57:25.000 |
unique_id | Unique ID of the inscription. | a997f335430dc852e42dddeca28ddb4b915cc09d07ed16794bee6d25aeee9db1i0 |
Last updated