Federal sales
This dataset contains federal sales data from the Form ONRR-2014 for:
- oil
- gas
- natural gas liquids (NGLs)
This dataset contains reported volumes for royalty and non-royalty bearing transactions by calendar year. Federal sales data represents sales transactions that took place within a given calendar year. This dataset is for calendar years 2013-2023.
Download federal sales data (as of March 6, 2024):
Scope
ONRR collects the data from the Sales and Royalty Remittance Report, Form ONRR-2014. Reporters submit Form ONRR-2014 to provide information on royalties due based on sales or use of the natural resource production.
ONRR collects revenues on over 60 different products, but this dataset only includes data for:
- oil, gas, and NGLs on U.S. federal onshore lands
- oil, gas, and NGLs on U.S. federal offshore areas
It does not include Native American land, privately-owned lands, or U.S. state lands. The dataset includes all ONRR Form-2014 federal reported royalty transaction codes, royalty relief codes, and transaction code (TC) 13 Quality Bank and Gravity Bank Adjustments.
After reporters submit Form ONRR-2014, ONRR aggregates the data by totaling the data values by the sales year. ONRR then publishes this dataset.
Data publication
The federal sales dataset is updated annually.
About the data
What are the steps to develop federal sales data?
Review the step-by-step diagram to learn about how the federal sales data is developed. Use the arrows to expand the steps and learn more about the process.
Reporters submit royalty reporting
Reporters use ONRR’s royalty reporting system, eCommerce, to report royalty revenues on federal oil and gas, using the electronic Report of Sales and Royalty and Remittance Form (ONRR–2014).
Additional details for royalty reporting
Royalty revenues are based on the amount and value of production removed or sold from the lease. Federal royalty rate is lease-specific and generally depends on the location of the oil or gas lease. The location of the lease also determines the applicable statutory requirements.
To determine the royalty due, reporters use the following steps:
A. Calculate federal royalty value with adjustments for royalty relief and/or quality and gravity bank adjustments
Revenues may be modified by various royalty relief programs, as well as quality and gravity bank adjustments. These modifications are made prior to any allowances taking place and are included in the 2014 reporting. This calculation results in the Royalty Value Prior to Allowances (RVPA).
B. Deduct regulatory allowances
Allowances are deductions lessees can claim against royalty value for the transportation and processing costs of production; application of these allowances decreases the royalty payment owed. Federal regulations allow for “reasonable, actual costs” to be deducted. This dataset includes Transportation Allowances and Processing Allowances. This calculation results in the Royalty Value Less Allowances (RVLA).
These steps result in the equation for royalty due:
References:
- ONRR Royalty Reports for Oil and Gas: 30 CFR Part 1210 Subpart B
- 30 CFR Part 1206 (Subpart C for federal oil)
- 30 CFR Part 1206 (Subpart D for federal gas)
- Valuation Regulations
- How Valuation Works
- Form ONRR-2014
- Minerals Revenue Reporter Handbook
- Handbook discussion on quality bank adjustments, section 4.11 (PDF)
- ONRR revenue reporting references
ONRR aggregates sales data
ONRR collects the royalty reporting data from payors across federal lands. ONRR aggregates it to develop this sales dataset, which is publicly available.
References for ONRR data processes
Calculation of Effective Royalty Rate
The Effective Royalty Rate (ERR) accounts for royalty relief, deductions, and other adjustments before the royalty value is divided by the sales value. The ERR is an equation defined by the Office of Inspector General (OIG). ONRR does not use the ERR in any of its processes.
Additional details for Effective Royalty Rate
The Office of Inspector General defined the following equation to calculate ERR:
Effective Royalty Rate =
(Total Royalty Value - Deductions ± Gravity Bank Adjustments)
Total Sales Value
References:
What is the difference between sales year and accounting year data?
The federal sales dataset is sales year data reported on a calendar year basis. Although sales year and accounting year appear similar, there are key differences:
Sales year data includes sales transactions records for a specific year* without adjustments for previous years. This data provides a snapshot of reported sales. It is useful for analyzing sales trends and comparing them to production volumes. The data changes, so ONRR publishes them with an as-of date. The federal sales dataset is sales year data reported on a calendar year basis.
Accounting year data includes sales transaction records accepted by ONRR within a specific year* with adjustments for previous years. The data shows the money ONRR collected and disbursed from the current year and any adjustments or corrections for previous years. It does not provide accurate trend analyses of sales values or volumes over time.
*federal fiscal year or calendar year
What are transaction codes (TC)?
Transaction codes are used transactions on Form ONRR-2014 and organized by function. This dataset does not include all the transaction codes. Other datasets on the site that come from Form ONRR-2014 include all the transaction codes. There are several reasons why some transaction codes are excluded for this dataset. The reasons include not specific to royalty collection, being used to only provide estimates, not relating to oil and gas products, not having royalties reported, or relating to minimum payments.
Federal sales dataset transaction codes
| Transaction Code | Description |
|---|---|
| 01 | Royalty Due |
| 08 | Royalty-in-Kind (Other) |
| 10 | Compensatory Royalty Payment |
| 11 | Transportation Allowance |
| 13 | Quality Bank and Gravity Bank Adjustment |
| 15 | Processing Allowance |
| 39 | Net Profit Share - Unprofitable |
| 40 | Net Profit Share - Profitable |
| 41 | Offshore Deep Water Royalty Relief |
| 44 | DWRRA - EPA Sec 344 - Shallow Water Deep Gas Royalty Relief (SV) |
| 55 | DWRRA - EPA Sec 345 - Deep Water Royalty Relief (SV) |
| RR | Royalty Relief |
What are product codes?
Product codes define the product or commodity on Form ONRR-2014. This dataset does not include all product codes reported on all Form ONRR-2014s. This dataset only includes product codes related to the product and byproducts of oil, gas, and NGLs.
Federal sales dataset product codes
| Product Code | Description | Commodity | Unit of Measure |
|---|---|---|---|
| 01 | Oil | Oil | bbl |
| 02 | Condensate | Oil | bbl |
| 03 | Processed (Residue) Gas | Gas | mcf |
| 04 | Unprocessed Gas | Gas | mcf |
| 05 | Drip or Scrubber Condensate | Oil | bbl |
| 06 | Inlet Scrubber | Oil | bbl |
| 07 | Gas Plant Products | NGL | gal |
| 08 | Gas Hydrate | Gas | mcf |
| 12 | Flash Gas | Gas | mcf |
| 13 | Fuel Oil | Oil | bbl |
| 14 | Oil Lost | Oil | bbl |
| 15 | Pipeline Fuel/Loss | Gas | mcf |
| 16 | Gas Lost - Flared or Vented | Gas | mcf |
| 20 | Other Liquid Hydrocarbons | Oil | bbl |
| 39 | Coal Bed Methane | Gas | mcf |
| 61 | Sweet Crude | Oil | bbl |
| 62 | Sour Crude | Oil | bbl |
| 63 | Asphaltic Crude | Oil | bbl |
| 64 | Black Wax Crude | Oil | bbl |
| 65 | Yellow Wax Crude | Oil | bbl |
| 66 | Flared Oil Well Gas | Gas | mcf |
| 67 | Flared Gas Well Gas | Gas | mcf |
| 68 | Vented Oil Well Gas | Gas | mcf |
| 69 | Vented Gas Well Gas | Gas | mcf |
| 70 | Gas Lost Prior to Royalty Measurement Point | Gas | mcf |
How are quality and gravity bank adjustments calculated?
Quality and gravity bank adjustments are made prior to any allowances taking place and are included in the reporting. These adjustments (TC 13) are used to report the difference in quality (gravity) between oil measured at the BLM or BSEE-approved point of royalty settlement and the oil delivered to the refiner at the delivery point. The dataset rolls up the TC 13 adjustments with the TC 01 (Royalty) reporting for oil. (See 30 CFR 1206.119 .)
What does “not tied to a commodity” mean?
As a part of the COVID royalty relief program reporters were not required to tie their reporting to a specific product code. Due to this ONRR is unable to allocate the reported information to the various products. In this dataset, “not tied to a commodity” references transactions that are identified as COVID royalty relief.
What is COVID royalty relief?
Under 30 CFR 203.80 the Bureau of Safety and Environmental Enforcement (BSEE) can grant special case royalty relief on a product or lease basis. This royalty relief is granted through an application-based process that adheres to strict criteria. In 2020 and 2021, BSEE granted limited royalty relief known as COVID royalty relief. COVID royalty relief is separated in this dataset because payors were not required to report a product.
Data dictionary
Fields and definitions
Calendar Year: The period between January 1 and December 31 for a given year. This dataset is sales year data reported on a calendar year basis.
Land Class: This field distinguishes federal lands and waters from Native American lands. All data in this dataset is federal.
- Federal: Federal lands (PDF) are owned by or under the jurisdiction of the federal government. Federal lands include: public domain lands, acquired lands, military acquired lands, and the Outer Continental Shelf .
Land Category:
- Onshore: Situated or occurring on land.
- Offshore: Submerged lands located farther than three miles off a state’s coastline, or three marine leagues into the Gulf of Mexico off Texas and western Florida.
State/Offshore Region: The Bureau of Ocean Energy Management (BOEM) separates offshore areas into four regions: Gulf of Mexico, Atlantic, Pacific, and Alaska. For more information on offshore regions, including spatial boundaries, see the Bureau of Ocean Energy Management's maps and GIS data . The state name is also listed under this column.
Revenue Type: Revenues from U.S. natural resources fall into one of several types. This dataset contains only royalties and COVID royalty relief as revenue types.
- Royalties: A natural resource lease holder pays royalties after the lease starts producing a commodity in paying quantities. The amount is based on a percentage of the revenue from the commodity sold. The exact percentage is set in the original lease document that went along with the lease sale.
- Covid Royalty Relief: This amount is always negative. COVID royalty relief is given its own category in the data as payors were not required to report a product.
Commodity: The Department of the Interior collects revenues on over 60 different products, but there are only oil, gas, NGLs, and "not tied to a commodity" in this dataset. “Not tied to a commodity” references COVID royalty relief data.
Sales Volume: A reported field on the Form ONRR-2014. Sales Volume is the quantity and quality of production as measured at the approved royalty measurement point. It is then sold. The Bureau of Land Management (BLM) or Bureau of Safety and Environmental Enforcement (BSEE) approve measuring points.
Gas MMBtu Volume: Volume measured in Million British Thermal Units (MMBtu). One British Thermal Unit (Btu) is the amount of heat required to raise the temperature of one pound of water by one degree Fahrenheit. MMBtu is the globally used energy value measurement.
Unit Value: The per-unit price that you apply to the royalty-bearing volume.
Sales Value: A reported field on the Form ONRR-2014. Reporters calculate sales value by multiplying the volumes sold by the agreed upon unit price. This calculation is done for each product based on pricing contracts and approved valuation guidelines.
Royalty Value Prior to Allowances (RVPA): Calculated by multiplying sales value by royalty rate.
Transportation Allowances (TA): Deductions in determining royalty value for the reasonable, actual costs incurred by the lessee, or a deduction accepted or established by ONRR for moving coal from the mine or lease to a remote point of sale or delivery, or moving oil or gas, gas, or geothermal byproducts to a point of sale or delivery off of the lease, unit area, or communitized area.
Processing Allowances (PA): Deductions from royalty value for the lessee's actual, reasonable costs of processing a gas stream.
Royalty Value Less Allowances (RVLA): Calculated by subtracting allowances (transportation, processing) from royalty value.
Effective Royalty Rate: The Office of Inspector General (OIG) created the term and concept of effective royalty rate. The OIG defines the calculation of the effective royalty rate in Report 2021-CR-042 June 2023 .
Contact us
Do you have questions about the data or need data that isn't here? Contact our data specialists at onrrdatarequests@onrr.gov