more notes on SIM/fatcat intersections

1 files changed, 77 insertions, 1 deletions

diff --git a/notes/fatcat_sim_intersection.md b/notes/fatcat_sim_intersection.md
index 43500ec..bb81884 100644
--- a/notes/fatcat_sim_intersection.md
+++ b/notes/fatcat_sim_intersection.md
@@ -16,7 +16,83 @@ investigate how many fatcat releases match to SIM:
     =>  0.7m in_ia_sim volume issue pages first_page preservation:none
     =>  2.5m in_ia_sim volume issue pages first_page date
 - how many (any?) SIM journals with no fatcat container
-- how many SIM journals/issues/years with ~no fatcat releases
+    total: 14860
+    missing-issn: 2863
+    no-match: 554
+    -> 3417./ 14860 = 23%
+- how many SIM journals/issues/years with ~no fatcat releases?
+    as of 2020-07-21: of 212 pubids (with scanned issues so far), 129 have any fatcat releases (60%)
 
 at least some (release_jpruczlec5gsjpbc2cbvwedsdy) have updated crossref
 metadata with issue numbers
+
+
+## 2020-07-20
+
+Categories of interesction:
+
+- fatcat catalog record and in SIM corpus: have good metadata, could
+  potentially extract just pages (for fulltext search) and link directly to
+  access
+    => at least 22m records; 18.4m no known public fulltext
+    => at least 6m with enough metadata to match; 5.3m no known public fulltext
+        => TODO: how many of this 16m metadata gap can be fixed by finding better metadata?
+    => SIM digitized yet?
+    => TODO: estimate at issue level
+
+    example:
+        "The Savings Gained From Participation in Health Promotion Programs for Medicare Beneficiaries"
+        https://fatcat.wiki/release/hp7jsz2cfnc3dgepk7oxj7kvjm
+        https://archive.org/details/sim_journal-of-occupational-and-environmental-medicine_2006-11_48_11/page/1125
+        https://scholar-qa.archive.org/search?q=%22responses+to+the+hra+or+from+data+gathered%22
+
+- SIM corpus paper, no fatcat catalog record
+    => TODO: estimate from issue count/ratio
+
+- fatcat catalog record, and fulltext, no SIM paper
+
+Current scholar.archive.org behavior is to use fatcat metadata to create a
+work-level document (with multiple pages) if possible. If not, the entire issue
+is issue is split into page-level documents.
+
+TODO: only "count" paper/records which have enough metadata to actually link
+(eg, volume, issue, pages), not just any `in_ia_sim`.
+
+#### SQL Queries
+
+    select count(*) from sim_pub;
+    => 212
+
+    select count(distinct sim_pubid) from release_counts;
+    => 129
+
+    select count(*) from sim_issue;
+    => 78301
+
+    select count(*) from sim_issue left join release_counts on sim_issue.year = release_counts.year and sim_issue.sim_pubid = release_counts.sim_pubid and sim_issue.volume = release_counts.volume where release_counts.sim_pubid is not null and release_counts.release_count > 0;
+    => 218
+
+    select count(*) from sim_issue left join release_counts on sim_issue.year = release_counts.year and sim_issue.sim_pubid = release_counts.sim_pubid and sim_issue.volume = release_counts.volume where release_counts.sim_pubid is not null and release_counts.release_count >= 3;
+    => 179
+
+    select count(*) from sim_issue left join release_counts on sim_issue.year = release_counts.year and sim_issue.sim_pubid = release_counts.sim_pubid and sim_issue.volume = release_counts.volume where release_counts.sim_pubid is not null and release_counts.release_count >= 10;
+    => 166
+
+    select sum(release_count) from release_counts;
+    => 9968
+
+    select sum(release_count) from release_counts where release_count >= 3;
+    => 9940
+
+    select count(*) from (select 1 from sim_issue group by sim_pubid, volume);
+    => 6405
+
+    select count(*) from (select sim_pubid, SUM(release_count) as release_count from release_counts group by sim_pubid);
+    => 129
+
+    select count(*) from (select sim_pubid, SUM(release_count) as release_count from release_counts group by sim_pubid) where release_count >= 10;
+    => 86
+
+    select count(*) from (select sim_pubid, SUM(release_count) as release_count from release_counts group by sim_pubid) where release_count >= 100;
+    => 27
+