Your primary source is the UN Comtrade database, which has various flaws and missing periods, but I wonder if you would be better off with the Food and Beverage Trade Database instead, available from SPC. It has been very intensively cleaned and is based on mirror databases (i.e. checking what countries say they import versus what their partners are exporting and vice versa).
https://stats.pacificdata.org/vis?lc=en&df[ds]=SPC2&df[id]=DF_TRADE_FOOD&df[ag]=SPC&df[vs]=1.0&dq=A.Q.AS%2BCK%2BFJ%2BFM%2BGU%2BKI%2BMH%2BMP%2BNC%2BNR%2BNU%2BPF%2BPG%2BPN%2BPW%2BSB%2BTK%2BTO%2BTV%2BVU%2BWF%2BWS.AU_NZ.10%2B11%2B12%2B15%2B16%2B17%2B18%2B19%2B20%2B21%2B22%2B24%2B02%2B03%2B04%2B07%2B08%2B09&pd=2013,2018&to[TIME_PERIOD]=false
Hmm OK it only seems to go to 2018, I thought it was more current than that. But for up to 2018 it would be better.
@Bimlesh2025 or @mikesharp59 is 2018 (in PDH.stat) the latest that the Pacific Food and Beverage Trade Database goes to, or is it just that PDH.Stat is a bit behind the latest?
Your primary source is the UN Comtrade database, which has various flaws and missing periods, but I wonder if you would be better off with the Food and Beverage Trade Database instead, available from SPC. It has been very intensively cleaned and is based on mirror databases (i.e. checking what countries say they import versus what their partners are exporting and vice versa).
https://stats.pacificdata.org/vis?lc=en&df[ds]=SPC2&df[id]=DF_TRADE_FOOD&df[ag]=SPC&df[vs]=1.0&dq=A.Q.AS%2BCK%2BFJ%2BFM%2BGU%2BKI%2BMH%2BMP%2BNC%2BNR%2BNU%2BPF%2BPG%2BPN%2BPW%2BSB%2BTK%2BTO%2BTV%2BVU%2BWF%2BWS.AU_NZ.10%2B11%2B12%2B15%2B16%2B17%2B18%2B19%2B20%2B21%2B22%2B24%2B02%2B03%2B04%2B07%2B08%2B09&pd=2013,2018&to[TIME_PERIOD]=false
Hmm OK it only seems to go to 2018, I thought it was more current than that. But for up to 2018 it would be better.
@Bimlesh2025 or @mikesharp59 is 2018 (in PDH.stat) the latest that the Pacific Food and Beverage Trade Database goes to, or is it just that PDH.Stat is a bit behind the latest?