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

About this Dataset

Licensed Premises

Data showing all the licensed premises in Plymouth.
Publisher name: Plymouth City Council
Last updated: 2022-07-01T04:05:34Z

Tables

Licensed Premises - Plymouth 2016

@ukgov.licensed_premises_in_plymouth.licensed_premises_plymouth_2016

62.33 KB
1024 rows
15 columns


CREATE TABLE licensed_premises_plymouth_2016 (
  "extractdate" TIMESTAMP,
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "casereference" VARCHAR,
  "casedate" TIMESTAMP,
  "licencestartdate" TIMESTAMP,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "premisesname" VARCHAR,
  "locationtext" VARCHAR,
  "postcode" VARCHAR,
  "latenightrefreshment" BOOLEAN,
  "alcoholsupply" BOOLEAN,
  "statusuri" VARCHAR,
  "statuslabel" VARCHAR
);