Each of the above downloads is in a comma delimited, tabular fomat. The first row contains the column headers, and the rest of the rows are the data. The files can be easily imported (or pasted) into MS Excel, MS Access and other database software.
If the scores downloaded are site visit scores (not aggregates), that score table can be joined to the sample table on the natural key composed of Agency, Site Code, and Visit Date. (Site Code is guaranteed to be unique within an agency).
Important Update: Three new fields have been added to data downloads: Site ID, Site Visit ID, and Sample ID. They are all integers generated from the database and uniquely identify Site, Site Visit, and Sample records, respectively. These fields should make working with downloaded data easier; joining (connecting) multiple downloads with these keys in a tool like MS Access is much easier than with the compound natural keys. The Sample ID field has been renamed to "Sample Code" to maintain a consistent naming convention: Site Code and Sample Code are defined by project staff, and Site ID, Sample ID and Site Visit ID are integers defined by the database.