U2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "import requests as r\n",
    "import pandas as pd\n",
    "import ujson as json\n",
    "import shelve\n",
    "import wikipedia"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "#source = \"https://en.wikipedia.org/api.php?action=query&prop=revisions&rvprop=content&format=jsonfm&titles=Main%20Page\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "def all_edits():\n",
    "    round = 0\n",
    "    while True:\n",
    "        user = \"DemocraticLuntz\"\n",
    "        source = \"https://en.wikipedia.org/w/api.php?action=query&\"\n",
    "        props = \"ids|title|timestamp|comment|size|flags\"\n",
    "        limit = 100\n",
    "        body = \"list=usercontribs&ucuser={}&uclimit={}&ucdir=older&format=json&ucprop={}\".format(user,limit,props)\n",
    "        if round > 0:\n",
    "            body += \"&uccontinue=\" + results[\"continue\"][\"uccontinue\"]\n",
    "        page = r.get(source + body)\n",
    "        results = json.loads(page.content)\n",
    "        try:\n",
    "            for contrib in results['query']['usercontribs']:\n",
    "                yield contrib\n",
    "        except StopIteration:\n",
    "            break\n",
    "        round += 1\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true,
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "South Portland, Maine\n",
      "Hibberts Gore, Maine\n",
      "West Central Franklin, Maine\n",
      "North Franklin, Maine\n",
      "Millinocket, Maine\n",
      "Hartland, Maine\n",
      "East Hancock, Maine\n"
     ]
    },
    {
     "ename": "KeyError",
     "evalue": "'continue'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m\u001b[0m",
      "\u001b[0;31mKeyError\u001b[0mTraceback (most recent call last)",
      "\u001b[0;32m<ipython-input-12-96a8dac467e4>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      1\u001b[0m \u001b[0mall_of_them\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      2\u001b[0m \u001b[0;32mimport\u001b[0m \u001b[0mrandom\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 3\u001b[0;31m \u001b[0;32mfor\u001b[0m \u001b[0medit\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mall_edits\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      4\u001b[0m     \u001b[0mall_of_them\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0medit\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      5\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;34m\"svg\"\u001b[0m \u001b[0;32min\u001b[0m \u001b[0medit\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"title\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m<ipython-input-4-67c7136b6743>\u001b[0m in \u001b[0;36mall_edits\u001b[0;34m()\u001b[0m\n\u001b[1;32m      8\u001b[0m         \u001b[0mbody\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m\"list=usercontribs&ucuser={}&uclimit={}&ucdir=older&format=json&ucprop={}\"\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mformat\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0muser\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mlimit\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mprops\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      9\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mround\u001b[0m \u001b[0;34m>\u001b[0m \u001b[0;36m0\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 10\u001b[0;31m             \u001b[0mbody\u001b[0m \u001b[0;34m+=\u001b[0m \u001b[0;34m\"&uccontinue=\"\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0mresults\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"continue\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"uccontinue\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     11\u001b[0m         \u001b[0mpage\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mr\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0msource\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0mbody\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     12\u001b[0m         \u001b[0mresults\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mjson\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mloads\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mpage\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcontent\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mKeyError\u001b[0m: 'continue'"
     ]
    }
   ],
   "source": [
    "all_of_them = []\n",
    "import random\n",
    "for edit in all_edits():\n",
    "    all_of_them.append(edit)\n",
    "    if not \"svg\" in edit[\"title\"]:\n",
    "        if \", Maine\" in edit[\"title\"]:\n",
    "            if random.random() < .01:\n",
    "                print edit[\"title\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "140628"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(all_of_them)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "places = [z for z in all_of_them if not \"svg\" in z[\"title\"]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "p = wikipedia.page(places[20][\"title\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "city_shelf = shelve.open(\"all_places.shelf\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "28596\n"
     ]
    }
   ],
   "source": [
    "maine_cities = list(set([c[\"title\"] for c in all_of_them if (\", \" in c['title'] or \", Vermont\" in c['title'] or \", New Hampshire\" in c['title'])]))\n",
    "print len(maine_cities)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import regex as re"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\"('Airmont', 'village', 'Rockland County', 'New York')\""
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "city_shelf.keys()[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "city_shelf = shelve.open(\"new_places.shelf\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 160,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "def parse_row(row):\n",
    "    try:\n",
    "        y = int(row[:4])\n",
    "        pop = int(row[5:])\n",
    "    except:\n",
    "        return None\n",
    "    return (y,pop)\n",
    "\n",
    "def parse_bars(row):\n",
    "    try:\n",
    "        _,y,p = row.split(\"|\")\n",
    "        return((int(y),int(p)))\n",
    "    except:\n",
    "        return None\n",
    "\n",
    "def town_pops(article_title):\n",
    "    try:\n",
    "        content = city_shelf[article_title.encode(\"utf-8\")]\n",
    "        if \"#REDIRECT\" in content and len(content) < 100:\n",
    "            content = content.split(\"\\n\",1)[0]\n",
    "            old = article_title\n",
    "            article_title = re.sub(r\".*REDIRECT \\[\\[(.*)\\]\\][.\\n]*\",r\"\\1\",content)\n",
    "            print u\"redirecting {} to {}\".format(old,article_title)\n",
    "            _ = city_shelf[\"fake key just to trigger a new search foobah\"]\n",
    "    except KeyError:\n",
    "        if random.random() < .05:\n",
    "            print article_title\n",
    "        p = r.get(u\"https://en.wikipedia.org/w/index.php?action=raw&title={}\".format(article_title))\n",
    "        content = p.content\n",
    "        city_shelf[article_title.encode(\"utf-8\")] = content\n",
    "    if \"Census population\\n|\" in content:\n",
    "        start = content.index(\"US Census population\\n|\") + 13\n",
    "        method = parse_row\n",
    "        splitter=\"|\"\n",
    "    elif \"USCensusPop\\n|\" in content:\n",
    "        start = content.index(\"USCensusPop\\n|\") + 11\n",
    "        method = parse_row\n",
    "        splitter=\"|\"\n",
    "\n",
    "    elif \"Historical populations\\n|type= USA\" in content:\n",
    "        start = content.index(\"Historical populations\\n|type= USA\") + 34\n",
    "        splitter = \"\\n\"\n",
    "        method = parse_bars\n",
    "    else:\n",
    "        raise TypeError(content)\n",
    "    area = content[(start):(start + 500)]\n",
    "    bits = area.split(splitter)\n",
    "    return [pair for pair in map(method,bits) if pair is not None]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Macon County, Georgia\n",
      "Warren Park, Indiana\n",
      "Eunice, Louisiana\n",
      "Bloomfield Township, Crawford County, Pennsylvania\n",
      "Logansport, Indiana\n",
      "Clark, New Jersey\n",
      "Chesterfield Township, Macoupin County, Illinois\n",
      "Elmore, Ohio\n",
      "Benton Harbor, Michigan\n",
      "Portia, Arkansas\n",
      "Cattaraugus, New York\n",
      "Hindman, Kentucky\n",
      "Ira, New York\n",
      "Corning, Kansas\n",
      "Palm Beach Gardens, Florida\n",
      "Frankfort, Kansas\n",
      "Danville, Iowa\n",
      "Washoe County, Nevada\n",
      "Sublette County, Wyoming\n",
      "Spiro, Oklahoma\n",
      "Greene County, New York\n",
      "Iroquois Township, Iroquois County, Illinois\n",
      "Huron, Ohio\n",
      "Sycamore, South Carolina\n",
      "Belmond, Iowa\n",
      "Karthaus Township, Clearfield County, Pennsylvania\n",
      "Scobey, Montana\n",
      "Pattison, Texas\n",
      "Lincoln, Michigan\n",
      "Bratenahl, Ohio\n",
      "Cleveland County, Arkansas\n",
      "Delaware County, Iowa\n",
      "Anderson Township, Clark County, Illinois\n",
      "Country Life Acres, Missouri\n",
      "Ellsworth, Kansas\n",
      "Edgewood, Florida\n",
      "Galena, Missouri\n",
      "Wallowa County, Oregon\n",
      "Kincaid, Kansas\n",
      "Hardin County, Iowa\n",
      "Middletown, Orange County, New York\n",
      "Elm Springs, Arkansas\n",
      "Englishtown, New Jersey\n",
      "Henderson Township, Knox County, Illinois\n",
      "Ranger, Texas\n",
      "Evanston, Wyoming\n",
      "Shannon, Mississippi\n",
      "St. Helena, California\n",
      "Spring Lake, New Jersey\n",
      "Lavina, Montana\n",
      "Indian Rocks Beach, Florida\n",
      "Leigh, Nebraska\n",
      "Pierson, Florida\n",
      "Carrington, North Dakota\n",
      "Marcy, New York\n",
      "Pickens County, Alabama\n",
      "Nelson, British Columbia\n",
      "Hot Spring County, Arkansas\n",
      "Laurie, Missouri\n",
      "Hillsville, Virginia\n",
      "Russell, Minnesota\n",
      "Garland, Arkansas\n",
      "South Lineville, Missouri\n",
      "Massilon Township, Wayne County, Illinois\n",
      "Geistown, Pennsylvania\n",
      "Wausa, Nebraska\n",
      "Osterdock, Iowa\n",
      "Lovelock, Nevada\n",
      "Mettawa, Illinois\n",
      "Holland, Indiana\n",
      "Mauston, Wisconsin\n",
      "Kimberly, Alabama\n",
      "Rocky Ridge, Utah\n",
      "Wiggins, Mississippi\n",
      "Mountain View, Arkansas\n",
      "Kenney, Illinois\n",
      "East Aurora, New York\n",
      "Scottsville, Virginia\n",
      "Carleton, Nebraska\n",
      "Lisbon, Connecticut\n",
      "Preston County, West Virginia\n",
      "Baldwin City, Kansas\n",
      "Faribault County, Minnesota\n",
      "Shelbyville, Missouri\n",
      "Cleveland, Illinois\n",
      "Crewe, Virginia\n",
      "Buncombe, Illinois\n",
      "Pleasant Ridge Township, Livingston County, Illinois\n",
      "Southfield, Michigan\n",
      "Loma, North Dakota\n",
      "Pantego, North Carolina\n",
      "Sycamore Hills, Missouri\n",
      "Chatsworth Township, Livingston County, Illinois\n",
      "Grant-Valkaria, Florida\n",
      "Grafton, Nebraska\n",
      "Aurora, Cayuga County, New York\n",
      "Sundance, Wyoming\n",
      "Nauvoo Township, Hancock County, Illinois\n",
      "Baxter County, Arkansas\n",
      "Sylvania, Ohio\n",
      "Box Hill, Wiltshire\n",
      "Jefferson County, Oregon\n",
      "Highlands, New Jersey\n",
      "Boulder City, Nevada\n",
      "Brayton, Iowa\n",
      "Durant, Iowa\n",
      "Kirkwood, Atlanta\n",
      "Lemoore, California\n",
      "Willow Creek Township, Lee County, Illinois\n",
      "Creston, Nebraska\n",
      "China Grove, Texas\n",
      "Marion County, Illinois\n",
      "Shawnee, Perry County, Ohio\n",
      "Richland County, Montana\n",
      "Gallatin County, Montana\n",
      "Buellton, California\n",
      "Chambers, Nebraska\n",
      "Grand River Township, Wayne County, Iowa\n",
      "Mary Anderson (actress, born 1918)\n",
      "Clinton, North Carolina\n",
      "Farwell, Nebraska\n",
      "Emmett, Michigan\n",
      "Hackensack, New Jersey\n",
      "Burke County, North Dakota\n",
      "Sauk Centre, Minnesota\n",
      "Portland, Oregon\n",
      "Fletcher, North Carolina\n",
      "Tenino, Washington\n",
      "Moorhead, Mississippi\n",
      "The Concourse, Chatswood\n",
      "Clear Lake, South Dakota\n",
      "South Bend, Indiana\n",
      "Connellsville, Pennsylvania\n",
      "Warren County, Missouri\n",
      "Frankston, Texas\n",
      "Byron, Nebraska\n",
      "New Providence, New Jersey\n",
      "Pelican Bay, Texas\n",
      "Terry Township, Bradford County, Pennsylvania\n",
      "Kit Carson, Colorado\n",
      "Cameron County, Texas\n",
      "Felicity, Ohio\n",
      "Oldham County, Texas\n",
      "Wilmington, Will County, Illinois\n",
      "Westmont, Pennsylvania\n",
      "Fort Covington, New York\n",
      "Marble Hill, Missouri\n",
      "Mexico Beach, Florida\n",
      "Bernville, Pennsylvania\n",
      "Worden, Illinois\n",
      "New Morgan, Pennsylvania\n",
      "Arona, Pennsylvania\n",
      "New Carlisle, Ohio\n",
      "Hayti, Missouri\n",
      "Folly Beach, South Carolina\n",
      "Chickamauga, Georgia\n",
      "Coal Grove, Ohio\n",
      "Collins, Mississippi\n",
      "Belville, North Carolina\n",
      "Olmsted Falls, Ohio\n",
      "East Brady, Pennsylvania\n",
      "Dunleith Township, Jo Daviess County, Illinois\n",
      "Oswegatchie, New York\n",
      "Wrightstown, Wisconsin\n",
      "Woolsey, Georgia\n",
      "Overton, Texas\n",
      "Alston, Georgia\n",
      "Rockford, Iowa\n",
      "Jefferson Parish, Louisiana\n",
      "Wardsville, Missouri\n",
      "South Amboy, New Jersey\n",
      "Marion, South Dakota\n",
      "Carroll Township, Perry County, Pennsylvania\n",
      "Crawford County, Illinois\n",
      "San Benito, Texas\n",
      "Lancaster, Ohio\n",
      "Trafalgar, Indiana\n",
      "Williford, Arkansas\n",
      "Jackson, Missouri\n",
      "Ohio Township, Allegheny County, Pennsylvania\n",
      "Desha County, Arkansas\n",
      "Harrison County, Indiana\n",
      "Erath, Louisiana\n",
      "Gary, West Virginia\n",
      "Westport, Minnesota\n",
      "Appleton City, Missouri\n",
      "Stella, Nebraska\n",
      "Seneca Falls, New York\n",
      "Stanhope, New Jersey\n",
      "Bay Minette, Alabama\n",
      "Shenango Township, Lawrence County, Pennsylvania\n",
      "El Campo, Texas\n",
      "Holliday, Missouri\n",
      "Fall River Township, LaSalle County, Illinois\n",
      "Merwin, Missouri\n",
      "Gholson, Texas\n",
      "Glenville, Minnesota\n",
      "Wasco County, Oregon\n",
      "Wabash County, Illinois\n",
      "Marengo, Illinois\n",
      "Hoxie, Kansas\n",
      "New Site, Alabama\n",
      "Republican Party presidential primaries, 2016\n",
      "President Township, Venango County, Pennsylvania\n",
      "Camp Point, Illinois\n",
      "Palmyra, Wisconsin\n",
      "St. John, Kansas\n",
      "Jetmore, Kansas\n",
      "Monticello, Minnesota\n",
      "Pick City, North Dakota\n",
      "Covington High School (Covington, Louisiana)\n",
      "Crawford, Georgia\n",
      "Cary, Illinois\n",
      "Rivergrove, Oregon\n",
      "Conecuh County, Alabama\n",
      "Du Quoin, Illinois\n",
      "Primghar, Iowa\n",
      "Craigsville, Virginia\n",
      "Apollo, Pennsylvania\n",
      "Canal Township, Venango County, Pennsylvania\n",
      "Lowell, Michigan\n",
      "Valley Grande, Alabama\n",
      "Swan Valley, Idaho\n",
      "Flossmoor, Illinois\n",
      "Eldridge, Iowa\n",
      "Crane, Texas\n",
      "St. Mary's County, Maryland\n",
      "Osborne, Kansas\n",
      "Washington County, Kansas\n",
      "Summit, Kentucky\n",
      "Peach Orchard, Arkansas\n",
      "Wayne Township, Greene County, Pennsylvania\n",
      "Nettle Creek Township, Grundy County, Illinois\n",
      "Wanamingo, Minnesota\n",
      "Adams County, Illinois\n",
      "Penbrook, Pennsylvania\n",
      "Sioux City, Iowa\n",
      "Yellow Bluff, Alabama\n",
      "Peotone, Illinois\n",
      "Galesville, Wisconsin\n",
      "North Bend, Washington\n",
      "Red Bank, Tennessee\n",
      "Adams, Minnesota\n",
      "Waddington, New York\n",
      "Germantown, Ohio\n",
      "East Norwegian Township, Schuylkill County, Pennsylvania\n",
      "Glenwood, Minnesota\n",
      "Woodhull, Illinois\n",
      "Starbuck, Minnesota\n",
      "Washington County, Tennessee\n",
      "Laramie, Wyoming\n",
      "Garrettsville, Ohio\n",
      "Carroll County, Tennessee\n",
      "Elgin, Illinois\n",
      "Hamburg, Iowa\n",
      "Lyndonville, New York\n",
      "Eros, Louisiana\n",
      "St. Francis, Arkansas\n",
      "Pascola, Missouri\n",
      "Electra, Texas\n",
      "De Graff, Ohio\n",
      "Stites, Idaho\n",
      "Rocksprings, Texas\n",
      "Middleton, Wisconsin\n",
      "Olean Town, Cattaraugus County, New York\n",
      "Dwight, Nebraska\n",
      "Maquon Township, Knox County, Illinois\n",
      "North Liberty, Indiana\n",
      "New Salem, North Dakota\n",
      "Sanford, Florida\n",
      "Cardinal O'Hara High School (Springfield, Pennsylvania)\n",
      "Vina, Alabama\n",
      "Christiansburg, Ohio\n",
      "Trenton, Missouri\n",
      "Avoca, Minnesota\n",
      "Needham, Alabama\n",
      "Union County, Florida\n",
      "Altadena, California\n",
      "Burrillville, Rhode Island\n",
      "Summersville, West Virginia\n",
      "La Grange, Texas\n",
      "Driggs, Idaho\n",
      "Lima, New York\n",
      "Waterloo, Illinois\n",
      "Catharine, New York\n",
      "Crosbyton, Texas\n",
      "Topeka, Kansas\n",
      "Wheeler, Oregon\n",
      "Levasy, Missouri\n",
      "Poplar, Wisconsin\n",
      "Bordentown, New Jersey\n",
      "Northport, Washington\n",
      "Cincinnati, Iowa\n",
      "East Amwell Township, New Jersey\n",
      "Rollingwood, Texas\n",
      "Asbury, Missouri\n",
      "Helena, Ohio\n",
      "Scofield, Utah\n",
      "Cash, Arkansas\n",
      "Polk Township, Macoupin County, Illinois\n",
      "Arabi, Georgia\n",
      "South Annville Township, Lebanon County, Pennsylvania\n",
      "Tredyffrin Township, Chester County, Pennsylvania\n",
      "Georgetown, Floyd County, Indiana\n",
      "Barrett, Minnesota\n",
      "Duncan, Mississippi\n",
      "Hartland, New York\n",
      "Albany, Ohio\n",
      "Centerville, Gallia County, Ohio\n",
      "Lamar County, Alabama\n",
      "Lee, Illinois\n",
      "Wingo, Kentucky\n",
      "Littlestown, Pennsylvania\n",
      "Buhler, Kansas\n",
      "Harvey County, Kansas\n",
      "Black Creek, Wisconsin\n",
      "Mattoon, Wisconsin\n",
      "Enterprise, Kansas\n",
      "Indiantown Township, Bureau County, Illinois\n",
      "Center, Texas\n",
      "Kerman, California\n",
      "Ligonier, Pennsylvania\n",
      "Spring Grove, Indiana\n",
      "Shoals, Indiana\n",
      "Proctor, Minnesota\n",
      "Lower Augusta Township, Northumberland County, Pennsylvania\n",
      "Oconto, Wisconsin\n",
      "Carlisle, New York\n",
      "Gogebic County, Michigan\n",
      "Milton, West Virginia\n",
      "Lawrence County, Indiana\n",
      "Pomaria, South Carolina\n",
      "Davenport, Washington\n",
      "Freeburg Township, St. Clair County, Illinois\n",
      "Tonti Township, Marion County, Illinois\n",
      "Door County, Wisconsin\n",
      "Rogersville, Alabama\n",
      "Madison County, Indiana\n",
      "Cooperstown, North Dakota\n",
      "Avon, New York\n",
      "Iredell County, North Carolina\n",
      "Ossian, New York\n",
      "Chappell, Nebraska\n",
      "Spencer, Wisconsin\n",
      "Spencer, Indiana\n",
      "Port Chester, New York\n",
      "Cundall, North Yorkshire\n",
      "LaRue, Ohio\n",
      "Hollandale, Wisconsin\n",
      "Georgetown, Beaver County, Pennsylvania\n",
      "Rowesville, South Carolina\n",
      "Monroe Township, Juniata County, Pennsylvania\n",
      "Dublin, Ohio\n",
      "Emerson, New Jersey\n",
      "Winnetka, Illinois\n",
      "Okay Ka, Fairy Ko!\n",
      "Hamilton County, Ohio\n",
      "Vinita Park, Missouri\n",
      "Mount Orab, Ohio\n",
      "Edna, Texas\n",
      "Franklin County, North Carolina\n",
      "Waycross, Georgia\n",
      "Red Lake County, Minnesota\n",
      "Riddleville, Georgia\n",
      "Shelbyville, Indiana\n",
      "Pekin, Illinois\n",
      "Old Forge, Lackawanna County, Pennsylvania\n",
      "Brown City, Michigan\n",
      "Rockefeller Township, Northumberland County, Pennsylvania\n",
      "Portage, New York\n",
      "Georgetown, Quitman County, Georgia\n",
      "Spafford, New York\n",
      "Primera, Texas\n",
      "Onondaga County, New York\n",
      "Overbrook, Kansas\n",
      "Inverness, Illinois\n",
      "Caledonia, Minnesota\n",
      "Grayson County, Texas\n",
      "Henderson, North Carolina\n",
      "Caledonia, New York\n",
      "Ackworth, Iowa\n",
      "Buchanan, Michigan\n",
      "Whitehall, Ohio\n",
      "Westfield, New York\n",
      "Olive Township, Madison County, Illinois\n",
      "Walton (town), New York\n",
      "Whitehall, Allegheny County, Pennsylvania\n",
      "Nashville, Georgia\n",
      "Elvaston, Illinois\n",
      "Toby Township, Clarion County, Pennsylvania\n",
      "O'Neill, Nebraska\n",
      "Ash Grove Township, Iroquois County, Illinois\n",
      "Greenup, Illinois\n",
      "Peletier, North Carolina\n",
      "Gardner Township, Sangamon County, Illinois\n",
      "Kurten, Texas\n",
      "Scotland, Georgia\n",
      "Lisbon, Illinois\n",
      "Upper Fairfield Township, Lycoming County, Pennsylvania\n",
      "Maple Heights, Ohio\n",
      "Elk Point, South Dakota\n",
      "Haslet, Texas\n",
      "Albers, Illinois\n",
      "Greencastle, Missouri\n",
      "Wood County, Ohio\n",
      "Chambers County, Texas\n",
      "Monroe, Oregon\n",
      "Forest Grove, Oregon\n",
      "Rush Springs, Oklahoma\n",
      "Newton, Georgia\n",
      "Solen, North Dakota\n",
      "Bainbridge, Indiana\n",
      "Edwards, Illinois\n",
      "Ravenna, Texas\n",
      "Ranchester, Wyoming\n",
      "Princeton Township, New Jersey\n",
      "Browns, Illinois\n",
      "Culdesac, Idaho\n",
      "Benton County, Arkansas\n",
      "La Jara, Colorado\n",
      "Webster County, Kentucky\n",
      "Wheeler County, Nebraska\n",
      "Alpine, Wyoming\n",
      "Tracy City, Tennessee\n",
      "Schley County, Georgia\n",
      "Daingerfield, Texas\n",
      "Mosheim, Tennessee\n",
      "Sharpsburg, Pennsylvania\n",
      "Meacham Township, Marion County, Illinois\n",
      "Pilot Mountain, North Carolina\n",
      "Montgomery County, Missouri\n",
      "Edwards, Mississippi\n",
      "Merrillville, Indiana\n",
      "Toppenish, Washington\n",
      "Cedar County, Missouri\n",
      "Cambridge, Idaho\n",
      "Haskell County, Texas\n",
      "Magellan Health, Inc.\n",
      "Cherry Hills Village, Colorado\n",
      "Providence Village, Texas\n",
      "Clarington, Ohio\n",
      "Kapileswarapuram, Krishna district\n",
      "Teachey, North Carolina\n",
      "Pamplin City, Virginia\n",
      "Central City, Illinois\n",
      "Lake Aluma, Oklahoma\n",
      "Pembroke, Virginia\n",
      "Ocean County, New Jersey\n",
      "Tuscumbia, Missouri\n",
      "Augusta, Kansas\n",
      "Lewisville, Minnesota\n",
      "Bluefield, Virginia\n",
      "Worcester County, Massachusetts\n",
      "Middletown, Ohio\n",
      "The Village, Oklahoma\n",
      "Byers, Texas\n",
      "River Forest, Indiana\n",
      "Pigeon Falls, Wisconsin\n",
      "Montpelier, Indiana\n",
      "Centennial, Colorado\n",
      "Coffey County, Kansas\n",
      "Bowling Green, Missouri\n",
      "Hope Township, New Jersey\n",
      "Hartly, Delaware\n",
      "Columbus Township, Adams County, Illinois\n",
      "Snow Hill, North Carolina\n",
      "Richland, Indiana\n",
      "Fairwater, Wisconsin\n",
      "Claire City, South Dakota\n",
      "Leominster, Massachusetts\n",
      "Grafton Township, McHenry County, Illinois\n",
      "Toledo, Oregon\n",
      "Buda, Texas\n",
      "Lamoine Township, McDonough County, Illinois\n",
      "Wayne, New Jersey\n",
      "Askewville, North Carolina\n",
      "North Buffalo Township, Armstrong County, Pennsylvania\n",
      "Regan, North Dakota\n",
      "Stanley, Iowa\n",
      "Sanger, California\n",
      "Milledgeville, Ohio\n",
      "Goodridge, Minnesota\n",
      "Elk Garden, West Virginia\n",
      "Hollister, Idaho\n",
      "Kaufman, Texas\n",
      "Chambersburg, Pennsylvania\n",
      "Palm Beach, Florida\n",
      "Dutch John, Utah\n",
      "East Arcadia, North Carolina\n",
      "Pellston, Michigan\n",
      "Big Falls, Waupaca County, Wisconsin\n",
      "Crossnore, North Carolina\n",
      "Cincinnati Township, Pike County, Illinois\n",
      "Sparta, New York\n",
      "Birkdale, New Zealand\n",
      "West Keating Township, Clinton County, Pennsylvania\n",
      "Willow Lake, South Dakota\n",
      "Seymour, Wisconsin\n",
      "Leidy Township, Clinton County, Pennsylvania\n",
      "Turner County, Georgia\n",
      "Leipsic, Delaware\n",
      "Green, Ohio\n",
      "Forsyth County, Georgia\n",
      "Shelburn, Indiana\n",
      "Wadena, Iowa\n",
      "Reedsburg, Wisconsin\n",
      "Dodge County, Nebraska\n",
      "Woodland, Alabama\n",
      "Evans Mills, New York\n",
      "Francis, Utah\n",
      "Taylor County, Georgia\n",
      "Blythe, California\n",
      "Alta Vista, Iowa\n",
      "Magnolia, Arkansas\n",
      "Wakonda, South Dakota\n",
      "Colebrookdale Township, Berks County, Pennsylvania\n",
      "Southlake, Texas\n",
      "Moscow, Kansas\n",
      "Sunbury Township, Livingston County, Illinois\n",
      "Mt. Angel, Oregon\n",
      "Lilbourn, Missouri\n",
      "Greenfield, Ohio\n",
      "Dovray, Minnesota\n",
      "Midland Park, New Jersey\n",
      "New Miami, Ohio\n",
      "Potter Township, Centre County, Pennsylvania\n",
      "Monticello, New York\n",
      "Wake County, North Carolina\n",
      "Sarpy County, Nebraska\n",
      "Mountain View, Wyoming\n",
      "Endicott, Washington\n",
      "Union City, New Jersey\n",
      "Danforth Township, Iroquois County, Illinois\n",
      "Seelyville, Indiana\n",
      "Oakville, Iowa\n",
      "Montrose, Pennsylvania\n",
      "Gonvick, Minnesota\n",
      "Sidney (village), New York\n",
      "Manly, Iowa\n",
      "Hawthorne Township, White County, Illinois\n",
      "Desloge, Missouri\n",
      "Malden, Washington\n",
      "Englewood, Tennessee\n",
      "Goose Creek Township, Piatt County, Illinois\n",
      "McConnelsville, Ohio\n",
      "West Bethlehem Township, Washington County, Pennsylvania\n",
      "Gustine, Texas\n",
      "High Bridge, New Jersey\n",
      "San Leanna, Texas\n",
      "Christ's College, Christchurch\n",
      "Lamar, South Carolina\n",
      "Hackettstown, New Jersey\n",
      "Estacada, Oregon\n",
      "Walnut Ridge, Arkansas\n",
      "Clinton, Oneida County, New York\n",
      "Red Creek, New York\n",
      "Parma, Michigan\n",
      "Madison County, New York\n",
      "Collegeville, Pennsylvania\n",
      "Jefferson, Ohio\n",
      "Tallassee, Alabama\n",
      "Hadley, Minnesota\n",
      "Yemassee, South Carolina\n",
      "Cameron, Oklahoma\n",
      "Bronxville, New York\n",
      "South Wilmington, Illinois\n",
      "Stoddard County, Missouri\n",
      "Seven Hickory Township, Coles County, Illinois\n",
      "Trousdale County, Tennessee\n",
      "Dover, Ohio\n",
      "Liberty, Kentucky\n",
      "Kensington, Minnesota\n",
      "Scott County, Minnesota\n",
      "Homer Glen, Illinois\n",
      "Gilliam, Missouri\n",
      "Raiford, Florida\n",
      "Glen Alpine, North Carolina\n",
      "Southgate, Kentucky\n",
      "East Chillisquaque Township, Northumberland County, Pennsylvania\n",
      "Optima, Oklahoma\n",
      "Camanche, Iowa\n",
      "Carter, Oklahoma\n",
      "Bowen, Illinois\n",
      "Rio Vista, California\n",
      "Huttonsville, West Virginia\n",
      "Mount Olivet, Kentucky\n",
      "Jefferson, York County, Pennsylvania\n",
      "Onekama, Michigan\n",
      "Harris, Iowa\n",
      "Slippery Rock Township, Lawrence County, Pennsylvania\n",
      "Mississippi County, Missouri\n",
      "Antrim Township, Franklin County, Pennsylvania\n",
      "Spring Lake, Indiana\n",
      "South Lebanon, Ohio\n",
      "Orestes, Indiana\n",
      "Salt Creek Township, Mason County, Illinois\n",
      "Passaic County, New Jersey\n",
      "Fort Loramie, Ohio\n",
      "Nicholson, Georgia\n",
      "Martin County, North Carolina\n",
      "Arapahoe, North Carolina\n",
      "Camdenton, Missouri\n",
      "Kingman, Indiana\n",
      "Warm River, Idaho\n",
      "Scarville, Iowa\n",
      "New Lothrop, Michigan\n",
      "Baldwin Park, California\n",
      "Lake Township, Wayne County, Pennsylvania\n",
      "Modesto, California\n",
      "Stewartville, Minnesota\n",
      "Skykomish, Washington\n",
      "Beallsville, Ohio\n",
      "Iowa County, Iowa\n",
      "Port Jervis, New York\n",
      "Omega Township, Marion County, Illinois\n",
      "Donna, Texas\n",
      "Sunset Hills, Missouri\n",
      "Ocean City, New Jersey\n",
      "Colma, California\n",
      "Salisbury Town, Herkimer County, New York\n",
      "Hayward, Wisconsin\n",
      "Campbell Station, Arkansas\n",
      "Amesbury, Massachusetts\n",
      "Grandview, Washington\n",
      "Osceola Township, Tioga County, Pennsylvania\n",
      "Nueces County, Texas\n",
      "Watkinsville, Georgia\n",
      "Ottawa, Ohio\n",
      "Grant County, Minnesota\n",
      "Cuney, Texas\n",
      "Richmond, California\n",
      "Tualatin, Oregon\n",
      "Simpsonville, Kentucky\n",
      "La Marque, Texas\n",
      "West Liberty, West Virginia\n",
      "Currie, Minnesota\n",
      "Nassau Bay, Texas\n",
      "Dorchester, Texas\n",
      "Foster Township, Madison County, Illinois\n",
      "Pahokee, Florida\n",
      "Milford, Utah\n",
      "Zilwaukee, Michigan\n",
      "Cass County, Michigan\n",
      "Amador County, California\n",
      "List of universities and colleges in Kota, Rajasthan\n",
      "Worthington, Iowa\n",
      "Rochelle, Georgia\n",
      "Bainbridge, New York\n",
      "Elmore City, Oklahoma\n",
      "Bridgeport, West Virginia\n",
      "Palos Park, Illinois\n",
      "Sheldon, Iowa\n",
      "Holly Hill, South Carolina\n",
      "Laurium, Michigan\n",
      "Louin, Mississippi\n",
      "Winchester, Arkansas\n",
      "Northview High School (Dothan, Alabama)\n",
      "Elko County, Nevada\n",
      "Harristown, Illinois\n",
      "Hubbard, Iowa\n",
      "Mound City, Missouri\n",
      "Proctorville, North Carolina\n",
      "Ernest, Pennsylvania\n",
      "Buckhannon, West Virginia\n",
      "Coalton, Ohio\n",
      "Lake Ozark, Missouri\n",
      "Middleville, Michigan\n",
      "Eagleswood Township, New Jersey\n",
      "Turtle Lake, Wisconsin\n",
      "Hampden Township, Cumberland County, Pennsylvania\n",
      "Cosmos, Minnesota\n",
      "Pratt County, Kansas\n",
      "Marsing, Idaho\n",
      "Hookstown, Pennsylvania\n",
      "Sturgis, Mississippi\n",
      "Black Brook, New York\n",
      "Milton (town), New York\n",
      "Macon, Georgia\n",
      "Cupertino, California\n",
      "Bonners Ferry, Idaho\n",
      "Bristol Township, Bucks County, Pennsylvania\n",
      "Logan, Kansas\n",
      "Richland Township, Venango County, Pennsylvania\n",
      "Huron, South Dakota\n",
      "Beaumont, Texas\n",
      "Great Bend, Kansas\n",
      "Bergman, Arkansas\n",
      "Avon, Minnesota\n",
      "Benton, Kentucky\n",
      "Thiensville, Wisconsin\n",
      "Dupo, Illinois\n",
      "Oswayo Township, Potter County, Pennsylvania\n",
      "Douglas, Wyoming\n",
      "Shageluk, Alaska\n",
      "Ward Township, Tioga County, Pennsylvania\n",
      "Pleasant Hill, California\n",
      "Spring Lake Township, Tazewell County, Illinois\n",
      "Plaucheville, Louisiana\n",
      "Tusten, New York\n",
      "Pleak, Texas\n",
      "Lake Elmo, Minnesota\n",
      "Islamorada, Florida\n",
      "Bakersfield, Missouri\n",
      "Port Allegany, Pennsylvania\n",
      "Windham (town), New York\n",
      "Gainesville, Georgia\n",
      "Jamestown, Missouri\n",
      "Auburn, Illinois\n",
      "Calion, Arkansas\n",
      "Peekskill, New York\n",
      "Harrogate, Tennessee\n",
      "Douglass Township, Berks County, Pennsylvania\n",
      "Double, Double, Toil and Trouble\n",
      "Lincoln County, Kentucky\n",
      "Golden Gate, Illinois\n",
      "Spencer, Oklahoma\n",
      "Woodside Township, Sangamon County, Illinois\n",
      "Pleasant Prairie, Wisconsin\n",
      "Kentwood, Louisiana\n",
      "Jordan Township, Lycoming County, Pennsylvania\n",
      "Turin, New York\n",
      "Lynn Township, Lehigh County, Pennsylvania\n",
      "Conway, Iowa\n",
      "Wood Lake, Minnesota\n",
      "Geneva, Ohio\n",
      "Windsor, Mercer County, Illinois\n",
      "Chelsea, Oklahoma\n",
      "Scales Mound, Illinois\n",
      "Irvington Township, Washington County, Illinois\n",
      "Chester Hill, Pennsylvania\n",
      "Knoxville, Pennsylvania\n",
      "Chevy Chase Section Three, Maryland\n",
      "Centerville, Missouri\n",
      "Lukin Township, Lawrence County, Illinois\n",
      "Pleasantville, Iowa\n",
      "Bourbonnais, Illinois\n",
      "Hammondville, Alabama\n",
      "Tea, South Dakota\n",
      "Rosemount, Minnesota\n",
      "Jo Daviess County, Illinois\n",
      "Dobson, North Carolina\n",
      "Wabasso, Minnesota\n",
      "Talk:Briarcliff Manor, New York\n",
      "Dunmore, Pennsylvania\n",
      "Youngtown, Arizona\n",
      "Cuba City, Wisconsin\n",
      "Big Stone County, Minnesota\n",
      "Daisytown, Pennsylvania\n",
      "Lone Rock, Wisconsin\n",
      "St. Charles, Minnesota\n",
      "Catron County, New Mexico\n",
      "Miltonvale, Kansas\n",
      "Clarendon County, South Carolina\n",
      "Ringtown, Pennsylvania\n",
      "Tolley, North Dakota\n",
      "Fennville, Michigan\n",
      "Kewaunee County, Wisconsin\n",
      "LaGrange County, Indiana\n",
      "Dimondale, Michigan\n",
      "Williamsburg, Iowa\n",
      "Sidney, Ohio\n",
      "Liberty, Nebraska\n",
      "Sibley, Missouri\n",
      "Hamilton, North Dakota\n",
      "Cicero, New York\n",
      "Slocomb, Alabama\n",
      "Comstock, Nebraska\n",
      "McKenzie County, North Dakota\n",
      "Meggett, South Carolina\n",
      "Spearman, Texas\n",
      "Laura, Ohio\n",
      "Morristown (town), New York\n",
      "Henry County, Georgia\n",
      "Dickinson Township, Cumberland County, Pennsylvania\n",
      "Selmont-West Selmont, Alabama\n",
      "Beaver, Arkansas\n",
      "Bell Township, Clearfield County, Pennsylvania\n",
      "Coolidge, Arizona\n",
      "Maryville, Tennessee\n",
      "Lewisville, Texas\n",
      "Turbotville, Pennsylvania\n",
      "Turin (village), New York\n",
      "Anacoco, Louisiana\n",
      "Baxley, Georgia\n",
      "Sarcoxie, Missouri\n",
      "Abbeville, Georgia\n",
      "Olympia, Washington\n",
      "Cashion Community, Texas\n",
      "Ball's Falls, Ontario\n",
      "Hastings, Florida\n",
      "Kildeer, Illinois\n",
      "Upper Saddle River, New Jersey\n",
      "Ochlocknee, Georgia\n",
      "Moravia (village), New York\n",
      "Clarke County, Mississippi\n",
      "Newtown, Missouri\n",
      "Watertown (town), New York\n",
      "Water Valley, Mississippi\n",
      "Witt, Illinois\n",
      "Boiling Springs, North Carolina\n",
      "South Crouch Township, Hamilton County, Illinois\n",
      "Latty, Ohio\n",
      "Bradley Township, Jackson County, Illinois\n",
      "East Butler, Pennsylvania\n",
      "Massac County, Illinois\n",
      "Coffee County, Georgia\n",
      "Somers Point, New Jersey\n",
      "Pawnee, Oklahoma\n",
      "Columbia, New York\n",
      "Mooresville, North Carolina\n",
      "Millbrook, New York\n",
      "Manning, Iowa\n",
      "Sultan, Washington\n",
      "Lonoke County, Arkansas\n",
      "Alsip, Illinois\n",
      "Greene Township, Greene County, Pennsylvania\n",
      "Jackson's Gap, Alabama\n",
      "Silver City, Mississippi\n",
      "Prairie Grove, Illinois\n",
      "Felsenthal, Arkansas\n",
      "Sylvan Beach, New York\n",
      "Athens, Wisconsin\n",
      "Green Ridge, Missouri\n",
      "Downey, Idaho\n",
      "Sullivan County, Pennsylvania\n",
      "Altamont, Illinois\n",
      "Daisetta, Texas\n",
      "Medora, Illinois\n",
      "River Bluff, Kentucky\n",
      "Valliant, Oklahoma\n",
      "Barbour County, West Virginia\n",
      "Ortonville, Michigan\n",
      "Monroe, New York\n",
      "Bloomburg, Texas\n",
      "Pike Township, Bradford County, Pennsylvania\n",
      "Piercefield, New York\n",
      "Oak Harbor, Ohio\n",
      "Chester, Connecticut\n",
      "Richford, New York\n",
      "Tolono Township, Champaign County, Illinois\n",
      "Granville, West Virginia\n",
      "Niota, Tennessee\n",
      "Brant, New York\n",
      "Gans, Oklahoma\n",
      "Riverside Township, New Jersey\n",
      "Ryan Woods (footballer, born 1993)\n",
      "Arthur, Nebraska\n",
      "St. Thomas, North Dakota\n",
      "Braddock, North Dakota\n",
      "South Lead Hill, Arkansas\n",
      "Danforth, Illinois\n",
      "Centerville, Crawford County, Pennsylvania\n",
      "Harter Township, Clay County, Illinois\n",
      "Logan, Ohio\n",
      "Lynnville, Tennessee\n",
      "Taylor County, Texas\n",
      "Rhodhiss, North Carolina\n",
      "New Waterford, Ohio\n",
      "Lincoln County, New Mexico\n",
      "Stark City, Missouri\n",
      "Franklin County, Arkansas\n",
      "Mayfield, Kentucky\n",
      "Athensville Township, Greene County, Illinois\n",
      "Valley City, North Dakota\n",
      "Jefferson Township, Dauphin County, Pennsylvania\n",
      "McClain County, Oklahoma\n",
      "Central City, Colorado\n",
      "Roeland Park, Kansas\n",
      "Trenton, North Carolina\n",
      "Bogue, Kansas\n",
      "Blount Township, Vermilion County, Illinois\n",
      "Letterkenny Township, Franklin County, Pennsylvania\n",
      "Sedan, Minnesota\n",
      "Cedar County, Iowa\n",
      "Corbin City, New Jersey\n",
      "Rensselaer, Indiana\n",
      "Eagle Lake, Minnesota\n",
      "Luzerne, Iowa\n",
      "Marlboro Township, New Jersey\n",
      "Lowe Township, Moultrie County, Illinois\n",
      "Belmont County, Ohio\n",
      "Herkimer, New York\n",
      "Hunter, New York\n",
      "Lexington, Missouri\n",
      "Monon, Indiana\n",
      "Altamont, Tennessee\n",
      "Malin, Oregon\n",
      "Markleville, Indiana\n",
      "Wellman, Texas\n",
      "Whittemore, Michigan\n",
      "Matthews, Indiana\n",
      "Elm Grove, Wisconsin\n",
      "Mount Vernon, Washington\n",
      "McGregor, Texas\n",
      "Jackson Heights, Queens\n",
      "Beaumont, California\n",
      "Hewitt, Wood County, Wisconsin\n",
      "Palestine, Ohio\n",
      "Forty Fort, Pennsylvania\n",
      "Wilmington, Greene County, Illinois\n",
      "Orange, Virginia\n",
      "Scranton, North Dakota\n",
      "Port Hueneme, California\n",
      "Ferdinand, Idaho\n",
      "Windsor, Wisconsin\n",
      "Pine Township, Crawford County, Pennsylvania\n",
      "Halifax County, North Carolina\n",
      "Barker, Broome County, New York\n",
      "Gamewell, North Carolina\n",
      "Braddyville, Iowa\n",
      "Shawnee Hills, Delaware County, Ohio\n",
      "Stark County, Ohio\n",
      "Wernersville, Pennsylvania\n",
      "Honey Brook, Pennsylvania\n",
      "Elgin, Oregon\n",
      "Shongaloo, Louisiana\n",
      "Lemont, Illinois\n",
      "Lawnside, New Jersey\n",
      "Junction, Utah\n",
      "Chatham, Illinois\n",
      "Elk Rapids, Michigan\n",
      "Cortland County, New York\n",
      "West Blocton, Alabama\n",
      "Junction, Illinois\n",
      "Richfield, Kansas\n",
      "Coal Valley, Illinois\n",
      "Greybull, Wyoming\n",
      "Polk City, Iowa\n",
      "Fredonia, North Dakota\n",
      "Koshkonong, Missouri\n",
      "Bushong, Kansas\n",
      "Castalia, North Carolina\n",
      "Shrewsbury, Missouri\n",
      "Herman, Minnesota\n",
      "Mechanicsburg, Ohio\n",
      "Dix, New York\n",
      "Fort Madison, Iowa\n",
      "Indian Creek Township, White County, Illinois\n",
      "Terry, Montana\n",
      "Talk:Daytona Beach, Florida\n",
      "Kidder, Missouri\n",
      "Norton, Kansas\n",
      "Oldtown, Idaho\n",
      "Slick, Oklahoma\n",
      "Schleicher County, Texas\n",
      "Basalt, Colorado\n",
      "Covington, Virginia\n",
      "Albion (village), New York\n",
      "Spencerville, Maryland\n",
      "Leesburg, Georgia\n",
      "Kirwin, Kansas\n",
      "Gustavus, Alaska\n",
      "Delano, California\n",
      "Batavia Town, Genessee County, New York\n",
      "Rentz, Georgia\n",
      "St. Mary Parish, Louisiana\n",
      "Picture Rocks, Pennsylvania\n",
      "Constantia (town), New York\n",
      "Howell, Michigan\n",
      "Mountain Grove, Missouri\n",
      "Carlton, Kansas\n",
      "Franklin, Nebraska\n",
      "Rush Township, Susquehanna County, Pennsylvania\n",
      "Caldwell, New Jersey\n",
      "Bairoil, Wyoming\n",
      "Tomah, Wisconsin\n",
      "Grundy County, Iowa\n",
      "Buckner, Illinois\n",
      "Honey Creek Township, Crawford County, Illinois\n",
      "Orient, Ohio\n",
      "Brocton, Illinois\n",
      "Asbury Township, Gallatin County, Illinois\n",
      "Halls, Tennessee\n",
      "New Hartford, Iowa\n",
      "Millersburg Township, Mercer County, Illinois\n",
      "Adair, Oklahoma\n",
      "McKittrick, Missouri\n",
      "Minnesota Lake, Minnesota\n",
      "Bennington, Oklahoma\n",
      "Cooperstown, Pennsylvania\n",
      "Washington Township, Schuylkill County, Pennsylvania\n",
      "Licking, Missouri\n",
      "DeWitt, New York\n",
      "Eustis, Nebraska\n",
      "Redmond, Washington\n",
      "McCleary, Washington\n",
      "Mitchell County, Georgia\n",
      "Honeyville, Utah\n",
      "West Salem, Illinois\n",
      "Colchester, Illinois\n",
      "Spring Bay Township, Woodford County, Illinois\n",
      "Leona, Texas\n",
      "Dunkirk (town), New York\n",
      "Renfrow, Oklahoma\n",
      "Scott, Ohio\n",
      "Nicollet County, Minnesota\n",
      "Pocahontas, Virginia\n",
      "Homer Township, Will County, Illinois\n",
      "La Moille, Illinois\n",
      "Galax, Virginia\n",
      "McEwen, Tennessee\n",
      "Collingdale, Pennsylvania\n",
      "Ozawkie, Kansas\n",
      "Munroe Falls, Ohio\n",
      "Team Health Holdings, Inc.\n",
      "Baltic, Ohio\n",
      "Weymouth Township, New Jersey\n",
      "Crestone, Colorado\n",
      "Morgan Township, Greene County, Pennsylvania\n",
      "Woodland Park, Colorado\n",
      "Lawrence County, Mississippi\n",
      "Jackson, California\n",
      "Atlanta, Missouri\n",
      "Homer, Alaska\n",
      "Fairchance, Pennsylvania\n",
      "Hassell, North Carolina\n",
      "Bayard, Nebraska\n",
      "Upper Hanover Township, Montgomery County, Pennsylvania\n",
      "Franklin County, Ohio\n",
      "Myerstown, Pennsylvania\n",
      "Cannon Beach, Oregon\n",
      "La Crosse, Washington\n",
      "Patterson, Georgia\n",
      "Copemish, Michigan\n",
      "Hart, Texas\n",
      "Oakley, Michigan\n",
      "Iroquois, Illinois\n",
      "East St. Louis, Illinois\n",
      "Regent, North Dakota\n",
      "Fondulac Township, Tazewell County, Illinois\n",
      "Marshall, Texas\n",
      "Bermuda Run, North Carolina\n",
      "Lakehurst, New Jersey\n",
      "Flint, Michigan\n",
      "Callensburg, Pennsylvania\n",
      "East Brewton, Alabama\n",
      "Rembrandt, Iowa\n",
      "Hughes Springs, Texas\n",
      "Hollandale, Mississippi\n",
      "Norton, Ohio\n",
      "North Port, Florida\n",
      "Hanover, Michigan\n",
      "South Blooming Grove, New York\n",
      "Kotzebue, Alaska\n",
      "Jasper, Tennessee\n",
      "Radium, Kansas\n",
      "North East, Maryland\n",
      "Wooster, Arkansas\n",
      "Prescott, Wisconsin\n",
      "Oak Grove, Jackson County, Missouri\n",
      "Marked Tree, Arkansas\n",
      "Shahada, Maharashtra\n",
      "Wildwood, Missouri\n",
      "Pearland, Texas\n",
      "Winona, Mississippi\n",
      "Bel-Nor, Missouri\n",
      "Strawn, Illinois\n",
      "Keweenaw County, Michigan\n",
      "Wellsville, Kansas\n",
      "McCormick County, South Carolina\n",
      "Bartlett, Tennessee\n",
      "Rice Lake, Wisconsin\n",
      "Clay Center, Ohio\n",
      "Gratis, Ohio\n",
      "Mockingbird Valley, Kentucky\n",
      "Sparta Township, Knox County, Illinois\n",
      "Fort Myers Beach, Florida\n",
      "White Oak, Pennsylvania\n",
      "New Lebanon, Pennsylvania\n",
      "Kent Township, Stephenson County, Illinois\n",
      "Annona, Texas\n",
      "Bensalem Township, Pennsylvania\n",
      "Petersburg, Virginia\n",
      "Pike County, Pennsylvania\n",
      "Morse Bluff, Nebraska\n",
      "Lauderhill, Florida\n",
      "Cedar Bluff, Virginia\n",
      "Hialeah Gardens, Florida\n",
      "Twin Falls, Idaho\n",
      "Liberty Township, New Jersey\n",
      "Mosinee, Wisconsin\n",
      "Fred's, Inc.\n",
      "Beaver City, Nebraska\n",
      "Gulfport, Illinois\n",
      "Midlothian, Illinois\n",
      "Franklin County, Mississippi\n",
      "Fayetteville, Georgia\n",
      "Columbia, Virginia\n",
      "Glen Rock, New Jersey\n",
      "Lone Oak, Texas\n",
      "Waterloo, New York (village)\n",
      "Cherryville, North Carolina\n",
      "Hudson, Ohio\n",
      "La Crosse, Indiana\n",
      "Southampton Township, Bedford County, Pennsylvania\n",
      "Wardner, Idaho\n",
      "Pecos County, Texas\n",
      "Grand Prairie Township, Jefferson County, Illinois\n",
      "Maple Plain, Minnesota\n",
      "Waterloo, Indiana\n",
      "River Grove, Illinois\n",
      "Lincoln, England\n",
      "Atoka, Tennessee\n",
      "Moose Lake, Minnesota\n",
      "Ransom County, North Dakota\n",
      "Independence, Minnesota\n",
      "Alton, Illinois\n",
      "Twin Groves, Arkansas\n",
      "Victor (village), New York\n",
      "Sentinel Butte, North Dakota\n",
      "South Fork, Pennsylvania\n",
      "Cleveland, New York\n",
      "Hollister, California\n",
      "Hillside, New Jersey\n",
      "Pulaski Township, Lawrence County, Pennsylvania\n",
      "Peabody, Kansas\n",
      "Wabash County, Indiana\n",
      "Shackelford County, Texas\n",
      "Farina, Illinois\n",
      "Richmond Township, Crawford County, Pennsylvania\n",
      "Huntington, New York\n",
      "Harrisburg, Missouri\n",
      "Ruston, Louisiana\n",
      "Sawyerville, Illinois\n",
      "Emerson, Iowa\n",
      "Williamson County, Texas\n",
      "Pottsville, Pennsylvania\n",
      "Bryan County, Oklahoma\n",
      "Roscoe, Illinois\n",
      "Lebanon County, Pennsylvania\n",
      "Lower Gwynedd Township, Montgomery County, Pennsylvania\n",
      "Westwood, Jefferson County, Kentucky\n",
      "Muscle Shoals, Alabama\n",
      "Holcomb, Missouri\n",
      "Sterlington, Louisiana\n",
      "Brighton Town, Franklin County, New York\n",
      "Villard, Minnesota\n",
      "Chewelah, Washington\n",
      "Frazer Township, Allegheny County, Pennsylvania\n",
      "Hideout, UT\n",
      "Arnoldsville, Georgia\n",
      "Madison Township, Clarion County, Pennsylvania\n",
      "Wadsworth, Ohio\n",
      "Kechi, Kansas\n",
      "Elkland Township, Sullivan County, Pennsylvania\n",
      "Stookey Township, St. Clair County, Illinois\n",
      "Bock, Minnesota\n",
      "Meador, West Virginia\n",
      "Peck, Idaho\n",
      "Davey, Nebraska\n",
      "Mason County, West Virginia\n",
      "Detroit, Oregon\n",
      "Wilsey, Kansas\n",
      "Goddard, Kansas\n",
      "Hope, New Mexico\n",
      "Noble County, Ohio\n",
      "East Ellijay, Georgia\n",
      "Plattsburgh (city), New York\n",
      "Norway, New York\n",
      "Gilbertown, Alabama\n",
      "Pantego, Texas\n",
      "Cross Plains, Tennessee\n",
      "Irwinton, Georgia\n",
      "Parker, South Dakota\n",
      "North Dansville, New York\n",
      "Millersport, Ohio\n",
      "Lead, South Dakota\n",
      "Lincoln County, Mississippi\n",
      "San Joaquin, California\n",
      "Pinesdale, Montana\n",
      "Lawrence Township, Tioga County, Pennsylvania\n",
      "McFarland, California\n",
      "Alakanuk, Alaska\n",
      "Richmond, Louisiana\n",
      "Lake Mary, Florida\n",
      "Iva, South Carolina\n",
      "Southampton Township, New Jersey\n",
      "Henning, Illinois\n",
      "Pitcairn, New York\n",
      "Live Oak, Texas\n",
      "Beebe, Arkansas\n",
      "Ponderay, Idaho\n",
      "Neoga, Illinois\n",
      "Stuart, Virginia\n",
      "Elmore County, Idaho\n",
      "Maury County, Tennessee\n",
      "Madison Heights, Michigan\n",
      "West Pymble, New South Wales\n",
      "Kalaeloa, Hawaii\n",
      "Susquehanna County, Pennsylvania\n",
      "Elmira Township, Stark County, Illinois\n",
      "Turon, Kansas\n",
      "Greenwood Township, Christian County, Illinois\n",
      "Cold Brook Township, Warren County, Illinois\n",
      "Schuyler County, Missouri\n",
      "Iola, Wisconsin\n",
      "Princeton, Kentucky\n",
      "St. Thomas Township, Franklin County, Pennsylvania\n",
      "Solvay, New York\n",
      "Frederick, South Dakota\n",
      "Vandalia, Missouri\n",
      "New Johnsonville, Tennessee\n",
      "Hardee County, Florida\n",
      "Garfield, Kansas\n",
      "Fall River, Kansas\n",
      "Jackson Township, Huntingdon County, Pennsylvania\n",
      "Center Township, Beaver County, Pennsylvania\n",
      "Citronelle, Alabama\n",
      "Winfield, Kansas\n",
      "Fredericksburg, Virginia\n",
      "Knowlton Township, New Jersey\n",
      "Martinton Township, Iroquois County, Illinois\n",
      "Wellman, Iowa\n",
      "Cutler, Illinois\n",
      "Olney Township, Richland County, Illinois\n",
      "Sumner, Washington\n",
      "Floyd County, Iowa\n",
      "Jonesville, North Carolina\n",
      "West Mead Township, Crawford County, Pennsylvania\n",
      "Wellsville, Utah\n",
      "Easthampton, Massachusetts\n",
      "Deer Lodge County, Montana\n",
      "Parryville, Pennsylvania\n",
      "Gap, Pennsylvania\n",
      "Ellsworth, Minnesota\n",
      "Geneva, Georgia\n",
      "Westernport, Maryland\n",
      "Waldron, Arkansas\n",
      "Williams, South Carolina\n",
      "Galt, California\n",
      "Ephrata, Pennsylvania\n",
      "Silerton, Tennessee\n",
      "Adams County, Pennsylvania\n",
      "West Lawn, Pennsylvania\n",
      "Elko, Nevada\n",
      "Norwood, New Jersey\n",
      "Malta, New York\n",
      "Beverly, Kansas\n",
      "Idanha, Oregon\n",
      "Scott Township, Allegheny County, Pennsylvania\n",
      "Arcade, New York\n",
      "Stark County, North Dakota\n",
      "Goshen, Kentucky\n",
      "Ellisville, Illinois\n",
      "Patton, Pennsylvania\n",
      "Northfield, New Jersey\n",
      "Deep River, Connecticut\n",
      "Lake Tekakwitha, Missouri\n",
      "Nash, Texas\n",
      "Lincoln County, Idaho\n",
      "Broken Arrow, Oklahoma\n",
      "El Mirage, Arizona\n",
      "Harrisburg, Pennsylvania\n",
      "Spring Hill, Indiana\n",
      "King City, Oregon\n",
      "St. Helena, North Carolina\n",
      "Plymouth, Minnesota\n",
      "Summerville, Georgia\n",
      "Van Wert, Iowa\n",
      "Clarksburg, Missouri\n",
      "Chester, Montana\n",
      "Lone Star, Texas\n",
      "Curtin Township, Centre County, Pennsylvania\n",
      "Bellewood, Kentucky\n",
      "Hunt County, Texas\n",
      "Romney, West Virginia\n",
      "Greenwood, Delaware\n",
      "Quinwood, West Virginia\n",
      "Toulon Township, Stark County, Illinois\n",
      "Franklin Township, Gloucester County, New Jersey\n",
      "Newark Valley, New York\n",
      "Seagraves, Texas\n",
      "Dayton, Virginia\n",
      "Shrewsbury Township, Sullivan County, Pennsylvania\n",
      "Lake Villa, Illinois\n",
      "Beulah, Mississippi\n",
      "Madill, Oklahoma\n",
      "The College at Brockport, State University of New York\n",
      "Penfield, New York\n",
      "Plains, Georgia\n",
      "Petrey, Alabama\n",
      "Loretto, Tennessee\n",
      "Morgan County, Illinois\n",
      "Galena, Kansas\n",
      "Wells, Nevada\n",
      "Silverhill, Alabama\n",
      "Dinosaur, Colorado\n",
      "Clearbrook, Minnesota\n",
      "Rush County, Kansas\n",
      "La Verne, California\n",
      "Ripley, Mississippi\n",
      "Lake Wilson, Minnesota\n",
      "Evesham Township, New Jersey\n",
      "McFarlan, North Carolina\n",
      "Columbiana, Ohio\n",
      "Alva, Oklahoma\n",
      "Benton Township, Lake County, Illinois\n",
      "Auburn, Iowa\n",
      "Hounsfield, New York\n",
      "Fishing Creek Township, Columbia County, Pennsylvania\n",
      "Lincolnville, South Carolina\n",
      "Artesia, New Mexico\n",
      "Pine Creek Township, Ogle County, Illinois\n",
      "Zeeland, North Dakota\n",
      "Theresa, Wisconsin\n",
      "Mead Township, Warren County, Pennsylvania\n",
      "Totowa, New Jersey\n",
      "Terry, Mississippi\n",
      "Clinton, Connecticut\n",
      "Nederland, Colorado\n",
      "Morgan County, Colorado\n",
      "Mount Carbon, Pennsylvania\n",
      "Nikolai, Alaska\n",
      "Orange County, California\n",
      "New Bloomfield, Pennsylvania\n",
      "Salisbury, Herkimer County, New York\n",
      "Springfield Township, Montgomery County, Pennsylvania\n",
      "Brookings, South Dakota\n",
      "Millport, New York\n",
      "Cave-In-Rock, Illinois\n",
      "Monroe, Utah\n",
      "East Lansdowne, Pennsylvania\n",
      "Horicon, New York\n",
      "Aurelia, Iowa\n",
      "Menallen Township, Adams County, Pennsylvania\n",
      "Grafton, New South Wales\n",
      "St. Paul, Missouri\n",
      "Fisher, Illinois\n",
      "Assaria, Kansas\n",
      "Belmont, West Virginia\n",
      "Gotebo, Oklahoma\n",
      "Buckhorn Township, Brown County, Illinois\n",
      "Upper Dublin Township, Montgomery County, Pennsylvania\n",
      "Ridgeland, Wisconsin\n",
      "Fayette County, Indiana\n",
      "Staunton city, Virginia\n",
      "Fairview, Utah\n",
      "Malheur County, Oregon\n",
      "Berrien County, Georgia\n",
      "Cromwell, Indiana\n",
      "Roland, Iowa\n",
      "Glen Ridge, Florida\n",
      "Clayton, Missouri\n"
     ]
    }
   ],
   "source": [
    "random.shuffle(maine_cities)\n",
    "all_pops = map(town_pops,maine_cities)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Sugar Hill, New Hampshire\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[(1970, 336), (1980, 397), (1990, 464), (2000, 563), (2010, 563)]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print maine_cities[1033]\n",
    "all_pops[1033]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "28596"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(all_pops)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Villa Grove, Illinois\n",
      "[(1910, 1828), (1920, 2493), (1930, 2001), (1940, 2072), (1950, 2026), (1960, 2308), (1970, 2605), (1980, 2707), (1990, 2734), (2000, 2553), (2010, 2537)]\n"
     ]
    }
   ],
   "source": [
    "n = random.randint(0,len(all_pops)-1)\n",
    "print maine_cities[n]\n",
    "print(all_pops[n])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 161,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "redirecting Davistown, Kentucky to Fairview, Kentucky\n",
      "redirecting Universal Forest Products, Inc. to Universal Forest Products\n",
      "redirecting Batavia Town, Genesee County, New York to Batavia (town), New York\n",
      "redirecting Dansville (town), Steuben County, New York to Dansville, Steuben County, New York\n",
      "redirecting Keurig Green Mountain, Inc. to Keurig Green Mountain\n",
      "redirecting Middletown Town, Delaware County, New York to Middletown, Delaware County, New York\n",
      "redirecting Pinkhams Grant, New Hampshire to Pinkham's Grant, New Hampshire\n",
      "redirecting Fulton (city), Oswego County, New York to Fulton, Oswego County, New York\n",
      "redirecting Clinton Town, Clinton County, New York to Clinton, Clinton County, New York\n",
      "redirecting Dickinson Town, Broome County, New York to Dickinson, Broome County, New York\n",
      "redirecting Itron, Inc. to Itron\n",
      "redirecting Hopewell city, Virginia to Hopewell, Virginia\n",
      "redirecting Northampton Town, Fulton County, New York to Northampton, Fulton County, New York\n",
      "redirecting City of Creede, Colorado to Creede, Colorado\n",
      "redirecting White Hall, WV to White Hall, West Virginia\n",
      "redirecting Charlottesville city, Virginia to Charlottesville, Virginia\n",
      "Charlottesville, Virginia\n",
      "redirecting Greenport Town, Columbia County, New York to Greenport, Columbia County, New York\n",
      "redirecting The Interpublic Group of Companies, Inc. to Interpublic Group of Companies\n",
      "redirecting Woodbury (town), Orange County, New York to Woodbury, Orange County, New York\n",
      "redirecting Henry Schein, Inc. to Henry Schein\n",
      "redirecting Mohawk Industries, Inc. to Mohawk Industries\n",
      "redirecting Clarksville Town, Allegany County, New York to Clarksville, Allegany County, New York\n",
      "redirecting Germantown Town, Columbia County, New York to Germantown (town), New York\n",
      "redirecting Ferrellgas Partners, L.P. to Ferrellgas\n",
      "redirecting Du Bois Township, Washington County, Illinois to DuBois Township, Washington County, Illinois\n",
      "redirecting Danville city, Virginia to Danville, Virginia\n",
      "redirecting El Paso de Robles (Paso Robles), California to #REDIRECT[[Paso Robles, California]]\n",
      "redirecting Olean Town, Cattaraugus County, New York to Olean (town), New York\n",
      "redirecting Ascena Retail Group, Inc. to Ascena Retail Group\n",
      "redirecting Central Academy (Des Moines, Iowa) to \n",
      "redirecting Tonawanda Town, Erie County, New York to Tonawanda (town), New York\n",
      "redirecting Aurora Town, Erie County, New York to Aurora, Erie County, New York\n",
      "redirecting Cato Town, Cayuga County, New York to Cato (town), New York\n",
      "redirecting Charmwood, MO to Charmwood, Missouri\n",
      "redirecting Barker Town, Broome County, New York to Barker, Broome County, New York\n",
      "redirecting Sears Hometown and Outlet Stores, Inc. to Sears Hometown and Outlet Stores\n",
      "redirecting Village of Grosse Pointe Shores, Michigan to Grosse Pointe Shores, Michigan\n",
      "redirecting Roosevelt Middle School (San Francisco, California) to #REDIRECT[[Richmond District, San Francisco]]\n",
      "redirecting Franklin Town, Delaware County, New York to Franklin, Delaware County, New York \n",
      "redirecting Morristown, New York to Morristown (town), New York\n",
      "redirecting Magellan Health, Inc. to Magellan Health\n",
      "redirecting Lewis Town, Essex County, New York to Lewis, Essex County, New York\n",
      "redirecting Dunkirk Town, Chautauqua County, New York to Dunkirk (town), New York\n",
      "redirecting Little Falls Town, Herkimer County, New York to Little Falls (town), New York\n",
      "redirecting Highland (town), Sullivan County, New York to Highland, Sullivan County, New York\n",
      "redirecting Richmond city, Virginia to Richmond, Virginia\n",
      "redirecting Stonefort Township, Saline County, Illinois to Stone Fort Township, Illinois\n",
      "redirecting Southbridge Town, Massachusetts to Southbridge, Massachusetts\n",
      "redirecting Baldwin Town, Chemung County, New York to Baldwin, Chemung County, New York\n",
      "redirecting Ak Chin CDP, Arizona to Ak Chin, Pima County, Arizona\n",
      "redirecting Fairfax city, Virginia to Fairfax, Virginia\n",
      "Fairfax, Virginia\n",
      "BAD COORDS: ['region:US-CT', 'format=dms', 'd'] for Enfield, Connecticut\n",
      "redirecting Sargents Purchase, New Hampshire to Sargent's Purchase, New Hampshire\n",
      "redirecting Wallkill (town), Orange County, New York to Wallkill, Orange County, New York\n",
      "BAD COORDS: ['36', '-87', 'region:US-TN', 'displ'] for Clarksville, Tennessee\n",
      "redirecting Tetra Tech, Inc. to Tetra Tech\n",
      "redirecting Franklin Town, Franklin County, New York to Franklin, Franklin County, New York\n",
      "redirecting Graybar Electric Company, Inc. to Graybar\n",
      "Error with Graybar Electric Company, Inc. at point 11630\n",
      "redirecting Palmer Town, Massachusetts to Palmer, Massachusetts\n",
      "redirecting Rochester (town), New York to Rochester, Ulster County, New York\n",
      "BAD COORDS: ['42', '50', '', 'N', '78', '5', '', 'W', 'region:U'] for Wyoming County, New York\n",
      "redirecting Middletown (city), Orange County, New York to Middletown, Orange County, New York\n",
      "redirecting Fredericksburg city, Virginia to Fredericksburg, Virginia\n",
      "redirecting Winfield Town, Herkimer County, New York to Winfield (town), New York\n",
      "redirecting Poland Town, Chautauqua County, New York to Poland, Chautauqua County, New York\n",
      "redirecting Ste. Marie township, Jasper County, Illinois to Sainte Marie Township, Jasper County, Illinois\n",
      "redirecting Pawling Town, Dutchess County, New York to Pawling (town), New York\n",
      "Pawling (town), New York\n",
      "redirecting The Men's Wearhouse, Inc. to Tailored Brands\n",
      "redirecting Fulton (town), New York to Fulton, Schoharie County, New York\n",
      "redirecting Macomb City Township, McDonough County, Illinois to Macomb Township, McDonough County, Illinois\n",
      "redirecting Salisbury Town, Herkimer County, New York to Salisbury, Herkimer County, New York\n",
      "redirecting Annaly Capital Management, Inc. to Annaly Capital Management\n",
      "redirecting Salamanca Town, Cattaraugus County, New York to Salamanca (town), New York\n",
      "redirecting Alvan, IL to Alvin, Illinois\n",
      "redirecting Clarkedale, AR to Clarkedale, Arkansas\n",
      "redirecting Galax city, Virginia to Galax, Virginia\n",
      "redirecting List of universities and colleges in Kota, Rajasthan to Kota, Rajasthan\n",
      "redirecting Cutts Grant, New Hampshire to Cutt's Grant, New Hampshire\n",
      "redirecting Lake Tekakwitha, MO to Lake Tekakwitha, Missouri {{Redir_from_US_postal_ab}}\n",
      "redirecting User:DemocraticLuntz/Charmwood, Missouri to Charmwood, Missouri\n",
      "redirecting Leap Wireless International, Inc. to Leap Wireless\n",
      "redirecting Allegiant (novel, Divergent series) to Allegiant (novel)\n",
      "Error with Tripoli, Iowa at point 14731\n",
      "redirecting Johnstown Town, Fulton County, New York to Johnstown (town), New York\n",
      "BAD COORDS: ['34.803', '-86.967}}.\\n* [[Ric'] for Limestone County, Alabama\n",
      "redirecting Greenville Town, Greene County, New York to Greenville (town), New York\n",
      "redirecting Fishkill Town, Dutchess County, New York to Fishkill (town), New York\n",
      "redirecting Ashland Town, Greene County, New York to Ashland, Greene County, New York\n",
      "redirecting Ashland Town, Chemung County, New York to Ashland, Chemung County, New York\n",
      "Ashland, Chemung County, New York\n",
      "redirecting O'Reilly Automotive, Inc. to O'Reilly Auto Parts\n",
      "redirecting Chesapeake city, Virginia to Chesapeake, Virginia\n",
      "redirecting Buckeye Partners, L.P. to Buckeye Partners\n",
      "redirecting Martins Location, New Hampshire to Martin's Location, New Hampshire\n",
      "BAD COORDS: ['region:US-OK', 'format=dms', 'd'] for Oaks, Oklahoma\n",
      "redirecting Trinity Industries, Inc. to Trinity Industries\n",
      "Trinity Industries\n",
      "redirecting Hadleys Purchase, New Hampshire to Hadley's Purchase, New Hampshire\n",
      "redirecting Lawrence (town), St. Lawrence County, New York to Lawrence, St. Lawrence County, New York\n",
      "redirecting Gainesville, New York to Gainesville (town), New York\n",
      "redirecting Werner Enterprises, Inc. to Werner Enterprises\n",
      "redirecting User:DemocraticLuntz/Greif, Inc. to Greif, Inc.\n",
      "Greif, Inc.\n",
      "redirecting Du Page Township, Will County, Illinois to DuPage Township, Will County, Illinois\n",
      "redirecting Wilson, New York to Wilson (town), New York\n",
      "redirecting United Natural Foods, Inc. to United Natural Foods\n",
      "redirecting Hub Group, Inc. to Hub Group \n",
      "redirecting Sugar Loaf Township, St. Clair County, Illinois to Sugarloaf Township, St. Clair County, Illinois\n",
      "Error with Groton, Massachusetts at point 17706\n",
      "redirecting HD Supply Holdings, Inc. to HD Supply\n",
      "redirecting Martinsville city, Virginia to Martinsville, Virginia\n",
      "redirecting Prairie Du Long Township, St. Clair County, Illinois to Prairie du Long Township, St. Clair County, Illinois\n",
      "redirecting Waverly Town, Franklin County, New York to Waverly, Franklin County, New York\n",
      "redirecting Fremont (town), Sullivan County, New York to Fremont, Sullivan County, New York\n",
      "redirecting Weymouth Town, Massachusetts to Weymouth, Massachusetts\n",
      "redirecting Dollar Tree, Inc. to Dollar Tree\n",
      "Error with Dollar Tree, Inc. at point 18733\n",
      "BAD COORDS: ['40.991681', '0', 'region:US_typ'] for Harrington Park, New Jersey\n",
      "BAD COORDS: ['37.53139', 'N', '88.36833', 'W}}) '] for Hardin County, Illinois\n",
      "redirecting Herkimer, New York to Herkimer (town), New York\n",
      "redirecting Dickinson Town, Franklin County, New York to Dickinson, Franklin County, New York\n",
      "redirecting Lewiston (village), Niagara County, New York to Lewiston (village), New York\n",
      "redirecting Richland, Spencer County, Indiana to Richland City, Indiana\n",
      "redirecting Plattsburgh Town, Clinton County, New York to Plattsburgh (town), New York\n",
      "redirecting Greenville (town), Orange County, New York to Greenville, Orange County, New York\n",
      "Greenville, Orange County, New York\n",
      "redirecting PriceSmart, Inc. to PriceSmart\n",
      "redirecting Activision Blizzard, Inc. to Activision Blizzard\n",
      "redirecting Batavia Town, Genessee County, New York to Batavia (town), New York\n",
      "redirecting Health Care REIT, Inc. to Welltower\n",
      "redirecting Greens Grant, New Hampshire to Green's Grant, New Hampshire\n",
      "redirecting Brookside, Texas to Brookside Village, Texas\n",
      "redirecting Bloomington City Township, McLean County, Illinois to Bloomington Township, McLean County, Illinois\n",
      "redirecting Glen (town), Montgomery County, New York to Glen, New York\n",
      "redirecting Wrangell City and Borough, AK to Wrangell, Alaska\n",
      "redirecting Colonial Heights city, Virginia to Colonial Heights, Virginia\n",
      "redirecting Fremont (town), Steuben County, New York, to Fremont, Steuben County, New York\n",
      "redirecting Lake of the Woods, VA to Lake of the Woods, Virginia\n",
      "redirecting Chester (town), Warren County, New York to Chester, Warren County, New York\n",
      "redirecting C. H. Robinson Worldwide, Inc. to C. H. Robinson\n",
      "redirecting New Shoreham, Rhode Island to Block Island#New Shoreham\n",
      "redirecting Womelsdorf, West Virginia to Womelsdorf (Coalton), West Virginia\n",
      "redirecting Team Health Holdings, Inc. to TeamHealth\n",
      "redirecting Stericycle, Inc. to Stericycle\n",
      "redirecting West Springfield Town, Massachusetts to West Springfield, Massachusetts\n",
      "redirecting Lewis Town, Lewis County, New York to Lewis, Lewis County, New York\n",
      "Lewis, Lewis County, New York\n",
      "redirecting Rhinebeck Town, Dutchess County, New York to Rhinebeck (town), New York\n",
      "redirecting Bristol city, Virginia to Bristol, Virginia\n",
      "redirecting Florida (town), Montgomery County, New York to Florida, Montgomery County, New York\n",
      "redirecting Norwich Town, Chenango County, New York to Norwich (town), New York\n",
      "redirecting Wentworth Location, New Hampshire to Wentworth's Location, New Hampshire\n",
      "redirecting Harrisonburg city, Virginia to Harrisonburg, Virginia\n",
      "redirecting Groupon, Inc. to Groupon\n",
      "redirecting Coyote Flats, TX to Coyote Flats, Texas\n",
      "BAD COORDS: ['region:US-OK_type:city', 'fo'] for Morrison, Oklahoma\n",
      "redirecting St. Rose Township, Clinton County, Illinois to Saint Rose Township, Clinton County, Illinois\n",
      "redirecting Fred's, Inc. to Fred's\n",
      "redirecting Wilson (village), Niagara County, New York to Wilson (village), New York\n",
      "redirecting Low and Burbanks Grant, New Hampshire to Low and Burbank's Grant, New Hampshire\n",
      "redirecting Hampton city, Virginia to Hampton, Virginia\n",
      "redirecting Walton, New York to Walton (town), New York\n",
      "redirecting Manassas Park city, Virginia to Manassas Park, Virginia\n",
      "redirecting Poughkeepsie Town, Dutchess County, New York to Poughkeepsie (town), New York\n",
      "redirecting Brighton Town, Franklin County, New York to Brighton, Franklin County, New York\n",
      "redirecting Hideout, UT to Hideout, Utah\n",
      "redirecting Linn Energy, LLC to Linn Energy\n",
      "redirecting Norton city, Virginia to Norton, Virginia\n",
      "redirecting Dresden (town), Washington County, New York to Dresden, Washington County, New York\n",
      "Error with Narrative of the Life of Frederick Douglass, an American Slave at point 25377\n",
      "BAD COORDS: ['format=dms', 'display=inline'] for Gray, Georgia\n",
      "redirecting Tupper Lake, New York to Tupper Lake (town), New York\n",
      "redirecting Otego, New York to Otego (town), New York\n",
      "redirecting Calumet Specialty Products Partners, L.P. to Calumet Specialty Products Partners\n",
      "redirecting Norfolk city, Virginia to Norfolk, Virginia\n",
      "redirecting Victory Town, Cayuga County, New York to Victory, Cayuga County, New York\n",
      "redirecting Greenfield Town, Massachusetts to Greenfield, Massachusetts\n",
      "redirecting Quanta Services, Inc. to Quanta Services\n",
      "redirecting Waterloo, New York to Waterloo, New York (town)\n",
      "Waterloo, New York (town)\n",
      "redirecting Coldbrook Township, Warren County, Illinois to Cold Brook Township, Warren County, Illinois\n",
      "Cold Brook Township, Warren County, Illinois\n",
      "redirecting Clinton Town, Dutchess County, New York to Clinton, Dutchess County, New York\n",
      "redirecting Sprouts Farmers Market, Inc. to Sprouts Farmers Market\n",
      "redirecting Elmira Town, Chemung County, New York to Elmira (town), New York\n",
      "BAD COORDS: ['41.866545', '-89.221923}}\\n', ' '] for Ashton, Illinois\n",
      "redirecting Binghamton Town, Broome County, New York to Binghamton (town), New York\n",
      "Error with Long Sutton, Hampshire at point 26799\n",
      "redirecting Winthrop Town, Massachusetts to Winthrop, Massachusetts\n",
      "redirecting Plains GP Holdings, L.P. to Plains All American Pipeline\n",
      "redirecting LifePoint Hospitals, Inc. to LifePoint Health\n",
      "redirecting Mohawk (town), Montgomery County, New York to Mohawk, Montgomery County, New York\n",
      "redirecting Franklin Town, Massachusetts to Franklin, Massachusetts\n",
      "redirecting Crawfords Purchase, New Hampshire to Crawford's Purchase, New Hampshire\n",
      "redirecting US Foods, Inc. to US Foods\n",
      "Error with The Heritage School, Newnan at point 27637\n",
      "redirecting Dixs Grant, New Hampshire to Dix's Grant, New Hampshire\n",
      "redirecting Steel Dynamics, Inc. to Steel Dynamics\n",
      "redirecting Fulton (town), Schoharie County, New York to Fulton, Schoharie County, New York\n",
      "redirecting VWR Funding, Inc. to VWR International\n",
      "redirecting Catskill, New York to Catskill (town), New York\n",
      "redirecting Winfield, Herkimer County, New York to Winfield (town), New York\n",
      "redirecting Falls Church city, Virginia to Falls Church, Virginia\n",
      "redirecting Patterson-UTI Energy, Inc. to Patterson-UTI\n",
      "redirecting Watertown Town, Jefferson County, New York to Watertown (town), New York\n",
      "redirecting Albion (town), Oswego County, New York to Albion, Oswego County, New York\n",
      "redirecting Williamsburg city, Virginia to Williamsburg, Virginia\n",
      "redirecting Onondaga (town), Onondaga County, New York to Onondaga, New York\n",
      "redirecting Staunton city, Virginia to Staunton, Virginia\n",
      "redirecting Chandlers Purchase, New Hampshire to Chandler's Purchase, New Hampshire\n",
      "redirecting Petersburg city, Virginia to Petersburg, Virginia\n"
     ]
    }
   ],
   "source": [
    "data = []\n",
    "\n",
    "def coords(city):\n",
    "    utf = city_shelf[city.encode(\"utf-8\")]\n",
    "\n",
    "    try:\n",
    "        start = utf.index(\"{{coord|\") + 8\n",
    "    except:\n",
    "        return utf\n",
    "    coords = utf[start:start+25].split(\"|\")\n",
    "    try:\n",
    "        if \".\" in coords[0] and \".\" in coords[1]:\n",
    "            lat = float(coords[0])\n",
    "            lon = float(coords[1])\n",
    "        elif len(coords)>=4 and coords[1] in \"NS\" and coords[3] in \"EW\":\n",
    "            lat = float(coords[0])\n",
    "            lon = float(coords[2])                                   \n",
    "        elif len(coords)==2:\n",
    "            lat,lon = map(float,coords)\n",
    "        elif coords[2]==\"N\":\n",
    "            lat = float(coords[0]) + float(coords[1])/60\n",
    "            lon = -1 * (float(coords[3]) + float(coords[4])/60)\n",
    "        else:\n",
    "            lat = float(coords[0]) + float(coords[1])/60 + float(coords[2])/60/60\n",
    "            lon = -1 * (float(coords[4]) + float(coords[5])/60 + float(coords[6])/60/60)\n",
    "    except:\n",
    "        print \"BAD COORDS: {} for {}\".format(coords,city)\n",
    "        return (None,None)\n",
    "    return (lat,lon)\n",
    "\n",
    "for i,city in enumerate(maine_cities):\n",
    "    if city in [\"Sanford (CDP), Maine\", \"The Andersons, Inc.\",\"Edmonton\"]:\n",
    "        continue\n",
    "    lookup = city_shelf[city.encode(\"utf-8\")]\n",
    "    if \"Infobox television\" in lookup:\n",
    "        continue\n",
    "    try:\n",
    "        pops = town_pops(city)\n",
    "    except TypeError:\n",
    "        if random.random() < .01:\n",
    "            print u\"Error with {} at point {}\".format(city,i)\n",
    "        continue\n",
    "    coordinates = coords(city)\n",
    "    if len(coordinates) > 2:\n",
    "        coordinates = (None,None)\n",
    "    for pop in pops:\n",
    "        data.append((city,coordinates[0],coordinates[1],pop[0],pop[1]))\n",
    "    \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Enfield, Connecticut\n",
      "['region:US-CT', 'format=dms', 'd']\n"
     ]
    },
    {
     "ename": "ValueError",
     "evalue": "could not convert string to float: region:US-CT",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m\u001b[0m",
      "\u001b[0;31mValueError\u001b[0mTraceback (most recent call last)",
      "\u001b[0;32m<ipython-input-158-182fc932b21a>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      1\u001b[0m \u001b[0;32mprint\u001b[0m \u001b[0mcity\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      2\u001b[0m \u001b[0mtown_pops\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcity\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 3\u001b[0;31m \u001b[0mcoords\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcity\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m<ipython-input-156-bc087fcc0b6f>\u001b[0m in \u001b[0;36mcoords\u001b[0;34m(city)\u001b[0m\n\u001b[1;32m     22\u001b[0m             \u001b[0mlon\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m-\u001b[0m\u001b[0;36m1\u001b[0m \u001b[0;34m*\u001b[0m \u001b[0;34m(\u001b[0m\u001b[0mfloat\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcoords\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m3\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0mfloat\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcoords\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m4\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m/\u001b[0m\u001b[0;36m60\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     23\u001b[0m         \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 24\u001b[0;31m             \u001b[0mlat\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mfloat\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcoords\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0mfloat\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcoords\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m/\u001b[0m\u001b[0;36m60\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0mfloat\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcoords\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m2\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m/\u001b[0m\u001b[0;36m60\u001b[0m\u001b[0;34m/\u001b[0m\u001b[0;36m60\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     25\u001b[0m             \u001b[0mlon\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m-\u001b[0m\u001b[0;36m1\u001b[0m \u001b[0;34m*\u001b[0m \u001b[0;34m(\u001b[0m\u001b[0mfloat\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcoords\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m4\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0mfloat\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcoords\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m5\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m/\u001b[0m\u001b[0;36m60\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0mfloat\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcoords\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m6\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m/\u001b[0m\u001b[0;36m60\u001b[0m\u001b[0;34m/\u001b[0m\u001b[0;36m60\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     26\u001b[0m     \u001b[0;32mexcept\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mValueError\u001b[0m: could not convert string to float: region:US-CT"
     ]
    }
   ],
   "source": [
    "print city\n",
    "town_pops(city)\n",
    "coords(city)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 162,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "del city_shelf[city.encode(\"utf-8\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 166,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "frame = pd.DataFrame(data,columns=[\"city\",\"lat\",\"lon\",\"year\",\"pop\"])\n",
    "frame.to_csv(\"/home/bschmidt/9943478/Maine.csv\",encoding=\"utf-8\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 185,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[(1820, 1422),\n",
       " (1830, 2222),\n",
       " (1840, 9102),\n",
       " (1850, 21019),\n",
       " (1860, 45619),\n",
       " (1870, 79577),\n",
       " (1880, 116340),\n",
       " (1890, 205876),\n",
       " (1900, 285704),\n",
       " (1910, 465766),\n",
       " (1920, 993678),\n",
       " (1930, 1568662),\n",
       " (1940, 1623452),\n",
       " (1950, 1849568),\n",
       " (1960, 1670144),\n",
       " (1970, 1514063),\n",
       " (1980, 1203368),\n",
       " (1990, 1027974),\n",
       " (2000, 951270),\n",
       " (2010, 713777)]"
      ]
     },
     "execution_count": 185,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "town_pops(\"Detroit\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 188,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[((1840, 1222), (1820, 1422)),\n",
       " ((1850, 3829), (1830, 2222)),\n",
       " ((1860, 13768), (1840, 9102)),\n",
       " ((1870, 31584), (1850, 21019)),\n",
       " ((1880, 50137), (1860, 45619)),\n",
       " ((1890, 81434), (1870, 79577)),\n",
       " ((1900, 131822), (1880, 116340)),\n",
       " ((1910, 168497), (1890, 205876)),\n",
       " ((1920, 243164), (1900, 285704)),\n",
       " ((1930, 290718), (1910, 465766)),\n",
       " ((1940, 282349), (1920, 993678)),\n",
       " ((1950, 303616), (1930, 1568662)),\n",
       " ((1960, 318003), (1940, 1623452)),\n",
       " ((1970, 383818), (1950, 1849568)),\n",
       " ((1980, 354635), (1960, 1670144)),\n",
       " ((1990, 332943), (1970, 1514063)),\n",
       " ((2000, 313619), (1980, 1203368)),\n",
       " ((2010, 287208), (1990, 1027974))]"
      ]
     },
     "execution_count": 188,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zip(town_pops(\"Toledo, Ohio\"),town_pops(\"Detroit\"))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "\n",
    "map(parse_bars,rows)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 198,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "easy_lookup = {}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 199,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "for (k,v) in zip(maine_cities,all_pops):\n",
    "    try:\n",
    "        z = dict(v)\n",
    "    except ValueError:\n",
    "        continue\n",
    "    lookup = []\n",
    "    for y in range(1790,2010,10):\n",
    "        try:\n",
    "            lookup.append(z[y])\n",
    "        except KeyError:\n",
    "            lookup.append(0)\n",
    "    easy_lookup[tuple(lookup)] = k"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 249,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "TN = pd.read_csv(\"wiki_census/TNPlaces.csv\")\n",
    "\n",
    "all_rows = []\n",
    "\n",
    "for row in TN.iterrows():\n",
    "    z = row[1].to_dict()\n",
    "    lookup = []\n",
    "    for y in range(1790,2010,10):\n",
    "        try:\n",
    "            lookup.append(z[str(y)])\n",
    "        except KeyError:\n",
    "            lookup.append(0)\n",
    "    try:\n",
    "        z[\"match\"] = easy_lookup[tuple(lookup)]\n",
    "    except KeyError:\n",
    "        z[\"match\"] = \"NOOOOOTHING\"\n",
    "    all_rows.append(z)\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 230,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "u'Adams, Tennessee'"
      ]
     },
     "execution_count": 230,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "easy_lookup[tuple(lookup)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 250,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>1790</th>\n",
       "      <th>1800</th>\n",
       "      <th>1810</th>\n",
       "      <th>1820</th>\n",
       "      <th>1830</th>\n",
       "      <th>1840</th>\n",
       "      <th>1850</th>\n",
       "      <th>1860</th>\n",
       "      <th>1870</th>\n",
       "      <th>1880</th>\n",
       "      <th>...</th>\n",
       "      <th>1970</th>\n",
       "      <th>1980</th>\n",
       "      <th>1990</th>\n",
       "      <th>2000</th>\n",
       "      <th>2010</th>\n",
       "      <th>2014</th>\n",
       "      <th>County</th>\n",
       "      <th>Place</th>\n",
       "      <th>State</th>\n",
       "      <th>match</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>563</td>\n",
       "      <td>418</td>\n",
       "      <td>362</td>\n",
       "      <td>511</td>\n",
       "      <td>354</td>\n",
       "      <td>333</td>\n",
       "      <td>Polk County</td>\n",
       "      <td>Copperhill</td>\n",
       "      <td>Tennessee</td>\n",
       "      <td>NOOOOOTHING</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5566</td>\n",
       "      <td>6929</td>\n",
       "      <td>10165</td>\n",
       "      <td>16988</td>\n",
       "      <td>25865</td>\n",
       "      <td>43350</td>\n",
       "      <td>...</td>\n",
       "      <td>426029</td>\n",
       "      <td>455651</td>\n",
       "      <td>488374</td>\n",
       "      <td>545524</td>\n",
       "      <td>601222</td>\n",
       "      <td>644014</td>\n",
       "      <td>Davidson County</td>\n",
       "      <td>Nashville-Davidson metropolitan government (ba...</td>\n",
       "      <td>Tennessee</td>\n",
       "      <td>NOOOOOTHING</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>145</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3099</td>\n",
       "      <td>5861</td>\n",
       "      <td>6423</td>\n",
       "      <td>Williamson County</td>\n",
       "      <td>Nolensville</td>\n",
       "      <td>Tennessee</td>\n",
       "      <td>NOOOOOTHING</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>331</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>236</td>\n",
       "      <td>...</td>\n",
       "      <td>1983</td>\n",
       "      <td>2109</td>\n",
       "      <td>1824</td>\n",
       "      <td>2228</td>\n",
       "      <td>2449</td>\n",
       "      <td>2420</td>\n",
       "      <td>Wayne County</td>\n",
       "      <td>Waynesboro</td>\n",
       "      <td>Tennessee</td>\n",
       "      <td>NOOOOOTHING</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     1790  1800  1810  1820  1830  1840   1850   1860   1870   1880  \\\n",
       "67      0     0     0     0     0     0      0      0      0      0   \n",
       "220     0     0     0     0  5566  6929  10165  16988  25865  43350   \n",
       "228     0     0     0     0     0     0      0      0      0    145   \n",
       "331     0     0     0     0     0     0      0      0      0    236   \n",
       "\n",
       "        ...         1970    1980    1990    2000    2010    2014  \\\n",
       "67      ...          563     418     362     511     354     333   \n",
       "220     ...       426029  455651  488374  545524  601222  644014   \n",
       "228     ...            0       0       0    3099    5861    6423   \n",
       "331     ...         1983    2109    1824    2228    2449    2420   \n",
       "\n",
       "                County                                              Place  \\\n",
       "67         Polk County                                         Copperhill   \n",
       "220    Davidson County  Nashville-Davidson metropolitan government (ba...   \n",
       "228  Williamson County                                        Nolensville   \n",
       "331       Wayne County                                         Waynesboro   \n",
       "\n",
       "         State        match  \n",
       "67   Tennessee  NOOOOOTHING  \n",
       "220  Tennessee  NOOOOOTHING  \n",
       "228  Tennessee  NOOOOOTHING  \n",
       "331  Tennessee  NOOOOOTHING  \n",
       "\n",
       "[4 rows x 28 columns]"
      ]
     },
     "execution_count": 250,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(all_rows)[pd.DataFrame(all_rows).match ==\"NOOOOOTHING\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 242,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{{Infobox settlement\n",
      "|official_name            = Waynesboro, Tennessee\n",
      "|settlement_type          = [[City]]\n",
      "|nickname                 =\n",
      "|motto                    =''Progressing toward our future, through an understanding of our past''<ref name=official>[http://www.cityofwaynesboro.org/ Waynesboro official website].  Retrieved: 1 March 2013.</ref>\n",
      "\n",
      "<!-- Images -->\n",
      "|image_skyline            = Wayne-County-Courthouse-SE-tn2.jpg\n",
      "|imagesize                = 250px\n",
      "|image_caption            = Wayne County Courthouse\n",
      "|image_flag               =\n",
      "|image_seal               =\n",
      "\n",
      "<!-- Maps -->\n",
      "|image_map                = TNMap-doton-Waynesboro.PNG\n",
      "|mapsize                  = 250px\n",
      "|map_caption              = Location of Waynesboro, Tennessee\n",
      "|image_map1               =\n",
      "|mapsize1                 =\n",
      "|map_caption1             =\n",
      "\n",
      "<!-- Location -->\n",
      "|subdivision_type         = [[List of countries|Country]]\n",
      "|subdivision_name         = [[United States]]\n",
      "|subdivision_type1        = [[Political divisions of the United States|State]]\n",
      "|subdivision_name1        = [[Tennessee]]\n",
      "|subdivision_type2        = [[List of counties in Tennessee|County]]\n",
      "|subdivision_name2        = [[Wayne County, Tennessee|Wayne]]\n",
      "\n",
      "<!-- Government -->\n",
      "|government_footnotes     =\n",
      "|government_type          =\n",
      "|leader_title             =\n",
      "|leader_name              =\n",
      "|leader_title1            =\n",
      "|leader_name1             =\n",
      "|established_title        =Established\n",
      "|established_date         =1821<ref name=tehc>Bob Rains, \"[http://tennesseeencyclopedia.net/entry.php?rec=1478 Wayne County],\" ''Tennessee Encyclopedia of History and Culture''.  Retrieved: 1 March 2013.</ref>\n",
      "|established_title2       =Incorporated\n",
      "|established_date2        =1850<ref name=bluebook>''[http://www.state.tn.us/sos/bluebook/05-06/48-data.pdf Tennessee Blue Book]'', 2005-2006, pp. 618-625.</ref>\n",
      "|named_for                = General [[Anthony Wayne]]<ref>Nancy Capace, ''[https://books.google.com/books?id=v8KkJq1ZRwYC&dq=gordonsville,+tennessee+named+for&source=gbs_navlinks_s Encyclopedia of Tennessee]'' (North American Book Distributors, 2000), p. 229.</ref>\n",
      "\n",
      "<!-- Area -->\n",
      "|unit_pref                = Imperial\n",
      "|area_footnotes           =\n",
      "|area_magnitude           =\n",
      "|area_total_km2           = 6.4\n",
      "|area_land_km2            = 6.4\n",
      "|area_water_km2           = 0.0\n",
      "|area_total_sq_mi         = 2.5\n",
      "|area_land_sq_mi          = 2.5\n",
      "|area_water_sq_mi         = 0.0\n",
      "\n",
      "<!-- Population -->\n",
      "|population_as_of         = [[United States Census, 2000|2000]]\n",
      "|population_footnotes     =\n",
      "|population_total         = 2449\n",
      "|population_density_km2   = 349.1\n",
      "|population_density_sq_mi = 904.2\n",
      "\n",
      "<!-- General information -->\n",
      "|timezone                 = [[North American Central Time Zone|Central (CST)]]\n",
      "|utc_offset               = -6\n",
      "|timezone_DST             = CDT\n",
      "|utc_offset_DST           = -5\n",
      "|elevation_footnotes      =\n",
      "|elevation_m              = 228\n",
      "|elevation_ft             = 748\n",
      "|coordinates              = {{coord|35|19|14|N|87|45|25|W|region:US_type:city|display=inline,title}}\n",
      "|postal_code_type         = [[ZIP code]]\n",
      "|postal_code              = 38485\n",
      "|area_code                = [[Area code 931|931]]\n",
      "|blank_name               = [[Federal Information Processing Standard|FIPS code]]\n",
      "|blank_info               = 47-78600<ref name=\"GR2\">{{cite web|url=http://factfinder2.census.gov|publisher=[[United States Census Bureau]]|accessdate=2008-01-31|title=American FactFinder}}</ref>\n",
      "|blank1_name              = [[Geographic Names Information System|GNIS]] feature ID\n",
      "|blank1_info              = 1326575<ref name=\"GR3\">{{cite web|url=http://geonames.usgs.gov|accessdate=2008-01-31|title=US Board on Geographic Names|publisher=[[United States Geological Survey]]|date=2007-10-25}}</ref>\n",
      "|website                  = {{url|http://www.cityofwaynesboro.org}}\n",
      "|footnotes                =\n",
      "}}\n",
      "'''Waynesboro''' is a city in and the [[county seat]] of [[Wayne County, Tennessee|Wayne County]], [[Tennessee]], [[United States]].<ref name=\"GR6\">{{cite web|url=http://www.naco.org/Counties/Pages/FindACounty.aspx|accessdate=2011-06-07|title=Find a County|publisher=National Association of Counties}}</ref> The population was 2,449 at the 2010 census, up from 2,228 in 2000.<ref>[http://2010.census.gov/2010census/popmap/ipmtext.php 2010 U.S. Census], U.S. Census Bureau. Accessed 9 November 2016.</ref>\n",
      "\n",
      "==History==\n",
      "\n",
      "Waynesboro was founded in 1821 as a county seat for the newly created Wayne County.  The city initially consisted of a {{convert|40|acre|ha|sing=on}} plot that included the courthouse and jail.  A school, Ashland Academy, was established in 1843.<ref>Austin Foster and Mel Foster, ''[https://books.google.com/books?id=0vQ9Ml-6C6oC&dq= Counties of Tennessee]'' (Genealogical Publishing Company, 2009), p. 92.</ref> The city incorporated in 1850.<ref name=bluebook />\n",
      "\n",
      "==Geography==\n",
      "Waynesboro is located at {{coord|35|19|14|N|87|45|25|W|type:city}} (35.320546, -87.756984).<ref name=\"GR1\">{{cite web|url=http://www.census.gov/geo/www/gazetteer/gazette.html|publisher=[[United States Census Bureau]]|accessdate=2011-04-23|date=2011-02-12|title=US Gazetteer files: 2010, 2000, and 1990}}</ref>  The city is concentrated around the junction of [[Tennessee State Route 13|State Route 13]] and [[U.S. Route 64]], {{convert|105|mi|km}} south of [[Nashville, Tennessee|Nashville]], and {{convert|135|mi|km}} east [[Memphis, Tennessee|Memphis]].  [[Tennessee State Route 99|State Route 99]], which intersects US 64 in eastern Waynesboro, connects the city with [[Hohenwald, Tennessee|Hohenwald]] to the northeast.  The [[Natchez Trace Parkway]] intersects US 64 a few miles east of Waynesboro.\n",
      "\n",
      "Waynesboro lies along the banks of the [[Green River (Tennessee)|Green River]], which slices a narrow valley oriented north-to-south en route to its mouth along the [[Buffalo River (Tennessee)|Buffalo River]] to the north.  Hurricane Creek, which approaches from the southeast, empties into the Green River just north of the city.  Much of the forest northwest of Waynesboro is part of the Eagle Creek Wildlife Management Area.\n",
      "\n",
      "According to the [[United States Census Bureau]], the city has a total area of {{convert|2.5|sqmi|km2}}, all of it land.\n",
      "\n",
      "==Demographics==\n",
      "{{US Census population\n",
      "|1880= 236\n",
      "|1890= 239\n",
      "|1910= 357\n",
      "|1940= 768\n",
      "|1950= 1147\n",
      "|1960= 1343\n",
      "|1970= 1983\n",
      "|1980= 2109\n",
      "|1990= 1824\n",
      "|2000= 2228\n",
      "|2010= 2449\n",
      "|estyear=2016\n",
      "|estimate=2357\n",
      "|estref=<ref name=\"USCensusEst2016\">{{cite web|url=https://www.census.gov/programs-surveys/popest/data/tables.2016.html|title=Population and Housing Unit Estimates|accessdate=June 9, 2017}}</ref>\n",
      "|footnote=Sources:<ref name=\"GR9\">{{cite web|url=http://www.census.gov/prod/www/abs/decennial/|publisher=[[United States Census Bureau]]|accessdate=2012-03-04|title=Census of Population and Housing: Decennial Censuses}}</ref><ref name=CensusPopEst>{{cite web|title=Incorporated Places and Minor Civil Divisions Datasets: Subcounty Resident Population Estimates: April 1, 2010 to July 1, 2012|url=http://www.census.gov/popest/data/cities/totals/2012/SUB-EST2012.html|work=Population Estimates|publisher=U.S. Census Bureau|accessdate=11 December 2013}}</ref>\n",
      "}}\n",
      "As of the [[census]]<ref name=\"GR2\" /> of 2000, there were 2,228 people, 954 households, and 601 families residing in the city. The [[population density]] was 904.2 people per square mile (349.7/km²). There were 1,071 housing units at an average density of 434.7 per square mile (168.1/km²). The racial makeup of the city was 97.04% [[White (U.S. Census)|White]], 1.39% [[African American (U.S. Census)|African American]], 0.22% [[Native American (U.S. Census)|Native American]], 0.45% [[Asian (U.S. Census)|Asian]], 0.09% [[Pacific Islander (U.S. Census)|Pacific Islander]], 0.22% from [[Race (United States Census)|other races]], and 0.58% from two or more races. [[Hispanic (U.S. Census)|Hispanic]] or [[Latino (U.S. Census)|Latino]] of any race were 1.03% of the population.\n",
      "\n",
      "[[File:Waynesboro-courthouse-square-tn1.jpg|left|210px|thumb|Buildings along the courthouse square]]\n",
      "\n",
      "There were 954 households out of which 27.7% had children under the age of 18 living with them, 47.1% were [[Marriage|married couples]] living together, 13.1% had a female householder with no husband present, and 37.0% were non-families. 35.1% of all households were made up of individuals and 18.3% had someone living alone who was 65 years of age or older. The average household size was 2.21 and the average family size was 2.84.\n",
      "\n",
      "In the city, the population was spread out with 23.1% under the age of 18, 7.7% from 18 to 24, 25.9% from 25 to 44, 23.4% from 45 to 64, and 19.9% who were 65 years of age or older. The median age was 40 years. For every 100 females there were 87.1 males. For every 100 females age 18 and over, there were 79.6 males.\n",
      "\n",
      "The median income for a household in the city was $25,196, and the median income for a family was $33,917. Males had a median income of $27,263 versus $17,379 for females. The [[per capita income]] for the city was $15,037. About 14.0% of families and 16.3% of the population were below the [[poverty line]], including 16.9% of those under age 18 and 15.2% of those age 65 or over.\n",
      "\n",
      "==Notable people==\n",
      "* [[Clay Allison]], [[Old West]] gun fighter\n",
      "* [[Mark Collie]], [[country music]] singer\n",
      "* Jimmy Smith, [[American Idol (season 12)|American Idol]] Semifinalist (Season 12)\n",
      "* Mary Beth Wylie, Film and television, American Ghost Hunter, The Ghost Prophecies, A Blood Red Sky, Paranormal State\n",
      "\n",
      "==Manufacturing==\n",
      "* Hometex\n",
      "* Tennessee Container Services\n",
      "* Lincoln Brass\n",
      "\n",
      "==Radio stations==\n",
      "* [[WWON (AM)|WWON]] Big Oldies 930\n",
      "* [[W210BE]] 89.9 [[American Family Radio]]\n",
      "*[[WWON-FM]] 100.7.<ref>[http://transition.fcc.gov/fcc-bin/fmq?list=0&facid=171033 Radio and TV Search], FCC website. Accessed 9 November 2016.</ref>\n",
      "\n",
      "==Education==\n",
      "* Waynesboro Elementary School\n",
      "* Waynesboro Middle School\n",
      "* [[Wayne County High School (Tennessee)|Wayne County High School]]\n",
      "* Wayne County Technology Center\n",
      "*Hollis Academy\n",
      "\n",
      "==Highways==\n",
      "* {{jct|state=TN|US|64|TN|15}}\n",
      "* {{jct|state=TN|TN|13}}\n",
      "* {{jct|state=TN|TN|99}}\n",
      "\n",
      "==References==\n",
      "{{reflist}}\n",
      "\n",
      "==External links==\n",
      "{{Commons category|Waynesboro, Tennessee}}\n",
      "* {{official|http://www.cityofwaynesboro.org}}\n",
      "* [http://www.mtas.tennessee.edu/gml-mtas.nsf/Webstatecityinfo/9F3A6DC41406E38285256AF7005EDB36?OpenDocument Municipal Technical Advisory Service entry for Waynesboro] — information on local government, elections, and link to charter\n",
      "* [http://www.tdot.state.tn.us/Maps/city/Waynesboro.PDF/  Map of Waynesboro]\n",
      "\n",
      "{{Wayne County, Tennessee}}\n",
      "\n",
      "[[Category:Cities in Tennessee]]\n",
      "[[Category:Cities in Wayne County, Tennessee]]\n",
      "[[Category:County seats in Tennessee]]\n"
     ]
    }
   ],
   "source": [
    "print city_shelf[\"Waynesboro, Tennessee\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 246,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/usr/local/lib/python2.7/dist-packages/ipykernel/__main__.py:1: FutureWarning: irow(i) is deprecated. Please use .iloc[i]\n",
      "  if __name__ == '__main__':\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "1790                 0\n",
       "1800                 0\n",
       "1810                 0\n",
       "1820                 0\n",
       "1830                 0\n",
       "1840                 0\n",
       "1850                 0\n",
       "1860                 0\n",
       "1870                 0\n",
       "1880               236\n",
       "1890               239\n",
       "1900                 0\n",
       "1910                 0\n",
       "1920                 0\n",
       "1930                 0\n",
       "1940               768\n",
       "1950              1147\n",
       "1960              1343\n",
       "1970              1983\n",
       "1980              2109\n",
       "1990              1824\n",
       "2000              2228\n",
       "2010              2449\n",
       "2014              2420\n",
       "County    Wayne County\n",
       "Place       Waynesboro\n",
       "State        Tennessee\n",
       "match             None\n",
       "Name: 331, dtype: object"
      ]
     },
     "execution_count": 246,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(all_rows).irow(331)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}