Wikidata

Queries

Interesting

Q101 is the longest word in ancient Greek (Lopadotemachoselachogaleo­kranioleipsanodrimhypotrimmatosilphiokarabomeli­tokatakechymenokichlepikossyphophatto­peristeralektryonoptekephalliokigklopeleio­lagoiosiraiobaphetraganopterygon)
Q102 is the longest word published in a dictionary (Pneumonoultramicroscopicsilicovolcanoconiosis)
Q27721 represents the number 1. Q16725860 is א, the first Hebrew letter.
Q42 is Douglas Adams, because who else but him could be assigned that number?
Q65041695 (blockchain analysis), because it has a link to blockchain.renenyffenegger.ch ☺
Q5460604 is a list of articles that all Wikipedia languages should have. select ?x ?xLabel { ?x wdt:P5008 wd:Q5460604 . service wikibase:label { bd:serviceParam wikibase:language "en,de" . } }.
Q1380645 (Pyotr Andreyevich Tolstoy) is recorded with two dates of death P570.

Q4827208 (Autwine in Oklahoma) because it is linked from here.

Q52834024 is less than (<)

Related to Wikimedia/Wikidata etc.

Q111513007 (Wikibase entity), Q32753077 (Wikidata entity), Q115490628 (fundamental Wikidata entity) etc.

Q14827288 (Wikimedia project)

Q17442446 (Wikimedia internal item)

Statements etc.

The the value of the statement with P349 (NDL Authority ID) in Q153 is deprecated. The wikidata page gives a reason for the deprecation («refers to different subject»). How can this reason be queried.

snaktype

The snaktype for P40 (child) of Queen Elizabeth I is novalue.

The snaktype for P509 (cause of death) of William Shakespeare is somevalue.

Related to OpenStreetMap

Q936
P402 (identifier for a relation)
P10689 (identifier for a way)
P11693 (ID of a node)

P13786 (OpenStreetMap key)

Q25494718 (A (likely outdated) fork of the OpenStreetMap project)

well well well

Q8557513 and Q1327226 refer both to Istanbul.

TODO

Why does Q35343261 return an empty data set?

Contact

P856 (official website), P6375: Street address, P1329: Phone numer, P968: email, P2900: Fax

Image/logos related properties etc.


Q100 has P948 (page banner).
Q1085 has P948 (page banner).
Q5291197 has P154 (logo image).
Q396 has P154 (logo).
Q406 has P373 (name of the Wikimedia Commons category containing files related to this item).

Done: The banner for Q15138389 is not displayed correctly because the filename contains a quote!

Q126372895 (Grenzstein 53 zwischen Deutschland und der Schweiz) has 5 P18 (image of relevant illustration of the subject)

Should P2716 be shown as page banner as well

P94 (coat of arms) could be displayed more prominently if there is no other banner for a page (such as Q680996, Bülach District).

External IDs

P1281 has two formatter URLs. (And btw, it is a flicker URL). Q5046939 (Carson Hill) uses P1281.

P1630, P1921 and P3303 are URL/URI formatters. P402 which uses all three of them.

Ethanol has the property P4964 whose formatter (P1630) contains apostrophes, which seems to cause problems when using <a href for the formatter.

Qualifiers

Q16577004 has a statement under the claim P348 (software version identifer) (or vice versa) with multiple references for the snak

P402 (OpenStreetMap relation ID) has the quantity P4876 (number of records) with multiple values. It seems that the qualifer with P585 (point in time) can/should be used to qualify the date for which the statement is valid.

The qualifers for P1346 (Winner) in Q19946573 (2015 Tour de France, stage 7) seem important.

P31, P361, P279

P31 (instance of) and P361 (part of) and P279 (subclass of) should be treated specially and given more prominence:

Person related

P1340: eye color (see Q42), P742: Pseudonym (again see Q42)

Location related

P47: shares border with, for example Prag

P150: contains the administrative territorial entity, for example Prag, Karawang or Bülach District.

Category related

Q5262 (Riehen) has several category related properties: P910 (topic's main category), P1464 (category for people born here), P1465 (category for people died here), P1792 (category of associated people), P7867 (category for maps or plans)

Chemical stuff

Q153 (Ethanol) has P117 (chemical structure) with three qualifers. These could possible by joined with P274 (chemical formula).

title_from_url

Does title_from_url run acceptably for Q328 (English Wikipedia) - The function tried to download the entire wikipedia cim file and should now time out.

Datatypes

Q2937190 has P7973 (Quantity symbol LaTeX) whose datatype is math.
Compare with P1993 (TeX String)

Character encoding

For example Whos On First still displays wrong characters.

P968: email address

For example Rosenberg Fortress (Check for contact)

P1448: official name, P1476 title

For example Festung Rosenberg or Závist

Q328 (English Wikipedia) has both.

Commons Category

Why does Karawang show the Wikimedia Commons Category twice (P373)

P281: Postalcodes

Postalcodes (P281) such as for Q159288 should probably not be listed in tabular form.

P355: child organization/unit

For example Prag

P1549: Demonym

Q100 (Boston) has demonyms (P1549) in multiple languages. The language should probably be stated

P3896: GeoShape

For example Závist

P625: coordinate location - GeoShape

For example Závist.

Other Ps (see .php)

P1334, P5140, P1332, P1333, P1335: easternmost point, geographic center etc

P610, P1589: Highest/lowest point (whose datatype is wikibase-item!)

P297, P298, P299: ISO 3166 alpha 2/3, numeric.
P300 is ISA3166-2 (for example DE-BE for Berlin).

P569, P570, P19, P20: date/place of birth/death

P156, P155 followed by/follows, P1545 (series ordinal), see Q19951541 (Tour de France, stage 19).

P242 Locator

P8814

Schemas

Humans (Q5) are related to schemas E10, E14 and E48.

Schema E2 is concerned with Wikimedia.
Among others, it defines #wikimedia_supported_language and wikibase:wikiGroup with the members article, commons, meta, species, wikibooks, wikidata, wikinews, wikipedia, wikiquote, wikisource, wikiversity, wikivoyage, mediawiki, wiktionary, ruwikimedia, sources, yuewiktionary, incubator, wikimania and testcommons.

Schema E3: Wikidata Item. How does this relate to Q29934200 (Wikibase Item) and Q111513007 (Wikibase Entity)?

Schema E4: Each wikidata itam has zero or more label, description and alias combinations.

Schema E5: Statement.

Schema E9: Schema for linking wikibase and wikidata.

Schema E49: Wikidata prefixes

Schema E54: Lexemes

Schema E30: Australian national parks.

Schema E31: File format families.

Schemas E32 Sovereign state, E50 national flag and E100 city.

Schemas E37 human gene, E75 gene, E38 human protein, E109 human chromosome, E107 chromosome, E103 gene variant and E74 pseudogene.

Schema E40: european route.

SELECT * WHERE {
   ?european_highway wdt:P31 wd:Q34442 ;
                     wdt:P16 wd:Q106123 . FILTER NOT EXISTS {?european_highway wdt:P361 ?hw} .
} LIMIT 10

Schema E46: Chemical element.

Schema E55: Programming language

Schema E12: Data set

Schema E83: W3C Recommendation

See also this query: 

 select
  ?entityLabel
  ?schemaLabel
  ?entity
  ?schema
{
   ?entity wdt:P12861 ?schema .
   service wikibase:label { bd:serviceParam wikibase:language "en" . }
}
order by
  (lcase(?entityLabel))

schema:article

select * {
   <https://de.wikipedia.org/wiki/Wikipedia> ?b ?c .
}
limit 100

rdf:type

select * {
     ?rdfType rdf:type ?x
}
limit 100
 See also https://www.wikidata.org/wiki/Special:ListDatatypes

PLZ

Why filtered?

Other properties


Q163957 has P8017 (generational suffix).

Descriptions

Q19951541 (2015 Tour de France, stage 19) has only descriptions for in german and french. Hence, if neither of these langages is present in the Accepted languages header, no description is shown.

Lexemes

Such as L851-S1 (see also L2)

Quantity units

Quantities are not displayed with units (for example the boling point of Q153 (Ethanol).

Quantity units seem to be resolved with psv:P2102: 

SELECT ?amount ?unit ?unitLabel WHERE {
  wd:Q153 p:P2102 ?statement.
  ?statement psv:P2102 ?valueNode.
  ?valueNode wikibase:quantityAmount ?amount;
             wikibase:quantityUnit ?unit.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}

Done

Strange characters, such as found in P5076.
The value of X/Twitter username is now prepended with a @, see Q127398951. (Only in the main query)

Chemical formulas (P274)

Such as in Q153 (Ethanol) or Q82038566 (i. e. 8a-Ethenyl-4-hydroxy-3,5-dimethylideneoctahydro-2h-furo[3,2-g]isochromene-2,6(3h)-dione)