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 Definition to “Between.” In the Search Value field, enter the first year shown in the Sector Snapshots chart, followed by “AND”, and the last year shown in the Sector Snapshots chart. For example, if the first year is 1996 and the last year is 2022, enter “1996 AND 2022” in the Search Value 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 “3311” under Search
Value. Then check the last box to the right under “Where Only.”
- Click on “Search database” or “Output to CSV File”
- Repeat steps three through five with NAICS code “3312” and sum the corresponding values
X
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).
- Go to: Get Air Emissions Data | US EPA which has a table with yearly data tables. Download the data years desired.
- 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.
- 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.
- For 2008 and onwards, click the “Data Summaries” hyperlink, then download the “Facility-level by Pollutant” File.
- Iron and Steel manufacturing facilities are grouped under SIC codes 3312, 3313, 3315, 3316, 3317,
and 3399 for the years 1996 and 1999 and NAICS codes beginning with 3311 and 3312 for the years 2002 – 2017.
- Using the SIC and NAICS variables, filter for iron and steel 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
Energy Use
How to Download Your Data
- Go to https://www.eia.gov/outlooks/aeo/archive.php
- This will bring you to the Annual Energy Outlook (AEO) Products – Archive which contains links to historical data sets.
- Under “Supplement Tables,” click on the HTML link for data by year. For each year shown in the Snapshot, users should select the AEO report published the following year for data. For example, for energy use data from 2020, the user should use the 2020 data published in the 2021 Annual Energy Outlook.
- Go to Table 30. Iron and Steel Industries Energy Consumption and click on the XLS option.
- For each year, copy the value for “Total” under “Energy Consumption”
- For other years, it will be necessary to repeat the process above.
X
Greenhouse Gases
How to Download Your Data
- Go to Greenhouse Gas (GHG) Emissions and Removals | US EPA.
- Under “National” select the “EPA's Inventory of U.S. Greenhouse Gas Emissions and Sinks”, then select “Annual Report”
- In the table presented, navigate to the “Related Data Files” column.
- Click on the folder for Chapter 4 – Industrial Processes zip folder.
- For each year, 1996 onwards, sum:
- In table 4-60 (CO2 Emissions from Metallurgical Coke Production), “total” row, million
metric tons CO2e (MMT CO2e)
- In table 4-62 (CO2 Emissions from Iron and Steel Production), “total” row, million metric
tons CO2e (MMT CO2e)
- In table 4-64 (CH4 Emissions from Iron and Steel Production), add 0.05 million metric tons
CO2e (MMT CO2e)
X
Hazardous Waste Generation
How to Download Your Data
- Go to https://rcrapublic.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: 3311 and 3312
- Reporting cycles: Select each year individually that is presented on the Sector Snapshots graphic
- 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 Definition to “Between.” In the Search Value field, enter the first year shown in the Sector Snapshots chart, followed by “AND”, and the last year shown in the Sector Snapshots chart. For example, if the first year is 1996 and the last year is 2022, enter “1996 AND 2022” in the Search Value field.
- For Primary NAICS Code – switch Operator to “Beginning with,” and enter “3311” under Search
Value. Then check the last box to the right under “Where Only.”
- Click on “Search database” or “Output to CSV File”
- Repeat steps three through five with NAICS code “3312” and sum the corresponding values
X
Recycling of Waste Chemicals
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 Recycling Onsite Current Year Quantity 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 Definition to “Between.” In the Search Value field, enter the first year shown in the Sector Snapshots chart, followed by “AND”, and the last year shown in the Sector Snapshots chart. For example, if the first year is 1996 and the last year is 2022, enter “1996 AND 2022” in the Search Value field.
- For Primary NAICS Code – switch Operator to “Beginning with,” and enter “3311” under Search
Value. Then check the last box to the right under “Where Only.”
- Click on “Search database” or “Output to CSV File”
- Repeat steps three through five with NAICS code “3312” and sum the corresponding values
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 Definition to “Between.” In the Search Value field, enter the first year shown in the Sector Snapshots chart, followed by “AND”, and the last year shown in the Sector Snapshots chart. For example, if the first year is 1996 and the last year is 2022, enter “1996 AND 2022” in the Search Value field.
- For Primary NAICS Code – switch Operator to “Beginning with,” and enter “3311” under Search
Value. Then check the last box to the right under “Where Only.”
- Click on “Search database” or “Output to CSV File”
- Repeat steps three through five with NAICS code “3312” and sum the corresponding values
X
Volume of Recycled Goods
How to Download Your Data
- Go to https://minerals.usgs.gov/minerals/pubs/commodity/iron_&_steel_scrap/
- For years 2015 – 2019, select the 2020 “Iron and Steel Scrap” report under “Mineral Commodities
Summaries”
- Sum the values for “Home scrap” and “Purchased scrap” in the first table in the PDF file.
- For 2014, repeat the above steps using the 2017 PDF file.
- Repeat step 4 for year 1996 – 2013, using the PDF file corresponding to five years after the given
year (e.g., 2011 data is from the 2016 report).
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 Definition to “Between.” In the Search Value field, enter the first year shown in the Sector Snapshots chart, followed by “AND”, and the last year shown in the Sector Snapshots chart. For example, if the first year is 1996 and the last year is 2022, enter “1996 AND 2022” in the Search Value field.
- For Primary NAICS Code – switch Operator to “Beginning with,” and enter “3311” under Search
Value. Then check the last box to the right under “Where Only.”
- Click on “Search database” or “Output to CSV File”
- Repeat steps three through five with NAICS code “3312” and sum the corresponding values
X
Dollar Value of Gross Output
How to Download Your Data
- Go to GDP by Industry | U.S. Bureau of Economic Analysis (BEA)
- Click on Underlying Detail Tables, Annual, 1997-2022
- Select “Gross Output by Industry.”
- Select “U.Gross Output by Industry (A).” Then on the next page, 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 end year as the last year presented in the graphic.
- In the code list, select only “(3311IS) Iron and steel mills and manufacturing from
purchased steel.” Do not select any other item in this menu, doing so may double count.
- Click “Refresh Table”
- Row 1 of the resulting table, labeled “Iron and steel mills and manufacturing from purchased steel"
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: 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 corresponding to years presented in the graphic.
- 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 3311 and 3312.
- With the filter in place, aggregate the “emp” column across all records.
X
Produced Goods
How to Download Your Data
- Go to https://minerals.usgs.gov/minerals/pubs/commodity/iron_&_steel/
- Use the most recent “Iron and Steel” report under “Mineral Commodities Summaries”
- Use the value under "Raw steel production"
- Repeat step 3 for year, for reports from 2000 onwards to obtain all historical data.
X