Data source: simonw/russian-ira-facebook-ads-datasette
This data as JSON, CSV (advanced)
| id | img | targeting | impressions | clicks | url | text | spend_usd | spend_amount | spend_currency | created | ended |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 798 | |
location:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 7721 | 335 | https://www.facebook.com/WilIiamsKalvin-788980617892144/ | There's no reason to fight the whole government if you are alone. You will die but you can never win. You need people who can stand with you for what you all think is right. Still , can we do this? Subscribe to our Channel: https://www.youtube.com/ChannellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: httpszllwww.instagram.Com/williams.and.kalvin | 12.762080000000001 | 797.63 | RUB | 2016-11-01T06:04:00-07:00 | |
| 799 | |
location:United States, interests:Martin Luther King, interests:Jr., interests:Melanin, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, interests:Black (Color), interests:HuffPost Black Voices, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 13263 | 1100 | https://www.facebook.com/WilIiamsKalvin-788980617892144/ | I pity anyone who has to deal with neighbors in an apartment building. Especially when you have to deal with the complaining and passive- aggressive types. Oh, and let’s not forget gentrifiers. Or, as I like to call them, “white migrators.” Apparently, instead of knocking on a neighbor’s door, people take the easy and passive-aggressive way out and just leave notes instead. But one man wasn’t having it. Link: https://scontent-arn2-1 .xx.fbcdn.net/v/t1 .0-9/14572967_1772905896322 988_913778538274424647_n.jpg?oh=9a4945f2582b54297fe1f8f786f297be& oe=5862D508 Subscribe to our Channel: https://www.youtube.com/ChahnellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: https://www.instagram.Com/williams.and.kalvin Follow me on Twitter: https://twitter.com/Williams8kalvih | 19.2 | 1200.00 | RUB | 2016-10-14T02:45:50-07:00 | 2016-10-15T02:45:48-07:00 |
| 803 | |
location:United States, interests:Martin Luther King, interests:Jr., interests:Police Brutality is a Crime, interests:African-Amerioan culture, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Police brutality in the United States, interests:Stop Police Brutality, interests:Malcolm X, interests:Union of Huffington Post Writers and Bloggers, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 12654 | 693 | https://www.facebook.com/WilIiamsKalvin-788980617892144/ | Ice-Cream is something more than just a food you love. When a business expresses its views, cops are attacking, because they know no other way to act! Ben & Jerry’s ice-cream is boycotted by the police officers just because of the opinion of the business owners. So, let’s stand against the political repressions! Subscribe to our Channel: https://www.youtube.com/ChahnellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: https://www.instagram.Com/williams.and.kalvin Follow me on Twitter: https://twitter.oom/Williams8kalvih | 12.7992 | 799.95 | RUB | 2016-10-21T07:46:31-07:00 | 2016-10-24T07:46:28-07:00 |
| 835 | |
location:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 0 | 0 | https://www.facebook.com/WilIiamsKalvin-788980617892144/ | Black guys are smart and no one can deny this. White cops are one of the hardest of the problems we face every day, still, we found the way how to deal with this bastards. So we developed the app that can collect and organize the information about cos’ misconduct. Use it and you will help the entire black community. Subscribe to our Channel: https://www.youtube.com/ChannellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: https://www.instagram.Com/williamsand.kalvin Follow me on Twitter: https://twitter.oom/Williams8kalvin | 0.0 | 0.00 | USD | 2016-10-20T08:03:34-07:00 | 2016-10-21T08:03:32-07:00 |
| 1051 | |
location:United States, interests:Pan-Afrioanism, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 36295 | 6656 | https://www.facebook.com/Blacktivist-128371547505950/ | CHARLESTON COP WHO FATALLY SHOT BLACK MAN ASKS JUDGE TO DROP CHARGES, CITING DOUBLE RISK North Charleston police officer Michael Slager, who shot and killed 50-year- old Scott after an April 2015 traffic stop, and his attorneys urged the court to drop murder Charge due to the double jeopardy that Slager faced before the shooting. According to ex-cop‘s attorneys, their defendant acted in self- defense despite the fact that Scott was unarmed and Slager fired eight times, hitting Scott five times from behind. Slager‘s defense attorney‘s: “The doubIe-teaming of Slager is a chilling example of how far politically motivated politicians and prosecutors will go to seek headlines and feather their own nests at the expense of a public servant who had to make a split- second life or death decision that will be seoond-guessed by comfortable armchair quarterbacks. This is unconscionable.” The shooting occurred in April 2015 when Slager stopped Scott for a broken brake light on the Mercedes-Benz he was driving. According to Slager‘s dashcam, ex-cop asked Scott to show his driving license and questioned him about documents for the car. When Slager returned to his car, Walter Scott jumped out of the car and ran away giving Slager chase. According to a bystander‘s video, Scott ran away from the officer when Slager opened fire. We‘ve seen what happened in different parts of America: unarmed dead black bodies lying across the streets at the hands of police officers and none of them found guilty. That‘s why today it‘s important to send a message to other police officers that if they do this, it‘s harsh penalty to pay. | 8.0 | 500.00 | RUB | 2016-11-03T08:11:51-07:00 | 2016-11-10T07:11:51-08:00 |
| 1100 | |
location:United States, interests:Pan-Afrioanism, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 34914 | 3640 | https://www.facebook.com/Blacktivist-128371547505950/ | COPS SHOT AND KILLED CALIFORNIA BLACK WOMAN WHO STRUGGLED WITH BIPOLAR DISORDER Michelle Lee Shirley was fatally shot by Torrance police officer as she approached a group of police officers in her car. Police arrived at the scene after a series of 911 calls in which they were warned of a reckless driver and her erratic behavior. When cop saw Shirley, who was off her bipolar medication, they boxed her in with their patrol cars. When she started approaching them, law enforcement officers opened fire at her. The incident resulted in a fatal shooting. After the shooting, Shirley was taken to County Harbor—UCLA Medical Center and was pronounced dead. Michelle Shirley, 39, who received a diagnosis of a mental disorder tried to balance motherhood and law school. In a video titled, “It‘s Up to Us,” she was asking people to take seriously a mental disorder and seek help because ignoring it can take away years of people‘s lives. Did you know that people with mental illness are 16 times more likely to be killed during a police encounter than mental healthy? Did you know that half of people shot by cops are mentally ill? Police officers are not equipped with firearms to deal with mental illness in the field. But they are equipped to protect us from criminals. | 8.0 | 500.00 | RUB | 2016-11-03T08:13:05-07:00 | 2016-11-10T07:13:05-08:00 |
| 1104 | |
location:United States, interests:Pan-Afrioanism, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 11217 | 1991 | https://www.facebook.com/Blacktivist-128371547505950/ | Don‘t be scared to rock your natural hair. Life is short and you only live once on this earth. | 6.4 | 400.00 | RUB | 2016-10-18T06:43:09-07:00 | 2016-10-19T06:43:07-07:00 |
| 1145 | |
location:United States, interests:Pan-Afrioanism, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 8475 | 1441 | https://www.facebook.com/Blacktivist-128371547505950/ | Colin Kaepernick is no Rosa Parks, who was a victim of segregation. But Colin Kaepernick is an articulate young man, who refused to show pride in a flag for a country that continues to gun down innocent black men. | 9.6 | 600.00 | RUB | 2016-10-20T07:56:56-07:00 | 2016-10-21T07:56:54-07:00 |
| 2483 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 7292 | 582 | https://blackmattersus.com/18419-refused-oredit-because-of-your-race-heres- | A bank wouldn't cash Trish Doolin's paycheck because they didn't believe she was an architect. This is not an isolated incident. Every African American gets rejected by a bank from time to time. Click to know what to do in this case. Racism is not only a social phenomenon. It affects us on all levels and in all spheres of our life. Banking system is not an exception. Pls. RT When you'r Refused Credit Because Of Your Race? Here’s What You Should Do | BM BM | 9.6 | 600.00 | RUB | 2016-10-21T08:43:53-07:00 | 2016-10-22T08:44:13-07:00 |
| 2506 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 1926 | 97 | https://represent.com/store/blaCk-matters-us | Whether you take part in protests and rallies orjust want to voice your concerns about police brutality against African Americans you need these cool t-shirts! Buying our t-shirts you donate to the needs of the Black Community. BlackMatters is a group of activists advocating for the rights of African Americans. Buying our t-shirts you donate to the needs of the Black Community. Black Matters US BM | 5.959840000000001 | 372.49 | RUB | 2016-11-02T05:06:18-07:00 | 2016-11-09T04:06:18-08:00 |
| 2514 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, interests:Anti-discrimination, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 1045 | 60 | https://www.facebook.com/blackmattersus.mvmnt/ | Your voices matter! We are looking for the authors. Your opinions will be published! In our work we have discovered that many Kings and Queens were silenced and had no opportunity to voice their concerns and opinions. But today, we want to give you this opportunity. We want America to know what bothers you as a member of the Black community. We are ready to publish your articles and your opinions. Plus, it‘s a good Chance for you to be a part of our team that is interested in educating African Americans and making real Changes! If you have something to say or you have good writing skills or you care about Black Lives, please DM us and become the part of our team. | 3.9792 | 248.70 | RUB | 2016-10-18T05:35:40-07:00 | 2016-10-19T05:35:39-07:00 |
| 2515 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 0 | 0 | https://www.facebook.com/blackmattersus.mvmnt/ | Your voices matter! We are looking for the authors. Your opinions will be published! In our work we have discovered that many Kings and Queens were silenced and had no opportunity to voice their concerns and opinions. But today, we want to give you this opportunity. We want America to know what bothers you as a member of the Black community. We are ready to publish your articles and your opinions. Plus, it‘s a good Chance for you to be a part of our team that is interested in educating African Americans and making real Changes! If you have something to say or you have good writing skills or you care about Black Lives, please DM us and become the part of our team. | 0.0 | 0.00 | USD | 2016-10-21T08:42:25-07:00 | 2016-10-19T05:35:39-07:00 |
| 2541 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 56130 | 11629 | https://www.facebook.com/blackmattersus.mvmnt/ | This man beat up police officer who tased his wife. Do you agree with the man who defended his woman? | 6.44944 | 403.09 | RUB | 2016-11-02T05:47:03-07:00 | 2016-11-09T04:47:03-08:00 |
| 2542 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, interests:Black (Color), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 11945 | 1310 | https://blaokmattersus.com/19353-all-blaCk-meetups-against-trump-in-your- | #NotMyPresident hashtag has become popular after the election that has shaken the life of the Black Community. Many people feel the urge to share their opinion on what happened. For those who would like to join the meetups against Donald Trump as the US President BlackMatters have gathered the comprehensive list of such events. Click to find your City. #NotMyPresident hashtag has become popular after the election that has shaken the life of the Black Community. Many people feed the urge to share their opinion on what happened. For those who would like to join the meetups against Donald Trump as the US President BlackMatters have gathered the compr... All Black Meetups Against Trump In Your City | BM | 22.055200000000003 | 1378.45 | RUB | 2016-11-11T04:48:49-08:00 | |
| 2816 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 0 | 0 | https://www.facebook.com/Woke-B|acks-294234600956431/ | This one is for ya'all brothers! If you exclusively date outside of your ethnicity and culture, you hate yourself. Don't talk to me until you start to love yourself. I'm going to get many people complaining about this post... I don't care. If you won't Check for your own people, seek help not more approval. I'm not saying you should ever Check for people outside of your culture, I am saying brothers if every women you have ever been with, isn't from your culture/ethnic group, you have issues of the mind. You are doing this not by love but on purpose, because you hate yourself subconsciously, it's ok, just love yourself and heal your illness. ? #westandtogether #melanin #blackisbeautiful #blacklivesmatter #blackgirlmagic #USA #blackahdproud #Africanamerican #unite4justice #melanin #ioahtbreathe #hood #blackgirl #blackbeauty #darkskin #blackqueen #blackqueehs #problaok #afro #afrocentric #boycott #hovem ber8 #elections2016 #ripaltonsterling #altonsterling #TerenceCrutCher | 0.0 | 0.00 | USD | 2016-11-03T08:39:17-07:00 | 2016-11-06T07:39:17-08:00 |
| 2817 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 2971 | 383 | https://www.facebook.com/Woke-B|acks-294234600956431/ | Couldn't go past this one, Blessed earth strong @kaepernick7 may you continue your works and work in the power of our ancestors :) ??? ? Be eager and glad to find out about your roots. The more you find out about your ancestry, the more you find yourself. Happy Birthday Colin Kaepernick. Stay woke forever!!! #westandtogether #melanin #blackisbeautiful #blacklivesmatter #blackgirlmagic #USA #blackahdproud #Africanamerican #unite4justice #melanin #ioahtbreathe #hood #blackgirl #blackbeauty #darkskin #blackqueen #blackqueehs #problaok #afro #afrocentric #boycott #hovem ber8 #elections2016 #ripaltonsterling #altonsterling #TerenceCrutCher | 1.2523199999999999 | 78.27 | RUB | 2016-11-03T08:42:09-07:00 | 2016-11-06T07:42:09-08:00 |
| 3021 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X or United States presidential election, interests:2016, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, interest_expansion:On | 0 | 0 | https://www.facebook.com/Williamsathalvin/ | Black Americans have really different problems to face no white American can ever experience in his own life. We have the same problems in our communities after the presidential elections as we had before. So, give no attention to what you are told by the media. Get down to your own business. Subscribe to our Channel: https://www.youtube.com/ChahnellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: https://www.instagram.Com/williams.and.kalvin Follow me on Twitter: https://twitter.oom/Williams8kalvih | 0.0 | 0.00 | USD | 2016-11-17T23:32:07-08:00 | 2016-11-20T23:32:07-08:00 |
| 3029 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X or United States presidential election, interests:2016, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, interest_expansion:On | 674 | 138 | https://www.facebook.com/WilliamsandKalvin/ | We have to learn to support each other and be happy about our people's success. Sometimes it's hard but it's the important part of growing. Do you celebrate your brothers and sisters success? | 0.8 | 50.00 | RUB | 2016-12-04T00:36:29-08:00 | 2016-12-06T00:36:29-08:00 |
| 3105 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan culture, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Black Consciousness Movement, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 2210 | 485 | https://www.facebook.com/Woke-B|acks-294234600956431/ | The truth hurts, but we must face it. It's a sad fact, but the most of Black men regard women of other race romantic and beautiful. Believe me you, Black men, we got the most beautiful, romantic and attractive females under the sun. Value 3 Black woman and treat her like you'd treat other women of other races and you'll realize how of a Queen you have. #blackexcellence #PanAfricanism #BlaokNationalism #BlackEmpowerment #AfricanEmpowermeht #AfricanAndProud #BlaCkAndProud #BlackPride #BlackPower #BlackLivesMatter #Amerikkka #UnapologeticallyBlack #UnapologeticallyAfrican #BlacklhAmerica #BlacklsBeautiful #KnowThySelf #KnowledgeOfSelf #KnowledgeOfSelflsANationality #EconomicEmpowerment #IhtegrationFailed #WhiteLiesMatter #Education #AfricanUnifiCation #AfricanUnity #BlackLove #JusticeOrElse #ProBlack #Regrann #blackexcellence | 2.80736 | 175.46 | RUB | 2017-04-13T07:03:49-07:00 | 2017-04-14T07:03:49-07:00 |
| 3117 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 423 | 81 | https://www.facebook.com/Woke-Blacks-294234600956431/ | I stopped watching tv for new, cus i can't take all this bs. i see my people do! | wana put this out straight, once and for all! We all say it's a whiteman's world in the US. with white-favouring-rules and everything, right? So what makes you want to be a part of this system, in other terms, be a slave to this system? Why in the heck would you all be routing and rioting and fighting over and for a two-party government system that cares less about you? Damn, we all agreed with Kaepernick when he took the knee for us all, and now we all, outta fear join white democrats to riot Trump? Like wtf happened to we rising above the government system to improve our lives and not joining this whole racist bias system? Damn, that's sad! #wakeup #organize #joshuabeal #altonsterling #TerenceCrutCher #westandtogether #blacklivesmatter #unite4justice #hovem ber8 #elections2016 #black #melanin #blackisbeautiful #blacklivesmatter #blackgirlmagic #USA #blackahdproud #democrat #republioan #Africanamerican #unite4justice #vote #breakingnews | 0.35472000000000004 | 22.17 | RUB | 2016-11-15T04:56:29-08:00 | 2016-11-16T04:56:29-08:00 |
| 3118 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 13292 | 2290 | https://www.facebook.com/Woke-B|acks-294234600956431/ | Ladies & Gents, today we remember one of the realest ever Lone Rangers, Bass Reeves. Mostly described as the “lawman second to none,” a man who was “absolutely fearless and also labelled, the Black Hero Marshal. Reeves was born to slave parents in 1838 in Crawford County Arkansas, but Bass Reeves would become the first black U.S. Deputy Marshal west of the Mississippi River and one of the greatest frontier heroes in the history of this country. #PanAfricanism #BIaokNationalism #BlackEmpowerment #AfricanEmpowermeht #AfricanAndProud #BIaokAndProud #BlackPride #BlackPower #BIaCkLivesMatter #Amerikkka #UnapologeticallyBlack #UnapologeticallyAfrican #BlacklhAmerica #BlacklsBeautiful #KnowThySelf #KnowledgeOfSelf #KnowledgeOfSelflsANationaIity #EconomicEmpowerment #IhtegrationFailed #WhiteLiesMatter #Education #AfricanUnifiCation #AfricanUnity #BlackLove #JusticeOrElse #ProBIack #Regrann #blackexcellence #goals #woke | 3.2 | 200.00 | RUB | 2017-02-17T05:32:12-08:00 | 2017-02-18T05:32:12-08:00 |
| 3119 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan culture, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Black Consciousness Movement, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 39914 | 7534 | https://www.facebook.com/Woke-B|acks-294234600956431/ | Just a reminder; Never forget that the black panthers group was only formed to protect Black people from the kkk, who used to kill Black people like animals. ?? However, the Black Panthers was dismantled by the US govt, but the kkk still exists today. No, tell me this ain't about race. Better still, tell me why is this so? #PanAfricanism #BIaokNationaIism #BlackEmpowerment #AfricanEmpowermeht #AfricanAndProud #BIaokAndProud #BlackPride #BlackPower #BIaCkLivesMatter #Amerikkka #UnapologeticallyBlack #UnapologeticallyAfrican #BlacklhAmerica #BlacklsBeautiful #KnowThySelf #KnowledgeOfSelf #KnowledgeOfSelflsANationaIity #EconomicEmpowerment #IhtegrationFailed #WhiteLiesMatter #Education #AfricanUnifiCation #AfricanUnity #BlackLove #JusticeOrElse #ProBIack #Regrann #blackexcellence #goals #woke | 5.9176 | 369.85 | RUB | 2017-02-17T05:32:50-08:00 | 2017-02-20T05:32:50-08:00 |
| 3123 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan culture, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Black Consciousness Movement, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 1327 | 122 | https://www.facebook.com/Woke-B|acks-294234600956431/ | A free-spirited mind thinks deeply. Thins mind thinks about being detached from the system since Childbirth, thinks about the liberation of his people, thinks about survival in all possible cases. Most importantly, a free-spirited mind always survives, doesn't perish and even does well under any given condition. I hope y'all striving to be free yourselves from the system. #wakeup #wewillsurvive #organize ##joshuabeal #altonsterling #TerenceCrutCher #westandtogether #blacklivesmatter #unite4justice #november8 #elections2016 #black #melanin #blackisbeautiful #blacklivesmatter #blackgirlmagic #U SA #blackahdproud #democrat #republioah #Africanamerican #unite4justice #vote #breakingnews | 1.12 | 70.00 | RUB | 2016-11-11T03:56:07-08:00 | 2016-11-14T03:56:07-08:00 |
| 3129 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 8114 | 890 | https://www.facebook.com/Woke-B|acks-294234600956431/ | I don't know about you, but I'm proud of my African roots, Ghana, West Africa. Which African country do you rep? #melaninqueen #dope #beautiful #wakeup #wewillsurvive #organize #westandtogether #blacklivesmatter #unite4justice #black #melanin #blackisbeautiful #blacklivesmatter #blackgirlmagic #USA #blackandproud #democrat #republioan #Africanamerican #unite4justice #breakingnews #goals #woke | 3.2 | 200.00 | RUB | 2016-12-29T03:51:47-08:00 | 2016-12-30T03:51:47-08:00 |
| 3130 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Black Consciousness Movement, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, interest_expansion:On | 0 | 0 | https://www.facebook.com/Woke-B|acks-294234600956431/ | Her Royal Highness, the faithful woke Black woman, with a sense of purpose, with a determination to keep her man going till the very end. The never—falling natural pillar of her family. Thank you for your unconditional love. Tag a Queen who makes you feel all of the above. #melaninqueen #dope #beautiful #wakeup #wewillsurvive #organize #joshuabeal #altonsterling #TerenceCrutcher #westandtogether #blacklivesmatter #unite4justice #november8 #eleotions2016 #black #melanin #blackisbeautiful #blacklivesmatter #blackgirlmagic #USA #blackandproud #democrat #republioah #Afrioanamerican #unite4justioe #vote #breakingnews | 0.0 | 0.00 | USD | 2016-12-01T07:48:56-08:00 | 2016-12-02T07:48:56-08:00 |
| 3135 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 4514 | 540 | https://www.facebook.com/Woke-B|acks-294234600956431/ | Keep on whining and crying for your president, ooh, who wasn't elected. Imma take care of my kids. I'll keep grinding for them, to make sure the get the best education. To ensure they dress well and eat healthy food. And I'm gon tell you to do the same thing. Don't waste time on an "afterparty" you wouldn't have been invited to! #word #wakeup #organize #joshuabeal #altonsterling #TerenceCrutCher #westandtogether #blacklivesmatter #unite4justice #hovem ber8 #electi0h52016 #black #melanin #blackisbeautiful #blacklivesmatter #blackgirlmagic #USA #blackahdproud #democrat #republioan #Africanamerican #unite4justice #vote #breakingnews | 1.104 | 69.00 | RUB | 2016-11-11T03:57:07-08:00 | 2016-11-14T03:57:07-08:00 |
| 3147 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 8039 | 1127 | https://www.facebook.com/Woke-B|acks-294234600956431/ | One question that always got me worried is, do we in one way or the other stand a Chance of protecting our people with Black people in Charge of things? Whatever the system has got on Black people, i hope these 8 black women, who were elected as judges in Jefferson County, Alabama, are able and will be willing to cause a Change in the lives of Black people. For now, we say, well done ladies! #BlackExcellence #PanAfricanism #BlaokNationalism #BlackEmpowerment #AfricanEmpowermeht #AfricanAndProud #BlaokAndProud #BlackPride #BlackPower #BlackLivesMatter #Amerikkka #UnapologeticallyBlack #UnapologeticallyAfrican #BlacklhAmerica #BlacklsBeautiful #KnowThySelf #KnowledgeOfSelf #KnowledgeOfSelflsANationality #EconomicEmpowerment #IhtegrationFailed #WhiteLiesMatter #Education #AfricanUnifiCation #AfricanUnity #BlackLove #JusticeOrElse #ProBlack #Regrann | 3.2 | 200.00 | RUB | 2017-01-31T03:21:18-08:00 | 2017-02-01T03:21:18-08:00 |
| 3157 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, page:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 4736 | 557 | https://www.facebook.com/Woke-B|acks-294234600956431/ | Joshua was born in Chicago, Illinois, and raised in Indianapolis. Two months before his death, he proposed to his longtime girlfriend and the mother of two sons. Joshua Beal had come to Chicago to serve as a pallbearer in the funeral of his cousin Marcus Washington who was fatally shot on October 27, 2016 in Indianapolis at the age of 26. Beal was fatally shot after he and several relatives were involved in what authorities called a road rage incident with an off-duty police officer and an off- duty firefighter. The relatives along with others in the caravan were headed to Southwest Memorial Chapel after burying their cousin Marcus Washington, she said. Suddenly, Boxley said, a car out her off and then tried to run her 17-year-old sister off the road. She said her family as well as the motorist who had cut her off — who she believed was a Chicago police officer — stopped and got out of their cars. At some point the man pushed her female cousin to the ground and pulled a gun on her, pointing it at her face, according to Boxley. She said the man got inside his car but exited again and “he just started shooting,” hitting the windshield of a car containing Beal, who had pulled his gun when he saw the man holding a gun on their cousin. Boxley said Beal legally owned the gun and did not fire it. Boxley said the man pulled Beal out of his front passenger seat and began shooting him. “I was hoping my brother wasn’t dead,” said Boxley. Beal’s mother said he was a father to two Children, a 4-year-old and a 2—year- old, and that his fiancee was a stay-at-home mother. “This is what CPD do. They tear our families apart over and over again. They have no consideration for life,” - Tiffaney Boxley. Yet another father of two has been shot, and despite what the cop's report will say, i know there can never be a way a Black man isn't guilty for his own death, armed or unarmed. #joshuabeal #altonsterling #TerenceCrutCher #westandtogether #blacklivesmatter #unite4justice | 1.04 | 65.00 | RUB | 2016-11-08T14:25:22-08:00 | 2016-11-09T14:25:22-08:00 |
| 3163 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Black Consciousness Movement, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 711 | 83 | https://www.facebook.com/Woke—B|acks—294234600956431/ | This is exactly what i have been trying to tell y'all. Your vote should be precious to y'all ous its your power to put another person in authority over you, your freedom, your daily life and your safety. To most people, it's about just going out to vote, if you did just that because you want to, well done, if you didn't, aka #BOYCOTT just like me, you also got your reasons. BUT, let those reasons be genuine! Let them be your reasons, not influenced upon or manipulated in any way. I'm proud of this mama not because she didn't vote #Hillary or #Trump, but simply because she did her research, decided for herself, in her interest and the interest of her kids, and voted consciously! I'm glad i Choose not to be a part of this whole system. Im proud to be woke | 0.94384 | 58.99 | RUB | 2016-11-10T07:03:23-08:00 | 2016-11-11T07:03:23-08:00 |
| 3167 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 566 | 115 | https://www.facebook.com/Woke-Blacks-294234600956431/ | End the whining and crying, end the riots with these same white people(democrats), who will not march with you when your son, daughter or loved one gets shot for being Black. I opted out of the elections and i had many Black people all up in my case, telling me how i was wrong and how i needed to make my vote count for Mrs. Clinton, all just to make sure Trump doesn't become president. Well now all i want to say is get over Trump and Clinton, they are rich white people, the elite who were born into and are a part of the system. I dream of liberation, not staying a slave under Hillary or Trump, so forget your Childish rioting, no one has shot! #wakeup #organize #joshuabeal #altonsterling #TerenceCrutCher #westandtogether #blacklivesmatter #unite4justice #novem ber8 #elections2016 #black #melanin #blackisbeautiful #blacklivesmatter #blackgirlmagic #USA #blackandproud #democrat #republioan #Africanamerican #unite4justice #vote #breakingnews | 0.40624 | 25.39 | RUB | 2016-11-15T04:55:06-08:00 | 2016-11-16T04:55:06-08:00 |
| 3170 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan culture, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Black Consciousness Movement, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 5 | 1 | https://www.facebook.com/Woke-Blacks-294234600956431/ | To all Black youth, to all young Black girls and ladies, to the Black gentlemen and to the Black boys, to all Black people, let's never underrate the power of our Queens, every single one of them, from new born babies to their mothers and young university graduates, we believe in you and your strength. Keep the Black girl Magic shinning everywhere. #PanAfricanism #BlaokNationalism #BlackEmpowermen #AfricanEmpowermeht #AfricanAndProud #BlaokAndProud #BlackPride #BlackPower #BlackLivesMatter #Amerikkka #UnapologeticallyBlack #UnapologeticallyAfrican #BlacklhAmerica #BlacklsBeautiful #KnowThySelf #KnowledgeOfSelf #KnowledgeOfSelflsANationality #EconomicEmpowerment #lhtegrationFailed #WhiteLiesMatter #Education #AfricanUnifiCation #AfricanUnity #BlackLove #JusticeOrElse #ProBlack #Regrann #blackexcellence | 0.00944 | 0.59 | RUB | 2017-03-15T08:05:34-07:00 | 2017-03-16T08:05:34-07:00 |
| 3174 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 0 | 0 | https://www.facebook.com/Woke-Blacks-294234600956431/ | | go on social media after taking a break and i read news all around our country and I'm like, really? Is that all we are capable of? Is that all we really wana achieve? To weep over Hillary's lost elections, as if our relative member died? Like wtf? people whining and crying like its our business if she is president. Damn people, it's a system. It doesnt matter who wins or loses! The point is that we've been fucked for over 300yrs and are still being f*cked, so let's fucking organizell That should be our only business!!! #wakeup #organize #joshuabeal #altonsterling #TerenceCrutoher #westandtogether #blacklivesmatter #unite4justice #hovem ber8 #elections2016 #black #melanin #blackisbeautiful #blacklivesmatter #blackgirlmagic #USA #blackahdproud #democrat #republioan #Africanamerican #unite4justice #vote #breakingnews | 0.0 | 0.00 | USD | 2016-11-10T07:02:49-08:00 | 2016-11-11T07:02:49-08:00 |
| 3199 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:BLACK BUSINESS GLOBAL, interests:Black Business Works, interests:African-Amerioan culture, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Black Business Builders Club, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:Instagram Feed, placements:News Feed on mobile devices, interest_expansion:On | 1193 | 4 | https://www.facebook.oom/Black4BlaCk-1268698556482143/ | “It’s important that we support black business because it strengthens the black community and helps to create jobs. It’s also empowering to show your solidarity in coming together to uplift your community,” - Dana Hill, a founder and CEO of COCOTIQUE | 3.2 | 200.00 | RUB | 2016-12-05T06:25:47-08:00 | 2016-12-06T06:25:47-08:00 |
| 3221 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:Instagram Feed, placements:News Feed on mobile devices | 2346 | 10 | https://www.facebook.oom/BIaok4Black-1268698556482143/ | “Everyone should #buyblack this holiday season in an effort to support the businesses that are the backbone of our neighborhoods and communities. Often times, we overlook our own businesses to purchase products and services from businesses outside of our communities. Many of us have heard the disturbing statistic about a dollar Circulating within the black community for only 6 hours compared to approximately 2-4 weeks in white, Jewish, and Asian communities. If we don’t support our entrepreneurs, how can we expect others to support our amazing businesses? We must continue to educate and Change the mindset of consumers so “buying black” becomes the norm amongst our people and not only an encouragement during the holiday season,” said Lonzell Fogle and Breyon Williams, founders of My Suited Life. | 4.8 | 300.00 | RUB | 2016-12-27T06:20:00-08:00 | 2016-12-28T06:20:00-08:00 |
| 3225 | |
location_living_in:United States, interests:Martin Luther King, interests:Jr., interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, age:18 - 65+, placements:News Feed on desktop computers, placements:Instagram Feed, placements:News Feed on mobile devices | 2267 | 19 | http://b|ack4b|ack.info/2017/01/19/boris-kodjoe-more-than-actor/ | "There are always roadblocks, obstacles and Challenges and you have to find other ways to reach your goal. That's what makes it interesting." Boris Kodjoe Success stories Boris Kodjoe: More Than Actor 2017-01-192017-01-19 0 Comment Boris Kodjoe, the World of Alfa Clothing "There are always roadblocks, obstacles and Challenges and you have to find other ways to reach your goal. That's what makes it interesting." Boris Kodjoe Born Boris Frederic Cecil... Boris Kodjoe: More Than Actor — Black4Black blaok4blaok.info | 7.48 | 467.50 | RUB | 2017-01-24T01:04:29-08:00 | 2017-01-25T01:04:29-08:00 |
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