home / russian-ads

display_ads (view)

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

3,498 rows sorted by impressions

View and edit SQL

id img targeting impressions ▼ clicks url text spend_usd spend_amount spend_currency created ended
6 location:United States, age:13 - 44, language:English (US), placements:Instagram Feed, people_who_match:interests:Christ's Commission Fellowship, people_who_match:interests:Jesus, people_who_match:interests:Jesus Daily, people_who_match:interests:Knowing Jesus, people_who_match:interests:Walk with Jesus, people_who_match:interests:The Bible (TV miniseries) 0 0 https://www.facebook.com/Bat-240131319678646/ Conservative Christians. Pro—Iife/ gun/ police/ military. Follow! 0.0 0.00 USD 2016-05-12T04:06:17-07:00  
18 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, language:English (US), placements:Instagram Feed 0 0 https://instagram.Com/veterans_us/ What do you know about PTSD? There is no greater agony. PTSD affects a person's memory, emotional responses, intellectual processes and nervous system. Nearly 31% of veterans fight this agony every day. Do you want to learn more? Click here! Veterans USA ( @veterans GovSpending 0.0 0.00 USD 2015-11-19T05:18:16-08:00 2015-11-21T10:28:00-08:00
30 location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, language:English (US), placements:Instagram Feed 0 0 https://instagram.Com/veterans_us/ Click learn more! People don't want to look at the homeless. But maybe they will look at, or think about, or support dealing with homelessness once they know that 12% of the homeless adult population are veterans. Join us! Veterans USA ( @veterans GovSpending 0.0 0.00 USD 2015-11-19T05:20:22-08:00 2015-11-21T10:28:00-08:00
34 location:United States, age:13 - 35, language:English (US), placements:Instagram Feed, people_who_match:interests:Conservatism, people_who_match:interests:Veterans Day, people_who_match:interests:Tea Party Patriots, people_who_match:interests:Veterans, people_who_match:interests:Republican Party (United States), people_who_match:interests:Supporting Our Veterans 0 0 https://www.instagram.Com/veterans_us/ A Wounded Warrior and his service dog. Support our Veterans - Follow! Black America ( @black Instalol 0.0 0.00 USD 2016-05-12T02:31:30-07:00  
35 location:United States, age:13 - 35, language:English (US), placements:Instagram Feed, people_who_match:interests:Military, people_who_match:interests:Veterans, people_who_match:interests:Politics 0 0 https://www.instagram.Com/veterahs_us/ There are some people who will always support you! And unfortunately, the VA is not on the list. There are numerous examples of disgusting treatment of our Veterans by the VA employees. And there is little Chance the situation will Change in the near future. The failure of the Defense Department and VA to create a joint electronic health record, despite spending $1 billion for development is just another example of it. Click Learn More! Veterans USA ( @veterans GovSpending 0.0 0.00 USD 2016-01-14T06:25:20-08:00  
43 location_living_in:United States, interests:Cop Block, age:18 - 65+, language:English (US), placements:Instagram Feed 0 0 https://instagram.Com/Cop_block_us Together we can stop them. Join the fight. Follow @COp_b|OCk_US Cop block is a grassroots organization working to make police accountable for their actions. Cop Block Us (@COp_b|OCk_US) - Instagram photos and videos 0.0 0.00 USD 2015-10-13T02:27:35-07:00 2015-10-15T23:59:59-07:00
44 location_living_in:united_states:Texas, age:18 - 65+, language:English (US), placements:Instagram Feed 0 0 https://instagram.Com/south_lone_star You can go to hell or follow @south_lone_star instead! Texas is where you always want to be! We are Texans and we're not like the rest! Follow us! Lone Star State Rebels (@south_lone_star) - Instagram photos and videos 0.0 0.00 USD 2015-10-13T01:34:37-07:00 2015-10-15T23:59:59-07:00
45 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Syria Charity, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:African- American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Syria- News or Malcolm X, people_who_match:interests:Employers: Syria 0 0 https://www.facebook.com/Woke-B|acks-294234600956431/ We always condemn racism and terrorism because they only affect the poor and less privilege in society. So don't be fooled into making this mistake: The war in Syria is just another rich white man's way to profit at the cost of innocent lives... and yes, Flint is stillwithout Clean water. #wokeblacks #PanAfricanism #BlackNationalism #BlackEmpowerment #AfricanEmpowermeht #AfricanAndProud #BlaCkAndProud #BlackPride #BlackPower #BlackLivesMatter #Amerikkka #UnapologeticallyBlack #UnapologeticallyAfrican #BlacklhAmerica #BIackIsBeautiful #KnowThySelf #KnowledgeOfSelf #KnowledgeOfSelflsANationality #EconomicEmpowerment #IhtegrationFailed #WhiteLiesMatter #Education #AfricanUnification #AfricanUnity #BlackLove #theblackmancan #brotherhood #kings 0.0 0.00 USD 2017-05-25T00:25:16-07:00 2017-05-26T00:25:16-07:00
46 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/shootusa Obey the law and everything will be ok, they say 0.0 0.00 USD 2015-07-27T00:42:42-07:00 2015-07-28T00:42:41-07:00
47 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/shootusa Obey the law and everything will be ok, they say 0.0 0.00 USD 2015-07-24T02:24:10-07:00 2015-07-25T02:24:09-07:00
48 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/pages/Proud-BIacks/1065511110127506   0.0 0.00 USD 2015-08-13T03:30:11-07:00 2015-08-14T03:30:11-07:00
53 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ Join us because we care. Black Matters! 0.0 0.00 USD 2015-07-13T07:13:40-07:00  
63 custom_audience:Lookalike (US, 1%) - newtestaudit, location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices 0 0 https://b|ackmattersus.com/ Get breaking news and analysis on the life of African American community in the US. Black Matters 4 Cops On 1 Teen: Brutality Against Juveniles L. A. County probation officers brutalize teen in detention center. Fox News Hosts Believe Charleston Shooting Wasn’t Hate Crime “Fox & Friends” hosts declare that the shooting was motivated by religious hatred towards Christians, but not racism. Brutal Alabama Cop Fatally Shoots Black Teen Holding Cellphone A mobile police officer fatally shot a 19-year-old black teen, Michael Moore, during a traffic stop Monday, June 13 in Toulminville, Alabama. Black Matters 0.0 0.00 USD 2016-06-21T07:08:44-07:00  
75 location:United States, friends_of_connections:Friends of people who are connected to Black Matters, age:18 - 54, language:English (UK), language:English (US), placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices, people_who_match:behaviors:African American (US), and_must_also_match:interests:BIackNews.com, and_must_also_match:interests:HuffPost Black Voices 0 0 https://b|ackmattersus.oom/ Black Community! We finally made a website! News about black racial and social issues. Get breaking news and analysis on the life of African American community in the US. Black Matters Hillary Doesn’t Deserve Black Votes Young black voters give up on Mrs. Clinton Outraged Flint Resident: “Lawsuit Must Be Filed Against State!” Flint Water Crisis touched the feelings of all Americans and the whole world. Justice For Aiyana Jones Rally The tragic death of Aiyana Jones, a 7-year-old African-Amerioan fatally shot by a Detroit police officer 4 Officers, Who Shot Jeremy MoDoIe, Won’t Face State Charges, Family Protests In Wilmington Friday The tragic alleged murder of Jeremy McDole happened last September after he had been “robbed and shot by an unknown robber,” Black Girl Gets Rope Burns During A Camping Trip When Sandy Rougely’s 12-year-old daughter returned from a one day camping trip on April 28, Sandy was shocked to see a horrible rope burn on the front side of the kid’s heck. Black Matters 0.0 0.00 USD 2016-05-23T08:02:51-07:00  
77 location:United States, friends_of_connections:Friends of people who are connected to Black Matters, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices, people_who_match:multicultural_affinity:African American (US), and_must_also_match:interests:Black Tea Patriots, and_must_also_match:interests:Black Knowledge, and_must_also_match:interests:BIackNews.com, and_must_also_match:interests:HuffPost Black Voices 0 0 https://b|ackmattersus.com/ Black Community! We finally made a website! News about black racial and social issues. Get breaking news and analysis on the life of African American community in the US. Black Matters Hillary Doesn’t Deserve Black Votes Young black voters give up on Mrs. Clinton Outraged Flint Resident: “Lawsuit Must Be Filed Against State!” Flint Water Crisis touched the feelings of all Americans and the whole world. Justice For Aiyana Jones Rally The tragic death of Aiyana Jones, a 7-year-old African-American fatally shot by a Detroit police officer 4 Officers, Who Shot Jeremy McDole, Won’t Face State Charges, Family Protests In Wilmington Friday The tragic alleged murder of Jeremy McDole happened last September after he had been “robbed and shot by an unknown robber,” Black Matters 0.0 0.00 USD 2016-06-16T01:21:05-07:00  
94 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ Keeping eye on our brother's cases and much more 0.0 0.00 USD 2015-07-13T07:17:59-07:00  
98 custom_audience:Lookalike (US, 1%) - newtestaudit, location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices 0 0 https://blackmattersus.com/ Get breaking news and analysis on the life of African American community in the US. Black Matters Black Matters This Is What Being “Confident In Ones Blackness” Means To Some White Conservatives Black Matters Life Expectancy For Black Americans Increase Black Matters Police Brutality Videos Change How Black Men Live Black Matters 0.0 0.00 USD 2016-06-23T06:07:51-07:00  
99 custom_audience:Lookalike (US, 1%) - newtestaudit, location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices 0 0 https://blackmattersus.com/ Get breaking news and analysis on the life of African American community in the US. Black Matters Black Matters 0.0 0.00 USD 2016-06-23T06:11:47-07:00  
100 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ Keeping eye on our brother's cases and much more 0.0 0.00 USD 2015-07-13T07:18:00-07:00  
103 location:united_states:New York (+40 km) New York, interests:BIackNews.com, interests:Black History Month, interests:African-American history, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/events/1085290071563825/ Almost 2 years have passed since the death of Eric Garner, a father of 6, who was violentl Rally In Memory Of Eric Garner 0.0 0.00 USD 2016-07-28T06:40:03-07:00 2016-07-17T03:03:41-07:00
104 location:united_states:Los Angeles (+40 km) California, interests:BIackNews.com, interests:Black History Month, interests:African-American history, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/events/1085290071563825/ Almost 2 years have passed since the death of Eric Garner, a father of 6, who was violentl Rally In Memory Of Eric Garner 0.0 0.00 USD 2016-08-04T07:24:02-07:00 2016-07-17T03:03:41-07:00
110 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ Join us because we care. Black Matters! 0.0 0.00 USD 2015-07-13T07:13:41-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
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
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
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
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
181 no image location:united_states:New York (+40 km) New York, interests:Black Tea Patriots, interests:BIackNews.com, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ The—will attract the UN’s attention to the long term injustice and cruelty against people of color in the United States. The genocide instituted by white supremacists should be stopped. Join our protest that will be held Also, join the event for more info: #CrimesOfGenocide 0.0 0.00 USD 2016-02-09T05:37:37-08:00 2016-02-12T06:18:00-08:00
189 no image location:united_states:New York (+40 km) New York, interests:Black Tea Patriots, interests:BIackNewscom, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ ATTENTION, NEWYORK! We're meetin at We need your support! We'll provide you with free food and coffee. Come and bring your friends! Join the FB event for more details: 0.0 0.00 USD 2016-02-18T05:09:11-08:00 2016-02-19T16:09:00-08:00
236 no image location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), excluded_connections:Exclude people who like Black Matters, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Mrs. Clara Belle Williams succeeded despite significant obstacles of discrimination placed upon her while pursuing her higher education. 0.0 0.00 USD 2016-04-30T08:53:02-07:00 2016-05-02T08:53:01-07:00
269 no image location:united_states:Detroit Michigan, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ The 265-159 vote would ban the display of the Confederate flag on flagpoles at VA cemeteries. Due to the meaning and what the Confederate flag stands for, The House last Thursday voted to ban its display on flagpoles at Veterans Administration cemeteries House Votes to Ban Confederate Flags on VA Cemetery Flagpoles | Black Matters Black Matters 0.0 0.00 USD 2016-05-24T07:43:26-07:00 2016-05-25T07:43:24-07:00
283 no image location_living_in:United States, 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     0.0 0.00 USD 2016-07-14T02:05:21-07:00 2016-07-15T02:05:19-07:00
284 no image location_living_in:United States, 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/ When a Black man is shot dead, the world will know about every little secret he had. It is obvious that every time a Black man is killed, all his secretes and mistakes will be all over the internet. The media goes in search of all his criminal r 2 Blacks, Sterling and Castile, Are Now Subject To Intense Scrutiny | Black Matters Black Matters 0.0 0.00 USD 2016-07-17T11:01:34-07:00 2016-07-15T02:05:19-07:00
301 no image custom_audience:Lookalike (US, 1%) - newtestaudit, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ A new BlackMattersUS tool gathers all the Black meetups in one place. Now you can keep track of and organize ALL the Black meetups in one place! We are glad to be the first and only platform that provides this opportunity. For those who want to make real Changes, we offer a convenient search of the upcoming and past events. For the organizers, we suggest the free promotion of your events to more than 300,000 of event-goers via all the social media! All copyrights remain with original owners. Now it is easy to search for a meetup in your area! https://blackmattersus.oom/meetup/ 0.0 0.00 USD 2016-08-05T06:52:42-07:00 2016-08-08T06:52:40-07:00
302 location:united_states:South Carolina, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), excluded_connections:Exclude people who like Black Matters, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/events/1730167210590258/ Stand up, South Carolina! Let’s stop the propaganda of hate and white supremacy! Not My Heritage 0.0 0.00 USD 2016-07-21T01:07:46-07:00 2016-07-23T10:00:00-07:00
310 no image location:united_states:New York New York, interests:BIackNews.com, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ As what happened to India while in police custody remains a major concern, many are wondering why the 27-year-old was denied an appropriate medical evaluation and proper care. The frequent reports of police brutality and extreme use of force, leading to death has regrettably become a daily course. Consequently, protests and demonstrations overflow in every nook and cranny, demanding answers and justice. On February 1, India T. Cummings was under the influence of the synth... #JusticeForlhdia: 27-Year-old Denied Medical Treatment, Dies in Police Custody | Black Matters Black Matters 0.0 0.00 USD 2016-03-04T00:41:08-08:00 2016-03-05T00:41:08-08:00
313 no image location_living_in:united_states:Cleveland (+50 mi) 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/events/1486230091674577/ November 23, 2015 Is the One year anniversary Death of 12 year old Tamir Rice; killed by two Cleveland Police Officers Timothy Loehmann and Frank Garmback. You are welcome! Join the meeting. A Year Without Justice for Tamir Rice 0.0 0.00 USD 2015-11-19T23:51:19-08:00 2015-11-22T23:51:18-08:00
314 location:united_states:Cleveland (+50 km) Ohio, behaviors:multicultural_affinity:African American (US), age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 0 0 https://www.facebook.com/events/1486230091674577/ A Year Without Justice for Tamir Rice. Join the meeting! A Year Without Justice for Tamir Rice 0.0 0.00 USD 2015-11-19T23:27:57-08:00  
315 no image location_living_in:united_states:Cleveland (+50 mi) 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     0.0 0.00 USD 2015-11-19T23:21:05-08:00 2015-11-22T23:21:03-08:00
319 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Fast-growing black community. Latest news and everyday updates. 0.0 0.00 USD 2015-07-13T07:12:00-07:00  
321 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Fast-growing black community. Latest news and everyday updates. 0.0 0.00 USD 2015-07-13T07:12:24-07:00  
323 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ Join us because we care. Black Matters! 0.0 0.00 USD 2015-07-13T07:16:57-07:00  
324 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ Join us because we care. Black Matters! 0.0 0.00 USD 2015-07-13T07:16:58-07:00  
360 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus Keeping eye on our brother's cases and much more 0.0 0.00 USD 2015-06-10T03:01:20-07:00  
362 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+50 km) Missouri, location:united_states:Richmond (+20 km) Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ Keeping eye on our brother's cases and much more 0.0 0.00 USD 2015-07-02T03:10:36-07:00  
363 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus Keeping eye on our brother's cases and much more 0.0 0.00 USD 2015-06-10T03:01:20-07:00  
367 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+50 km) Missouri, location:united_states:Richmond (+20 km) Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Keeping eye on our brother's cases and much more 0.0 0.00 USD 2015-07-02T03:10:36-07:00  
368 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus Join us because we care. Black matters. 0.0 0.00 USD 2015-06-10T02:59:59-07:00  
371 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus Join us because we care. Black matters. 0.0 0.00 USD 2015-06-10T02:59:57-07:00  
375 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+50 km) Missouri, location:united_states:Richmond (+20 km) Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Join us because we care. Black matters. 0.0 0.00 USD 2015-07-02T03:10:36-07:00  

Next page

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 1577.253ms · Data source: simonw/russian-ira-facebook-ads-datasette