somestamps

World Definitive Issues

Databases and Stamp Collecting: Brief Description of all items

Here are quick links to this section (links to be added as I complete each page): the main page, a page description of the tables needed to database a large number of these stamps, links from each of these types of records to pages discussing in detail the variations that can be encountered: Brief description of all items / Mint singles / Mint multiples / Used singles / Used multiples / Slogans / Buenos Aires postmarks / Town and city postmarks / Pieces and covers / Perfins / "SERVICIO OFICIAL" / Departmental officials / Wrappers and entires, and a summary page in which I describe a notional schema for a database of many of these stamps.

This table considers each 5c Moreno item, including items that may contain a 5c Moreno combined with other values, such as a cover. It is the equivalent of an auction catalog. Illustrated below is an example. In the "Brief" table this item is one record, even though it contains ten different stamps, including a first printing 5c Moreno.

The attributes, and their types-text, number, etc, for the "Brief" table are:

  • issue [text]: (5c1E, 5c1Et, 5c1CLt, many); this is my terminology for each of the three printings of the 5c Moreno. All are on papers with the first watermark. The 1E paper is cream, and the 1CL paper is clay. The lower case t is for typographed printings. I leave a description of the relative position of the letters in the watermark-RA, which stands for "Republica Argentina" for the detail tables. The attribute "many" is for items that contain more than just the 5c Moreno.
  • primary item type [text]: (mint single, mint multiple, used single, used multiple, piece, cover, wrapper, entire)
  • secondary item type [text]: (normal, official, departmental); for the case of departmental, this table does not describe which government department. What about a perfin official? It looks like we will need a tertiary type!
  • tertiary item type [text]: (normal, perfin)
  • special cases [text] (none, includes other stamps besides 5c Moreno stamps-case of pieces and cover, includes combinations of 5c Moreno stamps, such as a normal used single with a 5c Moreno "SERVICIO OFICIAL" on cover); the "other" attribute is important when selecting items that have other stamps besides the 5c Moreno for future expansion of the database.
  • stamp quantity [integer]: (total number of 5c Moreno stamps for this item)
  • wrapper quantity [integer]: (for 5c Moreno wrappers)
  • entire quantity [integer]: (for 5c Moreno entires)
  • postal items [integer]: total number of different issues on a piece or cover
  • postal rate or face value [integer]: postal rate for covers and face value for pieces, since the latter may not capture the complete rate on the original postal history item they came from.

For the item below, the above attributes are:

  • issue [text]: many
  • primary item type [text]: cover
  • secondary item type [text]: normal
  • tertiary item type [text]: normal
  • special cases [text]: other
  • stamp quantity [integer]: 1
  • wrapper quantity [integer]: 0
  • entire quantity [integer]: 0
  • postal items [integer]: 10
  • postal rate or face value [real]: 63.5

Keep in mind that the information contained in the "Brief" table is brief. Any item in this table may have lots more information associated with it, and that's what other tables are for. Examples of specific queries that this table will satisfy completely are:

  • How many 5c Moreno stamps are there in this database for any combination of primary and secondary item types, such as "SERVICIO OFICIAL" used multiples? These items would all have the following attributes:
    • issue [text]: 5c1E, 5c1Et, and 5c1CLt (all)
    • primary item type [text]: used multiple
    • secondary item type [text]: official
    • tertiary item type [text]: normal
    • special cases [text]: none
    • stamp quantity [integer]: 4
    • wrapper quantity [integer]: 0
    • entire quantity [integer]: 0
    • postal items [integer]: 0
    • postal rate [real]: 20.0
  • How many regular issue 5c Moreno stamps are on covers with other values from the series?:
    • issue [text]: 5c1E, 5c1Et, and 5c1CLt (all)
    • primary item type [text]: cover
    • secondary item type [text]: normal
    • tertiary item type [text]: normal
    • special cases [text]: other
    • stamp quantity [integer]: 1 or more
    • wrapper quantity [integer]: any
    • entire quantity [integer]: any
    • postal items [integer]: 2 or more
    • postal rate [real]: greater than 5.0

 

 

About This Site | Site Map | Contact Us | External Links | ©2004-2008 Somestamps