text:
http://tvtropes.org/pmwiki/pmwiki.php/Characters/ArrowverseCentralCityCitizens
Characters / Arrowverse: Central City Citizens
Create New - Create New - Analysis FanficRecs FanWorks Fridge Haiku Headscratchers ImageLinks Laconic PlayingWith Quotes Recap ReferencedBy Synopsis Timeline Trivia WMG YMMV
Arrowverse Character Index
Star City: Team Arrow (Oliver Queen / Dinah Laurel Lance) | Team Arrow Family Members | Citizens | Criminal Groups (Malcolm Merlyn / Slade Wilson / Prometheus) | Independent Criminals
Central City: West-Allen Family (Barry Allen) | Team Flash (Caitlin Snow & (Killer) Frost) | Citizens | Criminal Groups (Rogues) | Independent Criminals
National City: Citizens (Kara Zor-El / James Olsen) | Luthor Family & Associates | Criminals
Freeland: Pierce Family | Citizens | Criminals
Gotham City: Bat-Family | Citizens | Criminals
Organizations: U.S. Government | U.S. Military | A.R.G.U.S. | The D.E.O. | Justice Society of America | The League of Assassins | H.I.V.E. | Savage and His Followers | Criminal Groups
Time Travel: The Legends (Sara Lance / Ray Palmer / Leonard Snart / Mick Rory / John Constantine) | Time Masters & Time Bureau | The Legion | Time Criminals (Eobard Thawne / Damien Darhk) | The Past | The Future
Miscellaneous: Other Locales | Metahumans (Firestorm / The Hawks / Grodd) | Aliens | Mystics | Other Entities
The Multiverse: Other Earths | Earth-2 (Hunter Zolomon) | Earth-38 | Earth-90 | Earth-X
BEWARE OF SPOILERS!
open/close all folders
Stein Family
Clarissa Stein
Played By: Isabella Hofmann, Chanelle Stevenson (young, 1975), Emily Tennant (young, 1987)
Appearances: The Flash | Legends of Tomorrow | Crisis on Earth-X note (Supergirl | Legends of Tomorrow)
Prof. Martin Stein's wife.
Adaptational Nice Guy: Her comic counterpart is not a devoted wife to Prof. Stein, to the point that she divorced him just because she couldn't stand the fact that he is Married to the Job.
Adaptation Dye-Job: Her New Earth counterpart has raven hair. Here, she's blond. The features of her comic counterpart is given to her daughter, Lily.
Alliterative Name: She's known as Clarissa Clemens prior to her marriage.
Alphabetical Theme Naming: She and Caitlin Snow are the Love Interests of the two people that originally composed Firestorm.
Celebrity Paradox: The Law & Order franchise is acknowledged to exist in the Arrowverse. Her actress was a main character on Homicide: Life on the Street which takes place on the same universe.
Cool Old Lady: Very cooperative of Team Flash when tracking down Ronnie when he was still unwillingly fused with her husband.
Happily Married: Despite her woes that her husband is Married to the Job, they are more than vocal on how they love each other. Thanks to Martin convincing his younger self to be a better husband to Clarissa, a new timeline where the Steins' relationship was strong enough to have a daughter, Lily, together was created.
Housewife: Implied to be this.
Meet Cute: Legends of Tomorrow reveals that she was tagging along with her uncle when she first met Prof. Stein, who was her uncle's student at the time. In fact, their meeting was one of that episode's plot points.
Morality Chain: For Stein when he was still unwillingly fused with Ronnie, much like how Caitlin was for the latter during the ordeal.
Secret Keeper: One of the few people outside of his team who knows that Barry is The Flash.
Widow Woman: After Professor Stein's death in the fourth Crossover.
Lily Stein
Played By: Christina Brucato, Winter Lily White (child)
Appearances: Legends of Tomorrow | Invasion!note (The Flash | Legends of Tomorrow) | Crisis on Earth-X note (Supergirl | Legends of Tomorrow)
The daughter of Prof. Martin Stein and his wife Clarissa, born due to the former's meddling with time.
Basement-Dweller: Likely, as she's still living with her parents even after being a mother.
Brainy Brunette: She's Prof. Stein's daughter, after all. She's an expert on nanotechnology.
Canon Foreigner: Prof. Stein never had any child in the comics. Counts as In-Universe too, as she never existed in the previous timeline.
Celebrity Paradox: The Law & Order franchise is acknowledged to exist in the Arrowverse. Her actress is a Recurring Character on Chicago Med note as the sister of the character played by Colin Donnell (Tommy Merlyn), no less which takes place on the same universe. She has also guest starred on the the parent show, SVU, and Criminal Intent.
Child Prodigy: Unsurprisingly, given who her father is, Lily was one of these when it came to science. She even wanted to sing the periodic table instead of the alphabet in kindergarten.
Daddy's Girl: She's very close to her father, at least from her perspective.
Deadpan Snarker: Seems to have inherited her father's dry wit.
Martin: Sorry we're late.
Lily: Don't you have a time machine?
Deconstructed Character Archetype: Unlike with Julian Albert, the Remember the New Guy? trope associated with her is treated seriously.
Go Mad from the Revelation: Subverted. She is initially pissed after finding out that she's a Time Aberration, but not necessarily because she is one. Rather, she is upset to learn that her father originally never wanted any children. However, after he assures her that he loves her, Lily seemingly calms down.
Paradox Person: She is a Time Aberration created by her father when he tells his younger self to spend more time with his wife, which she appreciates by taking him (well, his younger self) to "Pound Town", as Jax puts it.
Raven Hair, Ivory Skin: She has pale skin and has dark brown hair.
Remember the New Guy?: Deconstructed. Due to being a Time Aberration created by her father, he can't remember her. And once he finally learns to love her, he is faced with a dilemma of having to erase her from his life.
Shoot the Dog: Prof. Stein is aware of the fact that he may have to Ret-Gone her eventually.
The Smart Girl: She has PhD on nanotechnology.
Tomato in the Mirror: She finally learns the circumstances regarding her existence thanks to Mick being unable to keep his mouth shut.
Walking Spoiler: Her existence is crucial to Prof. Stein's Story Arc for Legends Season 2.
What Measure Is a Non-Human?: Prof. Stein at first thinks that she's nothing more but a Time Aberration until Caitlin calls him out on it.
Played By: N/A
Appearances: Legends of Tomorrow | Crisis on Earth-X
Lily's son and the grandson of Prof. Martin Stein and Clarissa.
Birth/Death Juxtaposition: Born shortly before his grandfather's death.
Canon Foreigner: Like his mother, he doesn't exist in the comics.
Dead Guy Junior: Named after his grandfather's late and original Firestorm partner, Ronnie Raymond.
Heroic Bastard: Technically, since he's born before his parents are married.
No Name Given: Since his father's surname is never given, he's addressed via First-Name Basis.
The One Guy: He's the only male member of his family after his grandfather's death and his father being The Ghost.
Played By: Anna Hopkins
Appearances: Arrow | Flash vs. Arrow note (The Flash) | Heroes Join Forcesnote (The Flash) | Arrow)
A young woman impregnated by Oliver before his shipwreck and disappearance. Not wanting her to "get in the way" of her son's future, Moira bribes her to fake a miscarriage and disappear from Oliver's life.
Adaptational Name Change: In the comics the mother of Oliver's child is named Sandra Hawke, but here she is called Samantha Clayton.
Aloof Dark-Haired Girl: Towards Oliver, at least. While she's civil, Samantha makes it clear that she doesn't want him in her and William's lives.
Amicable Exes: She is very civil with Oliver despite what happened as shown when she met him again during the inaugural Flash Crossover episode.
Chekhov's Gunman: Word of God confirmed that they were setting her and her child up for a future season storyline, which came into play in Season 4.
Decomposite Character: Legends of Tomorrow reveals that Connor Hawke's (William's counterpart in the comics, with them also being a product of this trope) mother is Lyla Michaels-Diggle.
Died in Your Arms Tonight: She doesn't survive the explosions on Lian Yu and dies in Oliver's arms, her last words making him promise to take care of their son.
The Exile: Though less dramatic than usual examples as Moira gave her huge chunks of money to do go away that she never touched. The mere offer was enough to make her leave quietly.
Good Girls Avoid Abortion: When Moira sat down with her, one of the first things she made clear was that she's keeping the baby.
I Gave My Word: She still honors her agreement with Moira a year after the latter's death. Subverted when she later revealed that she continued to keep quiet because she didn't want her son to become involved in Oliver's world.
Killed Off for Real: She doesn't make it out alive on Lian Yu.
Law of Inverse Fertility: She only slept with Oliver once, but she still got pregnant.
Nice Girl: Is not bitter over the Queens despite what happened and even offered Oliver her condolences on Moira's death.
No Name Given: Her name was never mentioned in any of her appearances until Season 4, when it is revealed to be Samantha Clayton.
Race Lift: Sandra Hawke, her counterpart in the comics, is part Korean-American, part African-American. She's Caucasian in the show.
Red Herring: She's heavily implied to be Sandra Hawke, the mother of Oliver's son, Connor, which in the comics will eventually be the second Green Arrow. However Legends of Yesterday reveals that not to be the case, and per Legends of Tomorrow, the Arrowverse version of Connor Hawke is not Oliver's son, but Diggle's.
Secret Keeper: Oliver reveals to her that he's the Green Arrow.
Screw the Money, I Have Rules!: She never cashed the check Moira gave her, and the mere fact that she offered it was reason enough to sever all ties with the Queens.
You Can't Go Home Again: It's implied that there's more to Moira paying her to leave Starling to go to Central. She eventually clarifies that the main reason she stayed away was her desire to keep her son away from the Queens and their toxic influence. After rescuing William from Darhk, Oliver has them move to another city so they can be safe from H.I.V.E.'s clutches.
William Clayton
see the Arrowverse: Team Arrow Family Members page
Frank and Irene Clayton
Played By: Jake T. Roberts & Beverley Breuer
Appearances: Arrow
The late Samantha's parents and William's maternal grandparents.
Adult Fear: Their daughter was killed due to her connection with a vigilante, so they opt to take custody of their grandson in order for him to not suffer the same fate.
Outliving One's Offspring: They outlived Samantha.
Promotion to Parent: They gladly want to take custody of William since Oliver is a Doom Magnet due to his vigilantism.
Raised by Grandparents: What they want to happen since their grandson's father is a known vigilante.
Shoot the Dog: They deliberately sabotaged William's communication with Oliver and Felicity thinking it's for his own good.
Dante Ramon
Played By: Nicholas Gonzalez
Appearances: The Flash
Cisco's older brother.
see Arrowverse: Earth-2 page to see his Earth-2 counterpart
Action Survivor: He's attempted to take out Heat Wave and survived.
Adaptational Jerkass: His comic counterpart is apparently very close to Cisco. Here, they're not. Of course this changes a bit once Heel Realization kicks in.
Age Lift: In the comics, he and Cisco are around the same age. Here, he's clearly older and their actors' ages are 13 years apart.
Aloof Big Brother: He's not really that much of a great brother to Cisco. At first.
Always Someone Better: Parental Favoritism is in his favor, much to Cisco's dismay.
Bitch in Sheep's Clothing: Downplayed. Looks like a decent man until you hear him talk to his brother pre-Heel Realization, but is never a real villain.
Bus Crash: Barry's time travel indirectly caused Dante to get killed in an accident that didn't happen in the original timeline.
Composite Character: He has elements of Armando Ramon, his and Cisco's eldest brother in the comics.
Dropped a Bridge on Him: He dies in a drunk driving accident in the timeline Barry caused.
Fingore: Captain Cold freezes his fingers to give Cisco a Sadistic Choice between his brother suffering frostbite (and losing for good his job as a pianist) or telling him The Flash's Secret Identity.
Heel Realization: Finally realizes how shitty of a brother he was to Cisco when they were kidnapped by the Rogues.
Heroic Sacrifice: Attempted to take on Heat Wave to give Cisco, the brother he mocked most if not all his life, a time to escape after his Heel Realization. Thankfully, he didn't die.
Inferiority Superiority Complex: Acts smug around Cisco but he reveals that he's been jealous of him practically most of their lives.
Kick the Dog: Pretty much his treatment of Cisco pre-Heel Realization.
Killed Offscreen: He dies in-between Seasons 2 and 3, without the audience seeing it.
Manipulative Bastard: Because the Sibling Triangle wasn't in his favor, he lied to the girl he and Cisco liked by telling the latter wanted to be a priest.
Redemption Earns Life: He was actually attempting the inverse trope when doing his Heroic Sacrifice. It wasn't fatal, but the deed obviously repaired his very strained relationship with his brother.
Relative Button: For Cisco, especially after Barry screws up the timeline, and causes his death in a drunk driving accident.
Secret Keeper: Given that Captain Cold Fingored him to give Cisco a Sadistic Choice to tell him The Flash's Secret Identity, he may well be this. Unless of course Cisco whispered it to Cold or told him someplace else so he wouldn't hear it.
Sibling Triangle: He and Cisco apparently liked the same girl in High School. The woman favored Cisco so Dante lied to her by saying Cisco wanted to be a priest.
Two First Names: Per the DC Comics norm.
Played By: Jeremy Schuetze
Appearances: The Flash | Crisis on Earth-X note (Supergirl
Captain David Singh's fiancé, later husband.
The Bus Came Back: Returns in Crisis on Earth-X after last appearing near the end of The Flash Season 1.
Decomposite Character: In the New 52 comics Singh is in a relationship with Hartley Rathaway; since they aren't connected in the series (and Hartley was a criminal at the moment), Rob was introduced as Singh's Love Interest here.
Diet Episode: Not an episode exactly, but Rob appears to be fairly health conscious and has roped Captain Singh into it as well. This hasn't stopped Singh from sneaking less healthy lunches at work.
Gay Aesop: A very subtle one. Rob tries to visit Captain Singh in his hospital room only to be briefly denied as only family are allowed in at the time. Joe insists that Rob, being Singh's fiancé, counts as family and Rob is allowed in without a fuss. This mirrors real-life instances in which same-sex partners are denied visitation rights in hospitals.
Happily Married: With Cap. Singh in the penultimate episode of Season 1.
Non-Action Guy: Apparently.
Only One Name: Hasn't been given a last name.
Satellite Love Interest: Only appeared and mentioned in scenes related to Captain Singh.
Straight Gay: Like his fiancee, he doesn't appear camp.
Unbroken Vigil: Is introduced waiting outside Singh's hospital room after he's injured by the Weather Wizard.
What Happened to the Mouse?: Disappears after Season 1, until he attends Barry's thwarted marriage.
Kendra Saunders
see Arrowverse: The Hawks page
Jefferson "Jax" Jackson
see Arrowverse: Firestorm page
Sharon Finkel
Dr. Sharon Finkel
Played By: Donna Pescow
A psychologist in Central City visited by Team Flash members.
Recurring Extra: She makes several appearances in Season Four when Team Flash keep consulting her for her expert therapy and psychoanalytical skills.
The Shrink: She is the psychologist of Central City and the one Team Flash always consults.
Dave / Big Sir
David P. "Dave" Ratchet / Big Sir
Played By: Bill Goldberg
An inmate at Iron Heights Prison, framed for a murder he did not commit. Barry quickly befriends him.
Abled in the Adaptation: Big Sir in the comics had a malformed brain gland that caused him to grow to incredible proportions, but left him mentally retarded.
Adaptational Heroism: An obscure villain in the comics.
Adaptation Name Change: His first name in the comics was Dufus.
Adaptational Species Change: Metahuman in the comics, normal human here.
Bald of Awesome: Seems like a Bald of Evil at first, but he quickly proves himself to be a good man.
The Cynic: After 15 years in prison, he became quite disillusioned. Barry helps him snap out of it a little.
Frame-Up: On the receiving end by Sylbert Rundine, who was fine with him being incarcerated for a murder he committed.
Gentle Giant: Despite his imposing appearance, he is actually a very kind man.
Intergenerational Friendship: With Barry.
I Owe You My Life: After Henry Allen saved his life, he became eternally grateful and extends this courtesy to his son Barry.
Jerk with a Heart of Gold: Even though he is a bit grumpy and cynical at first, Big Sir is a very good person.
Mistaken for Murderer: The reason he's imprisoned, as detailed below.
No Good Deed Goes Unpunished:
Tried saving the security guards life who got shot by Sylbert Rundine. It ended up with him being blamed for the murder, as the two had a similar appearance during that time.
After standing up to a bunch of inmates who tried bullying Barry, they later ganged up on him. Luckily, Barry returned the favor and saved him.
Earl Cox
Played By: Paul McGillion
A former friend of Ralph Dibny.
Old Friend: He was a friend of Ralph.
Shadow Archetype: His demeanor makes one think him on Ralph before joining Team Flash.
Debbie Dibny
Played By: Amy Pietz
Ralph's mother, with whom he has a difficult relationship.
Cartwright Curse: She has broken up with all the men she has dated so far. She passed them as dead to Ralph to avoid saddening him.
Parents as People: To avoid saddening Ralph, she lied to him by saying that her husband and her boyfriends died.
Played By: Lisa Marie DiGiacinto, Pascal Lamothe-Kipnes (young)
Appearances: Legends of Tomorrow
Mick's old high school flame, with whom he unknowingly conceived a daughter in 2004.
Death Is Cheap: Get's killed by Kathy Meyers, but is quickly resurrected after the Legends alter the timeline.
Everyone Went to School Together: She and Mick went to school with Freddy Meyers.
In the Back: How Ali dies before the timeline is altered, courtesy of Kathy Meyers.
The One That Got Away: Ali was Mick's date for the prom but he skipped prom and stood her up. Fifteen years later he still clearly regrets that decision. After being revived due to undoing the Encore's existence, she forgives him and they hook up at the end of the episode, which ends up with her becoming pregnant with his child.
Played By: Mina Sundwall, Emmerson Sadler (ages 5–7), Scarlett Jando (ages 8–10)
Mick's teenage daughter, who initially despises him for being absent her entire life.
Brutal Honesty: She is very blunt, just like her old man.
Evil Parents Want Good Kids: What her father wants for her.
Like Parent, Like Child: Despite her resenting him, several people point out how much alike she and Mick actually are.
Plot-Relevant Age-Up: She was conceived in 2004. When Mick meets her in 2020, she's a teenager.
The Resenter: Growing up without her father left her a tad bit bitter and it takes a while before Mick can get through to her.
Troll: She first reaches out to her father by trolling him about the quality of his books.
Mayor Bellows
Anthony Bellows
Played By: Vito D'Ambrosio
The former mayor of Central City, and has been caught up in at least two attacks against the city.
see Arrowverse: Earth-90 page for his Earth-90 counterpart
Adaptational Villainy: In his Season 4 appearance, he becomes the outright main antagonist of the episode, sending out hitmen to kill Ralph Dibny (who blackmailed him with incriminating photos) and Barry and Joe (who knew of the blackmailing).
Bitch in Sheep's Clothing: Convinces the press that he's a good guy and even tries to stuff Joe up with compliments and jokes. However, when he's confronted by Joe and Barry about Dibny's blackmail, he gives them all they need to know and then orders them killed while pretending to give in to Dibny's demands. But even then, he had a gun just in case he needed to kill Dibny then and there.
Butt-Monkey: His two appearances were at events that were attacked by The Tricksters and Atom-Smasher, respectively.
Canon Foreigner: Never appeared in the comics, only the 1990 and 2014 series.
Demoted to Extra: Was a Recurring Character in the original Flash TV series, but has made few appearances in the 2014 series.
Evil Doppelgänger: He's revealed to be this to the Anthony Bellows of Earth-90, being thoroughly corrupt and not hesitating to shoot Ralph Dibny in the face.
Kicked Upstairs: Was a Recurring Character with a low rank in the original 1990 TV series, to Mayor who rarely appears in this one.
Mayor Pain: At first he seems a good man, but in season 4 he becomes willing to murder people just to cover-up his adultery.
Non-Action Guy: Is not combat proficient. However, he's efficient with a gun, given that he delivered a headshot to Ralph Dibny; the only thing was, Ralph had just received meta powers.
Rank Up: From officer to Mayor.
Remake Cameo: His actor also played the character in the 1990 TV series.
Mayor Van Buren
Played By: Kendall Cross
The new mayor of Central City after Anthony Bellows's incarceration.
No Name Given: Her first name hasn't been given away yet.
Tempting Fate: During Honey, I Shrunk Team Flash she praised a new, supposedly metahuman-proof building courtesy of Kord Industries, only for Dwarfstar to shrink it down right in front of everyone's eyes.
Van Buren: Believe me, no one is breaking into this building anytime soon.
(the building shrinks)
Van Buren: I hate this city.
Cap./COP. David Singh
Chief of Police David Singh
Played By: Patrick Sabongui
Appearances: The Flash | Arrow | Crisis on Earth-X note (Supergirl)
The Captain of the Central City police precinct and Joe, Eddie and Barry's superior. At the end of Season 5, he steps down from his post to take up the position of Chief of Police, offered to him by the mayor, leaving his old Job to Joe.
A Father to His Men: Despite all of his bluster at the end of the day its revealed that Singh genuinely cares for his men, he's still torn up over Detective Chyre's death in the pilot, he willingly jumps in the way of a lightning bolt to save Joe's life and, according to his fiancé genuinely praises Barry's skills.
All-Loving Hero: He is committed to protect metahumans, which is evident when calling out the spy who leaked Cicada the information on them.
Badass Beard: Grows an impressive one in season 2. His first time with a beard is commented by Cisco.
Badass in Distress: He was kidnapped and cloned by Eva McCulloch. The Singh shown in "The Exorcism of Nash Wells" and the two next episodes is the clone.
The Captain: Of the CCPD.
Career-Ending Injury: After Taking the Bullet for Joe, his doctor claims that he may never go back to active service again. Thankfully negated by Barry's Time Travel.
Da Chief: Repeatedly annoyed by Barry's habitual lateness to crime scenes and Joe's attempts to cover for him.
Demoted to Extra: After Season One, his appearances become very sparse as the show focuses less on the CCPD and more on S.T.A.R. Labs.
Good Is Not Nice: He's on the side of the good guys, but he's not exactly the nicest of supervisors. At least on Season 1.
Heroic Sacrifice: He jumps in the way of an incoming lightning bolt send by Mark Mardon to kill Joe and saves the latter's life. While the bolt doesn't kill him it did do significant internal damage to his body, giving him possible brain damage and possibly crippling him as well - before Barry's time-traveling at the end of the episode prevented the event, that is.
Hunk: His broad shoulders and toned body are easy to note in his white shirt.
Jerk with a Heart of Gold: Despite acting like a bit of a Jerkass throughout the majority of his initial appearances, "Out of Time" reveals that when it gets down to it he genuinely does care about his men. When Mark Mardon appears, and threatens to murder Joe for the death of his brother, Singh tells Joe in no uncertain terms that he will not allow him to die like his partner did. And later when Mardon attacks the police station he jumps in the way of a lightning bolt aimed for Joe. His fiancée even mentions that he's all bark. Also, unlike a lot of typical 'tough police chief' type characters in a superhero work, Singh is incredibly supportive of the Flash, is perfectly willing to ask for his help.
Kicked Upstairs: Promoted to Chief of Police in The Flash Season 5 finale, leaving his previous position to Joe.
Last-Name Basis: He calls everyone by their last name, except Joe. He himself is often called Singh.
Like a Son to Me: Singh sees Barry as something of a son. He initially admired Barry's talent and willingness to help the victims and often speaks fondly of him to Rob. That's why he is happy to be allowed to reinstate him.
Passing the Torch: He steps down as Captain to become Chief of Police, leaving his old post to Joe.
Perma-Stubble: When he doesn't have a beard proper, his beard shadow is visible.
Put on a Bus: After being a prominent Recurring Character for 5 seasons, he finally leaves when he becomes chief of police and entrusts the city to Joe and Barry.
Rank Up: Promoted to Chief of Police in The Flash Season 5 finale.
Reasonable Authority Figure: Although he's exasperated by Barry's perpetual tardiness, he's also aware that he's very good at his job, and when he's in a good mood he openly praises him.
Secret Secret-Keeper: He reveals he knew all along about Barry's identity as The Flash.
So Proud of You: Singh was impressed with Joe and Cecile's work when they saved the metahumans from Cicada II. That's why he appoints Joe as the new captain and states that if things get too complicated, he could always use Barry's help.
Straight Gay: Revealed to be one in Episode 8. He references his boyfriend in passing. In "Out of Time" it's revealed that he is now Singh's fiancé and we actually get to meet him, and by the end of the season 1, they're married.
Took a Level in Kindness: He mellows down a bit once he becomes engaged.
Twofer Token Minority: He's Hindu and gay.
Cap. Julio Mendez
Captain Julio Mendez
Played By: Alex Désert
Da Chief of CCPD in the Flashpoint timeline.
Adaptational Badass: In the 90s Flash series, he is a forensic scientist like Barry. Here, he is Da Chief of CCPD.
Adaptational Job Change: He was Barry's fellow forensic scientist in the nineties series. Here, he is seen first as Da Chief in Flashpoint and later as a musician.
Badass Beard: Like Singh, he has a beard and is an active cop. He is nor badass nor bearded (only has a soul patch) in the post-Flashpoint timeline.
Benevolent Boss: Listens to his men.
Beware the Nice Ones: Despite being a Benevolent Boss, he is not afraid to lash out on you if you're not doing your job (properly or at all).
Da Chief: Of CCPD in the Flashpoint timeline.
Dead Alternate Counterpart: For the Julio Mendez of Earth-90.
Demoted to Extra: He is one of the main characters of the 90s Flash series (kinda like the "equivalent" of Cisco). Here, he appears in an Alternate Timeline created by Barry replacing the regular chief and later is only used to show how deadly is Yorkin's power.
Kicked Upstairs: From an ordinary forensic scientist but regular main cast member in the 90s Flash series to Da Chief of CCPD in an Alternate Timeline.
Reasonable Authority Figure: Singh already is one, but Flashpoint Julio is more approachable.
Remake Cameo: Desert first played Julio Mendez in the 1990s Flash show, where he was Barry Allen's Token Black Friend.
We Hardly Knew Ye: There was few information on him in his two appearances since Yorkin kills him off in the second.
see Arrowverse: Barry Allen page
Det./Cap. Joe West
see Arrowverse: West/Allen Family page
Det. Eddie Thawne
Detective Edward "Eddie" Thawne
"He was wrong. Turns out I'm a hero after all. [...] That's all I've ever wanted to be, Iris. Your hero."
Played By: Rick Cosnett
Appearances: The Flash | Flash vs. Arrow!note (The Flash)
A police officer in the Central City PD, recently transferred from Keystone City, who becomes Joe's partner and Iris's boyfriend during The Flash Season 1.
The Ace: He's great at his job to the point of having started to keep scores of his arrests.
Adaptational Heroism: In most stories, the present-day "Thawne", Malcolm Thawne, is a straight-up supervillain who hates Barry with a passion so strong that he starts the Thawne-Flash family feud, which lasts until the 30th century.
Adaptational Name Change: It seems that way, as he seems to be the show's equivalent of Cobalt Blue/Malcolm Thawne, being the modern day Thawne and the ancestor of Eobard Thawne/Reverse-Flash. If so, this also makes him a case of Adaptational Heroism, as Cobalt Blue is an evil speedster, not a Badass Normal Nice Guy.
Adaptational Wimp: Played with. In most stories, the present day Thawne becomes the supervillain Cobalt Blue, who has the power to negate The Flash's Super Speed. Eddie never became a supervillain or gained any powers, but he was able to kill the one foe Barry couldn't even defeat on his own.
All for Nothing: His sacrifice to stop Eobard Thawne. Ultimately, while it made the Thawne they met in Season One disappear, he has time remnants and found other ways to still exist and cause Barry trouble. Savitar even acknowledges how that example of cause and effect didn't work for him.
Always Someone Better:
To Barry (whenever he's in civvies anyway). Most obvious when he catches a bag-snatcher that had, just a few moments ago, knocked Barry flat on his rear. Then he starts dating Iris.
Extends to all of the S.T.A.R. Labs crew by the time the season finale comes around, due in large part to Eobard messing with his head. He admits to feeling as if he has nothing to contribute to the group, considering most of them are geniuses or superheroes of sort. He gets over this in the midst of his sacrifice, however.
And Starring: Is credited with "Special Guest Star" citation for his appearances starting in Season Two.
Badass in a Nice Suit: He mostly fights while wearing suits.
Badass in Distress: Played with. After throwing away the masquerade, Eobard kidnaps him and keeps him locked away — but he won't kill him, because Eddie is his ancestor.
Badass Normal: Like Joe, he has no superpowers or special abilities, yet he willingly and regularly goes up against villains who do, and has no trouble against more standard criminals.
Big Damn Heroes: He leaps into action to save the Flash in a crucial moment during his fight against Captain Cold and Heat Wave.
Bullying a Dragon: He tries to use a task force to capture the Flash, a metahuman who can move faster than the eye can see and who already beat him senseless under Bivolo's influence.
Can't Kill You, Still Need You: The only reason he was spared by the Reverse-Flash is because he is Thawne's distant relative.
Celebrity Paradox: Played With. Quantico is mentioned quite a few times on Supergirl (2015), a show in which Eddie's actor is a prominent cast member, but it is set in an Alternate Universe. However, Barry (and Cisco) has traveled to that universe a number of times, as does Kara and her friends to Earth-1. The merging of two universes post-Crisis, along with Black Lightning's, makes this a non-issue.
Character Development: Of all the main characters aside from Barry, Eddie's has been the most drastic. Over the first season alone, he's developed quite a friendship with the S.T.A.R. Labs crew, gone from wanting to lock up the Flash to becoming one of his strongest allies, revealed some things about his childhood to Barry, decided that he wants to marry Iris, and earlier on, he Took a Level in Kindness (see below).
Composite Character: A combination of Malcolm Thawne and Hunter Zolomon (though Hunter himself shows up later, he bears little resemblance to his comic counterpart). Like Malcolm, he's a blond-haired blue-eyed man with an unhappy childhood, and the current Thawne. However, he takes his Nice Guy personality and status as the Flash's Friend on the Force from pre-villainy Hunter.
Cop Boyfriend: To Iris.
Dead Sidekick: He's Joe's second fallen partner.
Death by Adaptation: In most stories, the present day Thawne becomes the Supervillain "Cobalt Blue". Eddie was never able to don the identity after his Heroic Suicide in the Season 1 finale.
Death of the Hypotenuse: Being Iris' boyfriend, his death allows her to be with Barry.
Distressed Dude: Eobard kidnaps him and holds him for the majority of the last quarter of Season 1.
Entertainingly Wrong: He assumes that the Flash was the one killed the guards at Mercury Labs, based on a survivor's description of him. He had no way of knowing at the time that it had been done by another speedster, the Reverse Flash.
Expy: Of Tommy Merlyn. Friend to the hero? Check. Related to the main bad guy of Season 1? Check. Red Herring to said bad guy? Check. Romantic Rival to the hero? Check. Super-Nice guy? Check. Always getting the short end of the stick? Check. Fans of the show constantly predicting he will become a bad guy? Check. Breaks up with the hero's love interest, because he believes that the hero getting with said love interest is inevitable? Check. Heroic Sacrifice at the end of Season 1? Check. Was wearing a White Shirt of Death and black pants? Check.
Et Tu, Brute?: Punches Barry for flirting with Iris, when Eddie thought he and Barry were supposed to be friends.
Face Death with Dignity: He gladly performs a Heroic Suicide just so a monster like Eobard Thawne won't ever exist.
Fair Cop: We will be mentioning his nickname "Detective Pretty Boy" several times.
First Love: Much like Barry Allen, he can function as both this and Second Love to Iris West. While Iris started a relationship with Eddie first, Iris herself outright confirms that she was in love with Barry long before she had even met Eddie.
Formerly Fat: He used to be a short, fat kid, who was teased a lot.
Friend on the Force: Shares this role to the Flash with Joe. Becomes even more of this after Barry reveals his identity to him.
Friendless Background: Though not directly stated, Eddie lets on that he doesn't have many friends, but values the one he does. When talking to Barry about the latter's friendship to Iris, Eddie wistfully says that he's learned from experience that friends are hard to find; and when he learns Barry hit on Iris, what he singles out as the worst part isn't that someone tried to steal his girlfriend — it's that he thought he and Barry were friends. And, although it took some scientific explanation from Caitlin, Eddie forgives Barry pretty quickly afterwards.
Future Loser: According to Eobard he's the biggest disappointment in their family and grows up accomplishing nothing. Fortunately, Eddie says Screw Destiny.
Good All Along: For all the Red Herrings regarding him eventually pulling a Face–Heel Turn or being Evil All Along, he did a very noble Heroic Sacrifice just to ensure that a monster like Eobard Thawne will be erased from existence.
Grandfather Paradox: His death prevents Eobard Thawne from existing. However, he never would've killed himself had Eobard not caused the chain events leading to it by killing Nora Allen and making Barry the Flash. This causes the aforementioned paradox, which the universe seemed to try to fix by creating a singularity to eat away at all of existence.
Green-Eyed Monster:
Admitted to Barry that he was a bit jealous of his relationship to Iris, but he gets over it and bonds with him over the Tony Woodward case. It does briefly pop up again when Barry gives Iris replicas of her mom's wedding rings.
He initially did not like the Flash at all, and considered him a threat on little or no evidence mainly because Iris liked him. However, he got better after the Flash helped the police against Reverse-Flash, and is a full-on Flash supporter by Revenge of the Rogues.
Hair of Gold, Heart of Gold: Blonde and is a decent human being. Unlike his distant descendant, Eobard.
Heroic Suicide: In the Season One finale, he shoots himself in the chest to stop the Reverse-Flash, who is his descendant from the future.
Hopeless Suitor: What prompts his breakup with Iris is the realization that he's this compared to Barry. The main reason why their relationship even got as far as it did was because Barry was out of the picture for the beginning of it, and Iris had yet to realize her feelings for her best friend. Eddie knew that Iris would eventually come to recognize those feelings, and so wanted to spare them further heartbreak by breaking up rather than making the life-altering, near-permanent decision to get engaged and eventually married, believing they would only come to regret it. Iris did not like this explanation at all, but (though they themselves didn't know it) Eddie was correct — an earlier episode, "Out of Time", showed that the very moment Iris realized she loved Barry, she didn't hesitate to choose him over Eddie.
I Want My Beloved to Be Happy: He broke up with Iris because he knew that the person she really loved was Barry, even she herself had yet to realize it note he was right, in a way — while Iris did love Eddie, there is proof, from both before and after Eddie's death, that she was in love with Barry long before she had even met Eddie, and loved him more than she did Eddie. While they get back together in the Season 1 finale, as you can tell, it simply wasn't meant to be.
In-Series Nickname: Detective Pretty Boy.
In the Blood: Completely averted. Unlike his monstrous descendant, Eddie is 100% heroic.
Keeping Secrets Sucks: Keeping Barry's secret from Iris hurts their relationship —- especially given that he disagrees with the others' (mainly Joe's) assertion that keeping her Locked Out of the Loop is the best way to protect her.
The Lost Lenore: Iris is still hung up from his death almost a year after that. Barry later helps her move on when he travels back in time by making a video from Eddie.
Mysterious Past: His past is described as a mystery and he harbors a dark secret according to Word of God.
He's mentioned a little bit to Barry in "The Flash is Born". He said he was a short, fat kid whose dad was a local politician who shut down the factory in his school district, meaning he got his ass kicked. A lot.
Mutual Envy: Barry was jealous of Eddie for being Iris' boyfriend, oblivious to the fact that Eddie was a bit jealous of him for having a longer relationship with her.
Mythology Gag: His name is a reference to the comics character Eobard Thawne, known to be Professor Zoom/Reverse-Flash in the comics. However, he proves to be a Red Herring for Harrison Wells, the true Eobard Thawne/Reverse-Flash. Wells, however, calls Eddie a "distant relative", which is later clarified to mean that Eddie is his direct ancestor and he needs Eddie to live long enough to produce a child so he can exist.
Nice Guy: After the first few episodes especially, he is seen to be very affable and friendly to Joe and Barry, always showing concern and empathy for Barry.
Not So Different: As he points out to Barry, they're much more similar than he thinks: both had rough childhoods, were tormented by bullies, frequently got their asses handed to them, and eventually grew up to help people in the CCPD.
Oh, Crap!: He has a silent one when the Reverse Flash kills his entire task force in a few seconds and stares right into his face.
Old Cop, Young Cop: His partner is old enough to be his father, to the point that he even dated his daughter much to the former's dismay. They do still care and respect each other despite that, though.
Only Friend: He may not had a lot of pals among CCPD colleagues, but the pilot had him taking all of Joe's shifts so he could watch over Barry. Subverted later on when he becomes sociable with Barry and when he befriends most of Team Flash.
Open Mouth, Insert Foot: He's this around Joe on matters about him being Iris's boyfriend.
Out of Focus: In the middle of the season, until he learns the Flash's identity.
Plot-Triggering Death: His death in the Season 1 finale of The Flash is indirectly responsible for the events of Season 2 of Legends of Tomorrow, as it, plus the events of "Flashpoint", produced a time remnant of Eobard Thawne; this forced him to seek help from what would become the Legion of Doom and search for the Spear of Destiny in order to (futilely) avoid grisly non-existence at the hands of the Black Flash.
Pop-Culture Isolation: An in-universe example. During a pub quiz, Eddie apparently didn't know the name of Han Solo's ship.
Pretty Boy: To the point of being nicknamed Detective Pretty Boy in-universe. Even Caitlin thinks he's hot.
Red Herring: Despite sharing a surname with comics character Eobard Thawne and having being suspiciously spared by the Reverse-Flash, he is not the Reverse-Flash; Wells is. However, it does amount to something: Eobard spared Eddie because Eddie's his ancestor and he needs him alive to preserve his own existence. Which he outright tells him in "The Trap". "Grodd Lives" strongly implies Eobard is trying to mold Eddie into a villain by playing on his fears; it doesn't work, however, as Eddie winds up sacrificing himself to destroy Eobard.
The Rival: An unintentional variety, as while he is the Pretty Boy Ace Detective he views Barry as a friend and colleague, and had no idea that Barry's love for Iris was more than Platonic until Eobard showed him the future. The producers were aware that they were creating this dynamic and so had to struggle to make him a likable character without making him an unbearable Mary Sue.
Romantic False Lead: In Season One, for Iris West. Make no mistake, Iris loved Eddie. She loved him so much that she spent over a year mourning his death. But when it came down to it, Iris had always loved Barry more, even when she didn't know she loved Barry at all. With there being proof that Barry and Iris will always be Happily Married if they end up together, being effectively soul mates, the biggest question of Eddie and Iris' relationship was if their love was enough. Unfortunately, Eddie's death ensured that no one would know the answer.
Screw Destiny: At first, he broke up with Iris after Eobard showed him the future newspaper, but then he decided it didn't matter and they got back together. Unfortunately, his death in the Season 1 finale means that it wasn't meant to be after all. Still applied when his heroic suicide would make him less of a "loser".
Secret Keeper:
Let in on the meta-human secret, though Joe still keeps Eddie in the dark in regards to Flash's secret identity.
He's also the only one on the police force who knows that Joe is investigating his future ancestor.
And then Barry willingly reveals his identity as the Flash to him in "Tricksters".
Senseless Sacrifice: He killed himself to stop Eobard Thawne, his eventual descendant. While this stopped his immediate threat, it ultimately proved ineffective at stopping him permanently, as Thawne manages to cheat being Ret Goned on several occasions and is still running around free.
Stop, or I Will Shoot!: "You're not faster than a bullet." (Said to a crook, not the Flash.)
Sympathetic Inspector Antagonist: Created a task force to catch Flash (who had violently assaulted him earlier) before becoming his loyal supporter. Justified, as he was unaware of the fact that the Flash had been "brainwashed" (for lack of a better word) at the time.
Taking You with Me: Given his Heroic Sacrifice to take advantage of the Grandfather Paradox.
There Are No Coincidences: Both Stein and himself find it strange that the timeline Eobard Thawne spawned by murdering Nora Allen and replacing Harrison Wells is one where Eddie becomes a member of Team Flash and has a vested interest in ensuring that his descendant Eobard does not succeed in his plans, and is present in the right place, at the right time to stop him. It's never outright stated, but it's heavily implied the Speed Force allowed Eobard run amok because it knew Eddie would eventually kill himself to stop him.
Took a Level in Kindness: In the first few episodes, while polite he was very arrogant (keeping count of his arrests, being overly proud of catching a mugger, etc.) However, that later phases out and he starts to become friendlier and nicer. Compare and contrast both times Barry compliments him for "saving the day" when the Flash was present — the first time, in "Fastest Man Alive", he brushes it off with faux humbleness, but gives credit to no one else; the second time, in "Revenge of the Rogues", he gratefully thanks the Flash for everything.
Too Much Information: Accidentally tells Joe that keeping a secret for him is hurting his sex life with Iris.
Eddie: (to Joe) [Iris and I] haven't had sex in two weeks... and you did not need to know that!
Unperson: Eddie is apparently this in Eobard Thawne's time, having been completely overshadowed by his descendants and having no notable accomplishments. Eddie's given a better chance by his Heroic Sacrifice, which at least ensures that he has a memorial plaque at the CCPD and that he'll be remembered as a hero.
Unrelated in the Adaptation: He has no relationship with Barry, whereas Malcolm Thawne was Barry's identical Evil Twin.
Unwitting Muggle Friend: He isn't aware of Barry's nature as a speedster until long after they meet and start hanging out together.
What the Hell, Hero?: Punches Barry for trying to steal his girlfriend. However, Eddie later apologizes when Caitlin explains that it was due to Barry's medical condition.
White Shirt of Death: Was wearing a white suit when he performed his Heroic Suicide.
Wild Card: During his talk with Stein, the latter explains that his abduction by Eobard was not planned at all when he went back to the past and killed Barry's mom since he saw him as a coincidence, being that he was a distant ancestor of his. He decides to take advantage of it by shooting himself to prevent Eobard from existing.
You Are Better Than You Think You Are: When Hannibal Bates sets Eddie up as a murderer Barry fears that the same thing that happened to Henry will happen to Eddie, thus he attempts to break him out of prison. Eddie however assures him he has full faith in Barry's ability to prove his innocence.
You Can't Fight Fate: This is why he breaks up with Iris in "Rogue Air," as Eobard Thawne shows him a newspaper from the future showing that Barry gets married to Iris. This makes him realize that Iris has feelings for Barry, whether she admits/realizes it or not, and even he knows that Barry has been in their relationship as well. However, he later decides to "screw the future" and get back with her — right before Barry decides to go back in time to save his mother, which would erase the timeline where he met Iris. Even when Barry changes his mind and comes back, he pulls a Heroic Suicide to stop Eobard from killing him.
Det. Fred Chyre
Detective Frederick Chyre
Played By: Al Sapiens
Joe's original partner in the pilot.
Adaptational Curves: Inverted. In the comics, he's huge and muscular, while this incarnation isn't particularly impressive.
Death by Adaptation: In the comics, he's a major member of Wally West's supporting cast. Here, he dies in the pilot, long before Wally is even introduced and minutes before Barry's Superhero Origin began.
Demoted to Extra: A far less prominent character than his comic counterpart.
Old Cop, Young Cop: The old cop to Joe's young cop, judging from their respective actors' agenote Al Sapiens was born on 1962 while Jesse L. Martin was born on 1969. Interestingly enough, Joe will play the Old Cop with his future partners.
We Hardly Knew Ye: Dies before Barry even becomes the Flash.
Ofc./Det. Patty Spivot
Officer/Detective Patricia "Patty" Spivot
Played by: Shantel VanSanten
Appearances: The Flash | Heroes Join Forcesnote (The Flash)
A CCPD police officer who is made detective and Joe's new partner in the CCPD Meta-human Taskforce.
see Arrowverse: Earth-2 page to see her Earth-2 counterpart
Action Girl: She captures the Earth-1 version of the Sand Demon (who is not a metahuman, but still a career criminal) with ease after he gets away from Joe.
Birds of a Feather: She and Barry are both dorky, brave science nerds. On a darker note, they both had a father killed by a metahuman and joined the CCPD because of it, and hide the pain behind a Stepford Smiler facade. Caitlin lampshades this.
Fair Cop: A CCPD detective played by the gorgeous Shantel VanSanten.
Fanservice Pack: Once she gets promoted, she starts Letting Her Hair Down, wearing shirts with plunging necklines, and once a Little Black Dress during her date with Barry.
Hair of Gold, Heart of Gold: She's blonde, sweet, and upbeat.
It's All My Fault: She blames herself for Weather Wizard killing her dad, because she ditched work forcing him to go to the bank just when the Mardon Brothers were robbing it.
It's Personal: For Mark Mardon, since he killed her dad.
Long Bus Trip: After leaving to become a forensic scientist and forget Barry, she has not returned. That her potential talents are already present in Barry, Iris and Joe doesn't help.
Old Cop, Young Cop: Her partner is old enough to be her father, to the point that she even dated his surrogate son.
OOC Is Serious Business: When she becomes cold and focused on Mardon, it provides quite the contrast to her usual cheerful, Nice Girl self.
Plucky Girl: Despite Joe repeatedly shutting her off to join the Metahuman task force, she continues to try until he lets her in.
Put on a Bus: With her father's killer put away for now and her relationship with Barry on the rocks, she leaves Central City to work on becoming a CSI.
Rank Up: Started as a beat cop at her debut episode, she's promoted to a detective towards the end of the same episode.
Revenge: Patty joined the CCPD so she could join its anti-metahuman task force to secure her chance to legally kill Mark Mardon, the man who shot her father.
Revenge Before Reason: When she does get her chance to kill Mardon he had already been neutralized by the Flash. Had she done so it would not have been in self-defense and she would've lost her job and gone to prison had Barry not talked it out of her.
Romantic False Lead: For Barry, as she can't take his closed off nature and leaves the city.
Second Episode Introduction: Was introduced in the second episode of Season 2.
Secret Keeper: She figures out Barry is the Flash after his interactions with S.T.A.R. Labs and confirms it by doing a false distress call and tricking Barry to come as the Flash, but without revealing his identity.
Spotting the Thread: She figures out that Barry is the Flash through her own analysis of past events.
Stepford Smiler: Her cheerful attitude conceals her remorse for supposedly instigating her father's death.
Statuesque Stunner: She stands 5'8" and very pretty, enough for Barry to get tongue tied whenever they speak.
You Killed My Father: Her father was killed by the Mardon brothers a few months before the accelerator explosion, and seeing them among the people it gifted with superpowers made her determined to help stop anyone like them.
Julian Albert / Dr. Alchemy
See Arrowverse: S.T.A.R. Labs page.
Det. Tom Patterson
Detective Tom Patterson
Played By: Greg Grunberg
A CCPD police officer introduced in Season 3.
Badass in a Nice Suit: As he is a detective, he's wearing ones similar to what Joe and Eddie usually wear.
Celebrity Paradox:
Lost was mentioned in the very first episode of Arrow. His actor plays a Recurring Character there.
The Mission: Impossible film series was mentioned a lot on The Flash (2014). His actor was on the third film.
Star Wars was the most mentioned franchise in the entire Arrowverse. His actor plays a Red Shirt in The Force Awakens (and presumably the rest of the Sequel Trilogy).
Star Trek was mentioned quite a few times too. His actor has played two different and unrelated characters on two of its recent films.
The third annual Crossover directly mentions J. J. Abrams, whom his actor is a Production Posse with (involving all the aforementioned works).
Fantastic Racism: He has a low opinion on Metahumans.
Remember the New Guy?: He and Barry seem to know each other really well, indicating that they're acquainted even before Flashpoint happened. He only starts appearing in The Flash Season 3.
Ungrateful Bastard: Badmouths Kid Flash after he rescued him. Joe did not take this well.
What Happened to the Mouse?: He just disappears after The Flash Season 3.
Det. Ralph Dibny / Elongated Man
Det. Dinah Drake / Tina Boland
see the Arrowverse: Team Arrow page
Det. Vincent Sobel
see the Arrowverse: Star City Criminal Groups page
DA Cecile Horton
see the Arrowverse: West/Allen Family page
DA Anton Slater
Anton Slater
Played By: Mark Valley
The new District Attorney of Central City after Cecile Horton stepped down to defend Barry Allen. He prosecutes Barry Allen during his trial.
Amoral Attorney: During all the judgement, he kept doing emotional manipulation and slandering Barry of being a serial killer. When Captain Singh does a favourable testimony of Barry, this prosecutor accuses him of intending to cover up Barry although Singh was seeking to be cooperative with the case.
Hero Antagonist: He's a good guy by all means, but Barry and Team Flash are in direct opposition to him when Barry is framed for murder.
Ironic Echo: His opening statement for Barry Allen's prosecution is Barry's very first line in the series: "I need you to believe in the impossible", before it gets twisted to paint Barry in a malicious light.
One-Shot Character: He disappears from the series after "The Trial of The Flash". The only prosecutor present is Cecile.
Central City Picture news
Iris West-Allen
Played By: Olivia Cheng, Malese Jow
Appearances: Arrow | The Flash
A sports journalist for Central City Picture News, formerly reporting for KSFZ Channel 8. First seen reporting at S.T.A.R. Labs the night the particle reactor was being turned on, she become acquainted with Barry Allen a year later when he and Caitlin were singing karaoke at a bar. Barry and Linda eventually started going out with each other. Their relationship doesn't last due to Barry's feelings for Iris. In Season Two, Linda learns of Barry's identity as the Flash.
She also has an Earth 2 version who is known as the metahuman Dr. Light.
see Arrowverse: Earth-90 page for more info on the Earth-90 character who bears her name and background
Adaptational Early Appearance: Usually, she is introduced during the Wally West era. Here, she debuts way ahead of him.
Adaptation Distillation: In the comics she's a love interest to Wally West, not Barry. Of course, she probably will be a love interest for Wally.
Age Lift: In the comics she's of a similar age to Iris's nephew Wally, while in the show she's the same age as Barry and Iris. Not to mention she received one on the show because the original Linda was clearly years older.
Aloof Dark-Haired Girl: On a bad day, she can be very blunt.
Amicable Exes: She and Barry get along just fine after their breakup.
Early-Bird Cameo: She first appears (played by a different actress) in "Three Ghosts" over at Arrow, reporting as the particle accelerator malfunctioned. This footage of her was reused for the pilot.
Evil Twin: Her Earth-2 counterpart is the supervillain Dr. Light.
Feminine Women Can Cook: Inverted, she can cook but is The Lad-ette.
Hero Killer: Surprisingly Played for Laughs when she has to impersonate her Earth-2 evil counterpart. She (unconvincingly) "kills" The Flash to lure Zoom out of hiding.
It's All My Fault: When her Evil Twin kills her editor, she is wracked with guilt and wants to help.
I Want My Beloved to Be Happy: Upon realizing Barry's feelings for Iris, she tells him to go for it without any kind of drama.
The Lad-ette: During their first date, she and Barry have a contest to see who can handle spicy foods the best. She wins. However, she does cook when she is nervous.
Locked Out of the Loop: She doesn't know Barry is the Flash, so it causes some friction when his duties with the Flash interfere with their time together. She learns in Season 2.
Long Bus Trip: Zoom is no longer a menace, but she has not returned to Central City.
Monster of the Week: Has to pretend to be one in Enter Zoom, complete with training montages with Team Flash.
Most Definitely Not a Villain: As Dr. Light. She most certainly is a follower of Zoom! Zoom will rise! Then checks to make sure she didn't accidentally kill Barry.
Promoted to Love Interest: Played with. She is a Flash Love Interest, but for Wally West not Barry Allen.
Put on a Bus: With her getting Zoom's attention in the plan to lure him out, she's sent to Coast City to hide out.
Romantic False Lead: Unsurprisingly, she was this for Barry.
Second Love: Subverted. Barry is mesmerized by her after spending so many years pining for Iris. However, it is revealed that Barry never really got over Iris.
Secret Keeper: Barry reveals his secret to her, to give her the confidence needed to pretend to be her counterpart.
Tomboy with a Girly Streak: Linda cooks a lot of food when she is nervous.
Tricked-Out Gloves: Cisco makes her gloves to mimic Dr. Light's powers. Though she doesn't get to keep them.
Mason Bridge
Played By: Roger Howarth
A Pulitzer Prize winning journalist at Central City Picture News who is mentoring Iris. He is suspicious of "Wells" and has been investigating him.
Back from the Dead: Thanks to Barry going back in time in the Season 2 finale, Mason was likely saved from being killed by Eobard Thawne. Later subverted when Barry decides to change things back to the way they were, mostly.
Cassandra Truth: Subverted. He is correct in that there's something up with "Wells" (and that "Wells" killed Stagg), and the team refuses to believe him. However, his words eventually get to them and they investigate.
Defrosting Ice Queen: Starts out cold to Iris, but warms up to her.
The Drag-Along: He's not really thrilled on being assigned as Iris' mentor.
He Knows Too Much: Is killed by Reverse Flash for knowing too much
Impaled with Extreme Prejudice: Gets impaled by Reverse-Flash's hand.
Intrepid Reporter: He is a Pulitzer Prize winning journalist for a reason.
Jerkass: When he is first introduced, he is very dismissive of Iris.
Jerkass Has a Point: He's entirely correct about "Wells" hiding something.
Killed to Uphold the Masquerade: At the hands of the Reverse-Flash. It backfires because his death clues Barry that "Wells" isn't all what he seems at all.
Mentor Occupational Hazard: His death and disappearance is what finally got Iris to be a full-fledged Intrepid Reporter.
Mythology Gag: Has a similar name to a Mason Trollbridge, an ally of Wally West. Whether they are the same character remains to be seen.
Never Found the Body: Played with. His death is shown on-screen but his corpse is hidden by the Reverse-Flash.
Not So Stoic: He gets understandably freaked out when the Reverse-Flash pays him a visit.
Sacrificial Lion: Just as he starts getting significance in the plot, he ends up on the wrong end of the Reverse Flash - the first notable character to do so and stay dead, unlike Cisco. Also, his death is what finally alarms Barry about "Wells".
Stern Teacher: His lessons and advice for Iris involving their work are very rigid but still profound.
The Stoic: His default expression is a bored, mildly disgusted one.
Played By: Tone Bell
The new editor of Central City Pictures News. He's not as enthralled by the Scarlet Speedster as the old management was, which puts him into conflict with Iris.
Accentuate the Negative: He seems to prefer focusing/showing the downside of things.
Angry Black Man: More of a pessimistic than outright angry.
Beard of Evil: Downplayed. He sports a beard and is an insufferable person.
Chuck Cunningham Syndrome: He hasn't been seen "Trajectory" nor in the post Flashpoint reality that Barry made.
The Cynic: A past instance of a Broken Pedestal led Scott to be suspicious and distrustful of heroes like The Flash.
Da Editor: He's seen ripping a sports reporter for making basketball more boring than baseball and ordering him to rewrite it in his first scene alone.
Expy: Of Spider-Man 's Jonah Jameson.
Hate Sink: Scott is a condescending, unreasonable, Mean Boss, introduced openly demeaning two of his writers and refusing to budge on his hatred of The Flash, forcing CCPN to run a smear campaign against him. When last seen, he mistakes Iris' intention to defend her opinions as a date, and even after making some headway with him, he still adamantly despises the Flash. He then asks Iris out for real, but she confides in Caitlin she skipped the date altogether due to her feelings for Barry, and Scott is never seen or mentioned again. From the perspective of the viewers, between his intentional dislikability with little redemption and catalyst for Iris' romantic realization, it becomes pretty clear that Scott was the first non-villainous character in the show that was meant for the audience to oppose.
Jerkass: His reasons for wanting to start an anti-Flash crusade? He doesn't show up one time to stop a metahuman (because unknown to him he was on a rescue mission in Earth-2). The fact "Jay" showed up in his place is completely irrelevant to him.
Mean Boss: He's seen criticizing two of his reporters work in the most abrasive way possible.
Principles Zealot: Mild Example. He distrusts The Flash pretty much entirely on principle alone. When Iris asked why he is so reluctant to trust Flash, he tells the story of a beloved Mayoral candidate who was in the pocket of the Mob, and how he exposed him as corrupt. He then tells Iris that she should't trust The Flash for pretty much that exact reason, that he might at some point in the future fail or do something bad/morally compromising.
Romantic False Lead: He shows an interest in Iris, to the point that he asks her out, but it's clear his role was to be the catalyst for Iris to fully embrace her feelings for Barry, as she admitted to Caitlin she skipped the date for that very reason.
Strawman News Media: He wants his reporters to start writing stories about how the Flash isn't as great a hero as Central City think he is.
Ungrateful Bastard: He wants the reporters to start smearing Flash from now on simply because he has been gone for a few days.
Spencer Young
see Arrowverse: Central City Independent Criminals page
Central City Citizen (A.K.A. Team Citizen)
Kamilla Hwang
Played By: Victoria Park
A bartender and aspiring photographer who soon starts a relationship with Cisco, and begins working for Iris as her photographer.
He Knows Too Much: After she sees the photo of Mirror Iris and the latter reveals not to be Iris, she is sent to the Mirrorverse.
Intrepid Reporter: Iris hires her as the Photographer for "The Citizen."
Locked Out of the Loop: Doesn't know anything about Cisco being a part of Team Flash, and he doesn't want her to, as he thinks that she deserves a normal life. Cisco decides to come clean, and she becomes aware of Barry being The Flash.
Love Interest: For Cisco, as of The Flash Season 5.
Nice Girl: A very nice and supportive woman.
Secret Keeper: For Team Flash, she's often times is even seen hanging out with Cisco at S.T.A.R Labs.
Second Love: After Cisco's romance with Gypsy turned out to be unwieldy and Cisco weeps the break-up, Cisco eventually dates her.
Understanding Boyfriend: She is not mad at Cisco for hiding his life as Vibe.
Allegra Garcia
see the Arrowverse: S.T.A.R. Labs page
Mirror-Iris
see the Arrowverse: Central City Criminal Groups page
Mirror-Kamilla
Julie Greer
see Arrowverse: Future Characters page
Central City University
Dinah Lance
The ex-wife of Quentin Lance and mother of Laurel and Sara. She works as a Greek and medieval history professor.
Clifford DeVoe
A history professor with a vision.
see Arrowverse: Central City Criminal Groups page
Marlize DeVoe
Wife of Clifford and a physics professor
Mina Chaytan
An activist and cultural anthropology professor.
see the Arrowverse: Metahumans page
Renee Adler
The university librarian.
Tracy Brand
see Arrowverse: S.T.A.R. Labs page
Central City Hospital
Matthew Kim
Dr. Ambres
Dr. Vanessa Ambres
Played By: Lossen Chambers
A physician of Central City who collaborates with Cicada due to their mutual hatred of metahumans.
The Corrupter: She and Orlin's anti-meta opinions warped Grace into someone far more dangerous.
Death by Irony: She's killed by the future version of the girl she helped keep alive.
Fantastic Racism: Like Cicada she hates metahumans due to them being the cause of so many deaths and injuries that she's had to treat. The death of the man she loved during Zoom's rampage was the start.
Freudian Excuse: Her hatred of metas is fueled by her fiancé being killed during Zoom's rampage.
Hidden Villain: In-Universe, Team Flash is completely unaware of the significant role an unassuming Central City Hospital physician has played in Cicada's crusade.
Killed Off for Real: Courtesy of Future Cicada aka Grace.
Secret Keeper: She keeps Orlin's identity as Cicada a secret. She hid Barry that Orlin was the uncle and legal guardian of Grace Gibbons.
Unwitting Instigator of Doom: By aiding a fugitive in his anti-meta crusade and withholding Grace's status as a metahuman, she has unintentionally contributed to Grace's descent into villainy.
see their respective page
Mercury Labs
Tina McGee
Dr. Christina "Tina" McGee
Played By: Amanda Pays
The head scientist of Mercury Labs, a rival to S.T.A.R. Labs.
see Arrowverse: Earth-90 page for her Earth-90 counterpart
Adaptational Jerkass: While still good, she is portrayed in a much darker light than her original counterpart and the previous adaptation. This version of Dr. McGee is described as an "egomaniac" and behaves as antagonistically as possible towards Barry and S.T.A.R. Labs. "All Star Team-Up" sees her warm up to Barry, revealing that her antagonism is because she and Wells were best friends until Tess Morgan's death. Who she knew as "Wells" after that is, of course, literally not the man she once knew. Later, she starts mellowing down.
Age Lift: As a result of the same actress who portrayed her in the 90s series reprising her role, this incarnation of Tina is notably older than prior versions, as well as Barry.
Benevolent Boss: Caitlin seems to have a high opinion of her when she briefly worked for Mercury Labs.
December–December Romance: Gets a few Ship Tease with Henry Allen in Season 2 as another nod to the 1990s show. Unfortunately, Zoom decided to be the ultimate literal Moment Killer.
Defrosting Ice Queen: She eventually warms to Barry after ignoring the CCPD nearly got her killed. By Season 2, she completely mellowed down.
Distaff Counterpart: She's Thawne's Mercury Labs counterpart.
Everyone Has Standards: Despite supposedly being a so-called egomaniac, she draws the line at militarising any technology developed at Mercury Labs. She fired Brie Larvan because of this.
Expository Hairstyle Change: She becomes a blonde in Season 2.
The Leader: Of Mercury Labs.
Locked Out of the Loop: She's totally unaware of everything that has happened in the series up until the penultimate episode of Season 2 where Team Flash finally fills her in.
Mean Brit: She's British and fairly cold towards most people she interacts with. She does eventually warm up to Barry, however, and most of her interactions are around Eobard Thawne, whom she doesn't gets along with.
Platonic Life-Partners: She and Dr. Wells used to be this. Sadly, Thawne caused something to happen.
A Pupil of Mine Until He Turned to Evil: Two of her scientists, Brie Larvan and Eliza Harmon, both turned to the dark side.
Remake Cameo: Pays first played Dr. Tina McGee in the 1990s Flash show, where she was the confidant and teased love interest of Barry Allen.
The Rival: To Thawne and S.T.A.R. Labs. The two don't have a high opinion of each other.
Secret Secret-Keeper: Reveals that she knows The Flash's identity in "Invincible". While no specific explanation is given, she points out that it's her job to be perceptive.
Sixth Ranger: Becomes an ally of Team Flash during the penultimate episode of Season 2.
We Used to Be Friends: She and Wells used to be best friends when they were living in Starling, but after Tess died in the car accident, she thought "Wells" changed too much. If only she knew how much.
You Can't Go Home Again: Black Siren destroys Mercury Labs in the penultimate episode of Season 2.
Jason Rusch
Played By: Luc Roderique
A grad student who worked with Professor Stein on the F.I.R.E.S.T.O.R.M. project, and informed Caitlin of his disappearance.
Adaptational Species Change: Metahuman and (second) host body of Firestorm in the comics, normal human here.
Adaptational Wimp: The second Firestorm in the Arrowverse will be Jefferson Jackson, so he won't be a Superhero anytime soon.
Age Lift: He's normally depicted as college aged, usually a college freshman. Here, he's a grad student, thus making him at least around in his mid-twenties.
Black and Nerdy: A grad student who worked for Prof. Stein.
Decomposite Character: The Arrowverse has Jefferson Jackson as the second Firestorm.
Demoted to Extra: In the comics, he's the second Firestorm. In this continuity, Jefferson Jackson fills that role, thus possibly reducing him to a One-Shot Character as a result.
In Name Only: Likely so due to being a Decomposite Character (see above).
Properly Paranoid: He explains to Caitlin that after the military seized everything from the project and Stein disappeared, he's been looking over his shoulder ever since.
Jason: Am I being too paranoid? Or not paranoid enough?
The Rival: To S.T.A.R. Labs, somewhat. He applied for a job there before the reactor explosion, but afterwards ended up working with Tina McGee at Mercury Labs instead.
Brie Larvan
see Arrowverse: The Rogues page
Caitlin Snow
see Arrowverse: Caitlin Snow & Killer Frost page
Eliza Harmon
see Arrowverse: Metahumans page
Stagg Industries
Simon Stagg
Played By: William Sadler
A possibly corrupt businessman set to receive a reward for his research in organ cloning.
Alliterative Name: Simon Stagg.
And Starring: Was credited with the "And" billing in guest star lineup.
Big Bad Wannabe: He really tries to set himself up as this toward the Flash. Too bad he goes down to Eobard Thawne first.
Bitch in Sheep's Clothing: Like the archetypal corrupt politician character, he projects an approachable person demeanor everytime he's in front of the public.
Cisco mentioned The Shawshank Redemption in Season 1. His actor was a main character there.
The Marvel Cinematic Universe is acknowledged to exist in the Arrowverse. His actor plays the U.S. President in that franchise, at least by the time of Iron Man 3.
Chekhov's Gunman: Laurel mentioned him as the major sponsor of CNRI in the first season of Arrow.
Corrupt Corporate Executive: Stole his organ-cloning research from Danton Black.
Killed to Uphold the Masquerade: Thawne kills him to protect Barry from possible capture and experimentation.
Smug Snake: Best seen when he was talking to Thawne; right before Thawne kills him, Stagg smugly states he would love to test what the Flash is capable of.
Rogues Gallery Transplant: His comic counterpart is normally a Metamorpho enemy.
Tempting Fate: He mocked Thawne about not bothering to stand when they met. Guess what the scenario is when he dies?
We Hardly Knew Ye: He gets stabbed by Thawne in his debut episode.
What Happened to the Mouse?: You'd think that with three of the main characters being on the police force, they would at least make mention of Stagg suddenly "disappearing". In "Out of Time", it's addressed that he was believed to have gone on a vacation, although someone from Iris' workplace was suspicious enough to go looking into Stagg's disappearance. Like Stagg, he was killed off by Thawne once he was digging into things.
Danton Black
August Heart
Ivo Labs
Dr. Anthony Ivo
see Arrowverse: Criminal Groups & Organizations page
A.M.A.Z.O.
Species: Robot
Appearances: Elseworldsnote Supergirl, The Flash
An android commissioned by A.R.G.U.S. to Ivo Labs in case of metahuman threats.
An Ice Person: Thanks to copying Killer Frost's powers.
Assimilation Backfire: Assimilating all of the superheroes' powers means he has all of their weaknesses as well.
Beat Them at Their Own Game: Designed to fight metahumans with the capability to copy their powers.
Combo Platter Powers: Due to copying various hero's abilities, as well as Superman and Supergirl's own combo platter powers.
Fun with Acronyms: Anti Metahuman Adaptive Zootomic Organism.
Improbable Aiming Skills: Possibly has this due to copying Green Arrow's skills.
Mythology Gag: His design is similar to the A.M.A.Z.O. from Justice League Unlimited, whose name was also in an acronym.
One Steve Limit: The name Amazo was first used for the ship that Oliver was imprisoned aboard during the Season 2 flashbacks. This version is much Truer to the Text.
Power Copying: As with all versions of Amazo.
Rubber Man: Thanks to copying Elongated Man's powers.
Super Speed: Thanks to copying Flash's speed. Although whether or not this means he can access the speed force is left unknown.
McCulloch Technologies
see Black Hole and Eva McCulloch's faction
Al Rothstein
Played By: Adam Copeland
A construction worker killed by an unknown person, who is later revealed to be his Earth-2 counterpart.
see Arrowverse: Earth-2 page for Earth-2 Rothstein
Adaptational Wimp: Normally portrayed as a hero and member of the Justice Society of America. Here, he's killed off in his only appearance.
And Starring: Gets this billing in the guest stars lineup.
Celebrity Paradox: The Highlander franchise was acknowledged by Cisco to exist in the Arrowverse. His actor appeared as a Mook in Highlander: Endgame.
Continuity Snarl: Eobard Thawne mentioned him in Season One as one of the casualties of the Particle Accelerator explosion. However, in Season Two, he's said to have been away on his honeymoon when it happened, so they believe he couldn't have become a metahuman.
Dead Alternate Counterpart: Courtesy of said counterpart from Earth-2.
Dead to Begin With: His first appearance is his only one.
Death by Adaptation: His comic counterpart is still alive and a member of the Justice League.
Killed Offscreen: Courtesy of his his Earth-2 counterpart.
Victim of the Week: He's introduced via his corpse.
Hunter Zolomon
Played By: Teddy Sears
Zoom's Earth-1 counterpart.
see Arrowverse: Hunter Zolomon page for his Earth-2 counterpart, Zoom
see Arrowverse: Other Entities page for Black Flash
Adaptational Heroism: He is not Zoom; his Earth-2 self is. At the same time, he shows no signs of being a heroic FBI agent either, though we don't see enough of him to confirm that.
Adaptational Dumbass: Comic Hunter is the leading expert on metahuman psychology, but given that the S.T.A.R. Labs crew didn't recognize his name, it's safe to assume this is not the case here.
Adaptational Wimp: Very likely. In the comics, he is Zoom. Here, well, he's not, though it's entirely possible that he may gain powers at a later point.
Adaptation Dye-Job: A redhead in the comics, brown haired here.
Age Lift: In the comics, he is closer in age to Wally West. Here, he's in his 30s (presumably late 30s based from his actor's age) while Wally is in his early 20s.
Chekhov's Gunman: Not in person, but Caitlin knowing about Hunter allows Team Flash to work out Zoom's true identity and backstory.
Composite Character: Subverted. We are led to believe he is the Earth-1 counterpart of Jay Garrick, but that is a lie. His Earth-2 counterpart is still Hunter Zolomon, aka Zoom.
Dark Is Not Evil: He wears all black and seems to be not evil, unlike his Earth-2 counterpart.
Death by Childbirth: Part of Zoom's lie about his backstory.
Decomposite Character:
In the comics, he is Zoom's civilian identity. Here, Zoom is his Earth-2 counterpart and the Big Bad of Season Two.
His role in the comics prior to turning evil was serving as a Friend on the Force to the Flash. Here, that role was given to Eddie.
Early-Bird Cameo: Usually introduced during the Wally West era. Here, he makes a cameo during Barry's second year as The Flash. It is yet to be seen if he will have a greater role in the future.
Foreshadowing: He wears all black, just like Zoom.
Good Counterpart: Unlike his Earth-2 counterpart, who is a psychotic serial killer turned even more psychotic supervillain, this Hunter Zolomon appears, at least at a glance, to be a well-adjusted individual.
Identical Twin ID Tag: Another alternate version variant. His glasses are what make him stand out from his Earth-2 twin.
Megane: He's wearing spectacles when introduced.
Missing Mom: It is stated that his mother suffered Death by Childbirth. According to Zoom, anyway.
Mythology Gag: He's only shown sitting, possibly referencing his comic self being handicapped (first with a limp, later paralyzed).
Red Herring: Since he is Zoom in the comics, his appearance serves a possible entry for Zoom's Secret Identity. Turns out he isn't, but his Earth-2 counterpart is.
Sexy Spectacles: A glasses wearing 6'3 hunk.
Small Role, Big Impact: Being showed to Caitlin allows Harry to deduce that Zoom lied, as he recognizes the name as a Serial Killer on Earth-2.
Tall, Dark, and Handsome: Like "Jay", he stands 6'3 and is a brunette hunk.
Shay Lamden
Species: Humannote Unlike his Earth-2 counterpart, he did not survive his mutation into a humanoid shark
Played By: ???
A marine biologist who did not survived his metahuman transformation. He is the Earth-1 counterpart of King Shark.
see Arrowverse: A.R.G.U.S. & Task Force X page for Earth-2 Lamden
Adaptation Name Change: Shay Lamden instead of Nanaue.
Adaptation Species Change: He did not successfully mutate into a humanoid shark like his Earth-2 (and comic) counterpart.
Body Horror: Unlike his Earth-2 counterpart, he did not survived his mutation and succumbs from the pain.
Dead Alternate Counterpart: For King Shark.
Death by Adaptation: He did not survive his mutation into King Shark.
Friend to All Living Things: He was a marine biologist, after all.
Killed Offscreen: He succumbed to his mutation way before the series starts.
Posthumous Character: He died somewhere between The Flash Series premiere and the interim months that Barry was in a coma.
Race Lift: Depicted here as Caucasian instead of Polynesian.
Tanya Lamden
see the Arrowverse: A.R.G.U.S. & Task Force X page
Arrowverse: Caitlin Snow & Killer Frost
Characters/Supergirl (2015)
Arrowverse: Team Arrow
Characters/Crisis on Earth-X
Arrowverse: A.R.G.U.S. & Task Force X
Characters/Arrow
Arrowverse: The Rogues
Characters/Legends of Tomorrow
Arrowverse: Central City Criminal Groups
Arrowverse: Other Earths
Characters/The Flash
Arrowverse: Time Criminals
Characters/Aquaman
Titansverse
Characters/The Flash (2014)
Characters/Firestorm
Arrowverse: Metahumans
Characters/Arrowverse


text:
Göteborg Energi Gothnet AB (kallas GothNet), är ett svenskt företag som är ett helägt dotterbolag till Göteborg Energi Aktiebolag. GothNet äger och driver ett stadsnät i Göteborgsregionen. GothNet är medlem i svenska stadsnätsföreningen.

Stadsnätet
Stadsnätet kan grovt delas in i dessa delar:
egna optofibernätet
öppna stadsnätet (mer än 60000 hushåll är anslutna)
Västgötaringen GothNet driver denna fiberring och når perifera orter som till exempel  Alingsås, Borås, Ulricehamn, Falköping, Skövde, Skara, Lidköping, Trollhättan och Stenungsund.

Västlänken
GothNet samarbetar även med andra nätägare i projektet Västlänken.
Det är ett samarbete med stadsnätägare i västra Sverige. I dagsläget nås cirka hälften av Västra Götalands län samt de flesta kranskommuner till Göteborgs kommun till exempel
Kungälv (nätägare Kungälv energi)
Partille (nätägare Partille Energi)
Mölndal (nätägare Mölndal energi)
Lerum (nätägare Lerum energi)

Referenser

Externa länkar
Officiell webbplats för Göteborg Energi Gothnet AB
Officiell webbplats för Västlänk

Företag bildade 2000
Företag med ägande av Göteborgs kommun
Stadsnät i Sverige
Svenska telekommunikationsföretag

redpajama_set_name: RedPajamaWikipedia


text:
using System;
using System.Collections;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Data;
using System.Data.Common;
using System.IO;
using System.Linq;
using System.Linq.Expressions;
using System.Reflection;
using System.Text;
using IQToolkit.Data.Common;
using IQToolkit.Data;
using IQToolkit;

namespace RevStack.Client.API.Query
{
    public class OrientDbLanguage : QueryLanguage
    {
        DbTypeSystem typeSystem = new DbTypeSystem();

        public OrientDbLanguage()
        {
        }

        public override QueryTypeSystem TypeSystem
        {
            get { return this.typeSystem; }
        }

        public override bool AllowsMultipleCommands
        {
            get { return false; }
        }

        public override bool AllowDistinctInAggregates
        {
            get { return true; }
        }

        public override string Quote(string name)
        {
            return name;
        }

        private static readonly char[] splitChars = new char[] { '.' };

        public override Expression GetGeneratedIdExpression(MemberInfo member)
        {
            return new FunctionExpression(TypeHelper.GetMemberType(member), "LAST_INSERT_ID()", null);
        }

        public override Expression GetRowsAffectedExpression(Expression command)
        {
            return new FunctionExpression(typeof(int), "ROW_COUNT()", null);
        }

        public override bool IsRowsAffectedExpressions(Expression expression)
        {
            FunctionExpression fex = expression as FunctionExpression;
            return fex != null && fex.Name == "ROW_COUNT()";
        }

        public override QueryLinguist CreateLinguist(IQToolkit.Data.Common.QueryTranslator translator)
        {

            return new Linguist(this, translator);
        }

        class Linguist : QueryLinguist
        {
            public Linguist(OrientDbLanguage language, IQToolkit.Data.Common.QueryTranslator translator)
                : base(language, translator)
            {
            }

            public override Expression Translate(Expression expression)
            {
                // fix up any order-by's
                expression = OrderByRewriter.Rewrite(this.Language, expression);

                expression = base.Translate(expression);

                expression = UnusedColumnRemover.Remove(expression);

                //expression = DistinctOrderByRewriter.Rewrite(expression);

                return expression;
            }

            public override string Format(Expression expression)
            {
                return OrientDbFormatter.Format(expression, this.Language);
            }
        }

        public static readonly QueryLanguage Default = new OrientDbLanguage();
    }
}

redpajama_set_name: RedPajamaGithub


text:
Marietta's Admission counselor/distance coach committed to saving lives through education
Fall 2018 ›
A 2016 Olympian and 2017 Jeux de la Francophonie gold-winning marathoner Makorobondo "Dee" Salukombo was a teenager when he and his family fled his village of Kirotshe in the Democratic Republic of the Congo near the Rwandan border for a refugee camp in neighboring Uganda — barely escaping the civil war tearing apart his homeland.
"I started running in Uganda," says Salukombo, who is the Diversity and Inclusion Counselor for the Office of Admission and an Assistant Coach for Cross Country and Track & Field. "We were in PE class and our teacher said, 'If you can walk, you can run.' And that is when I realized that running was something I was good at and really wanted to do."
For three years, his family remained in limbo as refugees in Kampala, Uganda until, when he was nearly 16, his family was sponsored by the Catholic Charities Diocese of Cleveland and brought to the northern Ohio city.
"When we came to Cleveland, it was a dream that came true," he says. "My mindset was that I wanted to thank my parents by being the best student I could be, but I knew I was far behind the other students. To understand computers and the language, I had the mindset that I had to work harder than everyone else. For six months straight I read a book every day."
His hard work academically and athletically paid off in high school, during his undergraduate years at Denison University and in his distance running. After earning a Bachelor of Science degree in Chemistry and competing in the 2016 Summer Olympic Games in Rio de Janeiro, Salukombo joined Marietta College's Admission and coaching staffs.
"Dee works very well with our athletes. He relates with them very well, and they seem to really love him," says Jason Davis, men's and women's Cross Country and Track & Field coach. "His advice to them is always on point and motivational. I hope we have Dee around for a long time."
Though he is training for another shot at the Olympics, Salukombo is more likely to talk about his charity, Project Kirotshe, a youth running program in DR Congo that focuses on helping children gain access to an education. In addition to providing running guidance and training, the organization helps raise money for tuition and plans to purchase goats for families, who can earn money by selling milk or breeding the goats. This money pays for children to remain in school.
"I came here as a tiny refugee kid, and people took me under their wings and changed my life," he says. "I have 110 kids in Congo that my organization has been supporting since 2012. There are a million other kids who are still going through what I went through in that camp. They have no concept of long-term planning because war does not let you plan ahead."
Salukombo proudly talks about his young runners working hard to train for regional and national distance competitions, including a girl who ran a 5K in 17:31 or the girl's younger sister who is competing in the 2018 World Youth Olympics in Argentina. On average, the organization helps keep 70 children in school — and most recently celebrated two students who completed nursing school.
"Today, the runners in my village are respected," he says. "They are viewed as leaders, as teammates, as hard workers. For some, it takes a one-hour walk down a mountain to reach where we train, and then they run 8 to 10 miles. It takes them an hour and a half to walk back up the mountain. They do this two to four times per week. And they are proud to do this. Like me, they are grateful and they take nothing for granted."
- Gi Smith

redpajama_set_name: RedPajamaCommonCrawl


text:
Gallery Exhibits|
The Cartographic Creation of New England
An exhibition of early maps that chronicles the effects of European exploration and settlement in north-eastern North America in creating a spatial concept called "New England."
The Osher Map Library and Smith Center for Cartographic Education, University of Southern Maine, Portland. November 30th, 1996 to April 27th, 1997
© all site text and images (excepting item 19), University of Southern Maine, 1996.
We welcome you to visit this exhibition in person. Special tours are available for K-12 and other groups. For more information, including directions and open hours, please connect to the Osher Map Library's web-site, once you have finished viewing the exhibition.
Instructions for using this site are given on the next page, so please advance now.


Specialist salon treatments & products designed to enhance and improve the appearance of today's woman or man.
Nourish your hands and feet.
We only use the best .....St.Tropez & Topaz Sunbed.
© 2012 Aroma Beauty Rooms. All Rights Reserved.


Timing Solution as an additional decision making tool for traders is based on one simple idea: explore the correspondences between market movements and some processes or phenomena we are familiar with. Why? - only because there is no a theory that explains market movements and is confirmed by practice. We have only collection of consistent data and some attempts to understand it through methods either Fundamental or Technical Analysis. Fundamental Analysis explores the correspondences between the market movements and fundamental factors (which are registered observations of economical life phenomena). Technical Analysis works with price charts and seeks for their inner relationships represented by TA indicators (which are speculations on price charts parameters). Timing Solution is a software designed to fill in the gap between the two; it analyzes past data, compares them to some known phenomena and simulates the relations between these phenomena and market data. We can do it, and we can do it easily - due to Universal Language of Events (ULE), the core idea of this software.
When I have met Alphee Lavoie 10 years ago, one of his first questions was: is it possible to calculate and register the dates when some astrological event has occurred and watch the market performance at those dates? This was possible, and we did it. This idea has been realized in the SuperSearch module of Market Trader series. At that time, we did a recording of many different astrological events. Then the idea of Astrological Language was born and developed later into Universal Language of Events. ULE has one very important feature: it is designed to deal with different events, not only with astronomical or astrological ones. As an example, now we can include price events as well. This module has a huge potential, and when some processes will be found that prove to be corresponding to markets' activity, we can add them to ULE and use for analysis.
So, ULE is built from small bricks - different events. We can find when any of these events has occurred in the past and record the market condition at these moments. (Here and further in these lessons I call analyzed set of data as "analyzed market", "market" or "financial instrument"; it means the consistent data that we analyze with the help of Timing Solution. It could be data set on some stock, index or futures; I tried several times sun-spot activity data and temperature files for some locations as well.) As I said already, the huge part is made by astro events. I tried to include astro parameters that reflect a real process - such as planetary positions in Zodiac (space), angles between the planets, planetary speed, planetary phases; these astrological events coincide with regular astronomical events and are described by proper equations. Also, I have included pure astrological parameters - such as retrograde/direct movement, planetary positions in houses, Moon Nodes and other.
If you are familiar with Astrology already, you will easily understand how to work with this module (either SuperSearch in Market Trader or ULE in Timing Solution). If you are not, do not panic. You have no need to learn the whole great astrological lore, at least not now; it is enough for you to know the name and general meaning of any astro event included into ULE and be able to work with it. "Work with it" means being able to make the choice of necessary parameters and interpret the calculated results. You can trust the accuracy of calculations, Timing Solution and Market Trader do it well (plus the users of our astro software have checked it already many times:)). Later, and believe me, it will come - you will be fascinated by this Astro world, and you will read and learn a lot. But now - it will be enough to be able to work with these bricks of ULE. It is a very valuable ability: it will help you later to create your own models for projection lines and now it will help you to evaluate different ideas.
At least once a week I get a question like this: "What do you think will happen to the stock market when Mars ingresses Leo next time? Will it go up (down)?". When I ask in turn why this should happen, the best answer is something like this: "It has happened when Mars has ingressed Leo in September 1996". What do I think? Nothing. As my teacher, friend and partner Alphee Lavoie has said once, "The financial astrology is the precise science". Trading with astro cycles, we need to see the whole picture, all "pro et contra" of our statements, not just one side.
So, what would I do? I would run ULE (or SuperSearch) module. And there I would open the tab for the astro event in question, do the calculations and get all the moments when this event has occurred in the past. (By the way, "past" means my price data file, the historical data for the financial instrument that I do research for.) Then the program helps me again: it compares the event dates to the market conditions and does the statistical analysis. So, the unpleasant and boring job of calculating all ups and downs and comparing them to control groups is produced by the computer. I will do the honored job of thinking and making conclusions. And you can do it, too.
After learning this material, you will be able to check any astro related statements within seconds. Therefore, you will deal with astro finance info on a new level - you will have no need to trust or believe somebody or something, you will find the value of their statements. Next level will be making such statements yourself.
There are several ways to answer this question. We may guess (which is not my way). We may apply general astrology considerations (which I would not recommend; the general astrology's symbolism is designed for the needs of the personality; the core ideas behind it definitely work though sometimes their application is too vague; it is a theme for a special discussion and not a topic of this lesson). I prefer to do the thorough analysis.
Do it together with me.
We have here an object - DJI index. We will make a conclusion regarding its movement in respect to the outer factor - the movement mode of Saturn.
Doing this, we set the Learning Border Cursor (LBC) to the last price point available. This way we tell the program that we will use ALL available price history to analyze this astro phenomenon.
and then click "Edit Model" button.
This is the central window for ULE. There are many tabs there; each of them corresponds to some astro event or a group of events. You define everything there. Every tab is like an astro sentence. I recommend spending some time to get familiar with each tab.
Let us record our event, "the transit Saturn changes direction direction from retrograde to direct".
#5: The form will appear. It describes things related to the planetary movement mode: the mode itself, speed and acceleration types. You can do it for one planet only or for a group of planets. This one tab gives you ability to do a lot of research.
We have recorded this astro event, "transit Saturn is moving retrograde".
The black line represents our data; the red zones correspond to the periods when transit Saturn is retrograde.
We have got 116 lines within our data file. Now, we need to take them one by one and watch how the stock market (i.e., DJI) moved around these moments.
This diagram shows an average price change around the moment when Saturn becomes retrograde.
What conclusion can be made? There is upward movement there; however, it has started before Saturn's change of direction, at least 10 days earlier.
Before Saturn going retrograde, the DJI goes up mostly, though there are some insignificant fluctuations. However, the next day after this phenomenon occurs, the DJI loses its energy to grow. The stock market needs some time to "recover the breath".
#13: We are able not only register the existence of the upward trend before Saturn becomes retrograde; we can evaluate the strength of this trend as well.
Let us compare the DJI value 2 days before Saturn becomes retrograde to its value 20 days before this event. As you remember, it has occur 116 times within our data file. How many times there was increase in the value of DJI? And how many times did it go down?
We can get the answer to this question very easily: A-push left mouse button on "A" point (20 days before retrograde); B-drag the cursor while holding left mouse button from point "A" to point "C" (2 days before retrograde) C - release mouse button. The program looks through each one of these 116 moments and compares values 2 days and 20 days before Saturn becoming retrograde.
You see that the price went up 77 times, while it went down 39 times only. Plus, these results differ from the results provided by the control group (see the figures in brackets). So, I would say that the existence of upward trend for DJI, at least 20 days before Saturn going retrograde, is obvious.
However, you should be extremely cautious in making conclusions like this. The tricky part here is related to the control group issue, a very important thing in Statistics. The control group helps to eliminate natural trends. (Here is the example of a natural trend: a person is getting married; the main reason for this marriage is that they love each other. It is nothing surprising if the person is in the age 25 - 40. What if the person is 92? The control group for this age will show that this is an extraordinary event.) There are many ways of forming the control group. I chose the simplest one: we consider fictive event that happens totally randomly and watch how this event (so called "null hypothesis") affects the stock market.
It means that the control group shows that DJI may go up 66 times against 50 down. In other words, the up movement is more typical for DJI under these conditions.. So we need co compare these values.
In any case, the DJI went up 77 times against 66 times caused by general trend. This tendency is rather strong. Click here to read more regarding this issue.
DJI went down 58 times against 53 caused by other reasons than Saturn's change of direction So the downtrend movement is not so strong.
By the way, an interesting thing is that the Full Moon does not provide any consistent results.
It means that the DJI starts its uptrend movement 3 days after the Sun ingresses Cardinal signs (Aries, Cancer, Libra and Capricorn); the probability of DJI going up for the next 6 days is 62%.
Here we explore this downtrend arrow, while the statistics shows that the price went up 63 times against 47. It means that our downtrend movement takes place in the uptrend environment; it might be a strong one, however it is at least only one strong down among these 47 downs, not enough powerful to change the trend.
Now, your homework. See here.
Resume: We have learned to record astro events and analyze our data in respect to these events. Now you are able to evaluate any astro info published in books, magazines, newsletters and in the Internet.