hospital_data

Table actions
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

537 rows where hospital_ownership = "Government - Hospital District or Authority" sorted by fy_end_date

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, fy_end_date, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_irf_beds, nursing_fac_beds, oth_longterm_beds, filed_date (date), fy_end_date (date)

hospital_ownership ✖

  • Government - Hospital District or Authority · 537 ✖
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
476 476 LBJ TROPICAL MEDICAL CENTER FAGAALU VILLAGE PAGO PAGO AS 96799 EASTERN DISTRICT (684) 633-4590 Acute Care Hospitals Government - Hospital District or Authority TRUE -14.2900610 -170.6847054 1 APPROXIMATE 10 60 60010         https://data.medicare.gov/resource/xubh-q36u/row-6iv4.yudm-sdek                                      
4374 4374 HAMILTON GENERAL HOSPITAL 400 N BROWN, BUILDING 1 HAMILTON TX 76531 HAMILTON (254) 386-3151 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.7038520 -98.1134620 0   193 48 48193         https://data.medicare.gov/resource/xubh-q36u/row-u9ir-x2hd-6nbs                                      
49 49 ALAMEDA HOSPITAL 2070 CLINTON AVENUE ALAMEDA CA 94501 ALAMEDA (510) 522-3700 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7632300 -122.2535410 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-aten_zvra_dnju 50211 662328 2018-12-03 2018-06-30 29   5       34       181       215
51 51 SAN LEANDRO HOSPITAL 13855 E 14TH STREET SAN LEANDRO CA 94578 ALAMEDA (510) 357-6500 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7146320 -122.1419730 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-whtt-wfgb.a9rb 50773 657702 2018-12-03 2018-06-30 39 6         45               45
333 333 CAMPBELL COUNTY MEMORIAL HOSPITAL 501 SOUTH BURMA AVENUE GILLETTE WY 82716 CAMPBELL (307) 688-1551 Acute Care Hospitals Government - Hospital District or Authority TRUE 44.2898460 -105.5195570 0   5 56 56005 23940   Central Campbell County https://data.medicare.gov/resource/xubh-q36u/row-ppek.rg99~yqr6 530002 658628 2018-11-29 2018-06-30 52 14         66 6     160       232
545 545 CROOK COUNTY HOSPITAL 713 OAK STREET SUNDANCE WY 82729 CROOK (307) 283-3501 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.4088300 -104.3735960 0   11 56 56011         https://data.medicare.gov/resource/xubh-q36u/row-ikyx-7gnq-abzi 531311 640303 2018-12-04 2018-06-30 16           16       32       48
623 623 HUMBOLDT GENERAL HOSPITAL 118 EAST HASKELL STREET WINNEMUCCA NV 89445 HUMBOLDT (775) 623-5222 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.9715810 -117.7285340 0   13 32 32013 49080   Central Humboldt County https://data.medicare.gov/resource/xubh-q36u/row-ca7p_4a94-fjt7 291308 641600 2018-11-30 2018-06-30 22 3         25       42       67
763 763 GROVER C DILS MEDICAL CENTER 700 N SPRING ST, BOX 1010-C-ADM BLDG CALIENTE NV 89008 LINCOLN (775) 726-3171 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.6222810 -114.5118240 0   17 32 32017         https://data.medicare.gov/resource/xubh-q36u/row-5bun~jms2_227p 291312 654895 2018-12-03 2018-06-30 4           4       16       20
810 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
914 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
1120 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 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 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
1560 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
1595 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
1770 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
2093 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
2241 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
2288 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
2434 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
2776 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
1654 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
2741 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
2866 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 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 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
3185 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
3625 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
4451 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 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 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
78 78 APPLING HOSPITAL 163 E TOLLISON STREET BAXLEY GA 31513 APPLING (912) 367-9841 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.7687680 -82.3493510 0   1 13 13001         https://data.medicare.gov/resource/xubh-q36u/row-j4qq-twpw~u8jw 110071 658240 2019-03-29 2018-08-31 31 3         34 30     101       165
276 276 PREVOST MEMORIAL HOSPITAL 301 MEMORIAL DR DONALDSONVILLE LA 70346 ASCENSION (225) 474-2133 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.0879510 -91.0029040 0   5 22 22005 12940   Central Ascension Parish https://data.medicare.gov/resource/xubh-q36u/row-e567~vwui.ed3h 191308 642472 2019-02-01 2018-08-31 25           25               25
1797 1797 ALTA VISTA REGIONAL HOSPITAL 104 LEGION DRIVE LAS VEGAS NM 87701 SAN MIGUEL (505) 426-3930 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.6221500 -105.2098510 0   47 35 35047 29780 Albuquerque-Santa Fe-Las Vegas, NM Central San Miguel County https://data.medicare.gov/resource/xubh-q36u/row-eqjk~u8wz_58xt 320003 657378 2019-08-22 2018-08-31 38 8         46               46
4148 4148 FREESTONE MEDICAL CENTER 125 NEWMAN ST FAIRFIELD TX 75840 FREESTONE (903) 389-1612 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.7256440 -96.1696100 0   161 48 48161         https://data.medicare.gov/resource/xubh-q36u/row-7ffj_67x5_e9my 450658 657537 2019-01-31 2018-08-31 37           37               37
4524 4524 HAMLIN MEMORIAL HOSPITAL 632 N W SECOND STREET HAMLIN TX 79520 JONES (325) 576-3646 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.8851680 -100.1346350 0   253 48 48253 10180   Outlying Jones County https://data.medicare.gov/resource/xubh-q36u/row-t33d_rkk5~cpm5 450243 657517 2019-03-15 2018-08-31 25           25               25
4558 4558 WASHINGTON COUNTY REGIONAL MEDICAL CENTER 610 SPARTA ROAD SANDERSVILLE GA 31082 WASHINGTON (478) 240-2100 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.9968170 -82.8050420 0   303 13 13303         https://data.medicare.gov/resource/xubh-q36u/row-2tqu-phgw~rfp2 110086 658248 2019-02-01 2018-08-31 56           56       60       116
4 4 SGMC BERRIEN CAMPUS 1221 E MCPHERSON AVENUE NASHVILLE GA 31639 BERRIEN (229) 543-7100 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.2036290 -83.2383370 0   19 13 13019         https://data.medicare.gov/resource/xubh-q36u/row-nuhh.ufkh.cshr 110234 644717 2019-03-01 2018-09-30 51           51 12             63
90 90 T J HEALTH COLUMBIA 901 WESTLAKE DRIVE COLUMBIA KY 42728 ADAIR (270) 384-4753 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.0962890 -85.2949400 0   1 21 21001         https://data.medicare.gov/resource/xubh-q36u/row-7iis-x23i.zsak 180149 640382 2018-12-31 2018-09-30 49           49 20             69
244 244 PERMIAN REGIONAL MEDICAL CENTER ANDREWS COUNTY HO 720 HOSPITAL DRIVE ANDREWS TX 79714 ANDREWS (432) 523-2200 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.3374240 -102.5468660 0   3 48 48003 11380   Central Andrews County https://data.medicare.gov/resource/xubh-q36u/row-juik.55wn.c6fd 450144 643151 2019-02-12 2018-09-30 30           30               30
336 336 BIBB MEDICAL CENTER 208 PIERSON AVE CENTREVILLE AL 35042 BIBB (205) 926-4881 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.9511010 -87.1478650 0   7 1 1007 13820 Birmingham-Hoover-Talladega, AL Outlying Bibb County https://data.medicare.gov/resource/xubh-q36u/row-h96v_9sq6~aaj9 10058 644693 2019-03-01 2018-09-30 25           25       131       156
418 418 PARRISH MEDICAL CENTER 951 N WASHINGTON AVE TITUSVILLE FL 32796 BREVARD (321) 268-6111 Acute Care Hospitals Government - Hospital District or Authority TRUE 28.6290680 -80.8249430 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-md6z.znz4~w9v4 100028 645533 2019-03-05 2018-09-30 202 8         210               210
433 433 ELLINWOOD DISTRICT HOSPITAL 605 N MAIN STREET ELLINWOOD KS 67526 BARTON (620) 564-2548 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.3607070 -98.5811930 0   9 20 20009 24460   Central Barton County https://data.medicare.gov/resource/xubh-q36u/row-kt5p.cy3y_6d85 171301 661185 2019-02-28 2018-09-30 25           25               25
759 759 MERCY HOSPITAL 4572 COUNTY ROAD 61 MOOSE LAKE MN 55767 CARLTON (218) 485-4481 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.4425450 -92.7757250 0   17 27 27017 20260   Outlying Carlton County https://data.medicare.gov/resource/xubh-q36u/row-ank5~56fj_iw2s 241350 645270 2019-02-26 2018-09-30 23 2         25               25
889 889 MEDICAL CENTER, NAVICENT HEALTH (THE) 777 HEMLOCK STREET MACON GA 31201 BIBB (478) 633-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.8332020 -83.6365530 0   21 13 13021 31420 Macon-Warner Robins, GA Central Bibb County https://data.medicare.gov/resource/xubh-q36u/row-qa2j~4dhx.y2zw 110107 645712 2019-03-04 2018-09-30 453 77       64 594 16             610
901 901 MAYO REGIONAL HOSPITAL 897 WEST MAIN STREET DOVER FOXCROFT ME 4426 PISCATAQUIS (207) 564-4251 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.1865560 -69.2377980 0   21 23 23021         https://data.medicare.gov/resource/xubh-q36u/row-zhbf-zz89~t9dz 201309 645562 2019-03-04 2018-09-30 25           25               25
950 950 LOST RIVERS MEDICAL CENTER 551 HIGHLAND DRIVE ARCO ID 83213 BUTTE (208) 252-7654 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.6405520 -113.2962530 0   23 16 16023 26820 Idaho Falls-Rexburg-Blackfoot, ID Outlying Butte County https://data.medicare.gov/resource/xubh-q36u/row-77px.m9qb~bsww 131324 640856 2019-01-08 2018-09-30 14           14               14
1058 1058 CLAY COUNTY HOSPITAL 83825 HIGHWAY 9 P O BOX 1270 ASHLAND AL 36251 CLAY (256) 354-2131 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.2765480 -85.8237890 0   27 1 1027         https://data.medicare.gov/resource/xubh-q36u/row-p2yh_2e24~5sth 10073 644085 2019-02-28 2018-09-30 42 4         46       83       129
1064 1064 BROOKS COUNTY HOSPITAL 903 N COURT STREET QUITMAN GA 31643 BROOKS (912) 263-4171 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.7950120 -83.5595000 0   27 13 13027 46660   Outlying Brooks County https://data.medicare.gov/resource/xubh-q36u/row-yfqz_ezxu_56q8 111332 645068 2019-02-25 2018-09-30 25           25               25
1139 1139 RIVERLAND MEDICAL CENTER 1700 WALLACE BLVD FERRIDAY LA 71334 CONCORDIA (318) 757-6551 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.6469583 -91.5548418 1 ROOFTOP 29 22 22029 35020   Central Concordia Parish https://data.medicare.gov/resource/xubh-q36u/row-v73w.iknw.vmzz 191318 644280 2019-03-01 2018-09-30 20 5         25               25
1310 1310 HELEN KELLER MEMORIAL HOSPITAL 1300 SOUTH MONTGOMERY AVENUE SHEFFIELD AL 35660 COLBERT (256) 386-4556 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.7482490 -87.6988660 0   33 1 1033 22520   Central Colbert County https://data.medicare.gov/resource/xubh-q36u/row-jy8a.vhn5.4yjk 10019 644083 2019-02-25 2018-09-30 166 12         178               178
1606 1606 WEATHERFORD REGIONAL HOSPITAL, INC OF WEATHERFORD 3701 E MAIN WEATHERFORD OK 73096 CUSTER (580) 772-5551 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.5368690 -98.6615560 0   39 40 40039 48220   Central Custer County https://data.medicare.gov/resource/xubh-q36u/row-fwq8~2h8t.8wcs 371323 645603 2019-02-25 2018-09-30 25           25               25
1619 1619 SWEENY COMMUNITY HOSPITAL 305 NORTH MCKINNEY SWEENY TX 77480 BRAZORIA (979) 548-3311 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.0485140 -95.6913920 0   39 48 48039 26420 Houston-The Woodlands, TX Central Brazoria County https://data.medicare.gov/resource/xubh-q36u/row-argn.cnxa-jdss 451311 643974 2019-03-01 2018-09-30 14           14               14
1720 1720 DALE MEDICAL CENTER 126 HOSPITAL AVE OZARK AL 36360 DALE (334) 774-2601 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.4513450 -85.6309660 0   45 1 1045 37120 Dothan-Enterprise-Ozark, AL Central Dale County https://data.medicare.gov/resource/xubh-q36u/row-eeas~xsp4-ap8q 10021 644004 2019-02-20 2018-09-30 71 6         77 12             89
1738 1738 IBERIA MEDICAL CENTER 2315 E MAIN STREET NEW IBERIA LA 70562 IBERIA (337) 364-0441 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.9890470 -91.7857830 0   45 22 22045 29180 Lafayette-Opelousas-Morgan City, LA Central Iberia Parish https://data.medicare.gov/resource/xubh-q36u/row-x9u8_ffn4-xizx 190054 643889 2019-03-02 2018-09-30 102 11         113 12             125
1771 1771 HALE COUNTY HOSPITAL 508 GREEN STREET GREENSBORO AL 36744 HALE (334) 624-3024 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.4120980 -87.0186330 0   47 1 1047 42820   Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-s7ws-qt9j~ivrz 10095 644200 2019-03-01 2018-09-30 28           28               28
1832 1832 SYRINGA GENERAL HOSPITAL 607 W MAIN STREET GRANGEVILLE ID 83530 IDAHO (208) 983-1700 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.9267890 -116.1269940 0   49 16 16049         https://data.medicare.gov/resource/xubh-q36u/row-9the-4kgt.urhi 131315 642946 2019-02-08 2018-09-30 15           15               15
1838 1838 JACKSON PARISH HOSPITAL 165 BEECH SPRINGS ROAD JONESBORO LA 71251 JACKSON (318) 259-4435 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.2523490 -92.7196360 0   49 22 22049         https://data.medicare.gov/resource/xubh-q36u/row-sfrf-yeiu_hcfg 191317 643894 2019-02-26 2018-09-30 25           25               25
1856 1856 CAROLINA EAST MEDICAL CENTER 2000 NEUSE BLVD NEW BERN NC 28560 CRAVEN (252) 633-8640 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.1118930 -77.0662160 0   49 37 37049 35100 New Bern-Morehead City, NC Central Craven County https://data.medicare.gov/resource/xubh-q36u/row-p2zz.x8hz~epee 340131 645136 2019-02-27 2018-09-30 214 72         286   20           306
1938 1938 D W MCMILLAN MEMORIAL HOSPITAL 1301 BELLEVILLE AVENUE BREWTON AL 36426 ESCAMBIA (251) 867-8061 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.1271050 -87.0723780 0   53 1 1053         https://data.medicare.gov/resource/xubh-q36u/row-ug8v.qapr~xntq 10099 644201 2019-03-01 2018-09-30 38 8         46               46
1939 1939 ATMORE COMMUNITY HOSPITAL 401 MEDICAL PARK DRIVE ATMORE AL 36502 ESCAMBIA (251) 368-2500 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.0165700 -87.4797350 0   53 1 1053         https://data.medicare.gov/resource/xubh-q36u/row-nw85.p2jc-cva6 10169 645521 2019-02-28 2018-09-30 43 6         49               49
2072 2072 THIBODAUX REGIONAL MEDICAL CENTER 602 N ACADIA ROAD THIBODAUX LA 70301 LAFOURCHE (985) 447-5500 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.7805460 -90.8068190 0   57 22 22057 26380   Central Lafourche Parish https://data.medicare.gov/resource/xubh-q36u/row-gquu-42z7-apmr 190004 643886 2019-02-27 2018-09-30 114 16         130 16 14           160
2075 2075 MADISON VALLEY MEDICAL CENTER 305 N MAIN ENNIS MT 59729 MADISON (406) 682-4222 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.3514000 -111.7325670 0   57 30 30057         https://data.medicare.gov/resource/xubh-q36u/row-djeh_dspp-vwv4 271329 644643 2019-02-28 2018-09-30 10           10               10
2098 2098 RED BAY HOSPITAL 211 HOSPITAL ROAD RED BAY AL 35582 FRANKLIN (256) 356-9532 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.4574250 -88.1469340 0   59 1 1059         https://data.medicare.gov/resource/xubh-q36u/row-4dsc.86rj~64k4 11302 644088 2019-02-25 2018-09-30 25           25               25
2132 2132 DOCTORS MEMORIAL HOSPITAL 2600 HOSPITAL DR BONIFAY FL 32425 HOLMES (850) 547-1120 Critical Access Hospitals Government - Hospital District or Authority FALSE 30.7605900 -85.6824740 0   59 12 12059         https://data.medicare.gov/resource/xubh-q36u/row-sw88.r7zg.v2gg 101307 645754 2019-03-18 2018-09-30 20           20               20
2140 2140 LASALLE GENERAL HOSPITAL 187 NINTH ST/HWY 84 WEST JENA LA 71342 LASALLE (318) 992-9200 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.6831927 -92.1337360 1 GEOMETRIC_CENTER 59 22 22059         https://data.medicare.gov/resource/xubh-q36u/row-dbin~f8yn~yhkn 190145 644279 2019-03-01 2018-09-30 30           30 16             46
2141 2141 HARDTNER MEDICAL CENTER 1102 N PINE ROAD OLLA LA 71465 LASALLE (318) 495-3131 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.8597600 -92.2760200 0   59 22 22059         https://data.medicare.gov/resource/xubh-q36u/row-k4bv.84ki_wajg 191315 659035 2019-11-13 2018-09-30 25           25 10             35
2175 2175 WIREGRASS MEDICAL CENTER 1200 W MAPLE AVENUE GENEVA AL 36340 GENEVA (334) 684-3655 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.0480630 -85.8908370 0   61 1 1061 20020 Dothan-Enterprise-Ozark, AL Outlying Geneva County https://data.medicare.gov/resource/xubh-q36u/row-6zer-5ewe_shgk 10062 644199 2019-03-01 2018-09-30 67 6         73 16     96       185
2243 2243 JACKSON HOSPITAL 4250 HOSPITAL DR MARIANNA FL 32446 JACKSON (850) 526-2200 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.7874800 -85.2409320 0   63 12 12063         https://data.medicare.gov/resource/xubh-q36u/row-kd9h-xmn9-4awy 100142 645398 2019-03-01 2018-09-30 59 7         66               66
2271 2271 LEXINGTON MEDICAL CENTER 2720 SUNSET BLVD WEST COLUMBIA SC 29169 LEXINGTON (803) 791-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.0044030 -81.1143610 0   63 45 45063 17900 Columbia-Orangeburg-Newberry, SC Central Lexington County https://data.medicare.gov/resource/xubh-q36u/row-qscu~35q6.43rv 420073 645360 2019-03-01 2018-09-30 397 21     18   436               436
2384 2384 SOUTHEAST ALABAMA MEDICAL CENTER 1108 ROSS CLARK CIRCLE DOTHAN AL 36301 HOUSTON (334) 793-8701 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.2140580 -85.3617250 0   69 1 1069 20020 Dothan-Enterprise-Ozark, AL Central Houston County https://data.medicare.gov/resource/xubh-q36u/row-qib2_2qqh~zmw8 10001 644080 2019-03-01 2018-09-30 271 40       16 327               327
2392 2392 SOUTH LAKE HOSPITAL 1900 DON WICKHAM DR CLERMONT FL 34711 LAKE (352) 394-4071 Acute Care Hospitals Government - Hospital District or Authority FALSE 28.5511780 -81.7234150 0   69 12 12069 36740 Orlando-Deltona-Daytona Beach, FL Outlying Lake County https://data.medicare.gov/resource/xubh-q36u/row-z7xz~yu83_5nfj 100051 661477 2019-11-25 2018-09-30 124 16         140       30       170
2416 2416 PLAINS MEMORIAL HOSPITAL 310 WEST HALSELL STREET DIMMITT TX 79027 CASTRO (806) 647-2191 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.5555910 -102.3157640 0   69 48 48069         https://data.medicare.gov/resource/xubh-q36u/row-c55u_ceer_6r3n 451350 641531 2019-01-14 2018-09-30 17           17               17
2425 2425 HIGHLANDS MEDICAL CENTER 380 WOODS COVE ROAD SCOTTSBORO AL 35768 JACKSON (256) 259-4444 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6612540 -86.0471160 0   71 1 1071 42460 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-pkzd.p7rm.i3y6 10061 644084 2019-02-27 2018-09-30 158 10         168       50       218
2449 2449 CAPE CORAL HOSPITAL 636 DEL PRADO BLVD CAPE CORAL FL 33990 LEE (239) 574-2323 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.6393210 -81.9409460 0   71 12 12071 15980 Cape Coral-Fort Myers-Naples, FL Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-h94e-be5i_u37i 100244 644248 2019-02-28 2018-09-30 235 22       23 280               280
2450 2450 GULF COAST MEDICAL CENTER LEE MEM HEALTH SYSTEM 13681 DOCTORS WAY FORT MYERS FL 33912 LEE (239) 768-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.5430160 -81.8485890 0   71 12 12071 15980 Cape Coral-Fort Myers-Naples, FL Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-ey2r_ercs~bbdu 100220 644710 2019-02-28 2018-09-30 320 36         356               356
2452 2452 LEE MEMORIAL HOSPITAL 2776 CLEVELAND AVE FORT MYERS FL 33901 LEE (239) 332-1111 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.6269240 -81.8722950 0   71 12 12071 15980 Cape Coral-Fort Myers-Naples, FL Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-d9mq-v9vy_3733 100012 644229 2019-02-28 2018-09-30 539 75       32 743   60   15       818
2454 2454 COLQUITT REGIONAL MEDICAL CENTER 3131 THOMASVILLE HWY BOX 40 MOULTRIE GA 31768 COLQUITT (229) 985-3420 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.1267470 -83.7829180 0   71 13 13071 34220   Central Colquitt County https://data.medicare.gov/resource/xubh-q36u/row-cjar.baa5~jr3x 110105 645063 2019-03-01 2018-09-30 84 10         94           35   129
2490 2490 BAYSIDE COMMUNITY HOSPITAL 200 HOSPITAL DRIVE ANAHUAC TX 77514 CHAMBERS (409) 267-3143 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.7530120 -94.6868500 0   71 48 48071 26420 Houston-The Woodlands, TX Central Chambers County https://data.medicare.gov/resource/xubh-q36u/row-zszx-nqzy-xwd5 451320 643853 2019-02-28 2018-09-30 14           14               14
2499 2499 MEDICAL WEST, AN AFFILIATE OF UAB HEALTH SYSTEM 995 9TH AVENUE SOUTHWEST BESSEMER AL 35021 JEFFERSON (205) 481-7000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.3730860 -86.9917090 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-4v9u.s38j~rrc7 10114 644202 2019-03-01 2018-09-30 119 21         187 25 19           231
2520 2520 GROSSMONT HOSPITAL 5555 GROSSMONT CENTER DRIVE BOX 58 LA MESA CA 91942 SAN DIEGO (619) 465-0711 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7794350 -117.0091780 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-j2di_g3bq~q2tc 50026 643325 2019-02-25 2018-09-30 371 48         443 46 18   17   16   540
2536 2536 JOHNSON MEMORIAL HOSPITAL 1282 WALNUT STREET DAWSON MN 56232 LAC QUI PARLE (320) 769-4323 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.9309710 -96.0670630 0   73 27 27073         https://data.medicare.gov/resource/xubh-q36u/row-aiqt_9tq3~e2sg 241314 643711 2019-03-04 2018-09-30 20           20       56       76
2584 2584 CHILDRESS REGIONAL MEDICAL CENTER HWY 83 NORTH CHILDRESS TX 79201 CHILDRESS (940) 937-6371 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.4304911 -100.2265235 1 GEOMETRIC_CENTER 75 48 48075         https://data.medicare.gov/resource/xubh-q36u/row-vkgv.sxvw_zc6g 450369 646306 2019-03-08 2018-09-30 39           39               39
2602 2602 POWER COUNTY HOSPITAL DISTRICT 510 ROOSEVELT STREET AMERICAN FALLS ID 83211 POWER (208) 226-3200 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.7818580 -112.8490470 0   77 16 16077         https://data.medicare.gov/resource/xubh-q36u/row-jqyn~uieu.hqrg 131304 645328 2019-03-20 2018-09-30 10           10       16       26
2637 2637 LAWRENCE MEDICAL CENTER 202 HOSPITAL STREET MOULTON AL 35650 LAWRENCE (256) 974-2200 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.4828840 -87.2860190 0   79 1 1079 19460 Huntsville-Decatur-Albertville, AL Outlying Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-vch8-q4mb_8uww 10059 644694 2019-02-26 2018-09-30 37 6         43               43
2641 2641 MADISON COUNTY MEMORIAL HOSPITAL 224 NW CRANE AVE MADISON FL 32340 MADISON (850) 973-2271 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.4714130 -83.4198980 0   79 12 12079         https://data.medicare.gov/resource/xubh-q36u/row-gara~x4i8-9hau 101311 643696 2019-02-27 2018-09-30 25           25               25
2668 2668 COCHRAN MEMORIAL HOSPITAL 205 E GRANT STREET MORTON TX 79346 COCHRAN (806) 266-5565 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.7192940 -102.7580750 0   79 48 48079         https://data.medicare.gov/resource/xubh-q36u/row-cdg6.bkks~3hn7 451366 643985 2019-03-01 2018-09-30 18           18               18
2679 2679 EAST ALABAMA MEDICAL CENTER 2000 PEPPERELL PARKWAY OPELIKA AL 36801 LEE (334) 749-3411 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.6380550 -85.4040030 0   81 1 1081 12220 Columbus-Auburn-Opelika, GA-AL Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-vb76-r6it-demb 10029 645461 2019-03-01 2018-09-30 344 20 8       372   17   126       515
2749 2749 RICHLAND PARISH HOSPITAL-DELHI 407 CINCINNATI STREET DELHI LA 71232 RICHLAND (318) 878-5171 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.4528640 -91.4940790 0   83 22 22083         https://data.medicare.gov/resource/xubh-q36u/row-hfae.3pha.8u3y 191323 659094 2019-11-08 2018-09-30 25           25               25
2750 2750 RICHARDSON MEDICAL CENTER 254 HIGHWAY 3048 RAYVILLE LA 71269 RICHLAND (318) 728-4181 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.4639730 -91.7478790 0   83 22 22083         https://data.medicare.gov/resource/xubh-q36u/row-387x~nsyb.i8m2 190151 646337 2019-04-05 2018-09-30 36 2         38               38
2765 2765 SPARTANBURG MEDICAL CENTER 101 E WOOD ST SPARTANBURG SC 29303 SPARTANBURG (864) 560-6554 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.9678520 -81.9399270 0   83 45 45083 43900 Greenville-Spartanburg-Anderson, SC Central Spartanburg County https://data.medicare.gov/resource/xubh-q36u/row-hyp6-4fyv-sawi 420007 645166 2019-02-28 2018-09-30 410 19 20       493               493
2766 2766 PELHAM MEDICAL CENTER 250 WESTMORELAND ROAD GREER SC 29651 GREENVILLE (864) 560-6554 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.8635100 -82.2176610 0   83 45 45083 43900 Greenville-Spartanburg-Anderson, SC Central Spartanburg County https://data.medicare.gov/resource/xubh-q36u/row-kc6n_96px_662r 420103 645180 2019-02-28 2018-09-30 44 4         48               48
2767 2767 CASCADE MEDICAL CENTER 402 LAKE CASCADE PARKWAY CASCADE ID 83611 VALLEY (208) 382-4242 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.5179210 -116.0489380 0   85 16 16085         https://data.medicare.gov/resource/xubh-q36u/row-8r6g.s3au-3yid 131308 644833 2019-03-04 2018-09-30 8           8               8
2770 2770 COLEMAN COUNTY MEDICAL CENTER COMPANY 310 SOUTH PECOS STREET COLEMAN TX 76834 COLEMAN (325) 625-2135 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.8286260 -99.4252380 0   83 48 48083         https://data.medicare.gov/resource/xubh-q36u/row-arcj.jjrh_hge7 451347 643742 2019-02-28 2018-09-30 25           25               25
2843 2843 JACKSON MEMORIAL HOSPITAL 1611 NW 12TH AVE MIAMI FL 33136 MIAMI-DADE (305) 585-1111 Acute Care Hospitals Government - Hospital District or Authority TRUE 25.7906120 -80.2149450 0   86 12 12086 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Miami-Dade County https://data.medicare.gov/resource/xubh-q36u/row-7crg~caqv-izm8 100022 643685 2019-02-22 2018-09-30 1169 26 11   65 63 1457 151 55           1663
2935 2935 BRYAN W. WHITFIELD MEMORIAL HOSPITAL 105 HIGHWAY 80 EAST DEMOPOLIS AL 36732 MARENGO (334) 289-4000 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.5036760 -87.8367440 0   91 1 1091         https://data.medicare.gov/resource/xubh-q36u/row-eqeg.jsdy-rvpp 10112 645707 2019-03-04 2018-09-30 32 5         37 20             57
2940 2940 DODGE COUNTY HOSPITAL 901 GRIFFIN AVE EASTMAN GA 31023 DODGE (478) 448-4067 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.1860550 -83.1785910 0   91 13 13091         https://data.medicare.gov/resource/xubh-q36u/row-5bm5_8374~kawn 110092 644022 2019-02-25 2018-09-30 34 6         40 10             50
3021 3021 MARSHALL MEDICAL CENTERS SOUTH CAMPUS 2505 U S HIGHWAY 431 NORTH BOAZ AL 35957 MARSHALL (256) 593-8310 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.2216880 -86.1607098 1 ROOFTOP 95 1 1095 10700 Huntsville-Decatur-Albertville, AL Central Marshall County https://data.medicare.gov/resource/xubh-q36u/row-qhdt_aeut-3iwd 10005 644081 2019-02-28 2018-09-30 184 20         204               204
3068 3068 CONCHO COUNTY HOSPITAL 614 EAKER STREET EDEN TX 76837 CONCHO (915) 869-5911 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.2208850 -99.8478320 0   95 48 48095         https://data.medicare.gov/resource/xubh-q36u/row-gyb7_xqfh_6ezj 451325 643976 2019-03-04 2018-09-30 16           16               16
3145 3145 LAKESIDE MEDICAL CENTER 39200 HOOKER HWY BELLE GLADE FL 33430 PALM BEACH (561) 996-6571 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.7256840 -80.6700790 0   99 12 12099 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Palm Beach County https://data.medicare.gov/resource/xubh-q36u/row-vcv9~uwnp_a6fi 100130 644242 2019-03-04 2018-09-30 48 6         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
);