jsk_fellows (view)

5 rows where fellowship = "jsk-fellows2012" 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
5202671	Martyn Williams	North Korea-focused journalist/researcher @NorthKoreaTech @38NorthNK. Non-resident fellow @stimsoncenter. Author @committeeHRNK. Also KJ6SDF.	Washington, DC	http://www.northkoreatech.org	https://twitter.com/martyn_williams	jsk-fellows2012	24339	2007-04-19T08:11:12+00:00	1	martyn_williams
16259364	Michelle Holmes	📍 Free human, looking for adventure	Indiana, USA	https://www.linkedin.com/in/michelle-holmes-924b2b11/	https://twitter.com/mlh_holmes	jsk-fellows2012	4655	2008-09-12T17:26:14+00:00	1	mlh_holmes
39021657	Anita Zielina	Innovation, product, biz models, change in digital/media. 💪 Training innovative leaders @newmarkjschool. Alum @insead @jskstanford @nzz @sternde @derstandardat	New York, USA	https://www.journalism.cuny.edu/executive-ed	https://twitter.com/Zielina	jsk-fellows2012	46520	2009-05-10T09:02:13+00:00	1	Zielina
70574113	Djordje Padejski	@JSKStanford Associate Director, investigative/data journalist, @ICIJorg member, @FOIAMACHINE founder, alum: @CIRonline @OCCRP @CINSerbia	Stanford, CA	http://jsk.stanford.edu	https://twitter.com/djordjepadejski	jsk-fellows2012	2197	2009-09-01T02:29:07+00:00	1	djordjepadejski
264340567	T. Christian Miller	Senior investigative reporter @Propublica. Co-author of http://afalsereport.com. Into journalism that counts. And bacon. Pulitzer winner.	Berkeley, CA	http://www.propublica.org	https://twitter.com/txtianmiller	jsk-fellows2012	8847	2011-03-11T19:00:34+00:00	1	txtianmiller

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;