jsk_fellows (view)

7 rows where fellowship = "jsk-fellows2007" 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: created_at (date)

id	name	description	location	url	twitter	fellowship	followers_count	created_at	verified	screen_name
10794392	Kathleen McCoy	Good old dog Clare passed in May, 2014. Puppy arrived in August. Her name is Kiska.	Anchorage		https://twitter.com/kjmccoy	jsk-fellows2007	314	2007-12-02T21:45:12+00:00	0	kjmccoy
18197783	Leslie Casimir	Freelance journalist	San Francisco		https://twitter.com/lcasimir	jsk-fellows2007	48	2008-12-17T19:54:56+00:00	0	lcasimir
20932059	Imtiaz Ali		Peshawar -- Washington D.C		https://twitter.com/imtiaz999	jsk-fellows2007	681	2009-02-15T19:51:32+00:00	0	imtiaz999
48140747	Patricia Mercado S.	Mujer, madre, periodista. En la búsqueda constante... Iniciando proyectos y caminos propios. Directora de @Conectmigrante	Al lado de Carlos Miguel	http://www.conexionmigrante.com	https://twitter.com/Patmercado	jsk-fellows2007	4606	2009-06-17T22:21:43+00:00	0	Patmercado
55273455	Christianne Gonzalez	Online media consultant	Silicon Valley	http://www.brasilnewscom.com	https://twitter.com/brasilnewscom	jsk-fellows2007	66	2009-07-09T15:52:45+00:00	0	brasilnewscom
197544399	Pete McBride	Photographer, Writer, Filmmaker. Advocate of Wild Places. Lover of mountains, glassy waves, and spicy living.	Colorado - or road	http://www.petemcbride.com	https://twitter.com/photogpedro	jsk-fellows2007	2706	2010-10-01T19:53:37+00:00	0	photogpedro
341118458	Eric Schmitt	Senior writer, The New York Times (http://nyti.ms/1awYH4E) covering terrorism and national security issues. Co-author, Counterstrike	Washington, D.C.	http://www.counterstrikethebook.com	https://twitter.com/EricSchmittNYT	jsk-fellows2007	44038	2011-07-23T20:53:07+00:00	0	EricSchmittNYT

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;