{"columns":[{"name":"hospital_id","type":"string"},{"name":"hospital_display_name","type":"string"},{"name":"canonical_state","type":"string"},{"name":"hospital_type","type":"string"},{"name":"health_system","type":"string"},{"name":"canonical_state_name","type":"string"},{"name":"canonical_census_region","type":"string"},{"name":"canonical_census_division","type":"string"},{"name":"expected_format","type":"string"},{"name":"mrf_url","type":"string"},{"name":"snapshot_id","type":"string"},{"name":"current_snapshot_available","type":"bool"},{"name":"is_current_snapshot","type":"bool"},{"name":"published_last_updated_on","type":"date32[day]"},{"name":"snapshot_age_days","type":"int64"},{"name":"freshness_bucket","type":"string"},{"name":"overall_readiness_score","type":"double"},{"name":"freshness_score","type":"decimal128(3, 2)"},{"name":"code_coverage_score","type":"double"},{"name":"amount_coverage_score","type":"double"},{"name":"payer_mapping_score","type":"double"},{"name":"comparison_readiness_score","type":"double"},{"name":"overall_readiness_rank","type":"int64"},{"name":"comparison_readiness_rank","type":"int64"},{"name":"payer_mapping_rank","type":"int64"},{"name":"data_confidence_band","type":"string"},{"name":"charge_item_count","type":"int64"},{"name":"standard_charge_count","type":"int64"},{"name":"payer_rate_count","type":"int64"},{"name":"observation_count","type":"int64"},{"name":"distinct_comparable_codes","type":"int64"},{"name":"benchmark_context_count","type":"int64"},{"name":"benchmark_service_count","type":"int64"},{"name":"benchmark_services_meeting_floor","type":"int64"},{"name":"payer_contract_context_count","type":"int64"},{"name":"matched_payer_count","type":"int64"},{"name":"payer_contract_service_count","type":"int64"},{"name":"coded_item_coverage_rate","type":"double"},{"name":"dollar_observation_coverage_rate","type":"double"},{"name":"discounted_cash_coverage_rate","type":"double"},{"name":"negotiated_dollar_coverage_rate","type":"double"},{"name":"payer_mapping_coverage_rate","type":"double"}],"n_rows":14,"rows_kept":14,"cut":false,"text_format":"parquet-jsonl-2026-10-02","bounds":{"document_bytes":16777216,"package_text_limit_bytes":33554432,"package_text_slack_bytes":1024,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096,"vector_min":64,"vector_head_fixed":16,"vector_head_variable":64,"kv_value_chars":1048576,"nesting_max":64,"binary_text":true},"cells_cut":0,"cells_bad_utf8":0,"cells_raw":0,"cells_binary":0,"cells_binary_text":0,"cells_vector":0,"n_row_groups":1,"reader":"pyarrow 23.0.1, python 3.13","created_by":"DuckDB version v1.5.2 (build 8a5851971f)","schema":{"fields":[{"name":"hospital_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"hospital_display_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"canonical_state","type":"string","nullable":true,"metadata":null,"children":null},{"name":"hospital_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"health_system","type":"string","nullable":true,"metadata":null,"children":null},{"name":"canonical_state_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"canonical_census_region","type":"string","nullable":true,"metadata":null,"children":null},{"name":"canonical_census_division","type":"string","nullable":true,"metadata":null,"children":null},{"name":"expected_format","type":"string","nullable":true,"metadata":null,"children":null},{"name":"mrf_url","type":"string","nullable":true,"metadata":null,"children":null},{"name":"snapshot_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"current_snapshot_available","type":"bool","nullable":true,"metadata":null,"children":null},{"name":"is_current_snapshot","type":"bool","nullable":true,"metadata":null,"children":null},{"name":"published_last_updated_on","type":"date32[day]","nullable":true,"metadata":null,"children":null},{"name":"snapshot_age_days","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"freshness_bucket","type":"string","nullable":true,"metadata":null,"children":null},{"name":"overall_readiness_score","type":"double","nullable":true,"metadata":null,"children":null},{"name":"freshness_score","type":"decimal128(3, 2)","nullable":true,"metadata":null,"children":null},{"name":"code_coverage_score","type":"double","nullable":true,"metadata":null,"children":null},{"name":"amount_coverage_score","type":"double","nullable":true,"metadata":null,"children":null},{"name":"payer_mapping_score","type":"double","nullable":true,"metadata":null,"children":null},{"name":"comparison_readiness_score","type":"double","nullable":true,"metadata":null,"children":null},{"name":"overall_readiness_rank","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"comparison_readiness_rank","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"payer_mapping_rank","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"data_confidence_band","type":"string","nullable":true,"metadata":null,"children":null},{"name":"charge_item_count","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"standard_charge_count","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"payer_rate_count","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"observation_count","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"distinct_comparable_codes","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"benchmark_context_count","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"benchmark_service_count","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"benchmark_services_meeting_floor","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"payer_contract_context_count","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"matched_payer_count","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"payer_contract_service_count","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"coded_item_coverage_rate","type":"double","nullable":true,"metadata":null,"children":null},{"name":"dollar_observation_coverage_rate","type":"double","nullable":true,"metadata":null,"children":null},{"name":"discounted_cash_coverage_rate","type":"double","nullable":true,"metadata":null,"children":null},{"name":"negotiated_dollar_coverage_rate","type":"double","nullable":true,"metadata":null,"children":null},{"name":"payer_mapping_coverage_rate","type":"double","nullable":true,"metadata":null,"children":null}],"parquet":"required group field_id=-1 duckdb_schema {\n  optional binary field_id=-1 hospital_id (String);\n  optional binary field_id=-1 hospital_display_name (String);\n  optional binary field_id=-1 canonical_state (String);\n  optional binary field_id=-1 hospital_type (String);\n  optional binary field_id=-1 health_system (String);\n  optional binary field_id=-1 canonical_state_name (String);\n  optional binary field_id=-1 canonical_census_region (String);\n  optional binary field_id=-1 canonical_census_division (String);\n  optional binary field_id=-1 expected_format (String);\n  optional binary field_id=-1 mrf_url (String);\n  optional binary field_id=-1 snapshot_id (String);\n  optional boolean field_id=-1 current_snapshot_available;\n  optional boolean field_id=-1 is_current_snapshot;\n  optional int32 field_id=-1 published_last_updated_on (Date);\n  optional int64 field_id=-1 snapshot_age_days (Int(bitWidth=64, isSigned=true));\n  optional binary field_id=-1 freshness_bucket (String);\n  optional double field_id=-1 overall_readiness_score;\n  optional int32 field_id=-1 freshness_score (Decimal(precision=3, scale=2));\n  optional double field_id=-1 code_coverage_score;\n  optional double field_id=-1 amount_coverage_score;\n  optional double field_id=-1 payer_mapping_score;\n  optional double field_id=-1 comparison_readiness_score;\n  optional int64 field_id=-1 overall_readiness_rank (Int(bitWidth=64, isSigned=true));\n  optional int64 field_id=-1 comparison_readiness_rank (Int(bitWidth=64, isSigned=true));\n  optional int64 field_id=-1 payer_mapping_rank (Int(bitWidth=64, isSigned=true));\n  optional binary field_id=-1 data_confidence_band (String);\n  optional int64 field_id=-1 charge_item_count (Int(bitWidth=64, isSigned=true));\n  optional int64 field_id=-1 standard_charge_count (Int(bitWidth=64, isSigned=true));\n  optional int64 field_id=-1 payer_rate_count (Int(bitWidth=64, isSigned=true));\n  optional int64 field_id=-1 observation_count (Int(bitWidth=64, isSigned=true));\n  optional int64 field_id=-1 distinct_comparable_codes (Int(bitWidth=64, isSigned=true));\n  optional int64 field_id=-1 benchmark_context_count (Int(bitWidth=64, isSigned=true));\n  optional int64 field_id=-1 benchmark_service_count (Int(bitWidth=64, isSigned=true));\n  optional int64 field_id=-1 benchmark_services_meeting_floor (Int(bitWidth=64, isSigned=true));\n  optional int64 field_id=-1 payer_contract_context_count (Int(bitWidth=64, isSigned=true));\n  optional int64 field_id=-1 matched_payer_count (Int(bitWidth=64, isSigned=true));\n  optional int64 field_id=-1 payer_contract_service_count (Int(bitWidth=64, isSigned=true));\n  optional double field_id=-1 coded_item_coverage_rate;\n  optional double field_id=-1 dollar_observation_coverage_rate;\n  optional double field_id=-1 discounted_cash_coverage_rate;\n  optional double field_id=-1 negotiated_dollar_coverage_rate;\n  optional double field_id=-1 payer_mapping_coverage_rate;\n}\n"},"kv_metadata":[]}
["vumc","Vanderbilt University Medical Center","TN","academic_medical_center","VUMC","Tennessee","South","East South Central","json","https://finance.vumc.org/assets/pub/pt/352528741_vanderbilt-university-medical-center_standardcharges.json","08654598-a2ff-4359-95bb-3cec4b58221c",true,true,"2025-10-01",289,"<=365d",0.7350171175511011,"0.50",0.9569785411286391,0.6629165336065542,0.9961600753759561,0.5590304376443564,12,11,1,"moderate",96417,96417,6495440,13374281,22821,70009,22480,2799,277792,28,22317,0.9569785411286391,0.6629165336065542,0.9698393436842051,0.9975927727759782,0.9961600753759561]
["vanderbilt-wilson-county","Vanderbilt Wilson County Hospital","TN","community","VUMC","Tennessee","South","East South Central","json","https://finance.vumc.org/assets/pub/pt/352528741_vanderbilt-wilson-county-hospital_standardcharges.json","834a916c-d8fe-49ec-9c31-3e197bb21007",true,true,"2025-10-01",289,"<=365d",0.7475576133802238,"0.50",0.997977876880028,0.6634217274319253,0.9955465506123046,0.5808419119768605,11,6,2,"moderate",91488,91488,4752945,8796364,22774,70952,22434,2786,281226,27,22294,0.997977876880028,0.6634217274319253,0.9680613850996852,0.9967815743712582,0.9955465506123046]
["tristar-northcrest","TriStar NorthCrest Medical Center","TN","for_profit","HCA Healthcare","Tennessee","South","East South Central","json","https://stctrprodsnsvc00455826e6.blob.core.windows.net/pt-final-posting-files/85-4366763_TRISTAR-NORTHCREST-MEDICAL-CENTER_standardcharges.json?si=pt-json-access-policy&spr=https&sv=2024-11-04&sr=c&sig=o5IofreS%2F7ETlsnhPakPWCwHVVUZRobywQ5wUKGjVuQ%3D","e3408759-6af2-44cf-80a5-5782cf6abbdc",true,true,"2026-03-01",138,"<=180d",0.8423831497234782,"0.75",0.989560021785905,0.9901318537007378,0.9305993233912839,0.5516245497394636,1,12,3,"moderate",185441,185441,1242668,1640227,15959,19500,15215,15203,105634,14,15108,0.989560021785905,0.9901318537007378,0.05145571906967715,0.9934873996916312,0.9305993233912839]
["tristar-ashland-city","TriStar Ashland City Medical Center","TN","for_profit","HCA Healthcare","Tennessee","South","East South Central","json","https://stctrprodsnsvc00455826e6.blob.core.windows.net/pt-final-posting-files/62-1113737_TRISTAR-ASHLAND-CITY-MEDICAL-CENTER_standardcharges.json?si=pt-json-access-policy&spr=https&sv=2024-11-04&sr=c&sig=o5IofreS%2F7ETlsnhPakPWCwHVVUZRobywQ5wUKGjVuQ%3D","13c7940f-24dd-4348-aaa4-cfa34d256594",true,true,"2026-03-01",138,"<=180d",0.8383469709163414,"0.75",0.9965710193758062,0.9858577548379504,0.9113199167181528,0.547986163649798,2,13,4,"moderate",217849,217849,1312651,1767329,18610,26580,17913,17911,121790,15,17920,0.9965710193758062,0.9858577548379504,0.01606158394117026,0.9904795714931082,0.9113199167181528]
["tristar-hendersonville","TriStar Hendersonville Medical Center","TN","for_profit","HCA Healthcare","Tennessee","South","East South Central","json","https://stctrprodsnsvc00455826e6.blob.core.windows.net/pt-final-posting-files/62-1321255_TRISTAR-HENDERSONVILLE-MEDICAL-CENTER_standardcharges.json?si=pt-json-access-policy&spr=https&sv=2024-11-04&sr=c&sig=o5IofreS%2F7ETlsnhPakPWCwHVVUZRobywQ5wUKGjVuQ%3D","a195fbb1-2bae-4398-a589-58a5f71d5ab4",true,true,"2026-03-01",138,"<=180d",0.8280201217859663,"0.75",0.9814970519847201,0.9861066851133616,0.849691056230166,0.572805815601583,3,9,5,"moderate",192672,192672,1625053,2058544,18693,27212,17995,17992,131233,14,17907,0.9814970519847201,0.9861066851133616,0.08853388141504734,0.9912002870060238,0.849691056230166]
["tristar-horizon","TriStar Horizon Medical Center","TN","for_profit","HCA Healthcare","Tennessee","South","East South Central","json","https://stctrprodsnsvc00455826e6.blob.core.windows.net/pt-final-posting-files/62-1620866_TRISTAR-HORIZON-MEDICAL-CENTER_standardcharges.json?si=pt-json-access-policy&spr=https&sv=2024-11-04&sr=c&sig=o5IofreS%2F7ETlsnhPakPWCwHVVUZRobywQ5wUKGjVuQ%3D","aeccb653-f359-4396-8d9a-d66d904a5d00",true,true,"2026-03-01",138,"<=180d",0.8257052784988888,"0.75",0.9860385591709149,0.9865576436071035,0.8398542343759119,0.5660759553405131,4,10,6,"moderate",190668,190668,1593517,2012296,19037,27426,18338,18330,133643,14,18256,0.9860385591709149,0.9865576436071035,0.0634715841147964,0.9915124846487361,0.8398542343759119]
["tristar-stonecrest","TriStar StoneCrest Medical Center","TN","for_profit","HCA Healthcare","Tennessee","South","East South Central","json","https://stctrprodsnsvc00455826e6.blob.core.windows.net/pt-final-posting-files/62-1113737_TRISTAR-STONECREST-MEDICAL-CENTER_standardcharges.json?si=pt-json-access-policy&spr=https&sv=2024-11-04&sr=c&sig=o5IofreS%2F7ETlsnhPakPWCwHVVUZRobywQ5wUKGjVuQ%3D","e3bbdd09-742f-45ee-9300-456501fbe1bf",true,true,"2026-03-12",127,"<=180d",0.8230102611389389,"0.75",0.9712698156589085,0.9883307739334216,0.831862652826048,0.5735880632763168,5,8,7,"moderate",198328,198328,1742504,2198432,18706,27628,18008,17987,131244,14,17907,0.9712698156589085,0.9883307739334216,0.117774595619378,0.9926387543443229,0.831862652826048]
["tristar-southern-hills","TriStar Southern Hills Medical Center","TN","for_profit","HCA Healthcare","Tennessee","South","East South Central","json","https://stctrprodsnsvc00455826e6.blob.core.windows.net/pt-final-posting-files/62-1113737_TRISTAR-SOUTHERN-HILLS-MEDICAL-CENTER_standardcharges.json?si=pt-json-access-policy&spr=https&sv=2024-11-04&sr=c&sig=o5IofreS%2F7ETlsnhPakPWCwHVVUZRobywQ5wUKGjVuQ%3D","c7a94f7f-231c-4558-bd8f-a824eb7addd4",true,true,"2026-03-12",127,"<=180d",0.8180944917711571,"0.75",0.9743610088967795,0.9894384734453296,0.7979991430996264,0.5786738334140502,6,7,8,"moderate",201646,201646,1827517,2286980,19041,27926,18342,18339,134444,15,18256,0.9743610088967795,0.9894384734453296,0.1101980698848477,0.9933915799415273,0.7979991430996264]
["tristar-summit","TriStar Summit Medical Center","TN","for_profit","HCA Healthcare","Tennessee","South","East South Central","json","https://stctrprodsnsvc00455826e6.blob.core.windows.net/pt-final-posting-files/62-1113737_TRISTAR-SUMMIT-MEDICAL-CENTER_standardcharges.json?si=pt-json-access-policy&spr=https&sv=2024-11-04&sr=c&sig=o5IofreS%2F7ETlsnhPakPWCwHVVUZRobywQ5wUKGjVuQ%3D","8b258eb8-c8c3-486a-b7af-19ebb3e89cd8",true,true,"2026-03-01",138,"<=180d",0.8117136626390836,"0.75",0.97169006739996,0.9889194756256591,0.7607213373700145,0.5872374327997851,7,3,9,"moderate",205193,205193,1975220,2453133,19058,28045,18358,18350,134434,15,18256,0.97169006739996,0.9889194756256591,0.13203666791752156,0.9931192474762305,0.7607213373700145]
["tristar-skyline","TriStar Skyline Medical Center","TN","for_profit","HCA Healthcare","Tennessee","South","East South Central","json","https://stctrprodsnsvc00455826e6.blob.core.windows.net/pt-final-posting-files/62-1560757_TRISTAR-SKYLINE-MEDICAL-CENTER_standardcharges.json?si=pt-json-access-policy&spr=https&sv=2024-11-04&sr=c&sig=o5IofreS%2F7ETlsnhPakPWCwHVVUZRobywQ5wUKGjVuQ%3D","be744f02-b2a2-4a4e-b601-b309dc96f916",true,true,"2026-03-12",127,"<=180d",0.8096606576874684,"0.75",0.9678594283019867,0.9894639700096437,0.7501153975981032,0.5908644925276084,8,2,10,"moderate",207837,207837,1967112,2456523,19063,28493,18364,18344,134351,15,18253,0.9678594283019867,0.9894639700096437,0.14703349259275297,0.993421320189191,0.7501153975981032]
["williamson-medical-center","Williamson Medical Center","TN","community","Williamson Health","Tennessee","South","East South Central","csv_wide","https://williamsonhealth.org/content/uploads/2026/04/621501534_williamson-medical-center_standardcharges.csv","1239eb80-0c37-4198-b846-2fdb253054a2",true,true,null,null,"unknown",0.6214167197123356,"0.00",0.9999671668253604,0.7802364920168938,0.7441826764667071,0.5826972632527163,13,5,11,"limited",30457,72910,1235233,1832620,19916,50365,19492,0,237045,10,17617,0.9999671668253604,0.7802364920168938,0.33482375531477165,1.0,0.7441826764667071]
["tristar-centennial","TriStar Centennial Medical Center","TN","for_profit","HCA Healthcare","Tennessee","South","East South Central","json","https://stctrprodsnsvc00455826e6.blob.core.windows.net/pt-final-posting-files/62-1113737_TRISTAR-CENTENNIAL-MEDICAL-CENTER_standardcharges.json?si=dpx-pt-json-access-policy&spr=https&sv=2024-11-04&sr=c&sig=vdmkLz8lCE1qb%2BnsaFfL8tcI7Gg6B%2B3s%2Fny3TPZ1kqs%3D","83a1dd53-e49b-4c94-b887-03553ba740bd",true,true,"2026-03-01",138,"<=180d",0.7749292670077383,"0.75",0.9132910062021825,0.9902088964307816,0.6373690703567763,0.5837773620489518,9,4,12,"moderate",394861,394861,3069683,4159286,18790,28799,18040,17999,138079,16,17907,0.9132910062021825,0.9902088964307816,0.36207424891290857,0.9933667417775711,0.6373690703567763]
["nashville-general","Metro Nashville General Hospital","TN","community","Nashville General Hospital","Tennessee","South","East South Central","csv_tall","https://nashvillegeneral-440111.s3.amazonaws.com/62-1383977_METRO-NASHVILLE-GENERAL-HOSPITAL_standardcharges.csv","37858590-6c7b-4b1b-be1b-d4fd6fb23a7d",true,true,"2024-07-01",746,">365d",0.7640331810499296,"0.25",0.9995799495939512,1.0,0.5707868269348706,0.9997991287208265,10,1,13,"moderate",7142,7224,130448,159306,2351,9159,2351,2033,18854,8,2299,0.9995799495939512,1.0,0.9973698781838317,1.0,0.5707868269348706]
["maury-regional","Maury Regional Medical Center","TN","nonprofit","Maury Regional Health","Tennessee","South","East South Central","csv_wide","https://www.mauryregional.com/clientfiles/getfile/626002623_maury-regional-medical-center_standardcharges.csv","b7b4bbe0-ea6b-4e73-9619-b271ecb2cda2",true,true,null,null,"unknown",0.5209057051063384,"0.00",0.9999645207642227,0.659015221863062,0.40169073172295994,0.5438580511814471,14,14,14,"limited",56371,110340,1060251,2126875,38653,77136,28087,0,106642,8,14957,0.9999645207642227,0.659015221863062,0.54700018125793,1.0,0.40169073172295994]