stg_tyre_allocations

Pirelli weekend compound nominations for 2019-2025: which C-code each of hard/medium/soft actually was, per race.

Part of the Staging family.

Pirelli weekend compound nominations for 2019-2025: which C-code each of hard/medium/soft actually was, per race. compound_label has been RELATIVE since 2019 (Pirelli picks 3 of 5 physical compounds per weekend), so “SOFT” at one circuit is not the same rubber as “SOFT” at another; this model supplies the absolute scale that makes them comparable. One row per (race, label): 151 races x 3 = 453 rows (128 races for 2019-2024, 23 for 2025; the 2025 seed has no Miami row). 2025 values are carried forward from the circuit’s 2023 or 2024 allocation (source_url = ‘carried_from_20xx’), not read from a 2025 Pirelli preview. Row counts per season and three labels per race are pinned by assert_tyre_allocations_rows_per_season. PROVENANCE - READ BEFORE QUOTING ANYTHING FROM THIS TABLE. The seed is USER-SUPPLIED AND SELF-VERIFIED, not machine-sourced. source_url names the Pirelli per-race preview each row is attributed to, but only 47 of the 128 URLs resolve; the rest 404 against the live press site, which no longer serves its pre-2025 archive. Values were accepted on the user’s authority to unblock downstream work (08d) and are expected to be replaced once an archival source is available. Spot-checks that DID verify at source: 2022 Australia C2/C3/C5 (the deliberate C4 skip), 2022 Emilia-Romagna C2/C3/C4, and the 2024 Americas trio (Austin C2/C3/C4, Mexico City C3/C4/C5, Sao Paulo C3/C4/C5). See _improvements/work/08-foundations-repair.md section 08d.

​

Lineage

​

Overview

Property	Value
Layer	staging
Family	Staging
Contract enforced	No
Model-level tests	unique_combination_of_columns

11 tests guard this model - 10 generic, 1 singular.

​

Columns

Column	Type	Nullable	Tests	Description
race_year	integer	Yes	not_null	Season year, 2019-2025.
circuit_key	varchar	Yes	not_null, relationships	Event/grand-prix key, matching dim_circuits.circuit_key. Event-level, not venue-level: 2020 Silverstone is british_grand_prix AND 70th_anniversary_grand_prix, and the Red Bull Ring / Bahrain double-headers split the same way.
compound_code	varchar	Yes	not_null, accepted_values, relationships	Pirelli compound code. C1 hardest, C5 softest.
compound_label	varchar	Yes	not_null, accepted_values	The relative label this code was badged as for that weekend.
allocated_sets_per_driver	integer	Yes		NULL by construction. FIA technical allocation data, not carried by Pirelli’s compound announcements - left unpopulated rather than invented.
source_url	varchar	Yes	not_null	Pirelli press URL this row is attributed to. See the model description: most of these do not currently resolve. Presence of a URL is not evidence the row is sourced.