Wikipedia:Database reports
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
[edit]Articles
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Articles by size (configuration) | 61,879 | Weekly | 00:12, 26 November 2024 (UTC) |
| Articles containing linked e-mail addresses (configuration) | 306 | Weekly | 22:12, 21 November 2024 (UTC) |
| Articles containing links to the user space (configuration) | 4,645 | Weekly | 12:44, 26 November 2024 (UTC) |
| Featured articles by size (configuration) | 296,271 | Weekly | 22:09, 25 November 2024 (UTC) |
| Forgotten articles (configuration) | 27,555 | Weekly | 00:12, 25 November 2024 (UTC) |
| Good articles by size (configuration) | 28 | Weekly | 16:23, 19 November 2024 (UTC) |
| Linked miscapitalizations (configuration) | 31,110 | Daily | 12:51, 26 November 2024 (UTC) |
| Linked misspellings (configuration) | 14,402 | Daily | 12:52, 26 November 2024 (UTC) |
| PRODed articles with deletion logs (configuration) | 4,819 | Twice daily | 06:31, 26 November 2024 (UTC) |
| Most edited articles last month (configuration) | 1,478 | Weekly | 00:12, 25 November 2024 (UTC) |
| Orphans with incoming links (configuration) | 424 | Daily | 03:00, 25 November 2024 (UTC) |
| Unbelievable life spans (configuration) | 762 | Weekly | 16:44, 19 November 2024 (UTC) |
| Interlanguage link templates need to fix (configuration) | 1,197,348 | Weekly | 01:10, 23 November 2024 (UTC) |
| Vital articles update report (configuration) | 7,226 | Daily | 09:22, 26 November 2024 (UTC) |
| Pages containing too many maintenance templates (configuration) | 22,409 | Weekly | 17:35, 23 November 2024 (UTC) |
| Possibly out-of-process deletions | — | Every three days | — |
| Drafts with categories | — | Daily | — |
| Short descriptions containing invalid space characters | 2,330 | Daily | — |
| Articles with links to drafts | 4,497 | Daily | — |
| Biographies of dead people | |||
| Recent deaths (configuration) | 14,987 | Daily | 10:44, 26 November 2024 (UTC) |
| Recent deaths (red links) (configuration) | 8,003 | Daily | 10:44, 26 November 2024 (UTC) |
| Deaths from the COVID-19 pandemic (configuration) | 531,147 | Daily | 10:44, 26 November 2024 (UTC) |
| Potential biographies of dead people (1) (configuration) | 467 | Weekly | 16:36, 19 November 2024 (UTC) |
| Potential biographies of dead people (3) (configuration) | 115,134 | Weekly | 16:36, 19 November 2024 (UTC) |
| Potential biographies of dead people (4) (configuration) | 89,348 | Weekly | 16:37, 19 November 2024 (UTC) |
| Biographies of living people | |||
| Biographies of living people containing unsourced statements (configuration) | 15,458 | Weekly | 16:44, 19 November 2024 (UTC) |
| Biographies of living people possibly eligible for deletion (configuration) | 2,987 | Weekly | 16:41, 19 November 2024 (UTC) |
| Potential biographies of living people (1) (configuration) | 3,106 | Weekly | 16:37, 19 November 2024 (UTC) |
| Potential biographies of living people (2) (configuration) | 18,548 | Weekly | 16:38, 19 November 2024 (UTC) |
| Potential biographies of living people (3) (configuration) | 27,735 | Weekly | 16:38, 19 November 2024 (UTC) |
| Shortest biographies of living people (configuration) | 31,848 | Daily | 12:52, 26 November 2024 (UTC) |
| Uncategorized and unreferenced biographies of living people (configuration) | 422 | Weekly | 16:44, 19 November 2024 (UTC) |
| Untagged and unreferenced biographies of living people (configuration) | 350 | Weekly | 16:46, 19 November 2024 (UTC) |
| Untagged biographies of living people (configuration) | 11,575 | Weekly | 16:45, 19 November 2024 (UTC) |
| Birthday today (configuration) | 8,522 | Daily | 11:38, 24 November 2024 (UTC) |
Blocks
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Indefinitely blocked IPs (configuration) | 385 | Weekly | 08:02, 31 October 2024 (UTC) |
| Unusually long IP blocks (configuration) | 28 | Monthly | 08:05, 26 August 2024 (UTC) |
| Unusually long user blocks (configuration) | 1,887 | Monthly | 22:22, 3 November 2024 (UTC) |
Categories
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Categories categorized in red-linked categories (configuration) | 240 | Weekly | 01:00, 09 October 2022 (UTC) |
| Empty categories (configuration) | 889 | Daily | 12:51, 26 November 2024 (UTC) |
| Polluted categories (configuration) | 20,020 | Monthly | 12:24, 26 November 2024 (UTC) |
| Polluted categories (2) (configuration) | 9,851 | Ad hoc | 00:00, 25 November 2024 (UTC) |
| Polluted categories (3) (configuration) | 148,048 | Ad hoc | 01:00, 25 November 2024 (UTC) |
| Polluted categories (4) (configuration) | 1,298 | Ad hoc | 02:00, 25 November 2024 (UTC) |
| Red-linked categories with incoming links (configuration) | 3,839 | Weekly | 22:00, 05 October 2022 (UTC) |
| Self-categorized categories (configuration) | 1,069 | Weekly | 12:33, 25 November 2024 (UTC) |
| Template categories containing articles (configuration) | 306 | Weekly | 16:35, 19 November 2024 (UTC) |
| Uncategorized categories (configuration) | 1,885 | Weekly | 12:34, 26 November 2024 (UTC) |
| User categories (configuration) | 28 | Monthly | 18:01, 10 November 2024 (UTC) |
Files
[edit]Pages
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Bizarrely subnested userpages (configuration) | 149,897 | Weekly | |
| Blank single-author pages (configuration) | 41,775 | Weekly | 07:10, 23 November 2024 (UTC) |
| Malformed SPI Cases (configuration) | 235 | Weekly | 14:30, 11 November 2024 (UTC) |
| Old deletion discussions (configuration) | 1,358 | Weekly | 16:34, 19 November 2024 (UTC) |
| Orphaned article deletion discussions (configuration) | 53 | Monthly | 11:12, 4 September 2022 (UTC) |
| Orphaned talk pages (configuration) | 268 | Daily | 05:04, 26 November 2024 (UTC) |
| Orphaned talk subpages (configuration) | 1,297 | Weekly | 16:35, 19 November 2024 (UTC) |
| Pages with the most revisions (configuration) | 48,777 | Weekly | 00:32, 20 November 2024 (UTC) |
| Talk pages by size (configuration) | 16,308 | Weekly | 00:19, 22 November 2024 (UTC) |
| Unfiled RfAs (configuration) | 2,059 | Weekly | 14:31, 11 November 2024 (UTC) |
Protections
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Semi-protected articles with unusually long expiries (configuration) | 86,267 | Monthly | 12:00, 07 October 2022 (UTC) |
| Fully protected articles with unusually long expiries (configuration) | 305 | Monthly | 12:05, 07 October 2022 (UTC) |
| Fully protected user talk pages (configuration) | 58 | Weekly | 17:21, 24 November 2024 (UTC) |
| 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) |
| Indefinitely fully protected redirects (configuration) | 28 | Monthly | 00:02, 9 November 2024 (UTC) |
Redirects
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Broken section anchors (configuration) | 1,832,117 | Monthly | 17:48, 02 November 2024 (UTC) |
Statistics
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Articles with the most redirects (configuration) | 84,884 | Monthly | 06:06, 12 November 2024 (UTC) |
| Page count by namespace (configuration) | 1,493 | Weekly | 00:13, 26 November 2024 (UTC) |
Stubs
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Dubious stub categories (configuration) | 38,783 | Weekly | 10:00, 07 October 2022 (UTC) |
| Long stubs (configuration) | 41,874 | Weekly | 16:33, 19 November 2024 (UTC) |
| Untagged stubs (configuration) | 33,518 | Weekly | 16:45, 19 November 2024 (UTC) |
Templates
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| All free license tags (configuration) | 5,743 | Weekly | 14:30, 11 November 2024 (UTC) |
| Broken WikiProject templates (configuration) | 369 | Weekly | 12:33, 25 November 2024 (UTC) |
| Free license tags which do not exist on Commons (configuration) | 1,241 | Weekly | 14:30, 11 November 2024 (UTC) |
| Invalid Navbar links (configuration) | 12,475 | Monthly | 14:13, 01 November 2024 (UTC) |
| Templates containing links to disambiguation pages (configuration) | 7,676 | Weekly | 16:42, 19 November 2024 (UTC) |
| Templates transcluded on the most pages (configuration) | 372 | Weekly | 05:10, 24 November 2024 (UTC) |
| Transclusions of non-existent templates (configuration) | 20,115 | Daily | |
| Uncategorized templates | 6,733 | Daily | — |
| Unprotected templates with many transclusions (configuration) | 13 | Weekly | 15:35, 22 September 2022 (UTC) |
| Unused templates (configuration) | 28 | Daily | 12:58, 26 November 2024 (UTC) |
| Unused templates (filtered) (configuration) | 28 | Daily | 13:06, 26 November 2024 (UTC) |
Timed Text
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Timed Text without a corresponding File (configuration) | 66 | Weekly | 17:21, 24 November 2024 (UTC) |
WikiProjects
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| WikiProjects by changes (configuration) | 202,223 | Weekly | 16:40, 19 November 2024 (UTC) |
| WikiProject watchers (configuration) | 65,108 | Weekly | 00:00, 20 November 2024 (UTC) |
| New WikiProjects (configuration) | 1,679 | Fortnightly | 12:11, 24 November 2024 (UTC) |
Third-party (disambiguations)
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Articles with links to disambiguation pages | — | Daily | — |
| Templates with disambiguation links | — | Daily | — |
Third-party (non-free files)
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| 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 | — |
Long pages by namespace
[edit]Third-party (generic)
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Page moves grouped by user | — | Hourly | — |
| Largest pages | — | Dynamically | — |
| WikiProject Check Wikipedia reports | — | Daily | — |
Users
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Active editors with the longest-established accounts (configuration) | 11,686 | Monthly | 12:01, 9 November 2024 (UTC) |
| Confirmed autoconfirmed users (configuration) | 193 | Weekly | 14:32, 11 November 2024 (UTC) |
| Blocked users in user groups | 88,853 | Fortnightly | — |
| Editors eligible for Autopatrol privilege (source) | 178,913 | Daily | 02:23, 24 November 2024 (UTC) |
| List of Wikipedians by number of edits | — | Daily | — |
| Longest active user editing streaks (configuration) | 5,341 | Weekly | 06:51, 20 November 2024 (UTC) |
| Longest active user article editing streaks (configuration) | 3,063 | Weekly | 11:47, 20 November 2024 (UTC) |
| Miscategorized users (configuration) | 32,646 | Manually | 20:40, 16 September 2022 (UTC) |
| Ownerless pages in the user space (configuration) | 6,406 | Daily | 14:05, 26 November 2024 (UTC) |
| Potential U5s (configuration) | 28 | Weekly | 04:59, 21 November 2024 (UTC) |
| Top new article reviewers (source) | 147,666 | Twice daily | 15:53, 26 November 2024 (UTC) |
| Unusually large IP talk pages (configuration) | 56 | Weekly | 17:21, 24 November 2024 (UTC) |
| Unusually large user talk pages (configuration) | 58 | Weekly | 17:21, 24 November 2024 (UTC) |
| Userpages with ".com" in their titles (configuration) | 77,270 | Weekly |
Archived reports
[edit]An index of disabled reports is available here and in Category:Inactive Wikipedia database reports. You can also find an index of all DBR subpages at Special:PrefixIndex/Wikipedia:Database reports.