home / russian-ads

display_ads (view)

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

11 rows where an ad_target was location:united_states:Houston (+50 mi) Texas

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
704 location:united_states:Houston (+50 mi) Texas, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Texas 0 0 https://www.facebook.com/events/554359838086349/ It's been 15 years since the 9/11 and it became Clear that extemist terror groups are bein Stop Radical Islam 0.0 0.00 USD 2016-08-26T04:13:51-07:00 2016-09-10T03:10:55-07:00
705 location:united_states:Houston (+50 mi) Texas, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Texas 18540 1520 https://www.facebook.com/events/554359838086349/ It's been 15 years since the 9/11 and it became Clear that extemist terror groups are bein Stop Radical Islam 160.0 10000.00 RUB 2016-08-26T04:13:56-07:00 2016-09-10T03:10:55-07:00
706 location:united_states:Houston (+50 mi) Texas, 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:Texas 0 0 https://www.facebook.com/events/554359838086349/ It's been 15 years since the 9/11 and it became Clear that extemist terror groups are bein Stop Radical Islam 0.0 0.00 USD 2016-09-08T05:49:40-07:00 2016-09-10T03:10:55-07:00
707 location:united_states:Houston (+50 mi) Texas, 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:Texas 8538 632 https://www.facebook.com/events/554359838086349/ It's been 15 years since the 9/11 and it became Clear that extemist terror groups are bein Stop Radical Islam 62.15424 3884.64 RUB 2016-09-08T05:50:25-07:00 2016-09-10T03:10:55-07:00
715 location:united_states:Houston (+50 mi) Texas, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Texas 0 0 https://www.facebook.com/Heart-of-Texas-761114847343674/ America's slowly but surely shifting towards turning into islamic state. Our president and our government are pro—islamic and don't want America to believe in our one and only Lord Jesus Christ. Texas will never keep step with US. Texas stays Christian even when odds are against us. 0.0 0.00 USD 2016-08-26T04:13:50-07:00 2016-05-11T06:11:15-07:00
716 location:united_states:Houston (+50 mi) Texas, 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:Texas 0 0 https://www.facebook.com/Heart-of-Texas-761114847343674/ America's slowly but surely shifting towards turning into islamic state. Our president and our government are pro—islamic and don't want America to believe in our one and only Lord Jesus Christ. Texas will never keep step with US. Texas stays Christian even when odds are against us. 0.0 0.00 USD 2016-09-08T05:49:40-07:00 2016-05-11T06:11:15-07:00
1107 location:united_states:Houston (+50 mi) Texas, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Black panther 9788 981 https://www.facebook.com/events/1094784283992152/ On October 15, 1966, Bobby Seale and Huey P. Newton have founded BPP. Their idea was simple - we can't just talk to make the Change, we must take action. They started to monitor the behavior of police officers and Challenge police brutality in Oakland, California. And they succeeded. Unfortunately, the government and especially Federal Bureau of Investigation called the party "the greatest threat to the internal security of the country". They tried to Close it, to incarcerate BPP's participants, and in 1982 the original party was dissolved. 50 years have passed since BBP's foundation, but the situation in the country stills the same. Cops are shooting Blacks. lt spreads through all the country like the disease. Nowadays we need Black Panthers as never before. We need a strong hand that can protect us, that can keep our people safe, that can make Black Lives really matter. Let's get together and celebrate the 50th anniversary of the party that has made the Change. Let's honor its founders and participants. Let's share their ideas and ideals! Black Panther Party 50th Anniversary 31.98752 1999.22 RUB 2016-10-05T04:50:02-07:00 2016-10-14T15:00:00-07:00
1127 location:united_states:Houston (+50 mi) Texas, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Black panther 510 71 https://www.facebook.com/events/1183449788395273/ Houstonians, come out to honor the memory of Huey P. Newton, and other black leaders and prominent members of the Black Panther Party on October 15! We should revive their legacy and discuss the plan that Newton and Seale crafted to empower Black communities economically. The plan contained basic demands such as self—determination, decent housing, full employment, education that included African-American history, and an end to police brutality. The list of confirmed speakers will be released a few days before the event Share and invite your friends! Black Panther Party 50th Anniversary H-Town 1.37616 86.01 RUB 2016-10-05T04:50:03-07:00 2016-10-14T16:00:00-07:00
1128 location:united_states:Houston (+50 mi) Texas, age:16 - 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, people_who_match:interests:Black Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Black panther 9693 878 https://www.facebook.com/events/1183449788395273/ Houstonians, come out to honor the memory of Huey P. Newton, and other black leaders and prominent members of the Black Panther Party on October 15! We should revive their legacy and discuss the plan that Newton and Seale crafted to empower Black communities economically. The plan contained basic demands such as self—determination, decent housing, full employment, education that included African-American history, and an end to police brutality. The list of confirmed speakers will be released a few days before the event Share and invite your friends! Black Panther Party 50th Anniversary H-Town 14.61824 913.64 RUB 2016-10-06T01:03:54-07:00 2016-10-14T16:00:00-07:00
1612 location:united_states:Houston (+50 mi) Texas, interests:Islamism, interests:Glossary of Islam, interests:Sharia, interests:Hijra (Islam), age:18 - 45, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 7 1 https://www.facebook.com/events/571644626347616/ It’s been only a month since Library of Islamic Knowledge at the center in Houston is open SAVE ISLAMIC KNOWLEDGE 0.164 10.25 RUB 2016-05-11T07:01:48-07:00 2016-05-18T07:01:46-07:00
1613 location:united_states:Houston (+50 mi) Texas, interests:Islamism, interests:Glossary of Islam, interests:Sharia, interests:Hijra (Islam), age:18 - 45, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 2726 176 https://www.facebook.com/events/571644626347616/ It’s been only a month since Library of Islamic Knowledge at the center in Houston is open SAVE ISLAMIC KNOWLEDGE 44.11696 2757.31 RUB 2016-05-12T01:34:21-07:00 2016-05-18T07:01:46-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 1349.519ms · Data source: simonw/russian-ira-facebook-ads-datasette