count_history

562 rows where type = 3 sorted by datetime 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,6278622,2020-10-30T00:44:51+00:00	listed 3	Kathy Kiely 6278622	2020-10-30T00:44:51+00:00	132
3,7809252,2020-10-30T00:44:51+00:00	listed 3	wendy norris 7809252	2020-10-30T00:44:51+00:00	248
3,9720702,2020-10-30T00:44:51+00:00	listed 3	Patricia Sullivan 9720702	2020-10-30T00:44:51+00:00	144
3,11579212,2020-10-30T00:44:51+00:00	listed 3	Steve Sternberg 11579212	2020-10-30T00:44:51+00:00	737
3,14324734,2020-10-30T00:44:51+00:00	listed 3	Phil Trounstine 14324734	2020-10-30T00:44:51+00:00	43
3,14735654,2020-10-30T00:44:51+00:00	listed 3	Michelle Johnson 14735654	2020-10-30T00:44:51+00:00	129
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,15348391,2020-10-30T00:44:51+00:00	listed 3	AirBeano 15348391	2020-10-30T00:44:51+00:00	2
3,16450666,2020-10-30T00:44:51+00:00	listed 3	Kevin Weston 16450666	2020-10-30T00:44:51+00:00	15
3,17033026,2020-10-30T00:44:51+00:00	listed 3	Gabriela Mafort 17033026	2020-10-30T00:44:51+00:00	15
3,17188930,2020-10-30T00:44:51+00:00	listed 3	Nolu Crockett-Ntonga 17188930	2020-10-30T00:44:51+00:00	9
3,17690868,2020-10-30T00:44:51+00:00	listed 3	Nirmal Mitra 17690868	2020-10-30T00:44:51+00:00	10
3,17701416,2020-10-30T00:44:51+00:00	listed 3	Beth Duff-Brown 17701416	2020-10-30T00:44:51+00:00	66
3,18741571,2020-10-30T00:44:51+00:00	listed 3	VaughnPalmer 18741571	2020-10-30T00:44:51+00:00	659
3,20065842,2020-10-30T00:44:51+00:00	listed 3	Richard Knox 20065842	2020-10-30T00:44:51+00:00	356
3,20251052,2020-10-30T00:44:51+00:00	listed 3	Doug Stone 20251052	2020-10-30T00:44:51+00:00	9
3,20955208,2020-10-30T00:44:51+00:00	listed 3	BikeIntelligencer 20955208	2020-10-30T00:44:51+00:00	60
3,21399016,2020-10-30T00:44:51+00:00	listed 3	Ellen Shuman 21399016	2020-10-30T00:44:51+00:00	12
3,22362420,2020-10-30T00:44:51+00:00	listed 3	Gary Delsohn 22362420	2020-10-30T00:44:51+00:00	16
3,22543494,2020-10-30T00:44:51+00:00	listed 3	Allison Engel 22543494	2020-10-30T00:44:51+00:00	4
3,23757441,2020-10-30T00:44:51+00:00	listed 3	Hugo Rupert 23757441	2020-10-30T00:44:51+00:00	4
3,27469953,2020-10-30T00:44:51+00:00	listed 3	Lorraine Branham 27469953	2020-10-30T00:44:51+00:00	59
3,30037462,2020-10-30T00:44:51+00:00	listed 3	Chan Lowe 30037462	2020-10-30T00:44:51+00:00	116
3,36063042,2020-10-30T00:44:51+00:00	listed 3	Di Pinheiro 36063042	2020-10-30T00:44:51+00:00	21
3,41499730,2020-10-30T00:44:51+00:00	listed 3	Christy George 41499730	2020-10-30T00:44:51+00:00	11
3,54581810,2020-10-30T00:44:51+00:00	listed 3	Heather Dewar 54581810	2020-10-30T00:44:51+00:00	68
3,55364784,2020-10-30T00:44:51+00:00	listed 3	Peter Y. Sussman 55364784	2020-10-30T00:44:51+00:00	9
3,67707825,2020-10-30T00:44:51+00:00	listed 3	Eric V Taitjr 67707825	2020-10-30T00:44:51+00:00	1
3,103761767,2020-10-30T00:44:51+00:00	listed 3	Russell Skelton 103761767	2020-10-30T00:44:51+00:00	133
3,103779264,2020-10-30T00:44:51+00:00	listed 3	Robert Milliken 103779264	2020-10-30T00:44:51+00:00	9
3,106236010,2020-10-30T00:44:51+00:00	listed 3	Jaime Mantilla 106236010	2020-10-30T00:44:51+00:00	17
3,113442154,2020-10-30T00:44:51+00:00	listed 3	Gregory Graze 113442154	2020-10-30T00:44:51+00:00	4
3,138732826,2020-10-30T00:44:51+00:00	listed 3	Karelia Vázquez 138732826	2020-10-30T00:44:51+00:00	181
3,165426547,2020-10-30T00:44:51+00:00	listed 3	Jeremy Adam Smith 165426547	2020-10-30T00:44:51+00:00	157
3,197220475,2020-10-30T00:44:51+00:00	listed 3	Madhu Acharya 197220475	2020-10-30T00:44:51+00:00	29
3,203154161,2020-10-30T00:44:51+00:00	listed 3	Walter V Robinson 203154161	2020-10-30T00:44:51+00:00	137
3,209407086,2020-10-30T00:44:51+00:00	listed 3	Sylvester Monroe 209407086	2020-10-30T00:44:51+00:00	34
3,214990371,2020-10-30T00:44:51+00:00	listed 3	Duncan McCue 214990371	2020-10-30T00:44:51+00:00	395
3,254189881,2020-10-30T00:44:51+00:00	listed 3	Angelo Izama 254189881	2020-10-30T00:44:51+00:00	245
3,270984816,2020-10-30T00:44:51+00:00	listed 3	Klas Bergman 270984816	2020-10-30T00:44:51+00:00	14
3,327761500,2020-10-30T00:44:51+00:00	listed 3	Denise Clifton 327761500	2020-10-30T00:44:51+00:00	6
3,365005868,2020-10-30T00:44:51+00:00	listed 3	Bob Shaw 365005868	2020-10-30T00:44:51+00:00	21
3,376690985,2020-10-30T00:44:51+00:00	listed 3	Ulrik Haagerup 376690985	2020-10-30T00:44:51+00:00	172
3,400778798,2020-10-30T00:44:51+00:00	listed 3	Makena 400778798	2020-10-30T00:44:51+00:00	1
3,423733810,2020-10-30T00:44:51+00:00	listed 3	Klaus Weinmaier 423733810	2020-10-30T00:44:51+00:00	59
3,573764891,2020-10-30T00:44:51+00:00	listed 3	Brooke Gladstone 573764891	2020-10-30T00:44:51+00:00	689
3,915830820,2020-10-30T00:44:51+00:00	listed 3	Veikko Vuorikoski 915830820	2020-10-30T00:44:51+00:00	2
3,1168982911,2020-10-30T00:44:51+00:00	listed 3	Tunji Lardner 1168982911	2020-10-30T00:44:51+00:00	134
3,6819732,2020-10-30T00:44:50+00:00	listed 3	NAHJ 6819732	2020-10-30T00:44:50+00:00	897
3,7805322,2020-10-30T00:44:50+00:00	listed 3	Rosental 7805322	2020-10-30T00:44:50+00:00	1479
3,12655722,2020-10-30T00:44:50+00:00	listed 3	IRE and NICAR 12655722	2020-10-30T00:44:50+00:00	1540
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,14602589,2020-10-30T00:44:50+00:00	listed 3	aaja 14602589	2020-10-30T00:44:50+00:00	558
3,5202671,2020-10-30T00:44:49+00:00	listed 3	Martyn Williams 5202671	2020-10-30T00:44:49+00:00	1452
3,14590178,2020-10-30T00:44:49+00:00	listed 3	Michael V. Marcotte 14590178	2020-10-30T00:44:49+00:00	93
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,16616757,2020-10-30T00:44:49+00:00	listed 3	IJNet 16616757	2020-10-30T00:44:49+00:00	1506
3,17272464,2020-10-30T00:44:49+00:00	listed 3	aaronhuey 17272464	2020-10-30T00:44:49+00:00	149
3,17808151,2020-10-30T00:44:49+00:00	listed 3	ICFJ 17808151	2020-10-30T00:44:49+00:00	1985
3,22257074,2020-10-30T00:44:49+00:00	listed 3	Eric Newton 22257074	2020-10-30T00:44:49+00:00	249
3,22552271,2020-10-30T00:44:49+00:00	listed 3	News Leaders Association 22552271	2020-10-30T00:44:49+00:00	0
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,39021657,2020-10-30T00:44:49+00:00	listed 3	Anita Zielina 39021657	2020-10-30T00:44:49+00:00	810
3,46518958,2020-10-30T00:44:49+00:00	listed 3	Chloe Veltman 46518958	2020-10-30T00:44:49+00:00	128
3,86152476,2020-10-30T00:44:49+00:00	listed 3	Masood Farivar 86152476	2020-10-30T00:44:49+00:00	159
3,108360053,2020-10-30T00:44:49+00:00	listed 3	Judith Torrea 108360053	2020-10-30T00:44:49+00:00	369
3,110638978,2020-10-30T00:44:49+00:00	listed 3	Hacks/Hackers 110638978	2020-10-30T00:44:49+00:00	987
3,110905920,2020-10-30T00:44:49+00:00	listed 3	wjchat 110905920	2020-10-30T00:44:49+00:00	669
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,141222005,2020-10-30T00:44:49+00:00	listed 3	Teresa Bouza 141222005	2020-10-30T00:44:49+00:00	96
3,148420961,2020-10-30T00:44:49+00:00	listed 3	Justin Ferrell 148420961	2020-10-30T00:44:49+00:00	239
3,159616650,2020-10-30T00:44:49+00:00	listed 3	JAWS 159616650	2020-10-30T00:44:49+00:00	479
3,200120015,2020-10-30T00:44:49+00:00	listed 3	Katy Newton 200120015	2020-10-30T00:44:49+00:00	57
3,254874238,2020-10-30T00:44:49+00:00	listed 3	Jorge R. Imbaquingo 254874238	2020-10-30T00:44:49+00:00	74
3,386183180,2020-10-30T00:44:49+00:00	listed 3	Girma T Fantaye 386183180	2020-10-30T00:44:49+00:00	0
3,418837047,2020-10-30T00:44:49+00:00	listed 3	Matter. 418837047	2020-10-30T00:44:49+00:00	505
3,2464050332,2020-10-30T00:44:49+00:00	listed 3	SRCCON 2464050332	2020-10-30T00:44:49+00:00	116
3,3245142196,2020-10-30T00:44:49+00:00	listed 3	Google News Initiative 3245142196	2020-10-30T00:44:49+00:00	2229
3,3314775459,2020-10-30T00:44:49+00:00	listed 3	First Draft 3314775459	2020-10-30T00:44:49+00:00	1547
3,7068802,2020-10-30T00:44:48+00:00	listed 3	Marie C Beuth 7068802	2020-10-30T00:44:48+00:00	542
3,8956962,2020-10-30T00:44:48+00:00	listed 3	Kirk Caraway 8956962	2020-10-30T00:44:48+00:00	15
3,12956682,2020-10-30T00:44:48+00:00	listed 3	David Sarno 12956682	2020-10-30T00:44:48+00:00	454
3,14080017,2020-10-30T00:44:48+00:00	listed 3	Gabriel Sama 14080017	2020-10-30T00:44:48+00:00	481
3,14124402,2020-10-30T00:44:48+00:00	listed 3	Pedro Doria 🇧🇷😷 14124402	2020-10-30T00:44:48+00:00	1181
3,14282158,2020-10-30T00:44:48+00:00	listed 3	Chris Allbritton 14282158	2020-10-30T00:44:48+00:00	0
3,14478614,2020-10-30T00:44:48+00:00	listed 3	Jeff Elder 14478614	2020-10-30T00:44:48+00:00	1123
3,14743741,2020-10-30T00:44:48+00:00	listed 3	federica bianchi 14743741	2020-10-30T00:44:48+00:00	35
3,15967248,2020-10-30T00:44:48+00:00	listed 3	Justin Arenstein 15967248	2020-10-30T00:44:48+00:00	0
3,16288136,2020-10-30T00:44:48+00:00	listed 3	Melissa Chan 16288136	2020-10-30T00:44:48+00:00	1877
3,16613227,2020-10-30T00:44:48+00:00	listed 3	nunovargas 16613227	2020-10-30T00:44:48+00:00	322
3,16622367,2020-10-30T00:44:48+00:00	listed 3	Antonio Ruiz-Camacho 16622367	2020-10-30T00:44:48+00:00	71
3,16679508,2020-10-30T00:44:48+00:00	listed 3	Geri Smith 16679508	2020-10-30T00:44:48+00:00	52
3,16679681,2020-10-30T00:44:48+00:00	listed 3	Stephanie Banchero 16679681	2020-10-30T00:44:48+00:00	414
3,17290577,2020-10-30T00:44:48+00:00	listed 3	Diane Cardwell 17290577	2020-10-30T00:44:48+00:00	244
3,17677665,2020-10-30T00:44:48+00:00	listed 3	Geoff McGhee 17677665	2020-10-30T00:44:48+00:00	325
3,18231471,2020-10-30T00:44:48+00:00	listed 3	Andrew Finlayson 18231471	2020-10-30T00:44:48+00:00	91
3,18862139,2020-10-30T00:44:48+00:00	listed 3	maureenfan 18862139	2020-10-30T00:44:48+00:00	108

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