{"id":42567,"date":"2026-09-10T20:27:37","date_gmt":"2026-09-10T18:27:37","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/self-promotion-full-historical-gdelt-event-archive-50-years-hundreds-of-millions-of-rows-as-clean-sampled-parquet-no-api-or-bigquery-limits\/"},"modified":"2026-09-10T20:27:37","modified_gmt":"2026-09-10T18:27:37","slug":"self-promotion-full-historical-gdelt-event-archive-50-years-hundreds-of-millions-of-rows-as-clean-sampled-parquet-no-api-or-bigquery-limits","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/self-promotion-full-historical-gdelt-event-archive-50-years-hundreds-of-millions-of-rows-as-clean-sampled-parquet-no-api-or-bigquery-limits\/","title":{"rendered":"[self-promotion] Full Historical GDELT Event Archive (50+ Years, Hundreds Of Millions Of Rows) As Clean, Sampled Parquet, No API Or BigQuery Limits"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>Disclosure: I&#8217;m the developer of the tool linked below.<\/p>\n<p>GDELT (the Global Database of Events, Language, and Tone) is one of the largest open event datasets around: every reported event worldwide since 1979, tagged by actor, location, tone, and (via the Global Knowledge Graph) the article that reported it. The catch is actually getting the full thing: the official API caps you at ~250 rows per query and a 3-month window, and BigQuery&#8217;s free tier (1TB\/month query, 10GB storage) doesn&#8217;t stretch to a full historical pull either. The raw bulk archive at <a href=\"http:\/\/data.gdeltproject.org\/\">data.gdeltproject.org<\/a> is open, but it&#8217;s thousands of loose CSV\/ZIP files with no sampling or joining logic of its own.<\/p>\n<p>I built GdeltForge to close that gap: it downloads, checksums, converts to Parquet, and reproducibly samples the whole archive locally, and can cross-reference a sample back onto the Global Knowledge Graph. Check out the <a href=\"https:\/\/pypi.org\/project\/gdeltforge\/\">PyPI page<\/a>, the <a href=\"https:\/\/github.com\/Vinicius-Teixeirac\/GdeltForge\">GitHub Repo<\/a>, the <a href=\"https:\/\/vinicius-teixeirac.github.io\/GdeltForge\/\">documentation<\/a>, <strong>and especially the<\/strong> <a href=\"https:\/\/colab.research.google.com\/github\/Vinicius-Teixeirac\/GdeltForge\/blob\/main\/getting-started.ipynb\">hands-on getting started notebook<\/a>, runnable directly in Colab, no install needed. You can generate you own samples or even scan the entire data to create a dataset<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/Hendrik-Lorentz\"> \/u\/Hendrik-Lorentz <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1wcrdpt\/selfpromotion_full_historical_gdelt_event_archive\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1wcrdpt\/selfpromotion_full_historical_gdelt_event_archive\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-42567 jlk' href='javascript:void(0)' data-task='like' data-post_id='42567' data-nonce='b9a40cecc8' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-42567 lc'>0<\/span><\/a><\/div><\/div> <div class='status-42567 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Disclosure: I&#8217;m the developer of the tool linked below. GDELT (the Global Database of Events, Language, and&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-42567","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/42567","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=42567"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/42567\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=42567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=42567"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=42567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}