From a 500-row sample across 6 columns.
enrolledabsentreleased+2enrolledabsentreleased+2enrolledabsentreleased+2enrolledabsentreleased+2| school_dbn | date | enrolled | absent | present | released |
|---|---|---|---|---|---|
| 01M015 | 20180905 | 172 | 19 | 153 | 0 |
| 01M015 | 20180906 | 171 | 17 | 154 | 0 |
| 01M015 | 20180907 | 172 | 14 | 158 | 0 |
| 01M015 | 20180912 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
school_dbn | text | School Identification number | 0% | 23K36321K69021K468 |
date | text | Calendar date of the date in the school year for which the data is being reported. | 0% | 201809052018090620180928 |
enrolled | integer | Number of students matriculated on that day. | 0% | 295362412 |
absent | integer | The count of students whom were absent for that day. | 0% | 252723 |
present |
GET /api/datasets/x3bb-kg5j GET /api/datasets/x3bb-kg5j/quality GET /api/datasets/x3bb-kg5j/related GET /api/columns?dataset=x3bb-kg5j
enrolledabsentreleased+2school_dbnenrolledabsent+3| 173 |
| 7 |
| 166 |
| 0 |
| 01M015 | 20180913 | 173 | 9 | 164 | 0 |
| 01M015 | 20180914 | 173 | 11 | 162 | 0 |
| 01M015 | 20180917 | 173 | 10 | 163 | 0 |
| 01M015 | 20180918 | 174 | 7 | 167 | 0 |
| 01M015 | 20180920 | 174 | 7 | 167 | 0 |
| 01M015 | 20180921 | 174 | 8 | 166 | 0 |
| integer |
| The count of students present in school that day. |
| 0% |
384322329 |
released | integer | The count of students who were released from school for any reason on the date for which data is being reported. | 0% | 012 |