From a 500-row sample across 25 columns.
streetpermitteecommunityboard+18latitudelongitudeborough+2latitudentalongitude+3ntabinbblMappable — coordinate pair `latitude` / `longitude`.
Open on the map →| entityid | schoolname | number | street | city | state | borough | zipcode | lastinspection | permittee | inspectiondate | ptet |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 50082351 | DISTRICT 30 PRE-K CENTER | 27-35 | JACKSON AVENUE | Long Island City | NY | Queens | 11101 | 2026-04-01T00:00:00.000 | NEW YORK CITY DEPARTMENT OF EDUCATION | 2024-01-25T00:00:00.000 | 2530 |
| 50016657 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
entityid | text | Unique identifier for the establishment (school) | 0% | 500332404145751440740823 |
schoolname | text | Establishment (school) name | 0% | UNITED TALMUDICAL ACADEM…YESHIVA KEHILATH YAKOVYESHIVAS NOVOMINSK |
number | text | Building number for establishment (school) location | 0% | 100330345 |
street | text | Street name for establishment (school) location | 0% | 16 AVENUEOCEAN PARKWAYBEDFORD AVENUE |
GET /api/datasets/5ery-qagt GET /api/datasets/5ery-qagt/quality GET /api/datasets/5ery-qagt/related GET /api/columns?dataset=5ery-qagt
latitudezipcodenta+4latitudentalongitude+2streetlatitudelongitude+4| ALC - LINDEN ACADEMY |
| 30-48 |
| LINDEN PLACE |
| Flushing |
| NY |
| Queens |
| 11354 |
| 2026-06-24T00:00:00.000 |
| NEW YORK CITY DEPARTMENT OF EDUCATION |
| 2026-06-24T00:00:00.000 |
| 2530 |
| 40542917 | P.S. 186 DR. IRVING A GLADSTONE | 7601 | 19 AVENUE | Brooklyn | NY | Brooklyn | 11214 | 2026-08-05T00:00:00.000 | NEW YORK CITY DEPARTMENT OF EDUCATION | 2026-06-08T00:00:00.000 | 2530 |
| 40543661 | P.S. 226 (MAIN) | 1950 | SEDGWICK AVENUE | Bronx | NY | Bronx | 10453 | 2026-05-04T00:00:00.000 | NEW YORK CITY DEPARTMENT OF EDUCATION | 2025-10-21T00:00:00.000 | 2530 |
| 50103920 | THE NURTURING CENTER AND ACADEMY | 112-18 | SPRINGFIELD BOULEVARD | Queens Village | NY | Queens | 11429 | 2026-06-17T00:00:00.000 | THE NURTURING CENTER INC | 2025-10-10T00:00:00.000 | 2529 |
| 50039140 | TALMUDICAL SCHOOL OF BROOKLYN | 1200 | OCEAN PARKWAY | Brooklyn | NY | Brooklyn | 11230 | 2025-11-14T00:00:00.000 | YESHIVA OF BROOKLYN | 2023-12-18T00:00:00.000 | 2533 |
| 50033240 | YESHIVAS NOVOMINSK | 1690 | 60 STREET | Brooklyn | NY | Brooklyn | 11204 | 2026-06-17T00:00:00.000 | YESHIVAS NOVOMINSK | 2025-05-29T00:00:00.000 | 2533 |
| 40543602 | PS 048 ANNEX | 659 | COSTER STREET | Bronx | NY | Bronx | 10474 | 2026-06-24T00:00:00.000 | NEW YORK CITY DEPARTMENT OF EDUCATION | 2026-06-24T00:00:00.000 | 2530 |
| 50113943 | VALANCE COLLEGE PREPARATORY CHARTER SCHOOL | 97-29 | 64 ROAD | Rego Park | NY | Queens | 11374 | 2026-05-15T00:00:00.000 | VALENCE COLLEGE PREPARATORY CHARTER SCHOOL | 2025-02-14T00:00:00.000 | 2533 |
| 41415097 | BNOS SPINKA | 799 | KENT AVENUE | Brooklyn | NY | Brooklyn | 11205 | 2026-05-28T00:00:00.000 | BNOS SPINKA INC. | 2024-07-25T00:00:00.000 | 2533 |
Showing 12 of 25 columns. All of them are listed below.
city | text | Municipality of establishment (school) | 4% | BrooklynNew YorkBronx |
state | text | State of establishment (school) | 0% | NYof 1 |
borough | categorical | Borough of establishment (school) location | 0% | BrooklynQueensManhattanof 5 |
zipcode | text | Zip code of establishment (school) location | 1% | 112041121911206 |
lastinspection | datetime | Date of last inspection | 0% | 2026-07-14T00:00:00.0002026-09-23T00:00:00.0002026-05-28T00:00:00.000 |
permittee | text | Name of business owner holding the permit | 0% | NEW YORK CITY DEPARTMENT…ARCHDIOCESE OF NEW YORKELIOR CTY, LLC |
inspectiondate | datetime | Date an inspection was conducted | 0% | 2025-06-02T00:00:00.0002025-06-09T00:00:00.0002025-05-05T00:00:00.000 |
ptet | categorical | Permit Type Establishment Type - The four digit code indicating the type of permit and the type of food service establishment (FSE) | 0% | 253025332529of 4 |
site_type | categorical | The description of the type of food service establishment (FSE) | 0% | FSE (Public School Cafet…FSE (Private School Cafe…FSE (Private School Cafe…of 4 |
level | categorical | Indicator of the type of violation; Critical violations are those most likely to contribute to foodborne illness. | 20% | GCCHof 6 |
code | text | Violation code associated with inspection finding; Blank field indicates no violations were cited during inspection | 20% | 10F08A10B |
violationdescription | text | Violation description associated with inspection finding; Blank field indicates no violations were cited during inspection | 20% | Non-food contact surface…Establishment is not fre…Anti-siphonage or back-f… |
latitude | float | Latitude | 0% | 040.62366499467640.706233860525 |
longitude | float | Longitude | 0% | 0-73.990003566403-73.956621044197 |
communityboard | text | Community Board | 1% | 312301303 |
councildistrict | text | NYC Council District | 1% | 334408 |
censustract | text | Census Tract | 1% | 052900123700023200 |
bin | text | Building Identification Number | 1% | 300000033285103060167 |
bbl | text | Borough-Block-Lot | 0% | 123055170039 |
nta | text | Neighborhood Tabulation Area | 1% | BK88BK72BK75 |
borocode | categorical | Numerical code for the borough of establishment (school) location | 0% | 341of 5 |