C14Ghosts
C14 Ghosts table: Published radiocarbon dates that BIAD has rejected from the C14 table for various reasons, mainly due to missing crucial meta data or hoor hygiene. Their provenance is highly suspicous, yet can be found in some big 14C databases. This includes dates which can only be traced back to large C14 databases and not a single published source (book, article, report, etc.).
Column name Data type Column description
C14.Age int Uncalibrated years BP
C14.SD int Standard deviation
C14ID int Unique identification code for each C14 sample
CitationID varchar See citation table for the strict character code.
Context varchar
ContextType varchar Specification of the feature dated directly by the 14C sample.
Flag varchar Published issues or problems with the date.
GraveID varchar ID of the specific grave (in the Graves table) that this 14C sample is directly associated with.
IndividualID varchar ID of the specific human individual (in the GraveIndividuals table) that this 14C sample is directly associated with.
LabID varchar Unique Laboratory identification number. Lab suffixes must be in the C14laboratories table, which end with a hyphen. This is important as labcodes are automatically checked by string splitting on the first hyphen. Note, there are cases where multiple hyphen legitimately exist in a labcode (e.g. OxA-X-2135-46). Other non-standard characters are also permitted, such as ‘.’ or ‘/’. Case sensitivity is important, for example, prefix GD- and Gd- are two different laboratories. Spaces are NOT permitted, therefore rare occasions such as 'GIF FG 39a' will be automatically assigned 'GIFFG-39a'
Material varchar Material of the sample
MaterialNotes varchar
Period varchar Broad chronological period e.g. Early Neolithic (EN), Middle Neolithic (MN)
PhaseID varchar Please see the detailed description of the 'Phases' table.
Prefix varchar Laboratory prefix generated automatically (DO NOT ADD VALUES) by MySQL trigger, which automatically strips this from the LabID, as a sanity check that it is valid.
SiteID varchar Unique site identification number
TaxonCode varchar
δ13C decimal C13 value with respect to the radiocarbon date.
δ13C.SD decimal C13 error (standard deviation) with respect to the radiocarbon date.