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

244 rows where "filed_date" is on date 2019-05-30 sorted by acute_beds

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

filed_date (date) ✖

  • 2019-05-30 · 244 ✖
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
4424 4424 AD HOSPITAL EAST, LLC 12950 EAST FREEWAY, SUITE 100 HOUSTON TX 77015 HARRIS (713) 330-3897 Acute Care Hospitals Proprietary TRUE 29.7711360 -95.2007820 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-g9pj_7cms.hams 670102 649155 2019-05-30 2018-12-31 4           4               4
3669 3669 PROVIDENCE SEWARD HOSPITAL 417 FIRST AVENUE, PO BOX 365 SEWARD AK 99664 KENAI PENINSULA (907) 224-5205 Critical Access Hospitals Government - Local TRUE 60.1050460 -149.4453830 0   122 2 2122         https://data.medicare.gov/resource/xubh-q36u/row-bjag~4kwr.8ihd 21302 652058 2019-05-30 2018-12-31 6           6       40       46
2297 2297 ST VINCENT GENERAL HOSPITAL DISTRICT 822 W 4TH ST LEADVILLE CO 80461 LAKE (719) 486-0230 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2443920 -106.3033020 0   65 8 8065         https://data.medicare.gov/resource/xubh-q36u/row-zkkb~2fq8_8dib 61319 648894 2019-05-30 2018-12-31 8           8               8
3386 3386 NORTHWEST SURGICAL HOSPITAL 9204 NORTH MAY AVENUE OKLAHOMA CITY OK 73120 OKLAHOMA (405) 848-1918 Acute Care Hospitals Physician TRUE 35.5641660 -97.5671590 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-a9dt_8msh-9ahb 370192 650519 2019-05-30 2018-12-31 9           9               9
3933 3933 THE HOSPITALS OF PROVIDENCE HORIZON CITY CAMPUS 13600 HORIZON STREET, SUITE 100 HORIZON CITY TX 79928 EL PASO (915) 407-7878 Acute Care Hospitals Proprietary TRUE 31.6827230 -106.2073480 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-m5db~xjiy~dvv3 670124 649391 2019-05-30 2018-12-31 9           9               9
1615 1615 SANFORD CLEAR LAKE MEDICAL CENTER 701 THIRD AVENUE SOUTH CLEAR LAKE SD 57226 DEUEL (605) 874-2141 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.7526780 -96.6825600 0   39 46 46039         https://data.medicare.gov/resource/xubh-q36u/row-tyxz_xmhj~kyxp 431307 652104 2019-05-30 2018-12-31 10           10               10
2008 2008 LAFAYETTE GENERAL SURGICAL HOSPITAL 1000 W PINHOOK RD SUITE 100 LAFAYETTE LA 70503 LAFAYETTE (337) 289-8095 Acute Care Hospitals Physician FALSE 30.2042530 -92.0134680 0   55 22 22055 29180 Lafayette-Opelousas-Morgan City, LA Central Lafayette Parish https://data.medicare.gov/resource/xubh-q36u/row-i7bm~9svd~q42h 190268 649248 2019-05-30 2018-12-31 10           10               10
2009 2009 PARK PLACE SURGICAL HOSPITAL 4811 AMBASSADOR CAFFERY PARKWAY LAFAYETTE LA 70508 LAFAYETTE (337) 237-8119 Acute Care Hospitals Physician FALSE 30.1497980 -92.0401140 0   55 22 22055 29180 Lafayette-Opelousas-Morgan City, LA Central Lafayette Parish https://data.medicare.gov/resource/xubh-q36u/row-pekc_yry2_bpdk 190255 649246 2019-05-30 2018-12-31 10           10               10
2405 2405 REGIONAL WEST GARDEN COUNTY HOSPITAL 1100 WEST 2ND ST OSHKOSH NE 69154 GARDEN (308) 772-3283 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4124850 -102.3475730 0   69 31 31069         https://data.medicare.gov/resource/xubh-q36u/row-ak6k-74t4-rjik 281310 649128 2019-05-30 2018-12-31 10           10           40   50
2806 2806 EDGEWOOD SURGICAL HOSPITAL 239 EDGEWOOD DRIVE EXTENSION TRANSFER PA 16154 MERCER (724) 646-0400 Acute Care Hospitals Physician FALSE 41.3300510 -80.4178550 0   85 42 42085 49660 Youngstown-Warren, OH-PA Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-rh2b~kawm~nsdh 390307 649489 2019-05-30 2018-12-31 10           10               10
4077 4077 SUMMIT SURGICAL, LLC 1818 EAST 23RD AVENUE HUTCHINSON KS 67502 RENO (620) 662-6000 Acute Care Hospitals Physician FALSE 38.0795300 -97.8885950 0   155 20 20155 26740   Central Reno County https://data.medicare.gov/resource/xubh-q36u/row-rrpw.z43u-xa5d 170198 649226 2019-05-30 2018-12-31 10           10               10
4529 4529 PROVIDENCE VALDEZ MEDICAL CENTER PO BOX 550 VALDEZ AK 99686 VALDEZ-CORDOVA (907) 835-2249 Critical Access Hospitals Government - Local TRUE 61.1364781 -146.3458866 1 ROOFTOP 261 2 2261         https://data.medicare.gov/resource/xubh-q36u/row-2ygw.872k~d2en 21301 652057 2019-05-30 2018-12-31 11           11       10       21
4426 4426 FIRST TEXAS HOSPITAL 9922 LOUETTA RD HOUSTON TX 77070 HARRIS (844) 264-1435 Acute Care Hospitals Proprietary TRUE 30.0008390 -95.5608680 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-t68p~4ggy.94di 670118 649157 2019-05-30 2018-12-31 12           12               12
1450 1450 OAKLEAF SURGICAL HOSPITAL 1000 OAKLEAF WAY ALTOONA WI 54720 EAU CLAIRE (715) 831-8130 Acute Care Hospitals Physician FALSE 44.8150020 -91.4517640 0   35 55 55035 20740 Eau Claire-Menomonie, WI Central Eau Claire County https://data.medicare.gov/resource/xubh-q36u/row-4tiq~2hj5~t8xv 520196 650624 2019-05-30 2018-12-31 13           13               13
1502 1502 WEST COVINA MEDICAL CENTER, INC 725 S ORANGE AVE WEST COVINA CA 91790 LOS ANGELES (626) 338-8481 Acute Care Hospitals Proprietary FALSE 34.0709280 -117.9441660 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-mrqt_jczt_crz9 50096 652580 2019-05-30 2018-12-31 13           13       33       46
4530 4530 CORDOVA COMMUNITY MEDICAL CENTER PO BOX 160 - 602 CHASE AVENUE CORDOVA AK 99574 VALDEZ-CORDOVA (907) 424-8000 Critical Access Hospitals Government - Local TRUE 60.5413354 -145.7505310 1 ROOFTOP 261 2 2261         https://data.medicare.gov/resource/xubh-q36u/row-kscp_6dza~rvey 21307 650633 2019-05-30 2018-12-31 13           13       10       23
376 376 ATRIUM HEALTH ANSON 2301 US HIGHWAY 74 WEST WADESBORO NC 28170 ANSON (704) 694-5131 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.9785320 -80.1096790 0   7 37 37007         https://data.medicare.gov/resource/xubh-q36u/row-mv5j_iuia_xbie 340084 650339 2019-05-30 2018-12-31 15           15               15
1012 1012 MARGARETVILLE MEMORIAL HOSPITAL 42084 STATE HIGHWAY 28 MARGARETVILLE NY 12455 DELAWARE (845) 586-2631 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1476540 -74.6426290 0   25 36 36025         https://data.medicare.gov/resource/xubh-q36u/row-n54k.cyed-635i 331304 650758 2019-05-30 2018-12-31 15           15       82       97
1844 1844 MAYO CLINIC HEALTH SYSTEM-CANNON FALLS 32021 COUNTY 24 BOULEVARD CANNON FALLS MN 55009 GOODHUE (507) 263-6000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4859000 -92.9032500 0   49 27 27049 39860 Minneapolis-St. Paul, MN-WI Central Goodhue County https://data.medicare.gov/resource/xubh-q36u/row-wnpm.4cz9.5bg4 241346 649783 2019-05-30 2018-12-31 15           15               15
4142 4142 MAYO CLINIC HEALTH SYSTEM-WASECA 501 NORTH STATE STREET WASECA MN 56093 WASECA (507) 835-1210 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0815250 -93.5072970 0   161 27 27161         https://data.medicare.gov/resource/xubh-q36u/row-hubg_wxh8.5xfj 241345 649782 2019-05-30 2018-12-31 15           15               15
4423 4423 MEMORIAL HERMANN FIRST COLONY HOSPITAL 24429 TOMBALL PARKWAY, SUITE 100 TOMBALL TX 77375 HARRIS (281) 516-0911 Acute Care Hospitals Proprietary FALSE 30.0371760 -95.6053230 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-wtak~qp2w~qmyj 670095 649016 2019-05-30 2018-12-31 15           15               15
4449 4449 WILSON MEDICAL CENTER REECE CAMPUS 2600 OTTAWA ROAD NEODESHA KS 66757 WILSON (620) 325-2611 Critical Access Hospitals Government - Local TRUE 37.4085290 -95.7082419 1 ROOFTOP 205 20 20205         https://data.medicare.gov/resource/xubh-q36u/row-fh4a~9srx~xwnp 171344 649229 2019-05-30 2018-12-31 15           15               15
4427 4427 PROVIDENCE HOSPITAL OF NORTH HOUSTON LLC 16750 RED OAK DRIVE HOUSTON TX 77090 HARRIS (281) 453-7916 Acute Care Hospitals Proprietary TRUE 30.0142780 -95.4409351 1 ROOFTOP 201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-akm5~pcmt~sgnr 670119 648515 2019-05-30 2018-12-31 16           16               16
864 864 MOAB REGIONAL HOSPITAL 450 WEST WILLIAMS WAY MOAB UT 84532 GRAND (435) 719-3500 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.5743000 -109.5600030 0   19 49 49019         https://data.medicare.gov/resource/xubh-q36u/row-jugr_gjvr_fri6 461302 652116 2019-05-30 2018-12-31 17           17               17
1109 1109 DELTA COMMUNITY HOSPITAL 126 SOUTH WHITE SAGE AVENUE DELTA UT 84624 MILLARD (435) 864-5591 Critical Access Hospitals Proprietary TRUE 39.3502940 -112.5600230 0   27 49 49027         https://data.medicare.gov/resource/xubh-q36u/row-drqc-aprc.hcpi 461300 652115 2019-05-30 2018-12-31 18           18               18
1843 1843 MAYO CLINIC HEALTH SYSTEM - LAKE CITY 500 WEST GRANT STREET LAKE CITY MN 55041 WABASHA (651) 345-5955 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4583350 -92.2883650 0   49 27 27049 39860 Minneapolis-St. Paul, MN-WI Central Goodhue County https://data.medicare.gov/resource/xubh-q36u/row-xfrx_892y-jk4u 241338 649781 2019-05-30 2018-12-31 18           18       90       108
2264 2264 NORTH CAROLINA SPECIALTY HOSPITAL 3916 BEN FRANKLIN BOULEVARD DURHAM NC 27704 DURHAM (919) 956-9300 Acute Care Hospitals Proprietary FALSE 36.0428650 -78.8975480 0   63 37 37063 20500 Raleigh-Durham-Chapel Hill, NC Central Durham County https://data.medicare.gov/resource/xubh-q36u/row-qk28.yf4v-b8w5 340049 650337 2019-05-30 2018-12-31 18           18               18
3510 3510 FIRST TEXAS HOSPITAL CARROLLTON LLC 1401 E TRINITY MILLS ROAD CARROLLTON TX 75006 DALLAS (972) 810-0700 Acute Care Hospitals Proprietary TRUE 32.9850010 -96.8982210 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-pssx_vyvi-xhzt 670110 651438 2019-05-30 2018-12-31 18           18               18
2088 2088 MEMORIAL MEDICAL CENTER 815 N VIRGINIA STREET PORT LAVACA TX 77979 CALHOUN (361) 552-6713 Critical Access Hospitals Government - Local TRUE 28.6209120 -96.6315370 0   57 48 48057 38920 Victoria-Port Lavaca, TX Central Calhoun County https://data.medicare.gov/resource/xubh-q36u/row-fkri_527j~nq75 451356 650380 2019-05-30 2018-12-31 19 6         25               25
1698 1698 UNITED HOSPITAL DISTRICT 515 SOUTH MOORE STREET, PO BOX 160 BLUE EARTH MN 56013 FARIBAULT (507) 526-3273 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.6342900 -94.1008840 0   43 27 27043         https://data.medicare.gov/resource/xubh-q36u/row-hive~sdke_37q9 241369 649912 2019-05-30 2018-12-31 20 4         24           1   25
2540 2540 PONDERA MEDICAL CENTER 805 SUNSET BLVD CONRAD MT 59425 PONDERA (406) 271-3211 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1739170 -111.9586770 0   73 30 30073         https://data.medicare.gov/resource/xubh-q36u/row-23g5-69uu.yhw9 271324 652085 2019-05-30 2018-12-31 20           20       59       79
3895 3895 MAYO CLINIC HEALTH SYSTEM-NEW PRAGUE 301 2ND STREET NORTHEAST NEW PRAGUE MN 56071 SCOTT (952) 758-4431 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.5459260 -93.5749030 0   139 27 27139 33460 Minneapolis-St. Paul, MN-WI Central Scott County https://data.medicare.gov/resource/xubh-q36u/row-7zvq_kinr_xbfq 241361 649911 2019-05-30 2018-12-31 20           20               20
41 41 WHITE MOUNTAIN REGIONAL MEDICAL CENTER 118 SOUTH MOUNTAIN AVENUE SPRINGERVILLE AZ 85938 APACHE (928) 333-4368 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1321360 -109.2865450 0   1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-dkxh~vpbb.s52c 31315 652061 2019-05-30 2018-12-31 21           21               21
88 88 ADAMS MEMORIAL HOSPITAL 1100 MERCER AVE DECATUR IN 46733 ADAMS (260) 724-2145 Critical Access Hospitals Government - Local TRUE 40.8179660 -84.9125350 0   1 18 18001 19540 Fort Wayne-Huntington-Auburn, IN Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-vdys.bcxa-gdh7 151330 649100 2019-05-30 2018-12-31 21 4         25               25
1830 1830 MIDDLE PARK MEDICAL CENTER 214 4TH ST KREMMLING CO 80459 GRAND (970) 724-3442 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.0575000 -106.3911830 0   49 8 8049         https://data.medicare.gov/resource/xubh-q36u/row-zyfv.qfrq_5wh2 61318 649174 2019-05-30 2018-12-31 21           21               21
3086 3086 ASPEN VALLEY HOSPITAL 401 CASTLE CREEK RD ASPEN CO 81611 PITKIN (970) 544-1261 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.1900570 -106.8377840 0   97 8 8097 24060 Edwards-Glenwood Springs, CO Outlying Pitkin County https://data.medicare.gov/resource/xubh-q36u/row-w4f4-8yin.fcc5 61324 649403 2019-05-30 2018-12-31 21 4         25               25
4323 4323 WABASH GENERAL HOSPITAL 1 1418 COLLEGE DRIVE MOUNT CARMEL IL 62863 WABASH (618) 262-8621 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.4216250 -87.7687720 0   185 17 17185         https://data.medicare.gov/resource/xubh-q36u/row-4k4x-d3n5.d5n5 141327 649727 2019-05-30 2018-12-31 21 4         25               25
1877 1877 OREM COMMUNITY HOSPITAL 331 NORTH 400 WEST OREM UT 84057 UTAH (801) 714-3300 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3032550 -111.7054070 0   49 49 49049 39340 Salt Lake City-Provo-Orem, UT Central Utah County https://data.medicare.gov/resource/xubh-q36u/row-bbaq.r2pn_q46z 460043 652112 2019-05-30 2018-12-31 22           22               22
3707 3707 PELLA REGIONAL HEALTH CENTER 404 JEFFERSON STREET PELLA IA 50219 MARION (641) 628-3150 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4123370 -92.9116670 0   125 19 19125         https://data.medicare.gov/resource/xubh-q36u/row-8vwd.cjzd~uvhp 161367 649107 2019-05-30 2018-12-31 22 3         25           6   31
4059 4059 LAKEWOOD HEALTH SYSTEM 49725 COUNTY ROAD 83 STAPLES MN 56479 TODD (218) 894-1515 Critical Access Hospitals Voluntary non-profit - Other TRUE 46.3508690 -94.7483930 0   153 27 27153         https://data.medicare.gov/resource/xubh-q36u/row-vn9e~m7ke-5ysu 241329 650720 2019-05-30 2018-12-31 22 3         25 10     100       135
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
1325 1325 THE SPINE HOSPITAL OF LOUISIANA 10105 PARK ROW CIRCLE, SUITE 250 BATON ROUGE LA 70810 E. BATON ROUGE (225) 763-9900 Acute Care Hospitals Voluntary non-profit - Private FALSE 30.3803040 -91.0944530 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-tmb2.vpzg_7bvf 190266 649247 2019-05-30 2018-12-31 23           23               23
4009 4009 TMC- BONHAM HOSPITAL 504 LIPSCOMB STREET BONHAM TX 75418 FANNIN (903) 640-7311 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.5781300 -96.1674790 0   147 48 48147         https://data.medicare.gov/resource/xubh-q36u/row-va26~mxxb.q557 451370 649507 2019-05-30 2018-12-31 23 2         25               25
689 689 MAYO CLINIC HEALTH SYSTEM-SPRINGFIELD 625 JACKSON AVENUE NORTH SPRINGFIELD MN 56087 BROWN (507) 723-6201 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.2457470 -94.9716490 0   15 27 27015 35580 Mankato-New Ulm-North Mankato, MN Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-fczk.ip7t_6vg8 241352 649910 2019-05-30 2018-12-31 24           24               24
3177 3177 SURGICAL HOSPITAL AT SOUTHWOODS 7630 SOUTHERN BLVD YOUNGSTOWN OH 44512 MAHONING (330) 729-8000 Acute Care Hospitals Proprietary FALSE 41.0153550 -80.6534390 0   99 39 39099 49660 Youngstown-Warren, OH-PA Central Mahoning County https://data.medicare.gov/resource/xubh-q36u/row-422i~a2cq-j6nr 360352 648972 2019-05-30 2018-12-31 24           24               24
3917 3917 OSBORNE COUNTY MEMORIAL HOSPITAL 424 W NEW HAMPSHIRE STREET OSBORNE KS 67473 OSBORNE (785) 346-2121 Critical Access Hospitals Government - Local TRUE 39.4366820 -98.7011590 0   141 20 20141         https://data.medicare.gov/resource/xubh-q36u/row-fbsc.wavi.k36j 171364 648924 2019-05-30 2018-12-31 24           24               24
4028 4028 PROVIDENCE KODIAK ISLAND MEDICAL CTR 1915 EAST REZANOF DRIVE KODIAK AK 99615 KODIAK ISLAND BOROUGH (907) 486-9592 Critical Access Hospitals Voluntary non-profit - Church TRUE 57.8008350 -152.3739430 0   150 2 2150         https://data.medicare.gov/resource/xubh-q36u/row-3uhe-ufvn.rmdi 21306 652059 2019-05-30 2018-12-31 24           24       22       46
4643 4643 BAYLOR SCOTT AND WHITE EMERGENCY HOSPITAL BURLESON 12500 SOUTH FREEWAY SUITE 100 BURLESON TX 76028 JOHNSON (214) 294-6250 Acute Care Hospitals Proprietary TRUE 32.5760100 -97.3207740 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-f6z2_rbym-eqyb 670107 649156 2019-05-30 2018-12-31 24           24               24
117 117 ADAMS COUNTY REGIONAL MEDICAL CENTER 230 MEDICAL CENTER DRIVE SEAMAN OH 45679 ADAMS (937) 386-3400 Critical Access Hospitals Government - Local TRUE 38.9338480 -83.5856120 0   1 39 39001         https://data.medicare.gov/resource/xubh-q36u/row-wb9j-jzwz-2xmu 361326 649329 2019-05-30 2018-12-31 25           25               25
254 254 MEDICAL CENTER BARBOUR 820 W WASHINGTON ST EUFAULA AL 36027 BARBOUR (334) 688-7271 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.8879800 -85.1566130 0   5 1 1005         https://data.medicare.gov/resource/xubh-q36u/row-b9cj~n2ap_7hxj 10069 651152 2019-05-30 2018-12-31 25 5         30 17             47
290 290 ALLEGAN GENERAL HOSPITAL 555 LINN STREET ALLEGAN MI 49010 ALLEGAN (269) 686-4101 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.5202590 -85.8569390 0   5 26 26005 26090 Grand Rapids-Wyoming-Muskegon, MI Central Allegan County https://data.medicare.gov/resource/xubh-q36u/row-9kac~4r3i~rk7m 231328 649266 2019-05-30 2018-12-31 25           25               25
339 339 OZARKS COMMUNITY HOSPITAL OF GRAVETTE 1101 JACKSON STREET SW GRAVETTE AR 72736 BENTON (479) 787-5291 Critical Access Hospitals Proprietary TRUE 36.4085630 -94.4598700 0   7 5 5007 22220   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-snva.mem9_cs94 41331 651314 2019-05-30 2018-12-31 25           25               25
457 457 ASHE MEMORIAL HOSPITAL 200 HOSPITAL AVE JEFFERSON NC 28640 ASHE (336) 246-7101 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.4230270 -81.4597270 0   9 37 37009         https://data.medicare.gov/resource/xubh-q36u/row-adyt~iqxi_gv2a 341325 650353 2019-05-30 2018-12-31 25           25               25
713 713 SANFORD CHAMBERLAIN MEDICAL CENTER 300 S BYRON CHAMBERLAIN SD 57325 BRULE (605) 234-5511 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.7851100 -99.3261340 0   15 46 46015         https://data.medicare.gov/resource/xubh-q36u/row-cv97_2b3i.ibpd 431329 652106 2019-05-30 2018-12-31 25           25         44     69
953 953 SOUTH CAMERON MEMORIAL HOSPITAL 5360 WEST CREOLE HWY CAMERON LA 70631 CAMERON (337) 542-4111 Acute Care Hospitals Proprietary TRUE 29.8071730 -93.1652450 0   23 22 22023 29340   Outlying Cameron Parish https://data.medicare.gov/resource/xubh-q36u/row-59pq~i76h_a9yh 190307 648537 2019-05-30 2018-12-31 25           25 24             49
984 984 GARFIELD COUNTY MEMORIAL HOSPITAL 66 NORTH SIXTH STREET POMEROY WA 99347 GARFIELD (509) 843-1591 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.4751830 -117.6025510 0   23 53 53023         https://data.medicare.gov/resource/xubh-q36u/row-estz_txzt_98nt 501301 650792 2019-05-30 2018-12-31 25           25               25
1073 1073 BRECKINRIDGE MEMORIAL HOSPITAL 1011 OLD HIGHWAY 60 HARDINSBURG KY 40143 BRECKINRIDGE (270) 756-7000 Critical Access Hospitals Government - Local TRUE 37.7666150 -86.4416430 0   27 21 21027         https://data.medicare.gov/resource/xubh-q36u/row-x9zn_pcg8_7qr2 181319 648926 2019-05-30 2018-12-31 25           25       18       43
1694 1694 NEWMAN MEMORIAL HOSPITAL 905 SOUTH MAIN STREET SHATTUCK OK 73858 ELLIS (580) 938-2551 Critical Access Hospitals Government - Local TRUE 36.2681320 -99.8815380 0   45 40 40045         https://data.medicare.gov/resource/xubh-q36u/row-7tme~3s76_iax8 371336 649132 2019-05-30 2018-12-31 25           25               25
1716 1716 GUNDERSEN BOSCOBEL AREA HOSPITAL AND CLINICS 205 PARKER ST BOSCOBEL WI 53805 GRANT (608) 375-4112 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.1329260 -90.7077440 0   43 55 55043 38420   Central Grant County https://data.medicare.gov/resource/xubh-q36u/row-7ur6-ec65_gtvs 521344 650627 2019-05-30 2018-12-31 25           25               25
1732 1732 PARIS COMMUNITY HOSPITAL 721 E COURT STREET PARIS IL 61944 EDGAR (217) 465-4141 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.6067120 -87.6783110 0   45 17 17045         https://data.medicare.gov/resource/xubh-q36u/row-vi85_kv7j_pcxz 141320 649726 2019-05-30 2018-12-31 25           25               25
1831 1831 ADVENTHEALTH WAUCHULA 735 S 5TH AVE WAUCHULA FL 33873 HARDEE (863) 773-0216 Critical Access Hospitals Voluntary non-profit - Private TRUE 27.5394213 -81.8072774 1 ROOFTOP 49 12 12049 48100   Central Hardee County https://data.medicare.gov/resource/xubh-q36u/row-ev8e.32dq-kwq8 101300 649888 2019-05-30 2018-12-31 25           25               25
1897 1897 FAYETTE COUNTY HOSPITAL 7TH AND TAYLOR VANDALIA IL 62471 FAYETTE (618) 283-1231 Critical Access Hospitals Voluntary non-profit - Other TRUE 38.9706410 -89.0988780 1 GEOMETRIC_CENTER 51 17 17051         https://data.medicare.gov/resource/xubh-q36u/row-3m36-npvv-f9tn 141346 648907 2019-05-30 2018-12-31 25 4         29       85       114
2329 2329 PROVIDENCE MOUNT CARMEL HOSPITAL 982 EAST COLUMBIA COLVILLE WA 99114 STEVENS (509) 684-2561 Critical Access Hospitals Voluntary non-profit - Church TRUE 48.5413030 -117.8923850 0   65 53 53065 44060 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Outlying Stevens County https://data.medicare.gov/resource/xubh-q36u/row-bdxz~aq5d-z6tm 501326 652171 2019-05-30 2018-12-31 25           25               25
2376 2376 FREEMAN MEDICAL CENTER - CAH 510 E 8TH ST POST OFFICE BOX 370 FREEMAN SD 57029 HUTCHINSON (605) 925-4000 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3475430 -97.4310460 0   67 46 46067         https://data.medicare.gov/resource/xubh-q36u/row-hqee_nmdi.myuu 431313 650610 2019-05-30 2018-12-31 25           25       51       76
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
2607 2607 PATTERSON HEALTH CENTER 485 N. KS HWY 2 ANTHONY KS 67003 HARPER (620) 842-5111 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.1563360 -98.0393230 0   77 20 20077         https://data.medicare.gov/resource/xubh-q36u/row-twh3.zvup_2ech 171346 648922 2019-05-30 2018-12-31 25           25               25
2751 2751 SANFORD TRACY MEDICAL CENTER 251 FIFTH STREET EAST TRACY MN 56175 LYON (507) 629-8400 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.2322370 -95.6067500 0   83 27 27083 32140   Central Lyon County https://data.medicare.gov/resource/xubh-q36u/row-cgqv~g86j.h4yz 241303 649776 2019-05-30 2018-12-31 25           25               25
2854 2854 PARKVIEW LAGRANGE HOSPITAL 207 N TOWNLINE RD LAGRANGE IN 46761 LAGRANGE (260) 463-9000 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.6458030 -85.4249360 0   87 18 18087         https://data.medicare.gov/resource/xubh-q36u/row-kmf8-5wmj-tqaz 151323 649099 2019-05-30 2018-12-31 25           25               25
2982 2982 ADVENTHEALTH DURAND 1220 3RD AVE W DURAND WI 54736 PEPIN (715) 672-4211 Critical Access Hospitals Voluntary non-profit - Church TRUE 44.6203090 -91.9635000 0   91 55 55091         https://data.medicare.gov/resource/xubh-q36u/row-qzeb.agub~nfph 521307 650794 2019-05-30 2018-12-31 25           25               25
3095 3095 SCHUYLER HOSPITAL, INC 220 STEUBEN STREET MONTOUR FALLS NY 14865 SCHUYLER (607) 530-7121 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.3514530 -76.8588420 0   97 36 36097         https://data.medicare.gov/resource/xubh-q36u/row-kbkw-wgyf_adjj 331313 650759 2019-05-30 2018-12-31 25           25       120       145
3695 3695 WINNER REGIONAL HEALTHCARE CENTER - CAH 745 EAST 8TH STREET WINNER SD 57580 TRIPP (605) 842-7100 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3709470 -99.8476170 0   123 46 46123         https://data.medicare.gov/resource/xubh-q36u/row-8vjy-k644_c637 431334 650611 2019-05-30 2018-12-31 25           25       80       105
3777 3777 INDIANHEAD MEDICAL CENTER SHELL LAKE 113 4TH AVE SHELL LAKE WI 54871 WASHBURN (715) 468-7833 Critical Access Hospitals Proprietary TRUE 45.7421020 -91.9257800 0   129 55 55129         https://data.medicare.gov/resource/xubh-q36u/row-kcr4.6q2e-4e5f 521342 650795 2019-05-30 2018-12-31 25           25               25
4189 4189 MAYO CLINIC HEALTH SYSTEM - ST JAMES 1101 MOULTON AND PARSONS DRIVE ST JAMES MN 56081 WATONWAN (507) 375-8601 Critical Access Hospitals Voluntary non-profit - Other FALSE 43.9694900 -94.6215150 0   165 27 27165         https://data.medicare.gov/resource/xubh-q36u/row-iach_4kbz_5xj2 241333 649779 2019-05-30 2018-12-31 25           25               25
4444 4444 ADVOCATE EUREKA HOSPITAL 101 S MAJOR ST EUREKA IL 61530 WOODFORD (309) 467-2371 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.7214050 -89.2716610 0   203 17 17203 37900 Peoria-Canton, IL Central Woodford County https://data.medicare.gov/resource/xubh-q36u/row-4ygy~3sdv-kmqs 141309 649725 2019-05-30 2018-12-31 25           25               25
4650 4650 TEXAS HEALTH HEART & VASCULAR HOSPITAL ARLINGTON 811 WRIGHT STREET ARLINGTON TX 76012 TARRANT (817) 960-3500 Acute Care Hospitals Proprietary FALSE 32.7482060 -97.1163900 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-qhpw~99pb.trhs 670071 649388 2019-05-30 2018-12-31 27   20       47               47
3671 3671 RUSSELL MEDICAL CENTER 3316 HIGHWAY 280 ALEXANDER CITY AL 35010 TALLAPOOSA (256) 329-7100 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.9310300 -85.9683940 0   123 1 1123         https://data.medicare.gov/resource/xubh-q36u/row-7ugw.v846~xcyn 10065 651308 2019-05-30 2018-12-31 28 6         34               34
3914 3914 UNITY MEDICAL AND SURGICAL HOSPITAL 4455 EDISON LAKES PKWY MISHAWAKA IN 46545 ST. JOSEPH (574) 231-6800 Acute Care Hospitals Physician FALSE 41.7007230 -86.1767810 0   141 18 18141 43780 South Bend-Elkhart-Mishawaka, IN-MI Central St. Joseph County https://data.medicare.gov/resource/xubh-q36u/row-ezgx~i6vb_t9ti 150177 649092 2019-05-30 2018-12-31 29           29               29
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
1853 1853 PRESBYTERIAN SANTA FE MEDICAL CENTER 4801 BECKNER ROAD SANTA FE NM 87507 SANTA FE (505) 923-8826 Acute Care Hospitals Voluntary non-profit - Private FALSE 35.6165864 -106.0251239 1 ROOFTOP 49 35 35049 42140 Albuquerque-Santa Fe-Las Vegas, NM Central Santa Fe County https://data.medicare.gov/resource/xubh-q36u/row-4xmd_h3kt.run3 320090 649298 2019-05-30 2018-12-31 30 6         36               36
4306 4306 PARKVIEW WHITLEY HOSPITAL 1260 E SR 205 COLUMBIA CITY IN 46725 WHITLEY (260) 248-9301 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.1602610 -85.4665710 0   183 18 18183 23060 Fort Wayne-Huntington-Auburn, IN Outlying Whitley County https://data.medicare.gov/resource/xubh-q36u/row-7gf9.m2fd_samg 150101 649085 2019-05-30 2018-12-31 30           30               30
200 200 DIGNITY HEALTH ST ROSE DOMINICAN N L V CAMPUS 1550 W CRAIG RANCH NORTH LAS VEGAS NV 89031 CLARK (702) 777-3615 Acute Care Hospitals Proprietary TRUE 36.2434428 -115.1500008 1 ROOFTOP 3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-u3b3_a37u-466v 290058 652436 2019-05-30 2018-12-31 32           32               32
3121 3121 MADISON HEALTH 210 NORTH MAIN STREET LONDON OH 43140 MADISON (740) 845-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8920010 -83.4551750 0   97 39 39097 18140 Columbus-Marion-Zanesville, OH Outlying Madison County https://data.medicare.gov/resource/xubh-q36u/row-4ujt.kz8t-gzn7 360189 648971 2019-05-30 2018-12-31 32 13         45               45
1713 1713 PARK CITY HOSPITAL 900 ROUND VALLEY DRIVE PARK CITY UT 84060 SUMMIT (435) 658-6700 Acute Care Hospitals Proprietary TRUE 40.6876970 -111.4689520 0   43 49 49043 44920 Salt Lake City-Provo-Orem, UT Central Summit County https://data.medicare.gov/resource/xubh-q36u/row-ecxv.jm7a~8gnk 460057 652113 2019-05-30 2018-12-31 33 4         37               37
4641 4641 WISE HEALTH SYSTEM 3200 NORTH TARRANT PARKWAY FORT WORTH TX 76177 TARRANT (817) 502-7300 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.8974340 -97.3122990 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-nkp3_nyc5_hqkg 670116 650433 2019-05-30 2018-12-31 36           36               36
899 899 CALDWELL MEMORIAL HOSPITAL, INC 411 MAIN STREET COLUMBIA LA 71418 CALDWELL (318) 649-6111 Acute Care Hospitals Voluntary non-profit - Private FALSE 32.1041420 -92.0761550 0   21 22 22021         https://data.medicare.gov/resource/xubh-q36u/row-tzge.ni5n-rwic 190190 649740 2019-05-30 2018-12-31 37           37   10           47
3453 3453 SSM HEALTH ST CLARE HOSPITAL - BARABOO 707 14TH ST BARABOO WI 53913 SAUK (608) 356-1400 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.4806070 -89.7311940 0   111 55 55111 12660 Madison-Janesville-Beloit, WI Central Sauk County https://data.medicare.gov/resource/xubh-q36u/row-8rej_x5m4.4y83 520057 650543 2019-05-30 2018-12-31 37 6         43               43
3759 3759 DUNES SURGICAL HOSPITAL 600 N SIOUX POINT ROAD DAKOTA DUNES SD 57049 UNION (605) 232-3332 Acute Care Hospitals Proprietary FALSE 42.5047530 -96.4968160 0   127 46 46127 43580 Sioux City-Vermillion, IA-SD-NE Central Union County https://data.medicare.gov/resource/xubh-q36u/row-c5z7~7eiv-hfta 430089 650781 2019-05-30 2018-12-31 38           38               38
2150 2150 GLEN COVE HOSPITAL 101 ST ANDREWS LANE GLEN COVE NY 11542 NASSAU (516) 674-7300 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8711487 -73.6225297 1 ROOFTOP 59 36 36059 35620 New York-Newark, NY-NJ-CT-PA Central Nassau County https://data.medicare.gov/resource/xubh-q36u/row-68zb.5ywk.9gmb 330181 650306 2019-05-30 2018-12-31 39 10 5       54   65           119
2463 2463 ST CHARLES SURGICAL HOSPITAL LLC 1717 ST CHARLES AVE NEW ORLEANS LA 70130 ORLEANS (504) 529-6600 Acute Care Hospitals Physician FALSE 29.9373710 -90.0768800 0   71 22 22071 35380 New Orleans-Metairie-Hammond, LA-MS Central Orleans Parish https://data.medicare.gov/resource/xubh-q36u/row-bm2i-2rpj_kw3b 190300 649438 2019-05-30 2018-12-31 39           39               39
3442 3442 HEALTHALLIANCE HOSPITAL MARYS AVENUE CAMPUS 105 MARY'S AVENUE KINGSTON NY 12401 ULSTER (845) 338-2500 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.9224530 -73.9993350 0   111 36 36111 28740 New York-Newark, NY-NJ-CT-PA Central Ulster County https://data.medicare.gov/resource/xubh-q36u/row-b9ub-wy3m.n2hu 330224 650747 2019-05-30 2018-12-31 40 5         45 40 20           105
3658 3658 BAYLOR SCOTT AND WHITE EMERGENCY HOSPITAL AUBREY 26791 HIGHWAY 380 AUBREY TX 76227 DENTON (972) 347-2525 Acute Care Hospitals Proprietary TRUE 33.2206581 -96.9135249 1 ROOFTOP 121 48 48121 19100 Dallas-Fort Worth, TX-OK Outlying Denton County https://data.medicare.gov/resource/xubh-q36u/row-9pb6.v6ys-8mdu 670062 649013 2019-05-30 2018-12-31 40           40               40
3970 3970 MAJOR HOSPITAL 2451 INTELLIPLEX DR SHELBYVILLE IN 46176 SHELBY (317) 392-3211 Acute Care Hospitals Government - Local TRUE 39.5600170 -85.7839700 0   145 18 18145 26900 Indianapolis-Carmel-Muncie, IN Outlying Shelby County https://data.medicare.gov/resource/xubh-q36u/row-r4ki.27zg-ps3s 150097 659263 2019-05-30 2018-12-31 40 6         46               46
3391 3391 COMMUNITY HOSPITAL, LLC 3100 SOUTHWEST 89TH STREET OKLAHOMA CITY OK 73159 OKLAHOMA (405) 602-8100 Acute Care Hospitals Physician TRUE 35.3771130 -97.5704530 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-ftkm_6raj-yxui 370203 649480 2019-05-30 2018-12-31 42 3         45               45
2794 2794 HUTCHINSON HEALTH 1095 HIGHWAY 15 SOUTH HUTCHINSON MN 55350 MC LEOD (320) 234-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.8751050 -94.3755330 0   85 27 27085 26780 Minneapolis-St. Paul, MN-WI Central McLeod County https://data.medicare.gov/resource/xubh-q36u/row-ipi6_nv97~u6br 240187 649774 2019-05-30 2018-12-31 43 6         49               49
1600 1600 PRESBYTERIAN ESPANOLA HOSPITAL 1010 SPRUCE STREET ESPANOLA NM 87532 RIO ARRIBA (505) 753-1502 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.9971010 -106.0866830 0   39 35 35039 21580 Albuquerque-Santa Fe-Las Vegas, NM Central Rio Arriba County https://data.medicare.gov/resource/xubh-q36u/row-2ihe-5knz~yfsj 320011 651477 2019-05-30 2018-12-31 44 8         52               52
3331 3331 SSM HEALTH ST MARY'S HOSPITAL - JANESVILLE 3400 EAST RACINE STREET JANESVILLE WI 53546 ROCK (608) 373-8000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.6709820 -88.9760750 0   105 55 55105 27500 Madison-Janesville-Beloit, WI Central Rock County https://data.medicare.gov/resource/xubh-q36u/row-ded9.rse4~fbnh 520208 650625 2019-05-30 2018-12-31 44 6         50               50
2588 2588 AURORA MEDICAL CENTER BAY AREA 3003 UNIVERSITY DR MARINETTE WI 54143 MARINETTE (715) 735-4200 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.0709216 -87.6480055 1 ROOFTOP 75 55 55075 31940   Central Marinette County https://data.medicare.gov/resource/xubh-q36u/row-p6ir~8sny.ut2x 520113 650623 2019-05-30 2018-12-31 45 10         55               55
4688 4688 SCOTT & WHITE HOSPITAL BRENHAM 700 MEDICAL PARKWAY BRENHAM TX 77833 WASHINGTON (979) 836-6173 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.1450820 -96.3989370 0   477 48 48477 14780 Houston-The Woodlands, TX Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-bj3a~ezhw~phwu 450187 649137 2019-05-30 2018-12-31 45 5         50               50
1842 1842 MAYO CLINIC HEALTH SYSTEM - RED WING 701 HEWITT BOULEVARD, PO BOX 95 RED WING MN 55066 GOODHUE (651) 267-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.5602740 -92.5751970 0   49 27 27049 39860 Minneapolis-St. Paul, MN-WI Central Goodhue County https://data.medicare.gov/resource/xubh-q36u/row-98sr_epmf-n2q5 240018 649755 2019-05-30 2018-12-31 46 4         50               50
2495 2495 HOLY FAMILY MEMORIAL 2300 WESTERN AVE MANITOWOC WI 54221 MANITOWOC (920) 320-2011 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.0944100 -87.6768650 0   71 55 55071 31820   Central Manitowoc County https://data.medicare.gov/resource/xubh-q36u/row-3t2y-xqgp.yeuz 520107 650622 2019-05-30 2018-12-31 48 10         58               58

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