Entity Extraction, Document Processing, And Knowledge Graphs For Investigative Journalists with Friedrich Lindenberg
Published: 2018-11-20 03:16:58

---
title: Entity Extraction, Document Processing, And Knowledge Graphs For Investigative Journalists with Friedrich Lindenberg
published: true
tags: 
canonical_url: 
---

### Summary

Investigative reporters have a challenging task of identifying complex networks of people, places, and events gleaned from a mixed collection of sources. Turning those various documents, electronic records, and research into a searchable and actionable collection of facts is an interesting and difficult technical challenge. Friedrich Lindenberg created the Aleph project to address this issue and in this episode he explains how it works, why he built it, and how it is being used. He also discusses his hopes for the future of the project and other ways that the system could be used.

### Preface

- Hello and welcome to Podcast.\_\_init\_\_, the podcast about Python and the people who make it great.
- When you’re ready to launch your next app or want to try a project you hear about on the show, you’ll need somewhere to deploy it, so check out Linode. With 200 Gbit/s private networking, scalable shared block storage, node balancers, and a 40 Gbit/s public network, all controlled by a brand new API you’ve got everything you need to scale up. Go to [podcastinit.com/linode](https://www.podcastinit.com/linode?utm_source=rss&utm_medium=rss) today to get a $20 credit and launch a new server in under a minute.
- Visit the [site](https://www.podcastinit.com?utm_source=rss&utm_medium=rss) to subscribe to the show, sign up for the newsletter, and read the show notes. And if you have any questions, comments, or suggestions I would love to hear them. You can reach me on Twitter at [@Podcast\_\_init\_\_](https://twtiter.com/podcastinit?utm_source=rss&utm_medium=rss) or email [hosts@podcastinit.com](mailto:hosts@podcastinit.com))
- To help other people find the show please leave a review on [iTunes](https://itunes.apple.com/us/podcast/podcast.-init/id981834425?mt=2&uo=6&at=&ct=&utm_source=rss&utm_medium=rss), or [Google Play Music](https://play.google.com/music/m/I7ogju4xv6adasgqz6545jndgsy?t=Podcastinit_-_Python_and_the_people_who_make_it_great&utm_source=rss&utm_medium=rss), tell your friends and co-workers, and share it on social media.
- Join the community in the new Zulip chat workspace at [podcastinit.com/chat](https://www.podcastinit.com/chat?utm_source=rss&utm_medium=rss)
- Registration for [PyCon US](https://us.pycon.org/2019/registration/?utm_source=rss&utm_medium=rss), the largest annual gathering across the community, is open now. Don’t forget to get your ticket and I’ll see you there!
- Your host as usual is Tobias Macey and today I’m interviewing Friedrich Lindenberg about Aleph, a tool to perform entity extraction across documents and structured data

### Interview

- Introductions
- How did you get introduced to Python?
- Can you start by explaining what Aleph is and how the project got started?
- What is investigative journalism?
  - How does Aleph fit into their workflow?
  - What are some other tools that would be used alongside Aleph?
  - What are some ways that Aleph could be useful outside of investigative journalism?
- How is Aleph architected and how has it evolved since you first started working on it?
- What are the major components of Aleph?
  - What are the types of documents and data formats that Aleph supports?
- Can you describe the steps involved in entity extraction?
  - What are the most challenging aspects of identifying and resolving entities in the documents stored in Aleph?
- Can you describe the flow of data through the system from a document being uploaded through to it being displayed as part of a search query?
- What is involved in deploying and managing an installation of Aleph?
- What have been some of the most interesting or unexpected aspects of building Aleph?
- Are there any particularly noteworthy uses of Aleph that you are aware of?
- What are your plans for the future of Aleph?

### Keep In Touch

- [Website](http://pudo.org/?utm_source=rss&utm_medium=rss)
- [@pudo](https://twitter.com/pudo?utm_source=rss&utm_medium=rss) on Twitter
- [pudo](https://github.com/pudo?utm_source=rss&utm_medium=rss) on GitHub

### Picks

- Tobias
  - [Mechanical Soup](https://mechanicalsoup.readthedocs.io/en/stable/?utm_source=rss&utm_medium=rss)
- Friedrich
  - [phonenumbers](https://github.com/daviddrysdale/python-phonenumbers?utm_source=rss&utm_medium=rss) – because it’s useful
  - [pyicu](https://github.com/ovalhub/pyicu?utm_source=rss&utm_medium=rss) – super nerdy but amazing 
  - [sqlalchemy](https://www.sqlalchemy.org/?utm_source=rss&utm_medium=rss) – my all-time favorite python package

### Links

- [Aleph](https://github.com/alephdata/aleph?utm_source=rss&utm_medium=rss)
- [Organized Crime and Corruption Reporting Project](https://github.com/pudo?utm_source=rss&utm_medium=rss)
- [OCR (Optical Character Recognition)](https://en.wikipedia.org/wiki/Optical_character_recognition?utm_source=rss&utm_medium=rss)
- [Jorge Luis Borges](https://en.wikipedia.org/wiki/Jorge_Luis_Borges?utm_source=rss&utm_medium=rss)
- [Buenos Aires](https://en.wikipedia.org/wiki/Buenos_Aires?utm_source=rss&utm_medium=rss)
- [Investigative Journalism](https://en.wikipedia.org/wiki/Investigative_journalism?utm_source=rss&utm_medium=rss)
- [Azerbaijan](https://en.wikipedia.org/wiki/Azerbaijan?utm_source=rss&utm_medium=rss)
- [Signal](https://signal.org/?utm_source=rss&utm_medium=rss)
- [Open Corporates](https://opencorporates.com/?utm_source=rss&utm_medium=rss)
- [Open Refine](http://openrefine.org/?utm_source=rss&utm_medium=rss)
- [Money Laundering](https://en.wikipedia.org/wiki/Money_laundering?utm_source=rss&utm_medium=rss)
- [E-Discovery](https://en.wikipedia.org/wiki/Electronic_discovery?utm_source=rss&utm_medium=rss)
- [CSV](https://en.wikipedia.org/wiki/Comma-separated_values?utm_source=rss&utm_medium=rss)
- [SQL](https://en.wikipedia.org/wiki/SQL?utm_source=rss&utm_medium=rss)
- [Entity Extraction (Named Entity Recognition)](https://en.wikipedia.org/wiki/Named-entity_recognition?utm_source=rss&utm_medium=rss)
- [Apache Tika](https://tika.apache.org/?utm_source=rss&utm_medium=rss)
- [Polyglot](https://polyglot.readthedocs.io/en/latest/?utm_source=rss&utm_medium=rss)
- [SpaCy](https://spacy.io/?utm_source=rss&utm_medium=rss)
  - [Podcast.\_\_init\_\_ Episode](https://www.podcastinit.com/episode-87-spacy-with-matthew-honnibal/?utm_source=rss&utm_medium=rss)
- [LibreOffice](https://www.libreoffice.org/?utm_source=rss&utm_medium=rss)
- [Tesseract](https://github.com/tesseract-ocr/tesseract?utm_source=rss&utm_medium=rss)
- [followthemoney](https://alephdata.github.io/followthemoney/?utm_source=rss&utm_medium=rss)
- [Elasticsearch](https://www.elastic.co/products/elasticsearch?utm_source=rss&utm_medium=rss)
- [Knowledge Graph](https://en.wikipedia.org/wiki/Knowledge_Graph?utm_source=rss&utm_medium=rss)
- [Neo4J](https://neo4j.com/?utm_source=rss&utm_medium=rss)
- [Gephi](https://gephi.org/?utm_source=rss&utm_medium=rss)
- [Edward Snowden](https://en.wikipedia.org/wiki/Edward_Snowden?utm_source=rss&utm_medium=rss)
- [Document Cloud](https://www.documentcloud.org/?utm_source=rss&utm_medium=rss)
- [Overview Project](https://www.overviewdocs.com/?utm_source=rss&utm_medium=rss)
- [Veracrypt](https://www.veracrypt.fr/en/Home.html?utm_source=rss&utm_medium=rss)
- [Qubes OS](https://www.qubes-os.org/?utm_source=rss&utm_medium=rss)
- [I2 Analyst Notebook](https://www.ibm.com/us-en/marketplace/analysts-notebook?utm_source=rss&utm_medium=rss)

The intro and outro music is from Requiem for a Fish [The Freak Fandango Orchestra](http://freemusicarchive.org/music/The_Freak_Fandango_Orchestra/?utm_source=rss&utm_medium=rss) / [CC BY-SA](http://creativecommons.org/licenses/by-sa/3.0/?utm_source=rss&utm_medium=rss)

 ![](https://piwik.boundlessnotions.com/piwik.php?idsite=1&rec=1&url=https%3A%2F%2Fwww.podcastinit.com%2Faleph-with-friedrich-lindenberg-episode-186%2F&action_name=Entity+Extraction%2C+Document+Processing%2C+And+Knowledge+Graphs+For+Investigative+Journalists+with+Friedrich+Lindenberg+-+Episode+186&urlref=https%3A%2F%2Fwww.podcastinit.com%2Ffeed%2F&utm_source=rss&utm_medium=rss)