home / russian-ads

display_ads (view)

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

27 rows where an ad_target was people_who_match:interests:BIackNews.com

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
773 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:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 49 2 https://www.facebook.com/WilliamsandKalvin/ Community about black social and racial issues! Like to subcribe! 0.56 35.00 RUB 2016-01-14T06:27:21-08:00  
776 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:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 37 0 https://www.facebook.com/WilliamsandKalvin/ Community about black social and racial issues! Like to subcribe! 0.0 0.00 USD 2016-01-14T06:27:19-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  
779 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:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 55 1 https://www.facebook.com/WilliamsandKalvin/ We're black and We're proud of it! Join to understand how beautiful we are! 0.21872 13.67 RUB 2016-01-14T06:32:28-08:00  
789 location:United States, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, accessing_facebook_on:Wi-Fi, people_who_match:interests:BIackNews.com, people_who_match:interests:HuffPost Politics, people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 3067 172 https://www.youtube.com/watch?v=Gij0RgShO| Where is the justice? Our brothers and sisters are being cruelly killed by the so—called police every day and ourjudicial system is absolutely blind. We are all Americans, but why does our corrupt Government differ black and white people? We want the same attitude! I don‘t want to be scared of living in my country! They will never shut me up! https://www.youtube.com/watch?v=Gij0RgShO| Where is the justice? Our brothers and sisters are being cruelly killed by the so—called police every day and ourjudicial system is absolutely blind. We are... Police is not above the law! 16.0 1000.00 RUB 2016-01-05T02:04:48-08:00 2016-01-07T02:03:00-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  
792 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:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 51 0 https://www.facebook.com/WilliamsandKalvin/ We're black and We're proud of it! Join to understand how beautiful we are! 0.0 0.00 USD 2016-01-14T06:32:30-08:00  
795 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:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 51 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:10-08:00  
796 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:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 46 1 https://www.facebook.com/WilliamsandKalvin/ It's time for Changes in Black Community! Stay together brother let us be together here! 1.8379200000000002 114.87 RUB 2016-01-14T06:33:13-08:00  
797 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:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 41 0 https://www.facebook.com/WilliamsandKalvin/ Community about black social and racial issues! Like to subscribe! 0.0 0.00 USD 2016-01-14T06:31:14-08:00  
806 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:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 98 2 https://www.facebook.com/WilliamsandKalvin/ Newest news and videos for Black community! Stay together, like to join! 0.8736 54.60 RUB 2016-01-14T06:34:13-08:00  
814 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:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 31 0 https://www.facebook.com/WilliamsandKalvin/ Community about black social and racial issues! Like to subcribe! 0.0 0.00 USD 2016-01-14T06:27:20-08:00  
815 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:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 37 0 https://www.facebook.com/WilliamsandKalvin/ Newest news and videos for Black community! Stay together, like to join! 0.0 0.00 USD 2016-01-14T06:34:18-08:00  
816 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:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 87 3 https://www.facebook.com/WilliamsandKalvin/ It's time for Changes in Black Community! Stay together brother let us be together here! 0.4368 27.30 RUB 2016-01-14T06:33: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  
820 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:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 63 1 https://www.facebook.com/WilliamsandKalvin/ Newest news and videos for Black community! Stay together, like to join! 0.6176 38.60 RUB 2016-01-14T06:34:13-08:00  
825 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:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 138 4 https://www.facebook.com/WilliamsandKalvin/ We're black and We're proud of it! Join to understand how beautiful we are! 1.1009600000000002 68.81 RUB 2016-01-14T06:32:24-08:00  
827 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:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 27 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  
828 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:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 57 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:14-08:00  
829 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:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 78 2 https://www.facebook.com/WilliamsandKalvin/ Community about black social and racial issues! Like to subscribe! 0.56 35.00 RUB 2016-01-14T06:31:12-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  
836 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:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 37 0 https://www.facebook.com/WilliamsandKalvin/ We're black and We're proud of it! Join to understand how beautiful we are! 0.0 0.00 USD 2016-01-14T06:32:30-08:00  
840 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:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 30 0 https://www.facebook.com/WilliamsandKalvin/ Community about black social and racial issues! Like to subscribe! 0.0 0.00 USD 2016-01-14T06:31:05-08:00  
848 location:United States, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, accessing_facebook_on:Wi-Fi, people_who_match:interests:BIackNews.com, people_who_match:interests:HuffPost Politics, people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 6280 231 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Why don‘t american cops realize that being black is not a crime? African american kids are being shot only for playing with toy guns... How is it possible? Where is the justice? Our Government is blind, they simply don‘t want to pay attention to this legalized homicide of own people... This is crazy! We must speak about it! 16.0 1000.00 RUB 2016-01-05T02:06:20-08:00 2016-01-08T02:03:12-08:00
854 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:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIackNews.com, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 34 0 https://www.facebook.com/WilliamsandKalvin/ Community about black social and racial issues! Like to subscribe! 0.0 0.00 USD 2016-01-14T06:31:16-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 1410.518ms · Data source: simonw/russian-ira-facebook-ads-datasette