Ordinals inscription mints on Bitcoin enable the creation of unique digital artifacts by embedding data directly onto individual satoshis. Each inscription is stored on-chain, making it immutable and distinct. The process involves inscribing data, such as images or text, to specific satoshis, creating a form of digital ownership and provenance. These inscribed satoshis can then be transferred or traded, similar to NFTs on other blockchains, but are native to the Bitcoin network.

You can learn more about this here: https://docs.ordinals.com/

Sample Query

Fetch inscription mint for given inscription id

select * from bitcoin.ordinals_inscription_mints where inscription_id = 'b1e70cd284689d6079ba391b5fbbb877a8b7362491e71ebb8a4c560d5f4fc53ci0';

Table Columns

This table is indexed on block_timestamp, transaction_hash, inscription_id, cleaned_token_tick.

ColumnDescriptionExample
inscription_idunique id of inscriptionb1e70cd284689d6079ba391b5fbbb877a8b7362491e71ebb8a4c560d5f4fc53ci0
genesis_feefee for inscription mint1085
is_tokenif inscription is brc-20 tokent
is_unstableif inscription is cursed or unstable according to ordinals docsf
is_unstable_remarkstype of unstable according to ordinals docs
content_protocoltoken protocolbrc-20
token_ticktoken tickpepe
token_amttoken amount1000
token_optoken operationmint
cleaned_token_tickcleaned token tickpepe
cleaned_token_typecleaned token typebrc-20
content_typecontent typetext/plain;charset=utf-8
parsed_contentparsed inscription content{"amt":"1000","op":"mint","p":"brc-20","tick":"pepe"}
sent_as_feeif the utxo was sent as part of feef
output_addressaddress receiving the inscriptionbc1p9tr85rcavpq22v92j5x3c0k74jpqnm2a00xjm8creysh2204nz3scw3zd0
output_utxo_idoutput utxo idb1e70cd284689d6079ba391b5fbbb877a8b7362491e71ebb8a4c560d5f4fc53c:0
output_offsetoutput offset0
output_indexoutput index0
spent_transaction_hashspent transaction hash of input utxo8dffd2e90f42e9ff5b3893a8bff01cc62852e253fcf8f1ec281004f22a6232c0
spent_output_indexspent output index of input utxo60
input_address0input addressbc1pjctpfln4g5swx5ffu27zjj96n4t02r4m7ugvhzjpxzvv607agyfqw2qghz
input_indexinput index0
spent_utxo_idspent utxo id of input8dffd2e90f42e9ff5b3893a8bff01cc62852e253fcf8f1ec281004f22a6232c0:60
valuevalue of utxo containing inscription1631
sat_tx_offsetsat offset of inscription mint in output utxo0
transaction_hashtransaction hash of incsription mintb1e70cd284689d6079ba391b5fbbb877a8b7362491e71ebb8a4c560d5f4fc53c
transaction_indextransaction index of inscription mint849
block_timestampblock timestamp of inscription mint2023-03-21 04:34:59
block_numberblock number of inscription mint781761
block_hashblock hash of inscription mint000000000000000000039578eb6aaaccf0e33392a64512a70a28bc2af6b99710
is_vindicatedwhether inscription is vindicated according to ordinals docs