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
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
{ "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 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
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
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.
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
Last updated