dr5hn / 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
Projects that are alternatives of or similar to Countries States Cities Database
Python Benedict
dict subclass with keylist/keypath support, I/O shortcuts (base64, csv, json, pickle, plist, query-string, toml, xml, yaml) and many utilities. π
Stars: β 204 (-81.95%)
Mutual labels: json, xml, csv, yaml, plist
Countries
World countries in JSON, CSV, XML and Yaml. Any help is welcome!
Stars: β 5,379 (+376.02%)
Mutual labels: json, xml, csv, yaml, countries
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 (-47.08%)
Mutual labels: json, csv, sql, mysql, countries
Countries
Countries, Languages & Continents data (capital and currency, native name, calling codes).
Stars: β 656 (-41.95%)
Mutual labels: json, csv, sql, countries
Structured Text Tools
A list of command line tools for manipulating structured text data
Stars: β 6,180 (+446.9%)
Mutual labels: json, xml, csv, yaml
Iso 3166 Countries With Regional Codes
ISO 3166-1 country lists merged with their UN Geoscheme regional codes in ready-to-use JSON, XML, CSV data sets
Stars: β 1,372 (+21.42%)
Mutual labels: json, xml, csv, countries
Laravel World
provide countries, states, and cities relations and database.
Stars: β 222 (-80.35%)
Mutual labels: city, country, state, region
Octosql
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 (+128.23%)
Mutual labels: json, csv, sql, mysql
Bancosbrasileiros
Lista de bancos brasileiros | Brazilian banks list
Stars: β 178 (-84.25%)
Mutual labels: json, xml, csv, sql
Il Ilce Mahalle Sokak Cadde Sql
TΓΌrkiye Δ°l, Δ°lΓ§e, Mahalle, Sokak, Cadde Bilgisi SQL Εeklinde
Stars: β 235 (-79.2%)
Mutual labels: json, xml, sql, mysql
Choetl
ETL Framework for .NET / c# (Parser / Writer for CSV, Flat, Xml, JSON, Key-Value, Parquet, Yaml, Avro formatted files)
Stars: β 372 (-67.08%)
Mutual labels: json, xml, csv, yaml
Trdsql
CLI tool that can execute SQL queries on CSV, LTSV, JSON and TBLN. Can output to various formats.
Stars: β 593 (-47.52%)
Mutual labels: json, csv, sql, mysql
Jokeapi
A REST API that serves uniformly and well formatted jokes in JSON, XML, YAML or plain text format that also offers a great variety of filtering methods
Stars: β 71 (-93.72%)
Mutual labels: api, json, xml, yaml
Pmacct
pmacct is a small set of multi-purpose passive network monitoring tools [NetFlow IPFIX sFlow libpcap BGP BMP RPKI IGP Streaming Telemetry].
Stars: β 677 (-40.09%)
Mutual labels: json, sql, mysql
Parsrs
CSV, JSON, XML text parsers and generators written in pure POSIX shellscript
Stars: β 56 (-95.04%)
Mutual labels: json, xml, csv
Sheetjs
π SheetJS Community Edition -- Spreadsheet Data Toolkit
Stars: β 28,479 (+2420.27%)
Mutual labels: json, xml, csv
Country Json
A simple data of the world by country each in JSON format.
Stars: β 688 (-39.12%)
Mutual labels: countries, city, country
Feedr
Use feedr to fetch the data from a remote url, respect its caching, and parse its data. Despite its name, it's not just for feed data but also for all data that you can feed into it (including binary data).
Stars: β 56 (-95.04%)
Mutual labels: json, xml, yaml
π Countries States Cities Database
Full Database of city state country available in JSON, SQL, XML, PLIST, YAML & CSV format. All Countries, States & Cities are Covered & Populated with Different Combinations & Versions.
API π
π Introducing API for Countries States Cities Database.
Formats Available
- JSON
- SQL
- XML
- PLIST
- YAML
- CSV
Distribution Files Info
| File | JSON | SQL | XML | PLIST | YAML | CSV |
|---|---|---|---|---|---|---|
| Countries | β | β | β | β | β | β |
| States | β | β | β | β | β | β |
| Cities | β | β | β | β | β | β |
| Country+States | β | NA | β | NA | β | NA |
| Country+Cities | β | NA | β | NA | β | NA |
| State+Cities | β | NA | β | NA | β | NA |
| Country+State+Cities/World | β | β | β | NA | β | NA |
Demo
https://dr5hn.github.io/countries-states-cities-database/
Insights
Total Countries : 250
Total States/Regions/Municipalities : 4,892
Total Cities/Towns/Districts : 146,028
Last Updated On : 20th February 2021
Notes
This Free database does not guarantee for the complete list of world
countries, states & cities.
You can manually change the spelling mistakes, duplicates
or add/edit any records, which are incorrect.
Reason behind making this repo: I ran through many websites to get
perfect combination of state, city & countries.
Some were with missing states while others with large filesize.
So I thought to get it done on my own using PHP Script.
Contributions
Follow me at
Suggestions / Feedbacks
Suggestions & Feedbacks are Most Welcome
gadadarshan[at]gmail[dot]com
That's all Folks. Enjoy.
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].