wells-co

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 Colorado well permit register, reconciling it, dating it, and delivering it in a usable form.

Why the stream, not the snapshot

This register moves every day. Permits are issued, wells are reported as constructed, permits lapse. A snapshot records where the register stood on one morning; the difference between two mornings is what a portfolio holder wants to be told about — particularly a permit that has just expired.

What is in it

Every field below is measured on the delivered rows, not estimated. A ⚠️ marks a column the source file does not contain.

Fields delivered and fill rate, measured on the rows actually delivered — not estimated
FieldDescriptionFilled
receiptThe Division's receipt number — the unique key100.0 %
permitPermit number. NOT unique: one permit covers successive applications92.3 %
statusCurrent status, verbatim100.0 %
built⚠️ ⚠️ 1 where the status is Well Constructed — the answer a buyer needs first100.0 %
expired⚠️ ⚠️ 1 where the permit lapsed without the well being built — 98,256 of them100.0 %
county⚠️ County, case-normalised99.9 %
aquifer⚠️ ⚠️ First named aquifer, split out of a delimited list96.9 %
denver_basin⚠️ ⚠️ 1 where a named Denver Basin aquifer applies — a different legal regime100.0 %
primary_use⚠️ ⚠️ First decreed use, split out of a delimited list100.0 %
depth_ftWell depth as reported63.4 %
yield_gpmYield in gallons per minute as reported23.4 %
static_water_levelStatic water level, with its date48.6 %
issued / expires / constructed / plugged⚠️ ⚠️ Four dates, normalised to ISO from mixed source formats99.0 %
county_median_depth⚠️ ⚠️ The median depth of the county the permit sits in — computed here, published nowhere100.0 %

The 8 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 source file’s applicant name is not in this dataset. It is not requested at download and not stored: these are largely rural homes, and nothing about the question this register answers requires a name.

⚠️ A blank in depth_ft is not a zero. It means the Division was not told. Any aggregate built from this file must exclude blanks rather than count them as noughts — and should use a median, because a handful of holes go thousands of feet down.

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.

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