About this Dataset

Calendar Year Federal Sales Of U.S. Natural Resources

This dataset provides federal sales data for oil, gas, and natural gas liquids that report 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. This dataset only includes data for: oil, gas, and NGLs on U.S. federal onshore lands; and 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. The dataset is tracked and managed by the Department of the Interior’s Office of Natural Resources Revenue. It contains federal sales data for calendar years 2013-2023.
Organization: Department of the Interior
Last updated: 2025-09-14T17:40:47.842176
Tags: economy, environment, federal-lands, geoscientificinformation, location, offshore-waters, outer-continental-shelf

Tables

Calendar Year Federal Sales Of U.S. Natural Resources Revenue

@usgov.doi_gov_calendar_year_federal_sales_of_u_s_natural_resources.calendar_year_federal_sales_of_u_s_natural_resources_revenue

51.95 kB
872 rows
14 columns

CREATE TABLE calendar_year_federal_sales_of_u_s_natural_resources_revenue (
  "calendar_year" BIGINT,
  "land_class" VARCHAR,
  "land_category" VARCHAR,
  "state_offshore_region" VARCHAR,
  "revenue_type" VARCHAR,
  "commodity" VARCHAR,
  "sales_volume" DOUBLE,
  "gas_mmbtu_volume" DOUBLE,
  "sales_value" DOUBLE,
  "royalty_value_prior_to_allowances_rvpa" DOUBLE  -- Royalty Value Prior To Allowances (RVPA),
  "transportation_allowances_ta" DOUBLE  -- Transportation Allowances (TA),
  "processing_allowances_pa" DOUBLE  -- Processing Allowances (PA),
  "royalty_value_less_allowances_rvla" DOUBLE  -- Royalty Value Less Allowances (RVLA),
  "effective_royalty_rate" DOUBLE
);