NodeinfoUsage

27 rows where server = 42

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: users_total, users_active_half_year, users_active_month, local_posts, local_comments

id ▼ server full_entry users_total users_active_half_year users_active_month local_posts local_comments
74 polesie.pol.social 42 78 78 19 6 2 87 87
139 polesie.pol.social 42 145 145 19 6 2 87 87
204 polesie.pol.social 42 212 212 19 6 2 87 87
269 polesie.pol.social 42 279 279 19 6 2 89 89
333 polesie.pol.social 42 345 345 19 6 2 89 89
398 polesie.pol.social 42 412 412 19 6 2 89 89
462 polesie.pol.social 42 478 478 19 6 2 89 89
523 polesie.pol.social 42 541 541 19 6 2 89 89
585 polesie.pol.social 42 605 605 19 6 1 89 89
647 polesie.pol.social 42 669 669 19 6 1 90 90
707 polesie.pol.social 42 731 731 19 6 1 93 93
769 polesie.pol.social 42 795 795 19 6 1 93 93
830 polesie.pol.social 42 858 858 19 6 1 94 94
891 polesie.pol.social 42 922 922 19 6 1 94 94
958 polesie.pol.social 42 991 991 19 6 1 94 94
1024 polesie.pol.social 42 1059 1059 19 6 1 94 94
1090 polesie.pol.social 42 1127 1127 19 6 1 94 94
1157 polesie.pol.social 42 1196 1196 19 6 1 94 94
1223 polesie.pol.social 42 1265 1265 19 6 1 99 99
1286 polesie.pol.social 42 1329 1329 19 6 1 99 99
1351 polesie.pol.social 42 1396 1396 19 6 1 99 99
1418 polesie.pol.social 42 1465 1465 19 6 1 99 99
1484 polesie.pol.social 42 1534 1534 20 7 2 99 99
1551 polesie.pol.social 42 1603 1603 20 7 2 99 99
1619 polesie.pol.social 42 1673 1673 20 7 2 99 99
1687 polesie.pol.social 42 1743 1743 20 7 2 99 99
1755 polesie.pol.social 42 1813 1813 20 7 2 99 99

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");