diff options
| author | Bryan Newbold <bnewbold@archive.org> | 2020-10-08 17:36:35 -0700 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@archive.org> | 2020-10-08 17:36:35 -0700 |
| commit | f650d3014411b4bee07296e1cdd28e5dc49a3965 (patch) | |
| tree | d62ee2e07cfeedbcaba904b22544060284c9942e | |
| parent | a52e5f39346e28bdb2eb58f17a298177659dbbfe (diff) | |
| download | chocula-f650d3014411b4bee07296e1cdd28e5dc49a3965.tar.gz chocula-f650d3014411b4bee07296e1cdd28e5dc49a3965.zip | |
estimate coverage change from new coverage holdings
| -rw-r--r-- | notes/explore.md | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/notes/explore.md b/notes/explore.md index c25404d..a649217 100644 --- a/notes/explore.md +++ b/notes/explore.md @@ -1,4 +1,26 @@ +## 2020-10-08 + +How about preservation coverage from Scholar's Portal and Cariniana? + + + sqlite> select count(*), sum(journal.release_count), sum(journal.preserved_count) from journal join directory on journal.issnl = directory.issnl where directory.slug = 'cariniana'; + + count(*) sum(journal.release_count) sum(journal.preserved_count) + ---------- -------------------------- ---------------------------- + 777 165832 145352 + +Just 20k releases (or less). + + + sqlite> select count(*), sum(journal.release_count), sum(journal.preserved_count) from journal join directory on journal.issnl = directory.issnl where directory.slug = 'scholarsportal'; + + count(*) sum(journal.release_count) sum(journal.preserved_count) + ---------- -------------------------- ---------------------------- + 16973 45111605 40182992 + +Almost 5 million releases, potentially huge. + ## 2020-08-31 How big of a difference in preservation coverage stats does the inclusion of |