From a 500-row sample across 7 columns.
absentreleaseddate+3school_dbn| school_dbn | date | schoolyear | enrolled | present | absent | released |
|---|---|---|---|---|---|---|
| 15K896 | 09/05/2018 | 20182019 | 14 | 14 | 0 | 0 |
| 15K896 | 09/06/2018 | 20182019 | 26 | 26 | 0 | 0 |
| 15K896 | 09/07/2018 | 20182019 | 26 | 25 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
school_dbn | text | District, Borough, school number | 0% | 75Q99375X75475Q721 |
date | datetime | Calendar date for which data is reported | 0% | 2020-10-02T00:00:00.0002020-10-14T00:00:00.0002020-09-24T00:00:00.000 |
schoolyear | categorical | Fiscal school year of data reported | 0% | 202020212018201920192020of 3 |
enrolled | integer | Number of students enrolled at school for that day | 0% | 361362 |
GET /api/datasets/xc44-2jrh GET /api/datasets/xc44-2jrh/quality GET /api/datasets/xc44-2jrh/related GET /api/columns?dataset=xc44-2jrh
| 1 |
| 0 |
| 15K896 | 09/12/2018 | 20182019 | 27 | 26 | 1 | 0 |
| 15K896 | 09/13/2018 | 20182019 | 28 | 27 | 1 | 0 |
| 15K896 | 09/14/2018 | 20182019 | 29 | 27 | 2 | 0 |
| 15K896 | 09/17/2018 | 20182019 | 29 | 28 | 1 | 0 |
| 15K896 | 09/18/2018 | 20182019 | 30 | 29 | 1 | 0 |
| 15K896 | 09/20/2018 | 20182019 | 30 | 28 | 2 | 0 |
| 15K896 | 09/21/2018 | 20182019 | 30 | 29 | 1 | 0 |
399present | integer | Number of students in school that day | 0% | 275268270 |
absent | integer | Number of students absent that day | 0% | 262325 |
released | integer | Number of students released from school for any reason. | 0% | 012 |