All Projects → othmanus → Algeria Cities

othmanus / Algeria Cities

The list of all Algerian provinces and cities according to the official division in different formats: csv, xlsx, php, json, etc.

Projects that are alternatives of or similar to Algeria Cities

swiss-army knife for data
Stars: ✭ 275 (+18.53%)
Mutual labels:  json, csv, xlsx, sql
CLI tool that can execute SQL queries on CSV, LTSV, JSON and TBLN. Can output to various formats.
Stars: ✭ 593 (+155.6%)
Mutual labels:  json, csv, sql
An open source multi-tool for exploring and publishing data
Stars: ✭ 5,640 (+2331.03%)
Mutual labels:  json, csv, sql
📗 SheetJS Community Edition -- Spreadsheet Data Toolkit
Stars: ✭ 28,479 (+12175.43%)
Mutual labels:  json, csv, xlsx
Like Awk but with SQL and table joins
Stars: ✭ 263 (+13.36%)
Mutual labels:  json, csv, sql
Lista de bancos brasileiros | Brazilian banks list
Stars: ✭ 178 (-23.28%)
Mutual labels:  json, csv, sql
Countries, Languages & Continents data (capital and currency, native name, calling codes).
Stars: ✭ 656 (+182.76%)
Mutual labels:  json, csv, sql
OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
Stars: ✭ 2,579 (+1011.64%)
Mutual labels:  json, csv, sql
Countries States Cities Database
🌍 World countries, states, regions, provinces, cities, towns in JSON, SQL, XML, PLIST, YAML, and CSV. All Countries, States, Cities with ISO2, ISO3, Country Code, Phone Code, Capital, Native Language, Timezones, Latitude, Longitude, Region, Subregion, Flag Emoji, and Currency. #countries #states #cities
Stars: ✭ 1,130 (+387.07%)
Mutual labels:  json, csv, sql
Jl Sql
SQL for JSON and CSV streams
Stars: ✭ 44 (-81.03%)
Mutual labels:  json, csv, sql
World countries
Constantly updated lists of world countries and their associated alpha-2, alpha-3 and numeric country codes as defined by the ISO 3166 standard, available in CSV, JSON , PHP and SQL formats, in multiple languages and with national flags included
Stars: ✭ 598 (+157.76%)
Mutual labels:  json, csv, sql
Stars: ✭ 1,302 (+461.21%)
Mutual labels:  json, csv, xlsx
Nano Sql
Universal database layer for the client, server & mobile devices. It's like Lego for databases.
Stars: ✭ 717 (+209.05%)
Mutual labels:  json, csv, sql
(Migrated from CodePlex) DbWebApi is a .Net library that implement an entirely generic Web API (RESTful) for HTTP clients to call database (Oracle & SQL Server) stored procedures or functions in a managed way out-of-the-box without any configuration or coding.
Stars: ✭ 84 (-63.79%)
Mutual labels:  json, csv, xlsx
FileContextCore is a "Database"-Provider for Entity Framework Core and adds the ability to store information in files instead of being limited to databases.
Stars: ✭ 91 (-60.78%)
Mutual labels:  json, csv, xlsx
csvreader library / gem - read tabular data in the comma-separated values (csv) format the right way (uses best practices out-of-the-box with zero-configuration)
Stars: ✭ 169 (-27.16%)
Mutual labels:  json, csv
Neo4j Etl
Data import from relational databases to Neo4j.
Stars: ✭ 165 (-28.88%)
Mutual labels:  csv, sql
Web Database Analytics
Web scrapping and related analytics using Python tools
Stars: ✭ 175 (-24.57%)
Mutual labels:  json, sql
Stars: ✭ 161 (-30.6%)
Mutual labels:  json, xlsx
Django Import Export
Django application and library for importing and exporting data with admin integration.
Stars: ✭ 2,265 (+876.29%)
Mutual labels:  json, csv


This repository contains the list of all the administrative provinces and cities in Algeria.

The data is up-to-date according to the official source of the Algerian state.


The list is available in two languages:

  • Arabic
  • French


Each file contains the following data:

  • Wilaya
    • code: is the wilaya ID, between 1 and 48
    • name: in latin characters in French language
    • name_ar: in Arabic characters in Arabic language
  • Daira
    • code: is the official administrative code for the daira, prefixed by the wilaya's code
    • name: in latin characters in French language
    • name_ar: in Arabic characters in Arabic language
  • Commune
    • code: is the official administrative code for the city. IMPORTANT: this is NOT the postal code.
    • name: in latin characters in French language
    • name_ar: in Arabic characters in Arabic language


The list is available in different formats:

  • CSV comma separated
  • JSON
  • MySQL schema
  • PHP
  • XML
  • XLSX aka. Microsoft Excel
  • Dart and Flutter


To contribute with a specific format to the repository, please open a pull request.

Desired formats:

  • Java array
  • Swift array

Desired data:

  • List of the postal codes per city: according to the official Algerian Post, each city can have one or many post offices, and each post office has a postal code.
  • Latitude and Longitude of each city
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected]