Facts and Dimensions Ltd: US Covid19 Community Profile Report

Key indicators for all regions, states, core-based statistical areas (CBSAs), and counties across the US

Description:

The Community Profile Report (CPR) is generated by the Data Strategy and Execution Workgroup, under the White House COVID-19 Team. It is managed by an interagency team with representatives from multiple agencies and offices (including the United States Department of Health and Human Services, the Centers for Disease Control and Prevention, the Assistant Secretary for Preparedness and Response, and the Indian Health Service). The CPR provides easily interpretable information on key indicators for all regions, states, core-based statistical areas (CBSAs), and counties across the United States. It is a daily snapshot in time that:

– Focuses on recent COVID-19 outcomes in the last seven days and changes relative to the week prior
– Provides additional contextual information at the county, CBSA, state and regional levels
– Supports rapid visual interpretation of results with color thresholds*

Tables
– US_Covid19_CPR.Overview
– US_Covid19_CPR.Regions
– US_Covid19_CPR.Core_Based_Statistical_Area
– US_Covid19_CPR.Counties
– US_Covid19_CPR.National Peaks
– US_Covid19_CPR.National Historic

Fields
– County
– FIPS_Code
– County_Type
– Core_Based_Statistical_Area
– CBSA_Type
– State_Abbreviation
– Federal_Emergency_Management_Agency_Region
– Category
– Metric
– Metric_Value

Metrics include
– % Hispanic
– % hospital CCNs ever reporting utilization data
– % hospital CCNs reporting all utilization data at least once – last 7 days
– % hospital CCNs reporting any utilization data at least once – last 7 days
– % hospital CCNs reporting COVID-19 admissions at least once – last 7 days
– % In Poverty
– % inpatient beds occupied
– % inpatient beds occupied – absolute change
– % inpatient beds occupied by COVID-19 patient
– % inpatient beds occupied by COVID-19 patient – absolute change
– % Non-Hispanic Asian
– % Non-Hispanic Black
– % Non-Hispanic Native American / Alaskan Native
– % Non-Hispanic White
– % Over Age 65
– % staffed adult ICU beds occupied
– % staffed adult ICU beds occupied – absolute change
– % staffed adult ICU beds occupied by COVID-19 patient
– % staffed adult ICU beds occupied by COVID-19 patient – absolute change
– % tests resulted in 3 or fewer days – absolute change
– % tests resulted in 3 or fewer days – last 7 days
– % tests resulted in 3 or fewer days – previous 7 days
– % Uninsured
– % ventilators in use
– % ventilators in use – absolute change
– % ventilators in use by COVID-19 patient
– % ventilators in use by COVID-19 patient – absolute change
– Area of Concern Category
– Average household size
– Cases – % change
– Cases – last 7 days
– Cases – previous 7 days
– Cases as a percent of national total – last 7 days
– Cases as a percent of national total – previous 7 days
– Cases per 100k – last 7 days
– Cases per 100k – previous 7 days
– CCVI score
– Community Transmission Level – last 7 days
– Community Transmission Level – previous 7 days
– Confirmed COVID-19 admissions – last 7 days
– Confirmed COVID-19 admissions – percent change
– Confirmed COVID-19 admissions per 100 inpatient beds – last 7 days
– Cumulative cases
– Cumulative cases per 100k
– Cumulative deaths
– Cumulative deaths per 100k
– Deaths – % change
– Deaths – last 7 days
– Deaths – previous 7 days
– Deaths per 100k – last 7 days
– Deaths per 100k – previous 7 days
– Forecasted case trajectory
– IHE Full-time enrollment
– IHE Full-time enrollment as a percent of the population
– IHE with >5000 full-time enrollment
– Median test latency – last 7 days
– Median test latency – previous 7 days
– Number of days of downward case trajectory
– People initiating vaccination – last 7 days – ages 12+
– People initiating vaccination – last 7 days – ages 12-17
– People initiating vaccination – last 7 days – ages 18+
– People initiating vaccination – last 7 days – ages 65+
– People initiating vaccination as % of population – absolute change – ages 12+
– People initiating vaccination as % of population – absolute change – ages 12-17
– People initiating vaccination as % of population – absolute change – ages 18+
– People initiating vaccination as % of population – absolute change – ages 65+
– People initiating vaccination as % of population – last 7 days – ages 12+
– People initiating vaccination as % of population – last 7 days – ages 12-17
– People initiating vaccination as % of population – last 7 days – ages 18+
– People initiating vaccination as % of population – last 7 days – ages 65+
– People who are fully vaccinated
– People who are fully vaccinated – ages 12+
– People who are fully vaccinated – ages 12-17
– People who are fully vaccinated – ages 18+
– People who are fully vaccinated – ages 65+
– People who are fully vaccinated as % of population – ages 12+
– People who are fully vaccinated as % of population – ages 12-17
– People who are fully vaccinated as % of population – ages 18+
– People who are fully vaccinated as % of population – ages 65+
– People who are fully vaccinated as % of total population
– People with at least 1 dose
– People with at least 1 dose – ages 12+
– People with at least 1 dose – ages 12-17
– People with at least 1 dose – ages 18+
– People with at least 1 dose – ages 65+
– People with at least 1 dose as % of population – ages 12+
– People with at least 1 dose as % of population – ages 12-17
– People with at least 1 dose as % of population – ages 18+
– People with at least 1 dose as % of population – ages 65+
– People with at least 1 dose as % of total population
– Population
– Population as a percent of CBSA
– Population as a percent of national population
– Population as a percent of state
– Rapid rise (last 14 days)
– Rapid Riser Category
– RT-PCR tests per 100k – last 7 days (may be an underestimate due to delayed reporting)
– RT-PCR tests per 100k – previous 7 days (may be an underestimate due to delayed reporting)
– Suspected COVID-19 admissions – last 7 days
– Suspected COVID-19 admissions per 100 inpatient beds – last 7 days
– SVI score
– Testing latency – absolute change
– Total # of hospital CCNs
– Total inpatient beds among hospitals reporting – last 7 days
– Total RT-PCR diagnostic tests – % change (may be an underestimate due to delayed reporting)
– Total RT-PCR diagnostic tests – last 7 days (may be an underestimate due to delayed reporting)
– Total RT-PCR diagnostic tests – previous 7 days (may be an underestimate due to delayed reporting)
– Total staffed adult ICU beds among hospitals reporting – last 7 days
– Total ventilators among hospitals reporting – last 7 days
– Viral (RT-PCR) lab test positivity rate – absolute change (may be an underestimate due to delayed reporting)
– Viral (RT-PCR) lab test positivity rate – last 7 days (may be an underestimate due to delayed reporting)
– Viral (RT-PCR) lab test positivity rate – previous 7 days (may be an underestimate due to delayed reporting)

About the Provider:

Widest available single source of UK health statistics and reference data. In use by most of the NHS, including NHS England, and many other organisations.

All datasets are updated the same day as publication. Some within 30 minutes.

We use a very extensive testing regime and test scripting to ensure the absolute highest quality and reliable data. We do not simply scrape websites and copy data into tables. The data we load is checked for its integrity, the date etc. We have good contacts with the data providers and regularly keep in touch when data quality issues are found so they can be fixed.

Extensive forum for all paying customers.

Visit the provider’s website for more information

Get access to the Facts and Dimensions Ltd: US Covid19 Community Profile Report Dataset in Snowflake

Sign up for a free trial

Already a Snowflake customer?
Access this dataset directly from your Snowflake account