User:Charles Matthews/Training supporting links2
Jump to navigation
Jump to search
Try it!
Talk
[edit]- David Beckham (Q10520)
- David Beckham in Reasonator view
- Histropedia, Women scientists
- en:Category:French women engineers - example of "non-diffusing category", but not well-populated
- en:Category talk:American women novelists - there was media attention to categorisation in 2013
- Property talk:P21 – community discussion of sex or gender (P21)
- trans woman (Q1052281) models Try it!
SELECT ?item ?itemLabel WHERE { ?item wdt:P21 wd:Q1052281 . ?item wdt:P106 wd:Q4610556 . SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } }
- Cambridge in Reasonator view, SQID view, Beijing, SQID view
- Inventaire.io
- Cathedrals
- Libraries of the world, first pass, Second pass,
- UL on Wikidata
- Subclasses of library (Q7075) Try it!
SELECT ?item ?itemLabel WHERE { ?item wdt:P279 wd:Q7075 . SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } }
- WikiShootMe tool
- WMUK blogpost by John Lubbock: WikiShootMe and Bunhill Fields
- Panama Papers packed bubble chart, Listeria list
Hands-on session
[edit]Data entry
[edit]Number | Description | Query | Hits as of 29 June 2017, comments |
---|---|---|---|
1 | Encyclopædia Britannica Online ID (P1417), no gender | SELECT ?item ?itemLabel WHERE {
?item wdt:P1417 [] .
?item wdt:P31 wd:Q5 .
OPTIONAL { ?item wdt:P21 ?dummy0 }
FILTER(!bound(?dummy0))
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
|
10 |
2 | Trilogies without genre | SELECT ?item ?itemLabel WHERE {
?item wdt:P31 wd:Q149010 .
OPTIONAL { ?item wdt:P136 ?dummy0 }
FILTER(!bound(?dummy0))
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
|
11 |
3 | Villages with image but without country | SELECT ?item ?itemLabel ?image WHERE {
?item wdt:P31 wd:Q532 .
?item wdt:P18 ?image
OPTIONAL { ?item wdt:P17 ?dummy0 }
FILTER(!bound(?dummy0))
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
|
166 |
4 | Schools with image but without located in the administrative territorial entity (P131) | SELECT ?item ?itemLabel ?image WHERE {
?item wdt:P31 wd:Q3914 .
?item wdt:P18 ?image .
OPTIONAL { ?item wdt:P131 ?dummy0 }
FILTER(!bound(?dummy0))
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
|
399 |
5 | Italian films without director | SELECT ?item ?itemLabel WHERE {
?item wdt:P31 wd:Q11424 .
?item wdt:P495 wd:Q38 .
OPTIONAL { ?item wdt:P57 ?dummy0 }
FILTER(!bound(?dummy0))
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
|
889 |
6 | Historic houses without image | SELECT ?item ?itemLabel WHERE {
?item wdt:P31 wd:Q5773747 .
OPTIONAL { ?item wdt:P18 ?dummy0 }
FILTER(!bound(?dummy0))
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
|
1K, Timeline for all historic houses based on inception date |
7 | Members of the UK Parliament with National Portrait Gallery (London) person ID (P1816) but without image | SELECT ?item ?itemLabel WHERE {
?item wdt:P39 wd:Q16707842 .
?item wdt:P1816 [ ]
OPTIONAL { ?item wdt:P18 ?dummy0 }
FILTER(!bound(?dummy0))
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
|
1862 |
8 | Islands with image but without Commons category | SELECT ?item ?itemLabel ?image WHERE {
?item wdt:P31 wd:Q23442 .
?item wdt:P18 ?image
OPTIONAL { ?item wdt:P373 ?dummy0 }
FILTER(!bound(?dummy0))
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
|
2.6K |
9 | Novels without author | SELECT ?item ?itemLabel WHERE {
?item wdt:P31 wd:Q571 .
?item wdt:P136 wd:Q8261 .
OPTIONAL { ?item wdt:P50 ?dummy0 }
FILTER(!bound(?dummy0))
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
|
2.6K |
10 | French females without occupation | SELECT ?item ?itemLabel WHERE {
?item wdt:P21 wd:Q6581072 .
?item wdt:P27 wd:Q142 .
OPTIONAL { ?item wdt:P106 ?dummy0 }
FILTER(!bound(?dummy0))
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
|
2.9K, Timeline based on date of death |
11 | Battles without point in time (P585) | SELECT ?item ?itemLabel WHERE {
?item wdt:P31 wd:Q178561 .
OPTIONAL { ?item wdt:P585 ?dummy0 }
FILTER(!bound(?dummy0))
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
|
7K |
12 | Paintings without creator | SELECT ?item ?itemLabel WHERE {
?item wdt:P31 wd:Q3305213 .
OPTIONAL { ?item wdt:P170 ?dummy0 }
FILTER(!bound(?dummy0))
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
|
22K |
Placenames
[edit]#defaultView:Map
SELECT ?item ?itemLabel ?coord
WHERE
{
?item wdt:P31/wdt:P279* wd:Q486972;
wdt:P17 wd:Q145;
rdfs:label ?itemLabel;
wdt:P625 ?coord;
FILTER (lang(?itemLabel) = "en") .
FILTER regex (?itemLabel, "(by)$").
}
Fill a Venn diagram via SPARQL
[edit]WD-FIST
[edit]Subclasses
[edit]- Try it!
SELECT ?person ?occupation ?personLabel ?occupationLabel { ?person wdt:P31 wd:Q5 . ?person wdt:P21 wd:Q6581072 . ?person wdt:P27 wd:Q142 . ?person wdt:P106 ?occupation . ?occupation wdt:P279* wd:Q81096 . SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } }