Skip to content

README.md

Latest commit

 

History

History
120 lines (94 loc) · 2.97 KB

README.md

File metadata and controls

120 lines (94 loc) · 2.97 KB

🌍 Comprehensive World Countries Database

A detailed collection of information about countries, territories, and dependencies worldwide: this repository provides accurate, up-to-date data in multiple formats (SQL, CSV, and JSON) for easy integration into any project.

📊 Data Overview

The database includes comprehensive information about 240 entities, including:

  • 193 UN member states
  • 2 UN observer states (Vatican City and Palestine)
  • 45 territories and dependencies

📝 Available Fields

Each entry contains the following information:

  • Basic Information:
    • Name
    • ISO codes (2-letter and 3-letter)
    • Geographical classification (continent, region, subregion)
    • Capital city
  • Location Data:
    • Latitude and longitude coordinates
  • Communication:
    • Phone number prefix (country calling code)
    • Common phone number format
    • Top-level domain (TLD)
  • Financial:
    • Currency code (ISO 4217)
    • Currency name
    • Currency symbol
  • Visual:
    • Flag emoji (Unicode)
  • Metadata:
    • Creation and update timestamps

🗃️ Available Formats

  1. SQL

    • PostgreSQL-compatible schema
    • Includes proper data types and constraints
    • Indexed for optimal query performance

  2. CSV

    • Clean, comma-separated format
    • UTF-8 encoded
    • Includes header row
    • Ideal for data analysis and spreadsheet applications

  3. JSON

    • Well-structured and properly nested
    • UTF-8 encoded
    • Perfect for API responses and modern applications

🎯 Use Cases

  • Web and mobile applications
  • Geographic information systems (GIS)
  • International business applications
  • Telecommunications systems
  • Currency conversion tools
  • Data analysis and visualization
  • Educational resources
  • API development

🔍 Data Quality

  • Verified geographical information
  • ISO-standard country codes
  • Current currency information
  • Accurate phone number formats
  • Valid Unicode flag emojis
  • Precise coordinate data

📦 Installation

Simply clone the repository and choose the format that best suits your needs:

git clone https://github.com/ceexon/countries.git

🚀 Usage Examples

SQL

-- Get all European countries and their currencies
SELECT name, currency_code, currency_symbol 
FROM countries 
WHERE continent = 'Europe';

CSV (Python Example)

import pandas as pd

# Read the CSV file
df = pd.read_csv('countries.csv')

# Get all countries using USD
usd_countries = df[df['currency_code'] == 'USD']

JSON (JavaScript Example)

fetch('countries.json')
  .then(response => response.json())
  .then(data => {
    // Get all countries in Asia
    const asianCountries = data.filter(country => 
      country.continent === 'Asia'
    );
  });

🔄 Updates

The database is regularly maintained to ensure accuracy. Each record includes timestamps for the creation and the last update.

📜 License

This dataset is licensed under the MIT License. Feel free to use it in your projects, both personal and commercial.