Where U.S. Beer is Brewed

Across the United States, we’ve started to describe liquid in colors like straw, deep gold, copper, and red-brown. We even distinguish between light black and dark black—isn’t black just black? Not when you’re describing beer from the thousands of breweries that have sprung up in the last ten years. Microbrews are too big—now there are nano brews, which has quadrupled the breweries nationwide since 2007.

View Breweries by State in a full screen map

On the map above, you see each state, with a marker colored to match its current number of breweries. Click the “2017” in the lower left of the map to change years, or see the 10 and 20-year growth rates. Dig into the details in the map, or see below for the stories we found in the data.

Top 10 US States by Brewery Count

  1. California (981)
  2. Washington State (448)
  3. New York (420)
  4. Colorado (408)
  5. Michigan (402)
  6. Pennsylvania (352)
  7. Oregon (323)
  8. Florida (287)
  9. North Carolina (287)*
  10. Texas (279)
    * Technically, North Carolina is tied for eighth with Florida.

The most populous state in the country, California also leads the way in breweries. Its 981 is more than numbers two and three combined. That includes New York, the third-most populous state. California’s reign goes back as far as our data does. In 1984, California’s nine breweries accounted for over 20% of all US breweries tracked.

Many states have moved up and down in the rankings in the last 20 years. Colorado was second to California in 1997 and 2007 but slipped down to fourth in 2017. Oregon has also bumped down two notches in the last 10 years. It’s not that they haven’t grown—both states have more than tripled breweries during this time—but that they haven’t grown as fast as others.

New York, for example, climbed into the top three from the eighth spot in 2007. North Carolina jumped into the top 10 with an over 600% growth rate. To make room, others had to leave the top 10. Most notably is the state whose baseball team is called the Brewers. Wisconsin dropped 10 places in 10 years, from the fourth-most breweries in 2007 to #14 in 2017.

Of course, Wisconsinites might argue the state produces a lot of beer, even if its number of breweries haven’t kept up. That’s an important distinction to make. This map, and the data within it, covers individual breweries, not barrels of production. Since 11 brewers make over 90% of US beer, that map might not be quite as interesting.

Overall Growth in Breweries

California brewery growthThe growth in the number of breweries tells the story of proliferating microbrews. This is a nationwide trend that we see present in just about every state. You’ll see a chart for every state by clicking the marker above it on the map. For example, the one embedded here is California’s. The shape of many of these charts is similar, showing the pattern nationwide. While there was modest growth between 1997 and 2007, the greatest growth has come during the last ten years. In fact, the story becomes even clearer when we look at the national numbers by year instead of by decade.

Slight growth at the end of the 20th century turned to decline during the recession of the early 2000s. The number of breweries remained relatively flat until 2009 or 2010, the beginning of the increase that further spiked beginning in 2013.

The apparent recent drop in growth rate is actually due to incomplete data for 2017. The current count of breweries is as of the end of the first quarter, so it is reasonable to expect continued growth. In fact, we’re on pace to add 2,000 new breweries in one year, the first time that’s ever happened. If that pace continues, 2017 will add nearly double the number added in 2016.

Fastest Growing Brewery States

  1. Arkansas (900%)
  2. Alabama (740%)
  3. Virginia (680%)
  4. North Carolina (637%)
  5. Texas (620%)
  6. Florida (574%)
  7. Indiana (570%)
  8. North Dakota (566%)
  9. New York (545%)
  10. Minnesota (538%)

The growth rates listed above reference the last ten years, the time when most of the brewery growth has happened. As is the case with high percentage growth, many of these states had very few breweries in 2007. Arkansas, for example, had only four breweries in 2007 (the same number it had in 1997). Now Little Rock and Fayetteville lead the way and the entire state boasts 36 breweries. Similarly, Alabama jumped from five in 2007 (down from eight in 1997) to 37 in 2017.

Many on the list started above Arkansas and Alabama’s current levels in 2007, and still grew at rates close to those southern states. New York had 77 breweries in 2007 and now has over 400. Texas and Florida both decreased considerably between 1997 and 2007 but bounced back in a big way thanks to the national trend, now with 279 breweries in the Lone Star State and 287 Sunshine State breweries.

Perhaps most indicative of the nationwide growth is that the slowest growing states still doubled the number of breweries in ten years. Hawaii, with just a dozen breweries in 2007, now has 25. Brew-happy Wisconsin, which lost its spot in the top 10 overall, still added 132 breweries, a growth rate of 226%.

No matter the color of beer you drink, it’s clear that there are more options than ever. And that trend appears to be continuing, with more breweries than ever set to be added this year. So raise a pint of pilsner, porter, or IPA to thousands of US breweries, coast to coast.

How to Create a Customer Sales Map from Excel or Any CRM

Gain advanced insights on your business when you visualize your data analysis. You’re probably swimming in data, in Excel, Salesforce, or another CRM. Understand the story within your data by plotting it on a map. Any geographic information, from full addresses to names of regions can be converted to geo coordinates. Viewed spatially, you’ll get a whole other angle at your customers, leads, or assets data.

View Household income, average clustering in a full screen map

For example, the map above shows the median income for every county in the United States. Better yet, using clustering technology, we can get a summary of the underlying data at any zoom level. Now imagine that this contained your revenue by region or the spending power of your customers. Quickly, you’re able to see the most successful areas, in ways that are difficult or impossible when your data is sitting inside a spreadsheet or CRM.

Ready to map your customers? Let’s get started with the simple two step process.

1. Find Your Customer Locations

Before you can plot your customers on a map, you need to know where they live or work. This can come from many sources, and you likely have it already. If you don’t, you may be able to gather it from the data that you do have. The level of detail for location can vary, yet even non-granular data can provide good insights.

Some of the location data you may have about your customers includes:

  • Full address
  • Zip code
  • City name
  • County name
  • State name
  • Country name

Any of the above can be converted to geo coordinates. If you have none of the above, all is not lost. Here are two additional ideas for finding your customer’s locations:

  1. IP address: If they have visited your website, you have their IP address, or Internet Protocol address. This series of numbers identifies their computer, network, or internet service provider. Usually, these can be converted to at least a regional location. BatchGeo automatically detects and geolocates IP addresses in your data.
  2. Email address: Many companies collect the email address of customers when they create accounts or to send receipts for purchases. There are data enrichment companies, such as FullContact or Clearbit, that will take a list of email addresses and return name, location, and other data about the person behind the email address.

Once you have some location data, you can easily create a map from it.

2. Map Your Excel Data

Many companies keep customer data in Excel and other spreadsheets. Even if that’s not the “source of truth,” Excel is where many filter and analyze their data. That’s why BatchGeo has chosen spreadsheets as the primary way to get data into our mapping platform.

From within your spreadsheet program, highlight all your data, including the headers. Use Ctrl+C (Cmd+C on Mac) to copy the data. Then go to the Excel mapping tool on the BatchGeo homepage and put the data in the main box using Ctrl+V (Cmd+V on Mac) to paste.

The video above walks through a basic map, or you can find a full Excel mapping tutorial that walks through step by step.

View Example Sales Map in a full screen map

The result is a map with a marker for every row in your spreadsheet. In the case of the map above, we used aggregated state-level data, but you could show individual customers or leads. Any data that has a location is fair game for a map.

Export Data From Your CRM

Many times the source of truth for customer data is in one or more systems, such as customer relationship management (CRM) software. You’ll frequently want to use this data outside of your CRM, such as when you want to create mail/email campaigns, analyze in Excel, or create a map from the data.

Any good CRM should have the ability to export your data. If it doesn’t, you should probably get a new CRM, even though it will take a lot of effort to duplicate your existing data (since you can’t export). You might ask about an API (Application Programmer Interface), which is a more technical option to get your data. Unless you’re a programmer, you’ll need someone else to use it, but an API often means there are existing tools that others have wrote to help you retrieve your data.

The most common file formats when exporting from your CRM are:

  • CSV (Comma-separated values)
  • Tab-delimited
  • Excel

Any of the above will work to create a map using BatchGeo. Excel can read or import any of those file types, then you can copy from the spreadsheet as described above in step 2.

How you export will vary depending on the software you use. For example, in Salesforce you would use the Data Loader export wizard to create a CSV to download. You should be able to search the help section of your CRM or ask for technical support to help export your data.

Make Your Customer Map Today

Start uncovering the story behind your customer data. Create a map now with a simple copy-paste of your spreadsheet or CRM data.

Which Country Has the Most Christians, Muslims, Atheists, and More

Religion may be a touchy subject, but that’s because it’s filled with a lot of feeling. As much as 80% of the world identifies with a religion, most of which have hundreds or thousands of years of history. Rather than feeling, this post is brimming with data. We’ve mapped every country in the world below, along with the religious demographics of each country. Using the grouping features of BatchGeo, you can explore the rich dataset visually, the best way to understand the details behind the data.

View Religions by Country in a full screen map

For example, click the button in the lower left of the map, currently labeled “Region.” You can choose any of the various fields of data to zero in on a religion, region, or other field. Better yet, you can mix and match, to answer questions like “what religion is most popular in countries with the most people who don’t affiliate with a religion?” You can find the answer by selecting Unaffiliated, choosing the highest range, then looking at the ranges still available as you choose the other fields. You’ll find Buddhism and Folk Religions about equal with unaffiliated in a handful of Asian countries. There are also a number of Christian countries, especially in Europe, with large numbers of unaffiliated people.

There are many ways to go through the data yourself (based on this Wikipedia page). We’ll cover the highlights by religion below.

Christianity Around the World

Christianity is the most widespread religion in the world, with 157 countries with a majority who identify as Christian. There are 2.1 billion Christians, almost one third of the the world population. The United States has the most number of Christians by whole numbers, with nearly 250 million. Brazil (173M), Mexico (107M), and Russia (104M) join the U.S. in the hundreds of millions of Christians.

Yet, percentage-wise, none of those countries even make the top 25 Christian nations in terms of percentages. There are five countries with 99% or higher rate of Christianity, with one country reaching 100%. Once you know it, you won’t be surprised: Vatican City (within Italy, but officially a country), home of the Pope, has 800 residents, every single one a Christian. The other countries with at least 99% Christians are Tokelau (99.8%) in Polynesia, Timor-Leste (99.6%) in Southeastern Asia, Romania (99.5%), and Papua New Guinea (99.2%). While Tokelau has a small population (1,400), the others are over a million each, with Romania at over 20 million.

While Christianity is spread throughout the world more than other religions, there are clumps of high percentage practitioners. Latin America, the South Pacific, Southern Africa, and Europe all have multiple countries with at least 90% Christian residents.

On the flip side, there are many countries with only a very few Christians. Somalia, with a population of over 9 million, is home to 100 Christians, or one-thousandth of a percent of the population. Most of its citizens are Muslim, as are other countries with few Christians, including Morocco, Afghanistan, Tunisia, and Yemen.

Islam Around the World

Islam is the religion practiced by Muslims, and it is second only to Christianity in popularity worldwide. There are 1.5 billion Muslims, accounting for 23% of the world. There are 49 majority Muslim countries, making Islam and Christianity the only religions with more than 10 countries with majority populations.

Indonesia has over 200 million Muslims, more than any other country. Others with 100 million or more are India (176M), Pakistan (167M), and Bangladesh (133M). Only one of these, Pakistan, is top 25 in percentages. It has the 23rd most Muslims by percentage. Nine countries have 99% or more of their population practicing Islam: Morocco (99.9%), Somalia (99.8%), Afghanistan (99.7%), Iran (99.5%), Tunisia (99.5%), Yemen (99.1%), Mauritania (99.1%), Northern Cyprus (99%), and Iraq (99%). With the exception of Northern Cyprus, these countries have populations ranging from 3.4 million to over 70 million.

Unsurprisingly, the countries with the highest number of Muslims are clustered in the Middle East, including Northern Africa and into Central Asia. By contrast, there are 45 countries that apparently have no Muslims. The lowest number reported is Falkland Islands with nine Muslims, which makes up 0.3% of the South American country.

Hinduism Around the World

Though it doesn’t get the television news coverage of Christianity and Islam, Hinduism is the religion of over a billion people, or 15% of the world population. Yet, most of them live in one country.

The vast majority of Hindus live in India, where 973 million people make up almost 80% of the country’s people. The rest of the top five include Nepal (24M), Bangladesh (13M), Indonesia (4M), and Pakistan (3.2M). Among those, Nepal barely tops India in terms of percentage Hindu. Nearly 81% of Nepalese are Hindu. Only one other country is majority Hindu, Mauritius, in Eastern Africa.

Buddhism Around the World

The religion of Buddha is the fourth-most popular religion, the practice of just under 500,000 worldwide. While not in the billions like the others, that’s still 7% of the population. While more than half of Buddhists live in China (244M), there are several other countries with many that follow The Buddha. The top five are rounded out with Thailand (64M), Japan (45M), Burma (38M), and Vietnam (15M).

In terms of percentages, a couple of those same countries make the list. Cambodia is first percentage-wise, at 96.9%. It’s also the sixth-most in total numbers. Thailand (93.2%), Burma (80.1%), Bhutan (74.7%), and Sri Lanka (69.3%) fill out the top five. Only two others, Laos and Mongolia, are majority Buddhist. As is likely obvious from the list, Buddhism is most popular in Southern and Southeast Asia.

Folk Religions Around the World

Unlike the other religions on the map, this group is made up of many small religions based on cultural or ethnic elements. These folk religions, as they are known, are separate from organized religions, though they may borrow some elements of one or more popular religions.

There are about 400,000 people who practice a folk religion. While that’s a small number compared to the major religions, it’s still nearly 6% of the world population. The bulk of the practitioners are in China (293M), where folk religions make up over 20% of its population. There are 5 million or more in four other countries: Vietnam (42M), Taiwan (10M), India (6M), and Brazil (5M). Macau in Eastern Asia is the only country that is a majority folk religion (58.9%). Vietnam (45%) and Taiwan (44%) are nearly so.

Judaism Around the World

The last on the list of affiliated religions is Judaism. There are 13 million Jewish people in the world, accounting for just one-fifth of a percent of the worldwide population. The United States and Israel are home to most of those 13 million, with just over 5 million each. The bottom three countries of the top five are Canada, France, and the United Kingdom, each with around 300,000 followers of Judaism.

Beyond the 75% of Israel that is Jewish, most countries have 2% or fewer. While over 150 countries report no Jewish people, Afghanistan has one. Zablon Simintov lives alone next to the only synagogue in the country and has received special permission to slaughter his own meat since there are no kosher butchers in Afghanistan.

Atheism and Unaffiliated Religions Around the World

We’re listing unaffiliated religions last, though together this group is 1.1 billion people, about 16% of the world population. However, unaffiliated does not mean atheist, agnostic, or even non-spiritual, though those are all included. Rather, it’s a catch-all for anyone who does not identify with a specific religion.

Nearly 700 million of those who do not affiliate with a religion live in China, which accounts for a narrow majority of its citizens (52%). Japan (72M), France (50M), Vietnam (28M), and Russia (23M) also have high numbers of unaffiliated. Other majority unaffiliated countries include Czech Republic (76%), North Korea (71%), Estonia (59%), Japan (57%), and Hong Kong (56%). Eastern Asia and Europe are the most popular regions for being areligious.

Again, not having a religion is not the same as atheism, which is a disbelief in any God. According to some studies, the most atheist country is France, with 40% claiming there is no “spirit, God, or life force.” Those numbers don’t quite measure up with the unaffiliated data in the map above, which shows France at 28% unaffiliated (63% Christian and 7.5% Muslim). It’s possible someone might affiliate with a religion while not believing its teachings.

Nevertheless, the data shown on the map above provides a glimpse into how the seven billion people on earth think about religion. There are many more insights to be had in the large version of the world religion map.