{"id":6543,"date":"2010-08-02T00:00:52","date_gmt":"2010-08-01T23:00:52","guid":{"rendered":"http:\/\/www.transcend.org\/tms\/?p=6543"},"modified":"2019-11-18T10:26:25","modified_gmt":"2019-11-18T10:26:25","slug":"wikileaks-afghanistan-files-download-the-key-incidents-as-a-spreadsheet","status":"publish","type":"post","link":"https:\/\/www.transcend.org\/tms\/2010\/08\/wikileaks-afghanistan-files-download-the-key-incidents-as-a-spreadsheet\/","title":{"rendered":"Afghanistan: The War Logs"},"content":{"rendered":"

Wikileaks Afghanistan Files: Download the Key Incidents as a Spreadsheet<\/em><\/p>\n

Key incidents from the Wikileaks Afghanistan war logs selected by Guardian writers. As a spreadsheet, with co-ordinates
\n\u2022\u00a0Get this data<\/a>
\n\u2022 INTERACTIVE: These key incidents mapped<\/a>
\n\u2022 Glossary of military terms<\/a>
\n\u2022 How our datajournalism project worked<\/a><\/p>\n

It must be one of the biggest leaks in intelligence history. An archive of almost 90,000 files has come to light thanks to Wikileaks<\/a>, logging the history of the war in Afghanistan<\/a>, practically blow-by-blow. We’ve trawled through these incidents to help you make sense of the key events.<\/p>\n

We have reproduced full military<\/a> logs behind more than 200 of the key events from the database \u2013 you can navigate around them<\/a>. But if you want to download this data to play with it yourself, this is the place to come.<\/p>\n

These detailed reports show coalition forces’ attacks on civilians, friendly fire incidents and Afghan forces attacking each other \u2013 so-called green on green.<\/p>\n

Before you can read the original reports, however, these logs need a bit of explanation. Here’s how they’re organised:<\/p>\n

Each entry is divided into lots of columns. Some contain map references and the like \u2013 which we’ve used to map some of the incidents<\/a> for instance.<\/p>\n

Here is what the columns mean:<\/p>\n

Col A: Key<\/h2>\n

This is the unique indentifying code for each incident – if you have this, it makes it much easier to find.<\/p>\n

Col G: Date and time<\/h2>\n

Obvious – and in UK format (dd\/mm\/yy) which is used by Nato forces, rather than the US format (mm\/dd\/yy). It also often includes the time each incident occurred. They run from 2004 up to the end of 2009.<\/p>\n

Col H: Type<\/h2>\n

This section describes the type of incident. “Friendly fire” for instance, means coalition troops mistakenly firing on each other. “Friendly action” on the other hand, means “fighting started by our side” rather than an enemy attack.<\/p>\n

Col I: Category<\/h2>\n

This can have similar information – but with slightly more detail. ‘Blue-blue’ for instance, means our own troops shooting at each other.<\/p>\n

Col L: Title<\/h2>\n

This often has a brief summary of how many people were KIA \u2013 killed in action or WIA \u2013 wounded in action.<\/p>\n

Col M: Summary<\/h2>\n

This is the really important entry. It contains a short account of what happened, – although it’s often, but not always, written in pretty impenetrable military jargon. We have put together a glossary of the key terms here<\/a>.<\/p>\n

Cols T to AA: statistics<\/h2>\n

There follow some columns for statistics \u2013 friendly troops, host nation, civilians ‘KIA’ or ‘WIA’. Unfortunately, they are highly unreliable and the authors \u2013 many of them in the field of battle – often simply failed to fill them in.<\/p>\n

Col AH: CCIR<\/h2>\n

This is sometimes important \u2013 it may say “likely to cause negative media” or that there is a “credible allegation” civilians have been killed.<\/p>\n

We’ve also put together an interactive map of every IED \u2013 improvised explosive device \u2013 attack, all 16,000, where you can see how the number has rocketed since 2004.<\/p>\n

The data we have selected is below \u2013 as an Excel file (Google spreadsheets can’t cope with the enormous amount of text in these documents). What can you do with it?<\/p>\n

Download the data<\/h2>\n

\u2022 DATA: download the full list as a spreadsheet (XLS file)<\/a><\/p>\n

Can you do something with this data?<\/h2>\n

Flickr<\/strong> Please post your visualisations and mash-ups on our Flickr group<\/a> or mail us at datastore@guardian.co.uk<\/a><\/p>\n

World government data<\/h2>\n

\u2022 Search the world’s government datasets<\/a><\/p>\n

GO TO ORIGINAL \u2013 GUARDIAN.CO.UK<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Key incidents from the Wikileaks Afghanistan war logs selected by Guardian writers. As a spreadsheet, with co-ordinates.<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[65,57,219,60],"tags":[],"class_list":["post-6543","post","type-post","status-publish","format-standard","hentry","category-anglo-america","category-militarism","category-central-asia-2","category-whistleblowing-surveillance"],"_links":{"self":[{"href":"https:\/\/www.transcend.org\/tms\/wp-json\/wp\/v2\/posts\/6543","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.transcend.org\/tms\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.transcend.org\/tms\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.transcend.org\/tms\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.transcend.org\/tms\/wp-json\/wp\/v2\/comments?post=6543"}],"version-history":[{"count":0,"href":"https:\/\/www.transcend.org\/tms\/wp-json\/wp\/v2\/posts\/6543\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.transcend.org\/tms\/wp-json\/wp\/v2\/media?parent=6543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.transcend.org\/tms\/wp-json\/wp\/v2\/categories?post=6543"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.transcend.org\/tms\/wp-json\/wp\/v2\/tags?post=6543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}