count_history

562 rows where type = 3 sorted by datetime

- 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,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,13575602,2020-10-30T00:44:35+00:00	listed 3	Aparna Mukherjee 13575602	2020-10-30T00:44:35+00:00	417
3,34718702,2020-10-30T00:44:35+00:00	listed 3	Candice Fortman 34718702	2020-10-30T00:44:35+00:00	117
3,84439535,2020-10-30T00:44:35+00:00	listed 3	Maritza L. Félix 84439535	2020-10-30T00:44:35+00:00	24
3,110727296,2020-10-30T00:44:35+00:00	listed 3	Lyndsey Gilpin 110727296	2020-10-30T00:44:35+00:00	332
3,243373614,2020-10-30T00:44:35+00:00	listed 3	L. Rashad Mahmood 243373614	2020-10-30T00:44:35+00:00	10
3,778895864,2020-10-30T00:44:35+00:00	listed 3	Rachel Dissell 778895864	2020-10-30T00:44:35+00:00	201
3,847882850,2020-10-30T00:44:35+00:00	listed 3	Nicole Foy 847882850	2020-10-30T00:44:35+00:00	95
3,1053480468,2020-10-30T00:44:35+00:00	listed 3	Gregory Johnson 1053480468	2020-10-30T00:44:35+00:00	79
3,3177360083,2020-10-30T00:44:35+00:00	listed 3	jimmy gutierrez 3177360083	2020-10-30T00:44:35+00:00	24
3,975918869876527104,2020-10-30T00:44:35+00:00	listed 3	Brit from Nork 975918869876527104	2020-10-30T00:44:35+00:00	11
3,1112229965624307712,2020-10-30T00:44:35+00:00	listed 3	Haunted “Kate 👻☕️ Maxwell” House 1112229965624307712	2020-10-30T00:44:35+00:00	6
3,12497,2020-10-30T00:44:36+00:00	listed 3	Simon Willison 12497	2020-10-30T00:44:36+00:00	1265
3,2241921,2020-10-30T00:44:36+00:00	listed 3	Pamela Chen 🙋🏻‍♀️🤦🏻‍♀️ 2241921	2020-10-30T00:44:36+00:00	258
3,6199412,2020-10-30T00:44:36+00:00	listed 3	Jim Colgan 6199412	2020-10-30T00:44:36+00:00	89
3,7832552,2020-10-30T00:44:36+00:00	listed 3	Kinsey Wilson 7832552	2020-10-30T00:44:36+00:00	381
3,14192329,2020-10-30T00:44:36+00:00	listed 3	Karen Wickre ☕️💻👀 14192329	2020-10-30T00:44:36+00:00	840
3,14305753,2020-10-30T00:44:36+00:00	listed 3	𝙟𝙤𝙨𝙚 𝙯𝙖𝙢𝙤𝙧𝙖 14305753	2020-10-30T00:44:36+00:00	403
3,15674801,2020-10-30T00:44:36+00:00	listed 3	Emilio Garcia-Ruiz 15674801	2020-10-30T00:44:36+00:00	219
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,16829823,2020-10-30T00:44:36+00:00	listed 3	cephillips 16829823	2020-10-30T00:44:36+00:00	323
3,17000789,2020-10-30T00:44:36+00:00	listed 3	Matt Kiefer 17000789	2020-10-30T00:44:36+00:00	119
3,17797390,2020-10-30T00:44:36+00:00	listed 3	Sharad Goel 17797390	2020-10-30T00:44:36+00:00	115
3,19257632,2020-10-30T00:44:36+00:00	listed 3	Scarin’ Foley 🎃 19257632	2020-10-30T00:44:36+00:00	175
3,22455550,2020-10-30T00:44:36+00:00	listed 3	T O N Y A 22455550	2020-10-30T00:44:36+00:00	263
3,29006114,2020-10-30T00:44:36+00:00	listed 3	Latoya Peterson 29006114	2020-10-30T00:44:36+00:00	737
3,32995666,2020-10-30T00:44:36+00:00	listed 3	Maria Ronderos 32995666	2020-10-30T00:44:36+00:00	364
3,41653397,2020-10-30T00:44:36+00:00	listed 3	Anna Gielewska 41653397	2020-10-30T00:44:36+00:00	95
3,47854857,2020-10-30T00:44:36+00:00	listed 3	Alastair Leithead 47854857	2020-10-30T00:44:36+00:00	563
3,55367101,2020-10-30T00:44:36+00:00	listed 3	Dawn Garcia 55367101	2020-10-30T00:44:36+00:00	179
3,59954335,2020-10-30T00:44:36+00:00	listed 3	Bill Birnbauer 59954335	2020-10-30T00:44:36+00:00	51
3,60932080,2020-10-30T00:44:36+00:00	listed 3	Marcia Parker 60932080	2020-10-30T00:44:36+00:00	52
3,80784646,2020-10-30T00:44:36+00:00	listed 3	Krishna Bharat 80784646	2020-10-30T00:44:36+00:00	208
3,96366316,2020-10-30T00:44:36+00:00	listed 3	Shannon Brownlee 96366316	2020-10-30T00:44:36+00:00	302
3,106475977,2020-10-30T00:44:36+00:00	listed 3	Krista Almanzan 106475977	2020-10-30T00:44:36+00:00	9
3,183906947,2020-10-30T00:44:36+00:00	listed 3	Sarah SteinGreenberg 183906947	2020-10-30T00:44:36+00:00	24
3,240393453,2020-10-30T00:44:36+00:00	listed 3	Marcelle Hopkins 240393453	2020-10-30T00:44:36+00:00	260
3,245587242,2020-10-30T00:44:36+00:00	listed 3	Garance Burke 245587242	2020-10-30T00:44:36+00:00	307
3,421725730,2020-10-30T00:44:36+00:00	listed 3	Michael Rain 421725730	2020-10-30T00:44:36+00:00	57
3,516794788,2020-10-30T00:44:36+00:00	listed 3	Bryan Pollard 516794788	2020-10-30T00:44:36+00:00	15
3,520989810,2020-10-30T00:44:36+00:00	listed 3	Divine Dube 520989810	2020-10-30T00:44:36+00:00	7
3,776601864,2020-10-30T00:44:36+00:00	listed 3	Natasha Zouves 776601864	2020-10-30T00:44:36+00:00	290
3,1171581110,2020-10-30T00:44:36+00:00	listed 3	Motunrayo Alaka 1171581110	2020-10-30T00:44:36+00:00	20
3,2149361988,2020-10-30T00:44:36+00:00	listed 3	Sara Catania 2149361988	2020-10-30T00:44:36+00:00	131
3,2802357499,2020-10-30T00:44:36+00:00	listed 3	Heather Dewar 2802357499	2020-10-30T00:44:36+00:00	1
3,4250629253,2020-10-30T00:44:36+00:00	listed 3	Joseph Poliszuk 4250629253	2020-10-30T00:44:36+00:00	245
3,3219,2020-10-30T00:44:37+00:00	listed 3	Phillip Smith 3219	2020-10-30T00:44:37+00:00	363
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,6827702,2020-10-30T00:44:37+00:00	listed 3	André Natta 6827702	2020-10-30T00:44:37+00:00	341
3,11688592,2020-10-30T00:44:37+00:00	listed 3	Mandy Jenkins 11688592	2020-10-30T00:44:37+00:00	966
3,14104554,2020-10-30T00:44:37+00:00	listed 3	Tim Regan-Porter 14104554	2020-10-30T00:44:37+00:00	308
3,14173930,2020-10-30T00:44:37+00:00	listed 3	stacy-marie ishmael 14173930	2020-10-30T00:44:37+00:00	1022
3,14636665,2020-10-30T00:44:37+00:00	listed 3	Flor Coelho 14636665	2020-10-30T00:44:37+00:00	446
3,14716014,2020-10-30T00:44:37+00:00	listed 3	Laura Hertzfeld 14716014	2020-10-30T00:44:37+00:00	178
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,16390952,2020-10-30T00:44:37+00:00	listed 3	Akilah Johnson 16390952	2020-10-30T00:44:37+00:00	332
3,16700673,2020-10-30T00:44:37+00:00	listed 3	Rock’em Sock’em Rosie 16700673	2020-10-30T00:44:37+00:00	21
3,17714681,2020-10-30T00:44:37+00:00	listed 3	Frederic Filloux 17714681	2020-10-30T00:44:37+00:00	601
3,18257896,2020-10-30T00:44:37+00:00	listed 3	Ryan Nakashima 18257896	2020-10-30T00:44:37+00:00	205
3,18454770,2020-10-30T00:44:37+00:00	listed 3	🔅Don Day 18454770	2020-10-30T00:44:37+00:00	247
3,19138916,2020-10-30T00:44:37+00:00	listed 3	Zeba Khan 19138916	2020-10-30T00:44:37+00:00	100
3,24661811,2020-10-30T00:44:37+00:00	listed 3	Michael Grant 24661811	2020-10-30T00:44:37+00:00	142
3,25029808,2020-10-30T00:44:37+00:00	listed 3	Guilherme Amado 25029808	2020-10-30T00:44:37+00:00	305
3,34060703,2020-10-30T00:44:37+00:00	listed 3	Juan Pablo Meneses 34060703	2020-10-30T00:44:37+00:00	264
3,43767782,2020-10-30T00:44:37+00:00	listed 3	Elodie MaillietStorm 43767782	2020-10-30T00:44:37+00:00	14
3,47898401,2020-10-30T00:44:37+00:00	listed 3	Titus Plattner 47898401	2020-10-30T00:44:37+00:00	0
3,55300229,2020-10-30T00:44:37+00:00	listed 3	Ronny Rojas 55300229	2020-10-30T00:44:37+00:00	109
3,67227724,2020-10-30T00:44:37+00:00	listed 3	Gabriel Spitzer 67227724	2020-10-30T00:44:37+00:00	151
3,78114269,2020-10-30T00:44:37+00:00	listed 3	Marina Walker 78114269	2020-10-30T00:44:37+00:00	238
3,86776199,2020-10-30T00:44:37+00:00	listed 3	JulieAnn McKellogg 86776199	2020-10-30T00:44:37+00:00	73
3,97459086,2020-10-30T00:44:37+00:00	listed 3	mago torres 97459086	2020-10-30T00:44:37+00:00	108
3,111183422,2020-10-30T00:44:37+00:00	listed 3	Heather Bryant 111183422	2020-10-30T00:44:37+00:00	389
3,117450730,2020-10-30T00:44:37+00:00	listed 3	Geraldine Moriba 117450730	2020-10-30T00:44:37+00:00	75
3,168183999,2020-10-30T00:44:37+00:00	listed 3	Peter DiCampo 168183999	2020-10-30T00:44:37+00:00	156
3,180388029,2020-10-30T00:44:37+00:00	listed 3	agg 180388029	2020-10-30T00:44:37+00:00	27
3,184814522,2020-10-30T00:44:37+00:00	listed 3	Lisa Rossi 184814522	2020-10-30T00:44:37+00:00	133
3,187718921,2020-10-30T00:44:37+00:00	listed 3	Katie Palmer 187718921	2020-10-30T00:44:37+00:00	158
3,195493353,2020-10-30T00:44:37+00:00	listed 3	Benjamin Petit 195493353	2020-10-30T00:44:37+00:00	31
3,213689248,2020-10-30T00:44:37+00:00	listed 3	Dr. Seema Yasmin 213689248	2020-10-30T00:44:37+00:00	1272
3,225293034,2020-10-30T00:44:37+00:00	listed 3	Damien is The Antichris Horne 225293034	2020-10-30T00:44:37+00:00	75
3,250010900,2020-10-30T00:44:37+00:00	listed 3	Julie Makinen 250010900	2020-10-30T00:44:37+00:00	339
3,263734042,2020-10-30T00:44:37+00:00	listed 3	Dustin Bleizeffer 263734042	2020-10-30T00:44:37+00:00	133
3,275541233,2020-10-30T00:44:37+00:00	listed 3	Veronica Chambers 275541233	2020-10-30T00:44:37+00:00	168
3,293673969,2020-10-30T00:44:37+00:00	listed 3	Cécile Prieur 293673969	2020-10-30T00:44:37+00:00	283
3,316717535,2020-10-30T00:44:37+00:00	listed 3	Sarah Shourd 316717535	2020-10-30T00:44:37+00:00	122
3,388030023,2020-10-30T00:44:37+00:00	listed 3	Katherine A Rowlands 388030023	2020-10-30T00:44:37+00:00	165
3,556757858,2020-10-30T00:44:37+00:00	listed 3	Arif Elsaui 556757858	2020-10-30T00:44:37+00:00	12
3,627476459,2020-10-30T00:44:37+00:00	listed 3	Alina Fichter 627476459	2020-10-30T00:44:37+00:00	135
3,2281026164,2020-10-30T00:44:37+00:00	listed 3	Clara G Sueyro 2281026164	2020-10-30T00:44:37+00:00	29
3,2317636063,2020-10-30T00:44:37+00:00	listed 3	liza osetinskaya 2317636063	2020-10-30T00:44:37+00:00	51
3,2571132636,2020-10-30T00:44:37+00:00	listed 3	Barbara Maseda 2571132636	2020-10-30T00:44:37+00:00	173
3,4083799919,2020-10-30T00:44:37+00:00	listed 3	Joel Konopo 4083799919	2020-10-30T00:44:37+00:00	21
3,750919846330793984,2020-10-30T00:44:37+00:00	listed 3	YooHee Hong 750919846330793984	2020-10-30T00:44:37+00:00	3
3,1246761,2020-10-30T00:44:38+00:00	listed 3	Cindy Royal 1246761	2020-10-30T00:44:38+00:00	644
3,8441632,2020-10-30T00:44:38+00:00	listed 3	Burt Herman 8441632	2020-10-30T00:44:38+00:00	971
3,14130084,2020-10-30T00:44:38+00:00	listed 3	Shazna Nessa 14130084	2020-10-30T00:44:38+00:00	374
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

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