From a 500-row sample across 17 columns.
Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| borough | geographical | admin_district | ats_code | location_name | grade_level | building_code | building_name | address | building_ownership | room_no | area |
|---|---|---|---|---|---|---|---|---|---|---|---|
| K | 22 | 22 | 22K312 | P.S. 312 Bergen Beach | Elementary | K312 | P.S. 312 - Brooklyn | 7103 Avenue T | DOE Owned | 345 | 676 |
| Q | 25 |
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% | KXQof 5 |
geographical | integer | A two-character alphanumeric identifier of a school grade. | 0% | 21031 |
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% | 75210 |
ats_code | text | A four-character alphanumeric code used by the ATS system to uniquely identify an organization. | 0% | 75R02575X176 |
GET /api/datasets/xqmg-7z3j GET /api/datasets/xqmg-7z3j/quality GET /api/datasets/xqmg-7z3j/related GET /api/columns?dataset=xqmg-7z3j
grade_level| 25 |
| 25Q120 |
| P.S. 120 Queens |
| Elementary |
| Q120 |
| P.S. 120 - Queens |
| 58-01 136 Street |
| DOE Owned |
| GYM |
| 3850 |
| M | 1 | 1 | 01M063 | The STAR Academy - P.S.63 | Elementary | M063 | P.S. 63 - Manhattan | 121 East 3 Street | DOE Owned | 417 | 1500 |
| M | 1 | 1 | 01M015 | P.S. 015 Roberto Clemente | Elementary | M015 | P.S. 15 - Manhattan | 333 East 4 Street | DOE Owned | GYM. | 3243 |
| M | 1 | 1 | 01M015 | P.S. 015 Roberto Clemente | Elementary | M015 | P.S. 15 - Manhattan | 333 East 4 Street | DOE Owned | Outdoor Yard 1 | 14953 |
| M | 1 | 1 | 01M019 | P.S. 019 Asher Levy | Elementary | M019 | P.S. 19 - Manhattan | 185 1 Avenue | DOE Owned | GYM | 3942 |
| M | 1 | 1 | 01M019 | P.S. 019 Asher Levy | Elementary | M019 | P.S. 19 - Manhattan | 185 1 Avenue | DOE Owned | Outdoor Yard 1 | 28121 |
| M | 1 | 1 | 01M020 | P.S. 020 Anna Silver | Elementary | M020 | P.S. 20 - Manhattan | 166 Essex Street | DOE Owned | GYM | 4000 |
| M | 1 | 1 | 01M020 | P.S. 020 Anna Silver | Elementary | M020 | P.S. 20 - Manhattan | 166 Essex Street | DOE Owned | Outdoor Yard 1 | 3191 |
| M | 1 | 1 | 01M034 | P.S. 034 Franklin D. Roosevelt | K-8 | M034 | P.S. 34 - Manhattan | 730 East 12 Street | DOE Owned | 124 | 3450 |
Showing 12 of 17 columns. All of them are listed below.
75X010location_name | text | The name by which the organization is known. For a learning community, it is the official title of the school. | 0% | South Richmond High Scho…P.S. X176P.S. X010 |
grade_level | categorical | A two-character alphanumeric identifier of a school grade. | 0% | High schoolElementaryJunior High-Intermediate…of 7 |
building_code | text | An identifier of a physical structure housing different types of organizations, schools and programs. Buildings can be portable classrooms, trailers, or mini schools. An athletic field can also be assigned a building code as is a playground associated with a high school building. | 0% | X425M480M460 |
building_name | text | The name by which a building is associated. For a learning community, the official title of the school. | 0% | Evander Childs Hs - XJulia Richman Ed. Comple…Washington Irving Hs - M… |
address | text | The address of a site | 0% | 800 East Gun Hill Road317 East 67 Street40 Irving Place |
building_ownership | categorical | An indicator that shows whether a building is leased or owned by the DOE. | 0% | DOE OwnedTax Levy LeaseGratis Leaseof 3 |
room_no | text | The room number | 0% | Outdoor Yard 1GYMOutdoor Yard 2 |
area | integer | — | 0% | 650042346175 |
function | text | — | 0% | GymnasiumOutdoor YardDance Room |
is_school_co_located | categorical | If the school is co-located or not | 0% | truefalseof 2 |
inside_v_outside | categorical | — | 0% | InsideOutdoorOffsiteof 3 |
is_the_space_shared | categorical | Whether the space is shared by another school | 0% | truefalseof 2 |
space_used_for_any | boolean | Whether the space is used for a purpose other than PE | 0% | FalseTrueof 2 |