home / russian-ads

display_ads (view)

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

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

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
803 location:United States, interests:Martin Luther King, interests:Jr., interests:Police Brutality is a Crime, interests:African-Amerioan culture, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Malcolm X, interests:Union of Huffington Post Writers and Bloggers, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 12654 693 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Ice-Cream is something more than just a food you love. When a business expresses its views, cops are attacking, because they know no other way to act! Ben & Jerry’s ice-cream is boycotted by the police officers just because of the opinion of the business owners. So, let’s stand against the political repressions! Subscribe to our Channel: https://www.youtube.com/ChahnellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: https://www.instagram.Com/williams.and.kalvin Follow me on Twitter: https://twitter.oom/Williams8kalvih 12.7992 799.95 RUB 2016-10-21T07:46:31-07:00 2016-10-24T07:46:28-07:00
3105 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan culture, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Black Consciousness Movement, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2210 485 https://www.facebook.com/Woke-B|acks-294234600956431/ The truth hurts, but we must face it. It's a sad fact, but the most of Black men regard women of other race romantic and beautiful. Believe me you, Black men, we got the most beautiful, romantic and attractive females under the sun. Value 3 Black woman and treat her like you'd treat other women of other races and you'll realize how of a Queen you have. #blackexcellence #PanAfricanism #BlaokNationalism #BlackEmpowerment #AfricanEmpowermeht #AfricanAndProud #BlaCkAndProud #BlackPride #BlackPower #BlackLivesMatter #Amerikkka #UnapologeticallyBlack #UnapologeticallyAfrican #BlacklhAmerica #BlacklsBeautiful #KnowThySelf #KnowledgeOfSelf #KnowledgeOfSelflsANationality #EconomicEmpowerment #IhtegrationFailed #WhiteLiesMatter #Education #AfricanUnifiCation #AfricanUnity #BlackLove #JusticeOrElse #ProBlack #Regrann #blackexcellence 2.80736 175.46 RUB 2017-04-13T07:03:49-07:00 2017-04-14T07:03:49-07:00
3119 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan culture, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Black Consciousness Movement, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 39914 7534 https://www.facebook.com/Woke-B|acks-294234600956431/ Just a reminder; Never forget that the black panthers group was only formed to protect Black people from the kkk, who used to kill Black people like animals. ?? However, the Black Panthers was dismantled by the US govt, but the kkk still exists today. No, tell me this ain't about race. Better still, tell me why is this so? #PanAfricanism #BIaokNationaIism #BlackEmpowerment #AfricanEmpowermeht #AfricanAndProud #BIaokAndProud #BlackPride #BlackPower #BIaCkLivesMatter #Amerikkka #UnapologeticallyBlack #UnapologeticallyAfrican #BlacklhAmerica #BlacklsBeautiful #KnowThySelf #KnowledgeOfSelf #KnowledgeOfSelflsANationaIity #EconomicEmpowerment #IhtegrationFailed #WhiteLiesMatter #Education #AfricanUnifiCation #AfricanUnity #BlackLove #JusticeOrElse #ProBIack #Regrann #blackexcellence #goals #woke 5.9176 369.85 RUB 2017-02-17T05:32:50-08:00 2017-02-20T05:32:50-08:00
3123 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan culture, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Black Consciousness Movement, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1327 122 https://www.facebook.com/Woke-B|acks-294234600956431/ A free-spirited mind thinks deeply. Thins mind thinks about being detached from the system since Childbirth, thinks about the liberation of his people, thinks about survival in all possible cases. Most importantly, a free-spirited mind always survives, doesn't perish and even does well under any given condition. I hope y'all striving to be free yourselves from the system. #wakeup #wewillsurvive #organize ##joshuabeal #altonsterling #TerenceCrutCher #westandtogether #blacklivesmatter #unite4justice #november8 #elections2016 #black #melanin #blackisbeautiful #blacklivesmatter #blackgirlmagic #U SA #blackahdproud #democrat #republioah #Africanamerican #unite4justice #vote #breakingnews 1.12 70.00 RUB 2016-11-11T03:56:07-08:00 2016-11-14T03:56:07-08:00
3170 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan culture, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Black Consciousness Movement, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 5 1 https://www.facebook.com/Woke-Blacks-294234600956431/ To all Black youth, to all young Black girls and ladies, to the Black gentlemen and to the Black boys, to all Black people, let's never underrate the power of our Queens, every single one of them, from new born babies to their mothers and young university graduates, we believe in you and your strength. Keep the Black girl Magic shinning everywhere. #PanAfricanism #BlaokNationalism #BlackEmpowermen #AfricanEmpowermeht #AfricanAndProud #BlaokAndProud #BlackPride #BlackPower #BlackLivesMatter #Amerikkka #UnapologeticallyBlack #UnapologeticallyAfrican #BlacklhAmerica #BlacklsBeautiful #KnowThySelf #KnowledgeOfSelf #KnowledgeOfSelflsANationality #EconomicEmpowerment #lhtegrationFailed #WhiteLiesMatter #Education #AfricanUnifiCation #AfricanUnity #BlackLove #JusticeOrElse #ProBlack #Regrann #blackexcellence 0.00944 0.59 RUB 2017-03-15T08:05:34-07:00 2017-03-16T08:05:34-07:00
3199 location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:BLACK BUSINESS GLOBAL, interests:Black Business Works, interests:African-Amerioan culture, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Black Business Builders Club, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:Instagram Feed, placements:News Feed on mobile devices, interest_expansion:On 1193 4 https://www.facebook.oom/Black4BlaCk-1268698556482143/ “It’s important that we support black business because it strengthens the black community and helps to create jobs. It’s also empowering to show your solidarity in coming together to uplift your community,” - Dana Hill, a founder and CEO of COCOTIQUE 3.2 200.00 RUB 2016-12-05T06:25:47-08:00 2016-12-06T06:25:47-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 1225.14ms · Data source: simonw/russian-ira-facebook-ads-datasette