COVID-19 Daily Case Count In Jefferson County, KY by US Government | Healthcare

About this Dataset

COVID-19 Daily Case Count In Jefferson County, KY

This data set is no longer being updated and is historical, last update 10/10/2022.

A summary of reported data from CTT. This data includes: Daily counts as reported on the Reference Date for Confirmed, Deceased, Recovered. Total counts as reported on the Reference Date. Statistical data is based on the data as reported on the Reference Date (Counts per 100k population (2019 ACS), and 3-day average rates

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

For questions about this data please contact Angela Graham (Angela.Graham@louisvilleky.gov) or YuTing Chen (YuTing.Chen@louisvilleky.gov) or call (502) 574-8279.

Note: This data is preliminary, routinely updated, and is subject to change.
Organization: Louisville Metro Government
Last updated: 2023-04-13T13:24:27.508985
Tags: coronavirus, covid-19, health, historical, jefferson, ky, lojic, louisville, modp, open-data, popular, recently-added

Tables

Table 1

@usgov.louisville_metro_government_covid_19_daily_case_count__3f3da880.table_1

74.47 KB
911 rows
19 columns


CREATE TABLE table_1 (
  "avg_3day_confirmed_rateper100k" DOUBLE,
  "avg_3day_confirmed_rateper100k_diff" DOUBLE,
  "avg_3day_deceased_rateper100k" DOUBLE,
  "avg_3day_deceased_rateper100k_diff" DOUBLE,
  "confirmed" BIGINT,
  "confirmed_rateper100k" DOUBLE,
  "deceased" BIGINT,
  "deceased_rateper100k" DOUBLE,
  "loaded" VARCHAR,
  "recovered" BIGINT,
  "reported" VARCHAR,
  "total_confirmed" BIGINT,
  "total_deceased" BIGINT,
  "total_population" BIGINT,
  "total_recovered" BIGINT,
  "weekbeginningdate" VARCHAR,
  "weekendingdate" VARCHAR,
  "year_week" BIGINT,
  "objectid" BIGINT
);