home / russian-ads

display_ads (view)

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

85 rows where an ad_target was interests:Independence sorted by spend_usd

View and edit SQL

id img targeting impressions clicks url text spend_usd ▼ spend_amount spend_currency created ended
18 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, language:English (US), placements:Instagram Feed 0 0 https://instagram.Com/veterans_us/ What do you know about PTSD? There is no greater agony. PTSD affects a person's memory, emotional responses, intellectual processes and nervous system. Nearly 31% of veterans fight this agony every day. Do you want to learn more? Click here! Veterans USA ( @veterans GovSpending 0.0 0.00 USD 2015-11-19T05:18:16-08:00 2015-11-21T10:28:00-08:00
30 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, language:English (US), placements:Instagram Feed 0 0 https://instagram.Com/veterans_us/ Click learn more! People don't want to look at the homeless. But maybe they will look at, or think about, or support dealing with homelessness once they know that 12% of the homeless adult population are veterans. Join us! Veterans USA ( @veterans GovSpending 0.0 0.00 USD 2015-11-19T05:20:22-08:00 2015-11-21T10:28:00-08:00
447 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 0 0 https://www.facebook.com/patriototus We can’t all be Presidents, but we can all be patriots. Join us! 0.0 0.00 USD 2015-06-23T07:08:59-07:00  
453 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 0 0 https://www.facebook.com/patriototus We can’t all be Presidents, but we can all be patriots. Join us! 0.0 0.00 USD 2015-06-23T07:08:58-07:00  
481 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 0 0 https://www.facebook.com/patriototus Patriotism begins at home. Join new community about homeland! 0.0 0.00 USD 2015-06-23T07:10:47-07:00  
484 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 0 0 https://www.facebook.com/patriototus Patriotism comes from your heart... follow its dictates and don't live a false life. Join! 0.0 0.00 USD 2015-06-23T07:09:49-07:00  
504 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 0 0 https://www.facebook.com/patriototus Patriotism begins at home. Join new community about homeland! 0.0 0.00 USD 2015-06-23T07:10:47-07:00  
520 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 0 0 https://www.facebook.com/patriototus Your freedom starts here. Join! 0.0 0.00 USD 2015-06-23T07:10:04-07:00  
545 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/patriototus The stars at night truly are big and bright in Texas. Good morning USA! 0.0 0.00 USD 2015-09-28T06:46:33-07:00 2015-09-29T06:46:32-07:00
551 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/patriototus Republican strategist Karl Rove said on “Fox News Sunday” the only way to stop gun-related violence, like the Wednesday massacre at Emmanuel African Methodist Church in Charleston 8.0., was to repeal American Citizens’ Second Amendment rights. It’s strange to hear it from the man who supported 2nd amendment earlier. The lack of Clear-Cut opinion is very bad Character trait. However, it doesn’t matter. The right to bear arms is inalienable right of Americans that was given us by the Founding Fathers. The 2nd amendment guarantees private safety of the people. The right to keep and bear arms has been recognized as existing prior even to the creation of a written national constitution. The governmnet should respect the 2nd amendment and the law in general. It’s pity when some politicians think othen/vise. People should understand that a gun is not a killing tool, it’s seIf-defense tool. And we will stand for our right to keep and bear arms! 0.0 0.00 USD 2015-06-23T07:13:22-07:00 2015-06-24T07:13:22-07:00
552 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/patriototus The Chinese hackers executed a complex attack that gave them “administrator privileges” into the computer networks at the Office of Personnel Management, mimicking the credentials of people who run the agency’s systems. They began siphoning out a rush of data after constructing what amounted to an electronic pipeline that led back to China, investigators told Congress last week in classified briefings. Much of the personnel data had been stored in the lightly protected systems of the Department of the Interior, because it had Cheap, available space for digital data storage. The administration is urgently working to determine what other agencies are storing similarly sensitive information with weak protections. Officials would not identify their top concerns, but an audit issued early last year, before the Chinese attacks, harshly criticized lax security at the Internal Revenue Service, the Nuclear Regulatory Commission, the Energy Department, the Securities and Exchange Commission — and the Department of Homeland Security, which has responsibility for securing the nation’s critical networks. It's not Clear who is held liable for security hole. What do you think the hacker attack will affect U.S. — Chinese relations? 0.0 0.00 USD 2015-06-23T07:14:41-07:00 2015-06-24T07:14:41-07:00
553 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/patriototus The Battle of Okinawa, codenamed Operation Iceberg, came to the end on June 22, 1945. The operation was fought on the Ryukyu Islands of Okinawa and included the largest amphibious assault in the Pacific War during World War II. The military value of Okinawa "exceeded all hope." Okinawa provided a fleet anchorage, troop staging areas, and airfields in Close proximity to Japan. 0.0 0.00 USD 2015-06-23T07:37:18-07:00 2015-06-24T07:37:18-07:00
554 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/patriototus Since the game of American football was first played at the collegiate level in the late 1860s, the sport has captivated fans by using both strength and strategy to get the win. With the introduction of the American Professional Football Association, later renamed to the National Football League, audiences saw athletes play more ferociously than ever before. American football has actually became national kind of sports in the United States. We are proud of such players as Michael Vick, Peyton Manning and John Elway. We are proud we live in America! 0.0 0.00 USD 2015-06-23T07:13:53-07:00 2015-06-24T07:13:52-07:00
555 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/patriototus It is a symbol of patriots who were willing to die in order to protect this country and to make sure it has remained as the founders intended. South Carolina governor calls for removal of Confederate flag from statehouseGovernor Nikki Haley makes abrupt about-face in wake of Charleston killings to call for removal of flag that has flown on statehouse grounds for 50 years The Confederate flag represents heritage, not hate. The war that is called the "Civil War" was actually the "War for Southern Independence". This is our history and our heritage. Just because certain groups have used the confederate flag in hate related crimes or racism does not make the southern flag racist. Now it is used to show heritage and pride from the south showing that they have been strong and have overcome what has happened to them over time. 0.0 0.00 USD 2015-06-23T08:23:32-07:00 2015-06-24T08:23:32-07:00
556 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/patriototus Why do immigrants think that the US. government should create good conditions for them? I think immigrants should prove that they are deserved to stay in the United States. Why should we give a Citizenship to those who cannot give something good for the nation? The worst thing is that illegal immigrants who broke the law to live in the United States demand ask for indulgences. What nonsense! Illegals should be deported from the country invariably. But Obama’s administration is tied to the chariot of immigrants. Democrats know that immigrants will vote for the Democratic party. Especially former illegals. That’s why Barack Obama tries to give the Immigration Amnesty to illegals as soon as possible. It will allow to increase a number of votes for a Democratic Party presidential candidate in 2016. And democrats don’t care about the fact that most of immigrants will become welfare recipients, increasing unemployment rate. America doesn’t need immigrants, democrats do. What’s more important: to win Presidential elections in 2016 or to make America better? Democrats seem to Choose first option. That’s what differs republicans from democrats. 0.0 0.00 USD 2015-06-23T07:37:02-07:00 2015-06-24T07:37:02-07:00
557 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/patriototus Our flag is one with colors every so bright A symbol of goodwill and all that's right It is a beacon for those who are oppressed Who pine to live in the land of the blessed The photo of the Apollo 15 space shuttle on the Moon is historic moment in the history of the world. This was the first time that a man stepped foot on the Moon. 0.0 0.00 USD 2015-06-23T07:13:03-07:00 2015-06-24T07:13:03-07:00
558 location:United States, interests:Independence, interests:Patriotism, excluded_connections:Exclude 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/patriototus We can’t all be Presidents, but we can all be patriots. 0.0 0.00 USD 2015-07-01T02:24:19-07:00  
559 location:United States, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Being Patriotic, age:18 - 65+, placements:on pages: Right column on desktop computers, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Third-party Apps and Websites on mobile devices 0 0 https://www.facebook.com/patriototus The most patriotic page you've seen! 0.0 0.00 USD 2015-07-01T02:23:25-07:00  
560 location:United States, interests:Independence, interests:Patriotism, excluded_connections:Exclude 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/patriototus The most patriotic page you've seen! 0.0 0.00 USD 2015-07-01T02:23:49-07:00  
728 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
730 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
732 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
734 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
736 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
738 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
740 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
742 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
744 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
746 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
748 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ, and ur heart 0.0 0.00 USD 2016-10-11T07:47:39-07:00  
751 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Heart-of-Texas-761114847343674/ Obama is a total hypocrite and a liar! He visited the Dallas memorial service to blame us of racism. He just had to turn a ceremony honoring the fallen officers into a disgraceful. He doesn't care about fallen officers! Obama is not our leader! Texans have already honored our heroes, laying flowers at Dallas police headquarters. But Obama's speech did not make sense at all. That's why we have to support all police officers who refused to applaud Obama. Taking sides with these rioters and racists, Obama literally called for open war against police officers and whites. He came there and he lectured officers who are targeted every day for assassination by Black Lives Matter that they need to Change. Kick this asshole out of Texas! 0.0 0.00 USD 2016-07-14T00:54:14-07:00 2016-07-15T00:54:13-07:00
755 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede Best state in US! Should I say more? 0.0 0.00 USD 2015-09-22T07:42:50-07:00  
756 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede/ When you live in Texas you know that you are the Chosen one! 0.0 0.00 USD 2015-09-22T07:42:23-07:00  
757 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede Heart of Texas! Time to secede! 0.0 0.00 USD 2015-09-22T07:44:49-07:00  
758 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede Texas - homeland of guns, BBQ and ur heart! 0.0 0.00 USD 2015-09-22T07:44:15-07:00  
759 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/timetosecede Best state in US! News, fun, events! Subscribe! 0.0 0.00 USD 2015-09-22T07:43:25-07:00  
760 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Heart-of-Texas-761114847343674/timeline/ There are so many reasons to live and love Texas! Join to find out! 0.0 0.00 USD 2015-09-22T07:41:20-07:00  
761 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Heart-of-Texas-761114847343674/timeline/ This page is about our best state! Lone Star of Blessed America! 0.0 0.00 USD 2015-09-22T07:39:25-07:00  
3519 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 0 0 https://www.facebook.com/patriototus Best patriotic page ever! Join! 0.0 0.00 USD 2015-07-08T05:49:40-07:00  
529 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 4 0 https://www.facebook.com/Being-PatriotiC-1601685693432389/ Iraq, Syria, Libya — several years of fails in the Middle East diplomacy. May I remind you Hillary had a long time to show her foreign policy skills — being a Secretary of State she had quite enough of political powers. How can anyone support her? Voting for Hillary is just burying the American image in the world. 0.12656 7.91 RUB 2016-05-11T02:23:34-07:00 2016-05-12T02:23:33-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
498 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 284 20 https://www.facebook.com/patriototus This boy's love of country brings tears to my eyes. United we stand! 0.7460800000000001 46.63 RUB 2015-07-10T08:41:09-07:00 2015-07-11T08:41:08-07:00
489 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 538 25 https://www.facebook.com/patriototus “It is not always the same thing to be a good man and a good Citizen.” Aristotle 1.62752 101.72 RUB 2015-07-10T07:56:23-07:00 2015-07-11T07:56:23-07:00
482 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 699 113 https://www.facebook.com/patriototus What is the second amendment for you? It’s not just the right to bear arms. It’s respect to American history. The Founding Fathers were very smart people. And it may be assumed they were smarter than many liberals. The second amendment is deterrent. If a criminal knows you have a gun, he doesn’t want to rob you. Of course, not all Americans have a gun, but criminals don’t know who is unarmed. Liberals can say that guns increase crime rate. In fact, it is nonsense. Look at statistics: the most gun-friendly state is Wyoming, and it has low crime-rate. The states with high crime rate are states where there are many illegals as usual. So, liberal hysteria is just foolishness. Liberals find reasons of crimes in wrong places. The US. Constitution should be saved. Do you agree? 1.98 123.75 RUB 2015-09-01T07:41:24-07:00 2015-09-02T07:41:24-07:00
527 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 471 78 https://www.facebook.com/Being-PatriotiC-1601685693432389/ If a Republican doesn’t like guns he doesn’t buy one. If a Democrat doesn’t like guns he wants all guns outlawed. We all know the Supreme Court is now under a threat of receiving anti-gun majority ofjudges. Only a conservative President can stop this madness. Don’t let the Democraps take away your Constitutional right! Vote Republican, vote Trump, and support the Second Amendment! 2.6513600000000004 165.71 RUB 2016-05-19T05:12:56-07:00 2016-05-20T05:12:55-07:00
460 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 2192 351 https://www.facebook.oom/Being-PatriotiC-1601685693432389/ Today is a good day to honor our Navy forces. 72 years ago our ships took part in operation “overlord”, landing our forces in Europe. We can’t say we have brilliant commandership now, but our soldiers are as brave as our grandfathers were. Our sailors not only fight our enemies in the seas and oceans, they also Challenge the water elemental itself, sailing for months without seeing the shores of their home. God bless the US. Navy! 3.2 200.00 RUB 2016-06-07T04:49:01-07:00 2016-06-08T04:49:00-07:00
528 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 1929 458 https://www.facebook.com/Being-PatriotiC-1601685693432389/ Wow, this kind of gun control could prevent dangerous mentally ill idiots from buying guns! Isn’t it the great Democratic desire to “secure the society”? Speaking seriously: only two kinds of people shouldn’t be allowed to bear arms: criminals and psychopaths. Since we are none of those — never dare to take our rights and guns away! 4.3696 273.10 RUB 2016-05-11T02:25:27-07:00 2016-05-12T08:30:01-07:00
711 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 1954 368 https://www.facebook.com/Heart-of-Texas-761114847343674/ Austin’s Robert E. Lee Elementary school has a new name: Russell Lee. The Austin School Board voted 8-1 to Change the name Monday night.The school board had three name options from which to Choose: Russell Lee, a photographer from the school’s neighborhood who started UT’s photography program. The board approved Russell Lee at the request of the school’s Campus Advisory Council. So, what can I say? This is a disgrace for the Texas authorities! I am shocked at the dismantling of southern history. We know that our ancestors fought for our freedom. These names were, are and always will be the part of Texas history. Why is Texas administration willing to do anything what feds say them? Isn't it obvious that the Federal government aims to destroy our history? This is a madness! Therefore, I need to ask you: are you ready to defend our Heritage? The Southern history needs protection now more than ever before! 4.8 300.00 RUB 2016-05-25T07:22:16-07:00 2016-05-26T07:22:15-07:00
454 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 2198 441 https://www.facebook.com/Being-PatriotiC-1601685693432389/ Every American’s right to bear arms is absolutely sacred, period. All the liberal attacks on it are very worrying because the Amendment was not only made for self defense — it is a nation’s ability to overthrow the tyranny. A Government that doesn’t trust its Citizens to possess weapons can never receive mutual trust or respect. And that’s what things are now — there’s a great mistrust between the people and the country Administration and the only way for our “leaders” to establish relations with Americans is to stop all attacks on the Second Amendment. 5.13312 320.82 RUB 2016-05-11T02:24:04-07:00 2016-05-12T02:24:03-07:00
17 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, language:English (US), placements:Instagram Feed 1872 2 https://instagram.Com/veterans_us/ What do you know about PTSD? There is no greater agony. PTSD affects a person's memory, emotional responses, intellectual processes and nervous system. Nearly 31% of veterans fight this agony every day. Do you want to learn more? Click here! Veterans USA ( @veterans GovSpending 5.86256 366.41 RUB 2015-11-18T02:43:22-08:00 2015-11-21T10:28:00-08:00

Next page

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 1646.613ms · Data source: simonw/russian-ira-facebook-ads-datasette