home / russian-ads

display_ads (view)

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

12 rows where an ad_target was location:united_states:Washington

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
459 location:united_states:Washington, interests:Independence, interests:Patriotism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2499 229 https://www.faoebook.com/patriototus The leader of radical religious group Nation of Islam, Louis Farrakhan, announced that 20th anniversary Million Man March rally will take place on October 10, 2015 in Washington, DC, at the National Mall. Organizers of the Million Man March call forjustioe, standing against the police and for blacks, Latinos and incarcerated. They say racism rises among the police officers, but in fact it rises among radical groups. Only black activists say “black lives matter”, forgetting the fact thatjustice is when all lives matter. Americans are not against blacks, Latinos, etc. But if somebody breaks the law, he should be punished despite of his color or religion. If somebody goes over the speed limit, he should be ticketed. If somebody breaks the immigration law, he should be deported. If somebody kills a man, he should be imprisoned. Given the fact that two Islamic extremists who were arrested one year ago in Ferguson belong to the Nation of Islam, I cannot believe in Farrakhan’s benevolent intentions. This Million Man March looks like another liberal overture to black and Muslim communities. This is a bad idea, especially if we take into account the recent news about British jihadi who have published the address of the Navy Seal Robert O'Neill, the man who fatally shot Osama bin Laden, and called on American extremists to execute him. There is no problem, if whoever wants to live in the United States. But he should live here legally; he should not break the law. lt’s justice. 31.88848 1993.03 RUB 2015-10-08T00:34:04-07:00 2015-10-09T00:34:04-07:00
503 location:united_states:Washington, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Being Patriotic, people_who_match:Friends of connections: Friends of people who are connected to Being Patriotic 134 21 https://www.faoebook.com/patriototus The Justice Department is set to release about 6,000 inmates from federal prisons in a bid to reduce overcrowding. It is the largest one-time release of federal prisoners. The Department will release drug offenders who received harsh sentences over the last three decades. Every third of them is illegal immigrant. Barack Obama has criticized overblown sentencing laws that "disproportionately impact communities of color." But is it indeed a reason to release criminals? If Latinos commit crimes often than whites, it doesn’t mean that some Latino criminals should escape penalty. 1.92736 120.46 RUB 2015-10-08T00:39:35-07:00 2015-10-10T00:39:35-07:00
1220 no image location:united_states:Washington, interests:Martin Luther King, interests:Jr., interests:Mahatma Gandhi, interests:Nelson Mandela, interests:| Have a Dream, interests:Medgar Evers, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 620 100 https://www.facebook.com/Blacktivist-128371547505950/ You don‘t Choose the color to be born with, but you Choose your destiny. #IamBlackAndProud 1.6 100.00 RUB 2016-05-06T05:45:23-07:00 2016-05-07T05:45:23-07:00
1226 no image location:united_states:Washington, interests:Martin Luther King, interests:Jr., interests:Mahatma Gandhi, interests:Nelson Mandela, interests:| Have a Dream, interests:Medgar Evers, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1256 82 https://www.facebook.com/Blacktivist-128371547505950/ All Roads Lead To Washington 00 On October 10, 2015 in Washington, DC, at the National Mall, The Honorable Minister Louis Farrakhan will convene the 20th Anniversary of the Million Man March under the theme: Justice or Else! “The Million Man March was one of the most historic organizing and mobilizing events in the history of Black people in the United States,” said Chicago—based Dr. Conrad Worrill, who was a main organizer of the March and the current president emeritus of the National United Black Front. The widespread death, rising racism, mob attacks and police brutality on Blacks coupled with economic deprivation and stark poverty, requires that something must be immediately done to address and correct the condition. We should stop the violence and the killings and present ourselves as a united front before the Government of the United States of America. Fredrick Douglas said “ Power concedes nothing except by a demand”. Our demand of government must be backed by the power of our unity and love of the brotherhood. It's really important for all of us, brothers and sisters. Join the Movement! 10-10-15 Justice Or Else! 11.200000000000001 700.00 RUB 2015-10-07T02:54:52-07:00 2015-10-09T02:54:51-07:00
1227 no image location:united_states:Washington, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Blacktivist, people_who_match:Friends of connections: Friends of people who are connected to Blacktivist 3213 224 https://www.facebook.com/blacktivists/ Change YOUR Facebook profile picture to BLACKTIVIST flag to honor black victims of police killings and violence. Click the link below, download BLACKTIVIST flag and apply our new filter on your profile picture. Let‘s stand together against injustice! If you have troubles with photoshop, send us your profile picture and we will photoshop it for you. http://www.mediafire.com/down|oad/4m453ljfei9yda1/b|ack_f|ag.psd 24.0 1500.00 RUB 2015-11-18T23:01:15-08:00 2015-11-20T23:01:14-08:00
1228 no image location:united_states:Washington, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Blacktivist, people_who_match:Friends of connections: Friends of people who are connected to Blacktivist 146 26 https://www.facebook.com/blacktivists/ Wake up, Black America! Police brutality must stop. Visit http://b|acktivist.ihfo/ Take action > add your profile photo to converter > apply Blacktivist filter Everyone who believes in truth must stand up and support our brothers and sisters who suffer from the injustice system! 0.6300800000000001 39.38 RUB 2015-12-15T06:34:16-08:00 2015-12-18T06:34:15-08:00
2439 location:united_states:Alabama, location:united_states:Arizona, location:united_states:California, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:New Mexico, location:united_states:New York, location:united_states:Oklahoma, location:united_states:Texas, location:united_states:Washington, interests:Freckle, interests:Baltimore, interests:Color, interests:Visual perception, interests:Black (Color), age:13 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2395 269 https://www.faoebook.com/BIack-Edification-1772583676310336/ So let's do this. Since no one knew what he looked like and the bible forbade idolatry how about we all stop trying to draw Jesus! 4.84752 302.97 RUB 2016-06-28T11:05:51-07:00 2016-06-29T11:05:50-07:00
2440 location:united_states:Alabama, location:united_states:Arizona, location:united_states:California, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:New Mexico, location:united_states:New York, location:united_states:Oklahoma, location:united_states:Texas, location:united_states:Washington, interests:Freckle, interests:Baltimore, interests:Color, interests:African—American culture, interests:Visual perception, interests:Black (Color), age:13 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2318 146 https://www.facebook.com/BIack-Edification-1772583676310336/ Many of us are poor and struggling due to systemic racisml! 80 fight for something! IT IS OUR DUTY!! WE HAVE NOTHING TO LOSE BUT OUR CHAINS! 1.18 73.75 RUB 2016-07-19T14:16:10-07:00 2016-07-26T14:16:09-07:00
2441 location:united_states:Alabama, location:united_states:Arizona, location:united_states:California, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:New Mexico, location:united_states:New York, location:united_states:Oklahoma, location:united_states:Texas, location:united_states:Washington, interests:Freckle, interests:Baltimore, interests:Color, interests:Visual perception, interests:Black (Color), age:13 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices 658 145 https://www.facebook.com/BIack-Edification-1772583676310336/ The Original Statue of Liberty presented to the US. was a Statue of a..."BIack Woman". - Urban Intellectuals 2.21056 138.16 RUB 2016-06-28T11:59:55-07:00 2016-07-05T11:59:54-07:00
2442 location:united_states:Alabama, location:united_states:Arizona, location:united_states:California, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:New Mexico, location:united_states:New York, location:united_states:Oklahoma, location:united_states:Texas, location:united_states:Washington, interests:Freckle, interests:Baltimore, interests:Color, interests:African-American culture, interests:Visual perception, interests:Black (Color), age:13 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices 4717 470 https://www.facebook.com/Black-Edification-1772583676310336/ Melanin is gold. It's a gift of God. We have to appreciate this in all shades. The black girls with freckles are also beautiful. 8.0 500.00 RUB 2016-06-25T13:08:42-07:00 2016-06-27T13:08:40-07:00
2443 location:united_states:Alabama, location:united_states:Arizona, location:united_states:California, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:New Mexico, location:united_states:New York, location:united_states:Oklahoma, location:united_states:Texas, location:united_states:Washington, interests:Freckle, interests:Baltimore, interests:Color, interests:African-American culture, interests:Visual perception, interests:Black (Color), age:13 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Black-Edification-1772583676310336/ Melanin is gold. It's a gift of God. We have to appreciate this in all shades. The black girls with freckles are also beautiful. 0.0 0.00 USD 2016-07-17T00:37:25-07:00 2016-06-27T13:08:40-07:00
2444 location:united_states:Alabama, location:united_states:Arizona, location:united_states:California, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:New Mexico, location:united_states:New York, location:united_states:Oklahoma, location:united_states:Texas, location:united_states:Washington, interests:Freckle, interests:Baltimore, interests:Color, interests:Visual perception, interests:Black (Color), age:13 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices 15771 4020 https://www.faoebook.com/BIack-Edification-1772583676310336/ Darkness cannot drive out darkness; only light can do that. Hate cannot drive out hate; only love can do that. Martin Luther King, Jr. 8.0 500.00 RUB 2016-07-17T00:48:23-07:00 2016-07-24T00:48:22-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 1302.627ms · Data source: simonw/russian-ira-facebook-ads-datasette