|
Comparative Archaeology Database, University of Pittsburgh
|
|
Trapiche Itapalluni Colonial Mining Dataset |
The data files METALS.CSV and METALS.XSLX provide information on metal artifacts recovered through excavations carried out at the Trapiche site. METALS.CSV is a comma delimited UTF-8 CSV file; METALS.XSLX contains the same data in the form of an Excel spreadsheet. Each line in the CSV file represents one metal artifact recovered from a particular context. There are 55 lines, each with 31 variables separated by commas. The variables are listed in the following order:
| 1 | Box N°: Numerical ID of box in which fragment of faunal remains was kept. |
| 2 | Inventory N°: A unique inventory number given to a bag. Numbered with the year of excavation (2018), followed by a unique number in sequential order. Note: Numbers were not given in any particular order, just in the way they were processed in the laboratory. |
| 3 | Sector: The site of Trapiche was divided into 3 sectors: A, B, and C. |
| 4 | Locus: Each individual context (level, feature, wall, etc.) was given a unique locus number. |
| 5 | Patio/ Recinto: Each unit was placed within a recinto (building) or a patio. |
| 6 | U.E.: Excavation Units 4-25, without a 5 or 22. Each unit without a cuad extension is 1x1m. |
| 7 | Cuad: If the unit had a 1x1m extension, it was given the designation Cuad 1. Additional extensions were numbered sequentially (2, 3, …). |
| 8 | U.C.: Collection Unit (Surface collection unit) |
| 9 | Bag N°: An alternative bag number, different from "Inventory Number". The first number of the bag number is the Locus. Then bags were numbered sequentially within each Locus. For example, within Locus 100, bags were numbered as such: Locus 100-1 for lithics, Locus 100-2 for botanicals, Locus 100-3 for fauna, Locus 100-4 for soil sample, etc.). |
| 10 | Bag _ of _: This indicates if there were multiple bags for the same sample. |
| 11 | Screen Size: Indicates size of screen used to recover artifact. |
| 12 | Total Bag Count: Number of metal artifacts in bag. |
| 13 | Total Bag Weight (g): Total weight of all material within a bag. |
| 14 | Excavators' Initials: Initials of excavator |
| 15 | Date Excavated (DD,MM,YY) |
| 16 | Curators' Initials: Initials of the laboratory assistant who curated sample. |
| 17 | Date Curated: Date of laboratory curation. (DD,MM,YY) |
| 18 | Analysts' Initials |
| 19 | Date analyzed (DD,MM,YY) |
| 20 | Metal Type: Nail, Door hinge, Slag, Scrap metal, Wire mesh. |
| 21 | Specific Name: Caret-head nail, lath, scupper etc. |
| 22 | Reference: For wrought Iron Caret Headed Nails: Mathers and Haecker 2011, pg 301-302 & Flint and Flint 2003, pg. 253
Flint, R., and Flint, Shirley Cushing. (2003). The Coronado expedition: From the distance of 460 years. Albuquerque: University of New Mexico Press. Mathers, C., and Haecker, C. (2011). Between Cíbola and Tiguex: a Vázquez de Coronado presence at el Morro National Monument, New Mexico. In Flint, R., and Cushin Flint, C. (eds.), The Latest Word from 1540: People, Places, and Portrayals of the Coronado Expedition, University of New Mexico Press, Albuquerque, pp. 286–307. |
| 23 | Material: Iron, Copper, Iron oxides, etc. |
| 24 | Specific Material: Wrought iron, Steel, etc. |
| 25 | Portion: Complete, fragment, ½, 2/3, 1/4 , etc. |
| 26 | Wear: Rust, Patina (green) |
| 27 | Description: Hand wrought? Cut? Anything particular to note? |
| 28 | Measurements: length, width, etc. |
| 29 | Indiv. Count: If the materials were the same, they were analyzed and entered in the same data line and counted and weighed together. If the materials from the same bag were different, they were entered into separate lines and counted and weighed separately. |
| 30 | Indiv. Weight (g): If the materials were the same, they were analyzed and entered in the same data line and counted and weighed together. If the materials from the same bag were different, they were entered into separate lines and counted and weighed separately. |
| 31 | Comments/Observations: General comments/observations |
The first line of the CSV file, for example, looks like this:
14,2018-040,B,000,Patio 3,-,-,25,UC25-2,1 de 1,-,1,3.72,JMS,13/8/2018,RP,3/8/18,SAK,31/10/2018,Nail,L-headed,Noel Hume 1970,Iron,Wrought iron,complete,rust,hand-wrought nail,body: 40.54 mm len; 5.25 mm wid,1,3.72,"lacking large head, appears to be bent at tip, square body"
This means that the artifact comes from box 14, Inventory 2018-040, sector B, locus 000, patio 3, U.C. 25, bag number UC25-2, is bag 1 of 1 with a total bag count of 1, and the total bag weight was 3.72g. It was excavated by JMS on 13/8/2018, curated by RP on 3/8/2018, and analysed by SAK on 31/10/2018. The artifact is a nail, specifically L-headed, the reference used was Noel Hume 1970. The material is iron, specifically wrought iron, was found as a complete portion, with rust, described as "hand-wrought nail." It was measured as body: 40.54 mm len; 5.25 mm wid, the individual count was 1, with an individual weight of 3.72g, the comments were "lacking large head, appears to be bent at tip, square body."
Download the file METALS.CSV (13.8 KB) or the file METALS.XLSX (52.6 KB).