FaunalSpecies
Records of all species identified at the phase level for each site, with their associated age and sex trends, pathologies, and body part representation. Age identification methods (BF, DA and DE) are impotant because ? repliability?? How does an analyst potentially use this?
Column name Data type Column description
AgeCriteriaBF varchar Binary distinction between species that have been aged based on epiphyseal fusion (yes) and those that have not (no)
AgeCriteriaDA varchar Binary distinction between species that have been aged based on dental abrasion (yes) and those that have not (no)
AgeCriteriaDE varchar Binary distinction between species that have been aged based on dental eruption (yes) and those that have not (no)
AgeNote varchar Age trend evidence notes
AgeTrend varchar Bulk sample of many bones, therefore referring to the majority (mainly). Description of the age trend e.g. 'mostly juvenile', 'mostly adult'
CitationID varchar
FaunalSpeciesID varchar Unique identification number for each species record
HorncoreNote varchar Horncore shape notes
HorncoreShape varchar Interpretation of wild/domestic status based on the horncore shape e.g. 'Both wild and domestic', 'majority wild' etc.
NISP int Number of Identified Specimens
Pathology varchar Binary distinction between species that show evidence of pathology (1) and those that do not (0)
PathologyNote varchar Pathology evidence notes
PhaseID varchar Please see the detailed description of the 'Phases' table.
PresenceOfFoetals varchar Binary distinction between species that include foetal remains (1) and those that do not (0)
PresenceOnly varchar Binary distinction between species that have been recorded as presence only (1) and those that have not (0)
SexCriteriaME varchar Binary distinction between species that have been sexed based on metric criteria (1) and those that have not (0)
SexCriteriaMO varchar Binary distinction between species that have been sexed based on morphology (1) and those that have not (0)
SexNote varchar Sex trend evidence notes
SexTrend varchar Description of the sex trend e.g. 'majority male, 'majority female' etc.
SpeciesNote varchar General notes field for additional information about the species
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.