Wikipedia:Database reports

Shortcuts

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

Articles

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)	5,304	Weekly	10:44, 19 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)	30,985	Daily	12:41, 25 November 2024 (UTC)
Linked misspellings (configuration)	13,893	Daily	12:41, 25 November 2024 (UTC)
PRODed articles with deletion logs (configuration)	4,680	Twice daily	18:30, 25 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)	6,109	Daily	08:09, 25 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,890	Daily	—
Articles with links to drafts	12,194	Daily	—
Biographies of dead people
Recent deaths (configuration)	14,995	Daily	20:02, 25 November 2024 (UTC)
Recent deaths (red links) (configuration)	7,737	Daily	20:02, 25 November 2024 (UTC)
Deaths from the COVID-19 pandemic (configuration)	531,147	Daily	20:02, 25 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,843	Daily	12:41, 25 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

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)

Files

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)	105	Weekly	14:31, 11 November 2024 (UTC)
Files credited to Getty Images (configuration)	57	Weekly	17:20, 24 November 2024 (UTC)
Files credited to The Associated Press (configuration)	65	Weekly	17:21, 24 November 2024 (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)	28,498	Weekly	12:33, 25 November 2024 (UTC)
Files without a license tag (configuration)	1,938	Weekly	14:31, 11 November 2024 (UTC)
Free files which link to Flickr (configuration)	56,463	Weekly	14:31, 11 November 2024 (UTC)
Free files without a machine-readable source (configuration)	38,804	Weekly	14:31, 11 November 2024 (UTC)
Large fair-use images (configuration)	847	Weekly	14:30, 11 November 2024 (UTC)
Largely duplicative file names (configuration)	694	Daily	10:37, 25 November 2024 (UTC)
Largest orphaned free files by bytes (configuration)	63	Daily	17:20, 24 November 2024 (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)	370	Weekly	14:31, 11 November 2024 (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)	52,166	Weekly	14:31, 11 November 2024 (UTC)
Orphaned PDFs (configuration)	2,678	Weekly	14:31, 11 November 2024 (UTC)
Overused non-free files (configuration)	1,749	Weekly	16:35, 19 November 2024 (UTC)
Pages containing an unusually high number of non-free files (configuration)	9,688	Weekly	16:34, 19 November 2024 (UTC)
Smallest orphaned free files by bytes (configuration)	64	Weekly	17:20, 24 November 2024 (UTC)
Smallest orphaned free files by resolution (configuration)	69	Weekly	17:21, 24 November 2024 (UTC)
Templates containing non-free files (configuration)	381	Weekly	16:42, 19 November 2024 (UTC)
Unused file redirects (configuration)	428,333	Weekly	00:09, 1 June 2024 (UTC)
Unused non-free files (configuration)	17,335	Daily	12:43, 25 November 2024 (UTC)

Pages

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

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

Report	Size (bytes)	Run frequency	Data as of
Broken section anchors (configuration)	1,832,117	Monthly	17:48, 02 November 2024 (UTC)

Statistics

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

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

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)	12,972	Daily
Uncategorized templates	5,667	Daily	—
Unprotected templates with many transclusions (configuration)	13	Weekly	15:35, 22 September 2022 (UTC)
Unused templates (configuration)	28	Daily	12:46, 25 November 2024 (UTC)
Unused templates (filtered) (configuration)	28	Daily	12:54, 25 November 2024 (UTC)

Timed Text

Report	Size (bytes)	Run frequency	Data as of
Timed Text without a corresponding File (configuration)	66	Weekly	17:21, 24 November 2024 (UTC)

WikiProjects

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)

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)

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

Report	Size (bytes)	Run frequency	Data as of
Long pages	—	Monthly	—
Long pages (Talk)	—	Monthly	—
Long pages (Talk) (no subpages)	—	Monthly	—
Long pages (User)	—	Monthly	—
Long pages (User talk)	—	Monthly	—
Long pages (User talk) (no subpages)	—	Monthly	—
Long pages (Wikipedia)	—	Monthly	—
Long pages (Wikipedia talk)	—	Monthly	—
Long pages (Wikipedia talk) (no subpages)	—	Monthly	—
Long pages (File)	—	Monthly	—
Long pages (File talk)	—	Monthly	—
Long pages (MediaWiki)	—	Monthly	—
Long pages (MediaWiki talk)	—	Monthly	—
Long pages (Template)	—	Monthly	—
Long pages (Template talk)	—	Monthly	—
Long pages (Help)	—	Monthly	—
Long pages (Help talk)	—	Monthly	—
Long pages (Category)	—	Monthly	—
Long pages (Category talk)	—	Monthly	—
Long pages (Portal)	—	Monthly	—
Long pages (Portal talk)	—	Monthly	—
Long pages (Draft)	—	Monthly	—
Long pages (Draft talk)	—	Monthly	—
Long pages (TimedText)	—	Monthly	—
Long pages (TimedText talk)	—	Monthly	—
Long pages (Module)	—	Monthly	—
Long pages (Module talk)	—	Monthly

Third-party (generic)

Report	Size (bytes)	Run frequency	Data as of
Page moves grouped by user	—	Hourly	—
Largest pages	—	Dynamically	—
WikiProject Check Wikipedia reports	—	Daily	—

Users

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,262	Daily	12:30, 25 November 2024 (UTC)
Potential U5s (configuration)	28	Weekly	04:59, 21 November 2024 (UTC)
Top new article reviewers (source)	148,282	Twice daily	15:53, 25 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

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.

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)	1,003	Daily	12:40, 25 November 2024 (UTC)
Polluted categories (configuration)	12,578	Monthly	10:26, 19 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)	2,108	Weekly	10:37, 19 November 2024 (UTC)
User categories (configuration)	28	Monthly	18:01, 10 November 2024 (UTC)

v t e Wikipedia community
For a listing of current collaborations, tasks, and news, see the Community portal. For a listing of ongoing discussions and current requests, see the Dashboard.
General community topics	Administration News The Signpost Goings-on In the media Meetups Mailing lists Wikipedians Statistics The Wikipedia Library Centralized discussion Village pump Idea lab Policy Proposals Technical Miscellaneous WMF Holidays Bots
Contents and grading	Requested articles Most-wanted articles Images needing articles Articles needing images Articles for creation WP:AFC/R WP:AFC/C Creation Help Vital articles Articles for improvement Peer review Good article nominations Featured article candidates Lists Pictures Topics Article translation Pages Main Page Errors
WikiProjects and collaborations	Directory Culture and the arts Geographical History and society Science, technology and engineering Wikipedia assistance and tasks Patrols Recent changes Counter-Vandalism Unit Accessibility Organizations category
Awards and feedback	Reward board Contests A nice cup of tea and a sit down Charitableness WikiLove Compliment before criticism Kindness Campaign Thanks!
Maintenance tasks	Task Center Open tasks Backlog Category Admin category Edit requests Category Database reports Category tracker Dusty articles Special pages New pages Recent changes Controversial issues
Administrators and noticeboards	Administrators' noticeboard Incidents Edit warring Vandalism Admin dashboard Admin requests Closure Page protection User permissions Sockpuppets Open proxies Revision deletion Oversight Request Usernames Changing Title blacklist OTRS Bureaucrats' Requests for adminship and bureaucratship Arbitration Committee Requests Enforcement
Content dispute resolution	Requests for comment Third opinion Dispute resolution noticeboard Biographies of living persons Conflict of interest External links Fringe theories Neutral point of view No original research Reliable sources
Other noticeboards and assistance	Regional notice boards Requests for help Category Asking questions Teahouse Help desk Reference desk Adopt-a-user Copyright assistance Copyright investigations Text problems Media questions Resource requests Mergers History mergers Moves Page importation Spam Blacklist Whitelist Bots Education General sanctions Editor sanctions Long-term abuse
Deletion discussions	Guide Admin Today Articles Templates Files Categories Redirects Miscellany Speedy Proposed BLP Review Undeletion Arguments to avoid Arguments to make Article Rescue
Elections and voting	Requests for comment (meta) Wikimedia Foundation elections WP Democracy Voting is not evil Milestones
Directories, indexes, and summaries	Departments Edit summary legend Editor's index Essays FAQs Glossary Abbreviations Help Manual of Style Simplified Rules Five pillars Policies Guidelines Shortcuts Templates Citation templates Tips Today Tools Wiki markup
Media Category Templates