pieterprovoost
commented
6 years ago select country, count(*) from wos group by country order by count(*) descUSA,672
England,202
Germany,169
Australia,164
Canada,148
France,127
New Zealand,84
Belgium,75
Italy,75
Japan,71
Spain,65
Brazil,58
Norway,52
Denmark,42
Portugal,39
South Africa,39
Greece,37
Chile,31
Netherlands,28
Argentina,26
Ireland,26
Switzerland,25
India,20
Russia,19
Mexico,18
Poland,18
Venezuela,16
Malaysia,15
Sweden,15
China,14
Colombia,9
Israel,9
Philippines,9
Panama,8
Wales,8
Austria,6
Thailand,6
New Caledonia,5
Reunion,5
Tunisia,5
Slovenia,4
Ukraine,4
Bulgaria,3
Czech Republic,3
Estonia,3
Finland,3
Saudi Arabia,3
Singapore,3
Uruguay,3
Bermuda,2
Brunei,2
Costa Rica,2
Cuba,2
Fiji,2
Greenland,2
Iceland,2
Indonesia,2
Bahamas,1
Bangladesh,1
Bolivia,1
French Guiana,1
Guadeloupe,1
Guinea,1
Hungary,1
Jamaica,1
Kenya,1
Madagascar,1
Maldives,1
Malta,1
Monaco,1
Mozambique,1
Oman,1
Peru,1
Sri Lanka,1
Vietnam,1
Can you extract a CSV file from wos.db, with the number of papers per country?