Data source: simonw/russian-ira-facebook-ads-datasette
This data as JSON, CSV (advanced)
| 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 |
CREATE VIEW display_ads AS
select ads.id,
case when image is not null then
json_object("img_src", "https://raw.githubusercontent.com/umd-mith/irads/master/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