21PL72 and 21PL74 Database

Creator(s): Katherine Shillinglaw

Year: 2005

Summary

Database for 21PL72 and 21PL74.

Cite this Record

21PL72 and 21PL74 Database. Katherine Shillinglaw. 2005 ( tDAR id: 366250) ; doi:10.6067/XCV8XP7341

Data Set Structure

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

Table Information: tblArtifactInventory

Column Name Data Type Type Category Coding Sheet Ontology Search
Primary Key BIGINT  Uncoded Value uncategorized none none true
Accession No TEXT  Uncoded Value uncategorized none none true
State Site No TEXT  Uncoded Value uncategorized none none true
Lot Number TEXT  Uncoded Value uncategorized none none true
Catalogue No TEXT  Uncoded Value uncategorized none none true
Artifact No TEXT  Uncoded Value uncategorized none none true
Era TEXT  Uncoded Value uncategorized none none true
Material TEXT  Uncoded Value uncategorized none none true
Condition TEXT  Uncoded Value uncategorized none none true
Primary TEXT  Uncoded Value uncategorized none none true
Secondary TEXT  Uncoded Value uncategorized none none true
Trait 1 TEXT  Uncoded Value uncategorized none none true
Trait 3 TEXT  Uncoded Value uncategorized none none true
Trait 4 TEXT  Uncoded Value uncategorized none none true
Trait 4b TEXT  Uncoded Value uncategorized none none true
Trait 5 TEXT  Uncoded Value uncategorized none none true
side TEXT  Uncoded Value uncategorized none none true
Epiphysis TEXT  Uncoded Value uncategorized none none true
Count BIGINT  Uncoded Value uncategorized none none true
Weight DOUBLE  Uncoded Value uncategorized none none true
Comments TEXT  Uncoded Value uncategorized none none true
Trait 2 TEXT  Uncoded Value uncategorized none none true

Table Information: tblGridInventory

Column Name Data Type Type Category Coding Sheet Ontology Search
Grid TEXT  Uncoded Value uncategorized none none true
Catalogue No TEXT  Uncoded Value uncategorized none none true
Era TEXT  Uncoded Value uncategorized none none true
Material TEXT  Uncoded Value uncategorized none none true
Condition TEXT  Uncoded Value uncategorized none none true
Primary TEXT  Uncoded Value uncategorized none none true
Secondary TEXT  Uncoded Value uncategorized none none true
Trait 1 TEXT  Uncoded Value uncategorized none none true
Trait 2 TEXT  Uncoded Value uncategorized none none true
Trait 3 TEXT  Uncoded Value uncategorized none none true
Trait 4 TEXT  Uncoded Value uncategorized none none true
Trait 5 TEXT  Uncoded Value uncategorized none none true
Count BIGINT  Uncoded Value uncategorized none none true
Weight DOUBLE  Uncoded Value uncategorized none none true
Comments TEXT  Uncoded Value uncategorized none none true

Table Information: tblLotBook

Column Name Data Type Type Category Coding Sheet Ontology Search
Accession No TEXT  Uncoded Value uncategorized none none true
Catalogue No DOUBLE  Uncoded Value uncategorized none none true
Lot Number TEXT  Uncoded Value uncategorized none none true
State Site No TEXT  Uncoded Value uncategorized none none true
Bag No BIGINT  Uncoded Value uncategorized none none true
Type 1 ID TEXT  Uncoded Value uncategorized none none true
ID No TEXT  Uncoded Value uncategorized none none true
Type 2 ID TEXT  Uncoded Value uncategorized none none true
2 No TEXT  Uncoded Value uncategorized none none true
Section ID TEXT  Uncoded Value uncategorized none none true
North TEXT  Uncoded Value uncategorized none none true
North-P TEXT  Uncoded Value uncategorized none none true
East TEXT  Uncoded Value uncategorized none none true
East-P TEXT  Uncoded Value uncategorized none none true
Level TEXT  Uncoded Value uncategorized none none true
Begin Depth BIGINT  Uncoded Value uncategorized none none true
End Depth BIGINT  Uncoded Value uncategorized none none true
Incriment TEXT  Uncoded Value uncategorized none none true
Designation TEXT  Uncoded Value uncategorized none none true
Sterile TEXT  Uncoded Value uncategorized none none true
Sample TEXT  Uncoded Value uncategorized none none true
Date DATETIME  Uncoded Value uncategorized none none true
Initials TEXT  Uncoded Value uncategorized none none true
Description TEXT  Uncoded Value uncategorized none none true

Table Information: tblMather(Master)

Column Name Data Type Type Category Coding Sheet Ontology Search
Primary Key TEXT  Uncoded Value uncategorized none none true
Accession No TEXT  Uncoded Value uncategorized none none true
Site TEXT  Uncoded Value uncategorized none none true
Lot # TEXT  Uncoded Value uncategorized none none true
Catalogue No TEXT  Uncoded Value uncategorized none none true
Artifact # TEXT  Uncoded Value uncategorized none none true
Era TEXT  Uncoded Value uncategorized none none true
Material TEXT  Uncoded Value uncategorized none none true
Representation TEXT  Uncoded Value uncategorized none none true
Primary TEXT  Uncoded Value uncategorized none none true
Secondary TEXT  Uncoded Value uncategorized none none true
Taxon(Trait 1) TEXT  Uncoded Value uncategorized none none true
Element(Trait 2) TEXT  Uncoded Value uncategorized none none true
Trait 3 TEXT  Uncoded Value uncategorized none none true
Taphonomy 1(Trait 4) TEXT  Uncoded Value uncategorized none none true
Taphonomy 2(Trait 4) TEXT  Uncoded Value uncategorized none none true
Size(Trait 5) TEXT  Uncoded Value uncategorized none none true
Side TEXT  Uncoded Value uncategorized none none true
Epiphysis TEXT  Uncoded Value uncategorized none none true
Count DOUBLE  Uncoded Value uncategorized none none true
Weight DOUBLE  Uncoded Value uncategorized none none true
Comments TEXT  Uncoded Value uncategorized none none true

Data Table Relationships:

Type Local Table Foreign Table Column Relationships
ONE_TO_MANY tblLotBook tblMather(Master) Lot Number Lot #

Keywords

Culture
Middle Woodland • Woodland

Material
Ceramic • Chipped Stone • Fauna • Fire Cracked Rock • Ground Stone

Site Name
21PL0072 • 21PL0074

Site Type
Butchering / Kill Site • Hunting / Trapping

Investigation Types
Data Recovery / Excavation • Research Design / Data Recovery Plan

General
Bison Bison • Bison Kill / Processing Site • Laurel Complex

Geographic Keywords
Heartsville Coulee • Northeastern Plains • Red River Valley

Temporal Keywords
A.D. 340 to 650 • A.D. 770 to 990 • A.D. 860 to 1030

Spatial Coverage

min long: -97.067; min lat: 47.893 ; max long: -96.957; max lat: 47.958 ;

Individual & Institutional Roles

Contact(s): Katherine Shillinglaw

File Information

  Name Size Creation Date Date Uploaded Access
a21pl72-and-74-database.mdb 14.88mb Aug 29, 2011 11:51:18 AM Public