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

164.85 kB
328 rows
94 columns

CREATE TABLE birds_directive_article12_2013_ukdata (
  "n_1_1_member_state" VARCHAR  -- 1.1:Member State,
  "n_1_2_1_euring_code" VARCHAR  -- 1.2.1:EURING Code,
  "n_1_2_2_natura_2000_code" VARCHAR  -- 1.2.2:Natura 2000 Code,
  "n_1_3_species_scientific_name" VARCHAR  -- 1.3:Species Scientific Name,
  "n_1_3_1_sub_specific_population" VARCHAR  -- 1.3.1:Sub-specific Population,
  "n_1_4_alternative_species_scientific_name_optional" VARCHAR  -- 1.4:Alternative Species Scientific Name (optional),
  "n_1_5_common_name_optional" VARCHAR  -- 1.5:Common Name (optional),
  "n_1_6_season" VARCHAR  -- 1.6:Season,
  "n_2_1_year_or_period" VARCHAR  -- 2.1:Year Or Period,
  "n_2_1_start_year" DOUBLE  -- 2.1:Start Year,
  "n_2_1_finish_year" DOUBLE  -- 2.1:Finish Year,
  "n_2_2a_population_size_unit" VARCHAR  -- 2.2a:Population Size - Unit,
  "n_2_2a_population_size_unit_code" VARCHAR  -- 2.2a:Population Size - Unit - Code,
  "n_2_2b_population_size_minimum" DOUBLE  -- 2.2b:Population Size - Minimum,
  "n_2_2c_population_size_maximum" DOUBLE  -- 2.2c:Population Size - Maximum,
  "n_2_3_type_of_estimate" VARCHAR  -- 2.3:Type Of Estimate,
  "n_2_4_method_used" DOUBLE  -- 2.4:Method Used,
  "n_2_5_quality" VARCHAR  -- 2.5:Quality,
  "n_2_6_sources" VARCHAR  -- 2.6:Sources,
  "n_2_7_reason_for_change_since_previous_report" VARCHAR  -- 2.7:Reason For Change (since Previous Report),
  "n_2_8_additional_information_optional" VARCHAR  -- 2.8:Additional Information (optional),
  "n_3_1_1_short_term_trend_period" VARCHAR  -- 3.1.1:Short-term Trend, Period,
  "n_3_1_1_start_date" DOUBLE  -- 3.1.1:Start Date,
  "n_3_1_1_end_date" DOUBLE  -- 3.1.1:End Date,
  "n_3_1_2_short_term_trend_direction" VARCHAR  -- 3.1.2:Short-term Trend, Direction,
  "n_3_1_3a_short_term_trend_magnitude_minimim" VARCHAR  -- 3.1.3a:Short-term Trend, Magnitude (Minimim),
  "n_3_1_3b_short_term_trend_magnitude_maximum" VARCHAR  -- 3.1.3b:Short-term Trend, Magnitude (Maximum),
  "n_3_1_4_method_used" DOUBLE  -- 3.1.4:Method Used,
  "n_3_1_5_quality" DOUBLE  -- 3.1.5:Quality,
  "n_3_1_6_sources" VARCHAR  -- 3.1.6:Sources,
  "n_3_2_1_long_term_trend_period" VARCHAR  -- 3.2.1:Long-term Trend, Period,
  "n_3_2_1_start_date" DOUBLE  -- 3.2.1:Start Date,
  "n_3_2_1_end_date" DOUBLE  -- 3.2.1:End Date,
  "n_3_2_2_long_term_trend_direction" VARCHAR  -- 3.2.2:Long-term Trend, Direction,
  "n_3_2_3a_long_term_trend_magnitude_minimim" VARCHAR  -- 3.2.3a:Long-term Trend, Magnitude (Minimim),
  "n_3_2_3b_long_term_trend_magnitude_maximum" VARCHAR  -- 3.2.3b:Long-term Trend, Magnitude (Maximum),
  "n_3_2_4_method_used" DOUBLE  -- 3.2.4:Method Used,
  "n_3_2_5_quality" DOUBLE  -- 3.2.5:Quality,
  "n_3_2_6_sources" VARCHAR  -- 3.2.6:Sources,
  "n_3_3_additional_information_optional" VARCHAR  -- 3.3:Additional Information (optional),
  "n_4_1_year_or_period" VARCHAR  -- 4.1:Year Or Period,
  "n_4_2_sensitive_species" VARCHAR  -- 4.2:Sensitive Species,
  "n_4_3_distribution_map" VARCHAR  -- 4.3:Distribution Map,
  "n_4_4_additional_distribution_map_optional" VARCHAR  -- 4.4:Additional Distribution Map (optional),
  "n_4_5_range_map" VARCHAR  -- 4.5:Range Map,
  "n_4_6_range_surface_area" DOUBLE  -- 4.6:Range Surface Area,
  "n_4_7_method_used" DOUBLE  -- 4.7:Method Used,
  "n_4_8_quality" DOUBLE  -- 4.8:Quality,
  "n_4_9_sources" VARCHAR  -- 4.9:Sources,
  "n_4_1_reason_for_change_since_previous_report" VARCHAR  -- 4.1:Reason For Change (since Previous Report),
  "n_4_11_additonal_information_optional" VARCHAR  -- 4.11:Additonal Information (optional),
  "n_5_1_1_short_term_trend_period" VARCHAR  -- 5.1.1:Short-term Trend, Period,
  "n_5_1_1_start_date" DOUBLE  -- 5.1.1:Start Date,
  "n_5_1_1_end_date" DOUBLE  -- 5.1.1:End Date,
  "n_5_1_2_short_term_trend_direction" VARCHAR  -- 5.1.2:Short-term Trend, Direction,
  "n_5_1_3a_short_term_trend_magnitude_minimim" VARCHAR  -- 5.1.3a:Short-term Trend, Magnitude (Minimim),
  "n_5_1_3b_short_term_trend_magnitude_maximum" VARCHAR  -- 5.1.3b:Short-term Trend, Magnitude (Maximum),
  "n_5_1_4_method_used" DOUBLE  -- 5.1.4:Method Used,
  "n_5_1_5_quality" DOUBLE  -- 5.1.5:Quality,
  "n_5_1_6_sources" VARCHAR  -- 5.1.6:Sources,
  "n_5_2_1_long_term_trend_period" VARCHAR  -- 5.2.1:Long-term Trend, Period,
  "n_5_2_1_start_date" DOUBLE  -- 5.2.1:Start Date,
  "n_5_2_1_end_date" DOUBLE  -- 5.2.1:End Date,
  "n_5_2_2_long_term_trend_direction" VARCHAR  -- 5.2.2:Long-term Trend, Direction,
  "n_5_2_3a_long_term_trend_magnitude_minimim" VARCHAR  -- 5.2.3a:Long-term Trend, Magnitude (Minimim),
  "n_5_2_3b_long_term_trend_magnitude_maximum" VARCHAR  -- 5.2.3b:Long-term Trend, Magnitude (Maximum),
  "n_5_2_4_method_used" DOUBLE  -- 5.2.4:Method Used,
  "n_5_2_5_quality" DOUBLE  -- 5.2.5:Quality,
  "n_5_2_6_sources" VARCHAR  -- 5.2.6:Sources,
  "n_5_2_7_additional_information_optional" VARCHAR  -- 5.2.7:Additional Information (optional),
  "n_6_1_type_of_plan" VARCHAR  -- 6.1:Type Of Plan,
  "n_6_2_has_a_national_plan_linked_to_sap_mp_bms_been_adopted" VARCHAR  -- 6.2:Has A National Plan Linked To SAP/MP/BMS Been Adopted,
  "n_6_3_if_no_please_describe_the_measures_and_initiativ_5c157d2a" VARCHAR  -- 6.3:If 'NO', Please Describe The Measures And Initiatives Taken Pursuant To The SAP/MP/BMS,
  "n_6_4_sources_of_further_information" VARCHAR  -- 6.4:Sources Of Further Information,
  "n_8_1_1_a_spa_network_population_size_unit" VARCHAR  -- 8.1.1 A:SPA Network Population Size: Unit,
  "n_8_1_1_a_spa_network_population_size_unit_code" VARCHAR  -- 8.1.1 A:SPA Network Population Size: Unit - Code,
  "n_8_1_1_b_spa_network_population_size_minimum" DOUBLE  -- 8.1.1 B:SPA Network Population Size: Minimum,
  "n_8_1_1_c_spa_network_population_size_maximum" DOUBLE  -- 8.1.1 C:SPA Network Population Size: Maximum,
  "n_8_1_2_method_used" DOUBLE  -- 8.1.2:Method Used,
  "n_8_1_3_short_term_trend_of_population_size_in_the_spa_network" VARCHAR  -- 8.1.3:Short-term Trend Of Population Size In The SPA Network,
  "n_8_1_3_comment_on_spa_trend" VARCHAR  -- 8.1.3:[Comment On SPA Trend],
  "unnamed_81" VARCHAR  -- Unnamed: 81,
  "unnamed_82" VARCHAR  -- Unnamed: 82,
  "unnamed_83" VARCHAR  -- Unnamed: 83,
  "unnamed_84" VARCHAR  -- Unnamed: 84,
  "unnamed_85" VARCHAR  -- Unnamed: 85,
  "unnamed_86" VARCHAR  -- Unnamed: 86,
  "unnamed_87" VARCHAR  -- Unnamed: 87,
  "unnamed_88" VARCHAR  -- Unnamed: 88,
  "unnamed_89" VARCHAR  -- Unnamed: 89,
  "unnamed_90" VARCHAR  -- Unnamed: 90,
  "unnamed_91" VARCHAR  -- Unnamed: 91,
  "unnamed_92" VARCHAR  -- Unnamed: 92,
  "unnamed_93" VARCHAR  -- Unnamed: 93
);