Making video and audio interviews searchable: how Pinpoint helped with one investigation

Pinpoint creates a ranking of people, organisations, and locations with the number of times they are mentioned on your uploaded documents.

MA Data Journalism student Tony Jarne spent eight months investigating exempt accommodation, collecting hundreds of documents, audio and video recordings along the way. To manage all this information, he turned to Google’s free tool Pinpoint. In a special guest post for OJB, he explains how it should be an essential part of any journalist’s toolkit.

The use of exempt accommodation — a type of housing for vulnerable people — has rocketed in recent years.

At the end of December, a select committee was set up in Parliament to look into the issue. The select committee opened a deadline, and anyone who wished to do so could submit written evidence.

Organisations, local authorities and citizens submitted more than 125 pieces of written evidence to be taken into account by the committee. Some are only one page — others are 25 pages long.

In addition to the written evidence, I had various reports, news articles, Land Registry titles an company accounts downloaded from Companies House.

I needed a tool to organise all the documentation. I needed Pinpoint

A search engine for files (including multimedia and scanned PDFs)

Pinpoint is a Google tool designed for journalists. It allows you to organise information efficiently and quickly, in a way that has been very useful in writing my stories.

It is straightforward and intuitive. If you have used Google products, the design is very similar (I often had the feeling that I was using Gmail or Google Drive).

When you upload documents to a Pinpoint project, it identifies any people, organisations or places that are named (a process called entity extraction) — providing a ranking by frequency as part of the interface.

Clicking on the name of any of those organisations locations or people takes you to every mention of that entity in the documents.

It will even do this with scanned PDFs: the tool uses optical character recognition (OCR) to make them searchable.

Organising your files in Pinpoint

You can see all the labels I created for my investigation on the right. In the middle, all the documents with different labels and colours.

When you add a document, I recommend first giving it a title that will help you label and recognise it later. It will take more time, but if you are going to work and analyse the whole database, organising and titling files now will save you problems in the future.

To organise information, I used labels. Labelling every document allowed me to easily find and collect the information I found in the documents I wanted. 

Pinpoint allows you to search within the entire document base you have created, or search within those that have a particular tag.

The tool also allows you to underline texts and create a link to a document section so that you can go straight to it.

For my investigation, for example, I created a master file in which I added links to the most interesting parts of my background research. Gathering the information to write my articles was much quicker as a result.

Audio and video is searchable too

Transcription of conversation. Pinpoint transcribes and minutes your interviews. You can see every minute and the transcription. Unfortunately, the application does not distinguish between different voices.

Pinpoint also allows you to transcribe conversations: upload a video or audio file, and the tool creates a PDF with a timestamped transcription of the conversation. 

It is not the best application for transcriptions, but it can be useful to scan-read different parts of the interview if it has been very long — and most of all, it adds it to the information that you can search and link to.

Drawbacks and comparisons with Document Cloud

The tool also has its disadvantages. Perhaps the main one is that it is not possible to share files with others.

This can be a problem if you are collaborating on a project, or plan to involve others in future. When I wanted to share something, I used another similar tool created by journalists: DocumentCloud.

DocumentCloud has similar entity extraction, OCR and annotation functionality, and is particularly good for embedding documents in articles too — I uploaded the documents to this programme so the other person could see them.

It is a tool I would recommend for more experienced journalists: it offers a lot of possibilities and allows you to share information. It’s not quite as easy to use as Pinpoint, but you can always try both and choose the one you like the most.

Google Pinpoint also has space limitations. My project involved no more than 500 MB of documents, but if you have several gigabytes of material, you may have to create another Google account or pay for more space. 

As it is a tool that stores everything in the cloud, you need to be connected all the time. To avoid this inconvenience, I kept a copy of the documents on my computer and used my notebooks to write down the most important things. 

But Pinpoint has been an essential tool. If you are going to do research, whether as a journalist or an academic, it allows you to organise information in a very intuitive way and will save you hours of time in the long run.

Advertisement

2 thoughts on “Making video and audio interviews searchable: how Pinpoint helped with one investigation

  1. Trudy Beerman

    Thank you for sharing this. I am a doctoral student getting ready to do my observations for research, and keeping track of everything might be easier with this system you described. I have bookmarked it to dig in deeper later.

    Reply
  2. jarnavic Post author

    I hope Pinpoint is useful for your PhD, Trudy. It helped me a lot, and I can only recommend you. It is specifically designed for journalists, but I think that everybody that is researching or investigating should find it helpful.

    Reply

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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

This site uses Akismet to reduce spam. Learn how your comment data is processed.