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 -- Introduction: Background,
"geography_location" VARCHAR -- Geography: Location,
"geography_geographic_coordinates" VARCHAR -- Geography: Geographic Coordinates,
"geography_map_references" VARCHAR -- Geography: Map References,
"geography_area_total" VARCHAR -- Geography: Area - Total,
"geography_area_land" VARCHAR -- Geography: Area - Land,
"geography_area_water" VARCHAR -- Geography: Area - Water,
"geography_area_comparative" VARCHAR -- Geography: Area - Comparative,
"geography_land_boundaries_total" VARCHAR -- Geography: Land Boundaries - Total,
"geography_land_boundaries_border_countries_6" VARCHAR -- Geography: Land Boundaries - Border Countries (6),
"geography_coastline" VARCHAR -- Geography: Coastline,
"geography_maritime_claims" VARCHAR -- Geography: Maritime Claims,
"geography_climate" VARCHAR -- Geography: Climate,
"geography_terrain" VARCHAR -- Geography: Terrain,
"geography_elevation_highest_point" VARCHAR -- Geography: Elevation - Highest Point,
"geography_elevation_lowest_point" VARCHAR -- Geography: Elevation - Lowest Point,
"geography_elevation_mean_elevation" VARCHAR -- Geography: Elevation - Mean Elevation,
"geography_natural_resources" VARCHAR -- Geography: Natural Resources,
"geography_land_use_agricultural_land" VARCHAR -- Geography: Land Use - Agricultural Land,
"geography_land_use_forest" VARCHAR -- Geography: Land Use - Forest,
"geography_land_use_other" VARCHAR -- Geography: Land Use - Other,
"geography_irrigated_land" VARCHAR -- Geography: Irrigated Land,
"geography_major_lakes_area_sq_km_salt_water_lake_s" VARCHAR -- Geography: Major Lakes (area Sq Km) - Salt Water Lake(s),
"geography_major_rivers_by_length_in_km" VARCHAR -- Geography: Major Rivers (by Length In Km),
"geography_major_rivers_by_length_in_km_note" VARCHAR -- Geography: Major Rivers (by Length In Km) - Note,
"geography_major_watersheds_area_sq_km" VARCHAR -- Geography: Major Watersheds (area Sq Km),
"geography_population_distribution" VARCHAR -- Geography: Population Distribution,
"geography_natural_hazards" VARCHAR -- Geography: Natural Hazards,
"geography_geography_note" VARCHAR -- Geography: Geography - Note,
"people_and_society_population" VARCHAR -- People And Society: Population,
"people_and_society_nationality_noun" VARCHAR -- People And Society: Nationality - Noun,
"people_and_society_nationality_adjective" VARCHAR -- People And Society: Nationality - Adjective,
"people_and_society_ethnic_groups" VARCHAR -- People And Society: Ethnic Groups,
"people_and_society_languages" VARCHAR -- People And Society: Languages,
"people_and_society_languages_major_language_sample_s" VARCHAR -- People And Society: Languages - Major-language Sample(s),
"people_and_society_languages_note_1" VARCHAR -- People And Society: Languages - Note 1,
"people_and_society_languages_note_2" VARCHAR -- People And Society: Languages - Note 2,
"people_and_society_religions" VARCHAR -- People And Society: Religions,
"people_and_society_age_structure_0_14_years" VARCHAR -- People And Society: Age Structure - 0-14 Years,
"people_and_society_age_structure_15_64_years" VARCHAR -- People And Society: Age Structure - 15-64 Years,
"people_and_society_age_structure_65_years_and_over" VARCHAR -- People And Society: Age Structure - 65 Years And Over,
"people_and_society_dependency_ratios_total_dependency_ratio" VARCHAR -- People And Society: Dependency Ratios - Total Dependency Ratio,
"people_and_society_dependency_ratios_youth_dependency_ratio" VARCHAR -- People And Society: Dependency Ratios - Youth Dependency Ratio,
"people_and_society_dependency_ratios_elderly_dependency_ratio" VARCHAR -- People And Society: Dependency Ratios - Elderly Dependency Ratio,
"people_and_society_dependency_ratios_potential_support_ratio" VARCHAR -- People And Society: Dependency Ratios - Potential Support Ratio,
"people_and_society_median_age_total" VARCHAR -- People And Society: Median Age - Total,
"people_and_society_median_age_male" VARCHAR -- People And Society: Median Age - Male,
"people_and_society_median_age_female" VARCHAR -- People And Society: Median Age - Female,
"people_and_society_population_growth_rate" VARCHAR -- People And Society: Population Growth Rate,
"people_and_society_birth_rate" VARCHAR -- People And Society: Birth Rate,
"people_and_society_death_rate" VARCHAR -- People And Society: Death Rate,
"people_and_society_net_migration_rate" VARCHAR -- People And Society: Net Migration Rate,
"people_and_society_population_distribution" VARCHAR -- People And Society: Population Distribution,
"people_and_society_urbanization_urban_population" VARCHAR -- People And Society: Urbanization - Urban Population,
"people_and_society_urbanization_rate_of_urbanization" VARCHAR -- People And Society: Urbanization - Rate Of Urbanization,
"people_and_society_major_urban_areas_population" VARCHAR -- People And Society: Major Urban Areas - Population,
"people_and_society_sex_ratio_at_birth" VARCHAR -- People And Society: Sex Ratio - At Birth,
"people_and_society_sex_ratio_0_14_years" VARCHAR -- People And Society: Sex Ratio - 0-14 Years,
"people_and_society_sex_ratio_15_64_years" VARCHAR -- People And Society: Sex Ratio - 15-64 Years,
"people_and_society_sex_ratio_65_years_and_over" VARCHAR -- People And Society: Sex Ratio - 65 Years And Over,
"people_and_society_sex_ratio_total_population" VARCHAR -- People And Society: Sex Ratio - Total Population,
"people_and_society_mother_s_mean_age_at_first_birth" VARCHAR -- People And Society: Mother\u0027s Mean Age At First Birth,
"people_and_society_mother_s_mean_age_at_first_birth_note" VARCHAR -- People And Society: Mother\u0027s Mean Age At First Birth - Note,
"people_and_society_maternal_mortality_ratio" VARCHAR -- People And Society: Maternal Mortality Ratio,
"people_and_society_infant_mortality_rate_total" VARCHAR -- People And Society: Infant Mortality Rate - Total,
"people_and_society_infant_mortality_rate_male" VARCHAR -- People And Society: Infant Mortality Rate - Male,
"people_and_society_infant_mortality_rate_female" VARCHAR -- People And Society: Infant Mortality Rate - Female,
"people_and_society_life_expectancy_at_birth_total_population" VARCHAR -- People And Society: Life Expectancy At Birth - Total Population,
"people_and_society_life_expectancy_at_birth_male" VARCHAR -- People And Society: Life Expectancy At Birth - Male,
"people_and_society_life_expectancy_at_birth_female" VARCHAR -- People And Society: Life Expectancy At Birth - Female,
"people_and_society_total_fertility_rate" VARCHAR -- People And Society: Total Fertility Rate,
"people_and_society_gross_reproduction_rate" VARCHAR -- People And Society: Gross Reproduction Rate,
"people_and_society_contraceptive_prevalence_rate" VARCHAR -- People And Society: Contraceptive Prevalence Rate,
"people_and_society_contraceptive_prevalence_rate_note" VARCHAR -- People And Society: Contraceptive Prevalence Rate - Note,
"people_and_society_drinking_water_source_improved" VARCHAR -- People And Society: Drinking Water Source - Improved,
"people_and_society_drinking_water_source_unimproved" VARCHAR -- People And Society: Drinking Water Source - Unimproved,
"people_and_society_current_health_expenditure" VARCHAR -- People And Society: Current Health Expenditure,
"people_and_society_physicians_density" VARCHAR -- People And Society: Physicians Density,
"people_and_society_hospital_bed_density" VARCHAR -- People And Society: Hospital Bed Density,
"people_and_society_sanitation_facility_access_improved" VARCHAR -- People And Society: Sanitation Facility Access - Improved,
"people_and_society_sanitation_facility_access_unimproved" VARCHAR -- People And Society: Sanitation Facility Access - Unimproved,
"people_and_society_major_infectious_diseases_degree_of_risk" VARCHAR -- People And Society: Major Infectious Diseases - Degree Of Risk,
"people_and_society_major_infectious_diseases_food_or_w_26e122d7" VARCHAR -- People And Society: Major Infectious Diseases - Food Or Waterborne Diseases,
"people_and_society_major_infectious_diseases_vectorbor_8fe3e8d7" VARCHAR -- People And Society: Major Infectious Diseases - Vectorborne Diseases,
"people_and_society_major_infectious_diseases_note" VARCHAR -- People And Society: Major Infectious Diseases - Note,
"people_and_society_obesity_adult_prevalence_rate" VARCHAR -- People And Society: Obesity - Adult Prevalence Rate,
"people_and_society_alcohol_consumption_per_capita_total" VARCHAR -- People And Society: Alcohol Consumption Per Capita - Total,
"people_and_society_alcohol_consumption_per_capita_beer" VARCHAR -- People And Society: Alcohol Consumption Per Capita - Beer,
"people_and_society_alcohol_consumption_per_capita_wine" VARCHAR -- People And Society: Alcohol Consumption Per Capita - Wine,
"people_and_society_alcohol_consumption_per_capita_spirits" VARCHAR -- People And Society: Alcohol Consumption Per Capita - Spirits,
"people_and_society_alcohol_consumption_per_capita_othe_5379ac54" VARCHAR -- People And Society: Alcohol Consumption Per Capita - Other Alcohols,
"people_and_society_tobacco_use_total" VARCHAR -- People And Society: Tobacco Use - Total,
"people_and_society_tobacco_use_male" VARCHAR -- People And Society: Tobacco Use - Male,
"people_and_society_tobacco_use_female" VARCHAR -- People And Society: Tobacco Use - Female,
"people_and_society_children_under_the_age_of_5_years_u_c3b8b7a8" VARCHAR -- People And Society: Children Under The Age Of 5 Years Underweight,
"people_and_society_currently_married_women_ages_15_49" VARCHAR -- People And Society: Currently Married Women (ages 15-49),
"people_and_society_child_marriage_women_married_by_age_15" VARCHAR -- People And Society: Child Marriage - Women Married By Age 15,
"people_and_society_child_marriage_women_married_by_age_18" VARCHAR -- People And Society: Child Marriage - Women Married By Age 18
);Anyone who has the link will be able to view this.