Faunal Data from Apalachicola (1RU18, 1RU27)

Creator(s): Barnet Pavao-Zuckerman; Andrew Webster

Analyst(s): Tracie Mayfield; Chance H. Copperstone

Year: 2014

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

This Resource is Part of the Following Collections

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 Search
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 true
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 true

Table Information: Primary Data

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

Column Name Data Type Type Category Coding Sheet Ontology Search
Project # VARCHAR  Uncoded Value Provenience and Context : Project none none true
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 true
TX CODE Taxon Code
BIGINT  Coded Value Fauna : Taxon Alabama-Georgia Historic Sites Taxon Coding Sheet Fauna Taxon Ontology - Eastern US true
PRTN The portion of the element recovered.
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
Level # VARCHAR  Uncoded Value Provenience and Context : Level none none true
Stratum # VARCHAR  Uncoded Value Provenience and Context : Stratum none none true
Feature # VARCHAR  Uncoded Value Provenience and Context : Feature ID/Number none none true
Box Location VARCHAR  Uncoded Value Storage : Box Number none none true
Unit VARCHAR  Uncoded Value Provenience and Context : Unit none none true
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 true
Site/Field # 1RU18: Apalachicola Old Town,1715-1757 1RU27: Apalachicola, Creek, 1400s-1600s
VARCHAR  Uncoded Value Provenience and Context : Site none none 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.
VARCHAR  Coded Value Fauna : Cultural Modification Modifications: Arizona State Museum Faunal Coding Key Fauna Butchering 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
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 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
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 true
Common Name Common Taxon Tame
VARCHAR  Uncoded Value Fauna : Taxon none none true
Taxon Latin Taxon Name
VARCHAR  Uncoded Value Fauna : Taxon none none true
COMMENTS Comments may relate to modification types, see the "Modifications: Arizona State Museum Faunal Coding Key"
VARCHAR  Uncoded Value Lookup : Notes none none true
ELEM BIGINT  Coded Value Fauna : Element Element: Arizona State Museum Faunal Coding Key Fauna Element Ontology true

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 Search
Site/Field # 1RU18: Apalachicola Old Town, Creek, 1715-1757 1RU27: Apalachicola, Creek, 1400s-1600s.
VARCHAR  Uncoded Value Provenience and Context : Site none none true
Project # VARCHAR  Uncoded Value Provenience and Context : Project none none true
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 true
Taxon Latin Taxon Name
VARCHAR  Uncoded Value Fauna : Taxon none none true
Level # VARCHAR  Uncoded Value Provenience and Context : Level none none true
Stratum # VARCHAR  Uncoded Value Provenience and Context : Stratum none none true
Feature # VARCHAR  Uncoded Value Provenience and Context : Feature ID/Number none none true
Box Location VARCHAR  Uncoded Value Storage : Box Number none none true
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 true
Weight (in g.) Weight in grams of the specimen(s)
DOUBLE  Measurement (gram) Fauna : Weight none none true
Common Name Common Taxon name
VARCHAR  Uncoded Value Fauna : Taxon none none true
TX CODE Taxon Code
BIGINT  Coded Value Fauna : Taxon Alabama-Georgia Historic Sites Taxon Coding Sheet Fauna Taxon Ontology - Eastern US true

Keywords

Culture
Historic • Historic Native American • Mississippian

Material
Fauna

Site Name
Apalachicola (1RU27) • Apalachicola Old Town ​(1RU18)

Site Type
Domestic Structure or Architectural Complex • Settlements • Town / City

Investigation Types
Collections Research • Data Recovery / Excavation

General
Creek • Native Americans • Zooarchaeology • Zooarcheological Analysis

Geographic Keywords
Alabama (State / Territory) • CHATTAHOOCHEE RIVER DRAINAGE • North America: Southeast United States • North America - Southeast

Temporal Keywords
Colonial • Eighteenth century • Fifteenth Century • Historic • Seventeenth Century • sixteenth century

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: