TWBC Open Data Licensed Premises - 2022

Tunbridge Wells Borough Council

@ukgov.twbc_open_data_licensed_premises_2022

Table List

1 table(40.37 KB)

Table 1

@ukgov.twbc_open_data_licensed_premises_2022.table_1

40.37 KB
507 rows
13 columns

extraction_date Extraction Date	name_of_premises Name Of Premises	licence_number Licence Number	reference_url Reference URL	application_received Application Received	validation_date Validation Date	status Status	fid FID
Fri Oct 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	P & D News	15/01789/LAPRE	https://pa.sevenoaks.gov.uk/online-licensing/licencingDetails.do?activeTab=summary&keyVal=NPMISFTT02Q00	Mon Jun 08 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Aug 13 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Issued	1
Fri Oct 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	The Star Inn	15/01751/LAPRE	https://pa.sevenoaks.gov.uk/online-licensing/licencingDetails.do?activeTab=summary&keyVal=NPFCP5TT01K00	Thu Jun 04 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 05 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Issued	2
Fri Oct 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sucheera Thai Restaurant	15/01634/LAPRE	https://pa.sevenoaks.gov.uk/online-licensing/licencingDetails.do?activeTab=summary&keyVal=NP22NYTT01K00	Thu May 28 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu May 28 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Issued	3
Fri Oct 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Five Guys	22/03773/LAPMV	https://pa.sevenoaks.gov.uk/online-licensing/licencingDetails.do?activeTab=summary&keyVal=RJADHOTT04K00	Wed Oct 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Oct 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Outstanding consultations	4
Fri Oct 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Velo House (The)	15/01327/LAPRE	https://pa.sevenoaks.gov.uk/online-licensing/licencingDetails.do?activeTab=summary&keyVal=NNVEC7TT01O00	Tue May 05 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue May 05 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Suspended	5
Fri Oct 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Horsmonden Social Club	15/00850/LACPC	https://pa.sevenoaks.gov.uk/online-licensing/licencingDetails.do?activeTab=summary&keyVal=NLIE9PTT02Q00	Fri Mar 20 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 19 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Issued	6
Fri Oct 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	One Stop	15/00806/LAPMV	https://pa.sevenoaks.gov.uk/online-licensing/licencingDetails.do?activeTab=summary&keyVal=NLCSF3TT01K00	Tue Mar 17 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Mar 18 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Issued	7
Fri Oct 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Chimera Climbing	15/00712/LAPRE	https://pa.sevenoaks.gov.uk/online-licensing/licencingDetails.do?activeTab=summary&keyVal=NKY1DTTT01O00	Mon Mar 09 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 13 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Issued	8
Fri Oct 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sissinghurst Cricket Club	15/00689/LACMV	https://pa.sevenoaks.gov.uk/online-licensing/licencingDetails.do?activeTab=summary&keyVal=NKSGQ9TT01K00	Fri Mar 06 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 12 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Issued	9
Fri Oct 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Royal Express	22/03715/LAPMV	https://pa.sevenoaks.gov.uk/online-licensing/licencingDetails.do?activeTab=summary&keyVal=RJ6JI1TT04F00	Mon Oct 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Oct 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Outstanding consultations	10


CREATE TABLE table_1 (
  "extraction_date" TIMESTAMP,
  "council" VARCHAR,
  "ward_description" VARCHAR,
  "name_of_premises" VARCHAR,
  "licence_number" VARCHAR,
  "reference_url" VARCHAR,
  "application_received" TIMESTAMP,
  "validation_date" TIMESTAMP,
  "public_notice_start_date" VARCHAR,
  "public_notice_end_date" VARCHAR,
  "representations" BIGINT,
  "status" VARCHAR,
  "fid" BIGINT
);