From a 500-row sample across 17 columns.
pct_level_3_and_4gradepct_level_3+12geographic_subdivisionreport_categorygrade+3pct_level_3_and_4report_categorygrade+12| report_category | geographic_subdivision | grade | year | demographic | number_tested | mean_scale_score | num_level_1 | pct_level_1 | num_level_2 | pct_level_2 | num_level_3 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| School | 01M015 | 3 | 2006 | EP | 37 | 651 | 4 | 10.8 | 14 | 37.8 | 19 |
| School | 01M015 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
report_category | categorical | The high-level grouping for each report | 0% | SchoolDistrictBoroughof 5 |
geographic_subdivision | text | The individual schools or geographic subregion for each of the main categories | 0% | 20K10410X09511X089 |
grade | categorical | School grade which test was administered | 0% | All Grades35of 7 |
year | categorical | Year test was administered | 0% | 20102012 |
GET /api/datasets/9uqq-k6t8 GET /api/datasets/9uqq-k6t8/quality GET /api/datasets/9uqq-k6t8/related GET /api/columns?dataset=9uqq-k6t8
yearyear| 3 |
| 2007 |
| ELL |
| 8 |
| 627 |
| 2 |
| 25 |
| 6 |
| 75 |
| 0 |
| School | 01M015 | 3 | 2007 | EP | 25 | 637 | 4 | 16 | 12 | 48 | 9 |
| School | 01M015 | 3 | 2008 | ELL | 6 | 643 | 0 | 0 | 4 | 66.7 | 2 |
| School | 01M015 | 3 | 2008 | EP | 33 | 646 | 3 | 9.1 | 18 | 54.5 | 12 |
| School | 01M015 | 3 | 2009 | ELL | 8 | 642 | 0 | 0 | 5 | 62.5 | 3 |
| School | 01M015 | 3 | 2009 | EP | 25 | 645 | 1 | 4 | 14 | 56 | 10 |
| School | 01M015 | 3 | 2010 | ELL | 4 | s | s | s | s | s | s |
| School | 01M015 | 3 | 2010 | EP | 21 | 653 | 8 | 38.1 | 9 | 42.9 | 3 |
| School | 01M015 | 3 | 2011 | ELL | 9 | 636 | 4 | 44.4 | 5 | 55.6 | 0 |
Showing 12 of 17 columns. All of them are listed below.
2011demographic | categorical | Reflects the set of students which were tested | 0% | All StudentsMaleEPof 12 |
number_tested | integer | Total number of students tested | 0% | 123 |
mean_scale_score | text | Average of total students tested | 16% | s658657 |
num_level_1 | text | Number of students who scored in Level 1 range | 0% | 0s1 |
pct_level_1 | text | Percentage of students who scored in Level 1 range | 0% | 0s16.7 |
num_level_2 | text | Number of students who scored in Level 2 range | 0% | s45 |
pct_level_2 | text | Percentage of students who scored in Level 2 range | 0% | s5033.3 |
num_level_3 | text | Number of students who scored in Level 3 range | 0% | s12 |
pct_level_3 | text | Percentage of students who scored in Level 3 range | 0% | s050 |
num_level_4 | text | Number of students who scored in Level 4 range | 0% | 0s1 |
pct_level_4 | coordinate | Percentage of students who scored in Level 4 range | 0% | 0s1.4 |
num_level_3_and_4 | text | Number of students who scored in Level 3 and 4 range combined | 0% | s12 |
pct_level_3_and_4 | text | Percentage of students who scored in Level 3 and 4 range | 0% | s050 |