Using the Bone Sample Archive Database Search Form

The Bone Sample Archive Database Search Form, located in the upper frame, is used to search the Bone database for samples currently archived at EML. All of the Search Form selection options are linked to this instructional frame. Please select your search criteria and submit the Form. After submitting the Form, your search will be executed and the search results will appear in this frame, replacing these instructions.

Please be patient and only click submit *once*.

You can move the window separator up or down to show the results better or execute another search from the Form.

The time taken to execute your query depends on the number of records returned. If you do not set limits on the records sought above, your query will return approximately 20,000 records and will take several minutes to process, which may lead to a timeout error. Limiting your query to one site or to a range of dates is highly recommended. More limited queries should be much faster, and very specifc queries should execute almost instantly. You can also reduce this delay by selecting fewer records to be displayed at one time. Once you click the submit button, there will be a pause while the query is executed on our database; then the data will begin downloading. Depending upon your web browser, you may or may not receive a visual indication of activity after clicking the submit button but the query *is* working.

Please be patient and only click submit *once*.

Selecting sites: Select your site from the pull-down menu. You can choose to search across all the sites or just one of them. EML has bone samples from New York City, Chicago, San Francisco, and Puerto Rico.

Selecting dates: This search will allow you to limit your results to samples collected within a range of months. Selecting just a year will include all samples from that year and later/earlier. Selecting both a month and year will return all samples from that month and later/earlier. Selecting a month without a corresponding year is not meaningful, and if your start date is after your end date, your results set will be quite small.

Selecting an age range: Here you can limit your results to individuals who were at a specific age at the time of their death. Combined with the previous one, you could find all the samples of individuals between 50 and 60 years old who died in 1963, for instance.

Displaying records: This box allows you to select how many records will display on screen at one time. Extremely large HTML tables can cause problems with your web browser when it attempts to parse and display them and can increase the time needed to download the information over a slow internet connection. Choosing a large number of records at a time can create tables large enough to crash your web browser. You have been warned. On the other hand, the query is executed again for each page displayed, which can be time-consuming if the query is complex. This choice is only meaningful for the hyperlinked display and is ignored for the comma-delimited format.

Standard display: To display the search results on your screen, click the Submit button. All records which meet your criteria will be displayed, along with any appropriate columns of information according to your selections.

Comma-delimited display: Comma-delimited format is useful to allow people to download sections of the Bone database and import them into spreadsheet or database applications. The format parallels the hyperlinked display - it should provide exactly the same records and fields as the hyperlinked display. You can thus refine your query with the web display and then download a file suitable for data manipulation. After clicking on the button, your web browser will ask if you want to save the file to disk - you should answer yes and give it a name ending in .txt because it is a plain-text file. When importing into other applications, you should treat all fields (or at least the sample ID fields) as "text" and not as "general" or "numeric".

The EML Sample Archives makes available environmental radiological data collected for programs funded through the U.S. Atomic Energy Commission, the U. S. Energy Research and Development Administration and the U. S. Department of Energy. All of these programs have been terminated. The databases were last updated in 1999. No additional data will be added to these databases. Any inquiries about these programs should be made to webmaster@eml.doe.gov.