EU Pollinator Hub

, ,

Dataset Report
Unique identifier: VTCSS14.0.0
Title: Vetcases
Long title: Reports of notifiable diseases reported for Apis mellifera
Status: Quality Validated
Current Version: v. 1.0
Published: 2023-06-13
Reviewed by:
Citation proposal:
Biene Österreich – Imkereidachverband 2023 Report of dataset Vetcases, v. 1.0 [VTCSS14.0.0]. EU Pollinator Hub. [2025-07-01] app.pollinatorhub.eu
Compliance with FAIR* principles
Findable
Accessible
Interoperable
Reusable
See https://www.go-fair.org/fair-principles for more information about FAIR principles
Data Quality
Under evaluation

Document history

Release

Version v. 1.0 released on 2023-06-13.

Revision

Table 1. List of revisions made to the document. Identifier of revision (No); date of revision (Date); description of revision (Description); reason for revision (Reason).
No Date Description Reason
1 2023-06-13 00:06:00 Initial release. n/a

Abbreviations

AFB
American foulbrood of honey bees
BMSGPK
Bundesministerium für Soziales, Gesundheit, Pflege und Konsumentenschutz (Austrian Federal Ministry of Social Affairs, Health, Care and Consumer Protection)
EFB
European foulbrood of honey bees
EFSA
European Food Safety Authority
FAVV-AFSCA
Federaal Agentschap voor de veiligheid van de voedselketen - Agence fédérale pour la sécurité de la chaîne alimentaire (Federal Agency for the Safety of the Food Chain)
KVG
Kommunikationsplattform Verbrauchergesundheit (Consumer Health Communication Platform)
StLVB
Steirischer Landesverband für Bienenzucht (Styrian Beekeepers Association)
n.a.
not available

Executive summary

Data overview:

This dataset contains a list of outbreaks of honey (Apis mellifera L.) disease from various sources in Austria and Belgium for which legislation provides for compulsory notification to the veterinary authorities (referred to as notifiable diseases).

Data value:

This dataset was collected to provide an example for a comprehensive overview on the frequency and location of notified outbreaks of honey bee diseases in different countries and regions.

Data description:

The dataset contains 5 files with outbreaks of notifiable diseases from Belgium and Austria.

interactions.single.section-about.data-overview-application:

This data is suited to produce concise tabular and graphical overviews and summaries on notified outbreaks of honey bee diseases in different countries and regions. Possible research questions include the following:

Unresolved issues:

n/a

Introduction

This dataset contains a list of outbreaks of honey (Apis mellifera L.) disease from various sources in Austria and Belgium for which legislation provides for compulsory notification to the veterinary authorities (referred to as notifiable diseases). Since 13.06.2022 (law no. 2022041357) Regulation (EU) 2016/429 from 09.03.2016 on transmissible animal diseases and amending and repealing certain acts in the area of animal health (“Animal Health Law”) entered into force. According to Article 18 the following notifiable honey bee diseases are listed in annex II: infestation with Varroa spp. (Varroosis), infestation with Aethina tumida (Small hive beetle), American foulbrood, infestation with Tropilaelaps spp. In Belgium, until 10.06.2022 notification of honey bee diseases was regulated by the animal health law (dierengezondheidswet / loi relative à la santé des animaux), which entered into force on 27.04.1987 (law no. 19870106057). The following diseases had to be notified: infestation with the tracheal mite (Acarapis woodi), American foulbrood (Paenibacillus larvae), European foulbrood (Melissococcus plutonius), infestation with the small hive beetle (Aethina tumida), infestation with Tropilaelaps mites (Tropilaelaps spp). Since 17.07.2014 (law no. 2014024272) Varroosis has been removed from the list of notifiable diseases. In Austria notification of honey bee diseases is currently regulated in the bee disease law (Bundesgesetz vom 25. Mai 1988 über die Bekämpfung ansteckender Krankheiten der Bienen; Bienenseuchengesetz), which entered into force on 25.05.1988 (law no. 290/1988). The following diseases have to be notified: American foulbrood (Paenibacillus larvae), infestation with the small hive beetle (Aethina tumida), infestation with Tropilaelaps mites (Tropilaelaps spp), Varroosis in case of an imminent or actual death of at least 30% of the colonies in an apiary. Since 05.07.2005 (law no. 67/2005) Nosemosis has been removed from the list of notifiable diseases. Regulation (EU) 2016/429 has not been implemented to date.

Material and methods

Data acquisition

Data on notified outbreaks of animal diseases in Austria were obtained from monthly animal health reports available on the Website of the Consumer Health Communication Platform (Kommunikationsplattform Verbrauchergesundheit, KVG) provided by the Austrian Federal Ministry of Social Affairs, Health, Care and Consumer Protection (Bundesministerium für Soziales, Gesundheit, Pflege und Konsumentenschutz, BMSGPK). Monthly issued animal health reports for 2015 [1], 2016 [2], 2017 [3], 2018 [4], 2019 [5] and part of 2020 [6], available in PDF and XLSX format, were downloaded from the website. Data from 2021 [7] and 2022 [8] was obtained from summary animal health reports available at the same location. Data on notified outbreaks of honey bee diseases for Belgium were obtained from a website provided by the Belgium food safety authority (Agence Fédérale pour la Sécurité de la Chaîne Alimentaire, FAVV-AFSCA) [9]. The data source for each record is referenced in the dataset.

Table 2. List of raw data and metadata files included in the dataset. Identifier of table row (No); name of the file (File); the type of the file (Type); file contains data (D); file contains metadata (M); date of upload of the file to the EU Pollinator Hub (Arrival); number of data points contained within the file (if applicable); uploaded file size.
No File Type D M Arrival Data points File size
1 euph_000014_vetcases_table_kvg.csv CSV - Comma seperated values Yes No 2024-01-29 08:01:36 311,922 3.27 MiB
2 euph_000014_vetcases_table_vetcaseat.csv CSV - Comma seperated values Yes No 2024-01-29 08:01:10 7,695 72.45 KiB
3 euph_000014_vetcases_table_vetcasebe.csv CSV - Comma seperated values Yes No 2023-12-05 16:12:13 1,176 10.79 KiB
4 vetcaseat22_blurred.csv CSV - Comma seperated values Yes No 2023-12-14 09:12:40 6,552 78.21 KiB
5 euph_000014_vetcases_table_vetcase.csv CSV - Comma seperated values Yes No 2024-01-29 08:01:00 9,552 86.47 KiB
6 euph_000014_vetcases_table_references.csv CSV - Comma seperated values Yes No 2024-01-29 08:01:57 240 39.40 KiB

Data preparation

Raw data from BMSGPK was, if necessary, converted to a Microsoft® Excel® Document (*.xlsx) using Adobe Acrobat Reader DC (Adobe, Version 2022.002.20212) rearranged and further processed with Excel (Microsoft Corporation, version 16.0.15601.20148). Data from FAVV-AFSCA was inserted manually into Excel. Data was then exported from Excel to a CSV format (coding: UTF-8) and subsequently imported for profiling into a SQL database (MariaDB foundation, Server-Version 10.4.24) running in a XAMPP environment (BitRock, version 3.3.0). Data was exported from the MySQL database to CSV format using windows-1252 coding.

Data validation

None

Data analysis

None

Data description

Dataset

Table 3. Summary of tables belonging to the dataset. Table row identifier (No); name of the table (Table); description of the table (Description).
No Table Description
1 Kvg Data in this table was obtained from the Consumer Health Communication Platform (Kommunikationsplattform Verbrauchergesundheit, KVG) provided by the Austrian Federal…
2 Vetcaseat Data in this table was obtained from the Consumer Health Communication Platform (Kommunikationsplattform Verbrauchergesundheit, KVG) provided by the Austrian Federal…
3 Vetcasebe Data in this table was obtained from the Belgian Federal Agency for the Safety of the Food Chain (Federaal Agentschap…
4 Vetcasesat22 Data in this table was obtained from the Styrian Beekeepers Association (Steirischer Landesverband für Bienenzucht, StLVB), which is the biggest…
5 Vetcase Data in this table was was merged from tables vetcaseat and vetcasebe.
6 References The table contains references to sources (books, scientific journals, technical journals, websites) from which data in this dataset was obtained.
Table 4. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
interactions.single.uid VTCSS14.0.0
Title Vetcases
Long title Reports of notifiable diseases reported for Apis mellifera
Target IRI https://app.pollinatorhub.eu/dataset-discovery/VTCSS14.0.0
interactions.single.section-details.licence CC BY-NC-SA 4.0
DOI n/a
Created 2023-02-08
Published 2023-06-13
Contact n/a
Keywords AFB, American foulbrood, Austria, Belgium, EFB, European foulbrood, Steiermark, disease
Data collection years 2000-2022
Regions, the data was collected in Belgique/België, Steiermark, Österreich
Abstract

This dataset contains data from various sources on the outbreak of notifiable diseases reported for honey bees (Apis mellifera) in Belgium and Austria from 2000 to 2022.

Table 5. Standardised metadata of the data provider Biene Österreich – Imkereidachverband. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name Biene Österreich – Imkereidachverband
Url
Acronym
IRI https://app.pollinatorhub.eu/data-providers/boe
Contact Georg-Coch Platz 3/11a, 1010 Wien www.biene-oesterreich.at office@biene-oesterreich.at
Description

The Austrian Beekeepers Federation (, Biene Österreich-Imkereidachverband) is the umbrella organisation of the two largest beekeeping associations in Austria, the Austrian Beekepers Association (ÖIB, Österreichischer Imkerbund) and the Austrian Professional Beekeepers Association (ÖEIB, Österreichischer Erwerbsimkerbund).

Tables

Kvg

Table 6. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier VTCSS14.KVGAB29.0
Name Kvg
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/VTCSS14.KVGAB29.0
Table Type File
Licence KVG-BMSGPK
Description

Data in this table was obtained from the Consumer Health Communication Platform (Kommunikationsplattform Verbrauchergesundheit, KVG) provided by the Austrian Federal Ministry of Social Affairs, Health, Care and Consumer Protection (Bundesministerium für Soziales, Gesundheit, Pflege und Konsumentenschutz, BMSGPK). It contains information on food and consumer protection as well as animal health and animal welfare, among which outbreaks of notifiable honey bee diseases from 2015 to 2020 in Austria (AT).

Data in this table was obtained from the Consumer Health Communication Platform (Kommunikationsplattform Verbrauchergesundheit, KVG) provided by the Austrian Federal Ministry of Social Affairs, Health, Care and Consumer Protection (Bundesministerium für Soziales, Gesundheit, Pflege und Konsumentenschutz, BMSGPK). It contains information on food and consumer protection as well as animal health and animal welfare, among which outbreaks of notifiable honey bee diseases from 2015 to 2020 in Austria (AT).

Metadata

Table 7. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Column Description Datatype Descriptor Unit
id

Identifier of the record.

String pms:recordID [0.0.RCRDD344]

n/a

year

Reporting period (calendar year).

Integer number dwc:year [0.0.YEARA340]

year

month

Reporting period (calendar month).

Integer number iso-8601:calendarMonth [0.0.CLNDR376]

n/a

casenumber

Case number adopted by BMSGPK.

String casenumber [VTCSS14.0.CSNMB379]

n/a

disease

Name of the disease.

String pms:disease [0.0.HNYBD375]

n/a

item

Description of the reported item.

String Text [0.0.TEXTA315]

n/a

datestart

Date of establishment of a quarantine area. Official start of outbreak.

Date pms:startDate [0.0.STRTD805]

n/a

dateend

Date of lifting of a quarantine area. Official end of outbreak.

Date pms:endDate [0.0.NDDTE806]

n/a

districtcode

Official code of the district (Politischer Bezirk) in which the notified outbreak occurred.

Integer number eurostat:PoliticalDistrictID [0.0.PLTCL128]

n/a

unit

Unit in which the value is reported.

String Text [0.0.TEXTA315]

n/a

value

Reported value.

Integer number Integer [0.0.NTGER313]

no.

annotation

Detailed annotation to the value.

String Text [0.0.TEXTA315]

n/a

sourceId

Reference to the data source.

Integer number Source ID [VTCSS14.0.SRCDA377]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 8. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
id 1 - 5 12,157.5 1 5,998.75 12,141.5 18,284.25 24,378 23,994 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 23,994 ( 100.0% )
year 4 - 4 2,016.8 2,015 2,016 2,016 2,018 2,020 23,994 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 0.0% )
month 1 - 2 6.5 1 4 7 9 12 23,994 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 12 ( 0.1% )
casenumber 15 - 15 n/a TKH-2012-000… n/a n/a n/a TKH-2020-000… 23,994 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 525 ( 2.2% )
disease 32 - 32 n/a American fou… n/a n/a n/a American fou… 23,994 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
item 13 - 42 n/a Dead colonie… n/a n/a n/a Susceptible… 23,994 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 0.0% )
datestart 10 - 10 2,016.0 2012-03-20 2,015 2,016 2,017 2020-03-30 23,994 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 344 ( 1.4% )
dateend 0 - 10 2,017.0 2015-01-15 2,016 2,016 2,018 2019-11-25 23,994 20,760 ( 86.5% ) 0 ( 0.0% ) 0 ( 0.0% ) 221 ( 0.9% )
districtcode 3 - 3 489.9 106 323 504 616 900 23,994 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 70 ( 0.3% )
unit 6 - 6 n/a number n/a n/a n/a number 23,994 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
value 1 - 3 2.5 0 0 0 2 113 23,994 0 ( 0.0% ) 14,998 ( 62.5% ) 0 ( 0.0% ) 46 ( 0.2% )
annotation 0 - 130 n/a n/a n/a n/a Corrected fr… 23,994 23,991 ( 100.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4 ( 0.0% )
sourceId 1 - 2 31.9 1 15 32 50 61 23,994 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 61 ( 0.3% )

Quality measures

Table 9. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
id
100.00%
100.00%
1 1
year
100.00%
0.03%
2016 2020
month
100.00%
0.05%
9 12
casenumber
100.00%
2.19%
TKH-2014-000454 TKH-2016-000451
disease
100.00%
0.00%
American foulbrood of honey bees American foulbrood of honey bees
item
100.00%
0.03%
Susceptible livestock at start of outbreak Susceptible livestock at start of outbreak
datestart
100.00%
1.43%
2016-05-25 2016-04-29
dateend
13.48%
0.92%
null 2018-05-07
districtcode
100.00%
0.29%
614 106
unit
100.00%
0.00%
number number
value
100.00%
0.19%
0 48
annotation
0.01%
0.02%
null Corrected from 10000 to 1. Michael Rubinigg 05.07.2021. Reason: value obviously wrong, replaced by the most plausible real value.
sourceId
100.00%
0.25%
59 43

Changes made to preparatory file

Changes made to data

None

Unresolved issues

None

Vetcaseat

Table 10. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier VTCSS14.VTCST30.0
Name Vetcaseat
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/VTCSS14.VTCST30.0
Table Type File
Licence KVG-BMSGPK
Description

Data in this table was obtained from the Consumer Health Communication Platform (Kommunikationsplattform Verbrauchergesundheit, KVG) provided by the Austrian Federal Ministry of Social Affairs, Health, Care and Consumer Protection (Bundesministerium für Soziales, Gesundheit, Pflege und Konsumentenschutz, BMSGPK). It contains the number of notified outbreaks of notifiable honey bee diseases from 2015 to 2022 on apiaries in Austria, aggregated by calendar month and district (Politischer Bezirk) or NUTS2 region (if district is NULL).

Data in this table was obtained from the Consumer Health Communication Platform (Kommunikationsplattform Verbrauchergesundheit, KVG) provided by the Austrian Federal Ministry of Social Affairs, Health, Care and Consumer Protection (Bundesministerium für Soziales, Gesundheit, Pflege und Konsumentenschutz, BMSGPK). It contains the number of notified outbreaks of notifiable honey bee diseases from 2015 to 2022 on apiaries in Austria, aggregated by calendar month and district (Politischer Bezirk) or NUTS2 region (if district is NULL).

Metadata

Table 11. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Column Description Datatype Descriptor Unit
id

Identifier of the record.

String pms:recordID [0.0.RCRDD344]

n/a

year

Reporting period (calendar year).

Integer number dwc:year [0.0.YEARA340]

year

month

Reporting period (calendar month).

Integer number iso-8601:calendarMonth [0.0.CLNDR376]

n/a

casenumber

Case number adopted by BMSGPK.

String casenumber [VTCSS14.0.CSNMB379]

n/a

disease

Name of the disease.

String pms:disease [0.0.HNYBD375]

n/a

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/, which points to a taxonomic rank.

Integer number pms:gbifTaxonID [0.0.GBFTX336]

n/a

datestart

Date of establishment of a quarantine area. Official start of outbreak.

Date pms:startDate [0.0.STRTD805]

n/a

dateend

Date of lifting of a quarantine area. Official end of outbreak.

Date pms:endDate [0.0.NDDTE806]

n/a

country

ISO 3166-1 alpha-3 code of the country in which the notified outbreak occurred.

String iso-3166:alpha-3CountryCode [0.0.LPHCN5]

n/a

nuts

Nuts code of the geographic entity in which the notified outbreak occurred.

String eurostat:nuts2021Code [0.0.NTSCD55]

n/a

districtcode

Official code of the district (Politischer Bezirk) in which the notified outbreak occurred.

Integer number eurostat:PoliticalDistrictID [0.0.PLTCL128]

n/a

unit

Unit in which the value is reported.

String Text [0.0.TEXTA315]

n/a

value

Number of notified outbreaks (on an apiary basis) per district (Politischer Bezirk) or NUTS2 region (if district is NULL) and month.

Integer number Integer [0.0.NTGER313]

no.

annotation

Detailed annotation to the value.

String Text [0.0.TEXTA315]

n/a

sourceid

Reference to the data source.

Integer number Source ID [VTCSS14.0.SRCDA377]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 12. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
id 1 - 3 257.0 1 128.5 257 385.5 513 513 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 513 ( 100.0% )
year 4 - 4 2,017.3 2,015 2,016 2,017 2,019 2,022 513 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 8 ( 1.6% )
month 1 - 2 6.3 1 5 6 8 12 513 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 12 ( 2.3% )
casenumber 0 - 15 n/a n/a n/a n/a TKH-2020-000… 513 53 ( 10.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 461 ( 89.9% )
disease 32 - 94 n/a American fou… n/a n/a n/a Varroosis in… 513 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 0.4% )
animalspecies 7 - 7 1,341,976.0 1,341,976 1,341,976 1,341,976 1,341,976 1,341,976 513 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.2% )
datestart 0 - 10 2,017.0 2015-01-07 2,016 2,016 2,018 2020-03-30 513 53 ( 10.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 298 ( 58.1% )
dateend 0 - 10 2,017.0 2015-04-08 2,016 2,017 2,018 2019-11-25 513 157 ( 30.6% ) 0 ( 0.0% ) 0 ( 0.0% ) 193 ( 37.6% )
country 3 - 3 n/a AUT n/a n/a n/a AUT 513 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.2% )
nuts 4 - 4 n/a AT11 n/a n/a n/a AT34 513 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 9 ( 1.8% )
districtcode 3 - 3 489.6 106 323 504 620 900 513 53 ( 10.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 68 ( 13.3% )
unit 6 - 6 n/a number n/a n/a n/a number 513 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.2% )
value 1 - 2 1.1 1 1 1 1 11 513 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 8 ( 1.6% )
annotation 0 - 0 n/a n/a n/a n/a 513 513 ( 100.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.2% )
sourceid 1 - 2 46.8 1 33 56 61 80 513 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 52 ( 10.1% )

Quality measures

Table 13. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
id
100.00%
100.00%
1 1
year
100.00%
1.56%
2016 2020
month
100.00%
2.34%
5 12
casenumber
89.67%
89.86%
null TKH-2014-000443
disease
100.00%
0.39%
American foulbrood of honey bees Varroosis in the case of imminent or actual death of at least 30% of the colonies in an apiary
animalspecies
100.00%
0.19%
1341976 1341976
datestart
89.67%
58.09%
null 2015-01-07
dateend
69.40%
37.62%
null 2015-05-04
country
100.00%
0.19%
AUT AUT
nuts
100.00%
1.75%
AT12 AT13
districtcode
89.67%
13.26%
504 307
unit
100.00%
0.19%
number number
value
100.00%
1.56%
1 5
annotation
0.00%
0.19%
null null
sourceid
100.00%
10.14%
61 4

Changes made to preparatory file

None

Changes made to data

None

Unresolved issues

None

Vetcasebe

Table 14. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier VTCSS14.VTCSB31.0
Name Vetcasebe
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/VTCSS14.VTCSB31.0
Table Type File
Licence FAVV-AFSCA
Description

Data in this table was obtained from the Belgian Federal Agency for the Safety of the Food Chain (Federaal Agentschap voor de veiligheid van de voedselketen - Agence fédérale pour la sécurité de la chaîne alimentaire, FAVV-AFSCA), which is responsible for the assessment and management of risks that may be harmful to the health of consumers as well as the health of animals and plants. It provides outbreaks of notifiable honey bee diseases from 2006 to 2022 in Belgium (BE).

Data in this table was obtained from the Belgian Federal Agency for the Safety of the Food Chain (Federaal Agentschap voor de veiligheid van de voedselketen - Agence fédérale pour la sécurité de la chaîne alimentaire, FAVV-AFSCA), which is responsible for the assessment and management of risks that may be harmful to the health of consumers as well as the health of animals and plants. It provides outbreaks of notifiable honey bee diseases from 2006 to 2022 in Belgium (BE).

Metadata

Table 15. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Column Description Datatype Descriptor Unit
id

Identifier of the record.

String pms:recordID [0.0.RCRDD344]

n/a

year

Reporting period (calendar year).

Integer number dwc:year [0.0.YEARA340]

year

month

Reporting period (calendar month).

Integer number iso-8601:calendarMonth [0.0.CLNDR376]

n/a

disease

Name of the disease.

String pms:disease [0.0.HNYBD375]

n/a

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/, which points to a taxonomic rank.

Integer number pms:gbifTaxonID [0.0.GBFTX336]

n/a

datestart

Date of establishment of a quarantine area. Official start of outbreak.

Date pms:startDate [0.0.STRTD805]

n/a

dateend

Date of lifting of a quarantine area. Official end of outbreak.

Date pms:endDate [0.0.NDDTE806]

n/a

country

ISO 3166-1 alpha-3 code of the country in which the notified outbreak occurred.

String iso-3166:alpha-3CountryCode [0.0.LPHCN5]

n/a

nuts

Nuts code of the geographic entity in which the notified outbreak occurred.

String eurostat:nuts2021Code [0.0.NTSCD55]

n/a

postcode

Postcode of the location in which the notified outbreak occurred.

String eurostat:postcode [0.0.PSTCD378]

n/a

unit

Unit in which the value is reported.

String Text [0.0.TEXTA315]

n/a

value

Number of notified outbreaks (on an apiary basis) per postcode or NUTS region (if postcode is NULL) and month or year (if month is NULL).

Integer number Integer [0.0.NTGER313]

no.

annotation

Detailed annotation to the value.

String Text [0.0.TEXTA315]

n/a

sourceid

Reference to the data source.

Integer number Source ID [VTCSS14.0.SRCDA377]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 16. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
id 3 - 3 555.5 514 534.25 555.5 576.75 597 84 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 84 ( 100.0% )
year 4 - 4 2,018.1 2,006 2,018 2,019 2,020 2,022 84 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 17 ( 20.2% )
month 1 - 2 6.8 4 6 7 8 11 84 12 ( 14.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 8 ( 9.5% )
disease 32 - 32 n/a American fou… n/a n/a n/a European fou… 84 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 2.4% )
animalspecies 7 - 7 1,341,976.0 1,341,976 1,341,976 1,341,976 1,341,976 1,341,976 84 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 1.2% )
datestart 0 - 10 2,019.0 2014-06-05 2,018 2,019 2,020 2022-08-30 84 12 ( 14.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 59 ( 70.2% )
dateend 0 - 10 2,020.0 2014-08-06 2,019 2,020 2,021 2022-11-26 84 15 ( 17.9% ) 0 ( 0.0% ) 0 ( 0.0% ) 27 ( 32.1% )
country 3 - 3 n/a BEL n/a n/a n/a BEL 84 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 1.2% )
nuts 2 - 5 n/a BE n/a n/a n/a BE353 84 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 19 ( 22.6% )
postcode 4 - 4 6,327.6 1,549 6,180 6,740 7,332 9,255 84 12 ( 14.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 34 ( 40.5% )
unit 6 - 6 n/a number n/a n/a n/a number 84 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 1.2% )
value 1 - 2 1.8 0 1 1 1 36 84 0 ( 0.0% ) 3 ( 3.6% ) 0 ( 0.0% ) 9 ( 10.7% )
annotation 0 - 0 n/a n/a n/a n/a 84 84 ( 100.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 1.2% )
sourceid 2 - 2 78.1 78 78 78 78 79 84 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 2.4% )

Quality measures

Table 17. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
id
100.00%
100.00%
514 514
year
100.00%
20.24%
2020 2006
month
85.71%
9.52%
7 11
disease
100.00%
2.38%
American foulbrood of honey bees European foulbrood of honey bees
animalspecies
100.00%
1.19%
1341976 1341976
datestart
85.71%
70.24%
null 2014-06-05
dateend
82.14%
32.14%
null 2014-08-06
country
100.00%
1.19%
BEL BEL
nuts
100.00%
22.62%
BE323 BE221
postcode
85.71%
40.48%
6280 7973
unit
100.00%
1.19%
number number
value
100.00%
10.71%
1 5
annotation
0.00%
1.19%
null null
sourceid
100.00%
2.38%
78 79

Changes made to preparatory file

None

Changes made to data

None

Unresolved issues

None

Vetcasesat22

Table 18. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier VTCSS14.VTCSS32.0
Name Vetcasesat22
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/VTCSS14.VTCSS32.0
Table Type File
Licence CC BY 4.0
Description

Data in this table was obtained from the Styrian Beekeepers Association (Steirischer Landesverband für Bienenzucht, StLVB), which is the biggest beekeeping association in the region of Styria. It contains outbreaks of American foulbrood from 2000 to 2022 in Styria (AT22).

Data in this table was obtained from the Styrian Beekeepers Association (Steirischer Landesverband für Bienenzucht, StLVB), which is the biggest beekeeping association in the region of Styria. It contains outbreaks of American foulbrood from 2000 to 2022 in Styria (AT22).

Metadata

Table 19. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Column Description Datatype Descriptor Unit
id

Identifier of the record.

String pms:recordID [0.0.RCRDD344]

n/a

disease

Name of the disease.

String pms:disease [0.0.HNYBD375]

n/a

municipalitycode

Official code of the municipality (Gemeindekennziffer) in which the notified outbreak occurred.

Integer number eurostat:MunicipalityCode [0.0.MNCPL132]

n/a

wgs84e

Longitude of the position of the affected apiary in WGS 84 format.

Decimal number dwc:decimalLongitude [0.0.LNGTD332]

°

wgs84n

Latitude of the position of the affected apiary in WGS 84 format.

Decimal number dwc:decimalLatitude [0.0.LTTDE333]

°

bedatestart

Date of the administrative ruling (Bescheid) by which the apiary affected by a notifiable disease is put into quarantine.

Date pms:startDate [0.0.STRTD805]

n/a

begzstart

Reference number of the administrative ruling (Bescheid) by which the apiary affected by a notifiable disease is put into quarantine.

String Text [0.0.TEXTA315]

n/a

bedateend

Date of the administrative ruling (Bescheid) by which the apiary affected by a notifiable disease is released from quarantine.

Date pms:endDate [0.0.NDDTE806]

n/a

begzend

Reference number of the administrative ruling (Bescheid) by which the apiary affected by a notifiable disease is released from quarantine.

String Text [0.0.TEXTA315]

n/a

vodatestart

Date of the regulation (Verordnung) establishing a quarantine zone around an apiary affected by a notifiable disease.

Date pms:startDate [0.0.STRTD805]

n/a

vogzstart

Reference number of the regulation (Verordnung) establishing a quarantine zone around an apiary affected by a notifiable disease.

String Text [0.0.TEXTA315]

n/a

vodateend

Date of the regulation (Verordnung) revoking a quarantine zone around an apiary affected by a notifiable disease.

Date pms:endDate [0.0.NDDTE806]

n/a

vogzend

Reference number of the regulation (Verordnung) revoking a quarantine zone around an apiary affected by a notifiable disease.

String Text [0.0.TEXTA315]

n/a

annotation

Detailed annotation to the record.

String Text [0.0.TEXTA315]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 20. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
id 1 - 3 234.5 1 117.25 234.5 351.75 469 468 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 468 ( 100.0% )
disease 32 - 32 n/a American fou… n/a n/a n/a American fou… 468 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.2% )
municipalitycode 5 - 5 61,541.0 60,101 61,141.25 61,443.5 62,131 62,390 468 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 137 ( 29.3% )
wgs84e 5 - 5 15.138 13.83 14.51 15.41 15.67 16.04 468 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 168 ( 35.9% )
wgs84n 5 - 5 47.260 46.62 47.09 47.32 47.47 47.72 468 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 90 ( 19.2% )
bedatestart 10 - 10 2,010.0 2000-05-17 2,006 2,011 2,014 2022-07-05 468 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 317 ( 67.7% )
begzstart 8 - 50 n/a 8-122-02 n/a n/a n/a 8.2-30/2014,… 468 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 331 ( 70.7% )
bedateend 0 - 10 2,010.0 2000-10-02 2,006 2,011 2,014 2022-07-22 468 21 ( 4.5% ) 0 ( 0.0% ) 0 ( 0.0% ) 255 ( 54.5% )
begzend 0 - 36 n/a n/a n/a n/a 18.2B6/Bi1/1… 468 21 ( 4.5% ) 0 ( 0.0% ) 0 ( 0.0% ) 315 ( 67.3% )
vodatestart 0 - 10 2,012.0 2001-07-18 2,008 2,012 2,015 2022-07-12 468 213 ( 45.5% ) 0 ( 0.0% ) 0 ( 0.0% ) 182 ( 38.9% )
vogzstart 0 - 50 n/a n/a n/a n/a 8.2-30/2014,… 468 213 ( 45.5% ) 0 ( 0.0% ) 0 ( 0.0% ) 224 ( 47.9% )
vodateend 0 - 10 2,012.0 2002-05-28 2,008 2,012 2,016 2022-07-22 468 230 ( 49.1% ) 0 ( 0.0% ) 0 ( 0.0% ) 141 ( 30.1% )
vogzend 0 - 37 n/a n/a n/a n/a 8.2-21/0213,… 468 228 ( 48.7% ) 0 ( 0.0% ) 0 ( 0.0% ) 150 ( 32.1% )
annotation 0 - 0 n/a n/a n/a n/a 468 468 ( 100.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.2% )

Quality measures

Table 21. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
id
100.00%
100.00%
1 1
disease
100.00%
0.21%
American foulbrood of honey bees American foulbrood of honey bees
municipalitycode
100.00%
29.27%
61757 61053
wgs84e
100.00%
35.90%
15.49 15.90
wgs84n
100.00%
19.23%
47.41 46.95
bedatestart
100.00%
67.74%
2001-05-17 2012-04-12
begzstart
100.00%
70.73%
not available 18.9.R1/2011-12
bedateend
95.51%
54.49%
null 2012-05-25
begzend
95.51%
67.31%
not available 18.9.R1/2011-17
vodatestart
54.49%
38.89%
null 2012-03-26
vogzstart
54.49%
47.86%
null 18.9.R1/2011-12
vodateend
50.85%
30.13%
null 2012-05-25
vogzend
51.28%
32.05%
null 18.2-6/2012
annotation
0.00%
0.21%
null null

Changes made to preparatory file

None

Changes made to data

None

Unresolved issues

None

Vetcase

Table 22. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier VTCSS14.VTCSE33.0
Name Vetcase
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/VTCSS14.VTCSE33.0
Table Type File
Licence CC BY 4.0
Description

Data in this table was was merged from tables vetcaseat and vetcasebe.

Data in this table was was merged from tables vetcaseat and vetcasebe.

Metadata

n/a
Table 23. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Column Description Datatype Descriptor Unit
id

Identifier of the record.

String pms:recordID [0.0.RCRDD344]

n/a

year

Reporting period (calendar year).

Integer number dwc:year [0.0.YEARA340]

year

month

Reporting period (calendar month).

Integer number iso-8601:calendarMonth [0.0.CLNDR376]

n/a

casenumber

Case number adopted by BMSGPK.

String casenumber [VTCSS14.0.CSNMB379]

n/a

disease

Name of the disease

String pms:disease [0.0.HNYBD375]

n/a

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/, which points to a taxonomic rank.

Integer number pms:gbifTaxonID [0.0.GBFTX336]

n/a

datestart

Date of establishment of a quarantine area. Official start of outbreak.

Date pms:startDate [0.0.STRTD805]

n/a

dateend

Date of lifting of a quarantine area. Official end of outbreak.

Date pms:endDate [0.0.NDDTE806]

n/a

country

ISO 3166-1 alpha-3 code of the country in which the notified outbreak occurred.

String iso-3166:alpha-3CountryCode [0.0.LPHCN5]

n/a

nuts

Nuts code of the geographic entity in which the notified outbreak occurred.

String eurostat:nuts2021Code [0.0.NTSCD55]

n/a

districtcode

Official code of the municipality (Gemeindekennziffer) in which the notified outbreak occurred.

Integer number eurostat:MunicipalityCode [0.0.MNCPL132]

n/a

postcode

Postcode of the location in which the notified outbreak occurred.

String eurostat:postcode [0.0.PSTCD378]

n/a

unit

Unit in which the value is reported.

String Text [0.0.TEXTA315]

n/a

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 number Integer [0.0.NTGER313]

no.

annotation

Detailed annotation to the value.

String Text [0.0.TEXTA315]

n/a

sourceid

Reference to the data source.

Integer number Source ID [VTCSS14.0.SRCDA377]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 24. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
id 1 - 3 299.0 1 149.5 299 448.5 597 597 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 597 ( 100.0% )
year 4 - 4 2,017.4 2,006 2,016 2,017 2,019 2,022 597 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 17 ( 2.8% )
month 1 - 2 6.4 1 5 6 8 12 597 12 ( 2.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 13 ( 2.2% )
casenumber 0 - 15 n/a n/a n/a n/a TKH-2020-000… 597 137 ( 22.9% ) 0 ( 0.0% ) 0 ( 0.0% ) 461 ( 77.2% )
disease 32 - 108 n/a American fou… n/a n/a n/a Varroosis of… 597 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3 ( 0.5% )
animalspecies 7 - 7 1,341,976.0 1,341,976 1,341,976 1,341,976 1,341,976 1,341,976 597 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.2% )
datestart 0 - 10 2,017.0 2014-06-05 2,016 2,017 2,019 2022-08-30 597 65 ( 10.9% ) 0 ( 0.0% ) 0 ( 0.0% ) 345 ( 57.8% )
dateend 0 - 10 2,018.0 2014-08-06 2,016 2,017 2,019 2022-11-26 597 172 ( 28.8% ) 0 ( 0.0% ) 0 ( 0.0% ) 217 ( 36.3% )
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% )
nuts 2 - 5 n/a BE n/a n/a n/a BE353 597 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 28 ( 4.7% )
districtcode 3 - 3 489.6 106 323 504 620 900 597 137 ( 22.9% ) 0 ( 0.0% ) 0 ( 0.0% ) 68 ( 11.4% )
postcode 4 - 4 6,327.6 1,549 6,180 6,740 7,332 9,255 597 525 ( 87.9% ) 0 ( 0.0% ) 0 ( 0.0% ) 34 ( 5.7% )
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% )
value 1 - 2 1.2 0 1 1 1 36 597 0 ( 0.0% ) 3 ( 0.5% ) 0 ( 0.0% ) 11 ( 1.8% )
annotation 0 - 0 n/a n/a n/a n/a 597 597 ( 100.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.2% )
sourceid 1 - 2 51.2 1 36.5 59 61 80 597 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 54 ( 9.0% )

Quality measures

Table 25. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
id
100.00%
100.00%
1 1
year
100.00%
2.85%
2016 2006
month
97.99%
2.18%
7 12
casenumber
77.05%
77.22%
null TKH-2014-000443
disease
100.00%
0.50%
American foulbrood of honey bees Varroosis of honey bees in the case of imminent or actual death of at least 30% of the colonies in an apiary
animalspecies
100.00%
0.17%
1341976 1341976
datestart
89.11%
57.79%
null 2015-01-07
dateend
71.19%
36.35%
null 2015-05-04
country
100.00%
0.34%
AUT BEL
nuts
100.00%
4.69%
AT12 BE221
districtcode
77.05%
11.39%
504 307
postcode
12.06%
5.70%
6280 7973
unit
100.00%
0.17%
number number
value
100.00%
1.84%
1 11
annotation
0.00%
0.17%
null null
sourceid
100.00%
9.05%
61 4

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

References

Table 26. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier VTCSS14.RFRNC70.0
Name References
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/VTCSS14.RFRNC70.0
Table Type File
Licence CC BY 4.0
Description

The table contains references to sources (books, scientific journals, technical journals, websites) from which data in this dataset was obtained.

The table contains references to sources (books, scientific journals, technical journals, websites) from which data in this dataset was obtained.

Metadata

n/a
Table 27. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Column Description Datatype Descriptor Unit
îd

Reference to the data source.

Integer number Source ID [VTCSS14.0.SRCDA377]

n/a

format
String Text [0.0.TEXTA315]

n/a

reference
String Text [0.0.TEXTA315]

n/a

Metadata of individual tables can be found in Annex 1.

Descriptive measures

Table 28. Content analysis of the table. Column name (Name); range of length of characters (Length); arithmetic mean of values in column (Mean); lowest value in column (Min); first quartile of values in column (Q1); median of values in column (Median); third quartile of values in column (Q3); highest value in column (Max); number of records (Total); number and percentage (between brackets) of all values containing NULL (Missing), the value 0 (Zero), exclusively blank characters (Blank), and of distinct values including NULL, Zero and blank (Distinct).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
îd 1 - 2 40.5 1 20.25 40.5 60.75 80 80 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 80 ( 100.0% )
format 6 - 6 n/a BibTeX n/a n/a n/a BibTeX 80 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 1.3% )
reference 404 - 506 n/a @misc{agence… n/a n/a n/a @techreport{… 80 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 80 ( 100.0% )

Quality measures

Table 29. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
îd
100.00%
100.00%
1 1
format
100.00%
1.25%
BibTeX BibTeX
reference
100.00%
100.00%
@techreport{bundesministerium_fur_soziales_gesundheit_pflege_und_konsumentenschutz_tiergesundheitsbericht_2016, address = {Wien, AT}, title = {Tiergesundheitsbericht {Berichtszeitraum} {September} 2016}, url = {https://www.verbrauchergesundheit.gv.at/tiere/krankheiten/tgb_adns/TGB_AT_September_2016.pdf?92t3gv}, language = {de}, urldate = {2023-02-08}, author = {{Bundesministerium für Soziales, Gesundheit, Pflege und Konsumentenschutz}}, month = oct, year = {2016}, } @techreport{bundesministerium_fur_soziales_gesundheit_pflege_und_konsumentenschutz_tiergesundheitsbericht_2016, address = {Wien, AT}, title = {Tiergesundheitsbericht {Berichtszeitraum} {September} 2016}, url = {https://www.verbrauchergesundheit.gv.at/tiere/krankheiten/tgb_adns/TGB_AT_September_2016.pdf?92t3gv}, language = {de}, urldate = {2023-02-08}, author = {{Bundesministerium für Soziales, Gesundheit, Pflege und Konsumentenschutz}}, month = oct, year = {2016}, }

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

References

There are no sources in the current document.

Annex 1: Table column reports

Table: Kvg

Column: id

Table 30. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name id
Description

Identifier of the record.

Data type String
Descriptor pms:recordID [UID:0.0.RCRDD344]
Descriptor description

Unique sequence of integers associated with a record within a certain table.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.RCRDD344
Unit

n/a

Table 31. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
id 1 - 5 12,157.5 1 5,998.75 12,141.5 18,284.25 24,378 23,994 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 23,994 ( 100.0% )
Table 32. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
id
100.00%
100.00%
1 1

Continuous Data Distribution

Figure 1. Distribution of values in the column.

Outliers

Figure 2. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 3. Visualization of completeness of the data in the column.

Uniqueness

Figure 4. Visualization of uniqueness of the data in the column.

Column: year

Table 33. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name year
Description

Reporting period (calendar year).

Data type Integer number
Descriptor dwc:year [UID:0.0.YEARA340]
Descriptor description

A term from the Darwin Core standard:

The four-digit year in which the dwc:Event occurred, according to the Common Era Calendar.

Descriptor target IRI http://rs.tdwg.org/dwc/terms/year
Unit

year

Table 34. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
year 4 - 4 2,016.8 2,015 2,016 2,016 2,018 2,020 23,994 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 0.0% )
Table 35. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
year
100.00%
0.03%
2016 2020

Data Distribution Top 20

Figure 5. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 6. Distribution of values in the column.

Outliers

Figure 7. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 8. Visualization of completeness of the data in the column.

Uniqueness

Figure 9. Visualization of uniqueness of the data in the column.

Column: month

Table 36. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name month
Description

Reporting period (calendar month).

Data type Integer number
Descriptor iso-8601:calendarMonth [UID:0.0.CLNDR376]
Descriptor description

time scale unit [...] resulting from a defined division of a calendar year [...], each containing a specific number of calendar days [...] Note 1 to entry: A calendar month is in common parlance often referred to as month, however in this document calendar month and month have different definitions.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.CLNDR376
Unit

n/a

Table 37. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
month 1 - 2 6.5 1 4 7 9 12 23,994 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 12 ( 0.1% )
Table 38. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
month
100.00%
0.05%
9 12

Data Distribution Top 20

Figure 10. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 11. Distribution of values in the column.

Outliers

Figure 12. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 13. Visualization of completeness of the data in the column.

Uniqueness

Figure 14. Visualization of uniqueness of the data in the column.

Column: casenumber

Table 39. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name casenumber
Description

Case number adopted by BMSGPK.

Data type String
Descriptor casenumber [UID:VTCSS14.0.CSNMB379]
Descriptor description

Case number adopted by the Austrian Federal Ministry of Social Affairs, Health, Care and Consumer Protection (Bundesministerium für Soziales, Gesundheit, Pflege und Konsumentenschutz, BMSGPK).

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/VTCSS14.0.CSNMB379
Unit

n/a

Table 40. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
casenumber 15 - 15 n/a TKH-2012-000… n/a n/a n/a TKH-2020-000… 23,994 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 525 ( 2.2% )
Table 41. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
casenumber
100.00%
2.19%
TKH-2014-000454 TKH-2016-000451

Completeness

Figure 15. Visualization of completeness of the data in the column.

Uniqueness

Figure 16. Visualization of uniqueness of the data in the column.

Column: disease

Table 42. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name disease
Description

Name of the disease.

Data type String
Descriptor pms:disease [UID:0.0.HNYBD375]
Descriptor description

‘disease’ means the occurrence of infections and infestations in animals, with or without clinical or pathological manifestations, caused by one or more disease agents;

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.HNYBD375
Unit

n/a

Table 43. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
disease 32 - 32 n/a American fou… n/a n/a n/a American fou… 23,994 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
Table 44. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
disease
100.00%
0.00%
American foulbrood of honey bees American foulbrood of honey bees

Data Distribution Top 20

Figure 17. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 18. Visualization of completeness of the data in the column.

Uniqueness

Figure 19. Visualization of uniqueness of the data in the column.

Column: item

Table 45. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name item
Description

Description of the reported item.

Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a

Table 46. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
item 13 - 42 n/a Dead colonie… n/a n/a n/a Susceptible… 23,994 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 6 ( 0.0% )
Table 47. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
item
100.00%
0.03%
Susceptible livestock at start of outbreak Susceptible livestock at start of outbreak

Data Distribution Top 20

Figure 20. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 21. Visualization of completeness of the data in the column.

Uniqueness

Figure 22. Visualization of uniqueness of the data in the column.

Column: datestart

Table 48. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name datestart
Description

Date of establishment of a quarantine area. Official start of outbreak.

Data type Date
Descriptor pms:startDate [UID:0.0.STRTD805]
Descriptor description

Calendar date in which a dwc:Event starts.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.STRTD805
Unit

n/a

Table 49. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
datestart 10 - 10 2,016.0 2012-03-20 2,015 2,016 2,017 2020-03-30 23,994 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 344 ( 1.4% )
Table 50. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
datestart
100.00%
1.43%
2016-05-25 2016-04-29

Outliers

Figure 23. Visualization of median, min, max, and outliers in the column.
No data available.

Completeness

Figure 24. Visualization of completeness of the data in the column.

Uniqueness

Figure 25. Visualization of uniqueness of the data in the column.

Column: dateend

Table 51. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name dateend
Description

Date of lifting of a quarantine area. Official end of outbreak.

Data type Date
Descriptor pms:endDate [UID:0.0.NDDTE806]
Descriptor description

Calendar date in which a dwc:Event ends.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NDDTE806
Unit

n/a

Table 52. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
dateend 0 - 10 2,017.0 2015-01-15 2,016 2,016 2,018 2019-11-25 23,994 20,760 ( 86.5% ) 0 ( 0.0% ) 0 ( 0.0% ) 221 ( 0.9% )
Table 53. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
dateend
13.48%
0.92%
null 2018-05-07

Outliers

Figure 26. Visualization of median, min, max, and outliers in the column.
No data available.

Completeness

Figure 27. Visualization of completeness of the data in the column.

Uniqueness

Figure 28. Visualization of uniqueness of the data in the column.

Column: districtcode

Table 54. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name districtcode
Description

Official code of the district (Politischer Bezirk) in which the notified outbreak occurred.

Data type Integer number
Descriptor eurostat:PoliticalDistrictID [UID:0.0.PLTCL128]
Descriptor description

A district (German: Bezirk) is a second-level division of the executive arm of the Austrian government. District offices are the primary point of contact between residents and the state for most acts of government that exceed municipal purview: marriage licenses, driver licenses, passports, assembly permits, hunting permits, or dealings with public health officers for example all involve interaction with the district administrative authority (Bezirksverwaltungsbehörde).

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.PLTCL128
Unit

n/a

Table 55. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
districtcode 3 - 3 489.9 106 323 504 616 900 23,994 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 70 ( 0.3% )
Table 56. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
districtcode
100.00%
0.29%
614 106

Data Distribution Top 20

Figure 29. Distribution of 20 most common values, from highest to lowest.

Data Distribution Bottom 20

Figure 30. Distribution of 20 least common values, from lowest to highest.

Outliers

Figure 31. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 32. Visualization of completeness of the data in the column.

Uniqueness

Figure 33. Visualization of uniqueness of the data in the column.

Column: unit

Table 57. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name unit
Description

Unit in which the value is reported.

Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a

Table 58. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
unit 6 - 6 n/a number n/a n/a n/a number 23,994 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
Table 59. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
unit
100.00%
0.00%
number number

Data Distribution Top 20

Figure 34. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 35. Visualization of completeness of the data in the column.

Uniqueness

Figure 36. Visualization of uniqueness of the data in the column.

Column: value

Table 60. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name value
Description

Reported value.

Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

no.

Table 61. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
value 1 - 3 2.5 0 0 0 2 113 23,994 0 ( 0.0% ) 14,998 ( 62.5% ) 0 ( 0.0% ) 46 ( 0.2% )
Table 62. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
value
100.00%
0.19%
0 48

Data Distribution Top 20

Figure 37. Distribution of 20 most common values, from highest to lowest.

Data Distribution Bottom 20

Figure 38. Distribution of 20 least common values, from lowest to highest.

Completeness

Figure 39. Visualization of completeness of the data in the column.

Uniqueness

Figure 40. Visualization of uniqueness of the data in the column.

Column: annotation

Table 63. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name annotation
Description

Detailed annotation to the value.

Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a

Table 64. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
annotation 0 - 130 n/a n/a n/a n/a Corrected fr… 23,994 23,991 ( 100.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 4 ( 0.0% )
Table 65. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
annotation
0.01%
0.02%
null Corrected from 10000 to 1. Michael Rubinigg 05.07.2021. Reason: value obviously wrong, replaced by the most plausible real value.

Data Distribution Top 20

Figure 41. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 42. Visualization of completeness of the data in the column.

Uniqueness

Figure 43. Visualization of uniqueness of the data in the column.

Column: sourceId

Table 66. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name sourceId
Description

Reference to the data source.

Data type Integer number
Descriptor Source ID [UID:VTCSS14.0.SRCDA377]
Descriptor description

Links to the source from which the reported value in a record was obtained.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/VTCSS14.0.SRCDA377
Unit

n/a

Table 67. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
sourceId 1 - 2 31.9 1 15 32 50 61 23,994 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 61 ( 0.3% )
Table 68. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
sourceId
100.00%
0.25%
59 43

Data Distribution Top 20

Figure 44. Distribution of 20 most common values, from highest to lowest.

Data Distribution Bottom 20

Figure 45. Distribution of 20 least common values, from lowest to highest.

Outliers

Figure 46. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 47. Visualization of completeness of the data in the column.

Uniqueness

Figure 48. Visualization of uniqueness of the data in the column.

Table: Vetcaseat

Column: id

Table 69. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name id
Description

Identifier of the record.

Data type String
Descriptor pms:recordID [UID:0.0.RCRDD344]
Descriptor description

Unique sequence of integers associated with a record within a certain table.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.RCRDD344
Unit

n/a

Table 70. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
id 1 - 3 257.0 1 128.5 257 385.5 513 513 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 513 ( 100.0% )
Table 71. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
id
100.00%
100.00%
1 1

Continuous Data Distribution

Figure 49. Distribution of values in the column.

Outliers

Figure 50. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 51. Visualization of completeness of the data in the column.

Uniqueness

Figure 52. Visualization of uniqueness of the data in the column.

Column: year

Table 72. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name year
Description

Reporting period (calendar year).

Data type Integer number
Descriptor dwc:year [UID:0.0.YEARA340]
Descriptor description

A term from the Darwin Core standard:

The four-digit year in which the dwc:Event occurred, according to the Common Era Calendar.

Descriptor target IRI http://rs.tdwg.org/dwc/terms/year
Unit

year

Table 73. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
year 4 - 4 2,017.3 2,015 2,016 2,017 2,019 2,022 513 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 8 ( 1.6% )
Table 74. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
year
100.00%
1.56%
2016 2020

Data Distribution Top 20

Figure 53. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 54. Distribution of values in the column.

Outliers

Figure 55. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 56. Visualization of completeness of the data in the column.

Uniqueness

Figure 57. Visualization of uniqueness of the data in the column.

Column: month

Table 75. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name month
Description

Reporting period (calendar month).

Data type Integer number
Descriptor iso-8601:calendarMonth [UID:0.0.CLNDR376]
Descriptor description

time scale unit [...] resulting from a defined division of a calendar year [...], each containing a specific number of calendar days [...] Note 1 to entry: A calendar month is in common parlance often referred to as month, however in this document calendar month and month have different definitions.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.CLNDR376
Unit

n/a

Table 76. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
month 1 - 2 6.3 1 5 6 8 12 513 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 12 ( 2.3% )
Table 77. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
month
100.00%
2.34%
5 12

Data Distribution Top 20

Figure 58. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 59. Distribution of values in the column.

Outliers

Figure 60. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 61. Visualization of completeness of the data in the column.

Uniqueness

Figure 62. Visualization of uniqueness of the data in the column.

Column: casenumber

Table 78. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name casenumber
Description

Case number adopted by BMSGPK.

Data type String
Descriptor casenumber [UID:VTCSS14.0.CSNMB379]
Descriptor description

Case number adopted by the Austrian Federal Ministry of Social Affairs, Health, Care and Consumer Protection (Bundesministerium für Soziales, Gesundheit, Pflege und Konsumentenschutz, BMSGPK).

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/VTCSS14.0.CSNMB379
Unit

n/a

Table 79. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
casenumber 0 - 15 n/a n/a n/a n/a TKH-2020-000… 513 53 ( 10.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 461 ( 89.9% )
Table 80. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
casenumber
89.67%
89.86%
null TKH-2014-000443

Completeness

Figure 63. Visualization of completeness of the data in the column.

Uniqueness

Figure 64. Visualization of uniqueness of the data in the column.

Column: disease

Table 81. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name disease
Description

Name of the disease.

Data type String
Descriptor pms:disease [UID:0.0.HNYBD375]
Descriptor description

‘disease’ means the occurrence of infections and infestations in animals, with or without clinical or pathological manifestations, caused by one or more disease agents;

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.HNYBD375
Unit

n/a

Table 82. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
disease 32 - 94 n/a American fou… n/a n/a n/a Varroosis in… 513 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 0.4% )
Table 83. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
disease
100.00%
0.39%
American foulbrood of honey bees Varroosis in the case of imminent or actual death of at least 30% of the colonies in an apiary

Data Distribution Top 20

Figure 65. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 66. Visualization of completeness of the data in the column.

Uniqueness

Figure 67. Visualization of uniqueness of the data in the column.

Column: animalspecies

Table 84. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name animalspecies
Description

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/, which points to a taxonomic rank.

Data type Integer number
Descriptor pms:gbifTaxonID [UID:0.0.GBFTX336]
Descriptor description

The taxonID used by the the Global Biodiversity Information Facility (GBIF), an international network and data infrastructure aimed at providing open access to data about all types of life on Earth.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.GBFTX336
Unit

n/a

Table 85. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
animalspecies 7 - 7 1,341,976.0 1,341,976 1,341,976 1,341,976 1,341,976 1,341,976 513 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.2% )
Table 86. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
animalspecies
100.00%
0.19%
1341976 1341976

Data Distribution Top 20

Figure 68. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 69. Distribution of values in the column.

Outliers

Figure 70. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 71. Visualization of completeness of the data in the column.

Uniqueness

Figure 72. Visualization of uniqueness of the data in the column.

Column: datestart

Table 87. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name datestart
Description

Date of establishment of a quarantine area. Official start of outbreak.

Data type Date
Descriptor pms:startDate [UID:0.0.STRTD805]
Descriptor description

Calendar date in which a dwc:Event starts.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.STRTD805
Unit

n/a

Table 88. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
datestart 0 - 10 2,017.0 2015-01-07 2,016 2,016 2,018 2020-03-30 513 53 ( 10.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 298 ( 58.1% )
Table 89. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
datestart
89.67%
58.09%
null 2015-01-07

Outliers

Figure 73. Visualization of median, min, max, and outliers in the column.
No data available.

Completeness

Figure 74. Visualization of completeness of the data in the column.

Uniqueness

Figure 75. Visualization of uniqueness of the data in the column.

Column: dateend

Table 90. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name dateend
Description

Date of lifting of a quarantine area. Official end of outbreak.

Data type Date
Descriptor pms:endDate [UID:0.0.NDDTE806]
Descriptor description

Calendar date in which a dwc:Event ends.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NDDTE806
Unit

n/a

Table 91. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
dateend 0 - 10 2,017.0 2015-04-08 2,016 2,017 2,018 2019-11-25 513 157 ( 30.6% ) 0 ( 0.0% ) 0 ( 0.0% ) 193 ( 37.6% )
Table 92. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
dateend
69.40%
37.62%
null 2015-05-04

Outliers

Figure 76. Visualization of median, min, max, and outliers in the column.
No data available.

Completeness

Figure 77. Visualization of completeness of the data in the column.

Uniqueness

Figure 78. Visualization of uniqueness of the data in the column.

Column: country

Table 93. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name country
Description

ISO 3166-1 alpha-3 code of the country in which the notified outbreak occurred.

Data type String
Descriptor iso-3166:alpha-3CountryCode [UID:0.0.LPHCN5]
Descriptor description

A three-letter code that represents a country name, which is usually more closely related to the country name.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LPHCN5
Unit

n/a

Table 94. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
country 3 - 3 n/a AUT n/a n/a n/a AUT 513 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.2% )
Table 95. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
country
100.00%
0.19%
AUT AUT

Data Distribution Top 20

Figure 79. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 80. Visualization of completeness of the data in the column.

Uniqueness

Figure 81. Visualization of uniqueness of the data in the column.

Column: nuts

Table 96. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name nuts
Description

Nuts code of the geographic entity in which the notified outbreak occurred.

Data type String
Descriptor eurostat:nuts2021Code [UID:0.0.NTSCD55]
Descriptor description

A NUTS code defined in the NUTS classification 2021, valid from 2021-01-01 to 2023-12-31, containing 92 regions at NUTS level 1, 244 regions at NUTS level 2 and 1165 regions at NUTS level 3 level.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTSCD55
Unit

n/a

Table 97. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
nuts 4 - 4 n/a AT11 n/a n/a n/a AT34 513 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 9 ( 1.8% )
Table 98. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
nuts
100.00%
1.75%
AT12 AT13

Data Distribution Top 20

Figure 82. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 83. Visualization of completeness of the data in the column.

Uniqueness

Figure 84. Visualization of uniqueness of the data in the column.

Column: districtcode

Table 99. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name districtcode
Description

Official code of the district (Politischer Bezirk) in which the notified outbreak occurred.

Data type Integer number
Descriptor eurostat:PoliticalDistrictID [UID:0.0.PLTCL128]
Descriptor description

A district (German: Bezirk) is a second-level division of the executive arm of the Austrian government. District offices are the primary point of contact between residents and the state for most acts of government that exceed municipal purview: marriage licenses, driver licenses, passports, assembly permits, hunting permits, or dealings with public health officers for example all involve interaction with the district administrative authority (Bezirksverwaltungsbehörde).

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.PLTCL128
Unit

n/a

Table 100. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
districtcode 3 - 3 489.6 106 323 504 620 900 513 53 ( 10.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 68 ( 13.3% )
Table 101. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
districtcode
89.67%
13.26%
504 307

Continuous Data Distribution

Figure 85. Distribution of values in the column.

Outliers

Figure 86. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 87. Visualization of completeness of the data in the column.

Uniqueness

Figure 88. Visualization of uniqueness of the data in the column.

Column: unit

Table 102. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name unit
Description

Unit in which the value is reported.

Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a

Table 103. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
unit 6 - 6 n/a number n/a n/a n/a number 513 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.2% )
Table 104. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
unit
100.00%
0.19%
number number

Data Distribution Top 20

Figure 89. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 90. Visualization of completeness of the data in the column.

Uniqueness

Figure 91. Visualization of uniqueness of the data in the column.

Column: value

Table 105. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name value
Description

Number of notified outbreaks (on an apiary basis) per district (Politischer Bezirk) or NUTS2 region (if district is NULL) and month.

Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

no.

Table 106. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
value 1 - 2 1.1 1 1 1 1 11 513 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 8 ( 1.6% )
Table 107. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
value
100.00%
1.56%
1 5

Data Distribution Top 20

Figure 92. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 93. Distribution of values in the column.

Outliers

Figure 94. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 95. Visualization of completeness of the data in the column.

Uniqueness

Figure 96. Visualization of uniqueness of the data in the column.

Column: annotation

Table 108. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name annotation
Description

Detailed annotation to the value.

Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a

Table 109. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
annotation 0 - 0 n/a n/a n/a n/a 513 513 ( 100.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.2% )
Table 110. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
annotation
0.00%
0.19%
null null

Data Distribution Top 20

Figure 97. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 98. Visualization of completeness of the data in the column.

Uniqueness

Figure 99. Visualization of uniqueness of the data in the column.

Column: sourceid

Table 111. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name sourceid
Description

Reference to the data source.

Data type Integer number
Descriptor Source ID [UID:VTCSS14.0.SRCDA377]
Descriptor description

Links to the source from which the reported value in a record was obtained.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/VTCSS14.0.SRCDA377
Unit

n/a

Table 112. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
sourceid 1 - 2 46.8 1 33 56 61 80 513 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 52 ( 10.1% )
Table 113. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
sourceid
100.00%
10.14%
61 4

Continuous Data Distribution

Figure 100. Distribution of values in the column.

Outliers

Figure 101. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 102. Visualization of completeness of the data in the column.

Uniqueness

Figure 103. Visualization of uniqueness of the data in the column.

Table: Vetcasebe

Column: id

Table 114. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name id
Description

Identifier of the record.

Data type String
Descriptor pms:recordID [UID:0.0.RCRDD344]
Descriptor description

Unique sequence of integers associated with a record within a certain table.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.RCRDD344
Unit

n/a

Table 115. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
id 3 - 3 555.5 514 534.25 555.5 576.75 597 84 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 84 ( 100.0% )
Table 116. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
id
100.00%
100.00%
514 514

Continuous Data Distribution

Figure 104. Distribution of values in the column.

Outliers

Figure 105. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 106. Visualization of completeness of the data in the column.

Uniqueness

Figure 107. Visualization of uniqueness of the data in the column.

Column: year

Table 117. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name year
Description

Reporting period (calendar year).

Data type Integer number
Descriptor dwc:year [UID:0.0.YEARA340]
Descriptor description

A term from the Darwin Core standard:

The four-digit year in which the dwc:Event occurred, according to the Common Era Calendar.

Descriptor target IRI http://rs.tdwg.org/dwc/terms/year
Unit

year

Table 118. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
year 4 - 4 2,018.1 2,006 2,018 2,019 2,020 2,022 84 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 17 ( 20.2% )
Table 119. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
year
100.00%
20.24%
2020 2006

Continuous Data Distribution

Figure 108. Distribution of values in the column.

Outliers

Figure 109. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 110. Visualization of completeness of the data in the column.

Uniqueness

Figure 111. Visualization of uniqueness of the data in the column.

Column: month

Table 120. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name month
Description

Reporting period (calendar month).

Data type Integer number
Descriptor iso-8601:calendarMonth [UID:0.0.CLNDR376]
Descriptor description

time scale unit [...] resulting from a defined division of a calendar year [...], each containing a specific number of calendar days [...] Note 1 to entry: A calendar month is in common parlance often referred to as month, however in this document calendar month and month have different definitions.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.CLNDR376
Unit

n/a

Table 121. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
month 1 - 2 6.8 4 6 7 8 11 84 12 ( 14.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 8 ( 9.5% )
Table 122. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
month
85.71%
9.52%
7 11

Data Distribution Top 20

Figure 112. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 113. Distribution of values in the column.

Outliers

Figure 114. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 115. Visualization of completeness of the data in the column.

Uniqueness

Figure 116. Visualization of uniqueness of the data in the column.

Column: disease

Table 123. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name disease
Description

Name of the disease.

Data type String
Descriptor pms:disease [UID:0.0.HNYBD375]
Descriptor description

‘disease’ means the occurrence of infections and infestations in animals, with or without clinical or pathological manifestations, caused by one or more disease agents;

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.HNYBD375
Unit

n/a

Table 124. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
disease 32 - 32 n/a American fou… n/a n/a n/a European fou… 84 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 2.4% )
Table 125. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
disease
100.00%
2.38%
American foulbrood of honey bees European foulbrood of honey bees

Data Distribution Top 20

Figure 117. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 118. Visualization of completeness of the data in the column.

Uniqueness

Figure 119. Visualization of uniqueness of the data in the column.

Column: animalspecies

Table 126. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name animalspecies
Description

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/, which points to a taxonomic rank.

Data type Integer number
Descriptor pms:gbifTaxonID [UID:0.0.GBFTX336]
Descriptor description

The taxonID used by the the Global Biodiversity Information Facility (GBIF), an international network and data infrastructure aimed at providing open access to data about all types of life on Earth.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.GBFTX336
Unit

n/a

Table 127. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
animalspecies 7 - 7 1,341,976.0 1,341,976 1,341,976 1,341,976 1,341,976 1,341,976 84 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 1.2% )
Table 128. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
animalspecies
100.00%
1.19%
1341976 1341976

Data Distribution Top 20

Figure 120. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 121. Distribution of values in the column.

Outliers

Figure 122. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 123. Visualization of completeness of the data in the column.

Uniqueness

Figure 124. Visualization of uniqueness of the data in the column.

Column: datestart

Table 129. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name datestart
Description

Date of establishment of a quarantine area. Official start of outbreak.

Data type Date
Descriptor pms:startDate [UID:0.0.STRTD805]
Descriptor description

Calendar date in which a dwc:Event starts.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.STRTD805
Unit

n/a

Table 130. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
datestart 0 - 10 2,019.0 2014-06-05 2,018 2,019 2,020 2022-08-30 84 12 ( 14.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 59 ( 70.2% )
Table 131. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
datestart
85.71%
70.24%
null 2014-06-05

Outliers

Figure 125. Visualization of median, min, max, and outliers in the column.
No data available.

Completeness

Figure 126. Visualization of completeness of the data in the column.

Uniqueness

Figure 127. Visualization of uniqueness of the data in the column.

Column: dateend

Table 132. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name dateend
Description

Date of lifting of a quarantine area. Official end of outbreak.

Data type Date
Descriptor pms:endDate [UID:0.0.NDDTE806]
Descriptor description

Calendar date in which a dwc:Event ends.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NDDTE806
Unit

n/a

Table 133. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
dateend 0 - 10 2,020.0 2014-08-06 2,019 2,020 2,021 2022-11-26 84 15 ( 17.9% ) 0 ( 0.0% ) 0 ( 0.0% ) 27 ( 32.1% )
Table 134. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
dateend
82.14%
32.14%
null 2014-08-06

Outliers

Figure 128. Visualization of median, min, max, and outliers in the column.
No data available.

Completeness

Figure 129. Visualization of completeness of the data in the column.

Uniqueness

Figure 130. Visualization of uniqueness of the data in the column.

Column: country

Table 135. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name country
Description

ISO 3166-1 alpha-3 code of the country in which the notified outbreak occurred.

Data type String
Descriptor iso-3166:alpha-3CountryCode [UID:0.0.LPHCN5]
Descriptor description

A three-letter code that represents a country name, which is usually more closely related to the country name.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LPHCN5
Unit

n/a

Table 136. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
country 3 - 3 n/a BEL n/a n/a n/a BEL 84 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 1.2% )
Table 137. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
country
100.00%
1.19%
BEL BEL

Data Distribution Top 20

Figure 131. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 132. Visualization of completeness of the data in the column.

Uniqueness

Figure 133. Visualization of uniqueness of the data in the column.

Column: nuts

Table 138. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name nuts
Description

Nuts code of the geographic entity in which the notified outbreak occurred.

Data type String
Descriptor eurostat:nuts2021Code [UID:0.0.NTSCD55]
Descriptor description

A NUTS code defined in the NUTS classification 2021, valid from 2021-01-01 to 2023-12-31, containing 92 regions at NUTS level 1, 244 regions at NUTS level 2 and 1165 regions at NUTS level 3 level.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTSCD55
Unit

n/a

Table 139. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
nuts 2 - 5 n/a BE n/a n/a n/a BE353 84 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 19 ( 22.6% )
Table 140. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
nuts
100.00%
22.62%
BE323 BE221

Completeness

Figure 134. Visualization of completeness of the data in the column.

Uniqueness

Figure 135. Visualization of uniqueness of the data in the column.

Column: postcode

Table 141. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name postcode
Description

Postcode of the location in which the notified outbreak occurred.

Data type String
Descriptor eurostat:postcode [UID:0.0.PSTCD378]
Descriptor description

A postal code (also known locally in various English-speaking countries throughout the world as a postcode, post code, PIN or ZIP Code) is a series of letters or digits or both, sometimes including spaces or punctuation, included in a postal address for the purpose of sorting mail.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.PSTCD378
Unit

n/a

Table 142. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
postcode 4 - 4 6,327.6 1,549 6,180 6,740 7,332 9,255 84 12 ( 14.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 34 ( 40.5% )
Table 143. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
postcode
85.71%
40.48%
6280 7973

Continuous Data Distribution

Figure 136. Distribution of values in the column.

Outliers

Figure 137. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 138. Visualization of completeness of the data in the column.

Uniqueness

Figure 139. Visualization of uniqueness of the data in the column.

Column: unit

Table 144. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name unit
Description

Unit in which the value is reported.

Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a

Table 145. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
unit 6 - 6 n/a number n/a n/a n/a number 84 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 1.2% )
Table 146. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
unit
100.00%
1.19%
number number

Data Distribution Top 20

Figure 140. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 141. Visualization of completeness of the data in the column.

Uniqueness

Figure 142. Visualization of uniqueness of the data in the column.

Column: value

Table 147. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name value
Description

Number of notified outbreaks (on an apiary basis) per postcode or NUTS region (if postcode is NULL) and month or year (if month is NULL).

Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

no.

Table 148. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
value 1 - 2 1.8 0 1 1 1 36 84 0 ( 0.0% ) 3 ( 3.6% ) 0 ( 0.0% ) 9 ( 10.7% )
Table 149. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
value
100.00%
10.71%
1 5

Data Distribution Top 20

Figure 143. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 144. Distribution of values in the column.

Outliers

Figure 145. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 146. Visualization of completeness of the data in the column.

Uniqueness

Figure 147. Visualization of uniqueness of the data in the column.

Column: annotation

Table 150. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name annotation
Description

Detailed annotation to the value.

Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a

Table 151. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
annotation 0 - 0 n/a n/a n/a n/a 84 84 ( 100.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 1.2% )
Table 152. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
annotation
0.00%
1.19%
null null

Data Distribution Top 20

Figure 148. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 149. Visualization of completeness of the data in the column.

Uniqueness

Figure 150. Visualization of uniqueness of the data in the column.

Column: sourceid

Table 153. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name sourceid
Description

Reference to the data source.

Data type Integer number
Descriptor Source ID [UID:VTCSS14.0.SRCDA377]
Descriptor description

Links to the source from which the reported value in a record was obtained.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/VTCSS14.0.SRCDA377
Unit

n/a

Table 154. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
sourceid 2 - 2 78.1 78 78 78 78 79 84 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 2.4% )
Table 155. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
sourceid
100.00%
2.38%
78 79

Data Distribution Top 20

Figure 151. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 152. Distribution of values in the column.

Outliers

Figure 153. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 154. Visualization of completeness of the data in the column.

Uniqueness

Figure 155. Visualization of uniqueness of the data in the column.

Table: Vetcasesat22

Column: id

Table 156. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name id
Description

Identifier of the record.

Data type String
Descriptor pms:recordID [UID:0.0.RCRDD344]
Descriptor description

Unique sequence of integers associated with a record within a certain table.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.RCRDD344
Unit

n/a

Table 157. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
id 1 - 3 234.5 1 117.25 234.5 351.75 469 468 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 468 ( 100.0% )
Table 158. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
id
100.00%
100.00%
1 1

Continuous Data Distribution

Figure 156. Distribution of values in the column.

Outliers

Figure 157. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 158. Visualization of completeness of the data in the column.

Uniqueness

Figure 159. Visualization of uniqueness of the data in the column.

Column: disease

Table 159. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name disease
Description

Name of the disease.

Data type String
Descriptor pms:disease [UID:0.0.HNYBD375]
Descriptor description

‘disease’ means the occurrence of infections and infestations in animals, with or without clinical or pathological manifestations, caused by one or more disease agents;

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.HNYBD375
Unit

n/a

Table 160. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
disease 32 - 32 n/a American fou… n/a n/a n/a American fou… 468 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.2% )
Table 161. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
disease
100.00%
0.21%
American foulbrood of honey bees American foulbrood of honey bees

Data Distribution Top 20

Figure 160. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 161. Visualization of completeness of the data in the column.

Uniqueness

Figure 162. Visualization of uniqueness of the data in the column.

Column: municipalitycode

Table 162. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name municipalitycode
Description

Official code of the municipality (Gemeindekennziffer) in which the notified outbreak occurred.

Data type Integer number
Descriptor eurostat:MunicipalityCode [UID:0.0.MNCPL132]
Descriptor description

A term from the Darwin Core standard:

The full, unabbreviated name of the next smaller administrative region than county (city, municipality, etc.) in which the dcterms:Location occurs. Do not use this term for a nearby named place that does not contain the actual dcterms:Location.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MNCPL132
Unit

n/a

Table 163. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
municipalitycode 5 - 5 61,541.0 60,101 61,141.25 61,443.5 62,131 62,390 468 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 137 ( 29.3% )
Table 164. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
municipalitycode
100.00%
29.27%
61757 61053

Continuous Data Distribution

Figure 163. Distribution of values in the column.

Outliers

Figure 164. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 165. Visualization of completeness of the data in the column.

Uniqueness

Figure 166. Visualization of uniqueness of the data in the column.

Column: wgs84e

Table 165. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name wgs84e
Description

Longitude of the position of the affected apiary in WGS 84 format.

Data type Decimal number
Descriptor dwc:decimalLongitude [UID:0.0.LNGTD332]
Descriptor description

A term from the Darwin Core standard:

The geographic longitude (in decimal degrees, using the spatial reference system given in dwc:geodeticDatum) of the geographic center of a dcterms:Location. Positive values are east of the Greenwich Meridian, negative values are west of it. Legal values lie between -180 and 180, inclusive.

Descriptor target IRI http://rs.tdwg.org/dwc/terms/decimalLongitude
Unit

°

Table 166. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
wgs84e 5 - 5 15.138 13.83 14.51 15.41 15.67 16.04 468 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 168 ( 35.9% )
Table 167. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
wgs84e
100.00%
35.90%
15.49 15.90

Continuous Data Distribution

Figure 167. Distribution of values in the column.

Outliers

Figure 168. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 169. Visualization of completeness of the data in the column.

Uniqueness

Figure 170. Visualization of uniqueness of the data in the column.

Column: wgs84n

Table 168. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name wgs84n
Description

Latitude of the position of the affected apiary in WGS 84 format.

Data type Decimal number
Descriptor dwc:decimalLatitude [UID:0.0.LTTDE333]
Descriptor description

A term from the Darwin Core standard:

The geographic latitude (in decimal degrees, using the spatial reference system given in dwc:geodeticDatum) of the geographic center of a dcterms:Location. Positive values are north of the Equator, negative values are south of it. Legal values lie between -90 and 90, inclusive.

Descriptor target IRI http://rs.tdwg.org/dwc/terms/decimalLatitude
Unit

°

Table 169. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
wgs84n 5 - 5 47.260 46.62 47.09 47.32 47.47 47.72 468 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 90 ( 19.2% )
Table 170. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
wgs84n
100.00%
19.23%
47.41 46.95

Continuous Data Distribution

Figure 171. Distribution of values in the column.

Outliers

Figure 172. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 173. Visualization of completeness of the data in the column.

Uniqueness

Figure 174. Visualization of uniqueness of the data in the column.

Column: bedatestart

Table 171. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name bedatestart
Description

Date of the administrative ruling (Bescheid) by which the apiary affected by a notifiable disease is put into quarantine.

Data type Date
Descriptor pms:startDate [UID:0.0.STRTD805]
Descriptor description

Calendar date in which a dwc:Event starts.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.STRTD805
Unit

n/a

Table 172. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
bedatestart 10 - 10 2,010.0 2000-05-17 2,006 2,011 2,014 2022-07-05 468 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 317 ( 67.7% )
Table 173. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
bedatestart
100.00%
67.74%
2001-05-17 2012-04-12

Outliers

Figure 175. Visualization of median, min, max, and outliers in the column.
No data available.

Completeness

Figure 176. Visualization of completeness of the data in the column.

Uniqueness

Figure 177. Visualization of uniqueness of the data in the column.

Column: begzstart

Table 174. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name begzstart
Description

Reference number of the administrative ruling (Bescheid) by which the apiary affected by a notifiable disease is put into quarantine.

Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a

Table 175. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
begzstart 8 - 50 n/a 8-122-02 n/a n/a n/a 8.2-30/2014,… 468 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 331 ( 70.7% )
Table 176. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
begzstart
100.00%
70.73%
not available 18.9.R1/2011-12

Completeness

Figure 178. Visualization of completeness of the data in the column.

Uniqueness

Figure 179. Visualization of uniqueness of the data in the column.

Column: bedateend

Table 177. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name bedateend
Description

Date of the administrative ruling (Bescheid) by which the apiary affected by a notifiable disease is released from quarantine.

Data type Date
Descriptor pms:endDate [UID:0.0.NDDTE806]
Descriptor description

Calendar date in which a dwc:Event ends.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NDDTE806
Unit

n/a

Table 178. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
bedateend 0 - 10 2,010.0 2000-10-02 2,006 2,011 2,014 2022-07-22 468 21 ( 4.5% ) 0 ( 0.0% ) 0 ( 0.0% ) 255 ( 54.5% )
Table 179. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
bedateend
95.51%
54.49%
null 2012-05-25

Outliers

Figure 180. Visualization of median, min, max, and outliers in the column.
No data available.

Completeness

Figure 181. Visualization of completeness of the data in the column.

Uniqueness

Figure 182. Visualization of uniqueness of the data in the column.

Column: begzend

Table 180. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name begzend
Description

Reference number of the administrative ruling (Bescheid) by which the apiary affected by a notifiable disease is released from quarantine.

Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a

Table 181. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
begzend 0 - 36 n/a n/a n/a n/a 18.2B6/Bi1/1… 468 21 ( 4.5% ) 0 ( 0.0% ) 0 ( 0.0% ) 315 ( 67.3% )
Table 182. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
begzend
95.51%
67.31%
not available 18.9.R1/2011-17

Completeness

Figure 183. Visualization of completeness of the data in the column.

Uniqueness

Figure 184. Visualization of uniqueness of the data in the column.

Column: vodatestart

Table 183. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name vodatestart
Description

Date of the regulation (Verordnung) establishing a quarantine zone around an apiary affected by a notifiable disease.

Data type Date
Descriptor pms:startDate [UID:0.0.STRTD805]
Descriptor description

Calendar date in which a dwc:Event starts.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.STRTD805
Unit

n/a

Table 184. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
vodatestart 0 - 10 2,012.0 2001-07-18 2,008 2,012 2,015 2022-07-12 468 213 ( 45.5% ) 0 ( 0.0% ) 0 ( 0.0% ) 182 ( 38.9% )
Table 185. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
vodatestart
54.49%
38.89%
null 2012-03-26

Outliers

Figure 185. Visualization of median, min, max, and outliers in the column.
No data available.

Completeness

Figure 186. Visualization of completeness of the data in the column.

Uniqueness

Figure 187. Visualization of uniqueness of the data in the column.

Column: vogzstart

Table 186. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name vogzstart
Description

Reference number of the regulation (Verordnung) establishing a quarantine zone around an apiary affected by a notifiable disease.

Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a

Table 187. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
vogzstart 0 - 50 n/a n/a n/a n/a 8.2-30/2014,… 468 213 ( 45.5% ) 0 ( 0.0% ) 0 ( 0.0% ) 224 ( 47.9% )
Table 188. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
vogzstart
54.49%
47.86%
null 18.9.R1/2011-12

Completeness

Figure 188. Visualization of completeness of the data in the column.

Uniqueness

Figure 189. Visualization of uniqueness of the data in the column.

Column: vodateend

Table 189. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name vodateend
Description

Date of the regulation (Verordnung) revoking a quarantine zone around an apiary affected by a notifiable disease.

Data type Date
Descriptor pms:endDate [UID:0.0.NDDTE806]
Descriptor description

Calendar date in which a dwc:Event ends.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NDDTE806
Unit

n/a

Table 190. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
vodateend 0 - 10 2,012.0 2002-05-28 2,008 2,012 2,016 2022-07-22 468 230 ( 49.1% ) 0 ( 0.0% ) 0 ( 0.0% ) 141 ( 30.1% )
Table 191. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
vodateend
50.85%
30.13%
null 2012-05-25

Outliers

Figure 190. Visualization of median, min, max, and outliers in the column.
No data available.

Completeness

Figure 191. Visualization of completeness of the data in the column.

Uniqueness

Figure 192. Visualization of uniqueness of the data in the column.

Column: vogzend

Table 192. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name vogzend
Description

Reference number of the regulation (Verordnung) revoking a quarantine zone around an apiary affected by a notifiable disease.

Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a

Table 193. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
vogzend 0 - 37 n/a n/a n/a n/a 8.2-21/0213,… 468 228 ( 48.7% ) 0 ( 0.0% ) 0 ( 0.0% ) 150 ( 32.1% )
Table 194. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
vogzend
51.28%
32.05%
null 18.2-6/2012

Completeness

Figure 193. Visualization of completeness of the data in the column.

Uniqueness

Figure 194. Visualization of uniqueness of the data in the column.

Column: annotation

Table 195. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name annotation
Description

Detailed annotation to the record.

Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a

Table 196. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
annotation 0 - 0 n/a n/a n/a n/a 468 468 ( 100.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.2% )
Table 197. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
annotation
0.00%
0.21%
null null

Data Distribution Top 20

Figure 195. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 196. Visualization of completeness of the data in the column.

Uniqueness

Figure 197. Visualization of uniqueness of the data in the column.

Table: Vetcase

Column: id

Table 198. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name id
Description

Identifier of the record.

Data type String
Descriptor pms:recordID [UID:0.0.RCRDD344]
Descriptor description

Unique sequence of integers associated with a record within a certain table.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.RCRDD344
Unit

n/a

Table 199. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
id 1 - 3 299.0 1 149.5 299 448.5 597 597 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 597 ( 100.0% )
Table 200. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
id
100.00%
100.00%
1 1

Continuous Data Distribution

Figure 198. Distribution of values in the column.

Outliers

Figure 199. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 200. Visualization of completeness of the data in the column.

Uniqueness

Figure 201. Visualization of uniqueness of the data in the column.

Column: year

Table 201. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name year
Description

Reporting period (calendar year).

Data type Integer number
Descriptor dwc:year [UID:0.0.YEARA340]
Descriptor description

A term from the Darwin Core standard:

The four-digit year in which the dwc:Event occurred, according to the Common Era Calendar.

Descriptor target IRI http://rs.tdwg.org/dwc/terms/year
Unit

year

Table 202. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
year 4 - 4 2,017.4 2,006 2,016 2,017 2,019 2,022 597 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 17 ( 2.8% )
Table 203. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
year
100.00%
2.85%
2016 2006

Data Distribution Top 20

Figure 202. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 203. Distribution of values in the column.

Outliers

Figure 204. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 205. Visualization of completeness of the data in the column.

Uniqueness

Figure 206. Visualization of uniqueness of the data in the column.

Column: month

Table 204. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name month
Description

Reporting period (calendar month).

Data type Integer number
Descriptor iso-8601:calendarMonth [UID:0.0.CLNDR376]
Descriptor description

time scale unit [...] resulting from a defined division of a calendar year [...], each containing a specific number of calendar days [...] Note 1 to entry: A calendar month is in common parlance often referred to as month, however in this document calendar month and month have different definitions.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.CLNDR376
Unit

n/a

Table 205. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
month 1 - 2 6.4 1 5 6 8 12 597 12 ( 2.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 13 ( 2.2% )
Table 206. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
month
97.99%
2.18%
7 12

Data Distribution Top 20

Figure 207. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 208. Distribution of values in the column.

Outliers

Figure 209. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 210. Visualization of completeness of the data in the column.

Uniqueness

Figure 211. Visualization of uniqueness of the data in the column.

Column: casenumber

Table 207. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name casenumber
Description

Case number adopted by BMSGPK.

Data type String
Descriptor casenumber [UID:VTCSS14.0.CSNMB379]
Descriptor description

Case number adopted by the Austrian Federal Ministry of Social Affairs, Health, Care and Consumer Protection (Bundesministerium für Soziales, Gesundheit, Pflege und Konsumentenschutz, BMSGPK).

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/VTCSS14.0.CSNMB379
Unit

n/a

Table 208. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
casenumber 0 - 15 n/a n/a n/a n/a TKH-2020-000… 597 137 ( 22.9% ) 0 ( 0.0% ) 0 ( 0.0% ) 461 ( 77.2% )
Table 209. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
casenumber
77.05%
77.22%
null TKH-2014-000443

Completeness

Figure 212. Visualization of completeness of the data in the column.

Uniqueness

Figure 213. Visualization of uniqueness of the data in the column.

Column: disease

Table 210. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name disease
Description

Name of the disease

Data type String
Descriptor pms:disease [UID:0.0.HNYBD375]
Descriptor description

‘disease’ means the occurrence of infections and infestations in animals, with or without clinical or pathological manifestations, caused by one or more disease agents;

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.HNYBD375
Unit

n/a

Table 211. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
disease 32 - 108 n/a American fou… n/a n/a n/a Varroosis of… 597 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3 ( 0.5% )
Table 212. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
disease
100.00%
0.50%
American foulbrood of honey bees Varroosis of honey bees in the case of imminent or actual death of at least 30% of the colonies in an apiary

Data Distribution Top 20

Figure 214. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 215. Visualization of completeness of the data in the column.

Uniqueness

Figure 216. Visualization of uniqueness of the data in the column.

Column: animalspecies

Table 213. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name animalspecies
Description

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/, which points to a taxonomic rank.

Data type Integer number
Descriptor pms:gbifTaxonID [UID:0.0.GBFTX336]
Descriptor description

The taxonID used by the the Global Biodiversity Information Facility (GBIF), an international network and data infrastructure aimed at providing open access to data about all types of life on Earth.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.GBFTX336
Unit

n/a

Table 214. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
animalspecies 7 - 7 1,341,976.0 1,341,976 1,341,976 1,341,976 1,341,976 1,341,976 597 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.2% )
Table 215. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
animalspecies
100.00%
0.17%
1341976 1341976

Data Distribution Top 20

Figure 217. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 218. Distribution of values in the column.

Outliers

Figure 219. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 220. Visualization of completeness of the data in the column.

Uniqueness

Figure 221. Visualization of uniqueness of the data in the column.

Column: datestart

Table 216. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name datestart
Description

Date of establishment of a quarantine area. Official start of outbreak.

Data type Date
Descriptor pms:startDate [UID:0.0.STRTD805]
Descriptor description

Calendar date in which a dwc:Event starts.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.STRTD805
Unit

n/a

Table 217. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
datestart 0 - 10 2,017.0 2014-06-05 2,016 2,017 2,019 2022-08-30 597 65 ( 10.9% ) 0 ( 0.0% ) 0 ( 0.0% ) 345 ( 57.8% )
Table 218. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
datestart
89.11%
57.79%
null 2015-01-07

Outliers

Figure 222. Visualization of median, min, max, and outliers in the column.
No data available.

Completeness

Figure 223. Visualization of completeness of the data in the column.

Uniqueness

Figure 224. Visualization of uniqueness of the data in the column.

Column: dateend

Table 219. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name dateend
Description

Date of lifting of a quarantine area. Official end of outbreak.

Data type Date
Descriptor pms:endDate [UID:0.0.NDDTE806]
Descriptor description

Calendar date in which a dwc:Event ends.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NDDTE806
Unit

n/a

Table 220. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
dateend 0 - 10 2,018.0 2014-08-06 2,016 2,017 2,019 2022-11-26 597 172 ( 28.8% ) 0 ( 0.0% ) 0 ( 0.0% ) 217 ( 36.3% )
Table 221. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
dateend
71.19%
36.35%
null 2015-05-04

Outliers

Figure 225. Visualization of median, min, max, and outliers in the column.
No data available.

Completeness

Figure 226. Visualization of completeness of the data in the column.

Uniqueness

Figure 227. Visualization of uniqueness of the data in the column.

Column: country

Table 222. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name country
Description

ISO 3166-1 alpha-3 code of the country in which the notified outbreak occurred.

Data type String
Descriptor iso-3166:alpha-3CountryCode [UID:0.0.LPHCN5]
Descriptor description

A three-letter code that represents a country name, which is usually more closely related to the country name.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.LPHCN5
Unit

n/a

Table 223. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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% )
Table 224. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
country
100.00%
0.34%
AUT BEL

Data Distribution Top 20

Figure 228. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 229. Visualization of completeness of the data in the column.

Uniqueness

Figure 230. Visualization of uniqueness of the data in the column.

Column: nuts

Table 225. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name nuts
Description

Nuts code of the geographic entity in which the notified outbreak occurred.

Data type String
Descriptor eurostat:nuts2021Code [UID:0.0.NTSCD55]
Descriptor description

A NUTS code defined in the NUTS classification 2021, valid from 2021-01-01 to 2023-12-31, containing 92 regions at NUTS level 1, 244 regions at NUTS level 2 and 1165 regions at NUTS level 3 level.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTSCD55
Unit

n/a

Table 226. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
nuts 2 - 5 n/a BE n/a n/a n/a BE353 597 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 28 ( 4.7% )
Table 227. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
nuts
100.00%
4.69%
AT12 BE221

Completeness

Figure 231. Visualization of completeness of the data in the column.

Uniqueness

Figure 232. Visualization of uniqueness of the data in the column.

Column: districtcode

Table 228. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name districtcode
Description

Official code of the municipality (Gemeindekennziffer) in which the notified outbreak occurred.

Data type Integer number
Descriptor eurostat:MunicipalityCode [UID:0.0.MNCPL132]
Descriptor description

A term from the Darwin Core standard:

The full, unabbreviated name of the next smaller administrative region than county (city, municipality, etc.) in which the dcterms:Location occurs. Do not use this term for a nearby named place that does not contain the actual dcterms:Location.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.MNCPL132
Unit

n/a

Table 229. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
districtcode 3 - 3 489.6 106 323 504 620 900 597 137 ( 22.9% ) 0 ( 0.0% ) 0 ( 0.0% ) 68 ( 11.4% )
Table 230. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
districtcode
77.05%
11.39%
504 307

Continuous Data Distribution

Figure 233. Distribution of values in the column.

Outliers

Figure 234. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 235. Visualization of completeness of the data in the column.

Uniqueness

Figure 236. Visualization of uniqueness of the data in the column.

Column: postcode

Table 231. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name postcode
Description

Postcode of the location in which the notified outbreak occurred.

Data type String
Descriptor eurostat:postcode [UID:0.0.PSTCD378]
Descriptor description

A postal code (also known locally in various English-speaking countries throughout the world as a postcode, post code, PIN or ZIP Code) is a series of letters or digits or both, sometimes including spaces or punctuation, included in a postal address for the purpose of sorting mail.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.PSTCD378
Unit

n/a

Table 232. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
postcode 4 - 4 6,327.6 1,549 6,180 6,740 7,332 9,255 597 525 ( 87.9% ) 0 ( 0.0% ) 0 ( 0.0% ) 34 ( 5.7% )
Table 233. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
postcode
12.06%
5.70%
6280 7973

Continuous Data Distribution

Figure 237. Distribution of values in the column.

Outliers

Figure 238. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 239. Visualization of completeness of the data in the column.

Uniqueness

Figure 240. Visualization of uniqueness of the data in the column.

Column: unit

Table 234. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name unit
Description

Unit in which the value is reported.

Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a

Table 235. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
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% )
Table 236. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
unit
100.00%
0.17%
number number

Data Distribution Top 20

Figure 241. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 242. Visualization of completeness of the data in the column.

Uniqueness

Figure 243. Visualization of uniqueness of the data in the column.

Column: value

Table 237. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name value
Description

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).

Data type Integer number
Descriptor Integer [UID:0.0.NTGER313]
Descriptor description

A number with no fractional part, including the negative and positive numbers as well as zero.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.NTGER313
Unit

no.

Table 238. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
value 1 - 2 1.2 0 1 1 1 36 597 0 ( 0.0% ) 3 ( 0.5% ) 0 ( 0.0% ) 11 ( 1.8% )
Table 239. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
value
100.00%
1.84%
1 11

Data Distribution Top 20

Figure 244. Distribution of 20 most common values, from highest to lowest.

Continuous Data Distribution

Figure 245. Distribution of values in the column.

Outliers

Figure 246. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 247. Visualization of completeness of the data in the column.

Uniqueness

Figure 248. Visualization of uniqueness of the data in the column.

Column: annotation

Table 240. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name annotation
Description

Detailed annotation to the value.

Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a

Table 241. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
annotation 0 - 0 n/a n/a n/a n/a 597 597 ( 100.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.2% )
Table 242. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
annotation
0.00%
0.17%
null null

Data Distribution Top 20

Figure 249. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 250. Visualization of completeness of the data in the column.

Uniqueness

Figure 251. Visualization of uniqueness of the data in the column.

Column: sourceid

Table 243. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name sourceid
Description

Reference to the data source.

Data type Integer number
Descriptor Source ID [UID:VTCSS14.0.SRCDA377]
Descriptor description

Links to the source from which the reported value in a record was obtained.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/VTCSS14.0.SRCDA377
Unit

n/a

Table 244. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
sourceid 1 - 2 51.2 1 36.5 59 61 80 597 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 54 ( 9.0% )
Table 245. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
sourceid
100.00%
9.05%
61 4

Continuous Data Distribution

Figure 252. Distribution of values in the column.

Outliers

Figure 253. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 254. Visualization of completeness of the data in the column.

Uniqueness

Figure 255. Visualization of uniqueness of the data in the column.

Table: References

Column: îd

Table 246. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name îd
Description

Reference to the data source.

Data type Integer number
Descriptor Source ID [UID:VTCSS14.0.SRCDA377]
Descriptor description

Links to the source from which the reported value in a record was obtained.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/VTCSS14.0.SRCDA377
Unit

n/a

Table 247. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
îd 1 - 2 40.5 1 20.25 40.5 60.75 80 80 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 80 ( 100.0% )
Table 248. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
îd
100.00%
100.00%
1 1

Continuous Data Distribution

Figure 256. Distribution of values in the column.

Outliers

Figure 257. Visualization of median, min, max, and outliers in the column.

Completeness

Figure 258. Visualization of completeness of the data in the column.

Uniqueness

Figure 259. Visualization of uniqueness of the data in the column.

Column: format

Table 249. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name format
Description
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a

Table 250. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
format 6 - 6 n/a BibTeX n/a n/a n/a BibTeX 80 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 1.3% )
Table 251. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
format
100.00%
1.25%
BibTeX BibTeX

Data Distribution Top 20

Figure 260. Distribution of 20 most common values, from highest to lowest.

Completeness

Figure 261. Visualization of completeness of the data in the column.

Uniqueness

Figure 262. Visualization of uniqueness of the data in the column.

Column: reference

Table 252. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Parameter Content
Column name reference
Description
Data type String
Descriptor Text [UID:0.0.TEXTA315]
Descriptor description

In computer programming, a string is traditionally a sequence of characters, either as a literal constant or as some kind of variable. The latter may allow its elements to be mutated and the length changed, or it may be fixed (after creation). A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.

Descriptor target IRI https://app.pollinatorhub.eu/vocabulary/descriptors/0.0.TEXTA315
Unit

n/a

Table 253. Structural analysis of the table. Column name (Name); concise description of the column (Description); data type in which values are stored (Data type); EUPH-Descriptor (Descriptor); unit in which the values are provided (Unit).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
reference 404 - 506 n/a @misc{agence… n/a n/a n/a @techreport{… 80 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 80 ( 100.0% )
Table 254. Quality analysis of the table. Column name (Name); completeness of the column (Completeness); uniqueness of the column (Uniqueness); most common value in the column (Most Common Value); least common value in the column (Least Common Value).
Column Name Completeness Uniqueness Most Common Value Least Common Value
reference
100.00%
100.00%
@techreport{bundesministerium_fur_soziales_gesundheit_pflege_und_konsumentenschutz_tiergesundheitsbericht_2016, address = {Wien, AT}, title = {Tiergesundheitsbericht {Berichtszeitraum} {September} 2016}, url = {https://www.verbrauchergesundheit.gv.at/tiere/krankheiten/tgb_adns/TGB_AT_September_2016.pdf?92t3gv}, language = {de}, urldate = {2023-02-08}, author = {{Bundesministerium für Soziales, Gesundheit, Pflege und Konsumentenschutz}}, month = oct, year = {2016}, } @techreport{bundesministerium_fur_soziales_gesundheit_pflege_und_konsumentenschutz_tiergesundheitsbericht_2016, address = {Wien, AT}, title = {Tiergesundheitsbericht {Berichtszeitraum} {September} 2016}, url = {https://www.verbrauchergesundheit.gv.at/tiere/krankheiten/tgb_adns/TGB_AT_September_2016.pdf?92t3gv}, language = {de}, urldate = {2023-02-08}, author = {{Bundesministerium für Soziales, Gesundheit, Pflege und Konsumentenschutz}}, month = oct, year = {2016}, }

Completeness

Figure 263. Visualization of completeness of the data in the column.

Uniqueness

Figure 264. Visualization of uniqueness of the data in the column.