Jump to content

User:Timeshifter/Sandbox74

From Wikipedia, the free encyclopedia

Please do not edit this page. It is linked from other pages. Create your own user pages for trying out things. See also: Commons:Convert tables and charts to wiki code or image files.

Worksheet for full rapid update of List of countries by incarceration rate. Copy the country list (all countries) of prison population rates from here:

Then control-click the top of the columns that remain in order to select them. Then copy and paste into tab2wiki. Click the "do it" button at the bottom. It converts the spreadsheet into wikitext for a table.

The country links are created all at once. Copy the wikitext result from tab2wiki into freeware NoteTab Light. Put a checkmark in the regular expression box. Then click "replace" in the search menu. Then copy the following into it:

^.*?\|\h*\K(.*?)(?=\h*\|) "replace all" with [[$1]]

This creates a link of anything in the first cell of each row. So all the country names are linked. This must be done before other formatting. Such as adding the text-align styles. Those styles are added all at once too.

Do not add flag icons. The flag template sometimes changes the country names, and this messes up the alphabetical order of the table. So it takes much longer to update the chart due to having to change the order of the table rows in order to accommodate the name changes. Also, there are still some country names that do not have redirects yet. So a red link shows up instead of a flag icon and a clickable country link.

Please do not delete the country redirects. This allows the table to be fully updated much more often. It only takes half an hour to fully update the table if redirects do not also have to be recreated each time (which can take hours). The source page uses these country, territory, and subnational names.





Incarceration rates

[edit]

This list is initially sorted alphabetically. Click the sorting cell (with the icon) below the incarceration rate header to sort by rate. (Requires JavaScript.) The table can be sorted in ascending or descending order. The row number column stays static, and does not sort.

In the table below see "United Kingdom" to find the rates for Scotland, Northern Ireland, and England and Wales. There is no rate listed for the UK as a whole. South Korea is listed as Republic of (South) Korea. For info on North Korea, see notes below.

"Notes" column links to notes section below the chart.






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
Country (or dependent territory,
subnational area, etc.)
Incarceration
rate
(Prisoners per
100,000
population)
Notes

Afghanistan 88
Albania 193
Algeria 146
American Samoa (USA) 337
Andorra 69
Angola 93
Anguilla (United Kingdom) 307
Antigua and Barbuda 373
Argentina 186
Armenia 131
Aruba (Netherlands) 165
Australia 167
Austria 98
Azerbaijan 235
Bahamas 438
Bahrain 234
Bangladesh 47
Barbados 300
Belarus 364
Belgium 91
Belize 356
Benin 68
Bermuda (United Kingdom) 319
Bhutan 145
Bolivia 156
Bosnia and Herzegovina: Federation 73
Bosnia and Herzegovina: Republika Srpska 66
Botswana 208
Brazil 328
Brunei Darussalam 134
Bulgaria 125
Burkina Faso 41
Burundi 84
Cambodia 176
Cameroon 121
Canada 114
Cape Verde (Cabo Verde) 298
Cayman Islands (United Kingdom) 359
Central African Republic 16
Chad 59
Chile 225
China 118 Notes
Colombia 227
Comoros 23
Congo (Republic of) 27
Cook Islands (New Zealand) 229
Costa Rica 374
Cote d'Ivoire 66
Croatia 78
Cuba 510
Curaçao (Netherlands) 236
Cyprus (Republic of) 83
Czech Republic 209
Democratic Republic of Congo 29
Denmark 59
Djibouti 66
Dominica 289
Dominican Republic 244
Ecuador 222
Egypt 116
El Salvador 610
Equatorial Guinea 63
Estonia 202
Ethiopia 127
Faeroe Islands (Denmark) 12
Fiji 158
Finland 57
France 102
French Guiana/Guyane (France) 281
French Polynesia (France) 176
Gabon 191
Gambia 58
Georgia 254
Germany 78
Ghana 50
Gibraltar (United Kingdom) 165
Greece 93
Greenland (Denmark) 225
Grenada 435
Guadeloupe (France) 192
Guam (USA) 404
Guatemala 136
Guernsey (United Kingdom) 138
Guinea (Republic of) 25
Guinea Bissau 10
Guyana 259
Haiti 96
Honduras 216
Hong Kong (China) 111
Hungary 184
Iceland 38
India 33
Indonesia 94
Iran 284
Iraq 126
Ireland, Republic of 82
Isle of Man (United Kingdom) 108
Israel 236
Italy 96
Jamaica 138
Japan 45
Jersey (United Kingdom) 133
Jordan 197
Kazakhstan 194
Kenya 111
Kiribati 113
Kosovo/Kosova 106
Kuwait 157
Kyrgyzstan 171
Laos 119
Latvia 218
Lebanon 126
Lesotho 92
Liberia 44
Libya 99
Liechtenstein 27
Lithuania 235
Luxembourg 115
Macau (China) 197
Macedonia (former Yugoslav Republic of) 156
Madagascar 88
Malawi 79
Malaysia 167
Maldives 514
Mali 33
Malta 133
Marshall Islands 66
Martinique (France) 217
Mauritania 46
Mauritius 195
Mayotte (France) 119
Mexico 165
Micronesia, Federated States of 127
Moldova (Republic of) 215
Monaco 85
Mongolia 262
Montenegro 174
Morocco 232
Mozambique 65
Myanmar (formerly Burma) 145
Namibia 295
Nauru 140
Nepal 65
Netherlands 59
New Caledonia (France) 198
New Zealand 220
Nicaragua 238
Niger 53
Nigeria 36
Northern Mariana Islands (USA) 482
Norway 74
Oman 36
Pakistan 43
Palau 345
Panama 390
Papua New Guinea 63
Paraguay 199
Peru 267
Philippines 172
Poland 198
Portugal 129
Puerto Rico (USA) 313
Qatar 53
Republic of (South) Korea 109
Reunion (France) 115
Romania 116
Russian Federation 411
Rwanda 434
Samoa 204
Sao Tome e Principe 85
Saudi Arabia 197
Senegal 76
Serbia 152
Seychelles 437
Sierra Leone 64
Singapore 201
Sint Maarten (Netherlands) 347
Slovakia 190
Slovenia 64
Solomon Islands 73
South Africa 280
South Sudan 52
Spain 127
Sri Lanka 94
St. Kitts and Nevis 393
St. Lucia 279
St. Vincent and the Grenadines 378
Sudan 46
Suriname 183
Swaziland 282
Sweden 57
Switzerland 82
Syria 60
Taiwan 259
Tajikistan 121
Tanzania 58
Thailand 497
Timor-Leste (formerly East Timor) 51
Togo 62
Tonga 166
Trinidad and Tobago 270
Tunisia 206
Turkey 287
Turkmenistan 583
Tuvalu 110
Uganda 129
Ukraine 158
United Arab Emirates 104
United Kingdom: England & Wales 141 Notes
United Kingdom: Northern Ireland 79 Notes
United Kingdom: Scotland 137 Notes
United States of America 655 Notes
Uruguay 321
Uzbekistan 150
Vanuatu 71
Venezuela 173
Vietnam 122
Virgin Islands (United Kingdom) 470
Virgin Islands (USA) 542
Yemen 53
Zambia 146
Zimbabwe 120

Notes

[edit]

Return to top of table.

China

[edit]

North Korea

[edit]

United Kingdom

[edit]

United States

[edit]

References

[edit]