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

{ "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

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 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