Holger Drewes holgerd77
holgerd77
/ get_farmsubsidy_data.sh
Last active
August 29, 2015 14:01
— forked from stefanw/get_farmsubsidy_data.sh
Fixes for Farmsubsidy data files
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Fixes for Farmsubsidy data | |
| # Order of countries is taken form the website: | |
| # http://farmsubsidy.openspending.org/countries/ | |
| set -x verbose | |
| #wget -O AT.zip "http://data.farmsubsidy.org/web/at20130501.zip" | |
| #unzip -d AT AT.zip | |
| # Generic fixes/helpers | |
| # HTML encoding fix | |
| sed 's/\ö/ö/g; s/Ö/Ö/g; s/ü/ü/g; s/Ü/Ü/g; s/ä/ä/g; s/Ä/Ä/g; s/ß/ß/g; s/"/"/g; s/</</g; s/>/>/g; s/&/\&/g; s/&#[0-9]*;//g' [COUNTRY_CODE]/recipient_bad.txt > [COUNTRY_CODE]/recipient.txt |