jsk_fellows (view)

4 rows where fellowship = "jsk-fellows2011" 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
14985683	Jigar Mehta	Deputy Managing Director of @dohadebates. A new project to inspire solutions to global challenges through civil discourse and debate.	New York, USA	http://dohadebates.com	https://twitter.com/jigarmehta	jsk-fellows2011	3619	2008-06-02T21:53:47+00:00	1	jigarmehta
21901213	Paddy Hirsch	......	.....	http://www.paddyhirsch.com	https://twitter.com/paddyhirsch	jsk-fellows2011	7337	2009-02-25T18:49:06+00:00	1	paddyhirsch
123692265	Sahar Habib Ghazi	Journalist. Trainer. Consultant. Experimenting with fiction and comedy. Mother to 8 year-old koala. @globalvoices @JSKstanford @umich @dawn_news alum	Karachi, Pakistan	https://m.youtube.com/watch?index=220&list=PLMd3iH-TpRVdVhyEwDNT_uf_8Rnpqfadm&v=05ZwgjQjnI0	https://twitter.com/SaharHGhazi	jsk-fellows2011	26408	2010-03-16T23:09:38+00:00	1	SaharHGhazi
214990371	Duncan McCue	Nd’Anishinaabe. Southam Fellow @MasseyCollege @UofT. Journalist-in-residence @RSJnow. Host @CheckupCBC (on leave). Fan of frybread. Creator http://riic.ca	Toronto, Ontario	http://www.cbc.ca/mediacentre/bio/duncan-mccue	https://twitter.com/duncanmccue	jsk-fellows2011	16308	2010-11-12T18:46:52+00:00	1	duncanmccue

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;