Simple query  Connected to intcal09 database Reset About
cookedrawsets
datno
setno
division
subdivision
samid
labid
calage
calspan
calsig
c14age
c14sig
datno
setno
division
subdivision
calage
calspan
calsigI
calsigD
calsigC
calseqno
c14age
c14sig
c14addsig
c14mulsig
ReservoirAge
ReservoirSig
Date_Modified
setno
division
subdivision
author
published
comment
kind
  • calsigI: A calendar age uncertainty which is Independent of all other samples in the dataset, for example, a Uranium / Thorium date uncertainty.
  • calsigD: A calendar age uncertainty which is Dependent on other samples in the dataset, for example a wigglematch uncertainty.
  • calsigC: A calendar age uncertainty which is Cumulative. Counting errors and speliothem growth model uncertainties are examples.
  • calseqno: A somewhat redundant field which defines the range of samples affected by a dependent error structure. When there is a dependent error it will be the same for all samples in a division of a dataset.
  • raw.c14age: radiocarbon age BP uncorrected for reservoir age.
  • raw.c14sig: The uncertainty in the c14 age reported by the radiocarbon laboratory.
  • c14addsig: Additive c14 age uncertainty.
  • c14mulsig: Multiplicative c14 age uncertainty (error multiplier).
  • ReservoirAge: Local reservoir age of the ocean for marine samples or a Dead Carbon Fraction in speliothems.
  • ReservoirSig: Uncertainty in the reservoir age.

Type in a query here, following the example syntax

Help with Syntax

Examples:
select raw.*,raw.calage-(raw.calspan-1)/2 as calmidpt,labid,sets.author,sets.comment from cooked join raw using (datno,setno,division,subdivision) join sets using (setno,division,subdivision) where setno<10
Select * from sets
Select * from raw where setno=11
select calage,calage-(calspan-1)/2,calspan,c14age,c14sig,kind from raw join sets using (setno) where setno=7
select * from raw join sets using (setno) where author like 'cams%'
select raw.setno,labid,reservoirage from raw join cooked using (datno) where reservoirage>500 order by reservoirage
select calage,c14age,calsig,c14sig from cooked where calage between 12500 and 50000
It is possible to execute these queries from within the R programming language