About this Dataset

Licences

This dataset shows premises Licences, club premises certificates and temporary event notices. Local Government Association/Open Data Institute ------------------------------------------------ * Leeds City Council is participating in a scheme run by the LGA and ODI to standardise datasets from local authorities. Public toilets, premises licences, and planning datasets have been identified first to pilot this scheme. Please note: This dataset is no longer being kept up to date and is available via our other licensing publications. Please follow this link: https://datamillnorth.org/dataset?q=licence&format;=xml
Publisher name: Leeds City Council
Last updated: 2024-09-14T09:29:23Z

Tables

25/09/2015

@ukgov.licences1.n_25_09_2015

1.51 MB
23,579 rows
37 columns

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