{"ok":true,"computed_at":"2026-09-13T03:45:20.366Z","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"]},"rate_rows":370843731,"all_payers":90,"total_npis":2254755,"renewal_npis":189465,"renewal_rows":201259,"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,"renewal_payers":397,"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"}}