Louisville Metro KY - ABC Licenses
Louisville Metro Government
@usgov.louisville_metro_government_louisville_metro_ky_abc_licenses
Loading...
Loading...
Loading...
Loading...
About this Dataset
Louisville Metro KY - ABC Licenses
Metro ABC Licensing Division staff administrates and issues Louisville Metro's Specialties License & Permits as related to alcohol beverage control.
Data Dictionary
| Field Name | Field Description |
|---|---|
| LicenseNO | License Number |
| LicenseCat | License Category e.g. Bar, Restaurant |
| LicenseType | License Type |
| EXPDTTM | Expiration Date |
| BusinessName | Business Name |
| Address | Address of Business |
| GPSX | Longitude |
| GPSY | Latitude |
| ENDRSTATUS | Value = 1 |
| PRCLID | Parcel ID |
| LicStatus | License Status |
| DESCRIPT | Value = 1 |
| CouncilDist | Louisville Metro Council District |
| MAXLicenseHours | Maximum ABC license Hour. 0 = Midnight, 2 = 2AM, 4 =4AM |
| Authorized Public Consumption (Commercial Quadricycle Permit Required) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| Bottling House | Endorsement Type: Blank = Not licensed and Active = Licensed |
| Brewer's License | Endorsement Type: Blank = Not licensed and Active = Licensed |
| Caterer's License | Endorsement Type: Blank = Not licensed and Active = Licensed |
| Distiller | Endorsement Type: Blank = Not licensed and Active = Licensed |
| Extended Hours Supplemental | Endorsement Type: Blank = Not licensed and Active = Licensed |
| License & Permit Amendment | Endorsement Type: Blank = Not licensed and Active = Licensed |
| Liquor 50 Chairs (70% Food) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| Malt Beverage Distributor | Endorsement Type: Blank = Not licensed and Active = Licensed |
| Microbrewery | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ Retail Malt Bev Combo (Beer by the Package and Drink) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ Retail Malt Package (12-2am) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ Retail Malt Package (Beer by the package) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ1 Retail Drink (Auto Race Track) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ1 Retail Drink (Convention Center or Center) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ1 Retail Drink (Horse Race Track) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ2 Retail Drink (12to2am) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ2 Retail Drink (12to4am) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ2 Retail Drink (Airport) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ2 Retail Drink (Motel) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ2 Retail Drink (Restaurant) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ2 Retail Drink (Retail Distillery Drink) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ2 Retail Drink (River Boat) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ3 Private Club 12to2 | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ3 Private Club 12to4 | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ3 Retail Drink (Bed & Breakfast) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ3 Retail Drink (Distillery) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ3 Retail Drink (Private Club) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ3 Supplemental Bar (Bed & Breakfast) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ3 Supplemental Bar (Distillery) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ3 Supplemental Bar (Private Club) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ4 Retail Malt Beverage Drink (Beer by the drink. No food sales requirements) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ4 Retail Malt Drink 12to2 | Endorsement Type: Blank = Not licensed and Active = Licensed |
| NQ4 Retail Malt Drink 12to4 | Endorsement Type: Blank = Not licensed and Active = Licensed |
| Qualified Historic Site | Endorsement Type: Blank = Not licensed and Active = Licensed |
| Quota Retail Drink 12to2 | Endorsement Type: Blank = Not licensed and Active = Licensed |
| Quota Retail Drink 12to4 | Endorsement Type: Blank = Not licensed and Active = Licensed |
| Quota Retail Drink (Liquor and Wine. No food sales requirements) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| Quota Retail Package 12to2 | Endorsement Type: Blank = Not licensed and Active = Licensed |
| Quota Retail Package (Liquor and Wine by the package) | Endorsement Type: Blank = Not licensed and Active = Licensed |
| Rectifier's License | Endorsement Type: Blank = Not licensed and Active = Licensed |
| Sunday Retail Drink | Endorsement Type: Blank = Not licensed and Active = Licensed |
| Supplemental Bar | Endorsement Type: Blank = Not licensed and Active = Licensed |
| Wholesaler | Endorsement Type: Blank = Not licensed and Active = Licensed |
| Organization: Louisville Metro Government | |
| Last updated: 2025-07-30T13:32:29.220636 | |
| Tags: abc, codes-and-regs, codes-and-regulations, jefferson, jefferson-county, kentucky, license, louisville, louisville-metro, louisville-metro-ky, modp, open-data, updated-weekly |
Tables
Table 1
@usgov.louisville_metro_government_louisville_metro_ky_abc_licenses.table_1
- 195.29 kB
- 1,648 rows
- 61 columns
Loading...
Loading...
CREATE TABLE table_1 (
"licenseno" VARCHAR,
"licensecat" VARCHAR,
"licensetype" VARCHAR,
"expdttm" VARCHAR,
"businessname" VARCHAR,
"address" VARCHAR,
"gpsx" DOUBLE,
"gpsy" DOUBLE,
"endrstatus" BIGINT,
"prclid" VARCHAR,
"licstatus" VARCHAR,
"descript" BIGINT,
"councildist" DOUBLE,
"maxlicensehours" DOUBLE,
"authorized_public_consumption_commercial_quadricycle_p_4f752e09" VARCHAR -- Authorized Public Consumption (Commercial Quadricycle Permit Required),
"bottling_house" VARCHAR,
"brewer_s_license" VARCHAR,
"caterer_s_license" VARCHAR,
"distiller" VARCHAR,
"extended_hours_supplemental" VARCHAR,
"license_permit_amendment" VARCHAR -- License & Permit Amendment,
"liquor_50_chairs_70_food" VARCHAR -- Liquor 50 Chairs (70% Food),
"malt_beverage_distributor" VARCHAR,
"microbrewery" VARCHAR,
"nq_retail_malt_bev_combo_beer_by_the_package_and_drink" VARCHAR -- NQ Retail Malt Bev Combo (Beer By The Package And Drink),
"nq_retail_malt_package_12_2am" VARCHAR -- NQ Retail Malt Package (12-2am),
"nq_retail_malt_package_beer_by_the_package" VARCHAR -- NQ Retail Malt Package (Beer By The Package),
"nq1_retail_drink_auto_race_track" VARCHAR -- NQ1 Retail Drink (Auto Race Track),
"nq1_retail_drink_convention_center_or_center" VARCHAR -- NQ1 Retail Drink (Convention Center Or Center),
"nq1_retail_drink_horse_race_track" VARCHAR -- NQ1 Retail Drink (Horse Race Track),
"nq2_retail_drink_12to2am" VARCHAR -- NQ2 Retail Drink (12to2am),
"nq2_retail_drink_12to4am" VARCHAR -- NQ2 Retail Drink (12to4am),
"nq2_retail_drink_airport" VARCHAR -- NQ2 Retail Drink (Airport),
"nq2_retail_drink_motel" VARCHAR -- NQ2 Retail Drink (Motel),
"nq2_retail_drink_restaurant" VARCHAR -- NQ2 Retail Drink (Restaurant),
"nq2_retail_drink_retail_distillery_drink" VARCHAR -- NQ2 Retail Drink (Retail Distillery Drink),
"nq2_retail_drink_river_boat" VARCHAR -- NQ2 Retail Drink (River Boat),
"nq3_private_club_12to2" VARCHAR,
"nq3_private_club_12to4" VARCHAR,
"nq3_retail_drink_bed_breakfast" VARCHAR -- NQ3 Retail Drink (Bed & Breakfast),
"nq3_retail_drink_distillery" VARCHAR -- NQ3 Retail Drink (Distillery),
"nq3_retail_drink_private_club" VARCHAR -- NQ3 Retail Drink (Private Club),
"nq3_supplemental_bar_bed_breakfast" VARCHAR -- NQ3 Supplemental Bar (Bed & Breakfast),
"nq3_supplemental_bar_distillery" VARCHAR -- NQ3 Supplemental Bar (Distillery),
"nq3_supplemental_bar_private_club" VARCHAR -- NQ3 Supplemental Bar (Private Club),
"nq4_retail_malt_beverage_drink_beer_by_the_drink_no_fo_470904aa" VARCHAR -- NQ4 Retail Malt Beverage Drink (Beer By The Drink. No Food Sales Requirements),
"nq4_retail_malt_drink_12to2" VARCHAR,
"nq4_retail_malt_drink_12to4" VARCHAR,
"qualified_historic_site" VARCHAR,
"quota_retail_drink_12to2" VARCHAR,
"quota_retail_drink_12to4" VARCHAR,
"quota_retail_drink_liquor_and_wine_no_food_sales_requirements" VARCHAR -- Quota Retail Drink (Liquor And Wine. No Food Sales Requirements),
"quota_retail_package_12to2" VARCHAR,
"quota_retail_package_liquor_and_wine_by_the_package" VARCHAR -- Quota Retail Package (Liquor And Wine By The Package),
"rectifier_s_license" VARCHAR,
"sunday_retail_drink" VARCHAR,
"supplemental_bar" VARCHAR,
"wholesaler" VARCHAR,
"objectid" BIGINT,
"x" DOUBLE,
"y" DOUBLE
);