home / russian-ads

display_ads (view)

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

9 rows where an ad_target was connections:People who like Being Patriotic

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
433 location:United States, connections:People who like Being Patriotic, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 3362 761 https://www.facebook.oom/Being-PatriotiC-1601685693432389/ Boston police shot and killed a man wearing body armor and wielding an assault rifle who critically injured two officers responding to a domestic disturbance call late Wednesday, according to Police Commissioner William Evans. A gun battle raged at an East Boston home as a suspect, Kirk Figueroa, 33, of East Boston, critically injured two Boston police officers late on October 12.He was then shot and killed by other officers who ran into the home to drag out their wounded colleagues while undergoing heavy gunfire themselves. This bloody massacre is a vivid example of the fact that the war with police is too far from being OVER. It’s only coming and the consequences will be destructive if Hillary Clinton, the main hardliner against oops, will become the President of the United States. Defending the police against liberal and racist accusations is a solemn duty of every American Patriot. Recent spate of cop killings indicates that American national identity is undermined and replaced by ridiculous social experiments liberal elites are constantly setting up on the country. Democrats are unable to secure the police from attacks of extremist movements like Black Lives Matter. The Nation must unite against reverse racism, against those who want to destroy America! Among all the candidates Donald Trump is the one and only who can defend the police from terrorists. 8.0 500.00 RUB 2016-10-14T08:24:29-07:00 2016-10-15T08:24:28-07:00
472 location_living_in:united_states:New York (+50 mi) New York, connections:People who like Being Patriotic, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/events/365162297165103/ Donald John Trump was elected the 45th president of the United States on Tuesday! Today some massive crowds of libtards marched in NYC against election of Donald Trump. Come to Trump Tower (725 5th Ave) on Saturday to show Mr. Trump there actually ARE people in NY who voted for him! Support Trump in NYC 0.0 0.00 USD 2016-11-10T04:41:38-08:00 2016-11-11T21:00:00-08:00
473 location_living_in:united_states:New York (+50 mi) New York, connections:People who like Being Patriotic, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/events/365162297165103/ Donald John Trump was elected the 45th president of the United States on Tuesday! Today some massive crowds of libtards marched in NYC against election of Donald Trump. Come to Trump Tower (725 5th Ave) on Saturday to show Mr. Trump there actually ARE people in NY who voted for him! Support Trump in NYC 0.0 0.00 USD 2016-11-10T04:44:36-08:00 2016-11-11T21:00:00-08:00
474 location_living_in:united_states:New York (+50 mi) New York, connections:People who like Being Patriotic, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1 0 https://www.facebook.com/events/365162297165103/ Donald John Trump was elected the 45th president of the United States on Tuesday! Today some massive crowds of libtards marched in NYC against election of Donald Trump. Come to Trump Tower (725 5th Ave) on Saturday to show Mr. Trump there actually ARE people in NY who voted for him! Support Trump in NYC 0.0096 0.60 RUB 2016-11-10T04:50:28-08:00 2016-11-11T21:00:00-08:00
765 location_living_in:United States, connections:People who like Being Patriotic, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1987 131 https://www.facebook.com/patriototus/ It’s just ridiculous that we lack money for veterans’ healthcare and housing, lack recourses to enforce our border security, but at the same time have enough budget funds to continue this devastating policy of bombing foreign countries. Ordinary Americans get zero profit from oil wars that last for years but don’t end. Iraq, Syria, Afghanistan, we’ve been involved in conflicts in these countries for years, and none of these conflicts gave us anything but growing state debt. 5.76 360.00 RUB 2017-05-15T08:13:57-07:00 2017-05-17T08:13:57-07:00
766 location_living_in:United States, connections:People who like Being Patriotic, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2409 189 https://www.facebook.com/patriototus/ I believe Ron Paul’s position on our foreign military policy is absolutely right. After all, it was Trump who promised to put America First and promised to end Obama’s policy of wasting budget money on military operations overseas. “We’re not going into Syria”, Trump said it to calm down those who got really concerned about a possibility of America getting involved into another war. I really want to trust these words, but unfortunately many high-ranked politicians want to force Trump to pull America into another war. Here’s what Ron Paul thinks about it: “By the end of this month, Defense Secretary James Mattis and National Security Advisor HR McMaster will deliver to President Trump their plans for military escalations in Afghanistan, Iraq, and Syria. President Trump would be wise to rip the plans up and send his national security team back to the drawing board — or replace them. There is no way another “surge” in Afghanistan and Iraq (plus a new one in Syria) puts America first. There is no way doing the same thing over again will succeed any better than it did the last time.” Syria will be just another oil war; Iraq cost our country 4,500 soldier lives, and why the hell are we still in Afghanistan? We’ve started the whole Afghanistan thing to beat the Soviets, and no there’s no Soviet Union on the world map, and all the communists left on this planet are only Chinese and Californian students. 6.4 400.00 RUB 2017-05-16T07:32:20-07:00 2017-05-17T07:32:20-07:00
767 location_living_in:United States, connections:People who like Being Patriotic, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2703 343 https://www.facebook.com/patriototus/ The Obama Administration turned a great idea of fighting terrorism into drawing our country into another regime Change venture. Our military presence in Syria now doesn’t serve American interests. Our soldiers are there to fight and die for Globalists, Saudis and Israelis, but not for Americans. And that’s why we keep on talking about it: this policy is directly opposite to the “America First” concept. I believe Trump can fix it, just like he promised. Sadly days after days and weeks after weeks of Trump’s presidency there are no Changes in that direction. Israel captured a Syrian region named Golan Heights in 1967, and today this land is internationally considered to be occupied territory. Israelis want to use Trump’s influence so the world would acknowledge Israeli sovereignty. Trump is a dealer, and maybe he’s trying make a deal out of it, but there’s one important thing here: under no Circumstances can our soldiers’ lives be put at risk for that. So many times during the presidential campaign Trump said “let’s bring back our soldiers home”, and now it’s really time to do it. This is not our war. 3.2 200.00 RUB 2017-05-23T07:06:22-07:00 2017-05-24T12:30:00-07:00
768 location_living_in:United States, connections:People who like Being Patriotic, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 4604 453 https://www.facebook.com/patriototus/ Middle East wars are one of the reasons why we are in $20 trillion debt today. We could have solved thousands of economic and security problems by simply rejecting the aggressive military policy we’ve been having for so long. Iraq war didn’t end terrorism, and didn’t solve the Islamization problem. If we repeat the same war in Syria, we’ll only get the same result: no profit for American Citizens and several thousands of dead American soldiers. Globalists, terrorists and Corporations are the only ones who benefit from oil wars. 8.0 500.00 RUB 2017-05-19T07:20:22-07:00 2017-05-20T16:30:00-07:00
769 location_living_in:United States, connections:People who like Being Patriotic, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 5186 502 https://www.facebook.com/patriototus/ Our politicians should never forget that. We’ve been watching our military commandership wasting lives of American soldiers for too long, let’s hope it will end now when Trump is in Charge. A new Marine Corps artillery unit was sent to assist Syrian opposition in Raqqa, according to Army Maj. Josh T. Jacques, a spokesman for US. Central Command. The artillery unit recently replaced about 400 Marines from the 11th Marine Expeditionary Unit, which provided artillery support to Kurdish and Syrian Arab forces expected to launch an offensive against Raqqa. We must deal with ISIS and end the terrorist threat once and for all. Unfortunately that’s hardly possible because of the corruption in the Government. The Swamp in DC is still not drained from people like Senator McCain, and that’s why our troops not only focus on defeating terrorism, but also getting involved into another regime Change venture and possibly another oil war. We’re fighting radical Islamists, but we’re also siding with Syrian opposition, the very same radical Islamists, and there’s absolutely no guarantee that these rebels won’t replace ISIS when it’s gone. There’s only one Chance to avoid another Iraq: Trump and the American nation must defeat globalist politicians and the Establishment. All we can do now is to pray for all American soldiers to return back home alive and safe. 8.0 500.00 RUB 2017-05-18T07:14:21-07:00 2017-05-19T07:30:00-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 1346.444ms · Data source: simonw/russian-ira-facebook-ads-datasette