Global Embedded Metadata Graph (GEMG): November 2021 Top META Tags

The Global Embedded Metadata Graph (GEMG) records all HTML META tags found in each article, making it trivial to examine the top kinds of metadata encoded in these tags. Using the query below we can generate a histogram of the top tags from November 1, 2021 through today.

SELECT
metatag.key,
count(distinct(url)) cnt,
count(distinct(url)) / (SELECT count(distinct(url)) tot FROM `gdelt-bq.gdeltv2.gemg` WHERE DATE(date) >= '2021-11-01' ) * 100 perc
FROM `gdelt-bq.gdeltv2.gemg`, unnest(metatags) metatag WHERE DATE(date) >= '2021-11-01' and metatags is not null group by metatag.key order by cnt desc

You can download the final list below: