Dataset: Spill Incidents

About this Dataset

Spill Incidents

This dataset contains records of spills of petroleum and other hazardous materials. Under State law and regulations, spills that could pollute the lands or waters of the state must be reported by the spiller (and, in some cases, by anyone who has knowledge of the spill). Examples of what may be included in a spill record includes: Administrative information (DEC region and unique seven-digit spill number). Program facility name. Spill date/time. Location. Spill source and cause. Material(s) and material type spilled. Quantity spilled and recovered. Units measured. Surface water bodies affected. Close date (cleanup activity finished and all paperwork completed).
Organization: State of New York
Last updated: 2020-11-12T04:00:29.810944
Tags: chemical-spills, hazardous-materials, oil, petroleum-spills, spills

Tables

Table 1

@usgov.state_of_new_york_spill_incidents.table_1

24.37 MB
557341 rows
20 columns


CREATE TABLE table_1 (
  "spill_number" BIGINT,
  "program_facility_name" VARCHAR,
  "street_1" VARCHAR,
  "street_2" VARCHAR,
  "locality" VARCHAR,
  "county" VARCHAR,
  "zip_code" VARCHAR,
  "swis_code" BIGINT,
  "dec_region" BIGINT,
  "spill_date" TIMESTAMP,
  "received_date" TIMESTAMP,
  "contributing_factor" VARCHAR,
  "waterbody" VARCHAR,
  "source" VARCHAR,
  "close_date" TIMESTAMP,
  "material_name" VARCHAR,
  "material_family" VARCHAR,
  "quantity" DOUBLE,
  "units" VARCHAR,
  "recovered" DOUBLE
);