jsk_fellows (view)

2 rows where "created_at" is on date 2009-01-20

Search:

descending

id	name	description	location	url	twitter	fellowship	followers_count	created_at	verified	screen_name
19244373	Tom Davidson	Attempting to invent the future of media without blowing up Beeker in the process. Opinions here are mine, not those of employers past, present or future.	SEVa, Tysons Corner, and I-95	http://tgdavidson.com	https://twitter.com/tgdavidson	jsk-fellows1999	845	2009-01-20T16:47:45+00:00	0	tgdavidson
19257632	Scarin’ Foley 🎃	Black Media Initiative director @CCMNewmarkJ \| priors @jskstanford '20, @cityofdetroit storyteller \| ✊🏽🏳️‍🌈 \| books @belt_publishing \| email 👍🏽, DMs 👎🏽	NY borough/Detroit thorough	http://www.aaronkfoley.com	https://twitter.com/aaronkfoley	jsk-fellows-2020	6808	2009-01-20T21:10:41+00:00	0	aaronkfoley

Advanced export

JSON shape: default, array, newline-delimited

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;