jsk_fellows (view)

6 rows where fellowship = "jsk-fellows2009" and verified = 1

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: created_at (date)

id	name	description	location	url	twitter	fellowship	followers_count	created_at	verified	screen_name
8441632	Burt Herman	Entrepreneurial journalist finding meaning in the noise. Now: Product @CondeNast. Always: @HacksHackers. Previous: @LenfestInst, Co-founder @Storify, @AP	New York, NY	http://burtherman.com	https://twitter.com/burtherman	jsk-fellows2009	9235	2007-08-26T14:23:45+00:00	1	burtherman
14124402	Pedro Doria 🇧🇷😷	🗞 @canalmeio. 📚 Escrevo livros de história. 🎙 Falo sobre política. ⚽️ @flamengo 🏈 @stanford 📞 http://bit.ly/2HpPzVx RTs não indicam concordância	Rio de Janeiro	http://www.pedrodoria.com.br/	https://twitter.com/pedrodoria	jsk-fellows2009	115197	2008-03-11T15:22:17+00:00	1	pedrodoria
14478614	Jeff Elder	Cybersecurity reporter for Business Insider. DMs open for news tips, or email jelder@businessinsider dot com. Signal 4157999085	San Francisco, CA	https://www.businessinsider.com/author/jeff-elder	https://twitter.com/JeffElder	jsk-fellows2009	87727	2008-04-22T18:54:22+00:00	1	JeffElder
16622367	Antonio Ruiz-Camacho	Not there yet | BAREFOOT DOGS | Writing @nytimes @TexasMonthly @salon @TexasHighways et al | @JSKstanford @ut_english alum	Austin	http://antonioruizcamacho.com	https://twitter.com/aruizcamacho	jsk-fellows2009	1454	2008-10-06T23:33:29+00:00	1	aruizcamacho
16679681	Stephanie Banchero	Stephanie Banchero. Education Program Director at @JoyceFdn Former Wall Street Journal education reporter; Utah Jazz fan; shameless lover of corndogs & DWTS.	Chicago, IL	http://www.joycefdn.org	https://twitter.com/sbanchero	jsk-fellows2009	9243	2008-10-10T05:05:16+00:00	1	sbanchero
180871553	Michael Rezendes	Global investigations @AP. Formerly @GlobeSpotlight.		http://ap.org	https://twitter.com/MikeRezendes	jsk-fellows2009	14387	2010-08-20T18:17:18+00:00	1	MikeRezendes

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;