The World Factbook By CIA
The World Factbook, the indispensable source for basic information.
@kaggle.lucafrance_the_world_factbook_by_cia
The World Factbook, the indispensable source for basic information.
@kaggle.lucafrance_the_world_factbook_by_cia
The World Factbook is an almanac published by the Central Intelligence Agency (CIA).
The World Factbook, produced for US policymakers and coordinated throughout the US Intelligence Community, presents the basic realities about the world in which we live. We share these facts with the people of all nations in the belief that knowledge of the truth underpins the functioning of free societies.
Did You Know? - The World Factbook
Both files countries.json
and countries.csv
include the same information. The csv is constructed based on the json. Some columns are not shared across all countries. Depending on your use you can consider one file over the other.
The text is provided as is from the web page. Additional parsing might be necessary for numeric analysis.
The data has been scraped with Python.
The code is available here.
Note There is an entry for the entire world, you might consider removing it for your evaluations.
Note Some columns are not included in all countries. Each column in this list appears in at least one country.
CREATE TABLE countries (
"country" VARCHAR,
"url" VARCHAR,
"introduction_background" VARCHAR,
"geography_location" VARCHAR,
"geography_geographic_coordinates" VARCHAR,
"geography_map_references" VARCHAR,
"geography_area_total" VARCHAR,
"geography_area_land" VARCHAR,
"geography_area_water" VARCHAR,
"geography_area_comparative" VARCHAR,
"geography_land_boundaries_total" VARCHAR,
"geography_land_boundaries_border_countries_6" VARCHAR,
"geography_coastline" VARCHAR,
"geography_maritime_claims" VARCHAR,
"geography_climate" VARCHAR,
"geography_terrain" VARCHAR,
"geography_elevation_highest_point" VARCHAR,
"geography_elevation_lowest_point" VARCHAR,
"geography_elevation_mean_elevation" VARCHAR,
"geography_natural_resources" VARCHAR,
"geography_land_use_agricultural_land" VARCHAR,
"geography_land_use_forest" VARCHAR,
"geography_land_use_other" VARCHAR,
"geography_irrigated_land" VARCHAR,
"geography_major_lakes_area_sq_km_salt_water_lake_s" VARCHAR,
"geography_major_rivers_by_length_in_km" VARCHAR,
"geography_major_rivers_by_length_in_km_note" VARCHAR,
"geography_major_watersheds_area_sq_km" VARCHAR,
"geography_population_distribution" VARCHAR,
"geography_natural_hazards" VARCHAR,
"geography_geography_note" VARCHAR,
"people_and_society_population" VARCHAR,
"people_and_society_nationality_noun" VARCHAR,
"people_and_society_nationality_adjective" VARCHAR,
"people_and_society_ethnic_groups" VARCHAR,
"people_and_society_languages" VARCHAR,
"people_and_society_languages_major_language_sample_s" VARCHAR,
"people_and_society_languages_note_1" VARCHAR,
"people_and_society_languages_note_2" VARCHAR,
"people_and_society_religions" VARCHAR,
"people_and_society_age_structure_0_14_years" VARCHAR,
"people_and_society_age_structure_15_64_years" VARCHAR,
"people_and_society_age_structure_65_years_and_over" VARCHAR,
"people_and_society_dependency_ratios_total_dependency_ratio" VARCHAR,
"people_and_society_dependency_ratios_youth_dependency_ratio" VARCHAR,
"people_and_society_dependency_ratios_elderly_dependency_ratio" VARCHAR,
"people_and_society_dependency_ratios_potential_support_ratio" VARCHAR,
"people_and_society_median_age_total" VARCHAR,
"people_and_society_median_age_male" VARCHAR,
"people_and_society_median_age_female" VARCHAR,
"people_and_society_population_growth_rate" VARCHAR,
"people_and_society_birth_rate" VARCHAR,
"people_and_society_death_rate" VARCHAR,
"people_and_society_net_migration_rate" VARCHAR,
"people_and_society_population_distribution" VARCHAR,
"people_and_society_urbanization_urban_population" VARCHAR,
"people_and_society_urbanization_rate_of_urbanization" VARCHAR,
"people_and_society_major_urban_areas_population" VARCHAR,
"people_and_society_sex_ratio_at_birth" VARCHAR,
"people_and_society_sex_ratio_0_14_years" VARCHAR,
"people_and_society_sex_ratio_15_64_years" VARCHAR,
"people_and_society_sex_ratio_65_years_and_over" VARCHAR,
"people_and_society_sex_ratio_total_population" VARCHAR,
"people_and_society_mother_s_mean_age_at_first_birth" VARCHAR,
"people_and_society_mother_s_mean_age_at_first_birth_note" VARCHAR,
"people_and_society_maternal_mortality_ratio" VARCHAR,
"people_and_society_infant_mortality_rate_total" VARCHAR,
"people_and_society_infant_mortality_rate_male" VARCHAR,
"people_and_society_infant_mortality_rate_female" VARCHAR,
"people_and_society_life_expectancy_at_birth_total_population" VARCHAR,
"people_and_society_life_expectancy_at_birth_male" VARCHAR,
"people_and_society_life_expectancy_at_birth_female" VARCHAR,
"people_and_society_total_fertility_rate" VARCHAR,
"people_and_society_gross_reproduction_rate" VARCHAR,
"people_and_society_contraceptive_prevalence_rate" VARCHAR,
"people_and_society_contraceptive_prevalence_rate_note" VARCHAR,
"people_and_society_drinking_water_source_improved" VARCHAR,
"people_and_society_drinking_water_source_unimproved" VARCHAR,
"people_and_society_current_health_expenditure" VARCHAR,
"people_and_society_physicians_density" VARCHAR,
"people_and_society_hospital_bed_density" VARCHAR,
"people_and_society_sanitation_facility_access_improved" VARCHAR,
"people_and_society_sanitation_facility_access_unimproved" VARCHAR,
"people_and_society_major_infectious_diseases_degree_of_risk" VARCHAR,
"people_and_society_major_infectious_diseases_food_or_w_26e122d7" VARCHAR,
"people_and_society_major_infectious_diseases_vectorbor_8fe3e8d7" VARCHAR,
"people_and_society_major_infectious_diseases_note" VARCHAR,
"people_and_society_obesity_adult_prevalence_rate" VARCHAR,
"people_and_society_alcohol_consumption_per_capita_total" VARCHAR,
"people_and_society_alcohol_consumption_per_capita_beer" VARCHAR,
"people_and_society_alcohol_consumption_per_capita_wine" VARCHAR,
"people_and_society_alcohol_consumption_per_capita_spirits" VARCHAR,
"people_and_society_alcohol_consumption_per_capita_othe_5379ac54" VARCHAR,
"people_and_society_tobacco_use_total" VARCHAR,
"people_and_society_tobacco_use_male" VARCHAR,
"people_and_society_tobacco_use_female" VARCHAR,
"people_and_society_children_under_the_age_of_5_years_u_c3b8b7a8" VARCHAR,
"people_and_society_currently_married_women_ages_15_49" VARCHAR,
"people_and_society_child_marriage_women_married_by_age_15" VARCHAR,
"people_and_society_child_marriage_women_married_by_age_18" VARCHAR
);
Anyone who has the link will be able to view this.