mcc-codes
mcc-codes copied to clipboard
greggles
Another source of CSVs
Hi, thanks for your work on this repo!
I recently had to deal with MCCs from Python and decided to publish a python package for iso18245.
I got curious about pulling the data from first-party sources; I also needed range data, not just the list of MCCs, so I worked on generating new CSVs.
I grabbed the official ISO 18245 PDF, as well as the most recent Visa list, the USDA list, and even Stripe Issuing's list. I used Tabula to extract the data, and had to do some extra manual + scripted clean up (especially with Visa's PDF; the rest was pretty clean).
Wanted to share it here in case it's useful for someone:
- Ranges - directly from ISO18245
- Official ISO18245:2003 list of MCCs
- USDA list - this is pulled from this PDF. It's riddled with typos, as can be seen in other issues on this repo…
- VISA list, pulled from this PDF.
- Stripe list - non-exhaustive, pulled from this page, and contains stripe's internal codes as well.
Specifically, I needed to match cut text descriptions to the original MCCs:
It's a wonder why this was standardized on 4-digit codes at all if banking APIs are just going to use mangled english descriptions… but whatever. The python library itself exposes all that data. I've attached all the combined MCCs as JSON here if anyone needs them:
This is very cool! I'd be interested to make you a committer on this repo if you'd like to find a good way to merge in your work?
Feel free to merge it in! But I'm afraid I'm not interested in being a committer on here, I've spent enough time on it as is :)
If you'd like to open up the repo a bit, I recommend the Code Shelter: https://www.codeshelter.co/