Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

DOHMH School Cafeteria Inspections (Historical)

9hxz-c2kjHealth23 columns
This is an official DOHMH dataset. Creating derivative/community datasets based on this dataset is allowed so long as it is done in a manner that is not misleading and does not imply endorsement of such datasets by DOHMH. The dataset contains older inspection data from 2018 and 2019 for cafeterias permitted in public, private, and parochial schools in NYC. Data for cafeterias that have ceased operations and any violations cited during the inspection that were dismissed during adjudication are excluded from this dataset.
View on NYC Open Data↗

Quality

A90.4 / 100

From a 500-row sample across 23 columns.

completeness98/ 25% weight
consistency72/ 20% weight
accuracy95/ 20% weight
timeliness85/ 15% weight
usability100/ 20% weight
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • DOHMH School Cafeteria Inspections (2020-Present)0.71
    joins onbincodelongitude+18
  • NYC Pool Inspections0.36
    joins onbinntabbl
  • NYC Cooling Tower System Inspection Results0.35
    joins onbinlongitudelatitude+2
  • Recognized Shop Healthy Stores0.35
    joins onbinlongitudelatitude+3

Geography

Mappable — coordinate pair `latitude` / `longitude`.

Open on the map →

Sample rows

entityidschoolnamenumberstreetaddress_line_1address_line_2boroughzipcodelastinspectionpermitteeinspectiondatelevel
347831EMBER CHARTER SCHOOL FOR MINDFUL EDUCATION616QUINCY ST616 QUINCY STBROOKLYN, NY 11221Brooklyn112212019-10-08T00:00:00.000ZEMBER CHARTER SCHOOL FOR MINDFUL EDUCATION2017-10-13T00:00:00.000ZC

Columns

23 queryable · 23 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
entityidtextUnique identifier for the establishment (school)0%82920131467326183
schoolnametextEstablishment (school) name0%UNITED TALMUDICAL ACADEM…MERKAZ HATORAH OF BELLE …TALMUDICAL SCHOOL OF BRO…
numbertextBuilding number for establishment (school) location0%10042560
streettextStreet name for establishment (school) location0%OCEAN PARKWAYBEDFORD AVENUE

Query this from your own app

GET /api/datasets/9hxz-c2kj
GET /api/datasets/9hxz-c2kj/quality
GET /api/datasets/9hxz-c2kj/related
GET /api/columns?dataset=9hxz-c2kj
Active NYC Health Code Regulated Child Care Programs
0.34
joins onbinlongitudelatitude+3
  • Metal Content of Consumer Products Tested by the NYC Health Department0.33
  • DOHMH Indoor Environmental Complaints0.31
    joins onbinlongitudelatitude+2
  • NYC Farmers Markets0.31
    joins onlongitudelatitudeborough
    • 130374
    WILLIAM SPYROPOULOS SCHOOL
    19610
    NORTHERN BOULEVARD
    19610 NORTHERN BOULEVARD
    FLUSHING, NY 11358
    Queens
    11358
    2019-01-18T00:00:00.000Z
    NICHOLAS GREEK ST.
    2017-11-15T00:00:00.000Z
    C
    54040P.S. 145 THE BLOOMINDALE SCHOOL150WEST 105 STREET150 WEST 105 STREETNEW YORK, NY 10025Manhattan100252019-11-25T00:00:00.000ZNEW YORK CITY DEPARTMENT OF EDUCATION2019-11-25T00:00:00.000ZG
    54627P.S. 119 BROOKLYN3829AVENUE K3829 AVENUE KBROOKLYN, NY 11210Brooklyn112102019-07-24T00:00:00.000ZNEW YORK CITY DEPARTMENT OF EDUCATION2018-01-08T00:00:00.000ZG
    82920MERKAZ HATORAH OF BELLE HARBOR505BEACH 129 STREET505 BEACH 129 STREETBELLE HARBOR, NY 11694Queens116942019-11-06T00:00:00.000ZHATORAH OF BELL MERCAZ2019-10-31T00:00:00.000ZAV
    330902YESHIVAT MEKOR HAIM2710avenue x2710 avenue xbrooklyn, NY 11235Brooklyn112352019-02-27T00:00:00.000ZCONGREGATION SHAARI TEFILOH OF KINGS HIGHWAY2019-02-27T00:00:00.000ZG
    108635BETHEL ELEMENTARY SCHOOL457GRAND AVENUE457 GRAND AVENUEBrooklyn, NY 11238Brooklyn112382019-11-13T00:00:00.000ZNORTHEASTERN CONFERENCE OF SEVENTH DAY ADVENTISTS2018-02-08T00:00:00.000ZC
    86813INCARNATION SCHOOL570WEST 175 STREET570 WEST 175 STREETNEW YORK, NY 10033Manhattan100332019-11-12T00:00:00.000ZARCHDIOCESE OF NEW YORK2019-02-01T00:00:00.000ZC
    54737P.S. 175 BRONX200CITY ISLAND AVENUE200 CITY ISLAND AVENUEBRONX, NY 10464Bronx104642019-06-19T00:00:00.000ZNEW YORK CITY DEPARTMENT OF EDUCATION2018-06-20T00:00:00.000Z—
    331650CITY AND COUNTRY SCHOOL146W 13TH ST146 W 13TH STNEW YORK, NY 10011Manhattan100112019-10-08T00:00:00.000ZTHE CITY AND COUNTRY SCHOOL INC2019-10-08T00:00:00.000ZC

    Showing 12 of 23 columns. All of them are listed below.

    7 AVENUE
    address_line_1text—0%505 BEACH 129 STREET5511 QUEENS BOULEVARD1690 60TH ST
    address_line_2textMunicipality of establishment (school)0%BROOKLYN, NY 11219BROOKLYN, NY 11204BROOKLYN, NY 11206
    boroughcategoricalBorough of establishment (school) location0%BrooklynQueensManhattanof 5
    zipcodetextZip code of establishment (school) location1%112191120411230
    lastinspectiondatetimeDate of last inspection0%2019-09-11T00:00:00.000Z2019-11-25T00:00:00.000Z2019-10-07T00:00:00.000Z
    permitteetextName of business owner holding the permit0%NEW YORK CITY DEPARTMENT…ARCHDIOCESE OF NEW YORKREVOLUTION FOODS, INC.
    inspectiondatedatetimeDate an inspection was conducted0%2019-06-03T00:00:00.000Z2018-06-11T00:00:00.000Z2018-06-14T00:00:00.000Z
    levelcategoricalIndicator of the type of violation; Critical violations are those most likely to contribute to foodborne illness.12%GCAVof 5
    codetextViolation code associated with inspection finding; Blank field indicates no violations were cited during inspection12%10F08A10B
    violationdescriptiontextViolation description associated with inspection finding; Blank field indicates no violations were cited during inspection12%Non-food contact surface…Facility not vermin proo…Plumbing not properly in…
    latitudefloatLatitude0%040.58003527678640.742121816298
    longitudefloatLongitude0%0-73.850349751152-73.909719939032
    communityboardtextCommunity Board1%312301303
    councildistricttextNYC Council District1%443339
    censustracttextCensus Tract1%023200123700053500
    bintextBuilding Identification Number2%300000043040714030990
    bbltextBorough-Block-Lot0%143
    ntatextNeighborhood Tabulation Area1%BK88BK72BK75
    borocodecategorical—0%341of 5