Difference between revisions of "Template:Database"
From Wikishire
| Line 24: | Line 24: | ||
|HCS code=AGL | |HCS code=AGL | ||
|population 2001=66,829 | |population 2001=66,829 | ||
| − | |population 2011= | + | |population 2011=69,744 |
}} | }} | ||
|Angus={{#switch:{{{2}}} | |Angus={{#switch:{{{2}}} | ||
| Line 117: | Line 117: | ||
|HCS code=BED | |HCS code=BED | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=602,912 |
}} | }} | ||
|Berkshire={{#switch:{{{2}}} | |Berkshire={{#switch:{{{2}}} | ||
| Line 130: | Line 130: | ||
|HCS code=BER | |HCS code=BER | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=841,828 |
}} | }} | ||
|Berwickshire={{#switch:{{{2}}} | |Berwickshire={{#switch:{{{2}}} | ||
| Line 156: | Line 156: | ||
|HCS code=BRN | |HCS code=BRN | ||
|population 2001=55,570 | |population 2001=55,570 | ||
| − | |population 2011= | + | |population 2011=68,088 |
}} | }} | ||
|Buckinghamshire={{#switch:{{{2}}} | |Buckinghamshire={{#switch:{{{2}}} | ||
| Line 169: | Line 169: | ||
|HCS code=BUC | |HCS code=BUC | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=916,262 |
}} | }} | ||
|Buteshire={{#switch:{{{2}}} | |Buteshire={{#switch:{{{2}}} | ||
| Line 195: | Line 195: | ||
|HCS code=CRN | |HCS code=CRN | ||
|population 2001=127,857 | |population 2001=127,857 | ||
| − | |population 2011= | + | |population 2011=137,048 |
}} | }} | ||
|Caithness={{#switch:{{{2}}} | |Caithness={{#switch:{{{2}}} | ||
| Line 221: | Line 221: | ||
|HCS code=CMB | |HCS code=CMB | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=460,621 |
}} | }} | ||
|Cardiganshire={{#switch:{{{2}}} | |Cardiganshire={{#switch:{{{2}}} | ||
| Line 234: | Line 234: | ||
|HCS code=CRG | |HCS code=CRG | ||
|population 2001=74,941 | |population 2001=74,941 | ||
| − | |population 2011= | + | |population 2011=75,270 |
}} | }} | ||
|Carmarthenshire={{#switch:{{{2}}} | |Carmarthenshire={{#switch:{{{2}}} | ||
| Line 247: | Line 247: | ||
|HCS code=CRM | |HCS code=CRM | ||
|population 2001=172,842 | |population 2001=172,842 | ||
| − | |population 2011= | + | |population 2011=184,407 |
}} | }} | ||
|Cheshire={{#switch:{{{2}}} | |Cheshire={{#switch:{{{2}}} | ||
| Line 260: | Line 260: | ||
|HCS code=CHE | |HCS code=CHE | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=1,667,342 |
}} | }} | ||
|Clackmannanshire={{#switch:{{{2}}} | |Clackmannanshire={{#switch:{{{2}}} | ||
| Line 286: | Line 286: | ||
|HCS code=CNW | |HCS code=CNW | ||
|population 2001=499,114 | |population 2001=499,114 | ||
| − | |population 2011= | + | |population 2011=531,446 |
}} | }} | ||
|Cromartyshire={{#switch:{{{2}}} | |Cromartyshire={{#switch:{{{2}}} | ||
| Line 312: | Line 312: | ||
|HCS code=CUM | |HCS code=CUM | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=306,144 |
}} | }} | ||
|Denbighshire={{#switch:{{{2}}} | |Denbighshire={{#switch:{{{2}}} | ||
| Line 325: | Line 325: | ||
|HCS code=DBH | |HCS code=DBH | ||
|population 2001=217,132 | |population 2001=217,132 | ||
| − | |population 2011= | + | |population 2011=228,781 |
}} | }} | ||
|Derbyshire={{#switch:{{{2}}} | |Derbyshire={{#switch:{{{2}}} | ||
| Line 338: | Line 338: | ||
|HCS code=DRB | |HCS code=DRB | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=1,149,180 |
}} | }} | ||
|Devon={{#switch:{{{2}}} | |Devon={{#switch:{{{2}}} | ||
| Line 351: | Line 351: | ||
|HCS code=DVN | |HCS code=DVN | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=1,132,439 |
}} | }} | ||
|Dorset={{#switch:{{{2}}} | |Dorset={{#switch:{{{2}}} | ||
| Line 364: | Line 364: | ||
|HCS code=DRS | |HCS code=DRS | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=542,581 |
}} | }} | ||
|County Down={{#switch:{{{2}}} | |County Down={{#switch:{{{2}}} | ||
| Line 418: | Line 418: | ||
|HCS code=DRH | |HCS code=DRH | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=1,465,299 |
}} | }} | ||
|East Lothian={{#switch:{{{2}}} | |East Lothian={{#switch:{{{2}}} | ||
| Line 444: | Line 444: | ||
|HCS code=ESE | |HCS code=ESE | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=2,996,635 |
}} | }} | ||
|Fermanagh={{#switch:{{{2}}} | |Fermanagh={{#switch:{{{2}}} | ||
| Line 483: | Line 483: | ||
|HCS code=FLT | |HCS code=FLT | ||
|population 2001=212,718 | |population 2001=212,718 | ||
| − | |population 2011= | + | |population 2011=216,236 |
}} | }} | ||
|Glamorgan={{#switch:{{{2}}} | |Glamorgan={{#switch:{{{2}}} | ||
| Line 495: | Line 495: | ||
|Chapman code=GLA | |Chapman code=GLA | ||
|HCS code=GLM | |HCS code=GLM | ||
| − | |population 2001=1, | + | |population 2001=1,234,623 |
| − | |population 2011= | + | |population 2011=1,321,256 |
}} | }} | ||
|Gloucestershire={{#switch:{{{2}}} | |Gloucestershire={{#switch:{{{2}}} | ||
| Line 509: | Line 509: | ||
|HCS code=GLC | |HCS code=GLC | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=1,145,686 |
}} | }} | ||
|Hampshire={{#switch:{{{2}}} | |Hampshire={{#switch:{{{2}}} | ||
| Line 522: | Line 522: | ||
|HCS code=HMP | |HCS code=HMP | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=2,097,056 |
}} | }} | ||
|Herefordshire={{#switch:{{{2}}} | |Herefordshire={{#switch:{{{2}}} | ||
| Line 535: | Line 535: | ||
|HCS code=HRF | |HCS code=HRF | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=183,649 |
}} | }} | ||
|Hertfordshire={{#switch:{{{2}}} | |Hertfordshire={{#switch:{{{2}}} | ||
| Line 548: | Line 548: | ||
|HCS code=HTF | |HCS code=HTF | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=1,156,273 |
}} | }} | ||
|Huntingdonshire={{#switch:{{{2}}} | |Huntingdonshire={{#switch:{{{2}}} | ||
| Line 561: | Line 561: | ||
|HCS code=HNT | |HCS code=HNT | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=212,311 |
}} | }} | ||
|Inverness-shire={{#switch:{{{2}}} | |Inverness-shire={{#switch:{{{2}}} | ||
| Line 587: | Line 587: | ||
|HCS code=KNT | |HCS code=KNT | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=2,743,368 |
}} | }} | ||
|Kincardineshire={{#switch:{{{2}}} | |Kincardineshire={{#switch:{{{2}}} | ||
| Line 652: | Line 652: | ||
|HCS code=LCS | |HCS code=LCS | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=4,940,339 |
}} | }} | ||
|Leicestershire={{#switch:{{{2}}} | |Leicestershire={{#switch:{{{2}}} | ||
| Line 665: | Line 665: | ||
|HCS code=LCR | |HCS code=LCR | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=974,560 |
}} | }} | ||
|Lincolnshire={{#switch:{{{2}}} | |Lincolnshire={{#switch:{{{2}}} | ||
| Line 678: | Line 678: | ||
|HCS code= | |HCS code= | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=1,039,100 |
}} | }} | ||
|County Londonderry={{#switch:{{{2}}} | |County Londonderry={{#switch:{{{2}}} | ||
| Line 705: | Line 705: | ||
|HCS code=MRN | |HCS code=MRN | ||
|population 2001=37,260 | |population 2001=37,260 | ||
| − | |population 2011= | + | |population 2011=37,835 |
}} | }} | ||
|Middlesex={{#switch:{{{2}}} | |Middlesex={{#switch:{{{2}}} | ||
| Line 718: | Line 718: | ||
|HCS code=MSX | |HCS code=MSX | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=3,995,268 |
}} | }} | ||
|Midlothian={{#switch:{{{2}}} | |Midlothian={{#switch:{{{2}}} | ||
| Line 744: | Line 744: | ||
|HCS code=MNM | |HCS code=MNM | ||
|population 2001=503,917 | |population 2001=503,917 | ||
| − | |population 2011= | + | |population 2011=514,291 |
}} | }} | ||
|Montgomeryshire={{#switch:{{{2}}} | |Montgomeryshire={{#switch:{{{2}}} | ||
| Line 757: | Line 757: | ||
|HCS code=MTG | |HCS code=MTG | ||
|population 2001=59,474 | |population 2001=59,474 | ||
| − | |population 2011= | + | |population 2011=62,030 |
}} | }} | ||
|Morayshire={{#switch:{{{2}}} | |Morayshire={{#switch:{{{2}}} | ||
| Line 796: | Line 796: | ||
|HCS code=NRF | |HCS code=NRF | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=807,704 |
}} | }} | ||
|Northamptonshire={{#switch:{{{2}}} | |Northamptonshire={{#switch:{{{2}}} | ||
| Line 809: | Line 809: | ||
|HCS code=NHP | |HCS code=NHP | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=837,968 |
}} | }} | ||
|Northumberland={{#switch:{{{2}}} | |Northumberland={{#switch:{{{2}}} | ||
| Line 822: | Line 822: | ||
|HCS code=NHB | |HCS code=NHB | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=796,642 |
}} | }} | ||
|Nottinghamshire={{#switch:{{{2}}} | |Nottinghamshire={{#switch:{{{2}}} | ||
| Line 835: | Line 835: | ||
|HCS code=NOT | |HCS code=NOT | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=1,094,885 |
}} | }} | ||
|Orkney={{#switch:{{{2}}} | |Orkney={{#switch:{{{2}}} | ||
| Line 861: | Line 861: | ||
|HCS code=OXD | |HCS code=OXD | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=513,406 |
}} | }} | ||
|Peeblesshire={{#switch:{{{2}}} | |Peeblesshire={{#switch:{{{2}}} | ||
| Line 887: | Line 887: | ||
|HCS code=PMB | |HCS code=PMB | ||
|population 2001=114,131 | |population 2001=114,131 | ||
| − | |population 2011= | + | |population 2011=122,436 |
}} | }} | ||
|Perthshire={{#switch:{{{2}}} | |Perthshire={{#switch:{{{2}}} | ||
| Line 913: | Line 913: | ||
|HCS code=RDN | |HCS code=RDN | ||
|population 2001=24,805 | |population 2001=24,805 | ||
| − | |population 2011= | + | |population 2011=25,813 |
}} | }} | ||
|Renfrewshire={{#switch:{{{2}}} | |Renfrewshire={{#switch:{{{2}}} | ||
| Line 965: | Line 965: | ||
|HCS code=RTL | |HCS code=RTL | ||
|population 2001=34,563 | |population 2001=34,563 | ||
| − | |population 2011= | + | |population 2011=37,502 |
}} | }} | ||
|Selkirkshire={{#switch:{{{2}}} | |Selkirkshire={{#switch:{{{2}}} | ||
| Line 1,004: | Line 1,004: | ||
|HCS code=SHP | |HCS code=SHP | ||
|population 2001=441,498 | |population 2001=441,498 | ||
| − | |population 2011= | + | |population 2011=471,975 |
}} | }} | ||
|Somerset={{#switch:{{{2}}} | |Somerset={{#switch:{{{2}}} | ||
| Line 1,017: | Line 1,017: | ||
|HCS code=SMS | |HCS code=SMS | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=1,053,551 |
}} | }} | ||
|Staffordshire={{#switch:{{{2}}} | |Staffordshire={{#switch:{{{2}}} | ||
| Line 1,030: | Line 1,030: | ||
|HCS code=STF | |HCS code=STF | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=2,159,803 |
}} | }} | ||
|Stirlingshire={{#switch:{{{2}}} | |Stirlingshire={{#switch:{{{2}}} | ||
| Line 1,056: | Line 1,056: | ||
|HCS code=SFF | |HCS code=SFF | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=776,068 |
}} | }} | ||
|Surrey={{#switch:{{{2}}} | |Surrey={{#switch:{{{2}}} | ||
| Line 1,069: | Line 1,069: | ||
|HCS code=SUR | |HCS code=SUR | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=2,975,918 |
}} | }} | ||
|Sussex={{#switch:{{{2}}} | |Sussex={{#switch:{{{2}}} | ||
| Line 1,082: | Line 1,082: | ||
|HCS code=SUS | |HCS code=SUS | ||
|population 2001=1,493,755 | |population 2001=1,493,755 | ||
| − | |population 2011= | + | |population 2011=1,612,989 |
}} | }} | ||
|Sutherland={{#switch:{{{2}}} | |Sutherland={{#switch:{{{2}}} | ||
| Line 1,121: | Line 1,121: | ||
|HCS code=WRW | |HCS code=WRW | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=1,631,332 |
}} | }} | ||
|West Lothian={{#switch:{{{2}}} | |West Lothian={{#switch:{{{2}}} | ||
| Line 1,147: | Line 1,147: | ||
|HCS code=WML | |HCS code=WML | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=87,661 |
}} | }} | ||
|Wigtownshire={{#switch:{{{2}}} | |Wigtownshire={{#switch:{{{2}}} | ||
| Line 1,173: | Line 1,173: | ||
|HCS code=WTS | |HCS code=WTS | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=682,232 |
}} | }} | ||
|Worcestershire={{#switch:{{{2}}} | |Worcestershire={{#switch:{{{2}}} | ||
| Line 1,186: | Line 1,186: | ||
|HCS code=WRC | |HCS code=WRC | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=1,126,058 |
}} | }} | ||
|Yorkshire={{#switch:{{{2}}} | |Yorkshire={{#switch:{{{2}}} | ||
| Line 1,199: | Line 1,199: | ||
|HCS code=YRK | |HCS code=YRK | ||
|population 2001= | |population 2001= | ||
| − | |population 2011= | + | |population 2011=5,216,167 |
}} | }} | ||
|East Riding of Yorkshire={{#switch:{{{2}}} | |East Riding of Yorkshire={{#switch:{{{2}}} | ||
Revision as of 13:13, 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: |  |
| {{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.
