About this Dataset

Parks Inspection Program – Inspections

This dataset contains overall ratings associated with property inspections. Each row represents an individual inspection. Data Dictionary and User Guide can be found here: https://docs.google.com/spreadsheets/d/17LSfFUkhHPHJS4hszOYMVmVyU3xVF7J_dILhtIwWKKA/edit?usp=sharing A complete list of all datasets in the series can be found here.
Organization: City of New York
Last updated: 2021-08-07T17:57:08.309513
Tags: omp, park-inspection, pip

Tables

Table 1

@usgov.city_of_new_york_parks_inspection_program_inspections.table_1

3.8 MB
143,798 rows
20 columns

CREATE TABLE table_1 (
  "prop_id" VARCHAR,
  "ampsdistrict" VARCHAR,
  "inspection_id" BIGINT,
  "season" VARCHAR,
  "round" BIGINT,
  "date" VARCHAR,
  "begininspection" VARCHAR,
  "endinspection" VARCHAR,
  "inspection_year" BIGINT,
  "inspector" BIGINT,
  "inspector2" DOUBLE,
  "overall_condition" VARCHAR,
  "cleanliness" VARCHAR,
  "safety_condition" VARCHAR,
  "structural_condition" VARCHAR,
  "visitorcount" DOUBLE,
  "closed" VARCHAR  -- Closed?,
  "comments" VARCHAR,
  "inspectiontype" VARCHAR,
  "inspaddeddate" VARCHAR
);