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).
This dataset has the following 20 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Spill Number | spill_number | text | Program-specific spill identification number. | 9804657 9975456 9508313 9104571 9611561 view top 100 |
Program Facility Name | program_facility_name | text | Program name of the site or facility. | UNKNOWN RESIDENCE ROADWAY RESIDENTIAL COMMERCIAL view top 100 |
Street 1 | street_1 | text | Street address or location for the address for the spill. | 260 HUDSON RIVER ROAD 260 HUDSON RIVER RD MAIN STREET 240 AIRPORT ROAD BROADWAY view top 100 |
Street 2 | street_2 | text | Additional street address or location information for the spill. | BUILDING 67 260 HUDSON RIVER ROAD SUITE 200 RT 5 ROADWAY view top 100 |
Locality | locality | text | City, town or village of the address of the spill. | BROOKLYN MANHATTAN BRONX QUEENS ROCHESTER view top 100 |
County | county | text | County location of the spill. | Westchester Suffolk Nassau Queens Erie view top 100 |
ZIP Code | zip_code | text | Zip code of the address of the spill. US zip codes include four- digit zip code extension, if available. (Note: zip code is not reported for many spills) | 14624 14450 14580 14150 14606 view top 100 |
SWIS Code | swis_code | text | Four-digit State Wide Information System (SWIS) code identifying county, and city or town where spill is physically located. | 4101 2401 3101 3020 0301 view top 100 |
DEC Region | dec_region | number | NYSDEC Region where the spill is located: Region 1: (Long Island) Nassau and Suffolk counties; Region 2: (New York City) Brooklyn, Bronx, Manhattan, Queens and Staten Island; Region 3: (Lower Hudson Valley) Dutchess, Orange, Putnam, Rockland, Sullivan, Ulster and Westchester counties; Region 4: (Capital Region/Northern Catskills) Albany, Columbia, Delaware, Greene, Montgomery, Otsego, Rensselaer, Schenectady and Schoharie counties; Region 5: (Eastern Adirondacks/Lake Champlain) Clinton, Essex, Franklin, Fulton, Hamilton, Saratoga, Warren and Washington counties; Region 6: (Western Adirondacks/Eastern Lake Ontario) Herkimer, Jefferson, Lewis, Oneida and St. Lawrence counties; Region 7: (Central New York) Broome, Cayuga, Chenango, Cortland, Madison, Onondaga, Oswego, Tioga and Tompkins counties; Region 8: (Western Finger Lakes) Chemung, Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Steuben, Wayne and Yates counties; Region 9: (Western New York) Allegany, Chautauqua, Cattaraugus, Erie, Niagara and Wyoming counties. | 3 2 1 4 8 view top 100 |
Spill Date | spill_date | calendar_date | Date of spill. (Dates older than 1978 are estimates.) | 2012-10-29T00:00:00.000 2006-06-28T00:00:00.000 2011-08-28T00:00:00.000 2012-10-30T00:00:00.000 2012-10-31T00:00:00.000 view top 100 |
Received Date | received_date | calendar_date | Date spill information received. | 2012-11-13T00:00:00.000 2008-12-31T00:00:00.000 2009-12-31T00:00:00.000 2009-03-30T00:00:00.000 2010-06-30T00:00:00.000 view top 100 |
Contributing Factor | contributing_factor | text | Cause of spill: Unknown; Human Error; Traffic Accident; Equipment Failure; Vandalism; Tank Test Failure; Housekeeping; Deliberate; Abandoned Drums; Tank Failure; Tank Overfill; Storm; Other. | Equipment Failure Unknown Other Human Error Traffic Accident view top 100 |
Waterbody | waterbody | text | Name of surface water body affected by the spill. Filled in when resource affected is surface water. | NONE HUDSON RIVER EAST RIVER CREEK ON LAND view top 100 |
Source | source | text | Source of spill (Facility Type): Unknown; Commercial/Industrial; Institutional, Educational, Gov., Other; Major Facility (MOSF) > 400,000 gal; Non Major Facility > 1,100 gal; Gasoline Station or other PBS Facility; Passenger Vehicle; Commercial Vehicle; Tank Truck; Private Dwelling; Vessel; Railroad Car; Transformer; Chemical Bulk Storage Facility. | Commercial/Industrial Private Dwelling Commercial Vehicle Unknown Institutional, Educational, Gov., Other view top 100 |
Close Date | close_date | calendar_date | Spill close date. | 2013-05-10T00:00:00.000 2013-03-27T00:00:00.000 1986-06-01T00:00:00.000 1987-03-31T00:00:00.000 2003-03-03T00:00:00.000 view top 100 |
Material Name | material_name | text | Common name of spilled substance/material. | #2 fuel oil gasoline unknown petroleum diesel transformer oil view top 100 |
Material Family | material_family | text | Represents the family of the spilled material: Petroleum, Oxygenates, Hazardous Material, Other. | Petroleum Other Hazardous Material Oxygenates view top 100 |
Quantity | quantity | number | Amount of substance found/spilled. (If unknown: “0”) Note that the quantity can include amount of contaminated soil or water that is combined with the spilled material. | 0.00 1.00 5.00 10.00 2.00 view top 100 |
Units | units | text | Units for amount of substance found/spilled: Gallons or Pounds (Field may be blank if not reported.) | Gallons Pounds view top 100 |
Recovered | recovered | number | Amount of material recovered, if applicable. “Recovered” material units are the same as the “Quantity” spill units. (If amount recovered is unknown: “0”). Note that the quantity recovered can be greater than the amount spilled when contaminated soil or water is collected with the spilled material. | 0.00 1.00 5.00 10.00 2.00 view top 100 |