Number of subdivisions per country

Custom SQL query returning 200 rows (hide)

SELECT
    countries.short_name_lower_case
    , count(*)
FROM
    subdivisions
    INNER JOIN countries ON countries.alpha_2_code = subdivisions.country_code
GROUP BY
    country_code

Edit SQL

short_name_lower_casecount(*)
Andorra 7
United Arab Emirates (the) 7
Afghanistan 34
Antigua and Barbuda 8
Albania 12
Armenia 11
Angola 18
Argentina 24
Austria 9
Australia 8
Azerbaijan 78
Bosnia and Herzegovina 3
Barbados 11
Bangladesh 72
Belgium 13
Burkina Faso 58
Bulgaria 28
Bahrain 4
Burundi 18
Benin 12
Brunei Darussalam 4
Bolivia (Plurinational State of) 9
Bonaire, Sint Eustatius and Saba 3
Brazil 27
Bahamas (the) 32
Bhutan 20
Botswana 16
Belarus 7
Belize 6
Canada 13
Congo (the Democratic Republic of the) 26
Central African Republic (the) 17
Congo (the) 12
Switzerland 26
Côte d'Ivoire 14
Chile 16
Cameroon 10
China 34
Colombia 33
Costa Rica 7
Cuba 16
Cabo Verde 24
Cyprus 6
Czechia 90
Germany 16
Djibouti 6
Denmark 5
Dominica 10
Dominican Republic (the) 42
Algeria 48
Ecuador 24
Estonia 94
Egypt 27
Eritrea 6
Spain 62
Ethiopia 11
Finland 19
Fiji 19
Micronesia (Federated States of) 4
France 127
Gabon 9
United Kingdom of Great Britain and Northern Ireland (the) 216
Grenada 7
Georgia 12
Ghana 16
Greenland 5
Gambia (the) 6
Guinea 41
Equatorial Guinea 10
Greece 14
Guatemala 22
Guinea-Bissau 12
Guyana 10
Honduras 18
Croatia 21
Haiti 10
Hungary 43
Indonesia 41
Ireland 30
Israel 6
India 36
Iraq 18
Iran (Islamic Republic of) 31
Iceland 80
Italy 126
Jamaica 14
Jordan 12
Japan 47
Kenya 47
Kyrgyzstan 9
Cambodia 25
Kiribati 3
Comoros (the) 3
Saint Kitts and Nevis 16
Korea (the Democratic People's Republic of) 12
Korea (the Republic of) 17
Kuwait 6
Kazakhstan 17
Lao People's Democratic Republic (the) 18
Lebanon 8
Saint Lucia 10
Liechtenstein 11
Sri Lanka 34
Liberia 15
Lesotho 10
Lithuania 70
Luxembourg 12
Latvia 119
Libya 22
Morocco 87
Monaco 17
Moldova (the Republic of) 37
Montenegro 24
Madagascar 6
Marshall Islands (the) 26
North Macedonia 80
Mali 11
Myanmar 15
Mongolia 22
Mauritania 15
Malta 68
Mauritius 12
Maldives 21
Malawi 31
Mexico 32
Malaysia 16
Mozambique 11
Namibia 14
Niger (the) 8
Nigeria 37
Nicaragua 17
Netherlands (the) 17
Norway 13
Nepal 26
Nauru 14
New Zealand 17
Oman 11
Panama 13
Peru 26
Papua New Guinea 22
Philippines (the) 98
Pakistan 7
Poland 16
Palestine, State of 16
Portugal 20
Palau 16
Paraguay 18
Qatar 8
Romania 42
Serbia 32
Russian Federation (the) 83
Rwanda 5
Saudi Arabia 13
Solomon Islands 10
Seychelles 27
Sudan (the) 18
Sweden 21
Singapore 5
Saint Helena, Ascension and Tristan da Cunha 3
Slovenia 212
Slovakia 8
Sierra Leone 5
San Marino 9
Senegal 14
Somalia 18
Suriname 10
South Sudan 10
Sao Tome and Principe 7
El Salvador 14
Syrian Arab Republic (the) 14
Eswatini 4
Chad 23
Togo 5
Thailand 78
Tajikistan 5
Timor-Leste 13
Turkmenistan 6
Tunisia 24
Tonga 5
Turkey 81
Trinidad and Tobago 15
Tuvalu 8
Taiwan (Province of China) 22
Tanzania, the United Republic of 31
Ukraine 27
Uganda 139
United States Minor Outlying Islands (the) 9
United States of America (the) 57
Uruguay 19
Uzbekistan 14
Saint Vincent and the Grenadines 6
Venezuela (Bolivarian Republic of) 25
Viet Nam 63
Vanuatu 6
Wallis and Futuna 3
Samoa 11
Yemen 22
South Africa 9
Zambia 10
Zimbabwe 10