Faunal Data from Apalachicola (1RU18, 1RU27)

Summary

An Excel spreadsheet containing the zooarchaeological data from Apalachicola (1RU18 & 1RU27), part of the Apalachicola Ecosystems Project. The first tab contains the primary zooarchaeological data, the second tab contains the weights, and the third tab contains a pivot table which shows the total combined weight for each taxon identification.

Cite this Record

Faunal Data from Apalachicola (1RU18, 1RU27). Barnet Pavao-Zuckerman, Andrew Webster. 2014 ( tDAR id: 447802) ; doi:10.6067/XCV8447802

Data Set Structure

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

Table Information: Pivot Table

This pivot table displays the total weight (in grams) of each species or taxonomic identification. This table is best viewed in the Excel file (not through the tDAR interface).

Column Name Data Type Type Category Coding Sheet Ontology
Total Weight in grams In the column next to the taxon's common name, the pivot table displays the total weight in grams of all specimens belonging to that species or taxonomic identification.
DOUBLE  Measurement (gram) Fauna : Weight none none
Taxon Each taxon is displayed on three consecutive rows on the pivot table. The first row displays the taxon code, the second row displays the latin taxon name, and the third row displays the common taxon name.
VARCHAR  Uncoded Value Fauna : Taxon none none

Table Information: Primary Data

This table contains the primary zooarchaeological data (everything except weight).

Column Name Data Type Type Category Coding Sheet Ontology
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
PRTN The portion of the element recovered.
BIGINT  Coded Value Fauna : Portion/Proximal/Distal Pavao-Zuckerman Fauna Coding Sheet Portion none
TX CODE Taxon Code
BIGINT  Coded Value Fauna : Taxon Alabama-Georgia Historic Sites Taxon Coding Sheet Fauna Taxon Ontology - Eastern US
ELEM BIGINT  Coded Value Fauna : Element Element: Arizona State Museum Faunal Coding Key Fauna Element Ontology
COMMENTS Comments may relate to modification types, see the "Modifications: Arizona State Museum Faunal Coding Key"
VARCHAR  Uncoded Value Lookup : Notes none none
Taxon Latin Taxon Name
VARCHAR  Uncoded Value Fauna : Taxon none none
Common Name Common Taxon Tame
VARCHAR  Uncoded Value Fauna : Taxon none none
NISP The Number of Identified Specimens (NISP), or bone count, is determined for every taxonomic identification. Specimens that cross-mend with other specimens in the same minimum analytical unit (Catalog Number) are counted as single specimens. No attempt was made to cross-mend specimens from separate Catalog Numbers.
BIGINT  Count Fauna : Count none none
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
FUS The presence and extent of fusion on the bone.
BIGINT  Coded Value Fauna : Fusion Fusion: Arizona State Museum Faunal Coding Key Fauna Fusion Ontology
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
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.
VARCHAR  Coded Value Fauna : Cultural Modification Modifications: Arizona State Museum Faunal Coding Key Fauna Butchering Ontology
Unit VARCHAR  Uncoded Value Provenience and Context : Unit none none
Level # VARCHAR  Uncoded Value Provenience and Context : Level none none
Stratum # VARCHAR  Uncoded Value Provenience and Context : Stratum none none
Feature # VARCHAR  Uncoded Value Provenience and Context : Feature ID/Number none none
Box Location VARCHAR  Uncoded Value Storage : Box Number none none
Catalog # The minimum analytical unit. Each catalog number refers to all specimens found within the same context (same Unit, Stratum, and Level).
DOUBLE  Uncoded Value Provenience and Context : Identifier none none
Site/Field # 1RU18: Apalachicola Old Town,1715-1757 1RU27: Apalachicola, Creek, 1400s-1600s
VARCHAR  Uncoded Value Provenience and Context : Site none none
Project # VARCHAR  Uncoded Value Provenience and Context : Project none none
Analyst Collection analyzed by Tracie Mayfield (TM) and Chance Copperstone (CC) under the supervision of Dr. Barnet Pavao-Zuckerman
VARCHAR  Uncoded Value Lookup : Other none none

Table Information: Weights

All weights were collected by taking all specimens belonging to a specific taxon identification within a minimal analytical unit (Catalog number) and weighing them together. Thus, while different elements or portions are separated into different lines in the primary dataset, they are combined here for the weight measurement. ​

Column Name Data Type Type Category Coding Sheet Ontology
TX CODE Taxon Code
BIGINT  Coded Value Fauna : Taxon Alabama-Georgia Historic Sites Taxon Coding Sheet Fauna Taxon Ontology - Eastern US
Weight (in g.) Weight in grams of the specimen(s)
DOUBLE  Measurement (gram) Fauna : Weight none none
Common Name Common Taxon name
VARCHAR  Uncoded Value Fauna : Taxon none none
Taxon Latin Taxon Name
VARCHAR  Uncoded Value Fauna : Taxon none none
Level # VARCHAR  Uncoded Value Provenience and Context : Level none none
Stratum # VARCHAR  Uncoded Value Provenience and Context : Stratum none none
Feature # VARCHAR  Uncoded Value Provenience and Context : Feature ID/Number none none
Box Location VARCHAR  Uncoded Value Storage : Box Number none none
Catalog # The minimum analytical unit. Each catalog number refers to all specimens found within the same context (same horizontal and vertical provenience).
DOUBLE  Uncoded Value Provenience and Context : Identifier none none
Site/Field # 1RU18: Apalachicola Old Town, Creek, 1715-1757 1RU27: Apalachicola, Creek, 1400s-1600s.
VARCHAR  Uncoded Value Provenience and Context : Site none none
Project # VARCHAR  Uncoded Value Provenience and Context : Project none none
Analyst Collection analyzed by Tracie Mayfield (TM) and Chance Copperstone (CC) under the supervision of Dr. Barnet Pavao-Zuckerman
VARCHAR  Uncoded Value Lookup : Other none none

Temporal Coverage

Calendar Date: 1715 to 1757 (1RU18)

Calendar Date: 1400 to 1690 (1RU27)

Spatial Coverage

min long: -85; min lat: 32.184 ; max long: -84.927; max lat: 32.227 ;

Individual & Institutional Roles

Contact(s): Barnet Pavao-Zuckerman

Contributor(s): Nicole Mathwich; Andrew Webster; Tracie Mayfield; Chance H. Copperstone

Project Director(s): Thomas Foster; Roger Brown

Sponsor(s): National Science Foundation

Source Collections

1RU18 and 1RU27 (Apalachicola): The University of Tulsa

Related Comparative Collections

Stanley J. Olsen Laboratory of Zooarchaeology, Arizona State Museum, University of Arizona

File Information

  Name Size Creation Date Date Uploaded Access
Apalachicola_Faunal_Data.xlsx 236.50kb Dec 17, 2018 Oct 6, 2019 3:33:46 PM Public
  • Translated version Apalachicola_Faunal_Data_translated.xlsx (115.46kb)
    Data column(s) in this dataset have been associated with coding sheet(s) and translated: