factbook.sql World Factbook Country Profiles in SQL (Incl. factbook.db - Single-File SQLite Distro)

[Gerald Bauer]

Hello,

I've started a new project, that is, /factbook.sql [1] that offers
an SQL schema for the World Factbookand also includes a pre-built
single-file SQLite database, that is, factbook.db [2] for download.

What's the World Factbook?

The World Factbook [3] published by the Central Intelligence Agency
(CIA) offers free 260+ country profiles in the public domain (that is,
no copyright(s), no rights reserved).

Anyways, what's it good for? For example, to find the ten largest
countries by area, try:

SELECT name, area FROM facts ORDER BY area DESC LIMIT 10;

Resulting in:

Russia | 17_098_242
Canada | 9_984_670
United States | 9_826_675
China | 9_596_960
Brazil | 8_515_770
Australia | 7_741_220
European Union | 4_324_782
India | 3_287_263
Argentina | 2_780_400
Kazakhstan | 2_724_900

Or to find the ten largest countries by population, try:

SELECT name, population FROM facts ORDER BY population DESC LIMIT 10;

Resulting in:

World | 7_256_490_011
China | 1_367_485_388
India | 1_251_695_584
European Union | 513_949_445
United States | 321_368_864
Indonesia | 255_993_674
Brazil | 204_259_812
Pakistan | 199_085_847
Nigeria | 181_562_056
Bangladesh | 168_957_745

And so on. Note: Using the factbook command line tool and scripts you
can build yourself an up-to-date copy.

Questions? Comments? Welcome. Enjoy. Cheers.

[1] github.com/factbook/factbook.sql
[2] github.com/factbook/factbook.sql/releases
[3] www.cia.gov/library/publications/the-world-factbook