In a similar vein to the 2015 global conflict map, the map below compiles a list of every location on earth mentioned on at least 16 distinct days in 2015 and color-codes it by the average "tone" (emotion/sentiment) of all worldwide coverage mentioning that location over all of 2015, from bright green (very happy) to bright red (very unhappy).

TECHNICAL DETAILS

The final query to generate the map aggregates the 2015 GKG 2.0 dataset by unique location (using the Geographic FeatureID to normalize for different spellings and transliterations of a given location name), filters for the number of unique days in which that location was mentioned, and compiles the average tone of all of those mentions across 2015.

Alternatively, the following query rounds each location mention to a 0.01 grid and averages the tone for each grid cell, rather than at the resolution of individual locations. This is useful, for example, for grouping together the city of Chicago, major buildings there, and all of its various outlying suburbs into a single metro area, rather than treating them all as distinct and separate entities, or for aligning disparate geographic datasets for macro-level analysis.