NodeinfoUsage
39 rows where server = 45
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
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");