Crude Oil Analysis (COA) database
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.
Citation Formats
TY - DATA
AB - 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.
AU - Lillis, Paul
A2 - DOE, National Energy Technology Laboratory
DB - Open Energy Data Initiative (OEDI)
DP - Open EI | National Renewable Energy Laboratory
DO -
KW - COA
KW - crude
KW - gravity
KW - oil
KW - pour point
KW - sulfur content
LA - English
DA - 2019/05/29
PY - 2019
PB - National Renewable Energy Laboratory
T1 - Crude Oil Analysis (COA) database
UR - https://data.openei.org/submissions/178
ER -
Lillis, Paul, and National Energy Technology Laboratory DOE. Crude Oil Analysis (COA) database. National Renewable Energy Laboratory, 29 May, 2019, Open Energy Data Initiative (OEDI). https://data.openei.org/submissions/178.
Lillis, P., & DOE, N. (2019). Crude Oil Analysis (COA) database. [Data set]. Open Energy Data Initiative (OEDI). National Renewable Energy Laboratory. https://data.openei.org/submissions/178
Lillis, Paul and National Energy Technology Laboratory DOE. Crude Oil Analysis (COA) database. National Renewable Energy Laboratory, May, 29, 2019. Distributed by Open Energy Data Initiative (OEDI). https://data.openei.org/submissions/178
@misc{OEDI_Dataset_178,
title = {Crude Oil Analysis (COA) database},
author = {Lillis, Paul and DOE, National Energy Technology Laboratory},
abstractNote = {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.
},
url = {https://data.openei.org/submissions/178},
year = {2019},
howpublished = {Open Energy Data Initiative (OEDI), National Renewable Energy Laboratory, https://data.openei.org/submissions/178},
note = {Accessed: 2025-05-07}
}
Details
Data from May 29, 2019
Last updated Sep 5, 2023
Submitted May 29, 2019
Organization
National Renewable Energy Laboratory
Contact
Paul Lillis