home / russian-ads

display_ads (view)

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

10 rows where an ad_target was people_who_match:multicultural_affinity:African American (US)

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
77 location:United States, friends_of_connections:Friends of people who are connected to Black Matters, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices, people_who_match:multicultural_affinity:African American (US), and_must_also_match:interests:Black Tea Patriots, and_must_also_match:interests:Black Knowledge, and_must_also_match:interests:BIackNews.com, and_must_also_match:interests:HuffPost Black Voices 0 0 https://b|ackmattersus.com/ Black Community! We finally made a website! News about black racial and social issues. Get breaking news and analysis on the life of African American community in the US. Black Matters Hillary Doesn’t Deserve Black Votes Young black voters give up on Mrs. Clinton Outraged Flint Resident: “Lawsuit Must Be Filed Against State!” Flint Water Crisis touched the feelings of all Americans and the whole world. Justice For Aiyana Jones Rally The tragic death of Aiyana Jones, a 7-year-old African-American fatally shot by a Detroit police officer 4 Officers, Who Shot Jeremy McDole, Won’t Face State Charges, Family Protests In Wilmington Friday The tragic alleged murder of Jeremy McDole happened last September after he had been “robbed and shot by an unknown robber,” Black Matters 0.0 0.00 USD 2016-06-16T01:21:05-07:00  
97 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices, people_who_match:multicultural_affinity:African American (US) 74257 2603 https://blackmattersus.com/ Get breaking news and analysis on the life of African American community in the US. Black Matters Black Matters This Is What Being “Confident In Ones Blackness” Means To Some White Conservatives Black Matters Life Expectancy For Black Americans Increase Black Matters Police Brutality Videos Change How Black Men Live Black Matters 83.8656 5241.60 RUB 2016-05-10T07:26:47-07:00  
188 no image location:united_states:New York New York, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:multicultural_affinity:African American (US) 10016 283 https://www.facebook.com/blackmattersus/ ATTENTION, NEWYORK! Join the We need your support! We'll provide you with free food and coffee. Come and bring your friends! Join the FB event for more details: 23.9312 1495.70 RUB 2016-02-18T05:57:41-08:00 2016-02-19T05:46:31-08:00
1080 location:united_states:Buffalo (+50 mi) New York, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:multicultural_affinity:African American (US) 14908 538 https://www.facebook.com/events/1707140032898957/ Show up, fight racism and take a stand for equality. Monday, May 2 at 4 PM at Erie County Holding Center Justice For India: Not 1 More! 72.33216 4520.76 RUB 2016-04-22T02:32:26-07:00  
1081 location:united_states:Buffalo (+50 mi) New York, age:18 - 53, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:multicultural_affinity:African American (US) 18272 606 https://www.facebook.com/events/1707140032898957/ Show up, fight racism and take a stand for equality. Monday, May 2 at 4 PM at Erie County Holding Center Justice For India: Not 1 More! 115.28944 7205.59 RUB 2016-04-25T03:34:54-07:00  
1085 location_living_in:united_states:Buffalo (+14 mi) New York, age:18 - 50, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:multicultural_affinity:African American (US) 4011 288 https://www.facebook.com/events/1707140032898957/ Show up, fight racism and take a stand for equality. Monday, May 2 at 4 PM at Erie County Holding Center Justice For India: Not 1 More! 17.317439999999998 1082.34 RUB 2016-04-21T06:52:37-07:00 2016-04-28T06:52:36-07:00
1091 location:united_states:Baltimore (+25 mi) Maryland, age:16 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:multicultural_affinity:African American (US) 0 0 https://www.facebook.com/BIacktivist-128371547505950/ Go well beyond profiling 0.0 0.00 USD 2016-05-11T05:07:07-07:00 2016-05-15T07:00:01-07:00
1233 location:united_states:Rochester (+50 mi) New York, age:16 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:multicultural_affinity:African American (US) 14 2     0.04496 2.81 RUB 2016-05-16T08:26:53-07:00 2016-05-19T08:15:33-07:00
1236 location:united_states:Baltimore (+25 mi) Maryland, age:16 — 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:multicultural_affinity:African American (US) 3 0 https://www.facebook.com/Blacktivist-128371547505950/ White people do not want to be killed and terrorized by police neither do blacks. This is called injustice. 0.01184 0.74 RUB 2016-05-11T05:00:55-07:00 2016-05-12T05:00:54-07:00
1796 location:United States, age:13 - 50, language:English (US), placements:Instagram Feed, people_who_match:multicultural_affinity:African American (US) 66936 117 https://b|ackmattersus.com/ We didn’t believe the media and decided to become one! Want to know the actual state of things in US? — Go visit our website! Click here for more information! Black Mattersus Blackluive 139.04623999999998 8690.39 RUB 2016-02-04T00:40:35-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 1277.926ms · Data source: simonw/russian-ira-facebook-ads-datasette