users

13 rows where profile_text_color = 666666

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location, listed_count, geo_enabled, verified, profile_background_color, profile_background_image_url, profile_background_image_url_https, profile_background_tile, profile_link_color, profile_sidebar_border_color, profile_sidebar_fill_color, profile_use_background_image, has_extended_profile, following, created_at (date)

id ▼ screen_name name description location url protected followers_count friends_count listed_count created_at favourites_count utc_offset time_zone geo_enabled verified statuses_count lang contributors_enabled is_translator is_translation_enabled profile_background_color profile_background_image_url profile_background_image_url_https profile_background_tile profile_image_url profile_image_url_https profile_banner_url profile_link_color profile_sidebar_border_color profile_sidebar_fill_color profile_text_color profile_use_background_image has_extended_profile default_profile default_profile_image following notifications translator_type
2241921 pc Pamela Chen 🙋🏻‍♀️🤦🏻‍♀️ Camera & Photos @apple, curious at heart. 2020 @JSKStanford-@StanfordHAI Fellow, board @magnumfnd, alumna @instagram @natgeo @opensociety ☁️ Stanford, CA https://stanford.io/2O6sojp 0 13155 1225 258 2007-03-26T02:40:05+00:00 2742     1 0 1116   0 0 0 FFFFFF http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 1 http://pbs.twimg.com/profile_images/991738846869053440/O796MxpE_normal.jpg https://pbs.twimg.com/profile_images/991738846869053440/O796MxpE_normal.jpg https://pbs.twimg.com/profile_banners/2241921/1403462671 3865A3 FFFFFF EBEBEB 666666 1 0 0 0 1 0 none
8441632 burtherman Burt Herman Entrepreneurial journalist finding meaning in the noise. Now: Product @CondeNast. Always: @HacksHackers. Previous: @LenfestInst, Co-founder @Storify, @AP New York, NY http://burtherman.com 0 9235 1964 971 2007-08-26T14:23:45+00:00 1951     1 1 6762   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/67612383/XWS147_normal.jpg https://pbs.twimg.com/profile_images/67612383/XWS147_normal.jpg https://pbs.twimg.com/profile_banners/8441632/1537899498 2FC2EF 181A1E 252429 666666 1 1 0 0 0 0 none
9078442 agventcnn Greg Agvent Senior Director CNN Aerial Imagery &. Reporting Atlanta, USA   0 2192 292 57 2007-09-24T21:20:08+00:00 17     1 0 300   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/652194249329541120/IiWdURMo_normal.jpg https://pbs.twimg.com/profile_images/652194249329541120/IiWdURMo_normal.jpg   2FC2EF 181A1E 252429 666666 1 0 0 0 0 0 none
14766481 zajoryn RODRIGOCARPIO   Fort Lauderdale, FL, USA http://www.zajorynproductions.com 0 60 425 3 2008-05-13T23:45:17+00:00 16     1 0 4558   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/1012195814721118208/fL2SC42w_normal.jpg https://pbs.twimg.com/profile_images/1012195814721118208/fL2SC42w_normal.jpg https://pbs.twimg.com/profile_banners/14766481/1530161449 1B95E0 181A1E 252429 666666 1 1 0 0 0 0 none
17714681 filloux Frederic Filloux Entrepreneur (http://Deepnews.ai), editor of http://mondaynote.com, associate journalism professor at Sciences Po J-school in Paris. Paris, France https://mondaynote.com 0 9008 836 601 2008-11-28T18:03:11+00:00 400     0 0 2519   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/651008959625699328/k9xO_jl9_normal.jpg https://pbs.twimg.com/profile_images/651008959625699328/k9xO_jl9_normal.jpg https://pbs.twimg.com/profile_banners/17714681/1444047489 2FC2EF 181A1E 252429 666666 1 0 0 0 0 0 none
57621331 watchup Watchup Unleash the power of video journalism. On iOS, Android, Amazon Fire & Wii U Menlo Park, California http://watchup.com 0 2329 443 133 2009-07-17T11:43:04+00:00 1059     1 0 6634   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/452568953965903872/P4aLaoqW_normal.png https://pbs.twimg.com/profile_images/452568953965903872/P4aLaoqW_normal.png https://pbs.twimg.com/profile_banners/57621331/1462470271 2FC2EF 181A1E 252429 666666 1 0 0 0 0 0 none
84472525 stanfordstory Stanford Storytelling Project An arts program at Stanford University exploring the power & craft of great, oral storytelling, traditional or modern, from Lakota tales to Radiolab. Stanford, CA http://storytelling.stanford.edu 0 5578 707 222 2009-10-23T01:20:40+00:00 1225     1 0 1884   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 1 http://pbs.twimg.com/profile_images/1263170445685035009/KDT7AOs6_normal.jpg https://pbs.twimg.com/profile_images/1263170445685035009/KDT7AOs6_normal.jpg https://pbs.twimg.com/profile_banners/84472525/1589924007 2FC2EF 181A1E 252429 666666 1 0 0 0 0 0 none
86776199 jmckellogg JulieAnn McKellogg Making texts fetch @joinsubtext | Builder and storyteller @JSKstanford @pactio_us @mcclatchy @washingtonpost @voanews @UNCHussman San Francisco, CA http://joinsubtext.com 0 1576 946 73 2009-11-01T18:44:39+00:00 10280     1 0 5563   0 0 0 DBE9ED http://abs.twimg.com/images/themes/theme17/bg.gif https://abs.twimg.com/images/themes/theme17/bg.gif 0 http://pbs.twimg.com/profile_images/1027711718661677056/0V5Kgmq__normal.jpg https://pbs.twimg.com/profile_images/1027711718661677056/0V5Kgmq__normal.jpg https://pbs.twimg.com/profile_banners/86776199/1448332496 91D2FA FFFFFF 252429 666666 0 0 0 0 1 0 none
103761767 Skellor Russell Skelton Director RMIT ABC Fact Check. Views my own, links and retweets not. Melbourne, Victoria   0 3301 1197 133 2010-01-11T04:57:36+00:00 1019     1 0 15151   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/378800000042613328/086cee2400eef0b85b6ada6e1862dd38_normal.jpeg https://pbs.twimg.com/profile_images/378800000042613328/086cee2400eef0b85b6ada6e1862dd38_normal.jpeg   2FC2EF 181A1E 252429 666666 1 0 0 0 0 0 none
200120015 katywnewton Katy Newton UX Researcher + Developer, Emergent Media, Stanford http://d.school Media Experiments Resident, IDEONY, @JSKStanford Fellow @latimes Brooklyn, San Francisco http://katynewton.com 0 793 469 57 2010-10-08T14:02:56+00:00 2065     1 0 1246   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/1218264364148514816/t3NOeQQn_normal.jpg https://pbs.twimg.com/profile_images/1218264364148514816/t3NOeQQn_normal.jpg https://pbs.twimg.com/profile_banners/200120015/1485380832 030303 181A1E 252429 666666 1 0 0 0 0 0 none
607245696 BrownInstitute The Brown Institute The David and Helen Gurley Brown Institute for Media Innovation. A joint endeavor of Columbia and Stanford Universities for shaping the future of media. New York City and Stanford http://browninstitute.org 0 3827 483 162 2012-06-13T12:21:42+00:00 309     1 0 2186   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/530452918873231360/w4E2GTrg_normal.jpeg https://pbs.twimg.com/profile_images/530452918873231360/w4E2GTrg_normal.jpeg https://pbs.twimg.com/profile_banners/607245696/1426524703 2FC2EF 181A1E 252429 666666 1 0 0 0 0 0 none
749768262 KO_616 Akoto Ofori-Atta managing editor @teamtrace. @jskstanford 2014-2015/for life. BK/NJ/Ghana. Brooklyn, NY   0 3289 2237 111 2012-08-10T17:50:25+00:00 5271     1 1 3632   0 0 0 1A1B1F http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/433027900372439040/juWad5F3_normal.jpeg https://pbs.twimg.com/profile_images/433027900372439040/juWad5F3_normal.jpeg https://pbs.twimg.com/profile_banners/749768262/1418086499 2FC2EF 181A1E 252429 666666 1 0 0 0 0 0 none
1053480468 iGregoryJohnson Gregory Johnson modernizing tech for cities | http://CodeforSouth.org director | JSK @Stanford Fellow ‘20-21 | 🇯🇲 Florida http://www.higregory.com/about 0 939 366 79 2013-01-01T21:08:57+00:00 3334     1 0 4039   0 0 0 FFFFFF http://abs.twimg.com/images/themes/theme9/bg.gif https://abs.twimg.com/images/themes/theme9/bg.gif 0 http://pbs.twimg.com/profile_images/1315100277880565760/Rw606ewD_normal.jpg https://pbs.twimg.com/profile_images/1315100277880565760/Rw606ewD_normal.jpg https://pbs.twimg.com/profile_banners/1053480468/1598846198 005C9D FFFFFF 252429 666666 0 0 0 0 0 0 none

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [users] (
   [id] INTEGER PRIMARY KEY,
   [screen_name] TEXT,
   [name] TEXT,
   [description] TEXT,
   [location] TEXT
, [url] TEXT, [protected] INTEGER, [followers_count] INTEGER, [friends_count] INTEGER, [listed_count] INTEGER, [created_at] TEXT, [favourites_count] INTEGER, [utc_offset] TEXT, [time_zone] TEXT, [geo_enabled] INTEGER, [verified] INTEGER, [statuses_count] INTEGER, [lang] TEXT, [contributors_enabled] INTEGER, [is_translator] INTEGER, [is_translation_enabled] INTEGER, [profile_background_color] TEXT, [profile_background_image_url] TEXT, [profile_background_image_url_https] TEXT, [profile_background_tile] INTEGER, [profile_image_url] TEXT, [profile_image_url_https] TEXT, [profile_banner_url] TEXT, [profile_link_color] TEXT, [profile_sidebar_border_color] TEXT, [profile_sidebar_fill_color] TEXT, [profile_text_color] TEXT, [profile_use_background_image] INTEGER, [has_extended_profile] INTEGER, [default_profile] INTEGER, [default_profile_image] INTEGER, [following] INTEGER, [follow_request_sent] INTEGER, [notifications] INTEGER, [translator_type] TEXT);
Powered by Datasette · Query took 102.235ms · About: simonw/jsk-fellows-on-twitter