Back to MRF Run #31
Export PDF

Quality Care Partners

s3://talon-storage-private/mrf-feed-uploads/2026-02/2026-02-05_QCP_in-network-rates.json.gz
File date: 2/4/2026 Run: 2026-04-24 12:37 EDT v1.0.0
75.7
Usable w/ Caution
Generated At
2026-04-24 12:37 EDT
Elapsed
445.10s
Tool Version
1.0.0
Parse Errors / Crashes
0 / 0
File (raw compressed)
Size:  62.39 MB (65,421,374 bytes)
MD5:  aa30b4b66d382f89e99399c7c3d16d77
TOC Source
talon-storage-private/mrf-feed-uploads/2026-02/2026-02_plan_ref_98d7022b7d7165738b14c89261e12b3b_index.json
Talon
Canonical: s3://talon-storage-private/mrf-feed-uploads/2026-02/2026-02-05_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
82.7
Provider Mapping
99.9
Code Coverage
70.0
Pricing Sanity
63.5
Provider Geographic Coverage Loading…
Analysing provider locations…
Errors (1)
zero_rates
78250 zero-dollar rates (2.00%) — CMS schema requires negotiated_rate > 0 (exclusiveMinimum)
Warnings (11)
header_conditional
last_updated_on '2/4/2026' is not a valid YYYY-MM-DD date
header_conditional
Partial plan fields present — missing: ['plan_market_type']
rates_without_providers
259882 negotiated_rate entries have neither provider_groups nor provider_references
npi_validity
0.02% of NPIs failed Luhn checksum validation (1 of 4445)
  • 1588679012
ein_validity
0.32% of EINs failed IRS prefix validation (15 of 4704)
  • 281723399
  • 282504837
  • 282884410
  • 286429330
  • 287641240
  • … and 5 more
empty_npi_groups
259 provider groups contain no NPIs
billing_code_format
146876 HCPCS codes do not match expected format
duplicate_billing_codes
14826 billing codes appear in more than one in_network item (99.2%)
rate_spread_by_class
billing_class='institutional' / negotiated_type='fee schedule': P95/P50 spread is 30.5x (threshold: 10x, N=1,727,709 (1,000 sampled), high confidence)
rate_spread_by_class
billing_class='professional' / negotiated_type='fee schedule': P95/P50 spread is 14.6x (threshold: 5x, N=2,191,896 (1,000 sampled), high confidence)
per_code_rate_spread
1376 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
A4459 HCPCS fee schedule professional ffs — $0.05 $184.48 $179.28 $240.63 4812.6× 110
Q0249 HCPCS fee schedule institutional ffs — $7.57 $16.27 $4702.79 $14129.80 1866.8× 183
92953 CPT fee schedule institutional ffs — $0.83 $1.70 $388.25 $1446.07 1742.3× 129
Q0249 HCPCS fee schedule professional ffs — $7.57 $6572.00 $3584.40 $11829.60 1562.9× 230
95004 CPT fee schedule institutional ffs — $3.48 $7.13 $507.69 $1878.84 539.9× 129
95044 CPT fee schedule institutional ffs — $4.80 $9.84 $509.47 $1878.84 391.4× 129
33289 CPT fee schedule institutional ffs — $261.77 $536.63 $17153.93 $62756.18 239.7× 129
63685 CPT fee schedule institutional ffs — $298.15 $611.21 $18476.60 $67513.42 226.4× 129
33287 CPT fee schedule institutional ffs — $315.56 $646.90 $18500.10 $67513.42 213.9× 129
33231 CPT fee schedule institutional ffs — $327.65 $671.68 $18827.54 $68675.56 209.6× 129
Info (3)
far_future_expiration
3920117 expiration_dates are more than 3 years in the future
duplicate_npis
313 NPIs appear in more than one provider group
percentage_rates
506 percentage rates (0.0%) — values represent % of a reference rate, not dollar amounts; excluded from spread analysis
Recommended Actions
  1. 1.
    pricing zero_rates
    78250 zero-dollar rates (2.00%) — CMS schema requires negotiated_rate > 0 (exclusiveMinimum)
    P1
  2. 2.
    provider_mapping npi_validity
    0.02% of NPIs failed Luhn checksum validation (1 of 4445)
    P2
  3. 3.
    provider_mapping ein_validity
    0.32% of EINs failed IRS prefix validation (15 of 4704)
    P2
  4. 4.
    provider_mapping empty_npi_groups
    259 provider groups contain no NPIs
    P2
  5. 5.
    pricing rate_spread_by_class
    billing_class='institutional' / negotiated_type='fee schedule': P95/P50 spread is 30.5x (threshold: 10x, N=1,727,709 (1,000 sampled), high confidence)
    P2
  6. 6.
    pricing rate_spread_by_class
    billing_class='professional' / negotiated_type='fee schedule': P95/P50 spread is 14.6x (threshold: 5x, N=2,191,896 (1,000 sampled), high confidence)
    P2
  7. 7.
    pricing per_code_rate_spread
    1376 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 '2/4/2026' 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
    259882 negotiated_rate entries have neither provider_groups nor provider_references
    P2
  11. 11.
    code_coverage billing_code_format
    146876 HCPCS codes do not match expected format
    P3
  12. 12.
    code_coverage duplicate_billing_codes
    14826 billing codes appear in more than one in_network item (99.2%)
    P3
Metrics

header_missing_fields
header_conditional_issues last_updated_on '2/4/2026' is not a valid YYYY-MM-DD date, Partial plan fields present — missing: ['plan_market_type']
file_age_days None
items_total 3917855
items_missing_required_pct 0.0
items_empty_rates 0
prices_total 3920117
prices_missing_required_pct 0.0
prices_missing_field_breakdown
prices_missing_service_code 0
prices_invalid_billing_class 0
rates_without_providers 259882
negotiation_arrangements
ffs 3917855
billing_code_types
HCPCS 1214895
CSTM-ALL 114
CPT 2702574
RC 272
expired_prices 0
invalid_expiration_format 0

provider_references_in_file 4704
provider_group_ids_referenced 4704
unresolved_references 0
resolution_rate_pct 100.0
npis_validated 4445
invalid_npi_count 1
npi_validity_rate_pct 99.98
invalid_npi_examples 1588679012
eins_validated 4704
invalid_ein_count 15
ein_validity_rate_pct 99.68
invalid_ein_examples 281723399, 282504837, 282884410, 286429330, 287641240, 287743571, 287841552, 287924612, 290823786, 292667201
empty_npi_groups 259
groups_without_tin 0
npis_in_multiple_groups 313
unique_npis 1003034281, 1003037987, 1003081449, 1003105529, 1003121393, 1003163759, 1003220617, 1003225327, 1003268095, 1003295270, 1003296302, 1003297383, 1003300641, 1003325150, 1003389081, 1003398223, 1003480815, 1003508250, 1003693417, 1003704529, 1003801689, 1003803388, 1003811472, 1003814302, 1003826074, 1003828849, 1003851213, 1003857608, 1003888090, 1003891938, 1003894452, 1003898156, 1003906421, 1003926486, 1003946724, 1013028307, 1013032572, 1013033737, 1013075878, 1013087535, 1013088228, 1013108315, 1013165174, 1013167220, 1013175843, 1013204908, 1013235316, 1013268671, 1013270768, 1013405190, 1013420157, 1013430446, 1013453075, 1013456128, 1013474097, 1013483916, 1013503465, 1013547496, 1013588086, 1013708239, 1013764059, 1013794684, 1013906023, 1013912799, 1013917426, 1013934710, 1013956945, 1013959410, 1013974203, 1013993716, 1013997519, 1013999259, 1023002011, 1023013471, 1023013505, 1023017498, 1023022035, 1023032141, 1023040953, 1023042660, 1023060928, 1023062700, 1023066594, 1023078755, 1023080298, 1023111598, 1023113727, 1023115375, 1023168853, 1023196144, 1023214673, 1023319068, 1023329737, 1023344264, 1023413119, 1023432093, 1023462876, 1023469889, 1023476785, 1023493053, 1023520327, 1023540556, 1023541638, 1023544749, 1023594132, 1023654035, 1023695327, 1023731890, 1023787769, 1023793684, 1023818994, 1023882966, 1023985660, 1023994035, 1033141155, 1033178231, 1033183645, 1033190178, 1033213137, 1033230883, 1033231188, 1033323969, 1033372123, 1033405139, 1033418140, 1033422324, 1033456439, 1033466008, 1033484548, 1033485883, 1033494794, 1033537584, 1033585856, 1033589973, 1033613500, 1033646088, 1033657168, 1033675970, 1033682430, 1033691241, 1033701131, 1033740824, 1033760236, 1033766241, 1033771720, 1033787031, 1033837091, 1033990478, 1043200249, 1043201791, 1043207665, 1043210727, 1043216260, 1043219975, 1043228414, 1043268253, 1043272032, 1043284698, 1043299274, 1043348410, 1043350739, 1043404932, 1043464183, 1043508484, 1043536261, 1043536857, 1043571029, 1043573876, 1043607054, 1043661200, 1043675770, 1043686124, 1043688682, 1043695810, 1043843550, 1043887128, 1043932304, 1043974595, 1043988363, 1053004630, 1053041822, 1053052860, 1053154633, 1053165936, 1053182527, 1053191544, 1053191684, 1053197699, 1053312132, 1053312462, 1053345462, 1053347591, 1053347856, 1053376764, 1053392555, 1053425637, 1053430850, 1053441725, 1053475640, 1053512822, 1053527523, 1053553602, 1053560433, 1053575365, 1053620591, 1053635086, 1053644179, 1053661025, 1053678466, 1053687525, 1053741702, 1053747311, 1053750331, 1053751107, 1053761890, 1053775395, 1053792424, 1053792515, 1053815167, 1053818336, 1053860452, 1053880948, 1053892299, 1053931048, 1053940981, 1053951046, 1053982918, 1063003176, 1063040434, 1063043685, 1063047249, 1063070738, 1063114874, 1063168268, 1063177244, 1063249431, 1063284800, 1063400067, 1063404572, 1063407765, 1063411155, 1063411486, 1063440741, 1063456234, 1063460525, 1063465706, 1063489425, 1063498061, 1063514743, 1063518298, 1063556074, 1063569879, 1063573160, 1063580199, 1063593044, 1063638070, 1063640969, 1063643997, 1063649879, 1063681393, 1063705754, 1063721389, 1063755122, 1063757565, 1063772291, 1063788479, 1063807238, 1063815462, 1063817310, 1063861524, 1063903912, 1063921104, 1063927259, 1063977122, 1073006920, 1073016887, 1073029732, 1073036190, 1073077020, 1073085023, 1073085627, 1073092607, 1073096913, 1073106704, 1073140885, 1073153508, 1073245536, 1073316170, 1073505681, 1073511358, 1073513487, 1073516373, 1073518940, 1073545844, 1073565917, 1073599031, 1073599197, 1073599262, 1073599981, 1073600979, 1073613808, 1073697272, 1073712642, 1073756284, 1073766150, 1073770368, 1073788659, 1073836441, 1073869277, 1073902185, 1073952446, 1083021166, 1083022677, 1083031116, 1083043616, 1083059273, 1083060172, 1083102958, 1083150478, 1083153423, 1083165088, 1083172324, 1083180590, 1083193510, 1083216477, 1083218531, 1083226922, 1083241608, 1083265938, 1083273346, 1083335707, 1083357990, 1083434732, 1083597454, 1083613806, 1083634927, 1083648562, 1083655088, 1083662951, 1083664882, 1083671473, 1083681126, 1083686075, 1083694723, 1083696645, 1083705271, 1083725246, 1083734438, 1083795850, 1083797336, 1083816953, 1083828677, 1083836043, 1083847404, 1083856041, 1083867832, 1083955280, 1093008344, 1093087611, 1093131922, 1093132631, 1093173924, 1093191124, 1093216095, 1093239071, 1093243420, 1093244816, 1093247348, 1093267635, 1093281347, 1093285629, 1093298077, 1093304511, 1093343915, 1093345076, 1093481640, 1093556102, 1093569006, 1093726309, 1093763823, 1093770745, 1093771081, 1093791212, 1093863532, 1093908840, 1093921355, 1093966962, 1104081371, 1104111699, 1104147669, 1104175017, 1104231778, 1104261411, 1104357474, 1104364884, 1104427673, 1104454313, 1104499003, 1104530914, 1104563709, 1104801166, 1104804632, 1104808344, 1104816321, 1104821420, 1104822741, 1104825116, 1104842061, 1104845924, 1104895036, 1104913508, 1104928415, 1114013463, 1114025830, 1114063740, 1114076148, 1114125176, 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, 1114710522, 1114788387, 1114793486, 1114905890, 1114909744, 1114918042, 1114920485, 1114922440, 1114922515, 1114987914, 1114995602, 1124008131, 1124008792, 1124040951, 1124043625, 1124069737, 1124086251, 1124088737, 1124095740, 1124095906, 1124116447, 1124164744, 1124172135, 1124189592, 1124195441, 1124224100, 1124231824, 1124259247, 1124261359, 1124272976, 1124282199, 1124348842, 1124372628, 1124439039, 1124470935, 1124472519, 1124478771, 1124520317, 1124523105, 1124523865, 1124530126, 1124547435, 1124551809, 1124552443, 1124568316, 1124568795, 1124570239, 1124584677, 1124588512, 1124588546, 1124626718, 1124719455, 1124719794, 1124733753, 1124746326, 1124807235, 1124837893, 1124866694, 1124894779, 1134114374, 1134115173, 1134119092, 1134124183, 1134126139, 1134131329, 1134136526, 1134162563, 1134173339, 1134190739, 1134198898, 1134201940, 1134216252, 1134361371, 1134384977, 1134407133, 1134421035, 1134422934, 1134433931, 1134497209, 1134502602, 1134503899, 1134520877, 1134569478, 1134623200, 1134650294, 1134680424, 1134683394, 1134760028, 1134765878, 1134767551, 1134952302, 1134980113, 1144003062, 1144075375, 1144210055, 1144216425, 1144218025, 1144218074, 1144226598, 1144228131, 1144230731, 1144239096, 1144239765, 1144246034, 1144260043, 1144270497, 1144296062, 1144303843, 1144317009, 1144364076, 1144412784, 1144464769, 1144511791, 1144511833, 1144530759, 1144534322, 1144539362, 1144553199, 1144580085, 1144583261, 1144610296, 1144630047, 1144642489, 1144674185, 1144674854, 1144681487, 1144691387, 1144696360, 1144701574, 1144706821, 1144717265, 1144749839, 1144759770, 1144779604, 1144793902, 1144801390, 1144804931, 1144809476, 1144850058, 1144853649, 1144878810, 1144881772, 1144960717, 1144997420, 1154071264, 1154307858, 1154316909, 1154330157, 1154373009, 1154384154, 1154416659, 1154423580, 1154436665, 1154450658, 1154531952, 1154600534, 1154647899, 1154664167, 1154725844, 1154734788, 1154747855, 1154748267, 1154753895, 1154791036, 1154793164, 1154817294, 1154818029, 1154829687, 1154836203, 1154843043, 1154844280, 1154876845, 1154925964, 1154961696, 1164026258, 1164042289, 1164053419, 1164054987, 1164097374, 1164159323, 1164290243, 1164425526, 1164432001, 1164432613, 1164457198, 1164463451, 1164520516, 1164597910, 1164620290, 1164641759, 1164676854, 1164705505, 1164759866, 1164765277, 1164818084, 1164857322, 1164865457, 1164865465, 1164875415, 1164906764, 1164937660, 1164950697, 1164965752, 1164974531, 1164978615, 1174034870, 1174097794, 1174111702, 1174180632, 1174260475, 1174286710, 1174414668, 1174509160, 1174523641, 1174532097, 1174549604, 1174557862, 1174600852, 1174603526, 1174613897, 1174624159, 1174654651, 1174693360, 1174698245, 1174709745, 1174721823, 1174763239, 1174798227, 1174827893, 1174828487, 1174841357, 1174864326, 1174866404, 1174878979, 1174885529, 1174907752, 1174919948, 1174943591, 1174986855, 1174988398, 1184005977, 1184011652, 1184012494, 1184042293, 1184068561, 1184103129, 1184107179, 1184123473, 1184125536, 1184126260, 1184135535, 1184146516, 1184154627, 1184165227, 1184230583, 1184264376, 1184292336, 1184378127, 1184395501, 1184468530, 1184606303, 1184620676, 1184622102, 1184626244, 1184626855, 1184628950, 1184679516, 1184697989, 1184713539, 1184771701, 1184797367, 1184810541, 1184849747, 1184862344, 1184891277, 1184894685, 1184895567, 1184912909, 1194000588, 1194024315, 1194041285, 1194083717, 1194112755, 1194138370, 1194188219, 1194202945, 1194206128, 1194236521, 1194305110, 1194307942, 1194314260, 1194315697, 1194319889, 1194343376, 1194353235, 1194402271, 1194488692, 1194512301, 1194561951, 1194612978, 1194712273, 1194718585, 1194719914, 1194721993, 1194728071, 1194755504, 1194762229, 1194772400, 1194775288, 1194782987, 1194787283, 1194794339, 1194795120, 1194826727, 1194839985, 1194850594, 1194865238, 1194892976, 1194900670, 1194925743, 1194929463, 1194943357, 1194990259, 1205043684, 1205047594, 1205065760, 1205071743, 1205080488, 1205096195, 1205115706, 1205147196, 1205148947, 1205160942, 1205191871, 1205199759, 1205203270, 1205224185, 1205234093, 1205254042, 1205263944, 1205264371, 1205295672, 1205298320, 1205299732, 1205307287, 1205321379, 1205325040, 1205329513, 1205330479, 1205339009, 1205456761, 1205464732, 1205501962, 1205505179, 1205526464, 1205554847, 1205576469, 1205619442, 1205803814, 1205813946, 1205815016, 1205815404, 1205824331, 1205864113, 1205886439, 1205928959, 1205956018, 1205961729, 1205961752, 1205980075, 1215002217, 1215019179, 1215035811, 1215042130, 1215057914, 1215096854, 1215136403, 1215154562, 1215223664, 1215241658, 1215249529, 1215298146, 1215322664, 1215323084, 1215390117, 1215415419, 1215420005, 1215421441, 1215437561, 1215441308, 1215442090, 1215450911, 1215458690, 1215482617, 1215487368, 1215521547, 1215554670, 1215611611, 1215662382, 1215666102, 1215687058, 1215787601, 1215915442, 1215915897, 1215924311, 1215925383, 1215926597, 1215933700, 1215939525, 1215972575, 1215973995, 1215993779, 1225000920, 1225012958, 1225016900, 1225020878, 1225023344, 1225033632, 1225039407, 1225054679, 1225072523, 1225113525, 1225166549, 1225170145, 1225226954, 1225228943, 1225284839, 1225299704, 1225308240, 1225331663, 1225341399, 1225343080, 1225401623, 1225441660, 1225462989, 1225470602, 1225482193, 1225524051, 1225561863, 1225569056, 1225586332, 1225730534, 1225771397, 1225893019, 1235102591, 1235115270, 1235138496, 1235138629, 1235160599, 1235185950, 1235196114, 1235209149, 1235314071, 1235316589, 1235319187, 1235388703, 1235475674, 1235486796, 1235489097, 1235490996, 1235524885, 1235577099, 1235596669, 1235622481, 1235663147, 1235680901, 1235690975, 1235763012, 1235768870, 1235778481, 1235793134, 1235794439, 1235803743, 1235817867, 1235823790, 1235860255, 1235876947, 1235990946, 1245016047, 1245210657, 1245214303, 1245225754, 1245235969, 1245238120, 1245260108, 1245289529, 1245293513, 1245295211, 1245296409, 1245325182, 1245344605, 1245349463, 1245351832, 1245403815, 1245410893, 1245446418, 1245475714, 1245482470, 1245493477, 1245518653, 1245524768, 1245525765, 1245573963, 1245583483, 1245585694, 1245596238, 1245601491, 1245625177, 1245641273, 1245683960, 1245693357, 1245707272, 1245762459, 1245784982, 1245797539, 1245898675, 1255021226, 1255023834, 1255047999, 1255083374, 1255091013, 1255170239, 1255313177, 1255330072, 1255330965, 1255345336, 1255353249, 1255381034, 1255383162, 1255394391, 1255430930, 1255501839, 1255518296, 1255520441, 1255522801, 1255591582, 1255597324, 1255607784, 1255616181, 1255646535, 1255667341, 1255688461, 1255701504, 1255720264, 1255726550, 1255732467, 1255792792, 1255796231, 1255800470, 1255807335, 1255875548, 1255910139, 1255918736, 1255945853, 1265020341, 1265064430, 1265103394, 1265189807, 1265304737, 1265317846, 1265407100, 1265423941, 1265432975, 1265433635, 1265472690, 1265480727, 1265492532, 1265498604, 1265503551, 1265515662, 1265527295, 1265528269, 1265583009, 1265587349, 1265608004, 1265634158, 1265646376, 1265679187, 1265700843, 1265702369, 1265724405, 1265732093, 1265772347, 1265813141, 1265818553, 1265827133, 1265842751, 1265842991, 1265885602, 1265910384, 1265949226, 1265949382, 1265963540, 1265978373, 1265993455, 1275002073, 1275007213, 1275037947, 1275044604, 1275068850, 1275126617, 1275131302, 1275194664, 1275199820, 1275204810, 1275210726, 1275217267, 1275248809, 1275265621, 1275277220, 1275331126, 1275382731, 1275502213, 1275519647, 1275527897, 1275532251, 1275536237, 1275536377, 1275574535, 1275581605, 1275589038, 1275594350, 1275599524, 1275601502, 1275704363, 1275708760, 1275725954, 1275735623, 1275745242, 1275824641, 1275826463, 1275850737, 1275862633, 1275879454, 1275882706, 1275913808, 1275917866, 1275925422, 1275927048, 1275927105, 1275945016, 1275950560, 1275993040, 1285006619, 1285008946, 1285040410, 1285048603, 1285056440, 1285100040, 1285107094, 1285112532, 1285127852, 1285154997, 1285166702, 1285170654, 1285215236, 1285246132, 1285256628, 1285309096, 1285479592, 1285517433, 1285620179, 1285633115, 1285636084, 1285667410, 1285669481, 1285691113, 1285694380, 1285729616, 1285760579, 1285771634, 1285820001, 1285903757, 1285920744, 1285942151, 1285957308, 1285961805, 1285991976, 1285996140, 1295001204, 1295004877, 1295012227, 1295032902, 1295034346, 1295040178, 1295040624, 1295092732, 1295129831, 1295148260, 1295155984, 1295171338, 1295178622, 1295189355, 1295206126, 1295224350, 1295268498, 1295268654, 1295273910, 1295294833, 1295296648, 1295306140, 1295306330, 1295307379, 1295335289, 1295343358, 1295352482, 1295378115, 1295477842, 1295512911, 1295700755, 1295713725, 1295721611, 1295724359, 1295774040, 1295778215, 1295787414, 1295812279, 1295857332, 1295876449, 1295901023, 1295915759, 1295937654, 1295977924, 1295997518, 1306003033, 1306063656, 1306101852, 1306123112, 1306163704, 1306183942, 1306214101, 1306217088, 1306226873, 1306227285, 1306227921, 1306263330, 1306289897, 1306292909, 1306293659, 1306311477, 1306338025, 1306341441, 1306379086, 1306394143, 1306439583, 1306510474, 1306598081, 1306690326, 1306693304, 1306802517, 1306803390, 1306806369, 1306810635, 1306814330, 1306823695, 1306832928, 1306840210, 1306878111, 1306896360, 1306942214, 1306951157, 1316017429, 1316056567, 1316082506, 1316107154, 1316128853, 1316197080, 1316200629, 1316208929, 1316258437, 1316263015, 1316375124, 1316384035, 1316400955, 1316468978, 1316473242, 1316473721, 1316476823, 1316485253, 1316507981, 1316511348, 1316519127, 1316572290, 1316604010, 1316619554, 1316657042, 1316678329, 1316760556, 1316787716, 1316900053, 1316906811, 1316912306, 1316916752, 1316935653, 1316940513, 1316942410, 1316980741, 1316986805, 1326046541, 1326047028, 1326079005, 1326097809, 1326163890, 1326165259, 1326178815, 1326225301, 1326232232, 1326265794, 1326270505, 1326272196, 1326277468, 1326367327, 1326433558, 1326438011, 1326452061, 1326488891, 1326512898, 1326516527, 1326556812, 1326596875, 1326638990, 1326676917, 1326681719, 1326685066, 1326710823, 1326740572, 1326783036, 1326849969, 1336101542, 1336104355, 1336105113, 1336106178, 1336114602, 1336116383, 1336132547, 1336133685, 1336155837, 1336192517, 1336192624, 1336208040, 1336218031, 1336248335, 1336265602, 1336287002, 1336292085, 1336293034, 1336313865, 1336318047, 1336338326, 1336355973, 1336434729, 1336435965, 1336469006, 1336476415, 1336494814, 1336512672, 1336514801, 1336527985, 1336557883, 1336571116, 1336575174, 1336625680, 1336626423, 1336631647, 1336636422, 1336656941, 1336677608, 1336709799, 1336733450, 1336761972, 1336762012, 1336769702, 1336773621, 1336778018, 1336782093, 1336789015, 1336799873, 1336854439, 1336943802, 1336976497, 1346030285, 1346053501, 1346072618, 1346223351, 1346228467, 1346236692, 1346239357, 1346244266, 1346245388, 1346247673, 1346264397, 1346293404, 1346313897, 1346322005, 1346324167, 1346324738, 1346377090, 1346419793, 1346432143, 1346438066, 1346457355, 1346500816, 1346501269, 1346501319, 1346503091, 1346550472, 1346552957, 1346555414, 1346580842, 1346583630, 1346589553, 1346591914, 1346603008, 1346655966, 1346664109, 1346675121, 1346680576, 1346691482, 1346703204, 1346747961, 1346751625, 1346759412, 1346770393, 1346800828, 1346807062, 1346897741, 1346898103, 1346952801, 1356005714, 1356015424, 1356035315, 1356236251, 1356309108, 1356312102, 1356320667, 1356333470, 1356343586, 1356348676, 1356354773, 1356463616, 1356472815, 1356570287, 1356571053, 1356592869, 1356607378, 1356614267, 1356630727, 1356653737, 1356696918, 1356711030, 1356726046, 1356738439, 1356741664, 1356749998, 1356757629, 1356787550, 1356793095, 1356798094, 1356802888, 1356821581, 1356854228, 1356865034, 1356868426, 1356956353, 1356963862, 1356987960, 1356996417, 1356997456, 1366108342, 1366180952, 1366188971, 1366295313, 1366409468, 1366420614, 1366437949, 1366438848, 1366449464, 1366492027, 1366509978, 1366515405, 1366522658, 1366580110, 1366580375, 1366622185, 1366646119, 1366693772, 1366700247, 1366709891, 1366714032, 1366720658, 1366748535, 1366784712, 1366791659, 1366806481, 1366925109, 1366949976, 1376006338, 1376026740, 1376039099, 1376039388, 1376049726, 1376058701, 1376064642, 1376075135, 1376096842, 1376097030, 1376123141, 1376302034, 1376309765, 1376346296, 1376513424, 1376513564, 1376527663, 1376540625, 1376541649, 1376549543, 1376571059, 1376584961, 1376585141, 1376626507, 1376639385, 1376643841, 1376653634, 1376657254, 1376702761, 1376757690, 1376758797, 1376796581, 1376801274, 1376818369, 1376826925, 1376848028, 1376929521, 1386000255, 1386010460, 1386013258, 1386040509, 1386050821, 1386055614, 1386087435, 1386110054, 1386121556, 1386121820, 1386200509, 1386252856, 1386256717, 1386272540, 1386362325, 1386389211, 1386398048, 1386399863, 1386479814, 1386608883, 1386609634, 1386616548, 1386622025, 1386628469, 1386640613, 1386649457, 1386683290, 1386685790, 1386686988, 1386733434, 1386804284, 1386855484, 1386855674, 1386878155, 1386879138, 1386893147, 1386913945, 1386931327, 1386932093, 1386932267, 1386957447, 1386995967, 1396008553, 1396102901, 1396104196, 1396108676, 1396143533, 1396164125, 1396180923, 1396230645, 1396238440, 1396243374, 1396248795, 1396257663, 1396290441, 1396297651, 1396312500, 1396315479, 1396326609, 1396407946, 1396457792, 1396481446, 1396708814, 1396710091, 1396723979, 1396725271, 1396740445, 1396750782, 1396762134, 1396766705, 1396774691, 1396838785, 1396856191, 1396875407, 1396905584, 1396977385, 1407001563, 1407042468, 1407070576, 1407078413, 1407106404, 1407122989, 1407175052, 1407217995, 1407233208, 1407246853, 1407248354, 1407258221, 1407269988, 1407276496, 1407293681, 1407301112, 1407303399, 1407344922, 1407357239, 1407357940, 1407387426, 1407392079, 1407418411, 1407421407, 1407451289, 1407470719, 1407484181, 1407503006, 1407545114, 1407599707, 1407662968, 1407802754, 1407820483, 1407825912, 1407835572, 1407843162, 1407844749, 1407859218, 1407881154, 1407904808, 1407921158, 1407928823, 1407946262, 1407957996, 1407975535, 1417026949, 1417030701, 1417032749, 1417061995, 1417128083, 1417141078, 1417168311, 1417188806, 1417214032, 1417244393, 1417269309, 1417273459, 1417277229, 1417290834, 1417305558, 1417311200, 1417354721, 1417377409, 1417377615, 1417386905, 1417390972, 1417415993, 1417439548, 1417455577, 1417469172, 1417471582, 1417481771, 1417481839, 1417534314, 1417538323, 1417550559, 1417571118, 1417577974, 1417588229, 1417661885, 1417681974, 1417722182, 1417737867, 1417822305, 1417916651, 1417920182, 1417933490, 1417933508, 1417940172, 1417951831, 1417957416, 1417989575, 1417990565, 1417994476, 1427005784, 1427013085, 1427016211, 1427026087, 1427028810, 1427029248, 1427033117, 1427035930, 1427040690, 1427044114, 1427048180, 1427062603, 1427138692, 1427206879, 1427229442, 1427229764, 1427276948, 1427283076, 1427337674, 1427346501, 1427363472, 1427370345, 1427371202, 1427373968, 1427389600, 1427429257, 1427477694, 1427478569, 1427502913, 1427503259, 1427509280, 1427519438, 1427553379, 1427554682, 1427566439, 1427583566, 1427609759, 1427612571, 1427612597, 1427624147, 1427647817, 1427662642, 1427666486, 1427673599, 1427677640, 1427710227, 1427939628, 1437107695, 1437115151, 1437129004, 1437134376, 1437145158, 1437242310, 1437299724, 1437300316, 1437349610, 1437415569, 1437444346, 1437473360, 1437474897, 1437479896, 1437508033, 1437530128, 1437539640, 1437540861, 1437561420, 1437563558, 1437596251, 1437619889, 1437630134, 1437631462, 1437641594, 1437667755, 1437667797, 1437671831, 1437686037, 1437687118, 1437712692, 1437716842, 1437754538, 1437792348, 1437800919, 1437900065, 1437986197, 1447006242, 1447006424, 1447063078, 1447202106, 1447209994, 1447227087, 1447230859, 1447241666, 1447248612, 1447259932, 1447264833, 1447266697, 1447269451, 1447272299, 1447275789, 1447280151, 1447295795, 1447357769, 1447364732, 1447389168, 1447393855, 1447410980, 1447416896, 1447440052, 1447457247, 1447464789, 1447474861, 1447495569, 1447536073, 1447547385, 1447567615, 1447610258, 1447617337, 1447672811, 1447691142, 1447699525, 1447750823, 1447757380, 1447759501, 1447775515, 1447781158, 1447797386, 1447807904, 1447864210, 1447874045, 1447900196, 1447959242, 1447964069, 1447987847, 1457079931, 1457182891, 1457190860, 1457310419, 1457313850, 1457319386, 1457339806, 1457341281, 1457344087, 1457352940, 1457359754, 1457395485, 1457398398, 1457419582, 1457509598, 1457514051, 1457550501, 1457612442, 1457646127, 1457653081, 1457694291, 1457706533, 1457826497, 1457829871, 1457856973, 1457864977, 1457869125, 1457870750, 1457873770, 1457911521, 1457912180, 1457916777, 1457923302, 1457932329, 1457934176, 1457942377, 1457943912, 1457979635, 1467018457, 1467022442, 1467051318, 1467061432, 1467113118, 1467136218, 1467145193, 1467171165, 1467410258, 1467421412, 1467422337, 1467436832, 1467438580, 1467442111, 1467443721, 1467450668, 1467455915, 1467457846, 1467458562, 1467467852, 1467493700, 1467524199, 1467599464, 1467618603, 1467660035, 1467679183, 1467688093, 1467713362, 1467729442, 1467729996, 1467809160, 1467863555, 1467885475, 1467893735, 1467905778, 1467933671, 1467958512, 1467964437, 1467972299, 1467976993, 1467982645, 1467996637, 1467997767, 1477057883, 1477066835, 1477079226, 1477083095, 1477084473, 1477099273, 1477116622, 1477124964, 1477133254, 1477171825, 1477190825, 1477265155, 1477322055, 1477391472, 1477504587, 1477505949, 1477527737, 1477538031, 1477622942, 1477629152, 1477636751, 1477701332, 1477714640, 1477715431, 1477722999, 1477759512, 1477783942, 1477790145, 1477798049, 1477814069, 1477820462, 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, 1487385910, 1487621652, 1487626925, 1487632295, 1487644043, 1487656161, 1487657342, 1487661617, 1487664215, 1487679692, 1487685186, 1487720801, 1487750428, 1487753570, 1487755518, 1487760005, 1487832598, 1487858494, 1487861688, 1487862421, 1487862520, 1487944963, 1487960381, 1487994844, 1497038558, 1497120539, 1497124341, 1497182588, 1497189252, 1497194567, 1497203343, 1497232920, 1497259386, 1497264170, 1497268395, 1497269088, 1497286058, 1497308852, 1497334213, 1497348866, 1497382436, 1497383566, 1497415210, 1497477376, 1497501829, 1497520845, 1497529028, 1497638647, 1497707079, 1497709976, 1497732952, 1497735468, 1497742670, 1497771406, 1497782023, 1497782254, 1497788566, 1497853287, 1497855027, 1497879555, 1497889257, 1497922892, 1497937296, 1497964399, 1497971717, 1497981682, 1497987309, 1497992077, 1508048737, 1508152034, 1508173618, 1508175902, 1508199209, 1508203209, 1508220815, 1508240292, 1508314212, 1508334731, 1508346289, 1508373374, 1508391533, 1508397043, 1508414186, 1508462375, 1508469479, 1508498924, 1508504721, 1508528373, 1508534991, 1508549726, 1508645151, 1508648627, 1508651449, 1508806845, 1508809518, 1508822446, 1508831603, 1508850538, 1508861899, 1508870353, 1508872474, 1508911694, 1508943937, 1508958018, 1508971961, 1508993007, 1508997081, 1518007822, 1518030733, 1518036177, 1518043959, 1518069210, 1518083328, 1518101120, 1518105675, 1518113851, 1518133792, 1518192780, 1518225341, 1518300391, 1518316355, 1518344092, 1518345156, 1518378348, 1518401603, 1518408038, 1518414853, 1518432897, 1518432954, 1518435429, 1518440759, 1518441369, 1518480979, 1518490317, 1518495878, 1518512672, 1518543735, 1518546993, 1518555630, 1518598309, 1518798099, 1518904838, 1518904879, 1518907146, 1518908250, 1518926344, 1518928688, 1518947597, 1518948538, 1518956473, 1518962232, 1518962612, 1518965896, 1518996362, 1528038494, 1528058971, 1528061322, 1528084282, 1528110343, 1528124880, 1528144250, 1528157468, 1528176393, 1528185246, 1528251113, 1528355625, 1528355922, 1528357571, 1528361417, 1528401213, 1528411121, 1528419223, 1528419926, 1528425634, 1528441706, 1528487543, 1528505179, 1528549706, 1528554524, 1528555059, 1528578770, 1528651023, 1528664240, 1528671955, 1528712304, 1528721750, 1528772381, 1528789252, 1528796091, 1528837937, 1528839099, 1538100714, 1538108063, 1538132139, 1538145263, 1538146907, 1538159322, 1538164868, 1538181029, 1538199591, 1538214549, 1538255534, 1538295829, 1538314398, 1538321757, 1538322508, 1538329479, 1538339767, 1538347521, 1538369756, 1538484415, 1538492053, 1538511787, 1538600283, 1538621263, 1538637731, 1538643978, 1538653290, 1538659073, 1538675707, 1538677950, 1538684303, 1538685102, 1538723283, 1538775705, 1538798699, 1538861547, 1548200348, 1548220486, 1548243900, 1548244551, 1548248081, 1548256316, 1548267818, 1548267826, 1548272388, 1548286768, 1548293095, 1548310600, 1548346117, 1548410772, 1548425069, 1548449853, 1548458532, 1548517709, 1548578859, 1548579964, 1548588775, 1548598469, 1548622996, 1548641400, 1548646169, 1548655715, 1548657257, 1548676778, 1548684855, 1548700107, 1548720238, 1548770597, 1548784085, 1548791072, 1548816697, 1548831134, 1548837297, 1548849243, 1548901663, 1548909807, 1558005546, 1558032227, 1558132969, 1558153346, 1558320176, 1558336461, 1558342188, 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, 1568166114, 1568167187, 1568174746, 1568230936, 1568402808, 1568417343, 1568453587, 1568462240, 1568462299, 1568469849, 1568478386, 1568479087, 1568480606, 1568497717, 1568514230, 1568518538, 1568546414, 1568599108, 1568648061, 1568651990, 1568670990, 1568709194, 1568721488, 1568740108, 1568744183, 1568779924, 1568793602, 1568799781, 1568811339, 1568817948, 1568831428, 1568854065, 1568878197, 1568881654, 1568887925, 1568895993, 1568916872, 1568919710, 1568920577, 1568930832, 1568932671, 1568937563, 1568942894, 1578007381, 1578033502, 1578077236, 1578095717, 1578097820, 1578170718, 1578200671, 1578206256, 1578227419, 1578271649, 1578302089, 1578334546, 1578504171, 1578507299, 1578516951, 1578530127, 1578531547, 1578544250, 1578562013, 1578563706, 1578616033, 1578677068, 1578682290, 1578701116, 1578721437, 1578722971, 1578741385, 1578791018, 1578805388, 1578826061, 1578896957, 1578907176, 1578937967, 1578940649, 1578941753, 1578960209, 1578969028, 1578969846, 1578974028, 1588032080, 1588055644, 1588055669, 1588079529, 1588097844, 1588104137, 1588110779, 1588153001, 1588168173, 1588173132, 1588182430, 1588186688, 1588201511, 1588207658, 1588230817, 1588238349, 1588241475, 1588271779, 1588300602, 1588321426, 1588406318, 1588434195, 1588442941, 1588605729, 1588607279, 1588616239, 1588669279, 1588669543, 1588678684, 1588679012, 1588689780, 1588698286, 1588699680, 1588741755, 1588746341, 1588762868, 1588816573, 1588865414, 1588868616, 1588877955, 1588907810, 1588910723, 1588913958, 1588927834, 1588928188, 1588951636, 1588977391, 1588984587, 1598003428, 1598020059, 1598044737, 1598057853, 1598063554, 1598095929, 1598114803, 1598141327, 1598149486, 1598163651, 1598187437, 1598203531, 1598235020, 1598239410, 1598241614, 1598260663, 1598269805, 1598276842, 1598278079, 1598286825, 1598296394, 1598296915, 1598296972, 1598299075, 1598320590, 1598329831, 1598332645, 1598334047, 1598345480, 1598348252, 1598352288, 1598384125, 1598390148, 1598422065, 1598426017, 1598470452, 1598521767, 1598715625, 1598716201, 1598741597, 1598761017, 1598761371, 1598772881, 1598778847, 1598780702, 1598781460, 1598784092, 1598861726, 1598873804, 1598876930, 1598895674, 1598927824, 1598946527, 1609025527, 1609064617, 1609147883, 1609172063, 1609262641, 1609296912, 1609303437, 1609317734, 1609348176, 1609392406, 1609403443, 1609419670, 1609437177, 1609453448, 1609466457, 1609517978, 1609525302, 1609526797, 1609538594, 1609597434, 1609639194, 1609657394, 1609801489, 1609866490, 1609890821, 1609893221, 1609895952, 1609978014, 1619010444, 1619056793, 1619080314, 1619138724, 1619211463, 1619233061, 1619233822, 1619257508, 1619316056, 1619320702, 1619380557, 1619450699, 1619459641, 1619474327, 1619496965, 1619521028, 1619541356, 1619591468, 1619634193, 1619646072, 1619738671, 1619784774, 1619798956, 1619900784, 1619929981, 1619939659, 1619944097, 1619945755, 1619946852, 1619963196, 1619965472, 1619967650, 1619974987, 1619976065, 1619986155, 1619991452, 1629006903, 1629018700, 1629018783, 1629022207, 1629047857, 1629054739, 1629066998, 1629067509, 1629097126, 1629147574, 1629160262, 1629165907, 1629186101, 1629199393, 1629203112, 1629236997, 1629239322, 1629243332, 1629246293, 1629297924, 1629309398, 1629322474, 1629337894, 1629341094, 1629344254, 1629380878, 1629387972, 1629395512, 1629405147, 1629430376, 1629484092, 1629544242, 1629559042, 1629559778, 1629561105, 1629627039, 1629677117, 1629723812, 1629726476, 1629728878, 1629751490, 1629782909, 1629783774, 1629798806, 1639100571, 1639110885, 1639118557, 1639130701, 1639135965, 1639140734, 1639154495, 1639154792, 1639156300, 1639182082, 1639221518, 1639231087, 1639238157, 1639245350, 1639258791, 1639326804, 1639380124, 1639411887, 1639426778, 1639432958, 1639433014, 1639439334, 1639507486, 1639529936, 1639549538, 1639559867, 1639563844, 1639577604, 1639584949, 1639623093, 1639664501, 1639666589, 1639677974, 1639685563, 1639727555, 1639749948, 1639775729, 1639790991, 1639834443, 1639837784, 1639877574, 1639948946, 1639983315, 1649039165, 1649041435, 1649069436, 1649084310, 1649092628, 1649212903, 1649223074, 1649229360, 1649240136, 1649240151, 1649246489, 1649264128, 1649273137, 1649302258, 1649305988, 1649323379, 1649332321, 1649345026, 1649377391, 1649404138, 1649460098, 1649465600, 1649469982, 1649475971, 1649488032, 1649490368, 1649516337, 1649519158, 1649530692, 1649556218, 1649587114, 1649625682, 1649628686, 1649629692, 1649631839, 1649655028, 1649673500, 1649690579, 1649699158, 1649709866, 1649739780, 1649784273, 1649792037, 1649821216, 1649821398, 1649853169, 1649909003, 1649909342, 1649937202, 1649988692, 1659082378, 1659102887, 1659190957, 1659334738, 1659336337, 1659339380, 1659359313, 1659367068, 1659371292, 1659374700, 1659383750, 1659405249, 1659424877, 1659458156, 1659464543, 1659507366, 1659535045, 1659535409, 1659565265, 1659569382, 1659593184, 1659598860, 1659610905, 1659616597, 1659617454, 1659629053, 1659638443, 1659638617, 1659670156, 1659683779, 1659703593, 1659721579, 1659726719, 1659735173, 1659744134, 1659749570, 1659766319, 1659794683, 1659795664, 1659797132, 1659807964, 1659876944, 1659882470, 1659887388, 1659894921, 1659928190, 1659947067, 1669015087, 1669052254, 1669081683, 1669115705, 1669124988, 1669137063, 1669410411, 1669433348, 1669440814, 1669456737, 1669461265, 1669467783, 1669475463, 1669483566, 1669486197, 1669632469, 1669650693, 1669651816, 1669693032, 1669694246, 1669699385, 1669714671, 1669739561, 1669761177, 1669792024, 1669797890, 1669838199, 1669844437, 1669911152, 1669920401, 1669952644, 1669962502, 1669963971, 1669972410, 1669974721, 1669985446, 1669987814, 1679002497, 1679038624, 1679050025, 1679060370, 1679066617, 1679068134, 1679079016, 1679080667, 1679096770, 1679100580, 1679113682, 1679159222, 1679226542, 1679260061, 1679345722, 1679349492, 1679440101, 1679519649, 1679538177, 1679591234, 1679593628, 1679604201, 1679636807, 1679646178, 1679676274, 1679695985, 1679725865, 1679732036, 1679765770, 1679787386, 1679837983, 1679842058, 1679895320, 1679907984, 1679920425, 1679921894, 1679922819, 1679927198, 1679927842, 1679933238, 1679936181, 1679936819, 1679973754, 1689022303, 1689033763, 1689061848, 1689075632, 1689083438, 1689084113, 1689129918, 1689162075, 1689194870, 1689203150, 1689207292, 1689210494, 1689243297, 1689246662, 1689248650, 1689252470, 1689259301, 1689295842, 1689350043, 1689604324, 1689606436, 1689611071, 1689630048, 1689630741, 1689646663, 1689663130, 1689674152, 1689676777, 1689677874, 1689732778, 1689751372, 1689762726, 1689777070, 1689780454, 1689789810, 1689808107, 1689880346, 1689926180, 1689926982, 1689941395, 1689956005, 1689960429, 1689976375, 1689992091, 1699020826, 1699025312, 1699031476, 1699045542, 1699099986, 1699160044, 1699160176, 1699170142, 1699170282, 1699206664, 1699207381, 1699224220, 1699243592, 1699257733, 1699264283, 1699283408, 1699320705, 1699382580, 1699418897, 1699445841, 1699472571, 1699487330, 1699497339, 1699704684, 1699714774, 1699717504, 1699729434, 1699759449, 1699761809, 1699772244, 1699781120, 1699789065, 1699791582, 1699792416, 1699806091, 1699845867, 1699854018, 1699861393, 1699866434, 1699877688, 1699936377, 1699982751, 1700020138, 1700050309, 1700154929, 1700177383, 1700200607, 1700233889, 1700234101, 1700239423, 1700248010, 1700260866, 1700279858, 1700306545, 1700307352, 1700307519, 1700319530, 1700330586, 1700345675, 1700349800, 1700359361, 1700382439, 1700412418, 1700413796, 1700414299, 1700422326, 1700440062, 1700443413, 1700447711, 1700466430, 1700521952, 1700639143, 1700639457, 1700813839, 1700849114, 1700865391, 1700875747, 1700881034, 1700886041, 1700954526, 1700977592, 1710005970, 1710088471, 1710117098, 1710119532, 1710124201, 1710144100, 1710144746, 1710150933, 1710152616, 1710173885, 1710187521, 1710191713, 1710261193, 1710273248, 1710305156, 1710331715, 1710383336, 1710409487, 1710433909, 1710557814, 1710579990, 1710658984, 1710677521, 1710735147, 1710900790, 1710915079, 1710937370, 1710941885, 1710949110, 1710971916, 1710973508, 1710974407, 1710978424, 1710978820, 1710981089, 1710988225, 1720027824, 1720039126, 1720042245, 1720062318, 1720087463, 1720088966, 1720106248, 1720116924, 1720117195, 1720179765, 1720198112, 1720231897, 1720236433, 1720238298, 1720241318, 1720271596, 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, 1720692320, 1720699010, 1720750482, 1720763154, 1730052481, 1730101189, 1730105065, 1730128919, 1730156514, 1730156571, 1730162199, 1730166968, 1730187501, 1730193137, 1730216029, 1730218389, 1730225442, 1730234329, 1730267030, 1730275462, 1730278920, 1730314725, 1730337619, 1730365990, 1730369448, 1730376435, 1730410572, 1730416314, 1730421025, 1730437179, 1730445545, 1730460528, 1730492141, 1730503624, 1730504150, 1730535238, 1730537101, 1730538323, 1730540915, 1730542077, 1730581125, 1730595414, 1730603317, 1730609942, 1730623364, 1730624198, 1730625724, 1730638826, 1730649864, 1730683087, 1730699109, 1730735093, 1730741158, 1730767898, 1730837816, 1730849779, 1730857178, 1730890120, 1730994013, 1740205038, 1740222827, 1740252923, 1740253087, 1740257369, 1740258904, 1740276708, 1740277177, 1740282102, 1740347566, 1740353879, 1740383124, 1740389410, 1740442722, 1740446343, 1740464361, 1740539899, 1740553692, 1740573567, 1740574342, 1740611920, 1740620459, 1740622083, 1740633056, 1740633494, 1740636240, 1740647882, 1740660737, 1740683119, 1740743137, 1740767078, 1740772888, 1740779651, 1740784255, 1740838895, 1740861533, 1740870310, 1740886795, 1740940527, 1740947803, 1750039574, 1750053195, 1750058707, 1750058970, 1750069563, 1750093068, 1750315628, 1750336863, 1750337747, 1750341731, 1750350559, 1750364220, 1750379376, 1750383337, 1750469987, 1750472411, 1750509642, 1750562666, 1750573986, 1750586483, 1750612412, 1750614228, 1750615282, 1750623070, 1750631073, 1750631156, 1750644720, 1750664108, 1750750477, 1750777207, 1750794673, 1750803102, 1750811956, 1750824215, 1750828695, 1750844718, 1750854949, 1750863973, 1750905774, 1750908299, 1750944096, 1750982682, 1760017453, 1760070098, 1760126130, 1760411227, 1760430953, 1760434203, 1760468953, 1760481691, 1760499982, 1760530521, 1760576300, 1760577340, 1760592695, 1760598965, 1760633424, 1760641740, 1760743728, 1760832430, 1760851067, 1760881320, 1760888523, 1760903116, 1760925457, 1760936165, 1760937056, 1760970479, 1760973093, 1770002966, 1770015497, 1770017469, 1770028649, 1770029530, 1770052185, 1770054728, 1770070831, 1770077372, 1770083875, 1770133613, 1770214520, 1770223273, 1770254997, 1770276081, 1770299018, 1770337099, 1770337792, 1770374084, 1770394553, 1770510927, 1770548661, 1770567661, 1770570186, 1770571309, 1770576514, 1770577389, 1770577694, 1770579583, 1770583031, 1770583486, 1770595894, 1770628893, 1770665028, 1770697211, 1770725095, 1770734972, 1770738478, 1770739211, 1770744369, 1770760761, 1770762825, 1770780280, 1770784613, 1770812398, 1770825846, 1770835506, 1770846552, 1770848327, 1770869547, 1770895377, 1770936353, 1770974206, 1770995672, 1770996241, 1780004093, 1780022558, 1780041913, 1780047969, 1780068502, 1780079236, 1780086538, 1780139824, 1780182428, 1780229682, 1780263152, 1780272138, 1780286344, 1780291468, 1780299560, 1780317198, 1780390740, 1780600932, 1780611590, 1780612416, 1780616623, 1780660886, 1780664623, 1780669259, 1780671230, 1780694505, 1780727255, 1780728139, 1780766907, 1780792937, 1780808394, 1780826321, 1780855833, 1780871343, 1780886671, 1780889063, 1780917302, 1780926022, 1780926212, 1780926238, 1780939462, 1780941583, 1780941724, 1780972190, 1780978015, 1780980102, 1790013720, 1790026466, 1790062651, 1790142685, 1790147379, 1790165850, 1790171577, 1790203842, 1790206027, 1790219129, 1790225167, 1790225423, 1790225977, 1790259752, 1790290823, 1790313138, 1790326205, 1790329910, 1790446698, 1790450245, 1790520179, 1790525053, 1790556264, 1790709301, 1790721702, 1790728087, 1790741577, 1790746931, 1790754166, 1790827210, 1790828846, 1790836534, 1790946861, 1790949337, 1790975787, 1790984755, 1790990711, 1801022546, 1801024708, 1801059050, 1801102710, 1801155015, 1801184833, 1801190988, 1801193743, 1801195466, 1801252358, 1801304423, 1801321773, 1801328471, 1801341789, 1801353479, 1801355631, 1801361647, 1801384144, 1801397716, 1801446315, 1801448147, 1801470638, 1801513692, 1801522651, 1801539960, 1801580063, 1801599303, 1801629423, 1801772660, 1801815352, 1801826763, 1801836424, 1801843602, 1801848338, 1801852728, 1801885355, 1801889845, 1801895990, 1801896303, 1801900717, 1801908009, 1801945134, 1801980644, 1811060999, 1811064991, 1811069875, 1811082589, 1811106529, 1811107691, 1811141781, 1811144264, 1811166929, 1811191828, 1811219108, 1811230600, 1811242639, 1811288723, 1811303134, 1811315427, 1811336761, 1811368822, 1811392020, 1811399637, 1811403579, 1811424021, 1811439334, 1811456940, 1811476864, 1811490204, 1811520554, 1811582190, 1811633639, 1811670417, 1811718992, 1811759970, 1811923394, 1811937659, 1811947633, 1811952997, 1811961451, 1811967177, 1811967672, 1811973142, 1811976913, 1811983067, 1811984354, 1811993256, 1811995277, 1821010323, 1821020918, 1821034422, 1821037839, 1821061227, 1821061268, 1821076357, 1821078007, 1821080946, 1821087610, 1821091455, 1821094038, 1821109711, 1821123605, 1821159526, 1821191339, 1821219254, 1821249301, 1821254095, 1821255761, 1821259706, 1821267352, 1821325986, 1821436650, 1821439191, 1821449505, 1821455080, 1821470089, 1821533522, 1821536103, 1821542374, 1821595869, 1821632217, 1821642422, 1821646092, 1821655796, 1821664244, 1821665316, 1821736612, 1821876731, 1821893033, 1831108075, 1831110048, 1831114388, 1831120096, 1831139351, 1831151570, 1831154731, 1831175215, 1831181304, 1831240795, 1831243583, 1831262286, 1831293521, 1831304658, 1831310770, 1831353283, 1831367424, 1831381110, 1831415637, 1831441997, 1831460690, 1831504364, 1831512896, 1831523943, 1831524446, 1831565993, 1831610690, 1831619790, 1831625235, 1831640242, 1831647460, 1831654169, 1831667625, 1831684646, 1831698729, 1831717420, 1831739986, 1831771336, 1831798743, 1831840966, 1831869627, 1831889690, 1831967298, 1841041696, 1841201787, 1841213410, 1841220340, 1841250024, 1841256765, 1841265584, 1841268521, 1841276441, 1841278504, 1841288081, 1841289477, 1841289972, 1841292786, 1841296365, 1841306958, 1841351061, 1841371168, 1841420189, 1841424819, 1841435740, 1841450632, 1841493129, 1841528791, 1841530516, 1841537586, 1841545993, 1841553443, 1841593118, 1841642808, 1841679107, 1841682499, 1841741840, 1841753936, 1841765427, 1841773652, 1841780038, 1841781390, 1841799160, 1841849569, 1841906864, 1841950235, 1841960739, 1851003594, 1851016877, 1851025159, 1851087613, 1851120984, 1851305965, 1851334072, 1851341424, 1851351878, 1851384671, 1851386817, 1851402564, 1851506729, 1851508246, 1851513014, 1851529812, 1851533020, 1851573992, 1851609473, 1851617732, 1851631402, 1851632921, 1851640460, 1851650477, 1851677074, 1851682447, 1851685812, 1851698633, 1851705149, 1851733315, 1851739783, 1851740260, 1851746762, 1851754139, 1851797377, 1851810030, 1851816243, 1851823132, 1851840052, 1851871925, 1851875066, 1851900575, 1851903611, 1851915870, 1851942627, 1851943757, 1851952592, 1851956874, 1851961270, 1851984595, 1861014151, 1861022527, 1861029092, 1861072357, 1861161218, 1861444598, 1861449159, 1861460388, 1861467037, 1861525149, 1861565327, 1861598849, 1861621609, 1861672669, 1861692717, 1861697740, 1861708315, 1861744732, 1861763161, 1861781148, 1861787145, 1861797706, 1861846479, 1861851248, 1861858003, 1861869638, 1861886160, 1861893323, 1861914442, 1861939019, 1861944662, 1861951022, 1861994550, 1871007187, 1871017475, 1871026617, 1871033845, 1871035782, 1871060608, 1871079392, 1871096362, 1871121566, 1871124388, 1871139592, 1871152769, 1871178095, 1871248476, 1871290684, 1871325837, 1871357798, 1871476721, 1871501411, 1871514448, 1871524785, 1871541235, 1871557769, 1871563023, 1871567396, 1871571760, 1871583666, 1871608125, 1871669713, 1871676858, 1871698597, 1871739581, 1871757468, 1871800425, 1871800771, 1871813691, 1871822569, 1871834176, 1871871806, 1871871830, 1871893222, 1871934604, 1871951814, 1871954693, 1871959221, 1871977355, 1871986489, 1871997312, 1881002608, 1881022325, 1881022697, 1881028744, 1881040392, 1881053411, 1881053635, 1881056760, 1881088714, 1881102325, 1881125680, 1881128346, 1881157915, 1881161743, 1881175297, 1881190585, 1881192235, 1881230696, 1881231868, 1881256634, 1881333243, 1881336626, 1881337384, 1881361483, 1881463032, 1881473254, 1881649812, 1881681161, 1881688018, 1881693349, 1881699114, 1881720720, 1881763100, 1881765253, 1881771228, 1881791101, 1881828879, 1881863736, 1881883593, 1881885143, 1881924611, 1881950087, 1891019790, 1891048815, 1891055893, 1891081998, 1891102489, 1891106951, 1891108072, 1891115648, 1891139200, 1891232815, 1891243150, 1891259685, 1891263927, 1891271805, 1891277133, 1891289476, 1891299889, 1891322285, 1891324174, 1891331997, 1891350807, 1891388351, 1891442117, 1891548012, 1891564399, 1891565644, 1891762258, 1891765038, 1891766259, 1891773248, 1891775029, 1891784757, 1891799862, 1891808002, 1891808861, 1891863478, 1891882312, 1891913232, 1891929071, 1891935250, 1891938718, 1891975975, 1891978532, 1891982641, 1891995718, 1902048499, 1902160278, 1902160971, 1902169543, 1902188113, 1902225071, 1902227184, 1902247075, 1902292907, 1902315260, 1902315997, 1902323728, 1902350176, 1902350275, 1902366313, 1902377880, 1902377930, 1902399215, 1902407927, 1902418411, 1902422207, 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, 1912482449, 1912508516, 1912535766, 1912538240, 1912603416, 1912716630, 1912729542, 1912738105, 1912790122, 1912941089, 1912955758, 1912968603, 1912997792, 1912998709, 1922004704, 1922023670, 1922035922, 1922039551, 1922041144, 1922043298, 1922062751, 1922094325, 1922150713, 1922151943, 1922164771, 1922188622, 1922235498, 1922236017, 1922246966, 1922252345, 1922258060, 1922318815, 1922333558, 1922388578, 1922410141, 1922415264, 1922439066, 1922449859, 1922461102, 1922462258, 1922476332, 1922512896, 1922527449, 1922539048, 1922561695, 1922568765, 1922568930, 1922585256, 1922590264, 1922594514, 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, 1932501566, 1932511953, 1932515251, 1932528882, 1932532934, 1932543444, 1932554078, 1932555430, 1932570140, 1932577012, 1932586849, 1932602976, 1932609328, 1932613130, 1932614633, 1932664752, 1932667904, 1932726106, 1932787538, 1932865144, 1932866795, 1932920220, 1932949088, 1932964467, 1942035175, 1942072970, 1942203377, 1942242813, 1942261243, 1942265426, 1942266648, 1942384375, 1942405907, 1942410527, 1942421672, 1942422449, 1942507975, 1942526546, 1942543699, 1942545470, 1942560263, 1942561113, 1942561394, 1942594825, 1942627898, 1942628748, 1942635396, 1942638408, 1942678628, 1942716170, 1942716287, 1942721741, 1942743828, 1942760491, 1942765953, 1942767520, 1942794607, 1942823018, 1942826086, 1942854872, 1942910880, 1942913017, 1942949136, 1942966106, 1942966619, 1942972393, 1952006553, 1952036923, 1952041394, 1952043929, 1952044315, 1952163982, 1952296147, 1952307399, 1952333171, 1952334179, 1952334401, 1952339285, 1952407702, 1952426736, 1952442469, 1952487860, 1952545741, 1952566788, 1952605297, 1952644981, 1952646507, 1952658460, 1952690810, 1952695330, 1952718843, 1952722316, 1952738148, 1952745929, 1952763997, 1952827693, 1952888422, 1952899155, 1952917494, 1952928525, 1952950438, 1952991242, 1962003657, 1962040394, 1962043471, 1962058966, 1962064303, 1962074252, 1962095752, 1962142661, 1962186957, 1962426742, 1962430140, 1962465575, 1962468165, 1962471458, 1962475681, 1962483941, 1962484758, 1962505933, 1962608125, 1962715193, 1962733006, 1962743625, 1962753186, 1962757963, 1962764084, 1962767509, 1962771576, 1962795963, 1962824029, 1962825075, 1962848218, 1962860346, 1962866434, 1962874941, 1962900951, 1962911412, 1962920876, 1962923805, 1962971044, 1972042463, 1972043602, 1972044667, 1972049203, 1972052306, 1972066801, 1972091064, 1972123222, 1972184901, 1972220994, 1972229474, 1972310712, 1972311777, 1972356491, 1972504629, 1972512440, 1972527547, 1972528040, 1972532810, 1972560084, 1972590834, 1972597821, 1972609550, 1972613487, 1972647394, 1972656254, 1972687432, 1972690485, 1972705960, 1972711851, 1972719318, 1972722494, 1972738359, 1972786952, 1972827384, 1972840312, 1972846517, 1972879070, 1972889129, 1972890721, 1972918779, 1972940195, 1972952430, 1982009288, 1982011227, 1982027033, 1982028411, 1982047924, 1982072054, 1982085247, 1982101879, 1982124244, 1982135414, 1982139630, 1982144408, 1982148730, 1982166443, 1982168944, 1982190260, 1982202768, 1982204442, 1982220703, 1982239034, 1982247417, 1982256848, 1982257044, 1982329967, 1982393443, 1982601225, 1982653432, 1982660437, 1982680427, 1982680567, 1982704243, 1982716148, 1982717302, 1982718128, 1982747416, 1982781563, 1982818753, 1982823290, 1982911962, 1982977724, 1982978144, 1992013858, 1992015994, 1992075733, 1992076756, 1992086102, 1992119101, 1992121958, 1992141139, 1992202246, 1992209019, 1992213870, 1992229264, 1992234488, 1992278600, 1992339089, 1992355481, 1992368245, 1992394035, 1992466056, 1992596183, 1992700520, 1992705222, 1992706121, 1992735583, 1992740088, 1992772404, 1992773501, 1992781439, 1992796775, 1992800361, 1992809057, 1992811665, 1992826440, 1992871990, 1992909063, 1992963227, 1992964266, 1992965370, 1992975098, 1992996359

unique_codes_total 14941
duplicate_codes 14826
duplicate_pct 99.23
by_code_type
HCPCS 5380
CSTM-ALL 1
CPT 9512
RC 48
unknown_code_types
format_invalid_by_type
HCPCS 146876
codes_not_in_reference reference_not_loaded
most_frequent_codes
Type Code Occurrences
HCPCS E0950 1,674
HCPCS E0951 1,674
HCPCS E0952 1,674
HCPCS E0953 1,674
HCPCS E0954 1,674
HCPCS E0956 1,674
HCPCS E0957 1,674
HCPCS E0960 1,674
HCPCS E0973 1,674
HCPCS E0978 1,674
HCPCS E0981 1,674
HCPCS E0982 1,674
HCPCS E0990 1,674
HCPCS E0995 1,674
HCPCS E1016 1,674
HCPCS E2208 1,674
HCPCS E2209 1,674
HCPCS E2210 1,674
HCPCS E2323 1,674
HCPCS E2324 1,674

total_prices_checked 3920117
total_rates 3919611
per_diem_rates 0
percentage_rates 506
negative_rates 0
zero_rates 78250
extreme_high_rates 2970
extreme_low_rates 923
rate_distribution
sample_n 3919611
sample_k 5000
confidence high
p5 4.390165
p25 56.15575
p50 258.25899999999996
p75 969.5733749999999
p95 4152.113825000001
p99 14715.051195000002
by_billing_class
Class / Type Count Median p25 p75 p95 Confidence
institutional/fee schedule 1,727,709 352.1 81.9 1352.1 10729.4 high
professional/fee schedule 2,191,896 178.6 48.6 675.6 2603.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 3919605
derived 6
unique_rate_contexts 34764
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.