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 phone_number

✎ 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
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
3700 3700 D C H REGIONAL MEDICAL CENTER 809 UNIVERSITY BOULEVARD EAST TUSCALOOSA AL 35401 TUSCALOOSA (205) 759-7111 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.2061300 -87.5251540 0   125 1 1125 46220   Central Tuscaloosa County https://data.medicare.gov/resource/xubh-q36u/row-zssi.q234-yq7y 10092 644695 2019-02-28 2018-09-30 362 52 32       497 54 42           593
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
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
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
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
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
2853 2853 WEISER MEMORIAL HOSPITAL 645 EAST 5TH STREET WEISER ID 83672 WASHINGTON (208) 549-0370 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.2487610 -116.9617350 0   87 16 16087         https://data.medicare.gov/resource/xubh-q36u/row-e9wf-9jnf_cbd3 131307 655768 2019-11-01 2019-06-30 19           19               19
1998 1998 KOOTENAI HEALTH 2003 KOOTENAI HEALTH WAY COEUR D'ALENE ID 83814 KOOTENAI (208) 625-4000 Acute Care Hospitals Government - Hospital District or Authority TRUE 47.6945970 -116.7926690 0   55 16 16055 17660 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Central Kootenai County https://data.medicare.gov/resource/xubh-q36u/row-rqii_d7ee.cxzr 130049 649720 2019-05-31 2018-12-31 228 55       14 297               297
2642 2642 SHOSHONE MEDICAL CENTER 25 JACOBS GULCH ROAD KELLOGG ID 83837 SHOSHONE (208) 784-1221 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.5471230 -116.1314090 0   79 16 16079         https://data.medicare.gov/resource/xubh-q36u/row-5s2d-murc_kv83 131314 647887 2019-05-02 2018-11-30 21           21               21
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
3137 3137 OAK VALLEY HOSPITAL DISTRICT 350 S OAK AVE OAKDALE CA 95361 STANISLAUS (209) 847-3011 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7580980 -120.8603630 0   99 6 6099 33700 Modesto-Merced, CA Central Stanislaus County https://data.medicare.gov/resource/xubh-q36u/row-ehek_q3if-kskp 50067 660166 2019-12-02 2019-06-30 30 5         35       115       150
1682 1682 JOHN C FREMONT HEALTHCARE DISTRICT 5189 HOSPITAL ROAD MARIPOSA CA 95338 MARIPOSA (209) 966-3631 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.5005310 -119.9769480 0   43 6 6043         https://data.medicare.gov/resource/xubh-q36u/row-fty8~tgqe.f5tj 51304 661465 2019-12-02 2019-06-30 18           18       16   1   35
1180 1180 UNIVERSITY HEALTH SYSTEM 4502 MEDICAL DR SAN ANTONIO TX 78229 BEXAR (210) 358-2637 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.5094880 -98.5770620 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-a5b3.8n6m-4vq3 450213 651423 2019-05-31 2018-12-31 460 20     44   606   27           633
1182 1182 SOUTH TEXAS SPINE AND SURGICAL HOSPITAL 18600 NORTH HARDY OAK BLVD SAN ANTONIO TX 78258 BEXAR (210) 404-0800 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.6132070 -98.4784930 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-hrzf~ehe3.nfy2 450856 648491 2019-05-30 2018-12-31 30           30               30
3506 3506 PARKLAND HEALTH AND HOSPITAL SYSTEM 5200 HARRY HINES BLVD DALLAS TX 75235 DALLAS (214) 590-8000 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.8117980 -96.8369810 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-r83n-2jzv.t89y 450015 659727 2019-11-19 2018-09-30 621 35   9 17 77 771 18 18           807
4217 4217 SARAH D CULBERTSON MEMORIAL HOSPITAL 238 SOUTH CONGRESS STREET RUSHVILLE IL 62681 SCHUYLER (217) 322-4321 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.1179440 -90.5635870 0   169 17 17169         https://data.medicare.gov/resource/xubh-q36u/row-bfu9.4ehe.ppey 141333 652646 2019-07-26 2019-02-28 22           22               22
3436 3436 PERHAM HEALTH 1000 CONEY STREET WEST PERHAM MN 56573 OTTER TAIL (218) 347-1301 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.5926850 -95.5951650 0   111 27 27111 22260   Central Otter Tail County https://data.medicare.gov/resource/xubh-q36u/row-zmw6~bp7u-2zf8 241373 643422 2019-02-22 2018-09-30 25           25       96       121
9 9 NORTH SHORE HEALTH 515 5TH AVE WEST GRAND MARAIS MN 55604 COOK (218) 387-3040 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.7567440 -90.3401790 0   31 27 27031         https://data.medicare.gov/resource/xubh-q36u/row-kcfv-qat3~9wit 241317 649272 2019-05-28 2018-12-31 16           16       37       53
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
1394 1394 CUYUNA REGIONAL MEDICAL CENTER 320 EAST MAIN STREET CROSBY MN 56441 CROW WING (218) 546-2300 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.4824080 -93.9452500 0   35 27 27035 14660   Central Crow Wing County https://data.medicare.gov/resource/xubh-q36u/row-57iz_j5w8~gija 241353 654337 2019-09-09 2019-03-31 19 6         25       113       138
3877 3877 COOK HOSPITAL 10 SE FIFTH ST COOK MN 55723 ST. LOUIS (218) 666-5945 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.8534680 -92.6800320 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-buxd.3b5c~u3h4 241312 649042 2019-05-21 2018-12-31 14           14       28       42
2192 2192 BIGFORK VALLEY HOSPITAL 258 PINE TREE DRIVE PO BOX 258 BIGFORK MN 56628 ITASCA (218) 743-3177 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.7468850 -93.6468220 0   61 27 27061         https://data.medicare.gov/resource/xubh-q36u/row-356c-64uf.kf5r 241316 650718 2019-05-31 2018-12-31 20           20       47       67
2956 2956 ST HELENA PARISH HOSPITAL 16874 HIGHWAY 43 GREENSBURG LA 70441 ST. HELENA (225) 222-6111 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.8312500 -90.6670020 0   91 22 22091 12940   Outlying St. Helena Parish https://data.medicare.gov/resource/xubh-q36u/row-b8tn_kspp-zsgy 191300 646033 2019-04-01 2018-10-31 25           25               25
2608 2608 POINTE COUPEE GENERAL HOSPITAL 2202 FALSE RIVER DRIVE NEW ROADS LA 70760 POINTE COUPEE (225) 368-6386 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.6825160 -91.4613720 0   77 22 22077 12940   Outlying Pointe Coupee Parish https://data.medicare.gov/resource/xubh-q36u/row-xvrh.yvqv~4kd5 191316 650821 2019-06-24 2018-10-31 25           25               25
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
3710 3710 WEST FELICIANA PARISH HOSPITAL 5266 COMMERCE STREET, BUILDING B SAINT FRANCISVILLE LA 70775 WEST FELICIANA (225) 635-3811 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.7836100 -91.3656960 0   125 22 22125 12940   Outlying West Feliciana Parish https://data.medicare.gov/resource/xubh-q36u/row-2auk~kxvq-q4u4 191306 660809 2019-11-20 2018-10-31 25           25               25
1327 1327 LANE REGIONAL MEDICAL CENTER 6300 MAIN STREET ZACHARY LA 70791 E. BATON ROUGE (225) 658-4000 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.6499570 -91.1367470 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-6rne~rwgc-e8xv 190020 659955 2019-12-03 2019-06-30 95 8       2 113   30   39       182
2996 2996 ST JAMES PARISH HOSPITAL 1645 LUTCHER AVENUE LUTCHER LA 70071 ST. JAMES (225) 869-5512 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.0513910 -90.7018900 0   93 22 22093 35380 New Orleans-Metairie-Hammond, LA-MS Outlying St. James Parish https://data.medicare.gov/resource/xubh-q36u/row-5r4n.ki8u.r7sd 191305 653142 2019-08-28 2019-03-31 25           25               25
2852 2852 MEMORIAL HOSPITAL AND MANOR 1500 E SHOTWELL STREET BAINBRIDGE GA 39819 DECATUR (229) 246-3500 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.9037810 -84.5536700 0   87 13 13087 12460 Tallahassee-Bainbridge, FL-GA Central Decatur County https://data.medicare.gov/resource/xubh-q36u/row-74nj_m8fg-jx3q 110132 653382 2019-08-28 2019-03-31 70 10         80       107       187
2692 2692 CRISP REGIONAL HOSPITAL 902 7TH STREET NORTH CORDELE GA 31015 CRISP (229) 276-3100 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.9775150 -83.7828460 0   81 13 13081 18380   Central Crisp County https://data.medicare.gov/resource/xubh-q36u/row-cdxw-tgcq~24hj 110104 659938 2019-11-27 2019-06-30 49 16         65       143       208
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
4322 4322 SOUTH GEORGIA MEDICAL CENTER 2501 NORTH PATTERSON STREET, PO BOX 1727 VALDOSTA GA 31602 LOWNDES (229) 333-1020 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.8617500 -83.2888630 0   185 13 13185 46660   Central Lowndes County https://data.medicare.gov/resource/xubh-q36u/row-pihr~bnxt.5zgf 110122 644714 2019-03-01 2018-09-30 226 48         274   14           288
4447 4447 MITCHELL COUNTY HOSPITAL 90 STEPHENS STREET CAMILLA GA 31730 MITCHELL (229) 336-5284 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.2292770 -84.2050910 0   205 13 13205         https://data.medicare.gov/resource/xubh-q36u/row-wyam-jqj8.gyct 111331 644025 2019-02-25 2018-09-30 25           25       156       181
4539 4539 TIFT REGIONAL MEDICAL CENTER 901 E 18TH STREET TIFTON GA 31793 TIFT (229) 382-7120 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.4704020 -83.4910760 0   277 13 13277 45700   Central Tift County https://data.medicare.gov/resource/xubh-q36u/row-ny4q-euja_bk5w 110095 644114 2019-02-28 2018-09-30 161 20         181               181
4074 4074 IRWIN COUNTY HOSPITAL 710 N IRWIN AVENUE OCILLA GA 31774 IRWIN (229) 468-3845 Acute Care Hospitals Government - Hospital District or Authority FALSE 31.6027970 -83.2503310 0   155 13 13155         https://data.medicare.gov/resource/xubh-q36u/row-x4wh~4hz8~nrk6 110130 647117 2019-04-30 2018-11-30 34           34       30       64
4243 4243 SGMC LANIER CAMPUS 116 WEST THIGPEN AVENUE LAKELAND GA 31635 LANIER (229) 482-8402 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.0415910 -83.0864540 0   173 13 13173 46660   Outlying Lanier County https://data.medicare.gov/resource/xubh-q36u/row-h8ie_42qb_3sdj 111326 644718 2019-03-01 2018-09-30 25           25       62       87
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
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
4400 4400 MILLER COUNTY HOSPITAL 209 N CUTHBERT STREET COLQUITT GA 39837 MILLER (229) 758-4231 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.1754800 -84.7345480 0   201 13 13201         https://data.medicare.gov/resource/xubh-q36u/row-9k3y-ss2d~tagp 111305 659030 2019-11-20 2019-06-30 25           25       131       156
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
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
2648 2648 KALKASKA MEMORIAL HEALTH CENTER 419 S CORAL KALKASKA MI 49646 KALKASKA (231) 258-7500 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.7308970 -85.1838370 0   79 26 26079 45900   Outlying Kalkaska County https://data.medicare.gov/resource/xubh-q36u/row-xxgj-5p26_g3uf 231301 662385 2019-12-12 2019-06-30 8           8       102       110
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
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
990 990 GROVE HILL MEMORIAL HOSPITAL 295 JACKSON HWY S GROVE HILL AL 36451 CLARKE (251) 275-3191 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.6942130 -87.7772310 0   25 1 1025         https://data.medicare.gov/resource/xubh-q36u/row-qwpn-mu4j-e76s 10091 660905 2019-12-04 2019-06-30 21           21 9             30
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
3782 3782 WASHINGTON COUNTY HOSPITAL 14600 ST. STEPHENS AVENUE CHATOM AL 36518 WASHINGTON (251) 847-2223 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.4602960 -88.2352910 0   129 1 1129         https://data.medicare.gov/resource/xubh-q36u/row-kzeh_fuyx-rvjh 11300 644204 2019-03-01 2018-09-30 15           15       88       103
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
3899 3899 SENTARA ALBEMARLE MEDICAL CENTER 1144 N ROAD ST ELIZABETH CITY NC 27909 PASQUOTANK (252) 335-0531 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.3215300 -76.2200200 0   139 37 37139 21020 Virginia Beach-Norfolk, VA-NC Central Pasquotank County https://data.medicare.gov/resource/xubh-q36u/row-xfk5~qvx7~6vtj 340109 650342 2019-05-31 2018-12-31 81 10         91               91
3756 3756 NASH GENERAL HOSPITAL 2460 CURTIS ELLIS DRIVE ROCKY MOUNT NC 27804 NASH (252) 443-8000 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.9734430 -77.8489190 0   127 37 37127 40580 Rocky Mount-Wilson-Roanoke Rapids, NC Central Nash County https://data.medicare.gov/resource/xubh-q36u/row-rwxu_ptpb-kxcd 340147 660652 2019-11-26 2019-06-30 292 21       9 322   23           345
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
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                                      
4629 4629 STEPHENS MEMORIAL HOSPITAL 200 SOUTH GENEVA STREET BRECKENRIDGE TX 76424 STEPHENS (254) 559-2241 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7540560 -98.8877190 0   429 48 48429         https://data.medicare.gov/resource/xubh-q36u/row-f2c3_a9xb.afpq 450498 643739 2019-02-27 2018-09-30 14           14               14
3844 3844 EASTLAND MEMORIAL HOSPITAL 304 S DAUGHERTY EASTLAND TX 76448 EASTLAND (254) 629-2601 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.4004390 -98.8216360 0   133 48 48133         https://data.medicare.gov/resource/xubh-q36u/row-uts8~dkzz-h488 450411 660325 2019-12-02 2019-06-30 36           36               36
1431 1431 GOODALL WITCHER HOSPITAL 101 POSEY AVENUE CLIFTON TX 76634 BOSQUE (254) 675-8322 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.7771530 -97.5884310 0   35 48 48035         https://data.medicare.gov/resource/xubh-q36u/row-xqqi.9yb9.h6f2 451385 660476 2019-11-27 2019-06-30 25           25               25
4553 4553 LIMESTONE MEDICAL CENTER 701 MCCLINTIC DRIVE GROESBECK TX 76642 LIMESTONE (254) 729-3281 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.5319230 -96.5296210 0   293 48 48293         https://data.medicare.gov/resource/xubh-q36u/row-3e5u-tjfa_7eb2 451303 643539 2019-02-22 2018-09-30 20           20               20
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
4627 4627 GLEN ROSE MEDICAL CENTER 1021 HOLDEN STREET GLEN ROSE TX 76043 SOMERVELL (254) 897-2215 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.2420300 -97.7454000 0   425 48 48425 19100 Dallas-Fort Worth, TX-OK Outlying Somervell County https://data.medicare.gov/resource/xubh-q36u/row-cri5-k66p_vjbz 450451 645798 2019-03-22 2018-09-30 16           16               16
2732 2732 ATHENS LIMESTONE HOSPITAL 700 WEST MARKET STREET ATHENS AL 35611 LIMESTONE (256) 233-9292 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.8034990 -86.9778030 0   83 1 1083 26620 Huntsville-Decatur-Albertville, AL Outlying Limestone County https://data.medicare.gov/resource/xubh-q36u/row-nzdh.hdic_txkm 10079 660159 2019-12-02 2019-06-30 56 10         66               66
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
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
2879 2879 HUNTSVILLE HOSPITAL 101 SIVLEY RD HUNTSVILLE AL 35801 MADISON (256) 265-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.7212260 -86.5815470 0   89 1 1089 26620 Huntsville-Decatur-Albertville, AL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-srfb_s9fq-erqf 10039 660063 2019-12-02 2019-06-30 713 42 20   25   877 35             912
3243 3243 DECATUR MORGAN HOSPITAL-DECATUR CAMPUS 1201 7TH STREET SE DECATUR AL 35601 MORGAN (256) 341-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.5911680 -86.9726210 0   103 1 1103 19460 Huntsville-Decatur-Albertville, AL Central Morgan County https://data.medicare.gov/resource/xubh-q36u/row-j3pt~7hw5~edsk 10085 653820 2019-09-03 2019-03-31 166 23 11       200 64             264
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
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
3413 3413 TANNER MEDICAL CENTER-EAST ALABAMA 1032 MAIN STREET SOUTH WEDOWEE AL 36278 RANDOLPH (256) 357-2111 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.2966660 -85.4800280 0   111 1 1111         https://data.medicare.gov/resource/xubh-q36u/row-beeg-xgp7.fjvj 11306 659914 2019-11-27 2019-06-30 15           15               15
1311 1311 SHOALS HOSPITAL 201 WEST AVALON AVENUE MUSCLE SHOALS AL 35661 COLBERT (256) 386-1601 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.7449410 -87.6765110 0   33 1 1033 22520   Central Colbert County https://data.medicare.gov/resource/xubh-q36u/row-ks6f.h6du~x2iz 10157 653870 2019-09-04 2019-03-31 112 10         122 30 32           184
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
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
1680 1680 CULLMAN REGIONAL MEDICAL CENTER 1912 ALABAMA HIGHWAY 157 CULLMAN AL 35058 CULLMAN (256) 737-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.1985870 -86.8056410 0   43 1 1043 18980 Birmingham-Hoover-Talladega, AL Central Cullman County https://data.medicare.gov/resource/xubh-q36u/row-25az.bw5t.5dxy 10035 659467 2019-11-26 2019-06-30 133 12         145               145
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
4017 4017 THREE RIVERS HEALTH 701 S HEALTH PARKWAY THREE RIVERS MI 49093 ST. JOSEPH (269) 273-9602 Acute Care Hospitals Government - Hospital District or Authority FALSE 41.9349460 -85.6470480 0   149 26 26149 44780 Kalamazoo-Battle Creek-Portage, MI Central St. Joseph County https://data.medicare.gov/resource/xubh-q36u/row-bnfm~w7wq-f8qb 230015 649605 2019-05-31 2018-12-31 44 4         48   12           60
4123 4123 BRONSON SOUTH HAVEN HOSPITAL 955 S BAILEY AVE SOUTH HAVEN MI 49090 VAN BUREN (269) 637-5271 Acute Care Hospitals Government - Hospital District or Authority TRUE 42.3912520 -86.2641300 0   159 26 26159 28020 Kalamazoo-Battle Creek-Portage, MI Outlying Van Buren County https://data.medicare.gov/resource/xubh-q36u/row-zfqy_5w55-vbnk 230085 649607 2019-05-31 2018-12-31 49           49               49
2748 2748 JACKSON PURCHASE MEDICAL CENTER 1099 MEDICAL CENTER CIRCLE MAYFIELD KY 42066 GRAVES (270) 251-4585 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.7574110 -88.6509810 0   83 21 21083 32460 Paducah-Mayfield, KY-IL Central Graves County https://data.medicare.gov/resource/xubh-q36u/row-scw3~i5jx_eivs 180116 652359 2019-07-31 2019-02-28 87 8         95 12             107
1323 1323 CALDWELL MEDICAL CENTER 100 MEDICAL CENTER DRIVE PRINCETON KY 42445 CALDWELL (270) 365-0300 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.1142150 -87.9076580 0   33 21 21033         https://data.medicare.gov/resource/xubh-q36u/row-8ivi_hkzn.i9ke 181322 661513 2019-12-04 2019-06-30 25           25               25
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
4480 4480 TAYLOR REGIONAL HOSPITAL 1700 OLD LEBANON ROAD CAMPBELLSVILLE KY 42718 TAYLOR (270) 465-3561 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.3662160 -85.3391790 0   217 21 21217 15820   Central Taylor County https://data.medicare.gov/resource/xubh-q36u/row-qk8p.6ayj.fgni 180087 660562 2019-11-27 2019-06-30 82 8         90               90
4096 4096 MARSHALL COUNTY HOSPITAL 615 OLD SYMSONIA ROAD BENTON KY 42025 MARSHALL (270) 527-4800 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.8681820 -88.3680720 0   157 21 21157         https://data.medicare.gov/resource/xubh-q36u/row-3q24_p54p~4rj7 181327 648260 2019-05-20 2018-12-31 21 4         25               25
4112 4112 OAKBEND MEDICAL CENTER 1705 JACKSON ST RICHMOND TX 77469 FORT BEND (281) 341-3000 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.5777130 -95.7712970 0   157 48 48157 26420 Houston-The Woodlands, TX Central Fort Bend County https://data.medicare.gov/resource/xubh-q36u/row-579v~zdx9_b5ma 450330 648018 2019-05-21 2018-12-31 110 18         128 24     36       188
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
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
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
252 252 NORTH BIG HORN HOSPITAL DISTRICT 1115 LANE 12 LOVELL WY 82431 BIG HORN (307) 548-5200 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.8257990 -108.3906880 0   3 56 56003         https://data.medicare.gov/resource/xubh-q36u/row-s9vd~bscy-xn2k 531309 662633 2019-11-27 2019-06-30 12           12       85       97
253 253 SOUTH BIG HORN COUNTY CRITICAL ACCESS HOSPITAL 388 US HIGHWAY 20 SOUTH BASIN WY 82410 BIG HORN (307) 568-1500 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.4344490 -108.0490070 0   3 56 56003         https://data.medicare.gov/resource/xubh-q36u/row-vp99_bama.8nds 531301 661691 2019-11-29 2019-06-30 10           10       37       47
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
872 872 JOHNSON COUNTY HEALTHCARE CENTER 497 WEST LOTT BUFFALO WY 82834 JOHNSON (307) 684-5521 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.3497880 -106.7072480 0   19 56 56019         https://data.medicare.gov/resource/xubh-q36u/row-jfvm_9yjt_xtnf 531308 662298 2019-12-03 2019-06-30 22           22           3   69
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
1630 1630 ST JOHNS MEDICAL CENTER 625 EAST BROADWAY JACKSON WY 83001 TETON (307) 733-3636 Acute Care Hospitals Government - Hospital District or Authority TRUE 43.4796950 -110.7499860 0   39 56 56039 27220   Central Teton County https://data.medicare.gov/resource/xubh-q36u/row-vuqt_cw9d-cjux 530015 662632 2019-12-04 2019-06-30 42 6         48       60       108
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
1194 1194 POWELL VALLEY HOSPITAL 777 AVENUE H POWELL WY 82435 PARK (307) 754-2267 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.7566220 -108.7705470 0   29 56 56029         https://data.medicare.gov/resource/xubh-q36u/row-gs73_h7cj.ibeh 531310 662634 2019-11-27 2019-06-30 25           25       100       125
132 132 IVINSON MEMORIAL HOSPITAL 255 N 30TH LARAMIE WY 82072 ALBANY (307) 755-4600 Acute Care Hospitals Government - Hospital District or Authority TRUE 41.3113900 -105.5575120 0   1 56 56001 29660   Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-ptq5-c827_j29e 530025 660342 2019-12-03 2019-06-30 62 4         66 10     10       86
987 987 SOUTH LINCOLN MEDICAL CENTER - CAH 711 ONYX STREET KEMMERER WY 83101 LINCOLN (307) 877-4401 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.7895800 -110.5406070 0   23 56 56023         https://data.medicare.gov/resource/xubh-q36u/row-fvca.ncci~gnkk 531315 661692 2019-11-22 2019-06-30 13           13         24     37
988 988 STAR VALLEY MEDICAL CENTER 901 ADAMS STREET AFTON WY 83110 LINCOLN (307) 885-5800 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.7172500 -110.9314610 0   23 56 56023         https://data.medicare.gov/resource/xubh-q36u/row-763v_wyb3.smi9 531313 658921 2019-11-15 2019-06-30 22           22           24   46
4145 4145 GORDON MEMORIAL HOSPITAL DISTRICT 300 EAST 8TH ST GORDON NE 69343 SHERIDAN (308) 282-0401 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.8118390 -102.1996530 0   161 31 31161         https://data.medicare.gov/resource/xubh-q36u/row-4riz_taj9.4fxw 281358 662402 2019-12-05 2019-06-30 25           25           32   57
3211 3211 OGALLALA COMMUNITY HOSPITAL 2601 NORTH SPRUCE ST OGALLALA NE 69153 KEITH (308) 284-4011 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.1501770 -101.7204470 0   101 31 31101         https://data.medicare.gov/resource/xubh-q36u/row-g68g~zk9i.gtc5 281355 650174 2019-06-03 2018-12-31 18           18               18
1795 1795 LEXINGTON REGIONAL HEALTH CENTER P O BOX 980, 1201 NORTH ERIE ST LEXINGTON NE 68850 DAWSON (308) 324-5651 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.7858157 -99.7587068 1 ROOFTOP 47 31 31047 30420   Central Dawson County https://data.medicare.gov/resource/xubh-q36u/row-dbaj_tjsz.ntkv 281361 655216 2019-10-02 2019-06-30 25           25               25
3859 3859 PERKINS COUNTY HEALTH SERVICES 900 LINCOLN AVE GRANT NE 69140 PERKINS (308) 352-7200 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.8482680 -101.7271820 0   135 31 31135         https://data.medicare.gov/resource/xubh-q36u/row-g4pp~ymgi-thrv 281356 661045 2019-12-02 2019-06-30 20           20           50   70
1794 1794 GOTHENBURG MEMORIAL HOSPITAL 910 20TH ST GOTHENBURG NE 69138 DAWSON (308) 537-3661 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.9381320 -100.1533520 0   47 31 31047 30420   Central Dawson County https://data.medicare.gov/resource/xubh-q36u/row-dgzd-a44k.k83g 281313 661037 2019-12-02 2019-06-30 12           12               12

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
);