SHARE
TWEET

Rough list of author countries from ISFDB database

a guest Jun 1st, 2019 122 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top