home / russian-ads

display_ads (view)

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

8 rows where an ad_target was and_must_also_match:multicultural_affinity:African American (US)

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
182 no image location:united_states:New York (+20 km) 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:interests:Black Tea Patriots, people_who_match:interests:BIackNews.com, and_must_also_match:multicultural_affinity:African American (US) 4529 221 https://www.facebook.com/blackmattersus/ The _Ni|| attract the UN’s attention to the long term injustice and cruelty against people of color in the United States. The genocide instituted by white supremacists should be stopped. Join our protest that will be held Also, join the event for more info: #CrimesOfGenocide 24.8 1550.00 RUB 2016-02-09T05:40:15-08:00 2016-02-12T06:18:00-08:00
190 no image location:united_states:New York (+40 km) New York, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Black Tea Patriots, people_who_match:interests:BIackNews.com, and_must_also_match:multicultural_affinity:African American (US) 3466 353 https://www.facebook.com/blackmattersus/ ATTENTION, NEWYORK! We're meetin 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: 22.17904 1386.19 RUB 2016-02-18T05:12:00-08:00 2016-02-19T16:09:00-08:00
778 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:multicultural_affinity:Hispanic (US - All), exclude:multicultural_affinity:Hispanic (US - Spanish dominant), exclude:multicultural_affinity:Hispanic (US - English dominant), exclude:multicultural_affinity:Hispanic (US - Bilingual), exclude:multicultural_affinity:Asian American (US), people_who_match:interests:Black Tea Patriots, people_who_match:interests:Black Knowledge, people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:multicultural_affinity:African American (US) 147 5 https://www.facebook.com/WilliamsandKalvin/ We're black and We're proud of it! Join to understand how beautiful we are! 1.16432 72.77 RUB 2016-01-14T06:32:29-08:00  
783 location:United States, excluded_connections:Exclude people who like Williams&Kalvin, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:multicultural_affinity:Hispanic (US - All), exclude:multicultural_affinity:Hispanic (US - Spanish dominant), exclude:multicultural_affinity:Hispanic (US - English dominant), exclude:multicultural_affinity:Hispanic (US - Bilingual), exclude:multicultural_affinity:Asian American (US), people_who_match:interests:Black Tea Patriots, people_who_match:interests:Black Knowledge, people_who_match:interests:BIackNewscom, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:multicultural_affinity:African American (US) 39 1 https://www.facebook.com/WilliamsandKalvin/ Your voice counts! Here you can find news and videos about black community! 0.0 0.00 USD 2016-01-14T06:38:40-08:00  
791 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:multicultural_affinity:Hispanic (US - All), exclude:multicultural_affinity:Hispanic (US - Spanish dominant), exclude:multicultural_affinity:Hispanic (US - English dominant), exclude:multicultural_affinity:Hispanic (US - Bilingual), exclude:multicultural_affinity:Asian American (US), people_who_match:interests:Black Tea Patriots, people_who_match:interests:Black Knowledge, people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:multicultural_affinity:African American (US) 70 1 https://www.facebook.com/WilliamsandKalvin/ Community about black social and racial issues! Like to subscribe! 0.12928 8.08 RUB 2016-01-14T06:31:13-08:00  
812 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 — 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:multicultural_affinity:Hispanic (US — All), exclude:multicultural_affinity:Hispanic (US — Spanish dominant), exclude:multicultural_affinity:Hispanic (US - English dominant), exclude:multicultural_affinity:Hispanic (US - Bilingual), exclude:multicultural_affinity:Asian American (US), people_who_match:interests:Black Tea Patriots, people_who_match:interests:Black Knowledge, people_who_match:interests:BIackNewscom, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:multicultural_affinity:African American (US) 91 1 https://www.facebook.com/WilliamsandKalvin/ Community about black social and racial issues! Like to subcribe! 0.48672000000000004 30.42 RUB 2016-01-14T06:27:17-08:00  
817 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:multicultural_affinity:Hispanic (US - All), exclude:multicultural_affinity:Hispanic (US - Spanish dominant), exclude:multicultural_affinity:Hispanic (US - English dominant), exclude:multicultural_affinity:Hispanic (US - Bilingual), exclude:multicultural_affinity:Asian American (US), people_who_match:interests:Black Tea Patriots, people_who_match:interests:Black Knowledge, people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:multicultural_affinity:African American (US) 88 1 https://www.facebook.com/WilliamsandKalvin/ Newest news and videos for Black community! Stay together, like to join! 0.56 35.00 RUB 2016-01-14T06:34:14-08:00  
831 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:multicultural_affinity:Hispanic (US - All), exclude:multicultural_affinity:Hispanic (US - Spanish dominant), exclude:multicultural_affinity:Hispanic (US - English dominant), exclude:multicultural_affinity:Hispanic (US - Bilingual), exclude:multicultural_affinity:Asian American (US), people_who_match:interests:Black Tea Patriots, people_who_match:interests:Black Knowledge, people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:multicultural_affinity:African American (US) 47 0 https://www.facebook.com/WilliamsandKalvin/ It's time for Changes in Black Community! Stay together brother let us be together here! 0.0 0.00 USD 2016-01-14T06:33:15-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 1369.204ms · Data source: simonw/russian-ira-facebook-ads-datasette