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

Table Information: tblCandlestick

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

Table Information: tblCeramics

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

Table Information: tblCoins

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

Table Information: tblComb

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

Table Information: tblCurtainRing

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

Table Information: tblGlassware

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

Table Information: tblGrommet

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

Table Information: tblGunflint

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

Table Information: tblGuns

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

Table Information: tblHinge

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

Table Information: C-Context

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

Table Information: tblHorseshoe

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

Table Information: tblJettonToken

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

Table Information: tblJewelry

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

Table Information: tblKey

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

Table Information: tblLeadShotSprue

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

Table Information: tblLeatherOrnaments

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

Table Information: tblLithic

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

Table Information: tblLock

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

Table Information: tblMedals

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

Table Information: tblNativeCeramics

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

Table Information: lkupCategories

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

Table Information: tblNeedleBodkin

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

Table Information: tblPin

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

Table Information: tblProjPoint

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

Table Information: tblScissors

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

Table Information: tblSmokersCompanion

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

Table Information: tblSnuffer

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

Table Information: tblSpurs

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

Table Information: tblStirrup

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

Table Information: tblSwordBlade

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

Table Information: tblTack

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

Table Information: lkupSubCategory

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

Table Information: tblUtensil

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

Table Information: tblWeights

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

Table Information: tblBaleSeal

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

Table Information: tblBead

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

Table Information: tblBit

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

Table Information: tblBuckle

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

Table Information: tblButtonCuffStud

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

Table Information: A-ArtifactCatalog

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

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