I'm currently starting a large project to capture and classify published CC-BY-NC data of an international aid organisation into standard open formats.
(There's an overview of the project online at Open Data for Transparency in Development Aid )
I'll have 2 main blocks of data categories:
- Project / activity data
Project / activity data is pretty straight forward - I will use the IATI activity data format.
I could so far not locate any standards to best capture the operational data
Budgets: These are the annual budgets of the organisation - I've seen Reporting non-country specific administrative spending in IATI standard but that is looking at classifying general administrative overhead of projects vs general administrative costs of running the organisation. Breaking down these administrative cost into IATI sector codes is either not possible or misleading.
Procurements: I'm first trying to capture Requests for Proposal and their related documents - anyone done this before and could suggest standards in use ea.
Salaries, staff numbers: I had a look how e.g. DFID is publishing those, but they are using CSVs for that. So far not been able to identify any JSON / XML standard formats. With staff pay, I'm also looking into clustering the different levels to make them comparable (e.g. Top-Tier, 2nd level management, 3rd level management). Anyone done something similar before or any standards to look into.