home / russian-ads

display_ads (view)

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

10 rows where an ad_target was location:united_states:Detroit Michigan

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
265 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 1264 79 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Six years later and still no justice for Aiyana Stanley Jones. On May 21, 2016, a peaceful rally will be held in Detroit outside the Coleman A. Young Municipal Center to remember Aiyana and all victims of police brutality. https://www.facebook.com/events/1727519624184050/ 23.39168 1461.98 RUB 2016-05-19T04:36:50-07:00 2016-05-20T04:36:48-07:00
266 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 325 19 https://www.facebook.com/BlaCk-Matters-1579673598947501/ She only allowed her son to drive a golf cart. A beautiful family who always take a yearly vacation at the luxury resort on Bald Head Island met a horrible experience this year as soon as they met with polio Mom Brutalized And Jailed For Presumptuous Child Abuse | Black Matters Black Matters 7.0387200000000005 439.92 RUB 2016-05-24T07:44:29-07:00 2016-05-25T07:44:28-07:00
267 no image location:united_states:Detroit Michigan, interests:African American, age:18 — 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 397 19 https://www.facebook.com/BIack-Matters-157967359894750“ — has a history of assaulting people of color; yet he’s still in blue. The racist attitude of the Austin Police Department is that they will find any flimsy excuse to brutalize people of color on a nightly basis. Recently, during a Austin Police Assaults A Black American Downtown | Black Matters Black Matters 6.8751999999999995 429.70 RUB 2016-05-24T07:44:09-07:00 2016-05-25T07:44:08-07:00
268 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 340 24 https://www.facebook.com/BlaCk-Matters-1579673598947501/ President Obama signed bill HR. 4238, “modernizing terms relating to minorities,” into law Friday. Over the years, the minority have been looked down upon, i||-treated, teased by peers and felt inferior due to their historical background. In the 21st century, ‘Negro,’ ‘Oriental’ and ‘Indian’ To Be Abated From All Federal Laws | Black Matters Black Matters 6.7968 424.80 RUB 2016-05-24T07:43:49-07:00 2016-05-25T07:43:48-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
270 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 718 89 https://www.facebook.com/BlaCk-Matters-1579673598947501/ “Ummmmm did you just not want ME to sit next to you?” Former NBA basket ball player Etan Thomas writes about a woman who refused to allow him sit next to her on a train. Thomas explains that he politely and softly NBA Star Confronts Racist Woman On A Train | Black Matters Black Matters 9.09984 568.74 RUB 2016-05-23T08:19:17-07:00 2016-05-24T08:19:15-07:00
271 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 130 10 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Police watch three black Florida teenagers drown in a pond after Chasing them for an alleged stolen car. Natasha Winkler who is the mother of Laniya Miller, one of the three teens who drowned in a pond in St. Petersburg, Fl, after a police Chase on March 31, said t Black Moms say Cops Watched Their Daughters Drown Without Doing Anything | Black Matters Black Matters 2.43824 152.39 RUB 2016-05-23T08:17:29-07:00 2016-05-24T08:17:27-07:00
272 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 90 6 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Chicago researchers believe a few minutes of meditation may be a solution to dealing with stress problems for black students. Researchers at the Erikson Institute in Chicago are carrying out a 4-year-study to determine whether sitting down for few minutes with legs crossed each other a New Study: Meditation May Help Black Students Cope With Stress | Black Matters Black Matters 1.45168 90.73 RUB 2016-05-23T08:06:37-07:00 2016-05-24T08:06:35-07:00
273 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 57 5 https://www.facebook.com/BlaCk-Matters-1579673598947501/ A new research shows that blacks are more likely to be diagnosed with depression and schizophrenia disorders than whites. The study, which was published by the Psychiatric Services journal, analyzed medical records of patients from the Mental Health Research Network. One of the co- More Blacks Are Diagnosed With Schizophrenia But Few Are Treated | Black Matters Black Matters 1.36528 85.33 RUB 2016-05-23T08:06:15-07:00 2016-05-24T08:06:14-07:00
274 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 74 11 https://b|ackmattersus.com/8347-ohio—authorities-keep-their—eyes-shut-at-kkk- A black man found hanged on a tree, still no investigation initiated. The body of a 38-year-old Atlanta resident was discovered in the territory of the forest not far from Richmond Road and Park East Drive, Beechwood, Ohio. The bl Ohio Authorities Keep Their Eyes Shut At KKK—style Death | Black Matters Black Matters 1.0481600000000002 65.51 RUB 2016-05-25T00:32:02-07:00 2016-05-26T00:32:00-07:00

Advanced export

JSON shape: default, array

CSV options:

CREATE VIEW display_ads AS 
        select ads.id,
            case when image is not null then
                json_object("img_src", "https://raw.githubusercontent.com/edsu/irads/03fb4b/site/" || image, "width", 200)
            else
                "no image"
            end as img,
            json_group_array(
                json_object(
                    "label", targets.name,
                    "href", "/russian-ads/display_ads?_target="
                        || urllib_quote_plus(targets.id)
                )
            ) as targeting,
            ads.impressions, ads.clicks, ads.url, ads.text,
            cast(case
                when ads.spend_currency == "RUB" then ads.spend_amount * 0.016
                else ads.spend_amount
            end as float) as spend_usd,
            ads.spend_amount, ads.spend_currency,
            ads.created, ads.ended
        from ads
            join ad_targets on ads.id = ad_targets.ad_id
            join targets on ad_targets.target_id = targets.id
        group by ads.id
        order by ads.id
Powered by Datasette · Query took 1386.899ms · Data source: simonw/russian-ira-facebook-ads-datasette