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

16 rows where "filed_date" is on date 2019-06-03 and hospital_ownership = "Voluntary non-profit - Church"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, county_name, geocode_flag, geocode_accuracy, countyfips, statefips, statecountyfips, cbsacode, csatitle, countyequivalent, icu_beds, coronary_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, subprovider_oth_beds, skilled_nursing_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
262 262 CENTURA HEALTH-LITTLETON ADVENTIST HOSPITAL 7700 S BROADWAY LITTLETON CO 80122 ARAPAHOE (303) 730-8900 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.5765540 -104.9884890 0   5 8 8005 19740 Denver-Aurora, CO Central Arapahoe County https://data.medicare.gov/resource/xubh-q36u/row-xab7~spdz_mmxf 60113 649074 2019-06-03 2018-12-31 121 24         159   17           176
592 592 CENTURA HEALTH-AVISTA ADVENTIST HOSPITAL 100 HEALTH PARK DR LOUISVILLE CO 80027 BOULDER (303) 673-1280 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.9508470 -105.1491540 0   13 8 8013 14500 Denver-Aurora, CO Central Boulder County https://data.medicare.gov/resource/xubh-q36u/row-mqpm_6h4w_if8p 60103 649709 2019-06-03 2018-12-31 74 8         108               108
766 766 CAREPOINT HEALTH-HOBOKEN UNIVERSITY MEDICAL CENTER 308 WILLOW AVE HOBOKEN NJ 7030 HUDSON (201) 418-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.7412130 -74.0335590 0   17 34 34017 35620 New York-Newark, NY-NJ-CT-PA Central Hudson County https://data.medicare.gov/resource/xubh-q36u/row-64ry-qaxe-vxjm 310040 649624 2019-06-03 2018-12-31 102 15         117 47 11   15       190
767 767 CAREPOINT HEALTH-CHRIST HOSPITAL 176 PALISADE AVE JERSEY CITY NJ 7306 HUDSON (201) 795-8200 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.7348760 -74.0501420 0   17 34 34017 35620 New York-Newark, NY-NJ-CT-PA Central Hudson County https://data.medicare.gov/resource/xubh-q36u/row-zyny.ji2k-c7cs 310016 648953 2019-06-03 2018-12-31 160 18         178               178
834 834 ST JOSEPH HOSPITAL 360 BROADWAY BANGOR ME 4401 PENOBSCOT (207) 262-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.8145300 -68.7712600 0   19 23 23019 12620   Central Penobscot County https://data.medicare.gov/resource/xubh-q36u/row-ad3u-g4s7-xxty 200001 650700 2019-06-03 2018-12-31 92 7         99               99
1155 1155 BERTRAND CHAFFEE HOSPITAL 224 EAST MAIN STREET SPRINGVILLE NY 14141 ERIE (716) 592-2871 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.5084840 -78.6592350 0   29 36 36029 15380 Buffalo-Cheektowaga, NY Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-kh2y-a8h3~k7jx 330111 650864 2019-06-03 2018-12-31 21   2       23       80       103
2561 2561 CALIFORNIA PACIFIC MEDICAL CENTER - MISSION BERNAL 3555 CESAR CHAVEZ STREET SAN FRANCISCO CA 94110 SAN FRANCISCO (415) 641-6562 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.7480500 -122.4209870 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-9ens-9k58_jhkp 50055 650944 2019-06-03 2018-12-31 110 10         120               120
2895 2895 FRANCISCAN HEALTH DYER 24 JOLIET ST DYER IN 46311 LAKE (219) 865-2141 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.4943650 -87.5241660 0   89 18 18089 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-ptgy-v6qn-79qv 150090 649568 2019-06-03 2018-12-31 119 14 7       140   30           170
2899 2899 FRANCISCAN HEALTH CROWN POINT 1201 S MAIN ST CROWN POINT IN 46307 LAKE (219) 757-6100 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.3964970 -87.3644360 0   89 18 18089 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-bu7y_i7m5~izb5 150126 649896 2019-06-03 2018-12-31 172 22       20 214               214
3100 3100 FRANCISCAN HEALTH INDIANAPOLIS 8111 S EMERSON AVE INDIANAPOLIS IN 46237 MARION (317) 528-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.6483650 -86.0826740 0   97 18 18097 26900 Indianapolis-Carmel-Muncie, IN Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-caju~6id9.wgbb 150162 649897 2019-06-03 2018-12-31 257 60 66   31   441   21           462
3129 3129 BELLA VISTA HOSPITAL CARR 349 KM 2 7 CERRO LAS MESAS MAYAGUEZ PR 681 MAYAGUEZ (787) 652-6045 Acute Care Hospitals Voluntary non-profit - Church TRUE 18.1868275 -67.1192192 1 GEOMETRIC_CENTER 97 72 72097 32420 Mayagüez-San Germán, PR Central Mayagüez Municipio https://data.medicare.gov/resource/xubh-q36u/row-3qj8-u7h6~eihq 400014 650360 2019-06-03 2018-12-31 149 9         158   25           183
3281 3281 GOOD SAMARITAN HOSPITAL MEDICAL CENTER 1000 MONTAUK HIGHWAY WEST ISLIP NY 11795 SUFFOLK (631) 376-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.6968070 -73.2863210 0   103 36 36103 35620 New York-Newark, NY-NJ-CT-PA Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-vej5-kcwb-92y5 330286 651033 2019-06-03 2018-12-31 373 44       16 437               437
3343 3343 FRANCISCAN HEALTH CRAWFORDSVILLE 1710 LAFAYETTE RD CRAWFORDSVILLE IN 47933 MONTGOMERY (765) 362-2800 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.0660730 -86.9080850 0   107 18 18107 18820 Indianapolis-Carmel-Muncie, IN Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-dt4z-fqaw_yjyt 150022 649562 2019-06-03 2018-12-31 24 5         29 11             40
3368 3368 FRANCISCAN HEALTH MOORESVILLE 1201 HADLEY RD MOORESVILLE IN 46158 MORGAN (317) 831-1160 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.6093220 -86.3560980 0   109 18 18109 26900 Indianapolis-Carmel-Muncie, IN Central Morgan County https://data.medicare.gov/resource/xubh-q36u/row-9xhw-5asg~b2v8 150057 649894 2019-06-03 2018-12-31 73       10   83               83
3400 3400 SSM HEALTH ST ANTHONY HOSPITAL - OKLAHOMA CITY 1000 NORTH LEE AVENUE OKLAHOMA CITY OK 73101 OKLAHOMA (405) 272-7000 Acute Care Hospitals Voluntary non-profit - Church TRUE 35.4777860 -97.5242910 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-muxg_8sv2-fqgg 370037 651421 2019-06-03 2018-12-31 309   48       390 53 18 139         600
4094 4094 FRANCISCAN HEALTH LAFAYETTE 1701 S CREASY LN LAFAYETTE IN 47905 TIPPECANOE (765) 502-4334 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.3938450 -86.8383780 0   157 18 18157 29200 Lafayette-West Lafayette-Frankfort, IN Central Tippecanoe County https://data.medicare.gov/resource/xubh-q36u/row-68pj~ad45-cb3k 150109 649570 2019-06-03 2018-12-31 158 16       14 188   15           203

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