Main Page: Difference between revisions
(add data access) |
No edit summary |
||
(11 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]] | ||
== | ==Overview== | ||
The Aktienführer Knowledge Graph contains | 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:P79 start time] | |||
**[https://akf.kgi.uni-mannheim.de/wiki/Property:P76 end time] | |||
*[https://akf.kgi.uni-mannheim.de/wiki/Property:P127 ISIN] | |||
*[https://akf.kgi.uni-mannheim.de/wiki/Property:P4 WKN] | |||
*[https://akf.kgi.uni-mannheim.de/wiki/Property:P3 Aktienführer ID] | |||
**[https://akf.kgi.uni-mannheim.de/wiki/Property:P234 point in time] | |||
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 (meta)data== | |||
*The AKF (meta)data is accessible by both humans and machines | |||
*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 8: | Line 20: | ||
*[https://query.akf.kgi.uni-mannheim.de SPARQL endpoint] | *[https://query.akf.kgi.uni-mannheim.de SPARQL endpoint] | ||
*[https://akf.kgi.uni-mannheim.de/w/api.php API] | *[https://akf.kgi.uni-mannheim.de/w/api.php API] | ||
*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. | *[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 [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== | |||
*Searching identifiers of German companies for the period 1956-2018 | |||
*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] 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] | |||
*Federated queries over AKF, Wikidata and other SPARQL endpoints | |||
==Get involved== | |||
*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. | |||
*If you are new to knowledge graphs, check out materials at [https://github.com/shigapov/wikibase-knowledge-graphs Wikibase Knowledge Graphs]. | |||
*The AKF knowledge graph is based on [https://wikiba.se Wikibase], the software behind [https://www.wikidata.org Wikidata]. Therefore the [https://www.wikidata.org/wiki/Wikidata:Tours Wikidata tutorials] are also highly recommended. | |||
==External Resources== | |||
*[https://digi.bib.uni-mannheim.de/en/aktienfuehrer/overview AKF OCR-ed texts] | |||
*[https://digi.bib.uni-mannheim.de/aktienfuehrer/data/index.php AKF Structured Database with full data:] Restricted access for research purposes only | |||
*[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 | |||
== | ==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
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
- The AKF (meta)data is accessible by both humans and machines
- The AKF (meta)data is available under the Creative Commons CC0 License
- List of properties
- List of items
- Advanced search for items
- SPARQL endpoint
- API
- 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.
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
- You can contribute to this project in various ways: matching data, data quality checks and data editing/upload.
- You can give your feedback at GitHub AKF-KG Issues.
- You can get an account here via email request to the 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 Wikibase Knowledge Graphs.
- The AKF knowledge graph is based on Wikibase, the software behind Wikidata. Therefore the Wikidata tutorials are also highly recommended.
External Resources
- AKF OCR-ed texts
- AKF Structured Database with full data: Restricted access for research purposes only
- 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
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".