diff options
| -rw-r--r-- | notes/missing_homepage_task.md | 13 |
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; |