Offering products and solutions for all aspects of your oil and gas asset management workflow. More
Offering economic and financial analysis, forecasting, and market intelligence for 204 countries... More
Intelligence, consultancy and advertising solutions to the defense, national security and... More
IHS provides technical standards, codes and specifications plus the tools to manage critical data. More
Helping organizations drive innovation to achieve ESM goals with our software… More
Generating accurate price estimates, forecasts and analysis to help purchasing managers... More
Helping your business create a complete and profitable supply chain More
Every year IHS holds events across the world featuring valuable information from recognized experts. More
IHS regularly presents broad-audience, open-access webinars on current industry subjects. More
IHS takes pride in putting customers first and making sure that we keep you informed and updated More
Find the IHS news releases, media experts, corporate profile and more... More
Providing ongoing support and up-to-date reference materials for the Oil & Gas Information News and Analytical Tool products, both internationally and in the US.
on IHS Oil & Gas
The IHS International Exploration and Production (E&P) Database is the most comprehensive and reliable information dataset available to oil and gas industry professionals today. The following pages describe our enhancements to our International information, both recently completed and planned. You can download our International Information Review which contains all our improvements made during 2010. The Information Review also includes details of our International Quality Goals which were introduced in 2009 and are more than a dozen measurable, critical and customer focused goals which were defined in response to your feedback.
The Information Review is supplemented by our Quarterly Newsletter which includes a status report on our Quality Goals and progress of our key projects and statistics for that quarter. Progress within each of the modules is also reported.
Information will be updated frequently to reflect the on-going enhancements to each area.
API State Code
Oil Cums From Date
Gas Cums From Date
Monthly Oil Start
Monthly Gas Start
Test Data Available
Oil Reporting Level
Gas Reporting Level
|Alabama||01||Inception||Inception||1944||1952||Gas Only||No||Lease & Well Comp||Lease & Well Comp|
|Alaska||50||Inception||Inception||1919||1949||NA||Yes||Well Comp||Well Comp|
|Arizona||02||Inception||Inception||1969||1969||NA||No||Well Comp||Well Comp|
|California||04||1977||1977||1977||1977||NA||Yes||Well Comp||Well Comp|
|California (District 6)||04||1936||1936||1936||1936||NA||Yes||Well Comp||Well Comp|
|Colorado *||05||Inception||Inception||1970||1970||IP's Only||Yes||Lease & Well Comp||Lease & Well Comp|
|Federal GOM||60||Inception||Inception||1947||1947||Oil & Gas||Yes||Well Comp||Well Comp|
|Federal PAC||56||Inception||Inception||1968||1968||Oil & Gas||No||Well Comp||Well Comp|
|Kentucky Gas||16||NA||1997||NA||1997||IP's Only||No||NA||Well Comp|
|Louisiana||17||1965||1958||1965||1965||Oil & Gas||No||Lease||Unit/Lease
|Louisiana Allocated||17||1965||1958||1965||1965||Oil & Gas||No||Allocated Well||Allocated Well|
|Michigan||21||Inception||Inception||1960||1960||IP's Only||No||Lease & Well Comp||Lease & Well Comp|
|Michigan Antrim||21||NA||Inception||NA||1968||IP's Only||No||NA||Lease & Well Comp|
|Mississippi||23||Inception||Inception||1977||1977||Gas||No||Well Comp||Well Comp|
|Montana||25||Inception||Inception||1973||1973||IP's Only||No||Lease & Well Comp||Lease & Well Comp|
|Nevada||27||Inception||NA||1955||1955||IP's Only||No||Well Comp||NA|
|New Mexico **||30||Inception||Inception||1970||1970||Gas||Yes||Well Comp||Well Comp|
|New York||31||1985||1985||1985||1985||IP’s Only||No||NA||Well Comp|
|North Dakota||33||Inception||Inception||1951||1954||IP's Only||Yes||Well Comp||Well Comp|
|Ohio||34||1984||1984||1984||1984||IP's Only||No||Well Comp||Well Comp|
|Penn-sylvania||37||Calculated Inception||Calculated Inception||1980||1980||IP's Only||No||Well Comp||Well Comp|
|South Dakota||40||Inception||Inception||1954||1954||IP's Only||Yes||Well Comp||Well Comp|
|Texas||42||Inception||Inception||1958||1962||Oil & Gas||Yes||Lease||Well Comp|
|Texas Oil Allocated||42||Inception||NA||1970||NA||Oil & Gas||Yes||Allocated Well||NA|
|Utah||43||Inception||Inception||1949||1957||IP's Only||No||Well Comp||Well Comp|
|Virginia||45||1992||1992||1992||1992||IP's Only||No||Well Comp||Well Comp|
|West Virginia||47||1985||1985||1985||1985||Oil & Gas||No||Well Comp||Well Comp|
|Wyoming||49||Inception||Inception||1974||1974||IP's Only||Yes||Well Comp||Well Comp|
Documentation and sample data for the IHS standard US data export formats.
Below are the standard data export formats for the the domestic US database. These formats are version controlled to ensure compatibility with leading third-party applications.
This format is an updated version of the legacy PI 98 Production Export format.
This format is an updated version of the legacy Dwights Detailed Production Export format (DMP).
This format is an updated version of the legacy PI 197 Well Export format.
This format is an XML structure for well and production content.
Legacy 197 Well, 98 Production and DMP Production data export formats from the former Petroleum Information (PI) and Dwights Energydata are no longer supported. They are still available in our data products, but will be removed should they break. Likewise, they will not be included in any new applications being developed.
The American Petroleum Institute (API) Subcommittee on Well Data Retrieval Systems was formed in 1962 to develop a standard method for nationwide well identification for use in computerized well data systems. They created the API well number, a unique, permanent, numeric identifier assigned for identification of a well (i.e. hole in the ground) which is drilled for the purpose of finding or producing oil and/or gas or providing related services.
The subcommittee's recommendations were first published in 1966 as Appendix A, API Bulletin D12, Well Data Glossary. In 1968 it became the API Bulletin D12A, The API Well Number and Standard State and County Codes. Several revisions have been made, the latest being published in 1985. In 1995, the subcommittee drafted a new API numbering scheme that allowed for better identification of wells with sidetracks and recompletions. However, the Subcommittee on Well Data Retrieval was disbanded before these recommendations were officially published.
In the draft, the subcommittee proposed adding an Event Sequence Code (digits 13 and 14) which would apply to re-entries, recompletions, and hole deepenings. (These codes may vary between vendors and other industry groups according to well records obtained.) This would make it easy to identify a true hole change for each borehole in a well. The geoscientist could then more easily reconstruct the borehole geometry and sequence events that happened during recompletions, workovers, or sidetracking.
Digits 13 and 14 of the API number have long been part of the IHS's Active well and WHCS well completion database from the former Petroleum Information Corp. However, these digits were incremented differently than what the subcommittee proposed before its disbandonment. Recognizing that this new numbering scheme for digits 13 and 14 would offer greater benefits to our customers, the IHS is adopting this new structure.
In January 1999, this new numbering scheme was implemented in the WHCS well completion and the Active well database. All the API numbers have now been updated and replaced to reflect the new system. Only digits 13 and 14 will be affected. (Note: the Active and WHCS databases are from the former Petroleum Information Corp. Only products derived from these databases will be affected, such as the discontinued Magellan®, petroROM® Active, and petroROM® Well Data. API numbers in the former Dwight's Energydata well database and corresponding products will not be affected.)
In the Production Data database from the former Petroleum Information Corp., API's in regions that contain the full 14-digit API numbers may also have changes. These changes are implemented a state by state basis, as monthly production updates are released. (Note: Once again, these changes only affect products from the former Petroleum Information Corp production database, such as the discontinued Magellan® and petroROM® Production Data. No Dwights production products will be affected.)
If you are maintaining or updating a well database from a product using former PI well data, the following information could be of importance to you:
Well data obtained from products using the Active and WHCS well databases in January 1999 and thereafter will contain the new API numbering structure. Well data obtained from products using data from December 1998 and prior will have the previous API numbering structure. For example, petroROM's Well Data 4th quarter 1998 release will have the old numbering structure. petroROM's Active Well Data's January issue will have the new structure. Any data accessed from on-line systems today (i.e. PetroNet21SM Select: U.S.: Well and Production Data, formerly the Oil & Gas Data Channel) will have the new numbering system implemented for all wells.
In our Active Well database 2,058 wells will have API number changes to digits 13 and 14. In our WHCS well completion database, 34,889 wells will have changes.
Here are the actual statistics for both databases:
WHCS well completion data:
|Region||Number of Wells Changed|
|Appalacian & Illionois Basin||47|
|Gulf Coast/East Texas||6,289|
|North Louisiana/South Arkansas||366|
Active well data:
|Region||Number of Wells Changed|
|Appalacian & Illionois Basin||30|
|Gulf Coast/East Texas||446|
|North Louisiana/South Arkansas||17|
(More detailed statistics are available if needed)
A cross-reference file of the replaced API numbers is available to our customers. You may need to update your database with these API number changes or duplications of wells could result. If you need this file to update your database, please contact Customer Care.
If you are maintaining or updating a production database that utilizes the API number and is from the former PI production data, the following information may be of importance to you:
Some regions in the production database from the former PI will have API changes. Most regions will not be affected, as they did not contain the full 14-digit API number. Here are the statistics for each state:
|Region||Production Month Updated||# of API's Changed|
State by state cross-reference files of the impacted API numbers are available to our customers. If you need these files to update your database, please contact Customer Care.
Below are definitions of frequently requested reference codes used in our US Well and Production data. Some codes are not publicly available (i.e., formation codes), but can be requested by contacting our Customer Care.
Reference Code Abbreviations:
Proprietary to IHS - provided solely for use with IHS data and products.
To change the font size, press Ctrl and (- or +)
To change the font size, Ctrl + (- or +)
If that didn’t work, try the following: