The Pipe Database contains observations and measurements for all analyzed native-made and European-made pipes and pipe fragments recovered at the Fredricks site. The database is in dBase III format (*.dbf) and can be accessed using most quality database and spreadsheet applications.
Download Pipe Database (395 KB)
Description of the field headings used in the Pipe Database.
| Heading | Description |
| PKEY | A technical field used by the report software on the original CD-ROM. |
| CATALOG_NO | The Research Laboratories of Archaeology's catalog number of the artifact. |
| RAW_MATERI | Raw material type. |
| MORPHOLOGY | Pipe morphology. |
| PORTION | Portion of pipe represented. |
| BOWL_RIM | Bowl rim presence or absence (this field is not displayed in the report software, but does exist in the data file for analysis purposes). |
| BOWL_BODY | Bowl body presence or absence (this field is not displayed in the report software, but does exist in the data file for analysis purposes). |
| BOWL_BASE | Bowl base presence or absence (this field is not displayed in the report software, but does exist in the data file for analysis purposes). |
| STEM_BASE | Stem base presence or absence (this field is not displayed in the report software, but does exist in the data file for analysis purposes). |
| STEM_MIDS | Stem midsection presence or absence (this field is not displayed in the report software, but does exist in the data file for analysis purposes). |
| STEM_TIP | Stem tip presence or absence (this field is not displayed in the report software, but does exist in the data file for analysis purposes). |
| RIM_FORM | Bowl rim form (this field is not displayed in the report software, but does exist in the data file for analysis purposes). |
| BOWL_FORM | Bowl form. |
| STEM_FORM | Stem form (this field is not displayed in the report software, but does exist in the data file for analysis purposes). |
| DECORATION | Decoration. |
| RIM_DECORA | Rim decoration (this field is not displayed in the report software, but does exist in the data file for analysis purposes). |
| BOWL_DECOR | Bowl decoration (this field is not displayed in the report software, but does exist in the data file for analysis purposes). |
| STEM_DECOR | Stem decoration (this field is not displayed in the report software, but does exist in the data file for analysis purposes). |
| COUNT | Count. |
| STEM_DIAME | Stem diameter in millimeters (this field is not displayed in the report software, but does exist in the data file for analysis purposes). |
| BORE_DIAME | Bore diameter in millimeters (this field is not displayed in the report software, but does exist in the data file for analysis purposes). |
| ORIFICE_DI | Orifice diameter in millimeters (this field is not displayed in the report software, but does exist in the data file for analysis purposes). |
| BOWL_WALL_ | Bowl wall thickness in millimeters (this field is not displayed in the report software, but does exist in the data file for analysis purposes). |
| BOWL_HEIGH | Bowl height in millimeters (this field is not displayed in the report software, but does exist in the data file for analysis purposes). |
| STEM_LENGT | Stem length in millimeters (this field is not displayed in the report software, but does exist in the data file for analysis purposes). |
| BOWLTOSTEM | Length from bowl to stem in millimeters (this field is not displayed in the report software, but does exist in the data file for analysis purposes). |
| PIPE_NO | Pipe number (this field is not displayed in the report software, but does exist in the data file for analysis purposes). |
| COMMENT | Comment. |
| OADINFO | A technical field used by the report software on the original CD-ROM. |
| ADINFO | Context. |