Wikipedia:Database reports
(Redirected from Wikipedia:Database report)
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]Blocks
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Indefinitely blocked IPs | 17,386 | Monthly | |
| Unusually long IP blocks (configuration) | 28 | Monthly | 08:05, 26 August 2024 (UTC) |
| Unusually long user blocks (configuration) | 1,729 | Monthly | 00:00, 27 January 2025 (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) | 817 | Daily | 14:08, 13 February 2025 (UTC) |
| Polluted categories (configuration) | 18,105 | Monthly | 12:24, 12 February 2025 (UTC) |
| Polluted categories (2) (configuration) | 4,260 | Ad hoc | 00:01, 13 February 2025 (UTC) |
| Polluted categories (3) (configuration) | 156,241 | Ad hoc | 01:00, 13 February 2025 (UTC) |
| Polluted categories (4) (configuration) | 1,480 | Ad hoc | 02:00, 13 February 2025 (UTC) |
| Red-linked categories with incoming links (configuration) | 3,839 | Weekly | 22:00, 05 October 2022 (UTC) |
| Self-categorized categories (configuration) | 861 | Weekly | 00:03, 11 February 2025 (UTC) |
| Template categories containing articles (configuration) | 865 | Weekly | 13:10, 12 February 2025 (UTC) |
| Uncategorized categories (configuration) | 2,221 | Weekly | 12:36, 12 February 2025 (UTC) |
| User categories (configuration) | 28 | Monthly | 20:15, 2 February 2025 (UTC) |
Files
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| File description pages shadowing a Commons file or redirect (configuration) | 194 | Weekly | 14:30, 11 November 2024 (UTC) |
| Filenames with multiple extensions (configuration) | 18,906 | Weekly | 13:03, 11 February 2025 (UTC) |
| Files credited to Getty Images (configuration) | 7,002 | Weekly | 13:01, 11 February 2025 (UTC) |
| Files credited to The Associated Press (configuration) | 813 | Weekly | 13:01, 11 February 2025 (UTC) |
| Files for daily deletion with an impossible date (configuration) | 105 | Weekly | 14:31, 11 November 2024 (UTC) |
| Files tagged for FfD missing an FfD nomination (configuration) | 105 | Weekly | 14:30, 11 November 2024 (UTC) |
| Files with conflicting categorization (configuration) | 29,269 | Weekly | 00:03, 11 February 2025 (UTC) |
| Files without a license tag (configuration) | 1,938 | Weekly | 14:31, 11 November 2024 (UTC) |
| Free files which link to Flickr (configuration) | 22,628 | Weekly | 13:03, 11 February 2025 (UTC) |
| Free files without a machine-readable source (configuration) | 39,585 | Weekly | 13:02, 11 February 2025 (UTC) |
| Large fair-use images (configuration) | 847 | Weekly | 14:30, 11 November 2024 (UTC) |
| Largely duplicative file names (configuration) | 1,577 | Daily | 00:01, 13 February 2025 (UTC) |
| Largest orphaned free files by bytes (configuration) | 9,796 | Daily | 13:01, 11 February 2025 (UTC) |
| Local files with a duplicate on Commons (configuration) | 1,223 | Weekly | 14:31, 11 November 2024 (UTC) |
| Non-free files shadowing a Commons file (configuration) | 1,088 | Weekly | 14:31, 11 November 2024 (UTC) |
| Non-free PDFs (configuration) | 389 | Weekly | 13:02, 11 February 2025 (UTC) |
| Orphaned file talk pages (configuration) | 468 | Weekly | 14:31, 11 November 2024 (UTC) |
| Orphaned files copied to Commons tagged keep local (configuration) | 4,509 | Weekly | 14:32, 11 November 2024 (UTC) |
| Orphaned free files tagged keep local (configuration) | 18,014 | Weekly | 14:30, 11 November 2024 (UTC) |
| Orphaned low-resolution free files (configuration) | 53,379 | Weekly | 13:02, 11 February 2025 (UTC) |
| Orphaned PDFs (configuration) | 2,678 | Weekly | 14:31, 11 November 2024 (UTC) |
| Overused non-free files (configuration) | 2,295 | Weekly | 13:10, 12 February 2025 (UTC) |
| Pages containing an unusually high number of non-free files (configuration) | 9,654 | Weekly | 13:09, 12 February 2025 (UTC) |
| Smallest orphaned free files by bytes (configuration) | 6,919 | Weekly | 13:00, 11 February 2025 (UTC) |
| Smallest orphaned free files by resolution (configuration) | 16,751 | Weekly | 13:01, 11 February 2025 (UTC) |
| Templates containing non-free files (configuration) | 319 | Weekly | 13:18, 12 February 2025 (UTC) |
| Unused file redirects (configuration) | 428,333 | Weekly | 00:09, 1 June 2024 (UTC) |
| Unused non-free files (configuration) | 12,468 | Daily | 00:18, 13 February 2025 (UTC) |
Pages
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Bizarrely subnested userpages (configuration) | 153,205 | Weekly | |
| Blank single-author pages (configuration) | 41,699 | Weekly | 10:01, 9 February 2025 (UTC) |
| Malformed SPI Cases (configuration) | 90 | Continuously | 19:44, Thursday, February 13, 2025 (UTC) |
| Old deletion discussions (configuration) | 3,009 | Weekly | 13:09, 12 February 2025 (UTC) |
| Orphaned article deletion discussions (configuration) | 53 | Monthly | 11:12, 4 September 2022 (UTC) |
| Orphaned talk pages (configuration) | 963 | Daily | 05:02, 13 February 2025 (UTC) |
| Orphaned talk subpages (configuration) | 1,362 | Weekly | 13:09, 12 February 2025 (UTC) |
| Pages with the most revisions (configuration) | 48,820 | Weekly | 00:33, 12 February 2025 (UTC) |
| Talk pages by size (configuration) | 16,256 | Weekly | 00:19, 7 February 2025 (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) | 14,218 | Weekly | 13:02, 11 February 2025 (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, 1 February 2025 (UTC) |
Redirects
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Broken section anchors (configuration) | 1,905,884 | Monthly | 18:23, 02 February 2025 (UTC) |
Statistics
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Articles with the most redirects (configuration) | 84,903 | Monthly | 16:02, 4 February 2025 (UTC) |
| Page count by namespace (configuration) | 1,493 | Weekly | 00:13, 11 February 2025 (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,340 | Weekly | 13:08, 12 February 2025 (UTC) |
| Untagged stubs (configuration) | 33,418 | Weekly | 13:22, 12 February 2025 (UTC) |
Templates
[edit]Timed Text
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Timed Text without a corresponding File (configuration) | 173 | Weekly | 13:02, 11 February 2025 (UTC) |
WikiProjects
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| WikiProjects by changes (configuration) | 202,264 | Weekly | 13:16, 12 February 2025 (UTC) |
| WikiProject watchers (configuration) | 65,682 | Weekly | 00:00, 12 February 2025 (UTC) |
| New WikiProjects (configuration) | 546 | Fortnightly | 16:15, 2 February 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 |
|---|---|---|---|
| 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,737 | Monthly | 12:00, 1 February 2025 (UTC) |
| Confirmed autoconfirmed users (configuration) | 105 | Weekly | 13:02, 11 February 2025 (UTC) |
| Blocked users in user groups | 91,980 | Fortnightly | — |
| Editors eligible for Autopatrol privilege (source) | 174,420 | Daily | 02:45, 13 February 2025 (UTC) |
| List of Wikipedians by number of edits | — | Daily | — |
| Longest active user editing streaks (configuration) | 5,708 | Weekly | 20:48, 6 February 2025 (UTC) |
| Longest active user article editing streaks (configuration) | 3,240 | Weekly | 05:24, 7 February 2025 (UTC) |
| Miscategorized users (configuration) | 32,646 | Manually | 20:40, 16 September 2022 (UTC) |
| Ownerless pages in the user space (configuration) | 7,055 | Daily | 02:06, 13 February 2025 (UTC) |
| Potential U5s (configuration) | 28 | Weekly | 22:17, 6 February 2025 (UTC) |
| Top new article reviewers (source) | 145,364 | Twice daily | 15:53, 13 February 2025 (UTC) |
| Unusually large IP talk pages (configuration) | 448 | Weekly | 13:01, 11 February 2025 (UTC) |
| Unusually large user talk pages (configuration) | 755 | Weekly | 13:01, 11 February 2025 (UTC) |
| Userpages with ".com" in their titles (configuration) | 77,254 | 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.