Skip to content

Country database with flags and geographical coordinates available in SQL, JSON and CSV formats

License

Notifications You must be signed in to change notification settings

ban6ka/countries

 
 

Repository files navigation

About

Data set with world countries (names, flags, coordinates) in popular formats to easily integrate in your projects.

Features:

  • Full list of world countries
  • MySQL tables containing countries and attributes
  • JSON array of objects with country attributes
  • CSV table with countries
  • CSS sprite with country flags for HTML
  • Hi-quality flags (PNG file) available in two sizes: 128 x 64, and 32 x 16.
  • ISO codes 3166-1 / 3166-2 (ie. RO, ROU for Romania)
  • Country 'center' coordinates & zoom hand-picked to optimally fit into a square Google Maps viewport
  • List of official UN Regions & assignment of countries to regions

View Demo

TODO list:

  • Code examples

How to use

Look into the data/ directory for your preffered format.

MySQL

Open a console and load the countries:

	$> cat data/mysql/country.sql | mysql -u username -p database

License

Database with world country list, their flags and name in various languages Copyright (C) 2011 Cristian Romanescu

This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program. If not, see http://www.gnu.org/licenses/.

About

Country database with flags and geographical coordinates available in SQL, JSON and CSV formats

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Languages

  • HTML 68.1%
  • CSS 17.1%
  • PHP 13.1%
  • JavaScript 1.7%