home / russian-ads

display_ads (view)

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

2 rows where an ad_target was people_who_match:interests:Hispanic and latino americah culture

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
2555 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Hispanic and latino americah culture, people_who_match:interests:Mexico, people_who_match:interests:Being Chicano, people_who_match:interests:Mexican american culture, people_who_match:interests:Hispanic culture, people_who_match:interests:Latino culture, people_who_match:interests:Latin hip hop, people_who_match:interests:Chicano, people_who_match:interests:Chicano Movement, people_who_match:interests:Hispanidad, people_who_match:interests:Mexican Pride, people_who_match:interests:Lowrider, people_who_match:interests:Chicano rap, people_who_match:interests:La Raza 78307 9591 https://www.facebook.com/brownunitedfront/ Ah indigenous woman will be running for president of Mexico in 2018. Mexico hasn't have an indigenous president since Benito Juarez and that was over 130 years ago. The indigenous communities that are part of the National Indigenous Congress decided to struggle collectively, for another way of doing politics and for the right to live. I hope her policy will be the opposite of the US. policy, which does not spare its citizens and sends them to fight in the Middle East to satisfy their political ambitions. Source: — 18.01296 1125.81 RUB 2017-05-25T07:05:44-07:00 2017-05-29T07:05:44-07:00
2663 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Hispanic and latino americah culture, people_who_match:interests:Mexico, people_who_match:interests:Being Chicano, people_who_match:interests:Mexican american culture, people_who_match:interests:Hispanic culture, people_who_match:interests:Latino culture, people_who_match:interests:Latin hip hop, people_who_match:interests:Chicano, people_who_match:interests:Chicano Movement, people_who_match:interests:Hispanidad, people_who_match:interests:Mexican Pride, people_who_match:interests:Lowrider, people_who_match:interests:Chicano rap, people_who_match:interests:La Raza 27749 5102 https://www.facebook.com/brownunitedfront/ This is Juanita, daughter of immigrants. She was raised on a ranch in Mexico and she brought with her those traditions. She has six siblings and she will be the first to graduate from a university. Juanita has worked in the fields to help her family. I had the honour to capture her grad pictures. In the back, you can see her mother working. It made me so happy to see how proud her mother is of her. Y su padre ha de estar muy orgulloso de lo que ella a Iogrado. Desde el Cielo ha de sonreir y decir "esa es mi Juanita". Source: — 4.02192 251.37 RUB 2017-05-12T07:28:10-07:00 2017-05-13T07:28:10-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/umd-mith/irads/master/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 1306.57ms · Data source: simonw/russian-ira-facebook-ads-datasette