home / russian-ads

display_ads (view)

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

45 rows where an ad_target was excluded_connections:Exclude people who like Don't Shoot

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1427 location:United States, interests:Human rights, interests:Police, interests:Police officer, interests:Order of Merit of the Police Forces, behaviors:multicultural_affinity:Hispanic (US - All), behaviors:multicultural_affinity:Multicultural Affinity: Hispanic (US - English dominant), behaviors:multicultural_affinity:Multicultural Affinity: African American (US), excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 487 18 https://www.facebook.com/BIackJourney2Justice/ No one is above the law! Against Police Brutality! 7.9489600000000005 496.81 RUB 2015-12-10T02:18:40-08:00  
1439 location:united_states:Atlanta (+25 mi) Georgia, location:united_states:New Orleans (+25 mi) Louisiana, location:united_states:Baltimore (+25 mi) Maryland, location:united_states:St. Louis (+25 mi) Missouri, location:united_states:Cleveland (+25 mi) Ohio, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 8045 317 https://www.facebook.com/Dont-Shoot-1157233400960126/ Don't shoot we want to grow up! Against police brutality! 101.38208 6336.38 RUB 2015-09-15T07:13:32-07:00  
1442 location:united_states:Atlanta (+25 mi) Georgia, location:united_states:New Orleans (+25 mi) Louisiana, location:united_states:Baltimore (+25 mi) Maryland, location:united_states:St. Louis (+25 mi) Missouri, location:united_states:Cleveland (+25 mi) Ohio, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 2661 93 https://www.facebook.com/Dont-Shoot-1157233400960126/ Against social injustice and police brutality! 25.82672 1614.17 RUB 2015-09-15T07:12:23-07:00  
1443 location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), excluded_connections:Exclude people who like Don't Shoot, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 384 15 https://www.facebook.com/BIackJourneyZJustice/ We are not against the police, We are against police brutality! 10.87936 679.96 RUB 2015-12-10T02:14:26-08:00  
1459 location:United States, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 32064 3977 https://www.facebook.com/BIackJourneyZJustice/ We are not against police, we against police brutality! 509.17503999999997 31823.44 RUB 2015-09-23T04:49:10-07:00  
1460 location:United States, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on mobile devices 103614 10629 https://www.facebook.com/BIackJourneyZJustice/ We are not against police, we against police brutality! 1689.36976 105585.61 RUB 2015-11-06T02:41:18-08:00  
1461 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Cop Block 120496 4684 https://www.facebook.com/BIackJourney2Justice/ We are not against police, we against police brutality! 684.88768 42805.48 RUB 2016-02-12T05:52:58-08:00  
1462 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:14 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Cop Block 226262 9657 https://www.facebook.com/BIackJourney2Justice/ We are not against police, we against police brutality! 875.67152 54729.47 RUB 2016-05-05T02:12:02-07:00  
1463 location:united_states:Atlanta (+25 mi) Georgia, location:united_states:New Orleans (+25 mi) Louisiana, location:united_states:Baltimore (+25 mi) Maryland, location:united_states:St. Louis (+25 mi) Missouri, location:united_states:Cleveland (+25 mi) Ohio, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 12516 520 https://www.facebook.com/Dont-Shoot-1157233400960126/ Don't shoot we want to grow up! 148.14976000000001 9259.36 RUB 2015-09-15T07:13:48-07:00  
1572 location:United States, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 64 2 https://www.facebook.com/BIackJourneyZJustice/ We want to grow and not being shot! Join us! 1.17648 73.53 RUB 2015-09-23T04:48:34-07:00  
1573 location:United States, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on mobile devices 0 0 https://www.facebook.com/BIackJourneyZJustice/ We want to grow and not being shot! Join us! 0.0 0.00 USD 2015-11-06T02:41:18-08:00  
1574 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/BIackJourneyZJustice/ We want to grow and not being shot! Join us! 0.0 0.00 USD 2016-02-12T05:52:58-08:00  
1575 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:14 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/BIackJourney2Justice/ We want to grow and not being shot! Join us! 0.0 0.00 USD 2016-05-05T02:12:02-07:00  
1576 location:United States, interests:cop block, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, 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/BIackJourneyZJustice/ We want to live in the country with no fear! 0.0 0.00 USD 2015-09-23T04:47:56-07:00  
1577 location:United States, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on mobile devices 0 0 https://www.facebook.com/BIackJourneyZJustice/ We want to live in the country with no fear! 0.0 0.00 USD 2015-11-06T02:41:18-08:00  
1578 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/BIackJourney2Justice/ We want to live in the country with no fear! 0.0 0.00 USD 2016-02-12T05:52:58-08:00  
1579 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:14 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/BIackJourney2Justice/ We want to live in the country with no fear! 0.0 0.00 USD 2016-05-05T02:12:02-07:00  
1580 location:United States, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 800 69 https://www.facebook.com/BIackJourneyZJustice/ We want to live in the country with no fear! 12.821760000000001 801.36 RUB 2015-09-23T04:47:57-07:00  
1581 location:United States, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on mobile devices 0 0 https://www.facebook.com/BIackJourneyZJustice/ We want to live in the country with no fear! 0.0 0.00 USD 2015-11-06T02:41:18-08:00  
1582 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/BIackJourney2Justice/ We want to live in the country with no fear! 0.0 0.00 USD 2016-02-12T05:52:58-08:00  
1583 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:14 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/BIackJourney2Justice/ We want to live in the country with no fear! 0.0 0.00 USD 2016-05-05T02:12:02-07:00  
1584 location:United States, interests:cop block, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, 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/BIackJourneyZJustice/ We run this community because we care... 0.0 0.00 USD 2015-09-23T04:47:25-07:00  
1585 location:United States, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on mobile devices 0 0 https://www.facebook.com/BIackJourneyZJustice/ We run this community because we care... 0.0 0.00 USD 2015-11-06T02:41:18-08:00  
1586 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/BIackJourney2Justice/ We run this community because we care... 0.0 0.00 USD 2016-02-12T05:52:58-08:00  
1587 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:14 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/BIackJourney2Justice/ We run this community because we care... 0.0 0.00 USD 2016-05-05T02:12:02-07:00  
1588 location:United States, interests:cop block, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 307 18 https://www.facebook.com/BIackJourney2Justice/ It's not about who is "good" and "bad" it's about what is right! 8.41696 526.06 RUB 2015-09-23T04:46:49-07:00  
1589 location:United States, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on mobile devices 0 0 https://www.facebook.com/BIackJourney2Justice/ It's not about who is "good" and "bad" it's about what is right! 0.0 0.00 USD 2015-11-06T02:41:18-08:00  
1590 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/BIackJourney2Justice/ It's not about who is "good" and "bad" it's about what is right! 0.0 0.00 USD 2016-02-12T05:52:58-08:00  
1591 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:14 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/BIackJourney2Justice/ It's not about who is "good" and "bad" it's about what is right! 0.0 0.00 USD 2016-05-05T02:12:02-07:00  
1592 location:United States, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 283 36 https://www.facebook.com/BIackJourney2Justice/ It's not about who is "good" and "bad" it's about what is right! 8.752 547.00 RUB 2015-09-23T04:46:49-07:00  
1593 location:United States, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on mobile devices 0 0 https://www.facebook.com/BIackJourney2Justice/ It's not about who is "good" and "bad" it's about what is right! 0.0 0.00 USD 2015-11-06T02:41:18-08:00  
1594 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/BIackJourney2Justice/ It's not about who is "good" and "bad" it's about what is right! 0.0 0.00 USD 2016-02-12T05:52:58-08:00  
1595 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:14 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/BIackJourney2Justice/ It's not about who is "good" and "bad" it's about what is right! 0.0 0.00 USD 2016-05-05T02:12:02-07:00  
1596 location:United States, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 774 55 https://www.facebook.com/BIackJourneyZJustice/ We run this community because we care... 11.90432 744.02 RUB 2015-09-23T04:47:25-07:00  
1597 location:United States, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on mobile devices 0 0 https://www.facebook.com/BIackJourneyZJustice/ We run this community because we care... 0.0 0.00 USD 2015-11-06T02:41:18-08:00  
1598 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/BIackJourneyZJustice/ We run this community because we care... 0.0 0.00 USD 2016-02-12T05:52:58-08:00  
1599 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:14 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/BIackJourney2Justice/ We run this community because we care... 0.0 0.00 USD 2016-05-05T02:12:02-07:00  
1600 location:United States, interests:cop block, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, 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/BIackJourneyZJustice/ We want to grow and not being shot! Join us! 0.0 0.00 USD 2015-09-23T04:48:34-07:00  
1601 location:United States, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on mobile devices 0 0 https://www.facebook.com/BIackJourneyZJustice/ We want to grow and not being shot! Join us! 0.0 0.00 USD 2015-11-06T02:41:18-08:00  
1602 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/BIackJourney2Justice/ We want to grow and not being shot! Join us! 0.0 0.00 USD 2016-02-12T05:52:58-08:00  
1603 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:14 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/BIackJourney2Justice/ We want to grow and not being shot! Join us! 0.0 0.00 USD 2016-05-05T02:12:02-07:00  
1604 location:United States, interests:cop block, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, 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/BIackJourneyZJustice/ We are not against police, we against police brutality! 0.0 0.00 USD 2015-09-23T04:49:10-07:00  
1605 location:United States, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on mobile devices 0 0 https://www.facebook.com/BIackJourneyZJustice/ We are not against police, we against police brutality! 0.0 0.00 USD 2015-11-06T02:41:18-08:00  
1606 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/BIackJourney2Justice/ We are not against police, we against police brutality! 0.0 0.00 USD 2016-02-12T05:52:58-08:00  
1607 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:14 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Cop Block 0 0 https://www.facebook.com/BIackJourney2Justice/ We are not against police, we against police brutality! 0.0 0.00 USD 2016-05-05T02:12:02-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 1499.892ms · Data source: simonw/russian-ira-facebook-ads-datasette