home / russian-ads

display_ads (view)

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

10 rows where an ad_target was location:united_states:Kansas

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
565 location:united_states:Kansas, age:14 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Bernie Sanders, people_who_match:interests:LGBT rights by country or territory, people_who_match:interests:Lesbian community, people_who_match:interests:LGBT community, people_who_match:interests:Hillary Clinton, people_who_match:interests:Same—sex marriage 4798 240 https://www.facebook.com/events/533144703560571/ Westboro baptist church is planning to stand against tolerance in education system near LG God H85 Bigots Rally 50.186879999999995 3136.68 RUB 2016-05-12T08:05:06-07:00 2016-05-22T07:19:00-07:00
566 location:united_states:Kansas, age:14 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Rainbow flag (LGBT movement), people_who_match:interests:LGBT rights by country or territory, people_who_match:interests:Gay Rights, people_who_match:interests:Lesbian community, people_who_match:interests:LGBT community, people_who_match:interests:LGBT Equality, people_who_match:interests:Same-sex marriage in the United States, people_who_match:interests:Same-sex marriage, people_who_match:interests:LGBT social movements 7159 318 https://www.facebook.com/events/533144703560571/ Westboro baptist church is planning to stand against tolerance in education system near LG Westboro Baptist Church counter protest 53.1184 3319.90 RUB 2016-05-16T07:50:43-07:00 2016-05-22T07:19:00-07:00
567 location:united_states:Kansas, age:14 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:LGBT community 9372 373 https://www.facebook.com/events/533144703560571/ Westboro baptist church is planning to stand against tolerance in education system near LG Westboro Baptist Church counter protest 81.11536 5069.71 RUB 2016-05-18T00:13:06-07:00 2016-05-22T07:19: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
618 location:united_states:Kansas, age:14 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Bernie Sanders, people_who_match:interests:LGBT rights by country or territory, people_who_match:interests:LGBT community, people_who_match:interests:Hillary Clinton, people_who_match:interests:Same-sex marriage 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 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! 0.0 0.00 USD 2016-05-12T08:05:04-07:00 2016-05-12T08:27:26-07:00
619 location:united_states:Kansas, age:14 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Rainbow flag (LGBT movement), people_who_match:interests:LGBT rights by country or territory, people_who_match:interests:LGBT community, people_who_match:interests:Same-sex marriage in the United States, people_who_match:interests:Same-sex marriage, people_who_match:interests:LGBT social movements 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 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! 0.0 0.00 USD 2016-05-16T07:50:40-07:00 2016-05-12T08:27:26-07:00
620 location:united_states:Kansas, age:14 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:LGBT community 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 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! 0.0 0.00 USD 2016-05-18T00:12:58-07:00 2016-05-12T08:27:26-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
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/umd-mith/irads/master/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 1261.0ms · Data source: simonw/russian-ira-facebook-ads-datasette