lists

5 rows where following = 0, member_count = 18 and user = 211659408

View and edit SQL

Suggested facets: created_at (date)

id ▼ name uri subscriber_count member_count mode description slug full_name created_at following user
91839852 JSK-Fellows2012 /JSKstanford/lists/jsk-fellows2012 4 18 public John S. Knight Journalism Fellows at Stanford 2012 jsk-fellows2012 @JSKstanford/jsk-fellows2012 2013-06-25T06:59:18+00:00 0 John S. Knight Journalism Fellowships at Stanford 211659408
91840183 JSK-Fellows2010 /JSKstanford/lists/jsk-fellows2010 3 18 public John S. Knight Journalism Fellows at Stanford 2010 jsk-fellows2010 @JSKstanford/jsk-fellows2010 2013-06-25T07:11:35+00:00 0 John S. Knight Journalism Fellowships at Stanford 211659408
93929292 JSK-Fellows2014 /JSKstanford/lists/jsk-fellows2014 6 18 public Knight Fellows 2014 jsk-fellows2014 @JSKstanford/jsk-fellows2014 2013-08-06T19:30:21+00:00 0 John S. Knight Journalism Fellowships at Stanford 211659408
97640575 JSK@ONA13 /JSKstanford/lists/jsk-ona13 2 18 public Knights & friends attending ONA13 jsk-ona13 @JSKstanford/jsk-ona13 2013-10-14T17:23:12+00:00 0 John S. Knight Journalism Fellowships at Stanford 211659408
724758649818632193 JSK-Fellows2017 /JSKstanford/lists/jsk-fellows2017 25 18 public   jsk-fellows2017 @JSKstanford/jsk-fellows2017 2016-04-26T00:35:02+00:00 0 John S. Knight Journalism Fellowships at Stanford 211659408

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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])
);
Powered by Datasette · Query took 26.896ms · About: simonw/jsk-fellows-on-twitter