r/Fantasy • Stabby Winner, Reading Champion II, Worldbuilders • Mar 06 '17

r/Fantasy Database

So this has been done before, but I thought with Bingo coming to a close some of you might find an updated version useful.

 

Here it is: New r/Fantasy Database

 

For those of you unfamiliar with Google Spreadsheets, you can click File > Download As to copy the database and sort it however you like. I recommend you click the "Filter Views" button located near the top next to "Comment Only" and select "Create New Temporary Filter View." This will let you sort and filter the database without changing how it appears for anyone else!

This is a work in progress and is aimed at helping you find specific recommendations and finishing your bingo squares. As of now, you can sort by things like:

  • Publication Date
  • Number of Books in Series
  • All of the various "Top Lists"
  • Every AMA Author since 2010
  • All the Goodreads Book Club Books
  • LGBTQ
  • Epic, Urban, Historical, Standalone, Female Protagonist, etc.
  • Tons of Magical Realism, Swords & Sorcery, etc.

Let me know if I missed any bingo categories or if there is anything you'd like me to add!

151 Upvotes

65 comments sorted by

23

u/ashearmstrong Mar 06 '17

I am on this list, therefore, I am a really real author. For real.

12

u/CoffeeArchives Mar 06 '17

Not only are you on this list, but you also are the source of like 90% of the weird western entries :)

→ More replies (1)

17

u/KristaDBall Mar 06 '17

Lovely work!

There's a wee tiny error with Spirit Caller. It's 6 books now that it's finished (I think it was 4 books out when I did my AMA, thus the confusion). :)

9

u/CoffeeArchives Mar 06 '17

Fixed!

14

u/KristaDBall Mar 06 '17

Thanks. I considered not telling you, because it felt like one of those "OH LOOK I DID 5 BILLION HOURS WORTH OF WORK AND SOMEONE BITCHES AT ME"

Which, if that was your response, I would have been OK with that, too ;)

→ More replies (1)

12

u/Salaris Mar 06 '17

This is awesome! I'm particularly pleased I can search for more hard magic fantasy to read. =D

Are you still looking to add more options? I see that you've got my War of Broken Mirrors on there (thank you!) and I'd love to get my new series on there as well.

7

u/CoffeeArchives Mar 06 '17

I'm definitely looking to add more options! Is "Sufficiently Advanced Magic" the name of the series?

Also, do you have any suggestions for additional hard magic series to add?

→ More replies (7)

20

u/HiuGregg Mar 06 '17

Holy shit! This is awesome. Over 800 books? I can't even imagine how much time and effort went into this.

Edit: Words. By the time I get used to typing on this new phone, it'll be time to upgrade.

13

u/CoffeeArchives Mar 06 '17

I can't even imagine how much time and effort went into this.

I might have gotten a little carried away...

11

u/KristaDBall Mar 06 '17

As someone who counts threads for a hobby, nah, you are merely dedicated and passionate ;)

→ More replies (5)
→ More replies (2)

10

u/lrich1024 Mar 06 '17

Wooooooot! So very organized....love it. Thanks so much for pulling this together. Some of the squares will carry over for the next Bingo so this will be useful, I will make sure to link it in my Bingo post when it goes up on the 1st.

6

u/CoffeeArchives Mar 06 '17

Awesome! Hopefully it can help people :)

→ More replies (1)

8

u/thequeensownfool Mar 06 '17

This is amazing! Thank you so much for all your hard work.

Would it be possible to lock the first column? That was as you scroll along to check the genres you can still see the series listed.

4

u/UnsealedMTG Mar 07 '17

This is so awesome and makes me want to do some kind of playing with the data. When I was comparing the number of votes for characters different series to the votes for the characters in our top character list this would have been sooo much easier than copy-pasting from Reddit tables.

2

u/CoffeeArchives Mar 07 '17

Playing with data is the best! Hopefully this makes it a little easier in the future.

I know I already played around with it some. For instance, I thought it was interesting that ~43% of the books were by female authors, which was pleasantly surprising.

2

u/AmethystOrator Mar 07 '17

This is really terrific, thanks so much!

I'm not sure if I'm understanding it though? I immediately went to look for one of my favorite authors, Michelle West, who is on there for her Essalyien works. Do the "X"s mean Yes or No? I would think "Yes", but her series isn't complete, and there's an "X" there. And it wasn't her Debut, but there's an "X" there. Otoh, there are definitely non-Western cultures included, but no "X", and there are a lot of female protagonists (and dozens of convos that pass the Bechdel Test), but again no "X" there. Also, I know that there were votes for her on at least one of the pre-2016 "Top" lists. I think it was the 2014 (though I might be mistaken) but can't find that thread. I do have this list: http://www.listchallenges.com/reddits-top-105-fantasy-novelsseries-of-all-time/checklist/3 which I think is for 2014, and one of those (the Sun Sword) series is down as #103. As I said, I may be misunderstanding or wrong about the X's and/or the 2014 list, but if you could please check I'd really appreciate it.

3

u/CoffeeArchives Mar 07 '17

Do the "X"s mean Yes or No?

They mean yes.

there are definitely non-Western cultures included, but no "X"

I haven't read all of the books in the list (there's waaaay too many), so I'm relying on past recommendation threads for a lot of the columns. Would you say that Michelle West's Essalieyen series counts as "inspired mainly by or most prominently featuring a non-western culture?" I can add that.

Also, I know that there were votes for her on at least one of the pre-2016 "Top" lists.

You're right, I missed Sun Sword from our 2014 Top List. To be completely honest, I think I might have gotten about 150-200 books into the 2014 list and then decided that was enough. It's definitely on my to do list to finish it if I have time.

Also, the only lists I'm using for this database are ones generated or linked through r/Fantasy. My goal isn't to have a comprehensive source of ALL fantasy works, just the ones recommended through this subreddit.

Hopefully this clears some things up! This is definitely a work in progress and I appreciate you pointing out things I've missed! I think I've updated what you've mentioned.

→ More replies (9)

10

u/Swordofmytriumph Mar 06 '17

This is amazing! Could this be linked under the Find Books menu?

6

u/simbyotic Mar 06 '17

THIS IS AWESOME, going to play with it now brb

5

u/Alethela Mar 06 '17

Wow, this is so satisfying to look through! Well done.

3

u/emailanimal Mar 06 '17

Thanks! This is really useful.

3

u/cheryllovestoread Mar 07 '17

stands and applauds Lovely database!

3

u/MichaelJSullivan Mar 07 '17

Very nicely done! Thank you or all the work and effort you put into this.