{"query":" SELECT value_pesticide_id AS pesticide, value_year_collected AS year, --COUNT(value_pesticide_id) AS total_detections, --this over counts detections when we include LEFT JOINs below COALESCE(MAX(contact_ld50_geometric_mean),MAX(oral_ld50_geometric_mean),MAX(contact_acute_ld50_geometric_mean),MAX(oral_acute_ld50_geometric_mean),NULL) AS threshold, MIN(range_lower) AS min_level, MAX(range_upper) AS max_level, MAX(range_upper)/COALESCE(MAX(contact_ld50_geometric_mean),MAX(oral_ld50_geometric_mean),MAX(contact_acute_ld50_geometric_mean),MAX(oral_acute_ld50_geometric_mean),NULL) AS level_div_thresh FROM result_values rv LEFT JOIN pesticide_descriptions pd ON pd.description_pesticide_id=value_pesticide_id LEFT JOIN tosi_lethal tl ON pd.description_pesticide_id=tl.pesticide_id LEFT JOIN tosi_sub_lethal ts ON pd.description_pesticide_id=ts.pesticide_id  GROUP BY value_pesticide_id,value_year_collected ORDER BY value_pesticide_id, value_year_collected ","where":"","rowCount":84,"rows":[{"pesticide":"2-4-DMPF","year":2021,"threshold":null,"min_level":"7.31","max_level":"2016.13","level_div_thresh":null},{"pesticide":"2-4-DMPF","year":2022,"threshold":null,"min_level":"2.08","max_level":"17.54","level_div_thresh":null},{"pesticide":"2-4-DMPF","year":2023,"threshold":null,"min_level":"1.59","max_level":"3733.08","level_div_thresh":null},{"pesticide":"Acetamiprid","year":2022,"threshold":"8.09","min_level":"1.18","max_level":"1.58","level_div_thresh":"0.19530284301606922126"},{"pesticide":"Acetamiprid","year":2023,"threshold":"8.09","min_level":"0.35","max_level":"1.07","level_div_thresh":"0.13226205191594561187"},{"pesticide":"Ametryn","year":2023,"threshold":null,"min_level":"0.4","max_level":"1.25","level_div_thresh":null},{"pesticide":"Atrazine","year":2021,"threshold":"100","min_level":"0.35","max_level":"69.83","level_div_thresh":"0.69830000000000000000"},{"pesticide":"Atrazine","year":2022,"threshold":"100","min_level":"0.13","max_level":"108.27","level_div_thresh":"1.0827000000000000"},{"pesticide":"Atrazine","year":2023,"threshold":"100","min_level":"0.18","max_level":"311.15","level_div_thresh":"3.1115000000000000"},{"pesticide":"Azoxystrobin","year":2021,"threshold":"200","min_level":"0.04","max_level":"0.21","level_div_thresh":"0.00105000000000000000"},{"pesticide":"Azoxystrobin","year":2022,"threshold":"200","min_level":"0.1","max_level":"0.72","level_div_thresh":"0.00360000000000000000"},{"pesticide":"Azoxystrobin","year":2023,"threshold":"200","min_level":"0.08","max_level":"0.36","level_div_thresh":"0.00180000000000000000"},{"pesticide":"Boscalid","year":2022,"threshold":"200","min_level":"2.07","max_level":"6.22","level_div_thresh":"0.03110000000000000000"},{"pesticide":"Boscalid","year":2023,"threshold":"200","min_level":"1.26","max_level":"4.11","level_div_thresh":"0.02055000000000000000"},{"pesticide":"Carbaryl","year":2021,"threshold":"0.14","min_level":"0.52","max_level":"0.77","level_div_thresh":"5.5000000000000000"},{"pesticide":"Carbaryl","year":2022,"threshold":"0.14","min_level":"0.62","max_level":"1.87","level_div_thresh":"13.3571428571428571"},{"pesticide":"Carbaryl","year":2023,"threshold":"0.14","min_level":"0.4","max_level":"1.52","level_div_thresh":"10.8571428571428571"},{"pesticide":"Chlorantraniliprole","year":2021,"threshold":"4","min_level":"0.6","max_level":"1.79","level_div_thresh":"0.44750000000000000000"},{"pesticide":"Chlorantraniliprole","year":2022,"threshold":"4","min_level":"1.22","max_level":"3.74","level_div_thresh":"0.93500000000000000000"},{"pesticide":"Chlorantraniliprole","year":2023,"threshold":"4","min_level":"1.38","max_level":"13.95","level_div_thresh":"3.4875000000000000"},{"pesticide":"Clothianidin","year":2021,"threshold":"0.0321642","min_level":"0.61","max_level":"1.82","level_div_thresh":"56.5846500146125195"},{"pesticide":"Clothianidin","year":2022,"threshold":"0.0321642","min_level":"1.07","max_level":"5.31","level_div_thresh":"165.0903799876881751"},{"pesticide":"Clothianidin","year":2023,"threshold":"0.0321642","min_level":"0.84","max_level":"10.74","level_div_thresh":"333.9116160202958569"},{"pesticide":"Coumaphos","year":2022,"threshold":"4610","min_level":"17.46","max_level":"17.46","level_div_thresh":"0.00378741865509761388"},{"pesticide":"Coumaphos","year":2023,"threshold":"4610","min_level":"4.06","max_level":"12.19","level_div_thresh":"0.00264425162689804772"},{"pesticide":"Cyantraniliprole","year":2023,"threshold":"0.0934","min_level":"1.32","max_level":"4.11","level_div_thresh":"44.0042826552462527"},{"pesticide":"Cyflufenamid","year":2022,"threshold":"100","min_level":"0.23","max_level":"0.96","level_div_thresh":"0.00960000000000000000"},{"pesticide":"Difenoconazole","year":2023,"threshold":"100","min_level":"0.42","max_level":"101.73","level_div_thresh":"1.0173000000000000"},{"pesticide":"Diuron","year":2021,"threshold":"101.7","min_level":"0.66","max_level":"10.04","level_div_thresh":"0.09872173058013765978"},{"pesticide":"Diuron","year":2022,"threshold":"101.7","min_level":"2.03","max_level":"6.49","level_div_thresh":"0.06381514257620452311"},{"pesticide":"Diuron","year":2023,"threshold":"101.7","min_level":"1.51","max_level":"248.36","level_div_thresh":"2.4420845624385447"},{"pesticide":"Fenpyroximate","year":2022,"threshold":"15.8","min_level":"0.21","max_level":"0.62","level_div_thresh":"0.03924050632911392405"},{"pesticide":"Fenpyroximate","year":2023,"threshold":"15.8","min_level":"0.4","max_level":"1.2","level_div_thresh":"0.07594936708860759494"},{"pesticide":"Fluazinam","year":2023,"threshold":"200","min_level":"1.59","max_level":"1.59","level_div_thresh":"0.00795000000000000000"},{"pesticide":"Fluopyram","year":2022,"threshold":"100","min_level":"0.04","max_level":"0.1","level_div_thresh":"0.00100000000000000000"},{"pesticide":"Fluopyram","year":2023,"threshold":"100","min_level":"0.02","max_level":"0.1","level_div_thresh":"0.00100000000000000000"},{"pesticide":"Fluoxastrobin","year":2022,"threshold":"200","min_level":"0.1","max_level":"0.5","level_div_thresh":"0.00250000000000000000"},{"pesticide":"Fluoxastrobin","year":2023,"threshold":"200","min_level":"0.2","max_level":"0.61","level_div_thresh":"0.00305000000000000000"},{"pesticide":"Fluxapyroxad","year":2023,"threshold":"100","min_level":"1.46","max_level":"711.43","level_div_thresh":"7.1143000000000000"},{"pesticide":"Fumagillin","year":2022,"threshold":null,"min_level":"7.97","max_level":"23.92","level_div_thresh":null},{"pesticide":"Fumagillin","year":2023,"threshold":null,"min_level":"17.13","max_level":"51.38","level_div_thresh":null},{"pesticide":"Imidacloprid","year":2021,"threshold":"0.081","min_level":"0.6","max_level":"1.81","level_div_thresh":"22.3456790123456790"},{"pesticide":"Imidacloprid","year":2023,"threshold":"0.081","min_level":"0.61","max_level":"46666.67","level_div_thresh":"576131.728395061728"},{"pesticide":"Indoxacarb","year":2021,"threshold":"0.08","min_level":"2.02","max_level":"6.06","level_div_thresh":"75.7500000000000000"},{"pesticide":"Mandipropamid","year":2023,"threshold":"200","min_level":"0.2","max_level":"0.61","level_div_thresh":"0.00305000000000000000"},{"pesticide":"Metalaxyl","year":2022,"threshold":"200","min_level":"0.1","max_level":"0.31","level_div_thresh":"0.00155000000000000000"},{"pesticide":"Metalaxyl","year":2023,"threshold":"200","min_level":"0.04","max_level":"4930.86","level_div_thresh":"24.6543000000000000"},{"pesticide":"Metolachlor","year":2021,"threshold":"110","min_level":"0.07","max_level":"46.41","level_div_thresh":"0.42190909090909090909"},{"pesticide":"Metolachlor","year":2022,"threshold":"110","min_level":"0.04","max_level":"189.79","level_div_thresh":"1.7253636363636364"},{"pesticide":"Metolachlor","year":2023,"threshold":"110","min_level":"0.09","max_level":"270.91","level_div_thresh":"2.4628181818181818"},{"pesticide":"Napropamide","year":2023,"threshold":null,"min_level":"1.29","max_level":"1.29","level_div_thresh":null},{"pesticide":"Penthiopyrad","year":2023,"threshold":"500","min_level":"0.14","max_level":"0.4","level_div_thresh":"0.00080000000000000000"},{"pesticide":"Phosmet","year":2022,"threshold":"0.22","min_level":"2.13","max_level":"18.39","level_div_thresh":"83.5909090909090909"},{"pesticide":"Phosmet","year":2023,"threshold":"0.22","min_level":"1.99","max_level":"6.24","level_div_thresh":"28.3636363636363636"},{"pesticide":"Picoxystrobin","year":2021,"threshold":"200","min_level":"0.04","max_level":"0.13","level_div_thresh":"0.00065000000000000000"},{"pesticide":"Picoxystrobin","year":2022,"threshold":"200","min_level":"0.1","max_level":"0.32","level_div_thresh":"0.00160000000000000000"},{"pesticide":"Picoxystrobin","year":2023,"threshold":"200","min_level":"0.1","max_level":"0.35","level_div_thresh":"0.00175000000000000000"},{"pesticide":"Piperonyl-butoxide","year":2021,"threshold":"294","min_level":"0.04","max_level":"1.7","level_div_thresh":"0.00578231292517006803"},{"pesticide":"Piperonyl-butoxide","year":2022,"threshold":"294","min_level":"0.04","max_level":"6.45","level_div_thresh":"0.02193877551020408163"},{"pesticide":"Piperonyl-butoxide","year":2023,"threshold":"294","min_level":"0.06","max_level":"22.97","level_div_thresh":"0.07812925170068027211"},{"pesticide":"Prometryn","year":2023,"threshold":"99","min_level":"0.14","max_level":"0.44","level_div_thresh":"0.00444444444444444444"},{"pesticide":"Propazine","year":2021,"threshold":"16","min_level":"0.1","max_level":"2.39","level_div_thresh":"0.14937500000000000000"},{"pesticide":"Propazine","year":2022,"threshold":"16","min_level":"0.1","max_level":"1.42","level_div_thresh":"0.08875000000000000000"},{"pesticide":"Propazine","year":2023,"threshold":"16","min_level":"0.1","max_level":"3.56","level_div_thresh":"0.22250000000000000000"},{"pesticide":"Propiconazole","year":2023,"threshold":"100","min_level":"4.02","max_level":"4.02","level_div_thresh":"0.04020000000000000000"},{"pesticide":"Pyraclostrobin","year":2022,"threshold":"100","min_level":"0.16","max_level":"0.51","level_div_thresh":"0.00510000000000000000"},{"pesticide":"Pyraclostrobin","year":2023,"threshold":"100","min_level":"0.08","max_level":"1582.77","level_div_thresh":"15.8277000000000000"},{"pesticide":"Pyrimethanil","year":2023,"threshold":"100","min_level":"0.67","max_level":"2.05","level_div_thresh":"0.02050000000000000000"},{"pesticide":"Tebufenozide","year":2021,"threshold":"234","min_level":"0.47","max_level":"0.47","level_div_thresh":"0.00200854700854700855"},{"pesticide":"Tebuthiuron","year":2021,"threshold":"30","min_level":"0.03","max_level":"0.26","level_div_thresh":"0.00866666666666666667"},{"pesticide":"Tebuthiuron","year":2022,"threshold":"30","min_level":"0.09","max_level":"1.77","level_div_thresh":"0.05900000000000000000"},{"pesticide":"Tebuthiuron","year":2023,"threshold":"30","min_level":"0.12","max_level":"12.02","level_div_thresh":"0.40066666666666666667"},{"pesticide":"Thiabendazole","year":2021,"threshold":"34","min_level":"0.37","max_level":"0.37","level_div_thresh":"0.01088235294117647059"},{"pesticide":"Thiabendazole","year":2023,"threshold":"34","min_level":"0.2","max_level":"1.52","level_div_thresh":"0.04470588235294117647"},{"pesticide":"Thiacloprid","year":2021,"threshold":"38.82","min_level":"0.13","max_level":"0.4","level_div_thresh":"0.01030396702730551262"},{"pesticide":"Thiamethoxam","year":2021,"threshold":"0.01704113","min_level":"0.2","max_level":"0.81","level_div_thresh":"47.5320592002995107"},{"pesticide":"Thiamethoxam","year":2023,"threshold":"0.01704113","min_level":"0.82","max_level":"11.3","level_div_thresh":"663.1015666214623091"},{"pesticide":"Thiophanate-methyl","year":2021,"threshold":"100","min_level":"0.39","max_level":"1.21","level_div_thresh":"0.01210000000000000000"},{"pesticide":"Thiophanate-methyl","year":2022,"threshold":"100","min_level":"0.6","max_level":"5.68","level_div_thresh":"0.05680000000000000000"},{"pesticide":"Thiophanate-methyl","year":2023,"threshold":"100","min_level":"0.6","max_level":"1.84","level_div_thresh":"0.01840000000000000000"},{"pesticide":"Triadimefon","year":2023,"threshold":"25","min_level":"2.56","max_level":"2.56","level_div_thresh":"0.10240000000000000000"},{"pesticide":"Trifloxystrobin","year":2021,"threshold":"100","min_level":"0.1","max_level":"0.41","level_div_thresh":"0.00410000000000000000"},{"pesticide":"Trifloxystrobin","year":2022,"threshold":"100","min_level":"0.08","max_level":"0.83","level_div_thresh":"0.00830000000000000000"},{"pesticide":"Trifloxystrobin","year":2023,"threshold":"100","min_level":"0.08","max_level":"1.08","level_div_thresh":"0.01080000000000000000"}]}