users

154 rows where verified = 1

✎ View and edit SQL

This data as json, CSV (advanced)

verified ✖

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
423511427 CODaleyNews John Daley Multi-media journalist, covering health news for Colorado Public Radio, aka CPRNews A link or retweet does not = endorsement. USA http://cpr.org 0 2351 939 131 2011-11-28T16:05:17+00:00 3772     0 1 5025   0 0 0 000000 http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/1156307032892477440/BLv5vRSo_normal.jpg https://pbs.twimg.com/profile_images/1156307032892477440/BLv5vRSo_normal.jpg https://pbs.twimg.com/profile_banners/423511427/1442034198 1B95E0 000000 000000 000000 0 0 0 0 0 0 none
430250670 FukuyamaFrancis Francis Fukuyama Senior Fellow at Stanford's Freeman Spogli Institute, and Mosbacher Director, @StanfordCDDRL Instagram: francis.fukuyama Stanford, CA http://francisfukuyama.com 0 146506 546 2073 2011-12-06T23:09:59+00:00 3662     1 1 5186   0 0 0 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/2908541118/78cf45de12d324a5c6ef1113ad2263ca_normal.jpeg https://pbs.twimg.com/profile_images/2908541118/78cf45de12d324a5c6ef1113ad2263ca_normal.jpeg https://pbs.twimg.com/profile_banners/430250670/1521517508 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
437729436 susanferriss Susan Ferriss Reporter, immigration editor @publicintegrity The Fight in the Fields co-author, former Mexico-based news correspondent. Welcome tips. Washington, D.C. http://www.publicintegrity.org/ 0 2121 1004 127 2011-12-15T19:24:06+00:00 631     0 1 3671   0 0 0 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/1708231141/New_Image_normal.JPG https://pbs.twimg.com/profile_images/1708231141/New_Image_normal.JPG   1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 0 0 none
454099919 McFaul Michael McFaul Professor. http://michaelmcfaul.com/ Stanford, California http://www.facebook.com/amb.mcfaul 0 526294 1701 4974 2012-01-03T16:36:02+00:00 33719     0 1 87525   0 0 0 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/640815361638535169/L5CJEZkw_normal.jpg https://pbs.twimg.com/profile_images/640815361638535169/L5CJEZkw_normal.jpg https://pbs.twimg.com/profile_banners/454099919/1532108947 1B95E0 C0DEED DDEEF6 333333 0 0 0 0 1 0 none
573764891 OTMBrooke Brooke Gladstone Co-Host, Editor of WNYC's On the Media, author of "The Influencing Machine" and "The Trouble with Reality: A Rumination on Moral Panic" and so on. Brooklyn, New York http://onthemedia.org 0 25749 321 689 2012-05-07T16:15:11+00:00 342     1 1 1266   0 0 0 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/2199145153/gladstone_normal.jpg https://pbs.twimg.com/profile_images/2199145153/gladstone_normal.jpg   1DA1F2 C0DEED DDEEF6 333333 1 0 1 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
778895864 RachelDissell Rachel Dissell Journalist. Former Plain Dealer reporter. Mama bear. Public records are my jam. Current @JSKstanford fellow. Send tips to rldissell@gmail.com Cleveland, Oh   0 8014 2588 201 2012-08-24T20:16:33+00:00 9378     1 1 11781   0 0 0 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/691074780687142913/902N9itu_normal.jpg https://pbs.twimg.com/profile_images/691074780687142913/902N9itu_normal.jpg https://pbs.twimg.com/profile_banners/778895864/1552874644 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 1 0 none
1370570863 SachaPfeiffer Sacha Pfeiffer @NPR reporter. Former reporter for @BostonGlobe & @GlobeSpotlight. Former @WBUR host & reporter. @JSKStanford fellow. @SpotlightMovie fan. spfeiffer@npr.org Boston, MA https://www.npr.org/people/676406186/sacha-pfeiffer 0 18502 469 418 2013-04-21T20:54:15+00:00 7866     0 1 1876   0 0 0 10171A http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/3556429288/82ae993bbca95210b9c5445041c66af9_normal.jpeg https://pbs.twimg.com/profile_images/3556429288/82ae993bbca95210b9c5445041c66af9_normal.jpeg https://pbs.twimg.com/profile_banners/1370570863/1399513448 0A0A0A 000000 DDEEF6 333333 1 0 0 0 0 0 none
1407123218 DroneDeploy DroneDeploy Cloud-based software enabling simple and reliable drone operations. Create maps & 3D models in two clicks. Over 100 million acres mapped. San Francisco http://www.dronedeploy.com 0 31334 794 529 2013-05-06T08:00:03+00:00 6458     0 1 8211   0 0 0 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/907391581220515840/LY88qfLd_normal.jpg https://pbs.twimg.com/profile_images/907391581220515840/LY88qfLd_normal.jpg https://pbs.twimg.com/profile_banners/1407123218/1516655339 2F85C7 C0DEED DDEEF6 333333 1 0 0 0 0 0 none
1548898596 Ericnpr Eric Westervelt @NPR journalist. Recovering foreign correspondent. Occasional host. Musician by moonlight http://SecureDrop.npr.org/ http://SeeDisclaimer.com San Francisco, CA https://www.npr.org/people/2101350/eric-westervelt 0 4897 2014 210 2013-06-26T19:27:15+00:00 680     0 1 2353   0 0 0 000000 http://abs.twimg.com/images/themes/theme2/bg.gif https://abs.twimg.com/images/themes/theme2/bg.gif 0 http://pbs.twimg.com/profile_images/617350595511324672/WKSuKLYH_normal.jpg https://pbs.twimg.com/profile_images/617350595511324672/WKSuKLYH_normal.jpg https://pbs.twimg.com/profile_banners/1548898596/1406506418 3B94D9 000000 000000 000000 0 0 0 0 0 0 none
2373280040 HiromiSHorie 堀江広美 Bloomberg News東京支局記者・編集者/JBN Finance&Credit TL/ライブニュースブログPM/フルブライトジャーナリスト/スタンフォード大学元フェロー/TEDxFulbright Tokyo Speaker/ヨガRYT500/ Hiromi Saimu Horie. ツイートは個人の見解   https://www.bloomberg.com/authors/ADBE0_r0e2w/hiromi-horie 0 1602 1012 26 2014-03-05T06:33:39+00:00 2257     0 1 4244   0 0 0 0099B9 http://abs.twimg.com/images/themes/theme4/bg.gif https://abs.twimg.com/images/themes/theme4/bg.gif 0 http://pbs.twimg.com/profile_images/441103544498667520/VOQ6QSVn_normal.jpeg https://pbs.twimg.com/profile_images/441103544498667520/VOQ6QSVn_normal.jpeg https://pbs.twimg.com/profile_banners/2373280040/1523746300 0099B9 5ED4DC 95E8EC 3C3940 1 0 0 0 0 0 none
3245142196 GoogleNewsInit Google News Initiative Our effort to help news organizations and journalists thrive in the digital age. San Francisco, CA http://g.co/newsinitiative 0 111446 229 2229 2015-05-10T17:09:58+00:00 1934     1 1 3475   0 0 0 131516 http://abs.twimg.com/images/themes/theme14/bg.gif https://abs.twimg.com/images/themes/theme14/bg.gif 1 http://pbs.twimg.com/profile_images/976112586528784385/4WNT1R6Q_normal.jpg https://pbs.twimg.com/profile_images/976112586528784385/4WNT1R6Q_normal.jpg https://pbs.twimg.com/profile_banners/3245142196/1521558388 009999 EEEEEE EFEFEF 333333 1 0 0 0 1 0 none
3314775459 firstdraftnews First Draft We work to protect communities from harmful disinformation by sharing tips and resources to build resilience and improve access to accurate information. Global http://firstdraftnews.org 0 32047 1981 1547 2015-06-09T11:01:31+00:00 3491     0 1 9820   0 0 0 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png https://abs.twimg.com/images/themes/theme1/bg.png 0 http://pbs.twimg.com/profile_images/1278452041090830337/TFHOyXrO_normal.jpg https://pbs.twimg.com/profile_images/1278452041090830337/TFHOyXrO_normal.jpg https://pbs.twimg.com/profile_banners/3314775459/1593641694 9F1924 000000 000000 000000 1 0 0 0 0 0 none
1067218780806307841 StanfordHAI Stanford HAI Advancing AI research, education, policy, and practice to improve the human condition. Stanford, CA https://hai.stanford.edu 0 31130 117 616 2018-11-27T00:49:20+00:00 175     0 1 736   0 0 0 F5F8FA     0 http://pbs.twimg.com/profile_images/1312204437172097024/AEjW7Yds_normal.jpg https://pbs.twimg.com/profile_images/1312204437172097024/AEjW7Yds_normal.jpg https://pbs.twimg.com/profile_banners/1067218780806307841/1601688894 1DA1F2 C0DEED DDEEF6 333333 1 0 1 0 1 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 4.386ms · About: simonw/jsk-fellows-on-twitter