Connected to marine20 database as query
Reset

detailstimedeptaxaclassrefs
MapNo
Lon
Lat
DeltaR
DeltaRErr
Reference
Locality
Subregion
Notes
CollectionYear
ReservoirAge
ReservoirErr
C14age
C14err
LabID
Delta13C
TaxaNo
RefNo
nextime
last_changed
MapNo
Lon
Lat
DeltaR
DeltaRErr
Reference
Locality
Subregion
Notes
CollectionYear
ReservoirAge
ReservoirErr
C14age
C14err
LabID
Delta13C
TaxaNo
RefNo
nextime
last_changed
TaxaNo
Genus
Species
Feeding
ClassNo
ClassNo
Name
refno
authors
title
journal
year_published
doi

Type a query here, following the example syntax

Help with Syntax

Examples:
To get all the values (including a map) from a publication, look up the refno in the References link
   and then do Select * from details where refno=YourRefNo
Select * from class
Select * from details where mapno=600
select deltar,genus,species from details join taxa using (taxano) join class using (classno) where name='algae'
select locality,subregion,feeding,name from details join taxa using (taxano) join class using (classno) where reference like 'mcneely%'
select deltar,lon,lat from details where deltar>500 order by deltar
select mapno,labid,count(labid) from details group by labid having count(labid)>1 order by mapno
select avg(deltar),stddev_pop(deltar) from details where lat<-40 and lon between 0 and 180
select journal from refs order by journal