Name: GeoNames: Global Gazetteer Of Places And Features
Creator: GeoNames
License: https://download.geonames.org/export/dump/readme.txt

About this Dataset

GeoNames: Global Gazetteer Of Places And Features

This dataset provides comprehensive global geographical information sourced from the GeoNames database.

It includes millions of named places—cities, towns, mountains, rivers, and other geographic features—across all countries.
Each entry contains coordinates, feature classifications, administrative codes, population estimates, and timezone data.

The dataset supports a wide range of use cases, including geospatial indexing, location-based filtering, map rendering,
and demographic or administrative region analysis.

Tables

All Named Places Worldwide

@geonames.geonames.all_places

775.14 MB
13,378,136 rows
19 columns

CREATE TABLE all_places (
  "geonameid" BIGINT,
  "name" VARCHAR,
  "asciiname" VARCHAR,
  "alternatenames" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "feature_class" VARCHAR,
  "feature_code" VARCHAR,
  "country_code" VARCHAR,
  "cc2" VARCHAR,
  "admin1_code" VARCHAR,
  "admin2_code" VARCHAR,
  "admin3_code" VARCHAR,
  "admin4_code" VARCHAR,
  "population" BIGINT,
  "elevation" DOUBLE,
  "dem" BIGINT,
  "timezone" VARCHAR,
  "modification_date" TIMESTAMP
);

Cities With A Population > 1000

@geonames.geonames.cities_1000

16.88 MB
163,392 rows
19 columns

CREATE TABLE cities_1000 (
  "geonameid" BIGINT,
  "name" VARCHAR,
  "asciiname" VARCHAR,
  "alternatenames" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "feature_class" VARCHAR,
  "feature_code" VARCHAR,
  "country_code" VARCHAR,
  "cc2" VARCHAR,
  "admin1_code" VARCHAR,
  "admin2_code" VARCHAR,
  "admin3_code" VARCHAR,
  "admin4_code" VARCHAR,
  "population" BIGINT,
  "elevation" DOUBLE,
  "dem" BIGINT,
  "timezone" VARCHAR,
  "modification_date" TIMESTAMP
);

Cities With A Population > 15000

@geonames.geonames.cities_15000

4.95 MB
32,884 rows
19 columns

CREATE TABLE cities_15000 (
  "geonameid" BIGINT,
  "name" VARCHAR,
  "asciiname" VARCHAR,
  "alternatenames" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "feature_class" VARCHAR,
  "feature_code" VARCHAR,
  "country_code" VARCHAR,
  "cc2" VARCHAR,
  "admin1_code" VARCHAR,
  "admin2_code" VARCHAR,
  "admin3_code" VARCHAR,
  "admin4_code" VARCHAR,
  "population" BIGINT,
  "elevation" DOUBLE,
  "dem" BIGINT,
  "timezone" VARCHAR,
  "modification_date" TIMESTAMP
);

Cities With A Population > 500

@geonames.geonames.cities_500

21.59 MB
225,764 rows
19 columns

CREATE TABLE cities_500 (
  "geonameid" BIGINT,
  "name" VARCHAR,
  "asciiname" VARCHAR,
  "alternatenames" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "feature_class" VARCHAR,
  "feature_code" VARCHAR,
  "country_code" VARCHAR,
  "cc2" VARCHAR,
  "admin1_code" VARCHAR,
  "admin2_code" VARCHAR,
  "admin3_code" VARCHAR,
  "admin4_code" VARCHAR,
  "population" BIGINT,
  "elevation" DOUBLE,
  "dem" BIGINT,
  "timezone" VARCHAR,
  "modification_date" TIMESTAMP
);

Cities With A Population > 5000

@geonames.geonames.cities_5000

8.47 MB
66,751 rows
19 columns

CREATE TABLE cities_5000 (
  "geonameid" BIGINT,
  "name" VARCHAR,
  "asciiname" VARCHAR,
  "alternatenames" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "feature_class" VARCHAR,
  "feature_code" VARCHAR,
  "country_code" VARCHAR,
  "cc2" VARCHAR,
  "admin1_code" VARCHAR,
  "admin2_code" VARCHAR,
  "admin3_code" VARCHAR,
  "admin4_code" VARCHAR,
  "population" BIGINT,
  "elevation" DOUBLE,
  "dem" BIGINT,
  "timezone" VARCHAR,
  "modification_date" TIMESTAMP
);

Feature Codes

@geonames.geonames.feature_codes

40.37 kB
684 rows
4 columns

CREATE TABLE feature_codes (
  "feature_class" VARCHAR,
  "feature_code" VARCHAR,
  "name" VARCHAR,
  "description" VARCHAR
);