Map of Global Antitank and MANPADS Weapons

Kalev's latest piece for Forbes includes an interactive CartoDB map visualizing eight months of global coverage of antitank and MANPADS weapons across 65 languages.

(Click to View Map in Full Browser Window)

MAKING THE MAP

To make the map above, simply follow the instructions for Mapping the GDELT GKG and use the following BigQuery SQL query:

SELECT DATE, DocumentIdentifier, SourceCommonName, V2Themes, V2Locations, V2Tone, SharingImage, TranslationInfo FROM [gdeltv2.gkg] where (V2Themes like '%ANTITANK%' or V2Themes like '%ANTI_TANK%' or V2Themes like '%MANPAD%'
or V2Themes like '%MAN_PORTABLE_AIR_DEFENSE_SYSTEM%' or V2Themes like '%MAN_PORTABLE_AIR_DEFENCE_SYSTEM%')