"primary_location:source.source.type" == "type"?

[yhan818]

I am currently conducting citation analysis. I focus on “works” data obtained from OpenAlex. This dataset serves as the primary source for conducting data analysis and data mining, specifically aimed at understanding the publications and citation (mainly articles).

I primarily use the “host_organization” field to analyze our publishers and selected publishers along with their associated journals. This analysis helps us identify which journals are frequently cited and determine how many times individual journals or publishers have been cited over the years.

During the process, I filtered using "issn_l" containing value for year 2019 to 2023.
# Filter rows where issn_l is neither NA nor an empty string articles_cited <- works_cited_final[!is.na(works_cited_final$issn_l) & works_cited_final$issn_l != "", ]
As a result, ~20% of articles have "referenced_works" values as NA. For example, https://openalex.org/works/W2980882411

I met with OpenAlex staff and they said that some book chapters have ISSN too . They recommended using an additional filter to see "primary_location:source.source.type: " = "journal".

OpenAlex technical documentation has "Journal articles will have a primary_location.source.type of journal"

I checked my data pulled, which has 38 cols. One col has a name "type". Is this the mapping of the" primary_location:source.source.type: "? If not, how to get it?

Thank you very much,

[yjunechoe]

Thanks for the details (and cross-checking with the OpenAlex team)!

I'm having some trouble following the narrative though - is the stuff about "host_organization" and "issn_l" also part of the issue you're reporting here?

Could you give us a small reprex isolating the problem? Then we can us use that as the basis for debugging.