Page 2 of 5
Re: 51% lookup now available online @ TABC website!
Posted: Mon May 16, 2011 4:27 pm
by artx
Thanks! I've verified 2 places that had the 51% sign were not (as I thought) really 51% locations!!! This is great!
Re: 51% lookup now available online @ TABC website!
Posted: Mon May 16, 2011 4:32 pm
by RHenriksen
artx wrote:Thanks! I've verified 2 places that had the 51% sign were not (as I thought) really 51% locations!!! This is great!
Very cool. What's the appropriate process to get those businesses' signage reviewed/corrected?
Re: 51% lookup now available online @ TABC website!
Posted: Mon May 16, 2011 4:37 pm
by tbrown
If you know/like the management (or a staff member) you can point it out in a friendly way to save them any hassles.
If not, there's a form on the TABC website to report so they can investigate.
http://www.tabc.state.tx.us/forms/enforcement/4-65.pdf
Re: 51% lookup now available online @ TABC website!
Posted: Mon May 16, 2011 4:59 pm
by joelamosobadiah
Another use for this feature is to list all 51%+ establishments in a particular area (to see if there's any "surprises" in your area):
Go to the TABC website and click on Public inquiry, then click on the option for, "Create a list of licenses or permits".
Select the options you want listed. I listed the two counties of the city I live in (Potter and Randall), and left the dates blank.
Select Excel as the output format.
Open the downloaded Excel file.
Click on the data tab on the toolbar at the top.
Click on the Filter Button
Click on the down arrow on the far right column and make sure only the "Red" checkbox is checked.
Now you'll have a list of all the 51%+ businesses in the area.
Re: 51% lookup now available online @ TABC website!
Posted: Mon May 16, 2011 5:21 pm
by sugar land dave
Works well. Thanks to all involved!

Re: 51% lookup now available online @ TABC website!
Posted: Mon May 16, 2011 9:49 pm
by pedalman
This is great! Now we don't have to bother the TABC for this information. I'm sure they have more important things to do. Hopefully, this will free up some time for them.
Re: 51% lookup now available online @ TABC website!
Posted: Mon May 16, 2011 9:56 pm
by The Mad Moderate
could this data be culled and used in a iOS or Android app.
Re: 51% lookup now available online @ TABC website!
Posted: Mon May 16, 2011 10:04 pm
by RHenriksen
loadedliberal wrote:could this data be culled and used in a iOS or Android app.
Well, for starters the Android CHL app will get a link to the TABC search page.
Re: 51% lookup now available online @ TABC website!
Posted: Mon May 16, 2011 10:14 pm
by A-R
Re: 51% lookup now available online @ TABC website!
Posted: Mon May 16, 2011 10:26 pm
by RHenriksen
Thanks, AR, but she really deserves most of the credit

Re: 51% lookup now available online @ TABC website!
Posted: Tue May 17, 2011 4:29 pm
by Mach1
My thanks, also! Good job, RHenriksen.. And thanks also to Joel...iah for the spreadsheet tips.
Re: 51% lookup now available online @ TABC website!
Posted: Tue May 17, 2011 5:27 pm
by joelamosobadiah
Theoretically (I'm not a programmer) couldn't this info be parsed into an Excel or csv format and put into an Android or iPhone app that would use location services to search for 51+% locations near your current address? Wouldn't think it would be too difficult...
Re: 51% lookup now available online @ TABC website!
Posted: Tue May 17, 2011 5:31 pm
by RHenriksen
joelamosobadiah wrote:Theoretically (I'm not a programmer) couldn't this info be parsed into an Excel or csv format and put into an Android or iPhone app that would use location services to search for 51+% locations near your current address? Wouldn't think it would be too difficult...
I know just enough about programming to have a lot of respect for the people do

Re: 51% lookup now available online @ TABC website!
Posted: Tue May 17, 2011 6:06 pm
by boba
joelamosobadiah wrote:Theoretically (I'm not a programmer) couldn't this info be parsed into an Excel or csv format and put into an Android or iPhone app that would use location services to search for 51+% locations near your current address? Wouldn't think it would be too difficult...
It could, but if you have an Android or iPhone you probably have a data plan and can go to the website and check for a 51% license at the place your family or friends want to go. That way it's up to date.
Re: 51% lookup now available online @ TABC website!
Posted: Wed May 18, 2011 7:13 am
by 5thGenTexan
Man that is great, just verified one bad 51% sign that had miffed me for years just never thought call on.