Table prototype
Table example 1
Sourced from: UK consumer price inflation: May 2017
Table 1: CPIH, OOH component and CPI index values and 12-month rates: May 2016 to May 2017
UK | |||||||
---|---|---|---|---|---|---|---|
Year | Month | CPIH Index1,2 (UK, 2015 = 100) | CPIH 12- month2 rate | CPI Index1 (UK, 2015=100) | CPI 12- month rate | OOH Index 1,2 (UK, 2015=100) | OOH 12- month2 rate |
2016 | May | 100.8 | 0.7 | 100.4 | 0.3 | 102.1 | 2.3 |
Jun | 101.0 | 0.8 | 100.6 | 0.5 | 102.2 | 2.3 | |
Jul | 100.9 | 0.9 | 100.6 | 0.6 | 102.4 | 2.4 | |
Aug | 101.2 | 1.0 | 100.9 | 0.6 | 102.7 | 2.4 | |
Sep | 101.5 | 1.3 | 101.1 | 1.0 | 102.8 | 2.4 | |
Oct | 101.6 | 1.3 | 101.2 | 0.9 | 103.2 | 2.7 | |
Nov | 101.8 | 1.5 | 101.4 | 1.2 | 103.4 | 2.6 | |
Dec | 102.2 | 1.8 | 101.9 | 1.6 | 103.6 | 2.6 | |
2017 | Jan | 101.8 | 1.9 | 101.4 | 1.8 | 103.8 | 2.5 |
Feb | 102.4 | 2.3 | 102.1 | 2.3 | 103.9 | 2.5 | |
Mar | 102.7 | 2.3 | 102.5 | 2.3 | 104.0 | 2.4 | |
Apr | 103.2 | 2.6 | 102.9 | 2.7 | 104.1 | 2.2 | |
May | 103.5 | 2.7 | 103.3 | 2.9 | 104.2 | 2.1 |
Download this table
.xlsTable example 2
Overview of the UK population: March 2017
Table 2: Age distribution of the UK population, 1975 to 2045 (projected)
Year | UK Population | 0 to 15 years (%) | 16 to 64 years (%) | 65 years and over (%) |
---|---|---|---|---|
1975 | 56,226,000 | 24.9 | 61.0 | 14.1 |
1985 | 56,554,000 | 20.7 | 64.1 | 15.2 |
1995 | 58,025,000 | 20.7 | 63.4 | 15.8 |
2005 | 60,413,000 | 19.3 | 64.7 | 15.9 |
2015 | 65,110,000 | 18.8 | 63.3 | 17.8 |
2025 | 69,444,000 | 18.9 | 60.9 | 20.2 |
2035 | 73,044,000 | 18.1 | 58.3 | 23.6 |
2045 | 76,055,000 | 17.7 | 57.8 | 24.6 |
Download this table
.xlsTable example 3
House price index, by UK local authority district
Table 3: Top and bottom five UK local authorities, by annual growth in the year to April 2017
Top 5 Local Authorities | % change | Average price (£) |
---|---|---|
Orkney Islands | 24.1 | 151,543 |
Dartford | 13.1 | 306,405 |
Chiltern | 13.0 | 562,604 |
Rutland | 12.8 | 289,853 |
Forest Heath | 12.4 | 216,720 |
Bottom 5 Local Authorities | % change | Average price (£) |
Na h-Eileanan Siar | -15.3 | 85,093 |
South Hams | -6.9 | 276,609 |
City of Aberdeen | -4.3 | 167,630 |
Rhondda Cynon Taf | -3.1 | 97,763 |
Shetland Islands | -3.1 | 143,024 |
Download this table
.xlsTable example 4
Baby names in England and Wales: 2015
Table 4: Most popular names for baby boys and girls in 2015
Country / Region | Most popular boys name | Most popular girls name |
---|---|---|
England | Oliver | Amelia |
North East | Oliver | Amelia |
North West | Oliver | Amelia |
Yorkshire and The Humber | Oliver | Amelia |
East Midlands | Oliver | Olivia |
West Midlands | Muhammad | Amelia |
East | Oliver | Olivia |
London | Muhammad | Amelia |
South East | Oliver | Amelia |
South West | Oliver | Amelia |
Wales | Oliver | Amelia |
Download this table
.xlsTable example 5
Crime in England and Wales: year ending June 2017
Table 1a: Crime Survey for England and Wales incidence rates and numbers of incidents for year ending June 2017 and percentage change1
England and Wales, adults aged 16 and over/households | ||||||
---|---|---|---|---|---|---|
Jul 16 to Jun 17 | Jul 16 to Jun 17 compared with: | |||||
Jan 95 to Dec 95 | Apr 06 to Mar 07 | Apr 11 to Mar 12 | Jul 05 to Jun 16 | |||
Offence group2 | Rate per 1,000 population3 | Number of incidents (thousands)4 | Number of incidents - percentage change and significance5 | |||
Violence | 27 | 1,241 | -68* | -41* | -29* | -4 |
with injury | 12 | 571 | -75* | -49* | -37* | -5 |
without injury | 14 | 671 | -57* | -32* | -20* | -3 |
Robbery | 3 | 132 | -61* | -58* | -46* | -12 |
Theft offences6 | : | 3,311 | -72* | -41* | -38* | -11* |
Theft from the person | 8 | 354 | -48* | -37* | -42* | -12 |
Other theft of personal property | 13 | 584 | -72* | -48* | -45* | -27* |
Unweighted base - number of adults | 35,187 | 35,187 | ||||
Domestic burglary | 27 | 667 | -72* | -34* | -28* | -4 |
in a dwelling | 20 | 485 | -72* | -32* | -30* | -2 |
in a non-connected building to a dwelling | 7 | 182 | -72* | -39* | -21* | -10 |
Other household theft | 24 | 585 | -63* | -33* | -48* | -10 |
Unweighted base - number of households | 35,106 | 35,106 | ||||
Vehicle-related theft | 44 | 845 | -80* | -48* | -30* | -2 |
Unweighted base - number of vehicle owners | 28,080 | 28,080 | ||||
Bicycle theft | 22 | 276 | -58* | -40* | -38* | -5 |
Unweighted base - number of bicycle owners | 16,722 | 16,722 | ||||
Criminal damage | 46 | 1,128 | -66 | -61* | -44* | -10* |
Unweighted base - number of households | 35,106 | 35,106 | ||||
All CSEW crime6 | : | 5,812 | -70* | -47* | -38* | -9* |
Fraud and computer misuse(ES)7,8 | 107 | 4,946 | .. | .. | .. | .. |
Fraud | 72 | 3,339 | .. | .. | .. | .. |
Bank and credit account fraud | 54 | 2,513 | .. | .. | .. | .. |
Consumer and retail fraud9 | 16 | 727 | .. | .. | .. | .. |
Advance fee fraud | 1 | 40 | .. | .. | .. | .. |
Other fraud | 1 | 60 | .. | .. | .. | .. |
Computer misuse | 35 | 1,607 | .. | .. | .. | .. |
Computer virus | 23 | 1,071 | .. | .. | .. | .. |
Unauthorised access to personal information (including hacking) | 12 | 535 | .. | .. | .. | .. |
Unweighted base - number of adults | 17,029 | 17,029 | ||||
All CSEW crime including fraud and computer miuse(ES)10 | .. | 10,758 | .. | .. | .. | .. |
Download this table
.xlsAdd these things to tabile builder backlog
- Remove title attribute from button, but replace it with descriptive visually hidden text
- Add file size to button text
- Add padding on mobile
- Allow visual grouping of rows?
- Explore if spanned coloumns and rows help
- Explore sortable tables
- The crime one is a train wreck
For style guide
- Don't split asterisks and figures in different cells
- Don't do all caps