Crowd-sourcing HD fan-fair: Progress Report #2 - my f-list rocks!

[snowgall]

Update #2 for those interested in the status of the HD-fan-fair Crowd-Sourcing Data Project where we're hoping to find the answer to the burning question: Who tops more?

Background: Inspired by the comments on my Who Tops More post, I have decided to try running the same analysis just on the fics written for the hd_fan_fair fest from 2009-2014. But I need to get the complete set of data first, so I set up a public Google spreadsheet in the hopes of crowd-sourcing it. Anyone who wants to can add to the spreadsheet and help fill in the gaps in the data. (Note: my original post suggesting the crowd-sourcing is f-locked to hide the spreadsheet URL from vandals, but if anyone is interested in helping with this project, just PM me so I can send you the link).

In the previous progress report, I noted we were still lacking info on 66 fics rated R or NC-17 and only had inferential info for 20 more. In the four days since then, many more volunteers stepped up to fill in some of the gaps. Thanks to (in alpha order) birdsofshore, cagnurit, dicta_contrion, eidheann_writes, gracerene, iwao, khalulu, and vaysh, 36 more fics got complete info, leaving us with only 46 blanks and 4 partials. (I think cabinetcaligari helped too, but may not have left their name on the spreadsheet. If I left anyone else out, please let me know so I can thank you!)

The power of crowd-sourcing is truly awesome!

Hopefully soon we will have all the data we need so I can run the topping/bottoming numbers. But with all the data we *do* have, I can give you a quickie analysis of what proportion of the hd_fan_fair fest fics are rated NC-17, R, PG-13, or PG.

Year	G/PG	PG-13	R	NC-17	Total
2009	05 (07%)	15 (21%)	18 (25%)	34 (47%)	72
2010	05 (10%)	13 (26%)	12 (24%)	20 (40%)	50
2012	02 (06%)	07 (18%)	07 (18%)	22 (58%)	38
2013	04 (12%)	12 (35%)	06 (18%)	12 (35%)	34
2014	01 (03%)	17 (46%)	05 (13%)	14 (38%)	37

I don't have anything pithy to say about these numbers; if anyone else does, leave a comment :) Just one caveat: though the number of fics posted to the fest dropped significantly after 2009, it is important to note that since 2010 the number of HD fests throughout the year has gone way up. So perhaps less fics are posted to each fest, but there are many more fests to post to!

Once again, I invite anyone interested to take a look at the spreadsheet (find the link in this post, or PM me) and enter data for any fics you may have read. There are just 46 fics that we lack top/bottom data on!

**If you add or change any data, it is helpful to leave a note in the "data entry by" column so I know who to thank and what has been added. You can also add a comment right in the same cell if there's data you disagree with. Just highlight anything you do so I can see it and make a note of it. Thanks again for all the help so far!

More in this series:
Crowd-sourcing Fan-fair Proposal - Spreadsheet link (f-locked)
Progress Report #1
Progress Report #2 - My f-list rocks!
Progress Report #3 - Take a Poll
Progress Report #4 - Poll Results and Spreadsheet Complete!
Who Tops More in HD-fan-fair: Final Results

Comments

[khalulu]

There are only 100 works now, and I know there were more before (one of mine was # 121, and now none of mine are there) - did you decide to take out lower rated ones, or ones with complete data? Am I missing something?

ETA - tried again and now I can see them all. That was weird. At least it's not lost data.

[snowgall]

Thank goodness! You nearly gave me a heart attack there :) I do have a back-up of the data though, just in case anything ever does happen.

I just went and checked myself and there are still 231 fics. You can sort any column you like A-Z, so if you wanted to find yours easily you could sort by author or title. Right now I have it sorted by top/bottom so we can easily see what's needed.

[khalulu]

Sorry about that! It was strange, it was all gray after 100, and then i clicked the link again and it was there. Ah well!

[khalulu]

So I, ah, dedicated some time to research yesterday, and skimmed through a bunch of the shorter ones. Life is about to get much busier so this might be all from me for a while. The one where Death takes a honeymoon was fun.

[snowgall]

You're awesome! This weekend seems to have encouraged several people to research some of the entries on the table, and I think we're down to just 18 blanks now! I'm so excited!

[zeitgeistic.livejournal.com]

I love that you do these. I find this analysis so fascinating.

[snowgall]

Thank you ♥♥♥

I find it fascinating too, though I wish I could offer better theories as to *why* any of this is the way it is :) But I think the discussions in the comment sections for some of these posts have been extremely insightful, and I love getting input on this from everyone else. The crowd-sourcing has been even more successful than I'd even hoped. We're nearly there with the top/bottom info for fan-fair!