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 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 |