hiiamrohit / countries-states-cities-database Goto Github PK

Database & Dropdown Demo

Home Page: http://www.iamrohit.in/countries-states-and-cities-database-of-world-in-mysql/

countries-states-cities-database's Introduction

Database

City state country dropdown : http://lab.iamrohit.in/php_ajax_country_state_city_dropdown/ Download full source code: http://www.iamrohit.in/tag/php-ajax-country-state-city-dropdown

Note:

*This Free database dose not guarantee for the complete list of world countries, states and cities.

*You can manually change the spelling mistakes, or add edit any records, which are not correct.

countries-states-cities-database's People

Contributors

Stargazers

Watchers

Forkers

shivamanhar sayuj4 codesharpdev shibinphilip789 krajssm ajayvpatelce sanddycool47 saminanirmala sindresgaming ashutoshdev-zz managerorganization shafi-shaikat satishverma143 lifeles666 danishjamil flyeven jp-resource prakashgp akash-pal muhammedriyaz purushotam-thakur shakahl migueltrevinom huiralb ademuanthony sonifir gencer fariiqunakhmad waqasshahid dupesnduds pnagaraju25 cviral30 nimblechapps edisoncosta developbrondani rifqisec vishnusbabu91 hp-techbucket javydreamercsw brajeshkhare marketcloud saumya04 kapilkarda devbikram znidaric didoivanov golinmarq fakrunt phlema euginepj faryoung resultakak serdarsanri burakdev mygithub86 maleg aaditya025 danogwok actonate lord-zeus claudiuj subscriptions-sdei manne7025 webandcraft chandrakant1990 pimplesushant akhil393 mahmoudnaguib erickmorales3 energetics almamuncsit theoomoregbee christianrd gersonyf anandryadav danieluyo maneesh7787 krishghata pician sreejithezhakkad rkrathor ikhlasmemon riazxrazor arazakalhoro yltongf gabisajr josefloressv anehkumar tarunnagar abrawat16 williamzimmermann ahmadnegm siddheshsatoskar ketanbgm appsbender dyanababette ademahendra avanthikameenakshi dagifted vicksemmanuel

countries-states-cities-database's Issues

Missing Cities

Its missing a whole lot of cities from Sweden, Norway, Denmark and Island

Missing State at 2182

State is missing, it'll cause reference error when the city references it. The correct fix will be to add "Fezzan" to id 2182 and country_id as 124.

Add world communities data also, i need this

wrong area name

This area is named Østjylland and not Arhus

Countries-States-Cities-database/states.json

Line 4704 in aca26b6

"name": "Arhus",

United Kingdom

United Kingdom is considered by the ISO 3166 a nation divided in these 4 countries

COUNTRY IN THIS DATABASE
UNITED KINGDOM

STATES IN THIS DATABASE

Country	Nation
England	United Kingdom
Scotland	United Kingdom
Northern Ireland	United Kingdom
Wales	United Kingdom

CITIES/SUBDIVISIONS IN THIS DATABASE
Now, each of the 4 countries have subdivisions (either city, council, district, borough, etc)

Subdivision	Country
Barking and Dagenham	England
Barnet	England
Barnsley	England
Bath and North East Somerset	England
Bedford	England
Bexley	England
Birmingham	England
Blackburn with Darwen	England
Blackpool	England
Bolton	England
Bournemouth	England
Bracknell Forest	England
Bradford	England
Brent	England
Brighton and Hove	England
Bristol, City of	England
Bromley	England
Buckinghamshire	England
Bury	England
Calderdale	England
Cambridgeshire	England
Camden	England
Central Bedfordshire	England
Cheshire East	England
Cheshire West and Chester	England
Cornwall	England
Coventry	England
Croydon	England
Cumbria	England
Darlington	England
Derby	England
Derbyshire	England
Devon	England
Doncaster	England
Dorset	England
Dudley	England
Durham County	England
Ealing	England
East Riding of Yorkshire	England
East Sussex	England
Enfield	England
Essex	England
Gateshead	England
Gloucestershire	England
Greenwich	England
Hackney	England
Halton	England
Hammersmith and Fulham	England
Hampshire	England
Haringey	England
Harrow	England
Hartlepool	England
Havering	England
Herefordshire	England
Hertfordshire	England
Hillingdon	England
Hounslow	England
Isle of Wight	England
Isles of Scilly	England
Islington	England
Kensington and Chelsea	England
Kent	England
Kingston upon Hull	England
Kingston upon Thames	England
Kirklees	England
Knowsley	England
Lambeth	England
Lancashire	England
Leeds	England
Leicester	England
Leicestershire	England
Lewisham	England
Lincolnshire	England
Liverpool	England
London, City of	England
Luton	England
Manchester	England
Medway	England
Merton	England
Middlesbrough	England
Milton Keynes	England
Newcastle upon Tyne	England
Newham	England
Norfolk	England
North East Lincolnshire	England
North Lincolnshire	England
North Somerset	England
North Tyneside	England
North Yorkshire	England
Northamptonshire	England
Northumberland	England
Nottingham	England
Nottinghamshire	England
Oldham	England
Oxfordshire	England
Peterborough	England
Plymouth	England
Poole	England
Portsmouth	England
Reading	England
Redbridge	England
Redcar and Cleveland	England
Richmond upon Thames	England
Rochdale	England
Rotherham	England
Rutland	England
Salford	England
Sandwell	England
Sefton	England
Sheffield	England
Shropshire	England
Slough	England
Solihull	England
Somerset	England
South Gloucestershire	England
South Tyneside	England
Southampton	England
Southend-on-Sea	England
Southwark	England
St. Helens	England
Staffordshire	England
Stockport	England
Stockton-on-Tees	England
Stoke-on-Trent	England
Suffolk	England
Sunderland	England
Surrey	England
Sutton	England
Swindon	England
Tameside	England
Telford and Wrekin	England
Thurrock	England
Torbay	England
Tower Hamlets	England
Trafford	England
Wakefield	England
Walsall	England
Waltham Forest	England
Wandsworth	England
Warrington	England
Warwickshire	England
West Berkshire	England
West Sussex	England
Westminster	England
Wigan	England
Wiltshire	England
Windsor and Maidenhead	England
Wirral	England
Wokingham	England
Wolverhampton	England
Worcestershire	England
York	England
Antrim and Newtownabbey	Northern Ireland
Ards and North Down	Northern Ireland
Armagh, Banbridge and Craigavon	Northern Ireland
Belfast	Northern Ireland
Causeway Coast and Glens	Northern Ireland
Derry and Strabane	Northern Ireland
Fermanagh and Omagh	Northern Ireland
Lisburn and Castlereagh	Northern Ireland
Mid and East Antrim	Northern Ireland
Mid Ulster	Northern Ireland
Newry, Mourne and Down	Northern Ireland
Aberdeen City	Scotland
Aberdeenshire	Scotland
Angus	Scotland
Argyll and Bute	Scotland
Clackmannanshire	Scotland
Dumfries and Galloway	Scotland
Dundee City	Scotland
East Ayrshire	Scotland
East Dunbartonshire	Scotland
East Lothian	Scotland
East Renfrewshire	Scotland
Edinburgh, City of	Scotland
Eilean Siar	Scotland
Falkirk	Scotland
Fife	Scotland
Glasgow City	Scotland
Highland	Scotland
Inverclyde	Scotland
Midlothian	Scotland
Moray	Scotland
North Ayrshire	Scotland
North Lanarkshire	Scotland
Orkney Islands	Scotland
Perth and Kinross	Scotland
Renfrewshire	Scotland
Scottish Borders, The	Scotland
Shetland Islands	Scotland
South Ayrshire	Scotland
South Lanarkshire	Scotland
Stirling	Scotland
West Dunbartonshire	Scotland
West Lothian	Scotland
Blaenau Gwent	Wales
Bridgend	Wales
Caerphilly	Wales
Cardiff	Wales
Carmarthenshire	Wales
Ceredigion	Wales
Conwy	Wales
Denbighshire	Wales
Flintshire	Wales
Gwynedd	Wales
Isle of Anglesey	Wales
Merthyr Tydfil	Wales
Monmouthshire	Wales
Neath Port Talbot	Wales
Newport	Wales
Pembrokeshire	Wales
Powys	Wales
Rhondda, Cynon, Taff	Wales
Swansea	Wales
Torfaen	Wales
Vale of Glamorgan, The	Wales
Wrexham	Wales

Canada / New Brunswick

Canada / New Brunswick add the following cities

Bathurst
Campbellton
Dieppe
Edmundston
Fredericton
Miramichi
Moncton
Saint John

Source https://en.wikipedia.org/wiki/New_Brunswick

Many cities are missing for the specific states

Hi @hiiamrohit
First of all I appreciate your efforts.

Here I found that some cities are missing for specific states. Can you please update me if you have the same?
Here is the list of states which cities are missing.

Thanks

Barbados/ Saint Joseph

Barbados / Saint Joseph add cities

Airy Hill
Bathsheba
Bissex
Blackmans
Bonwell
Branchbury
Buckden House
Canefield
Castle Grant
Cattlewash
Chimborazo
Hackleton's Cliff

Source https://en.wikipedia.org/wiki/Saint_Joseph,_Barbados

Dominican Republic Santiago Santiago

Rename city Santiago to Santiago de los Caballeros

for the Santiago city in Dominican Republic country

United States / New Jersey

Eliminate
United States / New Jersy

There is a second correct one
United States / New Jersey

Zambia

Zambia / Lusaka

Add the following Cities

Num	DISTRICT (City)
1	CHILANGA
2	CHIRUNDU
3	CHONGWE
4	KAFUE
5	LUANGWA
6	LUSAKA
7	RUFUNSA
8	SHIBUYUNJI

Source https://en.wikipedia.org/wiki/Lusaka_Province

Missing states.json

In states.json, id 2181 written this.
{
"id": "2181",
"name": "Ajdabiya",
"country_id": "124);"
},

I think "124);" is "124"

Sint Maarten Netherlands Antilles

For Netherlands Antilles / Sint Maarten

Include the following cities

Philipsburg
Lower Prince's Quarter
Cul de Sac
Cole Bay
Upper Prince's Quarter
Little Bay (Fort Amsterdam)
Simpson Bay
Lowlands

Source: https://en.wikipedia.org/wiki/Sint_Maarten

Country not new update

Country ;

Aland Islands ( request new update )
Isle of Man ( request new update )
Montenegro ( request new update )
Saint Barthelemy ( request new update )
yugoslavia ( not exist again )

Need more info

I need GPS location (lat/long) and ZIP codes as well for all cities.

Abbreviations : code per states

This is just a wishlist. It would be nice if you can add the (abbreviations) codes per states.

Bahamas The

For the Bahamas, state Grand Bahama should have the following cities

Freeport
Lucaya
West End
Eight Mile Rock
McLeans Town

https://en.wikipedia.org/wiki/Grand_Bahama

United States / Pennsylvania

Delete city Phildephia
Since there is other entry Philadelphia

Missing many countries and cities as compare to the demo site

Hi,

We are using SQL scripts provided by you, But later we came to know most of the coutiers and cities are missing in that. We check for those missing countries and cities are present on the live demo created by you on the following location.
http://www.iamrohit.in/tag/php-ajax-country-state-city-dropdown

did that demo work on json data instead of sql scripts ?

Please let me know why sql scripts has these missing countries and cities. Since your demo does not has any missing countries and cities.

Some non-cities are listed as cities

There are a lot of errors on the Turkey's city list. Many neighborhoods are listed as cities on the list.

Just a question

I uploaded the sql files into the database but I'm not sure how to get the dropdown to work. Do I need to upload the dbconfiq api and location.js files or just the code. Please help

Anguilla

Add the following states

Num	District (State)
1	Blowing Point
2	East End
3	George Hill
4	Island Harbour
5	North Hill
6	North Side
7	Sandy Ground
8	Sandy Hill
9	South Hill
10	Stoney Ground
11	The Farrington
12	The Quarter
13	The Valley
14	West End

Source https://en.wikipedia.org/wiki/Geography_of_Anguilla

lots of missing cities in brazil

name    city
Acre    16
Alagoas 72
Amapa   6
Amazonas    50
Bahia   207
Ceara   100
Distrito Federal    0
Espirito Santo  0
Goias   90
Maranhao    105
Mato Grosso 0
Mato Grosso do Sul  0
Minas Gerais    0
Para    92
Paraiba 87
Parana  129
Pernambuco  113
Piaui   53
Rio Grande do Norte 0
Rio Grande do Sul   0
Rio de Janeiro  0
Rondonia    32
Roraima 8
Santa Catarina  0
Sao Paulo   0
Sergipe 44
Tocantins   25

Wrong Cities for the state Punjab in Pakistan

The cities are same for the indian punjab and pakistan punjab.

feature request

it will be more useful if abbreviations are there.

Canada States(Provinces/Territories)

Canada should have only these states (called provinces or territories)

State

Ontario
Quebec
Nova Scotia
New Brunswick
Manitoba
British Columbia
Prince Edward
Saskatchewan
Alberta
Newfoundland and Labrador
Northwest Territories
Yukon
Nunavut

Delete the rest

Source
https://en.wikipedia.org/wiki/Provinces_and_territories_of_Canada

Cities make reference to non state...

The cities Awbari and Ghat (ids 26069 and 26070), belongs to a state with the id 2182, but in the states table, it doesn't appear any record with such id...

Hence when you upload this to a relational model it gaves you an error...

In state.sql missing states 3478, 3479

Thank You So much Bro ! Cheers ...

Virgin Islands US / Saint Croix

Add cities:
Anna's Hope Village
Christiansted
East End
Frederiksted
Northcentral
Northwest
Sion Farm
Southcentral
Southwest

https://en.wikipedia.org/wiki/Saint_Croix

Cayman Islands / Grand Cayman

Cayman Islands / Grand Cayman add the following cities:

Bodden Town
East End
George Town
North Side
West Bay

Source: https://en.wikipedia.org/wiki/Grand_Cayman

Natwar is a City name

You have mentioned "Natwar" As a state in state.sql but "Natwar" is a city name in Bihar state.
Please update the list accordingly.

City: NATWAR
District: ROHTAS
State: BIHAR
Pincode: 802218

State - Putignano is repeated

State - Putignano is repeated and the repeated value is having an extra ,

(23500, 'Parabita', 1872),
(23501, 'Polignano a Mare', 1872),
(23502, 'Pulsano', 1872),
(23503, 'Putignano', 1872),
(23504, 'Putignano,', 1872),
(23505, 'Racale', 1872),
(23506, 'Ruffano', 1872),
(23507, 'Rutigliano', 1872),

If I remove that duplicate value, then all the indexes will become inconsistent. Should I remove it and update all other indexes and send you a PR?

cities are listed in states table for USA

below are cities not states
(3923, 'Byram', 231),
(3925, 'Cokato', 231),
(3940, 'Lowa', 231),
(3944, 'Medfield', 231),
(3964, 'Ramey', 231),
(3968, 'Sublimity', 231),
(3971, 'Trimble', 231),

this one is a repeated state name with misspell
(3954, 'New Jersy', 231),
this is state of Canada
(3961, 'Ontario', 231),

是的

**是**的

Putignano Duplicate

Putignano is listed twice, once with an extra comma.

(23503, 'Putignano', 1872),
(23504, 'Putignano,', 1872),

Trinidad and Tobago

For the state (region) Arima-Tunapuna-Piarco

It seems the region should be Tunapuna-Piarco and another region Arima
https://upload.wikimedia.org/wikipedia/commons/f/f0/Regional_corporations_and_municipalities_of_Trinidad_and_Tobago.svg

https://en.wikipedia.org/wiki/Tunapuna-Piarco_Regional_Corporation

From the countries census data the states should be the following
http://cso.gov.tt/census/2011-census-data/

Number	Regional Corporations (state)
1	Borough of Arima
2	Borough of Chaguanas
3	Borough of Point Fortin
4	City of San Fernando
5	Couva/ Tabaquite/ Talparo
6	Diego Martin
7	Mayaro/ Rio Claro
8	Penal/ Debe
9	Port of Spain
10	Princes Town
11	San Juan/ Laventille
12	Sangre Grande
13	Siparia
14	Tobago
15	Tunapuna/ Piarco

And Trinidad also has Counties (Historical) Caroni, Mayaro, Nariva, Saint Andrew, Saint David, Saint George, Saint Patrick, Victoria

Missing a lot of cities

Hi!
I've found that are missing a lot of cities in Latinoamerica, and curiously, missing cities are from states where its name is composed for two or more words.
For example in Colombia -> Valle del Cauca, La Guajira, Norte de Santader, San Andres y Providencia.

Many thanks!

--
pd. Sorry for my bad english :$

Complete mess

Hi I check this database how, basically i see amazing mess in some countries, state mixed with cities, cities with states, some cities marked for states and region - anyway tnx.

there is no city list under Nei Menggu,China

choose China and Nei Menggu, there is no data of cities

State "Estado de Sao Paulo" (520) and "Sao Paulo" (537) are the same

There are no 2 different states as "Estado de Sao Paulo" (520) and "Sao Paulo" (537) in Brazil.

To be more accurate, use only as "São Paulo". Also, I didn't found any city for any of them.

Mexico

Distrito Federal was renamed to Ciudad de Mexico on 2016/Jan/29 (https://es.wikipedia.org/wiki/Ciudad_de_M%C3%A9xico)

Here are the united nations database

http://www.unece.org/cefact/codesfortrade/codes_index.html

It seems to be updated with all the cities in Mexico.

How can I contribute to this project? I am new to github

Not accurate

In South Africa some cities even suburbs are states (provinces)

mixed states and cities

Hi there,

I just checked out the tables, and i realized that there are cities in the states table (i checked in the us and there are at least more than 52 states; there are around 60 states, and some of then are cities)

States of India are only 36 while we have 41 here

Pl. review the below list of states added against INDIA for correction (To be removed)
(18, 'Kenmore', 101),
(27, 'Narora', 101),
(28, 'Natwar', 101),
(30, 'Paschim Medinipur', 101),
(40, 'Vaishali', 101),

Barbados / Saint Michael

Add the following cities

Num	City (settlement)
1	Bank Hall
2	Bayville
3	Belfield
4	Belle
5	Bibbys Lane
6	Black Rock
7	Bridgetown (110,000) -- Capital
8	Brighton
9	Brittons Hill
10	Bush Hall
11	Canewood
12	Carrington
13	Cave Hill
14	Clermont
15	Codrington
16	Dayrells
17	Deacons
18	Deacons Farm
19	Eagle Hall
20	Eden Lodge
21	Fairfield
22	Friendship
23	Friendship Terrace
24	Goodland
25	Grazettes
26	Green Hill
27	Haggatt Hall
28	Harmony Hall
29	Henrys
30	Highgate
31	Hothersal Turning
32	Howells
33	Ivy
34	Jackmans
35	Kew
36	Lazarette
37	Lodge Hill
38	Lower Estate
39	Mapp Hill
40	Neils
41	Prospect
42	Rock Dundo
43	Rouen
44	Spring Garden
45	Station Hill
46	St Barnabas
47	Two Mile Hill
48	Upton
49	Wanstead
50	Warrens
51	Waterford
52	Whitehall
53	Wildey

some issue and some data

Ramy,Sublimity,Byram,Ontario,District of Columbia,Cokato,Lowa, Medfield and Trimble are not states in the united states
New jersey is duplicated
and here some other cities in zimbabwe
INSERT INTO cities (name, state_id)
VALUES ('Beitbridge', 4119);

INSERT INTO cities (name, state_id)
VALUES ('Gwanda', 4119);
INSERT INTO cities (name, state_id)
VALUES ('Lupane', 4118);
INSERT INTO cities (name, state_id)
VALUES ('Hwange', 4118);
INSERT INTO cities (name, state_id)
VALUES ('Victoria Falls', 4118);

INSERT INTO cities(name, state_id)
VALUES ('Banket', 4116);
INSERT INTO cities (name, state_id)
VALUES ('Chegutu', 4116);

INSERT INTO cities(name, state_id)
VALUES ('Chinhoyi', 4116);
INSERT INTO cities (name, state_id)
VALUES ('Kadoma', 4116);

INSERT INTO cities (name, state_id)
VALUES ('Kariba', 4116);
INSERT INTO cities (name, state_id)
VALUES ('Karoi', 4116);
INSERT INTO cities (name, state_id)
VALUES ('Mhangura', 4116);
INSERT INTO cities (name, state_id)
VALUES ('Norton', 4116);
INSERT INTO cities (name, state_id)
VALUES ('Chivhu', 4115);
INSERT INTO cities (name, state_id)
VALUES ('Marondera', 4115);
INSERT INTO cities(name, state_id)
VALUES ('Murewa', 4115);
INSERT INTO cities (name, state_id)
VALUES ('Mutoko', 4115);
INSERT INTO cities (name, state_id)
VALUES ('Ruwa', 4115);
INSERT INTO cities (name, state_id)
VALUES ('Bindura', 4114);
INSERT INTO cities (name, state_id)
VALUES ('Glendale', 4114);
INSERT INTO cities (name, state_id)
VALUES ('Mvurwi', 4114);
INSERT INTO cities(name, state_id)
VALUES ('Shamva', 4114);