Code Monkey home page Code Monkey logo

currency-codes's Introduction

List of currencies and their 3 digit codes as defined by ISO 4217. The data provided here is the consolidation of Table A.1 "Current currency & funds code list" and Table A.3 "Historic denominations".

Note that the ISO page offers pay-for PDFs but also links to http://www.currency-iso.org/en/home/tables.html which does provide them in machine readable form freely.

Data

The data provided (see data/codes.csv) in this data package provides a consolidated list of currency (and funds) codes by combining these two separate tables:

Preparation

The script requires recode package to be istalled. Install it by running:

sudo apt install recode

Run the following script to download and convert the data from XML to CSV:

cd scripts/
./runall.sh

The raw XML files are stored in ./archive. The cleaned data are ./data/codes-all.csv.

Version

The current tables have a published date of 28 March 2014 (as indicated in the XML files).

License

Placing in the Public Domain under the Public Domain Dedication and License. The original site states no restriction on use and the data is small and completely factual.

currency-codes's People

Contributors

anuveyatsu avatar branko-dj avatar kriskusano avatar mikanebu avatar rufaro-dato avatar rufuspollock avatar vitorbaptista avatar zelima avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

currency-codes's Issues

Integer "Numeric Code" Field has Invalid Values

The 4th field (Numeric Code) has a type='integer'. The field contains values of Nil, โ€” (HTML char &#8212), and N.A..

The data protocols spec does not have a default missing values (see also dataprotocols issue #97). An empty cell for non-integer values would be a more clear solution.

@rgrp - are you maintaining this dataset? I would be willing to write a script to download the data and convert the offending column if that would be helpful.

Issues with the data

The links need to be updated - (coincidentally I commented on this in the datahub http://datahub.io/dataset/iso-4217-currency-codes a couple of hours ago)

This table is not really currency codes, its country/currency codes so is denormalized so USD appears in several places as a result. The table is misnamed and less useful as a result.

Oddly too, the reference to a country is by name not by ISO 3166 code. Do you have a policy around linking/foreign keys?

Of course, some folk would use the XML 'package' directly http://www.currency-iso.org/dam/downloads/dl_iso_table_a1.xml :)

Originally opened as datasets/awesome-data#16 by @KitWallace

Invalid CSV according to spec

The included CSV has floating number of fields per row, sometimes exceeding number of fields defined in the metadata.

Moreover it contains invalid integer values for NumericCode โ€“ there is one Nil value (I guess representing an empty field) and some -'s. This can be fixed with changing the field type to string though.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.