Wikipedia:Database reports: Difference between revisions
Content deleted Content added
m Reverted edits by 2.147.176.173 (talk) (AV) |
update link |
||
| Line 605: | Line 605: | ||
* [[Wikipedia:Request a query]] |
* [[Wikipedia:Request a query]] |
||
* [[Wikipedia:Dump reports]] – historical reference |
* [[Wikipedia:Dump reports]] – historical reference |
||
* [ |
* [[quarry:|Quarry]] – see: [[wikitech:Help:Cloud Services Introduction]] |
||
{{Wikipedia community|state=collapsed}} |
{{Wikipedia community|state=collapsed}} |
||
Revision as of 03:13, 5 March 2023
Database reports query MediaWiki in search of patterns. Their output helps users by providing them with utility reports, used by community members to improve the encyclopedia (e.g., Untagged stubs (configuration)) and statistical reports, which have past and present informational value (e.g., Page count by namespace (configuration)).
Please discuss the current reports or suggest a new report on the talk page.
Current reports
| Report | Run frequency | Data as of | |
|---|---|---|---|
| Articles | |||
| Articles by size (configuration) | 61,706 | Weekly | 00:12, 25 June 2024 (UTC)2024-06-25T00:12:00+00:00 |
| Articles containing linked e-mail addresses (configuration) | 333 | Weekly | 20:01, 27 June 2024 (UTC)2024-06-27T20:01:00+00:00 |
| Articles containing links to the user space (configuration) | 1,453 | Weekly | 00:37, 27 June 2024 (UTC)2024-06-27T00:37:00+00:00 |
| Featured articles by size (configuration) | 291,880 | Weekly | 21:47, 25 June 2024 (UTC)2024-06-25T21:47:00+00:00 |
| Forgotten articles (configuration) | 27,767 | Weekly | 00:25, 24 June 2024 (UTC)2024-06-24T00:25:00+00:00 |
| Linked miscapitalizations (configuration) | 19,642 | Daily | 12:10, 30 June 2024 (UTC)2024-06-30T12:10:00+00:00 |
| Linked misspellings (configuration) | 2,683 | Daily | 12:11, 30 June 2024 (UTC)2024-06-30T12:11:00+00:00 |
| PRODed articles with deletion logs (configuration) | 2,553 | Twice daily | 06:30, 30 June 2024 (UTC)2024-06-30T06:30:00+00:00 |
| Most edited articles last month (configuration) | 1,417 | Weekly | 00:14, 24 June 2024 (UTC)2024-06-24T00:14:00+00:00 |
| Orphans with incoming links (configuration) | 357 | Daily | 03:00, 5 June 2024 (UTC)2024-06-05T03:00:00+00:00 |
| Unbelievable life spans (configuration) | 630 | Weekly | 22:47, 25 June 2024 (UTC)2024-06-25T22:47:00+00:00 |
| Interlanguage link templates need to fix (configuration) | 1,194,776 | Weekly | 00:05, 29 June 2024 (UTC)2024-06-29T00:05:00+00:00 |
| Vital articles update report (configuration) | 2,488 | Daily | 08:10, 26 June 2024 (UTC)2024-06-26T08:10:00+00:00 |
| Pages containing too many maintenance templates (configuration) | 12,494 | Weekly | 19:21, 15 June 2024 (UTC)2024-06-15T19:21:00+00:00 |
| Possibly out-of-process deletions | Every three days | — | |
| Drafts with categories | Daily | — | |
| Biographies of dead people | |||
| Recent deaths (configuration) | 14,108 | Daily | 17:25, 30 June 2024 (UTC)2024-06-30T17:25:00+00:00 |
| Recent deaths (red links) (configuration) | 9,338 | Daily | 17:25, 30 June 2024 (UTC)2024-06-30T17:25:00+00:00 |
| Deaths from the COVID-19 pandemic (configuration) | 531,147 | Daily | 17:25, 30 June 2024 (UTC)2024-06-30T17:25:00+00:00 |
| Potential biographies of dead people (1) (configuration) | 465 | Weekly | 22:28, 25 June 2024 (UTC)2024-06-25T22:28:00+00:00 |
| Potential biographies of dead people (3) (configuration) | 108,784 | Weekly | 22:32, 25 June 2024 (UTC)2024-06-25T22:32:00+00:00 |
| Biographies of living people | |||
| Biographies of living people containing unsourced statements (configuration) | 15,475 | Weekly | 22:48, 25 June 2024 (UTC)2024-06-25T22:48:00+00:00 |
| Biographies of living people possibly eligible for deletion (configuration) | 13,540 | Weekly | 22:42, 25 June 2024 (UTC)2024-06-25T22:42:00+00:00 |
| Potential biographies of living people (1) (configuration) | 3,423 | Weekly | 22:34, 25 June 2024 (UTC)2024-06-25T22:34:00+00:00 |
| Potential biographies of living people (2) (configuration) | 13,284 | Weekly | 22:38, 25 June 2024 (UTC)2024-06-25T22:38:00+00:00 |
| Potential biographies of living people (3) (configuration) | 27,658 | Weekly | 22:38, 25 June 2024 (UTC)2024-06-25T22:38:00+00:00 |
| Shortest biographies of living people (configuration) | 31,948 | Daily | 12:11, 30 June 2024 (UTC)2024-06-30T12:11:00+00:00 |
| Uncategorized and unreferenced biographies of living people (configuration) | 361 | Weekly | 22:48, 25 June 2024 (UTC)2024-06-25T22:48:00+00:00 |
| Untagged and unreferenced biographies of living people (configuration) | 1,882 | Weekly | 22:49, 25 June 2024 (UTC)2024-06-25T22:49:00+00:00 |
| Untagged biographies of living people (configuration) | 7,723 | Weekly | 22:48, 25 June 2024 (UTC)2024-06-25T22:48:00+00:00 |
| Birthday today (configuration) | 7,561 | Daily | 03:13, 5 March 2023 (UTC)2023-03-05T03:13:00+00:00 |
| Blocks | |||
| Indefinitely blocked IPs (configuration) | 382 | Weekly | 08:01, 13 June 2024 (UTC)2024-06-13T08:01:00+00:00 |
| Unusually long IP blocks (configuration) | 28 | Monthly | This page is intentionally left blank. (error parsing "This page is intentionally left blank.") |
| Unusually long user blocks (configuration) | 1,508 | Monthly | 15:01, 15 June 2024 (UTC)2024-06-15T15:01:00+00:00 |
| Categories | |||
| Categories categorized in red-linked categories (configuration) | 240 | Weekly | 01:00, 09 October 2022 (UTC)2022-10-09T01:00:00+00:00 |
| Empty categories (configuration) | 984 | Daily | 12:10, 30 June 2024 (UTC)2024-06-30T12:10:00+00:00 |
| Polluted categories (configuration) | 15,651 | Monthly | 21:08, 25 June 2024 (UTC)2024-06-25T21:08:00+00:00 |
| Polluted categories (2) (configuration) | 4,572 | Ad hoc | 00:00, 29 June 2024 (UTC)2024-06-29T00:00:00+00:00 |
| Polluted categories (3) (configuration) | 144,406 | Ad hoc | 01:00, 29 June 2024 (UTC)2024-06-29T01:00:00+00:00 |
| Polluted categories (4) (configuration) | 412 | Ad hoc | 02:00, 29 June 2024 (UTC)2024-06-29T02:00:00+00:00 |
| Red-linked categories with incoming links (configuration) | 3,839 | Weekly | 22:00, 05 October 2022 (UTC)2022-10-05T22:00:00+00:00 |
| Self-categorized categories (configuration) | 895 | Weekly | 21:11, 25 June 2024 (UTC)2024-06-25T21:11:00+00:00 |
| Template categories containing articles (configuration) | 302 | Weekly | 22:28, 25 June 2024 (UTC)2024-06-25T22:28:00+00:00 |
| Uncategorized categories (configuration) | 1,832 | Weekly | 21:43, 25 June 2024 (UTC)2024-06-25T21:43:00+00:00 |
| User categories (configuration) | 28 | Monthly | 16:01, 23 June 2024 (UTC)2024-06-23T16:01:00+00:00 |
| Files | |||
| File description pages shadowing a Commons file or redirect (configuration) | 143 | Weekly | 14:30, 17 June 2024 (UTC)2024-06-17T14:30:00+00:00 |
| Filenames with multiple extensions (configuration) | 101 | Weekly | 14:32, 17 June 2024 (UTC)2024-06-17T14:32:00+00:00 |
| Files credited to Getty Images (configuration) | 5,045 | Weekly | 14:32, 17 June 2024 (UTC)2024-06-17T14:32:00+00:00 |
| Files credited to The Associated Press (configuration) | 682 | Weekly | 14:32, 17 June 2024 (UTC)2024-06-17T14:32:00+00:00 |
| Files for daily deletion with an impossible date (configuration) | 101 | Weekly | 14:32, 17 June 2024 (UTC)2024-06-17T14:32:00+00:00 |
| Files tagged for FfD missing an FfD nomination (configuration) | 101 | Weekly | 14:30, 17 June 2024 (UTC)2024-06-17T14:30:00+00:00 |
| Files with conflicting categorization (configuration) | 29,366 | Weekly | 21:44, 25 June 2024 (UTC)2024-06-25T21:44:00+00:00 |
| Files without a license tag (configuration) | 1,755 | Weekly | 14:31, 17 June 2024 (UTC)2024-06-17T14:31:00+00:00 |
| Free files which link to Flickr (configuration) | 47,690 | Weekly | 14:32, 17 June 2024 (UTC)2024-06-17T14:32:00+00:00 |
| Free files without a machine-readable source (configuration) | 38,954 | Weekly | 14:32, 17 June 2024 (UTC)2024-06-17T14:32:00+00:00 |
| Large fair-use images (configuration) | 948 | Weekly | 14:31, 17 June 2024 (UTC)2024-06-17T14:31:00+00:00 |
| Largely duplicative file names (configuration) | 1,993 | Daily | 16:01, 30 June 2024 (UTC)2024-06-30T16:01:00+00:00 |
| Local files with a duplicate on Commons (configuration) | 612 | Weekly | 14:32, 17 June 2024 (UTC)2024-06-17T14:32:00+00:00 |
| Non-free files shadowing a Commons file (configuration) | 716 | Weekly | 14:32, 17 June 2024 (UTC)2024-06-17T14:32:00+00:00 |
| Non-free PDFs (configuration) | 239 | Weekly | 14:32, 17 June 2024 (UTC)2024-06-17T14:32:00+00:00 |
| Orphaned file talk pages (configuration) | 361 | Weekly | 14:32, 17 June 2024 (UTC)2024-06-17T14:32:00+00:00 |
| Orphaned free files tagged keep local (configuration) | 17,526 | Weekly | 14:31, 17 June 2024 (UTC)2024-06-17T14:31:00+00:00 |
| Orphaned low-resolution free files (configuration) | 51,902 | Weekly | 14:32, 17 June 2024 (UTC)2024-06-17T14:32:00+00:00 |
| Orphaned PDFs (configuration) | 2,232 | Weekly | 14:32, 17 June 2024 (UTC)2024-06-17T14:32:00+00:00 |
| Overused non-free files (configuration) | 2,512 | Weekly | 22:27, 25 June 2024 (UTC)2024-06-25T22:27:00+00:00 |
| Pages containing an unusually high number of non-free files (configuration) | 10,132 | Weekly | 22:26, 25 June 2024 (UTC)2024-06-25T22:26:00+00:00 |
| Templates containing non-free files (configuration) | 391 | Weekly | 22:42, 25 June 2024 (UTC)2024-06-25T22:42:00+00:00 |
| Unused file redirects (configuration) | 428,333 | Weekly | 00:09, 1 June 2024 (UTC)2024-06-01T00:09:00+00:00 |
| Unused non-free files (configuration) | 14,082 | Daily | 16:12, 30 June 2024 (UTC)2024-06-30T16:12:00+00:00 |
| Pages | |||
| Bizarrely subnested userpages (configuration) | 143,615 | Weekly | |
| Blank single-author pages (configuration) | 42,510 | Weekly | 00:01, 29 June 2024 (UTC)2024-06-29T00:01:00+00:00 |
| Malformed SPI Cases (configuration) | 227 | Weekly | 14:31, 17 June 2024 (UTC)2024-06-17T14:31:00+00:00 |
| Old deletion discussions (configuration) | 6,567 | Weekly | 22:26, 25 June 2024 (UTC)2024-06-25T22:26:00+00:00 |
| Orphaned article deletion discussions (configuration) | 53 | Monthly | 11:12, 4 September 2022 (UTC)2022-09-04T11:12:00+00:00 |
| Orphaned talk pages (configuration) | 341 | Daily | 06:39, 30 June 2024 (UTC)2024-06-30T06:39:00+00:00 |
| Orphaned talk subpages (configuration) | 620 | Weekly | 22:27, 25 June 2024 (UTC)2024-06-25T22:27:00+00:00 |
| Pages with the most revisions (configuration) | 48,620 | Weekly | 02:02, 26 June 2024 (UTC)2024-06-26T02:02:00+00:00 |
| Talk pages by size (configuration) | 16,275 | Weekly | 00:27, 28 June 2024 (UTC)2024-06-28T00:27:00+00:00 |
| Unfiled RfAs (configuration) | 2,008 | Weekly | 14:32, 17 June 2024 (UTC)2024-06-17T14:32:00+00:00 |
| Protections | |||
| Semi-protected articles with unusually long expiries (configuration) | 86,267 | Monthly | 12:00, 07 October 2022 (UTC)2022-10-07T12:00:00+00:00 |
| Fully protected articles with unusually long expiries (configuration) | 305 | Monthly | 12:05, 07 October 2022 (UTC)2022-10-07T12:05:00+00:00 |
| Fully protected user talk pages (configuration) | 14,826 | Weekly | 14:32, 17 June 2024 (UTC)2024-06-17T14:32:00+00:00 |
| Fully salted titles with unusually long expiries | Monthly | — | |
| Indefinitely semi-protected articles | Weekly | — | |
| Indefinitely semi-protected redirects (configuration) | 13 | Weekly | 00:30, 06 October 2022 (UTC)2022-10-06T00:30:00+00:00 |
| Indefinitely fully protected redirects (configuration) | 28 | Monthly | 20:03, 21 June 2024 (UTC)2024-06-21T20:03:00+00:00 |
| Redirects | |||
| Broken section anchors (configuration) | 1,524,318 | Monthly | 04:42, 03 June 2024 (UTC)2024-06-03T04:42:00+00:00 |
| Statistics | |||
| Articles with the most redirects (configuration) | 85,015 | Monthly | 02:08, 25 June 2024 (UTC)2024-06-25T02:08:00+00:00 |
| Page count by namespace (configuration) | 1,414 | Weekly | 00:17, 25 June 2024 (UTC)2024-06-25T00:17:00+00:00 |
| Stubs | |||
| Dubious stub categories (configuration) | 38,783 | Weekly | 10:00, 07 October 2022 (UTC)2022-10-07T10:00:00+00:00 |
| Long stubs (configuration) | 43,533 | Weekly | 22:25, 25 June 2024 (UTC)2024-06-25T22:25:00+00:00 |
| Untagged stubs (configuration) | 36,132 | Weekly | 22:49, 25 June 2024 (UTC)2024-06-25T22:49:00+00:00 |
| Templates | |||
| All free license tags (configuration) | 5,810 | Weekly | 14:30, 17 June 2024 (UTC)2024-06-17T14:30:00+00:00 |
| Broken WikiProject templates (configuration) | 668 | Weekly | 21:43, 25 June 2024 (UTC)2024-06-25T21:43:00+00:00 |
| Free license tags which do not exist on Commons (configuration) | 1,025 | Weekly | 14:30, 17 June 2024 (UTC)2024-06-17T14:30:00+00:00 |
| Invalid Navbar links (configuration) | 13,582 | Monthly | 17:55, 01 June 2024 (UTC)2024-06-01T17:55:00+00:00 |
| Templates containing links to disambiguation pages (configuration) | 7,641 | Weekly | 00:45, 27 June 2024 (UTC)2024-06-27T00:45:00+00:00 |
| Templates transcluded on the most pages (configuration) | 372 | Weekly | 09:43, 30 June 2024 (UTC)2024-06-30T09:43:00+00:00 |
| Transclusions of deleted templates (configuration) | 13 | Weekly | 15:25, 22 September 2022 (UTC)2022-09-22T15:25:00+00:00 |
| Transclusions of non-existent templates (configuration) | 8,961 | Daily | 15:00, 30 June 2024 (UTC)2024-06-30T15:00:00+00:00 |
| Uncategorized templates (configuration) | 117,441 | Weekly | |
| Unprotected templates with many transclusions (configuration) | 13 | Weekly | 15:35, 22 September 2022 (UTC)2022-09-22T15:35:00+00:00 |
| Unused templates (configuration) | 28 | Daily | 16:18, 30 June 2024 (UTC)2024-06-30T16:18:00+00:00 |
| Unused templates (filtered) (configuration) | 28 | Daily | 16:27, 30 June 2024 (UTC)2024-06-30T16:27:00+00:00 |
| Timed Text | |||
| Timed Text without a corresponding File (configuration) | 960 | Weekly | 14:30, 17 June 2024 (UTC)2024-06-17T14:30:00+00:00 |
| WikiProjects | |||
| WikiProjects by changes (configuration) | 203,273 | Weekly | 22:41, 25 June 2024 (UTC)2024-06-25T22:41:00+00:00 |
| WikiProject watchers (configuration) | 64,185 | Weekly | 00:00, 26 June 2024 (UTC)2024-06-26T00:00:00+00:00 |
| New WikiProjects (configuration) | 575 | Fortnightly | 10:01, 23 June 2024 (UTC)2024-06-23T10:01:00+00:00 |
| Third-party (disambiguations) | |||
| Articles with links to disambiguation pages | Daily | — | |
| Templates with disambiguation links | Daily | — | |
| Third-party (non-free files) | |||
| Articles containing an unusually high number of non-free files | Daily | — | |
| Non-free files used outside of mainspace | Daily | — | |
| Overused non-free files | Daily | — | |
| Mistagged non-free files | Daily | — | |
| Third-party (generic) | |||
| Page moves grouped by user | Hourly | — | |
| Largest pages | Dynamically | — | |
| WikiProject Check Wikipedia reports | Daily | — | |
| Users | |||
| Active editors with the longest-established accounts (configuration) | 11,675 | Monthly | 12:02, 22 June 2024 (UTC)2024-06-22T12:02:00+00:00 |
| Blocked users in user groups (configuration) | 90,628 | Fortnightly | |
| Editors eligible for Autopatrol privilege (source) | 142,825 | Daily | 01:51, 30 June 2024 (UTC)2024-06-30T01:51:00+00:00 |
| Longest active user editing streaks (configuration) | 5,397 | Weekly | 17:52, 26 June 2024 (UTC)2024-06-26T17:52:00+00:00 |
| Longest active user article editing streaks (configuration) | 3,073 | Weekly | 15:51, 20 June 2024 (UTC)2024-06-20T15:51:00+00:00 |
| Miscategorized users (configuration) | 32,646 | Manually | 20:40, 16 September 2022 (UTC)2022-09-16T20:40:00+00:00 |
| Ownerless pages in the user space (configuration) | 4,613 | Daily | 12:08, 30 June 2024 (UTC)2024-06-30T12:08:00+00:00 |
| Potential U5s (configuration) | 28 | Weekly | 06:56, 25 May 2023 (UTC)2023-05-25T06:56:00+00:00 |
| Top new article reviewers (source) | 141,978 | Twice daily | 15:53, 30 June 2024 (UTC)2024-06-30T15:53:00+00:00 |
| Unusually large IP talk pages (configuration) | 573 | Weekly | 14:32, 17 June 2024 (UTC)2024-06-17T14:32:00+00:00 |
| Unusually large user talk pages (configuration) | 642 | Weekly | 14:32, 17 June 2024 (UTC)2024-06-17T14:32:00+00:00 |
| Userpages with ".com" in their titles (configuration) | 77,034 | Weekly | |
Archived reports
An index of disabled reports is available here and in Category:Inactive Wikipedia database reports.