How might we combine the new Global Similarity Graph with the Global Knowledge Graph to identify coverage related to a given search? For example, what if we wanted to search the GKG for coverage that mentioned Surfside, Florida and then use the GSG to find coverage similar to those articles?

Doing so is as simple as:

WITH data AS (
    SELECT DocumentIdentifier url FROM `gdelt-bq.gdeltv2.gkg_partitioned` WHERE DATE(_PARTITIONTIME) = "2021-07-03" and V2Locations like '%Surfside%'
)
select * from `gdelt-bq.gdeltv2.gsg` where DATE(fromDate) = "2021-07-03" and fromUrl in (select url from data) OR toUrl in (select url from data)

This yields results like this:

What if we only want similar coverage published in a language other than English? We can simply append a language filter to the end of our query:

WITH data AS (
    SELECT DocumentIdentifier url FROM `gdelt-bq.gdeltv2.gkg_partitioned` WHERE DATE(_PARTITIONTIME) = "2021-07-03" and V2Locations like '%Surfside%'
)
select * from `gdelt-bq.gdeltv2.gsg` where DATE(fromDate) = "2021-07-03" and fromUrl in (select url from data) OR toUrl in (select url from data) and (fromlang!='ENGLISH' OR toLang!='ENGLISH')

This yields results like the following: