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

8 rows where "filed_date" is on date 2019-05-24 and hospital_ownership = "Proprietary"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, countyfips, statefips, csatitle, centraloutlyingcounty, icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_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
1173 1173 COLLETON MEDICAL CENTER 501 ROBERTSON BOULEVARD WALTERBORO SC 29488 COLLETON (843) 782-2000 Acute Care Hospitals Proprietary TRUE 32.9218550 -80.6708800 0   29 45 45029         https://data.medicare.gov/resource/xubh-q36u/row-429y~gw6b~pgj2 420030 648315 2019-05-24 2018-12-31 94 8         102 19 14           135
1197 1197 MEDICAL CENTER ENTERPRISE 400 N EDWARDS STREET ENTERPRISE AL 36330 COFFEE (334) 347-0584 Acute Care Hospitals Proprietary TRUE 31.3181910 -85.8553080 0   31 1 1031 21460 Dothan-Enterprise-Ozark, AL Central Coffee County https://data.medicare.gov/resource/xubh-q36u/row-m58x_64pa.z9zi 10049 648587 2019-05-24 2018-12-31 92 7         99               99
1205 1205 ROSE MEDICAL CENTER 4567 E 9TH AVE DENVER CO 80220 DENVER (303) 320-2121 Acute Care Hospitals Proprietary TRUE 39.7310760 -104.9340110 0   31 8 8031 19740 Denver-Aurora, CO Central Denver County https://data.medicare.gov/resource/xubh-q36u/row-d89y.4k32_5asy 60032 649400 2019-05-24 2018-12-31 167 35       24 226               226
3503 3503 PINE CREEK MEDICAL CENTER LLP 9032 HARRY HINES BLVD DALLAS TX 75235 DALLAS (214) 231-2273 Acute Care Hospitals Proprietary TRUE 32.8401610 -96.8688350 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-yjax~idz9_awg3 450894 648768 2019-05-24 2018-12-31 15           15               15
3521 3521 DOCTORS HOSPITAL OF SARASOTA 5731 BEE RIDGE RD SARASOTA FL 34233 SARASOTA (941) 342-1100 Acute Care Hospitals Proprietary TRUE 27.2989750 -82.4548480 0   115 12 12115 35840 North Port-Sarasota, FL Central Sarasota County https://data.medicare.gov/resource/xubh-q36u/row-5phw~tq29_truf 100166 651508 2019-05-24 2018-12-31 123 16         139 16             155
3648 3648 MERIT HEALTH RANKIN 350 CROSSGATES BLVD BRANDON MS 39042 RANKIN (601) 825-2811 Acute Care Hospitals Proprietary TRUE 32.2862140 -90.0359600 0   121 28 28121 27140 Jackson-Vicksburg-Brookhaven, MS Central Rankin County https://data.medicare.gov/resource/xubh-q36u/row-cu6y_iea7.rvw5 250096 648279 2019-05-24 2018-12-31 106 8         114 20             134
4246 4246 WOMEN'S HOSPITAL THE 4199 GATEWAY BLVD NEWBURGH IN 47630 WARRICK (812) 842-4200 Acute Care Hospitals Proprietary TRUE 37.9735480 -87.4491090 0   173 18 18173 21780   Central Warrick County https://data.medicare.gov/resource/xubh-q36u/row-rn9t.t87t.eat4 150149 648611 2019-05-24 2018-12-31 50 24         74               74
4608 4608 QUAIL CREEK SURGICAL HOSPITAL 6819 PLUM CREEK AMARILLO TX 79124 POTTER (806) 354-6100 Acute Care Hospitals Proprietary TRUE 35.2106750 -101.9135680 0   375 48 48375 11100 Amarillo-Borger, TX Central Potter County https://data.medicare.gov/resource/xubh-q36u/row-3fht_yhjz.yec5 450875 648767 2019-05-24 2018-12-31 32           32               32

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