jsk_fellows (view)

15 rows where fellowship = "jsk-fellows2002"

View and edit SQL

Suggested facets: location, verified, created_at (date)

fellowship

  • jsk-fellows2002 · 15
id name description location url fellowship followers_count created_at verified screen_name
1545741 Elizabeth Osder Media, Entertainment and Tech Executive... maker of real news... iPhone: 40.739487,-74.002266 http://www.osdergroup.com jsk-fellows2002 1133 2007-03-19T19:43:35+00:00 0 osder
14908497 luzmariahelguero Periodista, poeta, activista y deportista de remo. Fiel creyente en la democracia y la responsabilidad ciudadana. Peru   jsk-fellows2002 844 2008-05-26T12:33:00+00:00 0 luzmaria
19152977 Farai Chideya Journalist, Academic, Author, The Episodic Career NYC and Globally http://farai.com/the-episodic-career/ jsk-fellows2002 42786 2009-01-18T18:36:51+00:00 0 farai
19528008 sergey kuznetsov       jsk-fellows2002 789 2009-01-26T10:35:31+00:00 0 skuzn
21165536 james t. areddy jta formerly Shanghai http://www.suburbaphobia.com jsk-fellows2002 2745 2009-02-18T03:38:23+00:00 1 jamestareddy
21783956 gary marx Chicago Tribune investigative reporter. Chicago http://trib.in/2aLM20k jsk-fellows2002 2028 2009-02-24T19:09:20+00:00 0 garyjmarx
28113052 Beth Fouhy Senior editor, politics, NBC News and MSNBC New York, NY http://www.msnbc.com jsk-fellows2002 14457 2009-04-01T14:15:21+00:00 1 bfouhy
31303305 agnes cusack Journalist Melbourne http://www.newaustraliamedia.org jsk-fellows2002 107 2009-04-15T01:57:51+00:00 0 agnescusack
50379519 Sonni Efron President & COO, National Press Foundation. Journalism, foreign policy, democracy, human rights, technology, free expression, opinions my own, RTs not. Washington DC http://www.nationalpress.org jsk-fellows2002 384 2009-06-24T17:55:58+00:00 0 sonniefron
56245064 Stephen Magagnini independent journalist covering ethnic affairs, race relations, immigration, tribal affairs, faith issues and human rights California, USA http://sacbee.com jsk-fellows2002 1130 2009-07-13T01:12:53+00:00 0 SteveMagagnini
80089310 Andrew Lam #Lecturer, #journalist & #Author of Perfume Dreams: Reflections on the #Vietnamese Diaspora, East Eats West: Writing in Two Hemisphere, & Birds of Paradise Lost San Francisco http://www.huffingtonpost.com/andrew-lam/ jsk-fellows2002 1423 2009-10-05T18:19:44+00:00 1 andrewqlam
107116415 Claudia Kalb Independent journalist writing for @NatGeoMag + @NatGeoBooks. Ex- Newsweek. Book: Andy Warhol was a Hoarder: Inside the Minds of History's Great Personalities   http://amzn.to/1jGIb6R jsk-fellows2002 632 2010-01-21T16:05:37+00:00 0 ClaudiaKalb
224059040 Sheila Kaplan Prohibited disclosure NY student contact info/DOB/birthplace/+ w/w out consent via CPO & regs. Now alarmed by @privacyforum directory info findings; work ahead Brooklyn NY https://www.worldprivacyforum.org/2020/04/without-consent/ jsk-fellows2002 1846 2010-12-08T01:43:54+00:00 0 SheilaLKaplan
246041730 Serif Turgut Peace at Home, Peace in the World-Atatürk     jsk-fellows2002 23899 2011-02-02T00:36:54+00:00 0 Ljiljantr
1370927040 Alfredo Molano B 🕊🇨🇴 Comisionado de la Verdad 💚 Sociólogo UN, periodista y cronista 🕯 [1944 - 2019] Cuenta en Homenaje al Maestro. Colombia Rural   jsk-fellows2002 30303 2013-04-22T01:10:33+00:00 0 AlfredoMolanoB

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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;
Powered by Datasette · Query took 63.653ms · About: simonw/jsk-fellows-on-twitter