Baselight
Sign In

Alcohol, Refreshment And Late Night Entertainment - Licences Issued

Leicester City Council

@ukgov.alcohol_refreshment_and_late_night_entertainment_licen_d3d364c1

Table 1
@ukgov.alcohol_refreshment_and_late_night_entertainment_licen_d3d364c1.table_1

Alcohol, Refreshment and Late Night Entertainment - Licences Issued (csv)

  • 9.01 KB
  • 22 rows
  • 9 columns
date_issued_from

Date Issued From

date_issued_to

Date Issued To

licence_number

Licence Number

licence_type

Licence Type

application_type

Application Type

name_of_premises

Name Of Premises

address_of_premises

Address Of Premises

first_name_of_licence_holder

First Name Of Licence Holder

surname_company_name_of_licence_holder

Surname Company Name Of Licence Holder

Mon Oct 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)LEIPRM1827Premises Licence WITH AlcoholTransfer and DPS changeGreat Kathmandu2D/2E Herbert AvenueDawa FenchuLama
Mon Oct 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)LEIPRM0298Premises Licence WITH AlcoholTransfer ApplicationThe Friary12 Hotel StreetEi Group Ltd
Mon Oct 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)LEITNA4336Temporary Event Notice WITH AlcoholReceipt of Temporary Event NoticeSecret Garden Lounge66 Braunstone GateJulianOlaru
Mon Oct 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)LEITNA4335Temporary Event Notice WITH AlcoholReceipt of Temporary Event NoticeAbbey Park & GroundsAbbey Park & Grounds, Park HouseAnthonyNeedham
Mon Oct 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)LEITNA4337Temporary Event Notice WITH AlcoholReceipt of Temporary Event NoticeRoyal Standard87 Charles StreetBobbieLaw-Wilkins
Mon Oct 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)LEITNA4330Temporary Event Notice WITH AlcoholReceipt of Temporary Event NoticeAllexton & New Parks FCClub House, New CollegeCarlEwen
Mon Oct 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)LEIPRM0824Premises Licence WITH AlcoholChange of SupervisorSir Charles Napier46 Glenfield RoadCraft Union Pub Company Limited
Mon Oct 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)LEITNA4339Temporary Event Notice WITH AlcoholReceipt of Temporary Event NoticeShisha Cafe161 Belgrave GateJoanaDoci
Mon Oct 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)LEITNL1098Temporary Event Notice WITH Alcohol (LATE)Receipt of Temporary Event NoticeAbbey Park & GroundsAbbey Park & Grounds, Park HouseJackSeddon
Mon Oct 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)LEIPRM1318Premises Licence WITH AlcoholChange of SupervisorGate 5252a Braunstone GateSeanLander

CREATE TABLE table_1 (
  "date_issued_from" TIMESTAMP,
  "date_issued_to" TIMESTAMP,
  "licence_number" VARCHAR,
  "licence_type" VARCHAR,
  "application_type" VARCHAR,
  "name_of_premises" VARCHAR,
  "address_of_premises" VARCHAR,
  "first_name_of_licence_holder" VARCHAR,
  "surname_company_name_of_licence_holder" VARCHAR
);

Share link

Anyone who has the link will be able to view this.