The AQI workfile is a fixed field length text file
|
Start Position |
Field Length |
Field Name |
Note |
|
| |||
|
1 |
2 |
State Code |
Populated only if grouping by State, State – City, or State - County |
|
3 |
3 |
County Code |
Populated only if grouping by State – County |
|
6 |
5 |
City Code |
Populated only if grouping by State – City |
|
11 |
4 |
UAR Code |
Populated only if grouping by Urban Area |
|
15 |
4 |
MSA Code |
Populated only if grouping by MSA |
|
19 |
8 |
AQI Date |
In YYYYMMDD Format |
|
27 |
5 |
AQI Value 1 |
Highest AQI Value for the day |
|
32 |
5 |
Parameter Code 1 |
Parameter associated with the highest value for the day |
|
37 |
1 |
Duration Code 1 |
Duration associated with the highest value for the day. |
|
38 |
30 |
AQI Category |
Category of the highest value for the day. |
|
68 |
9 |
Max AQI Site Id 1 |
Site where the maximum value occurred. SSCCCTTTT format where "SS’ is a 2-digit state code, "CCC" is a 3-digit county code and TTTT is the 4-digit Site ID. |
|
77 |
5 |
Number of AQI Sites 1 |
Number of distinct sites that attempted to acquire an AQI value for the parameter - day |
|
82 |
5 |
AQI Value 2 |
2nd Highest AQI Value for the day |
|
87 |
5 |
Parameter Code 2 |
Parameter associated with the 2nd highest value for the day |
|
92 |
1 |
Duration Code 2 |
Duration associated with the 2nd highest value for the day. |
|
93 |
9 |
Max AQI Site Id 2 |
Site where the 2nd highest value occurred. SSCCCTTTT format where "SS’ is a 2-digit state code, "CCC" is a 3-digit county code and TTTT is the 4-digit Site ID. |
|
102 |
5 |
Number of AQI Sites 2 |
Number of distinct sites that attempted to acquire an AQI value for the parameter - day |
|
107 |
5 |
AQI Value 3 |
3rd Highest AQI Value for the day |
|
112 |
5 |
Parameter Code 3 |
Parameter associated with the 3rd highest value for the day |
|
117 |
1 |
Duration Code 3 |
Duration associated with the 3rd highest value for the day. |
|
118 |
9 |
Max AQI Site Id 3 |
Site where the 3rd highest value occurred. SSCCCTTTT format where "SS’ is a 2-digit state code, "CCC" is a 3-digit county code and TTTT is the 4-digit Site ID. |
|
127 |
5 |
Number of AQI Sites 3 |
Number of distinct sites that attempted to acquire an AQI value for the parameter - day |
|
132 |
5 |
AQI Value 4 |
4th Highest AQI Value for the day |
|
137 |
5 |
Parameter Code 4 |
Parameter associated with the 4th highest value for the day |
|
142 |
1 |
Duration Code 4 |
Duration associated with the 4th highest value for the day. |
|
143 |
9 |
Max AQI Site Id 4 |
Site where the 4th highest value occurred. SSCCCTTTT format where "SS’ is a 2-digit state code, "CCC" is a 3-digit county code and TTTT is the 4-digit Site ID. |
|
152 |
5 |
Number of AQI Sites 4 |
Number of distinct sites that attempted to acquire an AQI value for the parameter - day |
|
157 |
5 |
AQI Value 5 |
5th Highest AQI Value for the day |
|
162 |
5 |
Parameter Code 5 |
Parameter associated with the 5th highest value for the day |
|
167 |
1 |
Duration Code 5 |
Duration associated with the 5th highest value for the day. |
|
168 |
9 |
Max AQI Site Id 5 |
Site where the 5th highest value occurred. SSCCCTTTT format where "SS’ is a 2-digit state code, "CCC" is a 3-digit county code and TTTT is the 4-digit Site ID. |
|
177 |
5 |
Number of AQI Sites 5 |
Number of distinct sites that attempted to acquire an AQI value for the parameter – day |
|
182 |
5 |
AQI Value 6 |
6th Highest AQI Value for the day |
|
187 |
5 |
Parameter Code 6 |
Parameter associated with the 6th highest value for the day |
|
192 |
1 |
Duration Code 6 |
Duration associated with the 6th highest value for the day. |
|
193 |
9 |
Max AQI Site Id 6 |
Site where the 6th highest value occurred. SSCCCTTTT format where "SS’ is a 2-digit state code, "CCC" is a 3-digit county code and TTTT is the 4-digit Site ID. |
|
202 |
5 |
Number of AQI Sites 6 |
Number of distinct sites that attempted to acquire an AQI value for the parameter – day |