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

This data as JSON, CSV (advanced)

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

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