fuzzy-group.ipynb

{
  "cells": [
    {
      "metadata": {},
      "cell_type": "markdown",
      "source": "# Fuzzy grouping\nCopyright (c) Microsoft Corporation. All rights reserved.<br>\nLicensed under the MIT License.<br>\n\nDataPrep also provides a way to canonicalize strings in a column.\n"
    },
    {
      "metadata": {
        "trusted": true
      },
      "cell_type": "code",
      "source": "import azureml.dataprep as dprep",
      "execution_count": 1,
      "outputs": []
    },
    {
      "metadata": {
        "scrolled": true,
        "trusted": true
      },
      "cell_type": "code",
      "source": "dataflow = dprep.read_json(path='./data/json.json', )\ndataflow.head(5)",
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 2,
          "data": {
            "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>inspections.business.business_id</th>\n      <th>inspections.business.name</th>\n      <th>inspections.business.address</th>\n      <th>inspections.business.city</th>\n      <th>inspections.business.postal_code</th>\n      <th>inspections.business.latitude</th>\n      <th>inspections.business.longitude</th>\n      <th>inspections.business.phone_number</th>\n      <th>inspections.business.TaxCode</th>\n      <th>inspections.business.business_certificate</th>\n      <th>inspections.business.application_date</th>\n      <th>inspections.business.owner_name</th>\n      <th>inspections.business.owner_address</th>\n      <th>inspections.Score</th>\n      <th>inspections.date</th>\n      <th>inspections.type</th>\n      <th>inspections.violations</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>16162</td>\n      <td>Quick-N-Ezee Indian Foods</td>\n      <td>3861 24th St</td>\n      <td>SF</td>\n      <td>94114</td>\n      <td></td>\n      <td></td>\n      <td></td>\n      <td>H34</td>\n      <td>467114</td>\n      <td>May  9 2005 12:00AM</td>\n      <td>Jagpreet Enterprises</td>\n      <td>23682 Clawiter Road\\n Hayward\\n CA\\n 94545</td>\n      <td>100</td>\n      <td>20130223</td>\n      <td>Routine - Unscheduled</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>69707</td>\n      <td>Little Green Cyclo 2</td>\n      <td>Off The Grid</td>\n      <td></td>\n      <td></td>\n      <td></td>\n      <td></td>\n      <td></td>\n      <td>H79</td>\n      <td>453248</td>\n      <td>Jul 12 2012 12:00AM</td>\n      <td>LITTLEGREENCYCLO LLC</td>\n      <td>100 Esplanade Ave., Apt. 99\\n Pacifica\\n CA\\n ...</td>\n      <td>93</td>\n      <td>20130224</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103112: No hot water or runni...</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>67565</td>\n      <td>King of Thai Noodles Cafe</td>\n      <td>1541 TARAVAL St</td>\n      <td>SAN FRANCISCO</td>\n      <td>94116</td>\n      <td>37.7427</td>\n      <td>-122.483</td>\n      <td></td>\n      <td>H25</td>\n      <td></td>\n      <td>Oct 12 2011 12:00AM</td>\n      <td>Royal Thai Noodles, Inc</td>\n      <td>2410 19th Ave\\n SF\\n CA\\n 94116</td>\n      <td>79</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103139: Improper food storage...</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>67565</td>\n      <td>King of Thai Noodles Cafe</td>\n      <td>1541 TARAVAL St</td>\n      <td>SAN FRANCISCO</td>\n      <td>94116</td>\n      <td>37.7427</td>\n      <td>-122.483</td>\n      <td></td>\n      <td>H25</td>\n      <td></td>\n      <td>Oct 12 2011 12:00AM</td>\n      <td>Royal Thai Noodles, Inc</td>\n      <td>2410 19th Ave\\n SF\\n CA\\n 94116</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Complaint</td>\n      <td>[{\"description\":\"103139: Improper food storage...</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>68701</td>\n      <td>Grindz</td>\n      <td>832 Clement St</td>\n      <td>SF</td>\n      <td>94118</td>\n      <td>37.7828</td>\n      <td>-122.468</td>\n      <td></td>\n      <td>H25</td>\n      <td>467498</td>\n      <td>Mar 16 2012 12:00AM</td>\n      <td>Ono Grindz, LLC</td>\n      <td>1055 Granada St.\\n Vallejo\\n CA\\n 94591</td>\n      <td>100</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[]</td>\n    </tr>\n  </tbody>\n</table>\n</div>",
            "text/plain": "  inspections.business.business_id  inspections.business.name  \\\n0                            16162  Quick-N-Ezee Indian Foods   \n1                            69707       Little Green Cyclo 2   \n2                            67565  King of Thai Noodles Cafe   \n3                            67565  King of Thai Noodles Cafe   \n4                            68701                     Grindz   \n\n  inspections.business.address inspections.business.city  \\\n0                3861 24th St                         SF   \n1               Off The Grid                               \n2             1541 TARAVAL St              SAN FRANCISCO   \n3             1541 TARAVAL St              SAN FRANCISCO   \n4              832 Clement St                         SF   \n\n  inspections.business.postal_code inspections.business.latitude  \\\n0                            94114                                 \n1                                                                  \n2                            94116                       37.7427   \n3                            94116                       37.7427   \n4                            94118                       37.7828   \n\n  inspections.business.longitude inspections.business.phone_number  \\\n0                                                                    \n1                                                                    \n2                       -122.483                                     \n3                       -122.483                                     \n4                       -122.468                                     \n\n  inspections.business.TaxCode inspections.business.business_certificate  \\\n0                          H34                                    467114   \n1                          H79                                    453248   \n2                          H25                                             \n3                          H25                                             \n4                          H25                                    467498   \n\n  inspections.business.application_date inspections.business.owner_name  \\\n0                   May  9 2005 12:00AM            Jagpreet Enterprises   \n1                   Jul 12 2012 12:00AM            LITTLEGREENCYCLO LLC   \n2                   Oct 12 2011 12:00AM         Royal Thai Noodles, Inc   \n3                   Oct 12 2011 12:00AM         Royal Thai Noodles, Inc   \n4                   Mar 16 2012 12:00AM                 Ono Grindz, LLC   \n\n                  inspections.business.owner_address inspections.Score  \\\n0         23682 Clawiter Road\\n Hayward\\n CA\\n 94545               100   \n1  100 Esplanade Ave., Apt. 99\\n Pacifica\\n CA\\n ...                93   \n2                    2410 19th Ave\\n SF\\n CA\\n 94116                79   \n3                    2410 19th Ave\\n SF\\n CA\\n 94116                     \n4            1055 Granada St.\\n Vallejo\\n CA\\n 94591               100   \n\n  inspections.date       inspections.type  \\\n0         20130223  Routine - Unscheduled   \n1         20130224  Routine - Unscheduled   \n2         20130225  Routine - Unscheduled   \n3         20130225              Complaint   \n4         20130225  Routine - Unscheduled   \n\n                              inspections.violations  \n0                                                 []  \n1  [{\"description\":\"103112: No hot water or runni...  \n2  [{\"description\":\"103139: Improper food storage...  \n3  [{\"description\":\"103139: Improper food storage...  \n4                                                 []  "
          },
          "metadata": {}
        }
      ]
    },
    {
      "metadata": {},
      "cell_type": "markdown",
      "source": "For a simple case, where you just want to add a column with values brought to the automatically detected cacnonical form, you can call fuzzy_group_column() on an existing dataflow:"
    },
    {
      "metadata": {
        "trusted": true
      },
      "cell_type": "code",
      "source": "dataflow2 = dataflow.fuzzy_group_column(source_column='inspections.business.city',\n                                        new_column_name='city_grouped',\n                                        similarity_threshold=0.8,\n                                        similarity_score_column_name='similarity_score')\ndataflow2.head(100)",
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 3,
          "data": {
            "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>inspections.business.business_id</th>\n      <th>inspections.business.name</th>\n      <th>inspections.business.address</th>\n      <th>inspections.business.city</th>\n      <th>city_grouped</th>\n      <th>similarity_score</th>\n      <th>inspections.business.postal_code</th>\n      <th>inspections.business.latitude</th>\n      <th>inspections.business.longitude</th>\n      <th>inspections.business.phone_number</th>\n      <th>inspections.business.TaxCode</th>\n      <th>inspections.business.business_certificate</th>\n      <th>inspections.business.application_date</th>\n      <th>inspections.business.owner_name</th>\n      <th>inspections.business.owner_address</th>\n      <th>inspections.Score</th>\n      <th>inspections.date</th>\n      <th>inspections.type</th>\n      <th>inspections.violations</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>16162</td>\n      <td>Quick-N-Ezee Indian Foods</td>\n      <td>3861 24th St</td>\n      <td>SF</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94114</td>\n      <td></td>\n      <td></td>\n      <td></td>\n      <td>H34</td>\n      <td>467114</td>\n      <td>May  9 2005 12:00AM</td>\n      <td>Jagpreet Enterprises</td>\n      <td>23682 Clawiter Road\\n Hayward\\n CA\\n 94545</td>\n      <td>100</td>\n      <td>20130223</td>\n      <td>Routine - Unscheduled</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>69707</td>\n      <td>Little Green Cyclo 2</td>\n      <td>Off The Grid</td>\n      <td></td>\n      <td></td>\n      <td>NaN</td>\n      <td></td>\n      <td></td>\n      <td></td>\n      <td></td>\n      <td>H79</td>\n      <td>453248</td>\n      <td>Jul 12 2012 12:00AM</td>\n      <td>LITTLEGREENCYCLO LLC</td>\n      <td>100 Esplanade Ave., Apt. 99\\n Pacifica\\n CA\\n ...</td>\n      <td>93</td>\n      <td>20130224</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103112: No hot water or runni...</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>67565</td>\n      <td>King of Thai Noodles Cafe</td>\n      <td>1541 TARAVAL St</td>\n      <td>SAN FRANCISCO</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94116</td>\n      <td>37.7427</td>\n      <td>-122.483</td>\n      <td></td>\n      <td>H25</td>\n      <td></td>\n      <td>Oct 12 2011 12:00AM</td>\n      <td>Royal Thai Noodles, Inc</td>\n      <td>2410 19th Ave\\n SF\\n CA\\n 94116</td>\n      <td>79</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103139: Improper food storage...</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>67565</td>\n      <td>King of Thai Noodles Cafe</td>\n      <td>1541 TARAVAL St</td>\n      <td>SAN FRANCISCO</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94116</td>\n      <td>37.7427</td>\n      <td>-122.483</td>\n      <td></td>\n      <td>H25</td>\n      <td></td>\n      <td>Oct 12 2011 12:00AM</td>\n      <td>Royal Thai Noodles, Inc</td>\n      <td>2410 19th Ave\\n SF\\n CA\\n 94116</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Complaint</td>\n      <td>[{\"description\":\"103139: Improper food storage...</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>68701</td>\n      <td>Grindz</td>\n      <td>832 Clement St</td>\n      <td>SF</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94118</td>\n      <td>37.7828</td>\n      <td>-122.468</td>\n      <td></td>\n      <td>H25</td>\n      <td>467498</td>\n      <td>Mar 16 2012 12:00AM</td>\n      <td>Ono Grindz, LLC</td>\n      <td>1055 Granada St.\\n Vallejo\\n CA\\n 94591</td>\n      <td>100</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>69186</td>\n      <td>Premier Catering &amp; Events, Inc.</td>\n      <td>1255 22nd St</td>\n      <td>S.F.</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94107</td>\n      <td></td>\n      <td></td>\n      <td>14155530288</td>\n      <td>H30</td>\n      <td>362812</td>\n      <td>Apr 30 2012 12:00AM</td>\n      <td>Premier Catering &amp; Events, Inc.</td>\n      <td>298 Magellan Ave.\\n SF\\n CA\\n 94116</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td>2689</td>\n      <td>THE BLUE PLATE</td>\n      <td>3218 MISSION St</td>\n      <td>SF</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94110</td>\n      <td>37.7452</td>\n      <td>-122.42</td>\n      <td>14155286777</td>\n      <td>H25</td>\n      <td>325714</td>\n      <td></td>\n      <td>BLUE ENCLAVE LLC</td>\n      <td>3218 MISSION ST.\\n SAN FRANCISCO\\n CA\\n 94110</td>\n      <td>98</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103143: Inadequate warewashin...</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>15806</td>\n      <td>Vital Tea Leaf</td>\n      <td>1044 Grant Ave</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94133</td>\n      <td>37.7966</td>\n      <td>-122.407</td>\n      <td></td>\n      <td>H24</td>\n      <td>388301</td>\n      <td>May 23 2005 12:00AM</td>\n      <td>Minh H. Duong</td>\n      <td>1044 Grant Ave\\n San Francisco\\n CA\\n 94133</td>\n      <td>98</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103157: Food safety certifica...</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>21807</td>\n      <td>The Front Porch</td>\n      <td>65 29th St A</td>\n      <td>SF</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94110</td>\n      <td>37.7439</td>\n      <td>-122.422</td>\n      <td></td>\n      <td>H25</td>\n      <td>398500</td>\n      <td>Jun  7 2006 12:00AM</td>\n      <td>Front Porch Restaurant LLC</td>\n      <td>65A 29th Street\\n SF\\n CA\\n 94110</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>69041</td>\n      <td>Washington Cafe</td>\n      <td>826 Washington St</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94108</td>\n      <td>37.7951</td>\n      <td>-122.407</td>\n      <td></td>\n      <td>H26</td>\n      <td>468548</td>\n      <td>Apr 18 2012 12:00AM</td>\n      <td>Washington Caf�, Inc. / Louis Kuang</td>\n      <td>333 Third Avenue\\n Daly City\\n CA\\n 94014</td>\n      <td>65</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103120: Moderate risk food ho...</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td>6018</td>\n      <td>3RD BAPTIST FELLOWSHIP HALL</td>\n      <td>1399 MCALLISTER St</td>\n      <td>SAN FRANCISCO</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94115</td>\n      <td>37.7782</td>\n      <td>-122.435</td>\n      <td></td>\n      <td>AA</td>\n      <td></td>\n      <td></td>\n      <td>3RD BAPTIST FELLOWSHIP HALL</td>\n      <td>1399 MC ALLISTER STREET\\n SAN FRANCISCO\\n CA\\n...</td>\n      <td>98</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103143: Inadequate warewashin...</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td>23702</td>\n      <td>Doo Bu Restaurant</td>\n      <td>1723 Buchanan St</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94115</td>\n      <td>37.786</td>\n      <td>-122.43</td>\n      <td></td>\n      <td>H25</td>\n      <td>205289</td>\n      <td>Jun 30 2006 12:00AM</td>\n      <td>Jung Un Hong</td>\n      <td>1723 Buchanan St\\n San Francisco\\n CA\\n 94115</td>\n      <td>90</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103154: Unclean or degraded f...</td>\n    </tr>\n    <tr>\n      <th>12</th>\n      <td>23702</td>\n      <td>Doo Bu Restaurant</td>\n      <td>1723 Buchanan St</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94115</td>\n      <td>37.786</td>\n      <td>-122.43</td>\n      <td></td>\n      <td>H25</td>\n      <td>205289</td>\n      <td>Jun 30 2006 12:00AM</td>\n      <td>Jung Un Hong</td>\n      <td>1723 Buchanan St\\n San Francisco\\n CA\\n 94115</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Complaint</td>\n      <td>[{\"description\":\"103154: Unclean or degraded f...</td>\n    </tr>\n    <tr>\n      <th>13</th>\n      <td>34244</td>\n      <td>Vital Tea Leaf Inc</td>\n      <td>905 Grant Ave</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94108</td>\n      <td>37.7953</td>\n      <td>-122.407</td>\n      <td></td>\n      <td>H25</td>\n      <td>417300</td>\n      <td>May 17 2007 12:00AM</td>\n      <td>Vital Tea Leaf Inc   Minh Hong Duong</td>\n      <td>905 Grant Ave\\n San Francisco\\n CA\\n 94108</td>\n      <td>100</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>14</th>\n      <td>63503</td>\n      <td>Mason Street Deli and Market</td>\n      <td>39 MASON</td>\n      <td>SF</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94102</td>\n      <td>37.7841</td>\n      <td>-122.409</td>\n      <td>14155624312</td>\n      <td>H07</td>\n      <td>450988</td>\n      <td>Jun 28 2010 12:00AM</td>\n      <td>Hifdallah Ahmed Homran and Arkan Ali Hassan Al...</td>\n      <td>39 Mason Street\\n San Francisco\\n CA\\n 94102</td>\n      <td>100</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>15</th>\n      <td>1427</td>\n      <td>MIFUNE DON</td>\n      <td>22 PEACE PLAZA  275</td>\n      <td>SF</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94115</td>\n      <td>37.785</td>\n      <td>-122.43</td>\n      <td>14155341993</td>\n      <td>H24</td>\n      <td>314685</td>\n      <td></td>\n      <td>Osaka Eiko, Inc</td>\n      <td>22 PEACE PLAZA, #275\\n SF\\n CA\\n 94115</td>\n      <td>86</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103102: Unclean hands or impr...</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td>3331</td>\n      <td>HARVEY'S</td>\n      <td>500 CASTRO St</td>\n      <td>SAN FRANCISCO</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94114</td>\n      <td>37.7607</td>\n      <td>-122.435</td>\n      <td>14155434278</td>\n      <td>H26</td>\n      <td>945743</td>\n      <td></td>\n      <td>LANGLEY ENTERPRISES</td>\n      <td>500 CASTRO ST\\n SF\\n CA\\n 94114</td>\n      <td>83</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103149: Wiping cloths not cle...</td>\n    </tr>\n    <tr>\n      <th>17</th>\n      <td>5907</td>\n      <td>LILIENTHAL ELEMENTARY SCHOOL</td>\n      <td>3630 DIVISADERO St</td>\n      <td>S.F.</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94118</td>\n      <td>37.8035</td>\n      <td>-122.444</td>\n      <td>14155743516</td>\n      <td>H91</td>\n      <td></td>\n      <td></td>\n      <td>San Francisco Unified School District</td>\n      <td>3630 Divisadero Street\\n San Francisco\\n CA\\n ...</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>18</th>\n      <td>65050</td>\n      <td>House of Banquet</td>\n      <td>939 Clement St</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94118</td>\n      <td>37.7827</td>\n      <td>-122.469</td>\n      <td>14155780203</td>\n      <td>H26</td>\n      <td>455173</td>\n      <td>Jan 11 2011 12:00AM</td>\n      <td>LYS Trading, Inc. / Yong Shong</td>\n      <td>939 Clement Street\\n San Francisco\\n CA\\n 94118</td>\n      <td>87</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103149: Wiping cloths not cle...</td>\n    </tr>\n    <tr>\n      <th>19</th>\n      <td>71534</td>\n      <td>7 Eleven #2366-36039A</td>\n      <td>644 Mission St</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94105</td>\n      <td></td>\n      <td></td>\n      <td>14155610309</td>\n      <td>H07</td>\n      <td>475970</td>\n      <td>Jan 24 2013 12:00AM</td>\n      <td>Bhrighu Muniwar, Inc.</td>\n      <td>538 Pyramid Ct.\\n Fairfield\\n CA\\n 94534</td>\n      <td>100</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>20</th>\n      <td>71769</td>\n      <td>Lucky One Mini Mart</td>\n      <td>1010 Market St</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94102</td>\n      <td>37.7819</td>\n      <td>-122.411</td>\n      <td></td>\n      <td>H24</td>\n      <td>473612</td>\n      <td>Feb 15 2013 12:00AM</td>\n      <td>Charles Ahn</td>\n      <td>1010 Market Street\\n San Francisco\\n CA\\n 94102</td>\n      <td>100</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>21</th>\n      <td>5884</td>\n      <td>Gordon J Lau Elementary School</td>\n      <td>950 Clay St</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94108</td>\n      <td>37.794</td>\n      <td>-122.409</td>\n      <td></td>\n      <td>H91</td>\n      <td></td>\n      <td></td>\n      <td>S.F. Unified School District</td>\n      <td>950  Clay St\\n San Francisco\\n CA\\n 94108</td>\n      <td>96</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103120: Moderate risk food ho...</td>\n    </tr>\n    <tr>\n      <th>22</th>\n      <td>69635</td>\n      <td>Sophie's Crepes</td>\n      <td>1581 Webster St 275</td>\n      <td>S.F.</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94115</td>\n      <td></td>\n      <td></td>\n      <td></td>\n      <td>H28</td>\n      <td>470456</td>\n      <td>Jul  5 2012 12:00AM</td>\n      <td>Sophie's Crepes, LLC</td>\n      <td>1581 Webster St., #275\\n SF\\n CA\\n 94115</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Non-inspection site visit</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>23</th>\n      <td>3633</td>\n      <td>Magnolia Pub &amp; Brewery</td>\n      <td>1398 Haight St</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94117</td>\n      <td>37.7703</td>\n      <td>-122.445</td>\n      <td></td>\n      <td>H26</td>\n      <td>306120</td>\n      <td></td>\n      <td>McLean Breweries, Inc</td>\n      <td>1398 Haight St\\n San Francisco\\n CA\\n 94117</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>24</th>\n      <td>5905</td>\n      <td>MARINA MIDDLE SCHOOL</td>\n      <td>3500 FILLMORE St</td>\n      <td>S.F.</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94123</td>\n      <td>37.8018</td>\n      <td>-122.436</td>\n      <td>14155743495</td>\n      <td>H91</td>\n      <td></td>\n      <td></td>\n      <td>San Francisco Unified School district</td>\n      <td>3500 Fillmore Street\\n San Francisco\\n CA\\n 94123</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>25</th>\n      <td>19277</td>\n      <td>Farmer Brown</td>\n      <td>25 Mason St</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94102</td>\n      <td>37.7837</td>\n      <td>-122.409</td>\n      <td></td>\n      <td>H26</td>\n      <td>397481</td>\n      <td>Apr 20 2006 12:00AM</td>\n      <td>Black Rabbit Hospitality</td>\n      <td>25 Mason St\\n San Francisco\\n CA\\n 94102</td>\n      <td>100</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>26</th>\n      <td>1775</td>\n      <td>Sapporo-Ya</td>\n      <td>1581 WEBSTER St</td>\n      <td>SF</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94115</td>\n      <td>37.7852</td>\n      <td>-122.431</td>\n      <td>14155567400</td>\n      <td>H25</td>\n      <td>98407</td>\n      <td></td>\n      <td>TURNER SHIBATA INC.</td>\n      <td>1581 WEBSTER ST\\n SF\\n CA\\n 94115</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>27</th>\n      <td>61135</td>\n      <td>Old Mandarin Islamic Restaurant</td>\n      <td>3132 VICENTE St</td>\n      <td>SF</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94116</td>\n      <td>37.7382</td>\n      <td>-122.501</td>\n      <td></td>\n      <td>H24</td>\n      <td>442429</td>\n      <td>Sep 14 2009 12:00AM</td>\n      <td>Shuai Yang</td>\n      <td>3132 Vicente St.\\n SF\\n CA\\n 94116</td>\n      <td>84</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103144: Unapproved or unmaint...</td>\n    </tr>\n    <tr>\n      <th>28</th>\n      <td>765</td>\n      <td>APERTO RESTAURANT</td>\n      <td>1434 18th St</td>\n      <td>S.F.</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94107</td>\n      <td>37.7626</td>\n      <td>-122.397</td>\n      <td></td>\n      <td>H24</td>\n      <td>921479</td>\n      <td>Apr 16 1992 12:00AM</td>\n      <td>APERTO INC.</td>\n      <td>245 LAWTON ST.\\n S.F.\\n CA\\n 94122</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>29</th>\n      <td>3373</td>\n      <td>New Delhi Restaurant</td>\n      <td>160 Ellis St</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94102</td>\n      <td>37.7855</td>\n      <td>-122.409</td>\n      <td></td>\n      <td>H26</td>\n      <td>173398</td>\n      <td></td>\n      <td>New Delhi Restaurant</td>\n      <td>160 Ellis St\\n San Francisco\\n CA\\n 94102</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>30</th>\n      <td>3373</td>\n      <td>New Delhi Restaurant</td>\n      <td>160 Ellis St</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94102</td>\n      <td>37.7855</td>\n      <td>-122.409</td>\n      <td></td>\n      <td>H26</td>\n      <td>173398</td>\n      <td></td>\n      <td>New Delhi Restaurant</td>\n      <td>160 Ellis St\\n San Francisco\\n CA\\n 94102</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>31</th>\n      <td>33891</td>\n      <td>Harlot</td>\n      <td>46 Minna St</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94105</td>\n      <td>37.7887</td>\n      <td>-122.398</td>\n      <td></td>\n      <td>H87</td>\n      <td>404920</td>\n      <td>Apr 26 2007 12:00AM</td>\n      <td>Vespertine, Inc   Robert Nunez</td>\n      <td>46 Minna Street\\n San Francisco\\n CA\\n 94105</td>\n      <td>87</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103119: Inadequate and inacce...</td>\n    </tr>\n    <tr>\n      <th>32</th>\n      <td>28828</td>\n      <td>The Sandwich Shop</td>\n      <td>635 19th St</td>\n      <td>S.F.</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94107</td>\n      <td>37.7617</td>\n      <td>-122.389</td>\n      <td></td>\n      <td>H28</td>\n      <td>402498</td>\n      <td>Oct 11 2006 12:00AM</td>\n      <td>Hye Hwa Cho</td>\n      <td>635 19th Street\\n SF\\n CA\\n 94107</td>\n      <td>88</td>\n      <td>20130226</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103124: Inadequately cleaned ...</td>\n    </tr>\n    <tr>\n      <th>33</th>\n      <td>60933</td>\n      <td>Mayes</td>\n      <td>1233 Polk St</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94109</td>\n      <td>37.7883</td>\n      <td>-122.42</td>\n      <td></td>\n      <td>H26</td>\n      <td>441175</td>\n      <td>Aug 27 2009 12:00AM</td>\n      <td>1233 Polk Street LLC   Fred Duncan</td>\n      <td>1233 Polk St\\n San Francisco\\n CA\\n 94109</td>\n      <td>85</td>\n      <td>20130226</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103114: High risk vermin infe...</td>\n    </tr>\n    <tr>\n      <th>34</th>\n      <td>62688</td>\n      <td>Auntie April's</td>\n      <td>4618 03rd St</td>\n      <td>SF</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94124</td>\n      <td>37.7363</td>\n      <td>-122.39</td>\n      <td></td>\n      <td>H24</td>\n      <td>428950</td>\n      <td>Apr  2 2010 12:00AM</td>\n      <td>April Spears</td>\n      <td>4618 3rd Street\\n SF\\n CA\\n 94124</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>35</th>\n      <td>3373</td>\n      <td>New Delhi Restaurant</td>\n      <td>160 Ellis St</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94102</td>\n      <td>37.7855</td>\n      <td>-122.409</td>\n      <td></td>\n      <td>H26</td>\n      <td>173398</td>\n      <td></td>\n      <td>New Delhi Restaurant</td>\n      <td>160 Ellis St\\n San Francisco\\n CA\\n 94102</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>36</th>\n      <td>2756</td>\n      <td>STARBUCKS</td>\n      <td>3595 CALIFORNIA St</td>\n      <td>SF</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94118</td>\n      <td>37.7864</td>\n      <td>-122.453</td>\n      <td></td>\n      <td>H25</td>\n      <td>911744</td>\n      <td>Oct 30 1995 12:00AM</td>\n      <td>STARBUCKS COFFEE CO, INC.</td>\n      <td>3595 CALIFORNIA ST\\n SF\\n CA\\n 94118</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[{\"description\":\"103157: Food safety certifica...</td>\n    </tr>\n    <tr>\n      <th>37</th>\n      <td>7489</td>\n      <td>GAS &amp; SHOP</td>\n      <td>599 South Van Ness Ave</td>\n      <td>S.F.</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94110</td>\n      <td>37.7638</td>\n      <td>-122.417</td>\n      <td>14155866835</td>\n      <td>H10</td>\n      <td>922993</td>\n      <td>Aug 13 1993 12:00AM</td>\n      <td>SELF SERVE PETROLEUM, INC.</td>\n      <td>2240 SKY FARM\\n HILLSBOROUGH\\n CA\\n 94010</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>38</th>\n      <td>19094</td>\n      <td>Rigolo</td>\n      <td>3465 California St</td>\n      <td>SF</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94118</td>\n      <td>37.7867</td>\n      <td>-122.451</td>\n      <td></td>\n      <td>H25</td>\n      <td>373994</td>\n      <td>Mar  1 2004 12:00AM</td>\n      <td>Laurel Village Bakery LLC</td>\n      <td>2132 Pine Street\\n SF\\n CA\\n 94118</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>39</th>\n      <td>65051</td>\n      <td>Mission Cheese</td>\n      <td>736 Valencia St</td>\n      <td>SF</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94110</td>\n      <td>37.7611</td>\n      <td>-122.422</td>\n      <td>14155558667</td>\n      <td>H24</td>\n      <td>455293</td>\n      <td>Jan 11 2011 12:00AM</td>\n      <td>Mission Cheese LLC</td>\n      <td>363 Hermann St.\\n SF\\n CA\\n 94117</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Non-inspection site visit</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>40</th>\n      <td>3802</td>\n      <td>THE GREAT AMERICAN MUSIC HALL</td>\n      <td>859 O'FARRELL St</td>\n      <td>SAN FRANCISCO</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94109</td>\n      <td>37.785</td>\n      <td>-122.419</td>\n      <td></td>\n      <td>H26</td>\n      <td>358240</td>\n      <td></td>\n      <td>MUSIC HALL, LLC</td>\n      <td>859 O'FARRELL St\\n SAN FRANCISCO\\n CA\\n 94109</td>\n      <td>94</td>\n      <td>20130226</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103161: Low risk vermin infes...</td>\n    </tr>\n    <tr>\n      <th>41</th>\n      <td>475</td>\n      <td>Mara's</td>\n      <td>503 Columbus Ave</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94133</td>\n      <td>37.7995</td>\n      <td>-122.409</td>\n      <td></td>\n      <td>H24</td>\n      <td>147903</td>\n      <td></td>\n      <td>Filomena &amp; Gennaro Torrano</td>\n      <td>503 Columbus Ave\\n San Francisco\\n CA\\n 94133</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>42</th>\n      <td>1193</td>\n      <td>PEET'S COFFEES &amp; TEAS</td>\n      <td>3419 CALIFORNIA St</td>\n      <td>SAN FRANCISCO</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94118</td>\n      <td>37.7868</td>\n      <td>-122.45</td>\n      <td></td>\n      <td>H24</td>\n      <td>196325</td>\n      <td></td>\n      <td>Peet's Coffee</td>\n      <td>3419 California\\n SF\\n CA\\n 94118</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>43</th>\n      <td>2548</td>\n      <td>NOAH'S NEW YORK BAGELS #2120</td>\n      <td>3519 CALIFORNIA St</td>\n      <td>SF</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94118</td>\n      <td>37.7866</td>\n      <td>-122.452</td>\n      <td></td>\n      <td>H25</td>\n      <td>353177</td>\n      <td>Mar 15 2002 12:00AM</td>\n      <td>EINSTEIN AND NOAH CORP.</td>\n      <td>555 Zang St., Suite 300\\n Lakewood\\n CO\\n 80228</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>44</th>\n      <td>6913</td>\n      <td>XTRA OIL CORP</td>\n      <td>3750 03rd St</td>\n      <td>S.F.</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94124</td>\n      <td>37.7432</td>\n      <td>-122.388</td>\n      <td></td>\n      <td>H07</td>\n      <td>144903</td>\n      <td>May 17 1993 12:00AM</td>\n      <td>EDWARD T SIMAS</td>\n      <td>2307 PACIFIC AVE.\\n ALAMEDA\\n CA\\n 94501</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>45</th>\n      <td>4923</td>\n      <td>TED'S MARKET</td>\n      <td>1530 HOWARD St</td>\n      <td>S.F.</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94103</td>\n      <td>37.7727</td>\n      <td>-122.416</td>\n      <td></td>\n      <td>H28</td>\n      <td>321004</td>\n      <td></td>\n      <td>ZOUZOUNIS DAVID P</td>\n      <td>1530 HOWARD ST\\n SAN FRANCISCO\\n CA\\n 94103</td>\n      <td>100</td>\n      <td>20130226</td>\n      <td>Routine - Unscheduled</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>46</th>\n      <td>36020</td>\n      <td>Cadillac Market</td>\n      <td>499 Eddy St</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94109</td>\n      <td>37.7835</td>\n      <td>-122.416</td>\n      <td></td>\n      <td>H07</td>\n      <td>379395</td>\n      <td>Oct 29 2007 12:00AM</td>\n      <td>Irfan Barkat Ali</td>\n      <td>499 Eddy St\\n San Francisco\\n CA\\n 94109</td>\n      <td>98</td>\n      <td>20130226</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103143: Inadequate warewashin...</td>\n    </tr>\n    <tr>\n      <th>47</th>\n      <td>3935</td>\n      <td>Le Colonial, SF, LLC</td>\n      <td>20 Cosmo Pl</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94109</td>\n      <td>37.7881</td>\n      <td>-122.412</td>\n      <td></td>\n      <td>H26</td>\n      <td>317110</td>\n      <td></td>\n      <td>Le Colonial, SF, LLC</td>\n      <td>20  Cosmo PL\\n San Francisco\\n CA\\n 94109</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>48</th>\n      <td>1259</td>\n      <td>KD'S GROG &amp; GROCERY</td>\n      <td>2416 MARKET St</td>\n      <td>SF</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94114</td>\n      <td>37.7626</td>\n      <td>-122.435</td>\n      <td>14155863736</td>\n      <td>H24</td>\n      <td>198913</td>\n      <td></td>\n      <td>KIM, SUNG U.</td>\n      <td>2416 MARKET ST.\\n SAN FRANCISCO\\n CA\\n 94114</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>49</th>\n      <td>65396</td>\n      <td>Carmelina's Cafe</td>\n      <td>1855 Folsom St</td>\n      <td>SF</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94103</td>\n      <td>37.7677</td>\n      <td>-122.415</td>\n      <td></td>\n      <td>H24</td>\n      <td>181141</td>\n      <td>Mar  2 2011 12:00AM</td>\n      <td>Carmelina Narciso</td>\n      <td>1855 Folsom Street\\n SF\\n CA\\n 94103</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>50</th>\n      <td>477</td>\n      <td>Il Pollaio</td>\n      <td>555 Columbus Ave</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94133</td>\n      <td>37.8</td>\n      <td>-122.41</td>\n      <td></td>\n      <td>H24</td>\n      <td>147775</td>\n      <td></td>\n      <td>Antonio &amp; Jose Castellucci</td>\n      <td>555 Columbus Ave\\n San Francisco\\n CA\\n 94133</td>\n      <td>90</td>\n      <td>20130226</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103154: Unclean or degraded f...</td>\n    </tr>\n    <tr>\n      <th>51</th>\n      <td>1199</td>\n      <td>PANCHO'S</td>\n      <td>3440 GEARY Blvd</td>\n      <td>SAN FRANCISCO</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94118</td>\n      <td>37.7815</td>\n      <td>-122.456</td>\n      <td></td>\n      <td>H24</td>\n      <td>318180</td>\n      <td>Jun 17 1998 12:00AM</td>\n      <td>CAL. SOL. CONCEPTS LLC</td>\n      <td>3440  GEARY Blvd\\n S.F.\\n CA\\n 94118</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>52</th>\n      <td>1549</td>\n      <td>Cafe Bellini</td>\n      <td>235 Powell St</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94102</td>\n      <td>37.787</td>\n      <td>-122.408</td>\n      <td></td>\n      <td>H25</td>\n      <td>384285</td>\n      <td></td>\n      <td>SEGA FOOD GROUP INC</td>\n      <td>\\t235 POWELL ST\\n SAN FRANCISCO\\n CA\\n 94102</td>\n      <td>96</td>\n      <td>20130226</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103124: Inadequately cleaned ...</td>\n    </tr>\n    <tr>\n      <th>53</th>\n      <td>4257</td>\n      <td>DELUXE</td>\n      <td>1509 HAIGHT St</td>\n      <td>SF</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94117</td>\n      <td>37.7699</td>\n      <td>-122.447</td>\n      <td>14155556949</td>\n      <td>H25</td>\n      <td></td>\n      <td></td>\n      <td>JAY JOHNSON</td>\n      <td>1509 HAIGHT STREET\\n SAN FRANCISCO\\n CA\\n 94117</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Administrative or Document Review</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>54</th>\n      <td>68775</td>\n      <td>Dandelion Chocolate</td>\n      <td>740 Valencia St</td>\n      <td>San Francisco</td>\n      <td>San Francisco</td>\n      <td>1.000000</td>\n      <td>94110</td>\n      <td>37.761</td>\n      <td>-122.422</td>\n      <td></td>\n      <td>H26</td>\n      <td>466375</td>\n      <td>Mar 21 2012 12:00AM</td>\n      <td>Cocoa Co., Inc.</td>\n      <td>334 Santana Row #335\\n San Jose\\n Ca\\n 95128</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Complaint</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>55</th>\n      <td>68037</td>\n      <td>Focaccia Market Bakery</td>\n      <td>185 BERRY St #1430</td>\n      <td>S.F.</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94107</td>\n      <td>37.776</td>\n      <td>-122.393</td>\n      <td></td>\n      <td>H26</td>\n      <td>455335</td>\n      <td>Dec  1 2011 12:00AM</td>\n      <td>Focaccia Market Bakery, Inc.</td>\n      <td>119 Sacramento St.\\n SF\\n CA\\n 94111</td>\n      <td>91</td>\n      <td>20130226</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103109: Unclean or unsanitary...</td>\n    </tr>\n    <tr>\n      <th>56</th>\n      <td>69945</td>\n      <td>Linda's Catering</td>\n      <td>290 Townsend St</td>\n      <td>SF</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94107</td>\n      <td></td>\n      <td></td>\n      <td></td>\n      <td>H79</td>\n      <td>470527</td>\n      <td>Aug 15 2012 12:00AM</td>\n      <td>Hong Yan Fang-Li</td>\n      <td>3623 Kirkham St.\\n SF\\n CA\\n 94122</td>\n      <td>96</td>\n      <td>20130226</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103142: Unclean nonfood conta...</td>\n    </tr>\n    <tr>\n      <th>57</th>\n      <td>70920</td>\n      <td>Stock in Trade</td>\n      <td>2036 LOMBARD St</td>\n      <td>SF</td>\n      <td>San Francisco</td>\n      <td>0.814806</td>\n      <td>94123</td>\n      <td></td>\n      <td></td>\n      <td></td>\n      <td>H26</td>\n      <td>470757</td>\n      <td>Nov  9 2012 12:00AM</td>\n      <td>4 Item Combo Plate / Tod Alsman, Chris Fogarty</td>\n      <td>2036 Lombard Street\\n San Francisco\\n CA\\n 94123</td>\n      <td>90</td>\n      <td>20130226</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103149: Wiping cloths not cle...</td>\n    </tr>\n  </tbody>\n</table>\n</div>",
            "text/plain": "   inspections.business.business_id        inspections.business.name  \\\n0                             16162        Quick-N-Ezee Indian Foods   \n1                             69707             Little Green Cyclo 2   \n2                             67565        King of Thai Noodles Cafe   \n3                             67565        King of Thai Noodles Cafe   \n4                             68701                           Grindz   \n5                             69186  Premier Catering & Events, Inc.   \n6                              2689                   THE BLUE PLATE   \n7                             15806                   Vital Tea Leaf   \n8                             21807                  The Front Porch   \n9                             69041                  Washington Cafe   \n10                             6018      3RD BAPTIST FELLOWSHIP HALL   \n11                            23702                Doo Bu Restaurant   \n12                            23702                Doo Bu Restaurant   \n13                            34244               Vital Tea Leaf Inc   \n14                            63503     Mason Street Deli and Market   \n15                             1427                       MIFUNE DON   \n16                             3331                         HARVEY'S   \n17                             5907     LILIENTHAL ELEMENTARY SCHOOL   \n18                            65050                 House of Banquet   \n19                            71534            7 Eleven #2366-36039A   \n20                            71769              Lucky One Mini Mart   \n21                             5884   Gordon J Lau Elementary School   \n22                            69635                  Sophie's Crepes   \n23                             3633           Magnolia Pub & Brewery   \n24                             5905             MARINA MIDDLE SCHOOL   \n25                            19277                     Farmer Brown   \n26                             1775                       Sapporo-Ya   \n27                            61135  Old Mandarin Islamic Restaurant   \n28                              765                APERTO RESTAURANT   \n29                             3373             New Delhi Restaurant   \n30                             3373             New Delhi Restaurant   \n31                            33891                           Harlot   \n32                            28828                The Sandwich Shop   \n33                            60933                            Mayes   \n34                            62688                   Auntie April's   \n35                             3373             New Delhi Restaurant   \n36                             2756                        STARBUCKS   \n37                             7489                       GAS & SHOP   \n38                            19094                           Rigolo   \n39                            65051                   Mission Cheese   \n40                             3802    THE GREAT AMERICAN MUSIC HALL   \n41                              475                           Mara's   \n42                             1193            PEET'S COFFEES & TEAS   \n43                             2548     NOAH'S NEW YORK BAGELS #2120   \n44                             6913                    XTRA OIL CORP   \n45                             4923                     TED'S MARKET   \n46                            36020                  Cadillac Market   \n47                             3935             Le Colonial, SF, LLC   \n48                             1259              KD'S GROG & GROCERY   \n49                            65396                 Carmelina's Cafe   \n50                              477                       Il Pollaio   \n51                             1199                         PANCHO'S   \n52                             1549                     Cafe Bellini   \n53                             4257                           DELUXE   \n54                            68775              Dandelion Chocolate   \n55                            68037           Focaccia Market Bakery   \n56                            69945                 Linda's Catering   \n57                            70920                   Stock in Trade   \n\n   inspections.business.address inspections.business.city   city_grouped  \\\n0                 3861 24th St                         SF  San Francisco   \n1                Off The Grid                                              \n2              1541 TARAVAL St              SAN FRANCISCO  San Francisco   \n3              1541 TARAVAL St              SAN FRANCISCO  San Francisco   \n4               832 Clement St                         SF  San Francisco   \n5                 1255 22nd St                       S.F.  San Francisco   \n6              3218 MISSION St                         SF  San Francisco   \n7                1044 Grant Ave             San Francisco  San Francisco   \n8                  65 29th St A                        SF  San Francisco   \n9            826 Washington St              San Francisco  San Francisco   \n10          1399 MCALLISTER St              SAN FRANCISCO  San Francisco   \n11             1723 Buchanan St             San Francisco  San Francisco   \n12             1723 Buchanan St             San Francisco  San Francisco   \n13               905 Grant Ave              San Francisco  San Francisco   \n14                     39 MASON                        SF  San Francisco   \n15          22 PEACE PLAZA  275                        SF  San Francisco   \n16               500 CASTRO St              SAN FRANCISCO  San Francisco   \n17          3630 DIVISADERO St                       S.F.  San Francisco   \n18              939 Clement St              San Francisco  San Francisco   \n19              644 Mission St              San Francisco  San Francisco   \n20              1010 Market St              San Francisco  San Francisco   \n21                  950 Clay St             San Francisco  San Francisco   \n22          1581 Webster St 275                      S.F.  San Francisco   \n23               1398 Haight St             San Francisco  San Francisco   \n24            3500 FILLMORE St                       S.F.  San Francisco   \n25                 25 Mason St              San Francisco  San Francisco   \n26             1581 WEBSTER St                         SF  San Francisco   \n27             3132 VICENTE St                         SF  San Francisco   \n28                1434 18th St                       S.F.  San Francisco   \n29                160 Ellis St              San Francisco  San Francisco   \n30                160 Ellis St              San Francisco  San Francisco   \n31                 46 Minna St              San Francisco  San Francisco   \n32                 635 19th St                       S.F.  San Francisco   \n33                1233 Polk St              San Francisco  San Francisco   \n34                4618 03rd St                         SF  San Francisco   \n35                160 Ellis St              San Francisco  San Francisco   \n36          3595 CALIFORNIA St                         SF  San Francisco   \n37      599 South Van Ness Ave                       S.F.  San Francisco   \n38          3465 California St                         SF  San Francisco   \n39             736 Valencia St                         SF  San Francisco   \n40            859 O'FARRELL St              SAN FRANCISCO  San Francisco   \n41            503 Columbus Ave              San Francisco  San Francisco   \n42          3419 CALIFORNIA St              SAN FRANCISCO  San Francisco   \n43          3519 CALIFORNIA St                         SF  San Francisco   \n44                3750 03rd St                       S.F.  San Francisco   \n45              1530 HOWARD St                       S.F.  San Francisco   \n46                  499 Eddy St             San Francisco  San Francisco   \n47                 20 Cosmo Pl              San Francisco  San Francisco   \n48              2416 MARKET St                         SF  San Francisco   \n49              1855 Folsom St                         SF  San Francisco   \n50            555 Columbus Ave              San Francisco  San Francisco   \n51             3440 GEARY Blvd              SAN FRANCISCO  San Francisco   \n52               235 Powell St              San Francisco  San Francisco   \n53              1509 HAIGHT St                         SF  San Francisco   \n54             740 Valencia St              San Francisco  San Francisco   \n55           185 BERRY St #1430                      S.F.  San Francisco   \n56             290 Townsend St                         SF  San Francisco   \n57             2036 LOMBARD St                         SF  San Francisco   \n\n    similarity_score inspections.business.postal_code  \\\n0           0.814806                            94114   \n1                NaN                                    \n2           1.000000                            94116   \n3           1.000000                            94116   \n4           0.814806                            94118   \n5           0.814806                            94107   \n6           0.814806                            94110   \n7           1.000000                            94133   \n8           0.814806                            94110   \n9           1.000000                            94108   \n10          1.000000                            94115   \n11          1.000000                            94115   \n12          1.000000                            94115   \n13          1.000000                            94108   \n14          0.814806                            94102   \n15          0.814806                            94115   \n16          1.000000                            94114   \n17          0.814806                            94118   \n18          1.000000                            94118   \n19          1.000000                            94105   \n20          1.000000                            94102   \n21          1.000000                            94108   \n22          0.814806                            94115   \n23          1.000000                            94117   \n24          0.814806                            94123   \n25          1.000000                            94102   \n26          0.814806                            94115   \n27          0.814806                            94116   \n28          0.814806                            94107   \n29          1.000000                            94102   \n30          1.000000                            94102   \n31          1.000000                            94105   \n32          0.814806                            94107   \n33          1.000000                            94109   \n34          0.814806                            94124   \n35          1.000000                            94102   \n36          0.814806                            94118   \n37          0.814806                            94110   \n38          0.814806                            94118   \n39          0.814806                            94110   \n40          1.000000                            94109   \n41          1.000000                            94133   \n42          1.000000                            94118   \n43          0.814806                            94118   \n44          0.814806                            94124   \n45          0.814806                            94103   \n46          1.000000                            94109   \n47          1.000000                            94109   \n48          0.814806                            94114   \n49          0.814806                            94103   \n50          1.000000                            94133   \n51          1.000000                            94118   \n52          1.000000                            94102   \n53          0.814806                            94117   \n54          1.000000                            94110   \n55          0.814806                            94107   \n56          0.814806                            94107   \n57          0.814806                            94123   \n\n   inspections.business.latitude inspections.business.longitude  \\\n0                                                                 \n1                                                                 \n2                        37.7427                       -122.483   \n3                        37.7427                       -122.483   \n4                        37.7828                       -122.468   \n5                                                                 \n6                        37.7452                        -122.42   \n7                        37.7966                       -122.407   \n8                        37.7439                       -122.422   \n9                        37.7951                       -122.407   \n10                       37.7782                       -122.435   \n11                        37.786                        -122.43   \n12                        37.786                        -122.43   \n13                       37.7953                       -122.407   \n14                       37.7841                       -122.409   \n15                        37.785                        -122.43   \n16                       37.7607                       -122.435   \n17                       37.8035                       -122.444   \n18                       37.7827                       -122.469   \n19                                                                \n20                       37.7819                       -122.411   \n21                        37.794                       -122.409   \n22                                                                \n23                       37.7703                       -122.445   \n24                       37.8018                       -122.436   \n25                       37.7837                       -122.409   \n26                       37.7852                       -122.431   \n27                       37.7382                       -122.501   \n28                       37.7626                       -122.397   \n29                       37.7855                       -122.409   \n30                       37.7855                       -122.409   \n31                       37.7887                       -122.398   \n32                       37.7617                       -122.389   \n33                       37.7883                        -122.42   \n34                       37.7363                        -122.39   \n35                       37.7855                       -122.409   \n36                       37.7864                       -122.453   \n37                       37.7638                       -122.417   \n38                       37.7867                       -122.451   \n39                       37.7611                       -122.422   \n40                        37.785                       -122.419   \n41                       37.7995                       -122.409   \n42                       37.7868                        -122.45   \n43                       37.7866                       -122.452   \n44                       37.7432                       -122.388   \n45                       37.7727                       -122.416   \n46                       37.7835                       -122.416   \n47                       37.7881                       -122.412   \n48                       37.7626                       -122.435   \n49                       37.7677                       -122.415   \n50                          37.8                        -122.41   \n51                       37.7815                       -122.456   \n52                        37.787                       -122.408   \n53                       37.7699                       -122.447   \n54                        37.761                       -122.422   \n55                        37.776                       -122.393   \n56                                                                \n57                                                                \n\n   inspections.business.phone_number inspections.business.TaxCode  \\\n0                                                             H34   \n1                                                             H79   \n2                                                             H25   \n3                                                             H25   \n4                                                             H25   \n5                        14155530288                          H30   \n6                        14155286777                          H25   \n7                                                             H24   \n8                                                             H25   \n9                                                             H26   \n10                                                             AA   \n11                                                            H25   \n12                                                            H25   \n13                                                            H25   \n14                       14155624312                          H07   \n15                       14155341993                          H24   \n16                       14155434278                          H26   \n17                       14155743516                          H91   \n18                       14155780203                          H26   \n19                       14155610309                          H07   \n20                                                            H24   \n21                                                            H91   \n22                                                            H28   \n23                                                            H26   \n24                       14155743495                          H91   \n25                                                            H26   \n26                       14155567400                          H25   \n27                                                            H24   \n28                                                            H24   \n29                                                            H26   \n30                                                            H26   \n31                                                            H87   \n32                                                            H28   \n33                                                            H26   \n34                                                            H24   \n35                                                            H26   \n36                                                            H25   \n37                       14155866835                          H10   \n38                                                            H25   \n39                       14155558667                          H24   \n40                                                            H26   \n41                                                            H24   \n42                                                            H24   \n43                                                            H25   \n44                                                            H07   \n45                                                            H28   \n46                                                            H07   \n47                                                            H26   \n48                       14155863736                          H24   \n49                                                            H24   \n50                                                            H24   \n51                                                            H24   \n52                                                            H25   \n53                       14155556949                          H25   \n54                                                            H26   \n55                                                            H26   \n56                                                            H79   \n57                                                            H26   \n\n   inspections.business.business_certificate  \\\n0                                     467114   \n1                                     453248   \n2                                              \n3                                              \n4                                     467498   \n5                                     362812   \n6                                     325714   \n7                                     388301   \n8                                     398500   \n9                                     468548   \n10                                             \n11                                    205289   \n12                                    205289   \n13                                    417300   \n14                                    450988   \n15                                    314685   \n16                                    945743   \n17                                             \n18                                    455173   \n19                                    475970   \n20                                    473612   \n21                                             \n22                                    470456   \n23                                    306120   \n24                                             \n25                                    397481   \n26                                     98407   \n27                                    442429   \n28                                    921479   \n29                                    173398   \n30                                    173398   \n31                                    404920   \n32                                    402498   \n33                                    441175   \n34                                    428950   \n35                                    173398   \n36                                    911744   \n37                                    922993   \n38                                    373994   \n39                                    455293   \n40                                    358240   \n41                                    147903   \n42                                    196325   \n43                                    353177   \n44                                    144903   \n45                                    321004   \n46                                    379395   \n47                                    317110   \n48                                    198913   \n49                                    181141   \n50                                    147775   \n51                                    318180   \n52                                    384285   \n53                                             \n54                                    466375   \n55                                    455335   \n56                                    470527   \n57                                    470757   \n\n   inspections.business.application_date  \\\n0                    May  9 2005 12:00AM   \n1                    Jul 12 2012 12:00AM   \n2                    Oct 12 2011 12:00AM   \n3                    Oct 12 2011 12:00AM   \n4                    Mar 16 2012 12:00AM   \n5                    Apr 30 2012 12:00AM   \n6                                          \n7                    May 23 2005 12:00AM   \n8                    Jun  7 2006 12:00AM   \n9                    Apr 18 2012 12:00AM   \n10                                         \n11                   Jun 30 2006 12:00AM   \n12                   Jun 30 2006 12:00AM   \n13                   May 17 2007 12:00AM   \n14                   Jun 28 2010 12:00AM   \n15                                         \n16                                         \n17                                         \n18                   Jan 11 2011 12:00AM   \n19                   Jan 24 2013 12:00AM   \n20                   Feb 15 2013 12:00AM   \n21                                         \n22                   Jul  5 2012 12:00AM   \n23                                         \n24                                         \n25                   Apr 20 2006 12:00AM   \n26                                         \n27                   Sep 14 2009 12:00AM   \n28                   Apr 16 1992 12:00AM   \n29                                         \n30                                         \n31                   Apr 26 2007 12:00AM   \n32                   Oct 11 2006 12:00AM   \n33                   Aug 27 2009 12:00AM   \n34                   Apr  2 2010 12:00AM   \n35                                         \n36                   Oct 30 1995 12:00AM   \n37                   Aug 13 1993 12:00AM   \n38                   Mar  1 2004 12:00AM   \n39                   Jan 11 2011 12:00AM   \n40                                         \n41                                         \n42                                         \n43                   Mar 15 2002 12:00AM   \n44                   May 17 1993 12:00AM   \n45                                         \n46                   Oct 29 2007 12:00AM   \n47                                         \n48                                         \n49                   Mar  2 2011 12:00AM   \n50                                         \n51                   Jun 17 1998 12:00AM   \n52                                         \n53                                         \n54                   Mar 21 2012 12:00AM   \n55                   Dec  1 2011 12:00AM   \n56                   Aug 15 2012 12:00AM   \n57                   Nov  9 2012 12:00AM   \n\n                      inspections.business.owner_name  \\\n0                                Jagpreet Enterprises   \n1                                LITTLEGREENCYCLO LLC   \n2                             Royal Thai Noodles, Inc   \n3                             Royal Thai Noodles, Inc   \n4                                     Ono Grindz, LLC   \n5                     Premier Catering & Events, Inc.   \n6                                    BLUE ENCLAVE LLC   \n7                                       Minh H. Duong   \n8                          Front Porch Restaurant LLC   \n9                 Washington Caf�, Inc. / Louis Kuang   \n10                        3RD BAPTIST FELLOWSHIP HALL   \n11                                       Jung Un Hong   \n12                                       Jung Un Hong   \n13               Vital Tea Leaf Inc   Minh Hong Duong   \n14  Hifdallah Ahmed Homran and Arkan Ali Hassan Al...   \n15                                    Osaka Eiko, Inc   \n16                                LANGLEY ENTERPRISES   \n17              San Francisco Unified School District   \n18                     LYS Trading, Inc. / Yong Shong   \n19                              Bhrighu Muniwar, Inc.   \n20                                        Charles Ahn   \n21                       S.F. Unified School District   \n22                               Sophie's Crepes, LLC   \n23                              McLean Breweries, Inc   \n24              San Francisco Unified School district   \n25                           Black Rabbit Hospitality   \n26                                TURNER SHIBATA INC.   \n27                                         Shuai Yang   \n28                                        APERTO INC.   \n29                               New Delhi Restaurant   \n30                               New Delhi Restaurant   \n31                     Vespertine, Inc   Robert Nunez   \n32                                        Hye Hwa Cho   \n33                 1233 Polk Street LLC   Fred Duncan   \n34                                       April Spears   \n35                               New Delhi Restaurant   \n36                          STARBUCKS COFFEE CO, INC.   \n37                         SELF SERVE PETROLEUM, INC.   \n38                          Laurel Village Bakery LLC   \n39                                 Mission Cheese LLC   \n40                                    MUSIC HALL, LLC   \n41                         Filomena & Gennaro Torrano   \n42                                      Peet's Coffee   \n43                            EINSTEIN AND NOAH CORP.   \n44                                     EDWARD T SIMAS   \n45                                  ZOUZOUNIS DAVID P   \n46                                   Irfan Barkat Ali   \n47                               Le Colonial, SF, LLC   \n48                                       KIM, SUNG U.   \n49                                  Carmelina Narciso   \n50                         Antonio & Jose Castellucci   \n51                             CAL. SOL. CONCEPTS LLC   \n52                                SEGA FOOD GROUP INC   \n53                                        JAY JOHNSON   \n54                                    Cocoa Co., Inc.   \n55                       Focaccia Market Bakery, Inc.   \n56                                   Hong Yan Fang-Li   \n57     4 Item Combo Plate / Tod Alsman, Chris Fogarty   \n\n                   inspections.business.owner_address inspections.Score  \\\n0          23682 Clawiter Road\\n Hayward\\n CA\\n 94545               100   \n1   100 Esplanade Ave., Apt. 99\\n Pacifica\\n CA\\n ...                93   \n2                     2410 19th Ave\\n SF\\n CA\\n 94116                79   \n3                     2410 19th Ave\\n SF\\n CA\\n 94116                     \n4             1055 Granada St.\\n Vallejo\\n CA\\n 94591               100   \n5                 298 Magellan Ave.\\n SF\\n CA\\n 94116                     \n6       3218 MISSION ST.\\n SAN FRANCISCO\\n CA\\n 94110                98   \n7         1044 Grant Ave\\n San Francisco\\n CA\\n 94133                98   \n8                   65A 29th Street\\n SF\\n CA\\n 94110                     \n9           333 Third Avenue\\n Daly City\\n CA\\n 94014                65   \n10  1399 MC ALLISTER STREET\\n SAN FRANCISCO\\n CA\\n...                98   \n11      1723 Buchanan St\\n San Francisco\\n CA\\n 94115                90   \n12      1723 Buchanan St\\n San Francisco\\n CA\\n 94115                     \n13         905 Grant Ave\\n San Francisco\\n CA\\n 94108               100   \n14       39 Mason Street\\n San Francisco\\n CA\\n 94102               100   \n15             22 PEACE PLAZA, #275\\n SF\\n CA\\n 94115                86   \n16                    500 CASTRO ST\\n SF\\n CA\\n 94114                83   \n17  3630 Divisadero Street\\n San Francisco\\n CA\\n ...                     \n18    939 Clement Street\\n San Francisco\\n CA\\n 94118                87   \n19           538 Pyramid Ct.\\n Fairfield\\n CA\\n 94534               100   \n20    1010 Market Street\\n San Francisco\\n CA\\n 94102               100   \n21          950  Clay St\\n San Francisco\\n CA\\n 94108                96   \n22           1581 Webster St., #275\\n SF\\n CA\\n 94115                     \n23        1398 Haight St\\n San Francisco\\n CA\\n 94117                     \n24  3500 Fillmore Street\\n San Francisco\\n CA\\n 94123                     \n25           25 Mason St\\n San Francisco\\n CA\\n 94102               100   \n26                  1581 WEBSTER ST\\n SF\\n CA\\n 94115                     \n27                 3132 Vicente St.\\n SF\\n CA\\n 94116                84   \n28                 245 LAWTON ST.\\n S.F.\\n CA\\n 94122                     \n29          160 Ellis St\\n San Francisco\\n CA\\n 94102                     \n30          160 Ellis St\\n San Francisco\\n CA\\n 94102                     \n31       46 Minna Street\\n San Francisco\\n CA\\n 94105                87   \n32                  635 19th Street\\n SF\\n CA\\n 94107                88   \n33          1233 Polk St\\n San Francisco\\n CA\\n 94109                85   \n34                  4618 3rd Street\\n SF\\n CA\\n 94124                     \n35          160 Ellis St\\n San Francisco\\n CA\\n 94102                     \n36               3595 CALIFORNIA ST\\n SF\\n CA\\n 94118                     \n37          2240 SKY FARM\\n HILLSBOROUGH\\n CA\\n 94010                     \n38                 2132 Pine Street\\n SF\\n CA\\n 94118                     \n39                  363 Hermann St.\\n SF\\n CA\\n 94117                     \n40      859 O'FARRELL St\\n SAN FRANCISCO\\n CA\\n 94109                94   \n41      503 Columbus Ave\\n San Francisco\\n CA\\n 94133                     \n42                  3419 California\\n SF\\n CA\\n 94118                     \n43    555 Zang St., Suite 300\\n Lakewood\\n CO\\n 80228                     \n44           2307 PACIFIC AVE.\\n ALAMEDA\\n CA\\n 94501                     \n45        1530 HOWARD ST\\n SAN FRANCISCO\\n CA\\n 94103               100   \n46           499 Eddy St\\n San Francisco\\n CA\\n 94109                98   \n47          20  Cosmo PL\\n San Francisco\\n CA\\n 94109                     \n48       2416 MARKET ST.\\n SAN FRANCISCO\\n CA\\n 94114                     \n49               1855 Folsom Street\\n SF\\n CA\\n 94103                     \n50      555 Columbus Ave\\n San Francisco\\n CA\\n 94133                90   \n51               3440  GEARY Blvd\\n S.F.\\n CA\\n 94118                     \n52       \\t235 POWELL ST\\n SAN FRANCISCO\\n CA\\n 94102                96   \n53    1509 HAIGHT STREET\\n SAN FRANCISCO\\n CA\\n 94117                     \n54       334 Santana Row #335\\n San Jose\\n Ca\\n 95128                     \n55               119 Sacramento St.\\n SF\\n CA\\n 94111                91   \n56                 3623 Kirkham St.\\n SF\\n CA\\n 94122                96   \n57   2036 Lombard Street\\n San Francisco\\n CA\\n 94123                90   \n\n   inspections.date                   inspections.type  \\\n0          20130223              Routine - Unscheduled   \n1          20130224              Routine - Unscheduled   \n2          20130225              Routine - Unscheduled   \n3          20130225                          Complaint   \n4          20130225              Routine - Unscheduled   \n5          20130225              Reinspection/Followup   \n6          20130225              Routine - Unscheduled   \n7          20130225              Routine - Unscheduled   \n8          20130225              Reinspection/Followup   \n9          20130225              Routine - Unscheduled   \n10         20130225              Routine - Unscheduled   \n11         20130225              Routine - Unscheduled   \n12         20130225                          Complaint   \n13         20130225              Routine - Unscheduled   \n14         20130225              Routine - Unscheduled   \n15         20130225              Routine - Unscheduled   \n16         20130225              Routine - Unscheduled   \n17         20130225              Reinspection/Followup   \n18         20130225              Routine - Unscheduled   \n19         20130225              Routine - Unscheduled   \n20         20130225              Routine - Unscheduled   \n21         20130225              Routine - Unscheduled   \n22         20130225          Non-inspection site visit   \n23         20130225              Reinspection/Followup   \n24         20130225              Reinspection/Followup   \n25         20130225              Routine - Unscheduled   \n26         20130225              Reinspection/Followup   \n27         20130225              Routine - Unscheduled   \n28         20130225              Reinspection/Followup   \n29         20130225              Reinspection/Followup   \n30         20130225              Reinspection/Followup   \n31         20130225              Routine - Unscheduled   \n32         20130226              Routine - Unscheduled   \n33         20130226              Routine - Unscheduled   \n34         20130226              Reinspection/Followup   \n35         20130226              Reinspection/Followup   \n36         20130226              Reinspection/Followup   \n37         20130226              Reinspection/Followup   \n38         20130226              Reinspection/Followup   \n39         20130226          Non-inspection site visit   \n40         20130226              Routine - Unscheduled   \n41         20130226              Reinspection/Followup   \n42         20130226              Reinspection/Followup   \n43         20130226              Reinspection/Followup   \n44         20130226              Reinspection/Followup   \n45         20130226              Routine - Unscheduled   \n46         20130226              Routine - Unscheduled   \n47         20130226              Reinspection/Followup   \n48         20130226              Reinspection/Followup   \n49         20130226              Reinspection/Followup   \n50         20130226              Routine - Unscheduled   \n51         20130226              Reinspection/Followup   \n52         20130226              Routine - Unscheduled   \n53         20130226  Administrative or Document Review   \n54         20130226                          Complaint   \n55         20130226              Routine - Unscheduled   \n56         20130226              Routine - Unscheduled   \n57         20130226              Routine - Unscheduled   \n\n                               inspections.violations  \n0                                                  []  \n1   [{\"description\":\"103112: No hot water or runni...  \n2   [{\"description\":\"103139: Improper food storage...  \n3   [{\"description\":\"103139: Improper food storage...  \n4                                                  []  \n5                                                  []  \n6   [{\"description\":\"103143: Inadequate warewashin...  \n7   [{\"description\":\"103157: Food safety certifica...  \n8                                                  []  \n9   [{\"description\":\"103120: Moderate risk food ho...  \n10  [{\"description\":\"103143: Inadequate warewashin...  \n11  [{\"description\":\"103154: Unclean or degraded f...  \n12  [{\"description\":\"103154: Unclean or degraded f...  \n13                                                 []  \n14                                                 []  \n15  [{\"description\":\"103102: Unclean hands or impr...  \n16  [{\"description\":\"103149: Wiping cloths not cle...  \n17                                                 []  \n18  [{\"description\":\"103149: Wiping cloths not cle...  \n19                                                 []  \n20                                                 []  \n21  [{\"description\":\"103120: Moderate risk food ho...  \n22                                                 []  \n23                                                 []  \n24                                                 []  \n25                                                 []  \n26                                                 []  \n27  [{\"description\":\"103144: Unapproved or unmaint...  \n28                                                 []  \n29                                                 []  \n30                                                 []  \n31  [{\"description\":\"103119: Inadequate and inacce...  \n32  [{\"description\":\"103124: Inadequately cleaned ...  \n33  [{\"description\":\"103114: High risk vermin infe...  \n34                                                 []  \n35                                                 []  \n36  [{\"description\":\"103157: Food safety certifica...  \n37                                                 []  \n38                                                 []  \n39                                                 []  \n40  [{\"description\":\"103161: Low risk vermin infes...  \n41                                                 []  \n42                                                 []  \n43                                                 []  \n44                                                 []  \n45                                                 []  \n46  [{\"description\":\"103143: Inadequate warewashin...  \n47                                                 []  \n48                                                 []  \n49                                                 []  \n50  [{\"description\":\"103154: Unclean or degraded f...  \n51                                                 []  \n52  [{\"description\":\"103124: Inadequately cleaned ...  \n53                                                 []  \n54                                                 []  \n55  [{\"description\":\"103109: Unclean or unsanitary...  \n56  [{\"description\":\"103142: Unclean nonfood conta...  \n57  [{\"description\":\"103149: Wiping cloths not cle...  "
          },
          "metadata": {}
        }
      ]
    },
    {
      "metadata": {},
      "cell_type": "markdown",
      "source": "Out of the arguments only source_column and new_column_name are required. \nsimilarity_threshold, if provided controls how close values should be to warrant inclusion in the same fuzzy group.\nsimilarity_score_column_name controls the name of an additional column with the value representing similarity score between original value and detected canonical value. If no similarity_score_column_name is passed in, no column with the score would be added.\n\nAs you can see above, couple of ways San Francisco was present in the data were all normalized to 'San Francisco'.\nBut what if you want more control over what gets grouped, what doesn't and what the canonical value should be? \nThe way to get there is by going through a specific builder for FuzzyGoups:"
    },
    {
      "metadata": {
        "trusted": true
      },
      "cell_type": "code",
      "source": "builder = dataflow.builders.fuzzy_group_column(source_column='inspections.business.city',\n                                        new_column_name='city_grouped',\n                                        similarity_threshold=0.8,\n                                        similarity_score_column_name='similarity_score')",
      "execution_count": 4,
      "outputs": []
    },
    {
      "metadata": {
        "scrolled": true,
        "trusted": true
      },
      "cell_type": "code",
      "source": "builder.learn()\nbuilder.groups",
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 5,
          "data": {
            "text/plain": "[{'canonicalValue': 'San Francisco',\n  'duplicates': [{'similarityScore': 1.0,\n    'duplicateValue': 'San Francisco',\n    'useForReplacement': True},\n   {'similarityScore': 1.0,\n    'duplicateValue': 'SAN FRANCISCO',\n    'useForReplacement': True},\n   {'similarityScore': 0.8148061037063599,\n    'duplicateValue': 'SF',\n    'useForReplacement': True},\n   {'similarityScore': 0.8148061037063599,\n    'duplicateValue': 'S.F.',\n    'useForReplacement': True}]}]"
          },
          "metadata": {}
        }
      ]
    },
    {
      "metadata": {},
      "cell_type": "markdown",
      "source": "Here we can see that DataPrep has detected 1 group with 4 values that all map to 'San Francisco' as canonical value.\nWe can see what kind of effect changing the similarity threshold has:"
    },
    {
      "metadata": {
        "scrolled": true,
        "trusted": true
      },
      "cell_type": "code",
      "source": "builder.similarity_threshold = 0.9\nbuilder.learn()\nbuilder.groups",
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 6,
          "data": {
            "text/plain": "[{'canonicalValue': 'SF',\n  'duplicates': [{'similarityScore': 1.0,\n    'duplicateValue': 'SF',\n    'useForReplacement': True},\n   {'similarityScore': 0.9523809552192688,\n    'duplicateValue': 'S.F.',\n    'useForReplacement': True}]},\n {'canonicalValue': 'San Francisco',\n  'duplicates': [{'similarityScore': 1.0,\n    'duplicateValue': 'San Francisco',\n    'useForReplacement': True},\n   {'similarityScore': 1.0,\n    'duplicateValue': 'SAN FRANCISCO',\n    'useForReplacement': True}]}]"
          },
          "metadata": {}
        }
      ]
    },
    {
      "metadata": {},
      "cell_type": "markdown",
      "source": "Now that we want similarity of at least 0.9 DataPrep has generated two distinct fuzzy groups.\n\nLet's tweak some of the detected groups before completing the builder and getting our resulting dataflow."
    },
    {
      "metadata": {
        "trusted": true
      },
      "cell_type": "code",
      "source": "builder.similarity_threshold = 0.8\nbuilder.learn()\ngroups = builder.groups\ngroups",
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 7,
          "data": {
            "text/plain": "[{'canonicalValue': 'San Francisco',\n  'duplicates': [{'similarityScore': 1.0,\n    'duplicateValue': 'San Francisco',\n    'useForReplacement': True},\n   {'similarityScore': 1.0,\n    'duplicateValue': 'SAN FRANCISCO',\n    'useForReplacement': True},\n   {'similarityScore': 0.8148061037063599,\n    'duplicateValue': 'SF',\n    'useForReplacement': True},\n   {'similarityScore': 0.8148061037063599,\n    'duplicateValue': 'S.F.',\n    'useForReplacement': True}]}]"
          },
          "metadata": {}
        }
      ]
    },
    {
      "metadata": {
        "trusted": true
      },
      "cell_type": "code",
      "source": "groups[0]['canonicalValue'] = 'SANFRAN'\nduplicates = groups[0]['duplicates']\nduplicates = duplicates[:-1]\ngroups[0]['duplicates'] = duplicates\nbuilder.groups = groups\nbuilder.groups",
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 8,
          "data": {
            "text/plain": "[{'canonicalValue': 'SANFRAN',\n  'duplicates': [{'similarityScore': 1.0,\n    'duplicateValue': 'San Francisco',\n    'useForReplacement': True},\n   {'similarityScore': 1.0,\n    'duplicateValue': 'SAN FRANCISCO',\n    'useForReplacement': True},\n   {'similarityScore': 0.8148061037063599,\n    'duplicateValue': 'SF',\n    'useForReplacement': True}]}]"
          },
          "metadata": {}
        }
      ]
    },
    {
      "metadata": {},
      "cell_type": "markdown",
      "source": "As you can see, we have modified canonical value to be used for the single fuzzy group as well as removed 'S.F.' from this group's duplicates list.\n\nYou can mutate the copy of the list you got from the Builder (be careful to keep the structure of object inside this list) to get desired groups and then update the builder with it.\n\nNow we can get a dataflow with the FuzzyGroup step in it."
    },
    {
      "metadata": {
        "trusted": true
      },
      "cell_type": "code",
      "source": "dataflow = builder.to_dataflow()\n\ndf = dataflow.to_pandas_dataframe()\ndf",
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 9,
          "data": {
            "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>inspections.business.business_id</th>\n      <th>inspections.business.name</th>\n      <th>inspections.business.address</th>\n      <th>inspections.business.city</th>\n      <th>city_grouped</th>\n      <th>similarity_score</th>\n      <th>inspections.business.postal_code</th>\n      <th>inspections.business.latitude</th>\n      <th>inspections.business.longitude</th>\n      <th>inspections.business.phone_number</th>\n      <th>inspections.business.TaxCode</th>\n      <th>inspections.business.business_certificate</th>\n      <th>inspections.business.application_date</th>\n      <th>inspections.business.owner_name</th>\n      <th>inspections.business.owner_address</th>\n      <th>inspections.Score</th>\n      <th>inspections.date</th>\n      <th>inspections.type</th>\n      <th>inspections.violations</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>16162</td>\n      <td>Quick-N-Ezee Indian Foods</td>\n      <td>3861 24th St</td>\n      <td>SF</td>\n      <td>SANFRAN</td>\n      <td>0.814806</td>\n      <td>94114</td>\n      <td></td>\n      <td></td>\n      <td></td>\n      <td>H34</td>\n      <td>467114</td>\n      <td>May  9 2005 12:00AM</td>\n      <td>Jagpreet Enterprises</td>\n      <td>23682 Clawiter Road\\n Hayward\\n CA\\n 94545</td>\n      <td>100</td>\n      <td>20130223</td>\n      <td>Routine - Unscheduled</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>69707</td>\n      <td>Little Green Cyclo 2</td>\n      <td>Off The Grid</td>\n      <td></td>\n      <td></td>\n      <td>NaN</td>\n      <td></td>\n      <td></td>\n      <td></td>\n      <td></td>\n      <td>H79</td>\n      <td>453248</td>\n      <td>Jul 12 2012 12:00AM</td>\n      <td>LITTLEGREENCYCLO LLC</td>\n      <td>100 Esplanade Ave., Apt. 99\\n Pacifica\\n CA\\n ...</td>\n      <td>93</td>\n      <td>20130224</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103112: No hot water or runni...</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>67565</td>\n      <td>King of Thai Noodles Cafe</td>\n      <td>1541 TARAVAL St</td>\n      <td>SAN FRANCISCO</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94116</td>\n      <td>37.7427</td>\n      <td>-122.483</td>\n      <td></td>\n      <td>H25</td>\n      <td></td>\n      <td>Oct 12 2011 12:00AM</td>\n      <td>Royal Thai Noodles, Inc</td>\n      <td>2410 19th Ave\\n SF\\n CA\\n 94116</td>\n      <td>79</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103139: Improper food storage...</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>67565</td>\n      <td>King of Thai Noodles Cafe</td>\n      <td>1541 TARAVAL St</td>\n      <td>SAN FRANCISCO</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94116</td>\n      <td>37.7427</td>\n      <td>-122.483</td>\n      <td></td>\n      <td>H25</td>\n      <td></td>\n      <td>Oct 12 2011 12:00AM</td>\n      <td>Royal Thai Noodles, Inc</td>\n      <td>2410 19th Ave\\n SF\\n CA\\n 94116</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Complaint</td>\n      <td>[{\"description\":\"103139: Improper food storage...</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>68701</td>\n      <td>Grindz</td>\n      <td>832 Clement St</td>\n      <td>SF</td>\n      <td>SANFRAN</td>\n      <td>0.814806</td>\n      <td>94118</td>\n      <td>37.7828</td>\n      <td>-122.468</td>\n      <td></td>\n      <td>H25</td>\n      <td>467498</td>\n      <td>Mar 16 2012 12:00AM</td>\n      <td>Ono Grindz, LLC</td>\n      <td>1055 Granada St.\\n Vallejo\\n CA\\n 94591</td>\n      <td>100</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>69186</td>\n      <td>Premier Catering &amp; Events, Inc.</td>\n      <td>1255 22nd St</td>\n      <td>S.F.</td>\n      <td>S.F.</td>\n      <td>NaN</td>\n      <td>94107</td>\n      <td></td>\n      <td></td>\n      <td>14155530288</td>\n      <td>H30</td>\n      <td>362812</td>\n      <td>Apr 30 2012 12:00AM</td>\n      <td>Premier Catering &amp; Events, Inc.</td>\n      <td>298 Magellan Ave.\\n SF\\n CA\\n 94116</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td>2689</td>\n      <td>THE BLUE PLATE</td>\n      <td>3218 MISSION St</td>\n      <td>SF</td>\n      <td>SANFRAN</td>\n      <td>0.814806</td>\n      <td>94110</td>\n      <td>37.7452</td>\n      <td>-122.42</td>\n      <td>14155286777</td>\n      <td>H25</td>\n      <td>325714</td>\n      <td></td>\n      <td>BLUE ENCLAVE LLC</td>\n      <td>3218 MISSION ST.\\n SAN FRANCISCO\\n CA\\n 94110</td>\n      <td>98</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103143: Inadequate warewashin...</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>15806</td>\n      <td>Vital Tea Leaf</td>\n      <td>1044 Grant Ave</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94133</td>\n      <td>37.7966</td>\n      <td>-122.407</td>\n      <td></td>\n      <td>H24</td>\n      <td>388301</td>\n      <td>May 23 2005 12:00AM</td>\n      <td>Minh H. Duong</td>\n      <td>1044 Grant Ave\\n San Francisco\\n CA\\n 94133</td>\n      <td>98</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103157: Food safety certifica...</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>21807</td>\n      <td>The Front Porch</td>\n      <td>65 29th St A</td>\n      <td>SF</td>\n      <td>SANFRAN</td>\n      <td>0.814806</td>\n      <td>94110</td>\n      <td>37.7439</td>\n      <td>-122.422</td>\n      <td></td>\n      <td>H25</td>\n      <td>398500</td>\n      <td>Jun  7 2006 12:00AM</td>\n      <td>Front Porch Restaurant LLC</td>\n      <td>65A 29th Street\\n SF\\n CA\\n 94110</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>69041</td>\n      <td>Washington Cafe</td>\n      <td>826 Washington St</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94108</td>\n      <td>37.7951</td>\n      <td>-122.407</td>\n      <td></td>\n      <td>H26</td>\n      <td>468548</td>\n      <td>Apr 18 2012 12:00AM</td>\n      <td>Washington Caf�, Inc. / Louis Kuang</td>\n      <td>333 Third Avenue\\n Daly City\\n CA\\n 94014</td>\n      <td>65</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103120: Moderate risk food ho...</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td>6018</td>\n      <td>3RD BAPTIST FELLOWSHIP HALL</td>\n      <td>1399 MCALLISTER St</td>\n      <td>SAN FRANCISCO</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94115</td>\n      <td>37.7782</td>\n      <td>-122.435</td>\n      <td></td>\n      <td>AA</td>\n      <td></td>\n      <td></td>\n      <td>3RD BAPTIST FELLOWSHIP HALL</td>\n      <td>1399 MC ALLISTER STREET\\n SAN FRANCISCO\\n CA\\n...</td>\n      <td>98</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103143: Inadequate warewashin...</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td>23702</td>\n      <td>Doo Bu Restaurant</td>\n      <td>1723 Buchanan St</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94115</td>\n      <td>37.786</td>\n      <td>-122.43</td>\n      <td></td>\n      <td>H25</td>\n      <td>205289</td>\n      <td>Jun 30 2006 12:00AM</td>\n      <td>Jung Un Hong</td>\n      <td>1723 Buchanan St\\n San Francisco\\n CA\\n 94115</td>\n      <td>90</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103154: Unclean or degraded f...</td>\n    </tr>\n    <tr>\n      <th>12</th>\n      <td>23702</td>\n      <td>Doo Bu Restaurant</td>\n      <td>1723 Buchanan St</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94115</td>\n      <td>37.786</td>\n      <td>-122.43</td>\n      <td></td>\n      <td>H25</td>\n      <td>205289</td>\n      <td>Jun 30 2006 12:00AM</td>\n      <td>Jung Un Hong</td>\n      <td>1723 Buchanan St\\n San Francisco\\n CA\\n 94115</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Complaint</td>\n      <td>[{\"description\":\"103154: Unclean or degraded f...</td>\n    </tr>\n    <tr>\n      <th>13</th>\n      <td>34244</td>\n      <td>Vital Tea Leaf Inc</td>\n      <td>905 Grant Ave</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94108</td>\n      <td>37.7953</td>\n      <td>-122.407</td>\n      <td></td>\n      <td>H25</td>\n      <td>417300</td>\n      <td>May 17 2007 12:00AM</td>\n      <td>Vital Tea Leaf Inc   Minh Hong Duong</td>\n      <td>905 Grant Ave\\n San Francisco\\n CA\\n 94108</td>\n      <td>100</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>14</th>\n      <td>63503</td>\n      <td>Mason Street Deli and Market</td>\n      <td>39 MASON</td>\n      <td>SF</td>\n      <td>SANFRAN</td>\n      <td>0.814806</td>\n      <td>94102</td>\n      <td>37.7841</td>\n      <td>-122.409</td>\n      <td>14155624312</td>\n      <td>H07</td>\n      <td>450988</td>\n      <td>Jun 28 2010 12:00AM</td>\n      <td>Hifdallah Ahmed Homran and Arkan Ali Hassan Al...</td>\n      <td>39 Mason Street\\n San Francisco\\n CA\\n 94102</td>\n      <td>100</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>15</th>\n      <td>1427</td>\n      <td>MIFUNE DON</td>\n      <td>22 PEACE PLAZA  275</td>\n      <td>SF</td>\n      <td>SANFRAN</td>\n      <td>0.814806</td>\n      <td>94115</td>\n      <td>37.785</td>\n      <td>-122.43</td>\n      <td>14155341993</td>\n      <td>H24</td>\n      <td>314685</td>\n      <td></td>\n      <td>Osaka Eiko, Inc</td>\n      <td>22 PEACE PLAZA, #275\\n SF\\n CA\\n 94115</td>\n      <td>86</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103102: Unclean hands or impr...</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td>3331</td>\n      <td>HARVEY'S</td>\n      <td>500 CASTRO St</td>\n      <td>SAN FRANCISCO</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94114</td>\n      <td>37.7607</td>\n      <td>-122.435</td>\n      <td>14155434278</td>\n      <td>H26</td>\n      <td>945743</td>\n      <td></td>\n      <td>LANGLEY ENTERPRISES</td>\n      <td>500 CASTRO ST\\n SF\\n CA\\n 94114</td>\n      <td>83</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103149: Wiping cloths not cle...</td>\n    </tr>\n    <tr>\n      <th>17</th>\n      <td>5907</td>\n      <td>LILIENTHAL ELEMENTARY SCHOOL</td>\n      <td>3630 DIVISADERO St</td>\n      <td>S.F.</td>\n      <td>S.F.</td>\n      <td>NaN</td>\n      <td>94118</td>\n      <td>37.8035</td>\n      <td>-122.444</td>\n      <td>14155743516</td>\n      <td>H91</td>\n      <td></td>\n      <td></td>\n      <td>San Francisco Unified School District</td>\n      <td>3630 Divisadero Street\\n San Francisco\\n CA\\n ...</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>18</th>\n      <td>65050</td>\n      <td>House of Banquet</td>\n      <td>939 Clement St</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94118</td>\n      <td>37.7827</td>\n      <td>-122.469</td>\n      <td>14155780203</td>\n      <td>H26</td>\n      <td>455173</td>\n      <td>Jan 11 2011 12:00AM</td>\n      <td>LYS Trading, Inc. / Yong Shong</td>\n      <td>939 Clement Street\\n San Francisco\\n CA\\n 94118</td>\n      <td>87</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103149: Wiping cloths not cle...</td>\n    </tr>\n    <tr>\n      <th>19</th>\n      <td>71534</td>\n      <td>7 Eleven #2366-36039A</td>\n      <td>644 Mission St</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94105</td>\n      <td></td>\n      <td></td>\n      <td>14155610309</td>\n      <td>H07</td>\n      <td>475970</td>\n      <td>Jan 24 2013 12:00AM</td>\n      <td>Bhrighu Muniwar, Inc.</td>\n      <td>538 Pyramid Ct.\\n Fairfield\\n CA\\n 94534</td>\n      <td>100</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>20</th>\n      <td>71769</td>\n      <td>Lucky One Mini Mart</td>\n      <td>1010 Market St</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94102</td>\n      <td>37.7819</td>\n      <td>-122.411</td>\n      <td></td>\n      <td>H24</td>\n      <td>473612</td>\n      <td>Feb 15 2013 12:00AM</td>\n      <td>Charles Ahn</td>\n      <td>1010 Market Street\\n San Francisco\\n CA\\n 94102</td>\n      <td>100</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>21</th>\n      <td>5884</td>\n      <td>Gordon J Lau Elementary School</td>\n      <td>950 Clay St</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94108</td>\n      <td>37.794</td>\n      <td>-122.409</td>\n      <td></td>\n      <td>H91</td>\n      <td></td>\n      <td></td>\n      <td>S.F. Unified School District</td>\n      <td>950  Clay St\\n San Francisco\\n CA\\n 94108</td>\n      <td>96</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103120: Moderate risk food ho...</td>\n    </tr>\n    <tr>\n      <th>22</th>\n      <td>69635</td>\n      <td>Sophie's Crepes</td>\n      <td>1581 Webster St 275</td>\n      <td>S.F.</td>\n      <td>S.F.</td>\n      <td>NaN</td>\n      <td>94115</td>\n      <td></td>\n      <td></td>\n      <td></td>\n      <td>H28</td>\n      <td>470456</td>\n      <td>Jul  5 2012 12:00AM</td>\n      <td>Sophie's Crepes, LLC</td>\n      <td>1581 Webster St., #275\\n SF\\n CA\\n 94115</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Non-inspection site visit</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>23</th>\n      <td>3633</td>\n      <td>Magnolia Pub &amp; Brewery</td>\n      <td>1398 Haight St</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94117</td>\n      <td>37.7703</td>\n      <td>-122.445</td>\n      <td></td>\n      <td>H26</td>\n      <td>306120</td>\n      <td></td>\n      <td>McLean Breweries, Inc</td>\n      <td>1398 Haight St\\n San Francisco\\n CA\\n 94117</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>24</th>\n      <td>5905</td>\n      <td>MARINA MIDDLE SCHOOL</td>\n      <td>3500 FILLMORE St</td>\n      <td>S.F.</td>\n      <td>S.F.</td>\n      <td>NaN</td>\n      <td>94123</td>\n      <td>37.8018</td>\n      <td>-122.436</td>\n      <td>14155743495</td>\n      <td>H91</td>\n      <td></td>\n      <td></td>\n      <td>San Francisco Unified School district</td>\n      <td>3500 Fillmore Street\\n San Francisco\\n CA\\n 94123</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>25</th>\n      <td>19277</td>\n      <td>Farmer Brown</td>\n      <td>25 Mason St</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94102</td>\n      <td>37.7837</td>\n      <td>-122.409</td>\n      <td></td>\n      <td>H26</td>\n      <td>397481</td>\n      <td>Apr 20 2006 12:00AM</td>\n      <td>Black Rabbit Hospitality</td>\n      <td>25 Mason St\\n San Francisco\\n CA\\n 94102</td>\n      <td>100</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>26</th>\n      <td>1775</td>\n      <td>Sapporo-Ya</td>\n      <td>1581 WEBSTER St</td>\n      <td>SF</td>\n      <td>SANFRAN</td>\n      <td>0.814806</td>\n      <td>94115</td>\n      <td>37.7852</td>\n      <td>-122.431</td>\n      <td>14155567400</td>\n      <td>H25</td>\n      <td>98407</td>\n      <td></td>\n      <td>TURNER SHIBATA INC.</td>\n      <td>1581 WEBSTER ST\\n SF\\n CA\\n 94115</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>27</th>\n      <td>61135</td>\n      <td>Old Mandarin Islamic Restaurant</td>\n      <td>3132 VICENTE St</td>\n      <td>SF</td>\n      <td>SANFRAN</td>\n      <td>0.814806</td>\n      <td>94116</td>\n      <td>37.7382</td>\n      <td>-122.501</td>\n      <td></td>\n      <td>H24</td>\n      <td>442429</td>\n      <td>Sep 14 2009 12:00AM</td>\n      <td>Shuai Yang</td>\n      <td>3132 Vicente St.\\n SF\\n CA\\n 94116</td>\n      <td>84</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103144: Unapproved or unmaint...</td>\n    </tr>\n    <tr>\n      <th>28</th>\n      <td>765</td>\n      <td>APERTO RESTAURANT</td>\n      <td>1434 18th St</td>\n      <td>S.F.</td>\n      <td>S.F.</td>\n      <td>NaN</td>\n      <td>94107</td>\n      <td>37.7626</td>\n      <td>-122.397</td>\n      <td></td>\n      <td>H24</td>\n      <td>921479</td>\n      <td>Apr 16 1992 12:00AM</td>\n      <td>APERTO INC.</td>\n      <td>245 LAWTON ST.\\n S.F.\\n CA\\n 94122</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>29</th>\n      <td>3373</td>\n      <td>New Delhi Restaurant</td>\n      <td>160 Ellis St</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94102</td>\n      <td>37.7855</td>\n      <td>-122.409</td>\n      <td></td>\n      <td>H26</td>\n      <td>173398</td>\n      <td></td>\n      <td>New Delhi Restaurant</td>\n      <td>160 Ellis St\\n San Francisco\\n CA\\n 94102</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>30</th>\n      <td>3373</td>\n      <td>New Delhi Restaurant</td>\n      <td>160 Ellis St</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94102</td>\n      <td>37.7855</td>\n      <td>-122.409</td>\n      <td></td>\n      <td>H26</td>\n      <td>173398</td>\n      <td></td>\n      <td>New Delhi Restaurant</td>\n      <td>160 Ellis St\\n San Francisco\\n CA\\n 94102</td>\n      <td></td>\n      <td>20130225</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>31</th>\n      <td>33891</td>\n      <td>Harlot</td>\n      <td>46 Minna St</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94105</td>\n      <td>37.7887</td>\n      <td>-122.398</td>\n      <td></td>\n      <td>H87</td>\n      <td>404920</td>\n      <td>Apr 26 2007 12:00AM</td>\n      <td>Vespertine, Inc   Robert Nunez</td>\n      <td>46 Minna Street\\n San Francisco\\n CA\\n 94105</td>\n      <td>87</td>\n      <td>20130225</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103119: Inadequate and inacce...</td>\n    </tr>\n    <tr>\n      <th>32</th>\n      <td>28828</td>\n      <td>The Sandwich Shop</td>\n      <td>635 19th St</td>\n      <td>S.F.</td>\n      <td>S.F.</td>\n      <td>NaN</td>\n      <td>94107</td>\n      <td>37.7617</td>\n      <td>-122.389</td>\n      <td></td>\n      <td>H28</td>\n      <td>402498</td>\n      <td>Oct 11 2006 12:00AM</td>\n      <td>Hye Hwa Cho</td>\n      <td>635 19th Street\\n SF\\n CA\\n 94107</td>\n      <td>88</td>\n      <td>20130226</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103124: Inadequately cleaned ...</td>\n    </tr>\n    <tr>\n      <th>33</th>\n      <td>60933</td>\n      <td>Mayes</td>\n      <td>1233 Polk St</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94109</td>\n      <td>37.7883</td>\n      <td>-122.42</td>\n      <td></td>\n      <td>H26</td>\n      <td>441175</td>\n      <td>Aug 27 2009 12:00AM</td>\n      <td>1233 Polk Street LLC   Fred Duncan</td>\n      <td>1233 Polk St\\n San Francisco\\n CA\\n 94109</td>\n      <td>85</td>\n      <td>20130226</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103114: High risk vermin infe...</td>\n    </tr>\n    <tr>\n      <th>34</th>\n      <td>62688</td>\n      <td>Auntie April's</td>\n      <td>4618 03rd St</td>\n      <td>SF</td>\n      <td>SANFRAN</td>\n      <td>0.814806</td>\n      <td>94124</td>\n      <td>37.7363</td>\n      <td>-122.39</td>\n      <td></td>\n      <td>H24</td>\n      <td>428950</td>\n      <td>Apr  2 2010 12:00AM</td>\n      <td>April Spears</td>\n      <td>4618 3rd Street\\n SF\\n CA\\n 94124</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>35</th>\n      <td>3373</td>\n      <td>New Delhi Restaurant</td>\n      <td>160 Ellis St</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94102</td>\n      <td>37.7855</td>\n      <td>-122.409</td>\n      <td></td>\n      <td>H26</td>\n      <td>173398</td>\n      <td></td>\n      <td>New Delhi Restaurant</td>\n      <td>160 Ellis St\\n San Francisco\\n CA\\n 94102</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>36</th>\n      <td>2756</td>\n      <td>STARBUCKS</td>\n      <td>3595 CALIFORNIA St</td>\n      <td>SF</td>\n      <td>SANFRAN</td>\n      <td>0.814806</td>\n      <td>94118</td>\n      <td>37.7864</td>\n      <td>-122.453</td>\n      <td></td>\n      <td>H25</td>\n      <td>911744</td>\n      <td>Oct 30 1995 12:00AM</td>\n      <td>STARBUCKS COFFEE CO, INC.</td>\n      <td>3595 CALIFORNIA ST\\n SF\\n CA\\n 94118</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[{\"description\":\"103157: Food safety certifica...</td>\n    </tr>\n    <tr>\n      <th>37</th>\n      <td>7489</td>\n      <td>GAS &amp; SHOP</td>\n      <td>599 South Van Ness Ave</td>\n      <td>S.F.</td>\n      <td>S.F.</td>\n      <td>NaN</td>\n      <td>94110</td>\n      <td>37.7638</td>\n      <td>-122.417</td>\n      <td>14155866835</td>\n      <td>H10</td>\n      <td>922993</td>\n      <td>Aug 13 1993 12:00AM</td>\n      <td>SELF SERVE PETROLEUM, INC.</td>\n      <td>2240 SKY FARM\\n HILLSBOROUGH\\n CA\\n 94010</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>38</th>\n      <td>19094</td>\n      <td>Rigolo</td>\n      <td>3465 California St</td>\n      <td>SF</td>\n      <td>SANFRAN</td>\n      <td>0.814806</td>\n      <td>94118</td>\n      <td>37.7867</td>\n      <td>-122.451</td>\n      <td></td>\n      <td>H25</td>\n      <td>373994</td>\n      <td>Mar  1 2004 12:00AM</td>\n      <td>Laurel Village Bakery LLC</td>\n      <td>2132 Pine Street\\n SF\\n CA\\n 94118</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>39</th>\n      <td>65051</td>\n      <td>Mission Cheese</td>\n      <td>736 Valencia St</td>\n      <td>SF</td>\n      <td>SANFRAN</td>\n      <td>0.814806</td>\n      <td>94110</td>\n      <td>37.7611</td>\n      <td>-122.422</td>\n      <td>14155558667</td>\n      <td>H24</td>\n      <td>455293</td>\n      <td>Jan 11 2011 12:00AM</td>\n      <td>Mission Cheese LLC</td>\n      <td>363 Hermann St.\\n SF\\n CA\\n 94117</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Non-inspection site visit</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>40</th>\n      <td>3802</td>\n      <td>THE GREAT AMERICAN MUSIC HALL</td>\n      <td>859 O'FARRELL St</td>\n      <td>SAN FRANCISCO</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94109</td>\n      <td>37.785</td>\n      <td>-122.419</td>\n      <td></td>\n      <td>H26</td>\n      <td>358240</td>\n      <td></td>\n      <td>MUSIC HALL, LLC</td>\n      <td>859 O'FARRELL St\\n SAN FRANCISCO\\n CA\\n 94109</td>\n      <td>94</td>\n      <td>20130226</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103161: Low risk vermin infes...</td>\n    </tr>\n    <tr>\n      <th>41</th>\n      <td>475</td>\n      <td>Mara's</td>\n      <td>503 Columbus Ave</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94133</td>\n      <td>37.7995</td>\n      <td>-122.409</td>\n      <td></td>\n      <td>H24</td>\n      <td>147903</td>\n      <td></td>\n      <td>Filomena &amp; Gennaro Torrano</td>\n      <td>503 Columbus Ave\\n San Francisco\\n CA\\n 94133</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>42</th>\n      <td>1193</td>\n      <td>PEET'S COFFEES &amp; TEAS</td>\n      <td>3419 CALIFORNIA St</td>\n      <td>SAN FRANCISCO</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94118</td>\n      <td>37.7868</td>\n      <td>-122.45</td>\n      <td></td>\n      <td>H24</td>\n      <td>196325</td>\n      <td></td>\n      <td>Peet's Coffee</td>\n      <td>3419 California\\n SF\\n CA\\n 94118</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>43</th>\n      <td>2548</td>\n      <td>NOAH'S NEW YORK BAGELS #2120</td>\n      <td>3519 CALIFORNIA St</td>\n      <td>SF</td>\n      <td>SANFRAN</td>\n      <td>0.814806</td>\n      <td>94118</td>\n      <td>37.7866</td>\n      <td>-122.452</td>\n      <td></td>\n      <td>H25</td>\n      <td>353177</td>\n      <td>Mar 15 2002 12:00AM</td>\n      <td>EINSTEIN AND NOAH CORP.</td>\n      <td>555 Zang St., Suite 300\\n Lakewood\\n CO\\n 80228</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>44</th>\n      <td>6913</td>\n      <td>XTRA OIL CORP</td>\n      <td>3750 03rd St</td>\n      <td>S.F.</td>\n      <td>S.F.</td>\n      <td>NaN</td>\n      <td>94124</td>\n      <td>37.7432</td>\n      <td>-122.388</td>\n      <td></td>\n      <td>H07</td>\n      <td>144903</td>\n      <td>May 17 1993 12:00AM</td>\n      <td>EDWARD T SIMAS</td>\n      <td>2307 PACIFIC AVE.\\n ALAMEDA\\n CA\\n 94501</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>45</th>\n      <td>4923</td>\n      <td>TED'S MARKET</td>\n      <td>1530 HOWARD St</td>\n      <td>S.F.</td>\n      <td>S.F.</td>\n      <td>NaN</td>\n      <td>94103</td>\n      <td>37.7727</td>\n      <td>-122.416</td>\n      <td></td>\n      <td>H28</td>\n      <td>321004</td>\n      <td></td>\n      <td>ZOUZOUNIS DAVID P</td>\n      <td>1530 HOWARD ST\\n SAN FRANCISCO\\n CA\\n 94103</td>\n      <td>100</td>\n      <td>20130226</td>\n      <td>Routine - Unscheduled</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>46</th>\n      <td>36020</td>\n      <td>Cadillac Market</td>\n      <td>499 Eddy St</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94109</td>\n      <td>37.7835</td>\n      <td>-122.416</td>\n      <td></td>\n      <td>H07</td>\n      <td>379395</td>\n      <td>Oct 29 2007 12:00AM</td>\n      <td>Irfan Barkat Ali</td>\n      <td>499 Eddy St\\n San Francisco\\n CA\\n 94109</td>\n      <td>98</td>\n      <td>20130226</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103143: Inadequate warewashin...</td>\n    </tr>\n    <tr>\n      <th>47</th>\n      <td>3935</td>\n      <td>Le Colonial, SF, LLC</td>\n      <td>20 Cosmo Pl</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94109</td>\n      <td>37.7881</td>\n      <td>-122.412</td>\n      <td></td>\n      <td>H26</td>\n      <td>317110</td>\n      <td></td>\n      <td>Le Colonial, SF, LLC</td>\n      <td>20  Cosmo PL\\n San Francisco\\n CA\\n 94109</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>48</th>\n      <td>1259</td>\n      <td>KD'S GROG &amp; GROCERY</td>\n      <td>2416 MARKET St</td>\n      <td>SF</td>\n      <td>SANFRAN</td>\n      <td>0.814806</td>\n      <td>94114</td>\n      <td>37.7626</td>\n      <td>-122.435</td>\n      <td>14155863736</td>\n      <td>H24</td>\n      <td>198913</td>\n      <td></td>\n      <td>KIM, SUNG U.</td>\n      <td>2416 MARKET ST.\\n SAN FRANCISCO\\n CA\\n 94114</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>49</th>\n      <td>65396</td>\n      <td>Carmelina's Cafe</td>\n      <td>1855 Folsom St</td>\n      <td>SF</td>\n      <td>SANFRAN</td>\n      <td>0.814806</td>\n      <td>94103</td>\n      <td>37.7677</td>\n      <td>-122.415</td>\n      <td></td>\n      <td>H24</td>\n      <td>181141</td>\n      <td>Mar  2 2011 12:00AM</td>\n      <td>Carmelina Narciso</td>\n      <td>1855 Folsom Street\\n SF\\n CA\\n 94103</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>50</th>\n      <td>477</td>\n      <td>Il Pollaio</td>\n      <td>555 Columbus Ave</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94133</td>\n      <td>37.8</td>\n      <td>-122.41</td>\n      <td></td>\n      <td>H24</td>\n      <td>147775</td>\n      <td></td>\n      <td>Antonio &amp; Jose Castellucci</td>\n      <td>555 Columbus Ave\\n San Francisco\\n CA\\n 94133</td>\n      <td>90</td>\n      <td>20130226</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103154: Unclean or degraded f...</td>\n    </tr>\n    <tr>\n      <th>51</th>\n      <td>1199</td>\n      <td>PANCHO'S</td>\n      <td>3440 GEARY Blvd</td>\n      <td>SAN FRANCISCO</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94118</td>\n      <td>37.7815</td>\n      <td>-122.456</td>\n      <td></td>\n      <td>H24</td>\n      <td>318180</td>\n      <td>Jun 17 1998 12:00AM</td>\n      <td>CAL. SOL. CONCEPTS LLC</td>\n      <td>3440  GEARY Blvd\\n S.F.\\n CA\\n 94118</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Reinspection/Followup</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>52</th>\n      <td>1549</td>\n      <td>Cafe Bellini</td>\n      <td>235 Powell St</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94102</td>\n      <td>37.787</td>\n      <td>-122.408</td>\n      <td></td>\n      <td>H25</td>\n      <td>384285</td>\n      <td></td>\n      <td>SEGA FOOD GROUP INC</td>\n      <td>\\t235 POWELL ST\\n SAN FRANCISCO\\n CA\\n 94102</td>\n      <td>96</td>\n      <td>20130226</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103124: Inadequately cleaned ...</td>\n    </tr>\n    <tr>\n      <th>53</th>\n      <td>4257</td>\n      <td>DELUXE</td>\n      <td>1509 HAIGHT St</td>\n      <td>SF</td>\n      <td>SANFRAN</td>\n      <td>0.814806</td>\n      <td>94117</td>\n      <td>37.7699</td>\n      <td>-122.447</td>\n      <td>14155556949</td>\n      <td>H25</td>\n      <td></td>\n      <td></td>\n      <td>JAY JOHNSON</td>\n      <td>1509 HAIGHT STREET\\n SAN FRANCISCO\\n CA\\n 94117</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Administrative or Document Review</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>54</th>\n      <td>68775</td>\n      <td>Dandelion Chocolate</td>\n      <td>740 Valencia St</td>\n      <td>San Francisco</td>\n      <td>SANFRAN</td>\n      <td>1.000000</td>\n      <td>94110</td>\n      <td>37.761</td>\n      <td>-122.422</td>\n      <td></td>\n      <td>H26</td>\n      <td>466375</td>\n      <td>Mar 21 2012 12:00AM</td>\n      <td>Cocoa Co., Inc.</td>\n      <td>334 Santana Row #335\\n San Jose\\n Ca\\n 95128</td>\n      <td></td>\n      <td>20130226</td>\n      <td>Complaint</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>55</th>\n      <td>68037</td>\n      <td>Focaccia Market Bakery</td>\n      <td>185 BERRY St #1430</td>\n      <td>S.F.</td>\n      <td>S.F.</td>\n      <td>NaN</td>\n      <td>94107</td>\n      <td>37.776</td>\n      <td>-122.393</td>\n      <td></td>\n      <td>H26</td>\n      <td>455335</td>\n      <td>Dec  1 2011 12:00AM</td>\n      <td>Focaccia Market Bakery, Inc.</td>\n      <td>119 Sacramento St.\\n SF\\n CA\\n 94111</td>\n      <td>91</td>\n      <td>20130226</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103109: Unclean or unsanitary...</td>\n    </tr>\n    <tr>\n      <th>56</th>\n      <td>69945</td>\n      <td>Linda's Catering</td>\n      <td>290 Townsend St</td>\n      <td>SF</td>\n      <td>SANFRAN</td>\n      <td>0.814806</td>\n      <td>94107</td>\n      <td></td>\n      <td></td>\n      <td></td>\n      <td>H79</td>\n      <td>470527</td>\n      <td>Aug 15 2012 12:00AM</td>\n      <td>Hong Yan Fang-Li</td>\n      <td>3623 Kirkham St.\\n SF\\n CA\\n 94122</td>\n      <td>96</td>\n      <td>20130226</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103142: Unclean nonfood conta...</td>\n    </tr>\n    <tr>\n      <th>57</th>\n      <td>70920</td>\n      <td>Stock in Trade</td>\n      <td>2036 LOMBARD St</td>\n      <td>SF</td>\n      <td>SANFRAN</td>\n      <td>0.814806</td>\n      <td>94123</td>\n      <td></td>\n      <td></td>\n      <td></td>\n      <td>H26</td>\n      <td>470757</td>\n      <td>Nov  9 2012 12:00AM</td>\n      <td>4 Item Combo Plate / Tod Alsman, Chris Fogarty</td>\n      <td>2036 Lombard Street\\n San Francisco\\n CA\\n 94123</td>\n      <td>90</td>\n      <td>20130226</td>\n      <td>Routine - Unscheduled</td>\n      <td>[{\"description\":\"103149: Wiping cloths not cle...</td>\n    </tr>\n  </tbody>\n</table>\n</div>",
            "text/plain": "   inspections.business.business_id        inspections.business.name  \\\n0                             16162        Quick-N-Ezee Indian Foods   \n1                             69707             Little Green Cyclo 2   \n2                             67565        King of Thai Noodles Cafe   \n3                             67565        King of Thai Noodles Cafe   \n4                             68701                           Grindz   \n5                             69186  Premier Catering & Events, Inc.   \n6                              2689                   THE BLUE PLATE   \n7                             15806                   Vital Tea Leaf   \n8                             21807                  The Front Porch   \n9                             69041                  Washington Cafe   \n10                             6018      3RD BAPTIST FELLOWSHIP HALL   \n11                            23702                Doo Bu Restaurant   \n12                            23702                Doo Bu Restaurant   \n13                            34244               Vital Tea Leaf Inc   \n14                            63503     Mason Street Deli and Market   \n15                             1427                       MIFUNE DON   \n16                             3331                         HARVEY'S   \n17                             5907     LILIENTHAL ELEMENTARY SCHOOL   \n18                            65050                 House of Banquet   \n19                            71534            7 Eleven #2366-36039A   \n20                            71769              Lucky One Mini Mart   \n21                             5884   Gordon J Lau Elementary School   \n22                            69635                  Sophie's Crepes   \n23                             3633           Magnolia Pub & Brewery   \n24                             5905             MARINA MIDDLE SCHOOL   \n25                            19277                     Farmer Brown   \n26                             1775                       Sapporo-Ya   \n27                            61135  Old Mandarin Islamic Restaurant   \n28                              765                APERTO RESTAURANT   \n29                             3373             New Delhi Restaurant   \n30                             3373             New Delhi Restaurant   \n31                            33891                           Harlot   \n32                            28828                The Sandwich Shop   \n33                            60933                            Mayes   \n34                            62688                   Auntie April's   \n35                             3373             New Delhi Restaurant   \n36                             2756                        STARBUCKS   \n37                             7489                       GAS & SHOP   \n38                            19094                           Rigolo   \n39                            65051                   Mission Cheese   \n40                             3802    THE GREAT AMERICAN MUSIC HALL   \n41                              475                           Mara's   \n42                             1193            PEET'S COFFEES & TEAS   \n43                             2548     NOAH'S NEW YORK BAGELS #2120   \n44                             6913                    XTRA OIL CORP   \n45                             4923                     TED'S MARKET   \n46                            36020                  Cadillac Market   \n47                             3935             Le Colonial, SF, LLC   \n48                             1259              KD'S GROG & GROCERY   \n49                            65396                 Carmelina's Cafe   \n50                              477                       Il Pollaio   \n51                             1199                         PANCHO'S   \n52                             1549                     Cafe Bellini   \n53                             4257                           DELUXE   \n54                            68775              Dandelion Chocolate   \n55                            68037           Focaccia Market Bakery   \n56                            69945                 Linda's Catering   \n57                            70920                   Stock in Trade   \n\n   inspections.business.address inspections.business.city city_grouped  \\\n0                 3861 24th St                         SF      SANFRAN   \n1                Off The Grid                                            \n2              1541 TARAVAL St              SAN FRANCISCO      SANFRAN   \n3              1541 TARAVAL St              SAN FRANCISCO      SANFRAN   \n4               832 Clement St                         SF      SANFRAN   \n5                 1255 22nd St                       S.F.         S.F.   \n6              3218 MISSION St                         SF      SANFRAN   \n7                1044 Grant Ave             San Francisco      SANFRAN   \n8                  65 29th St A                        SF      SANFRAN   \n9            826 Washington St              San Francisco      SANFRAN   \n10          1399 MCALLISTER St              SAN FRANCISCO      SANFRAN   \n11             1723 Buchanan St             San Francisco      SANFRAN   \n12             1723 Buchanan St             San Francisco      SANFRAN   \n13               905 Grant Ave              San Francisco      SANFRAN   \n14                     39 MASON                        SF      SANFRAN   \n15          22 PEACE PLAZA  275                        SF      SANFRAN   \n16               500 CASTRO St              SAN FRANCISCO      SANFRAN   \n17          3630 DIVISADERO St                       S.F.         S.F.   \n18              939 Clement St              San Francisco      SANFRAN   \n19              644 Mission St              San Francisco      SANFRAN   \n20              1010 Market St              San Francisco      SANFRAN   \n21                  950 Clay St             San Francisco      SANFRAN   \n22          1581 Webster St 275                      S.F.         S.F.   \n23               1398 Haight St             San Francisco      SANFRAN   \n24            3500 FILLMORE St                       S.F.         S.F.   \n25                 25 Mason St              San Francisco      SANFRAN   \n26             1581 WEBSTER St                         SF      SANFRAN   \n27             3132 VICENTE St                         SF      SANFRAN   \n28                1434 18th St                       S.F.         S.F.   \n29                160 Ellis St              San Francisco      SANFRAN   \n30                160 Ellis St              San Francisco      SANFRAN   \n31                 46 Minna St              San Francisco      SANFRAN   \n32                 635 19th St                       S.F.         S.F.   \n33                1233 Polk St              San Francisco      SANFRAN   \n34                4618 03rd St                         SF      SANFRAN   \n35                160 Ellis St              San Francisco      SANFRAN   \n36          3595 CALIFORNIA St                         SF      SANFRAN   \n37      599 South Van Ness Ave                       S.F.         S.F.   \n38          3465 California St                         SF      SANFRAN   \n39             736 Valencia St                         SF      SANFRAN   \n40            859 O'FARRELL St              SAN FRANCISCO      SANFRAN   \n41            503 Columbus Ave              San Francisco      SANFRAN   \n42          3419 CALIFORNIA St              SAN FRANCISCO      SANFRAN   \n43          3519 CALIFORNIA St                         SF      SANFRAN   \n44                3750 03rd St                       S.F.         S.F.   \n45              1530 HOWARD St                       S.F.         S.F.   \n46                  499 Eddy St             San Francisco      SANFRAN   \n47                 20 Cosmo Pl              San Francisco      SANFRAN   \n48              2416 MARKET St                         SF      SANFRAN   \n49              1855 Folsom St                         SF      SANFRAN   \n50            555 Columbus Ave              San Francisco      SANFRAN   \n51             3440 GEARY Blvd              SAN FRANCISCO      SANFRAN   \n52               235 Powell St              San Francisco      SANFRAN   \n53              1509 HAIGHT St                         SF      SANFRAN   \n54             740 Valencia St              San Francisco      SANFRAN   \n55           185 BERRY St #1430                      S.F.         S.F.   \n56             290 Townsend St                         SF      SANFRAN   \n57             2036 LOMBARD St                         SF      SANFRAN   \n\n    similarity_score inspections.business.postal_code  \\\n0           0.814806                            94114   \n1                NaN                                    \n2           1.000000                            94116   \n3           1.000000                            94116   \n4           0.814806                            94118   \n5                NaN                            94107   \n6           0.814806                            94110   \n7           1.000000                            94133   \n8           0.814806                            94110   \n9           1.000000                            94108   \n10          1.000000                            94115   \n11          1.000000                            94115   \n12          1.000000                            94115   \n13          1.000000                            94108   \n14          0.814806                            94102   \n15          0.814806                            94115   \n16          1.000000                            94114   \n17               NaN                            94118   \n18          1.000000                            94118   \n19          1.000000                            94105   \n20          1.000000                            94102   \n21          1.000000                            94108   \n22               NaN                            94115   \n23          1.000000                            94117   \n24               NaN                            94123   \n25          1.000000                            94102   \n26          0.814806                            94115   \n27          0.814806                            94116   \n28               NaN                            94107   \n29          1.000000                            94102   \n30          1.000000                            94102   \n31          1.000000                            94105   \n32               NaN                            94107   \n33          1.000000                            94109   \n34          0.814806                            94124   \n35          1.000000                            94102   \n36          0.814806                            94118   \n37               NaN                            94110   \n38          0.814806                            94118   \n39          0.814806                            94110   \n40          1.000000                            94109   \n41          1.000000                            94133   \n42          1.000000                            94118   \n43          0.814806                            94118   \n44               NaN                            94124   \n45               NaN                            94103   \n46          1.000000                            94109   \n47          1.000000                            94109   \n48          0.814806                            94114   \n49          0.814806                            94103   \n50          1.000000                            94133   \n51          1.000000                            94118   \n52          1.000000                            94102   \n53          0.814806                            94117   \n54          1.000000                            94110   \n55               NaN                            94107   \n56          0.814806                            94107   \n57          0.814806                            94123   \n\n   inspections.business.latitude inspections.business.longitude  \\\n0                                                                 \n1                                                                 \n2                        37.7427                       -122.483   \n3                        37.7427                       -122.483   \n4                        37.7828                       -122.468   \n5                                                                 \n6                        37.7452                        -122.42   \n7                        37.7966                       -122.407   \n8                        37.7439                       -122.422   \n9                        37.7951                       -122.407   \n10                       37.7782                       -122.435   \n11                        37.786                        -122.43   \n12                        37.786                        -122.43   \n13                       37.7953                       -122.407   \n14                       37.7841                       -122.409   \n15                        37.785                        -122.43   \n16                       37.7607                       -122.435   \n17                       37.8035                       -122.444   \n18                       37.7827                       -122.469   \n19                                                                \n20                       37.7819                       -122.411   \n21                        37.794                       -122.409   \n22                                                                \n23                       37.7703                       -122.445   \n24                       37.8018                       -122.436   \n25                       37.7837                       -122.409   \n26                       37.7852                       -122.431   \n27                       37.7382                       -122.501   \n28                       37.7626                       -122.397   \n29                       37.7855                       -122.409   \n30                       37.7855                       -122.409   \n31                       37.7887                       -122.398   \n32                       37.7617                       -122.389   \n33                       37.7883                        -122.42   \n34                       37.7363                        -122.39   \n35                       37.7855                       -122.409   \n36                       37.7864                       -122.453   \n37                       37.7638                       -122.417   \n38                       37.7867                       -122.451   \n39                       37.7611                       -122.422   \n40                        37.785                       -122.419   \n41                       37.7995                       -122.409   \n42                       37.7868                        -122.45   \n43                       37.7866                       -122.452   \n44                       37.7432                       -122.388   \n45                       37.7727                       -122.416   \n46                       37.7835                       -122.416   \n47                       37.7881                       -122.412   \n48                       37.7626                       -122.435   \n49                       37.7677                       -122.415   \n50                          37.8                        -122.41   \n51                       37.7815                       -122.456   \n52                        37.787                       -122.408   \n53                       37.7699                       -122.447   \n54                        37.761                       -122.422   \n55                        37.776                       -122.393   \n56                                                                \n57                                                                \n\n   inspections.business.phone_number inspections.business.TaxCode  \\\n0                                                             H34   \n1                                                             H79   \n2                                                             H25   \n3                                                             H25   \n4                                                             H25   \n5                        14155530288                          H30   \n6                        14155286777                          H25   \n7                                                             H24   \n8                                                             H25   \n9                                                             H26   \n10                                                             AA   \n11                                                            H25   \n12                                                            H25   \n13                                                            H25   \n14                       14155624312                          H07   \n15                       14155341993                          H24   \n16                       14155434278                          H26   \n17                       14155743516                          H91   \n18                       14155780203                          H26   \n19                       14155610309                          H07   \n20                                                            H24   \n21                                                            H91   \n22                                                            H28   \n23                                                            H26   \n24                       14155743495                          H91   \n25                                                            H26   \n26                       14155567400                          H25   \n27                                                            H24   \n28                                                            H24   \n29                                                            H26   \n30                                                            H26   \n31                                                            H87   \n32                                                            H28   \n33                                                            H26   \n34                                                            H24   \n35                                                            H26   \n36                                                            H25   \n37                       14155866835                          H10   \n38                                                            H25   \n39                       14155558667                          H24   \n40                                                            H26   \n41                                                            H24   \n42                                                            H24   \n43                                                            H25   \n44                                                            H07   \n45                                                            H28   \n46                                                            H07   \n47                                                            H26   \n48                       14155863736                          H24   \n49                                                            H24   \n50                                                            H24   \n51                                                            H24   \n52                                                            H25   \n53                       14155556949                          H25   \n54                                                            H26   \n55                                                            H26   \n56                                                            H79   \n57                                                            H26   \n\n   inspections.business.business_certificate  \\\n0                                     467114   \n1                                     453248   \n2                                              \n3                                              \n4                                     467498   \n5                                     362812   \n6                                     325714   \n7                                     388301   \n8                                     398500   \n9                                     468548   \n10                                             \n11                                    205289   \n12                                    205289   \n13                                    417300   \n14                                    450988   \n15                                    314685   \n16                                    945743   \n17                                             \n18                                    455173   \n19                                    475970   \n20                                    473612   \n21                                             \n22                                    470456   \n23                                    306120   \n24                                             \n25                                    397481   \n26                                     98407   \n27                                    442429   \n28                                    921479   \n29                                    173398   \n30                                    173398   \n31                                    404920   \n32                                    402498   \n33                                    441175   \n34                                    428950   \n35                                    173398   \n36                                    911744   \n37                                    922993   \n38                                    373994   \n39                                    455293   \n40                                    358240   \n41                                    147903   \n42                                    196325   \n43                                    353177   \n44                                    144903   \n45                                    321004   \n46                                    379395   \n47                                    317110   \n48                                    198913   \n49                                    181141   \n50                                    147775   \n51                                    318180   \n52                                    384285   \n53                                             \n54                                    466375   \n55                                    455335   \n56                                    470527   \n57                                    470757   \n\n   inspections.business.application_date  \\\n0                    May  9 2005 12:00AM   \n1                    Jul 12 2012 12:00AM   \n2                    Oct 12 2011 12:00AM   \n3                    Oct 12 2011 12:00AM   \n4                    Mar 16 2012 12:00AM   \n5                    Apr 30 2012 12:00AM   \n6                                          \n7                    May 23 2005 12:00AM   \n8                    Jun  7 2006 12:00AM   \n9                    Apr 18 2012 12:00AM   \n10                                         \n11                   Jun 30 2006 12:00AM   \n12                   Jun 30 2006 12:00AM   \n13                   May 17 2007 12:00AM   \n14                   Jun 28 2010 12:00AM   \n15                                         \n16                                         \n17                                         \n18                   Jan 11 2011 12:00AM   \n19                   Jan 24 2013 12:00AM   \n20                   Feb 15 2013 12:00AM   \n21                                         \n22                   Jul  5 2012 12:00AM   \n23                                         \n24                                         \n25                   Apr 20 2006 12:00AM   \n26                                         \n27                   Sep 14 2009 12:00AM   \n28                   Apr 16 1992 12:00AM   \n29                                         \n30                                         \n31                   Apr 26 2007 12:00AM   \n32                   Oct 11 2006 12:00AM   \n33                   Aug 27 2009 12:00AM   \n34                   Apr  2 2010 12:00AM   \n35                                         \n36                   Oct 30 1995 12:00AM   \n37                   Aug 13 1993 12:00AM   \n38                   Mar  1 2004 12:00AM   \n39                   Jan 11 2011 12:00AM   \n40                                         \n41                                         \n42                                         \n43                   Mar 15 2002 12:00AM   \n44                   May 17 1993 12:00AM   \n45                                         \n46                   Oct 29 2007 12:00AM   \n47                                         \n48                                         \n49                   Mar  2 2011 12:00AM   \n50                                         \n51                   Jun 17 1998 12:00AM   \n52                                         \n53                                         \n54                   Mar 21 2012 12:00AM   \n55                   Dec  1 2011 12:00AM   \n56                   Aug 15 2012 12:00AM   \n57                   Nov  9 2012 12:00AM   \n\n                      inspections.business.owner_name  \\\n0                                Jagpreet Enterprises   \n1                                LITTLEGREENCYCLO LLC   \n2                             Royal Thai Noodles, Inc   \n3                             Royal Thai Noodles, Inc   \n4                                     Ono Grindz, LLC   \n5                     Premier Catering & Events, Inc.   \n6                                    BLUE ENCLAVE LLC   \n7                                       Minh H. Duong   \n8                          Front Porch Restaurant LLC   \n9                 Washington Caf�, Inc. / Louis Kuang   \n10                        3RD BAPTIST FELLOWSHIP HALL   \n11                                       Jung Un Hong   \n12                                       Jung Un Hong   \n13               Vital Tea Leaf Inc   Minh Hong Duong   \n14  Hifdallah Ahmed Homran and Arkan Ali Hassan Al...   \n15                                    Osaka Eiko, Inc   \n16                                LANGLEY ENTERPRISES   \n17              San Francisco Unified School District   \n18                     LYS Trading, Inc. / Yong Shong   \n19                              Bhrighu Muniwar, Inc.   \n20                                        Charles Ahn   \n21                       S.F. Unified School District   \n22                               Sophie's Crepes, LLC   \n23                              McLean Breweries, Inc   \n24              San Francisco Unified School district   \n25                           Black Rabbit Hospitality   \n26                                TURNER SHIBATA INC.   \n27                                         Shuai Yang   \n28                                        APERTO INC.   \n29                               New Delhi Restaurant   \n30                               New Delhi Restaurant   \n31                     Vespertine, Inc   Robert Nunez   \n32                                        Hye Hwa Cho   \n33                 1233 Polk Street LLC   Fred Duncan   \n34                                       April Spears   \n35                               New Delhi Restaurant   \n36                          STARBUCKS COFFEE CO, INC.   \n37                         SELF SERVE PETROLEUM, INC.   \n38                          Laurel Village Bakery LLC   \n39                                 Mission Cheese LLC   \n40                                    MUSIC HALL, LLC   \n41                         Filomena & Gennaro Torrano   \n42                                      Peet's Coffee   \n43                            EINSTEIN AND NOAH CORP.   \n44                                     EDWARD T SIMAS   \n45                                  ZOUZOUNIS DAVID P   \n46                                   Irfan Barkat Ali   \n47                               Le Colonial, SF, LLC   \n48                                       KIM, SUNG U.   \n49                                  Carmelina Narciso   \n50                         Antonio & Jose Castellucci   \n51                             CAL. SOL. CONCEPTS LLC   \n52                                SEGA FOOD GROUP INC   \n53                                        JAY JOHNSON   \n54                                    Cocoa Co., Inc.   \n55                       Focaccia Market Bakery, Inc.   \n56                                   Hong Yan Fang-Li   \n57     4 Item Combo Plate / Tod Alsman, Chris Fogarty   \n\n                   inspections.business.owner_address inspections.Score  \\\n0          23682 Clawiter Road\\n Hayward\\n CA\\n 94545               100   \n1   100 Esplanade Ave., Apt. 99\\n Pacifica\\n CA\\n ...                93   \n2                     2410 19th Ave\\n SF\\n CA\\n 94116                79   \n3                     2410 19th Ave\\n SF\\n CA\\n 94116                     \n4             1055 Granada St.\\n Vallejo\\n CA\\n 94591               100   \n5                 298 Magellan Ave.\\n SF\\n CA\\n 94116                     \n6       3218 MISSION ST.\\n SAN FRANCISCO\\n CA\\n 94110                98   \n7         1044 Grant Ave\\n San Francisco\\n CA\\n 94133                98   \n8                   65A 29th Street\\n SF\\n CA\\n 94110                     \n9           333 Third Avenue\\n Daly City\\n CA\\n 94014                65   \n10  1399 MC ALLISTER STREET\\n SAN FRANCISCO\\n CA\\n...                98   \n11      1723 Buchanan St\\n San Francisco\\n CA\\n 94115                90   \n12      1723 Buchanan St\\n San Francisco\\n CA\\n 94115                     \n13         905 Grant Ave\\n San Francisco\\n CA\\n 94108               100   \n14       39 Mason Street\\n San Francisco\\n CA\\n 94102               100   \n15             22 PEACE PLAZA, #275\\n SF\\n CA\\n 94115                86   \n16                    500 CASTRO ST\\n SF\\n CA\\n 94114                83   \n17  3630 Divisadero Street\\n San Francisco\\n CA\\n ...                     \n18    939 Clement Street\\n San Francisco\\n CA\\n 94118                87   \n19           538 Pyramid Ct.\\n Fairfield\\n CA\\n 94534               100   \n20    1010 Market Street\\n San Francisco\\n CA\\n 94102               100   \n21          950  Clay St\\n San Francisco\\n CA\\n 94108                96   \n22           1581 Webster St., #275\\n SF\\n CA\\n 94115                     \n23        1398 Haight St\\n San Francisco\\n CA\\n 94117                     \n24  3500 Fillmore Street\\n San Francisco\\n CA\\n 94123                     \n25           25 Mason St\\n San Francisco\\n CA\\n 94102               100   \n26                  1581 WEBSTER ST\\n SF\\n CA\\n 94115                     \n27                 3132 Vicente St.\\n SF\\n CA\\n 94116                84   \n28                 245 LAWTON ST.\\n S.F.\\n CA\\n 94122                     \n29          160 Ellis St\\n San Francisco\\n CA\\n 94102                     \n30          160 Ellis St\\n San Francisco\\n CA\\n 94102                     \n31       46 Minna Street\\n San Francisco\\n CA\\n 94105                87   \n32                  635 19th Street\\n SF\\n CA\\n 94107                88   \n33          1233 Polk St\\n San Francisco\\n CA\\n 94109                85   \n34                  4618 3rd Street\\n SF\\n CA\\n 94124                     \n35          160 Ellis St\\n San Francisco\\n CA\\n 94102                     \n36               3595 CALIFORNIA ST\\n SF\\n CA\\n 94118                     \n37          2240 SKY FARM\\n HILLSBOROUGH\\n CA\\n 94010                     \n38                 2132 Pine Street\\n SF\\n CA\\n 94118                     \n39                  363 Hermann St.\\n SF\\n CA\\n 94117                     \n40      859 O'FARRELL St\\n SAN FRANCISCO\\n CA\\n 94109                94   \n41      503 Columbus Ave\\n San Francisco\\n CA\\n 94133                     \n42                  3419 California\\n SF\\n CA\\n 94118                     \n43    555 Zang St., Suite 300\\n Lakewood\\n CO\\n 80228                     \n44           2307 PACIFIC AVE.\\n ALAMEDA\\n CA\\n 94501                     \n45        1530 HOWARD ST\\n SAN FRANCISCO\\n CA\\n 94103               100   \n46           499 Eddy St\\n San Francisco\\n CA\\n 94109                98   \n47          20  Cosmo PL\\n San Francisco\\n CA\\n 94109                     \n48       2416 MARKET ST.\\n SAN FRANCISCO\\n CA\\n 94114                     \n49               1855 Folsom Street\\n SF\\n CA\\n 94103                     \n50      555 Columbus Ave\\n San Francisco\\n CA\\n 94133                90   \n51               3440  GEARY Blvd\\n S.F.\\n CA\\n 94118                     \n52       \\t235 POWELL ST\\n SAN FRANCISCO\\n CA\\n 94102                96   \n53    1509 HAIGHT STREET\\n SAN FRANCISCO\\n CA\\n 94117                     \n54       334 Santana Row #335\\n San Jose\\n Ca\\n 95128                     \n55               119 Sacramento St.\\n SF\\n CA\\n 94111                91   \n56                 3623 Kirkham St.\\n SF\\n CA\\n 94122                96   \n57   2036 Lombard Street\\n San Francisco\\n CA\\n 94123                90   \n\n   inspections.date                   inspections.type  \\\n0          20130223              Routine - Unscheduled   \n1          20130224              Routine - Unscheduled   \n2          20130225              Routine - Unscheduled   \n3          20130225                          Complaint   \n4          20130225              Routine - Unscheduled   \n5          20130225              Reinspection/Followup   \n6          20130225              Routine - Unscheduled   \n7          20130225              Routine - Unscheduled   \n8          20130225              Reinspection/Followup   \n9          20130225              Routine - Unscheduled   \n10         20130225              Routine - Unscheduled   \n11         20130225              Routine - Unscheduled   \n12         20130225                          Complaint   \n13         20130225              Routine - Unscheduled   \n14         20130225              Routine - Unscheduled   \n15         20130225              Routine - Unscheduled   \n16         20130225              Routine - Unscheduled   \n17         20130225              Reinspection/Followup   \n18         20130225              Routine - Unscheduled   \n19         20130225              Routine - Unscheduled   \n20         20130225              Routine - Unscheduled   \n21         20130225              Routine - Unscheduled   \n22         20130225          Non-inspection site visit   \n23         20130225              Reinspection/Followup   \n24         20130225              Reinspection/Followup   \n25         20130225              Routine - Unscheduled   \n26         20130225              Reinspection/Followup   \n27         20130225              Routine - Unscheduled   \n28         20130225              Reinspection/Followup   \n29         20130225              Reinspection/Followup   \n30         20130225              Reinspection/Followup   \n31         20130225              Routine - Unscheduled   \n32         20130226              Routine - Unscheduled   \n33         20130226              Routine - Unscheduled   \n34         20130226              Reinspection/Followup   \n35         20130226              Reinspection/Followup   \n36         20130226              Reinspection/Followup   \n37         20130226              Reinspection/Followup   \n38         20130226              Reinspection/Followup   \n39         20130226          Non-inspection site visit   \n40         20130226              Routine - Unscheduled   \n41         20130226              Reinspection/Followup   \n42         20130226              Reinspection/Followup   \n43         20130226              Reinspection/Followup   \n44         20130226              Reinspection/Followup   \n45         20130226              Routine - Unscheduled   \n46         20130226              Routine - Unscheduled   \n47         20130226              Reinspection/Followup   \n48         20130226              Reinspection/Followup   \n49         20130226              Reinspection/Followup   \n50         20130226              Routine - Unscheduled   \n51         20130226              Reinspection/Followup   \n52         20130226              Routine - Unscheduled   \n53         20130226  Administrative or Document Review   \n54         20130226                          Complaint   \n55         20130226              Routine - Unscheduled   \n56         20130226              Routine - Unscheduled   \n57         20130226              Routine - Unscheduled   \n\n                               inspections.violations  \n0                                                  []  \n1   [{\"description\":\"103112: No hot water or runni...  \n2   [{\"description\":\"103139: Improper food storage...  \n3   [{\"description\":\"103139: Improper food storage...  \n4                                                  []  \n5                                                  []  \n6   [{\"description\":\"103143: Inadequate warewashin...  \n7   [{\"description\":\"103157: Food safety certifica...  \n8                                                  []  \n9   [{\"description\":\"103120: Moderate risk food ho...  \n10  [{\"description\":\"103143: Inadequate warewashin...  \n11  [{\"description\":\"103154: Unclean or degraded f...  \n12  [{\"description\":\"103154: Unclean or degraded f...  \n13                                                 []  \n14                                                 []  \n15  [{\"description\":\"103102: Unclean hands or impr...  \n16  [{\"description\":\"103149: Wiping cloths not cle...  \n17                                                 []  \n18  [{\"description\":\"103149: Wiping cloths not cle...  \n19                                                 []  \n20                                                 []  \n21  [{\"description\":\"103120: Moderate risk food ho...  \n22                                                 []  \n23                                                 []  \n24                                                 []  \n25                                                 []  \n26                                                 []  \n27  [{\"description\":\"103144: Unapproved or unmaint...  \n28                                                 []  \n29                                                 []  \n30                                                 []  \n31  [{\"description\":\"103119: Inadequate and inacce...  \n32  [{\"description\":\"103124: Inadequately cleaned ...  \n33  [{\"description\":\"103114: High risk vermin infe...  \n34                                                 []  \n35                                                 []  \n36  [{\"description\":\"103157: Food safety certifica...  \n37                                                 []  \n38                                                 []  \n39                                                 []  \n40  [{\"description\":\"103161: Low risk vermin infes...  \n41                                                 []  \n42                                                 []  \n43                                                 []  \n44                                                 []  \n45                                                 []  \n46  [{\"description\":\"103143: Inadequate warewashin...  \n47                                                 []  \n48                                                 []  \n49                                                 []  \n50  [{\"description\":\"103154: Unclean or degraded f...  \n51                                                 []  \n52  [{\"description\":\"103124: Inadequately cleaned ...  \n53                                                 []  \n54                                                 []  \n55  [{\"description\":\"103109: Unclean or unsanitary...  \n56  [{\"description\":\"103142: Unclean nonfood conta...  \n57  [{\"description\":\"103149: Wiping cloths not cle...  "
          },
          "metadata": {}
        }
      ]
    },
    {
      "metadata": {
        "trusted": true
      },
      "cell_type": "code",
      "source": "",
      "execution_count": null,
      "outputs": []
    },
    {
      "metadata": {
        "trusted": true
      },
      "cell_type": "code",
      "source": "",
      "execution_count": null,
      "outputs": []
    }
  ],
  "metadata": {
    "kernelspec": {
      "name": "python36",
      "display_name": "Python 3.6",
      "language": "python"
    },
    "language_info": {
      "mimetype": "text/x-python",
      "nbconvert_exporter": "python",
      "name": "python",
      "pygments_lexer": "ipython3",
      "version": "3.6.6",
      "file_extension": ".py",
      "codemirror_mode": {
        "version": 3,
        "name": "ipython"
      }
    }
  },
  "nbformat": 4,
  "nbformat_minor": 2
}