jsk_fellows (view)

8 rows where fellowship = "jsk-fellows1999" sorted by screen_name

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 ▼
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
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
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
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
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
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
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
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

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 78.206ms · About: simonw/jsk-fellows-on-twitter