home / russian-ads

display_ads (view)

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

16 rows where an ad_target was interests:Liberalism

View and edit SQL

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
33 location:united_states:Massachusetts, interests:Liberalism, age:18 - 65+, language:English (US), placements:Instagram Feed 2404 6 https://instagram.Com/gov_spending/ Unbelievable amount of the US government's waste. Click Learn More! The US Gov Spending Stats GovSpending 15.200000000000001 950.00 RUB 2015-12-01T05:57:42-08:00  
2411 location:United States, interests:Liberalism, interests:Libertarianism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2261 309 https://www.facebook.com/Born-LiberaI-522628564598423/   8.0 500.00 RUB 2016-07-21T09:37:16-07:00 2016-07-22T09:37:13-07:00
2412 location:United States, interests:Liberalism, interests:Libertarianism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1067 127 https://www.facebook.com/Born-LiberaI-522628564598423/ They just blame everybody for laziness and responses to cruelty. We just protect our freedom and act for everybody's rights 8.0 500.00 RUB 2016-07-14T01:00:10-07:00 2016-07-15T01:00:09-07:00
2413 location:United States, interests:Liberalism, interests:Libertarianism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1003 144 https://www.facebook.com/Born-LiberaI-522628564598423/ Clear that every presidential candidate must take the position in favor of the working men and women maintaining such fundamental DOMESTIC questions as the healthcare system, pension reform and the protection of labor rights. 8.0 500.00 RUB 2016-07-14T01:00:40-07:00 2016-07-15T01:00:39-07:00
2414 location:United States, interests:Liberalism, interests:Libertarianism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1204 183 https://www.facebook.com/Born-LiberaI-522628564598423/ Ohh..say no more! Fort Campbell says about 400 soldiers with the 101st Airborne Division are deploying to Iraq this summer. And the soldiers from the 2nd Brigade Combat Team will deploy as part of an increase in authorized troop levels in Iraq. Obama still drafts our guys into the army and they go to the Middle East. But his key campaign promise was to withdraw troops! It’s Clear that we come through too many wars: Libya, Iraq, Afghanistan... And 400 more our guys was deployed to Iraq... Maybe enough? We want peace! 11.200000000000001 700.00 RUB 2016-08-10T04:44:41-07:00 2016-08-11T04:44:40-07:00
2417 location:United States, interests:Liberalism, interests:Libertarianism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Born-LiberaI-522628564598423/ UC Davis paid $175,000 or more to scrub police pepper spray incident from web searches http://boingboing.net/2016/04/13/uc-davis-spent-175000-to—scr.htm| 0.0 0.00 USD 2016-07-14T00:59:58-07:00 2016-06-08T09:45:00-07:00
2418 location:United States, interests:Liberalism, interests:Libertarianism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2727 553 https://www.facebook.com/Born-LiberaI-522628564598423/ In spite of the prevailing stereotypes about who uses SNAP Food Stamp benefits the most in the United States, the highest usage is not in Compton, Queens, nor the South Side of Chicago” 8.0 500.00 RUB 2016-08-04T06:15:41-07:00 2016-08-05T06:15:40-07:00
2419 location:United States, interests:Liberalism, interests:Libertarianism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1920 187 https://www.faoebook.com/Born-LiberaI-522628564598423/ What future do you want for your Children? Government should focus additional funds on existing public schools, raising teacher salaries and reducing Class size! 8.0 500.00 RUB 2016-07-21T09:38:22-07:00 2016-07-22T09:38:20-07:00
2421 location:United States, interests:Liberalism, interests:Libertarianism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.faoebook.com/Born-Liberal-522628564598423/ "If you ask me about the Clinton Foundation, do l have a problem when a sitting secretary of state and a foundation run by her husband collects many millions of dollars from foreign governments, many governments which are dictatorships... yeah, I do," Sanders said in an interview with Jake Tapper on CNN. So, Bernie has the point. I appreciate the way he maintains his independent opinion in spite of all the pressure that is on him as the "second Democratic option". Because that is a fact. The Clinton Foundation is nothing more than an "organized crime" at it's finest, in which we are investing our taxpayers' money! Hillary has no problem in accepting foreign money from the countries, like Saudi Arabia. Hillary has no remorse about taking money from countries that abuse the rights of women, while she has always had her own alleged feminist stance. She does not refrain from receiving money from the countries that prosecute, torture and execute LGBT on the legal basis, although Hillary has always been a "defender" of the minorities. So, why are so many people going to vote for her? That's a secret for me. What's your opinion on that point? 0.0 0.00 USD 2016-07-14T01:00:00-07:00 2016-06-09T01:01:24-07:00
2423 location:United States, interests:Liberalism, interests:Libertarianism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.faoebook.com/Born-LiberaI-522628564598423/ Exactly. And, I also mind that you use some of your vast wealth to elect politicians who will pass laws to allow you to avoid paying your fair share of taxes. 0.0 0.00 USD 2016-07-14T01:00:03-07:00 2016-06-08T06:04:57-07:00
2425 location:United States, interests:Liberalism, interests:Libertarianism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Born-LiberaI-522628564598423/ Bernie for president! 0.0 0.00 USD 2016-07-14T01:00:02-07:00 2016-06-08T05:53:54-07:00
2428 location_living_in:United States, interests:Liberalism, interests:Libertarianism, interests:Democratic Party (United States), excluded_connections:Exclude people who like Born Liberal, age:18 - 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 120 6 https://www.facebook.com/bornliberall New ideas, old values. Like us! 6.6985600000000005 418.66 RUB 2016-06-06T08:17:56-07:00  
2434 location:United States, interests:Liberalism, interests:Libertarianism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1422 220 https://www.facebook.com/Born-LiberaI-522628564598423/ 8 August, 1974 Republican President Richard M. Nixon resigned. With impeachment proceedings underway against him for his involvement in the Watergate affair, Nixon was finally bowing to pressure from the public and Congress to leave the White House. Many people asked themselves: “How dare he to do that?” This is the awful part of our history, however, the similar actions still happen during current campaign: deleted emails, accident with Bernie Sanders and the DNC... This is bad and nobody cares. Does the political hypocrisy jump at the high level nowadays? 8.0 500.00 RUB 2016-08-10T04:45:57-07:00 2016-08-11T04:45:55-07:00
2435 location:United States, interests:Liberalism, interests:Libertarianism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2602 399 https://www.faoebook.com/Born-LiberaI-522628564598423/ Thank you Sister Chittister. Pro-Iifers are NOT pro-Iife, they are bombastic religionists who are more than prepared to watch Children starve. They ARE prepared to murder the doctors that perform abortions - do these doctors not have LIFE? If they wish to save one of these babies, then assist the would be mothers, set up a foundation to help support them, to feed the Children... 8.0 500.00 RUB 2016-08-10T04:45:30-07:00 2016-08-11T04:45:28-07:00
2436 location:United States, interests:Liberalism, interests:LGBT community, interests:Libertarianism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1451 187 https://www.facebook.com/Born-LiberaI-522628564598423/ LGBT community is suffering from haters and especially hate religious groups! These crazy thugs should be jailed for life! Crystal Raquel Cash, 55, cannot speak but is alive after being shot nearly point blank in the face by a member of Christian hate group. The attacker, Gerald Duane Lewis, 26, and his wife reportedly are members of the Israel United in Church, which the Southern Poverty Law Center listed as a hate group last year. According to the newspapers, Lewis was wearing a shirt from the Church when he opened fire, shouting a homophobic slur. The government must pay more attention to assaults on sexual minorities because this is the threat to the country’s internal security! 8.0 500.00 RUB 2016-07-21T09:35:45-07:00 2016-07-22T09:35:42-07:00
2437 location:United States, interests:Liberalism, interests:Libertarianism, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1303 245 https://www.facebook.com/Born-LiberaI-522628564598423/ Let's say stop to police brutality! We must be against racism of all kinds and make a strong and peaceful responce to these! 8.0 500.00 RUB 2016-07-14T01:01:12-07:00 2016-07-15T01:01:11-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 2114.681ms · Data source: simonw/russian-ira-facebook-ads-datasette