Awesome
Willkommen - Benvenuto - ようこそ - Bienvenido - Welcome to world.db
A free open public domain world database & schema for use in any (programming) language (e.g. uses plain text datasets). Example:
### Continents (& Regions)
eu, Europe
sa, South America
na, North America
ca, Central America
ci, Caribbean
af, Africa
me, Middle East
as, Asia
pa, Pacific # includes Australia & New Zealand
aq, Antarctica
### Countries
ca, Canada, CAN, Ottawa, 9 984 670 km², 34 278 406
mx, México [Mexico], MEX, México D.F., 1 972 550 km², 112 322 757
us, United States, USA, Washington D.C., 9 629 091 km², 314 167 157
### Tags - Political Organizations
Canada, un|g8|g20|commonwealth
United States, un|g8|g20
México, un|g5|g20
### Tags - Sports Organizations
Canada, ioc|fifa › concacaf › nafu
United States, ioc|fifa › concacaf › nafu
México, ioc|fifa › concacaf › nafu
### Provinces
bc, British Columbia, Victoria, 922 509 km²
ab, Alberta, Edmonton, 640 082 km²
mb, Manitoba, Winnipeg, 552 330 km²
sk, Saskatchewan, Regina, 588 239 km²
nb, New Brunswick, Fredericton, 71 377 km²
ns, Nova Scotia, Halifax, 52 939 km²
pe, Prince Edward Island, Charlottetown, 5 686 km²
nl, Newfoundland and Labrador, St. John's, 370 511 km²
on, Ontario, Toronto, 908 608 km²
qc, Québec, Quebec City, 1 356 547 km²
nt, Northwest Territories, Yellowknife, 1 143 793 km²
yt, Yukon, Whitehorse, 474 713 km²
nu, Nunavut, Iqaluit, 1 877 788 km²
### Tags - Geo Regions
British Columbia, western_canada
Alberta, western_canada|prairies
Manitoba, western_canada|prairies
Saskatchewan, western_canada|prairies
New Brunswick, eastern_canada|atlantic_canada|maritimes
Nova Scotia, eastern_canada|atlantic_canada|maritimes
Prince Edward Island, eastern_canada|atlantic canada|maritimes
Newfoundland and Labrador, eastern_canada|atlantic_canada
Ontario, eastern_canada|central_canada
Québec, eastern_canada|central_canada
Northwest Territories, northern_canada|territories
Yukon, northern_canada|territories
Nunavut, northern_canada|territories
### Tags - (Official) Languages
British Columbia, en
Alberta, en
Manitoba, en
Saskatchewan, en
New Brunswick, en|fr
Nova Scotia, en
Prince Edward Island, en
Newfoundland and Labrador, en
Ontario, en
Québec, fr|en
Northwest Territories, en|fr
Yukon, en
Nunavut, iu|en|fr
### Cities
Toronto, ON, 5 583 064
Montréal|Montreal, QC, 3 824 221
Vancouver, BC, 2 313 328
Ottawa, ON, 1 236 324
Calgary, AB, 1 214 839
Edmonton, AB, 1 159 869
Québec, QC, 765 706
Winnipeg, MB, 730 018
Hamilton, ON, 721 053
Kitchener, ON, 477 160
London, ON, 474 786
...
### Country Codes - Alpha 2, Alpha 3, Numeric
Afghanistan, AF, AFG, 004
Åland Islands (FI), AX, ALA, 248
Albania, AL, ALB, 008
Algeria, DZ, DZA, 012
American Samoa (US), AS, ASM, 016
Andorra, AD, AND, 020
Angola, AO, AGO, 024
...
Build Your Own world.db
Copy
Use the worlddb
command line tool to build your own world.db
copy
from the plain text datasets. More »
License
The world.db
schema, scripts, n datasets are dedicated to the public domain.
Use it as you please with no restrictions whatsoever.
Questions? Comments?
Send them along to the Open World Database (world.db) and Friends Forum/Mailing List. Thanks!