home / fediscrape

NodeinfoUsage

18 rows where server = 76

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: users_active_month

id ▼ server full_entry users_total users_active_half_year users_active_month local_posts local_comments
1787 Mbin.pl 76 1845 1845 2 2 2 0 0
1854 Mbin.pl 76 1914 1914 2 2 2 0 0
1924 Mbin.pl 76 1986 1986 2 2 2 0 0
1994 Mbin.pl 76 2058 2058 2 2 2 0 0
2062 Mbin.pl 76 2129 2129 2 2 2 0 0
2132 Mbin.pl 76 2201 2201 2 2 2 0 0
2202 Mbin.pl 76 2272 2272 2 2 2 0 0
2272 Mbin.pl 76 2344 2344 2 2 2 0 0
2342 Mbin.pl 76 2415 2415 2 2 2 0 0
2413 Mbin.pl 76 2487 2487 2 2 2 0 0
2552 Mbin.pl 76 2629 2629 2 2 2 0 0
2833 Mbin.pl 76 2919 2919 2 2 2 0 0
2910 Mbin.pl 76 2998 2998 2 2 2 0 0
2987 Mbin.pl 76 3077 3077 2 2 2 0 0
5235 Mbin.pl 76 5387 5387 2 2 0 0 0
5809 Mbin.pl 76 5969 5969 2 2 1 0 0
6239 Mbin.pl 76 6409 6409 2 2 1 0 0
6525 Mbin.pl 76 6703 6703 2 2 1 0 0

Advanced export

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

CSV options:

CREATE TABLE "NodeinfoUsage" (
  "id" INTEGER PRIMARY KEY AUTOINCREMENT,
  "server" INTEGER NOT NULL REFERENCES "Server" ("id") ON DELETE CASCADE,
  "full_entry" INTEGER NOT NULL REFERENCES "RawServerNodeInfo" ("id"),
  "users_total" INTEGER,
  "users_active_half_year" INTEGER,
  "users_active_month" INTEGER,
  "local_posts" INTEGER,
  "local_comments" INTEGER
);
CREATE INDEX "idx_nodeinfousage__full_entry" ON "NodeinfoUsage" ("full_entry");
CREATE INDEX "idx_nodeinfousage__server" ON "NodeinfoUsage" ("server");
Powered by Datasette · Queries took 21.271ms