California and San Diego Alcohol Licenses

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.

abc.ca.gov-licenses-2.1.2. Modified 2020-11-27T23:20:08

Resources | Packages | Documentation| Contacts| References| Data Dictionary

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

Documentation

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.

Contacts

Data Dictionary

ca_abc_licenses | sd_abc_density

ca_abc_licenses

Column NameData TypeDescription
license_typeinteger
file_numberinteger
lic_or_appstring
type_statusstring
type_orig_iss_datestring
expir_datestring
fee_codesstring
dup_countsstring
master_indstring
term_in_of_monthsinteger
geo_codeinteger
districtinteger
primary_nametext
prem_addr_1string
prem_addr_2string
prem_citystring
prem_statestring
prem_zipstring
dba_nametext
mail_addr_1string
mail_addr_2string
mail_citystring
mail_statestring
mail_zipstring
prem_countystring
prem_census_tractstring
countyintegerCounty FIPS code
tractstringTract Geoid

sd_abc_density

Column NameData TypeDescription
geoidstringTract geoid
geometrystringTract geometry, in wkt format
alandintegerLand area of tract, in square meters
offsaleintegerCount of off-sale licenses in tract, 20 & 21
onsaleintegerCount of on-sale licenses in tract, 41, 47, 48
offsale_dennumberAreal density of off-sale licences, per square km
onsale_dennumberAreal density of on-sale licences, per square km
community_namestringCommunity name in San Diego, Cityname otherwise.

References

Urls used in the creation of this data package.

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

Packages

Accessing Data in Vanilla Pandas

import pandas as pd


ca_abc_licenses_df =  pd.read_csv('http://library.metatab.org/abc.ca.gov-licenses-2.1.2/data/ca_abc_licenses.csv')
sd_abc_density_df =  pd.read_csv('http://library.metatab.org/abc.ca.gov-licenses-2.1.2/data/sd_abc_density.csv')

Accessing Package in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/abc.ca.gov-licenses-2.1.2.csv')

# Create Dataframes
ca_abc_licenses_df = pkg.resource('ca_abc_licenses').dataframe()
sd_abc_density_gdf = pkg.resource('sd_abc_density').geoframe()