| cooked | raw | sets |
| 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 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