Spill Incidents from January 1, 1996 to June 30, 2022

Note: Please use this link to leave the data view and to see the full description: https://data.ct.gov/Environment-and-Natural-Resources/Spill-Incidents/wr2a-rnsg

Description of Dataset:

This data set represents information reported between July 1, 1996 and June 30, 2022 to the Department of Energy and Environmental Protection (CT DEEP), generally to the CT DEEP Dispatch Center, regarding releases of substances to the environment, generally through accidental spills. For information related to releases reported to CT DEEP from July 1, 2022 to the present, go to Incident Reports for Releases Reported to CT DEEP July 1, 2022 to present at: https://connecticut.hazconnect.com/listincidentpublic.aspx

For a dataset related to releases reported to CT DEEP from July 1, 2022 to recent refer to the CT Open Data dataset: https://data.ct.gov/Environment-and-Natural-Resources/Spill-Incidents-from-July-1-2022-to-Recent-for-Dow/ffju-s5c5

Connecticut General Statutes Section 22a-450 requires anyone who causes any discharge, spillage, uncontrolled loss, seepage or filtration of oil or petroleum or chemical liquids or solid, liquid or gaseous products, or hazardous wastes which poses a potential threat to human health or the environment to report that release to the CT DEEP. Reports of releases from other persons are also included in this dataset.

Examples of what may be included in a spill incident record includes: Administrative information (unique spill case number). Spill date/time. Location. Spill source and cause. Material(s) and material type spilled. Quantity spilled. Measurement units. Surface water bodies affected.

Data limitations and factors to consider when using this data:

This data is limited to information about a spill incident as it was known at the time it was reported to CT DEEP. Although some data reflects updated information after the time of the initial notification, CT DEEP is unable to field check and verify all reported information. Therefore, information later determined to be incomplete or inaccurate may exist in this data set. There may also be spelling errors or other unintentionally inaccurate data that was transcribed in the spill incident report.

This dataset is a subset of records and information that may be available about releases that have occurred at specific locations. This dataset does not replace a full review of files publicly available either on-line and/or at CT DEEP’s Records Center.

For a complete review of agency records for this or other agency programs, you can perform your own search in our DEEP public file room located at 79 Elm Street, Hartford CT or at our DEEP Online Search Portal at: https://filings.deep.ct.gov/DEEPDocumentSearchPortal/Home .

If errors are found or there are questions about the data, please contact the program unit using the following email address: DEEP.SpillsDocs@ct.gov

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"ct-gov/spill-incidents-from-january-1-1996-to-june-30-wr2a-rnsg\".\"spill_incidents_from_january_1_1996_to_june_30\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.