ARIP Standard Reports

This topic contains a number of "standard reports", types of searches that are often done on ARIP data. The searches include:

Area
Selects a report that will give data on all facilities in a geographic area, such as a state, city, or county.
Example: You want to know about all facilities in College Park, MD.
Facility
Facility: Selects a report that will give you data on a particular facility.
Example: You are interested in the Rhone Poulenc plant in your town.
Chemical
Industry: Select a report that will give data on all facilities with accidents involving a particular chemical.
Example: You want to know about all facilities releasing chlorine.

If you have any questions, comments, or found any bugs in these reports please either send RTK NET mail to Rich Puchalsky or call us at 202-234-8494. We may also by able to assist you with more complex reports as long as you give us at least one week of lead time.

Area Search

Area reports are intended to help you find out about all facilities within a geographic area - a zip code, city, county, or state. A state must be entered; in addition, none or many of the zip code, city, and county fields can be chosen in each search.

Facility Search

Facility/discharger reports are intended to help you find information about a single facility or group of facilities, over one or more years. You can select a single facility by specifying its name. Specifying its city and state may also help. You can find a group of facilities owned by a parent company by filling in the owner name field, or all facilities in an industry by flling in the SIC code field.

Chemical Search

A Chemical report will let you specify a chemical name or CAS number. The chemical that you specify will be found whether it is the first or second chemical reporting in an ARIP incident.

City and County Fields

Fill in the name of the county or city that you want - do not fill in the word "county" after counties. Some submissions have their county or city misspelled; others have two varient spellings for the same city or county. For instance, the city of St. Louis can be spelled either ST. LOUIS or SAINT LOUIS. If you think this may be a factor, you can either run your search twice or use "*" to represent any characters. In the case above you could enter "S*LOUIS" and find both spellings. Watch out for FORT/FT., SAINT/ST., and MOUNT/MT.

Level of Detail Field

This field selects the level of detail you want in your report:

LOW
: The report will produce a header of basic information for each facility. This information includes name, address, and various other identifiers.
HIGH
: The report gives all the data that LOW would plus most of the rest of ARIP.

Output Type Field

This field selects what output style your report will have:
Text
The report will produce human-readable ASCII text.
Comma-delimited ASCII
The report will produce a table of data with the columns separated by commas. Character fields will by surrounded by double quotes so that any commas in them won't be read as column delimiters. This style of output is suitable for loading into a database such as Dbase.
Tab-delimited ASCII
The report will produce a table of data with the columns separated by tabs. This style of output is suitable for loading into databases such as Excel.

Facility Name Field

Fill in the facility name in this field if you know it.

Warning! Facility names are often misspelled when submitted to EPA. In addition, many facilities change their names from year to year. For these reasons, enter as few letters as are necessary to specify the facility, followed by a "*" to represent any number of letters. This will help you find the facility even if its name changes or is misspelled. Example: You want to find a Du Pont facility. Possible spellings of facility name:

  1. DU PONT CO.
  2. E. I. DU PONT DE NEMEURS
  3. DUPONT
  4. DU PONT MICHIGAN PLANT
If you entered "DU PONT" into the name field, you wouldn't have found any of these spellings. On the other hand, if you entered "DU PONT*", you would have found spellings 1 and 4. To find all of these you would need to enter "*DU*PONT*". If you're not very sure of the facility name it is often better to leave this field blank and get a list of all facilities in the city that your facility of interest is in.

State Field

If you wish to search on the entire US, select the "ALL" value for this field.

Year Field

The ARIP database currently has information for the reporting years 1986 through 1995. WARNING: 1996 only has 11 records. To search through all years, select the ALL value from the selection list. There is currently no way to select only two or three years, although this can be implemented if many users want it.

SIC Field

SIC codes are 4-digit numbers that represent specific industries. More general industrial categories are represented by the first 2 digits of the SIC codes. For instance, "Primary production of aluminum" is SIC code 3334, in the category 33, "Primary Metal Industries". You can fill in either a 4-digit or 2-digit code in this field; if you fill in a 2-digit code the program will automatically add a "*" to the end of it to find all 4-digit codes that start with those digits.

Zip Code Field

Fill in the zip code for the area that you want. If you fill in a 5-digit zip code, the program will automatically put a "*" after it. The "*" represents any number of characters and will let your search find 9-digit zip codes that start with the 5 digits you entered. Don't fill in dashes.
Example:
If you enter 20740*
this will find

Chemical Name Field

Fill in the chemical name that you want. Note that you can use an asterisk (*) as a wildcard, so if you want all chemicals whose name begins with chlorine you could type in chlorine*. Since the same chemical can have more than one name, you might want to try searching by CAS number if you know it.

CAS Number Field

CAS numbers uniquely identify chemicals. If you want to search by CAS number, type it in without any dashes.

Owner Name Field

You can search for the owner of the facility instead of the facility itself. This allows you to find facilities across the U.S. owned by the same corporate parent. It also can be used if you know a facility is there but a search on facility name doesn't seem to work.

Owner Name Field

You can search for the owner of the facility instead of the facility