Name: 🌍World Cities Population - Cleaned Version 🌍
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

🌍World Cities Population - Cleaned Version 🌍

About Dataset

All cities with a population seat of adm div (ca 80.000)Sources and Contributions Sources: GeoNames is aggregating over hundred different data sources. Ambassadors: GeoNames Ambassadors help in many countries. Wiki: A wiki allows you to view the data, quickly fix errors, and add missing places. Donations and Sponsoring: Costs for running GeoNames are covered by donations and sponsoring.enrichment:add country name

Context

Name
Country Code
Country Name
Timezone
Population
Latitude
Longitude
Acknowledgments
These data come from Maxmind.com and have not been altered. The original source can be found by clicking here

Additionally,
Reference
https://download.geonames.org/export/dump/
Attributions
https://www.geonames.org/about.html

Tables

Population Cleaned

@kaggle.donatoriccio_world_cities_population_cleaned_version.population_cleaned

12.97 MB
140,632 rows
10 columns

CREATE TABLE population_cleaned (
  "name" VARCHAR,
  "ascii_name" VARCHAR,
  "alternate_names" VARCHAR,
  "country_code" VARCHAR,
  "country_name_en" VARCHAR,
  "population" DOUBLE,
  "timezone" VARCHAR,
  "label_en" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);