FracTracker map of the density of wells by U.S. state as of 2015

1.7 Million Wells in the U.S. – A 2015 Update


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.

Top 10 of 371 published well types for wells in the United States.

Top 10 of 371 published well types for wells in the United States.

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

Active oil and gas wells in 2015 by state. Except for Texas, all data were aggregated published well coordinates.

Active oil and gas wells in 2015 by state. Except for Texas, all data were aggregated published well coordinates.

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.

Top 10 wells by operator in the US, excluding Texas. Unknown operators are highlighted in red.

Top 10 wells by operator in the US, excluding Texas. Unknown operators are highlighted in red.

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.

North American Pipeline Proposal Map

By Ted Auch, PhD – OH Program Coordinator, FracTracker Alliance

With all the focus on the existing TransCanada Keystone XL pipeline – as well as the primary expansion proposal recently rejected by Lancaster County, NB Judge Stephanie Stacy and more recently the Canadian National Energy Board’s approval of Enbridge’s Line 9 pipeline – we thought it would be good to generate a map that displays related proposals in the US and Canada.

North American Proposed Pipelines and Current Pipelines

To view the fullscreen version of this map along with a legend and more details, click on the arrows in the upper right hand corner of the map.

The map was last updated in October 2014.

Pipeline Incidents

The frequency and intensity of proposals and/or expansions of existing pipelines has increased in recent years to accompany the expansion of the shale gas boom in the Great Plains, Midwest, and the Athabasca Tar Sands in Alberta. This expansion of existing pipeline infrastructure and increased transport volume pressures has resulted in significant leakages in places like Marshall, MI along the Kalamazoo River and Mayflower, AR. Additionally, the demand for pipelines is rapidly outstripping supply – as can be seen from recent political pressure and headline-grabbing rail explosions in Lac-Mégantic, QC, Casselton, ND, Demopolis, AL, and Philadelphia.1 According to rail transport consultant Anthony Hatch, “Quebec shocked the industry…the consequences of any accident are rising.” This sentiment is ubiquitous in the US and north of the border, especially in Quebec where the sites, sounds, and casualties of Lac-Mégantic will not soon be forgotten.

Improving Safety Through Transparency

It is imperative that we begin to make pipeline data available to all manner of parties ex ante for planning purposes. The only source of pipeline data historically has been the EIA’s Pipeline Network. However, the last significant update to this data was 7/28/2011 – meaning much of the recent activity has been undocumented and/or mapped in any meaningful way. The EIA (and others) claims national security is a primary reason for the lack of data updates, but it could be argued that citizens’ right-to-know with respect to pending proposals outweighs such concerns – at least at the county or community level. There is no doubt that pipelines are magnets for attention, stretching from the nefarious to the curious. Our interest lies in filling a crucial and much requested data gap.


Pipelines in the map above range from the larger Keystone and Bluegrass across PA, OH, and KY to smaller ones like the Rex Energy Seneca Extension in Southeast Ohio or the Addison Natural Gas Project in Vermont. In total the pipeline proposals presented herein are equivalent to 46% of EIA’s 34,133 pipeline segment inventory (Table 1).

Table 1. Pipeline segments (#), min/max length, total length, and mean length (miles).













MW East-West






Midwest to OK/TX






Great Lakes












Liquids Ventures






Alliance et al






Rocky Express






Overland Pass






TX Eastern






Keystone Laterals






Gulf Stream






Arbuckle ECHO












West TX Gateway






SXL in PA and NY






New England






Spectra BC






Alliance et al
























This is equivalent to 46% of the current hydrocarbon pipeline inventory in the US across the EIA’s inventory of 34,133 pipeline segments with a total length of 195,990 miles

The map depicts all of the following (Note: Updated quarterly or when notified of proposals by concerned citizens):

  1. All known North American pipeline proposals
  2. Those pipelines that have yet to be documented by the EIA’s Natural Gas Pipeline Network mapping team
  3. EIA documented pipelines more accurately mapped to the county level (i.e., select northeastern pipelines)
  4. The current Keystone XL pipeline and the Keystone XL expansion proposal rectified to the county level in Nebraska, South Dakota, Oklahoma, and Texas

We generated this map by importing JPEGs into ArcMAP 10.2, we then “Fit To Display”. Once this was accomplished we anchored the image (i.e., georeferenced) in place using a minimum of 10 control points (Note: All Root Mean Square (RMS) error reports are available upon request) and as many as 30-40. When JPEGs were overly distorted we then converted or sought out Portable Network Graphic (PNG) imagery to facilitate more accurate anchoring of imagery.

We will be updating this map periodically, and it should be noted that all layers are a priori aggregations of regional pipelines across the 4 categories above.

Imagery sources:

  1. Northeast – Long Island Sound, Montreal to Portland, Westchester, Spectra Energy Northeast, Maritime Northeast-Algonquin-Texas Eastern, Delaware River Watershed, Northeastern accuracy of existing EIA data, New England Kinder Morgan, Spectra Energy-Tennessee Gas Pipeline Company (TGP)-Portland Natural Gas Transmission System (PNGTS)
  2. Duluth to The Dakotas, NYMarc Pipeline, Mariner East, Millenium Pipeline Company, WBI Energy’s Bakken,
  3. British Columbia – Enbridge, Spectra/BG, Coastal, Tanker Route
  4. Midwest – ATEX and Bluegrass, BlueGrass, BlueGrass Pipeline,
  5. TransCanada/New England – Portland, Financial Post,
  6. Alaska Pipelines Historically
  7. Rail projects and primary transport
  8. Keystone Tar Sands – Canada (website no longer active), United States, Texas-Oklahoma
  9. Gulf Coast – Florida
  10. MarkWest Houston, Liberty, Liberty, Houston and Majorsville,
  11. Texas Oklahoma – Granite Wash Extension,
  12. Ohio – Spectra Energy, Enterprise Products, Kinder Morgan, Buckeye-Kinder Morgan-El Paso, Chesapeake Energy and AEP
  13. The Rockies Express Pipeline (REX)


1. Krauss, C, & Mouawad, J. (2014, January 25). Accidents Surge as Oil Industry Takes the Train, The New York Times.


Over 1.1 Million Active Oil and Gas Wells in the US

Many people ask us how many wells have been hydraulically fractured in the United States.  It is an excellent question, but not one that is easily answered; most states don’t release data on well stimulation activities.  Also, since the data are released by state regulatory agencies, it is necessary to obtain data from each state that has oil and gas data to even begin the conversation.  We’ve finally had a chance to complete that task, and have been able to aggregate the following totals:

Oil and gas summary data of drilled wells in the United States.

Oil and gas summary data of drilled wells in the United States.


While data on hydraulically fractured wells is rarely made available, the slant of the wells are often made accessible.  The well types are as follows:

  • Directional:  Directional wells are those where the top and the bottom of the holes do not line up vertically.  In some cases, the deviation is fairly slight.  These are also known as deviated or slant wells.
  • Horizontal:  Horizontal wells are directional wells, where the well bore makes something of an “L” shape.  States may have their own definition for horizontal wells.  In Alaska, these wells are defined as those deviating at least 80° from vertical.  Currently, operators are able to drill horizontally for several miles.
  • Directional or Horizontal:  These wells are known to be directional, but whether they are classified as horizontal or not could not be determined from the available data.  In many cases, the directionality was determined by the presence of directional sidetrack codes in the well’s API number.
  • Vertical:  Wells in which the top hole and bottom hole locations are in alignment.  States may have differing tolerances for what constitutes a vertical well, as opposed to directional.
  • Hydraulically Fractured:  As each state releases data differently, it wasn’t always possible to get consistent data.  These wells are known to be hydraulically fractured, but the slant of the well is unknown.
  • Not Fractured:  These wells have not been hydraulically fractured, and the slant of the well is unknown.
  • Unknown:  Nothing is known about the slant, stimulation, or target formation of the well in question.
  • Unknown (Shale Formation):  Nothing is known about the slant or stimulation of the wells in question; however, it is known that the target formation is a major shale play.  Therefore, it is probable that the well has been hydraulically fractured, with a strong possibility of being drilled horizontally.

Wells that have been hydraulically fractured might appear in any of the eight categories, with the obvious exception of “Not Fractured.”  Categories that are very likely to be fractured include, “Horizontal”, “Hydraulically Fractured”, and “Unknown (Shale Formation),” the total of which is about 32,000 wells.  However, that number doesn’t include any wells from Texas or Colorado, where we know thousands wells have been drilled into major shale formations, but the data had to be placed into categories that were more vague.

Oil and gas wells in the United States, as of February 2014. Location data were not available for Maryland (n=104), North Carolina (n=2), and Texas (n=303,909).  To access the legend and other map tools, click the expanding arrows icon in the top-right corner.

The standard that we attempted to reach for all of the well totals was for wells that have been drilled but have not yet been plugged, which is a broad spectrum of the well’s life-cycle.  In some cases, decisions had to be made in terms of which wells to include, due to imperfect metadata.

No location data were available for Maryland, North Carolina, or Texas.  The first two have very few wells, and officials in Maryland said that they expect to have the data available within about a month.  Texas location data is available for purchase, however such data cannot be redistributed, so it was not included on the map.

It should not be assumed that all of the wells that are shown in  the map above the shale plays and shale basin layers are actually drilled into shale.  In many cases, however, shale is considered a source rock, where hydrocarbons are developed, before the oil and gas products migrate upward into shallower, more conventional formations.

The raw data oil and gas data is available for download on our site in shapefile format.