Difference between revisions of "Template:Database"

From Wikishire
Jump to: navigation, search
m
Line 260: Line 260:
 
|HCS code=CHE
 
|HCS code=CHE
 
|population 2001=
 
|population 2001=
|population=1,667342
+
|population=1667342
 
}}
 
}}
 
|Clackmannanshire={{#switch:{{{2}}}
 
|Clackmannanshire={{#switch:{{{2}}}
Line 298: Line 298:
 
|Chapman code=
 
|Chapman code=
 
|HCS code=CRT
 
|HCS code=CRT
|population 2001=71,536 (with Ross-shire)
+
|population 2001=71536
|population=71,536 (with Ross-shire)
+
|population=71536
 
}}
 
}}
 
|Cumberland={{#switch:{{{2}}}
 
|Cumberland={{#switch:{{{2}}}
Line 338: Line 338:
 
|HCS code=DRB
 
|HCS code=DRB
 
|population 2001=
 
|population 2001=
|population=1,149180
+
|population=1149180
 
}}
 
}}
 
|Devon={{#switch:{{{2}}}
 
|Devon={{#switch:{{{2}}}
Line 351: Line 351:
 
|HCS code=DVN
 
|HCS code=DVN
 
|population 2001=
 
|population 2001=
|population=1,132439
+
|population=1132439
 
}}
 
}}
 
|Dorset={{#switch:{{{2}}}
 
|Dorset={{#switch:{{{2}}}
Line 418: Line 418:
 
|HCS code=DRH
 
|HCS code=DRH
 
|population 2001=
 
|population 2001=
|population=1,465299
+
|population=1465299
 
}}
 
}}
 
|East Lothian={{#switch:{{{2}}}
 
|East Lothian={{#switch:{{{2}}}
Line 444: Line 444:
 
|HCS code=ESE
 
|HCS code=ESE
 
|population 2001=
 
|population 2001=
|population=2,996635
+
|population=2996635
 
}}
 
}}
 
|Fermanagh={{#switch:{{{2}}}
 
|Fermanagh={{#switch:{{{2}}}
Line 495: Line 495:
 
|Chapman code=GLA
 
|Chapman code=GLA
 
|HCS code=GLM
 
|HCS code=GLM
|population 2001=1,234623
+
|population 2001=1234623
|population=1,321256
+
|population=1321256
 
}}
 
}}
 
|Gloucestershire={{#switch:{{{2}}}
 
|Gloucestershire={{#switch:{{{2}}}
Line 509: Line 509:
 
|HCS code=GLC
 
|HCS code=GLC
 
|population 2001=
 
|population 2001=
|population=1,145686
+
|population=1145686
 
}}
 
}}
 
|Hampshire={{#switch:{{{2}}}
 
|Hampshire={{#switch:{{{2}}}
Line 522: Line 522:
 
|HCS code=HMP
 
|HCS code=HMP
 
|population 2001=
 
|population 2001=
|population=2,097056
+
|population=2097056
 
}}
 
}}
 
|Herefordshire={{#switch:{{{2}}}
 
|Herefordshire={{#switch:{{{2}}}
Line 548: Line 548:
 
|HCS code=HTF
 
|HCS code=HTF
 
|population 2001=
 
|population 2001=
|population=1,156273
+
|population=1156273
 
}}
 
}}
 
|Huntingdonshire={{#switch:{{{2}}}
 
|Huntingdonshire={{#switch:{{{2}}}
Line 587: Line 587:
 
|HCS code=KNT
 
|HCS code=KNT
 
|population 2001=
 
|population 2001=
|population=2,743368
+
|population=2743368
 
}}
 
}}
 
|Kincardineshire={{#switch:{{{2}}}
 
|Kincardineshire={{#switch:{{{2}}}
Line 652: Line 652:
 
|HCS code=LCS
 
|HCS code=LCS
 
|population 2001=
 
|population 2001=
|population=4,940339
+
|population=4940339
 
}}
 
}}
 
|Leicestershire={{#switch:{{{2}}}
 
|Leicestershire={{#switch:{{{2}}}
Line 678: Line 678:
 
|HCS code=
 
|HCS code=
 
|population 2001=
 
|population 2001=
|population=1,039100
+
|population=1039100
 
}}
 
}}
 
|County Londonderry={{#switch:{{{2}}}
 
|County Londonderry={{#switch:{{{2}}}
Line 718: Line 718:
 
|HCS code=MSX
 
|HCS code=MSX
 
|population 2001=
 
|population 2001=
|population=3,995268
+
|population=3995268
 
}}
 
}}
 
|Midlothian={{#switch:{{{2}}}
 
|Midlothian={{#switch:{{{2}}}
Line 835: Line 835:
 
|HCS code=NOT
 
|HCS code=NOT
 
|population 2001=
 
|population 2001=
|population=1,094885
+
|population=1094885
 
}}
 
}}
 
|Orkney={{#switch:{{{2}}}
 
|Orkney={{#switch:{{{2}}}
Line 938: Line 938:
 
|Chapman code=
 
|Chapman code=
 
|HCS code=RSS
 
|HCS code=RSS
|population 2001=71,536 (with Cromartyshire)
+
|population 2001=71536
|population=71,536 (with Cromartyshire)
+
|population=71536
 
}}
 
}}
 
|Roxburghshire={{#switch:{{{2}}}
 
|Roxburghshire={{#switch:{{{2}}}
Line 1,017: Line 1,017:
 
|HCS code=SMS
 
|HCS code=SMS
 
|population 2001=
 
|population 2001=
|population=1,053551
+
|population=1053551
 
}}
 
}}
 
|Staffordshire={{#switch:{{{2}}}
 
|Staffordshire={{#switch:{{{2}}}
Line 1,030: Line 1,030:
 
|HCS code=STF
 
|HCS code=STF
 
|population 2001=
 
|population 2001=
|population=2,159803
+
|population=2159803
 
}}
 
}}
 
|Stirlingshire={{#switch:{{{2}}}
 
|Stirlingshire={{#switch:{{{2}}}
Line 1,069: Line 1,069:
 
|HCS code=SUR
 
|HCS code=SUR
 
|population 2001=
 
|population 2001=
|population=2,975918
+
|population=2975918
 
}}
 
}}
 
|Sussex={{#switch:{{{2}}}
 
|Sussex={{#switch:{{{2}}}
Line 1,081: Line 1,081:
 
|Chapman code=SSX
 
|Chapman code=SSX
 
|HCS code=SUS
 
|HCS code=SUS
|population 2001=1,493755
+
|population 2001=1493755
|population=1,612989
+
|population=1612989
 
}}
 
}}
 
|Sutherland={{#switch:{{{2}}}
 
|Sutherland={{#switch:{{{2}}}
Line 1,121: Line 1,121:
 
|HCS code=WRW
 
|HCS code=WRW
 
|population 2001=
 
|population 2001=
|population=1,631332
+
|population=1631332
 
}}
 
}}
 
|West Lothian={{#switch:{{{2}}}
 
|West Lothian={{#switch:{{{2}}}
Line 1,186: Line 1,186:
 
|HCS code=WRC
 
|HCS code=WRC
 
|population 2001=
 
|population 2001=
|population=1,126058
+
|population=1126058
 
}}
 
}}
 
|Yorkshire={{#switch:{{{2}}}
 
|Yorkshire={{#switch:{{{2}}}
Line 1,199: Line 1,199:
 
|HCS code=YRK
 
|HCS code=YRK
 
|population 2001=
 
|population 2001=
|population=5,216167
+
|population=5216167
 
}}
 
}}
 
|East Riding of Yorkshire={{#switch:{{{2}}}
 
|East Riding of Yorkshire={{#switch:{{{2}}}

Revision as of 12:10, 5 February 2014

Template:Database is a general database constructed as the Mediawiki programme permits, as nested switch functions. The data may be extracted easily whether within an article or in a template.

The database contains counties, territories etc, but also units of measurement, which feed the "Convert" function of Template:Convert.

Examples

The following examples demonstrate how to extract data:

[[File:{{Database|Monmouthshire|flag}}|center|50px]] will give:
Flag of Monmouthshire.svg
{{Database|Monmouthshire|Welsh}} will give: Sir Fynwy

Caution: blank fields

Not every data field is completed nor can be. Care must therefore be taken to ensure that you still achieve the right result in every case.

The first example above but substituting "Ayrshire" in place of "Monmouthshire" would produce an error as there is no Ayrshire flag image, so an {{:if: or {{:ifeq: function should be used where there might be a blank field.