Jump to content

User:Timeshifter/Sandbox79

From Wikipedia, the free encyclopedia
See also: Commons:Convert tables and charts to wiki code or image files. And: Help:Table - see section on tables and the Visual Editor (VE).

18 Oct 2018 update of List of countries by incarceration rate.

I used freeware LibreOffice Calc to copy the 3 data columns from the main World Prison Brief (WPB) source.

I just copied and pasted directly from the page to LibreOffice Calc. I first alphabetized the columns on the WPB page by clicking on the column heads.

3 separate spreadsheet files. Each file had a column for nations, and a column for data.

I adjusted each data column so that there were the same number of rows in each spreadsheet file. I had to add countries into the unsentenced prisoners column for example. Even though those countries had no data for unsentenced prisoners.

In the prison population column I added commas for the blank spaces used by WPB to indicate the thousands separator. I did this all at once by using freeware NoteTab Light (or any text editor) to replace the space with the comma.

Then I copied and pasted the columns into one spreadsheet file.

I then used a sandbox page, and pasted that combined spreadsheet file into a new blank table created by the Visual Editor:

It took around 10 seconds in my Firefox browser. I had to tell it to allow the process to finish.

From the Wikipedia page I pasted in the nations column using Visual Editor since it had all the flags and links. I also pasted in the Notes column. One has to create a blank column first with the Visual Editor. Then paste into it via the Firefox edit menu: Edit > Paste.

So I had 2 nations columns and could compare them to make sure they aligned perfectly. They did. See it here:

I pasted that into Sandbox79 and removed the plain-text nations column. I used freeware NoteTab Light to add the text alignment all at once to the nations column.

Replace |{{ with
|style=text-align:left; |{{
Replace |''{{ with
|style=text-align:left; |''{{

"c." (circa) indicates "approximately". Sorting will not work correctly if it is in front of the number. So it needs to be moved after the number.

Flag templates to check

[edit]

There are some flagcountry templates to watch out for:

Make sure that you have a link for "England & Wales" after it:

Make sure that you have a link for "Bosnia and Herzegovina" after it:

Table

[edit]





1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
Country (or dependent territory,
subnational area, etc.) 		Incarceration
Rate per
100,000
population 		Prison

Population

Percent of
prisoners
unsentenced 		Notes



 Afghanistan 88 30,000 31.3
 Albania 188 5,407 40.6
 Algeria 146 60,000 8.6
 American Samoa (USA) 345 193 14.9
 Andorra 69 52 55.3
 Angola 93 24,000 45.8
 Anguilla (United Kingdom) 367 55 45.5
 Antigua and Barbuda 321 305 37
 Argentina 186 81,975 47.7
 Armenia 119 3,536 37.1
 Aruba (Netherlands) 165 170 16.6
 Australia 172 42,942 31.3
 Austria 98 8,692 21.3
 Azerbaijan 235 23,320 20.6
 Bahamas 438 1,746 42
 Bahrain 234 3,485 25.7
 Bangladesh 53 88,424 78.2
 Barbados 300 874 48.9
 Belarus 364 34,600 18.2
 Belgium 88 10,073 35.6
 Belize 356 1,297 30.1
 Benin 68 7,890 75.8
 Bermuda (United Kingdom) 319 209 9.6
 Bhutan 145 1,119
 Bolivia 156 17,946 69.9
 Federation of Bosnia and Herzegovina 73 1,722 12.5
 Republika Srpska (Bosnia and Herzegovina) 66 863 11.2
 Botswana 208 4,343 24.5
 Brazil 324 690,722 35.4
 Brunei 134 565 7.1
 Bulgaria 125 9,028 21.1
 Burkina Faso 41 7,670 42
 Burundi 84 10,093 51.1
 Cambodia 176 28,414 70.6
 Cameroon 121 29,341 56
 Canada 114 41,145 38.6
 Cape Verde 298 1,542 23.3
 Cayman Islands (United Kingdom) 393 253 29.6
 Central African Republic 16 764 70.2
 Chad 59 8,000 63.4
 Chile 233 42,683 33.3
 China 118 1,649,804 Notes
 Colombia 240 118,708 33.7
 Comoros 23 191 29
 Congo 27 1,240 60
 Cook Islands (New Zealand) 229 48 14.6
 Costa Rica 374 19,226 13.3
 Ivory Coast 66 16,127 40.7
 Croatia 78 3,190 24.5
 Cuba 510 57,337
 Curaçao (Netherlands) 236 377 41
 Cyprus 83 710 33.7
 Czech Republic 205 21,806 7.6
 DR Congo 29 20,550 73
 Denmark 63 3,635 35.5
 Djibouti 66 600 20
 Dominica 289 211 23.7
 Dominican Republic 238 26,286 60.3
 Ecuador 222 37,497 34.9
 Egypt 116 106,000 c. 9.9
 El Salvador 604 38,714 29.5
 Equatorial Guinea 63 500
 Estonia 195 2,575 19.8
 Ethiopia 127 113,727 14.9
 Faroe Islands (Denmark) 12 6 26.8
 Fiji 210 1,889 25.9
 Finland 51 2,842 19.2
 France 104 70,710 29.7
 French Guiana (France) 249 726 25.9
 French Polynesia (France) 199 569 14.4
 Gabon 191 3,373 66.7
 Gambia 58 1,121 22.2
 Georgia 268 9,990 17.1
 Germany 75 62,194 22.6
 Ghana 51 15,063 13.8
 Gibraltar (United Kingdom) 165 56 26.8
 Greece 97 10,409 32.6
 Greenland (Denmark) 249 139 32.5
 Grenada 435 465 15.2
 Guadeloupe (France) 216 970 26.9
 Guam (USA) 404 667 45.1
 Guatemala 141 24,386 51.8
 Guernsey (United Kingdom) 165 109 16.5
 Guinea 25 3,200 65
 Guinea-Bissau 10 196 67.9
 Guyana 283 2,200 35.6
 Haiti 96 10,512 71.1
 Honduras 216 18,950 53.1
 Hong Kong (China) 112 8,306 23.5
 Hungary 173 16,947 18.2
 Iceland 37 131 17.6
 India 33 419,623 67.2
 Indonesia 93 248,389 28.6
 Iran 284 230,000 25.1
 Iraq 126 45,000 35.2
 Ireland 78 3,816 19
 Isle of Man (United Kingdom) 125 106 6.6
 Israel 236 19,325 25.2
 Italy 98 59,135 33.3
 Jamaica 138 3,866 23.1
 Japan 41 51,805 10.8
 Jersey (United Kingdom) 122 130 26.4
 Jordan 197 15,700 44.4
 Kazakhstan 186 33,989 17
 Kenya 108 54,000 48
 Kiribati 113 129 5.4
 Kosovo 95 1,648 18.1
 Kuwait 157 6,000 10
 Kyrgyzstan 171 10,574 18.4
 Laos 119 8,201 1
 Latvia 195 3,765 27.9
 Lebanon 126 6,330 64.7
 Lesotho 92 2,073 19.5
 Liberia 47 2,211 63
 Libya 99 6,187 90
 Liechtenstein 27 10 37.5
 Lithuania 235 6,544 8.8
 Luxembourg 107 650 44.5
 Macau (China) 208 1,371 18.6
 Macedonia 141 2,931 8.5
 Madagascar 82 20,954 50.8
 Malawi 80 14,795 10.8
 Malaysia 177 55,413 29.8
 Maldives 499 1,852
 Mali 33 5,209 52.8
 Malta 133 588 26.5
 Marshall Islands 66 35 11.4
 Martinique (France) 211 814 27.3
 Mauritania 46 1,920 42.4
 Mauritius 194 2,499 41
 Mayotte (France) 118 308 56.1
 Mexico 164 204,422 39.4
 Micronesia 127 132 16.7
 Moldova 212 7,510 16.8
 Monaco 76 29 59.4
 Mongolia 102 3,099 23
 Montenegro 180 1,123 28.4
 Morocco 232 82,512 40.2
 Mozambique 61 18,185 33.1
 Myanmar 145 79,668 10.8
 Namibia 295 7,400 c. 54
 Nauru 140 14 25
   Nepal 65 18,881 58.9
 Netherlands 61 10,464 30
 New Caledonia (France) 193 543 14.2
 New Zealand 214 10,435 30.6
 Nicaragua 276 17,196 21.4
 Niger 53 10,383 59.8
 Nigeria 37 73,631 68.1
 Northern Mariana Islands (USA) 482 270
 Norway 63 3,373 22.9
 Oman 36 1,300 5.6
 Pakistan 43 83,718 69.1
 Palau 395 87 4.1
 Panama 390 16,183 53
 Papua New Guinea 63 4,945 38.3
 Paraguay 199 13,607 77.9
 Peru 270 87,995 39.8
 Philippines 179 188,278 75.1
 Poland 194 73,524 10.1
 Portugal 127 13,065 16.3
 Puerto Rico (USA) 313 10,475 13
 Qatar 53 1,150 44
 South Korea 109 55,198 34.5
 Réunion (France) 130 1,148 14
 Romania 111 21,527 8.3
 Russia 402 582,889 17.5
 Rwanda 464 61,000 6.8
 Samoa 204 400 14
 San Marino 3 0
 São Tomé and Príncipe 117 251 33.5
 Saudi Arabia 197 61,000 58.7
 Senegal 76 12,500 42.1
 Serbia 154 10,807 16.2
 Seychelles 437 423 16.8
 Sierra Leone 58 4,519 30.1
 Singapore 201 11,691 11.5
 Sint Maarten 153 62 18.1
 Slovakia 191 10,415 15.6
 Slovenia 64 1,333 23.3
 Solomon Islands 78 477 48.2
 South Africa 280 158,111 25.8
 South Sudan 52 6,504 28.9
 Spain 126 59,087 15
 Sri Lanka 94 20,598 53.4
 Saint Kitts and Nevis 393 220 30.5
 Saint Lucia 280 527 53.5
 Saint Vincent and the Grenadines 426 469 24.3
 Sudan 52 21,000 20.4
 Suriname 183 1,000 50
 Swaziland 282 3,610 18.1
 Sweden 59 5,979 30.6
  Switzerland 81 6,863 39.4
 Syria 60 10,599 50.5
 Taiwan 265 62,634 5.2
 Tajikistan 121 9,317 15
 Tanzania 58 31,382 53.1
 Thailand 526 364,288 18.2
 East Timor 51 659 23.2
 Togo 64 4,859 66.3
 Tonga 166 176 7.4
 Trinidad and Tobago 270 3,667 60.9
 Tunisia 181 20,755 52
 Turkey 288 232,886 43.1
 Turkmenistan 552 30,452 14
 Tuvalu 110 11 0
 Uganda 129 54,059 51.6
 Ukraine 157 56,246 34.2
 United Arab Emirates 104 9,826 38.2
 United Kingdom. England & Wales 140 83,014 11.2 Notes
 Northern Ireland (United Kingdom) 76 1,435 30.4 Notes
 Scotland (United Kingdom) 143 7,771 19.5 Notes
 United States 655 2,121,600 21.6 Notes
 Uruguay 321 11,078 69.7
 Uzbekistan 150 43,900 10
 Vanuatu 71 192 22.4
 Venezuela 178 57,096 63
 Vietnam 137 130,002 12.5
 British Virgin Islands (United Kingdom) 470 134 37
 U.S. Virgin Islands (USA) 542 577 36.4
 Yemen 53 14,000 70.1
 Zambia 146 25,000 28
 Zimbabwe 120 19,521 17.1
Retrieved from "https://wiki.riteme.site/w/index.php?title=User:Timeshifter/Sandbox79&oldid=865035145"