#merlin – @bakanokiwami on Tumblr

bakanokiwami

TOP 10 CELEBRITIES & REAL PEOPLE FANDOMS ON AO3 BASED ON NUMBER OF FANWORKS (2009-2022)

To make these bar chart race, all series titles in the Celebrities & Real People Category on November 29 (or the closest date to it) of every year were copy-pasted from Wayback Machine to Google Sheets, rearranged according to number of fanworks, and then inputted to Flourish to turn into a bar chart race.
Locked fanworks aren't included in the count because Wayback Machine can’t view those, only Ao3 users can.
In 2009-2012, American Idol RPF was only in the Music & Bands category. By 2013, it was categorized to Celebrities & Real People and TV Shows instead. Since its 2009-2012 were high enough to rank in the top 10 in this category, I've decided to show it here in the bar chart.
After American Idol RPF changed categories, it seems to have lost half its fanworks. There aren't much archives of the American Idol RPF page, but I believe it was because the tags of singers who participated in this show were removed from its subtags.
Japanese Actor RPF was reduced to 9.66% of its total fanworks by 2015 because Johnny's Entertainment was removed from its subtags.
British Actor RPF was reduced to around 70% of its total fanworks by 2017 because RPF of various media was removed from its subtags.
Music RPF was not in the Celebrities & Real People category in 2015-2018.
Minecraft (Video Game) was in the top 10 in 2021-2022. However, it has been removed from the Celebrities & Real People category by the time this post was made, so I'm excluding it from the bar chart.
Fandom tags that are no longer in the Celebrities & Real People category tag as of posting this are left out of the bar chart race. These tags are usually either miscategorized or already have other tags referring to the same fandom.
For tags that existed on the same years before eventually merging into one tag later on (such as CW Network RPF which later on merged with Actor RPF, and Internet Personalities which later on merged with Video Blogging RPF), I use the data of whichever tag has the highest number for that year.
Please refer to this post for more bar chart races.
Thanks for understanding and hopefully I didn’t mess up anywhere! 🙏

bakanokiwami

TOP 10 TV SHOW FANDOMS ON AO3 BASED ON NUMBER OF FANWORKS, SINGLE CATEGORY VERSION (2009-2022)

If you want to see the TV Show bar chart with the multi-category fandom tags included, please check this post.
To make these bar chart race, all series titles in the TV Show Category on November 29 (or the closest date to it) of every year were copy-pasted from Wayback Machine to Google Sheets, rearranged according to number of fanworks, manually filtered for fandoms belonging in only one category and then inputted to Flourish to turn into a bar chart race.
Locked fanworks aren't included in the count because Wayback Machine can’t view those, only Ao3 users can.
Jossverse was in the top 10 from 2010-2017 (Top 2 in 2010 and 2011). In 2018, it was removed from the TV Show fandom list and works tagged with it show up in Buffy the Vampire Slayer (TV) instead so I’ve excluded it from the bar chart.
Thanks for understanding and hopefully I didn’t mess up anywhere! 🙏
ETA: About Doctor Who: Doctor Who actually has 2 tags with ranked higher (Higher than Doctor Who (2005) even) on the list. Unfortunately, they were both multi-category tags: Doctor Who & Related Fandoms was also in the Other Media category thanks to the Doctor Who (Big Finish Audio), and the other tag Doctor Who was also in Books & Literature thanks to Doctor Who - Various Authors. You can see them rank in the top 10 TV Shows multi-category bar chart race linked above.
About Stargate: The Stargate - All Media Types tag is actually interesting because unlike most All Media Types tags, it’s only listed in the TV Show category. That’s why it still turned up in this list. This might just be a lack of tagging its other categories (like Books & Literature) on AO3, however. Now that I checked its subtags, it actually had at least 2 Book & Literature only subtags: Stargate Atlantis: Legacy Series - Various Authors and Stargate SG-1 - Various Authors. So it probably should not have been in this bar chart race. Apologies for the oversight.🙏