Name: Geolocation Data [Longitude Latitude]
Creator: Kaggle
License: http://opendatacommons.org/licenses/odbl/1.0/

About this Dataset

Geolocation Data [Longitude Latitude]

Context

Full Database of city state country available in CSV format. All Countries, States & Cities are Covered & Populated with Different Combinations & Versions.

Each CSV has the

Longitude
Latitude

of each location, alongside other miscellaneous country data such as
3. Currency
4. State code
5. Phone country code

Content

Total Countries : 250
Total States/Regions/Municipalities : 4,963
Total Cities/Towns/Districts : 148,061

Last Updated On : 29th January 2022

Source

https://github.com/dr5hn/countries-states-cities-database

Tables

Cities

@kaggle.liewyousheng_geolocation.cities

6.1 MB
148,061 rows
11 columns

CREATE TABLE cities (
  "id" BIGINT,
  "name" VARCHAR,
  "state_id" BIGINT,
  "state_code" VARCHAR,
  "state_name" VARCHAR,
  "country_id" BIGINT,
  "country_code" VARCHAR,
  "country_name" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "wikidataid" VARCHAR
);

Countries

@kaggle.liewyousheng_geolocation.countries

51.01 kB
250 rows
19 columns

CREATE TABLE countries (
  "id" BIGINT,
  "name" VARCHAR,
  "iso3" VARCHAR,
  "iso2" VARCHAR,
  "numeric_code" BIGINT,
  "phone_code" VARCHAR,
  "capital" VARCHAR,
  "currency" VARCHAR,
  "currency_name" VARCHAR,
  "currency_symbol" VARCHAR,
  "tld" VARCHAR,
  "native" VARCHAR,
  "region" VARCHAR,
  "subregion" VARCHAR,
  "timezones" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "emoji" VARCHAR,
  "emojiu" VARCHAR
);

States

@kaggle.liewyousheng_geolocation.states

206.09 kB
4,963 rows
9 columns

CREATE TABLE states (
  "id" BIGINT,
  "name" VARCHAR,
  "country_id" BIGINT,
  "country_code" VARCHAR,
  "country_name" VARCHAR,
  "state_code" VARCHAR,
  "type" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);