home / russian-ads

display_ads (view)

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

14 rows where an ad_target was exclude:multicultural_affinity:Hispanic (US - All)

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
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  
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  
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
837 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, 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) 2801 12 https://www.facebook.com/Williamsathalvin/ Questions about why police shot and critically wounded a 17-year-old Somali refugee in Salt Lake City grew Monday as Civil rights groups called for answers and several hundred protesters took the streets holdings signs that read, “Stop killer cops.” It’s very insane when those who are to protect us have turned into serial killers. The most annoying part is that they have refused to release the footage video. They need retraining. Whatever happened to Tasers? Whatever to rubber bullets? Whatever happened to shooting shots in the sky as a warning? Why are police wearing body cam and we can’t see it? If they’re right, let’s see it. 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 3.2 200.00 RUB 2016-03-10T01:28:08-08:00 2016-03-12T01:28:07-08: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
911 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, 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) 47 1 https://www.facebook.com/WilliamsandKalvin/ Black Discrimination Awareness! Like to join! 0.0 0.00 USD 2016-01-14T06:53:13-08:00  
915 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, 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) 44 0 https://www.facebook.com/WilliamsandKalvin/ BIaCk-Americans deserves equal justice! Like to join! 0.0 0.00 USD 2016-01-14T06:50:06-08:00  
918 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, 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) 137 1 https://www.facebook.com/WilliamsandKalvin/ Society need to see beyond skin color! Afro—american community welcomes you! 0.6316799999999999 39.48 RUB 2016-01-14T06:52:41-08:00  
921 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, 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) 145 3 https://www.facebook.com/WilliamsandKalvin/ Stop hating black people! Like to join! 1.26096 78.81 RUB 2016-01-14T06:51:15-08:00  
922 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, 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) 170 2 https://www.facebook.com/WilliamsandKalvin/ Black is beautiful! News and videos for BIaCk-Americans! 1.30304 81.44 RUB 2016-01-14T06:51:56-08:00  
923 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, 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) 267 3 https://www.facebook.com/WilliamsandKalvin/ Videoblog about racism and black social issues! 1.788 111.75 RUB 2016-01-14T06:46:44-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.966ms · Data source: simonw/russian-ira-facebook-ads-datasette