C14Ghosts
C14 dates in the literature that are missing the minimum required information to be accepted into the C14 table. 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.
ItemID	varchar
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.