About this Dataset

Status And Trends For Individual Bird Species: Tenth UK Report For Article 12 Of The EU Birds Directive (2008-2012)

This dataset summarises the status and trend for 319 bird species in the UK. These data formed part of the Tenth UK Report for Article 12 of the EU Birds Directive (2008-2012). The structure of the data corresponds to an agreed EU level format available here. http://bd.eionet.europa.eu/activities/Reporting/Article_12/reference_portal. Following public consultation and government sign-off, the final UK report was submitted to the European Commission in January 2014. The data in this dataset are structured into the following sections. 1. Species information 2. Population size 3. Population trend 4. Breeding distribution map and range size 5. Breeding range trend 6. Progress in work related to Species Action Plans (SAPs), Management Plans (MPs) and Brief Management Statements (BMSs) 8. SPA network overlaps The column headers have a numeric reference related to the above sections followed by a textual short title for each field. The reference portal gives further details of what all of these columns mean.
Publisher name: Joint Nature Conservation Committee
Last updated: 2024-09-14T19:09:24Z

Tables

Birds-Directive-Article12-2013-UKdata

@ukgov.status_and_trends_for_individual_bird_species_tenth_uk_52063184.birds_directive_article12_2013_ukdata

160.99 KB
328 rows
94 columns


CREATE TABLE birds_directive_article12_2013_ukdata (
  "n_1_1_member_state" VARCHAR,
  "n_1_2_1_euring_code" VARCHAR,
  "n_1_2_2_natura_2000_code" VARCHAR,
  "n_1_3_species_scientific_name" VARCHAR,
  "n_1_3_1_sub_specific_population" VARCHAR,
  "n_1_4_alternative_species_scientific_name_optional" VARCHAR,
  "n_1_5_common_name_optional" VARCHAR,
  "n_1_6_season" VARCHAR,
  "n_2_1_year_or_period" VARCHAR,
  "n_2_1_start_year" DOUBLE,
  "n_2_1_finish_year" DOUBLE,
  "n_2_2a_population_size_unit" VARCHAR,
  "n_2_2a_population_size_unit_code" VARCHAR,
  "n_2_2b_population_size_minimum" DOUBLE,
  "n_2_2c_population_size_maximum" DOUBLE,
  "n_2_3_type_of_estimate" VARCHAR,
  "n_2_4_method_used" DOUBLE,
  "n_2_5_quality" VARCHAR,
  "n_2_6_sources" VARCHAR,
  "n_2_7_reason_for_change_since_previous_report" VARCHAR,
  "n_2_8_additional_information_optional" VARCHAR,
  "n_3_1_1_short_term_trend_period" VARCHAR,
  "n_3_1_1_start_date" DOUBLE,
  "n_3_1_1_end_date" DOUBLE,
  "n_3_1_2_short_term_trend_direction" VARCHAR,
  "n_3_1_3a_short_term_trend_magnitude_minimim" VARCHAR,
  "n_3_1_3b_short_term_trend_magnitude_maximum" VARCHAR,
  "n_3_1_4_method_used" DOUBLE,
  "n_3_1_5_quality" DOUBLE,
  "n_3_1_6_sources" VARCHAR,
  "n_3_2_1_long_term_trend_period" VARCHAR,
  "n_3_2_1_start_date" DOUBLE,
  "n_3_2_1_end_date" DOUBLE,
  "n_3_2_2_long_term_trend_direction" VARCHAR,
  "n_3_2_3a_long_term_trend_magnitude_minimim" VARCHAR,
  "n_3_2_3b_long_term_trend_magnitude_maximum" VARCHAR,
  "n_3_2_4_method_used" DOUBLE,
  "n_3_2_5_quality" DOUBLE,
  "n_3_2_6_sources" VARCHAR,
  "n_3_3_additional_information_optional" VARCHAR,
  "n_4_1_year_or_period" VARCHAR,
  "n_4_2_sensitive_species" VARCHAR,
  "n_4_3_distribution_map" VARCHAR,
  "n_4_4_additional_distribution_map_optional" VARCHAR,
  "n_4_5_range_map" VARCHAR,
  "n_4_6_range_surface_area" DOUBLE,
  "n_4_7_method_used" DOUBLE,
  "n_4_8_quality" DOUBLE,
  "n_4_9_sources" VARCHAR,
  "n_4_1_reason_for_change_since_previous_report" VARCHAR,
  "n_4_11_additonal_information_optional" VARCHAR,
  "n_5_1_1_short_term_trend_period" VARCHAR,
  "n_5_1_1_start_date" DOUBLE,
  "n_5_1_1_end_date" DOUBLE,
  "n_5_1_2_short_term_trend_direction" VARCHAR,
  "n_5_1_3a_short_term_trend_magnitude_minimim" VARCHAR,
  "n_5_1_3b_short_term_trend_magnitude_maximum" VARCHAR,
  "n_5_1_4_method_used" DOUBLE,
  "n_5_1_5_quality" DOUBLE,
  "n_5_1_6_sources" VARCHAR,
  "n_5_2_1_long_term_trend_period" VARCHAR,
  "n_5_2_1_start_date" DOUBLE,
  "n_5_2_1_end_date" DOUBLE,
  "n_5_2_2_long_term_trend_direction" VARCHAR,
  "n_5_2_3a_long_term_trend_magnitude_minimim" VARCHAR,
  "n_5_2_3b_long_term_trend_magnitude_maximum" VARCHAR,
  "n_5_2_4_method_used" DOUBLE,
  "n_5_2_5_quality" DOUBLE,
  "n_5_2_6_sources" VARCHAR,
  "n_5_2_7_additional_information_optional" VARCHAR,
  "n_6_1_type_of_plan" VARCHAR,
  "n_6_2_has_a_national_plan_linked_to_sap_mp_bms_been_adopted" VARCHAR,
  "n_6_3_if_no_please_describe_the_measures_and_initiativ_5c157d2a" VARCHAR,
  "n_6_4_sources_of_further_information" VARCHAR,
  "n_8_1_1_a_spa_network_population_size_unit" VARCHAR,
  "n_8_1_1_a_spa_network_population_size_unit_code" VARCHAR,
  "n_8_1_1_b_spa_network_population_size_minimum" DOUBLE,
  "n_8_1_1_c_spa_network_population_size_maximum" DOUBLE,
  "n_8_1_2_method_used" DOUBLE,
  "n_8_1_3_short_term_trend_of_population_size_in_the_spa_network" VARCHAR,
  "n_8_1_3_comment_on_spa_trend" VARCHAR,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR,
  "unnamed_83" VARCHAR,
  "unnamed_84" VARCHAR,
  "unnamed_85" VARCHAR,
  "unnamed_86" VARCHAR,
  "unnamed_87" VARCHAR,
  "unnamed_88" VARCHAR,
  "unnamed_89" VARCHAR,
  "unnamed_90" VARCHAR,
  "unnamed_91" VARCHAR,
  "unnamed_92" VARCHAR,
  "unnamed_93" VARCHAR
);