Vetcase
[UID:VTCSS14.VTCSE33.0]
Data in this table was was merged from tables vetcaseat and vetcasebe.
Download
Properties
Dataset
Unique Identifier
[VTCSS14.VTCSE33.0]
URI
https://app.pollinatorhub.eu/dataset-discovery/parts/VTCSS14.VTCSE33.0
Columns
16
Rows
597
Data points
9,552
Data providers
Data profiling
Column description | Data type | Descriptor | ||
---|---|---|---|---|
id
|
Identifier of the record.
|
String |
Default unit
|
|
year
|
Reporting period (calendar year).
|
Integer |
year
|
|
month
|
Reporting period (calendar month).
|
Integer |
Default unit
|
|
casenumber
|
Case number adopted by BMSGPK.
|
String |
Default unit
|
|
disease
|
Name of the disease
|
String |
Default unit
|
|
animalspecies
|
The GBIF Taxon ID of the animal species concerned by the notified outbreak. It is the number following the URL [https://www.gbif.org/species/](https://www.gbif.org/species/), which points to a taxonomic rank.
|
Integer |
Default unit
|
|
datestart
|
Date of establishment of a quarantine area. Official start of outbreak.
|
Date |
Default unit
|
|
dateend
|
Date of lifting of a quarantine area. Official end of outbreak.
|
Date |
Default unit
|
|
country
|
ISO 3166-1 alpha-3 code of the country in which the notified outbreak occurred.
|
String |
Default unit
|
|
nuts
|
Nuts code of the geographic entity in which the notified outbreak occurred.
|
String |
Default unit
|
|
districtcode
|
Official code of the municipality (*Gemeindekennziffer*) in which the notified outbreak occurred.
|
Integer |
Default unit
|
|
postcode
|
Postcode of the location in which the notified outbreak occurred.
|
String |
Default unit
|
|
unit
|
Unit in which the value is reported.
|
String |
Default unit
|
|
value
|
Number of notified outbreaks (on an apiary basis) per district (Politischer Bezirk) or postcode or NUTS region (if district or postcode is NULL) and month or year (if month is NULL).
|
Integer |
no.
|
|
annotation
|
Detailed annotation to the value.
|
String |
Default unit
|
|
sourceid
|
Reference to the data source.
|
Integer |
Default unit
|
Length | Mean | Minimum | Q1 | Median | Q3 | Maximum | Total | Missing | Zero | Blank | Distinct | Outliers | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
id
|
1 - 3
|
299.0
|
1
|
149.5
|
299.0
|
448.5
|
597
|
597
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
597 (100.0 %)
|
298 (49.9 %)
|
year
|
4 - 4
|
2,017.4
|
2,006
|
2,016.0
|
2,017.0
|
2,019.0
|
2,022
|
597
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
17 (2.8 %)
|
217 (36.3 %)
|
month
|
1 - 2
|
6.4
|
1
|
5.0
|
6.0
|
8.0
|
12
|
597
|
12 (2.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
13 (2.2 %)
|
181 (30.3 %)
|
casenumber
|
0 - 15
|
n/a
|
TKH-2014-000443
|
n/a
|
n/a
|
n/a
|
TKH-2020-000052
|
597
|
137 (22.9 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
461 (77.2 %)
|
n/a
|
disease
|
32 - 108
|
n/a
|
American foulbrood of honey bees
|
n/a
|
n/a
|
n/a
|
Varroosis of honey bees in the case of imminent or actual death of at least 30% of the colonies in an apiary
|
597
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
3 (0.5 %)
|
n/a
|
animalspecies
|
7 - 7
|
1,341,976.0
|
1,341,976
|
1,341,976.0
|
1,341,976.0
|
1,341,976.0
|
1,341,976
|
597
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
1 (0.2 %)
|
0 (0.0 %)
|
datestart
|
0 - 10
|
n/a
|
2014-06-05
|
n/a
|
n/a
|
n/a
|
2022-08-30
|
597
|
65 (10.9 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
345 (57.8 %)
|
n/a
|
dateend
|
0 - 10
|
n/a
|
2014-08-06
|
n/a
|
n/a
|
n/a
|
2022-11-26
|
597
|
172 (28.8 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
217 (36.3 %)
|
n/a
|
country
|
3 - 3
|
n/a
|
AUT
|
n/a
|
n/a
|
n/a
|
BEL
|
597
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
2 (0.3 %)
|
n/a
|
nuts
|
2 - 5
|
n/a
|
AT11
|
n/a
|
n/a
|
n/a
|
BE353
|
597
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
28 (4.7 %)
|
n/a
|
districtcode
|
3 - 3
|
489.6
|
106
|
323.0
|
504.0
|
620.0
|
900
|
597
|
137 (22.9 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
68 (11.4 %)
|
362 (60.6 %)
|
postcode
|
4 - 4
|
6,327.6
|
1,549
|
6,180.0
|
6,740.0
|
7,332.0
|
9,255
|
597
|
525 (87.9 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
34 (5.7 %)
|
557 (93.3 %)
|
unit
|
6 - 6
|
n/a
|
number
|
n/a
|
n/a
|
n/a
|
number
|
597
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
1 (0.2 %)
|
n/a
|
value
|
1 - 2
|
1.2
|
0
|
1.0
|
1.0
|
1.0
|
36
|
597
|
0 (0.0 %)
|
3 (0.5 %)
|
0 (0.0 %)
|
11 (1.8 %)
|
35 (5.9 %)
|
annotation
|
0 - 0
|
n/a
|
n/a
|
n/a
|
n/a
|
n/a
|
n/a
|
597
|
597 (100.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
1 (0.2 %)
|
n/a
|
sourceid
|
1 - 2
|
51.2
|
1
|
36.5
|
59.0
|
61.0
|
80
|
597
|
0 (0.0 %)
|
0 (0.0 %)
|
0 (0.0 %)
|
54 (9.0 %)
|
286 (47.9 %)
|
id | year | month | casenumber | disease | animalspecies | datestart | dateend | country | nuts | districtcode | postcode | unit | value | annotation | sourceid |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1
|
2015
|
1
|
TKH-2014-000443
|
American foulbrood of honey bees
|
1341976
|
2015-01-07
|
2015-05-04
|
AUT
|
AT12
|
307
|
|
number
|
1
|
|
50
|
2
|
2015
|
1
|
TKH-2014-000454
|
American foulbrood of honey bees
|
1341976
|
2015-01-12
|
|
AUT
|
AT21
|
205
|
|
number
|
1
|
|
61
|
3
|
2015
|
2
|
TKH-2015-000173
|
American foulbrood of honey bees
|
1341976
|
2015-02-16
|
2015-04-08
|
AUT
|
AT12
|
325
|
|
number
|
1
|
|
50
|
4
|
2015
|
3
|
TKH-2015-000335
|
American foulbrood of honey bees
|
1341976
|
2015-03-06
|
2015-04-09
|
AUT
|
AT12
|
309
|
|
number
|
1
|
|
50
|
5
|
2015
|
2
|
TKH-2015-000553
|
American foulbrood of honey bees
|
1341976
|
2015-02-12
|
|
AUT
|
AT21
|
205
|
|
number
|
1
|
|
61
|
6
|
2015
|
3
|
TKH-2015-000563
|
American foulbrood of honey bees
|
1341976
|
2015-03-12
|
2015-07-09
|
AUT
|
AT32
|
503
|
|
number
|
1
|
|
50
|
7
|
2015
|
4
|
TKH-2015-000625
|
American foulbrood of honey bees
|
1341976
|
2015-04-08
|
2015-05-13
|
AUT
|
AT12
|
325
|
|
number
|
1
|
|
46
|
8
|
2015
|
4
|
TKH-2015-000692
|
American foulbrood of honey bees
|
1341976
|
2015-04-28
|
2015-07-14
|
AUT
|
AT22
|
621
|
|
number
|
1
|
|
46
|
9
|
2015
|
5
|
TKH-2015-000693
|
American foulbrood of honey bees
|
1341976
|
2015-05-04
|
2015-07-06
|
AUT
|
AT31
|
412
|
|
number
|
1
|
|
46
|
10
|
2015
|
5
|
TKH-2015-000705
|
American foulbrood of honey bees
|
1341976
|
2015-05-07
|
2015-07-07
|
AUT
|
AT32
|
505
|
|
number
|
1
|
|
46
|
11
|
2015
|
5
|
TKH-2015-000716
|
American foulbrood of honey bees
|
1341976
|
2015-05-02
|
2015-08-07
|
AUT
|
AT12
|
315
|
|
number
|
1
|
|
46
|
12
|
2015
|
5
|
TKH-2015-000719
|
American foulbrood of honey bees
|
1341976
|
2015-05-11
|
2015-09-30
|
AUT
|
AT22
|
611
|
|
number
|
1
|
|
46
|
13
|
2015
|
5
|
TKH-2015-000720
|
American foulbrood of honey bees
|
1341976
|
2015-05-18
|
2015-08-07
|
AUT
|
AT22
|
623
|
|
number
|
1
|
|
46
|
14
|
2015
|
4
|
TKH-2015-000721
|
American foulbrood of honey bees
|
1341976
|
2015-04-15
|
2015-06-12
|
AUT
|
AT12
|
323
|
|
number
|
1
|
|
46
|
15
|
2015
|
5
|
TKH-2015-000722
|
American foulbrood of honey bees
|
1341976
|
2015-05-12
|
2015-08-18
|
AUT
|
AT12
|
318
|
|
number
|
1
|
|
46
|
16
|
2015
|
5
|
TKH-2015-000723
|
American foulbrood of honey bees
|
1341976
|
2015-05-13
|
2015-07-02
|
AUT
|
AT31
|
414
|
|
number
|
1
|
|
46
|
17
|
2015
|
5
|
TKH-2015-000726
|
American foulbrood of honey bees
|
1341976
|
2015-05-12
|
2015-07-15
|
AUT
|
AT32
|
506
|
|
number
|
1
|
|
46
|
18
|
2015
|
5
|
TKH-2015-000728
|
American foulbrood of honey bees
|
1341976
|
2015-05-18
|
|
AUT
|
AT32
|
504
|
|
number
|
1
|
|
46
|
19
|
2015
|
5
|
TKH-2015-000740
|
American foulbrood of honey bees
|
1341976
|
2015-05-20
|
2016-08-31
|
AUT
|
AT22
|
614
|
|
number
|
1
|
|
61
|
20
|
2015
|
5
|
TKH-2015-000741
|
American foulbrood of honey bees
|
1341976
|
2015-05-11
|
2015-08-17
|
AUT
|
AT12
|
323
|
|
number
|
1
|
|
46
|
21
|
2015
|
5
|
TKH-2015-000742
|
American foulbrood of honey bees
|
1341976
|
2015-05-28
|
|
AUT
|
AT22
|
620
|
|
number
|
1
|
|
61
|
22
|
2015
|
5
|
TKH-2015-000746
|
American foulbrood of honey bees
|
1341976
|
2015-05-09
|
2015-09-28
|
AUT
|
AT22
|
621
|
|
number
|
1
|
|
46
|
23
|
2015
|
5
|
TKH-2015-000748
|
American foulbrood of honey bees
|
1341976
|
2015-05-05
|
|
AUT
|
AT22
|
621
|
|
number
|
1
|
|
46
|
24
|
2015
|
6
|
TKH-2015-000751
|
American foulbrood of honey bees
|
1341976
|
2015-06-02
|
2016-05-31
|
AUT
|
AT22
|
614
|
|
number
|
1
|
|
61
|
- id
- year
- month
- casenumber
- disease
- animalspecies
- datestart
- dateend
- country
- nuts
- districtcode
- postcode
- unit
- value
- annotation
- sourceid
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Data Distribution Top 20
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Data Distribution Top 20
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Data Distribution Top 20
Data Distribution Bottom 20
Outliers
Data unavailable
Completeness
Uniqueness
Data Distribution Top 20
Outliers
Data unavailable
Completeness
Uniqueness
Data Distribution Top 20
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Data Distribution Top 20
Data Distribution Bottom 20
Outliers
Data unavailable
Completeness
Uniqueness
Data Distribution Top 20
Data Distribution Bottom 20
Outliers
Data unavailable
Completeness
Uniqueness
Data Distribution Top 20
Outliers
Data unavailable
Completeness
Uniqueness
Data Distribution Top 20
Data Distribution Bottom 20
Outliers
Data unavailable
Completeness
Uniqueness
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Data Distribution Top 20
Outliers
Data unavailable
Completeness
Uniqueness
Data Distribution Top 20
Continuous Data Distribution
Outliers
Completeness
Uniqueness
Data Distribution Top 20
Outliers
Data unavailable