home / russian-ads

ads

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

3,498 rows sorted by text

View and edit SQL

Suggested facets: spend_currency

id pdf image clicks impressions text ▼ url spend_amount spend_currency created ended
48 data/2015-08/P(1)0000020.pdf images/0048.png 0 0   https://www.facebook.com/pages/Proud-BIacks/1065511110127506 0.00 USD 2015-08-13T03:30:11-07:00 2015-08-14T03:30:11-07:00
79 data/2015-06/P(1)0001844.pdf images/0079.png 0 31   https://www.facebook.com/pages/L-for-Iife/994910227187446 33.59 RUB 2015-06-09T03:50:21-07:00 2015-06-11T03:48:00-07:00
113 data/2015-07/P(1)0001900.pdf   144 1468   https://www.facebook.com/blackmattersus/ 196.27 RUB 2015-07-14T06:14:06-07:00 2015-07-15T06:14:05-07:00
283 data/2016-07/P(1)0002057.pdf   0 0     0.00 USD 2016-07-14T02:05:21-07:00 2016-07-15T02:05:19-07:00
311 data/2016-02/P(1)0002091.pdf   1 8   https://www.facebook.com/blackmattersus/ 5.47 RUB 2016-02-12T07:00:28-08:00 2016-02-15T07:00:27-08:00
315 data/2015-11/P(1)0002095.pdf   0 0     0.00 USD 2015-11-19T23:21:05-08:00 2015-11-22T23:21:03-08:00
318 data/2015-07/P(1)0002098.pdf   90 1331   https://www.facebook.com/BlaCk-Matters-1579673598947501/ 253.53 RUB 2015-07-16T02:22:53-07:00 2015-07-19T02:22:53-07:00
430 data/2015-06/P(1)0002263.pdf images/0430.png 0 0   https://www.facebook.com/pages/L-for-Iife/994910227187446 0.00 USD 2015-06-09T03:48:26-07:00 2015-06-10T03:48:25-07:00
443 data/2016-04/P(1)0002279.pdf images/0443.png 1 34     55.32 RUB 2016-04-13T03:23:43-07:00  
463 data/2016-04/P(1)0000068.pdf images/0463.png 0 14     11.24 RUB 2016-04-13T03:24:30-07:00  
483 data/2016-04/P(1)0000088.pdf images/0483.png 3 60     84.01 RUB 2016-04-13T03:22:57-07:00  
486 data/2016-04/P(1)0002335.pdf images/0486.png 39 560     821.33 RUB 2016-04-14T04:15:57-07:00  
487 data/2016-04/P(1)0000090.pdf images/0487.png 171 3335     4364.22 RUB 2016-04-12T01:59:17-07:00  
493 data/2016-04/P(1)0000094.pdf images/0493.png 4 94     148.73 RUB 2016-04-13T03:24:03-07:00  
496 data/2016-04/P(1)0002347.pdf images/0496.png 7 132     173.93 RUB 2016-04-13T03:24:00-07:00  
501 data/2016-04/P(1)0000098.pdf images/0501.png 3 78     108.14 RUB 2016-04-13T03:23:39-07:00  
524 data/2016-08/P(1)0006210.pdf images/0524.png 259 5253   3876.40 RUB 2016-08-23T04:59:14-07:00 2016-08-25T04:59:10-07:00
536 data/2016-04/P(1)0000118.pdf images/0536.png 0 4     2.23 RUB 2016-04-13T03:23:02-07:00  
694 data/2016-02/P(1)0002648.pdf   9 164   http://edition.cnn.com/2016/02/08/midd|eeast/syria-turkey-border-damon/ 88.92 RUB 2016-02-08T06:36:57-08:00 2016-02-09T06:36:57-08:00
859 data/2016-02/P(1)0001535.pdf images/0859.png 50 2574   https://www.facebook.com/WilliamsandKalvin/ 850.00 RUB 2016-02-02T06:18:30-08:00 2016-02-06T04:00:45-08:00
904 data/2016-02/P(1)0001579.pdf images/0904.png 128 2939   https://www.facebook.com/WilliamsandKalvin/ 850.00 RUB 2016-02-02T06:18:50-08:00 2016-02-06T04:00:31-08:00
931 data/2017-05/P(1)0001248.pdf images/0931.png 1607 10543   https://www.facebook.com/blacktivists/ 300.00 RUB 2017-05-17T04:21:04-07:00 2017-05-18T11:00:00-07:00
937 data/2017-05/P(1)0000206.pdf images/0937.png 4290 32942   https://www.facebook.com/blacktivists/ 200.00 RUB 2017-05-16T06:17:51-07:00 2017-05-17T06:17:51-07:00
939 data/2017-05/P(1)0006464.pdf images/0939.png 1868 10493   https://www.facebook.com/blacktivists/ 173.63 RUB 2017-05-18T07:12:05-07:00 2017-05-19T16:00:00-07:00
954 data/2017-05/P(1)0006466.pdf images/0954.png 523 5129   https://www.facebook.com/blacktivists/ 300.00 RUB 2017-05-16T07:09:31-07:00 2017-05-17T09:00:00-07:00
958 data/2017-03/P(1)0006468.pdf images/0958.png 2295 16816   https://www.facebook.com/blacktivists/ 137.04 RUB 2017-03-16T05:40:05-07:00 2017-03-17T12:00:00-07:00
967 data/2017-03/P(1)0001258.pdf images/0967.png 72 492   https://www.facebook.com/BIacktivist-128371547505950/ 14.53 RUB 2017-03-29T07:31:03-07:00 2017-03-30T07:31:03-07:00
987 data/2017-04/P(1)0000246.pdf images/0987.png 1250 6482   https://www.facebook.com/blacktivists/ 104.80 RUB 2017-04-21T07:42:24-07:00 2017-04-24T09:00:00-07:00
989 data/2017-04/P(1)0001266.pdf images/0989.png 1110 7745   https://www.facebook.com/blacktivists/ 199.99 RUB 2017-04-21T07:40:47-07:00 2017-04-22T18:00:00-07:00
1003 data/2017-04/P(1)0001268.pdf images/1003.png 230 1797   https://www.facebook.com/blacktivists/ 102.49 RUB 2017-04-14T08:03:15-07:00 2017-04-15T17:00:00-07:00
1007 data/2017-04/P(1)0001270.pdf images/1007.png 315 2919   https://www.facebook.com/blacktivists/ 117.92 RUB 2017-04-14T08:01:00-07:00 2017-04-15T13:00:00-07:00
1015 data/2017-04/P(1)0006482.pdf images/1015.png 5893 31651   https://www.facebook.com/blacktivists/ 300.00 RUB 2017-04-13T04:44:26-07:00 2017-04-14T04:44:26-07:00
1019 data/2017-04/P(1)0001278.pdf images/1019.png 583 5115   https://www.facebook.com/blacktivists/ 177.00 RUB 2017-04-13T03:41:20-07:00 2017-04-14T03:41:20-07:00
1053 data/2017-03/P(1)0001284.pdf images/1053.png 2328 17905   https://www.facebook.com/BIacktivist-128371547505950/ 253.70 RUB 2017-03-14T07:01:00-07:00 2017-03-15T12:00:00-07:00
1125 data/2016-12/P(1)0002923.pdf   392 7911     400.00 RUB 2016-12-06T23:31:19-08:00 2016-12-07T23:31:19-08:00
1133 data/2017-02/P(1)0006498.pdf images/1133.png 11269 67886   https://www.facebook.com/Blacktivist-128371547505950/ 400.00 RUB 2017-02-16T03:50:16-08:00 2017-02-17T03:50:16-08:00
1179 data/2016-11/P(1)0001290.pdf images/1179.png 3605 20526   https://www.facebook.com/BIacktivist-128371547505950/ 400.00 RUB 2016-11-18T08:21:54-08:00 2016-11-19T08:21:54-08:00
1185 data/2017-03/P(1)0006502.pdf images/1185.png 0 0   https://www.facebook.com/blacktivists/ 0.00 USD 2017-03-15T05:18:46-07:00 2017-03-16T06:00:00-07:00
1221 data/2016-08/P(1)0003073.pdf   0 0   https://www.facebook.com/Blacktivist-128371547505950/ 0.00 USD 2016-08-10T04:54:06-07:00 2016-05-07T05:45:23-07:00
1233 data/2016-05/P(1)0003086.pdf images/1233.png 2 14     2.81 RUB 2016-05-16T08:26:53-07:00 2016-05-19T08:15:33-07:00
1239 data/2016-02/P(1)0003092.pdf   1179 9778   https://www.facebook.com/blacktivists/ 5000.00 RUB 2016-02-18T05:33:23-08:00 2016-02-19T05:30:06-08:00
1270 data/2016-08/P(1)0003143.pdf images/1270.png 0 0     0.00 USD 2016-08-30T02:32:29-07:00  
1298 data/2016-07/P(1)0001292.pdf images/1298.png 91 3749   https://www.facebook.com/EricDraitser1lposts/950925828350122 2000.00 RUB 2016-07-06T06:56:45-07:00 2016-07-08T06:56:44-07:00
1465 data/2015-10/P(1)0003498.pdf   771 12616   https://www.facebook.com/Dont-Shoot-1157233400960126/ 700.00 RUB 2015-10-02T07:14:22-07:00 2015-10-05T07:14:21-07:00
1643 data/2016-03/P(1)0003706.pdf images/1643.png 49 244   https://www.facebook.com/MuslimAmerica/ 100.00 RUB 2016-03-17T04:21:29-07:00 2016-03-18T04:21:28-07:00
1678 data/2016-03/P(1)0003774.pdf   330 4869   https://www.facebook.com/MuslimAmerica/ 2500.00 RUB 2016-03-11T07:26:06-08:00 2016-03-13T11:26:00-07:00
1734 data/2016-05/P(1)0003830.pdf images/1734.png 205 1203   https://www.facebook.com/Memopolis-450474615151098/ 100.00 RUB 2016-05-12T06:08:29-07:00 2016-05-13T06:08:28-07:00
1736 data/2016-05/P(1)0003832.pdf images/1736.png 196 977   https://www.facebook.com/Memopolis-450474615151098/ 100.00 RUB 2016-05-12T06:06:22-07:00 2016-05-13T06:06:21-07:00
1767 data/2016-05/P(1)0003876.pdf images/1767.png 228 1077   https://www.facebook.com/Memopolis-450474615151098/ 100.00 RUB 2016-05-12T06:06:52-07:00 2016-05-13T06:06:51-07:00
1834 data/2016-05/P(1)0003978.pdf images/1834.png 494 2757   https://www.facebook.com/Memopolis-450474615151098/ 300.00 RUB 2016-05-12T06:08:06-07:00 2016-05-13T06:08:05-07:00

Next page

Advanced export

JSON shape: default, array, object

CSV options:

CREATE TABLE ads (
               id INTEGER  PRIMARY KEY ,
   pdf TEXT  ,
   image TEXT  ,
   clicks INTEGER  ,
   impressions INTEGER  ,
   text TEXT  ,
   url TEXT  ,
   spend_amount TEXT  ,
   spend_currency TEXT  ,
   created TEXT  ,
   ended TEXT  
        )
Powered by Datasette · Query took 16.698ms · Data source: simonw/russian-ira-facebook-ads-datasette