Premises Licences In South Lakeland by UK Government | Finance and Economics

About this Dataset

Premises Licences In South Lakeland

Premises Licences in South Lakeland released as part of the open Data Incentive Scheme. includes Temporary event notices and Club premises certificates.

Dataset is formatted to comply with the Local Government Open Data Incentive Scheme Schema compliance – premises licences.

A full dataset version including the UPRNs derived from Ordnance Survey data can only be released for using the data to respond to, or interact with the Licensor to deliver or support the delivery of the Licensor’s Core Business due to OS licensing restrictions under a PSMA end user licence http://www.ordnancesurvey.co.uk/business-and-government/public-sector/mapping-agreements/end-user-licence.html. If you wish to use this data for any other purpose other than supporting the delivery of the Licensor’s Core Business, then you should contact Ordnance Survey via https://www.ordnancesurvey.co.uk/contact/ or telephone 03456 05 05 05 to discuss how they can help you with your requirements.
Publisher name: South Lakeland District Council
Last updated: 2024-09-14T17:49:57Z

Tables

Premises Licences In South Lakeland

@ukgov.premises_licences_in_south_lakeland.premises_licences_in_south_lakeland

1.37 MB
967 rows
37 columns


CREATE TABLE premises_licences_in_south_lakeland (
  "extractdate" VARCHAR,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "casereference" VARCHAR,
  "casedate" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "premisesname" VARCHAR,
  "locationtext" VARCHAR,
  "postcode" VARCHAR,
  "entertainmenttypeuri" VARCHAR,
  "entertainmenttypelabel" VARCHAR,
  "latenightrefreshment" VARCHAR,
  "alcoholsupply" VARCHAR,
  "openinghours" VARCHAR,
  "statusuri" VARCHAR,
  "statuslabel" VARCHAR,
  "licencestartdate" VARCHAR,
  "licenceenddate" VARCHAR,
  "onpremisesalcoholsale" VARCHAR,
  "offpremisesalcoholsale" VARCHAR,
  "licenceholder" VARCHAR,
  "licenceholderaddress" VARCHAR,
  "licenceholderpostcode" VARCHAR,
  "applicanttypeuri" VARCHAR,
  "applicanttypelabel" VARCHAR,
  "designatedpremisessupervisor" VARCHAR,
  "supervisorlicenceno" VARCHAR,
  "supervisoraddress" VARCHAR,
  "supervisorpostcode" VARCHAR,
  "conditions" VARCHAR,
  "decisiondate" VARCHAR,
  "decidedby" VARCHAR,
  "licenceurl" VARCHAR,
  "uprn" VARCHAR,
  "geopointlicensingurl" VARCHAR,
  "unnamed_36" VARCHAR
);

2019

@ukgov.premises_licences_in_south_lakeland.n_2019

1.39 MB
986 rows
36 columns


CREATE TABLE n_2019 (
  "extractdate" TIMESTAMP,
  "n__organisationuri" VARCHAR,
  "n__organisationlabel" VARCHAR,
  "n__casereference" VARCHAR,
  "n__casedate" TIMESTAMP,
  "n__servicetypeuri" VARCHAR,
  "n__servicetypelabel" VARCHAR,
  "n__premisesname" VARCHAR,
  "n__locationtext" VARCHAR,
  "n__postcode" VARCHAR,
  "n__entertainmenttypeuri" VARCHAR,
  "n__entertainmenttypelabel" VARCHAR,
  "n__latenightrefreshment" VARCHAR,
  "n__alcoholsupply" VARCHAR,
  "n__openinghours" VARCHAR,
  "n__statusuri" VARCHAR,
  "n__statuslabel" VARCHAR,
  "n__licencestartdate" VARCHAR,
  "n__licenceenddate" VARCHAR,
  "n__onpremisesalcoholsale" VARCHAR,
  "n__offpremisesalcoholsale" VARCHAR,
  "n__licenceholder" VARCHAR,
  "n__licenceholderaddress" VARCHAR,
  "n__licenceholderpostcode" VARCHAR,
  "n__applicanttypeuri" VARCHAR,
  "n__applicanttypelabel" VARCHAR,
  "n__designatedpremisessupervisor" VARCHAR,
  "n__supervisorlicenceno" VARCHAR,
  "n__supervisoraddress" VARCHAR,
  "supervisorpostcode" VARCHAR,
  "conditions" VARCHAR,
  "decisiondate" VARCHAR,
  "decidedby" VARCHAR,
  "licenceurl" VARCHAR,
  "n__uprn" VARCHAR,
  "n__geopointlicensingurl" VARCHAR
);