California and San Diego Alcohol Licenses

abc.ca.gov-licenses-2.1.2 Last Update: 2020-11-27T23:13:03

Records of alcohol licenses in california, from the CA ABC daily file, with improvements to geographic identifiers, and acompilation of areal densities of on-sale and off-sale licenses in San Diego county.

This package is a conversion of the California Daily ABC file, so it is current as of the modification date of the package. The main change is the addition of the county variable, the FIPS code for the county, and the tract, the ACS format geoid version of the tract identifier.

For the values for the license_type field, see https://www.abc.ca.gov/licensing/license-types/. The codes have general categories roughly noted by the tens digit, so you can divide by 10 to group them:

• 0: Manufacturers and Distilleries
• 1: Importers, Borkers and Wholesalers
• 2: Off-sale (Sale for off-site consumption) and smalle wholesalers
• 4: On-sale
• 5: Clubs and caterers
• 6: On-Sale Seasonal sales, B&B, Hospitals, Theater Companies, etc.
• 7: Events, Farmers Markets
• 8: A Variety of odd types
• 9: Special Use

The most common types are:

• 41; On-Sale Beer and Wine - Public
• 47: On-Sale General - Eating
• 21: Off-Sale General
• 20: Off-sale Beer and Wine
• 58: Catering
• 48: On-Sale General -- Public ( Bars and Nightclubs )

Images

Density of On-Sale permits in permits per square kilometer.## Notes

• V2.1.1 Added sd_abc_density

Contacts

• Wrangler Eric Busboom, Civic Knowledge

Resources

• ca_abc_licenses. California Alcohol Beverage Control Licenses
• sd_abc_density. Areal density of on-sale and off-sale licenses in San Diego county

References

• abc_licenses_source. Raw ABC data
• sd_geography, metapack+http://library.metatab.org/sandiegodata.org-geography-2018-13.csv. San Diego geography
• zip_tract, metapack+http://s3.amazonaws.com/library.metatab.org/huduser.gov-zip_tract-2016-2.csv. Zip to Tract mapping