home / russian-ads

display_ads (view)

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

27 rows where an ad_target was excluded_connections:Exclude people who like Being Patriotic

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
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  
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  
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  
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  
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
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
461 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 3079 482 https://www.facebook.oom/Being-PatriotiC-1601685693432389/ A very touching story. Roberto Gonzalez, a dying Vietnam veteran from Texas made this special request last weekend. Hospital staff and Roberto’s family arranged his final meeting with two horses. Gonzalez was paralyzed in Vietnam during his service. He gave his health away in the name of America like thousands of our brave soldiers did. Unfortunately no one can return their health and lives back. Our best people have to live the shortest lives. If only our Government could pay more attention to our heroes’ problems to make them a bit happier and to make their heroic lives a bit longer. 6.74016 421.26 RUB 2016-05-25T06:56:33-07:00 2016-05-26T06:56:32-07:00
464 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 3268 743 https://www.facebook.oom/Being-PatriotiC-1601685693432389/ Marine veteran was forced by homeowner associations to remove USMC stickers from his car. Our country is run by idiots! Retired marine Frank Larison recently received a letter by the HOA, ordering him to remove his “marine stickers” from his Chevy car. Frank and his lawyer Claim that he will face $50 a day if he refuses to do so. If he does not play those fines, he will be towed. Have you ever heard of someone receiving a notification to remove Obama stickers? LGBT stickers? Those terrorists Black Lives Matter stickers? Well, me neither! The liberal rage comes only to those who love the Old Glory or US. Armed Forces. Our whole society is ill. Libtards are allowed to do whatever they want while even the smallest demonstration of love and devotion to America causes an immediate intervention from the authorities. 8.0 500.00 RUB 2016-05-19T05:12:18-07:00 2016-05-20T05:12:16-07:00
475 location_living_in:united_states:New York (+50 mi) New York, excluded_connections:Exclude people who like Being Patriotic, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Young Republicans, people_who_match:interests:2nd Amendment, people_who_match:interests:National Rifle Association, people_who_match:interests:Donald Trump, people_who_match:interests:Republican Party (United States), people_who_match:interests:Gun Owners of America or Donald Trump for President, people_who_match:interests:Employers: NYPD, people_who_match:interests:US., army_reserve_industry:Military (Global) or Veterans (US), army_reserve_industry:Politics: US politics (conservative), army_reserve_industry:US politics (very conservative) 4171 551 https://www.facebook.com/events/365162297165103/ Donald John Trump was elected the 45th president of the United States on Tuesday! Today some massive crowds of libtards marched in NYC against election of Donald Trump. Come to Trump Tower (725 5th Ave) on Saturday to show Mr. Trump there actually ARE people in NY who voted for him! Support Trump in NYC 31.9904 1999.40 RUB 2016-11-10T05:00:07-08:00 2016-11-11T21:00:00-08: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  
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  
524 location:united_states:New York (+40 km) New York, interests:Independence, interests:Veterans Day, interests:Patriotism, interests:Remembrance Day, 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 5253 259   62.022400000000005 3876.40 RUB 2016-08-23T04:59:14-07:00 2016-08-25T04:59:10-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
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
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
544 location:Russia, interests:Israel, interests:United States Army, interests:Politics and social issues, 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 Being patriotic means love or devotion to your homeland and readiness to defend it from 0.0 0.00 USD 2015-09-28T06:49:14-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  
762 location_living_in:United States, excluded_connections:Exclude people who like Being Patriotic, age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Fly the American Flag, people_who_match:interests:America the Beautiful, people_who_match:interests:American Patriots, people_who_match:interests:| Love the USA, people_who_match:interests:Proud to be an American, people_who_match:interests:Patriot Nation, people_who_match:interests:Flag of the United States, people_who_match:interests:American Patriot or American patriotism, people_who_match:interests:, employers:Proud to be an American, and_must_also_match:politics:Likely to engage with political content (conservative) 1828 141 https://www.facebook.com/patriototus/ "Patriotism is looking out for yourself by looking out for your country" - Calvin Coolidge. Being Patriotic 16.09856 1006.16 RUB 2017-05-16T01:35:01-07:00  
763 location_living_in:United States, excluded_connections:Exclude people who like Being Patriotic, age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Right-wing politics, and_must_also_match:interests:Fly the American Flag, and_must_also_match:interests:America the Beautiful, and_must_also_match:interests:American Patriots, and_must_also_match:interests:| Love the USA, and_must_also_match:interests:Proud to be an American, and_must_also_match:interests:Patriot Nation, and_must_also_match:interests:American Patriot, and_must_also_match:interests:American patriotism 0 0 https://www.facebook.com/patriototus/ "Patriotism is looking out for yourself by looking out for your country" - Calvin Coolidge. Being Patriotic 0.0 0.00 USD 2017-05-18T02:33:00-07:00  
764 location_living_in:United States, excluded_connections:Exclude people who like Being Patriotic, age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Right-wing politics, and_must_also_match:interests:Fly the American Flag, and_must_also_match:interests:America the Beautiful, and_must_also_match:interests:American Patriots, and_must_also_match:interests:| Love the USA, and_must_also_match:interests:Proud to be an American, and_must_also_match:interests:Patriot Nation, and_must_also_match:interests:American Patriot, and_must_also_match:interests:American patriotism 11717 1452 https://www.facebook.com/patriototus/ Supporting the Old Glory, the Constitution and traditional values. God bless America! Being Patriotic 110.94144 6933.84 RUB 2017-05-18T02:36:10-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  

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