NodeinfoUsage

16 rows where server = 87

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: local_posts, local_comments

id ▼ server full_entry users_total users_active_half_year users_active_month local_posts local_comments
6321 info.brwinow.gmina.pl 87 6493 6493 2     215 215
6393 info.brwinow.gmina.pl 87 6567 6567 2     215 215
6465 info.brwinow.gmina.pl 87 6641 6641 2     220 220
6536 info.brwinow.gmina.pl 87 6714 6714 2     227 227
6607 info.brwinow.gmina.pl 87 6787 6787 2     242 242
6678 info.brwinow.gmina.pl 87 6860 6860 2     178 178
6748 info.brwinow.gmina.pl 87 6932 6932 2     190 190
6818 info.brwinow.gmina.pl 87 7004 7004 2     195 195
6888 info.brwinow.gmina.pl 87 7076 7076 2     200 200
6958 info.brwinow.gmina.pl 87 7148 7148 2     177 177
7028 info.brwinow.gmina.pl 87 7220 7220 2     193 193
7097 info.brwinow.gmina.pl 87 7291 7291 2     208 208
7166 info.brwinow.gmina.pl 87 7362 7362 2     225 225
7236 info.brwinow.gmina.pl 87 7434 7434 2     247 247
7306 info.brwinow.gmina.pl 87 7506 7506 2     255 255
7376 info.brwinow.gmina.pl 87 7578 7578 2     256 256

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