count_history

4 rows where user = 30117765

View and edit SQL

Suggested facets: type, datetime, datetime (date)

Link type user datetime count
followers 1 Marcelo Rubens Paiva 30117765 2020-10-30T00:44:41+00:00 829945
followers 1 Marcelo Rubens Paiva 30117765 2020-10-30T00:44:51+00:00 829946
friends 2 Marcelo Rubens Paiva 30117765 2020-10-30T00:44:41+00:00 672
listed 3 Marcelo Rubens Paiva 30117765 2020-10-30T00:44:41+00:00 1088

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