list_members

10 rows where list = 197719925

descending

Link	list	user
197719925,6181532	NICAR15 197719925	Michael Morisy 6181532
197719925,14130084	NICAR15 197719925	Shazna Nessa 14130084
197719925,16259364	NICAR15 197719925	Michelle Holmes 16259364
197719925,17526481	NICAR15 197719925	Yvonne Leow 17526481
197719925,48068105	NICAR15 197719925	Beth Daley 48068105
197719925,70574113	NICAR15 197719925	Djordje Padejski 70574113
197719925,76971595	NICAR15 197719925	Dickens Olewe 76971595
197719925,119341695	NICAR15 197719925	Cordelia Hebblethwaite 119341695
197719925,264340567	NICAR15 197719925	T. Christian Miller 264340567
197719925,749768262	NICAR15 197719925	Akoto Ofori-Atta 749768262

Advanced export

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])
);