This data as json, CSV (advanced)
| id | file | clicks | impressions | text | url | spend_amount | spend_currency | created | ended | target_names |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | data/2015-10/P(1)0001740.pdf | 0 | 0 | Black lives matter because we see what’s going on. We care, and we won’t let it get swept under the rug. Join @blackunionus See Instagram photos and videos from Black Union for Justice (@blackunionus) Black Union for Justice (@blackunionus) - Instagram photos and videos | https://instagram.Com/blackunionus/ | 0.00 | USD | 2015-10-26T10:45:51-07:00 | 2015-10-27T21:00:59-07:00 | ["location:United States","interests:Pan-Africanism","interests:African-American Civil Rights Movement (1954—68)","interests:African-American history","interests:Black (Color)","age:16 - 65+","language:English (UK)","language:English (US)","placements:News Feed on desktop computers","placements:News Feed on mobile devices","location:United States","interests:Pan-Africanism","interests:African-American Civil Rights Movement (1954—68)","interests:African-American history","interests:Black (Color)","age:16 - 65+","language:English (UK)","language:English (US)","placements:News Feed on desktop computers","placements:News Feed on mobile devices","location:United States","interests:Black nationalism","interests:Pan-Africahism","interests:Police misconduct","interests:African- American culture","interests:African-American Civil Rights Movement (1954—68)","interests:African- American history","interests:Black Consciousness Movement","interests:Martin Luther King III","interests:Stop Police Brutality","interests:Black (Color)","age:16 - 65+","language:English (UK)","language:English (US)","placements:News Feed on desktop computers","placements:News Feed on mobile devices","location:United States","age:13 - 44","language:English (US)","placements:Instagram Feed","people_who_match:interests:Cop Block","location:united_states:Baltimore (+25 mi) Maryland","age:16 - 45","language:English (UK)","language:English (US)","placements:News Feed on desktop computers","placements:News Feed on mobile devices","people_who_match:behaviors:African American (US)","location:United States","age:13 - 35","language:English (US)","placements:Instagram Feed","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:Black History Month","location:United States","age:13 - 35","language:English (UK)","language:English (US)","placements:Instagram Feed","people_who_match:interests:Hoodies","people_who_match:interests:Trayvo… |
| 1 | data/2015-10/P(1)0001736.pdf | 6 | 358 | Instgogogo | https://instagram.Com/us_daily/ | 161.23 | RUB | 2015-10-25T06:28:33-07:00 | 2015-10-27T23:59:00-07:00 | ["location_living_in:United States","interests:News broadcasting","interests:Political party","interests:Breaking news","interests:Politics and social issues","age:18 - 51","language:English (US)","placements:Instagram Feed"] |
| 5 | data/2016-06/P(1)0000001.pdf | 201 | 29786 | WHERE is your VOICE? | https://www.facebook.com/GovSpending-1651761351759857/ | 3714.15 | RUB | 2016-06-15T03:39:52-07:00 | ["location_living_in:united_states:Georgia","age:18 - 65+","placements:Instagram Feed","people_who_match:interests:Understanding racial segregation in the united states","people_who_match:interests:American Black Film Festival","people_who_match:interests:Cop Block or HuffPost Black Voices","people_who_match:interests:","behaviors:African American (US)","behaviors:Field of study: African-American history","behaviors:","politics:Likely to engage with political content (liberal)"] | |
| 6 | data/2016-05/P(1)0001744.pdf | 0 | 0 | Conservative Christians. Pro—Iife/ gun/ police/ military. Follow! | https://www.facebook.com/Bat-240131319678646/ | 0.00 | USD | 2016-05-12T04:06:17-07:00 | ["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)"] | |
| 7 | data/2016-05/P(1)0001746.pdf | 54 | 23408 | Conservative Christians. Pro—Iife/ gun/ police/ military. Follow! | https://www.facebook.com/Bat-240131319678646/ | 2868.56 | RUB | 2016-05-13T01:18:08-07:00 | ["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)"] | |
| 10 | data/2015-11/P(1)0001747.pdf | 11 | 1625 | Unbelievable amount of the US government's waste. Join us to learn more about Goverment spending statistics! The US Gov Spending Stats Instalol | https://instagram.Com/gov_spending/ | 662.39 | RUB | 2015-11-16T05:49:20-08:00 | ["location:United States","interests:United States Senate","interests:Election","interests:Government","interests:Politics","age:18 - 65+","language:English (US)","placements:Instagram Feed"] | |
| 12 | data/2016-08/P(1)0000002.pdf | 625 | 44111 | It's time for us to understand that we do deserve all best. It's time for our people to stand up and use all the opportunities of this life. Follow black pride us, if you agree! | https://www.facebook.com/Bat-240131319678646/ | 4893.72 | RUB | 2016-08-17T04:17:52-07:00 | ["location:United States","age:18 - 65+","language:English (US)","placements:Instagram Feed","people_who_match:interests:Martin Luther King","people_who_match:interests:Jr.","people_who_match:interests:Black Power","people_who_match:interests:Black Arts Movement","people_who_match:interests:Fight the Power","people_who_match:interests:Black Panther Party","people_who_match:interests:Afrocentrism","people_who_match:interests:My Black is Beautiful","people_who_match:interests:Black is beautiful","people_who_match:interests:Malcolm X","people_who_match:interests:HuffPost Black Voices"] | |
| 14 | data/2015-11/P(1)0001751.pdf | 10 | 1598 | This military campaign is very ambiguous given that it has cost nearly 2,500 American lives and hundreds of billions of dollars. The goal was to "disrupt the use of Afghanistan as a terrorist base of operations." Well, the intervention deprived aI-Qaida of a sanctuary. But aI-Qaida — even after its leader Osama bin Laden was killed by US. commandos — has spawned cells elsewhere and inspired other extremists in Syria and Iraq. And now ISIS is rising as the most powerful terrorist organisation in the world. So, the question is whether it's worth to risk the lives of thousands of American soldiers for the mission that hardly can be called successful? It seems that Obama should review his military strategy without delay.Joih us! Veterans USA ( @veterans GovSpending | https://instagram.Com/veterans_us/ | 659.54 | RUB | 2015-11-16T05:17:56-08:00 | ["location:United States","interests:United Nations Assistance Mission in Afghanistan","interests:Veterans","age:18 - 65+","language:English (US)","placements:Instagram Feed"] | |
| 15 | data/2015-11/P(1)0001753.pdf | 12 | 1614 | And what would you Choose if u were a president: to create 11200 military- related jobs or to create 26700 jobs in education? Join us! Learn more! The US Gov Spending Stats Instalol | https://instagram.Com/gov_spending/ | 596.63 | RUB | 2015-11-17T07:07:36-08:00 | ["location:United States","interests:Tax","interests:Republican Party (United States)","age:20 - 65+","language:English (US)","placements:Instagram Feed"] | |
| 16 | data/2016-05/P(1)0000003.pdf | 53 | 21093 | A Wounded Warrior and his service dog. Support our Veterans - Follow! The US Gov Spending Stats Instalol | https://www.instagram.Com/veterahs_us/ | 2131.44 | RUB | 2016-05-12T02:37:39-07:00 | ["location:United States","age:14 - 65+","language:English (US)","placements:Instagram Feed","people_who_match:interests:Wounded Warrior Project","people_who_match:interests:Support our troops","people_who_match:interests:Veterans","people_who_match:interests:AMVETS","people_who_match:interests:Disabled American Veterans","people_who_match:interests:Chris Kyle","people_who_match:interests:Supporting Our Veterans","and_must_also_match:interests:Paralyzed Veterans of America","and_must_also_match:interests:Veterans Day","and_must_also_match:interests:Wounded Warrior Project","and_must_also_match:interests:Support our troops","and_must_also_match:interests:Veterans","and_must_also_match:interests:AMVETS","and_must_also_match:interests:United States Army Reserve","and_must_also_match:interests:Patriotism","and_must_also_match:interests:Disabled American Veterans","and_must_also_match:interests:The Veterans Site","and_must_also_match:interests:Chris Kyle","and_must_also_match:interests:Supporting Our Veterans"] | |
| 17 | data/2015-11/P(1)0001755.pdf | 2 | 1872 | 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 | https://instagram.Com/veterans_us/ | 366.41 | RUB | 2015-11-18T02:43:22-08:00 | 2015-11-21T10:28:00-08:00 | ["location:United States","interests:Independence","interests:Patriotism","age:18 - 65+","language:English (US)","placements:Instagram Feed"] |
| 18 | data/2015-11/P(1)0001757.pdf | 0 | 0 | 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 | https://instagram.Com/veterans_us/ | 0.00 | USD | 2015-11-19T05:18:16-08:00 | 2015-11-21T10:28:00-08:00 | ["location:United States","interests:Independence","interests:Patriotism","age:18 - 65+","language:English (US)","placements:Instagram Feed"] |
| 19 | data/2015-11/P(1)0001759.pdf | 8 | 2115 | Who will save the Children? Click Learn more! The US Gov Spending Stats Instalol | https://instagram.Com/gov_spending/ | 978.15 | RUB | 2015-11-19T05:35:36-08:00 | ["location:United States","interests:Homeless shelter","politics:US politics (liberal)","politics:US politics (moderate)","age:18 - 65+","language:English (US)","placements:Instagram Feed"] | |
| 20 | data/2015-12/P(1)0006446.pdf | 0 | 514 | Click Learn More if you really love your country! A small puppy wandered up to US. Marines from Alpha Company. After following the Marines numerous miles, a soft hearted Marine picked the puppy up and carried the puppy in his drop pouch. Veterans USA ( @veterans GovSpending | https://www.instagram.Com/veterahs_us/ | 0.00 | USD | 2015-12-16T04:26:55-08:00 | ["location:United States","interests:Patriotism","behaviors:Facebook access (mobile): all mobile devices","age:14 - 65+","language:English (US)","placements:Instagram Feed"] | |
| 21 | data/2015-11/P(1)0001761.pdf | 73 | 8292 | Throughout the history of our nation, there have been many wars. The soldiers have always carried the burden of death or injury while in battles. Politicians continually act as if the soldiers are their pawns, and their soldier pawns are expendable in war. Hence, we have the saddest statistics of military injuries. 1 out of 10 veterans is disabled, often by injuries sustained in combat. Join us! Learn more! Veterans USA ( @veterans GovSpending | https://instagram.Com/veterans_us/ | 2948.52 | RUB | 2015-11-13T06:27:35-08:00 | ["location:United States","interests:Tea Party Patriots","age:18 - 65+","placements:Instagram Feed"] | |
| 22 | data/2015-12/P(1)0001763.pdf | 32 | 9555 | Click learn more! See the latest breaking news photos and videos! Black America Blacklivessss | https://www.instagram.com/black_america_today/ | 1550.41 | RUB | 2015-12-01T07:37:28-08:00 | ["location:united_states:Chicago (+40 km) Illinois","behaviors:African American (US)","age:18 - 65+","language:English (US)","placements:Instagram Feed"] | |
| 23 | data/2016-04/P(1)0001765.pdf | 6 | 10785 | TAG YOUR PHOTOS WITH #TXagainst Send us the reason why don't you want illegals in Texas. Comments, photos, and videos are welcomed! | https://www.facebook.com/GovSpending-1651761351759857/ | 806.09 | RUB | 2016-04-19T08:23:46-07:00 | ["location:United States","interests:Independence","interests:Patriotism","age:18 - 65+","language:English (US)","placements:Instagram Feed"] | |
| 24 | data/2016-04/P(1)0000005.pdf | 9 | 77759 | TAG YOUR PHOTOS WITH #TXagainst Send us the reason why don't you want illegals in Texas. Comments, photos, and videos are welcomed! | https://www.facebook.com/GovSpending-1651761351759857/ | 6618.25 | RUB | 2016-04-20T00:07:11-07:00 | ["location:United States","interests:Independence","interests:Patriotism","age:18 - 65+","language:English (US)","placements:Instagram Feed"] | |
| 25 | data/2015-11/P(1)0000007.pdf | 35 | 3970 | Homeland of brave. Support our veterans! Join us! Veterans USA GovSpending | https://instagram.Com/veterans_us/ | 1401.80 | RUB | 2015-11-09T05:01:08-08:00 | ["location:United States","interests:Veterans","age:18 - 65+","language:English (US)","placements:Instagram Feed"] | |
| 26 | data/2015-12/P(1)0001767.pdf | 6 | 1721 | Home of the Brave. Support our Veterans! Click Learn More! Veterans USA ( @veterans GovSpending | https://www.instagram.Com/veterans_us/ | 898.36 | RUB | 2015-12-01T05:51:31-08:00 | ["location:united_states:Latitude 38.89 Longitude -77.03 Washington (+16 km) District of Columbia","location:united_states:Gallup (+40 km) New Mexico","interests:Veterans","age:18 - 65+","language:English (US)","placements:Instagram Feed"] | |
| 27 | data/2015-11/P(1)0001769.pdf | 6 | 2616 | Why our government wastes $11 MLN per day on |S|L Instead of saving more than 1300 lives of vets. Why do we engage in another conflict when we have so many unsolved problems in the US? It is a shame that our vets are treated so badly. They do not receive proper health care and unemployment benefits. They do not receive the respect they deserve. I do not want our government to create new veterans in such conditions. Join us for more statistics! Click learn more! The US Gov Spending Stats Instalol | https://instagram.Com/gov_spending/ | 467.12 | RUB | 2015-11-18T03:33:41-08:00 | 2015-11-19T08:26:00-08:00 | ["location:United States","interests:Tea Party Patriots","interests:Justice","age:18 - 65+","language:English (US)","placements:Instagram Feed"] |
| 28 | data/2015-12/P(1)0001771.pdf | 46 | 15398 | How to know the truth? Click learn more! Wouldn't it be better to solve the internal problems first? The US Gov Spending Stats Instalol | https://www.instagram.Com/gov_spending/ | 2070.42 | RUB | 2015-12-16T06:45:58-08:00 | ["location:United States","interests:Tax","behaviors:African American (US)","age:14 - 65+","language:English (US)","placements:Instagram Feed"] | |
| 29 | data/2015-11/P(1)0000009.pdf | 33 | 3527 | What do you know about PTSD? Do you know that US Military deaths since 1999 count 6,904, while veterans suicides since 1999 account for 128,480? We'are losing 18 times more warriors in Civilian life than on the battlefields! Learn more! Follow us! Veterans USA ( @veterans GovSpending | https://instagram.Com/veterans_us/ | 1506.21 | RUB | 2015-11-12T04:38:35-08:00 | ["location:United States","interests:Patient Protection and Affordable Care Act","interests:Supporting Our Veterans","age:18 - 65+","language:English (US)","placements:Instagram Feed"] | |
| 30 | data/2015-11/P(1)0000011.pdf | 0 | 0 | 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 | https://instagram.Com/veterans_us/ | 0.00 | USD | 2015-11-19T05:20:22-08:00 | 2015-11-21T10:28:00-08:00 | ["location:United States","interests:Independence","interests:Patriotism","age:18 - 65+","language:English (US)","placements:Instagram Feed"] |
| 31 | data/2016-03/P(1)0001773.pdf | 235 | 23670 | Quiz from EBONY magazine April 1952. Which is Negro? Which is White? Passing for white is a direct consequence of how race works in America. Because of the One Drop Rule if you look at all part black African you are seen as “black” by “whites” and suffer all the racism that goes with that. Click "Learn More" Black America ( @black Blacklivessss | https://www.instagram.com/black_america_today/ | 4040.17 | RUB | 2016-03-11T04:54:05-08:00 | ["location:United States","age:13 - 35","language:English (UK)","language:English (US)","placements:Instagram Feed","people_who_match:interests:Afro—American religion","people_who_match:interests:Malcolm X"] | |
| 32 | data/2016-08/P(1)0000013.pdf | 375 | 12727 | Heritage not hate y'all! Our flag has nothing to do with racism! The Federal Government shouldn’t be able to dictate what we can and cannot do. Go follow Confederate page #1 on Instagram south united if you are proud of our southern heritage. God bless Dixie! Confederate page #1 on Instagram! No racism, no hate! The south will rise again! https://twitter.com/March_for_Trump South United GovSpehding | https:l/www.instagram.com/south_united/ | 3106.28 | RUB | 2016-08-18T08:31:16-07:00 | ["location:united_states:Alabama","location:united_states:Arkansas","location:united_states:Florida","location:united_states:Georgia","location:united_states:Louisiana","location:united_states:Mississippi","location:united_states:North Carolina","location:united_states:South Carolina","location:united_states:Tennessee","location:united_states:Texas","location:united_states:Virginia","age:18 - 65+","language:English (US)","placements:Instagram Feed","people_who_match:interests:Confederate Flag","people_who_match:interests:Flags of the Confederate States of America","people_who_match:interests:confederate states america","people_who_match:interests:United Daughters of the Confederacy","people_who_match:interests:Confederate States of America","people_who_match:interests:Sons of Confederate Veterans","people_who_match:interests:Confederate States Army","people_who_match:interests:Robert E. Lee","people_who_match:interests:Southern United States","people_who_match:interests:Redneck Social Club"] | |
| 33 | data/2015-12/P(1)0001775.pdf | 6 | 2404 | Unbelievable amount of the US government's waste. Click Learn More! The US Gov Spending Stats GovSpending | https://instagram.Com/gov_spending/ | 950.00 | RUB | 2015-12-01T05:57:42-08:00 | ["location:united_states:Massachusetts","interests:Liberalism","age:18 - 65+","language:English (US)","placements:Instagram Feed"] | |
| 34 | data/2016-05/P(1)0001777.pdf | 0 | 0 | A Wounded Warrior and his service dog. Support our Veterans - Follow! Black America ( @black Instalol | https://www.instagram.Com/veterans_us/ | 0.00 | USD | 2016-05-12T02:31:30-07:00 | ["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"] | |
| 35 | data/2016-01/P(1)0001779.pdf | 0 | 0 | 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 | https://www.instagram.Com/veterahs_us/ | 0.00 | USD | 2016-01-14T06:25:20-08:00 | ["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"] | |
| 36 | data/2016-01/P(1)0000015.pdf | 496 | 143644 | He's lucky to return home to reunite with his family for the holidays. But he's just one of a few servicemen to do this. For many of our brave troops stationed abroad and far from their loved ones. Our brave servicemen and servicewomen will continue to make sacrifices for our great country while the VA employees will be having their dinner and laughing at the VA backlog. Click to Learn More! Veterans USA ( @veterans GovSpending | https:l/www.instagram.com/veterans_usl | 8339.12 | RUB | 2016-01-14T07:18:30-08:00 | ["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"] | |
| 37 | data/2015-12/P(1)0001781.pdf | 216 | 56837 | Join us to learn more! Why aren't white hoods and white supremacist propaganda illegal here in America? Why are Germans ashamed of their bigotry, while America is proud of it? Black America ( @black | https://www.instagram.com/black_america_today/ | 4030.81 | RUB | 2015-12-22T03:42:46-08:00 | ["location:United States","behaviors:African American (US)","age:14 - 65+","language:English (US)","placements:Instagram Feed"] | |
| 38 | data/2016-01/P(1)0001783.pdf | 95 | 24866 | Join us to learn more! Why aren't white hoods and white supremacist propaganda illegal here in America? Why are Germans ashamed of their bigotry, while America is proud of it? Black America ( @black Blacklivessss | https://www.instagram.com/black_america_today/ | 1796.49 | RUB | 2016-01-06T01:45:12-08:00 | ["location:United States","interests:HuffPost Black Voices","behaviors:African American (US)","age:14 - 65+","language:English (US)","placements:Instagram Feed"] | |
| 39 | data/2016-01/P(1)0001785.pdf | 300 | 95140 | Join us to learn more! Why aren't white hoods and white supremacist propaganda illegal here in America? Why are Germans ashamed of their bigotry, while America is proud of it? Black America ( @black Blacklivessss | https://www.instagram.com/black_america_today/ | 9160.88 | RUB | 2016-01-14T06:07:11-08:00 | ["location:United States","age:13 - 65+","language:English (US)","placements:Instagram Feed","people_who_match:interests:HuffPost Black Voices","and_must_also_match:behaviors:African American (US)"] | |
| 40 | data/2016-01/P(1)0000017.pdf | 25 | 12476 | Let's make America great again for the future generations! Click Learn More! Veterans USA ( @veterans GovSpending | https://www.instagram.com/veterans_us/ | 1203.51 | RUB | 2016-01-06T03:11:48-08:00 | ["location:United States","interests:Independence","interests:Patriotism","age:14 - 65+","language:English (US)","placements:Instagram Feed"] | |
| 41 | data/2016-06/P(1)0001787.pdf | 479 | 7190 | gather recent videos about outrageous police misconduct, really valuable ones but underrepresented by mass media. | https://www.facebook.com/BIacklivessss-930158090385628/ | 5270.00 | RUB | 2016-06-15T02:14:28-07:00 | ["location_living_in:united_states:Maryland","age:18 - 40","placements:Instagram Feed","people_who_match:interests:Cop Block"] | |
| 42 | data/2016-06/P(1)0000019.pdf | 266 | 22608 | If we ever forget that we are One Nation Under God, then we will be a nation gone under. Ronald Reagan | https://www.facebook.com/Bat-240131319678646/ | 6015.85 | RUB | 2016-06-15T04:02:09-07:00 | ["location_living_in:united_states:Ohio; Tennessee; Virginia","age:18 - 65+","placements:Instagram Feed","people_who_match:politics:US politics (conservative)","people_who_match:politics:US politics (very conservative)","people_who_match:politics:Likely to engage with political content (conservative)"] | |
| 43 | data/2015-10/P(1)0001788.pdf | 0 | 0 | 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 | https://instagram.Com/Cop_block_us | 0.00 | USD | 2015-10-13T02:27:35-07:00 | 2015-10-15T23:59:59-07:00 | ["location_living_in:United States","interests:Cop Block","age:18 - 65+","language:English (US)","placements:Instagram Feed"] |
| 44 | data/2015-10/P(1)0001790.pdf | 0 | 0 | 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 | https://instagram.Com/south_lone_star | 0.00 | USD | 2015-10-13T01:34:37-07:00 | 2015-10-15T23:59:59-07:00 | ["location_living_in:united_states:Texas","age:18 - 65+","language:English (US)","placements:Instagram Feed"] |
| 45 | data/2017-05/P(1)0001792.pdf | 0 | 0 | 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 | https://www.facebook.com/Woke-B|acks-294234600956431/ | 0.00 | USD | 2017-05-25T00:25:16-07:00 | 2017-05-26T00:25:16-07:00 | ["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"] |
| 46 | data/2015-07/P(1)0001794.pdf | 0 | 0 | Obey the law and everything will be ok, they say | https://www.facebook.com/shootusa | 0.00 | USD | 2015-07-27T00:42:42-07:00 | 2015-07-28T00:42:41-07:00 | ["location_living_in:United States","age:18 - 65+","placements:News Feed on desktop computers","placements:News Feed on mobile devices"] |
| 47 | data/2015-07/P(1)0001796.pdf | 0 | 0 | Obey the law and everything will be ok, they say | https://www.facebook.com/shootusa | 0.00 | USD | 2015-07-24T02:24:10-07:00 | 2015-07-25T02:24:09-07:00 | ["location_living_in:United States","age:18 - 65+","placements:News Feed on desktop computers","placements:News Feed on mobile devices"] |
| 48 | data/2015-08/P(1)0000020.pdf | 0 | 0 | https://www.facebook.com/pages/Proud-BIacks/1065511110127506 | 0.00 | USD | 2015-08-13T03:30:11-07:00 | 2015-08-14T03:30:11-07:00 | ["location_living_in:United States","age:18 - 65+","placements:News Feed on desktop computers","placements:News Feed on mobile devices"] | |
| 49 | data/2016-06/P(1)0001798.pdf | 716 | 4405 | The head of Chicago’s IPRA, Sharon Fairley, has recommended an on-duty officer to be fired for calling President Obama a n****r. According to Chicago Sun-Times, the racist remark was made during a meeting to decide on “who would cover the president’s detail for a Bulls game”. The Independ Chicago Cop To Be Fired For Calling Obama N-Word | Black Matters Black Matters | https://www.facebook.com/BlaCk-Matters-1579673598947501/ | 782.22 | RUB | 2016-06-20T08:22:58-07:00 | ["custom_audience:tesy","location:United States","age:18 - 65+","language:English (UK)","language:English (US)","placements:News Feed on desktop computers","placements:News Feed on mobile devices"] | |
| 50 | data/2016-06/P(1)0000022.pdf | 6555 | 92618 | 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 | https://blackmattersus.com/ | 13458.49 | RUB | 2016-06-21T07:09:02-07:00 | ["custom_audience:Lookalike (US","custom_audience: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"] | |
| 51 | data/2016-07/P(1)0000024.pdf | 393 | 12653 | 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 | https://b|ackmattersus.com/?utm_source=facebook&utm_medium=Cpc&utm | 1168.31 | RUB | 2016-07-06T07:18:32-07:00 | ["custom_audience:Lookalike (US","custom_audience: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"] | |
| 52 | data/2016-06/P(1)0001799.pdf | 724 | 4544 | The head of Chicago’s IPRA, Sharon Fairley, has recommended an on-duty officer to be fired for calling President Obama a n****r. According to Chicago Sun-Times, the racist remark was made during a meeting to decide on “who would cover the president’s detail for a Bulls game”. The Independ Chicago Cop To Be Fired For Calling Obama N-Word | Black Matters Black Matters | https://www.facebook.com/BlaCk-Matters-1579673598947501/ | 847.19 | RUB | 2016-06-20T08:03:12-07:00 | ["custom_audience:tesy","location:United States","age:18 - 65+","language:English (UK)","language:English (US)","placements:News Feed on desktop computers","placements:News Feed on mobile devices"] | |
| 53 | data/2015-07/P(1)0001800.pdf | 0 | 0 | Join us because we care. Black Matters! | https://www.facebook.com/blackmattersus/ | 0.00 | USD | 2015-07-13T07:13:40-07:00 | ["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"] | |
| 54 | data/2015-07/P(1)0001802.pdf | 12127 | 201428 | Join us because we care. Black Matters! | https://www.facebook.com/blackmattersus/ | 53424.95 | RUB | 2015-07-13T07:20:58-07:00 | ["location:united_states:Atlanta (+20 km) Georgia","location:united_states:Maryland","location:united_states:Ferguson (+20 km), 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"] | |
| 55 | data/2015-10/P(1)0001804.pdf | 73 | 812 | Fast-growing black community. Latest news and everyday updates! | https://www.facebook.com/blackmattersus/ | 214.45 | RUB | 2015-10-06T08:22:34-07:00 | ["location:United States","interests:BlackNews.com","interests:HuffPost Black Voices","behaviors:African American (US)","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"] | |
| 56 | data/2015-11/P(1)0001806.pdf | 211 | 3251 | Fast-growing black community. Latest news and everyday updates! | https://www.facebook.com/blackmattersus/ | 731.77 | RUB | 2015-11-05T23:17:06-08:00 | ["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"] | |
| 57 | data/2016-07/P(1)0001808.pdf | 304 | 7457 | Stand up, South Carolina! Let’s stop the propaganda of hate and white supremacy! Not My Heritage | https://www.facebook.com/events/1730167210590258/ | 4670.00 | RUB | 2016-07-21T05:32:28-07:00 | 2016-07-23T05:32:25-07:00 | ["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"] |
| 58 | data/2015-10/P(1)0001810.pdf | 2446 | 16322 | Black Matters. Black community. | https://www.facebook.com/blackmattersus/ | 4798.09 | RUB | 2015-10-06T08:25:00-07:00 | ["location:United States","interests:BlackNews.com","interests:HuffPost Black Voices","behaviors:African American (US)","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"] | |
| 59 | data/2015-11/P(1)0001812.pdf | 24838 | 359345 | Black Matters. Black community. | https://www.facebook.com/blackmattersus/ | 58408.48 | RUB | 2015-11-05T23:17:06-08:00 | ["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"] | |
| 60 | data/2015-10/P(1)0001814.pdf | 113 | 967 | Fast-growing black community. Latest news and everyday updates! | https://www.facebook.com/blackmattersus/ | 317.56 | RUB | 2015-10-06T08:22:34-07:00 | ["location:United States","interests:BlackNews.com","interests:HuffPost Black Voices","behaviors:African American (US)","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"] | |
| 61 | data/2015-11/P(1)0001816.pdf | 10292 | 115604 | Fast-growing black community. Latest news and everyday updates! | https://www.facebook.com/blackmattersus/ | 34501.08 | RUB | 2015-11-05T23:17:06-08:00 | ["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"] | |
| 62 | data/2016-06/P(1)0001818.pdf | 2182 | 42890 | One year ago nine people were killed by a gunman, including the senior pastor, state senat Remember Victims of Charleston Shooting | https://www.facebook.com/events/257074994652475/ | 14398.69 | RUB | 2016-06-01T06:03:23-07:00 | 2016-06-19T06:03:19-07:00 | ["location:united_states:Charleston (+70 km) South Carolina","age:18 - 65+","language:English (UK)","language:English (US)","placements:News Feed on desktop computers","placements:News Feed on mobile devices"] |
| 63 | data/2016-06/P(1)0000026.pdf | 0 | 0 | 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 | https://b|ackmattersus.com/ | 0.00 | USD | 2016-06-21T07:08:44-07:00 | ["custom_audience:Lookalike (US","custom_audience: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"] | |
| 64 | data/2015-07/P(1)0001820.pdf | 25 | 500 | Join us. Because we care | https://www.facebook.com/BlaCk-Matters-1579673598947501/ | 340.34 | RUB | 2015-07-10T01:03:31-07:00 | ["location:united_states:Chester (+20 km) Arkansas","location:united_states:Washington (+20 km) District of Columbia","location:united_states:Atlanta (+20 km) Georgia","location:united_states:New Orleans (+20 km) Louisiana","location:united_states:Baltimore (+20 km) Maryland","location:united_states:St. Louis (+20 km) Missouri","location:united_states:Cleveland (+20 km) Ohio","location:united_states:Philadelphia (+20 km) Pennsylvania","location:united_states:Memphis (+20 km) Tennessee","location:united_states:Richmond (+20 km) Virginia","location:united_states:Milwaukee (+20 km) Wisconsin","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"] | |
| 65 | data/2016-08/P(1)0001822.pdf | 1734 | 41395 | Two years have passed since August 11, 2014, the date, when 25-year-old Ezell Ford was mur Justice For Ezell Ford And Donnell Thompson | https://www.facebook.com/events/1702267153358101/ | 14881.75 | RUB | 2016-08-04T07:25:31-07:00 | 2016-08-20T07:25:28-07:00 | ["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"] |
| 66 | data/2016-05/P(1)0001824.pdf | 0 | 3 | A rally in loving memory of Aiyana Jones May 16 will mark the sixth anniversary of the br The 6th Anniversary Of The Aiyana Jones’ Death | https://www.facebook.com/events/1727519624184050/ | 0.82 | RUB | 2016-05-06T01:00:41-07:00 | ["location:united_states:Detroit (+70 km) Michigan","interests:HuffPost Black Voices","age:15 - 54","language:English (UK)","language:English (US)","placements:News Feed on desktop computers","placements:News Feed on mobile devices"] | |
| 67 | data/2016-05/P(1)0001826.pdf | 804 | 13066 | A rally in loving memory of Aiyana Jones May 16 will mark the sixth anniversary of the br The 6th Anniversary Of The Aiyana Jones’ Death | https://www.facebook.com/events/1727519624184050/ | 1714.83 | RUB | 2016-05-06T02:21:24-07:00 | ["location:united_states:Detroit (+70 km) Michigan","age:15 - 54","language:English (UK)","language:English (US)","placements:News Feed on desktop computers","placements:News Feed on mobile devices","people_who_match:interests:Detroit","people_who_match:interests:BlackNews.com","people_who_match:interests:HuffPost Black Voices"] | |
| 68 | data/2016-05/P(1)0001828.pdf | 2546 | 54836 | A rally in loving memory of Aiyana Jones May 16 will mark the sixth anniversary of the br The 6th Anniversary Of The Aiyana Jones’ Death | https://www.facebook.com/events/1727519624184050/ | 9192.47 | RUB | 2016-05-10T01:31:35-07:00 | ["location:united_states:Detroit (+70 km) Michigan","age:15 - 54","language:English (UK)","language:English (US)","placements:News Feed on desktop computers","placements:News Feed on mobile devices"] | |
| 69 | data/2016-05/P(1)0001830.pdf | 314 | 8376 | A rally in loving memory of Aiyana Jones May 16 will mark the sixth anniversary of the br The 6th Anniversary Of The Aiyana Jones’ Death | https://www.facebook.com/events/1727519624184050/ | 1505.34 | RUB | 2016-05-16T07:59:50-07:00 | ["location:united_states:Detroit (+70 km) Michigan","age:15 - 54","language:English (UK)","language:English (US)","placements:News Feed on desktop computers","placements:News Feed on mobile devices","people_who_match:behaviors:African American (US)"] | |
| 70 | data/2016-05/P(1)0001832.pdf | 442 | 10089 | A rally in loving memory of Aiyana Jones May 16 will mark the sixth anniversary of the br The 6th Anniversary Of The Aiyana Jones’ Death | https://www.facebook.com/events/1727519624184050/ | 2570.85 | RUB | 2016-05-17T00:21:13-07:00 | ["location:united_states:Detroit (+70 km) Michigan","age:15 - 54","language:English (UK)","language:English (US)","placements:News Feed on desktop computers","placements:News Feed on mobile devices","people_who_match:behaviors:African American (US)"] | |
| 71 | data/2016-03/P(1)0001834.pdf | 2317 | 77530 | Breaking news and analysis on the life of African American community in the US! Independent News For Black Amrican community Black Matters Black Matters | https://blackmattersus.com/ | 6691.62 | RUB | 2016-03-10T06:26:39-08:00 | ["location:United States","age:25 - 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","people_who_match:interests:Martin Luther King","people_who_match:interests:Jr.","people_who_match:interests:Behaviors: African American (US)"] | |
| 72 | data/2016-02/P(1)0001836.pdf | 75 | 2461 | Black Community! We finally made a website! News about black racial and social issues. This happened yesterday, Feb. 2, at a dry Cleaning shop in a black neighborhood, when this black guy went for his Clothes he had already sent for laundry. “What do you mean by you people?” The black guy asked. There was a murmur from inside the shop; the dry Cleaner answered “those who are arguing m... Black Matters The Police should protect not Brutalize Ideally Black Women... S. F. Police Vow To Eradicate Racism Plans to fight racism in the ranks. Black History Month The event grew out of “Negro History Week,” the brainchild Black Matters | https://b|ackmattersus.oom/ | 392.14 | RUB | 2016-02-04T00:28:15-08:00 | ["location:United States","interests:BIackNews.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:Third-party Apps and Websites on mobile devices","placements:News Feed on mobile devices"] | |
| 73 | data/2016-02/P(1)0001838.pdf | 6282 | 141500 | Black Community! We finally made a website! News about black racial and social issues. This happened yesterday, Feb. 2, at a dry Cleaning shop in a black neighborhood, when this black guy went for his Clothes he had already sent for laundry. “What do you mean by you people?” The black guy asked. There was a murmur from inside the shop; the dry Cleaner answered “those who are arguing m... Black Matters The Police should protect not Brutalize Ideally Black Women... S. F. Police Vow To Eradicate Racism Plans to fight racism in the ranks. Black History Month The event grew out of “Negro History Week,” the brainchild Black Matters | https://b|ackmattersus.oom/ | 24165.80 | RUB | 2016-02-04T23:54:33-08:00 | ["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:behaviors:African American (US)","and_must_also_match:interests:BIackNews.com","and_must_also_match:interests:HuffPost Black Voices"] | |
| 74 | data/2016-04/P(1)0001840.pdf | 1805 | 42072 | Black Community! We finally made a website! News about black racial and social issues. This happened yesterday, Feb. 2, at a dry Cleaning shop in a black neighborhood, when this black guy went for his Clothes he had already sent for laundry. “What do you mean by you people?” The black guy asked. There was a murmur from inside the shop; the dry Cleaner answered “those who are arguing m... Black Matters The Police should protect not Brutalize Ideally Black Women... S. F. Police Vow To Eradicate Racism Plans to fight racism in the ranks. Black History Month The event grew out of “Negro History Week,” the brainchild Black Matters | https://b|ackmattersus.oom/ | 10676.85 | RUB | 2016-04-25T05:36:07-07:00 | ["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"] | |
| 75 | data/2016-05/P(1)0000028.pdf | 0 | 0 | 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 | https://b|ackmattersus.oom/ | 0.00 | USD | 2016-05-23T08:02:51-07:00 | ["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"] | |
| 76 | data/2016-05/P(1)0000030.pdf | 3402 | 89836 | 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 | https://b|ackmattersus.com/ | 14182.61 | RUB | 2016-05-24T00:19:06-07:00 | ["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"] | |
| 77 | data/2016-06/P(1)0000032.pdf | 0 | 0 | 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 | https://b|ackmattersus.com/ | 0.00 | USD | 2016-06-16T01:21:05-07:00 | ["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"] | |
| 78 | data/2016-06/P(1)0001842.pdf | 1739 | 44405 | 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 Chicago IPRA Finally Gets Dashcam Video Of Darius Pinex Shooting It took over five years for the IPRA to get the key evidence in the fatal police shooting of a black Chicago man committed in 2011. Orlando Nightclub Massacre And The Race Factor Orlando tragedy shed light on how hate and terrorism can destroy innocent lives within a matter of seconds. Pepper-Sprayed Victim Donates $100K Settlement To Social Justice A Seattle high school history teacher Jesse Hagopian, pepper- sprayed by police, says he’ll donate the $100K settlement to help movement forjustice. NYPD Cop Pulls A Gun On Black Cyclist In Fender-Bender A 21-year-old black cyclist plans to sue a white NYPD police officer for threatening his life by pointing a gun at him during a fender-bender. Black Matters | https://b|ackmattersus.com/ | 5940.92 | RUB | 2016-06-16T01:32:37-07:00 | ["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:behaviors:African American (US)","and_must_also_match:interests:BIackNews.com","and_must_also_match:interests:HuffPost Black Voices"] | |
| 79 | data/2015-06/P(1)0001844.pdf | 0 | 31 | https://www.facebook.com/pages/L-for-Iife/994910227187446 | 33.59 | RUB | 2015-06-09T03:50:21-07:00 | 2015-06-11T03:48:00-07:00 | ["location:United States","excluded_connections:Exclude people who like L for life","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"] | |
| 80 | data/2015-10/P(1)0001846.pdf | 1393 | 10825 | Fast-growing black community. Latest news and everyday updates! | https://www.facebook.com/blackmattersus/ | 3364.59 | RUB | 2015-10-06T08:22:32-07:00 | ["location:United States","interests:BlackNews.com","interests:HuffPost Black Voices","behaviors:African American (US)","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"] | |
| 81 | data/2015-11/P(1)0001848.pdf | 738 | 7808 | Fast-growing black community. Latest news and everyday updates! | https://www.facebook.com/blackmattersus/ | 2796.95 | RUB | 2015-11-05T23:17:06-08:00 | ["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"] | |
| 82 | data/2015-07/P(1)0001850.pdf | 6 | 191 | Fast-growing black community. Latest news and everyday updates. | https://www.facebook.com/BlaCk-Matters-1579673598947501/ | 257.25 | RUB | 2015-07-10T01:02:58-07:00 | ["location:united_states:Chester (+20 km) Arkansas","location:united_states:Washington (+20 km) District of Columbia","location:united_states:Atlanta (+20 km) Georgia","location:united_states:New Orleans (+20 km) Louisiana","location:united_states:Baltimore (+20 km) Maryland","location:united_states:St. Louis (+20 km) Missouri","location:united_states:Cleveland (+20 km) Ohio","location:united_states:Philadelphia (+20 km) Pennsylvania","location:united_states:Memphis (+20 km) Tennessee","location:united_states:Richmond (+20 km) Virginia","location:united_states:Milwaukee (+20 km) Wisconsin","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"] | |
| 83 | data/2015-07/P(1)0001852.pdf | 30 | 613 | Join us. Because we care | https://www.facebook.com/BlaCk-Matters-1579673598947501/ | 468.00 | RUB | 2015-07-10T01:03:32-07:00 | ["location:united_states:Chester (+20 km) Arkansas","location:united_states:Washington (+20 km) District of Columbia","location:united_states:Atlanta (+20 km) Georgia","location:united_states:New Orleans (+20 km) Louisiana","location:united_states:Baltimore (+20 km) Maryland","location:united_states:St. Louis (+20 km) Missouri","location:united_states:Cleveland (+20 km) Ohio","location:united_states:Philadelphia (+20 km) Pennsylvania","location:united_states:Memphis (+20 km) Tennessee","location:united_states:Richmond (+20 km) Virginia","location:united_states:Milwaukee (+20 km) Wisconsin","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"] | |
| 84 | data/2015-10/P(1)0001854.pdf | 1838 | 14050 | Black Matters. Black community. | https://www.facebook.com/blackmattersus/ | 3760.42 | RUB | 2015-10-06T08:24:58-07:00 | ["location:United States","interests:BlackNews.com","interests:HuffPost Black Voices","behaviors:African American (US)","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"] | |
| 85 | data/2015-11/P(1)0001856.pdf | 10547 | 105431 | Black Matters. Black community. | https://www.facebook.com/blackmattersus/ | 35240.34 | RUB | 2015-11-05T23:17:06-08:00 | ["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"] | |
| 86 | data/2016-08/P(1)0001858.pdf | 75 | 2920 | Two years have passed since August 11, 2014, the date, when 25-year-old Ezell Ford was mur Justice For Ezell Ford and Donnell Thompson | https://www.facebook.com/events/1051176154917933/ | 3529.26 | RUB | 2016-08-22T07:04:52-07:00 | 2016-09-03T07:04:49-07:00 | ["location_living_in:united_states:Los Angeles (+50 mi) California","interests:Martin Luther","interests:Black Panther Party","interests:African-American Civil Rights Movement (1954—68)","interests:African-American history","interests:Malcolm X","age:18 - 65+","placements:News Feed on desktop computers","placements:News Feed on mobile devices"] |
| 87 | data/2016-08/P(1)0001860.pdf | 180 | 6368 | Two years have passed since August 11, 2014, the date, when 25-year-old Ezell Ford was mur Justice For Ezell Ford and Donnell Thompson | https://www.facebook.com/events/1051176154917933/ | 7110.11 | RUB | 2016-08-23T04:11:38-07:00 | 2016-09-03T07:04:49-07:00 | ["location_living_in:united_states:Los Angeles (+50 mi) California","age:18 - 65+","language:English (UK)","language:English (US)","placements:News Feed on desktop computers","placements:News Feed on mobile devices","people_who_match:interests:Malcolm X"] |
| 88 | data/2016-08/P(1)0001862.pdf | 236 | 5289 | Two years have passed since August 11, 2014, the date, when 25-year-old Ezell Ford was mur Justice For Ezell Ford and Donnell Thompson | https://www.facebook.com/events/1051176154917933/ | 6003.52 | RUB | 2016-08-26T04:19:56-07:00 | 2016-09-03T07:04:49-07:00 | ["custom_audience:Lookalike (US","custom_audience:10%) - tesy","location_living_in:united_states:Los Angeles (+50 mi) California","age:18 - 65+","language:English (UK)","language:English (US)","placements:News Feed on desktop computers","placements:News Feed on mobile devices","people_who_match:interests:Malcolm X"] |
| 89 | data/2016-08/P(1)0001864.pdf | 9 | 172 | Two years have passed since August 11, 2014, the date, when 25-year-old Ezell Ford was mur Justice For Ezell Ford, Jesse Romero and Donnell Thompson | https://www.facebook.com/events/1051176154917933/ | 147.23 | RUB | 2016-08-29T00:27:53-07:00 | 2016-09-03T07:04:49-07:00 | ["custom_audience:Lookalike (US","custom_audience:10%) - tesy","location_living_in:united_states:Los Angeles (+50 mi) California","age:18 - 65+","language:English (UK)","language:English (US)","placements:News Feed on desktop computers","placements:News Feed on mobile devices","people_who_match:interests:Latin","people_who_match:interests:Malcolm X"] |
| 90 | data/2016-08/P(1)0001866.pdf | 103 | 3477 | Two years have passed since August 11, 2014, the date, when 25-year-old Ezell Ford was mur Justice For Ezell Ford, Jesse Romero and Donnell Thompson | https://www.facebook.com/events/1051176154917933/ | 3849.25 | RUB | 2016-08-29T05:11:27-07:00 | 2016-09-03T07:04:49-07:00 | ["location_living_in:united_states:Los Angeles (+50 mi) California","age:18 - 65+","language:English (UK)","language:English (US)","placements:News Feed on desktop computers","placements:News Feed on mobile devices","people_who_match:interests:Latin","people_who_match:interests:Malcolm X"] |
| 91 | data/2016-03/P(1)0001231.pdf | 1499 | 49978 | We don’t want to honor racism, slavery and hatred. This is what Confederate Heritage is. Not My Heritage Rally | https://www.facebook.com/events/227388350945080/ | 13661.08 | RUB | 2016-03-15T08:02:45-07:00 | ["location:united_states:Jackson (+17 km) Mississippi","excluded_connections:Exclude people who are going to Not My Heritage Rally","age:18 - 60","language:English (UK)","language:English (US)","placements:News Feed on mobile devices","people_who_match:behaviors:African American (US)"] | |
| 92 | data/2015-07/P(1)0001868.pdf | 27 | 608 | Fast-growing black community. Latest news and everyday updates. | https://www.facebook.com/BlaCk-Matters-1579673598947501/ | 445.30 | RUB | 2015-07-10T01:03:03-07:00 | ["location:united_states:Chester (+20 km) Arkansas","location:united_states:Washington (+20 km) District of Columbia","location:united_states:Atlanta (+20 km) Georgia","location:united_states:New Orleans (+20 km) Louisiana","location:united_states:Baltimore (+20 km) Maryland","location:united_states:St. Louis (+20 km) Missouri","location:united_states:Cleveland (+20 km) Ohio","location:united_states:Philadelphia (+20 km) Pennsylvania","location:united_states:Memphis (+20 km) Tennessee","location:united_states:Richmond (+20 km) Virginia","location:united_states:Milwaukee (+20 km) Wisconsin","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"] | |
| 93 | data/2015-11/P(1)0001870.pdf | 922 | 17231 | A Year Without Justice for Tamir Rice. Join the meeting! A Year Without Justice for Tamir Rice | https://www.facebook.com/events/1486230091674577/ | 3988.68 | RUB | 2015-11-19T23:59:53-08:00 | ["location:united_states:Cleveland (+50 km) Ohio","behaviors:African American (US)","age:18 - 65+","language:English (UK)","language:English (US)","placements:News Feed on desktop computers","placements:News Feed on mobile devices"] | |
| 94 | data/2015-07/P(1)0001872.pdf | 0 | 0 | Keeping eye on our brother's cases and much more | https://www.facebook.com/blackmattersus/ | 0.00 | USD | 2015-07-13T07:17:59-07:00 | ["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"] | |
| 95 | data/2015-07/P(1)0001874.pdf | 4366 | 69296 | Keeping eye on our brother's cases and much more | https://www.facebook.com/blackmattersus/ | 20446.19 | RUB | 2015-07-13T07:20:58-07:00 | ["location:united_states:Atlanta (+20 km) Georgia","location:united_states:Maryland","location:united_states:Ferguson (+20 km), 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"] | |
| 96 | data/2016-04/P(1)0001876.pdf | 2813 | 54463 | Counter-protest against 'White Power' Confederate rally at Stone Mountain Not My Heritage | https://www.facebook.com/events/1579032272388106/ | 14912.81 | RUB | 2016-04-06T08:41:45-07:00 | 2016-04-24T22:41:00-07:00 | ["location:united_states:Atlanta (+20 km) Georgia","age:18 - 50","placements:News Feed on desktop computers","placements:News Feed on mobile devices"] |
| 97 | data/2016-05/P(1)0000034.pdf | 2603 | 74257 | 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 | https://blackmattersus.com/ | 5241.60 | RUB | 2016-05-10T07:26:47-07:00 | ["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","people_who_match:Multicultural Affinity: African American (US)"] | |
| 98 | data/2016-06/P(1)0000036.pdf | 0 | 0 | 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 | https://blackmattersus.com/ | 0.00 | USD | 2016-06-23T06:07:51-07:00 | ["custom_audience:Lookalike (US","custom_audience: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"] | |
| 99 | data/2016-06/P(1)0000038.pdf | 0 | 0 | Get breaking news and analysis on the life of African American community in the US. Black Matters Black Matters | https://blackmattersus.com/ | 0.00 | USD | 2016-06-23T06:11:47-07:00 | ["custom_audience:Lookalike (US","custom_audience: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"] | |
| 100 | data/2015-07/P(1)0001878.pdf | 0 | 0 | Keeping eye on our brother's cases and much more | https://www.facebook.com/blackmattersus/ | 0.00 | USD | 2015-07-13T07:18:00-07:00 | ["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"] | |
| 101 | data/2015-07/P(1)0001880.pdf | 5155 | 79112 | Keeping eye on our brother's cases and much more | https://www.facebook.com/blackmattersus/ | 23298.73 | RUB | 2015-07-13T07:20:58-07:00 | ["location:united_states:Atlanta (+20 km) Georgia","location:united_states:Maryland","location:united_states:Ferguson (+20 km), 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"] | |
| 102 | data/2016-07/P(1)0001882.pdf | 2775 | 37821 | Almost 2 years have passed since the death of Eric Garner, a father of 6, who was violentl Rally In Memory Of Eric Garner | https://www.facebook.com/events/1085290071563825/ | 12485.17 | RUB | 2016-07-06T03:03:43-07:00 | 2016-07-17T03:03:41-07:00 | ["location:united_states:New York (+40 km) New York","interests:BIackNews.com","age:18 - 65+","placements:News Feed on desktop computers","placements:News Feed on mobile devices"] |
| 103 | data/2016-07/P(1)0001884.pdf | 0 | 0 | Almost 2 years have passed since the death of Eric Garner, a father of 6, who was violentl Rally In Memory Of Eric Garner | https://www.facebook.com/events/1085290071563825/ | 0.00 | USD | 2016-07-28T06:40:03-07:00 | 2016-07-17T03:03:41-07:00 | ["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"] |
| 104 | data/2016-08/P(1)0001886.pdf | 0 | 0 | Almost 2 years have passed since the death of Eric Garner, a father of 6, who was violentl Rally In Memory Of Eric Garner | https://www.facebook.com/events/1085290071563825/ | 0.00 | USD | 2016-08-04T07:24:02-07:00 | 2016-07-17T03:03:41-07:00 | ["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"] |
| 105 | data/2015-10/P(1)0001888.pdf | 109 | 917 | Black Matters. Black community. | https://www.facebook.com/blackmattersus/ | 227.80 | RUB | 2015-10-06T08:24:59-07:00 | ["location:United States","interests:BlackNews.com","interests:HuffPost Black Voices","behaviors:African American (US)","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"] | |
| 106 | data/2015-11/P(1)0001890.pdf | 35 | 1002 | Black Matters. Black community. | https://www.facebook.com/blackmattersus/ | 95.01 | RUB | 2015-11-05T23:17:06-08:00 | ["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"] |
JSON shape: default, array, newline-delimited
CREATE VIEW ads_with_targets as select ads.*, json_group_array(targets.name) as target_names from ads join ad_targets on ad_targets.ad_id = ads.id join targets on ad_targets.target_id = targets.id group by ad_targets.ad_id