Project Name | Stars | Downloads | Repos Using This | Packages Using This | Most Recent Commit | Total Releases | Latest Release | Open Issues | License | Language |
---|---|---|---|---|---|---|---|---|---|---|
Sheetjs | 32,867 | 4,379 | 2,297 | a month ago | 170 | March 24, 2022 | 129 | apache-2.0 | JavaScript | |
📗 SheetJS Spreadsheet Data Toolkit -- New home https://git.sheetjs.com/SheetJS/sheetjs | ||||||||||
Phpexcel | 11,447 | 5,717 | 518 | 4 years ago | 9 | November 22, 2018 | 668 | other | PHP | |
ARCHIVED | ||||||||||
Yq | 8,737 | 43 | a day ago | 10 | February 06, 2020 | 75 | mit | Go | ||
yq is a portable command-line YAML, JSON, XML, CSV, TOML and properties processor | ||||||||||
Structured Text Tools | 6,672 | 2 months ago | 15 | |||||||
A list of command line tools for manipulating structured text data | ||||||||||
Countries | 5,709 | 399 | 77 | a month ago | 21 | April 04, 2020 | 37 | odbl-1.0 | PHP | |
World countries in JSON, CSV, XML and Yaml. Any help is welcome! | ||||||||||
Servicestack | 5,218 | 2,054 | 467 | 3 days ago | 172 | August 30, 2022 | 35 | other | C# | |
Thoughtfully architected, obscenely fast, thoroughly enjoyable web services for all | ||||||||||
Countries States Cities Database | 4,908 | 17 days ago | 41 | odbl-1.0 | PHP | |||||
🌍 Discover our global repository of countries, states, and cities! 🏙️ Get comprehensive data in JSON, SQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, timezones (for countries), and more. #countries #states #cities | ||||||||||
Luban | 2,043 | a month ago | mit | C# | ||||||
你的最佳游戏配置解决方案 {excel, csv, xls, xlsx, json, bson, xml, yaml, lua, unity scriptableobject} => {json, bson, xml, lua, yaml, protobuf(pb), msgpack, flatbuffers, erlang, custom template} data + {c++, java, c#, go(golang), lua, javascript(js), typescript(ts), erlang, rust, gdscript, protobuf schema, flatbuffers schema, custom template} code。 | ||||||||||
Iso 3166 Countries With Regional Codes | 1,831 | 4 months ago | August 26, 2016 | 13 | other | Ruby | ||||
ISO 3166-1 country lists merged with their UN Geoscheme regional codes in ready-to-use JSON, XML, CSV data sets | ||||||||||
World_countries | 1,092 | 2 months ago | 13 | June 19, 2022 | 8 | other | PHP | |||
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, SQL and XML formats, in multiple languages and with national flags included; also available are the ISO 3166-2 codes of provinces/ states associated with the countries |
These lists are the result of merging data from two sources, the Wikipedia ISO 3166-1 article for alpha and numeric country codes, and the UN Statistics site for countries' regional, and sub-regional codes. In addition to countries, it includes dependent territories.
The International Organization for Standardization (ISO) site provides partial data (capitalised and sometimes stripped of non-latin ornamentation), but sells the complete data set as a Microsoft Access 2003 database. Other sites give you the numeric and character codes, but there appeared to be no sites that included the associated UN-maintained regional codes in their data sets. I scraped data from the above two websites that is all publicly available already to produce some ready-to-use complete data sets that will hopefully save someone some time who had similar needs.
The data is available in
3 versions exist for each format
all.format
- Everything I can find, including regional and sub-regional codesslim-2.format
- English name, numeric country code and alpha-2 code (e.g., NZ)slim-3.format
- English name, numeric country code and alpha-3 code (e.g., NZL)Take a peek inside the all
, slim-2
and slim-3
directories for the full lists of JSON, XML and CSV.
Using JSON as an example:
[
{
"name":"Nigeria",
"alpha-2":"NG",
"alpha-3":"NGA",
"country-code":"566",
"iso_3166-2":"ISO 3166-2:NG",
"region":"Africa",
"sub-region":"Sub-Saharan Africa",
"intermediate-region":"Western Africa",
"region-code":"002",
"sub-region-code":"202",
"intermediate-region-code":"011"
},
// ...
]
[
{
"name":"New Zealand",
"alpha-2":"NZ",
"country-code":"554"
},
// ...
]
[
{
"name":"New Zealand",
"alpha-3":"NZL",
"country-code":"554"
},
// ...
]
scrubber.rb
is a dirty Ruby script I used to generate these files. You can run it yourself if you wish to re-generate the files fresh from the sources.
To install the gems in the Gemfile:
bundle
To run:
bundle exec ruby scrubber.rb
Note, due to file encoding issues the script should only be run using Ruby 1.9 or above.
tag 9.0
tag 8.0
tag 7.0
tag 6.0
tag 5.0
tag 4.0
tag 3.0
tag 2.0
tag 1.0