Beer_location.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "%matplotlib inline\n",
    "import matplotlib.pyplot as plt\n",
    "import pandas as pd\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Dependencies\n",
    "import json\n",
    "import os\n",
    "\n",
    "# Load JSON\n",
    "filepath = os.path.join(\"data\", \"open-beer-database-breweries.json\")\n",
    "with open(filepath) as jsonfile:\n",
    "    beer_json = json.load(jsonfile)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>brewery_name</th>\n",
       "      <th>Country</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [City, State, brewery_name, Country, Latitude, Longitude]\n",
       "Index: []"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "beer_jsondf = pd.DataFrame(columns=['City','State','brewery_name','Country','Latitude','Longitude'])\n",
    "beer_jsondf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Valparaiso\n",
      "Aberdeen Brewing\n",
      "41.4392\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Salisbury\n",
      "Missing field/result... skipping.\n",
      "Whitewater\n",
      "Randy's Fun Hunters Brewery Restaurant and Banquet Center\n",
      "42.832\n",
      "Minnetonka\n",
      "Sherlock's Home\n",
      "44.9133\n",
      "San Francisco\n",
      "Speakeasy Ales and Lagers\n",
      "37.7387\n",
      "Missoula\n",
      "Bayern Brewing\n",
      "46.8726\n",
      "Berkeley\n",
      "Bison Brewing\n",
      "37.8634\n",
      "Ithaca\n",
      "Ithaca Beer Company\n",
      "42.4145\n",
      "Amana\n",
      "Millstream Brewing\n",
      "41.7972\n",
      "San Antonio\n",
      "Pabst Brewing Company\n",
      "29.43\n",
      "Portsmouth\n",
      "Smuttynose Brewing Co.\n",
      "43.0325\n",
      "North Vancouver\n",
      "Taylor's Crossing Brewing\n",
      "49.3238\n",
      "Missing field/result... skipping.\n",
      "Iron River\n",
      "White Winter Winery\n",
      "47.3812\n",
      "Madison\n",
      "Ale Asylum\n",
      "43.1257\n",
      "Allentown\n",
      "Allentown Brew Works\n",
      "40.6016\n",
      "Louisville\n",
      "Cumberland Brewery\n",
      "38.2309\n",
      "Missing field/result... skipping.\n",
      "Marblehead\n",
      "Frontwaters Restaurant and Brewing\n",
      "41.5403\n",
      "Saint John\n",
      "Moosehead Breweries\n",
      "45.2567\n",
      "Milwaukee\n",
      "Stout Brothers Public House\n",
      "43.0389\n",
      "Duluth\n",
      "Fitger's Brewhouse, Brewery and Grill\n",
      "46.7926\n",
      "Alexandria\n",
      "Founder's Restaurant & Brewing\n",
      "38.8048\n",
      "Sacramento\n",
      "Hoppy Brewing Company\n",
      "38.5551\n",
      "Novato\n",
      "Moylan's Brewery & Restaurant\n",
      "38.0941\n",
      "Boulder\n",
      "Oasis Brewery and Restaurant\n",
      "40.015\n",
      "Carleton Place\n",
      "Scotch Irish Brewing\n",
      "45.1279\n",
      "Centreville\n",
      "Sweetwater Tavern - Centreville\n",
      "38.8289\n",
      "San Marcos\n",
      "The Lost Abbey\n",
      "33.1406\n",
      "Henley-on-Thames\n",
      "WH Brakspear & Sons\n",
      "51.5375\n",
      "Watertown\n",
      "Bellows Brew Crew\n",
      "43.1947\n",
      "Gaylord\n",
      "Big Buck Brewery\n",
      "45.0223\n",
      "Montreal\n",
      "Brasserie McAuslan\n",
      "45.4682\n",
      "Achel\n",
      "Brouwerij De Achelse Kluis\n",
      "51.2986\n",
      "Kobbegem\n",
      "Brouwerij De Keersmaeker\n",
      "50.9098\n",
      "New York\n",
      "Heartland Brewery Union Square\n",
      "40.7323\n",
      "Fairfax\n",
      "Iron Springs Pub & Brewery\n",
      "37.986\n",
      "Loveland\n",
      "Namaqua Brewing\n",
      "40.3978\n",
      "Fort Wayne\n",
      "Oyster Bar Bistro and Brewery\n",
      "41.1475\n",
      "La Crosse\n",
      "Pearl Street Brewery\n",
      "43.8344\n",
      "Pittsburgh\n",
      "Pennsylvania Brewing\n",
      "40.4569\n",
      "Fairfax\n",
      "Ross Valley Brewing\n",
      "37.9871\n",
      "LaPorte\n",
      "Back Road Brewery\n",
      "41.6124\n",
      "Williamsport\n",
      "Bavarian Barbarian Brewing Company\n",
      "41.238\n",
      "Ravensburg\n",
      "Brauerei Leibinger\n",
      "47.7818\n",
      "Lembeek\n",
      "Brouwerij Boon\n",
      "50.7123\n",
      "Einbeck\n",
      "Einbecker Brauhaus AG\n",
      "51.8162\n",
      "Vista\n",
      "Green Flash Brewing\n",
      "33.136\n",
      "Missing field/result... skipping.\n",
      "Wallsend\n",
      "Mordue Brewery\n",
      "55.0167\n",
      "San Diego\n",
      "On Tap Bistro & Brewery\n",
      "32.7153\n",
      "Frankfurt/Main\n",
      "Missing field/result... skipping.\n",
      "Edinburgh\n",
      "Scottish & Newcastle PLC\n",
      "55.9465\n",
      "La Crosse\n",
      "Tap Room Brewing Company\n",
      "43.8014\n",
      "Healdsburg\n",
      "Bear Republic Brewery\n",
      "38.6112\n",
      "Missing field/result... skipping.\n",
      "Merchtem-Peizegem\n",
      "Brouwerij De Block\n",
      "50.985\n",
      "Tadcaster\n",
      "Courage Brewery\n",
      "53.8846\n",
      "Fortuna\n",
      "Eel River Brewing\n",
      "40.5793\n",
      "Seattle\n",
      "Elliott Bay Brewery and Pub\n",
      "47.5604\n",
      "New York Mills\n",
      "Glacial Lakes Brewing\n",
      "46.518\n",
      "Ocean\n",
      "Heavyweight Brewing\n",
      "39.9653\n",
      "Ipswich\n",
      "Mercury Brewing Company\n",
      "42.6728\n",
      "Monroe\n",
      "Minhas Craft Brewery\n",
      "42.6001\n",
      "Krebs\n",
      "Pete's Place\n",
      "34.9251\n",
      "Whitsett\n",
      "Red Oak Brewery\n",
      "36.0613\n",
      "Sydney\n",
      "Tooth's\n",
      "-33.8671\n",
      "Eugene\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Saint Paul\n",
      "Green Mill Brewing - Saint Paul\n",
      "44.9398\n",
      "Midvale\n",
      "Hoppers Seafood & Grill\n",
      "40.6215\n",
      "San Francisco\n",
      "Magnolia Pub and Brewery\n",
      "37.7702\n",
      "Lake Barrington\n",
      "Onion Pub & Brewery\n",
      "42.1865\n",
      "San Marcos\n",
      "San Marcos Brewery & Grill\n",
      "33.1345\n",
      "Lake Oswego\n",
      "Saxer Brewing\n",
      "45.4207\n",
      "Melbourne\n",
      "Charlie and Jake's Brewery and BBQ\n",
      "28.2126\n",
      "Ruiselede\n",
      "De Leyerth Brouwerijen\n",
      "51.0811\n",
      "Downers Grove\n",
      "Founders Hill Brewing\n",
      "41.8089\n",
      "Missing field/result... skipping.\n",
      "Erpe-Mere\n",
      "Kleinbrouwerij de Glazen Toren\n",
      "50.9193\n",
      "Lake Placid\n",
      "Lake Placid Pub & Brewery\n",
      "44.2829\n",
      "Pensacola\n",
      "McGuire's Irish Pub and Brewery - Pensacola\n",
      "30.4181\n",
      "Fulton\n",
      "Moonlight Brewing\n",
      "38.498\n",
      "Conestoga\n",
      "Spring House Brewing Company\n",
      "39.9525\n",
      "Nederland\n",
      "Wolf Tongue Brewery\n",
      "39.9619\n",
      "Nashville\n",
      "Yazoo Brewing\n",
      "36.151\n",
      "Blaugies\n",
      "Brasserie de Blaugies\n",
      "50.3693\n",
      "Kenosha\n",
      "Brewmasters Restaurant and Brewery South\n",
      "42.5847\n",
      "Mechelen\n",
      "Brouwerij Het Anker\n",
      "51.0325\n",
      "Biloxi\n",
      "Coast Brewing\n",
      "30.396\n",
      "Mount Horeb\n",
      "Grumpy Troll Restaurant and Brewery\n",
      "43.0081\n",
      "Minneapolis\n",
      "Herkimer Pub & Brewery\n",
      "44.9491\n",
      "Woodbridge\n",
      "JJ Bitting Brewing\n",
      "40.5549\n",
      "Saint Louis\n",
      "Saint Louis Brewery / Schlafy Tap Room\n",
      "38.633\n",
      "San Francisco\n",
      "Shmaltz Brewing Company\n",
      "37.7749\n",
      "Southampton\n",
      "Southampton Publick House\n",
      "40.8903\n",
      "Tampa\n",
      "Stroh Brewery Company\n",
      "27.9494\n",
      "Canning Vale\n",
      "Swan Brewery\n",
      "-32.0638\n",
      "Innerleithen\n",
      "Traquair House Brewery\n",
      "55.619\n",
      "Boonville\n",
      "Anderson Valley Brewing\n",
      "39.0014\n",
      "Saint Louis\n",
      "Anheuser-Busch\n",
      "38.5983\n",
      "Strongsville\n",
      "Brew Kettle Taproom & Smokehouse BOP\n",
      "41.347\n",
      "Ingelmunster\n",
      "Brouwerij Van Honsebrouck\n",
      "50.9201\n",
      "Cedar Rapids\n",
      "Cedar Brewing\n",
      "41.9625\n",
      "Marina\n",
      "English Ales Brewery\n",
      "36.6802\n",
      "Fort Collins\n",
      "Fort Collins Brewery\n",
      "40.5832\n",
      "London\n",
      "Fuller, Smith & Turner PBC\n",
      "51.4877\n",
      "Cambridge\n",
      "John Harvard's Brew House - Harvard Square\n",
      "42.3724\n",
      "Lake Delton\n",
      "Pumphouse Pizza and Brewing\n",
      "43.6011\n",
      "Mount Pleasant\n",
      "T-Bonz Gill, Grill and Brewery\n",
      "32.8091\n",
      "La Crosse\n",
      "Missing field/result... skipping.\n",
      "Batavia\n",
      "Cugino Brewing Company\n",
      "41.8539\n",
      "Melmerby\n",
      "Hambleton Ales\n",
      "54.1744\n",
      "London\n",
      "Labatt Ontario Breweries\n",
      "42.9778\n",
      "Eugene\n",
      "Ninkasi Brewing\n",
      "44.0569\n",
      "Greenwood\n",
      "Oaken Barrel Brewing\n",
      "39.615\n",
      "Minneapolis\n",
      "Missing field/result... skipping.\n",
      "Asheville\n",
      "Missing field/result... skipping.\n",
      "Chicago\n",
      "Black Toad Brewing Company\n",
      "41.8817\n",
      "Roeselare\n",
      "Brouwerij Rodenbach\n",
      "50.9462\n",
      "Surrey\n",
      "Central City Brewing Company\n",
      "49.1873\n",
      "Baltimore\n",
      "Clipper City Brewing Co.\n",
      "39.2308\n",
      "Des Moines\n",
      "Court Avenue Brewing\n",
      "41.5855\n",
      "Missing field/result... skipping.\n",
      "Wasilla\n",
      "Great Bear Brewing\n",
      "61.5816\n",
      "Idaho Falls\n",
      "Idaho Brewing\n",
      "43.4666\n",
      "Austin\n",
      "Independence Brewing Co\n",
      "30.2131\n",
      "Perth\n",
      "Inveralmond Brewery\n",
      "56.4174\n",
      "Chippewa Falls\n",
      "Jacob Leinenkugel Brewing Company\n",
      "44.9449\n",
      "Berkeley\n",
      "Pyramid Alehouse, Brewery and Restaurant - Berkeley\n",
      "47.5917\n",
      "St. Mary's\n",
      "Straub Brewery\n",
      "41.4277\n",
      "Ipswich\n",
      "Tollemache and Cobbold Brewery\n",
      "52.0593\n",
      "Bethlehem\n",
      "Bethlehem Brew Works\n",
      "40.622\n",
      "Calgary\n",
      "Big Rock Brewery\n",
      "50.9847\n",
      "Missing field/result... skipping.\n",
      "Dresden\n",
      "Missing field/result... skipping.\n",
      "San Leandro\n",
      "Drake's Brewing\n",
      "37.7176\n",
      "Santa Rosa\n",
      "Kelmer's Brewhouse\n",
      "38.4405\n",
      "Duisburg\n",
      "Knig Brauerei\n",
      "51.5314\n",
      "Duncansville\n",
      "Marzoni's Brick Oven & Brewing Co\n",
      "40.4234\n",
      "Greensburg\n",
      "Red Star Brewery & Grille\n",
      "40.3044\n",
      "Waukesha\n",
      "Remington Watson Smith Brewing\n",
      "43.0117\n",
      "Millers Falls\n",
      "Missing field/result... skipping.\n",
      "Richmond\n",
      "Big River Brewing\n",
      "49.1344\n",
      "Soy\n",
      "Brasserie Fantme\n",
      "50.286\n",
      "Anderlecht\n",
      "Brasserie-Brouwerij Cantillon\n",
      "50.8416\n",
      "Frederick\n",
      "Frederick Brewing\n",
      "39.3628\n",
      "Philadelphia\n",
      "Independence Brew Pub\n",
      "39.9526\n",
      "Glen Mills\n",
      "McKenzie Brew House\n",
      "39.8658\n",
      "Saratoga Springs\n",
      "Mendocino Brewing - Saratoga Springs\n",
      "43.0831\n",
      "Las Vegas\n",
      "Monte Carlo Casino and Brewpub\n",
      "36.1286\n",
      "San Francisco\n",
      "Shmaltz Enterprises\n",
      "37.7481\n",
      "Missing field/result... skipping.\n",
      "San Ramon\n",
      "The Hop Yard\n",
      "37.7839\n",
      "Harrisburg\n",
      "Troegs Brewing\n",
      "40.2559\n",
      "Miesbach\n",
      "Weissbierbrauerei Hopf\n",
      "47.794\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Rock Island\n",
      "Blue Cat Brew Pub\n",
      "41.5118\n",
      "Missing field/result... skipping.\n",
      "Harrogate\n",
      "Daleside Brewery\n",
      "53.9999\n",
      "Traunstein\n",
      "Hofbruhaus Traunstein\n",
      "47.8691\n",
      "Marion\n",
      "Lang Creek Brewry\n",
      "48.014\n",
      "Latrobe\n",
      "Latrobe Brewing\n",
      "40.3212\n",
      "Charleston\n",
      "Palmetto Brewing\n",
      "32.8017\n",
      "Missing field/result... skipping.\n",
      "Manitowoc\n",
      "Courthouse Pub\n",
      "44.0886\n",
      "Kilegg\n",
      "Missing field/result... skipping.\n",
      "Bamberg\n",
      "Heller Bru Trum\n",
      "49.892\n",
      "Hartford\n",
      "Rothaus Brauerei\n",
      "43.3178\n",
      "Scottsdale\n",
      "Sonoran Brewing Company\n",
      "33.7268\n",
      "Stuttgart\n",
      "Missing field/result... skipping.\n",
      "Fredrick\n",
      "Wild Goose Brewery, LLC\n",
      "39.3628\n",
      "Asheville\n",
      "Asheville Pizza and Brewing Co.\n",
      "35.6221\n",
      "Manchester\n",
      "Boddington's Brewery\n",
      "53.4807\n",
      "Los Angeles\n",
      "Bonaventure Brewing Co\n",
      "34.0532\n",
      "Sint-Pieters-Leeuw\n",
      "Brasserie de la Senne\n",
      "50.7853\n",
      "Quenast\n",
      "Brasserie Lefebvre\n",
      "50.6746\n",
      "Tacoma\n",
      "Engine House #9\n",
      "47.256\n",
      "Bury St. Edmunds\n",
      "Greene King\n",
      "52.241\n",
      "Suisun City\n",
      "Grizzly Bay Brewing\n",
      "38.2382\n",
      "Modesto\n",
      "Hornsby's Pubdrafts Ltd.\n",
      "37.6345\n",
      "Klamath Falls\n",
      "Mia and Pia's Pizzeria and Brewhouse\n",
      "42.2249\n",
      "Littleton\n",
      "Mill Steakhouse\n",
      "39.612\n",
      "Holyoke\n",
      "Paper City Brewing Company\n",
      "42.2012\n",
      "Newcastle-upon-Tyne\n",
      "Scottish & Newcastle Breweries\n",
      "40.8918\n",
      "Berkeley Heights\n",
      "Trap Rock Restaurant and Brewery\n",
      "40.6892\n",
      "Fuquay Varina\n",
      "Aviator Brewing Company\n",
      "35.6197\n",
      "Amherst\n",
      "Amherst Brewing Company\n",
      "42.3763\n",
      "Long Valley\n",
      "Long Valley Pub & Brewery\n",
      "40.7843\n",
      "Aberdeen\n",
      "Pinehurst Village Brewery\n",
      "35.1315\n",
      "Solon\n",
      "Stone City Brewing\n",
      "41.8072\n",
      "Eugene\n",
      "Missing field/result... skipping.\n",
      "Detroit\n",
      "Atwater Block Brewing\n",
      "42.3372\n",
      "San Francisco\n",
      "Beach Chalet Brewery\n",
      "37.7694\n",
      "Missing field/result... skipping.\n",
      "Baltimore\n",
      "DuClaw\n",
      "39.2807\n",
      "Cleveland\n",
      "Great Lakes Brewing\n",
      "41.4844\n",
      "Portland\n",
      "Hair of the Dog Brewing\n",
      "45.4901\n",
      "Lafayette\n",
      "Lafayette Brewing\n",
      "40.4194\n",
      "Mossautal\n",
      "Privat-Brauerei Schmucker Ober-Mossau KG\n",
      "49.6747\n",
      "Missing field/result... skipping.\n",
      "Watou\n",
      "Brouwerij Van Eecke\n",
      "50.8612\n",
      "San Rafael\n",
      "California Cider Company\n",
      "37.9735\n",
      "Missing field/result... skipping.\n",
      "Berkeley\n",
      "Golden Pacific Brewing\n",
      "37.8716\n",
      "Bloomington\n",
      "Illinois Brewing\n",
      "40.4787\n",
      "Cockermouth\n",
      "Jennings Brewery\n",
      "54.6649\n",
      "Toronto\n",
      "Lwenbru Munich\n",
      "43.7379\n",
      "Oakland\n",
      "Pacific Coast Brewing\n",
      "37.8016\n",
      "Missing field/result... skipping.\n",
      "Kahului\n",
      "Sharktooth Brewing\n",
      "20.8947\n",
      "Missing field/result... skipping.\n",
      "Tokyo\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "San Martin\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Kln\n",
      "Brauhaus Sion\n",
      "50.9394\n",
      "Elk Grove\n",
      "Elk Grove Brewery & Restaurant\n",
      "38.4093\n",
      "Sanctuary Cove\n",
      "Gold Coast Brewery\n",
      "-27.8539\n",
      "Missing field/result... skipping.\n",
      "Pont Fer\n",
      "Phoenix Beverages Ltd\n",
      "-20.2738\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Toronto\n",
      "Steam Whistle Brewery\n",
      "43.6414\n",
      "Roseburg\n",
      "Umpqua Brewing\n",
      "43.2165\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Bend\n",
      "Deschutes Brewery\n",
      "44.0474\n",
      "Dorchester\n",
      "Missing field/result... skipping.\n",
      "Koblenz\n",
      "Knigsbacher Brauerei\n",
      "50.3216\n",
      "Missing field/result... skipping.\n",
      "Niles\n",
      "Ohio Brewing\n",
      "41.1828\n",
      "Missing field/result... skipping.\n",
      "San Diego\n",
      "Taylor's Restaurant and Brewery\n",
      "32.7153\n",
      "Galesburg\n",
      "Bell's Brewery Inc.\n",
      "42.2843\n",
      "Moline\n",
      "Bent River Brewing\n",
      "41.5059\n",
      "Las Vegas\n",
      "Big Dog's Brewing Company\n",
      "36.2426\n",
      "Villers-devant-Orval\n",
      "Missing field/result... skipping.\n",
      "Esen\n",
      "Brouwerij De Dolle Brouwers\n",
      "51.0281\n",
      "Centralia\n",
      "Dick's Brewing\n",
      "46.7713\n",
      "Pittsburgh\n",
      "The Church Brew Works\n",
      "40.4624\n",
      "Missing field/result... skipping.\n",
      "Idaho Springs\n",
      "Tommyknocker Brewery and Pub\n",
      "39.7418\n",
      "Ichtegem\n",
      "Brouwerij Strubbe\n",
      "51.0923\n",
      "Las Vegas\n",
      "Main Street Station Casino, Brewery and Hotel\n",
      "36.1755\n",
      "North Fremantle\n",
      "Matilda Bay Brewing\n",
      "-32.0232\n",
      "Bellegem\n",
      "Brouwerij Bockor\n",
      "50.7767\n",
      "Missing field/result... skipping.\n",
      "Issum\n",
      "Diebels Privatbrauerei\n",
      "51.5331\n",
      "Green Bay\n",
      "Legends Brewhouse & Eatery of Green Bay\n",
      "44.5534\n",
      "Flagstaff\n",
      "Mogollon Brewing Company\n",
      "35.2156\n",
      "Springfield\n",
      "Springfield Brewing\n",
      "37.2079\n",
      "Superior\n",
      "Twin Ports Brewing\n",
      "46.7208\n",
      "Westminster\n",
      "Wachusetts Brewing Company\n",
      "42.5586\n",
      "Middlebury\n",
      "Green Mountain Beverage\n",
      "44.0344\n",
      "Minocqua\n",
      "Minocqua Brewing Company\n",
      "45.8722\n",
      "Brooklyn\n",
      "Sixpoint Craft Ales\n",
      "40.674\n",
      "Anchorage\n",
      "Sleeping Lady Brewing Company\n",
      "61.2196\n",
      "Athens\n",
      "Terrapin Beer Company\n",
      "33.9459\n",
      "Qingdao\n",
      "Tsingtao\n",
      "36.0663\n",
      "Monroe\n",
      "Twin Rivers Brewing\n",
      "47.8559\n",
      "Missing field/result... skipping.\n",
      "St. Louis\n",
      "Missing field/result... skipping.\n",
      "Chalfont\n",
      "Crabby Larry's Brewpub Steak & Crab House\n",
      "40.2795\n",
      "Lincoln\n",
      "Crane River Brewpub and Cafe\n",
      "40.8069\n",
      "McHenry\n",
      "Deep Creek Brewing\n",
      "39.5584\n",
      "Dortmund\n",
      "Dortmunder Actien Brauerei  DAB\n",
      "51.5298\n",
      "Chicago\n",
      "Golden Prairie Brewing\n",
      "41.9273\n",
      "Durham\n",
      "Lanchester Brewing\n",
      "54.8229\n",
      "Blue Lake\n",
      "Mad River Brewing\n",
      "40.879\n",
      "Corona\n",
      "Main Street Brewery\n",
      "33.8835\n",
      "Hopland\n",
      "Mendocino Brewing - Hopland\n",
      "38.9734\n",
      "Foothill Ranch\n",
      "ReaperAle\n",
      "33.6864\n",
      "Monroeville\n",
      "Rivertowne Pour House\n",
      "40.4465\n",
      "River Falls\n",
      "Rush River Brewing\n",
      "44.8902\n",
      "Santa Rosa\n",
      "Santa Rosa Brewing\n",
      "38.4405\n",
      "Dallas\n",
      "Schooner Brewery\n",
      "32.803\n",
      "Salida\n",
      "Amicas Pizza, Microbrews and More\n",
      "38.535\n",
      "Mooresville\n",
      "Carolina Beer Company\n",
      "35.6231\n",
      "Missing field/result... skipping.\n",
      "Hood River\n",
      "Double Mountain Brewery & Taproom\n",
      "45.71\n",
      "Reedsburg\n",
      "EndeHouse Brewery and Restaurant\n",
      "43.5325\n",
      "Las Cruces\n",
      "High Desert Brewing Co.\n",
      "32.3096\n",
      "Slippery Rock\n",
      "North Country Brewery\n",
      "41.0638\n",
      "Blanco\n",
      "Real Ale Brewing Company\n",
      "30.113\n",
      "Pittsburgh\n",
      "Wainwright Brewing\n",
      "40.4616\n",
      "Marktoberdorf\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Goze\n",
      "Brasserie Val de Sambre\n",
      "50.3682\n",
      "Hoogstraten-Meer\n",
      "Brouwerij Sterkens\n",
      "51.4439\n",
      "Cheyenne\n",
      "C.B. & Potts of Cheyenne\n",
      "41.1607\n",
      "Albany\n",
      "C.H. Evans Brewing Company\n",
      "42.6542\n",
      "Missing field/result... skipping.\n",
      "Central City\n",
      "Dostal Alley\n",
      "39.8019\n",
      "Elgin\n",
      "Prairie Rock Brewing - Elgin\n",
      "42.0347\n",
      "Bangalore\n",
      "Sabmiller India,\n",
      "12.9683\n",
      "McKinleyville\n",
      "Six Rivers Brewery\n",
      "40.9491\n",
      "Bonduel\n",
      "Slab City Brewing\n",
      "44.7403\n",
      "Munster\n",
      "Three Floyds Brewing\n",
      "41.5354\n",
      "Warstein\n",
      "Warsteiner Brauerei\n",
      "51.4416\n",
      "Greenville\n",
      "Blue Ridge Brewing\n",
      "34.8531\n",
      "Burton-upon-Trent\n",
      "Burton Bridge Brewery\n",
      "52.8065\n",
      "Marshall\n",
      "Dark Horse Brewing Co.\n",
      "42.2667\n",
      "Encinitas\n",
      "Red Kettle Brewing\n",
      "33.037\n",
      "Sterling\n",
      "Sweet Water Tavern and Brewery\n",
      "39.0324\n",
      "Missing field/result... skipping.\n",
      "Auburn\n",
      "American River Brewing\n",
      "38.8966\n",
      "Missing field/result... skipping.\n",
      "Kln\n",
      "Clner Hofbrau Frh\n",
      "50.9401\n",
      "Pittsburgh\n",
      "East End Brewing Company\n",
      "40.4553\n",
      "Missing field/result... skipping.\n",
      "Appleton\n",
      "Fratellos Restaurant and Brewery\n",
      "44.2678\n",
      "Manheim\n",
      "JoBoy's Brew Pub\n",
      "40.1707\n",
      "Port Washington\n",
      "Port Washington Brewing\n",
      "43.3872\n",
      "Morrisville\n",
      "Rock Art Brewery\n",
      "44.5693\n",
      "Charleston\n",
      "Southend Brewery and Smokehouse - Charleston\n",
      "32.7785\n",
      "East Lothian\n",
      "Belhaven Brewery\n",
      "55.997\n",
      "Jalhay-Vervifontaine\n",
      "Missing field/result... skipping.\n",
      "Williamsport\n",
      "Bullfrog Brewery\n",
      "41.2404\n",
      "Grand Lake\n",
      "Grand Lake Brewing\n",
      "40.2518\n",
      "Butler\n",
      "High Point Wheat Beer Company\n",
      "41.0016\n",
      "Red Bank\n",
      "Original Basil T's\n",
      "40.3532\n",
      "Sheridan\n",
      "Sanford's Grub and Pub\n",
      "44.8007\n",
      "Sunnyside\n",
      "Snipes Mountain Microbrewery & Restaurant\n",
      "46.3284\n",
      "Missing field/result... skipping.\n",
      "Washington\n",
      "Capital City Brewing Company\n",
      "38.8999\n",
      "Grand Island\n",
      "Copper Eagle Brewing\n",
      "40.9222\n",
      "Vancouver\n",
      "Dix Barbecue & Brewery\n",
      "49.2766\n",
      "Milwaukee\n",
      "Miller Brewing\n",
      "43.0445\n",
      "Billings\n",
      "Montana Brewing\n",
      "45.7822\n",
      "Missing field/result... skipping.\n",
      "Berkeley\n",
      "Pyramid Alehouse, Brewery and Restaurant - Berkeley\n",
      "37.8806\n",
      "Royersford\n",
      "Sly Fox Brewhouse and Eatery - Royersford\n",
      "40.1943\n",
      "Missing field/result... skipping.\n",
      "Melbourne\n",
      "Carlton and United Breweries\n",
      "-37.8231\n",
      "Michigan City\n",
      "Duneland Brewhouse Pub and Restaurant\n",
      "41.7075\n",
      "Cherry Hill\n",
      "Flying Fish Brewing Company\n",
      "39.9121\n",
      "Winston-Salem\n",
      "Foothills Brewing Company\n",
      "36.0973\n",
      "Glenwood Springs\n",
      "Glenwood Canyon Brewing Company\n",
      "39.5476\n",
      "Frstenfeldbruck\n",
      "Knig Ludwig Schlobrauerei Kaltenberg\n",
      "48.1826\n",
      "Saint Paul\n",
      "Minnesota Brewing\n",
      "44.9442\n",
      "Saint John\n",
      "Moosehead Breweries Ltd.\n",
      "45.2578\n",
      "Marinette\n",
      "Rail House Restaurant and Brewpub\n",
      "45.0851\n",
      "San Antonio\n",
      "Salado Creek Brewing Company\n",
      "29.4241\n",
      "Buxton\n",
      "Whim Ales\n",
      "53.1407\n",
      "Kaufbeuren\n",
      "Aktienbrauerei Kaufbeuren\n",
      "47.8781\n",
      "Sint-Lievens-Esse\n",
      "Brouwerij Van Den Bossche\n",
      "50.8564\n",
      "Beloit\n",
      "BT McClintic Beer Company\n",
      "42.5083\n",
      "Davenport\n",
      "Front Street Brewery\n",
      "41.5202\n",
      "Leipzig\n",
      "Gasthaus & Gosebrauerei Bayerischer Bahnhof\n",
      "51.3397\n",
      "Manchester\n",
      "Milly's Tavern\n",
      "42.9945\n",
      "Fort Mitchell\n",
      "Oldenberg Brewery\n",
      "39.0472\n",
      "Portland\n",
      "Roots Organic Brewing\n",
      "45.5118\n",
      "San Diego\n",
      "Tailgate Beer\n",
      "32.7732\n",
      "Missing field/result... skipping.\n",
      "Lincoln\n",
      "Beermann's Beerwerks BrewPub\n",
      "38.8916\n",
      "Concord\n",
      "Coastal Fog Brewing\n",
      "37.978\n",
      "Wisbech\n",
      "Elgood & Sons\n",
      "52.6643\n",
      "Pleasanton\n",
      "HopTown Brewing\n",
      "37.677\n",
      "Newark\n",
      "Iron Hill Brewery - Newark\n",
      "39.6834\n",
      "Papillion\n",
      "Nebraska Brewing Company\n",
      "41.1339\n",
      "Santa Cruz\n",
      "Seabright Brewery\n",
      "36.9676\n",
      "Shiner\n",
      "Spoetzl Brewery\n",
      "29.426\n",
      "Davis\n",
      "Sudwerk Privatbrauerei Hbsch\n",
      "38.5472\n",
      "Boise\n",
      "Tablerock\n",
      "43.6113\n",
      "Beersel\n",
      "3 Fonteinen Brouwerij Ambachtelijke Geuzestekerij\n",
      "50.7668\n",
      "Mnster\n",
      "Brauerei und Altbierkche Pinkus Mller\n",
      "51.9657\n",
      "Dsseldorf\n",
      "Brauhaus Johann Albrecht - Dsseldorf\n",
      "51.2404\n",
      "Missing field/result... skipping.\n",
      "Fairfield\n",
      "Cricket Hill\n",
      "40.8726\n",
      "Moskva\n",
      "Efes Moscow Brewery\n",
      "55.7558\n",
      "Duluth\n",
      "Lake Superior Brewing\n",
      "46.7611\n",
      "Portland\n",
      "Nor'Wester Brewery and Public House\n",
      "45.5235\n",
      "Missing field/result... skipping.\n",
      "Red Lodge\n",
      "Red Lodge Ales\n",
      "45.1913\n",
      "Chambersburg\n",
      "Roy Pitz Brewing Company\n",
      "39.939\n",
      "Denver\n",
      "SandLot Brewery at Coors Field\n",
      "39.7557\n",
      "Casper\n",
      "Sweetwater Brewing - Casper\n",
      "42.8666\n",
      "Dene\n",
      "Abbaye de Maredsous\n",
      "50.3093\n",
      "Bar Harbor\n",
      "Atlantic Brewing Company\n",
      "44.3996\n",
      "Northville\n",
      "Bonfire Brewery\n",
      "42.4311\n",
      "Stockport\n",
      "Frederic Robinson Ltd.\n",
      "41.499\n",
      "Port Washington\n",
      "Harbor City Brewing\n",
      "43.3871\n",
      "Arcata\n",
      "Humboldt Brewing\n",
      "40.87\n",
      "Milwaukee\n",
      "Mickey's Brewing Co.\n",
      "43.0389\n",
      "Metuchen\n",
      "Pizzeria Uno Chicago Grill & Brewery\n",
      "37.2283\n",
      "Knoxville\n",
      "Smoky Mountain Brewing\n",
      "35.9657\n",
      "Detroit\n",
      "Stoney Creek Brewing Company\n",
      "42.3372\n",
      "Omaha\n",
      "Upstream Brewing Company at Legacy\n",
      "41.2331\n",
      "Ulm\n",
      "Barfer - das kleine Brauhaus\n",
      "48.3979\n",
      "Sturgeon Bay\n",
      "Cherryland Brewing\n",
      "44.8342\n",
      "Helena\n",
      "Lewis & Clark Brewing Company\n",
      "46.5977\n",
      "Lombard\n",
      "Taylor Brewing\n",
      "41.8358\n",
      "Boulder\n",
      "Twisted Pine Brewing Company\n",
      "40.0201\n",
      "Maidstone\n",
      "Whitstable Brewery\n",
      "51.2047\n",
      "Missing field/result... skipping.\n",
      "Kansas City\n",
      "Amerisports Brew Pub\n",
      "39.1551\n",
      "Berlin\n",
      "Berliner Kindl Brauerei AG\n",
      "52.4793\n",
      "Missing field/result... skipping.\n",
      "Binche\n",
      "Brasserie La Binchoise\n",
      "50.408\n",
      "Kln\n",
      "Brauerei Reissdorf\n",
      "50.8753\n",
      "Chapel Hill\n",
      "Carolina Brewery\n",
      "35.9103\n",
      "Windsor\n",
      "Harpoon Brewery - Windsor\n",
      "43.513\n",
      "Bad KÃ¶stritz\n",
      "Missing field/result... skipping.\n",
      "Moab\n",
      "Moab Brewery\n",
      "38.5657\n",
      "Portsmouth\n",
      "Portsmouth Brewery\n",
      "43.0781\n",
      "Missing field/result... skipping.\n",
      "St. Austell\n",
      "St. Austell Brewery\n",
      "50.3416\n",
      "Durango\n",
      "Steamworks Brewing - Durango\n",
      "37.2724\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Lynnwood\n",
      "Ellersick Brewing Big E Ales\n",
      "47.8099\n",
      "Redmond\n",
      "Far West Ireland Brewing\n",
      "47.6701\n",
      "Denver\n",
      "Hops Grillhouse & Brewery - Cherry Creek\n",
      "39.7187\n",
      "New Albany\n",
      "New Albanian Brewing\n",
      "38.3281\n",
      "Sacramento\n",
      "Rubicon Brewing\n",
      "38.5731\n",
      "La Jolla\n",
      "Sports City Cafe & Brewery\n",
      "33.8575\n",
      "Missing field/result... skipping.\n",
      "Sydney\n",
      "Tooheys\n",
      "-33.8501\n",
      "Stockton\n",
      "Valley Brewing Company\n",
      "37.9551\n",
      "Victoria\n",
      "Vancouver Island Brewing\n",
      "48.4344\n",
      "Houffalize-Achouffe\n",
      "Brasserie D'Achouffe\n",
      "50.1507\n",
      "Bedford\n",
      "Charles Wells Ltd.\n",
      "52.1321\n",
      "Dillon\n",
      "Dillon Dam Brewery\n",
      "39.6282\n",
      "Motten\n",
      "Hochstiftliches Brauhaus in Bayern\n",
      "50.3949\n",
      "Manhattan Beach\n",
      "Manhattan Beach Brewing\n",
      "33.8844\n",
      "Papillion\n",
      "Nebraska Brewing Company\n",
      "37.244\n",
      "Milford\n",
      "Pennichuck Brewing Company\n",
      "42.8368\n",
      "Granby\n",
      "The Cambridge House\n",
      "41.9658\n",
      "Formosa\n",
      "Missing field/result... skipping.\n",
      "Millheim\n",
      "Elk Creek Cafe and Aleworks\n",
      "40.8911\n",
      "West Dundee\n",
      "Emmett's Tavern and Brewery\n",
      "42.0981\n",
      "Lawrence\n",
      "Free State Brewing\n",
      "38.9718\n",
      "Mission\n",
      "Mission Springs Brewing\n",
      "49.1323\n",
      "Missing field/result... skipping.\n",
      "Portland\n",
      "Portland Brewing\n",
      "45.5415\n",
      "Campbell\n",
      "Rock Bottom Restaurant & Brewery - San Jose\n",
      "37.2886\n",
      "Bar Harbor\n",
      "Bar Harbor Brewing Company\n",
      "44.3875\n",
      "Sunnyvale\n",
      "Faultline Brewing #1\n",
      "37.387\n",
      "Missing field/result... skipping.\n",
      "Salt Lake City\n",
      "Rivers Effortless Dining\n",
      "40.638\n",
      "Houston\n",
      "Saint Arnold Brewing\n",
      "29.8123\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Longview\n",
      "Steel Brewing\n",
      "32.5007\n",
      "Alpine\n",
      "Alpine Beer Company\n",
      "32.8355\n",
      "Seattle\n",
      "Baron Brewing Company\n",
      "47.5203\n",
      "Washington\n",
      "Missing field/result... skipping.\n",
      "Opitter\n",
      "Brouwerij Sint-Jozef\n",
      "51.1168\n",
      "Missing field/result... skipping.\n",
      "Inyokern\n",
      "Indian Wells Brewing\n",
      "35.6675\n",
      "Burnaby\n",
      "Marine Pub & Brewhouse\n",
      "49.2055\n",
      "Chicago\n",
      "Rock Bottom Restaurant & Brewery - Chicago\n",
      "41.8915\n",
      "Stevens Point\n",
      "Stevens Point Brewery\n",
      "44.5104\n",
      "Missing field/result... skipping.\n",
      "Columbus\n",
      "Gottberg Brew Pub\n",
      "41.4295\n",
      "Manchester\n",
      "JW Lees and Co (Brewers) Ltd.\n",
      "53.5412\n",
      "Richmond\n",
      "Main Street Beer Company #1\n",
      "37.543\n",
      "Bellingham\n",
      "Orchard Street Brewery\n",
      "48.7596\n",
      "Pleasanton\n",
      "Pleasanton Main Street Brewery\n",
      "37.6645\n",
      "Missing field/result... skipping.\n",
      "Portland\n",
      "BJ's Pizza, Grill, and Brewery - Jantzen Beach\n",
      "45.5235\n",
      "Golden\n",
      "Coors Brewing - Golden Brewery\n",
      "39.7599\n",
      "Middletown\n",
      "Costal Extreme Brewing Company\n",
      "41.537\n",
      "Vancouver\n",
      "Dockside Brewing\n",
      "49.269800000000004\n",
      "Chicago\n",
      "Goose Island Beer Company - Clybourn\n",
      "41.9137\n",
      "Issaquah\n",
      "Issaquah Brewhouse\n",
      "47.53\n",
      "Castle Rock\n",
      "Jarre Creek Ranch Brewing\n",
      "39.3722\n",
      "Toms River\n",
      "Joshua Huddy's Brew Pub and Grill\n",
      "39.9529\n",
      "Moskva\n",
      "Ostankinskij Pivovarennij Zavod\n",
      "55.7558\n",
      "Mount Vernon\n",
      "Skagit River Brewing\n",
      "48.419200000000004\n",
      "Missing field/result... skipping.\n",
      "Ingelmunster\n",
      "Alvinne Picobrouwerij\n",
      "50.919\n",
      "Columbus\n",
      "Barley's Brewing #1\n",
      "39.9719\n",
      "Cincinnati\n",
      "Barrel House Brewing Co.\n",
      "39.1136\n",
      "Bremen\n",
      "Brauerei Beck\n",
      "53.0787\n",
      "Ninove\n",
      "Brouwerij Slaghmuylder\n",
      "50.8417\n",
      "Sunnyvale\n",
      "Firehouse Grill & Brewery\n",
      "37.3775\n",
      "Lewes\n",
      "Harvey & Son (Lewes)\n",
      "50.8742\n",
      "Minneapolis\n",
      "James Page Brewing\n",
      "45.0039\n",
      "Missing field/result... skipping.\n",
      "Des Moines\n",
      "Raccoon River Brewing\n",
      "41.5841\n",
      "Santa Rosa\n",
      "Russian River Brewing\n",
      "38.4418\n",
      "Burlington\n",
      "Three Needs Brewery and Taproom\n",
      "44.4771\n",
      "Portland\n",
      "Alameda Brewhouse\n",
      "45.5484\n",
      "Pipaix\n",
      "Brasserie Dubuisson\n",
      "50.5779\n",
      "Missing field/result... skipping.\n",
      "Lake Villa\n",
      "Columbia Bay Brewery Restaurant and Pub\n",
      "42.417\n",
      "Wilkes Barre\n",
      "Lion Brewery Inc.\n",
      "41.2557\n",
      "Toronto\n",
      "Molson Breweries of Canada\n",
      "43.6706\n",
      "Hastings\n",
      "Murphy's Wagon Wheel\n",
      "40.5843\n",
      "Missing field/result... skipping.\n",
      "Santa Fe\n",
      "Santa Fe Brewing Company\n",
      "35.5966\n",
      "Socorro\n",
      "Socorro Springs Brewing\n",
      "34.0701\n",
      "Chapel Hill\n",
      "Top of the Hill Restaurant and Brewery\n",
      "35.9132\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Westmalle\n",
      "Brouwerij Abdij der Trappisten van Westmalle\n",
      "51.2974\n",
      "Missing field/result... skipping.\n",
      "Arvada\n",
      "Cheshire Cat Brewery\n",
      "39.8023\n",
      "Cleveland\n",
      "Cleveland ChopHouse and Brewery\n",
      "41.4995\n",
      "Regency Park\n",
      "Coopers Brewery\n",
      "-34.8727\n",
      "Baltimore\n",
      "DeGroen's Grill\n",
      "39.2904\n",
      "Schwbisch Gmnd\n",
      "Missing field/result... skipping.\n",
      "Neuzelle\n",
      "Klosterbrauerei Neuzelle\n",
      "52.091\n",
      "Victoria\n",
      "Lighthouse Brewing\n",
      "48.4358\n",
      "Kansas City\n",
      "McCoy's Public House and Brewkitchen\n",
      "39.0534\n",
      "Olathe\n",
      "Pony Express Brewing\n",
      "38.8814\n",
      "San Diego\n",
      "San Diego Brewing\n",
      "32.7922\n",
      "Missing field/result... skipping.\n",
      "Monterrey\n",
      "Sierra Madre Brewing Co.\n",
      "25.6811\n",
      "Siletz\n",
      "Siletz Roadhouse & Brewery\n",
      "44.722\n",
      "Denver\n",
      "Tivoli Brewing\n",
      "39.7392\n",
      "Saint Paul\n",
      "Tunner's Guild Brewing Systems\n",
      "44.9442\n",
      "Reamstown\n",
      "Union Barrel Works\n",
      "40.2118\n",
      "Augusta\n",
      "Augusta Brewing\n",
      "38.5702\n",
      "Missing field/result... skipping.\n",
      "San Clemente\n",
      "Left Coast Brewing\n",
      "33.4577\n",
      "Bamberg\n",
      "Maisel Bru\n",
      "49.8928\n",
      "Pacific City\n",
      "Pelican Pub & Brewery\n",
      "45.2152\n",
      "Missing field/result... skipping.\n",
      "St. Paul\n",
      "Flat Earth Brewing Company\n",
      "44.9084\n",
      "Uji\n",
      "Missing field/result... skipping.\n",
      "La Jolla\n",
      "La Jolla Brew House\n",
      "32.8409\n",
      "Missing field/result... skipping.\n",
      "Fort Collins\n",
      "New Belgium Brewing\n",
      "40.5929\n",
      "Heber City\n",
      "Park City Brewing\n",
      "40.496\n",
      "Missing field/result... skipping.\n",
      "Portland\n",
      "Raccoon Lodge and Brewpub / Cascade Brewing\n",
      "45.4856\n",
      "Blue Ash\n",
      "Watson Brothers Brewhouse\n",
      "39.232\n",
      "Newberg\n",
      "White Oak Cider\n",
      "45.3498\n",
      "San Diego\n",
      "Ballast Point Brewing\n",
      "32.7668\n",
      "Burton-upon-Trent\n",
      "Bass Brewers\n",
      "52.8046\n",
      "Irchonwelz\n",
      "Brasserie des Gants\n",
      "50.620400000000004\n",
      "Onuma\n",
      "Brauhaus Onuma\n",
      "43.0646\n",
      "Fremont\n",
      "Brewpub-on-the-Green\n",
      "37.5483\n",
      "Jumet\n",
      "Brouwerij Alken-Maes\n",
      "50.4431\n",
      "Bavikhove\n",
      "Brouwerij Bavik - De Brabandere\n",
      "50.8628\n",
      "Sint-Ulriks-Kapelle\n",
      "Missing field/result... skipping.\n",
      "Vichte\n",
      "Brouwerij Verhaeghe\n",
      "50.8322\n",
      "Wolnzach\n",
      "Missing field/result... skipping.\n",
      "Coeur d'Alene\n",
      "Coeur d'Alene Brewing Company\n",
      "47.6745\n",
      "Wilson\n",
      "Grand Teton Brewing #1\n",
      "43.4988\n",
      "Kihei\n",
      "Hapa*s Brew Haus and Restaurant\n",
      "20.7592\n",
      "Cham\n",
      "Hofmark Brauerei\n",
      "49.1672\n",
      "Austin\n",
      "Live Oak Brewing\n",
      "30.2541\n",
      "Eureka\n",
      "Lost Coast Brewery\n",
      "40.8032\n",
      "Chicago\n",
      "Metropolitan Brewing\n",
      "41.975\n",
      "Collegeville\n",
      "New Road Brewhouse\n",
      "40.1857\n",
      "Pittsburgh\n",
      "Penn Brewery\n",
      "40.4569\n",
      "Portland\n",
      "Yamhill Brewing\n",
      "45.5235\n",
      "Austin\n",
      "Celis Brewery\n",
      "30.2672\n",
      "Farmville\n",
      "Duck-Rabbit Craft Brewery\n",
      "35.6003\n",
      "Anchorage\n",
      "Moose's Tooth Pub and Pizzeria\n",
      "61.1902\n",
      "Atlanta\n",
      "New River Brewing\n",
      "33.9089\n",
      "Fort Bragg\n",
      "North Coast Brewing Company\n",
      "39.4466\n",
      "Denver\n",
      "Pint's Pub Brewery and Freehouse\n",
      "39.7369\n",
      "Nagoya\n",
      "Pokka Beer Works\n",
      "35.1814\n",
      "Eichsttt\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Cave Junction\n",
      "Wild River Brewing and Pizza - Cave Junction\n",
      "42.1707\n",
      "Kempten\n",
      "Allguer Brauhaus AG Kempten\n",
      "47.7487\n",
      "Lee's Summit\n",
      "Bard's Tale Beer Company\n",
      "38.9169\n",
      "Surrey\n",
      "Big Ridge Brewing\n",
      "49.1049\n",
      "Portsmouth\n",
      "George Gale & Company\n",
      "50.7989\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Nelson\n",
      "Nelson Brewing\n",
      "49.4884\n",
      "Milwaukee\n",
      "Onopa Brewing\n",
      "43.0389\n",
      "Konstanz\n",
      "Ruppaner-Brauerei\n",
      "47.6855\n",
      "Missing field/result... skipping.\n",
      "Sonora\n",
      "Snowshoe Brewing - Sonora\n",
      "37.9841\n",
      "Willoughby\n",
      "Willoughby Brewing\n",
      "41.6416\n",
      "Oak Bluffs\n",
      "Brewery at Martha's Vineyard\n",
      "41.4548\n",
      "Red Oak\n",
      "Firehouse Brewery & Restaurant\n",
      "41.0117\n",
      "Vernon\n",
      "Okanagan Spring Brewery\n",
      "50.2613\n",
      "Weston-super-Mare\n",
      "RCH Brewery\n",
      "51.3723\n",
      "Bellaire\n",
      "Short's Brewing Company\n",
      "44.9763\n",
      "Denver\n",
      "Wynkoop Brewing\n",
      "39.7535\n",
      "Lexington\n",
      "Alltech's Lexington Brewing Company\n",
      "38.0501\n",
      "Greenwich\n",
      "Meantime Brewing Company Limited\n",
      "51.4899\n",
      "Seattle\n",
      "Pyramid Ales Brewery\n",
      "47.5924\n",
      "Boulder\n",
      "RedFish New Orleans Brewhouse\n",
      "40.0187\n",
      "Sacramento\n",
      "Sacramento Brewing Company\n",
      "38.6191\n",
      "New Hope\n",
      "Triumph Brewing of New Hope\n",
      "40.3659\n",
      "Missing field/result... skipping.\n",
      "Harrisburg\n",
      "Appalachian Brewing Company\n",
      "40.2659\n",
      "Missing field/result... skipping.\n",
      "Etna\n",
      "Etna Brewing\n",
      "41.4559\n",
      "Dresden\n",
      "Missing field/result... skipping.\n",
      "Omaha\n",
      "Granite City Food & Brewery - Omaha\n",
      "41.2672\n",
      "Missing field/result... skipping.\n",
      "Seattle\n",
      "Missing field/result... skipping.\n",
      "Phoenixville\n",
      "Sly Fox Brewhouse and Eatery - Phoenixville\n",
      "40.1298\n",
      "Winnipeg\n",
      "Missing field/result... skipping.\n",
      "Aurora\n",
      "America's Brewing\n",
      "41.7605\n",
      "Brunehaut\n",
      "Brasserie de Brunehaut\n",
      "50.5109\n",
      "Missing field/result... skipping.\n",
      "Glens Falls\n",
      "Cooper's Cave Ale Company\n",
      "43.3177\n",
      "Greeley\n",
      "Crabtree Brewery\n",
      "40.4313\n",
      "Pasadena\n",
      "Craftsman Brewing\n",
      "34.1696\n",
      "Paso Robles\n",
      "Firestone Walker Brewing Company\n",
      "35.5953\n",
      "Pittsburgh\n",
      "Iron City Brewing Co.\n",
      "40.461\n",
      "Philadelphia\n",
      "Nodding Head Brewpub\n",
      "39.9502\n",
      "Fresno\n",
      "Sequoia Brewing Conoabt\n",
      "36.7582\n",
      "Toronto\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Moos\n",
      "Missing field/result... skipping.\n",
      "Portland\n",
      "Blitz-Weinhard Brewing\n",
      "45.5325\n",
      "Cerfontaine-Silenrieux\n",
      "Brasserie De Silenrieux\n",
      "50.2248\n",
      "Ternat\n",
      "Brewery De Troch\n",
      "50.853\n",
      "Dworp\n",
      "Hanssens Artisanal\n",
      "50.729\n",
      "Ishpeming\n",
      "Jasper Ridge Brewery\n",
      "46.5015\n",
      "Milwaukee\n",
      "Rock Bottom Restaurant & Brewery - Milwaukee\n",
      "43.0399\n",
      "Salt Lake City\n",
      "Uinta Brewing Compnay\n",
      "40.7326\n",
      "Melle\n",
      "Missing field/result... skipping.\n",
      "Cambridge\n",
      "Cambridge Brewing\n",
      "42.3664\n",
      "White River Junction\n",
      "Catamount Brewing\n",
      "43.649\n",
      "Truckee\n",
      "Fifty Fifty Brewing Co.\n",
      "39.322\n",
      "Wilmington\n",
      "First Coast Brewing\n",
      "34.2257\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Omaha\n",
      "Jaipur Restaurant and Brewpub\n",
      "41.2328\n",
      "Boulder\n",
      "Oasis Brewery Annex\n",
      "40.015\n",
      "Seattle\n",
      "Redhook Ale Brewery\n",
      "47.6062\n",
      "Missing field/result... skipping.\n",
      "Madison\n",
      "Angelic Brewing\n",
      "43.0785\n",
      "Wheeling\n",
      "Big Horn Brewing @ The RAM 2\n",
      "42.1511\n",
      "Montignies-sur-Roc\n",
      "Brasserie De L'Abbaye Des Rocs\n",
      "50.3705\n",
      "Miltenberg\n",
      "Brauhaus Faust\n",
      "49.6993\n",
      "Kalamazoo\n",
      "Kalamazoo Brewing\n",
      "42.2949\n",
      "Missing field/result... skipping.\n",
      "Orlando\n",
      "Orlando Brewing\n",
      "28.5265\n",
      "Delta\n",
      "Shaftebury Brewing\n",
      "49.1487\n",
      "Ashland\n",
      "South Shore Brewery\n",
      "46.5872\n",
      "Warrenville\n",
      "Two Brothers Brewing\n",
      "41.8206\n",
      "Greeley\n",
      "Union Colony Brewery\n",
      "40.4233\n",
      "Bloomington\n",
      "Upland Brewing\n",
      "39.1733\n",
      "Boulder\n",
      "Missing field/result... skipping.\n",
      "Cooperstown\n",
      "Brewery Ommegang\n",
      "42.6818\n",
      "Diest\n",
      "Brouwerij Duysters\n",
      "50.9882\n",
      "Missing field/result... skipping.\n",
      "Oconomowoc\n",
      "Oconomowoc Brewing\n",
      "43.1117\n",
      "Missing field/result... skipping.\n",
      "Centerport\n",
      "The Blind Bat Brewery LLC\n",
      "40.8959\n",
      "North Bergen\n",
      "Missing field/result... skipping.\n",
      "Raleigh\n",
      "Big Boss Brewing Company\n",
      "35.8104\n",
      "Fremont\n",
      "Jack's Brewing\n",
      "37.5441\n",
      "Newport\n",
      "Rogue Ales\n",
      "44.6202\n",
      "Santa Fe\n",
      "Second Street Brewery\n",
      "35.6631\n",
      "Lodi\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Wagner Valley Brewing\n",
      "42.5739\n",
      "Steinberg/Sachsen\n",
      "Missing field/result... skipping.\n",
      "Baltimore\n",
      "Baltimore-Washington Beer Works\n",
      "39.42\n",
      "Germantown\n",
      "Boscos Memphis Brewing\n",
      "35.0868\n",
      "Salinas\n",
      "Carmel Brewing\n",
      "36.6777\n",
      "Reedsburg\n",
      "Corner Pub\n",
      "43.5323\n",
      "Peoria\n",
      "Crooked Waters Brewing\n",
      "40.6936\n",
      "West Philly\n",
      "Dock Street Beer\n",
      "39.9478\n",
      "Breendonk\n",
      "Missing field/result... skipping.\n",
      "Camino\n",
      "Jack Russell Brewing\n",
      "38.7563\n",
      "Gresham\n",
      "Main Street Alehouse\n",
      "45.5001\n",
      "Dsseldorf\n",
      "Uerige Obergrige Hausbrauerei\n",
      "51.225\n",
      "Missing field/result... skipping.\n",
      "Yakima\n",
      "Yakima Brewing and Malting / Grant's Ales\n",
      "46.6021\n",
      "Southwold\n",
      "Adnams & Co.\n",
      "52.3277\n",
      "Seattle\n",
      "Elysian Brewery & Public House\n",
      "47.614\n",
      "Niagara Falls\n",
      "Niagara Falls Brewing\n",
      "43.0893\n",
      "Missing field/result... skipping.\n",
      "Moreno Valley\n",
      "PH Woods Diner and Brewery\n",
      "33.9176\n",
      "Missing field/result... skipping.\n",
      "Campbell\n",
      "Roost Brewery\n",
      "37.2869\n",
      "MÃ¼nchen\n",
      "Missing field/result... skipping.\n",
      "Detroit\n",
      "Traffic Jam and Snug\n",
      "42.351\n",
      "Dallas\n",
      "Yegua Creek Brewing - Dallas\n",
      "32.821\n",
      "Oudenaarde\n",
      "Brouwerij Roman\n",
      "50.831\n",
      "Donaueschingen\n",
      "Missing field/result... skipping.\n",
      "Vancouver\n",
      "Granville Island Brewing Company\n",
      "49.2705\n",
      "Fort Wayne\n",
      "Mad Anthony Brewing\n",
      "41.0677\n",
      "Utica\n",
      "Panther Brewing Company\n",
      "43.1467\n",
      "Missing field/result... skipping.\n",
      "Richmond\n",
      "Richbrau Brewing Company\n",
      "37.5356\n",
      "Green Bay\n",
      "Titletown Brewing\n",
      "44.52\n",
      "Swansea\n",
      "Tomos Watkin and Sons Ltd.\n",
      "51.6666\n",
      "Manhattan\n",
      "Missing field/result... skipping.\n",
      "Rochefort\n",
      "Abbaye Notre Dame du St Remy\n",
      "50.1999\n",
      "Missing field/result... skipping.\n",
      "Pleasantville\n",
      "Captain Lawrence Brewing Company\n",
      "41.126\n",
      "Lincolnshire\n",
      "Flatlander's Restaurant & Brewery\n",
      "42.2031\n",
      "Tacoma\n",
      "Harmon Brewing Company\n",
      "47.2436\n",
      "Dsseldorf\n",
      "Hausbrauerei Zum Schlssel\n",
      "51.2261\n",
      "Roseburg\n",
      "Hawks Brewing\n",
      "43.2165\n",
      "Missing field/result... skipping.\n",
      "Fremantle\n",
      "Little Creatures Brewery\n",
      "-32.0597\n",
      "Ukiah\n",
      "Ukiah Brewing\n",
      "39.1498\n",
      "Mankato\n",
      "Bandana Brewery\n",
      "44.1636\n",
      "Aubel\n",
      "Brasserie de l'Abbaye Val-Dieu\n",
      "50.7046\n",
      "Portland\n",
      "BridgePort Brewing\n",
      "45.5311\n",
      "Westvleteren\n",
      "Brouwerij Abdij Saint Sixtus\n",
      "50.8961\n",
      "Helena\n",
      "Kessler Brewing\n",
      "46.5958\n",
      "Missing field/result... skipping.\n",
      "Belfast\n",
      "Belfast Bay Brewing Company\n",
      "44.4295\n",
      "Urbana\n",
      "Bibiana Brewing\n",
      "40.1106\n",
      "Kansas City\n",
      "Boulevard Brewing Company\n",
      "39.0821\n",
      "Knoxville\n",
      "Calhoun's Microbrewery\n",
      "35.932\n",
      "Cross Plains\n",
      "Esser's Cross Plains Brewery\n",
      "43.1147\n",
      "Rochester\n",
      "Flour City Brewing\n",
      "43.161\n",
      "Neuhaus\n",
      "Kaiser-Bru\n",
      "49.6283\n",
      "Mill Creek\n",
      "McMenamins Mill Creek\n",
      "47.8774\n",
      "Missing field/result... skipping.\n",
      "Abita Springs\n",
      "Abita Brewing Company\n",
      "30.5049\n",
      "Glen Ellyn\n",
      "Glen Ellyn Sports Brew\n",
      "41.8775\n",
      "Sparta\n",
      "Krogh's Restaurant and Brewpub\n",
      "41.0323\n",
      "Eagle River\n",
      "Loaf and Stein Brewing\n",
      "45.9172\n",
      "Missing field/result... skipping.\n",
      "Vancouver\n",
      "R&B; Brewing\n",
      "49.2673\n",
      "Sturgeon Bay\n",
      "Sturgeon Bay Brewing\n",
      "44.8342\n",
      "Missing field/result... skipping.\n",
      "Bloomington\n",
      "Bloomington Brewing Company\n",
      "39.1716\n",
      "Purnode\n",
      "Brasserie du Bocq\n",
      "50.3114\n",
      "Oudenaarde\n",
      "Brouwerij Liefmans\n",
      "50.8439\n",
      "Rockford\n",
      "Carlyle Brewing\n",
      "42.2689\n",
      "GroÃŸostheim\n",
      "Eder & Heylands\n",
      "49.9211\n",
      "Asheville\n",
      "Highland Brewing Company\n",
      "35.5716\n",
      "Lancaster\n",
      "Lancaster Brewing Co.\n",
      "40.0438\n",
      "New Glarus\n",
      "New Glarus Brewing Company\n",
      "42.8171\n",
      "State College\n",
      "Otto's Pub and Brewery\n",
      "40.8098\n",
      "Kearney\n",
      "Platte Valley Brewing\n",
      "40.6954\n",
      "Black River Falls\n",
      "Sand Creek Brewing Company\n",
      "44.2929\n",
      "Lyndonville\n",
      "Trout River Brewing\n",
      "44.5203\n",
      "New Brighton\n",
      "Barley John's Brewpub\n",
      "45.036\n",
      "Vlezenbeek\n",
      "Brouwerij Lindemans\n",
      "50.818\n",
      "Beersel\n",
      "Brouwerij Oud Beersel\n",
      "50.7586\n",
      "Rochester\n",
      "High Falls Brewing\n",
      "43.1646\n",
      "Eau Claire\n",
      "Northwoods Brewpub Grill\n",
      "44.7776\n",
      "Albany\n",
      "Oregon Trader Brewing\n",
      "44.6365\n",
      "Greenville\n",
      "Thomas Creek Brewery\n",
      "34.7968\n",
      "Cleveland\n",
      "Western Reserve Brewing\n",
      "41.4995\n",
      "Hannover\n",
      "Brauerei Herrenhausen\n",
      "52.3935\n",
      "Molenbeek\n",
      "Brewery Belle-Vue\n",
      "50.8527\n",
      "Ellicott City\n",
      "Ellicott Mills Brewing\n",
      "39.2684\n",
      "Missing field/result... skipping.\n",
      "Arlington Heights\n",
      "O'Grady's Brewery and Pub #1\n",
      "42.0884\n",
      "Rocky River\n",
      "Rocky River Brewing\n",
      "41.4623\n",
      "Cardiff\n",
      "SA Brain & Co. Ltd.\n",
      "51.4736\n",
      "Missing field/result... skipping.\n",
      "Grand Rapids\n",
      "Missing field/result... skipping.\n",
      "Honolulu\n",
      "Ali`i Brewing\n",
      "21.3069\n",
      "Missing field/result... skipping.\n",
      "Assebroek\n",
      "Brouwerij De Regenboog\n",
      "51.1968\n",
      "Sankt-Peterburg\n",
      "Pivzavod Baltika /\n",
      "59.939\n",
      "Qingdao\n",
      "Qingdao Brewery\n",
      "36.0663\n",
      "Lake Mills\n",
      "Tyranena Brewing\n",
      "43.0862\n",
      "Lewiston\n",
      "Baxter Brewing\n",
      "44.1004\n",
      "Laughlin\n",
      "Boiler Room Brewpub\n",
      "35.1584\n",
      "Missing field/result... skipping.\n",
      "Moultonborough\n",
      "Castle Springs Brewery\n",
      "43.7548\n",
      "Alva\n",
      "Harviestoun Brewery\n",
      "56.1531\n",
      "Dentergem\n",
      "Liefmans Breweries\n",
      "50.9649\n",
      "Minneapolis\n",
      "Rock Bottom Restaurant & Brewery - Minneapolis\n",
      "44.9765\n",
      "San Francisco\n",
      "ThirstyBear Brewing\n",
      "37.7855\n",
      "Berkeley\n",
      "Triple Rock Brewery\n",
      "37.8734\n",
      "Dallas\n",
      "TwoRows Restaurant & Brewery - Dallas\n",
      "32.8545\n",
      "Missing field/result... skipping.\n",
      "Alloa\n",
      "Williams Brothers Brewing Company\n",
      "56.1163\n",
      "Calgary\n",
      "Wyder's Cider\n",
      "51.034\n",
      "Missing field/result... skipping.\n",
      "Opwijk\n",
      "Brouwerij De Smedt\n",
      "50.971\n",
      "Toledo\n",
      "Maumee Bay Brewing\n",
      "41.6432\n",
      "Saint Paul\n",
      "O'Gara's Bar & Grill\n",
      "44.9458\n",
      "Fort Collins\n",
      "Odell Brewing\n",
      "40.5894\n",
      "Eugene\n",
      "Wild Duck Brewing\n",
      "44.0521\n",
      "Boulder\n",
      "Avery Brewing Company\n",
      "40.0166\n",
      "Missing field/result... skipping.\n",
      "Indianapolis\n",
      "Broad Ripple Brewing\n",
      "39.8735\n",
      "Jever\n",
      "Friesisches Brauhaus zu Jever\n",
      "53.5755\n",
      "Mnchengladbach\n",
      "Hannen Brauerei\n",
      "51.1913\n",
      "South Burlington\n",
      "Magic Hat\n",
      "44.4284\n",
      "Milford\n",
      "Ship Inn Brewpub\n",
      "40.5684\n",
      "Modesto\n",
      "St. Stan's Brewing Co.\n",
      "37.6417\n",
      "Belfast\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Morgan Hill\n",
      "El Toro Brewing Company\n",
      "37.1553\n",
      "Syracuse\n",
      "Middle Ages Brewing\n",
      "43.0508\n",
      "Utica\n",
      "Mississippi Brewing Co.\n",
      "40.687\n",
      "Polson\n",
      "Spanish Peaks Brewing\n",
      "47.6959\n",
      "Delafield\n",
      "Water Street Lake Country\n",
      "43.0525\n",
      "Rose City\n",
      "Bad Frog Brewery Company\n",
      "44.4214\n",
      "Missing field/result... skipping.\n",
      "Arlington\n",
      "Capitol City Brewing #4\n",
      "38.8411\n",
      "Missing field/result... skipping.\n",
      "Moab\n",
      "Eddie McStiff's Brewpub\n",
      "38.5725\n",
      "Oak Harbor\n",
      "Flyers Restraunt and Brewery\n",
      "48.2992\n",
      "Grand Rapids\n",
      "Founders Brewing\n",
      "42.9585\n",
      "Mishawaka\n",
      "Mishawaka Brewing\n",
      "41.6931\n",
      "Salt Lake City\n",
      "Salt Lake Brewing - Squatters\n",
      "40.7626\n",
      "Fox\n",
      "Silver Gulch Brewing Company\n",
      "64.9583\n",
      "Enterprise\n",
      "Terminal Gravity Brewing\n",
      "45.419200000000004\n",
      "Dsseldorf\n",
      "Brauerei Schumacher\n",
      "51.2216\n",
      "Konstanz\n",
      "Brauhaus Johann Albrecht - Konstanz\n",
      "47.6651\n",
      "Amherst\n",
      "Central Waters Brewing Company\n",
      "44.4419\n",
      "Chicago\n",
      "Goose Island Beer Company - Fulton Street\n",
      "41.8871\n",
      "Vail\n",
      "Hubcap Brewery and Kitchen\n",
      "39.6403\n",
      "Carpinteria\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Kulmbach\n",
      "Kulmbacher Brauerei AG\n",
      "50.106\n",
      "Bridgewater Corners\n",
      "Long Trail Brewing Co\n",
      "43.5882\n",
      "Tustin\n",
      "Tustin Brewing\n",
      "33.7496\n",
      "Philadelphia\n",
      "Yards Brewing\n",
      "39.9831\n",
      "Bristol\n",
      "Bobcat Cafe & Brewery\n",
      "44.1332\n",
      "Brooklyn\n",
      "Brooklyn Brewery\n",
      "40.7215\n",
      "Middleton\n",
      "Capital Brewery\n",
      "43.0949\n",
      "Cold Spring\n",
      "Cold Spring Brewing\n",
      "45.4582\n",
      "Milford\n",
      "Cooperstown Brewing Company\n",
      "42.5893\n",
      "Vancouver\n",
      "Granville Island Brewing Company\n",
      "34.396\n",
      "Baunatal\n",
      "Htt-Brauerei Bettenhuser\n",
      "51.2615\n",
      "Philadelphia\n",
      "Philadelphia Brewing Co\n",
      "39.9827\n",
      "Mnchen\n",
      "Unionsbru Haidhausen\n",
      "48.1355\n",
      "Meadville\n",
      "Voodoo Brewing Co.,LLC\n",
      "41.6372\n",
      "Lake Havasu City\n",
      "Barley Brothers Brewery and Grill\n",
      "34.4702\n",
      "Leutkirch im AllgÃ¤u\n",
      "Brauerei Hrle\n",
      "47.8243\n",
      "Fresno\n",
      "Butterfield Brewing #1\n",
      "36.7477\n",
      "Philadelphia\n",
      "Manayunk Brewery and Restaurant\n",
      "40.0236\n",
      "Surrey\n",
      "Missing field/result... skipping.\n",
      "Vancouver\n",
      "Steamworks\n",
      "49.2849\n",
      "Atlanta\n",
      "Sweetwater Brewing - Atlanta\n",
      "33.8087\n",
      "Missing field/result... skipping.\n",
      "Malli\n",
      "Missing field/result... skipping.\n",
      "Seattle\n",
      "Big Time Brewing\n",
      "47.6576\n",
      "Marrero\n",
      "Day Brewing\n",
      "29.8994\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Shrewsbury\n",
      "Salopian Brewery\n",
      "52.7069\n",
      "Boise\n",
      "Sockeye\n",
      "43.6326\n",
      "Leesburg\n",
      "Vintage 50 Restaurant and Brew Lounge\n",
      "39.1126\n",
      "Mexicali\n",
      "Cucapa Brewing Company\n",
      "31.7291\n",
      "De Pere\n",
      "Egan Brewing\n",
      "44.4489\n",
      "Dsseldorf\n",
      "Gatz Brauhaus\n",
      "51.2249\n",
      "Silver Spring\n",
      "Hook & Ladder Brewing Company\n",
      "38.9911\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Waltham\n",
      "Watch City Brewing\n",
      "42.3718\n",
      "Frankfurt am Main\n",
      "Binding Brauerei AG\n",
      "50.0943\n",
      "Patchogue\n",
      "Blue Point Brewing\n",
      "40.7591\n",
      "Boulder\n",
      "Boulder Beer Company\n",
      "40.0267\n",
      "Baltimore\n",
      "Brewer's Art\n",
      "39.3028\n",
      "Emeryville\n",
      "Emery Pub\n",
      "37.8313\n",
      "Llanelli\n",
      "Felinfoel Brewery Co Ltd\n",
      "51.6987\n",
      "San Francisco\n",
      "Golden Gate Park Brewery\n",
      "37.7749\n",
      "San Jose\n",
      "Gordon Biersch Brewing\n",
      "37.3526\n",
      "Brea\n",
      "BJ's Restaurant and Brewery\n",
      "33.9132\n",
      "Missing field/result... skipping.\n",
      "Louisville\n",
      "Brownings\n",
      "38.2554\n",
      "Hilo\n",
      "Mehana Brewing\n",
      "19.706\n",
      "Roselle Park\n",
      "Climax Brewing Copmany\n",
      "40.6598\n",
      "Billings\n",
      "Yellowstone Valley Brewing\n",
      "45.7861\n",
      "Mukilteo\n",
      "Diamond Knot Brewery & Alehouse\n",
      "47.9485\n",
      "Juneau\n",
      "Alaskan Brewing\n",
      "58.3573\n",
      "Milton\n",
      "Dogfish Head Craft Brewery\n",
      "38.768299999999996\n",
      "Bitburg\n",
      "Bitburger Brauerei\n",
      "49.974\n",
      "Fayetteville\n",
      "Mash House Restaurant and Brewery\n",
      "35.0707\n",
      "Lochristi-Hijfte\n",
      "De Proef Brouwerij\n",
      "51.1159\n",
      "Missing field/result... skipping.\n",
      "MontrÃ©al\n",
      "Dieu du Ciel\n",
      "45.5228\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Heidelberg\n",
      "Missing field/result... skipping.\n",
      "San Marcos\n",
      "Port Brewing Company\n",
      "33.1406\n",
      "Indianapolis\n",
      "Circle V Brewing\n",
      "39.7684\n",
      "Holland\n",
      "Roffey Brewery\n",
      "42.7875\n",
      "Denver\n",
      "Denver ChopHouse and Brewery\n",
      "39.7553\n",
      "Penticton\n",
      "Tin Whistle Brewing\n",
      "49.4944\n",
      "Edwards\n",
      "Gore Range Brewery\n",
      "39.6441\n",
      "Missing field/result... skipping.\n",
      "San Diego\n",
      "Karl Strauss Brewery Gardens - Sorrento Mesa\n",
      "32.8969\n",
      "Louisville\n",
      "BBC Brewing Co., LLC\n",
      "38.2546\n",
      "Missing field/result... skipping.\n",
      "Frederick\n",
      "Brimstone Brewing\n",
      "39.3628\n",
      "Saint Paul\n",
      "Summit Brewing\n",
      "44.9139\n",
      "Cleveland\n",
      "Diamondback Brewery\n",
      "41.4995\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Madison\n",
      "BluCreek Brewing Company\n",
      "43.0598\n",
      "Akron\n",
      "Thirsty Dog Brewing\n",
      "41.0689\n",
      "Bamberg\n",
      "Brauerei Spezial\n",
      "49.8942\n",
      "Trowbridge\n",
      "Ushers of Trowbridge\n",
      "51.3201\n",
      "Washington\n",
      "Capital City Brewing Company\n",
      "43.8042\n",
      "Wrzburg\n",
      "Wrzburger Hofbru AG\n",
      "49.792\n",
      "Las Vegas\n",
      "Chicago Brewing\n",
      "36.1476\n",
      "Liverpool\n",
      "Missing field/result... skipping.\n",
      "Manhattan\n",
      "Little Apple Brewing\n",
      "39.1836\n",
      "Little River\n",
      "Australian Brewing Corporation\n",
      "-37.968\n",
      "Boston\n",
      "New Century Brewing Company\n",
      "42.3587\n",
      "Missing field/result... skipping.\n",
      "Picton\n",
      "Scharer's Little Brewery\n",
      "-34.1855\n",
      "Blacksburg\n",
      "Blacksburg Brewing Company\n",
      "37.23\n",
      "Westerlo\n",
      "Tongerlo\n",
      "51.0873\n",
      "Oud-Turnhout\n",
      "Brewery Corsendonk\n",
      "51.3144\n",
      "Witney\n",
      "Wychwood Brewery\n",
      "51.7523\n",
      "Coronado\n",
      "Coronado Brewing Company\n",
      "32.6976\n",
      "Portland\n",
      "Allagash Brewing\n",
      "43.7028\n",
      "St Michaels\n",
      "Eastern Shore Brewing\n",
      "38.7814\n",
      "Tannersville\n",
      "Barley Creek Brewing\n",
      "41.0523\n",
      "Keystone\n",
      "Great Northern Tavern and Brewery\n",
      "39.6042\n",
      "Missing field/result... skipping.\n",
      "Mukilteo\n",
      "Missing field/result... skipping.\n",
      "Ashland\n",
      "Caldera Brewing\n",
      "42.1844\n",
      "Oshkosh\n",
      "Fox River Brewing #1\n",
      "44.0342\n",
      "Princeton by the Sea\n",
      "Half Moon Bay Brewing\n",
      "37.4903\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Unity\n",
      "Logjam Microbrewery\n",
      "44.8516\n",
      "Regensburg\n",
      "Klosterbrauerei Weltenburg\n",
      "49.0144\n",
      "Pentlow\n",
      "Nethergate Brewery Co Ltd\n",
      "52.081\n",
      "Warren\n",
      "Kuhnhenn Brewing\n",
      "42.5278\n",
      "Florence\n",
      "Nicolet Brewing\n",
      "45.9222\n",
      "Saint Cloud\n",
      "O'Hara's Brewpub and Restaurant\n",
      "45.5539\n",
      "Missing field/result... skipping.\n",
      "Vista\n",
      "Oggi's Pizza and Brewing - Vista\n",
      "33.2029\n",
      "Killyleagh\n",
      "Strangford Lough Brewing Company Ltd\n",
      "54.3906\n",
      "Missing field/result... skipping.\n",
      "Chambly\n",
      "Unibroue\n",
      "45.4416\n",
      "Tettnang\n",
      "Brauerei & Gasthof zur Krone\n",
      "47.6715\n",
      "Omaha\n",
      "Upstream Brewing Old Market\n",
      "41.2553\n",
      "Raeren\n",
      "Brennerei-Distillerie Radermacher\n",
      "50.6718\n",
      "Easton\n",
      "Weyerbacher Brewing Company\n",
      "40.6732\n",
      "Carbondale\n",
      "Copper Dragon Brewing\n",
      "37.7273\n",
      "Dresden\n",
      "Missing field/result... skipping.\n",
      "Egg Harbor\n",
      "Shipwrecked Brew Pub\n",
      "45.0495\n",
      "Chimay-Forges\n",
      "Brasserie de l'Abbaye de Scourmont (Trappistes)\n",
      "49.9842\n",
      "Noblesville\n",
      "Barley Island Brewing\n",
      "40.0453\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Schwelm\n",
      "Brauerei Schwelm\n",
      "51.2847\n",
      "Cleveland\n",
      "Crooked River Brewing\n",
      "41.4995\n",
      "Herbertingen\n",
      "Brauereigasthof Adler\n",
      "48.0778\n",
      "Kressbronn am Bodensee\n",
      "Gasthaus-Brauerei Max & Moritz\n",
      "47.6064\n",
      "Oakville\n",
      "Cameron's Brewing\n",
      "43.4745\n",
      "Missing field/result... skipping.\n",
      "Cincinnati\n",
      "Devil Mountain Brewing\n",
      "39.1361\n",
      "Stevens Point\n",
      "Keg Microbrewery & Restaurant\n",
      "44.5236\n",
      "Takayama\n",
      "Missing field/result... skipping.\n",
      "Durango\n",
      "Missing field/result... skipping.\n",
      "Halifax\n",
      "Labatt / Keith's Brewery / Oland Breweries\n",
      "44.6598\n",
      "Longmont\n",
      "Tabernash Brewing\n",
      "40.1672\n",
      "Kiln\n",
      "Lazy Magnolia Brewing Company\n",
      "30.3764\n",
      "Dallas\n",
      "Viking Brewing\n",
      "45.2585\n",
      "Itegem\n",
      "Microbrouwerij Achilles\n",
      "51.1028\n",
      "Omaha\n",
      "Aksarben Brewing (BOP)\n",
      "41.2603\n",
      "Solana Beach\n",
      "Pizza Port Brewing - Solana Beach\n",
      "32.9908\n",
      "La Jolla\n",
      "CJ's Brewery & Grill\n",
      "33.8575\n",
      "Dallas\n",
      "Routh Street Brewery and Grille\n",
      "32.789\n",
      "Belmont\n",
      "Missing field/result... skipping.\n",
      "Tadcaster\n",
      "Samuel Smith Old Brewery (Tadcaster)\n",
      "53.8834\n",
      "Riverside\n",
      "Jurupa Valley Brewing\n",
      "33.9533\n",
      "Missing field/result... skipping.\n",
      "Ponderay\n",
      "Laughing Dog Brewing\n",
      "48.3003\n",
      "Manteo\n",
      "Weeping Radish Restaurant and Brewery - Manteo\n",
      "35.8859\n",
      "Clackmannan\n",
      "Maclay and Co.\n",
      "56.1073\n",
      "Baltimore\n",
      "Wharf Rat\n",
      "39.2866\n",
      "Savannah\n",
      "Moon River Brewing Company\n",
      "32.081\n",
      "Missing field/result... skipping.\n",
      "St Charles\n",
      "Pizza Beer\n",
      "41.9455\n",
      "Dubuque\n",
      "Dubuque Brewing and Bottling\n",
      "42.5006\n",
      "Radeberg\n",
      "Radeberger Exportbierbrauerei\n",
      "51.1148\n",
      "Lincoln\n",
      "Empyrean Brewing Company\n",
      "40.8155\n",
      "Coniston\n",
      "Missing field/result... skipping.\n",
      "Rapid City\n",
      "Firehouse Brewing\n",
      "44.0812\n",
      "Raleigh\n",
      "Greenshields Brewery and Pub\n",
      "35.7721\n",
      "McMinnville\n",
      "Golden Valley Brewery and Pub\n",
      "45.2104\n",
      "Wilmington\n",
      "Iron Hill Brewery - Wilmingon\n",
      "39.745\n",
      "Madison\n",
      "Great Dane Pub and Brewing #1\n",
      "43.0745\n",
      "Conroe\n",
      "Southern Star Brewing Company\n",
      "30.3489\n",
      "Milwaukee\n",
      "Lakefront Brewery\n",
      "43.0547\n",
      "Tampa\n",
      "Tampa Bay Brewing\n",
      "27.9607\n",
      "Corvallis\n",
      "Oregon Trail Brewery\n",
      "44.5613\n",
      "White Marsh\n",
      "White Marsh Brewing Company\n",
      "39.3722\n",
      "Castle Rock\n",
      "Rockyard Brewing\n",
      "39.4091\n",
      "West Yellowstone\n",
      "Wolf Pack Brewing\n",
      "44.6584\n",
      "Honolulu\n",
      "Sam Choy's Breakfast, Lunch, Crab & Big Aloha Brewery\n",
      "21.3069\n",
      "Frisco\n",
      "Backcountry Brewery\n",
      "39.5765\n",
      "Jackson\n",
      "Snake River Brewing\n",
      "43.4768\n",
      "Pinedale\n",
      "Bottom's Up Brewing\n",
      "42.8666\n",
      "Bear\n",
      "Stewart's Brewing\n",
      "39.6318\n",
      "Hoegaarden\n",
      "Brouwerij van Hoegaarden\n",
      "50.7778\n",
      "Wauwatosa\n",
      "Wisconsin Brewing\n",
      "43.0495\n",
      "Millmont\n",
      "Copper Kettle Brewery\n",
      "40.8942\n",
      "San Francisco\n",
      "Big Bang Brewery (Closed)\n",
      "37.7756\n",
      "Green Bay\n",
      "Green Bay Brewing\n",
      "44.5189\n",
      "Buggenhout\n",
      "Brouwerij Bosteels\n",
      "51.0138\n",
      "New Brunswick\n",
      "Harvest Moon Brewery / Cafe\n",
      "40.4962\n",
      "Missing field/result... skipping.\n",
      "Belgrade\n",
      "Lightning Boy Brewery\n",
      "45.7786\n",
      "Missing field/result... skipping.\n",
      "Seattle\n",
      "Maritime Pacific Brewing\n",
      "47.6637\n",
      "South Orange\n",
      "Gaslight Brewery\n",
      "40.7465\n",
      "Simmerberg\n",
      "Simmerberg Brusttt und Taferne\n",
      "47.5814\n",
      "Missing field/result... skipping.\n",
      "Princeton\n",
      "Triumph Brewing of Princeton\n",
      "40.3507\n",
      "Strongsville\n",
      "Mad Crab Restaurant and Brewery\n",
      "41.3145\n",
      "New Orleans\n",
      "Zea Rotisserie and Brewery\n",
      "29.9386\n",
      "Missing field/result... skipping.\n",
      "Santa Cruz\n",
      "Santa Cruz Brewing\n",
      "36.9741\n",
      "Faversham\n",
      "Shepherd Neame\n",
      "51.3169\n",
      "Downingtown\n",
      "Victory Brewing\n",
      "40.0061\n",
      "Austin\n",
      "(512) Brewing Company\n",
      "30.2234\n",
      "San Francisco\n",
      "21st Amendment Brewery Cafe\n",
      "37.7825\n",
      "Dinant\n",
      "Abbaye de Leffe\n",
      "50.2606\n",
      "Columbus\n",
      "Barley's #2 Smokehouse and Brewpub\n",
      "39.9745\n",
      "Missing field/result... skipping.\n",
      "Jauche\n",
      "Folx-les-Caves\n",
      "50.6818\n",
      "Golden\n",
      "Golden City Brewery\n",
      "39.7546\n",
      "Janesville\n",
      "Gray Brewing\n",
      "42.6793\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Hertford\n",
      "McMullen & Sons\n",
      "51.7975\n",
      "Holland\n",
      "New Holland Brewing Company\n",
      "42.79\n",
      "Everett\n",
      "Scuttlebutt Brewing\n",
      "47.9975\n",
      "Portland\n",
      "Shipyard Brewing - Portland\n",
      "43.6619\n",
      "Sioux Falls\n",
      "Sioux Falls Brewing\n",
      "43.55\n",
      "Grand Island\n",
      "Thunderhead Brewery #2\n",
      "40.9259\n",
      "Missing field/result... skipping.\n",
      "LaSalle\n",
      "Brasal-Brasserie Allemande\n",
      "45.4289\n",
      "Habay-Rulles\n",
      "Brasserie Artisanale de Rulles\n",
      "49.7185\n",
      "Oudenaarde\n",
      "Brasserie Clarysse\n",
      "50.8431\n",
      "Watou\n",
      "Brouwerij St. Bernardus\n",
      "50.8425\n",
      "Missing field/result... skipping.\n",
      "Hamburg\n",
      "Holsten-Brauerei\n",
      "53.5621\n",
      "Omaha\n",
      "Jobber's Canyon Restaurant & Brewery\n",
      "41.254\n",
      "Lake Havasu City\n",
      "Mudshark Brewing\n",
      "34.4686\n",
      "Kirkland\n",
      "Northwest Brewwrks\n",
      "47.6815\n",
      "Chico\n",
      "Sierra Nevada Brewing Co.\n",
      "39.7246\n",
      "MÃ¼nchen\n",
      "Missing field/result... skipping.\n",
      "Bungay\n",
      "St Peter's Brewery\n",
      "36.7282\n",
      "Warwick\n",
      "Missing field/result... skipping.\n",
      "Leuven\n",
      "Brouwerij Artois\n",
      "50.8853\n",
      "Kailua-Kona\n",
      "Kona Brewing\n",
      "19.642\n",
      "Durham\n",
      "Steve and Clark's Brew Pub and Sausage Co. #2\n",
      "35.994\n",
      "Bethesda\n",
      "Tuppers Hop Pocket Ale\n",
      "38.9735\n",
      "Glen Alpine\n",
      "Missing field/result... skipping.\n",
      "Bellingham\n",
      "Boundary Bay Brewery and Bistro\n",
      "48.7475\n",
      "Missing field/result... skipping.\n",
      "Le Roeulx\n",
      "Brouwerij St-Feuillien\n",
      "50.5018\n",
      "Fresno\n",
      "Bulldog Brewing\n",
      "36.7477\n",
      "Missing field/result... skipping.\n",
      "Denver\n",
      "Great Divide Brewing\n",
      "39.7539\n",
      "Larkspur Landing\n",
      "Marin Brewing\n",
      "37.9479\n",
      "Webberville\n",
      "Michigan Brewing\n",
      "42.6616\n",
      "Pawleys Island\n",
      "Quigleys\n",
      "33.4905\n",
      "Tokyo\n",
      "Missing field/result... skipping.\n",
      "Placentia\n",
      "The Bruery\n",
      "33.8614\n",
      "Stoke Lacy\n",
      "Wye Valley Brewery\n",
      "52.1496\n",
      "Belgrade\n",
      "Big Hole Brewing\n",
      "45.7736\n",
      "Missoula\n",
      "Big Sky Brewing\n",
      "46.9223\n",
      "New Orleans\n",
      "Dixie Brewing\n",
      "29.9606\n",
      "Akron\n",
      "Hoppin Frog Brewery\n",
      "41.0247\n",
      "Missing field/result... skipping.\n",
      "South Barrington\n",
      "Millrose Brewing\n",
      "42.0855\n",
      "Missing field/result... skipping.\n",
      "London\n",
      "Watney Brewery\n",
      "51.5002\n",
      "Grand Rapids\n",
      "Big Buck Brewery and Steakhouse #2\n",
      "42.9634\n",
      "Albuquerque\n",
      "Blue Corn Caf and Brewery - Albuquerque\n",
      "35.0845\n",
      "Keene\n",
      "Elm City Brewing Co\n",
      "42.9324\n",
      "Escanaba\n",
      "Hereford & Hops Restaurant and Brewpub #1\n",
      "45.7458\n",
      "Camperdown\n",
      "Malt Shovel Brewery\n",
      "-33.8867\n",
      "Marquette\n",
      "Marquette Harbor Brewery and Restaurant\n",
      "46.5431\n",
      "Missing field/result... skipping.\n",
      "Lawton\n",
      "Old Hat Brewery\n",
      "42.1682\n",
      "St. John\n",
      "St John Brewers\n",
      "18.3368\n",
      "Adamstown\n",
      "Stoudt's Brewery\n",
      "40.2369\n",
      "Glasgow\n",
      "Tennent Caledonian Brewery\n",
      "55.8593\n",
      "Winnipeg\n",
      "Agassiz Brewing\n",
      "49.7652\n",
      "Henderson\n",
      "Barley's Casino & Brewing Company\n",
      "36.0721\n",
      "Nashville\n",
      "Blackstone Restaurant & Brewery\n",
      "36.152\n",
      "Chico\n",
      "Butte Creek Brewing\n",
      "39.7245\n",
      "Ponta Grossa\n",
      "Cervejaria Kaiser Brasil\n",
      "-25.1688\n",
      "Lake In The Hills\n",
      "Govnor's Public House\n",
      "42.1779\n",
      "O'Fallon\n",
      "O'Fallon Brewery\n",
      "38.8058\n",
      "Pullach im Isartal\n",
      "Restaurant Isarbru\n",
      "48.0708\n",
      "Saint Louis\n",
      "Route 66 Brewery\n",
      "38.647\n",
      "Dudley\n",
      "Sarah Hughes Brewery\n",
      "52.5435\n",
      "Bamberg\n",
      "Bamberger Mahr's-Bru\n",
      "49.8901\n",
      "The Borders\n",
      "Broughton Ales\n",
      "55.6145\n",
      "Albuquerque\n",
      "Chama River Brewing\n",
      "35.14\n",
      "Woesten\n",
      "De Struise Brouwers\n",
      "50.9229\n",
      "Missing field/result... skipping.\n",
      "Hood River\n",
      "Full Sail Brewing #1\n",
      "45.7103\n",
      "Fort Lauderdale\n",
      "Gordash Brewing Company\n",
      "26.0745\n",
      "Phoenix\n",
      "Leinenkugel's Ballyard Brewery\n",
      "33.4484\n",
      "Tourpes\n",
      "Brasserie Dupont\n",
      "50.5718\n",
      "Missing field/result... skipping.\n",
      "Ettal\n",
      "Ettaler Klosterbetriebe Abteilung Brauerei & Destillerie\n",
      "47.569\n",
      "Skegness\n",
      "George Bateman and Son Ltd.\n",
      "53.1691\n",
      "Waterloo\n",
      "Gold Crown Brewing\n",
      "43.4676\n",
      "Reading\n",
      "Legacy Brewing Co.\n",
      "40.3256\n",
      "Alpirsbach\n",
      "Alpirsbacher Klosterbru\n",
      "48.3457\n",
      "Orlando\n",
      "Beach Brewing\n",
      "28.5383\n",
      "Ecaussinnes\n",
      "Brasserie d'Ecaussinnes\n",
      "50.5593\n",
      "Lucan\n",
      "Brauhaus Brew Hall\n",
      "44.4105\n",
      "Dubuque\n",
      "Bricktown Brewery\n",
      "42.4965\n",
      "Ann Arbor\n",
      "Grizzly Peak Brewing\n",
      "42.2805\n",
      "Sonthofen\n",
      "Hirschbru Privatbrauerei Hss\n",
      "47.5132\n",
      "Addison\n",
      "Hoffbrau Steaks Brewery #1\n",
      "32.9618\n",
      "Hereford\n",
      "HP Bulmer\n",
      "42.2626\n",
      "Madison\n",
      "JT Whitney's Brewpub and Eatery\n",
      "43.0519\n",
      "Stillwater\n",
      "Lift Bridge Brewery\n",
      "45.0565\n",
      "Milwaukee\n",
      "Milwaukee Ale House\n",
      "43.0334\n",
      "Salt Lake City\n",
      "Utah Brewers Cooperative\n",
      "40.7322\n",
      "Missing field/result... skipping.\n",
      "Westport\n",
      "Buzzards Bay Brewing Inc.\n",
      "41.5713\n",
      "Crested Butte\n",
      "Crested Butte Brewery &  Pub\n",
      "38.8698\n",
      "Denver\n",
      "Dixon's Downtown Grill\n",
      "39.7541\n",
      "Grfelfing\n",
      "Missing field/result... skipping.\n",
      "Romsey\n",
      "Hampshire Brewery\n",
      "50.9889\n",
      "Abingdon\n",
      "Morland and Co.\n",
      "51.6701\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Longmont\n",
      "Pumphouse Brewery & Restaurant\n",
      "40.1688\n",
      "Denver\n",
      "Rock Bottom Restaurant & Brewery - Denver\n",
      "39.7472\n",
      "Missing field/result... skipping.\n",
      "Denmark\n",
      "Denmark Brewing\n",
      "44.3478\n",
      "La Jolla\n",
      "La Jolla Brewing\n",
      "33.8575\n",
      "Missing field/result... skipping.\n",
      "Jacksonville\n",
      "Margaritaville Brewing Company\n",
      "30.3617\n",
      "Exeter\n",
      "Missing field/result... skipping.\n",
      "Lambertville\n",
      "River Horse Brewing Company\n",
      "40.3688\n",
      "Selinsgrove\n",
      "Selin's Grove Brewing Co.\n",
      "40.801\n",
      "Berwyn\n",
      "Weinkeller Brewery - Berwyn\n",
      "41.8506\n",
      "Appleton\n",
      "Appleton Brewing\n",
      "44.2619\n",
      "Missing field/result... skipping.\n",
      "Mineral Point\n",
      "Brewery Creek Brewing\n",
      "42.8606\n",
      "Monterrey\n",
      "Cervecera Cuauhtmoc-Moctezuma\n",
      "25.7091\n",
      "Cincinnati\n",
      "Listermann Brewing Company\n",
      "39.1456\n",
      "Anchorage\n",
      "Midnight Sun Brewing Co.\n",
      "61.1473\n",
      "Missing field/result... skipping.\n",
      "Hillburn\n",
      "Ramapo Valley Brewery\n",
      "41.1151\n",
      "Buttenheim\n",
      "St. GeorgenBru Modschiedler KG\n",
      "49.802\n",
      "Las Vegas\n",
      "Tenaya Creek Restaurant and Brewery\n",
      "36.2154\n",
      "Wayne\n",
      "Valley Forge Brewing\n",
      "40.0439\n",
      "Milwaukee\n",
      "Water Street Brewery\n",
      "43.0448\n",
      "Ellezelles\n",
      "Brasserie Ellezelloise\n",
      "50.7428\n",
      "Pickering\n",
      "Cropton Brewery\n",
      "54.2912\n",
      "San Diego\n",
      "Del Mar Stuft Pizza and Brewing\n",
      "32.7153\n",
      "Albuquerque\n",
      "Dry Gulch Brewing\n",
      "35.0845\n",
      "Erie\n",
      "Erie Brewing Company\n",
      "42.1112\n",
      "Dallas\n",
      "Hoffbrau Steaks Brewery #2\n",
      "32.803\n",
      "Missing field/result... skipping.\n",
      "Chicago\n",
      "Revolution Brewing LLC\n",
      "41.9234\n",
      "Cortland\n",
      "Spilker Ales\n",
      "40.5058\n",
      "Glendale\n",
      "Sprecher Brewing\n",
      "43.1\n",
      "Seattle\n",
      "Thomas Kemper Brewing\n",
      "47.5924\n",
      "Colorado Springs\n",
      "Trinity Brewing Company\n",
      "38.8967\n",
      "Portland\n",
      "Widmer Brothers Brewing\n",
      "45.5408\n",
      "Clear Lake\n",
      "William Kuether Brewing\n",
      "45.2519\n",
      "Anacortes\n",
      "Anacortes Brewing\n",
      "48.5193\n",
      "Andechs\n",
      "Andechser Klosterbrauerei\n",
      "47.9775\n",
      "Missing field/result... skipping.\n",
      "Portland\n",
      "Hopworks Urban Brewery\n",
      "45.4969\n",
      "Dexter\n",
      "Jolly Pumpkin Artisan Ales\n",
      "42.3375\n",
      "Missing field/result... skipping.\n",
      "Santa Barbara\n",
      "Santa Barbara Brewing\n",
      "34.4166\n",
      "Ripon\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Brugge\n",
      "Brouwerij de Gouden Boom\n",
      "51.2094\n",
      "Portland\n",
      "D.L. Geary Brewing Company\n",
      "43.7076\n",
      "Petaluma\n",
      "Dempsey's Restaurant & Brewery\n",
      "38.2362\n",
      "Fenton\n",
      "Dirt Cheap Cigarettes and Beer\n",
      "38.5405\n",
      "Wilmington\n",
      "Wilmington Brewing\n",
      "34.2257\n",
      "Omaha\n",
      "Breckenridge BBQ of Omaha\n",
      "41.254\n",
      "San Diego\n",
      "Callahan's Pub and Brewery\n",
      "32.9147\n",
      "Columbia\n",
      "Flat Branch Pub & Brewing\n",
      "38.95\n",
      "Enschede\n",
      "Grolsche Bierbrouwerij\n",
      "52.2081\n",
      "Karlsruhe\n",
      "Hoepfner Privatbrauerei\n",
      "49.0125\n",
      "Petaluma\n",
      "Lagunitas Brewing Company\n",
      "38.2724\n",
      "Chilton\n",
      "Rowland's Calumet Brewery\n",
      "44.0291\n",
      "Chicago\n",
      "Missing field/result... skipping.\n",
      "Columbus\n",
      "Missing field/result... skipping.\n",
      "Plover\n",
      "Missing field/result... skipping.\n",
      "Bakersfield\n",
      "Bootleggers Steakhouse and Brewery\n",
      "35.3733\n",
      "Buggenhout\n",
      "Brouwerij De Landtsheer\n",
      "51.0228\n",
      "New York\n",
      "Chelsea Brewing Company\n",
      "40.7457\n",
      "Seattle\n",
      "Elysian Brewing - TangleTown\n",
      "47.6688\n",
      "Saint Paul\n",
      "Great Waters Brewing Company\n",
      "44.9467\n",
      "Sydney\n",
      "Lion Nathan Australia  Hunter Street\n",
      "-33.8687\n",
      "Burnley\n",
      "Moorhouse's Brewery (Burnley)\n",
      "53.7864\n",
      "Steenhuffel\n",
      "Palm Breweries\n",
      "50.9953\n",
      "Kln\n",
      "Privatbrauerei Gaffel\n",
      "50.9465\n",
      "Anchorage\n",
      "Railway Brewing\n",
      "61.2181\n",
      "Guelph\n",
      "Sleeman Brewing & Malting\n",
      "43.487\n",
      "Benton Harbor\n",
      "The Livery\n",
      "42.1185\n",
      "Missing field/result... skipping.\n",
      "Winona\n",
      "Backwater Brewing\n",
      "44.0486\n",
      "Missing field/result... skipping.\n",
      "Norman\n",
      "Coach's Norman\n",
      "35.2205\n",
      "Greenville\n",
      "Ham's Restaurant and Brewhouse\n",
      "35.6083\n",
      "Denver\n",
      "Heavenly Daze Brewery and Grill\n",
      "39.7392\n",
      "Montreal\n",
      "Le Cheval Blanc\n",
      "45.5181\n",
      "Lich\n",
      "Licher Privatbrauerei\n",
      "50.5208\n",
      "Missing field/result... skipping.\n",
      "Waterbury\n",
      "The Alchemist\n",
      "44.3372\n",
      "Burlington\n",
      "Vermont Pub & Brewery\n",
      "44.4773\n",
      "Battle Creek\n",
      "Arcadia Brewing\n",
      "42.322\n",
      "Missing field/result... skipping.\n",
      "Concord\n",
      "EJ Phair Brewing Company and Alehouse\n",
      "37.978\n",
      "Melbourne\n",
      "Florida Beer Company\n",
      "28.0707\n",
      "MÃ¼nchen\n",
      "Missing field/result... skipping.\n",
      "Walla Walla\n",
      "Mill Creek Brewpub\n",
      "46.0697\n",
      "Tempe\n",
      "Rio Salado Brewing\n",
      "33.4148\n",
      "Bad Schussenried\n",
      "Schussenrieder Erlebnisbrauerei\n",
      "48.004\n",
      "Aspen\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Olympia\n",
      "Fish Brewing Company & Fish Tail Brewpub\n",
      "47.0437\n",
      "Buffalo\n",
      "Flying Bison Brewing\n",
      "42.9561\n",
      "Missing field/result... skipping.\n",
      "Evergem\n",
      "ICOBES b.v.b.a.\n",
      "51.1007\n",
      "Bamberg\n",
      "Keesmann Bru\n",
      "49.8904\n",
      "Horsham\n",
      "King and Barnes\n",
      "51.0638\n",
      "Grimstad\n",
      "Missing field/result... skipping.\n",
      "Lyons\n",
      "Oskar Blues Grill and Brew\n",
      "40.2246\n",
      "South Stoke\n",
      "Ridgeway Brewing\n",
      "51.5462\n",
      "Eden Prairie\n",
      "Water Tower Brewing\n",
      "44.8652\n",
      "Ripon\n",
      "Missing field/result... skipping.\n",
      "Arena\n",
      "Lake Louie Brewing\n",
      "43.1706\n",
      "Mammoth Lakes\n",
      "Mammoth Brewing\n",
      "37.6484\n",
      "Ukiah\n",
      "Mendocino Brewing - Ukiah\n",
      "39.1326\n",
      "Pacific Beach\n",
      "Pacific Beach Brewhouse\n",
      "32.7978\n",
      "Seattle\n",
      "Pacific Rim Brewing\n",
      "47.5143\n",
      "Clinton\n",
      "Upper Mississippi Brewing\n",
      "41.8445\n",
      "Missing field/result... skipping.\n",
      "Rhinelander\n",
      "Brown Street Brewery\n",
      "45.638\n",
      "Brugge\n",
      "De Halve Maan\n",
      "51.2026\n",
      "Tempe\n",
      "Four Peaks Brewing\n",
      "33.4194\n",
      "Saint Cloud\n",
      "Granite City Food & Brewery - Saint Cloud\n",
      "45.5498\n",
      "Missing field/result... skipping.\n",
      "Wausau\n",
      "Hereford & Hops Steakhouse and Brewpub #3\n",
      "44.9518\n",
      "Missing field/result... skipping.\n",
      "Framingham\n",
      "John Harvard's Brew House - Framingham\n",
      "42.3037\n",
      "Morrisville\n",
      "Kross Brewing\n",
      "44.5617\n",
      "Kassel\n",
      "Martini-Brauerei\n",
      "51.3175\n",
      "Wisconsin Dells\n",
      "Moosejaw Pizza & Dells Brewing Company\n",
      "43.5907\n",
      "Fortworth\n",
      "Rahr & Sons Brewing Company\n",
      "32.7366\n",
      "Tucson\n",
      "Thunder Canyon Brewery\n",
      "32.3407\n",
      "Gilroy\n",
      "Coast Range Brewing\n",
      "37.0013\n",
      "Isle of Skye\n",
      "Isle of Skye Brewing Company\n",
      "56.4907\n",
      "Myrtle Beach\n",
      "Liberty Steakhouse and Brewery\n",
      "33.7187\n",
      "Lahaina, Maui\n",
      "Maui Brewing Co.\n",
      "20.9721\n",
      "Missing field/result... skipping.\n",
      "Boston\n",
      "Boston Beer Company\n",
      "42.3144\n",
      "Gloucester\n",
      "Cape Ann Brewing\n",
      "42.6102\n",
      "Regensburg\n",
      "Frstliche Brauerei Thurn Und Taxis Regensburg\n",
      "49.0156\n",
      "Sheboygan\n",
      "Hops Haven Brew Haus\n",
      "43.7594\n",
      "Missing field/result... skipping.\n",
      "Camino\n",
      "Jack Russell Brewing\n",
      "49.1482\n",
      "Lexington\n",
      "Kentucky Hemp Beer Company\n",
      "38.0317\n",
      "Ashland\n",
      "Standing Stone Brewing Company\n",
      "42.1976\n",
      "Escondido\n",
      "Stone Brewing Co.\n",
      "33.1157\n",
      "Appleton\n",
      "Stone Cellar Brewpub & Restaurant\n",
      "44.2536\n",
      "Portland\n",
      "Stone Coast Brewing - Portland\n",
      "43.71\n",
      "Providence\n",
      "The Narragansett Brewing Company\n",
      "41.819\n",
      "Wailuku\n",
      "Trade Winds Brewing\n",
      "20.8911\n",
      "Williamsport\n",
      "Abbey Wright Brewing/Valley Inn\n",
      "41.2225\n",
      "Missing field/result... skipping.\n",
      "Denver\n",
      "Flying Dog Brewery\n",
      "39.7582\n",
      "Victor\n",
      "Grand Teton Brewing #2\n",
      "43.5984\n",
      "Bamberg\n",
      "Klosterbru Bamberg\n",
      "49.8891\n",
      "Middlebury\n",
      "Otter Creek Brewing & Wolaver's Organic Ales\n",
      "44.0197\n",
      "Tarpon Springs\n",
      "Saint Somewhere Brewing Company\n",
      "28.1646\n",
      "Freetown\n",
      "Sierra Leone Brewery\n",
      "8.4841\n",
      "Fawn Grove\n",
      "South County Brewing Co.\n",
      "39.7323\n",
      "Toms River\n",
      "Basil T's Brew Pub and Italian Grill\n",
      "39.9767\n",
      "Missing field/result... skipping.\n",
      "Bamberg\n",
      "Brauerei Fssla\n",
      "49.8942\n",
      "Ertvelde\n",
      "Brouwerij Van Steenberge\n",
      "51.1766\n",
      "Durango\n",
      "Carver Brewing Co.\n",
      "37.2748\n",
      "Estes Park\n",
      "Estes Park Brewery\n",
      "40.3707\n",
      "Madison\n",
      "Fauerbach Brewing Company\n",
      "43.0844\n",
      "Iowa City\n",
      "Fitzpatrick's Brewing\n",
      "41.6611\n",
      "Cinderford\n",
      "Freeminer Brewery\n",
      "51.8325\n",
      "Missing field/result... skipping.\n",
      "Seattle\n",
      "Pike Pub and Brewery\n",
      "47.6081\n",
      "Antioch\n",
      "Schooner's Grille & Brewery\n",
      "37.9669\n",
      "Kempten\n",
      "Allguer Brauhaus AG Kempten\n",
      "47.7237\n",
      "Cannon Beach\n",
      "Bill's Tavern & Brewhouse\n",
      "45.8981\n",
      "Missing field/result... skipping.\n",
      "Kerkom\n",
      "Brouwerij Kerkom\n",
      "50.7763\n",
      "New Orleans\n",
      "Crescent City Brewhouse\n",
      "29.9558\n",
      "Hannover\n",
      "Gilde Brauerei\n",
      "52.3544\n",
      "Knigseggwald\n",
      "Knigsegger WalderBru\n",
      "47.9262\n",
      "Missing field/result... skipping.\n",
      "Dillon\n",
      "Pug Ryan's Steakhouse and Brewery\n",
      "39.6282\n",
      "Vancouver\n",
      "Yaletown Brewing\n",
      "49.2755\n",
      "San Diego\n",
      "AleSmith Brewing\n",
      "32.892\n",
      "Missing field/result... skipping.\n",
      "Meschede\n",
      "Brauerei C. & A. Veltins GmbH & Co.\n",
      "51.3055\n",
      "Mount Joy\n",
      "Bube's Brewery\n",
      "40.1119\n",
      "Mazatln\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Flossmoor\n",
      "Flossmoor Station Brewery\n",
      "41.5433\n",
      "Fort Collins\n",
      "HC Berger Brewing\n",
      "40.5853\n",
      "Ibaraki\n",
      "Missing field/result... skipping.\n",
      "Mequon\n",
      "Mambo Beer\n",
      "43.2167\n",
      "San Antonio\n",
      "Pete's Brewing\n",
      "29.5761\n",
      "Prescott\n",
      "Prescott Brewing Company\n",
      "34.542\n",
      "Bangor\n",
      "Sea Dog Brewing Company\n",
      "44.7974\n",
      "Burlington\n",
      "Switchback Brewing Co\n",
      "43.3906\n",
      "Bloomfield\n",
      "Thomas Hooker Brewing\n",
      "41.8087\n",
      "Lake Barrington\n",
      "Wild Onion Brewing\n",
      "42.2108\n",
      "Norwich\n",
      "Woodforde's Norfolk Ales\n",
      "52.6842\n",
      "Pottsville\n",
      "Yuengling & Son Brewing\n",
      "40.7\n",
      "Freising\n",
      "Bayerische Staatsbrauerei Weihenstephan\n",
      "48.3952\n",
      "Silly\n",
      "Brasserie de Silly\n",
      "50.6493\n",
      "Grand Island\n",
      "Copper Eagle Brewing\n",
      "47.9454\n",
      "Flagstaff\n",
      "Flagstaff Brewing\n",
      "35.1973\n",
      "Annapolis\n",
      "Fordham Brewing\n",
      "38.9773\n",
      "Boston\n",
      "Harpoon Brewery - Boston\n",
      "42.3465\n",
      "Missing field/result... skipping.\n",
      "Lahaska\n",
      "Porterhouse Restaurant and Brewpub\n",
      "40.3341\n",
      "Barre\n",
      "Stonecutters Brewhouse\n",
      "44.1972\n",
      "Missing field/result... skipping.\n",
      "Nrnberg\n",
      "Tucher Bru\n",
      "49.4643\n",
      "Boston\n",
      "Boston Beer Works\n",
      "42.347\n",
      "Harltepool\n",
      "Camerons Brewery Company\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "41.4995\n",
      "Missing field/result... skipping.\n",
      "Little Rock\n",
      "Diamond Bear Brewing Co.\n",
      "34.7473\n",
      "Tulsa\n",
      "Marshall Brewing Company\n",
      "36.152\n",
      "Sedona\n",
      "Oak Creek Brewery\n",
      "34.8661\n",
      "Orkney\n",
      "Orkney Brewery\n",
      "59.0697\n",
      "Dsseldorf\n",
      "Privatbrauerei Frankenheim\n",
      "51.2292\n",
      "Englewood\n",
      "Rock Bottom Restaurant & Brewery - South Denver\n",
      "39.5678\n",
      "Santa Rosa\n",
      "Third Street Ale Works\n",
      "38.4398\n",
      "Atlanta\n",
      "Atlanta Brewing Company\n",
      "33.818\n",
      "Cincinnati\n",
      "Hudepohl-Schoenling Brewing\n",
      "39.2651\n",
      "Wilmington\n",
      "John Harvard's Brewhouse - Wilmington\n",
      "39.7458\n",
      "Bamberg\n",
      "Kaiserdom Privatbrauerei Bamberg\n",
      "49.9043\n",
      "Kulmbach\n",
      "Kulmbacher Mnchshof Bru\n",
      "50.1077\n",
      "Ames\n",
      "Olde Main Brewing\n",
      "42.0248\n",
      "Scottsdale\n",
      "Pinnacle Peak Patio Steakhouse & Microbrewery\n",
      "33.7268\n",
      "Portland\n",
      "Pugsley Brewing LLC\n",
      "43.6615\n",
      "Frankenmuth\n",
      "Sullivan's Black Forest Brew Haus & Grill\n",
      "43.3152\n",
      "Hastings\n",
      "Walldorff Brew Pub\n",
      "42.6488\n",
      "Luton\n",
      "Whitbread Beer Company\n",
      "52.1357\n",
      "Lincolnville\n",
      "Andrew's Brewing\n",
      "44.3516\n",
      "Colorado Springs\n",
      "Blicks Brewing\n",
      "38.8339\n",
      "Mountain View\n",
      "Brew Makers\n",
      "37.3861\n",
      "Missing field/result... skipping.\n",
      "Delafield\n",
      "Delafield Brewhaus\n",
      "43.0481\n",
      "Stuttgart\n",
      "Missing field/result... skipping.\n",
      "Reckendorf\n",
      "Schlobrauerei Reckendorf\n",
      "50.0224\n",
      "Missing field/result... skipping.\n",
      "Stevenson\n",
      "Walking Man Brewery\n",
      "45.6922\n",
      "New Ulm\n",
      "August Schell Brewing\n",
      "44.2896\n",
      "Missing field/result... skipping.\n",
      "Wevelgem\n",
      "Brouwerij De Ranke\n",
      "50.8105\n",
      "Edinburgh\n",
      "Caledonian Brewing\n",
      "55.9358\n",
      "Gateshead\n",
      "Federation Brewery\n",
      "54.9548\n",
      "Seattle\n",
      "Hale's Ales #3\n",
      "47.6592\n",
      "LaConner\n",
      "LaConner Brewing\n",
      "48.3917\n",
      "Bernalillo\n",
      "Milagro Brewery and Grill\n",
      "35.3\n",
      "Boulder\n",
      "Mountain Sun Pub & Brewery\n",
      "40.019\n",
      "Peterborough\n",
      "Oakham Ales\n",
      "52.5758\n",
      "Austin\n",
      "Old City Brewing\n",
      "30.2767\n",
      "South Burlington\n",
      "Orlio Organic\n",
      "44.4284\n",
      "Lakewood\n",
      "Southern Tier Brewing Co\n",
      "42.1008\n",
      "Vancouver\n",
      "Storm Brewing\n",
      "49.2821\n",
      "Missing field/result... skipping.\n",
      "San Francisco\n",
      "Anchor Brewing\n",
      "37.7635\n",
      "Louisville\n",
      "Bluegrass Brewing Company, Inc.\n",
      "38.253\n",
      "Aying\n",
      "Brauerei Aying Franz Inselkammer KG\n",
      "47.9706\n",
      "Denver\n",
      "Breckenridge Brewery\n",
      "39.7236\n",
      "Blumenau\n",
      "Cervejaria Sudbrack\n",
      "-26.8914\n",
      "Warren\n",
      "Dragonmead Microbrewery\n",
      "42.493\n",
      "La Crosse\n",
      "G. Heileman Brewing\n",
      "43.8014\n",
      "Sparks\n",
      "Great Basin Brewing Company\n",
      "39.5349\n",
      "Chicago\n",
      "Piece\n",
      "41.9104\n",
      "Brooklyn Center\n",
      "Surly Brewing\n",
      "45.0429\n",
      "Missing field/result... skipping.\n",
      "Tampa\n",
      "Cigar City Brewing\n",
      "27.9587\n",
      "Boston\n",
      "Commonwealth Brewing #1\n",
      "42.3584\n",
      "Missing field/result... skipping.\n",
      "Walnut Creek\n",
      "Faultline Brewing #2\n",
      "37.8855\n",
      "Flensburg\n",
      "Flensburger Brauerei\n",
      "54.779\n",
      "Anchorage\n",
      "Glacier Brewhouse\n",
      "61.2179\n",
      "Fitchburg\n",
      "Great Dane Pub and Brewing #2\n",
      "43.0177\n",
      "Erding\n",
      "Privatbrauerei Erdinger Weissbru\n",
      "48.3153\n",
      "Saint Charles\n",
      "Trailhead Brewing Company\n",
      "38.7745\n",
      "Berlin\n",
      "Berliner-Kindl-Schultheiss-Brauerei\n",
      "52.5234\n",
      "Falmignoul\n",
      "Brasserie La Caracole\n",
      "50.2024\n",
      "Colorado Springs\n",
      "Bristol Brewing\n",
      "38.8097\n",
      "Saskatoon\n",
      "Canadian Brewery\n",
      "52.1344\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Wernigerode\n",
      "Hasserder Brauerei\n",
      "51.8439\n",
      "Hook Norton\n",
      "Hook Norton Brewery\n",
      "51.9966\n",
      "Albuquerque\n",
      "Marble Brewery\n",
      "35.0928\n",
      "Novato\n",
      "moylans Brewing company\n",
      "38.1074\n",
      "Dover\n",
      "Old Dominion Brewing Co.\n",
      "39.154\n",
      "MÃ¼nchen\n",
      "Missing field/result... skipping.\n",
      "Ursel\n",
      "Brouwerij The Musketiers\n",
      "51.1287\n",
      "Denver\n",
      "Bull & Bush Pub & Brewery\n",
      "39.705\n",
      "Kelowna\n",
      "Granville Island Brewing\n",
      "49.8945\n",
      "Longmont\n",
      "Left Hand Brewing Company\n",
      "40.1587\n",
      "Blue Lake\n",
      "Mad River Brewing Company\n",
      "40.8786\n",
      "Libertyville\n",
      "Mickey Finn's Brewery\n",
      "42.2872\n",
      "Baltimore\n",
      "Stillwater Artisanal Ales\n",
      "39.2904\n",
      "Kearney\n",
      "Thunderhead Brewery\n",
      "40.6966\n",
      "San Jose\n",
      "Tied House Cafe & Brewery - San Jose\n",
      "37.3362\n",
      "Missing field/result... skipping.\n",
      "Missing field/result... skipping.\n",
      "Utica\n",
      "F.X. Matt Brewing\n",
      "43.1045\n",
      "Dallas\n",
      "Main Street Brewing\n",
      "32.803\n",
      "Minneapolis\n",
      "Minneapolis Town Hall Brewery\n",
      "44.9732\n",
      "Korschenbroich\n",
      "Privatbrauerei Bolten\n",
      "51.1833\n",
      "Baroda\n",
      "The Round Barn Winery & Brewery\n",
      "41.9211\n",
      "DÃ¼sseldorf\n",
      "Missing field/result... skipping.\n",
      "Mnchen\n",
      "Hacker-Pschorr Bru\n",
      "48.1391\n",
      "Heimenkirch\n",
      "Meckatzer Lwenbru\n",
      "47.6308\n",
      "Kalamazoo\n",
      "Olde Peninsula Brewpub and Restaurant\n",
      "42.2936\n",
      "Bamberg\n",
      "Privater Brauereigasthof Greifenklau\n",
      "49.8851\n",
      "Chicago\n",
      "River West Brewing\n",
      "41.85\n",
      "Saint Helena\n",
      "Silverado Brewing\n",
      "38.5243\n",
      "Adelaide\n",
      "South Australian Brewing\n",
      "-34.9111\n",
      "Manhasset\n",
      "Two Dogs Beverage Company\n",
      "40.7964\n"
     ]
    }
   ],
   "source": [
    "for data in beer_json:\n",
    "    city=[]\n",
    "    State=[]\n",
    "    beer_id=[]\n",
    "    lat=[]\n",
    "    long=[]\n",
    "    try:\n",
    "        city = data['fields']['city']\n",
    "        state = data['fields']['state']\n",
    "        #df = df.append({'City':city},ignore_index=True)\n",
    "        print(city)\n",
    "        brewery_name = data['fields']['name_breweries']\n",
    "        lat = data['fields']['coordinates'][0]\n",
    "        long = data['fields']['coordinates'][1]\n",
    "        country = data['fields']['country']\n",
    "        print(brewery_name)\n",
    "        print(lat)\n",
    "        beer_jsondf = beer_jsondf.append({'City':city,'State':state,'brewery_name':brewery_name,'Latitude':lat,'Longitude':long,'Country':country},ignore_index=True)\n",
    "    except (KeyError, IndexError):\n",
    "         print(\"Missing field/result... skipping.\")\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "beer_jsondf = beer_jsondf.dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method NDFrame.describe of                City            State  \\\n",
       "0        Valparaiso          Indiana   \n",
       "1        Whitewater        Wisconsin   \n",
       "2        Minnetonka        Minnesota   \n",
       "3     San Francisco       California   \n",
       "4          Missoula          Montana   \n",
       "...             ...              ...   \n",
       "1161        Bamberg           Bayern   \n",
       "1162        Chicago         Illinois   \n",
       "1163   Saint Helena       California   \n",
       "1164       Adelaide  South Australia   \n",
       "1165      Manhasset         New York   \n",
       "\n",
       "                                           brewery_name        Country  \\\n",
       "0                                      Aberdeen Brewing  United States   \n",
       "1     Randy's Fun Hunters Brewery Restaurant and Ban...  United States   \n",
       "2                                       Sherlock's Home  United States   \n",
       "3                             Speakeasy Ales and Lagers  United States   \n",
       "4                                        Bayern Brewing  United States   \n",
       "...                                                 ...            ...   \n",
       "1161               Privater Brauereigasthof Greifenklau        Germany   \n",
       "1162                                 River West Brewing  United States   \n",
       "1163                                  Silverado Brewing  United States   \n",
       "1164                           South Australian Brewing      Australia   \n",
       "1165                          Two Dogs Beverage Company  United States   \n",
       "\n",
       "      Latitude  Longitude  \n",
       "0      41.4392   -87.1078  \n",
       "1      42.8320   -88.7140  \n",
       "2      44.9133   -93.5033  \n",
       "3      37.7387  -122.3810  \n",
       "4      46.8726  -114.0200  \n",
       "...        ...        ...  \n",
       "1161   49.8851    10.8823  \n",
       "1162   41.8500   -87.6501  \n",
       "1163   38.5243  -122.4970  \n",
       "1164  -34.9111   138.5750  \n",
       "1165   40.7964   -73.6990  \n",
       "\n",
       "[1166 rows x 6 columns]>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# check for unique values and drop duplicates as needed\n",
    "beer_jsondf.describe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1159"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "beer_jsondf[\"brewery_name\"].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# drop duplicates\n",
    "beer_json = beer_jsondf.drop_duplicates([\"brewery_name\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# save to csv\n",
    "beer_json.to_csv('beer_json.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sqlalchemy import create_engine \n",
    "from config import pw"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create database connection \n",
    "\n",
    "connection_string = f\"postgres:{pw}@localhost:5432/beer_db\"\n",
    "\n",
    "engine = create_engine(f'postgres://{connection_string}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "beer_json.to_sql(name='locationdata', con=engine, index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['beerdata', 'locationdata']"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Confirm tables\n",
    "engine.table_names()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>brewery_name</th>\n",
       "      <th>Country</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Valparaiso</td>\n",
       "      <td>Indiana</td>\n",
       "      <td>Aberdeen Brewing</td>\n",
       "      <td>United States</td>\n",
       "      <td>41.4392</td>\n",
       "      <td>-87.1078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Whitewater</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Randy's Fun Hunters Brewery Restaurant and Ban...</td>\n",
       "      <td>United States</td>\n",
       "      <td>42.8320</td>\n",
       "      <td>-88.7140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Minnetonka</td>\n",
       "      <td>Minnesota</td>\n",
       "      <td>Sherlock's Home</td>\n",
       "      <td>United States</td>\n",
       "      <td>44.9133</td>\n",
       "      <td>-93.5033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>San Francisco</td>\n",
       "      <td>California</td>\n",
       "      <td>Speakeasy Ales and Lagers</td>\n",
       "      <td>United States</td>\n",
       "      <td>37.7387</td>\n",
       "      <td>-122.3810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Missoula</td>\n",
       "      <td>Montana</td>\n",
       "      <td>Bayern Brewing</td>\n",
       "      <td>United States</td>\n",
       "      <td>46.8726</td>\n",
       "      <td>-114.0200</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            City       State  \\\n",
       "0     Valparaiso     Indiana   \n",
       "1     Whitewater   Wisconsin   \n",
       "2     Minnetonka   Minnesota   \n",
       "3  San Francisco  California   \n",
       "4       Missoula     Montana   \n",
       "\n",
       "                                        brewery_name        Country  Latitude  \\\n",
       "0                                   Aberdeen Brewing  United States   41.4392   \n",
       "1  Randy's Fun Hunters Brewery Restaurant and Ban...  United States   42.8320   \n",
       "2                                    Sherlock's Home  United States   44.9133   \n",
       "3                          Speakeasy Ales and Lagers  United States   37.7387   \n",
       "4                                     Bayern Brewing  United States   46.8726   \n",
       "\n",
       "   Longitude  \n",
       "0   -87.1078  \n",
       "1   -88.7140  \n",
       "2   -93.5033  \n",
       "3  -122.3810  \n",
       "4  -114.0200  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_sql_query('select * from locationdata', con=engine).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "# create connection for heroku db\n",
    "engine2 = create_engine(\"postgres://tqbdhzteqgwdyw:c7d66aabb7d4faa111c07b4c7bc80ec3945cdd5007def7303e8b114850aea028@ec2-52-7-15-198.compute-1.amazonaws.com:5432/d610h005vrmvi7\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "# save to heroku server\n",
    "beer_json.to_sql(name='locationdata', con=engine2, index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}