NodeinfoUsage
103 rows where server = 60
This data as json, CSV (advanced)
| id ▼ | server | full_entry | users_total | users_active_half_year | users_active_month | local_posts | local_comments |
|---|---|---|---|---|---|---|---|
| 92 | fediverse.pl 60 | 96 96 | 1 | 1 | 1 | 29 | 29 |
| 157 | fediverse.pl 60 | 163 163 | 1 | 1 | 1 | 29 | 29 |
| 351 | fediverse.pl 60 | 363 363 | 1 | 1 | 1 | 29 | 29 |
| 415 | fediverse.pl 60 | 429 429 | 1 | 1 | 1 | 29 | 29 |
| 479 | fediverse.pl 60 | 495 495 | 1 | 1 | 1 | 29 | 29 |
| 540 | fediverse.pl 60 | 558 558 | 1 | 1 | 1 | 29 | 29 |
| 602 | fediverse.pl 60 | 622 622 | 1 | 1 | 1 | 29 | 29 |
| 664 | fediverse.pl 60 | 686 686 | 1 | 1 | 1 | 29 | 29 |
| 724 | fediverse.pl 60 | 748 748 | 1 | 1 | 1 | 29 | 29 |
| 786 | fediverse.pl 60 | 812 812 | 1 | 1 | 1 | 29 | 29 |
| 847 | fediverse.pl 60 | 875 875 | 1 | 1 | 1 | 29 | 29 |
| 908 | fediverse.pl 60 | 939 939 | 1 | 1 | 1 | 29 | 29 |
| 974 | fediverse.pl 60 | 1007 1007 | 1 | 1 | 1 | 29 | 29 |
| 1040 | fediverse.pl 60 | 1075 1075 | 1 | 1 | 1 | 29 | 29 |
| 1106 | fediverse.pl 60 | 1143 1143 | 1 | 1 | 1 | 29 | 29 |
| 1173 | fediverse.pl 60 | 1212 1212 | 1 | 1 | 1 | 29 | 29 |
| 1239 | fediverse.pl 60 | 1281 1281 | 1 | 1 | 1 | 29 | 29 |
| 1301 | fediverse.pl 60 | 1344 1344 | 1 | 1 | 1 | 29 | 29 |
| 1367 | fediverse.pl 60 | 1412 1412 | 1 | 1 | 1 | 29 | 29 |
| 1434 | fediverse.pl 60 | 1481 1481 | 1 | 1 | 1 | 29 | 29 |
| 1500 | fediverse.pl 60 | 1550 1550 | 1 | 1 | 1 | 29 | 29 |
| 1567 | fediverse.pl 60 | 1619 1619 | 1 | 1 | 1 | 29 | 29 |
| 1635 | fediverse.pl 60 | 1689 1689 | 1 | 1 | 1 | 29 | 29 |
| 1703 | fediverse.pl 60 | 1759 1759 | 1 | 1 | 1 | 29 | 29 |
| 1771 | fediverse.pl 60 | 1829 1829 | 1 | 1 | 1 | 29 | 29 |
| 1838 | fediverse.pl 60 | 1898 1898 | 1 | 1 | 1 | 29 | 29 |
| 1908 | fediverse.pl 60 | 1970 1970 | 1 | 1 | 1 | 29 | 29 |
| 1978 | fediverse.pl 60 | 2042 2042 | 1 | 1 | 1 | 29 | 29 |
| 2047 | fediverse.pl 60 | 2114 2114 | 1 | 1 | 1 | 29 | 29 |
| 2116 | fediverse.pl 60 | 2185 2185 | 1 | 1 | 1 | 29 | 29 |
| 2186 | fediverse.pl 60 | 2256 2256 | 1 | 1 | 1 | 29 | 29 |
| 2256 | fediverse.pl 60 | 2328 2328 | 1 | 1 | 1 | 29 | 29 |
| 2326 | fediverse.pl 60 | 2399 2399 | 1 | 1 | 1 | 29 | 29 |
| 2397 | fediverse.pl 60 | 2471 2471 | 1 | 1 | 1 | 29 | 29 |
| 2468 | fediverse.pl 60 | 2543 2543 | 1 | 1 | 1 | 29 | 29 |
| 2537 | fediverse.pl 60 | 2614 2614 | 1 | 1 | 1 | 29 | 29 |
| 2608 | fediverse.pl 60 | 2687 2687 | 1 | 1 | 1 | 29 | 29 |
| 2678 | fediverse.pl 60 | 2759 2759 | 1 | 1 | 1 | 29 | 29 |
| 2748 | fediverse.pl 60 | 2831 2831 | 1 | 1 | 1 | 29 | 29 |
| 2817 | fediverse.pl 60 | 2903 2903 | 1 | 1 | 1 | 29 | 29 |
| 2894 | fediverse.pl 60 | 2982 2982 | 1 | 1 | 1 | 29 | 29 |
| 2971 | fediverse.pl 60 | 3061 3061 | 1 | 1 | 1 | 29 | 29 |
| 3047 | fediverse.pl 60 | 3140 3140 | 1 | 1 | 1 | 29 | 29 |
| 3123 | fediverse.pl 60 | 3218 3218 | 1 | 1 | 1 | 29 | 29 |
| 3199 | fediverse.pl 60 | 3296 3296 | 1 | 1 | 1 | 29 | 29 |
| 3275 | fediverse.pl 60 | 3374 3374 | 1 | 1 | 1 | 29 | 29 |
| 3351 | fediverse.pl 60 | 3452 3452 | 1 | 1 | 1 | 29 | 29 |
| 3426 | fediverse.pl 60 | 3529 3529 | 1 | 1 | 1 | 29 | 29 |
| 3500 | fediverse.pl 60 | 3605 3605 | 1 | 1 | 1 | 29 | 29 |
| 3575 | fediverse.pl 60 | 3682 3682 | 1 | 1 | 1 | 29 | 29 |
| 3650 | fediverse.pl 60 | 3759 3759 | 1 | 1 | 1 | 29 | 29 |
| 3724 | fediverse.pl 60 | 3835 3835 | 1 | 1 | 1 | 29 | 29 |
| 3797 | fediverse.pl 60 | 3910 3910 | 1 | 1 | 1 | 29 | 29 |
| 3870 | fediverse.pl 60 | 3984 3984 | 1 | 1 | 1 | 29 | 29 |
| 3943 | fediverse.pl 60 | 4059 4059 | 1 | 1 | 1 | 29 | 29 |
| 4015 | fediverse.pl 60 | 4133 4133 | 1 | 1 | 1 | 29 | 29 |
| 4087 | fediverse.pl 60 | 4207 4207 | 1 | 1 | 1 | 29 | 29 |
| 4161 | fediverse.pl 60 | 4283 4283 | 1 | 1 | 1 | 29 | 29 |
| 4234 | fediverse.pl 60 | 4358 4358 | 1 | 1 | 1 | 29 | 29 |
| 4306 | fediverse.pl 60 | 4432 4432 | 1 | 1 | 1 | 29 | 29 |
| 4378 | fediverse.pl 60 | 4506 4506 | 1 | 1 | 1 | 29 | 29 |
| 4449 | fediverse.pl 60 | 4579 4579 | 1 | 1 | 1 | 29 | 29 |
| 4521 | fediverse.pl 60 | 4653 4653 | 1 | 1 | 1 | 29 | 29 |
| 4593 | fediverse.pl 60 | 4727 4727 | 1 | 1 | 1 | 29 | 29 |
| 4663 | fediverse.pl 60 | 4799 4799 | 1 | 1 | 1 | 29 | 29 |
| 4736 | fediverse.pl 60 | 4874 4874 | 1 | 1 | 1 | 29 | 29 |
| 4806 | fediverse.pl 60 | 4946 4946 | 1 | 1 | 1 | 29 | 29 |
| 4874 | fediverse.pl 60 | 5016 5016 | 1 | 1 | 1 | 29 | 29 |
| 4943 | fediverse.pl 60 | 5087 5087 | 1 | 1 | 1 | 29 | 29 |
| 5010 | fediverse.pl 60 | 5156 5156 | 1 | 1 | 1 | 29 | 29 |
| 5081 | fediverse.pl 60 | 5229 5229 | 1 | 1 | 1 | 29 | 29 |
| 5151 | fediverse.pl 60 | 5301 5301 | 1 | 1 | 1 | 29 | 29 |
| 5222 | fediverse.pl 60 | 5374 5374 | 1 | 1 | 1 | 29 | 29 |
| 5295 | fediverse.pl 60 | 5448 5448 | 1 | 1 | 1 | 29 | 29 |
| 5367 | fediverse.pl 60 | 5521 5521 | 1 | 1 | 1 | 29 | 29 |
| 5438 | fediverse.pl 60 | 5593 5593 | 1 | 1 | 1 | 29 | 29 |
| 5509 | fediverse.pl 60 | 5666 5666 | 1 | 1 | 1 | 29 | 29 |
| 5581 | fediverse.pl 60 | 5739 5739 | 1 | 1 | 1 | 29 | 29 |
| 5651 | fediverse.pl 60 | 5809 5809 | 1 | 1 | 1 | 29 | 29 |
| 5722 | fediverse.pl 60 | 5881 5881 | 1 | 1 | 1 | 29 | 29 |
| 5795 | fediverse.pl 60 | 5955 5955 | 1 | 1 | 1 | 29 | 29 |
| 5869 | fediverse.pl 60 | 6030 6030 | 1 | 1 | 1 | 29 | 29 |
| 5942 | fediverse.pl 60 | 6104 6104 | 1 | 1 | 1 | 29 | 29 |
| 6014 | fediverse.pl 60 | 6178 6178 | 1 | 1 | 1 | 29 | 29 |
| 6084 | fediverse.pl 60 | 6250 6250 | 1 | 1 | 1 | 29 | 29 |
| 6154 | fediverse.pl 60 | 6322 6322 | 1 | 1 | 1 | 29 | 29 |
| 6225 | fediverse.pl 60 | 6395 6395 | 1 | 1 | 1 | 29 | 29 |
| 6297 | fediverse.pl 60 | 6469 6469 | 1 | 1 | 1 | 29 | 29 |
| 6369 | fediverse.pl 60 | 6543 6543 | 1 | 1 | 1 | 29 | 29 |
| 6441 | fediverse.pl 60 | 6617 6617 | 1 | 1 | 1 | 29 | 29 |
| 6513 | fediverse.pl 60 | 6691 6691 | 1 | 1 | 1 | 29 | 29 |
| 6584 | fediverse.pl 60 | 6764 6764 | 1 | 1 | 1 | 29 | 29 |
| 6654 | fediverse.pl 60 | 6836 6836 | 1 | 1 | 1 | 29 | 29 |
| 6725 | fediverse.pl 60 | 6909 6909 | 1 | 1 | 1 | 29 | 29 |
| 6795 | fediverse.pl 60 | 6981 6981 | 1 | 1 | 1 | 29 | 29 |
| 6865 | fediverse.pl 60 | 7053 7053 | 1 | 1 | 1 | 29 | 29 |
| 6935 | fediverse.pl 60 | 7125 7125 | 1 | 1 | 1 | 29 | 29 |
| 7005 | fediverse.pl 60 | 7197 7197 | 1 | 1 | 1 | 29 | 29 |
| 7075 | fediverse.pl 60 | 7269 7269 | 1 | 1 | 1 | 29 | 29 |
| 7143 | fediverse.pl 60 | 7339 7339 | 1 | 1 | 1 | 29 | 29 |
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");