Uses ZBW's https://zbw.eu/beta/sparql/pm20/query or the Wikidata SPARQL endpoint at https://query.wikidata.org/sparql - check endpoint= param.
| Query | Description |
|---|---|
| dummy | (results) |
| search_folders_by_text | Search folders by text |
| count_folder_type | Count pm20 ids in total, with docs and with link in WD, by folder type (results) |
| folder_names_qs | Folder names qs input for folders connected to WD items |
| pm20_mnm | Create Mix-n-match input (for co) |
| pm20_mnm_search | Create list of search statements in parallel to Wikidata Mix'n'match catalog for PM20 companies (excluding entries which are already exactly linked) |
| Persons | |
| persons | All persons |
| Organizations | |
| companies | List companies/organizations with most relevant infos and count of documents and business reports (results) |
| companies_with_reports | List companies_with_reports/organizations with most relevant infos and count of documents and business reports (results) |
| companies_unmapped_to_gnd | Organizations which are not linked to GND, with search links |
| companies_unmapped_to_wd | Organizations which are not linked to Wikidata, with search links |
| companies_missing_in_wikidata | Extract information for creating missing company items in Wikidata |
| duplicate_company_signatures | All duplicate company signatures |
| Subjects / wares | |
| subject_folders | Full list of subject folders |
| count_by_country | Subject and ware folder count by country |
| count_by_ware | Folder count by ware |
| count_by_subject | Folder count by subject |
| Colonial affairs | |
| persons_colonial | Persons active in colonial affairs |
| companies_colonial | Companies active in colonial affairs |
| subjects_colonial_german | Subject folders from former German colonial empire |
| wares_colonial_german | Ware folders from former German colonial empire |
| Vocabs | |
| ag_for_openrefine | PM20 country category system prepared for CSV ouput and matching in OpenRefine |
| je_for_openrefine | PM20 subject category system prepared for CSV ouput and matching in OpenRefine |
| ip_for_openrefine | PM20 ware category system prepared for CSV ouput and matching in OpenRefine |
| geo_by_signature | Systematic list of geo categories |
| subject_by_signature | Systematic list of subject categories |
| ware_by_signature | Systematic list of ware categories |
| geo_wd_mapping | Mapping of countries category system to WD |
| sk_wd_mapping | Mapping of industries category system to WD |
| add_category_code | Statements for adding missing category codes to Wikidata |
| add_category_doc_counts | Get aggregated document counts (free and total) for folders connected to WD items by category for adding to Wikidata |
| industries | Get the industry and nace assignment from pm20 |
All links are restricted to folders for which online documents are accessible.
| List | Description |
|---|---|
| nationality | Nationality |
| activity/about | Field of activity |
| activity/location | Country of activity |
| List | Description |
|---|---|
| type | Type of the organization |
| industry | Industry / sector |
| member/roleName | Roles of organization members |
| location | Location |
| broaderLocation | Broader location |
| countryCode | ISO 3166-1 alpha-2 country code (with country names from Wikidata) |