International Museum Day 2021/Wikidata Competition/List 1: Difference between revisions

Click on the looking glass next to a property you want to focus on. In this example, we want to find libraries in Albania without a located in the administrative territorial entity (P131) statement.

On the following page, select All items without the property set.

This will take you to the Wikidata Query Service, with a pre-filled SPARQL query. Execute it by clicking on the blue triangle button on the left side of the screen.

The results are a list of Wikidata items of libraries in Albania without a located in the administrative territorial entity (P131) statement.

Manually update

all entities | count | all groupings | without grouping property | below threshold (5)

Top groupings (Minimum 5 items)		Top Properties (used at least 0 times per grouping)
Name	Count	українська
Argentina (Q414)	1338	0.9% (12) 🔍
Totals (all items)	1432	1.26% (18) 🔍

@@ Line 20: / Line 20: @@
 <onlyinclude>
 {{Property dashboard
-|selector_sparql=(wdt:P31/(wdt:P279*)) wd:Q33506;  wdt:P17 ?countries FILTER (?countries IN (wd:Q40, wd:Q183, wd:Q142, wd:Q39, wd:Q38))
+|selector_sparql=(wdt:P31/(wdt:P279*)) wd:Q33506;  wdt:P17 ?countries FILTER (?countries IN (wd:Q414))
 |grouping_property=P17
 |grouping_threshold=5
-|properties=Len,Lfr,Lde,Lde-at,Lde-ch,Lit,Lrm
+|properties=Luk
 }}
 {| class="wikitable sortable"
 ! colspan="2" |Top groupings (Minimum 5 items)
-! colspan="7"|Top Properties (used at least 0 times per grouping)
+! colspan="1"|Top Properties (used at least 0 times per grouping)
 |-
 ! Name
 ! Count
-! data-sort-type="number"|{{#language:en}}
+! data-sort-type="number"|{{#language:uk}}
-! data-sort-type="number"|{{#language:fr}}
-! data-sort-type="number"|{{#language:de}}
-! data-sort-type="number"|{{#language:de-at}}
-! data-sort-type="number"|{{#language:de-ch}}
-! data-sort-type="number"|{{#language:it}}
-! data-sort-type="number"|{{#language:rm}}
 |-
-| {{Q|Q183}}
+| {{Q|Q414}}
-| 7580
+| 1338
-| {{Integraality cell|39.78|3015|column=Len|grouping=Q183}}
+| {{Integraality cell|0.9|12|column=Luk|grouping=Q414}}
-| {{Integraality cell|11.81|895|column=Lfr|grouping=Q183}}
-| {{Integraality cell|99.89|7572|column=Lde|grouping=Q183}}
-| {{Integraality cell|0.29|22|column=Lde-at|grouping=Q183}}
-| {{Integraality cell|0.77|58|column=Lde-ch|grouping=Q183}}
-| {{Integraality cell|6.03|457|column=Lit|grouping=Q183}}
-| {{Integraality cell|0.33|25|column=Lrm|grouping=Q183}}
-|-
-| {{Q|Q38}}
-| 6199
-| {{Integraality cell|57.44|3561|column=Len|grouping=Q38}}
-| {{Integraality cell|19.29|1196|column=Lfr|grouping=Q38}}
-| {{Integraality cell|15.49|960|column=Lde|grouping=Q38}}
-| {{Integraality cell|0.02|1|column=Lde-at|grouping=Q38}}
-| {{Integraality cell|0.15|9|column=Lde-ch|grouping=Q38}}
-| {{Integraality cell|99.85|6190|column=Lit|grouping=Q38}}
-| {{Integraality cell|0.05|3|column=Lrm|grouping=Q38}}
-|-
-| {{Q|Q142}}
-| 2647
-| {{Integraality cell|67.7|1792|column=Len|grouping=Q142}}
-| {{Integraality cell|99.7|2639|column=Lfr|grouping=Q142}}
-| {{Integraality cell|21.68|574|column=Lde|grouping=Q142}}
-| {{Integraality cell|0.15|4|column=Lde-at|grouping=Q142}}
-| {{Integraality cell|0.53|14|column=Lde-ch|grouping=Q142}}
-| {{Integraality cell|15.26|404|column=Lit|grouping=Q142}}
-| {{Integraality cell|0.19|5|column=Lrm|grouping=Q142}}
-|-
-| {{Q|Q40}}
-| 1660
-| {{Integraality cell|77.41|1285|column=Len|grouping=Q40}}
-| {{Integraality cell|10.54|175|column=Lfr|grouping=Q40}}
-| {{Integraality cell|99.94|1659|column=Lde|grouping=Q40}}
-| {{Integraality cell|45.48|755|column=Lde-at|grouping=Q40}}
-| {{Integraality cell|0.6|10|column=Lde-ch|grouping=Q40}}
-| {{Integraality cell|7.47|124|column=Lit|grouping=Q40}}
-| {{Integraality cell|0|0|column=Lrm|grouping=Q40}}
-|-
-| {{Q|Q39}}
-| 1358
-| {{Integraality cell|46.47|631|column=Len|grouping=Q39}}
-| {{Integraality cell|36.97|502|column=Lfr|grouping=Q39}}
-| {{Integraality cell|95.07|1291|column=Lde|grouping=Q39}}
-| {{Integraality cell|0.15|2|column=Lde-at|grouping=Q39}}
-| {{Integraality cell|0.37|5|column=Lde-ch|grouping=Q39}}
-| {{Integraality cell|19.07|259|column=Lit|grouping=Q39}}
-| {{Integraality cell|0.59|8|column=Lrm|grouping=Q39}}
 |- class="sortbottom"
-|'''Totals''' <small>(all items)</small>:
+| '''Totals''' <small>(all items)</small>
-| 20371
+| 1432
-| {{Integraality cell|54.49|11100|column=Len}}
+| {{Integraality cell|1.26|18|column=Luk|grouping=}}
-| {{Integraality cell|29.05|5918|column=Lfr}}
-| {{Integraality cell|62.41|12713|column=Lde}}
-| {{Integraality cell|4.04|823|column=Lde-at}}
-| {{Integraality cell|0.51|103|column=Lde-ch}}
-| {{Integraality cell|39.01|7947|column=Lit}}
-| {{Integraality cell|0.22|45|column=Lrm}}
 |}