Archaeological Study of Colonial Chesapeake Culture, Comprehensive Artifact Catalog

Gregory Brown

Archaeological Study of Colonial Chesapeake Culture, Comprehensive Artifact Catalog

Part of the An Archaeological Study of Colonial Chesapeake Culture project

Year: 2004

Summary

Comprehensive artifact catalog for the Archaeological Study of Colonial Chesapeake Culture project, an NEH-funded comparative analysis of 18 early seventeenth-century archaeological sites in the Chesapeake region. The artifact catalog, composed of about 186,000 records, was created from the individual artifact catalogs for the 18 sites, combined and standardized into a single MS Access database.

The associated manual and coding conventions documents (below) explain in detail how to use the database effectively.

Linked to the Manual for the use of the comprehensive artifact catalog and to the Coding Conventions for the comprehensive artifact catalog.

Cite this Record

Archaeological Study of Colonial Chesapeake Culture, Comprehensive Artifact Catalog. Gregory Brown. 2004 ( tDAR id: 371712) ; doi:10.6067/XCV8057D0V

This Resource is Part of the Following Collections

Archaeological Study of Colonial Chesapeake Culture

Data Set Structure

Measurement Column

Count Column

Coded Column

Filename Column

Integration Column (has Ontology)

Table Information: ArtifactCatalog

Column Name	Data Type	Type	Category	Coding Sheet	Ontology	Search
KeyID	Arbitrary record number used for linking with other tables
KeyID	BIGINT	Uncoded Value	uncategorized	none	none	true
Site	The official state site number
Site	TEXT	Uncoded Value	uncategorized	none	none	true
SiteName	Site name
SiteName	TEXT	Uncoded Value	uncategorized	none	none	true
ContextNumber	An arbitrary number often assigned by the original collection repository. The context number creates a relationship between the artifact and provenience information. The number often is given as a Lot number or Excavation Unit number
ContextNumber	TEXT	Uncoded Value	uncategorized	none	none	true
WeightOz	The weight of the artifacts identified, in ounces
WeightOz	DOUBLE	Uncoded Value	uncategorized	none	none	true
WeightG	The weight of the artifacts identified, in grams
WeightG	DOUBLE	Uncoded Value	uncategorized	none	none	true
ObjectType	Description of the artifact
ObjectType	TEXT	Uncoded Value	uncategorized	none	none	true
ObjectSubType	More specific description or modifier (e.g., "felling" is a subtype of "axe")
ObjectSubType	TEXT	Uncoded Value	uncategorized	none	none	true
Material	The composition material of the artifact: Ceramic, Faunal, Floral, Glass, Lithic, Metal, Pottery, Sample, Stone, Synthetic, and Unidentified
Material	TEXT	Uncoded Value	uncategorized	none	none	true
MaterialSubType	The type of material within the larger material categories, including breakdowns of ceramics into Earthenware, Stoneware, and Porcelain, etc.
MaterialSubType	TEXT	Uncoded Value	uncategorized	none	none	true
WareType	General ware type of a ceramic
WareType	TEXT	Uncoded Value	uncategorized	none	none	true
WareSubType	More specific ware type within a larger category
WareSubType	TEXT	Uncoded Value	uncategorized	none	none	true
VarietyAttributes	Type or variety of the object (i.e., (Button) Two Hole, or (Nail) Spatula Tip). Also defines the attributes of the object (i.e., (Lithic) Cortex or (Flint) European)
VarietyAttributes	TEXT	Uncoded Value	uncategorized	none	none	true
Taxonomy	Further information pertaining to the species of the faunal artifact represented in the Object Type field (i.e., (Mammal) Pig)
Taxonomy	TEXT	Uncoded Value	uncategorized	none	none	true
Temper	Temper material (ceramics)
Temper	TEXT	Uncoded Value	uncategorized	none	none	true
Technology	The manufacturing method used
Technology	TEXT	Uncoded Value	uncategorized	none	none	true
Glaze	Type and color of glaze
Glaze	TEXT	Uncoded Value	uncategorized	none	none	true
Paste	Paste, fabric, or body of ceramic; includes color of brick paste if identified
Paste	TEXT	Uncoded Value	uncategorized	none	none	true
SurfaceTreatment	Treatment to the surface of pottery during the manufacturing of the object, such as Cord-marked
SurfaceTreatment	TEXT	Uncoded Value	uncategorized	none	none	true
Decoration	Manufacture technique and decorative design if applicable
Decoration	TEXT	Uncoded Value	uncategorized	none	none	true
Color	Color of the object, not of design, such as Aqua colored Glass
Color	TEXT	Uncoded Value	uncategorized	none	none	true
BoreDiameter	Diameter of tobacco pipe stem bore
BoreDiameter	TEXT	Uncoded Value	uncategorized	none	none	true
MakersMarks	Description of a maker’s mark, be it initials or a design that is known to belong to a particular maker. Any additional comments can be found in Remarks
MakersMarks	TEXT	Uncoded Value	uncategorized	none	none	true
Dimensions	The dimensions and any information pertaining to the dimensions of the object
Dimensions	TEXT	Uncoded Value	uncategorized	none	none	true
Remarks	Any information not applicable to any of the above fields or elaboration of information found in other fields
Remarks	TEXT	Uncoded Value	uncategorized	none	none	true
MacCordLot	Lot number assigned to Howard MacCord excavation unit by Virginia Department of Historic Resources (VDHR)
MacCordLot	TEXT	Uncoded Value	uncategorized	none	none	true
Count	Number of fragments
Count	DOUBLE	Uncoded Value	uncategorized	none	none	true
Element	The part of the whole object that the artifact represents
Element	TEXT	Uncoded Value	uncategorized	none	none	true
Condition	The condition of the object
Condition	TEXT	Uncoded Value	uncategorized	none	none	true

Table Information: ArtifactCounts

Column Name	Data Type	Type	Category	Coding Sheet	Ontology	Search
SiteAbbrev	Abbreviation of site name
SiteAbbrev	TEXT	Uncoded Value	uncategorized	none	none	true
SiteName	Site name
SiteName	TEXT	Uncoded Value	uncategorized	none	none	true
WCTP 10-64	White clay tobacco pipes, 10/64 inch bore diameter
WCTP 10-64	BIGINT	Uncoded Value	uncategorized	none	none	true
WCTP 9-64	White clay tobacco pipes, 9/64 inch bore diameter
WCTP 9-64	BIGINT	Uncoded Value	uncategorized	none	none	true
WCTP 8-64	White clay tobacco pipes, 8/64 inch bore diameter
WCTP 8-64	BIGINT	Uncoded Value	uncategorized	none	none	true
WCTP 7-64	White clay tobacco pipes, 7/64 inch bore diameter
WCTP 7-64	BIGINT	Uncoded Value	uncategorized	none	none	true
WCTP 6-64	White clay tobacco pipes, 6/64 inch bore diameter
WCTP 6-64	BIGINT	Uncoded Value	uncategorized	none	none	true
WCTP 5-64	White clay tobacco pipes, 5/64 inch bore diameter
WCTP 5-64	BIGINT	Uncoded Value	uncategorized	none	none	true
WCTP 4-64	White clay tobacco pipes, 4/64 inch bore diameter
WCTP 4-64	BIGINT	Uncoded Value	uncategorized	none	none	true
WCTP Total	White clay tobacco pipes, all
WCTP Total	BIGINT	Uncoded Value	uncategorized	none	none	true
Terra Cotta Tobacco Pipes	Terra cotta tobacco pipes
Terra Cotta Tobacco Pipes	BIGINT	Uncoded Value	uncategorized	none	none	true
Case Bottle Fragments	Case bottle fragments
Case Bottle Fragments	BIGINT	Uncoded Value	uncategorized	none	none	true
Wine Bottle Fragments	Wine bottle fragments
Wine Bottle Fragments	BIGINT	Uncoded Value	uncategorized	none	none	true
Bottle Glass Total	Bottle glass fragments, total
Bottle Glass Total	BIGINT	Uncoded Value	uncategorized	none	none	true
Tin-Glazed Earthenware	Tin-glazed earthenware
Tin-Glazed Earthenware	BIGINT	Uncoded Value	uncategorized	none	none	true
North Devon Sgraffito	North Devon sgraffito
North Devon Sgraffito	BIGINT	Uncoded Value	uncategorized	none	none	true
North Italian Slipware	North Italian slipware
North Italian Slipware	BIGINT	Uncoded Value	uncategorized	none	none	true
Staffordshire Slipware	Staffordshire slipware
Staffordshire Slipware	BIGINT	Uncoded Value	uncategorized	none	none	true
North Devon Gravel-Tempered Earthenware	North Devon gravel-tempered earthenware
North Devon Gravel-Tempered Earthenware	BIGINT	Uncoded Value	uncategorized	none	none	true
North Devon Gravel-Free Earthenware	North Devon gravel-free earthenware
North Devon Gravel-Free Earthenware	BIGINT	Uncoded Value	uncategorized	none	none	true
Borderware	Borderware
Borderware	BIGINT	Uncoded Value	uncategorized	none	none	true
Buckley-type	Buckley-type earthenware
Buckley-type	BIGINT	Uncoded Value	uncategorized	none	none	true
Rhenish Blue and Grey Stoneware	Rhenish blue and gray stoneware
Rhenish Blue and Grey Stoneware	BIGINT	Uncoded Value	uncategorized	none	none	true
Rhenish Brown Stoneware	Rhenish brown stoneware
Rhenish Brown Stoneware	BIGINT	Uncoded Value	uncategorized	none	none	true
Rhenish Stoneware Unidentified	Rhenish stoneware, unidentified
Rhenish Stoneware Unidentified	BIGINT	Uncoded Value	uncategorized	none	none	true
English Brown Stoneware	English brown stoneware
English Brown Stoneware	BIGINT	Uncoded Value	uncategorized	none	none	true
White Salt-Glazed Stoneware	White salt-glazed stoneware
White Salt-Glazed Stoneware	BIGINT	Uncoded Value	uncategorized	none	none	true
Porcelain	Porcelain
Porcelain	BIGINT	Uncoded Value	uncategorized	none	none	true
Ceramics Total	Ceramic fragments, total
Ceramics Total	BIGINT	Uncoded Value	uncategorized	none	none	true
Food Drink Storage	Food and Drink Storage category
Food Drink Storage	BIGINT	Uncoded Value	uncategorized	none	none	true
Food Drink Preparation	Food and Drink Preparation category
Food Drink Preparation	BIGINT	Uncoded Value	uncategorized	none	none	true
Food Drink Consumption	Food and Drink Consumption category
Food Drink Consumption	BIGINT	Uncoded Value	uncategorized	none	none	true
Ceramics Native American Late Woodland	e Woodland (Native American) ceramics
Ceramics Native American Late Woodland	BIGINT	Uncoded Value	uncategorized	none	none	true
Wrought Nails	ught nails
Wrought Nails	BIGINT	Uncoded Value	uncategorized	none	none	true
Window Cames	Window cames
Window Cames	BIGINT	Uncoded Value	uncategorized	none	none	true
Locking Mechanisms	Locking mechanisms
Locking Mechanisms	BIGINT	Uncoded Value	uncategorized	none	none	true
Keys Key Hole Covers	Keys and key hole covers
Keys Key Hole Covers	BIGINT	Uncoded Value	uncategorized	none	none	true
Gun Parts Ammunition	Gun parts and ammunition
Gun Parts Ammunition	BIGINT	Uncoded Value	uncategorized	none	none	true
Armor Weaponry	Armor and weaponry
Armor Weaponry	BIGINT	Uncoded Value	uncategorized	none	none	true
Horse Furniture	Horse furniture
Horse Furniture	BIGINT	Uncoded Value	uncategorized	none	none	true
Personal Adornment	Personal adornment artifacts
Personal Adornment	BIGINT	Uncoded Value	uncategorized	none	none	true
Clothing Sewing Items	Clothing and sewing items
Clothing Sewing Items	BIGINT	Uncoded Value	uncategorized	none	none	true
Recreational Material	Recreational material
Recreational Material	BIGINT	Uncoded Value	uncategorized	none	none	true
Spoons Forks Knives	Spoons, forks, and knives
Spoons Forks Knives	BIGINT	Uncoded Value	uncategorized	none	none	true
Home Beautification Count	Home beautification artifacts
Home Beautification Count	BIGINT	Uncoded Value	uncategorized	none	none	true
Home Beautification Weight Grams	Home beautification artifacts, weight in grams
Home Beautification Weight Grams	DOUBLE	Uncoded Value	uncategorized	none	none	true
Bone Refuse Count	Bone refuse, fragments
Bone Refuse Count	BIGINT	Uncoded Value	uncategorized	none	none	true
Shell Refuse Count	Shell refuse, fragments
Shell Refuse Count	BIGINT	Uncoded Value	uncategorized	none	none	true
Roofing Tile Count	Roofing tiles, fragments
Roofing Tile Count	BIGINT	Uncoded Value	uncategorized	none	none	true
Flooring Tile Count	Flooring tiles, fragments
Flooring Tile Count	BIGINT	Uncoded Value	uncategorized	none	none	true
Yellow Brick Count	Yellow brick, fragments
Yellow Brick Count	BIGINT	Uncoded Value	uncategorized	none	none	true
Red Brick Count	Red brick, fragments
Red Brick Count	BIGINT	Uncoded Value	uncategorized	none	none	true
Brick Total Count	Brick, fragments
Brick Total Count	BIGINT	Uncoded Value	uncategorized	none	none	true
Bone Refuse Weight Grams	Bone refuse, weight in grams
Bone Refuse Weight Grams	DOUBLE	Uncoded Value	uncategorized	none	none	true
Shell Refuse Weight Grams	Shell refuse, weight in grams
Shell Refuse Weight Grams	DOUBLE	Uncoded Value	uncategorized	none	none	true
Roofing Tile Weight Grams	Roofing tiles, weight in grams
Roofing Tile Weight Grams	DOUBLE	Uncoded Value	uncategorized	none	none	true
Flooring Tile Weight Grams	Flooring tiles, weight in grams
Flooring Tile Weight Grams	DOUBLE	Uncoded Value	uncategorized	none	none	true
Yellow Brick Weight Grams	Yellow brick, weight in grams
Yellow Brick Weight Grams	DOUBLE	Uncoded Value	uncategorized	none	none	true
Red Brick Weight Grams	Red brick, weight in grams
Red Brick Weight Grams	DOUBLE	Uncoded Value	uncategorized	none	none	true
Brick Total Weight Grams	Brick, weight in grams
Brick Total Weight Grams	DOUBLE	Uncoded Value	uncategorized	none	none	true
Bone Refuse Weight Oz	Bone refuse, weight in ounces
Bone Refuse Weight Oz	DOUBLE	Uncoded Value	uncategorized	none	none	true
Shell Refuse Weight Oz	Shell refuse, weight in ounces
Shell Refuse Weight Oz	DOUBLE	Uncoded Value	uncategorized	none	none	true
Roofing Tile Weight Oz	Roofing tiles, weight in ounces
Roofing Tile Weight Oz	DOUBLE	Uncoded Value	uncategorized	none	none	true
Flooring Tile Weight Oz	Flooring tiles, weight in ounces
Flooring Tile Weight Oz	DOUBLE	Uncoded Value	uncategorized	none	none	true
Yellow Brick Weight Oz	Yellow brick, weight in ounces
Yellow Brick Weight Oz	DOUBLE	Uncoded Value	uncategorized	none	none	true
Red Brick Weight Oz	Red brick, weight in ounces
Red Brick Weight Oz	DOUBLE	Uncoded Value	uncategorized	none	none	true
Brick Total Weight Oz	Brick, weight in ounces
Brick Total Weight Oz	DOUBLE	Uncoded Value	uncategorized	none	none	true

Table Information: Authorities

Column Name	Data Type	Type	Category	Coding Sheet	Ontology	Search
FieldValue	Authority value
FieldValue	TEXT	Uncoded Value	uncategorized	none	none	true
TotalCount	Count of times authority value is currently used
TotalCount	DOUBLE	Uncoded Value	uncategorized	none	none	true
FieldName	Name of field to which authority value is attached
FieldName	TEXT	Uncoded Value	uncategorized	none	none	true
Parent	Parent value (not currently used on web site)
Parent	TEXT	Uncoded Value	uncategorized	none	none	true

Table Information: AuthorityCounts

Column Name	Data Type	Type	Category	Coding Sheet	Ontology	Search
FieldValue	Authority value
FieldValue	TEXT	Uncoded Value	uncategorized	none	none	true
TotalCount	Count of times authority value is currently used
TotalCount	BIGINT	Uncoded Value	uncategorized	none	none	true
FieldName	Name of field to which authority value is attached
FieldName	TEXT	Uncoded Value	uncategorized	none	none	true

Table Information: BasicData

Column Name	Data Type	Type	Category	Coding Sheet	Ontology	Search
SiteAbbrev	Site abbreviation used on web site
SiteAbbrev	TEXT	Uncoded Value	uncategorized	none	none	true
SiteSummaryPage	Name of site summary page on web site
SiteSummaryPage	TEXT	Uncoded Value	uncategorized	none	none	true
SitePlanFileName	Primary site plan image file
SitePlanFileName	TEXT	Uncoded Value	uncategorized	none	none	true
SiteName	Site name
SiteName	TEXT	Uncoded Value	uncategorized	none	none	true
SiteDates	Approximate dates of site occupation
SiteDates	TEXT	Uncoded Value	uncategorized	none	none	true
StateSiteNumber	State site number
StateSiteNumber	TEXT	Uncoded Value	uncategorized	none	none	true
ArtifactImages	Number of images in Artifact Gallery section of web site
ArtifactImages	BIGINT	Uncoded Value	uncategorized	none	none	true
SurferImages	Number of images in Artifact Distributions section of web site
SurferImages	BIGINT	Uncoded Value	uncategorized	none	none	true
MiddenImages	Number of images in Midden Analysis section of web site
MiddenImages	BIGINT	Uncoded Value	uncategorized	none	none	true
ID	Primary key
ID	BIGINT	Uncoded Value	uncategorized	none	none	true

Table Information: ContextRecords

Column Name	Data Type	Type	Category	Coding Sheet	Ontology	Search
KeyID	Arbitrary record number used for linking with other tables
KeyID	BIGINT	Uncoded Value	uncategorized	none	none	true
NoOfRecords	Number of records associated with this provenience in artifact table
NoOfRecords	BIGINT	Uncoded Value	uncategorized	none	none	true
NoOfArtifacts	Number of fragments associated with this provenience in artifact table
NoOfArtifacts	BIGINT	Uncoded Value	uncategorized	none	none	true
Site	The official state site number
Site	TEXT	Uncoded Value	uncategorized	none	none	true
SiteName	Site name
SiteName	TEXT	Uncoded Value	uncategorized	none	none	true
ContextNumber	An arbitrary number often assigned by the original collection repository. The context number creates a relationship between the artifact and provenience information. The number often is given as a Lot number or Excavation Unit number
ContextNumber	TEXT	Uncoded Value	uncategorized	none	none	true
DepositType	Field used to standardize context descriptions
DepositType	TEXT	Uncoded Value	uncategorized	none	none	true
DepositSubType	Field used to standardize context descriptions
DepositSubType	TEXT	Uncoded Value	uncategorized	none	none	true
ShortTitle	Field used to standardize context descriptions
ShortTitle	TEXT	Uncoded Value	uncategorized	none	none	true
ContextDescription	Original context description
ContextDescription	TEXT	Uncoded Value	uncategorized	none	none	true
CenterX	East coordinate used for distribution mapping, derived by determining the center point of the excavation unit
CenterX	DOUBLE	Uncoded Value	uncategorized	none	none	true
CenterY	North coordinate used for distribution mapping, derived by determining the center point of the excavation unit
CenterY	DOUBLE	Uncoded Value	uncategorized	none	none	true
GridNorthCoord	Value of the northwest corner coordinate of the excavation unit in meters from arbitrary datum
GridNorthCoord	DOUBLE	Uncoded Value	uncategorized	none	none	true
GridEastCoord	Value of the northwest corner coordinate of the excavation unit in meters from arbitrary datum
GridEastCoord	DOUBLE	Uncoded Value	uncategorized	none	none	true
NorthingY	North coordinate
NorthingY	DOUBLE	Uncoded Value	uncategorized	none	none	true
EastingX	East coordinate
EastingX	DOUBLE	Uncoded Value	uncategorized	none	none	true
HorizLoc	Hoizontal location
HorizLoc	TEXT	Uncoded Value	uncategorized	none	none	true
ExcavationUnit	Excavation unit number
ExcavationUnit	TEXT	Uncoded Value	uncategorized	none	none	true
FeatureNumber	Feature number
FeatureNumber	TEXT	Uncoded Value	uncategorized	none	none	true
StratLevel	Stratigraphic level
StratLevel	TEXT	Uncoded Value	uncategorized	none	none	true
Provenience	General provenience
Provenience	TEXT	Uncoded Value	uncategorized	none	none	true
Area	Site area or portion
Area	TEXT	Uncoded Value	uncategorized	none	none	true
UnitSize	Unit size
UnitSize	TEXT	Uncoded Value	uncategorized	none	none	true
SizeMultiple	Multiplication factor used to standardize differing excavation unit sizes
SizeMultiple	DOUBLE	Uncoded Value	uncategorized	none	none	true
SCNumber	Surface collection identification number
SCNumber	TEXT	Uncoded Value	uncategorized	none	none	true
SCLetter	Surface collection identification letter
SCLetter	TEXT	Uncoded Value	uncategorized	none	none	true
MacCordUnit	Unit number used in Howard MacCord excavation
MacCordUnit	TEXT	Uncoded Value	uncategorized	none	none	true
MacCordAccNumber	Accession number used in Howard MacCord excavation
MacCordAccNumber	DOUBLE	Uncoded Value	uncategorized	none	none	true
JPPMLot	Lot designation assigned by Catherine Alston (Jefferson Patterson Park and Museum) for standardization of artifact distribution
JPPMLot	DOUBLE	Uncoded Value	uncategorized	none	none	true
JPPMDistributionMap	Lot designation assigned by Catherine Alston (Jefferson Patterson Park and Museum) for standardization of artifact distribution. Used in artifact distribution mapping?
JPPMDistributionMap	TEXT	Uncoded Value	uncategorized	none	none	true
ExcavationMethod	Excavation method
ExcavationMethod	TEXT	Uncoded Value	uncategorized	none	none	true
ScreenType	Screen type
ScreenType	TEXT	Uncoded Value	uncategorized	none	none	true
FeatureType	Feature type
FeatureType	TEXT	Uncoded Value	uncategorized	none	none	true
BasinType	Basin type (for features)
BasinType	TEXT	Uncoded Value	uncategorized	none	none	true
TemporalPeriod	Period of deposition
TemporalPeriod	TEXT	Uncoded Value	uncategorized	none	none	true
ContextType	Context type
ContextType	TEXT	Uncoded Value	uncategorized	none	none	true
Remarks	Comments
Remarks	TEXT	Uncoded Value	uncategorized	none	none	true
ExcavatorsNotes	Excavator's notes
ExcavatorsNotes	TEXT	Uncoded Value	uncategorized	none	none	true
SupervisorsNotes	Supervisor's notes
SupervisorsNotes	TEXT	Uncoded Value	uncategorized	none	none	true
ContextLater	Context number of the stratigraphically immediately later context
ContextLater	TEXT	Uncoded Value	uncategorized	none	none	true
ContextEarlier	Context number of the stratigraphically immediately earlier context
ContextEarlier	TEXT	Uncoded Value	uncategorized	none	none	true
TPQ	Terminus post quem date
TPQ	TEXT	Uncoded Value	uncategorized	none	none	true
PlanShape	Plan shape
PlanShape	TEXT	Uncoded Value	uncategorized	none	none	true
ProfileShape	Profile shape
ProfileShape	TEXT	Uncoded Value	uncategorized	none	none	true
SoilType	Soil type
SoilType	TEXT	Uncoded Value	uncategorized	none	none	true
SoilTexture	Soil texture
SoilTexture	TEXT	Uncoded Value	uncategorized	none	none	true
MunsellColor	Munsell soil color
MunsellColor	TEXT	Uncoded Value	uncategorized	none	none	true
Width	Width of feature in cm
Width	TEXT	Uncoded Value	uncategorized	none	none	true
XCoord	East coordinate of piece-plotted artifact
XCoord	TEXT	Uncoded Value	uncategorized	none	none	true
YCoord	North coordinate of piece-plotted artifact
YCoord	TEXT	Uncoded Value	uncategorized	none	none	true
ZCoord	Depth of piece-plotted artifact
ZCoord	TEXT	Uncoded Value	uncategorized	none	none	true
ExcavatedBy	Person excavating the context
ExcavatedBy	TEXT	Uncoded Value	uncategorized	none	none	true
ExcavatedDate	Date context was excavated
ExcavatedDate	DATETIME	Uncoded Value	uncategorized	none	none	true
Length	Length of feature in cm
Length	TEXT	Uncoded Value	uncategorized	none	none	true
Depth	Depth of feature in cm
Depth	TEXT	Uncoded Value	uncategorized	none	none	true

Table Information: dbo_DepositTypes

Column Name	Data Type	Type	Category	Coding Sheet	Ontology	Search
DepositType	TEXT	Uncoded Value	uncategorized	none	none	true
DepositSubType	TEXT	Uncoded Value	uncategorized	none	none	true

Table Information: ImageCategories

Column Name	Data Type	Type	Category	Coding Sheet	Ontology	Search
CategoryID	Category ID, primary key
CategoryID	BIGINT	Uncoded Value	uncategorized	none	none	true
Category	Category name
Category	TEXT	Uncoded Value	uncategorized	none	none	true
PhotoType	Section of web site to which category is applied (Artifact Gallery, Artifact Distributions, or Midden Analysis)
PhotoType	TEXT	Uncoded Value	uncategorized	none	none	true

Table Information: Images

Column Name	Data Type	Type	Category	Coding Sheet	Ontology	Search
ImageID	Auto-incremented ID number, primary key
ImageID	BIGINT	Uncoded Value	uncategorized	none	none	true
SiteAbbrev	Site abbreviation
SiteAbbrev	TEXT	Uncoded Value	uncategorized	none	none	true
PhotoType	Section of web site to which category is applied (Artifact Gallery, Artifact Distributions, or Midden Analysis)
PhotoType	TEXT	Uncoded Value	uncategorized	none	none	true
PhotoFileName	File name
PhotoFileName	TEXT	Uncoded Value	uncategorized	none	none	true
SidebarCaption	Caption to show in sidebar
SidebarCaption	TEXT	Uncoded Value	uncategorized	none	none	true
PhotoCaption	Caption
PhotoCaption	TEXT	Uncoded Value	uncategorized	none	none	true
PhotoDetailedCaption	Detailed caption
PhotoDetailedCaption	TEXT	Uncoded Value	uncategorized	none	none	true
CxtObjNumber	Provenience
CxtObjNumber	TEXT	Uncoded Value	uncategorized	none	none	true
CreditLine	Credit line
CreditLine	TEXT	Uncoded Value	uncategorized	none	none	true
MainGalleryPage	Order to display on web site
MainGalleryPage	TEXT	Uncoded Value	uncategorized	none	none	true
OrigFileName	Original file name
OrigFileName	TEXT	Uncoded Value	uncategorized	none	none	true
ID	Original ID number
ID	BIGINT	Uncoded Value	uncategorized	none	none	true

Table Information: ImagesToImageCategories

Column Name	Data Type	Type	Category	Coding Sheet	Ontology	Search
ImageID	Image ID value from Images table, used for linking Images to ImageCategories
ImageID	BIGINT	Uncoded Value	uncategorized	none	none	true
CategoryID	Category ID value from ImageCategories table, used for linking Images to ImageCategories
CategoryID	BIGINT	Uncoded Value	uncategorized	none	none	true

Table Information: InterpPapers

Column Name	Data Type	Type	Category	Coding Sheet	Ontology	Search
Title	Title
Title	TEXT	Uncoded Value	uncategorized	none	none	true
Author	Author
Author	TEXT	Uncoded Value	uncategorized	none	none	true
ArticleDate	Date published
ArticleDate	TEXT	Uncoded Value	uncategorized	none	none	true
Imprint	Imprint details
Imprint	TEXT	Uncoded Value	uncategorized	none	none	true
AuthoredBy	Author (string to display on web page, prefaced by the word by)
AuthoredBy	TEXT	Uncoded Value	uncategorized	none	none	true
ThumbImage	Thumbnail image of cover
ThumbImage	TEXT	Uncoded Value	uncategorized	none	none	true
SummaryText	Short summary text to be used on web site
SummaryText	TEXT	Uncoded Value	uncategorized	none	none	true
CFMPage	ColdFusion page (for interpretive papers)
CFMPage	TEXT	Uncoded Value	uncategorized	none	none	true
PDFFile	Name of PDF file
PDFFile	TEXT	Uncoded Value	uncategorized	none	none	true
PDFSize	Size of PDF file (to display on web site)
PDFSize	TEXT	Uncoded Value	uncategorized	none	none	true
PPTFile	Name of associated PowerPoint presentation
PPTFile	TEXT	Uncoded Value	uncategorized	none	none	true
PPTSize	Size of PPT file (to display on web site)
PPTSize	TEXT	Uncoded Value	uncategorized	none	none	true
ID	Auto-incremented ID number, primary key
ID	TEXT	Uncoded Value	uncategorized	none	none	true

Table Information: ObjectTypeCategories

Column Name	Data Type	Type	Category	Coding Sheet	Ontology	Search
ObjectType	Object type authority value
ObjectType	TEXT	Uncoded Value	uncategorized	none	none	true
ObjectSubType	Object subtype authority value
ObjectSubType	TEXT	Uncoded Value	uncategorized	none	none	true
Category	Category
Category	TEXT	Uncoded Value	uncategorized	none	none	true

Table Information: Reports

Column Name	Data Type	Type	Category	Coding Sheet	Ontology	Search
ReportOrder	Order in which report should appear on web site
ReportOrder	TEXT	Uncoded Value	uncategorized	none	none	true
Title	Title of report
Title	TEXT	Uncoded Value	uncategorized	none	none	true
Author	Author
Author	TEXT	Uncoded Value	uncategorized	none	none	true
ArticleDate	Date published
ArticleDate	TEXT	Uncoded Value	uncategorized	none	none	true
Imprint	Imprint details
Imprint	TEXT	Uncoded Value	uncategorized	none	none	true
AuthoredBy	Author (string to display on web page, prefaced by the word by)
AuthoredBy	TEXT	Uncoded Value	uncategorized	none	none	true
ThumbImage	Thumbnail image of cover
ThumbImage	TEXT	Uncoded Value	uncategorized	none	none	true
SummaryText	Short summary text to be used on web site
SummaryText	TEXT	Uncoded Value	uncategorized	none	none	true
PDFFile	Name of PDF file
PDFFile	TEXT	Uncoded Value	uncategorized	none	none	true
PDFSize	Size of PDF file (to display on web site)
PDFSize	TEXT	Uncoded Value	uncategorized	none	none	true
PPTFile	Name of associated PowerPoint presentation
PPTFile	TEXT	Uncoded Value	uncategorized	none	none	true
PPTSize	Size of PPT file (to display on web site)
PPTSize	TEXT	Uncoded Value	uncategorized	none	none	true
CFMPage	ColdFusion page (for interpretive papers)
CFMPage	TEXT	Uncoded Value	uncategorized	none	none	true
ID	Auto-incremented ID number, primary key
ID	BIGINT	Uncoded Value	uncategorized	none	none	true

Table Information: SiteNames

Column Name	Data Type	Type	Category	Coding Sheet	Ontology	Search
SiteName	Site name abbreviation used on web site
SiteName	TEXT	Uncoded Value	uncategorized	none	none	true
Site	State site number
Site	TEXT	Uncoded Value	uncategorized	none	none	true

Table Information: Sorts

Column Name	Data Type	Type	Category	Coding Sheet	Ontology	Search
QueryName	Name of query to appy sort to
QueryName	TEXT	Uncoded Value	uncategorized	none	none	true
SortName	Sort name
SortName	TEXT	Uncoded Value	uncategorized	none	none	true
ASCString	String for ascending sort (SQL)
ASCString	TEXT	Uncoded Value	uncategorized	none	none	true
DESCString	String for descending sort (SQL)
DESCString	TEXT	Uncoded Value	uncategorized	none	none	true
SortNameOrder	Order in which sort should appear in drop-down list
SortNameOrder	TEXT	Uncoded Value	uncategorized	none	none	true

Keywords

Culture
Euroamerican • Historic Native American

Material
Ceramic • Fauna • Glass • Macrobotanical • Mineral • Shell • Wood

Site Name
Bennett's Point (18QU28) • Burle's Town Land (18AN826) • Camden (44CE3) • Carter's Grove CG-8 (44JC647) • Chalkley (18AN711) • Chaney's Hills (18AN711) • Clifts Plantation (44WM33) • Compton (18CV279) • Homewood's Lot (18AN871) • Jordan's Journey (44PG302) • King's Reach (18CV83) • Mattapany (18ST390) • Old Chapel Field (18ST233) • Patuxent Point (18CV271) • Posey (18CH281) • Reverend Buck (44JC568) • Sandys (44JC802)

Site Type
House

Geographic Keywords
Chesapeake • Tidewater

Temporal Keywords
Early 17th century

Temporal Coverage

Calendar Date: 1600 to 1700

Spatial Coverage

min long: -77.498; min lat: 36.633 ; max long: -75.41; max lat: 39.368 ;

Individual & Institutional Roles

Principal Investigator(s): Julia King

File Information

	Name	Size	Creation Date	Date Uploaded	Access
	colches.mdb	38.94mb		Dec 10, 2011 12:11:42 PM	Public

Archaeological Study of Colonial Chesapeake Culture, Comprehensive Artifact Catalog

Summary

Cite this Record

This Resource is Part of the Following Collections

Data Set Structure

Table Information: ArtifactCatalog

Table Information: ArtifactCounts

Table Information: Authorities

Table Information: AuthorityCounts

Table Information: BasicData

Table Information: ContextRecords

Table Information: dbo_DepositTypes

Table Information: ImageCategories

Table Information: Images

Table Information: ImagesToImageCategories

Table Information: InterpPapers

Table Information: ObjectTypeCategories

Table Information: Reports

Table Information: SiteNames

Table Information: Sorts

Keywords

Temporal Coverage

Spatial Coverage

Individual & Institutional Roles

File Information

Add to a Collection

Included as part of :