Air Emissions
How to Download Your Data
- Go to https://www.epa.gov/enviro/tri-ez-search.
- Scroll down and click on “Flat (Denormalized) Form R – A flat view of the TRI database that contains
a majority of the available TRI information.
- Select the following variables from the list of data elements provided.
- Reporting Year
- In the row immediately below Air Total Release check the box above SUM
- Primary NAICS Code
- Scroll to the bottom of the page and click on “STEP 3: Enter Search Criteria”
- On the next page:
- For Reporting Year – switch Operator to “Between.” In the pop-up box that results, enter
“1996” into the top form field, and “2018” into the bottom form field. Then click Click
“Enter BETWEEN Range in Search Field.” In the Sort Column field, enter “1.” (You can leave
the other columns blank or unchanged.)
- For Primary NAICS Code – switch Operator to “Beginning with,” and enter 2211 (Electric Power
Generation, Transmission and Distribution) under Search Value. Then check the last box to
the right under “Where Only.”
- Click on “Search database” or “Output to CSV File”
X
Criteria Air Pollutants
How to Download Your Data
Note: Processing National Emissions Inventory data will require use of data processing software. 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.
- For 1996, 1999, 2002, and 2005, use the following links:
- For 2008, 2011, 2014, and 2017, use the following links:
At each link, click the “Data Summaries” tab, then download the file “Facility-level by Pollutant.”
- Utilities facilities are grouped under SIC codes 4911, 4931, and 4949 for the years 1996 and 1999
and NAICS codes
beginning with 2211 for the years 2002 – 2017.
- Using the SIC and NAICS variables, filter for utilities 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.
X
Greenhouse Gases
How to Download Your Data
- Go to https://www.epa.gov/sites/production/files/2020-04/us-ghg-inventory-chapter-text.zip.
This link will open a ZIP
file containing a full time series of all tables in the U.S. GHG Inventory report.
- Open folder for Chapter 2 - Trends
- In table 2-11 (Electric Power-Related Greenhouse Gas Emissions), the 1996 – 2018 values in the
“total” row corresponds to the values shown in this chart.
X
Hazardous Waste Generation
How to Download Your Data
- Go to https://rcrainfo.epa.gov/rcrainfoweb/action/modules/br/naics/view
- 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:
- NAICS code: 2211
- Reporting cycles: 2001, 2003, 2005, 2007, 2009, 2011, 2013, 2015, 2017
- You do not need to change the “Generators to Include” dropdown or the “Location” dropdown
before hitting submit.
X
Production-Related Waste Managed
How to Download Your Data
- Go to https://www.epa.gov/enviro/tri-ez-search.
- Scroll down and click on “Flat (Denormalized) Form R – A flat view of the TRI database that contains
a majority of the available TRI information.
- Select the following variables from the list of data elements provided.
- Reporting Year
- In the row immediately below Total Production Related Waste check the box above SUM
- Primary NAICS Code
- Scroll to the bottom of the page and click on “STEP 3: Enter Search Criteria”
- On the next page:
- For Reporting Year – switch Operator to “Between.” In the pop-up box that results, enter
“1998” into the top form field, and “2018” into the bottom form field. Then click Click
“Enter BETWEEN Range in Search Field.” In the Sort Column field, enter “1.” (You can leave
the other columns blank or unchanged.)
- For Primary NAICS Code – switch Operator to “Beginning with,” and enter 2211 (Electric Power
Generation, Transmission and Distribution) under Search Value. Then check the last box to
the right under “Where Only.”
- Click on “Search database” or “Output to CSV File”
X
Releases to Land
How to Download Your Data
- Go to https://www.epa.gov/enviro/tri-ez-search.
- Scroll down and click on “Flat (Denormalized) Form R – A flat view of the TRI database that contains
a majority of the available TRI information.
- Select the following variables from the list of data elements provided.
- Reporting Year
- In the row immediately below Land Total Release check the box above SUM
- Primary NAICS Code
- Scroll to the bottom of the page and click on “STEP 3: Enter Search Criteria”
- On the next page:
- For Reporting Year – switch Operator to “Between.” In the pop-up box that results, enter
“1998” into the top form field, and “2018” into the bottom form field. Then click Click
“Enter BETWEEN Range in Search Field.” In the Sort Column field, enter “1.” (You can leave
the other columns blank or unchanged.)
- For Primary NAICS Code – switch Operator to “Beginning with,” and enter 2211 (Electric Power
Generation, Transmission and Distribution) under Search Value. Then check the last box to
the right under “Where Only.”
- Click on “Search database” or “Output to CSV File”
X
Water Discharges
How to Download Your Data
- Go to https://www.epa.gov/enviro/tri-ez-search.
- Scroll down and click on “Flat (Denormalized) Form R – A flat view of the TRI database that contains
a majority of the available TRI information.
- Select the following variables from the list of data elements provided.
- Reporting Year
- In the row immediately below Water Total Release check the box above SUM
- Primary NAICS Code
- Scroll to the bottom of the page and click on “STEP 3: Enter Search Criteria”
- On the next page:
- For Reporting Year – switch Operator to “Between.” In the pop-up box that results, enter
“1998” into the top form field, and “2018” into the bottom form field. Then click Click
“Enter BETWEEN Range in Search Field.” In the Sort Column field, enter “1.” (You can leave
the other columns blank or unchanged.)
- For Primary NAICS Code – switch Operator to “Beginning with,” and enter 2211 (Electric Power
Generation, Transmission and Distribution) under Search Value. Then check the last box to
the right under “Where Only.”
- Click on “Search database” or “Output to CSV File”
X
Dollar Value of Gross Output
How to Download Your Data
- Go to https://www.bea.gov/industry/gdpbyind_data.htm
- Select “Access Underlying Detail tables.”
- Select “Gross Output by Industry.”
- Select “U.Gross Output by Industry (A).”
- Select “Underlying Summary Level’ and click “Next Step.” The resulting data table will then load.
- Select “Modify” in the upper-right-hand corner of the table. In the resulting window:
- Set the scale as “Billions”
- Set the start year as “1997”
- Set the start year as “Most Recent”
- In the code list, select “(2211) Electric power generation, transmission and distribution.”
Do not select any other item in this menu, doing so may double count.
- Click “Refresh Table”
- Row 1 of the resulting table, labeled “Electric power generation, transmission, and distribution”
provides the corresponding data shown in this chart for each year.
- (Optional) Download the dataset in XLS, CSV, or PDF format.
X
Employment
How to Download Your Data
Note: Processing employment data from the Census Bureau will require use of data processing software.
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.
- Go to https://www.census.gov/programs-surveys/cbp/data/datasets.html
- 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
from 1998 to 2018.
- Open each file in a software package of your choice that can process comma-delimited text files.
Repeat the steps below for each file.
- 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 |
- In your software package, filter the data for NAICS codes that begin with 2211.
- With the filter in place, aggregate the “emp” column across all records.
X
Electricity Generation
How to Download Your Data
- For years 2010 through 2019:
- Go to https://www.eia.gov/electricity/monthly/epm_table_grapher.php?t=epmt_1_1
- Use the dropdowns on the top right of the page to download the “May 2020” issue in zip
folder format.
- In the zip folder, open “Table_1_01.” Cells M6 through M15 display the annual energy
production totals in this chart for years 2010 through 2019.
- For years 2008 and 2009:
- Go to https://www.eia.gov/electricity/monthly/epm_table_grapher.php?t=epmt_1_1
- Use the dropdowns on the top right of the page to download the “October 2018” issue in zip
folder format.
- In the zip folder, open “Table_1_01.” Cells M6 and M7 display the annual energy production
totals in this chart for
years 2008 and 2009.
- For years 1996 through 2007:
- Go to https://www.eia.gov/electricity/monthly/epm_table_grapher.php?t=epmt_1_1
- Use the dropdowns on the top right of the page to download the “January 2011” issue in zip
folder format.
- In the zip folder, open “epmxlfile1_1.” Cells L4 through L15 display the annual energy
production totals in this chart for years 1996 through 2007.
X