Trade catalogue data

Creator(s): Penny Crook

Year: 2008

Summary

This dataset includes 35,610 individual prices for glass and ceramic tableware from 25 Australian, English, North American and Canadian store and mail-order catalogues dating from 1872 to 1907. It includes bibliographic information about each catalogue and detailed descriptions of each tableware set.

Cite this Record

Trade catalogue data. Penny Crook. 2008 ( tDAR id: 407298) ; doi:10.6067/XCV83T9K89

This Resource is Part of the Following Collections

Data Set Structure

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

Table Information: BiblioData

Column Name Data Type Type Category Coding Sheet Ontology Search
ID BIGINT  Uncoded Value uncategorized none none true
Vol VARCHAR  Uncoded Value uncategorized none none true
AuthorSurname VARCHAR  Uncoded Value uncategorized none none true
AuthorFirstName VARCHAR  Uncoded Value uncategorized none none true
OtherAuthorJoin VARCHAR  Uncoded Value uncategorized none none true
Other Authors VARCHAR  Uncoded Value uncategorized none none true
Editors BIGINT  Uncoded Value uncategorized none none true
Title VARCHAR  Uncoded Value uncategorized none none true
Journal BIGINT  Uncoded Value uncategorized none none true
Book Title VARCHAR  Uncoded Value uncategorized none none true
Editor VARCHAR  Uncoded Value uncategorized none none true
Publisher VARCHAR  Uncoded Value uncategorized none none true
PlaceOfPublish VARCHAR  Uncoded Value uncategorized none none true
PublishedMonth BIGINT  Uncoded Value uncategorized none none true
Year VARCHAR  Uncoded Value uncategorized none none true
JournalVol BIGINT  Uncoded Value uncategorized none none true
JournalNo BIGINT  Uncoded Value uncategorized none none true
Volume or Series Details VARCHAR  Uncoded Value uncategorized none none true
PageFrom BIGINT  Uncoded Value uncategorized none none true
PageTo BIGINT  Uncoded Value uncategorized none none true
Datefrom BIGINT  Uncoded Value uncategorized none none true
DateTo BIGINT  Uncoded Value uncategorized none none true
Source BIGINT  Uncoded Value uncategorized none none true
RefPlace VARCHAR  Uncoded Value uncategorized none none true
RefNo VARCHAR  Uncoded Value uncategorized none none true
ISBN VARCHAR  Uncoded Value uncategorized none none true
Format VARCHAR  Uncoded Value uncategorized none none true
Document Type VARCHAR  Uncoded Value uncategorized none none true
SourceType BIGINT  Uncoded Value uncategorized none none true
Keyword BIGINT  Uncoded Value uncategorized none none true
Comments VARCHAR  Uncoded Value uncategorized none none true
Entered by VARCHAR  Uncoded Value uncategorized none none true
DateEntered VARCHAR  Uncoded Value uncategorized none none true
DateUpdated VARCHAR  Uncoded Value uncategorized none none true

Table Information: SetItems

Column Name Data Type Type Category Coding Sheet Ontology Search
SetItemID BIGINT  Uncoded Value uncategorized none none true
SetID BIGINT  Uncoded Value uncategorized none none true
NoItems BIGINT  Uncoded Value uncategorized none none true
Category VARCHAR  Uncoded Value uncategorized none none true
ItemNameCategory VARCHAR  Uncoded Value uncategorized none none true
ItemNameSubCategory VARCHAR  Uncoded Value uncategorized none none true
Subheading VARCHAR  Uncoded Value uncategorized none none true
ItemName VARCHAR  Uncoded Value uncategorized none none true
Dimensions DOUBLE  Uncoded Value uncategorized none none true
DimMeas VARCHAR  Uncoded Value uncategorized none none true
Form VARCHAR  Uncoded Value uncategorized none none true
Price$ VARCHAR  Uncoded Value uncategorized none none true
PricePnd BIGINT  Uncoded Value uncategorized none none true
PriceShill BIGINT  Uncoded Value uncategorized none none true
PricePenc DOUBLE  Uncoded Value uncategorized none none true
PriceFrom VARCHAR  Uncoded Value uncategorized none none true
OrderNo VARCHAR  Uncoded Value uncategorized none none true
Notes VARCHAR  Uncoded Value uncategorized none none true
OriginalSpelling VARCHAR  Uncoded Value uncategorized none none true

Table Information: SetNames

Column Name Data Type Type Category Coding Sheet Ontology Search
Tsno BIGINT  Uncoded Value uncategorized none none true
SetID BIGINT  Uncoded Value uncategorized none none true
Category VARCHAR  Uncoded Value uncategorized none none true
SetName VARCHAR  Uncoded Value uncategorized none none true
OrderNo VARCHAR  Uncoded Value uncategorized none none true
Description VARCHAR  Uncoded Value uncategorized none none true
SameAs BIGINT  Uncoded Value uncategorized none none true
SameAsExtra VARCHAR  Uncoded Value uncategorized none none true
SameAsOtherCat BIGINT  Uncoded Value uncategorized none none true
DescriptionType VARCHAR  Uncoded Value uncategorized none none true
DetailedDescription VARCHAR  Uncoded Value uncategorized none none true
BriefDescription VARCHAR  Uncoded Value uncategorized none none true
Nodescription VARCHAR  Uncoded Value uncategorized none none true
Illustration VARCHAR  Uncoded Value uncategorized none none true
Body VARCHAR  Uncoded Value uncategorized none none true
NoPieces BIGINT  Uncoded Value uncategorized none none true
Price VARCHAR  Uncoded Value uncategorized none none true
Weight BIGINT  Uncoded Value uncategorized none none true
SourceID BIGINT  Uncoded Value uncategorized none none true
SourcePageRef VARCHAR  Uncoded Value uncategorized none none true
CountryOfSale VARCHAR  Uncoded Value uncategorized none none true
Year BIGINT  Uncoded Value uncategorized none none true
BodyType VARCHAR  Uncoded Value uncategorized none none true
BodyTypeQuestionable VARCHAR  Uncoded Value uncategorized none none true
Decoration VARCHAR  Uncoded Value uncategorized none none true
DecorationQuestionable VARCHAR  Uncoded Value uncategorized none none true
SecondaryDecoration VARCHAR  Uncoded Value uncategorized none none true
DecorationForm VARCHAR  Uncoded Value uncategorized none none true
TechniqueManufacture VARCHAR  Uncoded Value uncategorized none none true
TechniqueQuestionable VARCHAR  Uncoded Value uncategorized none none true
PatternName VARCHAR  Uncoded Value uncategorized none none true
PatternType VARCHAR  Uncoded Value uncategorized none none true
PatternCategory VARCHAR  Uncoded Value uncategorized none none true
ShapeName VARCHAR  Uncoded Value uncategorized none none true
ShapeType VARCHAR  Uncoded Value uncategorized none none true
ShapeCategory VARCHAR  Uncoded Value uncategorized none none true
FormProfile VARCHAR  Uncoded Value uncategorized none none true
FormProfileUpper VARCHAR  Uncoded Value uncategorized none none true
FormProfileMid VARCHAR  Uncoded Value uncategorized none none true
FormProfileLower VARCHAR  Uncoded Value uncategorized none none true
FormSection VARCHAR  Uncoded Value uncategorized none none true
Colour VARCHAR  Uncoded Value uncategorized none none true
TSname VARCHAR  Uncoded Value uncategorized none none true
Manufacturer VARCHAR  Uncoded Value uncategorized none none true
Provenance VARCHAR  Uncoded Value uncategorized none none true
Notes VARCHAR  Uncoded Value uncategorized none none true
FileName VARCHAR  Uncoded Value uncategorized none none true
CatalogueCategory VARCHAR  Uncoded Value uncategorized none none true
DateEntered VARCHAR  Uncoded Value uncategorized none none true
DateUpdated VARCHAR  Uncoded Value uncategorized none none true
NoImages BIGINT  Uncoded Value uncategorized none none true

Individual & Institutional Roles

Contact(s): Penny Crook

Record Identifiers

TDAR ID(s): 6865

FAIMS ID(s): repo.fedarch.org/dataset/6865

Notes

Redaction Note: Owing to the large file size the fields for descriptive terms have been removed from the dataset.

Rights & Attribution: © 2012 Penny Crook. All rights reserved.

File Information

  Name Size Creation Date Date Uploaded Access
tradecatdata.xlsx 4.81mb Aug 20, 2016 11:37:41 AM Public