home / russian-ads

display_ads (view)

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

18 rows where an ad_target was location:united_states:Louisiana

View and edit SQL

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
32 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 12727 375 https://www.instagram.com/south_united/ 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 49.700480000000006 3106.28 RUB 2016-08-18T08:31:16-07:00  
1449 location:united_states:Louisiana, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 26837 2125 https://www.facebook.com/events/2067403916818218/ Alton Sterling, an innocent 37-year-old Black male, was outrageously executed by two Baton Justice For Alton Sterling 131.18608 8199.13 RUB 2016-07-06T07:06:29-07:00 2016-07-09T13:00:00-07:00
1457 location:united_states:Louisiana, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Dont-Shoot-1157233400960126/ This short video shows the bloody scuffle that took place during the forceful arrest of a homeless man Terre Johnson. SPREAD THIS LIKE WILDFIRE, if you believe #BlaCkLivesMatter ! Full story: http://goo.g|/GX8dYu 0.0 0.00 USD 2016-07-06T07:06:06-07:00 2016-05-13T08:08:49-07:00
1477 no image location:united_states:Louisiana, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Dont-Shoot-1157233400960126/ Is that justice? Public officials assaulted a man without any consequences. How and why does the government allow it? 0.0 0.00 USD 2016-07-06T07:05:48-07:00 2016-05-09T06:36:15-07:00
1480 no image location:united_states:Louisiana, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Dont-Shoot-1157233400960126/ Everyday we watch, read and receive news of police beating, assaulting, and killing innocent people. These videos and instances have become so common that people are rarely shocked by even the most brutal of cases. We were wondering how long time would it take to make people fighting back? So now, karma's coming back for blue pigs! A shocking video was shared on social media Tuesday showing two police officers being attacked. Two unidentified men were seen beating up the two officers for seemingly no reason. The incident occurred Monday afternoon in Northeast Philadelphia after two school police officers were called to break up a fight outside of a local pizza shop. As we can see police couldn't stop the fight. Now we see what kind of police do we have. Those cops are slow weak doughnuts, who can do |itera||y nothing without using their guns. Cops can blame themselves when shit like this happens. They live by their own laws, they can break your arms and legs, torture you with Chemical and electrical ways, rape or even kill you "doing theirjob." All those things and more are well within departmental policy. So I'd rather give a fight for my rights than ignore the fact our country becoming a Nazi States of America. Look around, the only other thing that will happen is that people will whine about it, but will ultimately do nothing to actively stop this behavior, and this is why cops are so violent now. If we want to stop it, we should fight as our ancestors did it for centuries. Take out a few dozen cops and the rest will Change. Amen. 0.0 0.00 USD 2016-07-06T07:05:50-07:00 2016-05-09T06:35:55-07:00
1483 no image location:united_states:Louisiana, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Dont-Shoot-1157233400960126/ Rookie Florida cop arrested, fired after being caught on video beating up handcuffed strip Club employee Video shows probationary patrol officer Akinyemi Borisade repeatedly hitting 31-year-old Mayra Martinez on Wednesday at the Duval County jail. Man, there were so many ways to fix the situation without resorting to use excessive force. The worst part of it is how everyone just stands around nonchalantly.? People who support cops and belive in good cops, please tell me why the he“ a bunch of cops just stand and watch how another cop beating a woman??? How??? How can we respect law enforcement, if they act like that? If you want my respect, STOP SHOOTING AND BEATING THE CITIZENS YOU SWORE TO PROTECT!!! ? IF U AGREE 0.0 0.00 USD 2016-07-06T07:05:51-07:00 2016-05-07T06:35:41-07:00
1486 no image location:united_states:Louisiana, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Dont-Shoot-1157233400960126/ State Police pulled Philadelphia attorney Rebecca Musarra over for allegedly speeding on October 16, 2015. She refused to answer any questions and they arrested her for obstruction of justice. She was later released without being Charged for obstruct. Americans have rights and one of them is the right to remain silent. We don't have to answer your stupid interrogation questions. If we are speeding, tell us we were stopped for speeding, issue the warning/summons and get the hell out of our lives Nazis. Why did they escalate the situation? What for? The best part of the video is when they say she had the right to remain silent. LOL! #Copslogic 0.0 0.00 USD 2016-07-06T07:05:53-07:00 2016-05-07T06:35:17-07:00
1496 no image location:united_states:Louisiana, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Dont-Shoot-1157233400960126/ Please take a moment to read my story! Back in 2015, Douglas Babbitt was talking on the phone in the driver's seat of his parked van when a police officer asked if an open beer bottle on the ground near the vehicle's front passenger door belonged to him. Notice the location of the beer can - it's located on the ground, outside of the vehicle, on the passenger's side. When Babbitt said the beer wasn't his, the police needlessly escalated the situation that lead to Babbitt's arrest, and left the 51-year-old Oakland man briefly lying unconscious on the ground. The beer wasn't in his car, and a toxicology report from after his arrest shows that he had no alcohol in his system. So what's the problem with you guys? Damn, after all that, the only thing I may conclude is DO NOT TALK TO POLICE! The following video is a prime example of why... 0.0 0.00 USD 2016-07-06T07:06:03-07:00 2016-05-16T07:17:05-07:00
1499 no image location:united_states:Louisiana, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Dont-Shoot-1157233400960126/ A man misidentified by a cop was violently body slammed to the ground and punched in the face. The bizarre incident occurred at the playground at the moment when the man was trying to pick up his Child. Let's make these cop famous! ? + Comment + Share this video with your friends and family. Full story: http://bit.|y/1R0RCAP 0.0 0.00 USD 2016-07-06T07:05:58-07:00 2016-05-16T07:16:44-07:00
1502 no image location:united_states:Louisiana, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Dont-Shoot-1157233400960126/ Cops are allergic to cameras, they don't like being recorded because it won't allow them to break the law and lie about the Circumstances which presented them the opportunity to break the law. ?WARNING!!!? In yet another disturbing video of police escalating violence in a public school, a Philadelphia school cop was caught on video in an intense altercation with a student. According to the Philadelphia Student Union, of which the alleged victim, Brian Burney, the incident was all over a dispute over using the bathroom. The student, who recorded the incident, was told to delete it. All that is left is a brief Clip showing the officer, who is twice the size of Burney, on top of him. I don't understand why are there cops in schools? Cops are nothing more then a bunch of bu||ies or gang members in police uniforms! Whatever happened to deans? Moreover, don't you think it's a bit strange, when an officer forces someone to delete video? Obviously, police is trying to hide something and their testimony should be considered a lie. Also, is not destruction of evidence a crime? What do you think about it guys? Please, share or comment below. 0.0 0.00 USD 2016-07-06T07:06:04-07:00 2016-05-14T07:16:12-07:00
1505 no image location:united_states:Louisiana, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Dont-Shoot-1157233400960126/ Watch below an attack on another victim of police brutality. R.|.P Sarah Reed. 0.0 0.00 USD 2016-07-06T07:06:01-07:00 2016-05-13T08:09:30-07:00
1508 no image location:united_states:Louisiana, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Dont-Shoot-1157233400960126/ Clark Dickson, a veteran Seattle police department officer, punched a homeless 21-year-old man in the head and remained unpunished. The cop said that his misconduct was “justified” because the man had spit at him. Almost one year after the incident, the footage showing the punch was released. Personally, I didn’t notice in the video the suspect spitting at Dickson. However, the police department didn’t consider it necessary to punish the cop. The only penalty he got was a suspension without pay for 1 day. Is it really enough for excessive force use? 0.0 0.00 USD 2016-07-06T07:06:08-07:00 2016-05-13T08:09:18-07:00
1515 no image location:united_states:Louisiana, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Dont-Shoot-1157233400960126/ Did you see this? Damn... We lost count of how many mentally ill Citizens were murdered during encounters with violent cops. Here is another woman suffering from mental illness. Full story: http://bit.|y/10rq|hk 0.0 0.00 USD 2016-07-06T07:05:59-07:00 2016-05-16T07:30:00-07:00
1561 no image location:united_states:Louisiana, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Dont-Shoot-1157233400960126/ A simple traffic stop turned into the violent situation. Cop refused to identify himself, instead, he nearly killed a man. The shocking video reveals the real face of the US police. Read the full story: http://bit.|y/294CSi9 0.0 0.00 USD 2016-07-06T07:05:56-07:00 2016-06-29T06:49:57-07:00
1563 no image location:united_states:Louisiana, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Dont-Shoot-1157233400960126/ Warning! The video is graphic. Two cops brutally assaulted a man and killed him! Whatever he did, they didn't have the right to treat him like that! Cops are taking away people's lives and they don't even need a reason for that! 0.0 0.00 USD 2016-07-06T07:05:54-07:00 2016-06-29T06:49:34-07:00
1695 no image location:united_states:Louisiana, location:united_states:Minnesota, age:13 - 60, placements:Instagram Feed, people_who_match:interests:Black Power, people_who_match:interests:Fight the Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Slavery by Another Name, people_who_match:interests:Malcolm X, people_who_match:interests:Cop Block 36601 920 https://www.facebook.com/Blackluive-1725227467722991/ I didn't believe the media, 80 | BECAME ONE. Follow! 79.07808 4942.38 RUB 2016-07-11T02:41:37-07:00  
1885 no image location:united_states:Alabama, location:united_states:Arkansas, location:united_states:Georgia, location:united_states:Illinois, location:united_states:Iowa, location:united_states:Louisiana, location:united_states:Minnesota, location:united_states:Mississippi, location:united_states:Nebraska, location:united_states:Wisconsin, age:16 - 60, placements:Instagram Feed, people_who_match:interests:U.S. Patriot Tactical, people_who_match:interests:Flags of the Confederate States of America, people_who_match:interests:The Patriot Post, people_who_match:interests:Confederate States of America, people_who_match:interests:American Patriots, people_who_match:interests:Thank A Soldier, people_who_match:interests:Flag of the United States, people_who_match:interests:Guns & Patriots, people_who_match:interests:American Patriot, people_who_match:interests:Proud to be an American, people_who_match:interests:American patriotism, people_who_match:interests:Chris Kyle 13211 10 https://www.facebook.com/Lalalo-1028159433939877/ INSTagram Of The United States or simply - INSTOTUS. Unique Instagram page for American patriots only! FOLLOW! JUST DO IT! 36.44064 2277.54 RUB 2016-05-20T04:36:31-07:00  
1897 location:united_states:Louisiana, interests:Reading, age:18 - 65+, language:English (US), placements:Instagram Feed 12559 90 https://www.instagram.Com/south_united/ Located on a barrier island in the Gulf of Mexico, Grand Isle is a small fishing town that has proved resilient despite being battered by hurricanes throughout the years. The tiny town is the setting for The Awakening by Kate Chopin, who spent her summers in Grande |s|e for many years. The island is full of beautiful beaches, protected as part of Grand Isle State Park. Click Learn More! Join us! South United Yoyoyoyoyo 34.93632 2183.52 RUB 2015-12-10T06:59:52-08: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 1663.112ms · Data source: simonw/russian-ira-facebook-ads-datasette