Converting CSV file to SQLite.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import sqlite3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "schools_df =  pd.read_csv('DOE_High_School_Directory_2016-geocoded.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "scores_df = pd.read_csv('SAT__College_Board__2010_School_Level_Results.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "conn = sqlite3.connect('schools.db') #literally everyone says 'conn'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "schools_df.to_sql('schools' , conn)\n",
    "scores_df.to_sql('sat_scores' , conn)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>dbn</th>\n",
       "      <th>school_name</th>\n",
       "      <th>boro</th>\n",
       "      <th>building_code</th>\n",
       "      <th>shared_space</th>\n",
       "      <th>phone_number</th>\n",
       "      <th>fax_number</th>\n",
       "      <th>school_email</th>\n",
       "      <th>grade_span_min</th>\n",
       "      <th>...</th>\n",
       "      <th>is_match</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>returned_address</th>\n",
       "      <th>side</th>\n",
       "      <th>state</th>\n",
       "      <th>state_fips</th>\n",
       "      <th>tiger_line</th>\n",
       "      <th>tract</th>\n",
       "      <th>zipcode</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>01M292</td>\n",
       "      <td>Henry Street School for International Studies</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M056</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-406-9411</td>\n",
       "      <td>212-406-9417</td>\n",
       "      <td>cloughl@schools.nyc.gov</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.713700</td>\n",
       "      <td>-73.986200</td>\n",
       "      <td>220 HENRY ST, NEW YORK, NY, 10002</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59654332.0</td>\n",
       "      <td>201.0</td>\n",
       "      <td>10002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>01M448</td>\n",
       "      <td>University Neighborhood High School</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M446</td>\n",
       "      <td>No</td>\n",
       "      <td>212-962-4341</td>\n",
       "      <td>212-267-5611</td>\n",
       "      <td>ransonunhs@gmail.com</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.712418</td>\n",
       "      <td>-73.984360</td>\n",
       "      <td>200 MONROE ST, NEW YORK, NY, 10002</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59663661.0</td>\n",
       "      <td>202.0</td>\n",
       "      <td>10002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>01M450</td>\n",
       "      <td>East Side Community School</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M060</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-460-8467</td>\n",
       "      <td>212-260-9657</td>\n",
       "      <td>tomm@eschs.org</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.729782</td>\n",
       "      <td>-73.982990</td>\n",
       "      <td>420 E 12TH ST, NEW YORK, NY, 10009</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59654596.0</td>\n",
       "      <td>3400.0</td>\n",
       "      <td>10009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>01M509</td>\n",
       "      <td>Marta Valle High School</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M025</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-473-8152</td>\n",
       "      <td>212-475-7588</td>\n",
       "      <td>jbailey2@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.720505</td>\n",
       "      <td>-73.985390</td>\n",
       "      <td>145 STANTON ST, NEW YORK, NY, 10002</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59654134.0</td>\n",
       "      <td>3001.0</td>\n",
       "      <td>10002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>01M539</td>\n",
       "      <td>New Explorations into Science, Technology and ...</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M022</td>\n",
       "      <td>No</td>\n",
       "      <td>212-677-5190</td>\n",
       "      <td>212-260-8124</td>\n",
       "      <td>Sglasgall@schools.nyc.gov</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.717888</td>\n",
       "      <td>-73.979820</td>\n",
       "      <td>111 COLUMBIA ST, NEW YORK, NY, 10002</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>610201451.0</td>\n",
       "      <td>2201.0</td>\n",
       "      <td>10002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>01M696</td>\n",
       "      <td>Bard High School Early College</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M097</td>\n",
       "      <td>No</td>\n",
       "      <td>212-995-8479</td>\n",
       "      <td>212-777-4702</td>\n",
       "      <td>apply@bhsec.bard.edu</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.718903</td>\n",
       "      <td>-73.975390</td>\n",
       "      <td>525 E HOUSTON ST, NEW YORK, NY, 10002</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59663496.0</td>\n",
       "      <td>1002.0</td>\n",
       "      <td>10002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>02M047</td>\n",
       "      <td>47 The American Sign Language and English Seco...</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M047</td>\n",
       "      <td>Yes</td>\n",
       "      <td>917-326-6668</td>\n",
       "      <td>917-326-6688</td>\n",
       "      <td>wshama@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.738350</td>\n",
       "      <td>-73.981995</td>\n",
       "      <td>223 E 23RD ST, NEW YORK, NY, 10010</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>639436265.0</td>\n",
       "      <td>6400.0</td>\n",
       "      <td>10010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>02M135</td>\n",
       "      <td>The Urban Assembly School for Emergency Manage...</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M520</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-225-0998</td>\n",
       "      <td>212-225-0996</td>\n",
       "      <td>info@uasem.org</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.711080</td>\n",
       "      <td>-74.000626</td>\n",
       "      <td>411 PEARL ST, NEW YORK, NY, 10038</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59660609.0</td>\n",
       "      <td>2900.0</td>\n",
       "      <td>10038</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>02M139</td>\n",
       "      <td>Stephen T. Mather Building Arts &amp; Craftsmanshi...</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M625</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-399-3520</td>\n",
       "      <td>212-245-4669</td>\n",
       "      <td>info@MatherHSNYC.org</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.763350</td>\n",
       "      <td>-73.990555</td>\n",
       "      <td>439 W 49TH ST, NEW YORK, NY, 10019</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59655179.0</td>\n",
       "      <td>12700.0</td>\n",
       "      <td>10019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>02M260</td>\n",
       "      <td>M.S. 260 Clinton School Writers &amp; Artists</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M933</td>\n",
       "      <td>No</td>\n",
       "      <td>212-695-9114</td>\n",
       "      <td>212-695-9611</td>\n",
       "      <td>admissions@theclintonschool.net</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.753044</td>\n",
       "      <td>-73.997540</td>\n",
       "      <td>425 W 33RD ST, NEW YORK, NY, 10001</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>640902204.0</td>\n",
       "      <td>10300.0</td>\n",
       "      <td>10001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>02M280</td>\n",
       "      <td>Manhattan Early College School for Advertising</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M520</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-225-0880</td>\n",
       "      <td>212-225-0882</td>\n",
       "      <td>Info@meca-nyc.org</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.711080</td>\n",
       "      <td>-74.000626</td>\n",
       "      <td>411 PEARL ST, NEW YORK, NY, 10038</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59660609.0</td>\n",
       "      <td>2900.0</td>\n",
       "      <td>10038</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>02M282</td>\n",
       "      <td>Urban Assembly Maker Academy</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M520</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-935-3442</td>\n",
       "      <td>None</td>\n",
       "      <td>info@uamaker.org</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.711080</td>\n",
       "      <td>-74.000626</td>\n",
       "      <td>411 PEARL ST, NEW YORK, NY, 10038</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59660609.0</td>\n",
       "      <td>2900.0</td>\n",
       "      <td>10038</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>02M288</td>\n",
       "      <td>Food and Finance High School</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M535</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-586-2943</td>\n",
       "      <td>212-586-4205</td>\n",
       "      <td>cmercado4@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.765198</td>\n",
       "      <td>-73.993000</td>\n",
       "      <td>525 W 50TH ST, NEW YORK, NY, 10019</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59662114.0</td>\n",
       "      <td>13500.0</td>\n",
       "      <td>10019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>02M294</td>\n",
       "      <td>Essex Street Academy</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M445</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-475-4773</td>\n",
       "      <td>212-674-2058</td>\n",
       "      <td>meghan@essexstreetacademy.org</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.716846</td>\n",
       "      <td>-73.989550</td>\n",
       "      <td>350 GRAND ST, NEW YORK, NY, 10002</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59654284.0</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>10002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>02M296</td>\n",
       "      <td>High School of Hospitality Management</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M535</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-586-0963</td>\n",
       "      <td>212-265-1307</td>\n",
       "      <td>ymompoi@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.765198</td>\n",
       "      <td>-73.993000</td>\n",
       "      <td>525 W 50TH ST, NEW YORK, NY, 10019</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59662114.0</td>\n",
       "      <td>13500.0</td>\n",
       "      <td>10019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>02M298</td>\n",
       "      <td>Pace High School</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M131</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-334-4663</td>\n",
       "      <td>212-334-4919</td>\n",
       "      <td>msowiski@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.716496</td>\n",
       "      <td>-73.992900</td>\n",
       "      <td>100 HESTER ST, NEW YORK, NY, 10002</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59654174.0</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>10002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>02M300</td>\n",
       "      <td>Urban Assembly School of Design and Constructi...</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M535</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-586-0981</td>\n",
       "      <td>212-586-1731</td>\n",
       "      <td>Matt.Willoughby@uasdc.org</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.765198</td>\n",
       "      <td>-73.993000</td>\n",
       "      <td>525 W 50TH ST, NEW YORK, NY, 10019</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59662114.0</td>\n",
       "      <td>13500.0</td>\n",
       "      <td>10019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>02M303</td>\n",
       "      <td>Facing History School, The</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M535</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-757-2680</td>\n",
       "      <td>212-757-2156</td>\n",
       "      <td>dana@facinghistoryschool.org</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.765198</td>\n",
       "      <td>-73.993000</td>\n",
       "      <td>525 W 50TH ST, NEW YORK, NY, 10019</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59662114.0</td>\n",
       "      <td>13500.0</td>\n",
       "      <td>10019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>02M305</td>\n",
       "      <td>Urban Assembly Academy of Government and Law, The</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M445</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-505-0745</td>\n",
       "      <td>212-674-8021</td>\n",
       "      <td>contact@uaagl.org</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.716846</td>\n",
       "      <td>-73.989550</td>\n",
       "      <td>350 GRAND ST, NEW YORK, NY, 10002</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59654284.0</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>10002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>02M308</td>\n",
       "      <td>Lower Manhattan Arts Academy</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M445</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-505-0143</td>\n",
       "      <td>212-674-8021</td>\n",
       "      <td>lcordero@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.716846</td>\n",
       "      <td>-73.989550</td>\n",
       "      <td>350 GRAND ST, NEW YORK, NY, 10002</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59654284.0</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>10002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>02M316</td>\n",
       "      <td>Urban Assembly School of Business for Young Wo...</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M282</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-668-0169</td>\n",
       "      <td>212-668-0635</td>\n",
       "      <td>pminaya@uasbyw.org</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.706240</td>\n",
       "      <td>-74.012940</td>\n",
       "      <td>26 BROADWAY, BOWLING GREEN, NY, 10004</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59659614.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>10004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>02M374</td>\n",
       "      <td>Gramercy Arts High School</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M460</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-253-7076</td>\n",
       "      <td>212-253-8095</td>\n",
       "      <td>sdicicco@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.735523</td>\n",
       "      <td>-73.987640</td>\n",
       "      <td>40 IRVING PL, NEW YORK, NY, 10003</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59653688.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>10003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>02M376</td>\n",
       "      <td>NYC iSchool</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M615</td>\n",
       "      <td>Yes</td>\n",
       "      <td>917-237-7300</td>\n",
       "      <td>212-219-0743</td>\n",
       "      <td>admissions@mail.nycischool.org</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.723670</td>\n",
       "      <td>-74.004776</td>\n",
       "      <td>131 AVE OF THE AMERICAS, CANAL STREET, NY, 10013</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59660122.0</td>\n",
       "      <td>3700.0</td>\n",
       "      <td>10013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>02M392</td>\n",
       "      <td>MANHATTAN BUSINESS ACADEMY</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M440</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-647-1983</td>\n",
       "      <td>212-647-1989</td>\n",
       "      <td>kpolson@manhattanbusinessacademy.org</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.742867</td>\n",
       "      <td>-74.002144</td>\n",
       "      <td>351 W 18TH ST, NEW YORK, NY, 10011</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59659738.0</td>\n",
       "      <td>8900.0</td>\n",
       "      <td>10011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>02M393</td>\n",
       "      <td>BUSINESS OF SPORTS SCHOOL</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M625</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-246-2183</td>\n",
       "      <td>212-246-2913</td>\n",
       "      <td>solomon@nycBOSS.org</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.763350</td>\n",
       "      <td>-73.990555</td>\n",
       "      <td>439 W 49TH ST, NEW YORK, NY, 10019</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59655179.0</td>\n",
       "      <td>12700.0</td>\n",
       "      <td>10019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>02M399</td>\n",
       "      <td>THE HIGH SCHOOL FOR LANGUAGE AND DIPLOMACY</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M460</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-253-2480</td>\n",
       "      <td>212-253-2539</td>\n",
       "      <td>DSchindler@Schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.735523</td>\n",
       "      <td>-73.987640</td>\n",
       "      <td>40 IRVING PL, NEW YORK, NY, 10003</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59653688.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>10003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>02M400</td>\n",
       "      <td>High School for Environmental Studies</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M834</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-262-8113</td>\n",
       "      <td>212-262-0702</td>\n",
       "      <td>GGross@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.767788</td>\n",
       "      <td>-73.987510</td>\n",
       "      <td>444 W 56TH ST, NEW YORK, NY, 10019</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59655126.0</td>\n",
       "      <td>13900.0</td>\n",
       "      <td>10019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>02M407</td>\n",
       "      <td>Institute for Collaborative Education</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M475</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-475-7972</td>\n",
       "      <td>212-475-0459</td>\n",
       "      <td>ICEadmissions@gmail.com</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.732334</td>\n",
       "      <td>-73.982765</td>\n",
       "      <td>345 E 15TH ST, NEW YORK, NY, 10003</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>639434786.0</td>\n",
       "      <td>4800.0</td>\n",
       "      <td>10003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>02M408</td>\n",
       "      <td>Professional Performing Arts High School</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M017</td>\n",
       "      <td>Yes</td>\n",
       "      <td>212-247-8652</td>\n",
       "      <td>212-247-7514</td>\n",
       "      <td>admissions@ppasshare.org</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.761230</td>\n",
       "      <td>-73.987495</td>\n",
       "      <td>328 W 48TH ST, NEW YORK, NY, 10036</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>642471753.0</td>\n",
       "      <td>12700.0</td>\n",
       "      <td>10036</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>02M411</td>\n",
       "      <td>Baruch College Campus High School</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>M874</td>\n",
       "      <td>No</td>\n",
       "      <td>212-683-7440</td>\n",
       "      <td>212-683-7338</td>\n",
       "      <td>bcchs@bcchsnyc.net</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.741783</td>\n",
       "      <td>-73.986170</td>\n",
       "      <td>55 E 25TH ST, NEW YORK, NY, 10010</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59653622.0</td>\n",
       "      <td>5600.0</td>\n",
       "      <td>10010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>407</th>\n",
       "      <td>407</td>\n",
       "      <td>29Q327</td>\n",
       "      <td>Eagle Academy for Young Men III</td>\n",
       "      <td>Queens</td>\n",
       "      <td>Q633</td>\n",
       "      <td>No</td>\n",
       "      <td>718-480-2600</td>\n",
       "      <td>718-480-2610</td>\n",
       "      <td>eagleacademy3@gmail.com</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>No_Match</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>408</th>\n",
       "      <td>408</td>\n",
       "      <td>29Q492</td>\n",
       "      <td>Mathematics, Science Research and Technology M...</td>\n",
       "      <td>Queens</td>\n",
       "      <td>Q490</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-978-1837</td>\n",
       "      <td>718-978-2063</td>\n",
       "      <td>jcruz3@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Tie</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11411</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>409</th>\n",
       "      <td>409</td>\n",
       "      <td>29Q498</td>\n",
       "      <td>Humanities &amp; Arts Magnet High School</td>\n",
       "      <td>Queens</td>\n",
       "      <td>Q490</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-978-2135</td>\n",
       "      <td>718-978-2309</td>\n",
       "      <td>None</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.697660</td>\n",
       "      <td>-73.746340</td>\n",
       "      <td>207-01 116TH AVE, JAMAICA, NY, 11411</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59720396.0</td>\n",
       "      <td>53401.0</td>\n",
       "      <td>11411</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>410</th>\n",
       "      <td>410</td>\n",
       "      <td>30Q258</td>\n",
       "      <td>Energy Tech High School</td>\n",
       "      <td>Queens</td>\n",
       "      <td>Q204</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-472-0536</td>\n",
       "      <td>718-472-0490</td>\n",
       "      <td>energytechhs@gmail.com</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.757088</td>\n",
       "      <td>-73.932650</td>\n",
       "      <td>36-41 28TH ST, LONG IS CITY, NY, 11106</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59696768.0</td>\n",
       "      <td>5100.0</td>\n",
       "      <td>11106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>411</td>\n",
       "      <td>30Q286</td>\n",
       "      <td>Young Women's Leadership School, Astoria</td>\n",
       "      <td>Queens</td>\n",
       "      <td>Q739</td>\n",
       "      <td>No</td>\n",
       "      <td>718-267-2839</td>\n",
       "      <td>718-728-0218</td>\n",
       "      <td>30Q286@schools.nyc.gov</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.771175</td>\n",
       "      <td>-73.924545</td>\n",
       "      <td>23-15 NEWTOWN AVE, LONG IS CITY, NY, 11102</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59696670.0</td>\n",
       "      <td>6900.0</td>\n",
       "      <td>11102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>412</th>\n",
       "      <td>412</td>\n",
       "      <td>30Q301</td>\n",
       "      <td>Academy for Careers in Television and Film</td>\n",
       "      <td>Queens</td>\n",
       "      <td>Q404</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-609-3330</td>\n",
       "      <td>718-609-3339</td>\n",
       "      <td>info@actvf.org</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>No_Match</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>413</td>\n",
       "      <td>30Q445</td>\n",
       "      <td>William Cullen Bryant High School</td>\n",
       "      <td>Queens</td>\n",
       "      <td>Q445</td>\n",
       "      <td>No</td>\n",
       "      <td>718-721-5404</td>\n",
       "      <td>718-728-3478</td>\n",
       "      <td>jnarvaez@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.758255</td>\n",
       "      <td>-73.910550</td>\n",
       "      <td>48-10 31ST AVE, LONG IS CITY, NY, 11103</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59697270.0</td>\n",
       "      <td>16300.0</td>\n",
       "      <td>11103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>414</td>\n",
       "      <td>30Q450</td>\n",
       "      <td>Long Island City High School</td>\n",
       "      <td>Queens</td>\n",
       "      <td>Q452</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-545-7095</td>\n",
       "      <td>718-545-2980</td>\n",
       "      <td>licinfo@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.765930</td>\n",
       "      <td>-73.932976</td>\n",
       "      <td>14-30 BROADWAY, LONG IS CITY, NY, 11106</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>639579330.0</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>11106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>415</td>\n",
       "      <td>30Q501</td>\n",
       "      <td>Frank Sinatra School of the Arts High School</td>\n",
       "      <td>Queens</td>\n",
       "      <td>Q570</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-361-9920</td>\n",
       "      <td>718-361-9995</td>\n",
       "      <td>None</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>No_Match</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>416</th>\n",
       "      <td>416</td>\n",
       "      <td>30Q502</td>\n",
       "      <td>Information Technology High School</td>\n",
       "      <td>Queens</td>\n",
       "      <td>Q725</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-937-4270</td>\n",
       "      <td>718-937-5236</td>\n",
       "      <td>msolomon@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>No_Match</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>417</th>\n",
       "      <td>417</td>\n",
       "      <td>30Q555</td>\n",
       "      <td>Newcomers High School</td>\n",
       "      <td>Queens</td>\n",
       "      <td>Q450</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-937-6005</td>\n",
       "      <td>718-937-6316</td>\n",
       "      <td>30Q555@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>No_Match</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>418</th>\n",
       "      <td>418</td>\n",
       "      <td>30Q575</td>\n",
       "      <td>Academy of American Studies</td>\n",
       "      <td>Queens</td>\n",
       "      <td>Q451</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-361-8786</td>\n",
       "      <td>718-361-8832</td>\n",
       "      <td>academyinfo@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>No_Match</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419</th>\n",
       "      <td>419</td>\n",
       "      <td>30Q580</td>\n",
       "      <td>Baccalaureate School for Global Education</td>\n",
       "      <td>Queens</td>\n",
       "      <td>Q798</td>\n",
       "      <td>No</td>\n",
       "      <td>718-361-5275</td>\n",
       "      <td>718-361-5395</td>\n",
       "      <td>bsgeadmissions@gmail.com</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.755386</td>\n",
       "      <td>-73.927210</td>\n",
       "      <td>34-12 36TH AVE, LONG IS CITY, NY, 11106</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59696798.0</td>\n",
       "      <td>5500.0</td>\n",
       "      <td>11106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>420</th>\n",
       "      <td>420</td>\n",
       "      <td>31R047</td>\n",
       "      <td>CSI High School for International Studies</td>\n",
       "      <td>Staten Island</td>\n",
       "      <td>R043</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-370-6900</td>\n",
       "      <td>718-370-6915</td>\n",
       "      <td>31r047@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.582127</td>\n",
       "      <td>-74.157610</td>\n",
       "      <td>100 ESSEX DR, STATEN ISLAND, NY, 10314</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59890393.0</td>\n",
       "      <td>27702.0</td>\n",
       "      <td>10314</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>421</td>\n",
       "      <td>31R064</td>\n",
       "      <td>Gaynor McCown Expeditionary Learning School</td>\n",
       "      <td>Staten Island</td>\n",
       "      <td>R043</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-370-6950</td>\n",
       "      <td>718-370-6960</td>\n",
       "      <td>tfrey@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.582127</td>\n",
       "      <td>-74.157610</td>\n",
       "      <td>100 ESSEX DR, STATEN ISLAND, NY, 10314</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59890393.0</td>\n",
       "      <td>27702.0</td>\n",
       "      <td>10314</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422</th>\n",
       "      <td>422</td>\n",
       "      <td>31R080</td>\n",
       "      <td>The Michael J. Petrides School</td>\n",
       "      <td>Staten Island</td>\n",
       "      <td>R880</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-815-0186</td>\n",
       "      <td>718-815-9638</td>\n",
       "      <td>ATabbit@schools.nyc.gov</td>\n",
       "      <td>-1</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.607327</td>\n",
       "      <td>-74.101460</td>\n",
       "      <td>715 OCEAN TER, STATEN ISLAND, NY, 10301</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59867138.0</td>\n",
       "      <td>17700.0</td>\n",
       "      <td>10301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>423</th>\n",
       "      <td>423</td>\n",
       "      <td>31R440</td>\n",
       "      <td>New Dorp High School</td>\n",
       "      <td>Staten Island</td>\n",
       "      <td>R435</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-667-8686</td>\n",
       "      <td>718-987-4889</td>\n",
       "      <td>cgannon@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.569725</td>\n",
       "      <td>-74.108250</td>\n",
       "      <td>465 NEW DORP LN, STATEN ISLAND, NY, 10306</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59868878.0</td>\n",
       "      <td>11202.0</td>\n",
       "      <td>10306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>424</th>\n",
       "      <td>424</td>\n",
       "      <td>31R445</td>\n",
       "      <td>Port Richmond High School</td>\n",
       "      <td>Staten Island</td>\n",
       "      <td>R445</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-420-2100</td>\n",
       "      <td>718-981-6203</td>\n",
       "      <td>31R445@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.634613</td>\n",
       "      <td>-74.141800</td>\n",
       "      <td>85 ST JOSEPHS AVE, STATEN ISLAND, NY, 10302</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59877537.0</td>\n",
       "      <td>21300.0</td>\n",
       "      <td>10302</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>425</td>\n",
       "      <td>31R450</td>\n",
       "      <td>Curtis High School</td>\n",
       "      <td>Staten Island</td>\n",
       "      <td>R450</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-390-1800</td>\n",
       "      <td>718-556-4800</td>\n",
       "      <td>76R450@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.644783</td>\n",
       "      <td>-74.080520</td>\n",
       "      <td>105 HAMILTON AVE, STATEN ISLAND, NY, 10301</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59878849.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>10301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426</th>\n",
       "      <td>426</td>\n",
       "      <td>31R455</td>\n",
       "      <td>Tottenville High School</td>\n",
       "      <td>Staten Island</td>\n",
       "      <td>R455</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-668-8800</td>\n",
       "      <td>718-317-0962</td>\n",
       "      <td>31R455@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.528200</td>\n",
       "      <td>-74.192100</td>\n",
       "      <td>100 LUTEN AVE, STATEN ISLAND, NY, 10312</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59883892.0</td>\n",
       "      <td>19800.0</td>\n",
       "      <td>10312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>427</th>\n",
       "      <td>427</td>\n",
       "      <td>31R460</td>\n",
       "      <td>Susan E. Wagner High School</td>\n",
       "      <td>Staten Island</td>\n",
       "      <td>R460</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-698-4200</td>\n",
       "      <td>718-698-5213</td>\n",
       "      <td>drabinowitz@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.599010</td>\n",
       "      <td>-74.122900</td>\n",
       "      <td>1200 MANOR RD, STATEN ISLAND, NY, 10314</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59884583.0</td>\n",
       "      <td>18100.0</td>\n",
       "      <td>10314</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>428</th>\n",
       "      <td>428</td>\n",
       "      <td>31R600</td>\n",
       "      <td>Ralph R. McKee Career and Technical Education ...</td>\n",
       "      <td>Staten Island</td>\n",
       "      <td>R600</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-420-2600</td>\n",
       "      <td>718-981-8776</td>\n",
       "      <td>SHenry2@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>No_Match</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>429</td>\n",
       "      <td>31R605</td>\n",
       "      <td>Staten Island Technical High School</td>\n",
       "      <td>Staten Island</td>\n",
       "      <td>R440</td>\n",
       "      <td>No</td>\n",
       "      <td>718-667-3222</td>\n",
       "      <td>718-987-5872</td>\n",
       "      <td>BMalenfant@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.567883</td>\n",
       "      <td>-74.115360</td>\n",
       "      <td>485 CLAWSON ST, STATEN ISLAND, NY, 10306</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59867884.0</td>\n",
       "      <td>13400.0</td>\n",
       "      <td>10306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>430</th>\n",
       "      <td>430</td>\n",
       "      <td>32K168</td>\n",
       "      <td>The Brooklyn School for Math and Research</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>K480</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-381-7100</td>\n",
       "      <td>718-381-9897</td>\n",
       "      <td>DTorres28@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.697517</td>\n",
       "      <td>-73.911750</td>\n",
       "      <td>400 IRVING AVE, BROOKLYN, NY, 11237</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59083056.0</td>\n",
       "      <td>43500.0</td>\n",
       "      <td>11237</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431</th>\n",
       "      <td>431</td>\n",
       "      <td>32K403</td>\n",
       "      <td>Academy for Environmental Leadership</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>K480</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-381-7100</td>\n",
       "      <td>718-381-0223</td>\n",
       "      <td>DHenry10@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.697517</td>\n",
       "      <td>-73.911750</td>\n",
       "      <td>400 IRVING AVE, BROOKLYN, NY, 11237</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59083056.0</td>\n",
       "      <td>43500.0</td>\n",
       "      <td>11237</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>432</th>\n",
       "      <td>432</td>\n",
       "      <td>32K545</td>\n",
       "      <td>EBC High School for Public Service - Bushwick</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>K913</td>\n",
       "      <td>No</td>\n",
       "      <td>718-452-3440</td>\n",
       "      <td>718-452-3603</td>\n",
       "      <td>32k545@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.694412</td>\n",
       "      <td>-73.929190</td>\n",
       "      <td>1155 DEKALB AVE, BROOKLYN, NY, 11221</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59082595.0</td>\n",
       "      <td>39300.0</td>\n",
       "      <td>11221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433</th>\n",
       "      <td>433</td>\n",
       "      <td>32K549</td>\n",
       "      <td>Bushwick School for Social Justice</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>K480</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-381-7100</td>\n",
       "      <td>718-418-0192</td>\n",
       "      <td>jsierra2@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.697517</td>\n",
       "      <td>-73.911750</td>\n",
       "      <td>400 IRVING AVE, BROOKLYN, NY, 11237</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59083056.0</td>\n",
       "      <td>43500.0</td>\n",
       "      <td>11237</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>434</th>\n",
       "      <td>434</td>\n",
       "      <td>32K552</td>\n",
       "      <td>Academy of Urban Planning</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>K480</td>\n",
       "      <td>Yes</td>\n",
       "      <td>718-381-7100</td>\n",
       "      <td>718-418-0314</td>\n",
       "      <td>knorman3@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.697517</td>\n",
       "      <td>-73.911750</td>\n",
       "      <td>400 IRVING AVE, BROOKLYN, NY, 11237</td>\n",
       "      <td>R</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59083056.0</td>\n",
       "      <td>43500.0</td>\n",
       "      <td>11237</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>435</th>\n",
       "      <td>435</td>\n",
       "      <td>32K554</td>\n",
       "      <td>All City Leadership Secondary School</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>K554</td>\n",
       "      <td>No</td>\n",
       "      <td>718-246-6500</td>\n",
       "      <td>718-246-6509</td>\n",
       "      <td>None</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.697403</td>\n",
       "      <td>-73.913140</td>\n",
       "      <td>321 PALMETTO ST, BROOKLYN, NY, 11237</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59083039.0</td>\n",
       "      <td>43300.0</td>\n",
       "      <td>11237</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>436</th>\n",
       "      <td>436</td>\n",
       "      <td>32K556</td>\n",
       "      <td>Bushwick Leaders High School for Academic Exce...</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>K865</td>\n",
       "      <td>No</td>\n",
       "      <td>718-919-4212</td>\n",
       "      <td>718-574-1103</td>\n",
       "      <td>32k556@schools.nyc.gov</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>Match</td>\n",
       "      <td>40.695150</td>\n",
       "      <td>-73.928314</td>\n",
       "      <td>797 BUSHWICK AVE, BROOKLYN, NY, 11221</td>\n",
       "      <td>L</td>\n",
       "      <td>NY</td>\n",
       "      <td>36.0</td>\n",
       "      <td>59099423.0</td>\n",
       "      <td>39300.0</td>\n",
       "      <td>11221</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>437 rows × 77 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     index     dbn                                        school_name  \\\n",
       "0        0  01M292      Henry Street School for International Studies   \n",
       "1        1  01M448                University Neighborhood High School   \n",
       "2        2  01M450                         East Side Community School   \n",
       "3        3  01M509                            Marta Valle High School   \n",
       "4        4  01M539  New Explorations into Science, Technology and ...   \n",
       "5        5  01M696                     Bard High School Early College   \n",
       "6        6  02M047  47 The American Sign Language and English Seco...   \n",
       "7        7  02M135  The Urban Assembly School for Emergency Manage...   \n",
       "8        8  02M139  Stephen T. Mather Building Arts & Craftsmanshi...   \n",
       "9        9  02M260          M.S. 260 Clinton School Writers & Artists   \n",
       "10      10  02M280     Manhattan Early College School for Advertising   \n",
       "11      11  02M282                       Urban Assembly Maker Academy   \n",
       "12      12  02M288                       Food and Finance High School   \n",
       "13      13  02M294                               Essex Street Academy   \n",
       "14      14  02M296              High School of Hospitality Management   \n",
       "15      15  02M298                                   Pace High School   \n",
       "16      16  02M300  Urban Assembly School of Design and Constructi...   \n",
       "17      17  02M303                         Facing History School, The   \n",
       "18      18  02M305  Urban Assembly Academy of Government and Law, The   \n",
       "19      19  02M308                       Lower Manhattan Arts Academy   \n",
       "20      20  02M316  Urban Assembly School of Business for Young Wo...   \n",
       "21      21  02M374                          Gramercy Arts High School   \n",
       "22      22  02M376                                        NYC iSchool   \n",
       "23      23  02M392                         MANHATTAN BUSINESS ACADEMY   \n",
       "24      24  02M393                          BUSINESS OF SPORTS SCHOOL   \n",
       "25      25  02M399         THE HIGH SCHOOL FOR LANGUAGE AND DIPLOMACY   \n",
       "26      26  02M400              High School for Environmental Studies   \n",
       "27      27  02M407              Institute for Collaborative Education   \n",
       "28      28  02M408           Professional Performing Arts High School   \n",
       "29      29  02M411                  Baruch College Campus High School   \n",
       "..     ...     ...                                                ...   \n",
       "407    407  29Q327                    Eagle Academy for Young Men III   \n",
       "408    408  29Q492  Mathematics, Science Research and Technology M...   \n",
       "409    409  29Q498               Humanities & Arts Magnet High School   \n",
       "410    410  30Q258                            Energy Tech High School   \n",
       "411    411  30Q286           Young Women's Leadership School, Astoria   \n",
       "412    412  30Q301         Academy for Careers in Television and Film   \n",
       "413    413  30Q445                  William Cullen Bryant High School   \n",
       "414    414  30Q450                       Long Island City High School   \n",
       "415    415  30Q501       Frank Sinatra School of the Arts High School   \n",
       "416    416  30Q502                 Information Technology High School   \n",
       "417    417  30Q555                              Newcomers High School   \n",
       "418    418  30Q575                        Academy of American Studies   \n",
       "419    419  30Q580          Baccalaureate School for Global Education   \n",
       "420    420  31R047          CSI High School for International Studies   \n",
       "421    421  31R064        Gaynor McCown Expeditionary Learning School   \n",
       "422    422  31R080                     The Michael J. Petrides School   \n",
       "423    423  31R440                               New Dorp High School   \n",
       "424    424  31R445                          Port Richmond High School   \n",
       "425    425  31R450                                 Curtis High School   \n",
       "426    426  31R455                            Tottenville High School   \n",
       "427    427  31R460                        Susan E. Wagner High School   \n",
       "428    428  31R600  Ralph R. McKee Career and Technical Education ...   \n",
       "429    429  31R605                Staten Island Technical High School   \n",
       "430    430  32K168          The Brooklyn School for Math and Research   \n",
       "431    431  32K403               Academy for Environmental Leadership   \n",
       "432    432  32K545      EBC High School for Public Service - Bushwick   \n",
       "433    433  32K549                 Bushwick School for Social Justice   \n",
       "434    434  32K552                          Academy of Urban Planning   \n",
       "435    435  32K554               All City Leadership Secondary School   \n",
       "436    436  32K556  Bushwick Leaders High School for Academic Exce...   \n",
       "\n",
       "              boro building_code shared_space  phone_number    fax_number  \\\n",
       "0        Manhattan          M056          Yes  212-406-9411  212-406-9417   \n",
       "1        Manhattan          M446           No  212-962-4341  212-267-5611   \n",
       "2        Manhattan          M060          Yes  212-460-8467  212-260-9657   \n",
       "3        Manhattan          M025          Yes  212-473-8152  212-475-7588   \n",
       "4        Manhattan          M022           No  212-677-5190  212-260-8124   \n",
       "5        Manhattan          M097           No  212-995-8479  212-777-4702   \n",
       "6        Manhattan          M047          Yes  917-326-6668  917-326-6688   \n",
       "7        Manhattan          M520          Yes  212-225-0998  212-225-0996   \n",
       "8        Manhattan          M625          Yes  212-399-3520  212-245-4669   \n",
       "9        Manhattan          M933           No  212-695-9114  212-695-9611   \n",
       "10       Manhattan          M520          Yes  212-225-0880  212-225-0882   \n",
       "11       Manhattan          M520          Yes  718-935-3442          None   \n",
       "12       Manhattan          M535          Yes  212-586-2943  212-586-4205   \n",
       "13       Manhattan          M445          Yes  212-475-4773  212-674-2058   \n",
       "14       Manhattan          M535          Yes  212-586-0963  212-265-1307   \n",
       "15       Manhattan          M131          Yes  212-334-4663  212-334-4919   \n",
       "16       Manhattan          M535          Yes  212-586-0981  212-586-1731   \n",
       "17       Manhattan          M535          Yes  212-757-2680  212-757-2156   \n",
       "18       Manhattan          M445          Yes  212-505-0745  212-674-8021   \n",
       "19       Manhattan          M445          Yes  212-505-0143  212-674-8021   \n",
       "20       Manhattan          M282          Yes  212-668-0169  212-668-0635   \n",
       "21       Manhattan          M460          Yes  212-253-7076  212-253-8095   \n",
       "22       Manhattan          M615          Yes  917-237-7300  212-219-0743   \n",
       "23       Manhattan          M440          Yes  212-647-1983  212-647-1989   \n",
       "24       Manhattan          M625          Yes  212-246-2183  212-246-2913   \n",
       "25       Manhattan          M460          Yes  212-253-2480  212-253-2539   \n",
       "26       Manhattan          M834          Yes  212-262-8113  212-262-0702   \n",
       "27       Manhattan          M475          Yes  212-475-7972  212-475-0459   \n",
       "28       Manhattan          M017          Yes  212-247-8652  212-247-7514   \n",
       "29       Manhattan          M874           No  212-683-7440  212-683-7338   \n",
       "..             ...           ...          ...           ...           ...   \n",
       "407         Queens          Q633           No  718-480-2600  718-480-2610   \n",
       "408         Queens          Q490          Yes  718-978-1837  718-978-2063   \n",
       "409         Queens          Q490          Yes  718-978-2135  718-978-2309   \n",
       "410         Queens          Q204          Yes  718-472-0536  718-472-0490   \n",
       "411         Queens          Q739           No  718-267-2839  718-728-0218   \n",
       "412         Queens          Q404          Yes  718-609-3330  718-609-3339   \n",
       "413         Queens          Q445           No  718-721-5404  718-728-3478   \n",
       "414         Queens          Q452          Yes  718-545-7095  718-545-2980   \n",
       "415         Queens          Q570          Yes  718-361-9920  718-361-9995   \n",
       "416         Queens          Q725          Yes  718-937-4270  718-937-5236   \n",
       "417         Queens          Q450          Yes  718-937-6005  718-937-6316   \n",
       "418         Queens          Q451          Yes  718-361-8786  718-361-8832   \n",
       "419         Queens          Q798           No  718-361-5275  718-361-5395   \n",
       "420  Staten Island          R043          Yes  718-370-6900  718-370-6915   \n",
       "421  Staten Island          R043          Yes  718-370-6950  718-370-6960   \n",
       "422  Staten Island          R880          Yes  718-815-0186  718-815-9638   \n",
       "423  Staten Island          R435          Yes  718-667-8686  718-987-4889   \n",
       "424  Staten Island          R445          Yes  718-420-2100  718-981-6203   \n",
       "425  Staten Island          R450          Yes  718-390-1800  718-556-4800   \n",
       "426  Staten Island          R455          Yes  718-668-8800  718-317-0962   \n",
       "427  Staten Island          R460          Yes  718-698-4200  718-698-5213   \n",
       "428  Staten Island          R600          Yes  718-420-2600  718-981-8776   \n",
       "429  Staten Island          R440           No  718-667-3222  718-987-5872   \n",
       "430       Brooklyn          K480          Yes  718-381-7100  718-381-9897   \n",
       "431       Brooklyn          K480          Yes  718-381-7100  718-381-0223   \n",
       "432       Brooklyn          K913           No  718-452-3440  718-452-3603   \n",
       "433       Brooklyn          K480          Yes  718-381-7100  718-418-0192   \n",
       "434       Brooklyn          K480          Yes  718-381-7100  718-418-0314   \n",
       "435       Brooklyn          K554           No  718-246-6500  718-246-6509   \n",
       "436       Brooklyn          K865           No  718-919-4212  718-574-1103   \n",
       "\n",
       "                             school_email  grade_span_min   ...     is_match  \\\n",
       "0                 cloughl@schools.nyc.gov               6   ...        Match   \n",
       "1                    ransonunhs@gmail.com               9   ...        Match   \n",
       "2                          tomm@eschs.org               6   ...        Match   \n",
       "3                jbailey2@schools.nyc.gov               9   ...        Match   \n",
       "4               Sglasgall@schools.nyc.gov               0   ...        Match   \n",
       "5                    apply@bhsec.bard.edu               9   ...        Match   \n",
       "6                  wshama@schools.nyc.gov               9   ...        Match   \n",
       "7                          info@uasem.org               9   ...        Match   \n",
       "8                    info@MatherHSNYC.org               9   ...        Match   \n",
       "9         admissions@theclintonschool.net               6   ...        Match   \n",
       "10                      Info@meca-nyc.org               9   ...        Match   \n",
       "11                       info@uamaker.org               9   ...        Match   \n",
       "12              cmercado4@schools.nyc.gov               9   ...        Match   \n",
       "13          meghan@essexstreetacademy.org               9   ...        Match   \n",
       "14                ymompoi@schools.nyc.gov               9   ...        Match   \n",
       "15               msowiski@schools.nyc.gov               9   ...        Match   \n",
       "16              Matt.Willoughby@uasdc.org               9   ...        Match   \n",
       "17           dana@facinghistoryschool.org               9   ...        Match   \n",
       "18                      contact@uaagl.org               9   ...        Match   \n",
       "19               lcordero@schools.nyc.gov               9   ...        Match   \n",
       "20                     pminaya@uasbyw.org               9   ...        Match   \n",
       "21               sdicicco@schools.nyc.gov               9   ...        Match   \n",
       "22         admissions@mail.nycischool.org               9   ...        Match   \n",
       "23   kpolson@manhattanbusinessacademy.org               9   ...        Match   \n",
       "24                    solomon@nycBOSS.org               9   ...        Match   \n",
       "25             DSchindler@Schools.nyc.gov               9   ...        Match   \n",
       "26                 GGross@schools.nyc.gov               9   ...        Match   \n",
       "27                ICEadmissions@gmail.com               6   ...        Match   \n",
       "28               admissions@ppasshare.org               6   ...        Match   \n",
       "29                     bcchs@bcchsnyc.net               9   ...        Match   \n",
       "..                                    ...             ...   ...          ...   \n",
       "407               eagleacademy3@gmail.com               6   ...     No_Match   \n",
       "408                jcruz3@schools.nyc.gov               9   ...          Tie   \n",
       "409                                  None               9   ...        Match   \n",
       "410                energytechhs@gmail.com               9   ...        Match   \n",
       "411                30Q286@schools.nyc.gov               6   ...        Match   \n",
       "412                        info@actvf.org               9   ...     No_Match   \n",
       "413              jnarvaez@schools.nyc.gov               9   ...        Match   \n",
       "414               licinfo@schools.nyc.gov               9   ...        Match   \n",
       "415                                  None               9   ...     No_Match   \n",
       "416              msolomon@schools.nyc.gov               9   ...     No_Match   \n",
       "417                30Q555@schools.nyc.gov               9   ...     No_Match   \n",
       "418           academyinfo@schools.nyc.gov               9   ...     No_Match   \n",
       "419              bsgeadmissions@gmail.com               7   ...        Match   \n",
       "420                31r047@schools.nyc.gov               9   ...        Match   \n",
       "421                 tfrey@schools.nyc.gov               9   ...        Match   \n",
       "422               ATabbit@schools.nyc.gov              -1   ...        Match   \n",
       "423               cgannon@schools.nyc.gov               9   ...        Match   \n",
       "424                31R445@schools.nyc.gov               9   ...        Match   \n",
       "425                76R450@schools.nyc.gov               9   ...        Match   \n",
       "426                31R455@schools.nyc.gov               9   ...        Match   \n",
       "427           drabinowitz@schools.nyc.gov               9   ...        Match   \n",
       "428               SHenry2@schools.nyc.gov               9   ...     No_Match   \n",
       "429            BMalenfant@schools.nyc.gov               9   ...        Match   \n",
       "430             DTorres28@schools.nyc.gov               9   ...        Match   \n",
       "431              DHenry10@schools.nyc.gov               9   ...        Match   \n",
       "432                32k545@schools.nyc.gov               9   ...        Match   \n",
       "433              jsierra2@schools.nyc.gov               9   ...        Match   \n",
       "434              knorman3@schools.nyc.gov               9   ...        Match   \n",
       "435                                  None               6   ...        Match   \n",
       "436                32k556@schools.nyc.gov               9   ...        Match   \n",
       "\n",
       "      latitude  longitude                                  returned_address  \\\n",
       "0    40.713700 -73.986200                 220 HENRY ST, NEW YORK, NY, 10002   \n",
       "1    40.712418 -73.984360                200 MONROE ST, NEW YORK, NY, 10002   \n",
       "2    40.729782 -73.982990                420 E 12TH ST, NEW YORK, NY, 10009   \n",
       "3    40.720505 -73.985390               145 STANTON ST, NEW YORK, NY, 10002   \n",
       "4    40.717888 -73.979820              111 COLUMBIA ST, NEW YORK, NY, 10002   \n",
       "5    40.718903 -73.975390             525 E HOUSTON ST, NEW YORK, NY, 10002   \n",
       "6    40.738350 -73.981995                223 E 23RD ST, NEW YORK, NY, 10010   \n",
       "7    40.711080 -74.000626                 411 PEARL ST, NEW YORK, NY, 10038   \n",
       "8    40.763350 -73.990555                439 W 49TH ST, NEW YORK, NY, 10019   \n",
       "9    40.753044 -73.997540                425 W 33RD ST, NEW YORK, NY, 10001   \n",
       "10   40.711080 -74.000626                 411 PEARL ST, NEW YORK, NY, 10038   \n",
       "11   40.711080 -74.000626                 411 PEARL ST, NEW YORK, NY, 10038   \n",
       "12   40.765198 -73.993000                525 W 50TH ST, NEW YORK, NY, 10019   \n",
       "13   40.716846 -73.989550                 350 GRAND ST, NEW YORK, NY, 10002   \n",
       "14   40.765198 -73.993000                525 W 50TH ST, NEW YORK, NY, 10019   \n",
       "15   40.716496 -73.992900                100 HESTER ST, NEW YORK, NY, 10002   \n",
       "16   40.765198 -73.993000                525 W 50TH ST, NEW YORK, NY, 10019   \n",
       "17   40.765198 -73.993000                525 W 50TH ST, NEW YORK, NY, 10019   \n",
       "18   40.716846 -73.989550                 350 GRAND ST, NEW YORK, NY, 10002   \n",
       "19   40.716846 -73.989550                 350 GRAND ST, NEW YORK, NY, 10002   \n",
       "20   40.706240 -74.012940             26 BROADWAY, BOWLING GREEN, NY, 10004   \n",
       "21   40.735523 -73.987640                 40 IRVING PL, NEW YORK, NY, 10003   \n",
       "22   40.723670 -74.004776  131 AVE OF THE AMERICAS, CANAL STREET, NY, 10013   \n",
       "23   40.742867 -74.002144                351 W 18TH ST, NEW YORK, NY, 10011   \n",
       "24   40.763350 -73.990555                439 W 49TH ST, NEW YORK, NY, 10019   \n",
       "25   40.735523 -73.987640                 40 IRVING PL, NEW YORK, NY, 10003   \n",
       "26   40.767788 -73.987510                444 W 56TH ST, NEW YORK, NY, 10019   \n",
       "27   40.732334 -73.982765                345 E 15TH ST, NEW YORK, NY, 10003   \n",
       "28   40.761230 -73.987495                328 W 48TH ST, NEW YORK, NY, 10036   \n",
       "29   40.741783 -73.986170                 55 E 25TH ST, NEW YORK, NY, 10010   \n",
       "..         ...        ...                                               ...   \n",
       "407        NaN        NaN                                              None   \n",
       "408        NaN        NaN                                              None   \n",
       "409  40.697660 -73.746340              207-01 116TH AVE, JAMAICA, NY, 11411   \n",
       "410  40.757088 -73.932650            36-41 28TH ST, LONG IS CITY, NY, 11106   \n",
       "411  40.771175 -73.924545        23-15 NEWTOWN AVE, LONG IS CITY, NY, 11102   \n",
       "412        NaN        NaN                                              None   \n",
       "413  40.758255 -73.910550           48-10 31ST AVE, LONG IS CITY, NY, 11103   \n",
       "414  40.765930 -73.932976           14-30 BROADWAY, LONG IS CITY, NY, 11106   \n",
       "415        NaN        NaN                                              None   \n",
       "416        NaN        NaN                                              None   \n",
       "417        NaN        NaN                                              None   \n",
       "418        NaN        NaN                                              None   \n",
       "419  40.755386 -73.927210           34-12 36TH AVE, LONG IS CITY, NY, 11106   \n",
       "420  40.582127 -74.157610            100 ESSEX DR, STATEN ISLAND, NY, 10314   \n",
       "421  40.582127 -74.157610            100 ESSEX DR, STATEN ISLAND, NY, 10314   \n",
       "422  40.607327 -74.101460           715 OCEAN TER, STATEN ISLAND, NY, 10301   \n",
       "423  40.569725 -74.108250         465 NEW DORP LN, STATEN ISLAND, NY, 10306   \n",
       "424  40.634613 -74.141800       85 ST JOSEPHS AVE, STATEN ISLAND, NY, 10302   \n",
       "425  40.644783 -74.080520        105 HAMILTON AVE, STATEN ISLAND, NY, 10301   \n",
       "426  40.528200 -74.192100           100 LUTEN AVE, STATEN ISLAND, NY, 10312   \n",
       "427  40.599010 -74.122900           1200 MANOR RD, STATEN ISLAND, NY, 10314   \n",
       "428        NaN        NaN                                              None   \n",
       "429  40.567883 -74.115360          485 CLAWSON ST, STATEN ISLAND, NY, 10306   \n",
       "430  40.697517 -73.911750               400 IRVING AVE, BROOKLYN, NY, 11237   \n",
       "431  40.697517 -73.911750               400 IRVING AVE, BROOKLYN, NY, 11237   \n",
       "432  40.694412 -73.929190              1155 DEKALB AVE, BROOKLYN, NY, 11221   \n",
       "433  40.697517 -73.911750               400 IRVING AVE, BROOKLYN, NY, 11237   \n",
       "434  40.697517 -73.911750               400 IRVING AVE, BROOKLYN, NY, 11237   \n",
       "435  40.697403 -73.913140              321 PALMETTO ST, BROOKLYN, NY, 11237   \n",
       "436  40.695150 -73.928314             797 BUSHWICK AVE, BROOKLYN, NY, 11221   \n",
       "\n",
       "     side state state_fips   tiger_line    tract  zipcode  \n",
       "0       R    NY       36.0   59654332.0    201.0    10002  \n",
       "1       R    NY       36.0   59663661.0    202.0    10002  \n",
       "2       R    NY       36.0   59654596.0   3400.0    10009  \n",
       "3       R    NY       36.0   59654134.0   3001.0    10002  \n",
       "4       L    NY       36.0  610201451.0   2201.0    10002  \n",
       "5       R    NY       36.0   59663496.0   1002.0    10002  \n",
       "6       L    NY       36.0  639436265.0   6400.0    10010  \n",
       "7       L    NY       36.0   59660609.0   2900.0    10038  \n",
       "8       R    NY       36.0   59655179.0  12700.0    10019  \n",
       "9       R    NY       36.0  640902204.0  10300.0    10001  \n",
       "10      L    NY       36.0   59660609.0   2900.0    10038  \n",
       "11      L    NY       36.0   59660609.0   2900.0    10038  \n",
       "12      R    NY       36.0   59662114.0  13500.0    10019  \n",
       "13      L    NY       36.0   59654284.0   1800.0    10002  \n",
       "14      R    NY       36.0   59662114.0  13500.0    10019  \n",
       "15      L    NY       36.0   59654174.0   1600.0    10002  \n",
       "16      R    NY       36.0   59662114.0  13500.0    10019  \n",
       "17      R    NY       36.0   59662114.0  13500.0    10019  \n",
       "18      L    NY       36.0   59654284.0   1800.0    10002  \n",
       "19      L    NY       36.0   59654284.0   1800.0    10002  \n",
       "20      R    NY       36.0   59659614.0    900.0    10004  \n",
       "21      R    NY       36.0   59653688.0   5000.0    10003  \n",
       "22      L    NY       36.0   59660122.0   3700.0    10013  \n",
       "23      R    NY       36.0   59659738.0   8900.0    10011  \n",
       "24      R    NY       36.0   59655179.0  12700.0    10019  \n",
       "25      R    NY       36.0   59653688.0   5000.0    10003  \n",
       "26      L    NY       36.0   59655126.0  13900.0    10019  \n",
       "27      L    NY       36.0  639434786.0   4800.0    10003  \n",
       "28      L    NY       36.0  642471753.0  12700.0    10036  \n",
       "29      L    NY       36.0   59653622.0   5600.0    10010  \n",
       "..    ...   ...        ...          ...      ...      ...  \n",
       "407  None    NY        NaN          NaN      NaN    11434  \n",
       "408  None    NY        NaN          NaN      NaN    11411  \n",
       "409     L    NY       36.0   59720396.0  53401.0    11411  \n",
       "410     L    NY       36.0   59696768.0   5100.0    11106  \n",
       "411     L    NY       36.0   59696670.0   6900.0    11102  \n",
       "412  None    NY        NaN          NaN      NaN    11101  \n",
       "413     R    NY       36.0   59697270.0  16300.0    11103  \n",
       "414     R    NY       36.0  639579330.0   4500.0    11106  \n",
       "415  None    NY        NaN          NaN      NaN    11106  \n",
       "416  None    NY        NaN          NaN      NaN    11101  \n",
       "417  None    NY        NaN          NaN      NaN    11101  \n",
       "418  None    NY        NaN          NaN      NaN    11101  \n",
       "419     R    NY       36.0   59696798.0   5500.0    11106  \n",
       "420     L    NY       36.0   59890393.0  27702.0    10314  \n",
       "421     L    NY       36.0   59890393.0  27702.0    10314  \n",
       "422     L    NY       36.0   59867138.0  17700.0    10301  \n",
       "423     L    NY       36.0   59868878.0  11202.0    10306  \n",
       "424     R    NY       36.0   59877537.0  21300.0    10302  \n",
       "425     R    NY       36.0   59878849.0    700.0    10301  \n",
       "426     L    NY       36.0   59883892.0  19800.0    10312  \n",
       "427     R    NY       36.0   59884583.0  18100.0    10314  \n",
       "428  None    NY        NaN          NaN      NaN    10301  \n",
       "429     R    NY       36.0   59867884.0  13400.0    10306  \n",
       "430     R    NY       36.0   59083056.0  43500.0    11237  \n",
       "431     R    NY       36.0   59083056.0  43500.0    11237  \n",
       "432     L    NY       36.0   59082595.0  39300.0    11221  \n",
       "433     R    NY       36.0   59083056.0  43500.0    11237  \n",
       "434     R    NY       36.0   59083056.0  43500.0    11237  \n",
       "435     L    NY       36.0   59083039.0  43300.0    11237  \n",
       "436     L    NY       36.0   59099423.0  39300.0    11221  \n",
       "\n",
       "[437 rows x 77 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_sql('SELECT * FROM schools' , conn) #If you have large dataset put it into SQL database and then pull parts of it out at a time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}