The Week in Arrow Fanfiction

Arrow fanfiction posted on AO3 and fanfiction.net.  Header from paperlief.com, icon from CW's Arrow pinterest page. For code: https://github.com/SovvanNight?tab=repositories.

[theweekinarrowfic]

Hi! I saw you helped someone find an arrow fic and I was hoping you could do the same for me? I've been looking for actual years 😭

Maybe? I kind of dropped out of the fandom at a certain point, but if it's an older fic it might be in my database. Who were the main characters, what was the setting, and what was it about?

[theweekinarrowfic]

Can u help me find a specific sladiver fic that's driving me crazy?

Maybe? It would have to be an older fic because I haven't pulled data in a while. What do you remember about it?

[sovvannight]

@lilredandthebigbadwolf, I think I found it, but it seems to have been removed from AO3: https://archiveofourown.org/works/4689278

Family by tolieawake

Four years ago, Oliver Queen made Slade Wilson a promise - that if he ever got off the island, and Slade didn't - he would look after Slade's son, Joe.; Returned to Starling City, Oliver is determined to keep that promise. Even if it means having to be a responsible Omega.; (because I can't imagine Slade not asking that of Oliver, and then decided to throw a/b/o and a Slade/Oliver romance into the mix as well, just for fun)

[theweekinarrowfic]

I searched for the user name on AO3 and did find that someone else had reposted some of the author's works with permission, so they would presumably know how to get in touch with tolieawake if you wanted to try that. See https://archiveofourown.org/chapters/123566350#work_endnotes.

[theweekinarrowfic]

Can u help me find a specific sladiver fic that's driving me crazy?

Maybe? It would have to be an older fic because I haven't pulled data in a while. What do you remember about it?

[theweekinarrowfic]

The Year in Arrow Fic, 2022

This is my fourth year providing some statistics on Arrow fanfiction on AO3 (see 2019, 2020, and 2021).  

My data are based on monthly scrapes of recent unlocked fics tagged Arrow. The totals differ from a hand count of fics on AO3 because, on the one hand, my scraping tool does not capture locked fics (yet), but on the other hand, I have fics that were posted or updated in 2022 but have since been deleted. 

Note that this year I used a third party scraper through January 30th, after which it was taken offline, and then began scraping using my own Python code as of August 26th.  So, I will have missed some fics that were posted and then removed from February-August.

The 1,074 fics published in 2022 represent a 38% decrease from 2021, continuing a downward trend since the show ended.

I hand code several variables for each fic, including a 9-category relationship variable, a freeform relationship variable where I can go into more detail, and a 4-category fic type field.

By Ship:   Looking at relationship type, Olicity is the most ficced relationship of the four specific relationships I track, at 17% of all fics for the year (down from 19% in 2021). Lauriver makes of 5% of 2022 fics, down from 7% last year.  Olivarry makes up 4% of 2022 fics, down from 5% last year.  Dinahsiren is down from 3% to 0.65%.

I categorized 45% of 2022 fics into the “Other Arrow Ships” category (which includes gen), up from 42% in 2021.  Fics tagged Arrow that aren’t primarily about Arrow held steady at 20%, although my new category “Completely Non-Arrow” increased from 5% to 6%, and “Non-Arrow” (focuses on other shows/characters but either Arrow is referenced in the summary or Arrow characters are listed in the tags) decreased from 15% to 14%.  Finally, fics in a language other than English increased from 4% to 8%.

More statistics under the cut!

The “Other Arrow Ships” category is quite diverse--the 478 fics have 255 different entries in the freeform field.  The most ficced relationship within that category is Avalance, making up about 5% of the category.  As in previous years, the majority of the most ficced relationships involve Sara and/or Oliver.  This is also the place for gen fic, and here Oliver-centric makes the top 10 “relationships” within Other Arrow Ships.

By Format:  For fics tagged Arrow in 2022, 53% were multichapters (566), 41% were one-shots (441), 5% were one-shot collections (52), and 1% were single-universe collections (15).   [That last type are fics like Pieces of Always, where the story doesn’t necessarily flow from one chapter to the next, but all chapters are in the same universe.]  Compared to 2021, there were slightly more multichapters and slightly fewer one shots (51% and 43% in 2021).

Looking at format by ship category, non-Arrow fics were least likely to be one-shots, and Dinahsiren, foreign language fics, and “non-fic” fics were most likely to be one-shots in 2022.

As always, grad school training demands I must offer some caveats.

I hand code category and format myself; in an academic research project, each fic would be coded by multiple coders working independently who would discuss and resolve discrepancies.  I code based on the summary and tags alone, so fics with minimal information may be categorized inaccurately.  Also, these statistics are for unlocked fics on AO3 only.  It’s possible that locked fics and fics published on other platforms would show different patterns.  (I’ve seen instructions online for how to scrape while logged in, so sometime when I have time I’ll work on that.)  It’s also possible that I have missed fics, particularly with the gap in the beginning part of the year while I was figuring out a new scraping method.

As always, I hope you found this interesting and inspiring to go out and create in 2023!

[theweekinarrowfic]

Completed Arrow Multichapters on AO3, December, 2022

NOTE: I’m now crossposting to https://theweekinarrowfic.dreamwidth.org. Need more Arrow in your life? Why not try one of the multchapter fanfics recently completed by our talented fic writers?

Olicity

I get the sweetest feeling (that this is the start of something new) by StarlightDreamer21 (Oliver/Felicity, 3/3, 2022-12-01) - Felicity Smoak just moved to Starling City to start her new job at Queen Consolidated. It doesn’t take her long though to learn that her best friend, Thea, is the sister of the CEO. She moved here for new opportunities and adventures, but will she also find new love from the CEO who doubles as a 5 star chef?

I Object! by mindramblings (Oliver/Felicity, 2/2, 2022-12-25) - Oliver and Felicity were high school sweethearts, but they were torn apart by the distance adulthood brought to their lives. Despite the hurt and pain that it brings, Felicity is determined to face her past years later. So, she returns to Starling City...just in time for Oliver and Laurel's wedding. Memories bring out an emotional confession.

Other Arrow Ships

Arrow: The Paths To Tomorrow by HRwriter897, Onyon23 (Sara/Oliver, 23/23, 2022-12-09) - After the Crisis of infinite earths event, everything you thought you knew was changed. With the help of the one called The Specter, two individuals from Oliver’s life are given the chance to fix many mistakes and rebuild the world to be better prepared for what comes ahead.

Batgirl Sucks Cock by Batman_Batgirl_XXX (TottPaula) (Barbara Gordon/various including Barbara/Oliver, 4/4, 2022-12-22) - Batgirl thinks creatively to earn extra money to help finance her crusade in Gotham. She utilizes her best skill to earn a few benefactors. So how much cock could Batgirl suck if Batgirl would suck cock? Enough to finance her mission in Gotham as needed. Easy peasy. What millionaire would deny her request? An Arrowverse/ Batverse crossover. If Batman gets to eat pussy, Batgirl gets to suck cock!

What if...? by coldtime2000 (Rip Hunter/Leonard Snart, Sara/Leonard Snart, 33/33, 2022-12-15) - What if...? Fic What if...Would Rip have been married to Snart and not Miranda? After watching his husband die at the hands of Vandalo Savage, Rip Hunter decides to assemble a team to kill Vandalo and save the man he loves. But what if one of his team members is his husband? Only...this version of his husband is not yet his husband.

You can't be serious?! by Victoria832 (Natasha Romanov/Skye | Daisy Johnson; Felicity listed as character, 9/9, 2022-12-24) - When Skye gets the message that a friend of hers passed away Natasha is there to comfort her, to the surprise of her own team. May is starting to grow suspicious of their behavior. And then the two women just leave, leaving the team of three agents short and with lots of questions. A lot of Skye/Natasha

Touch Like a Memory by moonbeam (Oasiis) (Dick Grayson/Jason Todd, Oliver and Dinah Lance listed as characters, 8/8, 2022-12-16) - Dick Grayson, an unclaimed Omega living under the protection of Alpha Bruce Wayne, spends most of his nights as Nightwing, protecting the people of Gotham from numerous threats. His life is relatively simple considering he's yet to break through his first Heat. But his entire world shifts when Dick stumbles upon an Alpha fighting/breeding ring and locks eyes with the mysterious Alpha 'Red'. He's determined to save Red, even if he doesn't fully understand why the urge is so strong, and with his family at his back to help him, he's sure to succeed. However, Bruce Wayne has had his eye on Dick for years in the hope of becoming his bonded Alpha and he doesn't take kindly to anyone that gets in the way. Notes: Set in the Gotham Knights (2022) game universe. This is a standalone AU in the series so feel free to skip to the next one if it's not your thing! <3

Altering The Calm by Phillipe363 (Sara/Oliver, 3/3, 2022-12-18) - Instead of the Olicity driven episode we got and starting so many issues, what if events went differently? What if the show followed a path of Oliver and Sara focused? How does one tiny difference along with other stuff making sense like Oliver caring about QC, change things? Find out.

Waverider Down by legendsstan19 (Sara/Ava Sharpe, 2/2, 2022-12-01) - Summary: When an SOS call goes out to everyone on Prime Earth they are confused why it’s the waverider when all of the sudden the waverider comes crashing down. Read as they help each other get the legends out and figure out what happened.

Любовь под названием «АваЛенс» by Bernyce_Kiuberty (Sara/Ava Sharpe, 28/28, 2022-12-15) - Какой будет жизнь, после свадьбы Сары Ленс и Эвелин Шарп? Единственное, что все знают точно - она не будет спокойной.

Sorry if you can by Bernyce_Kiuberty (Alex Danvers/Sara, Sara/Ava Sharpe, 2/2, 2022-12-15) - Всё началось с драки и закончилось свадьбой. В этом вся я. Хотите узнать кто моя избранница?

playboy, playboy by kapiushonnn (Oliver/Slade, 2/2, 2022-12-15) - Oliver Queen era el playboy más peligroso. hasta que se fijó en Slade Wilson. o pequeño estudio de Oliver Queen y algún que otro carácter en cuánto amor y Slade Wilson.

It's a Super Xmas Tale by AllyBP (Kara Danvers/Oliver, 4/4, 2022-12-22) - This is my annual SuperArrow Xmas story the introduction of a new crackship I believe many people will enjoy. ave fun and happy holidays.

[theweekinarrowfic]

Completed Arrow Multichapters on AO3, October-November, 2022

NOTE: I’m now crossposting to https://theweekinarrowfic.dreamwidth.org. Need more Arrow in your life? Why not try one of the multchapter fanfics recently completed by our talented fic writers?

Olicity

Retribution by TaraB1915 (Oliver/Felicity, 17/17, 2022-10-13) - Felicity Smoak returns home to work with Oliver Queen, Captain of the SCPD. The past had retreated from the foreground but the darkness of it was still hanging around Starling City waiting for her. Then there was Moira Queen. And Laurel Lance.

so runs the world away by clarissawrites (Oliver/Felicity, 15/15, 2022-10-06) - In 2021, Felicity is abducted, pulled from her life as a wife, mother, and CEO, and forced to work for an underground organization. Oliver fights to find her, but with the threat of her death from her captors looming over him, all searches have to be kept discrete. For three years, he keeps searching. When he finally finds her, though, the real difficulty begins, as Felicity struggles to return to a normal life. (mostly canon through 4x06)

illicit affairs by SmoakingGreenArrow (Oliver/Felicity, 10/10, 2022-11-29) - Oliver Queen and Felicity Smoak do not plan on falling in love with each other. In fact, they deny it at every stolen glance, every instinctive thought, every unspoken desire. But some things are too powerful to ignore. They’re both on separate paths when they meet, but the way they’re drawn to each other is unlike anything they’ve ever felt. If only life could be so simple.

Other Arrow Ships

A New Life on a New Earth by ArrowverseFan833 (Kara Danvers/Oliver, 61/61, 2022-10-06) - Oliver Queen decides that he isn't going to go to prison, so he fakes his death and moves to Earth 38. See what happens when the Green Arrow joins forces with Supergirl.*I do not own Arrow, Supergirl, The Flash, Legends of Tomorrow, or any of the characters in this story. They belong to the CW, WB, and DC Comics along with the writers of the shows.*

Arrow Enriched: The League, Part 3 by RoczaDeb (Laurel/Oliver, 8/8, 2022-10-26) - The League would train them. Make them stronger. Give them a purpose... hunting evil. AU. Ship-Laurel/Oliver. Laurel/Oliver/Tommy. Graphic Violence. Graphic Torture. Arrow Enriched Series, Part 3 (Second part of the story).

Arrow Enriched: Lian Yu, Part 2 by RoczaDeb (Laurel/Oliver, 5/5, 2022-10-15) - It was supposed to be a fun summer trip with friends. Yeah, Dad had business, but that left Oliver, Tommy, and Laurel to explore the cities they visited. It would be good for them. AU. Ship-Laurel/Oliver. Character Death. Graphic Injuries. Rape Warning. Arrow Enriched Series, Part 2 (Start of story)

the universe may not care but barry allen sure does. by SpaceCactus19 (Barry Allen/Caitlin Snow, Barry Allen/Oliver, 2/2, 2022-10-02) - set after Crisis on Infinite Earths. gonna be honest here I only saw the scene where (spoiler) Oliver died. i still have to watch it but this is set after it. barry can't accept the fact that Oliver died so against everyone's advice he travels back in time and somehow he saved Oliver. he goes missing in their reality for a week. this fic starts when he is back with them again. and Oliver is suddenly there and all alive. leaving some very confused people.

Arrow Dæmon AU by BeanSidhe_13 (Oliver & Slade, 9/9, 2022-10-20) - Oliver is a horribly traumatized human being, and so are his friends. Here’s how I think it might affect their souls if they were visible.

El juramento de obsesión by kapiushonnn (Oliver/Slade, 2/2, 2022-10-04) - Las personas elegían ver por lo general a Oliver Queen & Slade Wilson cómo una pareja genial y poderosa. eran más que eso. eran algo mucho más oscuro que eso. algo inexplicable y de alguna manera, algo peor. era un error. un error que no iban a dejar de cometer.

Of Friends and Reflections by LadyArthem (Hamish Duke/Vera Stone, Oliver/Felicity as side pairing, 2/2, 2022-11-29) - Hamish asks for help to bring Lilith's soul back. What he doesn't realise is that he might get more than he bargained for.

Earth-1 by WeirdWolf_Fandoms (Kara Danvers/Lena Luthor, Oliver and Sara listed as characters, 8/8, 2022-10-24) - During a routine crossover with just Barry Kara accidentally gets in the middle of Earth-1 Lena and Kara's relationship.

Unthinkable: Part 1 by RamaMind (Oliver/Slade, 9/9, 2022-10-17) - Slade Wilson's plan to torture Oliver Queen takes a disastrous turn when he kills him instead. With the subject of his obsession gone, he unravels in his madness. Team Arrow and Oliver's friends and family have to band together to save his city, and with Slade out of the picture, they have a good chance of doing so. But soon they will realize the emptiness left by Oliver's passing, and someone will make a deal with the Demon's Head to bring him back.

Oliver Does Arrow Season Two by megamatt09 (Oliver/various including Oliver/Shado, Oliver/Moira/Laurel, 7/7, 2022-10-14) - More sexual encounters featuring Oliver Queen and various women featured in Arrow. Season Two.

Nightmare in Starling City by Pootamis13 (Laurel/Oliver, 7/7, 2022-10-11) - One, two, Freddy's coming for you. Three, four, better lock your door. Five, six, grab a crucifix. Seven, eight, gonna stay up late. Nine, ten, never sleep again.

Anges gardiens by Amelia_Queen (Oliver-centric, 9/9, 2022-10-31) - Après son enlèvement par Chase, Oliver est au fond du gouffre et repousse tout le monde. C’était sans compter sur ses amis extraordinaires qui refusent de le laisser sombrer.

Never Be Silent by Ray_Writes (Laurel/Oliver, 11/11, 2022-11-19) - When Curtis messes with Laurel’s Canary Cry choker to save Oliver from Larvan’s bees, a secret Team Arrow never realized existed is revealed, prompting them to take a harder look at their counterparts in Central City and the way metahumans are treated."

Estoy cansado, ayudame por favor. by kapiushonnn (Barry Allen/Kara Danvers/Oliver, 2/2, 2022-11-04) - Maldita sea, Oliver estaba jodidamente cansado. pero no ese tipo de cansancio dónde llega a la mansión y se tira en un sillón, a dormir veinte horas para ser despertado por su madre, raisa, digg o thea con una declaración cómo “ tienes una cama propia, ve a dormir a ella ”, no. era un cansancio más allá de eso. estaba cansado con la vida. o algo así. o la vez que Oliver se desahoga, y llora, mientras que Barry & Kara deciden después de entender la situación, apoyarlo.

No destinados a ser. [ Bruce Wayne/Oliver Queen] by kapiushonnn (Oliver/Bruce Wayne, 3/3, 2022-11-24) - Bruce Wayne & Oliver Queen fueron personas no destinadas a ser, sin embargo aún así lograron tener una historia llena de admiración, romance, apodos estúpidos, y problemas. [ ligeramente sigue la historia de arrow pero no el canon y/o órden cronológico alguno. varios capítulos & distintas tomas. + bruce wayne ]"

Arrow Redesigned 03.O: Demon's Venom, Sah-him by RoczaDeb (Laurel/Tommy/Oliver, 6/6, 2022-11-14) - Sah-him’s (Oliver’s) specialized field training with The Demon’s Venom. Learning to use the Ruya. AU. Ship-Laurel/Oliver/Tommy. Graphic Injuries. Arrow Redesigned Series, Part 03.O

Waverider Down by legendsstan19 (Sara/Ava Sharpe, 2/2, 2022-12-01) - Summary: When an SOS call goes out to everyone on Prime Earth they are confused why it’s the waverider when all of the sudden the waverider comes crashing down. Read as they help each other get the legends out and figure out what happened.

[theweekinarrowfic]

Completed Arrow Multichapters on AO3, September, 2022

NOTE: I’m now crossposting to https://theweekinarrowfic.dreamwidth.org. Need more Arrow in your life? Why not try one of the multchapter fanfics recently completed by our talented fic writers?

Olicity

Trouvaille by SmoakingGreenArrow (Oliver/Felicity, 2/2, 2022-09-24) - When Tommy has to bail on giving his best friend Felicity a ride home from college, Oliver takes his place. The problem? Felicity hates him. And she thinks Oliver hates her back. If they can survive a 12 hour car ride together, could it lead to forever?

Other Arrow Ships & Characters

Second Chances: Artemis - Rough Draft by Lauriverfanboy1 (Thea/Roy, 25/25, 2022-09-24) - My name is Thea Queen. In another life, I spent years fighting by my brother's side as a vigilante but in this one, I now plan to become my own hero outside of his shadow. Hopefully some day, I'll become just as great as he is. I am Artemis. Part 8 of Second Chances.

【明日传奇】末日传奇电影俱乐部：第一夜（末日军团&冷队&原子侠） by buwei (Ray & Damien, 6/6, 2022-09-16) - 命运之矛被摧毁了。雷蒙德·帕尔默给自己选择了最糟糕的庆祝伙伴。比那更糟糕的是，他们或许是成立了一个末日军团与传奇版的电影俱乐部。但另一方面，谁知道他们也会给彼此做心理治疗呢？

Second Chances: Arrow - Rough Draft by Lauriverfanboy1 (Laurel/Oliver, 25/25, 2022-09-24) - My name is Oliver Queen. After dying to restore the multiverse, I found myself back at the beginning of my story and now I plan to rewrite it to not only save my city, but save those I lost before. A lot of things have changed in this new world but one that hasn't is me. I will always protect my home. I am the Green Arrow."

One More Time by Ray_Writes (Laurel/Oliver, 24/24, 2022-09-10) - Upon her death, Laurel is made an offer by a being named Mar Novu to be sent back in time and correct Earth-1’s timeline, as it is rapidly spiraling out of the Monitor’s control. Now, just under five years into her past and armed only with a partial knowledge of the timeline and a certainty she is not the right person for the job, Laurel must unite six Paragons and as many additional heroes as possible to face a coming Crisis. What changes will she make, and will they be the right ones? Time is ticking to save the world."

The Other Side of Lonely by paynesgrey (Laurel/Cisco Ramon, 5/5, 2022-09-07) - Fighting alone on the streets of Starling City, the Black Canary could use a little help from a friend. Enter: Cisco Ramon.

el orbe by Pedroedu (Laurel & Thea-centric, 11/11, 2022-09-13) - esta historia esta basada en un universo alternativo de la tercera temporada de arrow aunque aquí laurel y thea ya asumieron sus alteregos

Laser Tag by sspace_invader (Damien/Malcolm/Eobard Thawne, 2/2, 2022-09-03) - “Remember, no cheating.” Eobard sighed, preparing to just ignore Malcolm’s stupid rules and speed around the course, shooting the other team, easily winning. But doing that would cause them to get kicked out. Plus Damien and Malcolm would be mad at him. He didn’t think it was worth the risk. He mentally kicked himself for letting his partners make him soft, The Flash would laugh in his face if he could see him right now. Or The Legion plays laser tag and leads to other things.

Non-Arrow

Wedding For the Wilders by FuegoCreativeFlow (Sophie Moore/Ryan Wilder, several Arrow characters listed, 6/6, 2022-09-06) - This is the next series in my Batwoman Stories that’s connected. This story takes place four months after the “Gotham’s Drama” Series. You finally get to see Ryan and Sophie explore marriage, family, and still being badass Superheroes. I hope you all enjoy. And yes, Alani is back!!

Der Bote des Wahnsinns, das Gefängnis des Multiverse by God_of_the_stories_I_heve_written_0 (Marvel-centric, John Constantine listed as character, 4/4, 2022-09-25) - Stepfen Strange wird durch einen Streit mit Wanda Mazimof auferstehen in eine andere Welt gebracht und landet direkt vor dem Lux. In einer anderen Wersion der Arrowverse, wo John Constantine dort Stammgast ist. Er hasst die Welt und will nach Hause.

Second Chances: Kid Flash - Rough Draft by Lauriverfanboy1 (Linda Park/Wally West, several Arrow characters listed, 25/25, 2022-09-23) - My name is Wally West. For years I've traveled, trying to find my place in a world of heroes, trying to find peace. But after getting struck by lightning in a new world, I think I've finally found my place as I become the hero I was always meant to be. I am Kid Flash. Part 9 of Second Chances.

Love at first sight. by Batwoman2019 (Kate Kane/Reagan, Kara Danvers/Sara as side pairing, 7/7, 2022-09-28) - What if instead of Kate and Reagan meeting during Tommy Elliott's party they both met during crisis on infinite earth.

Crisis by WhatIfUniverse (Barry Allen/Caitlin Snow, several Arrow characters listed, 8/8, 2022-09-28) - Last year, the multiverse had a visitor named the Monitor who warned them of a crisis coming to end all life. Now the Avengers, SHIELD, and the heroes of Earth-1 must join forces again to save their universes from being destroyed, with help from a new member who has traveled back in time to help stop it. Is it enough, or will all of reality be destroyed?

[theweekinarrowfic]

Completed Arrow Multichapters on AO3, July-August, 2022

NOTE: I’m now crossposting to https://theweekinarrowfic.dreamwidth.org. Also, I'm looking for volunteers to test out my fic recommender! Need more Arrow in your life? Why not try one of the multchapter fanfics recently completed by our talented fic writers?

Olicity

Haunted by History by Jess_S (Oliver/Felicity, 54/54, 2022-08-30) - Because what's past can't be forgotten

Queen's Consort by stoicheroes (Oliver/Felicity, 19/19, 2022-08-13) - The Queen family hosts an annual cruise on their yacht featuring many of Starling City’s rich and famous. This year, recently rescued castaway Oliver Queen is resigned to a weekend of being the center of curiosity and gossip - until something goes drastically wrong and throws the trip into chaos. Mysterious stowaways, brutal murders, and a severe storm at sea - Oliver has to deal with his PTSD and along with Felicity and Diggle, race against the clock to figure out what is going on in time to save his family and the other passengers. Essentially ‘Die Hard’ on a ship with Olicity

Family Feud: Queen vs. West-Allen by Queen_Woomy (Oliver/Felicity, 5/5, 2022-08-07) - The Queen family from Star City USA takes on the West-Allen family from Central City USA. Both families are trying to guess the results of survey questions in the hopes of winning $20,000!

Other Arrow Ships

Dark DC: Doomworld by Enthralledo (Damien/Malcolm/Leonard Snart/Eobard Thawne, 4/4, 2022-08-13) - Dark take on the Legends Episode 'Doomworld'. Warning, Mature, Lemons XXX

Infinite Crisis by AllyBP (Kara Danvers/Oliver, 11/11, 2022-08-08) - Thanks to Oliver Queen's sacrifice, life was given a second chance in the universe. Earth Prime heroes are still dealing the lost of a friend, but they have no idea what's coming their way is even worse that they can possible imagine. New bonds and hope for the future fills this Arrowverse story, inspired by an iconic story from Justice League animated series. Come join the biggest heroes of history in this new journey. (Rated M just in case, but is mostly T+)

Cruising Through Time by bigwlwshipper (Nyssa/Sara, 42/42, 2022-07-12) - The Legends. A wonderful bunch of weirdoes. A dysfunctional family. We all know and love the Legends as they are, but let's put a relationship twist in. A Nyssara twist. Sara's dedication to the woman alters how the Legends go about things, but at the same time, they're the same dysfunctional bunch we love. or the AU in which Sara goes to travel in time but leaves her heart in the hands of Nyssa.

The Red and Green Arrow. by Batwoman2019 (Laurel/Oliver, Kate Kane/Regan, 40/40, 2022-07-28) - What would of happened had Reagan gone with Oliver on his father's boat instead of Sara. Will they find them alive or will they have lost them for good.

Balance of Two Lights by whenfictioncalls (Kara Danvers/Oliver, 23/23, 2022-08-06) - Oliver Queen has set off on a suicidal course as he tries to save Star City alone as the Green Arrow while running it as Mayor. Broken and grieving after tragedy, he finds himself running in circles between who he was in the past and who he has become- and who he needs to be in order to be the man that not only his city needs but the people he loves. Kara Danvers, an intrepid reporter who has one of the most influential voices in Star City, wants nothing more than to save her dying city. Willingly challenging the seemingly apathetic Mayor will send her down a path of her finding her true self and embracing it.

The Countdown has Begun by HRwriter897 (Tim Drake/Rose Wilson, Nyssa/Sara/Oliver among side pairings, 23/23, 2022-07-28) - Something sinister is simmering below the surface. One of the most dangerous villains has returned with like minded allies and with him comes the possibility of an Apocalypse and revelations that will shake this Universe and the rest to its very core. During this, feelings will be admitted and old grievances will be put to rest."

Don't Tell Me Your Name by KathleenRaven (Barry Allen/Oliver, 19/19, 2022-08-21) - Barry Allen has just ended his relationship and is looking for something new. The Verdant nightclub seems like the perfect place for it and "Arrow" his ideal partner in adventure. Having a friend with benefits is fun, but what happens when you don't know anything about him? For a person as in touch with his feelings as Barry, it will be a challenge to keep things casual. It will all get complicated when fate brings him face to face with the attractive and mysterious Oliver Queen.

Siblings United by am837 (Aelita Schaeffer/Ulrich Stern, Kara Danvers/Oliver as side pairing, 2/2, 2022-08-02) - Ulrich and Aelita, siblings, who have sought to go into hiding from the Empire have been called by Supergirl and her children, the last of fewer resistances hunted by the Empire. With an offer to join Supergirl's resistance, will Ulrich and Aelita decline, or will get themselves involved in the war against the Empire?

Heroes from Infinite Earths by Aragorn_II_Elessar (The Monitor listed as character, 21/21, 2022-08-29) - The Crisis on Infinite Earths has come at last, and all the Heroes from the Multiverse must unite to battle it. But will their unity be enough this time? Or will they finally lose as all is destroyed? The finale of the 'Heroes' series.

This Godforsaken Mess That You Made Me by swarley18 (Sara/Ava Sharpe, 18/18, 2022-08-21) - This is an AU spin on The One Where We're Trapped on TV. Instead of trapping the Legends on TV, Charlie hides them from her sisters by sending them to an alternate dimension where Sara is a police officer, Ava is a teacher, Zari is a doctor, and the rest of the Legends are living out their normal lives none the wiser of their true identities. In her haste to hide the Legends, Charlie makes some mistakes in creating this new dimension. When some of them start to remember, will the Legends risk giving up their fabricated lives where Sara and Behrad are alive to return to an uncertain reality to face the Fates?

Oliver Does Arrow Season One by megamatt09 (Oliver/various, 8/8, 2022-08-26) - The various sexual encounters featuring Oliver Queen and various women featured in Arrow. Season One.

Talia Al Ghul. by KalK (Clark Kent/Talia al Ghul, 4/4, 2022-07-17) - Clark se encuentra despechado, después que Lana se casara con Lex, ella aunque quiere a Luthor como un amigo decide aceptar la propuesta de matrimonio por obligación. Es madre soltera y en estos momentos necesita mucho apoyo, aparte que fue manipulada por Lex sin que ella se diera cuenta. Al ver que Lana se a casado, decide despejar su mente y corriendo llega a suiza donde esa noche en un bar conoce a una guapa mujer.

How I Fall Apart Completely by SevenMinutesToMidnight (Barry Allen/Oliver, 8/8, 2022-07-07) - When Harrison Wells shows up, well… Diggle has to grab Oliver to prevent him from catching charges. The man’s like a raging bull, eyes practically flashing red and voice fierce like he’s talking down a drug lord and not one of the world’s leading scientists. Oliver doesn't scream, he just condemns the man, “You did this. You failed this city. His life is on you!” Diggle's glad he grabbed Oliver because the younger man was clearly moving to do something everyone would regret. Maybe Oliver wanted to be stopped though, because if he didn’t, then there’s no way Diggle could have done shit. [Alternatively: A series of Outsider POV's on Oliver during the months Barry is in his lightening induced Coma.]

Luke’s idiotic plan by Batwoman2019 (Kate Kane/Reagan, Oliver listed as character, 4/4, 2022-07-01) - What happens while Kate and Reagan are planning their wedding and someone calls in a tip to the police in order to have Reagan arrested. Will her friends and family be able to clear her name?

[theweekinarrowfic]

Completed Arrow Multichapters on AO3, June 2022

NOTE: I’m now crossposting to https://theweekinarrowfic.dreamwidth.org. Also, I'm looking for volunteers to test out my fic recommender! Need more Arrow in your life? Why not try one of the multchapter fanfics recently completed by our talented fic writers?

Olicity

Daughter of the Demon by Dweb08, laxit21 (Oliver/Felicity, 120/120, 2022-06-02) - What if in 1988 while traveling through Las Vegas Ra's al Ghul bumps into a nice waitress named Donna Smoak and they have one-night stand together? A little bundle of joy named Felicity Smoak is the result. In 2014, the Demon Head becomes aware of his youngest daughter's existence.

Love is above all things. by aphrodite161701 (Oliver/Felicity, 30/30, 2022-06-18) - Oliver Queen is with the Argus Agency. Five years ago, during a assigment, her partner, Felicity Smoak, was killed by the Hive Group. Now he must protect Meghan Kutler, an amnesiac woman, that Damien Darkh wants back. Who is this woman? What exactly does Darkh want. Why is he pursuing her ? Follow me through that story and get answers. Oliver is not the arrow... Tommy’s alive.

Love Never Dies by SG1Lover14 (Oliver/Felicity, 5/5, 2022-06-13) - Felicity has a secret. Multiple secrets. Will Oliver and the team find out? What will their reactions be?

Other Arrow Ships

Making A Better Future by ArrowverseFan833 (Laurel/Oliver, 72/72, 2022-06-28) - This is the sequel to Specter of Oliver Queen. Oliver is now on his way home from his five years in hell to protect his city. Little does he know that all of his friends know his secret and are going to be there to help him with his mission. Hopefully his friends can help him change things for the better of his city and his life as well.

unravel me by Bekka911 (Oliver/OFC (Tommy's sister), 36/36, 2022-06-20) - ""...and she knew that the Oliver that had come home to them was not the same Oliver that had gotten on that damned boat."" Cali Merlyn had a rough five years after the death of her best friend. Now, she works in the Starling Public Library and lives in a quaint little apartment she can easily call her own. She's getting better, she knows she is, but then Oliver returns and things spiral once more. Now, she has to deal with a new vigilante who uses arrows, her brother chasing after Laurel Lance, and her own suspicions of Moira Queen. All because Oliver Queen got on that goddamned boat five years ago.

New Earth: Arrow by DarkShado (Laurel/Oliver, 49/49, 2022-06-25) - My name is Oliver Queen. After giving my life to create a new multiverse, I was given a second chance, not only at life, but to correct my mistakes and save those I lost before. I am the Paragon of life and the Spectre, but most importantly, I am once again, the Green Arrow. Lauriver pairing. part one of New Earth saga. *Adopted from Lauriverfanboy1*

The Beginning of the Age of Heroes by ArrowverseFan833 (Laurel/Oliver, 32/32, 2022-06-09) - Oliver, Barry, Kara, Laurel, Sara, and Thea are all trapped on Lian after going on the Queen's Gambit to have a celebration. See how the team becomes the heroes that the world will need them to be in the future. (The group is all from Starling City. Kara is taken in by the Queens and Barry is taken in by the Lances.)

Karry Universe: Aquawar- Stuck in the Flux by KarryCoMaster, KarryMaster (Barry Allen/Kara Danvers, Laurel/Oliver as side pairing, 12/12, 2022-06-19) - Kara Allen is finally pregnant with Kent, but unfortunately for Rip she's now pregnant during the Aquawar. A war with Atlantis and time is now in flux and Rip and family are stuck in the flux

A Selective Gathering: Legend by ArlyssTolero, Nyame (Moira/Walter, 93/93, 2022-06-06) - A select group of individuals are brought to the Vanishing Point by The Spectre to learn how the future will unfold with Oliver Queen being sent back in time to prepare the world for the Crisis on Infinite Earths by reading "The Legend of the Green Arrow."

Strong by lilbluednacer (Roy/Thea, 4/4, 2022-06-13) - Thea isn’t weak anymore. But when she starts working for Team Arrow she learns how strong she really is.

The Hot Mess That is the Doctor’s Family by Lupin_and_Tonks_Forever (Malcolm-centric, 13/13, 2022-06-27) - What if Malcom Merlyn was actually Jack Harkness? And Rip Hunter was Rory Williams? And Sara Lance’s mom was really River Song? Well you’re about to find out. This started as a fix-it fic where Amy and Rory and Ianto live. And then it just spiraled from there. And I’m just ignoring that Lenny also died. Of course trouble ensues and where there’s trouble there’s the Doctor. There shouldn’t be any spoilers for Thirteen or the end of Twelve’s season. Also I literally stopped watching Arrow after season 5 and all of the other DC tv shows at that time too. So like I literally have no idea what is going on in canon there so I am just ignoring literally everything beyond that point. I do know that Constantine comes back at some point and so does Hartley. Also if you haven’t watched the Doctor Who episodes “World Enough and Time” and “The Doctor Falls” I would recommend you do that. There aren’t any spoilers but it would definitely add a lot more context to my fic.

Green Arrow: Full Circle by DarkShado (Laurel/Oliver, 4/4, 2022-06-25) - Team Arrow is Back in Buisness! After the Thanagarian Invasion, Team Arrow is back in Star City dealing with the everlasting crime and insane criminals

Free Game, Fun For Some But Not For All. by Acernusaurus (Sara/Ava Sharpe, 21/21, 2022-06-22) - No one knows what happened that night in the Queen family manor. And, cool as it might be, Ava Sharpe doesn't really expect to find out when her friend Nate buys the place. Who would have thought that game night would have the answer to one of Starling City's weirdest mysteries. A Jumanji (1995) AU

A Selective Gathering: Dawn by ArlyssTolero, Nyame (Moira/Walter, 75/75, 2022-06-21) - Those brought to the Vanishing Point by The Spectre to read the future decide to continue reading, beginning to read "The Dawn of the Golden Age."

Weak by lilbluednacer (Roy/Thea, 4/4, 2022-06-12) - When Thea can’t handle the guilt of what she did, it’s up to Team Arrow to save her from herself.

Black Canary: Rebirth by ArlyssTolero, Nyame (Laurel/Oliver, 19/19, 2022-06-21) - One moment, Laurel Lance is seizing on her hospital room bed, the next instant, she’s falling out of bed in her apartment eight years in the past. How is this possible? Who has done this to her? Laurel doesn’t know, but after taking stock of her life, both as it was in the future and as it is now, Laurel decides she doesn’t want to continue down the same path as before, a path that led to her death at the hands of a deluded man-child. With nothing but her clothes and a few personal belongings, Laurel flees Starling City and the coming years of supervillains, heading for her hometown of Gotham City, unaware that Gotham could now easily be considered the Supervillain Capital of the World. There, Laurel learns who she truly is, and the Black Canary shall rise from the ashes to make criminals everywhere tremble in fear of her name.

Dream Walker a Tale of Adventure and Sex by AvengingMikaelsonsLover (Original Female Character/Various, including Ricardo Diaz/OFC, 23/23, 2022-06-20) - Okay so.... this is an Old story off my hard drive it was written 5-14-2019. A Dream walker story this is the first of this type of story

United we stand, divided we fall by Bl4ckHunter (Oliver/Natasha Romanoff, 9/9, 2022-06-11) - An attempt of Tony Stark and Bruce Banner at creating a peacekeeping program Ultron backfires, so the Avengers, Oliver Queen and Barry Allen have to stand together against Ultron, despite the struggles that threaten to divide the entire group as they also face new enemies and find new allies.

Second Try by Linzero (Barry Allen/Leonard Snart, Oliver/Felicity as side pairing, 20/20, 2022-06-10) - After Barry is sentenced to imprisonment in the Speed Force, he is able to see how his life might have played out if he'd just made a few different choices. When Team Flash opens a portal to help him escape, Barry just can't resist the temptation to try a do-over. The starting point to fix Barry's mistakes? Ferris Air. If Barry can make the tiniest change to how it all went down, maybe he can save his loved ones and his future. But tiny changes can snowball, and there might be room in his definition of loved ones for a few enemies too.

Desperation. by Batwoman2019 (Kate Kane/Reagan, Oliver listed as character, 3/3, 2022-06-09) - There's so much some people can do when it comes around to being jealous. But what happens when Sophie shows she's jealous of not just Reagan but also her's and Kate's little girl. Will Sophie get what she wants or will she lose it all in the end.

Called Out In The Dark by SevenMinutesToMidnight (Barry Allen/Oliver, 14/14, 2022-06-09) - It starts when a green hooded vigilante appears. It's clear that he's targeting the corrupt upper echelons of Starling City and righting the wrongs Barry knows that the SCPD have failed to. From there, Barry is not sure if his life is going up or down hill, but it's certainly going somewhere even if it’s not really making sense anymore.

[theweekinarrowfic]

Completed Arrow Multichapters on AO3, April-May, 2022

NOTE: I’m now crossposting to https://theweekinarrowfic.dreamwidth.org. Also, I'm looking for volunteers to test out my fic recommender! Need more Arrow in your life? Why not try one of the multchapter fanfics recently completed by our talented fic writers?

Olicity

To be or not to be (a queen) by MiriRainbowitz (Oliver/Felicity, 2/2, 2022-04-26) - Felicity had had fairly ambitious life plans, but she'd never bothered to include "becoming Queen of a (small) European country when she turned 21". Still, she's not going to back away from her duty- especially now that some pretentious would-be usurper is trying to take her crown.

Complicated by m3m (Oliver/Felicity, 48/48, 2022-05-31) - Felicity Smoak is determined not to let her relationship with Oliver get complicated. She's been there, done that with a masked vigilante, and it ended very poorly, to say the least. But her plans are derailed by two things: her strong and unshakeable attraction to Oliver and Bruce's completely unexpected arrival at Queen Consolidated.

Other Arrow Ships

The One-Winged Crisis by Aragorn_II_Elessar (multifandom, several Arrow characters listed, 4/4, 2022-03-16) - Mar-Novu summons a powerful warrior to end the Anti-Monitor, but he didn't think it through, and now the Multiverse has to deal with an even greater threat.

The Archer, the Widow and the Purgatory by Bl4ckHunter (Oliver/Natasha Romanoff, 2/2, 2022-04-08) - When Oliver's wife, Natasha Romanoff and his friends and family are kidnapped by Adrian Chase who executes his endgame on Lian Yu, Oliver has to recruit allies and former enemies to save them.

DC Downfall by kuroWriter (Mia and Helena among characters listed, 13/13, 2022-04-03) - The DC ladies are captured, abused and murdered one after the other, by an unknown new enemy that seems to always be a step ahead of the ill-fated heroines

New Justice: Revenge Against the League by KarryCoMaster, KarryMaster (Kara Danvers/OFC, Sara/Tommy, Laurel/Oliver among side pairings, 12/12, 2022-04-10) - Crisis is over and life is returning to normal, but there are some loose ends from previous seasons that will come back to haunt the league. Who exactly wants revenge and what for?

Young And A Menace by SevenMinutesToMidnight (Barry Allen/Oliver, 7/7, 2022-04-26) - Barry is 16, on as many prescriptions as the doctor will allow for his ‘psychosis’, and furious with it. People who know, who saw his green smudge like paint, all say it's wasted on a freak like him. As much as he thinks about it, Barry is perfectly aware of how unwanted he is. Oliver Queen is 20, mindbogglingly rich, achingly beautiful, and high on the fast life. Most importantly though is that over the course of the night- as Oliver plies him with a rum and coke followed by more than a few Shirley Temples- Barry’s emerald green smudge begins to spell his name in a quick messy cursive script. It's a rather awe inspiring match to Oliver’s own red splotch spelling Barry’s name in his furiously quick chicken scratch.

Cleaning The Clocks by Crazy_Comet_97 (Digg/Oliver, 2/2, 2022-04-22) - It had happened so fast that he hadn’t noticed his heat had come and now, he was a mess. (A/B/O)

Rayon de soleil by Amelia_Queen (Oliver-centric, 5/5, 2022-04-16) - Dans un autre univers, sur une autre Terre, Oliver revient de l'île avec un enfant dans les bras. Garder tous ses secrets se révèle encore plus compliqué.

The Archer, the Widow and the Winter Soldier by Bl4ckHunter (Oliver/Natasha Romanoff, 8/8, 2022-04-15) - While working with S.H.I.E.L.D., Oliver Queen, Steve Rogers and Natasha Romanoff discover a deadly conspiracy from within, while facing the dangerous Winter Soldier and they will also have to face with more than one devastating betrayal and revelation.

A Trip to LA by Screvier (Laurel/Oliver, 7/7, 2022-04-11) - Felicity gets over her head helping John Constantine behind Team Arrow's back.

Team Lance by Regallyif (Sara/Ava Sharpe, 10/10, 2022-04-11) - When a mission to find the time pirates leads the Legends to some familiar faces, having Laurel on board gets a bit more complicated.

The Wedding that we've all been waiting for by HRwriter897 (Selina Kyle/Bruce Wayne, Nyssa/Sara/Oliver among side pairings, 7/7, 2022-04-06) - Bruce Wayne and Selina Kyle are finally tying the knot and everyone wants to be there to see it.

Burning Arrows by Crazy_Comet_97 (Oliver/OFC, 5/5, 2022-04-22) - British citizen Elizabeth Lestrade-Holmes, daughter of Mycroft and Gregory Lestrade-Holmes, was kidnapped off the streets of Westminster when she was 15 and was found in America 7 years later when she is 22 years old, but she is not the same Elizabeth who left. She holds a dark secret and when keeping it starts to spill over when navigating how to act normal once again, questions are being asked. How can she speak languages she never learnt? How does she do advanced military moves without even taking a self-defence class or even stepping foot into a barracks? And more pointedly, how on Earth is she friends with the rich American businessman Oliver Queen? (Originally posted in 2013)

No More Heroes - a Purge Night Story - Part 2 by dbud (multifandom, Isabel among characters listed, 11/11, 2022-04-25) - This a continuation of the story 'No More Heroes - a Purge Night Story'. A crossover of the Purge universe and the worlds created by the Marvel and DC universes as well as other's from movies and TV. A world where the heroes never came to pass and where murder, rape and every type of crime is legal one night per year. In this place, men of power and wealth come together every Purge night to indulge their darker whims. Unfortunately, in this world of no superheroes, there is no one to protect the women who might draw their attention. Even women of power and influence can find themselves at these mad men’s mercy.

Smut Series: Oliver Queen Gathering by Phillipe363 (Nyssa/Sara/Oliver, 4/4, 2022-03-01) - Just a story with chapters focusing on Oliver sleeping with various Arrowverse women either from my stories directly or original to this. Chapter 4 is Oliver Queen/Sara Lance/Thea Queen.

Cupid's Deadly Kiss by Batman_Batgirl_XXX (TottPaula) (Barbara Gordon-centric, Oliver/Felicity as side pairing, 8/8, 2022-05-09) - Barbara Gordon is known as cold and distant, and Bruce Wayne's rep says he's a womanizer. Barbara reluctantly agrees to be Bruce's date to a charity night after her dad begs her for a favor. It morphed into a delightful evening as they become acquainted. The Batsignal interrupts the night calling for Batman, and Batgirl answers as well, coincidentally, both heading to the exact unused room to switch identities! They fight a new criminal mastermind armed with tainted arrows, Batgirl is later struck down and collapses unconscious! Complications arise! Stay tuned to this tv channel, and don't touch that dial!

When Demon Hunters Meet The Arrow by The_Unlimited (Dean Winchester & Sam Winchester, Laurel/Oliver, 12/12, 2022-05-23) - Discovering a new job happening in Starling City, Sam and Dean decide to head up there despite all of the dangers of their resident vigilante. Pretty soon, they're working with that vigilante to search for the monsters they have to take out, and end up helping him discover the truth of more than a few of the problems happening to his city and to his family and friends. Maybe they should have let Garth take care of this one...

Parents by Amelia_Queen (Kara Danvers/Oliver, 2/2, 2022-05-07) - La rencontre avec la figure parentale de son âme sœur ne se passe pas toujours dans les meilleures circonstances.

there it is again (that funny feeling) by AllHaleOlicity (OC/OC (next gen), 36/36, 2022-05-20) - After quitting his job at the Star City Hospital, Q Lance decides to visit his sister in LA. But he didn't expect to be stuck on the couch for more than a week. A few months have went by and just before deciding whether or not it's time to go back and beg for his previous position at the hospital, he meets a girl who runs a coffee shop on a small street corner. She knows nothing about Star City drama or vigilantes. Perfect for Q, who would prefer to stay away from the city, and topics surrounding it, for as long as possible.

I Know Why The Caged Bat Can't Sing by AshWinterGray (Tim Drake-centric, Oliver/Felicity as a side pairing, 16/16, 2022-05-20) - Living on the Earth now deemed ""New Earth"" by the Bats, Tim has to adjust to having a family slightly different than his old one. But things aren't nearly that simple. Huntress, Powerwoman, and Powerman were but the first to come from their Earth, and now Tim finds himself trapped in a plot he had hoped would never come to be. Secrets not even Tim fully understands come to light, and the Bats find the need to separate in order to properly piece the puzzle together, but it means putting each of them at risk, and every step they take can lead to a trap that could cost their lives. Or their sanity. Perhaps Dick's insistence that Tim make friends wasn't so misplaced after all.

Reasons Wretched and Divine by SevenMinutesToMidnight (Barry Allen/Oliver, 2/2, 2022-05-28) - When Oliver came to him and asked if he wanted to go on The Gambit for Robert’s trip, he’d said no. Barry has school to think about and he’s not about to intrude on a Father-Son outing with the Queens. He’s learned how to judge what trips he should go on. So, he says no. Tommy isn’t going and it's a trip to Hong Kong for actual business so obviously Barry has no reason to be there as Robert’s stand-in buddy or whatever. It’s not until Oliver looks at him and says, “I fucked up Bear.” Then proceeds to go into horrible detail about all the things he’s done to blow up his relationship with Laurel that Barry agrees to come. Oliver is hurting and while it's his own damn fault, Barry’s job has always been to be there for him. Even when it breaks his own heart. [Alternatively: AN AU of my AU where Oliver doesn't kiss Barry, which leads him to join Oliver on The Gambit]

Don't You Know Who I Used To Be? by SevenMinutesToMidnight (Barry Allen/Oliver, 8/8, 2022-05-27) - When he returns he brings the weight of grief as well as a motorcycle that’s black, sleek, and seems like it belongs in a car magazine and not the parking garage of their building. Barry tells her very quietly one day, “The bike, it's a Ducati. It was Oliver's. We- We used to ride it on days he didn’t drink. One time, I bribed him to come to one of his mother’s parties by telling him I’d learn to ride it. I was so upset about it. The party sucked so much I really didn’t want to learn." It's the first time he cries in front of her and Barry is 6 feet tall but he looks so small at that moment. All Iris can do is be there for him, holding his hand and it’s devastating and feels like she’s been thrown into water that’s far too deep to swim in but afterwards Barry thanks her so quietly she thinks she might have dreamed it. [Alternatively: Barry Allen through the years in the eyes of the people that love, or have grown to love him.]

Glee and Arrowverse High School AU by AvaLanceisForever2021 (Sara/Ava Sharpe, 5/5, 2022-05-01) – no description

Stepping Back From The Throne by okoriwadsworth (Barry Allen/Patty Spivot, Laurel/Oliver as side pairing, 21/21, 2022-05-15) – no description

[theweekinarrowfic]

Completed Arrow Multichapters on AO3, February-March, 2022

NOTE: I’m now crossposting to https://theweekinarrowfic.dreamwidth.org. Also, I'm looking for volunteers to test out my fic recommender! Need more Arrow in your life? Why not try one of the multchapter fanfics recently completed by our talented fic writers?

Olicity

Frequency by Magspseudonimo (Oliver/Felicity, 10/10, 2022-02-28) - Mia Smoak-Queen lost another person she loved, but an old machine will bring a breath of hope into her life.

Merry Me by SmoakingGreenArrow (Oliver/Felicity, 9/9, 2022-02-02) - Oliver didn't expect to find himself at a Felicity Smoak concert/wedding. He didn't expect her fiancé to cheat on her before the event, either. And he certainly didn't expect the singer to call him up on stage to marry her instead.

The Knight of Swords and the Queen of Cups by sec982 (Oliver/Felicity, 37/37, 2022-03-03) - In a world where everyone has a soulmark on their wrist, Felicity Smoak chooses to ignore her own. She's too busy starting her career and explaining to her mother that she doesn't want to read Tarot cards like her grandmother did. Then one night, while working late, she draws the Knight of Swords, a card of impulsive action. She takes it as clear evidence that the tarot cards do not work. She dismisses it and takes a memo up to the CEO's office, where her own knight of swords comes crashing into her life in an irreversible way.

Love Will Find You by TaraB1915 (Oliver/Felicity, 41/41, 2022-03-24) - Oliver Queen meets Felicity Smoak for the first time AFTER his release from Slabside. {How will that be} With no love in his life and no one to harness the last remnants of light inside of him, Oliver's killer instincts remain strong. Beneath the surface he is not coping with his PTSD, heightened by his time in Slabside. Events will force him to confront his mental health and the struggle with his Green Arrow identity. Felicity Smoak is the unapologetic trust fund babe, with a big heart hidden beneath it all. Their first meeting does not begin well but she is his salvation.

Post it by Magspseudonimo (Oliver/Felicity, 23/23, 2022-03-27) - Everyday Felicity loses yesterday, Oliver can't let go of yesterdays can they meet in the middle and move forward?

Safe Moments: Part Two by sec982 (Oliver/Felicity, 21/21, 2022-03-14) - After the trial of Dr. Natural and Roy's kidnapping and injection with Mirakuru, Oliver is on edge. Felicity is heavily pregnant, and the whole team is worried about whether or not Slade Wilson is really back. The recasting of moments from the second half of season two in the safe universe. You do need to read the rest of the series first, but it's worth it!

This Life to the Next by SmoakingGreenArrow, smoakqueenfam (Oliver/Felicity, 20/20, 2022-03-22) - Hiking deep in the Hindu Kush mountains with her fiance, Felicity Smoak stumbles upon a small village and a young woman, whose palm reading abilities throw her for a loop. Felicity doesn’t expect this woman’s words to have an everlasting effect on her. Later that evening, with a buzzing sound ringing in her ears, she follows a path to a waterfall that transports her life back 100 years to a man who throws her world completely off track. Surrounded by men in long black cloaks, and masks covering their faces, Felicity fights the overwhelming urge to run. Instead she is met with crystal clear blue eyes that ground her in a way she didn’t quite understand. An instant chemistry forms, along with an abundance of questions. Who is this man? Where is she? Why is she here? And most importantly, how will she make it back to Ray? Or more importantly, will she want to? An Olicity Outlander AU

Other Arrow Ships

Guide Me To Home by dawnofarchives (Nyssa/Sara, 11/11, 2022-02-08) - ‘‘She’s not a child, Sara. She’s a seventeen-year-old with a life.’’ Or, the one where Nyssa and Sara kinda-not-really adopts a certain vigilante named Evelyn Sharp.

Syndicate by Sophia205 (Adrien Agreste/Marinette Dupain-Cheng; Arrow fusion, Marinette is the Arrow, 39/39, 2022-03-03) - This is a mix of Miraculous Ladybug and Arrow. Marinette and her family had been off to visit family when their plane went down. Marinette was alone on an island for 6 years before finding a way home. now she has to cope with everything around her.

Cicatrices by Amelia_Queen (Kara Danvers/Oliver, 3/3, 2022-02-11) - Chacun des enfants d’Oliver aborde ses cicatrices différemment.

FBI by Batwoman2019 (Kate Kane/Reagan, Mia listed as character, 21/21, 2022-03-25) - What happens five months after the whole thing with Black Mask and Circe Sionis Kate comes back to Gotham only to become the cause of an investigation. Will the super heroes be able to keep her out of jail?

Choices and Ultimatums by NikolaosT (Slade listed among characters, 11/11, 2022-02-15) - It all came down to this moment. Standing on a roof opposite his former team. He knew what he had to do, but doing so would have him crossing yet another line that he never thought he would cross. He did this and he killed another part of him that used to make him Robin. There would be no going back.

Green & Black (Chinese Translation) 绿与黑 中文翻译 by Sophia_C (Malcolm & Oliver, 35/35, 2022-02-02) - Oliver发现，他最好的朋友的父亲是他最致命的敌人。Malcolm发现，他最大的敌人是他最好的朋友的儿子。两个走在不同道路上的人，能否达成拯救自己城市的同一目标？接《绿箭侠》第一季第22集展开的正剧向平行宇宙故事。

Verdant by The_Ghost_Has (Sara/Oliver, 3/3, 2022-02-04) - A man is reborn as Oliver Queen right before he goes back to Starling City, read on his adventure towards being a badass version of Oliver Queen and The Green Arrow

Legacy by closemyeyesandleap (Sara/Ava Sharpe, 6/6, 2022-03-30) - Sara and Ava’s teenage daughter will stop at nothing to meet her Aunt Laurel. Sara is finding it harder and harder to say no. (Can be read alone or with other stories in the series.)

Secrets. by Batwoman2019 (Kate Kane/Reagan, several Arrow characters listed, 2/2, 2022-03-21) - What happens two years later and Mary finds something that both Luke and Sophie wanted to remain hidden will the truth help Kate get the woman she loves back or will one more secret keep them from being together?

The Gladiator's Chaos Crisis by HRwriter897 (several Arrow characters listed, 4/4, 2022-03-19) - Mar Novu, seeing the battle with the Anti-Monitor about to be lost, summoned a warrior more than capable but it backfired, the Multiverse now having to deal with an even greater threat, one that threatens the entire order of the Multiverse and to engulf it in Chaos.

The Infinity Crisis by Bl4ckHunter (Oliver/Natasha Romanoff, 15/15, 2022-03-12) - When the Mad Titan Thanos begins his conquest to gather all six Infinity Stones and wipe out half of life, the heroes must stand together to face the threat to the entire universe, or maybe even more.

When two loves collide (it´s going to be a hell of a ride) by vallyqueen (Sara/Ava Sharpe, Nyssa/Sara, 5/5, 2022-03-02) - Because of an alien alert, the Legends travel to the Himalaya mountains present day, but they aren´t the only ones, who are after the intergalactic creature. Nyssa, whose sister Thalia has been taken by the beast after an encounter, wants to free her sister and asks for Sara help, when she figures out, they have the same enemy and soon, there are a lot more problems than just the dangerous alien, they hunt. I´ve always wondered, how a meeting between Ava and Nyssa would look like, but I didn´t find a story, which I completely agreed with, so I tried to come up with my own.

The Demon's gamble by R4ik3n (Talia/Oliver, 12/12, 2022-02-15) - AU post 3x09. After losing the duel to Ra's, Oliver is saved by his former teacher Talia, who helps Oliver find his path again and channel his darkness, doing whatever it takes to stop Ra's.

Husband? by dawnofarchives (Nyssa/Sara, 2/2, 2022-02-05) - Oliver Queen should've known that his day was going to go downhill when his phone rang. Getting a call from the Heir to the Demon was one thing. Getting a call from her, as she called you "Husband" on loudspeaker, as you looked at your girlfriend-not-quite was another.

Amazo, Mirakuru, Lianyu, and salvation by Panda_Tea_0624 (Sara/Ava Sharpe, 2/2, 2022-02-06) - "Oliver Queen, the green arrow, was injected with mirakuru on a ship called Amazo by a man named Dr. Anthony Ivo. This was not supposed to happen in the correct timeline, so the mission is to stop that from happening" or Sara finally gets to deal with her emotional trauma because of Ivo, and Ava was there for her. Oliver was only the theme of the mission, he did not have an appearance."

Dinner with the Queens by Regallyif (Sara/Ava Sharpe, 6/6, 2022-02-04) - Just some domestic Avalance to placate my frustration that Ava has never met any of Sara's old friends. Set during Season 4 of Legends

The Hood and the Widow by Bl4ckHunter (Oliver/Natasha Romanoff, 31/31, 2022-03-07) - ! Discontinued, no sequel planned ! When Oliver meets an interesting woman in Russia, they both find themselves on a path of seeking justice and later redemption.

The War of Shadows by HRwriter897 (Selina Kyle/Bruce Wayne, Laurel/Tommy, Nyssa/Sara/Oliver among side pairings, 19/19, 2022-03-12) - The Joker is dead by the Batman's hands. Ra's al Ghul comes to Gotham to make the Detective his heir but the Dark Knight stands his ground against the Demon's Head.

[theweekinarrowfic]

Completed Arrow Multichapters on AO3, January 2022

I’m baaack!

NOTE:  I’m now crossposting to https://theweekinarrowfic.dreamwidth.org. Need more Arrow in your life?  Why not try one of the multchapter fanfics recently (-ish) completed by our talented fic writers? 

Olicity

Time goes by by Liz2027 (Oliver/Felicity, 2/2, 2022-01-11) - Oliver is in an accessed that puts him in a coma but he wake up two years later."

Le Prix d'une nouvelle vie by Amelia_Queen (Oliver/Felicity, 8/8, 2022-01-21) - Oliver reçoit une visite en prison qui lui donne l’idée d’un cadeau pour sa famille. Mais rien ne se passe jamais comme prévu et Felicity va le découvrir à ses dépens."

Olicity: A whisper to the heart by Dnm (Oliver/Felicity, 6/6, 2022-01-06) - I got insppired by someone in twitter that made a scene on 6x12 . It starts with Felicity giving Oliver the news that she is pregnant. I imagine it happens a couple months after their 1 year anniversary. And its also available in wattpad"

Night at the museum by Liz2027 (Oliver/Felicity, 2/2, 2022-01-26) - John Diggle is a guard at a mysteries museum. He notices strange things happening with the Green arrow statue and the Overwatch statue."

Home by Magspseudonimo (Oliver/Felicity, 2/2, 2022-01-17) - After the island, China and Russia, Oliver worked for Argus until he had enough of Waller ways, he left to work for Diggle Security as a bodyguard. He work, he went home, he pretend like he was happy in front of his sister, he went to work again, he didn't deserve anything more, he is auto pilot until his past comes back and catches up him him, he is just waiting. His last job was different tough he found something he didn't even knew he was looking for it, a family, if only he was brave enough."

Other Ships/Characters

Revenge of the Black Swans. by Batwoman2019 (Kate Kane/Reagan, Oliver/Felicity as side pairing, 2/2, 2022-01-26) - What happens when the two people Mark thought were dead arrive in Gotham to get pay back. Will the Bat team be able to stop them or stay out of it."

Dependencia by dogoncabrera2 (Oliver/Harleen Quinzel, 3/3, 2022-01-20) - ACLARACION: Esta versión de Harley es diferente la de Margot Robbie, también es muy diferente a la versión de su serie animada si esperas algo así te sentirás decepcionado, sobre advertencia no hay engaño lee bajo tu propio riesgo. Si quieres mas información ve a la sección de aclaraciones Sinopsis: Después de una fragmentación con su equipo Green Arrow se encuentra con Harley Quinn que al parecer busca redimirse por su pasado ¿Qué hará Green Arrow? ¿La entregara al murciélago? ¿La llevara a la cárcel? Lo mas probable es que algo mas pase..."

Ships in the Night by Emmeebee (Felicity/Tony Stark, 6/6, 2022-01-20) - With shared interests in computers and superhero justice, Felicity and Tony have more in common than most. By the time they find themselves standing in her living room, their secrets laid bare, they’ve almost met more times than either of them know. (Or: Five times Felicity and Tony almost meet, and one time they do.)"

Cage Full Of Killers by F_my_entire_life (Derek Hale/Stiles Stilinski, Oliver listed as character, 6/6, 2022-01-07) - Stiles and Derek get picked to be the tributes for District 12. Stiles only has one ability he can use, he can talk to animals, wolves mostly."

The Magic Bar by wheel_pen (John Constantine/Leonard Snart, 3/3, 2022-01-05) - Lenny intercepts John after a bad day at work, interrupting his usual downward spiral."

Naruto - Arrow by FrostZero007 (Naruto/Laurel/Thea/Felicity/Helena/Sara, 6/6, 2022-01-18) - aruto is reborn in the Queen family. This is the same Arrow, but instead of Oliver, the main character is Naruto. What decisions will he make and what will they lead to? Naruto / Harem"

Paragons by megamatt09 (Harry Potter/various including Harry/Mia, 22/22, 2022-01-21) - Harry Potter always has been determined to the point of madness. The coming Crisis will test his determination even more. Harry/Multi."

Alternate Timeline by drchemist (Oliver-centric, multiple ships listed, 24/24, 2022-01-19) - Alternative world to the one set in Arrow where Oliver never left on the Queen's Gambit and stays to work at Queen Consolidated, fulfilling his desire of being Starling City's biggest playboy"

Hope is never lost by Marhitee (Sara/Ava Sharpe, 3/3, 2022-01-02) - Ava y su compañera habían pasado por mucho en estos dos años desde que el caos comenzó y sabían que no debían fiarse de nadie dada su condición, pero la llegada a una comunidad puede hacerte cambiar de parecer al encontrar personas por las cuales vale la pena darte una oportunidad y quizá quien sabe, esto pueda acabar mas pronto que tarde si encuentras la ayuda adecuada."

A Girlfriend for Christmas. by Batwoman2019 (Calamity/Beca Mitchell, Thea listed as character, 10/10, 2022-01-15) - What happens when a year earlier a plane had come down and all on board had survived but one person did come out of the crash with no memory of the Bellas former rival's or the woman she loves."

Don't Call me Baby by swarley18 (Sara/Ava Lance, 16/16, 2022-01-30) - While schmoozing Star City’s elite at her husband’s fundraising gala, Sara meets a mysterious woman, who not only sweeps her off her feet, but will change her life in more ways than Sara could ever imagine. Ava returns to Star City after a lifetime away, hell bent on getting justice for her murdered parents, but her plan gets complicated when she starts to develop real feelings for one of her marks."

Avengers Injustice Heroes Among Us by HeroWitch (Thor & Kara Zor-El, Dinah Lance and Oliver listed as characters, 20/20, 2022-01-13) - (Injustice 2 MCU Arrowverse) Thor and the Guardians of the Galaxy discover a new Earth where a Supergirl, Batman, and Superman exist. As Thor meets the new Kara, he must protect this Earth from the terrible Brainiac, but he don't know that an even more terrible danger is brewing and that could threaten the entire universe."

Cross Destination by GabbySaky (Felicity-centric, 59/59, 2022-01-29) - Felicity Smoak morou em Vegas desde que nasceu. Quando teve a oportunidade de fazer uma boa faculdade, ela foi para Starling e conheceu alguém que transformou sua vida. Ela se apaixonou, foi correspondida, e viveu feliz com o jovem mais cobiçado e rico de Starling City, mas tudo desmoronou e coisas realmente dolorosas a fizeram voltar para Vegas. Lá ela fez uma descoberta assustadora, mas ao mesmo tempo incrível, algo que mudaria sua vida para sempre. Depois de 6 anos ela estava de volta em Starling. Desesperada. Assustada. Fugindo para salvar a ela e aos seus filhos. E isso acarretará em reencontro, alguém que ela não pensava em reencontrar, não depois de tantos anos. Oliver Queen. Agora a mulher de expressivos olhos verdes-oliva terá que explicar o que houve com ela em todos aqueles anos que se passaram, o por que de ela fugir e por qual razão escondeu a existência de duas crianças, gêmeas, do pai. Ele vai querer saber de tudo e então descobrirá não só o perigo que cerca a mulher que ama e seus filhos, mas também coisas desastrosas que o magoará no processo."

The Proposal AU by Hera_avalancefan14 (Sara/Ava Sharpe, 10/10, 2022-01-17) - You read it right. This is one of my fave romcom movie and why not make this an AVALANCE AU. I made some moderation out of it. You know, to make it easy for you guys!"

It’s just an Echo (of All the Things I Hate About Me) by Ashes737 (Sara/Ava Sharpe, 14/14, 2022-04-23) - Sara Lance counts her time in the League of Assassins as one her greatest sins and most plaguing regrets. While there's no doubt her time spent training with the League has given her an edge as a Legend, it's ultimately a part of her past that she would like to keep buried, but when a young girl's plea for help draws Sara, Ava, and several of the Legends back into the League's influence, Sara will have to come to terms with the League of Assassin's role in shaping her life and who she has decided to make herself into without it. -or- When Sara, Ava, Charlie, and Constantine are called upon to save a young girl from the League of Assassin's influence, Sara must come to terms with what it means to re-enter the League and see just how far she's willing to go to escape it again."

When Two Worlds Collide by Sharpe_Lance (Sara/Ava Sharpe, 36/36, 2022-01-23) - EARTH: A dying planet that will eventually be unable to support human life, so ships are sent off into the cosmos to go in search of new planets. OSSORY: 4,000 years after a war between the Alphas, Omegas and the Betas where two factions tried to eradicate the Beta's the Ossarans are now facing extinction. For generations the number of births has declined. To save there race they send out Scientific Exploration Ships to search for compatible races that might be able to help. Will these two desperate races find each other in time? Will they be compatible? Find out When Two Worlds Collide

whoever, whenever, you are (you're alive) by red_banner (Nyssa/Sara, 4/4, 2022-01-08) - She hadn’t quite gotten the whole story; Ava clones looked as surprised as she had felt to wake up in a room collapsing around her. She was told of science and code and a plan about the universe and planets. Clone. She is Sara Lance’s clone and is built in such a way that the memories of Sara Lance’s life stand intact in a way that demand to be felt and owned by this… by whoever she is now. Not only that though because, apparently, there is already another Sara Lance clone; built only hours before her, one who had escaped only seconds before she woke up. or There is another Sara Lance clone and things get complicated. or How Nyssara can still win."

A Second Chance by writewithurheart (Tommy-centric, 21/21, 2022-01-24) - When Oliver finds Tommy in CNRI, he thinks he's too late and is forced to flee to avoid the cops. But Tommy is rescued from the rubble. He survives his injuries and decides to use his second chance to help people the way he always wanted to.

𝐃𝐄𝐒𝐓𝐑𝐎𝐘𝐄𝐃 || 𝐎𝐋𝐈𝐕𝐄𝐑 𝐐𝐔𝐄𝐄𝐍 by salvatqre (several Arrow characters listed, 10/10, 2022-01-04) – no description

[theweekinarrowfic]

Always fun when you hit a problem you’d never think you’d encounter.  I’ve seen fics with 0 words before (like someone uploaded a moodboard or something), but apparently AO3 looks at some Polish text and is like, word count?  I couldn’t tell ya.

I clicked on the fic and it definitely has words.

[theweekinarrowfic]

Progress, August 2022

I’m to the point where I have a file with some scraped data!  Now I’m trying to import that into SQL and:

Sigh.

[theweekinarrowfic]

I’m making progress!

Four months later, and I’ve finally found some time to work on my scraping code--which was not at all far along when I worked on it last.  Here’s what I’ve got so far (scraping the search results for a different fandom, but you can at least get an idea):

work numbers ['39376164', '34412509', '25245898', '36740236', '39393723', '39677205', '24502618', '39153300', '38348827', '26021761', '39547734', '39507039', '38074345', '39115020', '39519678', '39489381', '36042388', '39469899', '39465267', '38844051'] 20 work websites ['https://archiveofourown.org/works/39376164', 'https://archiveofourown.org/works/34412509', 'https://archiveofourown.org/works/25245898', 'https://archiveofourown.org/works/36740236', 'https://archiveofourown.org/works/39393723', 'https://archiveofourown.org/works/39677205', 'https://archiveofourown.org/works/24502618', 'https://archiveofourown.org/works/39153300', 'https://archiveofourown.org/works/38348827', 'https://archiveofourown.org/works/26021761', 'https://archiveofourown.org/works/39547734', 'https://archiveofourown.org/works/39507039', 'https://archiveofourown.org/works/38074345', 'https://archiveofourown.org/works/39115020', 'https://archiveofourown.org/works/39519678', 'https://archiveofourown.org/works/39489381', 'https://archiveofourown.org/works/36042388', 'https://archiveofourown.org/works/39469899', 'https://archiveofourown.org/works/39465267', 'https://archiveofourown.org/works/38844051'] 20 fic names ['Heartbeat', 'Of Foxes and Wolves', 'Emerald Eyed Mystery', 'Sexual Adventures in Beacon Hills', 'Radiate', 'Preparations', 'Uncrowned Royals', 'Nouvelles aventures', 'Bridge Between Us', 'Day In and Day Out', 'Broken Promise', 'All These Little Things (will catch up to you)', 'If I Go Down, You’re Coming With Me', 'Smoke Signals', 'Loud is the Scream (Louder is the Silence)', "I'm Grounding All My Fears", 'You Feel Like Home', 'An Original Stiles (Mieczyslaw)', 'The Ten (15) Year Plan', 'challenges that come from you'] 20 first author names (plus other junk in some cases) ['Jiminiesaur', 'AmeYuki32', 'QueenOfAngst21', 'drchemist', 'supitsme4444', 'XOLittleRed', 'Totallynotashieldagent', 'Looky37', 'mischief24', 'herefortheparty', 'BeaconFallsMonsters', 'archergwen', 'LullabliesAndDreams', 'pastaslut', 'OIlie', 'secretly_a_spacaecadet', 'just_let_me_be', 'KillSecured', 'Phoebsfan', 'orphan_account'] 20 first author websites ['https://archiveofourown.org/users/Jiminiesaur/pseuds/Jiminiesaur', 'https://archiveofourown.org/users/AmeYuki32/pseuds/AmeYuki32', 'https://archiveofourown.org/users/QueenOfAngst21/pseuds/QueenOfAngst21', 'https://archiveofourown.org/users/drchemist/pseuds/drchemist', 'https://archiveofourown.org/users/supitsme4444/pseuds/supitsme4444', 'https://archiveofourown.org/users/XOLittleRed/pseuds/XOLittleRed', 'https://archiveofourown.org/users/Totallynotashieldagent/pseuds/Totallynotashieldagent', 'https://archiveofourown.org/users/Looky37/pseuds/Looky37', 'https://archiveofourown.org/users/mischief24/pseuds/mischief24', 'https://archiveofourown.org/users/herefortheparty/pseuds/herefortheparty', 'https://archiveofourown.org/users/BeaconFallsMonsters/pseuds/BeaconFallsMonsters', 'https://archiveofourown.org/users/archergwen/pseuds/archergwen', 'https://archiveofourown.org/users/LullabliesAndDreams/pseuds/LullabliesAndDreams', 'https://archiveofourown.org/users/pastaslut/pseuds/pastaslut', 'https://archiveofourown.org/users/OIlie/pseuds/OIlie', 'https://archiveofourown.org/users/secretly_a_spacaecadet/pseuds/secretly_a_spacaecadet', 'https://archiveofourown.org/users/just_let_me_be/pseuds/just_let_me_be', 'https://archiveofourown.org/users/KillSecured/pseuds/KillSecured', 'https://archiveofourown.org/users/Phoebsfan/pseuds/Phoebsfan', 'https://archiveofourown.org/users/orphan_account/pseuds/orphan_account'] 20 fandoms ['Teen Wolf (TV)', 'Teen Wolf (TV)', 'Teen Wolf (TV)', 'Teen Wolf (TV)', 'Teen Wolf (TV)', 'Teen Wolf (TV)', 'Teen Wolf (TV), The Originals (TV), The Vampire Diaries (TV)', 'Teen Wolf (TV)', 'Teen Wolf (TV)', 'Teen Wolf (TV)', 'Teen Wolf (TV)', 'Teen Wolf (TV)', 'Teen Wolf (TV)', 'Teen Wolf (TV)', 'Teen Wolf (TV)', 'Teen Wolf (TV)', 'Teen Wolf (TV)', 'Teen Wolf (TV)', 'Teen Wolf (TV)', 'Teen Wolf (TV)'] 20 rating ['Explicit', 'Mature', 'Teen And Up Audiences', 'Explicit', 'Teen And Up Audiences', 'General Audiences', 'Teen And Up Audiences', 'General Audiences', 'Mature', 'Mature', 'General Audiences', 'General Audiences', 'Teen And Up Audiences', 'Not Rated', 'Teen And Up Audiences', 'Teen And Up Audiences', 'Mature', 'Teen And Up Audiences', 'Explicit', 'Explicit'] 20 archive warnings ['Graphic Depictions Of Violence', 'Graphic Depictions Of Violence', 'Graphic Depictions Of Violence, Major Character Death', 'Underage', 'Choose Not To Use Archive Warnings', 'Choose Not To Use Archive Warnings', 'Choose Not To Use Archive Warnings', 'Graphic Depictions Of Violence', 'Choose Not To Use Archive Warnings', 'Choose Not To Use Archive Warnings', 'Choose Not To Use Archive Warnings', 'No Archive Warnings Apply', 'Choose Not To Use Archive Warnings, Graphic Depictions Of Violence', 'No Archive Warnings Apply', 'Major Character Death', 'No Archive Warnings Apply', 'Choose Not To Use Archive Warnings', 'Choose Not To Use Archive Warnings, Graphic Depictions Of Violence, No Archive Warnings Apply', 'No Archive Warnings Apply', 'Choose Not To Use Archive Warnings'] 20 relationship categories ['F/M, M/M', 'F/M, M/M, Multi', 'M/M', 'F/F, F/M, Multi', 'No category', 'F/M, M/M', 'F/M, M/M', 'No category', 'No category', 'F/M', 'F/M', 'F/M', 'F/M, Gen', 'F/M', 'Multi', 'Gen', 'F/M, M/M, Multi', 'F/M, Gen, Other, F/F, M/M', 'F/M', 'F/M'] 20 complete or WIP ['Work in Progress', 'Work in Progress', 'Complete Work', 'Work in Progress', 'Work in Progress', 'Complete Work', 'Work in Progress', 'Work in Progress', 'Work in Progress', 'Work in Progress', 'Complete Work', 'Complete Work', 'Work in Progress', 'Work in Progress', 'Complete Work', 'Complete Work', 'Work in Progress', 'Work in Progress', 'Complete Work', 'Complete Work'] 20 date updated ['19 Jun 2022', '19 Jun 2022', '18 Jun 2022', '16 Jun 2022', '16 Jun 2022', '16 Jun 2022', '15 Jun 2022', '14 Jun 2022', '11 Jun 2022', '10 Jun 2022', '09 Jun 2022', '09 Jun 2022', '09 Jun 2022', '08 Jun 2022', '08 Jun 2022', '07 Jun 2022', '07 Jun 2022', '06 Jun 2022', '06 Jun 2022', '04 Jun 2022'] 20 language ['English', 'English', 'English', 'English', 'English', 'English', 'English', 'Français', 'English', 'English', 'English', 'English', 'English', 'English', 'English', 'English', 'English', 'English', 'English', 'English'] 20 words ['21,391', '17,840', '173,570', '192,542', '3,632', '3,668', '98,523', '4,276', '36,346', '29,584', '962', '2,862', '122,592', '5,288', '4,601', '2,969', '42,774', '2,254', '5,006', '15,470'] 20 comments ['39376164>1', '34412509>6', '25245898>271', '36740236>18', '396772053', '24502618>203', '26021761>39', '395477341', '38074345>9', '39115020>6', '395196782', '36042388>8', '394698992', '394652671'] 14 kudos ['39376164>50', '34412509>43', '25245898>1659', '36740236>60', '39393723>1', '39677205>41', '24502618>271', '39153300>1', '38348827>15', '26021761>62', '39547734>17', '39507039>13', '38074345>60', '39115020>16', '39519678>6', '39489381>1', '36042388>41', '39469899>10', '39465267>37', '38844051>14'] 20 bookmarks ['39376164>8', '34412509>3', '25245898>431', '36740236>17', '39677205>3', '24502618>41', '38348827>1', '26021761>13', '39547734>3', '38074345>4', '39115020>1', '39519678>3', '36042388>13', '39469899>2', '39465267>5', '38844051>2'] 16 hits ['1593', '734', '78848', '14324', '27', '295', '10456', '45', '865', '1988', '172', '184', '1694', '184', '84', '15', '1150', '184', '297', '224'] 20

What I have left to do:

Get the descriptions - right now it’s pulling in each new paragraph as a separate item instead of giving me 20 items, so I don’t know which paragraphs go to which fic.  I also need to see what happens when there’s no description at all and make sure that doesn’t cause errors

Get the tags - I currently get all tags with no commas between, which is obnoxious

Get series information - forgot about this entirely

Comments, kudos, and bookmarks - need the work # split from the data and then it needs to be combined with the variables that every fic has, taking into account that if it’s missing for a fic then it should be 0

Make a way to loop through a certain # of pages and/or all pages.

Expand the author coding to deal with coauthors and gifts

Revamp the process of pulling the data into SQL, since this is in a different format than the files I used to get from the online scraper.

[theweekinarrowfic]

The Week in Arrow Fic is on Hiatus

Well, crap.

The web scraper I use to pull data from AO3 is gone.

I’ve just poked around a little and I’m not seeing another good option--I want web-based rather than having to download an application that might be malware, and I tried browser extensions a few years ago and couldn’t make them work.

In theory, I could scrape using Python--I wrote a program to scrape kudos, but the actual fic data structure is a lot more complicated, and I already have a lot going on so I’m not sure how much time I’m going to be able to devote to another computer project.  But that probably is the correct answer, because then I’m not reliant on another third party who might shut down the service at any time.

Ugh.

Let me get some breakfast and try to find my notes from where I started trying to figure out how to scrape the fic info.  Maybe I’m further along than I think, but, yeah--the monthly post I had planned to do today is definitely not going to happen.

[theweekinarrowfic]

The Year in Arrow Fic, 2021

This is my third year providing some statistics on Arrow fanfiction on AO3 (see 2019 and 2020). 

My data are based on weekly scrapes of recent unlocked fics tagged Arrow. The totals differ slightly from a hand count of fics on AO3 today (1,725 in my database vs. 1,613 based on a hand count) because, on the one hand, my scraping tool does not capture locked fics, but on the other hand, I have fics that were posted or updated in 2021 but have since been deleted.  (The 113 fic difference is much larger than in previous years.  I’ve noticed a rise in “fics” that are just requests for help locating another fic, which tend to be deleted after the searcher finds the fic, so that may explain it, although it could legitimately be that more authors are deleting actual fics as well.)

The 1,725 fics represent a dramatic decrease from 2020 (44%).

By Ship:  Olicity remains the most ficced ship at 19% of all Arrow fics, although this is down from last year.  Olivarry remains steady at 5%.  Dinahsiren and Lauriver weren’t top-level categories last year, but from what I can see Lauriver is down slightly and Dinahsiren is down substantially.  Non-Arrow fics make up 20% of all fics tagged Arrow, compared to 13% last year.  I have started breaking this down into two categories: Non-Arrow for fics that focus on other shows but include Arrow characters in a supporting role, and Completely Non-Arrow, where no Arrow characters are tagged and there’s no reference to Arrow in the summary.  (Completely Non-Arrow fics are filtered out and not included in my weekly/monthly posts, because they don’t deserve to be promoted to the Arrow fandom when they have nothing to do with the show.)

More statistics under the cut!

Comparing 2021 to 2020, it appears that there were declines across all Arrow ships:  the number of Olicity fics dropped by 58%, Olivarry decreased 43%, and Other Arrow Ships (temporarily adding back Lauriver and Dinahsiren) decreased by 47%.

Other Arrow Ships: This category includes all fics in English not focused on one of the ships I break out separately but that do focus on what I count as an Arrow character, defined as having a major/recurring role on our show, even if they are no longer on it because of character death or shifting to a different Arrowverse show.  So Sara counts, but Barry Allen does not, for example.  And although the category is called “Other Arrow Ships” this is also the category where I place gen fic.  Fics in this group focus on a wide range of characters, although many of the most common relationships here are alternate pairings for Oliver and/or Sara.

By Format:  I also code fics into one of four format categories:  one-shot, multichapter fic, one shot collection, and single-universe one shot collection (fics like Pieces of Always, where the story doesn’t necessarily flow from one chapter to the next, but all chapters are in the same universe). 

For fics tagged Arrow in 2021, 51% were multichapters (872), 43% were one-shots (734), 5% were one-shot collections (86), and 2% were single-universe collections (33). 

It appears that production of multichapter fics decreased less than one shots, but I think that makes sense:  some one-shots are reactions to an episode or speculation for the future, and there was no new episodes this year for authors to react to.

Looking at format by ship category, foreign language and non-Arrow fics were most likely to be multichaptered, and Dinahsiren fics were least likely to be multichaptered in 2021.

As always, grad school training demands I must offer some caveats.

I hand code category and format myself; in an academic each fic would be coded by multiple coders working independently who would discuss and resolve discrepancies.  I code based on the summary and tags alone, so fics with minimal information may be categorized inaccurately.  Also, these statistics are for unlocked fics on AO3 only.  It’s possible that locked fics and fics published on other platforms would show different patterns.  It’s also possible that I have missed fics, particularly because I moved from Access to Postgres SQL this year and have had some growing pains because of it.

As always, I hope you found this interesting and inspiring to go out and create in 2022!