aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@archive.org>2020-12-28 22:55:58 -0800
committerBryan Newbold <bnewbold@archive.org>2020-12-28 22:55:58 -0800
commita1cf127f3412f406ff34539b3af86b3b0d06f213 (patch)
treeceb74a752095cc9a4e617692d8ff0e8fcdb693c0
parent76cfdc1c446da8edfeabaf12039bbb5dcdedd651 (diff)
downloadchocula-a1cf127f3412f406ff34539b3af86b3b0d06f213.tar.gz
chocula-a1cf127f3412f406ff34539b3af86b3b0d06f213.zip
missing homepages update (2020-10-13)
-rw-r--r--notes/missing_homepage_task.md13
1 files changed, 13 insertions, 0 deletions
diff --git a/notes/missing_homepage_task.md b/notes/missing_homepage_task.md
index 418415b..5e6d270 100644
--- a/notes/missing_homepage_task.md
+++ b/notes/missing_homepage_task.md
@@ -85,3 +85,16 @@ NOTE: this is a partial list, as of 2020-05-05 about 4600 rows,
After the first round of manual homepage identification, as of 2020-07-08 there
are only 264 journals remaining selected by the above query.
+
+## 2020-10-13 Update
+
+ .headers on
+ .mode tabs
+ .output chocula_missing_hompages.2020-10-13.tsv
+
+ SELECT issnl, issnp, issne, name, publisher, country, lang, release_count, has_dois
+ FROM journal
+ WHERE
+ any_homepage=0
+ AND name IS NOT NULL
+ AND valid_issnl=1;