Asher,<div><br></div><div>As you can see in the conversation below, I discovered that sha1 hashes are not being generated historically for revision content in Wikipedia -- just generated from the time of release (mid-April) forward.  Is this intended?  If so, is there a plan to fill in the sha1&#39;s historically or should we (data monkeys) keep track of THE GREAT SHA1 EPOCH of April, 2012 when performing our analysis from here forward?</div>

<div><br></div><div>Thanks!</div><div>-Aaron<br><br><div class="gmail_quote">On Thu, May 10, 2012 at 4:27 PM, Diederik van Liere <span dir="ltr">&lt;<a href="mailto:dvanliere@wikimedia.org" target="_blank">dvanliere@wikimedia.org</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Aaron,<div><br></div><div>You are right, it seems not to have been calculated for older pages (I checked it for eswiki). I was under the impression that this either had finished or is in progress. Probably best to ask Asher for more details.</div>


<div><br></div><div><br></div><div>Best,</div><div><br></div><div>Diederik</div><div class="HOEnZb"><div class="h5"><div><br><div class="gmail_quote">On Thu, May 10, 2012 at 5:09 PM, Aaron Halfaker <span dir="ltr">&lt;<a href="mailto:aaron.halfaker@gmail.com" target="_blank">aaron.halfaker@gmail.com</a>&gt;</span> wrote:<br>


<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I&#39;m using the web API and db42. <div><br></div><div>API example:  <a href="http://en.wikipedia.org/w/api.php?action=query&amp;prop=revisions&amp;titles=User:EpochFail&amp;rvprop=ids%7Csha1&amp;format=jsonfm&amp;rvlimit=2&amp;rvdir=older&amp;rvstartid=488033783" target="_blank">http://en.wikipedia.org/w/api.php?action=query&amp;prop=revisions&amp;titles=User:EpochFail&amp;rvprop=ids|sha1&amp;format=jsonfm&amp;rvlimit=2&amp;rvdir=older&amp;rvstartid=488033783</a></div>




<div><br></div><div>MySQL example:</div><div><div><font face="&#39;courier new&#39;, monospace">mysql&gt; select rev_id, rev_sha1 from revision where rev_page = 15661504 and rev_id &lt;= 488033783 order by rev_timestamp desc limit 2;</font></div>




<div><font face="&#39;courier new&#39;, monospace">+-----------+---------------------------------+</font></div><div><font face="&#39;courier new&#39;, monospace">| rev_id    | rev_sha1                        |</font></div>




<div><font face="&#39;courier new&#39;, monospace">+-----------+---------------------------------+</font></div><div><font face="&#39;courier new&#39;, monospace">| 488033783 | i8x0e29kxs2t1o9f1h03ks7q59yyyrv |</font></div>




<div><font face="&#39;courier new&#39;, monospace">| 485404713 |                                 |</font></div><div><font face="&#39;courier new&#39;, monospace">+-----------+---------------------------------+</font></div>




<div><font face="&#39;courier new&#39;, monospace">2 rows in set (0.00 sec)</font></div><span><font color="#888888"><div><br></div><div>-Aaron</div></font></span><div><div><br><div class="gmail_quote">
On Thu, May 10, 2012 at 4:03 PM, Diederik van Liere <span dir="ltr">&lt;<a href="mailto:dvanliere@wikimedia.org" target="_blank">dvanliere@wikimedia.org</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Which machine are you accessing?<br>D<br><br><div class="gmail_quote"><div><div>On Thu, May 10, 2012 at 4:58 PM, Aaron Halfaker <span dir="ltr">&lt;<a href="mailto:aaron.halfaker@gmail.com" target="_blank">aaron.halfaker@gmail.com</a>&gt;</span> wrote:<br>





</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>Hey guys,<div><br></div><div>I&#39;m trying to use the sha1 hashes of Wiki content for the first time (woot!  Props to D et al. for seeing it through) but I&#39;m having some trouble actually getting them out of the API/databases.  It looks like the checksums only go back to April 19th.  Is this true of all pages?  Is there any plan to propagate the metric backwards?</div>





<span><font color="#888888">


<div><br></div><div>-Aaron</div>
</font></span><br></div></div>_______________________________________________<br>
Analytics mailing list<br>
<a href="mailto:Analytics@lists.wikimedia.org" target="_blank">Analytics@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/analytics" target="_blank">https://lists.wikimedia.org/mailman/listinfo/analytics</a><br>
<br></blockquote></div><br>
<br>_______________________________________________<br>
Analytics mailing list<br>
<a href="mailto:Analytics@lists.wikimedia.org" target="_blank">Analytics@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/analytics" target="_blank">https://lists.wikimedia.org/mailman/listinfo/analytics</a><br>
<br></blockquote></div><br></div></div></div>
<br>_______________________________________________<br>
Analytics mailing list<br>
<a href="mailto:Analytics@lists.wikimedia.org" target="_blank">Analytics@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/analytics" target="_blank">https://lists.wikimedia.org/mailman/listinfo/analytics</a><br>
<br></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
Analytics mailing list<br>
<a href="mailto:Analytics@lists.wikimedia.org">Analytics@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/analytics" target="_blank">https://lists.wikimedia.org/mailman/listinfo/analytics</a><br>
<br></blockquote></div><br></div>