Cleansing data is a necessity in order to properly do your analysis. Luckily, we have done the hard work for you.
Several fields in WellDatabase have a "reported" and "aliased" option. The simple explanation is that reported values appear exactly as the state regulatory agency has reported it and the aliased values are our cleansed & normalized values.
The reported values can have typos, inconsistencies, and more. They also contain valuable insights into the exact data as reported, especially when an operator uses multiple companies for it's operations in different areas. In addition to those types of insights, WellDatabase is dedicated to maintaining integrity in our dataset. We always want you to be able to trace our data back to the source. Also, by providing analytics by both reported and aliased, we provide transparency on how we do our aliasing.
The aliased value is the value we have cleaned and normalized. This value is consistent across our entire database and helps you identify properties when various states handle them differently. This is a necessity for doing large scale analytics.
It is important to note that in regard to operators, the aliased value is not a roll-up of subsidiaries. This means that when a company is acquired by another, we do not change the operator to the new company name. That is unless the company files a change of operator form to update the company to the new name. To give you greater visibility into ownership structures and changes over time, we’ve introduced the Parent Company field as an additional resource to show M&A activity.
To determine the aliased values for data points like well status, well type, and primary formation, our team follows a defined methodology designed to ensure consistency and accuracy. Explore the links below to further understand how each of these values is aliased within our system.
Here is a list of fields that we provide both a reported and aliased value:
- Field
- Primary Formation
- Current Operator
- Original Operator
- Well Bore Profile
- Well Status
- Well Type
Explore other articles by searching the topics on the left or if you have any questions feel free to email support@welldatabase.com