From a 500-row sample across 11 columns.
boroughreport_typeschool_yearnumber_of_classesprogram_typeclass_size+2boroughnumber_of_classesprogram_type+3number_of_classesprogram_typeclass_size+2Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| school_year | report_type | borough | grade_level | program_type | number_of_classes | number_of_students | percent_of_students_in_borough | class_size |
|---|---|---|---|---|---|---|---|---|
| 2010-2011 | Borough | K | 0K | GEN ED / CTT / G&T | 28 | 329 | 2 | — |
| 2010-2011 | Borough | K | 0K | GEN ED / CTT / G&T | 22 | 330 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
school_year | categorical | School Year of the report | 0% | 2013-20142011-20122014-2015of 5 |
report_type | categorical | Indicates the level of aggregation | 0% | DistrictBoroughCitywideof 3 |
borough | categorical | NYC Borough | 3% | KQXof 5 |
csd | text | Community School District | 16% | 10279 |
GET /api/datasets/9ksk-35jf GET /api/datasets/9ksk-35jf/quality GET /api/datasets/9ksk-35jf/related GET /api/columns?dataset=9ksk-35jf
number_of_classesprogram_typeclass_size+2number_of_classesprogram_typeclass_size+2boroughnumber_of_classesprogram_type+2number_of_classesprogram_typeclass_size+2| 2 |
| 15 |
| 2010-2011 | Borough | K | 0K | GEN ED / CTT / G&T | 16 | 256 | 1 | 16 |
| 2010-2011 | Borough | K | 0K | GEN ED / CTT / G&T | 37 | 629 | 3 | 17 |
| 2010-2011 | Borough | K | 0K | GEN ED / CTT / G&T | 64 | 1152 | 6 | 18 |
| 2010-2011 | Borough | K | 0K | GEN ED / CTT / G&T | 60 | 1140 | 6 | 19 |
| 2010-2011 | Borough | K | 0K | GEN ED / CTT / G&T | 92 | 1840 | 9 | 20 |
| 2010-2011 | Borough | K | 0K | GEN ED / CTT / G&T | 77 | 1617 | 8 | 21 |
| 2010-2011 | Borough | K | 0K | GEN ED / CTT / G&T | 121 | 2662 | 13 | 22 |
| 2010-2011 | Borough | K | 0K | GEN ED / CTT / G&T | 100 | 2300 | 11 | 23 |
grade_level |
| categorical |
| The student’s grade level. |
| 0% |
09-12MS Core0K-09of 13 |
program_type | categorical | The types of classes students are enrolled in. | 0% | GEN ED / CTTGEN ED / CTT / G&TSPEC EDof 5 |
core_subject | categorical | Subject of Instruction | 9% | -Social StudiesScienceof 11 |
service_category | categorical | Denotes students population to teacher ratio per program type | 19% | -1899-12-31T12:01:01.0001899-12-31T12:01:00.000of 9 |
class_size | text | Indicates the number of students in the class | 2% | 252624 |
number_of_classes | integer | Count of Official Classes or Courses | 0% | 123 |
number_of_students | integer | Number of students enrolled in the Official Class or Course | 0% | 161815 |
percent_of_students_in_borough | integer | This metric represents the proportion of students who are enrolled in a specific combination of Borough, Grade Level, Program Type and Subject | 0% | 123 |