Context As mentioned on gdeltproject.org: A Global Database of Society Supported by Google Jigsaw, the GDELT Project monitors the world's broadcast, print, and web news from nearly every corner of every country in over 100 languages and identifies the people, locations, organizations, themes, sources, emotions, counts, quotes, images and events driving our global society every second of every day, creating a free open platform for computing on the entire world. Content Raw datafiles based on the date it was added to the GDELT 1.0 database covering a 2 year period from March 23, 2016 to March 22, 2018 were downloaded from source: http://data.gdeltproject.org/events/index.html. Once downloaded, the daily files were merged into one datafile which was then loaded into a Hive database table. The table was partitioned by country. Six random countries were chosen: Australia, Belgium, France, India, Japan, and New Zealand. Queries were used to output different attributes and aggregations for each country. The results of the queries were reformatted in Excel and then saved as a csv file. My goal was to take a big dataset and bring it down to a manageable size that I could use for simple visualizations. Acknowledgements GDELT Project website https://www.gdeltproject.org/ Inspiration Taking a deeper dive into the event codes used to categorize the news events, we can get an idea of the general public sentiment in each country. The event code classification is according to the [Conflict and Mediation Event Observations (CAMEO)][1] framework for event data research. [1]: http://data.gdeltproject.org/documentation/CAMEO.Manual.1.1b3.pdf