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

21 rows where "filed_date" is on date 2019-05-30 and geocode_flag = 1

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, county_name, hospital_type, hospital_ownership, emergency_services, geocode_accuracy, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, fy_end_date, acute_beds, icu_beds, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, subprovider_oth_beds, skilled_nursing_beds, oth_longterm_beds, filed_date (date), fy_end_date (date)

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
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
627 627 HACKENSACK-UMC MOUNTAINSIDE BAY AND HIGHLAND AVE MONTCLAIR NJ 7042 ESSEX (973) 429-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8120546 -74.2036597 1 ROOFTOP 13 34 34013 35620 New York-Newark, NY-NJ-CT-PA Central Essex County https://data.medicare.gov/resource/xubh-q36u/row-pe3j.pdff_kug9 310054 648640 2019-05-30 2018-12-31 165 16       4 185 30     16       231
831 831 EASTERN MAINE MEDICAL CENTER PO BOX 404 BANGOR ME 4401 PENOBSCOT (207) 973-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.8080922 -68.7517371 1 ROOFTOP 19 23 23019 12620   Central Penobscot County https://data.medicare.gov/resource/xubh-q36u/row-2mv7_y4vm-bcwh 200033 650703 2019-05-30 2018-09-30 246 44         313   36           349
970 970 ROBERT WOOD JOHNSON UNIVERSITY HOSPITAL ONE ROBERT WOOD JOHNSON PLACE NEW BRUNSWICK NJ 8901 MIDDLESEX (732) 937-8525 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4952121 -74.4501310 1 ROOFTOP 23 34 34023 35620 New York-Newark, NY-NJ-CT-PA Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-x8c8.u8tc.tif5 310038 649802 2019-05-30 2018-12-31 510 16 14   28 14 610               610
1093 1093 NORTHERN DUTCHESS HOSPITAL 6511 SPRINGBROOK AVENUE RHINEBECK NY 12572 DUTCHESS (845) 871-3391 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9356251 -73.9127226 1 ROOFTOP 27 36 36027 35620 New York-Newark, NY-NJ-CT-PA Outlying Dutchess County https://data.medicare.gov/resource/xubh-q36u/row-6kct.fkwh~nawz 330049 650191 2019-05-30 2018-12-31 67 7         74   10           84
1754 1754 CROZER CHESTER MEDICAL CENTER ONE MEDICAL CENTER BOULEVARD UPLAND PA 19013 DELAWARE (610) 447-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.8559248 -75.3692897 1 ROOFTOP 45 42 42045 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Delaware County https://data.medicare.gov/resource/xubh-q36u/row-n43i.tyzh.5v4t 390180 649488 2019-05-30 2018-12-31 287 25 15 14   18 359 52 38       10   459
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
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
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
1983 1983 TACOMA GENERAL ALLENMORE HOSPITAL 315 S MLK JR WAY TACOMA WA 98405 PIERCE (253) 403-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.2593601 -122.4529681 1 ROOFTOP 53 53 53053 42660 Seattle-Tacoma, WA Central Pierce County https://data.medicare.gov/resource/xubh-q36u/row-tg4u.2tin~uuu2 500129 650920 2019-05-30 2018-12-31 235 48       70 353     27         380
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
2155 2155 MOUNT SINAI SOUTH NASSAU ONE HEALTHY WAY OCEANSIDE NY 11572 NASSAU (516) 632-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6528352 -73.6305705 1 GEOMETRIC_CENTER 59 36 36059 35620 New York-Newark, NY-NJ-CT-PA Central Nassau County https://data.medicare.gov/resource/xubh-q36u/row-c4kg.jzxx-isay 330198 650310 2019-05-30 2018-12-31 323 10 12     6 351 36     20       407
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
3591 3591 ALTON MEMORIAL HOSPITAL ONE MEMORIAL DRIVE ALTON IL 62002 MADISON (618) 463-7300 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8995477 -90.1591567 1 ROOFTOP 119 17 17119 41180 St. Louis-St. Charles-Farmington, MO-IL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-45rg.3vzm_7irj 140002 648904 2019-05-30 2018-12-31 120 12         132 20             152
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
3781 3781 DOCTORS' CENTER HOSPITAL SAN JUAN PDA. 20 C/ SAN RAFAEL # 1395 FERNANDEZ JUNCOS PR 909 SAN JUAN (787) 723-2950 Acute Care Hospitals Proprietary TRUE 18.4446749 -66.0761443 1 RANGE_INTERPOLATED 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-u5ha_su64_x3jd 400006 649492 2019-05-30 2018-12-31 123 6         129               129
4159 4159 DETROIT RECEIVING HOSPITAL & UNIV HEALTH CENTER 4201 ST ANTOINE ST - 2C DETROIT MI 48201 WAYNE (313) 745-3104 Acute Care Hospitals Proprietary TRUE 42.3535426 -83.0550940 1 ROOFTOP 163 26 26163 19820 Detroit-Warren-Ann Arbor, MI Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-niud-7c22~chx9 230273 649265 2019-05-30 2018-12-31 134 28 12 9 12   195 19             214
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
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
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
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

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