Newsrack Inspections by US Government | Media and Entertainment

About this Dataset

Newsrack Inspections

Tracks complaints, inspections and reinspections of News racks and reports on the Inspection results.
Organization: City of New York
Last updated: 2020-11-10T17:01:50.545041
Tags: inspection, news-rack, newsrack, nis

Tables

Table 1

@usgov.city_of_new_york_newsrack_inspections.table_1

259.93 KB
6348 rows
16 columns


CREATE TABLE table_1 (
  "newsracklocationid" BIGINT,
  "boroughname" VARCHAR,
  "publishername" VARCHAR,
  "publicationname" VARCHAR,
  "newsrackstatus" VARCHAR,
  "newsrackstatustype" VARCHAR,
  "newsrackstatusdate" VARCHAR,
  "newsrackactive" VARCHAR,
  "onstreetname" VARCHAR,
  "fromstreetname" VARCHAR,
  "tostreetname" VARCHAR,
  "compassdirection" VARCHAR,
  "specificlocation" VARCHAR,
  "communitydistrictleft" DOUBLE,
  "lastinspecteddate" VARCHAR,
  "lastinspectionresult" VARCHAR
);