# What are the most popular HTTP status codes?

**URL:** <https://discuss.httparchive.org/t/what-are-the-most-popular-http-status-codes/428>\
**Category:** Analysis\
**Created:** [November 25, 2014, 8:54pm UTC](https://discuss.httparchive.org/t/what-are-the-most-popular-http-status-codes/428 "2014-11-25T20:54:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![stevesoudersorg](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/stevesoudersorg/32/1293_2.png) [@stevesoudersorg](https://discuss.httparchive.org/u/stevesoudersorg)\
**Post date:** [November 25, 2014, 8:54pm UTC](https://discuss.httparchive.org/t/what-are-the-most-popular-http-status-codes/428/1 "2014-11-25T20:54:46Z")

</div>

I wanted to know the percentage of responses that had a status code of 200, 304, 404, etc. Here’s the query:

```sql
SELECT status, round(100*ratio) as percent, num 
FROM (
  SELECT status, count(*) as num, RATIO_TO_REPORT(num) OVER() ratio
  FROM httparchive:runs.2014_11_15_requests
  GROUP BY status
)
ORDER BY num desc

```

And the results for Nov 15 2014:  
 ![](https://yyz1.discourse-cdn.com/flex035/uploads/httparchive/402/6cbaf1bfcdbfae60.png)

---

<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:18am UTC](https://discuss.httparchive.org/t/what-are-the-most-popular-http-status-codes/428/2 "2014-11-27T08:18:28Z")

</div>

Whats with the “0” as response code? Does that mean literal 0 or some error code?

It would also be interesting to fork httparchive to maintain a browser cache and look at the trend of 304s. My hypothesis is that low number of 304s are explained by the fact that there is no persistence between crawls, right?

---

<div class="post-metadata">

**Author:** ![stevesoudersorg](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/stevesoudersorg/32/1293_2.png) [@stevesoudersorg](https://discuss.httparchive.org/u/stevesoudersorg)\
**Post date:** [November 27, 2014, 5:00pm UTC](https://discuss.httparchive.org/t/what-are-the-most-popular-http-status-codes/428/3 "2014-11-27T17:00:58Z")

</div>

The default is “0” so those requests probably didn’t have a status code. This could be due to errors in the crawl or other factors.

There is not persistence across crawls.