Hello,
I've started a new project, that is, /factbook.sql [1] that offers
an SQL schema for the World Factbook and 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] https://github.com/factbook/factbook.sql
[2] https://github.com/factbook/factbook.sql/releases
[3] https://www.cia.gov/library/publications/the-world-factbook
