home / russian-ads

display_ads (view)

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

6 rows where an ad_target was people_who_match:interests:African-Amerioan culture

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
940 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Afrioanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-Amerioan culture, people_who_match:interests:African-Amerioan Civil Rights Movement (1954—68), people_who_match:interests:African-Amerioan history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 58233 4781 https://www.facebook.com/blacktivists/ When you leave your baby girl alone with her father, that‘s what happens. When you leave your baby girl alone with her father, that‘s wh... 3.2 200.00 RUB 2017-04-19T07:17:40-07:00 2017-04-20T12:00:00-07:00
1037 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Afrioanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-Amerioan culture, people_who_match:interests:African-Amerioan Civil Rights Movement (1954—68), people_who_match:interests:African-Amerioan history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 56416 4011 https://www.facebook.com/Blacktivist-128371547505950/ When your mom sends you to shoot a hair tutorial so she can have a few minutes of peace. When your mom sends you to shoot a hair tutorial so she can ha... www.facebook.com 4.8 300.00 RUB 2017-03-09T02:48:35-08:00 2017-03-10T02:48:35-08:00
2068 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Martin Luther King, people_who_match:interests:African-Amerioan culture, people_who_match:interests:African-Amerioan Civil Rights Movement (1954—68), people_who_match:interests:African-Amerioan history, people_who_match:interests:Malcolm X 6583 703 https://www.facebook.com/blackmattersus.mvmnt/ Our deepest condolences to the victims and families in Manchester. We also wish people dedicate their sadness and thoughts to Syria, Flint, Bangkok or any other country which suffered from attacks and where the government cares only about money, not Citizens. 8.0 500.00 RUB 2017-05-25T00:12:18-07:00 2017-05-26T00:12:18-07:00
3328 location_living_in:united_states:Lansing (+25 mi) Michigan, 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:Martin Luther King, people_who_match:interests:Pan-Africanism, people_who_match:interests:Black Power, people_who_match:interests:Martial arts, people_who_match:interests:African American, people_who_match:interests:Black history, people_who_match:interests:Black Panther Party, people_who_match:interests:African-Amerioan culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Black History Month, people_who_match:interests:African-American history, people_who_match:interests:Angela Davis, people_who_match:interests:Malcolm X, people_who_match:interests:Self Defense Family, people_who_match:interests:Black (Color), people_who_match:interests:The Self Defense Company, and_must_also_match:interests:Mixed martial arts, and_must_also_match:interests:Martial arts, and_must_also_match:interests:The Women's Self Defense Institute, and_must_also_match:interests:PERSONAL & HOME DEFENSE, and_must_also_match:interests:SeIf-defense, and_must_also_match:interests:Self- defense (United States), and_must_also_match:interests:Personal Defense, and_must_also_match:interests:Right of self—defense, and_must_also_match:interests:Self Defense Family, and_must_also_match:interests:Active Self Protection 866 33 https://www.facebook.com/events/1779150775733663/ Join the event, bring your friends, feel safe with us! Don't miss the opportunity to train with our coach! You will enjoy it for sure. It's free! Organized on a donation basis. Join the event, bring your friends, feel safe with us! Don't miss the opportunity to train with our coach! You will enjoy it for sure. It's free! Organized on a donation basis. Free SeIf-Defense class in Lansing, MI —Free SeIf—Defense class in Lansing, MI _ 10.34416 646.51 RUB 2017-04-19T06:46:36-07:00 2017-04-29T06:46:36-07:00
3343 location_living_in:united_states:Lansing (+25 mi) Michigan, 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:Martin Luther King, people_who_match:interests:Pan-Africanism, people_who_match:interests:Black Power, people_who_match:interests:Martial arts, people_who_match:interests:African American, people_who_match:interests:Black history, people_who_match:interests:Black Panther Party, people_who_match:interests:African-Amerioan culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Black History Month, people_who_match:interests:African-American history, people_who_match:interests:Angela Davis, people_who_match:interests:Malcolm X, people_who_match:interests:Self Defense Family, people_who_match:interests:Black (Color), people_who_match:interests:The Self Defense Company, and_must_also_match:interests:Mixed martial arts, and_must_also_match:interests:Martial arts, and_must_also_match:interests:The Women's Self Defense Institute, and_must_also_match:interests:PERSONAL & HOME DEFENSE, and_must_also_match:interests:SeIf-defense, and_must_also_match:interests:Self- defense (United States), and_must_also_match:interests:Personal Defense, and_must_also_match:interests:Right of self—defense, and_must_also_match:interests:Self Defense Family, and_must_also_match:interests:Active Self Protection 1095 74 https://www.facebook.com/events/759606484220517/ Join the event, bring your friends, feel safe with us! Don't miss the opportunity to train with our coach! You will enjoy it for sure. It's free! Organized on a donation basis. Join the event, bring your friends, feel safe with us! Don't miss the opportunity to train with our coach! You will enjoy it for sure. It's free! Organized on a donation basis. Free SeIf-Defense class in Lansing, PFree SeIf—Defense class in Lansing, MI _ 11.108 694.25 RUB 2017-04-13T05:16:27-07:00 2017-04-15T05:16:27-07:00
3368 location_living_in:united_states:Lansing (+25 mi) Michigan, 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:Martin Luther King, people_who_match:interests:Pan-Africanism, people_who_match:interests:Black Power, people_who_match:interests:Martial arts, people_who_match:interests:African American, people_who_match:interests:Black history, people_who_match:interests:Black Panther Party, people_who_match:interests:African-Amerioan culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Black History Month, people_who_match:interests:African-American history, people_who_match:interests:Angela Davis, people_who_match:interests:Malcolm X, people_who_match:interests:Self Defense Family, people_who_match:interests:Black (Color), people_who_match:interests:The Self Defense Company, and_must_also_match:interests:Mixed martial arts, and_must_also_match:interests:Martial arts, and_must_also_match:interests:The Women's Self Defense Institute, and_must_also_match:interests:PERSONAL & HOME DEFENSE, and_must_also_match:interests:SeIf-defense, and_must_also_match:interests:Self- defense (United States), and_must_also_match:interests:Personal Defense, and_must_also_match:interests:Right of self—defense, and_must_also_match:interests:Self Defense Family, and_must_also_match:interests:Active Self Protection 2959 152 https://www.facebook.com/events/144244932774129/ Join the event, bring your friends, feel safe with us! Don't miss the opportunity to train with our coach! You will enjoy it for sure. It's free! Organized on a donation basis. Join the event, bring your friends, feel safe with us! Don't miss the opportunity to train with our coach! You will enjoy it for sure. It's free! Organized on a donation basis. Free SeIf-Defense class in Lansing, P Free SeIf—Defense class in Lansing, MI— 27.04 1690.00 RUB 2017-04-13T05:25:51-07:00 2017-04-22T05:25:51-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/umd-mith/irads/master/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 1285.275ms · Data source: simonw/russian-ira-facebook-ads-datasette