home / russian-ads

display_ads (view)

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

11 rows where an ad_target was interests:Same-sex marriage

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
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
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
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

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