denarium-database/README.md at master · prasos/denarium-database

Official Denarium database

This is the official Denarium Bitcoin
database. The database is a single file, coin.tsv which
contains current status of all Denarium Bitcoins ever produced in
tab-separated format.

If you want to see coin details and transactions in a visual format, we also have the Denarium Database Explorer.

Provided data was automatically produced at 2021-01-05 12:47:31 UTC.
Content is signed by bitcoin address
1PrasosHejKfuRW6XgB6iYwftZQcatrMNC.
Proof of origin and existence of the data is in transaction
6ba18fab62db087823849e1371e7b38488b18895b6ea0a120106d123bf0c0799.

Verification

To verify the origin, check that the transaction originates from our bitcoin
address. To verify existence, calculate SHA256 of coin.tsv and
compare it to last bytes of OP_RETURN output of given bitcoin transaction.

There is also verify.py which does all of this
automatically. See that file for instructions.

Format

Data is separated to columns using tab (\t) character. Character set
is ASCII. It can be easily imported to common databases and
spreadsheet editors.

Column
Description

address
Bitcoin address of the coin

serial
Serial number (L series are pre-loaded coins)

pubkey
Reserved for future use

sku
Stock keeping unit (see below)

denomination
Bitcoin value of that coin after activation

batch
Production batch code (see below)

created_at
Timestamp of coin creation (importing is done in batches so this is not the exact moment of manufacture)

status
Coin status (see below)

pubkey_2fa
Reserved for future use

txid
Funding transaction ID. (Some of the txid’s have been subject to malleability attacks)

Coin status

Status
Description

new
Successfully manufactured, not shipped yet

failed
Destroyed on the production line

sample
Random samples for quality control

shipped
Shipped but not yet activated

reported_missing
Reported as missing by customer

reported_damaged
Reported as damaged by customer

reported_ok
Reported as OK by customer

missing
Confirmed as missing

complete
Successfully activated

SKU

The X in the SKU means that the coin is sold as empty and in most cases, the serial number begins with an E. For mock-up coins, prototypes and new models we use Bitcointalk for auctioning these pieces. These coins serial number usually starts with an A.

Serial number

SERIAL
Description

A
Auction coin (unique pieces sold as Bitcointalk)

E
Sold as empty or multisig

L
Sold as loaded with bitcoins

M
Used for special multisig coins

SKU JSON

The file coin_sku.json contains all the products with their corresponding SKU names. It is useful for creating charts and other tools to the top of the Denarium Database.

Production batch code

The format is in YYYY-MM-DD-N format and is composed of year, month,
day of the production set-up. The same set-up may have been used for
multiple days. In case of multiple set-ups per a day, N is
incremented.