Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

4,766 rows sorted by fy_end_date

View and edit SQL

Link rowid hospital_name address city state zip_code county_name phone_number hospital_type hospital_ownership emergency_services lat lng geocode_flag geocode_accuracy countyfips statefips statecountyfips cbsacode csatitle centraloutlyingcounty countyequivalent hosp_lookup_url PRVDR_NUM RPT_REC_NUM filed_date fy_end_date ▼ acute_beds icu_beds coronary_beds burn_beds surg_icu_beds oth_spec_beds subtotal_acute_beds subprovider_ipf_beds subprovider_irf_beds subprovider_oth_beds skilled_nursing_beds nursing_fac_beds oth_longterm_beds hospice_beds all_beds
810 COALINGA REGIONAL MEDICAL CENTER 1191 PHELPS AVENUE COALINGA CA 93210 FRESNO (559) 935-6400 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.1515170 -120.3420890 0   19 6 6019 23420 Fresno-Madera, CA Central Fresno County https://data.medicare.gov/resource/xubh-q36u/row-6rbr~b9je.7rdb 50397 656406 2018-12-03 2018-06-30 22           22       114       136
851 CAVALIER COUNTY MEMORIAL HOSPITAL ASSOCIATION 909 2ND ST LANGDON ND 58249 CAVALIER (701) 256-6100 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.7612430 -98.3666610 0   19 38 38019         https://data.medicare.gov/resource/xubh-q36u/row-m8nv.tvsx-unkm 351323 638003 2018-11-28 2018-06-30 20           20               20
856 BUTLER MEMORIAL HOSPITAL ONE HOSPITAL WAY BUTLER PA 16001 BUTLER (724) 283-6666 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8672740 -79.8805124 1 ROOFTOP 19 42 42019 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Butler County https://data.medicare.gov/resource/xubh-q36u/row-3qh5.b2vu-gny9 390168 657465 2018-12-03 2018-06-30 232 35         267 21     25       313
858 MUSC MEDICAL CENTER 169 ASHLEY AVE CHARLESTON SC 29425 CHARLESTON (843) 792-2300 Acute Care Hospitals Government - State TRUE 32.7854000 -79.9465590 0   19 45 45019 16700   Central Charleston County https://data.medicare.gov/resource/xubh-q36u/row-yb9w~4mxa-yhfk 420004 662071 2019-08-30 2018-06-30 502 114       66 682 98             780
912 GLENDIVE MEDICAL CENTER 202 PROSPECT DR GLENDIVE MT 59330 DAWSON (406) 345-3306 Critical Access Hospitals Voluntary non-profit - Other TRUE 47.1172260 -104.7049530 0   21 30 30021         https://data.medicare.gov/resource/xubh-q36u/row-x469.qqvr~n68h 271332 642881 2019-02-07 2018-06-30 22 3         25       56       81
914 MOUNT GRANT GENERAL HOSPITAL 200 SOUTH A ST HAWTHORNE NV 89415 MINERAL (702) 945-2461 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.5166320 -118.6284520 0   21 32 32021         https://data.medicare.gov/resource/xubh-q36u/row-dzph~qsgj~bgaf 291300 652888 2018-12-04 2018-06-30 11           11       24       35
974 ST LUKE'S HOSPITAL 702 1ST ST SW CROSBY ND 58730 DIVIDE (701) 965-6384 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.9067080 -103.2982300 0   23 38 38023         https://data.medicare.gov/resource/xubh-q36u/row-pn67~uvq9.k3y8 351325 638546 2018-11-26 2018-06-30 15           15       40       55
982 CENTRAL VALLEY MEDICAL CENTER - CAH 48 WEST 1500 NORTH NEPHI UT 84648 JUAB (435) 623-3000 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.7305870 -111.8372150 0   23 49 49023 39340 Salt Lake City-Provo-Orem, UT Outlying Juab County https://data.medicare.gov/resource/xubh-q36u/row-chs9.w8rs-dsc2 461304 637950 2018-11-21 2018-06-30 25           25               25
1120 NIOBRARA HEALTH & LIFE CENTER 921 SOUTH BALLANCEE AVENUE LUSK WY 82225 NIOBRARA (307) 334-4000 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.7532780 -104.4460830 0   27 56 56027         https://data.medicare.gov/resource/xubh-q36u/row-ee9k~358g.gwyk 531314 640304 2018-12-03 2018-06-30 24           24               24
1131 KERN VALLEY HEALTHCARE DISTRICT 6412 LAUREL AVE LAKE ISABELLA CA 93240 KERN (760) 379-2681 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.6353510 -118.4063000 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-vmmb-dmgx.ncbv 51314 652738 2018-12-04 2018-06-30 24           24       74       98
1195 CODY REGIONAL HEALTH 707 SHERIDAN AVENUE CODY WY 82414 PARK (307) 578-2488 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.5260710 -109.0735760 0   29 56 56029         https://data.medicare.gov/resource/xubh-q36u/row-hbhj.vs4q~3zsw 531312 638925 2018-12-03 2018-06-30 21 4         25       94       119
1357 UNIVERSITY OF WASHINGTON MEDICAL CTR 1959 NE PACIFIC ST BOX 356151 SEATTLE WA 98195 KING (206) 598-3300 Acute Care Hospitals Government - State TRUE 47.6505060 -122.3074820 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-gezf_iitw.mxe8 500008 661427 2018-11-29 2018-06-30 209 81       50 408 16 18           442
1358 OVERLAKE HOSPITAL MEDICAL CENTER 1035-116TH AVE NE BELLEVUE WA 98004 KING (425) 688-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 47.6208736 -122.1868731 1 GEOMETRIC_CENTER 33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-rzza-8dw4_494p 500051 658006 2019-01-09 2018-06-30 237 32         286 14             300
1459 TORRANCE MEMORIAL MEDICAL CENTER 3330 LOMITA BLVD TORRANCE CA 90509 LOS ANGELES (310) 325-9110 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.8126440 -118.3437500 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-cibe~cfxf_9r58 50351 640468 2018-11-30 2018-06-30 391 44   12   25 472       40       512
1468 CATALINA ISLAND MEDICAL CENTER 100 FALLS CANYON ROAD AVALON CA 90704 LOS ANGELES (310) 510-0700 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.3390790 -118.3304770 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-8vi9~ashp_y9rx 51307 638364 2018-11-29 2018-06-30 8           8       4       12
1471 CEDARS-SINAI MEDICAL CENTER 8700 BEVERLY BLVD LOS ANGELES CA 90048 LOS ANGELES (310) 423-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.0754960 -118.3801220 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-pkaz~e2ny_94bc 50625 662348 2018-11-21 2018-06-30 709 48 18   24 24 880               880
1474 MARTIN LUTHER KING, JR. COMMUNITY HOSPITAL 1680 EAST 120TH STREET LOS ANGELES CA 90059 LOS ANGELES (424) 835-6808 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.9243610 -118.2443310 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-wqas_evtp_8i7y 50779 662351 2018-11-29 2018-06-30 111 20         131               131
1479 WHITTIER HOSPITAL MEDICAL CENTER 9080 COLIMA RD WHITTIER CA 90605 LOS ANGELES (562) 945-3561 Acute Care Hospitals Proprietary TRUE 33.9507480 -118.0051140 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-4rmv_824x.pbwt 50735 657693 2018-12-03 2018-06-30 140 16         156       22       178
1483 LAC/RANCHO LOS AMIGOS NATIONAL REHABILITATION CTR 7601 EAST IMPERIAL HIGHWAY DOWNEY CA 90242 LOS ANGELES (562) 401-7022 Acute Care Hospitals Government - Local FALSE 33.9293317 -118.1585885 1 ROOFTOP 37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-rfj5_pyf7~7bni 50717 662350 2018-12-03 2018-06-30 89 12         101   109           210
1488 GLENDALE MEM HOSPITAL & HLTH CENTER 1420 S CENTRAL AVE GLENDALE CA 91204 LOS ANGELES (818) 502-1900 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1277890 -118.2577950 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-7nps-ge35~jh8j 50058 657613 2018-12-03 2018-06-30 204 24       13 241 49 14       30   334
1560 LAKE DISTRICT HOSPITAL 700 SOUTH J STREET LAKEVIEW OR 97630 LAKE (541) 947-2114 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.1815830 -120.3514370 0   37 41 41037         https://data.medicare.gov/resource/xubh-q36u/row-2rpx~hmxp~n924 381309 640591 2018-12-10 2018-06-30 24           24               24
1582 MADERA COMMUNITY HOSPITAL 1250 E ALMOND AVE MADERA CA 93637 MADERA (559) 675-5555 Acute Care Hospitals Voluntary non-profit - Other FALSE 36.9454270 -120.0454670 0   39 6 6039 31460 Fresno-Madera, CA Central Madera County https://data.medicare.gov/resource/xubh-q36u/row-zgse.huz6_3uyv 50568 656247 2018-12-12 2018-06-30 96 10         106               106
1595 GRANITE COUNTY MEDICAL CENTER 310 SANSOME ST PHILIPSBURG MT 59858 GRANITE (406) 859-3271 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.3327550 -113.2942070 0   39 30 30039         https://data.medicare.gov/resource/xubh-q36u/row-wazi~b6n6_xzju 271303 640231 2018-12-03 2018-06-30 25           25               25
1612 PEACEHEALTH COTTAGE GROVE COMMUNITY MEDICAL CENTER 1515 VILLAGE DRIVE COTTAGE GROVE OR 97424 LANE (541) 767-5202 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.8038370 -123.0386760 0   39 41 41039 21660   Central Lane County https://data.medicare.gov/resource/xubh-q36u/row-6buq_rs3k.th8r 381301 640536 2018-11-30 2018-06-30 14           14               14
1764 BOWDLE HOSPITAL - CAH 8001 W 5TH POST OFFICE BOX 556 BOWDLE SD 57428 EDMUNDS (605) 285-6146 Critical Access Hospitals Government - Local TRUE 45.4480531 -99.6609364 1 ROOFTOP 45 46 46045 10100   Outlying Edmunds County https://data.medicare.gov/resource/xubh-q36u/row-q6h5.bajv_fkde 431318 637935 2018-11-26 2018-06-30 12           12       34       46
1770 WESTON COUNTY HEALTH SERVICES 1124 WASHINGTON BOULEVARD NEWCASTLE WY 82701 WESTON (307) 746-4491 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.8487470 -104.1887560 0   45 56 56045         https://data.medicare.gov/resource/xubh-q36u/row-jibn-3jkh~ba9g 531303 640299 2018-12-03 2018-06-30 12           12       58       70
1969 MCKENZIE COUNTY HEALTHCARE SYSTEMS INC 709 4TH AVE NE WATFORD CITY ND 58854 MCKENZIE (701) 842-3000 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.8046820 -103.2713580 0   53 38 38053         https://data.medicare.gov/resource/xubh-q36u/row-ph32.gcyn.yevx 351302 652530 2018-12-03 2018-06-30 24           24       47       71
2032 CHI ST ALEXIUS HEALTH TURTLE LAKE 220 5TH AVE W TURTLE LAKE ND 58575 MCLEAN (701) 448-2331 Critical Access Hospitals Voluntary non-profit - Church TRUE 47.5179250 -100.8944420 0   55 38 38055         https://data.medicare.gov/resource/xubh-q36u/row-w8fb-47fy-9nzg 351304 640251 2018-12-03 2018-06-30 25           25               25
2041 PEACEHEALTH PEACE ISLAND MEDICAL CENTER 1117 SPRING STREET FRIDAY HARBOR WA 98250 SAN JUAN (360) 378-2141 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.5298570 -123.0281710 0   55 53 53055         https://data.medicare.gov/resource/xubh-q36u/row-tq94~fpij_9q58 501340 640562 2018-11-30 2018-06-30 10           10               10
2093 PEACEHEALTH UNITED GENERAL MEDICAL CENTER 2000 HOSPITAL DRIVE SEDRO WOOLLEY WA 98284 SKAGIT (360) 856-6021 Critical Access Hospitals Government - Hospital District or Authority TRUE 48.4955160 -122.2752870 0   57 53 53057 34580 Seattle-Tacoma, WA Central Skagit County https://data.medicare.gov/resource/xubh-q36u/row-bxir_c4z7.hk8y 501329 640561 2018-11-30 2018-06-30 25           25               25
2113 CHILDREN'S HOSPITAL AT MISSION 27700 MEDICAL CENTER RD, 5TH FLOOR MISSION VIEJO CA 92691 ORANGE (949) 365-2408 Childrens Voluntary non-profit - Private TRUE 33.5610153 -117.6653937 1 ROOFTOP 59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-ux4n.c7cr-d5uw 53306 659086 2018-11-30 2018-06-30                              
2127 FAIRVIEW DEVELOPMENTAL CENTER 2501 HARBOR BOULEVARD COSTA MESA CA 92626 ORANGE (714) 957-5000 Acute Care Hospitals Government - Local FALSE 33.6649120 -117.9192670 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-gyrb-ji8k_8vsj 50548 638176 2018-11-27 2018-06-30 30           30           1151   1181
2241 PLUMAS DISTRICT HOSPITAL 1065 BUCKS LAKE ROAD QUINCY CA 95971 PLUMAS (530) 283-2121 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.9347670 -120.9192510 0   63 6 6063         https://data.medicare.gov/resource/xubh-q36u/row-k6tt~sk6g~887z 51326 640492 2018-12-13 2018-06-30 23           23               23
2265 NELSON COUNTY HEALTH SYSTEM 200 N MAIN ST MCVILLE ND 58254 NELSON (701) 322-4328 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.7656260 -98.1773140 0   63 38 38063         https://data.medicare.gov/resource/xubh-q36u/row-mxe5_p48x_qufq 351308 640252 2018-11-29 2018-06-30 19           19       39       58
2286 RIVERSIDE UNIVERSITY HEALTH SYSTEM-MEDICAL CENTER 26520 CACTUS AVENUE MORENO VALLEY CA 92555 RIVERSIDE (951) 486-4000 Acute Care Hospitals Government - Local TRUE 33.9100540 -117.1958240 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-h5qt.qee8.h53s 50292 662336 2018-12-28 2018-06-30 354 45       8 439               439
2288 PALO VERDE HOSPITAL 250 NORTH FIRST STREET BLYTHE CA 92225 RIVERSIDE (760) 922-4115 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.6124500 -114.5954790 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-ekup.vqie~g6zn 50423 658138 2018-11-28 2018-06-30 47 4         51               51
2295 LOMA LINDA UNIVERSITY MEDICAL CENTER-MURRIETA 28062 BAXTER ROAD MURRIETA CA 92563 RIVERSIDE (951) 290-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6134350 -117.1689230 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-2wpb~hess-t7nh 50770 657700 2019-01-18 2018-06-30 94 12       6 112               112
2332 METHODIST HOSPITAL OF SACRAMENTO 7500 HOSPITAL DRIVE SACRAMENTO CA 95823 SACRAMENTO (916) 423-6010 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.4642320 -121.4163330 0   67 6 6067 40900 Sacramento-Roseville, CA Central Sacramento County https://data.medicare.gov/resource/xubh-q36u/row-3qei-q8un_3r8f 50590 657683 2018-12-03 2018-06-30 126 20       12 158       171       329
2371 TUALITY COMMUNITY HOSPITAL 335 SE 8TH AVENUE HILLSBORO OR 97123 WASHINGTON (503) 681-1111 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5196230 -122.9773100 0   67 41 41067 38900 Portland-Vancouver-Salem, OR-WA Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-x4zr_f9jw.9qwd 380021 662242 2018-11-30 2018-06-30 165 29         194 21             215
2434 MOUNTAINS COMMUNITY HOSPITAL 29101 HOSPITAL ROAD LAKE ARROWHEAD CA 92352 SAN BERNARDINO (909) 336-3651 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.2659000 -117.1670920 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-z5bb_6v2j.847b 51312 659479 2019-01-07 2018-06-30 17           17       20       37
2546 ELLWOOD CITY MEDICAL CENTER 724 PERSHING STREET ELLWOOD CITY PA 16117 LAWRENCE (724) 752-0081 Acute Care Hospitals Proprietary TRUE 40.8693490 -80.2744790 0   73 42 42073 35260 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-k638_yc9y~2hzs 390008 640799 2019-01-10 2018-06-30 46 6         52 10             62
2552 ST JOSEPH HOSPITAL 2901 SQUALICUM PARKWAY BELLINGHAM WA 98225 WHATCOM (360) 734-5400 Acute Care Hospitals Voluntary non-profit - Other TRUE 48.7722780 -122.4748780 0   73 53 53073 13380   Central Whatcom County https://data.medicare.gov/resource/xubh-q36u/row-xf7q~fgxx.c5xi 500030 662286 2018-11-30 2018-06-30 183 24         207 20 14           241
2683 SAN MATEO MEDICAL CENTER 222 W 39TH AVE SAN MATEO CA 94403 SAN MATEO (650) 573-2222 Acute Care Hospitals Government - Local TRUE 37.5301160 -122.2994060 0   81 6 6081 41860 San Jose-San Francisco-Oakland, CA Central San Mateo County https://data.medicare.gov/resource/xubh-q36u/row-n83i.z2gh_aca4 50113 660755 2018-12-03 2018-06-30 93 7         100 34     374       508
2708 MARCUS DALY MEMORIAL HOSPITAL - CAH 1200 WESTWOOD DR HAMILTON MT 59840 RAVALLI (406) 375-4408 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.2471580 -114.1713650 0   81 30 30081         https://data.medicare.gov/resource/xubh-q36u/row-r262~sb7s_y9sk 271340 640517 2018-12-04 2018-06-30 20 5         25               31
2759 SAMARITAN HOSPITAL-ST MARY'S CAMPUS 1300 MASSACHUSETTS AVENUE TROY NY 12180 RENSSELAER (518) 268-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.7439770 -73.6764150 0   83 36 36083 10580 Albany-Schenectady, NY Central Rensselaer County https://data.medicare.gov/resource/xubh-q36u/row-23ud-7iuq.i6ww 330232 660842 2019-11-18 2018-06-30 20           20               20
2769 AVERA HEART HOSPITAL OF SOUTH DAKOTA 4500 W 69TH ST SIOUX FALLS SD 57108 LINCOLN (605) 977-7000 Acute Care Hospitals Proprietary TRUE 43.4899220 -96.7809060 0   83 46 46083 43620   Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-rh7v_8wee~ws72 430095 658587 2018-12-03 2018-06-30 53           53               53
2776 EL CAMINO HOSPITAL 2500 GRANT ROAD MOUNTAIN VIEW CA 94040 SANTA CLARA (650) 940-7000 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.3693410 -122.0779330 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-pztm_52rg~xmku 50308 662338 2018-11-30 2018-06-30 303 39         388 25 30           443
2778 ST LOUISE REGIONAL HOSPITAL 9400 NO NAME UNO GILROY CA 95020 SANTA CLARA (408) 848-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.0351100 -121.5730380 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-bxa9-aaz9_2d3g 50688 658156 2018-11-29 2018-06-30 64 8         72               72
2783 O'CONNOR HOSPITAL 2105 FOREST AVENUE SAN JOSE CA 95128 SANTA CLARA (408) 947-2500 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3270540 -121.9371540 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-e67s~ymzp~sv3q 50153 656228 2018-11-29 2018-06-30 302 22         324       24       348
2882 MERCY MEDICAL CENTER REDDING 2175 ROSALINE AVE, CLAIRMONT HGTS REDDING CA 96001 SHASTA (530) 225-6102 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5719533 -122.3952328 1 ROOFTOP 89 6 6089 39820 Redding-Red Bluff, CA Central Shasta County https://data.medicare.gov/resource/xubh-q36u/row-y47u-62yf~3uib 50280 657650 2019-07-01 2018-06-30 202 44       16 262               262
2919 MARGARET R PARDEE MEMORIAL HOSPITAL 800 N JUSTICE ST HENDERSONVILLE NC 28791 HENDERSON (828) 696-1000 Acute Care Hospitals Government - Local TRUE 35.3208140 -82.4681530 0   89 37 37089 11700 Asheville-Brevard, NC Central Henderson County https://data.medicare.gov/resource/xubh-q36u/row-zt42_agis.ksd3 340017 658528 2018-11-29 2018-06-30 147 13         160               160
3058 TOWNER COUNTY MEDICAL CENTER HWY 281 N CANDO ND 58324 TOWNER (701) 968-4411 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.4931522 -99.2110430 1 ROOFTOP 95 38 38095         https://data.medicare.gov/resource/xubh-q36u/row-8pd6_eppf-kx3r 351331 638004 2018-11-28 2018-06-30 20           20       30   5   55
3080 SONOMA DEVELOPMENTAL CENTER 15000 ARNOLD DRIVE / P O BOX 1493 ELDRIDGE CA 95431 SONOMA (707) 938-6000 Acute Care Hospitals Government - State FALSE 38.3490270 -122.5169100 0   97 6 6097 42220 San Jose-San Francisco-Oakland, CA Central Sonoma County https://data.medicare.gov/resource/xubh-q36u/row-j6wx.73xx-wqrm 50547 638175 2018-11-27 2018-06-30 13           13           963   976
3114 PIONEER MEDICAL CENTER 301 W 7TH AVE BIG TIMBER MT 59011 SWEET GRASS (406) 932-4603 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.8284800 -109.9524270 0   97 30 30097         https://data.medicare.gov/resource/xubh-q36u/row-y6u6-i6dq_6uh8 271313 639315 2018-12-03 2018-06-30 25           25               25
3180 LIFESCAPE 2501 W 26TH ST SIOUX FALLS SD 57105 MINNEHAHA (605) 444-9500 Childrens Voluntary non-profit - Private FALSE 43.5294580 -96.7562080 0   99 46 46099 43620   Central Minnehaha County https://data.medicare.gov/resource/xubh-q36u/row-iuzk-vbys_y5he 433300 654864 2018-11-19 2018-06-30                              
3192 PARKVIEW MEDICAL CENTER, INC 400 W 16TH ST PUEBLO CO 81003 PUEBLO (719) 584-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.2816780 -104.6121230 0   101 8 8101 39380 Pueblo-Cañon City, CO Central Pueblo County https://data.medicare.gov/resource/xubh-q36u/row-6kae.fdwt~txeq 60020 656879 2018-11-28 2018-06-30 233 12       11 276 35 15           326
3226 JEANES HOSPITAL 7600 CENTRAL AVENUE PHILADELPHIA PA 19111 PHILADELPHIA (215) 728-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0690710 -75.0865510 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-ffib_n7hw-d6uu 390080 657948 2018-12-03 2018-06-30 126 20         146               146
3289 REGIONAL HEALTH RAPID CITY HOSPITAL 353 FAIRMONT BLVD POST OFFICE BOX 6000 RAPID CITY SD 57701 PENNINGTON (605) 755-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.0586100 -103.2249640 0   103 46 46103 39660 Rapid City-Spearfish, SD Central Pennington County https://data.medicare.gov/resource/xubh-q36u/row-2zks_fxav-k73q 430077 658789 2018-11-27 2018-06-30 305 38         371   16           387
3302 ADVENTHEALTH HEART OF FLORIDA 40100 HWY 27 DAVENPORT FL 33837 POLK (863) 422-4971 Acute Care Hospitals Proprietary TRUE 28.1803340 -81.6399540 0   105 12 12105 29460   Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-febs~ded9_jd7n 100137 656903 2018-12-03 2018-06-30 178 15         193               193
3338 PORTERVILLE DEVELOPMENTAL CENTER 26501 AVENUE 140 PORTERVILLE CA 93257 TULARE (559) 782-2222 Acute Care Hospitals Government - State FALSE 36.0439080 -118.9804830 0   107 6 6107 47300 Visalia-Porterville-Hanford, CA Central Tulare County https://data.medicare.gov/resource/xubh-q36u/row-8jhm_m9d6-frtp 50546 638174 2018-11-27 2018-06-30 44           44           1182   1226
3420 VENTURA COUNTY MEDICAL CENTER 300 HILLMONT AVENUE VENTURA CA 93003 VENTURA (805) 652-6075 Acute Care Hospitals Government - Local TRUE 34.2790550 -119.2543550 0   111 6 6111 37100 Los Angeles-Long Beach, CA Central Ventura County https://data.medicare.gov/resource/xubh-q36u/row-8hxa_nmwp_zdmb 50159 662323 2018-12-03 2018-06-30 196 52       24 272               272
3425 NORTHWESTERN MEDICINE MCHENRY HOSPITAL 4201 MEDICAL CENTER DRIVE MCHENRY IL 60050 MC HENRY (815) 344-5000 Acute Care Hospitals Voluntary non-profit - Other FALSE 42.3189000 -88.2797870 0   111 17 17111 16980 Chicago-Naperville, IL-IN-WI Central McHenry County https://data.medicare.gov/resource/xubh-q36u/row-kudg.ki8v.vy8u 140116 661720 2018-11-29 2018-06-30 234 30         264   22           286
3480 DAYTON CHILDREN'S HOSPITAL ONE CHILDRENS PLAZA DAYTON OH 45404 MONTGOMERY (937) 641-3450 Childrens Voluntary non-profit - Private TRUE 39.7742909 -84.1676062 1 ROOFTOP 113 39 39113 19380 Dayton-Springfield-Sidney, OH Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-m72e~a4zq_2h8h 363306 655032 2018-12-04 2018-06-30 109 34       34 177               177
3582 NORTH METRO MEDICAL CENTER 1400 BRADEN STREET JACKSONVILLE AR 72076 PULASKI (501) 985-7000 Acute Care Hospitals Proprietary TRUE 34.8723810 -92.1246970 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-fmp5~srts-kxcs 40074 656863 2018-12-06 2018-06-30 47           47 31             78
3766 UNIVERSITY PEDIATRIC HOSPITAL PUERTO RICO MEDICAL CENTER IN RIO PIEDRAS SAN JUAN PR 935 SAN JUAN (787) 777-3232 Childrens Government - State TRUE 18.3958646 -66.0736306 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-aat9~yvnm_fjvd 403301 640173 2018-11-30 2018-06-30                              
3778 CENTRO CARDIOVASCULAR AVENIDA AMERICO MIRANDA, ENTRADA PRINCIPAL CM RIO PIEDRAS PR 936 SAN JUAN (787) 754-8500 Acute Care Hospitals Government - State FALSE 18.3997905 -66.0681500 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-n57n_rm6c-sekq 400124 639357 2018-12-12 2018-06-30 114 50         164               164
3800 MERCY HOSPITAL FORT SMITH 7301 ROGERS AVE FORT SMITH AR 72903 SEBASTIAN (479) 314-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.3536470 -94.3529640 0   131 5 5131 22900   Central Sebastian County https://data.medicare.gov/resource/xubh-q36u/row-2a77_rb9f.j48w 40062 661700 2018-11-30 2018-06-30 280 38         343   42           400
3840 WELLSPAN SURGERY AND REHABILITATION HOSPITAL 55 MONUMENT ROAD YORK PA 17403 YORK (717) 812-6100 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.9232770 -76.7168980 0   133 42 42133 49620 Harrisburg-York-Lebanon, PA Central York County https://data.medicare.gov/resource/xubh-q36u/row-vz8h~6tdd.rzsw 390327 655835 2018-11-29 2018-06-30 25           25   48           73
3862 AVERA SACRED HEART HOSPITAL 501 SUMMIT ST YANKTON SD 57078 YANKTON (605) 668-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.8725730 -97.4069450 0   135 46 46135 49460   Central Yankton County https://data.medicare.gov/resource/xubh-q36u/row-p2ay-ses4.gzui 430012 656749 2018-11-30 2018-06-30 65 10         75       187       262
4011 DARDANELLE HOSPITAL 200 NORTH THIRD STREET DARDANELLE AR 72834 YELL (479) 229-4677 Critical Access Hospitals Proprietary TRUE 35.2209170 -93.1569870 0   149 5 5149 40780   Outlying Yell County https://data.medicare.gov/resource/xubh-q36u/row-u9x6_diim.h7v6 41302 639835 2018-12-26 2018-06-30 25           25 10             35
4204 HEGG MEMORIAL HEALTH CENTER 1202 21ST AVENUE ROCK VALLEY IA 51247 SIOUX (712) 476-8000 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.2016930 -96.2850860 0   167 19 19167         https://data.medicare.gov/resource/xubh-q36u/row-5p5r_j23k-rsrv 161336 639251 2018-12-03 2018-06-30 25           25           60   85
4484 SITKA COMMUNITY HOSPITAL 209 MOLLER DRIVE SITKA AK 99835 SITKA BOROUGH (907) 747-3241 Critical Access Hospitals Government - Local TRUE 57.0589920 -135.3459290 0   220 2 2220         https://data.medicare.gov/resource/xubh-q36u/row-asew~ba2y_nt2p 21303 638783 2018-12-03 2018-06-30 12           12       15       27
197 MESA VIEW REGIONAL HOSPITAL 1299 BERTHA HOWE AVENUE MESQUITE NV 89027 CLARK (702) 346-8040 Critical Access Hospitals Proprietary TRUE 36.8088590 -114.1144560 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-8rk4-cq3s_fa8n 291307 640239 2018-12-18 2018-07-31 21 4         25               25
560 HACIENDA CHILDREN'S HOSPITAL, INC. 610 WEST JEROME AVENUE MESA AZ 85210 MARICOPA (602) 243-4231 Childrens Proprietary FALSE 33.3811280 -111.8448920 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-r4wv.uiyn_d6cn 33303 654954 2018-11-26 2018-07-31                              
697 PARKLAND MEDICAL CENTER 1 PARKLAND DRIVE DERRY NH 3038 ROCKINGHAM (603) 421-2100 Acute Care Hospitals Proprietary TRUE 42.8758250 -71.3175780 0   15 33 33015 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Rockingham County https://data.medicare.gov/resource/xubh-q36u/row-m9nh.dqhg_kjyp 300017 659515 2019-11-07 2018-07-31 60 8         68 18             86
731 DORMINY MEDICAL CENTER 200 PERRY HOUSE ROAD, BOX 1447 FITZGERALD GA 31750 BEN HILL (229) 424-7100 Acute Care Hospitals Government - Local TRUE 31.6979180 -83.2609750 0   17 13 13017 22340   Central Ben Hill County https://data.medicare.gov/resource/xubh-q36u/row-x5tq.yugi-ym8v 110073 658241 2019-01-02 2018-07-31 43 5         48 12             60
823 CLARK MEMORIAL HEALTH 1220 MISSOURI AVE JEFFERSONVILLE IN 47130 CLARK (812) 283-2147 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.2827840 -85.7492480 0   19 18 18019 31140 Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-99py-itd8.dhfq 150009 656628 2019-05-09 2018-07-31 128 22 3       153 15             168
1654 CALLAWAY DISTRICT HOSPITAL P O BOX 100, 211 E KIMBALL CALLAWAY NE 68825 CUSTER (308) 836-2228 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.2909887 -99.9242095 1 ROOFTOP 41 31 31041         https://data.medicare.gov/resource/xubh-q36u/row-nfg8_ccxm-ja7t 281335 660412 2019-01-02 2018-07-31 12           12               12
2530 FRANKFORT REGIONAL MEDICAL CENTER 299 KINGS DAUGHTERS DRIVE FRANKFORT KY 40601 FRANKLIN (502) 875-5240 Acute Care Hospitals Proprietary TRUE 38.1597740 -84.9057530 0   73 21 21073 23180 Lexington-Fayette--Richmond--Frankfort, KY Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-iiuj~fp2r_ghys 180127 657103 2019-06-24 2018-07-31 102 10       4 116 12             128
2741 ADVENTHEALTH OCALA 1500 SW 1ST AVE OCALA FL 34474 MARION (352) 351-7200 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.1742360 -82.1378340 0   83 12 12083 36100   Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-5mfq.kkk3.z2w9 100062 644236 2019-01-29 2018-07-31 369 44         413               413
2844 WATSONVILLE COMMUNITY HOSPITAL 75 NIELSON STREET WATSONVILLE CA 95076 SANTA CRUZ (831) 724-4741 Acute Care Hospitals Proprietary TRUE 36.9282800 -121.7937210 0   87 6 6087 42100 San Jose-San Francisco-Oakland, CA Central Santa Cruz County https://data.medicare.gov/resource/xubh-q36u/row-wbga.ap2u-4y8h 50194 656871 2019-08-22 2018-07-31 90 6         106               106
2866 HAYWOOD REGIONAL MEDICAL CENTER 262 LEROY GEORGE DRIVE CLYDE NC 28721 HAYWOOD (828) 456-7311 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.5278560 -82.9454370 0   87 37 37087 11700 Asheville-Brevard, NC Central Haywood County https://data.medicare.gov/resource/xubh-q36u/row-va55-s4tn.af57 340184 658543 2019-05-09 2018-07-31 110 12         122 16             138
2907 ST CHARLES PARISH HOSPITAL 1057 PAUL MAILLARD ROAD LULING LA 70070 ST. CHARLES (985) 785-3644 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.9245130 -90.3717510 0   89 22 22089 35380 New Orleans-Metairie-Hammond, LA-MS Central St. Charles Parish https://data.medicare.gov/resource/xubh-q36u/row-jwzr_ckt6~ux2m 190079 661901 2018-12-21 2018-07-31 31 8         39 20             59
3033 PHOEBE PUTNEY MEMORIAL HOSPITAL 417 THIRD AVENUE ALBANY GA 31703 DOUGHERTY (229) 312-4068 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.5902290 -84.1562670 0   95 13 13095 10500   Central Dougherty County https://data.medicare.gov/resource/xubh-q36u/row-97aw-8gyu-wg2w 110007 658211 2019-07-05 2018-07-31 332 50       27 409 15 25           461
3172 HARRIS REGIONAL HOSPITAL 68 HOSPITAL RD SYLVA NC 28779 JACKSON (828) 586-7000 Acute Care Hospitals Proprietary TRUE 35.3839230 -83.2027900 0   99 37 37099 19000   Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-xxmc~xtb8_wjsz 340016 658527 2019-05-09 2018-07-31 73 9         82               82
3185 CORYELL MEMORIAL HEALTHCARE SYSTEM 1507 W MAIN STREET GATESVILLE TX 76528 CORYELL (254) 865-8251 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.4331520 -97.7788220 0   99 48 48099 28660   Central Coryell County https://data.medicare.gov/resource/xubh-q36u/row-ndki.wivs~b55z 451379 640181 2019-01-02 2018-07-31 21 4         25               25
3533 BYRD REGIONAL HOSPITAL 1020 FERTITTA BLVD LEESVILLE LA 71446 VERNON (337) 239-9041 Acute Care Hospitals Proprietary TRUE 31.1373240 -93.2687910 0   115 22 22115 22860 DeRidder-Fort Polk South, LA Central Vernon Parish https://data.medicare.gov/resource/xubh-q36u/row-strz-rejf.3ijm 190164 643212 2019-02-11 2018-07-31 45 7         52               52
3550 CARLINVILLE AREA HOSPITAL 20733 N BROAD STREET CARLINVILLE IL 62626 MACOUPIN (217) 854-3141 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.2996420 -89.8816300 0   117 17 17117 41180 St. Louis-St. Charles-Farmington, MO-IL Outlying Macoupin County https://data.medicare.gov/resource/xubh-q36u/row-pxfs~3ysx~txi8 141347 640505 2019-01-07 2018-07-31 25           25               25
3595 MINDEN MEDICAL CENTER NO 1 MEDICAL PLAZA MINDEN LA 71055 WEBSTER (318) 377-2321 Acute Care Hospitals Proprietary TRUE 32.6172391 -93.2863556 1 ROOFTOP 119 22 22119 43340   Outlying Webster Parish https://data.medicare.gov/resource/xubh-q36u/row-zn8k~yqhx.sjt5 190144 657128 2019-01-03 2018-07-31 113 10         125 20 12           157
3625 COOSA VALLEY MEDICAL CENTER 315 W HICKORY ST SYLACAUGA AL 35150 TALLADEGA (256) 249-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.1646660 -86.2545980 0   121 1 1121 45180 Birmingham-Hoover-Talladega, AL Central Talladega County https://data.medicare.gov/resource/xubh-q36u/row-uqj6-bzwc~56ip 10164 659174 2018-12-26 2018-07-31 114 8         122 15     35 50     222
3928 LAS PALMAS MEDICAL CENTER 1801 NORTH OREGON STREET EL PASO TX 79902 EL PASO (915) 521-1200 Acute Care Hospitals Proprietary TRUE 31.7704830 -106.4987530 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-ay4n-jgmd_mzpr 450107 662079 2019-08-29 2018-07-31 377 64       55 496   63           559
4004 COMMUNITY MEDICAL CENTER, INC P O BOX 399, 3307 BARADA ST FALLS CITY NE 68355 RICHARDSON (402) 245-2428 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.0778770 -95.6075970 1 ROOFTOP 147 31 31147         https://data.medicare.gov/resource/xubh-q36u/row-xcna_pb8z-kjhc 281352 640654 2018-12-28 2018-07-31 24           24               24
4130 RIVERVIEW REGIONAL MEDICAL CENTER 158 HOSPITAL DRIVE CARTHAGE TN 37030 SMITH (615) 735-9815 Critical Access Hospitals Proprietary TRUE 36.2636070 -85.9485560 0   159 47 47159 34980 Nashville-Davidson--Murfreesboro, TN Outlying Smith County https://data.medicare.gov/resource/xubh-q36u/row-rt2i~krrj-iike 441307 641882 2019-01-02 2018-07-31 23 2         25 10             35
4205 RUSSELL REGIONAL HOSPITAL 200 S MAIN STREET RUSSELL KS 67665 RUSSELL (785) 483-3131 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.8832620 -98.8598360 0   167 20 20167         https://data.medicare.gov/resource/xubh-q36u/row-jqcp-w49x~7w2h 171350 640712 2019-01-03 2018-07-31 19           19           22   41
4249 ASCENSION VIA CHRISTI HOSPITAL ST. TERESA, INC. 14800 WEST ST TERESA WICHITA KS 67235 SEDGWICK (316) 796-7800 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.7250450 -97.5137860 0   173 20 20173 48620 Wichita-Arkansas City-Winfield, KS Central Sedgwick County https://data.medicare.gov/resource/xubh-q36u/row-8pe2-i236~vmyi 170200 657087 2019-01-02 2018-07-31 33 6         39   18           57
4257 SWAIN COUNTY HOSPITAL 45 PLATEAU STREET BRYSON CITY NC 28713 SWAIN (828) 488-2155 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.4351230 -83.4446880 0   173 37 37173         https://data.medicare.gov/resource/xubh-q36u/row-xctq~5kw9.id78 341305 640115 2018-12-27 2018-07-31 24           24               24
4421 PARK PLAZA HOSPITAL 1313 HERMANN DR HOUSTON TX 77004 HARRIS (713) 527-5019 Acute Care Hospitals Proprietary TRUE 29.7223750 -95.3880450 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-dstj_s4k4.df5s 450659 657538 2019-08-26 2018-07-31 119 14         133               133
4451 COON MEMORIAL HOSPITAL 1411 DENVER AVENUE DALHART TX 79022 DALLAM (806) 244-4571 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.0515690 -102.5219060 0   205 48 48205         https://data.medicare.gov/resource/xubh-q36u/row-8mcz-n3gr~ux5g 451331 646182 2019-03-19 2018-07-31 21           21               21
4510 SOUTHWEST GEORGIA REGIONAL MEDICAL CENTER 361 RANDOLPH STREET CUTHBERT GA 39840 RANDOLPH (229) 732-2181 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.7748230 -84.7936060 0   243 13 13243         https://data.medicare.gov/resource/xubh-q36u/row-9bkz.mqd7-hbvn 111300 641801 2019-01-02 2018-07-31 25           25       80       105
4531 PHOEBE SUMTER MEDICAL CENTER 126 HIGHWAY 280 W AMERICUS GA 31719 SUMTER (229) 931-1280 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.0642500 -84.2553760 0   261 13 13261 11140   Central Sumter County https://data.medicare.gov/resource/xubh-q36u/row-vsiw~isbg~xz6s 110044 658233 2018-12-28 2018-07-31 44   10       54               54

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [hospital_data] (
   [hospital_name] TEXT,
   [address] TEXT,
   [city] TEXT,
   [state] TEXT,
   [zip_code] INTEGER,
   [county_name] TEXT,
   [phone_number] TEXT,
   [hospital_type] TEXT,
   [hospital_ownership] TEXT,
   [emergency_services] TEXT,
   [lat] TEXT,
   [lng] TEXT,
   [geocode_flag] INTEGER,
   [geocode_accuracy] TEXT,
   [countyfips] INTEGER,
   [statefips] INTEGER,
   [statecountyfips] INTEGER,
   [cbsacode] TEXT,
   [csatitle] TEXT,
   [centraloutlyingcounty] TEXT,
   [countyequivalent] TEXT,
   [hosp_lookup_url] TEXT,
   [PRVDR_NUM] INTEGER,
   [RPT_REC_NUM] INTEGER,
   [filed_date] TEXT,
   [fy_end_date] TEXT,
   [acute_beds] INTEGER,
   [icu_beds] TEXT,
   [coronary_beds] TEXT,
   [burn_beds] TEXT,
   [surg_icu_beds] TEXT,
   [oth_spec_beds] TEXT,
   [subtotal_acute_beds] INTEGER,
   [subprovider_ipf_beds] TEXT,
   [subprovider_irf_beds] TEXT,
   [subprovider_oth_beds] TEXT,
   [skilled_nursing_beds] TEXT,
   [nursing_fac_beds] TEXT,
   [oth_longterm_beds] TEXT,
   [hospice_beds] TEXT,
   [all_beds] INTEGER
);