This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 2345 | 2345 | 36203 | 1211 1211 |
| 2584 | 2584 | 36203 | 1205 1205 |
| 2650 | 2650 | 36203 | 1147 1147 |
| 2947 | 2947 | 36203 | 1193 1193 |
| 2959 | 2959 | 36203 | 1199 1199 |
| 8796 | 8796 | 36203 | 1215 1215 |
| 8862 | 8862 | 36203 | 1218 1218 |
| 8995 | 8995 | 36203 | 1209 1209 |
| 9012 | 9012 | 36203 | 1217 1217 |
| 9178 | 9178 | 36203 | 1197 1197 |
| 9203 | 9203 | 36203 | 1203 1203 |
| 9463 | 9463 | 36203 | 1151 1151 |
| 35468 | 35468 | 36203 | 1213 1213 |
| 35496 | 35496 | 36203 | 1207 1207 |
| 35510 | 35510 | 36203 | 1214 1214 |
| 35536 | 35536 | 36203 | 1206 1206 |
| 35557 | 35557 | 36203 | 1212 1212 |
| 35572 | 35572 | 36203 | 1208 1208 |
| 35673 | 35673 | 36203 | 1202 1202 |
| 35701 | 35701 | 36203 | 1196 1196 |
| 35744 | 35744 | 36203 | 1148 1148 |
| 35812 | 35812 | 36203 | 1201 1201 |
| 35869 | 35869 | 36203 | 1150 1150 |
| 35891 | 35891 | 36203 | 1195 1195 |
| 35908 | 35908 | 36203 | 1194 1194 |
| 35933 | 35933 | 36203 | 1200 1200 |
| 35948 | 35948 | 36203 | 1149 1149 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)