DataShare - Our data. Free for all.

Data sharing from London Borough of Hounslow

Go Back View Hounslow Premises Licences More info

Home View - choose a category Environmental services Hounslow Premises Licences

Search for a dataset:

Scroll left Scroll right

Help

Views:

Table Column Bar Line Pie

Download

AlcoholSupply ApplicantTypeLabel ApplicantTypeURI CaseDate CaseReference Conditions DecidedBy DecisionDate DesignatedPremisesSupervisor EntertainmentTypeLabel EntertainmentTypeURI ExtractDate GeoPointLicensingURL LateNightRefreshment LicenceEndDate LicenceHolder LicenceHolderAddress LicenceHolderPostcode LicenceStartDate LicenceURL LocationText OffPremisesAlcoholSale OnPremisesAlcoholSale OpeningHours OrganisationLabel OrganisationURI Postcode PremisesName ServiceTypeLabel ServiceTypeURI StatusLabel StatusURI SupervisorAddress SupervisorLicenceNo SupervisorPostcode UPRN

contains is equal to

greater than greater than or equal to less than less than or equal to is equal to

 from   to 

Edit columns

• AlcoholSupply
• ApplicantTypeLabel
• ApplicantTypeURI
• CaseDate
• CaseReference
• Conditions
• DecidedBy
• DecisionDate
• DesignatedPremisesSupervisor
• EntertainmentTypeLabel
• EntertainmentTypeURI
• ExtractDate
• GeoPointLicensingURL
• LateNightRefreshment
• LicenceEndDate
• LicenceHolder
• LicenceHolderAddress
• LicenceHolderPostcode
• LicenceStartDate
• LicenceURL
• LocationText
• OffPremisesAlcoholSale
• OnPremisesAlcoholSale
• OpeningHours
• OrganisationLabel
• OrganisationURI
• Postcode
• PremisesName
• ServiceTypeLabel
• ServiceTypeURI
• StatusLabel
• StatusURI
• SupervisorAddress
• SupervisorLicenceNo
• SupervisorPostcode
• UPRN

OrganisationLabel	OrganisationURI	CaseReference	CaseDate	ServiceTypeLabel	ServiceTypeURI	PremisesName	LocationText	EntertainmentTypeLabel	EntertainmentTypeURI	LateNightRefreshment	AlcoholSupply	OpeningHours	StatusLabel	StatusURI	LicenceStartDate	LicenceEndDate	OnPremisesAlcoholSale	OffPremisesAlcoholSale	LicenceHolder	LicenceHolderAddress	LicenceHolderPostcode	ApplicantTypeLabel	ApplicantTypeURI	DesignatedPremisesSupervisor	SupervisorLicenceNo	SupervisorAddress	SupervisorPostcode	Conditions	DecisionDate	DecidedBy	LicenceURL	UPRN	GeoPointLicensingURL	ExtractDate	Postcode
Hounslow	View	N/A	N/A	Premises licence	View	Baber Bridge Grocers	1-2 Baber Bridge Parade, Hounslow Road	N/A	N/A	No	Yes	Monday to Sunday, 06:00 to 24:00	Issued	View	01/01/2015	N/A	N/A	N/A	Mr KuldIp Singh Bains	1-2 Baber Bridge Parade, Hounslow Road	TW14 0HP	N/A	N/A	Mr KuldIp Singh Bains	Personal Licence No. 00305, issued by LB Hounslow	1-2 Baber Bridge Parade, Hounslow Road	TW14 0HP	N/A	N/A	N/A	N/A	N/A	N/A	20/03/2015	TW14 0HP
Hounslow	View	N/A	N/A	Premises licence	View	Cromwell Stores	82 Cromwell Road	N/A	N/A	No	No	Unrestricted	Issued	View	01/01/2015	N/A	N/A	N/A	Mr Charan Singh Gulati	256 North Hyde Lane	UB2 4LS	N/A	N/A	Mr Paramjit Singh Grover	Personal Licence No: 00193, Issued by LB Ealing	12 St Mary's Avenue	UB2 4LS	N/A	N/A	N/A	N/A	N/A	N/A	20/03/2015	TW3 3QJ
Hounslow	View	N/A	N/A	Premises licence	View	Martindale Super Stores	75 Martindale Road	N/A	N/A	No	No	Unrestricted	Issued	View	01/01/2015	N/A	N/A	N/A	Mr Vikneswaran Mahadevan	14 Nonsuch Close	IG6 2RZ	N/A	N/A	Mr Balasingham Balaranjan	Personal Licence No. 00185, issued by LB Hounslow	22 Adelaide Road	TW5 9AG	N/A	N/A	N/A	N/A	N/A	N/A	20/03/2015	TW4 7EW
Hounslow	View	N/A	N/A	Premises licence	View	Mahar Convenience Store	164 Hanworth Road	N/A	N/A	No	No	Unrestricted	Issued	View	01/01/2015	N/A	N/A	N/A	Mr Kulbir Singh	27 Beach Grove	TW13 5QY	N/A	N/A	Mr Kulbir Singh	Personal Licence No. 00125, issued by LB Hounslow	27 Beach Grove	TW13 5QY	N/A	N/A	N/A	N/A	N/A	N/A	20/03/2015	TW3 3TR
Hounslow	View	N/A	N/A	Premises licence	View	Feltham Wines	104 High Street	N/A	N/A	No	No	Unrestricted	Issued	View	01/01/2015	N/A	N/A	N/A	Mr Mayilvaganam Thayabalan	22 Winkley Court, Eastcote Lane	HA2 8RT	N/A	N/A	Mr Mayilvaganam Thayabalan	Personal Licence No. 05MT-00AQ-JAK4-NMW4, issued by Harrow Council	27 Winkley Court	HA2 8RT	N/A	N/A	N/A	N/A	N/A	N/A	20/03/2015	TW13 4EX
Hounslow	View	N/A	N/A	Premises licence	View	SPS News Londis	164 Bedfont Lane	N/A	N/A	No	No	Unrestricted	Issued	View	01/01/2015	N/A	N/A	N/A	Mr Balasingham Sivapalarajah	164 Bedfont Lane	TW14 9NJ	N/A	N/A	Mr Balasingham Sivapalarajah	Personal Licence No. 00140, issued by LB Hounslow	164 Bedfont Lane	TW14 9NJ	N/A	N/A	N/A	N/A	N/A	N/A	20/03/2015	TW14 9NJ
Hounslow	View	N/A	N/A	Premises licence	View	Kings Wines	487 Staines Road	N/A	N/A	No	No	Unrestricted	Issued	View	01/01/2015	N/A	N/A	N/A	Mr Gursahib Singh Sandhu	2 Gould Road	TW14 8AB	N/A	N/A	Mr Gursahib Singh Sandhu	Personal Licence No. 00235, issued by LB Hounslow	2 Gould Road	TW14 8AB	N/A	N/A	N/A	N/A	N/A	N/A	20/03/2015	TW14 8BN
Hounslow	View	N/A	N/A	Premises licence	View	Southville Stores	252 Bedfont Lane	N/A	N/A	No	No	Unrestricted	Issued	View	01/01/2015	N/A	N/A	N/A	Mr Rajakeethan Pathmanathan & Miss Visithra Pathmanathan	68 Keatsway	UB6 9HF	N/A	N/A	Mr Rajakeethan Pathmanathan	Personal Licence No: 00147, Issued by LB Ealing	68 Keatsway	UB6 9HF	N/A	N/A	N/A	N/A	N/A	N/A	20/03/2015	TW14 9NU
Hounslow	View	N/A	N/A	Premises licence	View	Daily Needs	91 Whitton Road	N/A	N/A	No	No	Unrestricted	Issued	View	01/01/2015	N/A	N/A	N/A	Surbir Singh Arora	91 Whitton Road	TW3 2EH	N/A	N/A	Mr Surbir Arora	Personal licence No.01115 Issued by LB hounslow	20 Saxon House Saxon Ave	TW13 5Th	N/A	N/A	N/A	N/A	N/A	N/A	20/03/2015	TW3 2EH
Hounslow	View	N/A	N/A	Premises licence	View	Rutaba Bedfont Lane Service Station	174-178 Bedfont Lane	N/A	N/A	No	No	Unrestricted	Issued	View	01/01/2015	N/A	N/A	N/A	Mr Bhikhalal Gondhia & Mr Shalesh Gondhia	168 Tolkarne Drive, Pinner	HA5 2DR	N/A	N/A	Mr Bhikhalal Gondhia	Personal Licence No. LBHIL0027, issued by LB Hillingdon	168 Tolkarne Drive	HA5 2DR	N/A	N/A	N/A	N/A	N/A	N/A	20/03/2015	TW14 9NJ

Category axis OrganisationLabel OrganisationURI CaseReference CaseDate by day CaseDate by month CaseDate by year ServiceTypeLabel ServiceTypeURI PremisesName LocationText EntertainmentTypeLabel EntertainmentTypeURI LateNightRefreshment AlcoholSupply OpeningHours StatusLabel StatusURI LicenceStartDate by day LicenceStartDate by month LicenceStartDate by year LicenceEndDate by day LicenceEndDate by month LicenceEndDate by year OnPremisesAlcoholSale OffPremisesAlcoholSale LicenceHolder LicenceHolderAddress LicenceHolderPostcode ApplicantTypeLabel ApplicantTypeURI DesignatedPremisesSupervisor SupervisorLicenceNo SupervisorAddress SupervisorPostcode Conditions DecisionDate by day DecisionDate by month DecisionDate by year DecidedBy LicenceURL UPRN GeoPointLicensingURL ExtractDate by day ExtractDate by month ExtractDate by year Postcode

Value axis

As Sum Count Average

prev page 1 of next

Show 10 50 100 200 rows  Page 1 of 81   Go to page:  

<!-- {#template MAIN} {#foreach $T.Data as record} {#include ROW root=$T.record} {#/for} {#/template MAIN} {#template ROW} <tr class="{#cycle values=['alt','']}"> <td class="left"> {#if $T.OrganisationLabel != '' && $T.OrganisationLabel != null} <a href='#' title='Filter by {$T.OrganisationLabel}'>{$T.OrganisationLabel}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.OrganisationURI != '' && $T.OrganisationURI != null} <a href='{$T.OrganisationURI}' class='externalbutton button secondary float_left' title='Go to {$T.OrganisationURI}'>View</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.CaseReference != '' && $T.CaseReference != null} <a href='#' title='Filter by {$T.CaseReference}'>{$T.CaseReference}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class=""> {#if $T.CaseDate != '' && $T.CaseDate != null} <a href='#' title='Filter by {$T.CaseDate}'>{$T.CaseDate}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.ServiceTypeLabel != '' && $T.ServiceTypeLabel != null} <a href='#' title='Filter by {$T.ServiceTypeLabel}'>{$T.ServiceTypeLabel}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.ServiceTypeURI != '' && $T.ServiceTypeURI != null} <a href='{$T.ServiceTypeURI}' class='externalbutton button secondary float_left' title='Go to {$T.ServiceTypeURI}'>View</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.PremisesName != '' && $T.PremisesName != null} <a href='#' title='Filter by {$T.PremisesName}'>{$T.PremisesName}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.LocationText != '' && $T.LocationText != null} <a href='#' title='Filter by {$T.LocationText}'>{$T.LocationText}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.EntertainmentTypeLabel != '' && $T.EntertainmentTypeLabel != null} <a href='#' title='Filter by {$T.EntertainmentTypeLabel}'>{$T.EntertainmentTypeLabel}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.EntertainmentTypeURI != '' && $T.EntertainmentTypeURI != null} <a href='{$T.EntertainmentTypeURI}' class='externalbutton button secondary float_left' title='Go to {$T.EntertainmentTypeURI}'>View</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.LateNightRefreshment != '' && $T.LateNightRefreshment != null} <a href='#' title='Filter by {$T.LateNightRefreshment}'>{$T.LateNightRefreshment}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.AlcoholSupply != '' && $T.AlcoholSupply != null} <a href='#' title='Filter by {$T.AlcoholSupply}'>{$T.AlcoholSupply}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.OpeningHours != '' && $T.OpeningHours != null} <a href='#' title='Filter by {$T.OpeningHours}'>{$T.OpeningHours}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.StatusLabel != '' && $T.StatusLabel != null} <a href='#' title='Filter by {$T.StatusLabel}'>{$T.StatusLabel}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.StatusURI != '' && $T.StatusURI != null} <a href='{$T.StatusURI}' class='externalbutton button secondary float_left' title='Go to {$T.StatusURI}'>View</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class=""> {#if $T.LicenceStartDate != '' && $T.LicenceStartDate != null} <a href='#' title='Filter by {$T.LicenceStartDate}'>{$T.LicenceStartDate}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class=""> {#if $T.LicenceEndDate != '' && $T.LicenceEndDate != null} <a href='#' title='Filter by {$T.LicenceEndDate}'>{$T.LicenceEndDate}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.OnPremisesAlcoholSale != '' && $T.OnPremisesAlcoholSale != null} <a href='#' title='Filter by {$T.OnPremisesAlcoholSale}'>{$T.OnPremisesAlcoholSale}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.OffPremisesAlcoholSale != '' && $T.OffPremisesAlcoholSale != null} <a href='#' title='Filter by {$T.OffPremisesAlcoholSale}'>{$T.OffPremisesAlcoholSale}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.LicenceHolder != '' && $T.LicenceHolder != null} <a href='#' title='Filter by {$T.LicenceHolder}'>{$T.LicenceHolder}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.LicenceHolderAddress != '' && $T.LicenceHolderAddress != null} <a href='#' title='Filter by {$T.LicenceHolderAddress}'>{$T.LicenceHolderAddress}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.LicenceHolderPostcode != '' && $T.LicenceHolderPostcode != null} <a href='#' title='Filter by {$T.LicenceHolderPostcode}'>{$T.LicenceHolderPostcode}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.ApplicantTypeLabel != '' && $T.ApplicantTypeLabel != null} <a href='#' title='Filter by {$T.ApplicantTypeLabel}'>{$T.ApplicantTypeLabel}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.ApplicantTypeURI != '' && $T.ApplicantTypeURI != null} <a href='{$T.ApplicantTypeURI}' class='externalbutton button secondary float_left' title='Go to {$T.ApplicantTypeURI}'>View</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.DesignatedPremisesSupervisor != '' && $T.DesignatedPremisesSupervisor != null} <a href='#' title='Filter by {$T.DesignatedPremisesSupervisor}'>{$T.DesignatedPremisesSupervisor}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.SupervisorLicenceNo != '' && $T.SupervisorLicenceNo != null} <a href='#' title='Filter by {$T.SupervisorLicenceNo}'>{$T.SupervisorLicenceNo}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.SupervisorAddress != '' && $T.SupervisorAddress != null} <a href='#' title='Filter by {$T.SupervisorAddress}'>{$T.SupervisorAddress}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.SupervisorPostcode != '' && $T.SupervisorPostcode != null} <a href='#' title='Filter by {$T.SupervisorPostcode}'>{$T.SupervisorPostcode}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.Conditions != '' && $T.Conditions != null} <a href='#' title='Filter by {$T.Conditions}'>{$T.Conditions}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class=""> {#if $T.DecisionDate != '' && $T.DecisionDate != null} <a href='#' title='Filter by {$T.DecisionDate}'>{$T.DecisionDate}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.DecidedBy != '' && $T.DecidedBy != null} <a href='#' title='Filter by {$T.DecidedBy}'>{$T.DecidedBy}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.LicenceURL != '' && $T.LicenceURL != null} <a href='{$T.LicenceURL}' class='externalbutton button secondary float_left' title='Go to {$T.LicenceURL}'>View</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.UPRN != '' && $T.UPRN != null} <a href='#' title='Filter by {$T.UPRN}'>{$T.UPRN}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.GeoPointLicensingURL != '' && $T.GeoPointLicensingURL != null} <a href='{$T.GeoPointLicensingURL}' class='externalbutton button secondary float_left' title='Go to {$T.GeoPointLicensingURL}'>View</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class=""> {#if $T.ExtractDate != '' && $T.ExtractDate != null} <a href='#' title='Filter by {$T.ExtractDate}'>{$T.ExtractDate}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.Postcode != '' && $T.Postcode != null} <a href='#' title='Filter by {$T.Postcode}'>{$T.Postcode}</a> {#else} <span class="empty">N/A</span> {#/if} </td> </tr> {#/template ROW} -->

<!-- {#template MAIN} <div class="FilterHolder" style="display:none;"> <div class="optioncontainer"> <select id="ColumnToSearch{$T}" name="filter[{$T}].ColumnToSearch" class="ColumnToSearch selectbox small"> <option value="AlcoholSupply" class="text">AlcoholSupply</option> <option value="ApplicantTypeLabel" class="text">ApplicantTypeLabel</option> <option value="ApplicantTypeURI" class="url">ApplicantTypeURI</option> <option value="CaseDate" class="datetime">CaseDate</option> <option value="CaseReference" class="text">CaseReference</option> <option value="Conditions" class="text">Conditions</option> <option value="DecidedBy" class="text">DecidedBy</option> <option value="DecisionDate" class="datetime">DecisionDate</option> <option value="DesignatedPremisesSupervisor" class="text">DesignatedPremisesSupervisor</option> <option value="EntertainmentTypeLabel" class="text">EntertainmentTypeLabel</option> <option value="EntertainmentTypeURI" class="url">EntertainmentTypeURI</option> <option value="ExtractDate" class="datetime">ExtractDate</option> <option value="GeoPointLicensingURL" class="url">GeoPointLicensingURL</option> <option value="LateNightRefreshment" class="text">LateNightRefreshment</option> <option value="LicenceEndDate" class="datetime">LicenceEndDate</option> <option value="LicenceHolder" class="text">LicenceHolder</option> <option value="LicenceHolderAddress" class="text">LicenceHolderAddress</option> <option value="LicenceHolderPostcode" class="text">LicenceHolderPostcode</option> <option value="LicenceStartDate" class="datetime">LicenceStartDate</option> <option value="LicenceURL" class="url">LicenceURL</option> <option value="LocationText" class="text">LocationText</option> <option value="OffPremisesAlcoholSale" class="text">OffPremisesAlcoholSale</option> <option value="OnPremisesAlcoholSale" class="text">OnPremisesAlcoholSale</option> <option value="OpeningHours" class="text">OpeningHours</option> <option value="OrganisationLabel" class="text">OrganisationLabel </option> <option value="OrganisationURI" class="url">OrganisationURI</option> <option value="Postcode" class="text">Postcode</option> <option value="PremisesName" class="text">PremisesName</option> <option value="ServiceTypeLabel" class="text">ServiceTypeLabel</option> <option value="ServiceTypeURI" class="url">ServiceTypeURI</option> <option value="StatusLabel" class="text">StatusLabel</option> <option value="StatusURI" class="url">StatusURI</option> <option value="SupervisorAddress" class="text">SupervisorAddress</option> <option value="SupervisorLicenceNo" class="text">SupervisorLicenceNo</option> <option value="SupervisorPostcode" class="text">SupervisorPostcode</option> <option value="UPRN" class="text">UPRN</option> </select> </div> <div class="searchByText optioncontainer"> <select id="SearchOperator{$T}" name="filter[{$T}].SearchOperator" class="SearchOperator selectbox small"> <option value="contains">contains</option> <option value="isequalto">is equal to</option> </select> <input type="text" id="SearchText{$T}" name="filter[{$T}].SearchText" class="text-box searchText"/> </div> <div class="searchByNumber optioncontainer" style="display:none;"> <select id="SearchOperatorNumber{$T}" name="filter[{$T}].SearchOperatorNumber" class="SearchOperatorNumber selectbox small"> <option value="greaterthan">greater than</option> <option value="greaterthanequalto">greater than or equal to</option> <option value="lessthan">less than</option> <option value="lessthanequalto">less than or equal to</option> <option value="isequalto">is equal to</option> </select> <input type="text" id="SearchNumber{$T}" name="filter[{$T}].SearchNumber" class="text-box searchNumber number"/> </div> <div class="searchByDate optioncontainer" style="display:none;">  <label for="From{$T}">from</label>  <input type="text" id="From{$T}" name="filter[{$T}].From" class="text-box datebox searchDate from date"/>  <label for="To{$T}">to</label>  <input type="text" id="To{$T}" name="filter[{$T}].To" class="text-box datebox searchDate to date"/> </div> <input type="button" value="-" title="Remove filter" class="button blue small removeFilter" /> <input id="AddFilter" type="button" title="Add another filter" value="+" class="button blue small disabled" /> <input id="Filter" type="submit" value="Filter" class="button grey" /> <input id="ClearFilter" type="button" value="Clear" class="button grey" /> </div> {#/template MAIN} -->