Back to Recent Schemas

Schema Information

http://schemas.esd.org.uk/premiseslicences/PremisesLicences.json

Download schema

Fields

Index Column Heading Required Unique Type Value Constraints Title/Description
1 ExtractDate Yes No String Pattern: (^([0-2]\d|[3][0-1])\/([0]\d|[1][0-2])\/[1-2]\d{3}((\s([0-1]\d|[2][0-3]):[0-5]\d(:[0-5]\d)?)?)|)$
Extract Date
The date that the data was last extracted from its source database
2 OrganisationURI Yes No URI Organisation URI
URI from OpenDataCommunities of organisation (eg local authority) responsible for the case
3 OrganisationLabel Yes No String Organisation Label
Label of Organisation URI
4 CaseReference Yes No String Case Reference
Licence number - Number allocated to licence when issued. Null before issued. Same licence might apply to multiple entries to give a history
5 CaseDate Yes No String Pattern: (^([0-2]\d|[3][0-1])\/([0]\d|[1][0-2])\/[1-2]\d{3}((\s([0-1]\d|[2][0-3]):[0-5]\d(:[0-5]\d)?)?)|)$
Case Date
Licence issue date. Null before issued
6 ServiceTypeURI Yes No URI Service Type URI
Premises related licence type. One of premises licence, club premises certificate, temporary event notice. One LGSL service type for each of these as given by the Service URI from http://id.esd.org.uk/list/services
7 ServiceTypeLabel Yes No String Service Type Label
Label of the Service Type URI
8 PremisesName Yes No String Premises Name
Name of licenced premises
9 LocationText Yes No String Location Text
Address of licenced premises
10 Postcode Yes No String Postcode
Only empty if premises have no post code (eg field for an event)
11 EntertainmentTypeURI Yes No String Entertainment Type URI
List of 8 types of entertainment activity defined on application form: plays, films, indoor sporting events, boxing or wrestling entertainment, live music, recorded music, performances of dance, anything of a similar description to that falling within the previous three
12 EntertainmentTypeLabel Yes No String Entertainment Type Label
Label of the Entertainment Type URI
13 LateNightRefreshment Yes No String Pattern: (true|True|TRUE|false|False|FALSE|yes|Yes|YES|no|No|NO)
Late Night Refreshment
Flag to indicate whether the licence allows late night refreshment
14 AlcoholSupply Yes No String Pattern: (true|True|TRUE|false|False|FALSE|yes|Yes|YES|no|No|NO)
Alcohol Supply
Flag to indicate whether the licence allows alcohol to be supplied
15 OpeningHours Yes No String Opening Hours
Opening hours (eg two opening periods per day) by day of week, opening time & closing time for each entertainment type + late night refreshment + supply of alcohol
16 StatusURI Yes No URI Status URI
Status of application/licence (eg new, current, expired, refused etc.)
17 StatusLabel Yes No String Status Label
Label of the StatusURI
18 LicenceStartDate Yes No String Pattern: (^([0-2]\d|[3][0-1])\/([0]\d|[1][0-2])\/[1-2]\d{3}((\s([0-1]\d|[2][0-3]):[0-5]\d(:[0-5]\d)?)?)|)$
Licence Start Date
Date on which the licence starts
19 LicenceEndDate Yes No String Pattern: (^([0-2]\d|[3][0-1])\/([0]\d|[1][0-2])\/[1-2]\d{3}((\s([0-1]\d|[2][0-3]):[0-5]\d(:[0-5]\d)?)?)|)$
Licence End Date
Date on which the licence ends. For temporary event notice or where requested on other types.
20 OnPremisesAlcoholSale Yes No String Pattern: (true|True|TRUE|false|False|FALSE|yes|Yes|YES|no|No|NO|)
On Premises Alcohol Sale
Flag to indicate whether the licence allows alcohol to be sold on the premises
21 OffPremisesAlcoholSale Yes No String Pattern: (true|True|TRUE|false|False|FALSE|yes|Yes|YES|no|No|NO|)
Off Premises Alcohol Sale
Flag to indicate whether the licence allows alcohol to be sold off the premises
22 LicenceHolder Yes No String Licence Holder
Pipe separated list of names of individuals or businesses which hold the licence
23 LicenceHolderAddress Yes No String Licence Holder Address
Pipe separated list of addresses of individuals or businesses which hold licence. Blank unless address differs from premises address.
24 LicenceHolderPostcode Yes No String Licence Holder Postcode
Pipe separated list of postcodes of individuals or businesses which hold licence. Blank unless address differs from premises address.
25 ApplicantTypeURI Yes No URI Applicant Type URI
Type of licence (individual, business, club etc. List defined on application form)
26 ApplicantTypeLabel Yes No String Applicant Type Label
Label of ApplicantTypeURI
27 DesignatedPremisesSupervisor Yes No String Designated Premises Supervisor
Name of designated premises supervisor (for alcohol licence)
28 SupervisorLicenceNo Yes No String Supervisor Licence No
Personal licence number of designated supervisor
29 SupervisorAddress Yes No String Supervisor Address
Address of designated premises supervisor
30 SupervisorPostcode Yes No String Pattern: (^([A-PR-UWYZ0-9][A-HK-Y0-9][AEHMNPRTVXY0-9]?[ABEHMNPRVWXY0-9]? {1,2}[0-9][ABD-HJLN-UW-Z]{2}|GIR 0AA)$|)
Supervisor Postcode
Postcode of designated premises supervisor
31 Conditions Yes No String Conditions
Conditions attached to issuing of a licence
32 DecisionDate Yes No String Pattern: (^([0-2]\d|[3][0-1])\/([0]\d|[1][0-2])\/[1-2]\d{3}((\s([0-1]\d|[2][0-3]):[0-5]\d(:[0-5]\d)?)?)|)$
Decision Date
Date licence granted/refused
33 DecidedBy Yes No String Decided By
Name of officer making decision on application
34 LicenceURL Yes No URI Licence URL
URL to further information, including opening hours and license type
35 UPRN Yes No String UPRN
Unique Property Reference Number
36 GeoPointLicensingURL Yes No String Geo Point Licensing URL
URL of any page that describes any licensing restrictions on using UPRN values
Download Example CSV File