Data dictionary: the site table

Every column of GET /api/v1/sites, in table order. CSV readers key by position: columns 1 to 36 are the original table, 37 to 49 the production columns, 50 to 88 the capacity product and material columns, 89 to 115 the ownership columns (the publisher and holding level at 112 to 114, after owners_from, and the hash of the document read at 115). Column 116 lists linked facility IDs, 117 identifies the site, and 118 identifies the operation whose output includes the figure. Column 119 carries dated mining leases and licences. Column 120 gives additional capacity figures with their sources. A column is never renamed or moved; a new one is appended. Values are as their source states them: nothing is summed, inferred or invented, a grade never changes a figure, a material never makes a row rankable, and a stake is printed as its document prints it. The API guide shows the calls.

Encodings

  • A null value prints as an empty cell: the source does not state it. No column carries a default.
  • A closed-vocabulary list (ids, classes, codes, numbers, dates) joins its items with "; ", an item a source does not state left empty in its position: two unstated items read "; ", which is not an empty cell.
  • A free-text list (product words, URLs, documents, sections, quotes) is a JSON array in the cell when it holds two or more values (["p. 4",null]), so a "; " inside one item never splits it; a list of one value is that value, bare.
  • The table's V3.2d lists (stages_at_site, owners, hs_lines) join their items with "; ".
  • In the JSON every material list column is an array (one item per claim, aligned by position across the grade columns and across the spec columns) or null, never an empty array; a prod_* column is a scalar for one product and an array for two or more, and an own_* column a scalar for one holder and an array for two or more.
  • A mat_hs_lines item reads "<hs6> HS<edition> <relation>" ("760110 HS2022 equals"), then "<scheme>:<national_code>" for a national line, "grade_blind" where the line's umbrella row says the line does not split the product's grades, and "from <parent id>" where the line belongs to the form family mat_id sits under rather than to mat_id itself.

Columns

#columntyperead fromCSV cellnull means
1row_idstringfacility_capacity.row_idscalarnever null
2namestringfacility_capacity.namescalarnever null
3countrystringfacility_capacity.countryscalarthe census row states none
4country_iso3stringfacility_capacity.country_iso3scalarthe census row states none
5stagestringfacility_capacity.stagescalarnever null
6stages_at_sitestring[]facility_capacity.stage of every census row of the sitelist ("; ")never null
7operatorstringfacility_capacity.operatorscalarthe census row states none
8ultimate_parentstringfacility_capacity.ultimate_parentscalarthe census row states none
9ownersobject[] (owner, stake_percent, approximate, qualifier)STRATA's curated ownership split for the operationlist ("; ")never null; an empty list when no curated operation names the site, or the site has typed owner rows (owners_from site_ownership), which replace the curated owners
10owners_as_statedstringthe curated row's ultimate_ownerscalarno curated row matched, or the site has typed owner rows (owners_from site_ownership), which replace the curated owners
11owners_sourcestringthe curated row's source labelscalarno curated row matched, or the site has typed owner rows (owners_from site_ownership), which replace the curated owners
12owners_matchstringhow the curated row's name matched the sitescalarno curated row matched, or the site has typed owner rows (owners_from site_ownership), which replace the curated owners
13statusstringfacility_capacity.statusscalarthe census row states none
14status_linestringthe dated status line (curated status row, else the figure's statement). A row dated by an MSHA register entry names the day the status took effect and the register edition observed, each labelled, when the linked facility record holds bothscalarnever null
15status_line_basisstringwhat dates the status linescalarnever null
16status_datestringthe date the status line rests on. For a status dated by the MSHA register's current status date, this is when the status took effect.scalarthe status is undated
17status_source_urlstringthe page the status line rests onscalarno page dates it
18commissioning_yearintegeryear of a cited commissioning event reviewed as the opening of the aluminium plant and stage, through the requested as_of datescalarno reviewed opening matches the site, stage and sole linked facility, or the reviews disagree
19closure_yearintegernot in the capacity census yetscalarnull on every row until the dated status rows fold in
20capacity_as_publishedstringfacility_capacity.cap_displayscalarthe census row states none
21cap_valuenumberfacility_capacity.cap_valuescalarno figure, or the census marks the figure not disclosed
22cap_unitstringfacility_capacity.cap_unit_canonicalscalarthe census row states none
23cap_basisstringfacility_capacity.cap_basisscalarthe census row states none
24cap_yearintegerfacility_capacity.cap_yearscalarthe figure states no year
25cap_as_ofstringfacility_capacity.cap_as_ofscalarthe figure's document is undated
26cap_disclosurestringfacility_capacity.cap_disclosurescalarthe census row states none
27cap_source_urlstringfacility_capacity.cap_source_urlscalarno page is cited
28cap_quotestringfacility_capacity.cap_quotescalarno dated quote was read
29cap_document_titlestringfacility_capacity.cap_document_titlescalarnot a filing
30cap_pageintegerfacility_capacity.cap_pagescalarnot a filing page
31cap_read_onstringfacility_capacity.cap_read_onscalarno read date is recorded
32hs_linesobject[] (code, label)the tariff lines the stage's product trades under (STRATA's wording)list ("; ")never null; an empty list for a stage with no lines
33verifiedbooleanfacility_capacity.verified: the site's stage and product were read on the operator's own website; not a check of the capacity figure (rank_eligible is)scalarthe census row states none
34official_websitestringfacility_capacity.official_websitescalarthe census row states none
35rank_eligiblebooleanfacility_capacity.rank_eligible: the figure is one operating site's, quoted with its read date from the page that prints it, on a basis and product the stage ranks; filter on it for source-checked capacity (rank_exclusion says why a row does not rank)scalarthe census row states none
36rank_exclusionstringfacility_capacity.rank_exclusionscalarthe row may rank
37prod_productstring or listsite_production.productfree list (JSON array)STRATA holds no 100% production figure for the site and stage
38prod_value_ktnumber or listsite_production.value (kt)closed list ("; ")STRATA holds no 100% production figure for the site and stage
39prod_yearinteger or listsite_production.yearclosed list ("; ")STRATA holds no 100% production figure for the site and stage
40prod_period_kindstring or listsite_production.period_kindclosed list ("; ")STRATA holds no 100% production figure for the site and stage
41prod_period_endstring or listsite_production.period_endclosed list ("; ")STRATA holds no 100% production figure for the site and stage
42prod_basisstring or listsite_production.basisclosed list ("; ")STRATA holds no 100% production figure for the site and stage
43prod_share_basisstring or listsite_production.share_basisclosed list ("; ")STRATA holds no 100% production figure for the site and stage
44prod_source_urlstring or listsite_production.citation_urlfree list (JSON array)STRATA holds no 100% production figure for the site and stage
45prod_documentstring or listsite_production.documentfree list (JSON array)STRATA holds no 100% production figure for the site and stage
46prod_section_or_pagestring or listsite_production.section_or_pagefree list (JSON array)STRATA holds no 100% production figure for the site and stage
47prod_quotestring or listsite_production.quotefree list (JSON array)STRATA holds no 100% production figure for the site and stage
48prod_read_onstring or listsite_production.read_onclosed list ("; ")STRATA holds no 100% production figure for the site and stage
49prod_linestring or listthe production figure as one sentencefree list (JSON array)STRATA holds no 100% production figure for the site and stage
50cap_productstringfacility_capacity.cap_productscalarthe census row states none
51cap_measurestringfacility_capacity.cap_measurescalarthe row states no measure, or the census marks the figure not disclosed
52cap_contained_t_yrnumberfacility_capacity.cap_contained_t_yrscalarthe row states no contained tonnage, or the census marks the figure not disclosed
53mat_idstringfacility_capacity.material.material_form_idscalarthe row carries no material object, or its words resolve to no one id (unresolved, or parts across commodities)
54mat_labelstringmaterial_form.label of mat_id (the registry)scalarthe row carries no material object, the edition publishes no registry, or the registry holds no row for mat_id
55mat_as_publishedstringfacility_capacity.material.material_as_publishedscalarthe row carries no material object
56mat_translationstringfacility_capacity.material.material_translationscalarthe row carries no material object, or the published words are English
57mat_resolutionstringfacility_capacity.material.material_resolutionscalarthe row carries no material object
58mat_partsstring[]facility_capacity.material.materials_namedclosed list ("; ")the row carries no material object, or the resolution is neither parts nor unresolved
59mat_form_evidencestringfacility_capacity.material.form.evidencescalarthe row carries no material object
60mat_form_source_urlstringfacility_capacity.material.form: cap_source_url when source_is_figure, else citation.citation_urlscalarthe row carries no material object, or the source cites no page
61mat_form_quotestringfacility_capacity.material.form: cap_quote, only for evidence quoted when source_is_figure, else citation.quotescalarthe row carries no material object, or no quote prints the form's words
62mat_form_read_onstringfacility_capacity.material.form: cap_read_on when source_is_figure, else citation.read_onscalarthe row carries no material object, or no read date is recorded
63mat_form_tierstringfacility_capacity.material.form.tierscalarthe row carries no material object
64mat_grade_classstring[]facility_capacity.material.grades[].valueclosed list ("; ")the source states no grade (grade not stated), or no material
65mat_grade_textstring[]facility_capacity.material.grades[].as_publishedfree list (JSON array)the source states no grade, or no material
66mat_grade_evidencestring[]facility_capacity.material.grades[].evidenceclosed list ("; ")the source states no grade, or no material
67mat_grade_source_urlstring[]facility_capacity.material.grades[]: cap_source_url when source_is_figure, else citation.citation_urlfree list (JSON array)the source states no grade, or no material; an item null: that grade's source cites no page
68mat_grade_quotestring[]facility_capacity.material.grades[]: cap_quote, only for evidence spec_quoted or label_quoted when source_is_figure, else citation.quotefree list (JSON array)the source states no grade, or no material; an item null: no quote prints that grade's words
69mat_grade_read_onstring[]facility_capacity.material.grades[]: cap_read_on when source_is_figure, else citation.read_onclosed list ("; ")the source states no grade, or no material
70mat_grade_as_ofstring[]facility_capacity.material.grades[]: cap_as_of when source_is_figure, else citation.as_ofclosed list ("; ")the source states no grade, or no material; an item null: that grade's document is undated
71mat_grade_tierstring[]facility_capacity.material.grades[].tierclosed list ("; ")the source states no grade, or no material
72mat_specstring[]facility_capacity.material.specs[].value (a material_spec id)closed list ("; ")the source prints no assay or standard, or no material
73mat_spec_textstring[]facility_capacity.material.specs[].as_publishedfree list (JSON array)the source prints no assay or standard, or no material
74mat_spec_source_urlstring[]facility_capacity.material.specs[]: cap_source_url when source_is_figure, else citation.citation_urlfree list (JSON array)the source prints no assay or standard, or no material
75mat_spec_read_onstring[]facility_capacity.material.specs[]: cap_read_on when source_is_figure, else citation.read_onclosed list ("; ")the source prints no assay or standard, or no material
76mat_spec_tierstring[]facility_capacity.material.specs[].tierclosed list ("; ")the source prints no assay or standard, or no material
77mat_purity_minnumber[]material_spec.headline.lo of each mat_spec, where its relation is >= or >closed list ("; ")no spec, or no registry; an item null: the spec's comparator is not a minimum (= or ~), or the registry holds no such spec
78mat_purity_speciesstring[]material_spec.headline.species of each mat_spec, with "/" and headline.of for a ratioclosed list ("; ")no spec, or no registry; an item null: the registry holds no such spec
79mat_originstringfacility_capacity.material.origin.valuescalarthe row carries no material object, or the source states no origin
80mat_origin_evidencestringfacility_capacity.material.origin.evidencescalarthe row carries no material object, or the source states no origin
81mat_routestringfacility_capacity.material.route.valuescalarthe row carries no material object, or the source states no route
82mat_route_evidencestringfacility_capacity.material.route.evidencescalarthe row carries no material object, or the source states no route
83mat_registry_versionstringfacility_capacity.material.registry_versionscalarthe row carries no material object
84mat_hs_linesstring[]material_hs_map rows of mat_id, or of the nearest id up its parent chain that has any (a graded form carries its family's lines), as tokensclosed list ("; ")the row carries no material object, the edition publishes no registry, or no id on mat_id's parent chain has a map row
85mat_origin_tierstringfacility_capacity.material.origin.tierscalarthe row carries no material object, or the source states no origin
86mat_origin_source_urlstringfacility_capacity.material.origin: cap_source_url when source_is_figure, else citation.citation_urlscalarthe row carries no material object, the source states no origin, or it cites no page
87mat_route_tierstringfacility_capacity.material.route.tierscalarthe row carries no material object, or the source states no route
88mat_route_source_urlstringfacility_capacity.material.route: cap_source_url when source_is_figure, else citation.citation_urlscalarthe row carries no material object, the source states no route, or it cites no page
89own_ownerstring or string[]site_ownership.owner (as printed) of each holder in the current split, then each read printing no ownersfree list (JSON array)the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of; the item is a not_published read, which names no owner
90own_owner_kindstring or string[]site_ownership.owner_kind (company, state, person, public_float, other; other for the printed remainder, never a company) of each holder in the current split, then each read printing no ownersclosed list ("; ")the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of; a not_published read
91own_owner_countrystring or string[]site_ownership.owner_country of each holder in the current split, then each read printing no ownersclosed list ("; ")the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of; the document prints no seat
92own_owner_identifierstring or string[]site_ownership.owner_identifier (scheme:key) of each holder in the current split, then each read printing no ownersclosed list ("; ")the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of; the document prints no identifier
93own_owner_entity_idstring or string[]site_ownership.owner_entity_id of each holder in the current split, then each read printing no ownersclosed list ("; ")the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of; no crosswalk link yet (every row until C's crosswalk), a holder that is not a company or state (a person, a public float, the printed remainder: never linked), or a BrightQuery legal-entity id, which is never printed
94own_held_viastring or string[]site_ownership.held_via of each holder in the current split, then each read printing no ownersfree list (JSON array)the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of; the document names no intermediate holder
95own_stake_percentnumber or number[]site_ownership.stake_percent of each holder in the current split, then each read printing no ownersclosed list ("; ")the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of; the document prints a band, no figure, or the item is a not_published read
96own_stake_minnumber or number[]site_ownership.stake_min of each holder in the current split, then each read printing no ownersclosed list ("; ")the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of; the document prints no band
97own_stake_maxnumber or number[]site_ownership.stake_max of each holder in the current split, then each read printing no ownersclosed list ("; ")the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of; the document prints no band
98own_stake_qualifierstring or string[]site_ownership.stake_qualifier (approximate, at_least, at_most) of each holder in the current split, then each read printing no ownersclosed list ("; ")the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of; the figure is printed without one
99own_basisstring or string[]site_ownership.stake_basis of each holder in the current split, then each read printing no ownersclosed list ("; ")the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of
100own_as_ofstring or string[]site_ownership.as_of (as printed: YYYY, YYYY-MM or YYYY-MM-DD) of each holder in the current split, then each read printing no ownersclosed list ("; ")the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of
101own_valid_tostring or string[]site_ownership.valid_to (as printed) of each holder in the current split, then each read printing no ownersclosed list ("; ")the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of; the document records no end
102own_source_urlstring or string[]site_ownership.citation_url of each holder in the current split, then each read printing no ownersfree list (JSON array)the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of
103own_documentstring or string[]site_ownership.document of each holder in the current split, then each read printing no ownersfree list (JSON array)the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of
104own_document_kindstring or string[]site_ownership.document_kind of each holder in the current split, then each read printing no ownersclosed list ("; ")the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of
105own_publisher_rolestring or string[]site_ownership.publisher_role (owner, issuer, operator; a legacy parent is served as owner) of each holder in the current split, then each read printing no ownersclosed list ("; ")the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of
106own_section_or_pagestring or string[]site_ownership.section_or_page of each holder in the current split, then each read printing no ownersfree list (JSON array)the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of
107own_quotestring or string[]site_ownership.quote of each holder in the current split, then each read printing no ownersfree list (JSON array)the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of
108own_quote_translationstring or string[]site_ownership.quote_translation of each holder in the current split, then each read printing no ownersfree list (JSON array)the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of; the quote is in English, or no translation is recorded
109own_read_onstring or string[]site_ownership.read_on of each holder in the current split, then each read printing no ownersclosed list ("; ")the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of
110own_linestring or string[]each item of own_* as one sentence: owner, stake as printed with its basis ("wholly owned" for a sole owner, never a figure), as_of, "until <valid_to>" ("until the <date> transfer" for a printed transfer date, the holding ending the day before), "holding level not stated by the document" where it is not, "not restated in <document>, <as_of>" where a later report of the same source neither restates the holder nor prints the full owner set, the cited host, document kind, whose document and its publisher; "ownership not published by the operator (read <read_on>)" for a not_published readfree list (JSON array)the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of
111owners_fromstringwhere the row's owners come from: "site_ownership" (the site has a typed row, in force or not; the typed rows replace the curated owners, so owners to owners_match are empty), "ledger_text" (only the curated owners matched)scalarthe site has no typed row and no curated owners matched
112own_publisherstring or string[]site_ownership.publisher (the document's publisher as its cover or legal notice names it, verbatim) of each holder in the current split, then each read printing no ownersfree list (JSON array)the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of; the edition's site_ownership table predates CONTRACT-v1.1 (no such column)
113own_publisher_identifierstring or string[]site_ownership.publisher_identifier (scheme:key, in the register's form) of each holder in the current split, then each read printing no ownersclosed list ("; ")the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of; the document prints no identifier for its publisher, a BrightQuery legal-entity id (never printed), or the edition's site_ownership table predates CONTRACT-v1.1 (no such column)
114own_holding_levelstring or string[]site_ownership.holding_level (direct, not_stated; a printed indirect interest is never a site row) of each holder in the current split, then each read printing no ownersclosed list ("; ")the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of; the edition's site_ownership table predates CONTRACT-v1.1 (no such column)
115own_document_sha256string or string[]site_ownership.document_sha256 (the sha256 of the bytes the lane read, as its download manifest records it) of each holder in the current split, then each read printing no ownersclosed list ("; ")the edition publishes no site_ownership table, or no typed row of the site and stage is in force at the call's as_of; the edition's site_ownership table predates the document hash (no such column)
116facility_idsstring[]facility_material_role.facility_ids of the row (the tier facility ids the census row is linked to, sorted; the same link GET /api/v1/site_roles serves); for a row whose material roles give no facility id (it has no role, as a site whose capacity is not disclosed has none, or its roles name no facility), the facility ids its typed owner rows name on the same site and stage, the link lookup_facility's census_status uses; identity only, no figure or material; lookup_facility takes each idclosed list ("; ")the census row is linked to no tier facility yet by a material role or a typed owner row, or the edition publishes neither table or one that predates the link (no such column)
117site_keystringthe site's key as JSON text: ["al_site_id", the census row's al_site_id] where it has one, else ["site_id", its site_id]; lookup_entity's owned_sites carry the same key, so a held site joins its row here by site_key and stagescalarthe census row is keyed only by its name (a site_id beginning "name:"), which is no site identity
118prod_included_in_site_idstring or string[]site_production.included_in_site_id of each selected output observation. This census ID identifies the operation whose reported output already includes the figure. Its site_key is the JSON text ["al_site_id", ID]. Compare like products and periods before summing.closed list ("; ")STRATA has no recorded enclosing operation for this observation, or the edition predates the field. Additivity is unknown.
119lease_disclosuresobject[]site_lease. Dated mining leases and licences for this census site and stage, with the holder and original document.JSON array of recordsThe edition has no published lease disclosure for this site and stage.
120cap_other_figuresobject[]facility_capacity.cap_other_figures. Additional capacity figures for the same product and stage. Each gives its measurement basis, unit, date, page and quotation. Rankings and totals use the main capacity fields only.JSON array of recordsNo additional capacity figure is published for this row at the requested date.