STRATA · Docs
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
| # | column | type | read from | CSV cell | null means |
|---|---|---|---|---|---|
| 1 | row_id | string | facility_capacity.row_id | scalar | never null |
| 2 | name | string | facility_capacity.name | scalar | never null |
| 3 | country | string | facility_capacity.country | scalar | the census row states none |
| 4 | country_iso3 | string | facility_capacity.country_iso3 | scalar | the census row states none |
| 5 | stage | string | facility_capacity.stage | scalar | never null |
| 6 | stages_at_site | string[] | facility_capacity.stage of every census row of the site | list ("; ") | never null |
| 7 | operator | string | facility_capacity.operator | scalar | the census row states none |
| 8 | ultimate_parent | string | facility_capacity.ultimate_parent | scalar | the census row states none |
| 9 | owners | object[] (owner, stake_percent, approximate, qualifier) | STRATA's curated ownership split for the operation | list ("; ") | 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 |
| 10 | owners_as_stated | string | the curated row's ultimate_owner | scalar | no curated row matched, or the site has typed owner rows (owners_from site_ownership), which replace the curated owners |
| 11 | owners_source | string | the curated row's source label | scalar | no curated row matched, or the site has typed owner rows (owners_from site_ownership), which replace the curated owners |
| 12 | owners_match | string | how the curated row's name matched the site | scalar | no curated row matched, or the site has typed owner rows (owners_from site_ownership), which replace the curated owners |
| 13 | status | string | facility_capacity.status | scalar | the census row states none |
| 14 | status_line | string | the 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 both | scalar | never null |
| 15 | status_line_basis | string | what dates the status line | scalar | never null |
| 16 | status_date | string | the 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. | scalar | the status is undated |
| 17 | status_source_url | string | the page the status line rests on | scalar | no page dates it |
| 18 | commissioning_year | integer | year of a cited commissioning event reviewed as the opening of the aluminium plant and stage, through the requested as_of date | scalar | no reviewed opening matches the site, stage and sole linked facility, or the reviews disagree |
| 19 | closure_year | integer | not in the capacity census yet | scalar | null on every row until the dated status rows fold in |
| 20 | capacity_as_published | string | facility_capacity.cap_display | scalar | the census row states none |
| 21 | cap_value | number | facility_capacity.cap_value | scalar | no figure, or the census marks the figure not disclosed |
| 22 | cap_unit | string | facility_capacity.cap_unit_canonical | scalar | the census row states none |
| 23 | cap_basis | string | facility_capacity.cap_basis | scalar | the census row states none |
| 24 | cap_year | integer | facility_capacity.cap_year | scalar | the figure states no year |
| 25 | cap_as_of | string | facility_capacity.cap_as_of | scalar | the figure's document is undated |
| 26 | cap_disclosure | string | facility_capacity.cap_disclosure | scalar | the census row states none |
| 27 | cap_source_url | string | facility_capacity.cap_source_url | scalar | no page is cited |
| 28 | cap_quote | string | facility_capacity.cap_quote | scalar | no dated quote was read |
| 29 | cap_document_title | string | facility_capacity.cap_document_title | scalar | not a filing |
| 30 | cap_page | integer | facility_capacity.cap_page | scalar | not a filing page |
| 31 | cap_read_on | string | facility_capacity.cap_read_on | scalar | no read date is recorded |
| 32 | hs_lines | object[] (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 |
| 33 | verified | boolean | facility_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) | scalar | the census row states none |
| 34 | official_website | string | facility_capacity.official_website | scalar | the census row states none |
| 35 | rank_eligible | boolean | facility_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) | scalar | the census row states none |
| 36 | rank_exclusion | string | facility_capacity.rank_exclusion | scalar | the row may rank |
| 37 | prod_product | string or list | site_production.product | free list (JSON array) | STRATA holds no 100% production figure for the site and stage |
| 38 | prod_value_kt | number or list | site_production.value (kt) | closed list ("; ") | STRATA holds no 100% production figure for the site and stage |
| 39 | prod_year | integer or list | site_production.year | closed list ("; ") | STRATA holds no 100% production figure for the site and stage |
| 40 | prod_period_kind | string or list | site_production.period_kind | closed list ("; ") | STRATA holds no 100% production figure for the site and stage |
| 41 | prod_period_end | string or list | site_production.period_end | closed list ("; ") | STRATA holds no 100% production figure for the site and stage |
| 42 | prod_basis | string or list | site_production.basis | closed list ("; ") | STRATA holds no 100% production figure for the site and stage |
| 43 | prod_share_basis | string or list | site_production.share_basis | closed list ("; ") | STRATA holds no 100% production figure for the site and stage |
| 44 | prod_source_url | string or list | site_production.citation_url | free list (JSON array) | STRATA holds no 100% production figure for the site and stage |
| 45 | prod_document | string or list | site_production.document | free list (JSON array) | STRATA holds no 100% production figure for the site and stage |
| 46 | prod_section_or_page | string or list | site_production.section_or_page | free list (JSON array) | STRATA holds no 100% production figure for the site and stage |
| 47 | prod_quote | string or list | site_production.quote | free list (JSON array) | STRATA holds no 100% production figure for the site and stage |
| 48 | prod_read_on | string or list | site_production.read_on | closed list ("; ") | STRATA holds no 100% production figure for the site and stage |
| 49 | prod_line | string or list | the production figure as one sentence | free list (JSON array) | STRATA holds no 100% production figure for the site and stage |
| 50 | cap_product | string | facility_capacity.cap_product | scalar | the census row states none |
| 51 | cap_measure | string | facility_capacity.cap_measure | scalar | the row states no measure, or the census marks the figure not disclosed |
| 52 | cap_contained_t_yr | number | facility_capacity.cap_contained_t_yr | scalar | the row states no contained tonnage, or the census marks the figure not disclosed |
| 53 | mat_id | string | facility_capacity.material.material_form_id | scalar | the row carries no material object, or its words resolve to no one id (unresolved, or parts across commodities) |
| 54 | mat_label | string | material_form.label of mat_id (the registry) | scalar | the row carries no material object, the edition publishes no registry, or the registry holds no row for mat_id |
| 55 | mat_as_published | string | facility_capacity.material.material_as_published | scalar | the row carries no material object |
| 56 | mat_translation | string | facility_capacity.material.material_translation | scalar | the row carries no material object, or the published words are English |
| 57 | mat_resolution | string | facility_capacity.material.material_resolution | scalar | the row carries no material object |
| 58 | mat_parts | string[] | facility_capacity.material.materials_named | closed list ("; ") | the row carries no material object, or the resolution is neither parts nor unresolved |
| 59 | mat_form_evidence | string | facility_capacity.material.form.evidence | scalar | the row carries no material object |
| 60 | mat_form_source_url | string | facility_capacity.material.form: cap_source_url when source_is_figure, else citation.citation_url | scalar | the row carries no material object, or the source cites no page |
| 61 | mat_form_quote | string | facility_capacity.material.form: cap_quote, only for evidence quoted when source_is_figure, else citation.quote | scalar | the row carries no material object, or no quote prints the form's words |
| 62 | mat_form_read_on | string | facility_capacity.material.form: cap_read_on when source_is_figure, else citation.read_on | scalar | the row carries no material object, or no read date is recorded |
| 63 | mat_form_tier | string | facility_capacity.material.form.tier | scalar | the row carries no material object |
| 64 | mat_grade_class | string[] | facility_capacity.material.grades[].value | closed list ("; ") | the source states no grade (grade not stated), or no material |
| 65 | mat_grade_text | string[] | facility_capacity.material.grades[].as_published | free list (JSON array) | the source states no grade, or no material |
| 66 | mat_grade_evidence | string[] | facility_capacity.material.grades[].evidence | closed list ("; ") | the source states no grade, or no material |
| 67 | mat_grade_source_url | string[] | facility_capacity.material.grades[]: cap_source_url when source_is_figure, else citation.citation_url | free list (JSON array) | the source states no grade, or no material; an item null: that grade's source cites no page |
| 68 | mat_grade_quote | string[] | facility_capacity.material.grades[]: cap_quote, only for evidence spec_quoted or label_quoted when source_is_figure, else citation.quote | free list (JSON array) | the source states no grade, or no material; an item null: no quote prints that grade's words |
| 69 | mat_grade_read_on | string[] | facility_capacity.material.grades[]: cap_read_on when source_is_figure, else citation.read_on | closed list ("; ") | the source states no grade, or no material |
| 70 | mat_grade_as_of | string[] | facility_capacity.material.grades[]: cap_as_of when source_is_figure, else citation.as_of | closed list ("; ") | the source states no grade, or no material; an item null: that grade's document is undated |
| 71 | mat_grade_tier | string[] | facility_capacity.material.grades[].tier | closed list ("; ") | the source states no grade, or no material |
| 72 | mat_spec | string[] | facility_capacity.material.specs[].value (a material_spec id) | closed list ("; ") | the source prints no assay or standard, or no material |
| 73 | mat_spec_text | string[] | facility_capacity.material.specs[].as_published | free list (JSON array) | the source prints no assay or standard, or no material |
| 74 | mat_spec_source_url | string[] | facility_capacity.material.specs[]: cap_source_url when source_is_figure, else citation.citation_url | free list (JSON array) | the source prints no assay or standard, or no material |
| 75 | mat_spec_read_on | string[] | facility_capacity.material.specs[]: cap_read_on when source_is_figure, else citation.read_on | closed list ("; ") | the source prints no assay or standard, or no material |
| 76 | mat_spec_tier | string[] | facility_capacity.material.specs[].tier | closed list ("; ") | the source prints no assay or standard, or no material |
| 77 | mat_purity_min | number[] | 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 |
| 78 | mat_purity_species | string[] | material_spec.headline.species of each mat_spec, with "/" and headline.of for a ratio | closed list ("; ") | no spec, or no registry; an item null: the registry holds no such spec |
| 79 | mat_origin | string | facility_capacity.material.origin.value | scalar | the row carries no material object, or the source states no origin |
| 80 | mat_origin_evidence | string | facility_capacity.material.origin.evidence | scalar | the row carries no material object, or the source states no origin |
| 81 | mat_route | string | facility_capacity.material.route.value | scalar | the row carries no material object, or the source states no route |
| 82 | mat_route_evidence | string | facility_capacity.material.route.evidence | scalar | the row carries no material object, or the source states no route |
| 83 | mat_registry_version | string | facility_capacity.material.registry_version | scalar | the row carries no material object |
| 84 | mat_hs_lines | string[] | 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 tokens | closed 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 |
| 85 | mat_origin_tier | string | facility_capacity.material.origin.tier | scalar | the row carries no material object, or the source states no origin |
| 86 | mat_origin_source_url | string | facility_capacity.material.origin: cap_source_url when source_is_figure, else citation.citation_url | scalar | the row carries no material object, the source states no origin, or it cites no page |
| 87 | mat_route_tier | string | facility_capacity.material.route.tier | scalar | the row carries no material object, or the source states no route |
| 88 | mat_route_source_url | string | facility_capacity.material.route: cap_source_url when source_is_figure, else citation.citation_url | scalar | the row carries no material object, the source states no route, or it cites no page |
| 89 | own_owner | string or string[] | site_ownership.owner (as printed) of each holder in the current split, then each read printing no owners | free 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 |
| 90 | own_owner_kind | string 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 owners | closed 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 |
| 91 | own_owner_country | string or string[] | site_ownership.owner_country of each holder in the current split, then each read printing no owners | closed 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 |
| 92 | own_owner_identifier | string or string[] | site_ownership.owner_identifier (scheme:key) of each holder in the current split, then each read printing no owners | closed 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 |
| 93 | own_owner_entity_id | string or string[] | site_ownership.owner_entity_id of each holder in the current split, then each read printing no owners | closed 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 |
| 94 | own_held_via | string or string[] | site_ownership.held_via of each holder in the current split, then each read printing no owners | free 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 |
| 95 | own_stake_percent | number or number[] | site_ownership.stake_percent of each holder in the current split, then each read printing no owners | closed 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 |
| 96 | own_stake_min | number or number[] | site_ownership.stake_min of each holder in the current split, then each read printing no owners | closed 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 |
| 97 | own_stake_max | number or number[] | site_ownership.stake_max of each holder in the current split, then each read printing no owners | closed 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 |
| 98 | own_stake_qualifier | string or string[] | site_ownership.stake_qualifier (approximate, at_least, at_most) of each holder in the current split, then each read printing no owners | closed 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 |
| 99 | own_basis | string or string[] | site_ownership.stake_basis of each holder in the current split, then each read printing no owners | closed 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 |
| 100 | own_as_of | string 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 owners | closed 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 |
| 101 | own_valid_to | string or string[] | site_ownership.valid_to (as printed) of each holder in the current split, then each read printing no owners | closed 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 |
| 102 | own_source_url | string or string[] | site_ownership.citation_url of each holder in the current split, then each read printing no owners | free 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 |
| 103 | own_document | string or string[] | site_ownership.document of each holder in the current split, then each read printing no owners | free 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 |
| 104 | own_document_kind | string or string[] | site_ownership.document_kind of each holder in the current split, then each read printing no owners | closed 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 |
| 105 | own_publisher_role | string 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 owners | closed 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 |
| 106 | own_section_or_page | string or string[] | site_ownership.section_or_page of each holder in the current split, then each read printing no owners | free 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 |
| 107 | own_quote | string or string[] | site_ownership.quote of each holder in the current split, then each read printing no owners | free 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 |
| 108 | own_quote_translation | string or string[] | site_ownership.quote_translation of each holder in the current split, then each read printing no owners | free 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 |
| 109 | own_read_on | string or string[] | site_ownership.read_on of each holder in the current split, then each read printing no owners | closed 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 |
| 110 | own_line | string 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 read | free 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 |
| 111 | owners_from | string | where 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) | scalar | the site has no typed row and no curated owners matched |
| 112 | own_publisher | string 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 owners | free 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) |
| 113 | own_publisher_identifier | string 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 owners | closed 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) |
| 114 | own_holding_level | string 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 owners | closed 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) |
| 115 | own_document_sha256 | string 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 owners | closed 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) |
| 116 | facility_ids | string[] | 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 id | closed 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) |
| 117 | site_key | string | the 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 stage | scalar | the census row is keyed only by its name (a site_id beginning "name:"), which is no site identity |
| 118 | prod_included_in_site_id | string 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. |
| 119 | lease_disclosures | object[] | site_lease. Dated mining leases and licences for this census site and stage, with the holder and original document. | JSON array of records | The edition has no published lease disclosure for this site and stage. |
| 120 | cap_other_figures | object[] | 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 records | No additional capacity figure is published for this row at the requested date. |