Closed StephenAbbott closed 6 days ago
@StephenAbbott One question on this - the .csv file format doesn't have a concept of multiple tabs / sheets within one file so to add the metadata we would either need to have two downloadable files (with links for each on the page), or change to an .xls format which is slightly less accessible as it's a proprietary format and not everyone will have access to Excel. Any preference?
@drcongo I think two downloadable files - one updated regularly and one with static metadata - sounds preferable. And hopefully that is the more straightforward option?
In 2022/2023, we introduced the ability on the Open Ownership website for users to download csv files containing a subset of the information on beneficial ownership commitments and implementation which Open Ownership collects via Notion trackers that power our Open Ownership Map and country pages.
See https://github.com/openownership/openownership.org-wagtail/issues/158 and https://github.com/openownership/openownership.org-wagtail/issues/399 for previous work
Following discussions with our advocacy and policy/research teams, we'd like to make the following changes to the information published in the global csv file under the OO Map and the country files published on the country pages.
Overall aim is to remove all the fields relating to commitments coming from the commitment tracker and instead focus on details about registers coming from the implementation tracker.
FIELDS TO BE REMOVED FROM GLOBAL CSV FILE AND COUNTRY CSV FILES
UPDATED FIELDS FOR GLOBAL CSV FILE AND COUNTRY CSV FILES
NEW FIELDS FOR GLOBAL CSV FILE AND COUNTRY CSV FILES
To better explain what all the fields mean, we would also like to have the following information published in a 'Metadata' tab in the csv: