ct-gov/spill-incidents-from-july-1-2022-to-recent-for-ffju-s5c5
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 23 days ago
Indexed 6 hours ago

Spill Incidents from July 1, 2022 to Recent for Download

This data set represents information reported after 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.

The update frequeny on this data set is about once a month.

For current 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, 1996 to June 30, 2022 refer to the CT Open Data dataset: https://data.ct.gov/Environment-and-Natural-Resources/Spill-Incidents-from-January-1-1996-to-June-30-202/wr2a-rnsg

This dataset is a snapshot of data from the live system that is updated periodically to provide to public users the download capabilities offered from the CT Open Data platform.

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.

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 idoes not 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 (https://portal.ct.gov/DEEP/About/Environmental-Quality-Records-Records-Center-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-july-1-2022-to-recent-for-ffju-s5c5\".\"spill_incidents_from_july_1_2022_to_recent_for\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • spill_incidents_from_july_1_2022_to_recent_for
     
     
     
     
     
Upstream Metadata