Data source: https://ilsweb.cincinnatilibrary.org/collection-analysis-docs/

333 rows

View and edit SQL

Link rowid ▼ code display_order name
1   0 No country
2 aa 1 Albania
3 abc 2 Alberta
4 aca 3 Australian Capital Terr.
5 ae 4 Algeria
6 af 5 Afghanistan
7 ag 6 Argentina
8 ai 7 Armenia (Republic)
9 aj 8 Azerbaijan
10 aku 9 Alaska
11 alu 10 Alabama
12 am 11 Anquilla
13 an 12 Andorra
14 ao 13 Angola
15 aq 14 Antigua and Barbuda
16 aru 15 Arkansas
17 as 16 American Samoa
18 at 17 Australia
19 au 18 Austria
20 aw 19 Aruba
21 ay 20 Antarctica
22 azu 21 Arizona
23 ba 22 Bahrain
24 bb 23 Barbados
25 bcc 24 British Columbia
26 bd 25 Burundi
27 be 26 Belgium
28 bf 27 Bahamas
29 bg 28 Bangladesh
30 bh 29 Belize
31 bi 30 British Indian Ocean Terr.
32 bl 31 Brazil
33 bm 32 Bermuda Islands
34 bn 33 Bosnia and Hercegovina
35 bo 34 Bolivia
36 bp 35 Solomon Islands
37 br 36 Burma
38 bs 37 Botswana
39 bt 38 Bhutan
40 bu 39 Bulgaria
41 bv 40 Bouvet Island
42 bw 41 Belarus
43 bx 42 Brunei
44 ca 43 Caribbean Netherlands
45 cau 44 California
46 cb 45 Cambodia
47 cc 46 China
48 cd 47 Chad
49 ce 48 Sri Lanka
50 cf 49 Congo (Brazzaville)
51 cg 50 Congo (Democratic Republic)
52 ch 51 China (Republic : 1949- )
53 ci 52 Croatia
54 cj 53 Cayman Islands
55 ck 54 Colombia
56 cl 55 Chile
57 cm 56 Cameroon
58 co 57 Curaçao
59 cou 58 Colorado
60 cq 59 Comoros
61 cr 60 Costa Rica
62 ctu 61 Connecticut
63 cu 62 Cuba
64 cv 63 Cape Verde
65 cw 64 Cook Islands
66 cx 65 Central African Republic
67 cy 66 Cyprus
68 dcu 67 District of Columbia
69 deu 68 Delaware
70 dk 69 Denmark
71 dm 70 Benin
72 dq 71 Dominica
73 dr 72 Dominican Republic
74 ea 73 Eritrea
75 ec 74 Ecuador
76 eg 75 Equatorial Guinea
77 em 76 East Timor
78 enk 77 England
79 er 78 Estonia
80 es 79 El Salvador
81 et 80 Ethiopia
82 fa 81 Faroe Islands
83 fg 82 French Guiana
84 fi 83 Finland
85 fj 84 Fiji
86 fk 85 Falkland Islands
87 flu 86 Florida
88 fm 87 Micronesia (Federated Sts)
89 fp 88 French Polynesia
90 fr 89 France
91 fs 90 Terres australes&antarct.
92 ft 91 Djibouti
93 gau 92 Georgia
94 gb 93 Kiribati
95 gd 94 Grenada
96 gh 95 Ghana
97 gi 96 Gibraltar
98 gl 97 Greenland
99 gm 98 Gambia
100 go 99 Gabon

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE country_property_myuser (
	code TEXT, 
	display_order INTEGER, 
	name TEXT
);