count_history

1,691 rows sorted by datetime descending

✎ View and edit SQL

This data as json, CSV (advanced)

type ✖

Link type user datetime ▲ count
1,6819732,2020-10-30T00:44:50+00:00 followers 1 NAHJ 6819732 2020-10-30T00:44:50+00:00 34217
1,7805322,2020-10-30T00:44:50+00:00 followers 1 Rosental 7805322 2020-10-30T00:44:50+00:00 28097
1,12655722,2020-10-30T00:44:50+00:00 followers 1 IRE and NICAR 12655722 2020-10-30T00:44:50+00:00 35319
1,13745872,2020-10-30T00:44:50+00:00 followers 1 Online News Association 13745872 2020-10-30T00:44:50+00:00 57314
1,14073364,2020-10-30T00:44:50+00:00 followers 1 Knight Foundation 14073364 2020-10-30T00:44:50+00:00 153569
1,14602589,2020-10-30T00:44:50+00:00 followers 1 aaja 14602589 2020-10-30T00:44:50+00:00 18953
2,6819732,2020-10-30T00:44:50+00:00 friends 2 NAHJ 6819732 2020-10-30T00:44:50+00:00 10996
2,7805322,2020-10-30T00:44:50+00:00 friends 2 Rosental 7805322 2020-10-30T00:44:50+00:00 1327
2,12655722,2020-10-30T00:44:50+00:00 friends 2 IRE and NICAR 12655722 2020-10-30T00:44:50+00:00 711
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,14602589,2020-10-30T00:44:50+00:00 friends 2 aaja 14602589 2020-10-30T00:44:50+00:00 4246
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
1,5202671,2020-10-30T00:44:49+00:00 followers 1 Martyn Williams 5202671 2020-10-30T00:44:49+00:00 24339
1,14590178,2020-10-30T00:44:49+00:00 followers 1 Michael V. Marcotte 14590178 2020-10-30T00:44:49+00:00 1176
1,16291934,2020-10-30T00:44:49+00:00 followers 1 Society for News Design 16291934 2020-10-30T00:44:49+00:00 8784
1,16295662,2020-10-30T00:44:49+00:00 followers 1 Alberto Ibarguen 16295662 2020-10-30T00:44:49+00:00 12897
1,16616757,2020-10-30T00:44:49+00:00 followers 1 IJNet 16616757 2020-10-30T00:44:49+00:00 43360
1,17272464,2020-10-30T00:44:49+00:00 followers 1 aaronhuey 17272464 2020-10-30T00:44:49+00:00 3683
1,17808151,2020-10-30T00:44:49+00:00 followers 1 ICFJ 17808151 2020-10-30T00:44:49+00:00 66829
1,22257074,2020-10-30T00:44:49+00:00 followers 1 Eric Newton 22257074 2020-10-30T00:44:49+00:00 3483
1,22552271,2020-10-30T00:44:49+00:00 followers 1 News Leaders Association 22552271 2020-10-30T00:44:49+00:00 8562
1,24164338,2020-10-30T00:44:49+00:00 followers 1 NABJ Headquarters | NABJ.org 24164338 2020-10-30T00:44:49+00:00 45397
1,39021657,2020-10-30T00:44:49+00:00 followers 1 Anita Zielina 39021657 2020-10-30T00:44:49+00:00 46520
1,46518958,2020-10-30T00:44:49+00:00 followers 1 Chloe Veltman 46518958 2020-10-30T00:44:49+00:00 2187
1,86152476,2020-10-30T00:44:49+00:00 followers 1 Masood Farivar 86152476 2020-10-30T00:44:49+00:00 6809
1,108360053,2020-10-30T00:44:49+00:00 followers 1 Judith Torrea 108360053 2020-10-30T00:44:49+00:00 7134
1,110638978,2020-10-30T00:44:49+00:00 followers 1 Hacks/Hackers 110638978 2020-10-30T00:44:49+00:00 17814
1,110905920,2020-10-30T00:44:49+00:00 followers 1 wjchat 110905920 2020-10-30T00:44:49+00:00 8759
1,130596773,2020-10-30T00:44:49+00:00 followers 1 Global Investigative Journalism Network 130596773 2020-10-30T00:44:49+00:00 56389
1,141222005,2020-10-30T00:44:49+00:00 followers 1 Teresa Bouza 141222005 2020-10-30T00:44:49+00:00 1026
1,148420961,2020-10-30T00:44:49+00:00 followers 1 Justin Ferrell 148420961 2020-10-30T00:44:49+00:00 3882
1,159616650,2020-10-30T00:44:49+00:00 followers 1 JAWS 159616650 2020-10-30T00:44:49+00:00 15010
1,200120015,2020-10-30T00:44:49+00:00 followers 1 Katy Newton 200120015 2020-10-30T00:44:49+00:00 793
1,254874238,2020-10-30T00:44:49+00:00 followers 1 Jorge R. Imbaquingo 254874238 2020-10-30T00:44:49+00:00 3088
1,386183180,2020-10-30T00:44:49+00:00 followers 1 Girma T Fantaye 386183180 2020-10-30T00:44:49+00:00 1229
1,418837047,2020-10-30T00:44:49+00:00 followers 1 Matter. 418837047 2020-10-30T00:44:49+00:00 7121
1,2464050332,2020-10-30T00:44:49+00:00 followers 1 SRCCON 2464050332 2020-10-30T00:44:49+00:00 3096
1,3245142196,2020-10-30T00:44:49+00:00 followers 1 Google News Initiative 3245142196 2020-10-30T00:44:49+00:00 111446
1,3314775459,2020-10-30T00:44:49+00:00 followers 1 First Draft 3314775459 2020-10-30T00:44:49+00:00 32047
2,5202671,2020-10-30T00:44:49+00:00 friends 2 Martyn Williams 5202671 2020-10-30T00:44:49+00:00 900
2,14590178,2020-10-30T00:44:49+00:00 friends 2 Michael V. Marcotte 14590178 2020-10-30T00:44:49+00:00 1924
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,16616757,2020-10-30T00:44:49+00:00 friends 2 IJNet 16616757 2020-10-30T00:44:49+00:00 1735
2,17272464,2020-10-30T00:44:49+00:00 friends 2 aaronhuey 17272464 2020-10-30T00:44:49+00:00 326
2,17808151,2020-10-30T00:44:49+00:00 friends 2 ICFJ 17808151 2020-10-30T00:44:49+00:00 1782
2,22257074,2020-10-30T00:44:49+00:00 friends 2 Eric Newton 22257074 2020-10-30T00:44:49+00:00 2772
2,22552271,2020-10-30T00:44:49+00:00 friends 2 News Leaders Association 22552271 2020-10-30T00:44:49+00:00 1118
2,24164338,2020-10-30T00:44:49+00:00 friends 2 NABJ Headquarters | NABJ.org 24164338 2020-10-30T00:44:49+00:00 3696
2,39021657,2020-10-30T00:44:49+00:00 friends 2 Anita Zielina 39021657 2020-10-30T00:44:49+00:00 4387
2,46518958,2020-10-30T00:44:49+00:00 friends 2 Chloe Veltman 46518958 2020-10-30T00:44:49+00:00 741
2,86152476,2020-10-30T00:44:49+00:00 friends 2 Masood Farivar 86152476 2020-10-30T00:44:49+00:00 5537
2,108360053,2020-10-30T00:44:49+00:00 friends 2 Judith Torrea 108360053 2020-10-30T00:44:49+00:00 7164
2,110638978,2020-10-30T00:44:49+00:00 friends 2 Hacks/Hackers 110638978 2020-10-30T00:44:49+00:00 522
2,110905920,2020-10-30T00:44:49+00:00 friends 2 wjchat 110905920 2020-10-30T00:44:49+00:00 0
2,130596773,2020-10-30T00:44:49+00:00 friends 2 Global Investigative Journalism Network 130596773 2020-10-30T00:44:49+00:00 5411
2,141222005,2020-10-30T00:44:49+00:00 friends 2 Teresa Bouza 141222005 2020-10-30T00:44:49+00:00 868
2,148420961,2020-10-30T00:44:49+00:00 friends 2 Justin Ferrell 148420961 2020-10-30T00:44:49+00:00 1029
2,159616650,2020-10-30T00:44:49+00:00 friends 2 JAWS 159616650 2020-10-30T00:44:49+00:00 9230
2,200120015,2020-10-30T00:44:49+00:00 friends 2 Katy Newton 200120015 2020-10-30T00:44:49+00:00 469
2,254874238,2020-10-30T00:44:49+00:00 friends 2 Jorge R. Imbaquingo 254874238 2020-10-30T00:44:49+00:00 1344
2,386183180,2020-10-30T00:44:49+00:00 friends 2 Girma T Fantaye 386183180 2020-10-30T00:44:49+00:00 451
2,418837047,2020-10-30T00:44:49+00:00 friends 2 Matter. 418837047 2020-10-30T00:44:49+00:00 1505
2,2464050332,2020-10-30T00:44:49+00:00 friends 2 SRCCON 2464050332 2020-10-30T00:44:49+00:00 649
2,3245142196,2020-10-30T00:44:49+00:00 friends 2 Google News Initiative 3245142196 2020-10-30T00:44:49+00:00 229
2,3314775459,2020-10-30T00:44:49+00:00 friends 2 First Draft 3314775459 2020-10-30T00:44:49+00:00 1981
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
1,7068802,2020-10-30T00:44:48+00:00 followers 1 Marie C Beuth 7068802 2020-10-30T00:44:48+00:00 8697

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