======================================================================
CHECK 1: dedup-key integrity
======================================================================
Rows with blank/placeholder APN:               713
Rows with blank/placeholder tracking ID:        58
Rows with BOTH blank:                            0

Deduped units, key WITHOUT jurisdiction:       991,298
Deduped units, key WITH jurisdiction:          991,298
Difference (units falsely merged across jurisdictions by the old key): 0

Same-key groups appearing >1x WITHIN a single APR year: 3,907
Units in those groups: 21,443 (units that WOULD be dropped by within-year collapse: 15,592 if rows are equal-sized)

Dedup strategy comparison (statewide units, all years):
  A. No dedup:                          1,214,118
  B. Cross-year only (keep within):     1,004,430
  C. Full row-collapse (with jur):        991,298
  D. Full row-collapse (no jur, as published):      991,298

[Strategy B: cross-year dedup, jurisdiction-aware] 2018-2025
  Total units:                               975,286
  Owner + DR VLI/LI (excl ADU):                2,526   1 in 386 of all units
      as share of owner units:          0.647%  (1 in 155)
  Owner + DR MODERATE (excl ADU):              1,656
  Owner + DR VLI/LI/Mod (excl ADU):            4,182   1 in 233 of all units
  Renter + DR VLI/LI (any):                  116,919   = 20.00% of renter units

[Strategy C: full collapse, jurisdiction-aware] 2018-2025
  Total units:                               962,501
  Owner + DR VLI/LI (excl ADU):                2,514   1 in 383 of all units
      as share of owner units:          0.659%  (1 in 152)
  Owner + DR MODERATE (excl ADU):              1,588
  Owner + DR VLI/LI/Mod (excl ADU):            4,102   1 in 235 of all units
  Renter + DR VLI/LI (any):                  116,225   = 20.00% of renter units

[Strategy A: no dedup (upper bound denominator)] 2018-2025
  Total units:                             1,183,572
  Owner + DR VLI/LI (excl ADU):                3,333   1 in 355 of all units
      as share of owner units:          0.700%  (1 in 143)
  Owner + DR MODERATE (excl ADU):              2,069
  Owner + DR VLI/LI/Mod (excl ADU):            5,402   1 in 219 of all units
  Renter + DR VLI/LI (any):                  138,288   = 19.54% of renter units

======================================================================
CHECK 2: statewide totals by year under strategy B (vs HCD dashboard)
======================================================================
ayear
2018    110711
2019    111092
2020    108141
2021    125102
2022    136014
2023    140062
2024    120973
2025    123191

======================================================================
CHECK 3: tenure plausibility crosstab (strategy B, units)
======================================================================
TENURE     Owner  Renter  pct_owner
UNIT_CAT                           
2 to 4      8364   25951       0.24
5+         27613  396519       0.07
ADU        17742  151936       0.10
MH          8741    4057       0.68
SFA        27430    1602       0.94
SFD       300780    4551       0.99

======================================================================
CHECK 4: numerator audit — top jurisdictions & projects (strategy B)
======================================================================
Rows contributing to numerator: 1,245; units: 2,526

Top 15 jurisdictions by numerator units:
JURIS_NAME
INDIO               216
FREMONT             133
ONTARIO             100
HALF MOON BAY        94
SACRAMENTO           85
IMPERIAL             71
CLAREMONT            68
REEDLEY              67
BUENA PARK           59
REDDING              58
RIVERSIDE COUNTY     57
PALMDALE             54
POWAY                53
BAKERSFIELD          51
LIVERMORE            50

Top 20 largest single rows (project-level, for public-record spot checks):
                JURIS_NAME       CNTY_NAME  ayear                            PROJECT_NAME                        STREET_ADDRESS UNIT_CAT  vli_li_dr  bp_units    DR_TYPE TERM_AFF_DR
256333               INDIO       Riverside   2022                      Arroyo Crossing II                   47605  Jefferson St       5+        214       216      Other          55
836675       HALF MOON BAY       San Mateo   2024                         Stone Pine Cove                   880 Stone Pine Road       5+         94        94      Other          55
393153             ONTARIO  San Bernardino   2019                                     NaN  110 N VIRGINIA AV, ONTARIO, CA 91761       5+         82        83      Other          55
196909             FREMONT         Alameda   2019              Metro Crossing Building A1                  45025 S Grimmer Blvd       5+         70        71         DB          55
885334           CLAREMONT     Los Angeles   2024                 Larkin Place Apartments                     731 Harrison Ave.       5+         66        66         DB         NaN
197969             FREMONT         Alameda   2019              Metro Crossing Building A2                  45108 Tom Blalock St       5+         60        61         DB          55
333589               POWAY       San Diego   2019                           Villa De Vida                    12341 Oak Knoll Rd       5+         53        54        INC          57
695679              COLUSA          Colusa   2025                Rancho Colusa (Phase II)                       1717 Highway 20       5+         48        48         DB          55
743926          SEBASTOPOL          Sonoma   2023                                Woodmark                       7716 Bodega Ave       5+         47        48         DB          55
740197            ALHAMBRA     Los Angeles   2023                                     NaN                          103 N Chapel       5+         43        44      Other          55
802334           LIVERMORE         Alameda   2019                                     NaN                      1665 CHESTNUT ST       5+         42        42      Other         NaN
572305          BUENA PARK          Orange   2022                                     NaN                  8180 Commonwealth #B       5+         30        30      Other          55
118076          BUENA PARK          Orange   2022                                     NaN                  8180 Commonwealth #A       5+         28        28      Other          55
199491             REDDING          Shasta   2019                            Kennet Court          1081 LAKE BLVD, UNIT #BLDG 2      SFD         24        24      Other          55
854917            RICHMOND    Contra Costa   2024                 LEGACY COURT TOWNHOMES:            1243-1329 FRED JACKSON WAY       5+         24        43  INC;Other         NaN
199143             REDDING          Shasta   2019                            Kennet Court          1085 LAKE BLVD, UNIT #BLDG 1      SFD         23        23      Other          55
156260          SANTA CRUZ      Santa Cruz   2023                                     NaN                      508/418 FRONT ST       5+         20       175        INC        1000
393154             ONTARIO  San Bernardino   2019                                     NaN  112 N VIRGINIA AV, ONTARIO, CA 91761       5+         18        18      Other          55
365915            CARLSBAD       San Diego   2019                     UPTOWN BRESSI RANCH                      6066 COLT PL 105      SFA         17        79        INC         NaN
227401  SAN JOAQUIN COUNTY     San Joaquin   2021  TRINITY DEVELOPMENT & CONSTRUCTION INC                      295 W MATHEWS RD       5+         16        16      Other        1000

Numerator by unit category:
UNIT_CAT
2 to 4      53
5+        1330
MH          82
SFA        237
SFD        824

Numerator by DR_TYPE:
DR_TYPE
Other           1293
DB               547
INC              442
DB;INC            46
INC;Other         25
DB;Other          15
DB;INC;Other       1

Numerator rows with vli_li_dr > 50 in a single row (verify these):
           JURIS_NAME  ayear                PROJECT_NAME UNIT_CAT TENURE  vli_li_dr  bp_units
196909        FREMONT   2019  Metro Crossing Building A1       5+  Owner         70        71
197969        FREMONT   2019  Metro Crossing Building A2       5+  Owner         60        61
256333          INDIO   2022          Arroyo Crossing II       5+  Owner        214       216
333589          POWAY   2019               Villa De Vida       5+  Owner         53        54
393153        ONTARIO   2019                         NaN       5+  Owner         82        83
836675  HALF MOON BAY   2024             Stone Pine Cove       5+  Owner         94        94
885334      CLAREMONT   2024     Larkin Place Apartments       5+  Owner         66        66

======================================================================
CHECK 5: high-growth counties, strategy B
======================================================================
HG total: 588,328; owner+DR VLI/LI excl ADU: 1,249; 1 in 471
