From a 500-row sample across 41 columns.
open_datestatus_descriptionslocation_name+26ntacensus_tractlongitude+1location_namentacensus_tract+4Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| fiscal_year | system_code | location_code | location_name | beds | managed_by_name | location_type_description | location_category_description | grades_text | grades_final_text | open_date | status_descriptions |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2020 | 15K001 | K001 | P.S. 001 The Bergen | 331500010001 | DOE | General Academic | Elementary | PK,0K,01,02,03,04,05,SE | PK,0K,01,02,03,04,05 | 1965-07-01T00:00:00.000 | Open |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
fiscal_year | integer | — | 0% | 2020of 1 |
system_code | text | — | 0% | 02M04003M47902M560 |
location_code | text | — | 0% | K344K744K681 |
location_name | text | — | 0% | New Visions Charter High…New Visions Charter High…Lower Manhattan Communit… |
beds |
GET /api/datasets/wg9x-4ke6 GET /api/datasets/wg9x-4ke6/quality GET /api/datasets/wg9x-4ke6/related GET /api/columns?dataset=wg9x-4ke6
primary_address_line_1ntafax_number+5| 2020 | 17K002 | K002 | Parkside Preparatory Academy | 331700010002 | DOE | General Academic | Junior High-Intermediate-Middle | 06,07,08,SE | 06,07,08 | 1994-07-01T00:00:00.000 | Open |
| 2020 | 13K003 | K003 | P.S. 003 The Bedford Village | 331300010003 | DOE | General Academic | Elementary | PK,0K,01,02,03,04,05,SE | PK,0K,01,02,03,04,05 | 1950-07-01T00:00:00.000 | Open |
| 2020 | 75K004 | K004 | P.S. K004 | 307500013004 | DOE | Special Education | Elementary | PK,0K,01,02,03,04,05,SE | PK,0K,01,02,03,04,05,06,07,SE | 1999-07-01T00:00:00.000 | Open |
| 2020 | 16K005 | K005 | P.S. 005 Dr. Ronald McNair | 331600010005 | DOE | General Academic | Elementary | PK,0K,01,02,03,04,05,SE | PK,0K,01,02,03,04,05 | 1966-07-01T00:00:00.000 | Open |
| 2020 | 17K006 | K006 | Norma Adams Clemons Academy | 331700010006 | DOE | General Academic | Elementary | PK,0K,01,02,03,04,05,06,SE | 0K,01,02,03,04,05 | 1993-07-01T00:00:00.000 | Open |
| 2020 | 19K007 | K007 | P.S. 007 Abraham Lincoln | 331900010007 | DOE | General Academic | Elementary | PK,0K,01,02,03,04,05,SE | PK,0K,01,02,03,04,05 | 1999-07-01T00:00:00.000 | Open |
| 2020 | 13K008 | K008 | P.S. 008 Robert Fulton | 331300010008 | DOE | General Academic | K-8 | 0K,01,02,03,04,05,08,SE | PK,0K,01,02,03,04,05 | 1907-07-01T00:00:00.000 | Open |
| 2020 | 13K009 | K009 | P.S. 009 Teunis G. Bergen | 331300010009 | DOE | General Academic | Elementary | PK,0K,01,02,03,04,05,SE | PK,0K,01,02,03,04,05 | 1957-07-01T00:00:00.000 | Open |
| 2020 | 15K010 | K010 | Magnet School of Math, Science and Design Technolo | 331500010010 | DOE | General Academic | Elementary | 0K,01,02,03,04,05,06,SE | PK,0K,01,02,03,04,05 | 1930-07-01T00:00:00.000 | Open |
Showing 12 of 41 columns. All of them are listed below.
| integer |
| — |
| 0% |
307500012188331800010285310500860858 |
managed_by_name | categorical | — | 0% | DOECharterof 2 |
location_type_description | categorical | — | 0% | General AcademicSpecial EducationTransfer Schoolof 7 |
location_category_description | categorical | — | 0% | ElementaryHigh schoolJunior High-Intermediate…of 9 |
grades_text | text | — | 2% | PK,0K,01,02,03,04,05,SE09,10,11,12,SE06,07,08,SE |
grades_final_text | text | — | 4% | 09,10,11,12PK,0K,01,02,03,04,0506,07,08 |
open_date | datetime | — | 0% | 1999-07-01T00:00:00.0002004-09-08T00:00:00.0002012-07-01T00:00:00.000 |
status_descriptions | categorical | — | 0% | OpenClosedInitiated, never openedof 3 |
primary_building_code | text | — | 0% | X410X450X435 |
primary_address_line_1 | text | — | 0% | 240 EAST 172 STREET1980 LAFAYETTE AVENUE99 TERRACE VIEW AVENUE |
state_code | text | — | 0% | NYof 1 |
x_coordinate | text | — | 0% | 100877510241251017958 |
y_coordinate | text | — | 0% | 245072238502242606 |
longitude | coordinate | — | 0% | -73.911366-73.878191-73.85593 |
latitude | coordinate | — | 0% | 40.83930740.82121840.832508 |
community_district | text | — | 0% | 303201305 |
council_district | text | — | 0% | 17816 |
census_tract | text | — | 0% | 3900160040900 |
borough_block_lot | text | — | 0% | 020281700022036040039 |
nta | text | — | 0% | BX14BX39BK81 |
nta_name | text | — | 0% | East Concourse-Concourse…Mott Haven-Port MorrisBrownsville |
principal_name | text | — | 0% | NULLLisa LuftArleen Liquori |
principal_title | categorical | — | 0% | PrincipalPRINCIPALI.A. Principalof 7 |
principal_phone_number | phone | — | 0% | NULL718-381-7100718-828-0034 |
fax_number | phone | — | 0% | NULL718-345-3327917-305-1005 |
geographical_district_code | integer | — | 0% | 2109 |
administrative_district_code | integer | — | 0% | 84210 |
administrative_district_name | text | — | 0% | NULLOFFICE OF CHARTER SCHOOL…COMMUNITY SCHOOL DISTRIC… |
community_school_sup_name | text | — | 0% | NULLGALLASSIO, VINCENZAHULLA, MARIBEL |
tier_3_support_location_name | categorical | — | 0% | NULLNYCDOE Borough Office - …NYCDOE Borough Office - …of 10 |
tier_3_support_leader_name | categorical | — | 0% | NULLSAFFER, NANCYCHU, YUETof 8 |
tier_2_support_location_name | text | — | 0% | NULLSchool Support Team 2- Q…School Support Team 4- B… |
highschool_network_location | categorical | — | 0% | NULLHS07HS10of 13 |
highschool_network_name | text | — | 0% | NULLHS Network 07 Superinten…HS Network 10 Superinten… |
highschool_network | text | — | 0% | NULLCINTRON, RICHARDROTONDO, PAUL |
community_district_1 | text | — | 0% | 303201305 |
police_precinct | text | — | 0% | 407542 |