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 Kansas oil and gas well register, reconciling it, dating it, and delivering it in a usable form.
Why the stream, not the snapshot
This register moves: wells are added, classes change, plugging dates come in. A snapshot says where it stood one morning. The difference between two says which leases just gained a well and which wells just became the State’s problem — and for anyone holding acreage, that difference is the whole signal.
What is in it
Every field below is measured on the delivered rows, not on the service — asking the service for not null returns 100% on columns that are mostly empty strings. A ⚠️ marks a column the source does not contain.
| Field | Description | Filled |
|---|---|---|
kgs_well_id | The Survey's well id — the unique key | 100.0 % |
api_number | API number. NOT unique: 576 are shared by more than one well | 92.1 % |
well_class | Class as the register carries it | 89.6 % |
plugged | ⚠️ ⚠️ 1 where a plugging date is on file — 178,355 wells | 100.0 % |
state_plugged | ⚠️ ⚠️ 1 where the well was plugged at public expense — 12,297 wells, the clearest sign an operator was gone | 100.0 % |
inactive | ⚠️ ⚠️ 1 where the class is Inactive Well — 14,915 wells | 100.0 % |
county | ⚠️ ⚠️ Derived from the API FIPS prefix and resolved against the publisher's own county table. 0 unresolved codes | 92.1 % |
operator | ⚠️ ⚠️ Operator of record, case-normalised for joining | 92.7 % |
lease / well_name | Lease and well names as recorded | 99.4 % |
field | ⚠️ Oil field name, case-normalised | 71.6 % |
formation | Producing formation — sparse, and marked as such everywhere | 20.6 % |
total_depth_ft | Total depth as reported | 86.4 % |
spud / completion / plug dates | ⚠️ ⚠️ Normalised to ISO from the service's epoch timestamps | 67.8 % |
county_median_depth | ⚠️ ⚠️ The median depth of the county the well is in — computed here, published nowhere | 100.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.
⚠️ plugged and well_class disagree on
92,867 wells classed as plugged with no date, and 26,002 wells
dated under another class. We ship both columns rather than reconcile them,
and anyone building on this file must decide which they mean.
⚠️ state_plugged is a fact about a file: the
Commission could not find a responsible party when it acted. It is not a
finding against the company named in operator, and it must not
be presented as one.
What it costs
- Change feed — USD 300 / monthOr USD 3 000 a year. At every collection, what came in, went out or changed since the previous one. This is the part that does not age.
- One slice — USD 90 / monthThe feed restricted to a single county, for those who do not need the rest.
- Full snapshot — USD 4 000, onceThe state of the register on the day of delivery, every field included. Listed last on purpose : a snapshot ages.
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 — the same grid, a different thing sold.