# Top MIME Types based on HTTPArchive

**URL:** <https://discuss.httparchive.org/t/top-mime-types-based-on-httparchive/63>\
**Category:** Analysis\
**Created:** [September 3, 2013, 10:16pm UTC](https://discuss.httparchive.org/t/top-mime-types-based-on-httparchive/63 "2013-09-03T22:16:02Z")\
**Posts on this page:** 2\
**Page:** 1

<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:** [September 3, 2013, 10:16pm UTC](https://discuss.httparchive.org/t/top-mime-types-based-on-httparchive/63/1 "2013-09-03T22:16:03Z")

</div>

The following query would return the top MIME types seen on HTTPArchive

```
select count(requestid) as ct, mimeType 
 FROM [httparchive:runs.latest_requests]
  group by mimeType 
  having ct > 10000 
  order by ct desc;

```

![](https://yyz1.discourse-cdn.com/flex035/uploads/httparchive/52/9e3fe14813eba60a.png)

same for mobile

```
select count(requestid) as ct, mimeType 
 FROM [httparchive:runs.latest_requests_mobile]
  group by mimeType 
  having ct > 10000 
  order by ct desc;

```

![](https://yyz1.discourse-cdn.com/flex035/uploads/httparchive/53/6eb7ebfe9cfb21ef.png)

Just wanted to see if I am missing anything above? Also isnt MIME type the same as response Content-Type. If not the same queries would be

```
select count(requestid) as ct, resp_content_type 
 FROM [httparchive:runs.latest_requests]
  group by resp_content_type
  having ct > 10000 
  order by ct desc;

```

![](https://yyz1.discourse-cdn.com/flex035/uploads/httparchive/54/b356d3ac44306d22.png)

Same for mobile

```
select count(requestid) as ct, resp_content_type 
 FROM [httparchive:runs.latest_requests_mobile]
  group by resp_content_type
  having ct > 10000 
  order by ct desc;

```

![](https://yyz1.discourse-cdn.com/flex035/uploads/httparchive/55/db3e1df28fc0b09f.png)

Just wondering how does the community go about solving such issues and if what I did was valid?

---

<div class="post-metadata">

**Author:** ![igrigorik](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/igrigorik/32/925_2.png) [@igrigorik](https://discuss.httparchive.org/u/igrigorik)\
**Post date:** [September 4, 2013, 11:14pm UTC](https://discuss.httparchive.org/t/top-mime-types-based-on-httparchive/63/2 "2013-09-04T23:14:45Z")

</div>

You dig into the data… 🙂

```sql
select domain(url), resp_server, mimeType, resp_content_type
 FROM [httparchive:runs.latest_requests]
 LIMIT 1000;

```

Paging through the results of above query shows that the difference is likely due to the extra charset specification in resp\_content\_type. The delta is not big, I think that would account for it…

![](https://yyz1.discourse-cdn.com/flex035/uploads/httparchive/56/a0edb37c35fbef97.png)