This data as json, CSV (advanced)
Suggested facets: ad_id
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5166 | 5166 | 03f36 | 1635 1635 |
| 5277 | 5277 | 03f36 | 1665 1665 |
| 5447 | 5447 | 03f36 | 1672 1672 |
| 5747 | 5747 | 03f36 | 1670 1670 |
| 5822 | 5822 | 03f36 | 1664 1664 |
| 6040 | 6040 | 03f36 | 1634 1634 |
| 6233 | 6233 | 03f36 | 1633 1633 |
| 6421 | 6421 | 03f36 | 1671 1671 |
| 6483 | 6483 | 03f36 | 1663 1663 |
| 6632 | 6632 | 03f36 | 1619 1619 |
| 7268 | 7268 | 03f36 | 1620 1620 |
| 7331 | 7331 | 03f36 | 1618 1618 |
| 7836 | 7836 | 03f36 | 1658 1658 |
| 11646 | 11646 | 03f36 | 1902 1902 |
| 14632 | 14632 | 03f36 | 1919 1919 |
| 31672 | 31672 | 03f36 | 1903 1903 |
| 31676 | 31676 | 03f36 | 1903 1903 |
| 31705 | 31705 | 03f36 | 1628 1628 |
| 31825 | 31825 | 03f36 | 1627 1627 |
| 32028 | 32028 | 03f36 | 1649 1649 |
| 33206 | 33206 | 03f36 | 1624 1624 |
| 33272 | 33272 | 03f36 | 1920 1920 |
| 33285 | 33285 | 03f36 | 1646 1646 |
| 34807 | 34807 | 03f36 | 1915 1915 |
| 35236 | 35236 | 03f36 | 1639 1639 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)