home / russian-ads

display_ads (view)

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

25 rows where an ad_target was age:14 - 65+

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
16 location:United States, age:14 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Wounded Warrior Project, people_who_match:interests:Support our troops, people_who_match:interests:Veterans, people_who_match:interests:AMVETS, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Chris Kyle, people_who_match:interests:Supporting Our Veterans, and_must_also_match:interests:Paralyzed Veterans of America, and_must_also_match:interests:Veterans Day, and_must_also_match:interests:Wounded Warrior Project, and_must_also_match:interests:Support our troops, and_must_also_match:interests:Veterans, and_must_also_match:interests:AMVETS, and_must_also_match:interests:United States Army Reserve, and_must_also_match:interests:Patriotism, and_must_also_match:interests:Disabled American Veterans, and_must_also_match:interests:The Veterans Site, and_must_also_match:interests:Chris Kyle, and_must_also_match:interests:Supporting Our Veterans 21093 53 https://www.instagram.Com/veterahs_us/ A Wounded Warrior and his service dog. Support our Veterans - Follow! The US Gov Spending Stats Instalol 34.10304 2131.44 RUB 2016-05-12T02:37:39-07:00  
20 location:United States, interests:Patriotism, behaviors:facebook_access_(mobile):all mobile devices, age:14 - 65+, language:English (US), placements:Instagram Feed 514 0 https://www.instagram.Com/veterahs_us/ Click Learn More if you really love your country! A small puppy wandered up to US. Marines from Alpha Company. After following the Marines numerous miles, a soft hearted Marine picked the puppy up and carried the puppy in his drop pouch. Veterans USA ( @veterans GovSpending 0.0 0.00 USD 2015-12-16T04:26:55-08:00  
28 location:United States, interests:Tax, behaviors:African American (US), age:14 - 65+, language:English (US), placements:Instagram Feed 15398 46 https://www.instagram.Com/gov_spending/ How to know the truth? Click learn more! Wouldn't it be better to solve the internal problems first? The US Gov Spending Stats Instalol 33.12672 2070.42 RUB 2015-12-16T06:45:58-08:00  
37 location:United States, behaviors:African American (US), age:14 - 65+, language:English (US), placements:Instagram Feed 56837 216 https://www.instagram.com/black_america_today/ Join us to learn more! Why aren't white hoods and white supremacist propaganda illegal here in America? Why are Germans ashamed of their bigotry, while America is proud of it? Black America ( @black 64.49296 4030.81 RUB 2015-12-22T03:42:46-08:00  
38 location:United States, interests:HuffPost Black Voices, behaviors:African American (US), age:14 - 65+, language:English (US), placements:Instagram Feed 24866 95 https://www.instagram.com/black_america_today/ Join us to learn more! Why aren't white hoods and white supremacist propaganda illegal here in America? Why are Germans ashamed of their bigotry, while America is proud of it? Black America ( @black Blacklivessss 28.743840000000002 1796.49 RUB 2016-01-06T01:45:12-08:00  
40 location:United States, interests:Independence, interests:Patriotism, age:14 - 65+, language:English (US), placements:Instagram Feed 12476 25 https://www.instagram.com/veterans_us/ Let's make America great again for the future generations! Click Learn More! Veterans USA ( @veterans GovSpending 19.25616 1203.51 RUB 2016-01-06T03:11:48-08:00  
564 location:united_states:Kansas, interests:LGBT rights by country or territory, interests:Lesbian community, interests:LGBT community, interests:Same-sex marriage, age:14 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1495 73 https://www.facebook.com/events/533144703560571/ Westboro baptist church is planning to stand against tolerance in education system near LG God H85 Bigots Rally 10.7224 670.15 RUB 2016-05-11T07:19:33-07:00 2016-05-22T07:19:00-07:00
617 location:united_states:Kansas, interests:LGBT rights by country or territory, interests:LGBT community, interests:Same-sex marriage, age:14 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 20810 1989 https://www.facebook.com/LGBT-United-839497472793277/ Well, as you know, schools are places of learning and also miniature societies. The school Climate has a direct impact on both how well students learn and how well they interact with other people. More and more teachers today understand the importance of socialization and try to make their Classes more friendly where each student feels involved. But despite these efforts, students who are LGBT continue to face a harsh reality.... May 24,25 Westboro baptist Church is planning to stand against tolerance in education system near LGBT-friendly Lawrence High School. They want to "remind this nation that the parents, students, teachers and staff of the high schools celebrate disobedience to God's law." They are just inciting hate riots and violence! Their right to protest infringes on others rights! Personally I have had enough of those idiots. Someone should picket them (in return)!! Any volunteers willing to help me drown out their voices of hatred? Please, DM us for more information and we can stop their nonsense - to put them on the right way! 117.21648 7326.03 RUB 2016-05-06T08:27:27-07:00 2016-05-12T08:27:26-07:00
618 location:united_states:Kansas, age:14 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Bernie Sanders, people_who_match:interests:LGBT rights by country or territory, people_who_match:interests:LGBT community, people_who_match:interests:Hillary Clinton, people_who_match:interests:Same-sex marriage 0 0 https://www.facebook.com/LGBT-United-839497472793277/ Well, as you know, schools are places of learning and also miniature societies. The school Climate has a direct impact on both how well students learn and how well they interact with other people. More and more teachers today understand the importance of socialization and try to make their Classes more friendly where each student feels involved. But despite these efforts, students who are LGBT continue to face a harsh reality.... May 24,25 Westboro baptist Church is planning to stand against tolerance in education system near LGBT-friendly Lawrence High School. They want to "remind this nation that the parents, students, teachers and staff of the high schools celebrate disobedience to God's law." They are just inciting hate riots and violence! Their right to protest infringes on others rights! Personally I have had enough of those idiots. Someone should picket them (in return)!! Any volunteers willing to help me drown out their voices of hatred? Please, DM us for more information and we can stop their nonsense - to put them on the right way! 0.0 0.00 USD 2016-05-12T08:05:04-07:00 2016-05-12T08:27:26-07:00
619 location:united_states:Kansas, age:14 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Rainbow flag (LGBT movement), people_who_match:interests:LGBT rights by country or territory, people_who_match:interests:LGBT community, people_who_match:interests:Same-sex marriage in the United States, people_who_match:interests:Same-sex marriage, people_who_match:interests:LGBT social movements 0 0 https://www.facebook.com/LGBT-United-839497472793277/ Well, as you know, schools are places of learning and also miniature societies. The school Climate has a direct impact on both how well students learn and how well they interact with other people. More and more teachers today understand the importance of socialization and try to make their Classes more friendly where each student feels involved. But despite these efforts, students who are LGBT continue to face a harsh reality.... May 24,25 Westboro baptist Church is planning to stand against tolerance in education system near LGBT-friendly Lawrence High School. They want to "remind this nation that the parents, students, teachers and staff of the high schools celebrate disobedience to God's law." They are just inciting hate riots and violence! Their right to protest infringes on others rights! Personally I have had enough of those idiots. Someone should picket them (in return)!! Any volunteers willing to help me drown out their voices of hatred? Please, DM us for more information and we can stop their nonsense - to put them on the right way! 0.0 0.00 USD 2016-05-16T07:50:40-07:00 2016-05-12T08:27:26-07:00
620 location:united_states:Kansas, age:14 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:LGBT community 0 0 https://www.facebook.com/LGBT-United-839497472793277/ Well, as you know, schools are places of learning and also miniature societies. The school Climate has a direct impact on both how well students learn and how well they interact with other people. More and more teachers today understand the importance of socialization and try to make their Classes more friendly where each student feels involved. But despite these efforts, students who are LGBT continue to face a harsh reality.... May 24,25 Westboro baptist Church is planning to stand against tolerance in education system near LGBT-friendly Lawrence High School. They want to "remind this nation that the parents, students, teachers and staff of the high schools celebrate disobedience to God's law." They are just inciting hate riots and violence! Their right to protest infringes on others rights! Personally I have had enough of those idiots. Someone should picket them (in return)!! Any volunteers willing to help me drown out their voices of hatred? Please, DM us for more information and we can stop their nonsense - to put them on the right way! 0.0 0.00 USD 2016-05-18T00:12:58-07:00 2016-05-12T08:27:26-07:00
624 no image location:united_states:Kansas, interests:LGBT rights by country or territory, interests:LGBT community, interests:Same-sex marriage, age:14 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/LGBT-United-839497472793277/ Well, as you know, schools are places of learning and also miniature societies. The school Climate has a direct impact on both how well students learn and how well they interact with other people. More and more teachers today understand the importance of socialization and try to make their Classes more friendly where each student feels involved. But despite these efforts, students who are LGBT continue to face a harsh reality.... May 24,25 Westboro baptist Church is planning to stand against tolerance in education system near LGBT-friendly Lawrence High School. They want to "remind this nation that the parents, students, teachers and staff of the high schools celebrate disobedience to God's law." They are just inciting hate riots and violence! Their right to protest infringes on others rights! Personally I have had enough of those assholes. Someone should picket them (in return)!! Any volunteers willing to help me drown out their voices of hatred? Please, DM us for more information and we can stop their nonsense - to put them on the right way! 0.0 0.00 USD 2016-05-06T07:58:41-07:00 2016-05-09T07:58:41-07:00
1487 no image location:united_states:Wilmington Delaware, interests:Cop Block, age:14 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 5098 187 https://www.facebook.com/Dont-Shoot-1157233400960126/ MARCH/PROTEST 108.85072000000001 6803.17 RUB 2016-05-06T06:33:30-07:00 2016-05-20T06:33:00-07:00
1488 no image location:united_states:Wilmington Delaware, age:14 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 10098 404 https://www.facebook.com/Dont-Shoot-1157233400960126/ MARCH/PROTEST 75.38816 4711.76 RUB 2016-05-16T07:15:50-07:00 2016-05-20T06:33:00-07:00
1687 location:United States, age:14 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Humour 113296 778 https://www.instagram.Com/Cop_block_us/ Fed up with police violence? Wanna stop police brutality? Join us! Cop Block Us ( @COp Block AmericanCops 112.29056 7018.16 RUB 2015-12-17T05:21:36-08:00  
1689 location:United States, age:14 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:BuzzFeed, people_who_match:interests:Humour 119733 1256 https://www.instagram.Com/nuts.news/ 5-year-old David Southwick of Cortlandville had an argument with his wife in the parking lot and got into his car trying to run over the woman. He was so pissed off that he intentionally hit 14 vehicles and drove into the porch of a nearby house. Join us to read more funny news! Nuts News ( @nuts.news) Funnylnst 112.57600000000001 7036.00 RUB 2015-12-17T06:43:41-08:00  
1877 no image location:united_states:New York, age:14 - 65+, placements:Instagram Feed, people_who_match:interests:Malcolm X, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Black Church, people_who_match:interests:Louis Farrakhan, people_who_match:interests:Black Panther Party, people_who_match:interests:The Honorable Minister Louis Farrakhan or National Black Police Association (United Kingdom), people_who_match:interests:Field of study: African-American history 10114 9 https://www.facebook.com/Yoyoyoyoyoy-1729293847304592/ Black lives do matter! We want justice or else! Follow us to know the truth! Go to our website to stay abreast of the latest black news in America. ( link in the bio) 35.55936 2222.46 RUB 2016-05-20T04:41:47-07:00  
1880 location:United States, interests:Confederate States of America, interests:American History, age:14 - 65+, language:English (US), placements:Instagram Feed 91968 432 https://www.instagram.Com/south_united/ Many of y'all know that the Civil war was not at all about slavery, it was about freedom and independence from the Union. Click Learn More! South United ( @south Yoyoyoyoyo 277.43647999999996 17339.78 RUB 2016-01-06T06:22:09-08:00  
1886 location:United States, behaviors:facebook_access_(mobile):all mobile devices, behaviors:facebook_access_(mobile):African American (US), age:14 - 65+, language:English (US), placements:Instagram Feed 31110 114 https://www.instagram.Com/black_pride_us/ People, our race is in danger! Together we are an invincible power. Just say your word! Join us! Black Pride ( @black Yoyoyoyoyoy 122.97536000000001 7685.96 RUB 2015-12-17T02:46:47-08:00  
1896 location:United States, interests:History, politics:US politics (conservative), age:14 - 65+, language:English (US), placements:Instagram Feed 16808 113 https://www.instagram.Com/south_united/ Confederate page #1 on Instagram! Learn about our country's history with us! Join us! South United ( @south 54.210879999999996 3388.18 RUB 2015-12-17T02:54:15-08:00  
1918 location:United States, interests:Ted Cruz, interests:Fox News Channel, age:14 - 65+, language:English (US), placements:Instagram Feed 36217 103 https://www.instagram.Com/tea_party_news/ Click Learn More! Support the police! They have so much responsibility, they have so much to care about, they have to worry about everything and to make people's life safe. Tea Party News ( @tea Teapartypat 138.96128 8685.08 RUB 2016-01-06T03:35:59-08:00 2016-03-20T20:47:00-07:00
1921 location:United States, interests:Islam, interests:Al Jazeera, age:14 - 65+, language:English (US), placements:Instagram Feed 13604 47 https://www.instagram.com/muslim_voice/ I want Americans and Europeans understand and ask to feel the difference between terrorists and faithful Muslim! Click Learn More! @muslim Voice - Muslimlnst 23.915680000000002 1494.73 RUB 2016-01-06T03:51:08-08:00  
1928 location:united_states:Baltimore (+40 km) Maryland, interests:African-American culture, age:14 - 65+, language:English (US), placements:Instagram Feed 29879 67 https://www.instagram.Com/baltimore.blackvoice/ THANK YOU to all those who risked their life for the sake of our country! Click Learn More! Baltimore News Balt 64.79888 4049.93 RUB 2016-01-06T04:26:59-08:00  
1931 location:United States, age:14 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Texas Nationalist Movement, people_who_match:interests:Hog Hunting Texas Style, people_who_match:interests:Texas Secession, people_who_match:interests:Texas Hog Hunting, people_who_match:interests:Don't Mess with Texas, people_who_match:interests:Texas Gun Owner, people_who_match:interests:Texas Deer Association, people_who_match:interests:Texas Parks and Wildlife — Hunt, people_who_match:interests:Don't Mess with Texas Program, people_who_match:interests:Texas secession movements, people_who_match:interests:Republic of Texas, people_who_match:interests:Houston, people_who_match:interests:Texas, people_who_match:interests:Chicano Movement, people_who_match:interests:Texas Deer Hunting, people_who_match:interests:Texas Born Texas Proud, people_who_match:interests:Daughters of the Republic of Texas, people_who_match:interests:The Texas Huntress, people_who_match:interests:Texas Got It Right, people_who_match:interests:Texas Values, people_who_match:interests:Open Carry Texas, people_who_match:interests:Texas Gun Talk, people_who_match:interests:Keep Texas Working 5394 7 https://www.ihstagram.com/tx_patriots/ Follow for the true Texas Pride! Support The Police Atla 11.09248 693.28 RUB 2016-05-12T03:20:33-07:00  
1935 location:United States, interests:Police, interests:Safety, age:14 - 65+, language:English (US), placements:Instagram Feed 50761 135 https://www.instagram.Com/stay4police/ If you say you don't need badges, it means you don't need your safety and confidence! Click Learn More! Support The Police Libelibe 63.20112 3950.07 RUB 2016-01-06T04:08:49-08: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 1397.489ms · Data source: simonw/russian-ira-facebook-ads-datasette