{"ok":true,"computed_at":"2026-09-19T21:37:33.587Z","index":{"cpts":110819,"payers":90,"states":56,"_refresh":{"method":"full scan of the live serving tables, run from the OVH box via psql (the MCP/HTTP path times out at 120s)","known_defect":"renewal_npis recomputes to 0: payer_renewal_window.payer does not join to npi_payer_cpt_rate.payer (key namespace mismatch). The cached 189465 is not reproducible today and 0 would imply no renewals exist, so both were left alone rather than published. renewal_waves still carry July 2026 dates presented as upcoming.","refreshed_at":"2026-08-17T12:55:09.544573+00:00","not_refreshed":["renewal_npis","renewal_rows","renewal_waves"],"refreshed_fields":["payers","all_payers","states","cpts","rate_rows","total_rate_rows","total_npis","npis_with_data","peer_stat_cells","renewal_payers"]},"_withheld":{"by":"@MEMO-PACKET-PLAYBOOK, on the president's ruling: withhold beats guess","rule":"CLAUDE.md HARD rule 1 (real data or an honest empty state) and rule 4 (numbers-at-MAX as SCOPE, defer to live stats with the same labels). A number we cannot recompute is a remembered number.","restore":"Recompute from the OVH box via psql (the MCP/HTTP path times out at 120s), after mapping payer_renewal_window.payer through the payer-slug forms so the namespaces agree. Do not republish until the recomputed figure is reproducible on demand.","withheld_at":"2026-09-19T01:20:00Z","renewal_npis":{"why":"Not reproducible. payer_renewal_window.payer holds payer DISPLAY NAMES (e.g. \"Aetna Health Inc. (a PA corp.)\") while npi_payer_cpt_rate.payer holds SLUGS, so the join yields 0. The endpoint's own _refresh.known_defect said so and published it anyway. Last computed 2026-08-17.","value":189465},"renewal_rows":{"why":"Same failed join. payer_renewal_window has only 798 rows in total, so 201,259 cannot be a count of it and is unsupportable from any table we can point at today.","value":201259},"renewal_payers":{"why":"Reproducible but MISLABELLED, which is worse. It is count(distinct payer) over that 798-row reference list, in the display-name namespace, published beside payers=90 as if it were renewal coverage. A true number under a false noun.","value":397}},"rate_rows":370843731,"all_payers":90,"total_npis":2254755,"renewal_waves":[{"pct":51.1,"date":"2026-08-31","npis":96829,"label":"Aug 31","month":8,"payers":20},{"pct":36.8,"date":"2026-09-30","npis":69657,"label":"Sep 30","month":9,"payers":27}],"npis_with_data":2255302,"peer_stat_cells":62170064,"total_rate_rows":370843731},"percentiles_98941":{"avg":105.72,"cpt":"99213","p25":72.86,"p50":92.75,"p75":126.67,"p90":169.7,"label":"Office visit, established patient (all specialties)","samples":2730043},"ca_payer_leaderboard":[{"payer":"bcbs_ca","median_rate":21.6,"practices_affected":177},{"payer":"aetna_ca","median_rate":29.7,"practices_affected":2010},{"payer":"molina_ca","median_rate":33.4,"practices_affected":12},{"payer":"lacare","median_rate":35.09,"practices_affected":46},{"payer":"cigna_ca","median_rate":39.91,"practices_affected":2014},{"payer":"uhc","median_rate":60.54,"practices_affected":445}],"example_breakdown":[{"avg":8.53,"cpt":"36415","p25":3,"p50":6.72,"p75":9.07,"p90":11.83,"samples":3074754},{"avg":147.76,"cpt":"99214","p25":102.79,"p50":127.77,"p75":181.48,"p90":245.68,"samples":2777611},{"avg":105.72,"cpt":"99213","p25":72.86,"p50":92.75,"p75":126.67,"p90":169.7,"samples":2730043},{"avg":133.39,"cpt":"99203","p25":91.56,"p50":116.74,"p75":160.14,"p90":210.46,"samples":2536985},{"avg":41,"cpt":"97110","p25":25.67,"p50":31.35,"p75":48.4,"p90":75.55,"samples":2477530},{"avg":15.32,"cpt":"80053","p25":6.8,"p50":9.5,"p75":12.64,"p90":20.39,"samples":2468962},{"avg":26.87,"cpt":"93000","p25":17.6,"p50":22.9,"p75":31.55,"p90":41.76,"samples":2312471},{"avg":195.66,"cpt":"90837","p25":137.01,"p50":171.77,"p75":224.54,"p90":317.16,"samples":2286727}],"live_feed":{"payer":"aetna_national","cpt":"D6010","state":"TX","ingested_at":"2026-09-05T17:37:39.396428+00:00"}}