A free open public domain world database & schema for use in any (programming) language (e.g. uses plain text datasets). Example:
### Continents
eu, Europe
sa, South America
na, North America
ca, Central America
ci, Caribbean
af, Africa
me, Middle East
as, Asia
pa, Pacific
### Countries
ca, Canada, CAN, 9_984_670 km², 34_278_406, un|north america
mx, México [Mexico], MEX, 1_972_550 km², 112_322_757, un|north america
us, United States, USA, 9_629_091 km², 314_167_157, un|north america
### Provinces
bc, British Columbia, Victoria, 922_509 km², en|western canada
ab, Alberta, Edmonton, 640_082 km², en|western canada|prairies
mb, Manitoba, Winnipeg, 552_330 km², en|western canada|prairies
sk, Saskatchewan, Regina, 588_239 km², en|western canada|prairies
nb, New Brunswick, Fredericton, 71_377 km², en|fr|eastern canada|atlantic canada|maritimes
ns, Nova Scotia, Halifax, 52_939 km², en|eastern canada|atlantic canada|maritimes
pe, Prince Edward Island, Charlottetown, 5_686 km², en|eastern canada|atlantic canada|maritimes
nl, Newfoundland and Labrador, St. John's, 370_511 km², en|eastern canada|atlantic canada
on, Ontario, Toronto, 908_608 km², en|eastern canada|central canada
qc, Québec, Quebec City, 1_356_547 km², fr|en|eastern canada|central canada
nt, Northwest Territories, Yellowknife, 1_143_793 km², en|fr|northern canada|territories
yt, Yukon, Whitehorse, 474_713 km², en|northern canada|territories
nu, Nunavut, Iqaluit, 1_877_788 km², iu|en|fr|northern canada|territories
### 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
...
Use the worlddb command line tool to build your own world.db copy
from the plain text datasets. More »
The world.db schema, scripts, n datasets are dedicated to the public domain.
Use it as you please with no restrictions whatsoever.
Send them along to the Open World Database (world.db) and Friends Forum/Mailing List. Thanks!