Design Value Workfile Formats

Lead Format

Position	Element	Definition or Derivation
1	State Code or Tribal Indicator	For state-owned sites, this is the FIPS (Census Bureau) 2 digit code for State. For Tribal sites, this is the string ‘TT’ indicating that it is a tribal site. For Canadian and Mexican sites, this is ‘CC’ or ‘80’ respectively.
2	County Code or Tribal Code	For tribal sites, this is the FIPS 3-digit tribal code. For Non-tribal sites, this is the FIPS 3-digit County Code . For Canada and Mexico , these are AQS assigned 3-digit numbers.
3	Site-Number	AQS assigned number for site, unique to the county or tribe.
4	Parameter Code	AQS Code for Pollutant (Lead = 14129)
5	Design Value Year	Year associated with 3 year summaries (last year of 3-year period)
6	Exceptional Data Type	Single digit code indicating how the summary is affected by exceptional events: 0 – No sample measurements were flagged 1 – All flagged measurements are excluded 2 – Flagged measurements not excluded (i.e. all measurements included) 5 – Concurred flagged measurements excluded
7	One-Hour Pollutant Standard,	Unique name associated with NAAQS standard
8	One-Hour Standard Statistic	Name of statistic that is compared to the one hour standard.
9	One-Hour Standard Level	Value of one hour standard
10	Units Code	AQS code of units associated with standard and all statistics
11	Units Name	Text description of Units Code
12	Street Address	Street address of site from SITES table
13	Site Latitude	Latitudeof site from SITES table.
14	Site Longitude	Longitude of site from SITES table.
15	3 Year Design Value	Maximum 3-Month combined site-level mean for the 3-year period.
16	3 Year Design Value Validity	Set to ‘Y’ if any of the following is TRUE, Otherwise set to ‘N’: The 3-Year Design Value > Standard. All 36 combined site-level summaries in the 3-year period are valid. For the 2012 Design Value Year: For sites that begin monitoring after Jan. 12, 2009 but before January 15, 2010, there exist 34 consecutive valid combined site-level summaries in the 3-year period For the 2013 Design Value Year: For sites that begin monitoring after Jan. 12, 2009 but before January 15, 2011, there exist 34 consecutive valid combined site-level summaries in the 3-year period
17	3 Year Maximum Month	Month when Design Value occurs
18	3 Year Maximum Year	Year when Design value occurs
19	3-Year DV Combined Site Summaries	Number of valid combined site-level summaries in the 3-year period
20	Design Value Year: Highest Valid Combined Site Summary,	Highest Valid combined site-level summary for the year
21	Design Value Year: Max Month	Month when the highest valid combined site-level summary occurs in the year
22	Design Value Year: Parameter Codes	Parameter code of the highest valid combined site-level summary occurs in the year
23	Design Value Year: Valid Months	Number of valid months in the year.
24	Design Value Year: Certification Indicator	Indicator that the reporting agency has certified that the data for the year is complete and correct, and that the EPA agrees (or disagrees) that the certification requirements are met.
25	Year -1: Highest Valid Combined Site Summary,	Highest Valid combined site-level summary for the year
26	Year -1: Max Month	Month when the highest valid combined site-level summary occurs in the year
27	Year -1: Parameter Codes	Parameter code of the highest valid combined site-level summary occurs in the year
28	Year -1: Valid Months	Number of valid months in the year.
29	Year -1: Certification Indicator	Indicator that the reporting agency has certified that the data for the year is complete and correct, and that the EPA agrees (or disagrees) that the certification requirements are met..
30	Year -2: Highest Valid Combined Site Summary,	Highest Valid combined site-level summary for the year
31	Year -2: Max Month	Month when the highest valid combined site-level summary occurs in the year
32	Year -2: Parameter Codes	Parameter code of the highest valid combined site-level summary occurs in the year
33	Year -2: Valid Months	Number of valid months in the year.
34	Year -2: Certification Indicator	Indicator that the reporting agency has certified that the data for the year is complete and correct, and that the EPA agrees (or disagrees) that the certification requirements are met.

NO2 Format

Position	Element	Definition or Derivation
1	State Code or Tribal Indicator	For state-owned sites, this is the FIPS (Census Bureau) 2 digit code for State. For Tribal sites, this is the string ‘TT’ indicating that it is a tribal site. For Canadian and Mexican sites, this is ‘CC’ or ‘80’ respectively.
2	County Code or Tribal Code	For tribal sites, this is the FIPS 3-digit tribal code. For Non-tribal sites, this is the FIPS 3-digit County Code . For Canada and Mexico , these are AQS assigned 3-digit numbers.
3	Site-Number	AQS assigned number for site, unique to the county or tribe.
4	Parameter Code	AQS Code for Pollutant (NO2=42602)
5	Design Value Year	Year associated with 3 year summaries (last year of 3-year period)
6	Exceptional Data Type	Single digit code indicating how the summary is affected by exceptional events: 0 – No sample measurements were flagged 1 – All flagged measurements are excluded 2 – Flagged measurements not excluded (i.e. all measurements included) 5 – Concurred flagged measurements excluded
7	One-Hour Pollutant Standard,	Unique name associated with NAAQS standard
8	One-Hour Standard Statistic	Name of statistic that is compared to the one hour standard.
9	One-Hour Standard Level	Value of one hour standard
10	Units Code	AQS code of units associated with standard and all statistics
11	Units Name	Text description of Units Code
12	Street Address	Street address of site from SITES table
13	Site Latitude	Latitude of site from SITES table.
14	Site Longitude	Longitude of site from SITES table.
15	Design Value Year: Count of Complete Quarters	Number of quarterly summaries, with the corresponding pollutant standard and exceptional data type, where the summary criterion is met, in the design value year
16	Design Value Year: 98th Percentile	The 98th percentile of the 1 hour NO2 values for the year for the design value year. The calculation of the 98th percentile for SO2 can be found in Appendix S of the 40 CFR 50.
17	Design Value Year: Certification Indicator	Indicator that the reporting agency has certified that the data for the year is complete and correct, and that the EPA agrees (or disagrees) that the certification requirements are met.
18	Year 1: Count of Complete Quarters	Number of quarterly summaries, with the corresponding pollutant standard and exceptional data type, where the summary criterion is met, in Year 1, where Year 1 is the year before the design value year (Example: If Design value year is 2012, Year 1 is 2011.
19	Year 1: 98th Percentile	The 98th percentile of the 1 hour NO2 values for the year for Year 1. The calculation of the 98th percentile for NO2 can be found in Appendix S of the 40 CFR 50.
20	Year 1: Certification Indicator	Indicator that the reporting agency has certified that the data for the year is complete and correct, and that the EPA agrees (or disagrees) that the certification requirements are met.
21	Year 2: Count of Complete Quarters	Number of quarterly summaries, with the corresponding pollutant standard and exceptional data type, where the summary criterion is met, in Year 2, where Year 2 is the year before the design value year (Example: If Design value year is 2012, Year 2 is 2010.
22	Year 2: 98th Percentile	The 98th percentile of the 1 hour NO2 values for the year for Year 2. The calculation of the 99th percentile for NO2 can be found in Appendix S of the 40 CFR 50.
23	Year 2: Certification Indicator	Indicator that the reporting agency has certified that the data for the year is complete and correct, and that the EPA agrees (or disagrees) that the certification requirements are met.
24	3 Year Design Value	Average of one hour 98th percentiles for 3 year period.
25	3 Year Design Value Validity Indicator	V Set to ‘Y’ if any of the following are true, set to ‘N’ otherwise: All quarters have Completeness Percent >= 75% for all 3 years. The 3-Year 1-Hour Design Value <= the hourly standard (100 ppb) and all of the following are true: For each quarter, there are a total of 200 valid days for that quarter in the 3-year period The Percent Days for each quarter in each year >= 50% The average of the High-Substituted 98th Percentile values <= the hourly standard (100 ppb) The 3-Year 1-Hour Design Value > the hourly standard (100 ppb) and at least 75% of the days in each quarter in the three year period have at least one reported hourly value. (i.e. Quarterly Day Percent >= 75%) The 3-Year 1-Hour Design Value > the hourly standard (100 ppb) and all of the following are true: For each quarter, there are a total of 200 valid days for that quarter in the 3-year period The average of the Low-Substituted 98th Percentile values > the hourly standard (100 ppb)

Ozone Format

Position	Field Name	Definition or Derivation
1	State Code or Tribal Indicator	For state-owned sites, this is the FIPS (Census Bureau) 2 digit code for State. For Tribal sites, this is the string ‘TT’ indicating that it is a tribal site. For Canadian and Mexican sites, this is ‘CC’ or ‘80’ respectively.
2	County Code or Tribal Code	For tribal sites, this is the FIPS 3-digit tribal code. For Non-tribal sites, this is the FIPS 3-digit County Code. For Canada and Mexico, these are AQS assigned 3-digit numbers.
3	Site-Number	AQS assigned number for site, unique to the county or tribe.
4	Parameter Code	AQS Code for Pollutant (Ozone = 44201)
5	POC	Parameter Occurrence Code from MONITORS table.
6	Design Value Year	Year associated with 3 year summaries (last year of 3-year period)
7	Exceptional Data Type	Single digit code indicating how the summary is affected by exceptional events: 0 – No sample measurements were flagged 1 – All flagged measurements are excluded 2 – Flagged measurements not excluded (i.e. all measurements included) 5 – Concurred flagged measurements excluded
8	Pollutant Standard	Unique name associated with NAAQS standard
9	Standard Statistic	Name of statistic that is compared to the NAAQS standard.
10	Standard Level	Value of NAAQS standard
11	AQS Units Code	AQS code of units associated with standard and all statistics
12	Units Description	Text description for meaning of units code.
13	User Site Metadata	One of the following fields selected by the user via report options: · Street Address (SITES table) · City Name (CITIES table) · County Name (COUNTIES table) · Local Site Name (SITES table) · Local Site ID (SITES table) · Urbanized Area (URBANIZED_AREAS table) · CBSA Name (CORE_BASED_STATISTICAL_AREAS table)
14	Site Latitude	Latitude of site from SITES table.
15	Site Longitude	Longitude of site from SITES table.
16	DV Year: Valid Days	Count of days that met completeness requirements in the effective monitoring season for the year. From ANNUAL_SUMMARIES table.
17	DV Year: Missing Days Assumed Less than Standard	A missing or invalid day is assumed to be less than the standard when the sum of the following is greater than or equal to 18 for 8-hour averages: § Number of valid 8-hour averages § Number of 8-hour averages with (Number of Observations + Null Data Codes that are regionally concurred) > 6
18	DV Year: Required Days	Number of days in the effective monitoring season
19	DV Year: Percent Complete	100 * (Number of Valid Days + Number of Missing Days Assumed Less Than the Standard) / Number of Required Days for year From ANNUAL_SUMMARIES table
20	DV Year: 4^th Maximum	Fourth largest daily maximum value in the effective monitoring season for the year. From SUMMARY_MAXIMUMS table
21	DV Year: Certification	Indicator that the reporting agency has certified that the data for the year is complete and correct, and that the EPA agrees (or disagrees) that the certification requirements are met. From ANNUAL _SUMMARIES table
22	DV Year – 1: Valid Days	Count of days that met completeness requirements in the effective monitoring season for the year. From ANNUAL_SUMMARIES table
23	DV Year – 1: Missing Days Assumed Less than Standard	A missing or invalid day is assumed to be less than the standard when the sum of the following is greater than or equal to 18 for 8-hour averages: § Number of valid 8-hour averages § Number of 8-hour averages with (Number of Observations + Null Data Codes that are regionally concurred) > 6
24	DV Year – 1: Required Days	Number of days in the effective monitoring season
25	DV Year - 1: Percent Complete	100 * (Number of Valid Days + Number of Missing Days Assumed Less Than the Standard) / Number of Required Days for year From ANNUAL_SUMMARIES table
26	DV Year – 1: 4^th Maximum	Fourth largest daily maximum value in the effective monitoring season for the year. From SUMMARY_MAXIMUMS table
27	DV Year – 1: Certification	Indicator that the reporting agency has certified that the data for the year is complete and correct, and that the EPA agrees (or disagrees) that the certification requirements are met. From ANNUAL _SUMMARIES table
28	DV Year - 2: Valid Days	Count of days that met completeness requirements in the effective monitoring season for the year. From ANNUAL_SUMMARIES table
29	DV Year - 2: Missing Days Assumed Less than Standard	A missing or invalid day is assumed to be less than the standard when the sum of the following is greater than or equal to 18 for 8-hour averages: § Number of valid 8-hour averages § Number of 8-hour averages with (Number of Observations + Null Data Codes that are regionally concurred) > 6
30	DV Year - 2: Required Days	Number of days in the effective monitoring season
31	DV Year - 2: Percent Complete	100 * (Number of Valid Days + Number of Missing Days Assumed Less Than the Standard) / Number of Required Days for year From ANNUAL_SUMMARIES table
32	DV Year – 2: 4^th Maximum	Fourth largest daily maximum value in the effective monitoring season for the year. From SUMMARY_MAXIMUMS table
33	DV Year - 2: Certification	Indicator that the reporting agency has certified that the data for the year is complete and correct, and that the EPA agrees (or disagrees) that the certification requirements are met. From ANNUAL _SUMMARIES table
34	3-Year Percent Complete	100 * (Number of Valid Days + Number of Missing Days Assumed Less Than the Standard) / Number of Required Days for all 3 years. From ANNUAL_SUMMARIES table
35	3-Year Design Value	Average of annual 4^th maximums for 3 year period.
36	Design Value Validity Indicator	Set to ‘Y’ if the Annual Summary for the Design Value Year, and the two immediately prior years exist, AND · The 3-Year Design Value is above the level of the standard OR · the 3-Year Completeness Percent is greater than or equal to 90% and, and at least one of the following is true for each year: Percent Complete >= 75% for year The Annual 4^th Maximum is greater than the level of the standard Otherwise set to ‘N’

PM 2.5 Format

Position	Field Name	Definition or Derivation
1	State Code or Tribal Indictor	For state-owned sites, this is the FIPS (Census Bureau) 2 digit code for State. For Tribal sites, this is the string ‘TT’ indicating that it is a tribal site. For Canadian and Mexican sites, this is ‘CC’ or ‘80’ respectively.
2	County Code or Tribal Code	For tribal sites, this is the FIPS 3-digit tribal code. For Non-tribal sites, this is the FIPS 3-digit County Code. For Canada and Mexico, these are AQS assigned 3-digit numbers.
3	Site ID Number	AQS assigned number for site, unique to the county or tribe.
4	Parameter Code	AQS Code for Pollutant (PM 2.5 = 88101)
5	Design Value Year	Year associated with 3 year summaries (last year of 3-year period)
6	Exceptional Data Type	Single digit code indicating how the summary is affected by exceptional events: 0 – No sample measurements were flagged 1 – All flagged measurements are excluded 2 – Flagged measurements not excluded (i.e. all measurements included) 5 – Concurred flagged measurements excluded
7	Daily Pollutant Standard	Unique name associated with NAAQS standard
8	Daily Standard Statistic	Name of statistic that is compared to the daily standard.
9	Daily Standard Level	Value of daily standard
10	Annual Pollutant Standard	Unique name associated with NAAQS standard
11	Annual Standard Statistic	Name of statistic that is compared to the annual standard.
12	Annual Standard Level	Value of annual standard
13	Units Code	AQS code of units associated with standard and all statistics
14	Units Name	Text description for meaning of units code.
15	User Site Metadata	One of the following fields selected by the user via report options: · Street Address (SITES table) · City Name (CITIES table) · County Name (COUNTIES table) · Local Site Name (SITES table) · Local Site ID (SITES table) · Urbanized Area (URBANIZED_AREAS table) · CBSA Name (CORE_BASED_STATISTICAL_AREAS table)
16	Site Latitude	Latitude of site from SITES table.
17	Site Longitude	Longitude of site from SITES table.
18	DV Year: Creditable Count	Count of days with samples that are either scheduled days or make-up days for the monitor where the sample was collected. From SITE_ANNUAL_SUMMARIES table
19	DV Year: Complete Quarters	Number of Quarters with an observation percent that is greater than or equal to 75%. From SITE_QUARTERLY_SUMMARIES table
20	DV Year: Arithmetic Mean	Mean of all quarterly arithmetic means for site-year. From SITE_ANNUAL_SUMMARIES table
21	DV Year: Min Substituted Mean	Annual Mean computed with incomplete or missing quarters. (computed using the minimum quarterly substituted means). (Computed on the fly by the report)
22	DV Year: Max Substituted Mean	Annual Mean computed with incomplete or missing quarters. (computed using the maximum quarterly substituted means). (Computed on the fly by the report)
23	DV Year: Mean Complete	Flag indicating that annual mean is valid. Set to ‘Y’ according to the following rules: All 4 quarters are 75% complete, or All 4 quarters have at least 11 actual values and the annual mean > the annual standard, or The Substituted Annual Mean exists and is greater than the annual standard (Computed on the fly by the report)
24	DV Year: 98^th Percentile	Site-level 98^th percentile. From SITE_ANNUAL_SUMMARIES table.
25	DV Year: 98^th Complete	Flag indicating that annual 98^th percentile is valid. Set to ‘Y’ according to the following rules: · All 4 quarters are 75% complete, or · Annual 98^th percentile value greater than the 24-hour standard (35 ug/m³). Note: Value must be rounded to 0 digits after decimal before comparison to standard.
26	DV Year: Certification	Indicator that the reporting agency has certified that the data for the year is complete and correct, and that the EPA agrees (or disagrees) that the certification requirements are met. Derivation: Set to ‘Y’ if and only if all Monitor-Year data at site are certified (i.e. primary and all collocated)
27	Year - 1: Creditable Count	Count of days with samples that are either scheduled days or make-up days for the monitor where the sample was collected. From SITE_ANNUAL_SUMMARIES table
28	Year - 1: Complete Quarters:	Number of Quarters with an observation percent that is greater than or equal to 75%. From SITE_QUARTERLY_SUMMARIES table
29	Year - 1: Arithmetic Mean	Mean of all quarterly arithmetic means for site-year. SITE_ANNUAL_SUMMARIES table
30	Year - 1: Min Substituted Mean	Annual Mean computed with incomplete or missing quarters (computed using the minimum quarterly substituted means) (Computed on the fly by the report)
31	Year - 1: Max Substituted Mean	Annual Mean computed with incomplete or missing quarters (computed using the maximum quarterly substituted means) (Computed on the fly by the report)
32	Year - 1: Mean Complete	Flag indicating that annual mean is valid. Set to ‘Y’ according to the following rules: · All 4 quarters are 75% complete, or · All 4 quarters have at least 11 actual values and the annual mean > the annual standard, or · The Substituted Annual Mean exists and is greater than the annual standard (Computed on the fly by the report)
33	Year - 1: 98^th Percentile	Site-level 98^th percentile. From SITE_ANNUAL_SUMMARIES table.
34	Year - 1: 98^th Complete	Flag indicating that annual 98^th percentile is valid. Set to ‘Y’ according to the following rules: · All 4 quarters are 75% complete, or · Annual 98^th percentile value greater than the 24-hour standard (35 ug/m³). Note: Value must be rounded to 0 digits after decimal before comparison to standard.
35	Year - 1: Certification	Indicator that the reporting agency has certified that the data for the year is complete and correct, and that the EPA agrees (or disagrees) that the certification requirements are met. Derivation: Set to ‘Y’ if and only if all Monitor-Year data at site are certified (i.e. primary and all collocated)
36	Year - 2: Creditable Count	Count of days with samples that are either scheduled days or make-up days for the monitor where the sample was collected. From SITE_ANNUAL_SUMMARIES table
37	Year - 2: Complete Quarters:	Number of Quarters with an observation percent that is greater than or equal to 75%. From SITE_QUARTERLY_SUMMARIES table
38	Year - 2: Arithmetic Mean	Mean of all quarterly arithmetic means for site-year. From SITE_ANNUAL_SUMMARIES table
39	Year - 2: Min Substituted Mean	Annual Mean computed with incomplete or missing quarters. (computed using the minimum quarterly substituted means) (Computed on the fly by the report)
40	Year - 2: Max Substituted Mean	Annual Mean computed with incomplete or missing quarters. (computed using the maximum quarterly substituted means) (Computed on the fly by the report)
41	Year - 2: Mean Complete	Flag indicating that annual mean is valid. Set to ‘Y’ according to the following rules: · All 4 quarters are 75% complete, or · All 4 quarters have at least 11 actual values and the annual mean > the annual standard, or · The Substituted Annual Mean exists and is greater than the annual standard (Computed on the fly by the report)
42	Year - 2: 98^th Percentile	Site-level 98^th percentile. From SITE_ANNUAL_SUMMARIES table.
43	Year - 2: 98^th Complete	Flag indicating that annual 98^th percentile is valid. Set to ‘Y’ according to the following rules: · All 4 quarters are 75% complete, or · Annual 98^th percentile value greater than the 24-hour standard (35 ug/m³). Note: Value must be rounded to 0 digits after decimal before comparison to standard.
44	Year - 2: Certification	Indicator that the reporting agency has certified that the data for the year is complete and correct, and that the EPA agrees (or disagrees) that the certification requirements are met. Derivation: Set to ‘Y’ if and only if all Monitor-Year data at site are certified (i.e. primary and all collocated)
45	Daily Design Value	Average of current year and prior two calendar year Annual Summary 98^th percentile values (e.g., the design value for the 24-hour standard). From SITE_ANNUAL_SUMMARIES table
46	Daily Max Substituted Design Value	Daily Design Value computed with incomplete or missing data substituted with the maximum substitution value. (Computed on the fly by the report)
47	Daily Validity Indicator	Flag indicating that the 24-Hour Standard Design Value is “valid” as per 40 CFR Part 50 Appendix N. Set to valid (i.e. ‘Y’) if all three years are present and one of the following is true: The Annual 98th Percentile Completeness Indicator for the DV year and the two immediately prior years exists and is set to “valid” (i.e. ‘Y’). The 24-hour Standard Design Value > the standard (Note: This can occur with missing quarters.) From SITE_ANNUAL_SUMMARIES table
48	Annual Design Value	Average of DV year and 2 prior years site-level weighted arithmetic mean. From SITE_ANNUAL_SUMMARIES table
49	Annual Min Substituted Design Value	Annual Design Value computed with incomplete or missing data substituted with the minimum substitution value. (Computed on the fly by the report)
50	Annual Max Substituted Design Value	Annual Design Value computed with incomplete or missing data substituted with the maximum substitution value. (Computed on the fly by the report)
51	Annual Validity Indicator	Flag indicating that the Single Site Annual Design Value is valid. Set to valid if all three years are present and any of the following is true: · The present year and the two prior year Annual Mean Completeness Indicators are set to complete (i.e. ‘Y’). · The 3-Year Substituted Mean exists and is above the standard (15). · The 3-Year Annual Standard Design Value is above the standard (15) and the Substituted Annual Design Value is null. (Computed on the fly by the report)
52	3 Year Q1 Minimum	The minimum substitution value for calendar quarter 1.
53	3 Year Q2 Minimum	The minimum substitution value for calendar quarter 2.
54	3 Year Q3 Minimum	The minimum substitution value for calendar quarter 3.
55	3 Year Q4 Minimum	The minimum substitution value for calendar quarter 4.
56	3 Year Q1 Maximum (Annual Standard)	The maximum substitution value for calendar quarter 1 used in the annual standard calculations.
57	3 Year Q2 Maximum (Annual Standard)	The maximum substitution value for calendar quarter 2 used in the annual standard calculations.
58	3 Year Q3 Maximum (Annual Standard)	The maximum substitution value for calendar quarter 3 used in the annual standard calculations.
59	3 Year Q4 Maximum (Annual Standard)	The maximum substitution value for calendar quarter 4 used in the annual standard calculations.
60	3 Year Q1 Maximum (Daily Standard)	The maximum substitution value for calendar quarter 1 used in the daily standard calculations.
61	3 Year Q2 Maximum (Daily Standard)	The maximum substitution value for calendar quarter 2 used in the daily standard calculations.
62	3 Year Q3 Maximum (Daily Standard)	The maximum substitution value for calendar quarter 3 used in the daily standard calculations.
63	3 Year Q4 Maximum (Daily Standard)	The maximum substitution value for calendar quarter 4 used in the daily standard calculations.
64	DV Year Q1: Creditable Count	Count of days with samples that are either scheduled days or make-up days for the monitor where the sample was collected. From SITE_QUARTERLY_SUMMARIES table
65	DV Year Q1: Observation Count	Count of total number of days in quarter with site-level daily summaries (not just scheduled days).
66	DV Year Q1: Percent Complete	Completeness Percent (100 X Creditable Days / Scheduled Days) From SITE_QUARTERLY_SUMMARIES
67	DV Year Q1: Arithmetic Mean	Average of all site-level daily values (on all days, not just scheduled days) for quarter From SITE_QUARTERLY_SUMMARIES
68	DV Year Q1: Min Substituted Mean	The quarterly mean using the minimum value substitution calculation. Only computed if quarterly completeness below 75% and daily design value > standard and there is a valid 3-year quarterly minimum. Computed by following formula: SM= (SUM(DV) + MD* Three_Year_Min)/11 Where: · SM is the Substituted Mean · SUM(DV) is the sum of the site-level daily arithmetic means in the quarter (on any day, not just scheduled days) · MD is: 11 – the number of Actual Sample Days · Three_Year_Min is the minimum site-level daily arithmetic mean in the corresponding calendar quarter for the three year DV period. (Computed on the fly by the report)
69	DV Year Q1: Max Substituted Mean	The quarterly mean using the maximum value substitution calculation. Only computed if quarterly completeness between 50 and 75% and quarterly mean < standard. Computed by following formula: SM= (SUM(DV) + MD* Three_Year_Max)/11 Where: · SM is the Substituted Mean · SUM(DV) is the sum of the site-level daily arithmetic means in the quarter (on any day, not just scheduled days) · MD is: 11 – the number of Actual Sample Days · Three_Year_Max is the maximum site-level daily arithmetic mean in the corresponding calendar quarter for the three year DV period. (Computed on the fly by the report)
70	DV Year Q2: Creditable Count	Count of days with samples that are either scheduled days or make-up days for the monitor where the sample was collected. From SITE_QUARTERLY_SUMMARIES table
71	DV Year Q2: Observation Count	Count of total number of days in quarter with site-level daily summaries (not just scheduled days).
72	DV Year Q2: Percent Complete	Completeness Percent (100 X Creditable Days / Scheduled Days) From SITE_QUARTERLY_SUMMARIES
73	DV Year Q2: Arithmetic Mean	Average of all site-level daily values (on all days, not just scheduled days) for quarter From SITE_QUARTERLY_SUMMARIES
74	DV Year Q2: Min Substituted Mean	The quarterly mean using the minimum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)
75	DV Year Q2: Max Substituted Mean	The quarterly mean using the maximum value substitution calculation, See DV Year Q1 for description of calculation. (Computed on the fly by the report)
76	DV Year Q3: Creditable Count	Count of days with samples that are either scheduled days or make-up days for the monitor where the sample was collected. From SITE_QUARTERLY_SUMMARIES table
77	DV Year Q3: Observation Count	Count of total number of days in quarter with site-level daily summaries (not just scheduled days).
78	DV Year Q3: Percent Complete	Completeness Percent (100 X Creditable Days / Scheduled Days) From SITE_QUARTERLY_SUMMARIES
79	DV Year Q3: Arithmetic Mean	Average of all site-level daily values (on all days, not just scheduled days) for quarter From SITE_QUARTERLY_SUMMARIES
80	DV Year Q3: Min Substituted Mean	The quarterly mean using the minimum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)
81	DV Year Q3: Max Substituted Mean	The quarterly mean using the maximum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)
82	DV Year Q4: Creditable Count	Count of days with samples that are either scheduled days or make-up days for the monitor where the sample was collected. From SITE_QUARTERLY_SUMMARIES table
83	DV Year Q4: Observation Count	Count of total number of days in quarter with site-level daily summaries (not just scheduled days).
84	DV Year Q4: Percent Complete	Completeness Percent (100 X Creditable Days / Scheduled Days) From SITE_QUARTERLY_SUMMARIES
85	DV Year Q4: Arithmetic Mean	Average of all site-level daily values (on all days, not just scheduled days) for quarter From SITE_QUARTERLY_SUMMARIES
86	DV Year Q4: Min Substituted Mean	The quarterly mean using the minimum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)
87	DV Year Q4: Max Substituted Mean	The quarterly mean using the maximum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)
88	Year-1 Q1: Creditable Count	Count of days with samples that are either scheduled days or make-up days for the monitor where the sample was collected. From SITE_QUARTERLY_SUMMARIES table
89	Year-1 Q1: Observation Count	Count of total number of days in quarter with site-level daily summaries (not just scheduled days).
90	Year-1 Q1: Percent Complete	Completeness Percent (100 X Creditable Days / Scheduled Days) From SITE_QUARTERLY_SUMMARIES
91	Year-1 Q1: Arithmetic Mean	Average of all site-level daily values (on all days, not just scheduled days) for quarter From SITE_QUARTERLY_SUMMARIES
92	Year-1 Q1: Min Substituted Mean	The quarterly mean using the minimum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)
93	Year-1 Q1: Max Substituted Mean	The quarterly mean using the maximum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)
94	Year-1 Q2: Creditable Count	Count of days with samples that are either scheduled days or make-up days for the monitor where the sample was collected. From SITE_QUARTERLY_SUMMARIES table
95	Year-1 Q2: Observation Count	Count of total number of days in quarter with site-level daily summaries (not just scheduled days).
96	Year-1 Q2: Percent Complete	Completeness Percent (100 X Creditable Days / Scheduled Days) From SITE_QUARTERLY_SUMMARIES
97	Year-1 Q2: Arithmetic Mean	Average of all site-level daily values (on all days, not just scheduled days) for quarter From SITE_QUARTERLY_SUMMARIES
98	Year-1 Q2: Min Substituted Mean	The quarterly mean using the minimum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)
99	Year-1 Q2: Max Substituted Mean	The quarterly mean using the maximum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)
100	Year-1 Q3: Creditable Count	Count of days with samples that are either scheduled days or make-up days for the monitor where the sample was collected. From SITE_QUARTERLY_SUMMARIES table
101	Year-1 Q3: Observation Count	Count of total number of days in quarter with site-level daily summaries (not just scheduled days).
102	Year-1 Q3: Percent Complete	Completeness Percent (100 X Creditable Days / Scheduled Days) From SITE_QUARTERLY_SUMMARIES
103	Year-1 Q3: Arithmetic Mean	Average of all site-level daily values (on all days, not just scheduled days) for quarter From SITE_QUARTERLY_SUMMARIES
104	Year-1 Q3: Min Substituted Mean	The quarterly mean using the minimum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)
105	Year-1 Q3: Max Substituted Mean	The quarterly mean using the maximum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)
106	Year-1 Q4: Creditable Count	Count of days with samples that are either scheduled days or make-up days for the monitor where the sample was collected. From SITE_QUARTERLY_SUMMARIES table
107	Year-1 Q4: Observation Count	Count of total number of days in quarter with site-level daily summaries (not just scheduled days).
108	Year-1 Q4: Percent Complete	Completeness Percent (100 X Creditable Days / Scheduled Days) From SITE_QUARTERLY_SUMMARIES
109	Year-1 Q4: Arithmetic Mean	Average of all site-level daily values (on all days, not just scheduled days) for quarter From SITE_QUARTERLY_SUMMARIES
110	Year-1 Q4: Min Substituted Mean	The quarterly mean using the minimum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)
111	Year-1 Q4: Max Substituted Mean	The quarterly mean using the maximum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)
112	Year-2 Q1: Creditable Count	Count of days with samples that are either scheduled days or make-up days for the monitor where the sample was collected. From SITE_QUARTERLY_SUMMARIES table
113	Year-2 Q1: Observation Count	Count of total number of days in quarter with site-level daily summaries (not just scheduled days).
114	Year-2 Q1: Percent Complete	Completeness Percent (100 X Creditable Days / Scheduled Days) From SITE_QUARTERLY_SUMMARIES
115	Year-2 Q1: Arithmetic Mean	Average of all site-level daily values (on all days, not just scheduled days) for quarter From SITE_QUARTERLY_SUMMARIES
116	Year-2 Q1: Min Substituted Mean	The quarterly mean using the minimum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)
117	Year-2 Q1: Max Substituted Mean	The quarterly mean using the maximum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)
118	Year-2 Q2: Creditable Count	Count of days with samples that are either scheduled days or make-up days for the monitor where the sample was collected. From SITE_QUARTERLY_SUMMARIES table
119	Year-2 Q2: Observation Count	Count of total number of days in quarter with site-level daily summaries (not just scheduled days).
120	Year-2 Q2: Percent Complete	Completeness Percent (100 X Creditable Days / Scheduled Days) From SITE_QUARTERLY_SUMMARIES
121	Year-2 Q2: Arithmetic Mean	Average of all site-level daily values (on all days, not just scheduled days) for quarter From SITE_QUARTERLY_SUMMARIES
122	Year-2 Q2: Min Substituted Mean	The quarterly mean using the minimum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)
123	Year-2 Q2: Max Substituted Mean	The quarterly mean using the maximum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)
124	Year-2 Q3: Creditable Count	Count of days with samples that are either scheduled days or make-up days for the monitor where the sample was collected. From SITE_QUARTERLY_SUMMARIES table
125	Year-2 Q3: Observation Count	Count of total number of days in quarter with site-level daily summaries (not just scheduled days).
126	Year-2 Q3: Percent Complete	Completeness Percent (100 X Creditable Days / Scheduled Days) From SITE_QUARTERLY_SUMMARIES
127	Year-2 Q3: Arithmetic Mean	Average of all site-level daily values (on all days, not just scheduled days) for quarter From SITE_QUARTERLY_SUMMARIES
128	Year-2 Q3: Min Substituted Mean	The quarterly mean using the minimum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)
129	Year-2 Q3: Max Substituted Mean	The quarterly mean using the maximum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)
130	Year-2 Q4: Creditable Count	Count of days with samples that are either scheduled days or make-up days for the monitor where the sample was collected. From SITE_QUARTERLY_SUMMARIES table
131	Year-2 Q4: Observation Count	Count of total number of days in quarter with site-level daily summaries (not just scheduled days).
132	Year-2 Q4: Percent Complete	Completeness Percent (100 X Creditable Days / Scheduled Days) From SITE_QUARTERLY_SUMMARIES
133	Year-2 Q4: Arithmetic Mean	Average of all site-level daily values (on all days, not just scheduled days) for quarter From SITE_QUARTERLY_SUMMARIES
132	Year-2 Q4: Min Substituted Mean	The quarterly mean using the minimum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)
135	Year-2 Q4: Max Substituted Mean	The quarterly mean using the maximum value substitution calculation. See DV Year Q1 for description of calculation. (Computed on the fly by the report)

PM 10 Format

Position	Element	Definition or Derivation
1	State Code or Tribal Indictor	For state-owned sites, this is the FIPS (Census Bureau) 2 digit code for State. For Tribal sites, this is the string ‘TT’ indicating that it is a tribal site. For Canadian and Mexican sites, this is ‘CC’ or ‘80’ respectively.
2	County Code or Tribal Code	For tribal sites, this is the FIPS 3-digit tribal code. For Non-tribal sites, this is the FIPS 3-digit County Code. For Canada and Mexico, these are AQS assigned 3-digit numbers.
3	Site-Number	AQS assigned number for site, unique to the county or tribe.
4	Parameter Code	AQS Code for Pollutant (PM10 = 81102)
5	POC	Parameter Occurrence Code from MONITORS table. (Provided since there is no combining of PM-10 data at the site level.)
6	Design Value Year	Year associated with 3 year summaries (last year of 3-year period)
7	Exceptional Data Type	Single digit code indicating how the summary is affected by exceptional events: 0 – No sample measurements were flagged 1 – All flagged measurements are excluded 2 – Flagged measurements not excluded (i.e. all measurements included) 5 – Concurred flagged measurements excluded
8	Pollutant Standard	Unique name associated with NAAQS standard
9	Standard Statistic	Name of statistic that is compared to the NAAQS standard.
10	Standard Level	Value of NAAQS standard
11	AQS Units Code	AQS code of units associated with standard and all statistics
12	Units Description	Text description for meaning of units code.
13	User Site Metadata	One of the following fields selected by the user via report options: · Street Address (SITES table) · City Name (CITIES table) · County Name (COUNTIES table) · Local Site Name (SITES table) · Local Site ID (SITES table) · Urbanized Area (URBANIZED_AREAS table) · CBSA Name (CORE_BASED_STATISTICAL_AREAS table)
14	Site Latitude	Latitude of site from SITES table.
15	Site Longitude	Longitude of site from SITES table.
16	DV Year Complete Quarters	Count of quarters with observation percent >= 75%. From QUARTERLY_SUMMARIES
17	DV Year Estimated Exceedances	Computed as per 40 CFR Part 50 Appendix K From ANNUAL_SUMMARIES table (EST_DAYS_GT_STD)
18	DV Year Exceedance Count	Number of valid daily means greater than the level of the standard. From ANNUAL_SUMMARIES table (VALUES_GT_PRI_LEVEL)
19	DV Year Certification	Indicator that the reporting agency has certified that the data for the year is complete and correct, and that the EPA agrees (or disagrees) that the cerrtifiction requirements are met.. From ANNUAL _SUMMARIES table
20	Year - 1 Complete Quarters	Count of quarters with observation percent >= 75%. From QUARTERLY_SUMMARIES
21	Year - 1 Estimated Exceedances	Computed as per 40 CFR Part 50 Appendix K From ANNUAL_SUMMARIES table (EST_DAYS_GT_STD)
22	Year - 1 Exceedance Count	Number of valid daily means greater than the level of the standard. From ANNUAL_SUMMARIES table (VALUES_GT_PRI_LEVEL)
23	Year - 1 Certification	Indicator that the reporting agency has certified that the data for the year is complete and correct, and that the EPA agrees (or disagrees) that the cerrtifiction requirements are met.. From ANNUAL _SUMMARIES table
24	Year - 2 Complete Quarters	Count of quarters with observation percent >= 75%. From QUARTERLY_SUMMARIES
25	Year - 2 Estimated Exceedances	Computed as per 40 CFR Part 50 Appendix K From ANNUAL_SUMMARIES table (EST_DAYS_GT_STD)
26	Year – 2 Exceedance Count	Number of valid daily means greater than the level of the standard. From ANNUAL_SUMMARIES table (VALUES_GT_PRI_LEVEL)
27	Year - 2 Certification	Indicator that the reporting agency has certified that the data for the year is complete and correct, and that the EPA agrees (or disagrees) that the cerrtifiction requirements are met.. From ANNUAL _SUMMARIES table
28	3-Year Estimated Exceedances	Average of Annual Number of Estimated Exceedances. Note: If less than 3 years present, then 0 used for missing year(s). From ANNUAL _SUMMARIES table
29	3-Year Validity Indicator	Set to ‘Y’ if any of the following are true. § Observation Percent >= 75% for each quarter for all 3 years § 3-Year Estimated Exceedances > 1.
30	DV Year Qtr1: Valued Strata	Number of strata (time intervals), based on Required Collection Frequency, in quarter with at least 1 actual sample measurement
31	DV Year Qtr1: Actual Samples	Number of actual sample measurements in quarter.
32	DV Year Qtr1: Scheduled Samples	Number of strata (time intervals), based on Required Collection Frequency, in quarter.
33	DV Year Qtr1: Estimated Exceedances	Computed as per 40 CFR Part 50 Appendix K (Based on number of strata in quarter vs the number of days in quarter)
34	DV Year Qtr1: Exceedance Count	Number of valid daily means greater than the level of the standard.
35	DV Year Qtr2: Valued Strata	Number of strata (time intervals), based on Required Collection Frequency, in quarter with at least 1 actual sample measurement
36	DV Year Qtr2: Actual Samples	Number of actual sample measurements in quarter.
37	DV Year Qtr2: Scheduled Samples	Number of strata (time intervals), based on Required Collection Frequency, in quarter.
38	DV Year Qtr2: Estimated Exceedances	Computed as per 40 CFR Part 50 Appendix K (Based on number of strata in quarter vs the number of days in quarter)
39	DV Year Qtr2: Exceedance Count	Number of valid daily means greater than the level of the standard.
40	DV Year Qtr3: Valued Strata	Number of strata (time intervals), based on Required Collection Frequency, in quarter with at least 1 actual sample measurement
41	DV Year Qtr3: Actual Samples	Number of actual sample measurements in quarter.
42	DV Year Qtr3: Scheduled Samples	Number of strata (time intervals), based on Required Collection Frequency, in quarter.
43	DV Year Qtr3: Estimated Exceedances	Computed as per 40 CFR Part 50 Appendix K (Based on number of strata in quarter vs the number of days in quarter)
44	DV Year Qtr3: Exceedance Count	Number of valid daily means greater than the level of the standard.
45	DV Year Qtr4: Valued Strata	Number of strata (time intervals), based on Required Collection Frequency, in quarter with at least 1 actual sample measurement
46	DV Year Qtr4: Actual Samples	Number of actual sample measurements in quarter.
47	DV Year Qtr4: Scheduled Samples	Number of strata (time intervals), based on Required Collection Frequency, in quarter.
48	DV Year Qtr4: Estimated Exceedances	Computed as per 40 CFR Part 50 Appendix K (Based on number of strata in quarter vs the number of days in quarter)
49	DV Year Qtr4: Exceedance Count	Number of valid daily means greater than the level of the standard.
50	Year - 1 Qtr1: Valued Strata	Number of strata (time intervals), based on Required Collection Frequency, in quarter with at least 1 actual sample measurement
51	Year - 1 Qtr1: Actual Samples	Number of actual sample measurements in quarter.
52	Year - 1 Qtr1: Scheduled Samples	Number of strata (time intervals), based on Required Collection Frequency, in quarter.
53	Year – 1 Qtr1: Estimated Exceedances	Computed as per 40 CFR Part 50 Appendix K (Based on number of strata in quarter vs the number of days in quarter)
54	Year -1 Qtr1: Exceedance Count	Number of valid daily means greater than the level of the standard.
55	Year - 1 Qtr2: Valued Strata	Number of strata (time intervals), based on Required Collection Frequency, in quarter with at least 1 actual sample measurement
56	Year - 1 Qtr2: Actual Samples	Number of actual sample measurements in quarter.
57	Year - 1 Qtr2: Scheduled Samples	Number of strata (time intervals), based on Required Collection Frequency, in quarter.
58	Year – 1 Qtr2: Estimated Exceedances	Computed as per 40 CFR Part 50 Appendix K (Based on number of strata in quarter vs the number of days in quarter)
59	Year -1 Qtr12 Exceedance Count	Number of valid daily means greater than the level of the standard.
60	Year - 1 Qtr3: Valued Strata	Number of strata (time intervals), based on Required Collection Frequency, in quarter with at least 1 actual sample measurement
61	Year - 1 Qtr3: Actual Samples	Number of actual sample measurements in quarter.
62	Year - 1 Qtr3: Scheduled Samples	Number of strata (time intervals), based on Required Collection Frequency, in quarter.
63	Year – 1 Qtr3: Estimated Exceedances	Computed as per 40 CFR Part 50 Appendix K (Based on number of strata in quarter vs the number of days in quarter)
64	Year - 1 Qtr3: Exceedance Count	Number of valid daily means greater than the level of the standard.
65	Year - 1 Qtr4: Valued Strata	Number of strata (time intervals), based on Required Collection Frequency, in quarter with at least 1 actual sample measurement
66	Year - 1 Qtr4: Actual Samples	Number of actual sample measurements in quarter.
67	Year - 1 Qtr4: Scheduled Samples	Number of strata (time intervals), based on Required Collection Frequency, in quarter.
68	Year – 1 Qtr4: Estimated Exceedances	Computed as per 40 CFR Part 50 Appendix K (Based on number of strata in quarter vs the number of days in quarter)
69	Year - 1 Qtr4: Exceedance Count	Number of valid daily means greater than the level of the standard.
70	Year - 2 Qtr1: Valued Strata	Number of strata (time intervals), based on Required Collection Frequency, in quarter with at least 1 actual sample measurement
71	Year - 2 Qtr1: Actual Samples	Number of actual sample measurements in quarter.
72	Year - 2 Qtr1: Scheduled Samples	Number of strata (time intervals), based on Required Collection Frequency, in quarter.
73	Year – 2 Qtr1: Estimated Exceedances	Computed as per 40 CFR Part 50 Appendix K (Based on number of strata in quarter vs the number of days in quarter)
74	Year - 2 Qtr1: Exceedance Count	Number of valid daily means greater than the level of the standard.
75	Year - 2 Qtr2: Valued Strata	Number of strata (time intervals), based on Required Collection Frequency, in quarter with at least 1 actual sample measurement
76	Year - 2 Qtr2: Actual Samples	Number of actual sample measurements in quarter.
77	Year - 2 Qtr2: Scheduled Samples	Number of strata (time intervals), based on Required Collection Frequency, in quarter.
78	Year – 2 Qtr2: Estimated Exceedances	Computed as per 40 CFR Part 50 Appendix K (Based on number of strata in quarter vs the number of days in quarter)
79	Year - 2 Qtr12 Exceedance Count	Number of valid daily means greater than the level of the standard.
80	Year - 2 Qtr3: Valued Strata	Number of strata (time intervals), based on Required Collection Frequency, in quarter with at least 1 actual sample measurement
81	Year - 2 Qtr3: Actual Samples	Number of actual sample measurements in quarter.
82	Year - 2 Qtr3: Scheduled Samples	Number of strata (time intervals), based on Required Collection Frequency, in quarter.
83	Year – 2 Qtr3: Estimated Exceedances	Computed as per 40 CFR Part 50 Appendix K (Based on number of strata in quarter vs the number of days in quarter)
84	Year - 2 Qtr3: Exceedance Count	Number of valid daily means greater than the level of the standard.
85	Year - 2 Qtr4: Valued Strata	Number of strata (time intervals), based on Required Collection Frequency, in quarter with at least 1 actual sample measurement
86	Year - 2 Qtr4: Actual Samples	Number of actual sample measurements in quarter.
87	Year - 2 Qtr4: Scheduled Samples	Number of strata (time intervals), based on Required Collection Frequency, in quarter.
88	Year – 2 Qtr4: Estimated Exceedances	Computed as per 40 CFR Part 50 Appendix K (Based on number of strata in quarter vs the number of days in quarter)
89	Year - 2 Qtr4: Exceedance Count	Number of valid daily means greater than the level of the standard.

SO2 Format

Position	Element	Definition or Derivation
1	State Code or Tribal Indictor	For state-owned sites, this is the FIPS (Census Bureau) 2 digit code for State. For Tribal sites, this is the string ‘TT’ indicating that it is a tribal site. For Canadian and Mexican sites, this is ‘CC’ or ‘80’ respectively.
2	County Code or Tribal Code	For tribal sites, this is the FIPS 3-digit tribal code. For Non-tribal sites, this is the FIPS 3-digit County Code . For Canada and Mexico , these are AQS assigned 3-digit numbers.
3	Site-Number	AQS assigned number for site, unique to the county or tribe.
4	Parameter Code	AQS Code for Pollutant (SO2=42602)
5	Design Value Year	Year associated with 3 year summaries (last year of 3-year period)
6	Exceptional Data Type	Single digit code indicating how the summary is affected by exceptional events: 0 – No sample measurements were flagged 1 – All flagged measurements are excluded 2 – Flagged measurements not excluded (i.e. all measurements included) 5 – Concurred flagged measurements excluded
7	One-Hour Pollutant Standard,	Unique name associated with NAAQS standard
8	One-Hour Standard Statistic	Name of statistic that is compared to the one hour standard.
9	One-Hour Standard Level	Value of one hour standard
10	Units Code	AQS code of units associated with standard and all statistics
11	Units Name	Text description of Units Code
12	Street Address	Street address of site from SITES table
13	Site Longitude	Longitude of site from SITES table.
14	Site Latitude	Latitude of site from SITES table.
15	Design Value Year: Count of Complete Quarters	Number of quarterly summaries, with the corresponding pollutant standard and exceptional data type, where the summary criterion is met, in the design value year
16	Design Value Year: 99th Percentile	The 99th percentile of the 1 hour SO2 values for the year for the design value year. The calculation of the 99th percentile for SO2 can be found in Appendix T of the 40 CFR 50.
17	Design Value Year: 99th Percentile Completness Indicator.	A Y or N indicating whether there are sufficient observations for the 99th percentile to be marked complete. Appendix T contains the specific requirements for SO2 completeness.
18	Design Value Year: Certification Indicator	Indicator that the reporting agency has certified that the data for the year is complete and correct, and that the EPA agrees (or disagrees) that the cerrtifiction requirements are met..
19	Year 1: Count of Complete Quarters	Number of quarterly summaries, with the corresponding pollutant standard and exceptional data type, where the summary criterion is met, in Year 1, where Year 1 is the year before the design value year (Example: If Design value year is 2012, Year 1 is 2011.
20	Year 1: 99th Percentile	The 99th percentile of the 1 hour SO2 values for the year for Year 1. The calculation of the 99th percentile for SO2 can be found in Appendix T of the 40 CFR 50.
21	Year 1: 99th Percentile Completness Indicator.	A Y or N indicating whether there are sufficient observations for the 99th percentile to be marked complete. Appendix T contains the specific requirements for SO2 completeness.
22	Year 1: Certification Indicator	Indicator that the reporting agency has certified that the data for the year is complete and correct, and that the EPA agrees (or disagrees) that the cerrtifiction requirements are met..
23	Year 2: Count of Complete Quarters	Number of quarterly summaries, with the corresponding pollutant standard and exceptional data type, where the summary criterion is met, in Year 2, where Year 2 is the year before the design value year (Example: If Design value year is 2012, Year 2 is 2010.
24	Year 2: 99th Percentile	The 99th percentile of the 1 hour SO2 values for the year for Year 2. The calculation of the 99th percentile for SO2 can be found in Appendix T of the 40 CFR 50.
25	Year 2: 99th Percentile Completness Indicator.	A Y or N indicating whether there are sufficient observations for the 99th percentile to be marked complete. Appendix T contains the specific requirements for SO2 completeness.
26	Year 2: Certification Indicator	Indicator that the reporting agency has certified that the data for the year is complete and correct, and that the EPA agrees (or disagrees) that the cerrtifiction requirements are met..
27	3 Year Design Value	Average of one hour 99th percentiles for 3 year period.
28	3 Year Design Value Validity Indicator	V Set to ‘Y’ if any of the following are true, set to ‘N’ otherwise: Count of Complete Quarters = 4 for all 3 years The 3-Year 1-Hour Design Value <= the hourly standard and all of the following are true: For each quarter, there are a total of 200 valid days for that quarter in the 3-year period The Percent Days for each quarter in each year >= 50% (i.e. High-Substituted 99th Percentile values are not null) The average of the High-Substituted 99th Percentile values <= the hourly standard The 3-Year 1-Hour Design Value > the hourly standard and at least 75% of the days in each quarter in the three year period have at least one reported hourly value. The 3-Year 1-Hour Design Value > the hourly standard and all of the following are true: For each quarter, there are a total of 200 valid days for that quarter in the 3-year period The average of the Low-Substituted 99th Percentile values > the hourly standard