bqsub - Documentation

This documentation serves as an overview of bibliometric data provided on Google BigQuery by the SUB Göttingen.

Status Crossref

Current Snapshot (cr_instant)

Info: Only includes publications with type 'journal-article'

Snapshot	File	Table	Schema	Procedure	Last Changed	Coverage	Number of rows
2025/02	all.json.tar.gz	cr_instant.snapshot	schema_crossref.json	Repo	10.03.2025	2013-2025	53.132.181

Historical Snapshots (cr_history)

Info: Only includes publications with type 'journal-article'

Snapshot	File	Table	Schema	Procedure	Last Changed	Coverage	Number of rows
2018/04	all.json.tar.gz	cr_history.cr_apr18	schema_crossref.json	Repo	20.02.2022	2013-2018	16.766.035
2019/04	all.json.tar.gz	cr_history.cr_apr19	schema_crossref.json	Repo	29.10.2021	2013-2019	20.715.644
2020/04	all.json.tar.gz	cr_history.cr_apr20	schema_crossref.json	Repo	29.10.2021	2013-2020	25.334.525
2021/04	all.json.tar.gz	cr_history.cr_apr21	schema_crossref.json	Repo	29.10.2021	2013-2021	30.579.119
2022/04	all.json.tar.gz	cr_history.cr_apr22	schema_crossref.json	Repo	14.05.2022	2013-2022	35.939.195
2023/04	all.json.tar.gz	cr_history.cr_apr23	schema_crossref.json	Repo	07.05.2023	2013-2023	41.767.461
2024/04	all.json.tar.gz	cr_history.cr_apr24	schema_crossref.json	Repo	07.05.2024	2013-2024	47.709.184

Status Unpaywall

Current Snapshot (upw_instant)

Snapshot	File	Table	Schema	Procedure	Last Changed	Coverage	Number of rows
2022/03	unpaywall_snapshot_2022-03-09T083001.jsonl.gz	upw_instant.snapshot	bq_schema_mar22.json	Repo	14.03.2022	2008-2022	67.424.819

Historical Snapshots (upw_history)

Snapshot	File	Table	Schema	Procedure	Last Changed	Coverage	Number of rows
2018/03	unpaywall_snapshot_2018-03-29T113154.jsonl.gz	upw_history.upw_Mar18_08_20	bq_schema_mar18.json	Repo	29.10.2021	2008-2018	36.557.043
2019/02	unpaywall_snapshot_2019-02-21T031509.jsonl.gz	upw_history.upw_Feb19_08_19	bq_schema_feb19.json	Repo	10.11.2021	2008-2019	42.143.979
2020/02	unpaywall_snapshot_2020-02-25T115244.jsonl.gz	upw_history.upw_Feb20_08_20	bq_schema_feb20.json	Repo	30.10.2021	2008-2020	49.717.710
2021/02	unpaywall_snapshot_2021-02-18T160139.jsonl.gz	upw_history.upw_Feb21_08_21	bq_schema_feb21.json	Repo	29.10.2021	2008-2021	58.437.927
2022/03	unpaywall_snapshot_2022-03-09T083001.jsonl.gz	upw_history.upw_Mar22_08_22	bq_schema_mar22.json	Repo	14.03.2022	2008-2022	67.424.819

Status Semantic Scholar

Snapshot	Directory	Table	Schema	Procedure	Last Changed	Coverage	Number of rows
2025-02-25	papers/	semantic_scholar.papers	s2_papers_schema.json	Repo	04.03.2025	All	224.566.486
2025-02-25	venues/	semantic_scholar.venues	s2_venues_schema.json	Repo	04.03.2025	All	194.578
2025-02-25	abstracts/	semantic_scholar.abstracts	s2_abstracts_schema.json	Repo	04.03.2025	All	108.246.108

Status Openalex

Snapshot	Directory	Table	Schema	Procedure	Last Changed	Coverage	Number of rows
2025-02-27	authors/	openalex.authors	schema_openalex_author.json	Repo	13.03.2025	All	102.382.226
2025-02-28	funders/	openalex.funders	schema_openalex_funders.json	Repo	13.03.2025	All	32.437
2025-02-28	institutions/	openalex.institutions	schema_openalex_institutions.json	Repo	13.03.2025	All	112.271
2025-02-28	publishers/	openalex.publishers	schema_openalex_publishers.json	Repo	13.03.2025	All	10.741
2025-02-28	sources/	openalex.sources	schema_openalex_sources.json	Repo	13.03.2025	All	260.812
2025-02-24	topics/	openalex.topics	schema_openalex_topics.json	Repo	13.03.2025	All	4.516
2025-02-27	works/	openalex.works	schema_openalex_work.json	Repo	13.03.2025	All	264.675.127

Status OpenAlex Document Type classification by SUB Göttingen

Info: Only includes publications with type 'article' or 'review' and primary source type 'journal'

Snapshot	Directory	Table	Schema	Procedure	Last Changed	Coverage	Number of rows
2025-02-27	works/	resources.classification_article_reviews_2014_2025_february25	schema_document_types.json	Repo	13.03.2025	2014-2025	59.219.719