X

Track changes made to this page

If you find this page useful and would like to be notified of changes made to this page, start by inputting your email below.



Privacy policy
Close this window

powered by ChangeDetection

Texas Oil and Gas Data Sources

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. 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.

Well Production

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.

Counties

County production data is sourced from the RRC PDQ dump, utilizing table og_county_cycle. Rows for a given county year, month, and name are summed together for primary production values displayed on the wiki to provide a more compact presentation of data. Infoboxes for each county are sourced from wikipedia's county pages.

Operators

Operator Details is sourced from the og_operator_dw table from the PDQ dump. P5 Status, SB369 status, and Financial Assurance were provided in coded forms in the table, which were decoded using information from Source Location here.

Production data for a given operator originates from table og_operator_cycle, which is displayed on each where information applies to a given operator.