Fusihatchee Faunal Data

Summary

An Access database of zooarchaeology data from the Ancestral Creek Fusihatchee site (1EE191) The data were reported in a 2001 dissertation by Barnet Pavao-Zuckerman entitled "Culture Contact and Subsistence Change at Fusihatchee." The database was created in 2015 by Nicole Mathwich and uploaded to tDAR by Andrew Webster in 2018.

The database was created from handwritten data cards created from 1997-1998 at the University of Georgia. These original cards have been scanned and are included in this tDAR project as "Fusihatchee Faunal Data Paper Copy Scans"

The database is compatible with Microsoft Access 2007 and 2013, however it is best not to switch between versions to avoid file corruption. The entire database can be exported to an Excel and a variety of other formats.

Known issues:

The majority of the database has not been checked against the original cards.

“Str” could refer to structure or stratum. The abbreviation was used inconsistently by the three people who originally created the cards.

About 4/5th of the data were entered by trained zooarchaeologist, the other 1/5th were entered by volunteers who were unfamiliar with the coding system.

Cite this Record

Fusihatchee Faunal Data. Barnet Pavao-Zuckerman, Andrew Webster, Nicole Mathwich. 2015 ( tDAR id: 446732) ; doi:10.6067/XCV8446732

Data Set Structure

Measurement Column
Count Column
Coded Column
Filename Column
Integration Column (has Ontology)

Table Information: Card_info

This table includes taxon identification and provenience information, including site, unit, structure/feature, level/stratum, FS number, and screen size. It also includes the taxon identification, count, and total weight of the specimen(s). It links with the Specimen_info table (more detailed faunal data) through the PK_ID field.

Column Name Data Type Type Category Coding Sheet Ontology Search
Feature Type The type of feature, when recorded.
TEXT  Uncoded Value Provenience and Context : Feature Type none none true
Level/Stratum The level or stratum in which the specimen(s) were recovered.
TEXT  Uncoded Value Provenience and Context : Level none none true
FS Number The field specimen number
TEXT  Uncoded Value Provenience and Context : Identifier none none true
Screen size The screen size used, when recorded.
TEXT  Uncoded Value Provenience and Context : Screening none none true
Taxon code Unique number assigned to taxa (see lkp_taxon)
BIGINT  Coded Value Fauna : Taxon Alabama-Georgia Historic Sites Taxon Coding Sheet Fauna Taxon Ontology - Eastern US true
Project The archaeological project. For this dataset, all specimens are part of the Fusihatchee project.
TEXT  Uncoded Value Provenience and Context : Project none none true
Structure/Feature The structure or feature in which the specimen(s) were recovered.
TEXT  Uncoded Value Provenience and Context : Feature ID/Number none none true
Unit The unit in which the specimen(s) were recovered.
TEXT  Uncoded Value Provenience and Context : Unit none none true
Taxon Uncoded taxa name, with common name in parentheses.
BIGINT  Uncoded Value Fauna : Taxon none none true
PK_ID The Primary key from Card_info table. The PK_ID links this Card_Info table (which has provenience information and the taxon identification) to the Specimen_info table data (which has specific faunal information). Each PK_ID is a unique, automatically generated, sequential integer that groups together all specimens of one taxon that were found in a distinct context. In other words, for every Level/Stratum within a Structure/Feature within a Unit, one PK_ID will be assigned to all specimens of one taxa found in that specific context. Different taxa within the same context receive different PK_IDs. Specimens of the same taxa from different contexts likewise receive different PK_IDs.
BIGINT  Uncoded Value Lookup : ID none none true
UGA # Unique number assigned to individual index card onto which the data was originally recorded. UGA refers to the University of Georgia, where the analysis took place.
BIGINT  Uncoded Value uncategorized none none true
Weight (g) The weight in grams of the specimen(s)
DOUBLE  Measurement (gram) Fauna : Weight none none true
Count Count of specimens
BIGINT  Count Fauna : Count none none true
Data Entry Person Person who entered the data into the access database, NOT the person who wrote the original paper card/did the analysis
TEXT  Uncoded Value Lookup : Other none none true

Table Information: lkp_burn

Used in the access database to code for burning

Column Name Data Type Type Category Coding Sheet Ontology Search
burn_term Burn key
TEXT  Uncoded Value Fauna : Burning none none true
burn_code Unique number that codes for burning
BIGINT  Uncoded Value Fauna : Burning none none true

Table Information: lkp_element

Used in the access database to code for element

Column Name Data Type Type Category Coding Sheet Ontology Search
ELEM_Code Unique number that codes for an element
BIGINT  Uncoded Value Fauna : Element none none true
ELEM_term Element key
TEXT  Uncoded Value Fauna : Element none none true

Table Information: lkp_fusion

Used in the access database to code for fusion

Column Name Data Type Type Category Coding Sheet Ontology Search
fusion_code Unique number that codes for the bone fusion categories
BIGINT  Uncoded Value Fauna : Fusion none none true
fusion_term Bone fusion key
TEXT  Uncoded Value Fauna : Fusion none none true

Table Information: lkp_portion

Used in the access database to code for portion

Column Name Data Type Type Category Coding Sheet Ontology Search
portion_code Unique number that codes for element portion
BIGINT  Uncoded Value Fauna : Portion/Proximal/Distal none none true
portion_term Element portion key
TEXT  Uncoded Value Fauna : Portion/Proximal/Distal none none true

Table Information: lkp_taxon

Used in the access database to code for taxon

Column Name Data Type Type Category Coding Sheet Ontology Search
taxon_code Unique number that codes for a taxon category
BIGINT  Uncoded Value Fauna : Taxon none none true
taxon_term Taxon key
TEXT  Uncoded Value Fauna : Taxon none none true

Table Information: Specimen_info

This is the primary data table for faunal data. It includes all recorded information about the faunal data from the site, including NISP, element, side, portion, fusion, burning, marks, and gnawing. It does not display the taxon identification. It links with the Card_info table through the PK_ID field. This Specimen_info table records the faunal information about each specimen, while the Card_info table has the provenience information for each specimen, as as the taxon identification.

Column Name Data Type Type Category Coding Sheet Ontology Search
ID Automatic sequential number assigned to each specimen entry. Multiple specimens may be represented by a single ID number, all the same taxon from the same context. See NISP for the number of identified specimens recovered.
BIGINT  Uncoded Value Lookup : ID none none true
Portion The portion of the element recovered. Code connected to lkp_portion table.
BIGINT  Coded Value Fauna : Portion/Proximal/Distal Pavao-Zuckerman Fauna Coding Sheet Portion none true
Gnaw 0 = ungnawed; 1 = rodent gnawing; 2 = carnivore gnawing
BIGINT  Coded Value Fauna : Gnawing/Animal Modification Gnawing: Arizona State Museum Faunal Coding Key Fauna Gnawing Ontology true
Fusion The presence and extent of fusion on the bone. Code connected to lkp_fusion table.
BIGINT  Coded Value Fauna : Fusion Fusion: Arizona State Museum Faunal Coding Key Fauna Fusion Ontology true
Burn Presence of burning. 0 = unburned; 1 = burned; 2 = calcined
BIGINT  Coded Value Fauna : Burning Burning: Arizona State Museum Faunal Coding Key Fauna Burning Intensity Ontology true
Marks The type of butchery or other culturally-made marks on the specimen. More information about these marks is sometimes included in the Comments column.
BIGINT  Coded Value Fauna : Cultural Modification Modifications: Arizona State Museum Faunal Coding Key Fauna Butchering Ontology true
Comments Memo field containing information about the specimen and any difficulties encountered when entering the data. Includes other details like the nature of butchery marks.
TEXT  Uncoded Value Lookup : Notes none none true
Element The element represented by the specimen. Code connected to lkp_element table.
BIGINT  Coded Value Fauna : Element Element: Arizona State Museum Faunal Coding Key Fauna Element Ontology true
NISP Number of Identified Specimens. The count of specimens for each entry.
BIGINT  Count Fauna : Count none none true
Side Side Code: 0 = unknown or n/a; 1 = left; 2 = right
BIGINT  Coded Value Fauna : Side Symmetry: Arizona State Museum Faunal Coding Key Fauna Side Ontology true
PK_ID The Primary key from Card_info table. The PK_ID links this Specimen_info table data (which has specific faunal information) to the Card_Info table (which has provenience information and the taxon identification). Each PK_ID is a unique, automatically generated, sequential integer that groups together all specimens of one taxon that were found in a distinct context. In other words, for every Level/Stratum within a Structure/Feature within a Unit, one PK_ID will be assigned to all specimens of one taxa found in that specific context. Different taxa within the same context receive different PK_IDs. Specimens of the same taxa from different contexts likewise receive different PK_IDs.
BIGINT  Uncoded Value Lookup : ID none none true

Data Table Relationships:

Type Local Table Foreign Table Column Relationships
ONE_TO_MANY lkp_burn Specimen_info burn_code Burn
ONE_TO_MANY lkp_taxon Card_info taxon_code Taxon
ONE_TO_MANY lkp_fusion Specimen_info fusion_code Fusion
ONE_TO_MANY lkp_portion Specimen_info portion_code Portion
ONE_TO_MANY lkp_element Specimen_info ELEM_Code Element
ONE_TO_MANY Card_info Specimen_info PK_ID PK_ID

Temporal Coverage

Calendar Date: 1050 to 1250 (Late Woodland)

Calendar Date: 1814 to 1836 (Late Historic)

Calendar Date: 1717 to 1814 (Historic)

Calendar Date: 1600 to 1717 (Colonial/Protohistoric)

Spatial Coverage

min long: -86.188; min lat: 32.347 ; max long: -85.858; max lat: 32.524 ;

Individual & Institutional Roles

Contact(s): Barnet Pavao-Zuckerman

Contributor(s): Marilyn Malone; Nancy Daunton; Nicole Mathwich; Andrew Webster

Source Collections

University of South Alabama

Related Comparative Collections

Georgia Museum of Natural History, University of Georgia

File Information

  Name Size Creation Date Date Uploaded Access
Fusihatchee_Faunal_Data.accdb 1.69mb Sep 3, 2018 Oct 6, 2019 2:16:32 PM Public
An access database of zooarchaeology data from the Ancestral Creek Fusihatchee site (1EE191) The data were reported in a 2001 dissertation by Barnet Pavao-Zuckerman entitled "Culture Contact and Subsistence Change at Fusihatchee." Access database created in 2015 by Nicole Mathwich and uploaded to tDAR by Andrew Webster in 2018.
  • Translated version Fusihatchee_Faunal_Data_translated.xlsx (845.46kb)
    Data column(s) in this dataset have been associated with coding sheet(s) and translated: