Feedback Form

Saturday, August 16, 2008

List of countries, cities, languages

WORLD_MAP_by_SUNZHINE

You will find in the following links list of countries, cities, and their languages in CSV format, you can import into any database:

Countries:

http://www.ziddu.com/download/1936707/Country.csv.html

Cities:

http://www.ziddu.com/download/1936708/City.csv.html

Languages:

http://www.ziddu.com/download/1936713/Language.csv.html

and the following is the sql script to create these tables in sql server 2005:

USE [World]
GO
/****** Object: Table [dbo].[City] Script Date: 08/16/2008 14:48:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[City](
[ID] [int] NOT NULL,
[Name] [nvarchar](35) COLLATE Arabic_CI_AS NOT NULL,
[CountryCode] [nvarchar](3) COLLATE Arabic_CI_AS NOT NULL,
[District] [nvarchar](20) COLLATE Arabic_CI_AS NULL,
[Population] [int] NULL
) ON [PRIMARY]

GO
/****** Object: Table [dbo].[Country] Script Date: 08/16/2008 14:48:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Country](
[Code] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
[Name] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
[Continent] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
[Region] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
[SurfaceArea] [nvarchar](150) NOT NULL,
[IndepYear] [nvarchar](150) NULL,
[Population] [nvarchar](150) NOT NULL,
[LifeExpectancy] [nvarchar](150) NULL,
[GNP] [nvarchar](150) NULL,
[GNPOld] [nvarchar](150) NULL,
[LocalName] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
[GovernmentForm] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
[HeadOfState] [nvarchar](150) COLLATE Arabic_CI_AS NULL,
[Capital] [nvarchar](150) NULL,
[Code2] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
CONSTRAINT [PK_Country] PRIMARY KEY CLUSTERED
(
[Code] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object: Table [dbo].[Language] Script Date: 08/16/2008 14:48:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Language](
[CountryCode] [nvarchar](50) COLLATE Arabic_CI_AS NOT NULL,
[Language] [nvarchar](50) COLLATE Arabic_CI_AS NOT NULL,
[IsOfficial] [bit] NULL,
[Percentage] [nvarchar](50) COLLATE Arabic_CI_AS NULL,
CONSTRAINT [PK_Language] PRIMARY KEY CLUSTERED
(
[CountryCode] ASC,
[Language] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


kick it on DotNetKicks.com

16 comments:

Anonymous said...

Thanks, some questions though:

How can we keep this data up to date? Care to share your sources?

All characters besides A-Z seems garbled to me. Can you reformat them as Unicode?

Amr ElGarhy said...

All of these date taken from this db: http://downloads.mysql.com/docs/world.sql.zip and i just formatted for SQL server, so i don't know how to make these date updated, and if you can't see some characters just change your DB collation, or open the mysql original one.

Thanks,

Anonymous said...

you got utf8 issues in those csv's friend

manbros said...

I am looking for javascript of countries & cities dropdown menu, anyone pls help.

Amr ElGarhy said...

You can use these data and put the values inside drop downs.

Anonymous said...

NICE MAP. I WANT TO USE IT ON MY SITE. WHAT IS THE SOURCE AND IS THERE A COPYRIGHT MATE?

Amr ElGarhy said...

http://sunzhine.deviantart.com/art/WORLD-MAP-47040356

Anonymous said...

I inclination not agree on it. I assume nice post. Especially the appellation attracted me to review the sound story.

Anonymous said...

Good brief and this enter helped me alot in my college assignement. Say thank you you for your information.

Ahmad Ali said...

This list is very much helpful. Thanks a lot

metro said...

This list is very much helpful, i hope can give me more .....

easystuf.com

nurac said...

Its very much useful. But i need there telephone code too.

web development India said...

Hey guys the blog is really cool. The facts are the point and reliable. This space contains really helpful info. Loved it. Keep Following...Best of Luck


web site development company

web development India said...

great work dude. The blog is just awesome. Content is relevant, presentation is impressive, language is simple…just perfect. I liked the conclusion a lot. Long way to go man.


web development company

Elle Montecarlo said...

Thanks a lot for your post. Is exactly that I searched X)

Web Development Company said...

It's really useful for everyone.