About this Dataset

Premises Licences In Ealing (Licensing Act 2003 Only)

Licensing Act 2003 licences issued for premises by the London Borough of Ealing eg public houses, off licences, take aways, cinemas etc. Includes all licences prior to the publication date and shows which have expired. Produced under the Local Government Association Open Data scheme.
Publisher name: London Borough of Ealing
Last updated: 2022-07-01T04:07:06Z

Tables

Premises Licences In Ealing (Licensing Act 2003 Only)

@ukgov.premises_licences_in_ealing.premises_licences_in_ealing_licensing_act_2003_only

1.53 MB
4718 rows
36 columns


CREATE TABLE premises_licences_in_ealing_licensing_act_2003_only (
  "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,
  "statusuri" VARCHAR,
  "statuslabel" 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
);