In a previous project we used the UN FAO food Pocketbook, although I think the way they compile data changed after 2012. We used the ‘kcal production per capita’ metric, from here: https://www.fao.org/publications/card/en/c/a9f447e8-6798-5e82-82b0-a78724bfff03/
You can see what we did in the following two papers:
https://pubmed.ncbi.nlm.nih.gov/33886124/
https://onlinelibrary.wiley.com/doi/abs/10.1111/risa.13398
There are FAO CSVs for more recent years available to download here: https://www.fao.org/faostat/en/#data/FBS
That’s one suggestion.
In a previous project we used the UN FAO food Pocketbook, although I think the way they compile data changed after 2012. We used the ‘kcal production per capita’ metric, from here: https://www.fao.org/publications/card/en/c/a9f447e8-6798-5e82-82b0-a78724bfff03/
You can see what we did in the following two papers:
https://pubmed.ncbi.nlm.nih.gov/33886124/
https://onlinelibrary.wiley.com/doi/abs/10.1111/risa.13398
There are FAO CSVs for more recent years available to download here: https://www.fao.org/faostat/en/#data/FBS
That’s one suggestion.