Database

The database is stored in Microsoft Access 2002/XP format, and is located in the DATABASE folder. A *.TXT version of the database has been provided to facilitate import into other database management programs.

The database contains information gathered from unpublished field records and previous publications of the Megiddo Expedition. In addition to the Ceramic and Object data, an archive of Object and Site Photographs has been included.

Download the Access Database

Download the Database in Spreadsheet Form

Download a Spreadsheet of Objects

Below is a list of the field names used in the Ceramic and Object data table, and a brief description of what is contained in the field.

Fieldname
Data Type
Description
OBJ_PLATE# Number Megiddo III Object Plate Publication # Sequence
OBJ_PLATE Number Megiddo III Object Plate #
PUB_PLATE# Number Megiddo III Ceramic Publication # Sequence
PUB_PLATE Number Megiddo III Ceramic Publication Plate #
Harrison Type Group Text Dr. Timothy Harrison's Ceramic Typology
Appendix B Order Number Order for Appendix B Report
PUBTYPE Text Pottery type in Megiddo I/II publication
OLDTYPE Text Old Pottery type (at time of excavation?)
LOCUS Number Locus number
LOCUSEXT Text Locus extension (N,S,E,W,+,-,=)
LOCUSDES Text Locus description
X_COORD Number ArcView Coordinates
Y_COORD Number ArcView Coordinates
PLAN Text Published Megiddo Plan (Megiddo I and II)
STR Text Stratum number
AREA Text Area of Site
SQUARE Text Excavation square
REGNO Text Registration Number/Field Number
QTY Number Number of instances of Object
CLASSIFICATION Text Object Type
MATERIAL Text Material / Composition
PUBLICATION Text Previous publication
PUBEX Yes/No Example illustrated in publication
OINUMBER Number Oriental Institute Accession Number Sequence
DMS Text Dimensions
Weight Text Weight in grams
PHOTO # Text Photo number
Drawn Yes/No Drawing available
Drawing Text Scale of Drawing
DOF Date/Time Date of Finding for Object
Kept Yes/No Kept at some point
Disposition Text Final Disposition
Condition Text Condition of Object
Firing Text Degree of Firing
Technique Text Manufacturing Technique
Texture Text Fabric Texture
Workmanship Text Quality of manufacture
FB_Color_1 Text Fabric Color
FB_Color_2 Text Fabric Color
FB_Core_Color Text Core Colour
IN_Den Text Inclusion Density
IN_Size Text Inclusion Size
IN_Type_Organic Yes/No Inclusion Type - Organic
IN_Type_Inorganic Yes/No Inclusion Type - Inorganic
IN_Color_1 Text Inclusion Color
IN_Color_2 Text Inclusion Color
SF_Wet Yes/No Wet-smoothed
SF_Rough Yes/No Rough finish
SF_Glaze Yes/No Glaze applied to surface
SF_Incised Yes/No Incised decoration
SF_Wash Yes/No Wash applied to surface
SF_Wash_Color Text Wash Color
SF_Wash_EXT Yes/No Wash on exterior
SF_Wash_INT Yes/No Wash on interior
SF_Slip Yes/No Slip applied to surface
SF_Slip_Color Text Slip Color
SF_Slip_EXT Yes/No Slip on exterior
SF_Slip_INT Yes/No Slip on interior
SF_Burnish Yes/No Burnish
SF_Burnish_Type Text Burnish Type
SF_Burnish_App Text Burnish Application
SF_Burnish_EXT Yes/No Burnish on exterior
SF_Burnish_INT Yes/No Burnish on interior
SF_Paint Yes/No Painted decoration
SF_Paint_Color_1 Text Paint Color
SF_Paint_Color_2 Text Paint Color
SF_Paint_Location Text Paint Location
SF_Paint_App Text Paint Application/Design
SF_Paint_EXT Yes/No Paint on exterior
SF_Paint_INT Yes/No Paint on interior
Field Notes Memo Information not recorded in another field
DRAWSHEET Yes/No Photocopy of Drawing
DATASHEET Yes/No Photocopy of Data form
Photo_File Text Filename of Photo