jsk_fellows (view)

8 rows where fellowship = "jsk-fellows1999"

View and edit SQL

Suggested facets: verified, created_at (date)

fellowship

  • 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 241 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 849 2009-01-20T16:47:45+00:00 0 tgdavidson
101610491 Joan Úbeda Confined Factual TV and documentary producer at http://www.mediapro.tv Barcelona http://blogerocasional.blogspot.com.es jsk-fellows1999 1468 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 592 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 2147 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 102 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 1356 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 159 2012-03-26T09:40:10+00:00 0 lindagradstein

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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