CODEWITHSUNDEEP
sqldatabasegoogle-bigquerygdelt
Patrick T.
Patrick T.

Reputation: 11

How do I search the GDELT database hosted in Google's BigQuery for a keyword, as I can with the GDELT API?

How can I query articles in BigQuery GDELT that make mention of a keyword such as "climate change" (despite the lack of a keyword column)? Admittedly, I am a complete novice at working with databases and may be misunderstanding something simple, so please feel free to point anything out.

I am attempting to query articles pertaining to keywords of interest in order to trace the provenance of a query claim. I would use the GDELT API, which supports fast querying with keywords, but it only returns articles in the past 3 months. The nature of the problem I'm interested in likely requires locating information potentially years ago. Thus I figured I could try querying the public GDELT Events database in Google BigQuery, however I am confused how to query by keyword, as there is no column/feature for keywords or event content.

Upvotes: 1

Views: 478

Answers (1)

Nestor
Nestor

Reputation: 1377

Did you meant Gdelt public dataset stored in bigquery ? You can view the dataset here. You can simply run select query against this dataset or even tune the query to apply condition to your use case.

I would suggest visiting this article for more details about querying and BQ's capabilities when writing querys and I believe a good starting point for writing queries in BQ: https://cloud.google.com/bigquery/docs/introduction-sql

Upvotes: 0

Related Questions