Get Account

Being logged in allows you to access advanced search features such as saved queries and saved diagrams. Membership is free. Please login or get a new account

Output Data outputdata

6799 samples found

Create an HTML Table, Excel File, or Tab-delimited Text File for viewing data createtable

Please select from the following list of options on how you would like the data presented.

Text File is tab-delimited and can be downloaded and opened in a spreadsheet application.
Advanced Excel Output and Advanced Text Output allow you to specify which fields to show.

All data files include Sample ID, References, Age, and Location.

With >2000 samples, the file may take several minutes to appear.

Major Element 4728 samples
Trace Element 4140 samples
Isotopes 1632 samples
Major, Trace Elements 3642 samples
Major, Trace, Isotopes 652 samples
All Data 6799 samples

HTML Table  Excel File  Text File  Advanced Excel Output  Advanced Text Output

First 10 References:
Russell, Charles W.; Gabites, ...    2005    Idaho Geological Survey, Techn...    Elevated 87Sr/86Sr ratios from mafic intrusions in...   
McCurry, Michael; Hayden, Karl...    2008    n/a    Genesis of post-hotspot, A-type rhyolite of the Ea...   
Sanford, Richard F; Snee, Lawr...    2005    U. S. Geological Survey Bullet...    Geology and stratigraphy of the Challis volcanic g...   
Godchaux, Martha M; Bonnichsen...    2004    Bulletin - Idaho Geological Su...    Syneruptive magma-water and posteruptive lava-wate...   
Shervais, John W; Shroff, Gaur...    2004    Bulletin - Idaho Geological Su...    Origin and evolution of the western Snake River pl...   
White, Craig M; Hart, William ...    2004    Bulletin - Idaho Geological Su...    Geochemical and Sr-isotopic variations in western ...   
Shoemaker, Kurt A; Hart, Willi...    2004    Bulletin - Idaho Geological Su...    Temporal controls on basalt genesis and evolution ...   
Hart, William K; Carlson, Rich...    1985    Isochron/West, vol.43, pp.5-10...    Distribution and geochronology of Steens Mountain-...   
Hart, William K; Carlson, Rich...    1983    Isochron/West, vol.38, pp.23-2...    K-Ar ages of late Cenozoic basalts from southeaste...   
10  Bonnichsen, Bill; Godchaux, Ma...    2004    Bulletin - Idaho Geological Su...    Late Miocene, Pliocene, and Pleistocene geology of...   

Download all references for this search.


Display all results on a dynamic map.

Display results on a simple static map suitable for downloading.


select sum(major_data_count) as smdc, sum(samp_trace_data_count) as stdc, sum(samp_isotope_data_count) as sidc, sum(samp_majtrace_data_count) as ssmtd, sum(samp_majtriso_data_count) as ssmdc, sum(samp_total_data_count) as total FROM (SELECT (case when samp.major_data = 'y' then 1 else 0 end) as major_data_count, (case when samp.trace_data = 'y' then 1 else 0 end) as samp_trace_data_count, (case when samp.isotope_data = 'y' then 1 else 0 end) as samp_isotope_data_count, (CASE when samp.major_data='y' and samp.trace_data='y' then 1 else 0 end) as samp_majtrace_data_count, (CASE when samp.major_data='y' and samp.trace_data='y' and samp.isotope_data='y' then 1 else 0 end) as samp_majtriso_data_count, (CASE WHEN samp.sample_num > 0 then 1 else 0 end) as samp_total_data_count FROM view_data_output norm, sample samp, location loc, sample_age age, batch bat, reference ref, method meth WHERE ST_Contains(st_GeomFromText('Polygon((-108.7646484375 45.583289756006316,-118.1689453125 44.6061127451739,-118.01513671875 41.590796851056005,-108.08349609375 42.61779143282346,-108.7646484375 45.583289756006316))'),loc.mypoint) AND norm.sample_num = samp.sample_num AND age.sample_num = samp.sample_num AND loc.location_num = samp.location_num AND bat.sample_num = samp.sample_num AND ref.ref_num = bat.ref_num AND meth.method_num = age.method_num ) b
go to earthchem NAVDAT Home