Science Fiction related projects by ErsatzCulture

Some projects I've built relating to science fiction in written form. Most of these are based on data from ISFDB, with some also using Goodreads APIs.

"Rough sketch" mini-projects

The stuff that's hosted on this site are the projects that I actually spent a lot of time and effort on to bring to - what I hope is - a reasomably professional and complete state. However, I've worked on a number of other similar, smaller projects, that aren't in a state to be "formally" published for various reasons. Some of this work has been made available through my Twitter feed though; here are some examples:

Three linked threads investigating curious user behaviour on Goodreads. (Posted March 2020, although mainly relates to activity around the time of the previous year's Goodreads Choice Awards)

An earlier analysis looking at the nominees for that year's Goodreads Choice Awards, just looking at the overall numbers, and highlighting things that didn't make sense to me. (Posted December 2019)
Analysing the trends of some Goodreads user-voted lists for Hugo Award Best Novel and Best Novella categories, and making some predictions for the actual nominations based on that.
A look at the 2019-2020 year-on-year changes in the number of ratings Hugo finalist novels received. This was a by-product of my charts linked above, and aims to give some insight into which books are currently popular, as opposed to having lots of readers in the past, but where perhaps the audience has since lost interest. (Posted June 2020)
A visualization of how the proportion of SF&F novels that are in a series has grown over time. (Posted November 2019)
An earlier analysis using similar metholodogy on three different SF awards - just the raw data though, no charts. (Posted April 2019)
A couple of threads of charts that attempt to identify the gender balance of all SF&F novels published since 1900. These stats are much less reliable than the "proper" project linked above that just concentrates on the smaller and better documented dataset of award nominees/finalists. All novels, and subgenres, proportionally ; All novels, not scaled to 100% (Posted October 2019)

Works-in-progress

Besides the above, I have other projects that I've been working on intermittently. These include:

How diverse are SF&F awards in terms of the nationality of the finalists/nominees?
Is there an equivalent of Oscar Season for SF&F book awards?
How do readership levels of volumes in series drop off?
Examining the marketing/cover blurb claim of "Britain's No.1 Science Fiction Writer"
Why are the Top 10 US retail sales for SF so stagnant compared to other genres?
What proportion of novels published are debuts? What is the average "nth novel" published?
What SF&F books have been published in the UK (since 1970), but not the US? (There's a rough version here, but it was hacked up in a couple of hours, and definitely isn't something I feel is really suitable for human consumption as it stands.)