Greg writes: I’m looking for a code system that is unique to every coin: year, mint, variety for a database that I’m creating for my collection. Even non-rare current issues. I would also like to know if there are any databases that I can incorporate into my own database. Thanks
The PCGS numbering system is a well thought out system for all U.S. coins and World Coins, at least the ones they currently grade. It would be nice to get their database on a disk or CD and be able to incorporate it as a look-up table in a database. So far they have expressed no interest in sharing or selling the system. You can use it yourself in your own dB but you have to key the data in yourself. You can get the system simply by buying a copy of the PCGS Population Report.
It is possible to create a query that updates a look-up table so that the data and the translation can be used if you again have the same coin in the same grade. Another idea. The real value in being able to identify specific coins is so they can be sorted for reports and lists. Try coming up with 3 letter codes, a la the Old New England Rare Coin system, to identify types; use a look-up table for grades so they are consistent. Some examples: GSG -Gold St. Guadens $20, MG$ Morgan Dollar, PC$ Peace Dollar etc.