{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "
\n", " \"cognitiveclass.ai\n", "
\n", "\n", "# Working with a real world data-set using SQL and Python\n", "\n", "Estaimted time needed: **30** minutes\n", "\n", "## Objectives\n", "\n", "After complting this lab you will be able to:\n", "\n", "* Understand the dataset for Chicago Public School level performance\n", "* Store the dataset in an Db2 database on IBM Cloud instance\n", "* Retrieve metadata about tables and columns and query data from mixed case columns\n", "* Solve example problems to practice your SQL skills including using built-in database functions\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Chicago Public Schools - Progress Report Cards (2011-2012)\n", "\n", "The city of Chicago released a dataset showing all school level performance data used to create School Report Cards for the 2011-2012 school year. The dataset is available from the Chicago Data Portal: [https://data.cityofchicago.org/Education/Chicago-Public-Schools-Progress-Report-Cards-2011-/9xs2-f89t](https://data.cityofchicago.org/Education/Chicago-Public-Schools-Progress-Report-Cards-2011-/9xs2-f89t?utm_medium=Exinfluencer&utm_source=Exinfluencer&utm_content=000026UJ&utm_term=10006555&utm_id=NA-SkillsNetwork-Channel-SkillsNetworkCoursesIBMDeveloperSkillsNetworkDB0201ENSkillsNetwork20127838-2022-01-01&cm_mmc=Email_Newsletter-\\_-Developer_Ed%2BTech-\\_-WW_WW-\\_-SkillsNetwork-Courses-IBMDeveloperSkillsNetwork-DB0201EN-SkillsNetwork-20127838&cm_mmca1=000026UJ&cm_mmca2=10006555&cm_mmca3=M12345678&cvosrc=email.Newsletter.M12345678&cvo_campaign=000026UJ)\n", "\n", "This dataset includes a large number of metrics. Start by familiarizing yourself with the types of metrics in the database: [https://data.cityofchicago.org/api/assets/AAD41A13-BE8A-4E67-B1F5-86E711E09D5F?download=true](https://data.cityofchicago.org/api/assets/AAD41A13-BE8A-4E67-B1F5-86E711E09D5F?utm_medium=Exinfluencer&utm_source=Exinfluencer&utm_content=000026UJ&utm_term=10006555&utm_id=NA-SkillsNetwork-Channel-SkillsNetworkCoursesIBMDeveloperSkillsNetworkDB0201ENSkillsNetwork20127838-2022-01-01&download=true&cm_mmc=Email_Newsletter-\\_-Developer_Ed%2BTech-\\_-WW_WW-\\_-SkillsNetwork-Courses-IBMDeveloperSkillsNetwork-DB0201EN-SkillsNetwork-20127838&cm_mmca1=000026UJ&cm_mmca2=10006555&cm_mmca3=M12345678&cvosrc=email.Newsletter.M12345678&cvo_campaign=000026UJ)\n", "\n", "**NOTE**:\n", "\n", "Do not download the dataset directly from City of Chicago portal. Instead download a static copy which is a more database friendly version from this link.\n", "\n", "Now review some of its contents.\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Store the dataset in a Table\n", "\n", "In many cases the dataset to be analyzed is available as a .CSV (comma separated values) file, perhaps on the internet. To analyze the data using SQL, it first needs to be stored in the database.\n", "\n", "While it is easier to read the dataset into a Pandas dataframe and then PERSIST it into the database as we saw in the previous lab, it results in mapping to default datatypes which may not be optimal for SQL querying. For example a long textual field may map to a CLOB instead of a VARCHAR.\n", "\n", "Therefore, **it is highly recommended to manually load the table using the database console LOAD tool, as indicated in Week 2 Lab 1 Part II**. The only difference with that lab is that in Step 5 of the instructions you will need to click on create \"(+) New Table\" and specify the name of the table you want to create and then click \"Next\".\n", "\n", "##### Now open the Db2 console, open the LOAD tool, Select / Drag the .CSV file for the CHICAGO PUBLIC SCHOOLS dataset and load the dataset into a new table called **SCHOOLS**.\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Connect to the database\n", "\n", "Let us now load the ipython-sql extension and establish a connection with the database\n", "\n", "The following modules are pre-installed in the Skills Network Labs environment. However if you run this notebook commands in a different Jupyter environment (e.g. Watson Studio or Ananconda) you may need to install these libraries by removing the `#` sign before `!pip` in the code cell below.\n" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "# These libraries are pre-installed in SN Labs. If running in another environment please uncomment lines below to install them:\n", "# !pip install --force-reinstall ibm_db==3.1.0 ibm_db_sa==0.3.3\n", "# Ensure we don't load_ext with sqlalchemy>=1.4 (incompadible)\n", "# !pip uninstall sqlalchemy==1.4 -y && pip install sqlalchemy==1.3.24\n", "# !pip install ipython-sql" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "%load_ext sql" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "'Connected: cnv39734@BLUDB'" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Enter the connection string for your Db2 on Cloud database instance below\n", "# %sql ibm_db_sa://my-username:my-password@my-hostname:my-port/my-db-name?security=SSL\n", "%sql ibm_db_sa://" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Query the database system catalog to retrieve table metadata\n", "\n", "##### You can verify that the table creation was successful by retrieving the list of all tables in your schema and checking whether the SCHOOLS table was created\n" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * ibm_db_sa://cnv39734:***@1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud:32286/BLUDB\n", "Done.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
tabschematabnameownerownertypeTYPEstatusbase_tabschemabase_tabnamerowtypeschemarowtypenamecreate_timealter_timeinvalidate_timestats_timecolcounttableidtbspaceidcardnpagesmpagesfpagesnpartitionsnfilestablesizeoverflowtbspaceindex_tbspacelong_tbspaceparentschildrenselfrefskeycolumnskeyindexidkeyuniquecheckcountdatacaptureconst_checkedpmap_idpartition_modelog_attributepctfreeappend_modeREFRESHrefresh_timeLOCKSIZEVOLATILErow_formatpropertystatistics_profilecompressionrowcompmodeaccess_modeclusteredactive_blocksdroprulemaxfreespacesearchavgcompressedrowsizeavgrowcompressionratioavgrowsizepctrowscompressedlogindexbuildcodepagecollationschemacollationnamecollationschema_orderbycollationname_orderbyencoding_schemepctpagessavedlast_regen_timesecpolicyidprotectiongranularityauditpolicyidauditpolicynameauditexceptionenableddefineroncommitloggedonrollbacklastusedcontroltemporaltypetableorgextended_row_sizepctextendedrowsremarks
CNV39734SCHOOLSCNV39734UTNNoneNoneNoneNone2022-08-06 12:10:30.6284502022-08-06 12:10:30.6284502022-08-06 12:10:30.628450None7816932-1-1-1-1-1-1-1-1CNV39734SPACE1NoneNone0000000NYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY1 0-1N NoneR N                                NoneN FNone-1N999-1-1.0-1-1.0None1208SYSIBMIDENTITYSYSIBMIDENTITY -12022-08-06 12:10:30.6284500 NoneNoneNCNV39734 0001-01-01 NRN-1.0None
" ], "text/plain": [ "[('CNV39734', 'SCHOOLS', 'CNV39734', 'U', 'T', 'N', None, None, None, None, datetime.datetime(2022, 8, 6, 12, 10, 30, 628450), datetime.datetime(2022, 8, 6, 12, 10, 30, 628450), datetime.datetime(2022, 8, 6, 12, 10, 30, 628450), None, 78, 16, 932, -1, -1, -1, -1, -1, -1, -1, -1, 'CNV39734SPACE1', None, None, 0, 0, 0, 0, 0, 0, 0, 'N', 'YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY', 1, ' ', '0', -1, 'N', ' ', None, 'R', ' ', 'N', ' ', None, 'N', ' ', 'F', None, -1, 'N', 999, -1, -1.0, -1, -1.0, None, 1208, 'SYSIBM', 'IDENTITY', 'SYSIBM', 'IDENTITY', ' ', -1, datetime.datetime(2022, 8, 6, 12, 10, 30, 628450), 0, ' ', None, None, 'N', 'CNV39734', ' ', ' ', ' ', datetime.date(1, 1, 1), ' ', 'N', 'R', 'N', -1.0, None)]" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# type in your query to retrieve list of all tables in the database for your db2 schema (username)\n", "%sql SELECT * FROM SYSCAT.TABLES WHERE TABNAME = 'SCHOOLS'" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for a hint\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for the solution.\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Query the database system catalog to retrieve column metadata\n", "\n", "##### The SCHOOLS table contains a large number of columns. How many columns does this table have?\n" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * ibm_db_sa://cnv39734:***@1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud:32286/BLUDB\n", "Done.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
tabschematabnamecolnamecolnotypeschematypenamelengthscaletypestringunitsstringunitslengthDEFAULTNULLScodepagecollationschemacollationnameloggedcompactcolcardhigh2keylow2keyavgcollenkeyseqpartkeyseqnquantilesnmostfreqnumnullstarget_typeschematarget_typenamescope_tabschemascope_tabnamesource_tabschemasource_tabnamedl_featuresspecial_propshiddeninline_lengthpctinlinedIDENTITYrowchangetimestampGENERATEDtextcompressavgdistinctperpagepagevarianceratiosub_countsub_delim_lengthavgcollencharimplicitvalueseclabelnamerowbeginrowendtransactionstartidpctencodedavgencodedcollenqualifierfunc_pathranddistkeyremarks
CNV39734SCHOOLSSCHOOL_ID0SYSIBM INTEGER40NoneNoneNoneY0NoneNone -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSNAME_OF_SCHOOL1SYSIBM VARCHAR640OCTETS64NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSElementary, Middle, or High School2SYSIBM VARCHAR20OCTETS2NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSSTREET_ADDRESS3SYSIBM VARCHAR290OCTETS29NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSCITY4SYSIBM VARCHAR70OCTETS7NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSSTATE5SYSIBM VARCHAR20OCTETS2NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSZIP_CODE6SYSIBM INTEGER40NoneNoneNoneY0NoneNone -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSPHONE_NUMBER7SYSIBM VARCHAR140OCTETS14NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSLINK8SYSIBM VARCHAR780OCTETS78NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSNETWORK_MANAGER9SYSIBM VARCHAR400OCTETS40NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSCOLLABORATIVE_NAME10SYSIBM VARCHAR340OCTETS34NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSADEQUATE_YEARLY_PROGRESS_MADE_11SYSIBM VARCHAR30OCTETS3NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSTRACK_SCHEDULE12SYSIBM VARCHAR120OCTETS12NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSCPS_PERFORMANCE_POLICY_STATUS13SYSIBM VARCHAR160OCTETS16NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSCPS_PERFORMANCE_POLICY_LEVEL14SYSIBM VARCHAR150OCTETS15NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSHEALTHY_SCHOOL_CERTIFIED15SYSIBM VARCHAR30OCTETS3NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSSAFETY_ICON16SYSIBM VARCHAR110OCTETS11NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSSAFETY_SCORE17SYSIBM SMALLINT20NoneNoneNoneY0NoneNone -1\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSFAMILY_INVOLVEMENT_ICON18SYSIBM VARCHAR110OCTETS11NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSFAMILY_INVOLVEMENT_SCORE19SYSIBM VARCHAR30OCTETS3NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSENVIRONMENT_ICON20SYSIBM VARCHAR110OCTETS11NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSENVIRONMENT_SCORE21SYSIBM SMALLINT20NoneNoneNoneY0NoneNone -1\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSINSTRUCTION_ICON22SYSIBM VARCHAR110OCTETS11NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSINSTRUCTION_SCORE23SYSIBM SMALLINT20NoneNoneNoneY0NoneNone -1\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSLEADERS_ICON24SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSLEADERS_SCORE25SYSIBM VARCHAR30OCTETS3NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSTEACHERS_ICON26SYSIBM VARCHAR110OCTETS11NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSTEACHERS_SCORE27SYSIBM VARCHAR30OCTETS3NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSPARENT_ENGAGEMENT_ICON28SYSIBM VARCHAR70OCTETS7NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSPARENT_ENGAGEMENT_SCORE29SYSIBM VARCHAR30OCTETS3NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSPARENT_ENVIRONMENT_ICON30SYSIBM VARCHAR70OCTETS7NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSPARENT_ENVIRONMENT_SCORE31SYSIBM VARCHAR30OCTETS3NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSAVERAGE_STUDENT_ATTENDANCE32SYSIBM VARCHAR60OCTETS6NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSRATE_OF_MISCONDUCTS__PER_100_STUDENTS_33SYSIBM DECIMAL51NoneNoneNoneY0NoneNone -1\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSAVERAGE_TEACHER_ATTENDANCE34SYSIBM VARCHAR60OCTETS6NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSINDIVIDUALIZED_EDUCATION_PROGRAM_COMPLIANCE_RATE35SYSIBM VARCHAR70OCTETS7NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSPK_2_LITERACY__36SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSPK_2_MATH__37SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSGR3_5_GRADE_LEVEL_MATH__38SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSGR3_5_GRADE_LEVEL_READ__39SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSGR3_5_KEEP_PACE_READ__40SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSGR3_5_KEEP_PACE_MATH__41SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSGR6_8_GRADE_LEVEL_MATH__42SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSGR6_8_GRADE_LEVEL_READ__43SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSGR6_8_KEEP_PACE_MATH_44SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSGR6_8_KEEP_PACE_READ__45SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSGR_8_EXPLORE_MATH__46SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSGR_8_EXPLORE_READ__47SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSISAT_EXCEEDING_MATH__48SYSIBM DECIMAL41NoneNoneNoneY0NoneNone -1\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSISAT_EXCEEDING_READING__49SYSIBM DECIMAL41NoneNoneNoneY0NoneNone -1\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSISAT_VALUE_ADD_MATH50SYSIBM DECIMAL31NoneNoneNoneY0NoneNone -1\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSISAT_VALUE_ADD_READ51SYSIBM DECIMAL31NoneNoneNoneY0NoneNone -1\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSISAT_VALUE_ADD_COLOR_MATH52SYSIBM VARCHAR60OCTETS6NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSISAT_VALUE_ADD_COLOR_READ53SYSIBM VARCHAR60OCTETS6NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSSTUDENTS_TAKING__ALGEBRA__54SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSSTUDENTS_PASSING__ALGEBRA__55SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLS9th Grade EXPLORE (2009)56SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLS9th Grade EXPLORE (2010)57SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLS10th Grade PLAN (2009)58SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLS10th Grade PLAN (2010)59SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSNET_CHANGE_EXPLORE_AND_PLAN60SYSIBM VARCHAR30OCTETS3NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLS11th Grade Average ACT (2011)61SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSNET_CHANGE_PLAN_AND_ACT62SYSIBM VARCHAR30OCTETS3NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSCOLLEGE_ELIGIBILITY__63SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSGRADUATION_RATE__64SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSCOLLEGE_ENROLLMENT_RATE__65SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSCOLLEGE_ENROLLMENT66SYSIBM SMALLINT20NoneNoneNoneY0NoneNone -1\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSGENERAL_SERVICES_ROUTE67SYSIBM SMALLINT20NoneNoneNoneY0NoneNone -1\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSFRESHMAN_ON_TRACK_RATE__68SYSIBM VARCHAR40OCTETS4NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSX_COORDINATE69SYSIBM DECIMAL133NoneNoneNoneY0NoneNone -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSY_COORDINATE70SYSIBM DECIMAL133NoneNoneNoneY0NoneNone -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSLATITUDE71SYSIBM DECIMAL188NoneNoneNoneY0NoneNone -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSLONGITUDE72SYSIBM DECIMAL188NoneNoneNoneY0NoneNone -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSCOMMUNITY_AREA_NUMBER73SYSIBM SMALLINT20NoneNoneNoneY0NoneNone -1\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSCOMMUNITY_AREA_NAME74SYSIBM VARCHAR220OCTETS22NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSWARD75SYSIBM SMALLINT20NoneNoneNoneY0NoneNone -1\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSPOLICE_DISTRICT76SYSIBM SMALLINT20NoneNoneNoneY0NoneNone -1\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
CNV39734SCHOOLSLOCATION77SYSIBM VARCHAR270OCTETS27NoneY1208SYSIBMIDENTITY -1\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000-1None0-1-1-1NoneNoneNoneNoneNoneNoneNoneNone 0-1NN NoneONone-1.0-1-1-1NoneNoneNNN-1-1.0NoneNoneNNone
" ], "text/plain": [ "[('CNV39734', 'SCHOOLS', 'SCHOOL_ID', 0, 'SYSIBM ', 'INTEGER', 4, 0, None, None, None, 'Y', 0, None, None, ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'NAME_OF_SCHOOL', 1, 'SYSIBM ', 'VARCHAR', 64, 0, 'OCTETS', 64, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'Elementary, Middle, or High School', 2, 'SYSIBM ', 'VARCHAR', 2, 0, 'OCTETS', 2, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00', '\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'STREET_ADDRESS', 3, 'SYSIBM ', 'VARCHAR', 29, 0, 'OCTETS', 29, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'CITY', 4, 'SYSIBM ', 'VARCHAR', 7, 0, 'OCTETS', 7, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'STATE', 5, 'SYSIBM ', 'VARCHAR', 2, 0, 'OCTETS', 2, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00', '\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'ZIP_CODE', 6, 'SYSIBM ', 'INTEGER', 4, 0, None, None, None, 'Y', 0, None, None, ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'PHONE_NUMBER', 7, 'SYSIBM ', 'VARCHAR', 14, 0, 'OCTETS', 14, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'LINK', 8, 'SYSIBM ', 'VARCHAR', 78, 0, 'OCTETS', 78, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'NETWORK_MANAGER', 9, 'SYSIBM ', 'VARCHAR', 40, 0, 'OCTETS', 40, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'COLLABORATIVE_NAME', 10, 'SYSIBM ', 'VARCHAR', 34, 0, 'OCTETS', 34, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'ADEQUATE_YEARLY_PROGRESS_MADE_', 11, 'SYSIBM ', 'VARCHAR', 3, 0, 'OCTETS', 3, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00', '\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'TRACK_SCHEDULE', 12, 'SYSIBM ', 'VARCHAR', 12, 0, 'OCTETS', 12, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'CPS_PERFORMANCE_POLICY_STATUS', 13, 'SYSIBM ', 'VARCHAR', 16, 0, 'OCTETS', 16, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'CPS_PERFORMANCE_POLICY_LEVEL', 14, 'SYSIBM ', 'VARCHAR', 15, 0, 'OCTETS', 15, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'HEALTHY_SCHOOL_CERTIFIED', 15, 'SYSIBM ', 'VARCHAR', 3, 0, 'OCTETS', 3, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00', '\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'SAFETY_ICON', 16, 'SYSIBM ', 'VARCHAR', 11, 0, 'OCTETS', 11, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'SAFETY_SCORE', 17, 'SYSIBM ', 'SMALLINT', 2, 0, None, None, None, 'Y', 0, None, None, ' ', ' ', -1, '\\x00\\x00', '\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'FAMILY_INVOLVEMENT_ICON', 18, 'SYSIBM ', 'VARCHAR', 11, 0, 'OCTETS', 11, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'FAMILY_INVOLVEMENT_SCORE', 19, 'SYSIBM ', 'VARCHAR', 3, 0, 'OCTETS', 3, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00', '\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'ENVIRONMENT_ICON', 20, 'SYSIBM ', 'VARCHAR', 11, 0, 'OCTETS', 11, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'ENVIRONMENT_SCORE', 21, 'SYSIBM ', 'SMALLINT', 2, 0, None, None, None, 'Y', 0, None, None, ' ', ' ', -1, '\\x00\\x00', '\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'INSTRUCTION_ICON', 22, 'SYSIBM ', 'VARCHAR', 11, 0, 'OCTETS', 11, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'INSTRUCTION_SCORE', 23, 'SYSIBM ', 'SMALLINT', 2, 0, None, None, None, 'Y', 0, None, None, ' ', ' ', -1, '\\x00\\x00', '\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'LEADERS_ICON', 24, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'LEADERS_SCORE', 25, 'SYSIBM ', 'VARCHAR', 3, 0, 'OCTETS', 3, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00', '\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'TEACHERS_ICON', 26, 'SYSIBM ', 'VARCHAR', 11, 0, 'OCTETS', 11, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'TEACHERS_SCORE', 27, 'SYSIBM ', 'VARCHAR', 3, 0, 'OCTETS', 3, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00', '\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'PARENT_ENGAGEMENT_ICON', 28, 'SYSIBM ', 'VARCHAR', 7, 0, 'OCTETS', 7, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'PARENT_ENGAGEMENT_SCORE', 29, 'SYSIBM ', 'VARCHAR', 3, 0, 'OCTETS', 3, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00', '\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'PARENT_ENVIRONMENT_ICON', 30, 'SYSIBM ', 'VARCHAR', 7, 0, 'OCTETS', 7, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'PARENT_ENVIRONMENT_SCORE', 31, 'SYSIBM ', 'VARCHAR', 3, 0, 'OCTETS', 3, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00', '\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'AVERAGE_STUDENT_ATTENDANCE', 32, 'SYSIBM ', 'VARCHAR', 6, 0, 'OCTETS', 6, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'RATE_OF_MISCONDUCTS__PER_100_STUDENTS_', 33, 'SYSIBM ', 'DECIMAL', 5, 1, None, None, None, 'Y', 0, None, None, ' ', ' ', -1, '\\x00\\x00\\x00', '\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'AVERAGE_TEACHER_ATTENDANCE', 34, 'SYSIBM ', 'VARCHAR', 6, 0, 'OCTETS', 6, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'INDIVIDUALIZED_EDUCATION_PROGRAM_COMPLIANCE_RATE', 35, 'SYSIBM ', 'VARCHAR', 7, 0, 'OCTETS', 7, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'PK_2_LITERACY__', 36, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'PK_2_MATH__', 37, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'GR3_5_GRADE_LEVEL_MATH__', 38, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'GR3_5_GRADE_LEVEL_READ__', 39, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'GR3_5_KEEP_PACE_READ__', 40, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'GR3_5_KEEP_PACE_MATH__', 41, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'GR6_8_GRADE_LEVEL_MATH__', 42, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'GR6_8_GRADE_LEVEL_READ__', 43, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'GR6_8_KEEP_PACE_MATH_', 44, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'GR6_8_KEEP_PACE_READ__', 45, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'GR_8_EXPLORE_MATH__', 46, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'GR_8_EXPLORE_READ__', 47, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'ISAT_EXCEEDING_MATH__', 48, 'SYSIBM ', 'DECIMAL', 4, 1, None, None, None, 'Y', 0, None, None, ' ', ' ', -1, '\\x00\\x00\\x00', '\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'ISAT_EXCEEDING_READING__', 49, 'SYSIBM ', 'DECIMAL', 4, 1, None, None, None, 'Y', 0, None, None, ' ', ' ', -1, '\\x00\\x00\\x00', '\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'ISAT_VALUE_ADD_MATH', 50, 'SYSIBM ', 'DECIMAL', 3, 1, None, None, None, 'Y', 0, None, None, ' ', ' ', -1, '\\x00\\x00', '\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'ISAT_VALUE_ADD_READ', 51, 'SYSIBM ', 'DECIMAL', 3, 1, None, None, None, 'Y', 0, None, None, ' ', ' ', -1, '\\x00\\x00', '\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'ISAT_VALUE_ADD_COLOR_MATH', 52, 'SYSIBM ', 'VARCHAR', 6, 0, 'OCTETS', 6, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'ISAT_VALUE_ADD_COLOR_READ', 53, 'SYSIBM ', 'VARCHAR', 6, 0, 'OCTETS', 6, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'STUDENTS_TAKING__ALGEBRA__', 54, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'STUDENTS_PASSING__ALGEBRA__', 55, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', '9th Grade EXPLORE (2009)', 56, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', '9th Grade EXPLORE (2010)', 57, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', '10th Grade PLAN (2009)', 58, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', '10th Grade PLAN (2010)', 59, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'NET_CHANGE_EXPLORE_AND_PLAN', 60, 'SYSIBM ', 'VARCHAR', 3, 0, 'OCTETS', 3, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00', '\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', '11th Grade Average ACT (2011)', 61, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'NET_CHANGE_PLAN_AND_ACT', 62, 'SYSIBM ', 'VARCHAR', 3, 0, 'OCTETS', 3, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00', '\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'COLLEGE_ELIGIBILITY__', 63, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'GRADUATION_RATE__', 64, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'COLLEGE_ENROLLMENT_RATE__', 65, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'COLLEGE_ENROLLMENT', 66, 'SYSIBM ', 'SMALLINT', 2, 0, None, None, None, 'Y', 0, None, None, ' ', ' ', -1, '\\x00\\x00', '\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'GENERAL_SERVICES_ROUTE', 67, 'SYSIBM ', 'SMALLINT', 2, 0, None, None, None, 'Y', 0, None, None, ' ', ' ', -1, '\\x00\\x00', '\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'FRESHMAN_ON_TRACK_RATE__', 68, 'SYSIBM ', 'VARCHAR', 4, 0, 'OCTETS', 4, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'X_COORDINATE', 69, 'SYSIBM ', 'DECIMAL', 13, 3, None, None, None, 'Y', 0, None, None, ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'Y_COORDINATE', 70, 'SYSIBM ', 'DECIMAL', 13, 3, None, None, None, 'Y', 0, None, None, ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'LATITUDE', 71, 'SYSIBM ', 'DECIMAL', 18, 8, None, None, None, 'Y', 0, None, None, ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'LONGITUDE', 72, 'SYSIBM ', 'DECIMAL', 18, 8, None, None, None, 'Y', 0, None, None, ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'COMMUNITY_AREA_NUMBER', 73, 'SYSIBM ', 'SMALLINT', 2, 0, None, None, None, 'Y', 0, None, None, ' ', ' ', -1, '\\x00\\x00', '\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'COMMUNITY_AREA_NAME', 74, 'SYSIBM ', 'VARCHAR', 22, 0, 'OCTETS', 22, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'WARD', 75, 'SYSIBM ', 'SMALLINT', 2, 0, None, None, None, 'Y', 0, None, None, ' ', ' ', -1, '\\x00\\x00', '\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'POLICE_DISTRICT', 76, 'SYSIBM ', 'SMALLINT', 2, 0, None, None, None, 'Y', 0, None, None, ' ', ' ', -1, '\\x00\\x00', '\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None),\n", " ('CNV39734', 'SCHOOLS', 'LOCATION', 77, 'SYSIBM ', 'VARCHAR', 27, 0, 'OCTETS', 27, None, 'Y', 1208, 'SYSIBM', 'IDENTITY', ' ', ' ', -1, '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', '\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00', -1, None, 0, -1, -1, -1, None, None, None, None, None, None, None, None, ' ', 0, -1, 'N', 'N', ' ', None, 'O', None, -1.0, -1, -1, -1, None, None, 'N', 'N', 'N', -1, -1.0, None, None, 'N', None)]" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# type in your query to retrieve the number of columns in the SCHOOLS table\n", "%sql SELECT * FROM SYSCAT.COLUMNS WHERE TABNAME = 'SCHOOLS'" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for a hint\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for the solution.\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Now retrieve the the list of columns in SCHOOLS table and their column type (datatype) and length.\n" ] }, { "cell_type": "code", "execution_count": 9, "metadata": { "tags": [] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * ibm_db_sa://cnv39734:***@1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud:32286/BLUDB\n", "Done.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
colnametypenamelength
SCHOOL_IDINTEGER4
NAME_OF_SCHOOLVARCHAR64
Elementary, Middle, or High SchoolVARCHAR2
STREET_ADDRESSVARCHAR29
CITYVARCHAR7
STATEVARCHAR2
ZIP_CODEINTEGER4
PHONE_NUMBERVARCHAR14
LINKVARCHAR78
NETWORK_MANAGERVARCHAR40
COLLABORATIVE_NAMEVARCHAR34
ADEQUATE_YEARLY_PROGRESS_MADE_VARCHAR3
TRACK_SCHEDULEVARCHAR12
CPS_PERFORMANCE_POLICY_STATUSVARCHAR16
CPS_PERFORMANCE_POLICY_LEVELVARCHAR15
HEALTHY_SCHOOL_CERTIFIEDVARCHAR3
SAFETY_ICONVARCHAR11
SAFETY_SCORESMALLINT2
FAMILY_INVOLVEMENT_ICONVARCHAR11
FAMILY_INVOLVEMENT_SCOREVARCHAR3
ENVIRONMENT_ICONVARCHAR11
ENVIRONMENT_SCORESMALLINT2
INSTRUCTION_ICONVARCHAR11
INSTRUCTION_SCORESMALLINT2
LEADERS_ICONVARCHAR4
LEADERS_SCOREVARCHAR3
TEACHERS_ICONVARCHAR11
TEACHERS_SCOREVARCHAR3
PARENT_ENGAGEMENT_ICONVARCHAR7
PARENT_ENGAGEMENT_SCOREVARCHAR3
PARENT_ENVIRONMENT_ICONVARCHAR7
PARENT_ENVIRONMENT_SCOREVARCHAR3
AVERAGE_STUDENT_ATTENDANCEVARCHAR6
RATE_OF_MISCONDUCTS__PER_100_STUDENTS_DECIMAL5
AVERAGE_TEACHER_ATTENDANCEVARCHAR6
INDIVIDUALIZED_EDUCATION_PROGRAM_COMPLIANCE_RATEVARCHAR7
PK_2_LITERACY__VARCHAR4
PK_2_MATH__VARCHAR4
GR3_5_GRADE_LEVEL_MATH__VARCHAR4
GR3_5_GRADE_LEVEL_READ__VARCHAR4
GR3_5_KEEP_PACE_READ__VARCHAR4
GR3_5_KEEP_PACE_MATH__VARCHAR4
GR6_8_GRADE_LEVEL_MATH__VARCHAR4
GR6_8_GRADE_LEVEL_READ__VARCHAR4
GR6_8_KEEP_PACE_MATH_VARCHAR4
GR6_8_KEEP_PACE_READ__VARCHAR4
GR_8_EXPLORE_MATH__VARCHAR4
GR_8_EXPLORE_READ__VARCHAR4
ISAT_EXCEEDING_MATH__DECIMAL4
ISAT_EXCEEDING_READING__DECIMAL4
ISAT_VALUE_ADD_MATHDECIMAL3
ISAT_VALUE_ADD_READDECIMAL3
ISAT_VALUE_ADD_COLOR_MATHVARCHAR6
ISAT_VALUE_ADD_COLOR_READVARCHAR6
STUDENTS_TAKING__ALGEBRA__VARCHAR4
STUDENTS_PASSING__ALGEBRA__VARCHAR4
9th Grade EXPLORE (2009)VARCHAR4
9th Grade EXPLORE (2010)VARCHAR4
10th Grade PLAN (2009)VARCHAR4
10th Grade PLAN (2010)VARCHAR4
NET_CHANGE_EXPLORE_AND_PLANVARCHAR3
11th Grade Average ACT (2011)VARCHAR4
NET_CHANGE_PLAN_AND_ACTVARCHAR3
COLLEGE_ELIGIBILITY__VARCHAR4
GRADUATION_RATE__VARCHAR4
COLLEGE_ENROLLMENT_RATE__VARCHAR4
COLLEGE_ENROLLMENTSMALLINT2
GENERAL_SERVICES_ROUTESMALLINT2
FRESHMAN_ON_TRACK_RATE__VARCHAR4
X_COORDINATEDECIMAL13
Y_COORDINATEDECIMAL13
LATITUDEDECIMAL18
LONGITUDEDECIMAL18
COMMUNITY_AREA_NUMBERSMALLINT2
COMMUNITY_AREA_NAMEVARCHAR22
WARDSMALLINT2
POLICE_DISTRICTSMALLINT2
LOCATIONVARCHAR27
" ], "text/plain": [ "[('SCHOOL_ID', 'INTEGER', 4),\n", " ('NAME_OF_SCHOOL', 'VARCHAR', 64),\n", " ('Elementary, Middle, or High School', 'VARCHAR', 2),\n", " ('STREET_ADDRESS', 'VARCHAR', 29),\n", " ('CITY', 'VARCHAR', 7),\n", " ('STATE', 'VARCHAR', 2),\n", " ('ZIP_CODE', 'INTEGER', 4),\n", " ('PHONE_NUMBER', 'VARCHAR', 14),\n", " ('LINK', 'VARCHAR', 78),\n", " ('NETWORK_MANAGER', 'VARCHAR', 40),\n", " ('COLLABORATIVE_NAME', 'VARCHAR', 34),\n", " ('ADEQUATE_YEARLY_PROGRESS_MADE_', 'VARCHAR', 3),\n", " ('TRACK_SCHEDULE', 'VARCHAR', 12),\n", " ('CPS_PERFORMANCE_POLICY_STATUS', 'VARCHAR', 16),\n", " ('CPS_PERFORMANCE_POLICY_LEVEL', 'VARCHAR', 15),\n", " ('HEALTHY_SCHOOL_CERTIFIED', 'VARCHAR', 3),\n", " ('SAFETY_ICON', 'VARCHAR', 11),\n", " ('SAFETY_SCORE', 'SMALLINT', 2),\n", " ('FAMILY_INVOLVEMENT_ICON', 'VARCHAR', 11),\n", " ('FAMILY_INVOLVEMENT_SCORE', 'VARCHAR', 3),\n", " ('ENVIRONMENT_ICON', 'VARCHAR', 11),\n", " ('ENVIRONMENT_SCORE', 'SMALLINT', 2),\n", " ('INSTRUCTION_ICON', 'VARCHAR', 11),\n", " ('INSTRUCTION_SCORE', 'SMALLINT', 2),\n", " ('LEADERS_ICON', 'VARCHAR', 4),\n", " ('LEADERS_SCORE', 'VARCHAR', 3),\n", " ('TEACHERS_ICON', 'VARCHAR', 11),\n", " ('TEACHERS_SCORE', 'VARCHAR', 3),\n", " ('PARENT_ENGAGEMENT_ICON', 'VARCHAR', 7),\n", " ('PARENT_ENGAGEMENT_SCORE', 'VARCHAR', 3),\n", " ('PARENT_ENVIRONMENT_ICON', 'VARCHAR', 7),\n", " ('PARENT_ENVIRONMENT_SCORE', 'VARCHAR', 3),\n", " ('AVERAGE_STUDENT_ATTENDANCE', 'VARCHAR', 6),\n", " ('RATE_OF_MISCONDUCTS__PER_100_STUDENTS_', 'DECIMAL', 5),\n", " ('AVERAGE_TEACHER_ATTENDANCE', 'VARCHAR', 6),\n", " ('INDIVIDUALIZED_EDUCATION_PROGRAM_COMPLIANCE_RATE', 'VARCHAR', 7),\n", " ('PK_2_LITERACY__', 'VARCHAR', 4),\n", " ('PK_2_MATH__', 'VARCHAR', 4),\n", " ('GR3_5_GRADE_LEVEL_MATH__', 'VARCHAR', 4),\n", " ('GR3_5_GRADE_LEVEL_READ__', 'VARCHAR', 4),\n", " ('GR3_5_KEEP_PACE_READ__', 'VARCHAR', 4),\n", " ('GR3_5_KEEP_PACE_MATH__', 'VARCHAR', 4),\n", " ('GR6_8_GRADE_LEVEL_MATH__', 'VARCHAR', 4),\n", " ('GR6_8_GRADE_LEVEL_READ__', 'VARCHAR', 4),\n", " ('GR6_8_KEEP_PACE_MATH_', 'VARCHAR', 4),\n", " ('GR6_8_KEEP_PACE_READ__', 'VARCHAR', 4),\n", " ('GR_8_EXPLORE_MATH__', 'VARCHAR', 4),\n", " ('GR_8_EXPLORE_READ__', 'VARCHAR', 4),\n", " ('ISAT_EXCEEDING_MATH__', 'DECIMAL', 4),\n", " ('ISAT_EXCEEDING_READING__', 'DECIMAL', 4),\n", " ('ISAT_VALUE_ADD_MATH', 'DECIMAL', 3),\n", " ('ISAT_VALUE_ADD_READ', 'DECIMAL', 3),\n", " ('ISAT_VALUE_ADD_COLOR_MATH', 'VARCHAR', 6),\n", " ('ISAT_VALUE_ADD_COLOR_READ', 'VARCHAR', 6),\n", " ('STUDENTS_TAKING__ALGEBRA__', 'VARCHAR', 4),\n", " ('STUDENTS_PASSING__ALGEBRA__', 'VARCHAR', 4),\n", " ('9th Grade EXPLORE (2009)', 'VARCHAR', 4),\n", " ('9th Grade EXPLORE (2010)', 'VARCHAR', 4),\n", " ('10th Grade PLAN (2009)', 'VARCHAR', 4),\n", " ('10th Grade PLAN (2010)', 'VARCHAR', 4),\n", " ('NET_CHANGE_EXPLORE_AND_PLAN', 'VARCHAR', 3),\n", " ('11th Grade Average ACT (2011)', 'VARCHAR', 4),\n", " ('NET_CHANGE_PLAN_AND_ACT', 'VARCHAR', 3),\n", " ('COLLEGE_ELIGIBILITY__', 'VARCHAR', 4),\n", " ('GRADUATION_RATE__', 'VARCHAR', 4),\n", " ('COLLEGE_ENROLLMENT_RATE__', 'VARCHAR', 4),\n", " ('COLLEGE_ENROLLMENT', 'SMALLINT', 2),\n", " ('GENERAL_SERVICES_ROUTE', 'SMALLINT', 2),\n", " ('FRESHMAN_ON_TRACK_RATE__', 'VARCHAR', 4),\n", " ('X_COORDINATE', 'DECIMAL', 13),\n", " ('Y_COORDINATE', 'DECIMAL', 13),\n", " ('LATITUDE', 'DECIMAL', 18),\n", " ('LONGITUDE', 'DECIMAL', 18),\n", " ('COMMUNITY_AREA_NUMBER', 'SMALLINT', 2),\n", " ('COMMUNITY_AREA_NAME', 'VARCHAR', 22),\n", " ('WARD', 'SMALLINT', 2),\n", " ('POLICE_DISTRICT', 'SMALLINT', 2),\n", " ('LOCATION', 'VARCHAR', 27)]" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# type in your query to retrieve all column names in the SCHOOLS table along with their datatypes and length\n", "%sql select COLNAME, TYPENAME, LENGTH from SYSCAT.COLUMNS where TABNAME = 'SCHOOLS'" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for the solution.\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Questions\n", "\n", "1. Is the column name for the \"SCHOOL ID\" attribute in upper or mixed case?\n", "2. What is the name of \"Community Area Name\" column in your table? Does it have spaces?\n", "3. Are there any columns in whose names the spaces and paranthesis (round brackets) have been replaced by the underscore character \"\\_\"?\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Problems\n", "\n", "### Problem 1\n", "\n", "##### How many Elementary Schools are in the dataset?\n" ] }, { "cell_type": "code", "execution_count": 13, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * ibm_db_sa://cnv39734:***@1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud:32286/BLUDB\n", "Done.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
1
442
" ], "text/plain": [ "[(442,)]" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%sql SELECT COUNT(NAME_OF_SCHOOL) FROM SCHOOLS WHERE NAME_OF_SCHOOL like '%Elementary%'" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * ibm_db_sa://cnv39734:***@1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud:32286/BLUDB\n", "Done.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
1
462
" ], "text/plain": [ "[(462,)]" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%sql SELECT COUNT(NAME_OF_SCHOOL) FROM SCHOOLS WHERE \"Elementary, Middle, or High School\" = 'ES'" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for a hint\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for another hint\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for the solution.\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Problem 2\n", "\n", "##### What is the highest Safety Score?\n" ] }, { "cell_type": "code", "execution_count": 14, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * ibm_db_sa://cnv39734:***@1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud:32286/BLUDB\n", "Done.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
1
99
" ], "text/plain": [ "[(99,)]" ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%sql SELECT MAX(SAFETY_SCORE) FROM SCHOOLS " ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for a hint\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for the solution.\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Problem 3\n", "\n", "##### Which schools have highest Safety Score?\n" ] }, { "cell_type": "code", "execution_count": 15, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * ibm_db_sa://cnv39734:***@1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud:32286/BLUDB\n", "Done.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
name_of_school
Abraham Lincoln Elementary School
Alexander Graham Bell Elementary School
Annie Keller Elementary Gifted Magnet School
Augustus H Burley Elementary School
Edgar Allan Poe Elementary Classical School
Edgebrook Elementary School
Ellen Mitchell Elementary School
James E McDade Elementary Classical School
James G Blaine Elementary School
LaSalle Elementary Language Academy
Mary E Courtenay Elementary Language Arts Center
Northside College Preparatory High School
Northside Learning Center High School
Norwood Park Elementary School
Oriole Park Elementary School
Sauganash Elementary School
Stephen Decatur Classical Elementary School
Talman Elementary School
Wildwood Elementary School
" ], "text/plain": [ "[('Abraham Lincoln Elementary School',),\n", " ('Alexander Graham Bell Elementary School',),\n", " ('Annie Keller Elementary Gifted Magnet School',),\n", " ('Augustus H Burley Elementary School',),\n", " ('Edgar Allan Poe Elementary Classical School',),\n", " ('Edgebrook Elementary School',),\n", " ('Ellen Mitchell Elementary School',),\n", " ('James E McDade Elementary Classical School',),\n", " ('James G Blaine Elementary School',),\n", " ('LaSalle Elementary Language Academy',),\n", " ('Mary E Courtenay Elementary Language Arts Center',),\n", " ('Northside College Preparatory High School',),\n", " ('Northside Learning Center High School',),\n", " ('Norwood Park Elementary School',),\n", " ('Oriole Park Elementary School',),\n", " ('Sauganash Elementary School',),\n", " ('Stephen Decatur Classical Elementary School',),\n", " ('Talman Elementary School',),\n", " ('Wildwood Elementary School',)]" ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%sql SELECT NAME_OF_SCHOOL FROM SCHOOLS WHERE SAFETY_SCORE = (SELECT MAX(SAFETY_SCORE) FROM SCHOOLS)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for the solution.\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Problem 4\n", "\n", "##### What are the top 10 schools with the highest \"Average Student Attendance\"?\n" ] }, { "cell_type": "code", "execution_count": 19, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * ibm_db_sa://cnv39734:***@1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud:32286/BLUDB\n", "Done.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
name_of_schoolaverage_student_attendance
John Charles Haines Elementary School98.40%
James Ward Elementary School97.80%
Edgar Allan Poe Elementary Classical School97.60%
Orozco Fine Arts & Sciences Elementary School97.60%
Rachel Carson Elementary School97.60%
Annie Keller Elementary Gifted Magnet School97.50%
Andrew Jackson Elementary Language Academy97.40%
Lenart Elementary Regional Gifted Center97.40%
Disney II Magnet School97.30%
John H Vanderpoel Elementary Magnet School97.20%
" ], "text/plain": [ "[('John Charles Haines Elementary School', '98.40%'),\n", " ('James Ward Elementary School', '97.80%'),\n", " ('Edgar Allan Poe Elementary Classical School', '97.60%'),\n", " ('Orozco Fine Arts & Sciences Elementary School', '97.60%'),\n", " ('Rachel Carson Elementary School', '97.60%'),\n", " ('Annie Keller Elementary Gifted Magnet School', '97.50%'),\n", " ('Andrew Jackson Elementary Language Academy', '97.40%'),\n", " ('Lenart Elementary Regional Gifted Center', '97.40%'),\n", " ('Disney II Magnet School', '97.30%'),\n", " ('John H Vanderpoel Elementary Magnet School', '97.20%')]" ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%sql SELECT NAME_OF_SCHOOL, AVERAGE_STUDENT_ATTENDANCE FROM SCHOOLS ORDER BY AVERAGE_STUDENT_ATTENDANCE DESC nulls last LIMIT 10" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for the solution.\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Problem 5\n", "\n", "##### Retrieve the list of 5 Schools with the lowest Average Student Attendance sorted in ascending order based on attendance\n" ] }, { "cell_type": "code", "execution_count": 22, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * ibm_db_sa://cnv39734:***@1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud:32286/BLUDB\n", "Done.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
name_of_schoolaverage_student_attendance
Richard T Crane Technical Preparatory High School57.90%
Barbara Vick Early Childhood & Family Center60.90%
Dyett High School62.50%
Wendell Phillips Academy High School63.00%
Orr Academy High School66.30%
" ], "text/plain": [ "[('Richard T Crane Technical Preparatory High School', '57.90%'),\n", " ('Barbara Vick Early Childhood & Family Center', '60.90%'),\n", " ('Dyett High School', '62.50%'),\n", " ('Wendell Phillips Academy High School', '63.00%'),\n", " ('Orr Academy High School', '66.30%')]" ] }, "execution_count": 22, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%sql SELECT NAME_OF_SCHOOL, AVERAGE_STUDENT_ATTENDANCE FROM SCHOOLS ORDER BY AVERAGE_STUDENT_ATTENDANCE fetch first 5 rows only" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for the solution.\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Problem 6\n", "\n", "##### Now remove the '%' sign from the above result set for Average Student Attendance column\n" ] }, { "cell_type": "code", "execution_count": 23, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * ibm_db_sa://cnv39734:***@1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud:32286/BLUDB\n", "Done.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
name_of_school2
Richard T Crane Technical Preparatory High School57.90
Barbara Vick Early Childhood & Family Center60.90
Dyett High School62.50
Wendell Phillips Academy High School63.00
Orr Academy High School66.30
" ], "text/plain": [ "[('Richard T Crane Technical Preparatory High School', '57.90'),\n", " ('Barbara Vick Early Childhood & Family Center', '60.90'),\n", " ('Dyett High School', '62.50'),\n", " ('Wendell Phillips Academy High School', '63.00'),\n", " ('Orr Academy High School', '66.30')]" ] }, "execution_count": 23, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%sql SELECT NAME_OF_SCHOOL, REPLACE(AVERAGE_STUDENT_ATTENDANCE,'%','') FROM SCHOOLS ORDER BY AVERAGE_STUDENT_ATTENDANCE fetch first 5 rows only" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for a hint\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for the solution.\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Problem 7\n", "\n", "##### Which Schools have Average Student Attendance lower than 70%?\n" ] }, { "cell_type": "code", "execution_count": 26, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * ibm_db_sa://cnv39734:***@1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud:32286/BLUDB\n", "Done.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
name_of_schoolaverage_student_attendance
Richard T Crane Technical Preparatory High School57.90%
Barbara Vick Early Childhood & Family Center60.90%
Dyett High School62.50%
Wendell Phillips Academy High School63.00%
Orr Academy High School66.30%
Manley Career Academy High School66.80%
Chicago Vocational Career Academy High School68.80%
Roberto Clemente Community Academy High School69.60%
" ], "text/plain": [ "[('Richard T Crane Technical Preparatory High School', '57.90%'),\n", " ('Barbara Vick Early Childhood & Family Center', '60.90%'),\n", " ('Dyett High School', '62.50%'),\n", " ('Wendell Phillips Academy High School', '63.00%'),\n", " ('Orr Academy High School', '66.30%'),\n", " ('Manley Career Academy High School', '66.80%'),\n", " ('Chicago Vocational Career Academy High School', '68.80%'),\n", " ('Roberto Clemente Community Academy High School', '69.60%')]" ] }, "execution_count": 26, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%sql SELECT NAME_OF_SCHOOL, AVERAGE_STUDENT_ATTENDANCE FROM SCHOOLS WHERE CAST ( REPLACE(Average_Student_Attendance, '%', '') AS DOUBLE ) < 70 ORDER BY AVERAGE_STUDENT_ATTENDANCE" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for a hint\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for another hint\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for the solution.\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Problem 8\n", "\n", "##### Get the total College Enrollment for each Community Area\n" ] }, { "cell_type": "code", "execution_count": 32, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * ibm_db_sa://cnv39734:***@1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud:32286/BLUDB\n", "Done.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
1community_area_name
6864ALBANY PARK
4823ARCHER HEIGHTS
1458ARMOUR SQUARE
6483ASHBURN
4175AUBURN GRESHAM
10933AUSTIN
1522AVALON PARK
3640AVONDALE
14386BELMONT CRAGIN
1636BEVERLY
3167BRIDGEPORT
9647BRIGHTON PARK
549BURNSIDE
1568CALUMET HEIGHTS
5042CHATHAM
7086CHICAGO LAWN
2085CLEARING
4670DOUGLAS
4568DUNNING
5337EAST GARFIELD PARK
5305EAST SIDE
4600EDGEWATER
910EDISON PARK
6832ENGLEWOOD
1431FOREST GLEN
531FULLER PARK
9915GAGE PARK
4552GARFIELD RIDGE
2809GRAND BOULEVARD
4051GREATER GRAND CROSSING
963HEGEWISCH
3975HERMOSA
8620HUMBOLDT PARK
1930HYDE PARK
7764IRVING PARK
1755JEFFERSON PARK
4287KENWOOD
7055LAKE VIEW
5615LINCOLN PARK
4132LINCOLN SQUARE
7351LOGAN SQUARE
871LOOP
7257LOWER WEST SIDE
1552MCKINLEY PARK
1317MONTCLARE
3271MORGAN PARK
2091MOUNT GREENWOOD
3362NEAR NORTH SIDE
1378NEAR SOUTH SIDE
7975NEAR WEST SIDE
7922NEW CITY
7541NORTH CENTER
5146NORTH LAWNDALE
4210NORTH PARK
6469NORWOOD PARK
140OAKLAND
786OHARE
6954PORTAGE PARK
1620PULLMAN
1547RIVERDALE
4068ROGERS PARK
7020ROSELAND
4043SOUTH CHICAGO
1859SOUTH DEERING
14793SOUTH LAWNDALE
4543SOUTH SHORE
4388UPTOWN
4006WASHINGTON HEIGHTS
2648WASHINGTON PARK
3700WEST ELSDON
5946WEST ENGLEWOOD
2622WEST GARFIELD PARK
4207WEST LAWN
3240WEST PULLMAN
8197WEST RIDGE
9429WEST TOWN
4206WOODLAWN
" ], "text/plain": [ "[(6864, 'ALBANY PARK'),\n", " (4823, 'ARCHER HEIGHTS'),\n", " (1458, 'ARMOUR SQUARE'),\n", " (6483, 'ASHBURN'),\n", " (4175, 'AUBURN GRESHAM'),\n", " (10933, 'AUSTIN'),\n", " (1522, 'AVALON PARK'),\n", " (3640, 'AVONDALE'),\n", " (14386, 'BELMONT CRAGIN'),\n", " (1636, 'BEVERLY'),\n", " (3167, 'BRIDGEPORT'),\n", " (9647, 'BRIGHTON PARK'),\n", " (549, 'BURNSIDE'),\n", " (1568, 'CALUMET HEIGHTS'),\n", " (5042, 'CHATHAM'),\n", " (7086, 'CHICAGO LAWN'),\n", " (2085, 'CLEARING'),\n", " (4670, 'DOUGLAS'),\n", " (4568, 'DUNNING'),\n", " (5337, 'EAST GARFIELD PARK'),\n", " (5305, 'EAST SIDE'),\n", " (4600, 'EDGEWATER'),\n", " (910, 'EDISON PARK'),\n", " (6832, 'ENGLEWOOD'),\n", " (1431, 'FOREST GLEN'),\n", " (531, 'FULLER PARK'),\n", " (9915, 'GAGE PARK'),\n", " (4552, 'GARFIELD RIDGE'),\n", " (2809, 'GRAND BOULEVARD'),\n", " (4051, 'GREATER GRAND CROSSING'),\n", " (963, 'HEGEWISCH'),\n", " (3975, 'HERMOSA'),\n", " (8620, 'HUMBOLDT PARK'),\n", " (1930, 'HYDE PARK'),\n", " (7764, 'IRVING PARK'),\n", " (1755, 'JEFFERSON PARK'),\n", " (4287, 'KENWOOD'),\n", " (7055, 'LAKE VIEW'),\n", " (5615, 'LINCOLN PARK'),\n", " (4132, 'LINCOLN SQUARE'),\n", " (7351, 'LOGAN SQUARE'),\n", " (871, 'LOOP'),\n", " (7257, 'LOWER WEST SIDE'),\n", " (1552, 'MCKINLEY PARK'),\n", " (1317, 'MONTCLARE'),\n", " (3271, 'MORGAN PARK'),\n", " (2091, 'MOUNT GREENWOOD'),\n", " (3362, 'NEAR NORTH SIDE'),\n", " (1378, 'NEAR SOUTH SIDE'),\n", " (7975, 'NEAR WEST SIDE'),\n", " (7922, 'NEW CITY'),\n", " (7541, 'NORTH CENTER'),\n", " (5146, 'NORTH LAWNDALE'),\n", " (4210, 'NORTH PARK'),\n", " (6469, 'NORWOOD PARK'),\n", " (140, 'OAKLAND'),\n", " (786, 'OHARE'),\n", " (6954, 'PORTAGE PARK'),\n", " (1620, 'PULLMAN'),\n", " (1547, 'RIVERDALE'),\n", " (4068, 'ROGERS PARK'),\n", " (7020, 'ROSELAND'),\n", " (4043, 'SOUTH CHICAGO'),\n", " (1859, 'SOUTH DEERING'),\n", " (14793, 'SOUTH LAWNDALE'),\n", " (4543, 'SOUTH SHORE'),\n", " (4388, 'UPTOWN'),\n", " (4006, 'WASHINGTON HEIGHTS'),\n", " (2648, 'WASHINGTON PARK'),\n", " (3700, 'WEST ELSDON'),\n", " (5946, 'WEST ENGLEWOOD'),\n", " (2622, 'WEST GARFIELD PARK'),\n", " (4207, 'WEST LAWN'),\n", " (3240, 'WEST PULLMAN'),\n", " (8197, 'WEST RIDGE'),\n", " (9429, 'WEST TOWN'),\n", " (4206, 'WOODLAWN')]" ] }, "execution_count": 32, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%sql SELECT SUM(COLLEGE_ENROLLMENT), COMMUNITY_AREA_NAME FROM SCHOOLS GROUP BY COMMUNITY_AREA_NAME" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for a hint\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for another hint\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for the solution.\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Problem 9\n", "\n", "##### Get the 5 Community Areas with the least total College Enrollment sorted in ascending order\n" ] }, { "cell_type": "code", "execution_count": 33, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * ibm_db_sa://cnv39734:***@1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud:32286/BLUDB\n", "Done.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
total_enrollmentcommunity_area_name
140OAKLAND
531FULLER PARK
549BURNSIDE
786OHARE
871LOOP
" ], "text/plain": [ "[(140, 'OAKLAND'),\n", " (531, 'FULLER PARK'),\n", " (549, 'BURNSIDE'),\n", " (786, 'OHARE'),\n", " (871, 'LOOP')]" ] }, "execution_count": 33, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%sql SELECT TOTAL_ENROLLMENT, COMMUNITY_AREA_NAME FROM (SELECT SUM(COLLEGE_ENROLLMENT) AS TOTAL_ENROLLMENT, COMMUNITY_AREA_NAME FROM SCHOOLS GROUP BY COMMUNITY_AREA_NAME) ORDER BY TOTAL_ENROLLMENT LIMIT 5" ] }, { "cell_type": "code", "execution_count": 35, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * ibm_db_sa://cnv39734:***@1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud:32286/BLUDB\n", "Done.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
total_enrollmentcommunity_area_name
140OAKLAND
531FULLER PARK
549BURNSIDE
786OHARE
871LOOP
" ], "text/plain": [ "[(140, 'OAKLAND'),\n", " (531, 'FULLER PARK'),\n", " (549, 'BURNSIDE'),\n", " (786, 'OHARE'),\n", " (871, 'LOOP')]" ] }, "execution_count": 35, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%sql SELECT SUM(COLLEGE_ENROLLMENT) AS TOTAL_ENROLLMENT, COMMUNITY_AREA_NAME FROM SCHOOLS GROUP BY COMMUNITY_AREA_NAME ORDER BY TOTAL_ENROLLMENT LIMIT 5" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for a hint\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for the solution.\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Problem 10\n", "\n", "##### List 5 schools with lowest safety score.\n" ] }, { "cell_type": "code", "execution_count": 36, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * ibm_db_sa://cnv39734:***@1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud:32286/BLUDB\n", "Done.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
name_of_schoolsafety_score
Edmond Burke Elementary School1
Luke O'Toole Elementary School5
George W Tilton Elementary School6
Foster Park Elementary School11
Emil G Hirsch Metropolitan High School13
" ], "text/plain": [ "[('Edmond Burke Elementary School', 1),\n", " (\"Luke O'Toole Elementary School\", 5),\n", " ('George W Tilton Elementary School', 6),\n", " ('Foster Park Elementary School', 11),\n", " ('Emil G Hirsch Metropolitan High School', 13)]" ] }, "execution_count": 36, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%sql SELECT NAME_OF_SCHOOL, SAFETY_SCORE FROM SCHOOLS ORDER BY SAFETY_SCORE LIMIT 5" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for the solution.\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Problem 11\n", "\n", "##### Get the hardship index for the community area which has College Enrollment of 4368\n" ] }, { "cell_type": "code", "execution_count": 52, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * ibm_db_sa://cnv39734:***@1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud:32286/BLUDB\n", "Done.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
community_area_namehardship_index
UPTOWN20.0
" ], "text/plain": [ "[('UPTOWN', 20.0)]" ] }, "execution_count": 52, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%%sql \n", "\n", "SELECT A.COMMUNITY_AREA_NAME, B.HARDSHIP_INDEX \n", " FROM (SELECT SUM(COLLEGE_ENROLLMENT) AS TOTAL_ENROLLMENT, COMMUNITY_AREA_NAME FROM SCHOOLS GROUP BY COMMUNITY_AREA_NAME) A, CHICAGO_SOCIOECONOMIC_DATA B \n", " WHERE UPPER(A.COMMUNITY_AREA_NAME) = UPPER(B.COMMUNITY_AREA_NAME) AND TOTAL_ENROLLMENT=4388" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for the solution.\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Problem 12\n", "\n", "##### Get the hardship index for the community area which has the school with the highest enrollment.\n" ] }, { "cell_type": "code", "execution_count": 53, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * ibm_db_sa://cnv39734:***@1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud:32286/BLUDB\n", "(ibm_db_dbi.ProgrammingError) ibm_db_dbi::ProgrammingError: SQLNumResultCols failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0119N An expression starting with \"COMMUNITY_AREA_NAME\" specified in a SELECT clause, HAVING clause, or ORDER BY clause is not specified in the GROUP BY clause or it is in a SELECT clause, HAVING clause, or ORDER BY clause with a column function and no GROUP BY clause is specified. SQLSTATE=42803 SQLCODE=-119\n", "[SQL: SELECT A.COMMUNITY_AREA_NAME, B.HARDSHIP_INDEX \n", " FROM (SELECT MAX(COLLEGE_ENROLLMENT), COMMUNITY_AREA_NAME FROM SCHOOLS) A, CHICAGO_SOCIOECONOMIC_DATA B \n", " WHERE UPPER(A.COMMUNITY_AREA_NAME) = UPPER(B.COMMUNITY_AREA_NAME) AND TOTAL_ENROLLMENT=4388]\n", "(Background on this error at: http://sqlalche.me/e/13/f405)\n" ] } ], "source": [ "%%sql \n", "\n", "SELECT A.COMMUNITY_AREA_NAME, B.HARDSHIP_INDEX \n", " FROM (SELECT MAX(COLLEGE_ENROLLMENT), COMMUNITY_AREA_NAME FROM SCHOOLS) A, CHICAGO_SOCIOECONOMIC_DATA B \n", " WHERE UPPER(A.COMMUNITY_AREA_NAME) = UPPER(B.COMMUNITY_AREA_NAME) AND TOTAL_ENROLLMENT=4388" ] }, { "cell_type": "code", "execution_count": 57, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * ibm_db_sa://cnv39734:***@1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud:32286/BLUDB\n", "Done.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
community_area_namehardship_index
NORTH CENTER6.0
" ], "text/plain": [ "[('NORTH CENTER', 6.0)]" ] }, "execution_count": 57, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%%sql SELECT A.COMMUNITY_AREA_NAME, B.HARDSHIP_INDEX FROM SCHOOLS A, CHICAGO_SOCIOECONOMIC_DATA B \n", " WHERE UPPER(A.COMMUNITY_AREA_NAME) = UPPER(B.COMMUNITY_AREA_NAME) AND COLLEGE_ENROLLMENT=(SELECT MAX(COLLEGE_ENROLLMENT) FROM SCHOOLS)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Double-click **here** for the solution.\n", "\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Summary\n", "\n", "##### In this lab you learned how to work with a real word dataset using SQL and Python. You learned how to query columns with spaces or special characters in their names and with mixed case names. You also used built in database functions and practiced how to sort, limit, and order result sets, as well as used sub-queries and worked with multiple tables.\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Author\n", "\n", "Rav Ahuja\n", "\n", "## Change Log\n", "\n", "| Date (YYYY-MM-DD) | Version | Changed By | Change Description |\n", "| ----------------- | ------- | ----------------- | ----------------------------------------- |\n", "| 2021-07-09 | 2.4 | Malika | Updated connection string |\n", "| 2021-05-19 | 2.3 | Lakshmi Holla | Updated question |\n", "| 2021-04-20 | 2.2 | Malika | Added the libraries |\n", "| 2020-11-27 | 2.1 | Sannareddy Ramesh | Modified data sets and added new problems |\n", "| 2020-08-28 | 2.0 | Lavanya | Moved lab to course repo in GitLab |\n", "\n", "
\n", "\n", "##

© IBM Corporation 2020. All rights reserved.

\n" ] } ], "metadata": { "celltoolbar": "Raw Cell Format", "kernelspec": { "display_name": "Python 3.8.9 64-bit", "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.9" }, "vscode": { "interpreter": { "hash": "31f2aee4e71d21fbe5cf8b01ff0e069b9275f58929596ceb00d14d90e3e16cd6" } }, "widgets": { "state": {}, "version": "1.1.2" } }, "nbformat": 4, "nbformat_minor": 4 }