Skip to content

Latest commit

 

History

History
90 lines (69 loc) · 15.3 KB

README.md

File metadata and controls

90 lines (69 loc) · 15.3 KB

Queries for Wikidata

Uses the Wikidata SPARQL endpoint at https://query.wikidata.org/sparql.

Query Description
lookup_by_gnd Lookup wikidata URI by GND id, show label, language-specific wikipedia site link and link to the SQUID browser
lookup_by_repec Look up the wikidata URI, label and en+de wikipedia site links by RePEc ID
all_repec Look up the wikidata URI, label and en wikipedia site links by RePEc ID for all defined mappings
prominent_economists Internationally prominent economists (with entries in three or more Wikipedias)
thriving_new_items Numbers of properties/ids and WP pages for newly created items (missing top female economists from RePEc ranking, created in a batch in April 2017)
econ_pers_with_wikipedia Wikipedia pages for EconBiz authors
count_economists_with_gnd Count wikidata economists and those having gnd ids
articles_by Articles by an author (from newspapers and the like)
geographic_entities Autosuggest geographic entities
geographic_entities_codelist Geographic entities code list (for import into SowiDataNet repository)
iso3166_codelist ISO 3166-1/2 code list for countries and German states
missing_property Prominent economists, as indicated by a certain property, lacking another propery (e.g., RePEc authors without a GND ID) - with links for looking up the names in GND
mapping_relation_qualifier_qs Generate statements for QuickStatements2 for adding a default mapping relation qualifier to external identifiers
pm20_economists Show pm20 folders for persons of a certain occupation
all_subclasses Get all subclasses of a Wikidata class
nace List of items with NACE code
stw_dbpedia_mapping Links STW - DBpedia, derived from Wikidata

Queries re. PM20

Query Description
pm20_folder_mapping Wikidata items with linked PM20 folders
item_by_pm20_id Items by pm20 folder id
pm20_references Properties with reference from PM20
missing_pm20_id_via_gnd Get missing PM20 IDs for WD items with known GND ID
missing_class_via_pm20 Get missing class for WD items from PM20 organizations
pm20_folder_doc_counts Get document counts (free and total) for folders connected to WD items
pm20_subject_category_by_code Get PM20 subject category by subject code
multiple_pm20_co Items with multiple PM20 co entries (narrow match excluded)
industries_for_pm20 Industries for items with pm20 company folder
industries_for_pm20_by_sk Systematic overview by PM20 industry category system for items with pm20 company folder
industries_for_pm20_by_nace Industries by NACE code for items with pm20 company folders (incomplete!)
all_pm20_companies All PM20 organizations (folder and microfilm)
filmsections_without_ids Items with film sections without PM20 id

"Power queries"

Due to limitations of the public Wikidata endpoint (in particular timeouts), the following queries do not work there and require a "private" endpoint. Therefore, links to cached result files has been added.

re. persons/economists

see also Economists in Wikidata

Query Description
count_persons_by_wp_language Does not work any more Count wikipedia articles about persons and specifically economists in different languages (result (as of 2016-11-07))
count_ebds_pers Uses internal dataset Statistics about economics-related gnd persons (from a prototype of the econbiz research dataset) and how many of them are in wikidata (result)
count_ebds_pub_pers Uses internal dataset Statistics about how many EBDS persons are missing a GND link in Wikidata and how many enriched publications could be gained by fixing this (result)
count_ebds_pers_by_authority Uses internal dataset Count economics-related gnd persons (from a prototype of the econbiz research dataset) by properties used for authority control (result)
ebds_persons_by_publication_count Uses internal dataset List the most frequent persons in EconBiz (by GND) and links to Wikidata or to a search for all their names in Wikidata (result)
search_person_by_gnd_names Search a person by all preferred and variant names from gnd (rank by calculated total score) (result)
count_econ_pers Statistics about economics-related gnd persons (from econ_pers dataset) and how many of them are in wikidata (result)
frequent_econ_pers_occupations Occupations of economics-related gnd persons (from econ_pers dataset) (result)
count_economists_by_authority Count economists by properties used for authority control (result)
count_by_authority_for_persons Count persons with authority control properties for people (result)

re. concepts

see also STW mapping to Wikidata

Query Description
search_concept_by_stw_labels Search a concept by all preferred and alternate labels from stw and other linked concepts (rank by calculated total score)
items_created_from_stw Wikidata items created from STW concepts, normally via Quickstatements

re. PM20

Query Description
search_corp_by_pm20_names Search a PM20 company by all preferred and alternate labels (rank by calculated total score)
search_person_by_pm20_names Search a PM20 person by all preferred and alternate labels (rank by calculated total score)

Documentation

see Wikidata Links