API tools faq
paste
Advertisement
Guest User

Rough list of author countries from ISFDB database

a guest
Jun 1st, 2019
608
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.93 KB | None | 0 0
raw download clone embed print report
  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
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!