Talk:Q7309443

From Wikidata
Jump to navigation Jump to search

Autodescription — registration county (Q7309443)

description: former statistical unit in Great Britain and Ireland
Useful links:
Classification of the class registration county (Q7309443)  View with Reasonator View with SQID
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)
registration county⟩ on wikidata tree visualisation (external tool)(depth=1)
Generic queries for classes
See also

United Kingdom and Ireland

historic county or not in Scotland[edit]

When requesting a list of historic counties in the UK I got some Scottish entries twice because registration county (Q7309443) is a shire of Scotland (Q1350181) which is a historic county of the United Kingdom (Q67376938) but some council areas which are not the historic county entries are considered to be a registration county (Q7309443). Could someone who knows more about Scottish administrative regions ensure that

SELECT DISTINCT ?item ?itemLabel ?itemDescription WHERE {
 SERVICE wikibase:label { bd:serviceParam wikibase:language "en-GB,en". } 
  { 
    SELECT DISTINCT ?item WHERE { 
      ?item p:P31 ?statement0. 
      ?statement0 (ps:P31/(wdt:P279*)) wd:Q67770276. 
      ?item p:P17 ?statement1. 
      ?statement1 (ps:P17/(wdt:P279*)) wd:Q145. 
    } 
  } 
}
Try it!

only reports one of each pair below

Clackmannanshire@Q207268@Scottish council area 
Clackmannanshire@Q67393019@historic county of Scotland

Angus@Q202177@council area of Scotland 
Angus@Q67387310@historic county of Scotland
 
Dunbartonshire@Q140090@lieutenancy area and registration county in the west central Lowlands of Scotland 
Dunbartonshire@Q17582129@historic county of Scotland
 
East Lothian@Q207257@council area of Scotland; lieutenancy area 
East Lothian@Q66224885@historic county of Scotland
 
Fife@Q201149@council area of Scotland 
Fife@Q67479974@historic county in Scotland
 
Midlothian@Q206934@council area of Scotland 
Midlothian@Q67317221@historic county of Scotland

Perthshire@Q1247411@registration county in central Scotland 
Perthshire@Q67442430@historic county of Scotland
 

Renfrewshire@Q1249400@lieutenancy area of Scotland 
Renfrewshire@Q20723659@historic county of Scotland
 

West Lothian@Q204940@Scottish council area 
West Lothian@Q67317108@historic county of Scotland

and I don't think these are historic counties

County of the City of Aberdeen@Q104631615@the area administered by the Corporation of the City of Aberdeen, from 1900 to 1975
County of the City of Dundee@Q104632042@the area administered by the Corporation of the City of Dundee, from 1894 to 1975
County of the City of Edinburgh@Q104631138@The area administered by the Corporation of the City of Edinburgh, from 1900 to 1975
County of the City of Glasgow@Q77607750@the area administered by the Corporation of the City of Glasgow, from 1893 to 1975
Vicarage (talk) 15:42, 6 December 2022 (UTC)[reply]