Talk:Q3112446
Jump to navigation
Jump to search
Autodescription — Government of the 3rd Scottish Parliament (Q3112446)
description: Scottish Government led by Alex Salmond from 2007 to 2011
- Useful links:
- View it! – Images depicting the item on Commons
- Report on constraint conformation of “Government of the 3rd Scottish Parliament” claims and statements. Constraints report for items data
Generic queries for organizations
This section is generated using {{TP organization}}
- List of organizations which have Government of the 3rd Scottish Parliament as parent organization (P749) (query)
- List of organizations of which Government of the 3rd Scottish Parliament is a subsidiary (P355) (query)
- Queries based on employer (P108)
- Queries based on member of (P463)
- See also: WikiProject Organizations
- See also EntitySchema for organizations: E98
- See also
- This documentation is generated using
{{Item documentation}}.
Members[edit]
 | Warning: This table is generated automatically. Please make adjustments by editing statements on the relevant item page, not by editing the table below. The list will be refreshed daily (or you can trigger a manual update to see any changes you've made). |
This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!
WDQS | PetScan | TABernacle | Find images | Recent changes | Query:SELECT DISTINCT ?item ?who ?mem_start ?mem_end { wd:Q3112446 wdt:P2670 ?item ; wdt:P571 ?cabinet_start; wdt:P576 ?cabinet_end . OPTIONAL { ?who p:P39 [ ps:P39 ?item ; pq:P580 ?mem_start; pq:P582 ?mem_end ] . FILTER ( (?mem_end > ?cabinet_start) && (?mem_start < ?cabinet_end) ) } }| Article | ?who | ?mem_start | ?mem_end |
|---|---|---|---|
| Cabinet Secretary for Education and Lifelong Learning | Michael Russell Fiona Hyslop |
2009-12-01 2007-05-17 |
2014-11-19 2009-12-01 |
| Cabinet Secretary for Finance and Sustainable Growth | John Swinney | 2007-05-17 | 2011-05-19 |
| Cabinet Secretary for Health and Wellbeing | Nicola Sturgeon | 2007-05-17 | 2011-05-19 |
| Cabinet Secretary for Justice | Kenny MacAskill | 2007-05-17 | 2014-11-19 |
| Cabinet Secretary for Rural Affairs and the Environment | Richard Lochhead | 2011-05-18 2007-05-17 |
2014-11-21 2011-05-18 |
| Deputy First Minister of Scotland | Nicol Stephen, Baron Stephen Nicola Sturgeon |
2005-06-27 2007-05-17 |
2007-05-17 2014-11-19 |
| First Minister of Scotland | Alex Salmond | 2007-05-16 | 2014-11-19 |
End of automatically generated list.
---
The underlying query behind this report is:
SELECT DISTINCT ?position ?positionLabel ?cabinet_start ?cabinet_end ?who ?whoLabel ?mem_start ?mem_end {
wd:Q3112446 wdt:P2670 ?position ; wdt:P571 ?cabinet_start; wdt:P576 ?cabinet_end .
OPTIONAL {
?who p:P39 [ ps:P39 ?position ; pq:P580 ?mem_start; pq:P582 ?mem_end ] .
FILTER ( (?mem_end > ?cabinet_start) && (?mem_start < ?cabinet_end) )
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}
ORDER BY ?positionLabel ?mem_start