dw8547
commented
8 years ago I run a final sanity check on the automated individual donor ODA data series in DDW data series as follows: I downloaded all of the relevant .csv files from: https://github.com/devinit/digital-platform/tree/master/country-year/oda-donor and read the .csv files into tables. I then compared the content in these tables with fact.oda_donor_2012 applying a filer to 'from_di_id' as appropriate. For example, I compared:
https://github.com/devinit/digital-platform/tree/master/country-year/oda-donor/oda-AEwith:
SELECT
*
FROM fact.oda_donor_2012
WHERE from_di_id = 'AE'
AND year BETWEEN 2006 AND 2013
;I did this for all of the files in https://github.com/devinit/digital-platform/tree/master/country-year/oda-donor. The files in this folder were updated/created at the time indicated in the repository. The data in fact.oda_donor_2012 was sourced from the OECD on 2016/01/20 as were the deflators used in the price conversion function which was used to convert the values into 2012 constant prices. Note: the OECD has not updated the deflators therefore they are out of sync with the CRS ⇒ minor data loss.
@xriss, it looks like the fact table fact.oda_donor_2012 has the right data in it (assuming what's in the .csv files in right). You can go ahead and replace the data with that from the DDW for these data series.
@xriss, the donor id 'afesd' has been removed (duplicate of 'arab-fund-afesd') & the donor id 'idb-specialfund' needs to be changed to 'idb-special-fund'.
@xriss, this is a separate issue for the data check of the individual donor ODA data series in DDW. I'll use it to OK these:
@xriss, these do need to be replaced with DW data. The data for these is in fact.oda_donor_2012. To get at the individual donor data, we need to filer on the di_id for the relevant years so: