This data as json, CSV (advanced)
id | name | uri ▼ | subscriber_count | member_count | mode | description | slug | full_name | created_at | following | user |
---|---|---|---|---|---|---|---|---|---|---|---|
101209398 | JSK-Fellows2005 | /JSKstanford/lists/jsk-fellows2005 | 3 | 10 | public | jsk-fellows2005 | @JSKstanford/jsk-fellows2005 | 2013-12-09T21:56:55+00:00 | 0 | John S. Knight Journalism Fellowships at Stanford 211659408 | |
101176108 | JSK-Fellows2008 | /JSKstanford/lists/jsk-fellows2008 | 3 | 12 | public | jsk-fellows2008 | @JSKstanford/jsk-fellows2008 | 2013-12-09T10:23:20+00:00 | 0 | John S. Knight Journalism Fellowships at Stanford 211659408 |
JSON shape: default, array, newline-delimited, object
CREATE TABLE [lists] ( [id] INTEGER PRIMARY KEY, [name] TEXT, [uri] TEXT, [subscriber_count] INTEGER, [member_count] INTEGER, [mode] TEXT, [description] TEXT, [slug] TEXT, [full_name] TEXT, [created_at] TEXT, [following] INTEGER, [user] INTEGER REFERENCES [users]([id]) );