home / russian-ads

display_ads (view)

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

24 rows where an ad_target was interests:Homosexuality

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
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  
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
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  
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 1314.199ms · Data source: simonw/russian-ira-facebook-ads-datasette