home / russian-ads

display_ads (view)

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

15 rows where an ad_target was location:united_states:New York (+40 km) New York

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
102 location:united_states:New York (+40 km) New York, interests:BIackNews.com, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 37821 2775 https://www.facebook.com/events/1085290071563825/ Almost 2 years have passed since the death of Eric Garner, a father of 6, who was violentl Rally In Memory Of Eric Garner 199.76272 12485.17 RUB 2016-07-06T03:03:43-07:00 2016-07-17T03:03:41-07:00
103 location:united_states:New York (+40 km) New York, interests:BIackNews.com, interests:Black History Month, interests:African-American history, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/events/1085290071563825/ Almost 2 years have passed since the death of Eric Garner, a father of 6, who was violentl Rally In Memory Of Eric Garner 0.0 0.00 USD 2016-07-28T06:40:03-07:00 2016-07-17T03:03:41-07:00
181 no image location:united_states:New York (+40 km) New York, interests:Black Tea Patriots, interests:BIackNews.com, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ The—will attract the UN’s attention to the long term injustice and cruelty against people of color in the United States. The genocide instituted by white supremacists should be stopped. Join our protest that will be held Also, join the event for more info: #CrimesOfGenocide 0.0 0.00 USD 2016-02-09T05:37:37-08:00 2016-02-12T06:18:00-08:00
187 no image location:united_states:New York (+40 km) New York, interests:Black Tea Patriots, interests:BIackNews.Com, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 5 0 https://www.facebook.com/blackmattersus/ ATTENTION, NEWYORK! Join the We're meeting We need your support! We'll provide you with free food and coffee. Come and bring your friends! Join the FB event for more details: 0.0688 4.30 RUB 2016-02-18T05:46:32-08:00 2016-02-19T05:46:31-08:00
189 no image location:united_states:New York (+40 km) New York, interests:Black Tea Patriots, interests:BIackNewscom, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ ATTENTION, NEWYORK! We're meetin at We need your support! We'll provide you with free food and coffee. Come and bring your friends! Join the FB event for more details: 0.0 0.00 USD 2016-02-18T05:09:11-08:00 2016-02-19T16:09:00-08:00
190 no image location:united_states:New York (+40 km) New York, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Black Tea Patriots, people_who_match:interests:BIackNews.com, and_must_also_match:multicultural_affinity:African American (US) 3466 353 https://www.facebook.com/blackmattersus/ ATTENTION, NEWYORK! We're meetin We need your support! We'll provide you with free food and coffee. Come and bring your friends! Join the FB event for more details: 22.17904 1386.19 RUB 2016-02-18T05:12:00-08:00 2016-02-19T16:09:00-08:00
192 no image location:united_states:New York (+40 km) New York, 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 7 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ As what happened to India while in police custody remains a major concern, many are wondering why the 27-year-old was denied an appropriate medical evaluation and proper care. The frequent reports of police brutality and extreme use of force, leading to death has regrettably become a daily course. Consequently, protests and demonstrations overflow in every nook and cranny, demanding answers and justice. On February 1, India T. Cummings was under the influence of the synth... #JusticeForlhdia: 27-Year-old Denied Medical Treatment, Dies in Police Custody | Black Matters Black Matters 0.04624 2.89 RUB 2016-03-04T00:46:00-08:00 2016-03-06T00:46:00-08:00
298 location:united_states:New York (+40 km) New York, interests:BIackNews.com, interests:Black History Month, interests:African-American history, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 29689 1969 https://www.facebook.com/events/309180056094025/ August 9, 2016, marks a two—year anniversary of the brutal murder of Michael Brown, an 18- Rally In Memory Of Mike Brown 97.6888 6105.55 RUB 2016-07-28T06:40:40-07:00 2016-08-14T06:40:38-07:00
465 location:united_states:New York (+40 km) New York, interests:Donald Trump, interests:Donald Trump for President, interests:Donald Trump Jr., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 1752 353 https://www.facebook.com/Being-PatriotiC-1601685693432389/ Clinton said the United States needs to confront the ‘systematic racism’ in its law enforcement efforts. We’re sick of politicians organizing and leading the systematical propaganda against our police. It is unfair and vilely to accuse our heroes of every sin and crime. In fact, the efficiency of our cops resulted in a decrease of the average amount of crimes, especially in large Cities. Law-abiding Citizens should never fear cops, but criminals do. And that’s why Hillary is on the criminals’ side. Join our rally on July, 23th in New York City, it's time to show Clinton that we will never let her become our next President! 8.0 500.00 RUB 2016-07-14T01:34:33-07:00 2016-07-15T01:34:31-07:00
466 location:united_states:New York (+40 km) New York, interests:Donald Trump, interests:Donald Trump for President, interests:Donald Trump Jr., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 18915 1454 https://www.facebook.com/events/966495900135555/ Our country was drawing a blank for the last eight years. We need a strong leader who will March for Trump 264.54256 16533.91 RUB 2016-06-02T03:50:04-07:00 2016-06-22T03:50:01-07:00
476 location:united_states:New York (+40 km) New York, interests:Donald Trump, interests:Donald Trump for President, interests:Donald Trump Jr., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 3001 204 https://www.facebook.com/Being-PatriotiC-1601685693432389/ We insist over and over again: Black Lives Matter is a radical hate group and its violent actions must be stopped. And we're glad to know that our police officials are on our side on that issue. 8.0 500.00 RUB 2016-07-14T01:35:03-07:00 2016-07-15T01:35:01-07:00
477 location:united_states:New York (+40 km) New York, interests:Donald Trump, interests:Donald Trump for President, interests:Donald Trump Jr., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 15255 1312 https://www.facebook.com/events/1139813819411853/ Hillary Clinton is the co-author of Obama’s anti-police and anti-Constitutional propaganda Down With Hillary! 235.29088000000002 14705.68 RUB 2016-07-12T02:52:38-07:00 2016-07-23T02:52:36-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
526 location:united_states:New York (+40 km) New York, interests:Donald Trump, interests:Donald Trump for President, interests:Donald Trump Jr., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 1301 120 https://www.facebook.com/events/966495900135555/ Our country was drawing a blank for the last eight years. We need a strong leader who will March for Trump 21.85584 1365.99 RUB 2016-06-01T06:31:00-07:00 2016-06-03T06:30:57-07:00
1951 location:united_states:Connecticut, location:united_states:Delaware, location:united_states:Maine, location:united_states:Maryland, location:united_states:Massachusetts, location:united_states:Ferguson (+40 km) Missouri, location:united_states:Virginia City (+40 km) Nevada, location:united_states:New Hampshire, location:united_states:New Jersey, location:united_states:New York (+40 km) New York, location:united_states:Ohio, location:united_states:Pennsylvania, location:united_states:Rhode Island, location:united_states:Vermont, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:HispanicTV, people_who_match:interests:Behaviors: African American (US) 26514 0 https://www.facebook.com/Proudblacks-954167134618867/ New York. 18-19 Feb. 11:00. Meet at Dag Hammarskjold Plaza on 47 street. 40.0 2500.00 RUB 2016-02-18T05:03:07-08:00 2016-02-19T11:26:00-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 1356.609ms · Data source: simonw/russian-ira-facebook-ads-datasette