home / russian-ads

display_ads (view)

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

29 rows where an ad_target was people_who_match:interests:Racism in the United States

This data as JSON, CSV (advanced)

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
804 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, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 185599 10575 https://www.facebook.com/WilliamsandKalvin We are proud to be black and stand for our community! Join to end the racism in the US. 774.0616 48378.85 RUB 2016-04-13T04:42:55-07:00  
807 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, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 371295 16442 https://www.facebook.com/WilliamsandKalvin We are proud to be black and stand for our community! Join to end the racism in the US. 889.7540799999999 55609.63 RUB 2016-04-13T04:43:03-07:00  
873 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, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 113 0 https://www.facebook.com/WilIiamsKalvin-788980617892144/ We are proud to be black and stand for our community! Join to end the racism in the US. 1.09152 68.22 RUB 2016-04-13T04:42:49-07:00  
874 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, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 697 15 https://www.facebook.com/WilliamsandKalvin It’s time to wake up and break our Chains! Together we will find our way to freedom. 5.42208 338.88 RUB 2016-04-13T04:44:13-07:00  
876 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, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 811 16 https://www.facebook.com/WilliamsandKalvin We are proud to be black and stand for our community! Join to end the racism in the US. 10.01696 626.06 RUB 2016-04-13T04:42:44-07:00  
877 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, people_who_match:interests:Stop Racism”, people_who_match:interests:Say To No Racism, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 316 7 https://www.facebook.com/WilliamsandKalvin We are proud to be black and stand for our community! Join to end the racism in the US. 3.41392 213.37 RUB 2016-04-13T04:42:47-07:00  
878 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, people_who_match:interests:Stop Racism”, people_who_match:interests:Say To No Racism, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 154 3 https://www.facebook.com/WilliamsandKalvin We are proud to be black and stand for our community! Join to end the racism in the US. 1.35232 84.52 RUB 2016-04-13T04:42:50-07:00  
879 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, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 89 1 https://www.facebook.com/WilIiamsKalvin-788980617892144/ We are proud to be black and stand for our community! Join to end the racism in the US. 0.72704 45.44 RUB 2016-04-13T04:42:40-07:00  
880 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, people_who_match:interests:Stop Racism”, people_who_match:interests:Say To No Racism, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 170 1 https://www.facebook.com/WilliamsandKalvin We are proud to be black and stand for our community! Join to end the racism in the US. 2.5321599999999997 158.26 RUB 2016-04-13T04:42:52-07:00  
881 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, people_who_match:interests:Stop Racism”, people_who_match:interests:Say To No Racism, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 107 1 https://www.facebook.com/WilliamsandKalvin We are proud to be black and stand for our community! Join to end the racism in the US. 1.2047999999999999 75.30 RUB 2016-04-13T04:42:58-07:00  
883 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, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 438 9 https://www.facebook.com/WilliamsandKalvin Information is your strongest weapon. Know the truth and stand against the racism in US. 2.84 177.50 RUB 2016-04-13T04:45:58-07:00  
884 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, people_who_match:interests:Stop Racism”, people_who_match:interests:Say To No Racism, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 35 0 https://www.facebook.com/WilliamsandKalvin We are proud to be black and stand for our community! Join to end the racism in the US. 0.17632 11.02 RUB 2016-04-13T04:43:04-07:00  
885 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, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 32 0 https://www.facebook.com/WilIiamsKalvin-788980617892144/ We are proud to be black and stand for our community! Join to end the racism in the US. 0.21824000000000002 13.64 RUB 2016-04-13T04:42:59-07:00  
886 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, people_who_match:interests:Stop Racism”, people_who_match:interests:Say To No Racism, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 35 0 https://www.facebook.com/WilliamsandKalvin It’s time to wake up and break our chains! Together we will find our way to freedom. 0.42672000000000004 26.67 RUB 2016-04-13T04:44:15-07:00  
887 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, people_who_match:interests:Stop Racism”, people_who_match:interests:Say To No Racism, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 41 0 https://www.facebook.com/WilliamsandKalvin We are proud to be black and stand for our community! Join to end the racism in the US. 0.37744 23.59 RUB 2016-04-13T04:43:01-07:00  
888 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, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 33 0 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Information is your strongest weapon. Know the truth and stand against the racism in US. 0.29056 18.16 RUB 2016-04-13T04:45:52-07:00  
889 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, people_who_match:interests:Stop Racism”, people_who_match:interests:Say To No Racism, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 216 5 https://www.facebook.com/WilliamsandKalvin Information is your strongest weapon. Know the truth and stand against the racism in US. 2.20608 137.88 RUB 2016-04-13T04:46:01-07:00  
890 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, people_who_match:interests:Stop Racism”, people_who_match:interests:Say To No Racism, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 92 1 https://www.facebook.com/WilliamsandKalvin Information is your strongest weapon. Know the truth and stand against the racism in US. 1.6806400000000001 105.04 RUB 2016-04-13T04:45:55-07:00  
891 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, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 134 2 https://www.facebook.com/WilIiamsKalvin-788980617892144/ It’s time to wake up and break our Chains! Together we will find our way to freedom. 1.06256 66.41 RUB 2016-04-13T04:44:11-07:00  
892 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, people_who_match:interests:Stop Racism”, people_who_match:interests:Say To No Racism, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 71 3 https://www.facebook.com/WilliamsandKalvin It’s time to wake up and break our chains! Together we will find our way to freedom. 0.68016 42.51 RUB 2016-04-13T04:44:14-07:00  
2980 location_living_in:United States, excluded_connections:Exclude people who like Watch the Police, age:18 - 65+, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Anti-Racist Action, people_who_match:interests:Social justice, people_who_match:interests:Anti-racism, people_who_match:interests:Filming Cops, people_who_match:interests:Cop Block, people_who_match:interests:Racism in the United States 23038 1635 https://www.facebook.com/WatCh-the-Police-1095374457243609/ We united by our shared goal of police accountability! 135.20592000000002 8450.37 RUB 2016-10-12T06:05:12-07:00  
3081 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States, interest_expansion:On 1 0 https://www.facebook.com/WilliamsandKalvin/ Videoblog about social issues. Williams&Ka|vin 0.00464 0.29 RUB 2016-12-01T05:06:49-08:00  
3082 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States, interest_expansion:On 5458 187 https://www.facebook.com/WilliamsandKalvin/ It's time to wake up and break our Chains! Together we will find our way to freedom. 21.794880000000003 1362.18 RUB 2016-12-01T05:40:16-08:00  
3083 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States, interest_expansion:On 2744 76 https://www.facebook.com/WilliamsandKalvin/ It's time to wake up and break our Chains! Together we will find our way to freedom. 19.124 1195.25 RUB 2016-12-05T06:24:36-08:00  
3084 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Racism in the United States, interest_expansion:On 0 0 https://www.facebook.com/WilliamsandKalvin/ It's time to wake up and break our Chains! Together we will find our way to freedom. 0.0 0.00 USD 2016-12-06T01:02:03-08:00  
3085 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Racism in the United States, interest_expansion:On 4 0 https://www.facebook.com/Williamsathalvin/ Information is your strongest weapon. Know the truth and stand against the racism in the US! 0.020960000000000003 1.31 RUB 2016-12-06T01:08:35-08:00  
3086 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Racism in the United States, interest_expansion:On 0 0 https://www.facebook.com/Williamsathalvin/ Newsblog about social injustice in the US. Our goal is to tell the truth 0.0 0.00 USD 2016-12-06T01:31:58-08:00  
3087 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Racism in the United States, interest_expansion:On 11113 321 https://www.facebook.com/Williamsathalvin/ Newsblog about social injustice in the US. Join us and stay informed! 75.09328000000001 4693.33 RUB 2016-12-06T01:36:05-08:00  
3088 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Racism in the United States, interest_expansion:On 127188 3309 https://www.facebook.com/Williamsathalvin/ Newsblog about social injustice in the US. Join us and stay informed! Williams&Ka|vin 418.49136 26155.71 RUB 2016-12-12T06:40:45-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 1282.537ms · Data source: simonw/russian-ira-facebook-ads-datasette