This project contains a script that creates a SQL database of licensed breweries, wineries, cideries, distilleries, alcohol distributors, and alcohol sales to distributors in Washington State. Source data is publically available from the Washington State Liquor and Cannabis Board.
The purpose of this project was to provide a foundation for visualizing trends in Craft Brewery production and operations in Washington state, and to estimate available quantities of brewer's spent grain for use in local biogas digesters. The code found here can ingest data found in the spreadsheets and documentation from the state liquor control board for downstream analysis and visualization.
Clone the repository from the terminal using the following command:
Local deployment can be accomplished by creating a virtual environment using Python 3.11 and installing the necessary dependencies as described in the next section.
- Install dependencies from the terminal using the following command:
pip install -r requirements.txt
- Python
- SQLite
Contributions and suggestions are welcome and may be submitted by forking this project and submitting a pull request through GitHub.
This project is in development.
Written by Cyrus Anderson.
This project is licensed under the MIT License - see the LICENSE file for details.