count_history

562 rows where type = 3

- 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,3219,2020-10-30T00:44:37+00:00	listed 3	Phillip Smith 3219	2020-10-30T00:44:37+00:00	363
3,12497,2020-10-30T00:44:36+00:00	listed 3	Simon Willison 12497	2020-10-30T00:44:36+00:00	1265
3,29283,2020-10-30T00:44:39+00:00	listed 3	Steve Rhodes 29283	2020-10-30T00:44:39+00:00	726
3,770729,2020-10-30T00:44:39+00:00	listed 3	Liz Gannes 770729	2020-10-30T00:44:39+00:00	2171
3,783324,2020-10-30T00:44:39+00:00	listed 3	Dave Maass 🔦 783324	2020-10-30T00:44:39+00:00	192
3,1169521,2020-10-30T00:44:39+00:00	listed 3	Eric Cheng 1169521	2020-10-30T00:44:39+00:00	399
3,1246761,2020-10-30T00:44:38+00:00	listed 3	Cindy Royal 1246761	2020-10-30T00:44:38+00:00	644
3,1545741,2020-10-30T00:44:43+00:00	listed 3	Elizabeth Osder 1545741	2020-10-30T00:44:43+00:00	82
3,2241921,2020-10-30T00:44:36+00:00	listed 3	Pamela Chen 🙋🏻‍♀️🤦🏻‍♀️ 2241921	2020-10-30T00:44:36+00:00	258
3,2400471,2020-10-30T00:44:46+00:00	listed 3	Kaizar Campwala 2400471	2020-10-30T00:44:46+00:00	74
3,5202671,2020-10-30T00:44:49+00:00	listed 3	Martyn Williams 5202671	2020-10-30T00:44:49+00:00	1452
3,6181532,2020-10-30T00:44:39+00:00	listed 3	Michael Morisy 6181532	2020-10-30T00:44:39+00:00	519
3,6199412,2020-10-30T00:44:36+00:00	listed 3	Jim Colgan 6199412	2020-10-30T00:44:36+00:00	89
3,6278622,2020-10-30T00:44:51+00:00	listed 3	Kathy Kiely 6278622	2020-10-30T00:44:51+00:00	132
3,6304662,2020-10-30T00:44:39+00:00	listed 3	David Cohn 6304662	2020-10-30T00:44:39+00:00	1610
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,6819732,2020-10-30T00:44:50+00:00	listed 3	NAHJ 6819732	2020-10-30T00:44:50+00:00	897
3,6827702,2020-10-30T00:44:37+00:00	listed 3	André Natta 6827702	2020-10-30T00:44:37+00:00	341
3,7068802,2020-10-30T00:44:48+00:00	listed 3	Marie C Beuth 7068802	2020-10-30T00:44:48+00:00	542
3,7380872,2020-10-30T00:44:40+00:00	listed 3	Anne Kornblut 7380872	2020-10-30T00:44:40+00:00	587
3,7805322,2020-10-30T00:44:50+00:00	listed 3	Rosental 7805322	2020-10-30T00:44:50+00:00	1479
3,7809252,2020-10-30T00:44:51+00:00	listed 3	wendy norris 7809252	2020-10-30T00:44:51+00:00	248
3,7832552,2020-10-30T00:44:36+00:00	listed 3	Kinsey Wilson 7832552	2020-10-30T00:44:36+00:00	381
3,8119452,2020-10-30T00:44:45+00:00	listed 3	💀 damned sinker 💀 8119452	2020-10-30T00:44:45+00:00	1259
3,8143682,2020-10-30T00:44:40+00:00	listed 3	Jure Leskovec 8143682	2020-10-30T00:44:40+00:00	783
3,8441632,2020-10-30T00:44:38+00:00	listed 3	Burt Herman 8441632	2020-10-30T00:44:38+00:00	971
3,8839152,2020-10-30T00:44:39+00:00	listed 3	Matt Waite 8839152	2020-10-30T00:44:39+00:00	854
3,8956962,2020-10-30T00:44:48+00:00	listed 3	Kirk Caraway 8956962	2020-10-30T00:44:48+00:00	15
3,9078442,2020-10-30T00:44:39+00:00	listed 3	Greg Agvent 9078442	2020-10-30T00:44:39+00:00	57
3,9342312,2020-10-30T00:44:40+00:00	listed 3	Fred Turner 9342312	2020-10-30T00:44:40+00:00	151
3,9443532,2020-10-30T00:44:45+00:00	listed 3	Rick Attig 9443532	2020-10-30T00:44:45+00:00	9
3,9486682,2020-10-30T00:44:45+00:00	listed 3	Ezequiel Abiú López 9486682	2020-10-30T00:44:45+00:00	19
3,9720702,2020-10-30T00:44:51+00:00	listed 3	Patricia Sullivan 9720702	2020-10-30T00:44:51+00:00	144
3,10587552,2020-10-30T00:44:40+00:00	listed 3	Michael Bernstein 10587552	2020-10-30T00:44:40+00:00	299
3,10740662,2020-10-30T00:44:39+00:00	listed 3	Paul Egglestone 10740662	2020-10-30T00:44:39+00:00	116
3,10794392,2020-10-30T00:44:45+00:00	listed 3	Kathleen McCoy 10794392	2020-10-30T00:44:45+00:00	13
3,11579212,2020-10-30T00:44:51+00:00	listed 3	Steve Sternberg 11579212	2020-10-30T00:44:51+00:00	737
3,11688592,2020-10-30T00:44:37+00:00	listed 3	Mandy Jenkins 11688592	2020-10-30T00:44:37+00:00	966
3,12655722,2020-10-30T00:44:50+00:00	listed 3	IRE and NICAR 12655722	2020-10-30T00:44:50+00:00	1540
3,12956682,2020-10-30T00:44:48+00:00	listed 3	David Sarno 12956682	2020-10-30T00:44:48+00:00	454
3,13371202,2020-10-30T00:44:47+00:00	listed 3	john temple 13371202	2020-10-30T00:44:47+00:00	276
3,13575602,2020-10-30T00:44:35+00:00	listed 3	Aparna Mukherjee 13575602	2020-10-30T00:44:35+00:00	417
3,13690462,2020-10-30T00:44:43+00:00	listed 3	Bonnie D. Ford 13690462	2020-10-30T00:44:43+00:00	845
3,13745872,2020-10-30T00:44:50+00:00	listed 3	Online News Association 13745872	2020-10-30T00:44:50+00:00	2528
3,14073364,2020-10-30T00:44:50+00:00	listed 3	Knight Foundation 14073364	2020-10-30T00:44:50+00:00	6237
3,14080017,2020-10-30T00:44:48+00:00	listed 3	Gabriel Sama 14080017	2020-10-30T00:44:48+00:00	481
3,14104554,2020-10-30T00:44:37+00:00	listed 3	Tim Regan-Porter 14104554	2020-10-30T00:44:37+00:00	308
3,14124402,2020-10-30T00:44:48+00:00	listed 3	Pedro Doria 🇧🇷😷 14124402	2020-10-30T00:44:48+00:00	1181
3,14130084,2020-10-30T00:44:38+00:00	listed 3	Shazna Nessa 14130084	2020-10-30T00:44:38+00:00	374
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,14145296,2020-10-30T00:44:39+00:00	listed 3	Susie Cagle 14145296	2020-10-30T00:44:39+00:00	1120
3,14173930,2020-10-30T00:44:37+00:00	listed 3	stacy-marie ishmael 14173930	2020-10-30T00:44:37+00:00	1022
3,14192329,2020-10-30T00:44:36+00:00	listed 3	Karen Wickre ☕️💻👀 14192329	2020-10-30T00:44:36+00:00	840
3,14282158,2020-10-30T00:44:48+00:00	listed 3	Chris Allbritton 14282158	2020-10-30T00:44:48+00:00	0
3,14305753,2020-10-30T00:44:36+00:00	listed 3	𝙟𝙤𝙨𝙚 𝙯𝙖𝙢𝙤𝙧𝙖 14305753	2020-10-30T00:44:36+00:00	403
3,14324734,2020-10-30T00:44:51+00:00	listed 3	Phil Trounstine 14324734	2020-10-30T00:44:51+00:00	43
3,14335332,2020-10-30T00:44:40+00:00	listed 3	Dan Nguyen »»» 14335332	2020-10-30T00:44:40+00:00	900
3,14370540,2020-10-30T00:44:39+00:00	listed 3	jeremyhay 14370540	2020-10-30T00:44:39+00:00	43
3,14381600,2020-10-30T00:44:38+00:00	listed 3	Tracie Powell 14381600	2020-10-30T00:44:38+00:00	182
3,14426743,2020-10-30T00:44:38+00:00	listed 3	jrbettinger 14426743	2020-10-30T00:44:38+00:00	55
3,14478614,2020-10-30T00:44:48+00:00	listed 3	Jeff Elder 14478614	2020-10-30T00:44:48+00:00	1123
3,14573694,2020-10-30T00:44:46+00:00	listed 3	Ann Grimes 14573694	2020-10-30T00:44:46+00:00	30
3,14590178,2020-10-30T00:44:49+00:00	listed 3	Michael V. Marcotte 14590178	2020-10-30T00:44:49+00:00	93
3,14602589,2020-10-30T00:44:50+00:00	listed 3	aaja 14602589	2020-10-30T00:44:50+00:00	558
3,14615604,2020-10-30T00:44:45+00:00	listed 3	Denis RB 14615604	2020-10-30T00:44:45+00:00	76
3,14636665,2020-10-30T00:44:37+00:00	listed 3	Flor Coelho 14636665	2020-10-30T00:44:37+00:00	446
3,14699813,2020-10-30T00:44:40+00:00	listed 3	Zena Barakat 14699813	2020-10-30T00:44:40+00:00	114
3,14715942,2020-10-30T00:44:47+00:00	listed 3	Umbreen Bhatti 14715942	2020-10-30T00:44:47+00:00	112
3,14716014,2020-10-30T00:44:37+00:00	listed 3	Laura Hertzfeld 14716014	2020-10-30T00:44:37+00:00	178
3,14735654,2020-10-30T00:44:51+00:00	listed 3	Michelle Johnson 14735654	2020-10-30T00:44:51+00:00	129
3,14743741,2020-10-30T00:44:48+00:00	listed 3	federica bianchi 14743741	2020-10-30T00:44:48+00:00	35
3,14766481,2020-10-30T00:44:41+00:00	listed 3	RODRIGOCARPIO 14766481	2020-10-30T00:44:41+00:00	3
3,14769899,2020-10-30T00:44:43+00:00	listed 3	TimJohnson 14769899	2020-10-30T00:44:43+00:00	335
3,14849874,2020-10-30T00:44:44+00:00	listed 3	Matt Crenson 14849874	2020-10-30T00:44:44+00:00	11
3,14908497,2020-10-30T00:44:43+00:00	listed 3	luzmariahelguero 14908497	2020-10-30T00:44:43+00:00	12
3,14947379,2020-10-30T00:44:47+00:00	listed 3	Tran Ha 14947379	2020-10-30T00:44:47+00:00	161
3,14968475,2020-10-30T00:44:40+00:00	listed 3	Dan Jurafsky 14968475	2020-10-30T00:44:40+00:00	475
3,14984915,2020-10-30T00:44:46+00:00	listed 3	Andrew Haeg 14984915	2020-10-30T00:44:46+00:00	408
3,14985683,2020-10-30T00:44:38+00:00	listed 3	Jigar Mehta 14985683	2020-10-30T00:44:38+00:00	228
3,15035816,2020-10-30T00:44:51+00:00	listed 3	Tomoko Hosaka Mullaney 15035816	2020-10-30T00:44:51+00:00	1137
3,15120110,2020-10-30T00:44:51+00:00	listed 3	Paul Raeburn 15120110	2020-10-30T00:44:51+00:00	228
3,15220720,2020-10-30T00:44:39+00:00	listed 3	Steve Grove 15220720	2020-10-30T00:44:39+00:00	508
3,15315979,2020-10-30T00:44:38+00:00	listed 3	Carolina Guerrero 15315979	2020-10-30T00:44:38+00:00	279
3,15348391,2020-10-30T00:44:51+00:00	listed 3	AirBeano 15348391	2020-10-30T00:44:51+00:00	2
3,15587316,2020-10-30T00:44:41+00:00	listed 3	JocelynNoveckAP 15587316	2020-10-30T00:44:41+00:00	49
3,15607854,2020-10-30T00:44:41+00:00	listed 3	MarshaMcFadden 15607854	2020-10-30T00:44:41+00:00	13
3,15674801,2020-10-30T00:44:36+00:00	listed 3	Emilio Garcia-Ruiz 15674801	2020-10-30T00:44:36+00:00	219
3,15751494,2020-10-30T00:44:42+00:00	listed 3	Roberta Oster 15751494	2020-10-30T00:44:42+00:00	13
3,15900236,2020-10-30T00:44:42+00:00	listed 3	Harriet A.Washington 15900236	2020-10-30T00:44:42+00:00	77
3,15906933,2020-10-30T00:44:47+00:00	listed 3	Danyel Smith 15906933	2020-10-30T00:44:47+00:00	1133
3,15967248,2020-10-30T00:44:48+00:00	listed 3	Justin Arenstein 15967248	2020-10-30T00:44:48+00:00	0
3,16018986,2020-10-30T00:44:37+00:00	listed 3	Brian EdwardsTiekert 16018986	2020-10-30T00:44:37+00:00	86
3,16141134,2020-10-30T00:44:37+00:00	listed 3	hrv 16141134	2020-10-30T00:44:37+00:00	111
3,16212914,2020-10-30T00:44:36+00:00	listed 3	Natalia Mazotte 16212914	2020-10-30T00:44:36+00:00	205
3,16248718,2020-10-30T00:44:36+00:00	listed 3	LisaHsia 16248718	2020-10-30T00:44:36+00:00	92
3,16259364,2020-10-30T00:44:39+00:00	listed 3	Michelle Holmes 16259364	2020-10-30T00:44:39+00:00	224
3,16288136,2020-10-30T00:44:48+00:00	listed 3	Melissa Chan 16288136	2020-10-30T00:44:48+00:00	1877
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,16295662,2020-10-30T00:44:49+00:00	listed 3	Alberto Ibarguen 16295662	2020-10-30T00:44:49+00:00	556
3,16350120,2020-10-30T00:44:46+00:00	listed 3	Claudia Nunez 16350120	2020-10-30T00:44:46+00:00	100

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])
);