LQS - Reports

Daily Reports
• Issued Licenses
• New Applications
• Status Changes
Weekly Reports
• Finalized Legal Proceedings
• Filed Legal Proceedings
• Archives
Monthly reports
• Revocation Pending Licenses
• Raw Data Export
Annual Reports
• License Summary Counts
• List of Licensed Importers
Ad-Hoc reports
• Query by City and License Type information
• Query by County, ZIP Code and License Type information
• Query by County, Census Tract and License Type information

Right Column

DEPARTMENT OF ALCOHOLIC BEVERAGE CONTROL

The following forms/documents are available in Portable Document Format (PDF). You will need the Adobe Acrobat Reader application (version 5.0 or greater) to view, fill-in or print. To download the free software, please click the icon.

MONTHLY DATA EXPORT

The Data Export is a zipped file that contains the raw data (ASCII format, fixed-length fields). It may be too large for some versions of Excel. Average zipped file size is 7MB (70MB unzipped).
Please read the ABC_Data_layout.pdf document first, as it has code definitions and record layout information.

• Data Layout and code references.
  (Definition of the fields and descriptions of the codes.)



• Data Export (Pending and Active License Records, refreshed every 4th Wednesday of the month. Average Zipped file size is 7MB.)