GDELT text data extract for a specific country

20 hours ago 1
ARTICLE AD BOX

I intend to check the inflation-related data for the UK. And I was trying to get it from the GDELT huge database in Google BigQuery. As of my research, there is only a news link available at the moment, but I need the news title and text. So, my question is, is it possible somehow? And I tried to restrict the locations within the selected country, but after downloading the CSV, I found out that there are also a few other countries' data sources available.

SELECT DATE, SourceCommonName, Themes, V2Tone, Locations, DocumentIdentifier FROM `gdelt-bq.gdeltv2.gkg_partitioned` WHERE _PARTITIONDATE = DATE '2023-01-01' AND REGEXP_CONTAINS(Themes, r'ECON_INFLATION|ECON_PRICES|ECON_COSTLIVING') AND REGEXP_CONTAINS(Locations, r'United Kingdom|UK|GBR') LIMIT 20;
Read Entire Article