aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--notes/fatcat_sim_intersection.md78
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
+