home / russian-ads

display_ads (view)

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

17 rows where search matches "patriot"

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
330 no image location:united_states:Baltimore Maryland, location:united_states:Ferguson, St. Louis Missouri, location:united_states:Cleveland Ohio, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 524 24 https://www.facebook.com/BlaCk-Matters-1579673598947501/ American Racists On The Road The racists group of America "Back To The Blue" are organizing a hate rally in response to the public outcry and protests against police officers. "Bikers-patriots" want to descend on the McKinney Police HQ in a show of solidarity for the police because race-baiters and cop-haters. They plan to have "the biggest thing to happen in Patriot Movement since the Bundy Ranch victory!" It seems like we won't get into "post-racial America".... this event and the regular murder of innocent Black Children by white supremacist police and Citizens makes that Clear. The modern government has brought racist America to the forefront, good or bad. This is something that America has a serious issue with - RACISM! Is it time to call out the national guard? 1.4152 88.45 RUB 2015-06-15T07:22:00-07:00 2015-06-16T07:21:59-07:00
431 location:United States, 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 1813 268 https://www.facebook.com/patriototus Barack Obama and his team have spent two months working to secure 41 percent for Iran deal. And now they Claim enourmous victory. Under the Constitution, treaties require the support of two-thirds of the Senate. The deal with Iran is a treaty in every respect — a legally binding long- term agreement between sovereign powers, in which hundreds of billions of dollars will flow and billions of dollars in nuclear materiel will be destroyed. Since this is a treaty and we have 100 senators, Obama should have been obliged to secure the backing of 67 senators, not 41. Obama knows he can never get Iran deal through the Congress. Americans voted for the GOP in 2014 to provide Republican majority in both the House of representatives and the Senate. It has to stop crazy ideas of Obama. But Obama is not stupid, he is very crafty politician. He succeded to Change a subject to a vote — not of approval, like a treaty, but of disapproval. It would be treated like any piece of legislation. It would be voted on by the House and the Senate, and if they turned thumbs-down, he could then exercise his presidential veto. The Constitution requires a second vote by the two Houses of Congress to overturn such a veto — and in that case, the vote has to be by two-thirds. So, instead of 67 Senators having to support the deal to make it legal, 67 senators have to disapprove of it to render it null and void. It is enough 60 or more Senators to overturn a veto. But you remember, 41 Senators agree to support the deal. Thus, it may well be that for the first time in American history, a president will simply impose a treaty on the country without even the pretense of seeking and obtaining the advice and consent of the Congress. And how? With 42 percent. Barack Obama is very smart man, but he is not a patriot. He doesn’t care about Americans. All what he cares is his outsized ambitions. 6.3304 395.65 RUB 2015-09-10T03:48:38-07:00 2015-09-11T03:48:37-07:00
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
450 location:United States, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Being Patriotic, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 529205 72043 https://www.facebook.com/patriototus/ United We Stand! Welcome every patriot we can reach. Flag and news! 5306.812 331675.75 RUB 2015-06-23T00:41:02-07:00  
451 location:United States, excluded_connections:Exclude people who like Being Patriotic, 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:Independence, people_who_match:interests:Patriotism 99946 11684 https://www.facebook.com/patriototus/ United We Stand! Welcome every patriot we can reach. Flag and news! 578.5600000000001 36160.00 RUB 2016-09-15T02:50:06-07:00  
452 location:United States, 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 1383 124 https://www.facebook.com/patriototus This man pedaled from Mission beach, San Diego all the way to the east coast carrying this great flag! He rode in memory of all the fallen troops and got it signed by service members along the way. It is very common among service members to sign flags for each other. This man is a true patriot, and we should be proud of that there are such people in America! 4.64 290.00 RUB 2015-07-17T06:42:47-07:00 2015-07-19T06:42:46-07:00
492 location_living_in:United States, 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 2083 291 https://www.facebook.com/patriototus Sometimes people say | criticize the government too much. They say I can’t see positive moments. In fact, I see all good things in the United States, and I’m proud to be an American. But I reckon that I can’t have the right to keep silence when outrageous things happen. I can’t keep silence while stupid idiots forbid our Children to wear patriotic Clothes. I can’t keep silence while Obama creates comfortable conditions for terrorists, accepting of 10,000 Syrian refugees. I can’t keep silence while liberals spit on the US. Constitution. Yes, | criticize everything what is unacceptable for the nation. If Americans turn a blind eye to outrageous things, enjoying only positive moments of their lives, we will never live better. Criticism is a way for development. I’m a patriot, that’s why I criticize. 2.64208 165.13 RUB 2015-10-19T08:03:24-07:00 2015-10-20T08:03:23-07:00
506 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 29 5 https://www.faoebook.com/patriototus Why am | against individuals who live in the United States illegally? On the one hand, I have nothing against foreigners. On the other hand, I love the United States very much. If the government gives an amnesty to them who broke the immigration law, it doesn’t respect Americans who love their country. Why Citizens cannot break the law, but illegals can? What nonsense! Illegal immigrants work illegally and they don’t pay taxes. Many of them commit a crime. And the police have no their finger prints because illegals have never obtained US. visa. If people want to live in the United States, they should require U.S. residence permit. Illegals should not be amnestied. How can we be the greatest nation in the world, if we don’t respect our law? I am against illegals not because I am Chauvinist, but because I am patriot! 0.17696 11.06 RUB 2015-09-01T23:58:28-07:00 2015-09-02T23:58:28-07:00
516 location:United States, 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 1318 222 https://www.facebook.com/patriototus The US. Constitutional Convention signed and adopted the Constitution at Philadelphia's Independence Hall 228 years ago. Since then the US. Constitution has been amended twenty-seven times. All of amendments are steps that made the United States the greatest country in the world. The US. Constitution is not only the law, it is the basis of the country. Every true patriot respects it. Unfortunately, last decade has become the time of nihilism. More and more people don’t respect American law. More and more people come to the United States and some of them don’t feel reverence for our Constitution. It goes without saying that illegals who already broke the immigration law and will violate the supreme law easily. But the worst thing is that the current president of the United States and some high-ranking officials also spit upon the Constitution. They call for ban the right to bear arms, a confederate flag (I think this flag reflects not slavery, but important part of American history) and some liberals ban even the Old Glory -- a school district in Tennessee has banned all flags and banners, including the US. flag -- and so on. The same regards the lran deal. America has a hard time. And we have to save the US. Constitution. We have to do it in God’s name! America has to be great again because we are one nation under God! 5.61856 351.16 RUB 2015-09-17T07:28:27-07:00 2015-09-18T07:28:26-07:00
531 location_living_in:United States, 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 129 32 https://www.facebook.com/Being-PatriotiC-1601685693432389/ Remember that terrible case when a student was forced by York Comprehensive High School officials to remove the Old Glory from his pickup? It happened in May 2015 and luckily had a happy end, as a result the students were allowed to attach our flag to their vehicles. The story ended well by efforts of dozens of patriots united to protest against High School authorities. It was a peaceful but strong and confident protest that made the authorities listen, it was a great example of how conscious people should act. We have to keep ready to stand against all kinds of attacks on American values and Constitutional |aws. Unfortunately our current Government approves and even provokes these attacks, and the liberals’ offensive and violent moods make it Clear — every American patriot has to be careful and attentive. 0.27584 17.24 RUB 2016-05-10T08:12:26-07:00 2016-05-11T08:12:25-07:00
713 location_living_in:United States, interests:Automobiles, interests:BMW, interests:Used car, interests:Car dealership, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 139 4 https://www.facebook.com/Heart-of-Texas-761114847343674/timeline/ Drive like a patriot! 0.96 60.00 RUB 2015-09-11T03:39:42-07:00 2015-09-12T03:39:41-07:00
1250 location_living_in:United States, age:18 - 65+, placements:Instagram Feed 19765 21 https://www.instagram.com/instotus/ We are honored to be the main and the biggest American Instagram account! Follow @instotus for the best patriotic imagery and US. latest news exclusives. This is a community for everyone whose heart is with America. Don't be a stranger, be a patriot! Follow us! 7.65888 478.68 RUB 2015-10-08T00:39:23-07:00 2015-10-09T23:59:59-07:00
1267 location_living_in:United States, age:18 - 65+, placements:Instagram Feed 0 0 https://www.instagram.com/instotus/ We are honored to be the main and the biggest American Instagram accountlFollow @instotus for the best patriotic imagery and US. latest news exclusives. This is a community for everyone whose heart is with America. Don't be a stranger, be a patriot! Follow us! 0.0 0.00 USD 2015-10-07T01:15:58-07:00 2015-10-08T21:59:59-07:00
1608 location_living_in:United States, interests:Politics, age:18 - 65+, language:English (US), placements:Instagram Feed 0 0 https://www.instagram.com/instotus/ We are honored to be the main and the biggest American Instagram account! Follow @instotus for the best patriotic imagery and US. latest news exclusives. This is a community for everyone whose heart is with America. Don't be a stranger, be a patriot! Follow us! 0.0 0.00 USD 2015-10-06T02:08:02-07:00 2015-10-07T23:59:59-07:00
1934 location_living_in:United States, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Young Republicans, people_who_match:interests:Support Our Veterans, people_who_match:interests:Donald Trump for President, people_who_match:interests:Fox News Politics, people_who_match:interests:conservative daily, people_who_match:interests:Donald Trump Jr. or Supporting OurVeterans, people_who_match:interests:Politics: US politics (conservative), people_who_match:interests:US politics (very conservative), people_who_match:interests:Likely to engage with political content (conservative) 15738 150 https://www.instagram.com/instotus/ Join our AmericaAgainstHillary flashmob! Make a sign with your state - make Clinton see that we DON'T WANT her! Follow instotus for participation. This is a community for everyone whose heart is with America. Don't be a stranger, be a patriot! Follow us! Instagram Of The United Instotus 54.164320000000004 3385.27 RUB 2016-07-20T06:44:47-07:00  
1936 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Proud to be an American, people_who_match:interests:Patriot Nation, people_who_match:interests:ForAmerica, people_who_match:interests:Patriotism 22567 92 https://www.instagram.oom/instotus/ We are Patriots. We fight for the traditions, for the National Symbols and for the Future. If you don't like the liberal ideas and you are not the one who supports gun control, gay marriage and black lives matter activists. If America is more than just a country for you, we want you to join us! This is a community for everyone whose heart is with America. Don't be a stranger, be a patriot! Follow us! Instagram Of The United Instotus 58.899680000000004 3681.23 RUB 2016-05-06T07:29:40-07:00  
1947 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Patriot (American Revolution), people_who_match:interests:Tea Party Patriots 21912 86 https://www.instagram.com/instotus/ Instagram Of The United StatesDon't be a stranger, be a patriot! Follow us! instotus Instagram Of The United Instotus 94.94976 5934.36 RUB 2016-03-16T07:43:24-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 1299.627ms · Data source: simonw/russian-ira-facebook-ads-datasette