← All results

Open Knowledge Foundation Deutschland e.V. (OKFN) / OpenCorporatesGerman Company Register Data (OffeneRegister)

Basic German company information (companies and their officers) collected by OpenCorporates mainly from June 2017 to January 2019, sourced from Handelsregisterbekanntmachungen and Handelsregister, covering over 5,000,000 companies. Includes company details, officers, registered addresses, and related registrations. Dataset is kept up-to-date by processing gazette notices as they are published.

Categories

private_establishments_and_corporates

Category Inference

German company register data containing over 5 million registered companies with details on officers, registered addresses, and related registrations sourced from the Handelsregister (German commercial register)

Fallback category: private_establishments_and_corporates

Source Schema

(7 columns)
Name Type Null % Unique Sample values
id object 0.0% 10000
  • R1202_HRB291
  • B1204_HRA370470
  • D2601V_VR7972
names object 0.0%
  • {'primary': 'Niederrheinische Gas- und Wasserwerke Gesellschaft mit beschränkter Haftung'}
  • {'primary': 'Friedrich Lasch Kaminbau, Inhaber Holger Kreß e.K.'}
  • {'primary': 'Bürgervereinigung Allach-Untermenzing e.V.'}
categories object 0.0%
  • {'primary': 'private_establishments_and_corporates'}
  • {'primary': 'private_establishments_and_corporates'}
  • {'primary': 'private_establishments_and_corporates'}
operating_status object 0.0% 2
  • permanently_closed
  • open
  • open
addresses object 0.0%
  • [{'region': None, 'country': 'DE', 'freeform': '', 'locality': None, 'postcode': None}]
  • [{'region': None, 'country': 'DE', 'freeform': '', 'locality': None, 'postcode': None}]
  • [{'region': None, 'country': 'DE', 'freeform': '', 'locality': None, 'postcode': None}]
sources object 0.0%
  • [{'between': None, 'dataset': 'opencorporates-de', 'license': None, 'property': '', 'record_id': 'R1202_HRB291', 'confidence': None, 'update_time': '2025-01-01'}]
  • [{'between': None, 'dataset': 'opencorporates-de', 'license': None, 'property': '', 'record_id': 'B1204_HRA370470', 'confidence': None, 'update_time': '2025-01-01'}]
  • [{'between': None, 'dataset': 'opencorporates-de', 'license': None, 'property': '', 'record_id': 'D2601V_VR7972', 'confidence': None, 'update_time': '2025-01-01'}]
source_properties object 0.0%
  • {'name': 'Niederrheinische Gas- und Wasserwerke Gesellschaft mit beschränkter Haftung', 'officers': "[{'end_date': '2007-03-29', 'name': 'Friedrich Dürre', 'other_attributes': {'city': 'Marl', 'dismissed': True, 'firstname': 'Friedrich', 'lastname': 'Dürre'}, 'position': 'Geschäftsführer', 'type': 'person'}, {'name': 'Heiner Krietenbrink', 'other_attributes': {'city': 'Gelsenkirchen', 'firstname': 'Heiner', 'lastname': 'Krietenbrink'}, 'position': 'Geschäftsführer', 'start_date': '2007-03-29', 'type': 'person'}, {'name': 'Stefan Pruss', 'other_attributes': {'city': 'Mühlheim an der Ruhr', 'firstname': 'Stefan', 'lastname': 'Pruss'}, 'position': 'Geschäftsführer', 'start_date': '2008-01-28', 'type': 'person'}]", 'retrieved_at': '2018-06-18T22:05:33Z', 'company_number': 'R1202_HRB291', 'current_status': 'removed', 'previous_names': None, 'jurisdiction_code': 'de', 'registered_address': None, 'alternate_registrations': None, 'all_attributes.registrar': 'Duisburg', 'subsequent_registrations': None, 'all_attributes._registerArt': 'HRB', 'all_attributes.federal_state': 'North Rhine-Westphalia', 'all_attributes._registerNummer': '291', 'all_attributes.additional_data.': None, 'all_attributes.former_registrar': None, 'all_attributes.registered_office': 'Duisburg', 'all_attributes.additional_data.AD': 'False', 'all_attributes.additional_data.CD': 'True', 'all_attributes.additional_data.DK': 'True', 'all_attributes.additional_data.HD': 'True', 'all_attributes.additional_data.SI': 'False', 'all_attributes.additional_data.UT': 'True', 'all_attributes.additional_data.VÖ': 'True', 'all_attributes._registerNummerSuffix': None, 'all_attributes.additional_data.Note:': None, 'all_attributes.native_company_number': 'Duisburg HRB 291', 'all_attributes.additional_data.Status information': None}
  • {'name': 'Friedrich Lasch Kaminbau, Inhaber Holger Kreß e.K.', 'officers': "[{'end_date': '2008-01-04', 'name': 'Friedrich Lasch', 'other_attributes': {'city': 'Rheinau', 'dismissed': True, 'firstname': 'Friedrich', 'lastname': 'Lasch', 'title': 'Maurermeister'}, 'position': 'Inhaber', 'type': 'person'}, {'name': 'Brigitte geborene Lasch Kreß', 'other_attributes': {'city': 'Rheinau', 'firstname': 'Brigitte geborene Lasch', 'lastname': 'Kreß'}, 'position': 'Prokurist', 'start_date': '2010-04-01', 'type': 'person'}, {'name': 'Holger Kreß', 'other_attributes': {'city': 'Rheinau', 'firstname': 'Holger', 'lastname': 'Kreß'}, 'position': 'Inhaber', 'start_date': '2008-01-04', 'type': 'person'}]", 'retrieved_at': '2018-07-27T17:11:46Z', 'company_number': 'B1204_HRA370470', 'current_status': 'currently registered', 'previous_names': "[{'company_name': 'Friedrich Lasch Kaminbau'}]", 'jurisdiction_code': 'de', 'registered_address': None, 'alternate_registrations': None, 'all_attributes.registrar': 'Freiburg', 'subsequent_registrations': None, 'all_attributes._registerArt': 'HRA', 'all_attributes.federal_state': 'Baden-Württemberg', 'all_attributes._registerNummer': '370470', 'all_attributes.additional_data.': None, 'all_attributes.former_registrar': None, 'all_attributes.registered_office': 'Rheinau', 'all_attributes.additional_data.AD': 'True', 'all_attributes.additional_data.CD': 'True', 'all_attributes.additional_data.DK': 'True', 'all_attributes.additional_data.HD': 'True', 'all_attributes.additional_data.SI': 'True', 'all_attributes.additional_data.UT': 'True', 'all_attributes.additional_data.VÖ': 'True', 'all_attributes._registerNummerSuffix': None, 'all_attributes.additional_data.Note:': None, 'all_attributes.native_company_number': 'Freiburg HRA 370470', 'all_attributes.additional_data.Status information': None}
  • {'name': 'Bürgervereinigung Allach-Untermenzing e.V.', 'officers': None, 'retrieved_at': '2018-06-23T22:11:07Z', 'company_number': 'D2601V_VR7972', 'current_status': 'currently registered', 'previous_names': "[{'company_name': 'Bürgervereinigung Allach-Untermenzing'}]", 'jurisdiction_code': 'de', 'registered_address': None, 'alternate_registrations': None, 'all_attributes.registrar': 'München', 'subsequent_registrations': None, 'all_attributes._registerArt': 'VR', 'all_attributes.federal_state': 'Bavaria', 'all_attributes._registerNummer': '7972', 'all_attributes.additional_data.': 'True', 'all_attributes.former_registrar': None, 'all_attributes.registered_office': 'München', 'all_attributes.additional_data.AD': 'False', 'all_attributes.additional_data.CD': 'False', 'all_attributes.additional_data.DK': 'False', 'all_attributes.additional_data.HD': 'False', 'all_attributes.additional_data.SI': 'False', 'all_attributes.additional_data.UT': 'False', 'all_attributes.additional_data.VÖ': 'False', 'all_attributes._registerNummerSuffix': None, 'all_attributes.additional_data.Note:': None, 'all_attributes.native_company_number': 'München VR 7972', 'all_attributes.additional_data.Status information': 'True'}

Quality Report

Dataset is usable

Geographic Bounds

Coordinates: Southwest (10.0000, 51.0000) - Northeast (10.0000, 51.0000)