Name: GeoNames - All Cities
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

GeoNames - All Cities

All cities with a population > 500 or seats of adm div (ca 135.000)
Sources and Contributions

Sources : GeoNames is aggregating over hundred different data sources.
Ambassadors : GeoNames Ambassadors help in many countries.
Wiki : A wiki allows to view the data and quickly fix error and add missing places.
Donations and Sponsoring : Costs for running GeoNames are covered by donations and sponsoring.

Tables

Geonames All Cities With A Population 500

@kaggle.joebeachcapital_geonames_all_cities.geonames_all_cities_with_a_population_500

22.48 MB
199727 rows
21 columns


CREATE TABLE geonames_all_cities_with_a_population_500 (
  "geoname_id" BIGINT,
  "name" VARCHAR,
  "ascii_name" VARCHAR,
  "alternate_names" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "feature_class" VARCHAR,
  "feature_code" VARCHAR,
  "country_code" VARCHAR,
  "country_code_2" VARCHAR,
  "admin1_code" VARCHAR,
  "admin2_code" VARCHAR,
  "admin3_code" VARCHAR,
  "admin4_code" VARCHAR,
  "population" BIGINT,
  "elevation" DOUBLE,
  "digital_elevation_model" BIGINT,
  "timezone" VARCHAR,
  "modification_date" TIMESTAMP,
  "country" VARCHAR,
  "coordinates" VARCHAR
);