Skip to content

Instantly share code, notes, and snippets.

@glamp

glamp/db.py.ipynb

Created October 26, 2014 18:02
Show Gist options
  • Save glamp/3fa8032499b6db007f0f to your computer and use it in GitHub Desktop.
Save glamp/3fa8032499b6db007f0f to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
db.py.ipynb
{
"metadata": {
"name": "",
"signature": "sha256:9f04c02543c2721beea538598849f7ba7454ca0ee142794537ede86cb1f68a08"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "code",
"collapsed": false,
"input": [
"from db import DB\n",
"\n",
"db = DB(filename=\"./baseball-archive-2012.sqlite\", dbtype=\"sqlite\")\n",
"db"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stderr",
"text": [
"Indexing schema. This will take a second...finished!\n"
]
},
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 1,
"text": [
"DB[sqlite][localhost]:5432 > None@None"
]
}
],
"prompt_number": 1
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"db.tables.allstarfull"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<table>\n",
" <tr>\n",
" <th>Column</th>\n",
" <th>Type</th>\n",
" </tr>\n",
" <tr>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>gameNum</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>gameID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teamID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>lgID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>GP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>startingPos</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
"</table>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 2,
"text": [
"+-----------------------+\n",
"| allstarfull |\n",
"+-------------+---------+\n",
"| Column | Type |\n",
"+-------------+---------+\n",
"| playerID | TEXT |\n",
"| yearID | INTEGER |\n",
"| gameNum | INTEGER |\n",
"| gameID | TEXT |\n",
"| teamID | TEXT |\n",
"| lgID | TEXT |\n",
"| GP | INTEGER |\n",
"| startingPos | INTEGER |\n",
"+-------------+---------+"
]
}
],
"prompt_number": 2
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"db.tables.allstarfull.head()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>playerID</th>\n",
" <th>yearID</th>\n",
" <th>gameNum</th>\n",
" <th>gameID</th>\n",
" <th>teamID</th>\n",
" <th>lgID</th>\n",
" <th>GP</th>\n",
" <th>startingPos</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td> aaronha01</td>\n",
" <td> 1955</td>\n",
" <td> 0</td>\n",
" <td> NLS195507120</td>\n",
" <td> ML1</td>\n",
" <td> NL</td>\n",
" <td> 1</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td> aaronha01</td>\n",
" <td> 1956</td>\n",
" <td> 0</td>\n",
" <td> ALS195607100</td>\n",
" <td> ML1</td>\n",
" <td> NL</td>\n",
" <td> 1</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td> aaronha01</td>\n",
" <td> 1957</td>\n",
" <td> 0</td>\n",
" <td> NLS195707090</td>\n",
" <td> ML1</td>\n",
" <td> NL</td>\n",
" <td> 1</td>\n",
" <td> 9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td> aaronha01</td>\n",
" <td> 1958</td>\n",
" <td> 0</td>\n",
" <td> ALS195807080</td>\n",
" <td> ML1</td>\n",
" <td> NL</td>\n",
" <td> 1</td>\n",
" <td> 9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td> aaronha01</td>\n",
" <td> 1959</td>\n",
" <td> 1</td>\n",
" <td> NLS195907070</td>\n",
" <td> ML1</td>\n",
" <td> NL</td>\n",
" <td> 1</td>\n",
" <td> 9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td> aaronha01</td>\n",
" <td> 1959</td>\n",
" <td> 2</td>\n",
" <td> NLS195908030</td>\n",
" <td> ML1</td>\n",
" <td> NL</td>\n",
" <td> 1</td>\n",
" <td> 9</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 3,
"text": [
" playerID yearID gameNum gameID teamID lgID GP startingPos\n",
"0 aaronha01 1955 0 NLS195507120 ML1 NL 1 NaN\n",
"1 aaronha01 1956 0 ALS195607100 ML1 NL 1 NaN\n",
"2 aaronha01 1957 0 NLS195707090 ML1 NL 1 9\n",
"3 aaronha01 1958 0 ALS195807080 ML1 NL 1 9\n",
"4 aaronha01 1959 1 NLS195907070 ML1 NL 1 9\n",
"5 aaronha01 1959 2 NLS195908030 ML1 NL 1 9"
]
}
],
"prompt_number": 3
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"db.tables.allstarfull.sample()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>playerID</th>\n",
" <th>yearID</th>\n",
" <th>gameNum</th>\n",
" <th>gameID</th>\n",
" <th>teamID</th>\n",
" <th>lgID</th>\n",
" <th>GP</th>\n",
" <th>startingPos</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td> kellech01</td>\n",
" <td> 1941</td>\n",
" <td> 0</td>\n",
" <td> ALS194107080</td>\n",
" <td> NYA</td>\n",
" <td> AL</td>\n",
" <td> 1</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td> burdele01</td>\n",
" <td> 1959</td>\n",
" <td> 1</td>\n",
" <td> NLS195907070</td>\n",
" <td> ML1</td>\n",
" <td> NL</td>\n",
" <td> 1</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td> vaughar01</td>\n",
" <td> 1936</td>\n",
" <td> 0</td>\n",
" <td> NLS193607070</td>\n",
" <td> PIT</td>\n",
" <td> NL</td>\n",
" <td> 0</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td> benchjo01</td>\n",
" <td> 1969</td>\n",
" <td> 0</td>\n",
" <td> ALS196907230</td>\n",
" <td> CIN</td>\n",
" <td> NL</td>\n",
" <td> 1</td>\n",
" <td> 2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td> reesepe01</td>\n",
" <td> 1951</td>\n",
" <td> 0</td>\n",
" <td> ALS195107100</td>\n",
" <td> BRO</td>\n",
" <td> NL</td>\n",
" <td> 1</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td> glavito02</td>\n",
" <td> 2002</td>\n",
" <td> 0</td>\n",
" <td> NLS200207090</td>\n",
" <td> ATL</td>\n",
" <td> NL</td>\n",
" <td> 0</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td> dimagjo01</td>\n",
" <td> 1939</td>\n",
" <td> 0</td>\n",
" <td> ALS193907110</td>\n",
" <td> NYA</td>\n",
" <td> AL</td>\n",
" <td> 1</td>\n",
" <td> 8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td> harrebu01</td>\n",
" <td> 1971</td>\n",
" <td> 0</td>\n",
" <td> ALS197107130</td>\n",
" <td> NYN</td>\n",
" <td> NL</td>\n",
" <td> 1</td>\n",
" <td> 6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td> truckvi01</td>\n",
" <td> 1949</td>\n",
" <td> 0</td>\n",
" <td> NLS194907120</td>\n",
" <td> DET</td>\n",
" <td> AL</td>\n",
" <td> 1</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td> patekfr01</td>\n",
" <td> 1976</td>\n",
" <td> 0</td>\n",
" <td> NLS197607130</td>\n",
" <td> KCA</td>\n",
" <td> AL</td>\n",
" <td> 1</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 4,
"text": [
" playerID yearID gameNum gameID teamID lgID GP startingPos\n",
"0 kellech01 1941 0 ALS194107080 NYA AL 1 NaN\n",
"1 burdele01 1959 1 NLS195907070 ML1 NL 1 NaN\n",
"2 vaughar01 1936 0 NLS193607070 PIT NL 0 NaN\n",
"3 benchjo01 1969 0 ALS196907230 CIN NL 1 2\n",
"4 reesepe01 1951 0 ALS195107100 BRO NL 1 NaN\n",
"5 glavito02 2002 0 NLS200207090 ATL NL 0 NaN\n",
"6 dimagjo01 1939 0 ALS193907110 NYA AL 1 8\n",
"7 harrebu01 1971 0 ALS197107130 NYN NL 1 6\n",
"8 truckvi01 1949 0 NLS194907120 DET AL 1 NaN\n",
"9 patekfr01 1976 0 NLS197607130 KCA AL 1 NaN"
]
}
],
"prompt_number": 4
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"db.tables.allstarfull.playerID"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<table>\n",
" <tr>\n",
" <th>Table</th>\n",
" <th>Name</th>\n",
" <th>Type</th>\n",
" </tr>\n",
" <tr>\n",
" <td>allstarfull</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
"</table>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 5,
"text": [
"+-------------+----------+------+\n",
"| Table | Name | Type |\n",
"+-------------+----------+------+\n",
"| allstarfull | playerID | TEXT |\n",
"+-------------+----------+------+"
]
}
],
"prompt_number": 5
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"db.tables.allstarfull.playerID.head()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 6,
"text": [
"0 aaronha01\n",
"1 aaronha01\n",
"2 aaronha01\n",
"3 aaronha01\n",
"4 aaronha01\n",
"5 aaronha01\n",
"Name: playerID, dtype: object"
]
}
],
"prompt_number": 6
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"db.tables.allstarfull.playerID.unique().count()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 7,
"text": [
"1637"
]
}
],
"prompt_number": 7
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"db.find_column(\"*player*\")"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<table>\n",
" <tr>\n",
" <th>Table</th>\n",
" <th>Column Name</th>\n",
" <th>Type</th>\n",
" </tr>\n",
" <tr>\n",
" <td>allstarfull</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsplayers</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsshareplayers</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fielding</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingof</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingpost</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>master</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>salaries</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>schoolsplayers</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
"</table>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 8,
"text": [
"+--------------------+-------------+------+\n",
"| Table | Column Name | Type |\n",
"+--------------------+-------------+------+\n",
"| allstarfull | playerID | TEXT |\n",
"| appearances | playerID | TEXT |\n",
"| awardsplayers | playerID | TEXT |\n",
"| awardsshareplayers | playerID | TEXT |\n",
"| battingpost | playerID | TEXT |\n",
"| fielding | playerID | TEXT |\n",
"| fieldingof | playerID | TEXT |\n",
"| fieldingpost | playerID | TEXT |\n",
"| master | playerID | TEXT |\n",
"| pitching | playerID | TEXT |\n",
"| pitchingpost | playerID | TEXT |\n",
"| salaries | playerID | TEXT |\n",
"| schoolsplayers | playerID | TEXT |\n",
"| tmp_batting | playerID | TEXT |\n",
"+--------------------+-------------+------+"
]
}
],
"prompt_number": 8
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"db.find_column(\"*ID*\")"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<table>\n",
" <tr>\n",
" <th>Table</th>\n",
" <th>Column Name</th>\n",
" <th>Type</th>\n",
" </tr>\n",
" <tr>\n",
" <td>allstarfull</td>\n",
" <td>lgID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>allstarfull</td>\n",
" <td>gameID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>allstarfull</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>allstarfull</td>\n",
" <td>teamID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>allstarfull</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>teamID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>lgID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsmanagers</td>\n",
" <td>lgID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsmanagers</td>\n",
" <td>managerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsmanagers</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsmanagers</td>\n",
" <td>awardID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsplayers</td>\n",
" <td>lgID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsplayers</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsplayers</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsplayers</td>\n",
" <td>awardID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardssharemanagers</td>\n",
" <td>lgID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardssharemanagers</td>\n",
" <td>managerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardssharemanagers</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardssharemanagers</td>\n",
" <td>awardID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsshareplayers</td>\n",
" <td>lgID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsshareplayers</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsshareplayers</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsshareplayers</td>\n",
" <td>awardID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>teamID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>GIDP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>lgID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fielding</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fielding</td>\n",
" <td>teamID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fielding</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fielding</td>\n",
" <td>lgID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingof</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingof</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingpost</td>\n",
" <td>lgID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingpost</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingpost</td>\n",
" <td>teamID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingpost</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>halloffame</td>\n",
" <td>hofID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>hofold</td>\n",
" <td>hofID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managers</td>\n",
" <td>lgID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managers</td>\n",
" <td>teamID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managers</td>\n",
" <td>managerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managers</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managershalf</td>\n",
" <td>lgID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managershalf</td>\n",
" <td>teamID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managershalf</td>\n",
" <td>managerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managershalf</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>master</td>\n",
" <td>lahman40ID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>master</td>\n",
" <td>bbrefID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>master</td>\n",
" <td>retroID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>master</td>\n",
" <td>lahmanID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>master</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>master</td>\n",
" <td>hofID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>master</td>\n",
" <td>holtzID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>master</td>\n",
" <td>managerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>master</td>\n",
" <td>lahman45ID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>teamID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>GIDP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>lgID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>teamID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>GIDP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>lgID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>salaries</td>\n",
" <td>lgID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>salaries</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>salaries</td>\n",
" <td>teamID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>salaries</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>schools</td>\n",
" <td>schoolID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>schoolsplayers</td>\n",
" <td>schoolID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>schoolsplayers</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>seriespost</td>\n",
" <td>lgIDwinner</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>seriespost</td>\n",
" <td>lgIDloser</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>seriespost</td>\n",
" <td>teamIDwinner</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>seriespost</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>seriespost</td>\n",
" <td>teamIDloser</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>teamID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>teamIDBR</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>teamIDretro</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>teamIDlahman45</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>lgID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>franchID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>divID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teamsfranchises</td>\n",
" <td>franchID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teamshalf</td>\n",
" <td>lgID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teamshalf</td>\n",
" <td>divID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teamshalf</td>\n",
" <td>teamID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teamshalf</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>playerID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>teamID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>GIDP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>lgID</td>\n",
" <td>TEXT</td>\n",
" </tr>\n",
"</table>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 9,
"text": [
"+---------------------+----------------+---------+\n",
"| Table | Column Name | Type |\n",
"+---------------------+----------------+---------+\n",
"| allstarfull | lgID | TEXT |\n",
"| allstarfull | gameID | TEXT |\n",
"| allstarfull | playerID | TEXT |\n",
"| allstarfull | teamID | TEXT |\n",
"| allstarfull | yearID | INTEGER |\n",
"| appearances | playerID | TEXT |\n",
"| appearances | teamID | TEXT |\n",
"| appearances | yearID | INTEGER |\n",
"| appearances | lgID | TEXT |\n",
"| awardsmanagers | lgID | TEXT |\n",
"| awardsmanagers | managerID | TEXT |\n",
"| awardsmanagers | yearID | INTEGER |\n",
"| awardsmanagers | awardID | TEXT |\n",
"| awardsplayers | lgID | TEXT |\n",
"| awardsplayers | playerID | TEXT |\n",
"| awardsplayers | yearID | INTEGER |\n",
"| awardsplayers | awardID | TEXT |\n",
"| awardssharemanagers | lgID | TEXT |\n",
"| awardssharemanagers | managerID | TEXT |\n",
"| awardssharemanagers | yearID | INTEGER |\n",
"| awardssharemanagers | awardID | TEXT |\n",
"| awardsshareplayers | lgID | TEXT |\n",
"| awardsshareplayers | playerID | TEXT |\n",
"| awardsshareplayers | yearID | INTEGER |\n",
"| awardsshareplayers | awardID | TEXT |\n",
"| battingpost | playerID | TEXT |\n",
"| battingpost | teamID | TEXT |\n",
"| battingpost | yearID | INTEGER |\n",
"| battingpost | GIDP | INTEGER |\n",
"| battingpost | lgID | TEXT |\n",
"| fielding | playerID | TEXT |\n",
"| fielding | teamID | TEXT |\n",
"| fielding | yearID | INTEGER |\n",
"| fielding | lgID | TEXT |\n",
"| fieldingof | playerID | TEXT |\n",
"| fieldingof | yearID | INTEGER |\n",
"| fieldingpost | lgID | TEXT |\n",
"| fieldingpost | playerID | TEXT |\n",
"| fieldingpost | teamID | TEXT |\n",
"| fieldingpost | yearID | INTEGER |\n",
"| halloffame | hofID | TEXT |\n",
"| hofold | hofID | TEXT |\n",
"| managers | lgID | TEXT |\n",
"| managers | teamID | TEXT |\n",
"| managers | managerID | TEXT |\n",
"| managers | yearID | INTEGER |\n",
"| managershalf | lgID | TEXT |\n",
"| managershalf | teamID | TEXT |\n",
"| managershalf | managerID | TEXT |\n",
"| managershalf | yearID | INTEGER |\n",
"| master | lahman40ID | TEXT |\n",
"| master | bbrefID | TEXT |\n",
"| master | retroID | TEXT |\n",
"| master | lahmanID | INTEGER |\n",
"| master | playerID | TEXT |\n",
"| master | hofID | TEXT |\n",
"| master | holtzID | TEXT |\n",
"| master | managerID | TEXT |\n",
"| master | lahman45ID | TEXT |\n",
"| pitching | playerID | TEXT |\n",
"| pitching | teamID | TEXT |\n",
"| pitching | yearID | INTEGER |\n",
"| pitching | GIDP | INTEGER |\n",
"| pitching | lgID | TEXT |\n",
"| pitchingpost | playerID | TEXT |\n",
"| pitchingpost | teamID | TEXT |\n",
"| pitchingpost | yearID | INTEGER |\n",
"| pitchingpost | GIDP | INTEGER |\n",
"| pitchingpost | lgID | TEXT |\n",
"| salaries | lgID | TEXT |\n",
"| salaries | playerID | TEXT |\n",
"| salaries | teamID | TEXT |\n",
"| salaries | yearID | INTEGER |\n",
"| schools | schoolID | TEXT |\n",
"| schoolsplayers | schoolID | TEXT |\n",
"| schoolsplayers | playerID | TEXT |\n",
"| seriespost | lgIDwinner | TEXT |\n",
"| seriespost | lgIDloser | TEXT |\n",
"| seriespost | teamIDwinner | TEXT |\n",
"| seriespost | yearID | INTEGER |\n",
"| seriespost | teamIDloser | TEXT |\n",
"| teams | teamID | TEXT |\n",
"| teams | teamIDBR | TEXT |\n",
"| teams | teamIDretro | TEXT |\n",
"| teams | yearID | INTEGER |\n",
"| teams | teamIDlahman45 | TEXT |\n",
"| teams | lgID | TEXT |\n",
"| teams | franchID | TEXT |\n",
"| teams | divID | TEXT |\n",
"| teamsfranchises | franchID | TEXT |\n",
"| teamshalf | lgID | TEXT |\n",
"| teamshalf | divID | TEXT |\n",
"| teamshalf | teamID | TEXT |\n",
"| teamshalf | yearID | INTEGER |\n",
"| tmp_batting | playerID | TEXT |\n",
"| tmp_batting | teamID | TEXT |\n",
"| tmp_batting | yearID | INTEGER |\n",
"| tmp_batting | GIDP | INTEGER |\n",
"| tmp_batting | lgID | TEXT |\n",
"+---------------------+----------------+---------+"
]
}
],
"prompt_number": 9
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"db.find_column(\"HR\")"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<table>\n",
" <tr>\n",
" <th>Table</th>\n",
" <th>Column Name</th>\n",
" <th>Type</th>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>HR</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>HR</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>HR</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>HR</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>HR</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
"</table>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 10,
"text": [
"+--------------+-------------+---------+\n",
"| Table | Column Name | Type |\n",
"+--------------+-------------+---------+\n",
"| battingpost | HR | INTEGER |\n",
"| pitching | HR | INTEGER |\n",
"| pitchingpost | HR | INTEGER |\n",
"| teams | HR | INTEGER |\n",
"| tmp_batting | HR | INTEGER |\n",
"+--------------+-------------+---------+"
]
}
],
"prompt_number": 10
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"db.find_column(\"HR\", \"INTEGER\")"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<table>\n",
" <tr>\n",
" <th>Table</th>\n",
" <th>Column Name</th>\n",
" <th>Type</th>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>HR</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>HR</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>HR</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>HR</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>HR</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
"</table>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 11,
"text": [
"+--------------+-------------+---------+\n",
"| Table | Column Name | Type |\n",
"+--------------+-------------+---------+\n",
"| battingpost | HR | INTEGER |\n",
"| pitching | HR | INTEGER |\n",
"| pitchingpost | HR | INTEGER |\n",
"| teams | HR | INTEGER |\n",
"| tmp_batting | HR | INTEGER |\n",
"+--------------+-------------+---------+"
]
}
],
"prompt_number": 11
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"db.find_column(\"*\", \"INTEGER\")"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<table>\n",
" <tr>\n",
" <th>Table</th>\n",
" <th>Column Name</th>\n",
" <th>Type</th>\n",
" </tr>\n",
" <tr>\n",
" <td>allstarfull</td>\n",
" <td>GP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>allstarfull</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>allstarfull</td>\n",
" <td>startingPos</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>allstarfull</td>\n",
" <td>gameNum</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>G_cf</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>G_all</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>G_2b</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>G_batting</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>G_p</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>G_ss</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>G_of</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>G_c</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>G_dh</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>G_3b</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>G_rf</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>G_1b</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>G_lf</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>G_defense</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>G_ph</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>G_pr</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsmanagers</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsplayers</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardssharemanagers</td>\n",
" <td>votesFirst</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardssharemanagers</td>\n",
" <td>pointsWon</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardssharemanagers</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardssharemanagers</td>\n",
" <td>pointsMax</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsshareplayers</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsshareplayers</td>\n",
" <td>pointsMax</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>RBI</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>BB</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>HR</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>IBB</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>3B</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>HBP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>AB</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>G</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>H</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>R</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>2B</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>CS</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>GIDP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>SF</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>SH</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>SO</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>SB</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fielding</td>\n",
" <td>WP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fielding</td>\n",
" <td>E</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fielding</td>\n",
" <td>stint</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fielding</td>\n",
" <td>DP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fielding</td>\n",
" <td>PB</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fielding</td>\n",
" <td>PO</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fielding</td>\n",
" <td>A</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fielding</td>\n",
" <td>GS</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fielding</td>\n",
" <td>G</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fielding</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fielding</td>\n",
" <td>CS</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fielding</td>\n",
" <td>InnOuts</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fielding</td>\n",
" <td>SB</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingof</td>\n",
" <td>Gcf</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingof</td>\n",
" <td>Glf</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingof</td>\n",
" <td>Grf</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingof</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingof</td>\n",
" <td>stint</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingpost</td>\n",
" <td>A</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingpost</td>\n",
" <td>G</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingpost</td>\n",
" <td>TP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingpost</td>\n",
" <td>PB</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingpost</td>\n",
" <td>InnOuts</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingpost</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingpost</td>\n",
" <td>PO</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingpost</td>\n",
" <td>SB</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingpost</td>\n",
" <td>CS</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingpost</td>\n",
" <td>GS</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingpost</td>\n",
" <td>E</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingpost</td>\n",
" <td>DP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>halloffame</td>\n",
" <td>votes</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>halloffame</td>\n",
" <td>needed</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>halloffame</td>\n",
" <td>yearid</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>halloffame</td>\n",
" <td>ballots</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>hofold</td>\n",
" <td>votes</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>hofold</td>\n",
" <td>yearid</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>hofold</td>\n",
" <td>ballots</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managers</td>\n",
" <td>G</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managers</td>\n",
" <td>rank</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managers</td>\n",
" <td>W</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managers</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managers</td>\n",
" <td>inseason</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managers</td>\n",
" <td>L</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managershalf</td>\n",
" <td>G</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managershalf</td>\n",
" <td>rank</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managershalf</td>\n",
" <td>W</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managershalf</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managershalf</td>\n",
" <td>inseason</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managershalf</td>\n",
" <td>half</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managershalf</td>\n",
" <td>L</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>master</td>\n",
" <td>weight</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>master</td>\n",
" <td>lahmanID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>master</td>\n",
" <td>birthMonth</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>master</td>\n",
" <td>deathMonth</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>master</td>\n",
" <td>deathYear</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>master</td>\n",
" <td>birthYear</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>master</td>\n",
" <td>birthDay</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>master</td>\n",
" <td>deathDay</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>BB</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>HR</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>IBB</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>IPouts</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>BK</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>WP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>stint</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>HBP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>SH</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>ER</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>GS</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>G</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>H</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>CG</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>L</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>GF</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>BFP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>W</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>GIDP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>SHO</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>SV</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>R</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>SO</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>SF</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>BB</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>HR</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>IBB</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>IPouts</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>BK</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>WP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>HBP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>SH</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>ER</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>GS</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>G</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>H</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>CG</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>L</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>GF</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>BFP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>W</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>GIDP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>SHO</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>SV</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>SF</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>R</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>SO</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>salaries</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>schoolsplayers</td>\n",
" <td>yearMax</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>schoolsplayers</td>\n",
" <td>yearMin</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>seriespost</td>\n",
" <td>wins</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>seriespost</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>seriespost</td>\n",
" <td>losses</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>seriespost</td>\n",
" <td>ties</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>W</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>BB</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>BPF</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>HR</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>IPouts</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>Ghome</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>3B</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>HA</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>HBP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>DP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>SOA</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>attendance</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>PPF</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>RA</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>SHO</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>AB</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>E</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>G</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>H</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>CG</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>L</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>BBA</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>R</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>2B</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>CS</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>HRA</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>ER</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>SV</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>Rank</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>SO</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>SB</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>SF</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teamshalf</td>\n",
" <td>G</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teamshalf</td>\n",
" <td>Rank</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teamshalf</td>\n",
" <td>L</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teamshalf</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teamshalf</td>\n",
" <td>W</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>RBI</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>BB</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>HR</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>IBB</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>3B</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>G_old</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>stint</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>G_batting</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>HBP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>AB</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>G</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>H</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>yearID</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>R</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>2B</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>CS</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>GIDP</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>SH</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>SO</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>SB</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>SF</td>\n",
" <td>INTEGER</td>\n",
" </tr>\n",
"</table>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 12,
"text": [
"+---------------------+-------------+---------+\n",
"| Table | Column Name | Type |\n",
"+---------------------+-------------+---------+\n",
"| allstarfull | GP | INTEGER |\n",
"| allstarfull | yearID | INTEGER |\n",
"| allstarfull | startingPos | INTEGER |\n",
"| allstarfull | gameNum | INTEGER |\n",
"| appearances | G_cf | INTEGER |\n",
"| appearances | G_all | INTEGER |\n",
"| appearances | G_2b | INTEGER |\n",
"| appearances | G_batting | INTEGER |\n",
"| appearances | G_p | INTEGER |\n",
"| appearances | G_ss | INTEGER |\n",
"| appearances | G_of | INTEGER |\n",
"| appearances | G_c | INTEGER |\n",
"| appearances | G_dh | INTEGER |\n",
"| appearances | yearID | INTEGER |\n",
"| appearances | G_3b | INTEGER |\n",
"| appearances | G_rf | INTEGER |\n",
"| appearances | G_1b | INTEGER |\n",
"| appearances | G_lf | INTEGER |\n",
"| appearances | G_defense | INTEGER |\n",
"| appearances | G_ph | INTEGER |\n",
"| appearances | G_pr | INTEGER |\n",
"| awardsmanagers | yearID | INTEGER |\n",
"| awardsplayers | yearID | INTEGER |\n",
"| awardssharemanagers | votesFirst | INTEGER |\n",
"| awardssharemanagers | pointsWon | INTEGER |\n",
"| awardssharemanagers | yearID | INTEGER |\n",
"| awardssharemanagers | pointsMax | INTEGER |\n",
"| awardsshareplayers | yearID | INTEGER |\n",
"| awardsshareplayers | pointsMax | INTEGER |\n",
"| battingpost | RBI | INTEGER |\n",
"| battingpost | BB | INTEGER |\n",
"| battingpost | HR | INTEGER |\n",
"| battingpost | IBB | INTEGER |\n",
"| battingpost | 3B | INTEGER |\n",
"| battingpost | HBP | INTEGER |\n",
"| battingpost | AB | INTEGER |\n",
"| battingpost | G | INTEGER |\n",
"| battingpost | H | INTEGER |\n",
"| battingpost | yearID | INTEGER |\n",
"| battingpost | R | INTEGER |\n",
"| battingpost | 2B | INTEGER |\n",
"| battingpost | CS | INTEGER |\n",
"| battingpost | GIDP | INTEGER |\n",
"| battingpost | SF | INTEGER |\n",
"| battingpost | SH | INTEGER |\n",
"| battingpost | SO | INTEGER |\n",
"| battingpost | SB | INTEGER |\n",
"| fielding | WP | INTEGER |\n",
"| fielding | E | INTEGER |\n",
"| fielding | stint | INTEGER |\n",
"| fielding | DP | INTEGER |\n",
"| fielding | PB | INTEGER |\n",
"| fielding | PO | INTEGER |\n",
"| fielding | A | INTEGER |\n",
"| fielding | GS | INTEGER |\n",
"| fielding | G | INTEGER |\n",
"| fielding | yearID | INTEGER |\n",
"| fielding | CS | INTEGER |\n",
"| fielding | InnOuts | INTEGER |\n",
"| fielding | SB | INTEGER |\n",
"| fieldingof | Gcf | INTEGER |\n",
"| fieldingof | Glf | INTEGER |\n",
"| fieldingof | Grf | INTEGER |\n",
"| fieldingof | yearID | INTEGER |\n",
"| fieldingof | stint | INTEGER |\n",
"| fieldingpost | A | INTEGER |\n",
"| fieldingpost | G | INTEGER |\n",
"| fieldingpost | TP | INTEGER |\n",
"| fieldingpost | PB | INTEGER |\n",
"| fieldingpost | InnOuts | INTEGER |\n",
"| fieldingpost | yearID | INTEGER |\n",
"| fieldingpost | PO | INTEGER |\n",
"| fieldingpost | SB | INTEGER |\n",
"| fieldingpost | CS | INTEGER |\n",
"| fieldingpost | GS | INTEGER |\n",
"| fieldingpost | E | INTEGER |\n",
"| fieldingpost | DP | INTEGER |\n",
"| halloffame | votes | INTEGER |\n",
"| halloffame | needed | INTEGER |\n",
"| halloffame | yearid | INTEGER |\n",
"| halloffame | ballots | INTEGER |\n",
"| hofold | votes | INTEGER |\n",
"| hofold | yearid | INTEGER |\n",
"| hofold | ballots | INTEGER |\n",
"| managers | G | INTEGER |\n",
"| managers | rank | INTEGER |\n",
"| managers | W | INTEGER |\n",
"| managers | yearID | INTEGER |\n",
"| managers | inseason | INTEGER |\n",
"| managers | L | INTEGER |\n",
"| managershalf | G | INTEGER |\n",
"| managershalf | rank | INTEGER |\n",
"| managershalf | W | INTEGER |\n",
"| managershalf | yearID | INTEGER |\n",
"| managershalf | inseason | INTEGER |\n",
"| managershalf | half | INTEGER |\n",
"| managershalf | L | INTEGER |\n",
"| master | weight | INTEGER |\n",
"| master | lahmanID | INTEGER |\n",
"| master | birthMonth | INTEGER |\n",
"| master | deathMonth | INTEGER |\n",
"| master | deathYear | INTEGER |\n",
"| master | birthYear | INTEGER |\n",
"| master | birthDay | INTEGER |\n",
"| master | deathDay | INTEGER |\n",
"| pitching | BB | INTEGER |\n",
"| pitching | HR | INTEGER |\n",
"| pitching | IBB | INTEGER |\n",
"| pitching | IPouts | INTEGER |\n",
"| pitching | BK | INTEGER |\n",
"| pitching | WP | INTEGER |\n",
"| pitching | stint | INTEGER |\n",
"| pitching | HBP | INTEGER |\n",
"| pitching | SH | INTEGER |\n",
"| pitching | ER | INTEGER |\n",
"| pitching | GS | INTEGER |\n",
"| pitching | G | INTEGER |\n",
"| pitching | H | INTEGER |\n",
"| pitching | CG | INTEGER |\n",
"| pitching | L | INTEGER |\n",
"| pitching | GF | INTEGER |\n",
"| pitching | yearID | INTEGER |\n",
"| pitching | BFP | INTEGER |\n",
"| pitching | W | INTEGER |\n",
"| pitching | GIDP | INTEGER |\n",
"| pitching | SHO | INTEGER |\n",
"| pitching | SV | INTEGER |\n",
"| pitching | R | INTEGER |\n",
"| pitching | SO | INTEGER |\n",
"| pitching | SF | INTEGER |\n",
"| pitchingpost | BB | INTEGER |\n",
"| pitchingpost | HR | INTEGER |\n",
"| pitchingpost | IBB | INTEGER |\n",
"| pitchingpost | IPouts | INTEGER |\n",
"| pitchingpost | BK | INTEGER |\n",
"| pitchingpost | WP | INTEGER |\n",
"| pitchingpost | HBP | INTEGER |\n",
"| pitchingpost | SH | INTEGER |\n",
"| pitchingpost | ER | INTEGER |\n",
"| pitchingpost | GS | INTEGER |\n",
"| pitchingpost | G | INTEGER |\n",
"| pitchingpost | H | INTEGER |\n",
"| pitchingpost | CG | INTEGER |\n",
"| pitchingpost | L | INTEGER |\n",
"| pitchingpost | GF | INTEGER |\n",
"| pitchingpost | yearID | INTEGER |\n",
"| pitchingpost | BFP | INTEGER |\n",
"| pitchingpost | W | INTEGER |\n",
"| pitchingpost | GIDP | INTEGER |\n",
"| pitchingpost | SHO | INTEGER |\n",
"| pitchingpost | SV | INTEGER |\n",
"| pitchingpost | SF | INTEGER |\n",
"| pitchingpost | R | INTEGER |\n",
"| pitchingpost | SO | INTEGER |\n",
"| salaries | yearID | INTEGER |\n",
"| schoolsplayers | yearMax | INTEGER |\n",
"| schoolsplayers | yearMin | INTEGER |\n",
"| seriespost | wins | INTEGER |\n",
"| seriespost | yearID | INTEGER |\n",
"| seriespost | losses | INTEGER |\n",
"| seriespost | ties | INTEGER |\n",
"| teams | W | INTEGER |\n",
"| teams | BB | INTEGER |\n",
"| teams | BPF | INTEGER |\n",
"| teams | HR | INTEGER |\n",
"| teams | IPouts | INTEGER |\n",
"| teams | Ghome | INTEGER |\n",
"| teams | 3B | INTEGER |\n",
"| teams | HA | INTEGER |\n",
"| teams | HBP | INTEGER |\n",
"| teams | DP | INTEGER |\n",
"| teams | SOA | INTEGER |\n",
"| teams | attendance | INTEGER |\n",
"| teams | PPF | INTEGER |\n",
"| teams | RA | INTEGER |\n",
"| teams | SHO | INTEGER |\n",
"| teams | AB | INTEGER |\n",
"| teams | E | INTEGER |\n",
"| teams | G | INTEGER |\n",
"| teams | H | INTEGER |\n",
"| teams | CG | INTEGER |\n",
"| teams | L | INTEGER |\n",
"| teams | BBA | INTEGER |\n",
"| teams | yearID | INTEGER |\n",
"| teams | R | INTEGER |\n",
"| teams | 2B | INTEGER |\n",
"| teams | CS | INTEGER |\n",
"| teams | HRA | INTEGER |\n",
"| teams | ER | INTEGER |\n",
"| teams | SV | INTEGER |\n",
"| teams | Rank | INTEGER |\n",
"| teams | SO | INTEGER |\n",
"| teams | SB | INTEGER |\n",
"| teams | SF | INTEGER |\n",
"| teamshalf | G | INTEGER |\n",
"| teamshalf | Rank | INTEGER |\n",
"| teamshalf | L | INTEGER |\n",
"| teamshalf | yearID | INTEGER |\n",
"| teamshalf | W | INTEGER |\n",
"| tmp_batting | RBI | INTEGER |\n",
"| tmp_batting | BB | INTEGER |\n",
"| tmp_batting | HR | INTEGER |\n",
"| tmp_batting | IBB | INTEGER |\n",
"| tmp_batting | 3B | INTEGER |\n",
"| tmp_batting | G_old | INTEGER |\n",
"| tmp_batting | stint | INTEGER |\n",
"| tmp_batting | G_batting | INTEGER |\n",
"| tmp_batting | HBP | INTEGER |\n",
"| tmp_batting | AB | INTEGER |\n",
"| tmp_batting | G | INTEGER |\n",
"| tmp_batting | H | INTEGER |\n",
"| tmp_batting | yearID | INTEGER |\n",
"| tmp_batting | R | INTEGER |\n",
"| tmp_batting | 2B | INTEGER |\n",
"| tmp_batting | CS | INTEGER |\n",
"| tmp_batting | GIDP | INTEGER |\n",
"| tmp_batting | SH | INTEGER |\n",
"| tmp_batting | SO | INTEGER |\n",
"| tmp_batting | SB | INTEGER |\n",
"| tmp_batting | SF | INTEGER |\n",
"+---------------------+-------------+---------+"
]
}
],
"prompt_number": 12
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"db.find_table(\"*\")"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<table>\n",
" <tr>\n",
" <th>Table</th>\n",
" <th>Columns</th>\n",
" </tr>\n",
" <tr>\n",
" <td>allstarfull</td>\n",
" <td>playerID, yearID, gameNum, gameID, teamID, lgID, GP, startingPos</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>yearID, teamID, lgID, playerID, G_all, G_batting, G_defense, G_p, G_c, G_1b, G_2<br>b, G_3b, G_ss, G_lf, G_cf, G_rf, G_of, G_dh, G_ph, G_pr</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsmanagers</td>\n",
" <td>managerID, awardID, yearID, lgID, tie, notes</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsplayers</td>\n",
" <td>playerID, awardID, yearID, lgID, tie, notes</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardssharemanagers</td>\n",
" <td>awardID, yearID, lgID, managerID, pointsWon, pointsMax, votesFirst</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsshareplayers</td>\n",
" <td>awardID, yearID, lgID, playerID, pointsWon, pointsMax, votesFirst</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>yearID, round, playerID, teamID, lgID, G, AB, R, H, 2B, 3B, HR, RBI, SB, CS, BB,<br> SO, IBB, HBP, SH, SF, GIDP</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fielding</td>\n",
" <td>playerID, yearID, stint, teamID, lgID, POS, G, GS, InnOuts, PO, A, E, DP, PB, WP<br>, SB, CS, ZR</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingof</td>\n",
" <td>playerID, yearID, stint, Glf, Gcf, Grf</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingpost</td>\n",
" <td>playerID, yearID, teamID, lgID, round, POS, G, GS, InnOuts, PO, A, E, DP, TP, PB<br>, SB, CS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>halloffame</td>\n",
" <td>hofID, yearid, votedBy, ballots, needed, votes, inducted, category</td>\n",
" </tr>\n",
" <tr>\n",
" <td>hofold</td>\n",
" <td>hofID, yearid, votedBy, ballots, votes, inducted, category</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managers</td>\n",
" <td>managerID, yearID, teamID, lgID, inseason, G, W, L, rank, plyrMgr</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managershalf</td>\n",
" <td>managerID, yearID, teamID, lgID, inseason, half, G, W, L, rank</td>\n",
" </tr>\n",
" <tr>\n",
" <td>master</td>\n",
" <td>lahmanID, playerID, managerID, hofID, birthYear, birthMonth, birthDay, birthCoun<br>try, birthState, birthCity, deathYear, deathMonth, deathDay, deathCountry, death<br>State, deathCity, nameFirst, nameLast, nameNote, nameGiven, nameNick, weight, he<br>ight, bats, throws, debut, finalGame, college, lahman40ID, lahman45ID, retroID, <br>holtzID, bbrefID</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>playerID, yearID, stint, teamID, lgID, W, L, G, GS, CG, SHO, SV, IPouts, H, ER, <br>HR, BB, SO, BAOpp, ERA, IBB, WP, HBP, BK, BFP, GF, R, SH, SF, GIDP</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>playerID, yearID, round, teamID, lgID, W, L, G, GS, CG, SHO, SV, IPouts, H, ER, <br>HR, BB, SO, BAOpp, ERA, IBB, WP, HBP, BK, BFP, GF, R, SH, SF, GIDP</td>\n",
" </tr>\n",
" <tr>\n",
" <td>salaries</td>\n",
" <td>yearID, teamID, lgID, playerID, salary</td>\n",
" </tr>\n",
" <tr>\n",
" <td>schools</td>\n",
" <td>schoolID, schoolName, schoolCity, schoolState, schoolNick</td>\n",
" </tr>\n",
" <tr>\n",
" <td>schoolsplayers</td>\n",
" <td>playerID, schoolID, yearMin, yearMax</td>\n",
" </tr>\n",
" <tr>\n",
" <td>seriespost</td>\n",
" <td>yearID, round, teamIDwinner, lgIDwinner, teamIDloser, lgIDloser, wins, losses, t<br>ies</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>yearID, lgID, teamID, franchID, divID, Rank, G, Ghome, W, L, DivWin, WCWin, LgWi<br>n, WSWin, R, AB, H, 2B, 3B, HR, BB, SO, SB, CS, HBP, SF, RA, ER, ERA, CG, SHO, S<br>V, IPouts, HA, HRA, BBA, SOA, E, DP, FP, name, park, attendance, BPF, PPF, teamI<br>DBR, teamIDlahman45, teamIDretro</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teamsfranchises</td>\n",
" <td>franchID, franchName, active, NAassoc</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teamshalf</td>\n",
" <td>yearID, lgID, teamID, Half, divID, DivWin, Rank, G, W, L</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>playerID, yearID, stint, teamID, lgID, G, G_batting, AB, R, H, 2B, 3B, HR, RBI, <br>SB, CS, BB, SO, IBB, HBP, SH, SF, GIDP, G_old</td>\n",
" </tr>\n",
"</table>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 13,
"text": [
"+---------------------+----------------------------------------------------------------------------------+\n",
"| Table | Columns |\n",
"+---------------------+----------------------------------------------------------------------------------+\n",
"| allstarfull | playerID, yearID, gameNum, gameID, teamID, lgID, GP, startingPos |\n",
"| appearances | yearID, teamID, lgID, playerID, G_all, G_batting, G_defense, G_p, G_c, G_1b, G_2 |\n",
"| | b, G_3b, G_ss, G_lf, G_cf, G_rf, G_of, G_dh, G_ph, G_pr |\n",
"| awardsmanagers | managerID, awardID, yearID, lgID, tie, notes |\n",
"| awardsplayers | playerID, awardID, yearID, lgID, tie, notes |\n",
"| awardssharemanagers | awardID, yearID, lgID, managerID, pointsWon, pointsMax, votesFirst |\n",
"| awardsshareplayers | awardID, yearID, lgID, playerID, pointsWon, pointsMax, votesFirst |\n",
"| battingpost | yearID, round, playerID, teamID, lgID, G, AB, R, H, 2B, 3B, HR, RBI, SB, CS, BB, |\n",
"| | SO, IBB, HBP, SH, SF, GIDP |\n",
"| fielding | playerID, yearID, stint, teamID, lgID, POS, G, GS, InnOuts, PO, A, E, DP, PB, WP |\n",
"| | , SB, CS, ZR |\n",
"| fieldingof | playerID, yearID, stint, Glf, Gcf, Grf |\n",
"| fieldingpost | playerID, yearID, teamID, lgID, round, POS, G, GS, InnOuts, PO, A, E, DP, TP, PB |\n",
"| | , SB, CS |\n",
"| halloffame | hofID, yearid, votedBy, ballots, needed, votes, inducted, category |\n",
"| hofold | hofID, yearid, votedBy, ballots, votes, inducted, category |\n",
"| managers | managerID, yearID, teamID, lgID, inseason, G, W, L, rank, plyrMgr |\n",
"| managershalf | managerID, yearID, teamID, lgID, inseason, half, G, W, L, rank |\n",
"| master | lahmanID, playerID, managerID, hofID, birthYear, birthMonth, birthDay, birthCoun |\n",
"| | try, birthState, birthCity, deathYear, deathMonth, deathDay, deathCountry, death |\n",
"| | State, deathCity, nameFirst, nameLast, nameNote, nameGiven, nameNick, weight, he |\n",
"| | ight, bats, throws, debut, finalGame, college, lahman40ID, lahman45ID, retroID, |\n",
"| | holtzID, bbrefID |\n",
"| pitching | playerID, yearID, stint, teamID, lgID, W, L, G, GS, CG, SHO, SV, IPouts, H, ER, |\n",
"| | HR, BB, SO, BAOpp, ERA, IBB, WP, HBP, BK, BFP, GF, R, SH, SF, GIDP |\n",
"| pitchingpost | playerID, yearID, round, teamID, lgID, W, L, G, GS, CG, SHO, SV, IPouts, H, ER, |\n",
"| | HR, BB, SO, BAOpp, ERA, IBB, WP, HBP, BK, BFP, GF, R, SH, SF, GIDP |\n",
"| salaries | yearID, teamID, lgID, playerID, salary |\n",
"| schools | schoolID, schoolName, schoolCity, schoolState, schoolNick |\n",
"| schoolsplayers | playerID, schoolID, yearMin, yearMax |\n",
"| seriespost | yearID, round, teamIDwinner, lgIDwinner, teamIDloser, lgIDloser, wins, losses, t |\n",
"| | ies |\n",
"| teams | yearID, lgID, teamID, franchID, divID, Rank, G, Ghome, W, L, DivWin, WCWin, LgWi |\n",
"| | n, WSWin, R, AB, H, 2B, 3B, HR, BB, SO, SB, CS, HBP, SF, RA, ER, ERA, CG, SHO, S |\n",
"| | V, IPouts, HA, HRA, BBA, SOA, E, DP, FP, name, park, attendance, BPF, PPF, teamI |\n",
"| | DBR, teamIDlahman45, teamIDretro |\n",
"| teamsfranchises | franchID, franchName, active, NAassoc |\n",
"| teamshalf | yearID, lgID, teamID, Half, divID, DivWin, Rank, G, W, L |\n",
"| tmp_batting | playerID, yearID, stint, teamID, lgID, G, G_batting, AB, R, H, 2B, 3B, HR, RBI, |\n",
"| | SB, CS, BB, SO, IBB, HBP, SH, SF, GIDP, G_old |\n",
"+---------------------+----------------------------------------------------------------------------------+"
]
}
],
"prompt_number": 13
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"db.find_table(\"*batting*\")"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<table>\n",
" <tr>\n",
" <th>Table</th>\n",
" <th>Columns</th>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>yearID, round, playerID, teamID, lgID, G, AB, R, H, 2B, 3B, HR, RBI, SB, CS, BB,<br> SO, IBB, HBP, SH, SF, GIDP</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>playerID, yearID, stint, teamID, lgID, G, G_batting, AB, R, H, 2B, 3B, HR, RBI, <br>SB, CS, BB, SO, IBB, HBP, SH, SF, GIDP, G_old</td>\n",
" </tr>\n",
"</table>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 14,
"text": [
"+-------------+----------------------------------------------------------------------------------+\n",
"| Table | Columns |\n",
"+-------------+----------------------------------------------------------------------------------+\n",
"| battingpost | yearID, round, playerID, teamID, lgID, G, AB, R, H, 2B, 3B, HR, RBI, SB, CS, BB, |\n",
"| | SO, IBB, HBP, SH, SF, GIDP |\n",
"| tmp_batting | playerID, yearID, stint, teamID, lgID, G, G_batting, AB, R, H, 2B, 3B, HR, RBI, |\n",
"| | SB, CS, BB, SO, IBB, HBP, SH, SF, GIDP, G_old |\n",
"+-------------+----------------------------------------------------------------------------------+"
]
}
],
"prompt_number": 14
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"db.save_credentials(\"baseball\")"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 15
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"from db import DB"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 16
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"db = DB(profile=\"baseball\", dbtype=\"sqlite\")"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stderr",
"text": [
"Indexing schema. This will take a second...finished!\n"
]
}
],
"prompt_number": 17
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"db.tables"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<table>\n",
" <tr>\n",
" <th>Table</th>\n",
" <th>Columns</th>\n",
" </tr>\n",
" <tr>\n",
" <td>allstarfull</td>\n",
" <td>playerID, yearID, gameNum, gameID, teamID, lgID, GP, startingPos</td>\n",
" </tr>\n",
" <tr>\n",
" <td>appearances</td>\n",
" <td>yearID, teamID, lgID, playerID, G_all, G_batting, G_defense, G_p, G_c, G_1b, G_2<br>b, G_3b, G_ss, G_lf, G_cf, G_rf, G_of, G_dh, G_ph, G_pr</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsmanagers</td>\n",
" <td>managerID, awardID, yearID, lgID, tie, notes</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsplayers</td>\n",
" <td>playerID, awardID, yearID, lgID, tie, notes</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardssharemanagers</td>\n",
" <td>awardID, yearID, lgID, managerID, pointsWon, pointsMax, votesFirst</td>\n",
" </tr>\n",
" <tr>\n",
" <td>awardsshareplayers</td>\n",
" <td>awardID, yearID, lgID, playerID, pointsWon, pointsMax, votesFirst</td>\n",
" </tr>\n",
" <tr>\n",
" <td>battingpost</td>\n",
" <td>yearID, round, playerID, teamID, lgID, G, AB, R, H, 2B, 3B, HR, RBI, SB, CS, BB,<br> SO, IBB, HBP, SH, SF, GIDP</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fielding</td>\n",
" <td>playerID, yearID, stint, teamID, lgID, POS, G, GS, InnOuts, PO, A, E, DP, PB, WP<br>, SB, CS, ZR</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingof</td>\n",
" <td>playerID, yearID, stint, Glf, Gcf, Grf</td>\n",
" </tr>\n",
" <tr>\n",
" <td>fieldingpost</td>\n",
" <td>playerID, yearID, teamID, lgID, round, POS, G, GS, InnOuts, PO, A, E, DP, TP, PB<br>, SB, CS</td>\n",
" </tr>\n",
" <tr>\n",
" <td>halloffame</td>\n",
" <td>hofID, yearid, votedBy, ballots, needed, votes, inducted, category</td>\n",
" </tr>\n",
" <tr>\n",
" <td>hofold</td>\n",
" <td>hofID, yearid, votedBy, ballots, votes, inducted, category</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managers</td>\n",
" <td>managerID, yearID, teamID, lgID, inseason, G, W, L, rank, plyrMgr</td>\n",
" </tr>\n",
" <tr>\n",
" <td>managershalf</td>\n",
" <td>managerID, yearID, teamID, lgID, inseason, half, G, W, L, rank</td>\n",
" </tr>\n",
" <tr>\n",
" <td>master</td>\n",
" <td>lahmanID, playerID, managerID, hofID, birthYear, birthMonth, birthDay, birthCoun<br>try, birthState, birthCity, deathYear, deathMonth, deathDay, deathCountry, death<br>State, deathCity, nameFirst, nameLast, nameNote, nameGiven, nameNick, weight, he<br>ight, bats, throws, debut, finalGame, college, lahman40ID, lahman45ID, retroID, <br>holtzID, bbrefID</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitching</td>\n",
" <td>playerID, yearID, stint, teamID, lgID, W, L, G, GS, CG, SHO, SV, IPouts, H, ER, <br>HR, BB, SO, BAOpp, ERA, IBB, WP, HBP, BK, BFP, GF, R, SH, SF, GIDP</td>\n",
" </tr>\n",
" <tr>\n",
" <td>pitchingpost</td>\n",
" <td>playerID, yearID, round, teamID, lgID, W, L, G, GS, CG, SHO, SV, IPouts, H, ER, <br>HR, BB, SO, BAOpp, ERA, IBB, WP, HBP, BK, BFP, GF, R, SH, SF, GIDP</td>\n",
" </tr>\n",
" <tr>\n",
" <td>salaries</td>\n",
" <td>yearID, teamID, lgID, playerID, salary</td>\n",
" </tr>\n",
" <tr>\n",
" <td>schools</td>\n",
" <td>schoolID, schoolName, schoolCity, schoolState, schoolNick</td>\n",
" </tr>\n",
" <tr>\n",
" <td>schoolsplayers</td>\n",
" <td>playerID, schoolID, yearMin, yearMax</td>\n",
" </tr>\n",
" <tr>\n",
" <td>seriespost</td>\n",
" <td>yearID, round, teamIDwinner, lgIDwinner, teamIDloser, lgIDloser, wins, losses, t<br>ies</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teams</td>\n",
" <td>yearID, lgID, teamID, franchID, divID, Rank, G, Ghome, W, L, DivWin, WCWin, LgWi<br>n, WSWin, R, AB, H, 2B, 3B, HR, BB, SO, SB, CS, HBP, SF, RA, ER, ERA, CG, SHO, S<br>V, IPouts, HA, HRA, BBA, SOA, E, DP, FP, name, park, attendance, BPF, PPF, teamI<br>DBR, teamIDlahman45, teamIDretro</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teamsfranchises</td>\n",
" <td>franchID, franchName, active, NAassoc</td>\n",
" </tr>\n",
" <tr>\n",
" <td>teamshalf</td>\n",
" <td>yearID, lgID, teamID, Half, divID, DivWin, Rank, G, W, L</td>\n",
" </tr>\n",
" <tr>\n",
" <td>tmp_batting</td>\n",
" <td>playerID, yearID, stint, teamID, lgID, G, G_batting, AB, R, H, 2B, 3B, HR, RBI, <br>SB, CS, BB, SO, IBB, HBP, SH, SF, GIDP, G_old</td>\n",
" </tr>\n",
"</table>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 18,
"text": [
"+---------------------+----------------------------------------------------------------------------------+\n",
"| Table | Columns |\n",
"+---------------------+----------------------------------------------------------------------------------+\n",
"| allstarfull | playerID, yearID, gameNum, gameID, teamID, lgID, GP, startingPos |\n",
"| appearances | yearID, teamID, lgID, playerID, G_all, G_batting, G_defense, G_p, G_c, G_1b, G_2 |\n",
"| | b, G_3b, G_ss, G_lf, G_cf, G_rf, G_of, G_dh, G_ph, G_pr |\n",
"| awardsmanagers | managerID, awardID, yearID, lgID, tie, notes |\n",
"| awardsplayers | playerID, awardID, yearID, lgID, tie, notes |\n",
"| awardssharemanagers | awardID, yearID, lgID, managerID, pointsWon, pointsMax, votesFirst |\n",
"| awardsshareplayers | awardID, yearID, lgID, playerID, pointsWon, pointsMax, votesFirst |\n",
"| battingpost | yearID, round, playerID, teamID, lgID, G, AB, R, H, 2B, 3B, HR, RBI, SB, CS, BB, |\n",
"| | SO, IBB, HBP, SH, SF, GIDP |\n",
"| fielding | playerID, yearID, stint, teamID, lgID, POS, G, GS, InnOuts, PO, A, E, DP, PB, WP |\n",
"| | , SB, CS, ZR |\n",
"| fieldingof | playerID, yearID, stint, Glf, Gcf, Grf |\n",
"| fieldingpost | playerID, yearID, teamID, lgID, round, POS, G, GS, InnOuts, PO, A, E, DP, TP, PB |\n",
"| | , SB, CS |\n",
"| halloffame | hofID, yearid, votedBy, ballots, needed, votes, inducted, category |\n",
"| hofold | hofID, yearid, votedBy, ballots, votes, inducted, category |\n",
"| managers | managerID, yearID, teamID, lgID, inseason, G, W, L, rank, plyrMgr |\n",
"| managershalf | managerID, yearID, teamID, lgID, inseason, half, G, W, L, rank |\n",
"| master | lahmanID, playerID, managerID, hofID, birthYear, birthMonth, birthDay, birthCoun |\n",
"| | try, birthState, birthCity, deathYear, deathMonth, deathDay, deathCountry, death |\n",
"| | State, deathCity, nameFirst, nameLast, nameNote, nameGiven, nameNick, weight, he |\n",
"| | ight, bats, throws, debut, finalGame, college, lahman40ID, lahman45ID, retroID, |\n",
"| | holtzID, bbrefID |\n",
"| pitching | playerID, yearID, stint, teamID, lgID, W, L, G, GS, CG, SHO, SV, IPouts, H, ER, |\n",
"| | HR, BB, SO, BAOpp, ERA, IBB, WP, HBP, BK, BFP, GF, R, SH, SF, GIDP |\n",
"| pitchingpost | playerID, yearID, round, teamID, lgID, W, L, G, GS, CG, SHO, SV, IPouts, H, ER, |\n",
"| | HR, BB, SO, BAOpp, ERA, IBB, WP, HBP, BK, BFP, GF, R, SH, SF, GIDP |\n",
"| salaries | yearID, teamID, lgID, playerID, salary |\n",
"| schools | schoolID, schoolName, schoolCity, schoolState, schoolNick |\n",
"| schoolsplayers | playerID, schoolID, yearMin, yearMax |\n",
"| seriespost | yearID, round, teamIDwinner, lgIDwinner, teamIDloser, lgIDloser, wins, losses, t |\n",
"| | ies |\n",
"| teams | yearID, lgID, teamID, franchID, divID, Rank, G, Ghome, W, L, DivWin, WCWin, LgWi |\n",
"| | n, WSWin, R, AB, H, 2B, 3B, HR, BB, SO, SB, CS, HBP, SF, RA, ER, ERA, CG, SHO, S |\n",
"| | V, IPouts, HA, HRA, BBA, SOA, E, DP, FP, name, park, attendance, BPF, PPF, teamI |\n",
"| | DBR, teamIDlahman45, teamIDretro |\n",
"| teamsfranchises | franchID, franchName, active, NAassoc |\n",
"| teamshalf | yearID, lgID, teamID, Half, divID, DivWin, Rank, G, W, L |\n",
"| tmp_batting | playerID, yearID, stint, teamID, lgID, G, G_batting, AB, R, H, 2B, 3B, HR, RBI, |\n",
"| | SB, CS, BB, SO, IBB, HBP, SH, SF, GIDP, G_old |\n",
"+---------------------+----------------------------------------------------------------------------------+"
]
}
],
"prompt_number": 18
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"db.tables.appearances.head()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>yearID</th>\n",
" <th>teamID</th>\n",
" <th>lgID</th>\n",
" <th>playerID</th>\n",
" <th>G_all</th>\n",
" <th>G_batting</th>\n",
" <th>G_defense</th>\n",
" <th>G_p</th>\n",
" <th>G_c</th>\n",
" <th>G_1b</th>\n",
" <th>G_2b</th>\n",
" <th>G_3b</th>\n",
" <th>G_ss</th>\n",
" <th>G_lf</th>\n",
" <th>G_cf</th>\n",
" <th>G_rf</th>\n",
" <th>G_of</th>\n",
" <th>G_dh</th>\n",
" <th>G_ph</th>\n",
" <th>G_pr</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td> 1871</td>\n",
" <td> BS1</td>\n",
" <td> NA</td>\n",
" <td> barnero01</td>\n",
" <td> 31</td>\n",
" <td> None</td>\n",
" <td> 31</td>\n",
" <td> 31</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 16</td>\n",
" <td> 0</td>\n",
" <td> 15</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td> 1871</td>\n",
" <td> BS1</td>\n",
" <td> NA</td>\n",
" <td> barrofr01</td>\n",
" <td> 18</td>\n",
" <td> None</td>\n",
" <td> 18</td>\n",
" <td> 18</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 1</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 13</td>\n",
" <td> 0</td>\n",
" <td> 4</td>\n",
" <td> 17</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td> 1871</td>\n",
" <td> BS1</td>\n",
" <td> NA</td>\n",
" <td> birdsda01</td>\n",
" <td> 29</td>\n",
" <td> None</td>\n",
" <td> 29</td>\n",
" <td> 29</td>\n",
" <td> 0</td>\n",
" <td> 7</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 27</td>\n",
" <td> 27</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td> 1871</td>\n",
" <td> BS1</td>\n",
" <td> NA</td>\n",
" <td> conefr01</td>\n",
" <td> 19</td>\n",
" <td> None</td>\n",
" <td> 19</td>\n",
" <td> 19</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 18</td>\n",
" <td> 0</td>\n",
" <td> 1</td>\n",
" <td> 18</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td> 1871</td>\n",
" <td> BS1</td>\n",
" <td> NA</td>\n",
" <td> gouldch01</td>\n",
" <td> 31</td>\n",
" <td> None</td>\n",
" <td> 31</td>\n",
" <td> 31</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 30</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 1</td>\n",
" <td> 1</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td> 1871</td>\n",
" <td> BS1</td>\n",
" <td> NA</td>\n",
" <td> jackssa01</td>\n",
" <td> 16</td>\n",
" <td> None</td>\n",
" <td> 16</td>\n",
" <td> 16</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 0</td>\n",
" <td> 14</td>\n",
" <td> 0</td>\n",
" <td> 1</td>\n",
" <td> 0</td>\n",
" <td> 1</td>\n",
" <td> 0</td>\n",
" <td> 1</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 19,
"text": [
" yearID teamID lgID playerID G_all G_batting G_defense G_p G_c G_1b \\\n",
"0 1871 BS1 NA barnero01 31 None 31 31 0 0 \n",
"1 1871 BS1 NA barrofr01 18 None 18 18 0 0 \n",
"2 1871 BS1 NA birdsda01 29 None 29 29 0 7 \n",
"3 1871 BS1 NA conefr01 19 None 19 19 0 0 \n",
"4 1871 BS1 NA gouldch01 31 None 31 31 0 0 \n",
"5 1871 BS1 NA jackssa01 16 None 16 16 0 0 \n",
"\n",
" G_2b G_3b G_ss G_lf G_cf G_rf G_of G_dh G_ph G_pr \n",
"0 0 16 0 15 0 0 0 0 None None \n",
"1 0 1 0 0 13 0 4 17 None None \n",
"2 0 0 0 0 0 0 27 27 None None \n",
"3 0 0 0 0 18 0 1 18 None None \n",
"4 30 0 0 0 0 0 1 1 None None \n",
"5 0 14 0 1 0 1 0 1 None None "
]
}
],
"prompt_number": 19
},
{
"cell_type": "code",
"collapsed": false,
"input": [],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 19
}
],
"metadata": {}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment