From a 500-row sample across 12 columns.
districtchronically_absent_1chronically_absentdbn+7yearchronically_absent_1chronically_absentHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| report_type | grade | year | demographic_category | demographic_variable | total_days | days_absent | days_present | attendance | contributing_20_total_days | chronically_absent | chronically_absent_1 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Citywide | All Grades | 2013-14 | All Students | All Students | 171713418 | 15281111 | 156432307 | 91.10 | 1011828 | 273005 | 27.00 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
report_type | categorical | — | 0% | SchoolDistrictBoroughof 4 |
borough | categorical | — | 99% | BronxBrooklynManhattanof 5 |
district | text | — | 95% | 91011 |
dbn | text | — | 6% | 31R08001M53975Q993 |
school_name | text |
GET /api/datasets/mg8s-7r2b GET /api/datasets/mg8s-7r2b/quality GET /api/datasets/mg8s-7r2b/related GET /api/columns?dataset=mg8s-7r2b
days_presentschool_nameyearreport_typedbnschool_namedbngradedistrict| Citywide |
| All Grades |
| 2014-15 |
| All Students |
| All Students |
| 173811895 |
| 14380478 |
| 159431417 |
| 91.70 |
| 1010090 |
| 251676 |
| 24.90 |
| Citywide | All Grades | 2015-16 | All Students | All Students | 169417635 | 13767754 | 155649881 | 91.90 | 1004877 | 245828 | 24.50 |
| Citywide | All Grades | 2016-17 | All Students | All Students | 166560858 | 13860124 | 152700734 | 91.70 | 998438 | 252179 | 25.30 |
| Citywide | All Grades | 2017-18 | All Students | All Students | 166672935 | 14320146 | 152352789 | 91.40 | 989637 | 265567 | 26.80 |
| Citywide | All Grades | 2018-19 | All Students | All Students | 164817248 | 13959465 | 150857783 | 91.50 | 974122 | 258377 | 26.50 |
| Citywide | PK in K-12 Schools | 2013-14 | All Students | All Students | 4046083 | 437114 | 3608969 | 89.20 | 24411 | 10538 | 43.20 |
| Citywide | PK in K-12 Schools | 2014-15 | All Students | All Students | 4635913 | 494991 | 4140922 | 89.30 | 27754 | 11845 | 42.70 |
| Citywide | PK in K-12 Schools | 2015-16 | All Students | All Students | 4502733 | 445461 | 4057272 | 90.10 | 27078 | 10258 | 37.90 |
| Citywide | PK in K-12 Schools | 2016-17 | All Students | All Students | 4348812 | 437426 | 3911386 | 89.90 | 26392 | 10290 | 39.00 |
| — |
| 6% |
P.S. 212P.S. 253The Michael J. Petrides … |
grade | categorical | — | 0% | All Grades0K1of 15 |
year | categorical | — | 0% | 2015-162016-172017-18of 6 |
demographic_category | categorical | — | 0% | EthnicityGenderPovertyof 6 |
demographic_variable | categorical | — | 0% | All StudentsPovertyMaleof 14 |
total_days | integer | — | 0% | 178356176 |
days_absent | text | — | 0% | s158126 |
days_present | text | — | 0% | s1020997 |
attendance | coordinate | — | 0% | s94.193.8 |
contributing_20_total_days | text | — | 0% | s118 |
chronically_absent | text | — | 0% | s32 |
chronically_absent_1 | coordinate | — | 0% | s0.033.3 |