Country State City Database - MySQL / JSON Download

World Data Bundle — Full Continent, Country, State, City & Currency Dataset

This article provides an overview of the World Geo Data digital product.

World data bundle — download mysql, csv, json and svg country flag icons to boost your app progress faster | Image by author

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.

Use this friend link, if you don't have full article read access.

🌍 World Geo Data — Get the Full Country, State, City & Currency Dataset

Checkout country list, continent list, states, currencies and cities | Image by Author

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.

👉 Buy on Gumroad (for $5)

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

🫰 Usage

✅ Ready to import into any MySQL or PostgreSQL DB
📦 Useful for developers, SaaS founders, UI designers, data analysts & educators.

📜 License & Permits

Licensed under MIT, it can be used freely in personal and commercial projects.

✨ Use Cases

• 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…
• 👉 Buy on Gumroad (for $5)

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.

<h3>India <span class="fi fi-in"></span></h3>

Best Way To Add Country Flag Icons In Angular

Learn the best way to add country flag icons in Angular, React or vue.js with this comprehensive guide. Easy methods…

www.9mood.com

You can also check out the stackblitz code below for setting up the country flag icons demo. See the output preview directly here.

📦 What’s Included?

├───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.md

Each file is cleanly structured and ready for integration into your apps, databases, analytics platforms, or localization projects.

📂 File Format Support

All 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.

🔐 Licensing

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.

🙌 Contribution / Suggestion

This repo is for documentation purposes only. If you have suggestions or questions about the dataset, feel free to reach out via email.

👉 Buy on Gumroad (for $5)

⭐ Why Use This?

• ✅ Clean, consistent, and standardized
• 🌐 Global coverage
• 🛠️ Ready for production
• 📊 Ideal for developers, UI designers, analysts, and entrepreneurs

🫰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');

🛒 Buy Now

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.

Support us on Social Media:

Product Hunt | Instagram| Facebook| LinkedIn| X/Twitter

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.