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
This data as JSON, CSV (advanced)
|
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 |
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