From a 500-row sample across 11 columns.
boroughschool_yearreport_type+2boroughgrade_levelprogram_type+1boroughgrade_levelprogram_typegrade_levelprogram_typeaverage_class_sizeHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| school_year | report_type | borough | grade_level | program_type | core_subject_ms_core_and | core_course_ms_core_and_9 | service_category_k_9_only | number_of_students_seats | number_of_sections | average_class_size |
|---|---|---|---|---|---|---|---|---|---|---|
| 2010-2011 | Borough | Brooklyn | 0K | GEN ED | - | - | - | 17264 | 783 | 22 |
| 2010-2011 | Borough |
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% | 2014-20152013-20142012-2013of 5 |
report_type | categorical | Indicates the level of aggregation | 0% | SchoolDistrictBoroughof 4 |
borough | categorical | NYC Borough | 0% | KXQof 10 |
csd | text | Community School District | 2% | 2109 |
GET /api/datasets/nbpb-zygj GET /api/datasets/nbpb-zygj/quality GET /api/datasets/nbpb-zygj/related GET /api/columns?dataset=nbpb-zygj
grade_levelprogram_typeschool_codesize_of_smallest_classprogram_type+5grade_levelprogram_typegrade_levelprogram_typeaverage_class_size| Brooklyn |
| 0K |
| CTT |
| - |
| - |
| - |
| 3056 |
| 149 |
| 20.5 |
| 2010-2011 | Borough | Brooklyn | 0K | G&T | - | - | - | 390 | 21 | 18.6 |
| 2010-2011 | Borough | Brooklyn | 1 | GEN ED | - | - | - | 18658 | 823 | 22.7 |
| 2010-2011 | Borough | Brooklyn | 1 | CTT | - | - | - | 2783 | 126 | 22.1 |
| 2010-2011 | Borough | Brooklyn | 1 | G&T | - | - | - | 512 | 22 | 23.3 |
| 2010-2011 | Borough | Brooklyn | 2 | GEN ED | - | - | - | 18083 | 784 | 23.1 |
| 2010-2011 | Borough | Brooklyn | 2 | CTT | - | - | - | 2775 | 123 | 22.6 |
| 2010-2011 | Borough | Brooklyn | 2 | G&T | - | - | - | 370 | 17 | 21.8 |
| 2010-2011 | Borough | Brooklyn | 3 | GEN ED | - | - | - | 17201 | 737 | 23.3 |
school_code| text |
| District, Boro, School Number (DBN) of the location |
| 12% |
M655X505X141 |
school_name | text | The official name of the school | 12% | Brooklyn Secondary Schoo…YOUNG WOMEN'S LEADERSHIP…LIFE SCIENCES SECONDARY … |
grade_level | categorical | The student’s grade level. | 5% | 09-12MS Core0K-09of 13 |
program_type | categorical | The types of classes students are enrolled in. | 5% | GEN EDCTTSPEC EDof 6 |
core_subject_ms_core_and | categorical | Subject of Instruction | 5% | -Social StudiesScienceof 11 |
core_course_ms_core_and_9 | text | Course Name | 5% | -MS English CoreIntegrated Algebra |
service_category_k_9_only | categorical | Denotes students population to teacher ratio per program type | 5% | -1899-12-31T12:01:01.0001899-12-31T12:01:00.000of 11 |
number_of_students_seats | integer | Indicates the number of students in the class and count of seats they occupy | 5% | 252426 |
number_of_sections | integer | Number of sections a course is divided into | 5% | 123 |
average_class_size | float | Average number of students in a class or course | 5% | 252624 |
size_of_smallest_class | text | Denotes the smallest class size for each school | 16% | 252423 |
size_of_largest_class | text | Denotes the largest class size for each school | 16% | 343031 |
data_source | categorical | Application recognized as the official source for the data | 16% | STARSATSof 2 |
schoolwide_pupil_teacher | coordinate | Ratio of Teacher to Students | 95% | 15.114.714.2 |