Skip to main content
U.S. flag

An official website of the United States government

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Skip to content

Crude Oil Analysis (COA) Database

Metadata Updated: August 23, 2025

The Crude Oil Analysis (COA) database contains the digital data compilation of 9,076 crude oil analyses from samples collected from 1920 through 1983 from the United States and around the world and analyzed by the United States Bureau of Mines (National Institute for Petroleum and Energy Research, 1995). Two laboratories (Bartlesville, Oklahoma, and Laramie, Wyoming) performed routine crude oil analyses by a standardized method, and the data were originally reported in more than 50 reports by the Bureau of Mines.

Analyses include specific gravity, API gravity, pour point, viscosity, sulfur content, nitrogen content, and color of the crude oil, as well as the bulk properties of the distillation cuts.

The data were digitized in the late 1970s and a database retrieval system was implemented in 1980 and made available to the public. The Department of Energy (DOE) updated this system in 1995-96 with public access through a dial-up bulletin board system. The database was operated by the National Institute for Petroleum and Energy Research (NIPER) in Bartlesville, Oklahoma. A stand-alone version of the database (COADB) was available in 1995 in the form of a series of tables in Foxpro (.dbf) format. In 1998, an updated version of COADB was available on the NIPER website that included a Microsoft Access 97 version of the database called "coadb.mdb". The file contains more tables than the original 1995 version but we believe the number of oil samples and the amount of raw data are the same. The additional tables contain text translations for codes used in other tables regarding color, county, laboratory, formation, geologic age, lithology, and state name. Sample location information is generally inadequate to identify the specific well in most cases. The sample location information lacks lease name and in many cases well number and section-township-range. In rare cases, the latitude and longitude are given. A 2002 version was provided by the National Energy Technology Laboratory.

Access & Use Information

Public: This dataset is intended for public access and use. License: Creative Commons Attribution

Downloads & Resources

Dates

Metadata Created Date August 23, 2025
Metadata Updated Date August 23, 2025

Metadata Source

Harvested from OpenEI data.json

Additional Metadata

Resource Type Dataset
Metadata Created Date August 23, 2025
Metadata Updated Date August 23, 2025
Publisher National Renewable Energy Laboratory
Maintainer
Identifier https://data.openei.org/submissions/178
Data First Published 2019-05-29T06:00:00Z
Data Last Modified 2025-08-21T15:12:37Z
Public Access Level public
Bureau Code 019:20
Metadata Context https://openei.org/data.json
Metadata Catalog ID https://openei.org/data.json
Schema Version https://project-open-data.cio.gov/v1.1/schema
Catalog Describedby https://project-open-data.cio.gov/v1.1/schema/catalog.json
Data Quality True
Harvest Object Id 11c7b9b0-2261-45d5-bb5f-321bbb394fa0
Harvest Source Id 7cbf9085-0290-4e9f-bec1-91653baeddfd
Harvest Source Title OpenEI data.json
Homepage URL https://data.openei.org/submissions/178
License https://creativecommons.org/licenses/by/4.0/
Old Spatial {"type":"Polygon","coordinates":-126.50608750000004,22.654784296750755,-65.828675,22.654784296750755,-65.828675,49.720412758647186,-126.50608750000004,49.720412758647186,-126.50608750000004,22.654784296750755}
Program Code 019:000
Source Datajson Identifier True
Source Hash 809ddbe52805d15cac72f78684577af59c84a0ae8c9f6420c04808824f67acf0
Source Schema Version 1.1
Spatial {"type":"Polygon","coordinates":-126.50608750000004,22.654784296750755,-65.828675,22.654784296750755,-65.828675,49.720412758647186,-126.50608750000004,49.720412758647186,-126.50608750000004,22.654784296750755}

Didn't find what you're looking for? Suggest a dataset here.