Updated National Well Data
By Matt Kelso, Manager of Data & Technology
In February 2014, the FracTracker Alliance produced our first version of a national well data file and map, showing over 1.1 million active oil and gas wells in the United States. We have now updated that data, with the total of wells up to 1,666,715 active wells accounted for.
Density by state of active oil and gas wells in the United States. Click here to access the legend, details, and full map controls. Zoom in to see summaries by county, and zoom in further to see individual well data. Texas contains state and county totals only, and North Carolina is not included in this map.
While 1.7 million wells is a substantial increase over last year’s total of 1.1 million, it is mostly attributable to differences in how we counted wells this time around, and should not be interpreted as a huge increase in activity over the past 15 months or so. Last year, we attempted to capture those wells that seemed to be producing oil and gas, or about ready to produce. This year, we took a more inclusive definition. Primarily, the additional half-million wells can be accounted for by including wells listed as dry holes, and the inclusion of more types of injection wells. Basically anything with an API number that was not described as permanently plugged was included this time around.
Data for North Carolina are not included, because they did not respond to three email inquiries about their oil and gas data. However, in last year’s national map aggregation, we were told that there were only two active wells in the state. Similarly, we do not have individual well data for Texas, and we use a published list of well counts by county in its place. Last year, we assumed that because there was a charge for the dataset, we would be unable to republish well data. In discussions with the Railroad Commission, we have learned that the data can in fact be republished. However, technical difficulties with their datasets persist, and data that we have purchased lacked location values, despite metadata suggesting that it would be included. So in short, we still don’t have Texas well data, even though it is technically available.
Wells by Type and Status
Each state is responsible for what their oil and gas data looks like, so a simple analysis of something as ostensibly straightforward as what type of well has been drilled can be surprisingly complicated when looking across state lines. Additionally, some states combine the well type and well status into a single data field, making comparisons even more opaque.
Among all of the oil producing states, there are 371 different published well types. This data is “raw,” meaning that no effort has been made to combine similar entries, so “gas, oil” is counted separately from “GAS OIL,” and “Bad Data” has not been combined with “N/A,” either. Conforming data from different sources is an exercise that gets out of hand rather quickly, and utility over using the original published data is questionable, as well. We share this information, primarily to demonstrate the messy state of the data. Many states combine their well type and well status data into a single column, while others keep them separate. Unfortunately, the most frequent well type was blank, either because states did not publish well types, or they did not publish them for all of their wells.
There are no national standards for publishing oil and gas data – a serious barrier to data transparency and the most important takeaway from this exercise…
Wells by Location
There are oil and gas wells in 35 of the 50 states (70%) in the United States, and 1,673 out of 3,144 (53%) of all county and county equivalent areas. The number of wells per state ranges from 57 in Maryland to 291,996 in Texas. There are 135 counties with a single well, while the highest count is in Kern County, California, host to 77,497 active wells.
With the exception of Texas, where the data are based on published lists of well county by county, the state and county well counts were determined by the location of the well coordinates. Because of this, any errors in the original well’s location data could lead to mistakes in the state and county summary files. Any wells that are offshore are not included, either. Altogether, there are about 6,000 wells (0.4%) are missing from the state and county files.
Wells by Operator
There are a staggering number of oil and gas operators in the United States. In a recent project with the National Resources Defense Council, we looked at violations across the few states that publish such data, and only for the 68 operators that were identified previously as having the largest lease acreage nationwide. Even for this task, we had to follow a spreadsheet of which companies were subsidiaries of others, and sometimes the inclusion of an entity like “Williams” on the list came down to a judgement call as to whether we had the correct company or not.
No such effort was undertaken for this analysis. So in Pennsylvania, wells drilled by the operator Exco Resources PA, Inc. are not included with those drilled by Exco Resources PA, Llc., even though they are presumably the same entity. It just isn’t feasible to systematically go through thousands of operators to determine which operators are owned by whom, so we left the data as is. Results, therefore, should be taken with a brine truck’s worth of salt.
Texas does publish wells by operator, but as with so much of their data, it’s just not worth the effort that it takes to process it. First, they process it into thirteen different files, then publish it in PDF format, requiring special software to convert the data to spreadsheet format. Suffice to say, there are thousands of operators of active oil and gas wells in the Lone Star State.
Not counting Texas, there are 39,693 different operators listed in the United States. However, many of those listed are some version of “we don’t know whose well this is.” Sorting the operators by the number of wells that they are listed as having, we see four of the top ten operators are in fact unknown, including the top three positions.
The state of oil and gas data in the United States is clearly in shambles. As long as there are no national standards for data transparency, we can expect this trend to continue. The data that we looked for in this file is what we consider to be bare bones: well name, well type, well status, slant (directional, vertical, or horizontal), operator, and location. In none of these categories can we say that we have a satisfactory sense of what is going on nationally.
Click on the above button to download the three sets of data we used to make the dynamic map (once you are zoomed in to a state level). The full dataset was broken into three parts due to the large file sizes.