NodeinfoUsage
106 rows where server = 20
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|
| 18 | PeerTube 20 | 20 20 | 4 | 4 | 2 | 13 | 13 |
| 53 | PeerTube 20 | 57 57 | 4 | 4 | 2 | 13 | 13 |
| 118 | PeerTube 20 | 124 124 | 4 | 4 | 2 | 13 | 13 |
| 183 | PeerTube 20 | 191 191 | 4 | 4 | 2 | 13 | 13 |
| 247 | PeerTube 20 | 257 257 | 4 | 4 | 2 | 13 | 13 |
| 312 | PeerTube 20 | 324 324 | 4 | 4 | 2 | 13 | 13 |
| 377 | PeerTube 20 | 391 391 | 4 | 4 | 2 | 13 | 13 |
| 441 | PeerTube 20 | 457 457 | 4 | 4 | 2 | 13 | 13 |
| 504 | PeerTube 20 | 522 522 | 4 | 4 | 2 | 13 | 13 |
| 566 | PeerTube 20 | 586 586 | 4 | 4 | 2 | 14 | 14 |
| 628 | PeerTube 20 | 650 650 | 4 | 4 | 2 | 14 | 14 |
| 690 | PeerTube 20 | 714 714 | 4 | 4 | 2 | 14 | 14 |
| 750 | PeerTube 20 | 776 776 | 4 | 3 | 2 | 14 | 14 |
| 811 | PeerTube 20 | 839 839 | 4 | 3 | 2 | 14 | 14 |
| 872 | PeerTube 20 | 903 903 | 4 | 3 | 2 | 14 | 14 |
| 939 | PeerTube 20 | 972 972 | 4 | 3 | 2 | 14 | 14 |
| 1005 | PeerTube 20 | 1040 1040 | 4 | 3 | 2 | 14 | 14 |
| 1071 | PeerTube 20 | 1108 1108 | 4 | 3 | 2 | 14 | 14 |
| 1138 | PeerTube 20 | 1177 1177 | 4 | 3 | 2 | 14 | 14 |
| 1204 | PeerTube 20 | 1246 1246 | 4 | 3 | 1 | 14 | 14 |
| 1269 | PeerTube 20 | 1312 1312 | 4 | 3 | 1 | 14 | 14 |
| 1332 | PeerTube 20 | 1377 1377 | 4 | 3 | 1 | 14 | 14 |
| 1399 | PeerTube 20 | 1446 1446 | 4 | 3 | 1 | 14 | 14 |
| 1465 | PeerTube 20 | 1515 1515 | 4 | 3 | 1 | 14 | 14 |
| 1532 | PeerTube 20 | 1584 1584 | 4 | 3 | 1 | 14 | 14 |
| 1600 | PeerTube 20 | 1654 1654 | 4 | 3 | 1 | 14 | 14 |
| 1668 | PeerTube 20 | 1724 1724 | 4 | 3 | 1 | 14 | 14 |
| 1736 | PeerTube 20 | 1794 1794 | 4 | 3 | 1 | 14 | 14 |
| 1805 | PeerTube 20 | 1865 1865 | 4 | 3 | 1 | 14 | 14 |
| 1874 | PeerTube 20 | 1936 1936 | 4 | 3 | 1 | 14 | 14 |
| 1944 | PeerTube 20 | 2008 2008 | 4 | 3 | 1 | 14 | 14 |
| 2013 | PeerTube 20 | 2080 2080 | 4 | 3 | 1 | 14 | 14 |
| 2082 | PeerTube 20 | 2151 2151 | 4 | 3 | 2 | 14 | 14 |
| 2152 | PeerTube 20 | 2222 2222 | 4 | 3 | 2 | 14 | 14 |
| 2222 | PeerTube 20 | 2294 2294 | 4 | 3 | 2 | 15 | 15 |
| 2292 | PeerTube 20 | 2365 2365 | 4 | 3 | 2 | 15 | 15 |
| 2363 | PeerTube 20 | 2437 2437 | 4 | 3 | 2 | 15 | 15 |
| 2434 | PeerTube 20 | 2509 2509 | 4 | 3 | 2 | 15 | 15 |
| 2503 | PeerTube 20 | 2580 2580 | 4 | 3 | 2 | 15 | 15 |
| 2574 | PeerTube 20 | 2653 2653 | 4 | 3 | 2 | 15 | 15 |
| 2645 | PeerTube 20 | 2726 2726 | 4 | 3 | 2 | 15 | 15 |
| 2715 | PeerTube 20 | 2798 2798 | 4 | 3 | 2 | 15 | 15 |
| 2785 | PeerTube 20 | 2870 2870 | 4 | 3 | 2 | 15 | 15 |
| 2861 | PeerTube 20 | 2949 2949 | 4 | 3 | 2 | 15 | 15 |
| 2938 | PeerTube 20 | 3028 3028 | 4 | 3 | 2 | 15 | 15 |
| 3015 | PeerTube 20 | 3107 3107 | 4 | 3 | 2 | 15 | 15 |
| 3090 | PeerTube 20 | 3185 3185 | 4 | 3 | 2 | 15 | 15 |
| 3166 | PeerTube 20 | 3263 3263 | 4 | 3 | 2 | 15 | 15 |
| 3242 | PeerTube 20 | 3341 3341 | 4 | 3 | 2 | 15 | 15 |
| 3318 | PeerTube 20 | 3419 3419 | 4 | 3 | 2 | 15 | 15 |
| 3394 | PeerTube 20 | 3497 3497 | 4 | 3 | 2 | 15 | 15 |
| 3468 | PeerTube 20 | 3573 3573 | 4 | 3 | 2 | 15 | 15 |
| 3543 | PeerTube 20 | 3650 3650 | 4 | 3 | 2 | 15 | 15 |
| 3618 | PeerTube 20 | 3727 3727 | 4 | 3 | 2 | 15 | 15 |
| 3692 | PeerTube 20 | 3803 3803 | 4 | 3 | 2 | 15 | 15 |
| 3765 | PeerTube 20 | 3878 3878 | 4 | 3 | 2 | 15 | 15 |
| 3838 | PeerTube 20 | 3952 3952 | 4 | 3 | 2 | 15 | 15 |
| 3912 | PeerTube 20 | 4028 4028 | 4 | 3 | 2 | 15 | 15 |
| 3984 | PeerTube 20 | 4102 4102 | 4 | 3 | 2 | 15 | 15 |
| 4056 | PeerTube 20 | 4176 4176 | 4 | 3 | 2 | 15 | 15 |
| 4129 | PeerTube 20 | 4251 4251 | 4 | 3 | 2 | 15 | 15 |
| 4202 | PeerTube 20 | 4326 4326 | 4 | 3 | 2 | 15 | 15 |
| 4274 | PeerTube 20 | 4400 4400 | 4 | 3 | 1 | 15 | 15 |
| 4346 | PeerTube 20 | 4474 4474 | 4 | 3 | 1 | 15 | 15 |
| 4417 | PeerTube 20 | 4547 4547 | 4 | 3 | 1 | 15 | 15 |
| 4489 | PeerTube 20 | 4621 4621 | 4 | 3 | 1 | 15 | 15 |
| 4561 | PeerTube 20 | 4695 4695 | 4 | 3 | 1 | 15 | 15 |
| 4631 | PeerTube 20 | 4767 4767 | 4 | 3 | 1 | 15 | 15 |
| 4704 | PeerTube 20 | 4842 4842 | 4 | 3 | 1 | 15 | 15 |
| 4776 | PeerTube 20 | 4916 4916 | 4 | 3 | 1 | 15 | 15 |
| 4846 | PeerTube 20 | 4988 4988 | 4 | 3 | 1 | 15 | 15 |
| 4914 | PeerTube 20 | 5058 5058 | 4 | 3 | 1 | 15 | 15 |
| 4983 | PeerTube 20 | 5129 5129 | 4 | 3 | 1 | 15 | 15 |
| 5050 | PeerTube 20 | 5198 5198 | 4 | 3 | 1 | 15 | 15 |
| 5120 | PeerTube 20 | 5270 5270 | 4 | 3 | 1 | 15 | 15 |
| 5191 | PeerTube 20 | 5343 5343 | 4 | 3 | 1 | 15 | 15 |
| 5263 | PeerTube 20 | 5416 5416 | 4 | 3 | 1 | 15 | 15 |
| 5336 | PeerTube 20 | 5490 5490 | 4 | 3 | 1 | 15 | 15 |
| 5407 | PeerTube 20 | 5562 5562 | 4 | 3 | 1 | 15 | 15 |
| 5479 | PeerTube 20 | 5635 5635 | 4 | 3 | 1 | 15 | 15 |
| 5550 | PeerTube 20 | 5708 5708 | 4 | 3 | 1 | 15 | 15 |
| 5621 | PeerTube 20 | 5779 5779 | 4 | 3 | 1 | 15 | 15 |
| 5691 | PeerTube 20 | 5850 5850 | 4 | 3 | 1 | 15 | 15 |
| 5763 | PeerTube 20 | 5923 5923 | 4 | 3 | 1 | 15 | 15 |
| 5837 | PeerTube 20 | 5998 5998 | 4 | 3 | 1 | 15 | 15 |
| 5910 | PeerTube 20 | 6072 6072 | 4 | 3 | 1 | 15 | 15 |
| 5983 | PeerTube 20 | 6146 6146 | 4 | 3 | 1 | 15 | 15 |
| 6054 | PeerTube 20 | 6219 6219 | 4 | 3 | 1 | 15 | 15 |
| 6124 | PeerTube 20 | 6291 6291 | 4 | 3 | 1 | 15 | 15 |
| 6195 | PeerTube 20 | 6364 6364 | 4 | 3 | 1 | 15 | 15 |
| 6267 | PeerTube 20 | 6438 6438 | 4 | 3 | 1 | 15 | 15 |
| 6339 | PeerTube 20 | 6512 6512 | 4 | 3 | 1 | 15 | 15 |
| 6411 | PeerTube 20 | 6586 6586 | 4 | 3 | 1 | 15 | 15 |
| 6483 | PeerTube 20 | 6660 6660 | 4 | 3 | 1 | 15 | 15 |
| 6554 | PeerTube 20 | 6733 6733 | 4 | 3 | 1 | 15 | 15 |
| 6625 | PeerTube 20 | 6806 6806 | 4 | 3 | 1 | 15 | 15 |
| 6696 | PeerTube 20 | 6879 6879 | 4 | 3 | 1 | 15 | 15 |
| 6766 | PeerTube 20 | 6951 6951 | 4 | 3 | 1 | 15 | 15 |
| 6836 | PeerTube 20 | 7023 7023 | 4 | 3 | 1 | 15 | 15 |
| 6906 | PeerTube 20 | 7095 7095 | 4 | 3 | 1 | 15 | 15 |
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");