FaunalBiometrics
The interaction between the 'Castrate' probability and 'Sex' probability (of being female) is tricky. In cases where the sex determination was originally published as 'castrate?' there was uncertainty in the archaeologist's mind, which we interpret as an equal probability of being castrated or not. However, it is unclear if the archaeologist was confident that it was a male (either castrated or not), or if there was also the possibility that it was female. Therefore, in all cases where the castrate probability is between 0 and 1 we make no judgment on th castrate status and leave null. Likewise where there is no judgement on the sex probability where the castrate status is uncertain.
Column name	Data type	Column description
BoneID	varchar	Bone identification number, since many metrics can be measured from the same bone.
Castrate	decimal	Probability of being a castrate. A value of 1 indicates castrate with certainty. A value of 0.5 indicates an equal probability of being castrated or not. A value of 0 indicates certainly not a castrate. NULL indicates unknown.
Measurement	varchar	Von den Driesch abbreviation of the metric.
MetricID	varchar	Unique metric identification number
PhaseID	varchar	Please see the detailed description of the 'Phases' table.
Sex	decimal	Probability of being female. A value of 1 indicates female with certainty, a value of 0 indicates male with certainty, and a value of 0.5 indicates an equal probability of male or female.
SkeletalElement	varchar	Name of bone or tooth. Case sensitive, as adult and milk teeth are defined by upper and lower case.
TaxonCode	varchar	Unique code to identify the full taxonomic name. This usually consists of the first four letters of the genus and first three letters of the species.
Value	decimal	Measurement value in mm.