Pending Original New Primary and Subordinate License Application(s)
The TABC Pending Original (New) Primary and Subordinate License Application dataset includes information for certain submitted applications for new licenses. These records include original (new) applications with the status of “Received” or “In Review” by the agency and as found in the Alcohol Industry Management System (AIMS). Data includes transactions as of midnight the day before the current calendar date.
Please note these data records do not include license renewals or other license-related applications. To find data for renewal applications, please see the appropriate section within <a href="https://www.tabc.texas.gov/public-information/tabc-public-inquiry/">Public Inquiry</a> or the Open Data Portal’s <a href="https://data.texas.gov/dataset/TABC-License-Information/7hf9-qc9f">TABC License Information Dataset</a>. Renewal applications will be identified by the license status “Renewal Pending.”
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"texas-gov/pending-original-new-primary-and-subordinate-mxm5-tdpj\".\"pending_original_new_primary_and_subordinate\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.