Difference between revisions of "Template:Database"

From Wikishire
Jump to: navigation, search
(Current population. Can be archived to extra fields when newer data available)
Line 11: Line 11:
 
|HCS code=ABN
 
|HCS code=ABN
 
|population 2001=370,716
 
|population 2001=370,716
|population=
+
|population=370,716
 
}}
 
}}
 
|Anglesey={{#switch:{{{2}}}
 
|Anglesey={{#switch:{{{2}}}
Line 37: Line 37:
 
|HCS code=ANG
 
|HCS code=ANG
 
|population 2001=254,911
 
|population 2001=254,911
|population=
+
|population=254,911
 
}}
 
}}
 
|County Antrim={{#switch:{{{2}}}
 
|County Antrim={{#switch:{{{2}}}
Line 64: Line 64:
 
|HCS code=ARG
 
|HCS code=ARG
 
|population 2001=59,862
 
|population 2001=59,862
|population=
+
|population=59,862
 
}}
 
}}
 
|County Armagh={{#switch:{{{2}}}
 
|County Armagh={{#switch:{{{2}}}
Line 91: Line 91:
 
|HCS code=AYS
 
|HCS code=AYS
 
|population 2001=361,657
 
|population 2001=361,657
|population=
+
|population=361,657
 
}}
 
}}
 
|Banffshire={{#switch:{{{2}}}
 
|Banffshire={{#switch:{{{2}}}
Line 104: Line 104:
 
|HCS code=BNF
 
|HCS code=BNF
 
|population 2001=43,924
 
|population 2001=43,924
|population=
+
|population=43,924
 
}}
 
}}
 
|Bedfordshire={{#switch:{{{2}}}
 
|Bedfordshire={{#switch:{{{2}}}
Line 143: Line 143:
 
|HCS code=BRW
 
|HCS code=BRW
 
|population 2001=23,969
 
|population 2001=23,969
|population=
+
|population=23,969
 
}}
 
}}
 
|Brecknockshire={{#switch:{{{2}}}
 
|Brecknockshire={{#switch:{{{2}}}
Line 182: Line 182:
 
|HCS code=BTE
 
|HCS code=BTE
 
|population 2001=13,720
 
|population 2001=13,720
|population=
+
|population=13,720
 
}}
 
}}
 
|Caernarfonshire={{#switch:{{{2}}}
 
|Caernarfonshire={{#switch:{{{2}}}
Line 208: Line 208:
 
|HCS code=CTN
 
|HCS code=CTN
 
|population 2001=25,587
 
|population 2001=25,587
|population=
+
|population=25,587
 
}}
 
}}
 
|Cambridgeshire={{#switch:{{{2}}}
 
|Cambridgeshire={{#switch:{{{2}}}
Line 273: Line 273:
 
|HCS code=CLM
 
|HCS code=CLM
 
|population 2001=47,451
 
|population 2001=47,451
|population=
+
|population=47,451
 
}}
 
}}
 
|Cornwall={{#switch:{{{2}}}
 
|Cornwall={{#switch:{{{2}}}
Line 299: Line 299:
 
|HCS code=CRT
 
|HCS code=CRT
 
|population 2001=71,536 (with Ross-shire)
 
|population 2001=71,536 (with Ross-shire)
|population=
+
|population=71,536 (with Ross-shire)
 
}}
 
}}
 
|Cumberland={{#switch:{{{2}}}
 
|Cumberland={{#switch:{{{2}}}
Line 391: Line 391:
 
|HCS code=DMF
 
|HCS code=DMF
 
|population 2001=74,605
 
|population 2001=74,605
|population=
+
|population=74,605
 
}}
 
}}
 
|Dunbartonshire={{#switch:{{{2}}}
 
|Dunbartonshire={{#switch:{{{2}}}
Line 404: Line 404:
 
|HCS code=DUN
 
|HCS code=DUN
 
|population 2001=280,889
 
|population 2001=280,889
|population=
+
|population=280,889
 
}}
 
}}
 
|County Durham={{#switch:{{{2}}}
 
|County Durham={{#switch:{{{2}}}
Line 431: Line 431:
 
|HCS code=ELT
 
|HCS code=ELT
 
|population 2001=66,097
 
|population 2001=66,097
|population=
+
|population=66,097
 
}}
 
}}
 
|Essex={{#switch:{{{2}}}
 
|Essex={{#switch:{{{2}}}
Line 470: Line 470:
 
|HCS code=FFE
 
|HCS code=FFE
 
|population 2001=349,344
 
|population 2001=349,344
|population=
+
|population=349,344
 
}}
 
}}
 
|Flintshire={{#switch:{{{2}}}
 
|Flintshire={{#switch:{{{2}}}
Line 574: Line 574:
 
|HCS code=INS
 
|HCS code=INS
 
|population 2001=108,465
 
|population 2001=108,465
|population=
+
|population=108,465
 
}}
 
}}
 
|Kent={{#switch:{{{2}}}
 
|Kent={{#switch:{{{2}}}
Line 600: Line 600:
 
|HCS code=KNC
 
|HCS code=KNC
 
|population 2001=51,295
 
|population 2001=51,295
|population=
+
|population=51,295
 
}}
 
}}
 
|Kinross-shire={{#switch:{{{2}}}
 
|Kinross-shire={{#switch:{{{2}}}
Line 613: Line 613:
 
|HCS code=KNR
 
|HCS code=KNR
 
|population 2001=10,967
 
|population 2001=10,967
|population=
+
|population=10,967
 
}}
 
}}
 
|Kirkcudbrightshire={{#switch:{{{2}}}
 
|Kirkcudbrightshire={{#switch:{{{2}}}
Line 626: Line 626:
 
|HCS code=KCB
 
|HCS code=KCB
 
|population 2001=46,206
 
|population 2001=46,206
|population=
+
|population=46,206
 
}}
 
}}
 
|Lanarkshire={{#switch:{{{2}}}
 
|Lanarkshire={{#switch:{{{2}}}
Line 639: Line 639:
 
|HCS code=LNK
 
|HCS code=LNK
 
|population 2001=860,936
 
|population 2001=860,936
|population=
+
|population=860,936
 
}}
 
}}
 
|Lancashire={{#switch:{{{2}}}
 
|Lancashire={{#switch:{{{2}}}
Line 692: Line 692:
 
|HCS code=LDR
 
|HCS code=LDR
 
|population 2001=233,500
 
|population 2001=233,500
|population=
+
|population=233,500
 
}}
 
}}
 
|Merionethshire={{#switch:{{{2}}}
 
|Merionethshire={{#switch:{{{2}}}
Line 731: Line 731:
 
|HCS code=MLT
 
|HCS code=MLT
 
|population 2001=555,418
 
|population 2001=555,418
|population=
+
|population=555,418
 
}}
 
}}
 
|Monmouthshire={{#switch:{{{2}}}
 
|Monmouthshire={{#switch:{{{2}}}
Line 770: Line 770:
 
|HCS code=MOY
 
|HCS code=MOY
 
|population 2001=63,142
 
|population 2001=63,142
|population=
+
|population=63,142
 
}}
 
}}
 
|Nairnshire={{#switch:{{{2}}}
 
|Nairnshire={{#switch:{{{2}}}
Line 783: Line 783:
 
|HCS code=NRN
 
|HCS code=NRN
 
|population 2001=10,980
 
|population 2001=10,980
|population=
+
|population=10,980
 
}}
 
}}
 
|Norfolk={{#switch:{{{2}}}
 
|Norfolk={{#switch:{{{2}}}
Line 848: Line 848:
 
|HCS code=ORN
 
|HCS code=ORN
 
|population 2001=19,245
 
|population 2001=19,245
|population=
+
|population=19,245
 
}}
 
}}
 
|Oxfordshire={{#switch:{{{2}}}
 
|Oxfordshire={{#switch:{{{2}}}
Line 874: Line 874:
 
|HCS code=PBS
 
|HCS code=PBS
 
|population 2001=17,394
 
|population 2001=17,394
|population=
+
|population=17,394
 
}}
 
}}
 
|Pembrokeshire={{#switch:{{{2}}}
 
|Pembrokeshire={{#switch:{{{2}}}
Line 900: Line 900:
 
|HCS code=PRT
 
|HCS code=PRT
 
|population 2001=155,436
 
|population 2001=155,436
|population=
+
|population=155,436
 
}}
 
}}
 
|Radnorshire={{#switch:{{{2}}}
 
|Radnorshire={{#switch:{{{2}}}
Line 926: Line 926:
 
|HCS code=RNF
 
|HCS code=RNF
 
|population 2001=612,369
 
|population 2001=612,369
|population=
+
|population=612,369
 
}}
 
}}
 
|Ross-shire={{#switch:{{{2}}}
 
|Ross-shire={{#switch:{{{2}}}
Line 939: Line 939:
 
|HCS code=RSS
 
|HCS code=RSS
 
|population 2001=71,536 (with Cromartyshire)
 
|population 2001=71,536 (with Cromartyshire)
|population=
+
|population=71,536 (with Cromartyshire)
 
}}
 
}}
 
|Roxburghshire={{#switch:{{{2}}}
 
|Roxburghshire={{#switch:{{{2}}}
Line 952: Line 952:
 
|HCS code=RXB
 
|HCS code=RXB
 
|population 2001=46,302
 
|population 2001=46,302
|population=
+
|population=46,302
 
}}
 
}}
 
|Rutland={{#switch:{{{2}}}
 
|Rutland={{#switch:{{{2}}}
Line 978: Line 978:
 
|HCS code=SKK
 
|HCS code=SKK
 
|population 2001=17,757
 
|population 2001=17,757
|population=
+
|population=17,757
 
}}
 
}}
 
|Shetland={{#switch:{{{2}}}
 
|Shetland={{#switch:{{{2}}}
Line 991: Line 991:
 
|HCS code=SHT
 
|HCS code=SHT
 
|population 2001=21,988
 
|population 2001=21,988
|population=
+
|population=21,988
 
}}
 
}}
 
|Shropshire={{#switch:{{{2}}}
 
|Shropshire={{#switch:{{{2}}}
Line 1,043: Line 1,043:
 
|HCS code=STL
 
|HCS code=STL
 
|population 2001=208,267
 
|population 2001=208,267
|population=
+
|population=208,267
 
}}
 
}}
 
|Suffolk={{#switch:{{{2}}}
 
|Suffolk={{#switch:{{{2}}}
Line 1,095: Line 1,095:
 
|HCS code=SRL
 
|HCS code=SRL
 
|population 2001=12,408
 
|population 2001=12,408
|population=
+
|population=12,408
 
}}
 
}}
 
|Tyrone={{#switch:{{{2}}}
 
|Tyrone={{#switch:{{{2}}}
Line 1,108: Line 1,108:
 
|HCS code=TYN
 
|HCS code=TYN
 
|population 2001=166,516
 
|population 2001=166,516
|population=
+
|population=166,516
 
}}
 
}}
 
|Warwickshire={{#switch:{{{2}}}
 
|Warwickshire={{#switch:{{{2}}}
Line 1,134: Line 1,134:
 
|HCS code=WLT
 
|HCS code=WLT
 
|population 2001=172,341
 
|population 2001=172,341
|population=
+
|population=172,341
 
}}
 
}}
 
|Westmorland={{#switch:{{{2}}}
 
|Westmorland={{#switch:{{{2}}}
Line 1,160: Line 1,160:
 
|HCS code=WGT
 
|HCS code=WGT
 
|population 2001=26,827
 
|population 2001=26,827
|population=
+
|population=26,827
 
}}
 
}}
 
|Wiltshire={{#switch:{{{2}}}
 
|Wiltshire={{#switch:{{{2}}}
Line 1,210: Line 1,210:
 
|HCS code=
 
|HCS code=
 
|population 2001=
 
|population 2001=
|population=
+
|population=-
 
}}
 
}}
 
|North Riding of Yorkshire={{#switch:{{{2}}}
 
|North Riding of Yorkshire={{#switch:{{{2}}}
Line 1,221: Line 1,221:
 
|HCS code=
 
|HCS code=
 
|population 2001=
 
|population 2001=
|population=
+
|population=-
 
}}
 
}}
 
|West Riding of Yorkshire={{#switch:{{{2}}}
 
|West Riding of Yorkshire={{#switch:{{{2}}}
Line 1,232: Line 1,232:
 
|HCS code=
 
|HCS code=
 
|population 2001=
 
|population 2001=
|population=
+
|population=-
 
}}
 
}}
 
|County Carlow={{#switch:{{{2}}}
 
|County Carlow={{#switch:{{{2}}}

Revision as of 15:17, 4 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.