home / fediscrape

NodeinfoUsage

39 rows where server = 45

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ server full_entry users_total users_active_half_year users_active_month local_posts local_comments
77 CYPR24 45 81 81 24 21 21 12734 12734
142 CYPR24 45 148 148 24 21 21 12734 12734
207 CYPR24 45 215 215 24 21 21 12734 12734
272 CYPR24 45 282 282 24 21 21 12736 12736
336 CYPR24 45 348 348 24 21 21 12744 12744
401 CYPR24 45 415 415 24 21 21 12753 12753
465 CYPR24 45 481 481 24 21 21 12761 12761
526 CYPR24 45 544 544 24 21 21 12769 12769
588 CYPR24 45 608 608 24 21 21 12775 12775
650 CYPR24 45 672 672 24 21 21 12782 12782
710 CYPR24 45 734 734 24 21 21 12793 12793
772 CYPR24 45 798 798 24 21 21 12802 12802
833 CYPR24 45 861 861 24 21 21 12808 12808
894 CYPR24 45 925 925 24 21 21 12805 12805
961 CYPR24 45 994 994 24 21 21 12812 12812
1027 CYPR24 45 1062 1062 24 21 21 12818 12818
1093 CYPR24 45 1130 1130 24 21 21 12825 12825
1160 CYPR24 45 1199 1199 24 21 21 12835 12835
1226 CYPR24 45 1268 1268 24 21 21 12843 12843
1289 CYPR24 45 1332 1332 24 21 21 12853 12853
1354 CYPR24 45 1399 1399 24 21 21 12861 12861
1421 CYPR24 45 1468 1468 24 21 21 12867 12867
1487 CYPR24 45 1537 1537 24 21 21 12878 12878
1554 CYPR24 45 1606 1606 24 21 21 12887 12887
1622 CYPR24 45 1676 1676 24 21 21 12895 12895
1690 CYPR24 45 1746 1746 24 21 21 12903 12903
1758 CYPR24 45 1816 1816 24 21 21 12910 12910
1825 CYPR24 45 1885 1885 24 21 21 12920 12920
1895 CYPR24 45 1957 1957 24 21 21 12927 12927
1965 CYPR24 45 2029 2029 24 21 21 12933 12933
2034 CYPR24 45 2101 2101 24 21 21 12941 12941
2103 CYPR24 45 2172 2172 24 21 21 12945 12945
2173 CYPR24 45 2243 2243 24 21 21 12948 12948
2243 CYPR24 45 2315 2315 24 21 21 12952 12952
2313 CYPR24 45 2386 2386 24 21 21 12956 12956
2384 CYPR24 45 2458 2458 24 21 21 12958 12958
2455 CYPR24 45 2530 2530 24 21 21 12958 12958
2524 CYPR24 45 2601 2601 24 21 21 12959 12959
2595 CYPR24 45 2674 2674 24 21 21 12961 12961

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 6.208ms