Skip to content

Instantly share code, notes, and snippets.

@albertyumol

albertyumol/gdelt_bigQ.sql

Created September 30, 2019 03:11
Show Gist options
  • Save albertyumol/3715a1cb2c5efb96269b05ac4dce0d02 to your computer and use it in GitHub Desktop.
Save albertyumol/3715a1cb2c5efb96269b05ac4dce0d02 to your computer and use it in GitHub Desktop.
Download ZIP
Big Query for event logs for news in the Philippines since year 2000
Raw
gdelt_bigQ.sql
select SQLDATE, MonthYear, EventRootCode, GoldsteinScale, NumMentions, AvgTone, ActionGeo_CountryCode, ActionGeo_Lat, ActionGeo_Long
from `gdelt-bq.full.events`
where
SQLDATE > 20000101 and
ActionGeo_CountryCode = 'RP';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment