Udgivelse i forbindelse med Den digitale Graverskole 2019

På Den digitale Graverskole 2019 har vi prøvet at tilrettelægge et program, der kommer rundt omkring de digitale, journalistiske processer, studerende kan møde. Graverskolen har derfor udviklet deltagernes digitale og visuelle egenskaber, som der er kommet disse udgivelser ud af.

Ekstra Bladet: Afsløring: Her er frimurernes optagelsesritual

En af vores seje deltagere på den digitale graverskole 2019 Andreas Wentoft har fået publiceret en vild graverhistorie om de danske frimurer, som er en loge, der har eksisteret siden 1743, og hvor flere danske konger har været leder af logen. Afsløringen er blevet lavet i samarbejde med os. Andreas fortæller selv:

“Graverskolen har virkelig inspireret mig i forhold til forskellige måder at fortælle en historie. Det har jeg helt klart brugt til at formidle frimurernes optagelsesritual.”

Zetland: Er det bedst bare at glemme de 110 tons gift, der ligger begravet på stranden?

Den Digitale Graverskole 19 har også arbejdet med lange, digitale fortællinger. Det har en af vores deltager Ida Maria Kristensen taget til sig, da hun lavede en fantastisk historie om et giftdepot, som påvirker et helt lokalområde, men som ingen vil tage ansvar for at fjerne. Ida fortæller selv:

“Det var især det fortællende element, graverskolen har været med til at inspirere mig med. Jeg har både trukket på besøget af den internationale underviser Mark Kramer, og det at sætte en digital fortælling op, som vi har fået hjælp af Rasmus Fahrendorff, til at få den her fortælling hjem.”

Berlingske: To år efter Kundby-pigen blev dømt, er hun tilbage i rampelyset: »Vi viser en person, som virkelig er i lort op til halsen«

Deltagerne på Den digitale Graverskole har også fået undersøgende værktøjer med hjem. Peter Thomsen tog meget hurtigt dette til sig, da han sideløbende med en af skolens kursusdage om research på sociale medier, arbejdede med en artikel om de etiske dilemmaer ved at lave teater om den terrordømte Kundby-pige til Berlingske. Peter Thomsen fortæller:

“Forud for undervisningen havde jeg allerede brugt et par timer på at finde en helt central person i forløbet, som havde ændret navn på sociale medier efter terrorsagen, men uden held. Efter den éne kursusdag, fandt jeg en central personen på fem minutter . Det understreger i virkeligheden, hvor hurtigt man kan omsætte graverskolens undervisning til noget brugbart.”

Denne side bliver løbende opdateret.

An OSINT guide for military research

By Daniel Oxholm

This is the first blogpost from NOIR and is made as a response to the first @Quiztime quiz I made some weeks ago. The quiz was about a danish CV90 on a lorry going west toward ‘Antvorskov Kaserne’ close to Slagelse. 

@Nixintel solved this quiz brilliantly and wrote a blog post that I recommend reading:

In this blog, I will give tips regarding methods to find military logos and camouflage, military vehicles, military airplanes, weapon and short about finding the military locations.

Military logos

The logo of the British Armed Forces

Firstly, Google is very helpful to find the right troops logo that you are searching for. It might take time if you are looking for small military troops, but still, this should be possible.

Try searching for some different troops like English troops, which might lead you to a page like this one, which will show you many different options for your logo. 

If you already have an image of the logo that you are searching for, then you should go for a “reverse image search” on both Yandex, Google and Bing. Rule: Always check all the different search tools, which are available to you, it will increase your chance of getting more results.

If you are trying to find a specific type of camouflage and figure out which troop it belongs to, the page camopedia, is a good place to start.

Military vehicles recognition

Photo: Daniel Oxholm

Type of vehicle: You can do a reverse image search if you have an image of the vehicle. 

Make sure that you are looking at the right model and not an old model of the same vehicle. See, for example, this site, on licenses plate of the world

If you are trying to find a specific vehicle, then make sure that you get all of its unique characteristics; damages that have been done to the vehicle, unique logos, licence plate, numbers and camouflage layout. A good case to understand this is M17 by Bellingcat. See the article about this case here.

Military Airplanes

U.S. Air Force photo by Senior Airman Kayla Newman – https://www.dvidshub.net/image/2323414/1st-fighter-wing-hosts-coalition-aerial-exercise#

Airplane spotters: 

Try looking or asking for aviation spotters in the country or state, that you are doing your research in. Here are some examples. 

Airplane tracking:

The main source for tracking airplanes is the online websites with overviews of airplanes movement. Global Investigative Journalism Network (GIJN) has made a very useful guide of how to use these websites – read this guide carefully!

Examples of websites to use are:

Military weapons

https://www.turkiyeegitim.com/cudi-daginda-3-terorist-olduruldu-3135g-p13.htm

I have not worked with this, but I think that Elliots (founder of Bellingcat) approach when he began his Brown Moses blog is still valid. Find and ask around until you get to know what you are looking at.

Another good source would be to follow @CalibreObscura and other arms researchers on Twitter. And remember to ask about weapons that you either don’t know or don’t understand!

Finding military locations

Screenshot: Interface from Mapillary, Image by Axel Pettersson

The method to find a specific location is mostly a mix of satellite images and maps. The two main sources are google maps, google earth, if you are without a budget – another good interactive map is Mapillary. When it has to do with military it is always good to consider what the strategy for a group or person in the image is, because this might tell you where they are, where they might have come from and the direction that they are heading. In the quiz about a danish CV90, the direction of the vehicle and the shadows of the vehicle, helped Nixintel find the E20 highway that is the only one running East-West in Denmark.

Dette blogindlæg er kun på engelsk, da NOIR er et internationalt netværk. 

#EIJC19/Dataharvest Day 2 – storytelling and big data

By Jannie Møller Hartley

Miranda Patrucic is the regional editor of OCCRP Sarajevo. In the afternoon of the second day, she gives her best advice on how to think about story-telling in stories based on large amount of data.

Miranda’s six ways of turning data-stories into real stories, that people want to read even if they are heavy with data.

  1. Organisation: “Preparing to write from the moment, I start reporting.”
  2. Structure: “Journalists are bad at structuring, but I use it to give my writing a backbone.”
  3. Clarity and simplicity: “You want to make the complex simple.”
  4. Voice and authority: “When you don’t have what you need, you write around it. But instead, use the writing to find the missing pieces.”
  5. Use fictional techniques in non-fiction
  6. Multimedia, digital and alternative forms of story-telling: “You don’t need all the details in your story or the whole research, pick out the bits you need to tell the story, some research might be better in a graph, that you present on a separate website”.

As an editor, Miranda has learned the hard way, that it’s important to force the journalists to think about the pitch of their story before starting. Too many stories are relevant but seem irrelevant or too complicated for users. Too few journalists ask the “so what question,” she argues.

“Think about why is my story important, who should people care about this?”

For Miranda a timeline is one of the most useful tools in her storytelling process:

“Once you have started, you should do a timeline, who are the central people, dates, important events and it gives and overview of the connections.”

A timeline is useful because it allows you to see the bigger picture in all the data, and it guides you towards the interviews and observations. But even then, when interviews are done, journalists need to ask themselves, what is the story here and then do more research.

“Think about the questions that arise out of the interviews and talk to the editors, or other trusted people.”

But even then, don’t start writing. Instead, Miranda says, start reading through everything. Find the quotes.

“What are the three major points, you want to make in your story.”

Finally, she notes four questions, you should always ask yourself as a storytelling journalist:

  • What is the purpose of this story?
  • What is the relevance to the reader?
  • How big IS the problem?
  • What are the competing interests involved?


Dette blogpost er kun på engelsk. 

Day two of #EIJC19 – advanced social media and information research

By Katrine Juel Friis

The day began with BBC research specialist, Paul Myers, tools for a structured researched on Social Media and shortcuts for information.

Therefore, CUJ wants to share some of them.

  1. Firstly, Facebook’s search box is not very efficient, so Paul Myers gave some different ways to search for persons on Facebook. The website findmyfbid.com helps you find a Facebook pages’ unique ID-number, which you then enter like this: Facebook.com/search/[ID-number]. See guide here, and also learn different customised sample searches.
  2. Another website is peoplefindThor.com, but be careful with this, because it searches everything in the searched word.
  3. Paul Myers also showed how powerful the Facebook Graph search generator stalkscan.com is. Try it out!
  4. The website archive.is is good for finding past social media pages both on Facebook and Twitter, when looking for deleted social media accounts.
  5. For analysing a particular Twitter account followerwonk.com and tweepsept.com are efficient tools.
  6. Paul Myers also gave some advice on the research method ‘Reversed Images’. This is a method to search on specific locations of an image on google search. For example, you can have a photo of the person you want to research, with a hotel logo in the background, BUT not the hotel’s name. You can find the hotels name by Google search. But first you have to crop the photo to only the logo, and then you search on google pictures.
  7. Another tool for this is Yandex – which you can also get as a plugin. It can do some of the same as Google search, but however, it also has facial recognition.
  8. And then to the scary part. Because you can upload a photo on http://exif.regex.info/exif.cgi, and then it can display the photo’s metadata and geolocation. Then you can click on this, and go to google maps where you can use street view, to see if the picture has the same backgrounds as street view. 
  9. To find someone’s location, you can also create a fake link on IPlogger.com.
  10. If you want to find the domain for a website, go to either who.isdomainbigdata.com – where you can search on a specific name -and domaintools.com.
  11. If you, for example, have someones email-address you can look it up at pipl.com, which is an amazing database of peoples data. 
  12. And a scarily good way to track a location via a persons mobile phone is the website hlr-lookups.com.

There are more tools and methods on this page.

Dette blogindlæg er kun på engelsk. 

CUJ at #EIJC19 – curious noses digging into air quality

By Jannie Møller Hartley

In the afternoon we heard Ine Renson from the Belgium newspaper De Standaard presenting her experiences of how to include readers into your investigations. The project was to measure NO2 – a parameter of air quality (mainly traffic pollution, especially from diesel cars). They were able to show that pollution was linked to how the road was designed and street canyon effect, or if you have wind blowing in from the side. This made the air pollution dramatically different in places that were geographically close to each other. Here is what they went through – step by step:

1) The goal was to cover and collect data on pollution from the whole region – and the university (Antwerp) did the analysis of the data. People contributed by collecting data from outside their homes.

2) The journalist used this data and made an interactive tool, where you could zoom in and look at the results where they live, they named it “The biggest reality check ever”. Launching it as a huge campaign it had to become famous among a lot of people.

3) “It started with a special report on air quality – but we asked: how bad is it really? The measurement stations were placed in places, where people don’t live. Then we thought: There is no data, so we have to just find and collect the data”

4) They had no script, and they had to invent it as they went along. They found partners and collaborated with public officials and the University

5) “It was super expensive and complicated, we needed 20.000 entry points spread out over the country.”

6) “We had to make signs, manuals, deliver test tubes during a certain temperature, and you have NO guarantee of success. 96 percent of the data entries were valid.”

7) They have all the data on the website, and they published the stories over 16 pages in the newspaper.

Dette blogindlæg er kun på engelsk. 

#Dataharvest/EIJC19 day one – Digital security in cross-border investigation

By Katrine Juel Friis 

After lunch, Tech & data team leader at CORRECTIV Anne-Lise Bouyer, Chief Technology Officer at ICIJ Pierre Romera and Tech Coordinator at OCCRP Friedrich Lindenberg give tips for how to secure your cross-border investigation.

Digital security is very important in cross-border collaborations, but there are different tools and process’ to approach this. Firstly, you need to take into account the level of security needed in the communication and the level of tech-experience within the cross-border group. Secondly, it is important to use a secure team chat software, where the panel takes the website Slack as an example.

When communicating with each other on a daily basis, Facebook is a no go. Instead, the panel recommended Signal, Whatsapp and Telegram.

Pierre also underlined that ICIJ is there to help you: “Another way to secure yourself and your partners are to come to us.” International Consortium of Investigative Journalists (ICIJ) is an organisation and a global network of reporters and media organizations.

The panel was asked if they ever compromised with security in their work, where Pierre Romera then says:

“Some of our new colleagues received a fake invitation-mail the day they arrived at ICIJ. That was a big problem for us, and very difficult to handle.”

However, if you suddenly end up having not secured for example your data, it is very useful to have made an emergency guide explaining what to do in these kinds of situations.

Friedrich Lindenberg ended the panel session on a happy note with a smile on the face by saying:

“If you want to be totally secure, don’t be an investigative reporter. There is always a risk.”

Dette blogindlæg er kun på engelsk. 

#Dataharvest/EIJC19 day one – exploring Networks with Graph Database

By Katrine Juel Friis 

The investigative and data journalist at Financial Times, Leila Haddou, started the day by guiding us through the program for graph database Neo4j.

It is a very useful tool to find connections or patterns within data. This has for example been used in the paradise papers investigations. It gives you a good overview of huge networks for example between politicians and donators.

You can find the slides and guide for building a database here.

Dette blogpost er kun på engelsk. 

#Dataharvest/EIJC19 day one – how to get started as a data-journalist

By Jannie Møller Hartley

On this first panel of the #EIJC19 the 3 panellists give great advice on how to get started with data-journalism.

The first speaker Carmen Arguilar Carcia, data journalist at Sky News, explains how data adds value to stories. For example, she says “data can make quite simple stories more illustrative for the users.” For example she did a story on which MP’s changed their minds to Brexit.

The second thing data is good for, she says, is that you can use it for hypothesis testing. For example, if you have a feeling that Oscar winners are mostly men and that women are older when they win. For Carmen this became the project of “The anatomy of Oscars Winners”, which was good for testing and proving this hypothesis.

Finally, Carmen points out, that data can give context to the stories, and data can be used to estimate the size of the problem. This she used, for example in a story mapping crime rates in the UK.

Next on the panel is Brant Houston, who has been teaching data journalism for years and worked on data journalism primarily in the US. His first important advice is: “Remember multi-sourcing of data sets, do the stories on at least 3 data- sets, they give you different viewpoints of the story. And you still need to interview and observe,” Brant Houston says.

Furthermore, Houston points out, start simple, use a small dataset and a dataset that has been used before. This is to avoid having to do too much cleaning, which he describes as “the most boring part of data-journalism”.

Next up is Nils Mulvad, who is co-founder of the Global Network for Investigative Journalism and other international networks such as Farmsubsidy.org.

Nils starts off by emphasising the problem with data journalism and investigative journalists working in silos.

“But imagine if we went 100 years back and someone said, hey I’m good at using the phone, I can do all the phone interviews! Data journalists need to think in journalistic terms and the journalist need to understand data,” Nils Mulvad emphasises.

For Nils it’s all about asking the simple question. For example, in the work he has done for Greenpeace, they simply asked: How big a part of European subsidies are going to life stock?

“The EU was saying that this was not much, but by putting data on what land is used for together with how much of this is subsidised we were able to show that 70 percent of all subsidies were going to livestock.” This amounted to a fifth of the EU budget – more than £24bn of taxpayer money going to support livestock farming across Europe.

Perhaps more surprisingly, Mulvad towards the end adviced the room to not fill your story with data, but instead find the people in the data, and he warns that beginners in data journalism tend to fill their stories with boring data.

“Find the people in the stories and tell the stories through them, rather than through the data,” he said.

Dette blogpost er kun på engelsk.

Vil du gerne på digital graverskole?

Så giver CUJ i samarbejde med Foreningen for Undersøgende Journalistik (FUJ) dig en enestående mulighed for det, når du kan komme med på ‘Den digitale Graverskole’ til efteråret 2019. For at komme i betragtning til en plads skal du gå på en af journalistuddannelserne på SDU (Center for Journalistik), DMJX (Danmarks Medie- og Journalisthøjskole eller RUC (Journalistik – Roskilde Universitet) og have endt praktik ved graverskolens start eller havde været nyuddannet journalist fra en af skolerne i max et år ved graverskolens start. OBS: DEADLINE FOR AT INDSENDE PITCH ER RYKKET TIL D. 22 JUNI 2019. Læs mere her:

Kom og hør instruktøren bag prisvindende dokumentar

Vil du gerne høre mere om udformningen af årets dokumentar ‘Mændene der plyndrede Europa’? Vil du gerne lære mere om visuelle fortællinger inden for journalistikkens verden?

Så gæster den prisvindende DR-journalist og instruktør, Mads Ellesøe, Roskilde Universitet. Kom og hør, hvordan han formåede at formidle et så svært stof, som svindel med udbytteskat, så helt almindelige danskere forstod det.

Det foregår i lokale 42.2.37 på Roskilde Universitet. Læs mere her.

Du kan se hele dokumentaren her.