View source for Wikipedia:Database reports

{{short description|Reports made by querying the wiki database}}
{{Maintenance departments}}
{{/Announcements}}
{{shortcut|WP:DBR}}

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

Many reports such as these can now be generated with the  [http://quarry.wmflabs.org/ Quarry] service.

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.

Please discuss the current reports or suggest a new report on the [[{{TALKPAGENAME}}|talk page]].

{{clear}}

== Current reports ==
{| class="wikitable plainlinks sortable" style="margin:auto; width:100%;"
|- style="white-space:nowrap;"
! Report
! Run frequency
! Data as of
|-
! colspan="3" style="text-align:left;" id="Articles"|Articles<h3 style="display:none">Articles</h3>
|-
{{DBR row
| report = Articles containing linked e-mail addresses
| frequency = Weekly
}}
{{DBR row
| report = Articles containing links to the user space
| frequency = Weekly
}}
{{DBR row
| report = Forgotten articles
| frequency = Weekly
}}
{{DBR row
| report = Linked miscapitalizations
| frequency = Daily
}}
{{DBR row
| report = Linked misspellings
| frequency = Daily
}}
{{DBR row
| report = PRODed articles with deletion logs
| frequency = Twice daily
}}
{{DBR row
| report = Most edited articles last month
| frequency = Weekly
}}
{{DBR row
| report = Orphans with incoming links
| frequency = Daily
}}
{{DBR row
| report = Interlanguage link templates need to fix
| frequency = Weekly
}}
{{DBR row
| report = Vital articles update report
| frequency = Daily
}}
{{DBR row
| report = Pages contains too many maintenance templates
| frequency = Weekly
| config = ([[User:Cewbot/log/20150916/configuration|configuration]])
}}
|-
! 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>
|-
{{DBR row
| report = Recent deaths
| frequency = Daily
}}
{{DBR row
| report = Deaths from the COVID-19 pandemic
| frequency = Daily
}}
{{DBR row
| report = Potential biographies of dead people (1)
| frequency = Weekly
}}
{{DBR row
| report = Potential biographies of dead people (3)
| frequency = Weekly
}}
|-
! 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>
|-
{{DBR row
| report = Biographies of living people containing unsourced statements
| frequency = Weekly
}}
{{DBR row
| report = Biographies of living people possibly eligible for deletion
| frequency = Weekly
}}
{{DBR row
| report = Potential biographies of living people (1)
| frequency = Weekly
}}
{{DBR row
| report = Potential biographies of living people (2)
| frequency = Weekly
}}
{{DBR row
| report = Potential biographies of living people (3)
| frequency = Weekly
}}
{{DBR row
| report = Shortest biographies of living people
| frequency = Daily
}}
{{DBR row
| report = Uncategorized and unreferenced biographies of living people
| frequency = Weekly
}}
{{DBR row
| report = Untagged and unreferenced biographies of living people
| frequency = Weekly
}}
{{DBR row
| report = Untagged biographies of living people
| frequency = Weekly
}}
{{DBR row
| report = Birthday today
| frequency = Daily
}}
|-
! colspan="3" style="text-align:left;" id="Blocks" | Blocks<h3 style="display:none">Blocks</h3>
|-
{{DBR row
| report = Indefinitely blocked IPs
| frequency = Weekly
}}
{{DBR row
| report = Unusually long IP blocks
| frequency = Monthly
| multi-page = True
}}
{{DBR row
| report = Unusually long user blocks
| frequency = Monthly
}}
|-
! colspan="3" style="text-align:left;" id="Categories" | Categories<h3 style="display:none">Categories</h3>
|-
{{DBR row
| report = Categories categorized in red-linked categories
| frequency = Weekly
| multi-page = true
}}
{{DBR row
| report = Empty categories
| frequency = Daily
}}
{{DBR row
| report = Polluted categories
| frequency = Weekly
}}
{{DBR row
| report = Polluted categories (2)
| frequency = Ad hoc
}}
{{DBR row
| report = Polluted categories (3)
| frequency = Ad hoc
}}
{{DBR row
| report = Polluted categories (4)
| frequency = Ad hoc
}}
{{DBR row
| report = Red-linked categories with incoming links
| frequency = Weekly
}}
{{DBR row
| report = Self-categorized categories
| frequency = Weekly
}}
{{DBR row
| report = Uncategorized categories
| frequency = Weekly
}}
{{DBR row
| report = User categories
| frequency = Monthly
| multi-page = true
}}
|-
! colspan="3" style="text-align:left;" id="Files" | Files<h3 style="display:none">Files</h3>
|-
{{DBR row
| report = File description pages shadowing a Commons file or redirect
| frequency = Weekly
}}
{{DBR row
| report = Files for daily deletion with an impossible date
| frequency = Weekly
}}
{{DBR row
| report = Files tagged for FfD missing an FfD nomination
| frequency = Weekly
}}
{{DBR row
| report = Files with conflicting categorization
| frequency = Weekly
}}
{{DBR row
| report = Files without a license tag
| frequency = Weekly
}}
{{DBR row
| report = Free files which link to Flickr
| frequency = Weekly
}}
{{DBR row
| report = Free files without a machine-readable source
| frequency = Weekly
}}
{{DBR row
| report = Large fair-use images
| frequency = Weekly
}}
{{DBR row
| report = Largely duplicative file names
| frequency = Weekly
}}
{{DBR row
| report = Local files with a duplicate on Commons
| frequency = Weekly
}}
{{DBR row
| report = Non-free files shadowing a Commons file
| frequency = Weekly
}}
{{DBR row
| report = Non-free PDFs
| frequency = Weekly
}}
{{DBR row
| report = Orphaned file talk pages
| frequency = Weekly
}}
{{DBR row
| report = Orphaned free files tagged keep local
| frequency = Weekly
}}
{{DBR row
| report = Orphaned low-resolution free files
| frequency = Weekly
}}
{{DBR row
| report = Orphaned PDFs
| frequency = Weekly
}}
{{DBR row
| report = Unused file redirects
| frequency = Weekly
}}
{{DBR row
| report = Unused non-free files
| frequency = Daily
}}
|-
! colspan="3" style="text-align:left;" id="Pages"| Pages<h3 style="display:none">Pages</h3>
|-
{{DBR row
| report = Blank single-author pages
| frequency = Weekly
}}
{{DBR row
| report = Malformed SPI Cases
| frequency = Weekly
}}
{{DBR row
| report = Orphaned article deletion discussions
| frequency = Monthly
| multi-page = yes
}}
{{DBR row
| report = Orphaned talk pages
| frequency = Daily
}}
{{DBR row
| report = Talk pages by size
| frequency = Weekly
}}
{{DBR row
| report = Pages with the most revisions
| frequency = Weekly
}}
|-
! colspan="3" style="text-align:left;" id="Protections" | Protections<h3 style="display:none">Protections</h3>
|-
{{DBR row
| report = Semi-protected articles with unusually long expiries
| frequency = Monthly
}}
{{DBR row
| report = Fully protected articles with unusually long expiries
| frequency = Monthly
}}
|-
| [[Wikipedia:Database reports/Fully salted titles with unusually long expiries|Fully salted titles with unusually long expiries]]
| Monthly
| {{emdash}}
|-
| [[Wikipedia:Database reports/Indefinitely semi-protected articles|Indefinitely semi-protected articles]]
| Weekly
| {{emdash}}
|-
{{DBR row
| report = Indefinitely semi-protected redirects
| frequency = Weekly
| multi-page = true
}}
{{DBR row
| report = Indefinitely fully protected redirects
| frequency = Monthly
| multi-page = true
}}
! colspan="3" style="text-align:left;" id="Redirects" | Redirects<h3 style="display:none">Redirects</h3>
|-
{{DBR row
| report = Broken section anchors
| frequency = Monthly
}}
|-
! colspan="3" style="text-align:left;" id="Statistics" | {{anchor|Stats}} Statistics<h3 style="display:none">Statistics</h3>
|-
{{DBR row
| report = Page count by namespace
| frequency = Weekly
}}
|-
! colspan="3" style="text-align:left;" id="Stubs" | Stubs<h3 style="display:none">Stubs</h3>
|-
{{DBR row
| report = Dubious stub categories
| frequency = Weekly
}}
{{DBR row
| report = Long stubs
| frequency = Weekly
}}
{{DBR row
| report = Untagged stubs
| frequency = Weekly
}}
|-
! colspan="3" style="text-align:left;" id="Templates" | Templates<h3 style="display:none">Templates</h3>
|-
{{DBR row
| report = All free license tags
| frequency = Weekly
}}
{{DBR row
| report = Broken WikiProject templates
| frequency = Weekly
}}
{{DBR row
| report = Free license tags which do not exist on Commons
| frequency = Weekly
}}
{{DBR row
| report = Invalid Navbar links
| frequency = Monthly
}}
{{DBR row
| report = Templates containing links to disambiguation pages
| frequency = Weekly
}}
{{DBR row
| report = Templates transcluded on the most pages
| frequency = Weekly
}}
{{DBR row
| report = Transclusions of deleted templates
| frequency = Weekly
| multi-page = true
}}
{{DBR row
| report = Transclusions of non-existent templates
| frequency = Weekly
}}
{{DBR row
| report = Unprotected templates with many transclusions
| frequency = Weekly
| multi-page = true
}}
{{DBR row
| report = Unused templates
| frequency = Weekly
| multi-page = true
}}
|-
! colspan="3" style="text-align:left;" id="WikiProjects"| WikiProjects<h3 style="display:none">WikiProjects</h3>
|-
{{DBR row
| report = WikiProjects by changes
| frequency = Weekly
}}
{{DBR row
| report = WikiProject watchers
| frequency = Weekly
}}
{{DBR row
| report = New WikiProjects
| frequency = Fortnightly
}}
|-
! colspan="3" style="text-align:left;" id="Third-party (disambiguations)" | {{anchor|Disambiguations}} Third-party (disambiguations)<h3 style="display:none">Third-party (disambiguations)</h3>
|-
| [[toollabs:dplbot/articles_with_dab_links.php|Articles with links to disambiguation pages]]
| Daily
| —
|-
| [[toollabs:dplbot/templates_with_dab_links.php|Templates with disambiguation links]]
| Daily
| —
|-
! 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>
|-
| [[toollabs:betacommand-dev/reports/pages_with_excessive_nfcc.html|Articles containing an unusually high number of non-free files]] 
| Daily
| —
|-
| [[toollabs:betacommand-dev/reports/NFCC9.html|Non-free files used outside of mainspace]]
| Daily
| —
|-
| [[toollabs:betacommand-dev/reports/high_use_NFCC.html|Overused non-free files]] 
| Daily
| —
|-
| [[c:Commons:Database reports/Mistagged non-free files|Mistagged non-free files]]
| Daily
| —
|-
! colspan="3" style="text-align:left;" id="Third-party (generic)"| Third-party (generic)<h3 style="display:none">Third-party (generic)</h3>
|-
| [[toollabs:dplbot/mv/move_watch.php|Page moves grouped by user]]
| Hourly
| —
|-
| [[xtools:largestpages|Largest pages]]
| Dynamically
| —
|-
| [[Wikipedia:WikiProject Check Wikipedia|WikiProject Check Wikipedia]] reports
| Daily
| —
|-
! colspan="3" style="text-align:left;" id="Users" | Users<h3 style="display:none">Users</h3>
|-
{{DBR row
| report = Blocked users in user groups
| frequency = Fortnightly
}}
{{DBR row
| report = Editors eligible for Autopatrol privilege
| frequency = Daily
| config = ([https://github.com/MusikAnimal/MusikBot/blob/master/tasks/autopatrolled_candidates.rb source])
}}
{{DBR row
| report = Active editors with the longest-established accounts
| frequency = Weekly
}}
{{DBR row
| report = Top new article reviewers
| frequency = Twice daily
| config = ([https://github.com/MusikAnimal/MusikBot/blob/master/tasks/top_article_reviewers.rb source])
}}
|}

== Archived reports ==
An index of disabled reports is available [[/Archive|here]] and in [[:Category:Inactive Wikipedia database reports]].

== Other reports ==
<!-- NO-OP * [https://dispenser.info.tm/~dispenser/view/Dabfix#Reports Dabfix Reports] -->
* [[Special:LintErrors]]
* [[Wikipedia:Dump reports]] – historical reference

== See also ==
* [[Special:SpecialPages]]
** [[Special:ListDuplicatedFiles]]
* [[Wikipedia:Request a query]]

==External links==
* [https://quarry.wmflabs.org/ Quarry] – see: [[wikitech:Help:Cloud Services Introduction]]

{{Wikipedia community|state=collapsed}}

[[Category:Wikipedia database reports| ]]