EU Pollinator Hub

, ,

Dataset Report
Unique identifier: GRCLT223.0.0
Title: EUROSTAT Agriculture labour
Long title: Agricultural labour input statistics: absolute figures 1000 annual work units (aact_ali01)
Status: Quality Validated
Current Version: v. 1.0
Published: 2025-01-15
Reviewed by: Rubinigg Michael as Data scientist
Citation proposal:
European Statistical Office 2025 Report of dataset EUROSTAT Agriculture labour, v. 1.0 [GRCLT223.0.0]. EU Pollinator Hub. [2025-07-02] 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 2025-01-15. Reviewed by Rubinigg Michael.

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 2025-01-15 00:01:00 Initial release. n/a

Abbreviations

EU
European Union
EUPH
EU Pollinator Hub
Eurostat
European Statistical Office

Executive summary

Data overview:

n/a

Data value:

n/a

Data description:

n/a

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

n/a

Unresolved issues:

n/a

Introduction

n/a

Material and methods

Data acquisition

All raw data files were downloaded from the website of EUROSTAT on 2025-01-16.

List of raw data obtained from the data provider.

  1. File estat_aact_ali01_filtered_en_aggregates.csv.gz, accessed on 2025-01-16 16:44:12, provided by EUROSTAT with the following settings: Geopolitical entity all Agregates|Time 1973-2024|List of products - EAA [40000] Total labour force input
  2. File estataactali01filteredencountries.csv.gz, accessed on 2025-01-16 16:45:06, provided by EUROSTAT with the following settings: Geopolitical entity all Countries and territories|Time 1973-2024|List of products - EAA [40000] Total labour force input
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 estat_aact_ali01_filtered_en_countries_PREP_MR_250116.csv CSV - Comma seperated values Yes No 2025-01-16 17:01:20 12,716 124.92 KiB
2 estat_aact_ali01_filtered_en_aggregates_PREP_MR_250116.csv CSV - Comma seperated values Yes No 2025-01-16 18:01:38 3,652 53.25 KiB

Data preparation

All files in the zip-archives were extracted using 7-Zip (Igor Pavlov, version 19.00). Data was processed with Notepad++ (v8.7.1) before integration on the EUPH. Dates were parsed to the required YYYY-MM-DD format using the python script ParseDates.py.

Data validation

No data validation was performed.

Data analysis

The reults of data analysis were published in the EUPH article European Honey Market

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 Country Total annual labour force input by country
2 Country aggregate Total annual labour force input by country aggregate
Table 4. Standardised metadata of the dataset. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
interactions.single.uid GRCLT223.0.0
Title EUROSTAT Agriculture labour
Long title Agricultural labour input statistics: absolute figures 1000 annual work units (aact_ali01)
Target IRI https://app.pollinatorhub.eu/dataset-discovery/GRCLT223.0.0
interactions.single.section-details.licence CC BY 4.0
DOI n/a
Created 2025-01-16
Published 2025-01-15
Contact ec.europa.eu
Keywords EU, agriculture, labour input, total labour force input
Data collection years n/a
Regions, the data was collected in Belgique/België, Danmark, Deutschland, Eesti, España, France, Hrvatska, Italia, Latvija, Lietuva, Luxembourg, Magyarország, Malta, Nederland, Norge, Polska, Portugal, România, Schweiz/Suisse/Svizzera, Slovenija, Slovensko, Suomi/Finland, Sverige, United Kingdom, Éire/Ireland, Ísland, Österreich, Česko, Ελλάδα , Κύπρος , България 
Abstract

The Economic Accounts for Agriculture (EAA) provide detailed information on the preformance and the income of the agricultural sector. The purpose is to analyse the production process of the agricultural industry and the income derived from it. The accounts are therefore based on the industry concept. The EAA are detailed data on the value of output, intermediate consumption, subsidies and taxes, consumption of fixed capital, rent and interest, capital formation etc. The values are available in both current prices and volume terms.

Agricultural Labour Input (ALI) statistics are an integrated part of the overall concept of the EAA. Meanwhile Unit Values (UV) were an integragted part of the concept of EAA only until 2018. Since then the collection of UV is discontinued. The EAA are a satellite account of the European System of Accounts (ESA), providing complementary information and concepts adapted to the particular nature of the agricultural industry. Although their structure very closely matches that of the national accounts, their compilation requires the formulation of appropriate rules and methods. National Statistical Institutes or Ministries of Agriculture are responsible for data collection and calculations of national EAA, in accordance with EC Regulations. Eurostat is responsible for the EU aggregations. Frequency of data collection for data under Regulation (EC) No 138/2004.

Table 5. Standardised metadata of the data provider European Statistical Office. Reported parameter (Parameter); content of the parameter (Content).
Parameter Content
Name European Statistical Office
Url
Acronym Eurostat
IRI https://app.pollinatorhub.eu/data-providers/european-statistical-office
Address
Country Luxembourg
Contact ec.europa.eu
Description

Eurostat (European Statistical Office; DG ESTAT) is a Directorate-General of the European Commission. Eurostat's main responsibilities are to provide statistical information to the institutions of the European Union (EU) and to promote the harmonisation of statistical methods across its member states and candidates for accession as well as EFTA countries.

Tables

Country

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

Total annual labour force input by country

Total annual labour force input by country

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
DATAFLOW
String eurostat:dataflow [0.0.DTFLW549]

n/a

LAST UPDATE
String dcterms:dateModified [0.0.MDFDA545]

n/a

freq_code
String eurostat:frequencyCode [0.0.FRQNC554]

n/a

freq_label
String pms:updateFrequency [0.0.PDTFR551]

n/a

itm_newa_code
String eurostat:itemCode [0.0.TMCDA553]

n/a

itm_newa_label
String eurostat:itemLabel [0.0.TMLBL552]

n/a

geo_code
String iso-3166:alpha-2CountryCode [0.0.LPHCN4]

n/a

geo_label
String dwc:country [0.0.CNTRY159]

n/a

TIME_PERIOD
Integer number dwc:year [0.0.YEARA340]

year

OBS_VALUE
Decimal number eurostat:totalLabourInput [0.0.TTLLB555]

103 AWUs

OBS_FLAG
String eurostat:flag [0.0.FLGAB556]

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
DATAFLOW 21 - 21 n/a ESTAT:AACT_A… n/a n/a n/a ESTAT:AACT_A… 1,156 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.1% )
LAST UPDATE 19 - 19 2,024.0 2024-12-16 1… 2,024 2,024 2,024 2024-12-16 1… 1,156 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.1% )
freq_code 1 - 1 n/a A n/a n/a n/a A 1,156 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.1% )
freq_label 6 - 6 n/a Annual n/a n/a n/a Annual 1,156 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.1% )
itm_newa_code 5 - 5 40,000.0 40,000 40,000 40,000 40,000 40,000 1,156 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.1% )
itm_newa_label 24 - 24 n/a Total labour… n/a n/a n/a Total labour… 1,156 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.1% )
geo_code 2 - 2 n/a AT n/a n/a n/a SK 1,156 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 31 ( 2.7% )
geo_label 5 - 14 n/a Italy n/a n/a n/a United Kingd… 1,156 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 31 ( 2.7% )
TIME_PERIOD 4 - 4 2,004.2 1,973 1,995 2,006 2,015 2,024 1,156 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 52 ( 4.5% )
OBS_VALUE 3 - 7 425.830 3.34 73.45 151.355 498.94 3,648.0 1,156 2 ( 0.2% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,088 ( 94.1% )
OBS_FLAG 0 - 1 n/a n/a n/a n/a z 1,156 1,123 ( 97.1% ) 0 ( 0.0% ) 0 ( 0.0% ) 3 ( 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
DATAFLOW
100.00%
0.09%
ESTAT:AACT_ALI01(1.0) ESTAT:AACT_ALI01(1.0)
LAST UPDATE
100.00%
0.09%
2024-12-16 11:00:00 2024-12-16 11:00:00
freq_code
100.00%
0.09%
A A
freq_label
100.00%
0.09%
Annual Annual
itm_newa_code
100.00%
0.09%
40000 40000
itm_newa_label
100.00%
0.09%
Total labour force input Total labour force input
geo_code
100.00%
2.68%
BE IS
geo_label
100.00%
2.68%
Belgium Iceland
TIME_PERIOD
100.00%
4.50%
2007 1973
OBS_VALUE
99.83%
94.12%
5.04 228.24
OBS_FLAG
2.85%
0.26%
null z

Changes made to preparatory file

  1. Missing values were replaced by {NULL} (4.288 occurrences).
  2. NUTS0 code for Greece {EL} was replaced by the ISO-3166 alpha-2 code {GR} (36 records)
  3. NUTS0 code for United Kingdom {UK} was replaced by the ISO-3166 alpha-2 code {GB} (48 records)
  4. Codes and labels, which are separated by a {:} were separated by the column delimiter {;} for the columns freq, itm_newa and geo, headers were added/changed to (freq_code/freqlabel), (itm_newa_code/itm_newa_label) and (geo_code/geo_label), respectively.

Changes made to data

None

Unresolved issues

None

Country aggregate

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

Total annual labour force input by country aggregate

Total annual labour force input by country aggregate

Metadata

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 Column Description Datatype Descriptor Unit
DATAFLOW
String eurostat:dataflow [0.0.DTFLW549]

n/a

LAST UPDATE
String dcterms:dateModified [0.0.MDFDA545]

n/a

freq_code
String eurostat:frequencyCode [0.0.FRQNC554]

n/a

freq_label
String pms:updateFrequency [0.0.PDTFR551]

n/a

itm_newa_code
String eurostat:itemCode [0.0.TMCDA553]

n/a

itm_newa_label
String eurostat:itemLabel [0.0.TMLBL552]

n/a

geo_code
String iso-3166:alpha-2CountryCode [0.0.LPHCN4]

n/a

geo_label
String dwc:country [0.0.CNTRY159]

n/a

TIME_PERIOD
Integer number dwc:year [0.0.YEARA340]

year

OBS_VALUE
Decimal number eurostat:totalLabourInput [0.0.TTLLB555]

103 AWUs

OBS_FLAG
String eurostat:flag [0.0.FLGAB556]

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
DATAFLOW 21 - 21 n/a ESTAT:AACT_A… n/a n/a n/a ESTAT:AACT_A… 332 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.3% )
LAST UPDATE 19 - 19 2,024.0 2024-12-16 1… 2,024 2,024 2,024 2024-12-16 1… 332 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.3% )
freq_code 1 - 1 n/a A n/a n/a n/a A 332 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.3% )
freq_label 6 - 6 n/a Annual n/a n/a n/a Annual 332 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.3% )
itm_newa_code 5 - 5 40,000.0 40,000 40,000 40,000 40,000 40,000 332 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.3% )
itm_newa_label 24 - 24 n/a Total labour… n/a n/a n/a Total labour… 332 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.3% )
geo_code 2 - 14 n/a EA n/a n/a n/a EU27_2020_EF… 332 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 13 ( 3.9% )
geo_label 36 - 112 n/a Euro area -… n/a n/a n/a European Uni… 332 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 13 ( 3.9% )
TIME_PERIOD 4 - 4 2,009.6 1,991 2,003 2,010 2,017 2,024 332 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 34 ( 10.2% )
OBS_VALUE 6 - 8 6,933.122 3,671.49 4,910.96 6,062.875 9,089.195 14,881.98 332 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 270 ( 81.3% )
OBS_FLAG 0 - 1 n/a n/a n/a n/a e 332 323 ( 97.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 0.6% )

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
DATAFLOW
100.00%
0.30%
ESTAT:AACT_ALI01(1.0) ESTAT:AACT_ALI01(1.0)
LAST UPDATE
100.00%
0.30%
2024-12-16 11:00:00 2024-12-16 11:00:00
freq_code
100.00%
0.30%
A A
freq_label
100.00%
0.30%
Annual Annual
itm_newa_code
100.00%
0.30%
40000 40000
itm_newa_label
100.00%
0.30%
Total labour force input Total labour force input
geo_code
100.00%
3.92%
EA EU28
geo_label
100.00%
3.92%
Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023) European Union - 28 countries (2013-2020)
TIME_PERIOD
100.00%
10.24%
2007 1991
OBS_VALUE
100.00%
81.33%
6989.34 5257.49
OBS_FLAG
2.71%
0.60%
null e

Changes made to preparatory file

  1. Missing values were replaced by {NULL} (4.288 occurrences).
    1. NUTS0 code for Greece {EL} was replaced by the ISO-3166 alpha-2 code {GR} (36 records)
  2. NUTS0 code for United Kingdom {UK} was replaced by the ISO-3166 alpha-2 code {GB} (48 records)
  3. Codes and labels, which are separated by a {:} were separated by the column delimiter {;} for the columns freq, itm_newa and geo, headers were added/changed to (freq_code/freqlabel), (itm_newa_code/itm_newa_label) and (geo_code/geo_label), respectively.

Changes made to data

None

Unresolved issues

None

References

  1. Eurostat 2024 Economic accounts for agriculture (aact). [2025-1-16] ec.europa.eu
  2. Eurostat 2024 Agricultural labour input statistics: absolute figures. doi: https://doi.org/10.2908/AACT_ALI01

Annex 1: Table column reports

Table: Country

Column: DATAFLOW

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).
Parameter Content
Column name DATAFLOW
Description
Data type String
Descriptor eurostat:dataflow [UID:0.0.DTFLW549]
Descriptor description

Structure which describes, categorises and constrains the allowable content of a dataset that providers supply for different reference periods.

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

n/a

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 Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
DATAFLOW 21 - 21 n/a ESTAT:AACT_A… n/a n/a n/a ESTAT:AACT_A… 1,156 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.1% )
Table 16. 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
DATAFLOW
100.00%
0.09%
ESTAT:AACT_ALI01(1.0) ESTAT:AACT_ALI01(1.0)

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: LAST UPDATE

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).
Parameter Content
Column name LAST UPDATE
Description
Data type String
Descriptor dcterms:dateModified [UID:0.0.MDFDA545]
Descriptor description
Descriptor target IRI http://purl.org/dc/terms/modified
Unit

n/a

Table 18. 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
LAST UPDATE 19 - 19 2,024.0 2024-12-16 1… 2,024 2,024 2,024 2024-12-16 1… 1,156 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.1% )
Table 19. 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
LAST UPDATE
100.00%
0.09%
2024-12-16 11:00:00 2024-12-16 11:00:00

Data Distribution Top 20

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

Outliers

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

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

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).
Parameter Content
Column name freq_code
Description
Data type String
Descriptor eurostat:frequencyCode [UID:0.0.FRQNC554]
Descriptor description

An attribute of a cell in a data set representing qualitative information about the period over which the reported data were aggregated.

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

n/a

Table 21. 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
freq_code 1 - 1 n/a A n/a n/a n/a A 1,156 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.1% )
Table 22. 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
freq_code
100.00%
0.09%
A A

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

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).
Parameter Content
Column name freq_label
Description
Data type String
Descriptor pms:updateFrequency [UID:0.0.PDTFR551]
Descriptor description

The frequency as which a record or a data element or a content is updated.

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

n/a

Table 24. 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
freq_label 6 - 6 n/a Annual n/a n/a n/a Annual 1,156 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.1% )
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
freq_label
100.00%
0.09%
Annual Annual

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

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).
Parameter Content
Column name itm_newa_code
Description
Data type String
Descriptor eurostat:itemCode [UID:0.0.TMCDA553]
Descriptor description

A code representing qualitative information about the EUROSTAT item for which the data are reported.

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

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 Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
itm_newa_code 5 - 5 40,000.0 40,000 40,000 40,000 40,000 40,000 1,156 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.1% )
Table 28. 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
itm_newa_code
100.00%
0.09%
40000 40000

Data Distribution Top 20

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

Continuous Data Distribution

Figure 15. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: itm_newa_label

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).
Parameter Content
Column name itm_newa_label
Description
Data type String
Descriptor eurostat:itemLabel [UID:0.0.TMLBL552]
Descriptor description

The description adopted by EUROSTAT for a given EUROSTAT item.

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

n/a

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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
itm_newa_label 24 - 24 n/a Total labour… n/a n/a n/a Total labour… 1,156 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.1% )
Table 31. 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
itm_newa_label
100.00%
0.09%
Total labour force input Total labour force input

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: geo_code

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).
Parameter Content
Column name geo_code
Description
Data type String
Descriptor iso-3166:alpha-2CountryCode [UID:0.0.LPHCN4]
Descriptor description

A two-letter code that represents a country name, recommended as the general purpose code.

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

n/a

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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
geo_code 2 - 2 n/a AT n/a n/a n/a SK 1,156 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 31 ( 2.7% )
Table 34. 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
geo_code
100.00%
2.68%
BE IS

Data Distribution Top 20

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

Data Distribution Bottom 20

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

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

Table 35. 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 geo_label
Description
Data type String
Descriptor dwc:country [UID:0.0.CNTRY159]
Descriptor description

A collective generic term that refers here to a wide variety of dependencies, areas of special sovereignty, uninhabited islands, and other entities in addition to the traditional countries or independent states.

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

n/a

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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
geo_label 5 - 14 n/a Italy n/a n/a n/a United Kingd… 1,156 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 31 ( 2.7% )
Table 37. 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
geo_label
100.00%
2.68%
Belgium Iceland

Data Distribution Top 20

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

Data Distribution Bottom 20

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

Completeness

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

Uniqueness

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

Column: TIME_PERIOD

Table 38. 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 TIME_PERIOD
Description
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 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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
TIME_PERIOD 4 - 4 2,004.2 1,973 1,995 2,006 2,015 2,024 1,156 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 52 ( 4.5% )
Table 40. 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
TIME_PERIOD
100.00%
4.50%
2007 1973

Continuous Data Distribution

Figure 30. Distribution of values in the column.

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

Table 41. 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 OBS_VALUE
Description
Data type Decimal number
Descriptor eurostat:totalLabourInput [UID:0.0.TTLLB555]
Descriptor description

The total labour input corresponds to the total hours worked divided by the average annual number of hours worked in full-time jobs within the economic territory. Full-time work should be based on the definition used in Eurostat's Farm Structure Survey (FSS) and is typically 1800 hours per year, if no specific national provisions are detailed. One person cannot represent more than one AWU. This constraint holds even if someone is working in the agricultural industry for more than the number of hours defining full time. The agricultural labour input of persons who work less than full time on agricultural holdings is calculated as the quotient of the number of hours actually worked (per week or per year) and the number of hours actually worked (per week or per year) in a full-time job. Total hours worked do not cover work for the private household of the holder or manager.

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

103 AWUs

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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
OBS_VALUE 3 - 7 425.830 3.34 73.45 151.355 498.94 3,648.0 1,156 2 ( 0.2% ) 0 ( 0.0% ) 0 ( 0.0% ) 1,088 ( 94.1% )
Table 43. 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
OBS_VALUE
99.83%
94.12%
5.04 228.24

Continuous Data Distribution

Figure 34. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: OBS_FLAG

Table 44. 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 OBS_FLAG
Description
Data type String
Descriptor eurostat:flag [UID:0.0.FLGAB556]
Descriptor description

Flag used to add standardised comments to data provided by EUROSTAT data, summarised in the "Observation flags:" list on the web page of the EUROSTAT dataset.

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

n/a

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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
OBS_FLAG 0 - 1 n/a n/a n/a n/a z 1,156 1,123 ( 97.1% ) 0 ( 0.0% ) 0 ( 0.0% ) 3 ( 0.3% )
Table 46. 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
OBS_FLAG
2.85%
0.26%
null z

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Table: Country aggregate

Column: DATAFLOW

Table 47. 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 DATAFLOW
Description
Data type String
Descriptor eurostat:dataflow [UID:0.0.DTFLW549]
Descriptor description

Structure which describes, categorises and constrains the allowable content of a dataset that providers supply for different reference periods.

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

n/a

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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
DATAFLOW 21 - 21 n/a ESTAT:AACT_A… n/a n/a n/a ESTAT:AACT_A… 332 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.3% )
Table 49. 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
DATAFLOW
100.00%
0.30%
ESTAT:AACT_ALI01(1.0) ESTAT:AACT_ALI01(1.0)

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: LAST UPDATE

Table 50. 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 LAST UPDATE
Description
Data type String
Descriptor dcterms:dateModified [UID:0.0.MDFDA545]
Descriptor description
Descriptor target IRI http://purl.org/dc/terms/modified
Unit

n/a

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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
LAST UPDATE 19 - 19 2,024.0 2024-12-16 1… 2,024 2,024 2,024 2024-12-16 1… 332 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.3% )
Table 52. 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
LAST UPDATE
100.00%
0.30%
2024-12-16 11:00:00 2024-12-16 11:00:00

Data Distribution Top 20

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

Outliers

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

Completeness

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

Uniqueness

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

Column: freq_code

Table 53. 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 freq_code
Description
Data type String
Descriptor eurostat:frequencyCode [UID:0.0.FRQNC554]
Descriptor description

An attribute of a cell in a data set representing qualitative information about the period over which the reported data were aggregated.

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

n/a

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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
freq_code 1 - 1 n/a A n/a n/a n/a A 332 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.3% )
Table 55. 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
freq_code
100.00%
0.30%
A A

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: freq_label

Table 56. 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 freq_label
Description
Data type String
Descriptor pms:updateFrequency [UID:0.0.PDTFR551]
Descriptor description

The frequency as which a record or a data element or a content is updated.

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

n/a

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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
freq_label 6 - 6 n/a Annual n/a n/a n/a Annual 332 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.3% )
Table 58. 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
freq_label
100.00%
0.30%
Annual Annual

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: itm_newa_code

Table 59. 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 itm_newa_code
Description
Data type String
Descriptor eurostat:itemCode [UID:0.0.TMCDA553]
Descriptor description

A code representing qualitative information about the EUROSTAT item for which the data are reported.

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

n/a

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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
itm_newa_code 5 - 5 40,000.0 40,000 40,000 40,000 40,000 40,000 332 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.3% )
Table 61. 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
itm_newa_code
100.00%
0.30%
40000 40000

Data Distribution Top 20

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

Continuous Data Distribution

Figure 55. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: itm_newa_label

Table 62. 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 itm_newa_label
Description
Data type String
Descriptor eurostat:itemLabel [UID:0.0.TMLBL552]
Descriptor description

The description adopted by EUROSTAT for a given EUROSTAT item.

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

n/a

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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
itm_newa_label 24 - 24 n/a Total labour… n/a n/a n/a Total labour… 332 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 1 ( 0.3% )
Table 64. 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
itm_newa_label
100.00%
0.30%
Total labour force input Total labour force input

Data Distribution Top 20

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

Completeness

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

Uniqueness

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

Column: geo_code

Table 65. 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 geo_code
Description
Data type String
Descriptor iso-3166:alpha-2CountryCode [UID:0.0.LPHCN4]
Descriptor description

A two-letter code that represents a country name, recommended as the general purpose code.

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

n/a

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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
geo_code 2 - 14 n/a EA n/a n/a n/a EU27_2020_EF… 332 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 13 ( 3.9% )
Table 67. 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
geo_code
100.00%
3.92%
EA EU28

Data Distribution Top 20

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

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

Table 68. 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 geo_label
Description
Data type String
Descriptor dwc:country [UID:0.0.CNTRY159]
Descriptor description

A collective generic term that refers here to a wide variety of dependencies, areas of special sovereignty, uninhabited islands, and other entities in addition to the traditional countries or independent states.

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

n/a

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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
geo_label 36 - 112 n/a Euro area -… n/a n/a n/a European Uni… 332 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 13 ( 3.9% )
Table 70. 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
geo_label
100.00%
3.92%
Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023) European Union - 28 countries (2013-2020)

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

Table 71. 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 TIME_PERIOD
Description
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 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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
TIME_PERIOD 4 - 4 2,009.6 1,991 2,003 2,010 2,017 2,024 332 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 34 ( 10.2% )
Table 73. 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
TIME_PERIOD
100.00%
10.24%
2007 1991

Continuous Data Distribution

Figure 68. Distribution of values in the column.

Outliers

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

Completeness

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

Uniqueness

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

Column: OBS_VALUE

Table 74. 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 OBS_VALUE
Description
Data type Decimal number
Descriptor eurostat:totalLabourInput [UID:0.0.TTLLB555]
Descriptor description

The total labour input corresponds to the total hours worked divided by the average annual number of hours worked in full-time jobs within the economic territory. Full-time work should be based on the definition used in Eurostat's Farm Structure Survey (FSS) and is typically 1800 hours per year, if no specific national provisions are detailed. One person cannot represent more than one AWU. This constraint holds even if someone is working in the agricultural industry for more than the number of hours defining full time. The agricultural labour input of persons who work less than full time on agricultural holdings is calculated as the quotient of the number of hours actually worked (per week or per year) and the number of hours actually worked (per week or per year) in a full-time job. Total hours worked do not cover work for the private household of the holder or manager.

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

103 AWUs

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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
OBS_VALUE 6 - 8 6,933.122 3,671.49 4,910.96 6,062.875 9,089.195 14,881.98 332 0 ( 0.0% ) 0 ( 0.0% ) 0 ( 0.0% ) 270 ( 81.3% )
Table 76. 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
OBS_VALUE
100.00%
81.33%
6989.34 5257.49

Continuous Data Distribution

Figure 72. Distribution of values in the column.

Outliers

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

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

Table 77. 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 OBS_FLAG
Description
Data type String
Descriptor eurostat:flag [UID:0.0.FLGAB556]
Descriptor description

Flag used to add standardised comments to data provided by EUROSTAT data, summarised in the "Observation flags:" list on the web page of the EUROSTAT dataset.

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

n/a

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).
Column Name Range Mean Minimum Q1 Median Q3 Maximum Total Missing Zero Blank Distinct
OBS_FLAG 0 - 1 n/a n/a n/a n/a e 332 323 ( 97.3% ) 0 ( 0.0% ) 0 ( 0.0% ) 2 ( 0.6% )
Table 79. 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
OBS_FLAG
2.71%
0.60%
null e

Data Distribution Top 20

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

Completeness

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

Uniqueness

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