Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: BUILDING
|   BUILDING IRN | BUILDING NAME                                        |   DISTRICT IRN | DISTRICT NAME                                        | ADDRESS                   | CITY      | STATE   | ZIP CODE   | PHONE          | PRINCIPAL            | COUNTY   | GRADE SPAN   | INDICATORS MET GRADE   | PERFORMANCE INDEX SCORE GRADE   | 4-YEAR GRADUATION RATE GRADE   | 5-YEAR GRADUATION RATE GRADE   | OVERALL VALUE-ADDED GRADE   | GIFTED VALUE-ADDED GRADE   | LOWEST 20% VALUE-ADDED GRADE   | SWD VALUE-ADDED GRADE   | AMO GRADE   | K-3 LITERACY IMPROVEMENT GRADE   | ACHIEVEMENT COMPONENT GRADE   | GRADUATION COMPONENT GRADE   | PROGRESS COMPONENT GRADE   | GAP CLOSING COMPONENT GRADE   | K-3 LITERACY IMPROVEMENT GRADE_1   | PREPARED FOR SUCCESS GRADE   |   Num INDICATORS MET GRADE |   Num PERFORMANCE INDEX SCORE GRADE |   Num 4-YEAR GRADUATION RATE GRADE |   Num 5-YEAR GRADUATION RATE GRADE |   Num OVERALL VALUE-ADDED GRADE |   Num GIFTED VALUE-ADDED GRADE |   Num LOWEST 20% VALUE-ADDED GRADE |   Num SWD VALUE-ADDED GRADE |   Num AMO GRADE |   Num K-3 LITERACY IMPROVEMENT GRADE |   Num ACHIEVEMENT COMPONENT GRADE |   Num GRADUATION COMPONENT GRADE |   Num PROGRESS COMPONENT GRADE |   Num GAP CLOSING COMPONENT GRADE |   Num K-3 LITERACY IMPROVEMENT GRADE_1 |   Num PREPARED FOR SUCCESS GRADE |   OVERALL SCORE | CityState     |
|---------------:|:-----------------------------------------------------|---------------:|:-----------------------------------------------------|:--------------------------|:----------|:--------|:-----------|:---------------|:---------------------|:---------|:-------------|:-----------------------|:--------------------------------|:-------------------------------|:-------------------------------|:----------------------------|:---------------------------|:-------------------------------|:------------------------|:------------|:---------------------------------|:------------------------------|:-----------------------------|:---------------------------|:------------------------------|:-----------------------------------|:-----------------------------|---------------------------:|------------------------------------:|-----------------------------------:|-----------------------------------:|--------------------------------:|-------------------------------:|-----------------------------------:|----------------------------:|----------------:|-------------------------------------:|----------------------------------:|---------------------------------:|-------------------------------:|----------------------------------:|---------------------------------------:|---------------------------------:|----------------:|:--------------|
|          13254 | Akron Preparatory School                             |          13254 | Akron Preparatory School                             | 1200 E Market St Ste 3360 | Akron     | OH      | 44305-4018 | (330) 247-6232 | Zack Kantouros       | Summit   | K-12         | F                      | D                               | NR                             | NR                             | B                           | NR                         | C                              | NR                      | F           | D                                | D                             | NR                           | B                          | F                             | D                                  | NR                           |                          1 |                                   2 |                                  0 |                                  0 |                               4 |                              0 |                                  3 |                           0 |               1 |                                    2 |                                 2 |                                0 |                              4 |                                 1 |                                      2 |                                0 |         2.2     | Akron, OH     |
|            843 | Bennett Venture Academy                              |            843 | Bennett Venture Academy                              | 5130 Bennett Road         | Toledo    | OH      | 43612      | (419) 269-2247 | Luis R. Calderon     | Lucas    | K-8          | F                      | D                               | NR                             | NR                             | D                           | NR                         | C                              | A                       | F           | F                                | D                             | NR                           | C                          | F                             | F                                  | NR                           |                          1 |                                   2 |                                  0 |                                  0 |                               2 |                              0 |                                  3 |                           5 |               1 |                                    1 |                                 2 |                                0 |                              3 |                                 1 |                                      1 |                                0 |         2       | Toledo, OH    |
|            557 | Columbus Arts & Technology Academy                   |            557 | Columbus Arts & Technology Academy                   | 2255 Kimberly Pkwy E      | Columbus  | OH      | 43232-7210 | (614) 577-0900 | Derrick R. Shelton   | Franklin | K-12         | F                      | D                               | NR                             | NR                             | C                           | NR                         | C                              | NR                      | F           | NR                               | D                             | NR                           | C                          | F                             | NR                                 | NR                           |                          1 |                                   2 |                                  0 |                                  0 |                               3 |                              0 |                                  3 |                           0 |               1 |                                    0 |                                 2 |                                0 |                              3 |                                 1 |                                      0 |                                0 |         2       | Columbus, OH  |
|           9122 | Columbus Collegiate Academy                          |           9122 | Columbus Collegiate Academy                          | 1469 E Main St            | Columbus  | OH      | 43205-2152 | (614) 299-5284 | Melissa C. Barrett   | Franklin | 6-8          | F                      | D                               | NR                             | NR                             | A                           | NR                         | A                              | B                       | F           | NR                               | D                             | NR                           | A                          | F                             | NR                                 | NR                           |                          1 |                                   2 |                                  0 |                                  0 |                               5 |                              0 |                                  5 |                           4 |               1 |                                    0 |                                 2 |                                0 |                              5 |                                 1 |                                      0 |                                0 |         2.88889 | Columbus, OH  |
|          12951 | Columbus Collegiate Academy - West                   |          12951 | Columbus Collegiate Academy - West                   | 300 Dana Ave              | Columbus  | OH      | 43223-1310 | (614) 545-9570 | Nathan G. Parker     | Franklin | 6-8          | F                      | D                               | NR                             | NR                             | B                           | NR                         | A                              | C                       | F           | NR                               | D                             | NR                           | B                          | F                             | NR                                 | NR                           |                          1 |                                   2 |                                  0 |                                  0 |                               4 |                              0 |                                  5 |                           3 |               1 |                                    0 |                                 2 |                                0 |                              4 |                                 1 |                                      0 |                                0 |         2.55556 | Columbus, OH  |
|            952 | Columbus Preparatory and Fitness Academy             |            952 | Columbus Preparatory and Fitness Academy             | 1258 Demorest Rd          | Columbus  | OH      | 43204-7003 | (614) 318-0606 | Jeffrey R. Luelleman | Franklin | K-8          | F                      | D                               | NR                             | NR                             | F                           | NR                         | F                              | D                       | F           | F                                | D                             | NR                           | D                          | F                             | F                                  | NR                           |                          1 |                                   2 |                                  0 |                                  0 |                               1 |                              0 |                                  1 |                           2 |               1 |                                    1 |                                 2 |                                0 |                              2 |                                 1 |                                      1 |                                0 |         1.36364 | Columbus, OH  |
|         132951 | Constellation Schools: Lorain Community Elementary   |         132951 | Constellation Schools: Lorain Community Elementary   | 5983 W 54th St            | Parma     | OH      | 44129-3854 | (440) 204-2130 | Melisa R. Shady      | Cuyahoga | K-4          | F                      | D                               | NR                             | NR                             | F                           | NR                         | C                              | C                       | F           | F                                | D                             | NR                           | D                          | F                             | F                                  | NR                           |                          1 |                                   2 |                                  0 |                                  0 |                               1 |                              0 |                                  3 |                           3 |               1 |                                    1 |                                 2 |                                0 |                              2 |                                 1 |                                      1 |                                0 |         1.63636 | Parma, OH     |
|            321 | Constellation Schools: Old Brooklyn Community Middle |            321 | Constellation Schools: Old Brooklyn Community Middle | 5730 Broadview Rd         | Parma     | OH      | 44134-1602 | (216) 351-0280 | Cherie Kaiser        | Cuyahoga | 5-9          | F                      | D                               | NR                             | NR                             | F                           | NR                         | F                              | D                       | F           | NR                               | D                             | NR                           | D                          | F                             | NR                                 | NR                           |                          1 |                                   2 |                                  0 |                                  0 |                               1 |                              0 |                                  1 |                           2 |               1 |                                    0 |                                 2 |                                0 |                              2 |                                 1 |                                      0 |                                0 |         1.44444 | Parma, OH     |
|         143479 | Constellation Schools: Puritas Community Elementary  |         143479 | Constellation Schools: Puritas Community Elementary  | 15204 Puritas Ave         | Cleveland | OH      | 44135-2716 | (216) 688-0680 | Margaret M. Colwell  | Cuyahoga | K-4          | F                      | D                               | NR                             | NR                             | F                           | NR                         | D                              | NR                      | F           | D                                | D                             | NR                           | D                          | F                             | D                                  | NR                           |                          1 |                                   2 |                                  0 |                                  0 |                               1 |                              0 |                                  2 |                           0 |               1 |                                    2 |                                 2 |                                0 |                              2 |                                 1 |                                      2 |                                0 |         1.6     | Cleveland, OH |
|            534 | Constellation Schools: Puritas Community Middle      |            534 | Constellation Schools: Puritas Community Middle      | 5730 Broadview Rd         | Parma     | OH      | 44134-1602 | (216) 688-0680 | Margaret M. Colwell  | Cuyahoga | 5-9          | F                      | D                               | NR                             | NR                             | A                           | NR                         | A                              | NR                      | F           | NR                               | D                             | NR                           | A                          | F                             | NR                                 | NR                           |                          1 |                                   2 |                                  0 |                                  0 |                               5 |                              0 |                                  5 |                           0 |               1 |                                    0 |                                 2 |                                0 |                              5 |                                 1 |                                      0 |                                0 |         2.75    | Parma, OH     |


Table: DISTRICT
|   DISTRICT IRN | DISTRICT NAME                            | ADDRESS              | CITY        | STATE   | ZIP CODE   | PHONE          | SUPERINTENDENT     | COUNTY    | INDICATORS MET GRADE   | PERFORMANCE INDEX SCORE GRADE   | 4-YEAR GRADUATION RATE GRADE   | 5-YEAR GRADUATION RATE GRADE   | OVERALL VALUE-ADDED GRADE   | GIFTED VALUE-ADDED GRADE   | LOWEST 20% VALUE-ADDED GRADE   | SWD VALUE-ADDED GRADE   | AMO GRADE   | K-3 LITERACY IMPROVEMENT GRADE   | ACHIEVEMENT COMPONENT GRADE   | GRADUATION COMPONENT GRADE   | PROGRESS COMPONENT GRADE   | GAP CLOSING COMPONENT GRADE   | K-3 LITERACY COMPONENT GRADE   | PREPARED FOR SUCCESS GRADE   |   Num INDICATORS MET GRADE |   Num PERFORMANCE INDEX SCORE GRADE |   Num 4-YEAR GRADUATION RATE GRADE |   Num 5-YEAR GRADUATION RATE GRADE |   Num OVERALL VALUE-ADDED GRADE |   Num GIFTED VALUE-ADDED GRADE |   Num LOWEST 20% VALUE-ADDED GRADE |   Num SWD VALUE-ADDED GRADE |   Num AMO GRADE |   Num K-3 LITERACY IMPROVEMENT GRADE |   Num ACHIEVEMENT COMPONENT GRADE |   Num GRADUATION COMPONENT GRADE |   Num PROGRESS COMPONENT GRADE |   Num GAP CLOSING COMPONENT GRADE |   Num K-3 LITERACY COMPONENT GRADE |   Num PREPARED FOR SUCCESS GRADE |   OVERALL SCORE |   OVERALL SCORE STDDEV FROM MEAN |   2013 Typology |   Enrollment |   Median Income |   Student Poverty |   Pct. Minority | Full Descriptor                                                     | Major Grouping   | Poverty Category   | CityState       | District IRN Name                              |   FY12 Per Pupil |
|---------------:|:-----------------------------------------|:---------------------|:------------|:--------|:-----------|:---------------|:-------------------|:----------|:-----------------------|:--------------------------------|:-------------------------------|:-------------------------------|:----------------------------|:---------------------------|:-------------------------------|:------------------------|:------------|:---------------------------------|:------------------------------|:-----------------------------|:---------------------------|:------------------------------|:-------------------------------|:-----------------------------|---------------------------:|------------------------------------:|-----------------------------------:|-----------------------------------:|--------------------------------:|-------------------------------:|-----------------------------------:|----------------------------:|----------------:|-------------------------------------:|----------------------------------:|---------------------------------:|-------------------------------:|----------------------------------:|-----------------------------------:|---------------------------------:|----------------:|---------------------------------:|----------------:|-------------:|----------------:|------------------:|----------------:|:--------------------------------------------------------------------|:-----------------|:-------------------|:----------------|:-----------------------------------------------|-----------------:|
|            442 | Manchester Local                         | 130 Wayne Frye Dr    | Manchester  | OH      | 45144-9314 | (937) 549-4777 | Charles J. Shreve  | Adams     | F                      | D                               | A                              | A                              | A                           | NR                         | A                              | A                       | F           | NR                               | D                             | A                            | A                          | F                             | NR                             | D                            |                          1 |                                   2 |                                  5 |                                  5 |                               5 |                              0 |                                  5 |                           5 |               1 |                                    0 |                                 2 |                                5 |                              5 |                                 1 |                                  0 |                                2 |         3.38462 |                         0.88191  |               1 |      842.096 |           22901 |          0.732428 |       0.0308341 | Rural - High Student Poverty & Small Student Population             | Rural            | 60%-80%            | Manchester, OH  | Manchester Local-442                           |            15493 |
|          61903 | Adams County Ohio Valley Local           | 141 Lloyd Rd         | West Union  | OH      | 45693-8974 | (937) 544-5586 | Richard A. Seas    | Adams     | F                      | D                               | A                              | B                              | A                           | B                          | B                              | F                       | F           | F                                | D                             | B                            | B                          | F                             | F                              | D                            |                          1 |                                   2 |                                  5 |                                  4 |                               5 |                              4 |                                  4 |                           1 |               1 |                                    1 |                                 2 |                                4 |                              4 |                                 1 |                                  1 |                                2 |         2.625   |                        -0.227545 |               1 |     3962.16  |           25268 |          0.643098 |       0.0192887 | Rural - High Student Poverty & Small Student Population             | Rural            | 60%-80%            | West Union, OH  | Adams County Ohio Valley Local-61903           |             9872 |
|          45468 | Loudonville-Perrysville Exempted Village | 210 E Main St        | Loudonville | OH      | 44842-1245 | (419) 994-3912 | John E. Miller     | Ashland   | F                      | C                               | A                              | B                              | A                           | A                          | B                              | C                       | F           | F                                | C                             | A                            | B                          | F                             | F                              | D                            |                          1 |                                   3 |                                  5 |                                  4 |                               5 |                              5 |                                  4 |                           3 |               1 |                                    1 |                                 3 |                                5 |                              4 |                                 1 |                                  1 |                                2 |         3       |                         0.32016  |               1 |     1185.7   |           27227 |          0.455231 |       0.0265616 | Rural - High Student Poverty & Small Student Population             | Rural            | 40%-60%            | Loudonville, OH | Loudonville-Perrysville Exempted Village-45468 |            10918 |
|          49494 | Adena Local                              | 3367 County Road 550 | Frankfort   | OH      | 45628-9503 | (740) 998-4633 | John W. Balzer     | Ross      | F                      | D                               | C                              | B                              | C                           | B                          | D                              | D                       | F           | F                                | D                             | C                            | C                          | F                             | F                              | D                            |                          1 |                                   2 |                                  3 |                                  4 |                               3 |                              4 |                                  2 |                           2 |               1 |                                    1 |                                 2 |                                3 |                              3 |                                 1 |                                  1 |                                2 |         2.1875  |                        -0.866535 |               2 |     1230.11  |           31808 |          0.370236 |       0.0679032 | Rural - Average Student Poverty & Very Small Student Population     | Rural            | 20%-40%            | Frankfort, OH   | Adena Local-49494                              |             9332 |
|          45906 | Alexander Local                          | 6091 Ayers Rd        | Albany      | OH      | 45710-9492 | (740) 698-8831 | Lindy L. Douglas   | Athens    | F                      | D                               | A                              | A                              | D                           | C                          | B                              | C                       | F           | F                                | D                             | A                            | C                          | F                             | F                              | D                            |                          1 |                                   2 |                                  5 |                                  5 |                               2 |                              3 |                                  4 |                           3 |               1 |                                    1 |                                 2 |                                5 |                              3 |                                 1 |                                  1 |                                2 |         2.5625  |                        -0.318829 |               2 |     1631.79  |           30677 |          0.507845 |       0.0283032 | Rural - Average Student Poverty & Very Small Student Population     | Rural            | 40%-60%            | Albany, OH      | Alexander Local-45906                          |            10565 |
|          45773 | Elida Local                              | 4380 Sunnydale St    | Elida       | OH      | 45807-9593 | (419) 331-4155 | Joel W. Mengerink  | Allen     | F                      | C                               | D                              | B                              | A                           | A                          | D                              | D                       | F           | F                                | C                             | C                            | B                          | F                             | F                              | D                            |                          1 |                                   3 |                                  2 |                                  4 |                               5 |                              5 |                                  2 |                           2 |               1 |                                    1 |                                 3 |                                3 |                              4 |                                 1 |                                  1 |                                2 |         2.5     |                        -0.410114 |               4 |     2464.49  |           29976 |          0.470129 |       0.209112  | Small Town - High Student Poverty & Average Student Population Size | Small Town       | 40%-60%            | Elida, OH       | Elida Local-45773                              |             8398 |
|          46847 | Amanda-Clearcreek Local                  | 328 E Main St        | Amanda      | OH      | 43102-9330 | (740) 969-7250 | Jacalyn R. Osborne | Fairfield | F                      | C                               | A                              | C                              | A                           | A                          | A                              | A                       | F           | D                                | D                             | B                            | A                          | F                             | D                              | D                            |                          1 |                                   3 |                                  5 |                                  3 |                               5 |                              5 |                                  5 |                           5 |               1 |                                    2 |                                 2 |                                4 |                              5 |                                 1 |                                  2 |                                2 |         3.1875  |                         0.594013 |               2 |     1715.08  |           32649 |          0.345124 |       0.0233455 | Rural - Average Student Poverty & Very Small Student Population     | Rural            | 20%-40%            | Amanda, OH      | Amanda-Clearcreek Local-46847                  |             8215 |
|          44222 | Lima City                                | 755 Saint Johns Ave  | Lima        | OH      | 45804-1552 | (419) 996-3400 | Jill A. Ackerman   | Allen     | F                      | D                               | F                              | F                              | D                           | C                          | F                              | F                       | F           | F                                | F                             | F                            | D                          | F                             | F                              | F                            |                          1 |                                   2 |                                  1 |                                  1 |                               2 |                              3 |                                  1 |                           1 |               1 |                                    1 |                                 1 |                                1 |                              2 |                                 1 |                                  1 |                                1 |         1.3125  |                        -2.14451  |               7 |     4032.81  |           20747 |          0.808293 |       0.571315  | Urban - High Student Poverty & Average Student Population           | Urban            | >80%               | Lima, OH        | Lima City-44222                                |            13155 |
|          48975 | Put-In-Bay Local                         | PO Box 659           | Put In Bay  | OH      | 43456-0659 | (419) 285-3614 | Steven J. Poe      | Ottawa    | F                      | C                               | NR                             | NR                             | C                           | NR                         | NR                             | NR                      | F           | NR                               | D                             | NR                           | C                          | F                             | NR                             | NR                           |                          1 |                                   3 |                                  0 |                                  0 |                               3 |                              0 |                                  0 |                           0 |               1 |                                    0 |                                 2 |                                0 |                              3 |                                 1 |                                  0 |                                0 |         2       |                        -1.14039  |               0 |       71     |               0 |          0        |       0         | Island                                                              | Island           | <20%               | Put In Bay, OH  | Put-In-Bay Local-48975                         |            37154 |
|          45781 | Perry Local                              | 2770 E Breese Rd     | Lima        | OH      | 45806-9743 | (419) 221-2770 | Omer I. Schroeder  | Allen     | F                      | D                               | A                              | B                              | A                           | NR                         | C                              | C                       | F           | F                                | D                             | B                            | B                          | F                             | F                              | D                            |                          1 |                                   2 |                                  5 |                                  4 |                               5 |                              0 |                                  3 |                           3 |               1 |                                    1 |                                 2 |                                4 |                              4 |                                 1 |                                  1 |                                2 |         2.6     |                        -0.264059 |               4 |      831.8   |           25994 |          0.718862 |       0.328308  | Small Town - High Student Poverty & Average Student Population Size | Small Town       | 60%-80%            | Lima, OH        | Perry Local-45781                              |             9653 |


Table: Fiscal Years
| Fiscal Year   |   Sort |
|:--------------|-------:|
| FY95          |      1 |
| FY96          |      2 |
| FY97          |      3 |
| FY98          |      4 |
| FY99          |      5 |
| FY00          |      6 |
| FY01          |      7 |
| FY02          |      8 |
| FY03          |      9 |
| FY04          |     10 |


Table: iREADY
|   Student ID | Active   | Student Grade   | Academic Year   | School                         | Subject   |   Number of Diagnostics Completed during the time frame | Diagnostic Gain (Note: negative gains = zero. See Export Guide)   | Diagnostic: Start Date (Most Recent)   | Diagnostic: Completion Date (Most Recent)   | Diagnostic: Time on Task (min) (Most Recent)   | Diagnostic: Rush Flag (see Student Profile) (Most Recent)   | Diagnostic: Overall Scale Score (Most Recent)   | Diagnostic: Overall Placement (Most Recent)   | Diagnostic: Percentile (Most Recent)   | Diagnostic: Overall Relative Placement (Most Recent)   | Diagnostic: Start Date (1)   | Diagnostic: Completion Date (1)   | Diagnostic: Time on Task (min) (1)   | Diagnostic: Rush Flag (see Student Profile) (1)   | Diagnostic: Overall Scale Score (1)   | Diagnostic: Overall Placement (1)   | Diagnostic: Percentile (1)   | Diagnostic: Overall Relative Placement (1)   | Diagnostic: Start Date (2)   | Diagnostic: Completion Date (2)   | Diagnostic: Time on Task (min) (2)   | Diagnostic: Rush Flag (see Student Profile) (2)   | Diagnostic: Overall Scale Score (2)   | Diagnostic: Overall Placement (2)   | Diagnostic: Percentile (2)   | Diagnostic: Overall Relative Placement (2)   | Diagnostic: Start Date (3)   | Diagnostic: Completion Date (3)   | Diagnostic: Time on Task (min) (3)   | Diagnostic: Rush Flag (see Student Profile) (3)   | Diagnostic: Overall Scale Score (3)   | Diagnostic: Overall Placement (3)   | Diagnostic: Percentile (3)   | Diagnostic: Overall Relative Placement (3)   | Diagnostic: Start Date (4)   | Diagnostic: Completion Date (4)   | Diagnostic: Time on Task (min) (4)   | Diagnostic: Rush Flag (see Student Profile) (4)   | Diagnostic: Overall Scale Score (4)   | Diagnostic: Overall Placement (4)   | Diagnostic: Percentile (4)   | Diagnostic: Overall Relative Placement (4)   | Diagnostic: Start Date (5)   | Diagnostic: Completion Date (5)   | Diagnostic: Time on Task (min) (5)   | Diagnostic: Rush Flag (see Student Profile) (5)   | Diagnostic: Overall Scale Score (5)   | Diagnostic: Overall Placement (5)   | Diagnostic: Percentile (5)   | Diagnostic: Overall Relative Placement (5)   |
|-------------:|:---------|:----------------|:----------------|:-------------------------------|:----------|--------------------------------------------------------:|:------------------------------------------------------------------|:---------------------------------------|:--------------------------------------------|:-----------------------------------------------|:------------------------------------------------------------|:------------------------------------------------|:----------------------------------------------|:---------------------------------------|:-------------------------------------------------------|:-----------------------------|:----------------------------------|:-------------------------------------|:--------------------------------------------------|:--------------------------------------|:------------------------------------|:-----------------------------|:---------------------------------------------|:-----------------------------|:----------------------------------|:-------------------------------------|:--------------------------------------------------|:--------------------------------------|:------------------------------------|:-----------------------------|:---------------------------------------------|:-----------------------------|:----------------------------------|:-------------------------------------|:--------------------------------------------------|:--------------------------------------|:------------------------------------|:-----------------------------|:---------------------------------------------|:-----------------------------|:----------------------------------|:-------------------------------------|:--------------------------------------------------|:--------------------------------------|:------------------------------------|:-----------------------------|:---------------------------------------------|:-----------------------------|:----------------------------------|:-------------------------------------|:--------------------------------------------------|:--------------------------------------|:------------------------------------|:-----------------------------|:---------------------------------------------|
|       243562 | Active   | 6               | 2015-2016       | UNION ELEMENTARY MIDDLE SCHOOL | Math      |                                                       0 |                                                                   |                                        |                                             |                                                |                                                             |                                                 |                                               |                                        |                                                        |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |
|        11200 | Active   | K               | 2015-2016       | UNION ELEMENTARY MIDDLE SCHOOL | Math      |                                                       0 |                                                                   |                                        |                                             |                                                |                                                             |                                                 |                                               |                                        |                                                        |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |
|        10671 | Active   | 2               | 2015-2016       | UNION ELEMENTARY MIDDLE SCHOOL | Math      |                                                       0 |                                                                   |                                        |                                             |                                                |                                                             |                                                 |                                               |                                        |                                                        |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |
|       148246 | Active   | 6               | 2015-2016       | UNION ELEMENTARY MIDDLE SCHOOL | Math      |                                                       0 |                                                                   |                                        |                                             |                                                |                                                             |                                                 |                                               |                                        |                                                        |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |
|       148249 | Active   | 7               | 2015-2016       | UNION ELEMENTARY MIDDLE SCHOOL | Math      |                                                       0 |                                                                   |                                        |                                             |                                                |                                                             |                                                 |                                               |                                        |                                                        |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |
|       244459 | Active   | 6               | 2015-2016       | UNION ELEMENTARY MIDDLE SCHOOL | Math      |                                                       0 |                                                                   |                                        |                                             |                                                |                                                             |                                                 |                                               |                                        |                                                        |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |
|       245029 | Active   | 6               | 2015-2016       | UNION ELEMENTARY MIDDLE SCHOOL | Math      |                                                       0 |                                                                   |                                        |                                             |                                                |                                                             |                                                 |                                               |                                        |                                                        |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |
|       150646 | Active   | 7               | 2015-2016       | UNION ELEMENTARY MIDDLE SCHOOL | Math      |                                                       0 |                                                                   |                                        |                                             |                                                |                                                             |                                                 |                                               |                                        |                                                        |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |
|        10741 | Active   | 7               | 2015-2016       | UNION ELEMENTARY MIDDLE SCHOOL | Math      |                                                       0 |                                                                   |                                        |                                             |                                                |                                                             |                                                 |                                               |                                        |                                                        |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |
|        11724 | Active   | 1               | 2015-2016       | UNION ELEMENTARY MIDDLE SCHOOL | Math      |                                                       0 |                                                                   |                                        |                                             |                                                |                                                             |                                                 |                                               |                                        |                                                        |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |


Table: iREADYREADING
|   Student ID | Active   | Student Grade   | Academic Year   | School                         | Subject   |   Number of Diagnostics Completed during the time frame | Diagnostic Gain (Note: negative gains = zero. See Export Guide)   | Diagnostic: Start Date (Most Recent)   | Diagnostic: Completion Date (Most Recent)   | Diagnostic: Time on Task (min) (Most Recent)   | Diagnostic: Rush Flag (see Student Profile) (Most Recent)   | Diagnostic: Overall Scale Score (Most Recent)   | Diagnostic: Overall Placement (Most Recent)   | Diagnostic: Percentile (Most Recent)   | Diagnostic: Overall Relative Placement (Most Recent)   | Diagnostic: Start Date (1)   | Diagnostic: Completion Date (1)   | Diagnostic: Time on Task (min) (1)   | Diagnostic: Rush Flag (see Student Profile) (1)   | Diagnostic: Overall Scale Score (1)   | Diagnostic: Overall Placement (1)   | Diagnostic: Percentile (1)   | Diagnostic: Overall Relative Placement (1)   | Diagnostic: Start Date (2)   | Diagnostic: Completion Date (2)   | Diagnostic: Time on Task (min) (2)   | Diagnostic: Rush Flag (see Student Profile) (2)   | Diagnostic: Overall Scale Score (2)   | Diagnostic: Overall Placement (2)   | Diagnostic: Percentile (2)   | Diagnostic: Overall Relative Placement (2)   | Diagnostic: Start Date (3)   | Diagnostic: Completion Date (3)   | Diagnostic: Time on Task (min) (3)   | Diagnostic: Rush Flag (see Student Profile) (3)   | Diagnostic: Overall Scale Score (3)   | Diagnostic: Overall Placement (3)   | Diagnostic: Percentile (3)   | Diagnostic: Overall Relative Placement (3)   | Diagnostic: Start Date (4)   | Diagnostic: Completion Date (4)   | Diagnostic: Time on Task (min) (4)   | Diagnostic: Rush Flag (see Student Profile) (4)   | Diagnostic: Overall Scale Score (4)   | Diagnostic: Overall Placement (4)   | Diagnostic: Percentile (4)   | Diagnostic: Overall Relative Placement (4)   | Diagnostic: Start Date (5)   | Diagnostic: Completion Date (5)   | Diagnostic: Time on Task (min) (5)   | Diagnostic: Rush Flag (see Student Profile) (5)   | Diagnostic: Overall Scale Score (5)   | Diagnostic: Overall Placement (5)   | Diagnostic: Percentile (5)   | Diagnostic: Overall Relative Placement (5)   |
|-------------:|:---------|:----------------|:----------------|:-------------------------------|:----------|--------------------------------------------------------:|:------------------------------------------------------------------|:---------------------------------------|:--------------------------------------------|:-----------------------------------------------|:------------------------------------------------------------|:------------------------------------------------|:----------------------------------------------|:---------------------------------------|:-------------------------------------------------------|:-----------------------------|:----------------------------------|:-------------------------------------|:--------------------------------------------------|:--------------------------------------|:------------------------------------|:-----------------------------|:---------------------------------------------|:-----------------------------|:----------------------------------|:-------------------------------------|:--------------------------------------------------|:--------------------------------------|:------------------------------------|:-----------------------------|:---------------------------------------------|:-----------------------------|:----------------------------------|:-------------------------------------|:--------------------------------------------------|:--------------------------------------|:------------------------------------|:-----------------------------|:---------------------------------------------|:-----------------------------|:----------------------------------|:-------------------------------------|:--------------------------------------------------|:--------------------------------------|:------------------------------------|:-----------------------------|:---------------------------------------------|:-----------------------------|:----------------------------------|:-------------------------------------|:--------------------------------------------------|:--------------------------------------|:------------------------------------|:-----------------------------|:---------------------------------------------|
|       243562 | Active   | 6               | 2015-2016       | UNION ELEMENTARY MIDDLE SCHOOL | Reading   |                                                       0 |                                                                   |                                        |                                             |                                                |                                                             |                                                 |                                               |                                        |                                                        |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |
|        11200 | Active   | K               | 2015-2016       | UNION ELEMENTARY MIDDLE SCHOOL | Reading   |                                                       0 |                                                                   |                                        |                                             |                                                |                                                             |                                                 |                                               |                                        |                                                        |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |
|       193039 | Active   | 7               | 2015-2016       | EAST ELEMENTARY SCHOOL         | Reading   |                                                       0 |                                                                   |                                        |                                             |                                                |                                                             |                                                 |                                               |                                        |                                                        |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |
|        10671 | Active   | 2               | 2015-2016       | UNION ELEMENTARY MIDDLE SCHOOL | Reading   |                                                       0 |                                                                   |                                        |                                             |                                                |                                                             |                                                 |                                               |                                        |                                                        |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |
|       148246 | Active   | 6               | 2015-2016       | UNION ELEMENTARY MIDDLE SCHOOL | Reading   |                                                       0 |                                                                   |                                        |                                             |                                                |                                                             |                                                 |                                               |                                        |                                                        |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |
|       148249 | Active   | 7               | 2015-2016       | UNION ELEMENTARY MIDDLE SCHOOL | Reading   |                                                       0 |                                                                   |                                        |                                             |                                                |                                                             |                                                 |                                               |                                        |                                                        |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |
|       183204 | Active   | 7               | 2015-2016       | SOUTH ELEMENTARY SCHOOL        | Reading   |                                                       0 |                                                                   |                                        |                                             |                                                |                                                             |                                                 |                                               |                                        |                                                        |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |
|       244459 | Active   | 6               | 2015-2016       | UNION ELEMENTARY MIDDLE SCHOOL | Reading   |                                                       0 |                                                                   |                                        |                                             |                                                |                                                             |                                                 |                                               |                                        |                                                        |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |
|        70383 | Active   | 7               | 2015-2016       | SOUTH ELEMENTARY SCHOOL        | Reading   |                                                       0 |                                                                   |                                        |                                             |                                                |                                                             |                                                 |                                               |                                        |                                                        |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |
|       245029 | Active   | 6               | 2015-2016       | UNION ELEMENTARY MIDDLE SCHOOL | Reading   |                                                       0 |                                                                   |                                        |                                             |                                                |                                                             |                                                 |                                               |                                        |                                                        |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |                              |                                   |                                      |                                                   |                                       |                                     |                              |                                              |


Table: PerPupilAllRevenue (2)
|   IRN | Fiscal Year   |   Revenue Per Pupil |
|------:|:--------------|--------------------:|
|   442 | FY95          |                   0 |
| 61903 | FY95          |                5040 |
| 45757 | FY95          |                3681 |
| 45765 | FY95          |                4624 |
| 45211 | FY95          |                3994 |
| 43885 | FY95          |                4614 |
| 45773 | FY95          |                3969 |
| 44222 | FY95          |                5329 |
| 45781 | FY95          |                4774 |
| 45799 | FY95          |                4922 |


Table: PerPupilAllRevenue
|   IRN | DISTRICT             | COUNTY   |   FY95 |   FY96 |   FY97 |   FY98 |   FY99 |   FY00 |   FY01 |   FY02 |   FY03 |   FY04 |    FY05  |    FY06  |    FY07  |    FY08  |    FY09  |    FY10  |    FY11  |    FY12  |
|------:|:---------------------|:---------|-------:|-------:|-------:|-------:|-------:|-------:|-------:|-------:|-------:|-------:|---------:|---------:|---------:|---------:|---------:|---------:|---------:|---------:|
|   442 | Manchester Local SD  | Adams    |      0 |      0 |      0 |      0 |      0 |      0 |      0 |      0 |      0 |      0 |    15441 |    15179 |    15877 |    16813 |    17683 |    17683 |    16038 |    15493 |
| 61903 | Ohio Valley Local SD | Adams    |   5040 |   4856 |   5207 |   5468 |   5722 |   6026 |   6385 |   7362 |   7759 |   8084 |     8866 |     9232 |     9461 |     9782 |     9530 |     9582 |     9739 |     9872 |
| 45757 | Allen East Local SD  | Allen    |   3681 |   4128 |   4410 |   4467 |   5036 |   5245 |   5692 |   6037 |   6282 |   6536 |     7176 |     7762 |     8146 |     7278 |     6986 |     7293 |     8102 |     7899 |
| 45765 | Bath Local SD        | Allen    |   4624 |   4808 |   4849 |   4950 |   5161 |   5494 |   5920 |   6523 |   6739 |   6879 |     7551 |     8070 |     9690 |     8658 |     8598 |     8558 |     8579 |     8419 |
| 45211 | Bluffton Ex Vill SD  | Allen    |   3994 |   4095 |   3907 |   4315 |   4771 |   5216 |   5699 |   6571 |   6340 |   6777 |     7285 |     7508 |     8180 |     7928 |     7714 |     7780 |     7813 |     7536 |
| 43885 | Delphos City SD      | Allen    |   4614 |   4362 |   4837 |   4983 |   5324 |   5513 |   5968 |   6352 |   6621 |   6980 |     7864 |     8235 |     8507 |     8458 |     8495 |     8714 |     8493 |     9107 |
| 45773 | Elida Local SD       | Allen    |   3969 |   4050 |   4594 |   4943 |   5310 |   5434 |   5755 |   6183 |   6666 |   7203 |     7832 |     8153 |     8331 |     8809 |     8629 |     8463 |     8561 |     8398 |
| 44222 | Lima City SD         | Allen    |   5329 |   5576 |   5796 |   6078 |   6709 |   7062 |   7459 |   7668 |   8347 |   9389 |     9545 |    10196 |    10692 |    11346 |    12114 |    12034 |    12471 |    13155 |
| 45781 | Perry Local SD       | Allen    |   4774 |   4797 |   5582 |   5227 |   5585 |   5973 |   6629 |   6859 |   6885 |   7426 |     8302 |     8293 |     9110 |     8819 |     8489 |     9096 |     9273 |     9653 |
| 45799 | Shawnee Local SD     | Allen    |   4922 |   5493 |   5069 |   5072 |   5753 |   5722 |   5985 |   6705 |   6221 |   6881 |     7341 |     7992 |     8451 |     8340 |     9511 |     8671 |     8703 |     8702 |


Table: RAW STATE DATA
| Student     |   Grade | LEP   | IEP   | Primary Disability   | School   | Column8   | Column9   | Column10   | Column11   | Column12   | Column13   | Column14   | Column15   | Column16   | Test            |   Overall scaled score |   Overall performance level | Year      |
|:------------|--------:|:------|:------|:---------------------|:---------|:----------|:----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:----------------|-----------------------:|----------------------------:|:----------|
| Student2395 |       8 | N     | N     |                      | USMS     |           |           |            |            |            |            |            |            |            | Grade 8 Science |                    712 |                           3 | 2015-2016 |
| Student2398 |       8 | N     | N     |                      | USMS     |           |           |            |            |            |            |            |            |            | Grade 8 Science |                    702 |                           3 | 2015-2016 |
| Student2401 |       8 | N     | N     |                      | USMS     |           |           |            |            |            |            |            |            |            | Grade 8 Science |                    766 |                           5 | 2015-2016 |
| Student2404 |       8 | N     | N     |                      | USMS     |           |           |            |            |            |            |            |            |            | Grade 8 Science |                    722 |                           3 | 2015-2016 |
| Student2407 |       8 | N     | N     |                      | USMS     |           |           |            |            |            |            |            |            |            | Grade 8 Science |                    712 |                           3 | 2015-2016 |
| Student2410 |       8 | N     | N     |                      | USMS     |           |           |            |            |            |            |            |            |            | Grade 8 Science |                    748 |                           4 | 2015-2016 |
| Student2413 |       8 | N     | N     |                      | USMS     |           |           |            |            |            |            |            |            |            | Grade 8 Science |                    732 |                           4 | 2015-2016 |
| Student2416 |       8 | N     | N     |                      | USMS     |           |           |            |            |            |            |            |            |            | Grade 8 Science |                    755 |                           4 | 2015-2016 |
| Student2419 |       8 | N     | N     |                      | USMS     |           |           |            |            |            |            |            |            |            | Grade 8 Science |                    778 |                           5 | 2015-2016 |
| Student2422 |       8 | N     | N     |                      | USMS     |           |           |            |            |            |            |            |            |            | Grade 8 Science |                    742 |                           4 | 2015-2016 |


Table: TR_DORP_2016
|   BUILDING IRN | BUILDING NAME                                               |   DISTRICT IRN | DISTRICT NAME                                               | ADDRESS                  | CITY       | STATE   | ZIP CODE   | PHONE          | SUPERINTENDENT      | PRINCIPAL                | GRADE SPAN   | 12TH GRADE PASSAGE RATING   | AMO RATING              | 4-YEAR GRADUATION RATE RATING   | 5-YEAR GRADUATION RATE RATING   | 6-YEAR GRADUATION RATE RATING   | 7-YEAR GRADUATION RATE RATING   | 8-YEAR GRADUATION RATE RATING   | COMBINED GRADUATION RATING   | GROWTH RATING           | OVERALL RATING          |
|---------------:|:------------------------------------------------------------|---------------:|:------------------------------------------------------------|:-------------------------|:-----------|:--------|:-----------|:---------------|:--------------------|:-------------------------|:-------------|:----------------------------|:------------------------|:--------------------------------|:--------------------------------|:--------------------------------|:--------------------------------|:--------------------------------|:-----------------------------|:------------------------|:------------------------|
|          13249 | Academy for Urban Scholars Youngstown                       |          13249 | Academy for Urban Scholars Youngstown                       | 1350 5th Ave Ste 100 106 | Youngstown | OH      | 44504-1765 | (330) 744-9070 | Pamela Duckett      | (null)                   | 9-12,UNG     | Meets Standards             | Does Not Meet Standards | Meets Standards                 | Exceeds Standards               | Exceeds Standards               | NR                              | NR                              | Meets Standards              | Does Not Meet Standards | Does Not Meet Standards |
|          12624 | Accelerated Achievement Academy of Cincinnati               |          12624 | Accelerated Achievement Academy of Cincinnati               | 415 W Court St           | Cincinnati | OH      | 45203-1519 | (513) 246-4102 | Gamal D. Brown      | (null)                   | 9-12         | Does Not Meet Standards     | Meets Standards         | Meets Standards                 | Does Not Meet Standards         | Meets Standards                 | Meets Standards                 | Meets Standards                 | Does Not Meet Standards      | Does Not Meet Standards | Does Not Meet Standards |
|          11507 | Achieve Career Preparatory Academy                          |          11507 | Achieve Career Preparatory Academy                          | 3891 Martha Ave          | Toledo     | OH      | 43612-1250 | (419) 243-8559 | Cindy M. Wilson     | Cindy M. Wilson          | 8-12         | Meets Standards             | Does Not Meet Standards | Meets Standards                 | Meets Standards                 | Meets Standards                 | Meets Standards                 | Meets Standards                 | Meets Standards              | Does Not Meet Standards | Does Not Meet Standards |
|         149054 | Akron Digital Academy                                       |         149054 | Akron Digital Academy                                       | 133 Merriman Rd          | Akron      | OH      | 44303-1943 | (330) 237-2200 | LaShawn Terrell     | Teresa K. Sayles         | K-12         | Meets Standards             | Meets Standards         | Meets Standards                 | Meets Standards                 | Meets Standards                 | Meets Standards                 | Meets Standards                 | Meets Standards              | Does Not Meet Standards | Meets Standards         |
|           9971 | Ashland County Community Academy                            |           9971 | Ashland County Community Academy                            | 716 Union St             | Ashland    | OH      | 44805-1823 | (419) 903-0295 | Samuel A. Wilson    | Samuel A. Wilson         | 7-12         | Meets Standards             | Meets Standards         | Exceeds Standards               | Exceeds Standards               | Exceeds Standards               | Exceeds Standards               | Exceeds Standards               | Exceeds Standards            | Meets Standards         | Meets Standards         |
|            288 | Auglaize County Educational Academy                         |            288 | Auglaize County Educational Academy                         | 1130A East Albert St     | Lima       | OH      | 45804-1614 | (419) 738-4572 | Shawn Brown         | (null)                   | K-12         | Meets Standards             | Not Rated               | Exceeds Standards               | Exceeds Standards               | Exceeds Standards               | Exceeds Standards               | Exceeds Standards               | Exceeds Standards            | Meets Standards         | Meets Standards         |
|            525 | Canton Harbor High School                                   |            525 | Canton Harbor High School                                   | 1731 Grace Ave NE        | Canton     | OH      | 44705-2261 | (330) 452-8414 | Steven A. Nichols   | Steven A. Nichols        | 9-12         | Meets Standards             | Meets Standards         | Exceeds Standards               | Meets Standards                 | Exceeds Standards               | Exceeds Standards               | Meets Standards                 | Exceeds Standards            | Meets Standards         | Meets Standards         |
|          12044 | Capital High School                                         |          12044 | Capital High School                                         | 640 Harrisburg Pike      | Columbus   | OH      | 43223-2112 | (614) 228-2854 | Gamal D. Brown      | Monica D. Scott-Matthews | 8-12         | Meets Standards             | Exceeds Standards       | Meets Standards                 | Meets Standards                 | Meets Standards                 | Meets Standards                 | Meets Standards                 | Meets Standards              | Does Not Meet Standards | Meets Standards         |
|          12041 | Central High School                                         |          12041 | Central High School                                         | 840 W State St           | Columbus   | OH      | 43222-1442 | (614) 362-7530 | Karen R. Wachter    | THOMAS J. Rogan          | 8-12         | Not Rated                   | Not Rated               | Meets Standards                 | Not Rated                       | Does Not Meet Standards         | Meets Standards                 | Meets Standards                 | Meets Standards              | Does Not Meet Standards | Does Not Meet Standards |
|            527 | Cleveland Academy for Scholarship Technology and Leadership |            527 | Cleveland Academy for Scholarship Technology and Leadership | 3950 Prospect Ave E      | Cleveland  | OH      | 44115-2710 | (216) 443-5400 | Wendy A. Rydarowicz | Kimberly L. Trammell     | 9-12,UNG     | Meets Standards             | Does Not Meet Standards | Meets Standards                 | Exceeds Standards               | Exceeds Standards               | Meets Standards                 | Meets Standards                 | Meets Standards              | Does Not Meet Standards | Does Not Meet Standards |


Table: TYPOLOGIES
|    2013 Typology Code | Major Grouping   |  Full Descriptor                                                    |    Districts Within Typology |    Students Within Typology |
|----------------------:|:-----------------|:--------------------------------------------------------------------|-----------------------------:|----------------------------:|
|                     1 | Rural            | Rural - High Student Poverty & Small Student Population             |                          124 |                      170000 |
|                     2 | Rural            | Rural - Average Student Poverty & Very Small Student Population     |                          107 |                      110000 |
|                     3 | Small Town       | Small Town - Low Student Poverty & Small Student Population         |                          111 |                      185000 |
|                     4 | Small Town       | Small Town - High Student Poverty & Average Student Population Size |                           89 |                      200000 |
|                     5 | Suburban         | Suburban - Low Student Poverty & Average Student Population Size    |                           77 |                      320000 |
|                     6 | Suburban         | Suburban - Very Low Student Poverty & Large Student Population      |                           46 |                      240000 |
|                     7 | Urban            | Urban - High Student Poverty & Average Student Population           |                           47 |                      210000 |
|                     8 | Urban            | Urban - Very High Student Poverty & Very Large Student Population   |                            8 |                      200000 |
|                     0 | Island           | Island                                                              |                            5 |                         150 |


Table: TYPOLOGY BY DISTRICT
|   IRN | District Name                            | County    |   2013 Typology |   Enrollment |   Median Income |   Student Poverty |   Pct. Minority |
|------:|:-----------------------------------------|:----------|----------------:|-------------:|----------------:|------------------:|----------------:|
| 61903 | Adams County/Ohio Valley Local           | Adams     |               1 |     3962.16  |           25268 |          0.643098 |       0.0192887 |
|   442 | Manchester Local (Adams)                 | Adams     |               1 |      842.096 |           22901 |          0.732428 |       0.0308341 |
| 45468 | Loudonville-Perrysville Exempted Village | Ashland   |               1 |     1185.7   |           27227 |          0.455231 |       0.0265616 |
| 45880 | Pymatuning Valley Local                  | Ashtabula |               1 |     1370.4   |           26857 |          0.552115 |       0.0357239 |
| 45864 | Grand Valley Local                       | Ashtabula |               1 |     1431.91  |           29251 |          0.490675 |       0.0478866 |
| 45914 | Federal Hocking Local                    | Athens    |               1 |     1057.52  |           27767 |          0.644243 |       0.0797655 |
| 45922 | Trimble Local                            | Athens    |               1 |      870.583 |           25599 |          0.638381 |       0.0157226 |
| 44446 | Nelsonville-York City                    | Athens    |               1 |     1287.06  |           22857 |          0.61267  |       0.0311035 |
| 44982 | Wapakoneta City                          | Auglaize  |               1 |     3027.42  |           31317 |          0.414289 |       0.0276302 |
| 45203 | Barnesville Exempted Village             | Belmont   |               1 |     1131.93  |           26921 |          0.41606  |       0.025588  |

 


tables: name: BUILDING
data: BUILDING.csv
name: DISTRICT
data: DISTRICT.csv
name: Fiscal Years
data: Fiscal Years.csv
name: iREADY
data: iREADY.csv
name: iREADYREADING
data: iREADYREADING.csv
name: PerPupilAllRevenue (2)
data: PerPupilAllRevenue (2).csv
name: PerPupilAllRevenue
data: PerPupilAllRevenue.csv
name: RAW STATE DATA
data: RAW STATE DATA.csv
name: TR_DORP_2016
data: TR_DORP_2016.csv
name: TYPOLOGIES
data: TYPOLOGIES.csv
name: TYPOLOGY BY DISTRICT
data: TYPOLOGY BY DISTRICT.csv
label: BUILDING
DISTRICT IRN
DISTRICT
DISTRICT IRN
iREADY
Student ID
iREADYREADING
Student ID
TR_DORP_2016
DISTRICT IRN
DISTRICT
DISTRICT IRN
DISTRICT
DISTRICT IRN
PerPupilAllRevenue
IRN
PerPupilAllRevenue (2)
IRN
DISTRICT
DISTRICT IRN
PerPupilAllRevenue (2)
Fiscal Year
Fiscal Years
Fiscal Year
output: {
    "joins": [
        {
            "from_table": "BUILDING",
            "from_column": "DISTRICT IRN",
            "to_table": "DISTRICT",
            "to_column": "DISTRICT IRN"
        },
        {
            "from_table": "iREADY",
            "from_column": "Student ID",
            "to_table": "iREADYREADING",
            "to_column": "Student ID"
        },
        {
            "from_table": "TR_DORP_2016",
            "from_column": "DISTRICT IRN",
            "to_table": "DISTRICT",
            "to_column": "DISTRICT IRN"
        },
        {
            "from_table": "DISTRICT",
            "from_column": "DISTRICT IRN",
            "to_table": "PerPupilAllRevenue",
            "to_column": "IRN"
        },
        {
            "from_table": "PerPupilAllRevenue (2)",
            "from_column": "IRN",
            "to_table": "DISTRICT",
            "to_column": "DISTRICT IRN"
        },
        {
            "from_table": "PerPupilAllRevenue (2)",
            "from_column": "Fiscal Year",
            "to_table": "Fiscal Years",
            "to_column": "Fiscal Year"
        }
    ]
}