Most popular journals

[ValWood]

we made a list in 2022. A couple of people said they would find it useful to see over the past 5 years, and maybe we could host on PomBase somewhere.

It doesn't need to be very prominent, maybe: https://www.pombase.org/documents

[kimrutherford]

Do you have the previous list to jog my memory?

[ValWood]

journal_count_with_year.csv

[kimrutherford]

maybe we could host on PomBase somewhere.

Let's chat about that on a call sometime.

Here is an updated counts file: journal_count_with_year-2024.csv

I'm going to include the SQL this time so I don't have to go looking when we need it again:

CREATE TABLE journal_counts AS
SELECT substring(miniref FROM '(.*?) \d\d\d\d.*') AS journal,
       substring(miniref FROM '.*? (\d\d\d\d)[^\d].*') AS year,
       pub_id
FROM pub WHERE uniquename like 'PMID:%' AND miniref IS NOT NULL;

\copy (select substring(journal for 50) as journal_name, year, count(pub_id) from journal_counts group by journal, year order by year desc, count(pub_id) desc) to 'journal_count_with_year-2024.csv' csv header

[kimrutherford]

Action: add to "Other documents" here: https://pombase.org/documents

[kimrutherford]

Action: add to "Other documents" here: https://pombase.org/documents

That's done for Tuesday morning. I'll check then.

[kimrutherford]

That's done for Tuesday morning. I'll check then.

https://pombase.org/documents

I turned it into an Excel file. It's the last link on the page, under "Other documents". It's not exactly prominent. Should it be in a different section maybe?

The Documents page could do with updating anyway.

[ValWood]

I will tag this onto a future announcement, but I just tried the link and I can't open the file.

[kimrutherford]

I just tried the link and I can't open the file.

What error do you get?

[ValWood]

I get this:

then when I say yes I get a message that just says "style" and still nothing opens

[kimrutherford]

Can you open this one?:

journal_count_with_year-2024.xlsx

[ValWood]

yes!

[kimrutherford]

I've swapped in the file that works. I've put the file in its own "Statistics" sub-heading because it was very hidden under the "Other documents" heading. Do you have a better suggestion for the heading?

[ValWood]

Maybe call it 'publication metrics' (and we can broaden if we include other data?)

[kimrutherford]

Maybe call it 'publication metrics' (and we can broaden if we include other data?)

Sounds good. That change will be on the main site in a little while.