home / russian-ads

display_ads (view)

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

45 rows where an ad_target was location_living_in:united_states:Baltimore Maryland; Ferguson

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
117 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 45 7 https://www.facebook.com/BlaCk-Matters-1579673598947501/ "I can‘t breathe" symbolize an anger and frustration over the relationship between law enforcement and black people in America. 0.16496000000000002 10.31 RUB 2015-07-16T02:22:00-07:00 2015-07-18T02:22:00-07:00
118 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 327 18 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Ta-Nehisi Coates on growing up in West Baltimore The famous African-Amerioan writer Ta-Nehisi Coates grew up in West Baltimore with people who lost a Child whether to the streets, to guns or to jail. Today, his goal is to protect his son from the different forms of violence that he experienced in school and on the streets. People of color have been dealing with injustice ever since they crossed the North American continent. For instance, in West Baltimore, Ta-Nehisi was trained not to go to the neighborhoods unless you know this place. He was told that you cannot tolerate anybody attempting any physically violent threat to you. Moreover, his mom was feared that her Children would get arrested. What does it mean? Undoubtedly, black Americans were afraid of police, improper procedure, injustice or what is worse, being killed by police officer. That‘s why the nationwide furor over the growing number of unarmed black men fatally shot by police officers has put the public on a new trend in America. In fact, this new trend caused disproportionate number of unarmed people of color killed by police. How dangerous is to live in your area today? 2.52352 157.72 RUB 2015-07-15T08:23:22-07:00 2015-07-16T08:23:21-07:00
124 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 15 2 https://www.facebook.com/BlaCk-Matters-1579673598947501/ ‘Hands up, don‘t shoot‘ was built on pain. We don‘t ask police to hug us, we only ask them to stop killing black men. Because we are disproportionally killed by cops over and over again. 0.07872 4.92 RUB 2015-07-17T06:33:37-07:00 2015-07-19T06:33:37-07:00
125 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 28 10 https://www.facebook.com/BlaCk-Matters-1579673598947501/ 90-year-old VWVII veteran is evicted on stretcher. The VWVII veteran Johnnie H. Hodges refused to leave his house after he was not able to pay his mortgage while caring for his sick wife. Police and ambulance workers had to carry him away on a stretcher. A 90-year-old Navy veteran lived in his Buffalo home with his wife for decades. But about four years ago, he was taking care of his wife, who had Alzheimer’s disease and spent all his income on her rehabilitation. In the process, he defaulted on his mortgage and amassed a huge debt totaling $73,000 to M&T Bank. Unfortunately, due to his default on his mortgage loan payments, he was evicted from his house on a stretcher. Why does the US. government treat military veterans absolutely disgracefully? Why the VWVII veterans are literally being treated like human garbage by their own government? How potentially disabled veteran was evicted from his house? How come homelessness and unemployment among American veterans is much higher today than for the general population of the United States of America? 0.1416 8.85 RUB 2015-07-17T06:33:04-07:00 2015-07-19T06:33:04-07:00
126 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 18 3 https://www.facebook.com/BlaCk-Matters-1579673598947501/ What differences do you see in the picture below? What do you think is the difference between police attitude towards white Citizens and black Citizens? Think about it. 0.0712 4.45 RUB 2015-07-17T06:32:46-07:00 2015-07-19T06:32:45-07:00
127 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 5959 754 https://www.facebook.com/BlaCk-Matters-1579673598947501/ St. Louis police shot teenager. Teen is paralyzed. Last Saturday the 16-year-old Brandon Claxton prompted an officer to shoot him three times in a housing complex in Hodiamont Avenue. According to police, they responded to a call about someone with a stolen 40-Caliber pistol. Brandon Claxton is in critical conditions. But according to witnesses, Brandon did not point a pistol at anyone but he was trying to run away from the officers. Where is the video evidence of police shooting? Police Chief Sam Dotson said that there is not a Clear view on video. What if police is trying to cover up the story? Did you know that police did not allow Brandon’s mother to see her son because he was in custody? Do you believe that police was justified to arrest Brandon? Cameras don‘t lie! We need to know the truth whether the boy posed a threat or not! 8.0 500.00 RUB 2015-07-17T00:52:41-07:00 2015-07-19T00:52:40-07:00
128 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 1704 184 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Rapper OG Mace walked the red carpet of BET Awards in a shirt donning the names of police brutality victims. Helluva statement, indeed! 2.09008 130.63 RUB 2015-07-21T07:32:31-07:00 2015-07-23T07:32:30-07:00
129 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 1536 157 https://www.facebook.com/BlaCk-Matters-1579673598947501/ This is so sad.. how s|ow|y this is becoming reality. Please America. Please wake up and realize it's time to Change. Don't hide your head in the sand 2.00896 125.56 RUB 2015-07-21T06:55:01-07:00 2015-07-23T06:55:01-07:00
130 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 869 125 https://www.facebook.com/BlaCk-Matters-1579673598947501/ 'We want our Chief back' Last week, in a place that bills itself as the “Friendliest Town on the Eastern Shore,” angry residents marched to City Hall, demanding to give back a job for Kelvin Sewell, the community’s first black police Chief. On June 29 he was fired amid allegations leveled against white officers of departmental racism. After that the crowd of Sewell's supporters moved to voice their outrage to the Pooomoke City Council with posters that read "We Support Chief Kelvin Sewell." As a nation we have looked the other way for far too long and it is disgraceful! This time we're not fighting with police, we're fighting forjustioe. The system is broken, police doesn't protect us and the government cares only about tycoons' interests. So here's a question - who will care about Americans who can't protect themselves? Who will care about us? #JusticeforChiefSewell 3.372 210.75 RUB 2015-07-21T06:54:35-07:00 2015-07-23T06:54:33-07:00
131 location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 1426 109 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Made In The US: The Justice Turns lnto Business For years, inmates with non-violent felonies and misdemeanor Charges in New York City had to sit in Rikers Island for months awaiting trial, 'Cause they couldn’t afford to pay bail. Under the City’s new bail initiative announced by Mayor Bill de Blasio last week, some 3,000 low-level offenders are eligible for release without bail. The system needs serious reform. According to the New York Police Department, the biggest part of arrests are low-level offenses like peeing on the street or disorderly conduct. The New York Daily News reports that 81 percent of the 7.3 million people hit with summonses between 2001 and 2013 were black and Hispanic. So what should we do? The criminal penal system is antiquated. It should be Changed. The worse, it is now designed to be for profit which has led to laws being designed to keep people in prison, rather than rehabilitating. More and more it looks like it's a business. The first rule of any society is development. At such rate the US government will start to sell indulgences soon. Our system is not only unfair, but also corrupt! We should explore alternative solutions and limit the number of people in prison to the most violent and potentially dangerous offenders. Only real criminals should be in jail! Lemme ask you, have you ever seen a one of the tobacco industry executives go to jail? I guess no. We also have never seen the Bush or any other Presidents administrations were brought to justice. America has a justice system that was supplanted the Jim Crow laws as a means to keep the minorities from developing real opportunities for keeping the very rich from ever being brought to justice. 5.83792 364.87 RUB    
132 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 1244 161 https://www.facebook.com/BlaCk-Matters-1579673598947501/ KKK, African-Amerioan group plan rallies at South Carolina Capitol Could you please just Close your eyes for a minute? Now, imagine... 70-years after the Third Reich was down, Berlin organizes Nazi military parade. Sounds weird, inconceivable right? So tell me, why KKK march at South Carolina Capitol draws the ire only of local African-Amerioans? A Ku Klux Klan Chapter and an African-Amerioan group plan overlapping demonstrations on Saturday outside the South Carolina State House, where state officials removed the Confederate battle flag last week. We have been fought with slavery, Jim Crow laws and etc for REALLy long time so what's the problem today? Nothing good coming out of this mess. So what is the purpose of this march? Hmmm... It feels like this could be billed as "the fight of the century." What do you think about it guys? 4.44768 277.98 RUB 2015-07-21T06:53:25-07:00 2015-07-22T06:53:24-07:00
133 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 0 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Another Woman Commits Suicide In Jail A teen committed suicide in a jail cell an hour after being arrested, another suspicious case of a Black woman dying in police custody in the past week. The second case over a week, huh? How retarded and/or brainwashed by Fox News is one supposed to be to believe this is a coincidence? No way we are gonna buy such bullshit. The weirdest thing about this specific case is that the suicide was committed just an hour after the arrest. Moreover, the woman was suspected of stealing someone’s phone which is quite not a reason for getting to her account. We've got to also take into consideration that 1 in 3 black men go to prison as opposed to a considerably lower rate with the white men (http://www.alternet. org/story/154587/1 in 3 blaok_men_go_to_prison_the_10_most_disturbing_ facts_about_racia|_inequality_in the_u.s._criminal_justice_system). It definitely seems like there’s more to this since until recently taking into custody hasn’t been a reason for suicide among black women. Now for some people the only way to deal with police violence at the police stations is simply killing themselves... 0.0 0.00 USD 2015-07-21T07:32:07-07:00 2015-07-23T07:32:07-07:00
134 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 117 18 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Black, white, Asian, Hispanic, it doesn’t matter. Racism is racism, it’s wrong regardless. 0.55872 34.92 RUB 2015-08-04T05:32:25-07:00 2015-08-05T05:32:24-07:00
135 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 14 1 https://www.facebook.com/BlaCk-Matters-1579673598947501/ | see racism as a pervasive element of both right and left wing politics in the US. Trust no one. 0.05504 3.44 RUB 2015-08-04T08:31:29-07:00 2015-08-05T08:31:28-07:00
136 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 12708 1347 https://www.facebook.com/BlaCk-Matters-1579673598947501/ We do not need to drink the water from the fountain of youth. Because black don‘t crack! 16.0 1000.00 RUB 2015-08-06T07:38:42-07:00 2015-08-08T23:38:00-07:00
137 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 1294 120 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Special prosecutor opened an investigation into death of black women Raynette Turner New York Attorney General Eric Schneiderman will launch an investigation into to the death of one of the five black women who died in an American jail over a two-week span. Raynette Tumer who was the mother of eight Children died in jail cell in police custody last week. She was arrested for shoplifting some crab legs from a grocery store. Due to her bad health history she was taken to the hospital and released. But she died in jail waiting for someone to help. According to American legislation, the courthouse officials are supposed to Check the cell every fifteen minutes but, no one Checked Tumer‘s cell for more than two hours. A total of five African-Amerioan women have been found dead in police custody in just the last month. Most of them were hold for minor Charges and still their deaths are under investigation. Sandra Bland from Texas, Kindra Chapman from Alabama, Joyce Curnell from South Carolina, Ralkina Jones from Ohio, and Raynetta Turner from New York were found dead in their cell after being arrested by police officers. Once again it raises questions about how black people are treated in police custody. What if death in police custody is about excessive police force? Do you realize that dozens of black people were found dead in the US? 4.436319999999999 277.27 RUB 2015-08-05T07:05:06-07:00 2015-08-06T07:05:06-07:00
138 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 3595 242 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Black people come together! Only together we are stronger! Stand up for your rights! Stand up against discrimination! Stand up for equality! It all depends on us, not the Congress,neither the White House. Because it‘s not the government who want to end discrimination. 16.40832 1025.52 RUB 2015-08-05T07:04:05-07:00 2015-08-06T07:31:10-07:00
139 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 902 92 https://www.facebook.com/BlaCk-Matters-1579673598947501/ The Civil Rights Activist Mary McLeod Bethune Mary McLeod Bethune was the Civil rights activist and an educator who found the National Council of Negro Women in 1935. Being one of the 17 Children of former slaves she was the first and the only Child to go to African-Amerioan school. She found the Daytona Normal and Industrial Institute for Negro Girls because she believed that education was the key to racial advancement. In addition, Bethune did a lot of work to contribute to American society. For instance, she was the president of the Florida Chapter of the National Association of Colored Women. Moreover, in 1935 Mary Bethune became an advisory to President Roosevelt on minority affairs and later on she started her Civil rights organization, the National Council of Negro Women. The great educator and Civil right activist Mary McLeod Bethune demonstrated the values of education, the philosophy of love and the wise use of power. Sadly, at least 10 years of data reveals that Congress don‘t pay attention to American Civil rights as Mary McLeod Bethune did 80 years ago. 4.56192 285.12 RUB 2015-08-05T07:03:32-07:00 2015-08-06T07:03:32-07:00
140 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 847 70 https://www.facebook.com/BlaCk-Matters-1579673598947501/ The drama in Pocomoke. A Maryland town several weeks ago fired its first black Police Chief, now exposing a racial rift The leaders of small Maryland‘s City in Eastern Shore fired the Pocomoke City‘s first black police Chief Kelvin Sewell due to his incompetence and refusal to fire black police officers Franklin Savage and Lynell Green. Chief Sewell was hired by Pocomoke City back in 2010 after his retirement from the Baltimore Police Department. Earlier, before Sewell‘s dismissal he filed a complaint on unequal employment opportunities Claiming he was paid less than his white predecessors. This is Circumstantial evidence that America is divided into different parts based on race and income. Racism has gotten so bad, black people are treated unfairly. If God created us equally, why the unequal treatment of minorities still exists in our country? What if the firing gas stirred a new spirit of African-American activism? 2.84224 177.64 RUB 2015-08-05T07:03:16-07:00 2015-08-06T07:03:15-07:00
141 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 0 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Who said that protesting is not effective? Yes, it is! How many black people were killed and shot by police department for the past few years? How many protests have been held since 2013? How useful were protests? According to analysis by AP, 24 states have put 40 new laws to tackle police violence such as use of police officer body cameras, raciaI-bias training and surplus of military equipment. However, there is more work to be done to solve racial tensions in America. The public stand against discrimination happens when there is lack of inside connections with the government. People attempt to stop racism the government usually assumes to be problematic but protesters force the government to find compromise. It‘s a well known fact, when governments do not deliver, people protest. 0.0 0.00 USD 2015-08-05T01:58:00-07:00 2015-08-06T00:11:58-07:00
142 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 221 35 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Three Bronx officers were caught on camera by the passenger in a car as the driver appears to be repeatedly punched in the head and thrown to the ground. “Y’all is punching me in the face. What did I do to deserve this?” the 24-year-old Timothy Nelson can be heard saying in the recording of the July 26 traffic stop. Do they really need 20 cops showing up for a traffic stop? And that's why I’d rather call a crack head for help before I call the cops ..... they don't protect and serve, they shoot and kill anybody that's not wearing a police badge. And I do not wear it. 0.98128 61.33 RUB 2015-08-04T08:31:58-07:00 2015-08-05T08:31:58-07:00
143 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 105 9 https://www.facebook.com/BlaCk-Matters-1579673598947501/ So basically cops are detaining folks for no real reason in order to find a reason to further detain & arrest them. That's a problem. 0.51008 31.88 RUB 2015-08-04T08:31:45-07:00 2015-08-05T08:31:44-07:00
144 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 351 63 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Man rammed St. Louis police car 'for the black people'. Black people are fed up with an age of racist society? The 48-year-old Kevin Labriado from Bellefontaine Neighbors was Charged for ramming police car from behind twice screaming “for black people”. He assaulted two officers and his Child who was sitting in his car. Two St. Louis officers were on patrol until Labriado and his five-year-old daughter accidentally rammed their car. When police officer tried to arrest him, Labriado yelled several times "This is for the black people”. What if Labriado sought to revenge for all black lives that officers took away? Racism obviously gave rise to the tensions in society that led to disrespect and hate. Moreover, black people are fed up with racism and police violence towards black community. What is more, racial tensions have gotten worse under the current government. Even after several months of protests over the deaths of Eric Garner, Tamir Rice, Michael Brown, Sandra Bland and Freddie Gray the government inspired more unrest. Today black community is in desperate situation seeking for help. 1.3611199999999999 85.07 RUB 2015-08-04T08:30:58-07:00 2015-08-05T08:30:58-07:00
145 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 402 49 https://www.facebook.com/BlaCk-Matters-1579673598947501/ We can start by having community days for the kids_ it’s a must to invest in the youth. We underestimate what we’re capable of doing on our own. We don’t have to wait on others to value our lives. 1.0539200000000002 65.87 RUB 2015-08-04T05:31:20-07:00 2015-08-05T05:31:20-07:00
146 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 0 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Alabama Police Officer Kept His Job After Proposal to Murder Black Man and Hide Evidence A police officer in Alabama proposed murdering a black resident and creating bogus evidence to suggest the killing was in seIf-defense. Officer Troy Middlebrooks kept his job and continues to patrol Alexander City after authorities there paid the man $35,000 to avoid being publicly sued over the incident. Middlebrooks, a veteran of the US marines, said the man “needs a god damn bullet” and allegedly referred to him as “that nigger”, after becoming frustrated that the man was not punished more harshly over a prior run-In. The payment was made to the black resident, Vincent Bias, after a secret recording of Middlebrooks’s remarks was played to the City’s police Chiefs and the mayor. Elected City councillors said they were not consulted. Do you know that you can go to prison for murderous intent? However, if you are a white police officer, offering to KILL a BLACK AMERICAN and then hide the evidence, then you don't even get fired. Oh yeah, it's happening in a wonderful state called Alabama! You know how it works here. Do you have any more questions for American law enforcement system? 0.0 0.00 USD 2015-08-06T07:36:02-07:00 2015-08-07T07:36:01-07:00
147 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 290 86 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Young, Unarmed Black Man Killed By Cop Didn't Want To 'Die Too Young' An unarmed black teenager in Texas was shot dead by a cop who had only recently graduated from the police academy. Just over a week before his death, he posted that he doesn't want to die too young on Twitter. Officers responded to a burglary call around 1 am. on Friday, hearing reports that a suspect was damaging vehicles. First spotting Taylor moving about the lot, officers also noticed Taylor's SUV had been smashed into the front of the dealership showroom. Finding that Taylor had moved inside the showroom, Arlington Police Chief Police Will Johnson said Taylor would not comply when told to lie down on the ground, but fled to a back room. 49-year-old officer Brad Miller entered the showroom to arrest Taylor, and then an altercation broke out. Miller fired four shots, including the fatal bullets from the gun of Miller. A second officer fired a taser, Johnson said. And now there are three main points that you should think of: 1) Taylor was described as a good kid. He was a football player at Angelo State University. Never was involved in criminal activities. 2) The officer graduated from the police academy less than 6 months ago and was working under the supervision of a training officer. 3) Taylor didn't want to die young. Black teens don't really live, they survive. And, unfortunately, there is no one to save them from death. There is no one to stop police brutality. We all want our kids to feel safe, we want them to be safe and sound. Are our hopes doomed to disappointment? 0.71264 44.54 RUB 2015-08-10T07:36:40-07:00 2015-08-11T07:36:39-07:00
148 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 8752 1102 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Michael, we didn’t forget you. We haven’t forgotten anyone. No justice - no peace. #BlackLivesMatter #Ferguson 15.99984 999.99 RUB 2015-08-12T00:53:51-07:00 2015-08-14T00:53:50-07:00
149 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 0 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ BREAKING NEWS! #Oakland #JoeBart Oakland police officers fatally shot a man suspected in alleged carjaoking attempt in Downtown Oakland Wednesday night. Is it a race war? Yesterday night, a group of 50 protesters burned Confederate flag and tried to shutdown a freeway in Downtown Oakland. The opposition to police violence was in response to the police shooting earlier in the day. According to Oakland Police Department, yesterday at 2:39 pm. in the area of 69th Avenue and International Boulevard, Oakland police officers spotted a vehicle they believe to be connected to a previous robbery on July 27. The pursuit started when the driver fled through Oakland streets until the suspect crashed into another car in the area of 27th Avenue and Martin Luther King Jr. street. But when the suspect ran of the car, three officers opened fire. The suspect Joe Bart has died at the hospital. Did you know that it was fifth shooting this year that involved police officers? How quickly it has become so usual? Why it has become so legit? Where is the government speaking about the existence of racism in America? Black Lives Matter! 0.0 0.00 USD 2015-08-13T07:18:16-07:00 2015-08-15T07:18:16-07:00
150 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 294 34 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Black people still face discrimination New data shows that white privilege sti|| dominates in the United States of America. It is painfully obvious that unequal treatment is harmful on a daily basis. For instance, poor service plays an important role contributing to alteration in health that is potential harmful realities for many black people. 1.3272000000000002 82.95 RUB 2015-08-18T08:23:09-07:00 2015-08-19T08:23:09-07:00
151 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 594 63 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Why black parents worry about their Children? How should we talk to our Children about how safely interact with police officers in order to protect themselves? Tina Carter—Shileds has five kids and three of them recently started to drive. The first thought she had when they wanted to drive alone was 'Wait a minute. I'm really scared right now.' What should they do if they get pulled over? What if they do something they don‘t supposed to be doing? It is not always fair when officers arrest African Americans, but it‘s a reality. What if police officers will automatically assume that your Child is criminal because of how him or her looks. Black parents should remember that their kids will always be judged by the way they look. That‘s why it‘s important to instruct our Children how to react when you are in trouble with law enforcement. Because if a stranger follows your Child after him/her buy a bag of Skittles, ran back into the store. Remember, anything is better than dying. Anyways, it‘s hard to believe that in 21st century black parents have to teach their Children both survive and thrive. But who will take responsibility for training police officers? 2.5636799999999997 160.23 RUB 2015-08-18T08:22:50-07:00 2015-08-19T08:22:49-07:00
152 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 315 42 https://www.facebook.com/BlaCk-Matters-1579673598947501/ What is like to live in America if you are black? Well, first of all you have to work much harder to prove that you are worth others. Second of all, everybody is judging and stereotyping you by the color of your skin. Third of all, you are always being an “other” even in the country you were born. Forth of all you are always expected to be load and to dance well. In addition, there are lots of people who like to “throw race cards”. Can we live like that? How long should we wait for the government contributions? 1.9128 119.55 RUB 2015-08-18T08:22:26-07:00 2015-08-19T08:22:25-07:00
153 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 11736 1130 https://www.facebook.com/BlaCk-Matters-1579673598947501/ 300 Men March begins with 35-mile walk to DC. to denounce epidemic of the culture of gun violence and racism 35-mile trek to Washington has started this Sunday evening in order to bring more attention to widespread violence in different Cities across America. The founder of the group Munir Bahar said that the march will last 20 hours in a memory of more than 200 people who have been killed in Baltimore this year. The 300 Men March will highlight the racism and violence across the country. What‘s wrong with our society? Police kill unarmed Citizens, we kill each other. What example we will be setting for the future generations? How are we going to break the cycle of violence? Are there any Chances to overcome deeply rooted racism and violence in America? What if peace comes after the fairness? 22.63952 1414.97 RUB 2015-08-18T08:22:08-07:00 2015-08-21T08:22:00-07:00
154 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 553 70 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Straight Outta Compton is straight reality The new movie Straight Outta Compton focus on legendary hip-hop pioneers N.W.A. and their struggles against racism and police violence. The movie is coming this weekend in the theaters. However, some of the Cinemas refused to show the movie, Citing “safety and liability” concerns. Does it remind you of anything? How about Ferguson? How about Baltimore? Today you are willing to be detained in the name of defending your rights. Today cops can easily shoot you for a small violation. Even having black cops and black mayors doesn‘t end police brutality. Fortunately today you are allowed to record police officers in order to further prevent potentially serious cases of police wrongdoing fairly. 1.9366400000000001 121.04 RUB 2015-08-18T08:21:46-07:00 2015-08-19T08:21:45-07:00
155 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 199 21 https://www.facebook.com/BlaCk-Matters-1579673598947501/ 14 Police Officers Take Down A One-legged Homeless Black Man Armed With Crutches in San Francisco Writer Chaédria LaBouvier reported that she had seen 14 San Francisco police officers subduing a homeless black man who had one leg outside Twitter headquarters. Witnesses told LaBouvier that police had been called because the man was waving “sticks,” which later turned out to be his crutches. None of the employees at Twitter or other tech companies came out to object as the 14 officers took down the one-legged homeless man. The US. Justice Department recently filed court documents in an Idaho case which declared it unconstitutional to criminalize homelessness. According to the Coalition on Homelessness, the City handed out 11,000 Citations to homeless people who were sitting on sidewalks between 7 am. and 11 pm. in 2014. What kind of people police usually hire? Mentally unstable bloodthirsty cowards or? We already know the answer. Sometimes we all wonder do police officers have mercy for anyone? Hard to say, because what we see confuses us. 1.30272 81.42 RUB 2015-08-18T08:21:25-07:00 2015-08-19T08:21:24-07:00
156 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 219 32 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Hand-colored portrait of an unidentified black woman shucking corn. By George Barnard. 1.30288 81.43 RUB 2015-08-18T08:20:41-07:00 2015-08-19T08:20:40-07:00
157 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 2644 251 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Racism doesn't usually look like someone shouting slurs, it looks like people eagerly looking for a reason why a black kid deserved to die. 6.6230400000000005 413.94 RUB 2015-08-18T08:20:23-07:00 2015-08-21T08:20:00-07:00
158 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 447 99 https://www.facebook.com/BlaCk-Matters-1579673598947501/ BREAKING NEWS! St. Louis police fatally shot a black teenager while trying to issue search warrant On Wednesday, Aug. 19 racial tensions again sparked in Missouri City after St. Louis police officers fatally shot black teenager at Walton Avenue and Page Boulevard while trying to issue search warrant. According to St. Louis Police Chief San Dotson, a young black man pointed a gun at officers and was trying to escape from a house where officers were carrying out a search warrant for him. The 33-year-old and 20-year-old officers who shot the suspect four times were about seven years on the force. That was followed by crowd of 150 people who gathered by intersection. Later on, nine people were arrested on Charges of resisting arrest. The protesters said that the police provoked the situation. What do you think about it? What if this situation makes us want to keep the police out of our neighborhood? Why do you think police shoots first and then asks questions? Do you realize that the shooting came just ten days after St. Louis was flooded with protesters who were marking the anniversary of Michael Brown? What if the City and the government needs to center its attention on racism and discrimination in America instead of suspecting every single black men? We cannot accept the fact that police can easily kill black people in America, than we must do something about it. Protest or accept it. You Choose. This is your life. 1.6 100.00 RUB 2015-08-21T08:05:07-07:00 2015-08-22T08:05:07-07:00
159 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 322 47 https://www.facebook.com/BlaCk-Matters-1579673598947501/ What is like driving while black in America? Throughout the twenty-first century there are thousands of complaints of the police “profiling” black drivers in America. Black Americans often complaint about being pulled over for the phenomenon called “driving while black”. For example, a rich African American driving new Ferrari can be stopped hundreds of times for no apparent reason just because the fact that a black man driving an expensive car attract the attention of the police officers. But what if racial profiling ends with lethal consequences? Do you remember Sandra Bland who had run-ins with the police while driving? Do you all remember that she was found dead in police custody? Do we all have to avoid traffic stops in order to survive? For the matter of fact, the routine traffic stops are being a big deal for the people of color. According to the Justice Department statistics, black drivers are about 31 percent more likely to be subject to police than whites. Overall, this number indicates the racial difference in America. 1.6 100.00 RUB 2015-08-21T07:46:04-07:00 2015-08-22T08:00:00-07:00
160 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 3218 408 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Silenced racism in America Tamir Rice, Rumain Brisbon, Kajieme Powel, Dante Parker, Michael Brown, John Crawford III, Eric Garner, Jonathan Ferrell, Kimani Gray, Michael Brown and Sandra Bland are one of many examples of excessive police brutality used on black Americans. You never know if a simple traffic stop will end up with you in a police custody or bullets in your Chest. Unfortunately, many of Americans feel very uncomfortable talking about these issues, which seem to confirm the idea that the government remain silent. Nevertheless, one should accept that African-Americans are more likely to be targeted by police officers on the street than whites. Therefore it endangers the rights of black community. Doubtless when the government defends the officers who have killed black men, it strikes us how unfair the system is and reaffirms our view that America would spend billions of dollars on radical extremists than talking about the domestic terrorism, racial inequality and police brutality. 7.7303999999999995 483.15 RUB 2015-08-21T07:45:31-07:00 2015-08-26T09:00:00-07:00
161 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 1720 230 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Black power is greater then you thought. You just have to use it right. Fight for your Civil rights, use your power! Civil Rights legislation is the most effective step towards eliminating unspoken by the government inequality in America. What if the Civil rights movement generates social Change? What if the Civil rights movement accelerates the process of ”the same opportunities”? 9.35632 584.77 RUB 2015-08-20T07:43:42-07:00 2015-08-21T08:46:32-07:00
162 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 0 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Confederate flags are permitted to fly at schools in Tennessee. Parents are worried about their Children‘s safety. Yet here we are, Tennessee parents are worried about their Children‘s safety at the local school after discovering that anyone is permitted to wear Confederate flag attire and to fly the Confederate flags at school. This provoked widespread discontent among black parents of Rutherford County. One of the parents said that she witnessed the students wearing the Confederate flag T-shirt and the controversial flags flying in the back students‘ cars. How would you feel if your Child studies among those who like to fly the Confederate flags on their trucks? How would you feel about the safety of your Child? Why Children were permitted to openly display the Confederate flag on the school grounds? What kind of symbol the Confederate flag is for you? Do you remember Dylanh Roof who killed black people at Church? Do you remember that he was promoting the Confederate flag? What if your Child studies among the same people? Is it an appropriate place for your kid to study? If Nazi flag was banned, than the Confederate flag must be outlawed too. Thus, if the government continues to accept this flag, it will bring more racist and hateful movements, because the Confederate flag shows a lack of empathy for African Americans slavery and for every black American man. 0.0 0.00 USD 2015-08-20T07:42:57-07:00 2015-08-21T10:20:07-07:00
163 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 259 36 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Are you going to vote in this presidential election as young black male or female? The founder and editor-in-Chief of Black Millennial and one of the organizers of Black Lives Matter NYC Arielle Newton is 23-years-old. She is black college-educated woman who is drawing in $160,000 student loan debt. Today, Arielle is centered on the roots causes racism and resulting epidemic discrimination and socioeconomic illness. In fact, in her opinion the candidates for the next president of the United States of America are problematic in terms of lack of transparency and accountability. For instance, one candidate is complicit in fueling the war on drugs; another one in corrupted criminal justice system, next one in making racial justice as the centerpiece of the campaign as a strategy to have more black voters. Doubtless, voting won‘t bring us safety and won‘t provide us an immediate conduit for our social weII-being. Ironically, even the first black president of the United States of America was not able to withstand the racist opposition and law enforcement. It means voting again for anti-black system won‘t save black lives, but might jeopardize it. 1.1848 74.05 RUB 2015-08-20T07:42:15-07:00 2015-08-21T09:32:36-07:00
165 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 2543 309 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Love this sign because it's true. Whether killed orjailed, too many Black Children lose their fathers because of corrupted system. 3.94224 246.39 RUB 2015-08-24T08:27:46-07:00 2015-08-27T08:27:00-07:00
166 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 323 47 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Prominent Black Lives Matter activist Shaun King revealed to be white Black Lives Matter activist Shaun King has Claimed for years that he is biracial, being born to a white mother and a black father. But recently uncovered records Claim he misled the public about his race, and that he is in fact a white man pretending to be black. King’s race would not be under scrutiny if it was not an essential component of his career, education and social status. In addition to getting a full-ride scholarship that is exclusively for black men, King has the position of “Justice Columnist” at progressive news website Daily Kos and enjoys a 169,000-strong follower count on Twitter, most of whom are a result of his activism following the death of Mike Brown in Ferguson. King’s race would not be under scrutiny if it was not an essential component of his career, education and social status. In addition to getting a full-ride scholarship that is exclusively for black men, King has the position of “Justice Columnist” at progressive news website Daily Kos and enjoys a 169,000-strong follower count on Twitter, most of whom are a result of his activism following the death of Mike Brown in Ferguson. King still did not directly answer the simple yes or no question about his ethnic background: Are you black? Instead, he said, “If you have known me from when l was in elementary school at Huntertown Elementary until now, you’ve known me as black or bi-racial.” Turning blackness into a performance is anti-blackness—irrespective of whether the white person doing it is Rachel Dolezal or Shaun King. 1.2499200000000001 78.12 RUB 2015-08-24T08:27:21-07:00 2015-08-25T08:27:21-07:00
318 no image location_living_in:united_states:Baltimore Maryland; Ferguson, location_living_in:united_states:St. Louis Missouri; Cleveland Ohio, 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 1331 90 https://www.facebook.com/BlaCk-Matters-1579673598947501/   4.0564800000000005 253.53 RUB 2015-07-16T02:22:53-07:00 2015-07-19T02:22:53-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 1351.972ms · Data source: simonw/russian-ira-facebook-ads-datasette