This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1980 | 1980 | cc5ed | 2543 2543 |
| 1981 | 1981 | d6ade | 2543 2543 |
| 1982 | 1982 | 8e7b3 | 2543 2543 |
| 1983 | 1983 | d4179 | 2543 2543 |
| 1984 | 1984 | 313af | 2543 2543 |
| 1985 | 1985 | 6e219 | 2543 2543 |
| 1986 | 1986 | aabe0 | 2543 2543 |
| 1987 | 1987 | a0f55 | 2543 2543 |
| 1988 | 1988 | 1073c | 2543 2543 |
| 1989 | 1989 | 371f0 | 2543 2543 |
| 1990 | 1990 | e6200 | 2543 2543 |
| 1991 | 1991 | b1201 | 2543 2543 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)