Premises Licences In South Lakeland

South Lakeland District Council

@ukgov.premises_licences_in_south_lakeland

Table List

2 tables(2.77 MB)

2019

2019

@ukgov.premises_licences_in_south_lakeland.n_2019

1.39 MB
986 rows
36 columns

extractdate ExtractDate	n__organisationuri OrganisationURI	n__organisationlabel OrganisationLabel	n__casereference CaseReference	n__casedate CaseDate	n__servicetypeuri ServiceTypeURI	n__servicetypelabel ServiceTypeLabel	n__premisesname PremisesName	n__locationtext LocationText	n__postcode Postcode	n__entertainmenttypeuri EntertainmentTypeURI	n__entertainmenttypelabel EntertainmentTypeLabel	n__latenightrefreshment LateNightRefreshment	n__alcoholsupply AlcoholSupply	n__openinghours OpeningHours	n__statusuri StatusURI	n__statuslabel StatusLabel	n__licencestartdate LicenceStartDate	n__onpremisesalcoholsale OnPremisesAlcoholSale	n__offpremisesalcoholsale OffPremisesAlcoholSale	n__licenceholder LicenceHolder	n__licenceholderaddress LicenceHolderAddress	n__licenceholderpostcode LicenceHolderPostcode	n__designatedpremisessupervisor DesignatedPremisesSupervisor	n__supervisorlicenceno SupervisorLicenceNo	n__supervisoraddress SupervisorAddress	supervisorpostcode SupervisorPostcode	conditions Conditions	decisiondate DecisionDate	decidedby DecidedBy	licenceurl LicenceURL	n__geopointlicensingurl GeoPointLicensingURL
Thu Jan 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/district-council/south-lakeland	South Lakeland	PL(N)0077	Tue Jan 21 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	http://id.esd.org.uk/service/860	Premises Licence	Silver Moon	39 Main Street Kirkby Lonsdale Cumbria	LA6 2AH			TRUE	FALSE	Tues 17:00-23:00,Weds 17:00-23:00,Thurs 17:00-23:00,Fri 17:00-00:00,Sat 17:00-00:00,Sun 17:00-23:00	http://id.esd.org.uk/premisesLicenceStatus/13	Issued	24/11/2005	FALSE	FALSE	Mr Chun Ming Chung	Silver Moon 39 Main Street Kirkby Lonsdale Cumbria	LA6 2AH	Not Required		Silver Moon 39 Main Street Kirkby Lonsdale Cumbria	LA6 2AH		21/01/2014	Emma Ette	http://applications.southlakeland.gov.uk/LicensingRegister/Licensing/Default/Premises	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
Thu Jan 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/district-council/south-lakeland	South Lakeland	PL(A)0060	Thu Oct 13 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	http://id.esd.org.uk/service/860	Premises Licence	The Bluebird Cafe by the Lake	The Blue Bird Cafe by the Lake Lake Road Coniston Cumbria	LA21 8AN			FALSE	TRUE		http://id.esd.org.uk/premisesLicenceStatus/13	Issued	24/11/2005	TRUE	TRUE	Mr Philip Derek Dixon	The Bluebird Cafe by the LakeThe Blue Bird Cafe by the Lake Lake Road Coniston Cumbria	LA21 8AN	Mr Philip Derek Dixon	PA0125	The Bluebird Cafe by the LakeThe Blue Bird Cafe by the Lake Lake Road Coniston Cumbria	LA21 8AN	Annex 1 Restaurant Licence - Mandatory conditions 1_ _Alcohol may be sold or supplied: a)_ _On weekdays; other than Christmas Day; Good Friday or New YearÆs Eve from 10 a.m. to 12 midnight. b)_ _On Sundays; other than Christmas Day; or New YearÆs Eve a nd Good Friday; from 12 noon to 11.30 p.m. c…	13/10/2005		http://applications.southlakeland.gov.uk/LicensingRegister/Licensing/Default/Premises	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
Thu Jan 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/district-council/south-lakeland	South Lakeland	PL(N)0011	Tue Nov 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	http://id.esd.org.uk/service/860	Premises Licence	Urswick Recreation Hall (c/o Mr M Rogers - Chairman)	c/o Mr M Rogers 2 Greenbank Gardens Ulverston Cumbria	LA12 0RN	http://id.esd.org.uk/entertainment/5\|http://id.esd.org.uk/entertainment/6\|http://id.esd.org.uk/entertainment/7	Live music\|Recorded music\|Performances of dance	FALSE	FALSE		http://id.esd.org.uk/premisesLicenceStatus/13	Issued	24/11/2005	FALSE	FALSE	Mr Michael Rogers	Urswick Recreation Hall (c/o Mr M Rogers - Chairman)c/o Mr M Rogers 2 Greenbank Gardens Ulverston Cumbria	LA12 0RN	Not Required		Urswick Recreation Hall (c/o Mr M Rogers - Chairman)c/o Mr M Rogers 2 Greenbank Gardens Ulverston Cumbria	LA12 0RN	Annex 1 Public Entertainment Licence - E119 Urswick Recreation Hall Occupancy Rates:- _ __ __ __ __ __ __ _Dance Informal/Closely Seated - Total not to exceed Closely Seated Audience_ __ __ __ __ __ __ _200_ __ _200 Disco Functions - One row periphe ral Seating 250_ __ __ __ _250 Us…	01/11/2005		http://applications.southlakeland.gov.uk/LicensingRegister/Licensing/Default/Premises	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
Thu Jan 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/district-council/south-lakeland	South Lakeland	PL(N)0034	Tue Nov 08 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	http://id.esd.org.uk/service/860	Premises Licence	Ulverston Parish Church Centre	Church Walk Ulverston Cumbria	LA12 7EN	http://id.esd.org.uk/entertainment/3\|http://id.esd.org.uk/entertainment/4\|http://id.esd.org.uk/entertainment/5\|http://id.esd.org.uk/entertainment/6\|http://id.esd.org.uk/entertainment/7\|http://id.esd.org.uk/entertainment/8	Indoor sporting events\|Boxing or wrestling\|Live music\|Recorded music\|Performances of dance\|Similar to music or dance	FALSE	FALSE		http://id.esd.org.uk/premisesLicenceStatus/13	Issued	24/11/2005	FALSE	FALSE	Reverend Alan Charles Bing	Ulverston Parish Church Centre Church Walk Ulverston Cumbria	LA12 7EN	Not Required		Ulverston Parish Church Centre Church Walk Ulverston Cumbria	LA12 7EN	Annex 1 Public Entertainment Licence - E040 Ulverston Parish Centre Occupancy Rates:- Area_ __ __ _Dance Informal_ _Closely Seated_ _Total not to Exceed Balcony_ __ __ __ __ _102_ __ __ _102 _ _ Conference Area_ __ __ __ _158_ __ __ _158 _ _ See att ached conditions for Public Entertainment L…	08/11/2005		http://applications.southlakeland.gov.uk/LicensingRegister/Licensing/Default/Premises	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
Thu Jan 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/district-council/south-lakeland	South Lakeland	PL(A)0063	Thu Oct 13 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	http://id.esd.org.uk/service/860	Premises Licence	Deja Vu in Kendal	124 Stricklandgate Kendal Cumbria	LA9 4QG			FALSE	TRUE		http://id.esd.org.uk/premisesLicenceStatus/13	Issued	24/11/2005	TRUE	TRUE	Mrs Frances Mary Wood	Deja Vu in Kendal 124 Stricklandgate Kendal Cumbria	LA9 4QG	Mrs Frances Mary Wood	PA0139	Deja Vu in Kendal 124 Stricklandgate Kendal Cumbria	LA9 4QG	Annex 1 Restaurant Licence - Mandatory conditions 1_ _Alcohol may be sold or supplied: a)_ _On weekdays; other than Christmas Day; Good Friday or New YearÆs Eve from 10 a.m. to 12 midnight. b)_ _On Sundays; other than Christmas Day; or New YearÆs Eve a nd Good Friday; from 12 noon to 11.30 p.m. c…	13/10/2005		http://applications.southlakeland.gov.uk/LicensingRegister/Licensing/Default/Premises	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
Thu Jan 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/district-council/south-lakeland	South Lakeland	PL(A)0018	Mon Oct 10 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	http://id.esd.org.uk/service/860	Premises Licence	Chocolat In Kirkby Lonsdale	3 New Road Kirkby Lonsdale Cumbria	LA6 2AB			FALSE	TRUE		http://id.esd.org.uk/premisesLicenceStatus/13	Issued	24/11/2005	FALSE	TRUE	Mr Robin William Sadler	Chocolat In Kirkby Lonsdale 3 New Road Kirkby Lonsdale Cumbria	LA6 2AB	Mr Robin William Sadler	PA0047	Chocolat In Kirkby Lonsdale 3 New Road Kirkby Lonsdale Cumbria	LA6 2AB	Annex 1 Off Licence - Mandatory conditions 1_ _Alcohol shall not be sold or supplied except during permitted hours. In this condition; permitted hours means: a)_ _On weekdays; other than Christmas Day; 8 a.m. to 11 p.m. b)_ _On Sundays; other than on Christmas Day; 10 a.m. to 10.30 p.m. c)_ _On …	10/10/2005		http://applications.southlakeland.gov.uk/LicensingRegister/Licensing/Default/Premises	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
Thu Jan 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/district-council/south-lakeland	South Lakeland	PL(A)0648	Mon Apr 10 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	http://id.esd.org.uk/service/860	Premises Licence	Butterfingers	Butterfingers Main Street Grange Over Sands Cumbria	LA11 6DP			TRUE	TRUE		http://id.esd.org.uk/premisesLicenceStatus/13	Issued	24/11/2005	TRUE	FALSE	Mr Kenneth Airey	ButterfingersButterfingers Main Street Grange Over Sands Cumbria	LA11 6DP	Mr Philip Richard Airey	PA0972	ButterfingersButterfingers Main Street Grange Over Sands Cumbria	LA11 6DP	Annex 1 Restaurant Licence - Mandatory conditions 1_ _Alcohol may be sold or supplied: a)_ _On weekdays; other than Christmas Day; Good Friday or New YearÆs Eve from 10 a.m. to 12 midnight. b)_ _On Sundays; other than Christmas Day; or New YearÆs Eve a nd Good Friday; from 12 noon to 11.30 p.m. c…	10/04/2006		http://applications.southlakeland.gov.uk/LicensingRegister/Licensing/Default/Premises	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
Thu Jan 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/district-council/south-lakeland	South Lakeland	PL(N)0042	Tue Nov 15 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	http://id.esd.org.uk/service/860	Premises Licence	YWCA	95 Stricklandgate Kendal Cumbria	LA9 4RA	http://id.esd.org.uk/entertainment/5\|http://id.esd.org.uk/entertainment/6\|http://id.esd.org.uk/entertainment/7	Live music\|Recorded music\|Performances of dance	FALSE	FALSE		http://id.esd.org.uk/premisesLicenceStatus/13	Issued	24/11/2005	FALSE	FALSE	Ms Ann Nelson	YWCA 95 Stricklandgate Kendal Cumbria	LA9 4RA	Not Required		YWCA 95 Stricklandgate Kendal Cumbria	LA9 4RA	Annex 1 Public Entertainment Licence - E053 - YWCA Occupancy Rates:- Area_ __ __ _Dance Informal_ _Closely Seated_ _Total not to Exceed With tables_ __ __ __ __ _120_ __ __ _120 Without tabes_ __ _200_ __ __ __ __ __ _200 See attached conditions f or Public Entertainment Licences.	15/11/2005		http://applications.southlakeland.gov.uk/LicensingRegister/Licensing/Default/Premises	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
Thu Jan 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/district-council/south-lakeland	South Lakeland	PL(N)0029	Thu Nov 03 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	http://id.esd.org.uk/service/860	Premises Licence	Mill Room	Broughton Beck Ulverston	LA12	http://id.esd.org.uk/entertainment/3\|http://id.esd.org.uk/entertainment/4\|http://id.esd.org.uk/entertainment/5\|http://id.esd.org.uk/entertainment/6\|http://id.esd.org.uk/entertainment/7\|http://id.esd.org.uk/entertainment/8	Indoor sporting events\|Boxing or wrestling\|Live music\|Recorded music\|Performances of dance\|Similar to music or dance	FALSE	FALSE		http://id.esd.org.uk/premisesLicenceStatus/13	Issued	24/11/2005	FALSE	FALSE	Ms Lorna Elizabeth Wilkinson	Mill Room Broughton Beck Ulverston	LA12	Not Required		Mill Room Broughton Beck Ulverston	LA12	Annex 1 Public Entertainment Licence - E209 Mill Room Occupancy; Capacity and Seating Rates 1. It is recommended that the maximum number of persons allowed in the premises for public entertainment purposes is restricted as follows: a)_ _For a functio n with tables and chairs_ _70 persons b) _ …	03/11/2005		http://applications.southlakeland.gov.uk/LicensingRegister/Licensing/Default/Premises	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
Thu Jan 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/district-council/south-lakeland	South Lakeland	PL(A)0241	Thu Nov 10 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	http://id.esd.org.uk/service/860	Premises Licence	Ees Wyke Country House	Ees Wyke Country House Near Sawrey Ambleside Cumbria	LA22 0JZ			TRUE	TRUE		http://id.esd.org.uk/premisesLicenceStatus/13	Issued	24/11/2005	TRUE	FALSE	Mr Richard Lee	Ees Wyke Country HouseEes Wyke Country House Near Sawrey Ambleside Cumbria	LA22 0JZ	Mr Richard Lee	PA0836	Ees Wyke Country HouseEes Wyke Country House Near Sawrey Ambleside Cumbria	LA22 0JZ	Annex 1 Restaurant Licence - Mandatory conditions 1_ _Alcohol may be sold or supplied: a)_ _On weekdays; other than Christmas Day; Good Friday or New YearÆs Eve from 10 a.m. to 12 midnight. b)_ _On Sundays; other than Christmas Day; or New YearÆs Eve a nd Good Friday; from 12 noon to 11.30 p.m. c…	10/11/2005		http://applications.southlakeland.gov.uk/LicensingRegister/Licensing/Default/Premises	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/


CREATE TABLE n_2019 (
  "extractdate" TIMESTAMP,
  "n__organisationuri" VARCHAR,
  "n__organisationlabel" VARCHAR,
  "n__casereference" VARCHAR,
  "n__casedate" TIMESTAMP,
  "n__servicetypeuri" VARCHAR,
  "n__servicetypelabel" VARCHAR,
  "n__premisesname" VARCHAR,
  "n__locationtext" VARCHAR,
  "n__postcode" VARCHAR,
  "n__entertainmenttypeuri" VARCHAR,
  "n__entertainmenttypelabel" VARCHAR,
  "n__latenightrefreshment" VARCHAR,
  "n__alcoholsupply" VARCHAR,
  "n__openinghours" VARCHAR,
  "n__statusuri" VARCHAR,
  "n__statuslabel" VARCHAR,
  "n__licencestartdate" VARCHAR,
  "n__licenceenddate" VARCHAR,
  "n__onpremisesalcoholsale" VARCHAR,
  "n__offpremisesalcoholsale" VARCHAR,
  "n__licenceholder" VARCHAR,
  "n__licenceholderaddress" VARCHAR,
  "n__licenceholderpostcode" VARCHAR,
  "n__applicanttypeuri" VARCHAR,
  "n__applicanttypelabel" VARCHAR,
  "n__designatedpremisessupervisor" VARCHAR,
  "n__supervisorlicenceno" VARCHAR,
  "n__supervisoraddress" VARCHAR,
  "supervisorpostcode" VARCHAR,
  "conditions" VARCHAR,
  "decisiondate" VARCHAR,
  "decidedby" VARCHAR,
  "licenceurl" VARCHAR,
  "n__uprn" VARCHAR,
  "n__geopointlicensingurl" VARCHAR
);