The Global Landscapes Initiative has crop yield and distribution data globally for all 177 FAO crops free online at www.earthstat.org. Stefan Siebert has done some really nice work quantifying total annual water consumption by crops ( https://www.researchgate.net/publication/222076577_Quantifying_blue_and_green_virtual_water_contents_in_global_crop_production_as_well_as_potential_production_losses_without_irrigation?ev=prf_pub ), and his work is integrated into FAO's Aquastat database.
To the best of my knowledge, there isn't yet a global database of crop production costs - let me know if you find one!
All the best,
Kate
Article Quantifying Blue and Green Virtual Water Contents in Global ...