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 content_type field to make it easy to analyze. | 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 content_type, content_length & content | |
| 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 p key)The protocol of the inscription, derived with json_content[‘p’] | 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.
| 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. | https://twitter.com/digitpain |
| collection_discord_link | Collection Discord link, if applicable. | https://discord.gg/aesthetic-computer |
| collection_website_link | Collection Website link, if applicable. | https://aesthetic.computer |
| is_brc20 | Derived with content_protocol = ‘brc-20’. To be deprecated for is_token + content_protocol | 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 content_parsed[‘tick’] | ordi |
| token_amt | The amout specified in the token-like inscription. Derived with content_parsed[‘amt’] | 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 about, rev, avatar fields. | {"avatar":"cfab194b924f7785c6e453728e1c264b89b74843633278cda3ad3f57576c1e93i0","op":"reg"} |
| is_domain | true/false - whether the domain name/namespace fit the requirements of sns/bitmap protocols.
| 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 | input_addresses[0] | 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 |