Advertisement
Guest User

Rough list of author countries from ISFDB database

a guest
Jun 1st, 2019
539
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.93 KB | None
  1. select trim(substring_index(author_birthplace, ',', -1)) author_country, count(1) c from authors where author_birthplace is not null group by author_country order by author_country;
  2.  
  3.  
  4. author_country c
  5. 1
  6. 1950 1
  7. Abbasid Caliphate 1
  8. Adelaide 1
  9. Aden 1
  10. Adriatic Veneti 1
  11. Afghanistan 3
  12. Africa 3
  13. Al-Andalus 1
  14. Algeria 6
  15. Algeria] 1
  16. Ancient Greece 1
  17. Ancient Rome 1
  18. Angola 2
  19. Antigua 1
  20. Arcadia 1
  21. Argentina 206
  22. Argentina. 1
  23. Argentine 1
  24. Argentine Republic 1
  25. Asti (Italy) 1
  26. at Sea 1
  27. Austian Empire 1
  28. Australia 749
  29. Australia? 1
  30. Australian External Territories 1
  31. Austria 184
  32. Austria-Hungary 6
  33. Austrian Empire 43
  34. Austrian-Hungarian Empire 2
  35. Austro-Hungarian Empire 238
  36. Azerbaijan Soviet Socialist Republic 1
  37. Bad Schwalbach 1
  38. Baden Württemberg 1
  39. Baden-Württemberg 1
  40. Bahrain 2
  41. Bailiwick of Guernsey 3
  42. Bailiwick of Jersey 5
  43. Baltimore 1
  44. Bangaldesh 1
  45. Bangladesh 7
  46. Barbados 2
  47. Batavian Republic 1
  48. Belarus 2
  49. Belgian Congo 4
  50. Belgique 1
  51. Belgium 335
  52. Bermuda 2
  53. Boeotia 1
  54. Bohemia 1
  55. Bolivia 8
  56. Bosnia 1
  57. Bosnia and Herzegovina 2
  58. Botswana 3
  59. Brandenburg/Havel 1
  60. Brasil 2
  61. Brasilia 1
  62. Brazil 137
  63. Brazil. 6
  64. Brisbane Australia 1
  65. British Ceylon 5
  66. British Commonwealth 1
  67. British Dependent Territory 1
  68. British Empire 196
  69. British Guiana 2
  70. British Guyana 2
  71. British India 132
  72. British India (Now Bangladesh) 1
  73. British Kenya 2
  74. British Malaya 2
  75. British Mandate for Palestine 4
  76. British Mandate of Palestine 2
  77. British Nigeria 1
  78. British North America 6
  79. British Raj 3
  80. British West Indies 16
  81. Brno 1
  82. Bulgaria 98
  83. Burma 2
  84. Byelorussian Soviet Socialist Republic 1
  85. Byzacium 1
  86. Calfornia 1
  87. Cameroon 2
  88. Campina Grande 1
  89. Canada 1361
  90. Canda 1
  91. Catalonia 1
  92. Cayman Islands 1
  93. Ceylon 3
  94. Chalcidian League 1
  95. Channel Islands 4
  96. Chile 66
  97. China 162
  98. City and State of Geneva 1
  99. Colombia 15
  100. Colony and Protectorate of Nigeria 1
  101. Commonwealth of Dominica 1
  102. Commonwealth of the Philippines 1
  103. Confederation of the Rhine 6
  104. Conferderation of the Rhine 1
  105. Congo 1
  106. Congress Poland 1
  107. Costa Rica 10
  108. Croatia 11
  109. Croats and Slovenes 2
  110. Crown of Castile 2
  111. Cuba 75
  112. Cyprus 5
  113. Czech 1
  114. Czech Republic 4
  115. Czechoslovakia 120
  116. Danmark 2
  117. Denmark 86
  118. Denmark–Norway 1
  119. Dominican Republic 6
  120. Dominion of Pakistan 1
  121. Duchy of Anhalt 1
  122. Duchy of Brunswick 1
  123. Duchy of Nassau 2
  124. Duchy of Savoy 1
  125. Duchy of Saxe-Coburg and Gotha 1
  126. Duchy of Warsaw 1
  127. Dutch Colony of Suriname 1
  128. Dutch East Indies 16
  129. Dutch Republic 14
  130. East Germany 127
  131. East Pakistan 1
  132. East-Germany 1
  133. Ecuador 7
  134. Egypt 12
  135. El Salvador 3
  136. Electorate of Saxony 1
  137. Elgersburg 1
  138. Empire of Brazil 1
  139. Empire of Japan 4
  140. España 2
  141. Estonia 10
  142. Ethiopia 2
  143. Federal Republic of Germany 5
  144. Federation of Rhodesia and Nyasaland 1
  145. Federative Union of Soviet Socialist Republics of Transcaucasia 1
  146. Fiji 2
  147. Finalnd 1
  148. Finland 101
  149. Florence 2
  150. France 1944
  151. Free City of Danzig 4
  152. Free Hanseatic City of Hamburg 1
  153. Free Imperial City of Frankfurt 1
  154. Free Imperial City of Schwäbisch Gmünd 1
  155. French Algeria 21
  156. French Cameroons 1
  157. French colony of New Caledonia 1
  158. French Dahomey 1
  159. French Empire 16
  160. French Equatorial Africa 1
  161. French Fourth Republic 1
  162. French Indo-China 1
  163. French Indochina 3
  164. French Madagascar 1
  165. French Mandate for Syria and Lebanon 1
  166. French Mandate for Syria and the Lebanon 1
  167. French protectorate in Morocco 6
  168. French protectorate of Tunisia 2
  169. French Tunisia 1
  170. French West Africa 1
  171. French West Indies 2
  172. Frnce 1
  173. Gabon 1
  174. German Confederation 41
  175. German Democratic Republic 1
  176. German Empire 265
  177. German Realm 3
  178. German Reich 4
  179. Germany 666
  180. Germany Realm 1
  181. Ghana 7
  182. Gibraltar 1
  183. Grand Duchy of Hesse 1
  184. Grand Duchy of Mecklenburg-Schwerin 1
  185. Grand Duchy of Saxe-Weimar-Eisenach 1
  186. Grand Duchy of Tuscany 6
  187. Great Britain 4
  188. Greater Germany 17
  189. Greece 39
  190. Grenada 3
  191. Guadeloupe 1
  192. Guatemala 4
  193. Guernsey 1
  194. Guinea 1
  195. Guyana 4
  196. Habsburg Monarchy 2
  197. Habsburg Netherlands 2
  198. Haiti 18
  199. Haute-Vienne; France 1
  200. Holland 1
  201. Holy Roman Empire 102
  202. Honduras 3
  203. Hong Komg 1
  204. Hong Kong 10
  205. Hungaria 1
  206. Hungary 105
  207. Iceland 17
  208. Icelandic Commonwealth 1
  209. India 96
  210. Indonesia 13
  211. Iran 15
  212. Iraq 10
  213. Ireland 116
  214. Irish Free State 7
  215. Isle of Man 1
  216. Israel 44
  217. Israeli 1
  218. Italia 1
  219. Italian Eritrea 1
  220. Italian Libya 1
  221. Italy 380
  222. Italy. 1
  223. Jamaica 14
  224. Japan 667
  225. Japanese Empire 1
  226. Jersey 2
  227. Jordan 2
  228. Jugoslavia 1
  229. Karlsruhe 1
  230. Kashmir 2
  231. Kazakhstan 2
  232. Kenya 47
  233. Kindom of Romania 2
  234. Kingdom of Bavaria 9
  235. Kingdom of Belgium 2
  236. Kingdom of Bulgaria 2
  237. Kingdom of Castile 1
  238. Kingdom of Denmark 3
  239. Kingdom of Denmark–Norway 2
  240. Kingdom of Egypt 7
  241. Kingdom of England 52
  242. Kingdom of France 13
  243. Kingdom of Great Britain 142
  244. Kingdom of Greece 1
  245. Kingdom of Hannover 1
  246. Kingdom of Hawaii 3
  247. Kingdom of Ireland 22
  248. Kingdom of Italy 10
  249. Kingdom of Joseon 1
  250. Kingdom of Libya 1
  251. Kingdom of Lombardy–Venetia 1
  252. Kingdom of Montenegro 1
  253. Kingdom of Naples 1
  254. Kingdom of Northumbria 1
  255. Kingdom of Portugal 1
  256. Kingdom of Portugal and the Algarves 1
  257. Kingdom of Prussia 54
  258. Kingdom of Prussia. German Empire 1
  259. Kingdom of Romania 78
  260. Kingdom of Romania. 1
  261. Kingdom of Sardinia 4
  262. Kingdom of Saxony 1
  263. Kingdom of Scotland 8
  264. Kingdom of Serbia 2
  265. Kingdom of Sicily 3
  266. Kingdom of Spain 1
  267. Kingdom of Sweden 2
  268. Kingdom of the Netherlands 3
  269. Kingdom of the Two Sicilies 4
  270. Kingdom of Württemberg 1
  271. Kingdom of Yougoslavia 1
  272. Kingdom of Yugoslavia 29
  273. Korea 4
  274. Kuwait 1
  275. Laos 2
  276. Latvia 8
  277. Lebanon 14
  278. Liberec 1
  279. Liberia 2
  280. Libya 2
  281. Lisbon 1
  282. Lithuania 2
  283. Lithuania] 1
  284. Lombardy 1
  285. London 3
  286. Luxembourg 8
  287. Luxemburg 1
  288. MA 1
  289. Macedonia 3
  290. Madagascar 2
  291. Madrid 1
  292. Malawi 7
  293. Malaya 4
  294. Malaysia 26
  295. Malta 7
  296. Manchuria 1
  297. Mandatory Palestine 1
  298. Maroc 1
  299. Marocco 2
  300. Martinique 1
  301. Mauritius 2
  302. Melbourne 1
  303. Mexico 189
  304. Milan 1
  305. Minneapolis 1
  306. Minorca 1
  307. Moldavian Democratic Republic 1
  308. Montréal 1
  309. Morocco 12
  310. Mozambique 2
  311. Namibia 1
  312. Natherlands 1
  313. Nepal 1
  314. Netherlands 477
  315. Netherlands Antilles 2
  316. Netherlands New Guinea 1
  317. New Brunswick 1
  318. New Zealand 162
  319. New Zeland 2
  320. Newfoundland 1
  321. Nicaragua 2
  322. Niger 2
  323. Nigeria 71
  324. NJ 1
  325. North Africa 1
  326. North German Confederation 5
  327. Northern Ireland 1
  328. Northern Rhodesia 1
  329. Norway 58
  330. NZ 2
  331. OH 1
  332. Old Swiss Confederacy 1
  333. Ontario 1
  334. Orange Free State 2
  335. Ostmark 1
  336. Ottoman Empire 39
  337. Pacific Northwest 1
  338. Pakistan 10
  339. Palermo 1
  340. Palestine 4
  341. Palestine Mandate 1
  342. Panama 9
  343. Panama Canal Zone 1
  344. Papal States 12
  345. Papua and New Guinea 1
  346. Papua New Guinea 4
  347. Paraguay 4
  348. Paris 4
  349. Pennslvania USA 1
  350. People's Republic of China 2
  351. Persia 6
  352. Peru 38
  353. Phiippines 1
  354. Philippine Islands 1
  355. Philippines 75
  356. Phillipines 5
  357. Poland 246
  358. Poland (now in Ukraine) 1
  359. Poland] 1
  360. Polish People's Republic 1
  361. Polish-Lithuanian Commonwealth 1
  362. Polish–Lithuanian Commonwealth 5
  363. Portugal 51
  364. Portugal. 1
  365. Portuguese Mozambique 1
  366. Portuguese West Africa 1
  367. Prague 1
  368. Principality of Correggio 1
  369. Principality of Moldavia 1
  370. Protectorate of Bohemia and Moravia 1
  371. Province of Canada 2
  372. Prussia 1
  373. Prussian Rhine Province 1
  374. Przedeczu 1
  375. Puerto Rico 33
  376. Qing Empire 1
  377. Québec Canada 1
  378. Québec. Canada 1
  379. Republic of China 3
  380. Republic of Djibouti 1
  381. Republic of Florence 12
  382. Republic of Genoa 1
  383. Republic of India 1
  384. Republic of Ireland 1
  385. Republic of Korea 2
  386. Republic of Lucca 1
  387. Republic of San Marino 1
  388. Republic of Siena 1
  389. Republic of Venice 13
  390. Republic of Yugoslavia 83
  391. Rhodesia 3
  392. RI 1
  393. Rochlitz an der Iser 1
  394. Roman Empire 2
  395. Roman Republic 3
  396. Romania 381
  397. Rome 3
  398. Russia 39
  399. Russian Empire 344
  400. Russian Soviet Federative Socialist Republic 1
  401. San Francisco 1
  402. San Marino 1
  403. Saudi Arabia 2
  404. Saxony 1
  405. Schwarzwald 1
  406. Second French Empire 1
  407. Seitzerland 1
  408. Senegal 1
  409. Serbia 2
  410. SFR Yugoslavia 1
  411. Shanghai 1
  412. Siam 2
  413. Sicily 1
  414. Sierra Leone 1
  415. Singapore 41
  416. Slovakia 5
  417. Slovenia 2
  418. Somalia 4
  419. Somerset 1
  420. South Africa 82
  421. South African Republic 1
  422. South America 2
  423. South Australia 10
  424. South Korea 22
  425. South Vietnam 2
  426. Southern Netherlands 1
  427. Soviet Union 3
  428. Spain 887
  429. Spain. 1
  430. Spanish Empire 6
  431. Spanish Morocco 1
  432. Spanish Santo Domingo 1
  433. Sri Lanka 9
  434. Sudan 3
  435. Suisse 1
  436. Sultanate of Egypt 1
  437. Suriname 1
  438. Sweden 124
  439. Swedish Empire 4
  440. Swiss Confederacy 6
  441. Switzerland 160
  442. Syria 4
  443. Taiwan 23
  444. Tamil Nadu 1
  445. Tanganyika 1
  446. Tanzania 5
  447. Tasmania 1
  448. Territory of Papua and New Guinea 1
  449. Territory of the USA 1
  450. Thailand 31
  451. The Netherlands 15
  452. The Philippines 1
  453. The United Arab Emirates 1
  454. Thrace 1
  455. Timisoara 1
  456. Trinidad 9
  457. Trinidad and Tobago 7
  458. Tunisia 3
  459. Turkey 26
  460. U.S.A. 2
  461. Uganda 15
  462. UK 6268
  463. Ukraine 23
  464. Ukraine) 2
  465. Umayyad Caliphate 1
  466. Union of South Africa 43
  467. United Arab Emirates 2
  468. United Kingdom of the Netherlands 4
  469. United Kingdoms of Sweden and Norway 2
  470. United States 2
  471. United States of Colombia 1
  472. United States of the Ionian Islands 2
  473. Upper Canada 2
  474. URSS 3
  475. Uruguay 44
  476. US Virgin Islands 2
  477. USA 14462
  478. USSR 397
  479. VA 1
  480. Venetian Republic 2
  481. Veneto 1
  482. Venezuela 22
  483. Viana do Castelo 1
  484. Victoria 1
  485. Victoria. AUSTRALIA. 1
  486. Viet-Nam 1
  487. Vietnam 8
  488. Virgin Islands 1
  489. Vladivostok 1
  490. WA 1
  491. Wales 2
  492. Warsaw 1
  493. Weimar Republic 1
  494. West Africa 1
  495. West Australia 1
  496. West Gemany 1
  497. West Germany 864
  498. West Indies 1
  499. West-Germany 2
  500. Western Australia 3
  501. Western China 1
  502. Yemen 1
  503. Yugoslavia 69
  504. Yugoslavija 1
  505. Zaire 1
  506. Zambia 8
  507. Zhou Kingdom 1
  508. Zimbabwe 7
  509. Zlín 1
Advertisement
RAW Paste Data Copied
Advertisement