From a1cf127f3412f406ff34539b3af86b3b0d06f213 Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Mon, 28 Dec 2020 22:55:58 -0800 Subject: missing homepages update (2020-10-13) --- notes/missing_homepage_task.md | 13 +++++++++++++ 1 file changed, 13 insertions(+) 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; -- cgit v1.2.3