jsk_fellows (view)

29 rows where description = ""

✎ View and edit SQL

This data as json, CSV (advanced)

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

description ✖

id name description location url fellowship followers_count created_at verified screen_name
14766481 RODRIGOCARPIO   Fort Lauderdale, FL, USA http://www.zajorynproductions.com jsk-fellows1997 60 2008-05-13T23:45:17+00:00 0 zajoryn
15607854 MarshaMcFadden   ÜT: 21.339917,-157.925875   jsk-fellows1995 228 2008-07-26T04:50:00+00:00 0 marshamcfadden
15900236 Harriet A.Washington   New York City, Las Vegas, NV   jsk-fellows1998 5650 2008-08-19T03:44:42+00:00 0 haw95
17787248 Richard Gonzales NPR       jsk-fellows1995 228 2008-12-01T19:55:08+00:00 0 RichardGonzalesNPR
19528008 sergey kuznetsov       jsk-fellows2002 787 2009-01-26T10:35:31+00:00 0 skuzn
20632365 barbara roessner       jsk-fellows2004 20 2009-02-11T21:54:11+00:00 0 broessner
20846696 Tomasz Deptula       jsk-fellows2005 15 2009-02-14T13:27:41+00:00 0 tomekdep
20932059 Imtiaz Ali   Peshawar -- Washington D.C   jsk-fellows2007 681 2009-02-15T19:51:32+00:00 0 imtiaz999
23757441 Hugo Rupert   stanford U   jsk-fellows2011 90 2009-03-11T12:50:26+00:00 0 hugorupert
28293072 who   Kowloon City District   jsk-fellows1995 6203 2009-04-02T06:12:42+00:00 0 who_blgw2017
29932001 Barbara E. Allen   Stanford!   jsk-fellows2013 269 2009-04-09T05:47:18+00:00 0 BA1245
30117765 Marcelo Rubens Paiva     http://blog.estadao.com.br/blog/marcelorubenspaiva/ jsk-fellows1995 829946 2009-04-10T01:14:01+00:00 1 marcelorubens
40381878 Kim Komenich   Mill Valley, CA http://kimkom.com jsk-fellows1994 107 2009-05-16T01:35:04+00:00 0 kimkom
41007644 Matthew B. Stannard       jsk-fellows2008 16 2009-05-19T00:11:54+00:00 0 MBStannard
66732477 Bonnie Jo Mount       jsk-fellows2003 118 2009-08-18T16:58:07+00:00 0 bonjomo
71545361 Paul Radu       jsk-fellows2010 69 2009-09-04T14:18:36+00:00 0 sforaru
86097492 jo-ann armao       jsk-fellows2006 178 2009-10-29T15:52:11+00:00 0 armaoj
115359136 Andrew Losowsky   New York, NY   jsk-fellows2014 8023 2010-02-18T12:03:16+00:00 1 losowsky
144361718 Mainul Khan       jsk-fellows2003 98 2010-05-16T02:44:34+00:00 0 mainulislamkhan
157531033 watson ,meng       jsk-fellows2009 38 2010-06-20T03:08:34+00:00 0 watsonmeng
164206121 Akaki Gogichaishvili       jsk-fellows2005 174 2010-07-08T08:49:13+00:00 0 BizCourier
284593852 William McNulty   Santa Cruz CA   jsk-fellows2013 469 2011-04-19T15:40:58+00:00 0 wemcn
365973699 Azmat Abbas   Islamabad   jsk-fellows2004 73 2011-09-01T10:34:49+00:00 0 Azmat_Abbas
386183180 Girma T Fantaye       jsk-fellows2012 1229 2011-10-06T20:15:31+00:00 0 Girmatf
1003951466 Slawomir Zagorski       jsk-fellows1997 32 2012-12-11T12:35:36+00:00 0 SlawomirZagorsk
1522716182 Sarah T. Williams       jsk-fellows2000 32 2013-06-16T17:16:34+00:00 0 sarahtwilliams1
1892710843 Rita Neubauer       jsk-fellows2000 24 2013-09-22T06:12:57+00:00 0 ritaneubauer
2802357499 Heather Dewar       jsk-fellows1993 20 2014-09-10T19:29:28+00:00 0 heatherjodewar
750919846330793984 YooHee Hong   San Francisco, CA http://ww.linkedin.com/in/yoohee-hong-6136b856 jsk-fellows2017 72 2016-07-07T05:10:17+00:00 0 YooHeeHong0916

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