FoodLand survey crop checks
fabrizio
01/12/2021
Checks
The first checks are made on:
- production per unit of area per crop;
- ratio of quantity sold and produced per crop;
- prices per crop.
The evaluation of potential outliers is done by considering as a limit 3 times the interquartile range.
A second round of checks is made on the basis of those listed in the table below:
| ord | check | app.function |
|---|---|---|
| 1 | crop 1 different product q61 - q141 | q61 != q141 |
| 2 | crop 1 different product q61 - q171 | q61 != q171 |
| 3 | crop 2 different product q62 - q142 | q62 != q142 |
| 4 | crop 2 different product q62 - q172 | q62 != q172 |
| 5 | crop 3 different product q63 - q143 | q63 != q143 |
| 6 | crop 3 different product q63 - q173 | q63 != q173 |
| 7 | The sum of the sizes for the Tenure status must be less than or equal to the total size | round((q51_size+q52_size+q53_size+q54_size)/q55_tot,2) > 1 |
| 8 | land size of Crop N.1 must be less than or equal to the total size | q61_size/q55_tot > 1 |
| 9 | land size of Crop N.2 must be less than or equal to the total size | q62_size/q55_tot > 1 |
| 10 | land size of Crop N.3 must be less than or equal to the total size | q63_size/q55_tot > 1 |
| 11 | crop 1 quantity sold must be less than or equal to the quantity produced | q141_qs/q141_qp > 1 |
| 12 | crop 2 quantity sold must be less than or equal to the quantity produced | q142_qs/q142_qp > 1 |
| 13 | crop 3 quantity sold must be less than or equal to the quantity produced | q143_qs/q143_qp > 1 |
| 14 | household members aged 14 or older involved in the farm must be less than or equal to the adults 14 or older | q27/q224 > 1 |
| 15 | farmer age | |
| 16 | total household members | |
| 17 | Number of household members who emigrated | |
| 18 | Number of people outside the household employed in the farm |
For checks that include a function, the cases that do not satisfy the check are reported;
for checks without a function, cases that exceed 3x IQR are reported as potential outliers, as before.
Finally, there are tables of categorical variables with missing cases.
MO_crop_Meknes
crop.1 production x unit size
session_number participant_id q61_size q141_qp q141 q61 q141_qp_u q61_unit prd_unit.size
131 124 0.25 80000 olive olive kg ha 320000
442 437 0.012 3000 onion onion kg ha 250000
210 203 0.0004 50 onion onion kg ha 125000
238 231 0.03 1000 olive olive kg ha 33333.
114 107 1 30000 bean bean kg ha 30000
76 68 0.07 2000 wheat wheat kg ha 28571.
75 67 3 80000 soft wheat soft wheat kg ha 26667.
158 151 3.5 90000 wheat wheat kg ha 25714.
157 150 3 60000 wheat wheat kg ha 20000
159 152 4 80000 soft wheat soft wheat kg ha 20000
160 153 3 60000 soft wheat soft wheat kg ha 20000
173 166 2 40000 wheat wheat kg ha 20000
179 172 2 35000 wheat wheat kg ha 17500
191 184 2 30000 wheat wheat kg ha 15000
192 185 1 15000 wheat wheat kg ha 15000
379 373 2 30000 wheat wheat kg ha 15000
53 45 3 40000 wheat wheat kg ha 13333.
133 126 1 6000 barley barley kg ha 6000
crop.2 production x unit size
session_number participant_id q62_size q142_qp q142 q62 q142_qp_u q62_unit prd_unit.size
447 442 0.25 30000 potato potato kg ha 120000
424 418 0.5 50000 potato potato kg ha 100000
10 2 1 80000 wheat wheat kg ha 80000
217 210 0.5 30000 barley barley kg ha 60000
272 265 0.5 25000 wheat wheat kg ha 50000
226 219 0.5 15000 oat oat kg ha 30000
505 500 1 30000 wheat wheat kg ha 30000
27 20 1.5 40000 barley barley kg ha 26667.
161 154 1.5 40000 bean bean kg ha 26667.
173 166 2 50000 bean bean kg ha 25000
464 459 2 50000 wheat wheat kg ha 25000
158 151 1.5 35000 bean bean kg ha 23333.
76 68 0.1 2000 soft wheat soft wheat kg ha 20000
459 454 2 40000 wheat wheat kg ha 20000
263 256 0.5 8000 bean bean kg ha 16000
53 45 3 40000 barley barley kg ha 13333.
165 158 3 40000 wheat wheat kg ha 13333.
56 48 2 24000 wheat wheat kg ha 12000
crop.3 production x unit size
session_number participant_id q63_size q143_qp q143 q63 q143_qp_u q63_unit prd_unit.size
125 118 0.5 30000 watermelon watermelon kg ha 60000
357 351 0.001 50 legume legume kg ha 50000
27 20 1 40000 wheat wheat kg ha 40000
157 150 1 35000 barley barley kg ha 35000
36 28 1 30000 olive olive kg ha 30000
215 208 2.75 60000 wheat wheat kg ha 21818.
46 38 1 20000 olive olive kg ha 20000
56 48 2 40000 soft wheat soft wheat kg ha 20000
59 51 1 20000 grain grain kg ha 20000
120 113 2 35000 bean bean kg ha 17500
180 173 1 15000 oat oat kg ha 15000
310 304 1.5 20000 bean bean kg ha 13333.
191 184 2 25000 bean bean kg ha 12500
281 275 0.25 3000 grain grain kg ha 12000
171 164 6.3 65000 wheat wheat kg ha 10317.
58 50 3 30000 wheat wheat kg ha 10000
165 158 1 10000 bean bean kg ha 10000
179 172 2 20000 oat oat kg ha 10000
503 498 1 10000 bean bean kg ha 10000
307 301 0.5 3000 oat oat kg ha 6000
## crop 1 different product q61 - q141
no failed check
## crop 1 different product q61 - q171
no failed check
## crop 2 different product q62 - q142
no failed check
## crop 2 different product q62 - q172
no failed check
## crop 3 different product q63 - q143
no failed check
## crop 3 different product q63 - q173
no failed check
## The sum of the sizes for the Tenure status must be less than or equal to the total size
no failed check
## land size of Crop N.1 must be less than or equal to the total size
no failed check
## land size of Crop N.2 must be less than or equal to the total size
no failed check
## land size of Crop N.3 must be less than or equal to the total size
no failed check
## crop 1 quantity sold must be less than or equal to the quantity produced
no failed check
## crop 2 quantity sold must be less than or equal to the quantity produced
no failed check
## crop 3 quantity sold must be less than or equal to the quantity produced
no failed check
## household members aged 14 or older involved in the farm must be less than or equal to the adults 14 or older
failed checks
session_number participant_id q27 q224 q27/q224
1 10 2 2 1 2.0
2 13 4 11 1 11.0
3 14 6 2 1 2.0
4 16 8 2 1 2.0
5 17 9 2 1 2.0
6 21 13 3 1 3.0
7 24 16 3 1 3.0
8 26 18 3 1 3.0
9 27 20 2 1 2.0
10 29 21 3 1 3.0
11 32 24 2 1 2.0
12 34 26 3 1 3.0
13 35 27 2 1 2.0
14 36 28 4 1 4.0
15 37 29 3 1 3.0
16 38 30 2 1 2.0
17 39 31 3 1 3.0
18 41 33 4 1 4.0
19 43 35 2 1 2.0
20 45 37 3 1 3.0
21 46 38 4 1 4.0
22 47 39 2 1 2.0
23 48 40 4 1 4.0
24 49 41 6 1 6.0
25 53 45 6 1 6.0
26 54 46 4 1 4.0
27 55 47 3 1 3.0
28 56 48 4 1 4.0
29 58 50 8 1 8.0
30 59 51 2 1 2.0
31 60 52 3 1 3.0
32 61 53 2 1 2.0
33 64 56 2 1 2.0
34 65 57 3 1 3.0
35 67 59 3 1 3.0
36 69 61 3 1 3.0
37 70 62 2 1 2.0
38 72 64 2 1 2.0
39 73 65 3 1 3.0
40 74 66 3 1 3.0
41 75 67 3 1 3.0
42 77 69 2 1 2.0
43 80 72 11 1 11.0
44 87 79 2 1 2.0
45 93 86 4 1 4.0
46 95 88 9 1 9.0
47 96 89 2 1 2.0
48 99 92 3 1 3.0
49 100 93 2 1 2.0
50 101 94 2 1 2.0
51 102 95 2 1 2.0
52 104 97 2 1 2.0
53 105 98 3 1 3.0
54 110 103 3 1 3.0
55 111 104 4 1 4.0
56 113 106 2 1 2.0
57 115 108 2 1 2.0
58 118 111 2 1 2.0
59 119 112 2 1 2.0
60 124 117 4 1 4.0
61 125 118 3 1 3.0
62 127 120 2 1 2.0
63 128 121 3 1 3.0
64 129 122 2 1 2.0
65 134 127 2 1 2.0
66 136 129 2 1 2.0
67 139 132 2 1 2.0
68 142 135 2 1 2.0
69 144 137 2 1 2.0
70 146 139 3 1 3.0
71 147 140 2 1 2.0
72 153 146 2 1 2.0
73 155 148 2 1 2.0
74 156 149 2 1 2.0
75 157 150 6 1 6.0
76 159 152 2 1 2.0
77 160 153 2 1 2.0
78 163 156 3 1 3.0
79 164 157 2 1 2.0
80 167 160 2 1 2.0
81 168 161 2 1 2.0
82 171 164 4 1 4.0
83 172 165 2 1 2.0
84 174 167 2 1 2.0
85 180 173 3 1 3.0
86 183 176 2 1 2.0
87 185 178 3 1 3.0
88 186 179 2 1 2.0
89 187 180 2 1 2.0
90 189 182 4 1 4.0
91 191 184 3 1 3.0
92 192 185 3 1 3.0
93 206 199 5 1 5.0
94 220 213 2 1 2.0
95 224 217 2 1 2.0
96 242 235 3 1 3.0
97 243 236 2 1 2.0
98 249 242 2 1 2.0
99 253 246 3 2 1.5
100 254 247 2 1 2.0
101 255 248 2 1 2.0
102 256 249 2 1 2.0
103 257 250 2 1 2.0
104 262 255 4 1 4.0
105 264 257 2 1 2.0
106 266 259 2 1 2.0
107 267 260 2 1 2.0
108 271 264 2 1 2.0
109 275 268 2 1 2.0
110 508 269 2 1 2.0
111 276 270 4 1 4.0
112 281 275 2 1 2.0
113 284 278 2 1 2.0
114 285 279 2 1 2.0
115 304 298 9 1 9.0
116 305 299 3 1 3.0
117 309 303 4 1 4.0
118 313 307 2 1 2.0
119 316 310 3 1 3.0
120 317 311 4 1 4.0
121 318 312 2 1 2.0
122 320 314 2 1 2.0
123 323 317 3 1 3.0
124 325 319 7 1 7.0
125 326 320 10 1 10.0
126 327 321 2 1 2.0
127 331 325 6 1 6.0
128 336 330 2 1 2.0
129 340 334 3 1 3.0
130 341 335 4 1 4.0
131 343 337 4 1 4.0
132 346 340 4 1 4.0
133 348 342 2 1 2.0
134 359 353 2 1 2.0
135 361 355 6 1 6.0
136 395 389 8 1 8.0
137 397 391 2 1 2.0
138 399 393 3 1 3.0
139 401 395 2 1 2.0
140 405 399 3 1 3.0
141 410 404 3 1 3.0
142 411 405 6 1 6.0
143 431 425 2 1 2.0
144 434 428 2 1 2.0
145 506 429 2 1 2.0
146 436 431 3 1 3.0
147 437 432 2 1 2.0
148 439 434 2 1 2.0
149 442 437 2 1 2.0
150 447 442 2 1 2.0
151 457 452 2 1 2.0
152 459 454 2 1 2.0
153 460 455 2 1 2.0
154 464 459 2 1 2.0
155 470 465 2 1 2.0
156 472 467 2 1 2.0
157 488 483 3 1 3.0
158 495 490 4 1 4.0
159 496 491 4 1 4.0
160 497 492 2 1 2.0
161 499 494 3 1 3.0
162 502 497 2 1 2.0
163 504 499 5 1 5.0
## farmer age
no failed check
## total household members
possible outliers
session_number participant_id q224 q225 q226
1 293 287 4 4 18
## Number of household members who emigrated
possible outliers
session_number participant_id q261
1 25 17 7
2 26 18 8
3 31 23 5
4 79 71 6
5 123 116 6
6 133 126 7
7 188 181 6
8 265 258 5
9 280 274 6
10 297 291 5
11 315 309 5
12 354 348 10
13 385 379 5
## Number of people outside the household employed in the farm
possible outliers
session_number participant_id q28 q27 q55_tot q61
1 36 28 32 4 5.00 onion
2 38 30 40 2 13.00 grain
3 44 36 40 0 12.50 onion
4 49 41 29 6 6.00 onion
5 62 54 90 1 25.00 soft wheat
6 63 55 30 0 5.00 onion
7 122 115 100 0 7.80 soft wheat
8 139 132 60 2 12.40 oat
9 166 159 100 1 9.00 soft wheat
10 168 161 40 2 10.00 soft wheat
11 188 181 40 1 9.00 soft wheat
12 189 182 40 4 11.00 soft wheat
13 190 183 50 0 14.00 grain
14 202 195 40 1 17.00 garlic
15 260 253 60 0 26.00 grain
16 266 259 35 2 5.00 wheat
17 290 284 30 1 2.00 nectarine
18 296 290 30 1 5.00 onion
19 395 389 40 8 7.25 onion
20 403 397 30 0 1.00 wheat
21 412 406 40 0 3.00 onion
22 421 415 30 1 7.00 onion
23 429 423 30 1 4.00 onion
24 431 425 150 2 4.00 onion
25 432 426 40 1 2.00 wheat
26 437 432 40 2 12.00 onion
27 447 442 40 2 1.25 onion
q171_l_fie Losses of Crop N.1 – in the field n %
1 1=Not at all important 97 19.4
2 2=Slightly important 100 20.0
3 3=Somewhat important 138 27.6
4 4=moderately important 95 19.0
5 5=Extremely important 68 13.6
<NA> <NA> 2 0.4
Total - 500 100.0
q171_l_ph Losses of Crop N.1 – post-harvest n %
1 1=Not at all important 120 24.0
2 2=Slightly important 89 17.8
3 3=Somewhat important 100 20.0
4 4=moderately important 95 19.0
5 5=Extremely important 94 18.8
<NA> <NA> 2 0.4
Total - 500 100.0
q172_l_fie Losses of Crop N.2 – in the field n %
1 1=Not at all important 106 24.0909091
2 2=Slightly important 97 22.0454545
3 3=Somewhat important 118 26.8181818
4 4=moderately important 79 17.9545455
5 5=Extremely important 38 8.6363636
<NA> <NA> 2 0.4545455
Total - 440 100.0000000
q172_l_ph Losses of Crop N.2 – post-harvest n %
1 1=Not at all important 117 26.5909091
2 2=Slightly important 95 21.5909091
3 3=Somewhat important 117 26.5909091
4 4=moderately important 65 14.7727273
5 5=Extremely important 44 10.0000000
<NA> <NA> 2 0.4545455
Total - 440 100.0000000
q173_l_fie Losses of Crop N.2 – in the field n %
1 1=Not at all important 92 27.9635258
2 2=Slightly important 81 24.6200608
3 3=Somewhat important 71 21.5805471
4 4=moderately important 59 17.9331307
5 5=Extremely important 25 7.5987842
<NA> <NA> 1 0.3039514
Total - 329 100.0000000
q173_l_ph Losses of Crop N.2 – post-harvest n %
1 1=Not at all important 107 32.5227964
2 2=Slightly important 81 24.6200608
3 3=Somewhat important 66 20.0607903
4 4=moderately important 49 14.8936170
5 5=Extremely important 25 7.5987842
<NA> <NA> 1 0.3039514
Total - 329 100.0000000
q262_1 Location in which household members emigrated. 1= other district in the same region n %
0 0=No 105 78.947368
1 1=Yes 26 19.548872
4 <NA> 2 1.503759
Total - 133 100.000000
q3211 Other n %
4 4=moderately important 1 0.2
5 5=Extremely important 21 4.2
<NA> <NA> 478 95.6
Total - 500 100.0
q3311 Specify the category Other, if reported n %
3 3=Somewhat important 1 0.2
5 5=Extremely important 21 4.2
<NA> <NA> 478 95.6
Total - 500 100.0MO_crop_BeniMellal
crop.1 production x unit size
session_number participant_id q61_size q141_qp q141 q61 q141_qp_u q61_unit prd_unit.size
83 631 0.5 15000 olive olive kg ha 30000
22 566 0.5 14000 olive olive kg ha 28000
192 748 6 120000 broad bean broad bean kg ha 20000
518 776 0.5 10000 olive olive kg HA 20000
28 572 2 30000 olive olive kg ha 15000
196 752 2 30000 olive olive kg ha 15000
60 550 3 40000 olive olive kg ha 13333.
609 867 3 40000 olive olive kg ha 13333.
57 547 0.75 8000 olive olive kg ha 10667.
41 585 0.5 5000 olive olive kg ha 10000
97 645 0.5 5000 olive olive kg ha 10000
158 706 1 10000 olive olive kg ha 10000
194 750 1 10000 wheat wheat kg ha 10000
524 782 4.5 45000 olive olive kg ha 10000
548 806 6 55000 olive olive kg ha 9167.
628 765 2 15000 wheat wheat kg ha 7500
180 736 1 4000 carob carob kg ha 4000
crop.2 production x unit size
session_number participant_id q62_size q142_qp q142 q62 q142_qp_u q62_unit prd_unit.size
534 792 0.5 80000 sugar beet sugar beet kg ha 160000
9 553 3 30000 wheat wheat kg ha 10000
114 662 0.5 5000 wheat wheat kg ha 10000
513 725 1 10000 pea pea kg ha 10000
171 719 1 9000 wheat wheat kg ha 9000
132 680 0.5 4000 wheat wheat kg ha 8000
82 630 2 15000 alfalfa alfalfa kg ha 7500
14 558 0.5 2000 grain grain kg ha 4000
28 572 1 4000 grain grain kg ha 4000
crop.3 production x unit size
session_number participant_id q63_size q143_qp q143 q63 q143_qp_u q63_unit prd_unit.size
195 751 1 20000 olive olive kg ha 20000
534 792 0.5 4000 wheat wheat kg ha 8000
59 549 0.5 3000 bean bean kg ha 6000
561 819 0.5 2000 broad bean broad bean kg ha 4000
## crop 1 different product q61 - q141
no failed check
## crop 1 different product q61 - q171
no failed check
## crop 2 different product q62 - q142
no failed check
## crop 2 different product q62 - q172
no failed check
## crop 3 different product q63 - q143
no failed check
## crop 3 different product q63 - q173
no failed check
## The sum of the sizes for the Tenure status must be less than or equal to the total size
no failed check
## land size of Crop N.1 must be less than or equal to the total size
no failed check
## land size of Crop N.2 must be less than or equal to the total size
no failed check
## land size of Crop N.3 must be less than or equal to the total size
no failed check
## crop 1 quantity sold must be less than or equal to the quantity produced
no failed check
## crop 2 quantity sold must be less than or equal to the quantity produced
no failed check
## crop 3 quantity sold must be less than or equal to the quantity produced
no failed check
## household members aged 14 or older involved in the farm must be less than or equal to the adults 14 or older
failed checks
session_number participant_id q27 q224 q27/q224
1 13 503 2 1 2
2 15 505 2 1 2
3 21 511 2 1 2
4 48 538 8 1 8
5 20 564 3 1 3
6 52 596 2 1 2
7 66 610 2 1 2
8 69 617 2 1 2
9 71 619 3 1 3
10 74 622 3 1 3
11 82 630 2 1 2
12 86 634 2 1 2
13 94 642 3 1 3
14 114 662 3 1 3
15 117 665 2 1 2
16 125 673 2 1 2
17 127 675 3 1 3
18 137 685 3 1 3
19 142 690 2 1 2
20 145 693 2 1 2
21 147 695 2 1 2
22 149 697 4 1 4
23 153 701 4 1 4
24 154 702 2 1 2
25 156 704 4 1 4
26 164 712 2 1 2
27 169 717 2 1 2
28 509 721 2 1 2
29 511 723 3 1 3
30 514 726 2 1 2
31 177 733 3 1 3
32 180 736 2 1 2
33 191 747 5 1 5
34 195 751 3 1 3
35 621 758 2 1 2
36 624 761 6 1 6
37 628 765 3 1 3
38 631 768 2 1 2
39 634 771 2 1 2
40 517 775 2 1 2
41 521 779 2 1 2
42 530 788 2 1 2
43 537 795 5 1 5
44 543 801 2 1 2
45 546 804 2 1 2
46 547 805 2 1 2
47 563 821 2 1 2
48 566 824 2 1 2
49 570 828 2 1 2
50 577 835 2 1 2
51 591 849 2 1 2
52 595 853 2 1 2
53 598 856 5 1 5
54 612 870 3 1 3
55 638 875 3 1 3
56 641 878 3 1 3
57 651 888 2 1 2
58 654 891 2 1 2
59 657 894 2 1 2
60 659 896 2 1 2
## farmer age
no failed check
## total household members
no failed check
## Number of household members who emigrated
possible outliers
session_number participant_id q261
1 22 566 5
2 50 594 5
3 57 601 6
4 82 630 6
5 107 655 7
6 191 747 5
7 548 806 5
8 572 830 5
9 643 880 5
10 652 889 5
11 663 900 5
## Number of people outside the household employed in the farm
possible outliers
session_number participant_id q28 q27 q55_tot q61
1 10 554 30 0 5.00 olive
2 32 576 20 1 4.00 olive
3 62 606 20 1 3.00 olive
4 629 766 20 0 7.00 apple
5 630 767 20 1 11.25 olive
6 544 802 30 0 100.00 wheat
7 557 815 20 1 70.00 carob
8 656 893 20 1 4.00 wheat
q3211 Other n %
<NA> <NA> 400 100
Total - 400 100
q3311 Specify the category Other, if reported n %
<NA> <NA> 400 100
Total - 400 100TN_crop_Jendouba
crop.1 production x unit size
session_number participant_id q61_size q141_qp q141 q61 q141_qp_u q61_unit prd_unit.size
18 18 4 20000 wheat wheat kg ha 5000
10 5 0.5 2200 potato potato kg ha 4400
23 17 1 4200 barley barley kg ha 4200
9 1 0.5 2000 barley barley kg ha 4000
17 19 0.25 1000 fava bean fava bean kg ha 4000
18 20 0.5 2000 oat oat kg ha 4000
12 20 1 3000 oat oat kg ha 3000
crop.2 production x unit size
session_number participant_id q62_size q142_qp q142 q62 q142_qp_u q62_unit prd_unit.size
2 17 0.2 3000 oat (hay) oat (hay) kg ha 15000
17 19 0.25 1200 wheat wheat kg ha 4800
18 11 1 4500 oat oat kg ha 4500
21 16 0.5 2000 barley barley kg ha 4000
10 5 0.5 300 onion onion kg ha 600
crop.3 production x unit size
session_number participant_id q63_size q143_qp q143 q63 q143_qp_u q63_unit prd_unit.size
8 2 1 20000 barley barley kg ha 20000
15 17 1 13000 oat (hay) oat (hay) kg ha 13000
6 17 2 20000 pea pea kg ha 10000
4 12 0.25 2000 oat (hay) oat (hay) kg ha 8000
2 17 0.1 500 fava bean fava bean kg ha 5000
18 17 1 4600 barley barley kg ha 4600
18 10 1 4000 barley barley kg ha 4000
crop.1 price
session_number participant_id q61 q141 q141_price
7 5 wheat wheat 1
14 20 wheat wheat 1
24 16 wheat wheat 1
5 3 wheat wheat 0.56
8 4 watermelon watermelon 0.25
crop.2 price
session_number participant_id q62 q142 q142_price
14 20 fava bean fava bean 1.7
21 12 fava bean fava bean 1.7
18 15 oat oat 1.2
5 8 wheat wheat 0.900
5 1 wheat wheat 0.850
8 12 wheat wheat 0.850
9 1 wheat wheat 0.850
9 5 wheat wheat 0.850
9 19 wheat wheat 0.850
11 3 wheat wheat 0.760
11 10 wheat wheat 0.760
12 15 wheat wheat 0.760
24 15 wheat wheat 0.75
16 3 wheat wheat 0.720
6 1 oat oat 0.700
11 2 wheat wheat 0.700
21 9 wheat wheat 0.700
22 15 wheat wheat 0.700
23 17 wheat wheat 0.600
crop.3 price
session_number participant_id q63 q143 q143_price
8 15 barley barley 1
16 11 oat oat 0.960
4 8 wheat wheat 0.820
8 6 wheat wheat 0.820
9 3 wheat wheat 0.75
16 6 wheat wheat 0.75
9 6 wheat wheat 0.700
15 7 wheat wheat 0.700
## crop 1 different product q61 - q141
no failed check
## crop 1 different product q61 - q171
no failed check
## crop 2 different product q62 - q142
no failed check
## crop 2 different product q62 - q172
no failed check
## crop 3 different product q63 - q143
no failed check
## crop 3 different product q63 - q173
no failed check
## The sum of the sizes for the Tenure status must be less than or equal to the total size
no failed check
## land size of Crop N.1 must be less than or equal to the total size
failed checks
session_number participant_id q61_size q55_tot q61_size/q55_tot
1 1 7 35 1.5 23.33333
## land size of Crop N.2 must be less than or equal to the total size
no failed check
## land size of Crop N.3 must be less than or equal to the total size
no failed check
## crop 1 quantity sold must be less than or equal to the quantity produced
no failed check
## crop 2 quantity sold must be less than or equal to the quantity produced
no failed check
## crop 3 quantity sold must be less than or equal to the quantity produced
no failed check
## household members aged 14 or older involved in the farm must be less than or equal to the adults 14 or older
failed checks
session_number participant_id q27 q224 q27/q224
1 9 6 3 2 1.500000
2 9 19 3 2 1.500000
3 12 4 3 2 1.500000
4 16 13 3 2 1.500000
5 16 16 4 2 2.000000
6 17 19 3 2 1.500000
7 18 5 7 3 2.333333
8 22 12 3 2 1.500000
9 24 14 3 2 1.500000
## farmer age
no failed check
## total household members
no failed check
## Number of household members who emigrated
possible outliers
session_number participant_id q261
1 1 15 5
2 4 19 5
3 5 10 5
4 5 13 7
5 17 9 6
6 22 7 5
## Number of people outside the household employed in the farm
possible outliers
session_number participant_id q28 q27 q55_tot q61
1 1 6 12 2 4.0 wheat
2 1 7 10 3 1.5 pea
3 1 9 10 2 1.7 wheat
4 4 15 10 1 10.0 wheat
5 5 3 10 2 7.0 wheat
6 5 15 7 2 2.0 pepper
7 7 6 28 2 8.0 wheat
8 7 8 5 2 9.0 fava bean
9 7 10 20 1 8.0 watermelon
10 7 16 20 1 10.0 watermelon
11 7 17 8 4 5.0 watermelon
12 8 2 8 3 7.0 wheat
13 8 3 10 2 8.0 wheat
14 8 4 10 2 6.0 watermelon
15 8 5 7 2 10.0 wheat
16 8 6 5 4 3.5 fava bean
17 9 5 7 2 7.0 fava bean
18 10 18 6 1 10.0 wheat
19 17 4 10 2 5.0 oat
20 17 9 5 1 10.0 wheat
21 18 18 10 2 8.0 wheat
22 22 15 5 2 2.5 pea
UG_crop_Kamuli
crop.1 production x unit size
session_number participant_id q61_size q141_qp q141 q61 q141_qp_u q61_unit prd_unit.size
9 373 0.5 14700 cassava cassava kg acre 29400
9 378 0.0413 1140 matooke matooke kg acre 27584.
5 222 0.0276 258 maize maize kg acre 9364.
8 345 2 10000 maize maize kg acre 5000
8 360 2 10000 maize maize kg acre 5000
7 320 2 10000 coffee coffee kg acre 5000
8 335 2 8000 maize maize kg acre 4000
2 53 2 7500 maize maize kg acre 3750
3 121 0.0804 300 bean bean kg acre 3733.
5 205 0.230 700 maize maize kg acre 3049.
2 68 0.115 300 maize maize kg acre 2613.
5 197 0.2 350 bean bean kg acre 1750
crop.2 production x unit size
session_number participant_id q62_size q142_qp q142 q62 q142_qp_u q62_unit prd_unit.size
9 380 0.00230 3000 maize maize kg acre 1306620.
9 400 0.0000115 5 bean bean kg acre 435540.
4 183 0.00230 150 bean bean kg acre 65331.
7 289 0.0115 400 cassava cassava kg acre 34843.
3 98 0.00230 50 bean bean kg acre 21777.
5 206 1 19600 matooke matooke kg acre 19600
8 352 0.00344 54 groundnut groundnut kg acre 15679.
9 378 0.00459 70 maize maize kg acre 15244.
5 222 0.0276 120 bean bean kg acre 4355.
7 295 0.25 1000 bean bean kg acre 4000
5 209 0.5 1200 rice rice kg acre 2400
6 236 3 6000 coffee coffee kg acre 2000
7 294 1 2000 millet millet kg acre 2000
3 139 0.0918 150 bean bean kg acre 1633.
5 205 0.138 200 bean bean kg acre 1452.
4 167 2 2900 bean bean kg acre 1450
1 36 0.5 600 bean bean kg acre 1200
9 375 0.5 500 bean bean kg acre 1000
5 212 0.5 500 bean bean kg acre 1000
crop.3 production x unit size
session_number participant_id q63_size q143_qp q143 q63 q143_qp_u q63_unit prd_unit.size
9 400 0.0000115 20 soybean soybean kg acre 1742160.
9 380 0.00230 600 cassava cassava kg acre 261324.
7 317 0.25 15000 cassava cassava kg acre 60000
4 183 0.00230 85 soybean soybean kg acre 37021.
5 202 0.5 15200 matooke matooke kg acre 30400
1 36 0.115 2660 matooke matooke kg acre 23171.
1 4 0.0689 1540 matooke matooke kg acre 22358.
1 16 0.0276 480 maize maize kg acre 17422.
5 222 0.0367 640 cassava cassava kg acre 17422.
1 24 0.0184 320 sweet potato sweet potato kg acre 17422.
3 124 0.5 4800 sweet potato sweet potato kg acre 9600
5 193 0.5 4500 cassava cassava kg acre 9000
9 378 0.00459 25 bean bean kg acre 5444.
9 373 1 4000 rice rice kg acre 4000
8 326 0.25 384 bean bean kg acre 1536
crop.1 price
session_number participant_id q61 q141 q141_price
4 156 maize maize 1000
4 147 maize maize 1000
5 206 maize maize 800
6 263 maize maize 750
1 14 maize maize 700
1 18 maize maize 700
3 123 maize maize 700
7 282 maize maize 700
8 355 maize maize 700
9 400 maize maize 700
# ... with 24 more rows
crop.2 price
session_number participant_id q62 q142 q142_price
9 387 maize maize 3333
9 386 tomatoes tomatoes 2666
4 143 maize maize 2500
## crop 1 different product q61 - q141
no failed check
## crop 1 different product q61 - q171
no failed check
## crop 2 different product q62 - q142
no failed check
## crop 2 different product q62 - q172
no failed check
## crop 3 different product q63 - q143
no failed check
## crop 3 different product q63 - q173
no failed check
## The sum of the sizes for the Tenure status must be less than or equal to the total size
no failed check
## land size of Crop N.1 must be less than or equal to the total size
failed checks
session_number participant_id q61_size q55_tot q61_size/q55_tot
1 3 99 0.75 0.5 1.5
2 2 59 2.00 1.0 2.0
3 9 394 2.00 0.5 4.0
4 5 226 12.00 2.0 6.0
## land size of Crop N.2 must be less than or equal to the total size
failed checks
session_number participant_id q62_size q55_tot q62_size/q55_tot
1 3 99 0.75 0.5 1.5
2 7 280 5.00 2.0 2.5
3 9 394 2.00 0.5 4.0
## land size of Crop N.3 must be less than or equal to the total size
failed checks
session_number participant_id q63_size q55_tot q63_size/q55_tot
1 9 394 1 0.5 2.000000
2 7 295 4 1.1 3.636364
## crop 1 quantity sold must be less than or equal to the quantity produced
no failed check
## crop 2 quantity sold must be less than or equal to the quantity produced
no failed check
## crop 3 quantity sold must be less than or equal to the quantity produced
no failed check
## household members aged 14 or older involved in the farm must be less than or equal to the adults 14 or older
failed checks
session_number participant_id q27 q224 q27/q224
1 6 248 4 2 2.000000
2 4 162 6 4 1.500000
3 3 121 3 2 1.500000
4 3 122 9 4 2.250000
5 3 136 8 6 1.333333
6 7 279 4 2 2.000000
7 6 256 3 1 3.000000
8 6 262 4 2 2.000000
9 8 336 6 4 1.500000
10 8 340 4 3 1.333333
11 9 384 4 2 2.000000
12 9 386 3 2 1.500000
13 9 397 6 3 2.000000
14 5 207 4 1 4.000000
15 8 329 3 1 3.000000
## farmer age
no failed check
## total household members
no failed check
## Number of household members who emigrated
no failed check
## Number of people outside the household employed in the farm
possible outliers
session_number participant_id q28 q27 q55_tot q61
1 5 201 15 2 12 sweet potato
q3211 Other n %
1 1=Not at all important 1 0.25
5 5=Extremely important 6 1.50
<NA> <NA> 393 98.25
Total - 400 100.00
q3311 Specify the category Other, if reported n %
5 5=Extremely important 1 0.25
<NA> <NA> 399 99.75
Total - 400 100.00UG_crop_Nakaseke
crop.1 production x unit size
session_number participant_id q61_size q141_qp q141 q61 q141_qp_u q61_unit prd_unit.size
2 489 0.0138 400 eggplant eggplant kg acre 29036.
3 653 4 65000 maize maize kg acre 16250
2 577 40 600000 maize maize kg acre 15000
1 428 1 15000 maize maize kg acre 15000
2 533 1 12920 matooke matooke kg acre 12920
4 711 1.5 10000 coffee coffee kg acre 6667.
2 546 17 70000 maize maize kg acre 4118.
6 790 1 4000 rice rice kg acre 4000
2 570 2 6250 maize maize kg acre 3125
3 666 1 3000 bean bean kg acre 3000
2 476 1 2200 coffee coffee kg acre 2200
3 477 0.115 240 coffee coffee kg acre 2091.
crop.2 production x unit size
session_number participant_id q62_size q142_qp q142 q62 q142_qp_u q62_unit prd_unit.size
2 489 0.00459 1600 aubergine aubergine kg acre 348432.
1 479 0.25 14400 tomato tomato kg acre 57600
1 401 0.007 300 bean bean kg acre 42857.
3 500 0.0248 600 maize maize kg acre 24197.
3 477 0.0689 1600 sweet potato sweet potato kg acre 23229.
6 771 1 19000 matooke matooke kg acre 19000
6 768 0.5 7644 matooke matooke kg acre 15288
3 616 1 7000 coffee coffee kg acre 7000
1 486 0.25 1500 maize maize kg acre 6000
5 722 1 6000 bean bean kg acre 6000
1 420 0.5 2500 bean bean kg acre 5000
1 437 0.5 1500 bean bean kg acre 3000
4 681 1 3000 coffee coffee kg acre 3000
2 546 10 24000 bean bean kg acre 2400
4 692 0.25 600 bean bean kg acre 2400
3 618 0.5 1000 bean bean kg acre 2000
2 574 0.125 200 nakati nakati kg acre 1600
1 425 0.25 180 bbuga bbuga kg acre 720
crop.3 production x unit size
session_number participant_id q63_size q143_qp q143 q63 q143_qp_u q63_unit prd_unit.size
3 477 0.0459 2800 matooke matooke kg acre 60976.
1 437 0.5 15360 eggplant eggplant kg acre 30720
4 692 0.25 7500 maize maize kg acre 30000
3 612 0.5 9600 eggplant eggplant kg acre 19200
1 401 0.002 28 soybean soybean kg acre 14000
3 557 0.0230 150 cassava cassava kg acre 6533.
3 595 0.25 1500 cassava cassava kg acre 6000
3 502 1 2000 bean bean kg acre 2000
1 417 0.25 500 bean bean kg acre 2000
crop.1 price
session_number participant_id q61 q141 q141_price
5 728 matooke matooke 6500
5 732 sweet potato sweet potato 5000
6 778 matooke matooke 5000
4 694 coffee coffee 4500
3 633 coffee coffee 3000
1 404 coffee coffee 3000
3 627 coffee coffee 2700
4 701 cabbage cabbage 2273
1 435 green pepper green pepper 2143
2 535 aubergine aubergine 1875
# ... with 12 more rows
crop.2 price
session_number participant_id q62 q142 q142_price
4 684 coffee coffee 4000
1 450 coffee coffee 3000
1 417 coffee coffee 3000
3 508 maize maize 1300
2 495 aubergine aubergine 1125
2 506 coffee coffee 700
1 430 maize maize 0
1 435 maize maize 0
5 725 maize maize 0
6 797 maize maize 0
6 790 maize maize 0
4 701 coffee coffee 0
4 704 coffee coffee 0
4 707 maize maize 0
4 681 coffee coffee 0
4 688 matooke matooke 0
crop.3 price
session_number participant_id q63 q143 q143_price
5 765 matooke matooke 5000
4 685 coffee coffee 3800
4 690 coffee coffee 3300
2 501 coffee coffee 3000
1 433 coffee coffee 3000
1 469 coffee coffee 3000
5 746 cabbage cabbage 1818
4 713 maize maize 1800
1 432 nakati nakati 1667
6 793 maize maize 1200
# ... with 12 more rows
## crop 1 different product q61 - q141
no failed check
## crop 1 different product q61 - q171
no failed check
## crop 2 different product q62 - q142
no failed check
## crop 2 different product q62 - q172
no failed check
## crop 3 different product q63 - q143
no failed check
## crop 3 different product q63 - q173
no failed check
## The sum of the sizes for the Tenure status must be less than or equal to the total size
no failed check
## land size of Crop N.1 must be less than or equal to the total size
failed checks
session_number participant_id q61_size q55_tot q61_size/q55_tot
1 3 641 5.500 5.000 1.100000
2 2 524 3.000 1.000 3.000000
3 2 489 0.014 0.011 1.272727
## land size of Crop N.2 must be less than or equal to the total size
no failed check
## land size of Crop N.3 must be less than or equal to the total size
failed checks
session_number participant_id q63_size q55_tot q63_size/q55_tot
1 1 450 7.5 3 2.5
## crop 1 quantity sold must be less than or equal to the quantity produced
failed checks
session_number participant_id q141_qs q141_qp q141 q141_qs/q141_qp
1 1 461 640 560 aubergine 1.142857
2 1 468 5400 4500 tomato 1.200000
3 4 690 800 320 sweet potato 2.500000
## crop 2 quantity sold must be less than or equal to the quantity produced
failed checks
session_number participant_id q142_qs q142_qp q142 q142_qs/q142_qp
1 2 473 1800 800 coffee 2.250000
2 1 423 4800 690 sweet potato 6.956522
## crop 3 quantity sold must be less than or equal to the quantity produced
failed checks
session_number participant_id q143_qs q143_qp q143 q143_qs/q143_qp
1 3 485 560 400 eggplant 1.4
## household members aged 14 or older involved in the farm must be less than or equal to the adults 14 or older
no failed check
## farmer age
no failed check
## total household members
possible outliers
session_number participant_id q224 q225 q226
1 3 502 9 13 3
2 1 448 16 5 3
3 5 746 19 7 3
## Number of household members who emigrated
possible outliers
session_number participant_id q261
1 1 402 6
2 1 443 6
3 2 523 6
4 3 658 8
5 2 533 7
6 5 765 5
7 5 766 6
8 6 789 6
## Number of people outside the household employed in the farm
possible outliers
session_number participant_id q28 q27 q55_tot q61
1 2 546 15 2 30 maize
2 2 577 23 2 47 maize
3 3 591 11 3 20 green pepper
4 2 544 20 2 100 rice
q3211 Other n %
1 1=Not at all important 1 0.25
2 2=Slightly important 1 0.25
3 3=Somewhat important 1 0.25
4 4=moderately important 4 1.00
5 5=Extremely important 24 6.00
<NA> <NA> 369 92.25
Total - 400 100.00
q3311 Specify the category Other, if reported n %
2 2=Slightly important 1 0.25
4 4=moderately important 4 1.00
5 5=Extremely important 9 2.25
<NA> <NA> 386 96.50
Total - 400 100.00