Name: Licensed Premises
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

Licensed Premises

Premises Licenses and Club Premises Certificates issued by Swale Borough Council, published under the LG Inform Incentive Scheme, as at date published.
Publisher name: Swale Borough Council
Last updated: 2022-07-01T04:07:04Z

Tables

Licensed Premises

@ukgov.licensed_premises.licensed_premises

115.46 KB
796 rows
36 columns


CREATE TABLE licensed_premises (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "casereference" VARCHAR,
  "casedate" TIMESTAMP,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "premisesname" VARCHAR,
  "locationtext" VARCHAR,
  "postcode" VARCHAR,
  "entertainmenttypeuri" VARCHAR,
  "entertainmenttypelabel" VARCHAR,
  "latenightrefreshment" BOOLEAN,
  "alcoholsupply" BOOLEAN,
  "openinghours" VARCHAR,
  "statuslabel" VARCHAR,
  "statusuri" VARCHAR,
  "licencestartdate" TIMESTAMP,
  "licenceenddate" TIMESTAMP,
  "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" TIMESTAMP,
  "decidedby" VARCHAR,
  "licenceurl" VARCHAR,
  "uprn" VARCHAR,
  "geopointlicensingurl" VARCHAR
);