Insect_Plant
[UID:PLLNT11.NSCTP75.0]
This table contains data on documented faunistic observations of insect species on plant species, mainly crops, obtained from literature references and images from a photographer. The information on the Global Biodiversity Information Facility (GBIF) was used as taxonomic reference for all species referred to in this table.
Download
-
Licence
This file contains dataset licencing information.
Properties
Dataset
Unique Identifier
[PLLNT11.NSCTP75.0]
URI
https://app.pollinatorhub.eu/dataset-discovery/parts/PLLNT11.NSCTP75.0
Columns
21
Rows
0
Data points
0
Data providers
Data profiling
| Column description | Data type | Descriptor | ||
|---|---|---|---|---|
|
Id
|
Identifier of the record.
|
n/a
|
n/a
|
Default unit
|
|
InsectValidName
|
Valid scientific name of the insect.
|
n/a
|
n/a
|
Default unit
|
|
InsectGbif
|
GBIF identifier of the insect, accessible at https://www.gbif.org/species/[InsectGbif].
|
n/a
|
n/a
|
Default unit
|
|
IInsectSynonymName
|
Synonym of the scientific name of the insect used in the indicated source.
|
n/a
|
n/a
|
Default unit
|
|
PlantValidName
|
Valid scientific name of the plant the insect has been observed on.
|
n/a
|
n/a
|
Default unit
|
|
PlantGbif
|
GBIF identifier of the plant, accessible at https://www.gbif.org/species/[PlantGbif].
|
n/a
|
n/a
|
Default unit
|
|
PlantSynonymName
|
Synonym of the scientific name of the plant used in the indicated source.
|
n/a
|
n/a
|
Default unit
|
|
Country
|
Two-letter country code as defined in ISO 3166-1 in which the observation is reported.
|
n/a
|
n/a
|
Default unit
|
|
Nuts
|
NUTS area in which the observation is reported.
|
n/a
|
n/a
|
Default unit
|
|
Zip
|
Postcodes for the location in which the observation is reported.
|
n/a
|
n/a
|
Default unit
|
|
PlaceName
|
Name of the place in local language in which the observation is reported.
|
n/a
|
n/a
|
Default unit
|
|
Lau
|
LAU code of in which the observation is reported.
|
n/a
|
n/a
|
Default unit
|
|
WGS84_N
|
Latitude in WGS84 format of the position on which the observation is reported.
|
n/a
|
n/a
|
Default unit
|
|
WGS84_E
|
Longitude in WGS84 format of the position on which the observation is reported.
|
n/a
|
n/a
|
Default unit
|
|
Elevation
|
Elevation of the location in which the observation is reported.
|
n/a
|
n/a
|
Default unit
|
|
DateFrom
|
Start date at which the observation is reported.
|
n/a
|
n/a
|
Default unit
|
|
DateTo
|
End date at which the observation is reported.
|
n/a
|
n/a
|
Default unit
|
|
TimeFrom
|
First time of the day at which the observation is reported.
|
n/a
|
n/a
|
Default unit
|
|
TimeTo
|
First time of the day at which the observation is reported.
|
n/a
|
n/a
|
Default unit
|
|
SourceId
|
Reference to the data source.
|
n/a
|
n/a
|
Default unit
|
|
ImageId
|
Reference to an image source.
|
n/a
|
n/a
|
Default unit
|
| Length | Mean | Minimum | Q1 | Median | Q3 | Maximum | Total | Missing | Zero | Blank | Distinct | Outliers | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Id
|
n/a
|
712.5
|
1
|
n/a
|
n/a
|
n/a
|
1,424
|
1,424
|
0
|
0
|
0
|
1,424
|
n/a
|
|
InsectValidName
|
n/a
|
0.0
|
Adalia bipunctata
|
n/a
|
n/a
|
n/a
|
Xylocopa violacea
|
1,424
|
0
|
0
|
0
|
269
|
n/a
|
|
InsectGbif
|
n/a
|
1,824,858.2
|
1,043,097
|
n/a
|
n/a
|
n/a
|
9,805,254
|
1,424
|
0
|
0
|
0
|
265
|
n/a
|
|
IInsectSynonymName
|
n/a
|
0.0
|
Andrena carbonaria
|
n/a
|
n/a
|
n/a
|
Tipula hortulana
|
1,424
|
1,334
|
0
|
0
|
21
|
n/a
|
|
PlantValidName
|
n/a
|
0.0
|
Acer platanoides
|
n/a
|
n/a
|
n/a
|
Vitis vinifera
|
1,424
|
0
|
0
|
0
|
264
|
n/a
|
|
PlantGbif
|
n/a
|
4,772,458.8
|
2,773,448
|
n/a
|
n/a
|
n/a
|
9,485,490
|
1,424
|
0
|
0
|
0
|
252
|
n/a
|
|
PlantSynonymName
|
n/a
|
0.0
|
n/a
|
n/a
|
n/a
|
n/a
|
n/a
|
1,424
|
1,424
|
0
|
0
|
1
|
n/a
|
|
Country
|
n/a
|
0.0
|
n/a
|
n/a
|
n/a
|
n/a
|
IT
|
1,424
|
73
|
0
|
16
|
4
|
n/a
|
|
Nuts
|
n/a
|
0.0
|
n/a
|
n/a
|
n/a
|
n/a
|
ITC18
|
1,424
|
48
|
0
|
45
|
15
|
n/a
|
|
Zip
|
n/a
|
1,131.2
|
0
|
n/a
|
n/a
|
n/a
|
77,743
|
1,424
|
1,317
|
1,317
|
0
|
25
|
n/a
|
|
PlaceName
|
n/a
|
0.0
|
Absam
|
n/a
|
n/a
|
n/a
|
Zirl
|
1,424
|
1,317
|
0
|
0
|
25
|
n/a
|
|
Lau
|
n/a
|
68,174.2
|
0
|
n/a
|
n/a
|
n/a
|
8,317,151
|
1,424
|
1,317
|
1,317
|
0
|
25
|
n/a
|
|
WGS84_N
|
n/a
|
1.4
|
0
|
n/a
|
n/a
|
n/a
|
48
|
1,424
|
1,382
|
1,382
|
0
|
4
|
n/a
|
|
WGS84_E
|
n/a
|
0.3
|
0
|
n/a
|
n/a
|
n/a
|
15
|
1,424
|
1,382
|
1,382
|
0
|
4
|
n/a
|
|
Elevation
|
n/a
|
29.9
|
0
|
n/a
|
n/a
|
n/a
|
2,250
|
1,424
|
1,356
|
1,356
|
0
|
22
|
n/a
|
|
DateFrom
|
n/a
|
0.0
|
01.04.65
|
n/a
|
n/a
|
n/a
|
May 1877
|
1,424
|
1,315
|
0
|
0
|
37
|
n/a
|
|
DateTo
|
n/a
|
0.0
|
01.04.65
|
n/a
|
n/a
|
n/a
|
September 2011
|
1,424
|
1,315
|
0
|
0
|
37
|
n/a
|
|
TimeFrom
|
n/a
|
0.0
|
10:00
|
n/a
|
n/a
|
n/a
|
sunrise (app. 05:45)
|
1,424
|
1,377
|
0
|
0
|
14
|
n/a
|
|
TimeTo
|
n/a
|
0.0
|
12:00
|
n/a
|
n/a
|
n/a
|
sunset (app. 20:30)
|
1,424
|
1,377
|
0
|
0
|
14
|
n/a
|
|
SourceId
|
n/a
|
35.6
|
0
|
n/a
|
n/a
|
n/a
|
188
|
1,424
|
13
|
13
|
0
|
38
|
n/a
|
|
ImageId
|
n/a
|
0.1
|
0
|
n/a
|
n/a
|
n/a
|
13
|
1,424
|
1,411
|
1,411
|
0
|
14
|
n/a
|
| Id | InsectValidName | InsectGbif | IInsectSynonymName | PlantValidName | PlantGbif | PlantSynonymName | Country | Nuts | Zip | PlaceName | Lau | WGS84_N | WGS84_E | Elevation | DateFrom | DateTo | TimeFrom | TimeTo | SourceId | ImageId |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1
|
Adalia bipunctata
|
1043097
|
Anthophora quadrifasciata
|
Malus domestica
|
3001244
|
|
AT
|
AT332
|
6065
|
Thaur
|
70358
|
47.29676385610731
|
11.484982603518578
|
640
|
25.04.77
|
11.05.77
|
sunrise (app. 05:45)
|
sunset (app. 20:30)
|
34
|
1
|
|
2
|
Adalia decempunctata
|
4452227
|
Anthophora quadrifasciata
|
Malus domestica
|
3001244
|
|
AT
|
AT332
|
6065
|
Thaur
|
70358
|
47.29676385610731
|
11.484982603518578
|
640
|
25.04.77
|
11.05.77
|
sunrise (app. 05:45)
|
sunset (app. 20:30)
|
34
|
2
|
|
3
|
Amegilla quadrifasciata
|
1340000
|
Anthophora quadrifasciata
|
Anchusa officinalis
|
5341201
|
|
DE
|
DE1
|
6020
|
Innsbruck
|
70107
|
47.29676385610731
|
11.484982603518578
|
605
|
June 1877
|
June 1877
|
sunrise (app. 05:45)
|
sunset (app. 20:30)
|
38
|
3
|
|
4
|
Amegilla quadrifasciata
|
1340000
|
Anthophora quadrifasciata
|
Ballota nigra
|
2926894
|
|
DE
|
DE1
|
6020
|
Innsbruck
|
70107
|
47.29676385610731
|
11.484982603518578
|
605
|
June 1877
|
June 1877
|
sunrise (app. 05:45)
|
sunset (app. 20:30)
|
38
|
4
|
|
5
|
Amegilla quadrifasciata
|
1340000
|
Anthophora quadrifasciata
|
Centaurea paniculata
|
3127613
|
|
DE
|
DE1
|
6020
|
Innsbruck
|
70107
|
47.29676385610731
|
11.484982603518578
|
605
|
May 1877
|
May 1877
|
sunrise (app. 05:45)
|
sunset (app. 20:30)
|
38
|
5
|
|
6
|
Amegilla quadrifasciata
|
1340000
|
Anthophora quadrifasciata
|
Cirsium vulgare
|
3112801
|
|
DE
|
DE1
|
6020
|
Innsbruck
|
70107
|
47.29676385610731
|
11.484982603518578
|
640
|
05.04.49
|
05.04.49
|
sunrise (app. 05:45)
|
sunset (app. 20:30)
|
38
|
6
|
|
7
|
Amegilla quadrifasciata
|
1340000
|
Anthophora quadrifasciata
|
Echium vulgare
|
2925892
|
|
DE
|
DE1
|
6170
|
Zirl
|
70369
|
47.29676385610731
|
11.484982603518578
|
600
|
01.04.65
|
01.04.65
|
sunrise (app. 05:45)
|
sunset (app. 20:30)
|
38
|
7
|
|
8
|
Amegilla quadrifasciata
|
1340000
|
Andrena ratisbonensis
|
Ononis spinosa
|
2977149
|
|
DE
|
DE1
|
6215
|
Achental
|
70901
|
47.29676385610731
|
11.484982603518578
|
640
|
June 1877
|
June 1877
|
sunrise (app. 05:45)
|
sunset (app. 20:30)
|
38
|
8
|
|
9
|
Amegilla quadrifasciata
|
1340000
|
Andrena ratisbonensis
|
Vicia cracca
|
2975287
|
|
DE
|
DE1
|
6543
|
Nauders
|
70615
|
47.29676385610731
|
11.484982603518578
|
640
|
June 1877
|
June 1877
|
sunrise (app. 05:45)
|
sunset (app. 20:30)
|
38
|
9
|
|
10
|
Ammobates punctatus
|
5039552
|
Andrena ratisbonensis
|
Echium vulgare
|
2925892
|
|
DE
|
DE1
|
6170
|
Zirl
|
70369
|
47.29676385610731
|
11.484982603518578
|
640
|
18.04.53
|
18.04.53
|
sunrise (app. 05:45)
|
sunset (app. 20:30)
|
38
|
10
|
|
11
|
Ammobates punctatus
|
5039552
|
Andrena jacobi
|
Jasione montana
|
8366345
|
|
DE
|
DE1
|
6065
|
Thaur
|
70358
|
48.45385
|
7.81893
|
640
|
25.04.77
|
11.05.77
|
10:00
|
17:00
|
38
|
11
|
|
12
|
Ammobates punctatus
|
5039552
|
Andrena jacobi
|
Scabiosa columbaria
|
2888802
|
|
DE
|
DE1
|
6060
|
Hall
|
70354
|
47.159483
|
15.364551
|
640
|
June 1877
|
June 1877
|
10:00
|
17:00
|
38
|
12
|
|
13
|
Ammobates punctatus
|
5039552
|
Andrena jacobi
|
Thymus serpyllum
|
6409622
|
|
DE
|
DE1
|
6020
|
Innsbruck
|
70107
|
46.663673
|
15.534542
|
2250
|
19.03.22
|
11.04.22
|
10:00
|
17:00
|
38
|
13
|
|
14
|
Ammobates punctatus
|
5039552
|
Andrena jacobi
|
Trifolium arvense
|
5359246
|
|
DE
|
DE1
|
6020
|
Innsbruck
|
70107
|
47.149837
|
15.378202
|
2250
|
Juli 1877
|
Juli 1877
|
9:45
|
9:45
|
38
|
|
|
15
|
Andrena aberrans
|
1357730
|
Andrena jacobi
|
Chamaecytisus podolicus
|
5354619
|
|
DE
|
DE1
|
6370
|
Kitzb?hel
|
70411
|
47.04638
|
15.386947
|
2100
|
August 1877
|
August 1877
|
12:30
|
12:30
|
38
|
|
|
16
|
Andrena aberrans
|
1357730
|
Andrena jacobi
|
Chamaecytisus ratisbonensis
|
5354685
|
|
DE
|
DE1
|
6330
|
Kufstein
|
70513
|
46.7359
|
15.866698
|
1900
|
August 1877
|
August 1877
|
14:45
|
14:45
|
38
|
|
|
17
|
Andrena aberrans
|
1357730
|
Andrena jacobi
|
Chamaecytisus ruthenicus
|
5354537
|
|
DE
|
DE1
|
6020
|
Innsbruck
|
70107
|
47.031658
|
15.414465
|
1900
|
June 1877
|
June 1877
|
14:45
|
14:45
|
38
|
|
|
18
|
Andrena agilissima
|
1356870
|
Andrena jacobi
|
Brassica napus
|
3042636
|
|
DE
|
DE1
|
6170
|
Zirl
|
70369
|
47.091125
|
15.349322
|
1900
|
June 1877
|
June 1877
|
12:00
|
12:00
|
38
|
|
|
19
|
Andrena agilissima
|
1356870
|
Andrena jacobi
|
Brassica rapa
|
7903057
|
|
DE
|
DE1
|
6065
|
Thaur
|
70358
|
47.045474
|
15.382475
|
640
|
25.04.77
|
11.05.77
|
14:30
|
14:30
|
38
|
|
|
20
|
Andrena agilissima
|
1356870
|
Andrena jacobi
|
Sinaps arvensis
|
3047598
|
|
DE
|
DE1
|
6020
|
Innsbruck
|
70107
|
47.128207
|
15.714627
|
640
|
27.03.48
|
27.03.48
|
13:00
|
13:00
|
38
|
|
|
21
|
Andrena agilissima
|
1356870
|
Andrena jacobi
|
Barbarea vulgaris
|
5708780
|
|
DE
|
DE1
|
6020
|
Innsbruck
|
70107
|
47.127677
|
15.713933
|
144
|
14.04.49
|
14.04.49
|
16:30
|
16:30
|
38
|
|
|
22
|
Andrena agilissima
|
1356870
|
Andrena jacobi
|
Raphanus raphanistrum
|
3040983
|
|
DE
|
DE1
|
6020
|
Innsbruck
|
70107
|
47.123133
|
15.388818
|
650
|
March 1877
|
March 1877
|
15:15
|
15:15
|
38
|
|
|
23
|
Andrena alfkenella
|
1357170
|
Andrena jacobi
|
Brassica napus
|
3042636
|
|
DE
|
DE1
|
6065
|
Thaur
|
70358
|
47.091125
|
15.349322
|
650
|
25.04.77
|
11.05.77
|
15:00
|
15:00
|
38
|
|
|
24
|
Andrena alfkenella
|
1357170
|
Andrena jacobi
|
Brassica rapa
|
7903057
|
|
DE
|
DE1
|
6020
|
Innsbruck
|
70107
|
47.045662
|
15.383363
|
350
|
05.04.49
|
05.04.49
|
16:30
|
17:00
|
38
|
|
- Id
- InsectValidName
- InsectGbif
- IInsectSynonymName
- PlantValidName
- PlantGbif
- PlantSynonymName
- Country
- Nuts
- Zip
- PlaceName
- Lau
- WGS84_N
- WGS84_E
- Elevation
- DateFrom
- DateTo
- TimeFrom
- TimeTo
- SourceId
- ImageId
Outliers
Data unavailable
Completeness
Uniqueness
Outliers
Data unavailable
Completeness
Uniqueness
Outliers
Data unavailable
Completeness
Uniqueness
Outliers
Data unavailable
Completeness
Uniqueness
Outliers
Data unavailable
Completeness
Uniqueness
Outliers
Data unavailable
Completeness
Uniqueness
Outliers
Data unavailable
Completeness
Uniqueness
Outliers
Data unavailable
Completeness
Uniqueness
Outliers
Data unavailable
Completeness
Uniqueness
Outliers
Data unavailable
Completeness
Uniqueness
Outliers
Data unavailable
Completeness
Uniqueness
Outliers
Data unavailable
Completeness
Uniqueness
Outliers
Data unavailable
Completeness
Uniqueness
Outliers
Data unavailable
Completeness
Uniqueness
Outliers
Data unavailable
Completeness
Uniqueness
Outliers
Data unavailable
Completeness
Uniqueness
Outliers
Data unavailable
Completeness
Uniqueness
Outliers
Data unavailable
Completeness
Uniqueness
Outliers
Data unavailable
Completeness
Uniqueness
Outliers
Data unavailable
Completeness
Uniqueness
Outliers
Data unavailable