UPDATED: September 2017 with data from USGS Mineral Yearbook Nitrogen, 2015 advance release tables
This excel spreadsheet contains selected raw data from 59 years of US Geological Survey reports, specifically Mineral Yearbook, Nitrogen (1958 – 2015) and Mineral Commodity Summaries (1996 – 2016), with a focus on “Table 1: Salient Ammonia Statistics.”
The download (.xlsx, 96KB) contains unbroken annual data series (58 years) for US ammonia production, consumption, imports, and exports, as well as total global ammonia production.
Purchase download for $25 (save $50): Salient Ammonia Statistics: USGS (.xlsx) →
ABOUT THIS DOWNLOAD
All this data is publicly available, in 60+ separate PDF files, from the USGS website.
This excel file also includes data, when provided by USGS (partial datasets), for the following: US capacity utilization rate, company count, plant count, average product price, average natural gas price, and net import reliance, among others.
In addition, it includes the total US ammonia capacity, presented in Table 4 of the Mineral Yearbook (partial dataset 1958-1978, unbroken data 1979-2015).
I’ll update this spreadsheet whenever USGS publishes new data (next expected: 2017).
To avoid confusion, the spreadsheet presents raw data given in metric tons (from 1988) in separate rows from raw data given in short tons (up to 1987). In addition to the raw data, the file includes rows of data with unit conversions, creating consistent, usable data series (unit conversions: short/metric tons, and contained nitrogen/product tons).
Note that USGS’s “Salient Ammonia Statistics” series extends further back than 1958; however, older data is presented under a different methodology and is not comparable.
This download and the data it contains are provided “as is.” I don’t believe there are any errors but, if you identify one, please contact me so that I can correct it.