| 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 |