count_history

562 rows where type = 2

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime, datetime (date)

Link type user datetime count
2,3219,2020-10-30T00:44:37+00:00 friends 2 Phillip Smith 3219 2020-10-30T00:44:37+00:00 4341
2,12497,2020-10-30T00:44:36+00:00 friends 2 Simon Willison 12497 2020-10-30T00:44:36+00:00 4245
2,29283,2020-10-30T00:44:39+00:00 friends 2 Steve Rhodes 29283 2020-10-30T00:44:39+00:00 11305
2,770729,2020-10-30T00:44:39+00:00 friends 2 Liz Gannes 770729 2020-10-30T00:44:39+00:00 2906
2,783324,2020-10-30T00:44:39+00:00 friends 2 Dave Maass πŸ”¦ 783324 2020-10-30T00:44:39+00:00 1012
2,1169521,2020-10-30T00:44:39+00:00 friends 2 Eric Cheng 1169521 2020-10-30T00:44:39+00:00 1199
2,1246761,2020-10-30T00:44:38+00:00 friends 2 Cindy Royal 1246761 2020-10-30T00:44:38+00:00 2206
2,1545741,2020-10-30T00:44:43+00:00 friends 2 Elizabeth Osder 1545741 2020-10-30T00:44:43+00:00 968
2,2241921,2020-10-30T00:44:36+00:00 friends 2 Pamela Chen πŸ™‹πŸ»β€β™€οΈπŸ€¦πŸ»β€β™€οΈ 2241921 2020-10-30T00:44:36+00:00 1225
2,2400471,2020-10-30T00:44:46+00:00 friends 2 Kaizar Campwala 2400471 2020-10-30T00:44:46+00:00 604
2,5202671,2020-10-30T00:44:49+00:00 friends 2 Martyn Williams 5202671 2020-10-30T00:44:49+00:00 900
2,6181532,2020-10-30T00:44:39+00:00 friends 2 Michael Morisy 6181532 2020-10-30T00:44:39+00:00 9331
2,6199412,2020-10-30T00:44:36+00:00 friends 2 Jim Colgan 6199412 2020-10-30T00:44:36+00:00 2277
2,6278622,2020-10-30T00:44:51+00:00 friends 2 Kathy Kiely 6278622 2020-10-30T00:44:51+00:00 1017
2,6304662,2020-10-30T00:44:39+00:00 friends 2 David Cohn 6304662 2020-10-30T00:44:39+00:00 2068
2,6423572,2020-10-30T00:44:37+00:00 friends 2 Tom Van de Weghe 6423572 2020-10-30T00:44:37+00:00 913
2,6819732,2020-10-30T00:44:50+00:00 friends 2 NAHJ 6819732 2020-10-30T00:44:50+00:00 10996
2,6827702,2020-10-30T00:44:37+00:00 friends 2 AndrΓ© Natta 6827702 2020-10-30T00:44:37+00:00 1883
2,7068802,2020-10-30T00:44:48+00:00 friends 2 Marie C Beuth 7068802 2020-10-30T00:44:48+00:00 933
2,7380872,2020-10-30T00:44:40+00:00 friends 2 Anne Kornblut 7380872 2020-10-30T00:44:40+00:00 690
2,7805322,2020-10-30T00:44:50+00:00 friends 2 Rosental 7805322 2020-10-30T00:44:50+00:00 1327
2,7809252,2020-10-30T00:44:51+00:00 friends 2 wendy norris 7809252 2020-10-30T00:44:51+00:00 4151
2,7832552,2020-10-30T00:44:36+00:00 friends 2 Kinsey Wilson 7832552 2020-10-30T00:44:36+00:00 301
2,8119452,2020-10-30T00:44:45+00:00 friends 2 πŸ’€ damned sinker πŸ’€ 8119452 2020-10-30T00:44:45+00:00 4171
2,8143682,2020-10-30T00:44:40+00:00 friends 2 Jure Leskovec 8143682 2020-10-30T00:44:40+00:00 291
2,8441632,2020-10-30T00:44:38+00:00 friends 2 Burt Herman 8441632 2020-10-30T00:44:38+00:00 1964
2,8839152,2020-10-30T00:44:39+00:00 friends 2 Matt Waite 8839152 2020-10-30T00:44:39+00:00 1589
2,8956962,2020-10-30T00:44:48+00:00 friends 2 Kirk Caraway 8956962 2020-10-30T00:44:48+00:00 305
2,9078442,2020-10-30T00:44:39+00:00 friends 2 Greg Agvent 9078442 2020-10-30T00:44:39+00:00 292
2,9342312,2020-10-30T00:44:40+00:00 friends 2 Fred Turner 9342312 2020-10-30T00:44:40+00:00 567
2,9443532,2020-10-30T00:44:45+00:00 friends 2 Rick Attig 9443532 2020-10-30T00:44:45+00:00 270
2,9486682,2020-10-30T00:44:45+00:00 friends 2 Ezequiel AbiΓΊ LΓ³pez 9486682 2020-10-30T00:44:45+00:00 324
2,9720702,2020-10-30T00:44:51+00:00 friends 2 Patricia Sullivan 9720702 2020-10-30T00:44:51+00:00 815
2,10587552,2020-10-30T00:44:40+00:00 friends 2 Michael Bernstein 10587552 2020-10-30T00:44:40+00:00 1465
2,10740662,2020-10-30T00:44:39+00:00 friends 2 Paul Egglestone 10740662 2020-10-30T00:44:39+00:00 974
2,10794392,2020-10-30T00:44:45+00:00 friends 2 Kathleen McCoy 10794392 2020-10-30T00:44:45+00:00 894
2,11579212,2020-10-30T00:44:51+00:00 friends 2 Steve Sternberg 11579212 2020-10-30T00:44:51+00:00 10444
2,11688592,2020-10-30T00:44:37+00:00 friends 2 Mandy Jenkins 11688592 2020-10-30T00:44:37+00:00 2765
2,12655722,2020-10-30T00:44:50+00:00 friends 2 IRE and NICAR 12655722 2020-10-30T00:44:50+00:00 711
2,12956682,2020-10-30T00:44:48+00:00 friends 2 David Sarno 12956682 2020-10-30T00:44:48+00:00 1512
2,13371202,2020-10-30T00:44:47+00:00 friends 2 john temple 13371202 2020-10-30T00:44:47+00:00 559
2,13575602,2020-10-30T00:44:35+00:00 friends 2 Aparna Mukherjee 13575602 2020-10-30T00:44:35+00:00 5001
2,13690462,2020-10-30T00:44:43+00:00 friends 2 Bonnie D. Ford 13690462 2020-10-30T00:44:43+00:00 652
2,13745872,2020-10-30T00:44:50+00:00 friends 2 Online News Association 13745872 2020-10-30T00:44:50+00:00 8183
2,14073364,2020-10-30T00:44:50+00:00 friends 2 Knight Foundation 14073364 2020-10-30T00:44:50+00:00 3439
2,14080017,2020-10-30T00:44:48+00:00 friends 2 Gabriel Sama 14080017 2020-10-30T00:44:48+00:00 4175
2,14104554,2020-10-30T00:44:37+00:00 friends 2 Tim Regan-Porter 14104554 2020-10-30T00:44:37+00:00 16140
2,14124402,2020-10-30T00:44:48+00:00 friends 2 Pedro Doria πŸ‡§πŸ‡·πŸ˜· 14124402 2020-10-30T00:44:48+00:00 1975
2,14130084,2020-10-30T00:44:38+00:00 friends 2 Shazna Nessa 14130084 2020-10-30T00:44:38+00:00 1060
2,14140617,2020-10-30T00:44:39+00:00 friends 2 Bay Area Video Coalition 14140617 2020-10-30T00:44:39+00:00 2911
2,14145296,2020-10-30T00:44:39+00:00 friends 2 Susie Cagle 14145296 2020-10-30T00:44:39+00:00 2692
2,14173930,2020-10-30T00:44:37+00:00 friends 2 stacy-marie ishmael 14173930 2020-10-30T00:44:37+00:00 9836
2,14192329,2020-10-30T00:44:36+00:00 friends 2 Karen Wickre β˜•οΈπŸ’»πŸ‘€ 14192329 2020-10-30T00:44:36+00:00 4965
2,14282158,2020-10-30T00:44:48+00:00 friends 2 Chris Allbritton 14282158 2020-10-30T00:44:48+00:00 1886
2,14305753,2020-10-30T00:44:36+00:00 friends 2 π™Ÿπ™€π™¨π™š 𝙯𝙖𝙒𝙀𝙧𝙖 14305753 2020-10-30T00:44:36+00:00 3740
2,14324734,2020-10-30T00:44:51+00:00 friends 2 Phil Trounstine 14324734 2020-10-30T00:44:51+00:00 134
2,14335332,2020-10-30T00:44:40+00:00 friends 2 Dan Nguyen »»» 14335332 2020-10-30T00:44:40+00:00 7103
2,14370540,2020-10-30T00:44:39+00:00 friends 2 jeremyhay 14370540 2020-10-30T00:44:39+00:00 853
2,14381600,2020-10-30T00:44:38+00:00 friends 2 Tracie Powell 14381600 2020-10-30T00:44:38+00:00 3330
2,14426743,2020-10-30T00:44:38+00:00 friends 2 jrbettinger 14426743 2020-10-30T00:44:38+00:00 239
2,14478614,2020-10-30T00:44:48+00:00 friends 2 Jeff Elder 14478614 2020-10-30T00:44:48+00:00 13602
2,14573694,2020-10-30T00:44:46+00:00 friends 2 Ann Grimes 14573694 2020-10-30T00:44:46+00:00 643
2,14590178,2020-10-30T00:44:49+00:00 friends 2 Michael V. Marcotte 14590178 2020-10-30T00:44:49+00:00 1924
2,14602589,2020-10-30T00:44:50+00:00 friends 2 aaja 14602589 2020-10-30T00:44:50+00:00 4246
2,14615604,2020-10-30T00:44:45+00:00 friends 2 Denis RB 14615604 2020-10-30T00:44:45+00:00 1295
2,14636665,2020-10-30T00:44:37+00:00 friends 2 Flor Coelho 14636665 2020-10-30T00:44:37+00:00 7140
2,14699813,2020-10-30T00:44:40+00:00 friends 2 Zena Barakat 14699813 2020-10-30T00:44:40+00:00 2458
2,14715942,2020-10-30T00:44:47+00:00 friends 2 Umbreen Bhatti 14715942 2020-10-30T00:44:47+00:00 1754
2,14716014,2020-10-30T00:44:37+00:00 friends 2 Laura Hertzfeld 14716014 2020-10-30T00:44:37+00:00 1793
2,14735654,2020-10-30T00:44:51+00:00 friends 2 Michelle Johnson 14735654 2020-10-30T00:44:51+00:00 647
2,14743741,2020-10-30T00:44:48+00:00 friends 2 federica bianchi 14743741 2020-10-30T00:44:48+00:00 848
2,14766481,2020-10-30T00:44:41+00:00 friends 2 RODRIGOCARPIO 14766481 2020-10-30T00:44:41+00:00 425
2,14769899,2020-10-30T00:44:43+00:00 friends 2 TimJohnson 14769899 2020-10-30T00:44:43+00:00 770
2,14849874,2020-10-30T00:44:44+00:00 friends 2 Matt Crenson 14849874 2020-10-30T00:44:44+00:00 137
2,14908497,2020-10-30T00:44:43+00:00 friends 2 luzmariahelguero 14908497 2020-10-30T00:44:43+00:00 670
2,14947379,2020-10-30T00:44:47+00:00 friends 2 Tran Ha 14947379 2020-10-30T00:44:47+00:00 1260
2,14968475,2020-10-30T00:44:40+00:00 friends 2 Dan Jurafsky 14968475 2020-10-30T00:44:40+00:00 282
2,14984915,2020-10-30T00:44:46+00:00 friends 2 Andrew Haeg 14984915 2020-10-30T00:44:46+00:00 5009
2,14985683,2020-10-30T00:44:38+00:00 friends 2 Jigar Mehta 14985683 2020-10-30T00:44:38+00:00 1476
2,15035816,2020-10-30T00:44:51+00:00 friends 2 Tomoko Hosaka Mullaney 15035816 2020-10-30T00:44:51+00:00 3590
2,15120110,2020-10-30T00:44:51+00:00 friends 2 Paul Raeburn 15120110 2020-10-30T00:44:51+00:00 648
2,15220720,2020-10-30T00:44:39+00:00 friends 2 Steve Grove 15220720 2020-10-30T00:44:39+00:00 2888
2,15315979,2020-10-30T00:44:38+00:00 friends 2 Carolina Guerrero 15315979 2020-10-30T00:44:38+00:00 4134
2,15348391,2020-10-30T00:44:51+00:00 friends 2 AirBeano 15348391 2020-10-30T00:44:51+00:00 571
2,15587316,2020-10-30T00:44:41+00:00 friends 2 JocelynNoveckAP 15587316 2020-10-30T00:44:41+00:00 250
2,15607854,2020-10-30T00:44:41+00:00 friends 2 MarshaMcFadden 15607854 2020-10-30T00:44:41+00:00 572
2,15674801,2020-10-30T00:44:36+00:00 friends 2 Emilio Garcia-Ruiz 15674801 2020-10-30T00:44:36+00:00 583
2,15751494,2020-10-30T00:44:42+00:00 friends 2 Roberta Oster 15751494 2020-10-30T00:44:42+00:00 835
2,15900236,2020-10-30T00:44:42+00:00 friends 2 Harriet A.Washington 15900236 2020-10-30T00:44:42+00:00 799
2,15906933,2020-10-30T00:44:47+00:00 friends 2 Danyel Smith 15906933 2020-10-30T00:44:47+00:00 7758
2,15967248,2020-10-30T00:44:48+00:00 friends 2 Justin Arenstein 15967248 2020-10-30T00:44:48+00:00 2596
2,16018986,2020-10-30T00:44:37+00:00 friends 2 Brian EdwardsTiekert 16018986 2020-10-30T00:44:37+00:00 1947
2,16141134,2020-10-30T00:44:37+00:00 friends 2 hrv 16141134 2020-10-30T00:44:37+00:00 2234
2,16212914,2020-10-30T00:44:36+00:00 friends 2 Natalia Mazotte 16212914 2020-10-30T00:44:36+00:00 2700
2,16248718,2020-10-30T00:44:36+00:00 friends 2 LisaHsia 16248718 2020-10-30T00:44:36+00:00 459
2,16259364,2020-10-30T00:44:39+00:00 friends 2 Michelle Holmes 16259364 2020-10-30T00:44:39+00:00 3635
2,16288136,2020-10-30T00:44:48+00:00 friends 2 Melissa Chan 16288136 2020-10-30T00:44:48+00:00 2211
2,16291934,2020-10-30T00:44:49+00:00 friends 2 Society for News Design 16291934 2020-10-30T00:44:49+00:00 1289
2,16295662,2020-10-30T00:44:49+00:00 friends 2 Alberto Ibarguen 16295662 2020-10-30T00:44:49+00:00 2534
2,16350120,2020-10-30T00:44:46+00:00 friends 2 Claudia Nunez 16350120 2020-10-30T00:44:46+00:00 1166

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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])
);
Powered by Datasette · Query took 12.513ms · About: simonw/jsk-fellows-on-twitter