Hi Bruce, (
@Reidy12) as you know there are several active members contributing serial numbers "harvested" from various internet sites as well as a whole lot of members posting the serial numbers of their own collections. I process these numbers at the end of each month and upload them into a MS Access database. Since the folks harvesting serial numbers often are looking at the same internet sites, there are always duplicates in the monthly postings. I have a robust process for finding and eliminating duplicate serial numbers.
Last month I compiled 537 serial numbers from various threads in the Sansui forum. There were 16 duplicates in that initial batch. After cleaning up the formatting and dropping out invalid serial numbers, there were 492 valid serial numbers to add to the database. 101 of those matched serial numbers already in the database dropping the total to 391. After manually entering the valid non standard serial numbers and adding in a few new serial numbers I discovered when researching new, unreported Sansui models, a total of 415 serial numbers were added to the database in November 2023.
Weeding out duplicates is a routine part of processing the serial numbers each month. The most time consuming part of the monthly process is researching new, previously unreported models. The database catalogs 1,593 Sansui models. Every month turns up models not previously cataloged. Sansui had some very odd Model Naming Conventions. They were inconstant in using prefixes and especially suffixes. Words like Vintage, Extra, Limited, Premium and a range of added letters often are not reported properly. In many cases "new models" are simply a variation in the name of a model already cataloged. So every time a reported model doesn't match a model on file I conduct an internet search to find actual photograph of the model in question.
As far as the difference in the of the monthly report between May 2020 and November 2023 here are some milestones in the history of the database.
The database was started in December 2003 by AK member Morden2004. He maintained the database through October 2008. Between 12/02 and 10/08, 5,304 serial numbers were collected in the database. Many of these original serial numbers were "Harvested" from the internet by AK members.
I revived the database in 2017. AK was a very different forum. It now had two or three hundred thousands of members that could contribute to the database.
Here's a summary of it's growth.
10/08 - 5,304
12/17 - 6,775
12/18 - 8,149
12/19 - 8,976
12/20 - 10,848
12/21 - 22,785 (many thanks to AK member
@Peter lye for supercharging the serial number search)
12/22 - 31,222
11/23 - 34,839
There are several AK members in addition to Peter Lye that have made significant contributions to the growth of the database:
@Oilmaster Revived the practice of harvesting serial numbers from the internet
@Reidy12 Jumped in with both feet
@PE9ZZ A very active contributor
@karik57 An active contributor
@Monicker1 An active contributor
I'm thankful to all the many, many AK members that contribute. Every serial number improves the database. If you would like to contribute please post your serial numbers in the
2017 Sansui Serial Number Database thread. Please use this format: Model,Serial Number,AK Member name (or internet site) 9090DB,821234567,LBPete
Hope this information is helpful.
- Pete