bitcoin.nfts.ordinals_inscriptions table contains inscription data aggregated from various ordinals explorer/data sources.
Table Details
| Property | Value |
|---|---|
| Table Name | bitcoin.nfts.ordinals_inscriptions |
| Table Status | Production-Ready |
| Unique Key | block_timestamp::date, transaction_hash, inscription_id |
| Clustering Key(s) | block_timestamp::date |
| Search Optimization | transaction_hash, inscription_id, is_brc20, token_tick |
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 theis_brc20/is_token column, with their metadata columns prefixed with token_.
Token-like protocols
With brc-20 as the leading protocol for fungible tokens, anis_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.
| 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. | Rank of this inscription within its collection by inscription number (1 = earliest). |
| attributes | Attiributes of the inscription. | JSON array of key-value trait pairs for this NFT (e.g. background, eyes, mouth). Used for rarity and filtering. |
| 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. | imagevideoapplicationaudiotextmodelothers |
| 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 | { "content": "7b2270223a226272632d3230222c226f70223a226d696e74222c227469636b223a2272737363222c22616d74223a2231303030227d", "content_length": 106, "content_type": "text/plain;charset=utf-8", "pretty_content": "{"p":"brc-20","op":"mint","tick":"rssc","amt":"1000"}" } |
| parsed_content | (For textual inscriptions)The parsed content of the inscription, could be a utf-8 string or a json object | hello world {"p":"brc-20","op":"transfer","tick":"pepe","amt":"500"} |
| 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 evolvesCurrently, 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. | 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 content_protocol = ‘brc-20’ or ‘orc-20’ or ‘orc20’ | 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 | snsbitmap |
| 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. 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 | 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 |
| is_unstable_remarks | Human-readable explanation of why this inscription is flagged as unstable. | |
| is_unbound | True if this inscription is not bound to a specific satoshi (created via a non-standard path). | true/false |
| is_cursed | True if this inscription is a cursed inscription (negative inscription number), created before Jubilee activation. | true/false |
| is_jubilant | True if this inscription was previously cursed but became blessed after the Jubilee upgrade at block 824544. | true/false |
| is_vindicated | True if this inscription was previously unbound or cursed but later vindicated. | true/false |
| previous_inscription_id | Inscription ID of the most recent prior inscription on the same satoshi, if any. | |
| previous_inscription_id_is_unstable | True if the previous inscription is flagged as unstable. | true/false |
| previous_inscription_id_is_unstable_remarks | Explanation of why the previous inscription is flagged as unstable. | |
| previous_inscription_id_transfer_count | Number of times the previous inscription on this satoshi has been transferred. | |
| input_index | Zero-based index of this input within the transaction’s input list. | |
| output_offset | Satoshi offset within the output UTXO at which this inscription is located. | |
| output_index | Zero-based index of this output within the transaction’s output list (equivalent to vout). | |
| transaction_index | Zero-based position of the transaction within its block. The first transaction in a block has index 0. |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| index | VARCHAR(16777216) | Index of the inscription. |
| inscription_id | VARCHAR(73) | Inscription ID assigned. https://ordinals.com/ |
| inscription_name | VARCHAR(16777216) | Inscription name, if available |
| status | VARCHAR(16777216) | Status of the inscription. Often inclue the rarity of the inscription (Common, Uncommon, Rare, Legendary, Founders Edition, Lengendary), if applicable. |
| rank | VARCHAR(16777216) | Rank of the inscription based on rarity, if applicable. |
| attributes | VARCHAR(16777216) | Attiributes of the inscription. |
| genesis_height | NUMBER(38,0) | Block height at the genesis of inscription. |
| genesis_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the inscription |
| content_type | VARCHAR(16777216) | 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. |
| content_tag | VARCHAR(16777216) | Content tag, which is a reclassification of the raw content_type field to make it easy to analyze. |
| content_length | NUMBER(38,0) | Content length of the inscription in bytes |
| parsed_inscription | VARIANT | The parsed output of the txwitness data. it would include fields such as content_type, content_length & content |
| parsed_content | VARIANT | (For textual inscriptions)The parsed content of the inscription, could be a utf-8 string or a json object |
| content_protocol | VARCHAR(16777216) | (For json inscriptions with a p key)The protocol of the inscription, derived with json_content[‘p’] |
| genesis_fee | VARCHAR(16777216) | The tx paid during the inscription of the ordinal, in satoshis |
| satoshi_timestamp | TIMESTAMP_NTZ(9) | Timestamp where the satoshi was minted in the coinbase block |
| is_brc20 | BOOLEAN | Derived with content_protocol = ‘brc-20’. To be deprecated for is_token + content_protocol |
| is_token | BOOLEAN | Used to identify token-like standards.Derived with content_protocol = ‘brc-20’ or ‘orc-20’ or ‘orc20’ |
| token_tick | VARCHAR(16777216) | The tick of the token-like inscription. Derived with content_parsed[‘tick’] |
| token_amt | VARCHAR(16777216) | The amout specified in the token-like inscription. Derived with content_parsed[‘amt’] |
| token_op | VARCHAR(16777216) | Operation: Type of event (mint, transfer, reg, deploy). |
| is_unstable | BOOLEAN | Indicates if the inscription is considered unstable.The definition might change overtime as the ordinals ecosystem evolvesCurrently, an inscription is considered unstable is input index > 0 |
| is_unstable_remarks | VARCHAR(16777216) | Human-readable explanation of why this inscription is flagged as unstable. |
| is_unbound | BOOLEAN | True if this inscription is not bound to a specific satoshi (created via a non-standard path). |
| is_cursed | BOOLEAN | True if this inscription is a cursed inscription (negative inscription number), created before Jubilee activation. |
| is_jubilant | BOOLEAN | True if this inscription was previously cursed but became blessed after the Jubilee upgrade at block 824544. |
| is_vindicated | BOOLEAN | True if this inscription was previously unbound or cursed but later vindicated. |
| collection_name | VARCHAR(16777216) | Collection name of the inscription, if applicable. |
| collection_slug | VARCHAR(16777216) | Collection slug of the inscription, if applicable. The collection slug is a human-readable, unique identifier. |
| collection_supply | NUMBER(38,0) | Collection supply, if applicable. |
| collection_icon | VARCHAR(16777216) | Collection icon, if applicable. |
| collection_description | VARCHAR(16777216) | Description of the collection, if applicable. |
| collection_twitter_link | VARCHAR(16777216) | Collection Twitter link, if applicable. |
| collection_discord_link | VARCHAR(16777216) | Collection Discord link, if applicable. |
| collection_website_link | VARCHAR(16777216) | Collection Website link, if applicable. |
| domain_protocol | VARCHAR(16777216) | Domain name protocol used to parse the content |
| domain_name | VARCHAR(16777216) | the domain name (portion before the . ) |
| domain_namespace | VARCHAR(16777216) | the domain namespace (portion after the . ) |
| domain_valid | BOOLEAN | true/false - domains are invalid if they are not the first or are unstable inscriptions |
| domain_meta | VARCHAR(16777216) | the metadata of the domain op, such as about, rev, avatar fields. |
| is_domain | BOOLEAN | 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. |
| previous_inscription_id | VARCHAR(73) | Inscription ID of the most recent prior inscription on the same satoshi, if any. |
| previous_inscription_id_is_unstable | BOOLEAN | True if the previous inscription is flagged as unstable. |
| previous_inscription_id_is_unstable_remarks | VARCHAR(16777216) | Explanation of why the previous inscription is flagged as unstable. |
| previous_inscription_id_transfer_count | NUMBER(38,0) | Number of times the previous inscription on this satoshi has been transferred. |
| output_address | VARCHAR(130) | The receiver address of the ordinal in the inscription tx |
| output_utxo_id | VARCHAR(73) | The output utxo id of the ordinal in the inscription tx |
| input_index | NUMBER(38,0) | Zero-based index of this input within the transaction’s input list. |
| output_offset | NUMBER(38,0) | Satoshi offset within the output UTXO at which this inscription is located. |
| output_index | NUMBER(38,0) | Zero-based index of this output within the transaction’s output list (equivalent to vout). |
| spent_transaction_hash | VARCHAR(66) | The transaction_hash of the spent input utxo in the inscription tx |
| spent_output_index | NUMBER(38,0) | The output index of the spent input utxo in the inscription tx |
| input_addresses | VARCHAR(16777216) | The owner(s) of the spent input utxo in the inscription tx |
| input_address0 | VARCHAR(130) | input_addresses[0] |
| spent_utxo_id | VARCHAR(73) | The utxo id of the spent input utxo in the inscription tx |
| value | VARCHAR(16777216) | The value of the spent input utxo |
| transaction_hash | VARCHAR(66) | The transaction_hash of the inscription tx |
| transaction_index | NUMBER(38,0) | Zero-based position of the transaction within its block. The first transaction in a block has index 0. |
| block_hash | VARCHAR(66) | The block_hash of the inscription tx |
| block_number | NUMBER(38,0) | The block_number of the inscription tx |
| block_timestamp | TIMESTAMP_NTZ(9) | The block_timestamp of the inscription tx |
| _fact_updated_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the most recent update to the underlying fact record feeding this row. |
| _dim_updated_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the most recent update to the dimension record (e.g. token metadata, entity label) joined into this row. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |
| unique_id | VARCHAR(73) | Unique ID of the inscription. |