Skip to content
Satoshi Gazette
Data Desk

Dictionary

Every field in the Gazette’s files: its type, its unit, what it holds and what an empty value means.

Empty values

An empty value is a JSON null, a key a row leaves out, an empty text, an empty list or an empty CSV cell. None of them is ever written as 0: a 0 in a file is a counted or a stated zero, and the Gazette reads it as one.

not disclosed
The source could have stated it and did not. The gap is the source’s.
not read
The Gazette has not read it, or did not record it. The gap is the Gazette’s, and a later read may fill it.
not applicable
The field has no meaning for this row, so there is nothing to state.
not in this dataset
Left out of this file on purpose: another dataset holds it, or it is outside what the file covers.
none listed
A list with nothing in it: the record was read and names none. That is a known nothing, not an unknown.
never empty
A JSON field holds a value wherever the group or the list item it sits in is present; a group or a list that can itself be empty has a row of its own, which says when. A CSV column holds a value in every row. The Gazette’s tests check both against the committed data.

Types, units and marks

A JSON field is named by its path. rows[].day is day in each item of rows; [] is every item of a list, [2] the third place in a row written as a list, and a part in braces, {line}, a key that is itself data. A group of fields has a row of its own only where the whole group can be empty.

Types

text
Text.
whole number
A whole number.
decimal text
An exact decimal written as text, so no digit passes through a float.
true/false
true or false.
list
A list. Its unit is the unit of each item; a list of groups or of rows has none.
group
A group of named fields. A group has a row of its own only where it can be empty.

Units

BTC
Bitcoin, to at most eight places.
sats
Satoshis: 100,000,000 to the bitcoin.
blocks
A number of blocks.
height
A block height, counted from the genesis block at 0.
count
A number of the things the field names. 0 is a count of none.
index
A place in an order, counted from 0 or from 1 as the field says.
percent
A percentage.
ratio
A number with no unit: a difficulty, or one target over another.
minutes
Minutes.
Unix seconds
Seconds since 1 January 1970, UTC.
ISO date
A day, as YYYY-MM-DD.
ISO date-time
A moment in UTC, as YYYY-MM-DDTHH:MM:SSZ.
hash
A digest in lowercase hex: a block hash, a sha256 or a git commit.
hex
A number in lowercase hexadecimal digits.
URL
A web address. A part in braces, such as {height}, stands for a value.
identifier
A name, number or code that picks out one thing: an accession number, a ticker, a version.
set value
One of a short list of words the file’s loader allows; the meaning names them.
none
No unit: words, true or false, a group, or a list of groups or of rows.

Marks on a figure

lower bound
A floor on disclosed positions, never an estimate: only what a holder disclosed is counted, each as of its own date, and what nobody disclosed is left out.
cut
Cut to the places shown, never rounded, so it is never above the exact value.
approximate
The filing’s own “approximately”. The number is kept as filed, and the row’s approximate field says when the filing used the word.
as stated
Rests on a holder’s or an issuer’s own statement, as of the date that statement gives. The Gazette did not check it against the chain.
heuristic
Rests on a labelling rule, not a record: a pool label, or what a node says it runs.
one source
Chain data read from one operator and not matched on a second. Where that is so of some rows only, the field says which.

Datasets

13 datasets have a file today, holding 759 JSON fields and 187 CSV columns.

Node software on reachable nodes

Every peer in KIT’s network snapshot, by the software it announces.

sg-node-software82 JSON fields43 CSV columns

JSON fieldssg-node-software.json

JSON fields of Node software on reachable nodes
FieldTypeUnitWhat it holdsWhen it is empty
schema_versiontextidentifierThe name and version of the file’s layout; the site’s loader refuses any other.Never empty
datasettextidentifierThe dataset’s ID in the register.Never empty
methodology_versiontextidentifierThe version of the method the file was built with.Never empty
headline_populationtextset valueThe population the pages lead with: connected or opened_24h.Never empty
populations.connectedtextnoneWhat the connected population counts, in the file’s own words.Never empty
populations.opened_24htextnoneWhat the opened_24h population counts, in the file’s own words.Never empty
source.nametextnoneThe name of KIT’s monitor, the one source of the counts.Never empty
source.publishertextnoneThe research group that runs the monitor.Never empty
source.data_pagetextURLKIT’s page describing its data.Never empty
source.listingtextURLKIT’s listing of its snapshot files.Never empty
source.snapshot_url_templatetextURLThe address of one snapshot file; {snapshot} stands for a row’s snapshot.Never empty
source.licencetextnoneThe licence KIT publishes its snapshots under.Never empty
source.licence_urltextURLAddress of the licence KIT publishes its snapshots under.Never empty
source.doitextidentifierThe DOI of KIT’s dataset.Never empty
source.citationtextnoneHow KIT’s dataset is cited, the credit its licence asks for.Never empty
source.changestextnoneWhat the Gazette changed in KIT’s records, which the licence asks it to say.Never empty
lifecycle_filetextidentifierThe Gazette file the Core release lines are classified against: the sg-core-lifecycle dataset.Never empty
ua_ruleslistnoneThe rules that sort a user agent into an implementation, in order; the first match wins.Never empty
ua_rules[].implementationtextset valueWhat the rule sorts a peer as: core, knots, btcd, other, unknown.Never empty
ua_rules[].ruletextnoneThe rule, in words.Never empty
method.populationtextnoneThe file’s own note on which peers each population holds.Never empty
method.clocktextnoneThe file’s own note on how KIT’s local clock is turned into UTC.Never empty
method.classificationtextnoneThe file’s own note on sorting peers by the user agent they announce.Never empty
method.lifecycletextnoneThe file’s own note on classifying Core release lines as maintained or end of life.Never empty
method.service_flagstextnoneThe file’s own note on counting the two Knots service flags.Never empty
method.precisiontextnoneThe file’s own note on how a share is printed from the counts.Never empty
method.decisiontextnoneThe file’s own note on which population the headline uses, and since when.Never empty
method.holdstextnoneThe file’s own note on when a day is held and nothing is written.Never empty
gapslistnoneThe days since the first row that hold no row, oldest first, each with why.not applicable Every day since the first row is recorded. The key is then left out.
gaps[].daytextISO dateA UTC date the series holds no row for.Never empty
gaps[].reasontextnoneWhy: no KIT snapshot that day, or the count check stopped the day and it was not recorded.Never empty
gaps[].recorded_attextISO date-timeWhen the day was written down as not recorded.Never empty
baselineslistnoneDays the counts jumped past the count check and that are recorded as read, oldest first, each with what changed.not applicable No such day. The key is then left out.
baselines[].from_daytextISO dateA day recorded as read although its counts jumped past the count check; the check’s median runs from it.Never empty
baselines[].reasontextnoneWhat changed on the day.Never empty
baselines[].recorded_attextISO date-timeWhen the day was recorded.Never empty
rowslistnoneOne item per KIT snapshot day recorded, oldest first.Never empty
rows[].daytextISO dateThe snapshot’s UTC date.Never empty
rows[].snapshottextidentifierKIT’s name for the snapshot file: its time in UTC, as YYYYMMDD_HHMMSS.Never empty
rows[].snapshot_attextISO date-timeThe snapshot’s time in UTC, as a timestamp.Never empty
rows[].clock_offset_minuteswhole numberminutesMinutes KIT’s lastConnect clock ran ahead of UTC, derived from the file.Never empty
rows[].lifecycle_as_oftextISO dateThe day of the Core lifecycle table the row was classified with.Never empty
rows[].sha256texthashsha256 of KIT’s snapshot file as served, so the row can be checked against KIT’s copy.Never empty
rows[].connected.nodeswhole numbercountAll connected peers: peers counted.Never empty
rows[].connected.ipv4whole numbercountAll connected peers: reached over IPv4.Never empty
rows[].connected.ipv6whole numbercountAll connected peers: reached over IPv6.Never empty
rows[].connected.ip_unknownwhole numbercountAll connected peers: KIT recorded no IP version.Never empty
rows[].connected.implementation.corewhole numbercountAll connected peers: user agent sorted as core by ua_rules.heuristicNever empty
rows[].connected.implementation.knotswhole numbercountAll connected peers: user agent sorted as knots by ua_rules.heuristicNever empty
rows[].connected.implementation.btcdwhole numbercountAll connected peers: user agent sorted as btcd by ua_rules.heuristicNever empty
rows[].connected.implementation.otherwhole numbercountAll connected peers: user agent sorted as other by ua_rules.heuristicNever empty
rows[].connected.implementation.unknownwhole numbercountAll connected peers: no user agent the rules can read.heuristicNever empty
rows[].connected.core_lifecycle.maintainedwhole numbercountAll connected peers: Core peers on a release line that was maintained on the snapshot day.heuristicNever empty
rows[].connected.core_lifecycle.end_of_lifewhole numbercountAll connected peers: Core peers on a release line that was end of life on the snapshot day.heuristicNever empty
rows[].connected.core_lifecycle.unreleasedwhole numbercountAll connected peers: Core peers on a release line not yet released on the snapshot day, or on an x.99 development build.heuristicNever empty
rows[].connected.core_lifecycle.not_listedwhole numbercountAll connected peers: Core peers on a release line the life cycle table does not carry, or announcing a version that does not parse.heuristicNever empty
rows[].connected.core_lines.{line}whole numbercountCore peers announcing a version on the release line the key names, such as 31.x; development counts x.99 builds and unparsed counts versions that do not parse.heuristicNever empty
rows[].opened_24h.nodeswhole numbercountPeers whose connection began within 24 hours of the snapshot: peers counted.Never empty
rows[].opened_24h.ipv4whole numbercountPeers whose connection began within 24 hours of the snapshot: reached over IPv4.Never empty
rows[].opened_24h.ipv6whole numbercountPeers whose connection began within 24 hours of the snapshot: reached over IPv6.Never empty
rows[].opened_24h.ip_unknownwhole numbercountPeers whose connection began within 24 hours of the snapshot: KIT recorded no IP version.Never empty
rows[].opened_24h.implementation.corewhole numbercountPeers whose connection began within 24 hours of the snapshot: user agent sorted as core by ua_rules.heuristicNever empty
rows[].opened_24h.implementation.knotswhole numbercountPeers whose connection began within 24 hours of the snapshot: user agent sorted as knots by ua_rules.heuristicNever empty
rows[].opened_24h.implementation.btcdwhole numbercountPeers whose connection began within 24 hours of the snapshot: user agent sorted as btcd by ua_rules.heuristicNever empty
rows[].opened_24h.implementation.otherwhole numbercountPeers whose connection began within 24 hours of the snapshot: user agent sorted as other by ua_rules.heuristicNever empty
rows[].opened_24h.implementation.unknownwhole numbercountPeers whose connection began within 24 hours of the snapshot: no user agent the rules can read.heuristicNever empty
rows[].opened_24h.core_lifecycle.maintainedwhole numbercountPeers whose connection began within 24 hours of the snapshot: Core peers on a release line that was maintained on the snapshot day.heuristicNever empty
rows[].opened_24h.core_lifecycle.end_of_lifewhole numbercountPeers whose connection began within 24 hours of the snapshot: Core peers on a release line that was end of life on the snapshot day.heuristicNever empty
rows[].opened_24h.core_lifecycle.unreleasedwhole numbercountPeers whose connection began within 24 hours of the snapshot: Core peers on a release line not yet released on the snapshot day, or on an x.99 development build.heuristicNever empty
rows[].opened_24h.core_lifecycle.not_listedwhole numbercountPeers whose connection began within 24 hours of the snapshot: Core peers on a release line the life cycle table does not carry, or announcing a version that does not parse.heuristicNever empty
rows[].service_flagsgroupnoneThe peers sorted by the two service flags Bitcoin Knots defines, as each peer announced them.heuristicnot read The row was recorded before the flags were counted, and its snapshot has not been read again under the proof the method asks for.
rows[].service_flags.connected.blake2b_onlywhole numbercountAll connected peers announcing the BLAKE2b flag only.heuristicNever empty
rows[].service_flags.connected.reduced_data_onlywhole numbercountAll connected peers announcing the reduced-data flag only.heuristicNever empty
rows[].service_flags.connected.bothwhole numbercountAll connected peers announcing both flags.heuristicNever empty
rows[].service_flags.connected.neitherwhole numbercountAll connected peers announcing neither flag.heuristicNever empty
rows[].service_flags.connected.unknownwhole numbercountAll connected peers whose services number was missing or unreadable: unknown, never neither.heuristicNever empty
rows[].service_flags.knots.blake2b_onlywhole numbercountKnots peers announcing the BLAKE2b flag only.heuristicNever empty
rows[].service_flags.knots.reduced_data_onlywhole numbercountKnots peers announcing the reduced-data flag only.heuristicNever empty
rows[].service_flags.knots.bothwhole numbercountKnots peers announcing both flags.heuristicNever empty
rows[].service_flags.knots.neitherwhole numbercountKnots peers announcing neither flag.heuristicNever empty
rows[].service_flags.knots.unknownwhole numbercountKnots peers whose services number was missing or unreadable: unknown, never neither.heuristicNever empty
rows[].possible_captrue/falsenonetrue when the snapshot held exactly 9,000 peers, which may be a cap on KIT’s file rather than a count of the network.not applicable The snapshot held another number of peers, so no cap is in question. The key is then left out, which reads as false: the JSON never writes false, and the CSV does.

CSV columnssg-node-software.csv

One row per KIT snapshot day recorded; 3 days not recorded are listed in the JSON’s gaps and in the notes. Core peers by release line vary by day and are in the JSON only.

CSV columns of Node software on reachable nodes
ColumnTypeUnitWhat it holdsWhen it is empty
dayJSON: rows[].daytextISO dateThe snapshot’s UTC date.Never empty
snapshotJSON: rows[].snapshottextidentifierKIT’s name for the snapshot file, its time in UTC.Never empty
snapshot_atJSON: rows[].snapshot_attextISO date-timeThe same time as an ISO 8601 timestamp.Never empty
clock_offset_minutesJSON: rows[].clock_offset_minuteswhole numberminutesMinutes KIT’s lastConnect clock ran ahead of UTC, derived from the file.Never empty
lifecycle_as_ofJSON: rows[].lifecycle_as_oftextISO dateThe day of the Core lifecycle table the row was classified with.Never empty
sha256JSON: rows[].sha256texthashsha256 of KIT’s snapshot file as served.Never empty
possible_capJSON: rows[].possible_captrue/falsenonetrue when the snapshot held exactly 9,000 peers, which may be a cap on KIT’s file.Never empty
connected_nodesJSON: rows[].connected.nodeswhole numbercountAll connected peers: peers counted.Never empty
connected_ipv4JSON: rows[].connected.ipv4whole numbercountAll connected peers: reached over IPv4.Never empty
connected_ipv6JSON: rows[].connected.ipv6whole numbercountAll connected peers: reached over IPv6.Never empty
connected_ip_unknownJSON: rows[].connected.ip_unknownwhole numbercountAll connected peers: IP version not recorded.Never empty
connected_coreJSON: rows[].connected.implementation.corewhole numbercountAll connected peers: user agent sorted as core by the rules in the JSON.heuristicNever empty
connected_knotsJSON: rows[].connected.implementation.knotswhole numbercountAll connected peers: user agent sorted as knots by the rules in the JSON.heuristicNever empty
connected_btcdJSON: rows[].connected.implementation.btcdwhole numbercountAll connected peers: user agent sorted as btcd by the rules in the JSON.heuristicNever empty
connected_otherJSON: rows[].connected.implementation.otherwhole numbercountAll connected peers: user agent sorted as other by the rules in the JSON.heuristicNever empty
connected_unknownJSON: rows[].connected.implementation.unknownwhole numbercountAll connected peers: user agent sorted as unknown by the rules in the JSON.heuristicNever empty
connected_core_maintainedJSON: rows[].connected.core_lifecycle.maintainedwhole numbercountAll connected peers: Core peers on a release line that was maintained on the snapshot day.heuristicNever empty
connected_core_end_of_lifeJSON: rows[].connected.core_lifecycle.end_of_lifewhole numbercountAll connected peers: Core peers on a release line that was end of life on the snapshot day.heuristicNever empty
connected_core_unreleasedJSON: rows[].connected.core_lifecycle.unreleasedwhole numbercountAll connected peers: Core peers on a release line not yet released on the snapshot day, or on an x.99 development build.heuristicNever empty
connected_core_not_listedJSON: rows[].connected.core_lifecycle.not_listedwhole numbercountAll connected peers: Core peers on a release line the life cycle table does not carry, or announcing a version that does not parse.heuristicNever empty
opened_24h_nodesJSON: rows[].opened_24h.nodeswhole numbercountPeers whose connection began within 24 hours: peers counted.Never empty
opened_24h_ipv4JSON: rows[].opened_24h.ipv4whole numbercountPeers whose connection began within 24 hours: reached over IPv4.Never empty
opened_24h_ipv6JSON: rows[].opened_24h.ipv6whole numbercountPeers whose connection began within 24 hours: reached over IPv6.Never empty
opened_24h_ip_unknownJSON: rows[].opened_24h.ip_unknownwhole numbercountPeers whose connection began within 24 hours: IP version not recorded.Never empty
opened_24h_coreJSON: rows[].opened_24h.implementation.corewhole numbercountPeers whose connection began within 24 hours: user agent sorted as core by the rules in the JSON.heuristicNever empty
opened_24h_knotsJSON: rows[].opened_24h.implementation.knotswhole numbercountPeers whose connection began within 24 hours: user agent sorted as knots by the rules in the JSON.heuristicNever empty
opened_24h_btcdJSON: rows[].opened_24h.implementation.btcdwhole numbercountPeers whose connection began within 24 hours: user agent sorted as btcd by the rules in the JSON.heuristicNever empty
opened_24h_otherJSON: rows[].opened_24h.implementation.otherwhole numbercountPeers whose connection began within 24 hours: user agent sorted as other by the rules in the JSON.heuristicNever empty
opened_24h_unknownJSON: rows[].opened_24h.implementation.unknownwhole numbercountPeers whose connection began within 24 hours: user agent sorted as unknown by the rules in the JSON.heuristicNever empty
opened_24h_core_maintainedJSON: rows[].opened_24h.core_lifecycle.maintainedwhole numbercountPeers whose connection began within 24 hours: Core peers on a release line that was maintained on the snapshot day.heuristicNever empty
opened_24h_core_end_of_lifeJSON: rows[].opened_24h.core_lifecycle.end_of_lifewhole numbercountPeers whose connection began within 24 hours: Core peers on a release line that was end of life on the snapshot day.heuristicNever empty
opened_24h_core_unreleasedJSON: rows[].opened_24h.core_lifecycle.unreleasedwhole numbercountPeers whose connection began within 24 hours: Core peers on a release line not yet released on the snapshot day, or on an x.99 development build.heuristicNever empty
opened_24h_core_not_listedJSON: rows[].opened_24h.core_lifecycle.not_listedwhole numbercountPeers whose connection began within 24 hours: Core peers on a release line the life cycle table does not carry, or announcing a version that does not parse.heuristicNever empty
flags_connected_blake2b_onlyJSON: rows[].service_flags.connected.blake2b_onlywhole numbercountAll connected peers announcing the BLAKE2b flag only; empty when the split was not counted.heuristicnot read The row was recorded before the flags were counted, and its snapshot has not been read again under the proof the method asks for.
flags_connected_reduced_data_onlyJSON: rows[].service_flags.connected.reduced_data_onlywhole numbercountAll connected peers announcing the reduced-data flag only; empty when the split was not counted.heuristicnot read The row was recorded before the flags were counted, and its snapshot has not been read again under the proof the method asks for.
flags_connected_bothJSON: rows[].service_flags.connected.bothwhole numbercountAll connected peers announcing both flags; empty when the split was not counted.heuristicnot read The row was recorded before the flags were counted, and its snapshot has not been read again under the proof the method asks for.
flags_connected_neitherJSON: rows[].service_flags.connected.neitherwhole numbercountAll connected peers announcing neither flag; empty when the split was not counted.heuristicnot read The row was recorded before the flags were counted, and its snapshot has not been read again under the proof the method asks for.
flags_connected_unknownJSON: rows[].service_flags.connected.unknownwhole numbercountAll connected peers whose services number was missing or unreadable: unknown, never neither; empty when the split was not counted.heuristicnot read The row was recorded before the flags were counted, and its snapshot has not been read again under the proof the method asks for.
flags_knots_blake2b_onlyJSON: rows[].service_flags.knots.blake2b_onlywhole numbercountKnots peers announcing the BLAKE2b flag only; empty when the split was not counted.heuristicnot read The row was recorded before the flags were counted, and its snapshot has not been read again under the proof the method asks for.
flags_knots_reduced_data_onlyJSON: rows[].service_flags.knots.reduced_data_onlywhole numbercountKnots peers announcing the reduced-data flag only; empty when the split was not counted.heuristicnot read The row was recorded before the flags were counted, and its snapshot has not been read again under the proof the method asks for.
flags_knots_bothJSON: rows[].service_flags.knots.bothwhole numbercountKnots peers announcing both flags; empty when the split was not counted.heuristicnot read The row was recorded before the flags were counted, and its snapshot has not been read again under the proof the method asks for.
flags_knots_neitherJSON: rows[].service_flags.knots.neitherwhole numbercountKnots peers announcing neither flag; empty when the split was not counted.heuristicnot read The row was recorded before the flags were counted, and its snapshot has not been read again under the proof the method asks for.
flags_knots_unknownJSON: rows[].service_flags.knots.unknownwhole numbercountKnots peers whose services number was missing or unreadable: unknown, never neither; empty when the split was not counted.heuristicnot read The row was recorded before the flags were counted, and its snapshot has not been read again under the proof the method asks for.

Datasets ↑

Node software releases

bitcoincore.org’s support windows and advisories, with Knots releases beside them.

sg-core-lifecycle90 JSON fieldsNo CSV

JSON fieldssg-core-lifecycle.json

JSON fields of Node software releases
FieldTypeUnitWhat it holdsWhen it is empty
schema_versiontextidentifierThe name and version of the file’s layout; the site’s loader refuses any other.Never empty
datasettextidentifierThe dataset’s ID in the register.Never empty
methodology_versiontextidentifierThe version of the method the file was built with.Never empty
observed_attextISO date-timeWhen the sources answered: the latest of their five served_at times.Never empty
sources.lifecycle.urltextURLThe address of bitcoincore.org’s life cycle table.Never empty
sources.lifecycle.served_attextISO date-timeThe source’s HTTP Date header when it answered: its clock, not the Gazette’s.Never empty
sources.lifecycle.last_modifiedtextISO date-timeThe source’s Last-Modified header.not disclosed The server sent no Last-Modified header.
sources.lifecycle.licencetextnoneThe licence the source is published under.Never empty
sources.lifecycle.licence_urltextURLAddress of the licence the source is published under.Never empty
sources.security_advisories.urltextURLThe address of bitcoincore.org’s index of security advisories.Never empty
sources.security_advisories.served_attextISO date-timeThe source’s HTTP Date header when it answered: its clock, not the Gazette’s.Never empty
sources.security_advisories.last_modifiedtextISO date-timeThe source’s Last-Modified header.not disclosed The server sent no Last-Modified header.
sources.security_advisories.licencetextnoneThe licence the source is published under.Never empty
sources.security_advisories.licence_urltextURLAddress of the licence the source is published under.Never empty
sources.core_releases.urltextURLThe address of bitcoincore.org’s releases page.Never empty
sources.core_releases.served_attextISO date-timeThe source’s HTTP Date header when it answered: its clock, not the Gazette’s.Never empty
sources.core_releases.last_modifiedtextISO date-timeThe source’s Last-Modified header.not disclosed The server sent no Last-Modified header.
sources.core_releases.licencetextnoneThe licence the source is published under.Never empty
sources.core_releases.licence_urltextURLAddress of the licence the source is published under.Never empty
sources.knots_releases.urltextURLThe address of the Bitcoin Knots releases feed on GitHub.Never empty
sources.knots_releases.served_attextISO date-timeThe source’s HTTP Date header when it answered: its clock, not the Gazette’s.Never empty
sources.knots_releases.last_modifiedtextISO date-timeThe source’s Last-Modified header.not disclosed The server sent no Last-Modified header.
sources.knots_releases.licencetextnoneThe licence the source is published under.Never empty
sources.knots_releases.licence_urltextURLAddress of the licence the source is published under.Never empty
sources.knots_published.urltextURLThe address of GitHub’s release record for Bitcoin Knots, its public releases API.Never empty
sources.knots_published.served_attextISO date-timeThe source’s HTTP Date header when it answered: its clock, not the Gazette’s.Never empty
sources.knots_published.last_modifiedtextISO date-timeThe source’s Last-Modified header.not disclosed The server sent no Last-Modified header.
sources.knots_published.licencetextnoneThe licence the source is published under.Never empty
sources.knots_published.licence_urltextURLAddress of the licence the source is published under.Never empty
core_lineslistnoneOne item per Bitcoin Core release line in the life cycle table, newest first.Never empty
core_lines[].linetextidentifierThe release line as the table writes it: 31.x, 0.21.x.Never empty
core_lines[].majortextidentifierThe line’s major version: 31, 0.21.Never empty
core_lines[].release_datetextISO dateThe day the table gives for the line’s release.not disclosed The table gives no release date yet; release_note holds its words instead.
core_lines[].release_notetextnoneThe table’s own words where it gives no release date, such as TBA.not applicable The table gives a release date.
core_lines[].maintenance_endtextISO dateThe day the line leaves maintenance.not disclosed The table on bitcoincore.org publishes no maintenance-end date, so none is recorded for any line.
core_lines[].end_of_life.datetextISO dateThe end-of-life date the table publishes.not disclosed The table gives a condition instead of a date. The date is never projected.
core_lines[].end_of_life.conditiontextnoneThe table’s condition where it gives no date: after v34.0.not applicable The table gives a date.
core_lines[].end_of_life.after_majortextidentifierThe major version whose release ends the line, read from the condition.not applicable The table gives a date.
security_advisorieslistnoneOne item per advisory in bitcoincore.org’s index, newest first.Never empty
security_advisories[].titletextnoneThe advisory’s title, as the index gives it.Never empty
security_advisories[].urltextURLThe advisory’s post on bitcoincore.org.Never empty
security_advisories[].postedtextISO dateThe post’s date, taken from its address.Never empty
security_advisories[].cve_idslistidentifierThe CVE identifiers in the advisory’s title.none listed The title names no CVE identifier.
security_advisories[].postgroupnoneThe advisory’s own post on bitcoincore.org, read once, when the advisory was new to the index.not read The advisory's post was not read. The key is then left out.
security_advisories[].post.served_attextISO date-timeThe post’s HTTP Date header when it answered: its clock, not the Gazette’s.Never empty
security_advisories[].post.last_modifiedtextISO date-timeThe post’s Last-Modified header.not disclosed The server sent no Last-Modified header.
security_advisories[].post.sha256texthashsha256 of the post’s body as served.Never empty
security_advisories[].post.byteswhole numbercountThe length of that body in bytes.Never empty
security_advisories[].post.heldtextnoneWhy the post’s statements were not read.not applicable The post was read: its three statements are kept.
security_advisories[].post.severitygroupnoneThe post’s severity sentence, which names one of the four severities of Bitcoin Core’s disclosure policy.not read The post is held: it states this in no shape the Gazette reads, and held says why.
security_advisories[].post.severity.htmltextnoneThe sentence exactly as the post’s markup has it, byte for byte.Never empty
security_advisories[].post.severity.offsetwhole numberindexThe byte, counted from 0, at which that markup starts in the post as served.Never empty
security_advisories[].post.severity.texttextnoneThe markup’s text form, which a sentence may quote: tags taken out, the five named entities and the numbered ones read, each run of white space one space, none at either end.Never empty
security_advisories[].post.severity.leveltextset valueThe severity it names: Low, Medium, High or Critical.Never empty
security_advisories[].post.affectedgroupnoneWhat the post’s first paragraph states of the versions affected.not read The post is held: it states this in no shape the Gazette reads, and held says why.
security_advisories[].post.affected.htmltextnoneThe statement exactly as the post’s markup has it, byte for byte.Never empty
security_advisories[].post.affected.offsetwhole numberindexThe byte, counted from 0, at which that markup starts in the post as served.Never empty
security_advisories[].post.affected.texttextnoneThe markup’s text form, which a sentence may quote: tags taken out, the five named entities and the numbered ones read, each run of white space one space, none at either end.Never empty
security_advisories[].post.affected.formtextset valuebefore where the post names the versions affected as those before a list of versions, ranges where it names them from one version to another.Never empty
security_advisories[].post.affected.versionslistidentifierThe versions the statement names, in its order.Never empty
security_advisories[].post.fixed_inlistnoneOne item per line of the post’s timeline that says a Bitcoin Core release is released with a fix, in the timeline’s order.none listed The post is held, so no line of its timeline is kept.
security_advisories[].post.fixed_in[].htmltextnoneThe timeline line exactly as the post’s markup has it, byte for byte.Never empty
security_advisories[].post.fixed_in[].offsetwhole numberindexThe byte, counted from 0, at which that markup starts in the post as served.Never empty
security_advisories[].post.fixed_in[].texttextnoneThe markup’s text form, which a sentence may quote: tags taken out, the five named entities and the numbered ones read, each run of white space one space, none at either end.Never empty
security_advisories[].post.fixed_in[].daytextISO dateThe day the line gives, as the post writes it.Never empty
security_advisories[].post.fixed_in[].versiontextidentifierThe Bitcoin Core version the line names.Never empty
core_releaseslistnoneOne item per release on bitcoincore.org’s releases page, in the page’s order.Never empty
core_releases[].versiontextidentifierThe release’s version as the page names it: 31.1, 0.19.0.1.Never empty
core_releases[].urltextURLThe release’s own page on bitcoincore.org.Never empty
core_releases[].publishedtextISO dateThe day the release’s own page says it was published, read once, when its version first appears on the releases page.not disclosed The release’s page states no day.
knots_releaseslistnoneOne item per release in the Bitcoin Knots releases feed on GitHub, newest first; a release that has left the feed stays as last recorded.Never empty
knots_releases[].tagtextidentifierThe release’s tag.Never empty
knots_releases[].titletextnoneThe release’s title in the feed.Never empty
knots_releases[].urltextURLThe release on GitHub.Never empty
knots_releases[].feed_updatedtextISO date-timeThe feed’s time for the release entry: GitHub’s clock, not a publication date.Never empty
knots_releases[].prereleasetrue/falsenonetrue for a release candidate.Never empty
knots_releases[].core_basetextidentifierThe Bitcoin Core version the release is built on, read from the tag.not disclosed The tag does not name one in the form the Gazette reads.
knots_releases[].version_datetextISO dateThe Knots version date inside the tag, which is not a release date.not disclosed The tag carries no date in the form the Gazette reads.
knots_publishedlistnoneOne item per Bitcoin Knots release in GitHub’s release record, newest first; a release older than the newest 30 a read sees stays as last recorded.Never empty
knots_published[].tagtextidentifierThe release’s tag.Never empty
knots_published[].nametextnoneThe release’s name on GitHub.not disclosed The release has no name on GitHub.
knots_published[].urltextURLThe release on GitHub.Never empty
knots_published[].published_attextISO date-timeGitHub’s time for the release’s publication.Never empty
knots_published[].prereleasetrue/falsenonetrue for a release GitHub marks as a pre-release.Never empty
notes.maintenance_endtextnoneThe file’s own note on why no maintenance-end date is recorded.Never empty
notes.end_of_lifetextnoneThe file’s own note on a line whose end of life is a condition, not a date.Never empty
notes.security_advisoriestextnoneThe file’s own note on what the advisory list holds and leaves out.Never empty
notes.core_releasestextnoneThe file’s own note on what the list of Core releases holds and how a release’s day is read.Never empty
notes.knots_releasestextnoneThe file’s own note on what the Knots feed carries and how its dates read.Never empty
notes.knots_publishedtextnoneThe file’s own note on what GitHub’s release record for Knots carries.Never empty

CSV columns

JSON only: the file holds five lists (release lines, security advisories, Core releases, the Knots feed and Knots’ release record), not one table.

Datasets ↑

Lightning and BTCPay Server releases

Releases of LND, Core Lightning, Eclair and BTCPay Server, from GitHub’s release record.

sg-lightning-releases29 JSON fieldsNo CSV

JSON fieldssg-lightning-releases.json

JSON fields of Lightning and BTCPay Server releases
FieldTypeUnitWhat it holdsWhen it is empty
schema_versiontextidentifierThe name and version of the file’s layout; the site’s loader refuses any other.Never empty
datasettextidentifierThe dataset’s ID in the register.Never empty
methodology_versiontextidentifierThe version of the method the file was built with.Never empty
observed_attextISO date-timeWhen GitHub answered: the latest of the four projects’ served_at times.Never empty
projectslistnoneOne item per project read, in a fixed order: LND, Core Lightning, Eclair, BTCPay Server.Never empty
projects[].projecttextidentifierThe project’s key in this file: lnd, cln, eclair or btcpay.Never empty
projects[].nametextnoneThe project’s name.Never empty
projects[].repositorytextidentifierThe project’s repository on GitHub, as owner and name.Never empty
projects[].source.urltextURLThe address of GitHub’s release record for the repository, its public releases API.Never empty
projects[].source.served_attextISO date-timeGitHub’s HTTP Date header when it answered: its clock, not the Gazette’s.Never empty
projects[].source.last_modifiedtextISO date-timeGitHub’s Last-Modified header.not disclosed GitHub sent no Last-Modified header.
projects[].source.licencetextnoneThe licence the repository states.Never empty
projects[].source.licence_urltextURLAddress of the licence the repository states.Never empty
projects[].releaseslistnoneOne item per release of the project in GitHub’s release record, newest first; a release older than the newest 30 a read sees stays as last recorded.Never empty
projects[].releases[].tagtextidentifierThe release’s tag.Never empty
projects[].releases[].nametextnoneThe release’s name on GitHub.not disclosed The release has no name on GitHub, or its name carries a word the Gazette does not print.
projects[].releases[].urltextURLThe release on GitHub.Never empty
projects[].releases[].published_attextISO date-timeGitHub’s time for the release’s publication.Never empty
projects[].releases[].prereleasetrue/falsenonetrue for a release GitHub marks as a pre-release.Never empty
projects[].releases[].notes.sha256texthashsha256 of the release’s notes as GitHub’s record gave them when the release was new to the file, as UTF-8 text; a release with no notes is the empty text.Never empty
projects[].releases[].notes.byteswhole numbercountThe length of those notes in bytes.Never empty
projects[].releases[].notes.quotegroupnoneThe sentence the notes open with, kept so it can be found in them again to the byte.not applicable No sentence is kept: the project is LND, or the notes open with no sentence in the form the Gazette keeps.
projects[].releases[].notes.quote.texttextnoneThe sentence, exactly as the notes have it.Never empty
projects[].releases[].notes.quote.offsetwhole numberindexThe byte, counted from 0, at which the sentence starts in the notes.Never empty
projects[].releases[].withdrawn_ontextISO dateThe day of the read that first found the release gone from GitHub’s record.not applicable GitHub’s record lists the release, or the release is older than the newest a read sees. The key is then left out.
notes.releasestextnoneThe file’s own note on what each project’s list of releases holds.Never empty
notes.withdrawntextnoneThe file’s own note on a release that has left GitHub’s record.Never empty
notes.notestextnoneThe file’s own note on how a release’s notes are read.Never empty
notes.quotetextnoneThe file’s own note on which sentence of the notes is kept.Never empty

CSV columns

JSON only: the file holds one list of releases for each of four projects, not one table.

Datasets ↑

BIP status

Every BIP’s status in the BIP repository’s own words, and the changes recorded.

sg-bip-status44 JSON fields15 CSV columns

JSON fieldssg-bip-status.json

JSON fields of BIP status
FieldTypeUnitWhat it holdsWhen it is empty
schema_versiontextidentifierThe name and version of the file’s layout; the site’s loader refuses any other.Never empty
datasettextidentifierThe dataset’s ID in the register.Never empty
methodology_versiontextidentifierThe version of the method the file was built with.Never empty
observed_attextISO date-timeGitHub’s HTTP Date header when the repository’s commits feed answered: its clock, not the Gazette’s.Never empty
repository.urltextURLThe BIP repository.Never empty
repository.branchtextidentifierThe branch read.Never empty
repository.committexthashThe commit every row was read at.Never empty
repository.commit_attextISO date-timeThe feed’s time for that commit: GitHub’s clock for when the repository last changed.Never empty
sources.commits_feedtextURLThe repository’s commits feed.Never empty
sources.indextextURLThe repository’s index at a commit; {commit} stands for repository.commit.Never empty
sources.bip_filetextURLOne BIP’s file at a commit; {file} stands for a row’s file.Never empty
sources.processtextURLBIP 3, which sets the statuses.Never empty
sources.termstextnoneWhat the Gazette keeps from the repository, and under what terms.Never empty
method.statusestextnoneThe file’s own note on where each status comes from and what it does not say.Never empty
method.readingtextnoneThe file’s own note on how the repository is read.Never empty
method.changestextnoneThe file’s own note on when a status change is recorded, and how it is dated.Never empty
method.holdstextnoneThe file’s own note on when a row is held, and when a read writes nothing.Never empty
method.authorstextnoneThe file’s own note on what the author count counts.Never empty
method.allocatedtextnoneThe file’s own note on numbers the index lists without a document.Never empty
changes_sincetextISO dateThe day of the Gazette’s first read; changes holds every status change seen since.Never empty
allocatedlistnoneNumbers the index lists without a document, kept apart from the BIPs that have a status.none listed The index lists no number without a document.
allocated[].numberwhole numberidentifierA number the index lists without a document.Never empty
allocated[].titletextnoneThe title the index gives the number.Never empty
allocated[].listed_astextnoneThe index’s own words in its status column.Never empty
bipslistnoneOne item per BIP the repository’s index links, by number.Never empty
bips[].numberwhole numberidentifierThe BIP’s number.Never empty
bips[].filetextidentifierThe BIP’s own file in the repository.Never empty
bips[].titletextnoneThe Title header of the BIP’s preamble.not read Only on a held row the Gazette has never been able to read.
bips[].layertextset valueThe Layer header: one of BIP 123’s layers, as BIP 3 lists them.not disclosed The preamble has no Layer header; BIP 3 makes it optional.
bips[].typetextset valueThe Type header: Specification, Informational or Process.not read Only on a held row the Gazette has never been able to read.
bips[].statustextset valueThe Status header (Draft, Complete, Deployed or Closed): the repository’s label, not an endorsement and not an activation; on a held row, the status last recorded.not read Only on a held row the Gazette has never been able to read.
bips[].authorswhole numbercountLines in the Authors header; one line can name more than one person.not read Only on a held row the Gazette has never been able to read.
bips[].assignedtextISO dateThe Assigned header: the date the number was assigned.not read Only on a held row the Gazette has never been able to read.
bips[].replaceslistidentifierBIP numbers in the Replaces header.none listed The preamble has no Replaces header.
bips[].proposed_replacementlistidentifierBIP numbers in the Proposed-Replacement header.none listed The preamble has no Proposed-Replacement header.
bips[].heldgroupnoneSet when the last read could not read the row; its other fields are then what the Gazette last recorded.not applicable The row is not held: the last read took it.
bips[].held.sincetextISO dateThe day the hold began.Never empty
bips[].held.reasontextnoneWhy the row is held.Never empty
changeslistnoneEvery status change recorded, each dated by the day it was seen and never rewritten.none listed No status change is recorded since changes_since.
changes[].seen_ontextISO dateThe day the Gazette saw the change, not the day the repository made it.Never empty
changes[].numberwhole numberidentifierThe BIP’s number.Never empty
changes[].fromtextset valueThe status the Gazette had recorded before.not applicable The Gazette had recorded no status for the BIP before: it was newly listed, or its row had been held since it was first listed.
changes[].totextset valueThe status the Gazette read.Never empty
changes[].committexthashThe commit the Gazette read when it saw the change.Never empty

CSV columnssg-bip-status.csv

One row per BIP the repository’s index links, by number. The recorded status changes and the numbers allocated without a document are in the JSON.

CSV columns of BIP status
ColumnTypeUnitWhat it holdsWhen it is empty
numberJSON: bips[].numberwhole numberidentifierThe BIP’s number.Never empty
fileJSON: bips[].filetextidentifierThe BIP’s own file in the repository.Never empty
titleJSON: bips[].titletextnoneThe Title header of the BIP’s preamble.not read Only on a held row the Gazette has never been able to read.
layerJSON: bips[].layertextset valueThe Layer header; empty when the preamble names none.not disclosed The preamble has no Layer header; BIP 3 makes it optional.
typeJSON: bips[].typetextset valueThe Type header: Specification, Informational or Process.not read Only on a held row the Gazette has never been able to read.
statusJSON: bips[].statustextset valueThe Status header: Draft, Complete, Deployed or Closed. The repository’s label, not an endorsement and not an activation.not read Only on a held row the Gazette has never been able to read.
authorsJSON: bips[].authorswhole numbercountLines in the Authors header; one line can name more than one person.not read Only on a held row the Gazette has never been able to read.
assignedJSON: bips[].assignedtextISO dateThe Assigned header: the date the number was assigned.not read Only on a held row the Gazette has never been able to read.
replacesJSON: bips[].replacestextidentifierBIP numbers in the Replaces header, separated by spaces.none listed The preamble has no Replaces header.
proposed_replacementJSON: bips[].proposed_replacementtextidentifierBIP numbers in the Proposed-Replacement header, separated by spaces.none listed The preamble has no Proposed-Replacement header.
heldWorked out by the CSVtrue/falsenonetrue when the last read could not read the row; its fields are then what the Gazette last recorded.Never empty
held_sinceJSON: bips[].held.sincetextISO dateThe day the hold began; empty when the row is not held.not applicable The row is not held: the last read took it.
held_reasonJSON: bips[].held.reasontextnoneWhy the row is held; empty when it is not.not applicable The row is not held: the last read took it.
commitJSON: repository.committexthashThe repository commit the rows were read at.Never empty
urlWorked out by the CSVtextURLThe BIP’s file on GitHub at that commit.Never empty

Datasets ↑

Public Lightning network

Public channels, capacity and nodes a day, as one operator’s node received the gossip.

sg-lightning-network41 JSON fields8 CSV columns

JSON fieldssg-lightning-network.json

JSON fields of Public Lightning network
FieldTypeUnitWhat it holdsWhen it is empty
schema_versiontextidentifierThe name and version of the file’s layout; the site’s loader refuses any other.Never empty
datasettextidentifierThe dataset’s ID in the register.Never empty
methodology_versiontextidentifierThe version of the method the file was built with.Never empty
observed_attextISO date-timeThe source’s Date header on the last read that wrote rows: when the file was last read.Never empty
source.nametextnoneThe source’s name: the one host the counts are read from.Never empty
source.operatortextnoneWho runs the source.Never empty
source.softwaretextnoneThe software the source runs, and its licence.Never empty
source.software_urltextURLWhere that software’s code is published.Never empty
source.data_pagetextURLThe source’s own Lightning page.Never empty
source.history_urltextURLThe address of the source’s whole daily history.Never empty
source.window_urltextURLThe address of the source’s last month of days.Never empty
source.latest_urltextURLThe address of the source’s latest row, which carries its node total.Never empty
source.terms_urltextURLThe terms page the source serves.Never empty
source.termstextnoneWhat those terms grant and forbid, as the Gazette read them.Never empty
source.changestextnoneWhat the Gazette keeps of a response, and that it keeps nothing else.Never empty
method.populationtextnoneThe file’s own note on which channels and nodes are counted.Never empty
method.daytextnoneThe file’s own note on which day a row is, and when it is taken.Never empty
method.channelstextnoneThe file’s own note on the channel count.Never empty
method.capacitytextnoneThe file’s own note on capacity, and how it is printed.Never empty
method.nodestextnoneThe file’s own note on the node count and its check.Never empty
method.historytextnoneThe file’s own note on the rows taken from the source’s history.Never empty
method.holdstextnoneThe file’s own note on when a read is refused and when a day is held.Never empty
boundaries.private_channelstextnoneThe file’s own limit on private channels.Never empty
boundaries.capacitytextnoneThe file’s own limit on what capacity is.Never empty
boundaries.countstextnoneThe file’s own limit on whose counts these are.Never empty
gapslistnoneThe days since the first row that hold no row, oldest first, each with why.not applicable Every day since the first row is recorded. The key is then left out.
gaps[].daytextISO dateA UTC date the series holds no row for.Never empty
gaps[].reasontextnoneWhy: the source’s statistics hold no row for the day, or the count check stopped the day and it was not recorded.Never empty
gaps[].recorded_attextISO date-timeWhen the day was written down as not recorded.Never empty
baselineslistnoneDays the counts jumped past the count check and that are recorded as read, oldest first, each with what changed.not applicable No such day. The key is then left out.
baselines[].from_daytextISO dateA day recorded as read although its counts jumped past the count check; the check’s median runs from it.Never empty
baselines[].reasontextnoneWhat changed on the day.Never empty
baselines[].recorded_attextISO date-timeWhen the day was recorded.Never empty
rowslistnoneOne item per UTC day recorded, oldest first.Never empty
rows[].daytextISO dateThe UTC day the row counts.Never empty
rows[].channelswhole numbercountPublic channels in the source’s row for the day: channel_count.Never empty
rows[].nodeswhole numbercountPublic nodes: the sum of the source’s four node counts by address type.Never empty
rows[].capacity_satswhole numbersatsBitcoin locked in the public channels, summed from their funding amounts: total_capacity.Never empty
rows[].endpointtextset valueWhich of the source’s reads the row was taken from: statistics/all, the whole history, or statistics/1m, its last month.Never empty
rows[].served_attextISO date-timeThe source’s HTTP Date header on that read: its clock, not the Gazette’s.Never empty
rows[].sha256texthashsha256 of that response’s body as served.Never empty

CSV columnssg-lightning-network.csv

One row per UTC day recorded; 14 days not recorded are listed in the JSON’s gaps and in the notes.

CSV columns of Public Lightning network
ColumnTypeUnitWhat it holdsWhen it is empty
dayJSON: rows[].daytextISO dateThe UTC day the row counts.Never empty
channelsJSON: rows[].channelswhole numbercountPublic channels in the source’s row for the day.Never empty
nodesJSON: rows[].nodeswhole numbercountPublic nodes: the sum of the source’s four node counts by address type.Never empty
capacity_satsJSON: rows[].capacity_satswhole numbersatsBitcoin locked in those channels, in satoshis.Never empty
capacity_btcWorked out by the CSVdecimal textBTCThe same, in BTC, exact to the satoshi.Never empty
endpointJSON: rows[].endpointtextset valueWhich of the source’s reads the row was taken from: statistics/all or statistics/1m.Never empty
served_atJSON: rows[].served_attextISO date-timeThe source’s Date header on that read, UTC.Never empty
sha256JSON: rows[].sha256texthashsha256 of that response as served.Never empty

Datasets ↑

Difficulty

Every difficulty period since genesis, its difficulty exact from the block header.

sg-difficulty-ledger47 JSON fields17 CSV columns

JSON fieldssg-difficulty-ledger.json

JSON fields of Difficulty
FieldTypeUnitWhat it holdsWhen it is empty
schema_versiontextidentifierThe name and version of the file’s layout; the site’s loader refuses any other.Never empty
methodology_versiontextidentifierThe version of the method the file was built with.Never empty
datasetslistidentifierThe two datasets the period file is built for, sg-difficulty-ledger and sg-block-ledger; this download carries the first alone, as method.download says.Never empty
observed_attextISO date-timeWhen the chain tip was read: an operator’s HTTP Date header, its clock and not the Gazette’s.Never empty
through_heightwhole numberheightThe chain tip the file runs through.Never empty
ledger_from_heightwhole numberheightThe first block the reward ledger reads: 628,992, the start of the period that holds the 2020 halving.Never empty
ledger_through_heightwhole numberheightThe last block the reward ledger has read.not in this dataset The reward ledger is its own dataset, sg-block-ledger, and this file leaves it out: not zero, and not unread.
ledger_tip_hashtexthashHash of the last block the reward ledger has read.not in this dataset The reward ledger is its own dataset, sg-block-ledger, and this file leaves it out: not zero, and not unread.
sources.blockstextURLmempool.space’s blocks from a height; {height} stands for the height.Never empty
sources.headertextURLmempool.space’s 80-byte header of a block; {hash} stands for its hash.Never empty
sources.tiptextURLmempool.space’s chain tip height.Never empty
sources.second_operator_heighttextURLBlockstream’s Esplora: the block hash at a height.Never empty
sources.second_operator_txidstextURLBlockstream’s Esplora: a block’s full list of transaction IDs.Never empty
sources.second_operator_coinbasetextURLBlockstream’s Esplora: one transaction in hex, used for the coinbase.Never empty
sources.pool_rulestextURLThe public rules that assign pool labels.Never empty
sources.pool_rules_filetextURLThe rules file a period read from the node is labelled with: pools-v2.json at the commit the builder pins.not read The file was last written under method 1.0.0, which did not record it; a file written under 1.1.0 or later holds it.
sources.pool_matchingtextURLmempool’s own matching code, at the commit the Gazette’s matching was copied from.not read The file was last written under method 1.0.0, which did not record it; a file written under 1.1.0 or later holds it.
method.difficultytextnoneThe file’s own note on how difficulty is computed from nBits.Never empty
method.retarget_ruletextnoneThe file’s own note on recomputing each retarget by the consensus rule.Never empty
method.rewardstextnoneThe file’s own note on what the reward ledger reads, and from which block.Never empty
method.fees_caveattextnoneThe file’s own note on what fees rest on, and what they cannot see.Never empty
method.poolstextnoneThe file’s own note on where pool labels come from.Never empty
method.verificationtextnoneThe file’s own note on what is checked on each header and each claimed reward.Never empty
method.digesttextnoneThe file’s own note on how rows_sha256 is chained.Never empty
method.limitationtextnoneThe file’s own note on which operators the blocks were read from.Never empty
method.downloadtextnoneWhy this file leaves the reward ledger out, in the file’s own words.Never empty
periodslistnoneOne item per 2,016-block retarget period since the genesis block; the last may still be open.Never empty
periods[].epochwhole numberindexThe retarget period, counted from 0.Never empty
periods[].start_heightwhole numberheightHeight of the period’s first block, the retarget block.Never empty
periods[].end_heightwhole numberheightHeight of the last block read in the period.Never empty
periods[].blockswhole numberblocksBlocks in the period so far; 2,016 when it is complete.Never empty
periods[].completetrue/falsenonetrue when the period holds all 2,016 blocks.Never empty
periods[].first_block_timetextISO date-timeHeader time of the first block.Never empty
periods[].last_block_timetextISO date-timeHeader time of the last block read.Never empty
periods[].retarget_hashtexthashHash of the first block.Never empty
periods[].last_block_hashtexthashHash of the last block read.Never empty
periods[].bitstexthexnBits of the first block’s header, the compact form of the target: eight hex digits.Never empty
periods[].difficulty.fractiontextratioExact difficulty as a reduced fraction: 0xffff × 2^208 over the target.Never empty
periods[].difficulty.decimaldecimal textratioThe fraction cut to 8 decimals.cutNever empty
periods[].difficulty.core_floatdecimal textratioBitcoin Core’s double-precision difficulty, written out exactly.Never empty
periods[].ratio_to_previousdecimal textratioThe previous period’s target over this one, cut to 10 decimals.cutnot applicable The genesis period has no period before it.
periods[].subsidy_satswhole numbersatsSubsidy of the period’s blocks so far, from the halving schedule.Never empty
periods[].ledgergroupnoneThe period’s rewards, fees and pool labels.not in this dataset The reward ledger is its own dataset, sg-block-ledger, and this file leaves it out: not zero, and not unread.
periods[].verification.header_checktextset valueAlways retarget-window here, the check the difficulty pass gives every period: this file states the weaker check, never a stronger one.Never empty
periods[].verification.second_operator_hashtrue/falsenonetrue when the first block’s hash was matched on Blockstream’s Esplora.Never empty
periods[].verification.retarget_ruletrue/falsenonetrue when the nBits equals what the consensus rule requires from the period before.not applicable The genesis period has no period before it.
periods[].verification.coinbase_provedlistnoneThe block heights whose claimed reward was proved against the full transaction list, as ranges.not in this dataset The reward ledger is its own dataset, sg-block-ledger, and this file leaves it out: not zero, and not unread.

CSV columnssg-difficulty-ledger.csv

One row per 2,016-block retarget period since the genesis block; the latest period is still open.

CSV columns of Difficulty
ColumnTypeUnitWhat it holdsWhen it is empty
epochJSON: periods[].epochwhole numberindexThe retarget period, counted from 0.Never empty
start_heightJSON: periods[].start_heightwhole numberheightHeight of the period’s first block, the retarget block.Never empty
end_heightJSON: periods[].end_heightwhole numberheightHeight of the last block read in the period.Never empty
blocksJSON: periods[].blockswhole numberblocksBlocks in the period so far; 2,016 when complete.Never empty
completeJSON: periods[].completetrue/falsenonetrue when the period holds all 2,016 blocks.Never empty
first_block_timeJSON: periods[].first_block_timetextISO date-timeHeader time of the first block, UTC.Never empty
last_block_timeJSON: periods[].last_block_timetextISO date-timeHeader time of the last block read, UTC.Never empty
retarget_hashJSON: periods[].retarget_hashtexthashHash of the first block.Never empty
last_block_hashJSON: periods[].last_block_hashtexthashHash of the last block read.Never empty
bitsJSON: periods[].bitstexthexnBits of the first block’s header, eight hex digits.Never empty
difficulty_fractionJSON: periods[].difficulty.fractiontextratioExact difficulty as a reduced fraction: 0xffff × 2^208 over the target.Never empty
difficulty_decimalJSON: periods[].difficulty.decimaldecimal textratioThe fraction cut, never rounded, to 8 decimals.cutNever empty
difficulty_core_floatJSON: periods[].difficulty.core_floatdecimal textratioBitcoin Core’s double-precision difficulty, written out exactly.Never empty
ratio_to_previousJSON: periods[].ratio_to_previousdecimal textratioThe previous period’s target over this one, cut to 10 decimals; empty at genesis.cutnot applicable The genesis period has no period before it.
subsidy_satsJSON: periods[].subsidy_satswhole numbersatsSubsidy of the period’s blocks, from the halving schedule, in sats.Never empty
second_operator_hashJSON: periods[].verification.second_operator_hashtrue/falsenonetrue when the first block’s hash was matched on Blockstream’s Esplora.Never empty
retarget_ruleJSON: periods[].verification.retarget_ruletrue/falsenonetrue when the nBits equals what the consensus rule requires from the period before; empty at genesis.not applicable The genesis period has no period before it.

Datasets ↑

Public miners

Mined, sold and held per quarter, as the 11 listed miners on the roster filed it.

sg-public-miners131 JSON fields26 CSV columns

JSON fieldssg-public-miners.json

JSON fields of Public miners
FieldTypeUnitWhat it holdsWhen it is empty
schema_versiontextidentifierThe name and version of the file’s layout; the site’s loader refuses any other.Never empty
datasettextidentifierThe dataset’s ID in the register.Never empty
methodology_versiontextidentifierThe version of the method the file was built with.Never empty
observed_attextISO date-timeWhen the file last changed: the Gazette’s clock when a settled reading was filed, EDGAR’s when a listing check changed it.Never empty
source.publishertextnoneWho publishes the filings.Never empty
source.index_urltextURLEDGAR’s listings of each registrant’s filings.Never empty
source.documents_urltextURLWhere the filings’ documents sit on EDGAR.Never empty
source.termstextnoneThe terms the filings are read under.Never empty
source.terms_urltextURLThe SEC’s notice on reading EDGAR.Never empty
window.fromtextISO dateFirst day of the first calendar quarter read.Never empty
window.throughtextISO dateLast day of the last calendar quarter read.Never empty
window.opening_balance_datetextISO dateThe day before the window opens: the date of the opening balance.Never empty
roster_ruletextnoneThe rule that puts a company on the roster, and the day the roster was set.Never empty
entitieslistnoneOne item per company the file names, on the roster or beside it, in the roster’s order, which every list below follows.Never empty
entities[].keytextidentifierA stable key for the company.Never empty
entities[].cikwhole numberidentifierThe registrant’s CIK on EDGAR.Never empty
entities[].legal_nametextnoneThe name the company’s reports carry at the end of the window.Never empty
entities[].edgar_nametextnoneThe name EDGAR’s listing gives the registrant, to the letter.Never empty
entities[].tickertextidentifierThe company’s ticker.Never empty
entities[].former_nameslistnoneEvery earlier name EDGAR lists for the registration, newest first.none listed EDGAR lists no earlier name for a company on the roster; for a company beside it the listing was not read, and in_roster says which.
entities[].former_names[].nametextnoneThe earlier name, as EDGAR lists it.Never empty
entities[].former_names[].fromtextISO dateThe first day EDGAR dates the name by.Never empty
entities[].former_names[].untiltextISO dateThe last day EDGAR dates the name by.Never empty
entities[].former_names[].in_seriestrue/falsenonetrue when the company in these rows itself carried the name on a day its rows cover; false for an older name or another business’s.Never empty
entities[].fiscal_year_endtextidentifierThe day the company’s fiscal year ends, as MM-DD.not read The company is named beside the roster and not read: its listing on EDGAR was not read for it.
entities[].in_rostertrue/falsenonetrue for a company on the roster under the rule; false for one named beside it as not read yet.Never empty
entities[].basistextset valueThe basis of the company’s rows, as its own reports state them: consolidated, subsidiary, parent_excluding_subsidiary.not read The company is named beside the roster and not read: its listing on EDGAR was not read for it.
entities[].basis_notetextnoneWhat the company’s figures take in and leave out, in words.not read The company is named beside the roster and not read: its listing on EDGAR was not read for it.
entities[].statustextset valueread, or not_read for a company with no row: what it mined, sold and held is unknown here, not zero.Never empty
entities[].not_read_reasontextnoneWhy the company has no rows.not applicable The company is read.
entities[].enteredtextISO dateFirst day of the first calendar quarter the company has rows for, or will have.not read The company is named beside the roster and not read: its listing on EDGAR was not read for it.
entities[].closinggroupnoneThe day the company’s series ended, and why.not applicable The company’s series has not ended.
entities[].closing.ontextISO dateThe day the series ended.Never empty
entities[].closing.reasontextnoneWhy it ended: the company stopped mining, merged or stopped filing.Never empty
entities[].linkgroupnoneThe listed company this one is paired with: the parent that consolidates it, or its listed subsidiary.not applicable The company is not one of a listed parent and its listed subsidiary.
entities[].link.roletextset valueWhat this company is to the other: parent or subsidiary.Never empty
entities[].link.entitytextidentifierThe other company’s key.Never empty
entities[].link.notetextnoneHow the two reports relate, in words.Never empty
method.readingtextnoneThe file’s own note on who reads a figure, and how two readings are settled.Never empty
method.sourcestextnoneThe file’s own note on which reports are read and what every figure carries of its source.Never empty
method.periodstextnoneThe file’s own note on calendar quarters, the window, and a quantity stated only for a longer period.Never empty
method.quantitiestextnoneThe file’s own note on what counts as mined, sold, purchased and held, and what does not.Never empty
method.statestextnoneThe file’s own note on the five states of a figure, and which carry a number.Never empty
method.precedencetextnoneThe file’s own note on a later report that prints a different number, and amendments.Never empty
method.quotestextnoneThe file’s own note on how a quote is cut so that it carries no amount of money.Never empty
method.computedtextnoneThe file’s own note on what is worked out from the rows and stored nowhere.Never empty
method.watchingtextnoneThe file’s own note on the check that lists reports filed since the last one read.Never empty
method.limitationtextnoneThe file’s own note on what the file does not cover.Never empty
boundaries.quantities_onlytrue/falsenoneAlways true: the file holds quantities of bitcoin only.Never empty
boundaries.market_price_not_fetchedtrue/falsenoneAlways true: no market price was fetched for the file.Never empty
boundaries.nothing_inferred_from_holdingstrue/falsenoneAlways true: no sale or purchase is inferred from a change in holdings.Never empty
boundaries.nothing_computed_from_moneytrue/falsenoneAlways true: no quantity is computed from an amount of money or from a rate.Never empty
boundaries.nothing_carried_forwardtrue/falsenoneAlways true: a quarter the filings do not state is not filled from another.Never empty
boundaries.nothing_from_trackerstrue/falsenoneAlways true: no figure is taken from a tracker, a news site or a release outside EDGAR.Never empty
rowslistnoneOne item per read company per calendar quarter, by the roster and then the quarter; a quarter not on file has no item.not read No company’s reports have been filed here yet.
rows[].entitytextidentifierThe company’s key.Never empty
rows[].period_starttextISO dateFirst day of the calendar quarter.Never empty
rows[].period_endtextISO dateLast day of the calendar quarter.Never empty
rows[].fiscal_labeltextnoneThe quarter as the company’s reports name it in its fiscal year, in the Gazette’s words, with the period it is reported under.Never empty
rows[].figureslistnoneThe quarter’s figures: one each for mined, sold, purchased and held at the end, and one for every other quantity the filing gives in units.Never empty
rows[].figures[].fieldtextset valueWhich quantity the figure is: held_start, mined, sold, purchased, other_in, other_out, held_end, pledged_or_posted, lent, joint_venture_share.Never empty
rows[].figures[].labeltextnoneThe filing’s own name for the row or the movement, with any words of the Gazette’s own in square brackets: a whole label in brackets where the filing has no name for the number, or where the number is worked out from several of its rows.Never empty
rows[].figures[].statetextset valuestated, derived, not_stated_in_units, none_in_complete_rollforward, not_separable; only stated and derived carry a number.Never empty
rows[].figures[].value_btcdecimal textBTCThe quantity as the filing states it, or as derived from numbers it states.as statedapproximatenot disclosed The figure’s state carries no number: the filing gives it only as money or not at all, prints only a blend, or reconciles its balance in units with no such line; none of these is a reported nil.
rows[].figures[].approximatetrue/falsenonetrue when the filing says approximately, or the like, of this number.Never empty
rows[].figures[].basis_notetextnoneWhat the number contains or leaves out; for a pledged, posted or lent quantity, whether it sits inside the held figure or beside it.not applicable The reading records no note for the figure.
rows[].figures[].pool_fee_basistextset valueWhether a mined number is before or after pool fees, as the filing says of that number, and not_said where it is silent or its own words conflict, with what later reports point to kept to the basis note: after_pool_fees, before_pool_fees, not_said.not applicable The figure is not a mined figure that carries a number.
rows[].figures[].derivationtextnoneThe arithmetic of a derived figure, in words.not applicable The figure is not derived.
rows[].figures[].componentslistnoneThe arithmetic of a derived figure: each stated number with its sign, adding up to value_btc exactly.not applicable The figure is stated, not derived, or carries no number, so there is no arithmetic to list.
rows[].figures[].components[].signtextset valueplus or minus: whether the number is added or taken away.Never empty
rows[].figures[].components[].value_btcdecimal textBTCThe stated number, unsigned; 0 where its source prints a dash, a nil in words or no number.as statedNever empty
rows[].figures[].components[].sourcewhole numberindexWhich of the sources the number was read at, counted from 0.Never empty
rows[].figures[].sourceslistnoneEvery place the figure was read.none listed The figure is not stated in units, and no place in the filings read is cited for it.
rows[].figures[].sources[].formtextidentifierThe form of the filing the figure was read in, as EDGAR names it.Never empty
rows[].figures[].sources[].accessiontextidentifierThat filing’s EDGAR accession number.Never empty
rows[].figures[].sources[].filed_ontextISO dateThe day that filing was made.Never empty
rows[].figures[].sources[].document_urltextURLAddress of the document the number is in, inside the filing’s own folder on EDGAR.Never empty
rows[].figures[].sources[].locatortextnoneWhere in that document the number stands, in words a reader can follow.Never empty
rows[].figures[].sources[].covers_starttextISO dateFirst day of the period the printed number covers; the day itself for a balance.Never empty
rows[].figures[].sources[].covers_endtextISO dateLast day of the period the printed number covers.Never empty
rows[].figures[].sources[].value_as_printedtextnoneThe number as the filing prints it at this place, brackets and words included.not applicable The place prints no number for it: the figure carries none, or the place is a complete table without the row.
rows[].figures[].sources[].quotetextnoneThe filing’s own words at this place, a table row’s cells joined by a bar and cut to its label and the quantity, or to its column’s head and the quantity where the row has no label.not in this dataset The quote could not be given without an amount of money and was left out; quote_state says dropped, and the locator stands alone.
rows[].figures[].sources[].quote_statetextset valueWhat became of the quote on its way into the file: as_read, shortened, dropped.Never empty
rows[].figures[].later_valueslistnoneDifferent numbers later reports print for the same period; the first-reported value stands.none listed No later report read prints a different number for the period.
rows[].figures[].later_values[].value_btcdecimal textBTCThe number the later report prints.as statedNever empty
rows[].figures[].later_values[].accessiontextidentifierThe later filing’s EDGAR accession number.Never empty
rows[].figures[].later_values[].document_urltextURLAddress of the later document, inside its own filing’s folder on EDGAR.Never empty
rows[].figures[].later_values[].quotetextnoneThe later report’s own words, cut as every quote is.not in this dataset The quote could not be given without an amount of money and was left out; quote_state says dropped.
rows[].figures[].later_values[].quote_statetextset valueWhat became of that quote: as_read, shortened, dropped.Never empty
rows[].figures[].later_values[].whytextnoneWhy the later report prints another number, as far as it says.Never empty
spanslistnoneQuantities the filings state only for a period longer than a quarter, each kept whole and never divided among its quarters.none listed No filing read states a quantity for a longer period only.
spans[].entitytextidentifierThe company’s key.Never empty
spans[].covers_starttextISO dateFirst day of the period the quantity is stated for.Never empty
spans[].covers_endtextISO dateLast day of that period.Never empty
spans[].fieldtextset valueWhich movement it is: mined, sold, purchased, other_in, other_out or joint_venture_share; never a balance.Never empty
spans[].labeltextnoneThe filing’s own name for the movement; words in square brackets are the Gazette’s.Never empty
spans[].statetextset valuestated or derived: a span always carries a number.Never empty
spans[].value_btcdecimal textBTCThe quantity for the whole period.as statedapproximateNever empty
spans[].approximatetrue/falsenonetrue when the filing says approximately, or the like, of this number.Never empty
spans[].basis_notetextnoneWhat the number contains or leaves out.not applicable The reading records no note for the span.
spans[].derivationtextnoneThe arithmetic of a derived span, in words.not applicable The span is not derived.
spans[].componentslistnoneThe arithmetic of a derived span: each stated number with its sign, adding up to value_btc exactly.not applicable The span is stated, not derived, or carries no number, so there is no arithmetic to list.
spans[].components[].signtextset valueplus or minus: whether the number is added or taken away.Never empty
spans[].components[].value_btcdecimal textBTCThe stated number, unsigned; 0 where its source prints a dash, a nil in words or no number.as statedNever empty
spans[].components[].sourcewhole numberindexWhich of the sources the number was read at, counted from 0.Never empty
spans[].sourceslistnoneEvery place the span was read.Never empty
spans[].sources[].formtextidentifierThe form of the filing the span was read in, as EDGAR names it.Never empty
spans[].sources[].accessiontextidentifierThat filing’s EDGAR accession number.Never empty
spans[].sources[].filed_ontextISO dateThe day that filing was made.Never empty
spans[].sources[].document_urltextURLAddress of the document the number is in, inside the filing’s own folder on EDGAR.Never empty
spans[].sources[].locatortextnoneWhere in that document the number stands, in words a reader can follow.Never empty
spans[].sources[].covers_starttextISO dateFirst day of the period the printed number covers; the day itself for a balance.Never empty
spans[].sources[].covers_endtextISO dateLast day of the period the printed number covers.Never empty
spans[].sources[].value_as_printedtextnoneThe number as the filing prints it at this place, brackets and words included.not applicable The place prints no number for it: the figure carries none, or the place is a complete table without the row.
spans[].sources[].quotetextnoneThe filing’s own words at this place, a table row’s cells joined by a bar and cut to its label and the quantity, or to its column’s head and the quantity where the row has no label.not in this dataset The quote could not be given without an amount of money and was left out; quote_state says dropped, and the locator stands alone.
spans[].sources[].quote_statetextset valueWhat became of the quote on its way into the file: as_read, shortened, dropped.Never empty
filingslistnoneThe log of filings read: one item per document opened, whatever its form, oldest filing first within a company.not read No company’s reports have been filed here yet.
filings[].entitytextidentifierThe company’s key.Never empty
filings[].formtextidentifierThe form type as EDGAR names it.Never empty
filings[].accessiontextidentifierThe filing’s EDGAR accession number.Never empty
filings[].filed_ontextISO dateThe day the filing was made.Never empty
filings[].period_endtextISO dateThe period the document reports.Never empty
filings[].document_urltextURLAddress of the document, inside the filing’s own folder on EDGAR.Never empty
filings[].amendment_notetextnoneWhat was found of amendments to the report, or in this amendment.not read Nothing is recorded on amendments for the document.
unread_filingslistnoneAnnual and quarterly reports EDGAR lists as filed since the newest one read for a company; none is read, and no row reflects them.none listed No listing check has found a report filed since the newest one read.
unread_filings[].entitytextidentifierThe company’s key.Never empty
unread_filings[].formtextidentifierThe report’s form type.Never empty
unread_filings[].accessiontextidentifierThe report’s EDGAR accession number.Never empty
unread_filings[].filed_ontextISO dateThe day the report was filed.Never empty
unread_filings[].period_endtextISO dateThe period the report covers.not disclosed EDGAR’s listing gives the report no period.
unread_filings[].document_urltextURLAddress of the report’s main document.Never empty

CSV columnssg-public-miners.csv

One row per figure: a company, a calendar quarter and one quantity, with its state and the first place its number is printed. Quantities stated only for a longer period, the roster, the log of documents read, and every further place and quote are in the JSON.

CSV columns of Public miners
ColumnTypeUnitWhat it holdsWhen it is empty
entityJSON: rows[].entitytextidentifierThe company’s key in the file.Never empty
companyJSON: entities[].legal_nametextnoneThe company’s name at the end of the window.Never empty
cikJSON: entities[].cikwhole numberidentifierThe registrant’s CIK on EDGAR.Never empty
tickerJSON: entities[].tickertextidentifierIts ticker.Never empty
basisJSON: entities[].basistextset valueThe basis of the company’s rows, as its own reports state them: consolidated, subsidiary or parent_excluding_subsidiary.Never empty
period_startJSON: rows[].period_starttextISO dateFirst day of the calendar quarter.Never empty
period_endJSON: rows[].period_endtextISO dateLast day of the calendar quarter.Never empty
fiscal_labelJSON: rows[].fiscal_labeltextnoneThe quarter as the company’s reports name it in its fiscal year, in the Gazette’s words.Never empty
fieldJSON: rows[].figures[].fieldtextset valueWhich quantity the row is: held_start, mined, sold, purchased, other_in, other_out, held_end, pledged_or_posted, lent or joint_venture_share.Never empty
labelJSON: rows[].figures[].labeltextnoneThe filing’s own name for the row or the movement; words in square brackets are the Gazette’s.Never empty
stateJSON: rows[].figures[].statetextset valuestated, derived, not_stated_in_units, none_in_complete_rollforward or not_separable; only the first two carry a number.Never empty
value_btcJSON: rows[].figures[].value_btcdecimal textBTCThe quantity, an exact decimal in BTC; empty where the state carries no number, which is unknown, not zero. A reported nil is 0.as statedapproximatenot disclosed The figure’s state carries no number: the filing gives it only as money or not at all, prints only a blend, or reconciles its balance in units with no such line; none of these is a reported nil.
approximateJSON: rows[].figures[].approximatetrue/falsenonetrue when the filing says approximately, or the like, of this number.Never empty
pool_fee_basisJSON: rows[].figures[].pool_fee_basistextset valueFor a mined figure with a number, as the filing says of that number: after_pool_fees, before_pool_fees, or not_said where it is silent or says both.not applicable The figure is not a mined figure that carries a number.
derivationJSON: rows[].figures[].derivationtextnoneFor a derived figure, the arithmetic in words; its components are in the JSON.not applicable The figure is not derived.
basis_noteJSON: rows[].figures[].basis_notetextnoneWhat the number contains or leaves out, and for a pledged, posted or lent quantity whether it sits inside the held figure or beside it.not applicable The reading records no note for the figure.
sourcesWorked out by the CSVwhole numbercountHow many places the JSON holds for the figure.Never empty
receipt_formWorked out by the CSVtextidentifierThe form of the filing the number is printed in; for a derived figure, the first number of its arithmetic.not applicable The figure cites no place: it is not stated in units, and nothing in the filings read is cited for it.
receipt_accessionWorked out by the CSVtextidentifierThat filing’s EDGAR accession number.not applicable The figure cites no place: it is not stated in units, and nothing in the filings read is cited for it.
receipt_filed_onWorked out by the CSVtextISO dateThe day that filing was made.not applicable The figure cites no place: it is not stated in units, and nothing in the filings read is cited for it.
receipt_document_urlWorked out by the CSVtextURLAddress of the document the number is printed in, on sec.gov.not applicable The figure cites no place: it is not stated in units, and nothing in the filings read is cited for it.
receipt_locatorWorked out by the CSVtextnoneWhere in that document the number stands.not applicable The figure cites no place: it is not stated in units, and nothing in the filings read is cited for it.
receipt_covers_startWorked out by the CSVtextISO dateFirst day of the period the printed number covers; the day itself for a balance.not applicable The figure cites no place: it is not stated in units, and nothing in the filings read is cited for it.
receipt_covers_endWorked out by the CSVtextISO dateLast day of the period the printed number covers.not applicable The figure cites no place: it is not stated in units, and nothing in the filings read is cited for it.
longer_periodWorked out by the CSVtrue/falsenonetrue when the row has no number and the JSON’s spans hold this quantity for a longer period that takes in the quarter; the longer period’s number is in the JSON and is never divided.Never empty
later_valuesWorked out by the CSVwhole numbercountHow many different numbers later reports print for the same period; each is in the JSON, and the first-reported value stands.Never empty

Datasets ↑

Pool block share

mempool.space’s pool labels for three windows, read once a week and filed.

sg-pool-blocks25 JSON fields7 CSV columns

JSON fieldssg-pool-blocks.json

JSON fields of Pool block share
FieldTypeUnitWhat it holdsWhen it is empty
schema_versiontextidentifierThe name and version of the file’s layout; the site’s loader refuses any other.Never empty
methodology_versiontextidentifierThe version of the method the file was built with.Never empty
observed_attextISO date-timeWhen mempool.space served the three windows: the latest HTTP Date header among its responses, its clock and not the Gazette’s.Never empty
published_story_urltextURLThe Gazette Story Pools began with, which reported from an earlier reading of the sample, not from this one.Never empty
sources.one_weektextURLmempool.space’s pools endpoint for one week.Never empty
sources.one_monthtextURLmempool.space’s pools endpoint for one month.Never empty
sources.three_monthstextURLmempool.space’s pools endpoint for three months.Never empty
sources.methodologytextURLThe public rules that assign pool labels.Never empty
windowslistnoneOne item per window: one week, one month and three months.Never empty
windows[].keytextset valueThe window: 1w, 1m or 3m.Never empty
windows[].labeltextnoneThe window in words.Never empty
windows[].observed_blockswhole numberblocksBlocks in the window.Never empty
windows[].poolslistnoneThe window’s pool labels, in the source’s rank order.heuristicNever empty
windows[].pools[].labeltextnonemempool.space’s pool label, a labelling rule and not ownership; Unknown is its row for blocks its rules could not attribute.heuristicone sourceNever empty
windows[].pools[].blockswhole numberblocksBlocks carrying the label in the window.heuristicone sourceNever empty
method.calculationtextnoneThe file’s own note on how the shares are worked out and how the reading is dated.Never empty
method.attributiontextnoneThe file’s own note on how mempool.space assigns a label.Never empty
method.limitationtextnoneThe file’s own note on what a pool label does not reveal.Never empty
method.why_it_matterstextnoneThe file’s own note on why concentration under few labels matters.Never empty
boundaries.read_only_snapshottrue/falsenoneAlways true: the file is a saved reading, and nothing in it is live.Never empty
boundaries.pool_labels_are_not_ownershiptrue/falsenoneAlways true: a label says nothing of who owns the machines.Never empty
boundaries.hashrate_not_inferredtrue/falsenoneAlways true: the file holds no hashrate figure; the Pools page works out its interval from the one-week block counts when it prints.Never empty
boundaries.geography_not_inferredtrue/falsenoneAlways true: no location is worked out.Never empty
boundaries.collusion_not_inferredtrue/falsenoneAlways true: no coordination between operators is inferred.Never empty
boundaries.external_actiontrue/falsenoneAlways false: building the file acted on nothing outside the Gazette.Never empty

CSV columnssg-pool-blocks.csv

One row per pool label per window, in the source’s rank order. A label is a labelling rule, not ownership.

CSV columns of Pool block share
ColumnTypeUnitWhat it holdsWhen it is empty
observed_atJSON: observed_attextISO date-timeWhen mempool.space served the three windows, UTC.Never empty
window_keyJSON: windows[].keytextset value1w, 1m or 3m.Never empty
window_labelJSON: windows[].labeltextnoneThe window in words.Never empty
observed_blocksJSON: windows[].observed_blockswhole numberblocksBlocks in the window.Never empty
rankWorked out by the CSVwhole numberindexThe label’s place in the window by blocks, counted from 1.heuristicone sourceNever empty
labelJSON: windows[].pools[].labeltextnonemempool.space’s pool label; Unknown is its row for blocks its rules could not attribute.heuristicone sourceNever empty
blocksJSON: windows[].pools[].blockswhole numberblocksBlocks carrying the label in the window.heuristicone sourceNever empty

Datasets ↑

Company treasuries

Each company’s latest filing.

sg-treasury-ledger47 JSON fields25 CSV columns

JSON fieldssg-treasury-ledger.json

JSON fields of Company treasuries
FieldTypeUnitWhat it holdsWhen it is empty
boundaries.complete_market_ranking_publishedtrue/falsenoneAlways false: the file ranks a selected set, not every holder.Never empty
boundaries.external_actiontrue/falsenoneAlways false: building the file acted on nothing outside the Gazette.Never empty
boundaries.market_price_fetchedtrue/falsenoneAlways false: no market price was fetched for the file.Never empty
boundaries.read_onlytrue/falsenoneAlways true: the file is a saved reading, and nothing in it is live.Never empty
boundaries.runtime_state_exposedtrue/falsenoneAlways false: nothing of the Gazette’s internal state is in the file.Never empty
boundaries.selected_settrue/falsenoneAlways true: the companies are a selected set.Never empty
boundaries.verified_onlytrue/falsenoneAlways true: only holdings verified against a filing or disclosure are in the file.Never empty
calculation.orderingtextnoneThe file’s own note on how the companies are ordered.Never empty
calculation.totaltextnoneThe file’s own note on how the total is summed.Never empty
companieslistnoneOne item per company, each from one filing or disclosure, largest holding first.Never empty
companies[].as_of_datetextISO dateThe date the filing or disclosure states the holding for.Never empty
companies[].btc_amountdecimal textBTCBitcoin the filing or disclosure states the company held.as statedNever empty
companies[].capitalgroupnoneHow the filing says the bitcoin was funded.not read The Gazette has recorded no funding note for the company.
companies[].capital.basic_share_changetextnoneThe change in basic shares the filing reports.not disclosed The filing reports no figure the Gazette could take for it.
companies[].capital.funding_pathtextnoneHow the filing says the bitcoin was funded, with the filing’s own amounts in the currency it reports.Never empty
companies[].changegroupnoneThe change in the holding over one reported period.not read The Gazette has recorded no change for the company’s row. That is not a statement that the holding did not change.
companies[].change.btc_deltadecimal textBTCThe change over the period; negative for a reduction.as statedNever empty
companies[].change.period_endtextISO dateLast day of the change period.Never empty
companies[].change.period_starttextISO dateFirst day of the change period.Never empty
companies[].change.previous_btcdecimal textBTCThe holding at the start of the change period.as statedNever empty
companies[].confidencetextset valueThe Gazette’s confidence in the row: high, medium or low.Never empty
companies[].controlgroupnoneWhat the filing establishes about custody and control.not read The Gazette has recorded no custody note for the company.
companies[].control.notetextnoneWhat the filing establishes about custody and control, in words.Never empty
companies[].entity_typetextset valuepublic_company or private_company.Never empty
companies[].evidence_typetextset valueregulatory_filing, audited_report or company_disclosure.Never empty
companies[].exchangetextnoneWhere the ticker trades.not applicable The company has no listed shares.
companies[].jurisdictiontextnoneWhere the company is incorporated.Never empty
companies[].limitationtextnoneWhat the row does not establish; it may repeat a filing’s own amounts in the currency it reports.Never empty
companies[].nametextnoneThe company’s name.Never empty
companies[].source.locatortextnoneWhere in the filing or disclosure the holding is stated.Never empty
companies[].source.published_ontextISO dateThe day the filing or disclosure was published.Never empty
companies[].source.titletextnoneTitle of the filing or disclosure the row rests on.Never empty
companies[].source.urltextURLAddress of the filing or disclosure the row rests on.Never empty
companies[].tickertextidentifierThe company’s ticker.not applicable The company has no listed shares, so no ticker.
companies[].control.restricted_btcdecimal textBTCBitcoin the filing reports as restricted.as statednot disclosed The filing states no restricted bitcoin. That is not a reported zero.
companies[].control.loaned_btcdecimal textBTCBitcoin the filing reports as loaned.as statednot disclosed The filing states no loaned bitcoin. That is not a reported zero.
companies[].capital.btc_per_share_changetextnoneThe change in bitcoin per share, where the filing supports one.not disclosed The filing supports no figure for it.
companies[].capital.diluted_share_changetextnoneThe change in diluted shares the filing reports.not disclosed The filing reports no figure the Gazette could take for it.
input_sha256texthashsha256 of the reviewed evidence the file was exported from.Never empty
methodology_versiontextidentifierThe version of the method the file was built with.Never empty
schema_versiontextidentifierThe name and version of the file’s layout; the site’s loader refuses any other.Never empty
scope.descriptiontextnoneWhat the selected set is, in the file’s own words.Never empty
scope.excludeslistnoneWhat the set leaves out.none listed The file names nothing it leaves out.
summary.earliest_as_of_datetextISO dateThe oldest date any row’s holding is stated for.Never empty
summary.latest_as_of_datetextISO dateThe newest date any row’s holding is stated for.Never empty
summary.selected_total_btcdecimal textBTCThe rows’ holdings added up, each as of its own date: a total of the selected set, not of every company.as statedNever empty
summary.selected_verified_entitieswhole numbercountCompanies in the file.Never empty

CSV columnssg-treasury-ledger.csv

One row per company, each from one filing or disclosure, largest holding first.

CSV columns of Company treasuries
ColumnTypeUnitWhat it holdsWhen it is empty
nameJSON: companies[].nametextnoneThe company’s name.Never empty
entity_typeJSON: companies[].entity_typetextset valuepublic_company or private_company.Never empty
tickerJSON: companies[].tickertextidentifierIts ticker; empty when it has none.not applicable The company has no listed shares, so no ticker.
exchangeJSON: companies[].exchangetextnoneWhere the ticker trades; empty when it has none.not applicable The company has no listed shares.
jurisdictionJSON: companies[].jurisdictiontextnoneWhere the company is incorporated.Never empty
btc_amountJSON: companies[].btc_amountdecimal textBTCBitcoin the filing states, an exact decimal in BTC.as statedNever empty
as_of_dateJSON: companies[].as_of_datetextISO dateThe date the filing states the holding for.Never empty
evidence_typeJSON: companies[].evidence_typetextset valueregulatory_filing, audited_report or company_disclosure.Never empty
source_urlJSON: companies[].source.urltextURLAddress of the filing or disclosure the row rests on.Never empty
source_titleJSON: companies[].source.titletextnoneTitle of that filing or disclosure.Never empty
source_locatorJSON: companies[].source.locatortextnoneWhere in it the holding is stated.Never empty
source_published_onJSON: companies[].source.published_ontextISO dateThe day it was published.Never empty
confidenceJSON: companies[].confidencetextset valueThe Gazette’s confidence in the row: high, medium or low.Never empty
limitationJSON: companies[].limitationtextnoneWhat the row does not establish.Never empty
change_previous_btcJSON: companies[].change.previous_btcdecimal textBTCThe holding at the start of the change period; empty when no change is recorded.as statednot read The Gazette has recorded no change for the company’s row. That is not a statement that the holding did not change.
change_btc_deltaJSON: companies[].change.btc_deltadecimal textBTCThe change over the period in BTC; negative for a reduction.as statednot read The Gazette has recorded no change for the company’s row. That is not a statement that the holding did not change.
change_period_startJSON: companies[].change.period_starttextISO dateFirst day of the change period.not read The Gazette has recorded no change for the company’s row. That is not a statement that the holding did not change.
change_period_endJSON: companies[].change.period_endtextISO dateLast day of the change period.not read The Gazette has recorded no change for the company’s row. That is not a statement that the holding did not change.
capital_funding_pathJSON: companies[].capital.funding_pathtextnoneHow the filing says the bitcoin was funded, with the filing’s own amounts; empty when not recorded.not read The Gazette has recorded no funding note for the company.
capital_basic_share_changeJSON: companies[].capital.basic_share_changetextnoneThe change in basic shares the filing reports.not disclosed The filing reports no figure the Gazette could take for it. Also empty where the Gazette has recorded no funding note for the company; capital_funding_path is then empty too.
capital_diluted_share_changeJSON: companies[].capital.diluted_share_changetextnoneThe change in diluted shares the filing reports.not disclosed The filing reports no figure the Gazette could take for it. Also empty where the Gazette has recorded no funding note for the company; capital_funding_path is then empty too.
capital_btc_per_share_changeJSON: companies[].capital.btc_per_share_changetextnoneThe change in bitcoin per share, where the filing supports one.not disclosed The filing supports no figure for it. Also empty where the Gazette has recorded no funding note for the company; capital_funding_path is then empty too.
control_restricted_btcJSON: companies[].control.restricted_btcdecimal textBTCBitcoin the filing reports as restricted; empty when it states none.as statednot disclosed The filing states no restricted bitcoin; not a reported zero. Also empty where the Gazette has recorded no custody note for the company; control_note is then empty too.
control_loaned_btcJSON: companies[].control.loaned_btcdecimal textBTCBitcoin the filing reports as loaned; empty when it states none.as statednot disclosed The filing states no loaned bitcoin; not a reported zero. Also empty where the Gazette has recorded no custody note for the company; control_note is then empty too.
control_noteJSON: companies[].control.notetextnoneWhat the filing establishes about custody and control.not read The Gazette has recorded no custody note for the company.

Datasets ↑

Strategy’s filed totals

Every bitcoin total Strategy has stated in an 8-K, 10-Q or 10-K since 2020, one row each.

sg-strategy-filings61 JSON fields19 CSV columns

JSON fieldssg-strategy-filings.json

JSON fields of Strategy’s filed totals
FieldTypeUnitWhat it holdsWhen it is empty
schema_versiontextidentifierThe name and version of the file’s layout; the site’s loader refuses any other.Never empty
datasettextidentifierThe dataset’s ID in the register.Never empty
methodology_versiontextidentifierThe version of the method the file was built with.Never empty
observed_attextISO date-timeEDGAR’s clock when its listing of filings was read.Never empty
issuer.nametextnoneThe company’s name today.Never empty
issuer.formerlytextnoneThe company’s name when the first filings were made.Never empty
issuer.ciktextidentifierThe company’s CIK on EDGAR, ten digits.Never empty
coverage.filed_fromtextISO dateThe day filings are read from: the first of the month of the company’s first bitcoin purchase.Never empty
coverage.filed_throughtextISO dateThe day of the newest filing read.Never empty
coverage.formslistset valueThe SEC forms read; no other form is.Never empty
coverage.filings_readwhole numbercountFilings read.Never empty
coverage.filings_with_totalwhole numbercountFilings that state at least one dated total.Never empty
coverage.filings_without_totalwhole numbercountFilings that report a purchase or sale and state no total.Never empty
coverage.filings_unparsedwhole numbercountFilings that mention a holding with no dated total.Never empty
coverage.filings_without_holding_or_tradewhole numbercountFilings with no total and no purchase or sale to list.Never empty
source.publishertextnoneWho publishes the filings.Never empty
source.listingtextURLEDGAR’s listing of the company’s filings.Never empty
source.archivetextURLWhere the filings’ documents sit on EDGAR.Never empty
source.termstextnoneThe terms the filings are read under.Never empty
source.terms_urltextURLThe SEC’s notice on reading EDGAR.Never empty
wording_classes.holds_approximatelytextnoneWhat a sentence or a table cell must look like to be read as the wording class holds_approximately.Never empty
wording_classes.held_an_aggregate_oftextnoneWhat a sentence or a table cell must look like to be read as the wording class held_an_aggregate_of.Never empty
wording_classes.bitcoins_as_oftextnoneWhat a sentence or a table cell must look like to be read as the wording class bitcoins_as_of.Never empty
wording_classes.digital_assets_comprisedtextnoneWhat a sentence or a table cell must look like to be read as the wording class digital_assets_comprised.Never empty
wording_classes.bitcoin_holdings_as_oftextnoneWhat a sentence or a table cell must look like to be read as the wording class bitcoin_holdings_as_of.Never empty
wording_classes.aggregate_btc_holdings_tabletextnoneWhat a sentence or a table cell must look like to be read as the wording class aggregate_btc_holdings_table.Never empty
method.readingtextnoneThe file’s own note on which filings are read and what counts as a total.Never empty
method.rowstextnoneThe file’s own note on how filings become rows.Never empty
method.restatingtextnoneThe file’s own note on two filings that state one date.Never empty
method.continuitytextnoneThe file’s own note on checking each step against what its filing reports.Never empty
method.limitationtextnoneThe file’s own note on what a filed total is not.Never empty
rowslistnoneOne item per total a filing states, by the date it is stated for.Never empty
rows[].as_of_datetextISO dateThe date the filing states the total for.Never empty
rows[].btc_amountdecimal textBTCBitcoin the filing states the company held, as filed: a filed total, not a wallet balance.as statedapproximateNever empty
rows[].approximatetrue/falsenonetrue when the filing says approximately.Never empty
rows[].formtextset valueThe SEC form: 8-K, 10-Q, 10-K or an amendment of one.Never empty
rows[].accessiontextidentifierThe filing’s SEC accession number.Never empty
rows[].filed_ontextISO dateThe day the filing was made.Never empty
rows[].urltextURLThe document the statement is in: the report itself or an exhibit.Never empty
rows[].locatortextnoneWhere in that document the total is stated.Never empty
rows[].wording_classtextset valueWhich of the wordings in wording_classes the total was read from.Never empty
rows[].reported_changegroupnoneThe purchases and sales the filing reports for one period.not disclosed The filing reports no purchase and no sale of bitcoin.
rows[].restatestextidentifierAccession of the filing that first stated a total for this date.not applicable The row is the first statement for its date, the one that draws the step.
rows[].continuitygroupnoneThe step checked against the purchases and sales its filing reports.not applicable The row is not checked: it restates a date and draws no step, its filing reports no purchase or sale, or no filed total stands for its step to be measured from.
rows[].reported_change.period_starttextISO dateFirst day of the period the filing reports purchases or sales for.not disclosed The filing reports a purchase or sale without the period it was made in.
rows[].reported_change.period_endtextISO dateLast day of the period the filing reports purchases or sales for.not disclosed The filing reports a purchase or sale without the period it was made in.
rows[].reported_change.acquired_btcdecimal textBTCBitcoin the filing reports bought in the period; 0 when it reports none bought.as statednot disclosed The filing reports no purchases. Silence is not a reported zero.
rows[].reported_change.sold_btcdecimal textBTCBitcoin the filing reports sold in the period; 0 when it reports none sold.as statednot disclosed The filing reports no sales. Silence is not a reported zero.
rows[].continuity.statustextset valuematches or differs: the step against what the filing reports; a step that differs is flagged and left as filed.Never empty
rows[].continuity.baseline_accessiontextidentifierThe filing that stated the total the step is measured from.Never empty
rows[].continuity.baseline_as_of_datetextISO dateThe date of the filed total the step is measured from.Never empty
rows[].continuity.baseline_btcdecimal textBTCThe filed total the step is measured from.as statedNever empty
rows[].continuity.change_btcdecimal textBTCThis total less the baseline; negative for a decrease.as statedNever empty
rows[].continuity.reported_net_btcdecimal textBTCPurchases less sales as the filing reports them.as statedNever empty
filingslistnoneOne item per filing read, whether or not it gave a row.Never empty
filings[].accessiontextidentifierThe filing’s SEC accession number.Never empty
filings[].formtextset valueThe SEC form.Never empty
filings[].filed_ontextISO dateThe day the filing was made.Never empty
filings[].urltextURLThe filing’s main document.Never empty
filings[].outcometextset valueWhat the filing gave: aggregate, no_aggregate_stated, unparsed or no_holding_or_trade.Never empty
filings[].notetextnoneWhy a filing is listed without a row.not applicable The filing gave a row, or has no total and no purchase or sale to list.

CSV columnssg-strategy-filings.csv

One row per total a filing states. The log of every filing read, and the filings listed without a total, are in the JSON.

CSV columns of Strategy’s filed totals
ColumnTypeUnitWhat it holdsWhen it is empty
as_of_dateJSON: rows[].as_of_datetextISO dateThe date the filing states the total for.Never empty
btc_amountJSON: rows[].btc_amountdecimal textBTCBitcoin the filing states, an exact decimal in BTC, as filed.as statedapproximateNever empty
approximateJSON: rows[].approximatetrue/falsenonetrue when the filing says approximately.Never empty
formJSON: rows[].formtextset valueThe SEC form: 8-K, 10-Q, 10-K or an amendment.Never empty
accessionJSON: rows[].accessiontextidentifierThe filing’s SEC accession number.Never empty
filed_onJSON: rows[].filed_ontextISO dateThe day the filing was made.Never empty
urlJSON: rows[].urltextURLAddress of the document the statement is in, on sec.gov.Never empty
locatorJSON: rows[].locatortextnoneWhere in that document the total is stated.Never empty
wording_classJSON: rows[].wording_classtextset valueWhich of the wordings listed in the JSON the total was read from.Never empty
restatesJSON: rows[].restatestextidentifierAccession of the filing that first stated a total for this date; empty for the row that draws the step.not applicable The row is the first statement for its date, the one that draws the step.
reported_period_startJSON: rows[].reported_change.period_starttextISO dateFirst day of the period the filing reports purchases or sales for; empty when it gives none.not disclosed The filing reports a purchase or sale without the period it was made in. Also empty where the filing reports no purchase and no sale; reported_acquired_btc and reported_sold_btc are then empty too.
reported_period_endJSON: rows[].reported_change.period_endtextISO dateLast day of that period.not disclosed The filing reports a purchase or sale without the period it was made in. Also empty where the filing reports no purchase and no sale; reported_acquired_btc and reported_sold_btc are then empty too.
reported_acquired_btcJSON: rows[].reported_change.acquired_btcdecimal textBTCBitcoin the filing reports bought in the period; 0 when it reports none bought, empty when it reports no purchases.as statednot disclosed The filing reports a sale and no purchases. Silence is not a reported zero. Also empty where the filing reports no purchase and no sale; reported_sold_btc is then empty too.
reported_sold_btcJSON: rows[].reported_change.sold_btcdecimal textBTCBitcoin the filing reports sold in the period; 0 when it reports none sold, empty when it reports no sales.as statednot disclosed The filing reports a purchase and no sales. Silence is not a reported zero. Also empty where the filing reports no purchase and no sale; reported_acquired_btc is then empty too.
continuity_statusJSON: rows[].continuity.statustextset valuematches or differs: the step against what the filing reports; empty when it is not checked.not applicable The row is not checked: it restates a date and draws no step, its filing reports no purchase or sale, or no filed total stands for its step to be measured from.
continuity_baseline_as_of_dateJSON: rows[].continuity.baseline_as_of_datetextISO dateThe date of the filed total the step is measured from.not applicable The row is not checked: it restates a date and draws no step, its filing reports no purchase or sale, or no filed total stands for its step to be measured from.
continuity_baseline_accessionJSON: rows[].continuity.baseline_accessiontextidentifierThe filing that stated that total.not applicable The row is not checked: it restates a date and draws no step, its filing reports no purchase or sale, or no filed total stands for its step to be measured from.
continuity_change_btcJSON: rows[].continuity.change_btcdecimal textBTCThis total less the baseline, in BTC; negative for a decrease.as statednot applicable The row is not checked: it restates a date and draws no step, its filing reports no purchase or sale, or no filed total stands for its step to be measured from.
continuity_reported_net_btcJSON: rows[].continuity.reported_net_btcdecimal textBTCPurchases less sales as the filing reports them, in BTC.as statednot applicable The row is not checked: it restates a date and draws no step, its filing reports no purchase or sale, or no filed total stands for its step to be measured from.

Datasets ↑

Claims floor

Each holder’s latest disclosure, summed against issued supply at a pinned block.

sg-claims-floor43 JSON fields11 CSV columns

JSON fieldssg-claims-floor.json

JSON fields of Claims floor
FieldTypeUnitWhat it holdsWhen it is empty
as_of.block_heightwhole numberheightThe block issued supply is pinned at; it pins the supply only, and each holding keeps its own date.Never empty
as_of.height_source.titletextnoneWhere the block’s height was read.Never empty
as_of.height_source.urltextURLThe pinned block at that source.Never empty
as_of.observed_ontextISO dateThe day the block was read.Never empty
boundaries.clustering_heuristics_usedtrue/falsenoneAlways false: no coin is attributed to a holder by address clustering.Never empty
boundaries.external_actiontrue/falsenoneAlways false: building the file acted on nothing outside the Gazette.Never empty
boundaries.floor_not_estimatetrue/falsenoneAlways true: the figure is a floor on disclosed positions, never an estimate.Never empty
boundaries.market_price_fetchedtrue/falsenoneAlways false: no market price was fetched for the file.Never empty
boundaries.read_onlytrue/falsenoneAlways true: the file is a saved reading, and nothing in it is live.Never empty
boundaries.runtime_state_exposedtrue/falsenoneAlways false: nothing of the Gazette’s internal state is in the file.Never empty
categorieslistnoneOne item per kind of holder: spot funds, public-company treasuries and governments.Never empty
categories[].entitieslistnoneThe holders counted in the category, each from its own latest disclosure.not read The category is not yet compiled: its holdings are unknown, not zero.
categories[].entities[].as_of_datetextISO dateThe date the disclosure states the holding for.Never empty
categories[].entities[].btc_amountdecimal textBTCBitcoin the disclosure states; a spot ETF row drops the trailing zeros its filing prints and gives the filing’s places in its locator.as statedNever empty
categories[].entities[].entity_keytextidentifierA stable key for the holder.Never empty
categories[].entities[].entity_nametextnoneThe holder’s name.Never empty
categories[].entities[].evidence.kindtextset valueregulatory_filing, audited_report, company_disclosure or official_disclosure.Never empty
categories[].entities[].evidence.titletextnoneTitle of the record the row rests on.Never empty
categories[].entities[].evidence.urltextURLAddress of the record the row rests on.Never empty
categories[].entities[].evidence.locatortextnoneWhere in the record the holding is stated; for a spot ETF row, also how its filing tags and prints the quantity.Never empty
categories[].exit_dependencytextnoneWhat a holder of the claim depends on to get out.Never empty
categories[].keytextset valuespot_etf, public_company_treasury or government.Never empty
categories[].keys_held_bytextnoneWho holds the keys.Never empty
categories[].labeltextnoneThe category in words.Never empty
categories[].limitationtextnoneWhat the category’s figure does not establish.Never empty
categories[].statustextset valuecompiled, or not_yet_compiled for a category with no rows yet.Never empty
categories[].what_the_holder_ownstextnoneWhat the holder of the claim owns.Never empty
categories[].why_it_matterstextnoneWhy the category matters, where the Gazette has written it.not read The Gazette has written no such note for the category.
method.complement_warningtextnoneThe file’s own note on what the remainder is and is not.Never empty
method.floor_ruletextnoneThe file’s own note on what may be counted.Never empty
method.percentage_ruletextnoneThe file’s own note on how the percentages are computed and cut.Never empty
method.supply_ruletextnoneThe file’s own note on how issued supply is computed.Never empty
method.why_a_floortextnoneThe file’s own note on why the figure is a floor.Never empty
methodology_versiontextidentifierThe version of the method the file was built with.Never empty
schema_versiontextidentifierThe name and version of the file’s layout; the site’s loader refuses any other.Never empty
scope.descriptiontextnoneWhat the dataset counts, in the file’s own words.Never empty
scope.excludeslistnoneWhat it leaves out.none listed The file names nothing it leaves out.
summary.issued_btcdecimal textBTCBitcoin issued through the pinned block, computed from the subsidy schedule and fetched from no one.Never empty
summary.intermediated_floor_btcdecimal textBTCThe counted holders’ latest disclosures added up, each as of its own date.lower boundas statedNever empty
summary.intermediated_floor_percentdecimal textpercentThe floor as a percent of issued supply, cut to four places.lower boundcutNever empty
summary.unclassified_btcdecimal textBTCIssued supply less the floor: the bitcoin the counted disclosures do not account for, which is not evidence of self-custody.Never empty
summary.unclassified_percentdecimal textpercent100 less the floor’s percent, so the two always sum to 100.Never empty
input_sha256texthashsha256 of the saved file’s contents, as compact JSON without this key.not read The file was written without recording the digest.

CSV columnssg-claims-floor.csv

One row per holder’s latest disclosure. The pinned block, issued supply and the floor are in the JSON.

CSV columns of Claims floor
ColumnTypeUnitWhat it holdsWhen it is empty
category_keyJSON: categories[].keytextset valuespot_etf, public_company_treasury or government.Never empty
category_labelJSON: categories[].labeltextnoneThe category in words.Never empty
category_statusJSON: categories[].statustextset valuecompiled, or not_yet_compiled for a category with no rows yet.Never empty
entity_keyJSON: categories[].entities[].entity_keytextidentifierA stable key for the holder; empty on the one row of a category not yet compiled.not read The category is not yet compiled: its holdings are unknown, not zero. It keeps one row that names the category and no holder.
entity_nameJSON: categories[].entities[].entity_nametextnoneThe holder’s name.not read The category is not yet compiled: its holdings are unknown, not zero. It keeps one row that names the category and no holder.
btc_amountJSON: categories[].entities[].btc_amountdecimal textBTCBitcoin the disclosure states, an exact decimal in BTC.as statednot read The category is not yet compiled: its holdings are unknown, not zero. It keeps one row that names the category and no holder.
as_of_dateJSON: categories[].entities[].as_of_datetextISO dateThe date the disclosure states the holding for.not read The category is not yet compiled: its holdings are unknown, not zero. It keeps one row that names the category and no holder.
evidence_kindJSON: categories[].entities[].evidence.kindtextset valueregulatory_filing, audited_report, company_disclosure or official_disclosure.not read The category is not yet compiled: its holdings are unknown, not zero. It keeps one row that names the category and no holder.
evidence_titleJSON: categories[].entities[].evidence.titletextnoneTitle of the record the row rests on.not read The category is not yet compiled: its holdings are unknown, not zero. It keeps one row that names the category and no holder.
evidence_urlJSON: categories[].entities[].evidence.urltextURLAddress of that record.not read The category is not yet compiled: its holdings are unknown, not zero. It keeps one row that names the category and no holder.
evidence_locatorJSON: categories[].entities[].evidence.locatortextnoneWhere in it the holding is stated.not read The category is not yet compiled: its holdings are unknown, not zero. It keeps one row that names the category and no holder.

Datasets ↑

Spot ETF trusts

Bitcoin at each quarter end in 14 of the 16 trusts on the list, from their 10-Q and 10-K.

sg-etf-trusts69 JSON fields11 CSV columns

JSON fieldssg-etf-trusts.json

JSON fields of Spot ETF trusts
FieldTypeUnitWhat it holdsWhen it is empty
schema_versiontextidentifierThe name and version of the file’s layout; the site’s loader refuses any other.Never empty
datasettextidentifierThe dataset’s ID in the register.Never empty
methodology_versiontextidentifierThe version of the method the file was built with.Never empty
observed_attextISO date-timeEDGAR’s clock when it was read.Never empty
source.publishertextnoneWho publishes the filings.Never empty
source.index_urltextURLEDGAR’s filing indexes.Never empty
source.documents_urltextURLWhere the filings’ documents sit on EDGAR.Never empty
source.termstextnoneThe terms the filings are read under.Never empty
source.terms_urltextURLThe SEC’s notice on reading EDGAR.Never empty
list_ruletextnoneThe rule that puts a trust on the list, and the day the list was compiled.Never empty
orderslistnoneThe Commission orders the list rests on.Never empty
orders[].releasetextidentifierThe order’s release number.Never empty
orders[].datedtextISO dateThe day the order was made.Never empty
orders[].titletextnoneThe order’s title.Never empty
orders[].urltextURLThe order on sec.gov.Never empty
orders[].coverstextnoneWhich products the order covers.Never empty
trustslistnoneOne item per trust on the list, read or not.Never empty
trusts[].keytextidentifierA stable key for the trust.Never empty
trusts[].nametextnoneThe trust’s name today.Never empty
trusts[].tickertextidentifierThe trust’s ticker.Never empty
trusts[].cikwhole numberidentifierThe registrant’s CIK on EDGAR.Never empty
trusts[].exchangetextnoneThe exchange the trust’s shares are listed on.Never empty
trusts[].approved_astextnoneThe name the order or the certification approved the trust under.Never empty
trusts[].basis.ordertextidentifierThe release that approved the trust by name, or the one that set the generic listing standards a later listing rests on.Never empty
trusts[].basis.named_in_ordertrue/falsenonetrue when that order names the trust.Never empty
trusts[].basis.certification.accessiontextidentifierThe EDGAR accession number of the exchange’s certification, Form CERT; period ends are read from its date on.Never empty
trusts[].basis.certification.filed_ontextISO dateThe day the exchange’s certification was filed.Never empty
trusts[].basis.certification.urltextURLAddress of the document the Gazette read in the exchange’s certification.Never empty
trusts[].statustextset valueread, or not_read for a trust whose filings the rule cannot read; a trust not read has no rows and is in no total: unknown, not zero.Never empty
trusts[].not_read_reasontextnoneWhy the rule cannot read the trust’s filings.not applicable The trust is read.
trusts[].removalgroupnoneThe exchange’s filing to remove the trust from listing.not applicable The Gazette found no filing on EDGAR to remove the trust from listing.
trusts[].notetextnoneWhat else a reader should know of the trust.not applicable Nothing further is noted for the trust.
trusts[].removal.formtextidentifierThe form of the removal filing.Never empty
trusts[].removal.accessiontextidentifierThe EDGAR accession number of the removal filing.Never empty
trusts[].removal.filed_ontextISO dateThe day the removal filing was filed.Never empty
trusts[].removal.urltextURLAddress of the document the Gazette read in the removal filing.Never empty
not_in_listlistnoneProducts a reader might expect on the list, each with the filing that keeps it out.none listed No such product is recorded.
not_in_list[].nametextnoneThe product’s name.Never empty
not_in_list[].tickertextidentifierThe product’s ticker.not applicable The product’s shares are not established as listed, so there is no ticker to give.
not_in_list[].cikwhole numberidentifierThe registrant’s CIK on EDGAR.Never empty
not_in_list[].reasontextnoneWhy the product is not on the list.Never empty
not_in_list[].evidencegroupnoneThe filing that keeps the product off the list.not read The Gazette has recorded no single filing for the product; reason says why it is left out.
not_in_list[].evidence.formtextidentifierThe form of the filing that keeps the product off the list.Never empty
not_in_list[].evidence.accessiontextidentifierThe EDGAR accession number of the filing that keeps the product off the list.Never empty
not_in_list[].evidence.filed_ontextISO dateThe day the filing that keeps the product off the list was filed.Never empty
not_in_list[].evidence.urltextURLAddress of the document the Gazette read in the filing that keeps the product off the list.Never empty
rowslistnoneOne item per filed quantity: a trust, a quarter end and the report that states it; a quarter a trust has not reported has no item.Never empty
rows[].trusttextnoneThe trust’s name as the list gives it.Never empty
rows[].tickertextidentifierThe trust’s ticker.Never empty
rows[].cikwhole numberidentifierThe registrant’s CIK on EDGAR.Never empty
rows[].period_endtextISO dateThe quarter end the quantity is stated for.Never empty
rows[].btc_amountdecimal textBTCBitcoin held, with every digit the report prints and no more: a filed quarter-end quantity, not today’s holding.as statedNever empty
rows[].formtextset value10-Q, 10-K, 10-Q/A or 10-K/A.Never empty
rows[].accessiontextidentifierThe report’s EDGAR accession number.Never empty
rows[].filed_ontextISO dateThe day the report was filed.Never empty
rows[].document_urltextURLThe report’s primary document.Never empty
rows[].locatortextnoneWhere in the report the quantity is stated, and how it is dated.Never empty
rows[].restatestextidentifierAccession of the row this one restates.not applicable The figure is as first filed.
method.readingtextnoneThe file’s own note on which reports are read and which cell is taken.Never empty
method.datingtextnoneThe file’s own note on how a quantity is dated.Never empty
method.restatementstextnoneThe file’s own note on a quantity filed twice for one period.Never empty
method.absencetextnoneThe file’s own note on a quarter with no report, and a trust not read.Never empty
method.totaltextnoneThe file’s own note on how a total is added, and why it is a lower bound.Never empty
method.limitationtextnoneThe file’s own note on what a filed quarter-end quantity is not.Never empty
boundaries.quantities_onlytrue/falsenoneAlways true: the file holds quantities of bitcoin only.Never empty
boundaries.market_price_not_fetchedtrue/falsenoneAlways true: no market price was fetched for the file.Never empty
boundaries.values_not_readtrue/falsenoneAlways true: no net asset value or fair value is read.Never empty
boundaries.nothing_carried_forwardtrue/falsenoneAlways true: a quarter not yet reported has no row.Never empty
boundaries.external_actiontrue/falsenoneAlways false: building the file acted on nothing outside the Gazette.Never empty

CSV columnssg-etf-trusts.csv

One row per filed quantity: a trust, a quarter end and the report that states it. The list of trusts, with those not read, is in the JSON.

CSV columns of Spot ETF trusts
ColumnTypeUnitWhat it holdsWhen it is empty
trustJSON: rows[].trusttextnoneThe trust’s name as the list gives it.Never empty
tickerJSON: rows[].tickertextidentifierIts ticker.Never empty
cikJSON: rows[].cikwhole numberidentifierThe registrant’s CIK on EDGAR.Never empty
period_endJSON: rows[].period_endtextISO dateThe quarter end the quantity is stated for.Never empty
btc_amountJSON: rows[].btc_amountdecimal textBTCBitcoin held, exactly as the report prints it, an exact decimal in BTC.as statedNever empty
formJSON: rows[].formtextset value10-Q, 10-K, 10-Q/A or 10-K/A.Never empty
accessionJSON: rows[].accessiontextidentifierThe report’s EDGAR accession number.Never empty
filed_onJSON: rows[].filed_ontextISO dateThe day the report was filed.Never empty
document_urlJSON: rows[].document_urltextURLAddress of the report’s primary document.Never empty
locatorJSON: rows[].locatortextnoneWhere in it the quantity is stated, and how it is dated.Never empty
restatesJSON: rows[].restatestextidentifierThe accession of the row this one restates; empty for a figure as first filed.not applicable The figure is as first filed.

Datasets ↑

El Salvador’s disclosed wallet

The 20 addresses El Salvador discloses, re-summed on a second operator’s index.

sg-onbtc-wallet50 JSON fields5 CSV columns

JSON fieldssg-onbtc-wallet.json

JSON fields of El Salvador’s disclosed wallet
FieldTypeUnitWhat it holdsWhen it is empty
schema_versiontextidentifierThe name and version of the file’s layout; the site’s loader refuses any other.Never empty
datasettextidentifierThe dataset’s ID in the register.Never empty
methodology_versiontextidentifierThe version of the method the file was built with.Never empty
observed_attextISO date-timeWhen the balances were read: Blockstream’s Esplora’s HTTP Date header, its clock and not the Gazette’s.Never empty
observation.block_heightwhole numberheightThe block the reading is pinned at: Esplora’s chain tip, which held there while every address was read.Never empty
observation.block_hashtexthashHash of the block the reading is pinned at.Never empty
observation.block_timetextISO date-timeHeader time of the block the reading is pinned at.Never empty
disclosure.urltextURLThe endpoint where El Salvador’s National Bitcoin Office lists its addresses.Never empty
disclosure.served_attextISO date-timeWhen the endpoint answered.Never empty
disclosure.last_synctextISO date-timeWhen the endpoint says it last synced.Never empty
disclosure.address_countwhole numbercountAddresses the endpoint listed.Never empty
disclosure.address_set_sha256texthashsha256 of the address list, so a change in the set is seen.Never empty
disclosure.disclosed_confirmed_satswhole numbersatsThe confirmed total the endpoint’s own figures give; a reading is kept only when it equals total.confirmed_sats to the satoshi.Never empty
total.confirmed_satswhole numbersatsThe confirmed balance of the disclosed addresses, re-summed on Blockstream’s Esplora; coins outside those addresses are not in it.Never empty
total.unconfirmed_satswhole numbersatsNet amount in transactions not yet in a block, as Blockstream’s Esplora saw them, kept apart from the total.Never empty
addresseslistnoneOne item per disclosed address.Never empty
addresses[].addresstextidentifierThe address.Never empty
addresses[].confirmed_satswhole numbersatsThe address’s confirmed balance, funded less spent on Esplora; a reading is kept only when the endpoint’s own sums give the same.Never empty
addresses[].funded_satswhole numbersatsEverything confirmed transactions have paid into the address.one sourceNever empty
addresses[].spent_satswhole numbersatsEverything confirmed transactions have spent from the address.one sourceNever empty
addresses[].tx_countwhole numbercountConfirmed transactions that touched the address.one sourceNever empty
addresses[].unconfirmed_satswhole numbersatsThe address’s net amount in transactions not yet in a block, as Blockstream’s Esplora saw them.Never empty
series.unittextset valueThe unit of the series’ amounts: always sats.Never empty
series.columnslistidentifierThe names of the five places in each row of series.rows, in order.Never empty
series.first_credit_heightwhole numberheightThe block of the first credit to any address in the current set, where the series starts.one sourceNever empty
series.rowslistnoneOne row per block that moved the balance, oldest first, each a list of five numbers.Never empty
series.rows[][0]whole numberheightblock_height: a block in which confirmed transactions moved bitcoin into or out of the disclosed addresses.one sourceNever empty
series.rows[][1]whole numberUnix secondsblock_time: the block’s header time.one sourceNever empty
series.rows[][2]whole numbersatsdelta_sats: the net change in the block; negative for a spend.one sourceNever empty
series.rows[][3]whole numbersatscumulative_sats: the confirmed balance after the block; the last row’s equals total.confirmed_sats, which the endpoint’s own figures match.one sourceNever empty
series.rows[][4]whole numbercounttx_count: transactions in the block that touched the addresses.one sourceNever empty
sources.disclosure.urltextURLThe disclosure endpoint.Never empty
sources.disclosure.publishertextnoneWho publishes the address list.Never empty
sources.disclosure.operatortextnoneWho operates the disclosure endpoint.Never empty
sources.disclosure.termstextnoneThe terms the disclosure endpoint is read under, as the Gazette reads them.Never empty
sources.disclosure.terms_urltextURLAddress of the terms the disclosure endpoint is read under.Never empty
sources.disclosure.independent_of_mempool_spacetrue/falsenoneAlways false: the endpoint is run by the company that runs mempool.space.Never empty
sources.resum.urltextURLThe second operator’s API, where every address is re-summed.Never empty
sources.resum.operatortextnoneWho operates the second operator’s API.Never empty
sources.resum.termstextnoneThe terms the second operator’s API is read under, as the Gazette reads them.Never empty
sources.resum.independent_of_mempool_spacetrue/falsenoneAlways true: Blockstream is a different operator.Never empty
method.calculationtextnoneThe file’s own note on how the balance is read and re-summed.Never empty
method.independencetextnoneThe file’s own note on why the re-sum uses a second operator.Never empty
method.seriestextnoneThe file’s own note on what one step of the series is.Never empty
method.limitationtextnoneThe file’s own note on what the reading does not cover.Never empty
boundaries.read_only_snapshottrue/falsenoneAlways true: the file is a saved reading, and nothing in it is live.Never empty
boundaries.confirmed_onlytrue/falsenoneAlways true: the total counts confirmed transactions only.Never empty
boundaries.coins_outside_disclosed_addressestextset valueAlways not_in_this_reading: coins El Salvador may hold outside the disclosed addresses are not in this dataset, and are unknown, not zero.Never empty
boundaries.market_price_not_fetchedtrue/falsenoneAlways true: no market price was fetched for the file.Never empty
boundaries.external_actiontrue/falsenoneAlways false: building the file acted on nothing outside the Gazette.Never empty

CSV columnssg-onbtc-wallet.csv

One row per block that moved the balance. The disclosed addresses and their balances are in the JSON.

CSV columns of El Salvador’s disclosed wallet
ColumnTypeUnitWhat it holdsWhen it is empty
block_heightJSON: series.rows[][0]whole numberheightA block in which confirmed transactions moved bitcoin into or out of the disclosed addresses.one sourceNever empty
block_timeJSON: series.rows[][1]whole numberUnix secondsThe block’s header time, in Unix seconds.one sourceNever empty
delta_satsJSON: series.rows[][2]whole numbersatsNet change in the block, in sats; negative for a spend.one sourceNever empty
cumulative_satsJSON: series.rows[][3]whole numbersatsThe confirmed balance after the block, in sats; the last row’s is the confirmed total the JSON gives.one sourceNever empty
tx_countJSON: series.rows[][4]whole numbercountTransactions in the block that touched the addresses.one sourceNever empty

Datasets ↑

Datasets with no file