wmcrowds.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Collecting geocoder\n",
      "  Downloading geocoder-1.20.0-py2.py3-none-any.whl (69kB)\n",
      "\u001b[K    100% |████████████████████████████████| 71kB 5.9MB/s eta 0:00:01\n",
      "\u001b[?25hCollecting click (from geocoder)\n",
      "  Downloading click-6.7-py2.py3-none-any.whl (71kB)\n",
      "\u001b[K    100% |████████████████████████████████| 71kB 6.5MB/s eta 0:00:01\n",
      "\u001b[?25hCollecting ratelim (from geocoder)\n",
      "  Downloading ratelim-0.1.6-py2.py3-none-any.whl\n",
      "Requirement already satisfied (use --upgrade to upgrade): requests in /opt/conda/lib/python3.5/site-packages (from geocoder)\n",
      "Requirement already satisfied (use --upgrade to upgrade): six in /opt/conda/lib/python3.5/site-packages (from geocoder)\n",
      "Requirement already satisfied (use --upgrade to upgrade): decorator in /opt/conda/lib/python3.5/site-packages (from ratelim->geocoder)\n",
      "Installing collected packages: click, ratelim, geocoder\n",
      "Successfully installed click-6.7 geocoder-1.20.0 ratelim-0.1.6\n",
      "\u001b[33mYou are using pip version 8.1.2, however version 9.0.1 is available.\n",
      "You should consider upgrading via the 'pip install --upgrade pip' command.\u001b[0m\n"
     ]
    }
   ],
   "source": [
    "# need this!\n",
    "!pip install geocoder"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import geocoder"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# to download a google sheet as a csv \n",
    "# https://docs.google.com/spreadsheets/d/LONG_ID_STRING/export?format=csv&id=LONG_ID_STRING\n",
    "# https://docs.google.com/spreadsheets/d/1xa0iLqYKz8x9Yc_rfhtmSOJQ2EGgeUVjvV4A8LsIaxY/export?format=csv&id=1xa0iLqYKz8x9Yc_rfhtmSOJQ2EGgeUVjvV4A8LsIaxY"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 940 entries, 0 to 939\n",
      "Data columns (total 22 columns):\n",
      "place            939 non-null object\n",
      "state            669 non-null object\n",
      "country          934 non-null object\n",
      "estimate_low     866 non-null float64\n",
      "estimate_high    864 non-null float64\n",
      "est3             5 non-null float64\n",
      "not121           21 non-null float64\n",
      "source           891 non-null object\n",
      "source2          356 non-null object\n",
      "source3          74 non-null object\n",
      "a                937 non-null float64\n",
      "b                78 non-null object\n",
      "c                140 non-null object\n",
      "d                139 non-null float64\n",
      "e                87 non-null float64\n",
      "f                87 non-null float64\n",
      "g                257 non-null float64\n",
      "h                257 non-null float64\n",
      "i                31 non-null float64\n",
      "j                31 non-null float64\n",
      "k                275 non-null float64\n",
      "l                275 non-null float64\n",
      "dtypes: float64(14), object(8)\n",
      "memory usage: 161.6+ KB\n"
     ]
    }
   ],
   "source": [
    "# df = pd.read_csv(\"Crowd Estimates, 1.21.2017 - By City.csv\", skiprows=9,  header=None, thousands=\",\")\n",
    "df = pd.read_csv(\"Crowd Estimates, 1.21.2017 - Sheet1.csv\", skiprows=9,  header=None, thousands=\",\")\n",
    "col_names = [\"place\", \"state\", \"country\", \"estimate_low\", \"estimate_high\", \"est3\", \"not121\", \"source\", \"source2\", \"source3\", \"a\", \"b\", \"c\",\"d\",\"e\", \"f\", \"g\", \"h\", \"i\", \"j\", \"k\", \"l\"]\n",
    "df.columns = col_names\n",
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 256,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>place</th>\n",
       "      <th>state</th>\n",
       "      <th>country</th>\n",
       "      <th>estimate_low</th>\n",
       "      <th>estimate_high</th>\n",
       "      <th>est3</th>\n",
       "      <th>not121</th>\n",
       "      <th>source</th>\n",
       "      <th>source2</th>\n",
       "      <th>source3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Abilene, TX</td>\n",
       "      <td>TX</td>\n",
       "      <td>US</td>\n",
       "      <td>200.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.reporternews.com/story/news/local/2...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Accident, MD</td>\n",
       "      <td>MD</td>\n",
       "      <td>US</td>\n",
       "      <td>54.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Twitter; on-site witness</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Adak, AK</td>\n",
       "      <td>AK</td>\n",
       "      <td>US</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>adn.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Adrian, MI</td>\n",
       "      <td>MI</td>\n",
       "      <td>US</td>\n",
       "      <td>130.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.facebook.com/events/847360115406578/</td>\n",
       "      <td>http://www.lenconnect.com/news/20170122/marche...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ajo, AZ</td>\n",
       "      <td>AZ</td>\n",
       "      <td>US</td>\n",
       "      <td>250.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.facebook.com/plugins/post.php?href...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Alameda, CA</td>\n",
       "      <td>CA</td>\n",
       "      <td>US</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Alamosa, CO</td>\n",
       "      <td>CO</td>\n",
       "      <td>US</td>\n",
       "      <td>350.0</td>\n",
       "      <td>350.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://twitter.com/zepol/status/8232349739352...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Albany, CA</td>\n",
       "      <td>CA</td>\n",
       "      <td>US</td>\n",
       "      <td>500.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://twitter.com/ben_silverman/status/82303...</td>\n",
       "      <td>Albany PD (reported via google form)</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Albany, NY</td>\n",
       "      <td>NY</td>\n",
       "      <td>US</td>\n",
       "      <td>7000.0</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.timesunion.com/local/article/Albany...</td>\n",
       "      <td>FB</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Alexandria, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>US</td>\n",
       "      <td>17.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://twitter.com/TinaPStacy/status/82322604...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Albuquerque, NM</td>\n",
       "      <td>NM</td>\n",
       "      <td>US</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>20000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.koat.com/article/thousands-fill-civ...</td>\n",
       "      <td>https://twitter.com/PatDavisNM/status/82293149...</td>\n",
       "      <td>https://twitter.com/AthertonKD/status/82321516...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Almanor West, CA</td>\n",
       "      <td>CA</td>\n",
       "      <td>US</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>eyewitness; picture</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Alpine, TX</td>\n",
       "      <td>TX</td>\n",
       "      <td>US</td>\n",
       "      <td>96.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://twitter.com/sarahmvasquez/status/82318...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Amarillo, TX</td>\n",
       "      <td>TX</td>\n",
       "      <td>US</td>\n",
       "      <td>600.0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.texastribune.org/2017/01/21/thousa...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Amelia Island, FL</td>\n",
       "      <td>FL</td>\n",
       "      <td>US</td>\n",
       "      <td>700.0</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.firstcoastnews.com/news/womens-marc...</td>\n",
       "      <td>https://twitter.com/wideofthepost/status/82307...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Anacortes, WA</td>\n",
       "      <td>WA</td>\n",
       "      <td>US</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>200.0</td>\n",
       "      <td>http://www.goskagit.com/skagit/hundreds-partic...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Anchorage, AK</td>\n",
       "      <td>AK</td>\n",
       "      <td>US</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.adn.com/alaska-news/2017/01/21/lar...</td>\n",
       "      <td>https://twitter.com/julia_omalley/status/82290...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Ann Arbor, MI</td>\n",
       "      <td>MI</td>\n",
       "      <td>US</td>\n",
       "      <td>11000.0</td>\n",
       "      <td>11000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.mlive.com/news/ann-arbor/index.ssf/...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Annapolis, MD</td>\n",
       "      <td>MD</td>\n",
       "      <td>US</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.capitalgazette.com/news/annapolis/p...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Arlington, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>US</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Asbury Park, NJ</td>\n",
       "      <td>NJ</td>\n",
       "      <td>US</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://twitter.com/JuliaJHobbs/status/8229551...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Asheville, NC</td>\n",
       "      <td>NC</td>\n",
       "      <td>US</td>\n",
       "      <td>7000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://wlos.com/news/local/photo-gallery-the-w...</td>\n",
       "      <td>http://wlos.com/news/local/photo-gallery-the-w...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Ashland, OR</td>\n",
       "      <td>OR</td>\n",
       "      <td>US</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.mailtribune.com/news/20170121/voice...</td>\n",
       "      <td>http://ijpr.org/post/southern-oregon-womens-ma...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Aspen, CO</td>\n",
       "      <td>CO</td>\n",
       "      <td>US</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://twitter.com/SarahGoTrillIum/status/823...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Astoria, OR</td>\n",
       "      <td>OR</td>\n",
       "      <td>US</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.dailyastorian.com/Local_News/201701...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Athens, GA</td>\n",
       "      <td>GA</td>\n",
       "      <td>US</td>\n",
       "      <td>700.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://onlineathens.com/slideshow/2017-01-21/p...</td>\n",
       "      <td>FB</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Atlanta, GA</td>\n",
       "      <td>GA</td>\n",
       "      <td>US</td>\n",
       "      <td>60000.0</td>\n",
       "      <td>63000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.ajc.com/news/state--regional-govt--...</td>\n",
       "      <td>http://www.nbcnews.com/storyline/inauguration-...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Augusta, GA</td>\n",
       "      <td>GA</td>\n",
       "      <td>US</td>\n",
       "      <td>600.0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://chronicle.augusta.com/news/2017-01-21/h...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Augusta, ME</td>\n",
       "      <td>ME</td>\n",
       "      <td>US</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.pressherald.com/2017/01/21/thousand...</td>\n",
       "      <td>http://bangordailynews.com/2017/01/21/news/sta...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Austin, TX</td>\n",
       "      <td>TX</td>\n",
       "      <td>US</td>\n",
       "      <td>30000.0</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://kut.org/post/tens-thousands-participate...</td>\n",
       "      <td>http://www.statesman.com/news/local/police-000...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>648</th>\n",
       "      <td>Bremerhaven, Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Germany</td>\n",
       "      <td>30.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>email/FB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>649</th>\n",
       "      <td>Huntsville, Ontario, Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>30.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://doppleronline.ca/huntsville/sistermarc...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>650</th>\n",
       "      <td>Lilongwe, Malawi</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>651</th>\n",
       "      <td>Stavanger, Norway</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Norway</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>652</th>\n",
       "      <td>Isla Mujeres, Mexico</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>headcount from FB photo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>653</th>\n",
       "      <td>Cuenca, Ecuador</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ecuador</td>\n",
       "      <td>20.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://zeromagecuador.com/en/womens-march-in-c...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>654</th>\n",
       "      <td>Belfast, UK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UK</td>\n",
       "      <td>200.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.bbc.com/news/uk-northern-ireland-38...</td>\n",
       "      <td>https://twitter.com/ferguskelly/status/8231580...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>655</th>\n",
       "      <td>Castlebar, Ireland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ireland</td>\n",
       "      <td>120.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://twitter.com/ClearyConnolly/status/8232...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>656</th>\n",
       "      <td>Montpellier, France</td>\n",
       "      <td>NaN</td>\n",
       "      <td>France</td>\n",
       "      <td>500.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.midilibre.fr/2017/01/21/montpellier...</td>\n",
       "      <td>https://twitter.com/marienoellewurm/status/823...</td>\n",
       "      <td>https://t.co/dYoxYWZ13q</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>657</th>\n",
       "      <td>Guelph, ON, Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>545.0</td>\n",
       "      <td>545.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://twitter.com/l2m2d2/status/823146333095...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>658</th>\n",
       "      <td>Lusaka, Zambia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Zambia</td>\n",
       "      <td>140.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://twitter.com/ZamWomenMarch/status/82312...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>659</th>\n",
       "      <td>Songdo, South Korea</td>\n",
       "      <td>NaN</td>\n",
       "      <td>South Korea</td>\n",
       "      <td>25.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://twitter.com/jodikittle/status/82310507...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>660</th>\n",
       "      <td>Shipley, UK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UK</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://twitter.com/chickpeajones/status/82279...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>661</th>\n",
       "      <td>Maadi Degla, Cairo, Egypt</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://twitter.com/ABHodgkins/status/82308134...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>662</th>\n",
       "      <td>Trondheim, Norway</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Norway</td>\n",
       "      <td>260.0</td>\n",
       "      <td>260.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.adressa.no/nyheter/trondheim/2017/0...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>663</th>\n",
       "      <td>Phnom Penh, Cambodia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cambodia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://twitter.com/TheFoolishFish/status/8231...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>664</th>\n",
       "      <td>Rabat, Morocco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Morocco</td>\n",
       "      <td>23.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>eyewitness onsite (also picture)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>665</th>\n",
       "      <td>Ajijic, Mexico</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>666</th>\n",
       "      <td>San Pancho (San Francisco), Nayarit, Mexico</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>667</th>\n",
       "      <td>Riga, Latvia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Latvia</td>\n",
       "      <td>200.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.lsm.lv/en/article/politics/women-ma...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>668</th>\n",
       "      <td>Oranjestad, Aruba</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Aruba</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://twitter.com/rymey/status/8233040549358...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>669</th>\n",
       "      <td>Kingston, ON, Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>500.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.facebook.com/events/951645474967260/</td>\n",
       "      <td>Eyewitness</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>670</th>\n",
       "      <td>Oaxaca</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>eyewitness</td>\n",
       "      <td>email citing transit police</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>671</th>\n",
       "      <td>Mazatlan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>30.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FB; onsite eyewitnesses and photographic evidence</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>672</th>\n",
       "      <td>Riva Views</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bahrain</td>\n",
       "      <td>20.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>eyewitness\\n</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>673</th>\n",
       "      <td>Bonn</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Germany</td>\n",
       "      <td>200.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.general-anzeiger-bonn.de/ga-english...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>674</th>\n",
       "      <td>Heidelberg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Germany</td>\n",
       "      <td>800.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.rp-online.de/politik/ausland/women-...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>675</th>\n",
       "      <td>Dusseldorf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Germany</td>\n",
       "      <td>54.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.facebook.com/events/202632113541806/</td>\n",
       "      <td>Eyewitness</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>676</th>\n",
       "      <td>Lethbridge, AL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>500.0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://lethbridgeherald.com/news/lethbridge-ne...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>677</th>\n",
       "      <td>Leipzig</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Germany</td>\n",
       "      <td>20.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.facebook.com/leipglo/?fref=ts</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>678 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           place state      country  \\\n",
       "0                                    Abilene, TX    TX           US   \n",
       "1                                   Accident, MD    MD           US   \n",
       "2                                       Adak, AK    AK           US   \n",
       "3                                     Adrian, MI    MI           US   \n",
       "4                                        Ajo, AZ    AZ           US   \n",
       "5                                    Alameda, CA    CA           US   \n",
       "6                                    Alamosa, CO    CO           US   \n",
       "7                                     Albany, CA    CA           US   \n",
       "8                                     Albany, NY    NY           US   \n",
       "9                                 Alexandria, VA    VA           US   \n",
       "10                               Albuquerque, NM    NM           US   \n",
       "11                              Almanor West, CA    CA           US   \n",
       "12                                    Alpine, TX    TX           US   \n",
       "13                                  Amarillo, TX    TX           US   \n",
       "14                             Amelia Island, FL    FL           US   \n",
       "15                                 Anacortes, WA    WA           US   \n",
       "16                                 Anchorage, AK    AK           US   \n",
       "17                                 Ann Arbor, MI    MI           US   \n",
       "18                                 Annapolis, MD    MD           US   \n",
       "19                                 Arlington, VA    VA           US   \n",
       "20                               Asbury Park, NJ    NJ           US   \n",
       "21                                 Asheville, NC    NC           US   \n",
       "22                                   Ashland, OR    OR           US   \n",
       "23                                     Aspen, CO    CO           US   \n",
       "24                                   Astoria, OR    OR           US   \n",
       "25                                    Athens, GA    GA           US   \n",
       "26                                   Atlanta, GA    GA           US   \n",
       "27                                   Augusta, GA    GA           US   \n",
       "28                                   Augusta, ME    ME           US   \n",
       "29                                    Austin, TX    TX           US   \n",
       "..                                           ...   ...          ...   \n",
       "648                         Bremerhaven, Germany   NaN      Germany   \n",
       "649                  Huntsville, Ontario, Canada   NaN       Canada   \n",
       "650                             Lilongwe, Malawi   NaN       Malawi   \n",
       "651                            Stavanger, Norway   NaN       Norway   \n",
       "652                         Isla Mujeres, Mexico   NaN       Mexico   \n",
       "653                              Cuenca, Ecuador   NaN      Ecuador   \n",
       "654                                  Belfast, UK   NaN           UK   \n",
       "655                           Castlebar, Ireland   NaN      Ireland   \n",
       "656                          Montpellier, France   NaN       France   \n",
       "657                           Guelph, ON, Canada   NaN       Canada   \n",
       "658                               Lusaka, Zambia   NaN       Zambia   \n",
       "659                          Songdo, South Korea   NaN  South Korea   \n",
       "660                                  Shipley, UK   NaN           UK   \n",
       "661                    Maadi Degla, Cairo, Egypt   NaN        Egypt   \n",
       "662                            Trondheim, Norway   NaN       Norway   \n",
       "663                         Phnom Penh, Cambodia   NaN     Cambodia   \n",
       "664                               Rabat, Morocco   NaN      Morocco   \n",
       "665                               Ajijic, Mexico   NaN       Mexico   \n",
       "666  San Pancho (San Francisco), Nayarit, Mexico   NaN       Mexico   \n",
       "667                                 Riga, Latvia   NaN       Latvia   \n",
       "668                            Oranjestad, Aruba   NaN        Aruba   \n",
       "669                         Kingston, ON, Canada   NaN       Canada   \n",
       "670                                       Oaxaca   NaN       Mexico   \n",
       "671                                     Mazatlan   NaN       Mexico   \n",
       "672                                   Riva Views   NaN      Bahrain   \n",
       "673                                         Bonn   NaN      Germany   \n",
       "674                                   Heidelberg   NaN      Germany   \n",
       "675                                   Dusseldorf   NaN      Germany   \n",
       "676                               Lethbridge, AL   NaN       Canada   \n",
       "677                                      Leipzig   NaN      Germany   \n",
       "\n",
       "     estimate_low  estimate_high  est3  not121  \\\n",
       "0           200.0          200.0   NaN     NaN   \n",
       "1            54.0           54.0   NaN     NaN   \n",
       "2            10.0           10.0   NaN     NaN   \n",
       "3           130.0          150.0   NaN     NaN   \n",
       "4           250.0          250.0   NaN     NaN   \n",
       "5             8.0            8.0   NaN     NaN   \n",
       "6           350.0          350.0   NaN     NaN   \n",
       "7           500.0          500.0   NaN     NaN   \n",
       "8          7000.0         9000.0   NaN     NaN   \n",
       "9            17.0           17.0   NaN     NaN   \n",
       "10         3000.0        20000.0   NaN     NaN   \n",
       "11            4.0            4.0   NaN     NaN   \n",
       "12           96.0           96.0   NaN     NaN   \n",
       "13          600.0          600.0   NaN     NaN   \n",
       "14          700.0         1300.0   NaN     NaN   \n",
       "15            NaN            NaN   NaN   200.0   \n",
       "16         2000.0         3000.0   NaN     NaN   \n",
       "17        11000.0        11000.0   NaN     NaN   \n",
       "18         1600.0         1600.0   NaN     NaN   \n",
       "19            NaN            NaN   NaN     NaN   \n",
       "20         6000.0         6000.0   NaN     NaN   \n",
       "21         7000.0        10000.0   NaN     NaN   \n",
       "22         6000.0         8000.0   NaN     NaN   \n",
       "23         1000.0         1000.0   NaN     NaN   \n",
       "24          100.0         1000.0   NaN     NaN   \n",
       "25          700.0         5000.0   NaN     NaN   \n",
       "26        60000.0        63000.0   NaN     NaN   \n",
       "27          600.0          600.0   NaN     NaN   \n",
       "28         5000.0        10000.0   NaN     NaN   \n",
       "29        30000.0        50000.0   NaN     NaN   \n",
       "..            ...            ...   ...     ...   \n",
       "648          30.0           30.0   NaN     NaN   \n",
       "649          30.0           30.0   NaN     NaN   \n",
       "650           NaN            NaN   NaN     NaN   \n",
       "651           NaN            NaN   NaN     NaN   \n",
       "652           5.0            5.0   NaN     NaN   \n",
       "653          20.0           50.0   NaN     NaN   \n",
       "654         200.0          300.0   NaN     NaN   \n",
       "655         120.0          120.0   NaN     NaN   \n",
       "656         500.0         3000.0   NaN     NaN   \n",
       "657         545.0          545.0   NaN     NaN   \n",
       "658         140.0          140.0   NaN     NaN   \n",
       "659          25.0           25.0   NaN     NaN   \n",
       "660        1400.0         1400.0   NaN     NaN   \n",
       "661           4.0            4.0   NaN     NaN   \n",
       "662         260.0          260.0   NaN     NaN   \n",
       "663           NaN            NaN   NaN     NaN   \n",
       "664          23.0           23.0   NaN     NaN   \n",
       "665           NaN            NaN   NaN     NaN   \n",
       "666           NaN            NaN   NaN     NaN   \n",
       "667         200.0          200.0   NaN     NaN   \n",
       "668           1.0            1.0   NaN     NaN   \n",
       "669         500.0         1000.0   NaN     NaN   \n",
       "670        1000.0         2000.0   NaN     NaN   \n",
       "671          30.0          100.0   NaN     NaN   \n",
       "672          20.0           20.0   NaN     NaN   \n",
       "673         200.0          200.0   NaN     NaN   \n",
       "674         800.0          800.0   NaN     NaN   \n",
       "675          54.0          400.0   NaN     NaN   \n",
       "676         500.0          600.0   NaN     NaN   \n",
       "677          20.0           30.0   NaN     NaN   \n",
       "\n",
       "                                                source  \\\n",
       "0    http://www.reporternews.com/story/news/local/2...   \n",
       "1                            Twitter; on-site witness    \n",
       "2                                              adn.com   \n",
       "3     https://www.facebook.com/events/847360115406578/   \n",
       "4    https://www.facebook.com/plugins/post.php?href...   \n",
       "5                                                   FB   \n",
       "6    https://twitter.com/zepol/status/8232349739352...   \n",
       "7    https://twitter.com/ben_silverman/status/82303...   \n",
       "8    http://www.timesunion.com/local/article/Albany...   \n",
       "9    https://twitter.com/TinaPStacy/status/82322604...   \n",
       "10   http://www.koat.com/article/thousands-fill-civ...   \n",
       "11                                 eyewitness; picture   \n",
       "12   https://twitter.com/sarahmvasquez/status/82318...   \n",
       "13   https://www.texastribune.org/2017/01/21/thousa...   \n",
       "14   http://www.firstcoastnews.com/news/womens-marc...   \n",
       "15   http://www.goskagit.com/skagit/hundreds-partic...   \n",
       "16   https://www.adn.com/alaska-news/2017/01/21/lar...   \n",
       "17   http://www.mlive.com/news/ann-arbor/index.ssf/...   \n",
       "18   http://www.capitalgazette.com/news/annapolis/p...   \n",
       "19                                                 NaN   \n",
       "20   https://twitter.com/JuliaJHobbs/status/8229551...   \n",
       "21   http://wlos.com/news/local/photo-gallery-the-w...   \n",
       "22   http://www.mailtribune.com/news/20170121/voice...   \n",
       "23   https://twitter.com/SarahGoTrillIum/status/823...   \n",
       "24   http://www.dailyastorian.com/Local_News/201701...   \n",
       "25   http://onlineathens.com/slideshow/2017-01-21/p...   \n",
       "26   http://www.ajc.com/news/state--regional-govt--...   \n",
       "27   http://chronicle.augusta.com/news/2017-01-21/h...   \n",
       "28   http://www.pressherald.com/2017/01/21/thousand...   \n",
       "29   http://kut.org/post/tens-thousands-participate...   \n",
       "..                                                 ...   \n",
       "648                                           email/FB   \n",
       "649  https://doppleronline.ca/huntsville/sistermarc...   \n",
       "650                                                NaN   \n",
       "651                                                NaN   \n",
       "652                            headcount from FB photo   \n",
       "653  http://zeromagecuador.com/en/womens-march-in-c...   \n",
       "654  http://www.bbc.com/news/uk-northern-ireland-38...   \n",
       "655  https://twitter.com/ClearyConnolly/status/8232...   \n",
       "656  http://www.midilibre.fr/2017/01/21/montpellier...   \n",
       "657  https://twitter.com/l2m2d2/status/823146333095...   \n",
       "658  https://twitter.com/ZamWomenMarch/status/82312...   \n",
       "659  https://twitter.com/jodikittle/status/82310507...   \n",
       "660  https://twitter.com/chickpeajones/status/82279...   \n",
       "661  https://twitter.com/ABHodgkins/status/82308134...   \n",
       "662  http://www.adressa.no/nyheter/trondheim/2017/0...   \n",
       "663  https://twitter.com/TheFoolishFish/status/8231...   \n",
       "664                   eyewitness onsite (also picture)   \n",
       "665                                                NaN   \n",
       "666                                                NaN   \n",
       "667  http://www.lsm.lv/en/article/politics/women-ma...   \n",
       "668  https://twitter.com/rymey/status/8233040549358...   \n",
       "669   https://www.facebook.com/events/951645474967260/   \n",
       "670                                         eyewitness   \n",
       "671  FB; onsite eyewitnesses and photographic evidence   \n",
       "672                                       eyewitness\\n   \n",
       "673  http://www.general-anzeiger-bonn.de/ga-english...   \n",
       "674  http://www.rp-online.de/politik/ausland/women-...   \n",
       "675   https://www.facebook.com/events/202632113541806/   \n",
       "676  http://lethbridgeherald.com/news/lethbridge-ne...   \n",
       "677          https://www.facebook.com/leipglo/?fref=ts   \n",
       "\n",
       "                                               source2  \\\n",
       "0                                                  NaN   \n",
       "1                                                  NaN   \n",
       "2                                                  NaN   \n",
       "3    http://www.lenconnect.com/news/20170122/marche...   \n",
       "4                                                  NaN   \n",
       "5                                                  NaN   \n",
       "6                                                  NaN   \n",
       "7                 Albany PD (reported via google form)   \n",
       "8                                                   FB   \n",
       "9                                                  NaN   \n",
       "10   https://twitter.com/PatDavisNM/status/82293149...   \n",
       "11                                                 NaN   \n",
       "12                                                 NaN   \n",
       "13                                                 NaN   \n",
       "14   https://twitter.com/wideofthepost/status/82307...   \n",
       "15                                                 NaN   \n",
       "16   https://twitter.com/julia_omalley/status/82290...   \n",
       "17                                                 NaN   \n",
       "18                                                 NaN   \n",
       "19                                                 NaN   \n",
       "20                                                 NaN   \n",
       "21   http://wlos.com/news/local/photo-gallery-the-w...   \n",
       "22   http://ijpr.org/post/southern-oregon-womens-ma...   \n",
       "23                                                 NaN   \n",
       "24                                                 NaN   \n",
       "25                                                  FB   \n",
       "26   http://www.nbcnews.com/storyline/inauguration-...   \n",
       "27                                                 NaN   \n",
       "28   http://bangordailynews.com/2017/01/21/news/sta...   \n",
       "29   http://www.statesman.com/news/local/police-000...   \n",
       "..                                                 ...   \n",
       "648                                                NaN   \n",
       "649                                                NaN   \n",
       "650                                                NaN   \n",
       "651                                                NaN   \n",
       "652                                                NaN   \n",
       "653                                                NaN   \n",
       "654  https://twitter.com/ferguskelly/status/8231580...   \n",
       "655                                                NaN   \n",
       "656  https://twitter.com/marienoellewurm/status/823...   \n",
       "657                                                NaN   \n",
       "658                                                NaN   \n",
       "659                                                NaN   \n",
       "660                                                NaN   \n",
       "661                                                NaN   \n",
       "662                                                NaN   \n",
       "663                                                NaN   \n",
       "664                                                NaN   \n",
       "665                                                NaN   \n",
       "666                                                NaN   \n",
       "667                                                NaN   \n",
       "668                                                NaN   \n",
       "669                                         Eyewitness   \n",
       "670                       email citing transit police    \n",
       "671                                                NaN   \n",
       "672                                                NaN   \n",
       "673                                                NaN   \n",
       "674                                                NaN   \n",
       "675                                         Eyewitness   \n",
       "676                                                NaN   \n",
       "677                                                NaN   \n",
       "\n",
       "                                               source3  \n",
       "0                                                  NaN  \n",
       "1                                                  NaN  \n",
       "2                                                  NaN  \n",
       "3                                                  NaN  \n",
       "4                                                  NaN  \n",
       "5                                                  NaN  \n",
       "6                                                  NaN  \n",
       "7                                                  NaN  \n",
       "8                                                  NaN  \n",
       "9                                                  NaN  \n",
       "10   https://twitter.com/AthertonKD/status/82321516...  \n",
       "11                                                 NaN  \n",
       "12                                                 NaN  \n",
       "13                                                 NaN  \n",
       "14                                                 NaN  \n",
       "15                                                 NaN  \n",
       "16                                                 NaN  \n",
       "17                                                 NaN  \n",
       "18                                                 NaN  \n",
       "19                                                 NaN  \n",
       "20                                                 NaN  \n",
       "21                                                 NaN  \n",
       "22                                                 NaN  \n",
       "23                                                 NaN  \n",
       "24                                                 NaN  \n",
       "25                                                 NaN  \n",
       "26                                                 NaN  \n",
       "27                                                 NaN  \n",
       "28                                                 NaN  \n",
       "29                                                 NaN  \n",
       "..                                                 ...  \n",
       "648                                                NaN  \n",
       "649                                                NaN  \n",
       "650                                                NaN  \n",
       "651                                                NaN  \n",
       "652                                                NaN  \n",
       "653                                                NaN  \n",
       "654                                                NaN  \n",
       "655                                                NaN  \n",
       "656                            https://t.co/dYoxYWZ13q  \n",
       "657                                                NaN  \n",
       "658                                                NaN  \n",
       "659                                                NaN  \n",
       "660                                                NaN  \n",
       "661                                                NaN  \n",
       "662                                                NaN  \n",
       "663                                                NaN  \n",
       "664                                                NaN  \n",
       "665                                                NaN  \n",
       "666                                                NaN  \n",
       "667                                                NaN  \n",
       "668                                                NaN  \n",
       "669                                                NaN  \n",
       "670                                                NaN  \n",
       "671                                                NaN  \n",
       "672                                                NaN  \n",
       "673                                                NaN  \n",
       "674                                                NaN  \n",
       "675                                                NaN  \n",
       "676                                                NaN  \n",
       "677                                                NaN  \n",
       "\n",
       "[678 rows x 10 columns]"
      ]
     },
     "execution_count": 256,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# a few added here to fix data in spreadsheet\n",
    "state_lookup = { 'AK': 'Alaska', 'AL': 'Alabama', 'AR': 'Arkansas', 'AS': 'American Samoa', 'AZ': 'Arizona', 'CA': 'California', 'CO': 'Colorado', 'CT': 'Connecticut', 'DC': 'District of Columbia', 'DE': 'Delaware', 'FL': 'Florida', 'GA': 'Georgia', 'GU': 'Guam', 'HI': 'Hawaii', 'IA': 'Iowa', 'ID': 'Idaho', 'IL': 'Illinois', 'IN': 'Indiana', 'KS': 'Kansas', 'KY': 'Kentucky', 'LA': 'Louisiana', 'MA': 'Massachusetts', 'MD': 'Maryland', 'ME': 'Maine', 'MI': 'Michigan', 'MN': 'Minnesota', 'MO': 'Missouri', 'MP': 'Northern Mariana Islands', 'MS': 'Mississippi', 'MT': 'Montana', 'NA': 'National', 'NC': 'North Carolina', 'ND': 'North Dakota', 'NE': 'Nebraska', 'NH': 'New Hampshire', 'NJ': 'New Jersey', 'NM': 'New Mexico', 'NV': 'Nevada', 'NY': 'New York', 'OH': 'Ohio', 'OK': 'Oklahoma', 'OR': 'Oregon', 'PA': 'Pennsylvania', 'PR': 'Puerto Rico', 'RI': 'Rhode Island', 'SC': 'South Carolina', 'SD': 'South Dakota', 'TN': 'Tennessee', 'TX': 'Texas', 'UT': 'Utah', 'VA': 'Virginia', 'VI': 'Virgin Islands', 'VT': 'Vermont', 'WA': 'Washington', 'WI': 'Wisconsin', 'WV': 'West Virginia', 'WY': 'Wyoming', 'CA (Seacrest)':'California', 'Guam': 'Guam'}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>place</th>\n",
       "      <th>state</th>\n",
       "      <th>country</th>\n",
       "      <th>estimate_low</th>\n",
       "      <th>estimate_high</th>\n",
       "      <th>source</th>\n",
       "      <th>source2</th>\n",
       "      <th>source3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Abilene, TX</td>\n",
       "      <td>TX</td>\n",
       "      <td>US</td>\n",
       "      <td>200.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>http://www.reporternews.com/story/news/local/2...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Accident, MD</td>\n",
       "      <td>MD</td>\n",
       "      <td>US</td>\n",
       "      <td>54.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>http://www.riverfronttimes.com/newsblog/2017/0...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Twitter; on-site witness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Adak, AK</td>\n",
       "      <td>AK</td>\n",
       "      <td>US</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>adn.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Adrian, MI</td>\n",
       "      <td>MI</td>\n",
       "      <td>US</td>\n",
       "      <td>150.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>http://www.lenconnect.com/news/20170122/marche...</td>\n",
       "      <td>http://www.lenconnect.com/news/20170122/marche...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ajo, AZ</td>\n",
       "      <td>AZ</td>\n",
       "      <td>US</td>\n",
       "      <td>250.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>https://www.facebook.com/plugins/post.php?href...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Alameda, CA</td>\n",
       "      <td>CA</td>\n",
       "      <td>US</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>FB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Alamosa, CO</td>\n",
       "      <td>CO</td>\n",
       "      <td>US</td>\n",
       "      <td>350.0</td>\n",
       "      <td>350.0</td>\n",
       "      <td>https://twitter.com/zepol/status/8232349739352...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Albany, CA</td>\n",
       "      <td>CA</td>\n",
       "      <td>US</td>\n",
       "      <td>500.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>https://twitter.com/ben_silverman/status/82303...</td>\n",
       "      <td>Albany PD (reported via google form)</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Albany, NY</td>\n",
       "      <td>NY</td>\n",
       "      <td>US</td>\n",
       "      <td>7000.0</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>http://www.timesunion.com/local/article/Albany...</td>\n",
       "      <td>FB</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Alexandria, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>US</td>\n",
       "      <td>17.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>https://twitter.com/TinaPStacy/status/82322604...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Albuquerque, NM</td>\n",
       "      <td>NM</td>\n",
       "      <td>US</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>http://www.koat.com/article/thousands-fill-civ...</td>\n",
       "      <td>https://twitter.com/PatDavisNM/status/82293149...</td>\n",
       "      <td>https://twitter.com/AthertonKD/status/82321516...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Alliance, NE</td>\n",
       "      <td>NE</td>\n",
       "      <td>US</td>\n",
       "      <td>100.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>eyewtiness onsite w/ headcount</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Almanor West, CA</td>\n",
       "      <td>CA</td>\n",
       "      <td>US</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>eyewitness; picture</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Alpine, TX</td>\n",
       "      <td>TX</td>\n",
       "      <td>US</td>\n",
       "      <td>96.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>https://twitter.com/sarahmvasquez/status/82318...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Amarillo, TX</td>\n",
       "      <td>TX</td>\n",
       "      <td>US</td>\n",
       "      <td>600.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>https://www.texastribune.org/2017/01/21/thousa...</td>\n",
       "      <td>http://www.myhighplains.com/news/hundreds-gath...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Amelia Island, FL</td>\n",
       "      <td>FL</td>\n",
       "      <td>US</td>\n",
       "      <td>700.0</td>\n",
       "      <td>1367.0</td>\n",
       "      <td>http://www.firstcoastnews.com/news/womens-marc...</td>\n",
       "      <td>https://twitter.com/wideofthepost/status/82307...</td>\n",
       "      <td>http://www.ncflindependent.com/2017/01/21/stan...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Anacortes, WA</td>\n",
       "      <td>WA</td>\n",
       "      <td>US</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>http://www.goskagit.com/skagit/hundreds-partic...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Anchorage, AK</td>\n",
       "      <td>AK</td>\n",
       "      <td>US</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>https://www.adn.com/alaska-news/2017/01/21/lar...</td>\n",
       "      <td>https://twitter.com/julia_omalley/status/82290...</td>\n",
       "      <td>http://www.ktuu.com/content/news/Thousands-of-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Angola, IN</td>\n",
       "      <td>IN</td>\n",
       "      <td>US</td>\n",
       "      <td>24.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>http://wane.com/2017/01/21/womens-marches-in-a...</td>\n",
       "      <td>http://kpcnews.com/news/latest/heraldrepublican/</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Ann Arbor, MI</td>\n",
       "      <td>MI</td>\n",
       "      <td>US</td>\n",
       "      <td>11000.0</td>\n",
       "      <td>11000.0</td>\n",
       "      <td>http://www.mlive.com/news/ann-arbor/index.ssf/...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Annapolis, MD</td>\n",
       "      <td>MD</td>\n",
       "      <td>US</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>http://www.capitalgazette.com/news/annapolis/p...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Annville, PA</td>\n",
       "      <td>PA</td>\n",
       "      <td>US</td>\n",
       "      <td>30.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>http://www.ldnews.com/videos/news/2017/01/21/w...</td>\n",
       "      <td>onsite eyewitness via google form</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Appleton, WI</td>\n",
       "      <td>WI</td>\n",
       "      <td>US</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>http://www.sheboyganpress.com/story/news/local...</td>\n",
       "      <td>http://www.postcrescent.com/story/news/local/2...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Arden, DE</td>\n",
       "      <td>DE</td>\n",
       "      <td>US</td>\n",
       "      <td>40.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>onsite eyewitness via google form; did headcount</td>\n",
       "      <td>FB</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Asbury Park, NJ</td>\n",
       "      <td>NJ</td>\n",
       "      <td>US</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>https://twitter.com/JuliaJHobbs/status/8229551...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Asheville, NC</td>\n",
       "      <td>NC</td>\n",
       "      <td>US</td>\n",
       "      <td>7000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>http://wlos.com/news/local/photo-gallery-the-w...</td>\n",
       "      <td>http://wlos.com/news/local/photo-gallery-the-w...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Ashland, OR</td>\n",
       "      <td>OR</td>\n",
       "      <td>US</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>http://www.oregonlive.com/trending/2017/01/wom...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Aspen, CO</td>\n",
       "      <td>CO</td>\n",
       "      <td>US</td>\n",
       "      <td>200.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>http://www.aspendailynews.com/section/home/174009</td>\n",
       "      <td>https://twitter.com/SarahGoTrillIum/status/823...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Astoria, OR</td>\n",
       "      <td>OR</td>\n",
       "      <td>US</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>http://www.dailyastorian.com/Local_News/201701...</td>\n",
       "      <td>http://www.kast1370.com/index.php?option=com_c...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Athens, GA</td>\n",
       "      <td>GA</td>\n",
       "      <td>US</td>\n",
       "      <td>700.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>http://onlineathens.com/slideshow/2017-01-21/p...</td>\n",
       "      <td>FB</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>906</th>\n",
       "      <td>Taipa, Macau</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Macau</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>http://aamacau.com/2017/01/22/%E9%9F%BF%E6%87%...</td>\n",
       "      <td>http://www.macaupostdaily.com/article2236.html</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>907</th>\n",
       "      <td>Tblisi, Georgia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>300.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>http://dfwatch.net/tbilisi-joins-global-womens...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>908</th>\n",
       "      <td>Tel Aviv, Israel</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Israel</td>\n",
       "      <td>300.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>on site report with crowd-counting via flyer d...</td>\n",
       "      <td>https://twitter.com/melanielidman/status/82287...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>909</th>\n",
       "      <td>Thessoloniki</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Greece</td>\n",
       "      <td>36.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>http://www.centralctcommunications.com/newbrit...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>910</th>\n",
       "      <td>Todos Santos</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>200.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>onsite eyewitness</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>911</th>\n",
       "      <td>Tokyo, Japan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Japan</td>\n",
       "      <td>648.0</td>\n",
       "      <td>648.0</td>\n",
       "      <td>http://www.elle.com/culture/career-politics/ne...</td>\n",
       "      <td>https://www.facebook.com/events/37355156635747...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>912</th>\n",
       "      <td>Toronto, Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>60000.0</td>\n",
       "      <td>https://www.thestar.com/news/gta/2017/01/21/ev...</td>\n",
       "      <td>http://globalnews.ca/news/3197235/60000-people...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>913</th>\n",
       "      <td>Toulouse, France</td>\n",
       "      <td>NaN</td>\n",
       "      <td>France</td>\n",
       "      <td>200.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>FB group</td>\n",
       "      <td>onsite eyewitness</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>914</th>\n",
       "      <td>Trondheim, Norway</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Norway</td>\n",
       "      <td>260.0</td>\n",
       "      <td>280.0</td>\n",
       "      <td>http://www.adressa.no/nyheter/trondheim/2017/0...</td>\n",
       "      <td>http://www.adressa.no/nyheter/trondheim/2017/0...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>917</th>\n",
       "      <td>Ubud, Bali</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>FB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>918</th>\n",
       "      <td>Uvita</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Costa Rica</td>\n",
       "      <td>18.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Eyewitness report; photographic evidence</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>919</th>\n",
       "      <td>Vancouver, Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>http://www.cbc.ca/news/canada/british-columbia...</td>\n",
       "      <td>FB</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>920</th>\n",
       "      <td>Vicenza</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Italy</td>\n",
       "      <td>25.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>FB photo confirming headcount</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>921</th>\n",
       "      <td>Victoria, Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>http://www.timescolonist.com/news/local/women-...</td>\n",
       "      <td>https://www.facebook.com/isitt/posts/101580065...</td>\n",
       "      <td>http://www.cbc.ca/beta/news/canada/british-col...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>922</th>\n",
       "      <td>Vienna, Austria</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Austria</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>FB</td>\n",
       "      <td>http://www.usatoday.com/story/news/2017/01/21/...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>923</th>\n",
       "      <td>Vientiane</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Laos</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>FB photo confirming headcount</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>924</th>\n",
       "      <td>Vilnius, Lithuania</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lithuania</td>\n",
       "      <td>150.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>FB group with photos confirming approximate he...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>925</th>\n",
       "      <td>Warsaw</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Poland</td>\n",
       "      <td>200.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>http://www.cbsnews.com/pictures/womens-march-o...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>926</th>\n",
       "      <td>Wellington, New Zealand</td>\n",
       "      <td>NaN</td>\n",
       "      <td>New Zealand</td>\n",
       "      <td>700.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>https://www.facebook.com/events/215971992188360/</td>\n",
       "      <td>http://www.stuff.co.nz/national/88642615/new-z...</td>\n",
       "      <td>https://www.facebook.com/womensmarchnewzealand...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>927</th>\n",
       "      <td>Whitehorse, Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>200.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>http://www.cbc.ca/news/canada/north/yellowknif...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>928</th>\n",
       "      <td>Whitehorse, Yukon, Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>200.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>http://www.cbc.ca/news/canada/north/yellowknif...</td>\n",
       "      <td>https://twitter.com/dougrutherford/status/8229...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>929</th>\n",
       "      <td>Winnipeg, Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>http://www.cbc.ca/beta/news/canada/manitoba/wo...</td>\n",
       "      <td>https://twitter.com/Smile_Beaitiful/status/823...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>930</th>\n",
       "      <td>Wolfville, NS, Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>300.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>FB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>931</th>\n",
       "      <td>Xcalak</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>18.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>onsite eyewitness took approximate headcount</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>932</th>\n",
       "      <td>Yangon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Myanmar (Burma)</td>\n",
       "      <td>75.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>onsite eyewitness w photo w / approximate head...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>933</th>\n",
       "      <td>Yellowknife, NWT, Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>100.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>http://www.cbc.ca/news/canada/north/yellowknif...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>935</th>\n",
       "      <td>York, England</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>230.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>https://www.facebook.com/groups/pantsuitnation...</td>\n",
       "      <td>organizer onsite</td>\n",
       "      <td>https://www.yorkmix.com/news/53-empowering-pic...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>936</th>\n",
       "      <td>Surama</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Guyana</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Eyewitness account</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>937</th>\n",
       "      <td>Zacatitos</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>25.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>FB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>938</th>\n",
       "      <td>Zihuatanejo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>40.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Eyewitness account; photographic evidence</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>864 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         place state          country  estimate_low  \\\n",
       "2                  Abilene, TX    TX               US         200.0   \n",
       "3                 Accident, MD    MD               US          54.0   \n",
       "4                     Adak, AK    AK               US          10.0   \n",
       "5                   Adrian, MI    MI               US         150.0   \n",
       "6                      Ajo, AZ    AZ               US         250.0   \n",
       "7                  Alameda, CA    CA               US           8.0   \n",
       "8                  Alamosa, CO    CO               US         350.0   \n",
       "9                   Albany, CA    CA               US         500.0   \n",
       "10                  Albany, NY    NY               US        7000.0   \n",
       "11              Alexandria, VA    VA               US          17.0   \n",
       "12             Albuquerque, NM    NM               US        3000.0   \n",
       "13                Alliance, NE    NE               US         100.0   \n",
       "14            Almanor West, CA    CA               US           4.0   \n",
       "15                  Alpine, TX    TX               US          96.0   \n",
       "17                Amarillo, TX    TX               US         600.0   \n",
       "18           Amelia Island, FL    FL               US         700.0   \n",
       "19               Anacortes, WA    WA               US        1200.0   \n",
       "20               Anchorage, AK    AK               US        2000.0   \n",
       "21                  Angola, IN    IN               US          24.0   \n",
       "22               Ann Arbor, MI    MI               US       11000.0   \n",
       "23               Annapolis, MD    MD               US        1600.0   \n",
       "24                Annville, PA    PA               US          30.0   \n",
       "25                Appleton, WI    WI               US           3.0   \n",
       "26                   Arden, DE    DE               US          40.0   \n",
       "28             Asbury Park, NJ    NJ               US        6000.0   \n",
       "29               Asheville, NC    NC               US        7000.0   \n",
       "30                 Ashland, OR    OR               US        8000.0   \n",
       "31                   Aspen, CO    CO               US         200.0   \n",
       "32                 Astoria, OR    OR               US        1300.0   \n",
       "33                  Athens, GA    GA               US         700.0   \n",
       "..                         ...   ...              ...           ...   \n",
       "906               Taipa, Macau   NaN            Macau         100.0   \n",
       "907            Tblisi, Georgia   NaN          Georgia         300.0   \n",
       "908           Tel Aviv, Israel   NaN           Israel         300.0   \n",
       "909               Thessoloniki   NaN           Greece          36.0   \n",
       "910               Todos Santos   NaN           Mexico         200.0   \n",
       "911               Tokyo, Japan   NaN            Japan         648.0   \n",
       "912            Toronto, Canada   NaN           Canada       50000.0   \n",
       "913           Toulouse, France   NaN           France         200.0   \n",
       "914          Trondheim, Norway   NaN           Norway         260.0   \n",
       "917                 Ubud, Bali   NaN        Indonesia          95.0   \n",
       "918                      Uvita   NaN       Costa Rica          18.0   \n",
       "919          Vancouver, Canada   NaN           Canada       10000.0   \n",
       "920                    Vicenza   NaN            Italy          25.0   \n",
       "921           Victoria, Canada   NaN           Canada        2000.0   \n",
       "922            Vienna, Austria   NaN          Austria        1300.0   \n",
       "923                  Vientiane   NaN             Laos           9.0   \n",
       "924         Vilnius, Lithuania   NaN        Lithuania         150.0   \n",
       "925                     Warsaw   NaN           Poland         200.0   \n",
       "926    Wellington, New Zealand   NaN      New Zealand         700.0   \n",
       "927         Whitehorse, Canada   NaN           Canada         200.0   \n",
       "928  Whitehorse, Yukon, Canada   NaN           Canada         200.0   \n",
       "929           Winnipeg, Canada   NaN           Canada        1000.0   \n",
       "930      Wolfville, NS, Canada   NaN           Canada         300.0   \n",
       "931                     Xcalak   NaN           Mexico          18.0   \n",
       "932                     Yangon   NaN  Myanmar (Burma)          75.0   \n",
       "933   Yellowknife, NWT, Canada   NaN           Canada         100.0   \n",
       "935              York, England   NaN   United Kingdom         230.0   \n",
       "936                     Surama   NaN           Guyana           1.0   \n",
       "937                  Zacatitos   NaN           Mexico          25.0   \n",
       "938                Zihuatanejo   NaN           Mexico          40.0   \n",
       "\n",
       "     estimate_high                                             source  \\\n",
       "2            200.0  http://www.reporternews.com/story/news/local/2...   \n",
       "3             54.0  http://www.riverfronttimes.com/newsblog/2017/0...   \n",
       "4             10.0                                            adn.com   \n",
       "5            150.0  http://www.lenconnect.com/news/20170122/marche...   \n",
       "6            250.0  https://www.facebook.com/plugins/post.php?href...   \n",
       "7              8.0                                                 FB   \n",
       "8            350.0  https://twitter.com/zepol/status/8232349739352...   \n",
       "9            500.0  https://twitter.com/ben_silverman/status/82303...   \n",
       "10          9000.0  http://www.timesunion.com/local/article/Albany...   \n",
       "11            17.0  https://twitter.com/TinaPStacy/status/82322604...   \n",
       "12         15000.0  http://www.koat.com/article/thousands-fill-civ...   \n",
       "13           150.0                     eyewtiness onsite w/ headcount   \n",
       "14             4.0                                eyewitness; picture   \n",
       "15            96.0  https://twitter.com/sarahmvasquez/status/82318...   \n",
       "17           700.0  https://www.texastribune.org/2017/01/21/thousa...   \n",
       "18          1367.0  http://www.firstcoastnews.com/news/womens-marc...   \n",
       "19          1200.0  http://www.goskagit.com/skagit/hundreds-partic...   \n",
       "20          4000.0  https://www.adn.com/alaska-news/2017/01/21/lar...   \n",
       "21            60.0  http://wane.com/2017/01/21/womens-marches-in-a...   \n",
       "22         11000.0  http://www.mlive.com/news/ann-arbor/index.ssf/...   \n",
       "23          1600.0  http://www.capitalgazette.com/news/annapolis/p...   \n",
       "24            30.0  http://www.ldnews.com/videos/news/2017/01/21/w...   \n",
       "25             3.0  http://www.sheboyganpress.com/story/news/local...   \n",
       "26            50.0   onsite eyewitness via google form; did headcount   \n",
       "28          6000.0  https://twitter.com/JuliaJHobbs/status/8229551...   \n",
       "29         10000.0  http://wlos.com/news/local/photo-gallery-the-w...   \n",
       "30         15000.0  http://www.oregonlive.com/trending/2017/01/wom...   \n",
       "31          1000.0  http://www.aspendailynews.com/section/home/174009   \n",
       "32          1600.0  http://www.dailyastorian.com/Local_News/201701...   \n",
       "33          5000.0  http://onlineathens.com/slideshow/2017-01-21/p...   \n",
       "..             ...                                                ...   \n",
       "906          100.0  http://aamacau.com/2017/01/22/%E9%9F%BF%E6%87%...   \n",
       "907          300.0  http://dfwatch.net/tbilisi-joins-global-womens...   \n",
       "908          500.0  on site report with crowd-counting via flyer d...   \n",
       "909           36.0  http://www.centralctcommunications.com/newbrit...   \n",
       "910          300.0                                  onsite eyewitness   \n",
       "911          648.0  http://www.elle.com/culture/career-politics/ne...   \n",
       "912        60000.0  https://www.thestar.com/news/gta/2017/01/21/ev...   \n",
       "913          300.0                                          FB group    \n",
       "914          280.0  http://www.adressa.no/nyheter/trondheim/2017/0...   \n",
       "917          100.0                                                 FB   \n",
       "918           20.0           Eyewitness report; photographic evidence   \n",
       "919        15000.0  http://www.cbc.ca/news/canada/british-columbia...   \n",
       "920           25.0                      FB photo confirming headcount   \n",
       "921         8000.0  http://www.timescolonist.com/news/local/women-...   \n",
       "922         2000.0                                                 FB   \n",
       "923            9.0                      FB photo confirming headcount   \n",
       "924          200.0  FB group with photos confirming approximate he...   \n",
       "925          200.0  http://www.cbsnews.com/pictures/womens-march-o...   \n",
       "926         1000.0   https://www.facebook.com/events/215971992188360/   \n",
       "927          200.0  http://www.cbc.ca/news/canada/north/yellowknif...   \n",
       "928          300.0  http://www.cbc.ca/news/canada/north/yellowknif...   \n",
       "929         3000.0  http://www.cbc.ca/beta/news/canada/manitoba/wo...   \n",
       "930          300.0                                                 FB   \n",
       "931           25.0       onsite eyewitness took approximate headcount   \n",
       "932           85.0  onsite eyewitness w photo w / approximate head...   \n",
       "933          130.0  http://www.cbc.ca/news/canada/north/yellowknif...   \n",
       "935          300.0  https://www.facebook.com/groups/pantsuitnation...   \n",
       "936            1.0                                 Eyewitness account   \n",
       "937           26.0                                                 FB   \n",
       "938           50.0          Eyewitness account; photographic evidence   \n",
       "\n",
       "                                               source2  \\\n",
       "2                                                  NaN   \n",
       "3                                                  NaN   \n",
       "4                                                  NaN   \n",
       "5    http://www.lenconnect.com/news/20170122/marche...   \n",
       "6                                                  NaN   \n",
       "7                                                  NaN   \n",
       "8                                                  NaN   \n",
       "9                 Albany PD (reported via google form)   \n",
       "10                                                  FB   \n",
       "11                                                 NaN   \n",
       "12   https://twitter.com/PatDavisNM/status/82293149...   \n",
       "13                                                 NaN   \n",
       "14                                                 NaN   \n",
       "15                                                 NaN   \n",
       "17   http://www.myhighplains.com/news/hundreds-gath...   \n",
       "18   https://twitter.com/wideofthepost/status/82307...   \n",
       "19                                                 NaN   \n",
       "20   https://twitter.com/julia_omalley/status/82290...   \n",
       "21    http://kpcnews.com/news/latest/heraldrepublican/   \n",
       "22                                                 NaN   \n",
       "23                                                 NaN   \n",
       "24                   onsite eyewitness via google form   \n",
       "25   http://www.postcrescent.com/story/news/local/2...   \n",
       "26                                                  FB   \n",
       "28                                                 NaN   \n",
       "29   http://wlos.com/news/local/photo-gallery-the-w...   \n",
       "30                                                 NaN   \n",
       "31   https://twitter.com/SarahGoTrillIum/status/823...   \n",
       "32   http://www.kast1370.com/index.php?option=com_c...   \n",
       "33                                                  FB   \n",
       "..                                                 ...   \n",
       "906     http://www.macaupostdaily.com/article2236.html   \n",
       "907                                                NaN   \n",
       "908  https://twitter.com/melanielidman/status/82287...   \n",
       "909                                                NaN   \n",
       "910                                                NaN   \n",
       "911  https://www.facebook.com/events/37355156635747...   \n",
       "912  http://globalnews.ca/news/3197235/60000-people...   \n",
       "913                                  onsite eyewitness   \n",
       "914  http://www.adressa.no/nyheter/trondheim/2017/0...   \n",
       "917                                                NaN   \n",
       "918                                                NaN   \n",
       "919                                                 FB   \n",
       "920                                                NaN   \n",
       "921  https://www.facebook.com/isitt/posts/101580065...   \n",
       "922  http://www.usatoday.com/story/news/2017/01/21/...   \n",
       "923                                                NaN   \n",
       "924                                                NaN   \n",
       "925                                                NaN   \n",
       "926  http://www.stuff.co.nz/national/88642615/new-z...   \n",
       "927                                                NaN   \n",
       "928  https://twitter.com/dougrutherford/status/8229...   \n",
       "929  https://twitter.com/Smile_Beaitiful/status/823...   \n",
       "930                                                NaN   \n",
       "931                                                NaN   \n",
       "932                                                NaN   \n",
       "933                                                NaN   \n",
       "935                                   organizer onsite   \n",
       "936                                                NaN   \n",
       "937                                                NaN   \n",
       "938                                                NaN   \n",
       "\n",
       "                                               source3  \n",
       "2                                                  NaN  \n",
       "3                            Twitter; on-site witness   \n",
       "4                                                  NaN  \n",
       "5                                                  NaN  \n",
       "6                                                  NaN  \n",
       "7                                                  NaN  \n",
       "8                                                  NaN  \n",
       "9                                                  NaN  \n",
       "10                                                 NaN  \n",
       "11                                                 NaN  \n",
       "12   https://twitter.com/AthertonKD/status/82321516...  \n",
       "13                                                 NaN  \n",
       "14                                                 NaN  \n",
       "15                                                 NaN  \n",
       "17                                                 NaN  \n",
       "18   http://www.ncflindependent.com/2017/01/21/stan...  \n",
       "19                                                 NaN  \n",
       "20   http://www.ktuu.com/content/news/Thousands-of-...  \n",
       "21                                                 NaN  \n",
       "22                                                 NaN  \n",
       "23                                                 NaN  \n",
       "24                                                 NaN  \n",
       "25                                                 NaN  \n",
       "26                                                 NaN  \n",
       "28                                                 NaN  \n",
       "29                                                 NaN  \n",
       "30                                                 NaN  \n",
       "31                                                 NaN  \n",
       "32                                                 NaN  \n",
       "33                                                 NaN  \n",
       "..                                                 ...  \n",
       "906                                                NaN  \n",
       "907                                                NaN  \n",
       "908                                                NaN  \n",
       "909                                                NaN  \n",
       "910                                                NaN  \n",
       "911                                                NaN  \n",
       "912                                                NaN  \n",
       "913                                                NaN  \n",
       "914                                                NaN  \n",
       "917                                                NaN  \n",
       "918                                                NaN  \n",
       "919                                                NaN  \n",
       "920                                                NaN  \n",
       "921  http://www.cbc.ca/beta/news/canada/british-col...  \n",
       "922                                                NaN  \n",
       "923                                                NaN  \n",
       "924                                                NaN  \n",
       "925                                                NaN  \n",
       "926  https://www.facebook.com/womensmarchnewzealand...  \n",
       "927                                                 FB  \n",
       "928                                                NaN  \n",
       "929                                                NaN  \n",
       "930                                                NaN  \n",
       "931                                                NaN  \n",
       "932                                                NaN  \n",
       "933                                                NaN  \n",
       "935  https://www.yorkmix.com/news/53-empowering-pic...  \n",
       "936                                                NaN  \n",
       "937                                                NaN  \n",
       "938                                                NaN  \n",
       "\n",
       "[864 rows x 8 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# drop what we don't care about\n",
    "df.drop([\"est3\", \"not121\"], axis=1, inplace=True)\n",
    "# \"a\", \"b\", \"c\",\"d\",\"e\", \"f\", \"g\", \"h\", \"i\", \"j\", \"k\", \"l\"\n",
    "df.drop([\"a\", \"b\", \"c\",\"d\",\"e\", \"f\", \"g\", \"h\", \"i\", \"j\", \"k\", \"l\"], axis=1, inplace=True)\n",
    "# drop rows that lack a max estimate\n",
    "df.dropna(axis=0, how='any', subset=['estimate_high'], inplace=True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# this is spelled wrong\n",
    "t_town = df[ df['place']=='Tblisi, Georgia']\n",
    "df.loc[t_town.index,'place'] = 'Tbilisi, Georgia'\n",
    "\n",
    "# this is that header type row\n",
    "df.drop( df[ df.place.str.contains('partial')].index, axis=0, inplace=True )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "\n",
    "def fix_us_place_names(place, country):\n",
    "    if country != \"US\":\n",
    "        return place\n",
    "    res  = place.split(', ')\n",
    "    if len(res) < 2 or res[-1] not in state_lookup:\n",
    "        return place\n",
    "    state = state_lookup[res[-1]]\n",
    "    res[-1]= state\n",
    "    res.append('United States')\n",
    "    return ', '.join(res)\n",
    "\n",
    "# z = \"Abilene, TX\"\n",
    "# # z = \"Encinitas, CA (Seacrest)\"\n",
    "# country = \"US\"\n",
    "# fix_us_place_names(z, country)\n",
    "\n",
    "# df['col'] = 'str' + df['col'].astype(str)\n",
    "# df[\"new_column\"] = df.apply(lambda x: x[\"A\"] * x[\"B\"], axis = 1)\n",
    "# df.columns = df.columns.append('full_place')\n",
    "\n",
    "# create a new col with the full place name, for easier geocoding\n",
    "df = df.assign(full_place=df.place)\n",
    "df.full_place = df.apply(lambda x: fix_us_place_names(x.place, x.country) , axis=1 )\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# g = geocoder.google(\"New York, New York, United States\")\n",
    "# g.latlng"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "cache = {}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": false,
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Abilene, Texas, United States\n",
      "Accident, Maryland, United States\n",
      "Adak, Alaska, United States\n",
      "Adrian, Michigan, United States\n",
      "Ajo, Arizona, United States\n",
      "Alameda, California, United States\n",
      "Alamosa, Colorado, United States\n",
      "Albany, California, United States\n",
      "Albany, New York, United States\n",
      "Alexandria, Virginia, United States\n",
      "Albuquerque, New Mexico, United States\n",
      "Alliance, Nebraska, United States\n",
      "Almanor West, California, United States\n",
      "Alpine, Texas, United States\n",
      "Amarillo, Texas, United States\n",
      "Amelia Island, Florida, United States\n",
      "Anacortes, Washington, United States\n",
      "Anchorage, Alaska, United States\n",
      "Angola, Indiana, United States\n",
      "Ann Arbor, Michigan, United States\n",
      "Annapolis, Maryland, United States\n",
      "Annville, Pennsylvania, United States\n",
      "Appleton, Wisconsin, United States\n",
      "Arden, Delaware, United States\n",
      "Asbury Park, New Jersey, United States\n",
      "Asheville, North Carolina, United States\n",
      "Ashland, Oregon, United States\n",
      "Aspen, Colorado, United States\n",
      "Astoria, Oregon, United States\n",
      "Athens, Georgia, United States\n",
      "Athens, Ohio, United States\n",
      "Atlanta, Georgia, United States\n",
      "Augusta, Georgia, United States\n",
      "Augusta, Maine, United States\n",
      "Austin, Texas, United States\n",
      "Avalon, California, United States\n",
      "Bailey, Colorado, United States\n",
      "Bainbridge Island, Washington, United States\n",
      "Bakersfield, California, United States\n",
      "Baltimore, Maryland, United States\n",
      "Bar Harbor, Maine, United States\n",
      "Bandon, Oregon, United States\n",
      "Bayfield, Wisconsin, United States\n",
      "Beaufort\n",
      "Beaumont, Texas, United States\n",
      "Beaver, Pennsylvania, United States\n",
      "Beaver Island, Michigan, United States\n",
      "Bellingham, Washington, United States\n",
      "Bemidji, Minnesota, United States\n",
      "Bend, Oregon, United States\n",
      "Bennington, Vermont, United States\n",
      "Bentonville, Arkansas, United States\n",
      "Berkeley, California, United States\n",
      "Bethel, Alaska, United States\n",
      "Bethlehem, Connecticut, United States\n",
      "Bethlehem, Pennsylvania, United States\n",
      "Bettendorf, Iowa, United States\n",
      "Beverly Hills, California, United States\n",
      "Binghamton, New York, United States\n",
      "Birmingham, Alabama, United States\n",
      "Bishop, California, United States\n",
      "Bismarck, North Dakota, United States\n",
      "Black Mountain, North Carolina, United States\n",
      "Block Island, Rhode Island, United States\n",
      "Bloomsburg, Pennsylvania, United States\n",
      "Bluff, Utah, United States\n",
      "Boise, Idaho, United States\n",
      "Borrego Springs, California, United States\n",
      "Boston, Massachusetts, United States\n",
      "Bozeman, Montana, United States\n",
      "Breen, Colorado, United States\n",
      "Bridgewater, Massachusetts, United States\n",
      "Brighton, Michigan, United States\n",
      "Brattleboro, Vermont, United States\n",
      "Brookings, Oregon, United States\n",
      "Broomfield, Colorado, United States\n",
      "Brownsville, Texas, United States\n",
      "Brunswick, Maine, United States\n",
      "Buffalo, New York, United States\n",
      "Burbank, California, United States\n",
      "Burns, Oregon, United States\n",
      "Burnsville, North Carolina, United States\n",
      "Cambridge\n",
      "Canton, New York, United States\n",
      "Cape Henlopen, Delaware, United States\n",
      "Carbondale, Colorado, United States\n",
      "Carbondale, Illinois, United States\n",
      "Carmel, California, United States\n",
      "Casper, Wyoming, United States\n",
      "Cathlamet, Washington, United States\n",
      "Champaign, Illinois, United States\n",
      "Charleston, South Carolina, United States\n",
      "Charleston, West Virginia, United States\n",
      "Charlotte, North Carolina, United States\n",
      "Charlottesville, Virginia, United States\n",
      "Chattanooga, Tennessee, United States\n",
      "Chelan, Washington, United States\n",
      "Chesapeake Bay, Maryland, United States\n",
      "Cheyenne, Wyoming, United States\n",
      "Chicago, Illinois, United States\n",
      "Chico, California, United States\n",
      "Chillicothe, Ohio, United States\n",
      "Christiansted, St. Croix\n",
      "Cincinnati, Ohio, United States\n",
      "Clare, Michigan, United States\n",
      "Clarion, Pennsylvania, United States\n",
      "Clemson, South Carolina, United States\n",
      "Cleveland, Ohio, United States\n",
      "Cobb, California, United States\n",
      "Cobleskill, New York, United States\n",
      "Cody, Wyoming, United States\n",
      "College Station, Texas, United States\n",
      "Colorado Springs, Colorado, United States\n",
      "Columbia, Maryland, United States\n",
      "Columbia, Missouri, United States\n",
      "Columbia, South Carolina, United States\n",
      "Columbus, Ohio, United States\n",
      "Compton, California, United States\n",
      "Concord, New Hampshire, United States\n",
      "Conover, Wisconsin, United States\n",
      "Cooperstown, New York, United States\n",
      "Coos Bay, Oregon, United States\n",
      "Copper Harbor, Michigan, United States\n",
      "Cordova, Alaska, United States\n",
      "Corpus Christi, Texas, United States\n",
      "Cortez, Colorado, United States\n",
      "Corvallis, Oregon, United States\n",
      "Craftsbury, Vermont, United States\n",
      "Crested Butte, Colorado, United States\n",
      "Crestone, Colorado, United States\n",
      "Cruz Bay, St. John\n",
      "Crystal River, Florida, United States\n",
      "Dallas, Texas, United States\n",
      "Davis, West Virginia, United States\n",
      "Dayton, Ohio, United States\n",
      "Daytona Beach, Florida, United States\n",
      "Decorah, Iowa, United States\n",
      "Delaware, Ohio, United States\n",
      "Delhi, New York, United States\n",
      "Deming, New Mexico, United States\n",
      "Denton, Texas, United States\n",
      "Denver, Colorado, United States\n",
      "Des Moines, Iowa, United States\n",
      "Detroit, Michigan, United States\n",
      "Douglas-Saugatuck, Michigan, United States\n",
      "Doylestown, Pennsylvania, United States\n",
      "Driggs, Idaho, United States\n",
      "Dubuque, Iowa, United States\n",
      "Duluth, Minnesota, United States\n",
      "Durango, Colorado, United States\n",
      "Eagle Pass, Texas, United States\n",
      "East Haddam, Connecticut, United States\n",
      "East Liberty, Pennsylvania, United States\n",
      "East Millinocket, Maine, United States\n",
      "Eastport, Maine, United States\n",
      "Eastsound, Washington, United States\n",
      "Eau Claire, Wisconsin, United States\n",
      "El Centro, California, United States\n",
      "El Morro, New Mexico, United States\n",
      "El Paso, Texas, United States\n",
      "Elgin, Illinois, United States\n",
      "Ellensburg, Washington, United States\n",
      "Ellsworth, Maine, United States\n",
      "Ely, Minnesota, United States\n",
      "Encinitas, California, United States\n",
      "Ephrata, Washington, United States\n",
      "Erie, Pennsylvania, United States\n",
      "Esperanza, Puerto Rico, United States\n",
      "Eugene, Oregon, United States\n",
      "Eureka, California, United States\n",
      "Evanston, Wyoming, United States\n",
      "Fairbanks, Alaska, United States\n",
      "Fairfax, California, United States\n",
      "Fairfield, Iowa, United States\n",
      "Fairmont, West Virginia, United States\n",
      "Falmouth, Massachusetts, United States\n",
      "Fargo, North Dakota, United States\n",
      "Fayetteville, Arkansas, United States\n",
      "Fernandina Beach, Florida, United States\n",
      "Flagstaff, Arizona, United States\n",
      "Florence, Oregon, United States\n",
      "Floyd, Virginia, United States\n",
      "Forks, Washington, United States\n",
      "Fort Atkinson, Wisconsin, United States\n",
      "Fort Bragg, California, United States\n",
      "Fort Collins, Colorado, United States\n",
      "Fort Wayne, Indiana, United States\n",
      "Fort Worth, Texas, United States\n",
      "Francestown, New Hampshire, United States\n",
      "Frederick, Maryland, United States\n",
      "Fredonia, New York, United States\n",
      "Fresno, California, United States\n",
      "Friday Harbor, Washington, United States\n",
      "Gainesville, Florida, United States\n",
      "Galesburg, Illinois, United States\n",
      "Gila, New Mexico, United States\n",
      "Glens Falls, New York, United States\n",
      "Glenwood Springs, Colorado, United States\n",
      "Gloucester, New Jersey, United States\n",
      "Gouldsboro, Maine, United States\n",
      "Grand Forks, North Dakota, United States\n",
      "Grand Junction, Colorado, United States\n",
      "Grand Marais, Minnesota, United States\n",
      "Grand Rapids, Michigan, United States\n",
      "Grants Pass, Oregon, United States\n",
      "Green Bay, Wisconsin, United States\n",
      "Green Valley, Arizona, United States\n",
      "Greenfield, Massachusetts, United States\n",
      "Greensboro, North Carolina, United States\n",
      "Greensburg, Indiana, United States\n",
      "Greenville, South Carolina, United States\n",
      "Greenville, North Carolina, United States\n",
      "Gross Pointe, Michigan, United States\n",
      "Gualala, California, United States\n",
      "Guilford, Connecticut, United States\n",
      "Gulfport, Mississippi, United States\n",
      "Gustavus, Alaska, United States\n",
      "Hagatna, Guam, United States\n",
      "Haines, Alaska, United States\n",
      "Halfway, Oregon, United States\n",
      "Hana, Hawaii, United States\n",
      "Harrisburg, Pennsylvania, United States\n",
      "Harrisville, Michigan, United States\n",
      "Hartford, Connecticut, United States\n",
      "Harwich, Massachusetts, United States\n",
      "Helena, Arkansas, United States\n",
      "Helena, Montana, United States\n",
      "Hemet, California, United States\n",
      "Hilldale, Utah, United States\n",
      "Hillsborough, North Carolina, United States\n",
      "Hilo, Hawaii, United States\n",
      "Holden Village, Washington, United States\n",
      "Homer, Alaska, United States\n",
      "Honolulu (Oahu) HI\n",
      "Hood River, Oregon, United States\n",
      "Hospital Ward\n",
      "Houghton, Michigan, United States\n",
      "Houlton, Maine, United States\n",
      "Houston, Texas, United States\n",
      "Howard County, Maryland, United States\n",
      "Hudson, New York, United States\n",
      "Huntsville, Alabama, United States\n",
      "Huron, South Dakota, United States\n",
      "Idaho Falls, Idaho, United States\n",
      "Indiana, Pennsylvania, United States\n",
      "Indianapolis, Indiana, United States\n",
      "Inverness, California, United States\n",
      "Iowa City, Iowa, United States\n",
      "Isla Vista, California, United States\n",
      "Issaquah, Washington, United States\n",
      "Ithaca, New York, United States\n",
      "Jackson, New Hampshire, United States\n",
      "Jackson, Mississippi, United States\n",
      "Jackson Hole, Wyoming, United States\n",
      "Jacksonville, Florida, United States\n",
      "Jefferson City, Missouri, United States\n",
      "Jerome, Arizona, United States\n",
      "Jonesborough, Tennessee, United States\n",
      "Joseph, Oregon, United States\n",
      "June Lake, California, United States\n",
      "Juneau, Alaska, United States\n",
      "Kahului, Maui, Hawaii, United States\n",
      "Kalamazoo, Michigan, United States\n",
      "Kanab, Utah, United States\n",
      "Kansas City, Missouri, United States\n",
      "Kaunakakai (Molokai)\n",
      "Kawaihae, Hawaii, United States\n",
      "Keene, New Hampshire, United States\n",
      "Kennebunk, Maine, United States\n",
      "Kent, Connecticut, United States\n",
      "Kent, Ohio, United States\n",
      "Ketchikan, Alaska, United States\n",
      "Ketchum, Idaho, United States\n",
      "Key West, Florida, United States\n",
      "Killington, Vermont, United States\n",
      "King's Beach, California, United States\n",
      "Kingston, Washington, United States\n",
      "Klamath Falls, Oregon\n",
      "Knoxville, Tennessee, United States\n",
      "Kodiak, Alaska, United States\n",
      "Kona, Hawaii, United States\n",
      "Kotzebue, Alaska, United States\n",
      "La Crosse, Wisconsin, United States\n",
      "La Grande, Oregon, United States\n",
      "Lafayette, Colorado, United States\n",
      "Lafayette, Indiana, United States\n",
      "Laguna Beach, California, United States\n",
      "Lake Havasu City, Arizona, United States\n",
      "Lakeside, Ohio, United States\n",
      "Lakeville, Connecticut, United States\n",
      "Lamoni, Iowa, United States\n",
      "Lancaster, New Hampshire, United States\n",
      "Lancaster, Pennsylvania, United States\n",
      "Lander, Wyoming, United States\n",
      "Langley, Washington, United States\n",
      "Lansdale, Pennsylvania, United States\n",
      "Lansing, Michigan, United States\n",
      "Las Cruces, New Mexico, United States\n",
      "Las Vegas, Nevada, United States\n",
      "Las Vegas, New Mexico, United States\n",
      "Leonia, New Jersey, United States\n",
      "Lexington, Kentucky, United States\n",
      "Lewes, Delaware, United States\n",
      "Lewis, New York, United States\n",
      "Lewisburg, Pennsylvania, United States\n",
      "Lihue (Kauai) HI\n",
      "Lilly, Pennsylvania, United States\n",
      "Lincoln, Nebraska, United States\n",
      "Little Rock, Arkansas, United States\n",
      "Logan, Utah, United States\n",
      "Lompoc, California, United States\n",
      "Longview, Washington, United States\n",
      "Longville, Minnesota, United States\n",
      "Los Angeles, California, United States\n",
      "Louisville, Kentucky, United States\n",
      "Loup City, Nebraska, United States\n",
      "Lovell, Maine, United States\n",
      "Lovettsville\n",
      "Lubbock, Texas, United States\n",
      "Lubec, Maine, United States\n",
      "Lyons, Colorado, United States\n",
      "Mt. Shasta, California, United States\n",
      "Mt. Laurel, New Jersey, United States\n",
      "Madison, Wisconsin, United States\n",
      "Manchester, Vermont, United States\n",
      "Mankato, Minnesota, United States\n",
      "Marfa, Texas, United States\n",
      "Martha's Vineyard, Massachusetts, United States\n",
      "Marquette, Michigan, United States\n",
      "Marshall, Minnesota, United States\n",
      "Maryville, Illinois, United States\n",
      "McCall, Idaho, United States\n",
      "McMinnville, Oregon, United States\n",
      "Melbourne/Brevard County, Florida, United States\n",
      "Memphis, Tennessee, United States\n",
      "Menomonie, Wisconsin, United States\n",
      "Mentone, Alabama, United States\n",
      "Miami, Florida, United States\n",
      "Midland, Michigan, United States\n",
      "Midland, Texas, United States\n",
      "Midway Atoll\n",
      "Miles City, Montana, United States\n",
      "Milford, Connecticut, United States\n",
      "Milhelm, Pennsylvania, United States\n",
      "Milwaukee, Wisconsin, United States\n",
      "Minocqua, Wisconsin, United States\n",
      "Minturn, Colorado, United States\n",
      "Missoula, Montana, United States\n",
      "Mitchell, Indiana, United States\n",
      "Moab, Utah, United States\n",
      "Mobile, Alabama, United States\n",
      "Modesto, California, United States\n",
      "Mooresville, North Carolina, United States\n",
      "Monhegan Island\n",
      "Montpelier, Vermont, United States\n",
      "Mora, New Mexico, United States\n",
      "Morganton, North Carolina, United States\n",
      "Morris, Minnesota, United States\n",
      "Moscow, Idaho, United States\n",
      "Mount Vernon, Ohio, United States\n",
      "Mount Vernon, Washington, United States\n",
      "Murray, Kentucky, United States\n",
      "Nacogdoches, Texas, United States\n",
      "Nantucket, Massachusetts, United States\n",
      "Napa, California, United States\n",
      "Naples, Florida, United States\n",
      "Nashville, Tennessee, United States\n",
      "Nebraska City, Nebraska, United States\n",
      "Nederland, Colorado, United States\n",
      "Nevada City, California, United States\n",
      "New Bern, North Carolina, United States\n",
      "New Haven, Connecticut, United States\n",
      "New Orleans, Louisiana, United States\n",
      "New Smyrna Beach, Florida, United States\n",
      "New York, New York, United States\n",
      "Newark, Delaware, United States\n",
      "Newark, New Jersey, United States\n",
      "Newport, Oregon, United States\n",
      "Nome, Alaska, United States\n",
      "Norfolk, Virginia, United States\n",
      "Northampton, Massachusetts, United States\n",
      "Oak Ridge, Tennessee, United States\n",
      "Oakhurst, California, United States\n",
      "Oakland, California, United States\n",
      "Ocala, Florida, United States\n",
      "Ocean City, Maryland, United States\n",
      "Ocean Shores, Washington, United States\n",
      "Ocracoke, North Carolina, United States\n",
      "Ogden, Utah, United States\n",
      "Oklahoma City, Oklahoma, United States\n",
      "Old Saybrook, Connecticut, United States\n",
      "Olympia, Washington, United States\n",
      "Omaha, Nebraska, United States\n",
      "Oneonta, New York, United States\n",
      "Onley, Virginia, United States\n",
      "Ontario, California, United States\n",
      "Orcas Island, Washington, United States\n",
      "Orford, New Hampshire, United States\n",
      "Orlando, Florida, United States\n",
      "Owensboro, Kentucky, United States\n",
      "Oxford, Mississippi, United States\n",
      "Pacifica, California, United States\n",
      "Palm Desert, California, United States\n",
      "Palm Springs, California, United States\n",
      "Palmdale, California, United States\n",
      "Palmer, Alaska, United States\n",
      "Paradox, New York, United States\n",
      "Park City, Utah, United States\n",
      "Panama City, Florida, United States\n",
      "Paoli, Indiana, United States\n",
      "Paonia, Colorado, United States\n",
      "Pasadena, California, United States\n",
      "Pence, Wisconsin, United States\n",
      "Pendelton, Oregon, United States\n",
      "Pensacola, Florida, United States\n",
      "Pentwater, Michigan, United States\n",
      "Peoria, Illinois, United States\n",
      "Pequannock Township, New Jersey, United States\n",
      "Peterborough, New Hampshire, United States\n",
      "Petersburg, Alaska, United States\n",
      "Philadelphia, Pennsylvania, United States\n",
      "Phoenix, Arizona, United States\n",
      "Pierre, South Dakota, United States\n",
      "Pikeville, Kentucky, United States\n",
      "Pinedale, Wyoming, United States\n",
      "Pittsburgh, Pennsylvania, United States\n",
      "Pittsfield, Massachusetts, United States\n",
      "Plattsburgh, New York, United States\n",
      "Plymouth, Wisconsin, United States\n",
      "Pocatello, Idaho, United States\n",
      "Point Reyes Station, California, United States\n",
      "Port Angeles, Washington, United States\n",
      "Port Jefferson, New York, United States\n",
      "Port Jervis, New York, United States\n",
      "Port Orford, Oregon, United States\n",
      "Port Townsend, Washington, United States\n",
      "Portales, New Mexico, United States\n",
      "Portland, Maine, United States\n",
      "Portland, Oregon, United States\n",
      "Portland, OR area\n",
      "Portsmouth, New Hampshire, United States\n",
      "Potsdam, New York, United States\n",
      "Poughkeepsie, New York, United States\n",
      "Prescott, Arizona, United States\n",
      "Providence, Rhode Island, United States\n",
      "Provincetown, Massachusetts, United States\n",
      "Quincy, California, United States\n",
      "Raleigh, North Carolina, United States\n",
      "Rapid City, South Dakota, United States\n",
      "Reading, Pennsylvania, United States\n",
      "Red Bank, New Jersey, United States\n",
      "Redding, California, United States\n",
      "Redondo Beach, California, United States\n",
      "Redwood City, California, United States\n",
      "Reno, Nevada, United States\n",
      "Richland, Washington, United States\n",
      "Richmond, Virginia, United States\n",
      "Ridgecrest, California, United States\n",
      "Ridgway, Colorado, United States\n",
      "Riegelsville, Pennsylvania, United States\n",
      "Riverside, California, United States\n",
      "Roanoke, Virginia, United States\n",
      "Rochester, Minnesota, United States\n",
      "Rochester, New York, United States\n",
      "Rock Springs, Wyoming, United States\n",
      "Rockford, Illinois, United States\n",
      "Romney, West Virginia, United States\n",
      "Roswell, New Mexico, United States\n",
      "Roxbury, Connecticut, United States\n",
      "St. Augustine, Florida, United States\n",
      "St. Cloud, Minnesota, United States\n",
      "St. Croix, Virgin Islands, United States\n",
      "St. George, Utah, United States\n",
      "St. John, Virgin Islands, United States\n",
      "St. Johnsbury, Vermont, United States\n",
      "St. Joseph, Michigan, United States\n",
      "St. Louis, Missouri, United States\n",
      "St. Mary's City, Maryland, United States\n",
      "St. Mary of the Woods, Indiana, United States\n",
      "St. Paul/Minneapolis, Minnesota, United States\n",
      "St. Petersburg, Florida, United States\n",
      "Sacramento, California, United States\n",
      "Sag Harbor, New York, United States\n",
      "Salem, Oregon, United States\n",
      "Salem, Wisconsin, United States\n",
      "Salida, Colorado, United States\n",
      "Salinas, California, United States\n",
      "Salisbury, Connecticut, United States\n",
      "Salt Lake City, UT (1/20)\n",
      "Salt Lake City, UT (1/23)\n",
      "San Anselmo, California, United States\n",
      "San Antonio, Texas, United States\n",
      "San Bernardino, California, United States\n",
      "San Clemente, California, United States\n",
      "San Diego, California, United States\n",
      "San Francisco, California, United States\n",
      "San Jose, California, United States\n",
      "San Juan, Puerto Rico, United States\n",
      "San Luis Obispo, California, United States\n",
      "San Marcos, California, United States\n",
      "San Rafael, California, United States\n",
      "Sanford, Maine, United States\n",
      "Sandpoint, Idaho, United States\n",
      "Santa Ana, California, United States\n",
      "Santa Barbara, California, United States\n",
      "Santa Cruz, California, United States\n",
      "Santa Fe, New Mexico, United States\n",
      "Santa Rosa, California, United States\n",
      "Sarasota, Florida, United States\n",
      "Saugatuck, Michigan, United States\n",
      "Sault Ste Marie, Michigan, United States\n",
      "Sausalito, California, United States\n",
      "Savannah, Georgia, United States\n",
      "Saxaphaw, North Carolina, United States\n",
      "Seaside, California, United States\n",
      "Seattle, Washington, United States\n",
      "Sedona, Arizona, United States\n",
      "Seldovia, Alaska, United States\n",
      "Selingsgrove, Pennsylvania, United States\n",
      "Seneca Falls, New York, United States\n",
      "Sequim, Washington, United States\n",
      "Seward, Alaska, United States\n",
      "Sharon, Pennsylvania, United States\n",
      "Sheboygan, Wisconsin, United States\n",
      "Show Low, Arizona, United States\n",
      "Shreveport/Bossier, Louisiana, United States\n",
      "Sicklerville, New Jersey, United States\n",
      "Silver City, New Mexico, United States\n",
      "Silverton, Colorado, United States\n",
      "Sioux Falls, South Dakota, United States\n",
      "Sitka, Alaska, United States\n",
      "Skagway, Alaska, United States\n",
      "Skykomish, Washington, United States\n",
      "Soldotna, Alaska, United States\n",
      "Sonoma, California, United States\n",
      "South Bend, Indiana, United States\n",
      "South Lake Tahoe, CA / Stateline, Nevada, United States\n",
      "South Orange, New Jersey, United States\n",
      "Southborough, Massachusetts, United States\n",
      "Spokane, Washington, United States\n",
      "Springfield, Illinois, United States\n",
      "Springfield, Massachusetts, United States\n",
      "Springfield, Missouri, United States\n",
      "Springfield, Ohio, United States\n",
      "Stamford, Connecticut, United States\n",
      "Stanley, Idaho, United States\n",
      "State College, Pennsylvania, United States\n",
      "Statesboro, Georgia, United States\n",
      "Staunton, Virginia, United States\n",
      "Steamboat Springs, Colorado, United States\n",
      "Syracuse, New York, United States\n",
      "Talkeetna, Alaska, United States\n",
      "Tallahassee, Florida, United States\n",
      "Taos, New Mexico, United States\n",
      "Tecumseh, Michigan, United States\n",
      "Telluride, Colorado, United States\n",
      "Tenants Harbor, Maine, United States\n",
      "The Dalles, Oregon, United States\n",
      "Tillamook, Oregon, United States\n",
      "Tisbury, Massachusetts, United States\n",
      "Toledo, Ohio, United States\n",
      "Topeka, Kansas, United States\n",
      "Traverse City, Michigan, United States\n",
      "Trenton, New Jersey, United States\n",
      "Troy, Ohio, United States\n",
      "Troy, Pennsylvania, United States\n",
      "Truckee, California, United States\n",
      "Truth or Consequences, New Mexico, United States\n",
      "Tucson, Arizona, United States\n",
      "Tulsa, Oklahoma, United States\n",
      "Tupper Lake, New York, United States\n",
      "Tuscarora, Nevada, United States\n",
      "Twisp, Washington, United States\n",
      "Ukiah, California, United States\n",
      "Unalakleet, Alaska, United States\n",
      "Unalaska (Dutch Harbor)\n",
      "Union, Washington, United States\n",
      "University Park, Maryland, United States\n",
      "Utica, New York, United States\n",
      "Utqiagvik (Barrow), Alaska, United States\n",
      "Valdez, Alaska, United States\n",
      "Vallejo, California, United States\n",
      "Valparaiso, Indiana, United States\n",
      "Vancouver, Washington, United States\n",
      "Vashon, Washington, United States\n",
      "Ventura, California, United States\n",
      "Vermillion, South Dakota, United States\n",
      "Vienna, Virginia, United States\n",
      "Vieques, Puerto Rico, United States\n",
      "Vinalhaven, Maine, United States\n",
      "Visalia, California, United States\n",
      "Walla Walla, Washington, United States\n",
      "Walnut Creek, California, United States\n",
      "Washington DC\n",
      "Watertown, New York, United States\n",
      "Watsonville, California, United States\n",
      "Wausau, Wisconsin, United States\n",
      "Wellfleet, Massachusetts, United States\n",
      "Wenatchee, Washington, United States\n",
      "West Chester, Pennsylvania, United States\n",
      "West Jefferson, North Carolina, United States\n",
      "West Lima, Wisconsin, United States\n",
      "West Palm Beach, Florida, United States\n",
      "Westfield, New Jersey, United States\n",
      "Westwood, California, United States\n",
      "Wichita, Kansas, United States\n",
      "Wichita Falls, Texas, United States\n",
      "Williamsburg, Virginia, United States\n",
      "Willits, California, United States\n",
      "Wilmington, North Carolina, United States\n",
      "Wilmington, Ohio, United States\n",
      "Wilton, New Hampshire, United States\n",
      "Winchester, Virginia, United States\n",
      "Winters, California, United States\n",
      "Women's March Online\n",
      "Woods Hole, Massachusetts, United States\n",
      "Woodstock, New York, United States\n",
      "Woodstock, Virginia, United States\n",
      "Wooster, Ohio, United States\n",
      "Wyckoff, New Jersey, United States\n",
      "Yakima, Washington, United States\n",
      "Yellow Springs, Ohio, United States\n",
      "Ypsilanti, Michigan, United States\n",
      "Yucca Valley, California, United States\n",
      "Yuma, Arizona, United States\n",
      "Zebulon, Georgia, United States\n",
      "Abqaiq, Saudi Arabia\n",
      "Accra, Ghana\n",
      "Ajijic, Mexico\n",
      "Alamos\n",
      "Amsterdam, Netherlands\n",
      "Antigua, Guatemala\n",
      "Åre, Sweden\n",
      "Asuncion, Paraguay\n",
      "Athens, Greece\n",
      "Auckland, New Zealand\n",
      "Auvillar\n",
      "Bangkok, Thailand\n",
      "Bangor, Wales, UK\n",
      "Barcelona, Spain\n",
      "Barnstaple, England\n",
      "Beijing, China\n",
      "Beirut\n",
      "Belfast, UK\n",
      "Belgrade, Serbia\n",
      "Bergen, Norway\n",
      "Berlin, Germany\n",
      "Bogota, Colombia\n",
      "Bonn\n",
      "Bordeaux\n",
      "Botswana\n",
      "Bowen Island, BC\n",
      "Braga\n",
      "Brasilia, Brazil\n",
      "Bremen, Germany\n",
      "Bremerhaven, Germany\n",
      "Blantyre, Malawi\n",
      "Brisbane, Australia\n",
      "Bristol, UK\n",
      "Brussels\n",
      "Bucharest, Romania\n",
      "Budapest, Hungary\n",
      "Buenos Aires, Argentina\n",
      "Calgary, Canada\n",
      "Canberra, Australia\n",
      "Cape Town, South Africa\n",
      "Cardiff, Wales\n",
      "Castlebar, Ireland\n",
      "Castlegar, BC\n",
      "Charlestown\n",
      "Charlottetown, PEI, Canada\n",
      "Chennai, India\n",
      "Chiang Mai, Thailand\n",
      "Christchurch, New Zealand\n",
      "Coimbra\n",
      "Copenhagen, Denmark\n",
      "Courtenay, BC\n",
      "Cuenca, Ecuador\n",
      "Da Nang, Vietnam\n",
      "Dar Es Salaam, Tanzania\n",
      "Dili\n",
      "Doha\n",
      "Dublin, Ireland\n",
      "Dunedin, New Zealand\n",
      "Durban\n",
      "Dusseldorf\n",
      "Edinburgh, Scotland\n",
      "Edmonton, Canada\n",
      "El Sargento\n",
      "Erbil, Iraq\n",
      "Florence, Italy\n",
      "Frankfurt, Germany\n",
      "Freeport, Bahamas\n",
      "Fredericton, NB\n",
      "Gabriola, BC\n",
      "Galway, Ireland\n",
      "Gdansk\n",
      "Geneva, Switzerland\n",
      "Georgetown, Grand Cayman\n",
      "Goatfell Mountain, Isle of Arran, Scotland\n",
      "Granada\n",
      "Grand Forks, BC\n",
      "Guelph, ON, Canada\n",
      "The Hague, The Netherlands\n",
      "Halifax, NS, Canada\n",
      "Hamburg, Germany\n",
      "Hamilton, Bermuda\n",
      "Hamilton, ON, Canada\n",
      "Hanoi, Vietnam\n",
      "Harare\n",
      "Heidelberg\n",
      "Helsinki, Finland\n",
      "Ho Chi Minh City\n",
      "Huntsville, Ontario, Canada\n",
      "Isla Mujeres, Mexico\n",
      "Isle of Eigg\n",
      "Jaipur\n",
      "Jos, Nigeria\n",
      "Kamloops, BC\n",
      "Kampala\n",
      "Kassel, Germany\n",
      "Kelowna, BC\n",
      "Kigali\n",
      "Kingston, ON, Canada\n",
      "Kinshasa\n",
      "Kolonia, Pohnpei\n",
      "Kootenay Bay, BC\n",
      "Krakow\n",
      "Kralendijk, Caribbean Netherlands\n",
      "La Manzanilla, Jalisco\n",
      "La Ventana, Baja California Sur\n",
      "Lancaster, England\n",
      "Leeds, England\n",
      "Leipzig\n",
      "Lerwick, Scotland\n",
      "Lethbridge, AB\n",
      "Lilongwe, Malawi\n",
      "Lima\n",
      "Lisbon, Portugal\n",
      "Liverpool, UK\n",
      "Ljubljana\n",
      "London, Ontario, Canada.\n",
      "London, UK\n",
      "Lusaka, Zambia\n",
      "Lyon, France\n",
      "Maadi Degla, Cairo, Egypt\n",
      "Madrid, Spain\n",
      "Managua, Nicaragua\n",
      "Manchester, England\n",
      "Manutoulin Island, Ontario, Canada\n",
      "Marseilles, France\n",
      "Mazatlan\n",
      "Melaque, Jalisco\n",
      "Melbourne, Australia\n",
      "Merida\n",
      "Mexico City, Mexico\n",
      "Milan\n",
      "Monrovia, Liberia\n",
      "Montebello, Quebec\n",
      "Monteverde, Puntarenas\n",
      "Montpellier, France\n",
      "Montreal, Canada\n",
      "Montverde\n",
      "Moscow, Russia\n",
      "Munich, Germany\n",
      "Mwanza, Tanzania\n",
      "Nairobi, Kenya\n",
      "Nanaimo, BC\n",
      "New Delhi, India\n",
      "Nice, France\n",
      "North West River, Labrador, Canada\n",
      "Nosara, Costa Rica\n",
      "Oaxaca de Juarez, Oaxaca\n",
      "Okarito\n",
      "Oranjestad, Aruba\n",
      "Osaka, Japan\n",
      "Oshakati, Namibia\n",
      "Oslo, Norway\n",
      "Ottawa, Canada\n",
      "Paris, France\n",
      "Paradise Bay, Antarctica\n",
      "Pender Island, BC, Canada\n",
      "Phnom Penh, Cambodia\n",
      "Playa Del Carmen\n",
      "Poitiers\n",
      "Portillo, Chile\n",
      "Porto, Portugal\n",
      "Potrero\n",
      "Prague, Czech Republic\n",
      "Prince George, BC\n",
      "Pristina, Kosovo\n",
      "Puerto Vallarta, Jalisco\n",
      "Quebec City, QC\n",
      "Quito, Ecuador\n",
      "Rabat, Morocco\n",
      "Revelstoke, BC\n",
      "Reykjavik, Iceland\n",
      "Riga, Latvia\n",
      "Rio de Janeiro, Brazil\n",
      "Riva Views\n",
      "Roberts Creek, BC\n",
      "Rome, Italy\n",
      "Salmon Arm, BC\n",
      "Salt Spring Island, Canada\n",
      "San Jose, Costa Rica\n",
      "San Miguel de Allende, Mexico!\n",
      "San Pancho (San Francisco), Nayarit, Mexico\n",
      "Sandy Cove, NS\n",
      "Santiago, Chile\n",
      "Saskatoon, Canada\n",
      "Seoul, South Korea\n",
      "Seyðisfjörður, Iceland\n",
      "Shipley, UK\n",
      "Singapore\n",
      "Sligo, Ireland\n",
      "Sofia\n",
      "Sointula, BC\n",
      "Songdo, South Korea\n",
      "Southampton, England\n",
      "Squirrel Camp/Kloo Lake, Yukon\n",
      "St. Austell, England\n",
      "St. Catherine's, Ontario\n",
      "St. John, NB \n",
      "St. John's, Newfoundland\n",
      "Stavanger, Norway\n",
      "Stockholm, Sweden\n",
      "Strasbourg, Alsace\n",
      "Stratford, Ontario\n",
      "Sutton, Quebec\n",
      "Suva\n",
      "Sydney, Australia\n",
      "Taipa, Macau\n",
      "Tbilisi, Georgia\n",
      "Tel Aviv, Israel\n",
      "Thessoloniki\n",
      "Todos Santos\n",
      "Tokyo, Japan\n",
      "Toronto, Canada\n",
      "Toulouse, France\n",
      "Trondheim, Norway\n",
      "Ubud, Bali\n",
      "Uvita\n",
      "Vancouver, Canada\n",
      "Vicenza\n",
      "Victoria, Canada\n",
      "Vienna, Austria\n",
      "Vientiane\n",
      "Vilnius, Lithuania\n",
      "Warsaw\n",
      "Wellington, New Zealand\n",
      "Whitehorse, Canada\n",
      "Whitehorse, Yukon, Canada\n",
      "Winnipeg, Canada\n",
      "Wolfville, NS, Canada\n",
      "Xcalak\n",
      "Yangon\n",
      "Yellowknife, NWT, Canada\n",
      "York, England\n",
      "Surama\n",
      "Zacatitos\n",
      "Zihuatanejo\n",
      "Birmingham, Alabama, United States\n",
      "Helena, Arkansas, United States\n",
      "Milhelm, Pennsylvania, United States\n",
      "Women's March Online\n",
      "Squirrel Camp/Kloo Lake, Yukon\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>place</th>\n",
       "      <th>state</th>\n",
       "      <th>country</th>\n",
       "      <th>estimate_low</th>\n",
       "      <th>estimate_high</th>\n",
       "      <th>source</th>\n",
       "      <th>source2</th>\n",
       "      <th>source3</th>\n",
       "      <th>full_place</th>\n",
       "      <th>latlng</th>\n",
       "      <th>lng</th>\n",
       "      <th>lat</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Abilene, TX</td>\n",
       "      <td>TX</td>\n",
       "      <td>US</td>\n",
       "      <td>200.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>http://www.reporternews.com/story/news/local/2...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Abilene, Texas, United States</td>\n",
       "      <td>Abilene, TX</td>\n",
       "      <td>-99.733144</td>\n",
       "      <td>32.448736</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Accident, MD</td>\n",
       "      <td>MD</td>\n",
       "      <td>US</td>\n",
       "      <td>54.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>http://www.riverfronttimes.com/newsblog/2017/0...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Twitter; on-site witness</td>\n",
       "      <td>Accident, Maryland, United States</td>\n",
       "      <td>Accident, MD</td>\n",
       "      <td>-79.319759</td>\n",
       "      <td>39.628696</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Adak, AK</td>\n",
       "      <td>AK</td>\n",
       "      <td>US</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>adn.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Adak, Alaska, United States</td>\n",
       "      <td>Adak, AK</td>\n",
       "      <td>-176.658056</td>\n",
       "      <td>51.880000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Adrian, MI</td>\n",
       "      <td>MI</td>\n",
       "      <td>US</td>\n",
       "      <td>150.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>http://www.lenconnect.com/news/20170122/marche...</td>\n",
       "      <td>http://www.lenconnect.com/news/20170122/marche...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Adrian, Michigan, United States</td>\n",
       "      <td>Adrian, MI</td>\n",
       "      <td>-84.037166</td>\n",
       "      <td>41.897547</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ajo, AZ</td>\n",
       "      <td>AZ</td>\n",
       "      <td>US</td>\n",
       "      <td>250.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>https://www.facebook.com/plugins/post.php?href...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ajo, Arizona, United States</td>\n",
       "      <td>Ajo, AZ</td>\n",
       "      <td>-112.860710</td>\n",
       "      <td>32.371725</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Alameda, CA</td>\n",
       "      <td>CA</td>\n",
       "      <td>US</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>FB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alameda, California, United States</td>\n",
       "      <td>Alameda, CA</td>\n",
       "      <td>-122.241636</td>\n",
       "      <td>37.765206</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Alamosa, CO</td>\n",
       "      <td>CO</td>\n",
       "      <td>US</td>\n",
       "      <td>350.0</td>\n",
       "      <td>350.0</td>\n",
       "      <td>https://twitter.com/zepol/status/8232349739352...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alamosa, Colorado, United States</td>\n",
       "      <td>Alamosa, CO</td>\n",
       "      <td>-105.870021</td>\n",
       "      <td>37.469449</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Albany, CA</td>\n",
       "      <td>CA</td>\n",
       "      <td>US</td>\n",
       "      <td>500.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>https://twitter.com/ben_silverman/status/82303...</td>\n",
       "      <td>Albany PD (reported via google form)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Albany, California, United States</td>\n",
       "      <td>Albany, CA</td>\n",
       "      <td>-122.297747</td>\n",
       "      <td>37.886870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Albany, NY</td>\n",
       "      <td>NY</td>\n",
       "      <td>US</td>\n",
       "      <td>7000.0</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>http://www.timesunion.com/local/article/Albany...</td>\n",
       "      <td>FB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Albany, New York, United States</td>\n",
       "      <td>Albany, NY</td>\n",
       "      <td>-73.756232</td>\n",
       "      <td>42.652579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Alexandria, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>US</td>\n",
       "      <td>17.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>https://twitter.com/TinaPStacy/status/82322604...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alexandria, Virginia, United States</td>\n",
       "      <td>Alexandria, VA</td>\n",
       "      <td>-77.046921</td>\n",
       "      <td>38.804836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Albuquerque, NM</td>\n",
       "      <td>NM</td>\n",
       "      <td>US</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>http://www.koat.com/article/thousands-fill-civ...</td>\n",
       "      <td>https://twitter.com/PatDavisNM/status/82293149...</td>\n",
       "      <td>https://twitter.com/AthertonKD/status/82321516...</td>\n",
       "      <td>Albuquerque, New Mexico, United States</td>\n",
       "      <td>Albuquerque, NM</td>\n",
       "      <td>-106.605553</td>\n",
       "      <td>35.085334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Alliance, NE</td>\n",
       "      <td>NE</td>\n",
       "      <td>US</td>\n",
       "      <td>100.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>eyewtiness onsite w/ headcount</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alliance, Nebraska, United States</td>\n",
       "      <td>Alliance, NE</td>\n",
       "      <td>-102.870201</td>\n",
       "      <td>42.093024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Almanor West, CA</td>\n",
       "      <td>CA</td>\n",
       "      <td>US</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>eyewitness; picture</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Almanor West, California, United States</td>\n",
       "      <td>Almanor West, CA</td>\n",
       "      <td>-121.202534</td>\n",
       "      <td>40.234637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Alpine, TX</td>\n",
       "      <td>TX</td>\n",
       "      <td>US</td>\n",
       "      <td>96.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>https://twitter.com/sarahmvasquez/status/82318...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alpine, Texas, United States</td>\n",
       "      <td>Alpine, TX</td>\n",
       "      <td>-103.661012</td>\n",
       "      <td>30.358492</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Amarillo, TX</td>\n",
       "      <td>TX</td>\n",
       "      <td>US</td>\n",
       "      <td>600.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>https://www.texastribune.org/2017/01/21/thousa...</td>\n",
       "      <td>http://www.myhighplains.com/news/hundreds-gath...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Amarillo, Texas, United States</td>\n",
       "      <td>Amarillo, TX</td>\n",
       "      <td>-101.831297</td>\n",
       "      <td>35.221997</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Amelia Island, FL</td>\n",
       "      <td>FL</td>\n",
       "      <td>US</td>\n",
       "      <td>700.0</td>\n",
       "      <td>1367.0</td>\n",
       "      <td>http://www.firstcoastnews.com/news/womens-marc...</td>\n",
       "      <td>https://twitter.com/wideofthepost/status/82307...</td>\n",
       "      <td>http://www.ncflindependent.com/2017/01/21/stan...</td>\n",
       "      <td>Amelia Island, Florida, United States</td>\n",
       "      <td>Amelia Island, FL</td>\n",
       "      <td>-81.460856</td>\n",
       "      <td>30.626570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Anacortes, WA</td>\n",
       "      <td>WA</td>\n",
       "      <td>US</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>http://www.goskagit.com/skagit/hundreds-partic...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Anacortes, Washington, United States</td>\n",
       "      <td>Anacortes, WA</td>\n",
       "      <td>-122.612672</td>\n",
       "      <td>48.512604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Anchorage, AK</td>\n",
       "      <td>AK</td>\n",
       "      <td>US</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>https://www.adn.com/alaska-news/2017/01/21/lar...</td>\n",
       "      <td>https://twitter.com/julia_omalley/status/82290...</td>\n",
       "      <td>http://www.ktuu.com/content/news/Thousands-of-...</td>\n",
       "      <td>Anchorage, Alaska, United States</td>\n",
       "      <td>Anchorage, AK</td>\n",
       "      <td>-149.900278</td>\n",
       "      <td>61.218056</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Angola, IN</td>\n",
       "      <td>IN</td>\n",
       "      <td>US</td>\n",
       "      <td>24.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>http://wane.com/2017/01/21/womens-marches-in-a...</td>\n",
       "      <td>http://kpcnews.com/news/latest/heraldrepublican/</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Angola, Indiana, United States</td>\n",
       "      <td>Angola, IN</td>\n",
       "      <td>-84.999409</td>\n",
       "      <td>41.634773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Ann Arbor, MI</td>\n",
       "      <td>MI</td>\n",
       "      <td>US</td>\n",
       "      <td>11000.0</td>\n",
       "      <td>11000.0</td>\n",
       "      <td>http://www.mlive.com/news/ann-arbor/index.ssf/...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ann Arbor, Michigan, United States</td>\n",
       "      <td>Ann Arbor, MI</td>\n",
       "      <td>-83.743038</td>\n",
       "      <td>42.280826</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Annapolis, MD</td>\n",
       "      <td>MD</td>\n",
       "      <td>US</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>http://www.capitalgazette.com/news/annapolis/p...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Annapolis, Maryland, United States</td>\n",
       "      <td>Annapolis, MD</td>\n",
       "      <td>-76.492183</td>\n",
       "      <td>38.978445</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Annville, PA</td>\n",
       "      <td>PA</td>\n",
       "      <td>US</td>\n",
       "      <td>30.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>http://www.ldnews.com/videos/news/2017/01/21/w...</td>\n",
       "      <td>onsite eyewitness via google form</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Annville, Pennsylvania, United States</td>\n",
       "      <td>Annville, PA</td>\n",
       "      <td>-76.515244</td>\n",
       "      <td>40.329536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Appleton, WI</td>\n",
       "      <td>WI</td>\n",
       "      <td>US</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>http://www.sheboyganpress.com/story/news/local...</td>\n",
       "      <td>http://www.postcrescent.com/story/news/local/2...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Appleton, Wisconsin, United States</td>\n",
       "      <td>Appleton, WI</td>\n",
       "      <td>-88.415385</td>\n",
       "      <td>44.261931</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Arden, DE</td>\n",
       "      <td>DE</td>\n",
       "      <td>US</td>\n",
       "      <td>40.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>onsite eyewitness via google form; did headcount</td>\n",
       "      <td>FB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Arden, Delaware, United States</td>\n",
       "      <td>Arden, DE</td>\n",
       "      <td>-75.486587</td>\n",
       "      <td>39.809279</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Asbury Park, NJ</td>\n",
       "      <td>NJ</td>\n",
       "      <td>US</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>https://twitter.com/JuliaJHobbs/status/8229551...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Asbury Park, New Jersey, United States</td>\n",
       "      <td>Asbury Park, NJ</td>\n",
       "      <td>-74.012082</td>\n",
       "      <td>40.220391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Asheville, NC</td>\n",
       "      <td>NC</td>\n",
       "      <td>US</td>\n",
       "      <td>7000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>http://wlos.com/news/local/photo-gallery-the-w...</td>\n",
       "      <td>http://wlos.com/news/local/photo-gallery-the-w...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Asheville, North Carolina, United States</td>\n",
       "      <td>Asheville, NC</td>\n",
       "      <td>-82.551487</td>\n",
       "      <td>35.595058</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Ashland, OR</td>\n",
       "      <td>OR</td>\n",
       "      <td>US</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>http://www.oregonlive.com/trending/2017/01/wom...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ashland, Oregon, United States</td>\n",
       "      <td>Ashland, OR</td>\n",
       "      <td>-122.709477</td>\n",
       "      <td>42.194576</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Aspen, CO</td>\n",
       "      <td>CO</td>\n",
       "      <td>US</td>\n",
       "      <td>200.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>http://www.aspendailynews.com/section/home/174009</td>\n",
       "      <td>https://twitter.com/SarahGoTrillIum/status/823...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Aspen, Colorado, United States</td>\n",
       "      <td>Aspen, CO</td>\n",
       "      <td>-106.817539</td>\n",
       "      <td>39.191098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Astoria, OR</td>\n",
       "      <td>OR</td>\n",
       "      <td>US</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>http://www.dailyastorian.com/Local_News/201701...</td>\n",
       "      <td>http://www.kast1370.com/index.php?option=com_c...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Astoria, Oregon, United States</td>\n",
       "      <td>Astoria, OR</td>\n",
       "      <td>-123.831253</td>\n",
       "      <td>46.187884</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Athens, GA</td>\n",
       "      <td>GA</td>\n",
       "      <td>US</td>\n",
       "      <td>700.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>http://onlineathens.com/slideshow/2017-01-21/p...</td>\n",
       "      <td>FB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Athens, Georgia, United States</td>\n",
       "      <td>Athens, GA</td>\n",
       "      <td>-83.357567</td>\n",
       "      <td>33.951935</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>906</th>\n",
       "      <td>Taipa, Macau</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Macau</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>http://aamacau.com/2017/01/22/%E9%9F%BF%E6%87%...</td>\n",
       "      <td>http://www.macaupostdaily.com/article2236.html</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Taipa, Macau</td>\n",
       "      <td>Taipa, Macau</td>\n",
       "      <td>113.563922</td>\n",
       "      <td>22.159685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>907</th>\n",
       "      <td>Tbilisi, Georgia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>300.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>http://dfwatch.net/tbilisi-joins-global-womens...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tbilisi, Georgia</td>\n",
       "      <td>Tbilisi, Georgia</td>\n",
       "      <td>44.827096</td>\n",
       "      <td>41.715138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>908</th>\n",
       "      <td>Tel Aviv, Israel</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Israel</td>\n",
       "      <td>300.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>on site report with crowd-counting via flyer d...</td>\n",
       "      <td>https://twitter.com/melanielidman/status/82287...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tel Aviv, Israel</td>\n",
       "      <td>Tel Aviv, Israel</td>\n",
       "      <td>34.781768</td>\n",
       "      <td>32.085300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>909</th>\n",
       "      <td>Thessoloniki</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Greece</td>\n",
       "      <td>36.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>http://www.centralctcommunications.com/newbrit...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Thessoloniki</td>\n",
       "      <td>Thessoloniki</td>\n",
       "      <td>22.944419</td>\n",
       "      <td>40.640063</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>910</th>\n",
       "      <td>Todos Santos</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>200.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>onsite eyewitness</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Todos Santos</td>\n",
       "      <td>Todos Santos</td>\n",
       "      <td>-110.226510</td>\n",
       "      <td>23.446362</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>911</th>\n",
       "      <td>Tokyo, Japan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Japan</td>\n",
       "      <td>648.0</td>\n",
       "      <td>648.0</td>\n",
       "      <td>http://www.elle.com/culture/career-politics/ne...</td>\n",
       "      <td>https://www.facebook.com/events/37355156635747...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tokyo, Japan</td>\n",
       "      <td>Tokyo, Japan</td>\n",
       "      <td>139.691706</td>\n",
       "      <td>35.689487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>912</th>\n",
       "      <td>Toronto, Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>60000.0</td>\n",
       "      <td>https://www.thestar.com/news/gta/2017/01/21/ev...</td>\n",
       "      <td>http://globalnews.ca/news/3197235/60000-people...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Toronto, Canada</td>\n",
       "      <td>Toronto, Canada</td>\n",
       "      <td>-79.383184</td>\n",
       "      <td>43.653226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>913</th>\n",
       "      <td>Toulouse, France</td>\n",
       "      <td>NaN</td>\n",
       "      <td>France</td>\n",
       "      <td>200.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>FB group</td>\n",
       "      <td>onsite eyewitness</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Toulouse, France</td>\n",
       "      <td>Toulouse, France</td>\n",
       "      <td>1.444209</td>\n",
       "      <td>43.604652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>914</th>\n",
       "      <td>Trondheim, Norway</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Norway</td>\n",
       "      <td>260.0</td>\n",
       "      <td>280.0</td>\n",
       "      <td>http://www.adressa.no/nyheter/trondheim/2017/0...</td>\n",
       "      <td>http://www.adressa.no/nyheter/trondheim/2017/0...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Trondheim, Norway</td>\n",
       "      <td>Trondheim, Norway</td>\n",
       "      <td>10.395053</td>\n",
       "      <td>63.430515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>917</th>\n",
       "      <td>Ubud, Bali</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>95.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>FB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ubud, Bali</td>\n",
       "      <td>Ubud, Bali</td>\n",
       "      <td>115.264379</td>\n",
       "      <td>-8.507808</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>918</th>\n",
       "      <td>Uvita</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Costa Rica</td>\n",
       "      <td>18.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>Eyewitness report; photographic evidence</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Uvita</td>\n",
       "      <td>Uvita</td>\n",
       "      <td>-83.735851</td>\n",
       "      <td>9.163501</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>919</th>\n",
       "      <td>Vancouver, Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>http://www.cbc.ca/news/canada/british-columbia...</td>\n",
       "      <td>FB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Vancouver, Canada</td>\n",
       "      <td>Vancouver, Canada</td>\n",
       "      <td>-123.120738</td>\n",
       "      <td>49.282729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>920</th>\n",
       "      <td>Vicenza</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Italy</td>\n",
       "      <td>25.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>FB photo confirming headcount</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Vicenza</td>\n",
       "      <td>Vicenza</td>\n",
       "      <td>11.535421</td>\n",
       "      <td>45.545479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>921</th>\n",
       "      <td>Victoria, Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>http://www.timescolonist.com/news/local/women-...</td>\n",
       "      <td>https://www.facebook.com/isitt/posts/101580065...</td>\n",
       "      <td>http://www.cbc.ca/beta/news/canada/british-col...</td>\n",
       "      <td>Victoria, Canada</td>\n",
       "      <td>Victoria, Canada</td>\n",
       "      <td>-123.365644</td>\n",
       "      <td>48.428421</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>922</th>\n",
       "      <td>Vienna, Austria</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Austria</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>FB</td>\n",
       "      <td>http://www.usatoday.com/story/news/2017/01/21/...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Vienna, Austria</td>\n",
       "      <td>Vienna, Austria</td>\n",
       "      <td>16.373819</td>\n",
       "      <td>48.208174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>923</th>\n",
       "      <td>Vientiane</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Laos</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>FB photo confirming headcount</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Vientiane</td>\n",
       "      <td>Vientiane</td>\n",
       "      <td>102.633104</td>\n",
       "      <td>17.975706</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>924</th>\n",
       "      <td>Vilnius, Lithuania</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lithuania</td>\n",
       "      <td>150.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>FB group with photos confirming approximate he...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Vilnius, Lithuania</td>\n",
       "      <td>Vilnius, Lithuania</td>\n",
       "      <td>25.279651</td>\n",
       "      <td>54.687156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>925</th>\n",
       "      <td>Warsaw</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Poland</td>\n",
       "      <td>200.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>http://www.cbsnews.com/pictures/womens-march-o...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Warsaw</td>\n",
       "      <td>Warsaw</td>\n",
       "      <td>21.012229</td>\n",
       "      <td>52.229676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>926</th>\n",
       "      <td>Wellington, New Zealand</td>\n",
       "      <td>NaN</td>\n",
       "      <td>New Zealand</td>\n",
       "      <td>700.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>https://www.facebook.com/events/215971992188360/</td>\n",
       "      <td>http://www.stuff.co.nz/national/88642615/new-z...</td>\n",
       "      <td>https://www.facebook.com/womensmarchnewzealand...</td>\n",
       "      <td>Wellington, New Zealand</td>\n",
       "      <td>Wellington, New Zealand</td>\n",
       "      <td>174.776236</td>\n",
       "      <td>-41.286460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>927</th>\n",
       "      <td>Whitehorse, Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>200.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>http://www.cbc.ca/news/canada/north/yellowknif...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FB</td>\n",
       "      <td>Whitehorse, Canada</td>\n",
       "      <td>Whitehorse, Canada</td>\n",
       "      <td>-135.056845</td>\n",
       "      <td>60.721187</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>928</th>\n",
       "      <td>Whitehorse, Yukon, Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>200.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>http://www.cbc.ca/news/canada/north/yellowknif...</td>\n",
       "      <td>https://twitter.com/dougrutherford/status/8229...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whitehorse, Yukon, Canada</td>\n",
       "      <td>Whitehorse, Yukon, Canada</td>\n",
       "      <td>-135.056845</td>\n",
       "      <td>60.721187</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>929</th>\n",
       "      <td>Winnipeg, Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>http://www.cbc.ca/beta/news/canada/manitoba/wo...</td>\n",
       "      <td>https://twitter.com/Smile_Beaitiful/status/823...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Winnipeg, Canada</td>\n",
       "      <td>Winnipeg, Canada</td>\n",
       "      <td>-97.138374</td>\n",
       "      <td>49.895136</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>930</th>\n",
       "      <td>Wolfville, NS, Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>300.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>FB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wolfville, NS, Canada</td>\n",
       "      <td>Wolfville, NS, Canada</td>\n",
       "      <td>-64.359835</td>\n",
       "      <td>45.091760</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>931</th>\n",
       "      <td>Xcalak</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>18.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>onsite eyewitness took approximate headcount</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Xcalak</td>\n",
       "      <td>Xcalak</td>\n",
       "      <td>-87.835833</td>\n",
       "      <td>18.271389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>932</th>\n",
       "      <td>Yangon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Myanmar (Burma)</td>\n",
       "      <td>75.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>onsite eyewitness w photo w / approximate head...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yangon</td>\n",
       "      <td>Yangon</td>\n",
       "      <td>96.195132</td>\n",
       "      <td>16.866069</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>933</th>\n",
       "      <td>Yellowknife, NWT, Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>100.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>http://www.cbc.ca/news/canada/north/yellowknif...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yellowknife, NWT, Canada</td>\n",
       "      <td>Yellowknife, NWT, Canada</td>\n",
       "      <td>-114.371789</td>\n",
       "      <td>62.453972</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>935</th>\n",
       "      <td>York, England</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>230.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>https://www.facebook.com/groups/pantsuitnation...</td>\n",
       "      <td>organizer onsite</td>\n",
       "      <td>https://www.yorkmix.com/news/53-empowering-pic...</td>\n",
       "      <td>York, England</td>\n",
       "      <td>York, England</td>\n",
       "      <td>-1.087298</td>\n",
       "      <td>53.959965</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>936</th>\n",
       "      <td>Surama</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Guyana</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Eyewitness account</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Surama</td>\n",
       "      <td>Surama</td>\n",
       "      <td>59.506638</td>\n",
       "      <td>22.565276</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>937</th>\n",
       "      <td>Zacatitos</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>25.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>FB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Zacatitos</td>\n",
       "      <td>Zacatitos</td>\n",
       "      <td>-113.500002</td>\n",
       "      <td>27.999994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>938</th>\n",
       "      <td>Zihuatanejo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>40.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Eyewitness account; photographic evidence</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Zihuatanejo</td>\n",
       "      <td>Zihuatanejo</td>\n",
       "      <td>-101.551695</td>\n",
       "      <td>17.641669</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>863 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         place state          country  estimate_low  \\\n",
       "2                  Abilene, TX    TX               US         200.0   \n",
       "3                 Accident, MD    MD               US          54.0   \n",
       "4                     Adak, AK    AK               US          10.0   \n",
       "5                   Adrian, MI    MI               US         150.0   \n",
       "6                      Ajo, AZ    AZ               US         250.0   \n",
       "7                  Alameda, CA    CA               US           8.0   \n",
       "8                  Alamosa, CO    CO               US         350.0   \n",
       "9                   Albany, CA    CA               US         500.0   \n",
       "10                  Albany, NY    NY               US        7000.0   \n",
       "11              Alexandria, VA    VA               US          17.0   \n",
       "12             Albuquerque, NM    NM               US        3000.0   \n",
       "13                Alliance, NE    NE               US         100.0   \n",
       "14            Almanor West, CA    CA               US           4.0   \n",
       "15                  Alpine, TX    TX               US          96.0   \n",
       "17                Amarillo, TX    TX               US         600.0   \n",
       "18           Amelia Island, FL    FL               US         700.0   \n",
       "19               Anacortes, WA    WA               US        1200.0   \n",
       "20               Anchorage, AK    AK               US        2000.0   \n",
       "21                  Angola, IN    IN               US          24.0   \n",
       "22               Ann Arbor, MI    MI               US       11000.0   \n",
       "23               Annapolis, MD    MD               US        1600.0   \n",
       "24                Annville, PA    PA               US          30.0   \n",
       "25                Appleton, WI    WI               US           3.0   \n",
       "26                   Arden, DE    DE               US          40.0   \n",
       "28             Asbury Park, NJ    NJ               US        6000.0   \n",
       "29               Asheville, NC    NC               US        7000.0   \n",
       "30                 Ashland, OR    OR               US        8000.0   \n",
       "31                   Aspen, CO    CO               US         200.0   \n",
       "32                 Astoria, OR    OR               US        1300.0   \n",
       "33                  Athens, GA    GA               US         700.0   \n",
       "..                         ...   ...              ...           ...   \n",
       "906               Taipa, Macau   NaN            Macau         100.0   \n",
       "907           Tbilisi, Georgia   NaN          Georgia         300.0   \n",
       "908           Tel Aviv, Israel   NaN           Israel         300.0   \n",
       "909               Thessoloniki   NaN           Greece          36.0   \n",
       "910               Todos Santos   NaN           Mexico         200.0   \n",
       "911               Tokyo, Japan   NaN            Japan         648.0   \n",
       "912            Toronto, Canada   NaN           Canada       50000.0   \n",
       "913           Toulouse, France   NaN           France         200.0   \n",
       "914          Trondheim, Norway   NaN           Norway         260.0   \n",
       "917                 Ubud, Bali   NaN        Indonesia          95.0   \n",
       "918                      Uvita   NaN       Costa Rica          18.0   \n",
       "919          Vancouver, Canada   NaN           Canada       10000.0   \n",
       "920                    Vicenza   NaN            Italy          25.0   \n",
       "921           Victoria, Canada   NaN           Canada        2000.0   \n",
       "922            Vienna, Austria   NaN          Austria        1300.0   \n",
       "923                  Vientiane   NaN             Laos           9.0   \n",
       "924         Vilnius, Lithuania   NaN        Lithuania         150.0   \n",
       "925                     Warsaw   NaN           Poland         200.0   \n",
       "926    Wellington, New Zealand   NaN      New Zealand         700.0   \n",
       "927         Whitehorse, Canada   NaN           Canada         200.0   \n",
       "928  Whitehorse, Yukon, Canada   NaN           Canada         200.0   \n",
       "929           Winnipeg, Canada   NaN           Canada        1000.0   \n",
       "930      Wolfville, NS, Canada   NaN           Canada         300.0   \n",
       "931                     Xcalak   NaN           Mexico          18.0   \n",
       "932                     Yangon   NaN  Myanmar (Burma)          75.0   \n",
       "933   Yellowknife, NWT, Canada   NaN           Canada         100.0   \n",
       "935              York, England   NaN   United Kingdom         230.0   \n",
       "936                     Surama   NaN           Guyana           1.0   \n",
       "937                  Zacatitos   NaN           Mexico          25.0   \n",
       "938                Zihuatanejo   NaN           Mexico          40.0   \n",
       "\n",
       "     estimate_high                                             source  \\\n",
       "2            200.0  http://www.reporternews.com/story/news/local/2...   \n",
       "3             54.0  http://www.riverfronttimes.com/newsblog/2017/0...   \n",
       "4             10.0                                            adn.com   \n",
       "5            150.0  http://www.lenconnect.com/news/20170122/marche...   \n",
       "6            250.0  https://www.facebook.com/plugins/post.php?href...   \n",
       "7              8.0                                                 FB   \n",
       "8            350.0  https://twitter.com/zepol/status/8232349739352...   \n",
       "9            500.0  https://twitter.com/ben_silverman/status/82303...   \n",
       "10          9000.0  http://www.timesunion.com/local/article/Albany...   \n",
       "11            17.0  https://twitter.com/TinaPStacy/status/82322604...   \n",
       "12         15000.0  http://www.koat.com/article/thousands-fill-civ...   \n",
       "13           150.0                     eyewtiness onsite w/ headcount   \n",
       "14             4.0                                eyewitness; picture   \n",
       "15            96.0  https://twitter.com/sarahmvasquez/status/82318...   \n",
       "17           700.0  https://www.texastribune.org/2017/01/21/thousa...   \n",
       "18          1367.0  http://www.firstcoastnews.com/news/womens-marc...   \n",
       "19          1200.0  http://www.goskagit.com/skagit/hundreds-partic...   \n",
       "20          4000.0  https://www.adn.com/alaska-news/2017/01/21/lar...   \n",
       "21            60.0  http://wane.com/2017/01/21/womens-marches-in-a...   \n",
       "22         11000.0  http://www.mlive.com/news/ann-arbor/index.ssf/...   \n",
       "23          1600.0  http://www.capitalgazette.com/news/annapolis/p...   \n",
       "24            30.0  http://www.ldnews.com/videos/news/2017/01/21/w...   \n",
       "25             3.0  http://www.sheboyganpress.com/story/news/local...   \n",
       "26            50.0   onsite eyewitness via google form; did headcount   \n",
       "28          6000.0  https://twitter.com/JuliaJHobbs/status/8229551...   \n",
       "29         10000.0  http://wlos.com/news/local/photo-gallery-the-w...   \n",
       "30         15000.0  http://www.oregonlive.com/trending/2017/01/wom...   \n",
       "31          1000.0  http://www.aspendailynews.com/section/home/174009   \n",
       "32          1600.0  http://www.dailyastorian.com/Local_News/201701...   \n",
       "33          5000.0  http://onlineathens.com/slideshow/2017-01-21/p...   \n",
       "..             ...                                                ...   \n",
       "906          100.0  http://aamacau.com/2017/01/22/%E9%9F%BF%E6%87%...   \n",
       "907          300.0  http://dfwatch.net/tbilisi-joins-global-womens...   \n",
       "908          500.0  on site report with crowd-counting via flyer d...   \n",
       "909           36.0  http://www.centralctcommunications.com/newbrit...   \n",
       "910          300.0                                  onsite eyewitness   \n",
       "911          648.0  http://www.elle.com/culture/career-politics/ne...   \n",
       "912        60000.0  https://www.thestar.com/news/gta/2017/01/21/ev...   \n",
       "913          300.0                                          FB group    \n",
       "914          280.0  http://www.adressa.no/nyheter/trondheim/2017/0...   \n",
       "917          100.0                                                 FB   \n",
       "918           20.0           Eyewitness report; photographic evidence   \n",
       "919        15000.0  http://www.cbc.ca/news/canada/british-columbia...   \n",
       "920           25.0                      FB photo confirming headcount   \n",
       "921         8000.0  http://www.timescolonist.com/news/local/women-...   \n",
       "922         2000.0                                                 FB   \n",
       "923            9.0                      FB photo confirming headcount   \n",
       "924          200.0  FB group with photos confirming approximate he...   \n",
       "925          200.0  http://www.cbsnews.com/pictures/womens-march-o...   \n",
       "926         1000.0   https://www.facebook.com/events/215971992188360/   \n",
       "927          200.0  http://www.cbc.ca/news/canada/north/yellowknif...   \n",
       "928          300.0  http://www.cbc.ca/news/canada/north/yellowknif...   \n",
       "929         3000.0  http://www.cbc.ca/beta/news/canada/manitoba/wo...   \n",
       "930          300.0                                                 FB   \n",
       "931           25.0       onsite eyewitness took approximate headcount   \n",
       "932           85.0  onsite eyewitness w photo w / approximate head...   \n",
       "933          130.0  http://www.cbc.ca/news/canada/north/yellowknif...   \n",
       "935          300.0  https://www.facebook.com/groups/pantsuitnation...   \n",
       "936            1.0                                 Eyewitness account   \n",
       "937           26.0                                                 FB   \n",
       "938           50.0          Eyewitness account; photographic evidence   \n",
       "\n",
       "                                               source2  \\\n",
       "2                                                  NaN   \n",
       "3                                                  NaN   \n",
       "4                                                  NaN   \n",
       "5    http://www.lenconnect.com/news/20170122/marche...   \n",
       "6                                                  NaN   \n",
       "7                                                  NaN   \n",
       "8                                                  NaN   \n",
       "9                 Albany PD (reported via google form)   \n",
       "10                                                  FB   \n",
       "11                                                 NaN   \n",
       "12   https://twitter.com/PatDavisNM/status/82293149...   \n",
       "13                                                 NaN   \n",
       "14                                                 NaN   \n",
       "15                                                 NaN   \n",
       "17   http://www.myhighplains.com/news/hundreds-gath...   \n",
       "18   https://twitter.com/wideofthepost/status/82307...   \n",
       "19                                                 NaN   \n",
       "20   https://twitter.com/julia_omalley/status/82290...   \n",
       "21    http://kpcnews.com/news/latest/heraldrepublican/   \n",
       "22                                                 NaN   \n",
       "23                                                 NaN   \n",
       "24                   onsite eyewitness via google form   \n",
       "25   http://www.postcrescent.com/story/news/local/2...   \n",
       "26                                                  FB   \n",
       "28                                                 NaN   \n",
       "29   http://wlos.com/news/local/photo-gallery-the-w...   \n",
       "30                                                 NaN   \n",
       "31   https://twitter.com/SarahGoTrillIum/status/823...   \n",
       "32   http://www.kast1370.com/index.php?option=com_c...   \n",
       "33                                                  FB   \n",
       "..                                                 ...   \n",
       "906     http://www.macaupostdaily.com/article2236.html   \n",
       "907                                                NaN   \n",
       "908  https://twitter.com/melanielidman/status/82287...   \n",
       "909                                                NaN   \n",
       "910                                                NaN   \n",
       "911  https://www.facebook.com/events/37355156635747...   \n",
       "912  http://globalnews.ca/news/3197235/60000-people...   \n",
       "913                                  onsite eyewitness   \n",
       "914  http://www.adressa.no/nyheter/trondheim/2017/0...   \n",
       "917                                                NaN   \n",
       "918                                                NaN   \n",
       "919                                                 FB   \n",
       "920                                                NaN   \n",
       "921  https://www.facebook.com/isitt/posts/101580065...   \n",
       "922  http://www.usatoday.com/story/news/2017/01/21/...   \n",
       "923                                                NaN   \n",
       "924                                                NaN   \n",
       "925                                                NaN   \n",
       "926  http://www.stuff.co.nz/national/88642615/new-z...   \n",
       "927                                                NaN   \n",
       "928  https://twitter.com/dougrutherford/status/8229...   \n",
       "929  https://twitter.com/Smile_Beaitiful/status/823...   \n",
       "930                                                NaN   \n",
       "931                                                NaN   \n",
       "932                                                NaN   \n",
       "933                                                NaN   \n",
       "935                                   organizer onsite   \n",
       "936                                                NaN   \n",
       "937                                                NaN   \n",
       "938                                                NaN   \n",
       "\n",
       "                                               source3  \\\n",
       "2                                                  NaN   \n",
       "3                            Twitter; on-site witness    \n",
       "4                                                  NaN   \n",
       "5                                                  NaN   \n",
       "6                                                  NaN   \n",
       "7                                                  NaN   \n",
       "8                                                  NaN   \n",
       "9                                                  NaN   \n",
       "10                                                 NaN   \n",
       "11                                                 NaN   \n",
       "12   https://twitter.com/AthertonKD/status/82321516...   \n",
       "13                                                 NaN   \n",
       "14                                                 NaN   \n",
       "15                                                 NaN   \n",
       "17                                                 NaN   \n",
       "18   http://www.ncflindependent.com/2017/01/21/stan...   \n",
       "19                                                 NaN   \n",
       "20   http://www.ktuu.com/content/news/Thousands-of-...   \n",
       "21                                                 NaN   \n",
       "22                                                 NaN   \n",
       "23                                                 NaN   \n",
       "24                                                 NaN   \n",
       "25                                                 NaN   \n",
       "26                                                 NaN   \n",
       "28                                                 NaN   \n",
       "29                                                 NaN   \n",
       "30                                                 NaN   \n",
       "31                                                 NaN   \n",
       "32                                                 NaN   \n",
       "33                                                 NaN   \n",
       "..                                                 ...   \n",
       "906                                                NaN   \n",
       "907                                                NaN   \n",
       "908                                                NaN   \n",
       "909                                                NaN   \n",
       "910                                                NaN   \n",
       "911                                                NaN   \n",
       "912                                                NaN   \n",
       "913                                                NaN   \n",
       "914                                                NaN   \n",
       "917                                                NaN   \n",
       "918                                                NaN   \n",
       "919                                                NaN   \n",
       "920                                                NaN   \n",
       "921  http://www.cbc.ca/beta/news/canada/british-col...   \n",
       "922                                                NaN   \n",
       "923                                                NaN   \n",
       "924                                                NaN   \n",
       "925                                                NaN   \n",
       "926  https://www.facebook.com/womensmarchnewzealand...   \n",
       "927                                                 FB   \n",
       "928                                                NaN   \n",
       "929                                                NaN   \n",
       "930                                                NaN   \n",
       "931                                                NaN   \n",
       "932                                                NaN   \n",
       "933                                                NaN   \n",
       "935  https://www.yorkmix.com/news/53-empowering-pic...   \n",
       "936                                                NaN   \n",
       "937                                                NaN   \n",
       "938                                                NaN   \n",
       "\n",
       "                                   full_place                     latlng  \\\n",
       "2               Abilene, Texas, United States                Abilene, TX   \n",
       "3           Accident, Maryland, United States               Accident, MD   \n",
       "4                 Adak, Alaska, United States                   Adak, AK   \n",
       "5             Adrian, Michigan, United States                 Adrian, MI   \n",
       "6                 Ajo, Arizona, United States                    Ajo, AZ   \n",
       "7          Alameda, California, United States                Alameda, CA   \n",
       "8            Alamosa, Colorado, United States                Alamosa, CO   \n",
       "9           Albany, California, United States                 Albany, CA   \n",
       "10            Albany, New York, United States                 Albany, NY   \n",
       "11        Alexandria, Virginia, United States             Alexandria, VA   \n",
       "12     Albuquerque, New Mexico, United States            Albuquerque, NM   \n",
       "13          Alliance, Nebraska, United States               Alliance, NE   \n",
       "14    Almanor West, California, United States           Almanor West, CA   \n",
       "15               Alpine, Texas, United States                 Alpine, TX   \n",
       "17             Amarillo, Texas, United States               Amarillo, TX   \n",
       "18      Amelia Island, Florida, United States          Amelia Island, FL   \n",
       "19       Anacortes, Washington, United States              Anacortes, WA   \n",
       "20           Anchorage, Alaska, United States              Anchorage, AK   \n",
       "21             Angola, Indiana, United States                 Angola, IN   \n",
       "22         Ann Arbor, Michigan, United States              Ann Arbor, MI   \n",
       "23         Annapolis, Maryland, United States              Annapolis, MD   \n",
       "24      Annville, Pennsylvania, United States               Annville, PA   \n",
       "25         Appleton, Wisconsin, United States               Appleton, WI   \n",
       "26             Arden, Delaware, United States                  Arden, DE   \n",
       "28     Asbury Park, New Jersey, United States            Asbury Park, NJ   \n",
       "29   Asheville, North Carolina, United States              Asheville, NC   \n",
       "30             Ashland, Oregon, United States                Ashland, OR   \n",
       "31             Aspen, Colorado, United States                  Aspen, CO   \n",
       "32             Astoria, Oregon, United States                Astoria, OR   \n",
       "33             Athens, Georgia, United States                 Athens, GA   \n",
       "..                                        ...                        ...   \n",
       "906                              Taipa, Macau               Taipa, Macau   \n",
       "907                          Tbilisi, Georgia           Tbilisi, Georgia   \n",
       "908                          Tel Aviv, Israel           Tel Aviv, Israel   \n",
       "909                              Thessoloniki               Thessoloniki   \n",
       "910                              Todos Santos               Todos Santos   \n",
       "911                              Tokyo, Japan               Tokyo, Japan   \n",
       "912                           Toronto, Canada            Toronto, Canada   \n",
       "913                          Toulouse, France           Toulouse, France   \n",
       "914                         Trondheim, Norway          Trondheim, Norway   \n",
       "917                                Ubud, Bali                 Ubud, Bali   \n",
       "918                                     Uvita                      Uvita   \n",
       "919                         Vancouver, Canada          Vancouver, Canada   \n",
       "920                                   Vicenza                    Vicenza   \n",
       "921                          Victoria, Canada           Victoria, Canada   \n",
       "922                           Vienna, Austria            Vienna, Austria   \n",
       "923                                 Vientiane                  Vientiane   \n",
       "924                        Vilnius, Lithuania         Vilnius, Lithuania   \n",
       "925                                    Warsaw                     Warsaw   \n",
       "926                   Wellington, New Zealand    Wellington, New Zealand   \n",
       "927                        Whitehorse, Canada         Whitehorse, Canada   \n",
       "928                 Whitehorse, Yukon, Canada  Whitehorse, Yukon, Canada   \n",
       "929                          Winnipeg, Canada           Winnipeg, Canada   \n",
       "930                     Wolfville, NS, Canada      Wolfville, NS, Canada   \n",
       "931                                    Xcalak                     Xcalak   \n",
       "932                                    Yangon                     Yangon   \n",
       "933                  Yellowknife, NWT, Canada   Yellowknife, NWT, Canada   \n",
       "935                             York, England              York, England   \n",
       "936                                    Surama                     Surama   \n",
       "937                                 Zacatitos                  Zacatitos   \n",
       "938                               Zihuatanejo                Zihuatanejo   \n",
       "\n",
       "            lng        lat  \n",
       "2    -99.733144  32.448736  \n",
       "3    -79.319759  39.628696  \n",
       "4   -176.658056  51.880000  \n",
       "5    -84.037166  41.897547  \n",
       "6   -112.860710  32.371725  \n",
       "7   -122.241636  37.765206  \n",
       "8   -105.870021  37.469449  \n",
       "9   -122.297747  37.886870  \n",
       "10   -73.756232  42.652579  \n",
       "11   -77.046921  38.804836  \n",
       "12  -106.605553  35.085334  \n",
       "13  -102.870201  42.093024  \n",
       "14  -121.202534  40.234637  \n",
       "15  -103.661012  30.358492  \n",
       "17  -101.831297  35.221997  \n",
       "18   -81.460856  30.626570  \n",
       "19  -122.612672  48.512604  \n",
       "20  -149.900278  61.218056  \n",
       "21   -84.999409  41.634773  \n",
       "22   -83.743038  42.280826  \n",
       "23   -76.492183  38.978445  \n",
       "24   -76.515244  40.329536  \n",
       "25   -88.415385  44.261931  \n",
       "26   -75.486587  39.809279  \n",
       "28   -74.012082  40.220391  \n",
       "29   -82.551487  35.595058  \n",
       "30  -122.709477  42.194576  \n",
       "31  -106.817539  39.191098  \n",
       "32  -123.831253  46.187884  \n",
       "33   -83.357567  33.951935  \n",
       "..          ...        ...  \n",
       "906  113.563922  22.159685  \n",
       "907   44.827096  41.715138  \n",
       "908   34.781768  32.085300  \n",
       "909   22.944419  40.640063  \n",
       "910 -110.226510  23.446362  \n",
       "911  139.691706  35.689487  \n",
       "912  -79.383184  43.653226  \n",
       "913    1.444209  43.604652  \n",
       "914   10.395053  63.430515  \n",
       "917  115.264379  -8.507808  \n",
       "918  -83.735851   9.163501  \n",
       "919 -123.120738  49.282729  \n",
       "920   11.535421  45.545479  \n",
       "921 -123.365644  48.428421  \n",
       "922   16.373819  48.208174  \n",
       "923  102.633104  17.975706  \n",
       "924   25.279651  54.687156  \n",
       "925   21.012229  52.229676  \n",
       "926  174.776236 -41.286460  \n",
       "927 -135.056845  60.721187  \n",
       "928 -135.056845  60.721187  \n",
       "929  -97.138374  49.895136  \n",
       "930  -64.359835  45.091760  \n",
       "931  -87.835833  18.271389  \n",
       "932   96.195132  16.866069  \n",
       "933 -114.371789  62.453972  \n",
       "935   -1.087298  53.959965  \n",
       "936   59.506638  22.565276  \n",
       "937 -113.500002  27.999994  \n",
       "938 -101.551695  17.641669  \n",
       "\n",
       "[863 rows x 12 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# make our new cols\n",
    "df = df.assign(latlng=df.place)\n",
    "df = df.assign(lng=df.place)\n",
    "\n",
    "\n",
    "def get_lat(x): \n",
    "    if x in cache:\n",
    "        return cache[x][0]    \n",
    "    print(x)\n",
    "    g = geocoder.google(x)\n",
    "    if g.latlng:\n",
    "        cache[x] = g.latlng\n",
    "        return g.latlng[0]\n",
    "    else:\n",
    "        return pd.np.nan\n",
    "\n",
    "def get_lng(x): \n",
    "    if x in cache:\n",
    "        return cache[x][1]\n",
    "    print(x)\n",
    "    g = geocoder.google(x)\n",
    "    if g.latlng:\n",
    "        cache[x] = g.latlng        \n",
    "        return g.latlng[1]\n",
    "    else:\n",
    "        return pd.np.nan\n",
    "\n",
    "df['lat'] = df.full_place.apply(lambda x: get_lat(x) )\n",
    "df['lng'] = df.full_place.apply(lambda x: get_lng(x) )\n",
    "df\n",
    "# this can actually be run multiple times, which will fix missing data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 858 entries, 2 to 938\n",
      "Data columns (total 12 columns):\n",
      "place            858 non-null object\n",
      "state            624 non-null object\n",
      "country          858 non-null object\n",
      "estimate_low     858 non-null float64\n",
      "estimate_high    858 non-null float64\n",
      "source           858 non-null object\n",
      "source2          353 non-null object\n",
      "source3          74 non-null object\n",
      "full_place       858 non-null object\n",
      "latlng           858 non-null object\n",
      "lng              858 non-null float64\n",
      "lat              858 non-null float64\n",
      "dtypes: float64(4), object(8)\n",
      "memory usage: 87.1+ KB\n"
     ]
    }
   ],
   "source": [
    "df.dropna(axis=0, how='any', subset=['lat', 'lng'], inplace=True)\n",
    "# df.drop([\"latlng\"], axis=1, inplace=True)\n",
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df.to_json(\"marches.json\", orient=\"records\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 265,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "\n",
    "# df.info()\n",
    "# cache['Madison, Wisconsin, United States']\n",
    "# df [ df['full_place']== \"Madison, Wisconsin, United States\" ]\n",
    "# df[df.lat == False]\n",
    "# df[df.lng == False]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}