query-c2b858673526c6c0c33cbf888129b1bd

rq turtle/ttl

No letter: Assume CIdeally, we want "letters=1" in each row. But the majority (228k) have no letter: 3 2 false true true false 15 1 false true false false 2 3 true true true false 187 2 true true false false 9 2 false false true true 2741 1 false false false true 21080 1 true false false false 1563 2 true false true false 25907 1 false false true false 228168 0 false false false false c letters W V I A So I ran this discovery query to find the actual list of types:

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
select ?typeLabel (count(*) as ?c) {
  ?x wdt:P6366 ?mag
  filter (not exists {?x wdt:P31/wdt:P279* wd:Q5}
    && not exists {?x wdt:P31/wdt:P279* wd:Q43229}
    && not exists {?x wdt:P31/wdt:P279* wd:Q5633421} && not exists {?x wdt:P31/wdt:P279* wd:Q625994} 
    && not exists {?x wdt:P31/wdt:P279* wd:Q17537576}
  )
  ?x wdt:P31 ?type.
  ?type rdfs:label ?typeLabel filter(lang(?typeLabel)="en")
} group by ?typeLabel order by desc(?c)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?c") v4("?mag") v5("?type") v2("?typeLabel"):::projected v3("?x") a1((" ")) a2((" ")) a3((" ")) a4((" ")) a5((" ")) c7(["wd:Q625994"]):::iri c4(["wd:Q5"]):::iri c6(["wd:Q5633421"]):::iri c8(["wd:Q17537576"]):::iri c5(["wd:Q43229"]):::iri f0[["?typeLabel = 'en'"]] f0 --> v2 f1[["not not not not not "]] subgraph f1e0["Exists Clause"] e0v1 --"wdt:P31"--> e0a1 e0a1 --"wdt:P279"--> e0c3 e0v1("?x"):::projected e0a1((" ")):::projected e0c3(["wd:Q5"]):::iri end f1--EXISTS--> f1e0 subgraph f1e1["Exists Clause"] e1v1 --"wdt:P31"--> e1a1 e1a1 --"wdt:P279"--> e1c3 e1v1("?x"):::projected e1a1((" ")):::projected e1c3(["wd:Q43229"]):::iri end f1--EXISTS--> f1e1 subgraph f1e2["Exists Clause"] e2v1 --"wdt:P31"--> e2a1 e2a1 --"wdt:P279"--> e2c3 e2v1("?x"):::projected e2a1((" ")):::projected e2c3(["wd:Q5633421"]):::iri end f1--EXISTS--> f1e2 subgraph f1e3["Exists Clause"] e3v1 --"wdt:P31"--> e3a1 e3a1 --"wdt:P279"--> e3c3 e3v1("?x"):::projected e3a1((" ")):::projected e3c3(["wd:Q625994"]):::iri end f1--EXISTS--> f1e3 subgraph f1e4["Exists Clause"] e4v1 --"wdt:P31"--> e4a1 e4a1 --"wdt:P279"--> e4c3 e4v1("?x"):::projected e4a1((" ")):::projected e4c3(["wd:Q17537576"]):::iri end f1--EXISTS--> f1e4 f1 --> v3 f1 --> c2 f1 --> a1 f1 --> c3 f1 --> c4 f1 --> a2 f1 --> c5 f1 --> a3 f1 --> c6 f1 --> a4 f1 --> c7 f1 --> a5 f1 --> c8 v3 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c4 v3 --"wdt:P31"--> a2 a2 --"wdt:P279"--> c5 v3 --"wdt:P31"--> a3 a3 --"wdt:P279"--> c6 v3 --"wdt:P31"--> a4 a4 --"wdt:P279"--> c7 v3 --"wdt:P31"--> a5 a5 --"wdt:P279"--> c8 v3 --"wdt:P6366"--> v4 v3 --"wdt:P31"--> v5 v5 --"rdfs:label"--> v2 bind3[/"count(*)"/] bind3 --as--o v6