New Philadelphia Excavation Database 2004-2011
Part of the New Philadelphia Archaeology project
Creator(s): Christopher Fennell; Kathryn Fay
Year: 2013
Summary
Database of artifacts excavated in the New Philadelphia, Illinois Archaeological Project, 2004-2011
Cite this Record
New Philadelphia Excavation Database 2004-2011. Christopher Fennell, Kathryn Fay. Urbana, Illinois: University of Illinois, Urbana-Champaign, IL. 2013 ( tDAR id: 392018) ; doi:10.6067/XCV8HQ40TF
URL: http://www.anthro.illinois.edu/
Data Set Structure
Table Information: Copy of DATA ENTRY TABLE
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Catalog Number | TEXT | Uncoded Value | uncategorized | none | none | true |
| Provenience | Include Unit Number,Feature Number and Layer and/or STP coordinates and Layer | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Bag Number | Your Choice-use if necc. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| H/P | If you do not know, choose Unidentified | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Count | Number of objects | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Material Type | Class 4 in ANCS--Only List Primary Material--Describe more if needed in comments--Documentation is an option | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Object Name | Text only--no codes | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Manu Tech | Code 1 in ANCS | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Dec Tech | Code 2 in ANCS | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Dec Tech cont'd | Additional space for another code--Describe in Comments if more space is necc. | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Dec Design | Code 3 in ANCS--only record primary element | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Dec Ele | Code 4 in ANCS--only record primary element | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Color | Code 5 in ANCS--Common color combinations may be recorded as they will be included in the drop down data entry list | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Object Part | Code 6 in ANCS--Common segment combinations may be recorded as they will be included in the drop down data entry list | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Material | Code 7 in ANCS--Common material combinations may be recorded as they will be included in the drop down data entry list | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| MM | Yes means a mark is present | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Manu Date | Usually Year Only--If you date an object, usually you need to cite a reference in Comments | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Material_Type
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| code | TEXT | Uncoded Value | uncategorized | none | none | true |
| text | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Miscelaneous
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| code | TEXT | Uncoded Value | uncategorized | none | none | true |
| text | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Object__name
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Object Name | TEXT | Uncoded Value | uncategorized | none | none | true |
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Object_Part
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Object Part | TEXT | Uncoded Value | uncategorized | none | none | true |
| Field2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Field3 | TEXT | Uncoded Value | uncategorized | none | none | true |
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: DATA ENTRY TABLE
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Catalog Number | TEXT | Uncoded Value | uncategorized | none | none | true |
| Provenience | Include Unit Number,Feature Number and Layer and/or STP coordinates and Layer | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| H/P | If you do not know, choose Unidentified | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Material Type | Class 4 in ANCS--Only List Primary Material--Describe more if needed in comments--Documentation is an option | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Object Name | Text only--no codes | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Manu Tech | Code 1 in ANCS | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Dec Tech | Code 2 in ANCS | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Dec Tech cont'd | Additional space for another code--Describe in Comments if more space is necc. | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Dec Design | Code 3 in ANCS--only record primary element | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Dec Ele | Code 4 in ANCS--only record primary element | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Color | Code 5 in ANCS--Common color combinations may be recorded as they will be included in the drop down data entry list | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Object Part | Code 6 in ANCS--Common segment combinations may be recorded as they will be included in the drop down data entry list | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Material | Code 7 in ANCS--Common material combinations may be recorded as they will be included in the drop down data entry list | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Manu Date | Usually Year Only--If you date an object, usually you need to cite a reference in Comments | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| Count | Number of objects | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| MM | Yes means a mark is present | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Bag Number | Your Choice-use if necc. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: Decorativedesign_3
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Field3 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Decorative Design | TEXT | Uncoded Value | uncategorized | none | none | true |
| Field2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Decorativeelement_4
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Decorative Element | TEXT | Uncoded Value | uncategorized | none | none | true |
| Field2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Field3 | TEXT | Uncoded Value | uncategorized | none | none | true |
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Decorativetech_2
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Decorative Technique | TEXT | Uncoded Value | uncategorized | none | none | true |
| Field2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Field3 | TEXT | Uncoded Value | uncategorized | none | none | true |
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: historic_prehistoric
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| code | TEXT | Uncoded Value | uncategorized | none | none | true |
| text | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Makers_mark
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| code | Yes means a mark is present | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| text | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Manufacturingtech_1
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Manufacturing Tech | TEXT | Uncoded Value | uncategorized | none | none | true |
| Field3 | TEXT | Uncoded Value | uncategorized | none | none | true |
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Material__7
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Material__7 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Field2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Field3 | TEXT | Uncoded Value | uncategorized | none | none | true |
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Color__5
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Color_5 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Field2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Field3 | TEXT | Uncoded Value | uncategorized | none | none | true |
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Data Table Relationships:
| Type | Local Table | Foreign Table | Column Relationships |
|---|---|---|---|
| ONE_TO_MANY | Object__name | DATA ENTRY TABLE | ID Object Name |
| ONE_TO_MANY | Manufacturingtech_1 | DATA ENTRY TABLE | ID Manu Tech |
| ONE_TO_MANY | Miscelaneous | DATA ENTRY TABLE | ID Provenience |
| ONE_TO_MANY | Color__5 | DATA ENTRY TABLE | ID Color |
| ONE_TO_MANY | Material_Type | DATA ENTRY TABLE | ID Material Type |
| ONE_TO_MANY | Material__7 | DATA ENTRY TABLE | ID Material |
| ONE_TO_MANY | Decorativetech_2 | DATA ENTRY TABLE | ID Dec Tech |
| ONE_TO_MANY | Makers_mark | DATA ENTRY TABLE | ID MM |
| ONE_TO_MANY | Object_Part | DATA ENTRY TABLE | ID Object Part |
| ONE_TO_MANY | Decorativedesign_3 | DATA ENTRY TABLE | ID Dec Design |
| ONE_TO_MANY | Decorativeelement_4 | DATA ENTRY TABLE | ID Dec Ele |
| ONE_TO_MANY | historic_prehistoric | DATA ENTRY TABLE | ID H/P |
Keywords
Material
Building Materials
•
Ceramic
•
Chipped Stone
•
Dating Sample
•
Fauna
•
Glass
•
Macrobotanical
•
Metal
•
Mineral
•
Pollen
•
Shell
•
Wood
Site Name
New Philadelphia, Illinois
Site Type
Archaeological Feature
•
Domestic Structure or Architectural Complex
•
Non-Domestic Structures
Investigation Types
Archaeological Overview
•
Data Recovery / Excavation
•
Methodology, Theory, or Synthesis
•
Reconnaissance / Survey
•
Research Design / Data Recovery Plan
•
Site Evaluation / Testing
•
Systematic Survey
Geographic Keywords
New Philadelphia, Pike County, Illinois
Temporal Keywords
archaic period, 19th and 20th centuries
Temporal Coverage
Calendar Date: -8000 to 2010
Spatial Coverage
min long: -90.986; min lat: 39.679 ; max long: -90.941; max lat: 39.711 ;
Individual & Institutional Roles
Contact(s): Christopher Fennell
File Information
| Name | Size | Creation Date | Date Uploaded | Access | |
|---|---|---|---|---|---|
| New-Philadelphia-Excavation-Database-2004-2011.mdb | 82.78mb | Feb 11, 2014 | Feb 11, 2014 5:34:29 AM | Public | |
| Database of artifacts excavated in the New Philadelphia, Illinois Archaeological Project, 2004-2011, in MS Access format | |||||