Document ID: EPA-HQ-OAR-2015-0072-0221
Agency: epa
Document Type: Supporting & Related Material
Title: 
Posted Date: 2020-04-30T04:00Z

Subject: Input data for analyses associated with Chapter 3/Appendix B and Appendix A and of the PM NAAQS Policy Assessment. 
Date: February 2020

Chapter 3/Appendix B data files
	The following files (found in the folder titled "Chapter 3 appendix B data") were used to calculate analyses and develop figures and tables associated Chapter 3 and Appendix B of the Policy Assessment. In some files, the data is a product of statistical analyses using statistical software programs R Software and SAS, but could be generated using any type of statistical software. For illustration purposes, the files below were imported into Tableau software (Tableau 2019.3). The table below states the file name and associated figures within Chapter 3 or Appendix B of the Policy Assessment. 
	The file "Base_analysis_file.xlsx" was developed by EPA staff, using data from multiple sources, including published papers referenced in Chapter 3 of the Policy Assessment, U.S. 2015 Census Data and 2016 Statistics Canada data (see section B.4), as well as Air Quality information accessed from the Air Quality System (AQS) and found in the following file names: 

          "24hrDV_wPop_ALL_COUNTIES_1999_2017_Special_POP.xlsx"; and  
          "AnnualDV_wPop_ALL_COUNTIES_1999_2017_Special_POP.xlsx" 

This file ("Base_analysis_file.xlsx") serves as the main file from which most analysis files in the table below were derived.
                                 Figure/Table
                          Associated Excel File Name
                               File Description
Figure 3-3, 3-4, 3-5, 3-6
Base_analysis_file.xlsx
This file is the main file used for most analyses below.  The file contains information related to effect estimates, design values, and population data. 
Figure 3-7
Monitored.Mean.Percentile.xlsx
File contains mean/median, and where available, 10th and 25th percentile study concentration data for monitored studies.
Figure 3-8
Modeled.Mean.Percentile.xlsx
File contains mean/median, and where available, 10th and 25th percentile study concentration data for modeled studies.
Figure 3-9, Figure B-6, Figure B-9, Table B-5 and Table B-6
1. "Base_analysis_file.xlsx"
2. Population_percentile_and_pseudo_dv.xlsx
Population_percentile_and_pseudo_dv.xlsx is derived from "Base_analysis_file.xlsx" and contains data related to the percentile of population associated with a study average maximum pseudo design value.
Table B-7 and Table B-8
1.Epi study info.xlsx;
2.total population by study by pop by county.xlsx; 
3.total population by study by pop by county with DV.xlsx
These files were derived from the "Base_analysis_file.xlsx" file and contain information related to exposure years, design values and population, by study.
Figure B-3, Figure B-4
1. Study percentiles.xlsx
2. Population_percentile_and_pseudo_dv.xlsx
These files were derived from the "Base_analysis_file.xlsx" and contain information related to design values and the percentile population related to the percent of population. 
Figure B-5
1. Base_analysis_file.xlsx
2. DV and County Number by Reference 1.xlsx
Includes descriptive statistics on the number of study locations, study years, and number of DV values.
Figure B-7, Figure B-8, and Table B-9
CBSA_DV_Annual_Daily_Avg_Max_2015_2017.xlsx
Contains information related to design values by CBSA
Figure B-10, Figure B-11, Table B-10, and Table B-11
1. Reference and location and DV by year 1.csv
2. All studies and DVs split by bin.csv
Each file derived from Base_analysis_file.xlsx and contains study area reference information, as well as mean design values placed in 1 ug/m3 bins.
Appendix B Footnote 12
Population_percentile_and_real_dv_Di and Shi studies.xlsx
File related to analyses associated with regulatory versus non regulatory monitor analysis

Appendix A data files
	The following files (Found in the "Appendix A emails and data files" folder) are referenced in Appendix A. All files are attached to an email, except for "downscaler_12US2.ann.avg.rdata," and an explanation of the files is present within the respective email. The "downscaler" files titled "downscaler_12US2.ann.avg.rdata"  were developed in terms of daily average Downscaler predictions on a national grid following methods described in Appendix C of the Policy Assessment. 

File name
Main File or Attachment (if applicable)
Email EPA Request for info from Qian Di ftp site.pdf

Email EPA Request for info from Qian Di PM2.5 Exposure Fields.pdf
Main file (email)
Email EPA Request for info from Qian Di PM2.5 Exposure Fields data attachment.rdata
attachment
Email EPA Request for info from Yang Liu PM2.5 Exposure Fields.pdf
Main file (email)
Email EPA Request for info from Yang Liu PM2.5 Exposure Fields data attachement.rdata
attachment
Email EPA Request for info from van Donkelaar 2011 PM2.5 Spatial Fields.pdf
Main File (email)
Email EPA Request for info from van Donkelaar 2011 PM2.5 Spatial Fields attachement 1.nc
Attachment 1
Email EPA Request for info from van Donkelaar 2011 PM2.5 Spatial Fields attachement 2.rdata
Attachment 2 
downscaler_12US2.ann.avg.rdata
Main File