Main Page: Difference between revisions

(restructure company IDs)
No edit summary
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[File:Akf-ub-ma.webp|thumb|961x961px]]
[[File:Akf-ub-ma.webp|thumb|961x961px]]
[[File:Akf.png|thumb]]
[[File:Akf.png|thumb]]
==Aktienführer Knowledge Graph==
==Overview==
The Aktienführer (AKF) Knowledge Graph is free and open. It contains structured (meta)data for the German listed stock companies from the Hoppenstedt-Aktienführer from 1956 to 2018. The metadata includes official company names with time ranges, company identifiers (ISIN and WKN) and Aktienführer IDs.
The Aktienführer (AKF) Knowledge Graph is free and open. It contains structured (meta)data for the German listed stock companies from the Hoppenstedt-Aktienführer from 1956 to 2018. The metadata includes official company names with time ranges, company identifiers (ISIN and WKN) and Aktienführer IDs.
*[https://akf.kgi.uni-mannheim.de/wiki/Property:P346 official name]
*[https://akf.kgi.uni-mannheim.de/wiki/Property:P346 official name]
Line 12: Line 12:
We enriched metadata via entity linking with other databases: [https://www.creditreform.com Creditreform], [https://www.bvdinfo.com/de-de/unsere-losungen/daten/international/orbis Bureau van Dijk Orbis], [https://www.dnb.de/DE/Professionell/Standardisierung/GND/gnd_node.html GND] and [https://www.wikidata.org Wikidata]. The knowledge graph contains [https://akf.kgi.uni-mannheim.de/w/index.php?title=Special:ListProperties/external-id&limit=500&offset=0 342] external identifiers representing various databases, including the valuable company databases: [https://akf.kgi.uni-mannheim.de/wiki/Property:P5 Crefo number], [https://akf.kgi.uni-mannheim.de/wiki/Property:P6 BvD ID], [https://akf.kgi.uni-mannheim.de/wiki/Property:P8 Orbis ID], [https://akf.kgi.uni-mannheim.de/wiki/Property:P9 Handelsregisternummer], [https://akf.kgi.uni-mannheim.de/wiki/Property:P343 PM20 folder ID], [https://akf.kgi.uni-mannheim.de/wiki/Property:P10 European VAT number], [https://akf.kgi.uni-mannheim.de/wiki/Property:P25 D&B Hoovers company profile], [https://akf.kgi.uni-mannheim.de/wiki/Property:P36 Bloomberg company ID], [https://akf.kgi.uni-mannheim.de/wiki/Property:P126 ROR ID], [https://akf.kgi.uni-mannheim.de/wiki/Property:P146 Legal Entity Identifier (LEI)], [https://akf.kgi.uni-mannheim.de/wiki/Property:P161 Google Knowledge Graph ID], [https://akf.kgi.uni-mannheim.de/wiki/Property:P162 PermID], [https://akf.kgi.uni-mannheim.de/wiki/Property:P251 OpenSanctions ID], [https://akf.kgi.uni-mannheim.de/wiki/Property:P276 LinkedIn organization ID], [https://akf.kgi.uni-mannheim.de/wiki/Property:P275 German Lobbyregister ID], [https://akf.kgi.uni-mannheim.de/wiki/Property:P300 North Data ID] and [https://akf.kgi.uni-mannheim.de/wiki/Property:P334 OpenCorporates ID].
We enriched metadata via entity linking with other databases: [https://www.creditreform.com Creditreform], [https://www.bvdinfo.com/de-de/unsere-losungen/daten/international/orbis Bureau van Dijk Orbis], [https://www.dnb.de/DE/Professionell/Standardisierung/GND/gnd_node.html GND] and [https://www.wikidata.org Wikidata]. The knowledge graph contains [https://akf.kgi.uni-mannheim.de/w/index.php?title=Special:ListProperties/external-id&limit=500&offset=0 342] external identifiers representing various databases, including the valuable company databases: [https://akf.kgi.uni-mannheim.de/wiki/Property:P5 Crefo number], [https://akf.kgi.uni-mannheim.de/wiki/Property:P6 BvD ID], [https://akf.kgi.uni-mannheim.de/wiki/Property:P8 Orbis ID], [https://akf.kgi.uni-mannheim.de/wiki/Property:P9 Handelsregisternummer], [https://akf.kgi.uni-mannheim.de/wiki/Property:P343 PM20 folder ID], [https://akf.kgi.uni-mannheim.de/wiki/Property:P10 European VAT number], [https://akf.kgi.uni-mannheim.de/wiki/Property:P25 D&B Hoovers company profile], [https://akf.kgi.uni-mannheim.de/wiki/Property:P36 Bloomberg company ID], [https://akf.kgi.uni-mannheim.de/wiki/Property:P126 ROR ID], [https://akf.kgi.uni-mannheim.de/wiki/Property:P146 Legal Entity Identifier (LEI)], [https://akf.kgi.uni-mannheim.de/wiki/Property:P161 Google Knowledge Graph ID], [https://akf.kgi.uni-mannheim.de/wiki/Property:P162 PermID], [https://akf.kgi.uni-mannheim.de/wiki/Property:P251 OpenSanctions ID], [https://akf.kgi.uni-mannheim.de/wiki/Property:P276 LinkedIn organization ID], [https://akf.kgi.uni-mannheim.de/wiki/Property:P275 German Lobbyregister ID], [https://akf.kgi.uni-mannheim.de/wiki/Property:P300 North Data ID] and [https://akf.kgi.uni-mannheim.de/wiki/Property:P334 OpenCorporates ID].


==Access to AKF (meta)data==
==Access to (meta)data==
The AKF (meta)data is accessible by both humans and machines.
*The AKF (meta)data is accessible by both humans and machines
*License:
*The AKF (meta)data is available under the [https://creativecommons.org/publicdomain/zero/1.0 Creative Commons CC0 License]
*[https://akf.kgi.uni-mannheim.de/w/index.php?title=Special:ListProperties/&limit=500&offset=0 List of properties]
*[https://akf.kgi.uni-mannheim.de/w/index.php?title=Special:ListProperties/&limit=500&offset=0 List of properties]
*[https://akf.kgi.uni-mannheim.de/wiki/Special:AllPages?from=&to=&namespace=120 List of items]
*[https://akf.kgi.uni-mannheim.de/wiki/Special:AllPages?from=&to=&namespace=120 List of items]
Line 21: Line 21:
*[https://akf.kgi.uni-mannheim.de/w/api.php API]
*[https://akf.kgi.uni-mannheim.de/w/api.php API]
*[https://akf.kgi.uni-mannheim.de/wiki/Special:WikibaseExport Export to CSV]
*[https://akf.kgi.uni-mannheim.de/wiki/Special:WikibaseExport Export to CSV]
*Every entity can be downloaded in .json, .rdf, .ttl, .nt and .jsonld formats. An example for BASF: https://akf.kgi.uni-mannheim.de/entity/Q425.json, https://akf.kgi.uni-mannheim.de/entity/Q425.rdf, https://akf.kgi.uni-mannheim.de/entity/Q425.ttl, https://akf.kgi.uni-mannheim.de/entity/Q425.nt and https://akf.kgi.uni-mannheim.de/entity/Q425.jsonld.
*Every entity can be downloaded in .json, .rdf, .ttl, .nt and .jsonld formats. An example for [https://akf.kgi.uni-mannheim.de/entity/Q425 BASF]: https://akf.kgi.uni-mannheim.de/entity/Q425.json, https://akf.kgi.uni-mannheim.de/entity/Q425.rdf, https://akf.kgi.uni-mannheim.de/entity/Q425.ttl, https://akf.kgi.uni-mannheim.de/entity/Q425.nt and https://akf.kgi.uni-mannheim.de/entity/Q425.jsonld.


==Use Cases==
==Use Cases==
*Searching identifiers of German companies for the period 1956-2018
*Searching identifiers of German companies for the period 1956-2018
*Matching your (meta)data to AKF companies
*Matching your (meta)data to AKF data using the [https://rec.akf.kgi.uni-mannheim.de AKF reconciliation service]
*Clean your tabular data and match it to the AKF knowledge graph with [https://openrefine.org OpenRefine]
*Clean your tabular data and match it to the AKF knowledge graph with [https://openrefine.org OpenRefine] and the [https://rec.akf.kgi.uni-mannheim.de AKF reconciliation service]
*Semantic annotation of tabular data using the AKF knowledge graph with [https://github.com/UB-Mannheim/bbw bbw]
*Semantic annotation of tabular data using the AKF knowledge graph with [https://github.com/UB-Mannheim/bbw bbw]
*Federated queries over AKF, Wikidata and other SPARQL endpoints
*Federated queries over AKF, Wikidata and other SPARQL endpoints
Line 32: Line 32:
==Get involved==
==Get involved==
*You can contribute to this project in various ways: matching data, data quality checks and data editing/upload.
*You can contribute to this project in various ways: matching data, data quality checks and data editing/upload.
*You can give your feedback at [https://github.com/UB-Mannheim/Aktienfuehrer-KG/issues GitHub AKF-KG Issues].
*You can get an account here via email request to the [https://fdz.bib.uni-mannheim.de Research Data Center at UB Mannheim]. Please write "Request an account at the AKF KG" as a subject.
*You can get an account here via email request to the [https://fdz.bib.uni-mannheim.de Research Data Center at UB Mannheim]. Please write "Request an account at the AKF KG" as a subject.
*If you are new to knowledge graphs, check out materials at [https://github.com/shigapov/wikibase-knowledge-graphs Wikibase Knowledge Graphs].
*If you are new to knowledge graphs, check out materials at [https://github.com/shigapov/wikibase-knowledge-graphs Wikibase Knowledge Graphs].
Line 41: Line 42:
*[https://de.wikipedia.org/wiki/Hoppenstedt_Aktienf%C3%BChrer Hoppenstedt Aktienführer] at Wikipedia
*[https://de.wikipedia.org/wiki/Hoppenstedt_Aktienf%C3%BChrer Hoppenstedt Aktienführer] at Wikipedia
*Gehrlein, Sabine et al.: Vom Papier zur Datenanalyse. „Neue“ historische Forschungsdaten für die Wirtschaftswissenschaften, in: E-Science-Tage 2019: Data to Knowledge, Heidelberg: heiBOOKS, 2020. https://doi.org/10.11588/heibooks.598.c8423
*Gehrlein, Sabine et al.: Vom Papier zur Datenanalyse. „Neue“ historische Forschungsdaten für die Wirtschaftswissenschaften, in: E-Science-Tage 2019: Data to Knowledge, Heidelberg: heiBOOKS, 2020. https://doi.org/10.11588/heibooks.598.c8423
==Acknowledgments==
This work was funded by the Ministry of Science, Research and Arts of Baden-Württemberg through the project “BERD@BW" and by the German Research Foundation (DFG) through the project "[https://www.berd-nfdi.de BERD@NFDI]".

Latest revision as of 11:53, 11 May 2023

Akf-ub-ma.webp
Akf.png

Overview

The Aktienführer (AKF) Knowledge Graph is free and open. It contains structured (meta)data for the German listed stock companies from the Hoppenstedt-Aktienführer from 1956 to 2018. The metadata includes official company names with time ranges, company identifiers (ISIN and WKN) and Aktienführer IDs.

We enriched metadata via entity linking with other databases: Creditreform, Bureau van Dijk Orbis, GND and Wikidata. The knowledge graph contains 342 external identifiers representing various databases, including the valuable company databases: Crefo number, BvD ID, Orbis ID, Handelsregisternummer, PM20 folder ID, European VAT number, D&B Hoovers company profile, Bloomberg company ID, ROR ID, Legal Entity Identifier (LEI), Google Knowledge Graph ID, PermID, OpenSanctions ID, LinkedIn organization ID, German Lobbyregister ID, North Data ID and OpenCorporates ID.

Access to (meta)data

Use Cases

  • Searching identifiers of German companies for the period 1956-2018
  • Matching your (meta)data to AKF data using the AKF reconciliation service
  • Clean your tabular data and match it to the AKF knowledge graph with OpenRefine and the AKF reconciliation service
  • Semantic annotation of tabular data using the AKF knowledge graph with bbw
  • Federated queries over AKF, Wikidata and other SPARQL endpoints

Get involved

External Resources

Acknowledgments

This work was funded by the Ministry of Science, Research and Arts of Baden-Württemberg through the project “BERD@BW" and by the German Research Foundation (DFG) through the project "BERD@NFDI".