lists

5 rows where following = 0, subscriber_count = 4 and user = 211659408

View and edit SQL

Suggested facets: description, 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
92193784 JSK-Fellows2013 /JSKstanford/lists/jsk-fellows2013 4 19 public Knight Fellows 2013 jsk-fellows2013 @JSKstanford/jsk-fellows2013 2013-07-01T20:10:39+00:00 0 John S. Knight Journalism Fellowships at Stanford 211659408
101205153 JSK-Fellows2006 /JSKstanford/lists/jsk-fellows2006 4 11 public   jsk-fellows2006 @JSKstanford/jsk-fellows2006 2013-12-09T20:20:34+00:00 0 John S. Knight Journalism Fellowships at Stanford 211659408
101238694 JSK-Fellows2004 /JSKstanford/lists/jsk-fellows2004 4 12 public   jsk-fellows2004 @JSKstanford/jsk-fellows2004 2013-12-10T10:30:43+00:00 0 John S. Knight Journalism Fellowships at Stanford 211659408
219853736 JSKONA15 /JSKstanford/lists/jskona15 4 37 public Fellows, staff and alumni attending conference in LA jskona15 @JSKstanford/jskona15 2015-09-11T20:00:07+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 27.514ms · About: simonw/jsk-fellows-on-twitter