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" sorted by phone_number

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

hospital_ownership ✖

  • Government - 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
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
3333 3333 PICKENS COUNTY MEDICAL CENTER 241 ROBERT K WILSON DRIVE CARROLLTON AL 35447 PICKENS (205) 367-8111 Acute Care Hospitals Government - Local TRUE 33.2748070 -88.0896730 0   107 1 1107 46220   Outlying Pickens County https://data.medicare.gov/resource/xubh-q36u/row-zn5h.i3rc.njwh 10109 644006 2019-03-01 2018-09-30 36 4         40 10             50
2238 2238 GREENE COUNTY HOSPITAL 509 WILSON AVENUE EUTAW AL 35462 GREENE (205) 372-3388 Acute Care Hospitals Government - Local TRUE 32.8447440 -87.8893070 0   63 1 1063         https://data.medicare.gov/resource/xubh-q36u/row-dyit.ypt9~f4e7 10051 645036 2019-03-04 2018-09-30 20           20       72       92
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
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
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
2299 2299 MADISON MEMORIAL HOSPITAL 450 EAST MAIN STREET REXBURG ID 83440 MADISON (208) 359-6900 Acute Care Hospitals Government - Local TRUE 43.8260510 -111.7731480 0   65 16 16065 39940 Idaho Falls-Rexburg-Blackfoot, ID Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-x7qh_3ndv.ii77 130025 643024 2019-02-05 2018-09-30 49 4         67               67
1731 1731 VALOR HEALTH 1202 EAST LOCUST STREET EMMETT ID 83617 GEM (208) 365-3561 Critical Access Hospitals Government - Local TRUE 43.8790780 -116.4852550 0   45 16 16045 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Gem County https://data.medicare.gov/resource/xubh-q36u/row-cch8-kmmd-nmhb 131318 644635 2019-02-28 2018-09-30 13           13               13
2345 2345 MINIDOKA MEMORIAL HOSPITAL 1224 8TH STREET RUPERT ID 83350 MINIDOKA (208) 436-0481 Critical Access Hospitals Government - Local TRUE 42.6196250 -113.6853620 0   67 16 16067 15420   Outlying Minidoka County https://data.medicare.gov/resource/xubh-q36u/row-m4t9~2798.xb46 131319 643405 2019-02-26 2018-09-30 16           16       46       62
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
2135 2135 STEELE MEMORIAL MEDICAL CENTER 203 SOUTH DAISY STREET SALMON ID 83467 LEMHI (208) 756-5600 Critical Access Hospitals Government - Local TRUE 45.1733110 -113.8909180 0   59 16 16059         https://data.medicare.gov/resource/xubh-q36u/row-frkw_jutq_kwk4 131305 645073 2019-03-05 2018-09-30 18           18               18
2320 2320 NELL J REDFIELD MEMORIAL HOSPITAL 150 NORTH 200 WEST MALAD ID 83252 ONEIDA (208) 766-2231 Critical Access Hospitals Government - Local TRUE 42.1896380 -112.2507590 0   71 16 16071         https://data.medicare.gov/resource/xubh-q36u/row-dtun.jgpu~2hmu 131303 662195 2019-11-26 2019-06-30 11           11       33       44
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
1641 1641 FRANKLIN COUNTY MEDICAL CENTER 44 NORTH FIRST EAST PRESTON ID 83263 FRANKLIN (208) 852-0137 Critical Access Hospitals Government - Local TRUE 42.0983790 -111.8754670 0   41 16 16041 30860   Outlying Franklin County https://data.medicare.gov/resource/xubh-q36u/row-9du2~qaxa~z8nm 131322 645243 2019-03-08 2018-09-30 20           20       35       55
2594 2594 SAN JOAQUIN GENERAL HOSPITAL 500 W HOSPITAL ROAD FRENCH CAMP CA 95231 SAN JOAQUIN (209) 468-6000 Acute Care Hospitals Government - Local TRUE 37.8864920 -121.2820610 0   77 6 6077 44700 San Jose-San Francisco-Oakland, CA Central San Joaquin County https://data.medicare.gov/resource/xubh-q36u/row-imza-7dfi-q9b9 50167 661140 2019-12-02 2019-06-30 155 16       25 196               196
2209 2209 METROPOLITAN HOSPITAL CENTER 1901 FIRST AVENUE NEW YORK NY 10029 NEW YORK (212) 423-6262 Acute Care Hospitals Government - Local TRUE 40.7847200 -73.9436360 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-qux6~jv33~mbyj 330199 662131 2019-12-18 2019-06-30 158 24       14 196 122 20           338
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
2201 2201 BELLEVUE HOSPITAL CENTER 462 FIRST AVENUE NEW YORK NY 10016 NEW YORK (212) 562-4141 Acute Care Hospitals Government - Local TRUE 40.7400790 -73.9762500 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-9bwr~dxtd~5pcz 330204 662231 2019-12-20 2019-06-30 445 45 12     25 527 339 46           912
2200 2200 HARLEM HOSPITAL CENTER 506 LENOX AVENUE NEW YORK NY 10037 NEW YORK (212) 939-1000 Acute Care Hospitals Government - Local TRUE 40.8144820 -73.9404950 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-ghrr_yxuq.x5j3 330240 662232 2019-12-20 2019-06-30 190 17 6 3   15 231 51             282
1587 1587 WARNER HOSPITAL AND HEALTH SERVICES 422 W WHITE ST CLINTON IL 61727 DE WITT (217) 935-9571 Critical Access Hospitals Government - Local TRUE 40.1489530 -88.9646160 0   39 17 17039 14010 Bloomington-Pontiac, IL Outlying De Witt County https://data.medicare.gov/resource/xubh-q36u/row-gzhh-tmyy.cr8h 141303 654575 2019-09-26 2019-04-30 15           15               15
3878 3878 ESSENTIA HEALTH VIRGINIA 901 9TH STREET NORTH VIRGINIA MN 55792 ST. LOUIS (218) 741-3340 Acute Care Hospitals Government - Local FALSE 47.5307110 -92.5487970 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-39c9_62zv_e3w4 240084 662217 2019-12-02 2019-06-30 40 8         48   16   77       141
2860 2860 MAHNOMEN HEALTH CENTER 414 W JEFFERSON PO BOX 396 MAHNOMEN MN 56557 MAHNOMEN (218) 935-2511 Critical Access Hospitals Government - Local TRUE 47.3117925 -95.9729278 1 ROOFTOP 87 27 27087         https://data.medicare.gov/resource/xubh-q36u/row-hmyn_2dwh_mr9t 241300 651009 2019-06-04 2018-12-31 10           10       32       42
1742 1742 OCHSNER MEDICAL CENTER-HANCOCK 149 DRINKWATER BLVD BAY SAINT LOUIS MS 39520 HANCOCK (228) 467-8600 Acute Care Hospitals Government - Local TRUE 30.3130400 -89.3556570 0   45 28 28045 25060   Central Hancock County https://data.medicare.gov/resource/xubh-q36u/row-8qr6~e2iu-2dck 250162 645723 2019-03-01 2018-09-30 41 6         47               47
2144 2144 SINGING RIVER HEALTH SYSTEM 2809 DENNY AV PASCAGOULA MS 39581 JACKSON (228) 809-5000 Acute Care Hospitals Government - Local TRUE 30.3748710 -88.5324040 0   59 28 28059 25060   Outlying Jackson County https://data.medicare.gov/resource/xubh-q36u/row-tcrr_p47m-6bi7 250040 645722 2019-03-01 2018-09-30 272 48         320 14 20   36       390
1788 1788 MEMORIAL HOSPITAL AT GULFPORT 4500 13TH STREET GULFPORT MS 39502 HARRISON (228) 867-4000 Acute Care Hospitals Government - Local TRUE 30.3669280 -89.1149070 0   47 28 28047 25060   Central Harrison County https://data.medicare.gov/resource/xubh-q36u/row-s5rd_v3j6.9dir 250019 640104 2018-12-26 2018-09-30 232 26         281               281
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
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
3346 3346 SPECTRUM HEALTH BIG RAPIDS HOSPITAL 605 OAK STREET BIG RAPIDS MI 49307 MECOSTA (231) 796-8691 Acute Care Hospitals Government - Local TRUE 43.6931260 -85.4757630 0   107 26 26107 13660 Grand Rapids-Wyoming-Muskegon, MI Central Mecosta County https://data.medicare.gov/resource/xubh-q36u/row-6wsn~km5g_qqzq 230093 660588 2019-11-25 2019-06-30 45 4         49               49
3132 3132 MONROE COUNTY HOSPITAL 2016 SOUTH ALABAMA AVENUE MONROEVILLE AL 36460 MONROE (251) 575-3111 Acute Care Hospitals Government - Local TRUE 31.4978390 -87.3194110 0   99 1 1099         https://data.medicare.gov/resource/xubh-q36u/row-4wyz~k8fh_i5ug 10120 645040 2019-03-13 2018-09-30 41 8         49               49
1658 1658 VIDANT CHOWAN HOSPITAL 211 VIRGINIA RD EDENTON NC 27932 CHOWAN (252) 482-8451 Critical Access Hospitals Government - Local TRUE 36.0707740 -76.6090930 0   41 37 37041         https://data.medicare.gov/resource/xubh-q36u/row-trbd~xc39_h8ri 341318 644158 2019-02-28 2018-09-30 21 4         25               25
2317 2317 VIDANT EDGECOMBE HOSPITAL 111 HOSPITAL DR TARBORO NC 27886 EDGECOMBE (252) 641-7700 Acute Care Hospitals Government - Local TRUE 35.9218850 -77.5569940 0   65 37 37065 40580 Rocky Mount-Wilson-Roanoke Rapids, NC Central Edgecombe County https://data.medicare.gov/resource/xubh-q36u/row-9nuq.ij7s_3aca 340107 643926 2019-02-28 2018-09-30 86 15         101   16           117
3565 3565 MARTIN GENERAL HOSPITAL 310 S MCCASKEY RD P O BOX 1128 WILLIAMSTON NC 27892 MARTIN (252) 809-6179 Acute Care Hospitals Government - Local TRUE 35.8404770 -77.0711780 0   117 37 37117         https://data.medicare.gov/resource/xubh-q36u/row-6ty4.gevs-5eff 340133 654859 2019-09-25 2019-04-30 37 6         43               43
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
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
2570 2570 IU HEALTH JAY 500 W VOTAW ST PORTLAND IN 47371 JAY (260) 726-7131 Critical Access Hospitals Government - Local TRUE 40.4393660 -84.9841050 0   75 18 18075         https://data.medicare.gov/resource/xubh-q36u/row-krfy-myt9_8mki 151320 648822 2019-05-28 2018-12-31 25           25 10             35
2173 2173 FROEDTERT SOUTH - KENOSHA MEDICAL CENTER 6308 EIGHTH AVE KENOSHA WI 53143 KENOSHA (262) 656-2011 Acute Care Hospitals Government - Local TRUE 42.5777120 -87.8192850 0   59 55 55059 16980 Chicago-Naperville, IL-IN-WI Outlying Kenosha County https://data.medicare.gov/resource/xubh-q36u/row-eef7.jhz3-xedh 520021 659910 2019-11-20 2019-06-30 185 15         200               200
4018 4018 STURGIS HOSPITAL 916 MYRTLE AVE STURGIS MI 49091 ST. JOSEPH (269) 651-7824 Acute Care Hospitals Government - Local TRUE 41.7941930 -85.4073080 0   149 26 26149 44780 Kalamazoo-Battle Creek-Portage, MI Central St. Joseph County https://data.medicare.gov/resource/xubh-q36u/row-pcw2.cypd.6m9k 230096 644293 2019-02-20 2018-09-30 45   4       49               49
2995 2995 HARDIN MEMORIAL HOSPITAL 913 NORTH DIXIE AVENUE ELIZABETHTOWN KY 42701 HARDIN (270) 737-1212 Acute Care Hospitals Government - Local TRUE 37.7099170 -85.8750480 0   93 21 21093 21060 Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Central Hardin County https://data.medicare.gov/resource/xubh-q36u/row-g22s~wmun-s6iz 180012 660555 2019-11-21 2019-06-30 250 10 10       270 15     15       300
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
2069 2069 CUMBERLAND COUNTY HOSPITAL 299 GLASGOW ROAD BURKESVILLE KY 42717 CUMBERLAND (270) 864-2511 Critical Access Hospitals Government - Local TRUE 36.7968680 -85.3724400 0   57 21 21057         https://data.medicare.gov/resource/xubh-q36u/row-ptk2_m6d2-xzym 181317 661512 2019-12-02 2019-06-30 25           25               25
4453 4453 RUSSELL COUNTY HOSPITAL 153 DOWELL ROAD RUSSELL SPRINGS KY 42642 RUSSELL (270) 866-4141 Critical Access Hospitals Government - Local TRUE 37.0577070 -85.0668840 0   207 21 21207         https://data.medicare.gov/resource/xubh-q36u/row-sgx3_zv6f.tpnh 181330 660570 2019-11-22 2019-06-30 23 2         25               25
2004 2004 CRITTENDEN COMMUNITY HOSPITAL 520 WEST GUM STREET MARION KY 42064 CRITTENDEN (270) 965-1001 Acute Care Hospitals Government - Local TRUE 37.3296160 -88.0919450 0   55 21 21055         https://data.medicare.gov/resource/xubh-q36u/row-29y5_rw8y-4sga 180095 643771 2019-03-01 2018-09-30 48           48               48
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
3295 3295 WETZEL COUNTY HOSPITAL #3 EAST BENJAMIN DRIVE NEW MARTINSVILLE WV 26155 WETZEL (304) 455-8000 Acute Care Hospitals Government - Local TRUE 39.6810712 -80.8501977 1 ROOFTOP 103 54 54103         https://data.medicare.gov/resource/xubh-q36u/row-v7h8~v92p-92tq 510072 661438 2019-12-02 2019-06-30 43 5         48               48
2042 2042 PRINCETON COMMUNITY HOSPITAL 122 12TH STREET PRINCETON WV 24740 MERCER (304) 487-7260 Acute Care Hospitals Government - Local TRUE 37.3624580 -81.1130970 0   55 54 54055 14140   Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-sk8g_82ie~wytp 510046 660726 2019-11-26 2019-06-30 78   11       89 64             153
3069 3069 SISTERSVILLE GENERAL HOSPITAL 314 SOUTH WELLS STREET SISTERSVILLE WV 26175 TYLER (304) 652-2611 Critical Access Hospitals Government - Local TRUE 39.5583390 -81.0040670 0   95 54 54095         https://data.medicare.gov/resource/xubh-q36u/row-2s4x~j49z-cdcm 511304 650921 2019-06-04 2018-12-31 25           25           10   35
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
3240 3240 WEBSTER COUNTY MEMORIAL HOSPITAL 324 MILLER MOUNTAIN DRIVE WEBSTER SPRINGS WV 26288 WEBSTER (304) 847-5682 Critical Access Hospitals Government - Local TRUE 38.4818680 -80.4098110 0   101 54 54101         https://data.medicare.gov/resource/xubh-q36u/row-stvk~jdqs~5m5u 511301 661266 2019-12-02 2019-06-30 25           25               25
2381 2381 SUMMERSVILLE REGIONAL MEDICAL CENTER 400 FAIRVIEW HEIGHTS ROAD SUMMERSVILLE WV 26651 NICHOLAS (304) 872-2891 Critical Access Hospitals Government - Local TRUE 38.2919030 -80.8311360 0   67 54 54067         https://data.medicare.gov/resource/xubh-q36u/row-a2eh.63jr_sfyc 511322 661675 2019-12-03 2019-06-30 19 6         25       52       77
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
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
1719 1719 WASHAKIE MEDICAL CENTER 400 SOUTH 15TH STREET WORLAND WY 82401 WASHAKIE (307) 347-3221 Critical Access Hospitals Government - Local TRUE 44.0135560 -107.9484090 0   43 56 56043         https://data.medicare.gov/resource/xubh-q36u/row-wgjq-rwdt.3x58 531306 649859 2019-06-03 2018-12-31 18           18               18
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
1577 1577 MEMORIAL HOSPITAL SWEETWATER COUNTY 1200 COLLEGE DRIVE ROCK SPRINGS WY 82901 SWEETWATER (307) 362-3711 Acute Care Hospitals Government - Local TRUE 41.5840600 -109.2335780 0   37 56 56037 40540   Central Sweetwater County https://data.medicare.gov/resource/xubh-q36u/row-x7m7_kvh5~qmi2 530011 661448 2019-12-02 2019-06-30 48 10         58               58
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
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
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
3320 3320 KIMBALL HEALTH SERVICES 505 SOUTH BURG ST KIMBALL NE 69145 KIMBALL (308) 235-1951 Critical Access Hospitals Government - Local TRUE 41.2324380 -103.6672040 0   105 31 31105         https://data.medicare.gov/resource/xubh-q36u/row-3qnf.krtg-ks6w 281305 662400 2019-12-06 2019-06-30 15           15               15
3688 3688 MORRILL COUNTY COMMUNITY HOSPITAL 1313 S STREET BRIDGEPORT NE 69336 MORRILL (308) 262-1616 Critical Access Hospitals Government - Local TRUE 41.6618900 -103.0913740 0   123 31 31123         https://data.medicare.gov/resource/xubh-q36u/row-zd5w.8rx8_6yzu 281318 661038 2019-12-02 2019-06-30 20           20               20
2077 2077 DUNDY COUNTY HOSPITAL P O BOX 626, 1313 NORTH CHEYENNE ST BENKELMAN NE 69021 DUNDY (308) 423-2204 Critical Access Hospitals Government - Local TRUE 40.0565540 -101.5374470 1 ROOFTOP 57 31 31057         https://data.medicare.gov/resource/xubh-q36u/row-pych_p5gr-xzj5 281340 652885 2019-08-05 2019-02-28 14           14               14
2197 2197 FRANKLIN COUNTY MEMORIAL HOSPITAL 1406 Q ST FRANKLIN NE 68939 FRANKLIN (308) 425-6221 Critical Access Hospitals Government - Local TRUE 40.1015520 -98.9543530 0   61 31 31061         https://data.medicare.gov/resource/xubh-q36u/row-7jps~ae6v.42rk 281311 656707 2019-11-05 2019-06-30 14           14               14
4268 4268 VALLEY COUNTY HEALTH SYSTEM 2707 L STREET ORD NE 68862 VALLEY (308) 728-4200 Critical Access Hospitals Government - Local TRUE 41.6032130 -98.9426760 0   175 31 31175         https://data.medicare.gov/resource/xubh-q36u/row-y2qv_7x4q_v7xu 281353 661044 2019-12-02 2019-06-30 16           16               16
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
3171 3171 KEARNEY COUNTY HEALTH SERVICES HOSPITAL 727 EAST 1ST ST MINDEN NE 68959 KEARNEY (308) 832-3400 Critical Access Hospitals Government - Local TRUE 40.4957780 -98.9432030 0   99 31 31099 28260   Outlying Kearney County https://data.medicare.gov/resource/xubh-q36u/row-aaj3.vtp7.jy9v 281306 654341 2019-09-09 2019-06-30 10           10               10
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
2756 2756 HARLAN COUNTY HEALTH SYSTEM P O BOX 836, 717 NORTH BROWN ST ALMA NE 68920 HARLAN (308) 928-2151 Critical Access Hospitals Government - Local TRUE 40.0981797 -99.3631677 1 ROOFTOP 83 31 31083         https://data.medicare.gov/resource/xubh-q36u/row-yvs4.45jj.87ms 281300 647189 2019-04-23 2018-12-31 19           19               19
3650 3650 MERRICK MEDICAL CENTER 1715 26TH ST CENTRAL CITY NE 68826 MERRICK (308) 946-3015 Critical Access Hospitals Government - Local TRUE 41.1066100 -98.0026520 0   121 31 31121 24260   Outlying Merrick County https://data.medicare.gov/resource/xubh-q36u/row-tf8v-t66v_jxv4 281328 649920 2019-06-03 2018-12-31 20           20               20
4132 4132 GENESIS HEALTH SYSTEM 801 ILLINI DR SILVIS IL 61282 ROCK ISLAND (309) 281-4000 Acute Care Hospitals Government - Local TRUE 41.4930680 -90.4199970 0   161 17 17161 19340 Davenport-Moline, IA-IL Central Rock Island County https://data.medicare.gov/resource/xubh-q36u/row-wxqw_k6y5~djg4 140275 654836 2019-09-24 2019-06-30 138 7         145       92 28     265
1475 1475 LAC/HARBOR-UCLA MED CENTER 1000 W CARSON ST TORRANCE CA 90502 LOS ANGELES (310) 222-2101 Acute Care Hospitals Government - Local TRUE 33.8315830 -118.2945460 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-5whm.24nh_dyri 50376 662474 2019-12-03 2019-06-30 311 46 6       390 38             428
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
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
2914 2914 MASSENA MEMORIAL HOSPITAL 1 HOSPITAL DRIVE MASSENA NY 13662 ST. LAWRENCE (315) 764-1711 Acute Care Hospitals Government - Local TRUE 44.9363440 -74.9078280 0   89 36 36089 36300   Central St. Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-ysnc_8hd4_9yyh 330223 659330 2019-11-07 2018-12-31 46 4         50               50
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
2136 2136 HANCOCK REGIONAL HOSPITAL 801 N STATE ST GREENFIELD IN 46140 HANCOCK (317) 462-5544 Acute Care Hospitals Government - Local TRUE 39.7949520 -85.7696040 0   59 18 18059 26900 Indianapolis-Carmel-Muncie, IN Central Hancock County https://data.medicare.gov/resource/xubh-q36u/row-9wnz_ckw6~khmk 150037 649205 2019-05-31 2018-12-31 37 24         61 10         7   78
2696 2696 JOHNSON MEMORIAL HOSPITAL 1125 W JEFFERSON ST FRANKLIN IN 46131 JOHNSON (317) 736-3300 Acute Care Hospitals Government - Local TRUE 39.4805980 -86.0766630 0   81 18 18081 26900 Indianapolis-Carmel-Muncie, IN Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-gz4n-xn3z~kiqn 150001 649201 2019-05-31 2018-12-31 77 6         83   11           94
2246 2246 HENDRICKS REGIONAL HEALTH 1000 E MAIN ST DANVILLE IN 46122 HENDRICKS (317) 745-4451 Acute Care Hospitals Government - Local TRUE 39.7607100 -86.5009950 0   63 18 18063 26900 Indianapolis-Carmel-Muncie, IN Central Hendricks County https://data.medicare.gov/resource/xubh-q36u/row-7pz3-j79y~ybxb 150005 649202 2019-05-31 2018-12-31 121 12         133               133
2063 2063 RIVERVIEW HEALTH 395 WESTFIELD RD NOBLESVILLE IN 46060 HAMILTON (317) 773-0760 Acute Care Hospitals Government - Local TRUE 40.0470260 -86.0240810 0   57 18 18057 26900 Indianapolis-Carmel-Muncie, IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-2tme-mzbr.en9s 150059 659262 2019-05-30 2018-12-31 94 15         109   24   25       158
3099 3099 ESKENAZI HEALTH 720 ESKENAZI AVENUE INDIANAPOLIS IN 46202 MARION (317) 880-4818 Acute Care Hospitals Government - Local TRUE 39.7805300 -86.1734500 0   97 18 18097 26900 Indianapolis-Carmel-Muncie, IN Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-fv8t.e66e-c8mj 150024 649564 2019-06-03 2018-12-31 192 72   15     316 20             336
4212 4212 VAN BUREN COUNTY HOSPITAL 304 FRANKLIN STREET KEOSAUQUA IA 52565 VAN BUREN (319) 293-3171 Critical Access Hospitals Government - Local TRUE 40.7358620 -91.9590430 0   177 19 19177         https://data.medicare.gov/resource/xubh-q36u/row-e8fj_uhg7-i98m 161337 660970 2019-11-27 2019-06-30 25           25               25
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
2855 2855 HENRY COUNTY HEALTH CENTER 407 S WHITE ST MOUNT PLEASANT IA 52641 HENRY (319) 385-3141 Critical Access Hospitals Government - Local TRUE 40.9631160 -91.5580180 0   87 19 19087         https://data.medicare.gov/resource/xubh-q36u/row-vzbh~3fhi_gk69 161356 662119 2019-12-05 2019-06-30 25           25       74       99
2358 2358 CARRIS HEALTH LLC 301 BECKER AVE SW WILLMAR MN 56201 KANDIYOHI (320) 235-4543 Acute Care Hospitals Government - Local TRUE 45.1205140 -95.0463660 0   67 27 27067 48820   Central Kandiyohi County https://data.medicare.gov/resource/xubh-q36u/row-ypur_bzw7_kp3d 240088 661914 2019-12-06 2019-06-30 73 8         81       78       159
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
4040 4040 APPLETON MUNICIPAL HOSPITAL 30 SOUTH BEHL STREET APPLETON MN 56208 SWIFT (320) 289-8508 Critical Access Hospitals Government - Local TRUE 45.1996580 -96.0092240 0   151 27 27151         https://data.medicare.gov/resource/xubh-q36u/row-egz5_fa7v_8upj 241341 656449 2019-10-21 2018-09-30 15           15       50       65
3785 3785 RENVILLE COUNTY HOSPITAL AND CLINICS 100 HEALTHY WAY OLIVIA MN 56277 RENVILLE (320) 523-1261 Critical Access Hospitals Government - Local TRUE 44.7747296 -94.9724885 1 ROOFTOP 129 27 27129         https://data.medicare.gov/resource/xubh-q36u/row-9bry_ub3h~y6xn 241306 652484 2019-07-29 2018-12-31 16           16           16   32
4254 4254 MUNICIPAL HOSPITAL AND GRANITE MANOR 345 TENTH AVENUE GRANITE FALLS MN 56241 YELLOW MEDCINE (320) 564-3111 Critical Access Hospitals Government - Local TRUE 44.8087370 -95.5424670 0   173 27 27173         https://data.medicare.gov/resource/xubh-q36u/row-btj8.8k3m-tcy7 241343 649454 2019-05-29 2018-12-31 25           25       48       73
2309 2309 FIRSTLIGHT HEALTH SYSTEM 301 SOUTH HIGHWAY 65 MORA MN 55051 KANABEC (320) 679-1212 Critical Access Hospitals Government - Local TRUE 45.8733900 -93.2899550 0   65 27 27065         https://data.medicare.gov/resource/xubh-q36u/row-v75d-m8y9-db5g 241367 653975 2019-09-06 2018-12-31 21 4         25               25
2999 2999 MEEKER MEMORIAL HOSPITAL 612 SOUTH SIBLEY AVENUE LITCHFIELD MN 55355 MEEKER (320) 693-4507 Critical Access Hospitals Government - Local TRUE 45.1200030 -94.5280310 0   93 27 27093         https://data.medicare.gov/resource/xubh-q36u/row-yr69~qb3q~7yf3 241366 649455 2019-05-29 2018-12-31 25           25 8             33
1650 1650 ALOMERE HEALTH 111 17TH AVENUE EAST ALEXANDRIA MN 56308 DOUGLAS (320) 762-1511 Acute Care Hospitals Government - Local TRUE 45.8726690 -95.3763800 0   41 27 27041 10820   Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-psb9.f8hy_pu25 240030 649757 2019-05-30 2018-12-31 91 8         99               99
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
1473 1473 LAC+USC MEDICAL CENTER 1200 N STATE ST, ROOM C2K100 LOS ANGELES CA 90033 LOS ANGELES (323) 226-2800 Acute Care Hospitals Government - Local TRUE 34.0598720 -118.2103080 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-zb2x~3wn3~q6ug 50373 662473 2019-12-03 2019-06-30 396 128 10 20     594 76             670
4523 4523 ANSON GENERAL HOSPITAL 101 AVENUE J ANSON TX 79501 JONES (325) 823-3231 Acute Care Hospitals Government - Local TRUE 32.7681010 -99.8955140 0   253 48 48253 10180   Outlying Jones County https://data.medicare.gov/resource/xubh-q36u/row-yt33_gjz7-gmyy 450078 653860 2019-09-03 2019-03-31 7           7           6   13
4227 4227 WOOSTER COMMUNITY HOSPITAL 1761 BEALL AVENUE WOOSTER OH 44691 WAYNE (330) 263-8100 Acute Care Hospitals Government - Local TRUE 40.8207130 -81.9342470 0   169 39 39169 49300   Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-bh63_heg3-ryxh 360036 649308 2019-06-03 2018-12-31 90 14         104   10   22       136
2581 2581 POMERENE HOSPITAL 981 WOOSTER ROAD MILLERSBURG OH 44654 HOLMES (330) 674-1015 Acute Care Hospitals Government - Local TRUE 40.5643200 -81.9204920 0   75 39 39075         https://data.medicare.gov/resource/xubh-q36u/row-t7kd-h3yq_bv7v 360148 650893 2019-06-04 2018-12-31 37 4         41               41
4373 4373 WILKES REGIONAL MEDICAL CENTER 1370 WEST D ST NORTH WILKESBORO NC 28659 WILKES (336) 651-8100 Acute Care Hospitals Government - Local TRUE 36.1584650 -81.1570130 0   193 37 37193 35900   Central Wilkes County https://data.medicare.gov/resource/xubh-q36u/row-mugx~rcjs~9jqq 340064 661369 2019-12-02 2019-06-30 85 8         93       10       103
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
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
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
3115 3115 JOHNSON COUNTY HOSPITAL 202 HIGH ST TECUMSEH NE 68450 JOHNSON (402) 335-3361 Critical Access Hospitals Government - Local TRUE 40.3791920 -96.1973420 0   97 31 31097         https://data.medicare.gov/resource/xubh-q36u/row-zhkd~ybts_qztb 281350 659707 2019-11-18 2019-06-30 18           18               18
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

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