Wikipedia:Database reports
From Wikipedia, the free encyclopedia
Reports from MediaWiki database queries
"WP:DBR" redirects here; not to be confused with WP:2R.
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) | 61,733 | Weekly | 00:12, 18 November 2025 (UTC) |
| Articles containing linked e-mail addresses (configuration) | 683 | Weekly | 10:00, 23 November 2025 (UTC) |
| Articles containing links to the user space (configuration) | 3,422 | Weekly | 00:41, 17 November 2025 (UTC) |
| Featured articles by size (configuration) | 304,621 | Weekly | 00:52, 17 November 2025 (UTC) |
| Forgotten articles (configuration) | 26,058 | Weekly | 00:11, 17 November 2025 (UTC) |
| Good articles by size (configuration) | 28 | Weekly | 02:19, 17 November 2025 (UTC) |
| Linked miscapitalizations (configuration) | 213,148 | Daily | 19:25, 22 November 2025 (UTC) |
| Linked misspellings (configuration) | 5,360 | Daily | 06:01, 23 November 2025 (UTC) |
| Multiple "Use xxx dates" templates | 1,531 | Daily | 19:28, 22 November 2025 (UTC) |
| Multiple "Use xxx English" templates | 5,065 | Daily | 10:25, 23 November 2025 (UTC) |
| PRODed articles with deletion logs (configuration) | 2,536 | Twice daily | 06:30, 23 November 2025 (UTC) |
| Most edited articles last month (configuration) | 1,375 | Weekly | 00:13, 17 November 2025 (UTC) |
| Orphans with incoming links (configuration) | 726 | Daily | 03:00, 21 November 2025 (UTC) |
| Unbelievable life spans (configuration) | 1,019 | Weekly | 01:24, 17 November 2025 (UTC) |
| Interlanguage link templates need to fix (configuration) | 1,220,688 | Weekly | 03:04, 22 November 2025 (UTC) |
| Vital articles update report (configuration) | 8,887 | Daily | 08:21, 23 November 2025 (UTC) |
| Pages containing too many maintenance templates (configuration) | 31,068 | Weekly | 18:11, 18 November 2025 (UTC) |
| Possibly out-of-process deletions | — | Every three days | — |
| Drafts with categories | — | Daily | — |
| Short descriptions containing invalid space characters | 2,637 | Daily | — |
| Articles with links to drafts | 4,136 | Daily | — |
| Biographies of dead people | |||
| Recent deaths (configuration) | 15,359 | Daily | 14:58, 23 November 2025 (UTC) |
| Recent deaths (red links) (configuration) | 7,283 | Daily | 14:58, 23 November 2025 (UTC) |
| Deaths from the COVID-19 pandemic (configuration) | 531,147 | Daily | 14:58, 23 November 2025 (UTC) |
| Potential biographies of dead people (1) (configuration) | 872 | Weekly | 01:15, 17 November 2025 (UTC) |
| Potential biographies of dead people (3) (configuration) | 152,123 | Weekly | 01:16, 17 November 2025 (UTC) |
| Potential biographies of dead people (4) (configuration) | 86,510 | Weekly | 01:17, 17 November 2025 (UTC) |
| Biographies of living people | |||
| Biographies of living people containing unsourced statements (configuration) | 15,436 | Weekly | 01:24, 17 November 2025 (UTC) |
| Biographies of living people possibly eligible for deletion (configuration) | 2,233 | Weekly | 01:20, 17 November 2025 (UTC) |
| Potential biographies of living people (1) (configuration) | 3,031 | Weekly | 01:17, 17 November 2025 (UTC) |
| Potential biographies of living people (2) (configuration) | 21,825 | Weekly | 01:18, 17 November 2025 (UTC) |
| Potential biographies of living people (3) (configuration) | 28,695 | Weekly | 01:18, 17 November 2025 (UTC) |
| Shortest biographies of living people (configuration) | 32,087 | Daily | 02:08, 23 November 2025 (UTC) |
| Uncategorized and unreferenced biographies of living people (configuration) | 345 | Weekly | 01:24, 17 November 2025 (UTC) |
| Untagged and unreferenced biographies of living people (configuration) | 1,130 | Weekly | 01:26, 17 November 2025 (UTC) |
| Untagged biographies of living people (configuration) | 3,317 | Weekly | 01:25, 17 November 2025 (UTC) |
| Birthday today (configuration) | 5,566 | Daily | 10:08, 8 October 2025 (UTC) |
Blocks
[edit ]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Indefinitely blocked IPs | 16,988 | Monthly | 20:53, 16 November 2025 (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) | 1,193 | Daily | 02:08, 23 November 2025 (UTC) |
| Polluted categories (configuration) | 20,400 | Weekly | 00:21, 17 November 2025 (UTC) |
| Polluted categories (2) (configuration) | 3,990 | Ad hoc | 00:00, 23 November 2025 (UTC) |
| Polluted categories (3) (configuration) | 187,602 | Ad hoc | 01:01, 23 November 2025 (UTC) |
| Polluted categories (4) (configuration) | 999 | Ad hoc | 02:00, 21 November 2025 (UTC) |
| Red-linked categories with incoming links (configuration) | 3,889 | Weekly | 22:00, 05 October 2022 (UTC) |
| Self-categorized categories (configuration) | 896 | Weekly | 10:04, 19 November 2025 (UTC) |
| Template categories containing articles | 948 | Daily | 16:43, 22 November 2025 (UTC) |
| Uncategorized categories (configuration) | 3,330 | Weekly | 00:32, 17 November 2025 (UTC) |
| User categories (configuration) | 28 | Monthly | 00:21, 10 November 2025 (UTC) |
| Polluted administrator categories | 58,738 | Monthly | 23:25, 28 October 2025 (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,869 | Weekly | 23:32, 16 November 2025 (UTC) |
| Files credited to Getty Images (configuration) | 7,101 | Weekly | 23:30, 16 November 2025 (UTC) |
| Files credited to The Associated Press (configuration) | 813 | Weekly | 23:30, 16 November 2025 (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) | 33,481 | Weekly | 10:05, 19 November 2025 (UTC) |
| Files without a license tag (configuration) | 1,988 | Weekly | 14:31, 11 November 2024 (UTC) |
| Free files which link to Flickr (configuration) | 23,285 | Weekly | 23:32, 16 November 2025 (UTC) |
| Free files without a machine-readable source (configuration) | 39,928 | Weekly | 23:31, 16 November 2025 (UTC) |
| Large fair-use images (configuration) | 897 | Weekly | 14:30, 11 November 2024 (UTC) |
| Largely duplicative file names (configuration) | 358 | Daily | 10:00, 23 November 2025 (UTC) |
| Largest orphaned free files by bytes (configuration) | 9,971 | Daily | 23:30, 16 November 2025 (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) | 481 | Weekly | 23:31, 16 November 2025 (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,691 | Weekly | 23:31, 16 November 2025 (UTC) |
| Orphaned PDFs (configuration) | 2,728 | Weekly | 14:31, 11 November 2024 (UTC) |
| Overused non-free files (configuration) | 2,060 | Weekly | 01:14, 17 November 2025 (UTC) |
| Pages containing an unusually high number of non-free files (configuration) | 9,113 | Weekly | 01:13, 17 November 2025 (UTC) |
| Smallest orphaned free files by bytes (configuration) | 6,841 | Weekly | 23:30, 16 November 2025 (UTC) |
| Smallest orphaned free files by resolution (configuration) | 17,682 | Weekly | 23:30, 16 November 2025 (UTC) |
| Templates containing non-free files (configuration) | 319 | Weekly | 01:21, 17 November 2025 (UTC) |
| Unused file redirects (configuration) | 428,383 | Weekly | 00:09, 1 June 2024 (UTC) |
| Unused non-free files (configuration) | 21,111 | Daily | 02:09, 23 November 2025 (UTC) |
Pages
[edit ]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Bizarrely subnested userpages (configuration) | 155,625 | Weekly | 05:25, 23 November 2025 (UTC) |
| Blank single-author pages (configuration) | 40,980 | Weekly | 16:00, 18 November 2025 (UTC) |
| Malformed SPI Cases (configuration) | 90 | Continuously | 16:35, Sunday, November 23, 2025 (UTC) |
| Old deletion discussions (configuration) | 65,625 | Weekly | 01:14, 17 November 2025 (UTC) |
| Orphaned article deletion discussions (configuration) | 103 | Monthly | 11:12, 4 September 2022 (UTC) |
| Orphaned talk pages (configuration) | 268 | Daily | 05:02, 23 November 2025 (UTC) |
| Orphaned talk subpages (configuration) | 605 | Weekly | 01:14, 17 November 2025 (UTC) |
| Pages with the most distinct editors in the last month (configuration) | 48,040 | Daily | 19:28, 22 November 2025 (UTC) |
| Pages with the most revisions (configuration) | 49,161 | Weekly | 00:30, 19 November 2025 (UTC) |
| Talk pages by size (configuration) | 16,234 | Weekly | 00:19, 21 November 2025 (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,224 | Weekly | 23:30, 16 November 2025 (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:00, 8 November 2025 (UTC) |
Redirects
[edit ]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Broken section anchors (configuration) | 1,747,035 | Monthly | 14:52, 02 November 2025 (UTC) |
Statistics
[edit ]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Articles with the most redirects (configuration) | 84,843 | Monthly | 00:01, 12 November 2025 (UTC) |
| Page count by namespace (configuration) | 1,565 | Weekly | 00:12, 18 November 2025 (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 | 20,597 | Daily | 22:44, 22 November 2025 (UTC) |
| Untagged stubs (configuration) | 34,035 | Weekly | 01:25, 17 November 2025 (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) | 311 | Weekly | 10:05, 19 November 2025 (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,777 | Monthly | 14:06, 01 November 2025 (UTC) |
| Template sandboxes with categories (configuration) | 76,647 | Daily | 11:25, 23 November 2025 (UTC) |
| Templates containing links to disambiguation pages (configuration) | 7,878 | Weekly | 01:21, 17 November 2025 (UTC) |
| Templates transcluded on the most pages (configuration) | 493 | Weekly | 05:09, 23 November 2025 (UTC) |
| Transclusions of non-existent templates (configuration) | 10,311 | Daily | 02:45, 23 November 2025 (UTC) |
| Uncategorized templates | 5,924 | Daily | — |
| Unprotected templates with many transclusions (configuration) | 63 | Weekly | 15:35, 22 September 2022 (UTC) |
| Unused templates (configuration) | 28 | Daily | 02:13, 23 November 2025 (UTC) |
| Unused templates (filtered) (configuration) | 28 | Daily | 02:20, 23 November 2025 (UTC) |
Timed Text
[edit ]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Timed Text without a corresponding File (configuration) | 755 | Weekly | 23:31, 16 November 2025 (UTC) |
WikiProjects
[edit ]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| WikiProjects by changes (configuration) | 202,645 | Weekly | 01:19, 17 November 2025 (UTC) |
| WikiProjects by human changes | 236,506 | Daily | 16:26, 23 November 2025 (UTC) |
| WikiProjects with no activity | 49,527 | Weekly | 13:25, 17 November 2025 (UTC) |
| WikiProject watchers (configuration) | 66,540 | Weekly | 00:00, 19 November 2025 (UTC) |
| New WikiProjects | 2,139 | Daily | 19:29, 22 November 2025 (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 | — | Tertian | — |
| 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,858 | Monthly | 02:00, 18 November 2025 (UTC) |
| Confirmed autoconfirmed users (configuration) | 363 | Weekly | 23:31, 16 November 2025 (UTC) |
| Blocked users in user groups | 82,987 | Fortnightly | — |
| Editors eligible for Autopatrol privilege (source) | 184,618 | Daily | 02:23, 27 August 2025 (UTC) |
| Inactive users with advanced permissions | 5,734 | Weekly | 02:36, 23 November 2025 (UTC) |
| List of Wikipedians by number of edits | — | Daily | — |
| Longest active user editing streaks (configuration) | 6,889 | Weekly | 14:45, 18 November 2025 (UTC) |
| Longest active user article editing streaks (configuration) | 3,679 | Weekly | 05:18, 20 November 2025 (UTC) |
| Miscategorized users (configuration) | 32,696 | Manually | 20:40, 16 September 2022 (UTC) |
| Ownerless pages in the user space (configuration) | 7,064 | Daily | 10:05, 23 November 2025 (UTC) |
| Potential U5s (configuration) | 28 | Weekly | 02:38, 17 November 2025 (UTC) |
| Top new article reviewers (source) | 146,354 | Twice daily | 15:53, 23 November 2025 (UTC) |
| Unusually large IP talk pages (configuration) | 222 | Weekly | 23:30, 16 November 2025 (UTC) |
| Unusually large user talk pages (configuration) | 105 | Weekly | 23:30, 16 November 2025 (UTC) |
| Userpages with ".com" in their titles (configuration) | 83,755 | Weekly | 20:25, 19 November 2025 (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.