These are some stats about the usage of images on commons.
Here, an image is considered used if it is used by a wikimedia project outside of commons. Images used via instant commons are not counted. Some proofread page usages might not be counted. If an image is used more than once (which is common), it is only counted as a single usage. All data is queried via tools labs.
As of roughly right now (20:38, 5 July 2013 (UTC)) we have 17,649,274 images on commons. (Not counting old versions, or deleted images. Just a direct count(*) on image table)
See definition above about what a used image is. This does not include images used only on commons.
So the total number of unused images is:
MariaDB [commonswiki_p]> select count(img_name) from image LEFT OUTER JOIN globalimagelinks on gil_to = img_name where gil_to is null; +-----------------+ | count(img_name) | +-----------------+ | 10539394 | +-----------------+
Which means 7,109,880 images are in use outside of commons, or 40.3% of images are used.
Some interesting categories (to compare how usage differs by upload methods and sources). Note, its too be expected that mass imports from glams initially don't have a lot of use as people still sort through the images. That's not a bad thing - their images have instrinsic value, unrelated to how often they are used in a Wikipedia article.
|Images_from the_Canadian Copyright_Collection_at the_British Library||4381||112||2.56%|
|Images from_the German_Federal_Archive||82682||22789||27.56%|
|Uploaded with Mobile/Android||3153||241||7.64%|
|Uploaded with Mobile/Web||1931||400||20.71%|
|Uploaded with Mobile/iOS||1756||281||16.00%|
|Uploaded with Android WLM App||3634||1095||30.13%|
|Uploaded with VicuñaUploader||26225||4960||18.91%|
|Uploaded with Commonist||135,066||42487||31.46%|
|Uploaded with Up!||1347||36||2.67%|
|Uploaded with Open Access Media Importer||12548||513||4.09%|
|Uploaded with UploadWizard||2,653,234||1,092,390||41.17%|
The queries used for this section were as follows (Changing category name as appropriate. Used was calculated by taking total minus unused):
MariaDB [commonswiki_p]> select count(*) from image inner join page on page_namespace = 6 and page_title = img_name inner join categorylinks on cl_from = page_id and cl_type = 'file' LEFT OUTER JOIN globalimagelinks on gil_to = img_name where gil_to is null and cl_to='Images_from_the_Canadian_Copyright_Collection_at_the_British_Library'; +----------+ | count(*) | +----------+ | 4269 | +----------+ 1 row in set (0.09 sec) MariaDB [commonswiki_p]> select count(*) from categorylinks where cl_type= 'file' and cl_to = 'Images_from_the_Canadian_Copyright_Collection_at_the_British_Library'; +----------+ | count(*) | +----------+ | 4381 | +----------+ 1 row in set (0.03 sec)
Uploads in a week
This was for the 7 days preceding June 17, 2013
- 91,413 new files uploaded
- 10,153 files were replaced with a new version
- 7,452 were deleted + an additional 139 rev delete in file namespace.
- A total of 86 admins deleted at least 1 file that week, 32 admins
deleted 10 or more files, INeverCry had the highest number of deletions, and is just slightly short of deleting 2 thousand files that week.