# How many websites use a particular technology?

**URL:** <https://discuss.httparchive.org/t/how-many-websites-use-a-particular-technology/1627>\
**Category:** Analysis\
**Created:** [April 9, 2019, 6:56pm UTC](https://discuss.httparchive.org/t/how-many-websites-use-a-particular-technology/1627 "2019-04-09T18:56:21Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![rviscomi](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/rviscomi/32/835_2.png) [@rviscomi](https://discuss.httparchive.org/u/rviscomi)\
**Post date:** [April 9, 2019, 6:56pm UTC](https://discuss.httparchive.org/t/how-many-websites-use-a-particular-technology/1627/1 "2019-04-09T18:56:21Z")

</div>

[Wappalyzer](https://www.wappalyzer.com/) provides detection logic for over 1,000 different kinds of web technologies categorized by things like CMS and JS frameworks.

We can query these detections in the [`technologies`](https://bigquery.cloud.google.com/dataset/httparchive:technologies) dataset, for example to count the number of WordPress websites:

```sql
#standardSQL
# Counts 906,033 distinct URLs
SELECT COUNT(DISTINCT url)
FROM `httparchive.technologies.2019_03_01_desktop`
WHERE app = 'WordPress'

```

This query only costs about 1 GB.

If we don’t care about whether the website is built for mobile or desktop, we can use a wildcard in place of the client type:

```sql
#standardSQL
# Counts 1,213,389 distinct URLs
SELECT COUNT(DISTINCT url)
FROM `httparchive.technologies.2019_03_01_*`
WHERE app = 'WordPress'

```

Note that this consumes about 2x as much data because it queries both the desktop and mobile tables.

For a list of all possible `app` names, see [https://www.wappalyzer.com/technologies](https://www.wappalyzer.com/technologies)