About this Dataset

Rodent Inspection

Dataset contains information on rat inspections.

Rat Information Portal Data Release Notes April 20, 2015

The Rat Information Portal (RIP) is a web-based mapping application where users can view rat inspection data.

Data sources: NYC Department of Health and Mental Hygiene (DOHMH), Division of Environmental Health Pest Control Database

Notes on data limitations: Please note that if a property/taxlot does not appear in the file, that does not indicate an absence of rats - rather just that it has not been inspected. Similarly, neighborhoods with higher numbers properties with active rat signs may not actually have higher rat populations but simply have more inspections.

See our Data Disclaimer:
http://www.nyc.gov/rats
Organization: City of New York
Last updated: 2020-11-10T17:04:31.674241
Tags: dohmh, health, inspection, rodent

Tables

Table 1

@usgov.city_of_new_york_rodent_inspection.table_1

297.04 MB
2,781,288 rows
25 columns

CREATE TABLE table_1 (
  "inspection_type" VARCHAR,
  "job_ticket_or_work_order_id" BIGINT,
  "job_id" VARCHAR,
  "job_progress" BIGINT,
  "bbl" DOUBLE,
  "boro_code" BIGINT,
  "block" BIGINT,
  "lot" BIGINT,
  "house_number" VARCHAR,
  "street_name" VARCHAR,
  "zip_code" DOUBLE,
  "x_coord" DOUBLE,
  "y_coord" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "borough" VARCHAR,
  "inspection_date" VARCHAR,
  "result" VARCHAR,
  "approved_date" VARCHAR,
  "location" VARCHAR,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "bin" DOUBLE,
  "nta" VARCHAR
);