ust-ct

Datasets

The pages of this site are free and will stay free — a public fact belongs to nobody. What is sold is the work of compiling it.

The pages of this site are free and will stay free : an official fact belongs to no one. What is sold here is the compilation work — extracting the Connecticut tank register, reconciling it, dating it, and delivering it in a usable form.

Why the stream, not the snapshot

The Department refreshes all six files weekly. Tanks come out of use, releases get reported, actions get resolved. A snapshot is a photograph of a moving file; the difference between two weeks is what a portfolio holder actually wants.

What is in it

Every field below is measured on the delivered rows. A ⚠️ marks a column none of the six source files contains — that is what you cannot get by downloading them yourself.

Fields delivered and fill rate, measured on the rows actually delivered — not estimated
FieldDescriptionFilled
facility_idThe Department's facility identifier, the key to all six files100.0 %
name⚠️ Site name, case-normalised from the source's capitals92.0 %
address⚠️ Street address, case-normalised100.0 %
town⚠️ Place name as the Department writes it100.0 %
tanks⚠️ ⚠️ Tanks on the facility, counted100.0 %
tanks_in_use⚠️ ⚠️ Of those, currently in use100.0 %
construction⚠️ ⚠️ Commonest tank construction at the facility, from tankconstructioncd96.0 %
bare_steel⚠️ ⚠️ 1 where any tank is bare or asphalt-coated steel — the federal upgrade target, and the one physical risk signal in these files100.0 %
first_tank⚠️ ⚠️ Earliest installation date at the facility, ISO96.4 %
violations⚠️ ⚠️ Compliance entries, joined from the compliance file100.0 %
red_tags⚠️ ⚠️ Red-tag entries, joined100.0 %
enforcement⚠️ ⚠️ Enforcement actions, joined on relatedfacilityid100.0 %
releases⚠️ ⚠️ Reported releases, joined on ustid — NOT on lustid, which matches 0 %100.0 %
last_release⚠️ ⚠️ Date of the most recent reported release20.1 %

The 13 fields marked ⚠️ do not exist in the source : we add them — a join, a normalisation, or a reconstructed history. That is the part a buyer cannot reproduce by downloading the official file.

⚠️ The names of contacts are in the source and are delivered in the dataset, but appear on no page of this site: they are natural persons’ names. Coordinates are not carried — this answers a question about records, not a map.

What it costs

Not a consumer reporting agency. This site and the datasets sold from it are not consumer reports under the Fair Credit Reporting Act, and must not be used to decide anyone's eligibility for employment, credit, insurance, housing, or any other purpose covered by the FCRA. If you need a background check, use a screening company that operates as a consumer reporting agency.

Order

Tell us what you need : we reply with a sample, the field dictionary, and an invoice. No payment is taken on this site — an order opens a conversation.

Prices in USD, before any applicable tax. Delivered as CSV and Parquet, by download link. Every request is answered by hand.

Screening your own list instead of buying the set? That is Pro access, priced on volume.