OGJ's energy data warehouse

April 9, 2001
"Data available in Oil & Gas Journal Energy Database."
Click here to enlarge image

"Data available in Oil & Gas Journal Energy Database." Readers of the statistics section of OGJ see this printed below every table that appears on those pages.

It's available, but what does that mean?

It means that online access to our database, which includes the data shown in these tables and much more, is available on the internet via a service called HaverSelect.

Other editors have used this space to discuss other internet sites that are useful to them.

Wealth of data

This one is particularly important to Journal staffers, because it compiles much of our own data and puts it into one handy resource. Information held in this database is also culled from other sources, such as American Petroleum Institute, American Gas Association, Independent Petroleum Association of America, Organization of Petroleum Exporting Countries, Smith International Inc., Baker Hughes Inc., US Energy Information Administration, Minerals Management Service, and others.

All sectors of the energy industry are covered in the OGJ Energy Database via HaverSelect, including drilling and exploration, production, reserves, refining, stocks, imports, exports, and demand, to name just a few. In fact, the database includes more than 150,000 time series.

What's available

What this editor finds most useful about the service are the historical prices that are available. Average prices for crude oil, natural gas, and products can be accessed instantly on the site, with some of the price series dating back a couple of decades.

Use of this database allows me to quickly calculate monthly, quarterly, and annual oil and gas prices that are quoted in reports, such as the lead article for the Capital Spending Outlook. This special report begins on p. 66 in this issue and features a late-breaking adjunct on p. 20.

Among the options available when searching for oil prices are posted prices, spot prices, and futures prices. Choosing spot prices from this menu leads to yet another choice of links selecting any of 39 specific crudes (see table).

Other data series cover such diverse topics as:

  • Rig counts.
  • Nelson-Farrar refinery construction and operating indices.
  • Underground natural gas and LNG storage.
  • Wellhead revenues.
  • Volumes of crude and products transported by pipeline.
  • Geological and geophysical permits issued.

How it works

The OGJ Energy Database service is menu-driven, making it easy to use. Once a set of data is selected, it is put into a shopping cart. When all of the desired data series are selected, they are then ready to be ordered. Completing the order causes the data to immediately download into an Excel workbook. The frequency with which the data are displayed is the same as that stored in the database, unless the user chooses to narrow the years of information required or lower the frequency of the series. When ordering a download, the user can also request that the data appear in another file format rather than in a spreadsheet.

HaverSelect works with version 4.0 and higher of both Netscape and Microsoft Explorer internet browsers.

For more information about the Oil & Gas Journal Energy Database, please call Valerie Sanders at 918-831-9539.