# How many site are using webp image format

**URL:** https://discuss.httparchive.org/t/how-many-site-are-using-webp-image-format/430
**Category:** Analysis
**Created:** [November 26, 2014, 2:19pm UTC](https://discuss.httparchive.org/t/how-many-site-are-using-webp-image-format/430 "2014-11-26T14:19:55Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![david](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/david/32/1714_2.png) [@david](https://discuss.httparchive.org/u/david)
#### Post date: [November 26, 2014, 2:19pm UTC](https://discuss.httparchive.org/t/how-many-site-are-using-webp-image-format/430/1 "2014-11-26T14:19:55Z")

</div>

How many hostname are delivering webp file extension and also which CDN provider is delivering those:

```
select req_host, _cdn_provider,
from [httparchive:runs.latest_requests]
WHERE regexp_match(url, r'\.(webp)$')
GROUP BY req_host, _cdn_provider
```

---

<div class="post-metadata">

### Author: ![pganti](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/pganti/32/1299_2.png) [@pganti](https://discuss.httparchive.org/u/pganti)
#### Post date: [November 27, 2014, 8:40am UTC](https://discuss.httparchive.org/t/how-many-site-are-using-webp-image-format/430/2 "2014-11-27T08:40:14Z")

</div>

A few things to note here:

- You are simply looking for .webp in the URL which isnt an accurate way to look for webp content. A better way is to look for webp in response MIME type

For example you consider the URL at [http://www.webpagetest.org/result/141127\_9Q\_DV4/1/details/](http://www.webpagetest.org/result/141127_9Q_DV4/1/details/) to be a webp based on your query but you can see it returned a standard JPG rather than webp

- You can still send any response mime type for webp but chrome will still pick it up and do its thing so my suggestions is not 100% accurate way of detecting it

- I am not sure you can do your analysis on public data of httparchive as its collected using IE8/9 ([http://httparchive.org/about.php#datagathered](http://httparchive.org/about.php#datagathered)) which does not render webp . However you can run your own private instance of httparchive and use chrome as your browser to collect the same

- Funnily some data in the dataset does return image/webp for IE albeit cannot be rendered.

Chrome: [http://www.webpagetest.org/result/141127\_GS\_E5D/](http://www.webpagetest.org/result/141127_GS_E5D/)  
IE8: [http://www.webpagetest.org/result/141127\_TC\_E56/](http://www.webpagetest.org/result/141127_TC_E56/)

Happy Thanksgiving!