defconcepts / world.db

Free open public domain world database 'n' schema for use in any (programming) language (e.g. uses plain text datasets)

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
...

More world.db Project Site »

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!