> ## Documentation Index > Fetch the complete documentation index at: https://offthepace.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # stg_tyre_allocations > Pirelli weekend compound nominations for 2019-2024: which C-code each of hard/medium/soft actually was, per race. Part of the [Staging](/transform/families/staging) family. Pirelli weekend compound nominations for 2019-2024: 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): 128 races x 3 = 384 rows. 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 ```mermaid theme={null} flowchart LR stg_tyre_allocations --> int_stint_geometry style stg_tyre_allocations fill:#e40404,stroke:#e40404,color:#fff ``` ## Overview | Property | Value | | ----------------- | -------------------------------------- | | Layer | `staging` | | Family | [Staging](/transform/families/staging) | | Contract enforced | No | **7 tests** [guard](/transform/ci/overview) this model - 7 generic, 0 singular. ## Columns | Column | Type | Nullable | Tests | Description | | --------------------------- | --------- | -------- | ------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `race_year` | `integer` | Yes | [`not_null`](/transform/ci/structural) | Season year, 2019-2024. | | `circuit_key` | `varchar` | Yes | [`not_null`](/transform/ci/structural) | 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`](/transform/ci/structural), [`accepted_values`](/transform/ci/range-and-domain) | Pirelli compound code. C1 hardest, C5 softest. | | `compound_label` | `varchar` | Yes | [`not_null`](/transform/ci/structural), [`accepted_values`](/transform/ci/range-and-domain) | 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`](/transform/ci/structural) | 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. |