Movatterモバイル変換

[0]ホーム
URL:

Jump to content
WikipediaThe Free Encyclopedia
Search

Wikipedia:Database reports

From Wikipedia, the free encyclopedia
Reports from MediaWiki database queries
Shortcuts
"WP:DBR" redirects here; not to be confused withWP:2R.

Database reports queryMediaWiki 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 thetalk 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]
ReportSize (bytes)Run frequencyData as of
Articles by size (configuration)61,656Weekly00:12, 21 October 2025 (UTC)
Articles containing linked e-mail addresses (configuration)305Weekly10:01, 19 October 2025 (UTC)
Articles containing links to the user space (configuration)3,910Weekly16:57, 19 October 2025 (UTC)
Featured articles by size (configuration)303,494Weekly17:12, 19 October 2025 (UTC)
Forgotten articles (configuration)25,770Weekly00:11, 13 October 2025 (UTC)
Good articles by size (configuration)28Weekly17:33, 19 October 2025 (UTC)
Linked miscapitalizations (configuration)213,094Daily08:25, 26 October 2025 (UTC)
Linked misspellings (configuration)11,269Daily17:25, 25 October 2025 (UTC)
Multiple "Use xxx dates" templates  1,562Daily07:43, 26 October 2025 (UTC)
Multiple "Use xxx English" templates  74,699Daily07:37, 26 October 2025 (UTC)
PRODed articles with deletion logs (configuration)2,176Twice daily06:30, 26 October 2025 (UTC)
Most edited articles last month (configuration)1,383Weekly00:13, 20 October 2025 (UTC)
Orphans with incoming links (configuration)1,092Daily03:00, 25 October 2025 (UTC)
Unbelievable life spans (configuration)839Weekly17:54, 19 October 2025 (UTC)
Interlanguage link templates need to fix (configuration)1,215,160Weekly02:17, 25 October 2025 (UTC)
Vital articles update report (configuration)12,170Daily08:23, 26 October 2025 (UTC)
Pages containing too many maintenance templates (configuration)29,519Weekly15:54, 22 October 2025 (UTC)
Possibly out-of-process deletions—Every three days—
Drafts with categories—Daily—
Short descriptions containing invalid space characters1,829Daily—
Articles with links to drafts6,908Daily—
Biographies of dead people
Recent deaths (configuration)15,567Daily07:36, 26 October 2025 (UTC)
Recent deaths (red links) (configuration)8,415Daily07:36, 26 October 2025 (UTC)
Deaths from the COVID-19 pandemic (configuration)531,147Daily07:36, 26 October 2025 (UTC)
Potential biographies of dead people (1) (configuration)866Weekly17:38, 19 October 2025 (UTC)
Potential biographies of dead people (3) (configuration)148,816Weekly17:41, 19 October 2025 (UTC)
Potential biographies of dead people (4) (configuration)87,343Weekly17:42, 19 October 2025 (UTC)
Biographies of living people
Biographies of living people containing unsourced statements (configuration)15,459Weekly17:54, 19 October 2025 (UTC)
Biographies of living people possibly eligible for deletion (configuration)5,190Weekly17:47, 19 October 2025 (UTC)
Potential biographies of living people (1) (configuration)3,054Weekly17:42, 19 October 2025 (UTC)
Potential biographies of living people (2) (configuration)23,827Weekly17:44, 19 October 2025 (UTC)
Potential biographies of living people (3) (configuration)28,645Weekly17:44, 19 October 2025 (UTC)
Shortest biographies of living people (configuration)32,108Daily18:15, 25 October 2025 (UTC)
Uncategorized and unreferenced biographies of living people (configuration)344Weekly17:54, 19 October 2025 (UTC)
Untagged and unreferenced biographies of living people (configuration)349Weekly17:56, 19 October 2025 (UTC)
Untagged biographies of living people (configuration)4,890Weekly17:55, 19 October 2025 (UTC)
Birthday today (configuration)5,766Daily10:08, 8 October 2025 (UTC)

Blocks

[edit]
ReportSize (bytes)Run frequencyData as of
Indefinitely blocked IPs  20,603Monthly10:55, 24 October 2025 (UTC)
Unusually long IP blocks (configuration)78Monthly08:05, 26 August 2024 (UTC)
Unusually long user blocks (configuration)1,371Monthly00:02, 19 May 2025 (UTC)

Categories

[edit]
ReportSize (bytes)Run frequencyData as of
Categories categorized in red-linked categories (configuration)240No longer updated01:00, 09 October 2022 (UTC)
Empty categories (configuration)1,507Daily18:14, 25 October 2025 (UTC)
Polluted categories (configuration)31,762Weekly16:32, 19 October 2025 (UTC)
Polluted categories (2) (configuration)8,798Ad hoc00:00, 25 October 2025 (UTC)
Polluted categories (3) (configuration)179,251Ad hoc01:01, 25 October 2025 (UTC)
Polluted categories (4) (configuration)388Ad hoc02:00, 25 October 2025 (UTC)
Red-linked categories with incoming links (configuration)3,889Weekly22:00, 05 October 2022 (UTC)
Self-categorized categories (configuration)717Weekly10:06, 22 October 2025 (UTC)
Template categories containing articles  947Daily13:26, 25 October 2025 (UTC)
Uncategorized categories (configuration)6,176Weekly16:45, 19 October 2025 (UTC)
User categories (configuration)28Monthly00:01, 13 October 2025 (UTC)
Polluted administrator categories ​58,470Monthly22:48, 28 September 2025 (UTC)

Files

[edit]
ReportSize (bytes)Run frequencyData as of
File description pages shadowing a Commons file or redirect (configuration)231Weekly14:30, 11 November 2024 (UTC)
Filenames with multiple extensions (configuration)18,880Weekly23:32, 19 October 2025 (UTC)
Files credited to Getty Images (configuration)6,922Weekly23:30, 19 October 2025 (UTC)
Files credited to The Associated Press (configuration)812Weekly23:30, 19 October 2025 (UTC)
Files for daily deletion with an impossible date (configuration)155Weekly14:31, 11 November 2024 (UTC)
Files tagged for FfD missing an FfD nomination (configuration)155Weekly14:30, 11 November 2024 (UTC)
Files with conflicting categorization (configuration)33,058Weekly10:07, 22 October 2025 (UTC)
Files without a license tag (configuration)1,988Weekly14:31, 11 November 2024 (UTC)
Free files which link to Flickr (configuration)23,043Weekly23:32, 19 October 2025 (UTC)
Free files without a machine-readable source (configuration)39,929Weekly23:31, 19 October 2025 (UTC)
Large fair-use images (configuration)897Weekly14:30, 11 November 2024 (UTC)
Largely duplicative file names (configuration)626Daily10:01, 25 October 2025 (UTC)
Largest orphaned free files by bytes (configuration)9,989Daily23:30, 19 October 2025 (UTC)
Local files with a duplicate on Commons (configuration)1,273Weekly14:31, 11 November 2024 (UTC)
Non-free files shadowing a Commons file (configuration)1,138Weekly14:31, 11 November 2024 (UTC)
Non-free PDFs (configuration)611Weekly23:31, 19 October 2025 (UTC)
Orphaned file talk pages (configuration)518Weekly14:31, 11 November 2024 (UTC)
Orphaned files copied to Commons tagged keep local (configuration)4,559Weekly14:32, 11 November 2024 (UTC)
Orphaned free files tagged keep local (configuration)18,064Weekly14:30, 11 November 2024 (UTC)
Orphaned low-resolution free files (configuration)50,670Weekly23:31, 19 October 2025 (UTC)
Orphaned PDFs (configuration)2,728Weekly14:31, 11 November 2024 (UTC)
Overused non-free files (configuration)1,792Weekly17:38, 19 October 2025 (UTC)
Pages containing an unusually high number of non-free files (configuration)9,141Weekly17:36, 19 October 2025 (UTC)
Smallest orphaned free files by bytes (configuration)6,833Weekly23:30, 19 October 2025 (UTC)
Smallest orphaned free files by resolution (configuration)17,684Weekly23:30, 19 October 2025 (UTC)
Templates containing non-free files (configuration)318Weekly17:50, 19 October 2025 (UTC)
Unused file redirects (configuration)428,383Weekly00:09, 1 June 2024 (UTC)
Unused non-free files (configuration)18,690Daily18:16, 25 October 2025 (UTC)

Pages

[edit]
ReportSize (bytes)Run frequencyData as of
Bizarrely subnested userpages (configuration)155,759Weekly05:25, 26 October 2025 (UTC)
Blank single-author pages (configuration)41,031Weekly14:00, 21 October 2025 (UTC)
Malformed SPI Cases (configuration)90Continuously08:37, Sunday, October 26, 2025 (UTC)
Old deletion discussions (configuration)3,467Weekly17:36, 19 October 2025 (UTC)
Orphaned article deletion discussions (configuration)103Monthly11:12, 4 September 2022 (UTC)
Orphaned talk pages (configuration)267Daily05:06, 26 October 2025 (UTC)
Orphaned talk subpages (configuration)571Weekly17:37, 19 October 2025 (UTC)
Pages with the most distinct editors in the last month (configuration)48,525Daily07:25, 26 October 2025 (UTC)
Pages with the most revisions (configuration)49,078Weekly00:32, 22 October 2025 (UTC)
Talk pages by size (configuration)16,227Weekly00:19, 24 October 2025 (UTC)
Unfiled RfAs (configuration)2,109Weekly14:31, 11 November 2024 (UTC)

Protections

[edit]
ReportSize (bytes)Run frequencyData as of
Semi-protected articles with unusually long expiries (configuration)86,317Monthly12:00, 07 October 2022 (UTC)
Fully protected articles with unusually long expiries (configuration)355Monthly12:05, 07 October 2022 (UTC)
Fully protected user talk pages (configuration)14,226Weekly23:30, 19 October 2025 (UTC)
Fully salted titles with unusually long expiries—Monthly—
Indefinitely semi-protected articles—Weekly—
Indefinitely semi-protected redirects (configuration)63Weekly00:30, 06 October 2022 (UTC)
Indefinitely fully protected redirects (configuration)28Monthly04:01, 11 October 2025 (UTC)

Redirects

[edit]
ReportSize (bytes)Run frequencyData as of
Broken section anchors (configuration)1,818,435Monthly01:45, 03 October 2025 (UTC)

Statistics

[edit]
ReportSize (bytes)Run frequencyData as of
Articles with the most redirects (configuration)84,819Monthly00:01, 15 October 2025 (UTC)
Page count by namespace (configuration)1,564Weekly00:13, 14 October 2025 (UTC)

Stubs

[edit]
ReportSize (bytes)Run frequencyData as of
Dubious stub categories (configuration)38,833Weekly10:00, 07 October 2022 (UTC)
Long stubs  21,271Daily22:53, 25 October 2025 (UTC)
Untagged stubs (configuration)34,455Weekly17:56, 19 October 2025 (UTC)

Templates

[edit]
ReportSize (bytes)Run frequencyData as of
All free license tags (configuration)5,793Weekly14:30, 11 November 2024 (UTC)
Broken WikiProject templates (configuration)573Weekly10:07, 22 October 2025 (UTC)
Free license tags which do not exist on Commons (configuration)1,291Weekly14:30, 11 November 2024 (UTC)
Invalid Navbar links (configuration)16,109Monthly15:24, 01 October 2025 (UTC)
Template sandboxes with categories (configuration)76,818Daily11:25, 25 October 2025 (UTC)
Templates containing links to disambiguation pages (configuration)7,814Weekly17:49, 19 October 2025 (UTC)
Templates transcluded on the most pages (configuration)493Weekly05:16, 26 October 2025 (UTC)
Transclusions of non-existent templates (configuration)69,314Daily05:27, 26 October 2025 (UTC)
Uncategorized templates5,865Daily—
Unprotected templates with many transclusions (configuration)63Weekly15:35, 22 September 2022 (UTC)
Unused templates (configuration)28Daily18:19, 25 October 2025 (UTC)
Unused templates (filtered) (configuration)28Daily18:27, 25 October 2025 (UTC)

Timed Text

[edit]
ReportSize (bytes)Run frequencyData as of
Timed Text without a corresponding File (configuration)575Weekly23:31, 19 October 2025 (UTC)

WikiProjects

[edit]
ReportSize (bytes)Run frequencyData as of
WikiProjects by changes (configuration)202,537Weekly17:46, 19 October 2025 (UTC)
WikiProjects by human changes  239,142Daily11:26, 25 October 2025 (UTC)
WikiProjects with no activity  45,645Weekly13:26, 20 October 2025 (UTC)
WikiProject watchers (configuration)66,424Weekly00:00, 22 October 2025 (UTC)
New WikiProjects  1,560Daily18:25, 25 October 2025 (UTC)

Third-party (disambiguations)

[edit]
ReportSize (bytes)Run frequencyData as of
Articles with links to disambiguation pages—Daily—
Templates with disambiguation links—Daily—

Third-party (non-free files)

[edit]
ReportSize (bytes)Run frequencyData as of
Mistagged non-free files—Daily—

Long pages

[edit]
ReportSize (bytes)Run frequencyData as of
Long pages—Tertian—
By namespace
NamespaceTalk namespaceRun frequencyData as of
Main (Special:LongPages)Talk

Talk (no subpages)

Monthly—
UserUser talk

User talk (no subpages)

Monthly—
WikipediaWikipedia talk

Wikipedia talk (no subpages)

Monthly—
FileFile talk

File talk (no subpages)

Monthly—
MediaWikiMediaWiki talk

MediaWiki talk (no subpages)

Monthly—
TemplateTemplate talk

Template talk (no subpages)

Monthly—
HelpHelp talk

Help talk (no subpages)

Monthly—
CategoryCategory talkMonthly—
PortalPortal talk

Portal talk (no subpages)

Monthly—
DraftDraft talkMonthly—
MOSMOS talkMonthly—
TimedTextTimedText talkMonthly—
ModuleModule talk

Module talk (no subpages)

Monthly—
EventEvent talkMonthly—

Third-party (generic)

[edit]
ReportSize (bytes)Run frequencyData as of
Page moves grouped by user—Hourly—
Largest pages—Dynamically—
WikiProject Check Wikipedia reports—Daily—

Users

[edit]
ReportSize (bytes)Run frequencyData as of
Active editors with the longest-established accounts (configuration)12,799Monthly02:00, 21 October 2025 (UTC)
Confirmed autoconfirmed users (configuration)362Weekly23:31, 19 October 2025 (UTC)
Blocked users in user groups85,620Fortnightly—
Editors eligible for Autopatrol privilege (source)184,618Daily02:23, 27 August 2025 (UTC)
Inactive users with advanced permissions  5,193Weekly22:52, 21 October 2025 (UTC)
List of Wikipedians by number of edits—Daily—
Longest active user editing streaks (configuration)6,701Weekly06:51, 21 October 2025 (UTC)
Longest active user article editing streaks (configuration)3,496Weekly21:35, 22 October 2025 (UTC)
Miscategorized users (configuration)32,696Manually20:40, 16 September 2022 (UTC)
Ownerless pages in the user space (configuration)9,511Daily10:05, 25 October 2025 (UTC)
Potential U5s (configuration)28Weekly18:32, 19 October 2025 (UTC)
Top new article reviewers (source)145,463Twice daily03:53, 26 October 2025 (UTC)
Unusually large IP talk pages (configuration)221Weekly23:30, 19 October 2025 (UTC)
Unusually large user talk pages (configuration)104Weekly23:30, 19 October 2025 (UTC)
Userpages with ".com" in their titles (configuration)79,318Weekly20:25, 22 October 2025 (UTC)

Archived reports

[edit]

An index of disabled reports is availablehere and inCategory:Inactive Wikipedia database reports. You can also find an index of all DBR subpages atSpecial:PrefixIndex/Wikipedia:Database reports.

See also

[edit]
For a listing of current collaborations, tasks, and news, see theCommunity portal.
For a listing of ongoing discussions and current requests, see theDashboard.
General community
topics
Contents andgrading
WikiProjects
andcollaborations
Awards andfeedback
Maintenance tasks
Administrators
andnoticeboards
Content dispute
resolution
Other noticeboards
and assistance
Deletion
discussions
Elections andvoting
Directories, indexes,
and summaries
Retrieved from "https://en.wikipedia.org/w/index.php?title=Wikipedia:Database_reports&oldid=1315734775"
Category:
[8]ページ先頭
©2009-2025 Movatter.jp