data-raw/lookup_raw.R

library(magrittr)

# common_name
common_name <- tibble::tribble(
  ~speciescode,                    ~common_name,
  "A001",            "Red-throated Diver",
  "A002",          "Black-throated Diver",
  "A003",          "Great Northern Diver",
  "A004",                  "Little Grebe",
  "A005",           "Great Crested Grebe",
  "A006",              "Red-necked Grebe",
  "A007",                  "Horned Grebe",
  "A008",            "Black-necked Grebe",
  "A009",                        "Fulmar",
  "A013",               "Manx Shearwater",
  "A014",         "European Storm-petrel",
  "A016",               "Northern Gannet",
  "A021",                 "Great Bittern",
  "A022",                "Little Bittern",
  "A025",                  "Cattle Egret",
  "A026",                  "Little Egret",
  "A028",                    "Grey Heron",
  "A034",            "Eurasian Spoonbill",
  "A036",                     "Mute Swan",
  "A037",                   "Tundra Swan",
  "A038",                  "Whooper Swan",
  "A040-B",             "Pink-footed Goose",
  "A043",                 "Greylag Goose",
  "A044-X",                  "Canada Goose",
  "A045-A",                "Barnacle Goose",
  "A045-B",                "Barnacle Goose",
  "A045-X",                "Barnacle Goose",
  "A048",               "Common Shelduck",
  "A052",                   "Common Teal",
  "A053",                       "Mallard",
  "A054",              "Northern Pintail",
  "A058-X",           "Red-crested Pochard",
  "A059",                "Common Pochard",
  "A061",                   "Tufted Duck",
  "A062",                 "Greater Scaup",
  "A063",                  "Common Eider",
  "A064",              "Long-tailed Duck",
  "A066",                 "Velvet Scoter",
  "A067",              "Common Goldeneye",
  "A069",        "Red-breasted Merganser",
  "A070",              "Common Merganser",
  "A072",        "European Honey-buzzard",
  "A074",                      "Red Kite",
  "A075",            "White-tailed Eagle",
  "A081",         "Western Marsh-harrier",
  "A082",                   "Hen Harrier",
  "A084",             "Montagu's Harrier",
  "A087",                "Common Buzzard",
  "A091",                  "Golden Eagle",
  "A094",                        "Osprey",
  "A096",                "Common Kestrel",
  "A098",                        "Merlin",
  "A099",                "Eurasian Hobby",
  "A103",              "Peregrine Falcon",
  "A110-X",          "Red-legged Partridge",
  "A113",                  "Common Quail",
  "A115-X",               "Common Pheasant",
  "A118",                    "Water Rail",
  "A119",                 "Spotted Crake",
  "A122",                     "Corncrake",
  "A123",                "Common Moorhen",
  "A125",                   "Common Coot",
  "A127",                  "Common Crane",
  "A129",                 "Great Bustard",
  "A130",        "Eurasian Oystercatcher",
  "A131",            "Black-winged Stilt",
  "A132",                   "Pied Avocet",
  "A133",           "Eurasian Thick-knee",
  "A136",          "Little Ringed Plover",
  "A137",          "Common Ringed Plover",
  "A140",        "Eurasian Golden Plover",
  "A141",                   "Grey Plover",
  "A142",              "Northern Lapwing",
  "A143",                      "Red Knot",
  "A144",                    "Sanderling",
  "A146",              "Temminck's Stint",
  "A148",              "Purple Sandpiper",
  "A149",                        "Dunlin",
  "A152",                    "Jack Snipe",
  "A153",                  "Common Snipe",
  "A155",             "Eurasian Woodcock",
  "A156",             "Black-tailed Godwit",
  "A157",             "Bar-tailed Godwit",
  "A158",                      "Whimbrel",
  "A161",              "Spotted Redshank",
  "A162",               "Common Redshank",
  "A164",             "Common Greenshank",
  "A165",               "Green Sandpiper",
  "A166",                "Wood Sandpiper",
  "A168",              "Common Sandpiper",
  "A169",               "Ruddy Turnstone",
  "A170",          "Red-necked Phalarope",
  "A173",              "Parasitic Jaeger",
  "A175",                    "Great Skua",
  "A176",            "Mediterranean Gull",
  "A179",             "Black-headed Gull",
  "A182",                      "Mew Gull",
  "A185",                      "Iceland Gull",
  "A186",                      "Glaucous Gull",
  "A187",       "Great Black-backed Gull",
  "A188",        "Black-legged Kittiwake",
  "A192",                  "Roseate Tern",
  "A193",                   "Common Tern",
  "A194",                   "Arctic Tern",
  "A197",                    "Black Tern",
  "A200",                     "Razorbill",
  "A202",               "Black Guillemot",
  "A203",               "Little Auk",
  "A204",               "Atlantic Puffin",
  "A206-X",                   "Rock Pigeon",
  "A206",                   "Rock Pigeon",
  "A207",                    "Stock Dove",
  "A209",        "Eurasian Collared-dove",
  "A210",          "European Turtle-dove",
  "A212",                 "Common Cuckoo",
  "A213",                      "Barn Owl",
  "A215-X",                     "Eagle Owl",
  "A218-X",                    "Little Owl",
  "A219",                     "Tawny Owl",
  "A221",                "Long-eared Owl",
  "A222",               "Short-eared Owl",
  "A224",             "Eurasian Nightjar",
  "A226",                  "Common Swift",
  "A229",             "Common Kingfisher",
  "A233",              "Eurasian Wryneck",
  "A246",                     "Wood Lark",
  "A247",              "Eurasian Skylark",
  "A249",                   "Sand Martin",
  "A251",                  "Barn Swallow",
  "A256",                    "Tree Pipit",
  "A257",                  "Meadow Pipit",
  "A260",                "Yellow Wagtail",
  "A261",                  "Grey Wagtail",
  "A262",                 "White Wagtail",
  "A264",         "White-throated Dipper",
  "A266",                "Hedge Accentor",
  "A269",                "European Robin",
  "A271",            "Common Nightingale",
  "A273",                "Black Redstart",
  "A274",               "Common Redstart",
  "A275",                      "Whinchat",
  "A276",              "Common Stonechat",
  "A277",             "Northern Wheatear",
  "A282",                    "Ring Ouzel",
  "A283",            "Eurasian Blackbird",
  "A284",                     "Fieldfare",
  "A285",                   "Song Thrush",
  "A286",                       "Redwing",
  "A287",                 "Mistle Thrush",
  "A288",               "Cetti's Warbler",
  "A290",    "Common Grasshopper-warbler",
  "A292",                "Savi's Warbler",
  "A294",               "Aquatic Warbler",
  "A295",                 "Sedge Warbler",
  "A296",                 "Marsh Warbler",
  "A297",         "Eurasian Reed-warbler",
  "A302",              "Dartford Warbler",
  "A309",            "Common Whitethroat",
  "A310",                "Garden Warbler",
  "A311",                      "Blackcap",
  "A314",                  "Wood Warbler",
  "A316",                "Willow Warbler",
  "A317",                     "Goldcrest",
  "A318",                     "Firecrest",
  "A319",            "Spotted Flycatcher",
  "A322",      "European Pied Flycatcher",
  "A323",            "Bearded Parrotbill",
  "A324",               "Long-tailed Tit",
  "A330",                     "Great Tit",
  "A332",                 "Wood Nuthatch",
  "A334",          "Eurasian Treecreeper",
  "A337",        "Eurasian Golden Oriole",
  "A338",             "Red-backed Shrike",
  "A342",                  "Eurasian Jay",
  "A343",           "Black-billed Magpie",
  "A346",             "Red-billed Chough",
  "A347",              "Eurasian Jackdaw",
  "A348",                          "Rook",
  "A349",                  "Carrion Crow",
  "A350",                  "Common Raven",
  "A351",               "Common Starling",
  "A356",         "Eurasian Tree Sparrow",
  "A360",                     "Brambling",
  "A363",           "European Greenfinch",
  "A364",            "European Goldfinch",
  "A369",                 "Red Crossbill",
  "A370",              "Parrot Crossbill",
  "A372",            "Eurasian Bullfinch",
  "A373",                      "Hawfinch",
  "A374",              "Lapland Longspur",
  "A375",                  "Snow Bunting",
  "A376",                  "Yellowhammer",
  "A377",                  "Cirl Bunting",
  "A381",                  "Reed Bunting",
  "A383",                  "Corn Bunting",
  "A391",               "Great Cormorant",
  "A394",  "European White-fronted Goose",
  "A395", "Greenland White-fronted Goose",
  "A397-X",                "Ruddy Shelduck",
  "A434",                   "Winter Wren",
  "A451",            "Scottish Crossbill",
  "A460-X",                   "Wild Turkey",
  "A463",              "Willow Ptarmigan",
  "A466-A",                        "Dunlin",
  "A472",                      "Coal Tit",
  "A474",                "Common Redpoll",
  "A476",               "Eurasian Linnet",
  "A477",                         "Twite",
  "A478",               "Eurasian Siskin",
  "A483",                      "Blue Tit",
  "A489",      "Lesser Black-backed Gull",
  "A492",                    "Willow Tit",
  "A493",                     "Marsh Tit",
  "A497",                   "Crested Tit",
  "A502",            "White-billed Diver",
  "A553-X",                 "Mandarin Duck",
  "A556-X",                    "Snow Goose",
  "A557-X",               "Golden Pheasant",
  "A558-X",             "Reeves's Pheasant",
  "A572",             "Common Chiffchaff",
  "A574",            "Lesser Whitethroat",
  "A614-A",           "Black-tailed Godwit",
  "A616",           "Black-tailed Godwit",
  "A620",                 "House Sparrow",
  "A644",                "Grey Partridge",
  "A657",            "Eurasian Chaffinch",
  "A658",      "Great Spotted Woodpecker",
  "A659",          "Western Capercaillie",
  "A666",                    "Rock Pipit",
  "A674-A",                   "Brent Goose",
  "A674-B",                   "Brent Goose",
  "A675",                   "Brent Goose",
  "A676",                   "Winter Wren",
  "A681",                "Lesser Redpoll",
  "A683",               "Great Cormorant",
  "A684",                 "European Shag",
  "A687",            "Common Wood-pigeon",
  "A693",           "Balearic Shearwater",
  "A701",                    "Bean Goose",
  "A702",                    "Bean Goose",
  "A711",              "Willow Ptarmigan",
  "A727",             "Eurasian Dotterel",
  "A738",         "Northern House-martin",
  "A747-X",                    "Black Swan",
  "A748-X",                "Egyptian Goose",
  "A749-X",                     "Wood Duck",
  "A750-X",                    "Ruddy Duck",
  "A751-X",                  "Muscovy Duck",
  "A755-X",       "Lady Amherst's Pheasant",
  "A756-X",                "Indian Peafowl",
  "A757-X",           "Helmeted Guineafowl",
  "A760-X",          "Rose-ringed Parakeet",
  "A761-X",                 "Monk Parakeet",
  "A767",                          "Smew",
  "A768",               "Eurasian Curlew",
  "A773",             "Great White Egret",
  "A844-X",                 "Emperor Goose",
  "A845-X",              "Bar-headed Goose",
  "A846-X",               "Red-tailed Hawk",
  "A847-X",                 "Harris's Hawk",
  "A848-X",           "Rosy-faced Lovebird",
  "A854",          "Leach's Storm-petrel",
  "A855",               "Eurasian Wigeon",
  "A856",                      "Garganey",
  "A857",             "Northern Shoveler",
  "A861",                          "Ruff",
  "A862",                   "Little Gull",
  "A863",                 "Sandwich Tern",
  "A866",     "Eurasian Green Woodpecker",
  "A869",     "Lesser Spotted Woodpecker",
  "A877",                  "Black Grouse",
  "A885",                   "Little Tern",
  "A887",              "Common Guillemot",
  "A889",                       "Gadwall",
  "A891",                "Rock Ptarmigan",
  "A895",                  "Herring Gull",
  "A898",          "Eurasian Sparrowhawk",
  "A899",              "Northern Goshawk",
  "A900",                 "Common Scoter"
)
  
# information_assessement_look_up
url <- "http://biodiversity.eionet.europa.eu/activities/Reporting/Article_12/Reports_2019/Files_2019/art12_checklist_v2_update20180616.xls"
dest_file <- "art12_checklist_v2_update20180616.xls"
curl::curl_download(url, dest_file)
information_assessment_look_up <- readxl::read_excel(dest_file, sheet = "Art12 checklist") %>% 
  janitor::clean_names() %>% 
  dplyr::filter(country == "UK") %>% 
  dplyr::rename(speciescode = species_code,
                speciesname = species_name) %>%
  dplyr::left_join(common_name, by = "speciescode") %>% 
  dplyr::mutate(season = dplyr::case_when 
                (
                  stringr::str_to_lower(season) == "b" ~ "breeding",
                  stringr::str_to_lower(season) == "w" ~ "winter",
                  stringr::str_to_lower(season) == "p" ~ "passage",
                  TRUE ~ season
                )) %>%
  dplyr::mutate(occurrence = dplyr::case_when 
                (
                  stringr::str_to_lower(occurrence) == "pre" ~ "present",
                  stringr::str_to_lower(occurrence) == "arr" ~ "colonised",
                  stringr::str_to_lower(occurrence) == "exba" ~ "extinct",
                  TRUE ~ occurrence
                )) %>%
  dplyr::mutate(recommended_unit = dplyr::case_when 
                (
                  stringr::str_to_lower(recommended_unit) == "bfemales" ~ "breeding females",
                  stringr::str_to_lower(recommended_unit) == "cmales" ~ "calling males",
                  stringr::str_to_lower(recommended_unit) == "i" ~ "individuals",
                  stringr::str_to_lower(recommended_unit) == "males" ~ "males",  
                  stringr::str_to_lower(recommended_unit) == "p" ~ "pairs",    
                  TRUE ~ recommended_unit
                )) %>% 
  dplyr::select(speciescode,
                euringcode,
                speciesname,
                sub_unit,
                common_name,
                season,
                occurrence,
                recommended_unit) %>% 
  dplyr::arrange(speciesname, sub_unit)

# information_common_name_look_up
information_common_name_look_up <- tibble::tribble(
                                     ~speciescode,                                 ~common_name,                                                    ~additional_info, ~common_name_match,                        ~scientific_name,                                                     ~sub_unit,
                                           "A294",                            "Aquatic Warbler",                                                                  NA,              "yes",               "Acrocephalus paludicola",                                                            NA,
                                           "A194",                                "Arctic Tern",                                                                  NA,              "yes",                     "Sterna paradisaea",                                                            NA,
                                           "A204",                            "Atlantic Puffin",                                                                  NA,              "yes",                    "Fratercula arctica",                                                            NA,
                                           "A693",                        "Balearic Shearwater",                                                                  NA,              "yes",                 "Puffinus mauretanicus",                                                            NA,
                                         "A845-X",                           "Bar-headed Goose",                                                                  NA,              "yes",                         "Anser indicus",                                                            NA,
                                           "A213",                                   "Barn Owl",                                                                  NA,              "yes",                             "Tyto alba",                                                            NA,
                                           "A251",                               "Barn Swallow",                                                                  NA,              "yes",                       "Hirundo rustica",                                                            NA,
                                         "A045-A",                             "Barnacle Goose",                                 "East Greenland/Scotland & Ireland",               "no",                      "Branta leucopsis",                           "East Greenland/Scotland & Ireland",
                                         "A045-B",                             "Barnacle Goose",                                      "Svalbard/South-west Scotland",               "no",                      "Branta leucopsis",                                "Svalbard/South-west Scotland",
                                         "A045-X",                             "Barnacle Goose",                                            "non-native populations",               "no",                      "Branta leucopsis",                                      "non-native populations",
                                         "A045-X",                "Barnacle Goose, naturalised",                                                                  NA,              "yes",                      "Branta leucopsis",                                      "non-native populations",
                                         "A045-A",                  "Barnacle Goose, Greenland",                                                                  NA,              "yes",                      "Branta leucopsis",                           "East Greenland/Scotland & Ireland",
                                         "A045-B",                   "Barnacle Goose, Svalbard",                                                                  NA,              "yes",                      "Branta leucopsis",                                "Svalbard/South-west Scotland",
                                           "A157",                          "Bar-tailed Godwit",                                                                  NA,              "yes",                      "Limosa lapponica",                                                            NA,
                                           "A701",                                 "Bean Goose",                                             "Anser fabalis fabalis",               "no",                 "Anser fabalis fabalis",                                                            NA,
                                           "A702",                                 "Bean Goose",                                            "Anser fabalis rossicus",               "no",                "Anser fabalis rossicus",                                                            NA,
                                           "A701",                         "Bean Goose fabalis",                                                                  NA,              "yes",                 "Anser fabalis fabalis",                                                            NA,
                                           "A701",                          "Bean Goose, Taiga",                                                                  NA,              "yes",                 "Anser fabalis fabalis",                                                            NA,
                                           "A323",                         "Bearded Parrotbill",                                                                  NA,              "yes",                     "Panurus biarmicus",                                                            NA,
                                           "A037",                              "Bewick's Swan",                                                                  NA,              "yes",           "Cygnus columbianus bewickii",                                                            NA,
                                           "A877",                               "Black Grouse",                                                                  NA,              "yes",            "Lyrurus tetrix britannicus",                                                            NA,
                                           "A202",                            "Black Guillemot",                                                                  NA,              "yes",                        "Cepphus grylle",                                                            NA,
                                           "A273",                             "Black Redstart",                                                                  NA,              "yes",                  "Phoenicurus ochruros",                                                            NA,
                                         "A747-X",                                 "Black Swan",                                                                  NA,              "yes",                        "Cygnus atratus",                                                            NA,
                                           "A197",                                 "Black Tern",                                                                  NA,              "yes",                      "Chlidonias niger",                                                            NA,
                                           "A343",                        "Black-billed Magpie",                                                                  NA,              "yes",                             "Pica pica",                                                            NA,
                                           "A311",                                   "Blackcap",                                                                  NA,              "yes",                    "Sylvia atricapilla",                                                            NA,
                                           "A179",                          "Black-headed Gull",                                                                  NA,              "yes",                      "Larus ridibundus",                                                            NA,
                                           "A188",                     "Black-legged Kittiwake",                                                                  NA,              "yes",                      "Rissa tridactyla",                                                            NA,
                                           "A008",                         "Black-necked Grebe",                                                                  NA,              "yes",                  "Podiceps nigricollis",                                                            NA,
                                           "A156",                        "Black-tailed Godwit",                       "Limosa limosa, all non-breeding populations",               "no",                         "Limosa limosa",                                "all non-breeding populations",
                                         "A614-A",                        "Black-tailed Godwit",            "Limosa limosa limosa,  Western Europe/NW & West Africa",               "no",                  "Limosa limosa limosa",                             "Western Europe/NW & West Africa",
                                           "A616",                        "Black-tailed Godwit",                                           "Limosa limosa islandica",               "no",               "Limosa limosa islandica",                                                            NA,
                                           "A616",              "Black-tailed Godwit islandica",                                                                  NA,              "yes",               "Limosa limosa islandica",                                                            NA,
                                         "A614-A",                 "Black-tailed Godwit limosa",                                                                  NA,              "yes",                  "Limosa limosa limosa",                             "Western Europe/NW & West Africa",
                                           "A002",                       "Black-throated Diver",                                                                  NA,              "yes",                         "Gavia arctica",                                                            NA,
                                           "A131",                         "Black-winged Stilt",                                                                  NA,              "yes",                 "Himantopus himantopus",                                                            NA,
                                           "A483",                                   "Blue Tit",                                                                  NA,              "yes",           "Cyanistes caeruleus s. str.",                        "sensu stricto [excluding teneriffae]",
                                           "A360",                                  "Brambling",                                                                  NA,              "yes",              "Fringilla montifringilla",                                                            NA,
                                         "A674-A",                                "Brent Goose",  "Branta bernicla hrota, Canada & Greenland/Ireland, Light-bellied",               "no",                 "Branta bernicla hrota",                                  "Canada & Greenland/Ireland",
                                         "A674-B",                                "Brent Goose",       "Branta bernicla hrota, Svalbard/Denmark & UK, Light-bellied",               "no",                 "Branta bernicla hrota",                                       "Svalbard/Denmark & UK",
                                           "A675",                                "Brent Goose",                            "Branta bernicla bernicla, Dark-bellied",               "no",              "Branta bernicla bernicla",                                                            NA,
                                         "A044-X",                               "Canada Goose",                                                                  NA,              "yes",                     "Branta canadensis",                                                            NA,
                                         "A674-A",         "Canadian Light-bellied Brent Goose",                                                                  NA,              "yes",                 "Branta bernicla hrota",                                  "Canada & Greenland/Ireland",
                                           "A349",                               "Carrion Crow",                                                                  NA,              "yes",                         "Corvus corone",                                          "[including cornix]",
                                           "A025",                               "Cattle Egret",                                                                  NA,              "yes",                         "Bubulcus ibis",                                                            NA,
                                           "A288",                            "Cetti's Warbler",                                                                  NA,              "yes",                          "Cettia cetti",                                                            NA,
                                           "A377",                               "Cirl Bunting",                                                                  NA,              "yes",                       "Emberiza cirlus",                                                            NA,
                                           "A472",                                   "Coal Tit",                                                                  NA,              "yes",             "Periparus ater all others",                                                            NA,
                                           "A087",                             "Common Buzzard",                                                                  NA,              "yes",                           "Buteo buteo",                                                            NA,
                                           "A572",                          "Common Chiffchaff",                                                                  NA,              "yes",        "Phylloscopus collybita s. str.", "sensu stricto [excluding canariensis, ibericus and tristis]",
                                           "A125",                                "Common Coot",                                                                  NA,              "yes",                           "Fulica atra",                                                            NA,
                                           "A127",                               "Common Crane",                                                                  NA,              "yes",                             "Grus grus",                                                            NA,
                                           "A212",                              "Common Cuckoo",                                                                  NA,              "yes",                       "Cuculus canorus",                                                            NA,
                                           "A063",                               "Common Eider",                                                                  NA,              "yes",                  "Somateria mollissima",                                                            NA,
                                           "A067",                           "Common Goldeneye",                                                                  NA,              "yes",                    "Bucephala clangula",                                                            NA,
                                           "A290",                 "Common Grasshopper-warbler",                                                                  NA,              "yes",                     "Locustella naevia",                                                            NA,
                                           "A164",                          "Common Greenshank",                                                                  NA,              "yes",                      "Tringa nebularia",                                                            NA,
                                           "A887",                           "Common Guillemot",                                                                  NA,              "yes",                 "Uria aalge all others",                                                            NA,
                                           "A887",                     "Common Guillemot aalge",                                                                  NA,              "yes",                 "Uria aalge all others",                                                            NA,
                                           "A887",                    "Common Guillemot, aalge",                                                                  NA,              "yes",                 "Uria aalge all others",                                                            NA,
                                           "A887",                  "Common Guillemot albionis",                                                                  NA,              "yes",                 "Uria aalge all others",                                                            NA,
                                           "A887",                 "Common Guillemot, albionis",                                                                  NA,              "yes",                 "Uria aalge all others",                                                            NA,
                                           "A182",                                "Common Gull",                                                                  NA,              "yes",                           "Larus canus",                                                            NA,
                                           "A096",                             "Common Kestrel",                                                                  NA,              "yes",                     "Falco tinnunculus",                                                            NA,
                                           "A229",                          "Common Kingfisher",                                                                  NA,              "yes",                         "Alcedo atthis",                                                            NA,
                                           "A070",                           "Common Merganser",                                                                  NA,              "yes",                      "Mergus merganser",                                                            NA,
                                           "A123",                             "Common Moorhen",                                                                  NA,              "yes",                   "Gallinula chloropus",                                                            NA,
                                           "A271",                         "Common Nightingale",                                                                  NA,              "yes",                 "Luscinia megarhynchos",                                                            NA,
                                         "A115-X",                            "Common Pheasant",                                                                  NA,              "yes",                   "Phasianus colchicus",                                      "non-native populations",
                                           "A059",                             "Common Pochard",                                                                  NA,              "yes",                         "Aythya ferina",                                                            NA,
                                           "A113",                               "Common Quail",                                                                  NA,              "yes",                     "Coturnix coturnix",                                                            NA,
                                           "A350",                               "Common Raven",                                                                  NA,              "yes",                          "Corvus corax",                                                            NA,
                                           "A474",                             "Common Redpoll",                                                                  NA,              "yes",                      "Acanthis flammea",                            "[including cabaret and exilipes]",
                                           "A162",                            "Common Redshank",                                                                  NA,              "yes",                        "Tringa totanus",                                                            NA,
                                           "A274",                            "Common Redstart",                                                                  NA,              "yes",               "Phoenicurus phoenicurus",                                                            NA,
                                           "A137",                       "Common Ringed Plover",                                                                  NA,              "yes",                  "Charadrius hiaticula",                                                            NA,
                                           "A168",                           "Common Sandpiper",                                                                  NA,              "yes",                    "Actitis hypoleucos",                                                            NA,
                                           "A900",                              "Common Scoter",                                                                  NA,              "yes",               "Melanitta nigra s. str.",                         "sensu stricto [excluding americana]",
                                           "A048",                            "Common Shelduck",                                                                  NA,              "yes",                       "Tadorna tadorna",                                                            NA,
                                           "A153",                               "Common Snipe",                                                                  NA,              "yes",                   "Gallinago gallinago",                                                            NA,
                                           "A351",                            "Common Starling",                                                                  NA,              "yes",                      "Sturnus vulgaris",                                                            NA,
                                           "A276",                           "Common Stonechat",                                                                  NA,              "yes",                    "Saxicola torquatus",                                                            NA,
                                           "A226",                               "Common Swift",                                                                  NA,              "yes",                             "Apus apus",                                                            NA,
                                           "A226",                              "Common Swift,",                                                                  NA,              "yes",                             "Apus apus",                                                            NA,
                                           "A052",                                "Common Teal",                                                                  NA,              "yes",                           "Anas crecca",                                                            NA,
                                           "A193",                                "Common Tern",                                                                  NA,              "yes",                        "Sterna hirundo",                                                            NA,
                                           "A309",                         "Common Whitethroat",                                                                  NA,              "yes",                       "Sylvia communis",                                                            NA,
                                           "A687",                         "Common Wood-pigeon",                                                                  NA,              "yes",             "Columba palumbus palumbus",                                                            NA,
                                           "A683",                            "Cormorant carbo",                                                                  NA,              "yes",             "Phalacrocorax carbo carbo",                                                            NA,
                                           "A391",                         "Cormorant sinensis",                                                                  NA,              "yes",          "Phalacrocorax carbo sinensis",                                                            NA,
                                           "A383",                               "Corn Bunting",                                                                  NA,              "yes",                     "Emberiza calandra",                                                            NA,
                                           "A122",                                  "Corncrake",                                                                  NA,              "yes",                             "Crex crex",                                                            NA,
                                           "A497",                                "Crested Tit",                                                                  NA,              "yes",                 "Lophophanes cristatus",                                                            NA,
                                           "A675",                   "Dark-bellied Brent Geese",                                                                  NA,              "yes",              "Branta bernicla bernicla",                                                            NA,
                                           "A675",                   "Dark-bellied Brent Goose",                                                                  NA,              "yes",              "Branta bernicla bernicla",                                                            NA,
                                           "A302",                           "Dartford Warbler",                                                                  NA,              "yes",                         "Sylvia undata",                                                            NA,
                                           "A149",                                     "Dunlin",                     "Calidris alpina, all non-breeding populations",               "no",                       "Calidris alpina",                                "all non-breeding populations",
                                         "A466-A",                                     "Dunlin", "Calidris alpina schinzii, Britain & Ireland/SW Europe & NW Africa",               "no",              "Calidris alpina schinzii",                     "Britain & Ireland/SW Europe & NW Africa",
                                           "A149",                              "Dunlin alpina",                                                                  NA,              "yes",                       "Calidris alpina",                                "all non-breeding populations",
                                         "A466-A",                            "Dunlin schinzii",                                                                  NA,              "yes",              "Calidris alpina schinzii",                     "Britain & Ireland/SW Europe & NW Africa",
                                         "A215-X",                                  "Eagle Owl",                                                                  NA,              "yes",                             "Bubo bubo",                                      "non-native populations",
                                         "A748-X",                             "Egyptian Goose",                                                                  NA,              "yes",                  "Alopochen aegyptiaca",                                                            NA,
                                           "A063",                                      "Eider",                                                                  NA,              "yes",                  "Somateria mollissima",                                                            NA,
                                         "A844-X",                              "Emperor Goose",                                                                  NA,              "yes",                       "Anser canagicus",                                                            NA,
                                           "A283",                         "Eurasian Blackbird",                                                                  NA,              "yes",                         "Turdus merula",                                                            NA,
                                           "A372",                         "Eurasian Bullfinch",                                                                  NA,              "yes",                     "Pyrrhula pyrrhula",                                                            NA,
                                           "A657",                         "Eurasian Chaffinch",                                                                  NA,              "yes",          "Fringilla coelebs all others",                                                            NA,
                                           "A209",                     "Eurasian Collared Dove",                                                                  NA,              "yes",                 "Streptopelia decaocto",                                                            NA,
                                           "A209",                     "Eurasian Collared-dove",                                                                  NA,              "yes",                 "Streptopelia decaocto",                                                            NA,
                                           "A768",                            "Eurasian Curlew",                                                                  NA,              "yes",              "Numenius arquata arquata",                                                            NA,
                                           "A727",                          "Eurasian Dotterel",                                                                  NA,              "yes",                  "Eudromias morinellus",                                                            NA,
                                           "A337",                     "Eurasian Golden Oriole",                                                                  NA,              "yes",                       "Oriolus oriolus",                                                            NA,
                                           "A140",                     "Eurasian Golden Plover",                                                                  NA,              "yes",                   "Pluvialis apricaria",                                                            NA,
                                           "A140",                    "Eurasian Golden Plover,",                                                                  NA,              "yes",                   "Pluvialis apricaria",                                                            NA,
                                           "A866",                  "Eurasian Green Woodpecker",                                                                  NA,              "yes",                 "Picus viridis s. str.",                           "sensu stricto [excluding sharpei]",
                                           "A099",                             "Eurasian Hobby",                                                                  NA,              "yes",                        "Falco subbuteo",                                                            NA,
                                           "A347",                           "Eurasian Jackdaw",                                                                  NA,              "yes",                       "Corvus monedula",                                                            NA,
                                           "A342",                               "Eurasian Jay",                                                                  NA,              "yes",                   "Garrulus glandarius",                                                            NA,
                                           "A476",                            "Eurasian Linnet",                                                                  NA,              "yes",                     "Linaria cannabina",                                                            NA,
                                           "A224",                          "Eurasian Nightjar",                                                                  NA,              "yes",                 "Caprimulgus europaeus",                                                            NA,
                                           "A130",                     "Eurasian Oystercatcher",                                                                  NA,              "yes",                 "Haematopus ostralegus",                                                            NA,
                                           "A297",                      "Eurasian Reed-warbler",                                                                  NA,              "yes",               "Acrocephalus scirpaceus",                                                            NA,
                                           "A478",                            "Eurasian Siskin",                                                                  NA,              "yes",                         "Spinus spinus",                                                            NA,
                                           "A247",                           "Eurasian Skylark",                                                                  NA,              "yes",                       "Alauda arvensis",                                                            NA,
                                           "A898",                       "Eurasian Sparrowhawk",                                                                  NA,              "yes",            "Accipiter nisus all others",                                                            NA,
                                           "A034",                         "Eurasian Spoonbill",                                                                  NA,              "yes",                   "Platalea leucorodia",                                                            NA,
                                           "A133",                        "Eurasian Thick-knee",                                                                  NA,              "yes",                   "Burhinus oedicnemus",                                                            NA,
                                           "A356",                      "Eurasian Tree Sparrow",                                                                  NA,              "yes",                       "Passer montanus",                                                            NA,
                                           "A334",                       "Eurasian Treecreeper",                                                                  NA,              "yes",                    "Certhia familiaris",                                                            NA,
                                           "A855",                            "Eurasian Wigeon",                                                                  NA,              "yes",                       "Mareca penelope",                                                            NA,
                                           "A155",                          "Eurasian Woodcock",                                                                  NA,              "yes",                    "Scolopax rusticola",                                                            NA,
                                           "A233",                           "Eurasian Wryneck",                                                                  NA,              "yes",                        "Jynx torquilla",                                                            NA,
                                           "A364",                         "European Goldfinch",                                                                  NA,              "yes",                   "Carduelis carduelis",                                                            NA,
                                           "A363",                        "European Greenfinch",                                                                  NA,              "yes",                       "Chloris chloris",                                                            NA,
                                           "A072",                     "European Honey-buzzard",                                                                  NA,              "yes",                       "Pernis apivorus",                                                            NA,
                                           "A072",                     "European Honey-Buzzard",                                                                  NA,              "yes",                       "Pernis apivorus",                                                            NA,
                                           "A322",                   "European Pied Flycatcher",                                                                  NA,              "yes",                    "Ficedula hypoleuca",                                                            NA,
                                           "A269",                             "European Robin",                                                                  NA,              "yes",                    "Erithacus rubecula",                                                            NA,
                                           "A684",                              "European Shag",                                                                  NA,              "yes", "Phalacrocorax aristotelis aristotelis",                                                            NA,
                                           "A014",                      "European Storm Petrel",                                                                  NA,              "yes",                  "Hydrobates pelagicus",                                                            NA,
                                           "A014",                      "European Storm-petrel",                                                                  NA,              "yes",                  "Hydrobates pelagicus",                                                            NA,
                                           "A210",                       "European Turtle-dove",                                                                  NA,              "yes",                   "Streptopelia turtur",                                                            NA,
                                           "A394",               "European White-fronted Goose",                                                                  NA,              "yes",             "Anser albifrons albifrons",                                                            NA,
                                         "A748-X",                             "Eygptian Goose",                                                                  NA,              "yes",                  "Alopochen aegyptiaca",                                                            NA,
                                           "A434",                             "Fair Isle Wren",                                                                  NA,              "yes",  "Troglodytes troglodytes fridariensis",                                                            NA,
                                           "A284",                                  "Fieldfare",                                                                  NA,              "yes",                        "Turdus pilaris",                                                            NA,
                                           "A318",                                  "Firecrest",                                                                  NA,              "yes",                   "Regulus ignicapilla",                                                            NA,
                                           "A009",                                     "Fulmar",                                                                  NA,              "yes",                    "Fulmarus glacialis",                                                            NA,
                                           "A889",                                    "Gadwall",                                                                  NA,              "yes",                       "Mareca strepera",                                                            NA,
                                           "A310",                             "Garden Warbler",                                                                  NA,              "yes",                          "Sylvia borin",                                                            NA,
                                           "A856",                                   "Garganey",                                                                  NA,              "yes",                   "Spatula querquedula",                                                            NA,
                                           "A186",                              "Glaucous Gull",                                                                  NA,              "yes",                     "Larus hyperboreus",                                                            NA,
                                           "A317",                                  "Goldcrest",                                                                  NA,              "yes",                       "Regulus regulus",                                                            NA,
                                           "A091",                               "Golden Eagle",                                                                  NA,              "yes",                     "Aquila chrysaetos",                                                            NA,
                                           "A337",                              "Golden Oriole",                                                                  NA,              "yes",                       "Oriolus oriolus",                                                            NA,
                                         "A557-X",                            "Golden Pheasant",                                                                  NA,              "yes",                   "Chrysolophus pictus",                                                            NA,
                                           "A067",                                  "Goldeneye",                                                                  NA,              "yes",                    "Bucephala clangula",                                                            NA,
                                           "A021",                              "Great Bittern",                                                                  NA,              "yes",                    "Botaurus stellaris",                                                            NA,
                                           "A187",                    "Great Black-backed Gull",                                                                  NA,              "yes",                         "Larus marinus",                                                            NA,
                                           "A129",                              "Great Bustard",                                                                  NA,              "yes",                            "Otis tarda",                                                            NA,
                                           "A391",                            "Great Cormorant",                                      "Phalacrocorax carbo sinensis",               "no",          "Phalacrocorax carbo sinensis",                                                            NA,
                                           "A683",                            "Great Cormorant",                                         "Phalacrocorax carbo carbo",               "no",             "Phalacrocorax carbo carbo",                                                            NA,
                                           "A683",                      "Great Cormorant carbo",                                                                  NA,              "yes",             "Phalacrocorax carbo carbo",                                                            NA,
                                           "A391",                   "Great Cormorant sinensis",                                                                  NA,              "yes",          "Phalacrocorax carbo sinensis",                                                            NA,
                                           "A005",                        "Great Crested Grebe",                                                                  NA,              "yes",                    "Podiceps cristatus",                                                            NA,
                                           "A003",                       "Great Northern Diver",                                                                  NA,              "yes",                           "Gavia immer",                                                            NA,
                                           "A175",                                 "Great Skua",                                                                  NA,              "yes",                       "Catharacta skua",                                                            NA,
                                           "A658",                   "Great Spotted Woodpecker",                                                                  NA,              "yes",          "Dendrocopos major all others",                                                            NA,
                                           "A330",                                  "Great Tit",                                                                  NA,              "yes",                           "Parus major",                                                            NA,
                                           "A773",                          "Great White Egret",                                                                  NA,              "yes",                            "Ardea alba",                                                            NA,
                                           "A773",                          "Great White-Egret",                                                                  NA,              "yes",                            "Ardea alba",                                                            NA,
                                           "A062",                              "Greater Scaup",                                                                  NA,              "yes",                         "Aythya marila",                                                            NA,
                                           "A165",                            "Green Sandpiper",                                                                  NA,              "yes",                       "Tringa ochropus",                                                            NA,
                                         "A045-A",                   "Greenland Barnacle Goose",                                                                  NA,              "yes",                      "Branta leucopsis",                           "East Greenland/Scotland & Ireland",
                                           "A395",              "Greenland White-fronted Goose",                                                                  NA,              "yes",          "Anser albifrons flavirostris",                                                            NA,
                                           "A028",                                 "Grey Heron",                                                                  NA,              "yes",                         "Ardea cinerea",                                                            NA,
                                           "A644",                             "Grey Partridge",                                                                  NA,              "yes",              "Perdix perdix all others",                                                            NA,
                                           "A141",                                "Grey Plover",                                                                  NA,              "yes",                  "Pluvialis squatarola",                                                            NA,
                                           "A261",                               "Grey Wagtail",                                                                  NA,              "yes",                     "Motacilla cinerea",                                                            NA,
                                           "A043",                              "Greylag Goose",                                                                  NA,              "yes",                           "Anser anser",                                                            NA,
                                           "A043",                    "Greylag Goose (Britain)",                                                                  NA,              "yes",                           "Anser anser",                                                            NA,
                                           "A043",                    "Greylag Goose (Iceland)",                                                                  NA,              "yes",                           "Anser anser",                                                            NA,
                                           "A043",                     "Greylag Goose, Iceland",                                                                  NA,              "yes",                           "Anser anser",                                                            NA,
                                           "A043",                         "Greylag Goose (UK)",                                                                  NA,              "yes",                           "Anser anser",                                                            NA,
                                         "A847-X",                              "Harris's Hawk",                                                                  NA,              "yes",                  "Parabuteo unicinctus",                                                            NA,
                                           "A373",                                   "Hawfinch",                                                                  NA,              "yes",         "Coccothraustes coccothraustes",                                                            NA,
                                           "A266",                             "Hedge Accentor",                                                                  NA,              "yes",                    "Prunella modularis",                                                            NA,
                                         "A757-X",                        "Helmeted Guineafowl",                                                                  NA,              "yes",                      "Numida meleagris",                                                            NA,
                                           "A082",                                "Hen Harrier",                                                                  NA,              "yes",                        "Circus cyaneus",                                                            NA,
                                           "A895",                               "Herring Gull",                                                                  NA,              "yes",            "Larus argentatus argenteus",                                                            NA,
                                           "A349",                                "Hooded Crow",                                                                  NA,              "yes",                         "Corvus corone",                                          "[including cornix]",
                                           "A007",                               "Horned Grebe",                                                                  NA,              "yes",                      "Podiceps auritus",                                                            NA,
                                           "A620",                              "House Sparrow",                                                                  NA,              "yes",             "Passer domesticus s. str.",                           "sensu stricto [excluding italiae]",
                                           "A185",                               "Iceland Gull",                                                                  NA,              "yes",                      "Larus glaucoides",                                                            NA,
                                         "A756-X",                             "Indian Peafowl",                                                                  NA,              "yes",                        "Pavo cristatus",                                                            NA,
                                           "A152",                                 "Jack Snipe",                                                                  NA,              "yes",                  "Lymnocryptes minimus",                                                            NA,
                                         "A755-X",                    "Lady Amherst's Pheasant",                                                                  NA,              "yes",               "Chrysolophus amherstiae",                                                            NA,
                                           "A374",                           "Lapland Longspur",                                                                  NA,              "yes",                  "Calcarius lapponicus",                                                            NA,
                                           "A854",                       "Leach's Storm Petrel",                                                                  NA,              "yes",                 "Hydrobates leucorhous",                                                            NA,
                                           "A854",                       "Leach's Storm-petrel",                                                                  NA,              "yes",                 "Hydrobates leucorhous",                                                            NA,
                                           "A489",                   "Lesser Black-backed Gull",                                                                  NA,              "yes",               "Larus fuscus all others",                                                            NA,
                                               NA,                             "Lesser Redpoll",                                                                  NA,               "no",                                      NA,                                                            NA,
                                           "A869",                  "Lesser Spotted Woodpecker",                                                                  NA,              "yes",                       "Dryobates minor",                                                            NA,
                                           "A574",                         "Lesser Whitethroat",                                                                  NA,              "yes",                        "Sylvia curruca",                                          "[including minula]",
                                           "A203",                                 "Little Auk",                                                                  NA,              "yes",                             "Alle alle",                                                            NA,
                                           "A022",                             "Little Bittern",                                                                  NA,              "yes",                    "Ixobrychus minutus",                                                            NA,
                                           "A026",                               "Little Egret",                                                                  NA,              "yes",                      "Egretta garzetta",                                                            NA,
                                           "A004",                               "Little Grebe",                                                                  NA,              "yes",                "Tachybaptus ruficollis",                                                            NA,
                                           "A862",                                "Little Gull",                                                                  NA,              "yes",                  "Hydrocoloeus minutus",                                                            NA,
                                         "A218-X",                                 "Little Owl",                                                                  NA,              "yes",                         "Athene noctua",                                      "non-native populations",
                                           "A136",                       "Little Ringed Plover",                                                                  NA,              "yes",                     "Charadrius dubius",                                                            NA,
                                           "A885",                                "Little Tern",                                                                  NA,              "yes",                    "Sternula albifrons",                                                            NA,
                                           "A221",                             "Long-eared Owl",                                                                  NA,              "yes",                             "Asio otus",                                                            NA,
                                           "A064",                           "Long-tailed Duck",                                                                  NA,              "yes",                     "Clangula hyemalis",                                                            NA,
                                           "A324",                            "Long-tailed Tit",                                                                  NA,              "yes",                   "Aegithalos caudatus",                                                            NA,
                                           "A053",                                    "Mallard",                                                                  NA,              "yes",                    "Anas platyrhynchos",                                                            NA,
                                         "A553-X",                              "Mandarin Duck",                                                                  NA,              "yes",                      "Aix galericulata",                                                            NA,
                                           "A013",                            "Manx Shearwater",                                                                  NA,              "yes",                     "Puffinus puffinus",                                                            NA,
                                           "A493",                                  "Marsh Tit",                                                                  NA,              "yes",                     "Poecile palustris",                                                            NA,
                                           "A296",                              "Marsh Warbler",                                                                  NA,              "yes",                "Acrocephalus palustris",                                                            NA,
                                           "A257",                               "Meadow Pipit",                                                                  NA,              "yes",                      "Anthus pratensis",                                                            NA,
                                           "A176",                         "Mediterranean Gull",                                                                  NA,              "yes",                  "Larus melanocephalus",                                                            NA,
                                           "A098",                                     "Merlin",                                                                  NA,              "yes",                     "Falco columbarius",                                                            NA,
                                           "A182",                                   "Mew Gull",                                                                  NA,              "yes",                           "Larus canus",                                                            NA,
                                           "A287",                              "Mistle Thrush",                                                                  NA,              "yes",                     "Turdus viscivorus",                                                            NA,
                                         "A761-X",                              "Monk Parakeet",                                                                  NA,              "yes",                   "Myiopsitta monachus",                                                            NA,
                                           "A084",                          "Montagu's Harrier",                                                                  NA,              "yes",                       "Circus pygargus",                                                            NA,
                                         "A751-X",                               "Muscovy Duck",                                                                  NA,              "yes",                      "Cairina moschata",                                                            NA,
                                           "A036",                                  "Mute Swan",                                                                  NA,              "yes",                           "Cygnus olor",                                                            NA,
                                           "A016",                            "Northern Gannet",                                                                  NA,              "yes",                        "Morus bassanus",                                                            NA,
                                           "A899",                           "Northern Goshawk",                                                                  NA,              "yes",         "Accipiter gentilis all others",                                                            NA,
                                           "A738",                      "Northern House-martin",                                                                  NA,              "yes",                      "Delichon urbicum",                                                            NA,
                                           "A142",                           "Northern Lapwing",                                                                  NA,              "yes",                     "Vanellus vanellus",                                                            NA,
                                           "A054",                           "Northern Pintail",                                                                  NA,              "yes",                            "Anas acuta",                                                            NA,
                                           "A857",                          "Northern Shoveler",                                                                  NA,              "yes",                      "Spatula clypeata",                                                            NA,
                                           "A277",                          "Northern Wheatear",                                                                  NA,              "yes",                     "Oenanthe oenanthe",                                        "[excluding seebohmi]",
                                           "A094",                                     "Osprey",                                                                  NA,              "yes",                     "Pandion haliaetus",                                                            NA,
                                           "A173",                           "Parasitic Jaeger",                                                                  NA,              "yes",              "Stercorarius parasiticus",                                                            NA,
                                           "A370",                           "Parrot Crossbill",                                                                  NA,              "yes",                  "Loxia pytyopsittacus",                                                            NA,
                                           "A103",                                  "Peregrine",                                                                  NA,              "yes",                      "Falco peregrinus",                                   "[including pelegrinoides]",
                                           "A103",                           "Peregrine Falcon",                                                                  NA,              "yes",                      "Falco peregrinus",                                   "[including pelegrinoides]",
                                           "A132",                                "Pied Avocet",                                                                  NA,              "yes",                "Recurvirostra avosetta",                                                            NA,
                                           "A322",                            "Pied Flycatcher",                                                                  NA,              "yes",                    "Ficedula hypoleuca",                                                            NA,
                                         "A040-B",                          "Pink-footed Goose",                                                                  NA,              "yes",                  "Anser brachyrhynchus",                                 "East Greenland & Iceland/UK",
                                           "A054",                                    "Pintail",                                                                  NA,              "yes",                            "Anas acuta",                                                            NA,
                                           "A148",                           "Purple Sandpiper",                                                                  NA,              "yes",                     "Calidris maritima",                                                            NA,
                                           "A200",                                  "Razorbill",                                                                  NA,              "yes",                            "Alca torda",                                                            NA,
                                           "A369",                              "Red Crossbill",                                                                  NA,              "yes",                     "Loxia curvirostra",                                                            NA,
                                           "A074",                                   "Red Kite",                                                                  NA,              "yes",                         "Milvus milvus",                                                            NA,
                                           "A143",                                   "Red Knot",                                                                  NA,              "yes",                      "Calidris canutus",                                                            NA,
                                           "A338",                          "Red-backed Shrike",                                                                  NA,              "yes",                       "Lanius collurio",                                                            NA,
                                           "A346",                          "Red-billed Chough",                                                                  NA,              "yes",               "Pyrrhocorax pyrrhocorax",                                                            NA,
                                           "A069",                     "Red-breasted Merganser",                                                                  NA,              "yes",                       "Mergus serrator",                                                            NA,
                                         "A058-X",                        "Red-crested Pochard",                                                                  NA,              "yes",                          "Netta rufina",                                      "non-native populations",
                                         "A110-X",                       "Red-legged Partridge",                                                                  NA,              "yes",                        "Alectoris rufa",                                      "non-native populations",
                                           "A006",                           "Red-necked Grebe",                                                                  NA,              "yes",                    "Podiceps grisegena",                                                            NA,
                                           "A170",                       "Red-necked Phalarope",                                                                  NA,              "yes",                    "Phalaropus lobatus",                                                            NA,
                                         "A846-X",                            "Red-tailed Hawk",                                                                  NA,              "yes",                     "Buteo jamaicensis",                                                            NA,
                                           "A001",                         "Red-throated Diver",                                                                  NA,              "yes",                        "Gavia stellata",                                                            NA,
                                           "A286",                                    "Redwing",                                                                  NA,              "yes",                        "Turdus iliacus",                                                            NA,
                                           "A381",                               "Reed Bunting",                                                                  NA,              "yes",                  "Emberiza schoeniclus",                                                            NA,
                                         "A558-X",                          "Reeves's Pheasant",                                                                  NA,              "yes",                   "Syrmaticus reevesii",                                                            NA,
                                           "A282",                                 "Ring Ouzel",                                                                  NA,              "yes",                      "Turdus torquatus",                                                            NA,
                                           "A206",                                  "Rock Dove",                                                                  NA,              "yes",                         "Columba livia",                                            "wild populations",
                                           "A206",                                "Rock Pigeon",                                                  "wild populations",               "no",                         "Columba livia",                                            "wild populations",
                                         "A206-X",                                "Rock Pigeon",                                                 "feral populations",               "no",                         "Columba livia",                                           "feral populations",
                                           "A666",                                 "Rock Pipit",                                                                  NA,              "yes",                       "Anthus petrosus",                                                            NA,
                                           "A891",                             "Rock Ptarmigan",                                                                  NA,              "yes",               "Lagopus muta all others",                                                            NA,
                                           "A348",                                       "Rook",                                                                  NA,              "yes",                     "Corvus frugilegus",                                                            NA,
                                           "A192",                               "Roseate Tern",                                                                  NA,              "yes",                      "Sterna dougallii",                                                            NA,
                                         "A760-X",                       "Rose-ringed Parakeet",                                                                  NA,              "yes",                    "Psittacula krameri",                                                            NA,
                                         "A848-X",                        "Rosy-faced Lovebird",                                                                  NA,              "yes",                 "Agapornis roseicollis",                                                            NA,
                                         "A750-X",                                 "Ruddy Duck",                                                                  NA,              "yes",                    "Oxyura jamaicensis",                                                            NA,
                                         "A397-X",                             "Ruddy Shelduck",                                                                  NA,              "yes",                    "Tadorna ferruginea",                                      "non-native populations",
                                           "A169",                            "Ruddy Turnstone",                                                                  NA,              "yes",                    "Arenaria interpres",                                                            NA,
                                           "A861",                                       "Ruff",                                                                  NA,              "yes",                       "Calidris pugnax",                                                            NA,
                                           "A249",                                "Sand Martin",                                                                  NA,              "yes",                       "Riparia riparia",                                                            NA,
                                           "A144",                                 "Sanderling",                                                                  NA,              "yes",                         "Calidris alba",                                                            NA,
                                           "A863",                              "Sandwich Tern",                                                                  NA,              "yes",               "Thalasseus sandvicensis",                                                            NA,
                                           "A292",                             "Savi's Warbler",                                                                  NA,              "yes",               "Locustella luscinioides",                                                            NA,
                                           "A451",                         "Scottish Crossbill",                                                                  NA,              "yes",                         "Loxia scotica",                                                            NA,
                                           "A295",                              "Sedge Warbler",                                                                  NA,              "yes",            "Acrocephalus schoenobaenus",                                                            NA,
                                           "A048",                                   "Shelduck",                                                                  NA,              "yes",                       "Tadorna tadorna",                                                            NA,
                                           "A222",                            "Short-eared Owl",                                                                  NA,              "yes",                         "Asio flammeus",                                                            NA,
                                           "A767",                                       "Smew",                                                                  NA,              "yes",                    "Mergellus albellus",                                                            NA,
                                           "A375",                               "Snow Bunting",                                                                  NA,              "yes",                 "Plectrophenax nivalis",                                                            NA,
                                         "A556-X",                                 "Snow Goose",                                                                  NA,              "yes",                    "Anser caerulescens",                                                            NA,
                                           "A285",                                "Song Thrush",                                                                  NA,              "yes",                     "Turdus philomelos",                                                            NA,
                                           "A119",                              "Spotted Crake",                                                                  NA,              "yes",                       "Porzana porzana",                                                            NA,
                                           "A319",                         "Spotted Flycatcher",                                                                  NA,              "yes",                     "Muscicapa striata",                                                            NA,
                                           "A161",                           "Spotted Redshank",                                                                  NA,              "yes",                     "Tringa erythropus",                                                            NA,
                                           "A207",                                 "Stock Dove",                                                                  NA,              "yes",                         "Columba oenas",                                                            NA,
                                               NA,                                "Surf Scoter",                                                                  NA,               "no",                                      NA,                                                            NA,
                                         "A045-B",                    "Svalbard Barnacle Goose",                                                                  NA,              "yes",                      "Branta leucopsis",                                "Svalbard/South-west Scotland",
                                         "A674-B",         "Svalbard Light-bellied Brent Geese",                                                                  NA,              "yes",                 "Branta bernicla hrota",                                       "Svalbard/Denmark & UK",
                                           "A219",                                  "Tawny Owl",                                                                  NA,              "yes",                           "Strix aluco",                                                            NA,
                                           "A146",                           "Temminck's Stint",                                                                  NA,              "yes",                   "Calidris temminckii",                                                            NA,
                                           "A256",                                 "Tree Pipit",                                                                  NA,              "yes",                      "Anthus trivialis",                                                            NA,
                                           "A061",                                "Tufted Duck",                                                                  NA,              "yes",                       "Aythya fuligula",                                                            NA,
                                           "A037",                                "Tundra Swan",                                                                  NA,              "yes",           "Cygnus columbianus bewickii",                                                            NA,
                                           "A477",                                      "Twite",                                                                  NA,              "yes",                  "Linaria flavirostris",                                                            NA,
                                           "A066",                              "Velvet Scoter",                                                                  NA,              "yes",                       "Melanitta fusca",                                                            NA,
                                           "A118",                                 "Water Rail",                                                                  NA,              "yes",                      "Rallus aquaticus",                                                            NA,
                                           "A659",                       "Western Capercaillie",                                                                  NA,              "yes",           "Tetrao urogallus all others",                                                            NA,
                                           "A081",                     "Western Marsh -harrier",                                                                  NA,              "yes",                    "Circus aeruginosus",                                                            NA,
                                           "A081",                      "Western Marsh-harrier",                                                                  NA,              "yes",                    "Circus aeruginosus",                                                            NA,
                                           "A158",                                   "Whimbrel",                                                                  NA,              "yes",                     "Numenius phaeopus",                                                            NA,
                                           "A275",                                   "Whinchat",                                                                  NA,              "yes",                      "Saxicola rubetra",                                                            NA,
                                           "A275",                       "White (Pied) Wagtail",                                                                  NA,              "yes",                      "Saxicola rubetra",                                                            NA,
                                           "A262",                              "White Wagtail",                                                                  NA,              "yes",                        "Motacilla alba",                                                            NA,
                                           "A502",                         "White-billed Diver",                                                                  NA,              "yes",                         "Gavia adamsii",                                                            NA,
                                           "A075",                         "White-tailed Eagle",                                                                  NA,              "yes",                  "Haliaeetus albicilla",                                                            NA,
                                           "A264",                      "White-throated Dipper",                                                                  NA,              "yes",                       "Cinclus cinclus",                                                            NA,
                                           "A038",                               "Whooper Swan",                                                                  NA,              "yes",                         "Cygnus cygnus",                                                            NA,
                                           "A855",                                     "Wigeon",                                                                  NA,              "yes",                       "Mareca penelope",                                                            NA,
                                         "A460-X",                                "Wild Turkey",                                                                  NA,              "yes",                   "Meleagris gallopavo",                                                            NA,
                                           "A463",                           "Willow Ptarmigan",                                         "Lagopus lagopus hibernica",               "no",             "Lagopus lagopus hibernica",                                                            NA,
                                           "A711",                           "Willow Ptarmigan",                                           "Lagopus lagopus scotica",               "no",               "Lagopus lagopus scotica",                                                            NA,
                                           "A463", "Willow Ptarmigan (Red Grouse) (hibernicus)",                                                                  NA,              "yes",             "Lagopus lagopus hibernica",                                                            NA,
                                           "A711",    "Willow Ptarmigan (Red Grouse) (scotica)",                                                                  NA,              "yes",               "Lagopus lagopus scotica",                                                            NA,
                                           "A711",   "Willow Ptarmigan (Red Grouse) (scoticus)",                                                                  NA,              "yes",               "Lagopus lagopus scotica",                                                            NA,
                                           "A492",                                 "Willow Tit",                                                                  NA,              "yes",                      "Poecile montanus",                                                            NA,
                                           "A316",                             "Willow Warbler",                                                                  NA,              "yes",                "Phylloscopus trochilus",                                                            NA,
                                           "A434",                                "Winter Wren",                              "Troglodytes troglodytes fridariensis",               "no",  "Troglodytes troglodytes fridariensis",                                                            NA,
                                           "A676",                                "Winter Wren",                                "Troglodytes troglodytes all others",               "no",    "Troglodytes troglodytes all others",                                                            NA,
                                         "A749-X",                                  "Wood Duck",                                                                  NA,              "yes",                            "Aix sponsa",                                                            NA,
                                           "A246",                                  "Wood Lark",                                                                  NA,              "yes",                       "Lullula arborea",                                                            NA,
                                           "A246",                                  "Wood lark",                                                                  NA,              "yes",                       "Lullula arborea",                                                            NA,
                                           "A332",                              "Wood Nuthatch",                                                                  NA,              "yes",                        "Sitta europaea",                                                            NA,
                                           "A166",                             "Wood Sandpiper",                                                                  NA,              "yes",                       "Tringa glareola",                                                            NA,
                                           "A314",                               "Wood Warbler",                                                                  NA,              "yes",               "Phylloscopus sibilatrix",                                                            NA,
                                           "A260",                             "Yellow Wagtail",                                                                  NA,              "yes",                       "Motacilla flava",                                  "[excluding tschutschensis]",
                                           "A376",                               "Yellowhammer",                                                                  NA,              "yes",                   "Emberiza citrinella",                                                            NA
                                     )

# information_scientific_name_look_up
information_scientific_name_look_up <- tibble::tribble(
                                         ~speciescode,                        ~scientific_name,                                                     ~sub_unit, ~scientific_name_match,                    ~common_name,
                                               "A474",                      "Acanthis flammea",                            "[including cabaret and exilipes]",                  "yes",                "Common Redpoll",
                                               "A899",                    "Accipiter gentilis",                                                            NA,                  "yes",              "Northern Goshawk",
                                               "A899",         "Accipiter gentilis all others",                                                            NA,                  "yes",              "Northern Goshawk",
                                               "A898",                       "Accipiter nisus",                                                            NA,                  "yes",          "Eurasian Sparrowhawk",
                                               "A898",            "Accipiter nisus all others",                                                            NA,                  "yes",          "Eurasian Sparrowhawk",
                                               "A294",               "Acrocephalus paludicola",                                                            NA,                  "yes",               "Aquatic Warbler",
                                               "A296",                "Acrocephalus palustris",                                                            NA,                  "yes",                 "Marsh Warbler",
                                               "A295",            "Acrocephalus schoenobaenus",                                                            NA,                  "yes",                 "Sedge Warbler",
                                               "A297",               "Acrocephalus scirpaceus",                                                            NA,                  "yes",         "Eurasian Reed-warbler",
                                               "A168",                    "Actitis hypoleucos",                                                            NA,                  "yes",              "Common Sandpiper",
                                               "A324",                   "Aegithalos caudatus",                                                            NA,                  "yes",               "Long-tailed Tit",
                                             "A848-X",                 "Agapornis roseicollis",                                                            NA,                  "yes",           "Rosy-faced Lovebird",
                                             "A553-X",                      "Aix galericulata",                                                            NA,                  "yes",                 "Mandarin Duck",
                                             "A749-X",                            "Aix sponsa",                                                            NA,                  "yes",                     "Wood Duck",
                                               "A247",                       "Alauda arvensis",                                                            NA,                  "yes",              "Eurasian Skylark",
                                               "A200",                            "Alca torda",                                                            NA,                  "yes",                     "Razorbill",
                                               "A229",                         "Alcedo atthis",                                                            NA,                  "yes",             "Common Kingfisher",
                                             "A110-X",                        "Alectoris rufa",                                      "non-native populations",                  "yes",          "Red-legged Partridge",
                                               "A203",                             "Alle alle",                                                            NA,                  "yes",                    "Little Auk",
                                             "A748-X",                  "Alopochen aegyptiaca",                                                            NA,                  "yes",                "Egyptian Goose",
                                               "A054",                            "Anas acuta",                                                            NA,                  "yes",              "Northern Pintail",
                                               "A857",                         "Anas clypeata",                                                            NA,                  "yes",             "Northern Shoveler",
                                               "A052",                           "Anas crecca",                                                            NA,                  "yes",                   "Common Teal",
                                               "A855",                         "Anas penelope",                                                            NA,                  "yes",               "Eurasian Wigeon",
                                               "A053",                    "Anas platyrhynchos",                                                            NA,                  "yes",                       "Mallard",
                                               "A856",                      "Anas querquedula",                                                            NA,                  "yes",                      "Garganey",
                                               "A889",                         "Anas strepera",                                                            NA,                  "yes",                       "Gadwall",
                                               "A394",             "Anser albifrons albifrons",                                                            NA,                  "yes",  "European White-fronted Goose",
                                               "A395",          "Anser albifrons flavirostris",                                                            NA,                  "yes", "Greenland White-fronted Goose",
                                               "A043",                           "Anser anser",                                                            NA,                  "yes",                 "Greylag Goose",
                                             "A040-B",                  "Anser brachyrhynchus",                                 "East Greenland & Iceland/UK",                  "yes",             "Pink-footed Goose",
                                             "A556-X",                    "Anser caerulescens",                                                            NA,                  "yes",                    "Snow Goose",
                                             "A844-X",                       "Anser canagicus",                                                            NA,                  "yes",                 "Emperor Goose",
                                               "A701",                 "Anser fabalis fabalis",                                                            NA,                  "yes",                    "Bean Goose",
                                               "A702",                "Anser fabalis rossicus",                                                            NA,                  "yes",                    "Bean Goose",
                                             "A845-X",                         "Anser indicus",                                                            NA,                  "yes",              "Bar-headed Goose",
                                               "A666",                       "Anthus petrosus",                                                            NA,                  "yes",                    "Rock Pipit",
                                               "A257",                      "Anthus pratensis",                                                            NA,                  "yes",                  "Meadow Pipit",
                                               "A256",                      "Anthus trivialis",                                                            NA,                  "yes",                    "Tree Pipit",
                                               "A226",                             "Apus apus",                                                            NA,                  "yes",                  "Common Swift",
                                               "A091",                     "Aquila chrysaetos",                                                            NA,                  "yes",                  "Golden Eagle",
                                               "A773",                            "Ardea alba",                                                            NA,                  "yes",             "Great White Egret",
                                               "A028",                         "Ardea cinerea",                                                            NA,                  "yes",                    "Grey Heron",
                                               "A169",                    "Arenaria interpres",                                                            NA,                  "yes",               "Ruddy Turnstone",
                                               "A222",                         "Asio flammeus",                                                            NA,                  "yes",               "Short-eared Owl",
                                               "A221",                             "Asio otus",                                                            NA,                  "yes",                "Long-eared Owl",
                                             "A218-X",                         "Athene noctua",                                      "non-native populations",                  "yes",                    "Little Owl",
                                               "A059",                         "Aythya ferina",                                                            NA,                  "yes",                "Common Pochard",
                                               "A061",                       "Aythya fuligula",                                                            NA,                  "yes",                   "Tufted Duck",
                                               "A062",                         "Aythya marila",                                                            NA,                  "yes",                 "Greater Scaup",
                                               "A021",                    "Botaurus stellaris",                                                            NA,                  "yes",                 "Great Bittern",
                                               "A675",              "Branta bernicla bernicla",                                                            NA,                  "yes",                   "Brent Goose",
                                             "A674-A",                 "Branta bernicla hrota",                                  "Canada & Greenland/Ireland",                   "no",                   "Brent Goose",
                                             "A674-B",                 "Branta bernicla hrota",                                       "Svalbard/Denmark & UK",                   "no",                   "Brent Goose",
                                             "A044-X",                     "Branta canadensis",                                                            NA,                  "yes",                  "Canada Goose",
                                             "A045-X",                      "Branta leucopsis",                                      "non-native populations",                   "no",                "Barnacle Goose",
                                             "A045-A",                      "Branta leucopsis",                           "East Greenland/Scotland & Ireland",                   "no",                "Barnacle Goose",
                                             "A045-B",                      "Branta leucopsis",                                "Svalbard/South-west Scotland",                   "no",                "Barnacle Goose",
                                             "A215-X",                             "Bubo bubo",                                      "non-native populations",                  "yes",                     "Eagle Owl",
                                               "A025",                         "Bubulcus ibis",                                                            NA,                  "yes",                  "Cattle Egret",
                                               "A067",                    "Bucephala clangula",                                                            NA,                  "yes",              "Common Goldeneye",
                                               "A133",                   "Burhinus oedicnemus",                                                            NA,                  "yes",           "Eurasian Thick-knee",
                                               "A087",                           "Buteo buteo",                                                            NA,                  "yes",                "Common Buzzard",
                                             "A846-X",                     "Buteo jamaicensis",                                                            NA,                  "yes",               "Red-tailed Hawk",
                                             "A751-X",                      "Cairina moschata",                                                            NA,                  "yes",                  "Muscovy Duck",
                                               "A374",                  "Calcarius lapponicus",                                                            NA,                  "yes",              "Lapland Longspur",
                                               "A144",                         "Calidris alba",                                                            NA,                  "yes",                    "Sanderling",
                                               "A149",                       "Calidris alpina",                                "all non-breeding populations",                  "yes",                        "Dunlin",
                                             "A466-A",              "Calidris alpina schinzii",                     "Britain & Ireland/SW Europe & NW Africa",                  "yes",                        "Dunlin",
                                               "A143",                      "Calidris canutus",                                                            NA,                  "yes",                      "Red Knot",
                                               "A148",                     "Calidris maritima",                                                            NA,                  "yes",              "Purple Sandpiper",
                                               "A861",                       "Calidris pugnax",                                                            NA,                  "yes",                          "Ruff",
                                               "A146",                   "Calidris temminckii",                                                            NA,                  "yes",              "Temminck's Stint",
                                               "A224",                 "Caprimulgus europaeus",                                                            NA,                  "yes",             "Eurasian Nightjar",
                                                   NA,                     "Carduelis cabaret",                                                            NA,                   "no",                "Lesser Redpoll",
                                               "A476",                   "Carduelis cannabina",                                                            NA,                  "yes",               "Eurasian Linnet",
                                               "A364",                   "Carduelis carduelis",                                                            NA,                  "yes",            "European Goldfinch",
                                               "A474",                     "Carduelis flammea",                            "[including cabaret and exilipes]",                  "yes",                "Common Redpoll",
                                               "A477",                "Carduelis flavirostris",                                                            NA,                  "yes",                         "Twite",
                                               "A478",                      "Carduelis spinus",                                                            NA,                  "yes",               "Eurasian Siskin",
                                               "A175",                       "Catharacta skua",                                                            NA,                  "yes",                    "Great Skua",
                                               "A202",                        "Cepphus grylle",                                                            NA,                  "yes",               "Black Guillemot",
                                               "A334",                    "Certhia familiaris",                                                            NA,                  "yes",          "Eurasian Treecreeper",
                                               "A288",                          "Cettia cetti",                                                            NA,                  "yes",               "Cetti's Warbler",
                                               "A136",                     "Charadrius dubius",                                                            NA,                  "yes",          "Little Ringed Plover",
                                               "A137",                  "Charadrius hiaticula",                                                            NA,                  "yes",          "Common Ringed Plover",
                                               "A727",                 "Charadrius morinellus",                                                            NA,                  "yes",             "Eurasian Dotterel",
                                             "A844-X",                         "Chen canagica",                                                            NA,                  "yes",                 "Emperor Goose",
                                               "A363",                       "Chloris chloris",                                                            NA,                  "yes",           "European Greenfinch",
                                               "A179",            "Chroicocephalus ridibundus",                                                            NA,                  "yes",             "Black-headed Gull",
                                             "A755-X",               "Chrysolophus amherstiae",                                                            NA,                  "yes",       "Lady Amherst's Pheasant",
                                             "A557-X",                   "Chrysolophus pictus",                                                            NA,                  "yes",               "Golden Pheasant",
                                               "A264",                       "Cinclus cinclus",                                                            NA,                  "yes",         "White-throated Dipper",
                                               "A081",                    "Circus aeruginosus",                                                            NA,                  "yes",        "Western Marsh -harrier",
                                               "A082",                        "Circus cyaneus",                                                            NA,                  "yes",                   "Hen Harrier",
                                               "A084",                       "Circus pygargus",                                                            NA,                  "yes",             "Montagu's Harrier",
                                               "A064",                     "Clangula hyemalis",                                                            NA,                  "yes",              "Long-tailed Duck",
                                               "A373",         "Coccothraustes coccothraustes",                                                            NA,                  "yes",                      "Hawfinch",
                                             "A206-X",                         "Columba livia",                                           "feral populations",                   "no",                   "Rock Pigeon",
                                               "A206",                         "Columba livia",                                            "wild populations",                   "no",                     "Rock Dove",
                                               "A207",                         "Columba oenas",                                                            NA,                  "yes",                    "Stock Dove",
                                               "A687",                      "Columba palumbus",                                                            NA,                  "yes",            "Common Wood-pigeon",
                                               "A687",             "Columba palumbus palumbus",                                                            NA,                  "yes",            "Common Wood-pigeon",
                                               "A350",                          "Corvus corax",                                                            NA,                  "yes",                  "Common Raven",
                                               "A349",                         "Corvus cornix",                                          "[including cornix]",                  "yes",                  "Carrion Crow",
                                               "A349",                         "Corvus corone",                                          "[including cornix]",                  "yes",                  "Carrion Crow",
                                               "A348",                     "Corvus frugilegus",                                                            NA,                  "yes",                          "Rook",
                                               "A347",                       "Corvus monedula",                                                            NA,                  "yes",              "Eurasian Jackdaw",
                                               "A113",                     "Coturnix coturnix",                                                            NA,                  "yes",                  "Common Quail",
                                               "A122",                             "Crex crex",                                                            NA,                  "yes",                     "Corncrake",
                                               "A212",                       "Cuculus canorus",                                                            NA,                  "yes",                 "Common Cuckoo",
                                               "A483",                   "Cyanistes caeruleus",                        "sensu stricto [excluding teneriffae]",                  "yes",                      "Blue Tit",
                                               "A483",           "Cyanistes caeruleus s. str.",                        "sensu stricto [excluding teneriffae]",                  "yes",                      "Blue Tit",
                                             "A747-X",                        "Cygnus atratus",                                                            NA,                  "yes",                    "Black Swan",
                                               "A037",           "Cygnus columbianus bewickii",                                                            NA,                  "yes",                 "Bewick's Swan",
                                               "A038",                         "Cygnus cygnus",                                                            NA,                  "yes",                  "Whooper Swan",
                                               "A036",                           "Cygnus olor",                                                            NA,                  "yes",                     "Mute Swan",
                                               "A869",                      "Dedrocopos minor",                                                            NA,                  "yes",     "Lesser Spotted Woodpecker",
                                               "A738",                      "Delichon urbicum",                                                            NA,                  "yes",         "Northern House-martin",
                                               "A658",                     "Dendrocopos major",                                                            NA,                  "yes",      "Great Spotted Woodpecker",
                                               "A658",          "Dendrocopos major all others",                                                            NA,                  "yes",      "Great Spotted Woodpecker",
                                               "A869",                       "Dryobates minor",                                                            NA,                  "yes",     "Lesser Spotted Woodpecker",
                                               "A026",                      "Egretta garzetta",                                                            NA,                  "yes",                  "Little Egret",
                                               "A383",                     "Emberiza calandra",                                                            NA,                  "yes",                  "Corn Bunting",
                                               "A377",                       "Emberiza cirlus",                                                            NA,                  "yes",                  "Cirl Bunting",
                                               "A376",                   "Emberiza citrinella",                                                            NA,                  "yes",                  "Yellowhammer",
                                               "A381",                  "Emberiza schoeniclus",                                                            NA,                  "yes",                  "Reed Bunting",
                                               "A269",                    "Erithacus rubecula",                                                            NA,                  "yes",                "European Robin",
                                               "A727",                  "Eudromias morinellus",                                                            NA,                  "yes",             "Eurasian Dotterel",
                                               "A098",                     "Falco columbarius",                                                            NA,                  "yes",                        "Merlin",
                                               "A103",                      "Falco peregrinus",                                   "[including pelegrinoides]",                  "yes",                     "Peregrine",
                                               "A099",                        "Falco subbuteo",                                                            NA,                  "yes",                "Eurasian Hobby",
                                               "A096",                     "Falco tinnunculus",                                                            NA,                  "yes",                "Common Kestrel",
                                               "A322",                    "Ficedula hypoleuca",                                                            NA,                  "yes",      "European Pied Flycatcher",
                                               "A204",                    "Fratercula arctica",                                                            NA,                  "yes",               "Atlantic Puffin",
                                               "A657",                     "Fringilla coelebs",                                                            NA,                  "yes",            "Eurasian Chaffinch",
                                               "A657",          "Fringilla coelebs all others",                                                            NA,                  "yes",            "Eurasian Chaffinch",
                                               "A360",              "Fringilla montifringilla",                                                            NA,                  "yes",                     "Brambling",
                                               "A125",                           "Fulica atra",                                                            NA,                  "yes",                   "Common Coot",
                                               "A009",                    "Fulmarus glacialis",                                                            NA,                  "yes",                        "Fulmar",
                                               "A153",                   "Gallinago gallinago",                                                            NA,                  "yes",                  "Common Snipe",
                                               "A123",                   "Gallinula chloropus",                                                            NA,                  "yes",                "Common Moorhen",
                                               "A342",                   "Garrulus glandarius",                                                            NA,                  "yes",                  "Eurasian Jay",
                                               "A502",                         "Gavia adamsii",                                                            NA,                  "yes",            "White-billed Diver",
                                               "A002",                         "Gavia arctica",                                                            NA,                  "yes",          "Black-throated Diver",
                                               "A003",                           "Gavia immer",                                                            NA,                  "yes",          "Great Northern Diver",
                                               "A001",                        "Gavia stellata",                                                            NA,                  "yes",            "Red-throated Diver",
                                               "A127",                             "Grus grus",                                                            NA,                  "yes",                  "Common Crane",
                                               "A130",                 "Haematopus ostralegus",                                                            NA,                  "yes",        "Eurasian Oystercatcher",
                                               "A075",                  "Haliaeetus albicilla",                                                            NA,                  "yes",            "White-tailed Eagle",
                                               "A131",                 "Himantopus himantopus",                                                            NA,                  "yes",            "Black-winged Stilt",
                                               "A251",                       "Hirundo rustica",                                                            NA,                  "yes",                  "Barn Swallow",
                                               "A854",                 "Hydrobates leucorhous",                                                            NA,                  "yes",          "Leach's Storm Petrel",
                                               "A014",                  "Hydrobates pelagicus",                                                            NA,                  "yes",         "European Storm Petrel",
                                               "A862",                  "Hydrocoloeus minutus",                                                            NA,                  "yes",                   "Little Gull",
                                               "A233",                        "Jynx torquilla",                                                            NA,                  "yes",              "Eurasian Wryneck",
                                                   NA,                       "Lagopus lagopus",                                                            NA,                   "no",              "Willow Ptarmigan",
                                               "A463",             "Lagopus lagopus hibernica",                                                            NA,                  "yes",              "Willow Ptarmigan",
                                               "A711",               "Lagopus lagopus scotica",                                                            NA,                  "yes",              "Willow Ptarmigan",
                                               "A891",                          "Lagopus muta",                                                            NA,                  "yes",                "Rock Ptarmigan",
                                               "A891",               "Lagopus muta all others",                                                            NA,                  "yes",                "Rock Ptarmigan",
                                               "A338",                       "Lanius collurio",                                                            NA,                  "yes",             "Red-backed Shrike",
                                               "A895",                      "Larus argentatus",                                                            NA,                  "yes",                  "Herring Gull",
                                               "A895",            "Larus argentatus argenteus",                                                            NA,                  "yes",                  "Herring Gull",
                                               "A182",                           "Larus canus",                                                            NA,                  "yes",                   "Common Gull",
                                               "A489",                          "Larus fuscus",                                                            NA,                  "yes",      "Lesser Black-backed Gull",
                                               "A489",               "Larus fuscus all others",                                                            NA,                  "yes",      "Lesser Black-backed Gull",
                                               "A185",                      "Larus glaucoides",                                                            NA,                  "yes",                  "Iceland Gull",
                                               "A186",                     "Larus hyperboreus",                                                            NA,                  "yes",                 "Glaucous Gull",
                                               "A187",                         "Larus marinus",                                                            NA,                  "yes",       "Great Black-backed Gull",
                                               "A176",                  "Larus melanocephalus",                                                            NA,                  "yes",            "Mediterranean Gull",
                                               "A179",                      "Larus ridibundus",                                                            NA,                  "yes",             "Black-headed Gull",
                                               "A157",                      "Limosa lapponica",                                                            NA,                  "yes",             "Bar-tailed Godwit",
                                               "A156",                         "Limosa limosa",                                "all non-breeding populations",                  "yes",           "Black-tailed Godwit",
                                               "A616",               "Limosa limosa islandica",                                                            NA,                  "yes",           "Black-tailed Godwit",
                                             "A614-A",                  "Limosa limosa limosa",                             "Western Europe/NW & West Africa",                  "yes",           "Black-tailed Godwit",
                                               "A476",                     "Linaria cannabina",                                                            NA,                  "yes",               "Eurasian Linnet",
                                               "A477",                  "Linaria flavirostris",                                                            NA,                  "yes",                         "Twite",
                                               "A292",               "Locustella luscinioides",                                                            NA,                  "yes",                "Savi's Warbler",
                                               "A290",                     "Locustella naevia",                                                            NA,                  "yes",    "Common Grasshopper-warbler",
                                               "A497",                 "Lophophanes cristatus",                                                            NA,                  "yes",                   "Crested Tit",
                                               "A369",                     "Loxia curvirostra",                                                            NA,                  "yes",                 "Red Crossbill",
                                               "A370",                  "Loxia pytyopsittacus",                                                            NA,                  "yes",              "Parrot Crossbill",
                                               "A451",                         "Loxia scotica",                                                            NA,                  "yes",            "Scottish Crossbill",
                                                   NA,                              "Loxia sp",                                                            NA,                   "no",                              NA,
                                               "A246",                       "Lullula arborea",                                                            NA,                  "yes",                     "Wood Lark",
                                               "A271",                 "Luscinia megarhynchos",                                                            NA,                  "yes",            "Common Nightingale",
                                               "A152",                  "Lymnocryptes minimus",                                                            NA,                  "yes",                    "Jack Snipe",
                                               "A877",            "Lyrurus tetrix britannicus",                                                            NA,                  "yes",                  "Black Grouse",
                                               "A855",                       "Mareca penelope",                                                            NA,                  "yes",               "Eurasian Wigeon",
                                               "A889",                       "Mareca strepera",                                                            NA,                  "yes",                       "Gadwall",
                                               "A066",                       "Melanitta fusca",                                                            NA,                  "yes",                 "Velvet Scoter",
                                               "A900",                       "Melanitta nigra",                         "sensu stricto [excluding americana]",                  "yes",                 "Common Scoter",
                                               "A900",               "Melanitta nigra s. str.",                         "sensu stricto [excluding americana]",                  "yes",                 "Common Scoter",
                                             "A460-X",                   "Meleagris gallopavo",                                                            NA,                  "yes",                   "Wild Turkey",
                                               "A767",                    "Mergellus albellus",                                                            NA,                  "yes",                          "Smew",
                                               "A070",                      "Mergus merganser",                                                            NA,                  "yes",              "Common Merganser",
                                               "A069",                       "Mergus serrator",                                                            NA,                  "yes",        "Red-breasted Merganser",
                                               "A074",                         "Milvus milvus",                                                            NA,                  "yes",                      "Red Kite",
                                               "A016",                        "Morus bassanus",                                                            NA,                  "yes",               "Northern Gannet",
                                               "A262",                        "Motacilla alba",                                                            NA,                  "yes",                 "White Wagtail",
                                               "A261",                     "Motacilla cinerea",                                                            NA,                  "yes",                  "Grey Wagtail",
                                               "A260",                       "Motacilla flava",                                  "[excluding tschutschensis]",                  "yes",                "Yellow Wagtail",
                                               "A260",                 "Motacilla flava flava",                                  "[excluding tschutschensis]",                  "yes",                "Yellow Wagtail",
                                               "A319",                     "Muscicapa striata",                                                            NA,                  "yes",            "Spotted Flycatcher",
                                             "A761-X",                   "Myiopsitta monachus",                                                            NA,                  "yes",                 "Monk Parakeet",
                                             "A058-X",                          "Netta rufina",                                      "non-native populations",                  "yes",           "Red-crested Pochard",
                                               "A768",                      "Numenius arquata",                                                            NA,                  "yes",               "Eurasian Curlew",
                                               "A768",              "Numenius arquata arquata",                                                            NA,                  "yes",               "Eurasian Curlew",
                                               "A158",                     "Numenius phaeopus",                                                            NA,                  "yes",                      "Whimbrel",
                                             "A757-X",                      "Numida meleagris",                                                            NA,                  "yes",           "Helmeted Guineafowl",
                                               "A854",                 "Oceanodroma leucorhoa",                                                            NA,                  "yes",          "Leach's Storm Petrel",
                                               "A277",                     "Oenanthe oenanthe",                                        "[excluding seebohmi]",                  "yes",             "Northern Wheatear",
                                               "A337",                       "Oriolus oriolus",                                                            NA,                  "yes",        "Eurasian Golden Oriole",
                                               "A129",                            "Otis tarda",                                                            NA,                  "yes",                 "Great Bustard",
                                             "A750-X",                    "Oxyura jamaicensis",                                                            NA,                  "yes",                    "Ruddy Duck",
                                               "A094",                     "Pandion haliaetus",                                                            NA,                  "yes",                        "Osprey",
                                               "A323",                     "Panurus biarmicus",                                                            NA,                  "yes",            "Bearded Parrotbill",
                                             "A847-X",                  "Parabuteo unicinctus",                                                            NA,                  "yes",                 "Harris's Hawk",
                                               "A330",                           "Parus major",                                                            NA,                  "yes",                     "Great Tit",
                                               "A620",                     "Passer domesticus",                           "sensu stricto [excluding italiae]",                  "yes",                 "House Sparrow",
                                               "A620",             "Passer domesticus s. str.",                           "sensu stricto [excluding italiae]",                  "yes",                 "House Sparrow",
                                               "A356",                       "Passer montanus",                                                            NA,                  "yes",         "Eurasian Tree Sparrow",
                                             "A756-X",                        "Pavo cristatus",                                                            NA,                  "yes",                "Indian Peafowl",
                                               "A644",                         "Perdix perdix",                                                            NA,                  "yes",                "Grey Partridge",
                                               "A644",              "Perdix perdix all others",                                                            NA,                  "yes",                "Grey Partridge",
                                               "A472",                        "Periparus ater",                                                            NA,                  "yes",                      "Coal Tit",
                                               "A472",             "Periparus ater all others",                                                            NA,                  "yes",                      "Coal Tit",
                                               "A072",                       "Pernis apivorus",                                                            NA,                  "yes",        "European Honey-buzzard",
                                               "A684",             "Phalacrocorax aristotelis",                                                            NA,                  "yes",                 "European Shag",
                                               "A684", "Phalacrocorax aristotelis aristotelis",                                                            NA,                  "yes",                 "European Shag",
                                                   NA,                   "Phalacrocorax carbo",                                                            NA,                   "no",                     "Cormorant",
                                               "A683",             "Phalacrocorax carbo carbo",                                                            NA,                  "yes",               "Cormorant carbo",
                                               "A391",          "Phalacrocorax carbo sinensis",                                                            NA,                  "yes",            "Cormorant sinensis",
                                               "A170",                    "Phalaropus lobatus",                                                            NA,                  "yes",          "Red-necked Phalarope",
                                             "A115-X",                   "Phasianus colchicus",                                      "non-native populations",                  "yes",               "Common Pheasant",
                                               "A861",                    "Philomachus pugnax",                                                            NA,                  "yes",                          "Ruff",
                                               "A273",                  "Phoenicurus ochruros",                                                            NA,                  "yes",                "Black Redstart",
                                               "A274",               "Phoenicurus phoenicurus",                                                            NA,                  "yes",               "Common Redstart",
                                               "A572",                "Phylloscopus collybita", "sensu stricto [excluding canariensis, ibericus and tristis]",                  "yes",             "Common Chiffchaff",
                                               "A572",        "Phylloscopus collybita s. str.", "sensu stricto [excluding canariensis, ibericus and tristis]",                  "yes",             "Common Chiffchaff",
                                               "A618",                 "Phylloscopus ibericus",                                                            NA,                  "yes",            "Iberian Chiffchaff",
                                               "A314",               "Phylloscopus sibilatrix",                                                            NA,                  "yes",                  "Wood Warbler",
                                               "A316",                "Phylloscopus trochilus",                                                            NA,                  "yes",                "Willow Warbler",
                                               "A343",                             "Pica pica",                                                            NA,                  "yes",           "Black-billed Magpie",
                                               "A866",                         "Picus viridis",                           "sensu stricto [excluding sharpei]",                  "yes",     "Eurasian Green Woodpecker",
                                               "A866",                 "Picus viridis s. str.",                           "sensu stricto [excluding sharpei]",                  "yes",     "Eurasian Green Woodpecker",
                                               "A034",                   "Platalea leucorodia",                                                            NA,                  "yes",            "Eurasian Spoonbill",
                                               "A375",                 "Plectrophenax nivalis",                                                            NA,                  "yes",                  "Snow Bunting",
                                               "A140",                   "Pluvialis apricaria",                                                            NA,                  "yes",        "Eurasian Golden Plover",
                                               "A141",                  "Pluvialis squatarola",                                                            NA,                  "yes",                   "Grey Plover",
                                               "A007",                      "Podiceps auritus",                                                            NA,                  "yes",                  "Horned Grebe",
                                               "A005",                    "Podiceps cristatus",                                                            NA,                  "yes",           "Great Crested Grebe",
                                               "A006",                    "Podiceps grisegena",                                                            NA,                  "yes",              "Red-necked Grebe",
                                               "A008",                  "Podiceps nigricollis",                                                            NA,                  "yes",            "Black-necked Grebe",
                                               "A492",                       "Poecile montana",                                                            NA,                  "yes",                    "Willow Tit",
                                               "A492",                      "Poecile montanus",                                                            NA,                  "yes",                    "Willow Tit",
                                               "A493",                     "Poecile palustris",                                                            NA,                  "yes",                     "Marsh Tit",
                                               "A119",                       "Porzana porzana",                                                            NA,                  "yes",                 "Spotted Crake",
                                               "A266",                    "Prunella modularis",                                                            NA,                  "yes",                "Hedge Accentor",
                                             "A760-X",                    "Psittacula krameri",                                                            NA,                  "yes",          "Rose-ringed Parakeet",
                                               "A693",                 "Puffinus mauretanicus",                                                            NA,                  "yes",           "Balearic Shearwater",
                                               "A013",                     "Puffinus puffinus",                                                            NA,                  "yes",               "Manx Shearwater",
                                               "A346",               "Pyrrhocorax pyrrhocorax",                                                            NA,                  "yes",             "Red-billed Chough",
                                               "A372",                     "Pyrrhula pyrrhula",                                                            NA,                  "yes",            "Eurasian Bullfinch",
                                               "A118",                      "Rallus aquaticus",                                                            NA,                  "yes",                    "Water Rail",
                                               "A132",                "Recurvirostra avosetta",                                                            NA,                  "yes",                   "Pied Avocet",
                                               "A318",                   "Regulus ignicapilla",                                                            NA,                  "yes",                     "Firecrest",
                                               "A317",                       "Regulus regulus",                                                            NA,                  "yes",                     "Goldcrest",
                                               "A249",                       "Riparia riparia",                                                            NA,                  "yes",                   "Sand Martin",
                                               "A188",                      "Rissa tridactyla",                                                            NA,                  "yes",        "Black-legged Kittiwake",
                                               "A275",                      "Saxicola rubetra",                                                            NA,                  "yes",                      "Whinchat",
                                               "A276",                     "Saxicola rubicola",                                                            NA,                  "yes",              "Common Stonechat",
                                               "A276",                    "Saxicola torquatus",                                                            NA,                  "yes",              "Common Stonechat",
                                               "A155",                    "Scolopax rusticola",                                                            NA,                  "yes",             "Eurasian Woodcock",
                                               "A332",                        "Sitta europaea",                                                            NA,                  "yes",                 "Wood Nuthatch",
                                               "A063",                  "Somateria mollissima",                                                            NA,                  "yes",                  "Common Eider",
                                               "A857",                      "Spatula clypeata",                                                            NA,                  "yes",             "Northern Shoveler",
                                               "A856",                   "Spatula querquedula",                                                            NA,                  "yes",                      "Garganey",
                                               "A478",                         "Spinus spinus",                                                            NA,                  "yes",               "Eurasian Siskin",
                                               "A173",              "Stercorarius parasiticus",                                                            NA,                  "yes",              "Parasitic Jaeger",
                                               "A175",                     "Stercorarius skua",                                                            NA,                  "yes",                    "Great Skua",
                                               "A192",                      "Sterna dougallii",                                                            NA,                  "yes",                  "Roseate Tern",
                                               "A193",                        "Sterna hirundo",                                                            NA,                  "yes",                   "Common Tern",
                                               "A194",                     "Sterna paradisaea",                                                            NA,                  "yes",                   "Arctic Tern",
                                               "A863",                   "Sterna sandvicensis",                                                            NA,                  "yes",                 "Sandwich Tern",
                                               "A885",                    "Sternula albifrons",                                                            NA,                  "yes",                   "Little Tern",
                                               "A209",                 "Streptopelia decaocto",                                                            NA,                  "yes",        "Eurasian Collared Dove",
                                               "A210",                   "Streptopelia turtur",                                                            NA,                  "yes",          "European Turtle-dove",
                                               "A219",                           "Strix aluco",                                                            NA,                  "yes",                     "Tawny Owl",
                                               "A351",                      "Sturnus vulgaris",                                                            NA,                  "yes",               "Common Starling",
                                               "A311",                    "Sylvia atricapilla",                                                            NA,                  "yes",                      "Blackcap",
                                               "A310",                          "Sylvia borin",                                                            NA,                  "yes",                "Garden Warbler",
                                               "A309",                       "Sylvia communis",                                                            NA,                  "yes",            "Common Whitethroat",
                                               "A574",                        "Sylvia curruca",                                          "[including minula]",                  "yes",            "Lesser Whitethroat",
                                               "A302",                         "Sylvia undata",                                                            NA,                  "yes",              "Dartford Warbler",
                                             "A558-X",                   "Syrmaticus reevesii",                                                            NA,                  "yes",             "Reeves's Pheasant",
                                               "A004",                "Tachybaptus ruficollis",                                                            NA,                  "yes",                  "Little Grebe",
                                             "A397-X",                    "Tadorna ferruginea",                                      "non-native populations",                  "yes",                "Ruddy Shelduck",
                                               "A048",                       "Tadorna tadorna",                                                            NA,                  "yes",               "Common Shelduck",
                                               "A877",                         "Tetrao tetrix",                                                            NA,                  "yes",                  "Black Grouse",
                                               "A659",                      "Tetrao urogallus",                                                            NA,                  "yes",          "Western Capercaillie",
                                               "A659",           "Tetrao urogallus all others",                                                            NA,                  "yes",          "Western Capercaillie",
                                               "A863",               "Thalasseus sandvicensis",                                                            NA,                  "yes",                 "Sandwich Tern",
                                               "A161",                     "Tringa erythropus",                                                            NA,                  "yes",              "Spotted Redshank",
                                               "A166",                       "Tringa glareola",                                                            NA,                  "yes",                "Wood Sandpiper",
                                               "A164",                      "Tringa nebularia",                                                            NA,                  "yes",             "Common Greenshank",
                                               "A165",                       "Tringa ochropus",                                                            NA,                  "yes",               "Green Sandpiper",
                                               "A162",                        "Tringa totanus",                                                            NA,                  "yes",               "Common Redshank",
                                                   NA,               "Troglodytes troglodytes",                                                            NA,                   "no",                          "Wren",
                                               "A676",    "Troglodytes troglodytes all others",                                                            NA,                  "yes",                   "Winter Wren",
                                               "A434",  "Troglodytes troglodytes fridariensis",                                                            NA,                  "yes",                "Fair Isle Wren",
                                               "A286",                        "Turdus iliacus",                                                            NA,                  "yes",                       "Redwing",
                                               "A283",                         "Turdus merula",                                                            NA,                  "yes",            "Eurasian Blackbird",
                                               "A285",                     "Turdus philomelos",                                                            NA,                  "yes",                   "Song Thrush",
                                               "A284",                        "Turdus pilaris",                                                            NA,                  "yes",                     "Fieldfare",
                                               "A282",                      "Turdus torquatus",                                                            NA,                  "yes",                    "Ring Ouzel",
                                               "A287",                     "Turdus viscivorus",                                                            NA,                  "yes",                 "Mistle Thrush",
                                               "A213",                             "Tyto alba",                                                            NA,                  "yes",                      "Barn Owl",
                                               "A887",                            "Uria aalge",                                                            NA,                   "no",              "Common Guillemot",
                                               "A887",                 "Uria aalge all others",                                                            NA,                  "yes",              "Common Guillemot",
                                               "A142",                     "Vanellus vanellus",                                                            NA,                  "yes",              "Northern Lapwing"
                                         )
jncc/article12 documentation built on Oct. 10, 2019, 9:59 p.m.