jsk_fellows (view)

10 rows where fellowship = "jsk-fellows2016" and verified = 0

Search:

- remove filter - id name description location url twitter fellowship followers_count created_at verified screen_name

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - id name description location url twitter fellowship followers_count created_at verified screen_name

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - id name description location url twitter fellowship followers_count created_at verified screen_name

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by id Sort by name Sort by description Sort by location Sort by url Sort by twitter Sort by fellowship Sort by followers_count Sort by created_at Sort by verified Sort by screen_name

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location, created_at (date)

id	name	description	location	url	twitter	fellowship	followers_count	created_at	verified	screen_name
14381600	Tracie Powell	Connector. Change maker. Founder. Passionate about all things digital & media. Program Officer, Borealis Philanthropy & 2016 JSK Fellow. RT ≠ endorsement	Washington, DC	http://www.alldigitocracy.org	https://twitter.com/TMPowell	jsk-fellows2016	3059	2008-04-14T05:29:35+00:00	0	TMPowell
22167981	Craig Timberg	Longtime WashPost reporter, editor and author now covering technology	Washington, DC	https://www.washingtonpost.com/people/craig-timberg/?utm_term=.62c2bd0c02da	https://twitter.com/craigtimberg	jsk-fellows2016	4923	2009-02-27T18:02:48+00:00	0	craigtimberg
25603541	Jacqueline Park	Journalist/Editor, social entrepreneur. Publishes The Story APAC; Alum: #SpliceBeta @walkleys @JSK Stanford @IFJ @IFEX +Founding ed Walkley Mag	Sydney, Eora Nation		https://twitter.com/jacquipark	jsk-fellows2016	1256	2009-03-20T23:58:42+00:00	0	jacquipark
85653836	Nathalie Alvaray	Knowmad | @ImpactHubMAD | @jskfellow '16 @Stanford | antes en @uninoticias @runrunesweb @talcualdigital & Cadena Capriles |	United States		https://twitter.com/NathaHari	jsk-fellows2016	2486	2009-10-27T20:26:20+00:00	0	NathaHari
112265447	Kristen "you're on mute" Muller	Chief Content Officer @KPCC @LAist. Fan of the First Amendment & Arnold Palmers. http://kpcc.org & http://laist.com	Pasadena, CA	http://www.kpcc.org	https://twitter.com/KrisMul	jsk-fellows2016	2913	2010-02-07T21:17:58+00:00	0	KrisMul
225505935	Subbu	Despite all the jargon you hear, democratizing journalism and social media are part of the same journey. @jmethics. Book chapter: https://bit.ly/3m1ikb7	SF Bay Area, CA	https://www.scu.edu/ethics/about-the-center/people/subramaniam-vincent/	https://twitter.com/subbuvincent	jsk-fellows2016	1537	2010-12-11T18:51:16+00:00	0	subbuvincent
240349448	Sarah Alvarez	Journalist and founder/editor of Outlier Media. Profile photo by MacArthur Genius/Chicana extraordinaire Maria Varela, more:http://bit.ly/2RqcqAs	Detroit, MI	http://outliermedia.org	https://twitter.com/sarahalvarezMI	jsk-fellows2016	2658	2011-01-19T18:33:03+00:00	0	sarahalvarezMI
241747214	matilde suescun	Woman - Latina - Sin pelos en la lengua - Bloguera - Spanglish - JSK Knight Fellow @Stanford	Miami, FL	http://mujerconojosabiertos.com/	https://twitter.com/matisu19	jsk-fellows2016	341	2011-01-23T01:47:54+00:00	0	matisu19
382121824	Astrid Maier	Homeoffice Editor in Chief @XINGNews inspiring people to lead the work life they want / ex @join_ada / tech & companies editor @wiwo / @JSKstanford Fellow '16	Hamburg, Deutschland	http://dverse.media	https://twitter.com/MaierAstrid	jsk-fellows2016	3111	2011-09-29T14:36:21+00:00	0	MaierAstrid
2199658388	Oleksandr Akymenko	Entrepreneur, design-thinking consultant, @Stanford @JSKstanford Fellow 2015/16. Publisher at @Platfor_ma. Ex-head of investigative department at Forbes Ukraine	Kyiv, Ukraine	http://platfor.ma/	https://twitter.com/akymenko_o	jsk-fellows2016	804	2013-11-17T14:58:16+00:00	0	akymenko_o

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;