https://wiki.tachyony.co.uk/w/index.php?action=history&feed=atom&title=Wikipedia%3ADatabase_reports
Wikipedia:Database reports - Revision history
2026-05-15T14:27:25Z
Revision history for this page on the wiki
MediaWiki 1.35.5
https://wiki.tachyony.co.uk/w/index.php?title=Wikipedia:Database_reports&diff=640&oldid=prev
Tachyony: Imported page
2021-12-04T19:14:24Z
<p>Imported page</p>
<p><b>New page</b></p><div>{{short description|Reports made by querying the wiki database}}<br />
{{Maintenance departments}}<br />
{{/Announcements}}<br />
{{shortcut|WP:DBR}}<br />
<br />
'''Database reports''' query [[mw:|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., {{dbr|Untagged stubs}}) and statistical reports, which have past and present informational value (e.g., {{dbr|Page count by namespace}}).<br />
<br />
Many reports such as these can now be generated with the [http://quarry.wmflabs.org/ Quarry] service.<br />
<br />
Reports which are no longer updated can be found in the [[Wikipedia:Database reports/Archive|archive page]] or [[:Category:Inactive Wikipedia database reports|archive category]]. ''All'' subpages of this page (including database report pages, as well as configuration files, exclude lists, etc) can be found at the [[Special:PrefixIndex/Wikipedia:Database_reports|PrefixIndex]] for it.<br />
<br />
Please discuss the current reports or suggest a new report on the [[{{TALKPAGENAME}}|talk page]].<br />
<br />
{{clear}}<br />
<br />
== Current reports ==<br />
{| class="wikitable plainlinks sortable" style="margin:auto; width:100%;"<br />
|- style="white-space:nowrap;"<br />
! Report<br />
! Run frequency<br />
! Data as of<br />
|-<br />
! colspan="3" style="text-align:left;" id="Articles"|Articles<h3 style="display:none">Articles</h3><br />
|-<br />
{{DBR row<br />
| report = Articles containing linked e-mail addresses<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Articles containing links to the user space<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Forgotten articles<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Linked miscapitalizations<br />
| frequency = Daily<br />
}}<br />
{{DBR row<br />
| report = Linked misspellings<br />
| frequency = Daily<br />
}}<br />
{{DBR row<br />
| report = PRODed articles with deletion logs<br />
| frequency = Twice daily<br />
}}<br />
{{DBR row<br />
| report = Most edited articles last month<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Orphans with incoming links<br />
| frequency = Daily<br />
}}<br />
{{DBR row<br />
| report = Interlanguage link templates need to fix<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Vital articles update report<br />
| frequency = Daily<br />
}}<br />
{{DBR row<br />
| report = Pages contains too many maintenance templates<br />
| frequency = Weekly<br />
| config = ([[User:Cewbot/log/20150916/configuration|configuration]])<br />
}}<br />
|-<br />
! colspan="3" style="text-align:left;" id="Biographies of dead people" | {{anchor|BDP}} Biographies of dead people<h3 style="display:none">Biographies of dead people</h3><br />
|-<br />
{{DBR row<br />
| report = Recent deaths<br />
| frequency = Daily<br />
}}<br />
{{DBR row<br />
| report = Deaths from the COVID-19 pandemic<br />
| frequency = Daily<br />
}}<br />
{{DBR row<br />
| report = Potential biographies of dead people (1)<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Potential biographies of dead people (3)<br />
| frequency = Weekly<br />
}}<br />
|-<br />
! colspan="3" style="text-align:left;" id="Biographies of living people" | {{anchor|BLP}} Biographies of living people<h3 style="display:none">Biographies of living people</h3><br />
|-<br />
{{DBR row<br />
| report = Biographies of living people containing unsourced statements<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Biographies of living people possibly eligible for deletion<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Potential biographies of living people (1)<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Potential biographies of living people (2)<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Potential biographies of living people (3)<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Shortest biographies of living people<br />
| frequency = Daily<br />
}}<br />
{{DBR row<br />
| report = Uncategorized and unreferenced biographies of living people<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Untagged and unreferenced biographies of living people<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Untagged biographies of living people<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Birthday today<br />
| frequency = Daily<br />
}}<br />
|-<br />
! colspan="3" style="text-align:left;" id="Blocks" | Blocks<h3 style="display:none">Blocks</h3><br />
|-<br />
{{DBR row<br />
| report = Indefinitely blocked IPs<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Unusually long IP blocks<br />
| frequency = Monthly<br />
| multi-page = True<br />
}}<br />
{{DBR row<br />
| report = Unusually long user blocks<br />
| frequency = Monthly<br />
}}<br />
|-<br />
! colspan="3" style="text-align:left;" id="Categories" | Categories<h3 style="display:none">Categories</h3><br />
|-<br />
{{DBR row<br />
| report = Categories categorized in red-linked categories<br />
| frequency = Weekly<br />
| multi-page = true<br />
}}<br />
{{DBR row<br />
| report = Empty categories<br />
| frequency = Daily<br />
}}<br />
{{DBR row<br />
| report = Polluted categories<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Polluted categories (2)<br />
| frequency = Ad hoc<br />
}}<br />
{{DBR row<br />
| report = Polluted categories (3)<br />
| frequency = Ad hoc<br />
}}<br />
{{DBR row<br />
| report = Polluted categories (4)<br />
| frequency = Ad hoc<br />
}}<br />
{{DBR row<br />
| report = Red-linked categories with incoming links<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Self-categorized categories<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Uncategorized categories<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = User categories<br />
| frequency = Monthly<br />
| multi-page = true<br />
}}<br />
|-<br />
! colspan="3" style="text-align:left;" id="Files" | Files<h3 style="display:none">Files</h3><br />
|-<br />
{{DBR row<br />
| report = File description pages shadowing a Commons file or redirect<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Files for daily deletion with an impossible date<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Files tagged for FfD missing an FfD nomination<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Files with conflicting categorization<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Files without a license tag<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Free files which link to Flickr<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Free files without a machine-readable source<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Large fair-use images<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Largely duplicative file names<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Local files with a duplicate on Commons<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Non-free files shadowing a Commons file<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Non-free PDFs<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Orphaned file talk pages<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Orphaned free files tagged keep local<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Orphaned low-resolution free files<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Orphaned PDFs<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Unused file redirects<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Unused non-free files<br />
| frequency = Daily<br />
}}<br />
|-<br />
! colspan="3" style="text-align:left;" id="Pages"| Pages<h3 style="display:none">Pages</h3><br />
|-<br />
{{DBR row<br />
| report = Blank single-author pages<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Malformed SPI Cases<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Orphaned article deletion discussions<br />
| frequency = Monthly<br />
| multi-page = yes<br />
}}<br />
{{DBR row<br />
| report = Orphaned talk pages<br />
| frequency = Daily<br />
}}<br />
{{DBR row<br />
| report = Talk pages by size<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Pages with the most revisions<br />
| frequency = Weekly<br />
}}<br />
|-<br />
! colspan="3" style="text-align:left;" id="Protections" | Protections<h3 style="display:none">Protections</h3><br />
|-<br />
{{DBR row<br />
| report = Semi-protected articles with unusually long expiries<br />
| frequency = Monthly<br />
}}<br />
{{DBR row<br />
| report = Fully protected articles with unusually long expiries<br />
| frequency = Monthly<br />
}}<br />
|-<br />
| [[Wikipedia:Database reports/Fully salted titles with unusually long expiries|Fully salted titles with unusually long expiries]]<br />
| Monthly<br />
| {{emdash}}<br />
|-<br />
| [[Wikipedia:Database reports/Indefinitely semi-protected articles|Indefinitely semi-protected articles]]<br />
| Weekly<br />
| {{emdash}}<br />
|-<br />
{{DBR row<br />
| report = Indefinitely semi-protected redirects<br />
| frequency = Weekly<br />
| multi-page = true<br />
}}<br />
{{DBR row<br />
| report = Indefinitely fully protected redirects<br />
| frequency = Monthly<br />
| multi-page = true<br />
}}<br />
! colspan="3" style="text-align:left;" id="Redirects" | Redirects<h3 style="display:none">Redirects</h3><br />
|-<br />
{{DBR row<br />
| report = Broken section anchors<br />
| frequency = Monthly<br />
}}<br />
|-<br />
! colspan="3" style="text-align:left;" id="Statistics" | {{anchor|Stats}} Statistics<h3 style="display:none">Statistics</h3><br />
|-<br />
{{DBR row<br />
| report = Page count by namespace<br />
| frequency = Weekly<br />
}}<br />
|-<br />
! colspan="3" style="text-align:left;" id="Stubs" | Stubs<h3 style="display:none">Stubs</h3><br />
|-<br />
{{DBR row<br />
| report = Dubious stub categories<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Long stubs<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Untagged stubs<br />
| frequency = Weekly<br />
}}<br />
|-<br />
! colspan="3" style="text-align:left;" id="Templates" | Templates<h3 style="display:none">Templates</h3><br />
|-<br />
{{DBR row<br />
| report = All free license tags<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Broken WikiProject templates<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Free license tags which do not exist on Commons<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Invalid Navbar links<br />
| frequency = Monthly<br />
}}<br />
{{DBR row<br />
| report = Templates containing links to disambiguation pages<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Templates transcluded on the most pages<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Transclusions of deleted templates<br />
| frequency = Weekly<br />
| multi-page = true<br />
}}<br />
{{DBR row<br />
| report = Transclusions of non-existent templates<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Unprotected templates with many transclusions<br />
| frequency = Weekly<br />
| multi-page = true<br />
}}<br />
{{DBR row<br />
| report = Unused templates<br />
| frequency = Weekly<br />
| multi-page = true<br />
}}<br />
|-<br />
! colspan="3" style="text-align:left;" id="WikiProjects"| WikiProjects<h3 style="display:none">WikiProjects</h3><br />
|-<br />
{{DBR row<br />
| report = WikiProjects by changes<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = WikiProject watchers<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = New WikiProjects<br />
| frequency = Fortnightly<br />
}}<br />
|-<br />
! colspan="3" style="text-align:left;" id="Third-party (disambiguations)" | {{anchor|Disambiguations}} Third-party (disambiguations)<h3 style="display:none">Third-party (disambiguations)</h3><br />
|-<br />
| [[toollabs:dplbot/articles_with_dab_links.php|Articles with links to disambiguation pages]]<br />
| Daily<br />
| —<br />
|-<br />
| [[toollabs:dplbot/templates_with_dab_links.php|Templates with disambiguation links]]<br />
| Daily<br />
| —<br />
|-<br />
! colspan="3" style="text-align:left;" id="Third-party (non-free files)"| Third-party (non-free files)<h3 style="display:none">Third-party (non-free files)</h3><br />
|-<br />
| [[toollabs:betacommand-dev/reports/pages_with_excessive_nfcc.html|Articles containing an unusually high number of non-free files]] <br />
| Daily<br />
| —<br />
|-<br />
| [[toollabs:betacommand-dev/reports/NFCC9.html|Non-free files used outside of mainspace]]<br />
| Daily<br />
| —<br />
|-<br />
| [[toollabs:betacommand-dev/reports/high_use_NFCC.html|Overused non-free files]] <br />
| Daily<br />
| —<br />
|-<br />
| [[c:Commons:Database reports/Mistagged non-free files|Mistagged non-free files]]<br />
| Daily<br />
| —<br />
|-<br />
! colspan="3" style="text-align:left;" id="Third-party (generic)"| Third-party (generic)<h3 style="display:none">Third-party (generic)</h3><br />
|-<br />
| [[toollabs:dplbot/mv/move_watch.php|Page moves grouped by user]]<br />
| Hourly<br />
| —<br />
|-<br />
| [[xtools:largestpages|Largest pages]]<br />
| Dynamically<br />
| —<br />
|-<br />
| [[Wikipedia:WikiProject Check Wikipedia|WikiProject Check Wikipedia]] reports<br />
| Daily<br />
| —<br />
|-<br />
! colspan="3" style="text-align:left;" id="Users" | Users<h3 style="display:none">Users</h3><br />
|-<br />
{{DBR row<br />
| report = Blocked users in user groups<br />
| frequency = Fortnightly<br />
}}<br />
{{DBR row<br />
| report = Editors eligible for Autopatrol privilege<br />
| frequency = Daily<br />
| config = ([https://github.com/MusikAnimal/MusikBot/blob/master/tasks/autopatrolled_candidates.rb source])<br />
}}<br />
{{DBR row<br />
| report = Active editors with the longest-established accounts<br />
| frequency = Weekly<br />
}}<br />
{{DBR row<br />
| report = Top new article reviewers<br />
| frequency = Twice daily<br />
| config = ([https://github.com/MusikAnimal/MusikBot/blob/master/tasks/top_article_reviewers.rb source])<br />
}}<br />
|}<br />
<br />
== Archived reports ==<br />
An index of disabled reports is available [[/Archive|here]] and in [[:Category:Inactive Wikipedia database reports]].<br />
<br />
== Other reports ==<br />
<!-- NO-OP * [https://dispenser.info.tm/~dispenser/view/Dabfix#Reports Dabfix Reports] --><br />
* [[Special:LintErrors]]<br />
* [[Wikipedia:Dump reports]] – historical reference<br />
<br />
== See also ==<br />
* [[Special:SpecialPages]]<br />
** [[Special:ListDuplicatedFiles]]<br />
* [[Wikipedia:Request a query]]<br />
<br />
==External links==<br />
* [https://quarry.wmflabs.org/ Quarry] – see: [[wikitech:Help:Cloud Services Introduction]]<br />
<br />
{{Wikipedia community|state=collapsed}}<br />
<br />
[[Category:Wikipedia database reports| ]]</div>
Tachyony