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.
Some stale reports are listed on this page. If desired, and if the SQL is available, stale reports can often be revived using {{Database report}}.
Current reports
[edit]Articles
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Articles by size (configuration) | 62,196 | Weekly | 00:12, 8 September 2026 (UTC) |
| Articles containing linked e-mail addresses (configuration) | 477 | Weekly | 10:31, 20 September 2026 (UTC) |
| Articles containing links to the user space (configuration) | 2,204 | Weekly | 18:06, 22 September 2026 (UTC) |
| Featured articles by size (configuration) | 312,828 | Weekly | 13:10, 17 September 2026 (UTC) |
| Most forgotten articles overall | 37,224 | Daily | 02:00, 23 September 2026 (UTC) |
| Most forgotten articles by human editors | 38,163 | Daily | 01:27, 23 September 2026 (UTC) |
| Good articles by size (configuration) | 28 | Weekly | 08:48, 22 September 2026 (UTC) |
| Linked miscapitalizations (configuration) | 377,437 | Daily | 16:28, 22 September 2026 (UTC) |
| Linked misspellings (configuration) | 43,207 | Daily | 21:25, 22 September 2026 (UTC) |
| Multiple "Use xxx dates" templates | 1,580 | Daily | 09:30, 22 September 2026 (UTC) |
| Multiple "Use xxx English" templates | 2,241 | Daily | 12:25, 22 September 2026 (UTC) |
| PRODed articles with deletion logs (configuration) | 1,222 | Twice daily | (to be moved to User:HaleBot) |
| Most edited articles last month (configuration) | 1,289 | Weekly | 00:12, 7 September 2026 (UTC) |
| Orphans with incoming links (configuration) | 1,435 | Daily | 07:25, 22 September 2026 (UTC) |
| Orphans not tagged as orphans | 38,396 | Daily | 21:31, 22 September 2026 (UTC) |
| Unbelievable life spans | 3,772 | Weekly | 11:16, 22 September 2026 (UTC) |
| Interlanguage link templates need to fix (configuration) | 1,244,785 | Weekly | 02:36, 11 July 2026 (UTC) |
| Vital articles update report (configuration) | 1,314 | Daily | 08:18, 22 September 2026 (UTC) |
| Pages containing too many maintenance templates (configuration) | 45,301 | Weekly | 04:20, 17 September 2026 (UTC) |
| Possibly out-of-process deletions | — | Every three days | — |
| Drafts with categories | — | Daily | — |
| Short descriptions containing invalid space characters | 2,592 | Daily | — |
| Articles with links to drafts | 7,018 | Daily | — |
| All uncategorized articles | 28,755 | Daily | 20:27, 22 September 2026 (UTC) |
| Dead-end pages | 4,831 | Daily | 21:30, 22 September 2026 (UTC) |
| Biographies of dead people | |||
| Recent deaths (configuration) | 20,216 | Daily | 09:40, 22 September 2026 (UTC) |
| Recent deaths (red links) (configuration) | 8,372 | Daily | 09:40, 22 September 2026 (UTC) |
| Deaths from the COVID-19 pandemic (configuration) | 563,897 | Daily | 09:40, 22 September 2026 (UTC) |
| Potential biographies of dead people (1) (configuration) | 2,112 | Weekly | 04:25, 19 September 2026 (UTC) |
| Potential biographies of dead people (3) (configuration) | 197,817 | Weekly | 17:26, 20 September 2026 (UTC) |
| Potential biographies of dead people (4) (configuration) | 91,851 | Weekly | 08:01, 16 September 2026 (UTC) |
| Biographies of living people | |||
| Biographies of living people containing unsourced statements (configuration) | 13,373 | Weekly | 04:25, 19 September 2026 (UTC) |
| Biographies of living people possibly eligible for deletion (configuration) | 789 | Weekly | 08:02, 16 September 2026 (UTC) |
| Potential biographies of living people (1) (configuration) | 4,393 | Weekly | 20:25, 16 September 2026 (UTC) |
| Potential biographies of living people (2) | 22,311 | Weekly | 14:26, 16 September 2026 (UTC) |
| Potential biographies of living people (3) (configuration) | 30,764 | Weekly | 04:25, 22 September 2026 (UTC) |
| Shortest biographies of living people (configuration) | 34,492 | Daily | 12:18, 22 September 2026 (UTC) |
| Uncategorized and unreferenced biographies of living people (configuration) | 1,183 | Weekly | 05:25, 19 September 2026 (UTC) |
| Untagged and unreferenced biographies of living people (configuration) | 351 | Weekly | 13:12, 17 September 2026 (UTC) |
| Untagged biographies of living people (configuration) | 5,534 | Weekly | 16:26, 19 September 2026 (UTC) |
| Birthday today (configuration) | 4,164 | Daily | 07:14, 18 August 2026 (UTC) |
Blocks
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Indefinitely blocked IPs | 23,613 | Monthly | 21:25, 8 September 2026 (UTC) |
| Unusually long IP blocks (configuration) | 78 | Monthly | 08:05, 26 August 2024 (UTC) |
| Unusually long user blocks (configuration) | 1,371 | Monthly | 00:02, 19 May 2025 (UTC) |
Categories
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Categories categorized in red-linked categories (configuration) | 240 | No longer updated | 01:00, 09 October 2022 (UTC) |
| Empty categories (configuration) | 4,011 | Daily | 03:25, 23 September 2026 (UTC) |
| Polluted categories (configuration) | 4,679 | Weekly | 14:10, 22 September 2026 (UTC) |
| Polluted categories (2) (configuration) | 1,784 | Ad hoc | 04:13, 23 September 2026 (UTC) |
| Polluted categories (3) (configuration) | 1,105,153 | Ad hoc | 14:25, 22 September 2026 (UTC) |
| Polluted categories (4) (configuration) | 2,997 | Ad hoc | 17:25, 21 September 2026 (UTC) |
| Red-linked categories with incoming links (configuration) | 3,889 | No longer updated | 22:00, 05 October 2022 (UTC) |
| Self-categorized categories (configuration) | 950 | Weekly | 11:27, 16 September 2026 (UTC) |
| Template categories containing articles | 1,041 | Daily | 19:25, 21 September 2026 (UTC) |
| Uncategorized categories (configuration) | 1,918 | Weekly | 14:17, 21 September 2026 (UTC) |
| User categories (configuration) | 28 | Monthly | 06:12, 14 September 2026 (UTC) |
| Polluted administrator categories | 65,242 | Monthly | 10:15, 1 September 2026 (UTC) |
Files
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| File description pages shadowing a Commons file or redirect (configuration) | 231 | Weekly | 14:30, 11 November 2024 (UTC) |
| Filenames with multiple extensions (configuration) | 18,984 | Weekly | 23:30, 20 September 2026 (UTC) |
| Files credited to Getty Images (configuration) | 6,273 | Weekly | 23:30, 20 September 2026 (UTC) |
| Files credited to The Associated Press (configuration) | 702 | Weekly | 23:30, 20 September 2026 (UTC) |
| Files for daily deletion with an impossible date (configuration) | 155 | Weekly | 14:31, 11 November 2024 (UTC) |
| Files tagged for FfD missing an FfD nomination (configuration) | 155 | Weekly | 14:30, 11 November 2024 (UTC) |
| Files with conflicting categorization (configuration) | 42,677 | Weekly | 04:25, 19 September 2026 (UTC) |
| Files without a license tag (configuration) | 1,988 | Weekly | 14:31, 11 November 2024 (UTC) |
| Free files which link to Flickr (configuration) | 23,403 | Weekly | 23:32, 01 March 2026 (UTC) |
| Free files without a machine-readable source (configuration) | 40,286 | Weekly | 23:31, 01 March 2026 (UTC) |
| Large fair-use images (configuration) | 897 | Weekly | 14:30, 11 November 2024 (UTC) |
| Largely duplicative file names (configuration) | 603 | Daily | 14:00, 22 September 2026 (UTC) |
| Largest orphaned free files by bytes (configuration) | 10,003 | Daily | 23:30, 01 March 2026 (UTC) |
| Local files with a duplicate on Commons (configuration) | 1,273 | Weekly | 14:31, 11 November 2024 (UTC) |
| Non-free files shadowing a Commons file (configuration) | 1,138 | Weekly | 14:31, 11 November 2024 (UTC) |
| Non-free PDFs (configuration) | 156 | Weekly | 23:31, 01 March 2026 (UTC) |
| Orphaned file talk pages (configuration) | 518 | Weekly | 14:31, 11 November 2024 (UTC) |
| Orphaned files copied to Commons tagged keep local (configuration) | 4,559 | Weekly | 14:32, 11 November 2024 (UTC) |
| Orphaned free files tagged keep local (configuration) | 18,064 | Weekly | 14:30, 11 November 2024 (UTC) |
| Orphaned low-resolution free files (configuration) | 50,574 | Weekly | 23:31, 01 March 2026 (UTC) |
| Orphaned PDFs (configuration) | 2,728 | Weekly | 14:31, 11 November 2024 (UTC) |
| Overused non-free files (configuration) | 3,135 | Weekly | 11:25, 17 September 2026 (UTC) |
| Pages containing an unusually high number of non-free files (configuration) | 9,403 | Weekly | 10:25, 16 September 2026 (UTC) |
| Smallest orphaned free files by bytes (configuration) | 6,821 | Weekly | 23:30, 01 March 2026 (UTC) |
| Smallest orphaned free files by resolution (configuration) | 17,596 | Weekly | 23:30, 01 March 2026 (UTC) |
| Templates containing non-free files (configuration) | 1,020 | Weekly | 15:25, 16 September 2026 (UTC) |
| Unused file redirects (configuration) | 428,383 | Weekly | 00:09, 1 June 2024 (UTC) |
| Unused non-free files (configuration) | 25,963 | Daily | 03:26, 23 September 2026 (UTC) |
Pages
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Bizarrely subnested userpages (configuration) | 141,989 | Weekly | 23:25, 19 September 2026 (UTC) |
| Blank single-author pages (configuration) | 41,018 | Weekly | 16:01, 22 September 2026 (UTC) |
| Malformed SPI Cases (configuration) | 90 | Continuously | 05:02, Wednesday, September 23, 2026 (UTC) |
| Old deletion discussions (configuration) | 643,582 | Weekly | 00:25, 22 September 2026 (UTC) |
| Orphaned article deletion discussions (configuration) | 103 | Monthly | 11:12, 4 September 2022 (UTC) |
| Orphaned talk pages (configuration) | 269 | Daily | 05:01, 11 September 2026 (UTC) |
| Orphaned talk subpages (configuration) | 562 | Weekly | 06:46, 22 September 2026 (UTC) |
| Pages with the most distinct editors in the last month (configuration) | 52,720 | Daily | 00:25, 23 September 2026 (UTC) |
| Pages with the most revisions (configuration) | 49,360 | Weekly | 00:25, 9 September 2026 (UTC) |
| Potential edit-warring or disruption (configuration) | 242,130 | Daily | 15:26, 22 September 2026 (UTC) |
| Talk pages by size (configuration) | 16,166 | Weekly | 00:15, 11 September 2026 (UTC) |
| Unfiled RfAs (configuration) | 2,109 | 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,317 | Monthly | 12:00, 07 October 2022 (UTC) |
| Fully protected articles with unusually long expiries (configuration) | 355 | Monthly | 12:05, 07 October 2022 (UTC) |
| Fully protected user talk pages (configuration) | 14,225 | Weekly | 23:30, 20 September 2026 (UTC) |
| Fully salted titles with unusually long expiries | — | Monthly | — |
| Indefinitely semi-protected articles | — | Weekly | — |
| Indefinitely semi-protected redirects (configuration) | 63 | Weekly | 00:30, 06 October 2022 (UTC) |
| Indefinitely fully protected redirects (configuration) | 28 | Monthly | 04:40, 12 September 2026 (UTC) |
Redirects
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Broken section anchors (configuration) | 1,690,773 | Monthly | 22:54, 02 September 2026 (UTC) |
Statistics
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Articles with the most redirects (configuration) | 85,269 | Monthly | 02:01, 16 September 2026 (UTC) |
| Page count by namespace (configuration) | 1,572 | Weekly | 00:11, 1 September 2026 (UTC) |
Stubs
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Dubious stub categories (configuration) | 38,833 | Weekly | 10:00, 07 October 2022 (UTC) |
| Long stubs | 22,224 | Daily | 22:38, 22 September 2026 (UTC) |
| Untagged stubs (configuration) | 36,957 | Weekly | 21:25, 16 September 2026 (UTC) |
Templates
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| All free license tags (configuration) | 5,793 | Weekly | 14:30, 11 November 2024 (UTC) |
| Broken WikiProject templates (configuration) | 312 | Weekly | 12:54, 17 September 2026 (UTC) |
| Free license tags which do not exist on Commons (configuration) | 1,291 | Weekly | 14:30, 11 November 2024 (UTC) |
| Invalid Navbar links (configuration) | 13,075 | Monthly | 12:37, 01 September 2026 (UTC) |
| Template sandboxes with categories (configuration) | 80,060 | Daily | 08:25, 22 September 2026 (UTC) |
| Templates containing links to disambiguation pages (configuration) | 4,706 | Weekly | 14:25, 18 September 2026 (UTC) |
| Templates transcluded on the most pages (configuration) | 493 | Weekly | 05:07, 20 September 2026 (UTC) |
| Transclusions of non-existent templates (configuration) | 6,133 | Daily | 17:26, 22 September 2026 (UTC) |
| Uncategorized templates | 7,215 | Daily | — |
| Unprotected templates with many transclusions (configuration) | 63 | Weekly | 15:35, 22 September 2022 (UTC) |
| Unused templates (configuration) | 28 | Daily | 14:19, 22 September 2026 (UTC) |
| Unused templates (filtered) (configuration) | 28 | Daily | 14:26, 22 September 2026 (UTC) |
Timed Text
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Timed Text without a corresponding File (configuration) | 1,151 | Weekly | 23:30, 20 September 2026 (UTC) |
WikiProjects
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| WikiProjects by changes (configuration) | 202,570 | Weekly | 06:47, 22 September 2026 (UTC) |
| WikiProjects by human changes | 210,609 | Daily | 09:31, 22 September 2026 (UTC) |
| WikiProjects with no activity | 68,341 | Weekly | 18:26, 16 September 2026 (UTC) |
| WikiProject watchers (configuration) | 66,811 | Weekly | 00:00, 23 September 2026 (UTC) |
| New WikiProjects | 1,574 | Daily | 04:25, 23 September 2026 (UTC) |
| Largest articles not included in WikiProjects | 46,946 | Daily | 04:26, 23 September 2026 (UTC) |
| Largest unassessed articles | 41,730 | Daily | 08:25, 22 September 2026 (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 |
|---|---|---|---|
| Mistagged non-free files | — | Daily | — |
Long pages
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Long pages | — | Every three days | — |
| Namespace | Talk namespace | Run frequency | Data as of |
|---|---|---|---|
| Main (Special:LongPages) | Talk | Monthly | — |
| User | User talk | Monthly | — |
| Wikipedia | Wikipedia talk | Monthly | — |
| File | File talk | Monthly | — |
| MediaWiki | MediaWiki talk | Monthly | — |
| Template | Template talk | Monthly | — |
| Help | Help talk | Monthly | — |
| Category | Category talk | Monthly | — |
| Portal | Portal talk | Monthly | — |
| Draft | Draft talk | Monthly | — |
| MOS | MOS talk | Monthly | — |
| TimedText | TimedText talk | Monthly | — |
| Module | Module talk | Monthly | — |
| Event | Event talk | Monthly | — |
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) | 12,830 | Monthly | 02:00, 8 September 2026 (UTC) |
| Confirmed autoconfirmed users (configuration) | 106 | Weekly | 23:30, 20 September 2026 (UTC) |
| Blocked users in user groups | 88,974 | Fortnightly | — |
| Editors eligible for Autopatrol privilege (source) | 159,757 | Daily | 00:10, 23 September 2026 (UTC) |
| Inactive users with advanced permissions | 5,814 | Weekly | 14:00, 19 September 2026 (UTC) |
| List of Wikipedians by number of edits | — | Daily | — |
| Longest active user editing streaks (configuration) | 7,754 | Weekly | 01:17, 19 September 2026 (UTC) |
| Longest active user article editing streaks (configuration) | 3,968 | Weekly | 16:45, 20 September 2026 (UTC) |
| Miscategorized users (configuration) | 32,696 | Manually | 20:40, 16 September 2022 (UTC) |
| Ownerless pages in the user space (configuration) | 8,690 | Daily | 14:03, 22 September 2026 (UTC) |
| Potential U5s (configuration) | 28 | Weekly | 08:08, 16 September 2026 (UTC) |
| Top new article reviewers (source) | 151,080 | Twice daily | 15:53, 11 September 2026 (UTC) |
| Unusually large IP talk pages (configuration) | 135 | Weekly | 23:30, 20 September 2026 (UTC) |
| Unusually large user talk pages (configuration) | 202 | Weekly | 23:30, 20 September 2026 (UTC) |
| Unverified user-rights userboxen (source) | 48,781 | Daily | 2026-09-20T10:53:31+00:00 |
| Userpages with ".com" in their titles (configuration) | 76,239 | Weekly | 06:25, 16 September 2026 (UTC) |
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.