This data as json, CSV (advanced)
Suggested facets: description, location, created_at (date)
fellowship
id | name | description | location | url | fellowship | followers_count | created_at | verified | screen_name | |
---|---|---|---|---|---|---|---|---|---|---|
7068802 | Marie C Beuth | deputy editor-in-chief @lopinion_fr • founding editor @businessinsider France • founder @getnod • 2013 fellow @jskstanford • floor rebel | Paris, Ile-de-France | https://tinyurl.com/FeedbacklOpinion | https://twitter.com/M_C_B | jsk-fellows2013 | 8697 | 2007-06-25T13:36:18+00:00 | 0 | M_C_B |
8956962 | Kirk Caraway | Co-founder Megafone/NowAds, 2012-13 John S. Knight Fellow at Stanford University, online news entrepreneur | http://GetMegafone.biz | http://NowAds.biz | https://twitter.com/kirkcaraway | jsk-fellows2013 | 270 | 2007-09-18T18:11:50+00:00 | 0 | kirkcaraway |
12956682 | David Sarno | Founder of Lighthaus (@lighthausinc): Virtual reality science education. Stanford Knight Fellow '13. @latimes tech & business writer 2006-2013 | Long Beach, CA | http://lighthaus.us | https://twitter.com/dsarno | jsk-fellows2013 | 7208 | 2008-02-01T19:54:32+00:00 | 0 | dsarno |
16613227 | nunovargas | Media, Product, Digital Strategy, Design Thinking & Tech. Ever in love with futebol, food and my family. Knight Fellow @Stanford'13 & invented @getdatastory | Latin America + Porto,Portugal | http://www.linkedin.com/in/vargasnuno/ | https://twitter.com/nunovargas | jsk-fellows2013 | 2277 | 2008-10-06T12:54:28+00:00 | 0 | nunovargas |
20951229 | Mary Aviles | But first, the facts. | Bay Area | https://twitter.com/Avilesm | jsk-fellows2013 | 982 | 2009-02-16T00:45:08+00:00 | 0 | Avilesm | |
29932001 | Barbara E. Allen | Stanford! | https://twitter.com/BA1245 | jsk-fellows2013 | 269 | 2009-04-09T05:47:18+00:00 | 0 | BA1245 | ||
48193439 | drigarcia | Journalism, Creativity, Innovation. Teaching Fellow at Google News Initiative. Co-founder of Orbital Midia. @jskstanford 12'/13' | São Paulo, Brasil | http://about.me/adrianagarciamartinez | https://twitter.com/drigarcia | jsk-fellows2013 | 511 | 2009-06-18T01:20:51+00:00 | 0 | drigarcia |
67942338 | Musikilu Mojeed | Editor-in-Chief/Chief Operating Officer -- @premiumtimesng; Co-Founder -- @ptcij; founder - @TheImoleProject; founder, @naijapolizwatch; member, @ICIJorg | Abuja | http://www.premiumtimesng.com | https://twitter.com/Musikilu | jsk-fellows2013 | 2375 | 2009-08-22T17:53:27+00:00 | 0 | Musikilu |
284593852 | William McNulty | Santa Cruz CA | https://twitter.com/wemcn | jsk-fellows2013 | 469 | 2011-04-19T15:40:58+00:00 | 0 | wemcn | ||
588357987 | mariam semaan | #Knight #Fellow 2012/13 #Stanford #University #DesignThinking#Media expert #Designer of #Experiences #vintage clothes and accessories #collector | https://twitter.com/semaanmariam | jsk-fellows2013 | 207 | 2012-05-23T13:11:28+00:00 | 0 | semaanmariam | ||
1236306422 | María Lilly Delgado | Periodista.-Journalist. Stanford Knight Fellow 2013. Periodista-Freelance TV News Reporter and Producer @ Nicaragua. Tweets are on my own. | https://www.univision.com/temas/nicaragua | https://twitter.com/MLillyDelgado | jsk-fellows2013 | 11163 | 2013-03-02T20:33:19+00:00 | 0 | MLillyDelgado | |
1604288388 | Samaruddin Stewart | Countering Disinformation @StateDept | Priors: @Journalism_360 & @ONA, Media + Tech @spj_tweets with @GoogleNewsInit, @knightfdn Grantee, @JSKStanford Fellow.. | SF Bay Area | http://www.linkedin.com/in/samaruddin/ | https://twitter.com/samsends | jsk-fellows2013 | 1222 | 2013-07-18T20:50:38+00:00 | 0 | samsends |
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;