COVID-19 Scientific Networks


The topics listed below correspond to subsets of the Dimensions COVID-19 dataset. Topics are generated using from a specific SQL query. Clicking on the topic allows to explore it using different network visualizations.

This website is automatically generated via dimensions-network-gen, a prototype Python application that makes it easier to construct network visualizations using Dimensions and VosViewer.


Topic: Regexp herd immunity
Query:

-- max_nodes: 400 
-- min_edge_weight: 2
-- min_concept_relevance: 0.6 
-- min_concept_frequency: 2

select id
from `covid-19-dimensions-ai.data.publications`
where 
REGEXP_CONTAINS(abstract.preferred, r'herd.*immunity|immunity.*herd')
Topic: 2020 pubs with altmetric 1 or more
Query:

-- network_types: concepts, organizations
-- max_nodes: 300 
-- min_edge_weight: 2
-- min_concept_relevance: 0.5 
-- min_concept_frequency: 5

select id
from `covid-19-dimensions-ai.data.publications`
where 
EXTRACT(YEAR FROM date_inserted) = 2020
and altmetrics.score > 1
Topic: Journal nature
Query:

-- network_types: concepts, organizations
-- max_nodes: 300 
-- min_edge_weight: 2
-- min_concept_relevance: 0.5 
-- min_concept_frequency: 2

select id
from `covid-19-dimensions-ai.data.publications`
where 
journal.id = "jour.1018957"
Topic: Journal science
Query:

-- network_types: concepts, organizations
-- max_nodes: 300 
-- min_edge_weight: 2
-- min_concept_relevance: 0.5 
-- min_concept_frequency: 2

select id
from `covid-19-dimensions-ai.data.publications`
where 
journal.id = "jour.1346339"
Topic: 2021 pubs with altmetric 1 or more
Query:

-- network_types: concepts, organizations
-- max_nodes: 300 
-- min_edge_weight: 2
-- min_concept_relevance: 0.5 
-- min_concept_frequency: 5

select id
from `covid-19-dimensions-ai.data.publications`
where 
EXTRACT(YEAR FROM date_inserted) = 2021
and altmetrics.score > 1
Topic: Regexp complex science
Query:

-- network_types: concepts, organizations
-- max_nodes: 300 
-- min_edge_weight: 2
-- min_concept_relevance: 0.6 
-- min_concept_frequency: 3

-- WARNING: this query uses full Dimensions data

select id
from `dimensions-ai.data_analytics.publications`
where 
REGEXP_CONTAINS(abstract.preferred, r'complexity.*science|science.*complexity')


Topic: Only preprints
Query:

-- network_types: concepts, organizations
-- max_nodes: 300 
-- min_edge_weight: 3
-- min_concept_relevance: 0.5 
-- min_concept_frequency: 5

select id
from `covid-19-dimensions-ai.data.publications`
where 
type="preprint"
Topic: Regexp conspiracy theory
Query:

-- network_types: concepts, organizations
-- max_nodes: 300 
-- min_edge_weight: 2
-- min_concept_relevance: 0.5 
-- min_concept_frequency: 2

select id
from `covid-19-dimensions-ai.data.publications`
where 
REGEXP_CONTAINS(abstract.preferred, r'conspiracy.*theory|theory.*conspiracy')
Topic: Italian authors
Query:

-- max_nodes: 400 
-- min_edge_weight: 2
-- min_concept_relevance: 0.7 
-- min_concept_frequency: 2


select id
from `covid-19-dimensions-ai.data.publications`
where 
"Italy" in UNNEST(research_org_country_names)
Topic: 2022 pubs with altmetric 1 or more
Query:

-- network_types: concepts, organizations
-- max_nodes: 300 
-- min_edge_weight: 2
-- min_concept_relevance: 0.5 
-- min_concept_frequency: 5

select id
from `covid-19-dimensions-ai.data.publications`
where 
EXTRACT(YEAR FROM date_inserted) = 2022
and altmetrics.score > 1
Topic: Last 30 days
Query:

-- network_types: concepts, organizations
-- max_nodes: 400 
-- min_edge_weight: 3
-- min_concept_relevance: 0.5 
-- min_concept_frequency: 4

select id
from `covid-19-dimensions-ai.data.publications`
where 
EXTRACT(DATE FROM date_inserted) >= DATE_ADD(CURRENT_DATE(), INTERVAL -30 DAY)
and altmetrics.score > 1
Topic: Regexp japan
Query:

-- network_types: concepts, organizations
-- max_nodes: 400 
-- min_edge_weight: 1
-- min_concept_relevance: 0.4
-- min_concept_frequency: 2

select id
from `covid-19-dimensions-ai.data.publications`
where 
REGEXP_CONTAINS(abstract.preferred, r'japan')
OR
REGEXP_CONTAINS(title.preferred, r'japan')