What are the most common first names in the database? There are three ways a name can show up in the database:
- Name at the title of the artist’s page
- “Real Name”
- Aka name for a specific band
Right now I’m going to take a look at real names as I’m sure if I look at the regular name field I’ll get a lot of one off names I don’t care about (and about 1400 people that are Lord something or other). If we consider all bands and just whats been entered into the DB we get this (top20 based on real name):
|First Name||Real Name||Name||Diff|
Neat. Very important stuff here. The diff column shows you the difference in counts of real vs. regular name fields. A negative number indicates that name is used more as a common name (and is often a shortened version of a name). A positive number indicates that name is used less as a common name (and is often the longer version of a name). If we take into consideration that names like Mike and Michael are one and the same you’ll get a top5 maybe like this:
- Chris (Christopher did not show up with appreciable amounts)
I also noticed a trend of having real names in Cyrillic (Александр) and common name with the Latin alphabet (Alexander).
Getting only names from bands that have released full-lengths is going to be a little trickier. Maybe more on this and last names later.