How we recovered €2.3bn in Paris grants missing from the Open Data portal
Across two fiscal years (2020 and 2021), €2.3 billion in grants paid by the Ville de Paris to 26,000 beneficiaries do not appear in the standard OpenData file, nor in a journalist's usual searches. The data existed — in a PDF annex of the Administrative Account. Methodical account of a few-hour reconstitution using pdftotext and a 250-line regex parser.
Read the explainer


