TL;DR – This article provides an overview of the World Geo Data digital product. You can use it for your country, state, and city dropdowns.
Get instant access to the full dataset:
👉 Buy on Gumroad (for $5)
You can definitely try out this game-changing, developer-ready solution to use the dataset bundle for your application. Using this bundle kit, you can boost your development progress much faster. This bundle kit is really useful, as it contains files according to your development needs. See below for more information.
A ready-to-use dataset bundle includes all geographic and administrative information, including continents, countries, states, cities, and currencies in MySQL, CSV, JSON, and SVG Country Flag icons as Images for all countries.
This dataset includes structured lists of:
- Countries
- States/Provinces
- Cities
- Continents
- Currency
Each dataset is provided in:
- MySQL (.sql)
- CSV format
- JSON data format
- SVG Flag icons for all Countries
- Sample SQL queries
✅ Ready to import into any MySQL or PostgreSQL DB
📦 Useful for developers, SaaS founders, UI designers, data analysts & educators.
Licensed under MIT, it can be used freely in personal and commercial projects.
- Create country/state dropdowns
- Add region filters to your SaaS
- Power location-based dashboards
- Academic & data analysis projects
- You can make your own scenarios and use cases…
For example, in your signup form, you want to show a dropdown of country lists along with country flag icons and their respective phone code numbers. You cannot put every country’s information in the dropdown, because writing ul li tags for 195 countries is a real headache, and to resolve this, I brought up a unique approach using CSS where you just need to add the standard ISO 2-letter country code in lower case, as shown below.
Use class=”fi fi-in“
You can also check out the stackblitz code below for setting up the country flag icons demo. See the output preview directly here.
───1. Continents │ continents.csv │ continents.json │ continents.sql │ LICENSE.md │ ├───2. Countries │ │ countries.csv │ │ countries.json │ │ countries.sql │ │ LICENSE.md │ │ Readme-svg-country-flag-icons.txt │ │ │ └───svg-country-flag-icons │ │ ├───3. States │ LICENSE.md │ states-with-countryid-mapping.csv │ states.csv │ states.json │ states.sql │ ├───4. Cities │ cities-with-state-and-country-mapping.csv │ cities.csv │ cities.json │ cities.sql │ LICENSE.md │ └───5. Currencies currencies.sql currency.csv currency.json LICENSE.mdAll major formats are included:
- .csv — for spreadsheets and tabular data tools
- .json — for developers and APIs
- .sql — for direct database import (MySQL, PostgreSQL compatible)
- .svg — for showing flag icons for country-wise, for better readability.
Each folder includes a separate LICENSE.md file detailing usage rights. Please review them before using them in commercial or open-source projects. Licensed under MIT, it can be used freely in personal and commercial projects.
This repo is for documentation purposes only. If you have suggestions or questions about the dataset, feel free to reach out via email.
- ✅ Clean, consistent, and standardized
- 🌐 Global coverage
- 🛠️ Ready for production
- 📊 Ideal for developers, UI designers, analysts, and entrepreneurs
Get instant access to the full dataset:
👉 Buy on Gumroad (for $5)
Thanks for reading the article, and don’t forget to ⭐️ this article if you found it helpful! 👏 are most welcome. You can find sample queries below – (scroll down)
Support us on Social Media:
Product Hunt | Instagram| Facebook| LinkedIn| X/Twitter | Medium
Disclaimer: In this article, we have used our product link. When you make the purchase, I will earn some commission from it. It is an official property of Digital WorkerBees.
Download Continents List (MySQL + CSV + JSON) - Sample Queries
🫰Sample Queries:
For the continents table:
CREATE TABLE `continent_master` (
`id` int NOT NULL AUTO_INCREMENT,
`code` varchar(3) NOT NULL,
`name` varchar(150) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `code` (`code`,`name`)
);
Insert Queries:
INSERT INTO `continent_master` VALUES (1,'AF','AFRICA');
Download Country List (MySQL + CSV + JSON + SVG Country Flag icons) - Sample Queries
🫰Sample Queries:
For the countries table:
CREATE TABLE `countries_master` (
`id` int NOT NULL AUTO_INCREMENT,
`code` varchar(3) NOT NULL,
`name` varchar(150) NOT NULL,
`phonecode` int NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `code` (`code`,`name`,`phonecode`)
);
Insert Queries:
INSERT INTO `countries_master` VALUES (5,'AD','Andorra',376);
Download States List (MySQL + CSV + JSON) - Sample Queries
🫰Sample Queries:
For the states table:
CREATE TABLE `states_master` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`country_id` int NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`,`country_id`)
);
Insert Queries:
INSERT INTO `states_master` VALUES (4077,''Adan',243),(1977,''Ajlun',111);
Download Cities List (MySQL + CSV + JSON) - Sample Queries
🫰Sample Queries:
For the cities table:
CREATE TABLE `cities_master` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`state_id` int NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`,`state_id`)
);
Insert Queries:
INSERT INTO `cities_master` VALUES (22269,'',1815),(24081,' Montebello Vicentino',1901),(23862,' San Giorgio',1890);
Download Currencies List (MySQL + CSV + JSON) - Sample Queries
🫰Sample Queries:
For the currency table:
CREATE TABLE `currency_master` (
`currency_id` int NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL,
`code` varchar(3) NOT NULL,
`symbol` varchar(5) NOT NULL,
PRIMARY KEY (`currency_id`)
);
Insert Queries:
INSERT INTO `currency_master` VALUES (1,'Rupees','INR','₹'),(2,'Dollars','USD','$');
Get instant access to the full dataset:
👉 Buy on Gumroad (for $5)
adsense
Discover more from 9Mood
Subscribe to get the latest posts sent to your email.
English (US) · 