r/Elsanna • • Aug 25 '24

New Comprehensive Elsanna Dropbox Archive

87 Upvotes

Hello all,

I've been a quiet member of this fandom for over a decade now, and for a while I've wanted to give something back to the community that has brought me so much joy. I've never been a capable fiction writer so creating my own stories was out, instead I've decided to give back using one of the only skills I possess: management of large datasets.

I know I've often relied on the RunAwayWoods dropbox archive for stories that have since been deleted, however it hasn't been updated since 2016 and is not easy to navigate unless you already know the story you're looking for. For this reason I set out to create an updated archive, a task which proved rather more challenging than excpected at the outset.

For those only interested in getting access to the juicy fics you can find the archive here: https://www.dropbox.com/scl/fo/u1um3kkrdl0tegvfturud/AC4i7mUs8AAOtFt6NS6289c?rlkey=t93ujes3r293jw7u4v7v6tbz7

There are 5111 stories from fanfiction.net, 3183 from AO3, 95 from Wattpad, and a whopping 14 from fictionpress.

The archive includes a searchable sqlite database, as well as .csv versions of the database tables to endable searching for fics.

If you're interested in the process of creating the archive, plus some fun statistics then read on.

-First: A Plea for Help-

There are likely hundreds of stories still missing from the archive, if you have a personal collection of downloaded fics that you would be willing to share then I'd love to check it for missing stories to add to the archive. You can submit them directly to my Dropbox here: https://www.dropbox.com/request/Czh4vDodvF9XDyRhTw9Y. Alternatively you can message me here on reddit, in the elsanna shenanigans discord, or email me at elsarchivist@gmail.com, and please forgive me if I'm slow to reply.

I am also interested in suggestions/advice on other sources to add to the archive. AFF, Tumblr, DeviantArt, and elsanna.fans are all possible candidates, if people have advice/experience scraping these sources, or suggestions for other sources please chime in.

-Creating the Archive-

Advanced warning, this section may be increadibly boring, but I really feel the need to explain how much work this was to do, because (if I've done my work right) none of it should be apparent in the final product.

From the start I knew I wanted this to be an archive, not only of currently available fics, but also to be as comprehensive as possible archive of deleted stories. To achieve this I started out by locating and combinging as many existing archives as possible.

The archives I relied on were the following:

  • The r/elsanna dropbox archive by RunAwayWoods. The wokhorse, the mvp, we all know and love it. Provided over 3000 fics that were either deleted or up to date.
  • The other dropbox by eternalwintergreen on tumblr. Not quite as useful but still provided >200 fics not found in the RunAwayWoods archive
  • Box archive by Elsanna-i-ship-it on tumblr. Extremely frustrating due to mixed formats, dupes, & raw html. However had >100 otherwise lost stories and complete versions of several classics of the fandom.
  • The FF mega scrape. A scrape of fanfiction.net running from 2013-2017 plus sporadically up to 2019. Provided >300 stories in .txt form.
  • The AO3 mega scrape by entropy11235813 on archive.org, a scrape in epub form running from god knows when to today.
  • My own personal collection of saved fics.

After gathering these archives I then proceeded to perform full metadata scrapes of the Frozen tag on fanfiction.net, fictionpress.com, archiveofourown.org, and wattpad.com, resulting in a database of metadata on over 20,000 fics.

The next task was to identify which of these were relevant to this fandom. This may seem a trivial task on it's face but that is far from the case. Many authors are sadly lax in their tagging, and so simply searching for 'Anna/Elsa' would miss a lot of stories.

What I had to do was an sequence of very conservative filtering that was sensative to authors not adding metadata. TO illustrate, if a fic was tagged as just Anna/Kristoff it could be automatically deleted, if a fic was tagged Anna/Elsa it could be automatically kept, however if there was no relationship tag then it couldn't be safely deleted as may have been an elsanna story the author forgot to tag (this was shockingly common). This left over 2000 stories that required some manual checking, after which I had a database of over 5000 extant elsanna stories to download.

I opted to use fanficfare as my tool for downloading stories as it had the best capabilities for downloading in bulk. There was however a problem. In recent years fanfiction.net has clamped down heavily on scraping the site, these days in order to scrap ffn calibre opens the story chapter by chapter in your browser, then pulls the data from your browser's cache - this is an extremely slow proccess.

I new that I'd need to minimise the number of stories I had to download, and so I leant on the existing archives. I wrote a script to decompile all of their stories and pull out the fic urls and wordcounts. I then used this to exclude all stories that were up to date in one or more of the archives from downloading. This left me with 2163 stories to download from FFN, which took around 48 hours of runtime spread over 4 days. AO3 is much friendlier and so none of this complication was needed there. Similarly Wattpad puts no restrictions on downloads so that wasn't a problem.

At last it was time to integrated my fresh scrape with the existing archives; a simple task? Alas no. The stories existed in four formats (epub, html, mobi, and txt), and from seven different sources(fanficfare, fanficdownloader, fichub, ficsave, ao3 directly, raw web html, and who knows what for the txt stories), each having different internal strutures and so requiring different handling. There were also duplicated stories within and between the archives, though this at least was relatively straightforward to fix.

It was important to me to have all of the stories as epubs with a standardised structure, I'm not going to dive into the exact proccessing to achieve this (though you can take a look at the code in the tools folder of the archive to see a heavily cut down version with the core cases), but to briefly summerise. Using two python libraries (beautifulsoup and ebooklib) the stories are broken down, their metadata and chapter content are extracted and stored, then new epubs are generated from this information in a standardised format. At the same time the metadata is used to generate a SQL statement to add the fic's information to the database.

This was the final step, the script was run for all the collected stories and voila, at long last the archive was complete.

-Stats for Nerds-

Now for something fun (at least for nerds like me). Here's some intersting data I found in the process of creating this archive.

There are currently 13709 fanfics tagged as frozen or frozen crossovers including Elsa and Anna on fanfiction.net. Of these approximately 4000 are Elsanna stories, or platonic stories written by Elsanna authors. Many of these are not properly tagged so you can only find about half of them using FFN's search. Elsanna is by far the largest ship within the Frozen fandom an FFN. More than 3000 frozen stories have been deleted from fanfiction.net, including more than 1000 elsanna stories.

There are currently 11167 fanfics tagged a frozen on AO3. Of these 2669 are Elsanna stories, disgracefully falling behind kristanna which currently has 2750. Approximately 10% were incorrectly tagged (including some fics mistakenly tagged as Elsanna when they were not). Including mis-tagged stories and platonic stories by elsanna authors 3014 fics were found. To date more than 1000 Frozen fanfics have been deleted from AO3, with at least 200 being elsanna. A similar amount of fics have been orphaned/anonymized, which seems to have contributed to AO3's lower deletion rate.

Finally I've noticed for a while that activity on FFN is pretty dead for this fandom, so I though it would be insteresting to quantify activity on FFN vs AO3. Below are histograms of the number of stories published on FFN and AO3 binned by month, which show some interesting trends.

FFN shows a pretty standard decay curve. Obviously there's a very high initial spike, tailing off and matching the publishing rate on AO3 by around 2015, with activity mostly ceasing by around 2020. Interestingly the release of Frozen 2 didn't cause a noticable boost of stories on FFN.

/preview/pre/31jm4pc6cxkd1.png?width=2080&format=png&auto=webp&s=d3a3f728bcb94d81df3f36e9f73ed5b8656e9afd

AO3 is much more interesting. There is of course the intitial spike from Frozen's release as expected. There's then a second spike which fellow fandom dinosaurs may understand, for those newer fandom members this spike is the result of a community scare around a group called Critics United mass reporting Elsanna stories. There is then a third even larger spike caused by Frozen 2, followed by a modest decline with the publishing rate remaining pretty steady up to today.

/preview/pre/8kxg1ja7cxkd1.png?width=2080&format=png&auto=webp&s=46c49e44dd27053f5341cc705ba8d1b77b590e8b

Anyway that's everything I've got for now. Hopefully the archive is useful, I plan to update it at least once a month for the forseeable future.

Enjoy,

The Elsarchivist


r/Elsanna • • 20h ago

A Special Someone- fluff Fanfic

11 Upvotes

Elsa hadn't gone into the store for chocolates. She needed dish soap, batteries, and the particular brand of tea she'd been buying for six years because the idea of finding another one seemed unnecessarily exhausting.

The chocolates were an accident.

They were sitting on a little display near the registers, arranged in red and pink boxes with ribbons tied around them.

Elsa walked past, then stopped, one of the boxes was shaped like a heart. That was a little excessive, but she picked it up anyway.

Dark chocolate, milk chocolate, hazelnut cream, strawberry filling. Anna liked strawberry filling.

Actually, Anna liked most chocolate. She had once eaten half a bag of chocolate chips because she'd been too impatient to wait for the cookies to finish baking.

Elsa smiled faintly at the memory.

The box was twelve dollars, which seemed reasonable so she put it in her basket.

Then took it out. Then put it back.

It wasn't Valentine's Day. It wasn't Anna's birthday. They weren't celebrating anything.

But Anna liked chocolates, and Elsa liked Anna.

Those seemed like good enough reasons.

The cashier was a young woman with pink glasses and a little silver heart dangling from one ear.

She scanned Elsa's tea, batteries, and dish soap before she picked up the chocolates. "Oh, these are cute."

Elsa nodded politely.

"They're very good, too. My girlfriend loves this brand."

"That's good."

The cashier turned the box over to find the barcode, "Are they for someone special?"

Elsa opened her mouth, and then closed it. She looked at the box.

Someone special...

She thought about Anna.

Anna sitting cross-legged on the kitchen counter, eating cereal straight from the box.
Anna falling asleep halfway through movies she had insisted they watch together.
Anna sending her photographs of dogs she encountered on walks.
Anna talking too much when she was nervous.
Anna's freckles.
Her laugh.
The way she sometimes reached across the table just to touch Elsa's hand.
The way she said Elsa's name when she was particularly happy to see her.

… There were a great many people in the world.

Elsa knew that, statistically speaking, she had met only a very small percentage of them, though she couldn't imagine meeting anyone quite like Anna.

She looked up, "Yes," someone special.

The cashier smiled, "Aw."

Elsa considered the question a moment longer, "Very much so."

The cashier's smile grew, "well, I hope they like them."

Elsa looked down at the little heart-shaped box, "I think she will."

---

Anna was on the couch when Elsa got home, She had one sock on. There was a blanket around her shoulders and an unfinished crossword puzzle on her lap.

"Elsaaa."

"Anna."

"Did you get the tea?"

"Yes."

"Did you get the batteries?"

"Yes."

"Did you get me a pony?"

"No."

Anna sighed, "Nobody ever gets me a pony."

Elsa put the shopping bag on the kitchen counter, "I got you something else."

Anna immediately sat up, "What?"

Elsa took the box out and Anna stared, her entire face brightened, "Elsa!"

"It's chocolate."

"I can see that!"

"I thought you might like it."

Anna scrambled off the couch, nearly tripping over her blanket, "You got me chocolates?"

"Yes."

"Why?"

Elsa paused, "because I saw them."

Anna blinked, "And?"

"And I thought of you."

Anna's expression changed, only slightly. Just enough that her smile softened into something smaller and warmer, "Oh."

Elsa suddenly became very interested in straightening the ribbon on the box, "They have strawberry filling. Some of them. Not all of them. I don't know which ones, actually. There's a diagram on the back."
Anna took the box and looked at it for a moment, Then at Elsa."You saw chocolates and thought of me?"

"Yes."

"And bought them?"

"Eyep."

Anna laughed, then stepped forward and wrapped her arms around Elsa.

Elsa gave a small, surprised breath before awkwardly returning the hug.

"Thank you," Anna murmured.

"You're welcome."

"You're really sweet, you know."

Elsa made a doubtful noise.

Anna pulled back just enough to look up at her, "Really."

Elsa looked away, “If you say so…”

Anna smiled, “The sweetest big sister ever.”

Elsa's cheeks had gone a little pink, "I was told they're good chocolates."

Anna smiled, "Well, they're from my favorite person, so they're already pretty great."

Elsa looked at her, For a second, she considered telling Anna about the cashier asking if they were for someone special, and about how easy the answer had been once she'd thought about it.

Instead, she tucked a loose strand of red hair behind Anna's ear, and gently asked "Would you like to open them?"

"Obviously,” Anna caught Elsa's hand before she could move away.

"You're sharing."

"They're yours."

"Yeah, and I want to share them with you."

Elsa smiled, "All right."

Anna took her hand and led her toward the couch. And Elsa followed, quietly pleased with herself. Because she'd gone out for dish soap, batteries, and tea. And somehow she'd brought home a smile that made the entire trip worthwhile.


r/Elsanna • • 23d ago

Downloaded Fics

13 Upvotes

If anyone’s dying from the A03 shutdown, I got Helping Hands, Thawing Heart + Eclipsing Heart, guilty devotion, and We Were Monsters downloaded


r/Elsanna • • 29d ago

Frozen

Post image
108 Upvotes

*a kiss at the skating rink...*❄️♥️🌻


r/Elsanna • • Oct 22 '26

Elsanna art by crownthedogs

Thumbnail
gallery
93 Upvotes

r/Elsanna • • Oct 17 '26

Frozen Fever

Post image
128 Upvotes

a kiss in the morning 🌻♥️❄️


r/Elsanna • • Oct 14 '26

Loving You

Post image
144 Upvotes

r/Elsanna • • Oct 14 '26

Our Child

Post image
57 Upvotes

r/Elsanna • • Oct 12 '26

I Love You

Post image
62 Upvotes

r/Elsanna • • Oct 12 '26

Let's Create

Post image
123 Upvotes

Love can do all things.


r/Elsanna • • Oct 10 '26

Frozen

Post image
90 Upvotes

🌻♥️❄️