james_davis_nicoll: (Default)
[personal profile] james_davis_nicoll
To see how many novels were published in total after a certain date?

Date: 2017-05-04 08:01 pm (UTC)
rpresser: picture of Ross's dog (Default)
From: [personal profile] rpresser
One could download a recent ISFDB backup, load it into a local mysql instance and run whatever query that way.

Or you could try your luck at http://www.isfdb.org/cgi-bin/search.cgi

What date are you interested in?

Date: 2017-05-04 08:08 pm (UTC)
rpresser: picture of Ross's dog (Default)
From: [personal profile] rpresser
That's going to be way too many results to page through at the advanced search page. I will try the recent backup later tonight.

Date: 2017-05-04 08:09 pm (UTC)
rpresser: picture of Ross's dog (Default)
From: [personal profile] rpresser
Will you want to limit it other than Title Type=Novel, Title Year >= 1980? Limit by language perhaps?

Date: 2017-05-05 04:10 am (UTC)
rpresser: picture of Ross's dog (Default)
From: [personal profile] rpresser
I have come up with this number:

230128

Here is the breakdown by year:

1980 2382
1981 2277
1982 2256
1983 2258
1984 2546
1985 2692
1986 2861
1987 3109
1988 3227
1989 3006
1990 3015
1991 3086
1992 2912
1993 3049
1994 3069
1995 3210
1996 3284
1997 3266
1998 3235
1999 3572
2000 3687
2001 3767
2002 3976
2003 4197
2004 5164
2005 5414
2006 5296
2007 8320
2008 10094
2009 10778
2010 12957
2011 16823
2012 16892
2013 17385
2014 16526
2015 14114
2016 12430
2017 3676
8888 320

Here is the query, in case someone wants to check my thinking:

SELECT left(P.pub_year,4), count(DISTINCT P.pub_id) FROM isfdb.pubs AS P
inner join isfdb.pub_authors AS PA on P.pub_id=PA.pub_id
inner join isfdb.authors AS A on PA.author_id=A.author_id
inner join isfdb.languages AS L on A.author_language = L.lang_id
where L.lang_code='eng'
and P.pub_year >= '1980-00-00'
and p.pub_ctype = 'NOVEL'
GROUP by left(P.pub_year,4);
Edited Date: 2017-05-05 04:12 am (UTC)

Date: 2017-05-05 04:13 am (UTC)
rpresser: picture of Ross's dog (Default)
From: [personal profile] rpresser
I was surprised to find that in the ISFDB schema, publications don't have languages, only authors.

Paging John Titor

Date: 2017-05-07 07:05 pm (UTC)
From: (Anonymous)
D@mn. Now I want to read some of that SF from the year 8888. ;^)

-- TSM_in_Toronto

Date: 2017-05-05 12:54 am (UTC)
asyouknow_bob: (Default)
From: [personal profile] asyouknow_bob
It's not "novels" - but doesn't the Locus 'Year in Review' total "Book of interest to the SF genre" ?

Does that give a sense of the size of the ocean?
(Perhaps 3/4 of the "books of genre interest" are novels?)

Profile

james_davis_nicoll: (Default)
james_davis_nicoll

October 2017

S M T W T F S
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22232425262728
293031    

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Oct. 22nd, 2017 10:07 am
Powered by Dreamwidth Studios