Inside Offshore Leaks @ CIJ Summer School

The Centre of Investigative Journalism‘s Summer School 2013 starts in three days.  I will be joining Duncan Campbell and David Leigh to discuss the work involved in producing stories for the International Consortium of Investigative Journalists‘s “Offshore Leaks” project.


David Leigh, Duncan Campbell, Craig Shaw | Sunday 14 July (15:05-16:15)

The 2012-13 Offshore Leaks reporting project of the Washington-based International Consortium of Investigative Journalists (ICIJ) has forced law enforcement authorities in Britain, the US and Australia to admit that they had failed to act on information they held about secret offshore accounts, and to start taking action. The project has helped changed tax policy in the EU and with other international organisations (see; #offshoreleaks).

The Offshore Leaks reports were prepared from the largest collection of leaked data ever gathered and analysed by any investigative journalism team anywhere. The information analysed totalled 260 gigabytes (GB) of data. This is 162 times larger than the 252,000 US State Department cables leaked to and published by Wikileaks. The leaked data included company and trust documents and instructions, emails, databases, personal identity documents, accounting information and agents’ and companies’ internal papers and reports. The speakers will focus on the successes and failures of work on the project, the lessons learned and experience gained.
* * *
See timetable below, click here to visit CIJ site and find out more about this year’s Summer School.
Friday 12 July
8.20-9.10 Registration, tea and coffee in the Great Hall Foyer
9.10-9.40 Welcome by Gavin MacFadyen, Director of the CIJ in the Great Hall 
Talks: AG07 Talks: AG08 Talks: AG09 Labs: AG34A+B Labs: A308
9.45-10.55 The Secret History of Torture
Ian Cobain
Understanding Company Accounts: How to Get the Most of Companies House Martin Tomkinson and Robert Miller Libel and Privacy Law Justin Walford CAR Intro: Start Here if you are New to CAR (B) David Donald and Alex Plough
11.10-12.20 Understanding Company Accounts: Profits and Losses Raj Bairoliya Interviewing 1: Melanie McFadyean A Web Documentary Primer Kat Cizek Stats for stories with SPSS 1:  Frequencies and Other Descriptives (A) Jennifer LaFleur Excel 1: Power of Data Analysis for Stories (B) hands-on  David Donald and Caelainn Barr
12.20-13.30 Lunch
13.30-14.40 The Savile Panel Discussion with Mark Williams-Thomas, Paul Connew, Gavin Millar QC (chair) and Miles Goslett  in the Great Hall
Talks: AG07 Talks: AG08 Talks: AG09 Lab: AG34A+B Labs: A308
15.00-16.10 Understanding Company Accounts: Assets and Liabilities
Raj Bairoliya
Interviewing 2: Three Types of Interview: Roleplay
Robert Miller and Martin Tomkinson
The Politics of the Internet
Dr Richard Stallman
Stats for Stories with SPSS 2: Cross Tabulations (A) Jennifer LaFleur Excel 2: Finding the Patterns in the Data (B) hands-on David Donald and Caelainn Barr
16.25-17.35 Understanding Company Accounts: The Small Print and Q&A Raj Bairoliya How to Request Documents Under the Freedom of Information Act Brendan Montague and Lucas Amin Introduction to Offshore  John Christensen and Nick Mathiason Stats for Stories with SPSS 3: Linear Regression (A) David Donald Excel 3: Summarising Your data for the Big Picture (B), hands-on Jennifer LaFleur and Aron Pilhofer
17.55-19.05 Jim Nichol will be talking about  The Marikana Tragedy
In the Great Hall
19.05-21.00 Party

Saturday 13 July
Talks: AG07 Talks: AG08 Talks: AG09 Labs: AG34A+B Labs: A308
9.00-10.10 Story-based Inquiry 1. A Method Through the Madness: How Hypotheses Frame and Sell your Story Mark Lee Hunter InfoSec: The Introduction. Information Security, Technology and Behaviours: What They are and why you Need Them Arjen Kamphuis and Michael Rogers Understanding Company Accounts: An Interactive Demonstration Raj Bairoliya Stats for Stories with SPSS 4: Logistic Regression (A) Jennifer LaFleur Access 1: Understanding Databases (B) hands-on Aron Pilhofer, David Donald
10.25-11.35 Story-based Inquiry 2: The Hidden Scenario: Using Timelines and Characters to Advance your Story Luuk Sengers Infosec: Workshop-I Arjen Kamphuis and Michael  Rogers personal laptops required
Aron Pilhofer and Francesca Panetta
What to do When There is no Data – Sampling and Building Databases (A) Jennifer LaFleur Access 2: Digging for the Story (B) hands-on David Donald and Caelainn Barr
11.50-13.00 Tales of Money and Power: Reporting Environmental Stories
Mark Schapiro
Infosec: Workshop-II
Arjen Kamphuis and Michael Rogers personal laptops and USB-drives required
The Snowden Case and a Life of High-risk Investigations
David Leigh
Story-based Inquiry 3. Take Control: Making and Using Masterfile
Luuk Sengers
Access 3: Joining Databases for Deeper Analysis (B) hands-on Aron Pilhofer and David Donald
13.00-14.00 Lunch
14.00-15.10 Seymour Hersh. 
Pulitzer Prize winning journalist on Digging Deeper: How to Make the News More Important.
In the Great Hall
Talks: AG07 Talks: AG08 Labs: A220 Labs: AG34A+B Labs: A308
Mark Lee Hunter
HIGHRISE: The Making of an Emmy-winning Web Documentary Kat Cizek Fusion Tables (A)
Alex Plough
Mapping for Stories 1 (A) Jennifer LaFleur Interactive Data: Lessons from the New York Times (A)
Aron Pilhofer
16.50-18.00 Understanding Company Accounts: How Companies Avoid Tax
Richard Brooks
Photography for Evidence GatheringDamien Spleeters Social Network Analysis: Using NodeXL to Analyze Social Networks (A) hands-on
David Donald
Mapping for Stories 2 (A) Jennifer LaFleur Importing Data (B) hands-on
Alex Plough
18.15 – 19.25 Spying: the Eye On Everyone. With Sy Hersh and Geoffrey Robertson QC.

Sunday 14 July
  Talks AG07 Talks AG08 Labs: A220 Labs: AG34A+B Labs: A308
10.00-11.10 Reporting the Courts and Getting the Best Stories
Paul Cheston
Webdocs: Where to Start: from Skills to Finances
Kat Cizek
Excel 1: the Power of Data Analysis for Stories (B) Hands-on Jennifer LaFleur and Aron Pilhofer SQL 1 (A) Hands-on David Donald Fusion Tables (A)
Alex Plough
11.25-12.35 Getting Scoops from Local Councils
Paul Francis and Ted Jeory
The Scope and Significance of NSA-GCHQ Surveiilance
Duncan Campbell
Excel 2: Finding the Patterns in the Data (B) hands-on
Jennifer LaFleur and Aron Pilhofer
SQL 2 (A) hands-on David Donald Webdocs: Klynt 1/3 – Main Features (B) hands-on
Arnaud Dressen and Maria Gemayel
12.35-13.40 Lunch.
13.40-14.50 Keynote speech: Ioan Grillo. Investigating the Mexican Drug Cartels. At the Great Hall.
Talks: AG07 Talks: AG08 Labs: A220 Labs: AG34A+B Labs: A308
15.05- 16.15 How to Write Stories Readers will Remember Andrew Jennings Inside Offshore Leaks. Duncan Campbell and Craig Shaw Excel 3:Summarising Your data for the Big Picture (B) hands-on Jennifer LaFleur and Aron Pilhofer Web Detective Demo Paul Myers Webdocs: Klynt 2/3 – Story Architecture (B) hands-on
Arnaud Dressen and Maria Gemayel
16.30-17.40 Covert Filming Roddy Mansfield and Allan Harraden Offshore Leaks: Mining and Using Big Data.
Matt Fowler
Excel 4: Stats for Journalists (B), hands-on David Donald What’s Next: Future of Data Journalism Jennifer LaFleur and Aron Pilhofer Webdocs: Klynt 3/3 – User experience (B) hands-on
Arnaud Dressen and Meria Gemayel
17.45-18.00 Thank you and goodbye

About craig shaw

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: