1. Introduction
This document describes the contents of the pre-generated files that can be downloaded from http://www3.epa.gov/airquality/airdata/ad_data.html.
The file download page contains seven types of files
-
Site Descriptions
-
Monitor Descriptions
-
Annual Summary Data
-
Daily and Daily Summary Data
-
Hourly Data
-
8-Hour Average Data
-
Blanks Data
The contents and formats of these files will be described in turn.
All of this data comes from EPA’s Air Quality System (AQS). Data collection agencies report their data to EPA via this system and it calculates several types of aggregate (summary) data for EPA internal use. This includes daily and annual summaries, but not monthly summaries, as these are not routinely needed by EPA.
All files are comma separated variable (CSV) format that are compressed to save space. Each type of file has different content (columns) that are described in this document.
There are two concepts about how EPA stores data that are useful in understanding the data files: monitors and pollutant standards. These are described in the sections below.
1.1. Monitors
For the purposes of AQS, a monitor does not refer to a specific piece of equipment. Instead, it reflects that a given pollutant (or other parameter) is being measured at a given site.
-
The site (state + county + site number) where the monitor is located AND
-
The pollutant code AND
-
POC – Parameter Occurrence Code. Used to uniquely identify a monitor if there is more than one device measuring the same pollutant at the same site.
For example monitor IDs are usually written in the following way:
SS-CCC-NNNN-PPPPP-Q
where SS
is the State FIPS code, CCC
is the County FIPS code, and NNNN
is the Site Number within the county (leading zeroes are always included for these fields), PPPPP
is the AQS 5-digit parameter code, and Q
is the POC. For example:
01-089-0014-44201-2
is Alabama, Madison County, Site Number 14, ozone monitor, POC 2.
1.2. Pollutant Standards
An important concept to understand in interpreting summary data is that of a "pollutant standard". The national ambient air quality standards (NAAQS, http://www3.epa.gov/ttn/naaqs/criteria.html) all have an averaging time and a form. Furthermore, each pollutant may have several applicable standards based on the date of issuance, the duration of the sample, and a primary or secondary standard.
When comparing data to a NAAQS, EPA must aggregate the data according to the rules of the applicable pollutant standard. In order to do this, we must summarize the same data various ways. So the annual and daily summary files will (possibly) contain multiple records that have been calculated using different rules and starting metrics. These are differentiated by the Pollutant Standard. (The Annual Summary file also contains a Metric Used column indicating the metric reflected in the summary calculations.)
For an example of metric, consider ozone. Its standard form is the "annual fourth-highest daily maximum 8-hr concentration". So we first calculated 8-hour averages. Then we calculate the daily maximum of these 8-hour averages. Then, in the annual summary record, all metrics (mean, maxes, percentiles) are based on the daily maximum 8-hour average, not the individual sample values.
1.3. Changes Since Last Version
Changes implemented in December 2015 update.
-
Additional parameters added to VOC list; all VOC files regenerated.
-
Site and Monitor description formats added.
-
Minor editorial changes.
Changes implemented in June 2015 update (All files were regenerated to include the new columns).
-
Annual Summary - Completeness Indicator added as column #19.
-
Daily Summary - Method Code added as column #21.
-
Hourly Data - Method Code added as column #20.
2. Site Description File
2.1. Content
Each unique geographic location that contains monitors is called a "site" in AQS. Information about the geographic setting is store in the site record, which are presented here. A unique site is identified by the combination of state code, county code, and site number (within county). It can also be identified by the latitude and longitude.
2.2. Format
The file is comma separated variables (CSV) with a header row.
Field Position | Field Name | Description |
---|---|---|
1 |
State Code |
The FIPS code of the state in which the monitor resides. |
2 |
County Code |
The FIPS code of the county in which the monitor resides. |
3 |
Site Number |
A unique number within the county identifying the site. |
4 |
Latitude |
The monitoring site’s angular distance north of the equator measured in decimal degrees. |
5 |
Longitude |
The monitoring site’s angular distance east of the prime meridian measured in decimal degrees. |
6 |
Datum |
The Datum associated with the Latitude and Longitude measures. |
7 |
Elevation |
The elevation of the ground at the site in meters above mean sea level. |
8 |
Land Use |
A category describing the predominant land use within a 1/4 mile radius of the site. |
9 |
Location Setting |
A description of the setting within which the monitoring site is located. E.g., rural, urban, etc. |
10 |
Site Established Date |
The date when the site began operating. |
11 |
Site Closed Date |
The date on which the operating agency indicated that all operations ceased at this site. |
12 |
Met Site State Code |
Where sites are required to collect meteorological data, they may be able to list a surrogate site from where the meteorological data will be used. If a "met" site is listed this contains the AQS State Code identifier for that site. |
13 |
Met Site County Code |
Where sites are required to collect meteorological data, they may be able to list a surrogate site from where the meteorological data will be used. If a "met" site is listed this contains the AQS County Code identifier for that site. |
14 |
Met Site Site Number |
Where sites are required to collect meteorological data, they may be able to list a surrogate site from where the meteorological data will be used. If a "met" site is listed this contains the AQS Site Number for that site. |
15 |
Met Site Type |
Where sites are required to collect meteorological data, they may be able to list a surrogate site from where the meteorological data will be used. If a "met" site is listed this contains the type of surrogate site. E.g., AQS site, National Weather Service site, etc. |
16 |
Met Site Distance |
Where sites are required to collect meteorological data, they may be able to list a surrogate site from where the meteorological data will be used. If a "met" site is listed this contains the distance from this site to the met site in meters. |
17 |
Met Site Direction |
Where sites are required to collect meteorological data, they may be able to list a surrogate site from where the meteorological data will be used. If a "met" site is listed this contains the direction from this site to the met site (true, not magnetic, direction). |
18 |
GMT Offset |
The time difference (in hours) between local standard time at this site and GMT. |
19 |
Owning Agency |
The name of the agency that owns or controls the land at the site. |
20 |
Local Site Name |
The name of the site (if any) given by the State, local, or tribal air pollution control agency that operates it. |
21 |
Address |
The approximate street address of the monitoring site. |
22 |
Zip Code |
The postal zip code in which the monitoring site resides. |
23 |
State Name |
The name of the state where the monitoring site is located. |
24 |
County Name |
The name of the county where the monitoring site is located. |
25 |
City Name |
The name of the city where the monitoring site is located. This represents the legal incorporated boundaries of cities and not urban areas. |
26 |
CBSA Name |
The name of the core bases statistical area (metropolitan area) where the monitoring site is located. |
27 |
Tribe Name |
If this site resides on tribal lands and the tribe has chosen to identify the site with tribal identifiers, this is the name of the tribe that owns the site. |
28 |
Extraction Date |
The date on which this data was retrieved from the AQS Data Mart. This does not mean that all data is valid as of this date. Once site information is entered by the owning agency, it may not be updated as values change (e.g., location setting evolves from urban to suburban). |
3. Monitor Description File
3.1. Content
Each parameter that is measured at a site is considered a "monitor" in AQS. (So a "monitor" does not necessarily correspond to a physical instrument/sampler.) AQS tracks administrative information about monitors including who operates them, the methods being used, the networks they belong to, etc. That information is available in this file. A unique monitor is identified by the combination of state code, county code, site number (within county), parameter code, and parameter occurrence code ("POC", used to differentiate when a parameter is measured more than once at a site).
3.2. Format
The file is comma separated variables (CSV) with a header row.
Field Position | Field Name | Description |
---|---|---|
1 |
State Code |
The FIPS code of the state in which the monitor resides. |
2 |
County Code |
The FIPS code of the county in which the monitor resides. |
3 |
Site Number |
A unique number within the county identifying the site. |
4 |
Parameter Code |
The AQS code corresponding to the parameter measured by the monitor. |
5 |
Parameter Name |
The name or description assigned in AQS to the parameter measured by the monitor. Parameters may be pollutants or non-pollutants. |
6 |
POC |
This is the “Parameter Occurrence Code” used to distinguish different instruments that measure the same parameter at the same site. |
7 |
Latitude |
The monitoring site’s angular distance north of the equator measured in decimal degrees. |
8 |
Longitude |
The monitoring site’s angular distance east of the prime meridian measured in decimal degrees. |
9 |
Datum |
The Datum associated with the Latitude and Longitude measures. |
10 |
First Year of Data |
The year in which the earliest sample from this site is available in AQS. |
11 |
Last Sample Date |
The date on which the most recent sample from this site is available in AQS. This is often the best way to determine if a monitor is still operating. Note that the reporting deadlines to AQS are generally lengthy - about 6 months for most parameters. |
12 |
Monitor Type |
An administrative or regulatory classification for the monitor. |
13 |
Networks |
A list of the monitoring networks (groups of monitors with common goals and procedures) to which the monitor belongs. If the monitor belongs to more than one network, the names will be separated with semicolons. |
14 |
Reporting Agency |
The name of the agency responsible for reporting data to AQS. |
15 |
PQAO |
The name of the Primary Quality Assurance Organization for the monitor. Monitors of the same parameter belonging to the same PQAO must meet aggregate quality assurance requirements. |
16 |
Collecting Agency |
The name of the agency responsible for collecting data from the monitor. |
17 |
Exclusions |
If the agency operating the monitor has requested that data from this monitor be excluded from NAAQS calculations and the governing EPA regional office has agreed, the NAAQS standard(s) and the years of exclusion are listed. |
18 |
Monitoring Objective |
Identification of the reason for measuring air quality by the monitor. |
19 |
Last Method Code |
A three digit code representing the measurement method used by the monitor for its most recent sample (methods can change, but often do not). A method code is only unique within a parameter (that is, method 111 for ozone is not the same as method 111 for benzene). |
20 |
Last Method |
The full description of the measurement method used by the monitor for its most recent sample (methods can change, but often do not). |
21 |
NAAQS Primary Monitor |
A flag indicating if this monitor is part of a collocated set of monitors at the site and it is the primary data source for NAAQS data comparisons. |
22 |
QA Primary Monitor |
A flag indicating if this monitor is part of a collocated set of monitors at the site and it is the primary monitor for making quality assurance comparisons. |
23 |
Local Site Name |
The name of the site (if any) given by the State, local, or tribal air pollution control agency that operates it. |
24 |
Address |
The approximate street address of the monitoring site. |
25 |
State Name |
The name of the state where the monitoring site is located. |
26 |
County Name |
The name of the county where the monitoring site is located. |
27 |
City Name |
The name of the city where the monitoring site is located. This represents the legal incorporated boundaries of cities and not urban areas. |
28 |
CBSA Name |
The name of the core bases statistical area (metropolitan area) where the monitoring site is located. |
29 |
Tribe Name |
If this monitor resides on tribal lands and the tribe has chosen to identify the site with tribal identifiers, this is the name of the tribe that owns the site. |
30 |
Extraction Date |
The date on which this data was retrieved from the AQS Data Mart. This does not mean that all data is valid as of this date. Once monitor information is entered by the reporting agency, it may not be updated as values change (e.g., location setting evolves from urban to suburban). |
4. Annual Summary Files
4.1. Content
Each annual summary file contains data for every monitor (sampled parameter) in our database for the year. These files are relatively small and did not warrant being broken down by parameter, etc.
The annual summary files contain (at least) one record for each monitor that reported data for the given year. There will be multiple records for the monitor if:
-
There are calculated sample durations for the pollutant. For example, PM2.5 is sometimes reported as 1-hour samples and EPA calculates 24-hour averages.
-
There are multiple standards for the pollutant (q.v. pollutant standards).
-
There were exceptional events associated with some measurements that the monitoring agency has or may request be excluded from comparison to the standard.
4.2. Format
The file is comma separated variables (CSV) with a header row.
Field Position | Field Name | Description |
---|---|---|
1 |
State Code |
The FIPS code of the state in which the monitor resides. |
2 |
County Code |
The FIPS code of the county in which the monitor resides. |
3 |
Site Num |
A unique number within the county identifying the site. |
4 |
Parameter Code |
The AQS code corresponding to the parameter measured by the monitor. |
5 |
POC |
This is the “Parameter Occurrence Code” used to distinguish different instruments that measure the same parameter at the same site. |
6 |
Latitude |
The monitoring site’s angular distance north of the equator measured in decimal degrees. |
7 |
Longitude |
The monitoring site’s angular distance east of the prime meridian measured in decimal degrees. |
8 |
Datum |
The Datum associated with the Latitude and Longitude measures. |
9 |
Parameter Name |
The name or description assigned in AQS to the parameter measured by the monitor. Parameters may be pollutants or non-pollutants. |
10 |
Sample Duration |
The length of time that air passes through the monitoring device before it is analyzed (measured). So, it represents an averaging period in the atmosphere (for example, a 24-hour sample duration draws ambient air over a collection filter for 24 straight hours). For continuous monitors, it can represent an averaging time of many samples (for example, a 1-hour value may be the average of four one-minute samples collected during each quarter of the hour). |
11 |
Pollutant Standard |
A description of the ambient air quality standard rules used to aggregate statistics. (See description at beginning of document.) |
12 |
Metric Used |
The base metric used in the calculation of the aggregate statistics presented in the remainder of the row. For example, if this is Daily Maximum, then the value in the Mean column is the mean of the daily maximums. |
13 |
Method Name |
A short description of the processes, equipment, and protocols used in gathering and measuring the sample. |
14 |
Year |
The year the annual summary data represents. |
15 |
Units of Measure |
The unit of measure for the parameter. QAD always returns data in the standard units for the parameter. Submitters are allowed to report data in any unit and EPA converts to a standard unit so that we may use the data in calculations. |
16 |
Event Type |
Indicates whether data measured during exceptional events are included in the summary. A wildfire is an example of an exceptional event; it is something that affects air quality, but the local agency has no control over. No Events means no events occurred. Events Included means events occurred and the data from them is included in the summary. Events Excluded means that events occurred but data form them is excluded from the summary. Concurred Events Excluded means that events occurred but only EPA concurred exclusions are removed from the summary. If an event occurred for the parameter in question, the data will have multiple records for each monitor. |
17 |
Observation Count |
The number of observations (samples) taken during the year. |
18 |
Observation Percent |
The percent representing the number of observations taken with respect to the number scheduled to be taken during the year. This is only calculated for monitors where measurements are required (e.g., only certain parameters). |
19 |
Completeness Indicator |
An indication of whether the regulatory data completeness criteria for valid summary data have been met by the monitor for the year. Y means yes, N means no or that there are no regulatory completeness criteria for the parameter. |
20 |
Valid Day Count |
The number of days during the year where the daily monitoring criteria were met, if the calculation of the summaries is based on valid days. |
21 |
Required Day Count |
The number of days during the year which the monitor was scheduled to take samples if measurements are required. |
22 |
Exceptional Data Count |
The number of data points in the annual data set affected by exceptional air quality events (things outside the norm that affect air quality). |
23 |
Null Data Count |
The count of scheduled samples when no data was collected and the reason for no data was reported. |
24 |
Primary Exceedance Count |
The number of samples during the year that exceeded the primary air quality standard. |
25 |
Secondary Exceedance Count |
The number of samples during the year that exceeded the secondary air quality standard. |
26 |
Certification Indicator |
An indication whether the completeness and accuracy of the information on the annual summary record has been certified by the submitter. Certified means the submitter has certified the data (due May 01 the year after collection). Certification not required means that the parameter does not require certification or the deadline has not yet passed. Uncertified (past due) means that certification is required but is overdue. Requested but not yet concurred means the submitter has completed the process, but EPA has not yet acted to certify the data. Requested but denied means the submitter has completed the process, but EPA has denied the request for cause. Was certified but data changed means the data was certified but data was replaced and the process has not been repeated. |
27 |
Num Obs Below MDL |
The number of samples reported during the year that were below the method detection limit (MDL) for the monitoring instrument. Sometimes these values are replaced by 1/2 the MDL in summary calculations. |
28 |
Arithmetic Mean |
The average (arithmetic mean) value for the year. |
29 |
Arithmetic Standard Dev |
The standard deviation about the mean of the values for the year. |
30 |
1st Max Value |
The highest value for the year. |
31 |
1st Max DateTime |
The date and time (on a 24-hour clock) when the highest value for the year (the previous field) was taken. |
32 |
2nd Max Value |
The second highest value for the year. |
33 |
2nd Max DateTime |
The date and time (on a 24-hour clock) when the second highest value for the year (the previous field) was taken. |
34 |
3rd Max Value |
The third highest value for the year. |
35 |
3rd Max DateTime |
The date and time (on a 24-hour clock) when the third highest value for the year (the previous field) was taken. |
36 |
4th Max Value |
The fourth highest value for the year. |
37 |
4th Max DateTime |
The date and time (on a 24-hour clock) when the fourth highest value for the year (the previous field) was taken. |
38 |
1st Max Non Overlapping Value |
For 8-hour CO averages, the highest value of the year. |
39 |
1st NO Max DateTime |
The date and time (on a 24-hour clock) when the first maximum non overlapping value for the year (the previous field) was taken. |
40 |
2nd Max Non Overlapping Value |
For 8-hour CO averages, the second highest value of the year that does not share any hours with the 8-hour period of the first max non overlapping value. |
41 |
2nd NO Max DateTime |
The date and time (on a 24-hour clock) when the second maximum non overlapping value for the year (the previous field) was taken. |
42 |
99th Percentile |
The value from this monitor for which 99 per cent of the rest of the measured values for the year are equal to or less than. |
43 |
98th Percentile |
The value from this monitor for which 98 per cent of the rest of the measured values for the year are equal to or less than. |
44 |
95th Percentile |
The value from this monitor for which 95 per cent of the rest of the measured values for the year are equal to or less than. |
45 |
90th Percentile |
The value from this monitor for which 90 per cent of the rest of the measured values for the year are equal to or less than. |
46 |
75th Percentile |
The value from this monitor for which 75 per cent of the rest of the measured values for the year are equal to or less than. |
47 |
50th Percentile |
The value from this monitor for which 50 per cent of the rest of the measured values for the year are equal to or less than (i.e., the median). |
48 |
10th Percentile |
The value from this monitor for which 10 per cent of the rest of the measured values for the year are equal to or less than. |
49 |
Local Site Name |
The name of the site (if any) given by the State, local, or tribal air pollution control agency that operates it. |
50 |
Address |
The approximate street address of the monitoring site. |
51 |
State Name |
The name of the state where the monitoring site is located. |
52 |
County Name |
The name of the county where the monitoring site is located. |
53 |
City Name |
The name of the city where the monitoring site is located. This represents the legal incorporated boundaries of cities and not urban areas. |
54 |
CBSA Name |
The name of the core bases statistical area (metropolitan area) where the monitoring site is located. |
55 |
Date of Last Change |
The date the last time any numeric values in this record were updated in the AQS data system. |
5. Daily Summary Files
5.1. Content
Each daily summary file contains data for every monitor (sampled parameter) in our database for each day. These files are separated by parameter (or parameter group) to make the sizes more manageable.
This file will contain a daily summary record that is:
1) The aggregate of all sub-daily measurements taken at the monitor.
2) The single sample value if the monitor takes a single, daily sample (e.g., there is only one sample with a 24-hour duration). In this case, the mean and max daily sample will have the same value.
The daily summary files contain (at least) one record for each monitor that reported data for the given day. There may be multiple records for the monitor if:
-
There are calculated sample durations for the pollutant. For example, PM2.5 is sometimes reported as 1-hour samples and EPA calculates 24-hour averages.
-
There are multiple standards for the pollutant (q.v. pollutant standards).
-
There were exceptional events associated with some measurements that the monitoring agency has or may request be excluded from comparison to the standard.
5.2. Format
The file is comma separated variables (CSV) with a header row.
Field Position | Field Name | Description |
---|---|---|
1 |
State Code |
The FIPS code of the state in which the monitor resides. |
2 |
County Code |
The FIPS code of the county in which the monitor resides. |
3 |
Site Num |
A unique number within the county identifying the site. |
4 |
Parameter Code |
The AQS code corresponding to the parameter measured by the monitor. |
5 |
POC |
This is the “Parameter Occurrence Code” used to distinguish different instruments that measure the same parameter at the same site. |
6 |
Latitude |
The monitoring site’s angular distance north of the equator measured in decimal degrees. |
7 |
Longitude |
The monitoring site’s angular distance east of the prime meridian measured in decimal degrees. |
8 |
Datum |
The Datum associated with the Latitude and Longitude measures. |
9 |
Parameter Name |
The name or description assigned in AQS to the parameter measured by the monitor. Parameters may be pollutants or non-pollutants. |
10 |
Sample Duration |
The length of time that air passes through the monitoring device before it is analyzed (measured). So, it represents an averaging period in the atmosphere (for example, a 24-hour sample duration draws ambient air over a collection filter for 24 straight hours). For continuous monitors, it can represent an averaging time of many samples (for example, a 1-hour value may be the average of four one-minute samples collected during each quarter of the hour). |
11 |
Pollutant Standard |
A description of the ambient air quality standard rules used to aggregate statistics. (See description at beginning of document.) |
12 |
Date Local |
The calendar date for the summary. All daily summaries are for the local standard day (midnight to midnight) at the monitor. |
13 |
Units of Measure |
The unit of measure for the parameter. QAD always returns data in the standard units for the parameter. Submitters are allowed to report data in any unit and EPA converts to a standard unit so that we may use the data in calculations. |
14 |
Event Type |
Indicates whether data measured during exceptional events are included in the summary. A wildfire is an example of an exceptional event; it is something that affects air quality, but the local agency has no control over. No Events means no events occurred. Events Included means events occurred and the data from them is included in the summary. Events Excluded means that events occurred but data form them is excluded from the summary. Concurred Events Excluded means that events occurred but only EPA concurred exclusions are removed from the summary. If an event occurred for the parameter in question, the data will have multiple records for each monitor. |
15 |
Observation Count |
The number of observations (samples) taken during the day. |
16 |
Observation Percent |
The percent representing the number of observations taken with respect to the number scheduled to be taken during the day. This is only calculated for monitors where measurements are required (e.g., only certain parameters). |
17 |
Arithmetic Mean |
The average (arithmetic mean) value for the day. |
18 |
1st Max Value |
The highest value for the day. |
19 |
1st Max Hour |
The hour (on a 24-hour clock) when the highest value for the day (the previous field) was taken. |
20 |
AQI |
The Air Quality Index for the day for the pollutant, if applicable. |
21 |
Method Code |
An internal system code indicating the method (processes, equipment, and protocols) used in gathering and measuring the sample. The method name is in the next column. |
22 |
Method Name |
A short description of the processes, equipment, and protocols used in gathering and measuring the sample. |
23 |
Local Site Name |
The name of the site (if any) given by the State, local, or tribal air pollution control agency that operates it. |
24 |
Address |
The approximate street address of the monitoring site. |
25 |
State Name |
The name of the state where the monitoring site is located. |
26 |
County Name |
The name of the county where the monitoring site is located. |
27 |
City Name |
The name of the city where the monitoring site is located. This represents the legal incorporated boundaries of cities and not urban areas. |
28 |
CBSA Name |
The name of the core bases statistical area (metropolitan area) where the monitoring site is located. |
29 |
Date of Last Change |
The date the last time any numeric values in this record were updated in the AQS data system. |
6. Hourly Data Files
6.1. Content
These files contain the hourly data (sometimes called measurements, samples, etc). These files are separated by parameter (or parameter group) to make the sizes more manageable.
EPA does get sample data reported at durations other than hourly. For example, some SO2 is reported as 5-minute samples and some toxic substances are reported as 3-hour samples (and most PM speciation data is reported as 24-hour samples). These samples have not been included in these hourly files but their aggregates are included in the daily files, and the sample data is available on request.
If a particular file is empty (record count = 0) that means that no hourly data was collected for that parameter or group.
To keep the size of the raw data files smaller, less geographic descriptive information has been included. If you need the Local Site Name, CBSA, etc. you can find that in the Annual Summary file for the same monitor.
6.2. Format
The file is comma separated variables (CSV) with a header row.
Field Position | Field Name | Description |
---|---|---|
1 |
State Code |
The FIPS code of the state in which the monitor resides. |
2 |
County Code |
The FIPS code of the county in which the monitor resides. |
3 |
Site Num |
A unique number within the county identifying the site. |
4 |
Parameter Code |
The AQS code corresponding to the parameter measured by the monitor. |
5 |
POC |
This is the “Parameter Occurrence Code” used to distinguish different instruments that measure the same parameter at the same site. |
6 |
Latitude |
The monitoring site’s angular distance north of the equator measured in decimal degrees. |
7 |
Longitude |
The monitoring site’s angular distance east of the prime meridian measured in decimal degrees. |
8 |
Datum |
The Datum associated with the Latitude and Longitude measures. |
9 |
Parameter Name |
The name or description assigned in AQS to the parameter measured by the monitor. Parameters may be pollutants or non-pollutants. |
10 |
Date Local |
The calendar date of the sample in Local Standard Time at the monitor. |
11 |
Time Local |
The time of day that sampling began on a 24-hour clock in Local Standard Time. |
12 |
Date GMT |
The calendar date of the sample in Greenwich Mean Time. |
13 |
Time GMT |
The time of day that sampling began on a 24-hour clock in Greenwich Mean Time. |
14 |
Sample Measurement |
The measured value in the standard units of measure for the parameter. |
15 |
Units of Measure |
The unit of measure for the parameter. QAD always returns data in the standard units for the parameter. Submitters are allowed to report data in any unit and EPA converts to a standard unit so that we may use the data in calculations. |
16 |
MDL |
The Method Detection Limit. The minimum sample concentration detectable for the monitor and method. Note: if samples are reported below this level, they may have been replaced by 1/2 the MDL. |
17 |
Uncertainty |
The total measurement uncertainty associated with a reported measurement as indicated by the reporting agency. |
18 |
Qualifier |
Sample values may have qualifiers that indicate why they are missing or that they are out of the ordinary. Types of qualifiers are: null data, exceptional event, natural events, and quality assurance. The highest ranking qualifier, if any, is described in this field. |
19 |
Method Type |
An indication of whether the method used to collect the data is a federal reference method (FRM), equivalent to a federal reference method, an approved regional method, or none of the above (non-federal reference method). |
20 |
Method Code |
An internal system code indicating the method (processes, equipment, and protocols) used in gathering and measuring the sample. The method name is in the next column. |
21 |
Method Name |
A short description of the processes, equipment, and protocols used in gathering and measuring the sample. |
22 |
State Name |
The name of the state where the monitoring site is located. |
23 |
County Name |
The name of the county where the monitoring site is located. |
24 |
Date of Last Change |
The date the last time any numeric values in this record were updated in the AQS data system. |
7. 8-Hour Average Files
7.1. Content
Ozone and CO have NAAQS in the form of an 8-hour average. (Note that the ozone time stamp is at the begin hour of an 8-hour period and CO is at the end hour.) For convenience, we are posting the EPA calculated 8-hour averages.
These files are also at the monitor level. An 8-hour average is calculated for every clock hour. Only complete data (e.g., with 6 or more valid hourly samples in the 8 hour block, or 75% completeness) is included in these files.
7.2. Format
The file is comma separated variables (CSV) with a header row.
Field Position | Field Name | Description |
---|---|---|
1 |
State Code |
The FIPS code of the state in which the monitor resides. |
2 |
County Code |
The FIPS code of the county in which the monitor resides. |
3 |
Site Num |
A unique number within the county identifying the site. |
4 |
Parameter Code |
The AQS code corresponding to the parameter measured by the monitor. |
5 |
POC |
This is the “Parameter Occurrence Code” used to distinguish different instruments that measure the same parameter at the same site. |
6 |
Latitude |
The monitoring site’s angular distance north of the equator measured in decimal degrees. |
7 |
Longitude |
The monitoring site’s angular distance east of the prime meridian measured in decimal degrees. |
8 |
Datum |
The Datum associated with the Latitude and Longitude measures. |
9 |
Parameter Name |
The name or description assigned in AQS to the parameter measured by the monitor. Parameters may be pollutants or non-pollutants. |
10 |
Date Local |
The calendar date of the average in Local Standard Time at the monitor. |
11 |
Time Local |
The time of day for the average on a 24-hour clock in Local Standard Time. |
12 |
Date GMT |
The calendar date of the average in Greenwich Mean Time. |
13 |
Time GMT |
The time of day for the average on a 24-hour clock in Greenwich Mean Time. |
14 |
Sample Duration |
The averaging period. Will always be 8-hours for these files, but the fact that the ozone time stamp is at the begin hour of an 8-hour period and CO is at the end hour is reiterated. |
15 |
Pollutant Standard |
A description of the ambient air quality standard rules used to aggregate statistics. (See description at beginning of document.) |
16 |
Units of Measure |
The unit of measure for the parameter. QAD always returns data in the standard units for the parameter. Submitters are allowed to report data in any unit and EPA converts to a standard unit so that we may use the data in calculations. |
17 |
Observation Count |
The total number of observations (samples) taken during the 8-hour period. |
18 |
Observations with Events |
The number of observations (samples) during the 8-hour period that were flagged by the data submitter as having been affected by an exceptional event. |
19 |
Null Observations |
The number of observations (samples) during the 8-hour period that were missed (and reported as Null by the data submitter). |
20 |
Mean Including All Data |
The average (arithmetic mean) value including all data reported in the 8-hour block. |
21 |
Mean Excluding All Flagged Data |
The average (arithmetic mean) value excluding all data flagged by the data submitter as having been affected by an exceptional event. |
22 |
Mean Excluding All Concurred Flags |
The average (arithmetic mean) value excluding data flagged by the data submitter as having been affected by an exceptional event and that the EPA has concurred should be excluded from NAAQS calculations. |
23 |
Date of Last Change |
The date the last time any numeric values in this record were updated in the AQS data system. |
8. Blanks Data Files
8.1. Content
These files contain the field, trip, and lab blanks measurements. Blanks are collection media that are not used to collect sample data but are analyzed to determine possible contamination paths and levels in normal samples.
8.2. Format
The file is comma separated variables (CSV) with a header row.
Field Position | Field Name | Description |
---|---|---|
1 |
State Code |
The FIPS code of the state in which the monitor resides. |
2 |
County Code |
The FIPS code of the county in which the monitor resides. |
3 |
Site Num |
A unique number within the county identifying the site. |
4 |
Parameter Code |
The AQS code corresponding to the parameter measured by the monitor. |
5 |
POC |
This is the “Parameter Occurrence Code” used to distinguish different instruments that measure the same parameter at the same site. |
6 |
Latitude |
The monitoring site’s angular distance north of the equator measured in decimal degrees. |
7 |
Longitude |
The monitoring site’s angular distance east of the prime meridian measured in decimal degrees. |
8 |
Datum |
The Datum associated with the Latitude and Longitude measures. |
9 |
Parameter Name |
The name or description assigned in AQS to the parameter measured by the monitor. Parameters may be pollutants or non-pollutants. |
10 |
Blanks Type |
The type of blank analyzed. |
11 |
Date Local |
The calendar date the blank was exposed in Local Standard Time at the monitor. |
12 |
Time Local |
The time of day the blank was exposed on a 24-hour clock in Local Standard Time. |
13 |
Sample Measurement |
The measured value in the standard units of measure for the parameter. |
14 |
Units of Measure |
The unit of measure for the parameter. QAD always returns data in the standard units for the parameter. Submitters are allowed to report data in any unit and EPA converts to a standard unit so that we may use the data in calculations. |
15 |
Duration |
The length of time the blank was exposed. |
16 |
MDL |
The Method Detection Limit. The minimum sample concentration detectable for the monitor and method. Note: if samples are reported below this level, they may have been replaced by 1/2 the MDL. |
17 |
Uncertainty |
The total measurement uncertainty associated with a reported measurement as indicated by the reporting agency. |
18 |
Method Type |
An indication of whether the method used to collect the data is a federal reference method (FRM), equivalent to a federal reference method, an approved regional method, or none of the above (non-federal reference method). |
19 |
Method Name |
A short description of the processes, equipment, and protocols used in gathering and measuring the sample. |
20 |
State Name |
The name of the state where the monitoring site is located. |
21 |
County Name |
The name of the county where the monitoring site is located. |
22 |
Date of Last Change |
The date the last time any numeric values in this record were updated in the AQS data system. |
23 |
Qualifier 1 |
Sample values may have qualifiers that indicate why they are missing or that they are out of the ordinary. Types of qualifiers are: null data, exceptional event, natural events, and quality assurance. The highest ranking qualifier, if any, is described in this field. |
24 |
Qualifier 2 |
The second qualifier affecting this sample, if any, is described in this field. |
25 |
Qualifier 3 |
The third qualifier affecting this sample, if any, is described in this field. |
26 |
Qualifier 4 |
The fourth qualifier affecting this sample, if any, is described in this field. |
27 |
Qualifier 5 |
The fifth qualifier affecting this sample, if any, is described in this field. |
28 |
Qualifier 6 |
The sixth qualifier affecting this sample, if any, is described in this field. |
29 |
Qualifier 7 |
The seventh qualifier affecting this sample, if any, is described in this field. |
30 |
Qualifier 8 |
The eighth qualifier affecting this sample, if any, is described in this field. |
21 |
Qualifier 9 |
The ninth qualifier affecting this sample, if any, is described in this field. |
32 |
Qualifier 10 |
The tenth qualifier affecting this sample, if any, is described in this field. |