home / russian-ads

display_ads (view)

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

4 rows where an ad_target was location:united_states:Glendale (+10 mi) Arizona

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
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
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
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
632 location:united_states:Glendale (+10 mi) Arizona, age:13 - 50, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Bisexuality, people_who_match:interests:Lesbian community, people_who_match:interests:LGBT culture, people_who_match:interests:LGBT community, people_who_match:interests:Transgenderism, people_who_match:interests:Human Sexuality 0 0 https://www.facebook.com/Igbtun/ 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—suioide. 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,GIendaIe, 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 2016-02-18T05:42:24-08:00 2016-02-18T12:41:00-08: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 1302.124ms · Data source: simonw/russian-ira-facebook-ads-datasette