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 created

View and edit SQL

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ▼ ended
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  
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  
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  
438 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 815 39 https://www.facebook.com/patriototus Patriotism comes from your heart... follow its dictates and don't live a false life. Join! 12.78272 798.92 RUB 2015-06-23T07:09:49-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  
505 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 742 59 https://www.facebook.com/patriototus Your freedom starts here. Join! 6.9524799999999995 434.53 RUB 2015-06-23T07:10:04-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  
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  
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  
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
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
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
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
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
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
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
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  
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  
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  
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
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
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
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
743 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 2900 275 https://www.facebook.com/timetosecede/ This page is about our best state! Lone Star of Blessed America! 33.99808 2124.88 RUB 2015-09-22T07:39:21-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  
729 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 717 83 https://www.facebook.com/Heart-of-Texas-761114847343674/timeline/ This page is about our best state! Lone Star of Blessed America! 10.7288 670.55 RUB 2015-09-22T07:39:28-07:00  
747 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 597 42 https://www.facebook.com/timetosecede/ There are so many reasons to live and love Texas! Join to find out! 7.36144 460.09 RUB 2015-09-22T07:41:18-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  
727 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 1035 103 https://www.facebook.com/Heart-of-Texas-761114847343674/timeline/ There are so many reasons to live and love Texas! Join to find out! 11.86224 741.39 RUB 2015-09-22T07:41:23-07:00  
722 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 15808 1521 https://www.facebook.com/timetosecede/ When you live in Texas you know that you are the Chosen one! 152.20352 9512.72 RUB 2015-09-22T07:42:20-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  
741 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 439 38 https://www.facebook.com/timetosecede When you live in Texas you know that you are the Chosen one! 6.389600000000001 399.35 RUB 2015-09-22T07:42:26-07:00  
745 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 175705 18083 https://www.facebook.com/timetosecede/ Best state in US! Should I say more? 1894.93632 118433.52 RUB 2015-09-22T07:42:46-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  
739 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 36702 3868 https://www.facebook.com/timetosecede/ Best state in US! Should I say more? 497.66464 31104.04 RUB 2015-09-22T07:42:53-07:00  
737 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 6687 689 https://www.facebook.com/timetosecede/ Best state in US! News, fun, events! Subscribe! 85.87183999999999 5366.99 RUB 2015-09-22T07:43:19-07:00  
735 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 2792 272 https://www.facebook.com/timetosecede/ Best state in US! News, fun, events! Subscribe! 42.34176 2646.36 RUB 2015-09-22T07:43:22-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  
718 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 68285 8733 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ and ur heart! 767.93664 47996.04 RUB 2015-09-22T07:44:09-07:00  
733 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 956 76 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ and ur heart! 10.8976 681.10 RUB 2015-09-22T07:44:13-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  
731 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 61357 4612 https://www.facebook.com/timetosecede/ Heart of Texas! Time to secede! 593.2712 37079.45 RUB 2015-09-22T07:44:43-07:00  
701 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 12334 1290 https://www.facebook.com/timetosecede/ Heart of Texas! Time to secede! 129.19792 8074.87 RUB 2015-09-22T07:44:46-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  
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
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
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
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

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