This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
239 | 239 | 20711 | 3200 3200 |
629 | 629 | 20711 | 3201 3201 |
5615 | 5615 | 20711 | 2813 2813 |
6189 | 6189 | 20711 | 2812 2812 |
6656 | 6656 | 20711 | 2808 2808 |
6715 | 6715 | 20711 | 2810 2810 |
17575 | 17575 | 20711 | 3216 3216 |
17658 | 17658 | 20711 | 3214 3214 |
18080 | 18080 | 20711 | 3215 3215 |
28487 | 28487 | 20711 | 3204 3204 |
28637 | 28637 | 20711 | 3205 3205 |
28662 | 28662 | 20711 | 3203 3203 |
29375 | 29375 | 20711 | 3202 3202 |
29596 | 29596 | 20711 | 3206 3206 |
29629 | 29629 | 20711 | 3213 3213 |
29752 | 29752 | 20711 | 3212 3212 |
29801 | 29801 | 20711 | 3208 3208 |
29930 | 29930 | 20711 | 3210 3210 |
30163 | 30163 | 20711 | 3207 3207 |
30354 | 30354 | 20711 | 3211 3211 |
30366 | 30366 | 20711 | 3209 3209 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )