artifact Queries

ARTIFACT QUERY 5: Select Artifact Attributes by Artifact Category

Artifact Category







View or Subset Data By





Choose one or more Sites

Chesapeake































Jamaica


Jamaica












Nevis





South Carolina


St. Kitts


Choose one or more Contexts
Select All Contexts

- or -

Write in one Context per line. You may use the wildcard character *. For example:
Choose one or more Feature Types






























































Choose one or more Feature Numbers
Select All Feature Numbers

- or -

Write in one Feature Number per line. You may use the wildcard character *. For example:
Choose one or more Unit Types









Choose one or more Stratigraphic Groups
Select All Stratigraphic Groups

- or -

Write in one Stratigraphic Group per line. You may use the wildcard character *. For example:
Choose one or more Phases
Select All Phases

- or -

Write in one Phase per line. You may use the wildcard character *. For example:
Choose Bead Attributes





























Choose Buckle Attributes














Choose Button Attributes



























Choose Ceramic Attributes






































Choose Glass Attributes

































Choose Tobacco Pipe Attributes


























Choose Utensil Attributes


















Choose All Other Artifact Attributes
























Subset Artifacts (OPTIONAL)






































Subset Artifacts (OPTIONAL)

Subset results by Ware















































































Subset results by Form
















































Subset Artifacts (OPTIONAL)























































































































































































































































































































































































































































































































































































































































































































































































What Does This Query Do?

ARTIFACT QUERY 5: Select Artifact Attributes by Artifact Category

This detailed query returns all data for a specific artifact type. You select the project and artifact type. In addition, you may choose specific context(s) or Unit Type(s) or Feature Number(s) or Feature Type (s) or Stratigraphic Group(s) or Phase(s) from which you would like to view data. Data are summarized at the context level.

Fields Returned

  • Completeness
  • Material
  • Manufacturing Technique
  • Structure
  • Form
  • Shape
  • End Treatment
  • Heat Treated
  • Color
  • Complex Shape
  • Number of Facets
  • Diaphaneity
  • Post Manufacturing Modification
  • Patination
  • Weather Eroded
  • Burned
  • Length
  • Width
  • Height
  • Weight
  • Size of Perforation I
  • Size of Perforation II
  • Mended
  • Conservation
  • Images
  • Notes
  • Casing Layer Color
  • Decorative Technique
  • Buckle Type
  • Buckle Completeness
  • Frame Plating
  • Weight
  • Marks
  • Burned
  • Conservation
  • Mended
  • Post Manufacturing Modification
  • Images
  • Notes
  • Part Material Manufacturing Technique Shape Dimensions
  • Decorative Technique
  • Completeness
  • Manufacturing Technique
  • ButtonFaceManufacturingTechnique
  • Button Type
  • Button Shape
  • ButtonJoinMethod
  • Face Material
  • Material
  • Button Color
  • Eye
  • Shank Style
  • Shank Material
  • Shank Condition
  • Appearance
  • Burned
  • Conservation
  • Post Manufacturing Modification
  • Back Stamp
  • Length
  • Width
  • Height
  • Weight
  • Diameter
  • Images
  • Notes
  • Decorative Technique
  • Material
  • Manufacturing Technique
  • Ware
  • Vessel Category
  • Form
  • Mended Form
  • Completeness
  • Exterior Glaze Type
  • Exterior Color
  • Interior Glaze Type
  • Interior Color
  • Oxidized Vs Reduced
  • Burned
  • Post Manufacturing Modification
  • Pattern Name
  • Pattern Reference
  • Stylistic Genre
  • Base Mark
  • Base Mark Reference
  • Base Mark Color
  • Sherd Thickness
  • Colono Sherd Thickness
  • Maximum Sherd Measurement
  • Sherd Weight
  • Mended Sherd Weight
  • Colonoware Rim Form
  • Colonoware Rim Angle
  • Rim Length
  • Rim Diameter
  • Mended Rim Diameter
  • MaxRimWidth
  • Images
  • Notes
  • Plog Diameter
  • Decorative Technique
  • Paste Inclusion
  • Wear Location, Ceramic Completeness, Wear Pattern
  • Material
  • Color
  • Vessel Category
  • Form
  • Completeness
  • Manufacturing Technique
  • Mold Type
  • Post Manufacturing Modification
  • Mended
  • Pontil Type
  • Total Container Height
  • Stemware Body Shape
  • Stemware Foot Shape
  • Stem Shape
  • Stem Length
  • Weather Eroded
  • Burned
  • Patination
  • Solarized
  • Sherd Size
  • Sherd Thickness
  • Sherd Weight
  • Length of Rim
  • Rim Diameter
  • Mended Rim Diameter
  • Plog Diameter
  • Conservation
  • Images
  • Notes
  • Bottle Element, Shape, ManuTech, Treatment, Height, Diameter
  • Decorative Technique, Applied Color, Stylistic Element
  • Marks, Mark Location
  • Tobacco Pipe Completeness
  • Material
  • Paste Color
  • Paste Inclusion
  • Manufacturing Technique
  • Glaze Type
  • Glaze Color
  • Post Manufacturing Modification
  • Bowl Form
  • Bowl Base Type
  • Mouth Piece Form
  • Stem Length
  • Exterior Stem Diameter
  • Bore Diameter Metric
  • Bore Diameter 64ths
  • Bowl Height
  • Bowl Volume
  • Maximum Bowl Diameter
  • Bowl Rim Diameter
  • Weight
  • Conservation
  • Images
  • Notes
  • Decoration
  • TextMark
  • Completeness
  • Form
  • Plating
  • Handle Decoration
  • Post Manufacturing Modification
  • Number of Fork Tines
  • Presence of Rat Tail
  • Length
  • Width
  • Weight
  • Burned
  • Marks
  • Conservation
  • Mended
  • Images
  • Notes
  • Specifics
  • Category
  • Form
  • Completeness
  • Material
  • Manufacturing Technique
  • Nail Head Type
  • Nail End Type
  • Nail Modification
  • Nail Length
  • Coin Date
  • Brick Size
  • Mended
  • Post Manufacturing Modification
  • Burned
  • Length
  • Width
  • Height
  • Weight
  • Marks
  • Notes
  • Conservation
  • Images
  • Notes

The Data Are Ordered By

  • ProjectID
  • ProjectID
  • Form
  • ProjectID
  • Form
  • ProjectID
  • Manufacturing Technique
  • Shape
  • ProjectID
  • Material
  • Button Type
  • ProjectID
  • Buckle Type
  • ProjectID
  • Material
  • ProjectID
  • Form