How can we use the new Global Embedded Metadata Graph to explore some of the trends in metadata usage in a day of online news coverage?
What are the kinds of <META> tags we see in news coverage? Here is a query that returns a selection of META tags:
SELECT date, url, title, lang, metatag.key, metatag.type, metatag.value FROM `gdelt-bq.gdeltv2.gemg`, unnest(metatags) metatag WHERE DATE(date) = '2020-12-01' and metatags is not null limit 100
And here are the results for a particular news article, showing the tags it provides:
| date | url | title | lang | key | type | value | ||
|---|---|---|---|---|---|---|---|---|
| 84 |
2020-12-01 20:18:36 UTC
|
https://thebusinesscourier.com/ru/lidery-g20-rassmotryat-mezhdunarodnyj-plan-po-testirovaniyu-koronavirusa-v-aeroportah
|
Пост – THE BUSINESS COURIER
|
RUSSIAN
|
robots
|
name
|
index, follow
|
|
| 85 |
2020-12-01 20:18:36 UTC
|
https://thebusinesscourier.com/ru/lidery-g20-rassmotryat-mezhdunarodnyj-plan-po-testirovaniyu-koronavirusa-v-aeroportah
|
Пост – THE BUSINESS COURIER
|
RUSSIAN
|
format-detection
|
name
|
telephone=no
|
|
| 86 |
2020-12-01 20:18:36 UTC
|
https://thebusinesscourier.com/ru/lidery-g20-rassmotryat-mezhdunarodnyj-plan-po-testirovaniyu-koronavirusa-v-aeroportah
|
Пост – THE BUSINESS COURIER
|
RUSSIAN
|
viewport
|
name
|
width=device-width, height=device-height, initial-scale=1.0, maximum-scale=1.0, user-scalable=0
|
|
| 87 |
2020-12-01 20:18:36 UTC
|
https://thebusinesscourier.com/ru/lidery-g20-rassmotryat-mezhdunarodnyj-plan-po-testirovaniyu-koronavirusa-v-aeroportah
|
Пост – THE BUSINESS COURIER
|
RUSSIAN
|
og:url
|
property
|
https://thebusinesscourier.com/ru/lidery-g20-rassmotryat-mezhdunarodnyj-plan-po-testirovaniyu-koronavirusa-v-aeroportah
|
|
| 88 |
2020-12-01 20:18:36 UTC
|
https://thebusinesscourier.com/ru/lidery-g20-rassmotryat-mezhdunarodnyj-plan-po-testirovaniyu-koronavirusa-v-aeroportah
|
Пост – THE BUSINESS COURIER
|
RUSSIAN
|
og:type
|
property
|
article
|
|
| 89 |
2020-12-01 20:18:36 UTC
|
https://thebusinesscourier.com/ru/lidery-g20-rassmotryat-mezhdunarodnyj-plan-po-testirovaniyu-koronavirusa-v-aeroportah
|
Пост – THE BUSINESS COURIER
|
RUSSIAN
|
og:title
|
property
|
Лидеры G20 рассмотрят международный план по тестированию коронавируса в аэропортах
|
|
| 90 |
2020-12-01 20:18:36 UTC
|
https://thebusinesscourier.com/ru/lidery-g20-rassmotryat-mezhdunarodnyj-plan-po-testirovaniyu-koronavirusa-v-aeroportah
|
Пост – THE BUSINESS COURIER
|
RUSSIAN
|
og:description
|
property
|
Предложение World Travel и Tourism Council, направленное на "оживление индустрии туризма" и защиту рабочих мест
|
|
| 91 |
2020-12-01 20:18:36 UTC
|
https://thebusinesscourier.com/ru/lidery-g20-rassmotryat-mezhdunarodnyj-plan-po-testirovaniyu-koronavirusa-v-aeroportah
|
Пост – THE BUSINESS COURIER
|
RUSSIAN
|
og:image
|
property
|
https://thebusinesscourier.com/storage/app/media/Travel/covid tests.png
|
|
| 92 |
2020-12-01 20:18:36 UTC
|
https://thebusinesscourier.com/ru/lidery-g20-rassmotryat-mezhdunarodnyj-plan-po-testirovaniyu-koronavirusa-v-aeroportah
|
Пост – THE BUSINESS COURIER
|
RUSSIAN
|
fb:app_id
|
property
|
1419371654985540
|
This query returns just "keyword" fields from articles that have "covid" in their title.
SELECT date, url, title, lang, metatag.key, metatag.type, metatag.value FROM `gdelt-bq.gdeltv2.gemg`, unnest(metatags) metatag WHERE key='keywords' and LOWER(title) like '%covid%' and DATE(date) = '2020-12-01' limit 50
You can see how some pages have multiple keyword fields.
| date | url | title | lang | key | type | value | ||
|---|---|---|---|---|---|---|---|---|
| 1 |
2020-12-01 20:19:04 UTC
|
https://news.culturacolectiva.com/mundo/cual-es-efectividad-de-vacuna-de-oxford-y-astrazeneca-contra-covid-19/
|
¿Qué tan efectiva es la vacuna de Oxford y AstraZeneca contra covid-19?
|
SPANISH
|
keywords
|
name
|
efectividad vacuna astrazeneca oxford covid19, efectividad, vacuna, astrazeneca, oxford, covid19, efectividad vacuna astrazeneca, astrazeneca oxford,
|
|
| 2 |
2020-12-01 20:18:57 UTC
|
https://www.washingtonpost.com/health/2020/11/09/biden-coronavirus-task-force/
|
Biden covid team: President-elect announces coronavirus task force made up of physicians and health experts
|
ENGLISH
|
keywords
|
name
|
Biden, Joe Biden, Kamala Harris, covid, covid 19, pandemic, coronavirus pandemic, Biden transition, Biden covid
|
|
| 3 |
2020-12-01 20:18:50 UTC
|
https://www.abc.net.au/radio/programs/am/experts-prefer-caution-over-blanket-border-closures-covid-normal/12941184
|
Preparing for covid-normal: experts prefer caution over blanket border closures
|
ENGLISH
|
keywords
|
name
|
podcast, border, covid, coronavirus, covid-19, public health, vaccine, interstate, australian medical association
|
|
| 4 |
2020-12-01 20:18:50 UTC
|
https://www.abc.net.au/radio/programs/am/experts-prefer-caution-over-blanket-border-closures-covid-normal/12941184
|
Preparing for covid-normal: experts prefer caution over blanket border closures
|
ENGLISH
|
keywords
|
itemprop
|
podcast, border, covid, coronavirus, covid-19, public health, vaccine, interstate, australian medical association
|
|
| 5 |
2020-12-01 19:47:01 UTC
|
https://www.elcomercio.com/deportes/piloto-lewis-hamilton-positivo-covid.html
|
El piloto Lewis Hamilton se siente 'bien' tras dar positivo por covid-19
|
SPANISH
|
keywords
|
name
|
piloto, Lewis, Hamilton, positivo, covid
|
|
| 6 |
2020-12-01 19:47:03 UTC
|
https://www.elcomercio.com/tendencias/serenata-italia-esposa-hospital-pandemia.html
|
Un hombre de 81 años le dio una serenata a su esposa hospitalizada por covid-19; ella murió unos días después
|
SPANISH
|
keywords
|
name
|
serenata, italia, esposa, hospital, pandemia
|
|
| 7 |
2020-12-01 20:04:57 UTC
|
https://www.elobservador.com.uy/nota/lacalle-pou-esta-reunido-con-cientificos-y-ministros-para-definir-medidas-contra-el-coronavirus-2020121164040
|
Lacalle está reunido con científicos y ministros para definir medidas contra el covid-19
|
SPANISH
|
keywords
|
name
|
Luis Lacalle Pou, Daniel Salinas, coronavirus, Covid-19, pandemia, Álvaro Delgado, lacalle, reunido, científicos, ministros, definir, medidas, contra, covid-19
|
|
| 8 |
2020-12-01 20:04:57 UTC
|
https://www.elobservador.com.uy/nota/lacalle-pou-esta-reunido-con-cientificos-y-ministros-para-definir-medidas-contra-el-coronavirus-2020121164040
|
Lacalle está reunido con científicos y ministros para definir medidas contra el covid-19
|
SPANISH
|
keywords
|
itemprop
|
Luis Lacalle Pou
|
|
| 9 |
2020-12-01 20:04:57 UTC
|
https://www.elobservador.com.uy/nota/lacalle-pou-esta-reunido-con-cientificos-y-ministros-para-definir-medidas-contra-el-coronavirus-2020121164040
|
Lacalle está reunido con científicos y ministros para definir medidas contra el covid-19
|
SPANISH
|
keywords
|
itemprop
|
Daniel Salinas
|
|
| 10 |
2020-12-01 20:04:57 UTC
|
https://www.elobservador.com.uy/nota/lacalle-pou-esta-reunido-con-cientificos-y-ministros-para-definir-medidas-contra-el-coronavirus-2020121164040
|
Lacalle está reunido con científicos y ministros para definir medidas contra el covid-19
|
SPANISH
|
keywords
|
itemprop
|
coronavirus
|
|
| 11 |
2020-12-01 20:04:57 UTC
|
https://www.elobservador.com.uy/nota/lacalle-pou-esta-reunido-con-cientificos-y-ministros-para-definir-medidas-contra-el-coronavirus-2020121164040
|
Lacalle está reunido con científicos y ministros para definir medidas contra el covid-19
|
SPANISH
|
keywords
|
itemprop
|
Covid-19
|
|
| 12 |
2020-12-01 20:04:57 UTC
|
https://www.elobservador.com.uy/nota/lacalle-pou-esta-reunido-con-cientificos-y-ministros-para-definir-medidas-contra-el-coronavirus-2020121164040
|
Lacalle está reunido con científicos y ministros para definir medidas contra el covid-19
|
SPANISH
|
keywords
|
itemprop
|
pandemia
|
|
| 13 |
2020-12-01 20:04:57 UTC
|
https://www.elobservador.com.uy/nota/lacalle-pou-esta-reunido-con-cientificos-y-ministros-para-definir-medidas-contra-el-coronavirus-2020121164040
|
Lacalle está reunido con científicos y ministros para definir medidas contra el covid-19
|
SPANISH
|
keywords
|
itemprop
|
Álvaro Delgado
|
|
| 14 |
2020-12-01 19:49:13 UTC
|
https://www.gloucestershirelive.co.uk/news/gloucester-news/gloucestershires-covid-tier-3-wales-4754347
|
Gloucestershire's covid Tier 3 and Wales borders – where you can't go from tomorrow
|
ENGLISH
|
keywords
|
name
|
Coronavirus,Gloucestershire,Stroud,Cotswolds,Forest of Dean
|
|
| 15 |
2020-12-01 19:48:57 UTC
|
https://www.noticiasdenavarra.com/actualidad/sociedad/2020/12/01/sanidad-notifica-8257-nuevos-casos/1099909.html
|
Sanidad notifica 8.257 nuevos casos y 442 muertes más por covid-19
|
SPANISH
|
keywords
|
name
|
Sanidad,notifica,8257,nuevos,casos,muertes,covid19,Sociedad,noticia,noticias,noticias de hoy,noticias de navarra, navarra
|
|
| 16 |
2020-12-01 20:16:44 UTC
|
https://www.chinookobserver.com/coronavirus/peninsula-pharmacies-opens-for-drive-thru-covid-testing/article_cea14742-339f-11eb-a633-dfcad9982570.html
|
Peninsula Pharmacies opens for drive-thru covid testing
|
ENGLISH
|
keywords
|
name
|
test, jerry phillips, medicine, hospital, health board, provider, katie lindstrom, pharmacy, individual, willapa harbor hospital, law
|
|
Alternatively, this query returns only Google News "news_keyword" fields from articles that have "covid" in their title.
SELECT date, url, title, lang, metatag.key, metatag.type, metatag.value FROM `gdelt-bq.gdeltv2.gemg`, unnest(metatags) metatag WHERE key='keywords' and LOWER(title) like '%covid%' and DATE(date) = '2020-12-01' limit 50
With the following results:
| date | url | title | lang | key | type | value | ||
|---|---|---|---|---|---|---|---|---|
| 1 |
2020-12-01 20:19:20 UTC
|
https://www.journaldequebec.com/2020/12/01/les-symptomes-persistants-de-la-covid-19-pendant-plusieurs-mois
|
Les symptômes persistants de la COVID-19 pendant plusieurs mois
|
FRENCH
|
news_keywords
|
name
|
trouble du goût,Aucune étude,maux de tête,troubles du sommeil,trouble post-traumatique,nouveaux cas,éprouver des symptômes,maux de gorge,œdème des membres,phase aigüe,plusieurs mois,récent rapport,résiduels de la maladie,documenter les symptômes,développements de la pandémie,perte de l’odorat,dresse une liste,myalgie,palpitation,étourdissements,Noël,Québec
|
|
| 2 |
2020-12-01 20:18:57 UTC
|
https://www.washingtonpost.com/health/2020/11/09/biden-coronavirus-task-force/
|
Biden covid team: President-elect announces coronavirus task force made up of physicians and health experts
|
ENGLISH
|
news_keywords
|
name
|
Biden, Joe Biden, Kamala Harris, covid, covid 19, pandemic, coronavirus pandemic, Biden transition, Biden covid
|
|
| 3 |
2020-12-01 20:18:59 UTC
|
https://www.rbc.ru/society/01/12/2020/5fc6a15c9a794744e68d3ecd
|
В Москве число умерших с COVID-19 превысило 9 тыс.
|
RUSSIAN
|
news_keywords
|
name
|
Пандемия, Коронавирус, Возрасти, Столичный, Оперативный, Смертельный, Сообщать, Актуальный, Материал, Дополняться, Подтвердить, Прошедшее
|
|
| 4 |
2020-12-01 20:31:56 UTC
|
https://www.reuters.com/article/us-health-coronavirus-france-infections/new-covid-19-cases-in-france-stay-below-10000-for-third-day-idUSKBN28B64Y
|
New COVID-19 cases in France stay below 10,000 for third day
|
ENGLISH
|
news_keywords
|
name
|
US;HEALTH;CORONAVIRUS;FRANCE;INFECTIONS;Coronavirus;Diseases;Europe;Euro Zone;France;Health / Medicine;Infectious Diseases;Major News;Public Health;Western Europe
|
|
| 5 |
2020-12-01 20:31:54 UTC
|
https://www.washingtontimes.com/news/2020/dec/1/pentagon-reports-12th-military-death-covid-19/
|
Pentagon reports 12th military death from COVID-19
|
ENGLISH
|
news_keywords
|
name
|
Disaster Accident
|
|
| 6 |
2020-12-01 20:05:04 UTC
|
https://news.yahoo.com/mark-zuckerberg-says-facebook-asked-193732310.html
|
Mark Zuckerberg says Facebook has asked Biden team about collaborating on COVID-19 vaccine response
|
ENGLISH
|
news_keywords
|
name
|
Mark Zuckerberg, Facebook, Joe Biden
|
|
| 7 |
2020-12-01 20:05:05 UTC
|
https://www.wjcl.com/article/nearly-1-300-new-covid-19-cases-reported-in-south-carolina-20-deaths-in-1-day/34837434
|
Nearly 1,300 new COVID-19 cases reported in South Carolina, 20+ deaths in 1 day
|
ENGLISH
|
news_keywords
|
name
|
Beaufort County, COVID-19, DHEC, South Carolina, coronavirus, deaths, hospitalized, new cases
|
|
| 8 |
2020-12-01 20:04:57 UTC
|
https://www.elobservador.com.uy/nota/lacalle-pou-esta-reunido-con-cientificos-y-ministros-para-definir-medidas-contra-el-coronavirus-2020121164040
|
Lacalle está reunido con científicos y ministros para definir medidas contra el covid-19
|
SPANISH
|
news_keywords
|
name
|
Luis Lacalle Pou, Daniel Salinas, coronavirus, Covid-19, pandemia, Álvaro Delgado, lacalle, reunido, científicos, ministros, definir, medidas, contra, covid-19
|
|
| 9 |
2020-12-01 20:02:23 UTC
|
https://www.skai.gr/news/world/yperpsifistikan-ta-metra-kata-covid-pou-tha-isxyoun-apo-tin-tetarti-stin-agglia
|
Υπερψηφίστηκαν τα μέτρα κατά COVID που θα ισχύουν από την Τετάρτη στην Αγγλία
|
GREEK
|
news_keywords
|
name
|
Βρετανία, κορωνοϊός, lockdown, skai, ειδήσεις
|
|
| 10 |
2020-12-01 19:47:26 UTC
|
https://newpost.gr/ellada/5fc67a8bf2bbfe0171e4ff29/koronoios-apisteyto-eftiaxe-aytoshedia-monada-covid-sto-spiti-gia-na-frontisei-tin-pethera-toy
|
Κορωνοϊός – Απίστευτο: Έφτιαξε αυτοσχέδια μονάδα COVID στο σπίτι για να φροντίσει την πεθερά του
|
GREEK
|
news_keywords
|
name
|
ειδήσεις, ενημέρωση, νέα, πολιτική, Ελλάδα, παραπολιτικά, οικονομία, κόσμος, αθλητικά, media, lifestyle, πολιτισμός, γεύση, τεχνολογία, newpost.gr
|
|
| 11 |
2020-12-01 20:02:20 UTC
|
https://www.thebest.gr/article/602379-pagkosmia-imera-gia-to-aids-poso-tha-epireasei-i-pandimia-covid-19-tin-epiteuxi-ton-stochon
|
Παγκόσμια Ημέρα για το AIDS: Πόσο θα επηρεάσει η πανδημία COVID-19 την επίτευξη των στόχων
|
GREEK
|
news_keywords
|
name
|
Υγεία
|
|
| 12 |
2020-12-01 19:48:35 UTC
|
https://www.nordlittoral.fr/101297/article/2020-12-01/covid-19-une-campagne-de-vaccination-grand-public-envisagee-entre-avril-et-juin
|
Covid-19 : une campagne de vaccination grand public envisagée « entre avril et juin »
|
FRENCH
|
news_keywords
|
name
|
Covid-19, campagne, vaccination, grand, public, envisagée, entre, avril,,Épidémie,,
|
|
| 13 |
2020-12-01 19:48:12 UTC
|
https://www.lepoint.fr/monde/comment-l-australie-s-est-quasiment-debarrassee-du-covid-19–30-11-2020-2403300_24.php
|
Comment l'Australie s'est quasiment débarrassée du Covid-19
|
FRENCH
|
news_keywords
|
name
|
Confinement,Covid-19,Virus,Vaccins,Scott Morrison, Australie,Melbourne
|
|
| 14 |
2020-12-01 20:02:54 UTC
|
https://www.journaldemontreal.com/2020/12/01/les-symptomes-persistants-de-la-covid-19-pendant-plusieurs-mois
|
Les symptômes persistants de la COVID-19 pendant plusieurs mois
|
FRENCH
|
news_keywords
|
name
|
trouble du goût,Aucune étude,maux de tête,troubles du sommeil,trouble post-traumatique,nouveaux cas,éprouver des symptômes,maux de gorge,œdème des membres,phase aigüe,plusieurs mois,récent rapport,résiduels de la maladie,documenter les symptômes,développements de la pandémie,perte de l’odorat,dresse une liste,myalgie,palpitation,étourdissements,Noël,Québec
|
|
| 15 |
2020-12-01 20:03:15 UTC
|
https://www.journaldemontreal.com/2020/12/01/covid-19-des-aines-abandonnes-dans-leur-urine-dans-une-residence-de-sherbrooke
|
COVID-19: Des ainés abandonnés dans leur urine dans une résidence de Sherbrooke
|
FRENCH
|
news_keywords
|
name
|
publique rapportait,abandonner des aînés,diagnostic de COVID,urine dans une résidence,éclosion de COVID,COVID,Brooks,TVA,TVA Nouvelles,Sherbrooke
|
The following query compiles a list of date and time-related fields by looking for related words in their metadata fields:
SELECT date, url, title, lang, metatag.key, metatag.type, metatag.value FROM `gdelt-bq.gdeltv2.gemg`, unnest(metatags) metatag WHERE (key like '%published%' OR key like '%date%' OR key like '%time%') and DATE(date) = '2020-12-01' limit 100
| date | url | title | lang | key | type | value | ||
|---|---|---|---|---|---|---|---|---|
| 1 |
2020-12-01 20:18:24 UTC
|
https://oregional.com.br/cidades/ministerio-da-educacao-lanca-jogo-virtual-para-ajudar-na-alfabetizacao-de-criancas/
|
Ministério da Educação Lança Jogo Virtual Para Ajudar na Alfabetização de Crianças
|
PORTUGUESE
|
article:published_time
|
property
|
2020-12-01T13:30:21+00:00
|
|
| 2 |
2020-12-01 20:18:24 UTC
|
https://oregional.com.br/cidades/ministerio-da-educacao-lanca-jogo-virtual-para-ajudar-na-alfabetizacao-de-criancas/
|
Ministério da Educação Lança Jogo Virtual Para Ajudar na Alfabetização de Crianças
|
PORTUGUESE
|
article:modified_time
|
property
|
2020-12-01T13:31:29+00:00
|
|
| 3 |
2020-12-01 20:18:28 UTC
|
https://www.hna.de/verbraucher/cyber-monday-black-friday-2020-amazon-saturn-tipps-sparen-media-markt-angebote-tricks-kassel-hna-zr-90110120.html
|
Tipps zum Cyber Monday 2020: Mit diesen Tricks auch nach Black Friday sparen
|
GERMAN
|
article:published_time
|
property
|
2020-11-30T20:52:00+01:00
|
|
| 4 |
2020-12-01 20:18:36 UTC
|
https://pplware.sapo.pt/smartphones-tablets/xiaomi-tira-a-apple-do-top-3-de-vendas-de-smartphones/
|
Xiaomi tira a Apple do TOP 3 de vendas de smartphones
|
PORTUGUESE
|
article:published_time
|
property
|
2020-12-01T18:00:34+00:00
|
|
| 5 |
2020-12-01 20:18:36 UTC
|
https://pplware.sapo.pt/smartphones-tablets/xiaomi-tira-a-apple-do-top-3-de-vendas-de-smartphones/
|
Xiaomi tira a Apple do TOP 3 de vendas de smartphones
|
PORTUGUESE
|
article:modified_time
|
property
|
2020-12-01T18:05:30+00:00
|
|
| 6 |
2020-12-01 20:18:36 UTC
|
https://pplware.sapo.pt/smartphones-tablets/xiaomi-tira-a-apple-do-top-3-de-vendas-de-smartphones/
|
Xiaomi tira a Apple do TOP 3 de vendas de smartphones
|
PORTUGUESE
|
og:updated_time
|
property
|
2020-12-01T18:05:30+00:00
|
|
| 7 |
2020-12-01 20:18:44 UTC
|
https://baomoi.com/bi-mat-moi-ve-quai-vat-ho-loch-ness/c/37205520.epi
|
Bí mật mới về quái vật hồ Loch Ness
|
VIETNAMESE
|
msvalidate.01
|
name
|
94801D71438B64887D4670AB4661921E
|
|
| 8 |
2020-12-01 20:18:44 UTC
|
https://baomoi.com/bi-mat-moi-ve-quai-vat-ho-loch-ness/c/37205520.epi
|
Bí mật mới về quái vật hồ Loch Ness
|
VIETNAMESE
|
article:published_time
|
property
|
2020-12-02T02:50:00.000+07:00
|
|
| 9 |
2020-12-01 20:18:48 UTC
|
https://www.batiactu.com/edito/re2020-capacites-production-sont-assure-luc-charmasson-60746.php
|
RE2020 : "Les capacités de production sont là", assure Luc Charmasson (CSF Bois)
|
FRENCH
|
article:published_time
|
property
|
2020-11-27T14:22:59Z
|
|
| 10 |
2020-12-01 20:18:48 UTC
|
http://jamaica-star.com/article/entertainment/20201201/di-trilla-revving-his-career-new-single
|
Di Trilla revving up his career with new single
|
ENGLISH
|
og:updated_time
|
property
|
2020-12-01T05:01:35-05:00
|
We're tremendously excited to see what you're able to do with this new dataset!