From a 500-row sample across 12 columns.
number_of_studentsdbnschool_year+1districtboroughdistrictschool_nameschool_nameHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| school_year | month | geography | borough | grade_level | program_type | number_of_students | number_of_classes | average_class_size |
|---|---|---|---|---|---|---|---|---|
| 2017-2018 | November 2017 | Borough | Bronx | K | Gen Ed | 10509 | 479 | 21.9 |
| 2017-2018 | November 2017 | Borough | Bronx | K | G&T | 58 | 3 |
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% | 2017-20182018-2019of 2 |
month | categorical | Month and year combination indicating whether the report is preliminary (November) or updated (February) | 0% | November 2017November 2018of 2 |
geography | categorical | Indicates the level of aggregation (Borough, Citywide, District, School) | 0% | SchoolDistrictBoroughof 4 |
borough | categorical | NYC Borough | 98% | BrooklynManhattan |
GET /api/datasets/cfuy-6eha GET /api/datasets/cfuy-6eha/quality GET /api/datasets/cfuy-6eha/related GET /api/columns?dataset=cfuy-6eha
dbndistrictdbndistrictdbndistrict| 19.3 |
| 2017-2018 | November 2017 | Borough | Bronx | K | ICT | 3106 | 142 | 21.9 |
| 2017-2018 | November 2017 | Borough | Bronx | 1 | Gen Ed | 10646 | 447 | 23.8 |
| 2017-2018 | November 2017 | Borough | Bronx | 1 | G&T | 98 | 4 | 24.5 |
| 2017-2018 | November 2017 | Borough | Bronx | 1 | ICT | 3410 | 143 | 23.8 |
| 2017-2018 | November 2017 | Borough | Bronx | 1 | ICT & G&T | 50 | 2 | 25.0 |
| 2017-2018 | November 2017 | Borough | Bronx | 2 | Gen Ed | 10468 | 432 | 24.2 |
| 2017-2018 | November 2017 | Borough | Bronx | 2 | G&T | 157 | 6 | 26.2 |
| 2017-2018 | November 2017 | Borough | Bronx | 2 | ICT | 3758 | 155 | 24.2 |
Queensdistrict | text | NYC school district | 90% | 103127 |
dbn | text | Character code used to identify a school and its location. It is formed by concatenating the school district code, the school borough code, and the school number. | 12% | 12X27110X14110X368 |
school_name | text | The official name of the school | 12% | East Bronx Academy for t…EAST BRONX ACADEMY FOR T…Riverdale / Kingsbridge … |
grade_level | categorical | The grade level for which the course is offered | 0% | HS CoreMS Core1of 13 |
program_type | categorical | Identifies program type for course | 0% | Gen EdICTSCof 13 |
department | categorical | Denotes course department | 38% | EnglishMathScienceof 4 |
subject | text | Denotes course subject | 38% | MS Math CoreMS English CoreMS Science Core |
number_of_students | integer | The total number of students enrolled in a course | 0% | 252426 |
number_of_classes | integer | The total number of classes offered for a course | 0% | 123 |
average_class_size | integer | The average number of students in a class | 0% | 25.026.024.0 |
minimum_class_size | text | The number of students in the smallest class by school, grade level, program type, department, and subject | 12% | <15<625 |
maximum_class_size | text | The number of students in the largest class by school, grade level, program type, department, and subject | 12% | >34<1534.0 |