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