home / russian-ads

display_ads (view)

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

10 rows where an ad_target was people_who_match:interests:Black panther

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1106 location:united_states:Atlanta (+50 mi) Georgia, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Black panther 22839 1943 https://www.facebook.com/events/1094784283992152/ On October 15, 1966, Bobby Seale and Huey P. Newton have founded BPP. Their idea was simple - we can't just talk to make the Change, we must take action. They started to monitor the behavior of police officers and Challenge police brutality in Oakland, California. And they succeeded. Unfortunately, the government and especially Federal Bureau of Investigation called the party "the greatest threat to the internal security of the country". They tried to Close it, to incarcerate BPP's participants, and in 1982 the original party was dissolved. 50 years have passed since BBP's foundation, but the situation in the country stills the same. Cops are shooting Blacks. lt spreads through all the country like the disease. Nowadays we need Black Panthers as never before. We need a strong hand that can protect us, that can keep our people safe, that can make Black Lives really matter. Let's get together and celebrate the 50th anniversary of the party that has made the Change. Let's honor its founders and participants. Let's share their ideas and ideals! Black Panther Party 50th Anniversary 64.0 4000.00 RUB 2016-09-29T07:13:03-07:00 2016-10-14T15:00:00-07:00
1107 location:united_states:Houston (+50 mi) Texas, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Black panther 9788 981 https://www.facebook.com/events/1094784283992152/ On October 15, 1966, Bobby Seale and Huey P. Newton have founded BPP. Their idea was simple - we can't just talk to make the Change, we must take action. They started to monitor the behavior of police officers and Challenge police brutality in Oakland, California. And they succeeded. Unfortunately, the government and especially Federal Bureau of Investigation called the party "the greatest threat to the internal security of the country". They tried to Close it, to incarcerate BPP's participants, and in 1982 the original party was dissolved. 50 years have passed since BBP's foundation, but the situation in the country stills the same. Cops are shooting Blacks. lt spreads through all the country like the disease. Nowadays we need Black Panthers as never before. We need a strong hand that can protect us, that can keep our people safe, that can make Black Lives really matter. Let's get together and celebrate the 50th anniversary of the party that has made the Change. Let's honor its founders and participants. Let's share their ideas and ideals! Black Panther Party 50th Anniversary 31.98752 1999.22 RUB 2016-10-05T04:50:02-07:00 2016-10-14T15:00:00-07:00
1126 location:united_states:Atlanta (+50 mi) Georgia, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Black panther 0 0 https://www.facebook.com/events/1183449788395273/ Houstonians, come out to honor the memory of Huey P. Newton, and other black leaders and prominent members of the Black Panther Party on October 15! We should revive their legacy and discuss the plan that Newton and Seale crafted to empower Black communities economically. The plan contained basic demands such as self—determination, decent housing, full employment, education that included African-American history, and an end to police brutality. The list of confirmed speakers will be released a few days before the event Share and invite your friends! Black Panther Party 50th Anniversary H-Town 0.0 0.00 USD 2016-10-05T04:46:16-07:00 2016-10-14T16:00:00-07:00
1127 location:united_states:Houston (+50 mi) Texas, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Black panther 510 71 https://www.facebook.com/events/1183449788395273/ Houstonians, come out to honor the memory of Huey P. Newton, and other black leaders and prominent members of the Black Panther Party on October 15! We should revive their legacy and discuss the plan that Newton and Seale crafted to empower Black communities economically. The plan contained basic demands such as self—determination, decent housing, full employment, education that included African-American history, and an end to police brutality. The list of confirmed speakers will be released a few days before the event Share and invite your friends! Black Panther Party 50th Anniversary H-Town 1.37616 86.01 RUB 2016-10-05T04:50:03-07:00 2016-10-14T16:00:00-07:00
1128 location:united_states:Houston (+50 mi) Texas, age:16 - 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:Black Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Black panther 9693 878 https://www.facebook.com/events/1183449788395273/ Houstonians, come out to honor the memory of Huey P. Newton, and other black leaders and prominent members of the Black Panther Party on October 15! We should revive their legacy and discuss the plan that Newton and Seale crafted to empower Black communities economically. The plan contained basic demands such as self—determination, decent housing, full employment, education that included African-American history, and an end to police brutality. The list of confirmed speakers will be released a few days before the event Share and invite your friends! Black Panther Party 50th Anniversary H-Town 14.61824 913.64 RUB 2016-10-06T01:03:54-07:00 2016-10-14T16:00:00-07:00
2263 location_living_in:united_states:Charlotte (+25 mi) North Carolina, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Human rights, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Pan- Africanism, people_who_match:interests:Black Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Black panther, people_who_match:interests:Malcolm X, people_who_match:interests:Black (Color) or Cop Block, people_who_match:interests:Behaviors: African American (US) 0 0 https://b|ackmattersus.com/14732-beyonce-promotes-anti-police-brutality-in- Amazing Beyoncé protested against gun violence during her performance in the Video Music Awards. The popular singer showed her disapproval of the recent gun violence in the country through her VMA performance. Beyoncé, while performing a number of songs fro Beyoncé Protests Against Police Brutality In VMA Performance | Black Matters BM 0.0 0.00 USD 2016-10-06T06:20:32-07:00 2016-08-31T07:24:32-07:00
2283 location_living_in:united_states:Charlotte (+25 mi) North Carolina, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Human rights, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Pan- Africanism, people_who_match:interests:Black Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Black panther, people_who_match:interests:Malcolm X, people_who_match:interests:Black (Color) or Cop Block, people_who_match:interests:Behaviors: African American (US) 0 0 https://b|ackmattersus.com/14623-blaCk-man-re|eased-after-25-years-behind- 25 years for rape, murder, and burglary for a man who didn’t commit any of those crimes. Philadelphia is a place poisoned by police misconduct for so many years. That is the reason why they didn’t immediately release an innocent man even after it we Black Man Released After 25 Years Behind Bars For Nothing | Black Matters BM 0.0 0.00 USD 2016-10-06T06:20:33-07:00 2016-09-01T07:25:33-07:00
2305 location_living_in:united_states:Charlotte (+25 mi) North Carolina, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Human rights, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Pan- Africanism, people_who_match:interests:Black Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Black panther, people_who_match:interests:Malcolm X, people_who_match:interests:Black (Color) or Cop Block, people_who_match:interests:Behaviors: African American (US) 0 0 https://www.facebook.com/events/1640068636323203/ 43-year-old Keith Lamont Scott was fatally shot by police Tuesday afternoon at an apartment complex in Charlotte. The man was disabled, according to his family. Scott was waiting for his son to come home from school when police arrived at the apartment complex and shot him. The killer cop named Brentley Vinson from Metro Division has been placed on paid Administrative Leave. Raise up with us to demand justice for Keith Lamont Scott and his family on Saturday, September 24 at 12 pm! Justice For Keith Lamont Scott 0.0 0.00 USD 2016-10-06T06:20:34-07:00 2016-09-24T01:09:53-07:00
2324 location_living_in:united_states:Charlotte (+25 mi) North Carolina, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Human rights, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Pan- Africanism, people_who_match:interests:Black Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Black panther, people_who_match:interests:Malcolm X, people_who_match:interests:Black (Color) or Cop Block, people_who_match:interests:Behaviors: African American (US) 0 0 https://b|ackmattersus.com/15900-Ieon-ford-activating-mihds-of-those-who- The story of Leon Ford is shocking sad and gives hope at the same time. This brave activist uses his personal experience to inspire others and fight against police brutality. On November 12, 2012, Leon Ford was pulled over by a Pittsburgh cop for what appeared to be a routine traffic stop. His life has never been the same since then. Leon Ford: Activating Minds of Those Who are Mentally Paralyzed | BM BM 0.0 0.00 USD 2016-10-06T06:20:35-07:00 2016-09-16T02:30:22-07:00
2403 location_living_in:united_states:Charlotte (+25 mi) North Carolina, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Human rights, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Pan- Africanism, people_who_match:interests:Black Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Black panther, people_who_match:interests:Malcolm X, people_who_match:interests:Black (Color) or Cop Block, people_who_match:interests:Behaviors: African American (US) 24857 1112 https://www.facebook.com/blackmattersus.mvmnt/ October 22 is the National Day of Protest. October 22nd is a day that people around the nation have mobilized every year since 1996 for a National Day of Protest to Stop Police Brutality, Repression and the Criminalization of a Generation. Here in Charlotte, this problem appears especially hard. A number of victims and quantity of cases, where justice wasn't served - horrifies. The most well- known case is shooting of Jonathan Ferrell, an unarmed black man who was shot ten times and killed. Or situation with Daniel Kevin Harris, a deaf man, who just couldn't explain a thing, before he was shot. We need to use our right to protest to demand the authorities and police representatives, to do, the thing they are supposed to do! To protect and serve! Not to kill, damage and cripple! Join us on October 22, in Charlotte, 600 East Trade Street, just between Charlotte City hall and Charlotte-Mecklenburg Police Department. National Day of Protest. Charlotte, NC 186.21904 11638.69 RUB 2016-10-06T06:20:34-07:00 2016-10-22T04:18:29-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 1375.85ms · Data source: simonw/russian-ira-facebook-ads-datasette