County level prices for a crop are determined by taking the weighted average of policy prices at the county x crop x irrigation method x unit structure level, where the weights are based on statewide takeup (as measured by the net reporting level, i.e., number of insured acres) of the policy in a given year. In cases where the number of policies taken up at the state level exceeded that at the county level, reweighting was done.

County pairs crossing state borders were dropped. County pairs where 0 takeup (i.e., number of acres insured) is observed in both counties were dropped.

Non-Irrigated Wheat

County border price differences for non-irrigated wheat
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU 0.02603 0.03311 0 0.005 0.01500 0.034 0.44228
EP 0.02801 0.03592 0 0.006 0.01609 0.036 0.47832
EU 0.02751 0.03478 0 0.006 0.01600 0.036 0.47832
OU 0.02603 0.03311 0 0.005 0.01500 0.034 0.44228
County border subsidized price differences for non-irrigated wheat
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU 0.01067 0.01357 0 0.00205 0.00615 0.01394 0.18134
EP 0.00560 0.00718 0 0.00120 0.00322 0.00720 0.09566
EU 0.00550 0.00696 0 0.00120 0.00320 0.00720 0.09566
OU 0.01067 0.01357 0 0.00205 0.00615 0.01394 0.18134
County border takeup differences (measured as number insured acres) for non-irrigated wheat
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU -140.30217 1693.189 -27359.10 -188.7314 -12.60226 94.9196 32853.28
EP -105.21086 1467.942 -15097.85 -311.0000 -39.25560 197.0000 15097.85
EU -94.54806 1492.519 -24287.00 -308.0000 -37.00000 209.0000 23250.00
OU -140.30217 1693.189 -27359.10 -188.7314 -12.60226 94.9196 32853.28
County border takeup differences (measured as liability amount in $) for non-irrigated wheat
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU -31821.91 328052.4 -6545050 -37895.75 -2447.249 18238.09 4854308
EP -22118.06 255166.8 -3686595 -52357.50 -6913.562 33562.29 2624844
EU -21371.65 282545.6 -3816356 -60585.41 -7501.867 40227.23 3818560
OU -31821.91 328052.4 -6545050 -37895.75 -2447.249 18238.09 4854308

Irrigated Wheat

County border price differences for irrigated wheat
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU 0.02636 0.03121 0 0.007 0.01700 0.03400 0.391
EP 0.02576 0.03091 0 0.007 0.01698 0.03242 0.342
EU 0.02563 0.03119 0 0.007 0.01600 0.03288 0.361
OU 0.02636 0.03121 0 0.007 0.01700 0.03400 0.391
County border subsidized price differences for irrigated wheat
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU 0.01081 0.01280 0 0.00287 0.00697 0.01394 0.16031
EP 0.00515 0.00618 0 0.00140 0.00340 0.00648 0.06840
EU 0.00513 0.00624 0 0.00140 0.00320 0.00658 0.07220
OU 0.01081 0.01280 0 0.00287 0.00697 0.01394 0.16031
County border takeup differences (measured as number insured acres) for irrigated wheat
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU -122.7281 1396.2015 -22159.223 -154.1310 -14.04404 70.6380 20415.018
EP -109.0813 859.4088 -5226.584 -213.6036 -25.00000 117.0000 6003.617
EU -86.2234 786.8513 -5623.000 -204.7189 -27.00000 117.6863 6534.584
OU -122.7281 1396.2015 -22159.223 -154.1310 -14.04404 70.6380 20415.018
County border takeup differences (measured as liability amount in $) for irrigated wheat
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU -51067.20 679103.2 -11803305 -34417.44 -2927.335 15302.86 11349001
EP -34675.88 341293.5 -2252594 -54787.20 -3420.083 25877.35 2649791
EU -28915.74 354224.7 -4840866 -57561.40 -5856.851 30617.79 5673092
OU -51067.20 679103.2 -11803305 -34417.44 -2927.335 15302.86 11349001

Non-Irrigated Soy

County border price differences for non-irrigated soy
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU 0.02280 0.02826 0 0.005 0.0130 0.03013 0.47000
EP 0.02038 0.02514 0 0.004 0.0118 0.02793 0.30783
EU 0.02107 0.02612 0 0.004 0.0120 0.02841 0.30783
OU 0.02280 0.02826 0 0.005 0.0130 0.03013 0.47000
County border subsidized price differences for non-irrigated soy
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU 0.00935 0.01159 0 0.00205 0.00533 0.01235 0.19270
EP 0.00408 0.00503 0 0.00080 0.00236 0.00559 0.06157
EU 0.00421 0.00522 0 0.00080 0.00240 0.00568 0.06157
OU 0.00935 0.01159 0 0.00205 0.00533 0.01235 0.19270
County border takeup differences (measured as number insured acres) for non-irrigated soy
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU -64.03461 1228.654 -17523.39 -295.5538 -20.70451 170.7928 16853.72
EP -87.82452 1316.974 -22654.80 -399.1499 -41.76145 274.5446 21917.41
EU -77.27657 1339.795 -25567.20 -373.0706 -38.21532 258.0000 28459.27
OU -64.03461 1228.654 -17523.39 -295.5538 -20.70451 170.7928 16853.72
County border takeup differences (measured as liability amount in $) for non-irrigated soy
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU -27805.81 363456.7 -5792371 -89370.13 -6204.338 43394.63 4811677
EP -34136.50 452080.0 -10460778 -120309.97 -11444.078 72916.56 10131059
EU -32396.73 469771.7 -10460778 -119084.11 -10945.662 72941.91 10131059
OU -27805.81 363456.7 -5792371 -89370.13 -6204.338 43394.63 4811677

Irrigated Soy

County border price differences for irrigated soy
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU 0.01664 0.02209 0 0.003 0.009 0.02107 0.293
EP 0.01525 0.01778 0 0.003 0.009 0.02100 0.154
EU 0.01666 0.01952 0 0.004 0.010 0.02300 0.210
OU 0.01664 0.02209 0 0.003 0.009 0.02107 0.293
County border subsidized price differences for irrigated soy
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU 0.00682 0.00906 0 0.00123 0.00369 0.00864 0.12013
EP 0.00305 0.00356 0 0.00060 0.00180 0.00420 0.03080
EU 0.00333 0.00390 0 0.00080 0.00200 0.00460 0.04200
OU 0.00682 0.00906 0 0.00123 0.00369 0.00864 0.12013
County border takeup differences (measured as number insured acres) for irrigated soy
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU -105.4472 1270.092 -10776.52 -123.4557 -8.08476 59.8419 11254.80
EP -606.3250 5765.549 -70433.25 -275.8998 -23.14587 154.5084 63388.61
EU -538.3405 5501.782 -70832.12 -292.0000 -24.67093 170.8617 63388.61
OU -105.4472 1270.092 -10776.52 -123.4557 -8.08476 59.8419 11254.80
County border takeup differences (measured as liability amount in $) for irrigated soy
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU -51422.76 535248.9 -5009690 -43487.9 -2524.677 18795.62 4898475
EP -267477.31 2526209.1 -38944720 -99944.0 -7959.753 50593.16 30670746
EU -254962.63 2564200.5 -39126816 -114791.2 -8689.296 60529.30 33862592
OU -51422.76 535248.9 -5009690 -43487.9 -2524.677 18795.62 4898475

Non-Irrigated Corn

County border price differences for non-irrigated corn
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU 0.02851 0.03732 0 0.00508 0.016 0.03766 0.658
EP 0.02876 0.03957 0 0.00500 0.015 0.03700 0.516
EU 0.02741 0.03751 0 0.00500 0.015 0.03500 0.516
OU 0.02851 0.03732 0 0.00508 0.016 0.03766 0.658
County border subsidized price differences for non-irrigated corn
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU 0.01169 0.01530 0 0.00208 0.00656 0.01544 0.26978
EP 0.00575 0.00791 0 0.00100 0.00300 0.00740 0.10320
EU 0.00548 0.00750 0 0.00100 0.00300 0.00700 0.10320
OU 0.01169 0.01530 0 0.00208 0.00656 0.01544 0.26978
County border takeup differences (measured as number insured acres) for non-irrigated corn
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU -45.35549 899.1737 -18198.79 -227.5844 -13.27460 140.1785 10794.75
EP -82.43955 1226.3979 -15841.22 -362.7010 -23.00000 249.9165 12347.96
EU -57.28875 1232.0372 -19003.00 -340.0000 -20.52449 257.0000 21016.00
OU -45.35549 899.1737 -18198.79 -227.5844 -13.27460 140.1785 10794.75
County border takeup differences (measured as liability amount in $) for non-irrigated corn
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU -27280.98 415667.3 -6914678 -87686.52 -4906.396 44827.90 6914678
EP -51430.84 627996.1 -11662219 -148256.19 -7511.144 86835.96 8623067
EU -41201.64 627958.9 -11662219 -148788.98 -7723.142 96763.74 8623067
OU -27280.98 415667.3 -6914678 -87686.52 -4906.396 44827.90 6914678

Irrigated Corn

County border price differences for irrigated corn
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU 0.01714 0.02295 0 0.00300 0.00952 0.02200 0.394
EP 0.01584 0.01927 0 0.00300 0.00900 0.02101 0.292
EU 0.01683 0.02137 0 0.00309 0.00997 0.02200 0.292
OU 0.01714 0.02295 0 0.00300 0.00952 0.02200 0.394
County border subsidized price differences for irrigated corn
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU 0.00703 0.00941 0 0.00123 0.00390 0.00902 0.16154
EP 0.00317 0.00385 0 0.00060 0.00180 0.00420 0.05840
EU 0.00337 0.00427 0 0.00062 0.00199 0.00440 0.05840
OU 0.00703 0.00941 0 0.00123 0.00390 0.00902 0.16154
County border takeup differences (measured as number insured acres) for irrigated corn
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU -178.99996 2314.629 -29384.05 -234.0981 -12.36924 121.7376 26205.05
EP -80.59451 2383.179 -24515.00 -283.3422 -8.02456 262.0865 19911.68
EU -96.76768 2278.293 -29543.00 -313.0000 -17.07635 270.0000 21373.45
OU -178.99996 2314.629 -29384.05 -234.0981 -12.36924 121.7376 26205.05
County border takeup differences (measured as liability amount in $) for irrigated corn
unitstructurecode Mean SD Min Q1 Median Q3 Max
BU -112437.26 1480105 -18884336 -124786.5 -5520.939 59872.63 18705820
EP -55067.62 1360290 -16494527 -148928.6 -3711.219 131854.58 13377346
EU -65629.24 1415710 -21469568 -171953.9 -9239.279 147112.00 19628976
OU -112437.26 1480105 -18884336 -124786.5 -5520.939 59872.63 18705820