home / russian-ads

display_ads (view)

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

36 rows where an ad_target was interests:LGBT community

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
564 location:united_states:Kansas, interests:LGBT rights by country or territory, interests:Lesbian community, interests:LGBT community, interests:Same-sex marriage, age:14 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1495 73 https://www.facebook.com/events/533144703560571/ Westboro baptist church is planning to stand against tolerance in education system near LG God H85 Bigots Rally 10.7224 670.15 RUB 2016-05-11T07:19:33-07:00 2016-05-22T07:19:00-07:00
569 location:United States, interests:LGBT community, interests:Same-sex marriage, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/LGBT-United-839497472793277/ Louis Halsey, 88, and John Spofford, 94, New York City, New York The couple married after 64 years together. ? 0.0 0.00 USD 2015-08-18T08:42:08-07:00 2015-08-20T08:42:00-07:00
580 location:United States, interests:LGBT community, interests:Homosexuality, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 122 103 https://www.facebook.com/lgbtun/ We speak for all fellow members of LGBT community across the nation. 2.07456 129.66 RUB 2015-06-16T03:36:10-07:00  
581 location:United States, interests:LGBT community, interests:Homosexuality, interests:Yoga, interests:Fitness and wellness, interests:Politics and social issues, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 1438 36 https://www.facebook.com/lgbtun/ We speak for all fellow members of LGBT community across the nation. 21.80112 1362.57 RUB 2015-06-17T03:15:18-07:00  
582 location:United States, interests:LGBT community, interests:Homosexuality, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 18891 1724 https://www.facebook.com/lgbtun/ We speak for all fellow members of LGBT community across the nation. 161.37232 10085.77 RUB 2015-06-18T00:58:48-07:00  
583 location:United States, interests:Motherhood, interests:LGBT community, interests:Indiana, interests:Homosexuality, interests:Love, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 4265 186 https://www.facebook.com/lgbtun/ We speak for all fellow members of LGBT community across the nation. 22.2968 1393.55 RUB 2015-06-22T08:19:07-07:00  
584 location:United States, interests:Motherhood, interests:Philosophy, interests:LGBT community, interests:Indiana, interests:Homosexuality, interests:Love, interests:Society, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 31618 3206 https://www.facebook.com/lgbtun/ We speak for all fellow members of LGBT community across the nation. 266.08320000000003 16630.20 RUB 2015-06-23T05:06:57-07:00  
585 location:United States, interests:Motherhood, interests:Philosophy, interests:LGBT community, interests:Indiana, interests:Homosexuality, interests:Love, interests:Society, interests:Fitness and wellness, interests:Family, interests:Photography, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 11857 1252 https://www.facebook.com/lgbtun/ We speak for all fellow members of LGBT community across the nation. 88.61184 5538.24 RUB 2015-07-01T02:55:07-07:00  
586 location:United States, interests:Motherhood, interests:Philosophy, interests:LGBT community, interests:Indiana, interests:Puppy, interests:Homosexuality, interests:Love, interests:Society, interests:Dogs, interests:Fitness and wellness, interests:Family, interests:Photography, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 1811 59 https://www.facebook.com/lgbtun/ We speak for all fellow members of LGBT community across the nation. 12.1224 757.65 RUB 2015-07-07T01:51:07-07:00  
587 location:United States, interests:LGBT community, interests:Homosexuality, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 15175 542 https://www.facebook.com/lgbtun/ We speak for all fellow members of LGBT community across the nation. 99.2272 6201.70 RUB 2015-07-09T01:50:28-07:00  
588 location:United States, interests:Gay pride, interests:LGBT community, interests:Homosexuality, interests:LGBT culture, interests:Same-sex marriage, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 175460 21449 https://www.facebook.com/lgbtun/ We speak for all fellow members of LGBT community across the nation. 1500.0700800000002 93754.38 RUB 2015-07-14T00:01:38-07:00  
589 location:United States, interests:Gay pride, interests:LGBT community, interests:Homosexuality, interests:LGBT culture, interests:Same-sex marriage, excluded_connections:Exclude people who like LGBT United, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/lgbtun/ We speak for all fellow members of LGBT community across the nation. 0.0 0.00 USD 2015-11-05T23:11:52-08:00  
590 location:United States, interests:Gay pride, interests:LGBT community, interests:Homosexuality, interests:LGBT culture, interests:Same-sex marriage, excluded_connections:Exclude people who like LGBT United, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices 67221 6566 https://www.facebook.com/lgbtun/ We speak for all fellow members of LGBT community across the nation. 751.9161600000001 46994.76 RUB 2015-11-05T23:11:58-08:00  
593 location:United States, interests:LGBT community, interests:Same-sex marriage, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 5821 677 https://www.facebook.com/LGBT-United-839497472793277/ I need a dog just like that one! 11.200000000000001 700.00 RUB 2015-08-18T06:35:47-07:00 2015-08-20T06:35:00-07:00
594 location:united_states:Glendale (+10 mi) Arizona, interests:Bisexuality, interests:Lesbian community, interests:LGBT culture, interests:LGBT community, interests:Transgenderism, interests:Human Sexuality, age:13 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 4189 679 https://www.facebook.oom/lgbtun/ ls here anyone from Glendale, Arizona? WE NEED YOU! HELP US to protect the memory of the victims of hate! Last week on Friday, May Kieu and Dorothy Dutiel, both 15-year-old sophomores at Independence High School in Glendale, each died of a single gunshot wound about 8 am. just outside the school’s cafeteria. The girls were a couple. Police are calling it a murder-suicide. This heart-breaking incident is all over the news and the comments are disgusting! Homophobes use the incident as a proof that love is a sin! This is just ignorance! Two Children died and people are grieving! How would you feel if strangers came to your neighborhood or your school to push their agenda? These people are just aggravating the situation and traumatizing other KIDS! If you live in Glendale, Arizona, please, come and support us today: 6602 N 75th Ave,Glendale, AZ 85303. LET'S STAND UP AGAINST BIGOTRY! If you are not from Glendale, please, SHARE this post! Let people know we support them! P.S. please, send us photos from the event. 13.70064 856.29 RUB 2016-02-18T06:40:45-08:00 2016-02-19T06:40:45-08:00
596 location:United States, interests:LGBT community, interests:Same-sex marriage, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 331 41 https://www.facebook.com/LGBT-United-839497472793277/ THE US ARMY HAS PUNISHED CHELSEA MANNING for possessing books and magazines having to do with LGBTQ and political issues. They accused her of misconduct for having an expired tube of toothpaste and for brushing food off the table. They placed her in a solitary confinement — a torturous, extremely distressing experience. The whole cruel, corrupted system is against her. It looks like military prosecutors view Manning in a way that means she must be “broken” or forcefully assimilated because of her crime —first, because she exposed the government’s crimes, and government really doesn’t like it, and second, because she’s trans. Their goal is to see that Manning is as dehumanized as possible, but it's Clear who the real non-humans are. Someone has gone to great lengths to paint Chelsea as a deceitful and psychotic Character. But how many of those punishing Manning should themselves be in a psych ward? Transphobia is a one ugly thing. So sad when heroes like Chelsea Manning forced to suffer, to undergo injustice and humiliation, even though they had been through enough already! Free Chelsea Manning you sadistic creeps!! #ChelseaManning #FreeCheIsea #transphobia #LGBT #transgender #PrideHeroes 1.59984 99.99 RUB 2015-08-21T07:50:13-07:00 2015-08-22T07:50:12-07:00
598 location:United States, interests:LGBT community, interests:Same-sex marriage, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1597 193 https://www.facebook.com/LGBT-United-839497472793277/ Wonder Woman comes from an island populated exclusively by women, so there’s no doubt in our minds she is a supporter of the LGBT community. And of course this world always need an amazing power of woman’s touch :-) Isn’t it just amazing? Wonder Woman presides over the wedding of two brides in Sensation Comics Featuring Wonder Woman, Chapter 48 written and illustrated by Jason Badower. Badower said he also really wanted to reference current affairs in the story - specifically, legalization of same-sex marriage nationwide. "I saw this Wonder Woman story as an incredible opportunity to have one of the most recognizable, iconic Characters in the world to be among the first to step forward and officially endorse this new law," he said. "I thought, let's not just have Wonder Woman embrace this new law, let's have her celebrate it." Some may ask — why is it so important when superheroes depicted as supporters of marriage equality? Because it is a massive, land-mark milestone in LBGTQ rights history. Because the fight to get to normal was so difficult, and because the fight to Change normal is still ongoing. Just like Wonder Woman using her superpowers to struggle with violence and injustice of the world! :-) #wonderwoman #superheroes #marriageequality #gaymarriage #Iesbian 8.3104 519.40 RUB 2015-08-20T08:40:38-07:00 2015-08-21T08:40:37-07:00
604 location:United States, interests:LGBT community, interests:Same-sex marriage, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 13819 1521 https://www.facebook.com/LGBT-United-839497472793277/ "My mom blames California for me being a lesbian. "Everything was fine until you moved out there." "That's right, Mom, we have mandatory lesbianism in West Hollywood. The Gay Patrol busted me, and I was given seven business days to add a significant amount of flannel to my wardrobe!" ~quote by Coley Sohn #Iesbian #queerhumor #queerquote #Coleysohn 13.24416 827.76 RUB 2015-08-21T07:56:45-07:00 2015-08-25T07:56:00-07:00
606 location:United States, interests:LGBT community, interests:Homosexuality, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1732 178 https://www.facebook.com/LGBT-United-839497472793277/ An openly gay Cuban American poet will take part in Friday’s ceremony at the US. Embassy in Cuba where the American flag will be raised. The ceremony will mark the official reopening of the US. embassy along Havana’s oceanfront promenade that overlooks the Florida Straits. ‘My inspiration is thinking about 90 miles separating the two countries and the two people, 90 miles is the sea between us.’ Just 90 miles, but at the same time it is a vast schism that separates the United States from Cuba. The poet added he hopes there’s still possible to achieve “healing” between the two countries. ‘This very moment, the negotiation of cultural identities...This just seems so surreal sti||...This is really in some sense just the beginning, the dawn of new things to come.’ It would be so great if it will be indeed a new hope and a new day for Cuba, country which is still struggling to recover from severe embargo, country abused by wars. Sadly, the United States participated and initiated many of these conflicts... And there’s more - severe economic crisis, socialist dictatorship of Cuban leaders. It’s time for us to lend a helping hand. #RichardBlanco #Cuba #ForeignRelations #gay #queerart 9.6 600.00 RUB 2015-08-14T08:16:35-07:00 2015-08-16T08:16:34-07:00
609 location:United States, interests:LGBT community, interests:Homosexuality, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 4047 537 https://www.facebook.com/LGBT-United-839497472793277/ Do you seriously believe God will judge someone for loving a person of same sex, but will not judge you for hating someone you have never met? A Kentucky Clerk who defied a federal judge's order to issue marriage licenses and turned away four gay couples has until Monday to convince the judge to delay his mandate. US. District Judge David L. Bunning rejected Rowan County Clerk Kim Davis' Claim that her Christian faith should exempt her from issuing marriage licenses to same-sex couples and ordered her on Wednesday to hand out the licenses. But her office kept denying them. Interesting what would happen if I walked up to my boss and said I refuse to the job I am being paid for today? Let me think... guess I would stand in the unemployment line! Herjob is not to participate in gay weddings!! All she has to do is confirm that the paperwork is correct! She should be fired, fined and Charged with contem pt of court! 12.8 800.00 RUB 2015-08-14T08:16:10-07:00 2015-08-16T08:16:09-07:00
610 location:United States, interests:LGBT community, interests:Homosexuality, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 3074 445 https://www.facebook.com/LGBT-United-839497472793277/ On the first anniversary of Robin Williams’ death, I want to remember his most influential LGBT roles throughout his acting career. The 63-year-old comedian, who had struggled with depression, died by suicide on August 11 2014. His widow Susan Schneider said at the time of his death: “As he is remembered, it is our hope the focus will not be on Robin’s death, but on the countless moments ofjoy and laughter he gave to millions.” Even at home, Williams exhibited acceptance for the LGBT community with his trademark playfulness. While he denied rumours about being gay, he had no qualms about discussing the sexuality of his pet pug. He said: “I also have a gay rescue pug called Leonard. He has a boyfriend and they are planning to adopt a Siamese kitten together. We’re very modern.” When the Westboro Baptist announced its intentions to picket his funeral, pro- LGBT organisation Planting Peace raised over $40,000 for St. Jude Children’s Research Hospital — one of Williams’ favourite Charities. Robin Williams played many different roles in so many people’s lives, and giving back to others was at the top of that list... We will never forget you. And we'll always love you... 7.9489600000000005 496.81 RUB 2015-08-12T07:34:46-07:00 2015-08-14T07:34:46-07:00
617 location:united_states:Kansas, interests:LGBT rights by country or territory, interests:LGBT community, interests:Same-sex marriage, age:14 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 20810 1989 https://www.facebook.com/LGBT-United-839497472793277/ Well, as you know, schools are places of learning and also miniature societies. The school Climate has a direct impact on both how well students learn and how well they interact with other people. More and more teachers today understand the importance of socialization and try to make their Classes more friendly where each student feels involved. But despite these efforts, students who are LGBT continue to face a harsh reality.... May 24,25 Westboro baptist Church is planning to stand against tolerance in education system near LGBT-friendly Lawrence High School. They want to "remind this nation that the parents, students, teachers and staff of the high schools celebrate disobedience to God's law." They are just inciting hate riots and violence! Their right to protest infringes on others rights! Personally I have had enough of those idiots. Someone should picket them (in return)!! Any volunteers willing to help me drown out their voices of hatred? Please, DM us for more information and we can stop their nonsense - to put them on the right way! 117.21648 7326.03 RUB 2016-05-06T08:27:27-07:00 2016-05-12T08:27:26-07:00
624 no image location:united_states:Kansas, interests:LGBT rights by country or territory, interests:LGBT community, interests:Same-sex marriage, age:14 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/LGBT-United-839497472793277/ Well, as you know, schools are places of learning and also miniature societies. The school Climate has a direct impact on both how well students learn and how well they interact with other people. More and more teachers today understand the importance of socialization and try to make their Classes more friendly where each student feels involved. But despite these efforts, students who are LGBT continue to face a harsh reality.... May 24,25 Westboro baptist Church is planning to stand against tolerance in education system near LGBT-friendly Lawrence High School. They want to "remind this nation that the parents, students, teachers and staff of the high schools celebrate disobedience to God's law." They are just inciting hate riots and violence! Their right to protest infringes on others rights! Personally I have had enough of those assholes. Someone should picket them (in return)!! Any volunteers willing to help me drown out their voices of hatred? Please, DM us for more information and we can stop their nonsense - to put them on the right way! 0.0 0.00 USD 2016-05-06T07:58:41-07:00 2016-05-09T07:58:41-07:00
628 location:United States, interests:Lesbian community, interests:LGBT community, interests:Same—sex marriage, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 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 0.0 0.00 USD 2016-03-23T05:38:23-07:00 2016-03-24T05:38:22-07:00
631 location:united_states:Glendale (+10 mi) Arizona, interests:Bisexuality, interests:Lesbian community, interests:LGBT culture, interests:LGBT community, interests:Transgenderism, interests:Human Sexuality, age:13 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.oom/lgbtun/ ls here anyone from Glendale, Arizona? WE NEED YOU! HELP US to protect the memory of the victims of hate! Last week on Friday, May Kieu and Dorothy Dutiel, both 15-year-old sophomores at Independence High School in Glendale, each died of a single gunshot wound about 8 am. just outside the school’s cafeteria. The girls were a couple. Police are calling it a murder-suicide. This heart-breaking incident is all over the news and the comments are disgusting! Homophobes use the incident as a proof that homo love is a sin! This is just ignorance! Two Children died and people are grieving! How would you feel if strangers came to your neighborhood or your school to push their agenda? These assholes are just aggravating the situation and traumatizing other KIDS! If you live in Glendale, Arizona, please, come and support us today: 6602 N 75th Ave,Glendale, AZ 85303. LET'S STAND UP AGAINST BIGOTRY! If you are not from Glendale, please, SHARE this post! Let people know we support them! P.S. please, send us photos from the event. 0.0 0.00 USD 2018-02-18T05:41:28-08:00 2016-02-18T12:41:00-08:00
668 location:United States, interests:LGBT community, interests:Homosexuality, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/LGBT-United-839497472793277/ We speak for all fellow members of LGBT community across the nation. 0.0 0.00 USD 2015-06-16T03:36:09-07:00  
669 location:United States, interests:LGBT community, interests:Homosexuality, interests:Yoga, interests:Fitness and wellness, interests:Politics and social issues, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 1997 91 https://www.facebook.com/LGBT-United-839497472793277/ We speak for all fellow members of LGBT community across the nation. 42.78304 2673.94 RUB 2015-06-17T03:15:18-07:00  
670 location:United States, interests:LGBT community, interests:Homosexuality, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/LGBT-United-839497472793277/ We speak for all fellow members of LGBT community across the nation. 0.0 0.00 USD 2015-06-18T00:58:48-07:00  
671 location:United States, interests:LGBT community, interests:Homosexuality, interests:Yoga, interests:Fitness and wellness, interests:Politics and social issues, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/LGBT-United-839497472793277/ New LGBT community. Everyday news, updates, coming outs and much more! 0.0 0.00 USD 2015-06-18T00:57:19-07:00  
672 location:United States, interests:LGBT community, interests:Homosexuality, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 115 12 https://www.facebook.com/LGBT-United-839497472793277/ New LGBT community. Everyday news, updates, coming outs and much more! 3.3000000000000003 206.25 RUB 2015-06-18T00:58:48-07:00  
673 location:United States, interests:Motherhood, interests:LGBT community, interests:Indiana, interests:Homosexuality, interests:Love, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/LGBT-United-839497472793277/ We speak for all fellow members of LGBT community across the nation. Gender preference does not define you. Your spirit defines you. 0.0 0.00 USD 2015-06-22T08:19:07-07:00  
674 location:United States, interests:LGBT community, interests:Homosexuality, interests:Yoga, interests:Fitness and wellness, interests:Politics and social issues, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/LGBT-United-839497472793277/ Everyday news, updates, coming outs and much more! United we stand! 0.0 0.00 USD 2015-06-18T00:57:58-07:00  
675 location:United States, interests:LGBT community, interests:Homosexuality, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 59 4 https://www.facebook.com/LGBT-United-839497472793277/ Everyday news, updates, coming outs and much more! United we stand! 1.6440000000000001 102.75 RUB 2015-06-18T00:58:48-07:00  
676 location:United States, interests:Motherhood, interests:LGBT community, interests:Indiana, interests:Homosexuality, interests:Love, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/LGBT-United-839497472793277/ We speak for all fellow members of LGBT community across the nation. Gender preference does not define you. Your spirit defines you. 0.0 0.00 USD 2015-06-22T08:19:07-07:00  
2436 location:United States, interests:Liberalism, interests:LGBT community, interests:Libertarianism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1451 187 https://www.facebook.com/Born-LiberaI-522628564598423/ LGBT community is suffering from haters and especially hate religious groups! These crazy thugs should be jailed for life! Crystal Raquel Cash, 55, cannot speak but is alive after being shot nearly point blank in the face by a member of Christian hate group. The attacker, Gerald Duane Lewis, 26, and his wife reportedly are members of the Israel United in Church, which the Southern Poverty Law Center listed as a hate group last year. According to the newspapers, Lewis was wearing a shirt from the Church when he opened fire, shouting a homophobic slur. The government must pay more attention to assaults on sexual minorities because this is the threat to the country’s internal security! 8.0 500.00 RUB 2016-07-21T09:35:45-07:00 2016-07-22T09:35:42-07:00
3394 location:United States, interests:Motherhood, interests:LGBT community, interests:Indiana, interests:Homosexuality, interests:Love, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/LGBT-United-839497472793277/ We speak for all fellow members of LGBT community across the nation. Gender preference does not define you. Your spirit defines you. 0.0 0.00 USD 2015-06-22T08:19:07-07:00  

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 1346.294ms · Data source: simonw/russian-ira-facebook-ads-datasette