home / russian-ads

display_ads (view)

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

10 rows where an ad_target was interests:African—American history

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
775 location:United States, interests:Martin Luther King, interests:Jr., interests:Police Brutality is a Crime, interests:African-American culture, interests:African—American Civil Rights Movement (1954—68), interests:African—American history, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Malcolm X, interests:Union of Huffington Post Writers and Bloggers, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 12624 2096 https://www.facebook.com/WiIliamsKalvin-788980617892144/ Have you ever noticed that?! 4.770560000000001 298.16 RUB 2016-11-01T06:07:42-07:00  
1071 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:African-American culture, interests:African—American Civil Rights Movement (1954—68), interests:African—American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Black (Color), age:16 - 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/BIacktivist-128371547505950/ Dear cop, please stop using our children for publicity stunts. 0.0 0.00 USD 2016-10-20T07:48:37-07:00 2016-10-21T07:48:36-07:00
1176 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:African-American culture, interests:African—American Civil Rights Movement (1954—68), interests:African—American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 17968 2305 https://www.facebook.com/BIacktivist-128371547505950/ Share this image, because it will never make it to the mainstream media. 6.4 400.00 RUB 2016-10-18T06:43:38-07:00 2016-10-19T06:43:37-07:00
2518 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African—American history, interests:Black Consciousness Movement, interests:Malcolm X, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 3739 505 https://www.facebook.com/blackmattersus.mvmnt/ More and more unarmed black people are killed by police. And the cases of abuse and excessive force are simply swept under the rug. #ThatsWhyWeProtest https://www.facebook.comlevents/662307087278604/ 6.4 400.00 RUB 2016-10-21T08:42:24-07:00 2016-10-24T05:34:53-07:00
2543 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African—American history, interests:Black Consciousness Movement, interests:Malcolm X, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 5677 755 https://www.facebook.com/blackmattersus.mvmnt/ These girls did a very good job for Halloween. 4.4896 280.60 RUB 2016-11-01T08:02:57-07:00 2016-11-02T08:02:56-07:00
3106 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African—American history, interests:Black Consciousness Movement, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 9675 1761 https://www.facebook.com/Woke-B|acks-294234600956431/   6.4 400.00 RUB 2017-04-13T07:04:15-07:00 2017-04-14T07:04:15-07:00
3152 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African—American history, interests:Black Consciousness Movement, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 344 51 https://www.facebook.com/Woke-B|acks-294234600956431/ "You don't have to be a man to fight for freedom. All you have to do is to be an intelligent human being." - Malcolm X ?? #melaninqueen #dope #beautiful #wakeup #wewillsurvive #organize #VWISims #joshuabeal #altonsterling #TerenceCrutcher #westandtogether #blacklivesmatter #unite4justice #november8 #election52016 #black #melanin #blackisbeautiful #blacklivesmatter #blackgirlmagic #USA #blackandproud #democrat #republican #Africanamerican #unite4justice #vote #breakingnews 0.36048 22.53 RUB 2016-12-09T06:06:21-08:00 2016-12-10T06:06:21-08:00
3154 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African—American history, interests:Black Consciousness Movement, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, interest_expansion:On 809 63 https://www.facebook.com/Woke-Blacks-294234600956431/ These little ones are always watching and learning. The love of a mother and the supernatural connection between our Melanin Queens and their kids cannot be overlooked. Team Melanin. Tag your Mum 0r Queen 1.6 100.00 RUB 2016-12-01T07:48:44-08:00 2016-12-02T07:48:44-08:00
3173 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African—American history, interests:Black Consciousness Movement, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 6981 749 https://www.facebook.com/Woke-B|acks-294234600956431/ We give too many people the power to lower our positive Black vibrations. We shouldn't give in, rather stand true to our own frequency. #melaninqueen #dope #beautiful #wakeup #wewillsurvive #organize #VWISims #joshuabeal #altonsterling #TerenceCrutcher #westandtogether #blacklivesmatter #unite4justice #november8 #elections2016 #black #melanin #blackisbeautiful #blacklivesmatter #blackgirlmagic #USA #blackandproud #democrat #republican #Africanamerican #unite4justice #vote #breakingnews 4.8 300.00 RUB 2016-12-09T06:07:22-08:00 2016-12-10T06:07:22-08:00
3230 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:BLACK BUSINESS GLOBAL, interests:Black Business Works, interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African—American history, interests:Black Business Builders Club, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:Instagram Feed, placements:News Feed on mobile devices 738 11 http://b|ack4black.info/2017/01/18/usefuI—apps—for—entrepreneurs/ Pay attention to these useful apps that will help you run your business. For business owners Use it Useful Apps For Entrepreneurs 2017-01-182017-01-18_0 Comment for small business owners, useful apps Pay attention to these useful apps that will help you run your business. In an age when business is conducted on the go, and outside the office, it is essentia... Useful Apps For Entrepreneurs — BIack4BIaok black4black.info 5.86624 366.64 RUB 2017-01-24T01:04:52-08:00 2017-01-25T01:04:52-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 1286.699ms · Data source: simonw/russian-ira-facebook-ads-datasette