Alcohol, Refreshment And Late Night Entertainment - Licence Applications Received

Leicester City Council

@ukgov.alcohol_refreshment_and_late_night_entertainment_licen_4c614727

Table List

1 table(11.17 KB)

Table 1

@ukgov.alcohol_refreshment_and_late_night_entertainment_licen_4c614727.table_1

Alcohol, Refreshment and Late Night Entertainment - Licence Applications Received (csv)

11.17 KB
29 rows
10 columns

date_received_from Date Received From	date_received_to Date Received To	type_of_application Type Of Application	process Process	date_of_application Date Of Application	premises_name Premises Name	premises_address Premises Address	first_name_of_applicant_licenceholder First Name Of Applicant Licenceholder	surname_or_company_name_of_applicant_licence_holder Surname Or Company Name Of Applicant Licence Holder	last_date_for_representations_grant_variation_review_m_0554606a Last Date For Representations Grant Variation Review Minor Variation Applications Only
Mon Oct 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Premises Licence WITH Alcohol	Change of Supervisor	Thu Oct 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	The Grand Union	3 - 5 New Walk		Marstons PLC
Mon Oct 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Premises Licence WITH Alcohol	Change of Supervisor	Thu Oct 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Off Licence - Co-op	249-259 Narborough Road		Central England Co-operative 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)	Premises Licence WITH Alcohol	Change of Supervisor	Thu Oct 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Off Licence - Iceland	273-275 Uppingham Road		Iceland Foods 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)	Premises Licence WITH Alcohol	Change of Supervisor	Thu Oct 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Fosseway Service Station	500 Melton Road		HKS Retail 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)	Premises Licence WITH Alcohol	Review of Licence/Certificate	Tue Oct 22 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Rum and Spice	2 King Street		Rum and Spice LTD	Tue Nov 19 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
Mon Oct 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Temporary Event Notice WITH Alcohol	Receipt of Temporary Event Notice	Tue Oct 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Turtle Bay Restaurants Limited	15 Bath House Lane	William David	Combellack
Mon Oct 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Temporary Event Notice WITH Alcohol	Receipt of Temporary Event Notice	Fri Oct 25 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Combine House	7 Woodboy Street	David	Hardware
Mon Oct 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Temporary Event Notice WITH Alcohol	Receipt of Temporary Event Notice	Wed Oct 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Warning Zone	30 Frog Island	Richard William	Grudgings
Mon Oct 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Temporary Event Notice WITH Alcohol	Receipt of Temporary Event Notice	Wed Oct 23 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Secret Garden Lounge	66 Braunstone Gate	Xhesika	Notaj
Mon Oct 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Temporary Event Notice WITH Alcohol	Receipt of Temporary Event Notice	Wed Oct 23 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Royal Standard	87 Charles Street	Bobbie	Law-Wilkins


CREATE TABLE table_1 (
  "date_received_from" TIMESTAMP,
  "date_received_to" TIMESTAMP,
  "type_of_application" VARCHAR,
  "process" VARCHAR,
  "date_of_application" TIMESTAMP,
  "premises_name" VARCHAR,
  "premises_address" VARCHAR,
  "first_name_of_applicant_licenceholder" VARCHAR,
  "surname_or_company_name_of_applicant_licence_holder" VARCHAR,
  "last_date_for_representations_grant_variation_review_m_0554606a" TIMESTAMP
);