Gerald, thanks for this, it looks most interesting on both levels. i.e. The data release and your project work. Thank you for the information and your project.
On 2 November 2015 at 01:49, Gerald Bauer <gerald.bauer at gmail.com> wrote: > 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 > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Regards, Michael.j.Falconer.