From a 500-row sample across 12 columns.
city_council_districtschool_dbncommunity_school_districtcity_council_districtschool_dbnschool_name+2city_council_districtschool_dbnschool_name+1city_council_districtschool_dbncommunity_school_district| school_year | report_type | school_dbn | school_name | community_school_district | city_council_district | number_of_students_in_grade_6 | number_of_students_in_grade_6_1 | percentage_of_students_in_grade_6_2 | number_of_students_in_grades_7_12 | number_of_students_in_grades_7_12_1 | percentage_of_students_in_grades_7_12_2 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2017-2018 | School | 01M034 | P.S. 034 Franklin D. Roosevelt | 1 | 2 | 36 | 36 | 100.0% | 91 | 91 |
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% | 2023-20242019-20202020-2021of 7 |
report_type | categorical | Type of the report based on the school, school district or council district designation | 0% | SchoolCity Council DistrictSchool Districtof 3 |
school_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. | 14% | 13K52706M29328Q310 |
school_name | text | School Official name | 14% |
GET /api/datasets/hi2h-7vr7 GET /api/datasets/hi2h-7vr7/quality GET /api/datasets/hi2h-7vr7/related GET /api/columns?dataset=hi2h-7vr7
school_dbnschool_name| 100.0% |
| 2017-2018 | School | 01M140 | P.S. 140 Nathan Straus | 1 | 1 | 58 | s | s | 124 | s | s |
| 2017-2018 | School | 01M184 | P.S. 184m Shuang Wen | 1 | 1 | 93 | 93 | 100.0% | 170 | 170 | 100.0% |
| 2017-2018 | School | 01M188 | P.S. 188 The Island School | 1 | 2 | 42 | 24 | 57.1% | 104 | s | s |
| 2017-2018 | School | 01M292 | Orchard Collegiate Academy | 1 | 1 | s | s | s | 156 | s | s |
| 2017-2018 | School | 01M301 | Technology, Arts, and Sciences Studio | 1 | 2 | s | s | s | 71 | s | s |
| 2017-2018 | School | 01M332 | University Neighborhood Middle School | 1 | 1 | 69 | s | s | 128 | s | s |
| 2017-2018 | School | 01M378 | School for Global Leaders | 1 | 1 | 68 | 58 | 85.3% | 177 | s | s |
| 2017-2018 | School | 01M448 | University Neighborhood High School | 1 | 1 | s | s | s | 437 | 437 | 100.0% |
| 2017-2018 | School | 01M450 | East Side Community School | 1 | 2 | 98 | s | s | 561 | s | s |
The Michael J. Petrides …All City Leadership Seco…East Bronx Academy for t… |
community_school_district | text | Identifies the schools district location | 9% | 27510 |
city_council_district | text | Identifies the schools city council district location | 6% | 17116 |
grade_level | categorical | Indicates the grade designation of the students | 4% | 678of 8 |
number_of_students | text | Count of students in the grade level | 4% | s8687 |
number_of_students_that_received | text | Count of students who received the lessons | 4% | 0s6 |
percentage_of_students_that_received_1 | text | Percentage of students who received the lessons | 4% | 0.0%100.0%s |
number_of_students_in_grade_6 | text | Count of students in the 6 grade | 96% | s7172 |
number_of_students_in_grade_6_1 | text | Count of students who received the lessons for 6 grade | 96% | s7189 |
percentage_of_students_in_grade_6_2 | text | Percentage of students who received the lessons for 6 grade | 96% | s100.0%95.2% |
number_of_students_in_grades_7_12 | text | Count of students in the 7-12 grade | 96% | s363173 |
number_of_students_in_grades_7_12_1 | text | Count of students who received the lessons for 7-12 grade | 96% | s16078 |
percentage_of_students_in_grades_7_12_2 | text | Percentage of students who received the lessons for 7-12 grade | 96% | s100.0%99.7% |