This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
1960 | 1960 | cc5ed | 2502 2502 |
1961 | 1961 | d6ade | 2502 2502 |
1962 | 1962 | 8e7b3 | 2502 2502 |
1963 | 1963 | 313af | 2502 2502 |
1964 | 1964 | ebe26 | 2502 2502 |
1965 | 1965 | a0f55 | 2502 2502 |
1966 | 1966 | 1073c | 2502 2502 |
1967 | 1967 | 371f0 | 2502 2502 |
1968 | 1968 | e6200 | 2502 2502 |
1969 | 1969 | b1201 | 2502 2502 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )