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 burn_beds = 16

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_ownership, geocode_flag, geocode_accuracy, statefips, filed_date, fy_end_date, coronary_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_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
192 192 UNIVERSITY MEDICAL CENTER 1800 W CHARLESTON BLVD LAS VEGAS NV 89102 CLARK (702) 383-2000 Acute Care Hospitals Government - Local TRUE 36.1589410 -115.1659450 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-crh9_6nqs_53ud 290007 662546 2019-11-29 2019-06-30 358 20 24 16 16 14 498               498
2365 2365 NORTH CAROLINA BAPTIST HOSPITAL MEDICAL CENTER BOULEVARD WINSTON-SALEM NC 27157 FORSYTH (336) 716-2011 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0896734 -80.2713468 1 GEOMETRIC_CENTER 67 37 37067 49180 Greensboro--Winston-Salem--High Point, NC Central Forsyth County https://data.medicare.gov/resource/xubh-q36u/row-r4e3-jftf~8jdf 340047 661763 2019-12-02 2019-06-30 565 110 22 16     797 34 39           870
2462 2462 UNIVERSITY MEDICAL CENTER NEW ORLEANS 2000 CANAL STREET NEW ORLEANS LA 70112 ORLEANS (504) 903-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.9610920 -90.0809100 0   71 22 22071 35380 New Orleans-Metairie-Hammond, LA-MS Central Orleans Parish https://data.medicare.gov/resource/xubh-q36u/row-hnr4.2w3s~mz8n 190005 655272 2019-10-04 2018-12-31 208 40   16     264 60             324
2560 2560 SAINT FRANCIS MEMORIAL HOSPITAL 900 HYDE ST SAN FRANCISCO CA 94109 SAN FRANCISCO (415) 353-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7895610 -122.4171120 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-qjay~rve8~yys3 50152 662020 2019-12-03 2019-06-30 122 18   16     156 35 20           211
3381 3381 CHI HEALTH ST ELIZABETH 555 SOUTH 70TH ST LINCOLN NE 68510 LANCASTER (402) 219-7700 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8076090 -96.6251790 0   109 31 31109 30700 Lincoln-Beatrice, NE Central Lancaster County https://data.medicare.gov/resource/xubh-q36u/row-dwnv_q2vi_cf6s 280020 659989 2019-12-02 2019-06-30 176 16   16   27 235               235
3432 3432 UNIVERSITY OF LOUISVILLE HOSPITAL 530 SOUTH JACKSON STREET LOUISVILLE KY 40202 JEFFERSON (502) 562-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.2484460 -85.7450700 0   111 21 21111 31140 Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-tgzi_ynfd~ifit 180141 655002 2019-10-01 2019-06-30 242 56 10 16     348               348
4749 4749 SENTARA NORFOLK GENERAL HOSPITAL 600 GRESHAM DR NORFOLK VA 23507 NORFOLK CITY (757) 388-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.8597280 -76.3048200 0   710 51 51710 47260 Virginia Beach-Norfolk, VA-NC Central Norfolk city https://data.medicare.gov/resource/xubh-q36u/row-r5z9-wxad_tcc7 490007 650916 2019-06-03 2018-12-31 381 44 10 16   20 471 34 22           527
4756 4756 MEDICAL COLLEGE OF VIRGINIA HOSPITALS BOX 980510 1250 EAST MARSHALL STREET RICHMOND VA 23298 RICHMOND CITY (804) 828-0938 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.5400695 -77.4299163 1 ROOFTOP 760 51 51760 40060   Central Richmond city https://data.medicare.gov/resource/xubh-q36u/row-p6wh~7aeu~ic6q 490032 659745 2019-11-25 2019-06-30 502 28 14 16 28   715 28 38           781

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