From a 500-row sample across 9 columns.
report_categorydistrictgeography+3report_categoryschool_namedistrictschool_nameboroughdistrictHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| school_year | geography | report_category | by_group | group_demographic | group_metrics | value | percentage_within_demographic | total_number_within |
|---|---|---|---|---|---|---|---|---|
| 2013-2014 | Citywide | Discharge Code | Age by Discharge Code | 10 yrs old or younger | All | 203 | 100% | 203 |
| 2013-2014 | Citywide | Discharge Code | Age by Discharge Code | 10 yrs old or younger | Career Development and Occupational Studies (CDOS) Commencement Credential |
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-2014of 2 |
geography | categorical | Report is disaggregated by citywide, borough, school district, or individual school. | 0% | SchoolDistrictBoroughof 4 |
report_category | categorical | Report is disaggregated by 6 different categories: Attendance Rate, Credit Recovery, Disability Status, Discharge Code, GPA, To School | 0% | To SchoolDischarge CodeAttendance Rateof 6 |
borough | categorical | Indicates the NYC borough | 82% |
GET /api/datasets/r773-ytwa GET /api/datasets/r773-ytwa/quality GET /api/datasets/r773-ytwa/related GET /api/columns?dataset=r773-ytwa
school_nameboroughschool_nameschool_yearschool_nameschool_dbn| s |
| s |
| 203 |
| 2013-2014 | Citywide | Discharge Code | Age by Discharge Code | 10 yrs old or younger | Discharged to a Court Ordered Placement. Incarceration. | s | s | 203 |
| 2013-2014 | Citywide | Discharge Code | Age by Discharge Code | 10 yrs old or younger | Discharged to a Private School(in NYC or NY State) | s | s | 203 |
| 2013-2014 | Citywide | Discharge Code | Age by Discharge Code | 10 yrs old or younger | Discharged to a Private School(in NYC or NY State). Missing documentation. | s | s | 203 |
| 2013-2014 | Citywide | Discharge Code | Age by Discharge Code | 10 yrs old or younger | Discharged to a School outside of New York City. Missing documentation. | s | s | 203 |
| 2013-2014 | Citywide | Discharge Code | Age by Discharge Code | 10 yrs old or younger | Over 21 Years of Age | s | s | 203 |
| 2013-2014 | Citywide | Discharge Code | Age by Discharge Code | 10 yrs old or younger | Previously Discharged from DOE School with an IEP Diploma, GED or Dropout Code | s | s | 203 |
| 2013-2014 | Citywide | Discharge Code | Age by Discharge Code | 10 yrs old or younger | Received High School Advanced Regents Diploma | s | s | 203 |
| 2013-2014 | Citywide | Discharge Code | Age by Discharge Code | 10 yrs old or younger | Received High School Equivalency Diploma (GED) [D79 only] | s | s | 203 |
BrooklynBronxManhattanof 5district | categorical | Indicates the NYC school district | 69% | 191102of 19 |
school_dbn | text | Indicates unique DBN (District Borough Number) for the closed public school | 62% | 19K30219K16607X203 |
school_name | text | The name of the closed school | 62% | J.H.S. 302 Rafael Corder…J.H.S. 166 George Gershw…M.S. 203 |
by_group | text | A group for each report category: All students, Age, Disability Status, English Language Learner Status, Ethnicity, Gender, Grade | 0% | Age by To SchoolGrade by To SchoolEthnicity by To School |
group_demographic | text | Demographic categories for each group | 0% | WhiteEllFemale |
group_metrics | text | Metrics for each of the following group categories: Attendance Rate, Credit Recovery, Disability Status, Discharge Code, GPA | 64% | All21-40% Attendance Rate41-60% Attendance Rate |
to_school_dbn | text | Indicates unique DBN (District Borough Number) for the transfer public school. Data is only available for "To School" report category | 37% | All03M40307X670 |
to_school_name | text | The name of the transfer public school. Data is only available for "To School" report category | 37% | The Global Learning Coll…Urban Assembly School fo…Health Opportunities Hig… |
value | text | Count of students per each metrics | 0% | s1011 |
percentage_within_demographic | text | Percentage of students per each metrics within a specific demographic group | 0% | s100%1.0000 |
total_number_within | text | Count of students within each demographic group | 0% | s1210 |