dr5hn/

countries-states-cities-database

🌍World countries, states/regions, cities in JSON, SQL, XML, PLIST, YAML and CSV. All Countries, Cities, States with ISO2, ISO3, Country Code, Phone Code, Capital and Currency [Linked with Each Other By ID] [Countries-States-Cities-Database]

Owners:

$0.00

USD raised

Recent activities

dr5hn added the repository

over 5 years ago

Issues

Funded Unfunded Rewarded Closed

wrong district for Agios Tychonas n Cyprus

Unfunded#318created byd668

$0.00

A Missing City In Benue

Unfunded#306created bydigitalkingsley

$0.00

cities.xml/cities.csv should include WikiDataID

Unfunded#307created bybuko

$0.00

Add currency name

Unfunded#308created byldavidsp

$0.00

Missing Cities and Regions for country_code TZ

Unfunded#309created bydr5hn

$0.00

Missing Town in NJ

Unfunded#312created byBazoqa

$0.00

Missing States in GHANA (GH)

Unfunded#313created byLawrenceAddo

$0.00

Some Parts of the Philippines are missing some places

Unfunded#314created byfrancis150

$0.00

anyone has clean record of the cities without using cultural

Unfunded#316created bydigital53

$0.00

Correct list of Istanbul's districts (or cities)

Unfunded#317created byerenakbulut-q

$0.00

Get details of a city

Unfunded#296created byMateozmaldonado17

$0.00

Cities of Basel-Stadt State in Switzerland

Unfunded#324created byYekbun

$0.00

Keelung is not a Chinese province, it is just a city

Unfunded#325created bygetandplay

$0.00

Nicaragua departament missing

Unfunded#328created byedgewl2

$0.00

Missing State and City Data

Unfunded#329created byAsadAyyub

$0.00

Karnatka states city name spelling need to be corrected

Unfunded#333created byValueHome

$0.00

Missing Rosebery Australia City in New South Wales

Unfunded#334created byShashi-GS

$0.00

City Mismatch

Unfunded#338created bySteevoh120

$0.00

States/Regions in France

Unfunded#339created byjosegabrielcruz

$0.00

Can you update States.csv file with new column country_name? Thanx for the database of all city, state and country

Unfunded#341created byksbhatiya

$0.00

License clarification

Unfunded#272created bydineshkp

$0.00

Chilean Cities Updated .XLSX

Unfunded#255created bymatiasrojastoro

$0.00

complete

Unfunded#256created byi7eo

$0.00

ERROR importing states.sql

Unfunded#259created byabdullahsalma

$0.00

cities.sql

Unfunded#260created byabdullahsalma

$0.00

Missing Kōchi Prefecture in Japan

Unfunded#262created byjoaorb64

$0.00

Eastern Visayas State (Philippines) don't have any countries, which is wrong.

Unfunded#264created bydr5hn

$0.00

Update States & Cities

Unfunded#265created bydr5hn

$0.00

Some country Cities are not available can you please help to resolve this issue

Unfunded#270created byapurba-biswas-9

$0.00

countries.sql

Unfunded#271created byabdullahsalma

$0.00

Add Locality/Area names and cities Pin Codes / Zip.

Unfunded#344created byValueHome

$0.00

Outdated Province info for the Democratic Republic of the Congo

Unfunded#280created byPCJPablo

$0.00

Install Package

Unfunded#281created bymariohmol

$0.00

thailand

Unfunded#282created bytien-oii

$0.00

world.sql can't be imported twice - will fail with Cannot add foreign key constraint

Unfunded#286created byfeliperaul

$0.00

Wrong state name in Brazil - Federal District

Unfunded#287created byfeliperaul

$0.00

DB vs JSON file and DB-Schema

Unfunded#289created byemresaracoglu

$0.00

Saudia State Cities not mapped according to Source

Unfunded#291created byray-man

$0.00

Very long city name

Unfunded#294created bynicmorais

$0.00

Morningside (Pittsburgh) Missing

Unfunded#400created bybimaldave

$0.00

Request an API Key

Unfunded#390created byyyyyy1111122

$0.00

Miss city

Unfunded#392created bytopaloff

$0.00

Some States have 'wikiDataId' value MANUAL

Unfunded#393created byFreelenzer

$0.00

UA information is outdated

Unfunded#394created byNazariy

$0.00

Remove tab characters from data

Unfunded#395created byoctocat-1

$0.00

Sweden duplicate cities

Unfunded#396created byscriptcoded

$0.00

Incorrect country name: "Bahamas The"

Unfunded#397created byoctocat-1

$0.00

Request API Key

Unfunded#398created by350887156

$0.00

Incorrect city name "Saint-Côme--Linière"

Unfunded#399created byoctocat-1

$0.00

ARABIC

Unfunded#389created byikram3mkaissi

$0.00

A city called Ranipet is missing in the state of Tamil Nadu in India

Unfunded#405created byfebtech

$0.00

State details not found error for Iran States

Unfunded#406created byMostafaMobed

$0.00

country-state-city - Sync database updates

Unfunded#407created bymoolotfy

$0.00

countries-states-cities-database/sql/cities.sql upload error

Unfunded#412created bySujon-Ahmed

$0.00

Malaga Australia suburb is missing.

Unfunded#415created byShashi-GS

$0.00

Flag are not coming on the new browser versions

Unfunded#418created byneerajsharma-kiwi

$0.00

Australia suburbs are missing!

Unfunded#419created byShashi-GS

$0.00

Large cache on hml ambient

Unfunded#428created byburgodev

$0.00

Cities SQL "state_id" Numbers are Off by 207

Unfunded#373created byProBidPro

$0.00

Banksmeadow and Whale Beach of NSW Australia is missing.

Unfunded#345created byShashi-GS

$0.00

Images for states and cities required.

Unfunded#348created byShiba-Kar

$0.00

Missing cities in Vietnam

Unfunded#349created bytranghan

$0.00

Wrong WikiDataIds for some cities

Unfunded#352created byevancampbell

$0.00

missing Istanbul city

Unfunded#353created byAlameenAzad

$0.00

Missing neighborhood in Uruguay-Montevideo

Unfunded#355created byMathiMate

$0.00

Type of state of Canada should be "province"

Unfunded#356created bySamuelCarreau

$0.00

In Egypt, There is a state that does not exist

Unfunded#359created bymoolotfy

$0.00

JSON and CSV Country Table does not contain "wikiDataId"

Unfunded#362created byFreelenzer

$0.00

Prague weird names

Unfunded#254created byBaku452

$0.00

Wrong city name

Unfunded#374created bysteminist-ua

$0.00

Cambodia does not have state

Unfunded#375created bysoeurngsar

$0.00

Brazil: "Amazonas" and "Santa Catarina" states do not have lat/lng

Unfunded#376created byjoaorb64

$0.00

American Samoa appears as State inside United States

Unfunded#378created bythe-douglas-soares

$0.00

Why is everything duplicated?

Unfunded#379created bybraaar

$0.00

Huntingwood and Eagle_Farm cities are missing in Australia.

Unfunded#385created byShashi-GS

$0.00

Latitude & Longitude Missing from Punjab (PB), State in India

Unfunded#386created byZenithClown

$0.00

Missing a city in US

Unfunded#388created bybabyrusa

$0.00

Running Script in Sql Server

Unfunded#153created bySobi1995

$0.00

Cities are missing in colombo and kandy District of Sri lanka

Unfunded#123created bypsmahantesh

$0.00

Dependent territories

Unfunded#124created bynerfologist

$0.00

Continents and their countries

Unfunded#125created bydereuromark

$0.00

Population per level

Unfunded#132created bydereuromark

$0.00

Bonaire and Sint Maarten are missing from the database.

Unfunded#137created bynarayanmoni

$0.00

All States data

Unfunded#139created byPrateekGoyal18

$0.00

Northern Ireland Cities Added to North Yorkshire

Unfunded#140created bynigelhorne

$0.00

City Reghin in Romania is missing

Unfunded#146created bycornelpopa

$0.00

Schumen region and city is missing (Bulgaria)

Unfunded#147created bycornelpopa

$0.00

Nassau missing from states database under country bahamas

Unfunded#119created bysirsweet242

$0.00

Model needs modification

Unfunded#154created byTrozmagon

$0.00

Table cities column name is updated_on instead updated_at

Unfunded#165created bycornelpopa

$0.00

Can't get Cities if there's no State!

Unfunded#166created byUtopiaBe

$0.00

Currency Symbols

Unfunded#169created byoyeaussie

$0.00

currency symbol is null

Unfunded#173created byoyeaussie

$0.00

Wrong column mapping in countries.csv file

Unfunded#177created bymiststudent2011

$0.00

Too many records are repeating in Cities

Unfunded#178created byneelabh2010

$0.00

Project LICENSE

Unfunded#179created byJoelFernando209

$0.00

Hong Kong not listed as a city

Unfunded#78created byMarthinusStrydom

$0.00

Wrong city entries in Austria/Germany/Switzerland and probably much more

Unfunded#92created byTwentyFourMinutes

$0.00

Double entry in austrian cities

Unfunded#88created byBerndKarlsboeck

$0.00

No world regions linked to countries

Unfunded#98created bylesiagnapovska359

$0.00

Kosovo bug

Unfunded#99created byAvdiuAndin

$0.00

Counties are not Cities, Misc Stuff...

Unfunded#43created byviper2kx

$0.00

Improve Demo Application

Unfunded#59created bydr5hn

$0.00

Adding Feature : "Search cities b country"

Unfunded#44created byRebaiahmed

$0.00

Areas of city

Unfunded#100created byUmar431497

$0.00

Timezone, normalize names, language. Fix curencies

Unfunded#101created byrodolfosouza

$0.00

Add Country domain tld field in the list

Unfunded#180created bymiststudent2011

$0.00

Buenos Aires City Missing as State

Unfunded#90created bykingbeto

$0.00

City Bogota is the Capital from Colombia

Unfunded#63created byfagsoft1

$0.00

Cities are repeated with district, city or province suffix

Unfunded#103created bysryn101

$0.00

Ahmedabad/Ahmadabad bug

Unfunded#104created byaastashov

$0.00

add translations

Unfunded#106created bympoeschl

$0.00

I can see the issue of encoding. Can anyone help me to solve this encoding issue? Check below listed picture.

Unfunded#77created byviotile

$0.00

Many Provinces in the Philippines have no cities

Unfunded#107created byquezon

$0.00

Metro Manila, Philippines has a wrong set of cities/towns

Unfunded#108created byquezon

$0.00

A comprehensive list of possible duplicates

Unfunded#236created byjacy33

$0.00

Remove duplicates in cities

Unfunded#216created byjecfarolan360

$0.00

Portugal Error Cities in Viana do Castelo

Unfunded#217created bytjaoc

$0.00

Issue in cities and state of United Kingdom

Unfunded#218created byBNG007

$0.00

Data Related Issues

Unfunded#219created byAmit270702

$0.00

Can I use it in android with kotlin?

Unfunded#220created bySrt9930

$0.00

Wrong data

Unfunded#229created byandreafdaf

$0.00

Duplicate cities

Unfunded#230created byDr-Phone

$0.00

Information about data sources

Unfunded#231created bympathy

$0.00

Add Pincode in the Cities table

Unfunded#232created bymaheshdama13

$0.00

Fix India's State and Cities Namings

Unfunded#213created bydr5hn

$0.00

TS Support

Unfunded#237created bykishanio

$0.00

Eastern Visayas State (Philippines) don't have any countries, which is wrong.

Unfunded#240created byfranzgithub25

$0.00

States latitude, longitude missing in countries+states+cities.json file.

Unfunded#242created byiamhitya

$0.00

if specify only 1 country

Unfunded#246created byiwowpao

$0.00

Request an API check

Unfunded#247created byArashZich

$0.00

Translate country name into Korean.

Unfunded#248created byragubyun

$0.00

Missing Bogota state in Colombia country

Unfunded#252created byBaku452

$0.00

Missing Loreto state in Perú Country

Unfunded#253created byBaku452

$0.00

American Samoa doesn't have it's corresponding states and cities

Unfunded#201created bynilachandan

$0.00

A lot of errors

Unfunded#181created byVikrant659

$0.00

Spain: missing cities

Unfunded#184created byMelchyore

$0.00

Add City

Unfunded#186created byfaridmdnor

$0.00

[BUG] City listed in states of Poland

Unfunded#187created byDanielKucal

$0.00

Algeria has 10 new provinces (states/wilayas)

Unfunded#188created byMelchyore

$0.00

I wonder where these data come from? Are they named in the same way as iso3166?

Unfunded#190created byjabbawockeez

$0.00

Daylight saving times issues

Unfunded#195created bydrfrostongithub

$0.00

You could update this db with GeoDB, World cities, GeoNames and WikiData data

Unfunded#196created bymayank-mundhra-2012

$0.00

County Mures and Maramures are mixed (and one is missing) in Romania

Unfunded#198created bycornelpopa

$0.00

Missing City entries in Austria

Unfunded#95created byTwentyFourMinutes

$0.00

Whenever i am passing my value of state to a variable it is taking its isoCode.

Unfunded#202created bymoli0805

$0.00

is this the WGS-84 standard

Unfunded#203created bysourth-rain

$0.00

In Russia, Volgogradskaya oblast is missing

Unfunded#204created bysilvarius

$0.00

ISO code for Iran (islamic republic of) states/provinces changed at 2020-11-24

Unfunded#205created bymortezafs

$0.00

final node_modules package size

Unfunded#206created bykunalfleethawks

$0.00

The State/Region/County listings for Norway is not correct (administrative reorganization in 2020)

Unfunded#207created bydevNoustack

$0.00

The capital of Switzerland should be Bern

Unfunded#208created byMattMacs

$0.00

State codes

Unfunded#212created byRonaldTayie

$0.00

Recent activities

dr5hn added the repository

over 5 years ago

countries-states-cities-database

$0.00

Issues

Company

Community

Support

Connect