# Alexa rank attribute in the pages table

**URL:** <https://discuss.httparchive.org/t/alexa-rank-attribute-in-the-pages-table/1391>\
**Category:** Uncategorized\
**Created:** [June 26, 2018, 2:22pm UTC](https://discuss.httparchive.org/t/alexa-rank-attribute-in-the-pages-table/1391 "2018-06-26T14:22:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![raghuramakrishnan](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/raghuramakrishnan/32/924_2.png) [@raghuramakrishnan](https://discuss.httparchive.org/u/raghuramakrishnan)\
**Post date:** [June 26, 2018, 2:22pm UTC](https://discuss.httparchive.org/t/alexa-rank-attribute-in-the-pages-table/1391/1 "2018-06-26T14:22:29Z")

</div>

The rank attribute in the pages table in appears to change from one run to another as shown below (but remains constant 15 Oct 17 onwards).

As per the following thread, the updated Alexa top million was non longer available  
[[Number of domains in HTTPArchive](https://discuss.httparchive.org/t/number-of-domains-in-httparchive/1069/4)] and we could expect to see the same URLs and page ranks in all of the crawls this year.

So is the cutoff date 15 Oct 17?

SELECT  
rank  
FROM  
`httparchive.summary_pages.*`  
WHERE  
\_TABLE\_SUFFIX \>= ‘2017\_08\_01’ AND  
ENDS\_WITH(\_TABLE\_SUFFIX, ‘desktop’) AND  
url IN (‘[http://www.onlinesbi.com/](http://www.onlinesbi.com/)’)

![image](https://canada1.discourse-cdn.com/flex035/uploads/httparchive/original/2X/d/d3a73b5af4f19a997ab8d48648eee82449fe233f.png)

SELECT  
SUBSTR(\_TABLE\_SUFFIX, 0, 10) AS date,  
rank  
FROM  
`httparchive.summary_pages.*`  
WHERE  
\_TABLE\_SUFFIX \>= ‘2017\_08\_01’ AND  
ENDS\_WITH(\_TABLE\_SUFFIX, ‘desktop’) AND  
url IN (‘[http://www.sbi.co.in/](http://www.sbi.co.in/)’)  
ORDER BY  
date

![image](https://canada1.discourse-cdn.com/flex035/uploads/httparchive/original/2X/1/1924934ef4a264c79db82170ce4ffb46f16eca3d.png)

---

<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:** [June 26, 2018, 2:36pm UTC](https://discuss.httparchive.org/t/alexa-rank-attribute-in-the-pages-table/1391/2 "2018-06-26T14:36:29Z")

</div>

Yes that sounds right.