Issues: Argentina 1899 Liberty Seated Definitives / Argentina San Martin 1923-35 Definitives / Argentina 1935-51 Definitives / China Architecture Definitives / Cuba First Issue 1855-1863 / France Merson / Germany Women and Sites / India Modern Definitives / Kenya Butterflies / Kenya Birds / Mexico Exporta / UK Castles High Values / US Prexies / US Americana / US American Design
Countries: Argentina / Australia / Austria / Bahamas / Benin / Bhutan / Brazil / Canada / China / Colombia / Cuba / Czechoslovakia / Denmark / Egypt / France / Germany / Ghana / Greece / Guinea / India / Indonesia / Ireland / Israel / Italy / Japan / Kenya / Malaysia / Mexico / New Zealand / Nigeria / Pakistan / Peru / Phillipines / Poland / Portugal / Russia / Saudi Arabia / South Africa / South Korea / Spain / Suriname / Sweden / Thailand / United Kingdom / United States / Venezuela / Vietnam
Databases and Stamp Collecting
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. |
|
Stamp collecting benefits from the use of databases. Many of the life-long studies carried out before the era of relational databases for very common stamps, such as the letter rate definitives of the U.S. and U.K. of the 19th and early 20th century, would have benefited from the use of an SQL database. Here, I discuss some basic issues related to databasing a definitives study. The main study I am concerned with these days is the Argentina 1935-51 issue, and the most common value of this issue is the 5c Moreno. I use the 5c Moreno as an example of the complexities encountered when designing a database to be used for a high volume definitives study. By high volume I mean that the number of items-singles, multiples, pieces, and covers-is in the neighborhood of 10,000 or more. Top right is a block of four from the first printing, below left is a single from the second printing, and below right is a block of four from the third and last printing, on clay paper.
|
![]() |
![]() |
![]() |


