COVID_AHA_Staffing

Data provided by Big Local News includes hospital staffing aggregated by U.S. metropolitan area and states. Compiled from the American Hospital Association (AHA) 2018 Annual Survey, the data provides counts for medical residents/interns, registered nurses, licensed practical nurses, respiratory therapists and some physicians. Please cite the data source as: American Hospital Association 2018 Annual Survey provided via Big Local News. See the README file for additional details and data definitions.

Data source: Big Local News · About: big-local-datasette

Custom SQL query

aha2018staffing_cbsa

CBSACODE, CBSANAME, hospitals, hospbeds, resid_ft, rn_ft, lpn_ft, resp_ft, tot_ft...

384 rows

aha2018staffing_state

STATECODE, STATENAME, hospitals, hospbeds, resid_ft, rn_ft, lpn_ft, resp_ft, tot_ft...

51 rows

pop2018_cbsa

CBSA_Code, CBSA_Title, MSAtype, pop2018_tot, pop2018_0to4, pop2018_5to9, pop2018_10to14, pop2018_15to19, pop2018_20to24...

926 rows

pop2018_state

STATECODE, STATE, pop2018_tot, pop2018_0to4, pop2018_5to9, pop2018_10to14, pop2018_15to19, pop2018_20to24, pop2018_25to29...

51 rows

Download SQLite DB: COVID_AHA_Staffing.db 184.0 KB

Powered by Datasette · Query took 6.055ms · Data source: Big Local News · About: big-local-datasette