count_history

562 rows where type = 3 sorted by count descending

- remove filter - type user datetime count

= != 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 - type user datetime count

= != 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 type Sort by user Sort by datetime Sort by count

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime, datetime (date)

Link	type	user	datetime	count ▲
3,17595439,2020-10-30T00:44:39+00:00	listed 3	Chris Anderson 17595439	2020-10-30T00:44:39+00:00	8034
3,18036441,2020-10-30T00:44:40+00:00	listed 3	Stanford University 18036441	2020-10-30T00:44:40+00:00	7132
3,17813899,2020-10-30T00:44:40+00:00	listed 3	Stanford Business 17813899	2020-10-30T00:44:40+00:00	6920
3,14073364,2020-10-30T00:44:50+00:00	listed 3	Knight Foundation 14073364	2020-10-30T00:44:50+00:00	6237
3,37759047,2020-10-30T00:44:39+00:00	listed 3	JenniferPreston 37759047	2020-10-30T00:44:39+00:00	5612
3,454099919,2020-10-30T00:44:40+00:00	listed 3	Michael McFaul 454099919	2020-10-30T00:44:40+00:00	4974
3,174492304,2020-10-30T00:44:44+00:00	listed 3	Daniel Coronell 174492304	2020-10-30T00:44:44+00:00	3754
3,30331404,2020-10-30T00:44:40+00:00	listed 3	Stanford d.school 30331404	2020-10-30T00:44:40+00:00	3403
3,185809250,2020-10-30T00:44:47+00:00	listed 3	Civil Eats 185809250	2020-10-30T00:44:47+00:00	3134
3,43412697,2020-10-30T00:44:39+00:00	listed 3	Clara Jeffery 43412697	2020-10-30T00:44:39+00:00	2897
3,13745872,2020-10-30T00:44:50+00:00	listed 3	Online News Association 13745872	2020-10-30T00:44:50+00:00	2528
3,3245142196,2020-10-30T00:44:49+00:00	listed 3	Google News Initiative 3245142196	2020-10-30T00:44:49+00:00	2229
3,770729,2020-10-30T00:44:39+00:00	listed 3	Liz Gannes 770729	2020-10-30T00:44:39+00:00	2171
3,430250670,2020-10-30T00:44:40+00:00	listed 3	Francis Fukuyama 430250670	2020-10-30T00:44:40+00:00	2073
3,17808151,2020-10-30T00:44:49+00:00	listed 3	ICFJ 17808151	2020-10-30T00:44:49+00:00	1985
3,126776391,2020-10-30T00:44:40+00:00	listed 3	Bob Sutton 126776391	2020-10-30T00:44:40+00:00	1957
3,16288136,2020-10-30T00:44:48+00:00	listed 3	Melissa Chan 16288136	2020-10-30T00:44:48+00:00	1877
3,23898238,2020-10-30T00:44:40+00:00	listed 3	Tina Seelig 23898238	2020-10-30T00:44:40+00:00	1695
3,130596773,2020-10-30T00:44:49+00:00	listed 3	Global Investigative Journalism Network 130596773	2020-10-30T00:44:49+00:00	1659
3,19152977,2020-10-30T00:44:43+00:00	listed 3	Farai Chideya 19152977	2020-10-30T00:44:43+00:00	1643
3,6304662,2020-10-30T00:44:39+00:00	listed 3	David Cohn 6304662	2020-10-30T00:44:39+00:00	1610
3,24224268,2020-10-30T00:44:39+00:00	listed 3	Naomi Starkman 24224268	2020-10-30T00:44:39+00:00	1588
3,3314775459,2020-10-30T00:44:49+00:00	listed 3	First Draft 3314775459	2020-10-30T00:44:49+00:00	1547
3,12655722,2020-10-30T00:44:50+00:00	listed 3	IRE and NICAR 12655722	2020-10-30T00:44:50+00:00	1540
3,16616757,2020-10-30T00:44:49+00:00	listed 3	IJNet 16616757	2020-10-30T00:44:49+00:00	1506
3,7805322,2020-10-30T00:44:50+00:00	listed 3	Rosental 7805322	2020-10-30T00:44:50+00:00	1479
3,5202671,2020-10-30T00:44:49+00:00	listed 3	Martyn Williams 5202671	2020-10-30T00:44:49+00:00	1452
3,19425169,2020-10-30T00:44:40+00:00	listed 3	Stanford Engineering 19425169	2020-10-30T00:44:40+00:00	1291
3,213689248,2020-10-30T00:44:37+00:00	listed 3	Dr. Seema Yasmin 213689248	2020-10-30T00:44:37+00:00	1272
3,12497,2020-10-30T00:44:36+00:00	listed 3	Simon Willison 12497	2020-10-30T00:44:36+00:00	1265
3,8119452,2020-10-30T00:44:45+00:00	listed 3	💀 damned sinker 💀 8119452	2020-10-30T00:44:45+00:00	1259
3,124531391,2020-10-30T00:44:47+00:00	listed 3	MuckRock 124531391	2020-10-30T00:44:47+00:00	1228
3,16729309,2020-10-30T00:44:40+00:00	listed 3	Lucy Bernholz 16729309	2020-10-30T00:44:40+00:00	1201
3,2815077014,2020-10-30T00:44:40+00:00	listed 3	Christopher Manning 2815077014	2020-10-30T00:44:40+00:00	1184
3,14124402,2020-10-30T00:44:48+00:00	listed 3	Pedro Doria 🇧🇷😷 14124402	2020-10-30T00:44:48+00:00	1181
3,15035816,2020-10-30T00:44:51+00:00	listed 3	Tomoko Hosaka Mullaney 15035816	2020-10-30T00:44:51+00:00	1137
3,15906933,2020-10-30T00:44:47+00:00	listed 3	Danyel Smith 15906933	2020-10-30T00:44:47+00:00	1133
3,14478614,2020-10-30T00:44:48+00:00	listed 3	Jeff Elder 14478614	2020-10-30T00:44:48+00:00	1123
3,14145296,2020-10-30T00:44:39+00:00	listed 3	Susie Cagle 14145296	2020-10-30T00:44:39+00:00	1120
3,32129142,2020-10-30T00:44:41+00:00	listed 3	Carol Rosenberg 32129142	2020-10-30T00:44:41+00:00	1116
3,30117765,2020-10-30T00:44:41+00:00	listed 3	Marcelo Rubens Paiva 30117765	2020-10-30T00:44:41+00:00	1088
3,73194395,2020-10-30T00:44:39+00:00	listed 3	Katie Benner 73194395	2020-10-30T00:44:39+00:00	1054
3,17768092,2020-10-30T00:44:44+00:00	listed 3	carola fuentes 17768092	2020-10-30T00:44:44+00:00	1048
3,14173930,2020-10-30T00:44:37+00:00	listed 3	stacy-marie ishmael 14173930	2020-10-30T00:44:37+00:00	1022
3,21350494,2020-10-30T00:44:40+00:00	listed 3	Stanford eCorner 21350494	2020-10-30T00:44:40+00:00	992
3,110638978,2020-10-30T00:44:49+00:00	listed 3	Hacks/Hackers 110638978	2020-10-30T00:44:49+00:00	987
3,310596714,2020-10-30T00:44:47+00:00	listed 3	Radio Am-booo-lan-te 👻 310596714	2020-10-30T00:44:47+00:00	972
3,8441632,2020-10-30T00:44:38+00:00	listed 3	Burt Herman 8441632	2020-10-30T00:44:38+00:00	971
3,11688592,2020-10-30T00:44:37+00:00	listed 3	Mandy Jenkins 11688592	2020-10-30T00:44:37+00:00	966
3,14335332,2020-10-30T00:44:40+00:00	listed 3	Dan Nguyen »»» 14335332	2020-10-30T00:44:40+00:00	900
3,6819732,2020-10-30T00:44:50+00:00	listed 3	NAHJ 6819732	2020-10-30T00:44:50+00:00	897
3,24164338,2020-10-30T00:44:49+00:00	listed 3	NABJ Headquarters | NABJ.org 24164338	2020-10-30T00:44:49+00:00	879
3,8839152,2020-10-30T00:44:39+00:00	listed 3	Matt Waite 8839152	2020-10-30T00:44:39+00:00	854
3,13690462,2020-10-30T00:44:43+00:00	listed 3	Bonnie D. Ford 13690462	2020-10-30T00:44:43+00:00	845
3,14192329,2020-10-30T00:44:36+00:00	listed 3	Karen Wickre ☕️💻👀 14192329	2020-10-30T00:44:36+00:00	840
3,39021657,2020-10-30T00:44:49+00:00	listed 3	Anita Zielina 39021657	2020-10-30T00:44:49+00:00	810
3,26336913,2020-10-30T00:44:44+00:00	listed 3	Frances Robles 26336913	2020-10-30T00:44:44+00:00	801
3,341118458,2020-10-30T00:44:45+00:00	listed 3	Eric Schmitt 341118458	2020-10-30T00:44:45+00:00	796
3,8143682,2020-10-30T00:44:40+00:00	listed 3	Jure Leskovec 8143682	2020-10-30T00:44:40+00:00	783
3,329353102,2020-10-30T00:44:47+00:00	listed 3	Amie Ferris-Rotman 329353102	2020-10-30T00:44:47+00:00	766
3,11579212,2020-10-30T00:44:51+00:00	listed 3	Steve Sternberg 11579212	2020-10-30T00:44:51+00:00	737
3,29006114,2020-10-30T00:44:36+00:00	listed 3	Latoya Peterson 29006114	2020-10-30T00:44:36+00:00	737
3,29283,2020-10-30T00:44:39+00:00	listed 3	Steve Rhodes 29283	2020-10-30T00:44:39+00:00	726
3,20253808,2020-10-30T00:44:45+00:00	listed 3	Andrea Bernstein 20253808	2020-10-30T00:44:45+00:00	726
3,945284660,2020-10-30T00:44:40+00:00	listed 3	Susan Athey 945284660	2020-10-30T00:44:40+00:00	707
3,573764891,2020-10-30T00:44:51+00:00	listed 3	Brooke Gladstone 573764891	2020-10-30T00:44:51+00:00	689
3,110905920,2020-10-30T00:44:49+00:00	listed 3	wjchat 110905920	2020-10-30T00:44:49+00:00	669
3,18741571,2020-10-30T00:44:51+00:00	listed 3	VaughnPalmer 18741571	2020-10-30T00:44:51+00:00	659
3,1246761,2020-10-30T00:44:38+00:00	listed 3	Cindy Royal 1246761	2020-10-30T00:44:38+00:00	644
3,263852695,2020-10-30T00:44:40+00:00	listed 3	Stanford VR 263852695	2020-10-30T00:44:40+00:00	633
3,28113052,2020-10-30T00:44:43+00:00	listed 3	Beth Fouhy 28113052	2020-10-30T00:44:43+00:00	626
3,1067218780806307841,2020-10-30T00:44:40+00:00	listed 3	Stanford HAI 1067218780806307841	2020-10-30T00:44:40+00:00	616
3,1581899310,2020-10-30T00:44:40+00:00	listed 3	Tom & David Kelley 1581899310	2020-10-30T00:44:40+00:00	609
3,17270262,2020-10-30T00:44:41+00:00	listed 3	Tom Hamburger 17270262	2020-10-30T00:44:41+00:00	607
3,17714681,2020-10-30T00:44:37+00:00	listed 3	Frederic Filloux 17714681	2020-10-30T00:44:37+00:00	601
3,7380872,2020-10-30T00:44:40+00:00	listed 3	Anne Kornblut 7380872	2020-10-30T00:44:40+00:00	587
3,47854857,2020-10-30T00:44:36+00:00	listed 3	Alastair Leithead 47854857	2020-10-30T00:44:36+00:00	563
3,96941094,2020-10-30T00:44:45+00:00	listed 3	Andrew M. Mwenda 96941094	2020-10-30T00:44:45+00:00	559
3,14602589,2020-10-30T00:44:50+00:00	listed 3	aaja 14602589	2020-10-30T00:44:50+00:00	558
3,16295662,2020-10-30T00:44:49+00:00	listed 3	Alberto Ibarguen 16295662	2020-10-30T00:44:49+00:00	556
3,7068802,2020-10-30T00:44:48+00:00	listed 3	Marie C Beuth 7068802	2020-10-30T00:44:48+00:00	542
3,1407123218,2020-10-30T00:44:39+00:00	listed 3	DroneDeploy 1407123218	2020-10-30T00:44:39+00:00	529
3,6181532,2020-10-30T00:44:39+00:00	listed 3	Michael Morisy 6181532	2020-10-30T00:44:39+00:00	519
3,26006398,2020-10-30T00:44:39+00:00	listed 3	Jenée 26006398	2020-10-30T00:44:39+00:00	514
3,15220720,2020-10-30T00:44:39+00:00	listed 3	Steve Grove 15220720	2020-10-30T00:44:39+00:00	508
3,25427470,2020-10-30T00:44:40+00:00	listed 3	The Stanford Daily 25427470	2020-10-30T00:44:40+00:00	508
3,418837047,2020-10-30T00:44:49+00:00	listed 3	Matter. 418837047	2020-10-30T00:44:49+00:00	505
3,44911552,2020-10-30T00:44:38+00:00	listed 3	Mariana Santos 44911552	2020-10-30T00:44:38+00:00	502
3,16291934,2020-10-30T00:44:49+00:00	listed 3	Society for News Design 16291934	2020-10-30T00:44:49+00:00	495
3,14140617,2020-10-30T00:44:39+00:00	listed 3	Bay Area Video Coalition 14140617	2020-10-30T00:44:39+00:00	490
3,14080017,2020-10-30T00:44:48+00:00	listed 3	Gabriel Sama 14080017	2020-10-30T00:44:48+00:00	481
3,115359136,2020-10-30T00:44:38+00:00	listed 3	Andrew Losowsky 115359136	2020-10-30T00:44:38+00:00	479
3,159616650,2020-10-30T00:44:49+00:00	listed 3	JAWS 159616650	2020-10-30T00:44:49+00:00	479
3,14968475,2020-10-30T00:44:40+00:00	listed 3	Dan Jurafsky 14968475	2020-10-30T00:44:40+00:00	475
3,19002133,2020-10-30T00:44:39+00:00	listed 3	Monika Bauerlein 19002133	2020-10-30T00:44:39+00:00	469
3,12956682,2020-10-30T00:44:48+00:00	listed 3	David Sarno 12956682	2020-10-30T00:44:48+00:00	454
3,211659408,2020-10-30T00:44:34+00:00	listed 3	John S. Knight Journalism Fellowships at Stanford 211659408	2020-10-30T00:44:34+00:00	452
3,14636665,2020-10-30T00:44:37+00:00	listed 3	Flor Coelho 14636665	2020-10-30T00:44:37+00:00	446
3,6423572,2020-10-30T00:44:37+00:00	listed 3	Tom Van de Weghe 6423572	2020-10-30T00:44:37+00:00	441
3,46241234,2020-10-30T00:44:44+00:00	listed 3	Mike Swift 46241234	2020-10-30T00:44:44+00:00	441

Next page

CREATE TABLE [count_history] (
   [type] INTEGER REFERENCES [count_history_types]([id]),
   [user] INTEGER REFERENCES [users]([id]),
   [datetime] TEXT,
   [count] INTEGER,
   PRIMARY KEY ([type], [user], [datetime])
);