You might have noticed that last week OpenCorporates launched the German company data.
Bringing in the German company data was a mammoth task, as we’ve already started writing about – and we’ll be publishing more blog posts about the precise details of this in the near future. In the meantime, many eyes makes better data; if you’re using the German company data and have spotted a quality issue, be sure to flag these using our issues tracker.
With the help of Open Knowledge Deutschland, we also made this data available as an open dataset at offeneregister.de, where you can analyse networks between companies and officers – for example, this network of German digital publishing house Axel Springer.
Despite signing up to Open Government Partnership in 2016, this report by Transparency Germany shows Germany lags far behind the rest of Europe in terms of access to open data. As a result, we wanted to use this launch to show why the German government needs to open up company register data proactively – which is why we worked with some of Germany’s leading journalists to show why German company data needs to be openly available.
Outside of the journalists stories, we’ve also had an incredible response from our community, with anti-corruption NGOs, politicians, open data users proving why public records must be open data. We’ve listed these stories, some responses to the launch, and analyses of the dataset below.
Süddeutsche Zeitung and NDR found a company connected to alleged Mafia transactions, currently under investigation in Konstanz in the south of Germany. Using data provided by OpenCorporates, the journalists identified a company registered at a private address, which even law enforcement failed to spot. While it’s not yet known if the company was used for criminal purposes, we think this shows the importance of journalists having access to structured data.
SZ also discovered lobbying by Stiftung Familienunternehmen against the German beneficial ownership register (Transparenzregister) being made publicly available in January 2017. They illustrated the real world impact of this secrecy using the example of Hannibal II, a residential property in Dortmund that was evacuated after fire safety concerns – although no one has yet found out who is responsible.
Alongside working with Süddeutsche Zeitung on their investigation, NDR cross-referenced the OpenCorporates dataset with the Panama and Paradise Papers. In particular, they found that offshore corporate structures are often used in the real estate sector. They also discovered a company farm in Pullach, near Munich, where more than 1000 companies are registered.
Continuing the property theme, CORRECTIV combined OpenCorporates German data with that from Malta, Luxembourg, the Bahamas, and other offshore jurisdictions to show that offshore property ownership in Germany is more common than previously thought. It’s possible these complex corporate structures are developed so that little tax is paid – something described by the journalists as “partly legal, partly illegal, but always hard to understand”.
“Für die Bundesregierung ist es ein Armutszeugnis, dass eine ausländische zivilgesellschaftliche Organisation für die Aufbereitung der verfügbaren Daten sorgen muss“, so unsere Vorsitzende Edda Müller @opencorporates #offeneregister #Geldwäsche #Korruption https://t.co/FfTHU5JjOT
— Transparency Germany (@transparency_de) February 6, 2019
Many thanks to @opencorporates! Daten des #Handelsregisters endlich nutzbar. @correctiv_org @NDRrecherche @SZ zeigen Offshore-Firmen überall in Deutschland. Regierung & Lobby verhinderten Transparenz. Brauchen jetzt auch Immobilienregister! https://t.co/VY1lAwv8tu #team
— Fabio De Masi, MdB (@FabioDeMasi) February 6, 2019
So wie @opencorporates das #Handelsregister online stellt, muss auch das #Transparenzregister werden, das jetzt noch eine Datenmüllhalde ist: leicht und kostenlos durchsuchbar. Dann finden sich auch schnell Hinweise zu #PanamaPapers #Geldwäsche https://t.co/MSPTNO8ySP pic.twitter.com/w50v00wHqi
— Lisa Paus (@lisapaus) February 5, 2019
Tolle Sache von @opencorporates . Jetzt muss die Bundesregierung handeln anstatt vor Unternehmensinteressen einzuknicken. @dielinke fordert ein vollumfängliches und öffentliches #Transparenzregister um #Geldwäsche und illegale Geschäfte zu unterbinden. @dielinkeEP @die_linke_th https://t.co/h4MSfPgvB9
— Martin Schirdewan (@schirdewan) February 6, 2019
The German company register is less transparent than it should be. Now, @opencorporates took the effort for more transparency and made it searchable not only by company but also by officer: https://t.co/C4XtzssQlg
— Frederik Obermaier (@f_obermaier) February 5, 2019
Wer, wie, was – Warum Deutschland ein offenes Handelsregister & offene Verträge braucht. Eine kurze Reflektion zum großartigen Projekt OffeneRegister @opencorporates @okfde @transparency_de https://t.co/d3lSM08y69 #opencontracting
— Georg Neumann (@georg_neu) February 7, 2019
Mini exploration of the https://t.co/RoH5jKR2L7 data.
I created a network by connecting officers through their companies. Sample of first 500k companies in the jsonl file.
In the center are officers who are part of multiple companies. Border who are part of only one. pic.twitter.com/MCYIbkk6DN
— Luca Hammer (@luca) February 6, 2019
German Trade Register data has become open thanks to @okfde, @opencorporates and #offeneregister. I did a quick pass with #rstats to check the accessibility of the data. Below you see companies relative to population. Blog article with code: https://t.co/Sd9pGnahMI pic.twitter.com/Rzx6YKIOSE
— Joachim Gassen (@JoachimGassen) February 9, 2019
Worked on something we haven’t included? We want to hear about it! Contact us: email@example.com
EU Horizon 2020