Questions tagged [wikidata]

Wikidata is a project of the Wikimedia foundation related to open data

Filter by
Sorted by
Tagged with
2 votes
1 answer
21 views

Wikidata SPARQL query: adding qualifiers?

I have put together this SparQL query that basically get's all the members of UK cabinets. SELECT ?personLabel ?positionLabel ?parliamentLabel ?startDate ?endDate WHERE { ?person wdt:P106 wd:Q82955; ...
Kaura's user avatar
  • 21
2 votes
0 answers
36 views

Public database with celebrity names?

Essentially I have a list of customer names (first, last), and we want to know whether or not any of these have celebrity status, so looking to cross-reference my list with an external database. Again,...
dataquest2000's user avatar
1 vote
1 answer
41 views

Get Wikidata Dump with countries and attributes

I'm trying to write a SPARQL-query for wikidata, returning all European countries with their most recent properties (population, area, average income, age of retirement and human development index). ...
Lunar Cultist's user avatar
0 votes
1 answer
22 views

Trying to get a qualifier to work, not sure what's wrong

I'm trying to get total assets for companies within the US, but I only want assets from the most recent year available in Wikidata. I'm using P2403 to get total assets and I'm trying to use the ...
eespie's user avatar
  • 1
1 vote
2 answers
128 views

Wikidata COUNT(*) query times out

I have a straightforward query that counts how many humans have an English Wikipedia page. prefix schema: <http://schema.org/> PREFIX wikibase: <http://wikiba.se/ontology#> PREFIX wd: <...
abhinavkulkarni's user avatar
1 vote
3 answers
58 views

Why some items on Wikidata have no corresponding Wikipedia entry?

I get stuck by this Wikidata item: 9., and wonder why there is no corresponding Wikipedia entry?
Lerner Zhang's user avatar
1 vote
0 answers
25 views

getting the latest data about covid-19 pandemic per country with a Wikidata SPARQL query

I'm trying to extract some of the latest data about covid-19 pandemic statistics (number of cases, recoveries, point in time) per country from Wikidata using this SPARQL query: SELECT DISTINCT ?...
amine4392's user avatar
2 votes
1 answer
43 views

Why are some entries so long and strange on Wikidata?

I wonder why Wikidata includes/filters in this kind of entries: Foundations of Astrophysics Barbara Ryden Bradley M. Peterson. 596 pp. Addison-Wesley, San Francisco, 2009. Price: $137.33 (hardcover). ...
Lerner Zhang's user avatar
2 votes
1 answer
58 views

The Chinese English parallel corpus from Wikidata?

I have these two corpora: 1) wikidata alias; 2) wikidata labels. What confused me is that 数学常数 and Mathematical constant's QIDs are respectively Q866140 and Q186509, even though they are linked to ...
Lerner Zhang's user avatar
1 vote
0 answers
25 views

What is the difference between sameAs and alias in Wikidata?

From the descriptions of sameAs and alias I don't know how the two relate to each other, and it also provides the redirects. And aliases also appear in properties.
Lerner Zhang's user avatar
1 vote
0 answers
58 views

How can I get the category of a term by its QID?

I obtained entities(and their QIDs) and the category data from Wikidata, but cannot connect the two. Here is what an entity entry is like: <http://wikidata.dbpedia.org/resource/Q100000001> <...
Lerner Zhang's user avatar
1 vote
2 answers
89 views

Wikidata dump in another language

I am aware that you can download a Wikidata dump file from here But is it possible to only include results for a specific language?I have in the past worked with a json dump file and used python to ...
Pasqual's user avatar
  • 11
1 vote
2 answers
61 views

Fail to search a wikidata item through SPARQL

I tried to search and get the ID of a item with a certain label: Teodor Bogdanov. I can search this name successfully through wikidata website. However, I failed to do so by searching through SPARQL. ...
codelover123's user avatar
0 votes
2 answers
71 views

What is the best way to convert a taxonomy from wikipedia into a JSON-like object?

I'm trying to use the Wikipedia academic fields as a JSON object in one of my projects. I couldn't find it in a useable or convertible format so I am looking into the best approach to obtain it. I ...
Billybobbonnet's user avatar
3 votes
1 answer
98 views

Need top 1000 city names in Ukraine in English, Ukrainian, and Russian

I'm working on a project to track Russian troop movements in the Ukraine with a large group of people. I'm tasked with internationalizing the data. We need a list of the top 1,000 cities in Ukraine ...
Phil Salesses's user avatar
0 votes
1 answer
121 views

Find random 10 people Wikidata

Using Sparql I can find person on Wikdata by his name: SELECT distinct (SAMPLE(?image)as ?image) ?item ?itemLabel ?itemDescription (SAMPLE(?DR) as ?DR)(SAMPLE(?RIP) as ?RIP)(SAMPLE(?...
Alexan's user avatar
  • 442
2 votes
0 answers
104 views

WikiData: filter mwapi results

I am trying to write a sparql query that can retrieve all categories/items from a root and filter down only the ones that are of "human" type. Using the query below, I can retrieve all ...
webber's user avatar
  • 121
1 vote
1 answer
84 views

Wikidata reconciliation with OpenRefine—get only those subjects with English as the language flag

Leptospermum scoparium (Q1520028) has 8 common name (P1843) entries. I have data in OpenRefine reconciled to this object: How can I get only those P1843 entries that are in English? The ...
Hugh's user avatar
  • 13
0 votes
1 answer
605 views

How to get person name and other attributes from Wikidata Sparql (resolving entities)?

I have this Node.js sparql fetcher from Wikidata: next() async function next(offset = 0) { const sparql = ` SELECT ?person ?pic ?givenName ?familyName ?placeOfBirth WHERE { ?person wdt:P31 ...
Lance's user avatar
  • 377
0 votes
1 answer
90 views

Wikimedia: Delta-Dumps or Timestamp of Last Change

I am looking for a list of all the entries of https://de.wiktionary.org (German Wiktionary, but I think this works for all Wikimedia the same way) that have had any changes since the last dump. Is ...
Hubert Schölnast's user avatar
2 votes
1 answer
98 views

What is the best way to create private wikidata items

I am looking for a way to create new private wikidata items to be integrated with the existing public wikidata. Example: Fluffy (Qxxxx) is a (P31) red (Q3142) rabbit (Q9394) stuffed toy (Q682582) . ...
acortis's user avatar
  • 121
1 vote
0 answers
37 views

Explanation for behaviour of FILTER in WDQS

I try to write a simple SPARQL query using WDQS to show some information about a city. My first attempt was to filter using a check for equality, like: SELECT ?city ?cityLabel WHERE { ?city wdt:P31/...
Michael Kremser's user avatar
1 vote
1 answer
132 views

SPARQL query to find invalid date in Wikidata

The following wikidata query lists the teams Cristiano Ronaldo played for including start and end dates. SELECT ?playerLabel ?teamLabel ?start ?end WHERE { VALUES ?player { wd:Q11571 } ?...
Wainage's user avatar
  • 111
1 vote
0 answers
158 views

Is it possible to query Wikidata to get a list of things by item index?

Say, for example, that I wanted to know what the first 100 items are on WikiData (which I do,) without searching in WikiData Q1, Q2, Q3 and so on. Is there a way to write a SPARQL query to find all ...
Lou's user avatar
  • 111
1 vote
1 answer
156 views

Dataset for plant identification

I'm looking for a plant identification dataset (to train a plant identification system) that is free or not too expensive to use and has plant images, specifically garden plants. Just wondering if ...
user912830823's user avatar
1 vote
0 answers
47 views

DOID , SYMP Ontology Sparql Queries

I need to extract the list of diseases, categories, bodyparts and symptoms. I've found several ontologies for that datasets. Disease ontology, symptom ontology, Bioportal and Wikipedia. But I don't ...
Freeedy's user avatar
  • 21
0 votes
0 answers
40 views

How to retrieve infos about creators with sparql in wikidata

I'm trying to retrieve infos about birth and death corresponding to paintors with this query, however I have an empty result if I uncomment birth and death infos. # added before 2016-10 # Recherche de ...
Ben's user avatar
  • 201
1 vote
0 answers
108 views

How can I override this «Query is malformed: Bad aggregate» error message?

I'm working with a Wikidata query: SELECT DISTINCT ?protected_area ?protected_areaLabel ?coordinate_location ?territorialEntity ?territorialEntityLabel (SAMPLE(?instance_of) AS ?instance_of) ?...
Ismael Olea's user avatar
1 vote
0 answers
40 views

SPARQL to get Wikidata items that have no P18 image but have a Commons image depicting them?

Many Commons images depict Wikidata concepts. How to find these concepts, in particular those that do not have an image (P18) property? The request should output the URIs of both the Wikidata item ...
Nicolas Raoul's user avatar
  • 8,386
1 vote
0 answers
50 views

Whole word entity search on Wikidata

Wikidata wbsearchentities service seems perform prefix-based matching, e.g. searching for novel matches as expected: novel : narrative text, normally of a substantial length and in the form of prose ...
A'B's user avatar
  • 111
5 votes
1 answer
554 views

Torrent for Wikidata dump

I'm looking for Wikipedia (enwiki-latest-pages-articles-multistream.xml.bz2) and a Wikidata (latest-all.json.bz2 ) dumps. The files are quite large (the latter has ~47GB) and my internet connection ...
dzieciou's user avatar
  • 233
1 vote
1 answer
126 views

Filtering Wikidata Search

Wikidata today is not only an ontology but also a catalog of publications: scientific articles, formal documents (law), etc. are registered, millions of Wikidata-items. So, when using Wikidata's ...
Peter Krauss's user avatar
2 votes
0 answers
20 views

Airline Distribution system Data

Appreciate it if anyone can suggest an online data source to capture the below information. Airline | Country | number of Fleet | Number of Destinations | Airline PSS (Passenger Service System)
Lasith Harshana's user avatar
1 vote
1 answer
181 views

How do I extract certain articles from Arabic Wiki Dumps?

I need to collect all articles that are about countries and continents in Arabic from Wikipedia. I was wondering how do I find these articles if I downloaded the latest wiki dump? New to the field. ...
user3432543's user avatar
2 votes
1 answer
168 views

Does Wikidata offer inferencing/reasoning?

I would like to use RDFS level inferencing in some queries posed in the Wikidata Query Service which uses SPARQL. Does it support inferencing/reasoning? If so, in what kind? For example, is it Forward ...
pgmank's user avatar
  • 161
1 vote
1 answer
111 views

Looking for foot pressure database collected from pressure sensors

I am working on a project where I need foot pressure data that a person put on his foot while walking, running, or doing any other practice. I searched a lot in the search engines and I couldn't find ...
Sheraz Faraj's user avatar
0 votes
1 answer
184 views

Query wikipedia links

I'm using the following query to receive label and description of all Wikidata-entries with geo-location in a geo-bounding box: SELECT DISTINCT ?place ?placeLabel ?placeDescription ?location WHERE { ...
Tom's user avatar
  • 103
1 vote
2 answers
81 views

Find all Wikidata items whose image (P18) URL contains a certain word

I am trying to find all Wikidata items whose P18 property is an URL that has the word "Montage" anywhere in its filename. Example: I managed to find items by their complete P18 filename: SELECT ?...
Nicolas Raoul's user avatar
  • 8,386
1 vote
1 answer
772 views

SPARQL get all the data before it reaches timeout

I am trying to get all the city names of all countries in the world using this below query. Whenever I execute this below query it returns this message "Query timeout limit reached". Is there any ...
Karuppiah RK's user avatar
4 votes
1 answer
67 views

Find most-depicted Wikidata items that have no image

Wikimedia Commons has a new feature where a picture can have metadata saying it depicts a given Wikidata item. For instance, https://commons.wikimedia.org/wiki/File:Grandpark_Plaza.jpg depicts https:/...
Nicolas Raoul's user avatar
  • 8,386
1 vote
0 answers
42 views

How come there are missing entities in this SPARQL query?

I was interested in listing all books, so I wrote: SELECT ?book ?url WHERE { ?book wdt:P31 wd:Q571 . OPTIONAL { ?url schema:about ?book . ?url schema:inLanguage "en" . ?url schema:...
JammingThebBits's user avatar
1 vote
1 answer
384 views

How to find the wikidata ID of a DBpedia concept?

I have a set of DBpedia concepts and would like to get the corresponding wikidata IDs of them. For example, consider word2vec. The wikidata ID of word2vec is wd:Q22673982. Currently, I have the ...
EmJ's user avatar
  • 245
2 votes
0 answers
105 views

SPARQL - Filter wikidata identifiers

Query below gives me all programming languages entities, with their statements. Problem is that I don't need identifiers now, but these IDs might become necessary. I was just gonna model database ...
nanquim's user avatar
  • 121
2 votes
0 answers
165 views

Wikidata SPARQL - get company entities and the location of their headquarters

I'm having trouble extracting location attributes of company HQ's. My query: finds all companies or sub-classes, and returns some basic properties such as ISIN and URL, and the Headquarter location. ...
BenP's user avatar
  • 121
3 votes
0 answers
41 views

SPARQL query to get capacity of event venues from Wikidata

I am trying to query Wikidata to find out the capacities of all event venues in specific geographic regions (US urban centers). They have this service for querying: Wikidata Query Service The answer ...
Mike's user avatar
  • 143
1 vote
0 answers
19 views

How to distinguish between human and animal bones in Wikidata?

The two topics https://www.wikidata.org/wiki/Q16343 (Clavicle) https://www.wikidata.org/wiki/Q835986 (Baculum, Penis bone) are both instances of Q265868 (Bone). However, the clavicle is a human (...
Jonas Sourlier's user avatar
2 votes
0 answers
111 views

How to use wikidata property paths?

Given a term/concept, I want to decide if it belongs to computer science. For that, I am checking if the concept has a property path to computer science node. In other words, I am checking whether ...
EmJ's user avatar
  • 245
1 vote
0 answers
93 views

Wikidata SPARQL How to speed up this query?

I have come to this query, which retrieves wikipedia and wikidata info from a wikipedia title: SELECT ?wikipediaId ?wikipediaTitle ?wikidataId ?desc ?imageUrl (GROUP_CONCAT(?instanceOfS; SEPARATOR=";"...
Henrique Bruno's user avatar
1 vote
0 answers
111 views

Wikidata Sparql Getting properties from a Wikipedia generator list

I am trying to get the properties that the linked pages from a wikipedia page have. SELECT ?item ?wikipediaTitle ?target WHERE { SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "en....
Henrique Bruno's user avatar
3 votes
1 answer
169 views

Wikidata Query: How to retrieve the normal (non-verbose) JSON?

We can download the results of a Wikidata Query as "JSON file" or "JSON file (verbose)" Example link of random query: http://w.wiki/WQ. I am developing a javascript software which retrieves some ...
Henrique Bruno's user avatar