Grasshopper Pueblo Fauna

Creator(s): John Olsen; R. Kyle Bocinsky

Year: 2018


This dataset consists of a portion of the faunal assemblage that was excavated by the University of Arizona at Grasshopper Pueblo. These data were entered into a digital format from the original faunal coding cards on file at the Arizona State Museum. **NB: up to this point we have not reached the cards for the avian fauna; only mammals are included in this dataset.**

In cleaning the digital file February 2018 K. Spielmann undertook the following: The No of Specs column was edited to be a uniform count variable. The “?” entry in this column, when it occurred, was removed and typographical errors were removed. In particular, entries that were identified as ‘skeleton’ or ‘partial skeleton’ (primarily ground squirrels, mice, and woodrats) under the Element variable were changed to a count of 1 in the No of Specs column. The NISP count now is present in the comments box. For many of the skeletons, specific elements are listed in the “Portion Present” column.

When the information from the original index cards was entered into the database, the transcriber noted when a card had a red line through it and also the two occasions on which only one portion of the card had a read line through it. John Olsen confirmed (P.C. 1/25/18) that “John Sparling used a red line through a particular entry to indicate it was a duplicate.” Olsen then did not include these redundant data in calculating the raw numerical counts he used in his dissertation. These duplicate entries have thus been removed from the electronic database posted on tDAR. Two entries had red lines only through the portion present. These elements remain in the dataset; the note is in the comments column.

N.B.: Burning information is contained sometimes in either the ‘Color’ column or the ‘Comments’ column. It’s unclear how systematically burning was reported. In 2018, Bocinsky duplicated this dataset to remove the mapping of the "Size" field to the Taxon ontology.

Cite this Record

Grasshopper Pueblo Fauna. John Olsen, R. Kyle Bocinsky. Ann Arbor, MI: Museum of Anthropology, University of Michigan. 2018 ( tDAR id: 445469) ; doi:10.6067/XCV80G3NZN

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: Grasshopper

Column Name Data Type Type Category Coding Sheet Ontology Search
Color Grasshopper Pueblo Burning
VARCHAR  Uncoded Value Fauna : Burning none none true
Portion Present VARCHAR  Uncoded Value uncategorized none none true
ID Grasshopper Fauna Identification Number
BIGINT  Uncoded Value Provenience and Context : Other none none true
Site Grasshopper Pueblo Site Number
VARCHAR  Uncoded Value Provenience and Context : Site none none true
Number Grasshopper Pueblo No. on Original Site card
BIGINT  Uncoded Value Provenience and Context : Other none none true
Taxon Grasshopper Pueblo Taxon
VARCHAR  Coded Value Fauna : Taxon Grasshopper-Taxon Fauna Taxon Ontology - Southwest US true
Age Grasshopper Pueblo Age
VARCHAR  Coded Value Fauna : Age Generated identity coding sheet for Age Fauna Age Ontology true
Sex Grasshopper Pueblo Sex
VARCHAR  Coded Value Fauna : Sex Generated identity coding sheet for Sex Fauna Sex Ontology true
Side Grasshopper Pueblo Side
VARCHAR  Coded Value Fauna : Side Generated identity coding sheet for Side Fauna Side Ontology true
Element Grasshopper Pueblo Element
VARCHAR  Coded Value Fauna : Element Generated identity coding sheet for Element Fauna Element Ontology true
Worked Grasshopper Pueblo Cultural Modification
VARCHAR  Coded Value Fauna : Cultural Modification Generated identity coding sheet for Worked Fauna Worked Bone Ontology true
No of Specs Grasshopper Pueblo Number of Specimens
BIGINT  Count Fauna : Count none none true
Comments Grasshopper Pueblo Comments
VARCHAR  Uncoded Value Fauna : Other none none true
Provenience VARCHAR  Uncoded Value uncategorized none none true
Size Grasshopper Pueblo Animal Size
VARCHAR  Uncoded Value Fauna : Taxon none none true

File Information

  Name Size Creation Date Date Uploaded Access
Grasshopper--2cleaned.xlsx 585.59kb May 7, 2018 May 7, 2018 8:27:55 PM Public
Revised to un-map "SIZE" from the taxon ontology.
  • Translated version Grasshopper--2cleaned_translated.xlsx (756.04kb)
    Data column(s) in this dataset have been associated with coding sheet(s) and translated: