updated report HTML

1 files changed, 1172 insertions, 0 deletions

diff --git a/reports/report.2020-06-24.html b/reports/report.2020-06-24.html
new file mode 100644
index 0000000..4d9636e
--- /dev/null
+++ b/reports/report.2020-06-24.html
@@ -0,0 +1,1172 @@
+<!--
+This template can be "executed" to generate an HTML report page using the
+`sqlite-notebook` tool.
+-->
+
+<h1>Chocula Journal Aggregate Stats</h1>
+<div style="margin: 1em 3em 1em 3em; "><code><table>
+  <thead><tr>
+  <th>datetime('now')</th>
+</tr></thead>
+<tr>
+  <td>2020-06-24 06:07:59</td>
+</tr>
+</table><pre><b>QUERY:</b> SELECT datetime('now');</pre>
+<br></code></div><div style="margin: 1em 3em 1em 3em; "><code><table>
+  <thead><tr>
+  <th>seq</th>
+  <th>name</th>
+  <th>file</th>
+</tr></thead>
+<tr>
+  <td>0</td>
+  <td>main</td>
+  <td>/home/bnewbold/code/chocula/chocula.sqlite</td>
+</tr>
+</table><pre><b>QUERY:</b> PRAGMA database_list;</pre>
+<br></code></div><h2>Overview</h2>
+<p>Top publishers by journal count:</p>
+<div style="margin: 1em 3em 1em 3em; "><code><table>
+  <thead><tr>
+  <th>publisher</th>
+  <th>COUNT(*)</th>
+</tr></thead>
+<tr>
+  <td></td>
+  <td>50438</td>
+</tr>
+<tr>
+  <td>Elsevier</td>
+  <td>4896</td>
+</tr>
+<tr>
+  <td>Springer</td>
+  <td>3180</td>
+</tr>
+<tr>
+  <td>Taylor & Francis</td>
+  <td>3048</td>
+</tr>
+<tr>
+  <td>John Wiley & Sons, Inc</td>
+  <td>2322</td>
+</tr>
+<tr>
+  <td>SAGE Publications</td>
+  <td>1441</td>
+</tr>
+<tr>
+  <td>J-STAGE</td>
+  <td>1405</td>
+</tr>
+<tr>
+  <td>Peter Lang International Academic Publishers</td>
+  <td>1356</td>
+</tr>
+<tr>
+  <td>SciELO</td>
+  <td>1187</td>
+</tr>
+<tr>
+  <td>Informa UK (Taylor & Francis)</td>
+  <td>737</td>
+</tr>
+<tr>
+  <td>Springer-Verlag</td>
+  <td>706</td>
+</tr>
+<tr>
+  <td>Cambridge University Press</td>
+  <td>598</td>
+</tr>
+<tr>
+  <td>Walter de Gruyter GmbH</td>
+  <td>554</td>
+</tr>
+<tr>
+  <td>Georg Thieme Verlag KG</td>
+  <td>515</td>
+</tr>
+<tr>
+  <td>OMICS Publishing Group</td>
+  <td>497</td>
+</tr>
+<tr>
+  <td>IEEE, Inc</td>
+  <td>482</td>
+</tr>
+<tr>
+  <td>JSTOR</td>
+  <td>471</td>
+</tr>
+<tr>
+  <td>Medknow Publications</td>
+  <td>463</td>
+</tr>
+<tr>
+  <td>Oxford University Press</td>
+  <td>461</td>
+</tr>
+<tr>
+  <td>Hindawi</td>
+  <td>456</td>
+</tr>
+<tr>
+  <td>Bentham Science</td>
+  <td>445</td>
+</tr>
+<tr>
+  <td>De Gruyter Open Sp. z o.o.</td>
+  <td>440</td>
+</tr>
+<tr>
+  <td>Wolters Kluwer Health</td>
+  <td>427</td>
+</tr>
+<tr>
+  <td>CAIRN</td>
+  <td>416</td>
+</tr>
+<tr>
+  <td>Inderscience</td>
+  <td>396</td>
+</tr>
+</table><pre><b>QUERY:</b> SELECT publisher, COUNT(*)
+FROM journal
+GROUP BY publisher
+ORDER BY COUNT(*) DESC
+LIMIT 25;</pre>
+<br></code></div><p>Top countries by number of journals:</p>
+<div style="margin: 1em 3em 1em 3em; "><code><table>
+  <thead><tr>
+  <th>country</th>
+  <th>COUNT(*)</th>
+</tr></thead>
+<tr>
+  <td>us</td>
+  <td>31063</td>
+</tr>
+<tr>
+  <td></td>
+  <td>11775</td>
+</tr>
+<tr>
+  <td>id</td>
+  <td>10203</td>
+</tr>
+<tr>
+  <td>de</td>
+  <td>8221</td>
+</tr>
+<tr>
+  <td>in</td>
+  <td>7489</td>
+</tr>
+<tr>
+  <td>gb</td>
+  <td>7357</td>
+</tr>
+<tr>
+  <td>fr</td>
+  <td>6947</td>
+</tr>
+<tr>
+  <td>uk</td>
+  <td>5989</td>
+</tr>
+<tr>
+  <td>nl</td>
+  <td>5579</td>
+</tr>
+<tr>
+  <td>br</td>
+  <td>4779</td>
+</tr>
+</table><pre><b>QUERY:</b> SELECT  country,
+COUNT(*)
+FROM journal
+GROUP BY country
+ORDER BY COUNT(*) DESC
+LIMIT 10;</pre>
+<br></code></div><p>.. by number of papers:</p>
+<div style="margin: 1em 3em 1em 3em; "><code><table>
+  <thead><tr>
+  <th>country</th>
+  <th>COUNT(*)</th>
+  <th>SUM(release_count)</th>
+</tr></thead>
+<tr>
+  <td>us</td>
+  <td>31063</td>
+  <td>32178939</td>
+</tr>
+<tr>
+  <td>gb</td>
+  <td>7357</td>
+  <td>13514834</td>
+</tr>
+<tr>
+  <td>nl</td>
+  <td>5579</td>
+  <td>10994203</td>
+</tr>
+<tr>
+  <td>de</td>
+  <td>8221</td>
+  <td>7537722</td>
+</tr>
+<tr>
+  <td>jp</td>
+  <td>3924</td>
+  <td>5534859</td>
+</tr>
+<tr>
+  <td>uk</td>
+  <td>5989</td>
+  <td>4689013</td>
+</tr>
+<tr>
+  <td>fr</td>
+  <td>6947</td>
+  <td>2205320</td>
+</tr>
+<tr>
+  <td>ch</td>
+  <td>2184</td>
+  <td>1956771</td>
+</tr>
+<tr>
+  <td>ru</td>
+  <td>3321</td>
+  <td>1437805</td>
+</tr>
+<tr>
+  <td>in</td>
+  <td>7489</td>
+  <td>1193631</td>
+</tr>
+</table><pre><b>QUERY:</b> SELECT  country,
+COUNT(*),
+SUM(release_count)
+FROM journal
+GROUP BY country
+ORDER BY SUM(release_count) DESC
+LIMIT 10;</pre>
+<br></code></div><p>Top languages by number of journals:</p>
+<div style="margin: 1em 3em 1em 3em; "><code><table>
+  <thead><tr>
+  <th>lang</th>
+  <th>COUNT(*)</th>
+</tr></thead>
+<tr>
+  <td></td>
+  <td>119385</td>
+</tr>
+<tr>
+  <td>en</td>
+  <td>33483</td>
+</tr>
+<tr>
+  <td>fr</td>
+  <td>2545</td>
+</tr>
+<tr>
+  <td>es</td>
+  <td>1980</td>
+</tr>
+<tr>
+  <td>pt</td>
+  <td>1253</td>
+</tr>
+<tr>
+  <td>id</td>
+  <td>807</td>
+</tr>
+<tr>
+  <td>fa</td>
+  <td>705</td>
+</tr>
+<tr>
+  <td>de</td>
+  <td>687</td>
+</tr>
+<tr>
+  <td>ja</td>
+  <td>627</td>
+</tr>
+<tr>
+  <td>ru</td>
+  <td>454</td>
+</tr>
+</table><pre><b>QUERY:</b> SELECT  lang,
+COUNT(*)
+FROM journal
+GROUP BY lang
+ORDER BY COUNT(*) DESC
+LIMIT 10;</pre>
+<br></code></div><p>... by number of papers:</p>
+<div style="margin: 1em 3em 1em 3em; "><code><table>
+  <thead><tr>
+  <th>lang</th>
+  <th>COUNT(*)</th>
+  <th>SUM(release_count)</th>
+</tr></thead>
+<tr>
+  <td>en</td>
+  <td>33483</td>
+  <td>52106736</td>
+</tr>
+<tr>
+  <td></td>
+  <td>119385</td>
+  <td>39633327</td>
+</tr>
+<tr>
+  <td>de</td>
+  <td>687</td>
+  <td>1080227</td>
+</tr>
+<tr>
+  <td>ja</td>
+  <td>627</td>
+  <td>701062</td>
+</tr>
+<tr>
+  <td>fr</td>
+  <td>2545</td>
+  <td>459624</td>
+</tr>
+<tr>
+  <td>es</td>
+  <td>1980</td>
+  <td>326190</td>
+</tr>
+<tr>
+  <td>pt</td>
+  <td>1253</td>
+  <td>259440</td>
+</tr>
+<tr>
+  <td>ru</td>
+  <td>454</td>
+  <td>216062</td>
+</tr>
+<tr>
+  <td>it</td>
+  <td>365</td>
+  <td>107777</td>
+</tr>
+<tr>
+  <td>id</td>
+  <td>807</td>
+  <td>63140</td>
+</tr>
+</table><pre><b>QUERY:</b> SELECT  lang,
+COUNT(*),
+SUM(release_count)
+FROM journal
+GROUP BY lang
+ORDER BY SUM(release_count) DESC
+LIMIT 10;</pre>
+<br></code></div><h2>Fatcat Fulltext Coverage</h2>
+<p>Fulltext coverage by publisher type:</p>
+<div style="margin: 1em 3em 1em 3em; "><code><table>
+  <thead><tr>
+  <th>publisher_type</th>
+  <th>AVG(ia_frac)</th>
+  <th>AVG(preserved_frac)</th>
+  <th>journal_count</th>
+  <th>paper_count</th>
+</tr></thead>
+<tr>
+  <td>big5</td>
+  <td>0.20383140988711096</td>
+  <td>0.7478923363774996</td>
+  <td>14341</td>
+  <td>38968407</td>
+</tr>
+<tr>
+  <td>society</td>
+  <td>0.38285716584323315</td>
+  <td>0.5255948097434624</td>
+  <td>11594</td>
+  <td>17479369</td>
+</tr>
+<tr>
+  <td></td>
+  <td>0.2892933315187726</td>
+  <td>0.39489655868508394</td>
+  <td>76449</td>
+  <td>17433767</td>
+</tr>
+<tr>
+  <td>unipress</td>
+  <td>0.5291521159229248</td>
+  <td>0.7156133857743203</td>
+  <td>8156</td>
+  <td>5979807</td>
+</tr>
+<tr>
+  <td>commercial</td>
+  <td>0.33223411266240366</td>
+  <td>0.679294424296642</td>
+  <td>5900</td>
+  <td>5783703</td>
+</tr>
+<tr>
+  <td>longtail</td>
+  <td>0.7021171169141004</td>
+  <td>0.7512778812541995</td>
+  <td>42817</td>
+  <td>5541048</td>
+</tr>
+<tr>
+  <td>repository</td>
+  <td>0.12411437397202797</td>
+  <td>0.24122655404137083</td>
+  <td>765</td>
+  <td>1032655</td>
+</tr>
+<tr>
+  <td>scielo</td>
+  <td>0.8234053698608026</td>
+  <td>0.8532657517834494</td>
+  <td>1588</td>
+  <td>931427</td>
+</tr>
+<tr>
+  <td>other</td>
+  <td>0.17819330003908534</td>
+  <td>0.6325501923587422</td>
+  <td>961</td>
+  <td>847590</td>
+</tr>
+<tr>
+  <td>archive</td>
+  <td>0.3274660229123176</td>
+  <td>0.9870091603652298</td>
+  <td>545</td>
+  <td>733596</td>
+</tr>
+<tr>
+  <td>oa</td>
+  <td>0.7703412508161128</td>
+  <td>0.8051562963022213</td>
+  <td>1854</td>
+  <td>665337</td>
+</tr>
+</table><pre><b>QUERY:</b> SELECT  publisher_type,
+AVG(ia_frac),
+AVG(preserved_frac),
+COUNT(*) AS journal_count,
+SUM(release_count) AS paper_count
+FROM journal
+GROUP BY publisher_type
+ORDER BY SUM(release_count) DESC;</pre>
+<br></code></div><p>Top publishers with very little coverage:</p>
+<div style="margin: 1em 3em 1em 3em; "><code><table>
+  <thead><tr>
+  <th>publisher</th>
+  <th>journal_count</th>
+  <th>AVG(ia_frac)</th>
+</tr></thead>
+<tr>
+  <td></td>
+  <td>9604</td>
+  <td>0.0017576670094484276</td>
+</tr>
+<tr>
+  <td>Elsevier</td>
+  <td>1894</td>
+  <td>0.01719793308556602</td>
+</tr>
+<tr>
+  <td>Taylor & Francis</td>
+  <td>1034</td>
+  <td>0.026333463256277043</td>
+</tr>
+<tr>
+  <td>J-STAGE</td>
+  <td>1000</td>
+  <td>0.008786577145385244</td>
+</tr>
+<tr>
+  <td>John Wiley & Sons, Inc</td>
+  <td>758</td>
+  <td>0.021752551474386456</td>
+</tr>
+<tr>
+  <td>Informa UK (Taylor & Francis)</td>
+  <td>583</td>
+  <td>0.010076744435949143</td>
+</tr>
+<tr>
+  <td>SAGE Publications</td>
+  <td>566</td>
+  <td>0.018548379050446432</td>
+</tr>
+<tr>
+  <td>Springer-Verlag</td>
+  <td>381</td>
+  <td>0.015239356601104427</td>
+</tr>
+<tr>
+  <td>Springer</td>
+  <td>352</td>
+  <td>0.025469114384971014</td>
+</tr>
+<tr>
+  <td>JSTOR</td>
+  <td>271</td>
+  <td>0.01053436333975769</td>
+</tr>
+</table><pre><b>QUERY:</b> SELECT  publisher,
+COUNT(*) AS journal_count,
+AVG(ia_frac)
+FROM journal
+WHERE ia_frac < 0.05
+GROUP BY publisher
+ORDER BY journal_count DESC
+LIMIT 10;</pre>
+<br></code></div><p>Amount of fulltext by SHERPA/ROMEO journal color::</p>
+<div style="margin: 1em 3em 1em 3em; "><code><table>
+  <thead><tr>
+  <th>sherpa_color</th>
+  <th>SUM(ia_count)</th>
+</tr></thead>
+<tr>
+  <td></td>
+  <td>8179318</td>
+</tr>
+<tr>
+  <td>blue</td>
+  <td>1068696</td>
+</tr>
+<tr>
+  <td>green</td>
+  <td>10279336</td>
+</tr>
+<tr>
+  <td>white</td>
+  <td>731881</td>
+</tr>
+<tr>
+  <td>yellow</td>
+  <td>2489843</td>
+</tr>
+</table><pre><b>QUERY:</b> SELECT  sherpa_color,
+SUM(ia_count)
+FROM journal
+GROUP BY sherpa_color;</pre>
+<br></code></div><h2>Journal Homepages</h2>
+<p>Homepage URL counts:</p>
+<div style="margin: 1em 3em 1em 3em; "><code><table>
+  <thead><tr>
+  <th>unique_urls</th>
+  <th>journals_with_hompages</th>
+</tr></thead>
+<tr>
+  <td>188481</td>
+  <td>118838</td>
+</tr>
+</table><pre><b>QUERY:</b> SELECT COUNT(DISTINCT surt) as unique_urls, COUNT(DISTINCT issnl) as journals_with_hompages FROM homepage;</pre>
+<br></code></div><p>Journals with the most homepage URLs:</p>
+<div style="margin: 1em 3em 1em 3em; "><code><table>
+  <thead><tr>
+  <th>issnl</th>
+  <th>COUNT(*)</th>
+</tr></thead>
+<tr>
+  <td>0036-6439</td>
+  <td>21</td>
+</tr>
+<tr>
+  <td>1487-0614</td>
+  <td>16</td>
+</tr>
+<tr>
+  <td>2375-0383</td>
+  <td>16</td>
+</tr>
+<tr>
+  <td>2374-4030</td>
+  <td>15</td>
+</tr>
+<tr>
+  <td>0097-6326</td>
+  <td>14</td>
+</tr>
+<tr>
+  <td>0749-405X</td>
+  <td>13</td>
+</tr>
+<tr>
+  <td>1521-9097</td>
+  <td>13</td>
+</tr>
+<tr>
+  <td>0009-7004</td>
+  <td>12</td>
+</tr>
+<tr>
+  <td>0030-7076</td>
+  <td>12</td>
+</tr>
+<tr>
+  <td>0717-554X</td>
+  <td>12</td>
+</tr>
+</table><pre><b>QUERY:</b> SELECT  issnl,
+COUNT(*)
+FROM homepage
+GROUP BY issnl
+ORDER BY COUNT(*) DESC
+LIMIT 10;</pre>
+<br></code></div><p>Top/redundant URLs and SURTs:</p>
+<div style="margin: 1em 3em 1em 3em; "><code><table>
+  <thead><tr>
+  <th>surt</th>
+  <th>COUNT(*)</th>
+</tr></thead>
+<tr>
+  <td>com,indianjournals)/</td>
+  <td>80</td>
+</tr>
+<tr>
+  <td>com,hindawi)/</td>
+  <td>71</td>
+</tr>
+<tr>
+  <td>au,com,informit,search)/search;res=apaft</td>
+  <td>64</td>
+</tr>
+<tr>
+  <td>com,umi)/pqdauto</td>
+  <td>51</td>
+</tr>
+<tr>
+  <td>org,rsc,pubs)/en/ebooks</td>
+  <td>50</td>
+</tr>
+<tr>
+  <td>com,umi)/proquest</td>
+  <td>48</td>
+</tr>
+<tr>
+  <td>org,ieee,ieeexplore)/xplore/conferences.jsp</td>
+  <td>40</td>
+</tr>
+<tr>
+  <td>org,omicsonline)/</td>
+  <td>37</td>
+</tr>
+<tr>
+  <td>com,idealibrary)/</td>
+  <td>36</td>
+</tr>
+<tr>
+  <td>com,wiley,interscience)/</td>
+  <td>31</td>
+</tr>
+</table><pre><b>QUERY:</b> SELECT  surt,
+COUNT(*)
+FROM homepage
+GROUP BY surt
+ORDER BY COUNT(*) DESC
+LIMIT 10;</pre>
+<br></code></div><p>What is the deal with all those "benjamins" URLs?</p>
+<div style="margin: 1em 3em 1em 3em; "><code><table>
+  <thead><tr>
+  <th>publisher</th>
+  <th>name</th>
+</tr></thead>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>NOWELE</td>
+</tr>
+<tr>
+  <td></td>
+  <td>Studia Uralo-Altaica</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>Language Problems and Language Planning</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>Lingvisticæ investigationes</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>Linguistics of the TIbeto-Burman Area</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>Pragmatics & Cognition</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>Terminology</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>Written Language & Literacy</td>
+</tr>
+<tr>
+  <td></td>
+  <td>FORUM: Revue internationale d?interprétation et de traduction / International Journal of Interpretation and Translation</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>English Text Construction</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>Constructions and Frames</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>Pragmatics and Society</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>Translation and Interpreting Studies</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>Language and Dialogue</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>Metaphor in Language, Cognition, and Communication</td>
+</tr>
+<tr>
+  <td></td>
+  <td>Hamburg Studies on Linguistic Diversity</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>Translation Spaces</td>
+</tr>
+<tr>
+  <td></td>
+  <td>Studies in Arabic Linguistics</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>Journal of Immersion and Content-Based Language Education (JICB)</td>
+</tr>
+<tr>
+  <td></td>
+  <td>Children's Literature, Culture, and Cognition</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>Journal of Language Aggression and Conflict</td>
+</tr>
+<tr>
+  <td></td>
+  <td>FILLM Studies in Languages and Literatures</td>
+</tr>
+<tr>
+  <td></td>
+  <td>Advances in Historical Sociolinguistics</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>Linguistic Landscape</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>International Journal of Learner Corpus Research</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>Journal of Second Language Pronunciation</td>
+</tr>
+<tr>
+  <td></td>
+  <td>ITL - International Journal of Applied Linguistics</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>Cognitive Individual Differences in Second Language Processing and Acquisition</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>FORUM</td>
+</tr>
+<tr>
+  <td>John Benjamins Publishing Company</td>
+  <td>Studies in Germanic Linguistics</td>
+</tr>
+</table><pre><b>QUERY:</b> SELECT  publisher,
+name
+FROM journal
+LEFT JOIN homepage ON journal.issnl = homepage.issnl
+WHERE homepage.surt = 'com,benjamins)/';</pre>
+<br></code></div><p>Domains that block us:</p>
+<div style="margin: 1em 3em 1em 3em; "><code><table>
+  <thead><tr>
+  <th>domain</th>
+  <th>journal_homepages</th>
+  <th>SUM(blocked)</th>
+</tr></thead>
+<tr>
+  <td>jstor.org</td>
+  <td>7669</td>
+  <td>6575</td>
+</tr>
+<tr>
+  <td>wiley.com</td>
+  <td>4285</td>
+  <td>229</td>
+</tr>
+<tr>
+  <td>brill.nl</td>
+  <td>234</td>
+  <td>161</td>
+</tr>
+<tr>
+  <td>bentham.org</td>
+  <td>152</td>
+  <td>150</td>
+</tr>
+<tr>
+  <td>annualreviews.org</td>
+  <td>174</td>
+  <td>103</td>
+</tr>
+<tr>
+  <td>euppublishing.com</td>
+  <td>62</td>
+  <td>54</td>
+</tr>
+<tr>
+  <td>hogrefe.com</td>
+  <td>72</td>
+  <td>51</td>
+</tr>
+<tr>
+  <td>icevirtuallibrary.com</td>
+  <td>46</td>
+  <td>37</td>
+</tr>
+<tr>
+  <td>uem.br</td>
+  <td>49</td>
+  <td>36</td>
+</tr>
+<tr>
+  <td>brepolsonline.net</td>
+  <td>47</td>
+  <td>34</td>
+</tr>
+<tr>
+  <td>futuremedicine.com</td>
+  <td>40</td>
+  <td>31</td>
+</tr>
+<tr>
+  <td>siam.org</td>
+  <td>67</td>
+  <td>23</td>
+</tr>
+<tr>
+  <td>vr-elibrary.de</td>
+  <td>24</td>
+  <td>17</td>
+</tr>
+<tr>
+  <td>liverpooluniversitypress.co.uk</td>
+  <td>26</td>
+  <td>15</td>
+</tr>
+<tr>
+  <td>rodopi.nl</td>
+  <td>20</td>
+  <td>15</td>
+</tr>
+<tr>
+  <td>nrcresearchpress.com</td>
+  <td>18</td>
+  <td>14</td>
+</tr>
+<tr>
+  <td>aiaa.org</td>
+  <td>34</td>
+  <td>10</td>
+</tr>
+<tr>
+  <td>guilfordjournals.com</td>
+  <td>14</td>
+  <td>10</td>
+</tr>
+<tr>
+  <td>ingentaconnect.com</td>
+  <td>417</td>
+  <td>9</td>
+</tr>
+<tr>
+  <td>univie.ac.at</td>
+  <td>54</td>
+  <td>9</td>
+</tr>
+</table><pre><b>QUERY:</b> SELECT  domain,
+COUNT(*) as journal_homepages,
+SUM(blocked)
+FROM homepage
+GROUP BY domain
+ORDER BY SUM(blocked) DESC
+LIMIT 20;</pre>
+<br></code></div><p>Top duplicated domains:</p>
+<div style="margin: 1em 3em 1em 3em; "><code><table>
+  <thead><tr>
+  <th>url</th>
+  <th>COUNT(*)</th>
+</tr></thead>
+<tr>
+  <td><a href="http://www.indianjournals.com/">http://www.indianjournals.com/</a></td>
+  <td>73</td>
+</tr>
+<tr>
+  <td><a href="http://www.hindawi.com/">http://www.hindawi.com/</a></td>
+  <td>70</td>
+</tr>
+<tr>
+  <td><a href="http://search.informit.com.au/search;res=APAFT">http://search.informit.com.au/search;res=APAFT</a></td>
+  <td>60</td>
+</tr>
+<tr>
+  <td><a href="http://www.umi.com/proquest">http://www.umi.com/proquest</a></td>
+  <td>46</td>
+</tr>
+<tr>
+  <td><a href="http://www.umi.com/pqdauto/">http://www.umi.com/pqdauto/</a></td>
+  <td>45</td>
+</tr>
+<tr>
+  <td><a href="http://ieeexplore.ieee.org/Xplore/conferences.jsp">http://ieeexplore.ieee.org/Xplore/conferences.jsp</a></td>
+  <td>40</td>
+</tr>
+<tr>
+  <td><a href="http://omicsonline.org/">http://omicsonline.org/</a></td>
+  <td>36</td>
+</tr>
+<tr>
+  <td><a href="http://www.idealibrary.com/">http://www.idealibrary.com/</a></td>
+  <td>36</td>
+</tr>
+<tr>
+  <td><a href="http://ieeexplore.ieee.org/xpl/conferences.jsp">http://ieeexplore.ieee.org/xpl/conferences.jsp</a></td>
+  <td>24</td>
+</tr>
+<tr>
+  <td><a href="http://www.metapress.com/">http://www.metapress.com/</a></td>
+  <td>24</td>
+</tr>
+<tr>
+  <td><a href="http://www.randspublications.org/">http://www.randspublications.org/</a></td>
+  <td>22</td>
+</tr>
+<tr>
+  <td><a href="http://www.studia.ubbcluj.ro/serii/index_en.html">http://www.studia.ubbcluj.ro/serii/index_en.html</a></td>
+  <td>22</td>
+</tr>
+<tr>
+  <td><a href="http://find.galegroup.com/ips/publicationSearch.do">http://find.galegroup.com/ips/publicationSearch.do</a></td>
+  <td>21</td>
+</tr>
+<tr>
+  <td><a href="http://jurnal.unimed.ac.id/">http://jurnal.unimed.ac.id/</a></td>
+  <td>21</td>
+</tr>
+<tr>
+  <td><a href="http://www.bioinfo.in/journals.php">http://www.bioinfo.in/journals.php</a></td>
+  <td>20</td>
+</tr>
+<tr>
+  <td><a href="http://www.interscience.wiley.com/">http://www.interscience.wiley.com/</a></td>
+  <td>20</td>
+</tr>
+<tr>
+  <td><a href="http://www.commongroundpublishing.com/">http://www.commongroundpublishing.com/</a></td>
+  <td>19</td>
+</tr>
+<tr>
+  <td><a href="http://www.haworthpress.com/">http://www.haworthpress.com/</a></td>
+  <td>19</td>
+</tr>
+<tr>
+  <td><a href="http://www.heinonline.org/">http://www.heinonline.org/</a></td>
+  <td>19</td>
+</tr>
+<tr>
+  <td><a href="http://www.infosci-journals.com/">http://www.infosci-journals.com/</a></td>
+  <td>19</td>
+</tr>
+</table><pre><b>QUERY:</b> SELECT  url,
+COUNT(*)
+FROM homepage
+GROUP BY url
+ORDER BY COUNT(*) DESC
+LIMIT 20;</pre>
+<br></code></div><p>Number of journals with a homepage that points to web.archive.org or archive.org:</p>
+<div style="margin: 1em 3em 1em 3em; "><code><table>
+  <thead><tr>
+  <th>COUNT(DISTINCT issnl)</th>
+</tr></thead>
+<tr>
+  <td>1453</td>
+</tr>
+</table><pre><b>QUERY:</b> SELECT COUNT(DISTINCT issnl)
+FROM homepage
+WHERE domain = 'archive.org';</pre>
+<br></code></div><p>Top publishers that have journals in wayback:</p>
+<div style="margin: 1em 3em 1em 3em; "><code><table>
+  <thead><tr>
+  <th>publisher</th>
+  <th>COUNT(*)</th>
+</tr></thead>
+<tr>
+  <td></td>
+  <td>653</td>
+</tr>
+<tr>
+  <td>EDP Sciences</td>
+  <td>23</td>
+</tr>
+<tr>
+  <td>CAIRN</td>
+  <td>18</td>
+</tr>
+<tr>
+  <td>OpenEdition</td>
+  <td>18</td>
+</tr>
+<tr>
+  <td>Elsevier</td>
+  <td>6</td>
+</tr>
+<tr>
+  <td>Springer</td>
+  <td>6</td>
+</tr>
+<tr>
+  <td>PERSEE Program</td>
+  <td>5</td>
+</tr>
+<tr>
+  <td>Peer Community In</td>
+  <td>5</td>
+</tr>
+<tr>
+  <td>Institut de recherche et d'histoire des textes (France)</td>
+  <td>4</td>
+</tr>
+<tr>
+  <td>San Lucas Medical</td>
+  <td>4</td>
+</tr>
+</table><pre><b>QUERY:</b> SELECT  publisher,
+COUNT(*)
+FROM journal
+LEFT JOIN homepage ON journal.issnl = homepage.issnl
+WHERE homepage.domain = 'archive.org'
+GROUP BY journal.publisher
+ORDER BY COUNT(*) DESC
+LIMIT 10;</pre>
+<br></code></div><p>Top publishers by number of journals missing a homepage:</p>
+<div style="margin: 1em 3em 1em 3em; "><code><table>
+  <thead><tr>
+  <th>publisher</th>
+  <th>COUNT(*)</th>
+</tr></thead>
+<tr>
+  <td></td>
+  <td>21472</td>
+</tr>
+<tr>
+  <td>Peter Lang International Academic Publishers</td>
+  <td>1270</td>
+</tr>
+<tr>
+  <td>Elsevier</td>
+  <td>866</td>
+</tr>
+<tr>
+  <td>J-STAGE</td>
+  <td>863</td>
+</tr>
+<tr>
+  <td>Egypts Presidential Specialized Council for Education and Scientific Research</td>
+  <td>340</td>
+</tr>
+<tr>
+  <td>Georg Thieme Verlag KG</td>
+  <td>288</td>
+</tr>
+<tr>
+  <td>Al Manhal FZ, LLC</td>
+  <td>217</td>
+</tr>
+<tr>
+  <td>Informa UK (Taylor & Francis)</td>
+  <td>202</td>
+</tr>
+<tr>
+  <td>Springer-Verlag</td>
+  <td>156</td>
+</tr>
+<tr>
+  <td>ELSEVIER LTD</td>
+  <td>145</td>
+</tr>
+<tr>
+  <td>Inderscience</td>
+  <td>122</td>
+</tr>
+<tr>
+  <td>African Journals Online</td>
+  <td>121</td>
+</tr>
+<tr>
+  <td>Diva Enterprises Private Limited</td>
+  <td>119</td>
+</tr>
+<tr>
+  <td>PERSEE Program</td>
+  <td>118</td>
+</tr>
+<tr>
+  <td>Sabinet</td>
+  <td>109</td>
+</tr>
+<tr>
+  <td>SAGE Publications</td>
+  <td>103</td>
+</tr>
+<tr>
+  <td>Brill</td>
+  <td>99</td>
+</tr>
+<tr>
+  <td>Superintendent of Government Documents</td>
+  <td>99</td>
+</tr>
+<tr>
+  <td>Taylor & Francis</td>
+  <td>98</td>
+</tr>
+<tr>
+  <td>Bentham Science</td>
+  <td>94</td>
+</tr>
+</table><pre><b>QUERY:</b> SELECT  publisher,
+COUNT(*)
+FROM journal
+WHERE any_homepage=0
+GROUP BY publisher
+ORDER BY COUNT(*) DESC
+LIMIT 20;</pre>
+<br></code></div>