Back to MRF Run #70
Export PDF

Quality Care Partners

s3://talon-storage-private/mrf-feed-uploads/2025-11/2025-11-05_QCP_in-network-rates.json.gz
File date: 11/4/2025 Run: 2026-04-24 22:40 EDT v1.0.0
73.9
Limited Reliability
Generated At
2026-04-24 22:40 EDT
Elapsed
335.20s
Tool Version
1.0.0
Parse Errors / Crashes
0 / 0
File (raw compressed)
Size:  46.74 MB (49,006,751 bytes)
MD5:  e9cf03a29259158fc7c0fb952aecfda8
TOC Source
talon-storage-private/mrf-feed-uploads/2025-11/2025-11_plan_ref_98d7022b7d7165738b14c89261e12b3b_index.json
Talon
Canonical: s3://talon-storage-private/mrf-feed-uploads/2025-11/2025-11-21_QCP_in-network-rates.json.gz
Mirror: s3://talon-storage-private/mrf-feed-uploads/2025-11/2025-11-21_QCP_in-network-rates.json.gz
1 plan(s) in TOC
Plan Name Plan ID Issuer Market
QCP 0123456789 (custom) — —
CMS Official Schema Validation PASSED
Schema Integrity
78.9
Provider Mapping
99.9
Code Coverage
70.0
Pricing Sanity
62.0
Provider Geographic Coverage Loading…
Analysing provider locations…
Errors (1)
zero_rates
71337 zero-dollar rates (2.49%) — CMS schema requires negotiated_rate > 0 (exclusiveMinimum)
Warnings (12)
header_conditional
last_updated_on '11/4/2025' is not a valid YYYY-MM-DD date
header_conditional
Partial plan fields present — missing: ['plan_market_type']
rates_without_providers
241287 negotiated_rate entries have neither provider_groups nor provider_references
expired_prices
16475 negotiated_prices have past expiration dates (0.6%)
npi_validity
0.02% of NPIs failed Luhn checksum validation (1 of 4135)
  • 1810341789
ein_validity
0.39% of EINs failed IRS prefix validation (17 of 4359)
  • 281723399
  • 282504837
  • 282884410
  • 283428410
  • 287641240
  • … and 5 more
empty_npi_groups
224 provider groups contain no NPIs
billing_code_format
2126440 HCPCS codes do not match expected format
duplicate_billing_codes
14699 billing codes appear in more than one in_network item (99.1%)
rate_spread_by_class
billing_class='institutional' / negotiated_type='fee schedule': P95/P50 spread is 23.4x (threshold: 10x, N=893,592 (1,000 sampled), high confidence)
rate_spread_by_class
billing_class='professional' / negotiated_type='fee schedule': P95/P50 spread is 11.8x (threshold: 5x, N=1,973,393 (1,000 sampled), high confidence)
per_code_rate_spread
1057 rate contexts have a max/min ratio exceeding the type-specific threshold (20x professional / 50x facility, min 3 occurrences required). Each context is a unique combination of all 10 rate-key dimensions. n= shows how many distinct provider rates exist for that exact context.
Code Code Type Negotiated Type Billing Class Arrangement Setting Min Median Mean Max Ratio n
Q0249 HCPCS fee schedule institutional ffs — $7.57 $6572.00 $4867.23 $14129.80 1866.8× 83
92953 HCPCS fee schedule institutional ffs — $0.81 $1.66 $628.53 $1435.83 1772.6× 79
Q0249 HCPCS fee schedule professional ffs — $7.57 $6572.00 $3562.92 $11829.60 1562.9× 218
95004 HCPCS fee schedule institutional ffs — $3.38 $6.93 $979.43 $2232.34 660.5× 79
95044 HCPCS fee schedule institutional ffs — $4.66 $9.55 $980.78 $2232.34 479.0× 79
63685 HCPCS fee schedule institutional ffs — $315.24 $646.24 $29561.86 $66865.00 212.1× 79
33289 HCPCS fee schedule institutional ffs — $296.20 $607.21 $27580.03 $62377.31 210.6× 79
86905 HCPCS fee schedule institutional ffs — $3.83 $7.85 $348.01 $789.29 206.1× 79
33231 HCPCS fee schedule institutional ffs — $360.56 $739.15 $31132.75 $70349.35 195.1× 79
33264 HCPCS fee schedule institutional ffs — $362.67 $743.47 $31134.97 $70349.35 194.0× 79
Info (3)
far_future_expiration
2851001 expiration_dates are more than 3 years in the future
duplicate_npis
291 NPIs appear in more than one provider group
percentage_rates
485 percentage rates (0.0%) — values represent % of a reference rate, not dollar amounts; excluded from spread analysis
Recommended Actions
  1. 1.
    pricing zero_rates
    71337 zero-dollar rates (2.49%) — CMS schema requires negotiated_rate > 0 (exclusiveMinimum)
    P1
  2. 2.
    provider_mapping npi_validity
    0.02% of NPIs failed Luhn checksum validation (1 of 4135)
    P2
  3. 3.
    provider_mapping ein_validity
    0.39% of EINs failed IRS prefix validation (17 of 4359)
    P2
  4. 4.
    provider_mapping empty_npi_groups
    224 provider groups contain no NPIs
    P2
  5. 5.
    pricing rate_spread_by_class
    billing_class='institutional' / negotiated_type='fee schedule': P95/P50 spread is 23.4x (threshold: 10x, N=893,592 (1,000 sampled), high confidence)
    P2
  6. 6.
    pricing rate_spread_by_class
    billing_class='professional' / negotiated_type='fee schedule': P95/P50 spread is 11.8x (threshold: 5x, N=1,973,393 (1,000 sampled), high confidence)
    P2
  7. 7.
    pricing per_code_rate_spread
    1057 rate contexts have a max/min ratio exceeding the type-specific threshold (20x professional / 50x facility, min 3 occurrences required). Each context is a unique combination of all 10 rate-key dimensions. n= shows how many distinct provider rates exist for that exact context.
    P2
  8. 8.
    schema header_conditional
    last_updated_on '11/4/2025' is not a valid YYYY-MM-DD date
    P2
  9. 9.
    schema header_conditional
    Partial plan fields present — missing: ['plan_market_type']
    P2
  10. 10.
    schema rates_without_providers
    241287 negotiated_rate entries have neither provider_groups nor provider_references
    P2
  11. 11.
    schema expired_prices
    16475 negotiated_prices have past expiration dates (0.6%)
    P2
  12. 12.
    code_coverage billing_code_format
    2126440 HCPCS codes do not match expected format
    P3
  13. 13.
    code_coverage duplicate_billing_codes
    14699 billing codes appear in more than one in_network item (99.1%)
    P3
Metrics

header_missing_fields
header_conditional_issues last_updated_on '11/4/2025' is not a valid YYYY-MM-DD date, Partial plan fields present — missing: ['plan_market_type']
file_age_days None
items_total 2865237
items_missing_required_pct 0.0
items_empty_rates 0
prices_total 2867476
prices_missing_required_pct 0.0
prices_missing_field_breakdown
prices_missing_service_code 0
prices_invalid_billing_class 0
rates_without_providers 241287
negotiation_arrangements
ffs 2865237
billing_code_types
CSTM-ALL 909
HCPCS 2864134
RC 194
expired_prices 16475
invalid_expiration_format 0

provider_references_in_file 4359
provider_group_ids_referenced 4359
unresolved_references 0
resolution_rate_pct 100.0
npis_validated 4135
invalid_npi_count 1
npi_validity_rate_pct 99.98
invalid_npi_examples 1810341789
eins_validated 4359
invalid_ein_count 17
ein_validity_rate_pct 99.61
invalid_ein_examples 281723399, 282504837, 282884410, 283428410, 283428410, 283428410, 287641240, 287743571, 287841552, 287924612
empty_npi_groups 224
groups_without_tin 0
npis_in_multiple_groups 291
unique_npis 1003037987, 1003046780, 1003105529, 1003121393, 1003163759, 1003220617, 1003225327, 1003268095, 1003295270, 1003296302, 1003297383, 1003300641, 1003325150, 1003389081, 1003398223, 1003508250, 1003551920, 1003693417, 1003801689, 1003803388, 1003811472, 1003814302, 1003826074, 1003828849, 1003851213, 1003857608, 1003888090, 1003891938, 1003894452, 1003926486, 1013028307, 1013032572, 1013033737, 1013075878, 1013087535, 1013088228, 1013108315, 1013165174, 1013167220, 1013175843, 1013204908, 1013235316, 1013268671, 1013270768, 1013280148, 1013405190, 1013420157, 1013430446, 1013453075, 1013456128, 1013474097, 1013503465, 1013547496, 1013588086, 1013764059, 1013794684, 1013906023, 1013912799, 1013917426, 1013934710, 1013956945, 1013959410, 1013974203, 1013993716, 1013997519, 1013999259, 1023002011, 1023013471, 1023013505, 1023017498, 1023022035, 1023032141, 1023040953, 1023042660, 1023060928, 1023062700, 1023066594, 1023071453, 1023078755, 1023080298, 1023111598, 1023113727, 1023115375, 1023168853, 1023196144, 1023201944, 1023214673, 1023319068, 1023329737, 1023344264, 1023413119, 1023432093, 1023469889, 1023476785, 1023493053, 1023520327, 1023540556, 1023541638, 1023544749, 1023594132, 1023695327, 1023731890, 1023787769, 1023793684, 1023818994, 1023882966, 1033141155, 1033178231, 1033183645, 1033213137, 1033230883, 1033323969, 1033405139, 1033422324, 1033456439, 1033466008, 1033484548, 1033485883, 1033494794, 1033537584, 1033577523, 1033585856, 1033595673, 1033613500, 1033646088, 1033657168, 1033675970, 1033682430, 1033691241, 1033701131, 1033740824, 1033760236, 1033766241, 1033787031, 1033837091, 1033990478, 1043200249, 1043201791, 1043207665, 1043210727, 1043216260, 1043219975, 1043228414, 1043268253, 1043272032, 1043284698, 1043299274, 1043348410, 1043350739, 1043404932, 1043464183, 1043508484, 1043536261, 1043536857, 1043571029, 1043573876, 1043661200, 1043675770, 1043686124, 1043695810, 1043843550, 1043887128, 1043932304, 1043974595, 1043988363, 1053018333, 1053041822, 1053154633, 1053165936, 1053182527, 1053191544, 1053191684, 1053197699, 1053312132, 1053312462, 1053316364, 1053345462, 1053347591, 1053347856, 1053364778, 1053376764, 1053392555, 1053399709, 1053425637, 1053430850, 1053475640, 1053480970, 1053512822, 1053527523, 1053553602, 1053560433, 1053575365, 1053620591, 1053635086, 1053644179, 1053661025, 1053687525, 1053751107, 1053761890, 1053775395, 1053792424, 1053792515, 1053815167, 1053818336, 1053860452, 1053880948, 1053892299, 1053931048, 1053940981, 1053951046, 1053982918, 1063019131, 1063043685, 1063047249, 1063070738, 1063114874, 1063177244, 1063249431, 1063284800, 1063400067, 1063404572, 1063407765, 1063411486, 1063440741, 1063456234, 1063460525, 1063489425, 1063498061, 1063514743, 1063518298, 1063556074, 1063569879, 1063573160, 1063580199, 1063593044, 1063638070, 1063640969, 1063643997, 1063649879, 1063681393, 1063705754, 1063721389, 1063744522, 1063755122, 1063757565, 1063772291, 1063788479, 1063807238, 1063815462, 1063817310, 1063861524, 1063903912, 1063927259, 1063977122, 1073006920, 1073016887, 1073029732, 1073036190, 1073077020, 1073085627, 1073092607, 1073096913, 1073106704, 1073140885, 1073153508, 1073190351, 1073245536, 1073505681, 1073511358, 1073513487, 1073516373, 1073518940, 1073545844, 1073599031, 1073599197, 1073599262, 1073599981, 1073600979, 1073613808, 1073656062, 1073697272, 1073712642, 1073756284, 1073766150, 1073770368, 1073836441, 1073869277, 1073902185, 1073952446, 1083021166, 1083031116, 1083043616, 1083059273, 1083060172, 1083102958, 1083150478, 1083153423, 1083165088, 1083180590, 1083193510, 1083216477, 1083218531, 1083226922, 1083241608, 1083335707, 1083357990, 1083434732, 1083613806, 1083634927, 1083648562, 1083655088, 1083662951, 1083664882, 1083671473, 1083681126, 1083686075, 1083696645, 1083705271, 1083725246, 1083734438, 1083795850, 1083797336, 1083816953, 1083828677, 1083836043, 1083856041, 1083867832, 1093008344, 1093131922, 1093173924, 1093191124, 1093239071, 1093243420, 1093244816, 1093247348, 1093267635, 1093281347, 1093304511, 1093343915, 1093345076, 1093481640, 1093556102, 1093726309, 1093763823, 1093770745, 1093771081, 1093791212, 1093863532, 1093908840, 1093933764, 1104081371, 1104110469, 1104111699, 1104147669, 1104182245, 1104231778, 1104261411, 1104364884, 1104427673, 1104454313, 1104499003, 1104530914, 1104563709, 1104801166, 1104804632, 1104808344, 1104816321, 1104821420, 1104822741, 1104842061, 1104895036, 1104913508, 1104928415, 1114013463, 1114025830, 1114063740, 1114076148, 1114130739, 1114149390, 1114155579, 1114188273, 1114188422, 1114198348, 1114198371, 1114204195, 1114210374, 1114215852, 1114238805, 1114303443, 1114311230, 1114347564, 1114361557, 1114419140, 1114421583, 1114437696, 1114448735, 1114450210, 1114451143, 1114480555, 1114487758, 1114496171, 1114522463, 1114551454, 1114561297, 1114586617, 1114598018, 1114619426, 1114692050, 1114700739, 1114788387, 1114793486, 1114905890, 1114909744, 1114918042, 1114920485, 1114922440, 1114922515, 1114987914, 1114995602, 1124008131, 1124008792, 1124040951, 1124043625, 1124069737, 1124086251, 1124095740, 1124095906, 1124098355, 1124116447, 1124164744, 1124172135, 1124189592, 1124195441, 1124231824, 1124259247, 1124272976, 1124282199, 1124372628, 1124392154, 1124439039, 1124470935, 1124472519, 1124478771, 1124520317, 1124523105, 1124523865, 1124547435, 1124551809, 1124552443, 1124568316, 1124568795, 1124570239, 1124573928, 1124584677, 1124626718, 1124719455, 1124733753, 1124746326, 1124807235, 1124837893, 1124866694, 1134115173, 1134119092, 1134124183, 1134126139, 1134131329, 1134162563, 1134173339, 1134190739, 1134192859, 1134198898, 1134201940, 1134216252, 1134361371, 1134384977, 1134407133, 1134408735, 1134421035, 1134422934, 1134433931, 1134471113, 1134502602, 1134503899, 1134520877, 1134569478, 1134623200, 1134650294, 1134680424, 1134760028, 1134767551, 1134813710, 1134952302, 1134980113, 1144003062, 1144075375, 1144210055, 1144216425, 1144218025, 1144218074, 1144221714, 1144226598, 1144228131, 1144230731, 1144239096, 1144239765, 1144246034, 1144260043, 1144270497, 1144303843, 1144317009, 1144364076, 1144412784, 1144464769, 1144511833, 1144530759, 1144534322, 1144539362, 1144553199, 1144580085, 1144583261, 1144609561, 1144610296, 1144630047, 1144642489, 1144674185, 1144674854, 1144681487, 1144691387, 1144696360, 1144701574, 1144706821, 1144717265, 1144749839, 1144759770, 1144779604, 1144781113, 1144793902, 1144801390, 1144804931, 1144809476, 1144850058, 1144853649, 1144878810, 1144881772, 1144956509, 1144960717, 1144997420, 1154071264, 1154080935, 1154307858, 1154316909, 1154330157, 1154384154, 1154423580, 1154436665, 1154450658, 1154531952, 1154600534, 1154664167, 1154707198, 1154725844, 1154734788, 1154748267, 1154753895, 1154791036, 1154793164, 1154817294, 1154818029, 1154829687, 1154836203, 1154843043, 1154844280, 1154876845, 1154961696, 1154976215, 1164026258, 1164053419, 1164054987, 1164159323, 1164290243, 1164425526, 1164432001, 1164432613, 1164457198, 1164463451, 1164520516, 1164597910, 1164620290, 1164641759, 1164676854, 1164705505, 1164759866, 1164765277, 1164818084, 1164854295, 1164857322, 1164865457, 1164865465, 1164875415, 1164906764, 1164937660, 1164950697, 1164965752, 1164974531, 1164978615, 1174034870, 1174097794, 1174111702, 1174180632, 1174260475, 1174532097, 1174549604, 1174557862, 1174600852, 1174603526, 1174613897, 1174624159, 1174654651, 1174693360, 1174698245, 1174709745, 1174721823, 1174798227, 1174827893, 1174828487, 1174841357, 1174866404, 1174878979, 1174885529, 1174907752, 1174919948, 1174943591, 1174986855, 1174988398, 1184005977, 1184011652, 1184012494, 1184042293, 1184068561, 1184107179, 1184123473, 1184125536, 1184126260, 1184135535, 1184146516, 1184154627, 1184165227, 1184230583, 1184264376, 1184292336, 1184378127, 1184606303, 1184620676, 1184622102, 1184626244, 1184626855, 1184628950, 1184679516, 1184696197, 1184713539, 1184771701, 1184797367, 1184810541, 1184849747, 1184860926, 1184862344, 1184891277, 1184894685, 1184895567, 1184912909, 1194000588, 1194024315, 1194041285, 1194083717, 1194112755, 1194118240, 1194188219, 1194202945, 1194236521, 1194307942, 1194314260, 1194315697, 1194319889, 1194353235, 1194402271, 1194488692, 1194512301, 1194561951, 1194612978, 1194712273, 1194718585, 1194719914, 1194724666, 1194728071, 1194755504, 1194762229, 1194772400, 1194775288, 1194782987, 1194787283, 1194794339, 1194795120, 1194826727, 1194850594, 1194865238, 1194892976, 1194900670, 1194925743, 1194929463, 1194936120, 1194943357, 1194990259, 1205043684, 1205047594, 1205065760, 1205071743, 1205080488, 1205096195, 1205115706, 1205142270, 1205147196, 1205148947, 1205160942, 1205191871, 1205199759, 1205203270, 1205224185, 1205234093, 1205262607, 1205263944, 1205264371, 1205295672, 1205298320, 1205299732, 1205325040, 1205329513, 1205330479, 1205339009, 1205456761, 1205464732, 1205501962, 1205505179, 1205526464, 1205576469, 1205619442, 1205803814, 1205811130, 1205813946, 1205815016, 1205815404, 1205824331, 1205864113, 1205886439, 1205928959, 1205956018, 1205961729, 1205961752, 1215002217, 1215019179, 1215035811, 1215057914, 1215136403, 1215154562, 1215223664, 1215241658, 1215249529, 1215298146, 1215322664, 1215390117, 1215420005, 1215421441, 1215437561, 1215441308, 1215442090, 1215450911, 1215458690, 1215482617, 1215487368, 1215521547, 1215554670, 1215611611, 1215662382, 1215666102, 1215687058, 1215787601, 1215907332, 1215909072, 1215915442, 1215915897, 1215924311, 1215925383, 1215926597, 1215939525, 1215972575, 1215973995, 1215993779, 1225000920, 1225012958, 1225016900, 1225020878, 1225023344, 1225033632, 1225039407, 1225054679, 1225055965, 1225072523, 1225113525, 1225166549, 1225170145, 1225226954, 1225228943, 1225284839, 1225299704, 1225308240, 1225331663, 1225341399, 1225343080, 1225401623, 1225441660, 1225482193, 1225524051, 1225561863, 1225569056, 1225586332, 1225730534, 1225769391, 1225771397, 1225893019, 1235102591, 1235115270, 1235138496, 1235138629, 1235160599, 1235196114, 1235209149, 1235314071, 1235316589, 1235319187, 1235388703, 1235475674, 1235486796, 1235490996, 1235540154, 1235577099, 1235596669, 1235622481, 1235663147, 1235680901, 1235690975, 1235763012, 1235768870, 1235778481, 1235794439, 1235803743, 1235817867, 1235823790, 1235860255, 1235990946, 1245016047, 1245210657, 1245217975, 1245225754, 1245235969, 1245238120, 1245260108, 1245289529, 1245293513, 1245295211, 1245296409, 1245325182, 1245344605, 1245349463, 1245351832, 1245403815, 1245410893, 1245446418, 1245475714, 1245482470, 1245493477, 1245518653, 1245524768, 1245525765, 1245573963, 1245583483, 1245601491, 1245625177, 1245641273, 1245683960, 1245693357, 1245707272, 1245762459, 1245784982, 1245797539, 1245890862, 1245898675, 1255021226, 1255023834, 1255047999, 1255083374, 1255091013, 1255170239, 1255313177, 1255330072, 1255330965, 1255353249, 1255381034, 1255383162, 1255394391, 1255430930, 1255501839, 1255518296, 1255520441, 1255522801, 1255597324, 1255607784, 1255616181, 1255646535, 1255667341, 1255688461, 1255701504, 1255720264, 1255726550, 1255732467, 1255743001, 1255796231, 1255797569, 1255800470, 1255807335, 1255875548, 1255910139, 1265020341, 1265081269, 1265103394, 1265189807, 1265407100, 1265423941, 1265432975, 1265433635, 1265472690, 1265480727, 1265498604, 1265503551, 1265515662, 1265528269, 1265583009, 1265587349, 1265608004, 1265634158, 1265679187, 1265700843, 1265702369, 1265724405, 1265772347, 1265813141, 1265818553, 1265827133, 1265842751, 1265842991, 1265885602, 1265910384, 1265949226, 1265949382, 1265963540, 1265978373, 1265993455, 1275002073, 1275007213, 1275037947, 1275044604, 1275068850, 1275126617, 1275131302, 1275187452, 1275194664, 1275199820, 1275204810, 1275210726, 1275217267, 1275248809, 1275265621, 1275277220, 1275331126, 1275502213, 1275519647, 1275527897, 1275532251, 1275536237, 1275574535, 1275581605, 1275589038, 1275594350, 1275599524, 1275601502, 1275704363, 1275708760, 1275735623, 1275826463, 1275850737, 1275879454, 1275882706, 1275913808, 1275917866, 1275925422, 1275927048, 1275927105, 1275945016, 1275950560, 1275993040, 1285006619, 1285008946, 1285040410, 1285048603, 1285100040, 1285107094, 1285112532, 1285127852, 1285154997, 1285170654, 1285256628, 1285309096, 1285353334, 1285479592, 1285619122, 1285620179, 1285633115, 1285636084, 1285667410, 1285669481, 1285691113, 1285694380, 1285729616, 1285760579, 1285771634, 1285787341, 1285820001, 1285903757, 1285920744, 1285942151, 1285957308, 1285961805, 1285991976, 1285996140, 1295001204, 1295004877, 1295012227, 1295032902, 1295034346, 1295040178, 1295040624, 1295092732, 1295095966, 1295129831, 1295148260, 1295224350, 1295268498, 1295268654, 1295273910, 1295296648, 1295306140, 1295306330, 1295335289, 1295343358, 1295352482, 1295512911, 1295700755, 1295713725, 1295721611, 1295724359, 1295774040, 1295778215, 1295787414, 1295812279, 1295857332, 1295876449, 1295901023, 1295937654, 1295940781, 1295977924, 1295997518, 1306003033, 1306063656, 1306092432, 1306101852, 1306123112, 1306163704, 1306183942, 1306214101, 1306217088, 1306226873, 1306227285, 1306227921, 1306263330, 1306289897, 1306292909, 1306307368, 1306338025, 1306341441, 1306379086, 1306394143, 1306439583, 1306510474, 1306598081, 1306690326, 1306693304, 1306803390, 1306806369, 1306810635, 1306814330, 1306823695, 1306832928, 1306840210, 1306878111, 1306896360, 1306942214, 1306951157, 1316017429, 1316056567, 1316078835, 1316082506, 1316107154, 1316128853, 1316197080, 1316200629, 1316208929, 1316258437, 1316263015, 1316375124, 1316384035, 1316400955, 1316463490, 1316468978, 1316473242, 1316473721, 1316476823, 1316485253, 1316507981, 1316604010, 1316619554, 1316657042, 1316678329, 1316760556, 1316900053, 1316906811, 1316912306, 1316916752, 1316935653, 1316940513, 1316942410, 1316975618, 1316980741, 1316986805, 1326046541, 1326047028, 1326079005, 1326097809, 1326163890, 1326165259, 1326178815, 1326225301, 1326232232, 1326265794, 1326270505, 1326367327, 1326433558, 1326438011, 1326452061, 1326488891, 1326512898, 1326516527, 1326517509, 1326556812, 1326596875, 1326638990, 1326676917, 1326685066, 1326710823, 1326849969, 1336101542, 1336104355, 1336105113, 1336114602, 1336116383, 1336132547, 1336133685, 1336136514, 1336155837, 1336192517, 1336192624, 1336197474, 1336208040, 1336218031, 1336248335, 1336265602, 1336287002, 1336292085, 1336293034, 1336313865, 1336318047, 1336338326, 1336355973, 1336435965, 1336469006, 1336476415, 1336494814, 1336512672, 1336514801, 1336527985, 1336557883, 1336571116, 1336575174, 1336625680, 1336626423, 1336631647, 1336636422, 1336656941, 1336677608, 1336709799, 1336733450, 1336761972, 1336769702, 1336773621, 1336782093, 1336789015, 1336799873, 1336854439, 1336943802, 1336976497, 1346053501, 1346072618, 1346223351, 1346228467, 1346236692, 1346239357, 1346244266, 1346245388, 1346247673, 1346264397, 1346293404, 1346313897, 1346322005, 1346324167, 1346324738, 1346377090, 1346419793, 1346432143, 1346438066, 1346457355, 1346469491, 1346500816, 1346501269, 1346501319, 1346503091, 1346550472, 1346552957, 1346555414, 1346580842, 1346583630, 1346589553, 1346591914, 1346603008, 1346634623, 1346655966, 1346664109, 1346675121, 1346691482, 1346705472, 1346747961, 1346751625, 1346759412, 1346770393, 1346782687, 1346800828, 1346897741, 1346898103, 1356035315, 1356312102, 1356320667, 1356333470, 1356343586, 1356348676, 1356354773, 1356463616, 1356472815, 1356570287, 1356571053, 1356592869, 1356607378, 1356614267, 1356630727, 1356653737, 1356696918, 1356726046, 1356738439, 1356741664, 1356749998, 1356787550, 1356793095, 1356798094, 1356802888, 1356821581, 1356854228, 1356865034, 1356868426, 1356963862, 1356987960, 1356996417, 1356997456, 1366108342, 1366180952, 1366295313, 1366409468, 1366420614, 1366437949, 1366438848, 1366449464, 1366488702, 1366492027, 1366509978, 1366515405, 1366522658, 1366580110, 1366580375, 1366622185, 1366646119, 1366693772, 1366709891, 1366714032, 1366720658, 1366748535, 1366784712, 1366791659, 1366806481, 1366925109, 1366949976, 1376006338, 1376026740, 1376039099, 1376039388, 1376049726, 1376058701, 1376064642, 1376075135, 1376123141, 1376302034, 1376309765, 1376346296, 1376513424, 1376513564, 1376527663, 1376540625, 1376541649, 1376549543, 1376570556, 1376584961, 1376585141, 1376626507, 1376639385, 1376643841, 1376653634, 1376702761, 1376757690, 1376758797, 1376796581, 1376801274, 1376818369, 1376848028, 1376929521, 1386000255, 1386010460, 1386013258, 1386040509, 1386050821, 1386087435, 1386100113, 1386110054, 1386121556, 1386121820, 1386147197, 1386200509, 1386252856, 1386256717, 1386362325, 1386389211, 1386398048, 1386399863, 1386479814, 1386608883, 1386609634, 1386616548, 1386622025, 1386628469, 1386640613, 1386649457, 1386683290, 1386685790, 1386686988, 1386733434, 1386804284, 1386855484, 1386855674, 1386902096, 1386913945, 1386918993, 1386931327, 1386932093, 1386957447, 1386995967, 1396008553, 1396102901, 1396104196, 1396108676, 1396143533, 1396164125, 1396180923, 1396230645, 1396238440, 1396243374, 1396248795, 1396257663, 1396290441, 1396297651, 1396312500, 1396326609, 1396402004, 1396407946, 1396457792, 1396481446, 1396708814, 1396710091, 1396723979, 1396725271, 1396740445, 1396750782, 1396762134, 1396766705, 1396838785, 1396856191, 1396875407, 1396905584, 1396977385, 1407001563, 1407042468, 1407070576, 1407078413, 1407106404, 1407122989, 1407175052, 1407217995, 1407233208, 1407246853, 1407248354, 1407258221, 1407269988, 1407276496, 1407301112, 1407303399, 1407344922, 1407357239, 1407357940, 1407387426, 1407392079, 1407406739, 1407418411, 1407421407, 1407451289, 1407470719, 1407503006, 1407662968, 1407802754, 1407817661, 1407820483, 1407825912, 1407835572, 1407843162, 1407844749, 1407881154, 1407904808, 1407921158, 1407928823, 1407946262, 1407975535, 1417026949, 1417030701, 1417032749, 1417061995, 1417091786, 1417128083, 1417141078, 1417168311, 1417188806, 1417214032, 1417244393, 1417269309, 1417273459, 1417277229, 1417290834, 1417305558, 1417311200, 1417354721, 1417377409, 1417377615, 1417386905, 1417390972, 1417415993, 1417455577, 1417469172, 1417471582, 1417481771, 1417481839, 1417534314, 1417538323, 1417550559, 1417571118, 1417577974, 1417588229, 1417681974, 1417707969, 1417722182, 1417737867, 1417916651, 1417920182, 1417933490, 1417933508, 1417940172, 1417951831, 1417989575, 1417990565, 1417994476, 1427005784, 1427013085, 1427016211, 1427028810, 1427029248, 1427033117, 1427035930, 1427040690, 1427044114, 1427048180, 1427051044, 1427051390, 1427062603, 1427138692, 1427206879, 1427229442, 1427229764, 1427283076, 1427337674, 1427346501, 1427363472, 1427370345, 1427371202, 1427373968, 1427389600, 1427477694, 1427478569, 1427502913, 1427503259, 1427509280, 1427519438, 1427553379, 1427554682, 1427566439, 1427583566, 1427609759, 1427612597, 1427647817, 1427662642, 1427673599, 1427710227, 1427820273, 1427939628, 1437107695, 1437129004, 1437134376, 1437145158, 1437159654, 1437214608, 1437242310, 1437254950, 1437299724, 1437300316, 1437349610, 1437415569, 1437444346, 1437473360, 1437474897, 1437479896, 1437508033, 1437530128, 1437539640, 1437540861, 1437561420, 1437563558, 1437619889, 1437630134, 1437631462, 1437641594, 1437667755, 1437667797, 1437671831, 1437686037, 1437687118, 1437712692, 1437716842, 1437719044, 1437754538, 1437792348, 1437800919, 1437900065, 1437986197, 1447006424, 1447063078, 1447202106, 1447209994, 1447227087, 1447241666, 1447248612, 1447259932, 1447264833, 1447266697, 1447269451, 1447272299, 1447275789, 1447280151, 1447295795, 1447357769, 1447364732, 1447389168, 1447393855, 1447410980, 1447416896, 1447440052, 1447457247, 1447464789, 1447474861, 1447536073, 1447547385, 1447567615, 1447610258, 1447672811, 1447691142, 1447699525, 1447750823, 1447757380, 1447759501, 1447781158, 1447797386, 1447807904, 1447864210, 1447874045, 1447959242, 1447964069, 1447987847, 1457079931, 1457190860, 1457310419, 1457319386, 1457339806, 1457341281, 1457344087, 1457352940, 1457359754, 1457395485, 1457398398, 1457419582, 1457509598, 1457514051, 1457550501, 1457559692, 1457646127, 1457653081, 1457694291, 1457706533, 1457826497, 1457829871, 1457856973, 1457864977, 1457870750, 1457873770, 1457911521, 1457912180, 1457916777, 1457932329, 1457934176, 1457942377, 1457943912, 1457979635, 1467018457, 1467022442, 1467051318, 1467061432, 1467113118, 1467136218, 1467171165, 1467410258, 1467421412, 1467422337, 1467436832, 1467438580, 1467442111, 1467443721, 1467450668, 1467455915, 1467457846, 1467458562, 1467467852, 1467493700, 1467524199, 1467599464, 1467660035, 1467679183, 1467688093, 1467713362, 1467729442, 1467729996, 1467809160, 1467863555, 1467885475, 1467893735, 1467905778, 1467933671, 1467958512, 1467964437, 1467972299, 1467976993, 1467982645, 1467996637, 1467997767, 1477057883, 1477066835, 1477079226, 1477084473, 1477098895, 1477099273, 1477116622, 1477124964, 1477133254, 1477171825, 1477190825, 1477322055, 1477391472, 1477504587, 1477505949, 1477527737, 1477538031, 1477622942, 1477629152, 1477636751, 1477701332, 1477714640, 1477715431, 1477722999, 1477759512, 1477783942, 1477790145, 1477798049, 1477814069, 1477843480, 1477846392, 1477865285, 1477872224, 1477890812, 1477905289, 1477913218, 1477964583, 1477982718, 1487016564, 1487021200, 1487035820, 1487041950, 1487042057, 1487093647, 1487104071, 1487131348, 1487162475, 1487204848, 1487205209, 1487207254, 1487223095, 1487240388, 1487256293, 1487277000, 1487289823, 1487307872, 1487337887, 1487621652, 1487632295, 1487644043, 1487656161, 1487657342, 1487658928, 1487661617, 1487664215, 1487679692, 1487685186, 1487720801, 1487750428, 1487753570, 1487755518, 1487760005, 1487832598, 1487858494, 1487861688, 1487862520, 1487944963, 1487960381, 1487994844, 1497038558, 1497120539, 1497124341, 1497182588, 1497185284, 1497189252, 1497203343, 1497232920, 1497259386, 1497264170, 1497268395, 1497269088, 1497272587, 1497286058, 1497308852, 1497334213, 1497348866, 1497383566, 1497415210, 1497477376, 1497501829, 1497520845, 1497707079, 1497709976, 1497732952, 1497735468, 1497742670, 1497771406, 1497782023, 1497782254, 1497788566, 1497853287, 1497855027, 1497879555, 1497889257, 1497922892, 1497937296, 1497964399, 1497971717, 1497981682, 1497987309, 1497992077, 1508048737, 1508152034, 1508199209, 1508220815, 1508240292, 1508246422, 1508314212, 1508334731, 1508346289, 1508373374, 1508391533, 1508397043, 1508414186, 1508462375, 1508469479, 1508498924, 1508504721, 1508528373, 1508534991, 1508645151, 1508648627, 1508651449, 1508806845, 1508809518, 1508822446, 1508831603, 1508850538, 1508861899, 1508870353, 1508872474, 1508881053, 1508911694, 1508943937, 1508971961, 1508992876, 1508993007, 1508997081, 1518007822, 1518030733, 1518036177, 1518043959, 1518069210, 1518072701, 1518101120, 1518105675, 1518113851, 1518150168, 1518225341, 1518316355, 1518344092, 1518345156, 1518378348, 1518408038, 1518432897, 1518432954, 1518440759, 1518441369, 1518480979, 1518490317, 1518495878, 1518499649, 1518512672, 1518546993, 1518555630, 1518598309, 1518692607, 1518904879, 1518907146, 1518908250, 1518926344, 1518928688, 1518947597, 1518948538, 1518956473, 1518962232, 1518962612, 1518965896, 1518996362, 1528010675, 1528038494, 1528044260, 1528058971, 1528061322, 1528084282, 1528110343, 1528124880, 1528144250, 1528157468, 1528176393, 1528185246, 1528251113, 1528355625, 1528355922, 1528357571, 1528401213, 1528405586, 1528411121, 1528419223, 1528419926, 1528425634, 1528431657, 1528441706, 1528487543, 1528505179, 1528549706, 1528554524, 1528555059, 1528578770, 1528623592, 1528651023, 1528664240, 1528671955, 1528712304, 1528721750, 1528789252, 1528837937, 1528839099, 1538108063, 1538132139, 1538145263, 1538146907, 1538164868, 1538199591, 1538214549, 1538295829, 1538314398, 1538321757, 1538322508, 1538329479, 1538339767, 1538347521, 1538369756, 1538484415, 1538511787, 1538514070, 1538600283, 1538621263, 1538637731, 1538643978, 1538653290, 1538659073, 1538675707, 1538677950, 1538684303, 1538685102, 1538723283, 1538775705, 1538798699, 1538861547, 1548200348, 1548243900, 1548244551, 1548248081, 1548256316, 1548267818, 1548267826, 1548272388, 1548286768, 1548293095, 1548310600, 1548346117, 1548410772, 1548449853, 1548517709, 1548578859, 1548588775, 1548622996, 1548641400, 1548646169, 1548655715, 1548657257, 1548676778, 1548684855, 1548693807, 1548700107, 1548720238, 1548770597, 1548784085, 1548791072, 1548799877, 1548808017, 1548816697, 1548816812, 1548831134, 1548837297, 1548901663, 1548909807, 1558005546, 1558032227, 1558132969, 1558153346, 1558320176, 1558336461, 1558357509, 1558361360, 1558424515, 1558426841, 1558460204, 1558499467, 1558524033, 1558531657, 1558549428, 1558557165, 1558565358, 1558605618, 1558636332, 1558650127, 1558666859, 1558727909, 1558739193, 1558746131, 1558747360, 1558780262, 1558799627, 1558808352, 1558824854, 1558844423, 1558865824, 1558866806, 1558890657, 1558896290, 1558921742, 1568013852, 1568018083, 1568049286, 1568091668, 1568123180, 1568133726, 1568167187, 1568402808, 1568417343, 1568453587, 1568462240, 1568462299, 1568469849, 1568478386, 1568480606, 1568497717, 1568514230, 1568518538, 1568546414, 1568648061, 1568670990, 1568709194, 1568721488, 1568740108, 1568744183, 1568779924, 1568793602, 1568799781, 1568811339, 1568817948, 1568831428, 1568878197, 1568881654, 1568887925, 1568895993, 1568916872, 1568919710, 1568930832, 1568932671, 1568942894, 1578033502, 1578077236, 1578095717, 1578097820, 1578161766, 1578170718, 1578200671, 1578227419, 1578271649, 1578302089, 1578334546, 1578504171, 1578507299, 1578516951, 1578530127, 1578544250, 1578562013, 1578563706, 1578609277, 1578616033, 1578677068, 1578682290, 1578701116, 1578721437, 1578722971, 1578741385, 1578746095, 1578787990, 1578791018, 1578805388, 1578826061, 1578896957, 1578907176, 1578937967, 1578940649, 1578941753, 1578960209, 1578969028, 1578969846, 1578974028, 1588032080, 1588053367, 1588055644, 1588055669, 1588079529, 1588097844, 1588104137, 1588110779, 1588153902, 1588168173, 1588173132, 1588182430, 1588186688, 1588207658, 1588238349, 1588300602, 1588321426, 1588406318, 1588434195, 1588442941, 1588605729, 1588607279, 1588616239, 1588669279, 1588669543, 1588678684, 1588689780, 1588698286, 1588699680, 1588741755, 1588746341, 1588762868, 1588816573, 1588865414, 1588868616, 1588877955, 1588907810, 1588910723, 1588913958, 1588927834, 1588928188, 1588951636, 1588984587, 1598003428, 1598020059, 1598044737, 1598057853, 1598063554, 1598095929, 1598114803, 1598141327, 1598149486, 1598163651, 1598187437, 1598187866, 1598203531, 1598239410, 1598241614, 1598249393, 1598269805, 1598276842, 1598278079, 1598286825, 1598296394, 1598296915, 1598296972, 1598299075, 1598320590, 1598329831, 1598332645, 1598334047, 1598345480, 1598348252, 1598384125, 1598390148, 1598422065, 1598426017, 1598470452, 1598521767, 1598715625, 1598716201, 1598741597, 1598761017, 1598761371, 1598772881, 1598778847, 1598780702, 1598781460, 1598784092, 1598861726, 1598876930, 1598895674, 1598927824, 1609025527, 1609064617, 1609147883, 1609172063, 1609262641, 1609296912, 1609303437, 1609317734, 1609348176, 1609392406, 1609419670, 1609441674, 1609453448, 1609517978, 1609525302, 1609538594, 1609597434, 1609639194, 1609657394, 1609866490, 1609875269, 1609890821, 1609893221, 1609895952, 1609978014, 1619010444, 1619056793, 1619080314, 1619138724, 1619211463, 1619233061, 1619233822, 1619257508, 1619316056, 1619320702, 1619380557, 1619404936, 1619450699, 1619459641, 1619496965, 1619521028, 1619591468, 1619634193, 1619646072, 1619738671, 1619784774, 1619798956, 1619900784, 1619939659, 1619945755, 1619946852, 1619963196, 1619967650, 1619974987, 1619976065, 1619986155, 1619991452, 1629006903, 1629018700, 1629018783, 1629022207, 1629047857, 1629054739, 1629066998, 1629067509, 1629097126, 1629147574, 1629160262, 1629165907, 1629186101, 1629199393, 1629203112, 1629236997, 1629239322, 1629243332, 1629246293, 1629290648, 1629297924, 1629309398, 1629322474, 1629337894, 1629341094, 1629344254, 1629380878, 1629387972, 1629395512, 1629405147, 1629430376, 1629484092, 1629544242, 1629559042, 1629559778, 1629627039, 1629648795, 1629677117, 1629723812, 1629726476, 1629728878, 1629751490, 1629782909, 1629783774, 1629798806, 1639100571, 1639110885, 1639118557, 1639130701, 1639135965, 1639140734, 1639154495, 1639154792, 1639156300, 1639182082, 1639221518, 1639231087, 1639238157, 1639245350, 1639326804, 1639380124, 1639411887, 1639426778, 1639432958, 1639433014, 1639439334, 1639507486, 1639529936, 1639549538, 1639559867, 1639563844, 1639577604, 1639584949, 1639623093, 1639664501, 1639666589, 1639677974, 1639685563, 1639727555, 1639749948, 1639775729, 1639790991, 1639837784, 1639948946, 1649039165, 1649041435, 1649046582, 1649069436, 1649084310, 1649092628, 1649212903, 1649223074, 1649229360, 1649240136, 1649240151, 1649246489, 1649302258, 1649305988, 1649323379, 1649332321, 1649345026, 1649377391, 1649404138, 1649460098, 1649465600, 1649469982, 1649488032, 1649490368, 1649516337, 1649519158, 1649530692, 1649556218, 1649587114, 1649625682, 1649628686, 1649629692, 1649631839, 1649673500, 1649690579, 1649699158, 1649707803, 1649739780, 1649784273, 1649792037, 1649821216, 1649821398, 1649853169, 1649909003, 1649909342, 1649937202, 1649988692, 1659021467, 1659102887, 1659190957, 1659334738, 1659336337, 1659339380, 1659359313, 1659367068, 1659371292, 1659374700, 1659383750, 1659405249, 1659424877, 1659458156, 1659464543, 1659507366, 1659535045, 1659535409, 1659565265, 1659569382, 1659593184, 1659610905, 1659616597, 1659617454, 1659629053, 1659638443, 1659638617, 1659683779, 1659703593, 1659721579, 1659726719, 1659735173, 1659744134, 1659749570, 1659766319, 1659794683, 1659795664, 1659807964, 1659876944, 1659882470, 1659887388, 1659928190, 1659947067, 1669015087, 1669052254, 1669081683, 1669124988, 1669137063, 1669410411, 1669433348, 1669440814, 1669456737, 1669461265, 1669467783, 1669475463, 1669483566, 1669486197, 1669632469, 1669650693, 1669651816, 1669694246, 1669714671, 1669739561, 1669761177, 1669792024, 1669797890, 1669838199, 1669844437, 1669863148, 1669911152, 1669920401, 1669952644, 1669962502, 1669963971, 1669972410, 1669974721, 1669985446, 1669987814, 1679002497, 1679038624, 1679050025, 1679060370, 1679066617, 1679068134, 1679079016, 1679080667, 1679096770, 1679100580, 1679159222, 1679226542, 1679260061, 1679292841, 1679345722, 1679519649, 1679538177, 1679591234, 1679593628, 1679604201, 1679636807, 1679646178, 1679664031, 1679676274, 1679695985, 1679725865, 1679765770, 1679787386, 1679895320, 1679907984, 1679920425, 1679921894, 1679927198, 1679927842, 1679933238, 1679936181, 1679973754, 1689022303, 1689033763, 1689061848, 1689075632, 1689083438, 1689084113, 1689129918, 1689162075, 1689194870, 1689203150, 1689207292, 1689243297, 1689246662, 1689248650, 1689252470, 1689259301, 1689295842, 1689350043, 1689604324, 1689606436, 1689611071, 1689630048, 1689630741, 1689646663, 1689663130, 1689674152, 1689676777, 1689677874, 1689732778, 1689751372, 1689762726, 1689780454, 1689781361, 1689789810, 1689808107, 1689823007, 1689880346, 1689926982, 1689941395, 1689956005, 1689960429, 1689976375, 1689992091, 1699020826, 1699025312, 1699031476, 1699045542, 1699099986, 1699160044, 1699170142, 1699206664, 1699224220, 1699243592, 1699257733, 1699264283, 1699283408, 1699320705, 1699382580, 1699445841, 1699472571, 1699487330, 1699704684, 1699714774, 1699717504, 1699759449, 1699761809, 1699772244, 1699781120, 1699789065, 1699791582, 1699792416, 1699806091, 1699845867, 1699854018, 1699861393, 1699866434, 1699877688, 1699936377, 1699982751, 1700020138, 1700050309, 1700154929, 1700177383, 1700200607, 1700229317, 1700233889, 1700234101, 1700239423, 1700248010, 1700260866, 1700279858, 1700306545, 1700307352, 1700307519, 1700319530, 1700345675, 1700349800, 1700359361, 1700382439, 1700412418, 1700413796, 1700414299, 1700422326, 1700440062, 1700443413, 1700447711, 1700466430, 1700521952, 1700569308, 1700639143, 1700639457, 1700813839, 1700849114, 1700865391, 1700875747, 1700881034, 1700886041, 1700954526, 1700966942, 1700977592, 1710005970, 1710088471, 1710117098, 1710124201, 1710144100, 1710144746, 1710150933, 1710152616, 1710173885, 1710187521, 1710191713, 1710261193, 1710273248, 1710305156, 1710313382, 1710331715, 1710383336, 1710409487, 1710433909, 1710457171, 1710557814, 1710579990, 1710658984, 1710677521, 1710735147, 1710900790, 1710915079, 1710937370, 1710941885, 1710949110, 1710971916, 1710973508, 1710974407, 1710978424, 1710981089, 1720027824, 1720039126, 1720042245, 1720062318, 1720087463, 1720088966, 1720106248, 1720116924, 1720117195, 1720179765, 1720198112, 1720231897, 1720236433, 1720238298, 1720241318, 1720308547, 1720325467, 1720330657, 1720382476, 1720390859, 1720425440, 1720438419, 1720453152, 1720453392, 1720467996, 1720473374, 1720479959, 1720493547, 1720541253, 1720541543, 1720552714, 1720560634, 1720566862, 1720608342, 1720613425, 1720618366, 1720620198, 1720646037, 1720656408, 1720682420, 1720690597, 1720699010, 1720750482, 1720763154, 1730101189, 1730105065, 1730128919, 1730156514, 1730156571, 1730162199, 1730187501, 1730193137, 1730216029, 1730218389, 1730225442, 1730234329, 1730278920, 1730314725, 1730337619, 1730365990, 1730369448, 1730376435, 1730410572, 1730416314, 1730421025, 1730437179, 1730445545, 1730460528, 1730492141, 1730503624, 1730535238, 1730537101, 1730538323, 1730540915, 1730542077, 1730581125, 1730595414, 1730603317, 1730609942, 1730623364, 1730624198, 1730638826, 1730649864, 1730683087, 1730699109, 1730735093, 1730741158, 1730837816, 1730857178, 1730890120, 1730994013, 1740205038, 1740222827, 1740252923, 1740253087, 1740257369, 1740258904, 1740276708, 1740277177, 1740282102, 1740347566, 1740353879, 1740383124, 1740389410, 1740442722, 1740446343, 1740464361, 1740539899, 1740553692, 1740574342, 1740611920, 1740620459, 1740622083, 1740633056, 1740633494, 1740636240, 1740647882, 1740660737, 1740683119, 1740743137, 1740767078, 1740772888, 1740779651, 1740784255, 1740827930, 1740861533, 1740870310, 1740886795, 1740940527, 1740947803, 1750053195, 1750058707, 1750058970, 1750069563, 1750315628, 1750336863, 1750337747, 1750341731, 1750350559, 1750364220, 1750379376, 1750383337, 1750469987, 1750472411, 1750509642, 1750562666, 1750573986, 1750586483, 1750614228, 1750615282, 1750623070, 1750631156, 1750644720, 1750664108, 1750750477, 1750777207, 1750785184, 1750794673, 1750803102, 1750811956, 1750824215, 1750828695, 1750844718, 1750854949, 1750863973, 1750905774, 1750908299, 1750944096, 1750982682, 1760017453, 1760070098, 1760126130, 1760411227, 1760430953, 1760434203, 1760468953, 1760481691, 1760485734, 1760487409, 1760499982, 1760530521, 1760576300, 1760577340, 1760592695, 1760598965, 1760633424, 1760641740, 1760743728, 1760775761, 1760832430, 1760851067, 1760881320, 1760888523, 1760903116, 1760925457, 1760936165, 1760937056, 1760970479, 1760973093, 1770002966, 1770017469, 1770028649, 1770029530, 1770052185, 1770054728, 1770070831, 1770077372, 1770083875, 1770133613, 1770214520, 1770254997, 1770276081, 1770299018, 1770337099, 1770337792, 1770374084, 1770394553, 1770510927, 1770533788, 1770548661, 1770567661, 1770570186, 1770571309, 1770571853, 1770576514, 1770577389, 1770577694, 1770579583, 1770583031, 1770583486, 1770585358, 1770595894, 1770628893, 1770665028, 1770697211, 1770725095, 1770734972, 1770738478, 1770739211, 1770744369, 1770762825, 1770780280, 1770812398, 1770825846, 1770835506, 1770846552, 1770848327, 1770869547, 1770895377, 1770936353, 1770974206, 1770995672, 1770996241, 1780004093, 1780041913, 1780047969, 1780068502, 1780079236, 1780086538, 1780139824, 1780182428, 1780229682, 1780263152, 1780272138, 1780286344, 1780291468, 1780299560, 1780317198, 1780390740, 1780600932, 1780611590, 1780612416, 1780624965, 1780664623, 1780669259, 1780671230, 1780673129, 1780694505, 1780727255, 1780766907, 1780792937, 1780808394, 1780826321, 1780855833, 1780871343, 1780886671, 1780889063, 1780917302, 1780926022, 1780926212, 1780926238, 1780939462, 1780941583, 1780941724, 1780972190, 1780978015, 1790013720, 1790062651, 1790142685, 1790147379, 1790165850, 1790171577, 1790203842, 1790206027, 1790219129, 1790225167, 1790225423, 1790225977, 1790259752, 1790290823, 1790313138, 1790326205, 1790329910, 1790446698, 1790450245, 1790520179, 1790556264, 1790709301, 1790721702, 1790728087, 1790741577, 1790746931, 1790754166, 1790766194, 1790827210, 1790828846, 1790836534, 1790946861, 1790949337, 1790975787, 1790984755, 1790990711, 1801024708, 1801059050, 1801102710, 1801155015, 1801190988, 1801195466, 1801304423, 1801321773, 1801328471, 1801353479, 1801361647, 1801384144, 1801397716, 1801446315, 1801448147, 1801580063, 1801599303, 1801629423, 1801815352, 1801826763, 1801836424, 1801843602, 1801848338, 1801852728, 1801885355, 1801889845, 1801895990, 1801896303, 1801900717, 1801908009, 1801945134, 1801980644, 1810341789, 1811060999, 1811064991, 1811069875, 1811106529, 1811141781, 1811141922, 1811144264, 1811166929, 1811191828, 1811242639, 1811288723, 1811303134, 1811315427, 1811336761, 1811368822, 1811392020, 1811399637, 1811403579, 1811424021, 1811456940, 1811476864, 1811520554, 1811582190, 1811585532, 1811633639, 1811670417, 1811718992, 1811759970, 1811923394, 1811937659, 1811947633, 1811952997, 1811961451, 1811967177, 1811967672, 1811976913, 1811983067, 1811984354, 1811993256, 1811995277, 1821020918, 1821034422, 1821037839, 1821061227, 1821061268, 1821076357, 1821078007, 1821080946, 1821087610, 1821091455, 1821094038, 1821109711, 1821123605, 1821152331, 1821159526, 1821191339, 1821214990, 1821219254, 1821249301, 1821255761, 1821259706, 1821267352, 1821325986, 1821436650, 1821439191, 1821470089, 1821533522, 1821536103, 1821542374, 1821595794, 1821595869, 1821632217, 1821642422, 1821646092, 1821655796, 1821664244, 1821665316, 1821736612, 1821893033, 1831108075, 1831110048, 1831114388, 1831120096, 1831139351, 1831151570, 1831154731, 1831175215, 1831181304, 1831184704, 1831240795, 1831243583, 1831262286, 1831293521, 1831304658, 1831353283, 1831367424, 1831381110, 1831415637, 1831441997, 1831460690, 1831504364, 1831512896, 1831523943, 1831524446, 1831565993, 1831610690, 1831619790, 1831625235, 1831640242, 1831647460, 1831654169, 1831667625, 1831684646, 1831698729, 1831739986, 1831771336, 1831798743, 1831840966, 1831869627, 1831889690, 1831967298, 1841201787, 1841213410, 1841250024, 1841256765, 1841265584, 1841268521, 1841276441, 1841278504, 1841288081, 1841289477, 1841289972, 1841292786, 1841296365, 1841306958, 1841351061, 1841371168, 1841420189, 1841424819, 1841435740, 1841450632, 1841493129, 1841530516, 1841537586, 1841545993, 1841553443, 1841593118, 1841642808, 1841679107, 1841682499, 1841739869, 1841741840, 1841773652, 1841780038, 1841781390, 1841799160, 1841849569, 1841906864, 1841950235, 1841960739, 1851016877, 1851025159, 1851087613, 1851120984, 1851329528, 1851334072, 1851341424, 1851351878, 1851369458, 1851384671, 1851385249, 1851386817, 1851402564, 1851506729, 1851508246, 1851513014, 1851529812, 1851573992, 1851609473, 1851617732, 1851631402, 1851632921, 1851640460, 1851682447, 1851685812, 1851705149, 1851733315, 1851739783, 1851740260, 1851746762, 1851754139, 1851797377, 1851810030, 1851816243, 1851823132, 1851840052, 1851871925, 1851875066, 1851903611, 1851943757, 1851952592, 1851956874, 1851961270, 1851984595, 1861022527, 1861029092, 1861072357, 1861161218, 1861444598, 1861449159, 1861460388, 1861467037, 1861525149, 1861565327, 1861621609, 1861672669, 1861692717, 1861697740, 1861708315, 1861744732, 1861763161, 1861781148, 1861797706, 1861846479, 1861851248, 1861858003, 1861886160, 1861893323, 1861914442, 1861939019, 1861944662, 1861951022, 1861994550, 1871007187, 1871017475, 1871033845, 1871035782, 1871060608, 1871096362, 1871121566, 1871124388, 1871139592, 1871178095, 1871248476, 1871290684, 1871325837, 1871501411, 1871514448, 1871524785, 1871541235, 1871557769, 1871563023, 1871567396, 1871571760, 1871583666, 1871608125, 1871669713, 1871676858, 1871757468, 1871800425, 1871822569, 1871871806, 1871871830, 1871893222, 1871934604, 1871951814, 1871954693, 1871959221, 1871977355, 1871986489, 1871997312, 1881002608, 1881022325, 1881022697, 1881028744, 1881040392, 1881053411, 1881056760, 1881088714, 1881102325, 1881125680, 1881125706, 1881128346, 1881157915, 1881161743, 1881175297, 1881187540, 1881190585, 1881192235, 1881230696, 1881231868, 1881256634, 1881333243, 1881336626, 1881337384, 1881361483, 1881473254, 1881670792, 1881681161, 1881688018, 1881693349, 1881699114, 1881720720, 1881763100, 1881765253, 1881771228, 1881791101, 1881828879, 1881863736, 1881870194, 1881885143, 1881924611, 1881950087, 1891019790, 1891048815, 1891055893, 1891081998, 1891102489, 1891106951, 1891108072, 1891115648, 1891139200, 1891232815, 1891243150, 1891259685, 1891263927, 1891271805, 1891277133, 1891289476, 1891299889, 1891311700, 1891322285, 1891324174, 1891338315, 1891350807, 1891388351, 1891442117, 1891564399, 1891762258, 1891765038, 1891766259, 1891773248, 1891775029, 1891784757, 1891799862, 1891808002, 1891808861, 1891863478, 1891882312, 1891913232, 1891929071, 1891935250, 1891938718, 1891975975, 1891978532, 1891982641, 1891995718, 1902023278, 1902048499, 1902160278, 1902160971, 1902169543, 1902188113, 1902225071, 1902227184, 1902247075, 1902292907, 1902315260, 1902315997, 1902323728, 1902350176, 1902350275, 1902377880, 1902377930, 1902399215, 1902407927, 1902418411, 1902474992, 1902483837, 1902529852, 1902545049, 1902573959, 1902585276, 1902637739, 1902663859, 1902669328, 1902831688, 1902831779, 1902832108, 1902844491, 1902852775, 1902858780, 1902882095, 1902883416, 1902885502, 1902892789, 1902957251, 1912013061, 1912043514, 1912045527, 1912072646, 1912098757, 1912142365, 1912192535, 1912199720, 1912206020, 1912212135, 1912216011, 1912263575, 1912268269, 1912271321, 1912276866, 1912292103, 1912294802, 1912307091, 1912308024, 1912335498, 1912362138, 1912370545, 1912419383, 1912428368, 1912428475, 1912429564, 1912435207, 1912439019, 1912444183, 1912451287, 1912508516, 1912535766, 1912538240, 1912603416, 1912716630, 1912729542, 1912738105, 1912941089, 1912955758, 1912968603, 1912997792, 1912998709, 1922004704, 1922023670, 1922035922, 1922039551, 1922041144, 1922043298, 1922062751, 1922094325, 1922150713, 1922151943, 1922164771, 1922235498, 1922236017, 1922246966, 1922252345, 1922258060, 1922318815, 1922333558, 1922348382, 1922388578, 1922410141, 1922415264, 1922449859, 1922461102, 1922462258, 1922476332, 1922512896, 1922527449, 1922533009, 1922539048, 1922561695, 1922568765, 1922568930, 1922585256, 1922590264, 1922607357, 1922655844, 1922667740, 1922669993, 1922697234, 1922704485, 1922710607, 1922738046, 1922741008, 1922843101, 1922883909, 1932103280, 1932118635, 1932122645, 1932125309, 1932130242, 1932155330, 1932175858, 1932187515, 1932194966, 1932209871, 1932260973, 1932275005, 1932281904, 1932306073, 1932336518, 1932352622, 1932361383, 1932414364, 1932443199, 1932449121, 1932454071, 1932464070, 1932501566, 1932515251, 1932528882, 1932543444, 1932554078, 1932555430, 1932570140, 1932577012, 1932586849, 1932602976, 1932609328, 1932613130, 1932614633, 1932664752, 1932667904, 1932713559, 1932726106, 1932787538, 1932865144, 1932866795, 1932920220, 1932949088, 1932964467, 1942035175, 1942072970, 1942203377, 1942242813, 1942261243, 1942265426, 1942266648, 1942384375, 1942405907, 1942410527, 1942421672, 1942422449, 1942507975, 1942526546, 1942543699, 1942545470, 1942560263, 1942561394, 1942594825, 1942627898, 1942628748, 1942635396, 1942638408, 1942716170, 1942716287, 1942721741, 1942743828, 1942760491, 1942765953, 1942823018, 1942826086, 1942854872, 1942910880, 1942913017, 1942949136, 1942966106, 1942966619, 1942972393, 1952006553, 1952036923, 1952041394, 1952043929, 1952163982, 1952296147, 1952307399, 1952333171, 1952334179, 1952339285, 1952393480, 1952407702, 1952426736, 1952442469, 1952487860, 1952545741, 1952566788, 1952605297, 1952690810, 1952695330, 1952716789, 1952718843, 1952722316, 1952750465, 1952763997, 1952827693, 1952888422, 1952899155, 1952917494, 1952928525, 1952950438, 1952991242, 1962003657, 1962040394, 1962043471, 1962058966, 1962064303, 1962074252, 1962142661, 1962186957, 1962426742, 1962430140, 1962465575, 1962468165, 1962471458, 1962475681, 1962483941, 1962484758, 1962505933, 1962608125, 1962715193, 1962733006, 1962743625, 1962753186, 1962764084, 1962767509, 1962771576, 1962795963, 1962824029, 1962825075, 1962848218, 1962860346, 1962866434, 1962900951, 1962911412, 1962920876, 1962923805, 1962971044, 1972042463, 1972043602, 1972049203, 1972052306, 1972066801, 1972091064, 1972123222, 1972184901, 1972220994, 1972229474, 1972310712, 1972311777, 1972356491, 1972504629, 1972512440, 1972527547, 1972532810, 1972560084, 1972560662, 1972590834, 1972609550, 1972613487, 1972656254, 1972687432, 1972690485, 1972705960, 1972711851, 1972719318, 1972722494, 1972738359, 1972827384, 1972846517, 1972879070, 1972889129, 1972890721, 1972918779, 1972940195, 1972952430, 1982009288, 1982011227, 1982027033, 1982028411, 1982047924, 1982072054, 1982085247, 1982101879, 1982124244, 1982135414, 1982144408, 1982148730, 1982166443, 1982168944, 1982202768, 1982204442, 1982220703, 1982239034, 1982247417, 1982256848, 1982257044, 1982329967, 1982393443, 1982601225, 1982653432, 1982660437, 1982680427, 1982680567, 1982716148, 1982717302, 1982718128, 1982747416, 1982781563, 1982818753, 1982823290, 1982911962, 1982977724, 1982978144, 1992015994, 1992075733, 1992086102, 1992103345, 1992121958, 1992141139, 1992202246, 1992209019, 1992213870, 1992229264, 1992232839, 1992234488, 1992278600, 1992339089, 1992355481, 1992368245, 1992394035, 1992466056, 1992700520, 1992705222, 1992706121, 1992735583, 1992740088, 1992772404, 1992773501, 1992781439, 1992796775, 1992800361, 1992809057, 1992811665, 1992826440, 1992871990, 1992949358, 1992963227, 1992964266, 1992965370, 1992975098, 1992996359

unique_codes_total 14838
duplicate_codes 14699
duplicate_pct 99.06
by_code_type
CSTM-ALL 396
HCPCS 14395
RC 47
unknown_code_types
format_invalid_by_type
HCPCS 2126440
codes_not_in_reference reference_not_loaded
most_frequent_codes
Type Code Occurrences
HCPCS E0950 1,260
HCPCS E0951 1,260
HCPCS E0952 1,260
HCPCS E0953 1,260
HCPCS E0954 1,260
HCPCS E0956 1,260
HCPCS E0957 1,260
HCPCS E0960 1,260
HCPCS E0973 1,260
HCPCS E0978 1,260
HCPCS E0981 1,260
HCPCS E0982 1,260
HCPCS E0990 1,260
HCPCS E0995 1,260
HCPCS E1016 1,260
HCPCS E2208 1,260
HCPCS E2209 1,260
HCPCS E2210 1,260
HCPCS E2323 1,260
HCPCS E2324 1,260

total_prices_checked 2867476
total_rates 2866991
per_diem_rates 0
percentage_rates 485
negative_rates 0
zero_rates 71337
extreme_high_rates 2504
extreme_low_rates 628
rate_distribution
sample_n 2866991
sample_k 5000
confidence high
p5 3.61195
p25 50.7569625
p50 246.92
p75 983.267775
p95 4880.9407
p99 14216.611499999999
by_billing_class
Class / Type Count Median p25 p75 p95 Confidence
institutional/fee schedule 893,592 507.3 88.1 2148.7 11894.5 high
professional/fee schedule 1,973,393 208.6 39.9 733.7 2467.2 high
institutional/derived 3 1.0 1.0 1.0 1.0 low
professional/derived 3 1.0 1.0 1.0 1.0 low
negotiated_types
fee schedule 2866985
derived 6
unique_rate_contexts 34141
rate_key_dimension_validity
invalid_negotiated_type 0
invalid_negotiated_types_seen {}
invalid_setting 0
invalid_settings_seen {}
invalid_severity_of_illness 0
severity_on_non_apr_drg 0
institutional_with_service_codes 0
invalid_service_code_format 0
billing_code_modifier_too_long 0
Scoring Methodology embedded in this report at generation time

Weighted sum of four structural dimensions, normalized to a 0–100 scale.

Normalized Weights
Schema Integrity 30%
Provider Mapping 15%
Code Coverage 15%
Pricing Sanity 40%
Confidence Bands
High ≥90
Usable With Caution ≥75
Limited Reliability ≥60
Not Usable <60
Score Caps
ConditionCapReason
Raw Json Errors Only 74.0 Native JSON syntax errors in the unpatched source file. File must be re-exported by the payer; scoring reflects auto-patched data only.
Cms Validation Failure Only 65.0 CMS official schema validator reports the file does not conform to the TIC spec.
Both Raw Json Errors And Cms Failure 59.0 Both native JSON syntax errors and CMS schema validation failure present.
Rate Context Key — 14-Tuple Field Coverage

Every rate in a CMS TIC MRF file is described by a 14-field tuple. Fields 1–10 form the rate-context key used to group and compare rates across the system. Fields 11–12 (provider, expiration date) are validated separately and excluded from the grouping key for analytical reasons. Each of the four scoring dimensions validates a distinct slice of this tuple — together they cover all 14 fields.

FieldValidated by
1 billing_code_type Schema (required field) + Code Coverage (enum + format validation)
2 billing_code_type_version Schema (required field)
3 billing_code Schema (required field) + Code Coverage (format, duplicates, reference lookup)
4 billing_code_modifier Pricing (modifier length, key normalization)
5 service_code Pricing (POS format, normalization, institutional-class check)
6 negotiated_type Pricing (CMS TIC enum validation)
7 billing_class Schema (CMS TIC enum validation) + Pricing (spread thresholds)
8 negotiation_arrangement Schema (CMS TIC enum validation) + Pricing (FFS vs bundle/capitation gating)
9 severity_of_illness Pricing (APR-DRG only, valid values 1–4)
10 setting Pricing (CMS TIC enum validation)
11 provider (NPI/EIN) Provider Mapping (Luhn checksum, IRS prefix, group resolution) — excluded from grouping key
12 expiration_date Schema (date validity, far-future sanity) — excluded from grouping key
13 additional_generic_notes not validated (free-text)
14 negotiated_rate Pricing (negative/zero/extreme-value checks, spread analysis)
  • Fields 1–10 are the grouping key. Each unique combination is a distinct rate context — rates with different modifiers, POS codes, or arrangements land in separate buckets and are never compared against each other.
  • Provider (field 11) is excluded from the key: the spread check is cross-provider by design. Partitioning by provider produces singleton buckets and eliminates the spread signal.
  • Expiration date (field 12) is excluded because it is a contract lifecycle attribute, not a clinical context. Rates for the same service should be comparable regardless of when they expire.
  • service_code (field 5) arrays are flattened and normalized before keying: '1' → '01', and a rate with ['11','22'] contributes to both the '11' and '22' buckets so rates are compared apples-to-apples by place of service.

Validates required fields, enum values, conditional requirements, and date validity per the CMS TIC in-network-rates schema. Also checks file freshness and expiration date sanity.

Scoring Method
Penalty-based deductions from 100, capped per category.
Penalty / ComponentFormula
per_missing_required_header_field 5
per_header_conditional_issue 2
freshness_warn 5
freshness_error 10
item_missing_fields_pct ×5 (cap 30)
empty_rates_pct ×0.5 (cap 5)
price_missing_fields_pct ×10 (cap 30)
rates_without_providers_rate ×200 (cap 20)
expired_prices_pct ×0.5 (cap 5)
Thresholds
file freshness warn days 45
file freshness error days 90
expiry far future years 3

Verifies that all provider_group_id references in in_network items resolve to an entry in the provider_references array. Validates NPI integrity via Luhn checksum and EIN integrity via IRS-issued 2-digit prefix.

Scoring Method
Weighted component sum (not purely penalty-based).
ComponentFormula
provider_resolution (60%) resolution_rate% × 0.60
npi_validity (30%) (100 − invalid_npi_pct × 5) × 0.30
ein_validity (10%) 10 − (invalid_ein_pct × 0.1) [0% invalid → 10 pts, 100% invalid → 0 pts, linear]
Checks
provider_group_resolution Ratio of provider_group_id references that resolve to a known provider group. Unresolved references mean rates cannot be attributed to any provider.
npi_validity Luhn checksum applied to every NPI value in the file.
ein_validity IRS-issued 2-digit prefix validation on EIN values.
empty_npi_groups Provider groups with an empty npi list.
missing_tin Provider groups with no TIN (type + value pair).
duplicate_npis Informational: NPIs appearing in more than one provider group.

Tracks every (billing_code_type, billing_code) pair and flags unrecognized CMS TIC code types, format violations for CPT/HCPCS/NDC, and duplicates (same code appearing in multiple in_network items).

Scoring Method
Penalty-based deductions from 100.
Penalty / ComponentFormula
per_unknown_code_type 3 pts each (cap 20)
format_invalid_pct × 0.5 (cap 10)
duplicate_code_pct × 2 (cap 20)
codes_not_in_reference_pct × 0.5 (cap 30) — only when reference set is loaded
Recognized Code Types
AP-DRG, APC, APR-DRG, APS-DRG, CDT, CPT, CSTM-ALL, EAPG, HCPCS, HIPPS, ICD, LOCAL, MS-DRG, NDC, R-DRG, RC, S-DRG

Detects invalid rates (negative, zero, extreme-value) and distribution anomalies (per-class P95/P50 spread, per-code max/min ratio, flat-rate distributions). Exact counts are used for all validity checks (negative, zero, extreme, dimension validity). Percentile-based checks (spread, IQR) use reservoir sampling — k=5 000 global, k=1 000 per (billing_class, negotiated_type) bucket — so memory stays bounded on large files. Per-code max/min spread is exact (all rates seen, no sampling).

Scoring Method
Penalty-based deductions from 100.
Penalty / ComponentFormula
negative_rate_pct × 5 (cap 20)
zero_rate_pct × 3 (cap 15)
extreme_rate_pct × 5 (cap 25) — ffs only
class_spread_excess (spread − threshold) × 2, max across (billing_class, negotiated_type) buckets (cap 15)
per_code_high_spread_count × 0.1 (cap 15)
invalid_negotiated_type_pct × 3 (cap 10) — rates silently dropped
invalid_setting_pct × 1 (cap 5) — silently defaults to wildcard
invalid_severity_pct × 1 (cap 5) — silently normalised to ''
institutional_with_service_codes_pct × 1 (cap 5) — extra key variation
invalid_service_code_pct × 2 (cap 5) — encode raises ValueError
Thresholds
extreme high by billing class professional: 25000.0institutional: 2000000.0both: 2000000.0default: 500000.0
extreme low 0.01
spread warn p95 over p50 by class professional: 5institutional: 10both: 10default: 5
per rate context max min ratio professional_codes: 20facility_drg_codes: 50
flat rate iqr p75 threshold pct 5.0
flat rate min rates to check 100
spread min n to flag 50
per code min n to flag 3
Notes
  • per diem and percentage rates are not dollar amounts and are excluded from all spread and distribution analysis.
  • Zero rates are treated as errors per CMS schema (exclusiveMinimum: 0).
  • Extreme-value flags (negative, zero, extreme high/low) are only applied to ffs negotiation_arrangement rates — bundle and capitation rates have different magnitude ranges and lack calibrated thresholds.
  • P95/P50 spread and flat-rate IQR checks are keyed by (billing_class, negotiated_type) so fee schedule and negotiated distributions are evaluated independently.
  • flat_rate_distribution is suppressed for negotiated_type='fee schedule' buckets — a flat distribution is correct behaviour for a fee schedule, not a defect.

The dashboard assigns a persistent mrf_key to each MRF. All validation runs of the same MRF share the same key so the score-history chart reflects how a file has changed over time — even if the payer re-exports it at a new URL. This key is not stored in the report JSON; it is computed at ingest time.

Key derivation (priority order)
TierWhen usedInput string
1 Both reporting_entity_name and plan_id present plan|<entity>|<plan_id_type>|<plan_id>
2 plan_id absent — falls back to URL (entity name alone is not safe: a payer publishes multiple distinct plans under the same entity) <file_location URL>

The key is a 16-character MD5 hex digest of the input string (case-insensitive, whitespace-stripped). Tier 1 is stable across monthly file re-exports because the plan identity in the MRF header does not change when the payer fixes a bug and re-publishes. Tier 3 is URL-dependent and will produce a new key if the file path changes.

This run:
mrf_keyc254098866036231
EntityQuality Care Partners
Plan nameQuality Care Partners
Plan ID311435470 (hios)
Key tier Tier 1 entity + plan_id

Geographic analysis is a supplemental feature computed on demand after scoring completes. It does not affect any scoring dimension — it is an observational overlay to help assess the breadth and distribution of in-network providers.

Data Sources
NPPES CMS National Plan and Provider Enumeration System — monthly full-replacement CSV. Maps each NPI to its primary registered ZIP code.
ZCTA centroids GeoNames US postal code file. Maps each 5-digit ZIP to a (latitude, longitude) centroid for map placement.
Process
  1. Extract all NPIs from the MRF file (npi and npi_numbers fields).
  2. Resolve each NPI to its primary practice ZIP via NPPES lookup.
  3. Aggregate provider count per ZIP code.
  4. Map each ZIP to a (lat, lon) centroid via ZCTA table.
  5. Render as a weighted heatmap — intensity proportional to provider count per ZIP.
Limitations
  • NPIs not found in NPPES (recently issued, test NPIs, EINs used as NPIs) are excluded from the map and reduce the geocoding match rate.
  • Location reflects the provider's NPPES-registered primary address, not necessarily where they accept this specific plan.
  • Map viewport auto-fits to the bounding box of ZIP codes covering 90% of total provider count, dropping sparse geographic outliers.