Global Country Information Dataset 2023
A Comprehensive Dataset Empowering In-Depth Analysis and Cross-Country Insights
@kaggle.nelgiriyewithana_countries_of_the_world_2023
A Comprehensive Dataset Empowering In-Depth Analysis and Cross-Country Insights
@kaggle.nelgiriyewithana_countries_of_the_world_2023
This comprehensive dataset provides a wealth of information about all countries worldwide, covering a wide range of indicators and attributes. It encompasses demographic statistics, economic indicators, environmental factors, healthcare metrics, education statistics, and much more. With every country represented, this dataset offers a complete global perspective on various aspects of nations, enabling in-depth analyses and cross-country comparisons.
- Country: Name of the country.
- Analyze population density and land area to study spatial distribution patterns.
Data Source: This dataset was compiled from multiple data sources
If this was helpful, a vote is appreciated ❤️ Thank you 🙂
CREATE TABLE world_data_2023 (
"country" VARCHAR,
"density_p_km2" BIGINT -- Density (P/Km2),
"abbreviation" VARCHAR,
"agricultural_land" VARCHAR -- Agricultural Land( %),
"land_area_km2" DOUBLE -- Land Area(Km2),
"armed_forces_size" DOUBLE,
"birth_rate" DOUBLE,
"calling_code" DOUBLE,
"capital_major_city" VARCHAR,
"co2_emissions" DOUBLE,
"cpi" DOUBLE,
"cpi_change" VARCHAR -- CPI Change (%),
"currency_code" VARCHAR,
"fertility_rate" DOUBLE,
"forested_area" VARCHAR -- Forested Area (%),
"gasoline_price" VARCHAR,
"gdp" VARCHAR,
"gross_primary_education_enrollment" VARCHAR -- Gross Primary Education Enrollment (%),
"gross_tertiary_education_enrollment" VARCHAR -- Gross Tertiary Education Enrollment (%),
"infant_mortality" DOUBLE,
"largest_city" VARCHAR,
"life_expectancy" DOUBLE,
"maternal_mortality_ratio" DOUBLE,
"minimum_wage" VARCHAR,
"official_language" VARCHAR,
"out_of_pocket_health_expenditure" VARCHAR,
"physicians_per_thousand" DOUBLE,
"population" DOUBLE,
"population_labor_force_participation" VARCHAR -- Population: Labor Force Participation (%),
"tax_revenue" VARCHAR -- Tax Revenue (%),
"total_tax_rate" VARCHAR,
"unemployment_rate" VARCHAR,
"urban_population" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE
);Anyone who has the link will be able to view this.