Historical Environmental Spill Incidents Log

Columns

• Spill Number: A unique identifier assigned to each spill incident for tracking and reference purposes.
• Program Facility Name: The name of the facility or programme associated with the spill incident.
• Street 1: Detailed address information specifying the primary location where the spill occurred.
• Street 2: Supplementary address information for the spill location.
• Locality: The city, town, or locality (e.g., Brooklyn, Manhattan) where the spill took place.
• County: The county (e.g., Westchester, Suffolk) where the incident occurred.
• ZIP Code: Specific geographic postal code for localised analysis.
• SWIS Code: Solid Waste Information System Code, providing a specific code related to waste management.
• DEC Region: Department of Environmental Conservation Region number where the spill incident occurred.
• Spill Date: The date when the spill incident took place.
• Received Date: The date when the spill was reported to the authorities.
• Contributing Factor: The primary reason or factor contributing to the incident (e.g., Equipment Failure).
• Waterbody: The name of the surface water body affected by the spill, if any.
• Source: The origin classification of the spill (e.g., Commercial/Industrial, Private Dwelling).
• Close Date: The date when cleanup activity finished and paperwork was completed.
• Material Name: Specific name of the spilled substance (e.g., #2 fuel oil, gasoline).
• Material Family: Broader category of the spilled material (e.g., Petroleum).
• Quantity: The amount of material spilled.
• Units: The unit of measurement for the spilled material (e.g., Gallons, Pounds).
• Recovered: The amount of spilled material that was successfully recovered during cleanup.

Distribution

• Format: CSV (Spill_Incidents.csv)
• Size: Approximately 96.52 MB
• Structure: 20 Columns
• Rows: Approximately 543,000 records (Valid count: 543k)

Usage

• Environmental Impact Analysis: Assessing the frequency and volume of spills affecting local waterbodies and land.
• Regulatory Compliance: Monitoring facility safety records and adherence to state spill regulations.
• Risk Assessment: Evaluating potential environmental hazards for real estate development or insurance underwriting.
• Trend Analysis: Identifying temporal patterns in spill occurrences and reporting lags over decades.
• Operational Improvement: Studying contributing factors like equipment failure to implement preventative measures in industrial settings.

Coverage

• Geographic Scope: Concentrated on New York State regions, including specific data for counties such as Westchester and Suffolk, and boroughs like Brooklyn and Manhattan.
• Time Range: Covers incidents with reported dates spanning from 1900 through to December 2023.
• Demographic/Sector Scope: Includes spills from various sources such as Commercial/Industrial facilities (29%), Private Dwellings (21%), and other origins.
• Material Scope: Predominantly covers Petroleum spills (85%), alongside other hazardous materials.

License

Who Can Use It

• Environmental Scientists: For studying pollution patterns and ecological recovery.
• Data Analysts: For visualising hazardous material distribution and incident timelines.
• Urban Planners: For identifying areas with historical contamination issues.
• Policy Makers: For drafting tighter regulations based on common contributing factors.
• Concerned Citizens: For checking local spill history in their residential areas.

Dataset Name Suggestions

• State Petroleum and Hazardous Spill Registry
• Historical Environmental Spill Incidents Log
• Pollution and Contaminant Release Database
• Hazardous Material Recovery and Incident Tracker

Attributes