This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 2001 | 2001 | ec3ac | 1183 1183 |
| 2002 | 2002 | 96bbd | 1183 1183 |
| 2003 | 2003 | 313af | 1183 1183 |
| 2004 | 2004 | ebe26 | 1183 1183 |
| 2005 | 2005 | 1073c | 1183 1183 |
| 2006 | 2006 | 4801f | 1183 1183 |
| 2007 | 2007 | 5e075 | 1183 1183 |
| 2008 | 2008 | 59d75 | 1183 1183 |
| 2009 | 2009 | e6200 | 1183 1183 |
| 2010 | 2010 | b1201 | 1183 1183 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)