home / russian-ads

display_ads (view)

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

16 rows where an ad_target was excluded_connections:Exclude people who like Williams&Kalvin

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
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  
832 location:United States, excluded_connections:Exclude people who like Williams&Kalvin, age:18 - 51, 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:National Museum of American History, people_who_match:interests:Stop Racism”, people_who_match:interests:Malcolm X Memorial Foundation, people_who_match:interests:Maya Angelou, people_who_match:interests:Mumia Abu- Jamal, people_who_match:interests:The Raw Story or mother jones, people_who_match:interests:Multicultural Affinity: African American (US) 6508 1240 https://www.facebook.com/WiIliamsKalvin-788980617892144/ BLACK DOLLARS MATTER While Black activists are trying to strict American government’s attention by organizing protests, Black bank owners urge Black Americans to transfer money into their banks. A few days ago there were started the #MoveYourMany campaign which the main goal is to demonstrate the value of Black lives within America. At the request of rapper Killer Mike, over 8,000 people have transferred their money into BIack—owned banks in the last 5 days. 50 years ago Martin Luther King Jr. requested Blacks to replace their funds from non-Black banks to BIack-owned institutions which would help to empower and advance Black community. The best way to fight the system is to break its capitalist back which is why it is important for Blacks to invest in ourselves! 8.0 500.00 RUB 2016-07-21T09:17:51-07:00 2016-07-22T09:17:50-07:00
862 location:United States, excluded_connections:Exclude people who like Williams&Kalvin, age:18 - 51, 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:National Museum of American History, people_who_match:interests:Maya Angelou, people_who_match:interests:Mumia Abu-Jamal, people_who_match:interests:The Raw Story or motherjones, people_who_match:interests:Behaviors: African American (US) 3170 45 https://www.facebook.com/WilliamsKalvin-788980617892144/ The Civil Rights Movement was fighting for the real equality in general and particularly the equal rights of voting. It started in North Carolina but it can spread all over the country. Blacks are being deprived of general voting rights. The US. District Judge, Thomas Schroeder, on Monday dismissed lawsuits challenging Changes to the state’s election laws, declaring that the Challenges failed to show that it hindered voters of color from exercising their voting rights. The North Carolina law which eliminated early voting, same —day voter registration and out-of-precinct voting requires voters who go to the polls to show an acceptable form of identification such as a driver’s license, passport or military ID. This is not a good sign as we watch the world take the new turn for the worse now while doing nothing. Subscribe to our Channel: https://www.youtube.com/ChahnellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Twitter: https://twitter.com/Williams8kalvih 8.0 500.00 RUB 2016-05-05T01:09:03-07:00 2016-05-06T01:09:02-07:00
866 no image location:United States, excluded_connections:Exclude people who like Williams&Kalvin, age:18 - 51, 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:National Museum of American History, people_who_match:interests:Maya Angelou, people_who_match:interests:Mumia Abu-Jamal, people_who_match:interests:The Raw Story or motherjones, people_who_match:interests:Behaviors: African American (US) 0 0 https://www.facebook.com/WilliamsKalvin-788980617892144/ African-Americans have to Choose between old b*toh Hillary Clinton and rich bastard Donald Trump. This is like to Choose between the devil and the deep see. Still, you can not only survive in the deep see called Trump but also to catch a fish to feed your family there. But there’s no way to have a good deal with the devil called Hillary Clinton. Subscribe to our Channel: https://www.youtube.com/ChahnellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Twitter: https://twitter.oom/Williams8kalvih 0.0 0.00 USD 2016-08-22T02:55:36-07:00 2016-08-23T02:55:35-07:00
869 location:United States, excluded_connections:Exclude people who like Williams&Kalvin, age:18 - 51, 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:National Museum of American History, people_who_match:interests:Stop Racism”, people_who_match:interests:Malcolm X Memorial Foundation, people_who_match:interests:Maya Angelou, people_who_match:interests:Mumia Abu- Jamal, people_who_match:interests:The Raw Story or mother jones, people_who_match:interests:Multicultural Affinity: African American (US) 5 0 https://www.facebook.com/WiIliamsKalvin-788980617892144/ Don't believe the stereotypes that media created to discredit black dads! They're the best! Like if you agree! 0.05072 3.17 RUB 2016-05-05T01:08:27-07:00 2016-05-06T01:08:27-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  
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  
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  
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  
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  
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  
897 location:United States, excluded_connections:Exclude people who like Williams&Kalvin, age:18 - 51, 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:National Museum of American History, people_who_match:interests:Stop Racismll, people_who_match:interests:Malcolm X Memorial Foundation, people_who_match:interests:Maya Angelou, people_who_match:interests:Mumia Abu- Jamal, people_who_match:interests:The Raw Story or mother jones, people_who_match:interests:Multicultural Affinity: African American (US) 6881 192 https://www.facebook.com/WilliamsKalvin-788980617892144/ Robert Bentley, Alabama Governor, has decided to reform prison system. This is actually good news? Alabama happens to be one of the nation’s poorest states which have led to overcrowd in its prison. The prison system houses 24,000 inmates but it was designed for 13,000.Let me enlighten you a little on how it’s going to be done. Four other larger prisons will be built additionally to prevent the rate of overcrowd. Even though one would have taught of using this money for projects like health care facilities and other, he Chose prisons. It’s not bad though, at least inmates will have free live behind bars. It shows how much he cares for his people. Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Subscribe to my YouTube Channel: https://www.youtube.com/ChahnellUCszPCwUDPvDCR6VRaOCDtg Follow me on Twitter: https://twitter.oom/Williams8kalvih 18.20848 1138.03 RUB 2016-03-22T07:34:48-07:00 2016-03-23T07:34:47-07: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 1265.991ms · Data source: simonw/russian-ira-facebook-ads-datasette