WP:database reports
{{Short description|Reports from MediaWiki database queries}}
{{shortcut|WP:DBR|WP: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., {{dbr|Untagged stubs}}) and statistical reports, which have past and present informational value (e.g., {{dbr|Page count by namespace}}).
Please discuss the current reports or suggest a new report on the talk page.
Current reports
= Articles =
class="wikitable plainlinks sortable" style="margin: auto; width: 100%;" |
style="white-space: nowrap;"
! Report ! Size (bytes) ! Run frequency ! Data as of |
{{DBR row
| report = Articles by size | frequency = Weekly }} {{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 = Featured articles by size | frequency = Weekly }} {{DBR row | report = Forgotten articles | frequency = Weekly }} {{DBR row | report = Good articles by size | frequency = Weekly | multi-page = true }} {{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 = Unbelievable life spans | frequency = Weekly }} {{DBR row | report = Interlanguage link templates need to fix | frequency = Weekly }} {{DBR row | report = Vital articles update report | frequency = Daily | config = (configuration) }} {{DBR row | report = Pages containing too many maintenance templates | frequency = Weekly | config = (configuration) }} |
Possibly out-of-process deletions
| {{emdash}} | Every three days | {{emdash}} |
Drafts with categories
| {{emdash}} | Daily | {{emdash}} |
Short descriptions containing invalid space characters
| {{PAGESIZE:Wikipedia:Database reports/Short descriptions containing invalid space characters}} | Daily | {{emdash}} |
Articles with links to drafts
| {{PAGESIZE:Wikipedia:Database reports/Articles with links to drafts}} | Daily | {{emdash}} |
colspan="4" style="text-align:left;" id="Biographies of dead people" | {{anchor|BDP}} Biographies of dead people |
---|
{{DBR row
| report = Recent deaths | frequency = Daily }} {{DBR row | report = Recent deaths (red links) | 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 }} {{DBR row | report = Potential biographies of dead people (4) | frequency = Weekly }} |
colspan="4" style="text-align:left;" id="Biographies of living people" | {{anchor|BLP}} Biographies of living people |
{{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 }} |
= Blocks =
class="wikitable plainlinks sortable" style="margin: auto; width: 100%;" |
style="white-space: nowrap;"
! Report ! Size (bytes) ! Run frequency ! Data as of |
{{DBR row
| report = Indefinitely blocked IPs | frequency = Monthly | config= }} {{DBR row | report = Unusually long IP blocks | frequency = Monthly | multi-page = True }} {{DBR row | report = Unusually long user blocks | frequency = Monthly }} |
= Categories =
class="wikitable plainlinks sortable" style="margin: auto; width: 100%;" |
style="white-space: nowrap;"
! Report ! Size (bytes) ! Run frequency ! Data as of |
{{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 = Template categories containing articles | frequency = Weekly }} {{DBR row | report = Uncategorized categories | frequency = Weekly }} {{DBR row | report = User categories | frequency = Monthly | multi-page = true }} |
= Files =
class="wikitable plainlinks sortable" style="margin: auto; width: 100%;" |
style="white-space: nowrap;"
! Report ! Size (bytes) ! Run frequency ! Data as of |
{{DBR row
| report = File description pages shadowing a Commons file or redirect | frequency = Weekly }} {{DBR row | report = Filenames with multiple extensions | frequency = Weekly }} {{DBR row | report = Files credited to Getty Images | frequency = Weekly }} {{DBR row | report = Files credited to The Associated Press | 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 = Daily }} {{DBR row | report = Largest orphaned free files by bytes | frequency = Daily }} {{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 files copied to Commons tagged keep local | 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 = Overused non-free files | frequency = Weekly }} {{DBR row | report = Pages containing an unusually high number of non-free files | frequency = Weekly }} {{DBR row | report = Smallest orphaned free files by bytes | frequency = Weekly }} {{DBR row | report = Smallest orphaned free files by resolution | frequency = Weekly }} {{DBR row | report = Templates containing non-free files | frequency = Weekly }} {{DBR row | report = Unused file redirects | frequency = Weekly }} {{DBR row | report = Unused non-free files | frequency = Daily }} |
= Pages =
class="wikitable plainlinks sortable" style="margin: auto; width: 100%;" |
style="white-space: nowrap;"
! Report ! Size (bytes) ! Run frequency ! Data as of |
{{DBR row
| report = Bizarrely subnested userpages | frequency = Weekly }} {{DBR row | report = Blank single-author pages | frequency = Weekly }} {{DBR row | report = Malformed SPI Cases | frequency = Continuously }} {{DBR row | report = Old deletion discussions | 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 = Orphaned talk subpages | frequency = Weekly }} {{DBR row | report = Pages with the most revisions | frequency = Weekly }} {{DBR row | report = Talk pages by size | frequency = Weekly }} {{DBR row | report = Unfiled RfAs | frequency = Weekly }} |
= Protections =
class="wikitable plainlinks sortable" style="margin: auto; width: 100%;" |
style="white-space: nowrap;"
! Report ! Size (bytes) ! Run frequency ! Data as of |
{{DBR row
| report = Semi-protected articles with unusually long expiries | frequency = Monthly }} {{DBR row | report = Fully protected articles with unusually long expiries | frequency = Monthly }} {{DBR row | report = Fully protected user talk pages | frequency = Weekly }} |
Fully salted titles with unusually long expiries
| {{emdash}} | Monthly | {{emdash}} |
Indefinitely semi-protected articles
| {{emdash}} | 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 }} |
= Redirects =
class="wikitable plainlinks sortable" style="margin: auto; width: 100%;" |
style="white-space: nowrap;"
! Report ! Size (bytes) ! Run frequency ! Data as of |
{{DBR row
| report = Broken section anchors | frequency = Monthly }} |
= Statistics =
class="wikitable plainlinks sortable" style="margin: auto; width: 100%;" |
style="white-space: nowrap;"
! Report ! Size (bytes) ! Run frequency ! Data as of |
{{DBR row
| report = Articles with the most redirects | frequency = Monthly }} {{DBR row | report = Page count by namespace | frequency = Weekly }} |
= Stubs =
class="wikitable plainlinks sortable" style="margin: auto; width: 100%;" |
style="white-space: nowrap;"
! Report ! Size (bytes) ! Run frequency ! Data as of |
{{DBR row
| report = Dubious stub categories | frequency = Weekly }} {{DBR row | report = Long stubs | frequency = Weekly }} {{DBR row | report = Untagged stubs | frequency = Weekly }} |
= Templates =
class="wikitable plainlinks sortable" style="margin: auto; width: 100%;" |
style="white-space: nowrap;"
! Report ! Size (bytes) ! Run frequency ! Data as of |
{{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 = Template sandboxes with categories | frequency = Daily }} {{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 non-existent templates | frequency = Daily }} | {{PAGESIZE:Wikipedia:Database reports/Uncategorized templates}} | Daily | {{emdash}} |
{{DBR row
| report = Unprotected templates with many transclusions | frequency = Weekly | multi-page = true }} {{DBR row | report = Unused templates | frequency = Daily | multi-page = true }} {{DBR row | report = Unused templates (filtered) | frequency = Daily | multi-page = true }} |
= Timed Text =
class="wikitable plainlinks sortable" style="margin: auto; width: 100%;" |
style="white-space: nowrap;"
! Report ! Size (bytes) ! Run frequency ! Data as of |
{{DBR row
| report = Timed Text without a corresponding File | frequency = Weekly }} |
= WikiProjects =
class="wikitable plainlinks sortable" style="margin: auto; width: 100%;" |
style="white-space: nowrap;"
! Report ! Size (bytes) ! Run frequency ! Data as of |
{{DBR row
| report = WikiProjects by changes | frequency = Weekly }} {{DBR row | report = WikiProject watchers | frequency = Weekly }} {{DBR row | report = New WikiProjects | frequency = Fortnightly }} |
= Third-party (disambiguations) =
class="wikitable plainlinks sortable" style="margin: auto; width: 100%;" |
style="white-space: nowrap;"
! Report ! Size (bytes) ! Run frequency ! Data as of |
Articles with links to disambiguation pages
| {{emdash}} | Daily | — |
Templates with disambiguation links
| {{emdash}} | Daily | — |
= Third-party (non-free files) =
class="wikitable plainlinks sortable" style="margin: auto; width: 100%;" |
style="white-space: nowrap;"
! Report ! Size (bytes) ! Run frequency ! Data as of |
Articles containing an unusually high number of non-free files
| {{emdash}} | Daily | — |
Non-free files used outside of mainspace
| {{emdash}} | Daily | — |
Overused non-free files
| {{emdash}} | Daily | — |
Mistagged non-free files
| {{emdash}} | Daily | — |
= Long pages by namespace =
class="wikitable plainlinks sortable" style="margin: auto; width: 100%;" |
style="white-space: nowrap;"
! 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) =
class="wikitable plainlinks sortable" style="margin: auto; width: 100%;" |
style="white-space: nowrap;"
! Report ! Size (bytes) ! Run frequency ! Data as of |
Page moves grouped by user
| {{emdash}} | Hourly | — |
Largest pages
| {{emdash}} | Dynamically | — |
WikiProject Check Wikipedia reports
| {{emdash}} | Daily | — |
= Users =
class="wikitable plainlinks sortable" style="margin: auto; width: 100%;" |
style="white-space: nowrap;"
! Report ! Size (bytes) ! Run frequency ! Data as of |
{{DBR row
| report = Active editors with the longest-established accounts | frequency = Monthly }} {{DBR row | report = Confirmed autoconfirmed users | frequency = Weekly }} | Blocked users in user groups | {{PAGESIZE:Wikipedia:Database reports/Blocked users in user groups}} | Fortnightly | {{emdash}} |
{{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 = Inactive users with advanced permissions | frequency = Weekly | config= }} | List of Wikipedians by number of edits | {{emdash}} | Daily | — |
{{DBR row
| report = Longest active user editing streaks | frequency = Weekly }} {{DBR row | report = Longest active user article editing streaks | frequency = Weekly }} {{DBR row | report = Miscategorized users | frequency = Manually }} {{DBR row | report = Ownerless pages in the user space | frequency = Daily }} {{DBR row | report = Potential U5s | frequency = Weekly | multi-page = true }} {{DBR row | report = Top new article reviewers | frequency = Twice daily | config = ([https://github.com/MusikAnimal/MusikBot/blob/master/tasks/top_article_reviewers.rb source]) }} {{DBR row | report = Unusually large IP talk pages | frequency = Weekly }} {{DBR row | report = Unusually large user talk pages | frequency = Weekly }} {{DBR row | report = Userpages with ".com" in their titles | frequency = 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.
See also
- Special:SpecialPages
- Special:ListDuplicatedFiles
- Special:LintErrors
- Wikipedia:Request a query
- Wikipedia:Dump reports – historical reference
- Quarry – see: wikitech:Help:Cloud Services introduction
- Wikipedia:WikiProject Check Wikipedia
- Wikipedia:Typo Team/moss
{{Wikipedia community|state=collapsed}}