The query below searches across the GRG, which today totals more than 1.6 billion statements across English language news coverage dating back to October 27, 2020:
WITH data AS (select date, pre, verb, post, urls[offset(0)].url url, urls[offset(0)].title title, LOWER(CONCAT(pre, ' ', verb, ' ', post)) search from `gdelt-bq.gdeltv2.grg_vcn` WHERE DATE(date) >= "2021-05-01") select date, pre, verb, post, url, title from data where ( search like '%vaccin%' )
Using this query we find 585,524 results.
- Download Results. (22MB JSON / 179MB uncompressed)