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 address

✎ 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
4455 4455 HASKELL MEMORIAL HOSPITAL 1 NORTH AVENUE N PO BOX 1117 HASKELL TX 79521 HASKELL (940) 864-2621 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.1572901 -99.7446581 1 ROOFTOP 207 48 48207         https://data.medicare.gov/resource/xubh-q36u/row-66f3~mect.vjwe 451341 644375 2019-03-01 2018-09-30 25           25               25
3644 3644 GLACIAL RIDGE HOSPITAL 10 4TH AVENUE SOUTHEAST GLENWOOD MN 56334 POPE (320) 634-4521 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.6467570 -95.3898700 0   121 27 27121         https://data.medicare.gov/resource/xubh-q36u/row-ip3d~zsv9-xzxg 241376 644297 2019-03-11 2018-09-30 19           19               19
1715 1715 LINCOLN HOSPITAL 10 NICHOLS STREET DAVENPORT WA 99122 LINCOLN (509) 725-7101 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.6571949 -118.1462384 1 RANGE_INTERPOLATED 43 53 53043         https://data.medicare.gov/resource/xubh-q36u/row-3c5v_e33f-mmva 501305 647597 2019-05-13 2018-12-31 25           25               25
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
2268 2268 HOLDENVILLE GENERAL HOSPITAL 100 MCDOUGAL DRIVE HOLDENVILLE OK 74848 HUGHES (405) 379-4200 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.0882130 -96.3782650 0   63 40 40063         https://data.medicare.gov/resource/xubh-q36u/row-sj8k.rz7i~rzh6 371321 660004 2019-12-03 2019-06-30 25           25               25
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
4581 4581 NOCONA GENERAL HOSPITAL 100 PARK ROAD NOCONA TX 76255 MONTAGUE (940) 825-3235 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.7775590 -97.7315640 0   337 48 48337         https://data.medicare.gov/resource/xubh-q36u/row-f6j5-6zwa-5e54 450641 659541 2019-11-22 2019-06-30 18           18               18
3246 3246 PIONEERS MEDICAL CENTER 100 PIONEERS MEDICAL CENTER DR MEEKER CO 81641 RIO BLANCO (970) 878-5047 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.0470026 -107.8822968 1 ROOFTOP 103 8 8103         https://data.medicare.gov/resource/xubh-q36u/row-ygxw-c3bh-9y5d 61325 647603 2019-05-08 2018-12-31 10           10       30       40
1034 1034 CIMARRON MEMORIAL HOSPITAL 100 SOUTH ELLIS BOISE CITY OK 73933 CIMARRON (580) 544-2501 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.7290550 -102.5175370 0   25 40 40025         https://data.medicare.gov/resource/xubh-q36u/row-9zte.pc9m_addj 371307 650201 2019-06-03 2018-12-31 25           25               25
3604 3604 WESTCHESTER MEDICAL CENTER 100 WOODS RD VALHALLA NY 10595 WESTCHESTER (914) 493-7000 Acute Care Hospitals Government - Hospital District or Authority TRUE 41.0876800 -73.8038970 0   119 36 36119 35620 New York-Newark, NY-NJ-CT-PA Central Westchester County https://data.medicare.gov/resource/xubh-q36u/row-xkhz-jkc9_u59t 330234 650318 2019-06-21 2018-12-31 550 66 15 10   49 708 141 36           885
3612 3612 CAROLINAS MEDICAL CENTER/BEHAV HEALTH 1000 BLYTHE BLVD CHARLOTTE NC 28203 MECKLENBURG (704) 355-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.2049830 -80.8398450 0   119 37 37119 16740 Charlotte-Concord, NC-SC Central Mecklenburg County https://data.medicare.gov/resource/xubh-q36u/row-tjng_gucu-k2vq 340113 661769 2019-12-18 2018-12-31 768 49 20       1112 132 13           1257
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
3850 3850 NORTHSIDE HOSPITAL GWINNETT 1000 MEDICAL CENTER BOULEVARD LAWRENCEVILLE GA 30045 GWINNETT (678) 312-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.9664550 -84.0130120 0   135 13 13135 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Gwinnett County https://data.medicare.gov/resource/xubh-q36u/row-s7r7-ja6f~94m5 110087 661711 2019-12-13 2019-08-27 367 46       24 437   30   89       556
1319 1319 CRAWFORD MEMORIAL HOSPITAL 1000 NORTH ALLEN STREET ROBINSON IL 62454 CRAWFORD (618) 544-3131 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.0136680 -87.7489990 0   33 17 17033         https://data.medicare.gov/resource/xubh-q36u/row-2yid-zac4-j637 141343 654840 2019-10-01 2019-04-30 25           25       35       60
675 675 HEART OF THE ROCKIES REGIONAL MEDICAL CENTER 1000 RUSH DR SALIDA CO 81201 CHAFFEE (719) 530-2200 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.5431020 -106.0072910 0   15 8 8015         https://data.medicare.gov/resource/xubh-q36u/row-yr8v-xwgi_arj7 61322 649549 2019-05-29 2018-12-31 23 2         25               25
4694 4694 SHAMROCK GENERAL HOSPITAL 1000 SOUTH MAIN STREET SHAMROCK TX 79079 WHEELER (806) 256-2114 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.1991490 -100.2491890 0   483 48 48483         https://data.medicare.gov/resource/xubh-q36u/row-k4vv_ah6g-uezb 451340 645506 2019-02-25 2018-09-30 25           25               25
3702 3702 YUMA DISTRICT HOSPITAL 1000 W 8TH AVE YUMA CO 80759 YUMA (970) 848-5405 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.1184450 -102.7366540 0   125 8 8125         https://data.medicare.gov/resource/xubh-q36u/row-b6fk_8yss~83cp 61315 649173 2019-05-28 2018-12-31 15           15               15
3027 3027 MELISSA MEMORIAL HOSPITAL 1001 E JOHNSON ST HOLYOKE CO 80734 PHILLIPS (970) 854-2241 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.5784280 -102.2902490 0   95 8 8095         https://data.medicare.gov/resource/xubh-q36u/row-6wcd-peh6-fsnb 61305 650244 2019-05-31 2018-12-31 15           15               15
3269 3269 SLIDELL MEMORIAL HOSPITAL 1001 GAUSE BLVD SLIDELL LA 70458 ST. TAMMANY (985) 643-2200 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.2846510 -89.7704210 0   103 22 22103 35380 New Orleans-Metairie-Hammond, LA-MS Outlying St. Tammany Parish https://data.medicare.gov/resource/xubh-q36u/row-dj7e.4fyq~ywkm 190040 649436 2019-05-30 2018-12-31 123 100         231               231
355 355 KIOWA DISTRICT HOSPITAL 1002 SOUTH 4TH STREET KIOWA KS 67070 BARBER (620) 825-4131 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.0085470 -98.4897950 0   7 20 20007         https://data.medicare.gov/resource/xubh-q36u/row-cbxd_2s68-tihe 171331 648918 2019-05-29 2018-12-31 10           10               10
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
4505 4505 PUTNAM GENERAL HOSPITAL 101 LAKE OCONEE PARKWAY EATONTON GA 31024 PUTNAM (706) 485-2711 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.3355190 -83.3708440 0   237 13 13237         https://data.medicare.gov/resource/xubh-q36u/row-dznu-rxmb.4s2q 111313 645066 2019-03-04 2018-09-30 25           25               25
1192 1192 WHIDBEYHEALTH MEDICAL CENTER 101 NORTH MAIN STREET COUPEVILLE WA 98239 ISLAND (360) 678-5151 Critical Access Hospitals Government - Hospital District or Authority TRUE 48.2142400 -122.6861220 0   29 53 53029 36020 Seattle-Tacoma, WA Central Island County https://data.medicare.gov/resource/xubh-q36u/row-uede_fy5z~txux 501339 649688 2019-05-31 2018-12-31 19 6         25               25
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
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
659 659 DAYTON GENERAL HOSPITAL 1012 SOUTH 3RD STREET DAYTON WA 99328 COLUMBIA (509) 382-2531 Critical Access Hospitals Government - Hospital District or Authority FALSE 46.3125640 -117.9688720 0   13 53 53013 47460   Outlying Columbia County https://data.medicare.gov/resource/xubh-q36u/row-28j5-9jsv-a9rd 501302 648506 2019-05-23 2018-12-31 25           25         23     48
2048 2048 TAHOE FOREST HOSPITAL 10121 PINE AVE TRUCKEE CA 96161 NEVADA (530) 587-6011 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.3251630 -120.2013440 0   57 6 6057 46020 Sacramento-Roseville, CA Central Nevada County https://data.medicare.gov/resource/xubh-q36u/row-n6zm-373j_a9uq 51328 661144 2019-11-27 2019-06-30 19 6         25       37       62
4508 4508 JACKSON HEALTHCARE CENTER 1013 S WELLS EDNA TX 77957 JACKSON (361) 782-7800 Critical Access Hospitals Government - Hospital District or Authority TRUE 28.9693880 -96.6348390 0   239 48 48239         https://data.medicare.gov/resource/xubh-q36u/row-vk5d.74uh-ngkv 451363 644190 2019-02-26 2018-09-30 25           25               25
3703 3703 WRAY COMMUNITY DISTRICT HOSPITAL 1017 WEST 7TH ST WRAY CO 80758 YUMA (970) 332-4811 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.0754050 -102.2346600 0   125 8 8125         https://data.medicare.gov/resource/xubh-q36u/row-jpdk~yrgm-qq54 61309 649710 2019-06-03 2018-12-31 16           16               16
707 707 CARNEGIE TRI-COUNTY MUNICIPAL HOSPITAL 102 NORTH BROADWAY CARNEGIE OK 73015 CADDO (580) 654-1050 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.1075540 -98.6049180 0   15 40 40015         https://data.medicare.gov/resource/xubh-q36u/row-z387~mqsi.t58v 371334 654941 2019-10-02 2019-04-30 17           17               17
4464 4464 HEMPHILL COUNTY HOSPITAL 1020 S 4TH ST CANADIAN TX 79014 HEMPHILL (806) 323-6622 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.9037920 -100.3873990 0   211 48 48211         https://data.medicare.gov/resource/xubh-q36u/row-86yy_5s2m-up8r 450578 646584 2019-04-17 2018-09-30 15           15           2   17
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
4681 4681 UVALDE MEMORIAL HOSPITAL 1025 GARNER FIELD ROAD UVALDE TX 78801 UVALDE (830) 278-6251 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.2151260 -99.7686680 0   463 48 48463 46620   Central Uvalde County https://data.medicare.gov/resource/xubh-q36u/row-v3yf_upph.s38x 451387 660893 2019-11-29 2019-06-30 15 6         21               21
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
4575 4575 MATAGORDA REGIONAL MEDICAL CENTER 104 7TH STREET BAY CITY TX 77414 MATAGORDA (979) 245-6383 Acute Care Hospitals Government - Hospital District or Authority TRUE 28.9828050 -95.9912900 0   321 48 48321 13060 Houston-The Woodlands, TX Central Matagorda County https://data.medicare.gov/resource/xubh-q36u/row-wsg3_j6n3.vs5r 450465 645734 2019-03-26 2018-09-30 40 6         46 12             58
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
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
2658 2658 EASTERN OKLAHOMA MEDICAL CENTER 105 WALL STREET POTEAU OK 74953 LE FLORE (918) 647-8161 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.0439790 -94.6128340 0   79 40 40079 22900   Outlying Le Flore County https://data.medicare.gov/resource/xubh-q36u/row-4db9~xpsx-e222 371337 662241 2019-12-03 2019-06-30 21 4         25 10             35
1385 1385 WELLSTAR SYLVAN GROVE HOSPITAL 1050 MCDONOUGH ROAD JACKSON GA 30233 BUTTS (770) 775-7861 Critical Access Hospitals Government - Hospital District or Authority FALSE 33.3030850 -83.9778230 0   35 13 13035 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Butts County https://data.medicare.gov/resource/xubh-q36u/row-uazj.s3pp-ngue 111319 660799 2019-11-27 2019-06-30 25           25               25
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
3615 3615 ATRIUM HEALTH PINEVILLE 10628 PARK RD CHARLOTTE NC 28210 MECKLENBURG (704) 379-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.0913500 -80.8695290 0   119 37 37119 16740 Charlotte-Concord, NC-SC Central Mecklenburg County https://data.medicare.gov/resource/xubh-q36u/row-bjzs_ptmb_rc7h 340098 650341 2019-05-30 2018-12-31 181 30       10 221   29           250
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
4149 4149 JEFFERSON HOSPITAL 1067 PEACHTREE ST LOUISVILLE GA 30434 JEFFERSON (478) 625-7000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.0097600 -82.4043840 0   163 13 13163         https://data.medicare.gov/resource/xubh-q36u/row-xr6q_7x8r_zksf 110100 646291 2019-04-01 2018-12-31 37           37               37
4612 4612 REFUGIO COUNTY MEMORIAL HOSPITAL 107 SWIFT STREET REFUGIO TX 78377 REFUGIO (361) 526-2321 Critical Access Hospitals Government - Hospital District or Authority TRUE 28.3064870 -97.2794390 0   391 48 48391         https://data.medicare.gov/resource/xubh-q36u/row-2im8~3t6u.ez3t 451317 649504 2019-05-29 2018-12-31 20           20               20
174 174 ALLEN PARISH HOSPITAL 108 6TH AVENUE KINDER LA 70648 ALLEN (337) 738-2527 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.4914530 -92.8556480 0   3 22 22003         https://data.medicare.gov/resource/xubh-q36u/row-572u~e5cv~bbuy 190133 659958 2019-12-02 2019-06-30 25           25 24             49
3569 3569 MARSHALL MEDICAL CENTER 1080 NORTH ELLINGTON PARKWAY LEWISBURG TN 37091 MARSHALL (931) 359-6276 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.4644210 -86.7866520 0   117 47 47117 30280 Nashville-Davidson--Murfreesboro, TN Central Marshall County https://data.medicare.gov/resource/xubh-q36u/row-kdp7~w7ma-n6wt 441309 660459 2019-11-27 2019-06-30 25           25               25
3205 3205 FRANKLIN FOUNDATION HOSPITAL 1097 NORTHWEST BLVD FRANKLIN LA 70538 ST. MARY (337) 828-0760 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.8018700 -91.5252720 0   101 22 22101 34020 Lafayette-Opelousas-Morgan City, LA Central St. Mary Parish https://data.medicare.gov/resource/xubh-q36u/row-72t5.bydx-dr2i 191310 645093 2019-02-28 2018-09-30 20 5         25               25
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
4543 4543 CHATUGE REGIONAL HOSPITAL 110 S MAIN STREET HIAWASSEE GA 30546 TOWNS (706) 896-2222 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.9462820 -83.7543180 0   281 13 13281         https://data.medicare.gov/resource/xubh-q36u/row-mh6r.8qji~7cpb 111324 654720 2019-10-07 2019-04-30 25           25 10     112       147
1126 1126 ADVENTIST HEALTH TEHACHAPI VALLEY 1100 MAGELLAN TEHACHAPI CA 93561 KERN (661) 823-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.1474419 -118.4504364 1 ROOFTOP 29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-xx6n.a25c~74jx 51301 648598 2019-05-31 2018-12-31 16 4         20               20
4678 4678 TYLER COUNTY HOSPITAL 1100 WEST BLUFF WOODVILLE TX 75979 TYLER (409) 283-8141 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.7752870 -94.4282200 0   457 48 48457         https://data.medicare.gov/resource/xubh-q36u/row-xfu9.wq3c~xr3i 450460 660053 2019-11-25 2019-06-30 25           25               25
2395 2395 COFFEE REGIONAL MEDICAL CENTER, INC 1101 OCILLA ROAD DOUGLAS GA 31533 COFFEE (912) 383-5620 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.5095890 -82.8634600 0   69 13 13069 20060   Central Coffee County https://data.medicare.gov/resource/xubh-q36u/row-d473_ue4x.74tq 110089 652866 2019-06-03 2018-12-31 76 10         86               86
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
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
4279 4279 MEMORIAL HOSPITAL 1110 NORTH SARAH DEWITT DRIVE GONZALES TX 78629 GONZALES (830) 672-7581 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.5158950 -97.4288680 0   177 48 48177         https://data.medicare.gov/resource/xubh-q36u/row-7g7y.b4hd-s8g5 450235 659735 2019-11-25 2019-06-30 34           34               34
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
4255 4255 SANFORD CANBY MEDICAL CENTER 112 ST OLAF AVENUE SOUTH CANBY MN 56220 YELLOW MEDCINE (507) 223-7277 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.7078990 -96.2775550 0   173 27 27173         https://data.medicare.gov/resource/xubh-q36u/row-dj3n-ee8i_z8u5 241347 649785 2019-05-30 2018-12-31 22           22       53       75
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
4029 4029 PIEDMONT HENRY HOSPITAL 1133 EAGLE'S LANDING PARKWAY STOCKBRIDGE GA 30281 HENRY (678) 604-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.5089960 -84.2255610 0   151 13 13151 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Henry County https://data.medicare.gov/resource/xubh-q36u/row-vhdk-mf48~gr2g 110191 659490 2019-11-25 2019-06-30 196   40     16 252       89       341
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
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
3341 3341 EMANUEL MEDICAL CENTER 117 KITE ROAD SWAINSBORO GA 30401 EMANUEL (478) 289-1304 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.5932100 -82.3465520 0   107 13 13107         https://data.medicare.gov/resource/xubh-q36u/row-zwa9.bq43.jmum 110109 659232 2019-11-21 2019-06-30 37 8         45 15     49       109
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
3472 3472 ABBEVILLE GENERAL HOSPITAL 118 N HOSPITAL DR ABBEVILLE LA 70510 VERMILION (337) 893-5466 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.9732500 -92.1069860 0   113 22 22113 29180 Lafayette-Opelousas-Morgan City, LA Outlying Vermilion Parish https://data.medicare.gov/resource/xubh-q36u/row-b6fd-eygy.vwqx 190034 649244 2019-05-31 2018-12-31 38 6         44 16             60
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
4571 4571 WILLS MEMORIAL HOSPITAL 120 GORDON STREET WASHINGTON GA 30673 WILKES (706) 678-9212 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.7293020 -82.7423880 0   317 13 13317         https://data.medicare.gov/resource/xubh-q36u/row-xbea-eh76-aa8t 111325 654422 2019-09-23 2019-04-30 25           25               25
4015 4015 COMMUNITY HOSPITAL, ONAGA AND ST MARYS CAMPUS 120 WEST 8TH STREET ONAGA KS 66521 POTTAWATOMIE (785) 889-4272 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.4951550 -96.1708610 0   149 20 20149 31740 Manhattan-Junction City, KS Outlying Pottawatomie County https://data.medicare.gov/resource/xubh-q36u/row-9qa8.y7me.htnm 171354 654124 2019-09-04 2019-03-31 25           25               25
2319 2319 JACKSON COUNTY MEMORIAL HOSPITAL AUTHORITY 1200 EAST PECAN ST ALTUS OK 73521 JACKSON (580) 379-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6352730 -99.3191190 0   65 40 40065 11060   Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-grzh.mrwf.u2yy 370022 660425 2019-11-27 2019-06-30 43 6         49               49
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
3991 3991 WAGONER COMMUNITY HOSPITAL 1200 WEST CHEROKEE STREET WAGONER OK 74467 WAGONER (918) 485-5514 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.9599110 -95.3923770 0   145 40 40145 46140 Tulsa-Muskogee-Bartlesville, OK Central Wagoner County https://data.medicare.gov/resource/xubh-q36u/row-c9ha_a4zk-cz5h 370166 644772 2019-02-26 2018-09-30 94 6         100               100
2585 2585 WHITMAN HOSPITAL AND MEDICAL CENTER 1200 WEST FAIRVIEW COLFAX WA 99111 WHITMAN (509) 397-3435 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.8689190 -117.3750120 0   75 53 53075 39420 Pullman-Moscow, WA-ID Central Whitman County https://data.medicare.gov/resource/xubh-q36u/row-rc2f_yynj.hvxs 501327 652125 2019-05-30 2018-12-31 25           25               25
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
2312 2312 ROUNDUP MEMORIAL HEALTHCARE 1202 3RD ST W ROUNDUP MT 59072 MUSSELSHELL (406) 323-2301 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.4533500 -108.5463330 0   65 30 30065         https://data.medicare.gov/resource/xubh-q36u/row-4hiv-3ibs~jee7 271346 661357 2019-12-02 2019-06-30 25           25               25
3270 3270 ST TAMMANY PARISH HOSPITAL 1202 S TYLER STREET COVINGTON LA 70433 ST. TAMMANY (985) 898-4000 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.4689550 -90.1139350 0   103 22 22103 35380 New Orleans-Metairie-Hammond, LA-MS Outlying St. Tammany Parish https://data.medicare.gov/resource/xubh-q36u/row-g77w.u6w7-nqad 190045 648263 2019-05-24 2018-12-31 149 24         188   12           200
4591 4591 MEMORIAL HOSPITAL 1204 MOUND ST NACOGDOCHES TX 75961 NACOGDOCHES (936) 564-4611 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.6133970 -94.6494550 0   347 48 48347 34860   Central Nacogdoches County https://data.medicare.gov/resource/xubh-q36u/row-uznb.n7zt.xdrg 450508 659737 2019-11-26 2019-06-30 97 16         121   20           141
1363 1363 EVERGREENHEALTH MEDICAL CENTER 12040 NE 128TH STREET KIRKLAND WA 98034 KING (425) 899-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 47.7148720 -122.1785060 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-czqf-dh5d_37vj 500124 651252 2019-06-03 2018-12-31 241 20         304   14       15   333
4697 4697 ELECTRA MEMORIAL HOSPITAL 1207 S BAILEY STREET ELECTRA TX 76360 WICHITA (940) 495-3981 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.0184550 -98.9238740 0   485 48 48485 48660   Central Wichita County https://data.medicare.gov/resource/xubh-q36u/row-cvz8.wx35~2ua3 451343 643657 2019-02-25 2018-09-30 19           19               19
4158 4158 ROOKS COUNTY HEALTH CENTER 1210 NORTH WASHINGTON PLAINVILLE KS 67663 ROOKS (785) 434-4553 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2479670 -99.2982030 0   163 20 20163         https://data.medicare.gov/resource/xubh-q36u/row-y4ci.d2n6.6wdh 171311 651275 2019-06-12 2018-12-31 16           16               16
2094 2094 ISLAND HOSPITAL 1211 24TH STREET ANACORTES WA 98221 SKAGIT (360) 299-1300 Acute Care Hospitals Government - Hospital District or Authority TRUE 48.5028830 -122.6158250 0   57 53 53057 34580 Seattle-Tacoma, WA Central Skagit County https://data.medicare.gov/resource/xubh-q36u/row-7mqw.zfgi.xhpw 500007 651429 2019-06-03 2018-12-31 37 6         43               43
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
37 37 PRATTVILLE BAPTIST HOSPITAL 124 S MEMORIAL DR PRATTVILLE AL 36067 AUTAUGA (334) 361-4267 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.4644230 -86.4509360 0   1 1 1001 33860   Central Autauga County https://data.medicare.gov/resource/xubh-q36u/row-62jx-izkm-znx2 10108 660906 2019-12-04 2019-06-30 49 6         55               55
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
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
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
60 60 UNIVERSITY OF COLORADO HOSPITAL AUTHORITY 12605 E 16TH AVE AURORA CO 80045 ADAMS (720) 848-0000 Acute Care Hospitals Government - Hospital District or Authority TRUE 39.7413640 -104.8412750 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-sx7w-4iik_kiyq 60024 659482 2019-11-25 2019-06-30 432 101   19 24 50 650   12           662
2480 2480 HIGHLAND DISTRICT HOSPITAL 1275 NORTH HIGH STREET HILLSBORO OH 45133 HIGHLAND (937) 393-6100 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2215760 -83.6087710 0   71 39 39071         https://data.medicare.gov/resource/xubh-q36u/row-8tax-6wz7_d86d 361332 648465 2019-05-22 2018-12-31 25           25 10             35
4628 4628 STARR COUNTY MEMORIAL HOSPITAL 128 N FM RD 3167 RIO GRANDE CITY TX 78582 STARR (956) 487-5561 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.3775400 -98.8598860 0   427 48 48427 40100 McAllen-Edinburg, TX Central Starr County https://data.medicare.gov/resource/xubh-q36u/row-x724_tbx6~dpen 450654 646242 2019-03-19 2018-09-30 48           48               48
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
3377 3377 HIGHLAND COMMUNITY HOSPITAL 130 HIGHLAND PKWY PICAYUNE MS 39466 PEARL RIVER (601) 358-9400 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.5524710 -89.6654220 0   109 28 28109 38100 New Orleans-Metairie-Hammond, LA-MS Central Pearl River County https://data.medicare.gov/resource/xubh-q36u/row-desy.hp7i_qtrr 250117 653148 2019-08-22 2018-09-30 43 6         49               49
4610 4610 REAGAN MEMORIAL HOSPITAL 1300 N MAIN AVENUE BIG LAKE TX 76932 REAGAN (325) 844-2561 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.2016510 -101.4615870 0   383 48 48383         https://data.medicare.gov/resource/xubh-q36u/row-3fmb~j2vv~wgtn 451301 651298 2019-03-05 2018-09-30 7           7               7
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
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
4710 4710 GRAHAM REGIONAL MEDICAL CENTER 1301 MONTGOMERY ROAD GRAHAM TX 76450 YOUNG (940) 549-3400 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.0899730 -98.5843560 0   503 48 48503         https://data.medicare.gov/resource/xubh-q36u/row-zgck.cipi_69sb 450085 644359 2019-02-28 2018-09-30 25           25               25
1867 1867 LINDSAY MUNICIPAL HOSPITAL 1305 W CHEROKEE STREET - HIGHWAY 19 WEST LINDSAY OK 73052 GARVIN (405) 756-1404 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.8391179 -97.6263761 1 ROOFTOP 49 40 40049         https://data.medicare.gov/resource/xubh-q36u/row-qvm4-iqce~99wn 370214 657437 2019-10-31 2019-06-30 26           26               26
3893 3893 NORTH OTTAWA COMMUNITY HEALTH SYSTEM 1309 SHELDON RD GRAND HAVEN MI 49417 OTTAWA (616) 842-3600 Acute Care Hospitals Government - Hospital District or Authority TRUE 43.0516100 -86.2279630 0   139 26 26139 24340 Grand Rapids-Wyoming-Muskegon, MI Outlying Ottawa County https://data.medicare.gov/resource/xubh-q36u/row-s2h9-4cnt.tvzd 230174 660593 2019-11-26 2019-06-30 74 7         81               81
3293 3293 CRANE COUNTY HOSPITAL DISTRICT 1310 S ALFORD ST CRANE TX 79731 CRANE (432) 558-3555 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.3905650 -102.3493730 0   103 48 48103         https://data.medicare.gov/resource/xubh-q36u/row-q9vt-2wgg.5txf 451353 655608 2019-02-27 2018-09-30 25           25               25
772 772 GILA REGIONAL MEDICAL CENTER 1313 E 32ND ST SILVER CITY NM 88061 GRANT (575) 538-4100 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7955240 -108.2609080 0   17 35 35017 43500   Central Grant County https://data.medicare.gov/resource/xubh-q36u/row-7frq_jm9p~bbxr 320016 659708 2019-11-26 2019-06-30 26 6         32 10             42
4139 4139 FOREST HEALTH MEDICAL CENTER 135 S PROSPECT ST YPSILANTI MI 48198 WASHTENAW (734) 547-4700 Acute Care Hospitals Government - Hospital District or Authority TRUE 42.2373830 -83.6019160 0   161 26 26161 11460 Detroit-Warren-Ann Arbor, MI Central Washtenaw County https://data.medicare.gov/resource/xubh-q36u/row-txne-8zg7_uajf 230144 650831 2019-06-05 2018-12-31 24           24               24
4511 4511 UNIVERSITY HOSPITAL 1350 WALTON WAY AUGUSTA GA 30901 RICHMOND (706) 722-9011 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.4729890 -81.9813320 0   245 13 13245 12260   Central Richmond County https://data.medicare.gov/resource/xubh-q36u/row-uyz5-fma5.5625 110028 651195 2019-05-31 2018-12-31 417 141         574               574
4549 4549 LIBERTY DAYTON REGIONAL MEDICAL CENTER 1353 N TRAVIS ST LIBERTY TX 77575 LIBERTY (936) 336-7316 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.0685150 -94.7978880 0   291 48 48291 26420 Houston-The Woodlands, TX Outlying Liberty County https://data.medicare.gov/resource/xubh-q36u/row-mqxs.73v9-quxd 451375 651358 2019-03-04 2018-09-30 25           25               25

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