Hazardous Waste Manifest Data (CT) 1984 – 2008

NOTES:

1. Please use this link to leave the data view to see the full description: https://data.ct.gov/Environment-and-Natural-Resources/Hazardous-Waste-Manifest-Data-CT-1984-2008/h6d8-qiar

2. Please Use ALL CAPS when searching using the "Filter" function on text such as: LITCHFIELD. But not needed for the upper right corner "Find in this Dataset" search where for example "Litchfield" can be used.

Dataset Description:

We know there are errors in the data although we strive to minimize them. Examples include:

• Manifests completed incorrectly by the generator or the transporter - data was entered based on the incorrect information. We can only enter the information we receive.

• Data entry errors – we now have QA/QC procedures in place to prevent or catch and fix a lot of these.

• Historically there are multiple records of the same generator. Each variation in spelling in name or address generated a separate handler record. We have worked to minimize these but many remain. The good news is that as long as they all have the same EPA ID they will all show up in your search results.

• Handlers provide erroneous data to obtain an EPA ID - data entry was based on erroneous information. Examples include incorrect or bogus addresses and names. There are also a lot of MISSPELLED NAMES AND ADDRESSES!

• Missing manifests – Not every required manifest gets submitted to DEEP. Also, of the more than 100,000 paper manifests we receive each year, some were incorrectly handled and never entered.

• Missing data – we know that the records for approximately 25 boxes of manifests, mostly prior to 1985 were lost from the database in the 1980’s.

• Translation errors – the data has been migrated to newer data platforms numerous times, and each time there have been errors and data losses.

• Wastes incorrectly entered – mostly due to complex names that were difficult to spell, or typos in quantities or units of measure.

Since Summer 2019, scanned images of manifest hardcopies may be viewed at the DEEP Document Online Search Portal: https://filings.deep.ct.gov/DEEPDocumentSearchPortal/

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/hazardous-waste-manifest-data-ct-1984-2008-h6d8-qiar\".\"hazardous_waste_manifest_data_ct_1984_2008\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.