PA DEP Upgrades Drilled Well Data Distribution

The Pennsylvania DEP now has a linkto download all of the drilled wells from the Spud Report in Excel file format (1). This is a major upgrade over their previous system of posting online tables for each month, not only for the ease of access, but also because it contains complete location information, which previously had to be obtained elsewhere by matching the American Petroleum Institute (API) number with an external dataset; an imperfect system which resulted in thousands of wells between 1998 and 2010 for which location information could not be found.



Drilled wells in Pennsylvania in 2011. Click the gray compass rose and double carat (^) tabs for a complete view.

In addition, it utilizes the full API number. For example, in well number 37-005-30663-01-01, the initial 37 is the state code for Pennsylvania, and the 005 is the county code for Armstrong County.

  1. The Spud Date is the day that drilling begins on a particular well.
  2. API county codes, as well as a variety of other codes used by the PA DEP are explained here.