This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
21433 | 21433 | 04182 | 2906 2906 |
21777 | 21777 | 04182 | 2905 2905 |
25065 | 25065 | 04182 | 2931 2931 |
25408 | 25408 | 04182 | 2930 2930 |
29591 | 29591 | 04182 | 2966 2966 |
29694 | 29694 | 04182 | 2967 2967 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )