About this Dataset

Premises Licences

Premises Licences. *Please note that the data published within this dataset is a live API link to CYC's GIS server. Any changes made to the master copy of the data will be immediately reflected in the resources of this dataset.The date shown in the "Last Updated" field of each GIS resource reflects when the data was first published.
Publisher name: City of York Council
Last updated: 2024-09-14T14:52:38Z

Tables

Premises Licences

@ukgov.premises_licences1.premises_licences

96.62 KB
1026 rows
41 columns


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