home / russian-ads

display_ads (view)

Data source: simonw/russian-ira-facebook-ads-datasette

69 rows where an ad_target was people_who_match:Friends of connections: Friends of people who are connected to LGBT United

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
561 location:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 8111 951 https://www.facebook.com/LGBT-United-839497472793277/ SCOTUS RULES AGAINST KENTUCKY CLERK IN GAY MARRIAGE CASE The Supreme Court on Monday evening denied a Kentucky Clerk’s request to keep enforcing her “no marriage licenses” policy — an attempt to avoid issuing marriage licenses to same-sex couples — while she appeals the trial court’s preliminary ruling. Rowan County Clerk Kim Davis will have to Choose whether to issue marriage licenses, defying her Christian conviction, or continue to refuse them, defying a federal judge who could pummel her with fines or order that she be hauled off to jail. For Ms. Davis to enact her own personal policy is completely unacceptable. She is on her fourth marriage, a sinner according to her Bible, yet she’s screaming about religious convictions. What a hypocrite! And she doesn't even perform the ceremony, only issue a license. What her religious convictions has to do with it?? It's not up to her to make policy, it's her role only to enact it! Funny how all these "Christians" are preaching and practicing all this hate, eh? If Jesus were around today, his response would be most likely, "What the hell is wrong with you people!" #SameSexMarriage #MarriageEquality #Kentucky #SCOTUS #homophobia #bigotry 8.0 500.00 RUB 2015-09-01T07:44:55-07:00 2015-09-03T07:44:00-07:00
562 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 4067 339 https://www.facebook.com/LGBT-United-839497472793277/ On the national level, the suicide risk for gay, lesbian and transgender youth is far higher than it is among straight youth. LGBTQ youth actively plan suicide at a 2.6 times greater rate than straight youth. LGBTQ youth attempt suicide at a 4.0 times greater rate than straight youth. LGBTQ youth require medical attention for suicide attempts at a 5.1 times greater rate than straight youth. Behind these numbers are countless lives lost. This has to stop! Discuss problems together — but only at the initiative of the youth. Be caring and supportive discussing these issues. Don't sweep the problems "under the carpet"! #LGBTQ #youth #suicide #acceptance 8.0 500.00 RUB 2015-07-17T06:34:53-07:00 2015-07-19T06:34:53-07:00
563 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 728 87 https://www.facebook.com/LGBT-United-839497472793277/ #equality #humanrights #Igbt #manifesto 2.79312 174.57 RUB 2015-08-06T07:43:19-07:00 2015-08-07T07:43:18-07:00
568 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 467 67 https://www.facebook.com/LGBT—United—839497472793277/ Excuse me... WHAT?l? Taxpayers Spend $3.5 Million to Find Out Why Lesbians Are Fat A US. Health and Human Services study to understand why lesbians are fat has now cost taxpayers over $3.5 million to-date. The study, “Sexual Orientation and Obesity: A Test of a Gendered Biopsychosocial Model,” seeks to determine why there is a disparity in the obesity rates between straight women and lesbian women and straight men and gay men. Oh Godll It made you look the fools! People overeat when they are unhappy with themselves and their lives! Not only lesbians! And we have enough reasons! First of all — your researchlllt's humiliating! 1.86544 116.59 RUB 2015-07-15T03:40:04-07:00 2015-07-17T03:40:04-07:00
570 location:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 260 26 https://www.facebook.com/LGBT-United-839497472793277/ Colorado court sides against baker who refused same-sex marriage cake order The appellate court ruled that requiring the cake shop to comply with an anti- discrimination law does not violate the First Amendment. The ruling was premised chiefly on the Colorado Anti-Discrimination Act, which prohibits discrimination on the basis of a number of protected categories, including sexual orientation. I'm so sick of this true Christians who have never taken the Bible in their hands. reading or listening someone who read ancient texts and then declaring them to be applicable to today violates the scriptures. God didn't support divorces, so why did bakers not refuse service to divorcees? Anyway, the truth on our side... finally. So, grab your bee and go to eat some cakes! 1.42208 88.88 RUB 2015-08-18T08:18:19-07:00 2015-08-19T08:18:19-07:00
571 location_living_in:United States, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 280 30 https://www.facebook.com/LGBT-United-839497472793277/ Congratulations! Now we have the Gay Scouts of America! The Boy Scouts of America Executive Committee unanimously approved allowing gay adults to serve as leaders, officials said on Monday, in a major step toward dismantling a policy that has caused deep rifts in the 105-year-old organization. This resolution will allow chartered organizations to select adult leaders without regard to sexual orientation, continuing Scouting’s longstanding policy of Chartered organizations selecting their leaders. The Boy Scouts of America’s ban on gay adults has stood as a towering example of explicit, institutional homophobia in one of America’s most important and recognizable Civic organizations. This is a step in the right direction, but we’re still really concerned that there are still going to be groups that are going to be hostile to gay |eaders...This story certainly brought out the haters and the loony "Christians." They've lost so many cultural battles in their effort to keep us all in the middle ages that I think it's unhinged most of them! 1.9246400000000001 120.29 RUB 2015-07-15T03:40:52-07:00 2015-07-17T03:40:51-07:00
572 location:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 905 154 https://www.facebook.com/LGBT-United-839497472793277/ Vatican Says Transgender Man Cannot Become A Godparent The Vatican has rejected a request by a transgender man in Spain to become a godparent, ruling that his sexual identity means he is incapable of carrying out the task. Alex Salinas was asked by his family to be godfather to his nephew, but the bishop of his local diocese on Spain’s southern coast questioned his gender identity. Salinas was born a woman but has since undergone hormone therapy and has a male ID in Spain. He is now waiting for gender surgery. Bishop Rafael Zornoza Boy of Cadiz and Ceuta rejected the family’s request to name Salinas as a godfather. Then, after a media storm, the bishop wrote to the Vatican for advice. Zornoza published the Vatican’s reasoning for rejecting Salinas’ wish. It said transsexual behavior “reveals in a public way an attitude opposite to the moral imperative of solving the problem of sexual identity according to the truth of one’s own sexuality.” The pope supported gays, but now for some reason the transman wasn't allowed to be a godfather in Spain, an entirely Catholic, but at the same time, the most friendly country towards the LGBT community. Anyway it's just another superstition of Church. Funny. 4.79072 299.42 RUB 2015-09-09T07:21:52-07:00 2015-09-10T07:21:51-07:00
573 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 3576 469 https://www.facebook.com/LGBT-United-839497472793277/ Remember when African Americans couldn't drink from the same drinking fountains as whites? Remember when gay people couldn't get married? Both scenarios sound so ridiculous. Especially when you think about how much money is to be gained if same-sex couples are legally allowed to get married. A majority of small business owners believe companies shouldn’t be allowed to withhold goods or services from lesbian, gay,bisexual or transgender people based on an owner’s religious beliefs, according to a survey released Monday. Of course marriage is good for the business - no matter who it is that is marrying. It's a billion dollar industry in our country! I am certain that if a state supported marriage for all, then business would flourish. No one would be offended by not being considered legitimate, when their feelings are legitimate. 14.91136 931.96 RUB 2015-07-14T07:02:42-07:00 2015-07-16T07:02:00-07:00
574 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 967 82 https://www.facebook.com/LGBT-United-839497472793277/ Don't be afraid to be yourself. Every person is born unique, and our own way is just as unique and distinctive. And if you don't live your life in your own way you will regret it more and more with each passing year. So don't let anybody tell you who you are is not enough! #queerquote #beyourself #OscarWilde 4.8872 305.45 RUB 2015-08-12T07:32:53-07:00 2015-08-14T07:32:52-07:00
576 location:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 4930 630 https://www.facebook.com/LGBT-United-839497472793277/ Happiness is like a kiss. You must share it to enjoy it. Share your kisses, be happy and have a gay day! 8.0 500.00 RUB 2015-08-18T08:17:48-07:00 2015-08-20T08:17:00-07:00
577 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 3542 455 https://www.facebook.com/LGBT-United-839497472793277/ Our hearts are heavy with grief that we have lost another vibrant member of our community too soon. Our thoughts and prayers go out to all of Amber’s family and friends whom she Clearly loved deeply. Trans woman murdered in Detroit. According to initial police reports, 20-year- old Amber Monroe was shot to death. A lot of transgendered women don’t have support systems or employment. So they are forced to do whatever they can do to survive. This attack was fueled by transphobia and we do know that Amber’s murder is the 12th murder of a transgender woman in the United States this year, and the 10th murder of a transgender woman of color. Transgender women, and especially transgender women of color, are disproportionately affected by violence. Her life was just beginning... I know that this loss will leave so many people with a hole in their lives and with more questions than answers. Let’s work for real Change so that our transgender sisters can be free from persecution. I know we can do better. We have to do better! 12.7416 796.35 RUB 2015-08-11T08:31:51-07:00 2015-08-12T08:31:50-07:00
578 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 890 76 https://www.facebook.com/LGBT-United-839497472793277/ 'THAT'S NOT WHAT I AM': TRANSGENDER PERSON FIGHTS TO CHANGE 'F' TO 'M' ON DRIVER'S LICENSE. One of the friends of our group shared his story with us! He has been discriminated against by local authorities in Louisville, Ky. There's a gap between Kentucky law and federal law. People trying to Change the gender on a passport only need to be in transition, not post-surgery. But many transgender people never complete the surgery due to economical reasons, health issues etc. It seems that the law does not care about these people’s Circumstances. So typical of bureaucrats. It is very important for every transgender to be able to Change his\her identification to reflect who they really are. It’s not just about person dressed as a man one day and then dressed as a woman the next, or vice versa. It is about much more deep, more complex things. An authentic transgender man or woman on|y presents as the gender they truly are; And not the gender they were assigned to at birth. Transgender people are not trying to trick anyone by asking for identification Changes. They are trying to avoid as much confusion as absolutely possible. Because it is confusing enough to be the gender different from the one you were assigned to at birth. Please share your stories with us, because united we can stand against injustice and inequality! #Kentucky #transgender #inequality #discrimination 5.59984 349.99 RUB 2015-07-17T06:34:09-07:00 2015-07-19T06:34:09-07:00
579 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 782 137 https://www.facebook.com/LGBT-United-839497472793277/ "Here are the values that I stand for: honesty, equality, kindness, compassion, treating people the way you want to be treated and helping those in need. To me, those are traditional values." -- quote by Ellen DeGeneres #equality #equalrights #Igbt #traditionalvalues #EIIenDeGeneres #queerquote 4.184640000000001 261.54 RUB 2015-08-06T07:43:41-07:00 2015-08-07T07:43:40-07:00
595 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 1617 209 https://www.facebook.com/LGBT-United-839497472793277/ HOMOPHOBIA STILL RUNNING STRONG IN AMERICA. Controversial artist Ed Freeman sparked fury among conservative patriots after sharing his own version of the 1945 image. The outrage was caused by artist’s artwork recreating iconic |wo Jima photo, with a gay pride flag and haIf-naked men has received death threats. That’s a bit too harsh treatment for an artist, don’t you think? What’s this, the American version of Je suis Charlie? Joe Rosenthal’s picture of soldiers hauling a flag pole up after declaring the island of |wo Jima secure during the Second World War won the Pulitzer Prize in 1945. Around 70,000 US. troops fought more than 20,000 Japanese. It wasn’t a fair fight back then, and it’s not a fairfight today. But there’s nothing disrespectful in this image. Isn’t the imitation is the best form of homage? #homophobia #JoeRosenthaI #EdFreeman #IwoJima 3.99968 249.98 RUB 2015-07-17T06:34:31-07:00 2015-07-19T06:34:31-07:00
597 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 6695 885 https://www.facebook.com/LGBT-United-839497472793277/ That's sooooo coo“! 10.884 680.25 RUB 2015-08-11T08:31:18-07:00 2015-08-13T08:31:00-07:00
599 location:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 1406 197 https://www.facebook.com/LGBT-United-839497472793277/ Gay the force be with you: Star Wars soldier comes out Hero soldier Sinjir Rath Velus comes out in a new novel, which is part of the smash hit sci-fi franchise with arCh-baddie Darth Vader. The space warrior appears in Star Wars: Aftermath, which bridges the gap between Return of the Jedi and new film The Force Awakens. Sinjir, an Imperial turncoat who now serves in Luke Skywalker’s Rebellion, is the first major gay role to be part of the Star Wars universe. He reveals his sexuality to female bounty hunter Jas Emari, who tries to Chat him up. Chuck Wendig, author of Star Wars: Aftermath, said: "I don’t think his sexuality needs to be this giant plot point. At the same time, it’s part of who he is. Isn't that great, guys? Ain't no lie, It's a big step forward. We want to thank the creators of the new "Star Wars" for the incredible courage and opposition to conservative bias in Hollywood Cinema. There should be a special organization in Hollywood that will protect the rights of gay actors. There should be at least one gay Character in every movie in order to help the American society get rid of homophobic stereotypes. 4.75824 297.39 RUB 2015-09-09T07:22:25-07:00 2015-09-10T07:22:24-07:00
600 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 446 46 https://www.facebook.com/LGBT-United-839497472793277/ We have a method in place called, don't vote these morons into office! Passing the “First Amendment Defense Act” introduced by Sen. Mike Lee has been anti-LGBT oonservatives’ top priority since the Supreme Court brought marriage equality to all 50 states. It’s part of the National Organization for Marriage’s post-Obergefell plan and Republican presidential candidate pledge, and the Family Research Council mentions it almost daily. Lee joined NPR this week to defend the bill, basically admitting that all it does is enable anti-gay discrimination. Lee framed his concern as one about the government discriminating against religious institutions — for discriminating against people in same-sex marriages. It’s the latter he wants to allow by ensuring that the government never penalizes any religious institution that refuses to recognize a same-sex couple’s marriage, or employ them, house them, or serve them. Mr. Lee, you are ridiculous! You're just going to have to get over that fact that we have full Federal Civil rights now. Or don't! We will go on happily living our lives while you froth at the mouth and throw a fit because we're being treated equally under the law! 2.65856 166.16 RUB 2015-07-14T07:03:45-07:00 2015-07-16T07:03:44-07:00
601 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 31 7 https://www.facebook.com/LGBT-United-839497472793277/ Lil bit about the history of Gay Rights... Protestor at Weinstein Hall demonstration for the rights of gay people on campus. NY 1970. 0.41472000000000003 25.92 RUB 2015-08-04T06:19:12-07:00 2015-08-06T06:19:12-07:00
602 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 89 12 https://www.facebook.com/LGBT-United-839497472793277/ Luce: I met this girl... but she's with someone else. Ella: Does she love you? Luce: I don't know... no... yes... but it doesn't matter. Ella: [gently caresses Luce's face] Oh... it's all that matters. Imagine Me & You 0.24656 15.41 RUB 2015-08-04T06:19:31-07:00 2015-08-06T06:19:31-07:00
603 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 5012 588 https://www.facebook.com/LGBT-United-839497472793277/ Did you know that bats have the highest homosexuality rate of any mammal? It seems we could learn a lot from nature about acceptance and open- mindedness! #bats #batman #humor #rainbow #gaypride 11.200000000000001 700.00 RUB 2015-08-06T03:26:51-07:00 2015-08-08T03:26:50-07:00
605 location:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 398 53 https://www.facebook.com/LGBT-United-839497472793277/ The Hope Speech. Harvey Milk addressing crowd from stage at San Francisco Gay Day Parade. 1978. 1.7752000000000001 110.95 RUB 2015-08-18T08:18:33-07:00 2015-08-19T08:18:32-07:00
607 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 277 30 https://www.facebook.com/LGBT-United-839497472793277/ PLEASE NO HATE! JUST LET US EAT CAKE! Wedding cake is back in the news with developments in both the Oregon and Colorado bakery cases involving discrimination on the basis of sexual orientation. In Oregon, judgment has been finalized against Sweet Cakes by Melissa, requiring Aaron and Melissa Klein to pay a $135,000 fine for refusing service to a same-sex couple. Meanwhile, in Colorado, Jack Phillips of Masterpiece Cakeshop, is appealing the ruling against him for refusing to serve a same-sex couple. In the wake of the Supreme Court’s ruling in Obergefell v. Hodges, conservatives are eager to highlight Phillips and the Kleins as evidence that religious freedom is under attack. In fact, they have actually invented a new Claim about how these bakers’ “free speech” is under attack and how they’re thus the real victims. There's a simple solution. Since they won't agree to the conditions for having a license to do business with the public, they shouldn't have a license to do business with the public! This is not a free speech issue, it is an issue of American law! They can speak about their bigotry and ignorance, not to practice it! 2.03584 127.24 RUB 2015-07-14T07:03:04-07:00 2015-07-16T07:03:04-07:00
608 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 597 65 https://www.facebook.com/LGBT-United-839497472793277/ Why do people hate each other? That's an enormous question, and it's one that eludes an answer. Why there's so rarely we see acceptance, understanding, tolerance towards people who are different from "normal" in any way? I hope that someday all the hatred, all the xenophobia and prejudice between us will ceased to exist. And I'm so grateful for my fabulous loving friends who I have shared so much brilliant times! #glbt #gaypride #friendship #queerquote 2.8137600000000003 175.86 RUB 2015-07-15T08:16:13-07:00 2015-07-16T08:16:13-07:00
611 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 612 93 https://www.facebook.com/LGBT-United-839497472793277/ The first male couple to be married at West Point Military Academy was attacked on 2 August in NYC’s SoHo neighborhood. Some guy screamed anti-gay obscenities at Daniel and Larry Lennox-Choate and then attempted sucker—punching Danny. But our guys handled the situation and tossed him in the street, like the loser he is! As Danny and Larry wrote in 3 FB post, “He left covered in his own blood with his tail between his legs. Damn right! Gay people are not cowards or sissies! I think this is how most (if not all) stories of queer guys and gals being attacked should end. I so hate it when gay are the ones who have being killed, maimed or badly beaten. We welcome people with an outstretched hand, when they come in peace, and with our clenched fists, when they Choose to wage war against us! #homophobia #gayisokay #samesexmarriage #Iovewins #equality 3.17968 198.73 RUB 2015-08-06T07:42:24-07:00 2015-08-08T07:42:24-07:00
612 location:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 661 104 https://www.facebook.com/LGBT-United-839497472793277/ We are not here to entertain straight people. They can stare all they want. But please stop asking these stupid questions about "lesbian relationships"!! We don’t think of ourselves as a “lesbian couple”, so pleas stop saying that. We think of ourselves as a “couple”, and like any other, we are a couple who is madly in love and who doesn’t want to hide that love in order to make other people feel more comfortable. Oh you'd like to join because you've seen a lot of adult videos with "lesbians"? You think our deeply emotional, fully satisfying-on-all-levels relationship is just an act, a make-out for you to watch? For you to join us in our bedroom? No, no and NO. #lesbian #loveislove #straight #stereotypes 1.2695999999999998 79.35 RUB 2015-08-24T08:28:43-07:00 2015-08-25T08:28:42-07:00
613 location:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 1185 153 https://www.facebook.com/LGBT-United-839497472793277/ Stop the hate! Don’t be stupid. don’t hate what you don’t understand! 4.78224 298.89 RUB 2015-09-09T07:21:21-07:00 2015-09-10T07:21:21-07:00
614 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 22805 2341 https://www.facebook.com/LGBT—United—839497472793277/ Discrimination runs rampant in too many people in this country - and it comes in too many forms. Ok! ljust noticed one interesting thing... The kids that need foster care come from heterosexual families. So I think the straights should be banned from being foster parents! A Kansas Department of Children and Families official said that the state will continue to allow qualified single adults to serve as foster parents for abused and neglected Children, but she said her agency isn’t ready to say whether it will allow married same-sex couples to do so. Oh God... Just because your gay doesn't make you any less of a human or any less deserving of any right afforded to anyone else! Anyone who believes that a gay person is below a straight person needs treatment! It is time for this freaking discrimination to end! They have no valid reasons for denying married gays from adopting and fostering kids. All they are doing is denying kids loving homes because of their own bigotry. 27.2 1700.00 RUB 2015-08-04T06:19:55-07:00 2015-08-08T13:19:00-07:00
615 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 585 72 https://www.facebook.com/LGBT-United-839497472793277/ That's really cool! I think all people must realise that sexuality is not, fundamentally, about who you want to have sex with — but who you are, and who you love... One of the execs on Children’s cartoon series Steven Universe has confirmed a lesbian romance between two Characters. The popular show is based on a young boy named Steven, who grows up with three magical aliens — the ‘Crystal Gems’ Garnet, Amethyst and Pearl. The show, which has already won praise for including a number of strong, female Characters in a comparatively male-dominated genre, has now hinted at further diversity. That's 3000 nice! More and more shows go that route, even if it's probably just for advertising it's still good. 2.35632 147.27 RUB 2015-07-22T07:45:34-07:00 2015-07-24T07:45:33-07:00
616 location:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 848 54 https://www.facebook.com/LGBT-United-839497472793277/ You can color your own Bernie Hero! There is a new coloring book calling "Buff Bernie: A coloring Book for Berniacs" is full of very attractive doodles of Bernie Sanders in muscle poses. The author of the book said that she wanted people to stop taking this whole thing too serious. The coloring is something that suits for all people. I totally agree with her! I’ve recently heard some hateful comments from the Hillary supporters about Bernie Sanders and his supporters, so I really love the idea of this color book. I think that Bernie would love it! 1.7838399999999999 111.49 RUB 2016-03-24T00:07:21-07:00 2016-03-25T00:07:21-07:00
622 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 219 29 https://www.facebook.com/LGBT-United-839497472793277/ “...the man of my dreams is a girl.” ? Julie Anne Peters #Iesbian #queerquote #dream 1.32576 82.86 RUB 2015-08-06T07:43:06-07:00 2015-08-07T07:43:05-07:00
623 location:united_states:Kansas, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 585 86 https://www.facebook.com/LGBT-United-839497472793277/ Hate does seem to be a Christian ideal.... 3rd federal court case seeks to block Mississippi LGBT law A diverse group of gay, straight and transgender people have filed the third federal court Challenge seeking to block a Mississippi law that lets Clerks Cite religious beliefs to reouse themselves from issuing marriage licenses to same- sex couples. The lawsuit filed Friday says House Bill 1523 violates the separation of Church and state by favoring “certain narrow religious beliefs that condemn same-sex couples who get married, condemn unmarried people who have sexual relations and condemn transgender people.” How many times do we have to do this? Your BELIEFS don't supersede my RIGHTSH You just want to use your religious beliefs as an excuse to deliberately harm others and have no consequences for doing so! You can believe whatever you wish, but you cannot use those beliefs to deny me my rights! 4.0 250.00 RUB 2016-06-07T05:25:12-07:00 2016-06-08T05:25:10-07:00
626 location:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 495 76 https://www.facebook.com/LGBT-United-839497472793277/ IN 2016??? Closeted minor leaguer for St Louis Cardinals quit after coach and players spoke of killing gay people Tyler Dunnington was a 28th-round pick by the St Louis Cardinals in the 2014 Major League Baseball draft and given a Chance to pursue his dream of being in the big leagues. But afterjust one season pitching for a Cardinals minor league team and performing solidly, Dunnington quit. He explains that during his playing days, he was a Closeted gay man playing in an uncomfortable environment. A particular low point came when a coach made a bragging reference to the brutal murder in Wyoming of gay college student Matthew Shepard whose death led to federal hate crime legislation in the US. And the hate goes on and on and on....You need fight back! It's a shame all those "big strong men" are afraid of what somebody does in private!! 0.91792 57.37 RUB 2016-03-24T00:08:31-07:00 2016-03-25T00:08:31-07:00
627 location:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 0 0 https://www.facebook.com/LGBT-United-839497472793277/ ??? FinallyH It took long enough! It's so strange that there are individuals and groups out there still living in the past! For the first time, LGBTQ groups included in NYC’s St. Patrick’s parade The nation’s largest St. Patrick’s Day parade kicked off Thursday in New York City, and for the first time in decades, gay activists are not decrying it as an exercise in exclusion. The first of roughly 200,000 marchers began striding up Fifth Avenue just after 11 am. in a procession of throbbing pipes and drums, smiling dignitaries and waving flags. Thank you!! Now we can come out of the Closet and show you who we are! I have a fundamental objection to creating divisions , groups , categories of Citizens. Black, white, rich, poor, nationality and gender... Just be people! 0.0 0.00 USD 2016-03-24T00:08:02-07:00 2016-03-25T00:08:02-07:00
630 location:united_states:Glendale (+10 mi) Arizona, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 14 2 https://www.facebook.com/LGBT—United—839497472793277/ HUMAN RIGHTS PHOTO CHALLENGE Despite our race, religion, gender, age, education, sexual orientation and beliefs, we are all HUMANS. In the midst of the presidential race, all what politicians dream about is money. They keep giving empty promises in order to win votes. And this is our friendly reminder for the candidates: we are the ones who elect them. We don’t deserve having problems with employment, marriage, Child birth etc... We all deserve the right to be accepted. Go for it! Clicking the “like” button is not enough. If you want to attract the candidates' attention to the fight for human rights, do the following: 1) Take a picture with Campaign (HUMAN RIGHTS) logo (state required) 2) Post it in comments within a week 3) Share with your friends For the first place $50; second place $30; third place $20 0.1248 7.80 RUB 2016-03-22T07:19:51-07:00 2016-03-23T07:19:50-07:00
633 location:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 10377 1037 https://www.facebook.com/Igbtun/ Common ? normal - Heterosexuality is not normal, it is just common - Catcalling is not normal, it is just common - Having long hair as a girl is not normal, it is just common common ? normal 16.0 1000.00 RUB 2015-09-09T07:22:45-07:00 2015-09-12T07:22:00-07:00
634 location:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 20 7 https://www.facebook.com/LGBT—United—839497472793277/ Most parents aren’t prepared for the words, “Mom, Dad. I’m gay.” For many parents first reaction probably will be “How will I ever handle this?” The answer is simple and difficult at the same time: love and acceptance will help to understand your Child’s sexuality and its meaning to you and your continued relationship with your son or daughter. Some parents feel they would have been happier not knowing about their Child’s sexuality. They look back to before they knew and recall this time as problem-free — overlooking the distance they often felt from their child during that time. Sometimes parents try to deny what is happening — by rejecting what they're hearing (“It’s just a phase; you’ll get over it”); by shutting down (“If you Choose that lifestyle, I don’t want to hear about it”); or by not registering the impact of what we’re being told (“That’s nice, dear, and what do you want for dinner?”). Such denial often prove as a traumatizing experience for LGBT Children. If you as a parent 'll pretend to forgot the truth about your child’s sexuality, you would never really know your Child. A large part of his or her life would be kept secret from you, and you would never really know the whole person. It is important to accept and understand your child’s sexuality because homosexuality and bisexuality are not a phase. While people may experiment for some time with their sexuality, someone who has reached the point of telling a parent that he or she is gay is not usually going through "a phase". On the contrary, he or she has given long and hard thought to understanding and acknowledging his or her sexual orientation. So if you’re wondering, “ls she/he sure?” the answer will almost always be “yes”! DON'T BE YOUR CHILD'S FIRST CLOSET! #Children #lgbt #momdadimgay #gayisok #oomingout #aoceptance 0.12656 7.91 RUB 2015-08-24T08:28:21-07:00 2015-08-25T08:28:21-07:00
635 location:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 12 2 https://www.facebook.com/LGBT-United-839497472793277/ ABOUT 15,500 TRANS PEOPLE ACTIVELY SERVE IN THE MILITARY. It's estimated that over 134000 American veterans are transgender. Not long ago these people were forced into hiding. As a result, many were unable treatments for their gender dysphoria, a state of emotional distress caused by how the gender someone was designated at birth conflicts with their gender identity. Coming out as transgender requires telling everyone in your life about you and enduring the consequences which often means the loss of family, lifelong friends, yourjob, and being the subject of ridicule, discrimination, and often violence. No one makes the decision easily and no one transitions unless they have to do so. Transphobio s|ur of stupid politicians like GOP presidential hopeful Mike Huckabee seeking to tremendous efforts of transgender community who are still struggle for equal rights. We know how easily bigots and fools who has power are able to reverse progressive Changes for their own benefit. We can’t let that happen! These people know what it means to be Transgender and know what it is to serve in our Armed Forces. We respect their opinion in both of these areas, especially over those of Governor Huckabee who has not experienced or accomplished either. #transgender #military #equality #transphobia #mikehackabee 0.0616 3.85 RUB 2015-08-14T08:16:53-07:00 2015-08-17T08:16:52-07:00
636 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 379 39 https://www.facebook.com/LGBT-United-839497472793277/ Oh God! Just remember: you know you're doing something right when all the bigots and racist idiots are angry with you... For decades, conservative Christians who oppose LGBT equality have singled out the federal government or secular atheists as their preferred enemy in public settings, blasting both groups for supposedly attacking “traditional marriage” or infringing on their religious liberty. Yet in the months surrounding the recent US. Supreme Court decision to legalize same-sex marriage across the country, right-wing Christians have become increasingly willing to cast blame — seemingly hypocritically — on a group they have often dismissed or outright ignored: Progressive Christians, especially those who support marriage equality. I believe religions should teach love, they must stop teaching hatred! And I noticed while progressive Christians are constantly under attack from conservative Christians, they're not the ones screaming “persecution”. They are just tired of the persecution. 1.4883199999999999 93.02 RUB 2015-07-22T07:45:15-07:00 2015-07-24T07:45:15-07:00
637 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 12 1 https://www.facebook.com/LGBT-United-839497472793277/ Oh happy day! More and more of the "morally superior" cult members tripping over their sex scandals! Former Archbishop John Neinstedt is “dumbfounded” by allegations that he frequented gay Clubs, used ” peppers,” and made sexual advances on men. Neinstedt has called homosexuality “evil” in the past, and thinks equal marriage laws are a Satanic “man-made experiment” that would harm Children. Oh, look at this! So much for humility... just another poor white Christian "victim"! His Assholiness can play dumb forjust so long before it all comes out in the open.. 0.07615999999999999 4.76 RUB 2015-07-22T05:10:05-07:00 2015-07-24T05:10:04-07:00
638 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 1675 196 https://www.facebook.com/LGBT-United-839497472793277/ CAITLYN JENNER: “TRANS PEOPLE DESERVE YOUR RESPECT” Caitlyn accepted the Arthur Ashe Courage Award at the 2015 ESPY Awards. Caitlyn is amazing! It was her first public appearance since announcing her decision to transition. And her speech brought me to tears. It was very touching and thought provoking. She spoke about her own personal experience so far as a transgender woman. But she also dedicated a significant percentage of her speech to a thoughtful and touching discussion of the vast number of issues facing the larger transgender community. In her past life Caitlyn was known worldwide as a sports hero. Today she is an American hero of a great courage. Because it takes courage to stand up and do everything she has done and is doing. #CaitlynJenner #transgender #equality #ESPY 8.21056 513.16 RUB 2015-07-16T07:29:56-07:00 2015-07-17T07:29:55-07:00
639 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 3274 464 https://www.facebook.com/LGBT-United-839497472793277/ SOLDIER SHANE. Recently Pentagon confirmed plan to lift ban on transgender military service. Let’s meet the big player in repealing the ban. Sergeant Shane Ortega, 28, doesn't stand out or appear out of the ordinary among his fellow Army soldiers. But there's one thing that differs him from the bulk of troops. Shane is the first openly trans soldier of the US Army. He’s astonishingly handsome, he works out constantly (Check out his muscular build), he covered in tattoos, he's part black, Latino and Cherokee, he's obsessed with his girlfriend (a former model and aspiring doctor); and he gets giddy talking about both video games and shopping wood in Alaska. Yet despite his solid performance and commitment to serve, SGT Ortega has been at risk of getting kicked out of the Army because in official Army paperwork, he is identified as a woman. But the real warriors never surrender! Ortega struggled for the equal rights for the transgender people in the military. And he succeeded! America's military progressing s|ow|y towards inclusion and equal opportunity. Let’s hope that these changes“ ensure peace, instead of waging more war. #Igbt #transgender #equality #usarmy #Ortega 8.0 500.00 RUB 2015-07-16T01:46:23-07:00 2015-07-17T01:46:23-07:00
640 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 865 91 https://www.facebook.com/LGBT-United-839497472793277/ Dykes On Bikes birthday is in July! Dykes on bikes is a Chartered lesbian motorcycle Club with 22 Chapters and numerous affiliations, founded back in 1976. They are known for their participation in gay pride events such as Pride parades, and significant LGBT events like the international Gay Games. Dykes on Bikes have been leading marches such as Gay pride parades, Gay Games events and protests. The Dyke March events are generally non-commercial, often in sharp contrast to corporate-sponsored pride events, and are usually inclusive of lesbian, bi, and trans women. Leading pride parades around the world from San Francisco to Melbourne, Paris, London, Tokyo, Toronto, Vancouver, Sydney,Zurich, Tel Aviv, you name it! #DykesOnBikes #DOB #Iesbian #dyke #Igbt #prideparade 4.7988800000000005 299.93 RUB 2015-07-16T01:45:49-07:00 2015-07-17T01:45:49-07:00
641 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 1469 194 https://www.facebook.com/LGBT-United-839497472793277/ FEMALE SOCCER PLAYERS GET MARRIED, HAVE PERFECT MESSAGE FOR HATERS! Meet professional soccer players Erin McLeod and Ella Masar, who play for Houston Dash in the National Women's Soccer League. The long-time partners married this week, just days after the end of the Women's World Cup. Along with sincere congratulations, the couple also received plenty of negative messages, from people who didn't think two women should get married. Masar had this perfect message for those people. In spite of all their hatred her message is full of love because love wins despite any obstacles! "Thank you for praying for me and reinforcing my own prayers because as you pray, "Lord please help Ella, allow her to see her sin for loving that woman, for respecting her, being faithful, honoring her, etc Know I am saying the same thing, "my Heavenly Father, thank you for allowing me find my better half, for finding someone that strengthens my faith and allows me to be the person I always imagined. Thank you for teaching me what truly loving someone and others is all about, amen." Congratulations, you two! We hope you both have a full and wonderful life together! #lgbt #lovewihs #MarriageEquality #lesbians 4.59744 287.34 RUB 2015-07-15T08:27:06-07:00 2015-07-16T08:27:05-07:00
642 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 1563 266 https://www.facebook.com/LGBT-United-839497472793277/ Miley Cyrus Wants to Marry Her Girlfriend Stella Maxwell The 22-year-old Bangerz singer and 24-year-old Victoria's Secret model Stella Maxwell have reportedly been dating since they met on Instagram in April. While it's only been a few months, they're ready to take the next step. Miley's told friends that Stella is the one. And she wants to make a huge statement with an over—the-top wedding in the fall! She can't stop talking about how in love she is and how she wants the whole world to know... Miley came out as bisexual recently, not all of her relationships have been “straight, heterosexual” ones. She also told Paper magazine how she came out to her mom when she was 14, saying, "I remember telling her I admire women in a different way. And she asked me what that meant. And I said, 'I love them. I love them like I love boys."' We hope Miley can move on from the wrecking balls and think about wedding bells once she's ready! 3.06944 191.84 RUB 2015-07-14T07:03:24-07:00 2015-07-16T07:03:24-07:00
643 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 2109 229 https://www.facebook.com/LGBT-United-839497472793277/ Please... STOP DISCRIMINATION AGAINST HOMOSEXUAL TEACHERSH After eight years on the job, Margie V\finters was fired as director of religious education at Waldron Mercy Academy outside Philadelphia not because she just married her wife, but because some parents just found out that she’s been married for all eight years. Unfortunately LGBT teachers have long understood that openly expressing their identity in school can make them an easy target for discrimination. It is the biggest mistake! When students perceive that they’re not supposed to talk about homosexuality, they conclude that there must be something wrong about being gay. And it’s a dangerous message that can lead to bullying and harassment. Gay teachers need to serve as example for kids! It’s very powerful both for straight students and for LGBT students to know that they have teachers and people they respect who are LGBT and who are good at theirjobs. It’s important for all students to see that nothing to be ashamed! And it must be illegal for employers to discriminate against employees based on their actual or perceived sexual orientation! 9.6 600.00 RUB 2015-07-10T05:36:04-07:00 2015-07-11T05:36:03-07:00
644 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 3359 421 https://www.facebook.com/LGBT-United-839497472793277/ When this triumphant yearbook entry was published 8.0 500.00 RUB 2015-07-09T07:00:23-07:00 2015-07-11T07:00:00-07:00
645 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 1927 443 https://www.facebook.com/LGBT-United-839497472793277/ BACK IN LOVE! CAITLYN JENNER REPORTEDLY DATING FELLOW TRANSGENDER WOMAN CANDIS CAYNE It looks like 65-year-old reality TV star Caitlyn Jenner has found love again. After getting divorced from Kris Jenner earlier this year, Caitlyn has not been linked with any love interest. According to reports, she is now dating Candis Cayne, 44, an actress and a fellow transgender woman. Caitlyn and Candis had amazing Chemistry. After her monumental life Change, Caitlyn’s ready to open up her heart again and really, how could you ask for a more perfect fit as a romantic partner than Candis? She’s been basically through the same struggles and confusion, so she’d be the perfect person for Caitlyn to lean on as she continues herjourney of transition. Candis is smart, funny, talented and drop-dead sexy! 6.4 400.00 RUB 2015-07-10T05:34:53-07:00 2015-07-11T05:34:52-07:00
646 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 1400 156 https://www.facebook.com/LGBT-United-839497472793277/ This man is great example of human filth and liesll Rape Childrehl?! Really?! Are you nuts?! Louisiana Justice Refuses To Obey Supreme Court, Writes Opinion Implying Gay People Rape Their Children Raising children and starting a family is something that all people look forward to in life! We arejust people, not criminals! AND WE LOVE CHILDREN, NOT RAPEll We are all equal! It is better for Child to live with homosexual parents then to live on the street or in orphanage! Millions of children need love and they don't care if our love is different. Why should we let those children that are left on the streets be on the streets when a warm and open home are open to them?! I don't understandll 6.4 400.00 RUB 2015-07-10T05:35:23-07:00 2015-07-11T05:35:23-07:00
647 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 520 47 https://www.facebook.com/LGBT-United-839497472793277/ The greatest legacy one can pass on to one's children and grandchildren is not money or other material things accumulated in one's life, but rather a legacy of Character and faith. Love your Children and have a good day! 2.46224 153.89 RUB 2015-07-09T06:59:52-07:00 2015-07-10T06:59:51-07:00
648 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like LGBT United, people_who_match:Friends of connections: Friends of people who are connected to LGBT United 311 44 https://www.facebook.com/LGBT-United-839497472793277/ | wish all parents were like this 2.26416 141.51 RUB 2015-07-08T07:26:12-07:00 2015-07-10T07:26:00-07:00

Next page

Advanced export

JSON shape: default, array

CSV options:

CREATE VIEW display_ads AS 
        select ads.id,
            case when image is not null then
                json_object("img_src", "https://raw.githubusercontent.com/edsu/irads/03fb4b/site/" || image, "width", 200)
            else
                "no image"
            end as img,
            json_group_array(
                json_object(
                    "label", targets.name,
                    "href", "/russian-ads/display_ads?_target="
                        || urllib_quote_plus(targets.id)
                )
            ) as targeting,
            ads.impressions, ads.clicks, ads.url, ads.text,
            cast(case
                when ads.spend_currency == "RUB" then ads.spend_amount * 0.016
                else ads.spend_amount
            end as float) as spend_usd,
            ads.spend_amount, ads.spend_currency,
            ads.created, ads.ended
        from ads
            join ad_targets on ads.id = ad_targets.ad_id
            join targets on ad_targets.target_id = targets.id
        group by ads.id
        order by ads.id
Powered by Datasette · Query took 1184.977ms · Data source: simonw/russian-ira-facebook-ads-datasette