Stories

GIJC21 Resources

September 28, 2021

Conference resources will be uploaded and organized here by topic. We’ve added here additional reports from the GIJN Resource Center, which attendees may find useful.

Have a tipsheet or slides for your session at GIJC21? Send us a copy here and we’ll post it.

Session Name	Tipsheets	Presentations	GIJN's Guides and Tipsheets	Stories/Videos
Asia/Pacific Collaborations	Investigate Coal Power (Annelise Giseburt) Where to begin investigation (Jiyoon Kim) Cross-Border Collaboration on Drug Trafficking Related Topic in East Asia and Southeast Asia (Will Yang) How to Work with Traumatized Victims of Sexual Crimes for an in-depth Report (Dini Pramita)	How Lawyers Helped me Investigate Coal Power (Annelise Giseburt) Where to Begin Investigation: From a Home Country of a Transnational Conglomerate (Jiyoon Kim) Investigating Digital Sex Crime (Dini Pramita) Drug Trafficking in East Asian Countries (Will Yang) Covering Digital Sex Crimes in Asia (Raquel Carvalho) The Coal Dilemma in Indonesia (Nana Riskhi)	Partnerships and Collaborations Guide (also in Spanish and Arabic)
Autocrats, Oligarchs, and Kleptocrats: The Global Fight for a Watchdog Press			Investigating Mafia States and Kleptocracies (also in Turkish, Spanish and Hindi)	5 Journalism Tips from Edwy Plenel Taking the Pulse of the Global IJ Community: Democracy, Press Freedom, and Threats to Journalism GIJC21 Launches with Call to Action for Investigative Journalists: Find Allies — and Fight Why Journalists in Autocracies Should Report as If They’re in a Democracy (also in Turkish, French)
Breaking into Documentaries	Breaking Into Documentaries (Carrie Lozano) International Investigative Documentaries (Tom Giles)	Determining Which Story to Tell? (John-Allan Namu)	How to Set Up a Video Unit: A GIJN Guide for Small Organizations	Expert Advice for Breaking Into Documentaries
Business Strategies to Support Investigative Journalism		Standard Business Models (Steve Ahern) Audience Growth & Retention (Koreel Lahiri) How Membership is a Key Model for Investigative Journalism (Claudia Urquieta)	Business Tools for Newsrooms: A GIJN Guide
Citizen Investigators			Partnerships and Collaborations Guide (also in Spanish and Arabic) Citizen Investigation Guide (also in Spanish)
Climate Change Investigations	Tools (Hans Nicholas Jong)	Climate Reporting Tools (Hans Nicholas Jong) Collaborative Environmental Reporting: The Case of the Rainforest Investigation Network (Gustavo Faleiros)		Tips for Investigating the Climate Change Crisisv My Favorite Tools: Geo-Journalist Gustavo Faleiros (Spanish, Turkish, Bangla)
Climate Change: A Report from the Front Lines at COP26	Investigate Climate Change (James Fahn)
Crowdsourced Investigations	Crowdsourcing for Open Source Investigations (Giancarlo Fiorella) Tipsheet: Crowdsourcing Investigations at the ABC (Flip Prior, Clare Blumer)	Dying Homeless and Closed Doors (Maeve McClenaghan) Crowdsourcing for Open Source Investigations (Giancarlo Fiorella) Crowdsourcing Investigations at the ABC (Flip Prior, Clare Blumer)
Dealing with Burnout & Stress		BEYOND BURNOUT: Stress, Trauma and Resilience for Investigative Reporters (Bruce Shapiro & Elana Newman)		Resilient Reporting: Tips on How to Cope with Burnout and Trauma Journalism is Stressful Work. Here Are Resources for Reporters Coping with Trauma (also in Spanish, Turkish) How Journalists Can Deal With Trauma While Reporting on COVID-19 (also in Spanish, Russian, Arabic, Indonesia, Mandarin, Bangla)
Digging into Health & Medicine	Re-Check, Investigating and Mapping Health Affairs (Catherine Riva & Serena Tinari) Using Data to Investigate Health Stories (Syed Nazakat)	How to Read, Understand and Report on Medical Research (Fabiola Torres López) Investigating & Mapping Re-Check Health Affairs (Serana Tinari)	GIJN Guide: Investigating Health & Medicine (Also in: French, Italian, Russian, Spanish, Arabic, Hindi)
Exposing the Roots of Disinformation
Fundraising: How to Fund Your Investigation		JNI (Lisa Main) How to Fund Your Investigation (Ides Debruyne)	Grants & Fellowships (also in Arabic, Russian, French, Mandarin)
Fundraising: How to Write a Proposal	General Research Resources (Bridget Gallagher, Caroline Jarboe)	How to Write a Proposal: Strategies, Insights, Experiences (Bridget Gallagher, Caroline Jarboe)	A GIJN Guide to Fundraising
High Crimes & Misdemeanors	Reporting Repressions & Turning Them into Infographics (Maxim Litavrin)	Investigation of Ukrainian Judges (Anna Babinets) How Liberian Politicians and Officials Escape Accounting for Their Wealth (Bettie Kemah Johnson-Mbayo) Ponzi-Investigating Lebanon’s Central Bank Governor (Alia Ibrahim) Reporting Repressions & Turning Them into Infographics (Maxim Litavrin)	A GIJN Guide: Investigating Organized Crime	Undercover in the Sudanese Schools That Chain Boys
Human Trafficking & Forced Labor	Migration & Human Trafficking (Roli Srivastava)	Fruits of Labor (Robin McDowell) Pandemic and Forced Labor (Roli Srivastava) Forced Labour Presentation (Annie Kelly)	Organized Crime Series: Investigating Human Trafficking, an Evil Hidden in Plain Sight (also in Spanish, Arabic, Bangla, Turkish, Indonesia) A GIJN Guide: Investigating Organized Crime
Indigenous Investigations	Indigenous Investigative Reporting (Trina Roache)		GIJN/NAJA Guide for Indigenous Investigative Journalists	The Indigenous Voices Fighting Disinformation in the Andes and Amazon (also in Spanish)
Innovative Storytelling		Storyworks (Jenna Welch)Using Comics to Narrate Journalistic Investigations (Milagros Salazar Herrera)
Insights on Investigating China		Who Controls Anbang? (David Barboza) Jiangsu Hengrui Medicine		Interrogating China’s “Google Maps” to Investigate the Xinjiang Detention Centers (also in French, Indonesia, Bangla, Urdu)
Investigating Attacks on Journalists				How to Investigate Attacks on Journalists — and Make Them Backfire on Culpritsv
Investigating Elections
Investigating Inequality	Unequal Scenes (J Miller) Investigating inequality in the Brazilian Amazon (Elaíze Farias)	Unequal Scenes (J Miller)		Immersion and Imagery: Keys to Investigating Systemic Inequality
Investigations with Mapping & Satellite Imagery	Tip Sheet on Map Makoko (John Eromosele)	Mass Detention of Muslims in China (Alison Killing) About Cortina de Fumaça (Laura Kurtzberg) GeoJournalism (John Eromosele)	Resources for Finding and Using Satellite Images (also in Turkish, Portuguese, French, Bangla, Russian, Spanish, Hindi)	How to Expose Lies from the Skies Using Satellites and Drones
Investigative Podcasts		Investigative Podcasts in Mena (Ramsey Tesdell) How to Start Your Own Podcast (Taja Topolovec)		Investigative Audio: 8 Tips from Podcasting Innovators 7 Things I Learned Producing My First Investigative Podcast (also in Mandarin, Arabic, French, Portuguese, Russian, Spanish, Bangla) A Global Tour of Top Investigative Podcasts: The 2020 Edition (also in Spanish and Arabic)
Lightning Round: Great Stories You Can Do	“I Would Have Killed Her Anyway” (Savia Hasanova) Tipsheet for Stories about Land Grabbing (Naziha Syed Ali) Where is My Pension Tipsheet? (Luisa García Tellez)	Investigating Femicide (Nikolia Apostolou) A Few Great, Transferrable Stories From 2021 (Rowan Philp) Kloop’s Investigation of Femicide in Kyrgyzstan (Savia Hasanova) Greed Unlimited (Naziha Syed Ali) Where is My Pension? (Luisa García Tellez) Investigating US Right-wing ‘Dark Money’ Spent Around the World (Claire Provost)	A GIJN Guide: Investigating Femicide (also in Portuguese, Turkish, Arabic, Urdu)
Lightning Round: How They Did It	Your Right to Know (Donna Page) How I Did It Tips (Nanami Nakagawa) How I Did It Tips (Kevin Nguyen) Tipsheet for the Alliance for Journalists’ Freedom’s Press Freedom Tracker (Olivia Pirie-Griffiths)	Investigating Failures (Donna Page) How I Did It (Nanami Nakagawa)
Lightning Round: Great Tools for Investigators	Tools for Investigative Journalists (Lisseth Boon) Search Engines for “Open” Data of Ukraine and Kazakhstan(Dmytro Chaplynskyi) (Delphine Reuter and Soline Ledéser) CrowdNewsroom: the Tool for Crowdbased Investigations (Marc Engelhardt) Revealed: the neo-Nazis within the ranks of France’s armed forces (By Sébastien Bourdon, Justine Brabant, Matthieu Suc) Using the Facial Recognition Tool Findclone (Sébastien Bourdon) #MineAlert - Mapping South Africa’s Extractive Projects (Andiswa Matikinca)	ICIJ Tools: OffshoreLeaks Database, Datashare and Tarentula (Delphine Reuter & Soline Tools to Arrange, Analyze and Share Visualizations for Investigative Journalists (Lisseth Boon) Great Tools for Investigations: A few shared with GIJN this year (Rowan Philp) Making Open Data Usable (Dmytro Chaplynskyi) CrowdNewsroom: the Tool for Crowdbased Investigations (Marc Engelhardt)#MineAlert - Mapping South Africa’s Extractive Projects (Andiswa Matikinca) Three Ways OCCRP's ALEPH Can Make Your Life Easier My top 5 tools (Mohammed El-Haddad)
Making Sense of Afghanistan	Tips About Ghosts of Afghanistan Documentary (Julian Sher)	Ghosts of Afghanistan (Julian Sher)	Afghanistan: How to Help Journalists and Others at Risk (also in Dari, Pashtu, Turkish)	International Aid Needs to Step Up to Preserve Afghan Press
Online Search Secrets	How to Google More Effectively: The Basics (Paul Myers)
Pacific Plunder
Press Freedom in Asia				Curbing Asia’s Free Press: Propaganda Has Limits
The New Organized Crime			Investigating Organized Crime: A GIJN Guide Organized Crime Series: How to Investigate Money Laundering (Spanish, French, Russian, Turkish, Indonesia, Bangla, Hindi)	Understanding the Methods of Today’s Organized Crime Is Key to Exposing It
The Pandora Papers and Financial Crime	Investigating Offshore Trusts and The “enablers” of the Offshore Financial Industry (Scilla Alecci) How to Quickly Find Investigative Stories From a Leak of so Many Documents: The Case of the Pandora Papers (Purity Mukami)	Pandora Papers (Scilla Alecci) Finding Stories From Large Amount of Documents (Purity Mukami)		Lessons from the Pandora Papers: How to Investigate Financial Crime Stories
Tracking Wildlife Traffickers	Investigating Wildlife Trafficking in Asia (Jhesset Thrina Enano) Tips and Tools (Estacio Valoi) Checklist: Getting Started Reporting on the Wildlife trade (Rachael Bale)	Tracking Wildlife Traffickers in Asia (Jhesset Thrina Enano) WildEye: Mapping Illegal Wildlife Trade (Estacio Valoi) Tracking Wildlife Trafficking (Rachael Bale)	Wildlife Trafficking (short guide) Available in: English, Turkish, Spanish, Arabic, French. Wildlife Trafficking (long version)	Beyond Elephants and Rhinos: Tips For Covering Wildlife Trafficking What the Experts Say: Tips on Investigating Illegal Wildlife Trafficking
Visual Investigations: Using Thousands of Videos, and None	Visual Investigations Using Thousands of Videos, and None- The New York Times -Tipsheets (Malachy Browne, Anjali Singhvi, Muyi Xiao)	Visual Investigations (Malachy Browne, Anjali Singhvi, Muyi Xiao)		The Forensic Methods Reporters Are Using to Reveal Attacks by Security Forces (also in Arabic, Portuguese, Mandarin, Russian, Spanish, Bangla, French, Turkish)
Women and Investigative Journalism: Tips on Leadership	Women and Investigative Journalism: Tips on Leadership (Alaka, Damen, Lee, Manuli, Oldroyd, Walker) Women and Investigative Journalism: Tips on Leadership (Sherry Lee) Managing the Growth of An Organization (Rawan Damen)	Stories That Matter (Rachel Oldroyd) ARIJ's Growth (Rawan Damen) Leadership Tips (Marina Walker) Managing to Grow Female Leadership (Motunrayo Alaka)	GIJN Guide: Resources for Women Journalists (also in Portuguese, Spanish, Turkish)
Workshop: Bulletproofing Your Story	Guidelines for Mission Investigate (Nils Hanson)	Bulletproofing Your Story (Nils Hanson) Avoiding Lawsuits and Other Legal Dangers (Alinda Vermeer)	A Guide to Fact-Checking Investigative Stories (Also available in Portuguese, Spanish, Arabic, and Hindi)	Fact-checking & Verification (also in Russian and Hindi)
Workshop: Digital Security			Digital Security Guide (Portuguese, Spanish, Russian, Hindi, Bangla)
Workshop: Flight Tracking with Icarus			Flight Tracking Tipsheet (also in Spanish, Russian, Arabic, Bangla, Hindi, French)	Icarus Flights: The Powerful New Flight Tracking Tool
Workshop: Online Search Secrets
Workshop: Physical Security		Newsroom Safety (Drew Sullivan & Stevan Dojcinovic)	Safety and Security (also in Spanish and Arabic)
Workshop: Protecting Sources	Getting Information From Other People (Jason Reich)			How Journalists Can Protect Whistleblowers Making “First Contact” As Governments Attack the Media, Reporters Must Consider Their Responsibility to Protect Sources A Journalist’s Guide to Avoiding Lawsuits and Other Legal Dangers (also in Arabic, Indonesia, Turkish, French, Spanish)
Workshop: The Journalist Security Assessment Tool		The Journalist Security Assessment Tool (Runa Sandvik, Matt Hansen, and Matt Mitchell)	Online Advanced Search (also in Hindi, Indonesia) Online Research Tools Guide (also in Turkish, Arabic, Bangla, Spanish, French, Indonesia)	GIJN Launches Journalism Security Assessment Tool
Workshop: Who/What Is in That Video?		What What Is in That Video (Henk Van Ess)	Henk van Ess on Visual Thinking for Online Investigations (also in Mandarin, Russian, Arabic, Bangla) Tips for Mining Social Media Platforms with Henk van Ess (also available in Russian)
Testing & Tracking	Tracking Used and Returned Clothes (Minna Knus-Galán & Jessica Stolzmann)	Investigating Fast Fashion with GPS Trackers (Minna Knus-Galán & Jessica Stolzmann) How to Work with Scientists on Environmental Investigations (Martin Boudot) Saltwater Puts Women's Health At Risk in Bangladesh (Abu Siddique)

Data Sessions

Session Name	Tipsheets	Presentations	GIJN's Guide or Tipsheet
Data Analysis Through Visualization		Using Visualizations for Data-driven Investigations (Alastair Otter & Jennifer LaFleur)	Visualizing Data (also in Turkish) Visualization Tools
Data Journalism: Where We've Been, Where We're Headed		Data Journalism in Asia Trends and What’s Next (Kuek Ser Kuang Keng) In Data Journalism Investigations Latin America (Giannina Segnini) Data Journalism Trends in North America and Europe (Jennifer LaFleur )	Data Journalism Guide
Data: Free Google Tools for Investigations		Free Google Tools for Investigations (Mike Reilley)
Data: Joining Tables with SQL	SQL – Exploring Data (Helena Bengtsson Tipsheet)		Analyzing Data - SQL (also in Turkish)
Data: What Is Python & Why Use It?		What is Python and why use it (Winny de Jong)	Analyzing Data - Python (also in Turkish)
Mapping With Tableau		Mapping (Pınar Dağ)	Mapping (also in Turkish)
Networks, Clusters, Influencers: Social Network Analysis with NodeXL Pro		Social Network Analysis with NodeXL (Harald Meier)
Spreadsheets — Averages, Medians, Percents, Ratios			Analyzing Data - Spreadsheets (also in Turkish)
Spreadsheets — The Power of Sorting, Filtering and the Pivot Table		Sorting in Excel (Sanjit Oberai) Andrew Lehren's Files	Analyzing Data - Spreadsheets (also in Turkish)
Summarizing with SQL
Tools to Clean Data	OpenRefine (Nils Mulvad) OpenRefineData (Nils Mulvad)
What is R and Why Use It		What is R and Why Should I use It? (Sarah Cohen)
Web Scraping Made Easier	Start with Web Scraper (Nils Mulvad & Tommy Kaas)

This work is licensed under a Creative Commons Attribution-NoDerivatives 4.0 International License

Republish our articles for free, online or in print, under a Creative Commons license.

Republish this article

This work is licensed under a Creative Commons Attribution-NoDerivatives 4.0 International License

Material from GIJN’s website is generally available for republication under a Creative Commons Attribution-NonCommercial 4.0 International license. Images usually are published under a different license, so we advise you to use alternatives or contact us regarding permission. Here are our full terms for republication. You must credit the author, link to the original story, and name GIJN as the first publisher. For any queries or to send us a courtesy republication note, write to hello@gijn.org.

<h2>GIJC21 Resources</h2> September 28, 2021 <a href="https://gijn.org/wp-content/uploads/2021/08/GIJC21-2-1.jpg"><img class="alignright size-medium wp-image-365235" src="https://gijn.org/wp-content/uploads/2021/08/GIJC21-2-1-336x76.jpg" alt="" width="336" height="76"></a>Conference resources will be uploaded and organized here by topic. We've added here additional reports from the <a href="https://helpdesk.gijn.org/support/home">GIJN Resource Center</a>, which attendees may find useful.Have a tipsheet or slides for your session at GIJC21? <a href="mailto:speakers@gijn.org">Send us a copy here</a> and we&rsquo;ll post it.<a href="https://docs.google.com/a/gijn.org/spreadsheet/ccc?key=0AgQLiJxX1CGgdG9nSVVlem1fd21jcFczdFR3XzBadXc#gid=0">&nbsp;</a>&nbsp;Data Sessions
	This <a target="_blank" href="https://gijn.org/stories/gijc21-resources/">article</a> first appeared on <a target="_blank" href="https://gijn.org">Global Investigative Journalism Network</a> and is republished here under a Creative Commons license.
	<img id="republication-tracker-tool-source" src="https://gijn.org/?republication-pixel=true&amp;post=657947&amp;ga=UA-21528033-17">

Tips to Guide Investigative Journalists in Document Text Analysis

by Patrick Egwu • November 30, 2023

Investigative journalists often face the challenge of reviewing and combining large documents or data in text forms. This can be very exhausting and labor intensive.

Case Studies GIJC23

GIJN’s Top 10 Stories of 2023

by Rowan Philp • November 29, 2023

A curated list of 10 notable GIJN articles from this past year — a mix of our most popular stories, great reads, data journalism best practices, game-changing reporting tips, and panel takeaways.

OCCRP's Jan Strozyk Working with Hackers GIJC23 panel

GIJC23 Reporting Tools & Tips

Working With Hackers: Where — and How — Journalists Should Use These Sources

by Rowan Philp • November 28, 2023

The use of hacked data is a growing ethical challenge for investigative journalists. But responsible use of this information can lead to public interest revelations that would otherwise stay hidden.

Reporting Tools & Tips

GIJN’s Top 10 Investigative Tools of 2023

by Rowan Philp • November 27, 2023

Having flagged the top tips at conferences like the NICAR23, IRE23, and GIJC23 in Sweden, GIJN offers the following 10 user-friendly tools that you might consider in your next investigations.

Accessibility Settings

text size

color options

reading tools

other

Stories

GIJC21 Resources

Republish this article

Read Next

Data Journalism GIJC23 Reporting Tools & Tips

Tips to Guide Investigative Journalists in Document Text Analysis

Case Studies GIJC23

GIJN’s Top 10 Stories of 2023

GIJC23 Reporting Tools & Tips

Working With Hackers: Where — and How — Journalists Should Use These Sources

Reporting Tools & Tips

GIJN’s Top 10 Investigative Tools of 2023

Stories

GIJC21 Resources

Share

Related Resources

Tipsheet for Investigative Journalists on War Crimes and Open Source Research

Tipsheet for Investigative Journalists on War Crimes and Attacks on Civilians

No Coding Required: A Step-by-Step Guide to Scraping Websites With Data Miner

Tipsheet for Investigative Journalists on War Crimes and What Is Legal in War

Related Resources

Tipsheet for Investigative Journalists on War Crimes and Open Source Research

Tipsheet for Investigative Journalists on War Crimes and Attacks on Civilians

No Coding Required: A Step-by-Step Guide to Scraping Websites With Data Miner

Tipsheet for Investigative Journalists on War Crimes and What Is Legal in War

Related Stories

Tips to Guide Investigative Journalists in Document Text Analysis

GIJN’s Top 10 Stories of 2023

Working With Hackers: Where — and How — Journalists Should Use These Sources

GIJN’s Top 10 Investigative Tools of 2023

Republish this article

Read Next

Data Journalism GIJC23 Reporting Tools & Tips

Tips to Guide Investigative Journalists in Document Text Analysis

Case Studies GIJC23

GIJN’s Top 10 Stories of 2023

GIJC23 Reporting Tools & Tips

Working With Hackers: Where — and How — Journalists Should Use These Sources

Reporting Tools & Tips

GIJN’s Top 10 Investigative Tools of 2023