Criteria Air Pollutants

How to Download Your Data

Note: The data are available in a tab or comma-delimited text format that must be imported into a program that will allow you to analyze the file (such as Excel).

1. Go to: Get Air Emissions Data | US EPA which has a table with yearly data tables. Download the data years desired.
2. In the “Table of Air Emissions Data by Year and Time”, select the relevant NEI file under the Triennial NEI column for years within the range of the Snapshot Sectors Graphic.
3. For 1996 – 2005, select the file with “naics” or “sics” in the file name. For example, for 2000, use the “2000sicsummarymade09” file, but for 2005, use the “naics_summary.zip” file.
4. For 2008 and onwards, click the “Data Summaries” hyperlink, then download the “Facility-level by Pollutant” file.
5. Oil and Gas Production facilities are grouped under SIC codes 1311 and 1321 for the years 1996 and 1999 and NAICS codes beginning with 211 for the years 2002 – 2017.
6. Using the SIC and NAICS variables, filter for oil and gas production facilities, then sum total emissions of CO, NOX, VOC, PM10, NH3, and SO2 in each year to arrive at the totals shown in this chart.

Greenhouse Gases

How to Download Your Data

1. Go to Greenhouse Gas (GHG) Emissions and Removals | US EPA.
2. Under “National” select the “EPA's Inventory of U.S. Greenhouse Gas Emissions and Sinks”, then select “Annual Report”
3. In the table presented, navigate to the “Related Data Files” column.
4. Open folder for Chapter 3 - Energy
5. For each year, 1996 onwards, sum the following:
   1. In table 3-37 (CH4 from Petroleum Systems), sum of “Exploration” and “Production (Total)” rows, million metric tons CO2e (MMT CO2e)
   2. In table 3-39 (CO2 from Petroleum Systems), sum of “Exploration” and “Production” rows, million metric tons CO2e (MMT CO2e)
   3. In table 3-41 (N2O from Petroleum Systems), sum of “Exploration” and “Production” rows, and then divide by 1,000,000 (units are in metric tons CO2e)
   4. In table 3-57 (CH4 from Natural Gas Systems), sum of “Exploration” and “Production” rows, million metric tons CO2e (MMT CO2e)
   5. In table 3-59 (CO2 from Natural Gas Systems), sum of “Exploration” and “Production” rows, million metric tons CO2e (MMT CO2e)
   6. In table 3-61 (N2O from Natural Gas Systems), sum of “Exploration” and “Production” rows, and then divide by 1,000,000 (units are in metric tons CO2e)

Hazardous Waste Generation

How to Download Your Data

1. Go to https://rcrainfo.epa.gov/rcrainfoweb/action/modules/br/naics/view
2. For each reporting cycle, sum the output across all NAICS codes to calculate the total shown in this chart for the year corresponding to that reporting cycle by using the following criteria:
   1. NAICS code: 2211
   2. Reporting cycles: Select each year individually that is presented on the Sector Snapshots graphic
   3. You do not need to change the “Generators to Include” dropdown or the “Location” dropdown before hitting submit.

Dollar Value of Gross Output

How to Download Your Data

1. Go to GDP by Industry | U.S. Bureau of Economic Analysis (BEA)
2. Click on Underlying Detail Tables, Annual, 1997-2022
3. Select “Gross Output by Industry.”
4. Select “U.Gross Output by Industry (A).” Then on the next page, click “Next Step.” The resulting data table will then load.
5. Select “Modify” in the upper-right-hand corner of the table. In the resulting window:
   1. Set the scale as “Billions”
   2. Set the start year as “1997-A”
   3. Set the end year as the last year presented in the graphic.
   4. In the code list, select only “(211)” Do not select any other item in this menu, doing so may double count.
   5. Click “Refresh Table”
6. Row 1 of the resulting table, labeled “Chemical products” provides the corresponding data shown in this chart for each year.
7. (Optional) Download the dataset in XLS, CSV, or PDF format.

Note: NAICS 324110 (Petroleum Refineries) is not available in this dataset.

Employment

How to Download Your Data

Note: The data are available in a comma-delimited text format that must be imported into a software package that will allow you to analyze the file.

1. Go to https://www.census.gov/programs-surveys/cbp/data/datasets.html
2. Click on any link labeled “County Business Patterns: YEAR.” On the resulting page, click the “Complete U.S. File” link and download the corresponding file. Repeat this process for each year corresponding to years presented in the graphic.
3. Open each file in a software package of your choice that can process comma-delimited text files. Repeat the steps below for each file.
4. For entities with suppressed data, the Census Bureau replaces all employment values with zeroes, and this underestimates the total number of employees in each sector. Using your software package, replace the suppression flags with the midpoint of the Data Suppression Flag employment ranges per the table below.

   Empflag Data Suppression Flag	Employment Size Class		Midpoint
   	Min	Max
   A	0	19	10
   B	20	99	60
   C	100	249	175
   E	250	499	375
   F	500	999	750
   G	1000	2,499	1,750
   H	2,500	4,999	3,750
   I	5000	9,999	7,500
   J	10,000	24,999	17,500
   K	25,000	49,999	37,500
   L	50,000	99,999	75,000
   M	100,000	>100,000	100,000

5. In your software package, filter the data for NAICS codes that begin with 211.
6. With the filter in place, aggregate the “emp” column across all records.

Produced Goods

How to Download Your Data

Note: The Oil & Gas Snapshot uses the same production economic indicator value for the Processing and Production sub-sectors. This value is based on crude oil and gross withdrawals of natural gas, which are inputs to processed petroleum products and processed natural gas.

1. For petroleum quantity produced:
   1. Go to https://www.eia.gov/dnav/pet/pet_crd_crpdn_adc_mbbl_m.htm
   2. Change the displayed “Period-Unit” dropdown to “Annual-Thousand Barrels”
   3. Click “Download Series History.” The resulting spreadsheet file will contain a worksheet, “Data 1” with “U.S. Field Production of Crude Oil (Thousand Barrels)” as Column B.
   4. To convert petroleum (thousand barrels) to Btu, multiply each annual value by 5,800,000,000.
2. For natural gas quantity produced:
   1. Go to https://www.eia.gov/dnav/ng/ng_prod_sum_a_EPG0_FGW_mmcf_m.htm
   2. Confirm that the “Data Series” dropdown displays “Gross Withdrawals.”
   3. Change the displayed “Period-Unit” dropdown to “Annual-Million Cubic Feet”
   4. Click “Download Series History.” The resulting spreadsheet file will contain a worksheet, “Data 1” with “U.S. Natural Gas Gross Withdrawals (MMcf)” as Column B.
   5. To convert natural gas (MMcf) to Btu, multiply each value by 1,037,000,000.
3. Sum the converted petroleum values with the converted natural gas quantity values for each year to calculate the total quantity produced in Btu in each year.