count_history

1,691 rows sorted by user

✎ View and edit SQL

This data as json, CSV (advanced)

datetime (date) ✖

Link type user ▼ datetime count
1,14699813,2020-10-30T00:44:40+00:00 followers 1 Zena Barakat 14699813 2020-10-30T00:44:40+00:00 2996
2,14699813,2020-10-30T00:44:40+00:00 friends 2 Zena Barakat 14699813 2020-10-30T00:44:40+00:00 2458
3,14699813,2020-10-30T00:44:40+00:00 listed 3 Zena Barakat 14699813 2020-10-30T00:44:40+00:00 114
1,14715942,2020-10-30T00:44:47+00:00 followers 1 Umbreen Bhatti 14715942 2020-10-30T00:44:47+00:00 1993
2,14715942,2020-10-30T00:44:47+00:00 friends 2 Umbreen Bhatti 14715942 2020-10-30T00:44:47+00:00 1754
3,14715942,2020-10-30T00:44:47+00:00 listed 3 Umbreen Bhatti 14715942 2020-10-30T00:44:47+00:00 112
1,14716014,2020-10-30T00:44:37+00:00 followers 1 Laura Hertzfeld 14716014 2020-10-30T00:44:37+00:00 3387
2,14716014,2020-10-30T00:44:37+00:00 friends 2 Laura Hertzfeld 14716014 2020-10-30T00:44:37+00:00 1793
3,14716014,2020-10-30T00:44:37+00:00 listed 3 Laura Hertzfeld 14716014 2020-10-30T00:44:37+00:00 178
1,14735654,2020-10-30T00:44:51+00:00 followers 1 Michelle Johnson 14735654 2020-10-30T00:44:51+00:00 1704
2,14735654,2020-10-30T00:44:51+00:00 friends 2 Michelle Johnson 14735654 2020-10-30T00:44:51+00:00 647
3,14735654,2020-10-30T00:44:51+00:00 listed 3 Michelle Johnson 14735654 2020-10-30T00:44:51+00:00 129
1,14743741,2020-10-30T00:44:48+00:00 followers 1 federica bianchi 14743741 2020-10-30T00:44:48+00:00 1030
2,14743741,2020-10-30T00:44:48+00:00 friends 2 federica bianchi 14743741 2020-10-30T00:44:48+00:00 848
3,14743741,2020-10-30T00:44:48+00:00 listed 3 federica bianchi 14743741 2020-10-30T00:44:48+00:00 35
1,14766481,2020-10-30T00:44:41+00:00 followers 1 RODRIGOCARPIO 14766481 2020-10-30T00:44:41+00:00 60
2,14766481,2020-10-30T00:44:41+00:00 friends 2 RODRIGOCARPIO 14766481 2020-10-30T00:44:41+00:00 425
3,14766481,2020-10-30T00:44:41+00:00 listed 3 RODRIGOCARPIO 14766481 2020-10-30T00:44:41+00:00 3
1,14769899,2020-10-30T00:44:43+00:00 followers 1 TimJohnson 14769899 2020-10-30T00:44:43+00:00 5240
2,14769899,2020-10-30T00:44:43+00:00 friends 2 TimJohnson 14769899 2020-10-30T00:44:43+00:00 770
3,14769899,2020-10-30T00:44:43+00:00 listed 3 TimJohnson 14769899 2020-10-30T00:44:43+00:00 335
1,14849874,2020-10-30T00:44:44+00:00 followers 1 Matt Crenson 14849874 2020-10-30T00:44:44+00:00 189
2,14849874,2020-10-30T00:44:44+00:00 friends 2 Matt Crenson 14849874 2020-10-30T00:44:44+00:00 137
3,14849874,2020-10-30T00:44:44+00:00 listed 3 Matt Crenson 14849874 2020-10-30T00:44:44+00:00 11
1,14908497,2020-10-30T00:44:43+00:00 followers 1 luzmariahelguero 14908497 2020-10-30T00:44:43+00:00 851
2,14908497,2020-10-30T00:44:43+00:00 friends 2 luzmariahelguero 14908497 2020-10-30T00:44:43+00:00 670
3,14908497,2020-10-30T00:44:43+00:00 listed 3 luzmariahelguero 14908497 2020-10-30T00:44:43+00:00 12
1,14947379,2020-10-30T00:44:47+00:00 followers 1 Tran Ha 14947379 2020-10-30T00:44:47+00:00 2472
2,14947379,2020-10-30T00:44:47+00:00 friends 2 Tran Ha 14947379 2020-10-30T00:44:47+00:00 1260
3,14947379,2020-10-30T00:44:47+00:00 listed 3 Tran Ha 14947379 2020-10-30T00:44:47+00:00 161
1,14968475,2020-10-30T00:44:40+00:00 followers 1 Dan Jurafsky 14968475 2020-10-30T00:44:40+00:00 19245
2,14968475,2020-10-30T00:44:40+00:00 friends 2 Dan Jurafsky 14968475 2020-10-30T00:44:40+00:00 282
3,14968475,2020-10-30T00:44:40+00:00 listed 3 Dan Jurafsky 14968475 2020-10-30T00:44:40+00:00 475
1,14984915,2020-10-30T00:44:46+00:00 followers 1 Andrew Haeg 14984915 2020-10-30T00:44:46+00:00 4958
2,14984915,2020-10-30T00:44:46+00:00 friends 2 Andrew Haeg 14984915 2020-10-30T00:44:46+00:00 5009
3,14984915,2020-10-30T00:44:46+00:00 listed 3 Andrew Haeg 14984915 2020-10-30T00:44:46+00:00 408
1,14985683,2020-10-30T00:44:38+00:00 followers 1 Jigar Mehta 14985683 2020-10-30T00:44:38+00:00 3619
2,14985683,2020-10-30T00:44:38+00:00 friends 2 Jigar Mehta 14985683 2020-10-30T00:44:38+00:00 1476
3,14985683,2020-10-30T00:44:38+00:00 listed 3 Jigar Mehta 14985683 2020-10-30T00:44:38+00:00 228
1,15035816,2020-10-30T00:44:51+00:00 followers 1 Tomoko Hosaka Mullaney 15035816 2020-10-30T00:44:51+00:00 14359
2,15035816,2020-10-30T00:44:51+00:00 friends 2 Tomoko Hosaka Mullaney 15035816 2020-10-30T00:44:51+00:00 3590
3,15035816,2020-10-30T00:44:51+00:00 listed 3 Tomoko Hosaka Mullaney 15035816 2020-10-30T00:44:51+00:00 1137
1,15120110,2020-10-30T00:44:51+00:00 followers 1 Paul Raeburn 15120110 2020-10-30T00:44:51+00:00 3902
2,15120110,2020-10-30T00:44:51+00:00 friends 2 Paul Raeburn 15120110 2020-10-30T00:44:51+00:00 648
3,15120110,2020-10-30T00:44:51+00:00 listed 3 Paul Raeburn 15120110 2020-10-30T00:44:51+00:00 228
1,15220720,2020-10-30T00:44:39+00:00 followers 1 Steve Grove 15220720 2020-10-30T00:44:39+00:00 12498
2,15220720,2020-10-30T00:44:39+00:00 friends 2 Steve Grove 15220720 2020-10-30T00:44:39+00:00 2888
3,15220720,2020-10-30T00:44:39+00:00 listed 3 Steve Grove 15220720 2020-10-30T00:44:39+00:00 508
1,15315979,2020-10-30T00:44:38+00:00 followers 1 Carolina Guerrero 15315979 2020-10-30T00:44:38+00:00 15419
2,15315979,2020-10-30T00:44:38+00:00 friends 2 Carolina Guerrero 15315979 2020-10-30T00:44:38+00:00 4134
3,15315979,2020-10-30T00:44:38+00:00 listed 3 Carolina Guerrero 15315979 2020-10-30T00:44:38+00:00 279
1,15348391,2020-10-30T00:44:51+00:00 followers 1 AirBeano 15348391 2020-10-30T00:44:51+00:00 38
2,15348391,2020-10-30T00:44:51+00:00 friends 2 AirBeano 15348391 2020-10-30T00:44:51+00:00 571
3,15348391,2020-10-30T00:44:51+00:00 listed 3 AirBeano 15348391 2020-10-30T00:44:51+00:00 2
1,15587316,2020-10-30T00:44:41+00:00 followers 1 JocelynNoveckAP 15587316 2020-10-30T00:44:41+00:00 867
2,15587316,2020-10-30T00:44:41+00:00 friends 2 JocelynNoveckAP 15587316 2020-10-30T00:44:41+00:00 250
3,15587316,2020-10-30T00:44:41+00:00 listed 3 JocelynNoveckAP 15587316 2020-10-30T00:44:41+00:00 49
1,15607854,2020-10-30T00:44:41+00:00 followers 1 MarshaMcFadden 15607854 2020-10-30T00:44:41+00:00 228
2,15607854,2020-10-30T00:44:41+00:00 friends 2 MarshaMcFadden 15607854 2020-10-30T00:44:41+00:00 572
3,15607854,2020-10-30T00:44:41+00:00 listed 3 MarshaMcFadden 15607854 2020-10-30T00:44:41+00:00 13
1,15674801,2020-10-30T00:44:36+00:00 followers 1 Emilio Garcia-Ruiz 15674801 2020-10-30T00:44:36+00:00 5362
2,15674801,2020-10-30T00:44:36+00:00 friends 2 Emilio Garcia-Ruiz 15674801 2020-10-30T00:44:36+00:00 583
3,15674801,2020-10-30T00:44:36+00:00 listed 3 Emilio Garcia-Ruiz 15674801 2020-10-30T00:44:36+00:00 219
1,15751494,2020-10-30T00:44:42+00:00 followers 1 Roberta Oster 15751494 2020-10-30T00:44:42+00:00 405
2,15751494,2020-10-30T00:44:42+00:00 friends 2 Roberta Oster 15751494 2020-10-30T00:44:42+00:00 835
3,15751494,2020-10-30T00:44:42+00:00 listed 3 Roberta Oster 15751494 2020-10-30T00:44:42+00:00 13
1,15900236,2020-10-30T00:44:42+00:00 followers 1 Harriet A.Washington 15900236 2020-10-30T00:44:42+00:00 5650
2,15900236,2020-10-30T00:44:42+00:00 friends 2 Harriet A.Washington 15900236 2020-10-30T00:44:42+00:00 799
3,15900236,2020-10-30T00:44:42+00:00 listed 3 Harriet A.Washington 15900236 2020-10-30T00:44:42+00:00 77
1,15906933,2020-10-30T00:44:47+00:00 followers 1 Danyel Smith 15906933 2020-10-30T00:44:47+00:00 37569
2,15906933,2020-10-30T00:44:47+00:00 friends 2 Danyel Smith 15906933 2020-10-30T00:44:47+00:00 7758
3,15906933,2020-10-30T00:44:47+00:00 listed 3 Danyel Smith 15906933 2020-10-30T00:44:47+00:00 1133
1,15967248,2020-10-30T00:44:48+00:00 followers 1 Justin Arenstein 15967248 2020-10-30T00:44:48+00:00 7603
2,15967248,2020-10-30T00:44:48+00:00 friends 2 Justin Arenstein 15967248 2020-10-30T00:44:48+00:00 2596
3,15967248,2020-10-30T00:44:48+00:00 listed 3 Justin Arenstein 15967248 2020-10-30T00:44:48+00:00 0
1,16018986,2020-10-30T00:44:37+00:00 followers 1 Brian EdwardsTiekert 16018986 2020-10-30T00:44:37+00:00 3423
2,16018986,2020-10-30T00:44:37+00:00 friends 2 Brian EdwardsTiekert 16018986 2020-10-30T00:44:37+00:00 1947
3,16018986,2020-10-30T00:44:37+00:00 listed 3 Brian EdwardsTiekert 16018986 2020-10-30T00:44:37+00:00 86
1,16141134,2020-10-30T00:44:37+00:00 followers 1 hrv 16141134 2020-10-30T00:44:37+00:00 3938
2,16141134,2020-10-30T00:44:37+00:00 friends 2 hrv 16141134 2020-10-30T00:44:37+00:00 2234
3,16141134,2020-10-30T00:44:37+00:00 listed 3 hrv 16141134 2020-10-30T00:44:37+00:00 111
1,16212914,2020-10-30T00:44:36+00:00 followers 1 Natalia Mazotte 16212914 2020-10-30T00:44:36+00:00 6143
2,16212914,2020-10-30T00:44:36+00:00 friends 2 Natalia Mazotte 16212914 2020-10-30T00:44:36+00:00 2700
3,16212914,2020-10-30T00:44:36+00:00 listed 3 Natalia Mazotte 16212914 2020-10-30T00:44:36+00:00 205
1,16248718,2020-10-30T00:44:36+00:00 followers 1 LisaHsia 16248718 2020-10-30T00:44:36+00:00 1374
2,16248718,2020-10-30T00:44:36+00:00 friends 2 LisaHsia 16248718 2020-10-30T00:44:36+00:00 459
3,16248718,2020-10-30T00:44:36+00:00 listed 3 LisaHsia 16248718 2020-10-30T00:44:36+00:00 92
1,16259364,2020-10-30T00:44:39+00:00 followers 1 Michelle Holmes 16259364 2020-10-30T00:44:39+00:00 4655
2,16259364,2020-10-30T00:44:39+00:00 friends 2 Michelle Holmes 16259364 2020-10-30T00:44:39+00:00 3635
3,16259364,2020-10-30T00:44:39+00:00 listed 3 Michelle Holmes 16259364 2020-10-30T00:44:39+00:00 224
1,16288136,2020-10-30T00:44:48+00:00 followers 1 Melissa Chan 16288136 2020-10-30T00:44:48+00:00 75679
2,16288136,2020-10-30T00:44:48+00:00 friends 2 Melissa Chan 16288136 2020-10-30T00:44:48+00:00 2211
3,16288136,2020-10-30T00:44:48+00:00 listed 3 Melissa Chan 16288136 2020-10-30T00:44:48+00:00 1877
1,16291934,2020-10-30T00:44:49+00:00 followers 1 Society for News Design 16291934 2020-10-30T00:44:49+00:00 8784
2,16291934,2020-10-30T00:44:49+00:00 friends 2 Society for News Design 16291934 2020-10-30T00:44:49+00:00 1289
3,16291934,2020-10-30T00:44:49+00:00 listed 3 Society for News Design 16291934 2020-10-30T00:44:49+00:00 495
1,16295662,2020-10-30T00:44:49+00:00 followers 1 Alberto Ibarguen 16295662 2020-10-30T00:44:49+00:00 12897
2,16295662,2020-10-30T00:44:49+00:00 friends 2 Alberto Ibarguen 16295662 2020-10-30T00:44:49+00:00 2534
3,16295662,2020-10-30T00:44:49+00:00 listed 3 Alberto Ibarguen 16295662 2020-10-30T00:44:49+00:00 556
1,16350120,2020-10-30T00:44:46+00:00 followers 1 Claudia Nunez 16350120 2020-10-30T00:44:46+00:00 1428

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.843ms · About: simonw/jsk-fellows-on-twitter