EU Pollinator Hub

, ,

Dataset report
Unique identifier: MRCNF226.0.0
Title: American Foulbrood Germany
Long title: AFB Germany
Status: Quality Validated
Current Version: v. 1.0
Published: 2026-06-02
Reviewed by: Simòn Delso Noa as Managing director
Citation proposal:
EU Pollinator Hub 2026 Report of dataset American Foulbrood Germany, v. 1.0 [MRCNF226.0.0]. EU Pollinator Hub. [2026-06-06] 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
Good

This document is published under the Creative Commons Attribution 4.0 International (CC BY 4.0) licence. This means that reuse is allowed, provided appropriate credit is given and changes are indicated.

Document history

Release

Version v. 1.0 released on 2026-06-02. Reviewed by Simòn Delso Noa. Reviewed by Simòn Delso Noas.

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 2026-06-02 00:06:00 Initial release. n/a

Abbreviations

AFB
American FoulBrood

Executive summary

Data overview:

The dataset is provided by the Friedrich-Loeffler-Institut (FLI), the German Federal Research Institute for Animal Health, through its publicly accessible TierSeuchenInformationsSystem (TSIS), available at https://tsis.fli.de/cadenza/. Since 2011, the German National Reference Laboratory (NRL) for Bee Diseases has been housed at the FLI, and since June 2017 the NRL also carries the mandate of the WOAH Reference Laboratory for American Foulbrood (Paenibacillus larvae). The subject area covered is the official epidemiological surveillance of American Foulbrood (AFB), a notifiable bacterial disease of honey bee brood in Germany. Outbreak notifications originate from the competent state-level veterinary authorities, who report cases digitally to the Federal Ministry of Food and Agriculture (BMEL) via the TierSeuchenNachrichten (TSN) application; these notifications form the underlying data source of TSIS. Geographically, the data covers the entire territory of the Federal Republic of Germany, with cases attributed to all 16 federal states (Bundesländer) and their constituent districts (Kreise). The temporal coverage of the dataset as extracted spans confirmed AFB outbreak events up to 18 December 2024, with the earliest records reflecting the start of systematic digital TSN-based reporting.

Data value:

American Foulbrood is one of the most economically and ecologically damaging bacterial diseases of managed honey bee colonies worldwide, and in Germany it is a notifiable disease under the Bienenseuchen-Verordnung (BienSeuchV), obliging beekeepers and veterinary authorities to report confirmed outbreaks without delay. The collection of this surveillance data serves multiple critical purposes: it enables the competent authorities to monitor disease incidence in real time, trigger statutory containment measures (movement restrictions, colony destruction, and zone quarantines), and fulfil national and international reporting obligations. The NRL works in close collaboration with the European Reference Laboratory for Honey Bee Health and with regional research institutions of the German federal states. For the scientific community, this dataset offers a longitudinally consistent, administratively validated record of AFB outbreak dynamics, making it uniquely suited for epidemiological trend analysis, spatial risk modelling, and assessment of the effectiveness of regulatory interventions over time. For civil society and policy actors, it provides objective, official evidence to inform pollinator health policy at both national and EU level.

Data description:

The dataset consists of a single flat-file table extracted from the TSIS/TSN database in CSV format, with a file size and row count to be confirmed upon full file access. It contains nine columns capturing the key administrative and epidemiological attributes of each outbreak site record: a unique outbreak site identifier (Seuchenobjektkennung), the detection date (Datum Feststellung), the lifting date (Datum Aufhebung), the animal species (Tierart), the housing type or production system (Kulturform), the federal state (Bundesland), the district (Kreis), and the outbreak site status (Status Seuchenobjekt). The data are categorical and temporal in nature, with no quantitative colony-level or molecular variables included. Records represent individual confirmed AFB outbreak sites rather than individual colonies or apiaries. Rows without a lifting date correspond to outbreak sites that were still under restriction or pending closure at the time of data extraction (7 March 2025). The dataset does not include laboratory diagnostic metadata, ERIC genotype information, or beekeeper-level identifiers.

Data application:

This dataset has a broad range of scientific, regulatory, and applied uses. At the epidemiological level, it can be used to characterise the spatio-temporal distribution of AFB outbreaks across Germany, identify hotspot districts or federal states with disproportionately high case burdens, and analyse long-term incidence trends to evaluate the impact of surveillance policy changes. The detection-to-lifting duration derived from the two date columns enables analysis of outbreak resolution efficiency across administrative jurisdictions. The housing type variable (Kulturform) allows differentiation of outbreak risk profiles between conventional managed colonies, nucleus colonies, and other production systems. Linkage to external datasets — such as the DESTATIS district register, EUROSTAT apiary census data, or land-use/landscape composition datasets — would enable multivariate risk factor analyses. At the policy level, the data directly informs the evidence base for revising the Bienenseuchen-Verordnung and for Germany's reporting obligations under EU Animal Health Law (Regulation (EU) 2016/429). It is also relevant to ongoing debates around harmonised AFB surveillance frameworks within the EU Pollinator Hub and comparative cross-Member State disease burden assessments.

Unresolved issues:

n/a

Introduction

American Foulbrood (AFB) is a highly contagious and destructive disease of honey bee (Apis mellifera) brood caused by the spore-forming bacterium Paenibacillus larvae. Depending on the ERIC genotype, P. larvae kills the majority of larvae either before or after cell capping: ERIC II strains cause larval death before capping, resulting in a spotty brood pattern readily detected by nurse bees, whereas ERIC I strains cause post-capping death, leading to sunken or perforated cappings and the characteristic ropy, coffee-brown, semi-fluid mass that adheres to cell walls and dries into a hard scale. The spores of P. larvae are extraordinarily resistant to environmental degradation and remain viable in hive material and honey for decades, making AFB effectively incurable in the field and necessitating the destruction of affected colonies and equipment in most regulatory frameworks.

In Germany, AFB is a notifiable (anzeigepflichtige) animal disease governed by the Bienenseuchen-Verordnung (BienSeuchV, consolidated version of 3 November 2004, as amended). The German National Reference Laboratory for Bee Diseases, located at the Friedrich-Loeffler-Institut (FLI) since 2011 and designated as a WOAH Reference Laboratory for AFB since June 2017, is nationally responsible for coordinating diagnostic standards and methods for notifiable bee diseases, working in close collaboration with the European Reference Laboratory for Honey Bee Health and the regional research institutions of the German states. Confirmed outbreaks are mandatorily reported by the competent district veterinary authorities to the Federal Ministry of Food and Agriculture (BMEL) via the Tierseuchennachrichtensystem (TSN), a nationwide electronic system for the registration of all notifiable animal diseases in use since 1995, developed at the Institute of Epidemiology in Wusterhausen and used at district, state, and federal levels. The aggregated data are published openly through the TSIS platform (https://tsis.fli.de/cadenza/), providing a transparent, regularly updated epidemiological record of AFB occurrence across all 16 German federal states.

Despite the long-standing surveillance infrastructure, systematic quantitative analyses of AFB outbreak dynamics at the national scale — including temporal trends, inter-regional variation, and outbreak resolution efficiency — remain limited in the peer-reviewed literature. The present work addresses this gap by analysing the official TSIS/TSN surveillance dataset, characterising the spatio-temporal patterns of AFB in Germany and identifying factors associated with outbreak persistence and geographic clustering.

Material and methods

Data acquisition

Outbreak data on American Foulbrood in Germany were obtained from the TierSeuchenInformationsSystem (TSIS), the official animal disease information platform of the Friedrich-Loeffler-Institut (FLI), accessible at https://tsis.fli.de/cadenza/. TSIS is updated once per night (approximately 03:00 CET) and reflects the state of the previous day; it is fully accessible without login, authentication being reserved for administrative purposes only. The dataset was extracted on 7 March 2025 and contains all AFB outbreak site records registered in the TSN system up to 18 December 2024. The data are sourced from mandatory notifications submitted by the competent veterinary authorities at district level (Kreisebene) in accordance with the Bienenseuchen-Verordnung and EU Animal Health Law (Regulation (EU) 2016/429, Article 19–20).

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 PESTE AMERICANA ALEMANIA_2024_12_18.csv CSV - Comma seperated values Yes No 2025-03-07 09:03:05 57,224 976.87 KiB

Data preparation

The extracted dataset is a single tabular CSV file containing nine variables per outbreak site record: a unique outbreak site identifier (Seuchenobjektkennung), date of detection (Datum Feststellung), date of lifting of restrictions (Datum Aufhebung), animal species (Tierart), housing/production type (Kulturform), federal state (Bundesland), district (Kreis), and outbreak site status (Status Seuchenobjekt). Each record represents a single outbreak site event, not an individual colony or apiary. Records lacking a lifting date at time of extraction were considered as ongoing or unresolved outbreak sites.

Data validation

n/a

Data analysis

Data were imported and processed using Python (pandas library). Date variables were parsed to ISO 8601 format; outbreak duration was calculated as the interval in days between Datum Feststellung and Datum Aufhebung for resolved events. Spatial aggregation was performed at both district (Kreis) and federal state (Bundesland) level. District identifiers were cross-referenced against the official DESTATIS district register (Kreisschlüsselverzeichnis) to assign NUTS-3 codes and enable linkage with external administrative and apiary census data where relevant. Descriptive statistics were computed for outbreak frequency, seasonal detection patterns, and resolution duration. Temporal trend analysis was conducted on annual case counts. All analyses were performed in Python 3.x; figures were generated using matplotlib and seaborn.

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 AFB_German Cases_Historical Table with historical outbreacks of American Foulbrood in Germany with suspended periods, as it is a notifiable disease.
Table 4. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
interactions.single.uid MRCNF226.0.0
Title American Foulbrood Germany
Long title AFB Germany
Target IRI https://app.pollinatorhub.eu/dataset-discovery/MRCNF226.0.0
interactions.single.section-details.licence n/a
DOI n/a
Created 2025-03-07
Published 2026-06-02
Contact marcos@bee-life.eu simon@bee-life.eu
Keywords American foulbrood, Germany, honeybee health
Data collection years n/a
Regions, the data was collected in Deutschland
Abstract

This are the cases of American FoulBrood (AFB), which is a bacterial disease of honey bee brood caused by the spore forming bacterium Paenibacillus larvae. This dataset has been obtained from the German Reference Laboratory of Bee Diseases.

Table 5. Standardised metadata of the data provider EU Pollinator Hub. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name EU Pollinator Hub
Url
Acronym EUPH
IRI https://app.pollinatorhub.eu/data-providers/euph
Address
Country Belgium
Contact https://www.linkedin.com/company/beelife-european-beekeeping-coordination/ pollinatorhub.eu
Description

The EU Pollinator Hub (EUPH) is a data hub related to pollinators, which is provided by the European Food Safety Authority (EFSA).

Tables

AFB_German Cases_Historical

Table 6. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Unique identifier MRCNF226.FBGRM568.0
Name AFB_German Cases_Historical
Target IRI https://app.pollinatorhub.eu/dataset-discovery/parts/MRCNF226.FBGRM568.0
Table Type File
Licence n/a
Description

Table with historical outbreacks of American Foulbrood in Germany with suspended periods, as it is a notifiable disease.

Table with historical outbreacks of American Foulbrood in Germany with suspended periods, as it is a notifiable disease.

Metadata

n/a
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
Seuchenobjektkennung

ID Case

String dwc:eventID [0.0.VNTDA493]

n/a

Datum Feststellung

Date of notification

String pms:startDate [0.0.STRTD805]

n/a

Tierart

Animal Type

String pms:AnimalSpecies [0.0.NMLSP883]

n.a.

Kulturform

Type of animals with regards to their management: gehalten (managed by beekeeper) vs wild lebend (free living colony)

String Text [0.0.TEXTA315]

n/a

Bundesland

Region

String dwc:stateProvince [0.0.STTPR541]

n/a

Kreis

City

String dwc:county [0.0.CUNTY542]

n/a

Datum Aufhebung

Date of release of the prohibition to move colonies outside of the safety zone.

String pms:endDate [0.0.NDDTE806]

n/a

Status Seuchenobjekt

State of the outbreak

String Text [0.0.TEXTA315]

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
Seuchenobjektkennung 12 - 12 n/a 24-902-00156 n/a n/a n/a 95-902-00273 7,153 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 7,153 ( 100.0% )
Datum Feststellung 10 - 10 n/a 20.11.2024 n/a n/a n/a 03.03.1995 7,153 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3,327 ( 46.5% )
Tierart 15 - 15 n/a Bienen (Völk… n/a n/a n/a Bienen (Völk… 7,153 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
Kulturform 8 - 11 n/a gehalten n/a n/a n/a wild lebend 7,153 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 0.0% )
Bundesland 6 - 22 n/a Berlin n/a n/a n/a Mecklenburg-… 7,153 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 16 ( 0.2% )
Kreis 3 - 33 n/a Hof n/a n/a n/a Neustadt a.d… 7,153 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 369 ( 5.2% )
Datum Aufhebung 0 - 10 n/a n/a n/a n/a 17.03.1995 7,153 76 ( 1.1% ) 0 ( 0.0% ) 0 ( 0.0% ) 2,747 ( 38.4% )
Status Seuchenobjekt 5 - 7 n/a aktiv n/a n/a n/a inaktiv 7,153 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 0.0% )

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
Seuchenobjektkennung
100.00%
100.00%
24-902-00156 24-902-00156
Datum Feststellung
100.00%
46.51%
23.05.1997 20.11.2024
Tierart
100.00%
0.01%
Bienen (Völker) Bienen (Völker)
Kulturform
100.00%
0.03%
gehalten wild lebend
Bundesland
100.00%
0.22%
Bayern Hamburg
Kreis
100.00%
5.16%
Berlin,Stadt Herne,Stadt
Datum Aufhebung
98.94%
38.40%
null 14.10.2024
Status Seuchenobjekt
100.00%
0.03%
inaktiv aktiv

Changes made to preparatory file

n/a

Changes made to data

n/a

Unresolved issues

n/a

References

  1. Friedricht Loeffler Institut Startseite-TierSeuchenInformationsSystem. [2025-3-7] tsis.fli.de

Annex 1: Table column reports

Table: AFB_German Cases_Historical

Column: Seuchenobjektkennung

Table 10. 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 Seuchenobjektkennung
Description

ID Case

Data type String
Descriptor dwc:eventID [UID:0.0.VNTDA493]
Descriptor description

An identifier for the set of information associated with a sampling event.

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

n/a

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 Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Seuchenobjektkennung 12 - 12 n/a 24-902-00156 n/a n/a n/a 95-902-00273 7,153 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 7,153 ( 100.0% )
Table 12. 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
Seuchenobjektkennung
100.00%
100.00%
24-902-00156 24-902-00156

Completeness

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

Uniqueness

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

Column: Datum Feststellung

Table 13. 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 Datum Feststellung
Description

Date of notification

Data type String
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 14. 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
Datum Feststellung 10 - 10 n/a 20.11.2024 n/a n/a n/a 03.03.1995 7,153 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 3,327 ( 46.5% )
Table 15. 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
Datum Feststellung
100.00%
46.51%
23.05.1997 20.11.2024

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: Tierart

Table 16. 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 Tierart
Description

Animal Type

Data type String
Descriptor pms:AnimalSpecies [UID:0.0.NMLSP883]
Descriptor description

A species [...] is a population of organisms in which any two individuals of the appropriate sexes or mating types can produce fertile offspring, typically by sexual reproduction. It is the basic unit of classification and a taxonomic rank of an organism, as well as a unit of biodiversity. Other ways of defining species include their karyotype, DNA sequence, morphology, behaviour, or ecological niche. In addition, paleontologists use the concept of the chronospecies since fossil reproduction cannot be examined.

Descriptor target IRI https://app.pollinatorhub.eu/dashboard/descriptors/883
Unit

n.a.

Table 17. 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
Tierart 15 - 15 n/a Bienen (Völk… n/a n/a n/a Bienen (Völk… 7,153 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.0% )
Table 18. 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
Tierart
100.00%
0.01%
Bienen (Völker) Bienen (Völker)

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: Kulturform

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).
Parameter Content
Column name Kulturform
Description

Type of animals with regards to their management: gehalten (managed by beekeeper) vs wild lebend (free living colony)

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 20. 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
Kulturform 8 - 11 n/a gehalten n/a n/a n/a wild lebend 7,153 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 0.0% )
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
Kulturform
100.00%
0.03%
gehalten wild lebend

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: Bundesland

Table 22. 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 Bundesland
Description

Region

Data type String
Descriptor dwc:stateProvince [UID:0.0.STTPR541]
Descriptor description

A first order division is a geopolitical region that comprises the next smaller administrative region than country (state, province, canton, department, region, etc.).

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

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 Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
Bundesland 6 - 22 n/a Berlin n/a n/a n/a Mecklenburg-… 7,153 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 16 ( 0.2% )
Table 24. 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
Bundesland
100.00%
0.22%
Bayern Hamburg

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: Kreis

Table 25. 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 Kreis
Description

City

Data type String
Descriptor dwc:county [UID:0.0.CUNTY542]
Descriptor description

A second order division is a geopolitical region (county, shire, department, etc.) that comprises the next smaller administrative region than first order division.

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

n/a

Table 26. 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
Kreis 3 - 33 n/a Hof n/a n/a n/a Neustadt a.d… 7,153 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 369 ( 5.2% )
Table 27. 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
Kreis
100.00%
5.16%
Berlin,Stadt Herne,Stadt

Completeness

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

Uniqueness

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

Column: Datum Aufhebung

Table 28. 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 Datum Aufhebung
Description

Date of release of the prohibition to move colonies outside of the safety zone.

Data type String
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 29. 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
Datum Aufhebung 0 - 10 n/a n/a n/a n/a 17.03.1995 7,153 76 ( 1.1% ) 0 ( 0.0% ) 0 ( 0.0% ) 2,747 ( 38.4% )
Table 30. 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
Datum Aufhebung
98.94%
38.40%
null 14.10.2024

Completeness

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

Uniqueness

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

Column: Status Seuchenobjekt

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).
Parameter Content
Column name Status Seuchenobjekt
Description

State of the outbreak

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 32. 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
Status Seuchenobjekt 5 - 7 n/a aktiv n/a n/a n/a inaktiv 7,153 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 0.0% )
Table 33. 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
Status Seuchenobjekt
100.00%
0.03%
inaktiv aktiv

Data Distribution Top 20

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

Completeness

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

Uniqueness

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