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

22 rows where "filed_date" is on date 2019-11-26 and hospital_ownership = "Voluntary non-profit - Other"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: city, state, county_name, hospital_type, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, coronary_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, oth_longterm_beds, all_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
110 110 UNM HOSPITAL 2211 LOMAS BOULEVARD NE ALBUQUERQUE NM 87106 BERNALILLO (505) 272-2111 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.0874830 -106.6181480 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-ntcm.qi4a~h9yr 320001 661059 2019-11-26 2019-06-30 345           473 82             555
120 120 GETTYSBURG HOSPITAL 147 GETTYS STREET GETTYSBURG PA 17325 ADAMS (717) 334-2121 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.8233170 -77.2340440 0   1 42 42001 23900 Harrisburg-York-Lebanon, PA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-493f.cvfq~sac8 390065 660855 2019-11-26 2019-06-30 68 8         76               76
270 270 BACON COUNTY HOSPITAL 302 SOUTH WAYNE STREET ALMA GA 31510 BACON (912) 632-8961 Critical Access Hospitals Voluntary non-profit - Other TRUE 31.5391100 -82.4596870 0   5 13 13005         https://data.medicare.gov/resource/xubh-q36u/row-fsgt~f6fy~f5qx 111327 659492 2019-11-26 2019-06-30 21 4         25       88       113
701 701 ARTESIA GENERAL HOSPITAL 702 N 13TH STREET ARTESIA NM 88210 EDDY (575) 748-3333 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.8486030 -104.4127520 0   15 35 35015 16100   Central Eddy County https://data.medicare.gov/resource/xubh-q36u/row-t6vu-yth8.bk8u 320030 659993 2019-11-26 2019-06-30 34           34 15             49
1380 1380 SKY RIDGE MEDICAL CENTER 10101 RIDGEGATE PARKWAY LONE TREE CO 80124 DOUGLAS (720) 225-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.5293230 -104.8702690 0   35 8 8035 19740 Denver-Aurora, CO Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-qr62~ugzc.jjbq 60112 659642 2019-11-26 2019-06-30 214 30         272               272
1432 1432 JORDAN VALLEY MEDICAL CENTER 3580 WEST 9000 SOUTH WEST JORDAN UT 84088 SALT LAKE (801) 561-8888 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.5879580 -111.9752850 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-uwvk-5p5y~xqkd 460051 662282 2019-11-26 2019-06-30 221 46       11 278 26 10           314
1664 1664 GOOD SAMARITAN HOSPITAL FOURTH AND WALNUT STREETS LEBANON PA 17042 LEBANON (717) 270-7500 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.1463530 -77.1285980 0   41 42 42041 25420 Harrisburg-York-Lebanon, PA Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-nqjx-dmqh-mzcz 390066 661094 2019-11-26 2019-06-30 127 18         145   14           159
1940 1940 SALINAS VALLEY MEMORIAL HOSPITAL 450 EAST ROMIE LANE SALINAS CA 93901 MONTEREY (831) 757-4333 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.6599790 -121.6463270 0   53 6 6053 41500   Central Monterey County https://data.medicare.gov/resource/xubh-q36u/row-prne.hfxw.8pa4 50334 659756 2019-11-26 2019-06-30 216 13       11 240               240
2137 2137 LAKES REGIONAL HEALTHCARE 2301 HIGHWAY 71 SPIRIT LAKE IA 51360 DICKINSON (712) 336-1230 Acute Care Hospitals Voluntary non-profit - Other TRUE 43.4183960 -95.1263120 0   59 19 19059 44020   Central Dickinson County https://data.medicare.gov/resource/xubh-q36u/row-afjd-chpt.x7ew 160124 660085 2019-11-26 2019-06-30 41   3       44               44
2467 2467 ASPIRUS IRON RIVER HOSPITAL & CLINICS, INC 1400 W ICE LAKE ROAD IRON RIVER MI 49935 IRON (906) 265-6121 Critical Access Hospitals Voluntary non-profit - Other TRUE 46.0997200 -88.6202810 0   71 26 26071         https://data.medicare.gov/resource/xubh-q36u/row-5hmu-6w8t_e66h 231318 660105 2019-11-26 2019-06-30 22 3         25               25
2485 2485 LANCASTER GENERAL HOSPITAL 555 NORTH DUKE STREET LANCASTER PA 17604 LANCASTER (717) 299-5511 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.0469750 -76.3053280 0   71 42 42071 29540   Central Lancaster County https://data.medicare.gov/resource/xubh-q36u/row-5fun.iaku_agnn 390100 660294 2019-11-26 2019-06-30 504 48       29 581               581
2487 2487 WELLSPAN EPHRATA COMMUNITY HOSPITAL 169 MARTIN AVENUE EPHRATA PA 17522 LANCASTER (717) 733-0311 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.1868660 -76.1842680 0   71 42 42071 29540   Central Lancaster County https://data.medicare.gov/resource/xubh-q36u/row-yps7.f8sy.qcuw 390225 659881 2019-11-26 2019-06-30 91 19         115 18 8           141
2545 2545 UPMC JAMESON 1211 WILMINGTON AVENUE NEW CASTLE PA 16105 LAWRENCE (724) 656-4100 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.0134520 -80.3511160 0   73 42 42073 35260 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-b3de~w523~gs7s 390016 660435 2019-11-26 2019-06-30 109 12         121   12           133
2945 2945 HUMBOLDT COUNTY MEMORIAL HOSPITAL 1000 NORTH 15TH STREET HUMBOLDT IA 50548 HUMBOLDT (515) 332-4200 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.7318350 -94.2302160 0   91 19 19091         https://data.medicare.gov/resource/xubh-q36u/row-vk9h.9r4x-cbu7 161334 660218 2019-11-26 2019-06-30 17           17           28   45
3229 3229 PENN PRESBYTERIAN MEDICAL CENTER 51 NORTH 39TH STREET PHILADELPHIA PA 19104 PHILADELPHIA (215) 662-8000 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.9571030 -75.1995750 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-pjjq.x5ux.c9er 390223 659880 2019-11-26 2019-06-30 252 44 20       316 22     19       357
3558 3558 SPECTRUM HEALTH UNITED HOSPITAL 615 S BOWER STREET GREENVILLE MI 48838 MONTCALM (616) 754-4691 Acute Care Hospitals Voluntary non-profit - Other FALSE 43.1754690 -85.2687810 0   117 26 26117 24340 Grand Rapids-Wyoming-Muskegon, MI Outlying Montcalm County https://data.medicare.gov/resource/xubh-q36u/row-9sd4-nvyr_c2t3 230035 660578 2019-11-26 2019-06-30 41 8         49       39       88
3654 3654 UPMC NORTHWEST 100 FAIRFIELD DRIVE SENECA PA 16346 VENANGO (814) 676-7600 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.3600260 -79.7079260 0   121 42 42121 36340   Central Venango County https://data.medicare.gov/resource/xubh-q36u/row-tp8h_cf6h_y9en 390091 661096 2019-11-26 2019-06-30 110 8         118 28 9   16       171
3780 3780 PRESBYTERIAN COMMUNITY HOSP 1451 ASHFORD AVENUE SAN JUAN PR 907 SAN JUAN (787) 721-2160 Acute Care Hospitals Voluntary non-profit - Other TRUE 18.4550543 -66.0654679 1 ROOFTOP 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-gmb5-dr3a.fzy4 400001 660874 2019-11-26 2019-06-30 151 6         175               175
3792 3792 EXCELA HEALTH WESTMORELAND HOSPITAL 532 WEST PITTSBURGH STREET GREENSBURG PA 15601 WESTMORELAND (724) 832-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.3013170 -79.5555140 0   129 42 42129 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Westmoreland County https://data.medicare.gov/resource/xubh-q36u/row-j9d6.bgu8-2tdc 390145 659872 2019-11-26 2019-06-30 206 22 12     6 246   26           272
3794 3794 EXCELA HEALTH FRICK HOSPITAL 508 SOUTH CHURCH STREET MOUNT PLEASANT PA 15666 WESTMORELAND (724) 547-1500 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.1463690 -79.5482170 0   129 42 42129 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Westmoreland County https://data.medicare.gov/resource/xubh-q36u/row-duk2-m779~b9mf 390217 659878 2019-11-26 2019-06-30 27   6       33               33
4717 4717 MEDSTAR UNION MEMORIAL HOSPITAL 201 EAST UNIVERSITY PARKWAY BALTIMORE MD 21218 BALTIMORE CITY (410) 554-2227 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.3303820 -76.6143800 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-azaj.edd6.262f 210024 660389 2019-11-26 2019-06-30 133 52         185               185
4724 4724 MEDSTAR GOOD SAMARITAN HOSPITAL 5601 LOCH RAVEN BOULEVARD BALTIMORE MD 21239 BALTIMORE CITY (443) 444-3902 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.3593010 -76.5886840 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-zvrw-pxqd~vwry 210056 659805 2019-11-26 2019-06-30 184 17         201               201

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