jsk_fellows (view)

12 rows where fellowship = "jsk-fellows2004"

View and edit SQL

Suggested facets: description, location, verified, created_at (date)

fellowship

  • jsk-fellows2004 · 12
id name description location url fellowship followers_count created_at verified screen_name
14849874 Matt Crenson Opinions are my own. Facts belong to no one. Washington, DC   jsk-fellows2004 190 2008-05-20T23:21:58+00:00 0 mmcrenson
16480721 Lynne Varner College isn't about preparing for a job, it's about preparing for a fully realized life. Associate Vice Chancellor, Washington State University Everett. Seattle   jsk-fellows2004 1459 2008-09-27T02:34:03+00:00 0 lkvarner
20632365 barbara roessner       jsk-fellows2004 20 2009-02-11T21:54:11+00:00 0 broessner
21022307 Barbara Brotman Writer, hiker, former Chicago Tribune columnist, current freelancer. I love swimming, hug trees and wish Chicago had mountains. Chicago, Ill. http://archives.chicagotribune.com/writers/barbara-brotman jsk-fellows2004 1003 2009-02-16T20:19:59+00:00 0 BarbaraBrotman
21404432 Eric Weiner NYT bestselling author. Wanderer. @NPR alum. My new book, THE SOCRATES EXPRESS, is out now! Washington, DC http://www.ericweinerbooks.com jsk-fellows2004 6595 2009-02-20T15:21:40+00:00 1 Eric_Weiner
49554368 Kay Johnson Reuters bureau chief for Thailand, Cambodia and Laos. RT = not endorsements, sometimes bookmarks. Asia   jsk-fellows2004 2357 2009-06-22T06:13:15+00:00 1 kayatrtrz
51893064 Pablo González Journalist. Former Bloomberg, Debtwire, 3 Puntos, Perfil, Pagina/12, Jornal do Brasil. Stanford Knight Fellow. UNC. Cordoba, Buenos Aires, Palo Alto, Sao Paulo. South America   jsk-fellows2004 2662 2009-06-29T00:16:32+00:00 1 Pablo_Rosendo
133891833 Mika Mäkeläinen Foreign news journalist at Finland's @yleuutiset. Ex-China & USA. @JSKstanford 2004. RT/like=FYI. Author of Kimlandia. http://facebook.com/Mikareport Finland http://yle.fi/uutiset/ jsk-fellows2004 5460 2010-04-16T22:49:20+00:00 1 Mikareport
197940788 Kelly Scott Writer, editor, political obsessive, arts & culture enthusiast and @Dodgers fan. Proud mom of @DevinMitchell, @sc_mitchell. Chicago, IL   jsk-fellows2004 1412 2010-10-02T22:13:14+00:00 0 kscottAtLarge
253711352 Torsten Kjellstrand Torsten is a staff photographer at The Oregonian, where he makes photographs and videos. He likes snow more than rain. Portland, Oregon, USA http://oregonlive.com jsk-fellows2004 104 2011-02-17T20:26:16+00:00 0 otorsten
365973699 Azmat Abbas   Islamabad   jsk-fellows2004 75 2011-09-01T10:34:49+00:00 0 Azmat_Abbas
2149361988 Sara Catania Now: Solutions Journalism Network + USC Annenberg • Always: JSK Stanford 🍝 Catania rhymes with lasagna Headshot by Richa Syal   http://www.saracatania.com jsk-fellows2004 1846 2013-10-22T16:47:07+00:00 0 Catanify

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