Aluxosm
Joined 14 January 2014
About me
|
Works authored by Merlin SheldrakeEdit
#defaultView:Table
SELECT ?item ?itemLabel ?subjectLabel ?publisherLabel ?date ?doi ?pubmed ?pmcid
WHERE
{
?item wdt:P50 wd:Q89428526.
OPTIONAL {?item wdt:P921 ?subject.}
OPTIONAL {?item wdt:P1433 ?publisher.}
OPTIONAL {?item wdt:P577 ?date.}
OPTIONAL {?item wdt:P356 ?doi.}
OPTIONAL {?item wdt:P698 ?pubmed.}
OPTIONAL {?item wdt:P932 ?pmcid.}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?date
Breweries that are abbreviated to ABCEdit
#defaultView:Table
SELECT ?item ?itemLabel ?countryLabel ?localityLabel
WHERE
{
{?item wdt:P31 wd:Q131734} # Is a brewery
UNION
{?item wdt:P31 wd:Q5487333} # or a microbrewery
?item skos:altLabel ?alias. # Get the alias (also known as)
OPTIONAL {?item wdt:P17 ?country}. # Get the country
OPTIONAL {?item wdt:P131 ?locality}. # Get the locality
FILTER(CONTAINS(?alias, "ABC"@en)) # Check that the alias is 'ABC'
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE]"
}
}
ORDER BY ?countryLabel
People who have held a position in the Air Training CorpsEdit
#defaultView:Table
SELECT ?person ?personLabel ?positionLabel ?start_time ?end_time
WHERE
{
?person wdt:P31 wd:Q5 . # human
?person p:P39 [ ps:P39 ?position; pq:P642 wd:Q4698217] . # position held - ? - of - Air Training Corps
OPTIONAL{?person p:P39 [ ps:P39 ?position; pq:P580 ?start_time]} # start time
OPTIONAL{?person p:P39 [ ps:P39 ?position; pq:P582 ?end_time]} # end time
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
}
ORDER BY (?start_time)
Frequency of articles published about Younger DryasEdit
#defaultView:LineChart
SELECT ?year (COUNT (DISTINCT ?a) AS ?count) WHERE {
?a wdt:P31 wd:Q13442814 . # Is a scientific article
?a wdt:P921 wd:Q944279 . # Is mainly about "Younger Dryas"
?a wdt:P577 ?date . # Was published on this date
BIND(str(year(?date)) AS ?year) # Only care about the year published
}
GROUP BY ?year
ORDER BY ?year
Classification of sound recording devicesEdit
For help about classification, see Wikidata:Classification.
- Parent classes (classes of items which contain this one item)
- Subclasses (classes which contain special kinds of items of this class)
- ⟨
sound recording device
⟩ on wikidata tree visualisation (external tool)(depth=1) - Miga external tool (does not work in Firefox) — listing of subclasses, number of super and subclasses, properties of the instances
- ⟨sound recording device⟩ on Miga