openbrewerydb

KO | EN

gitlite — search

#javascript #python #hacktoberfest #react #ai #typescript #llm #go #golang #android #machine-learning #rust #deep-learning #linux

(★ 214)

🍻 An open-source dataset of breweries, cideries, brewpubs, and bottleshops.

openbrewerydb Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# 🍻 Open Brewery DB Dataset

[![All Contributors](https://img.shields.io/badge/all_contributors-76-orange.svg?style=flat-square)](https://raw.githubusercontent.com/openbrewerydb/openbrewerydb/master/)

![Open Brewery DB Logo](https://raw.githubusercontent.com/openbrewerydb/openbrewerydb/master/obdb-logo-md.jpg)

This is the open-source dataset for the [Open Brewery DB API](https://www.openbrewerydb.org/) which is served by a [REST API built with Laravel](https://github.com/openbrewerydb/openbrewerydb-laravel-api)

## 🎯 Purpose

Provide an approval-based pipeline to update the dataset and API.

## 🗄 Data Formats

- [CSV - Full Dataset](breweries.csv)
- [JSON](breweries.json)
- [PostgreSQL SQL](breweries.sql)

## 🚀 Getting Started

1. `git clone git@github.com:openbrewerydb/openbrewerydb.git`
2. `cd openbrewerydb && npm install`

## ⚙️ Scripts

The following npm scripts help maintain and manage the dataset:

### Data Management

- `npm run validate`

- Validates all CSV files against the JSON Schema
  - Checks for required fields and data format consistency
  - Reports any validation errors that need attention

- `npm run csv:combine`

- Combines all individual CSV files from country/state-region folders into a single `breweries.csv`
  - Useful when you've made changes to individual state files and need to update the main dataset

- `npm run csv:split`
  - Splits the main `breweries.csv` into separate files by country/state-region
  - Helps maintain organized, manageable data files for each region
  - Creates directories if they don't exist

### Data Generation

- `npm run generate:ids`

- Creates unique OBDB IDs for each brewery based on name and city
  - Automatically updates `breweries.csv` with new IDs
  - Ensures no duplicate IDs exist in the dataset

- `npm run generate:json`

- Converts `breweries.csv` into a JSON format (`breweries.json`)
  - Useful for applications that prefer working with JSON data
  - Maintains data consistency across formats

- `npm run generate:sql`

- Creates PostgreSQL SQL file from `breweries.csv`
  - Includes table creation and data insertion statements
  - Perfect for database implementations

- `npm run generate:stats`

- Generates comprehensive dataset statistics
  - Shows brewery counts by state/city
  - Displays brewery type distribution
  - Reports data completeness metrics

- `npm run update:readme-stats`
  - Updates the Statistics section in `README.md` with latest data
  - Automatically calculates and formats all statistics
  - Includes last updated timestamp

### Contributor Management

- `npm run contributors:add`

- Interactive CLI tool to add new contributors
  - Prompts for contributor information and contribution type
  - Updates `.all-contributorsrc` file

- `npm run contributors:check`

- Verifies if any contributors are missing from the list
  - Helps maintain accurate recognition of all contributors

- `npm run contributors:generate`
  - Updates the Contributors section in `README.md`
  - Generates contributor table with avatars and contribution types

### Workflow

- `npm run workflow:maintain`
  - Comprehensive maintenance workflow that:
    1. Validates all CSV files
    2. Combines all CSV files
    3. Creates unique IDs for each brewery
    4. Splits back into individual state files
    5. Creates JSON and SQL files
    6. Updates README.md with latest statistics
  - Run this after making any dataset updates

## 🤝 Contributing

For information on contributing to this project, please see the [contributing guide](CONTRIBUTING.md) and our [code of conduct](CODE_OF_CONDUCT.md).

1. Fork the repository
2. Add or update breweries in the CSV (Excel, Google Sheets)
3. Submit a Pull Request

### Tips

First and foremost, don't worry about messing up! 🙂 Thank you so much for contributing! 🙌

- CSVs are organized by `data/[country]/[state_province]`
- Required fields/columns: `name`, `brewery_type`, `city`, `state_province`, and `country`
- When adding a brewery, do not include an `id`. This will be created after review.
- Please either add to `breweries.csv` (preferred if adding breweries for a new country) or the individual state/province CSV file. Adding to both at the same time may introduce duplicates/errors.

## 👾 Community

- [Join the Newsletter](http://eepurl.com/dBjS0j)
- [Join the Discord](https://discord.gg/3G3syaD)

## 📫 Feedback

Any feedback, please [email me](mailto:chris@openbrewerydb.org).

Cheers! 🍻

## 📊 Project Status

- **Status**: Active
- **Last Dataset Update**: 2024
- **Maintenance**: Actively maintained through community contributions
- **Dataset Size**: 8,000+ breweries
- **Coverage**: United States, with growing international data

## 🔧 Requirements

- Node.js v22 or higher
- npm package manager
- Git

## 📚 Data Schema

Each brewery entry contains the following fields:

| Field          | Type   | Description                                      | Required |
| -------------- | ------ | ------------------------------------------------ | -------- |
| id             | String | Unique identifier                                | Yes      |
| name           | String | Name of the brewery                              | Yes      |
| brewery_type   | String | Type of brewery (micro, regional, brewpub, etc.) | Yes      |
| street         | String | Street address                                   | No       |
| city           | String | City                                             | Yes      |
| state_province | String | State/Province                                   | Yes      |
| postal_code    | String | Postal code                                      | Yes      |
| country        | String | Country                                          | Yes      |
| longitude      | String | Decimal longitude coordinate                     | No       |
| latitude       | String | Decimal latitude coordinate                      | No       |
| phone          | String | Phone number                                     | No       |
| website_url    | String | Website URL                                      | No       |

## 📖 Usage Examples

### Python

```python
import pandas as pd

# Read CSV
breweries_df = pd.read_csv('breweries.csv')

# Filter by state
california_breweries = breweries_df[breweries_df['state_province'] == 'California']
```

### JavaScript/Node.js

```javascript
const fs = require("fs");

// Read JSON
const breweries = JSON.parse(fs.readFileSync("breweries.json", "utf8"));

// Filter by type
const microBreweries = breweries.filter((b) => b.brewery_type === "micro");
```

### SQL

```sql
-- After importing breweries.sql
SELECT name, city, state_province
FROM breweries
WHERE brewery_type = 'brewpub'
ORDER BY state_province, city;
```

## 🔄 Versioning

The dataset is updated regularly through community contributions. Each update goes through the following process:

1. Community members submit new breweries or updates via pull requests
2. Changes are reviewed and validated
3. Upon approval, changes are merged and new dataset files are generated
4. The API is automatically updated with the new data

Latest dataset version: 2024.1

## Contributors ✨

Thanks goes to these wonderful people ([emoji key](https://allcontributors.org/docs/en/emoji-key)):

<table>
 <tbody>
 <tr>
 <td align="center" valign="top" width="14.28%"><a href="https://theputnams.net/mike/"><img src="https://avatars3.githubusercontent.com/u/213371?v=4?s=100" width="100px;" alt="Mike Putnam"/> Mike Putnam</a> <a href="#data-mikeputnam" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://andrewbarber.me/"><img src="https://avatars0.githubusercontent.com/u/135927?v=4?s=100" width="100px;" alt="Andrew A. Barber"/> Andrew A. Barber</a> <a href="#data-AndrewBarber" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="http://www.therearefourmics.com/"><img src="https://avatars2.githubusercontent.com/u/39307371?v=4?s=100" width="100px;" alt="Jason Allen"/> Jason Allen</a> <a href="#data-jallend1" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/Juicob"><img src="https://avatars1.githubusercontent.com/u/68080175?v=4?s=100" width="100px;" alt="Juicob"/> Juicob</a> <a href="#data-Juicob" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/wkarney"><img src="https://avatars0.githubusercontent.com/u/35663282?v=4?s=100" width="100px;" alt="Will Karnasiewicz"/> Will Karnasiewicz</a> <a href="#data-wkarney" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://dvavs.github.io/"><img src="https://avatars0.githubusercontent.com/u/49594473?v=4?s=100" width="100px;" alt="Dylan T. Vavra"/> Dylan T. Vavra</a> <a href="#data-dvavs" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/amadisonm1209"><img src="https://avatars0.githubusercontent.com/u/44384309?v=4?s=100" width="100px;" alt="Madison Martinez"/> Madison Martinez</a> <a href="#data-amadisonm1209" title="Data">🔣</a></td>
 </tr>
 <tr>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/danieleremchuk"><img src="https://avatars0.githubusercontent.com/u/50344935?v=4?s=100" width="100px;" alt="Daniel Eremchuk"/> Daniel Eremchuk</a> <a href="#data-danieleremchuk" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/alexchong"><img src="https://avatars2.githubusercontent.com/u/18007017?v=4?s=100" width="100px;" alt="Alex Chong"/> Alex Chong</a> <a href="#data-alexchong" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://www.jackofalladmins.com/"><img src="https://avatars0.githubusercontent.com/u/19848610?v=4?s=100" width="100px;" alt="Matt S"/> Matt S</a> <a href="#data-MStewGT" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://www.linkedin.com/in/samuel-rusher/"><img src="https://avatars3.githubusercontent.com/u/55074718?v=4?s=100" width="100px;" alt="Samuel Rusher"/> Samuel Rusher</a> <a href="#data-srusher" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/EACaraway"><img src="https://avatars1.githubusercontent.com/u/71463301?v=4?s=100" width="100px;" alt="Evan Caraway"/> Evan Caraway</a> <a href="#data-EACaraway" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/tylerkkp"><img src="https://avatars0.githubusercontent.com/u/30785626?v=4?s=100" width="100px;" alt="Tyler K Kuromiya Parker"/> Tyler K Kuromiya Parker</a> <a href="#data-tylerkkp" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/kendellmendoza"><img src="https://avatars.githubusercontent.com/u/32558172?v=4?s=100" width="100px;" alt="kendellmendoza"/> kendellmendoza</a> <a href="#data-kendellmendoza" title="Data">🔣</a></td>
 </tr>
 <tr>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/Johnnyk737"><img src="https://avatars.githubusercontent.com/u/20580717?v=4?s=100" width="100px;" alt="Johnnyk737"/> Johnnyk737</a> <a href="#data-Johnnyk737" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/jameshschuler"><img src="https://avatars.githubusercontent.com/u/41769529?v=4?s=100" width="100px;" alt="James Schuler"/> James Schuler</a> <a href="#data-jameshschuler" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/cleif"><img src="https://avatars.githubusercontent.com/u/6209424?v=4?s=100" width="100px;" alt="Creighton Leif"/> Creighton Leif</a> <a href="#data-cleif" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/vitaly-t"><img src="https://avatars.githubusercontent.com/u/5108906?v=4?s=100" width="100px;" alt="Vitaly Tomilov"/> Vitaly Tomilov</a> <a href="https://github.com/openbrewerydb/openbrewerydb/commits?author=vitaly-t" title="Code">💻</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/kylescudder"><img src="https://avatars.githubusercontent.com/u/74150974?v=4?s=100" width="100px;" alt="Kyle Scudder"/> Kyle Scudder</a> <a href="#data-kylescudder" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://chrisjmears.com/"><img src="https://avatars.githubusercontent.com/u/96110?v=4?s=100" width="100px;" alt="Chris Mears"/> Chris Mears</a> <a href="#question-chrisjm" title="Answering Questions">💬</a> <a href="https://github.com/openbrewerydb/openbrewerydb/commits?author=chrisjm" title="Code">💻</a> <a href="#data-chrisjm" title="Data">🔣</a> <a href="#maintenance-chrisjm" title="Maintenance">🚧</a> <a href="#projectManagement-chrisjm" title="Project Management">📆</a> <a href="#tool-chrisjm" title="Tools">🔧</a> <a href="#tutorial-chrisjm" title="Tutorials">✅</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/donkeyslaps"><img src="https://avatars.githubusercontent.com/u/91644699?v=4?s=100" width="100px;" alt="donkeyslaps"/> donkeyslaps</a> <a href="#data-donkeyslaps" title="Data">🔣</a></td>
 </tr>
 <tr>
 <td align="center" valign="top" width="14.28%"><a href="https://deciphermiddleware.blogspot.com/"><img src="https://avatars.githubusercontent.com/u/30888879?v=4?s=100" width="100px;" alt="Pranav Davar"/> Pranav Davar</a> <a href="#tool-cipherwizard9" title="Tools">🔧</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/ahbarrozo"><img src="https://avatars.githubusercontent.com/u/36050690?v=4?s=100" width="100px;" alt="Alexandre Hernandes Barrozo"/> Alexandre Hernandes Barrozo</a> <a href="#data-ahbarrozo" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/Resten1497"><img src="https://avatars.githubusercontent.com/u/19689492?v=4?s=100" width="100px;" alt="Resten"/> Resten</a> <a href="#data-Resten1497" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://matthiggins.dev/"><img src="https://avatars.githubusercontent.com/u/8033424?v=4?s=100" width="100px;" alt="Matt Higgins"/> Matt Higgins</a> <a href="#data-vextor22" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://alexjustesen.com/"><img src="https://avatars.githubusercontent.com/u/1144087?v=4?s=100" width="100px;" alt="Alex Justesen"/> Alex Justesen</a> <a href="#data-alexjustesen" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://www.binarydolphin.com/"><img src="https://avatars.githubusercontent.com/u/4139590?v=4?s=100" width="100px;" alt="Craig Kelly"/> Craig Kelly</a> <a href="#data-CraigKelly" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="http://rewak.pl/"><img src="https://avatars.githubusercontent.com/u/10898728?v=4?s=100" width="100px;" alt="Krzysztof Rewak"/> Krzysztof Rewak</a> <a href="#data-krzysztofrewak" title="Data">🔣</a></td>
 </tr>
 <tr>
 <td align="center" valign="top" width="14.28%"><a href="https://johnbaumert.com/"><img src="https://avatars.githubusercontent.com/u/36886175?v=4?s=100" width="100px;" alt="John Baumert"/> John Baumert</a> <a href="#data-baumertjohn" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/phortysiks"><img src="https://avatars.githubusercontent.com/u/25803180?v=4?s=100" width="100px;" alt="Charlie Cox"/> Charlie Cox</a> <a href="#data-phortysiks" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/milsman2"><img src="https://avatars.githubusercontent.com/u/72627575?v=4?s=100" width="100px;" alt="Miles Kane"/> Miles Kane</a> <a href="#data-milsman2" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/anthonylaflamme"><img src="https://avatars.githubusercontent.com/u/4626172?v=4?s=100" width="100px;" alt="Anthony Laflamme"/> Anthony Laflamme</a> <a href="https://github.com/openbrewerydb/openbrewerydb/commits?author=anthonylaflamme" title="Code">💻</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/Schurlo"><img src="https://avatars.githubusercontent.com/u/124918466?v=4?s=100" width="100px;" alt="Georg Engelsmann"/> Georg Engelsmann</a> <a href="#data-Schurlo" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/solidocean007"><img src="https://avatars.githubusercontent.com/u/106035937?v=4?s=100" width="100px;" alt="Clinton Williams"/> Clinton Williams</a> <a href="#data-solidocean007" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/buzzamus"><img src="https://avatars.githubusercontent.com/u/15583028?v=4?s=100" width="100px;" alt="Brent Busby"/> Brent Busby</a> <a href="#data-buzzamus" title="Data">🔣</a></td>
 </tr>
 <tr>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/kenster89"><img src="https://avatars.githubusercontent.com/u/32558172?v=4?s=100" width="100px;" alt="kenster89"/> kenster89</a> <a href="#data-kenster89" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/sadilet"><img src="https://avatars.githubusercontent.com/u/20108793?v=4?s=100" width="100px;" alt="Adilet Sarsembayev"/> Adilet Sarsembayev</a> <a href="#data-sadilet" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://blog.deciphermiddleware.in/"><img src="https://avatars.githubusercontent.com/u/30888879?v=4?s=100" width="100px;" alt="Pranav Davar"/> Pranav Davar</a> <a href="#data-pranav-davar" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/b-mc2"><img src="https://avatars.githubusercontent.com/u/78936105?v=4?s=100" width="100px;" alt="b-mc2"/> b-mc2</a> <a href="#data-b-mc2" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/nicole440"><img src="https://avatars.githubusercontent.com/u/111709554?v=4?s=100" width="100px;" alt="Nicole"/> Nicole</a> <a href="#data-nicole440" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="http://www.reenhanced.com/"><img src="https://avatars.githubusercontent.com/u/602226?v=4?s=100" width="100px;" alt="Nicholas Hance"/> Nicholas Hance</a> <a href="#data-nhance" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/Jocce-Nilsson"><img src="https://avatars.githubusercontent.com/u/59723488?v=4?s=100" width="100px;" alt="Joachim Nilsson"/> Joachim Nilsson</a> <a href="#data-Jocce-Nilsson" title="Data">🔣</a></td>
 </tr>
 <tr>
 <td align="center" valign="top" width="14.28%"><a href="https://alejandrolopezrocha.com/"><img src="https://avatars.githubusercontent.com/u/8307263?v=4?s=100" width="100px;" alt="Alejandro Lopez Rocha"/> Alejandro Lopez Rocha</a> <a href="#data-alrocha" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/zshapleigh"><img src="https://avatars.githubusercontent.com/u/816109?v=4?s=100" width="100px;" alt="zshapleigh"/> zshapleigh</a> <a href="#data-zshapleigh" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/Stormalias"><img src="https://avatars.githubusercontent.com/u/44340476?v=4?s=100" width="100px;" alt="Praval Visvanath"/> Praval Visvanath</a> <a href="#data-Stormalias" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="http://johnhenryward.me/"><img src="https://avatars.githubusercontent.com/u/43694168?v=4?s=100" width="100px;" alt="JohnHenry"/> JohnHenry</a> <a href="#data-JohnHenry-Ward" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/Jose-Alfredo-Garcia"><img src="https://avatars.githubusercontent.com/u/68479370?v=4?s=100" width="100px;" alt="Alfredo Garcia"/> Alfredo Garcia</a> <a href="#data-Jose-Alfredo-Garcia" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/Qerewe"><img src="https://avatars.githubusercontent.com/u/20256930?v=4?s=100" width="100px;" alt="Qerewe"/> Qerewe</a> <a href="#data-Qerewe" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://portfolio.nathan-peters.me/"><img src="https://avatars.githubusercontent.com/u/77593152?v=4?s=100" width="100px;" alt="Nathan Peters"/> Nathan Peters</a> <a href="#data-nathanpeters8" title="Data">🔣</a></td>
 </tr>
 <tr>
 <td align="center" valign="top" width="14.28%"><a href="http://www.eonjava.com/"><img src="https://avatars.githubusercontent.com/u/173938?v=4?s=100" width="100px;" alt="Erich Cervantez"/> Erich Cervantez</a> <a href="#data-erichcervantez" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/epikkoder"><img src="https://avatars.githubusercontent.com/u/20148265?v=4?s=100" width="100px;" alt="Ronald Sahagun"/> Ronald Sahagun</a> <a href="#data-epikkoder" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/gregwilson42"><img src="https://avatars.githubusercontent.com/u/132391327?v=4?s=100" width="100px;" alt="Greg W."/> Greg W.</a> <a href="#data-gregwilson42" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/davidaholm"><img src="https://avatars.githubusercontent.com/u/4689571?v=4?s=100" width="100px;" alt="David Holm"/> David Holm</a> <a href="#data-davidaholm" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/sadilett"><img src="https://avatars.githubusercontent.com/u/195586942?v=4?s=100" width="100px;" alt="sadilett"/> sadilett</a> <a href="#data-sadilett" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/RyanMallette"><img src="https://avatars.githubusercontent.com/u/13306840?v=4?s=100" width="100px;" alt="Ryan Mallette"/> Ryan Mallette</a> <a href="#data-RyanMallette" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://chriscondreay.github.io/condreaychris/"><img src="https://avatars.githubusercontent.com/u/76202959?v=4?s=100" width="100px;" alt="Chris Condreay"/> Chris Condreay</a> <a href="#data-chriscondreay" title="Data">🔣</a></td>
 </tr>
 <tr>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/Wi5ARD"><img src="https://avatars.githubusercontent.com/u/42097753?v=4?s=100" width="100px;" alt="Wi5ARD"/> Wi5ARD</a> <a href="#data-Wi5ARD" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://jpbulman.com/"><img src="https://avatars.githubusercontent.com/u/12652192?v=4?s=100" width="100px;" alt="JP Bulman"/> JP Bulman</a> <a href="#data-jpbulman" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/sarakaneki"><img src="https://avatars.githubusercontent.com/u/115870918?v=4?s=100" width="100px;" alt="Sara"/> Sara</a> <a href="#data-sarakaneki" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://seanwp.pythonanywhere.com/"><img src="https://avatars.githubusercontent.com/u/133682090?v=4?s=100" width="100px;" alt="Sean"/> Sean</a> <a href="#data-SeanRVACode" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://theclouddevopslearningblog.com/"><img src="https://avatars.githubusercontent.com/u/4686123?v=4?s=100" width="100px;" alt="Simon"/> Simon</a> <a href="#data-simonmackinnon" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/willkrakow"><img src="https://avatars.githubusercontent.com/u/17362961?v=4?s=100" width="100px;" alt="willkrakow"/> willkrakow</a> <a href="#data-willkrakow" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/CharlRitter"><img src="https://avatars.githubusercontent.com/u/13846799?v=4?s=100" width="100px;" alt="Charl Ritter"/> Charl Ritter</a> <a href="#data-CharlRitter" title="Data">🔣</a></td>
 </tr>
 <tr>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/zingi"><img src="https://avatars.githubusercontent.com/u/9286499?v=4?s=100" width="100px;" alt="Aaron Zingerle"/> Aaron Zingerle</a> <a href="#data-zingi" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/Ndawson15"><img src="https://avatars.githubusercontent.com/u/6465674?v=4?s=100" width="100px;" alt="Noah Dawson"/> Noah Dawson</a> <a href="#data-Ndawson15" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/jctopping"><img src="https://avatars.githubusercontent.com/u/163754356?v=4?s=100" width="100px;" alt="jctopping"/> jctopping</a> <a href="#data-jctopping" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://fabiovitalba.github.io/"><img src="https://avatars.githubusercontent.com/u/3830362?v=4?s=100" width="100px;" alt="Fabio Vitalba"/> Fabio Vitalba</a> <a href="#data-fabiovitalba" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/dustinb"><img src="https://avatars.githubusercontent.com/u/1167912?v=4?s=100" width="100px;" alt="Dustin Butler"/> Dustin Butler</a> <a href="#data-dustinb" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/BruddahChrispy"><img src="https://avatars.githubusercontent.com/u/3619514?v=4?s=100" width="100px;" alt="BruddahChrispy"/> BruddahChrispy</a> <a href="#data-BruddahChrispy" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://pirxpilot.me/"><img src="https://avatars.githubusercontent.com/u/3240?v=4?s=100" width="100px;" alt="Damian Krzeminski"/> Damian Krzeminski</a> <a href="https://github.com/openbrewerydb/openbrewerydb/commits?author=pirxpilot" title="Code">💻</a> <a href="#data-pirxpilot" title="Data">🔣</a></td>
 </tr>
 <tr>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/mathewhaug"><img src="https://avatars.githubusercontent.com/u/155565721?v=4?s=100" width="100px;" alt="mathewhaug"/> mathewhaug</a> <a href="#data-mathewhaug" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/kpomer"><img src="https://avatars.githubusercontent.com/u/25374403?v=4?s=100" width="100px;" alt="Kevin Pomer"/> Kevin Pomer</a> <a href="#data-kpomer" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/lglasbergen"><img src="https://avatars.githubusercontent.com/u/3315075?v=4?s=100" width="100px;" alt="Laurens Glasbergen"/> Laurens Glasbergen</a> <a href="#data-lglasbergen" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/natebru"><img src="https://avatars.githubusercontent.com/u/1214808?v=4?s=100" width="100px;" alt="Nate"/> Nate</a> <a href="#data-natebru" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/Reider1313"><img src="https://avatars.githubusercontent.com/u/288641639?v=4?s=100" width="100px;" alt="Reid Z"/> Reid Z</a> <a href="#data-Reider1313" title="Data">🔣</a></td>
 <td align="center" valign="top" width="14.28%"><a href="https://github.com/CrepuscularCremini"><img src="https://avatars.githubusercontent.com/u/101598531?v=4?s=100" width="100px;" alt="Brenn Anderson-Gregson"/> Brenn Anderson-Gregson</a> <a href="#data-CrepuscularCremini" title="Data">🔣</a></td>
 </tr>
 </tbody>
</table>

This project follows the [all-contributors](https://github.com/all-contributors/all-contributors) specification. Contributions of any kind welcome!

## 📊 Statistics

> Last updated: 2026-08-10

### Overview
- Total Breweries: 11,822
- Data Completeness: 79.0%

### 🏛 Top 10 States by Brewery Count
| State | Count |
|-------|-------|
| California | 919 |
| Bayern | 597 |
| Washington | 529 |
| Colorado | 449 |
| New York | 419 |
| Michigan | 375 |
| Texas | 352 |
| Pennsylvania | 345 |
| Florida | 312 |
| North Carolina | 311 |

### 🍺 Brewery Types Distribution
| Type | Count | Percentage |
|------|--------|------------|
| micro | 5,837 | 49.4% |
| brewpub | 3,929 | 33.2% |
| closed | 642 | 5.4% |
| planning | 640 | 5.4% |
| regional | 239 | 2.0% |
| contract | 210 | 1.8% |
| large | 137 | 1.2% |
| proprietor | 67 | 0.6% |
| taproom | 47 | 0.4% |
| bar | 41 | 0.3% |
| nano | 22 | 0.2% |
| cidery | 7 | 0.1% |
| beergarden | 3 | 0.0% |
| location | 1 | 0.0% |

### 🌆 Top 10 Cities by Brewery Count
| City | Count |
|------|--------|
| Seattle, Washington | 94 |
| Denver, Colorado | 92 |
| San Diego, California | 91 |
| Portland, Oregon | 85 |
| Chicago, Illinois | 64 |
| Toronto, Ontario | 53 |
| Austin, Texas | 49 |
| Berlin, Berlin | 41 |
| Houston, Texas | 40 |
| Auckland, Auckland | 40 |

### 🌍 By Country
| Country | Count | Percentage |
|---------|------------|------------|
| United States | 8,224 | 69.6% |
| Germany | 1,445 | 12.2% |
| Australia | 514 | 4.3% |
| Belgium | 478 | 4.0% |
| Canada | 283 | 2.4% |
| New Zealand | 243 | 2.1% |
| South Africa | 104 | 0.9% |
| Netherlands | 76 | 0.6% |
| Portugal | 72 | 0.6% |
| Ireland | 70 | 0.6% |
| Finland | 68 | 0.6% |
| England | 62 | 0.5% |
| South Korea | 61 | 0.5% |
| Poland | 34 | 0.3% |
| Singapore | 33 | 0.3% |
| Austria | 15 | 0.1% |
| Japan | 10 | 0.1% |
| Sweden | 10 | 0.1% |
| Scotland | 10 | 0.1% |
| Italy | 4 | 0.0% |
| France | 3 | 0.0% |
| Isle of Man | 2 | 0.0% |
| Ukraine | 1 | 0.0% |

### 📋 Data Completeness by Field
| Field | Completeness |
|-------|-------------|
| name | 100.0% |
| brewery_type | 100.0% |
| city | 100.0% |
| state_province | 100.0% |
| postal_code | 100.0% |
| country | 100.0% |
| address_1 | 94.0% |
| phone | 89.0% |
| website_url | 89.0% |
| longitude | 79.0% |
| latitude | 79.0% |
| address_2 | 3.0% |
| address_3 | 0.0% |

openbrewerydb

openbrewerydb Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

openbrewerydb

openbrewerydb Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README