Analyzing CIA Factbook Data Using SQL
Doing a lot of exploratory analysis with data from: factbook.db >> https://github.com/factbook
This data is interesting for people who:
- Will probably watch National Geographic
- Are curious about the world
- Probably love travel, discovery and being global citizens
- Also great for introducing kids to geography in a fun, discovery way.
The main questions that I answer at the end of the analysis include:
-
Getting an overview of the data
-
Summary statistics of the world's largest and smallest country population and sizes/areas
-
Exploration of outliers
-
Exploring average population and area
-
Discovering densely populated areas (where population > average and area < average
-
Discovering which countries have the highest ratios of water to land where water area > land
-
Discovering which countries will add the most people to their population next year
-
Finding out which countries have a higher death rate than birth rate //this should be alarming