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)).

Many reports such as these can now be generated with the Quarry service.

Reports which are no longer updated can be found in the archive page or archive category. All subpages of this page (including database report pages, as well as configuration files, exclude lists, etc) can be found at the PrefixIndex for it.

Please discuss the current reports or suggest a new report on the talk page.

Current reports

Report	Run frequency	Data as of
Articles Articles
Articles containing linked e-mail addresses (configuration)	Weekly	02:00, 12 October 2021 (UTC)
Articles containing links to the user space (configuration)	Weekly	02:00, 12 October 2021 (UTC)
Forgotten articles (configuration)	Weekly	00:12, 11 October 2021 (UTC)
Linked miscapitalizations (configuration)	Daily	04:00, 12 October 2021 (UTC)
Linked misspellings (configuration)	Daily	04:00, 12 October 2021 (UTC)
PRODed articles with deletion logs (configuration)	Twice daily	06:30, 14 October 2021 (UTC)
Most edited articles last month (configuration)	Weekly	00:12, 11 October 2021 (UTC)
Orphans with incoming links (configuration)	Daily	03:00, 13 October 2021 (UTC)
Interlanguage link templates need to fix (configuration)	Weekly	21:07, 8 October 2021 (UTC)
Vital articles update report (configuration)	Daily	08:12, 14 October 2021 (UTC)
Pages contains too many maintenance templates (configuration)	Weekly	11:22, 8 October 2021 (UTC)
Biographies of dead people Biographies of dead people
Recent deaths (configuration)	Daily	14:25, 14 October 2021 (UTC)
Deaths from the COVID-19 pandemic (configuration)	Daily	14:25, 14 October 2021 (UTC)
Potential biographies of dead people (1) (configuration)	Weekly	00:30, 07 October 2021 (UTC)
Potential biographies of dead people (3) (configuration)	Weekly	00:00, 07 October 2021 (UTC)
Biographies of living people Biographies of living people
Biographies of living people containing unsourced statements (configuration)	Weekly	00:00, 11 October 2021 (UTC)
Biographies of living people possibly eligible for deletion (configuration)	Weekly	01:47, 10 October 2021 (UTC)
Potential biographies of living people (1) (configuration)	Weekly	08:08, 10 October 2021 (UTC)
Potential biographies of living people (2) (configuration)	Weekly	08:10, 10 October 2021 (UTC)
Potential biographies of living people (3) (configuration)	Weekly	08:11, 10 October 2021 (UTC)
Shortest biographies of living people (configuration)	Daily	09:00, 11 October 2021 (UTC)
Uncategorized and unreferenced biographies of living people (configuration)	Weekly	08:15, 05 October 2021 (UTC)
Untagged and unreferenced biographies of living people (configuration)	Weekly	08:20, 05 October 2021 (UTC)
Untagged biographies of living people (configuration)	Weekly	08:20, 05 October 2021 (UTC)
Birthday today (configuration)	Daily	2021-10-09 06:50
Blocks Blocks
Indefinitely blocked IPs (configuration)	Weekly	00:00, 05 October 2021 (UTC)
Unusually long IP blocks (configuration)	Monthly	09:00, 13 October 2021 (UTC)
Unusually long user blocks (configuration)	Monthly	05:00, 12 October 2021 (UTC)
Categories Categories
Categories categorized in red-linked categories (configuration)	Weekly	01:00, 03 October 2021 (UTC)
Empty categories (configuration)	Daily	06:02, 11 October 2021 (UTC)
Polluted categories (configuration)	Weekly	12:38, 17 September 2021 (UTC)
Polluted categories (2) (configuration)	Ad hoc	00:00, 13 October 2021 (UTC)
Polluted categories (3) (configuration)	Ad hoc	01:00, 13 October 2021 (UTC)
Polluted categories (4) (configuration)	Ad hoc	02:00, 13 October 2021 (UTC)
Red-linked categories with incoming links (configuration)	Weekly	22:00, 29 September 2021 (UTC)
Self-categorized categories (configuration)	Weekly	06:00, 06 October 2021 (UTC)
Uncategorized categories (configuration)	Weekly	14:20, 10 October 2021 (UTC)
User categories (configuration)	Monthly	07:00, 18 September 2021 (UTC)
Files Files
File description pages shadowing a Commons file or redirect (configuration)	Weekly	14:30, 11 October 2021 (UTC)
Files for daily deletion with an impossible date (configuration)	Weekly	14:31, 11 October 2021 (UTC)
Files tagged for FfD missing an FfD nomination (configuration)	Weekly	14:30, 11 October 2021 (UTC)
Files with conflicting categorization (configuration)	Weekly	06:26, 9 October 2021 (UTC)
Files without a license tag (configuration)	Weekly	14:30, 11 October 2021 (UTC)
Free files which link to Flickr (configuration)	Weekly	14:32, 11 October 2021 (UTC)
Free files without a machine-readable source (configuration)	Weekly	14:31, 11 October 2021 (UTC)
Large fair-use images (configuration)	Weekly	14:30, 11 October 2021 (UTC)
Largely duplicative file names (configuration)	Weekly	15:20, 07 October 2021 (UTC)
Local files with a duplicate on Commons (configuration)	Weekly	14:31, 11 October 2021 (UTC)
Non-free files shadowing a Commons file (configuration)	Weekly	14:31, 11 October 2021 (UTC)
Non-free PDFs (configuration)	Weekly	14:31, 11 October 2021 (UTC)
Orphaned file talk pages (configuration)	Weekly	14:31, 11 October 2021 (UTC)
Orphaned free files tagged keep local (configuration)	Weekly	14:30, 11 October 2021 (UTC)
Orphaned low-resolution free files (configuration)	Weekly	14:31, 11 October 2021 (UTC)
Orphaned PDFs (configuration)	Weekly	14:31, 11 October 2021 (UTC)
Unused file redirects (configuration)	Weekly	00:09, 9 October 2021 (UTC)
Unused non-free files (configuration)	Daily	04:05, 14 October 2021 (UTC)
Pages Pages
Blank single-author pages (configuration)	Weekly	10:00, 07 October 2021 (UTC)
Malformed SPI Cases (configuration)	Weekly	14:30, 11 October 2021 (UTC)
Orphaned article deletion discussions (configuration)	Monthly	11:00, 3 October 2021 (UTC)
Orphaned talk pages (configuration)	Daily	05:02, 14 October 2021 (UTC)
Talk pages by size (configuration)	Weekly	00:18, 8 October 2021 (UTC)
Pages with the most revisions (configuration)	Weekly	00:25, 13 October 2021 (UTC)
Protections Protections
Semi-protected articles with unusually long expiries (configuration)	Monthly	12:00, 07 October 2021 (UTC)
Fully protected articles with unusually long expiries (configuration)	Monthly	12:05, 07 October 2021 (UTC)
Fully salted titles with unusually long expiries	Monthly	—
Indefinitely semi-protected articles	Weekly	—
Indefinitely semi-protected redirects (configuration)	Weekly	00:30, 07 October 2021 (UTC)
Indefinitely fully protected redirects (configuration)	Monthly	13:01, 12 October 2021 (UTC)
Redirects Redirects
Broken section anchors (configuration)	Monthly	12:54, 02 October 2021 (UTC)
Statistics Statistics
Page count by namespace (configuration)	Weekly	00:11, 12 October 2021 (UTC)
Stubs Stubs
Dubious stub categories (configuration)	Weekly	10:00, 01 October 2021 (UTC)
Long stubs (configuration)	Weekly	01:47, 10 October 2021 (UTC)
Untagged stubs (configuration)	Weekly	01:00, 11 October 2021 (UTC)
Templates Templates
All free license tags (configuration)	Weekly	14:30, 11 October 2021 (UTC)
Broken WikiProject templates (configuration)	Weekly	20:15, 07 October 2021 (UTC)
Free license tags which do not exist on Commons (configuration)	Weekly	14:30, 11 October 2021 (UTC)
Invalid Navbar links (configuration)	Monthly	14:53, 01 October 2021 (UTC)
Templates containing links to disambiguation pages (configuration)	Weekly	20:05, 07 October 2021 (UTC)
Transclusions of deleted templates (configuration)	Weekly	15:25, 07 October 2021 (UTC)
Transclusions of non-existent templates (configuration)	Weekly	15:00, 14 October 2021 (UTC)
Unprotected templates with many transclusions (configuration)	Weekly	15:35, 07 October 2021 (UTC)
Unused templates (configuration)	Weekly	06:08, 11 October 2021 (UTC)
WikiProjects WikiProjects
WikiProjects by changes (configuration)	Weekly	05:50, 9 October 2021 (UTC)
WikiProject watchers (configuration)	Weekly	00:01, 13 October 2021 (UTC)
New WikiProjects (configuration)	Fortnightly	22:00, 2 October 2021 (UTC)
Third-party (disambiguations) Third-party (disambiguations)
Articles with links to disambiguation pages	Daily	—
Templates with disambiguation links	Daily	—
Third-party (non-free files) 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) Third-party (generic)
Page moves grouped by user	Hourly	—
Largest pages	Dynamically	—
WikiProject Check Wikipedia reports	Daily	—
Users Users
Blocked users in user groups (configuration)	Fortnightly	15:00, 06 October 2021 (UTC)
Editors eligible for Autopatrol privilege (source)	Daily	22:57, 13 October 2021 (UTC)
Active editors with the longest-established accounts (configuration)	Weekly	08:00, 18 September 2021 (UTC)
Top new article reviewers (source)	Twice daily	15:53, 14 October 2021 (UTC)

Archived reports

An index of disabled reports is available here and in Category:Inactive Wikipedia database reports.

Other reports

• Special:LintErrors
• Wikipedia:Dump reports – historical reference

See also

• Special:SpecialPages
  • Special:ListDuplicatedFiles
• Wikipedia:Request a query

External links

• Quarry – see: wikitech:Help:Cloud Services Introduction