Crop_aggregate
[UID:PLLNT11.CRPGG73.0]
Downloads
About
This table contains data on single crops as well as different processing stages of these crops traded on the world market obtained from FAOSTAT and scientific data on the impact of animal pollination on crop protection provided by Klein and co-workers (2007).
Contributors
Metadata
Column Metadata
Column Description | Datatype | Descriptor | ||
---|---|---|---|---|
CropId
|
Identifier of the crop.
|
Integer |
%
|
|
FaoItemCode
|
FAO Item Code of the crop.
|
String |
Default unit
|
|
Id
|
Identifier of the record.
|
String |
Default unit
|
|
ParentCropId
|
Crop aggregate to which the crop belongs to.
|
String |
Default unit
|
|
SourceId
|
Reference to the data source.
|
Integer |
Default unit
|
Descriptive Measures
Column profiling
Range | Mean | Minimum | Q1 | Median | Q3 | Maximum | Total | Missing | Zero | Blank | Distinct | Outliers | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CropId
|
1 - 3
|
93.3
|
1
|
52.0
|
95.0
|
131.0
|
194
|
312
|
0 (0.0%)
|
0 (0.0%)
|
0 (0.0%)
|
194 (62.2%)
|
152 (48.7%)
|
FaoItemCode
|
2 - 4
|
n/a
|
89
|
n/a
|
n/a
|
n/a
|
NULL
|
312
|
0 (0.0%)
|
0 (0.0%)
|
0 (0.0%)
|
178 (57.1%)
|
n/a
|
Id
|
1 - 3
|
156.5
|
1
|
78.3
|
156.5
|
234.8
|
312
|
312
|
0 (0.0%)
|
0 (0.0%)
|
0 (0.0%)
|
312 (100.0%)
|
156 (50.0%)
|
ParentCropId
|
1 - 4
|
n/a
|
1
|
n/a
|
n/a
|
n/a
|
NULL
|
312
|
0 (0.0%)
|
0 (0.0%)
|
0 (0.0%)
|
36 (11.5%)
|
n/a
|
SourceId
|
1 - 1
|
1.1
|
1
|
1.0
|
1.0
|
1.0
|
2
|
312
|
0 (0.0%)
|
0 (0.0%)
|
0 (0.0%)
|
2 (0.6%)
|
40 (12.8%)
|
Quality Measures
Data quality measures
Completeness | Uniqueness | Most Common Value | Least Common Value | |
---|---|---|---|---|
CropId
|
100.00%
|
62.18%
|
96
|
1
|
FaoItemCode
|
100.00%
|
57.05%
|
NULL
|
711
|
Id
|
100.00%
|
100.00%
|
1
|
1
|
ParentCropId
|
100.00%
|
11.54%
|
NULL
|
189
|
SourceId
|
100.00%
|
0.64%
|
1
|
2
|
Profiling Charts
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Data Distribution Top 20
Data Distribution Bottom 20
Outliers
No data available.
Completeness
Uniqueness
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Data Distribution Top 20
Data Distribution Bottom 20
Outliers
No data available.
Completeness
Uniqueness
Data Distribution Top 20
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Data
Data samples
Id Text |
CropId Integer |
FaoItemCode Text |
ParentCropId Text |
SourceId Integer |
---|---|---|---|---|
1
|
1
|
711
|
NULL
|
1
|
2
|
2
|
NULL
|
1
|
1
|
3
|
3
|
NULL
|
1
|
1
|
4
|
4
|
NULL
|
1
|
1
|
5
|
5
|
NULL
|
1
|
1
|
6
|
6
|
515
|
NULL
|
1
|
7
|
7
|
526
|
NULL
|
1
|
8
|
8
|
572
|
NULL
|
1
|
9
|
9
|
176
|
NULL
|
1
|
10
|
10
|
NULL
|
9
|
1
|
11
|
11
|
NULL
|
9
|
1
|
12
|
12
|
NULL
|
9
|
1
|
13
|
13
|
NULL
|
9
|
1
|
14
|
14
|
NULL
|
9
|
1
|
15
|
15
|
NULL
|
9
|
1
|
16
|
16
|
NULL
|
9
|
1
|
17
|
17
|
NULL
|
9
|
1
|
18
|
18
|
NULL
|
9
|
1
|
19
|
19
|
552
|
NULL
|
1
|
20
|
20
|
NULL
|
19
|
1
|
21
|
21
|
NULL
|
19
|
2
|
22
|
22
|
NULL
|
19
|
2
|
23
|
23
|
NULL
|
19
|
1
|
24
|
24
|
181
|
NULL
|
1
|
Properties
Dataset
Unique Identifier
[PLLNT11.CRPGG73.0]
URI
https://app.pollinatorhub.eu/dataset-discovery/parts/PLLNT11.CRPGG73.0
Table Type
File
Licence in
EU Pollinator Hub
Columns
5
Rows
312
Data points
1,560
Published
2023-07-26
Metrics
Total views
41
Total downloads
0