{"query":" SELECT rv.value_year_collected AS year ,COUNT(DISTINCT(value_result_id))::INTEGER AS sample_count ,AVG(\"Corn\") AS \"Corn\" --,AVG(\"Sweet-Corn\") AS \"Sweet Corn\" ,AVG(\"Soybeans\") AS \"Soybean\" ,AVG(\"Winter-Wheat\") AS \"Wheat\" ,AVG(\"Grassland-Pasture\") AS \"Pasture\" ,AVG(\"Apples\") AS \"Apple\" FROM result_values rv JOIN crop_properties cp ON rv.value_result_id = cp.result_id JOIN pesticide_descriptions pd ON rv.value_pesticide_id = pd.description_pesticide_id  --WHERE value_grid_id=193 --WHERE value_result_id=2 GROUP BY value_year_collected ORDER BY value_year_collected; ","where":"","rowCount":3,"rows":[{"year":2021,"sample_count":16,"Corn":"0.14205502800033456790","Soybean":"0.04793582637193827160","Wheat":"0.00140769130577160494","Pasture":"0.04121788376096296296","Apple":"0.000009985185185185185185"},{"year":2022,"sample_count":28,"Corn":"0.13636322546907272727","Soybean":"0.02456077438286033058","Wheat":"0.00359841042599917355","Pasture":"0.10205689023279338843","Apple":"0.000015039669421487603306"},{"year":2023,"sample_count":110,"Corn":"0.11700996406671081678","Soybean":"0.01248427244797196468","Wheat":"0.00031890682909161148","Pasture":"0.09295046309050772627","Apple":"0.000001490066225165562914"}]}