Oil and Gas Data for Texas was collected from the Production Data Query Dump published and made available by the Rail Road Commission of Texas. Dataset is available for purchase here[1]. The database dump was last updated on 12/4/2014.

Well

Well data is sourced from the table og_well_completion. Using this table, the ten digit well API for each well could be constructed, in addition to providing information relating to the well county, district, type, wellbore and well shutin dates, as well as Rule 14(B)(2) information.

Production data for each well is sourced from table og_lease_cycle, in which the lease number for a well is used in order to obtain the names of the operator, field and lease, in addition to the production volumes for gas, oil, condensate and case head gas.