About this Dataset

Vaccination Rate By Zip Code Last Saturday In Jefferson County, KY Public

Provides weekly account of rate of first doses given to Jefferson County residents by zip code. ACS 2019 demographics are referenced in population counts and calculations.

Fieldname	Definition
Group_type	Currently, the group types are based on Age.
---	---
AG_12to18	Age group 12 to 18
AG_60	Age group 60+
AG_60to69	Age group 60 to 69
AG_70	Age group 70+
TOTAL	All ages

zipcode | zipcode of region where the recipient resides
WEEKENDINGDATE | Last full Week-ending date a dose was administered to the recipient
population_count | Estimated total population in the zipcode from the ref.Zip_ACS2019_AgeGroups table AG_12to18 leverages the Bridged-Race Population Estimates to use a factor of 0.70136413 * Zip_ACS2019_AgeGroups estimates to establish current population estimates for this age group.
Total_Dose_1 | number of recipients, to date, who received the first dose in the zipcode, by Group_type
Completed_Series | number of recipients, to date, who completed their vaccination series in the zipcode, by Group_type
Dose_1_rate_per100k | The number of recipients who received the first dose in zipcode per 100k, by Group_type Total_Dose_1*100000.0/ population_count
Completed_Series_rate_per100k | The number of recipients who received the first dose in zipcode per 100k, by Group_type (Total_JSN +Total_Dose_2)*100000.0/ population_count
LOADED | date the data was loaded into the system

Note: This data is preliminary, routinely updated, and is subject to change.

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.
Organization: Louisville Metro Government
Last updated: 2025-07-30T13:40:35.583095
Tags: coronavirus, covid-19, health, jefferson, ky, lmphw, lojic, louisville, modp, open-data, recently-added

Tables

Table 1

@usgov.louisville_metro_government_vaccination_rate_by_zip_co_2692e1bc.table_1

26.61 kB
236 rows
16 columns

CREATE TABLE table_1 (
  "objectid_1" BIGINT,
  "zipcode" BIGINT,
  "objectid" BIGINT,
  "group_type" VARCHAR,
  "zipcode_c77a44" BIGINT  -- Zipcode,
  "population_count" BIGINT,
  "total_dose_1" BIGINT,
  "completed_series" BIGINT,
  "dose_1_rate_per100k" DOUBLE,
  "completed_series_rate_per100k" DOUBLE,
  "loaded" VARCHAR,
  "shape_area" DOUBLE  -- Shape, Area,
  "shape_length" DOUBLE  -- Shape, Length,
  "weekendingdate" VARCHAR,
  "total_gp_booster" BIGINT,
  "gp_booster_percent" DOUBLE
);