jsk_fellows (view)

8 rows where fellowship = "jsk-fellows1999"

View and edit SQL

Suggested facets: verified, created_at (date)


  • jsk-fellows1999 · 8
id name description location url fellowship followers_count created_at verified screen_name
19169884 Karen Breslau Relapsing journalist, p/t strategist, and f/t citizen Oakland, CA   jsk-fellows1999 247 2009-01-19T03:29:33+00:00 0 kbreslau
19244373 Tom Davidson Attempting to invent the future of media without blowing up Beeker in the process. Opinions here are mine, not those of employers past, present or future. SEVa, Tysons Corner, and I-95 http://tgdavidson.com jsk-fellows1999 845 2009-01-20T16:47:45+00:00 0 tgdavidson
101610491 Joan Úbeda Factual TV and documentary producer Barcelona http://blogerocasional.blogspot.com.es jsk-fellows1999 1486 2010-01-04T00:22:02+00:00 0 joanubeda
234926815 Stephen Proctor Managing Editor, Houston Chronicle, golfer, golf historian Houston, TX http://chron.com jsk-fellows1999 590 2011-01-06T22:44:27+00:00 0 stephenrproctor
262793826 Joseph Neff Investigative reporter at The Marshall Project Durham, NC http://themarshallproject.org jsk-fellows1999 2247 2011-03-08T19:38:26+00:00 1 josephcneff
370797042 Gerald Carbone Published books on Nathanael Greene and George Washington; former Knight Fellow @ Stanford; master's degree in Public Humanities, Brown Brown University http://gedcarbone.com jsk-fellows1999 104 2011-09-09T17:02:51+00:00 0 GedCarbone
453900651 Newton Kanhema Journo | Father | Serving Humanity @UNICNAIROBI | Views are mine | With low handicap🏌🏾 | RTs not Endorsements Nairobi, Kenya http://www.unicnairobi.org jsk-fellows1999 1430 2012-01-03T12:04:25+00:00 0 kanhema
537162951 Linda Gradstein Bureau Chief, The Media Line News Agency Jerusalem http://www.lindagradstein.com jsk-fellows1999 167 2012-03-26T09:40:10+00:00 0 lindagradstein

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW jsk_fellows AS 
        'https://twitter.com/' || users.screen_name as twitter,
        group_concat(lists.slug) as fellowship,
    from users
        join list_members
            on list_members.user = users.id
        join lists
            on list_members.list = lists.id
        lists.slug like 'jsk-fellows%'
        and lists.slug not like '%projects'
    group by users.id;
Powered by Datasette · Query took 86.589ms · About: simonw/jsk-fellows-on-twitter