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

403 rows where hospital_ownership = "Government - Local"

✎ 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 - Local · 403 ✖
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
10 10 GARFIELD COUNTY HEALTH CENTER 332 LEAVITT AVE JORDAN MT 59337 GARFIELD (406) 557-2500 Critical Access Hospitals Government - Local TRUE 47.3185240 -106.9113280 0   33 30 30033         https://data.medicare.gov/resource/xubh-q36u/row-xbp8~mipq.32d8 271310 659309 2019-11-18 2019-06-30 4           4       24       28
13 13 NORTH VALLEY HOSPITAL 203 SOUTH WESTERN TONASKET WA 98855 OKANOGAN (509) 486-2151 Critical Access Hospitals Government - Local TRUE 48.7068190 -119.4395970 0   47 53 53047         https://data.medicare.gov/resource/xubh-q36u/row-dpfb.gqi2_r2fh 501321 648787 2019-05-29 2018-12-31 21           21               21
17 17 VAN DIEST MEDICAL CENTER 2350 HOSPITAL DRIVE WEBSTER CITY IA 50595 HAMILTON (515) 832-9400 Critical Access Hospitals Government - Local TRUE 42.4529630 -93.8134850 0   79 19 19079         https://data.medicare.gov/resource/xubh-q36u/row-89tb_yu6c_zwc4 161361 660984 2019-12-02 2019-06-30 25           25               25
18 18 HOUSTON COUNTY COMMUNITY HOSPITAL 5001 EAST MAIN STREET ERIN TN 37061 HOUSTON (931) 289-4211 Critical Access Hospitals Government - Local TRUE 36.3195160 -87.6891930 0   83 47 47083         https://data.medicare.gov/resource/xubh-q36u/row-dt3z.s9ya.age2 441322 639931 2018-12-03 2018-06-30 25           25               25
27 27 NEMAHA COUNTY HOSPITAL 2022 13TH ST AUBURN NE 68305 NEMAHA (402) 274-4366 Critical Access Hospitals Government - Local TRUE 40.3920330 -95.8530200 0   127 31 31127         https://data.medicare.gov/resource/xubh-q36u/row-jgty.gwke-kfnb 281324 654855 2019-09-24 2019-04-30 16           16               16
28 28 MORTON COUNTY HOSPITAL 445 N HILLTOP ELKHART KS 67950 MORTON (620) 697-2141 Acute Care Hospitals Government - Local TRUE 37.0019009 -101.9053025 1 ROOFTOP 129 20 20129         https://data.medicare.gov/resource/xubh-q36u/row-uv4u~7jpi~swm6 170166 651519 2019-07-09 2018-12-31 26           26               26
35 35 HAWARDEN REGIONAL HEALTHCARE 1111 11TH STREET HAWARDEN IA 51023 SIOUX (712) 551-3100 Critical Access Hospitals Government - Local TRUE 42.9980080 -96.4794270 0   167 19 19167         https://data.medicare.gov/resource/xubh-q36u/row-i52u~xknc.njpg 161311 660957 2019-12-02 2019-06-30 25           25               25
36 36 THAYER COUNTY HEALTH SERVICES 120 PARK AVE HEBRON NE 68370 THAYER (402) 768-6041 Critical Access Hospitals Government - Local TRUE 40.1601230 -97.5932670 0   169 31 31169         https://data.medicare.gov/resource/xubh-q36u/row-b26e~mfmy~67qg 281304 660643 2019-11-27 2019-06-30 19           19               19
69 69 ADAIR COUNTY MEMORIAL HOSPITAL 609 SE KENT GREENFIELD IA 50849 ADAIR (641) 743-2123 Critical Access Hospitals Government - Local TRUE 41.3031030 -94.4519270 0   1 19 19001         https://data.medicare.gov/resource/xubh-q36u/row-3dt7_nstz~yhhy 161310 660956 2019-12-02 2019-06-30 25           25               25
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
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
121 121 ABBEVILLE AREA MEDICAL CENTER 420 THOMSON CIRCLE ABBEVILLE SC 29620 ABBEVILLE (864) 366-5011 Critical Access Hospitals Government - Local TRUE 34.1561250 -82.3801740 0   1 45 45001 24940 Greenville-Spartanburg-Anderson, SC Outlying Abbeville County https://data.medicare.gov/resource/xubh-q36u/row-v8xu.2huz_ubxe 421301 645182 2019-02-25 2018-09-30 19 6         25               25
145 145 JOHN DEMPSEY HOSPITAL 263 FARMINGTON AVE FARMINGTON CT 6032 HARTFORD (860) 679-1145 Acute Care Hospitals Government - Local TRUE 41.7350900 -72.7958200 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-dhzf~ccfg~faa5 70036 661473 2019-11-27 2019-06-30 118 20         138 18             156
147 147 BIG HORN HOSPITAL 17 N MILES HARDIN MT 59034 BIG HORN (406) 665-2310 Critical Access Hospitals Government - Local TRUE 45.7288560 -107.6170100 0   3 30 30003         https://data.medicare.gov/resource/xubh-q36u/row-2cgz.f5s8-gu8f 271338 652087 2018-11-27 2018-06-30 25           25               25
176 176 CARY MEDICAL CENTER 163 VAN BUREN RD, SUITE 1 CARIBOU ME 4736 AROOSTOOK (207) 498-3111 Acute Care Hospitals Government - Local TRUE 46.8782370 -68.0096390 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-3dpx.x267~9y3n 200031 650153 2019-05-31 2018-12-31 43 6         49               49
192 192 UNIVERSITY MEDICAL CENTER 1800 W CHARLESTON BLVD LAS VEGAS NV 89102 CLARK (702) 383-2000 Acute Care Hospitals Government - Local TRUE 36.1589410 -115.1659450 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-crh9_6nqs_53ud 290007 662546 2019-11-29 2019-06-30 358 20 24 16 16 14 498               498
212 212 BERGEN NEW BRIDGE MEDICAL CENTER 230 EAST RIDGEWOOD AVE PARAMUS NJ 7652 BERGEN (201) 967-4000 Acute Care Hospitals Government - Local TRUE 40.9586020 -74.0621510 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-uajf_w5ak.e5wh 310058 651020 2019-06-03 2018-12-31 118 9         127 319     574       1020
273 273 COLUMBUS REGIONAL HOSPITAL 2400 E 17TH ST COLUMBUS IN 47201 BARTHOLOMEW (812) 379-4441 Acute Care Hospitals Government - Local TRUE 39.2158720 -85.8968540 0   5 18 18005 18020 Indianapolis-Carmel-Muncie, IN Central Bartholomew County https://data.medicare.gov/resource/xubh-q36u/row-u4i5.cqhh_8kd8 150112 649209 2019-05-31 2018-12-31 194 17         211   18           229
274 274 VETERANS MEMORIAL HOSPITAL 40 1ST STREET SE WAUKON IA 52172 ALLAMAKEE (563) 568-3411 Critical Access Hospitals Government - Local TRUE 43.2680920 -91.4744460 0   5 19 19005         https://data.medicare.gov/resource/xubh-q36u/row-kmrq-g36y.pe5i 161318 660959 2019-12-02 2019-06-30 25           25               25
292 292 FIELD HEALTH SYSTEM 178 HIGHWAY 24 CENTREVILLE MS 39631 WILKINSON (601) 890-0500 Critical Access Hospitals Government - Local TRUE 31.0820299 -91.0587631 1 ROOFTOP 5 28 28005 32620   Outlying Amite County https://data.medicare.gov/resource/xubh-q36u/row-d7tp~8xnm~uwen 251309 646102 2019-02-28 2018-09-30 16           16               16
305 305 LINCOLN MEDICAL & MENTAL HEALTH CENTER 234 EAST 149TH STREET BRONX NY 10451 BRONX (718) 579-5000 Acute Care Hospitals Government - Local TRUE 40.8176810 -73.9240720 0   5 36 36005 35620 New York-Newark, NY-NJ-CT-PA Central Bronx County https://data.medicare.gov/resource/xubh-q36u/row-b6it.a7xa.ygmk 330080 661747 2019-12-03 2019-06-30 229 38       20 287 60             347
306 306 JACOBI MEDICAL CENTER 1400 PELHAM PARKWAY SOUTH BRONX NY 10461 BRONX (718) 918-5000 Acute Care Hospitals Government - Local TRUE 40.8574550 -73.8472100 0   5 36 36005 35620 New York-Newark, NY-NJ-CT-PA Central Bronx County https://data.medicare.gov/resource/xubh-q36u/row-ah92_ybye.fwuw 330127 661748 2019-12-03 2019-06-30 249 32 12 8   25 326 89 24           439
308 308 NORTH CENTRAL BRONX HOSPITAL 3424 KOSSUTH AVENUE & 210TH STREET BRONX NY 10467 BRONX (212) 519-5000 Acute Care Hospitals Government - Local TRUE 40.8804709 -73.8811305 1 RANGE_INTERPOLATED 5 36 36005 35620 New York-Newark, NY-NJ-CT-PA Central Bronx County https://data.medicare.gov/resource/xubh-q36u/row-kzjb-7xtm_jntx 330385 661753 2019-12-03 2019-06-30 98 20       12 130 70             200
317 317 ALLENDALE COUNTY HOSPITAL 1787 ALLENDALE FAIRFAX RD FAIRFAX SC 29827 ALLENDALE (803) 632-3311 Critical Access Hospitals Government - Local TRUE 32.9662250 -81.2477270 0   5 45 45005         https://data.medicare.gov/resource/xubh-q36u/row-bjdu~dq8g.u82d 421300 645444 2019-03-04 2018-09-30 25           25       44       69
329 329 BOONE MEMORIAL HOSPITAL 701 MADISON AVENUE MADISON WV 25130 BOONE (304) 369-1230 Critical Access Hospitals Government - Local TRUE 38.0486360 -81.8065320 0   5 54 54005 16620 Charleston-Huntington-Ashland, WV-OH-KY Outlying Boone County https://data.medicare.gov/resource/xubh-q36u/row-r4j3~ibqd.28ff 511313 661267 2019-12-02 2019-06-30 25           25               25
335 335 CIBOLA GENERAL HOSPITAL 1016 E ROOSEVELT AVENUE GRANTS NM 87020 CIBOLA (505) 287-5300 Critical Access Hospitals Government - Local TRUE 35.1611680 -107.8265740 0   6 35 35006 24380 Albuquerque-Santa Fe-Las Vegas, NM Central Cibola County https://data.medicare.gov/resource/xubh-q36u/row-ap2g_auck_pm67 321308 662228 2019-12-18 2019-06-30 21 4         25               25
352 352 BEAR LAKE MEMORIAL HOSPITAL 164 SOUTH FIFTH STREET MONTPELIER ID 83254 BEAR LAKE (208) 847-1630 Critical Access Hospitals Government - Local TRUE 42.3162420 -111.3008470 0   7 16 16007         https://data.medicare.gov/resource/xubh-q36u/row-mggi-9epd.588z 131316 647888 2019-05-16 2018-12-31 21           21       36   32   89
401 401 MEMORIAL HOSPITAL OF CARBON COUNTY 2221 WEST ELM STREET RAWLINS WY 82301 CARBON (307) 324-2221 Critical Access Hospitals Government - Local TRUE 41.7867630 -107.2606730 0   7 56 56007         https://data.medicare.gov/resource/xubh-q36u/row-5zmg.wks7_27ym 531316 656814 2019-11-08 2019-06-30 19 6         25               25
428 428 BENEWAH COMMUNITY HOSPITAL 229 SOUTH 7TH STREET ST MARIES ID 83861 BENEWAH (208) 245-5551 Critical Access Hospitals Government - Local TRUE 47.3146130 -116.5666780 0   9 16 16009         https://data.medicare.gov/resource/xubh-q36u/row-3wfv~5stn~5t7d 131317 652074 2019-05-24 2018-12-31 19           19               19
430 430 AUDUBON COUNTY MEMORIAL HOSPITAL 515 PACIFIC AVENUE AUDUBON IA 50025 AUDUBON (712) 563-2611 Critical Access Hospitals Government - Local TRUE 41.7154230 -94.9370440 0   9 19 19009         https://data.medicare.gov/resource/xubh-q36u/row-7tp4_zwyw_2d9j 161330 659788 2019-11-25 2019-06-30 25           25               25
464 464 ST MICHAEL'S HOSPITAL - CAH 410 W 16TH AVE TYNDALL SD 57066 BON HOMME (605) 589-2100 Critical Access Hospitals Government - Local TRUE 42.9912530 -97.8678960 0   9 46 46009         https://data.medicare.gov/resource/xubh-q36u/row-sqz9_y3kz.mu4d 431327 659612 2019-11-25 2019-06-30 25           25               25
465 465 LANDMANN-JUNGMAN MEMORIAL HOSPITAL - CAH 600 BILLARS ST SCOTLAND SD 57059 BON HOMME (605) 583-2226 Critical Access Hospitals Government - Local TRUE 43.1494940 -97.7281040 0   9 46 46009         https://data.medicare.gov/resource/xubh-q36u/row-h5nm-t8q8-ubs6 431317 662141 2019-11-26 2019-06-30 25           25               25
466 466 BLOUNT MEMORIAL HOSPITAL 907 E LAMAR ALEXANDER PARKWAY MARYVILLE TN 37804 BLOUNT (865) 983-7211 Acute Care Hospitals Government - Local TRUE 35.7549750 -83.9586020 0   9 47 47009 28940 Knoxville-Morristown-Sevierville, TN Central Blount County https://data.medicare.gov/resource/xubh-q36u/row-q2u9.xgek.22ux 440011 659450 2019-11-25 2019-06-30 177 8 8       193 10     76       279
468 468 OLYMPIC MEDICAL CENTER 939 CAROLINE ST PORT ANGELES WA 98362 CLALLAM (360) 417-7000 Acute Care Hospitals Government - Local TRUE 48.1146350 -123.4140840 0   9 53 53009 38820   Central Clallam County https://data.medicare.gov/resource/xubh-q36u/row-pwiq.sab8.genf 500072 652469 2019-07-23 2018-12-31 59 19         78               78
469 469 WEIRTON MEDICAL CENTER 601 COLLIERS WAY WEIRTON WV 26062 HANCOCK (304) 797-6000 Acute Care Hospitals Government - Local TRUE 40.3937260 -80.5297390 0   9 54 54009 48260 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Brooke County https://data.medicare.gov/resource/xubh-q36u/row-kane-jbhj.6jim 510023 661436 2019-12-02 2019-06-30 117 10         127   7   33       167
474 474 MEMORIAL HOSPITAL OF CONVERSE COUNTY 111 SOUTH 5TH STREET DOUGLAS WY 82633 CONVERSE (307) 358-2122 Critical Access Hospitals Government - Local TRUE 42.7588050 -105.3812790 0   9 56 56009         https://data.medicare.gov/resource/xubh-q36u/row-zei4~mbih_rgkv 531302 662095 2019-12-03 2019-06-30 25           25               25
477 477 GUAM MEMORIAL HOSPITAL AUTHORITY 85O GOV CARLOS G CAMACHO ROAD TAMUNING GU 96913 GUAM (671) 647-2552 Acute Care Hospitals Government - Local TRUE 13.5008229 144.7755910 1 GEOMETRIC_CENTER 10 66 66010         https://data.medicare.gov/resource/xubh-q36u/row-4hjs.vy3n_hawy 650001 644079 2019-02-28 2018-09-30 147 14         161       40       201
502 502 PERRY MEMORIAL HOSPITAL 530 PARK AVENUE EAST PRINCETON IL 61356 BUREAU (815) 875-2811 Critical Access Hospitals Government - Local TRUE 41.3680100 -89.4559580 0   11 17 17011 36860 Chicago-Naperville, IL-IN-WI Central Bureau County https://data.medicare.gov/resource/xubh-q36u/row-93jr-f3xy_p6h2 141337 654839 2019-09-30 2019-04-30 22 3         25               25
503 503 WITHAM HEALTH SERVICES 2605 N LEBANON ST LEBANON IN 46052 BOONE (765) 485-8000 Acute Care Hospitals Government - Local TRUE 40.0769090 -86.4752090 0   11 18 18011 26900 Indianapolis-Carmel-Muncie, IN Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-gfq5-5jsq-rtmb 150104 649208 2019-05-31 2018-12-31 60 8         68 10     18       96
510 510 ORTONVILLE AREA HEALTH SERVICES 450 EASTVOLD AVE ORTONVILLE MN 56278 BIG STONE (320) 839-2505 Critical Access Hospitals Government - Local TRUE 45.3147690 -96.4465630 0   11 27 27011         https://data.medicare.gov/resource/xubh-q36u/row-jt8y~id78.iwpi 241342 645770 2019-03-28 2018-09-30 25           25       51       76
513 513 COX BARTON COUNTY HOSPITAL 29 NW 1ST LANE LAMAR MO 64759 BARTON (417) 682-6081 Critical Access Hospitals Government - Local TRUE 37.5052820 -94.2994820 0   11 29 29011         https://data.medicare.gov/resource/xubh-q36u/row-8cv5-t4zj_7sig 261325 645577 2019-03-04 2018-09-30 21 4         25               25
515 515 BOONE COUNTY HEALTH CENTER P O BOX 151, 723 WEST FAIRVIEW ST ALBION NE 68620 BOONE (402) 395-2191 Critical Access Hospitals Government - Local TRUE 41.6921113 -98.0002224 1 ROOFTOP 11 31 31011         https://data.medicare.gov/resource/xubh-q36u/row-3j5p_6aw6-77k2 281334 645125 2019-02-28 2018-09-30 25           25               25
534 534 BROOKINGS HEALTH SYSTEM 300 22ND AVE BROOKINGS SD 57006 BROOKINGS (605) 696-9000 Acute Care Hospitals Government - Local TRUE 44.3077510 -96.7681990 0   11 46 46011 15100   Central Brookings County https://data.medicare.gov/resource/xubh-q36u/row-tq89~5fbc_ivbf 430008 650780 2019-06-26 2018-12-31 49           49       79       128
564 564 VALLEYWISE HEALTH MEDICAL CENTER 2601 EAST ROOSEVELT STREET PHOENIX AZ 85008 MARICOPA (602) 344-5011 Acute Care Hospitals Government - Local TRUE 33.4585250 -112.0264300 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-c5qr_etcr-7dch 30022 661279 2018-12-03 2018-06-30 211 20   19 13   323 241             564
587 587 CONTRA COSTA REGIONAL MEDICAL CENTER 2500 ALHAMBRA AVENUE MARTINEZ CA 94553 CONTRA COSTA (925) 370-5000 Acute Care Hospitals Government - Local TRUE 38.0064670 -122.1308910 0   13 6 6013 41860 San Jose-San Francisco-Oakland, CA Outlying Contra Costa County https://data.medicare.gov/resource/xubh-q36u/row-iuri_7t24.rw23 50276 660491 2019-12-02 2019-06-30 110 8       6 124 23             147
616 616 BARAGA COUNTY MEMORIAL HOSPITAL 18341 US HIGHWAY 41 L' ANSE MI 49946 BARAGA (906) 524-3300 Critical Access Hospitals Government - Local TRUE 46.7344600 -88.4280420 0   13 26 26013         https://data.medicare.gov/resource/xubh-q36u/row-kzgx-j54h-paej 231307 645568 2019-03-05 2018-09-30 24           24               24
619 619 BATES COUNTY MEMORIAL HOSPITAL 615 W NURSERY ST BUTLER MO 64730 BATES (660) 200-7000 Acute Care Hospitals Government - Local TRUE 38.2496110 -94.3433910 0   13 29 29013 28140 Kansas City-Overland Park-Kansas City, MO-KS Outlying Bates County https://data.medicare.gov/resource/xubh-q36u/row-y4pe~pb6c-52i8 260034 648060 2019-05-16 2018-12-31 44           44               44
622 622 BOX BUTTE GENERAL HOSPITAL P O BOX 810, 2101 BOX BUTTE AVE ALLIANCE NE 69301 BOX BUTTE (308) 762-6660 Critical Access Hospitals Government - Local TRUE 42.0984344 -102.8703880 1 ROOFTOP 13 31 31013         https://data.medicare.gov/resource/xubh-q36u/row-gsu6_furw.wta3 281360 661047 2019-12-02 2019-06-30 25           25               25
649 649 BEAUFORT COUNTY MEMORIAL HOSPITAL 955 RIBAUT RD BEAUFORT SC 29902 BEAUFORT (843) 522-5200 Acute Care Hospitals Government - Local TRUE 32.4172440 -80.6885460 0   13 45 45013 25940   Central Beaufort County https://data.medicare.gov/resource/xubh-q36u/row-simj~c9x8.yqtx 420067 644559 2019-02-25 2018-09-30 155 12         167 14 14           195
666 666 NORTHEAST ALABAMA REGIONAL MEDICAL CENTER 400 EAST 10TH STREET ANNISTON AL 36207 CALHOUN (256) 235-5121 Acute Care Hospitals Government - Local TRUE 33.6571230 -85.8233530 0   15 1 1015 11500   Central Calhoun County https://data.medicare.gov/resource/xubh-q36u/row-ima9~p9t8~qh92 10078 644086 2019-02-28 2018-09-30 232 18         250 20             270
681 681 BOONE COUNTY HOSPITAL 1015 UNION STREET BOONE IA 50036 BOONE (515) 432-3140 Critical Access Hospitals Government - Local TRUE 42.0555830 -93.8770370 0   15 19 19015 14340 Des Moines-Ames-West Des Moines, IA Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-6zpe~cgwm_xs5p 161372 660987 2019-12-02 2019-06-30 25           25               25
691 691 SLEEPY EYE MUNICIPAL HOSPITAL 400 FOURTH AVENUE NORTHWEST SLEEPY EYE MN 56085 BROWN (507) 794-3571 Critical Access Hospitals Government - Local TRUE 44.2993190 -94.7273150 0   15 27 27015 35580 Mankato-New Ulm-North Mankato, MN Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-td5y_avnx_gs7p 241327 651011 2019-06-03 2018-12-31 16           16               16
731 731 DORMINY MEDICAL CENTER 200 PERRY HOUSE ROAD, BOX 1447 FITZGERALD GA 31750 BEN HILL (229) 424-7100 Acute Care Hospitals Government - Local TRUE 31.6979180 -83.2609750 0   17 13 13017 22340   Central Ben Hill County https://data.medicare.gov/resource/xubh-q36u/row-x5tq.yugi-ym8v 110073 658241 2019-01-02 2018-07-31 43 5         48 12             60
733 733 MEMORIAL HOSPITAL 1101 MICHIGAN AVE LOGANSPORT IN 46947 CASS (574) 753-7541 Acute Care Hospitals Government - Local TRUE 40.7624650 -86.3612460 0   17 18 18017 30900   Central Cass County https://data.medicare.gov/resource/xubh-q36u/row-wqwj~vb9b_viec 150072 646907 2019-04-05 2018-12-31 39 5         44               44
735 735 WAVERLY HEALTH CENTER 312 9TH STREET SW WAVERLY IA 50677 BREMER (319) 352-4120 Critical Access Hospitals Government - Local TRUE 42.7236680 -92.4818020 0   17 19 19017 47940   Outlying Bremer County https://data.medicare.gov/resource/xubh-q36u/row-cy2n.fbzb~m6ce 161339 661181 2019-11-29 2019-06-30 21           21               21
752 752 CAMBRIDGE HEALTH ALLIANCE 1493 CAMBRIDGE STREET CAMBRIDGE MA 2138 MIDDLESEX (617) 665-2300 Acute Care Hospitals Government - Local TRUE 42.3741860 -71.1044550 0   17 25 25017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-gyrk~893u_u5y7 220011 662215 2019-12-02 2019-06-30 182 18         200 62             262
762 762 BROWN COUNTY HOSPITAL 945 EAST ZERO ST AINSWORTH NE 69210 BROWN (402) 387-2800 Critical Access Hospitals Government - Local TRUE 42.5449340 -99.8500450 0   17 31 31017         https://data.medicare.gov/resource/xubh-q36u/row-7ya9_7bjz.6vjk 281325 659704 2019-11-18 2019-06-30 23           23               23
793 793 GARFIELD MEMORIAL HOSPITAL 200 NORTH 400 EAST PANGUITCH UT 84759 GARFIELD (435) 676-8811 Critical Access Hospitals Government - Local TRUE 37.8287720 -112.4354760 0   17 49 49017         https://data.medicare.gov/resource/xubh-q36u/row-76zy~3pmz.9dc6 461333 658918 2019-11-13 2018-12-31 15           15           21   36
798 798 HOT SPRINGS COUNTY MEMORIAL HOSPITAL 150 EAST ARAPAHOE THERMOPOLIS WY 82443 HOT SPRINGS (307) 864-3121 Critical Access Hospitals Government - Local TRUE 43.6474320 -108.1995900 0   17 56 56017         https://data.medicare.gov/resource/xubh-q36u/row-ktb5~jtkf~b2ae 531304 640300 2018-11-30 2018-06-30 25           25               25
836 836 PAUL OLIVER MEMORIAL HOSPITAL 224 PARK AVENUE FRANKFORT MI 49635 BENZIE (231) 352-2200 Critical Access Hospitals Government - Local TRUE 44.6373760 -86.2429130 0   19 26 26019 45900   Outlying Benzie County https://data.medicare.gov/resource/xubh-q36u/row-cypk~xgkd.zsnp 231300 660598 2019-11-26 2019-06-30 8           8       36       44
838 838 CHOCTAW REGIONAL MEDICAL CENTER 8613 MS HWY 12 ACKERMAN MS 39735 CHOCTAW (662) 285-4400 Critical Access Hospitals Government - Local TRUE 33.3184650 -89.1823040 0   19 28 28019         https://data.medicare.gov/resource/xubh-q36u/row-9nt3~77et_z9mg 251334 643914 2019-03-01 2018-09-30 15           15         73     88
847 847 GUADALUPE COUNTY HOSPITAL 117 CAMINO DE VIDA, SUITE 100 SANTA ROSA NM 88435 GUADALUPE (575) 472-3417 Acute Care Hospitals Government - Local TRUE 34.9295040 -104.6942240 0   19 35 35019         https://data.medicare.gov/resource/xubh-q36u/row-es4t_p7gk_ag72 320067 661934 2019-12-17 2019-06-30 10           10               10
882 882 PIGGOTT COMMUNITY HOSPITAL 216 EAST MAIN STREET PIGGOTT AR 72454 CLAY (870) 598-3881 Critical Access Hospitals Government - Local TRUE 36.3820190 -90.1884430 0   21 5 5021         https://data.medicare.gov/resource/xubh-q36u/row-73yu_ywme-uu8m 41330 649163 2019-06-03 2018-12-31 25           25               25
894 894 BUENA VISTA REGIONAL MEDICAL CENTER 1525 WEST 5TH STREET STORM LAKE IA 50588 BUENA VISTA (712) 732-4030 Critical Access Hospitals Government - Local TRUE 42.6443560 -95.2220080 0   21 19 19021 44740   Central Buena Vista County https://data.medicare.gov/resource/xubh-q36u/row-prcs~bkcs~7h4s 161375 660220 2019-11-26 2019-06-30 20   5       25 10             35
896 896 PREMIER SURGICAL INSTITUTE 1619 K 66 GALENA KS 66739 CHEROKEE (620) 783-1732 Acute Care Hospitals Government - Local FALSE 37.0766240 -94.6218020 0   21 20 20021         https://data.medicare.gov/resource/xubh-q36u/row-rere_4r4a~kxmn 170203 648913 2019-05-28 2018-12-31 36           36               36
910 910 CLAIBORNE COUNTY HOSPITAL 123 MCCOMB AVENUE PORT GIBSON MS 39150 CLAIBORNE (601) 437-5141 Critical Access Hospitals Government - Local FALSE 31.9459920 -90.9853950 0   21 28 28021 46980 Jackson-Vicksburg-Brookhaven, MS Outlying Claiborne County https://data.medicare.gov/resource/xubh-q36u/row-wz4r-hvew~et2i 251320 650593 2019-05-31 2018-12-31 22           22 10             32
923 923 NORTHEASTERN HEALTH SYSTEM 1400 EAST DOWNING STREET TAHLEQUAH OK 74465 CHEROKEE (918) 456-0641 Acute Care Hospitals Government - Local TRUE 35.9153260 -94.9505580 0   21 40 40021 45140 Tulsa-Muskogee-Bartlesville, OK Central Cherokee County https://data.medicare.gov/resource/xubh-q36u/row-y8w6~8rs4_b8fq 370089 660430 2019-11-27 2019-06-30 40 14 16       70 10 10           90
958 958 PROMEDICA COLDWATER REGIONAL HOSPITAL 274 E CHICAGO ST COLDWATER MI 49036 BRANCH (517) 279-5400 Acute Care Hospitals Government - Local TRUE 41.9389690 -84.9905850 0   23 26 26023 17740   Central Branch County https://data.medicare.gov/resource/xubh-q36u/row-c7fm~x3c9_q2bd 230022 649113 2019-05-30 2018-12-31 77 10         87               87
959 959 CHIPPEWA COUNTY HOSPITAL 824 NORTH 11TH STREET MONTEVIDEO MN 56265 CHIPPEWA (320) 269-8877 Critical Access Hospitals Government - Local TRUE 44.9539890 -95.7135860 0   23 27 27023         https://data.medicare.gov/resource/xubh-q36u/row-jiz7.bbr2-urg8 241325 650591 2019-06-11 2018-12-31 25           25               25
964 964 BUTLER COUNTY HEALTH CARE CENTER 372 SOUTH 9TH ST DAVID CITY NE 68632 BUTLER (402) 367-1200 Critical Access Hospitals Government - Local TRUE 41.2464710 -97.1230380 0   23 31 31023         https://data.medicare.gov/resource/xubh-q36u/row-u7xr~dyr4.b4xb 281332 661041 2019-12-02 2019-06-30 20           20               20
994 994 EL CENTRO REGIONAL MEDICAL CENTER 1415 ROSS AVENUE EL CENTRO CA 92243 IMPERIAL (760) 339-7100 Acute Care Hospitals Government - Local TRUE 32.7814980 -115.5686200 0   25 6 6025 20940   Central Imperial County https://data.medicare.gov/resource/xubh-q36u/row-35st~i7ay-x3eh 50045 660164 2019-12-02 2019-06-30 141 20         161               161
996 996 CLAY COUNTY HOSPITAL 911 STACY BURK DRIVE FLORA IL 62839 CLAY (618) 662-2131 Critical Access Hospitals Government - Local TRUE 38.6809170 -88.4703370 0   25 17 17025         https://data.medicare.gov/resource/xubh-q36u/row-waac_79mj~znty 141351 653013 2019-08-02 2019-02-28 20           20               20
1039 1039 CLAIBORNE MEDICAL CENTER 1850 OLD KNOXVILLE HIGHWAY TAZEWELL TN 37879 CLAIBORNE (423) 626-4211 Acute Care Hospitals Government - Local TRUE 36.4533410 -83.5719720 0   25 47 47025         https://data.medicare.gov/resource/xubh-q36u/row-vk5j.mjgd~i76d 440057 658958 2019-11-18 2019-06-30 28 5         33       95       128
1054 1054 WYOMING MEDICAL CENTER 1233 EAST 2ND ST CASPER WY 82601 NATRONA (307) 577-7201 Acute Care Hospitals Government - Local TRUE 42.8487180 -106.3087530 0   25 56 56025 16220   Central Natrona County https://data.medicare.gov/resource/xubh-q36u/row-sk2z.s7zk-vge8 530012 662631 2019-11-27 2019-06-30 198 14         212               212
1060 1060 MAGNOLIA HOSPITAL 101 HOSPITAL DRIVE MAGNOLIA AR 71754 COLUMBIA (870) 235-3000 Acute Care Hospitals Government - Local TRUE 33.2751230 -93.2400710 0   27 5 5027 31620   Central Columbia County https://data.medicare.gov/resource/xubh-q36u/row-ed5b-6fgx_6hyv 40067 644209 2019-03-01 2018-09-30 24 6         30               30
1069 1069 DAVIESS COMMUNITY HOSPITAL 1314 E WALNUT ST WASHINGTON IN 47501 DAVIESS (812) 254-2760 Acute Care Hospitals Government - Local TRUE 38.6586950 -87.1603190 0   27 18 18027 47780   Central Daviess County https://data.medicare.gov/resource/xubh-q36u/row-khjv_h54z-usqa 150061 649895 2019-06-03 2018-12-31 37 5         42 20 12           74
1072 1072 CLAY COUNTY MEDICAL CENTER 617 LIBERTY CLAY CENTER KS 67432 CLAY (785) 632-2144 Critical Access Hospitals Government - Local TRUE 39.3916810 -97.1241960 0   27 20 20027         https://data.medicare.gov/resource/xubh-q36u/row-5isq.mc8m-iybh 171371 650581 2019-06-03 2018-12-31 17           17               17
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
1096 1096 CLINTON MEMORIAL HOSPITAL 610 WEST MAIN STREET WILMINGTON OH 45177 CLINTON (937) 382-6611 Acute Care Hospitals Government - Local TRUE 39.4455420 -83.8394060 0   27 39 39027 48940 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Clinton County https://data.medicare.gov/resource/xubh-q36u/row-cuks-2rvh-qwpd 360175 648304 2019-05-21 2018-12-31 69 6         75               75
1133 1133 DELTA COUNTY MEMORIAL HOSPITAL 1501 E 3RD ST DELTA CO 81416 DELTA (970) 874-7681 Acute Care Hospitals Government - Local TRUE 38.7431660 -108.0475150 0   29 8 8029         https://data.medicare.gov/resource/xubh-q36u/row-wsed.7ysa~nwhq 60071 649875 2019-05-31 2018-12-31 43 6         49               49
1134 1134 CARIBOU MEMORIAL HOSPITAL 300 SOUTH 3RD WEST SODA SPRINGS ID 83276 CARIBOU (208) 547-3341 Critical Access Hospitals Government - Local TRUE 42.6522350 -111.6133540 0   29 16 16029         https://data.medicare.gov/resource/xubh-q36u/row-k69a-4kn6-dfne 131309 644028 2019-02-28 2018-09-30 25           25       30       55
1136 1136 HIGHPOINT HEALTH 600 WILSON CREEK RD LAWRENCEBURG IN 47025 DEARBORN (812) 537-1010 Acute Care Hospitals Government - Local TRUE 39.1129220 -84.8839510 0   29 18 18029 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Outlying Dearborn County https://data.medicare.gov/resource/xubh-q36u/row-ngjg.xy9w~6uaw 150086 649567 2019-06-03 2018-12-31 78 8         86               86
1137 1137 CASS COUNTY MEMORIAL HOSPITAL 1501 EAST TENTH STREET ATLANTIC IA 50022 CASS (712) 243-3250 Critical Access Hospitals Government - Local TRUE 41.4017120 -94.9926080 0   29 19 19029         https://data.medicare.gov/resource/xubh-q36u/row-6rhm-rv5z-pr85 161376 656671 2019-11-05 2019-06-30 21 4         25 4             29
1144 1144 COPIAH COUNTY MEDICAL CENTER 21790 HIGHWAY 28 HAZLEHURST MS 39083 COPIAH (601) 574-7000 Critical Access Hospitals Government - Local TRUE 31.8336830 -90.4732190 0   29 28 28029 27140 Jackson-Vicksburg-Brookhaven, MS Outlying Copiah County https://data.medicare.gov/resource/xubh-q36u/row-x52z.kcws_cv45 251327 652305 2019-08-01 2018-12-31 25           25               25
1149 1149 CHASE COUNTY COMMUNITY HOSPITAL P O BOX 819, 600 W 12TH ST IMPERIAL NE 69033 CHASE (308) 882-7111 Critical Access Hospitals Government - Local TRUE 40.5163553 -101.6419049 1 ROOFTOP 29 31 31029         https://data.medicare.gov/resource/xubh-q36u/row-nwms~eext-vthe 281351 655132 2019-10-04 2019-06-30 20           20               20
1165 1165 ASANTE ASHLAND COMMUNITY HOSPITAL 280 MAPLE STREET ASHLAND OR 97520 JACKSON (541) 201-4017 Acute Care Hospitals Government - Local TRUE 42.2064450 -122.7251290 0   29 41 41029 32780 Medford-Grants Pass, OR Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-xsnr-xsme.wejp 380005 644057 2019-02-27 2018-09-30 34 4         38               38
1196 1196 ROY LESTER SCHNEIDER HOSPITAL,THE 9048 SUGAR ESTATE ST THOMAS VI 801 SAINT THOMAS ISLAND (809) 776-8311 Acute Care Hospitals Government - Local TRUE 18.3403280 -64.9146707 1 ROOFTOP 30 78 78030         https://data.medicare.gov/resource/xubh-q36u/row-smqm-6qpj_ky9s 480001 644382 2019-03-01 2018-09-30 99 8         107               107
1220 1220 JOHN H STROGER JR HOSPITAL 1901 W HARRISON ST CHICAGO IL 60612 COOK (312) 864-6000 Acute Care Hospitals Government - Local TRUE 41.8740410 -87.6743110 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-2ss5~bvsp.bpf4 140124 659251 2019-11-07 2018-11-30 310 32   8 14   448               448
1225 1225 PROVIDENT HOSPITAL OF CHICAGO 500 E 51ST ST CHICAGO IL 60615 COOK (312) 572-2000 Acute Care Hospitals Government - Local TRUE 41.8021580 -87.6141930 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-knkg_mg7f-2emf 140300 659411 2019-11-05 2018-11-30 25           25               25
1265 1265 DECATUR COUNTY MEMORIAL HOSPITAL 720 N LINCOLN ST GREENSBURG IN 47240 DECATUR (812) 663-4331 Critical Access Hospitals Government - Local TRUE 39.3441160 -85.4794040 0   31 18 18031 24700 Indianapolis-Carmel-Muncie, IN Central Decatur County https://data.medicare.gov/resource/xubh-q36u/row-hqis.arxf_g2ap 151332 649101 2019-05-31 2018-12-31 25           25               25
1276 1276 COVINGTON COUNTY HOSPITAL CAH 701 SOUTH HOLLY AVENUE COLLINS MS 39428 COVINGTON (601) 765-6711 Critical Access Hospitals Government - Local TRUE 31.6382360 -89.5544240 0   31 28 28031         https://data.medicare.gov/resource/xubh-q36u/row-6qgj_6i6m-qfrk 251325 643804 2019-02-27 2018-09-30 25           25               25
1281 1281 CHERRY COUNTY HOSPITAL P O BOX 410, 510 NORTH GREEN ST VALENTINE NE 69201 CHERRY (402) 376-2525 Critical Access Hospitals Government - Local TRUE 42.8790786 -100.5384010 1 ROOFTOP 31 31 31031         https://data.medicare.gov/resource/xubh-q36u/row-fpwc_rzae.e38t 281344 652757 2019-07-23 2019-03-31 25           25               25
1308 1308 PLATTE COUNTY MEMORIAL HOSPITAL 201 14TH STREET WHEATLAND WY 82201 PLATTE (307) 322-3636 Critical Access Hospitals Government - Local TRUE 42.0498100 -104.9602210 0   31 56 56031         https://data.medicare.gov/resource/xubh-q36u/row-xwas~nr7a-7yiz 531305 649858 2019-06-03 2018-12-31 25           25               25
1322 1322 COMANCHE COUNTY HOSPITAL 2ND & FRISCO STREET COLDWATER KS 67029 COMANCHE (620) 582-2144 Critical Access Hospitals Government - Local TRUE 37.2679460 -99.3321152 1 GEOMETRIC_CENTER 33 20 20033         https://data.medicare.gov/resource/xubh-q36u/row-uexi-7hwn_3fpb 171312 648915 2019-05-29 2018-12-31 12           12               12
1338 1338 WINDOM AREA HEALTH 2150 HOSPITAL DRIVE, PO BOX 339 WINDOM MN 56101 COTTONWOOD (507) 831-2400 Critical Access Hospitals Government - Local TRUE 43.8785870 -95.1136590 0   33 27 27033         https://data.medicare.gov/resource/xubh-q36u/row-9bd7-ibcv.unjw 241332 654451 2019-09-27 2019-04-30 18           18               18
1366 1366 HARBORVIEW MEDICAL CENTER 325 9TH AVENUE SEATTLE WA 98104 KING (206) 731-3000 Acute Care Hospitals Government - Local TRUE 47.6040840 -122.3233720 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-fu42.79v4.ss25 500064 659621 2019-11-25 2019-06-30 232 89         321 68 24           413
1376 1376 SHERIDAN MEMORIAL HOSPITAL 1401 W 5TH ST SHERIDAN WY 82801 SHERIDAN (307) 672-1044 Acute Care Hospitals Government - Local TRUE 44.8074250 -106.9755700 0   33 56 56033 43260   Central Sheridan County https://data.medicare.gov/resource/xubh-q36u/row-kh7n.rjz9.bakb 530006 661690 2019-12-02 2019-06-30 60 11         71               71
1389 1389 WILLIAM NEWTON HOSPITAL 1300 EAST FIFTH AVENUE WINFIELD KS 67156 COWLEY (620) 221-2300 Critical Access Hospitals Government - Local TRUE 37.2446490 -96.9824700 0   35 20 20035 11680 Wichita-Arkansas City-Winfield, KS Central Cowley County https://data.medicare.gov/resource/xubh-q36u/row-m266-eq4z.krik 171383 650583 2019-06-04 2018-12-31 19 2         21               21
1390 1390 SOUTH CENTRAL KS MED CENTER 6401 PATTERSON PARKWAY ARKANSAS CITY KS 67005 COWLEY (620) 442-2500 Acute Care Hospitals Government - Local TRUE 37.1345340 -97.0365680 0   35 20 20035 11680 Wichita-Arkansas City-Winfield, KS Central Cowley County https://data.medicare.gov/resource/xubh-q36u/row-dxa5.86gc_tcfu 170150 651616 2019-06-24 2018-12-31 30 2         32 12             44
1396 1396 FORREST GENERAL HOSPITAL 6051 US HIGHWAY 49 HATTIESBURG MS 39404 FORREST (601) 288-7000 Acute Care Hospitals Government - Local TRUE 31.3185784 -89.3295264 1 ROOFTOP 35 28 28035 25620   Central Forrest County https://data.medicare.gov/resource/xubh-q36u/row-sww7-fvy2-pqtj 250078 659303 2019-10-30 2018-09-30 379 40 8       427   24   20       471

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