Church to bar ratio by county from U.S. Census Bureau data:
The brighter the color, the higher the church to bar ratio. Counties missing data necessary for the computation are shown in black.
From the 2011 County Business Patterns data published at http://www.census.gov/econ/cbp/download/index.htm, I extracted the number of establishments in each county that have NAICS codes 813110 (places of worship including churches, temples, mosques, synagogues, etc.) and 722410 (bars, taverns, drink-serving nightclubs, etc.). For each county, I then divided the number of NAICS 813110 establishments by the number of NAICS 722410 establishments to get the “church to bar ratio”. Before dividing I added one to each value to prevent division by zero errors. Finally, I partitioned the resulting ratio distribution into nine color groups, and plotted each county’s ratio color on the map. I used log-transformed values when creating the partitions. Counties missing both NAICS codes in the source data are shown in black on the map. Source code implementing these calculations is available at the link given below, to facilitate peer review.
Possible bias in the result
If NAICS code 813110 excludes church facilities with unpaid staff and clergy—i.e., if the Census Bureau does not to consider them “places of industry” since no one is getting paid to work there—the LDS presence in the west will be severely underrepresented. This warrants further review of NAICS measurement methodology before producing future map updates. Reader comments on the appropriateness of NAICS industry codes for this study are very welcome!
I used SAS to match the data necessary for the ratio computation, and Python to plot the map. Source code for these procedures is given on the Badass Data Science wiki at http://badassdatascience.com/wiki/index.php?title=2011_Church_to_Bar_Ratio_Calculation.