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

6 rows where "filed_date" is on date 2019-03-01 and hospital_ownership = "Voluntary non-profit - Other"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, coronary_beds, subtotal_acute_beds, subprovider_ipf_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
146 146 HOSPITAL OF CENTRAL CONNECTICUT, THE 100 GRAND STREET NEW BRITAIN CT 6050 HARTFORD (860) 224-5011 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.6620150 -72.7877990 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-wbxc-gjw3~i99u 70035 645240 2019-03-01 2018-09-30 222 24         246 32             278
363 363 BAPTIST MEDICAL CENTER-ATTALA 220 HWY 12 WEST KOSCIUSKO MS 39090 ATTALA (662) 289-4311 Critical Access Hospitals Voluntary non-profit - Other TRUE 33.0655920 -89.5967210 0   7 28 28007         https://data.medicare.gov/resource/xubh-q36u/row-24jy_6div~59c7 251336 644042 2019-03-01 2018-09-30 25           25               25
614 614 BAYSTATE WING HOSPITAL AND MEDICAL CENTERS 40 WRIGHT STREET PALMER MA 1069 HAMPDEN (413) 283-7651 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.1687270 -72.3410310 0   13 25 25013 44140 Springfield-Greenfield Town, MA Central Hampden County https://data.medicare.gov/resource/xubh-q36u/row-jar6~4ycw~3q2r 220030 645421 2019-03-01 2018-09-30 40 6         46 28             74
2058 2058 NORTHSIDE HOSPITAL CHEROKEE 450 NORTHSIDE CHEROKEE BOULEVARD CANTON GA 30115 CHEROKEE (770) 244-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.2275230 -84.4605620 0   57 13 13057 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Cherokee County https://data.medicare.gov/resource/xubh-q36u/row-8mi6.4b7m_m9gq 110008 644263 2019-03-01 2018-09-30 99   15       114               114
3760 3760 DIMMIT REGIONAL HOSPITAL 704 HOSPITAL DRIVE CARRIZO SPRINGS TX 78834 DIMMIT (830) 876-2424 Critical Access Hospitals Voluntary non-profit - Other TRUE 28.5199740 -99.8620980 0   127 48 48127         https://data.medicare.gov/resource/xubh-q36u/row-f4ys-ri9j-kfns 451390 643855 2019-03-01 2018-09-30 25           25               25
4206 4206 THE JAMES B HAGGIN MEMORIAL HOSPITAL 464 LINDEN AVENUE HARRODSBURG KY 40330 MERCER (859) 239-2409 Critical Access Hospitals Voluntary non-profit - Other TRUE 37.7564480 -84.8482120 0   167 21 21167         https://data.medicare.gov/resource/xubh-q36u/row-wq8e~n6v3_qk82 181302 658990 2019-03-01 2018-09-30 21 4         25               25

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