2-8-16-sf_biz.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "data = pd.read_csv('datasets/san_fran_biz.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Location_ID</th>\n",
       "      <th>Business_Account_Number</th>\n",
       "      <th>Ownership_Name</th>\n",
       "      <th>DBA Name</th>\n",
       "      <th>Street_Address</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Zip_Code</th>\n",
       "      <th>Business_Start_Date</th>\n",
       "      <th>Business_End_Date</th>\n",
       "      <th>Location Start Date</th>\n",
       "      <th>Location_End_Date</th>\n",
       "      <th>Mail_Address</th>\n",
       "      <th>Mail_City_State_Zip</th>\n",
       "      <th>Business_Location</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0000024-02-999</td>\n",
       "      <td>24</td>\n",
       "      <td>EASTMAN KODAK CO</td>\n",
       "      <td>EASTMAN KODAK CO</td>\n",
       "      <td>343 STATE ST</td>\n",
       "      <td>ROCHESTER</td>\n",
       "      <td>NY</td>\n",
       "      <td>14650</td>\n",
       "      <td>01/01/2003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/01/2003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>343 STATE STREET</td>\n",
       "      <td>ROCHESTER NY 14650-0904</td>\n",
       "      <td>343 STATE ST\\nROCHESTER, NY 14650\\n(43.161198,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0000028-02-001</td>\n",
       "      <td>28</td>\n",
       "      <td>FERRANDO LOUISE</td>\n",
       "      <td>3101 LAGUNA APTS</td>\n",
       "      <td>3101 LAGUNA ST</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94123</td>\n",
       "      <td>09/30/1993</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/30/1993</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2799 CALIFORNIA ST</td>\n",
       "      <td>SAN FRANCISCO CA 94115-2513</td>\n",
       "      <td>3101 LAGUNA ST\\nSan Francisco, CA 94123\\n(37.7...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0000052-01-001</td>\n",
       "      <td>52</td>\n",
       "      <td>IDEAL NOVAK CORP</td>\n",
       "      <td>IDEAL NOVAK CORP</td>\n",
       "      <td>8 MENDOSA AVE</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94116</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8 MENDOSA AVE</td>\n",
       "      <td>SAN FRANCISCO CA 94116-1942</td>\n",
       "      <td>8 MENDOSA AVE\\nSan Francisco, CA 94116\\n(37.74...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0000071-01-001</td>\n",
       "      <td>71</td>\n",
       "      <td>TOURNAHU GEORGE L</td>\n",
       "      <td>TOURNAHU ARMS</td>\n",
       "      <td>1842 JEFFERSON ST</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94123</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4444 GEARY BLVD. 100</td>\n",
       "      <td>SAN FRANCISCO CA 94118-</td>\n",
       "      <td>1842 JEFFERSON ST\\nSan Francisco, CA 94123\\n(3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0000071-02-001</td>\n",
       "      <td>71</td>\n",
       "      <td>TOURNAHU GEORGE L</td>\n",
       "      <td>3301 BRODERICK APARTMENTS</td>\n",
       "      <td>3301 BRODERICK ST</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94123</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>05/01/1988</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4444 GEARY BLVD. 100</td>\n",
       "      <td>SAN FRANCISCO CA 94118-</td>\n",
       "      <td>3301 BRODERICK ST\\nSan Francisco, CA 94123\\n(3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0000071-02-003</td>\n",
       "      <td>71</td>\n",
       "      <td>TOURNAHU GEORGE L</td>\n",
       "      <td>3301 BRODERICK APARTMENTS</td>\n",
       "      <td>3301 BRODERICK ST</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94123</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>05/01/1988</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4444 GEARY BLVD. 100</td>\n",
       "      <td>SAN FRANCISCO CA 94118-</td>\n",
       "      <td>3301 BRODERICK ST\\nSan Francisco, CA 94123\\n(3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0000071-03-001</td>\n",
       "      <td>71</td>\n",
       "      <td>TOURNAHU GEORGE L</td>\n",
       "      <td>1840-42 JEFFERSON ST</td>\n",
       "      <td>1840-42 JEFFERSON ST</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94109</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10/07/1991</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4444 GEARY BLVD. 100</td>\n",
       "      <td>SAN FRANCISCO CA 94118-</td>\n",
       "      <td>1840 42 JEFFERSON ST\\nSan Francisco, CA 94109\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0000086-01-001</td>\n",
       "      <td>86</td>\n",
       "      <td>HARRY D SOM LIVING TRUST</td>\n",
       "      <td>1601 GRANT APTS</td>\n",
       "      <td>1601 GRANT AVE</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94133</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15 LEWIS ST</td>\n",
       "      <td>HARTFORD CT 06103-</td>\n",
       "      <td>1601 GRANT AVE\\nSan Francisco, CA 94133\\n(37.8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0000086-02-002</td>\n",
       "      <td>86</td>\n",
       "      <td>HARRY D SOM LIVING TRUST</td>\n",
       "      <td>1601 GRANT PARKING</td>\n",
       "      <td>1601 GRANT AVE</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94133</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/01/2013</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15 LEWIS ST</td>\n",
       "      <td>HARTFORD CT 06103-</td>\n",
       "      <td>1601 GRANT AVE\\nSan Francisco, CA 94133\\n(37.8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0000188-01-001</td>\n",
       "      <td>188</td>\n",
       "      <td>ABBETT ELEC CORP</td>\n",
       "      <td>ABBETT ELEC CORP</td>\n",
       "      <td>1850 BRYANT ST</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94110</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1850 BRYANT ST</td>\n",
       "      <td>SAN FRANCISCO CA 94110-1407</td>\n",
       "      <td>1850 BRYANT ST\\nSan Francisco, CA 94110\\n(37.7...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0000189-02-001</td>\n",
       "      <td>189</td>\n",
       "      <td>TC MCMECHEN INC</td>\n",
       "      <td>ABBEY CARPET</td>\n",
       "      <td>2900 GEARY BLVD</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94118</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>07/27/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2900 GEARY BLVD</td>\n",
       "      <td>SAN FRANCISCO CA 94118-3305</td>\n",
       "      <td>2900 GEARY BLVD\\nSan Francisco, CA 94118\\n(37....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0000189-03-001</td>\n",
       "      <td>189</td>\n",
       "      <td>TC MCMECHEN INC</td>\n",
       "      <td>ABBEY CARPET OF SAN FRANCISCO</td>\n",
       "      <td>2900 GEARY BLVD</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94118</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10/01/2013</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2900 GEARY BLVD</td>\n",
       "      <td>SAN FRANCISCO CA 94118-3305</td>\n",
       "      <td>2900 GEARY BLVD\\nSan Francisco, CA 94118\\n(37....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0000205-01-001</td>\n",
       "      <td>205</td>\n",
       "      <td>ABC AUTO PARTS</td>\n",
       "      <td>ABC AUTO PARTS</td>\n",
       "      <td>1650 DAVIDSON AVE</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94124</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1650 DAVIDSON AV</td>\n",
       "      <td>SAN FRANCISCO CA 94124-1143</td>\n",
       "      <td>1650 DAVIDSON AVE\\nSan Francisco, CA 94124\\n(3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0000216-01-001</td>\n",
       "      <td>216</td>\n",
       "      <td>SASSER JR JAKE</td>\n",
       "      <td>ABC INSURANCE</td>\n",
       "      <td>1727 OAKDALE AVE</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94124</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10/24/2002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1727 OAKDALE AV</td>\n",
       "      <td>SAN FRANCISCO CA 94124-2326</td>\n",
       "      <td>1727 OAKDALE AVE\\nSan Francisco, CA 94124\\n(37...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0000216-02-001</td>\n",
       "      <td>216</td>\n",
       "      <td>SASSER JR JAKE</td>\n",
       "      <td>J &amp; E CONSTRUCTION</td>\n",
       "      <td>1727 OAKDALE AVE</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94124</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>08/27/1999</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1727 OAKDALE AV</td>\n",
       "      <td>SAN FRANCISCO CA 94124-2326</td>\n",
       "      <td>1727 OAKDALE AVE\\nSan Francisco, CA 94124\\n(37...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0000224-01-001</td>\n",
       "      <td>224</td>\n",
       "      <td>ABC WINDOW CONTRACTORS INC</td>\n",
       "      <td>ABC WINDOW CONTRACTORS INC</td>\n",
       "      <td>811 CESAR CHAVEZ ST</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94124</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/1997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>803 VACA VALLEY PARKWAY</td>\n",
       "      <td>VACAVILLE CA 95688-8705</td>\n",
       "      <td>811 CESAR CHAVEZ ST\\nSan Francisco, CA 94124\\n...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0000244-01-001</td>\n",
       "      <td>244</td>\n",
       "      <td>CROWN BUILDING MAINTENANCE CO</td>\n",
       "      <td>ABLE BUILDING MAINTENANCE CO</td>\n",
       "      <td>868 FOLSOM ST</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94107</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>868 FOLSOM ST</td>\n",
       "      <td>SAN FRANCISCO CA 94107-0000</td>\n",
       "      <td>868 FOLSOM ST\\nSan Francisco, CA 94107\\n(37.78...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0000244-02-001</td>\n",
       "      <td>244</td>\n",
       "      <td>CROWN BUILDING MAINTENANCE CO</td>\n",
       "      <td>ABLE SERVICES</td>\n",
       "      <td>868 FOLSOM ST</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94107</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/01/2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>868 FOLSOM ST</td>\n",
       "      <td>SAN FRANCISCO CA 94107-0000</td>\n",
       "      <td>868 FOLSOM ST\\nSan Francisco, CA 94107\\n(37.78...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0000265-01-001</td>\n",
       "      <td>265</td>\n",
       "      <td>STEPHENS INSTITUTE INC</td>\n",
       "      <td>ACADEMY OF ART UNIVERSITY</td>\n",
       "      <td>79 NEW MONTGOMERY ST 3RD FL</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94105</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/2004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79 NEW MONTGOMERY ST</td>\n",
       "      <td>SAN FRANCISCO CA 94105-</td>\n",
       "      <td>79 NEW MONTGOMERY ST\\nSan Francisco, CA 94105\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0000265-04-001</td>\n",
       "      <td>265</td>\n",
       "      <td>STEPHENS INSTITUTE INC</td>\n",
       "      <td>ACAD ART COLLEGE SUPPLY STORE</td>\n",
       "      <td>79 NEW MONTGOMERY ST</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94105</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>02/01/1993</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79 NEW MONTGOMERY ST</td>\n",
       "      <td>SAN FRANCISCO CA 94105-</td>\n",
       "      <td>79 NEW MONTGOMERY ST\\nSan Francisco, CA 94105\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0000265-06-001</td>\n",
       "      <td>265</td>\n",
       "      <td>STEPHENS INSTITUTE INC</td>\n",
       "      <td>ACADEMY OF ART UNIVERSITY</td>\n",
       "      <td>410 BUSH ST</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94108</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/28/1994</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79 NEW MONTGOMERY ST</td>\n",
       "      <td>SAN FRANCISCO CA 94105-</td>\n",
       "      <td>410 BUSH ST\\nSan Francisco, CA 94108\\n(37.7906...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0000265-06-002</td>\n",
       "      <td>265</td>\n",
       "      <td>STEPHENS INSTITUTE INC</td>\n",
       "      <td>ACADEMY OF ART UNIVERSITY</td>\n",
       "      <td>2225 JERROLD AVE</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94124</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>05/29/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79 NEW MONTGOMERY ST</td>\n",
       "      <td>SAN FRANCISCO CA 94105-</td>\n",
       "      <td>2225 JERROLD AVE\\nSan Francisco, CA 94124\\n(37...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0000265-06-003</td>\n",
       "      <td>265</td>\n",
       "      <td>STEPHENS INSTITUTE INC</td>\n",
       "      <td>ACADEMY OF ART UNIVERSITY</td>\n",
       "      <td>180 NEW MONTGOMERY ST</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94105</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04/28/1995</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79 NEW MONTGOMERY ST</td>\n",
       "      <td>SAN FRANCISCO CA 94105-</td>\n",
       "      <td>180 NEW MONTGOMERY ST\\nSan Francisco, CA 94105...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0000265-06-004</td>\n",
       "      <td>265</td>\n",
       "      <td>STEPHENS INSTITUTE INC</td>\n",
       "      <td>ACADEMY OF ART UNIVERSITY</td>\n",
       "      <td>540 POWELL ST</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94108</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/28/1994</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79 NEW MONTGOMERY ST</td>\n",
       "      <td>SAN FRANCISCO CA 94105-</td>\n",
       "      <td>540 POWELL ST\\nSan Francisco, CA 94108\\n(37.78...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0000265-06-005</td>\n",
       "      <td>265</td>\n",
       "      <td>STEPHENS INSTITUTE INC</td>\n",
       "      <td>ACADEMY OF ART UNIVERSITY</td>\n",
       "      <td>460 TOWNSEND ST</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94107</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10/02/2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79 NEW MONTGOMERY ST</td>\n",
       "      <td>SAN FRANCISCO CA 94105-</td>\n",
       "      <td>460 TOWNSEND ST\\nSan Francisco, CA 94107\\n(37....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0000265-06-006</td>\n",
       "      <td>265</td>\n",
       "      <td>STEPHENS INSTITUTE INC</td>\n",
       "      <td>ACADEMY OF ART UNIVERSITY</td>\n",
       "      <td>1835-49 VAN NESS AVE</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94109</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>06/09/1998</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79 NEW MONTGOMERY ST</td>\n",
       "      <td>SAN FRANCISCO CA 94105-</td>\n",
       "      <td>1835 49 VAN NESS AVE\\nSan Francisco, CA 94109\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0000265-06-007</td>\n",
       "      <td>265</td>\n",
       "      <td>STEPHENS INSTITUTE INC</td>\n",
       "      <td>ACADEMY OF ART UNIVERSITY</td>\n",
       "      <td>620 SUTTER ST</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94102</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>08/11/2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79 NEW MONTGOMERY ST</td>\n",
       "      <td>SAN FRANCISCO CA 94105-</td>\n",
       "      <td>620 SUTTER ST\\nSan Francisco, CA 94102\\n(37.78...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0000265-06-008</td>\n",
       "      <td>265</td>\n",
       "      <td>STEPHENS INSTITUTE INC</td>\n",
       "      <td>ACADEMY OF ART UNIVERSITY</td>\n",
       "      <td>655 SUTTER ST</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94102</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/01/1999</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79 NEW MONTGOMERY ST</td>\n",
       "      <td>SAN FRANCISCO CA 94105-</td>\n",
       "      <td>655 SUTTER ST\\nSan Francisco, CA 94102\\n(37.78...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0000265-07-001</td>\n",
       "      <td>265</td>\n",
       "      <td>STEPHENS INSTITUTE INC</td>\n",
       "      <td>ACADEMY OF ART UNIVERSITY</td>\n",
       "      <td>1055 PINE ST</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94109</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/02/2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79 NEW MONTGOMERY ST</td>\n",
       "      <td>SAN FRANCISCO CA 94105-</td>\n",
       "      <td>1055 PINE ST\\nSan Francisco, CA 94109\\n(37.790...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>0000265-08-001</td>\n",
       "      <td>265</td>\n",
       "      <td>STEPHENS INSTITUTE INC</td>\n",
       "      <td>ACADEMY OF ART UNIVERSITY</td>\n",
       "      <td>121 WISCONSIN ST</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94107</td>\n",
       "      <td>10/01/1968</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/02/2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79 NEW MONTGOMERY ST</td>\n",
       "      <td>SAN FRANCISCO CA 94105-</td>\n",
       "      <td>121 WISCONSIN ST\\nSan Francisco, CA 94107\\n(37...</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161992</th>\n",
       "      <td>1051968-02-161</td>\n",
       "      <td>189667</td>\n",
       "      <td>GRUBER PARTNERS</td>\n",
       "      <td>159-19TH AVE</td>\n",
       "      <td>159 19TH AVE</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94121</td>\n",
       "      <td>12/21/1986</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/01/1990</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1233 4TH AVE</td>\n",
       "      <td>SAN FRANCISCO CA 94122-2601</td>\n",
       "      <td>159 19TH AVE\\nSAN FRANCISCO, CA 94121\\n(37.784...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161993</th>\n",
       "      <td>1051970-02-161</td>\n",
       "      <td>1024562</td>\n",
       "      <td>BIRMINGHAM GEORGE ALBERT</td>\n",
       "      <td>AIRBNB</td>\n",
       "      <td>507 VICENTE ST</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94116</td>\n",
       "      <td>03/27/2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/27/2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>507 VICENTE ST</td>\n",
       "      <td>SAN FRANCISCO CA 94116-</td>\n",
       "      <td>507 VICENTE ST\\nSAN FRANCISCO, CA 94116\\n(37.7...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161994</th>\n",
       "      <td>1051972-02-161</td>\n",
       "      <td>1024565</td>\n",
       "      <td>XANTOS LLC</td>\n",
       "      <td>XANTOS LLC</td>\n",
       "      <td>235 MONTGOMERY ST #350</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94104</td>\n",
       "      <td>01/26/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/26/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>235 MONTGOMERY ST STE 350</td>\n",
       "      <td>SAN FRANCISCO CA 94104-</td>\n",
       "      <td>235 MONTGOMERY ST\\nSAN FRANCISCO, CA 94104\\n(3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161995</th>\n",
       "      <td>1051974-02-161</td>\n",
       "      <td>1024567</td>\n",
       "      <td>A-1 AFFORDABLE PLUMBING SERVICE INC</td>\n",
       "      <td>A-1 AFFORDABLE PLUMBING SERVICE INC</td>\n",
       "      <td>800 AVENUE  H</td>\n",
       "      <td>TREASURE ISLAND</td>\n",
       "      <td>CA</td>\n",
       "      <td>94130</td>\n",
       "      <td>01/31/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/31/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5330 NORMA WAY</td>\n",
       "      <td>LIVERMORE CA 94550-</td>\n",
       "      <td>800 AVENUE H TREASURE ISLAND\\nCA 94130\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161996</th>\n",
       "      <td>1051976-02-161</td>\n",
       "      <td>1024568</td>\n",
       "      <td>WAI JOHN E 1981 LVG TRUST</td>\n",
       "      <td>1111-1133 GREEN ST APTS</td>\n",
       "      <td>1111-1133 GREEN ST</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94109</td>\n",
       "      <td>01/01/2014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/01/2014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PO BOX 641045</td>\n",
       "      <td>SAN FRANCISCO CA 94164-</td>\n",
       "      <td>1111 1133 GREEN ST\\nSAN FRANCISCO, CA 94109\\n(...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161997</th>\n",
       "      <td>1051979-02-161</td>\n",
       "      <td>1024570</td>\n",
       "      <td>WENTWORTH TIMOTHY</td>\n",
       "      <td>TIMOTHY WENTWORTH AND KATHLEEN JAY</td>\n",
       "      <td>215 23RD AVE</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94121</td>\n",
       "      <td>07/15/2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>07/15/2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>215 23RD AVE</td>\n",
       "      <td>SAN FRANCISCO CA 94121-</td>\n",
       "      <td>215 23RD AVE\\nSAN FRANCISCO, CA 94121\\n(37.783...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161998</th>\n",
       "      <td>1051980-02-161</td>\n",
       "      <td>1024569</td>\n",
       "      <td>POLLINO LLC</td>\n",
       "      <td>POLLINO LLC</td>\n",
       "      <td>235 MONTGOMERY ST 350</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94104</td>\n",
       "      <td>01/26/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/26/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>235 MONTGOMERY ST STE 350</td>\n",
       "      <td>SAN FRANCISCO CA 94104-</td>\n",
       "      <td>235 MONTGOMERY ST\\nSAN FRANCISCO, CA 94104\\n(3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161999</th>\n",
       "      <td>1051982-02-161</td>\n",
       "      <td>1024571</td>\n",
       "      <td>VIGNERON BENJAMIN</td>\n",
       "      <td>BENBIKA</td>\n",
       "      <td>1630 47TH AVE</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94122</td>\n",
       "      <td>07/01/2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>07/01/2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1630 47TH AVE</td>\n",
       "      <td>SAN FRANCISCO CA 94122-</td>\n",
       "      <td>1630 47TH AVE\\nSAN FRANCISCO, CA 94122\\n(37.75...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162000</th>\n",
       "      <td>1051984-02-161</td>\n",
       "      <td>1024572</td>\n",
       "      <td>NIEMUTH TOFFLER</td>\n",
       "      <td>3RD STREET</td>\n",
       "      <td>599 3RD ST 303</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94107</td>\n",
       "      <td>01/27/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/27/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>599 3RD ST APT 303</td>\n",
       "      <td>SAN FRANCISCO CA 94107-</td>\n",
       "      <td>599 3RD ST\\nSAN FRANCISCO, CA 94107\\n(37.78023...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162001</th>\n",
       "      <td>1051987-02-161</td>\n",
       "      <td>1024574</td>\n",
       "      <td>SILAS IV JOEL</td>\n",
       "      <td>WESTWIND MERCHANDISING</td>\n",
       "      <td>42 VALERTON CT</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94112</td>\n",
       "      <td>02/01/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>02/01/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42 VALERTON CT</td>\n",
       "      <td>SAN FRANCISCO CA 94112-</td>\n",
       "      <td>42 VALERTON CT\\nSAN FRANCISCO, CA 94112\\n(37.7...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162002</th>\n",
       "      <td>1051988-02-161</td>\n",
       "      <td>1024573</td>\n",
       "      <td>WAI JOHN E 1981 LVG TRUST</td>\n",
       "      <td>7-19 LEROY ST APTS</td>\n",
       "      <td>7-19 LEROY PLACE</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94109</td>\n",
       "      <td>01/01/2014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/01/2014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PO BOX 641045</td>\n",
       "      <td>SAN FRANCISCO CA 94164-</td>\n",
       "      <td>7 19 LEROY PLACE\\nSAN FRANCISCO, CA 94109\\n(37...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162003</th>\n",
       "      <td>1051990-02-161</td>\n",
       "      <td>1024576</td>\n",
       "      <td>KERSCHER CHRISTOPHER</td>\n",
       "      <td>CHRISTOPHER KERSCHER</td>\n",
       "      <td>843 HAYES ST A</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94117</td>\n",
       "      <td>01/01/2014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/01/2014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>843 HAYES ST UNIT A</td>\n",
       "      <td>SAN FRANCISCO CA 94117-</td>\n",
       "      <td>843 HAYES ST\\nA SAN FRANCISCO, CA 94117\\n(37.7...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162004</th>\n",
       "      <td>1051992-02-161</td>\n",
       "      <td>1024577</td>\n",
       "      <td>EMANUEL AARON</td>\n",
       "      <td>AARON EMANUEL</td>\n",
       "      <td>250 RANDOLPH ST</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94132</td>\n",
       "      <td>02/01/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>02/01/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>250 RANDOLPH ST</td>\n",
       "      <td>SAN FRANCISCO CA 94132-</td>\n",
       "      <td>250 RANDOLPH ST\\nSAN FRANCISCO, CA 94132\\n(37....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162005</th>\n",
       "      <td>1051994-02-161</td>\n",
       "      <td>1024575</td>\n",
       "      <td>FAST PAY PARTNERS LLC</td>\n",
       "      <td>FAST PAY PARTNERS LLC</td>\n",
       "      <td>3046 CALIFORNIA ST</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94115</td>\n",
       "      <td>11/15/2015</td>\n",
       "      <td>11/15/2015</td>\n",
       "      <td>11/15/2015</td>\n",
       "      <td>11/15/2015</td>\n",
       "      <td>8201 BEVERLY BLVD #600</td>\n",
       "      <td>LOS ANGELES CA 90048-</td>\n",
       "      <td>3046 CALIFORNIA ST\\nSAN FRANCISCO, CA 94115\\n(...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162006</th>\n",
       "      <td>1051997-02-161</td>\n",
       "      <td>1024578</td>\n",
       "      <td>SAGE DAVID &amp; LILY</td>\n",
       "      <td>1225 PINE ST APARTMENTS</td>\n",
       "      <td>2031 BAKER ST</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94115</td>\n",
       "      <td>11/28/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11/28/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2031 BAKER ST</td>\n",
       "      <td>SAN FRANCISCO CA 94115-</td>\n",
       "      <td>2031 BAKER ST\\nSAN FRANCISCO, CA 94115\\n(37.78...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162007</th>\n",
       "      <td>1051999-02-161</td>\n",
       "      <td>1024581</td>\n",
       "      <td>GILMAN KORA</td>\n",
       "      <td>WARREN APARTMENT</td>\n",
       "      <td>475 WARREN DR 6</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94131</td>\n",
       "      <td>01/21/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/21/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>475 WARREN DR APT 6</td>\n",
       "      <td>SAN FRANCISCO CA 94131-</td>\n",
       "      <td>475 WARREN DR\\nSAN FRANCISCO, CA 94131\\n(37.75...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162008</th>\n",
       "      <td>1052000-02-161</td>\n",
       "      <td>1024579</td>\n",
       "      <td>WANG CYNTHIA</td>\n",
       "      <td>MY HOME</td>\n",
       "      <td>1566 27TH AVE</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94122</td>\n",
       "      <td>01/19/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/19/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1566 27TH AVE</td>\n",
       "      <td>SAN FRANCISCO CA 94122-</td>\n",
       "      <td>1566 27TH AVE\\nSAN FRANCISCO, CA 94122\\n(37.75...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162009</th>\n",
       "      <td>1052003-02-161</td>\n",
       "      <td>1024580</td>\n",
       "      <td>WAI JOHN E 1981 LVG TRUST</td>\n",
       "      <td>1307-1329 STEVENSON ST APTS</td>\n",
       "      <td>1307-1329 STEVENSON ST</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94103</td>\n",
       "      <td>01/01/2014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/01/2014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PO BOX 641045</td>\n",
       "      <td>SAN FRANCISCO CA 94164-</td>\n",
       "      <td>1307 1329 STEVENSON ST\\nSAN FRANCISCO, CA 9410...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162010</th>\n",
       "      <td>1052004-02-161</td>\n",
       "      <td>1024582</td>\n",
       "      <td>UBERTO LLC</td>\n",
       "      <td>UBERTO LLC</td>\n",
       "      <td>235 MONTGOMERY ST 350</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94104</td>\n",
       "      <td>01/26/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/26/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>235 MONTGOMERY ST STE 350</td>\n",
       "      <td>SAN FRANCISCO CA 94104-</td>\n",
       "      <td>235 MONTGOMERY ST\\nSAN FRANCISCO, CA 94104\\n(3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162011</th>\n",
       "      <td>1052005-02-161</td>\n",
       "      <td>1024583</td>\n",
       "      <td>RAMOS GABRIELA</td>\n",
       "      <td>GABRIELA RAMOS</td>\n",
       "      <td>2269 CHESTBUT ST 860</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94123</td>\n",
       "      <td>01/25/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/25/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2269 CHESTBUT ST UNIT 860</td>\n",
       "      <td>SAN FRANCISCO CA 94123-</td>\n",
       "      <td>2269 CHESTBUT ST\\nSAN FRANCISCO, CA 94123\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162012</th>\n",
       "      <td>1052008-02-161</td>\n",
       "      <td>1024584</td>\n",
       "      <td>WOO WAYLAND</td>\n",
       "      <td>WOO WAYLAND</td>\n",
       "      <td>18 RAMSELL ST</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94132</td>\n",
       "      <td>12/11/2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/11/2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>615 MAPLE AVE</td>\n",
       "      <td>SOUTH SAN FRANCISCO CA 94080-</td>\n",
       "      <td>18 RAMSELL ST\\nSAN FRANCISCO, CA 94132\\n(37.71...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162013</th>\n",
       "      <td>1052010-02-161</td>\n",
       "      <td>1024585</td>\n",
       "      <td>CHAMBERLAYNE CAROLYN</td>\n",
       "      <td>LITTLE WOOF PACK</td>\n",
       "      <td>4413 KIRKHAM ST</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94122</td>\n",
       "      <td>02/01/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>02/01/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4413 KIRKHAM ST</td>\n",
       "      <td>SAN FRANCISCO CA 94122-</td>\n",
       "      <td>4413 KIRKHAM ST\\nSAN FRANCISCO, CA 94122\\n(37....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162014</th>\n",
       "      <td>1052012-02-161</td>\n",
       "      <td>1024586</td>\n",
       "      <td>ADAMS CRAIG &amp; LOUNSBURY ROBYN</td>\n",
       "      <td>CSA PROPERTIES</td>\n",
       "      <td>2201 MARKET ST</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94114</td>\n",
       "      <td>01/15/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/15/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>530 DIVISADERO ST #153</td>\n",
       "      <td>SAN FRANCISCO CA 94117-</td>\n",
       "      <td>2201 MARKET ST\\nSAN FRANCISCO, CA 94114\\n(37.7...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162015</th>\n",
       "      <td>1052016-02-161</td>\n",
       "      <td>1024589</td>\n",
       "      <td>WAI JOHN E 1981 LVG TRUST</td>\n",
       "      <td>1086 POST ST APTS</td>\n",
       "      <td>1086 POST ST</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94109</td>\n",
       "      <td>01/01/2014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/01/2014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PO BOX 641045</td>\n",
       "      <td>SAN FRANCISCO CA 94164-</td>\n",
       "      <td>1086 POST ST\\nSAN FRANCISCO, CA 94109\\n(37.786...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162016</th>\n",
       "      <td>1052017-02-161</td>\n",
       "      <td>1024588</td>\n",
       "      <td>CUCCIA CHRISTINE</td>\n",
       "      <td>STUDIO NACL</td>\n",
       "      <td>1049 FILBERT ST</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94133</td>\n",
       "      <td>02/01/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>02/01/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1049 FILBERT ST</td>\n",
       "      <td>SAN FRANCISCO CA 94133-</td>\n",
       "      <td>1049 FILBERT ST\\nSAN FRANCISCO, CA 94133\\n(37....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162017</th>\n",
       "      <td>1052019-02-161</td>\n",
       "      <td>1024591</td>\n",
       "      <td>READ DAVID</td>\n",
       "      <td>DAVID READ</td>\n",
       "      <td>314 PARK ST</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94110</td>\n",
       "      <td>01/19/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/19/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>314 PARK ST</td>\n",
       "      <td>SAN FRANCISCO CA 94110-</td>\n",
       "      <td>314 PARK ST\\nSAN FRANCISCO, CA 94110\\n(37.7364...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162018</th>\n",
       "      <td>1052021-02-161</td>\n",
       "      <td>1024593</td>\n",
       "      <td>MORRISON WESLEY JOHN</td>\n",
       "      <td>MOBILE IRISH MECHANIC</td>\n",
       "      <td>2170 36TH AVE</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94116</td>\n",
       "      <td>02/01/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>02/01/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2170 36TH AVE</td>\n",
       "      <td>SAN FRANCISCO CA 94116-</td>\n",
       "      <td>2170 36TH AVE\\nSAN FRANCISCO, CA 94116\\n(37.74...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162019</th>\n",
       "      <td>1052023-02-161</td>\n",
       "      <td>1024592</td>\n",
       "      <td>CHAN MATTHEW C</td>\n",
       "      <td>GIANTS RENTAL</td>\n",
       "      <td>170 KING ST 307</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94107</td>\n",
       "      <td>01/25/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/25/2016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170 KING ST UNIT 307</td>\n",
       "      <td>SAN FRANCISCO CA 94107-</td>\n",
       "      <td>170 KING ST\\nSAN FRANCISCO, CA 94107\\n(37.7786...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162020</th>\n",
       "      <td>1052025-02-161</td>\n",
       "      <td>1024594</td>\n",
       "      <td>WAI JOHN E 1981 LVG TRUST</td>\n",
       "      <td>3735 ANZA ST APTS</td>\n",
       "      <td>3735 ANZA ST</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94121</td>\n",
       "      <td>01/01/2014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/01/2014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PO BOX 641045</td>\n",
       "      <td>SAN FRANCISCO CA 94164-</td>\n",
       "      <td>3735 ANZA ST\\nSAN FRANCISCO, CA 94121\\n(37.778...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162021</th>\n",
       "      <td>1052027-02-161</td>\n",
       "      <td>1024595</td>\n",
       "      <td>VALDEZ VALERIE</td>\n",
       "      <td>DIAMOND23BNB</td>\n",
       "      <td>601 DIAMOND ST APT A</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>94114</td>\n",
       "      <td>10/01/2014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10/01/2014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>601 DIAMOND ST APT A</td>\n",
       "      <td>SAN FRANCISCO CA 94114-</td>\n",
       "      <td>601 DIAMOND ST\\nAPT A SAN FRANCISCO, CA 94114\\...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>162022 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           Location_ID  Business_Account_Number  \\\n",
       "0       0000024-02-999                       24   \n",
       "1       0000028-02-001                       28   \n",
       "2       0000052-01-001                       52   \n",
       "3       0000071-01-001                       71   \n",
       "4       0000071-02-001                       71   \n",
       "5       0000071-02-003                       71   \n",
       "6       0000071-03-001                       71   \n",
       "7       0000086-01-001                       86   \n",
       "8       0000086-02-002                       86   \n",
       "9       0000188-01-001                      188   \n",
       "10      0000189-02-001                      189   \n",
       "11      0000189-03-001                      189   \n",
       "12      0000205-01-001                      205   \n",
       "13      0000216-01-001                      216   \n",
       "14      0000216-02-001                      216   \n",
       "15      0000224-01-001                      224   \n",
       "16      0000244-01-001                      244   \n",
       "17      0000244-02-001                      244   \n",
       "18      0000265-01-001                      265   \n",
       "19      0000265-04-001                      265   \n",
       "20      0000265-06-001                      265   \n",
       "21      0000265-06-002                      265   \n",
       "22      0000265-06-003                      265   \n",
       "23      0000265-06-004                      265   \n",
       "24      0000265-06-005                      265   \n",
       "25      0000265-06-006                      265   \n",
       "26      0000265-06-007                      265   \n",
       "27      0000265-06-008                      265   \n",
       "28      0000265-07-001                      265   \n",
       "29      0000265-08-001                      265   \n",
       "...                ...                      ...   \n",
       "161992  1051968-02-161                   189667   \n",
       "161993  1051970-02-161                  1024562   \n",
       "161994  1051972-02-161                  1024565   \n",
       "161995  1051974-02-161                  1024567   \n",
       "161996  1051976-02-161                  1024568   \n",
       "161997  1051979-02-161                  1024570   \n",
       "161998  1051980-02-161                  1024569   \n",
       "161999  1051982-02-161                  1024571   \n",
       "162000  1051984-02-161                  1024572   \n",
       "162001  1051987-02-161                  1024574   \n",
       "162002  1051988-02-161                  1024573   \n",
       "162003  1051990-02-161                  1024576   \n",
       "162004  1051992-02-161                  1024577   \n",
       "162005  1051994-02-161                  1024575   \n",
       "162006  1051997-02-161                  1024578   \n",
       "162007  1051999-02-161                  1024581   \n",
       "162008  1052000-02-161                  1024579   \n",
       "162009  1052003-02-161                  1024580   \n",
       "162010  1052004-02-161                  1024582   \n",
       "162011  1052005-02-161                  1024583   \n",
       "162012  1052008-02-161                  1024584   \n",
       "162013  1052010-02-161                  1024585   \n",
       "162014  1052012-02-161                  1024586   \n",
       "162015  1052016-02-161                  1024589   \n",
       "162016  1052017-02-161                  1024588   \n",
       "162017  1052019-02-161                  1024591   \n",
       "162018  1052021-02-161                  1024593   \n",
       "162019  1052023-02-161                  1024592   \n",
       "162020  1052025-02-161                  1024594   \n",
       "162021  1052027-02-161                  1024595   \n",
       "\n",
       "                             Ownership_Name  \\\n",
       "0                          EASTMAN KODAK CO   \n",
       "1                           FERRANDO LOUISE   \n",
       "2                          IDEAL NOVAK CORP   \n",
       "3                         TOURNAHU GEORGE L   \n",
       "4                         TOURNAHU GEORGE L   \n",
       "5                         TOURNAHU GEORGE L   \n",
       "6                         TOURNAHU GEORGE L   \n",
       "7                  HARRY D SOM LIVING TRUST   \n",
       "8                  HARRY D SOM LIVING TRUST   \n",
       "9                          ABBETT ELEC CORP   \n",
       "10                          TC MCMECHEN INC   \n",
       "11                          TC MCMECHEN INC   \n",
       "12                           ABC AUTO PARTS   \n",
       "13                           SASSER JR JAKE   \n",
       "14                           SASSER JR JAKE   \n",
       "15               ABC WINDOW CONTRACTORS INC   \n",
       "16            CROWN BUILDING MAINTENANCE CO   \n",
       "17            CROWN BUILDING MAINTENANCE CO   \n",
       "18                   STEPHENS INSTITUTE INC   \n",
       "19                   STEPHENS INSTITUTE INC   \n",
       "20                   STEPHENS INSTITUTE INC   \n",
       "21                   STEPHENS INSTITUTE INC   \n",
       "22                   STEPHENS INSTITUTE INC   \n",
       "23                   STEPHENS INSTITUTE INC   \n",
       "24                   STEPHENS INSTITUTE INC   \n",
       "25                   STEPHENS INSTITUTE INC   \n",
       "26                   STEPHENS INSTITUTE INC   \n",
       "27                   STEPHENS INSTITUTE INC   \n",
       "28                   STEPHENS INSTITUTE INC   \n",
       "29                   STEPHENS INSTITUTE INC   \n",
       "...                                     ...   \n",
       "161992                      GRUBER PARTNERS   \n",
       "161993             BIRMINGHAM GEORGE ALBERT   \n",
       "161994                           XANTOS LLC   \n",
       "161995  A-1 AFFORDABLE PLUMBING SERVICE INC   \n",
       "161996            WAI JOHN E 1981 LVG TRUST   \n",
       "161997                    WENTWORTH TIMOTHY   \n",
       "161998                          POLLINO LLC   \n",
       "161999                    VIGNERON BENJAMIN   \n",
       "162000                      NIEMUTH TOFFLER   \n",
       "162001                        SILAS IV JOEL   \n",
       "162002            WAI JOHN E 1981 LVG TRUST   \n",
       "162003                 KERSCHER CHRISTOPHER   \n",
       "162004                        EMANUEL AARON   \n",
       "162005                FAST PAY PARTNERS LLC   \n",
       "162006                    SAGE DAVID & LILY   \n",
       "162007                          GILMAN KORA   \n",
       "162008                         WANG CYNTHIA   \n",
       "162009            WAI JOHN E 1981 LVG TRUST   \n",
       "162010                           UBERTO LLC   \n",
       "162011                       RAMOS GABRIELA   \n",
       "162012                          WOO WAYLAND   \n",
       "162013                 CHAMBERLAYNE CAROLYN   \n",
       "162014        ADAMS CRAIG & LOUNSBURY ROBYN   \n",
       "162015            WAI JOHN E 1981 LVG TRUST   \n",
       "162016                     CUCCIA CHRISTINE   \n",
       "162017                           READ DAVID   \n",
       "162018                 MORRISON WESLEY JOHN   \n",
       "162019                       CHAN MATTHEW C   \n",
       "162020            WAI JOHN E 1981 LVG TRUST   \n",
       "162021                       VALDEZ VALERIE   \n",
       "\n",
       "                                   DBA Name               Street_Address  \\\n",
       "0                          EASTMAN KODAK CO                 343 STATE ST   \n",
       "1                          3101 LAGUNA APTS               3101 LAGUNA ST   \n",
       "2                          IDEAL NOVAK CORP                8 MENDOSA AVE   \n",
       "3                             TOURNAHU ARMS            1842 JEFFERSON ST   \n",
       "4                 3301 BRODERICK APARTMENTS            3301 BRODERICK ST   \n",
       "5                 3301 BRODERICK APARTMENTS            3301 BRODERICK ST   \n",
       "6                      1840-42 JEFFERSON ST         1840-42 JEFFERSON ST   \n",
       "7                           1601 GRANT APTS               1601 GRANT AVE   \n",
       "8                        1601 GRANT PARKING               1601 GRANT AVE   \n",
       "9                          ABBETT ELEC CORP               1850 BRYANT ST   \n",
       "10                             ABBEY CARPET              2900 GEARY BLVD   \n",
       "11            ABBEY CARPET OF SAN FRANCISCO              2900 GEARY BLVD   \n",
       "12                           ABC AUTO PARTS            1650 DAVIDSON AVE   \n",
       "13                            ABC INSURANCE             1727 OAKDALE AVE   \n",
       "14                       J & E CONSTRUCTION             1727 OAKDALE AVE   \n",
       "15               ABC WINDOW CONTRACTORS INC          811 CESAR CHAVEZ ST   \n",
       "16             ABLE BUILDING MAINTENANCE CO                868 FOLSOM ST   \n",
       "17                            ABLE SERVICES                868 FOLSOM ST   \n",
       "18                ACADEMY OF ART UNIVERSITY  79 NEW MONTGOMERY ST 3RD FL   \n",
       "19            ACAD ART COLLEGE SUPPLY STORE         79 NEW MONTGOMERY ST   \n",
       "20                ACADEMY OF ART UNIVERSITY                  410 BUSH ST   \n",
       "21                ACADEMY OF ART UNIVERSITY             2225 JERROLD AVE   \n",
       "22                ACADEMY OF ART UNIVERSITY        180 NEW MONTGOMERY ST   \n",
       "23                ACADEMY OF ART UNIVERSITY                540 POWELL ST   \n",
       "24                ACADEMY OF ART UNIVERSITY              460 TOWNSEND ST   \n",
       "25                ACADEMY OF ART UNIVERSITY         1835-49 VAN NESS AVE   \n",
       "26                ACADEMY OF ART UNIVERSITY                620 SUTTER ST   \n",
       "27                ACADEMY OF ART UNIVERSITY                655 SUTTER ST   \n",
       "28                ACADEMY OF ART UNIVERSITY                 1055 PINE ST   \n",
       "29                ACADEMY OF ART UNIVERSITY             121 WISCONSIN ST   \n",
       "...                                     ...                          ...   \n",
       "161992                         159-19TH AVE                 159 19TH AVE   \n",
       "161993                               AIRBNB               507 VICENTE ST   \n",
       "161994                           XANTOS LLC       235 MONTGOMERY ST #350   \n",
       "161995  A-1 AFFORDABLE PLUMBING SERVICE INC                800 AVENUE  H   \n",
       "161996              1111-1133 GREEN ST APTS           1111-1133 GREEN ST   \n",
       "161997   TIMOTHY WENTWORTH AND KATHLEEN JAY                 215 23RD AVE   \n",
       "161998                          POLLINO LLC        235 MONTGOMERY ST 350   \n",
       "161999                              BENBIKA                1630 47TH AVE   \n",
       "162000                           3RD STREET               599 3RD ST 303   \n",
       "162001               WESTWIND MERCHANDISING               42 VALERTON CT   \n",
       "162002                   7-19 LEROY ST APTS             7-19 LEROY PLACE   \n",
       "162003                 CHRISTOPHER KERSCHER               843 HAYES ST A   \n",
       "162004                        AARON EMANUEL              250 RANDOLPH ST   \n",
       "162005                FAST PAY PARTNERS LLC           3046 CALIFORNIA ST   \n",
       "162006              1225 PINE ST APARTMENTS                2031 BAKER ST   \n",
       "162007                     WARREN APARTMENT              475 WARREN DR 6   \n",
       "162008                              MY HOME                1566 27TH AVE   \n",
       "162009          1307-1329 STEVENSON ST APTS       1307-1329 STEVENSON ST   \n",
       "162010                           UBERTO LLC        235 MONTGOMERY ST 350   \n",
       "162011                       GABRIELA RAMOS         2269 CHESTBUT ST 860   \n",
       "162012                          WOO WAYLAND                18 RAMSELL ST   \n",
       "162013                     LITTLE WOOF PACK              4413 KIRKHAM ST   \n",
       "162014                       CSA PROPERTIES               2201 MARKET ST   \n",
       "162015                    1086 POST ST APTS                 1086 POST ST   \n",
       "162016                          STUDIO NACL              1049 FILBERT ST   \n",
       "162017                           DAVID READ                  314 PARK ST   \n",
       "162018                MOBILE IRISH MECHANIC                2170 36TH AVE   \n",
       "162019                        GIANTS RENTAL              170 KING ST 307   \n",
       "162020                    3735 ANZA ST APTS                 3735 ANZA ST   \n",
       "162021                         DIAMOND23BNB         601 DIAMOND ST APT A   \n",
       "\n",
       "                   City State  Zip_Code Business_Start_Date Business_End_Date  \\\n",
       "0             ROCHESTER    NY     14650          01/01/2003               NaN   \n",
       "1         San Francisco    CA     94123          09/30/1993               NaN   \n",
       "2         San Francisco    CA     94116          10/01/1968               NaN   \n",
       "3         San Francisco    CA     94123          10/01/1968               NaN   \n",
       "4         San Francisco    CA     94123          10/01/1968               NaN   \n",
       "5         San Francisco    CA     94123          10/01/1968               NaN   \n",
       "6         San Francisco    CA     94109          10/01/1968               NaN   \n",
       "7         San Francisco    CA     94133          10/01/1968               NaN   \n",
       "8         San Francisco    CA     94133          10/01/1968               NaN   \n",
       "9         San Francisco    CA     94110          10/01/1968               NaN   \n",
       "10        San Francisco    CA     94118          10/01/1968               NaN   \n",
       "11        San Francisco    CA     94118          10/01/1968               NaN   \n",
       "12        San Francisco    CA     94124          10/01/1968               NaN   \n",
       "13        San Francisco    CA     94124          10/01/1968               NaN   \n",
       "14        San Francisco    CA     94124          10/01/1968               NaN   \n",
       "15        San Francisco    CA     94124          10/01/1968               NaN   \n",
       "16        San Francisco    CA     94107          10/01/1968               NaN   \n",
       "17        San Francisco    CA     94107          10/01/1968               NaN   \n",
       "18        San Francisco    CA     94105          10/01/1968               NaN   \n",
       "19        San Francisco    CA     94105          10/01/1968               NaN   \n",
       "20        San Francisco    CA     94108          10/01/1968               NaN   \n",
       "21        San Francisco    CA     94124          10/01/1968               NaN   \n",
       "22        San Francisco    CA     94105          10/01/1968               NaN   \n",
       "23        San Francisco    CA     94108          10/01/1968               NaN   \n",
       "24        San Francisco    CA     94107          10/01/1968               NaN   \n",
       "25        San Francisco    CA     94109          10/01/1968               NaN   \n",
       "26        San Francisco    CA     94102          10/01/1968               NaN   \n",
       "27        San Francisco    CA     94102          10/01/1968               NaN   \n",
       "28        San Francisco    CA     94109          10/01/1968               NaN   \n",
       "29        San Francisco    CA     94107          10/01/1968               NaN   \n",
       "...                 ...   ...       ...                 ...               ...   \n",
       "161992    SAN FRANCISCO    CA     94121          12/21/1986               NaN   \n",
       "161993    SAN FRANCISCO    CA     94116          03/27/2015               NaN   \n",
       "161994    SAN FRANCISCO    CA     94104          01/26/2016               NaN   \n",
       "161995  TREASURE ISLAND    CA     94130          01/31/2016               NaN   \n",
       "161996    SAN FRANCISCO    CA     94109          01/01/2014               NaN   \n",
       "161997    SAN FRANCISCO    CA     94121          07/15/2015               NaN   \n",
       "161998    SAN FRANCISCO    CA     94104          01/26/2016               NaN   \n",
       "161999    SAN FRANCISCO    CA     94122          07/01/2015               NaN   \n",
       "162000    SAN FRANCISCO    CA     94107          01/27/2016               NaN   \n",
       "162001    SAN FRANCISCO    CA     94112          02/01/2016               NaN   \n",
       "162002    SAN FRANCISCO    CA     94109          01/01/2014               NaN   \n",
       "162003    SAN FRANCISCO    CA     94117          01/01/2014               NaN   \n",
       "162004    SAN FRANCISCO    CA     94132          02/01/2016               NaN   \n",
       "162005    SAN FRANCISCO    CA     94115          11/15/2015        11/15/2015   \n",
       "162006    SAN FRANCISCO    CA     94115          11/28/2012               NaN   \n",
       "162007    SAN FRANCISCO    CA     94131          01/21/2016               NaN   \n",
       "162008    SAN FRANCISCO    CA     94122          01/19/2016               NaN   \n",
       "162009    SAN FRANCISCO    CA     94103          01/01/2014               NaN   \n",
       "162010    SAN FRANCISCO    CA     94104          01/26/2016               NaN   \n",
       "162011    SAN FRANCISCO    CA     94123          01/25/2016               NaN   \n",
       "162012    SAN FRANCISCO    CA     94132          12/11/2015               NaN   \n",
       "162013    SAN FRANCISCO    CA     94122          02/01/2016               NaN   \n",
       "162014    SAN FRANCISCO    CA     94114          01/15/2016               NaN   \n",
       "162015    SAN FRANCISCO    CA     94109          01/01/2014               NaN   \n",
       "162016    SAN FRANCISCO    CA     94133          02/01/2016               NaN   \n",
       "162017    SAN FRANCISCO    CA     94110          01/19/2016               NaN   \n",
       "162018    SAN FRANCISCO    CA     94116          02/01/2016               NaN   \n",
       "162019    SAN FRANCISCO    CA     94107          01/25/2016               NaN   \n",
       "162020    SAN FRANCISCO    CA     94121          01/01/2014               NaN   \n",
       "162021    SAN FRANCISCO    CA     94114          10/01/2014               NaN   \n",
       "\n",
       "       Location Start Date Location_End_Date               Mail_Address  \\\n",
       "0               01/01/2003               NaN           343 STATE STREET   \n",
       "1               09/30/1993               NaN         2799 CALIFORNIA ST   \n",
       "2               10/01/1968               NaN              8 MENDOSA AVE   \n",
       "3               10/01/1968               NaN       4444 GEARY BLVD. 100   \n",
       "4               05/01/1988               NaN       4444 GEARY BLVD. 100   \n",
       "5               05/01/1988               NaN       4444 GEARY BLVD. 100   \n",
       "6               10/07/1991               NaN       4444 GEARY BLVD. 100   \n",
       "7               10/01/1968               NaN                15 LEWIS ST   \n",
       "8               01/01/2013               NaN                15 LEWIS ST   \n",
       "9               10/01/1968               NaN             1850 BRYANT ST   \n",
       "10              07/27/2012               NaN            2900 GEARY BLVD   \n",
       "11              10/01/2013               NaN            2900 GEARY BLVD   \n",
       "12              10/01/1968               NaN           1650 DAVIDSON AV   \n",
       "13              10/24/2002               NaN            1727 OAKDALE AV   \n",
       "14              08/27/1999               NaN            1727 OAKDALE AV   \n",
       "15              09/29/1997               NaN    803 VACA VALLEY PARKWAY   \n",
       "16              10/01/1968               NaN              868 FOLSOM ST   \n",
       "17              04/01/2005               NaN              868 FOLSOM ST   \n",
       "18              03/01/2004               NaN       79 NEW MONTGOMERY ST   \n",
       "19              02/01/1993               NaN       79 NEW MONTGOMERY ST   \n",
       "20              01/28/1994               NaN       79 NEW MONTGOMERY ST   \n",
       "21              05/29/2009               NaN       79 NEW MONTGOMERY ST   \n",
       "22              04/28/1995               NaN       79 NEW MONTGOMERY ST   \n",
       "23              01/28/1994               NaN       79 NEW MONTGOMERY ST   \n",
       "24              10/02/2009               NaN       79 NEW MONTGOMERY ST   \n",
       "25              06/09/1998               NaN       79 NEW MONTGOMERY ST   \n",
       "26              08/11/2005               NaN       79 NEW MONTGOMERY ST   \n",
       "27              03/01/1999               NaN       79 NEW MONTGOMERY ST   \n",
       "28              01/02/2011               NaN       79 NEW MONTGOMERY ST   \n",
       "29              01/02/2011               NaN       79 NEW MONTGOMERY ST   \n",
       "...                    ...               ...                        ...   \n",
       "161992          01/01/1990               NaN               1233 4TH AVE   \n",
       "161993          03/27/2015               NaN             507 VICENTE ST   \n",
       "161994          01/26/2016               NaN  235 MONTGOMERY ST STE 350   \n",
       "161995          01/31/2016               NaN             5330 NORMA WAY   \n",
       "161996          01/01/2014               NaN              PO BOX 641045   \n",
       "161997          07/15/2015               NaN               215 23RD AVE   \n",
       "161998          01/26/2016               NaN  235 MONTGOMERY ST STE 350   \n",
       "161999          07/01/2015               NaN              1630 47TH AVE   \n",
       "162000          01/27/2016               NaN         599 3RD ST APT 303   \n",
       "162001          02/01/2016               NaN             42 VALERTON CT   \n",
       "162002          01/01/2014               NaN              PO BOX 641045   \n",
       "162003          01/01/2014               NaN        843 HAYES ST UNIT A   \n",
       "162004          02/01/2016               NaN            250 RANDOLPH ST   \n",
       "162005          11/15/2015        11/15/2015     8201 BEVERLY BLVD #600   \n",
       "162006          11/28/2012               NaN              2031 BAKER ST   \n",
       "162007          01/21/2016               NaN        475 WARREN DR APT 6   \n",
       "162008          01/19/2016               NaN              1566 27TH AVE   \n",
       "162009          01/01/2014               NaN              PO BOX 641045   \n",
       "162010          01/26/2016               NaN  235 MONTGOMERY ST STE 350   \n",
       "162011          01/25/2016               NaN  2269 CHESTBUT ST UNIT 860   \n",
       "162012          12/11/2015               NaN              615 MAPLE AVE   \n",
       "162013          02/01/2016               NaN            4413 KIRKHAM ST   \n",
       "162014          01/15/2016               NaN     530 DIVISADERO ST #153   \n",
       "162015          01/01/2014               NaN              PO BOX 641045   \n",
       "162016          02/01/2016               NaN            1049 FILBERT ST   \n",
       "162017          01/19/2016               NaN                314 PARK ST   \n",
       "162018          02/01/2016               NaN              2170 36TH AVE   \n",
       "162019          01/25/2016               NaN       170 KING ST UNIT 307   \n",
       "162020          01/01/2014               NaN              PO BOX 641045   \n",
       "162021          10/01/2014               NaN       601 DIAMOND ST APT A   \n",
       "\n",
       "                  Mail_City_State_Zip  \\\n",
       "0             ROCHESTER NY 14650-0904   \n",
       "1         SAN FRANCISCO CA 94115-2513   \n",
       "2         SAN FRANCISCO CA 94116-1942   \n",
       "3             SAN FRANCISCO CA 94118-   \n",
       "4             SAN FRANCISCO CA 94118-   \n",
       "5             SAN FRANCISCO CA 94118-   \n",
       "6             SAN FRANCISCO CA 94118-   \n",
       "7                  HARTFORD CT 06103-   \n",
       "8                  HARTFORD CT 06103-   \n",
       "9         SAN FRANCISCO CA 94110-1407   \n",
       "10        SAN FRANCISCO CA 94118-3305   \n",
       "11        SAN FRANCISCO CA 94118-3305   \n",
       "12        SAN FRANCISCO CA 94124-1143   \n",
       "13        SAN FRANCISCO CA 94124-2326   \n",
       "14        SAN FRANCISCO CA 94124-2326   \n",
       "15            VACAVILLE CA 95688-8705   \n",
       "16        SAN FRANCISCO CA 94107-0000   \n",
       "17        SAN FRANCISCO CA 94107-0000   \n",
       "18            SAN FRANCISCO CA 94105-   \n",
       "19            SAN FRANCISCO CA 94105-   \n",
       "20            SAN FRANCISCO CA 94105-   \n",
       "21            SAN FRANCISCO CA 94105-   \n",
       "22            SAN FRANCISCO CA 94105-   \n",
       "23            SAN FRANCISCO CA 94105-   \n",
       "24            SAN FRANCISCO CA 94105-   \n",
       "25            SAN FRANCISCO CA 94105-   \n",
       "26            SAN FRANCISCO CA 94105-   \n",
       "27            SAN FRANCISCO CA 94105-   \n",
       "28            SAN FRANCISCO CA 94105-   \n",
       "29            SAN FRANCISCO CA 94105-   \n",
       "...                               ...   \n",
       "161992    SAN FRANCISCO CA 94122-2601   \n",
       "161993        SAN FRANCISCO CA 94116-   \n",
       "161994        SAN FRANCISCO CA 94104-   \n",
       "161995            LIVERMORE CA 94550-   \n",
       "161996        SAN FRANCISCO CA 94164-   \n",
       "161997        SAN FRANCISCO CA 94121-   \n",
       "161998        SAN FRANCISCO CA 94104-   \n",
       "161999        SAN FRANCISCO CA 94122-   \n",
       "162000        SAN FRANCISCO CA 94107-   \n",
       "162001        SAN FRANCISCO CA 94112-   \n",
       "162002        SAN FRANCISCO CA 94164-   \n",
       "162003        SAN FRANCISCO CA 94117-   \n",
       "162004        SAN FRANCISCO CA 94132-   \n",
       "162005          LOS ANGELES CA 90048-   \n",
       "162006        SAN FRANCISCO CA 94115-   \n",
       "162007        SAN FRANCISCO CA 94131-   \n",
       "162008        SAN FRANCISCO CA 94122-   \n",
       "162009        SAN FRANCISCO CA 94164-   \n",
       "162010        SAN FRANCISCO CA 94104-   \n",
       "162011        SAN FRANCISCO CA 94123-   \n",
       "162012  SOUTH SAN FRANCISCO CA 94080-   \n",
       "162013        SAN FRANCISCO CA 94122-   \n",
       "162014        SAN FRANCISCO CA 94117-   \n",
       "162015        SAN FRANCISCO CA 94164-   \n",
       "162016        SAN FRANCISCO CA 94133-   \n",
       "162017        SAN FRANCISCO CA 94110-   \n",
       "162018        SAN FRANCISCO CA 94116-   \n",
       "162019        SAN FRANCISCO CA 94107-   \n",
       "162020        SAN FRANCISCO CA 94164-   \n",
       "162021        SAN FRANCISCO CA 94114-   \n",
       "\n",
       "                                        Business_Location  \n",
       "0       343 STATE ST\\nROCHESTER, NY 14650\\n(43.161198,...  \n",
       "1       3101 LAGUNA ST\\nSan Francisco, CA 94123\\n(37.7...  \n",
       "2       8 MENDOSA AVE\\nSan Francisco, CA 94116\\n(37.74...  \n",
       "3       1842 JEFFERSON ST\\nSan Francisco, CA 94123\\n(3...  \n",
       "4       3301 BRODERICK ST\\nSan Francisco, CA 94123\\n(3...  \n",
       "5       3301 BRODERICK ST\\nSan Francisco, CA 94123\\n(3...  \n",
       "6         1840 42 JEFFERSON ST\\nSan Francisco, CA 94109\\n  \n",
       "7       1601 GRANT AVE\\nSan Francisco, CA 94133\\n(37.8...  \n",
       "8       1601 GRANT AVE\\nSan Francisco, CA 94133\\n(37.8...  \n",
       "9       1850 BRYANT ST\\nSan Francisco, CA 94110\\n(37.7...  \n",
       "10      2900 GEARY BLVD\\nSan Francisco, CA 94118\\n(37....  \n",
       "11      2900 GEARY BLVD\\nSan Francisco, CA 94118\\n(37....  \n",
       "12      1650 DAVIDSON AVE\\nSan Francisco, CA 94124\\n(3...  \n",
       "13      1727 OAKDALE AVE\\nSan Francisco, CA 94124\\n(37...  \n",
       "14      1727 OAKDALE AVE\\nSan Francisco, CA 94124\\n(37...  \n",
       "15      811 CESAR CHAVEZ ST\\nSan Francisco, CA 94124\\n...  \n",
       "16      868 FOLSOM ST\\nSan Francisco, CA 94107\\n(37.78...  \n",
       "17      868 FOLSOM ST\\nSan Francisco, CA 94107\\n(37.78...  \n",
       "18      79 NEW MONTGOMERY ST\\nSan Francisco, CA 94105\\...  \n",
       "19      79 NEW MONTGOMERY ST\\nSan Francisco, CA 94105\\...  \n",
       "20      410 BUSH ST\\nSan Francisco, CA 94108\\n(37.7906...  \n",
       "21      2225 JERROLD AVE\\nSan Francisco, CA 94124\\n(37...  \n",
       "22      180 NEW MONTGOMERY ST\\nSan Francisco, CA 94105...  \n",
       "23      540 POWELL ST\\nSan Francisco, CA 94108\\n(37.78...  \n",
       "24      460 TOWNSEND ST\\nSan Francisco, CA 94107\\n(37....  \n",
       "25      1835 49 VAN NESS AVE\\nSan Francisco, CA 94109\\...  \n",
       "26      620 SUTTER ST\\nSan Francisco, CA 94102\\n(37.78...  \n",
       "27      655 SUTTER ST\\nSan Francisco, CA 94102\\n(37.78...  \n",
       "28      1055 PINE ST\\nSan Francisco, CA 94109\\n(37.790...  \n",
       "29      121 WISCONSIN ST\\nSan Francisco, CA 94107\\n(37...  \n",
       "...                                                   ...  \n",
       "161992  159 19TH AVE\\nSAN FRANCISCO, CA 94121\\n(37.784...  \n",
       "161993  507 VICENTE ST\\nSAN FRANCISCO, CA 94116\\n(37.7...  \n",
       "161994  235 MONTGOMERY ST\\nSAN FRANCISCO, CA 94104\\n(3...  \n",
       "161995           800 AVENUE H TREASURE ISLAND\\nCA 94130\\n  \n",
       "161996  1111 1133 GREEN ST\\nSAN FRANCISCO, CA 94109\\n(...  \n",
       "161997  215 23RD AVE\\nSAN FRANCISCO, CA 94121\\n(37.783...  \n",
       "161998  235 MONTGOMERY ST\\nSAN FRANCISCO, CA 94104\\n(3...  \n",
       "161999  1630 47TH AVE\\nSAN FRANCISCO, CA 94122\\n(37.75...  \n",
       "162000  599 3RD ST\\nSAN FRANCISCO, CA 94107\\n(37.78023...  \n",
       "162001  42 VALERTON CT\\nSAN FRANCISCO, CA 94112\\n(37.7...  \n",
       "162002  7 19 LEROY PLACE\\nSAN FRANCISCO, CA 94109\\n(37...  \n",
       "162003  843 HAYES ST\\nA SAN FRANCISCO, CA 94117\\n(37.7...  \n",
       "162004  250 RANDOLPH ST\\nSAN FRANCISCO, CA 94132\\n(37....  \n",
       "162005  3046 CALIFORNIA ST\\nSAN FRANCISCO, CA 94115\\n(...  \n",
       "162006  2031 BAKER ST\\nSAN FRANCISCO, CA 94115\\n(37.78...  \n",
       "162007  475 WARREN DR\\nSAN FRANCISCO, CA 94131\\n(37.75...  \n",
       "162008  1566 27TH AVE\\nSAN FRANCISCO, CA 94122\\n(37.75...  \n",
       "162009  1307 1329 STEVENSON ST\\nSAN FRANCISCO, CA 9410...  \n",
       "162010  235 MONTGOMERY ST\\nSAN FRANCISCO, CA 94104\\n(3...  \n",
       "162011        2269 CHESTBUT ST\\nSAN FRANCISCO, CA 94123\\n  \n",
       "162012  18 RAMSELL ST\\nSAN FRANCISCO, CA 94132\\n(37.71...  \n",
       "162013  4413 KIRKHAM ST\\nSAN FRANCISCO, CA 94122\\n(37....  \n",
       "162014  2201 MARKET ST\\nSAN FRANCISCO, CA 94114\\n(37.7...  \n",
       "162015  1086 POST ST\\nSAN FRANCISCO, CA 94109\\n(37.786...  \n",
       "162016  1049 FILBERT ST\\nSAN FRANCISCO, CA 94133\\n(37....  \n",
       "162017  314 PARK ST\\nSAN FRANCISCO, CA 94110\\n(37.7364...  \n",
       "162018  2170 36TH AVE\\nSAN FRANCISCO, CA 94116\\n(37.74...  \n",
       "162019  170 KING ST\\nSAN FRANCISCO, CA 94107\\n(37.7786...  \n",
       "162020  3735 ANZA ST\\nSAN FRANCISCO, CA 94121\\n(37.778...  \n",
       "162021  601 DIAMOND ST\\nAPT A SAN FRANCISCO, CA 94114\\...  \n",
       "\n",
       "[162022 rows x 15 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "grouped = data['City'].groupby(data['Zip_Code'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "grouped = grouped.count().sort_values()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "grouped.to_csv('bizperzip.csv')"
   ]
  },
  {
   "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.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}