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
C14ID	int	Unique identification code for each C14 sample
PhaseID	varchar	Please see the detailed description of the 'Phases' table.
SiteID	varchar	Unique site identification number
ItemID	varchar
Period	varchar	Broad chronological period e.g. Early Neolithic (EN), Middle Neolithic (MN)
C14.Age	int	Uncalibrated years BP
C14.SD	int	Standard deviation
δ13C	decimal	C13 value with respect to the radiocarbon date.
δ13C.SD	decimal	C13 error (standard deviation) with respect to the radiocarbon date.
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'
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.
TaxonCode	varchar
Material	varchar	Material of the sample
MaterialNotes	varchar
Flag	varchar	Published issues or problems with the date.
ContextType	varchar	Specification of the feature dated directly by the 14C sample.
Context	varchar
CitationID	varchar	See citation table for the strict character code.