About this Dataset

Scorecard Ratings

Street and sidewalk cleanliness ratings.

NOTE: Due to a software coding error that’s since been corrected, some cleanliness rating data between November 2018 and July 2019 was found to be incomplete, and citywide scores cannot be re-calculated at the level of confidence required to be included in scorecard open data set.
Organization: City of New York
Last updated: 2020-11-10T17:05:02.491159
Tags: acceptable-clean, bids, cleaning-section, community-board, dsny

Tables

Table 1

@usgov.city_of_new_york_scorecard_ratings.table_1

640.16 kB
47,570 rows
13 columns

CREATE TABLE table_1 (
  "month" VARCHAR,
  "borough" VARCHAR,
  "community_board" BIGINT,
  "district" VARCHAR,
  "cleaning_section" VARCHAR,
  "acceptable_streets" DOUBLE  -- Acceptable Streets %,
  "acceptable_sidewalks" DOUBLE  -- Acceptable Sidewalks %,
  "acceptable_streets_previous_month" DOUBLE  -- Acceptable Streets % - Previous Month,
  "acceptable_sidewalks_previous_month" DOUBLE  -- Acceptable Sidewalks % - Previous Month,
  "acceptable_streets_previous_year" DOUBLE  -- Acceptable Streets % - Previous Year,
  "acceptable_sidewalks_previous_year" DOUBLE  -- Acceptable Sidewalks % - Previous Year,
  "acceptable_streets_previous_fiscal_quarter" DOUBLE  -- Acceptable Streets % - Previous Fiscal Quarter,
  "acceptable_sidewalks_previous_fiscal_quarter" DOUBLE  -- Acceptable Sidewalks % - Previous Fiscal Quarter
);