Wikipedia:Database 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., 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
edit| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Articles | |||
| Articles by size (configuration) | 61,627 | Weekly | 00:12, 23 July 2024 (UTC)2024-07-23T00:12:00+00:00 |
| Articles containing linked e-mail addresses (configuration) | 302 | Weekly | 20:03, 25 July 2024 (UTC)2024-07-25T20:03:00+00:00 |
| Articles containing links to the user space (configuration) | 1,436 | Weekly | 04:41, 26 July 2024 (UTC)2024-07-26T04:41:00+00:00 |
| Featured articles by size (configuration) | 292,599 | Weekly | 05:02, 26 July 2024 (UTC)2024-07-26T05:02:00+00:00 |
| Forgotten articles (configuration) | 27,004 | Weekly | 01:50, 22 July 2024 (UTC)2024-07-22T01:50:00+00:00 |
| Good articles by size (configuration) | 28 | Weekly | 05:19, 26 July 2024 (UTC)2024-07-26T05:19:00+00:00 |
| Linked miscapitalizations (configuration) | 16,577 | Daily | 06:35, 27 July 2024 (UTC)2024-07-27T06:35:00+00:00 |
| Linked misspellings (configuration) | 6,396 | Daily | 06:36, 27 July 2024 (UTC)2024-07-27T06:36:00+00:00 |
| PRODed articles with deletion logs (configuration) | 2,642 | Twice daily | 06:30, 27 July 2024 (UTC)2024-07-27T06:30:00+00:00 |
| Most edited articles last month (configuration) | 1,448 | Weekly | 00:19, 22 July 2024 (UTC)2024-07-22T00:19:00+00:00 |
| Orphans with incoming links (configuration) | 1,219 | Daily | 23:59, 25 July 2024 (UTC)2024-07-25T23:59:00+00:00 |
| Unbelievable life spans (configuration) | 590 | Weekly | 11:26, 26 July 2024 (UTC)2024-07-26T11:26:00+00:00 |
| Interlanguage link templates need to fix (configuration) | 1,181,220 | Weekly | 00:14, 27 July 2024 (UTC)2024-07-27T00:14:00+00:00 |
| Vital articles update report (configuration) | 5,683 | Daily | 08:12, 25 July 2024 (UTC)2024-07-25T08:12:00+00:00 |
| Pages containing too many maintenance templates (configuration) | 14,059 | Weekly | 17:37, 6 July 2024 (UTC)2024-07-06T17:37:00+00:00 |
| Possibly out-of-process deletions | — | Every three days | — |
| Drafts with categories | — | Daily | — |
| Short descriptions containing invalid space characters | 1,951 | Daily | — |
| Articles with links to drafts | 4,601 | Daily | — |
| Biographies of dead people | |||
| Recent deaths (configuration) | 13,488 | Daily | 06:46, 27 July 2024 (UTC)2024-07-27T06:46:00+00:00 |
| Recent deaths (red links) (configuration) | 8,208 | Daily | 06:46, 27 July 2024 (UTC)2024-07-27T06:46:00+00:00 |
| Deaths from the COVID-19 pandemic (configuration) | 531,147 | Daily | 06:46, 27 July 2024 (UTC)2024-07-27T06:46:00+00:00 |
| Potential biographies of dead people (1) (configuration) | 485 | Weekly | 10:58, 26 July 2024 (UTC)2024-07-26T10:58:00+00:00 |
| Potential biographies of dead people (3) (configuration) | 110,349 | Weekly | 11:03, 26 July 2024 (UTC)2024-07-26T11:03:00+00:00 |
| Biographies of living people | |||
| Biographies of living people containing unsourced statements (configuration) | 15,509 | Weekly | 11:26, 26 July 2024 (UTC)2024-07-26T11:26:00+00:00 |
| Biographies of living people possibly eligible for deletion (configuration) | 11,672 | Weekly | 11:13, 26 July 2024 (UTC)2024-07-26T11:13:00+00:00 |
| Potential biographies of living people (1) (configuration) | 3,448 | Weekly | 11:06, 26 July 2024 (UTC)2024-07-26T11:06:00+00:00 |
| Potential biographies of living people (2) (configuration) | 14,277 | Weekly | 11:07, 26 July 2024 (UTC)2024-07-26T11:07:00+00:00 |
| Potential biographies of living people (3) (configuration) | 27,694 | Weekly | 11:08, 26 July 2024 (UTC)2024-07-26T11:08:00+00:00 |
| Shortest biographies of living people (configuration) | 31,931 | Daily | 11:12, 26 July 2024 (UTC)2024-07-26T11:12:00+00:00 |
| Uncategorized and unreferenced biographies of living people (configuration) | 361 | Weekly | 11:26, 26 July 2024 (UTC)2024-07-26T11:26:00+00:00 |
| Untagged and unreferenced biographies of living people (configuration) | 346 | Weekly | 11:28, 26 July 2024 (UTC)2024-07-26T11:28:00+00:00 |
| Untagged biographies of living people (configuration) | 10,911 | Weekly | 11:27, 26 July 2024 (UTC)2024-07-26T11:27:00+00:00 |
| Birthday today (configuration) | 6,803 | Daily | 02:57, 20 June 2024 (UTC)2024-06-20T02:57:00+00:00 |
| Blocks | |||
| Indefinitely blocked IPs (configuration) | 382 | Weekly | 08:01, 11 July 2024 (UTC)2024-07-11T08:01:00+00:00 |
| Unusually long IP blocks (configuration) | 28 | Monthly | This page is intentionally left blank. (error parsing "This page is intentionally left blank.") |
| Unusually long user blocks (configuration) | 1,508 | Monthly | 18:08, 13 July 2024 (UTC)2024-07-13T18:08:00+00:00 |
| Categories | |||
| Categories categorized in red-linked categories (configuration) | 240 | Weekly | 01:00, 09 October 2022 (UTC)2022-10-09T01:00:00+00:00 |
| Empty categories (configuration) | 1,232 | Daily | 06:35, 27 July 2024 (UTC)2024-07-27T06:35:00+00:00 |
| Polluted categories (configuration) | 14,823 | Monthly | 20:58, 25 July 2024 (UTC)2024-07-25T20:58:00+00:00 |
| Polluted categories (2) (configuration) | 2,821 | Ad hoc | 00:01, 27 July 2024 (UTC)2024-07-27T00:01:00+00:00 |
| Polluted categories (3) (configuration) | 149,741 | Ad hoc | 01:00, 27 July 2024 (UTC)2024-07-27T01:00:00+00:00 |
| Polluted categories (4) (configuration) | 574 | Ad hoc | 00:01, 26 July 2024 (UTC)2024-07-26T00:01:00+00:00 |
| Red-linked categories with incoming links (configuration) | 3,839 | Weekly | 22:00, 05 October 2022 (UTC)2022-10-05T22:00:00+00:00 |
| Self-categorized categories (configuration) | 773 | Weekly | 21:01, 25 July 2024 (UTC)2024-07-25T21:01:00+00:00 |
| Template categories containing articles (configuration) | 441 | Weekly | 10:58, 26 July 2024 (UTC)2024-07-26T10:58:00+00:00 |
| Uncategorized categories (configuration) | 3,183 | Weekly | 21:57, 25 July 2024 (UTC)2024-07-25T21:57:00+00:00 |
| User categories (configuration) | 28 | Monthly | 16:03, 21 July 2024 (UTC)2024-07-21T16:03:00+00:00 |
| Files | |||
| File description pages shadowing a Commons file or redirect (configuration) | 227 | Weekly | 14:30, 22 July 2024 (UTC)2024-07-22T14:30:00+00:00 |
| Filenames with multiple extensions (configuration) | 101 | Weekly | 14:32, 22 July 2024 (UTC)2024-07-22T14:32:00+00:00 |
| Files credited to Getty Images (configuration) | 4,971 | Weekly | 14:33, 22 July 2024 (UTC)2024-07-22T14:33:00+00:00 |
| Files credited to The Associated Press (configuration) | 716 | Weekly | 14:33, 22 July 2024 (UTC)2024-07-22T14:33:00+00:00 |
| Files for daily deletion with an impossible date (configuration) | 101 | Weekly | 14:32, 22 July 2024 (UTC)2024-07-22T14:32:00+00:00 |
| Files tagged for FfD missing an FfD nomination (configuration) | 101 | Weekly | 14:30, 22 July 2024 (UTC)2024-07-22T14:30:00+00:00 |
| Files with conflicting categorization (configuration) | 29,542 | Weekly | 04:42, 26 July 2024 (UTC)2024-07-26T04:42:00+00:00 |
| Files without a license tag (configuration) | 1,793 | Weekly | 14:32, 22 July 2024 (UTC)2024-07-22T14:32:00+00:00 |
| Free files which link to Flickr (configuration) | 48,345 | Weekly | 14:32, 22 July 2024 (UTC)2024-07-22T14:32:00+00:00 |
| Free files without a machine-readable source (configuration) | 39,031 | Weekly | 14:32, 22 July 2024 (UTC)2024-07-22T14:32:00+00:00 |
| Large fair-use images (configuration) | 832 | Weekly | 14:31, 22 July 2024 (UTC)2024-07-22T14:31:00+00:00 |
| Largely duplicative file names (configuration) | 1,999 | Daily | 02:16, 27 July 2024 (UTC)2024-07-27T02:16:00+00:00 |
| Largest orphaned free files by bytes (configuration) | 9,813 | Daily | 14:33, 22 July 2024 (UTC)2024-07-22T14:33:00+00:00 |
| Local files with a duplicate on Commons (configuration) | 630 | Weekly | 14:32, 22 July 2024 (UTC)2024-07-22T14:32:00+00:00 |
| Non-free files shadowing a Commons file (configuration) | 594 | Weekly | 14:32, 22 July 2024 (UTC)2024-07-22T14:32:00+00:00 |
| Non-free PDFs (configuration) | 239 | Weekly | 14:32, 22 July 2024 (UTC)2024-07-22T14:32:00+00:00 |
| Orphaned file talk pages (configuration) | 250 | Weekly | 14:32, 22 July 2024 (UTC)2024-07-22T14:32:00+00:00 |
| Orphaned files copied to Commons tagged keep local (configuration) | 4,321 | Weekly | 14:33, 22 July 2024 (UTC)2024-07-22T14:33:00+00:00 |
| Orphaned free files tagged keep local (configuration) | 17,555 | Weekly | 14:31, 22 July 2024 (UTC)2024-07-22T14:31:00+00:00 |
| Orphaned low-resolution free files (configuration) | 51,931 | Weekly | 14:32, 22 July 2024 (UTC)2024-07-22T14:32:00+00:00 |
| Orphaned PDFs (configuration) | 2,388 | Weekly | 14:32, 22 July 2024 (UTC)2024-07-22T14:32:00+00:00 |
| Overused non-free files (configuration) | 2,083 | Weekly | 10:57, 26 July 2024 (UTC)2024-07-26T10:57:00+00:00 |
| Pages containing an unusually high number of non-free files (configuration) | 10,105 | Weekly | 10:56, 26 July 2024 (UTC)2024-07-26T10:56:00+00:00 |
| Smallest orphaned free files by bytes (configuration) | 6,917 | Weekly | 14:33, 22 July 2024 (UTC)2024-07-22T14:33:00+00:00 |
| Smallest orphaned free files by resolution (configuration) | 16,834 | Weekly | 14:33, 22 July 2024 (UTC)2024-07-22T14:33:00+00:00 |
| Templates containing non-free files (configuration) | 315 | Weekly | 11:18, 26 July 2024 (UTC)2024-07-26T11:18:00+00:00 |
| Unused file redirects (configuration) | 428,333 | Weekly | 00:09, 1 June 2024 (UTC)2024-06-01T00:09:00+00:00 |
| Unused non-free files (configuration) | 19,073 | Daily | 11:29, 26 July 2024 (UTC)2024-07-26T11:29:00+00:00 |
| Pages | |||
| Bizarrely subnested userpages (configuration) | 143,909 | Weekly | |
| Blank single-author pages (configuration) | 41,799 | Weekly | 02:09, 27 July 2024 (UTC)2024-07-27T02:09:00+00:00 |
| Malformed SPI Cases (configuration) | 172 | Weekly | 14:31, 22 July 2024 (UTC)2024-07-22T14:31:00+00:00 |
| Old deletion discussions (configuration) | 6,266 | Weekly | 10:56, 26 July 2024 (UTC)2024-07-26T10:56:00+00:00 |
| Orphaned article deletion discussions (configuration) | 53 | Monthly | 11:12, 4 September 2022 (UTC)2022-09-04T11:12:00+00:00 |
| Orphaned talk pages (configuration) | 379 | Daily | 06:24, 27 July 2024 (UTC)2024-07-27T06:24:00+00:00 |
| Orphaned talk subpages (configuration) | 3,459 | Weekly | 10:57, 26 July 2024 (UTC)2024-07-26T10:57:00+00:00 |
| Pages with the most revisions (configuration) | 48,671 | Weekly | 03:50, 24 July 2024 (UTC)2024-07-24T03:50:00+00:00 |
| Talk pages by size (configuration) | 16,276 | Weekly | 01:40, 26 July 2024 (UTC)2024-07-26T01:40:00+00:00 |
| Unfiled RfAs (configuration) | 2,003 | Weekly | 14:33, 22 July 2024 (UTC)2024-07-22T14:33:00+00:00 |
| Protections | |||
| Semi-protected articles with unusually long expiries (configuration) | 86,267 | Monthly | 12:00, 07 October 2022 (UTC)2022-10-07T12:00:00+00:00 |
| Fully protected articles with unusually long expiries (configuration) | 305 | Monthly | 12:05, 07 October 2022 (UTC)2022-10-07T12:05:00+00:00 |
| Fully protected user talk pages (configuration) | 14,778 | Weekly | 14:33, 22 July 2024 (UTC)2024-07-22T14:33:00+00:00 |
| 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)2022-10-06T00:30:00+00:00 |
| Indefinitely fully protected redirects (configuration) | 28 | Monthly | 20:06, 19 July 2024 (UTC)2024-07-19T20:06:00+00:00 |
| Redirects | |||
| Broken section anchors (configuration) | 1,389,274 | Monthly | 01:20, 03 July 2024 (UTC)2024-07-03T01:20:00+00:00 |
| Statistics | |||
| Articles with the most redirects (configuration) | 85,035 | Monthly | 04:22, 23 July 2024 (UTC)2024-07-23T04:22:00+00:00 |
| Page count by namespace (configuration) | 1,415 | Weekly | 02:52, 23 July 2024 (UTC)2024-07-23T02:52:00+00:00 |
| Stubs | |||
| Dubious stub categories (configuration) | 38,783 | Weekly | 10:00, 07 October 2022 (UTC)2022-10-07T10:00:00+00:00 |
| Long stubs (configuration) | 44,112 | Weekly | 10:55, 26 July 2024 (UTC)2024-07-26T10:55:00+00:00 |
| Untagged stubs (configuration) | 36,312 | Weekly | 11:27, 26 July 2024 (UTC)2024-07-26T11:27:00+00:00 |
| Templates | |||
| All free license tags (configuration) | 5,535 | Weekly | 14:30, 22 July 2024 (UTC)2024-07-22T14:30:00+00:00 |
| Broken WikiProject templates (configuration) | 307 | Weekly | 04:41, 26 July 2024 (UTC)2024-07-26T04:41:00+00:00 |
| Free license tags which do not exist on Commons (configuration) | 1,077 | Weekly | 14:30, 22 July 2024 (UTC)2024-07-22T14:30:00+00:00 |
| Invalid Navbar links (configuration) | 13,987 | Monthly | 14:58, 01 July 2024 (UTC)2024-07-01T14:58:00+00:00 |
| Templates containing links to disambiguation pages (configuration) | 7,296 | Weekly | 11:17, 26 July 2024 (UTC)2024-07-26T11:17:00+00:00 |
| Templates transcluded on the most pages (configuration) | 372 | Weekly | 10:14, 21 July 2024 (UTC)2024-07-21T10:14:00+00:00 |
| Transclusions of deleted templates (configuration) | 13 | Weekly | 15:25, 22 September 2022 (UTC)2022-09-22T15:25:00+00:00 |
| Transclusions of non-existent templates (configuration) | 15,288 | Daily | 15:00, 26 July 2024 (UTC)2024-07-26T15:00:00+00:00 |
| Uncategorized templates (configuration) | 3,237 | Daily | This is a report of uncategorized templates. All templates should have at least one category that is not a tracking or maintenance category. This report is limited to 1,000 uncategorized templates; to see more, add a category or {{Uncategorized}} to some of the pages on this list, then refresh the report.
This table is generated by querying the database replica and is periodically updated by a bot. [SQL Error: : Query execution was interrupted (max_statement_time exceeded) - SDZeroBot applies a timeout of 600 seconds on all queries.] End of auto-generated report.
|
(error parsing "This is a report of uncategorized templates. All templates should have at least one category that is not a tracking or maintenance category. This report is limited to 1,000 uncategorized templates; to see more, add a category or {{Uncategorized}} to some of the pages on this list, then refresh the report.
This table is generated by querying the database replica and is periodically updated by a bot.
Edits made within the table area will be removed on the next update!
[SQL Error: : Query execution was interrupted (max_statement_time exceeded) - SDZeroBot applies a timeout of 600 seconds on all queries.]
|}") |- | Unprotected templates with many transclusions (configuration) | 13 | Weekly | data-sort-value=2022-09-22T15:35:00+00:00 |15:35, 22 September 2022 (UTC)2022-09-22T15:35:00+00:00 |- | Unused templates (configuration) | 28 | Daily | data-sort-value=2024-07-26T11:37:00+00:00 |11:37, 26 July 2024 (UTC)2024-07-26T11:37:00+00:00 |- | Unused templates (filtered) (configuration) | 28 | Daily | data-sort-value=2024-07-26T11:44:00+00:00 |11:44, 26 July 2024 (UTC)2024-07-26T11:44:00+00:00 |- |- ! colspan="4" style="text-align:left;" id="Timed Text"| Timed Text |- | Timed Text without a corresponding File (configuration) | 251 | Weekly | data-sort-value=2024-07-22T14:30:00+00:00 |14:30, 22 July 2024 (UTC)2024-07-22T14:30:00+00:00 |- |- ! colspan="4" style="text-align:left;" id="WikiProjects"| WikiProjects |- | WikiProjects by changes (configuration) | 203,392 | Weekly | data-sort-value=2024-07-26T11:12:00+00:00 |11:12, 26 July 2024 (UTC)2024-07-26T11:12:00+00:00 |- | WikiProject watchers (configuration) | 64,231 | Weekly | data-sort-value=2024-07-24T00:00:00+00:00 |00:00, 24 July 2024 (UTC)2024-07-24T00:00:00+00:00 |- | New WikiProjects (configuration) | 564 | Fortnightly | data-sort-value=2024-07-21T12:09:00+00:00 |12:09, 21 July 2024 (UTC)2024-07-21T12:09:00+00:00 |- |- ! colspan="4" style="text-align:left;" id="Third-party (disambiguations)" | Third-party (disambiguations) |- | Articles with links to disambiguation pages | — | Daily | — |- | Templates with disambiguation links | — | Daily | — |- ! colspan="4" style="text-align:left;" id="Third-party (non-free files)"| Third-party (non-free files) |- | 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 | — |- ! colspan="4" style="text-align:left;" id="Long pages by namespace"| Long pages by namespace |- | 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 |- ! colspan="4" style="text-align:left;" id="Third-party (generic)"| Third-party (generic) |- | Page moves grouped by user | — | Hourly | — |- | Largest pages | — | Dynamically | — |- | WikiProject Check Wikipedia reports | — | Daily | — |- ! colspan="4" style="text-align:left;" id="Users" | Users |- | Active editors with the longest-established accounts (configuration) | 11,726 | Monthly | data-sort-value=2024-07-20T12:02:00+00:00 |12:02, 20 July 2024 (UTC)2024-07-20T12:02:00+00:00 |- | Confirmed autoconfirmed users (configuration) | 101 | Weekly | data-sort-value=2024-07-22T14:33:00+00:00 |14:33, 22 July 2024 (UTC)2024-07-22T14:33:00+00:00 |- | Blocked users in user groups | 92,218 | Fortnightly | — |- | Editors eligible for Autopatrol privilege (source) | 157,332 | Daily | data-sort-value=2024-07-27T02:16:00+00:00 |02:16, 27 July 2024 (UTC)2024-07-27T02:16:00+00:00 |- | List of Wikipedians by number of edits | — | Daily | — |- | Longest active user editing streaks (configuration) | 5,257 | Weekly | data-sort-value=2024-07-18T23:42:00+00:00 |23:42, 18 July 2024 (UTC)2024-07-18T23:42:00+00:00 |- | Longest active user article editing streaks (configuration) | 2,979 | Weekly | data-sort-value=2024-07-05T15:49:00+00:00 |15:49, 5 July 2024 (UTC)2024-07-05T15:49:00+00:00 |- | Miscategorized users (configuration) | 32,646 | Manually | data-sort-value=2022-09-16T20:40:00+00:00 |20:40, 16 September 2022 (UTC)2022-09-16T20:40:00+00:00 |- | Ownerless pages in the user space (configuration) | 5,812 | Daily | data-sort-value=2024-07-26T20:12:00+00:00 |20:12, 26 July 2024 (UTC)2024-07-26T20:12:00+00:00 |- | Potential U5s (configuration) | 28 | Weekly | data-sort-value=2023-05-25T06:56:00+00:00 |06:56, 25 May 2023 (UTC)2023-05-25T06:56:00+00:00 |- | Top new article reviewers (source) | 146,602 | Twice daily | data-sort-value=2024-07-27T03:53:00+00:00 |03:53, 27 July 2024 (UTC)2024-07-27T03:53:00+00:00 |- | Unusually large IP talk pages (configuration) | 385 | Weekly | data-sort-value=2024-07-22T14:32:00+00:00 |14:32, 22 July 2024 (UTC)2024-07-22T14:32:00+00:00 |- | Unusually large user talk pages (configuration) | 642 | Weekly | data-sort-value=2024-07-22T14:32:00+00:00 |14:32, 22 July 2024 (UTC)2024-07-22T14:32:00+00:00 |- | Userpages with ".com" in their titles (configuration) | 77,105 | Weekly | data-sort-value=2024-07-21T05:25:00+00:00 | |- |}
Archived reports
editAn 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.