Local Navigation

Aquatic ASCII Downloads

Download the Adobe® Reader® Exit EPA Disclaimer

The entire AQUIRE data set is available for downloading as pipe ( | ) delimited ASCII data files.  These files can be imported into other databases and with some effort can be reconstructed into a working database.  Consult the documents listed below for information on how to make use of the data files.

  • The Aquatic Data Structure (PDF) can be viewed in this PDF file when rebuilding the system using another database package


  • The data files are stored in a Windows compatible self-extracting ZIP format and can be accessed by double clicking on the downloaded aquire_ascii_**-**-***.exe file once it has been downloaded to your computer. 


  • For more information on the individual fields contained in each of the records, download the AQUATIC Coding Guidelines (PDF) and ECOTOX Code Appendix (PDF).


  • Listed below is a recent history of the updates made to the download file.  Select the data set you want to download by clicking the date field for that data set.  Only the three most recent data sets are kept available for purposes of comparison.

    •  
    Date of Update Reason for Update Files Updated
    09/16/2009 Scheduled update. All
    06/24/2009 Scheduled update. All
    02/11/2009 Scheduled update. All
    11/12/2008 Scheduled update. All
    03/05/2008 Scheduled update. All
    12/12/2007 Scheduled update. All
    09/07/2007 Scheduled update. All
    04/09/2007 Scheduled update. All
    09/21/2006 Scheduled update. All
    02/22/2006 Scheduled update. All
    10/04/2005 Scheduled update. All
    01/15/2004 Regular quarterly update. All
    09/01/2003 Regular quarterly update. All
    05/05/2003 Regular quarterly update. All
    12/20/2002 Regular quarterly update. All
    01/10/2002 Regular quarterly update. All
    05/22/2002 Regular quarterly update. All
    12/20/2001 Regular quarterly update plus format change. All
    07/07/2001 Regular quarterly update. All
    05/15/2001 Regular quarterly update. All (Added Table
     Relations PDF)
    12/20/2000 Regular quarterly update. All
    10/17/2000 It was discovered that a significant number of remarks were omitted from the 9/18/2000 release and all previous releases. These are now available as a part of this download.  remarks.txt
    09/18/2000 Regular quarterly update. All
    06/20/2000 Regular quarterly update. All
    05/17/2000 First release of AQUIRE data set using the ECOTOX Release 2 format. Important! Significant changes have been made to the data table structures since the previous release. All
    10/13/99 Several changes were made to the data tables to repair incorrect or missing data, the changes were:
    • The study controls were incorrect for a subset of the records.
    • The organic carbon type values were incorrect and have been replaced with the correct values.
    • The reviewer field was edited to fix a known problem where two reviewers were listed under the same set of initials, CAR.  These have now been split into CAR and DXC.
    • The water depth records were missing from the previous releases and have been added.
    		 aquire.txt, water-
    characteristics.txt
    10/04/99 Some species were missing from the species lookup file and have now been added. species.txt
    09/16/99 Some chemicals were missing from the chemical lookup file and have now been added. chemicals.txt
    08/12/99 The Office of Pesticide Programs data was omitted from the original download, it is now included. opp.txt
    08/01/99 Original release of data.  

     

    Jump to main content.