notebooks/Getting Started with DataJoint.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Getting Started with DataJoint"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import datajoint as dj"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Creating your first schema"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Connecting dbadmin@dimitri-proj0.cda95qzjbnvs.us-east-1.rds.amazonaws.com:3306\n",
      "Proceed to delete entire schema `university`? [yes, No]: yes\n"
     ]
    }
   ],
   "source": [
    "schema = dj.schema('university')\n",
    "schema.drop()\n",
    "schema = dj.schema('university')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Creating your first table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "@schema\n",
    "class Student(dj.Manual):\n",
    "    definition = \"\"\"\n",
    "    student_id : int unsigned   # university-wide ID number\n",
    "    ---\n",
    "    first_name      : varchar(40)\n",
    "    last_name       : varchar(40)\n",
    "    sex             : enum('F', 'M', 'U')\n",
    "    \"\"\""
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Inserting an entry as a dictionary"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "Student.insert1({\n",
    "    'student_id': 1, \n",
    "    'first_name': 'Alice', \n",
    "    'last_name': 'Anderson', \n",
    "    'sex': 'F'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "    \n",
       "    <style type=\"text/css\">\n",
       "        .Relation{\n",
       "            border-collapse:collapse;\n",
       "        }\n",
       "        .Relation th{\n",
       "            background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "            font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "        }\n",
       "        .Relation td{\n",
       "            padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "        }\n",
       "        .Relation tr:nth-child(odd){\n",
       "            background: #ffffff;\n",
       "        }\n",
       "        .Relation tr:nth-child(even){\n",
       "            background: #f3f1ff;\n",
       "        }\n",
       "        /* Tooltip container */\n",
       "        .djtooltip {\n",
       "        }\n",
       "        /* Tooltip text */\n",
       "        .djtooltip .djtooltiptext {\n",
       "            visibility: hidden;\n",
       "            width: 120px;\n",
       "            background-color: black;\n",
       "            color: #fff;\n",
       "            text-align: center;\n",
       "            padding: 5px 0;\n",
       "            border-radius: 6px;\n",
       "            /* Position the tooltip text - see examples below! */\n",
       "            position: absolute;\n",
       "            z-index: 1;\n",
       "        }\n",
       "        #primary {\n",
       "            font-weight: bold;\n",
       "            color: black;\n",
       "        }\n",
       "        #nonprimary {\n",
       "            font-weight: normal;\n",
       "            color: white;\n",
       "        }\n",
       "\n",
       "        /* Show the tooltip text when you mouse over the tooltip container */\n",
       "        .djtooltip:hover .djtooltiptext {\n",
       "            visibility: visible;\n",
       "        }\n",
       "    </style>\n",
       "    \n",
       "    <b></b>\n",
       "        <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "        <table border=\"1\" class=\"Relation\">\n",
       "            <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                            <p id=\"primary\">student_id</p>\n",
       "                            <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">first_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">last_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">sex</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div> </th> </tr> </thead>\n",
       "            <tbody> <tr> <td>1</td>\n",
       "<td>Alice</td>\n",
       "<td>Anderson</td>\n",
       "<td>F</td> </tr> </tbody>\n",
       "        </table>\n",
       "        \n",
       "        <p>Total: 1</p></div>\n",
       "        "
      ],
      "text/plain": [
       "*student_id    first_name     last_name     sex    \n",
       "+------------+ +------------+ +-----------+ +-----+\n",
       "1              Alice          Anderson      F      \n",
       " (Total: 1)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Student()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Inserting an entry as a tuple"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "Student.insert1((2, 'Bob', 'Dylan', 'M'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "    \n",
       "    <style type=\"text/css\">\n",
       "        .Relation{\n",
       "            border-collapse:collapse;\n",
       "        }\n",
       "        .Relation th{\n",
       "            background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "            font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "        }\n",
       "        .Relation td{\n",
       "            padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "        }\n",
       "        .Relation tr:nth-child(odd){\n",
       "            background: #ffffff;\n",
       "        }\n",
       "        .Relation tr:nth-child(even){\n",
       "            background: #f3f1ff;\n",
       "        }\n",
       "        /* Tooltip container */\n",
       "        .djtooltip {\n",
       "        }\n",
       "        /* Tooltip text */\n",
       "        .djtooltip .djtooltiptext {\n",
       "            visibility: hidden;\n",
       "            width: 120px;\n",
       "            background-color: black;\n",
       "            color: #fff;\n",
       "            text-align: center;\n",
       "            padding: 5px 0;\n",
       "            border-radius: 6px;\n",
       "            /* Position the tooltip text - see examples below! */\n",
       "            position: absolute;\n",
       "            z-index: 1;\n",
       "        }\n",
       "        #primary {\n",
       "            font-weight: bold;\n",
       "            color: black;\n",
       "        }\n",
       "        #nonprimary {\n",
       "            font-weight: normal;\n",
       "            color: white;\n",
       "        }\n",
       "\n",
       "        /* Show the tooltip text when you mouse over the tooltip container */\n",
       "        .djtooltip:hover .djtooltiptext {\n",
       "            visibility: visible;\n",
       "        }\n",
       "    </style>\n",
       "    \n",
       "    <b></b>\n",
       "        <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "        <table border=\"1\" class=\"Relation\">\n",
       "            <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                            <p id=\"primary\">student_id</p>\n",
       "                            <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">first_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">last_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">sex</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div> </th> </tr> </thead>\n",
       "            <tbody> <tr> <td>1</td>\n",
       "<td>Alice</td>\n",
       "<td>Anderson</td>\n",
       "<td>F</td></tr><tr><td>2</td>\n",
       "<td>Bob</td>\n",
       "<td>Dylan</td>\n",
       "<td>M</td> </tr> </tbody>\n",
       "        </table>\n",
       "        \n",
       "        <p>Total: 2</p></div>\n",
       "        "
      ],
      "text/plain": [
       "*student_id    first_name     last_name     sex    \n",
       "+------------+ +------------+ +-----------+ +-----+\n",
       "1              Alice          Anderson      F      \n",
       "2              Bob            Dylan         M      \n",
       " (Total: 2)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Student()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "Student.insert1((3, 'Carol', 'Lewis', 'F'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "    \n",
       "    <style type=\"text/css\">\n",
       "        .Relation{\n",
       "            border-collapse:collapse;\n",
       "        }\n",
       "        .Relation th{\n",
       "            background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "            font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "        }\n",
       "        .Relation td{\n",
       "            padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "        }\n",
       "        .Relation tr:nth-child(odd){\n",
       "            background: #ffffff;\n",
       "        }\n",
       "        .Relation tr:nth-child(even){\n",
       "            background: #f3f1ff;\n",
       "        }\n",
       "        /* Tooltip container */\n",
       "        .djtooltip {\n",
       "        }\n",
       "        /* Tooltip text */\n",
       "        .djtooltip .djtooltiptext {\n",
       "            visibility: hidden;\n",
       "            width: 120px;\n",
       "            background-color: black;\n",
       "            color: #fff;\n",
       "            text-align: center;\n",
       "            padding: 5px 0;\n",
       "            border-radius: 6px;\n",
       "            /* Position the tooltip text - see examples below! */\n",
       "            position: absolute;\n",
       "            z-index: 1;\n",
       "        }\n",
       "        #primary {\n",
       "            font-weight: bold;\n",
       "            color: black;\n",
       "        }\n",
       "        #nonprimary {\n",
       "            font-weight: normal;\n",
       "            color: white;\n",
       "        }\n",
       "\n",
       "        /* Show the tooltip text when you mouse over the tooltip container */\n",
       "        .djtooltip:hover .djtooltiptext {\n",
       "            visibility: visible;\n",
       "        }\n",
       "    </style>\n",
       "    \n",
       "    <b></b>\n",
       "        <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "        <table border=\"1\" class=\"Relation\">\n",
       "            <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                            <p id=\"primary\">student_id</p>\n",
       "                            <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">first_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">last_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">sex</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div> </th> </tr> </thead>\n",
       "            <tbody> <tr> <td>1</td>\n",
       "<td>Alice</td>\n",
       "<td>Anderson</td>\n",
       "<td>F</td></tr><tr><td>2</td>\n",
       "<td>Bob</td>\n",
       "<td>Dylan</td>\n",
       "<td>M</td></tr><tr><td>3</td>\n",
       "<td>Carol</td>\n",
       "<td>Lewis</td>\n",
       "<td>F</td> </tr> </tbody>\n",
       "        </table>\n",
       "        \n",
       "        <p>Total: 3</p></div>\n",
       "        "
      ],
      "text/plain": [
       "*student_id    first_name     last_name     sex    \n",
       "+------------+ +------------+ +-----------+ +-----+\n",
       "1              Alice          Anderson      F      \n",
       "2              Bob            Dylan         M      \n",
       "3              Carol          Lewis         F      \n",
       " (Total: 3)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Student()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Inserting multiple entries as a list of dictionaries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "students = [\n",
    "    {'student_id': 4, 'first_name': 'Chris', 'last_name': 'Smith', 'sex': 'M'},\n",
    "    {'student_id': 5, 'first_name': 'Stella', 'last_name': 'Taylor', 'sex': 'F'},\n",
    "    {'student_id': 6, 'first_name': 'Max', 'last_name': 'Scott', 'sex': 'M'}\n",
    "]\n",
    "Student.insert(students)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "    \n",
       "    <style type=\"text/css\">\n",
       "        .Relation{\n",
       "            border-collapse:collapse;\n",
       "        }\n",
       "        .Relation th{\n",
       "            background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "            font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "        }\n",
       "        .Relation td{\n",
       "            padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "        }\n",
       "        .Relation tr:nth-child(odd){\n",
       "            background: #ffffff;\n",
       "        }\n",
       "        .Relation tr:nth-child(even){\n",
       "            background: #f3f1ff;\n",
       "        }\n",
       "        /* Tooltip container */\n",
       "        .djtooltip {\n",
       "        }\n",
       "        /* Tooltip text */\n",
       "        .djtooltip .djtooltiptext {\n",
       "            visibility: hidden;\n",
       "            width: 120px;\n",
       "            background-color: black;\n",
       "            color: #fff;\n",
       "            text-align: center;\n",
       "            padding: 5px 0;\n",
       "            border-radius: 6px;\n",
       "            /* Position the tooltip text - see examples below! */\n",
       "            position: absolute;\n",
       "            z-index: 1;\n",
       "        }\n",
       "        #primary {\n",
       "            font-weight: bold;\n",
       "            color: black;\n",
       "        }\n",
       "        #nonprimary {\n",
       "            font-weight: normal;\n",
       "            color: white;\n",
       "        }\n",
       "\n",
       "        /* Show the tooltip text when you mouse over the tooltip container */\n",
       "        .djtooltip:hover .djtooltiptext {\n",
       "            visibility: visible;\n",
       "        }\n",
       "    </style>\n",
       "    \n",
       "    <b></b>\n",
       "        <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "        <table border=\"1\" class=\"Relation\">\n",
       "            <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                            <p id=\"primary\">student_id</p>\n",
       "                            <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">first_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">last_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">sex</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div> </th> </tr> </thead>\n",
       "            <tbody> <tr> <td>1</td>\n",
       "<td>Alice</td>\n",
       "<td>Anderson</td>\n",
       "<td>F</td></tr><tr><td>2</td>\n",
       "<td>Bob</td>\n",
       "<td>Dylan</td>\n",
       "<td>M</td></tr><tr><td>3</td>\n",
       "<td>Carol</td>\n",
       "<td>Lewis</td>\n",
       "<td>F</td></tr><tr><td>4</td>\n",
       "<td>Chris</td>\n",
       "<td>Smith</td>\n",
       "<td>M</td></tr><tr><td>5</td>\n",
       "<td>Stella</td>\n",
       "<td>Taylor</td>\n",
       "<td>F</td></tr><tr><td>6</td>\n",
       "<td>Max</td>\n",
       "<td>Scott</td>\n",
       "<td>M</td> </tr> </tbody>\n",
       "        </table>\n",
       "        \n",
       "        <p>Total: 6</p></div>\n",
       "        "
      ],
      "text/plain": [
       "*student_id    first_name     last_name     sex    \n",
       "+------------+ +------------+ +-----------+ +-----+\n",
       "1              Alice          Anderson      F      \n",
       "2              Bob            Dylan         M      \n",
       "3              Carol          Lewis         F      \n",
       "4              Chris          Smith         M      \n",
       "5              Stella         Taylor        F      \n",
       "6              Max            Scott         M      \n",
       " (Total: 6)"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Student()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Inserting multiple entries as a list of tuples"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "students = [\n",
    "    (7, 'John', 'Allen', 'M'),\n",
    "    (8, 'Julia', 'White', 'F'),\n",
    "    (9, 'Emma', 'Reed', 'F')\n",
    "]\n",
    "Student.insert(students)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "    \n",
       "    <style type=\"text/css\">\n",
       "        .Relation{\n",
       "            border-collapse:collapse;\n",
       "        }\n",
       "        .Relation th{\n",
       "            background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "            font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "        }\n",
       "        .Relation td{\n",
       "            padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "        }\n",
       "        .Relation tr:nth-child(odd){\n",
       "            background: #ffffff;\n",
       "        }\n",
       "        .Relation tr:nth-child(even){\n",
       "            background: #f3f1ff;\n",
       "        }\n",
       "        /* Tooltip container */\n",
       "        .djtooltip {\n",
       "        }\n",
       "        /* Tooltip text */\n",
       "        .djtooltip .djtooltiptext {\n",
       "            visibility: hidden;\n",
       "            width: 120px;\n",
       "            background-color: black;\n",
       "            color: #fff;\n",
       "            text-align: center;\n",
       "            padding: 5px 0;\n",
       "            border-radius: 6px;\n",
       "            /* Position the tooltip text - see examples below! */\n",
       "            position: absolute;\n",
       "            z-index: 1;\n",
       "        }\n",
       "        #primary {\n",
       "            font-weight: bold;\n",
       "            color: black;\n",
       "        }\n",
       "        #nonprimary {\n",
       "            font-weight: normal;\n",
       "            color: white;\n",
       "        }\n",
       "\n",
       "        /* Show the tooltip text when you mouse over the tooltip container */\n",
       "        .djtooltip:hover .djtooltiptext {\n",
       "            visibility: visible;\n",
       "        }\n",
       "    </style>\n",
       "    \n",
       "    <b></b>\n",
       "        <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "        <table border=\"1\" class=\"Relation\">\n",
       "            <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                            <p id=\"primary\">student_id</p>\n",
       "                            <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">first_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">last_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">sex</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div> </th> </tr> </thead>\n",
       "            <tbody> <tr> <td>1</td>\n",
       "<td>Alice</td>\n",
       "<td>Anderson</td>\n",
       "<td>F</td></tr><tr><td>2</td>\n",
       "<td>Bob</td>\n",
       "<td>Dylan</td>\n",
       "<td>M</td></tr><tr><td>3</td>\n",
       "<td>Carol</td>\n",
       "<td>Lewis</td>\n",
       "<td>F</td></tr><tr><td>4</td>\n",
       "<td>Chris</td>\n",
       "<td>Smith</td>\n",
       "<td>M</td></tr><tr><td>5</td>\n",
       "<td>Stella</td>\n",
       "<td>Taylor</td>\n",
       "<td>F</td></tr><tr><td>6</td>\n",
       "<td>Max</td>\n",
       "<td>Scott</td>\n",
       "<td>M</td></tr><tr><td>7</td>\n",
       "<td>John</td>\n",
       "<td>Allen</td>\n",
       "<td>M</td></tr><tr><td>8</td>\n",
       "<td>Julia</td>\n",
       "<td>White</td>\n",
       "<td>F</td></tr><tr><td>9</td>\n",
       "<td>Emma</td>\n",
       "<td>Reed</td>\n",
       "<td>F</td> </tr> </tbody>\n",
       "        </table>\n",
       "        \n",
       "        <p>Total: 9</p></div>\n",
       "        "
      ],
      "text/plain": [
       "*student_id    first_name     last_name     sex    \n",
       "+------------+ +------------+ +-----------+ +-----+\n",
       "1              Alice          Anderson      F      \n",
       "2              Bob            Dylan         M      \n",
       "3              Carol          Lewis         F      \n",
       "4              Chris          Smith         M      \n",
       "5              Stella         Taylor        F      \n",
       "6              Max            Scott         M      \n",
       "7              John           Allen         M      \n",
       "8              Julia          White         F      \n",
       "9              Emma           Reed          F      \n",
       " (Total: 9)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Student()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Dropping a table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "`university`.`student` (9 tuples)\n",
      "Proceed? [yes, No]: yes\n",
      "Tables dropped.  Restart kernel.\n"
     ]
    }
   ],
   "source": [
    "Student.drop()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "@schema\n",
    "class Student(dj.Manual):\n",
    "    definition = \"\"\"\n",
    "    student_id : int unsigned   # university-wide ID number\n",
    "    ---\n",
    "    first_name      : varchar(40)\n",
    "    last_name       : varchar(40)\n",
    "    sex             : enum('F', 'M', 'U')\n",
    "    date_of_birth   : date\n",
    "    home_address    : varchar(120) # mailing street address\n",
    "    home_city       : varchar(60)  # mailing address\n",
    "    home_state      : char(2)      # US state acronym: e.g. OH\n",
    "    home_zip        : char(10)     # zipcode e.g. 93979-4979\n",
    "    home_phone      : varchar(20)  # e.g. 414.657.6883x0881\n",
    "    \"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "import insert_students"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "insert_students.insert(Student, 300)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "    \n",
       "    <style type=\"text/css\">\n",
       "        .Relation{\n",
       "            border-collapse:collapse;\n",
       "        }\n",
       "        .Relation th{\n",
       "            background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "            font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "        }\n",
       "        .Relation td{\n",
       "            padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "        }\n",
       "        .Relation tr:nth-child(odd){\n",
       "            background: #ffffff;\n",
       "        }\n",
       "        .Relation tr:nth-child(even){\n",
       "            background: #f3f1ff;\n",
       "        }\n",
       "        /* Tooltip container */\n",
       "        .djtooltip {\n",
       "        }\n",
       "        /* Tooltip text */\n",
       "        .djtooltip .djtooltiptext {\n",
       "            visibility: hidden;\n",
       "            width: 120px;\n",
       "            background-color: black;\n",
       "            color: #fff;\n",
       "            text-align: center;\n",
       "            padding: 5px 0;\n",
       "            border-radius: 6px;\n",
       "            /* Position the tooltip text - see examples below! */\n",
       "            position: absolute;\n",
       "            z-index: 1;\n",
       "        }\n",
       "        #primary {\n",
       "            font-weight: bold;\n",
       "            color: black;\n",
       "        }\n",
       "        #nonprimary {\n",
       "            font-weight: normal;\n",
       "            color: white;\n",
       "        }\n",
       "\n",
       "        /* Show the tooltip text when you mouse over the tooltip container */\n",
       "        .djtooltip:hover .djtooltiptext {\n",
       "            visibility: visible;\n",
       "        }\n",
       "    </style>\n",
       "    \n",
       "    <b></b>\n",
       "        <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "        <table border=\"1\" class=\"Relation\">\n",
       "            <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                            <p id=\"primary\">student_id</p>\n",
       "                            <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">first_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">last_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">sex</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">date_of_birth</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_address</p>\n",
       "                            <span class=\"djtooltiptext\">mailing street address</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_city</p>\n",
       "                            <span class=\"djtooltiptext\">mailing address</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_state</p>\n",
       "                            <span class=\"djtooltiptext\">US state acronym: e.g. OH</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_zip</p>\n",
       "                            <span class=\"djtooltiptext\">zipcode e.g. 93979-4979</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_phone</p>\n",
       "                            <span class=\"djtooltiptext\">e.g. 414.657.6883x0881</span>\n",
       "                        </div> </th> </tr> </thead>\n",
       "            <tbody> <tr> <td>0</td>\n",
       "<td>Jillian</td>\n",
       "<td>Fischer</td>\n",
       "<td>F</td>\n",
       "<td>2000-12-14</td>\n",
       "<td>68627 Rodriguez Center Suite 032</td>\n",
       "<td>East Anthony</td>\n",
       "<td>WY</td>\n",
       "<td>64660</td>\n",
       "<td>+1-837-213-8181x775</td></tr><tr><td>1</td>\n",
       "<td>Danielle</td>\n",
       "<td>Mccann</td>\n",
       "<td>F</td>\n",
       "<td>2001-07-10</td>\n",
       "<td>459 Watts Path Suite 309</td>\n",
       "<td>Lake Charles</td>\n",
       "<td>PA</td>\n",
       "<td>42226</td>\n",
       "<td>2367757570</td></tr><tr><td>2</td>\n",
       "<td>Gabriel</td>\n",
       "<td>Austin</td>\n",
       "<td>M</td>\n",
       "<td>2002-05-15</td>\n",
       "<td>59647 Bruce Grove</td>\n",
       "<td>New Alexander</td>\n",
       "<td>OR</td>\n",
       "<td>48511</td>\n",
       "<td>+1-834-046-2990x923</td></tr><tr><td>3</td>\n",
       "<td>Gary</td>\n",
       "<td>Adams</td>\n",
       "<td>M</td>\n",
       "<td>1990-12-30</td>\n",
       "<td>2740 Henderson Shore Suite 497</td>\n",
       "<td>East Kyle</td>\n",
       "<td>VA</td>\n",
       "<td>16432</td>\n",
       "<td>(652)366-4084x188</td></tr><tr><td>4</td>\n",
       "<td>Aaron</td>\n",
       "<td>Dixon</td>\n",
       "<td>M</td>\n",
       "<td>2001-06-18</td>\n",
       "<td>57205 Clark Lane</td>\n",
       "<td>Millermouth</td>\n",
       "<td>AZ</td>\n",
       "<td>90284</td>\n",
       "<td>001-593-504-9751x736</td></tr><tr><td>5</td>\n",
       "<td>Mackenzie</td>\n",
       "<td>Boyer</td>\n",
       "<td>F</td>\n",
       "<td>1988-12-26</td>\n",
       "<td>9458 Ashley Stravenue Apt. 044</td>\n",
       "<td>Port Melissaland</td>\n",
       "<td>OH</td>\n",
       "<td>54499</td>\n",
       "<td>669-684-3236</td></tr><tr><td>6</td>\n",
       "<td>Bradley</td>\n",
       "<td>Williams</td>\n",
       "<td>M</td>\n",
       "<td>1986-03-06</td>\n",
       "<td>2067 Gonzalez Summit Suite 002</td>\n",
       "<td>New Kayla</td>\n",
       "<td>AK</td>\n",
       "<td>12823</td>\n",
       "<td>0458569751</td></tr><tr><td>7</td>\n",
       "<td>Anthony</td>\n",
       "<td>Diaz</td>\n",
       "<td>M</td>\n",
       "<td>1990-12-31</td>\n",
       "<td>76723 Anthony Cove</td>\n",
       "<td>Sabrinabury</td>\n",
       "<td>OR</td>\n",
       "<td>42013</td>\n",
       "<td>+1-183-571-0712</td></tr><tr><td>8</td>\n",
       "<td>Jacqueline</td>\n",
       "<td>Colon</td>\n",
       "<td>F</td>\n",
       "<td>1996-02-24</td>\n",
       "<td>64635 Duncan Place</td>\n",
       "<td>Solisburgh</td>\n",
       "<td>UT</td>\n",
       "<td>76301</td>\n",
       "<td>(983)027-5735x055</td></tr><tr><td>9</td>\n",
       "<td>Nicole</td>\n",
       "<td>Long</td>\n",
       "<td>F</td>\n",
       "<td>1986-10-24</td>\n",
       "<td>804 Sarah Rue Suite 661</td>\n",
       "<td>Port Kristinamouth</td>\n",
       "<td>ND</td>\n",
       "<td>07732</td>\n",
       "<td>568-928-6900x28524</td></tr><tr><td>10</td>\n",
       "<td>Brandon</td>\n",
       "<td>Grant</td>\n",
       "<td>M</td>\n",
       "<td>1997-07-31</td>\n",
       "<td>245 Christian Well</td>\n",
       "<td>Ericside</td>\n",
       "<td>ID</td>\n",
       "<td>94059</td>\n",
       "<td>6267113592</td></tr><tr><td>11</td>\n",
       "<td>Kevin</td>\n",
       "<td>Walker</td>\n",
       "<td>M</td>\n",
       "<td>2000-01-16</td>\n",
       "<td>12139 Smith Hills</td>\n",
       "<td>Coleshire</td>\n",
       "<td>OK</td>\n",
       "<td>82926</td>\n",
       "<td>001-227-524-1444x871</td> </tr> </tbody>\n",
       "        </table>\n",
       "        <p>...</p>\n",
       "        <p>Total: 300</p></div>\n",
       "        "
      ],
      "text/plain": [
       "*student_id    first_name     last_name     sex     date_of_birth  home_address   home_city      home_state     home_zip     home_phone    \n",
       "+------------+ +------------+ +-----------+ +-----+ +------------+ +------------+ +------------+ +------------+ +----------+ +------------+\n",
       "0              Jillian        Fischer       F       2000-12-14     68627 Rodrigue East Anthony   WY             64660        +1-837-213-818\n",
       "1              Danielle       Mccann        F       2001-07-10     459 Watts Path Lake Charles   PA             42226        2367757570    \n",
       "2              Gabriel        Austin        M       2002-05-15     59647 Bruce Gr New Alexander  OR             48511        +1-834-046-299\n",
       "3              Gary           Adams         M       1990-12-30     2740 Henderson East Kyle      VA             16432        (652)366-4084x\n",
       "4              Aaron          Dixon         M       2001-06-18     57205 Clark La Millermouth    AZ             90284        001-593-504-97\n",
       "5              Mackenzie      Boyer         F       1988-12-26     9458 Ashley St Port Melissala OH             54499        669-684-3236  \n",
       "6              Bradley        Williams      M       1986-03-06     2067 Gonzalez  New Kayla      AK             12823        0458569751    \n",
       "7              Anthony        Diaz          M       1990-12-31     76723 Anthony  Sabrinabury    OR             42013        +1-183-571-071\n",
       "8              Jacqueline     Colon         F       1996-02-24     64635 Duncan P Solisburgh     UT             76301        (983)027-5735x\n",
       "9              Nicole         Long          F       1986-10-24     804 Sarah Rue  Port Kristinam ND             07732        568-928-6900x2\n",
       "10             Brandon        Grant         M       1997-07-31     245 Christian  Ericside       ID             94059        6267113592    \n",
       "11             Kevin          Walker        M       2000-01-16     12139 Smith Hi Coleshire      OK             82926        001-227-524-14\n",
       "   ...\n",
       " (Total: 300)"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Student()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Querying data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Restricting by attribute values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "    \n",
       "    <style type=\"text/css\">\n",
       "        .Relation{\n",
       "            border-collapse:collapse;\n",
       "        }\n",
       "        .Relation th{\n",
       "            background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "            font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "        }\n",
       "        .Relation td{\n",
       "            padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "        }\n",
       "        .Relation tr:nth-child(odd){\n",
       "            background: #ffffff;\n",
       "        }\n",
       "        .Relation tr:nth-child(even){\n",
       "            background: #f3f1ff;\n",
       "        }\n",
       "        /* Tooltip container */\n",
       "        .djtooltip {\n",
       "        }\n",
       "        /* Tooltip text */\n",
       "        .djtooltip .djtooltiptext {\n",
       "            visibility: hidden;\n",
       "            width: 120px;\n",
       "            background-color: black;\n",
       "            color: #fff;\n",
       "            text-align: center;\n",
       "            padding: 5px 0;\n",
       "            border-radius: 6px;\n",
       "            /* Position the tooltip text - see examples below! */\n",
       "            position: absolute;\n",
       "            z-index: 1;\n",
       "        }\n",
       "        #primary {\n",
       "            font-weight: bold;\n",
       "            color: black;\n",
       "        }\n",
       "        #nonprimary {\n",
       "            font-weight: normal;\n",
       "            color: white;\n",
       "        }\n",
       "\n",
       "        /* Show the tooltip text when you mouse over the tooltip container */\n",
       "        .djtooltip:hover .djtooltiptext {\n",
       "            visibility: visible;\n",
       "        }\n",
       "    </style>\n",
       "    \n",
       "    <b></b>\n",
       "        <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "        <table border=\"1\" class=\"Relation\">\n",
       "            <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                            <p id=\"primary\">student_id</p>\n",
       "                            <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">first_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">last_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">sex</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">date_of_birth</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_address</p>\n",
       "                            <span class=\"djtooltiptext\">mailing street address</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_city</p>\n",
       "                            <span class=\"djtooltiptext\">mailing address</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_state</p>\n",
       "                            <span class=\"djtooltiptext\">US state acronym: e.g. OH</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_zip</p>\n",
       "                            <span class=\"djtooltiptext\">zipcode e.g. 93979-4979</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_phone</p>\n",
       "                            <span class=\"djtooltiptext\">e.g. 414.657.6883x0881</span>\n",
       "                        </div> </th> </tr> </thead>\n",
       "            <tbody> <tr> <td>0</td>\n",
       "<td>Jillian</td>\n",
       "<td>Fischer</td>\n",
       "<td>F</td>\n",
       "<td>2000-12-14</td>\n",
       "<td>68627 Rodriguez Center Suite 032</td>\n",
       "<td>East Anthony</td>\n",
       "<td>WY</td>\n",
       "<td>64660</td>\n",
       "<td>+1-837-213-8181x775</td></tr><tr><td>1</td>\n",
       "<td>Danielle</td>\n",
       "<td>Mccann</td>\n",
       "<td>F</td>\n",
       "<td>2001-07-10</td>\n",
       "<td>459 Watts Path Suite 309</td>\n",
       "<td>Lake Charles</td>\n",
       "<td>PA</td>\n",
       "<td>42226</td>\n",
       "<td>2367757570</td></tr><tr><td>5</td>\n",
       "<td>Mackenzie</td>\n",
       "<td>Boyer</td>\n",
       "<td>F</td>\n",
       "<td>1988-12-26</td>\n",
       "<td>9458 Ashley Stravenue Apt. 044</td>\n",
       "<td>Port Melissaland</td>\n",
       "<td>OH</td>\n",
       "<td>54499</td>\n",
       "<td>669-684-3236</td></tr><tr><td>8</td>\n",
       "<td>Jacqueline</td>\n",
       "<td>Colon</td>\n",
       "<td>F</td>\n",
       "<td>1996-02-24</td>\n",
       "<td>64635 Duncan Place</td>\n",
       "<td>Solisburgh</td>\n",
       "<td>UT</td>\n",
       "<td>76301</td>\n",
       "<td>(983)027-5735x055</td></tr><tr><td>9</td>\n",
       "<td>Nicole</td>\n",
       "<td>Long</td>\n",
       "<td>F</td>\n",
       "<td>1986-10-24</td>\n",
       "<td>804 Sarah Rue Suite 661</td>\n",
       "<td>Port Kristinamouth</td>\n",
       "<td>ND</td>\n",
       "<td>07732</td>\n",
       "<td>568-928-6900x28524</td></tr><tr><td>13</td>\n",
       "<td>Anna</td>\n",
       "<td>Golden</td>\n",
       "<td>F</td>\n",
       "<td>1999-03-09</td>\n",
       "<td>177 Robles Port</td>\n",
       "<td>Jamesmouth</td>\n",
       "<td>PA</td>\n",
       "<td>57615</td>\n",
       "<td>862.977.2190</td></tr><tr><td>14</td>\n",
       "<td>Jessica</td>\n",
       "<td>Ramos</td>\n",
       "<td>F</td>\n",
       "<td>1996-08-13</td>\n",
       "<td>8318 Kenneth Lakes</td>\n",
       "<td>North Megan</td>\n",
       "<td>NJ</td>\n",
       "<td>61279</td>\n",
       "<td>(736)120-0323x9695</td></tr><tr><td>16</td>\n",
       "<td>Heidi</td>\n",
       "<td>Lewis</td>\n",
       "<td>F</td>\n",
       "<td>1992-03-07</td>\n",
       "<td>810 Wanda Pines Suite 244</td>\n",
       "<td>Nicholechester</td>\n",
       "<td>WA</td>\n",
       "<td>39909</td>\n",
       "<td>001-467-054-8928x041</td></tr><tr><td>18</td>\n",
       "<td>Dawn</td>\n",
       "<td>Phillips</td>\n",
       "<td>F</td>\n",
       "<td>2004-08-30</td>\n",
       "<td>9205 Margaret Common Apt. 133</td>\n",
       "<td>East James</td>\n",
       "<td>CA</td>\n",
       "<td>35646</td>\n",
       "<td>+1-986-030-3766x9704</td></tr><tr><td>19</td>\n",
       "<td>Beth</td>\n",
       "<td>Nielsen</td>\n",
       "<td>F</td>\n",
       "<td>1989-10-14</td>\n",
       "<td>52211 Joseph Course</td>\n",
       "<td>Port Amandaberg</td>\n",
       "<td>WY</td>\n",
       "<td>77459</td>\n",
       "<td>001-289-285-4689</td></tr><tr><td>20</td>\n",
       "<td>Mikayla</td>\n",
       "<td>Thomas</td>\n",
       "<td>F</td>\n",
       "<td>2003-10-03</td>\n",
       "<td>3104 Riggs Radial Apt. 751</td>\n",
       "<td>Mathewsview</td>\n",
       "<td>TX</td>\n",
       "<td>41272</td>\n",
       "<td>772.655.0583</td></tr><tr><td>22</td>\n",
       "<td>Kristen</td>\n",
       "<td>Wiley</td>\n",
       "<td>F</td>\n",
       "<td>2003-06-21</td>\n",
       "<td>743 Linda Street Suite 948</td>\n",
       "<td>Christopherhaven</td>\n",
       "<td>WI</td>\n",
       "<td>29738</td>\n",
       "<td>873-334-4318x117</td> </tr> </tbody>\n",
       "        </table>\n",
       "        <p>...</p>\n",
       "        <p>Total: 151</p></div>\n",
       "        "
      ],
      "text/plain": [
       "*student_id    first_name     last_name     sex     date_of_birth  home_address   home_city      home_state     home_zip     home_phone    \n",
       "+------------+ +------------+ +-----------+ +-----+ +------------+ +------------+ +------------+ +------------+ +----------+ +------------+\n",
       "0              Jillian        Fischer       F       2000-12-14     68627 Rodrigue East Anthony   WY             64660        +1-837-213-818\n",
       "1              Danielle       Mccann        F       2001-07-10     459 Watts Path Lake Charles   PA             42226        2367757570    \n",
       "5              Mackenzie      Boyer         F       1988-12-26     9458 Ashley St Port Melissala OH             54499        669-684-3236  \n",
       "8              Jacqueline     Colon         F       1996-02-24     64635 Duncan P Solisburgh     UT             76301        (983)027-5735x\n",
       "9              Nicole         Long          F       1986-10-24     804 Sarah Rue  Port Kristinam ND             07732        568-928-6900x2\n",
       "13             Anna           Golden        F       1999-03-09     177 Robles Por Jamesmouth     PA             57615        862.977.2190  \n",
       "14             Jessica        Ramos         F       1996-08-13     8318 Kenneth L North Megan    NJ             61279        (736)120-0323x\n",
       "16             Heidi          Lewis         F       1992-03-07     810 Wanda Pine Nicholechester WA             39909        001-467-054-89\n",
       "18             Dawn           Phillips      F       2004-08-30     9205 Margaret  East James     CA             35646        +1-986-030-376\n",
       "19             Beth           Nielsen       F       1989-10-14     52211 Joseph C Port Amandaber WY             77459        001-289-285-46\n",
       "20             Mikayla        Thomas        F       2003-10-03     3104 Riggs Rad Mathewsview    TX             41272        772.655.0583  \n",
       "22             Kristen        Wiley         F       2003-06-21     743 Linda Stre Christopherhav WI             29738        873-334-4318x1\n",
       "   ...\n",
       " (Total: 151)"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Student() & 'sex=\"F\"'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "    \n",
       "    <style type=\"text/css\">\n",
       "        .Relation{\n",
       "            border-collapse:collapse;\n",
       "        }\n",
       "        .Relation th{\n",
       "            background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "            font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "        }\n",
       "        .Relation td{\n",
       "            padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "        }\n",
       "        .Relation tr:nth-child(odd){\n",
       "            background: #ffffff;\n",
       "        }\n",
       "        .Relation tr:nth-child(even){\n",
       "            background: #f3f1ff;\n",
       "        }\n",
       "        /* Tooltip container */\n",
       "        .djtooltip {\n",
       "        }\n",
       "        /* Tooltip text */\n",
       "        .djtooltip .djtooltiptext {\n",
       "            visibility: hidden;\n",
       "            width: 120px;\n",
       "            background-color: black;\n",
       "            color: #fff;\n",
       "            text-align: center;\n",
       "            padding: 5px 0;\n",
       "            border-radius: 6px;\n",
       "            /* Position the tooltip text - see examples below! */\n",
       "            position: absolute;\n",
       "            z-index: 1;\n",
       "        }\n",
       "        #primary {\n",
       "            font-weight: bold;\n",
       "            color: black;\n",
       "        }\n",
       "        #nonprimary {\n",
       "            font-weight: normal;\n",
       "            color: white;\n",
       "        }\n",
       "\n",
       "        /* Show the tooltip text when you mouse over the tooltip container */\n",
       "        .djtooltip:hover .djtooltiptext {\n",
       "            visibility: visible;\n",
       "        }\n",
       "    </style>\n",
       "    \n",
       "    <b></b>\n",
       "        <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "        <table border=\"1\" class=\"Relation\">\n",
       "            <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                            <p id=\"primary\">student_id</p>\n",
       "                            <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">first_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">last_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">sex</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">date_of_birth</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_address</p>\n",
       "                            <span class=\"djtooltiptext\">mailing street address</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_city</p>\n",
       "                            <span class=\"djtooltiptext\">mailing address</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_state</p>\n",
       "                            <span class=\"djtooltiptext\">US state acronym: e.g. OH</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_zip</p>\n",
       "                            <span class=\"djtooltiptext\">zipcode e.g. 93979-4979</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_phone</p>\n",
       "                            <span class=\"djtooltiptext\">e.g. 414.657.6883x0881</span>\n",
       "                        </div> </th> </tr> </thead>\n",
       "            <tbody> <tr> <td>0</td>\n",
       "<td>Jillian</td>\n",
       "<td>Fischer</td>\n",
       "<td>F</td>\n",
       "<td>2000-12-14</td>\n",
       "<td>68627 Rodriguez Center Suite 032</td>\n",
       "<td>East Anthony</td>\n",
       "<td>WY</td>\n",
       "<td>64660</td>\n",
       "<td>+1-837-213-8181x775</td></tr><tr><td>1</td>\n",
       "<td>Danielle</td>\n",
       "<td>Mccann</td>\n",
       "<td>F</td>\n",
       "<td>2001-07-10</td>\n",
       "<td>459 Watts Path Suite 309</td>\n",
       "<td>Lake Charles</td>\n",
       "<td>PA</td>\n",
       "<td>42226</td>\n",
       "<td>2367757570</td></tr><tr><td>2</td>\n",
       "<td>Gabriel</td>\n",
       "<td>Austin</td>\n",
       "<td>M</td>\n",
       "<td>2002-05-15</td>\n",
       "<td>59647 Bruce Grove</td>\n",
       "<td>New Alexander</td>\n",
       "<td>OR</td>\n",
       "<td>48511</td>\n",
       "<td>+1-834-046-2990x923</td></tr><tr><td>4</td>\n",
       "<td>Aaron</td>\n",
       "<td>Dixon</td>\n",
       "<td>M</td>\n",
       "<td>2001-06-18</td>\n",
       "<td>57205 Clark Lane</td>\n",
       "<td>Millermouth</td>\n",
       "<td>AZ</td>\n",
       "<td>90284</td>\n",
       "<td>001-593-504-9751x736</td></tr><tr><td>11</td>\n",
       "<td>Kevin</td>\n",
       "<td>Walker</td>\n",
       "<td>M</td>\n",
       "<td>2000-01-16</td>\n",
       "<td>12139 Smith Hills</td>\n",
       "<td>Coleshire</td>\n",
       "<td>OK</td>\n",
       "<td>82926</td>\n",
       "<td>001-227-524-1444x871</td></tr><tr><td>12</td>\n",
       "<td>Bradley</td>\n",
       "<td>Johnson</td>\n",
       "<td>M</td>\n",
       "<td>2002-10-27</td>\n",
       "<td>44057 Amber Club</td>\n",
       "<td>Martinborough</td>\n",
       "<td>WA</td>\n",
       "<td>96529</td>\n",
       "<td>1246630797</td></tr><tr><td>17</td>\n",
       "<td>Charles</td>\n",
       "<td>Burns</td>\n",
       "<td>M</td>\n",
       "<td>2000-03-21</td>\n",
       "<td>374 David Forks</td>\n",
       "<td>West Tylerville</td>\n",
       "<td>AR</td>\n",
       "<td>66484</td>\n",
       "<td>180-517-6772x0773</td></tr><tr><td>18</td>\n",
       "<td>Dawn</td>\n",
       "<td>Phillips</td>\n",
       "<td>F</td>\n",
       "<td>2004-08-30</td>\n",
       "<td>9205 Margaret Common Apt. 133</td>\n",
       "<td>East James</td>\n",
       "<td>CA</td>\n",
       "<td>35646</td>\n",
       "<td>+1-986-030-3766x9704</td></tr><tr><td>20</td>\n",
       "<td>Mikayla</td>\n",
       "<td>Thomas</td>\n",
       "<td>F</td>\n",
       "<td>2003-10-03</td>\n",
       "<td>3104 Riggs Radial Apt. 751</td>\n",
       "<td>Mathewsview</td>\n",
       "<td>TX</td>\n",
       "<td>41272</td>\n",
       "<td>772.655.0583</td></tr><tr><td>22</td>\n",
       "<td>Kristen</td>\n",
       "<td>Wiley</td>\n",
       "<td>F</td>\n",
       "<td>2003-06-21</td>\n",
       "<td>743 Linda Street Suite 948</td>\n",
       "<td>Christopherhaven</td>\n",
       "<td>WI</td>\n",
       "<td>29738</td>\n",
       "<td>873-334-4318x117</td></tr><tr><td>25</td>\n",
       "<td>Dr.</td>\n",
       "<td>Ashley</td>\n",
       "<td>F</td>\n",
       "<td>2005-03-16</td>\n",
       "<td>1004 Fuller Route Suite 401</td>\n",
       "<td>South Gary</td>\n",
       "<td>AR</td>\n",
       "<td>14885</td>\n",
       "<td>965.800.8174x14559</td></tr><tr><td>29</td>\n",
       "<td>Victoria</td>\n",
       "<td>Rodriguez</td>\n",
       "<td>F</td>\n",
       "<td>2005-06-12</td>\n",
       "<td>828 Lee Route</td>\n",
       "<td>Lake Felicia</td>\n",
       "<td>NC</td>\n",
       "<td>44928</td>\n",
       "<td>189.831.8711</td> </tr> </tbody>\n",
       "        </table>\n",
       "        <p>...</p>\n",
       "        <p>Total: 96</p></div>\n",
       "        "
      ],
      "text/plain": [
       "*student_id    first_name     last_name     sex     date_of_birth  home_address   home_city      home_state     home_zip     home_phone    \n",
       "+------------+ +------------+ +-----------+ +-----+ +------------+ +------------+ +------------+ +------------+ +----------+ +------------+\n",
       "0              Jillian        Fischer       F       2000-12-14     68627 Rodrigue East Anthony   WY             64660        +1-837-213-818\n",
       "1              Danielle       Mccann        F       2001-07-10     459 Watts Path Lake Charles   PA             42226        2367757570    \n",
       "2              Gabriel        Austin        M       2002-05-15     59647 Bruce Gr New Alexander  OR             48511        +1-834-046-299\n",
       "4              Aaron          Dixon         M       2001-06-18     57205 Clark La Millermouth    AZ             90284        001-593-504-97\n",
       "11             Kevin          Walker        M       2000-01-16     12139 Smith Hi Coleshire      OK             82926        001-227-524-14\n",
       "12             Bradley        Johnson       M       2002-10-27     44057 Amber Cl Martinborough  WA             96529        1246630797    \n",
       "17             Charles        Burns         M       2000-03-21     374 David Fork West Tylervill AR             66484        180-517-6772x0\n",
       "18             Dawn           Phillips      F       2004-08-30     9205 Margaret  East James     CA             35646        +1-986-030-376\n",
       "20             Mikayla        Thomas        F       2003-10-03     3104 Riggs Rad Mathewsview    TX             41272        772.655.0583  \n",
       "22             Kristen        Wiley         F       2003-06-21     743 Linda Stre Christopherhav WI             29738        873-334-4318x1\n",
       "25             Dr.            Ashley        F       2005-03-16     1004 Fuller Ro South Gary     AR             14885        965.800.8174x1\n",
       "29             Victoria       Rodriguez     F       2005-06-12     828 Lee Route  Lake Felicia   NC             44928        189.831.8711  \n",
       "   ...\n",
       " (Total: 96)"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Student() & 'date_of_birth > \"2000-01-01\"'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "female_texans = Student & [{'sex': 'F'}, {'home_state': 'UT'}]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "    \n",
       "    <style type=\"text/css\">\n",
       "        .Relation{\n",
       "            border-collapse:collapse;\n",
       "        }\n",
       "        .Relation th{\n",
       "            background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "            font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "        }\n",
       "        .Relation td{\n",
       "            padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "        }\n",
       "        .Relation tr:nth-child(odd){\n",
       "            background: #ffffff;\n",
       "        }\n",
       "        .Relation tr:nth-child(even){\n",
       "            background: #f3f1ff;\n",
       "        }\n",
       "        /* Tooltip container */\n",
       "        .djtooltip {\n",
       "        }\n",
       "        /* Tooltip text */\n",
       "        .djtooltip .djtooltiptext {\n",
       "            visibility: hidden;\n",
       "            width: 120px;\n",
       "            background-color: black;\n",
       "            color: #fff;\n",
       "            text-align: center;\n",
       "            padding: 5px 0;\n",
       "            border-radius: 6px;\n",
       "            /* Position the tooltip text - see examples below! */\n",
       "            position: absolute;\n",
       "            z-index: 1;\n",
       "        }\n",
       "        #primary {\n",
       "            font-weight: bold;\n",
       "            color: black;\n",
       "        }\n",
       "        #nonprimary {\n",
       "            font-weight: normal;\n",
       "            color: white;\n",
       "        }\n",
       "\n",
       "        /* Show the tooltip text when you mouse over the tooltip container */\n",
       "        .djtooltip:hover .djtooltiptext {\n",
       "            visibility: visible;\n",
       "        }\n",
       "    </style>\n",
       "    \n",
       "    <b></b>\n",
       "        <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "        <table border=\"1\" class=\"Relation\">\n",
       "            <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                            <p id=\"primary\">student_id</p>\n",
       "                            <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">first_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">last_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">sex</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">date_of_birth</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_address</p>\n",
       "                            <span class=\"djtooltiptext\">mailing street address</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_city</p>\n",
       "                            <span class=\"djtooltiptext\">mailing address</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_state</p>\n",
       "                            <span class=\"djtooltiptext\">US state acronym: e.g. OH</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_zip</p>\n",
       "                            <span class=\"djtooltiptext\">zipcode e.g. 93979-4979</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_phone</p>\n",
       "                            <span class=\"djtooltiptext\">e.g. 414.657.6883x0881</span>\n",
       "                        </div> </th> </tr> </thead>\n",
       "            <tbody> <tr> <td>0</td>\n",
       "<td>Jillian</td>\n",
       "<td>Fischer</td>\n",
       "<td>F</td>\n",
       "<td>2000-12-14</td>\n",
       "<td>68627 Rodriguez Center Suite 032</td>\n",
       "<td>East Anthony</td>\n",
       "<td>WY</td>\n",
       "<td>64660</td>\n",
       "<td>+1-837-213-8181x775</td></tr><tr><td>1</td>\n",
       "<td>Danielle</td>\n",
       "<td>Mccann</td>\n",
       "<td>F</td>\n",
       "<td>2001-07-10</td>\n",
       "<td>459 Watts Path Suite 309</td>\n",
       "<td>Lake Charles</td>\n",
       "<td>PA</td>\n",
       "<td>42226</td>\n",
       "<td>2367757570</td></tr><tr><td>5</td>\n",
       "<td>Mackenzie</td>\n",
       "<td>Boyer</td>\n",
       "<td>F</td>\n",
       "<td>1988-12-26</td>\n",
       "<td>9458 Ashley Stravenue Apt. 044</td>\n",
       "<td>Port Melissaland</td>\n",
       "<td>OH</td>\n",
       "<td>54499</td>\n",
       "<td>669-684-3236</td></tr><tr><td>8</td>\n",
       "<td>Jacqueline</td>\n",
       "<td>Colon</td>\n",
       "<td>F</td>\n",
       "<td>1996-02-24</td>\n",
       "<td>64635 Duncan Place</td>\n",
       "<td>Solisburgh</td>\n",
       "<td>UT</td>\n",
       "<td>76301</td>\n",
       "<td>(983)027-5735x055</td></tr><tr><td>9</td>\n",
       "<td>Nicole</td>\n",
       "<td>Long</td>\n",
       "<td>F</td>\n",
       "<td>1986-10-24</td>\n",
       "<td>804 Sarah Rue Suite 661</td>\n",
       "<td>Port Kristinamouth</td>\n",
       "<td>ND</td>\n",
       "<td>07732</td>\n",
       "<td>568-928-6900x28524</td></tr><tr><td>13</td>\n",
       "<td>Anna</td>\n",
       "<td>Golden</td>\n",
       "<td>F</td>\n",
       "<td>1999-03-09</td>\n",
       "<td>177 Robles Port</td>\n",
       "<td>Jamesmouth</td>\n",
       "<td>PA</td>\n",
       "<td>57615</td>\n",
       "<td>862.977.2190</td></tr><tr><td>14</td>\n",
       "<td>Jessica</td>\n",
       "<td>Ramos</td>\n",
       "<td>F</td>\n",
       "<td>1996-08-13</td>\n",
       "<td>8318 Kenneth Lakes</td>\n",
       "<td>North Megan</td>\n",
       "<td>NJ</td>\n",
       "<td>61279</td>\n",
       "<td>(736)120-0323x9695</td></tr><tr><td>16</td>\n",
       "<td>Heidi</td>\n",
       "<td>Lewis</td>\n",
       "<td>F</td>\n",
       "<td>1992-03-07</td>\n",
       "<td>810 Wanda Pines Suite 244</td>\n",
       "<td>Nicholechester</td>\n",
       "<td>WA</td>\n",
       "<td>39909</td>\n",
       "<td>001-467-054-8928x041</td></tr><tr><td>18</td>\n",
       "<td>Dawn</td>\n",
       "<td>Phillips</td>\n",
       "<td>F</td>\n",
       "<td>2004-08-30</td>\n",
       "<td>9205 Margaret Common Apt. 133</td>\n",
       "<td>East James</td>\n",
       "<td>CA</td>\n",
       "<td>35646</td>\n",
       "<td>+1-986-030-3766x9704</td></tr><tr><td>19</td>\n",
       "<td>Beth</td>\n",
       "<td>Nielsen</td>\n",
       "<td>F</td>\n",
       "<td>1989-10-14</td>\n",
       "<td>52211 Joseph Course</td>\n",
       "<td>Port Amandaberg</td>\n",
       "<td>WY</td>\n",
       "<td>77459</td>\n",
       "<td>001-289-285-4689</td></tr><tr><td>20</td>\n",
       "<td>Mikayla</td>\n",
       "<td>Thomas</td>\n",
       "<td>F</td>\n",
       "<td>2003-10-03</td>\n",
       "<td>3104 Riggs Radial Apt. 751</td>\n",
       "<td>Mathewsview</td>\n",
       "<td>TX</td>\n",
       "<td>41272</td>\n",
       "<td>772.655.0583</td></tr><tr><td>22</td>\n",
       "<td>Kristen</td>\n",
       "<td>Wiley</td>\n",
       "<td>F</td>\n",
       "<td>2003-06-21</td>\n",
       "<td>743 Linda Street Suite 948</td>\n",
       "<td>Christopherhaven</td>\n",
       "<td>WI</td>\n",
       "<td>29738</td>\n",
       "<td>873-334-4318x117</td> </tr> </tbody>\n",
       "        </table>\n",
       "        <p>...</p>\n",
       "        <p>Total: 152</p></div>\n",
       "        "
      ],
      "text/plain": [
       "*student_id    first_name     last_name     sex     date_of_birth  home_address   home_city      home_state     home_zip     home_phone    \n",
       "+------------+ +------------+ +-----------+ +-----+ +------------+ +------------+ +------------+ +------------+ +----------+ +------------+\n",
       "0              Jillian        Fischer       F       2000-12-14     68627 Rodrigue East Anthony   WY             64660        +1-837-213-818\n",
       "1              Danielle       Mccann        F       2001-07-10     459 Watts Path Lake Charles   PA             42226        2367757570    \n",
       "5              Mackenzie      Boyer         F       1988-12-26     9458 Ashley St Port Melissala OH             54499        669-684-3236  \n",
       "8              Jacqueline     Colon         F       1996-02-24     64635 Duncan P Solisburgh     UT             76301        (983)027-5735x\n",
       "9              Nicole         Long          F       1986-10-24     804 Sarah Rue  Port Kristinam ND             07732        568-928-6900x2\n",
       "13             Anna           Golden        F       1999-03-09     177 Robles Por Jamesmouth     PA             57615        862.977.2190  \n",
       "14             Jessica        Ramos         F       1996-08-13     8318 Kenneth L North Megan    NJ             61279        (736)120-0323x\n",
       "16             Heidi          Lewis         F       1992-03-07     810 Wanda Pine Nicholechester WA             39909        001-467-054-89\n",
       "18             Dawn           Phillips      F       2004-08-30     9205 Margaret  East James     CA             35646        +1-986-030-376\n",
       "19             Beth           Nielsen       F       1989-10-14     52211 Joseph C Port Amandaber WY             77459        001-289-285-46\n",
       "20             Mikayla        Thomas        F       2003-10-03     3104 Riggs Rad Mathewsview    TX             41272        772.655.0583  \n",
       "22             Kristen        Wiley         F       2003-06-21     743 Linda Stre Christopherhav WI             29738        873-334-4318x1\n",
       "   ...\n",
       " (Total: 152)"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "female_texans"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Fetching data from the querying results"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([(  0, 'Jillian', 'Fischer', 'F', datetime.date(2000, 12, 14), '68627 Rodriguez Center Suite 032', 'East Anthony', 'WY', '64660', '+1-837-213-8181x775'),\n",
       "       (  1, 'Danielle', 'Mccann', 'F', datetime.date(2001, 7, 10), '459 Watts Path Suite 309', 'Lake Charles', 'PA', '42226', '2367757570'),\n",
       "       (  5, 'Mackenzie', 'Boyer', 'F', datetime.date(1988, 12, 26), '9458 Ashley Stravenue Apt. 044', 'Port Melissaland', 'OH', '54499', '669-684-3236'),\n",
       "       (  8, 'Jacqueline', 'Colon', 'F', datetime.date(1996, 2, 24), '64635 Duncan Place', 'Solisburgh', 'UT', '76301', '(983)027-5735x055'),\n",
       "       (  9, 'Nicole', 'Long', 'F', datetime.date(1986, 10, 24), '804 Sarah Rue Suite 661', 'Port Kristinamouth', 'ND', '07732', '568-928-6900x28524'),\n",
       "       ( 13, 'Anna', 'Golden', 'F', datetime.date(1999, 3, 9), '177 Robles Port', 'Jamesmouth', 'PA', '57615', '862.977.2190'),\n",
       "       ( 14, 'Jessica', 'Ramos', 'F', datetime.date(1996, 8, 13), '8318 Kenneth Lakes', 'North Megan', 'NJ', '61279', '(736)120-0323x9695'),\n",
       "       ( 16, 'Heidi', 'Lewis', 'F', datetime.date(1992, 3, 7), '810 Wanda Pines Suite 244', 'Nicholechester', 'WA', '39909', '001-467-054-8928x041'),\n",
       "       ( 18, 'Dawn', 'Phillips', 'F', datetime.date(2004, 8, 30), '9205 Margaret Common Apt. 133', 'East James', 'CA', '35646', '+1-986-030-3766x9704'),\n",
       "       ( 19, 'Beth', 'Nielsen', 'F', datetime.date(1989, 10, 14), '52211 Joseph Course', 'Port Amandaberg', 'WY', '77459', '001-289-285-4689'),\n",
       "       ( 20, 'Mikayla', 'Thomas', 'F', datetime.date(2003, 10, 3), '3104 Riggs Radial Apt. 751', 'Mathewsview', 'TX', '41272', '772.655.0583'),\n",
       "       ( 22, 'Kristen', 'Wiley', 'F', datetime.date(2003, 6, 21), '743 Linda Street Suite 948', 'Christopherhaven', 'WI', '29738', '873-334-4318x117'),\n",
       "       ( 24, 'Karen', 'Hall', 'F', datetime.date(1991, 1, 1), '802 Oconnor Shoal', 'Courtneyside', 'VA', '76699', '001-450-895-2937x557'),\n",
       "       ( 25, 'Dr.', 'Ashley', 'F', datetime.date(2005, 3, 16), '1004 Fuller Route Suite 401', 'South Gary', 'AR', '14885', '965.800.8174x14559'),\n",
       "       ( 27, 'Tara', 'Moore', 'F', datetime.date(1996, 9, 25), '09753 Timothy Plains Suite 918', 'South Brandichester', 'WV', '20935', '098-675-6040'),\n",
       "       ( 29, 'Victoria', 'Rodriguez', 'F', datetime.date(2005, 6, 12), '828 Lee Route', 'Lake Felicia', 'NC', '44928', '189.831.8711'),\n",
       "       ( 30, 'Debbie', 'Patterson', 'F', datetime.date(1994, 8, 29), '5977 Donald Hills Suite 426', 'North Jillian', 'VA', '86148', '573-589-7894'),\n",
       "       ( 31, 'Karen', 'Lee', 'F', datetime.date(2001, 5, 28), '92397 Smith Court Suite 681', 'New Robin', 'OR', '03775', '001-504-939-0893x736'),\n",
       "       ( 33, 'Kimberly', 'Carey', 'F', datetime.date(1998, 9, 7), '92403 Nancy Mills Apt. 662', 'Port Laurenside', 'NY', '99368', '(097)580-1867x2670'),\n",
       "       ( 34, 'Robin', 'Jones', 'F', datetime.date(1991, 4, 4), '872 Jackson Pines Suite 396', 'Youngborough', 'MA', '74118', '+1-092-142-9264x4959'),\n",
       "       ( 37, 'Heather', 'Humphrey', 'F', datetime.date(2000, 3, 12), '728 Amy Groves Apt. 457', 'South Alvin', 'IN', '27823', '4145328004'),\n",
       "       ( 38, 'Jasmine', 'Hicks', 'F', datetime.date(1986, 6, 22), '92100 Nunez Mountain Suite 341', 'New Rachaelside', 'DC', '53689', '5590657043'),\n",
       "       ( 39, 'Amanda', 'Wang', 'F', datetime.date(2002, 7, 9), '028 James Avenue', 'Donnaburgh', 'NV', '37215', '251-324-2667'),\n",
       "       ( 40, 'Amanda', 'Rosario', 'F', datetime.date(1999, 4, 10), '9563 Michael Pine Suite 931', 'Michaelshire', 'WV', '21208', '001-576-734-7225x242'),\n",
       "       ( 43, 'Amanda', 'Arroyo', 'F', datetime.date(1992, 4, 30), '49408 Williams Brook', 'Jennifermouth', 'NE', '68506', '126-624-6833'),\n",
       "       ( 45, 'Kelly', 'Wheeler', 'F', datetime.date(1999, 8, 28), '5199 Grace Stream', 'North Regina', 'ID', '42797', '(852)471-1509x6905'),\n",
       "       ( 48, 'Kimberly', 'Raymond', 'F', datetime.date(2004, 1, 28), '69277 Ray Key', 'South Danielletown', 'ID', '64803', '022.172.5672x603'),\n",
       "       ( 51, 'Deanna', 'Valdez', 'F', datetime.date(2001, 10, 20), '98307 Jennifer Track', 'South Johnmouth', 'FL', '54437', '788.587.3743'),\n",
       "       ( 53, 'Kristen', 'Jenkins', 'F', datetime.date(1989, 12, 6), '7196 Brian Center', 'Barbaraview', 'NE', '95825', '+1-816-931-7241x906'),\n",
       "       ( 54, 'Jessica', 'Bennett', 'F', datetime.date(2003, 8, 26), '615 Sharon Gateway', 'Port Sean', 'SC', '03709', '867.612.4267x9135'),\n",
       "       ( 55, 'Elizabeth', 'Howell', 'F', datetime.date(2002, 9, 4), '2352 Benjamin Gateway Suite 996', 'Josephburgh', 'IL', '50989', '001-719-428-3855'),\n",
       "       ( 56, 'Dr.', 'Bethany', 'F', datetime.date(2003, 9, 14), '074 Justin Spurs Apt. 653', 'West Davidview', 'WA', '58491', '839-843-6610'),\n",
       "       ( 59, 'Kristina', 'Kirby', 'F', datetime.date(1988, 5, 22), '89489 Young Way', 'Benjaminstad', 'ID', '20962', '+1-494-205-1237x9988'),\n",
       "       ( 61, 'Carolyn', 'Miller', 'F', datetime.date(2002, 9, 18), '955 Brandon Mill Suite 104', 'Tuckerton', 'IN', '83326', '308.665.7407'),\n",
       "       ( 64, 'Ashley', 'Young', 'F', datetime.date(2000, 2, 22), '36721 Simpson Lights Suite 035', 'Smithberg', 'OK', '84539', '733.287.7040'),\n",
       "       ( 66, 'Kristin', 'Mason', 'F', datetime.date(1987, 4, 14), '31397 Stone Parkway Suite 353', 'Lake Amanda', 'DC', '09007', '696.480.4255x92770'),\n",
       "       ( 67, 'Megan', 'Martinez', 'F', datetime.date(1994, 12, 22), '5276 Alexander Avenue Suite 928', 'North Rodney', 'KY', '62441', '(432)914-1079'),\n",
       "       ( 68, 'Janet', 'Anderson', 'F', datetime.date(2002, 6, 28), '206 Smith Viaduct Suite 699', 'Heiditon', 'SD', '81142', '529.788.9930'),\n",
       "       ( 69, 'Vanessa', 'Copeland', 'F', datetime.date(1995, 10, 28), '9695 Samuel Drive Suite 092', 'Christopherburgh', 'WI', '51730', '915-931-4672x9407'),\n",
       "       ( 70, 'Kathleen', 'Reed', 'F', datetime.date(1999, 8, 11), '41882 Allen Walk Apt. 899', 'Sandrabury', 'LA', '56451', '+1-106-887-8907x7524'),\n",
       "       ( 71, 'Katherine', 'Jenkins', 'F', datetime.date(1998, 12, 2), '51656 Joseph Rapid Apt. 522', 'New Richardville', 'KY', '63822', '+1-522-727-7641x7839'),\n",
       "       ( 74, 'Katherine', 'Potter', 'F', datetime.date(2005, 3, 17), '477 Carrillo Street', 'West Emily', 'RI', '62414', '164.047.7857'),\n",
       "       ( 75, 'Teresa', 'Carter', 'F', datetime.date(1996, 2, 26), '597 Aimee Locks', 'Johnfurt', 'NE', '45270', '408-191-1318x661'),\n",
       "       ( 77, 'Rachel', 'Bowen', 'F', datetime.date(2002, 5, 25), '547 Taylor Crest', 'Kellytown', 'ME', '61328', '707-544-3298x4719'),\n",
       "       ( 78, 'Emily', 'Jones', 'F', datetime.date(2001, 10, 18), '502 Cameron Estate', 'South Thomas', 'OK', '51464', '001-280-466-4043x825'),\n",
       "       ( 79, 'Jennifer', 'Nunez', 'F', datetime.date(1989, 3, 1), '158 James Green Apt. 156', 'West Jerry', 'CA', '77440', '(571)077-8320'),\n",
       "       ( 80, 'Jennifer', 'Nguyen', 'F', datetime.date(1993, 11, 10), '6937 Jennifer Lock Apt. 321', 'Deanstad', 'NY', '48675', '001-267-589-2918x447'),\n",
       "       ( 81, 'Jessica', 'Clay', 'F', datetime.date(1997, 5, 22), '536 Hernandez Walks Apt. 972', 'South Alanmouth', 'SD', '96555', '6697468738'),\n",
       "       ( 83, 'Kristin', 'Jones', 'F', datetime.date(1990, 4, 17), '10480 Walker Trail Apt. 498', 'New Robertland', 'RI', '01171', '+1-421-682-5503x016'),\n",
       "       ( 86, 'Andrea', 'Moreno', 'F', datetime.date(1990, 11, 24), '5411 Smith Ways', 'Sanchezberg', 'LA', '26114', '001-988-175-2362'),\n",
       "       ( 91, 'Sara', 'Huff', 'F', datetime.date(2005, 2, 20), '017 Rich Hills Suite 633', 'Brownchester', 'CT', '67581', '(933)377-7739x6876'),\n",
       "       ( 96, 'Kimberly', 'Butler', 'F', datetime.date(1994, 10, 13), '48400 Rodriguez Street', 'Lake Robertstad', 'KS', '77376', '6395340351'),\n",
       "       ( 97, 'Tracy', 'Baker', 'F', datetime.date(2001, 2, 1), '79211 Nathaniel Drive Suite 386', 'South Deannashire', 'IL', '28281', '+1-005-844-5959'),\n",
       "       (101, 'Andrea', 'Franklin', 'F', datetime.date(1996, 6, 9), '4446 Taylor Plaza', 'Port Davidside', 'AR', '93278', '493-991-1706x07012'),\n",
       "       (102, 'Alyssa', 'Brown', 'F', datetime.date(2004, 6, 9), '20243 Daniel Manor Apt. 402', 'Cynthiaberg', 'MN', '22079', '001-925-888-7154x436'),\n",
       "       (107, 'Brenda', 'Sanders', 'F', datetime.date(1990, 4, 25), '189 Stephen Knolls', 'Lake Amyborough', 'AR', '93809', '453.136.2198'),\n",
       "       (109, 'Deanna', 'Cox', 'F', datetime.date(2003, 9, 24), '164 Chapman Drive Apt. 274', 'South Robert', 'NC', '28885', '(235)873-8575'),\n",
       "       (111, 'Heather', 'Alvarado', 'F', datetime.date(2003, 2, 8), '042 Rebecca Mission', 'North Donna', 'MD', '87937', '803.854.9834'),\n",
       "       (116, 'Amber', 'Blankenship', 'F', datetime.date(1993, 12, 12), '41843 Jones Heights', 'Port Kara', 'CT', '78824', '+1-632-246-1077x531'),\n",
       "       (117, 'Kathryn', 'Davis', 'F', datetime.date(1994, 6, 26), '71512 Nicholas Rapids', 'Port Traciberg', 'MA', '84122', '001-011-104-2980x973'),\n",
       "       (118, 'Kristina', 'Norman', 'F', datetime.date(2005, 3, 4), '5665 Dennis Mill', 'Perkinschester', 'PA', '38683', '816-936-8115x18690'),\n",
       "       (119, 'Alicia', 'Sweeney', 'F', datetime.date(1996, 2, 6), '111 Mackenzie Junctions', 'West Linda', 'IN', '93938', '894-678-6968x11463'),\n",
       "       (122, 'Rebecca', 'Copeland', 'F', datetime.date(1994, 12, 13), '89462 Lewis Expressway Apt. 713', 'Haleymouth', 'NY', '78212', '+1-614-640-8342x007'),\n",
       "       (123, 'Anna', 'Cunningham', 'F', datetime.date(2000, 1, 23), '293 Cox Pine', 'Kruegerborough', 'TN', '94115', '095.131.3694'),\n",
       "       (125, 'Kylie', 'Diaz', 'F', datetime.date(2003, 8, 17), '4603 Douglas Fort Apt. 494', 'Colemanview', 'WI', '03325', '052.106.6014x95876'),\n",
       "       (126, 'Kristin', 'Yates', 'F', datetime.date(1989, 9, 26), '7297 Danielle Wells Apt. 787', 'Bruceview', 'AK', '01608', '471-379-8060'),\n",
       "       (127, 'Kayla', 'Sawyer', 'F', datetime.date(1987, 4, 1), '147 Peter Crest', 'Medinamouth', 'SC', '36063', '155.903.2519x32943'),\n",
       "       (128, 'Megan', 'Rodriguez', 'F', datetime.date(1990, 10, 23), '9126 Brown Plaza', 'New David', 'MD', '28416', '924-150-2547'),\n",
       "       (132, 'Deborah', 'Callahan', 'F', datetime.date(1992, 9, 21), '8147 Madison Wells', 'Moyerbury', 'MN', '55249', '815.014.3670'),\n",
       "       (133, 'Natalie', 'Thomas', 'F', datetime.date(2000, 4, 29), '18291 Marcus Lock Apt. 641', 'Carlosmouth', 'LA', '41866', '007.913.3881x94110'),\n",
       "       (137, 'Melanie', 'Miller', 'F', datetime.date(1994, 1, 4), '1921 Michael Courts', 'Thomasberg', 'TN', '95425', '+1-392-739-5934x213'),\n",
       "       (138, 'Amber', 'Peters', 'F', datetime.date(1995, 9, 4), '501 Burnett Inlet', 'West Brittany', 'VT', '08798', '853-889-0428x9721'),\n",
       "       (139, 'Kristen', 'Thomas', 'F', datetime.date(1993, 5, 31), '10941 Virginia Island', 'Penningtonhaven', 'IN', '79891', '(192)078-6665'),\n",
       "       (144, 'Samantha', 'Clark', 'F', datetime.date(1996, 6, 1), '9094 Owens Causeway Suite 106', 'Martinezland', 'WY', '49371', '975.309.8113x664'),\n",
       "       (148, 'Felicia', 'Vaughn', 'F', datetime.date(2001, 8, 5), '90380 Joshua Landing', 'New Steven', 'SD', '37352', '+1-918-046-4526x727'),\n",
       "       (149, 'Debra', 'West', 'F', datetime.date(2003, 11, 9), '49508 Kelly Springs', 'Hallland', 'MD', '01505', '(428)591-2046x3225'),\n",
       "       (151, 'Melissa', 'Thomas', 'F', datetime.date(2002, 6, 5), '454 Mike Walk Suite 188', 'Sarashire', 'IN', '93084', '(707)472-4151x17712'),\n",
       "       (154, 'Tanya', 'Williams', 'F', datetime.date(1985, 11, 19), '427 Ann Isle Apt. 757', 'West Kristinaville', 'CO', '45548', '001-440-604-4666x725'),\n",
       "       (155, 'Emily', 'Byrd', 'F', datetime.date(2004, 4, 3), '650 Roberts Road', 'West Zacharyfort', 'WY', '79775', '(443)399-6944'),\n",
       "       (157, 'Monica', 'Klein', 'F', datetime.date(1998, 12, 9), '53050 Garcia Street Apt. 359', 'Butlerstad', 'DE', '87791', '+1-510-661-1680'),\n",
       "       (158, 'Crystal', 'Leach', 'F', datetime.date(1991, 12, 17), '88760 Elizabeth Station', 'East Scott', 'IN', '76311', '717.446.6353x0889'),\n",
       "       (160, 'Maureen', 'Simon', 'F', datetime.date(1996, 10, 5), '9799 Julie Plaza Suite 583', 'Barryport', 'IN', '87386', '+1-365-486-0536x712'),\n",
       "       (161, 'Wendy', 'Mcclure', 'F', datetime.date(2005, 5, 13), '93627 Hansen Drives', 'New Lisa', 'KS', '01367', '968.733.9273x1230'),\n",
       "       (162, 'Veronica', 'Jackson', 'F', datetime.date(1987, 9, 10), '55017 Anna Viaduct', 'Michaelbury', 'MN', '76244', '(354)996-9659x86033'),\n",
       "       (164, 'Amy', 'Williams', 'F', datetime.date(1998, 7, 29), '334 Weeks Club Suite 643', 'Larsonborough', 'ME', '18462', '409-286-7863'),\n",
       "       (168, 'Alyssa', 'Guerra', 'F', datetime.date(1989, 12, 10), '5551 John Stream', 'West Erikafort', 'TX', '39968', '+1-384-619-7074'),\n",
       "       (169, 'Deborah', 'Cline', 'F', datetime.date(1996, 3, 3), '91196 Anthony Wells', 'Brownhaven', 'MT', '23238', '(671)274-4744x719'),\n",
       "       (171, 'Diana', 'Wagner', 'F', datetime.date(2005, 10, 21), '957 Wong Lights', 'East Matthew', 'MA', '01000', '(282)563-2014x87937'),\n",
       "       (172, 'Tracy', 'Patton', 'F', datetime.date(2005, 4, 6), '82521 Brooks Tunnel Apt. 807', 'West Richardhaven', 'NH', '27416', '856.087.2857'),\n",
       "       (173, 'Taylor', 'Fleming', 'F', datetime.date(1992, 12, 8), '96752 Villa Stream Apt. 607', 'North Sarahchester', 'LA', '55882', '642-759-4869x1650'),\n",
       "       (175, 'Melissa', 'Keller', 'F', datetime.date(1994, 8, 23), '2874 Saunders Glen Suite 317', 'Denisebury', 'TN', '65422', '(484)124-9158x3337'),\n",
       "       (176, 'Crystal', 'Short', 'F', datetime.date(1996, 10, 11), '14918 Brown Walk', 'West Jeff', 'IN', '19394', '001-611-275-1179x645'),\n",
       "       (182, 'Katie', 'Palmer', 'F', datetime.date(1989, 8, 24), '439 Wright Prairie Suite 796', 'Fullerborough', 'ME', '03583', '+1-438-161-7483x788'),\n",
       "       (184, 'Jordan', 'Jones', 'F', datetime.date(1993, 8, 29), '227 Christy Causeway Suite 269', 'Port Brandonchester', 'CT', '34678', '(152)951-9193x444'),\n",
       "       (187, 'Kimberly', 'Anthony', 'F', datetime.date(1996, 1, 15), '71203 Ray Spur', 'Torrestown', 'KY', '09573', '(786)320-7649x2637'),\n",
       "       (188, 'Ashley', 'Guzman', 'F', datetime.date(2001, 11, 14), '011 Fowler Drive Apt. 620', 'Garciamouth', 'MI', '94068', '001-809-948-0078x762'),\n",
       "       (189, 'Kelly', 'Thompson', 'F', datetime.date(2004, 4, 26), '33144 Jeffery Courts Suite 171', 'North Isaiah', 'OR', '50923', '001-437-662-7268x603'),\n",
       "       (192, 'Margaret', 'Hughes', 'F', datetime.date(1986, 11, 17), '4879 Michelle Land Suite 673', 'Jenniferstad', 'PA', '27286', '001-390-553-2632'),\n",
       "       (193, 'Lisa', 'Escobar', 'F', datetime.date(1998, 3, 13), '926 Stark Crossing', 'South Bryan', 'MS', '86227', '(331)589-7870x58178'),\n",
       "       (198, 'Sarah', 'Odonnell', 'F', datetime.date(1989, 9, 13), '18158 Ellison Hills Apt. 244', 'Travisfurt', 'AL', '04641', '(792)274-1066x26038'),\n",
       "       (199, 'Stephanie', 'Curtis', 'F', datetime.date(1995, 11, 14), '133 Christopher Junction Apt. 134', 'South Jennifer', 'CA', '62643', '614-287-6200x23188'),\n",
       "       (200, 'Kimberly', 'Taylor', 'F', datetime.date(1987, 8, 14), '42166 Flores Island', 'Roberthaven', 'MT', '17048', '+1-689-653-0999'),\n",
       "       (201, 'Lacey', 'Taylor', 'F', datetime.date(1988, 4, 26), '97005 Lisa Mill Suite 678', 'Newtonshire', 'TN', '69198', '+1-357-502-7339x1514'),\n",
       "       (202, 'Melissa', 'Little', 'F', datetime.date(1999, 7, 13), '383 Haynes Court', 'North Lindsey', 'NY', '29588', '024.540.9045'),\n",
       "       (206, 'Karen', 'Bryan', 'F', datetime.date(1999, 6, 13), '3670 Carol Village Suite 907', 'South Christinaville', 'GA', '37283', '001-359-306-4754x614'),\n",
       "       (207, 'Anita', 'Harmon', 'F', datetime.date(1995, 6, 27), '9485 Werner Underpass', 'Jeffreyview', 'WV', '39997', '064.111.8438'),\n",
       "       (208, 'Beth', 'Smith', 'F', datetime.date(2004, 9, 30), '958 Kimberly Forges', 'Newmanland', 'NE', '78284', '492.071.6510'),\n",
       "       (209, 'Carrie', 'Dennis', 'F', datetime.date(1993, 11, 12), '3666 Adams Vista', 'North Jenniferland', 'SD', '02830', '+1-395-365-9523x6997'),\n",
       "       (210, 'Paula', 'Perez', 'F', datetime.date(2000, 8, 15), '17911 Frazier Roads', 'Port Tasha', 'UT', '21725', '405.906.1669'),\n",
       "       (213, 'Brianna', 'Rose', 'F', datetime.date(1998, 3, 31), '0428 Gomez Trail Apt. 639', 'North Donna', 'WA', '26718', '001-823-285-7191x368'),\n",
       "       (220, 'Kathryn', 'Lopez', 'F', datetime.date(1988, 3, 25), '861 Tanya Knolls', 'Payneside', 'NJ', '90616', '(074)095-3943x06918'),\n",
       "       (221, 'Sarah', 'Myers', 'F', datetime.date(1993, 1, 26), '34262 Christopher Street', 'Cabrerabury', 'HI', '26895', '915.044.0595'),\n",
       "       (224, 'Donna', 'Smith', 'F', datetime.date(2004, 12, 19), '804 Mccoy Turnpike Suite 847', 'Bautistafurt', 'WI', '29114', '(046)527-9112x706'),\n",
       "       (226, 'Shelley', 'Brooks', 'F', datetime.date(2005, 9, 27), '31828 Taylor Glen Suite 101', 'New Jenniferhaven', 'NJ', '44670', '+1-491-708-0414x864'),\n",
       "       (228, 'Andrea', 'Barrett', 'F', datetime.date(1993, 8, 11), '7100 Scott Lake', 'Kristenstad', 'OK', '09274', '001-500-223-8945x457'),\n",
       "       (234, 'Katelyn', 'Hoover', 'F', datetime.date(1997, 12, 24), '9315 Christopher Road', 'Loriburgh', 'CA', '75454', '275.704.7134x661'),\n",
       "       (235, 'Shannon', 'Williams', 'F', datetime.date(2002, 7, 8), '08663 Kimberly Expressway Apt. 575', 'South Wyatt', 'AL', '80993', '314-058-0010'),\n",
       "       (239, 'Yvette', 'Galloway', 'F', datetime.date(2002, 7, 24), '12076 Anthony Square', 'Samueltown', 'NY', '34260', '(878)866-9801x91611'),\n",
       "       (241, 'Sandra', 'Winters', 'F', datetime.date(2005, 7, 31), '907 Mario Lodge Apt. 942', 'Shermanville', 'ND', '45545', '+1-753-365-4045'),\n",
       "       (248, 'Richard', 'Noble', 'M', datetime.date(2003, 2, 5), '7977 Adams Crossroad Suite 214', 'Port Catherineland', 'UT', '34911', '458.117.5719'),\n",
       "       (249, 'Ashley', 'Thomas', 'F', datetime.date(1996, 8, 29), '241 Katie Fort Apt. 087', 'New Ebony', 'ME', '26233', '135-652-0859x3049'),\n",
       "       (251, 'Ashley', 'Miller', 'F', datetime.date(1988, 6, 13), '1805 Alexis Villages', 'Morrisonton', 'MD', '93116', '(263)336-5912'),\n",
       "       (254, 'Deanna', 'Price', 'F', datetime.date(1994, 11, 4), '120 Edwards Expressway Suite 511', 'Kathleenberg', 'CA', '19876', '001-940-447-1052x158'),\n",
       "       (258, 'Julie', 'Jones', 'F', datetime.date(2005, 8, 2), '35304 Rachel Meadows Suite 288', 'North Jeffreyberg', 'AZ', '48886', '141-934-7302x6340'),\n",
       "       (259, 'Monica', 'Hill', 'F', datetime.date(1992, 10, 18), '945 Angela Key', 'Johnchester', 'GA', '23266', '0750320331'),\n",
       "       (260, 'Joanne', 'Williams', 'F', datetime.date(2001, 2, 7), '85254 Janet Pines', 'Lake Daniel', 'AZ', '34031', '623.410.2275'),\n",
       "       (262, 'Debra', 'Riggs', 'F', datetime.date(2002, 5, 3), '090 Andrew Mountains Apt. 054', 'New Amandachester', 'WA', '61679', '001-635-536-1950x612'),\n",
       "       (264, 'Heidi', 'Charles', 'F', datetime.date(1990, 3, 15), '927 Chandler Groves Suite 929', 'Leeville', 'MA', '27167', '(160)618-6264x340'),\n",
       "       (266, 'Valerie', 'Smith', 'F', datetime.date(1989, 1, 22), '4709 Patrick Wall', 'West Ericview', 'AL', '73935', '(783)138-7164'),\n",
       "       (268, 'Debra', 'Schmitt', 'F', datetime.date(1992, 12, 22), '74229 James Hills Apt. 780', 'East Kristina', 'IN', '43119', '516.311.9867'),\n",
       "       (269, 'Veronica', 'Anderson', 'F', datetime.date(1997, 5, 19), '0043 Baker Springs', 'Kristinaton', 'UT', '04908', '(811)585-2197x666'),\n",
       "       (271, 'Elizabeth', 'Brock', 'F', datetime.date(1987, 3, 6), '8230 Mitchell Extension Apt. 275', 'Port Anthony', 'CA', '31032', '190-577-0466x2936'),\n",
       "       (273, 'Brenda', 'Lynch', 'F', datetime.date(2002, 9, 10), '11630 Jeremy Mountains', 'Austinchester', 'SC', '45091', '(460)652-5911x142'),\n",
       "       (275, 'Diane', 'Walker', 'F', datetime.date(2002, 6, 22), '929 Olivia Turnpike', 'Lake Keithport', 'DE', '11107', '1672377368'),\n",
       "       (276, 'Sara', 'Murphy', 'F', datetime.date(1987, 7, 5), '178 Smith Prairie', 'West Allison', 'ND', '93840', '610.384.6473x01662'),\n",
       "       (278, 'Shannon', 'Mayer', 'F', datetime.date(1997, 4, 10), '8730 Derrick Mews Suite 666', 'Craneborough', 'NV', '24146', '001-006-189-0389x612'),\n",
       "       (279, 'Crystal', 'Parker', 'F', datetime.date(2001, 11, 28), '1314 Jessica Causeway', 'Port Stephen', 'GA', '98006', '(321)139-5367'),\n",
       "       (280, 'Tamara', 'Walter', 'F', datetime.date(2001, 8, 18), '136 Garrison Prairie Apt. 775', 'South Sara', 'IN', '72450', '+1-823-985-9579x9827'),\n",
       "       (281, 'Amber', 'Benson', 'F', datetime.date(1988, 3, 21), '90660 Hamilton Orchard Apt. 932', 'Matthewstown', 'OK', '20573', '001-513-126-8556x683'),\n",
       "       (282, 'Colleen', 'Barnes', 'F', datetime.date(1992, 1, 19), '959 Lin Common Apt. 811', 'Port Phillip', 'MO', '72239', '341.284.4253x580'),\n",
       "       (283, 'Paula', 'Clark', 'F', datetime.date(2005, 9, 30), '49434 Robert Shore', 'Ortizport', 'MI', '20527', '664-842-9310'),\n",
       "       (284, 'Jennifer', 'Cole', 'F', datetime.date(1986, 11, 18), '821 Kline Valleys Apt. 697', 'South Jamesfort', 'WI', '57201', '8222564998'),\n",
       "       (286, 'Angela', 'Hill', 'F', datetime.date(2000, 7, 2), '126 Collins Neck', 'Seanfurt', 'CT', '98022', '213-109-1553x39625'),\n",
       "       (287, 'Mrs.', 'Lisa', 'F', datetime.date(1994, 10, 16), '2117 Walls Harbor Suite 967', 'Lake Anthony', 'WI', '41121', '+1-886-620-3505'),\n",
       "       (288, 'Olivia', 'Martinez', 'F', datetime.date(2001, 6, 25), '0897 Brian Union', 'Fosterfurt', 'ND', '42558', '8320317842'),\n",
       "       (289, 'Alyssa', 'Oliver', 'F', datetime.date(1999, 7, 30), '979 Daisy Cliffs', 'Maureenside', 'NY', '41650', '(927)504-5856'),\n",
       "       (290, 'Barbara', 'Hicks', 'F', datetime.date(2003, 2, 14), '06525 Coleman Via', 'Port Vanessatown', 'DC', '80068', '(403)892-5401x1797'),\n",
       "       (291, 'Shari', 'Rodriguez', 'F', datetime.date(2002, 4, 7), '14993 Reeves Cove', 'East Frederick', 'MN', '14832', '436.215.4569x041'),\n",
       "       (292, 'Wendy', 'Mathews', 'F', datetime.date(2003, 12, 13), '8728 Jamie Courts', 'New Leefort', 'AL', '66380', '+1-716-103-4197x654'),\n",
       "       (296, 'Michelle', 'George', 'F', datetime.date(1994, 1, 2), '56285 Stephanie Wall Suite 800', 'Vazquezside', 'AR', '02142', '(683)009-1622x26181'),\n",
       "       (298, 'Christine', 'Johnson', 'F', datetime.date(2003, 2, 14), '4725 Petersen Via', 'Clarkburgh', 'NC', '75437', '+1-281-129-5589x225'),\n",
       "       (299, 'Lisa', 'Sheppard', 'F', datetime.date(2004, 4, 2), '95923 Reynolds Fork Suite 719', 'West Laura', 'LA', '23546', '001-842-369-3244x325')],\n",
       "      dtype=[('student_id', '<i8'), ('first_name', 'O'), ('last_name', 'O'), ('sex', 'O'), ('date_of_birth', 'O'), ('home_address', 'O'), ('home_city', 'O'), ('home_state', 'O'), ('home_zip', 'O'), ('home_phone', 'O')])"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "female_texans.fetch()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'student_id': 0,\n",
       "  'first_name': 'Jillian',\n",
       "  'last_name': 'Fischer',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2000, 12, 14),\n",
       "  'home_address': '68627 Rodriguez Center Suite 032',\n",
       "  'home_city': 'East Anthony',\n",
       "  'home_state': 'WY',\n",
       "  'home_zip': '64660',\n",
       "  'home_phone': '+1-837-213-8181x775'},\n",
       " {'student_id': 1,\n",
       "  'first_name': 'Danielle',\n",
       "  'last_name': 'Mccann',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2001, 7, 10),\n",
       "  'home_address': '459 Watts Path Suite 309',\n",
       "  'home_city': 'Lake Charles',\n",
       "  'home_state': 'PA',\n",
       "  'home_zip': '42226',\n",
       "  'home_phone': '2367757570'},\n",
       " {'student_id': 5,\n",
       "  'first_name': 'Mackenzie',\n",
       "  'last_name': 'Boyer',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1988, 12, 26),\n",
       "  'home_address': '9458 Ashley Stravenue Apt. 044',\n",
       "  'home_city': 'Port Melissaland',\n",
       "  'home_state': 'OH',\n",
       "  'home_zip': '54499',\n",
       "  'home_phone': '669-684-3236'},\n",
       " {'student_id': 8,\n",
       "  'first_name': 'Jacqueline',\n",
       "  'last_name': 'Colon',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1996, 2, 24),\n",
       "  'home_address': '64635 Duncan Place',\n",
       "  'home_city': 'Solisburgh',\n",
       "  'home_state': 'UT',\n",
       "  'home_zip': '76301',\n",
       "  'home_phone': '(983)027-5735x055'},\n",
       " {'student_id': 9,\n",
       "  'first_name': 'Nicole',\n",
       "  'last_name': 'Long',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1986, 10, 24),\n",
       "  'home_address': '804 Sarah Rue Suite 661',\n",
       "  'home_city': 'Port Kristinamouth',\n",
       "  'home_state': 'ND',\n",
       "  'home_zip': '07732',\n",
       "  'home_phone': '568-928-6900x28524'},\n",
       " {'student_id': 13,\n",
       "  'first_name': 'Anna',\n",
       "  'last_name': 'Golden',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1999, 3, 9),\n",
       "  'home_address': '177 Robles Port',\n",
       "  'home_city': 'Jamesmouth',\n",
       "  'home_state': 'PA',\n",
       "  'home_zip': '57615',\n",
       "  'home_phone': '862.977.2190'},\n",
       " {'student_id': 14,\n",
       "  'first_name': 'Jessica',\n",
       "  'last_name': 'Ramos',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1996, 8, 13),\n",
       "  'home_address': '8318 Kenneth Lakes',\n",
       "  'home_city': 'North Megan',\n",
       "  'home_state': 'NJ',\n",
       "  'home_zip': '61279',\n",
       "  'home_phone': '(736)120-0323x9695'},\n",
       " {'student_id': 16,\n",
       "  'first_name': 'Heidi',\n",
       "  'last_name': 'Lewis',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1992, 3, 7),\n",
       "  'home_address': '810 Wanda Pines Suite 244',\n",
       "  'home_city': 'Nicholechester',\n",
       "  'home_state': 'WA',\n",
       "  'home_zip': '39909',\n",
       "  'home_phone': '001-467-054-8928x041'},\n",
       " {'student_id': 18,\n",
       "  'first_name': 'Dawn',\n",
       "  'last_name': 'Phillips',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2004, 8, 30),\n",
       "  'home_address': '9205 Margaret Common Apt. 133',\n",
       "  'home_city': 'East James',\n",
       "  'home_state': 'CA',\n",
       "  'home_zip': '35646',\n",
       "  'home_phone': '+1-986-030-3766x9704'},\n",
       " {'student_id': 19,\n",
       "  'first_name': 'Beth',\n",
       "  'last_name': 'Nielsen',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1989, 10, 14),\n",
       "  'home_address': '52211 Joseph Course',\n",
       "  'home_city': 'Port Amandaberg',\n",
       "  'home_state': 'WY',\n",
       "  'home_zip': '77459',\n",
       "  'home_phone': '001-289-285-4689'},\n",
       " {'student_id': 20,\n",
       "  'first_name': 'Mikayla',\n",
       "  'last_name': 'Thomas',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2003, 10, 3),\n",
       "  'home_address': '3104 Riggs Radial Apt. 751',\n",
       "  'home_city': 'Mathewsview',\n",
       "  'home_state': 'TX',\n",
       "  'home_zip': '41272',\n",
       "  'home_phone': '772.655.0583'},\n",
       " {'student_id': 22,\n",
       "  'first_name': 'Kristen',\n",
       "  'last_name': 'Wiley',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2003, 6, 21),\n",
       "  'home_address': '743 Linda Street Suite 948',\n",
       "  'home_city': 'Christopherhaven',\n",
       "  'home_state': 'WI',\n",
       "  'home_zip': '29738',\n",
       "  'home_phone': '873-334-4318x117'},\n",
       " {'student_id': 24,\n",
       "  'first_name': 'Karen',\n",
       "  'last_name': 'Hall',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1991, 1, 1),\n",
       "  'home_address': '802 Oconnor Shoal',\n",
       "  'home_city': 'Courtneyside',\n",
       "  'home_state': 'VA',\n",
       "  'home_zip': '76699',\n",
       "  'home_phone': '001-450-895-2937x557'},\n",
       " {'student_id': 25,\n",
       "  'first_name': 'Dr.',\n",
       "  'last_name': 'Ashley',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2005, 3, 16),\n",
       "  'home_address': '1004 Fuller Route Suite 401',\n",
       "  'home_city': 'South Gary',\n",
       "  'home_state': 'AR',\n",
       "  'home_zip': '14885',\n",
       "  'home_phone': '965.800.8174x14559'},\n",
       " {'student_id': 27,\n",
       "  'first_name': 'Tara',\n",
       "  'last_name': 'Moore',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1996, 9, 25),\n",
       "  'home_address': '09753 Timothy Plains Suite 918',\n",
       "  'home_city': 'South Brandichester',\n",
       "  'home_state': 'WV',\n",
       "  'home_zip': '20935',\n",
       "  'home_phone': '098-675-6040'},\n",
       " {'student_id': 29,\n",
       "  'first_name': 'Victoria',\n",
       "  'last_name': 'Rodriguez',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2005, 6, 12),\n",
       "  'home_address': '828 Lee Route',\n",
       "  'home_city': 'Lake Felicia',\n",
       "  'home_state': 'NC',\n",
       "  'home_zip': '44928',\n",
       "  'home_phone': '189.831.8711'},\n",
       " {'student_id': 30,\n",
       "  'first_name': 'Debbie',\n",
       "  'last_name': 'Patterson',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1994, 8, 29),\n",
       "  'home_address': '5977 Donald Hills Suite 426',\n",
       "  'home_city': 'North Jillian',\n",
       "  'home_state': 'VA',\n",
       "  'home_zip': '86148',\n",
       "  'home_phone': '573-589-7894'},\n",
       " {'student_id': 31,\n",
       "  'first_name': 'Karen',\n",
       "  'last_name': 'Lee',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2001, 5, 28),\n",
       "  'home_address': '92397 Smith Court Suite 681',\n",
       "  'home_city': 'New Robin',\n",
       "  'home_state': 'OR',\n",
       "  'home_zip': '03775',\n",
       "  'home_phone': '001-504-939-0893x736'},\n",
       " {'student_id': 33,\n",
       "  'first_name': 'Kimberly',\n",
       "  'last_name': 'Carey',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1998, 9, 7),\n",
       "  'home_address': '92403 Nancy Mills Apt. 662',\n",
       "  'home_city': 'Port Laurenside',\n",
       "  'home_state': 'NY',\n",
       "  'home_zip': '99368',\n",
       "  'home_phone': '(097)580-1867x2670'},\n",
       " {'student_id': 34,\n",
       "  'first_name': 'Robin',\n",
       "  'last_name': 'Jones',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1991, 4, 4),\n",
       "  'home_address': '872 Jackson Pines Suite 396',\n",
       "  'home_city': 'Youngborough',\n",
       "  'home_state': 'MA',\n",
       "  'home_zip': '74118',\n",
       "  'home_phone': '+1-092-142-9264x4959'},\n",
       " {'student_id': 37,\n",
       "  'first_name': 'Heather',\n",
       "  'last_name': 'Humphrey',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2000, 3, 12),\n",
       "  'home_address': '728 Amy Groves Apt. 457',\n",
       "  'home_city': 'South Alvin',\n",
       "  'home_state': 'IN',\n",
       "  'home_zip': '27823',\n",
       "  'home_phone': '4145328004'},\n",
       " {'student_id': 38,\n",
       "  'first_name': 'Jasmine',\n",
       "  'last_name': 'Hicks',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1986, 6, 22),\n",
       "  'home_address': '92100 Nunez Mountain Suite 341',\n",
       "  'home_city': 'New Rachaelside',\n",
       "  'home_state': 'DC',\n",
       "  'home_zip': '53689',\n",
       "  'home_phone': '5590657043'},\n",
       " {'student_id': 39,\n",
       "  'first_name': 'Amanda',\n",
       "  'last_name': 'Wang',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2002, 7, 9),\n",
       "  'home_address': '028 James Avenue',\n",
       "  'home_city': 'Donnaburgh',\n",
       "  'home_state': 'NV',\n",
       "  'home_zip': '37215',\n",
       "  'home_phone': '251-324-2667'},\n",
       " {'student_id': 40,\n",
       "  'first_name': 'Amanda',\n",
       "  'last_name': 'Rosario',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1999, 4, 10),\n",
       "  'home_address': '9563 Michael Pine Suite 931',\n",
       "  'home_city': 'Michaelshire',\n",
       "  'home_state': 'WV',\n",
       "  'home_zip': '21208',\n",
       "  'home_phone': '001-576-734-7225x242'},\n",
       " {'student_id': 43,\n",
       "  'first_name': 'Amanda',\n",
       "  'last_name': 'Arroyo',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1992, 4, 30),\n",
       "  'home_address': '49408 Williams Brook',\n",
       "  'home_city': 'Jennifermouth',\n",
       "  'home_state': 'NE',\n",
       "  'home_zip': '68506',\n",
       "  'home_phone': '126-624-6833'},\n",
       " {'student_id': 45,\n",
       "  'first_name': 'Kelly',\n",
       "  'last_name': 'Wheeler',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1999, 8, 28),\n",
       "  'home_address': '5199 Grace Stream',\n",
       "  'home_city': 'North Regina',\n",
       "  'home_state': 'ID',\n",
       "  'home_zip': '42797',\n",
       "  'home_phone': '(852)471-1509x6905'},\n",
       " {'student_id': 48,\n",
       "  'first_name': 'Kimberly',\n",
       "  'last_name': 'Raymond',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2004, 1, 28),\n",
       "  'home_address': '69277 Ray Key',\n",
       "  'home_city': 'South Danielletown',\n",
       "  'home_state': 'ID',\n",
       "  'home_zip': '64803',\n",
       "  'home_phone': '022.172.5672x603'},\n",
       " {'student_id': 51,\n",
       "  'first_name': 'Deanna',\n",
       "  'last_name': 'Valdez',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2001, 10, 20),\n",
       "  'home_address': '98307 Jennifer Track',\n",
       "  'home_city': 'South Johnmouth',\n",
       "  'home_state': 'FL',\n",
       "  'home_zip': '54437',\n",
       "  'home_phone': '788.587.3743'},\n",
       " {'student_id': 53,\n",
       "  'first_name': 'Kristen',\n",
       "  'last_name': 'Jenkins',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1989, 12, 6),\n",
       "  'home_address': '7196 Brian Center',\n",
       "  'home_city': 'Barbaraview',\n",
       "  'home_state': 'NE',\n",
       "  'home_zip': '95825',\n",
       "  'home_phone': '+1-816-931-7241x906'},\n",
       " {'student_id': 54,\n",
       "  'first_name': 'Jessica',\n",
       "  'last_name': 'Bennett',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2003, 8, 26),\n",
       "  'home_address': '615 Sharon Gateway',\n",
       "  'home_city': 'Port Sean',\n",
       "  'home_state': 'SC',\n",
       "  'home_zip': '03709',\n",
       "  'home_phone': '867.612.4267x9135'},\n",
       " {'student_id': 55,\n",
       "  'first_name': 'Elizabeth',\n",
       "  'last_name': 'Howell',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2002, 9, 4),\n",
       "  'home_address': '2352 Benjamin Gateway Suite 996',\n",
       "  'home_city': 'Josephburgh',\n",
       "  'home_state': 'IL',\n",
       "  'home_zip': '50989',\n",
       "  'home_phone': '001-719-428-3855'},\n",
       " {'student_id': 56,\n",
       "  'first_name': 'Dr.',\n",
       "  'last_name': 'Bethany',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2003, 9, 14),\n",
       "  'home_address': '074 Justin Spurs Apt. 653',\n",
       "  'home_city': 'West Davidview',\n",
       "  'home_state': 'WA',\n",
       "  'home_zip': '58491',\n",
       "  'home_phone': '839-843-6610'},\n",
       " {'student_id': 59,\n",
       "  'first_name': 'Kristina',\n",
       "  'last_name': 'Kirby',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1988, 5, 22),\n",
       "  'home_address': '89489 Young Way',\n",
       "  'home_city': 'Benjaminstad',\n",
       "  'home_state': 'ID',\n",
       "  'home_zip': '20962',\n",
       "  'home_phone': '+1-494-205-1237x9988'},\n",
       " {'student_id': 61,\n",
       "  'first_name': 'Carolyn',\n",
       "  'last_name': 'Miller',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2002, 9, 18),\n",
       "  'home_address': '955 Brandon Mill Suite 104',\n",
       "  'home_city': 'Tuckerton',\n",
       "  'home_state': 'IN',\n",
       "  'home_zip': '83326',\n",
       "  'home_phone': '308.665.7407'},\n",
       " {'student_id': 64,\n",
       "  'first_name': 'Ashley',\n",
       "  'last_name': 'Young',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2000, 2, 22),\n",
       "  'home_address': '36721 Simpson Lights Suite 035',\n",
       "  'home_city': 'Smithberg',\n",
       "  'home_state': 'OK',\n",
       "  'home_zip': '84539',\n",
       "  'home_phone': '733.287.7040'},\n",
       " {'student_id': 66,\n",
       "  'first_name': 'Kristin',\n",
       "  'last_name': 'Mason',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1987, 4, 14),\n",
       "  'home_address': '31397 Stone Parkway Suite 353',\n",
       "  'home_city': 'Lake Amanda',\n",
       "  'home_state': 'DC',\n",
       "  'home_zip': '09007',\n",
       "  'home_phone': '696.480.4255x92770'},\n",
       " {'student_id': 67,\n",
       "  'first_name': 'Megan',\n",
       "  'last_name': 'Martinez',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1994, 12, 22),\n",
       "  'home_address': '5276 Alexander Avenue Suite 928',\n",
       "  'home_city': 'North Rodney',\n",
       "  'home_state': 'KY',\n",
       "  'home_zip': '62441',\n",
       "  'home_phone': '(432)914-1079'},\n",
       " {'student_id': 68,\n",
       "  'first_name': 'Janet',\n",
       "  'last_name': 'Anderson',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2002, 6, 28),\n",
       "  'home_address': '206 Smith Viaduct Suite 699',\n",
       "  'home_city': 'Heiditon',\n",
       "  'home_state': 'SD',\n",
       "  'home_zip': '81142',\n",
       "  'home_phone': '529.788.9930'},\n",
       " {'student_id': 69,\n",
       "  'first_name': 'Vanessa',\n",
       "  'last_name': 'Copeland',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1995, 10, 28),\n",
       "  'home_address': '9695 Samuel Drive Suite 092',\n",
       "  'home_city': 'Christopherburgh',\n",
       "  'home_state': 'WI',\n",
       "  'home_zip': '51730',\n",
       "  'home_phone': '915-931-4672x9407'},\n",
       " {'student_id': 70,\n",
       "  'first_name': 'Kathleen',\n",
       "  'last_name': 'Reed',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1999, 8, 11),\n",
       "  'home_address': '41882 Allen Walk Apt. 899',\n",
       "  'home_city': 'Sandrabury',\n",
       "  'home_state': 'LA',\n",
       "  'home_zip': '56451',\n",
       "  'home_phone': '+1-106-887-8907x7524'},\n",
       " {'student_id': 71,\n",
       "  'first_name': 'Katherine',\n",
       "  'last_name': 'Jenkins',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1998, 12, 2),\n",
       "  'home_address': '51656 Joseph Rapid Apt. 522',\n",
       "  'home_city': 'New Richardville',\n",
       "  'home_state': 'KY',\n",
       "  'home_zip': '63822',\n",
       "  'home_phone': '+1-522-727-7641x7839'},\n",
       " {'student_id': 74,\n",
       "  'first_name': 'Katherine',\n",
       "  'last_name': 'Potter',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2005, 3, 17),\n",
       "  'home_address': '477 Carrillo Street',\n",
       "  'home_city': 'West Emily',\n",
       "  'home_state': 'RI',\n",
       "  'home_zip': '62414',\n",
       "  'home_phone': '164.047.7857'},\n",
       " {'student_id': 75,\n",
       "  'first_name': 'Teresa',\n",
       "  'last_name': 'Carter',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1996, 2, 26),\n",
       "  'home_address': '597 Aimee Locks',\n",
       "  'home_city': 'Johnfurt',\n",
       "  'home_state': 'NE',\n",
       "  'home_zip': '45270',\n",
       "  'home_phone': '408-191-1318x661'},\n",
       " {'student_id': 77,\n",
       "  'first_name': 'Rachel',\n",
       "  'last_name': 'Bowen',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2002, 5, 25),\n",
       "  'home_address': '547 Taylor Crest',\n",
       "  'home_city': 'Kellytown',\n",
       "  'home_state': 'ME',\n",
       "  'home_zip': '61328',\n",
       "  'home_phone': '707-544-3298x4719'},\n",
       " {'student_id': 78,\n",
       "  'first_name': 'Emily',\n",
       "  'last_name': 'Jones',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2001, 10, 18),\n",
       "  'home_address': '502 Cameron Estate',\n",
       "  'home_city': 'South Thomas',\n",
       "  'home_state': 'OK',\n",
       "  'home_zip': '51464',\n",
       "  'home_phone': '001-280-466-4043x825'},\n",
       " {'student_id': 79,\n",
       "  'first_name': 'Jennifer',\n",
       "  'last_name': 'Nunez',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1989, 3, 1),\n",
       "  'home_address': '158 James Green Apt. 156',\n",
       "  'home_city': 'West Jerry',\n",
       "  'home_state': 'CA',\n",
       "  'home_zip': '77440',\n",
       "  'home_phone': '(571)077-8320'},\n",
       " {'student_id': 80,\n",
       "  'first_name': 'Jennifer',\n",
       "  'last_name': 'Nguyen',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1993, 11, 10),\n",
       "  'home_address': '6937 Jennifer Lock Apt. 321',\n",
       "  'home_city': 'Deanstad',\n",
       "  'home_state': 'NY',\n",
       "  'home_zip': '48675',\n",
       "  'home_phone': '001-267-589-2918x447'},\n",
       " {'student_id': 81,\n",
       "  'first_name': 'Jessica',\n",
       "  'last_name': 'Clay',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1997, 5, 22),\n",
       "  'home_address': '536 Hernandez Walks Apt. 972',\n",
       "  'home_city': 'South Alanmouth',\n",
       "  'home_state': 'SD',\n",
       "  'home_zip': '96555',\n",
       "  'home_phone': '6697468738'},\n",
       " {'student_id': 83,\n",
       "  'first_name': 'Kristin',\n",
       "  'last_name': 'Jones',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1990, 4, 17),\n",
       "  'home_address': '10480 Walker Trail Apt. 498',\n",
       "  'home_city': 'New Robertland',\n",
       "  'home_state': 'RI',\n",
       "  'home_zip': '01171',\n",
       "  'home_phone': '+1-421-682-5503x016'},\n",
       " {'student_id': 86,\n",
       "  'first_name': 'Andrea',\n",
       "  'last_name': 'Moreno',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1990, 11, 24),\n",
       "  'home_address': '5411 Smith Ways',\n",
       "  'home_city': 'Sanchezberg',\n",
       "  'home_state': 'LA',\n",
       "  'home_zip': '26114',\n",
       "  'home_phone': '001-988-175-2362'},\n",
       " {'student_id': 91,\n",
       "  'first_name': 'Sara',\n",
       "  'last_name': 'Huff',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2005, 2, 20),\n",
       "  'home_address': '017 Rich Hills Suite 633',\n",
       "  'home_city': 'Brownchester',\n",
       "  'home_state': 'CT',\n",
       "  'home_zip': '67581',\n",
       "  'home_phone': '(933)377-7739x6876'},\n",
       " {'student_id': 96,\n",
       "  'first_name': 'Kimberly',\n",
       "  'last_name': 'Butler',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1994, 10, 13),\n",
       "  'home_address': '48400 Rodriguez Street',\n",
       "  'home_city': 'Lake Robertstad',\n",
       "  'home_state': 'KS',\n",
       "  'home_zip': '77376',\n",
       "  'home_phone': '6395340351'},\n",
       " {'student_id': 97,\n",
       "  'first_name': 'Tracy',\n",
       "  'last_name': 'Baker',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2001, 2, 1),\n",
       "  'home_address': '79211 Nathaniel Drive Suite 386',\n",
       "  'home_city': 'South Deannashire',\n",
       "  'home_state': 'IL',\n",
       "  'home_zip': '28281',\n",
       "  'home_phone': '+1-005-844-5959'},\n",
       " {'student_id': 101,\n",
       "  'first_name': 'Andrea',\n",
       "  'last_name': 'Franklin',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1996, 6, 9),\n",
       "  'home_address': '4446 Taylor Plaza',\n",
       "  'home_city': 'Port Davidside',\n",
       "  'home_state': 'AR',\n",
       "  'home_zip': '93278',\n",
       "  'home_phone': '493-991-1706x07012'},\n",
       " {'student_id': 102,\n",
       "  'first_name': 'Alyssa',\n",
       "  'last_name': 'Brown',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2004, 6, 9),\n",
       "  'home_address': '20243 Daniel Manor Apt. 402',\n",
       "  'home_city': 'Cynthiaberg',\n",
       "  'home_state': 'MN',\n",
       "  'home_zip': '22079',\n",
       "  'home_phone': '001-925-888-7154x436'},\n",
       " {'student_id': 107,\n",
       "  'first_name': 'Brenda',\n",
       "  'last_name': 'Sanders',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1990, 4, 25),\n",
       "  'home_address': '189 Stephen Knolls',\n",
       "  'home_city': 'Lake Amyborough',\n",
       "  'home_state': 'AR',\n",
       "  'home_zip': '93809',\n",
       "  'home_phone': '453.136.2198'},\n",
       " {'student_id': 109,\n",
       "  'first_name': 'Deanna',\n",
       "  'last_name': 'Cox',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2003, 9, 24),\n",
       "  'home_address': '164 Chapman Drive Apt. 274',\n",
       "  'home_city': 'South Robert',\n",
       "  'home_state': 'NC',\n",
       "  'home_zip': '28885',\n",
       "  'home_phone': '(235)873-8575'},\n",
       " {'student_id': 111,\n",
       "  'first_name': 'Heather',\n",
       "  'last_name': 'Alvarado',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2003, 2, 8),\n",
       "  'home_address': '042 Rebecca Mission',\n",
       "  'home_city': 'North Donna',\n",
       "  'home_state': 'MD',\n",
       "  'home_zip': '87937',\n",
       "  'home_phone': '803.854.9834'},\n",
       " {'student_id': 116,\n",
       "  'first_name': 'Amber',\n",
       "  'last_name': 'Blankenship',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1993, 12, 12),\n",
       "  'home_address': '41843 Jones Heights',\n",
       "  'home_city': 'Port Kara',\n",
       "  'home_state': 'CT',\n",
       "  'home_zip': '78824',\n",
       "  'home_phone': '+1-632-246-1077x531'},\n",
       " {'student_id': 117,\n",
       "  'first_name': 'Kathryn',\n",
       "  'last_name': 'Davis',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1994, 6, 26),\n",
       "  'home_address': '71512 Nicholas Rapids',\n",
       "  'home_city': 'Port Traciberg',\n",
       "  'home_state': 'MA',\n",
       "  'home_zip': '84122',\n",
       "  'home_phone': '001-011-104-2980x973'},\n",
       " {'student_id': 118,\n",
       "  'first_name': 'Kristina',\n",
       "  'last_name': 'Norman',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2005, 3, 4),\n",
       "  'home_address': '5665 Dennis Mill',\n",
       "  'home_city': 'Perkinschester',\n",
       "  'home_state': 'PA',\n",
       "  'home_zip': '38683',\n",
       "  'home_phone': '816-936-8115x18690'},\n",
       " {'student_id': 119,\n",
       "  'first_name': 'Alicia',\n",
       "  'last_name': 'Sweeney',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1996, 2, 6),\n",
       "  'home_address': '111 Mackenzie Junctions',\n",
       "  'home_city': 'West Linda',\n",
       "  'home_state': 'IN',\n",
       "  'home_zip': '93938',\n",
       "  'home_phone': '894-678-6968x11463'},\n",
       " {'student_id': 122,\n",
       "  'first_name': 'Rebecca',\n",
       "  'last_name': 'Copeland',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1994, 12, 13),\n",
       "  'home_address': '89462 Lewis Expressway Apt. 713',\n",
       "  'home_city': 'Haleymouth',\n",
       "  'home_state': 'NY',\n",
       "  'home_zip': '78212',\n",
       "  'home_phone': '+1-614-640-8342x007'},\n",
       " {'student_id': 123,\n",
       "  'first_name': 'Anna',\n",
       "  'last_name': 'Cunningham',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2000, 1, 23),\n",
       "  'home_address': '293 Cox Pine',\n",
       "  'home_city': 'Kruegerborough',\n",
       "  'home_state': 'TN',\n",
       "  'home_zip': '94115',\n",
       "  'home_phone': '095.131.3694'},\n",
       " {'student_id': 125,\n",
       "  'first_name': 'Kylie',\n",
       "  'last_name': 'Diaz',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2003, 8, 17),\n",
       "  'home_address': '4603 Douglas Fort Apt. 494',\n",
       "  'home_city': 'Colemanview',\n",
       "  'home_state': 'WI',\n",
       "  'home_zip': '03325',\n",
       "  'home_phone': '052.106.6014x95876'},\n",
       " {'student_id': 126,\n",
       "  'first_name': 'Kristin',\n",
       "  'last_name': 'Yates',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1989, 9, 26),\n",
       "  'home_address': '7297 Danielle Wells Apt. 787',\n",
       "  'home_city': 'Bruceview',\n",
       "  'home_state': 'AK',\n",
       "  'home_zip': '01608',\n",
       "  'home_phone': '471-379-8060'},\n",
       " {'student_id': 127,\n",
       "  'first_name': 'Kayla',\n",
       "  'last_name': 'Sawyer',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1987, 4, 1),\n",
       "  'home_address': '147 Peter Crest',\n",
       "  'home_city': 'Medinamouth',\n",
       "  'home_state': 'SC',\n",
       "  'home_zip': '36063',\n",
       "  'home_phone': '155.903.2519x32943'},\n",
       " {'student_id': 128,\n",
       "  'first_name': 'Megan',\n",
       "  'last_name': 'Rodriguez',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1990, 10, 23),\n",
       "  'home_address': '9126 Brown Plaza',\n",
       "  'home_city': 'New David',\n",
       "  'home_state': 'MD',\n",
       "  'home_zip': '28416',\n",
       "  'home_phone': '924-150-2547'},\n",
       " {'student_id': 132,\n",
       "  'first_name': 'Deborah',\n",
       "  'last_name': 'Callahan',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1992, 9, 21),\n",
       "  'home_address': '8147 Madison Wells',\n",
       "  'home_city': 'Moyerbury',\n",
       "  'home_state': 'MN',\n",
       "  'home_zip': '55249',\n",
       "  'home_phone': '815.014.3670'},\n",
       " {'student_id': 133,\n",
       "  'first_name': 'Natalie',\n",
       "  'last_name': 'Thomas',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2000, 4, 29),\n",
       "  'home_address': '18291 Marcus Lock Apt. 641',\n",
       "  'home_city': 'Carlosmouth',\n",
       "  'home_state': 'LA',\n",
       "  'home_zip': '41866',\n",
       "  'home_phone': '007.913.3881x94110'},\n",
       " {'student_id': 137,\n",
       "  'first_name': 'Melanie',\n",
       "  'last_name': 'Miller',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1994, 1, 4),\n",
       "  'home_address': '1921 Michael Courts',\n",
       "  'home_city': 'Thomasberg',\n",
       "  'home_state': 'TN',\n",
       "  'home_zip': '95425',\n",
       "  'home_phone': '+1-392-739-5934x213'},\n",
       " {'student_id': 138,\n",
       "  'first_name': 'Amber',\n",
       "  'last_name': 'Peters',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1995, 9, 4),\n",
       "  'home_address': '501 Burnett Inlet',\n",
       "  'home_city': 'West Brittany',\n",
       "  'home_state': 'VT',\n",
       "  'home_zip': '08798',\n",
       "  'home_phone': '853-889-0428x9721'},\n",
       " {'student_id': 139,\n",
       "  'first_name': 'Kristen',\n",
       "  'last_name': 'Thomas',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1993, 5, 31),\n",
       "  'home_address': '10941 Virginia Island',\n",
       "  'home_city': 'Penningtonhaven',\n",
       "  'home_state': 'IN',\n",
       "  'home_zip': '79891',\n",
       "  'home_phone': '(192)078-6665'},\n",
       " {'student_id': 144,\n",
       "  'first_name': 'Samantha',\n",
       "  'last_name': 'Clark',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1996, 6, 1),\n",
       "  'home_address': '9094 Owens Causeway Suite 106',\n",
       "  'home_city': 'Martinezland',\n",
       "  'home_state': 'WY',\n",
       "  'home_zip': '49371',\n",
       "  'home_phone': '975.309.8113x664'},\n",
       " {'student_id': 148,\n",
       "  'first_name': 'Felicia',\n",
       "  'last_name': 'Vaughn',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2001, 8, 5),\n",
       "  'home_address': '90380 Joshua Landing',\n",
       "  'home_city': 'New Steven',\n",
       "  'home_state': 'SD',\n",
       "  'home_zip': '37352',\n",
       "  'home_phone': '+1-918-046-4526x727'},\n",
       " {'student_id': 149,\n",
       "  'first_name': 'Debra',\n",
       "  'last_name': 'West',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2003, 11, 9),\n",
       "  'home_address': '49508 Kelly Springs',\n",
       "  'home_city': 'Hallland',\n",
       "  'home_state': 'MD',\n",
       "  'home_zip': '01505',\n",
       "  'home_phone': '(428)591-2046x3225'},\n",
       " {'student_id': 151,\n",
       "  'first_name': 'Melissa',\n",
       "  'last_name': 'Thomas',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2002, 6, 5),\n",
       "  'home_address': '454 Mike Walk Suite 188',\n",
       "  'home_city': 'Sarashire',\n",
       "  'home_state': 'IN',\n",
       "  'home_zip': '93084',\n",
       "  'home_phone': '(707)472-4151x17712'},\n",
       " {'student_id': 154,\n",
       "  'first_name': 'Tanya',\n",
       "  'last_name': 'Williams',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1985, 11, 19),\n",
       "  'home_address': '427 Ann Isle Apt. 757',\n",
       "  'home_city': 'West Kristinaville',\n",
       "  'home_state': 'CO',\n",
       "  'home_zip': '45548',\n",
       "  'home_phone': '001-440-604-4666x725'},\n",
       " {'student_id': 155,\n",
       "  'first_name': 'Emily',\n",
       "  'last_name': 'Byrd',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2004, 4, 3),\n",
       "  'home_address': '650 Roberts Road',\n",
       "  'home_city': 'West Zacharyfort',\n",
       "  'home_state': 'WY',\n",
       "  'home_zip': '79775',\n",
       "  'home_phone': '(443)399-6944'},\n",
       " {'student_id': 157,\n",
       "  'first_name': 'Monica',\n",
       "  'last_name': 'Klein',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1998, 12, 9),\n",
       "  'home_address': '53050 Garcia Street Apt. 359',\n",
       "  'home_city': 'Butlerstad',\n",
       "  'home_state': 'DE',\n",
       "  'home_zip': '87791',\n",
       "  'home_phone': '+1-510-661-1680'},\n",
       " {'student_id': 158,\n",
       "  'first_name': 'Crystal',\n",
       "  'last_name': 'Leach',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1991, 12, 17),\n",
       "  'home_address': '88760 Elizabeth Station',\n",
       "  'home_city': 'East Scott',\n",
       "  'home_state': 'IN',\n",
       "  'home_zip': '76311',\n",
       "  'home_phone': '717.446.6353x0889'},\n",
       " {'student_id': 160,\n",
       "  'first_name': 'Maureen',\n",
       "  'last_name': 'Simon',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1996, 10, 5),\n",
       "  'home_address': '9799 Julie Plaza Suite 583',\n",
       "  'home_city': 'Barryport',\n",
       "  'home_state': 'IN',\n",
       "  'home_zip': '87386',\n",
       "  'home_phone': '+1-365-486-0536x712'},\n",
       " {'student_id': 161,\n",
       "  'first_name': 'Wendy',\n",
       "  'last_name': 'Mcclure',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2005, 5, 13),\n",
       "  'home_address': '93627 Hansen Drives',\n",
       "  'home_city': 'New Lisa',\n",
       "  'home_state': 'KS',\n",
       "  'home_zip': '01367',\n",
       "  'home_phone': '968.733.9273x1230'},\n",
       " {'student_id': 162,\n",
       "  'first_name': 'Veronica',\n",
       "  'last_name': 'Jackson',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1987, 9, 10),\n",
       "  'home_address': '55017 Anna Viaduct',\n",
       "  'home_city': 'Michaelbury',\n",
       "  'home_state': 'MN',\n",
       "  'home_zip': '76244',\n",
       "  'home_phone': '(354)996-9659x86033'},\n",
       " {'student_id': 164,\n",
       "  'first_name': 'Amy',\n",
       "  'last_name': 'Williams',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1998, 7, 29),\n",
       "  'home_address': '334 Weeks Club Suite 643',\n",
       "  'home_city': 'Larsonborough',\n",
       "  'home_state': 'ME',\n",
       "  'home_zip': '18462',\n",
       "  'home_phone': '409-286-7863'},\n",
       " {'student_id': 168,\n",
       "  'first_name': 'Alyssa',\n",
       "  'last_name': 'Guerra',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1989, 12, 10),\n",
       "  'home_address': '5551 John Stream',\n",
       "  'home_city': 'West Erikafort',\n",
       "  'home_state': 'TX',\n",
       "  'home_zip': '39968',\n",
       "  'home_phone': '+1-384-619-7074'},\n",
       " {'student_id': 169,\n",
       "  'first_name': 'Deborah',\n",
       "  'last_name': 'Cline',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1996, 3, 3),\n",
       "  'home_address': '91196 Anthony Wells',\n",
       "  'home_city': 'Brownhaven',\n",
       "  'home_state': 'MT',\n",
       "  'home_zip': '23238',\n",
       "  'home_phone': '(671)274-4744x719'},\n",
       " {'student_id': 171,\n",
       "  'first_name': 'Diana',\n",
       "  'last_name': 'Wagner',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2005, 10, 21),\n",
       "  'home_address': '957 Wong Lights',\n",
       "  'home_city': 'East Matthew',\n",
       "  'home_state': 'MA',\n",
       "  'home_zip': '01000',\n",
       "  'home_phone': '(282)563-2014x87937'},\n",
       " {'student_id': 172,\n",
       "  'first_name': 'Tracy',\n",
       "  'last_name': 'Patton',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2005, 4, 6),\n",
       "  'home_address': '82521 Brooks Tunnel Apt. 807',\n",
       "  'home_city': 'West Richardhaven',\n",
       "  'home_state': 'NH',\n",
       "  'home_zip': '27416',\n",
       "  'home_phone': '856.087.2857'},\n",
       " {'student_id': 173,\n",
       "  'first_name': 'Taylor',\n",
       "  'last_name': 'Fleming',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1992, 12, 8),\n",
       "  'home_address': '96752 Villa Stream Apt. 607',\n",
       "  'home_city': 'North Sarahchester',\n",
       "  'home_state': 'LA',\n",
       "  'home_zip': '55882',\n",
       "  'home_phone': '642-759-4869x1650'},\n",
       " {'student_id': 175,\n",
       "  'first_name': 'Melissa',\n",
       "  'last_name': 'Keller',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1994, 8, 23),\n",
       "  'home_address': '2874 Saunders Glen Suite 317',\n",
       "  'home_city': 'Denisebury',\n",
       "  'home_state': 'TN',\n",
       "  'home_zip': '65422',\n",
       "  'home_phone': '(484)124-9158x3337'},\n",
       " {'student_id': 176,\n",
       "  'first_name': 'Crystal',\n",
       "  'last_name': 'Short',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1996, 10, 11),\n",
       "  'home_address': '14918 Brown Walk',\n",
       "  'home_city': 'West Jeff',\n",
       "  'home_state': 'IN',\n",
       "  'home_zip': '19394',\n",
       "  'home_phone': '001-611-275-1179x645'},\n",
       " {'student_id': 182,\n",
       "  'first_name': 'Katie',\n",
       "  'last_name': 'Palmer',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1989, 8, 24),\n",
       "  'home_address': '439 Wright Prairie Suite 796',\n",
       "  'home_city': 'Fullerborough',\n",
       "  'home_state': 'ME',\n",
       "  'home_zip': '03583',\n",
       "  'home_phone': '+1-438-161-7483x788'},\n",
       " {'student_id': 184,\n",
       "  'first_name': 'Jordan',\n",
       "  'last_name': 'Jones',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1993, 8, 29),\n",
       "  'home_address': '227 Christy Causeway Suite 269',\n",
       "  'home_city': 'Port Brandonchester',\n",
       "  'home_state': 'CT',\n",
       "  'home_zip': '34678',\n",
       "  'home_phone': '(152)951-9193x444'},\n",
       " {'student_id': 187,\n",
       "  'first_name': 'Kimberly',\n",
       "  'last_name': 'Anthony',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1996, 1, 15),\n",
       "  'home_address': '71203 Ray Spur',\n",
       "  'home_city': 'Torrestown',\n",
       "  'home_state': 'KY',\n",
       "  'home_zip': '09573',\n",
       "  'home_phone': '(786)320-7649x2637'},\n",
       " {'student_id': 188,\n",
       "  'first_name': 'Ashley',\n",
       "  'last_name': 'Guzman',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2001, 11, 14),\n",
       "  'home_address': '011 Fowler Drive Apt. 620',\n",
       "  'home_city': 'Garciamouth',\n",
       "  'home_state': 'MI',\n",
       "  'home_zip': '94068',\n",
       "  'home_phone': '001-809-948-0078x762'},\n",
       " {'student_id': 189,\n",
       "  'first_name': 'Kelly',\n",
       "  'last_name': 'Thompson',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2004, 4, 26),\n",
       "  'home_address': '33144 Jeffery Courts Suite 171',\n",
       "  'home_city': 'North Isaiah',\n",
       "  'home_state': 'OR',\n",
       "  'home_zip': '50923',\n",
       "  'home_phone': '001-437-662-7268x603'},\n",
       " {'student_id': 192,\n",
       "  'first_name': 'Margaret',\n",
       "  'last_name': 'Hughes',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1986, 11, 17),\n",
       "  'home_address': '4879 Michelle Land Suite 673',\n",
       "  'home_city': 'Jenniferstad',\n",
       "  'home_state': 'PA',\n",
       "  'home_zip': '27286',\n",
       "  'home_phone': '001-390-553-2632'},\n",
       " {'student_id': 193,\n",
       "  'first_name': 'Lisa',\n",
       "  'last_name': 'Escobar',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1998, 3, 13),\n",
       "  'home_address': '926 Stark Crossing',\n",
       "  'home_city': 'South Bryan',\n",
       "  'home_state': 'MS',\n",
       "  'home_zip': '86227',\n",
       "  'home_phone': '(331)589-7870x58178'},\n",
       " {'student_id': 198,\n",
       "  'first_name': 'Sarah',\n",
       "  'last_name': 'Odonnell',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1989, 9, 13),\n",
       "  'home_address': '18158 Ellison Hills Apt. 244',\n",
       "  'home_city': 'Travisfurt',\n",
       "  'home_state': 'AL',\n",
       "  'home_zip': '04641',\n",
       "  'home_phone': '(792)274-1066x26038'},\n",
       " {'student_id': 199,\n",
       "  'first_name': 'Stephanie',\n",
       "  'last_name': 'Curtis',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1995, 11, 14),\n",
       "  'home_address': '133 Christopher Junction Apt. 134',\n",
       "  'home_city': 'South Jennifer',\n",
       "  'home_state': 'CA',\n",
       "  'home_zip': '62643',\n",
       "  'home_phone': '614-287-6200x23188'},\n",
       " {'student_id': 200,\n",
       "  'first_name': 'Kimberly',\n",
       "  'last_name': 'Taylor',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1987, 8, 14),\n",
       "  'home_address': '42166 Flores Island',\n",
       "  'home_city': 'Roberthaven',\n",
       "  'home_state': 'MT',\n",
       "  'home_zip': '17048',\n",
       "  'home_phone': '+1-689-653-0999'},\n",
       " {'student_id': 201,\n",
       "  'first_name': 'Lacey',\n",
       "  'last_name': 'Taylor',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1988, 4, 26),\n",
       "  'home_address': '97005 Lisa Mill Suite 678',\n",
       "  'home_city': 'Newtonshire',\n",
       "  'home_state': 'TN',\n",
       "  'home_zip': '69198',\n",
       "  'home_phone': '+1-357-502-7339x1514'},\n",
       " {'student_id': 202,\n",
       "  'first_name': 'Melissa',\n",
       "  'last_name': 'Little',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1999, 7, 13),\n",
       "  'home_address': '383 Haynes Court',\n",
       "  'home_city': 'North Lindsey',\n",
       "  'home_state': 'NY',\n",
       "  'home_zip': '29588',\n",
       "  'home_phone': '024.540.9045'},\n",
       " {'student_id': 206,\n",
       "  'first_name': 'Karen',\n",
       "  'last_name': 'Bryan',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1999, 6, 13),\n",
       "  'home_address': '3670 Carol Village Suite 907',\n",
       "  'home_city': 'South Christinaville',\n",
       "  'home_state': 'GA',\n",
       "  'home_zip': '37283',\n",
       "  'home_phone': '001-359-306-4754x614'},\n",
       " {'student_id': 207,\n",
       "  'first_name': 'Anita',\n",
       "  'last_name': 'Harmon',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1995, 6, 27),\n",
       "  'home_address': '9485 Werner Underpass',\n",
       "  'home_city': 'Jeffreyview',\n",
       "  'home_state': 'WV',\n",
       "  'home_zip': '39997',\n",
       "  'home_phone': '064.111.8438'},\n",
       " {'student_id': 208,\n",
       "  'first_name': 'Beth',\n",
       "  'last_name': 'Smith',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2004, 9, 30),\n",
       "  'home_address': '958 Kimberly Forges',\n",
       "  'home_city': 'Newmanland',\n",
       "  'home_state': 'NE',\n",
       "  'home_zip': '78284',\n",
       "  'home_phone': '492.071.6510'},\n",
       " {'student_id': 209,\n",
       "  'first_name': 'Carrie',\n",
       "  'last_name': 'Dennis',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1993, 11, 12),\n",
       "  'home_address': '3666 Adams Vista',\n",
       "  'home_city': 'North Jenniferland',\n",
       "  'home_state': 'SD',\n",
       "  'home_zip': '02830',\n",
       "  'home_phone': '+1-395-365-9523x6997'},\n",
       " {'student_id': 210,\n",
       "  'first_name': 'Paula',\n",
       "  'last_name': 'Perez',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2000, 8, 15),\n",
       "  'home_address': '17911 Frazier Roads',\n",
       "  'home_city': 'Port Tasha',\n",
       "  'home_state': 'UT',\n",
       "  'home_zip': '21725',\n",
       "  'home_phone': '405.906.1669'},\n",
       " {'student_id': 213,\n",
       "  'first_name': 'Brianna',\n",
       "  'last_name': 'Rose',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1998, 3, 31),\n",
       "  'home_address': '0428 Gomez Trail Apt. 639',\n",
       "  'home_city': 'North Donna',\n",
       "  'home_state': 'WA',\n",
       "  'home_zip': '26718',\n",
       "  'home_phone': '001-823-285-7191x368'},\n",
       " {'student_id': 220,\n",
       "  'first_name': 'Kathryn',\n",
       "  'last_name': 'Lopez',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1988, 3, 25),\n",
       "  'home_address': '861 Tanya Knolls',\n",
       "  'home_city': 'Payneside',\n",
       "  'home_state': 'NJ',\n",
       "  'home_zip': '90616',\n",
       "  'home_phone': '(074)095-3943x06918'},\n",
       " {'student_id': 221,\n",
       "  'first_name': 'Sarah',\n",
       "  'last_name': 'Myers',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1993, 1, 26),\n",
       "  'home_address': '34262 Christopher Street',\n",
       "  'home_city': 'Cabrerabury',\n",
       "  'home_state': 'HI',\n",
       "  'home_zip': '26895',\n",
       "  'home_phone': '915.044.0595'},\n",
       " {'student_id': 224,\n",
       "  'first_name': 'Donna',\n",
       "  'last_name': 'Smith',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2004, 12, 19),\n",
       "  'home_address': '804 Mccoy Turnpike Suite 847',\n",
       "  'home_city': 'Bautistafurt',\n",
       "  'home_state': 'WI',\n",
       "  'home_zip': '29114',\n",
       "  'home_phone': '(046)527-9112x706'},\n",
       " {'student_id': 226,\n",
       "  'first_name': 'Shelley',\n",
       "  'last_name': 'Brooks',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2005, 9, 27),\n",
       "  'home_address': '31828 Taylor Glen Suite 101',\n",
       "  'home_city': 'New Jenniferhaven',\n",
       "  'home_state': 'NJ',\n",
       "  'home_zip': '44670',\n",
       "  'home_phone': '+1-491-708-0414x864'},\n",
       " {'student_id': 228,\n",
       "  'first_name': 'Andrea',\n",
       "  'last_name': 'Barrett',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1993, 8, 11),\n",
       "  'home_address': '7100 Scott Lake',\n",
       "  'home_city': 'Kristenstad',\n",
       "  'home_state': 'OK',\n",
       "  'home_zip': '09274',\n",
       "  'home_phone': '001-500-223-8945x457'},\n",
       " {'student_id': 234,\n",
       "  'first_name': 'Katelyn',\n",
       "  'last_name': 'Hoover',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1997, 12, 24),\n",
       "  'home_address': '9315 Christopher Road',\n",
       "  'home_city': 'Loriburgh',\n",
       "  'home_state': 'CA',\n",
       "  'home_zip': '75454',\n",
       "  'home_phone': '275.704.7134x661'},\n",
       " {'student_id': 235,\n",
       "  'first_name': 'Shannon',\n",
       "  'last_name': 'Williams',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2002, 7, 8),\n",
       "  'home_address': '08663 Kimberly Expressway Apt. 575',\n",
       "  'home_city': 'South Wyatt',\n",
       "  'home_state': 'AL',\n",
       "  'home_zip': '80993',\n",
       "  'home_phone': '314-058-0010'},\n",
       " {'student_id': 239,\n",
       "  'first_name': 'Yvette',\n",
       "  'last_name': 'Galloway',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2002, 7, 24),\n",
       "  'home_address': '12076 Anthony Square',\n",
       "  'home_city': 'Samueltown',\n",
       "  'home_state': 'NY',\n",
       "  'home_zip': '34260',\n",
       "  'home_phone': '(878)866-9801x91611'},\n",
       " {'student_id': 241,\n",
       "  'first_name': 'Sandra',\n",
       "  'last_name': 'Winters',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2005, 7, 31),\n",
       "  'home_address': '907 Mario Lodge Apt. 942',\n",
       "  'home_city': 'Shermanville',\n",
       "  'home_state': 'ND',\n",
       "  'home_zip': '45545',\n",
       "  'home_phone': '+1-753-365-4045'},\n",
       " {'student_id': 248,\n",
       "  'first_name': 'Richard',\n",
       "  'last_name': 'Noble',\n",
       "  'sex': 'M',\n",
       "  'date_of_birth': datetime.date(2003, 2, 5),\n",
       "  'home_address': '7977 Adams Crossroad Suite 214',\n",
       "  'home_city': 'Port Catherineland',\n",
       "  'home_state': 'UT',\n",
       "  'home_zip': '34911',\n",
       "  'home_phone': '458.117.5719'},\n",
       " {'student_id': 249,\n",
       "  'first_name': 'Ashley',\n",
       "  'last_name': 'Thomas',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1996, 8, 29),\n",
       "  'home_address': '241 Katie Fort Apt. 087',\n",
       "  'home_city': 'New Ebony',\n",
       "  'home_state': 'ME',\n",
       "  'home_zip': '26233',\n",
       "  'home_phone': '135-652-0859x3049'},\n",
       " {'student_id': 251,\n",
       "  'first_name': 'Ashley',\n",
       "  'last_name': 'Miller',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1988, 6, 13),\n",
       "  'home_address': '1805 Alexis Villages',\n",
       "  'home_city': 'Morrisonton',\n",
       "  'home_state': 'MD',\n",
       "  'home_zip': '93116',\n",
       "  'home_phone': '(263)336-5912'},\n",
       " {'student_id': 254,\n",
       "  'first_name': 'Deanna',\n",
       "  'last_name': 'Price',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1994, 11, 4),\n",
       "  'home_address': '120 Edwards Expressway Suite 511',\n",
       "  'home_city': 'Kathleenberg',\n",
       "  'home_state': 'CA',\n",
       "  'home_zip': '19876',\n",
       "  'home_phone': '001-940-447-1052x158'},\n",
       " {'student_id': 258,\n",
       "  'first_name': 'Julie',\n",
       "  'last_name': 'Jones',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2005, 8, 2),\n",
       "  'home_address': '35304 Rachel Meadows Suite 288',\n",
       "  'home_city': 'North Jeffreyberg',\n",
       "  'home_state': 'AZ',\n",
       "  'home_zip': '48886',\n",
       "  'home_phone': '141-934-7302x6340'},\n",
       " {'student_id': 259,\n",
       "  'first_name': 'Monica',\n",
       "  'last_name': 'Hill',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1992, 10, 18),\n",
       "  'home_address': '945 Angela Key',\n",
       "  'home_city': 'Johnchester',\n",
       "  'home_state': 'GA',\n",
       "  'home_zip': '23266',\n",
       "  'home_phone': '0750320331'},\n",
       " {'student_id': 260,\n",
       "  'first_name': 'Joanne',\n",
       "  'last_name': 'Williams',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2001, 2, 7),\n",
       "  'home_address': '85254 Janet Pines',\n",
       "  'home_city': 'Lake Daniel',\n",
       "  'home_state': 'AZ',\n",
       "  'home_zip': '34031',\n",
       "  'home_phone': '623.410.2275'},\n",
       " {'student_id': 262,\n",
       "  'first_name': 'Debra',\n",
       "  'last_name': 'Riggs',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2002, 5, 3),\n",
       "  'home_address': '090 Andrew Mountains Apt. 054',\n",
       "  'home_city': 'New Amandachester',\n",
       "  'home_state': 'WA',\n",
       "  'home_zip': '61679',\n",
       "  'home_phone': '001-635-536-1950x612'},\n",
       " {'student_id': 264,\n",
       "  'first_name': 'Heidi',\n",
       "  'last_name': 'Charles',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1990, 3, 15),\n",
       "  'home_address': '927 Chandler Groves Suite 929',\n",
       "  'home_city': 'Leeville',\n",
       "  'home_state': 'MA',\n",
       "  'home_zip': '27167',\n",
       "  'home_phone': '(160)618-6264x340'},\n",
       " {'student_id': 266,\n",
       "  'first_name': 'Valerie',\n",
       "  'last_name': 'Smith',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1989, 1, 22),\n",
       "  'home_address': '4709 Patrick Wall',\n",
       "  'home_city': 'West Ericview',\n",
       "  'home_state': 'AL',\n",
       "  'home_zip': '73935',\n",
       "  'home_phone': '(783)138-7164'},\n",
       " {'student_id': 268,\n",
       "  'first_name': 'Debra',\n",
       "  'last_name': 'Schmitt',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1992, 12, 22),\n",
       "  'home_address': '74229 James Hills Apt. 780',\n",
       "  'home_city': 'East Kristina',\n",
       "  'home_state': 'IN',\n",
       "  'home_zip': '43119',\n",
       "  'home_phone': '516.311.9867'},\n",
       " {'student_id': 269,\n",
       "  'first_name': 'Veronica',\n",
       "  'last_name': 'Anderson',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1997, 5, 19),\n",
       "  'home_address': '0043 Baker Springs',\n",
       "  'home_city': 'Kristinaton',\n",
       "  'home_state': 'UT',\n",
       "  'home_zip': '04908',\n",
       "  'home_phone': '(811)585-2197x666'},\n",
       " {'student_id': 271,\n",
       "  'first_name': 'Elizabeth',\n",
       "  'last_name': 'Brock',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1987, 3, 6),\n",
       "  'home_address': '8230 Mitchell Extension Apt. 275',\n",
       "  'home_city': 'Port Anthony',\n",
       "  'home_state': 'CA',\n",
       "  'home_zip': '31032',\n",
       "  'home_phone': '190-577-0466x2936'},\n",
       " {'student_id': 273,\n",
       "  'first_name': 'Brenda',\n",
       "  'last_name': 'Lynch',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2002, 9, 10),\n",
       "  'home_address': '11630 Jeremy Mountains',\n",
       "  'home_city': 'Austinchester',\n",
       "  'home_state': 'SC',\n",
       "  'home_zip': '45091',\n",
       "  'home_phone': '(460)652-5911x142'},\n",
       " {'student_id': 275,\n",
       "  'first_name': 'Diane',\n",
       "  'last_name': 'Walker',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2002, 6, 22),\n",
       "  'home_address': '929 Olivia Turnpike',\n",
       "  'home_city': 'Lake Keithport',\n",
       "  'home_state': 'DE',\n",
       "  'home_zip': '11107',\n",
       "  'home_phone': '1672377368'},\n",
       " {'student_id': 276,\n",
       "  'first_name': 'Sara',\n",
       "  'last_name': 'Murphy',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1987, 7, 5),\n",
       "  'home_address': '178 Smith Prairie',\n",
       "  'home_city': 'West Allison',\n",
       "  'home_state': 'ND',\n",
       "  'home_zip': '93840',\n",
       "  'home_phone': '610.384.6473x01662'},\n",
       " {'student_id': 278,\n",
       "  'first_name': 'Shannon',\n",
       "  'last_name': 'Mayer',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1997, 4, 10),\n",
       "  'home_address': '8730 Derrick Mews Suite 666',\n",
       "  'home_city': 'Craneborough',\n",
       "  'home_state': 'NV',\n",
       "  'home_zip': '24146',\n",
       "  'home_phone': '001-006-189-0389x612'},\n",
       " {'student_id': 279,\n",
       "  'first_name': 'Crystal',\n",
       "  'last_name': 'Parker',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2001, 11, 28),\n",
       "  'home_address': '1314 Jessica Causeway',\n",
       "  'home_city': 'Port Stephen',\n",
       "  'home_state': 'GA',\n",
       "  'home_zip': '98006',\n",
       "  'home_phone': '(321)139-5367'},\n",
       " {'student_id': 280,\n",
       "  'first_name': 'Tamara',\n",
       "  'last_name': 'Walter',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2001, 8, 18),\n",
       "  'home_address': '136 Garrison Prairie Apt. 775',\n",
       "  'home_city': 'South Sara',\n",
       "  'home_state': 'IN',\n",
       "  'home_zip': '72450',\n",
       "  'home_phone': '+1-823-985-9579x9827'},\n",
       " {'student_id': 281,\n",
       "  'first_name': 'Amber',\n",
       "  'last_name': 'Benson',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1988, 3, 21),\n",
       "  'home_address': '90660 Hamilton Orchard Apt. 932',\n",
       "  'home_city': 'Matthewstown',\n",
       "  'home_state': 'OK',\n",
       "  'home_zip': '20573',\n",
       "  'home_phone': '001-513-126-8556x683'},\n",
       " {'student_id': 282,\n",
       "  'first_name': 'Colleen',\n",
       "  'last_name': 'Barnes',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1992, 1, 19),\n",
       "  'home_address': '959 Lin Common Apt. 811',\n",
       "  'home_city': 'Port Phillip',\n",
       "  'home_state': 'MO',\n",
       "  'home_zip': '72239',\n",
       "  'home_phone': '341.284.4253x580'},\n",
       " {'student_id': 283,\n",
       "  'first_name': 'Paula',\n",
       "  'last_name': 'Clark',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2005, 9, 30),\n",
       "  'home_address': '49434 Robert Shore',\n",
       "  'home_city': 'Ortizport',\n",
       "  'home_state': 'MI',\n",
       "  'home_zip': '20527',\n",
       "  'home_phone': '664-842-9310'},\n",
       " {'student_id': 284,\n",
       "  'first_name': 'Jennifer',\n",
       "  'last_name': 'Cole',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1986, 11, 18),\n",
       "  'home_address': '821 Kline Valleys Apt. 697',\n",
       "  'home_city': 'South Jamesfort',\n",
       "  'home_state': 'WI',\n",
       "  'home_zip': '57201',\n",
       "  'home_phone': '8222564998'},\n",
       " {'student_id': 286,\n",
       "  'first_name': 'Angela',\n",
       "  'last_name': 'Hill',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2000, 7, 2),\n",
       "  'home_address': '126 Collins Neck',\n",
       "  'home_city': 'Seanfurt',\n",
       "  'home_state': 'CT',\n",
       "  'home_zip': '98022',\n",
       "  'home_phone': '213-109-1553x39625'},\n",
       " {'student_id': 287,\n",
       "  'first_name': 'Mrs.',\n",
       "  'last_name': 'Lisa',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1994, 10, 16),\n",
       "  'home_address': '2117 Walls Harbor Suite 967',\n",
       "  'home_city': 'Lake Anthony',\n",
       "  'home_state': 'WI',\n",
       "  'home_zip': '41121',\n",
       "  'home_phone': '+1-886-620-3505'},\n",
       " {'student_id': 288,\n",
       "  'first_name': 'Olivia',\n",
       "  'last_name': 'Martinez',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2001, 6, 25),\n",
       "  'home_address': '0897 Brian Union',\n",
       "  'home_city': 'Fosterfurt',\n",
       "  'home_state': 'ND',\n",
       "  'home_zip': '42558',\n",
       "  'home_phone': '8320317842'},\n",
       " {'student_id': 289,\n",
       "  'first_name': 'Alyssa',\n",
       "  'last_name': 'Oliver',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1999, 7, 30),\n",
       "  'home_address': '979 Daisy Cliffs',\n",
       "  'home_city': 'Maureenside',\n",
       "  'home_state': 'NY',\n",
       "  'home_zip': '41650',\n",
       "  'home_phone': '(927)504-5856'},\n",
       " {'student_id': 290,\n",
       "  'first_name': 'Barbara',\n",
       "  'last_name': 'Hicks',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2003, 2, 14),\n",
       "  'home_address': '06525 Coleman Via',\n",
       "  'home_city': 'Port Vanessatown',\n",
       "  'home_state': 'DC',\n",
       "  'home_zip': '80068',\n",
       "  'home_phone': '(403)892-5401x1797'},\n",
       " {'student_id': 291,\n",
       "  'first_name': 'Shari',\n",
       "  'last_name': 'Rodriguez',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2002, 4, 7),\n",
       "  'home_address': '14993 Reeves Cove',\n",
       "  'home_city': 'East Frederick',\n",
       "  'home_state': 'MN',\n",
       "  'home_zip': '14832',\n",
       "  'home_phone': '436.215.4569x041'},\n",
       " {'student_id': 292,\n",
       "  'first_name': 'Wendy',\n",
       "  'last_name': 'Mathews',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2003, 12, 13),\n",
       "  'home_address': '8728 Jamie Courts',\n",
       "  'home_city': 'New Leefort',\n",
       "  'home_state': 'AL',\n",
       "  'home_zip': '66380',\n",
       "  'home_phone': '+1-716-103-4197x654'},\n",
       " {'student_id': 296,\n",
       "  'first_name': 'Michelle',\n",
       "  'last_name': 'George',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(1994, 1, 2),\n",
       "  'home_address': '56285 Stephanie Wall Suite 800',\n",
       "  'home_city': 'Vazquezside',\n",
       "  'home_state': 'AR',\n",
       "  'home_zip': '02142',\n",
       "  'home_phone': '(683)009-1622x26181'},\n",
       " {'student_id': 298,\n",
       "  'first_name': 'Christine',\n",
       "  'last_name': 'Johnson',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2003, 2, 14),\n",
       "  'home_address': '4725 Petersen Via',\n",
       "  'home_city': 'Clarkburgh',\n",
       "  'home_state': 'NC',\n",
       "  'home_zip': '75437',\n",
       "  'home_phone': '+1-281-129-5589x225'},\n",
       " {'student_id': 299,\n",
       "  'first_name': 'Lisa',\n",
       "  'last_name': 'Sheppard',\n",
       "  'sex': 'F',\n",
       "  'date_of_birth': datetime.date(2004, 4, 2),\n",
       "  'home_address': '95923 Reynolds Fork Suite 719',\n",
       "  'home_city': 'West Laura',\n",
       "  'home_state': 'LA',\n",
       "  'home_zip': '23546',\n",
       "  'home_phone': '001-842-369-3244x325'}]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "female_texans.fetch(as_dict=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>first_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>sex</th>\n",
       "      <th>date_of_birth</th>\n",
       "      <th>home_address</th>\n",
       "      <th>home_city</th>\n",
       "      <th>home_state</th>\n",
       "      <th>home_zip</th>\n",
       "      <th>home_phone</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>student_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Jillian</td>\n",
       "      <td>Fischer</td>\n",
       "      <td>F</td>\n",
       "      <td>2000-12-14</td>\n",
       "      <td>68627 Rodriguez Center Suite 032</td>\n",
       "      <td>East Anthony</td>\n",
       "      <td>WY</td>\n",
       "      <td>64660</td>\n",
       "      <td>+1-837-213-8181x775</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Danielle</td>\n",
       "      <td>Mccann</td>\n",
       "      <td>F</td>\n",
       "      <td>2001-07-10</td>\n",
       "      <td>459 Watts Path Suite 309</td>\n",
       "      <td>Lake Charles</td>\n",
       "      <td>PA</td>\n",
       "      <td>42226</td>\n",
       "      <td>2367757570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Mackenzie</td>\n",
       "      <td>Boyer</td>\n",
       "      <td>F</td>\n",
       "      <td>1988-12-26</td>\n",
       "      <td>9458 Ashley Stravenue Apt. 044</td>\n",
       "      <td>Port Melissaland</td>\n",
       "      <td>OH</td>\n",
       "      <td>54499</td>\n",
       "      <td>669-684-3236</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Jacqueline</td>\n",
       "      <td>Colon</td>\n",
       "      <td>F</td>\n",
       "      <td>1996-02-24</td>\n",
       "      <td>64635 Duncan Place</td>\n",
       "      <td>Solisburgh</td>\n",
       "      <td>UT</td>\n",
       "      <td>76301</td>\n",
       "      <td>(983)027-5735x055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Nicole</td>\n",
       "      <td>Long</td>\n",
       "      <td>F</td>\n",
       "      <td>1986-10-24</td>\n",
       "      <td>804 Sarah Rue Suite 661</td>\n",
       "      <td>Port Kristinamouth</td>\n",
       "      <td>ND</td>\n",
       "      <td>07732</td>\n",
       "      <td>568-928-6900x28524</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291</th>\n",
       "      <td>Shari</td>\n",
       "      <td>Rodriguez</td>\n",
       "      <td>F</td>\n",
       "      <td>2002-04-07</td>\n",
       "      <td>14993 Reeves Cove</td>\n",
       "      <td>East Frederick</td>\n",
       "      <td>MN</td>\n",
       "      <td>14832</td>\n",
       "      <td>436.215.4569x041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>292</th>\n",
       "      <td>Wendy</td>\n",
       "      <td>Mathews</td>\n",
       "      <td>F</td>\n",
       "      <td>2003-12-13</td>\n",
       "      <td>8728 Jamie Courts</td>\n",
       "      <td>New Leefort</td>\n",
       "      <td>AL</td>\n",
       "      <td>66380</td>\n",
       "      <td>+1-716-103-4197x654</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296</th>\n",
       "      <td>Michelle</td>\n",
       "      <td>George</td>\n",
       "      <td>F</td>\n",
       "      <td>1994-01-02</td>\n",
       "      <td>56285 Stephanie Wall Suite 800</td>\n",
       "      <td>Vazquezside</td>\n",
       "      <td>AR</td>\n",
       "      <td>02142</td>\n",
       "      <td>(683)009-1622x26181</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>Christine</td>\n",
       "      <td>Johnson</td>\n",
       "      <td>F</td>\n",
       "      <td>2003-02-14</td>\n",
       "      <td>4725 Petersen Via</td>\n",
       "      <td>Clarkburgh</td>\n",
       "      <td>NC</td>\n",
       "      <td>75437</td>\n",
       "      <td>+1-281-129-5589x225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>Lisa</td>\n",
       "      <td>Sheppard</td>\n",
       "      <td>F</td>\n",
       "      <td>2004-04-02</td>\n",
       "      <td>95923 Reynolds Fork Suite 719</td>\n",
       "      <td>West Laura</td>\n",
       "      <td>LA</td>\n",
       "      <td>23546</td>\n",
       "      <td>001-842-369-3244x325</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>152 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            first_name  last_name sex date_of_birth  \\\n",
       "student_id                                            \n",
       "0              Jillian    Fischer   F    2000-12-14   \n",
       "1             Danielle     Mccann   F    2001-07-10   \n",
       "5            Mackenzie      Boyer   F    1988-12-26   \n",
       "8           Jacqueline      Colon   F    1996-02-24   \n",
       "9               Nicole       Long   F    1986-10-24   \n",
       "...                ...        ...  ..           ...   \n",
       "291              Shari  Rodriguez   F    2002-04-07   \n",
       "292              Wendy    Mathews   F    2003-12-13   \n",
       "296           Michelle     George   F    1994-01-02   \n",
       "298          Christine    Johnson   F    2003-02-14   \n",
       "299               Lisa   Sheppard   F    2004-04-02   \n",
       "\n",
       "                                home_address           home_city home_state  \\\n",
       "student_id                                                                    \n",
       "0           68627 Rodriguez Center Suite 032        East Anthony         WY   \n",
       "1                   459 Watts Path Suite 309        Lake Charles         PA   \n",
       "5             9458 Ashley Stravenue Apt. 044    Port Melissaland         OH   \n",
       "8                         64635 Duncan Place          Solisburgh         UT   \n",
       "9                    804 Sarah Rue Suite 661  Port Kristinamouth         ND   \n",
       "...                                      ...                 ...        ...   \n",
       "291                        14993 Reeves Cove      East Frederick         MN   \n",
       "292                        8728 Jamie Courts         New Leefort         AL   \n",
       "296           56285 Stephanie Wall Suite 800         Vazquezside         AR   \n",
       "298                        4725 Petersen Via          Clarkburgh         NC   \n",
       "299            95923 Reynolds Fork Suite 719          West Laura         LA   \n",
       "\n",
       "           home_zip            home_phone  \n",
       "student_id                                 \n",
       "0             64660   +1-837-213-8181x775  \n",
       "1             42226            2367757570  \n",
       "5             54499          669-684-3236  \n",
       "8             76301     (983)027-5735x055  \n",
       "9             07732    568-928-6900x28524  \n",
       "...             ...                   ...  \n",
       "291           14832      436.215.4569x041  \n",
       "292           66380   +1-716-103-4197x654  \n",
       "296           02142   (683)009-1622x26181  \n",
       "298           75437   +1-281-129-5589x225  \n",
       "299           23546  001-842-369-3244x325  \n",
       "\n",
       "[152 rows x 9 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "female_texans.fetch(format=\"frame\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "152"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(female_texans)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "utahns = Student & {'home_state': 'UT'}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "utah_genz = utahns & 'date_of_birth > \"1989-01-01\"'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "    \n",
       "    <style type=\"text/css\">\n",
       "        .Relation{\n",
       "            border-collapse:collapse;\n",
       "        }\n",
       "        .Relation th{\n",
       "            background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "            font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "        }\n",
       "        .Relation td{\n",
       "            padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "        }\n",
       "        .Relation tr:nth-child(odd){\n",
       "            background: #ffffff;\n",
       "        }\n",
       "        .Relation tr:nth-child(even){\n",
       "            background: #f3f1ff;\n",
       "        }\n",
       "        /* Tooltip container */\n",
       "        .djtooltip {\n",
       "        }\n",
       "        /* Tooltip text */\n",
       "        .djtooltip .djtooltiptext {\n",
       "            visibility: hidden;\n",
       "            width: 120px;\n",
       "            background-color: black;\n",
       "            color: #fff;\n",
       "            text-align: center;\n",
       "            padding: 5px 0;\n",
       "            border-radius: 6px;\n",
       "            /* Position the tooltip text - see examples below! */\n",
       "            position: absolute;\n",
       "            z-index: 1;\n",
       "        }\n",
       "        #primary {\n",
       "            font-weight: bold;\n",
       "            color: black;\n",
       "        }\n",
       "        #nonprimary {\n",
       "            font-weight: normal;\n",
       "            color: white;\n",
       "        }\n",
       "\n",
       "        /* Show the tooltip text when you mouse over the tooltip container */\n",
       "        .djtooltip:hover .djtooltiptext {\n",
       "            visibility: visible;\n",
       "        }\n",
       "    </style>\n",
       "    \n",
       "    <b></b>\n",
       "        <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "        <table border=\"1\" class=\"Relation\">\n",
       "            <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                            <p id=\"primary\">student_id</p>\n",
       "                            <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">first_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">last_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">sex</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">date_of_birth</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_address</p>\n",
       "                            <span class=\"djtooltiptext\">mailing street address</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_city</p>\n",
       "                            <span class=\"djtooltiptext\">mailing address</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_state</p>\n",
       "                            <span class=\"djtooltiptext\">US state acronym: e.g. OH</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_zip</p>\n",
       "                            <span class=\"djtooltiptext\">zipcode e.g. 93979-4979</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_phone</p>\n",
       "                            <span class=\"djtooltiptext\">e.g. 414.657.6883x0881</span>\n",
       "                        </div> </th> </tr> </thead>\n",
       "            <tbody> <tr> <td>8</td>\n",
       "<td>Jacqueline</td>\n",
       "<td>Colon</td>\n",
       "<td>F</td>\n",
       "<td>1996-02-24</td>\n",
       "<td>64635 Duncan Place</td>\n",
       "<td>Solisburgh</td>\n",
       "<td>UT</td>\n",
       "<td>76301</td>\n",
       "<td>(983)027-5735x055</td></tr><tr><td>210</td>\n",
       "<td>Paula</td>\n",
       "<td>Perez</td>\n",
       "<td>F</td>\n",
       "<td>2000-08-15</td>\n",
       "<td>17911 Frazier Roads</td>\n",
       "<td>Port Tasha</td>\n",
       "<td>UT</td>\n",
       "<td>21725</td>\n",
       "<td>405.906.1669</td></tr><tr><td>248</td>\n",
       "<td>Richard</td>\n",
       "<td>Noble</td>\n",
       "<td>M</td>\n",
       "<td>2003-02-05</td>\n",
       "<td>7977 Adams Crossroad Suite 214</td>\n",
       "<td>Port Catherineland</td>\n",
       "<td>UT</td>\n",
       "<td>34911</td>\n",
       "<td>458.117.5719</td></tr><tr><td>269</td>\n",
       "<td>Veronica</td>\n",
       "<td>Anderson</td>\n",
       "<td>F</td>\n",
       "<td>1997-05-19</td>\n",
       "<td>0043 Baker Springs</td>\n",
       "<td>Kristinaton</td>\n",
       "<td>UT</td>\n",
       "<td>04908</td>\n",
       "<td>(811)585-2197x666</td> </tr> </tbody>\n",
       "        </table>\n",
       "        \n",
       "        <p>Total: 4</p></div>\n",
       "        "
      ],
      "text/plain": [
       "*student_id    first_name     last_name     sex     date_of_birth  home_address   home_city      home_state     home_zip     home_phone    \n",
       "+------------+ +------------+ +-----------+ +-----+ +------------+ +------------+ +------------+ +------------+ +----------+ +------------+\n",
       "8              Jacqueline     Colon         F       1996-02-24     64635 Duncan P Solisburgh     UT             76301        (983)027-5735x\n",
       "210            Paula          Perez         F       2000-08-15     17911 Frazier  Port Tasha     UT             21725        405.906.1669  \n",
       "248            Richard        Noble         M       2003-02-05     7977 Adams Cro Port Catherine UT             34911        458.117.5719  \n",
       "269            Veronica       Anderson      F       1997-05-19     0043 Baker Spr Kristinaton    UT             04908        (811)585-2197x\n",
       " (Total: 4)"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "utah_genz"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "    \n",
       "    <style type=\"text/css\">\n",
       "        .Relation{\n",
       "            border-collapse:collapse;\n",
       "        }\n",
       "        .Relation th{\n",
       "            background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "            font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "        }\n",
       "        .Relation td{\n",
       "            padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "        }\n",
       "        .Relation tr:nth-child(odd){\n",
       "            background: #ffffff;\n",
       "        }\n",
       "        .Relation tr:nth-child(even){\n",
       "            background: #f3f1ff;\n",
       "        }\n",
       "        /* Tooltip container */\n",
       "        .djtooltip {\n",
       "        }\n",
       "        /* Tooltip text */\n",
       "        .djtooltip .djtooltiptext {\n",
       "            visibility: hidden;\n",
       "            width: 120px;\n",
       "            background-color: black;\n",
       "            color: #fff;\n",
       "            text-align: center;\n",
       "            padding: 5px 0;\n",
       "            border-radius: 6px;\n",
       "            /* Position the tooltip text - see examples below! */\n",
       "            position: absolute;\n",
       "            z-index: 1;\n",
       "        }\n",
       "        #primary {\n",
       "            font-weight: bold;\n",
       "            color: black;\n",
       "        }\n",
       "        #nonprimary {\n",
       "            font-weight: normal;\n",
       "            color: white;\n",
       "        }\n",
       "\n",
       "        /* Show the tooltip text when you mouse over the tooltip container */\n",
       "        .djtooltip:hover .djtooltiptext {\n",
       "            visibility: visible;\n",
       "        }\n",
       "    </style>\n",
       "    \n",
       "    <b></b>\n",
       "        <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "        <table border=\"1\" class=\"Relation\">\n",
       "            <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                            <p id=\"primary\">student_id</p>\n",
       "                            <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">first_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">last_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">sex</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">date_of_birth</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_address</p>\n",
       "                            <span class=\"djtooltiptext\">mailing street address</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_city</p>\n",
       "                            <span class=\"djtooltiptext\">mailing address</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_state</p>\n",
       "                            <span class=\"djtooltiptext\">US state acronym: e.g. OH</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_zip</p>\n",
       "                            <span class=\"djtooltiptext\">zipcode e.g. 93979-4979</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_phone</p>\n",
       "                            <span class=\"djtooltiptext\">e.g. 414.657.6883x0881</span>\n",
       "                        </div> </th> </tr> </thead>\n",
       "            <tbody> <tr> <td>8</td>\n",
       "<td>Jacqueline</td>\n",
       "<td>Colon</td>\n",
       "<td>F</td>\n",
       "<td>1996-02-24</td>\n",
       "<td>64635 Duncan Place</td>\n",
       "<td>Solisburgh</td>\n",
       "<td>UT</td>\n",
       "<td>76301</td>\n",
       "<td>(983)027-5735x055</td></tr><tr><td>210</td>\n",
       "<td>Paula</td>\n",
       "<td>Perez</td>\n",
       "<td>F</td>\n",
       "<td>2000-08-15</td>\n",
       "<td>17911 Frazier Roads</td>\n",
       "<td>Port Tasha</td>\n",
       "<td>UT</td>\n",
       "<td>21725</td>\n",
       "<td>405.906.1669</td></tr><tr><td>248</td>\n",
       "<td>Richard</td>\n",
       "<td>Noble</td>\n",
       "<td>M</td>\n",
       "<td>2003-02-05</td>\n",
       "<td>7977 Adams Crossroad Suite 214</td>\n",
       "<td>Port Catherineland</td>\n",
       "<td>UT</td>\n",
       "<td>34911</td>\n",
       "<td>458.117.5719</td></tr><tr><td>269</td>\n",
       "<td>Veronica</td>\n",
       "<td>Anderson</td>\n",
       "<td>F</td>\n",
       "<td>1997-05-19</td>\n",
       "<td>0043 Baker Springs</td>\n",
       "<td>Kristinaton</td>\n",
       "<td>UT</td>\n",
       "<td>04908</td>\n",
       "<td>(811)585-2197x666</td> </tr> </tbody>\n",
       "        </table>\n",
       "        \n",
       "        <p>Total: 4</p></div>\n",
       "        "
      ],
      "text/plain": [
       "*student_id    first_name     last_name     sex     date_of_birth  home_address   home_city      home_state     home_zip     home_phone    \n",
       "+------------+ +------------+ +-----------+ +-----+ +------------+ +------------+ +------------+ +------------+ +----------+ +------------+\n",
       "8              Jacqueline     Colon         F       1996-02-24     64635 Duncan P Solisburgh     UT             76301        (983)027-5735x\n",
       "210            Paula          Perez         F       2000-08-15     17911 Frazier  Port Tasha     UT             21725        405.906.1669  \n",
       "248            Richard        Noble         M       2003-02-05     7977 Adams Cro Port Catherine UT             34911        458.117.5719  \n",
       "269            Veronica       Anderson      F       1997-05-19     0043 Baker Spr Kristinaton    UT             04908        (811)585-2197x\n",
       " (Total: 4)"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "utah_genz"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'name': 'student',\n",
       " 'engine': 'InnoDB',\n",
       " 'version': 10,\n",
       " 'row_format': 'Dynamic',\n",
       " 'rows': 0,\n",
       " 'avg_row_length': 0,\n",
       " 'data_length': 16384,\n",
       " 'max_data_length': 0,\n",
       " 'index_length': 0,\n",
       " 'data_free': 0,\n",
       " 'auto_increment': None,\n",
       " 'create_time': datetime.datetime(2020, 10, 27, 9, 45, 43),\n",
       " 'update_time': None,\n",
       " 'check_time': None,\n",
       " 'collation': 'latin1_swedish_ci',\n",
       " 'checksum': None,\n",
       " 'create_options': '',\n",
       " 'comment': ''}"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "utah_genz.heading.table_status"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "    \n",
       "    <style type=\"text/css\">\n",
       "        .Relation{\n",
       "            border-collapse:collapse;\n",
       "        }\n",
       "        .Relation th{\n",
       "            background: #A0A0A0; color: #ffffff; padding:4px; border:#f0e0e0 1px solid;\n",
       "            font-weight: normal; font-family: monospace; font-size: 100%;\n",
       "        }\n",
       "        .Relation td{\n",
       "            padding:4px; border:#f0e0e0 1px solid; font-size:100%;\n",
       "        }\n",
       "        .Relation tr:nth-child(odd){\n",
       "            background: #ffffff;\n",
       "        }\n",
       "        .Relation tr:nth-child(even){\n",
       "            background: #f3f1ff;\n",
       "        }\n",
       "        /* Tooltip container */\n",
       "        .djtooltip {\n",
       "        }\n",
       "        /* Tooltip text */\n",
       "        .djtooltip .djtooltiptext {\n",
       "            visibility: hidden;\n",
       "            width: 120px;\n",
       "            background-color: black;\n",
       "            color: #fff;\n",
       "            text-align: center;\n",
       "            padding: 5px 0;\n",
       "            border-radius: 6px;\n",
       "            /* Position the tooltip text - see examples below! */\n",
       "            position: absolute;\n",
       "            z-index: 1;\n",
       "        }\n",
       "        #primary {\n",
       "            font-weight: bold;\n",
       "            color: black;\n",
       "        }\n",
       "        #nonprimary {\n",
       "            font-weight: normal;\n",
       "            color: white;\n",
       "        }\n",
       "\n",
       "        /* Show the tooltip text when you mouse over the tooltip container */\n",
       "        .djtooltip:hover .djtooltiptext {\n",
       "            visibility: visible;\n",
       "        }\n",
       "    </style>\n",
       "    \n",
       "    \n",
       "        <div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "        <table border=\"1\" class=\"Relation\">\n",
       "            <thead> <tr style=\"text-align: right;\"> <th> <div class=\"djtooltip\">\n",
       "                            <p id=\"primary\">student_id</p>\n",
       "                            <span class=\"djtooltiptext\">university-wide ID number</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">last_name</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">sex</p>\n",
       "                            <span class=\"djtooltiptext\"></span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_city</p>\n",
       "                            <span class=\"djtooltiptext\">mailing address</span>\n",
       "                        </div></th><th><div class=\"djtooltip\">\n",
       "                            <p id=\"nonprimary\">home_state</p>\n",
       "                            <span class=\"djtooltiptext\">US state acronym: e.g. OH</span>\n",
       "                        </div> </th> </tr> </thead>\n",
       "            <tbody> <tr> <td>8</td>\n",
       "<td>Colon</td>\n",
       "<td>F</td>\n",
       "<td>Solisburgh</td>\n",
       "<td>UT</td></tr><tr><td>210</td>\n",
       "<td>Perez</td>\n",
       "<td>F</td>\n",
       "<td>Port Tasha</td>\n",
       "<td>UT</td></tr><tr><td>248</td>\n",
       "<td>Noble</td>\n",
       "<td>M</td>\n",
       "<td>Port Catherineland</td>\n",
       "<td>UT</td></tr><tr><td>269</td>\n",
       "<td>Anderson</td>\n",
       "<td>F</td>\n",
       "<td>Kristinaton</td>\n",
       "<td>UT</td> </tr> </tbody>\n",
       "        </table>\n",
       "        \n",
       "        <p>Total: 4</p></div>\n",
       "        "
      ],
      "text/plain": [
       "*student_id    last_name     sex     home_city      home_state    \n",
       "+------------+ +-----------+ +-----+ +------------+ +------------+\n",
       "8              Colon         F       Solisburgh     UT            \n",
       "210            Perez         F       Port Tasha     UT            \n",
       "248            Noble         M       Port Catherine UT            \n",
       "269            Anderson      F       Kristinaton    UT            \n",
       " (Total: 4)"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "utah_genz = utah_genz.proj('last_name', 'home_city','home_state','sex')\n",
    "utah_genz"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['student_id', 'last_name', 'sex', 'home_city', 'home_state']"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "utah_genz.heading.non_blobs"
   ]
  }
 ],
 "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}