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.
Complete Metadata
| @type | dcat:Dataset |
|---|---|
| accessLevel | public |
| bureauCode |
[
"010:04",
"010:86"
]
|
| contactPoint |
{
"fn": "LouisvilleMetro",
"@type": "vcard:Contact",
"hasEmail": "mailto:opendata@louisvilleky.gov"
}
|
| culture | |
| description | <div style='margin:0px; padding:0px 7px;'></div><p><span style='margin:0px; padding:0px;'><b>This data set is no longer being updated and is historical, last update 10/10/2022.</b></span></p><p><span style='margin:0px; padding:0px;'>A summary of reported data from CTT.</span><span style='margin:0px; padding:0px;'> This data includes:</span><span style='margin:0px; padding:0px;'> </span><span style='margin:0px; padding:0px;'>Daily counts as reported on the Re</span><span style='margin:0px; padding:0px;'>ference</span><span style='margin:0px; padding:0px;'> Date for </span><span style='margin:0px; padding:0px;'>Confirmed, Deceased, Recovered</span><span style='margin:0px; padding:0px;'>. </span><span style='margin:0px; padding:0px;'> </span><span style='margin:0px; padding:0px;'>Total counts as reported on the Re</span><span style='margin:0px; padding:0px;'>ference</span><span style='margin:0px; padding:0px;'> Date. </span><span style='margin:0px; padding:0px;'>Statistical data is based on the data as reported on the </span><span style='margin:0px; padding:0px;'>Reference Date</span><span style='margin:0px; padding:0px;'> (</span><span style='margin:0px; padding:0px;'>Counts per 100k pop</span><span style='margin:0px; padding:0px;'>ulation (201</span><span style='margin:0px; padding:0px;'>9</span><span style='margin:0px; padding:0px;'> ACS)</span><span style='margin:0px; padding:0px;'>, and </span><span style='margin:0px; padding:0px;'>3-day</span><span style='margin:0px; padding:0px;'> average rates</span><br /></p><p style='margin-bottom:0.0001pt; background-image:initial; background-position:initial; background-size:initial; background-repeat:initial; background-attachment:initial; background-origin:initial; background-clip:initial;'> </p><table border='1' cellpadding='0' cellspacing='0' style='width:0in; margin-left:-.75pt; border-collapse:collapse;' width='0'> <tbody><tr> <td style='width:2.75in; border:solid windowtext 1.0pt; padding:0in 0in 0in 0in;' valign='top' width='264'> <p>Fieldname </p> </td> <td style='width:4.75in; border:solid windowtext 1.0pt; border-left:none; padding:0in 0in 0in 0in;' valign='top' width='456'> <p>Definition </p> </td> </tr> <tr> <td style='width:2.75in; border:solid windowtext 1.0pt; border-top:none; padding:0in 0in 0in 0in;' valign='top' width='264'> <p>reported </p> </td> <td style='width:4.75in; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 0in 0in 0in;' valign='top' width='456'> <p>Reference date </p> <p>-For Confirmed cases, before CTT, use loaded date </p> <p>-For Confirmed cases, after CTT, use yesterday’s date </p> </td> </tr> <tr> <td style='width:2.75in; border:solid windowtext 1.0pt; border-top:none; padding:0in 0in 0in 0in;' valign='top' width='264'> <p>CONFIRMED </p> </td> <td style='width:4.75in; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 0in 0in 0in;' valign='top' width='456'> <p>Number of new confirmed cases reported on reference date </p> </td> </tr> <tr> <td style='width:2.75in; border:solid windowtext 1.0pt; border-top:none; padding:0in 0in 0in 0in;' valign='top' width='264'> <p>TOTAL_CONFIRMED </p> </td> <td style='width:4.75in; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 0in 0in 0in;' valign='top' width='456'> <p>Number of all confirmed cases reported on reference date </p> </td> </tr> <tr> <td style='width:2.75in; border:solid windowtext 1.0pt; border-top:none; padding:0in 0in 0in 0in;' valign='top' width='264'> <p>DECEASED </p> </td> <td style='width:4.75in; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 0in 0in 0in;' valign='top' width='456'> <p>Number of cases newly marked as Deceased reported on reference date </p> </td> </tr> <tr> <td style='width:2.75in; border:solid windowtext 1.0pt; border-top:none; padding:0in 0in 0in 0in;' valign='top' width='264'> <p>TOTAL_DECEASED</p> </td> <td style='width:4.75in; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 0in 0in 0in;' valign='top' width='456'> <p>Number of all cases marked as Deceased reported on reference date</p> </td> </tr> <tr> <td style='width:2.75in; border:solid windowtext 1.0pt; border-top:none; padding:0in 0in 0in 0in;' valign='top' width='264'> <p>RECOVERED </p> </td> <td style='width:4.75in; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 0in 0in 0in;' valign='top' width='456'> <p>Number of cases newly marked recovered reported on reference date </p> </td> </tr> <tr> <td style='width:2.75in; border:solid windowtext 1.0pt; border-top:none; padding:0in 0in 0in 0in;' valign='top' width='264'> <p>TOTAL_RECOVERED</p> </td> <td style='width:4.75in; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 0in 0in 0in;' valign='top' width='456'> <p>Number of all cases marked recovered reported on reference date</p> </td> </tr> <tr> <td style='width:2.75in; border:solid windowtext 1.0pt; border-top:none; padding:0in 0in 0in 0in;' valign='top' width='264'> <p>WEEKBEGINNINGDATE</p> </td> <td style='width:4.75in; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 0in 0in 0in;' valign='top' width='456'> <p>The week beginning date for the Reported date </p> </td> </tr> <tr> <td style='width:2.75in; border:solid windowtext 1.0pt; border-top:none; padding:0in 0in 0in 0in;' valign='top' width='264'> <p>WEEKENDINGDATE</p> </td> <td style='width:4.75in; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 0in 0in 0in;' valign='top' width='456'> <p>The week ending date for the Reported date </p> </td> </tr> <tr> <td style='width:2.75in; border:solid windowtext 1.0pt; border-top:none; padding:0in 0in 0in 0in;' valign='top' width='264'> <p>YEAR_WEEK</p> </td> <td style='width:4.75in; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 0in 0in 0in;' valign='top' width='456'> <p>Year and week number of the Reported date </p> </td> </tr> <tr> <td style='width:2.75in; border:solid windowtext 1.0pt; border-top:none; padding:0in 0in 0in 0in;' valign='top' width='264'> <p>Total_Population</p> </td> <td style='width:4.75in; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 0in 0in 0in;' valign='top' width='456'> <p>Estimated total population from the ref.ACS2019_demographics table </p> </td> </tr> <tr> <td style='width:2.75in; border:solid windowtext 1.0pt; border-top:none; padding:0in 0in 0in 0in;' valign='top' width='264'> <p>Confirmed_RatePer100K</p> </td> <td style='width:4.75in; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 0in 0in 0in;' valign='top' width='456'> <p>Number of confirmed cases per 100K. CONFIRMED*100000.0/Total_Population</p> </td> </tr> <tr> <td style='width:2.75in; border:solid windowtext 1.0pt; border-top:none; padding:0in 0in 0in 0in;' valign='top' width='264'> <p>Deceased_RatePer100K </p> </td> <td style='width:4.75in; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 0in 0in 0in;' valign='top' width='456'> <p>Number of cases marked as Deceased per 100K. DECEASED*100000.0/Total_Population</p> </td> </tr> <tr> <td style='width:2.75in; border:solid windowtext 1.0pt; border-top:none; padding:0in 0in 0in 0in;' valign='top' width='264'> <p>Avg_3Day_Confirmed_RatePer100K</p> </td> <td style='width:4.75in; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 0in 0in 0in;' valign='top' width='456'> <p>Average of the Confirmed_RatePer100K for the current day and the 2 previous days. </p> </td> </tr> <tr> <td style='width:2.75in; border:solid windowtext 1.0pt; border-top:none; padding:0in 0in 0in 0in;' valign='top' width='264'> <p>Avg_3Day_Deceased_RatePer100K</p> </td> <td style='width:4.75in; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 0in 0in 0in;' valign='top' width='456'> <p>Average of the Deceased_RatePer100K for the current day and the 2 previous days. </p> </td> </tr> <tr> <td style='width:2.75in; border:solid windowtext 1.0pt; border-top:none; padding:0in 0in 0in 0in;' valign='top' width='264'> <p>Avg_3Day_Confirmed_RatePer100K_Diff </p> </td> <td style='width:4.75in; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 0in 0in 0in;' valign='top' width='456'> <p>Difference between the Avg_3Day_Confirmed_RatePer100K of the current day and previous day. </p> </td> </tr> <tr> <td style='width:2.75in; border:solid windowtext 1.0pt; border-top:none; padding:0in 0in 0in 0in;' valign='top' width='264'> <p>Avg_3Day_Deceased_RatePer100K_Diff </p> </td> <td style='width:4.75in; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 0in 0in 0in;' valign='top' width='456'> <p>Difference between the Avg_3Day_ Deceased_RatePer100K of the current day and previous day. </p> </td> </tr> <tr> <td style='width:2.75in; border:solid windowtext 1.0pt; border-top:none; padding:0in 0in 0in 0in;' valign='top' width='264'> <p>LOADED </p> </td> <td style='width:4.75in; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 0in 0in 0in;' valign='top' width='456'> <p>Date the data was loaded into the system </p> </td> </tr> </tbody></table> <p style='text-align:center; margin-bottom:0.0001pt; background-image:initial; background-position:initial; background-size:initial; background-repeat:initial; background-attachment:initial; background-origin:initial; background-clip:initial;'><br /></p><p style='margin-bottom:0.0001pt; background-image:initial; background-position:initial; background-size:initial; background-repeat:initial; background-attachment:initial; background-origin:initial; background-clip:initial;'>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.<br /></p><p style='margin-bottom:0.0001pt; background-image:initial; background-position:initial; background-size:initial; background-repeat:initial; background-attachment:initial; background-origin:initial; background-clip:initial;'><br /></p><p style='margin-bottom:0.0001pt; background-image:initial; background-position:initial; background-size:initial; background-repeat:initial; background-attachment:initial; background-origin:initial; background-clip:initial;'><span style='margin:0px; padding:0px;'><span style='margin:0px; padding:0px;'></span></span></p><p style='margin-bottom:0.0001pt; background-image:initial; background-position:initial; background-size:initial; background-repeat:initial; background-attachment:initial; background-origin:initial; background-clip:initial;'>Note: This data is preliminary, routinely updated, and is subject to change.<br /></p> |
| distribution |
[
{
"@type": "dcat:Distribution",
"title": "CSV",
"format": "CSV",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/1998f3ed1f5e48cf89451062bb58c509/csv?layers=0",
"mediaType": "text/csv"
},
{
"@type": "dcat:Distribution",
"title": "Excel",
"format": "XLSX",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/1998f3ed1f5e48cf89451062bb58c509/excel?layers=0",
"mediaType": "application/vnd.ms-excel"
},
{
"@type": "dcat:Distribution",
"title": "Feature Collection",
"format": "TXT",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/1998f3ed1f5e48cf89451062bb58c509/featureCollection?layers=0",
"mediaType": "text/plain"
},
{
"@type": "dcat:Distribution",
"title": "File Geodatabase",
"format": "ZIP",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/1998f3ed1f5e48cf89451062bb58c509/filegdb?layers=0",
"mediaType": "application/zip"
},
{
"@type": "dcat:Distribution",
"title": "GeoPackage",
"format": "GPKG",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/1998f3ed1f5e48cf89451062bb58c509/geoPackage?layers=0",
"mediaType": "application/geopackage+sqlite3"
},
{
"@type": "dcat:Distribution",
"title": "GeoJSON",
"format": "GeoJSON",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/1998f3ed1f5e48cf89451062bb58c509/geojson?layers=0",
"mediaType": "application/vnd.geo+json"
},
{
"@type": "dcat:Distribution",
"title": "KML",
"format": "KML",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/1998f3ed1f5e48cf89451062bb58c509/kml?layers=0",
"mediaType": "application/vnd.google-earth.kml+xml"
},
{
"@type": "dcat:Distribution",
"title": "Shapefile",
"format": "ZIP",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/1998f3ed1f5e48cf89451062bb58c509/shapefile?layers=0",
"mediaType": "application/zip"
},
{
"@type": "dcat:Distribution",
"title": "SQLite Geodatabase",
"format": "GDB",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/1998f3ed1f5e48cf89451062bb58c509/sqlite?layers=0",
"mediaType": "application/geopackage+sqlite3"
},
{
"@type": "dcat:Distribution",
"title": "ArcGIS Hub Dataset",
"format": "Web Page",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/datasets/LOJIC::covid-19-daily-case-count-in-jefferson-county-ky",
"mediaType": "text/html"
},
{
"@type": "dcat:Distribution",
"title": "ArcGIS GeoService",
"format": "ArcGIS GeoServices REST API",
"accessURL": "https://services1.arcgis.com/79kfd2K6fskCAkyg/arcgis/rest/services/Reported_Counts/FeatureServer/0",
"mediaType": "application/json"
}
]
|
| identifier | https://www.arcgis.com/home/item.html?id=1998f3ed1f5e48cf89451062bb58c509&sublayer=0 |
| issued | 2020-10-26T01:11:25.000Z |
| keyword |
[
"COVID-19",
"Coronavirus",
"Health",
"Historical",
"Jefferson",
"KY",
"LOJIC",
"Louisville",
"MODP",
"Open Data",
"Popular",
"Recently Added"
]
|
| landingPage | https://louisville-metro-opendata-lojic.hub.arcgis.com/datasets/LOJIC::covid-19-daily-case-count-in-jefferson-county-ky |
| license | https://louisville-metro-opendata-lojic.hub.arcgis.com/pages/terms-of-use-and-license |
| modified | 2024-05-23T15:45:09.561Z |
| platform | ArcGIS Hub |
| programCode |
[
"015:001",
"015:002"
]
|
| publisher |
{
"name": "Louisville/Jefferson County Information Consortium"
}
|
| spatial | {{extent:computeSpatialProperty}} |
| summary | A summary of reported data from Contract Tracing and Tracking (CTT). |
| theme |
[
"geospatial"
]
|
| title | COVID-19 Daily Case Count in Jefferson County, KY |