From a 500-row sample across 14 columns.
Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| borough | admin_district | geographical | pe_works_cohort | dbn | school_level | student_enrollment | full_time_licensed | total_part_time_and | ratio_of_full_time |
|---|---|---|---|---|---|---|---|---|---|
| Manhattan | 1 | 1 | 2 | 01M015 | Elementary | 143 | 1 | 1 | 1:143 |
| Manhattan | 1 | 1 | 2 | 01M019 | Elementary |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
borough | categorical | The borough of the site. | 0% | BrooklynBronxQueensof 5 |
admin_district | integer | A two-digit administrative district identifier. For schools in a region, it is in most cases the geographical district in which the school is physically located. | 0% | 2109 |
geographical | integer | The Geographical District | 0% | 21031 |
pe_works_cohort | categorical | Number of PE works cohorts | 0% | 321of 3 |
GET /api/datasets/x4sg-2jca GET /api/datasets/x4sg-2jca/quality GET /api/datasets/x4sg-2jca/related GET /api/columns?dataset=x4sg-2jca
school_levelboroughdbnboroughborough| 237 |
| 1 |
| 1 |
| 1:237 |
| Manhattan | 1 | 1 | 2 | 01M020 | Elementary | 500 | 1 | 1 | 1:500 |
| Manhattan | 1 | 1 | 2 | 01M034 | K-8 | 363 | 1 | 1 | 1:363 |
| Manhattan | 1 | 1 | 2 | 01M063 | Elementary | 180 | 1 | 1 | 1:180 |
| Manhattan | 1 | 1 | 2 | 01M064 | Elementary | 216 | 1 | 1 | 1:216 |
| Manhattan | 1 | 1 | 2 | 01M110 | Elementary | 352 | — | 0 | 0 |
| Manhattan | 1 | 1 | 2 | 01M134 | Elementary | 231 | 1 | 1 | 1:231 |
| Manhattan | 1 | 1 | 2 | 01M137 | Elementary | 131 | — | 0 | 0 |
| Manhattan | 1 | 1 | 2 | 01M140 | K-8 | 344 | 1 | 1 | 1:344 |
dbn | text | Acharacter 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. | 0% | 11X12128Q17526Q495 |
school_level | categorical | A single-character code that indicates the education level. | 0% | ElementaryHigh SchoolJunior High-Intermediate…of 7 |
student_enrollment | integer | The total enrollment count of students | 0% | 318365178 |
full_time_licensed | categorical | Number of full time licensed PE teachers | 30% | 123of 17 |
part_time_licensed | integer | Number of F status PE teachers | 98% | 1of 1 |
part_time_licensed_1 | categorical | Number of itinerant PE teachers | 99% | 12of 2 |
part_time_licensed_2 | categorical | Sum of F status and itinerant | 97% | 12of 2 |
total_part_time_and | categorical | The total number of part time and full time licensed PE teachers | 0% | 102of 19 |
shared_licensed_pe | boolean | — | 98% | Trueof 1 |
ratio_of_full_time | text | — | 0% | 01:3181:173 |