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

12 rows where burn_beds = 8

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: city, state, county_name, hospital_ownership, countyfips, statefips, statecountyfips, cbsacode, csatitle, countyequivalent, filed_date, fy_end_date, icu_beds, coronary_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, filed_date (date), fy_end_date (date)

burn_beds ✖

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
76 76 UF HEALTH SHANDS HOSPITAL 1600 SW ARCHER RD GAINESVILLE FL 32610 ALACHUA (352) 265-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.6392230 -82.3433250 0   1 12 12001 23540 Gainesville-Lake City, FL Central Alachua County https://data.medicare.gov/resource/xubh-q36u/row-6avt~6iq6-eksg 100113 661480 2019-11-27 2019-06-30 519 66 48 8 96   921 90 39           1050
306 306 JACOBI MEDICAL CENTER 1400 PELHAM PARKWAY SOUTH BRONX NY 10461 BRONX (718) 918-5000 Acute Care Hospitals Government - Local TRUE 40.8574550 -73.8472100 0   5 36 36005 35620 New York-Newark, NY-NJ-CT-PA Central Bronx County https://data.medicare.gov/resource/xubh-q36u/row-ah92_ybye.fwuw 330127 661748 2019-12-03 2019-06-30 249 32 12 8   25 326 89 24           439
1160 1160 ERIE COUNTY MEDICAL CENTER 462 GRIDER STREET BUFFALO NY 14215 ERIE (716) 898-3936 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9272360 -78.8291510 0   29 36 36029 15380 Buffalo-Cheektowaga, NY Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-6f2k.kya2.7ejd 330219 650316 2019-05-31 2018-12-31 302 30   8     340 136 40   390       906
1220 1220 JOHN H STROGER JR HOSPITAL 1901 W HARRISON ST CHICAGO IL 60612 COOK (312) 864-6000 Acute Care Hospitals Government - Local TRUE 41.8740410 -87.6743110 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-2ss5~bvsp.bpf4 140124 659251 2019-11-07 2018-11-30 310 32   8 14   448               448
1231 1231 THE UNIVERSITY OF CHICAGO MEDICAL CENTER 5841 SOUTH MARYLAND CHICAGO IL 60637 COOK (773) 702-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7879560 -87.6049250 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-i6p4_vxuh-wg5y 140088 662041 2019-12-19 2019-06-30 505 79 37 8   53 682               682
1329 1329 BATON ROUGE GENERAL MEDICAL CENTER 3600 FLORIDA BLVD BATON ROUGE LA 70806 E. BATON ROUGE (225) 387-7767 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4503360 -91.1546380 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-wzk2-7azq.gecu 190065 643777 2019-02-28 2018-09-30 212 24   8   9 253 50 8   54       365
2125 2125 UNIVERSITY OF CALIFORNIA IRVINE MED CENTER 101 CITY DRIVE SOUTH ORANGE CA 92868 ORANGE (714) 456-6112 Acute Care Hospitals Government - Local TRUE 33.7801110 -117.8943030 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-rbt4-6ucg-c9d4 50348 659757 2019-11-26 2019-06-30 242 50 10 8     352 48 14           414
2344 2344 WELLSTAR COBB HOSPITAL 3950 AUSTELL RD AUSTELL GA 30106 COBB (770) 732-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.8567010 -84.6015610 0   67 13 13067 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Cobb County https://data.medicare.gov/resource/xubh-q36u/row-9x86.sqzq-hgnz 110143 654421 2019-09-30 2019-06-30 308 26   8   25 367   20           387
2510 2510 UC SAN DIEGO HEALTH HILLCREST - HILLCREST MED CTR 200 WEST ARBOR DRIVE SAN DIEGO CA 92103 SAN DIEGO (619) 543-6222 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.7537170 -117.1659140 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-2d2j.kc8f_hnd2 50025 662154 2019-11-27 2019-06-30 513   46 8 50 52 669 32             701
2701 2701 SPECTRUM HEALTH - BUTTERWORTH CAMPUS 100 MICHIGAN ST NE GRAND RAPIDS MI 49503 KENT (616) 391-1774 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9705270 -85.6653190 0   81 26 26081 24340 Grand Rapids-Wyoming-Muskegon, MI Central Kent County https://data.medicare.gov/resource/xubh-q36u/row-wvf2~fzgf.ud23 230038 660580 2019-11-26 2019-06-30 897 94   8     1095   42   250       1387
2780 2780 SANTA CLARA VALLEY MEDICAL CENTER 751 SOUTH BASCOM AVENUE SAN JOSE CA 95128 SANTA CLARA (408) 885-5000 Acute Care Hospitals Government - Local TRUE 37.3137020 -121.9318880 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-uh57.f27a-8g3n 50038 662012 2019-12-04 2019-06-30 728 35 12 8 8 47 852 48 50   24       974
2924 2924 LEHIGH VALLEY HOSPITAL - POCONO 206 EAST BROWN STREET EAST STROUDSBURG PA 18301 MONROE (570) 421-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.9922840 -75.1743270 0   89 42 42089 20700 New York-Newark, NY-NJ-CT-PA Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-bken-695p_8igj 390201 660019 2019-11-26 2019-06-30 173 12 12 8     205 20 12           237

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