From f650d3014411b4bee07296e1cdd28e5dc49a3965 Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Thu, 8 Oct 2020 17:36:35 -0700 Subject: estimate coverage change from new coverage holdings --- notes/explore.md | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) 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 -- cgit v1.2.3