This data as json, CSV (advanced)
Link | list | user |
---|---|---|
29527592,119341695 | JSK Alumni Network 29527592 | Cordelia Hebblethwaite 119341695 |
76545315,119341695 | JSK ONA14 76545315 | Cordelia Hebblethwaite 119341695 |
111132650,119341695 | JSK-Fellows2015 111132650 | Cordelia Hebblethwaite 119341695 |
197719925,119341695 | NICAR15 197719925 | Cordelia Hebblethwaite 119341695 |
201462259,119341695 | Techraking drones 201462259 | Cordelia Hebblethwaite 119341695 |
JSON shape: default, array, newline-delimited, object
CREATE TABLE [list_members] ( [list] INTEGER REFERENCES [lists]([id]), [user] INTEGER REFERENCES [users]([id]), PRIMARY KEY ([list], [user]) );