Countries

Introduction

This repository contains a list of world countries, as defined by ISO Standard 3166-1, in JSON, CSV, XML and YAML. Warning: not all entities in this project are independent countries; refer to the independent property to know if the country is considered a sovereign state.

Data Source Characteristics

  • Data file: countries.csv

  • Format: csv

  • Size: < 1 MB

  • Update frequency: sporadic

  • URL: countries

Data Target Characteristics

  • Database management system: PostgreSQL

  • Database name: io_avstats_db

  • Database table: io_countries

Data Processing

  • Repository: io-avstats

  • Script: run_io_avstats_dev

  • Task: l_c_s (Load country and state data into PostgreSQL)

Processing Steps:

  1. The countries csv file is downloaded from here.

  2. The database table io_countries is updated from the downloaded data file countries.csv.

For detailed processing steps, refer to the external repository: io-avstats

Configuration Parameter:

countries_timeout = 10
countries_transaction_size = 500
countries_url = "https://raw.githubusercontent.com/mledoze/countries/master/dist/countries.csv"

Contact Information