{"year":2022,"sampleId":"D030301","farmName":"Farm 03","producerName":"Name 03","producerId":3,"fieldName":"Field 01","fieldId":1,"county":"D","longitude":-120,"latitude":50,"crop":"Wheat","texture":"Silt Loam","totalN_%":0.08,"totalC_%":0.67,"TOC_%":0.67,"OM_%":1.3,"poxC_mg.kg":130,"96hrminC_mgC.kg.day":9.8,"ammN_mg.kg":2.3,"nitrateN_mg.kg":1.9,"ace_g.protein.kg.soil":5.41,"pmN_mg.kg":1.5,"pmN_lbs.ac":5.23,"EC_mmhos.cm":0.29,"olsenP_mg.kg":19,"K_mg.kg":356,"Ca_cmolc.kg":6.6,"Ca_mg.kg":1320,"Mg_cmolc.kg":2.5,"Mg_mg.kg":302.5,"Na_cmolc.kg":0.1,"Na_mg.kg":23,"CEC_meq.100g":10.4,"Zn_mg.kg":0.2,"Mn_mg.kg":4.1,"Cu_mg.kg":1.5,"Fe_mg.kg":18,"S_mg.kg":0.72,"B_mg.kg":0.17,"bd_g.cm3":1.28,"wsa_%":67.6,"WHC_in.ft":2.07,"sand_%":32,"clay_%":12,"silt_%":56,"moisture_%":10.33,"pH":6.1}
{"year":2022,"sampleId":"D030302","farmName":"Farm 03","producerName":"Name 03","producerId":3,"fieldName":"Field 02","fieldId":2,"county":"D","longitude":-120,"latitude":50,"crop":"CRP/Conservation","texture":"Silt Loam","totalN_%":0.09,"totalC_%":0.94,"TOC_%":0.94,"OM_%":1.6,"poxC_mg.kg":201,"96hrminC_mgC.kg.day":27.7,"ammN_mg.kg":5.5,"nitrateN_mg.kg":3.1,"ace_g.protein.kg.soil":5.06,"pmN_mg.kg":14.4,"pmN_lbs.ac":44.62,"EC_mmhos.cm":0.34,"olsenP_mg.kg":23,"K_mg.kg":374,"Ca_cmolc.kg":7.9,"Ca_mg.kg":1580,"Mg_cmolc.kg":2.5,"Mg_mg.kg":302.5,"Na_cmolc.kg":0.07,"Na_mg.kg":16.1,"CEC_meq.100g":11.2,"Zn_mg.kg":0.5,"Mn_mg.kg":2.2,"Cu_mg.kg":1.1,"Fe_mg.kg":12,"S_mg.kg":3.1,"B_mg.kg":0.23,"bd_g.cm3":1.14,"wsa_%":69.2,"WHC_in.ft":2.02,"sand_%":33,"clay_%":13,"silt_%":54,"moisture_%":12.23,"pH":6.6}
{"year":2022,"sampleId":"D040401","farmName":"Farm 04","producerName":"Name 04","producerId":4,"fieldName":"Field 01","fieldId":1,"county":"D","longitude":-120,"latitude":50,"crop":"Apple","texture":"Loamy Sand","totalN_%":0.09,"totalC_%":0.87,"TOC_%":0.87,"OM_%":1.8,"poxC_mg.kg":462,"96hrminC_mgC.kg.day":63.8,"ammN_mg.kg":3.3,"nitrateN_mg.kg":3,"ace_g.protein.kg.soil":9.85,"pmN_mg.kg":30.2,"pmN_lbs.ac":99.27,"EC_mmhos.cm":0.21,"olsenP_mg.kg":55,"K_mg.kg":224,"Ca_cmolc.kg":6.4,"Ca_mg.kg":1280,"Mg_cmolc.kg":1.2,"Mg_mg.kg":145.2,"Na_cmolc.kg":0.1,"Na_mg.kg":23,"CEC_meq.100g":6,"Zn_mg.kg":20.1,"Mn_mg.kg":2.9,"Cu_mg.kg":1.4,"Fe_mg.kg":36,"S_mg.kg":26.36,"B_mg.kg":0.5,"bd_g.cm3":1.21,"wsa_%":87.5,"WHC_in.ft":0.95,"sand_%":76,"clay_%":3,"silt_%":21,"moisture_%":11,"pH":7}
{"year":2022,"sampleId":"D040402","farmName":"Farm 04","producerName":"Name 04","producerId":4,"fieldName":"Field 02","fieldId":2,"county":"D","longitude":-120,"latitude":50,"crop":"Green Manure","texture":"Sandy Loam","totalN_%":0.1,"totalC_%":1.12,"TOC_%":1.02,"OM_%":2.3,"poxC_mg.kg":432,"96hrminC_mgC.kg.day":60,"ammN_mg.kg":2.5,"nitrateN_mg.kg":2.2,"ace_g.protein.kg.soil":9.54,"pmN_mg.kg":57.4,"pmN_lbs.ac":226.52,"EC_mmhos.cm":0.03,"olsenP_mg.kg":22,"K_mg.kg":181,"Ca_cmolc.kg":6.6,"Ca_mg.kg":1320,"Mg_cmolc.kg":1.2,"Mg_mg.kg":145.2,"Na_cmolc.kg":0.09,"Na_mg.kg":20.7,"CEC_meq.100g":7.3,"Zn_mg.kg":23.2,"Mn_mg.kg":1.5,"Cu_mg.kg":0.8,"Fe_mg.kg":12,"S_mg.kg":9.61,"B_mg.kg":0.64,"bd_g.cm3":1.45,"wsa_%":86.8,"WHC_in.ft":1.1,"sand_%":71,"clay_%":2,"silt_%":27,"moisture_%":8.4,"pH":7.4,"inorganicC_%":0.1}
{"year":2022,"sampleId":"D040403","farmName":"Farm 04","producerName":"Name 04","producerId":4,"fieldName":"Field 03","fieldId":3,"county":"D","longitude":-120,"latitude":50,"crop":"Cherry","texture":"Sandy Loam","totalN_%":0.09,"totalC_%":0.86,"TOC_%":0.78,"OM_%":1.8,"poxC_mg.kg":426,"96hrminC_mgC.kg.day":22.5,"ammN_mg.kg":6,"nitrateN_mg.kg":5.5,"ace_g.protein.kg.soil":9.96,"pmN_mg.kg":13,"pmN_lbs.ac":40.43,"EC_mmhos.cm":0.1,"olsenP_mg.kg":39,"K_mg.kg":325,"Ca_cmolc.kg":5.6,"Ca_mg.kg":1120,"Mg_cmolc.kg":1.3,"Mg_mg.kg":157.3,"Na_cmolc.kg":0.08,"Na_mg.kg":18.4,"CEC_meq.100g":7,"Zn_mg.kg":17.2,"Mn_mg.kg":2.3,"Cu_mg.kg":1.9,"Fe_mg.kg":13,"S_mg.kg":47.62,"B_mg.kg":1.11,"bd_g.cm3":1.14,"wsa_%":88.2,"WHC_in.ft":1.31,"sand_%":63,"clay_%":3,"silt_%":34,"moisture_%":16.4,"pH":7.2,"inorganicC_%":0.08}
{"year":2022,"sampleId":"D040404","farmName":"Farm 04","producerName":"Name 04","producerId":4,"fieldName":"Field 04","fieldId":4,"county":"D","longitude":-120,"latitude":50,"crop":"Green Manure","texture":"Sandy Loam","totalN_%":0.13,"totalC_%":1.56,"TOC_%":1.46,"OM_%":2.3,"poxC_mg.kg":521,"96hrminC_mgC.kg.day":52.5,"ammN_mg.kg":3.7,"nitrateN_mg.kg":2.8,"ace_g.protein.kg.soil":11.47,"pmN_mg.kg":20.4,"pmN_lbs.ac":72.85,"EC_mmhos.cm":0.62,"olsenP_mg.kg":26,"K_mg.kg":230,"Ca_cmolc.kg":4.4,"Ca_mg.kg":880,"Mg_cmolc.kg":0.9,"Mg_mg.kg":108.9,"Na_cmolc.kg":0.06,"Na_mg.kg":13.8,"CEC_meq.100g":7.1,"Zn_mg.kg":19.9,"Mn_mg.kg":1.7,"Cu_mg.kg":1.5,"Fe_mg.kg":13,"S_mg.kg":6.84,"B_mg.kg":0.97,"bd_g.cm3":1.31,"wsa_%":89.4,"WHC_in.ft":1.23,"sand_%":66,"clay_%":3,"silt_%":31,"moisture_%":9.5,"pH":7.5,"inorganicC_%":0.1}
{"year":2022,"sampleId":"B010101","farmName":"Farm 01","producerName":"Name 01","producerId":1,"fieldName":"Field 01","fieldId":1,"county":"B","longitude":-120,"latitude":50,"crop":"Hops","texture":"Loam","totalN_%":0.1,"totalC_%":1.01,"TOC_%":0.87,"OM_%":1.8,"poxC_mg.kg":382,"96hrminC_mgC.kg.day":248.25,"ammN_mg.kg":9.3,"nitrateN_mg.kg":19.9,"ace_g.protein.kg.soil":3.73,"pmN_mg.kg":0.1,"pmN_lbs.ac":0.36,"EC_mmhos.cm":1.43,"olsenP_mg.kg":54,"K_mg.kg":457,"Ca_cmolc.kg":15.3,"Ca_mg.kg":3060,"Mg_cmolc.kg":3.4,"Mg_mg.kg":411.4,"Na_cmolc.kg":0.33,"Na_mg.kg":75.9,"CEC_meq.100g":12.6,"Zn_mg.kg":3.1,"Mn_mg.kg":5.5,"Cu_mg.kg":1.3,"Fe_mg.kg":34,"S_mg.kg":34.34,"B_mg.kg":0.3,"bd_g.cm3":1.34,"wsa_%":94.4,"WHC_in.ft":1.69,"sand_%":47,"clay_%":9,"silt_%":44,"moisture_%":24.6,"pH":7.2,"inorganicC_%":0.14,"24hrminC_mgC.kg.day":33.7}
{"year":2022,"sampleId":"B010102","farmName":"Farm 01","producerName":"Name 01","producerId":1,"fieldName":"Field 02","fieldId":2,"county":"B","longitude":-120,"latitude":50,"crop":"Hops","texture":"Silt Loam","totalN_%":0.11,"totalC_%":0.94,"TOC_%":0.94,"OM_%":1.8,"poxC_mg.kg":351,"96hrminC_mgC.kg.day":15.75,"ammN_mg.kg":21.3,"nitrateN_mg.kg":29.7,"ace_g.protein.kg.soil":5.01,"pmN_mg.kg":19.4,"pmN_lbs.ac":72.35,"EC_mmhos.cm":1.04,"olsenP_mg.kg":36,"K_mg.kg":337,"Ca_cmolc.kg":8.8,"Ca_mg.kg":1760,"Mg_cmolc.kg":3.4,"Mg_mg.kg":411.4,"Na_cmolc.kg":0.12,"Na_mg.kg":27.6,"CEC_meq.100g":10.2,"Zn_mg.kg":5.8,"Mn_mg.kg":13.8,"Cu_mg.kg":7.3,"Fe_mg.kg":54,"S_mg.kg":11.01,"B_mg.kg":0.28,"bd_g.cm3":1.37,"wsa_%":92.6,"WHC_in.ft":1.99,"sand_%":36,"clay_%":10,"silt_%":54,"moisture_%":25.27,"pH":6.1,"24hrminC_mgC.kg.day":0}
{"year":2022,"sampleId":"B010103","farmName":"Farm 01","producerName":"Name 01","producerId":1,"fieldName":"Field 03","fieldId":3,"county":"B","longitude":-120,"latitude":50,"crop":"Hops","texture":"Loam","totalN_%":0.11,"totalC_%":1.08,"TOC_%":1.08,"OM_%":2,"poxC_mg.kg":410,"96hrminC_mgC.kg.day":13.5,"ammN_mg.kg":14.5,"nitrateN_mg.kg":15,"ace_g.protein.kg.soil":5.7,"pmN_mg.kg":0.1,"pmN_lbs.ac":0.38,"EC_mmhos.cm":1.35,"olsenP_mg.kg":40,"K_mg.kg":281,"Ca_cmolc.kg":10.6,"Ca_mg.kg":2120,"Mg_cmolc.kg":3.1,"Mg_mg.kg":375.1,"Na_cmolc.kg":0.17,"Na_mg.kg":39.1,"CEC_meq.100g":10.6,"Zn_mg.kg":8.4,"Mn_mg.kg":14.7,"Cu_mg.kg":16.1,"Fe_mg.kg":77,"S_mg.kg":28.39,"B_mg.kg":0.29,"bd_g.cm3":1.39,"wsa_%":94.2,"WHC_in.ft":1.8,"sand_%":43,"clay_%":9,"silt_%":48,"moisture_%":21.93,"pH":6.4,"24hrminC_mgC.kg.day":1.5}
{"year":2022,"sampleId":"B010104","farmName":"Farm 01","producerName":"Name 01","producerId":1,"fieldName":"Field 04","fieldId":4,"county":"B","longitude":-120,"latitude":50,"crop":"Hops","texture":"Silt Loam","totalN_%":0.11,"totalC_%":1.06,"TOC_%":1.06,"OM_%":2.2,"poxC_mg.kg":368,"96hrminC_mgC.kg.day":24,"ammN_mg.kg":12,"nitrateN_mg.kg":21.7,"ace_g.protein.kg.soil":4.48,"pmN_mg.kg":0.1,"pmN_lbs.ac":0.32,"EC_mmhos.cm":1.22,"olsenP_mg.kg":17,"K_mg.kg":186,"Ca_cmolc.kg":16.3,"Ca_mg.kg":3260,"Mg_cmolc.kg":3.3,"Mg_mg.kg":399.3,"Na_cmolc.kg":0.12,"Na_mg.kg":27.6,"CEC_meq.100g":11.7,"Zn_mg.kg":6.1,"Mn_mg.kg":8.3,"Cu_mg.kg":1.4,"Fe_mg.kg":30,"S_mg.kg":9.19,"B_mg.kg":0.24,"bd_g.cm3":1.18,"wsa_%":91.7,"WHC_in.ft":1.92,"sand_%":39,"clay_%":9,"silt_%":52,"moisture_%":27.63,"pH":7,"24hrminC_mgC.kg.day":3.8}
{"year":2022,"sampleId":"B010105","farmName":"Farm 01","producerName":"Name 01","producerId":1,"fieldName":"Field 05","fieldId":5,"county":"B","longitude":-120,"latitude":50,"crop":"Hops","texture":"Loam","totalN_%":0.09,"totalC_%":0.83,"TOC_%":0.83,"OM_%":1.6,"poxC_mg.kg":321,"96hrminC_mgC.kg.day":13.5,"ammN_mg.kg":12,"nitrateN_mg.kg":17.8,"ace_g.protein.kg.soil":0.02,"pmN_mg.kg":0.1,"pmN_lbs.ac":0.39,"EC_mmhos.cm":1.17,"olsenP_mg.kg":28,"K_mg.kg":256,"Ca_cmolc.kg":11.6,"Ca_mg.kg":2320,"Mg_cmolc.kg":2.8,"Mg_mg.kg":338.8,"Na_cmolc.kg":0.14,"Na_mg.kg":32.2,"CEC_meq.100g":10.3,"Zn_mg.kg":3.1,"Mn_mg.kg":6.3,"Cu_mg.kg":1.2,"Fe_mg.kg":31,"S_mg.kg":11.1,"B_mg.kg":0.24,"bd_g.cm3":1.44,"wsa_%":92.7,"WHC_in.ft":1.69,"sand_%":47,"clay_%":9,"silt_%":44,"moisture_%":23.63,"pH":7,"24hrminC_mgC.kg.day":0}
{"year":2022,"sampleId":"B010106","farmName":"Farm 01","producerName":"Name 01","producerId":1,"fieldName":"Field 06","fieldId":6,"county":"B","longitude":-120,"latitude":50,"crop":"Hops","texture":"Sandy Loam","totalN_%":0.1,"totalC_%":0.9,"TOC_%":0.78,"OM_%":2.2,"poxC_mg.kg":362,"96hrminC_mgC.kg.day":25.5,"ammN_mg.kg":15.9,"nitrateN_mg.kg":18.2,"ace_g.protein.kg.soil":4.31,"pmN_mg.kg":25.1,"pmN_lbs.ac":93.33,"EC_mmhos.cm":1.51,"olsenP_mg.kg":26,"K_mg.kg":234,"Ca_cmolc.kg":11.2,"Ca_mg.kg":2240,"Mg_cmolc.kg":2.3,"Mg_mg.kg":278.3,"Na_cmolc.kg":0.19,"Na_mg.kg":43.7,"CEC_meq.100g":8.9,"Zn_mg.kg":2.4,"Mn_mg.kg":6.6,"Cu_mg.kg":1.5,"Fe_mg.kg":28,"S_mg.kg":17.42,"B_mg.kg":0.24,"bd_g.cm3":1.37,"wsa_%":98.7,"WHC_in.ft":1.43,"sand_%":57,"clay_%":7,"silt_%":36,"moisture_%":21.8,"pH":7.3,"inorganicC_%":0.12,"24hrminC_mgC.kg.day":3.8}
{"year":2020,"sampleId":"F050501","farmName":"Farm 05","producerName":"Name 05","producerId":5,"fieldName":"Field 01","fieldId":1,"county":"F","longitude":-120,"latitude":50,"crop":"Potato","texture":"Sandy Loam","totalN_%":0.03,"totalC_%":0.38,"poxC_mg.kg":286.06,"ammN_mg.kg":0.06,"nitrateN_mg.kg":9.13,"ace_g.protein.kg.soil":0.5,"pmN_mg.kg":9.2,"pmN_lbs.ac":34.51,"EC_mmhos.cm":0.91,"K_mg.kg":133,"Ca_mg.kg":860,"Mg_mg.kg":266.2,"Na_mg.kg":50.6,"CEC_meq.100g":6.6,"Zn_mg.kg":3.3,"Mn_mg.kg":8.9,"Cu_mg.kg":0.6,"Fe_mg.kg":13,"S_mg.kg":20.41,"B_mg.kg":0.22,"bd_g.cm3":1.38,"sand_%":78,"clay_%":12,"silt_%":10,"pH":6.8,"24hrminC_mgC.kg.day":38.52,"rootKnot_nematodes.250g":0,"rootLesion_nematodes.500cc":0,"stubbyRoot__nematodes.500cc":0,"stunt_nematodes.500cc":0,"pin_nematodes.500cc":0,"spiral_nematodes.500cc":0,"ring_nematodes.500cc":0,"stem_nematodes.500cc":0,"dagger_nematodes.500cc":0,"sheath_nematodes.500cc":0,"activity_nematodes.500cc":1050,"ammN_lbs.ac":0.23,"nitrateN_lbs.ac":34.29,"brayP_mg.kg":63,"betagluc_":55.66,"awhc_g.g":0.1}
{"year":2020,"sampleId":"F050502","farmName":"Farm 05","producerName":"Name 05","producerId":5,"fieldName":"Field 02","fieldId":2,"county":"F","longitude":-120,"latitude":50,"crop":"Potato","texture":"Loam","totalN_%":0.06,"totalC_%":0.63,"poxC_mg.kg":690.08,"ammN_mg.kg":0.06,"nitrateN_mg.kg":9.04,"ace_g.protein.kg.soil":0.7,"pmN_mg.kg":9.1,"pmN_lbs.ac":28.63,"EC_mmhos.cm":1.12,"K_mg.kg":206,"Ca_mg.kg":2000,"Mg_mg.kg":387.2,"Na_mg.kg":62.1,"CEC_meq.100g":10.2,"Zn_mg.kg":2.5,"Mn_mg.kg":5.5,"Cu_mg.kg":0.9,"Fe_mg.kg":21,"S_mg.kg":27.19,"B_mg.kg":0.28,"bd_g.cm3":1.16,"sand_%":50,"clay_%":14,"silt_%":36,"pH":7.4,"24hrminC_mgC.kg.day":49.5,"rootKnot_nematodes.250g":0,"rootLesion_nematodes.500cc":12,"stubbyRoot__nematodes.500cc":0,"stunt_nematodes.500cc":0,"pin_nematodes.500cc":0,"spiral_nematodes.500cc":0,"ring_nematodes.500cc":0,"stem_nematodes.500cc":0,"dagger_nematodes.500cc":0,"sheath_nematodes.500cc":0,"activity_nematodes.500cc":840,"ammN_lbs.ac":0.19,"nitrateN_lbs.ac":28.43,"brayP_mg.kg":52,"betagluc_":81.78,"awhc_g.g":0.21}
{"year":2020,"sampleId":"F050503","farmName":"Farm 05","producerName":"Name 05","producerId":5,"fieldName":"Field 03","fieldId":3,"county":"F","longitude":-120,"latitude":50,"crop":"Potato","texture":"Sandy Loam","totalN_%":0.05,"totalC_%":0.51,"poxC_mg.kg":762.73,"ammN_mg.kg":0.11,"nitrateN_mg.kg":7.16,"ace_g.protein.kg.soil":0.8,"pmN_mg.kg":7.27,"pmN_lbs.ac":26.85,"EC_mmhos.cm":1.09,"K_mg.kg":176,"Ca_mg.kg":980,"Mg_mg.kg":314.6,"Na_mg.kg":80.5,"CEC_meq.100g":7.8,"Zn_mg.kg":4.7,"Mn_mg.kg":9.8,"Cu_mg.kg":1,"Fe_mg.kg":20,"S_mg.kg":29.03,"B_mg.kg":0.35,"bd_g.cm3":1.36,"sand_%":64,"clay_%":12,"silt_%":24,"pH":6.6,"24hrminC_mgC.kg.day":34,"rootKnot_nematodes.250g":0,"rootLesion_nematodes.500cc":0,"stubbyRoot__nematodes.500cc":18,"stunt_nematodes.500cc":0,"pin_nematodes.500cc":0,"spiral_nematodes.500cc":0,"ring_nematodes.500cc":0,"stem_nematodes.500cc":0,"dagger_nematodes.500cc":0,"sheath_nematodes.500cc":0,"activity_nematodes.500cc":1160,"ammN_lbs.ac":0.39,"nitrateN_lbs.ac":26.45,"brayP_mg.kg":61,"betagluc_":87.26,"awhc_g.g":0.14}
{"year":2020,"sampleId":"B020201","farmName":"Farm 02","producerName":"Name 02","producerId":2,"fieldName":"Field 01","fieldId":1,"county":"B","longitude":-120,"latitude":50,"crop":"Potato","texture":"Silt Loam","totalN_%":0.05,"totalC_%":0.48,"poxC_mg.kg":247.97,"ammN_mg.kg":0.06,"nitrateN_mg.kg":4.95,"ace_g.protein.kg.soil":0.7,"pmN_mg.kg":5.01,"pmN_lbs.ac":17.72,"EC_mmhos.cm":0.86,"K_mg.kg":397,"Ca_mg.kg":1500,"Mg_mg.kg":363,"Na_mg.kg":43.7,"CEC_meq.100g":12.3,"Zn_mg.kg":1.5,"Mn_mg.kg":18.4,"Cu_mg.kg":1.7,"Fe_mg.kg":31,"S_mg.kg":40.37,"B_mg.kg":0.31,"bd_g.cm3":1.16,"sand_%":30,"clay_%":14,"silt_%":56,"pH":6.2,"24hrminC_mgC.kg.day":35.51,"rootKnot_nematodes.250g":0,"rootLesion_nematodes.500cc":0,"stubbyRoot__nematodes.500cc":0,"stunt_nematodes.500cc":4,"pin_nematodes.500cc":0,"spiral_nematodes.500cc":0,"ring_nematodes.500cc":0,"stem_nematodes.500cc":0,"dagger_nematodes.500cc":0,"sheath_nematodes.500cc":0,"activity_nematodes.500cc":850,"ammN_lbs.ac":0.22,"nitrateN_lbs.ac":17.51,"brayP_mg.kg":42,"betagluc_":56.51,"awhc_g.g":0.26}
{"year":2020,"sampleId":"B020202","farmName":"Farm 02","producerName":"Name 02","producerId":2,"fieldName":"Field 02","fieldId":2,"county":"B","longitude":-120,"latitude":50,"crop":"Potato","texture":"Loam","totalN_%":0.05,"totalC_%":0.56,"poxC_mg.kg":619.2,"ammN_mg.kg":-0.05,"nitrateN_mg.kg":15.62,"ace_g.protein.kg.soil":0.9,"pmN_mg.kg":15.57,"pmN_lbs.ac":49.33,"EC_mmhos.cm":0.83,"K_mg.kg":284,"Ca_mg.kg":1360,"Mg_mg.kg":326.7,"Na_mg.kg":46,"CEC_meq.100g":11.5,"Zn_mg.kg":2.2,"Mn_mg.kg":25.7,"Cu_mg.kg":2.2,"Fe_mg.kg":36,"S_mg.kg":46.43,"B_mg.kg":0.97,"bd_g.cm3":1.16,"sand_%":40,"clay_%":16,"silt_%":44,"pH":5.7,"24hrminC_mgC.kg.day":28.86,"rootKnot_nematodes.250g":0,"rootLesion_nematodes.500cc":22,"stubbyRoot__nematodes.500cc":0,"stunt_nematodes.500cc":4,"pin_nematodes.500cc":0,"spiral_nematodes.500cc":0,"ring_nematodes.500cc":0,"stem_nematodes.500cc":0,"dagger_nematodes.500cc":0,"sheath_nematodes.500cc":0,"activity_nematodes.500cc":700,"ammN_lbs.ac":-0.15,"nitrateN_lbs.ac":49.48,"brayP_mg.kg":65,"betagluc_":45.43,"awhc_g.g":0.21}
{"year":2020,"sampleId":"B020203","farmName":"Farm 02","producerName":"Name 02","producerId":2,"fieldName":"Field 03","fieldId":3,"county":"B","longitude":-120,"latitude":50,"crop":"Potato","texture":"Silt Loam","totalN_%":0.08,"totalC_%":0.65,"poxC_mg.kg":328.55,"ammN_mg.kg":0.06,"nitrateN_mg.kg":15.24,"ace_g.protein.kg.soil":0.7,"pmN_mg.kg":15.3,"pmN_lbs.ac":46.22,"EC_mmhos.cm":3.33,"K_mg.kg":249,"Ca_mg.kg":2620,"Mg_mg.kg":290.4,"Na_mg.kg":62.1,"CEC_meq.100g":12.7,"Zn_mg.kg":2.8,"Mn_mg.kg":6.6,"Cu_mg.kg":1.3,"Fe_mg.kg":16,"S_mg.kg":75.97,"B_mg.kg":0.29,"bd_g.cm3":1.11,"sand_%":36,"clay_%":14,"silt_%":50,"pH":7.1,"24hrminC_mgC.kg.day":58.1,"rootKnot_nematodes.250g":0,"rootLesion_nematodes.500cc":68,"stubbyRoot__nematodes.500cc":0,"stunt_nematodes.500cc":6,"pin_nematodes.500cc":0,"spiral_nematodes.500cc":0,"ring_nematodes.500cc":0,"stem_nematodes.500cc":0,"dagger_nematodes.500cc":0,"sheath_nematodes.500cc":0,"activity_nematodes.500cc":680,"ammN_lbs.ac":0.18,"nitrateN_lbs.ac":46.04,"brayP_mg.kg":66,"betagluc_":115.63,"awhc_g.g":0.22}
{"year":2021,"sampleId":"W101001","farmName":"Farm 10","producerName":"Name 10","producerId":10,"fieldName":"Field 01","fieldId":1,"county":"W","longitude":-120,"latitude":50,"crop":"Bean, Garbanzo","texture":"Silt Loam","totalN_%":0.15,"totalC_%":2.04,"poxC_mg.kg":593.03,"ammN_mg.kg":-0.24,"nitrateN_mg.kg":8,"ace_g.protein.kg.soil":2.55,"pmN_mg.kg":7.76,"pmN_lbs.ac":24.41,"EC_mmhos.cm":0.39,"K_mg.kg":388,"Ca_mg.kg":1940,"Mg_mg.kg":242,"Na_mg.kg":11.5,"CEC_meq.100g":0,"Zn_mg.kg":0.4,"Mn_mg.kg":28,"Cu_mg.kg":1.4,"Fe_mg.kg":71,"S_mg.kg":9.56,"B_mg.kg":0.34,"bd_g.cm3":1.16,"sand_%":12,"clay_%":24,"silt_%":64,"pH":5.5,"24hrminC_mgC.kg.day":43.09,"ammN_lbs.ac":-0.74,"nitrateN_lbs.ac":25.15,"betagluc_":115,"awhc_g.g":0.35}
{"year":2021,"sampleId":"W101002","farmName":"Farm 10","producerName":"Name 10","producerId":10,"fieldName":"Field 02","fieldId":2,"county":"W","longitude":-120,"latitude":50,"crop":"Bean, Garbanzo","texture":"Silty Clay Loam","totalN_%":0.15,"totalC_%":2.32,"poxC_mg.kg":673.19,"ammN_mg.kg":-0.24,"nitrateN_mg.kg":9.89,"ace_g.protein.kg.soil":3.32,"pmN_mg.kg":9.65,"pmN_lbs.ac":30.69,"EC_mmhos.cm":0.36,"K_mg.kg":286,"Ca_mg.kg":2360,"Mg_mg.kg":387.2,"Na_mg.kg":13.8,"CEC_meq.100g":0.1,"Zn_mg.kg":0.4,"Mn_mg.kg":19.8,"Cu_mg.kg":1.5,"Fe_mg.kg":49,"S_mg.kg":7.48,"B_mg.kg":0.23,"bd_g.cm3":1.17,"sand_%":12,"clay_%":34,"silt_%":54,"pH":5.7,"24hrminC_mgC.kg.day":40.48,"ammN_lbs.ac":-0.75,"nitrateN_lbs.ac":31.44,"betagluc_":111,"awhc_g.g":0.35}
{"year":2021,"sampleId":"W080801","farmName":"Farm 08","producerName":"Name 08","producerId":8,"fieldName":"Field 01","fieldId":1,"county":"W","longitude":-120,"latitude":50,"crop":"Bean, Garbanzo","texture":"Silt Loam","totalN_%":0.15,"totalC_%":2.04,"poxC_mg.kg":652.88,"ammN_mg.kg":-0.25,"nitrateN_mg.kg":12.14,"ace_g.protein.kg.soil":2,"pmN_mg.kg":11.89,"pmN_lbs.ac":44.02,"EC_mmhos.cm":0.39,"K_mg.kg":222,"Ca_mg.kg":2880,"Mg_mg.kg":387.2,"Na_mg.kg":18.4,"CEC_meq.100g":0.1,"Zn_mg.kg":0.4,"Mn_mg.kg":6,"Cu_mg.kg":0.9,"Fe_mg.kg":30,"S_mg.kg":6.25,"B_mg.kg":0.28,"bd_g.cm3":1.36,"sand_%":12,"clay_%":26,"silt_%":62,"pH":6.4,"24hrminC_mgC.kg.day":45.3,"ammN_lbs.ac":-0.92,"nitrateN_lbs.ac":44.95,"betagluc_":184,"awhc_g.g":0.34}
{"year":2021,"sampleId":"W080802","farmName":"Farm 08","producerName":"Name 08","producerId":8,"fieldName":"Field 02","fieldId":2,"county":"W","longitude":-120,"latitude":50,"crop":"Pea","texture":"Silty Clay Loam","totalN_%":0.15,"totalC_%":2.08,"poxC_mg.kg":538.88,"ammN_mg.kg":-0.23,"nitrateN_mg.kg":10.18,"ace_g.protein.kg.soil":2.66,"pmN_mg.kg":9.94,"pmN_lbs.ac":30.3,"EC_mmhos.cm":0.39,"K_mg.kg":377,"Ca_mg.kg":1800,"Mg_mg.kg":217.8,"Na_mg.kg":6.9,"CEC_meq.100g":0,"Zn_mg.kg":0.5,"Mn_mg.kg":23.1,"Cu_mg.kg":1.2,"Fe_mg.kg":58,"S_mg.kg":7.75,"B_mg.kg":0.29,"bd_g.cm3":1.12,"sand_%":12,"clay_%":28,"silt_%":60,"pH":5.6,"24hrminC_mgC.kg.day":49.84,"ammN_lbs.ac":-0.71,"nitrateN_lbs.ac":31,"betagluc_":147,"awhc_g.g":0.35}
{"year":2021,"sampleId":"W090901","farmName":"Farm 09","producerName":"Name 09","producerId":9,"fieldName":"Field 01","fieldId":1,"county":"W","longitude":-120,"latitude":50,"crop":"Bean, Garbanzo","texture":"Silty Clay Loam","totalN_%":0.11,"totalC_%":1.37,"poxC_mg.kg":411.61,"ammN_mg.kg":-0.24,"nitrateN_mg.kg":7.89,"ace_g.protein.kg.soil":2.53,"pmN_mg.kg":7.65,"pmN_lbs.ac":29.16,"EC_mmhos.cm":0.49,"K_mg.kg":180,"Ca_mg.kg":2020,"Mg_mg.kg":399.3,"Na_mg.kg":11.5,"CEC_meq.100g":0,"Zn_mg.kg":0.5,"Mn_mg.kg":19.6,"Cu_mg.kg":1.2,"Fe_mg.kg":62,"S_mg.kg":9.06,"B_mg.kg":0.28,"bd_g.cm3":1.4,"sand_%":8,"clay_%":30,"silt_%":62,"pH":5.5,"24hrminC_mgC.kg.day":30.11,"ammN_lbs.ac":-0.93,"nitrateN_lbs.ac":30.08,"betagluc_":124,"awhc_g.g":0.3}
{"year":2021,"sampleId":"W090902","farmName":"Farm 09","producerName":"Name 09","producerId":9,"fieldName":"Field 02","fieldId":2,"county":"W","longitude":-120,"latitude":50,"crop":"Bean, Garbanzo","texture":"Silty Clay Loam","totalN_%":0.14,"totalC_%":1.92,"poxC_mg.kg":563.83,"ammN_mg.kg":-0.25,"nitrateN_mg.kg":6.08,"ace_g.protein.kg.soil":2.25,"pmN_mg.kg":5.83,"pmN_lbs.ac":22.48,"EC_mmhos.cm":0.47,"K_mg.kg":345,"Ca_mg.kg":2240,"Mg_mg.kg":326.7,"Na_mg.kg":13.8,"CEC_meq.100g":0.1,"Zn_mg.kg":0.4,"Mn_mg.kg":12.7,"Cu_mg.kg":1.2,"Fe_mg.kg":54,"S_mg.kg":4.72,"B_mg.kg":0.25,"bd_g.cm3":1.42,"sand_%":10,"clay_%":28,"silt_%":62,"pH":5.7,"24hrminC_mgC.kg.day":29.7,"ammN_lbs.ac":-0.95,"nitrateN_lbs.ac":23.43,"betagluc_":136,"awhc_g.g":0.35}
{"year":2021,"sampleId":"O060601","farmName":"Farm 06","producerName":"Name 06","producerId":6,"fieldName":"Field 01","fieldId":1,"county":"O","longitude":-120,"latitude":50,"crop":"Apple","texture":"Sandy Loam","totalN_%":0.16,"totalC_%":2.12,"OM_%":3.64,"poxC_mg.kg":859.85,"96hrminC_mgC.kg.day":38.99,"ammN_mg.kg":-0.18,"nitrateN_mg.kg":39.2,"ace_g.protein.kg.soil":4.62,"pmN_mg.kg":39.02,"pmN_lbs.ac":169.78,"EC_mmhos.cm":0.49,"olsenP_mg.kg":20,"K_mg.kg":287,"Ca_mg.kg":9.6,"Mg_mg.kg":2.3,"Na_mg.kg":0.07,"CEC_meq.100g":12.2,"Zn_mg.kg":19.4,"Mn_mg.kg":5.5,"Cu_mg.kg":1.9,"Fe_mg.kg":19,"S_mg.kg":17.4,"B_mg.kg":1.12,"sand_%":72,"clay_%":14,"silt_%":14,"pH":7.2,"24hrminC_mgC.kg.day":96.09,"rootLesion_nematodes.500cc":8.01,"dagger_nematodes.500cc":5.49,"ammN_lbs.ac":-0.76,"nitrateN_lbs.ac":170.54,"betagluc_":234,"awhc_g.g":0.18,"pr0-15cm_psi":205,"pr15-45cm_psi":325,"infiltration_min.in":0.33,"appleBioassay":0.84,"beanBioassay":4}
{"year":2021,"sampleId":"O060602","farmName":"Farm 06","producerName":"Name 06","producerId":6,"fieldName":"Field 02","fieldId":2,"county":"O","longitude":-120,"latitude":50,"crop":"Apple","texture":"Sandy Loam","totalN_%":0.18,"totalC_%":2.44,"OM_%":4.2,"poxC_mg.kg":816.28,"96hrminC_mgC.kg.day":42.53,"ammN_mg.kg":0.03,"nitrateN_mg.kg":34.32,"ace_g.protein.kg.soil":4.04,"pmN_mg.kg":34.35,"pmN_lbs.ac":149.46,"EC_mmhos.cm":0.78,"olsenP_mg.kg":10,"K_mg.kg":250,"Ca_mg.kg":9.4,"Mg_mg.kg":2.3,"Na_mg.kg":0.1,"CEC_meq.100g":13,"Zn_mg.kg":16.4,"Mn_mg.kg":6.9,"Cu_mg.kg":2.5,"Fe_mg.kg":17,"S_mg.kg":13.8,"B_mg.kg":1.41,"sand_%":66,"clay_%":14,"silt_%":20,"pH":7.2,"24hrminC_mgC.kg.day":99.51,"rootLesion_nematodes.500cc":82.15,"dagger_nematodes.500cc":0,"ammN_lbs.ac":0.13,"nitrateN_lbs.ac":149.33,"betagluc_":177,"awhc_g.g":0.2,"pr0-15cm_psi":240,"pr15-45cm_psi":345,"infiltration_min.in":0.31,"appleBioassay":0.68,"beanBioassay":4.4}
{"year":2021,"sampleId":"O070701","farmName":"Farm 07","producerName":"Name 07","producerId":7,"fieldName":"Field 01","fieldId":1,"county":"O","longitude":-120,"latitude":50,"crop":"Apple","texture":"Sandy Loam","totalN_%":0.16,"totalC_%":2.17,"OM_%":3.73,"poxC_mg.kg":723.04,"96hrminC_mgC.kg.day":40.95,"ammN_mg.kg":0.94,"nitrateN_mg.kg":52.06,"ace_g.protein.kg.soil":3.75,"pmN_mg.kg":53,"pmN_lbs.ac":167.18,"EC_mmhos.cm":0.68,"olsenP_mg.kg":22,"K_mg.kg":277,"Ca_mg.kg":9.3,"Mg_mg.kg":1.7,"Na_mg.kg":0.09,"CEC_meq.100g":11,"Zn_mg.kg":22.6,"Mn_mg.kg":2.1,"Cu_mg.kg":9.2,"Fe_mg.kg":12,"S_mg.kg":36,"B_mg.kg":0.3,"bd_g.cm3":1.16,"sand_%":74,"clay_%":8,"silt_%":18,"pH":7,"24hrminC_mgC.kg.day":87.66,"rootLesion_nematodes.500cc":47.23,"dagger_nematodes.500cc":0,"ammN_lbs.ac":2.96,"nitrateN_lbs.ac":164.22,"betagluc_":296,"awhc_g.g":0.24,"pr0-15cm_psi":218,"pr15-45cm_psi":249,"infiltration_min.in":0.42,"appleBioassay":1.01,"beanBioassay":4}
{"year":2021,"sampleId":"O070702","farmName":"Farm 07","producerName":"Name 07","producerId":7,"fieldName":"Field 02","fieldId":2,"county":"O","longitude":-120,"latitude":50,"crop":"Apple","texture":"Sandy Loam","totalN_%":0.14,"totalC_%":1.59,"OM_%":2.73,"poxC_mg.kg":594.34,"96hrminC_mgC.kg.day":30.38,"ammN_mg.kg":-0.4,"nitrateN_mg.kg":26.75,"ace_g.protein.kg.soil":2.46,"pmN_mg.kg":26.35,"pmN_lbs.ac":89.56,"EC_mmhos.cm":0.44,"olsenP_mg.kg":20,"K_mg.kg":140,"Ca_mg.kg":7.1,"Mg_mg.kg":1.3,"Na_mg.kg":0.09,"CEC_meq.100g":8.8,"Zn_mg.kg":13.1,"Mn_mg.kg":1.6,"Cu_mg.kg":8.2,"Fe_mg.kg":11,"S_mg.kg":28.6,"B_mg.kg":0.21,"bd_g.cm3":1.25,"sand_%":74,"clay_%":8,"silt_%":18,"pH":7.1,"24hrminC_mgC.kg.day":61.39,"rootLesion_nematodes.500cc":2.58,"dagger_nematodes.500cc":0,"ammN_lbs.ac":-1.37,"nitrateN_lbs.ac":90.94,"betagluc_":236,"awhc_g.g":0.14,"pr0-15cm_psi":290,"pr15-45cm_psi":318,"infiltration_min.in":0.4,"appleBioassay":0.94,"beanBioassay":4.5}
{"year":2021,"sampleId":"Y111101","farmName":"Farm 11","producerName":"Name 11","producerId":11,"fieldName":"Field 01","fieldId":1,"county":"Y","longitude":-120,"latitude":50,"crop":"Apple","texture":"Sandy Loam","totalN_%":0.09,"totalC_%":0.88,"OM_%":1.52,"poxC_mg.kg":419.02,"96hrminC_mgC.kg.day":22.94,"ammN_mg.kg":-0.38,"nitrateN_mg.kg":17.09,"ace_g.protein.kg.soil":1.32,"pmN_mg.kg":16.72,"pmN_lbs.ac":71.37,"EC_mmhos.cm":0.29,"olsenP_mg.kg":37,"K_mg.kg":273,"Ca_mg.kg":15.9,"Mg_mg.kg":3,"Na_mg.kg":0.11,"CEC_meq.100g":14.9,"Zn_mg.kg":4,"Mn_mg.kg":1.7,"Cu_mg.kg":1.9,"Fe_mg.kg":25,"S_mg.kg":4.06,"B_mg.kg":0.26,"bd_g.cm3":1.57,"sand_%":62,"clay_%":12,"silt_%":26,"pH":7.5,"24hrminC_mgC.kg.day":53.82,"rootLesion_nematodes.500cc":61.65,"dagger_nematodes.500cc":0,"ammN_lbs.ac":-1.61,"nitrateN_lbs.ac":72.98,"betagluc_":188,"awhc_g.g":0.28,"pr0-15cm_psi":187.33,"pr15-45cm_psi":243.64,"infiltration_min.in":2.29,"appleBioassay":0.92,"beanBioassay":4.5}
{"year":2021,"sampleId":"Y111102","farmName":"Farm 11","producerName":"Name 11","producerId":11,"fieldName":"Field 02","fieldId":2,"county":"Y","longitude":-120,"latitude":50,"crop":"Apple","texture":"Silt Loam","totalN_%":0.12,"totalC_%":1.33,"OM_%":2.29,"poxC_mg.kg":546.26,"96hrminC_mgC.kg.day":33.59,"ammN_mg.kg":0.02,"nitrateN_mg.kg":22.3,"ace_g.protein.kg.soil":2.48,"pmN_mg.kg":22.32,"pmN_lbs.ac":90.42,"EC_mmhos.cm":1.04,"olsenP_mg.kg":63,"K_mg.kg":325,"Ca_mg.kg":12.7,"Mg_mg.kg":3.5,"Na_mg.kg":0.15,"CEC_meq.100g":17.2,"Zn_mg.kg":7.7,"Mn_mg.kg":7,"Cu_mg.kg":4,"Fe_mg.kg":31,"S_mg.kg":42.4,"B_mg.kg":0.48,"bd_g.cm3":1.49,"sand_%":34,"clay_%":16,"silt_%":50,"pH":6.4,"24hrminC_mgC.kg.day":76.25,"rootLesion_nematodes.500cc":39.28,"dagger_nematodes.500cc":2.37,"ammN_lbs.ac":0.08,"nitrateN_lbs.ac":90.34,"betagluc_":154,"awhc_g.g":0.27,"pr0-15cm_psi":270.45,"pr15-45cm_psi":313.64,"infiltration_min.in":2.29,"appleBioassay":0.68,"beanBioassay":6}