Federal sales
This dataset contains federal sales data from the Form ONRR-2014 for:
- oil
- gas
- natural gas liquids (NGLs)
The data contains reported volumes for royalty and non-royalty bearing transactions by calendar year. This federal sales data represents sales transactions that took place within a given calendar year. The dataset is for calendar years 2013-2022.
Download federal sales data (as of November 6, 2023):
Scope
ONRR collects the data from the Sales and Royalty Remittance Report, Form ONRR-2014, which contains information on royalties due based on sales or use of the natural resource production. This dataset is pulled from Form ONRR-2014. ONRR collects revenues on over 60 different products, but this dataset only includes data for oil, gas, and NGLs. ONRR aggregates the data to develop this federal sales dataset, which is publicly available.
The dataset includes federal sales data for U.S. federal onshore lands and offshore areas for oil, gas, and NGLs. 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.
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. Click on 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, quality bank, and/or gravity bank
Revenues may be modified by various royalty relief programs, as well as quality bank 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 (RLVA).
These steps result in the equation for royalty due:
| 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?
Although they appear similar, there are key differences:
Accounting Year data represent all transactions that ONRR accepted into our financial system during a given fiscal or calendar year. This dataset contains transactions for sales that took place in the current federal fiscal or calendar year, as well as adjusted or corrected transactions for sales that took place in previous federal fiscal or calendar years. Because revenues are generally disbursed in the same year they were reported and accepted into ONRR’s financial system, accounting year data are most useful when analyzing dollars ONRR collected and disbursed in a given federal fiscal or calendar year. Because they include adjusted or corrected transactions for previous sales periods, accounting year data should not be used for trending purposes or for analyzing sales volumes.
Sales Year data represent sales transactions that took place in a given federal fiscal or calendar year and do not include adjusted or corrected transactions for sales that took place in previous years. This dataset provides a “snap shot” of reported sales of mineral commodities, and is most useful when trending sales volumes or when making comparisons to production volumes. Because ONRR processes royalty transactions daily, the sales year data constantly changes. For this reason, ONRR publishes sales year datasets with an as-of date showing when the information was current.
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 data set. 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.
Below are the transaction codes included in the dataset.
| 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 |
How are Quality Bank and Gravity Bank Adjustments calculated?
Quality Bank and Gravity Bank Adjustments are made prior to any allowances taking place and 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?
30 CFR 203.80 allows the Bureau of Safety and Environmental Enforcement (BSEE) the ability to grant special case royalty relief on a product or lease basis through an application-based process that adheres to strict criteria. BSEE granted limited royalty relief in 2020 and 2021 that is categorized as COVID royalty relief in our data set. COVID Royalty Relief is given its own category in this dataset as payors were not required to report a product.
Data dictionary
Fields and definitions
Calendar Year: The year in which the data is reported for the period between January 1 and December 31 for a given year. This dataset is sales year data reported on a calendar year basis.
Note: Sales year and accounting year are different from calendar year and fiscal year. Refer to above definitions of sales year and accounting year.
Land Class: This field distinguishes federal lands and waters from Native American lands. All data in this dataset is federal.
- Federal: Federal lands 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 (Federal): Lands that are owned by or under the jurisdiction of the federal government and are situated or occurring on land. Onshore land includes public domain lands, acquired lands and military acquired lands.
- Offshore (Federal): Submerged lands that are located farther than three miles off a state's coastline, or three marine leagues into the Gulf of Mexico off Texas and Western Florida and are owned by or under the jurisdiction of the federal government. Outer Continental Shelf lands are included.
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: The volume of the product sold or removed from the lease or agreement and is attributable to the lease or to the lease-agreement combination, sales type code, product code, and sales month reported. The unit of measurement is located under the commodity column. The sales volume (or quantity, if geothermal) reported corresponds to the portion of the total production from the lease or from the lease-agreement combination. This is an industry reported value on the Form ONRR-2014.
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.
Sales Value: The value of a commodity when sales volume is multiplied by price.
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