COVID-19 Daily Case Count in Jefferson County, KY

Fieldname  

Definition  

reported 

Reference date 

-For Confirmed cases, before CTT, use loaded date 

-For Confirmed cases, after CTT, use yesterday’s date 

CONFIRMED 

Number of new confirmed cases reported on reference date 

TOTAL_CONFIRMED 

Number of all confirmed cases reported on reference date 

DECEASED 

Number of cases newly marked as Deceased reported on reference date 

TOTAL_DECEASED

Number of all cases marked as Deceased reported on reference date

RECOVERED 

Number of cases newly marked recovered reported on reference date 

TOTAL_RECOVERED

Number of all cases marked recovered reported on reference date

WEEKBEGINNINGDATE

The week beginning date for the Reported date 

WEEKENDINGDATE

The week ending date for the Reported date 

YEAR_WEEK

Year and week number of the Reported date 

Total_Population

Estimated total population from the ref.ACS2019_demographics table 

Confirmed_RatePer100K

Number of confirmed cases per 100K. CONFIRMED*100000.0/Total_Population

Deceased_RatePer100K 

Number of cases marked as Deceased per 100K. DECEASED*100000.0/Total_Population

Avg_3Day_Confirmed_RatePer100K

Average of the Confirmed_RatePer100K for the current day and the 2 previous days. 

Avg_3Day_Deceased_RatePer100K

Average of the Deceased_RatePer100K for the current day and the 2 previous days. 

Avg_3Day_Confirmed_RatePer100K_Diff 

Difference between the Avg_3Day_Confirmed_RatePer100K of the current day and previous day. 

Avg_3Day_Deceased_RatePer100K_Diff 

Difference between the Avg_3Day_ Deceased_RatePer100K of the current day and previous day. 

LOADED  

Date the data was loaded into the system