Artifact Catalog, Site 18CH233, Colonial Encounters

Summary

This database was generated as part of the Colonial Encounters: The Lower Potomac River Valley at Contact, 1500-1720 AD project.

Cite this Record

Artifact Catalog, Site 18CH233, Colonial Encounters. Maryland Archaeological Conservation Laboratory. 2014 ( tDAR id: 393668) ; doi:10.6067/XCV8ST7QW7

URL: http://www.chesapeakearchaeology.org/index.cfm


Restricted Access Some or all of this resource's attached file(s) are not publicly accessible.

Data Set Structure

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

Table Information: B-tblSFMAIN

Column Name Data Type Type Category Coding Sheet Ontology
Photolink3 Hyperlink to photograph/photograph path
TEXT  Uncoded Value uncategorized none none
Photolink2 Hyperlink to photograph/photograph path
TEXT  Uncoded Value uncategorized none none
Photolink1 Hyperlink to photograph/photograph path
TEXT  Uncoded Value uncategorized none none
RecLastUpdate Last time record was updated
DATETIME  Uncoded Value uncategorized none none
VerifiedBy Name of reviewer
TEXT  Uncoded Value uncategorized none none
Verified Date of entry check
DATETIME  Uncoded Value uncategorized none none
Disputed Other possible interpretations
TEXT  Uncoded Value uncategorized none none
Remarks Additional notes
TEXT  Uncoded Value uncategorized none none
PostMod Postmodifications (NONE if not applicable)
TEXT  Uncoded Value uncategorized none none
Fashionability Object date range
TEXT  Uncoded Value uncategorized none none
MarkText Text of mark
TEXT  Uncoded Value uncategorized none none
Marks Type of mark (ie: makers mark)
TEXT  Uncoded Value uncategorized none none
Manufactory TEXT  Uncoded Value uncategorized none none
Country Country of origin
TEXT  Uncoded Value uncategorized none none
SubCategory Small Find subcategory (ie: Horseshoe, Saddle, Bit, Stirrup, Spurs)
TEXT  Uncoded Value uncategorized none none
Category Small Find category (ie: Horse Furniture)
TEXT  Uncoded Value uncategorized none none
Morphology TEXT  Uncoded Value uncategorized none none
Diameter Diameter of object (if applicable)
TEXT  Uncoded Value uncategorized none none
Height Height of object
TEXT  Uncoded Value uncategorized none none
Width Width of object
TEXT  Uncoded Value uncategorized none none
Length Length of object
TEXT  Uncoded Value uncategorized none none
Color3 Tertiary color
TEXT  Uncoded Value uncategorized none none
Color2 Secondary color
TEXT  Uncoded Value uncategorized none none
Color1 Primary color of artifact (if only 1, use only 1)
TEXT  Uncoded Value uncategorized none none
Recorder Name of Small Find recorder
TEXT  Uncoded Value uncategorized none none
RecordDate Date Small Find was entered
DATETIME  Uncoded Value uncategorized none none
Conserved Is the artifact conserved
BOOLEAN  Uncoded Value uncategorized none none
Location Where is the artifact located (ie: Jefferson Patterson Park)
TEXT  Uncoded Value uncategorized none none
SiteNo Site number
TEXT  Uncoded Value uncategorized none none
Site Site Name (Abbreviated)
TEXT  Uncoded Value uncategorized none none
NoOfObject Number of objects (redundancy from main artifact database)
BIGINT  Uncoded Value uncategorized none none
ObjectID Object ID number from main database
BIGINT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none

Table Information: tblCandlestick

Column Name Data Type Type Category Coding Sheet Ontology
Element TEXT  Uncoded Value uncategorized none none
BaseDiam TEXT  Uncoded Value uncategorized none none
ColumnDiam TEXT  Uncoded Value uncategorized none none
Nozzle TEXT  Uncoded Value uncategorized none none
HandleType TEXT  Uncoded Value uncategorized none none
DripPanType TEXT  Uncoded Value uncategorized none none
ColumnFeature TEXT  Uncoded Value uncategorized none none
FootShape TEXT  Uncoded Value uncategorized none none
Technology TEXT  Uncoded Value uncategorized none none
CandleType TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblCeramics

Column Name Data Type Type Category Coding Sheet Ontology
Style TEXT  Uncoded Value uncategorized none none
Marks TEXT  Uncoded Value uncategorized none none
VesselForm TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblCoins

Column Name Data Type Type Category Coding Sheet Ontology
CoinDate TEXT  Uncoded Value uncategorized none none
Denomination TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none

Table Information: tblComb

Column Name Data Type Type Category Coding Sheet Ontology
ToothSpacing TEXT  Uncoded Value uncategorized none none
ToothLength TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblCurtainRing

Column Name Data Type Type Category Coding Sheet Ontology
Completeness TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblGlassware

Column Name Data Type Type Category Coding Sheet Ontology
FootringType TEXT  Uncoded Value uncategorized none none
RimDiam TEXT  Uncoded Value uncategorized none none
FootringDiam TEXT  Uncoded Value uncategorized none none
Composition TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblGrommet

Column Name Data Type Type Category Coding Sheet Ontology
Dimensions TEXT  Uncoded Value uncategorized none none
Technology TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblGunflint

Column Name Data Type Type Category Coding Sheet Ontology
Cortex BOOLEAN  Uncoded Value uncategorized none none
Type TEXT  Uncoded Value uncategorized none none
Origin TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblGuns

Column Name Data Type Type Category Coding Sheet Ontology
Element TEXT  Uncoded Value uncategorized none none
SearType TEXT  Uncoded Value uncategorized none none
TriggerType TEXT  Uncoded Value uncategorized none none
MountScrews BIGINT  Uncoded Value uncategorized none none
LockPlateShape TEXT  Uncoded Value uncategorized none none
LockType TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblHinge

Column Name Data Type Type Category Coding Sheet Ontology
JointType TEXT  Uncoded Value uncategorized none none
Symmetry BOOLEAN  Uncoded Value uncategorized none none
Mounting TEXT  Uncoded Value uncategorized none none
HingeType TEXT  Uncoded Value uncategorized none none
SmallFind ID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: C-Context

Column Name Data Type Type Category Coding Sheet Ontology
MarkThis TEXT  Uncoded Value uncategorized none none
NewRecord TEXT  Uncoded Value uncategorized none none
ExcavatedDate DATETIME  Uncoded Value uncategorized none none
ExcavatedBy TEXT  Uncoded Value uncategorized none none
ZCoord TEXT  Uncoded Value uncategorized none none
YCoord TEXT  Uncoded Value uncategorized none none
XCoord TEXT  Uncoded Value uncategorized none none
Depth TEXT  Uncoded Value uncategorized none none
Width TEXT  Uncoded Value uncategorized none none
Length TEXT  Uncoded Value uncategorized none none
MunsellColor TEXT  Uncoded Value uncategorized none none
SoilTexture TEXT  Uncoded Value uncategorized none none
SoilType TEXT  Uncoded Value uncategorized none none
ProfileShape TEXT  Uncoded Value uncategorized none none
PlanShape TEXT  Uncoded Value uncategorized none none
TPQ TEXT  Uncoded Value uncategorized none none
ContextEarlier TEXT  Uncoded Value uncategorized none none
ContextLater TEXT  Uncoded Value uncategorized none none
SupervisorsNotes TEXT  Uncoded Value uncategorized none none
ExcavatorsNotes TEXT  Uncoded Value uncategorized none none
Remarks TEXT  Uncoded Value uncategorized none none
ContextType TEXT  Uncoded Value uncategorized none none
TemporalPeriod TEXT  Uncoded Value uncategorized none none
BasinType TEXT  Uncoded Value uncategorized none none
FeatureType TEXT  Uncoded Value uncategorized none none
ScreenType TEXT  Uncoded Value uncategorized none none
ExcavationMethod TEXT  Uncoded Value uncategorized none none
JPPMDistributionMap TEXT  Uncoded Value uncategorized none none
JPPMLot DOUBLE  Uncoded Value uncategorized none none
MacCordAccNumber DOUBLE  Uncoded Value uncategorized none none
MacCordUnit TEXT  Uncoded Value uncategorized none none
SCNumber TEXT  Uncoded Value uncategorized none none
SizeMultiple DOUBLE  Uncoded Value uncategorized none none
UnitSize TEXT  Uncoded Value uncategorized none none
Area TEXT  Uncoded Value uncategorized none none
Provenience TEXT  Uncoded Value uncategorized none none
StratLevel TEXT  Uncoded Value uncategorized none none
FeatureNumber TEXT  Uncoded Value uncategorized none none
ExcavationUnit TEXT  Uncoded Value uncategorized none none
HorizLoc TEXT  Uncoded Value uncategorized none none
EastingX DOUBLE  Uncoded Value uncategorized none none
NorthingY DOUBLE  Uncoded Value uncategorized none none
GridEastCoord DOUBLE  Uncoded Value uncategorized none none
GridNorthCoord DOUBLE  Uncoded Value uncategorized none none
CenterY DOUBLE  Uncoded Value uncategorized none none
CenterX DOUBLE  Uncoded Value uncategorized none none
ContextDescription TEXT  Uncoded Value uncategorized none none
ShortTitle TEXT  Uncoded Value uncategorized none none
DepositSubType TEXT  Uncoded Value uncategorized none none
DepositType TEXT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none
NoOfArtifacts BIGINT  Uncoded Value uncategorized none none
NoOfRecords BIGINT  Uncoded Value uncategorized none none
ContextID BIGINT  Uncoded Value uncategorized none none

Table Information: tblHorseshoe

Column Name Data Type Type Category Coding Sheet Ontology
Calkins BOOLEAN  Uncoded Value uncategorized none none
Fullering BOOLEAN  Uncoded Value uncategorized none none
NoNailHoles BIGINT  Uncoded Value uncategorized none none
HorseshoeType TEXT  Uncoded Value uncategorized none none
SmallFindsID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblJettonToken

Column Name Data Type Type Category Coding Sheet Ontology
DateRange TEXT  Uncoded Value uncategorized none none
Maker TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblJewelry

Column Name Data Type Type Category Coding Sheet Ontology
Completeness TEXT  Uncoded Value uncategorized none none
Decor TEXT  Uncoded Value uncategorized none none
Diameter TEXT  Uncoded Value uncategorized none none
JewelrySubtype TEXT  Uncoded Value uncategorized none none
JewelryType TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblKey

Column Name Data Type Type Category Coding Sheet Ontology
SolidShank BOOLEAN  Uncoded Value uncategorized none none
Collar BOOLEAN  Uncoded Value uncategorized none none
BitType TEXT  Uncoded Value uncategorized none none
BowType TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblLeadShotSprue

Column Name Data Type Type Category Coding Sheet Ontology
Completeness TEXT  Uncoded Value uncategorized none none
Condition TEXT  Uncoded Value uncategorized none none
ShotTechnology TEXT  Uncoded Value uncategorized none none
ShotSprue TEXT  Uncoded Value uncategorized none none
Caliber TEXT  Uncoded Value uncategorized none none
Weight TEXT  Uncoded Value uncategorized none none
Subtype TEXT  Uncoded Value uncategorized none none
Type TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblLeatherOrnaments

Column Name Data Type Type Category Coding Sheet Ontology
Plating TEXT  Uncoded Value uncategorized none none
Style TEXT  Uncoded Value uncategorized none none
LeatherThickness TEXT  Uncoded Value uncategorized none none
TineLength TEXT  Uncoded Value uncategorized none none
TineType TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblLithic

Column Name Data Type Type Category Coding Sheet Ontology
Source TEXT  Uncoded Value uncategorized none none
Period TEXT  Uncoded Value uncategorized none none
Type TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblLock

Column Name Data Type Type Category Coding Sheet Ontology
NoBolts TEXT  Uncoded Value uncategorized none none
KeyholeCover TEXT  Uncoded Value uncategorized none none
ShackleType TEXT  Uncoded Value uncategorized none none
Housing TEXT  Uncoded Value uncategorized none none
Shape TEXT  Uncoded Value uncategorized none none
LockType TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblMedals

Column Name Data Type Type Category Coding Sheet Ontology
Decoration TEXT  Uncoded Value uncategorized none none
ObjectText TEXT  Uncoded Value uncategorized none none
Thickness TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblNativeCeramics

Column Name Data Type Type Category Coding Sheet Ontology
Type TEXT  Uncoded Value uncategorized none none
InteriorTreatment TEXT  Uncoded Value uncategorized none none
ExteriorTreatment TEXT  Uncoded Value uncategorized none none
MinThickness TEXT  Uncoded Value uncategorized none none
MaxThickness TEXT  Uncoded Value uncategorized none none
Period TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: lkupCategories

Column Name Data Type Type Category Coding Sheet Ontology
Categories Category name lists
TEXT  Uncoded Value uncategorized none none

Table Information: tblNeedleBodkin

Column Name Data Type Type Category Coding Sheet Ontology
EarScoop TEXT  Uncoded Value uncategorized none none
EyeLength TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblPin

Column Name Data Type Type Category Coding Sheet Ontology
HeadType TEXT  Uncoded Value uncategorized none none
Technology TEXT  Uncoded Value uncategorized none none
Weight TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblProjPoint

Column Name Data Type Type Category Coding Sheet Ontology
Source TEXT  Uncoded Value uncategorized none none
Period TEXT  Uncoded Value uncategorized none none
PointType TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblScissors

Column Name Data Type Type Category Coding Sheet Ontology
HandleDecor TEXT  Uncoded Value uncategorized none none
HandleType TEXT  Uncoded Value uncategorized none none
BladeLength TEXT  Uncoded Value uncategorized none none
BladeWidth TEXT  Uncoded Value uncategorized none none
EyeRingDim TEXT  Uncoded Value uncategorized none none
Tip TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblSmokersCompanion

Column Name Data Type Type Category Coding Sheet Ontology
BasalNotch BOOLEAN  Uncoded Value uncategorized none none
SpineThickness TEXT  Uncoded Value uncategorized none none
ObjectSubtype TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblSnuffer

Column Name Data Type Type Category Coding Sheet Ontology
HandleType TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblSpurs

Column Name Data Type Type Category Coding Sheet Ontology
BuckleShape TEXT  Uncoded Value uncategorized none none
TerminalShape TEXT  Uncoded Value uncategorized none none
ChapeType TEXT  Uncoded Value uncategorized none none
StudType TEXT  Uncoded Value uncategorized none none
NeckLength TEXT  Uncoded Value uncategorized none none
RowelBoxDim TEXT  Uncoded Value uncategorized none none
StudLength TEXT  Uncoded Value uncategorized none none
ArmLength TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblStirrup

Column Name Data Type Type Category Coding Sheet Ontology
EyeLoop TEXT  Uncoded Value uncategorized none none
SideProfile TEXT  Uncoded Value uncategorized none none
PlatformType TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblSwordBlade

Column Name Data Type Type Category Coding Sheet Ontology
PointType TEXT  Uncoded Value uncategorized none none
Fuller BOOLEAN  Uncoded Value uncategorized none none
Tang TEXT  Uncoded Value uncategorized none none
SpineWidth TEXT  Uncoded Value uncategorized none none
KnuckleGuard BOOLEAN  Uncoded Value uncategorized none none
PommelShape TEXT  Uncoded Value uncategorized none none
Quillion TEXT  Uncoded Value uncategorized none none
ShellType TEXT  Uncoded Value uncategorized none none
HiltTech TEXT  Uncoded Value uncategorized none none
HiltMat TEXT  Uncoded Value uncategorized none none
HiltType TEXT  Uncoded Value uncategorized none none
Element TEXT  Uncoded Value uncategorized none none
MakersMark TEXT  Uncoded Value uncategorized none none
Technology TEXT  Uncoded Value uncategorized none none
BladeType TEXT  Uncoded Value uncategorized none none
Type TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblTack

Column Name Data Type Type Category Coding Sheet Ontology
TackElement TEXT  Uncoded Value uncategorized none none
Decoration TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: lkupSubCategory

Column Name Data Type Type Category Coding Sheet Ontology
SubCategory Subcategories
TEXT  Uncoded Value uncategorized none none
Category Main Category
TEXT  Uncoded Value uncategorized none none

Table Information: tblUtensil

Column Name Data Type Type Category Coding Sheet Ontology
Rattail BOOLEAN  Uncoded Value uncategorized none none
Tang TEXT  Uncoded Value uncategorized none none
ShapeBowl TEXT  Uncoded Value uncategorized none none
ShapeBlade TEXT  Uncoded Value uncategorized none none
ShapeHandle TEXT  Uncoded Value uncategorized none none
Technology TEXT  Uncoded Value uncategorized none none
Element TEXT  Uncoded Value uncategorized none none
Decor TEXT  Uncoded Value uncategorized none none
Plating TEXT  Uncoded Value uncategorized none none
Form TEXT  Uncoded Value uncategorized none none
UtensilType TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblWeights

Column Name Data Type Type Category Coding Sheet Ontology
Shape TEXT  Uncoded Value uncategorized none none
Marks TEXT  Uncoded Value uncategorized none none
WeightUnit TEXT  Uncoded Value uncategorized none none
Standard TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblBaleSeal

Column Name Data Type Type Category Coding Sheet Ontology
Shape TEXT  Uncoded Value uncategorized none none
SealMotif TEXT  Uncoded Value uncategorized none none
Sections BIGINT  Uncoded Value uncategorized none none
Type TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none
Duty TEXT  Uncoded Value uncategorized none none

Table Information: tblBead

Column Name Data Type Type Category Coding Sheet Ontology
Classification TEXT  Uncoded Value uncategorized none none
Dimensions TEXT  Uncoded Value uncategorized none none
AddMod TEXT  Uncoded Value uncategorized none none
Opacity TEXT  Uncoded Value uncategorized none none
Shape TEXT  Uncoded Value uncategorized none none
Construction TEXT  Uncoded Value uncategorized none none
ManufMeth TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblBit

Column Name Data Type Type Category Coding Sheet Ontology
BBRivetStyle TEXT  Uncoded Value uncategorized none none
BBRivetMat TEXT  Uncoded Value uncategorized none none
BBPlating TEXT  Uncoded Value uncategorized none none
BBCrossType TEXT  Uncoded Value uncategorized none none
BBStyle TEXT  Uncoded Value uncategorized none none
BridleBossType TEXT  Uncoded Value uncategorized none none
AddHardware TEXT  Uncoded Value uncategorized none none
PurchaseLength TEXT  Uncoded Value uncategorized none none
ShankLength TEXT  Uncoded Value uncategorized none none
Mouthpiece Length TEXT  Uncoded Value uncategorized none none
Mouthpiece TEXT  Uncoded Value uncategorized none none
BitType TEXT  Uncoded Value uncategorized none none
SmallFindsID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblBuckle

Column Name Data Type Type Category Coding Sheet Ontology
Element TEXT  Uncoded Value uncategorized none none
Motif TEXT  Uncoded Value uncategorized none none
Decoration TEXT  Uncoded Value uncategorized none none
Plating TEXT  Uncoded Value uncategorized none none
Tongue TEXT  Uncoded Value uncategorized none none
PinCenterMeasure TEXT  Uncoded Value uncategorized none none
PinOrientation TEXT  Uncoded Value uncategorized none none
PinTerminal TEXT  Uncoded Value uncategorized none none
HookType TEXT  Uncoded Value uncategorized none none
FrameType TEXT  Uncoded Value uncategorized none none
Technology TEXT  Uncoded Value uncategorized none none
Shape TEXT  Uncoded Value uncategorized none none
Dimensions TEXT  Uncoded Value uncategorized none none
BuckleType TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: tblButtonCuffStud

Column Name Data Type Type Category Coding Sheet Ontology
MakersMark TEXT  Uncoded Value uncategorized none none
Diameter TEXT  Uncoded Value uncategorized none none
Decoration TEXT  Uncoded Value uncategorized none none
Completeness TEXT  Uncoded Value uncategorized none none
SecondaryMat TEXT  Uncoded Value uncategorized none none
ShankType TEXT  Uncoded Value uncategorized none none
Shape TEXT  Uncoded Value uncategorized none none
ButtonType TEXT  Uncoded Value uncategorized none none
SmallFindID BIGINT  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none

Table Information: A-ArtifactCatalog

Column Name Data Type Type Category Coding Sheet Ontology
UTRecordID BIGINT  Uncoded Value uncategorized none none
MacCordLot TEXT  Uncoded Value uncategorized none none
Remarks TEXT  Uncoded Value uncategorized none none
Dimensions TEXT  Uncoded Value uncategorized none none
Condition TEXT  Uncoded Value uncategorized none none
MakersMarks TEXT  Uncoded Value uncategorized none none
BoreDiameter TEXT  Uncoded Value uncategorized none none
Element TEXT  Uncoded Value uncategorized none none
Color TEXT  Uncoded Value uncategorized none none
Decoration TEXT  Uncoded Value uncategorized none none
SurfaceTreatment TEXT  Uncoded Value uncategorized none none
Paste TEXT  Uncoded Value uncategorized none none
Glaze TEXT  Uncoded Value uncategorized none none
Technology TEXT  Uncoded Value uncategorized none none
Temper TEXT  Uncoded Value uncategorized none none
Taxonomy TEXT  Uncoded Value uncategorized none none
VarietyAttributes TEXT  Uncoded Value uncategorized none none
WareSubType TEXT  Uncoded Value uncategorized none none
WareType TEXT  Uncoded Value uncategorized none none
MaterialSubType TEXT  Uncoded Value uncategorized none none
Material TEXT  Uncoded Value uncategorized none none
ObjectSubType TEXT  Uncoded Value uncategorized none none
ObjectType TEXT  Uncoded Value uncategorized none none
WeightG TEXT  Uncoded Value uncategorized none none
WeightOz TEXT  Uncoded Value uncategorized none none
Count DOUBLE  Uncoded Value uncategorized none none
ContextNumber TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none
ObjectID BIGINT  Uncoded Value uncategorized none none

Data Table Relationships:

Type Local Table Foreign Table Column Relationships
ONE_TO_MANY lkupCategories lkupSubCategory Categories Category
ONE_TO_MANY tblJewelry B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblKey B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblWeights B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblGuns B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblJettonToken B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblBuckle B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblSnuffer B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblSmokersCompanion B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblButtonCuffStud B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblGunflint B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblLeadShotSprue B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblScissors B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblBaleSeal B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblCeramics B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblSwordBlade B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblBead B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblHinge B-tblSFMAIN SmallFind ID SmallFindID
ONE_TO_MANY tblProjPoint B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblLock B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblLeatherOrnaments B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblGlassware B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblCoins B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblTack B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblStirrup B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblComb B-tblSFMAIN SmallFindID SmallFindID
MANY_TO_ONE C-Context A-ArtifactCatalog ContextNumber ContextNumber SiteName SiteName
ONE_TO_MANY tblGrommet B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY A-ArtifactCatalog B-tblSFMAIN ObjectID ObjectID
ONE_TO_MANY tblUtensil B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblCurtainRing B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblBit B-tblSFMAIN SmallFindsID SmallFindID
ONE_TO_MANY tblCandlestick B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblLithic B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblMedals B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblSpurs B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblHorseshoe B-tblSFMAIN SmallFindsID SmallFindID
ONE_TO_MANY tblNeedleBodkin B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblPin B-tblSFMAIN SmallFindID SmallFindID
ONE_TO_MANY tblNativeCeramics B-tblSFMAIN SmallFindID SmallFindID

Spatial Coverage

min long: -76.442; min lat: 38.13 ; max long: -76.413; max lat: 38.166 ;

Record Identifiers

MAC Lab Accession Number(s): 2001.002

Notes

General Note: The following physical records are held at MAC Lab: Field Notes, Lab Notes, Maps, Artifact Catalog, Color Negatives, Kodachrome Slides, Photologs, List of Documentation, acid-free copy of all paper records stored in the secondary records storage room

General Note: Date Collected:MARCH- DECEMBER 2000

General Note: General Note: St. Mary’s College of Maryland received NEH (National Endowment for the Humanities) support for a collaborative, collections-based archaeological study focused on the lower Potomac River Valley between c. 1500 and 1720 AD. The resource is based on physical collections held by the Maryland Archaeological Conservation Laboratory.

File Information

  Name Size Creation Date Date Uploaded Access
Colonial-Encounters-Catalogs-18ST233-Acc-2001.002.accdb 2.39mb Aug 1, 2014 12:36:58 PM Confidential

Accessing Restricted Files

At least one of the files for this resource is restricted from public view. For more information regarding access to these files, please reference the contact information below

Contact(s): Maryland Archaeological Conservation Laboratory Federal Curator; Michael Smolek