Louisville Metro KY - ABC License Endorsements
Louisville Metro Government
@usgov.louisville_metro_government_louisville_metro_ky_abc_li_1a20614d
Loading...
Loading...
Loading...
Loading...
About this Dataset
Louisville Metro KY - ABC License Endorsements
Metro ABC Licensing Division staff administrates and issues Louisville Metro's Specialties License & Permits as related to alcohol beverage control.
This data currently feeds the Louisville Metro KY- ABC Licenses map
| Field Name | Field Description |
|---|---|
| LicenseNO | License Number - the unique identifier issued by Louisville Metro Government |
| LicenseStatus | License Status |
| LicenseType | License Type as defined by the Director of ABC and used to determine appropriate licensing fees. |
| EXPIRATION_DATE | The date the license will expire |
| LicenseCat | License Category - e.g. Bar, Restaurant, Retailer |
| BusinessName | Name of the business or Doing Business As (DBA) |
| Address | Location covered by the license |
| LATITUDE | |
| LONGITUDE | |
| PRCLID | Parcel Id |
| CouncilDist | Council District |
| EndorsmentRow_Index | Number used to sort out the number of endorsements associated with the license number |
| EndorsementType | Endorsement Type - closely matches to the State ABC license type. |
| EndorsementStatus | Endorsement Status |
| ClosingTime | Closing Time - 0 = 12AM, 2 = 2AM, 4 = 4AM |
| Organization: Louisville Metro Government | |
| Last updated: 2025-07-30T14:13:54.542343 | |
| Tags: abc, jefferson, jefferson-county, kentucky, license, louisville, louisville-metro, louisville-metro-ky, modp, open-data, recent_odp, updated-weekly |
Tables
Table 1
@usgov.louisville_metro_government_louisville_metro_ky_abc_li_1a20614d.table_1
- 212.01 kB
- 4,537 rows
- 18 columns
Loading...
Loading...
CREATE TABLE table_1 (
"licenseno" VARCHAR,
"licensestatus" VARCHAR,
"licensetype" VARCHAR,
"expiration_date" VARCHAR,
"licensecat" VARCHAR,
"businessname" VARCHAR,
"address" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"prclid" VARCHAR,
"councildist" DOUBLE,
"endorsmentrow_index" DOUBLE,
"endorsementtype" VARCHAR,
"endorsementstatus" VARCHAR,
"closingtime" BIGINT,
"objectid" BIGINT,
"x" DOUBLE,
"y" DOUBLE
);