Comparative Archaeology Database, University of Pittsburgh
URL: http://www.cadb.pitt.edu
Email: cadb@pitt.edu

Trapiche Itapalluni Colonial Mining Ceramic Dataset
Sarah A. Kennedy

Ceramic Measurements

The data files CERAMMEASUREMENTS.CSV and CERAMMEASUREMENTS.XSLX provide information on ceramic sherds recovered through excavations carried out at Trapiche site. CERAMICS.CSV is a comma delimited UTF-8 CSV file; CERAMICS.XSLX contains the same data in the form of an Excel spreadsheet. Each line in the CSV file represents one ceramic sherd. There are 3,033 lines, each with 24 variables separated by commas. The variables are listed in the following order:

1 N° de Caja (Box Number): Numerical ID of a box in which sherds were kept.
2 N° de Inventario (Inventory Number): A unique inventory number given to a bag to ID it. They are numbered with the year of excavation, 2018, followed by a unique number in sequential order. The numbers were not given in any particular order, just in the way they were processed in the laboratory.
3 Sector: The site of Trapiche Itapalluni was divided into sectors A,B,C,D, & E. Excavations only occurred in sectors A, B, & C.
4 Locus: Indicates the specific stratigraphic context of an artifacts provenance.
5 Patio/Recinto: Unique ID of recinto (building) or patio where artifact was recovered.
6 U.E.: Unit of excavation (1x1m)
7 Cuad: Indicates 1 m x 1 m square expansion of initial excavation unit. Units with multiple expansions have Cuad values greater than 1.
8 U.C.: Collection unit. For surface collection only. Done through a series of 2m x 2m mapped surface units.
9 N° de Bolsa (Bag 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 faunam etc.
10 Cantidad (Count) Total: Number of sherds in bag.
11 Peso (g) Total: Total weight of all materials within a bag.
12 Cantidad Diagnóstico: Total amount of diagnostic sherds, indicating that the sherd can be used to determine vessel form.
13 Peso (g) Diagnóstico: Total weight of diagnostic sherds.
14 Cantidad Un-Diagnóstico: Total amount of undiagnostic sherds, indicating that the sherd cannot be used to determine vessel form.
15 Peso (g) Un-Diagnóstico: Total weight of undiagnostic sherds.
16 Iniciales de Rec.: Initials of recorder.
17 Fecha de Analysis: Date analysed (DD, MM, YY)
18 Artifact ID
19 Artifact Weight (g): Weight of individual artifact.
20 Munsell Code: Every ceramic sherd's interior paste was given a Munsell color notation to denote the color of the clay matrix the sherd was made from. There are 10 Munsell Hue categories: R (Red), YR (Yellow Red), Y (Yellow), GY (Green Yellow), G (Green), BG (Blue Green), B (Blue), PB (Purple Blue), P (Purple), and RP (Red Purple). The different numbers denote different hues or subcategories of each color
21 Maximum Thickness (mm).
22 Minimum Thickness (mm).
23 Maximum Dimensions (mm).
24 Minimum Dimensions (mm).

The first line of the CSV file, for example, looks like this:

1,2018-001,C,000,Patio 5,-,-,01,UC01-1,32,140.02,5,65.97,28,79.68,SAK,4/12/18,UC01-1,3.43,7.5YR 5/1,7.35,5.6,31.27,16.43

This means that the ceramic sherd is in box number 1, inventory number 2018-001, sector C, locus 000, patio 5, was collected through surface collection unit 01, and in bag number UC01-1. The total number of sherds in the bag was 32, with a total weight of 140.02 grams. This bag had 5 diagnostic sherds weighing 65.97 grams, and 28 undiagnostic sherds weighing 79.68 grams. The recorder was SAK and was recorded on 4/12/2018. This is artifact UC01-1, weighing 3.43 grams, with munsell code 7.5YR (Yellow Red) 5/1, a max thickness of 7.35mm, a min thickness of 5.6mm, max dimension of 31.27mm, and a min dimension of 16.43.

Download the file CERAMMEASUREMENTS.CSV (370 KB) or the file CERAMMEASUREMENTS.XLSX (386 KB).


Return to the Table of Contents