Baselight

🌍World Cities Population - Cleaned Version 🌍

Ready for EDA or data analysis

@kaggle.donatoriccio_world_cities_population_cleaned_version

Population Cleaned
@kaggle.donatoriccio_world_cities_population_cleaned_version.population_cleaned

  • 12.37 MB
  • 140632 rows
  • 10 columns
name

Name

ascii_name

ASCII Name

alternate_names

Alternate Names

country_code

Country Code

country_name_en

Country Name EN

population

Population

timezone

Timezone

label_en

LABEL EN

latitude

Latitude

longitude

Longitude

PizhankaPizhankaPizhanka,Pizjanka,ПижанкаRURussian Federation3900Europe/KirovRussian Federation57.4604248.542
PitelinoPitelinoPetelino,Pitelino,ПителиноRURussian Federation2355Europe/MoscowRussian Federation54.5776841.81448
Petro-SlavyankaPetro-SlavyankaPetro-Slav'anka,Petro-Slavjanka,Petro-Slavyanka,Петро-СлавянкаRURussian Federation1308Europe/MoscowRussian Federation59.8022230.50694
PalkinoPalkinoPalkino,Палкино,ՊալկինոRURussian Federation3112Europe/MoscowRussian Federation57.5408928.01257
OrlovkaOrlovkaOrlovka,ОрловкаRURussian Federation3236Europe/MoscowRussian Federation44.6913944.17444
Oktyabr’skiyOktyabr'skiyOKT,Oktiabr'skil,Oktiabr’skil,Oktjabr'skij,Oktjabrskij,Oktyabr'skiy,Oktyabrsk,Oktyabr’skiy,ОктябрьскийRURussian Federation108200Asia/YekaterinburgRussian Federation54.4814753.47103
NuradilovoNuradilovoDaud-Otar,Daut,Nuradilovo,НурадиловоRURussian Federation3371Europe/MoscowRussian Federation43.2844746.45763
Novyy RopskNovyy RopskNov.Ropsk,Novy Ropsk,Novyj Ropsk,Novyy Ropsk,Ropsk,Новый РопскRURussian Federation1293Europe/MoscowRussian Federation52.2967832.31226
Novyye Kuz’minkiNovyye Kuz'minkiNovye Kuz'minki,Novyye Kuz'minki,Novyye Kuz’minki,Новые КузьминкиRURussian Federation143000Europe/MoscowRussian Federation55.737.75
Novo-TalitsyNovo-TalitsyNovo-Talicy,Ново-ТалицыRURussian Federation8563Europe/MoscowRussian Federation57.0039240.85936

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
);

Share link

Anyone who has the link will be able to view this.