DOI: 10.15468/dl.qhp5z8
title: Occurrence Download

description: A dataset containing 2531147 records in GBIF matching the query:
SELECT speciesKey, decimalLongitude, decimalLatitude, "year" FROM occurrence WHERE hasCoordinate = TRUE AND hasGeospatialIssues = FALSE AND CoordinateUncertaintyInMeters &gt;= 0 AND CoordinateUncertaintyInMeters &lt;= 1000 AND basisOfRecord IN ('LIVING_SPECIMEN', 'HUMAN_OBSERVATION', 'MACHINE_OBSERVATION', 'OCCURRENCE') AND ( (level0Gid IN ('ALA', 'ALB', 'AND', 'AUT', 'BLR', 'BEL', 'BIH', 'BGR', 'HRV', 'CZE', 'DNK', 'EST', 'FRO', 'FIN', 'FRA', 'DEU', 'GIB', 'GRC', 'GGY', 'HUN', 'ISL', 'IRL', 'IMN', 'ITA', 'JEY', 'XKO', 'LVA', 'LIE', 'LTU', 'LUX', 'MKD', 'MLT', 'MDA', 'MCO', 'MNE', 'NLD', 'NOR', 'POL', 'PRT', 'ROU', 'SMR', 'SRB', 'SVK', 'SVN', 'ESP', 'SJM', 'SWE', 'CHE', 'UKR', 'GBR', 'VAT') AND ((speciesKey = 1651430 AND "year" IN (2023, 2024, 2022, 2018, 2020, 2019, 2021)) OR (speciesKey = 1817797 AND "year" IN (2024, 2021, 2022, 2023)) OR (speciesKey = 2427091 AND "year" IN (2022, 2023, 2021, 2024, 2020, 2019, 2014, 2011, 2012, 2013)) OR (speciesKey = 2439261 AND "year" IN (2022, 2024, 2023, 2021, 2019, 2020, 2016, 2018, 2017, 2015)) OR (speciesKey = 2439270 AND "year" IN (2020, 2019, 2018, 2011, 2017, 2022, 2024, 2023, 2021, 2016)) OR (speciesKey = 2440954 AND "year" IN (2015, 2024, 2021, 2023, 2016, 2013, 2017, 2018, 2014, 2022)) OR (speciesKey = 2441005 AND "year" IN (2009, 2020, 2018)) OR (speciesKey = 2443002 AND "year" IN (2024, 2023, 2022, 2021, 2020, 2019, 2017, 2018, 2016, 2015)) OR (speciesKey = 2479226 AND "year" IN (2020, 2023, 2022, 2024, 2021, 2019, 2018, 2017, 2016, 2015)) OR (speciesKey = 2479407 AND "year" IN (2023, 2024, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015)) OR (speciesKey = 2489005 AND "year" IN (2023, 2024, 2019, 2022, 2018, 2016, 2017)) OR (speciesKey = 2493660 AND "year" IN (2023, 2022, 2024, 2021, 2019, 2017, 2020, 2018, 2016, 2015)) OR (speciesKey = 2498305 AND "year" IN (2010, 2009, 2004, 2011, 2003, 2012, 2013, 2006, 2000, 2007)) OR (speciesKey = 2566393 AND "year" IN (2013, 2016, 2011, 2015, 2017, 2018, 2014, 2012)) OR (speciesKey = 2702084 AND "year" IN (2024, 2023, 2022, 2021, 2019, 2020, 2017, 2015, 2016, 2018)) OR (speciesKey = 2704523 AND "year" IN (2022, 2021, 2009, 2012, 2024, 2020, 2023, 2019, 2018, 2017)) OR (speciesKey = 2706026 AND "year" IN (2021, 2022, 2020, 2024, 2023)) OR (speciesKey = 2739071 AND "year" IN (2022, 2020, 2024, 2023, 2021, 2017, 2018, 2019, 2016, 2015)) OR (speciesKey = 2765156 AND "year" IN (2022, 2024, 2021, 2023, 2020, 2019)) OR (speciesKey = 2767031 AND "year" IN (2022, 2024, 2021, 2023, 2012, 2019, 2009, 2010, 2020, 2008)) OR (speciesKey = 2891661 AND "year" IN (2022, 2021, 2024, 2023, 2020, 2019, 2018, 2011, 2012, 2010)) OR (speciesKey = 2891755 AND "year" IN (2022, 2021, 2020, 2024, 2023, 2019)) OR (speciesKey = 2891770 AND "year" IN (2021, 2024, 2022, 2020, 2023, 2019, 2015, 2014, 2013, 2017, 2018)) OR (speciesKey = 2928783 AND "year" IN (2022, 2021, 2019, 2023, 2024, 2020, 2018, 2010, 2011, 2012)) OR (speciesKey = 2931469 AND "year" IN (2022, 2024, 2021)) OR (speciesKey = 2970418 AND "year" IN (2022, 2021, 2013, 2023, 2024)) OR (speciesKey = 2972983 AND "year" IN (2022, 2021, 2019, 2020)) OR (speciesKey = 2978552 AND "year" IN (2024, 2018, 2023, 2022, 2020, 2019, 2017)) OR (speciesKey = 2978730 AND "year" IN (2022, 2024, 2023, 2021)) OR (speciesKey = 2979000 AND "year" IN (2022, 2021, 2024, 2023, 2020)) OR (speciesKey = 2979775 AND "year" IN (2022, 2023, 2018, 2024)) OR (speciesKey = 2984306 AND "year" IN (2022, 2021, 2020, 2019, 2024, 2023, 2009, 2018)) OR (speciesKey = 2986239 AND "year" IN (2022, 2021, 2020, 2023, 2024)) OR (speciesKey = 2986293 AND "year" IN (2022, 2021, 2020, 2019)) OR (speciesKey = 3003244 AND "year" IN (2024, 2022, 2023, 2021, 2020, 2019, 2017, 2014, 2018, 2016)) OR (speciesKey = 3033896 AND "year" IN (2022, 2021, 2020, 2019, 2024, 2023, 2018, 2017, 2015, 2016)) OR (speciesKey = 3033905 AND "year" IN (2020, 2023, 2024, 2022, 2021)) OR (speciesKey = 3034825 AND "year" IN (2022, 2021, 2024, 2020, 2023, 2015, 2013, 2019, 2014, 2016)) OR (speciesKey = 3089150 AND "year" IN (2022, 2021, 2020, 2024, 2023, 2019, 2010, 2011)) OR (speciesKey = 3109086 AND "year" IN (2019, 2022, 2024, 2023, 2020, 2021, 2015, 2014, 2017, 2018)) OR (speciesKey = 3169137 AND "year" IN (2022, 2021, 2020, 2019, 2023, 2024, 2018, 2016, 2017, 2015)) OR (speciesKey = 3170823 AND "year" IN (2021, 2022, 2019, 2020, 2024, 2023, 2018, 2017, 2015, 2016)) OR (speciesKey = 3172294 AND "year" IN (2022, 2020, 2021, 2019, 2024, 2023)) OR (speciesKey = 3173338 AND "year" IN (2024, 2022, 2023, 2021, 2020, 2019, 2018, 2017, 2015, 2016)) OR (speciesKey = 3189843 AND "year" IN (2024, 2022, 2023, 2021, 2020, 2019, 2018, 2017, 2016, 2015)) OR (speciesKey = 3190653 AND "year" IN (2024, 2022, 2019, 2021, 2020, 2023, 2018, 2015, 2017, 2016)) OR (speciesKey = 4264680 AND "year" IN (2024, 2023, 2022, 2019, 2020, 2017, 2018, 2016, 2021, 2015)) OR (speciesKey = 4933568 AND "year" IN (2022, 2021, 2020, 2024, 2019, 2023, 2018)) OR (speciesKey = 4989904 AND "year" IN (2023, 2024, 2022, 2021, 2020, 2019, 2018, 2017, 2014, 2016)) OR (speciesKey = 5218987 AND "year" IN (2021, 2024, 2020, 2015, 2022, 2023, 2018, 2017, 2016, 2019)) OR (speciesKey = 5219362 AND "year" IN (2022, 2018, 2021, 2020, 2016, 2017, 2023, 2024, 2015, 2019)) OR (speciesKey = 5219681 AND "year" IN (2020, 2021, 2024, 2023, 2019, 2018, 2022, 2015, 2012, 2017, 2016)) OR (speciesKey = 5289833 AND "year" IN (2024, 2022, 2021)) OR (speciesKey = 5334240 AND "year" IN (2021, 2022, 2024, 2020, 2023, 2018, 2019, 2017, 2014, 2016)) OR (speciesKey = 5341784 AND "year" IN (2022, 2021, 2023, 2020, 2024, 2019, 2011, 2003, 2002, 2018)) OR (speciesKey = 5352251 AND "year" IN (2024, 2023, 2022, 2020, 2021, 2019, 2018, 2017, 2015, 2011)) OR (speciesKey = 5361785 AND "year" IN (2022, 2024, 2021, 2020, 2023, 2015, 2019, 2017, 2016, 2005)) OR (speciesKey = 5361889 AND "year" IN (2024, 2023, 2022, 2021, 2020, 2019)) OR (speciesKey = 5362054 AND "year" IN (2017, 2022, 2021, 2018, 2024, 2023, 2020, 2014, 2019, 2016)) OR (speciesKey = 5372639 AND "year" IN (2020, 2019, 2022, 2024, 2023, 2021, 2018, 2017, 2016, 2015)) OR (speciesKey = 5376648 AND "year" IN (2024, 2023, 2022, 2021, 2020, 2019, 2018, 2015, 2014, 2012)) OR (speciesKey = 5384075 AND "year" IN (2012, 2024, 2023, 2022, 2021)) OR (speciesKey = 5384931 AND "year" IN (2022, 2021, 2024, 2020)) OR (speciesKey = 5914287 AND "year" IN (2022, 2021, 2019, 2020, 2023, 2024, 2018)) OR (speciesKey = 8002952 AND "year" IN (2022, 2021, 2024, 2023, 2020, 2006, 2019, 2018, 2007, 2017)) OR (speciesKey = 8149049 AND "year" IN (2020, 2021, 2022)) OR (speciesKey = 8170635 AND "year" IN (2021, 2022, 2020, 2019, 2024, 2023, 2018, 2017, 2016, 2015)) OR (speciesKey = 8424006 AND "year" IN (2020, 2013, 2014, 2022, 2006)) OR (speciesKey = 8427624 AND "year" IN (2022, 2021, 2023, 2024, 2020, 2019, 2018, 2017, 2016, 2014)) OR (speciesKey = 9326020 AND "year" IN (2023, 2024, 2022, 2021, 2020, 2019, 2018, 2016, 2017)))) OR ("year" &gt;= 1992 AND "year" &lt;= 2024 AND ((speciesKey = 1651430 AND level0Gid IN ('JPN')) OR (speciesKey = 1817797 AND level0Gid IN ('CAN', 'MEX', 'USA')) OR (speciesKey = 2427091 AND level0Gid IN ('CAN', 'USA')) OR (speciesKey = 2439261 AND level0Gid IN ('CHN')) OR (speciesKey = 2439270 AND level0Gid IN ('IND')) OR (speciesKey = 2440954 AND level0Gid IN ('CHN', 'JPN', 'KOR', 'PRK', 'RUS', 'TWN', 'VNM')) OR (speciesKey = 2441005 AND level0Gid IN ('DZA', 'EGY', 'LBY', 'MAR', 'MLI', 'MRT', 'NER', 'SDN', 'TCD', 'TUN')) OR (speciesKey = 2443002 AND level0Gid IN ('USA')) OR (speciesKey = 2479226 AND level0Gid IN ('AFG', 'BEN', 'BFA', 'BGD', 'BTN', 'CAF', 'CHN', 'CIV', 'CMR', 'DJI', 'EGY', 'ERI', 'ETH', 'GHA', 'GIN', 'GMB', 'GNB', 'IND', 'LBR', 'LKA', 'MLI', 'MMR', 'MRT', 'NER', 'NGA', 'NPL', 'PAK', 'SDN', 'SEN', 'SLE', 'TCD', 'TGO', 'UGA', 'VNM')) OR (speciesKey = 2479407 AND level0Gid IN ('ARG', 'BOL', 'BRA', 'PRY', 'URY')) OR (speciesKey = 2489005 AND level0Gid IN ('AFG', 'BGD', 'BTN', 'CHN', 'EGY', 'IND', 'IRN', 'KAZ', 'KHM', 'LAO', 'LBN', 'LKA', 'MMR', 'MYS', 'NPL', 'PAK', 'THA', 'TJK', 'TKM', 'UZB', 'VNM')) OR (speciesKey = 2493660 AND level0Gid IN ('AGO', 'BDI', 'BWA', 'CAF', 'CIV', 'CMR', 'COD', 'COG', 'ETH', 'GAB', 'GHA', 'GIN', 'GNQ', 'KEN', 'LBR', 'LSO', 'MOZ', 'MWI', 'NAM', 'NGA', 'RWA', 'SDN', 'SLE', 'SOM', 'STP', 'SWZ', 'TZA', 'UGA', 'ZAF', 'ZMB', 'ZWE')) OR (speciesKey = 2498305 AND level0Gid IN ('MEX')) OR (speciesKey = 2566393 AND level0Gid IN ('CHN', 'JPN', 'KOR', 'PRK', 'TWN')) OR (speciesKey = 2702084 AND level0Gid IN ('BOL', 'BRA', 'CAN', 'COL', 'CRI', 'ECU', 'GTM', 'HND', 'JAM', 'MEX', 'PER', 'PRI', 'USA')) OR (speciesKey = 2704523 AND level0Gid IN ('ARG', 'BRA', 'CHL', 'PRY', 'URY')) OR (speciesKey = 2706026 AND level0Gid IN ('CHN', 'IDN', 'JPN', 'KOR', 'PHL', 'RUS', 'TWN')) OR (speciesKey = 2739071 AND level0Gid IN ('CHN', 'MMR')) OR (speciesKey = 2765156 AND level0Gid IN ('BRA')) OR (speciesKey = 2767031 AND level0Gid IN ('MEX', 'USA')) OR (speciesKey = 2891661 AND level0Gid IN ('NAM', 'ZAF')) OR (speciesKey = 2891755 AND level0Gid IN ('BLZ', 'BOL', 'CAN', 'COL', 'CRI', 'CUB', 'ECU', 'GLP', 'GTM', 'HND', 'MEX', 'MTQ', 'NIC', 'PAN', 'PER', 'PRI', 'SLV', 'USA', 'VEN')) OR (speciesKey = 2891770 AND level0Gid IN ('IND', 'NPL', 'PAK')) OR (speciesKey = 2928783 AND level0Gid IN ('ARG', 'BOL', 'BRA', 'CHL', 'ECU', 'PER', 'PRY', 'URY')) OR (speciesKey = 2931469 AND level0Gid IN ('BRA', 'URY')) OR (speciesKey = 2970418 AND level0Gid IN ('BLZ', 'MEX')) OR (speciesKey = 2972983 AND level0Gid IN ('AFG', 'BTN', 'CHN', 'IND', 'IRN', 'JPN', 'MMR', 'NPL', 'PAK', 'PRK', 'TWN')) OR (speciesKey = 2978552 AND level0Gid IN ('AUS')) OR (speciesKey = 2978730 AND level0Gid IN ('AUS')) OR (speciesKey = 2979000 AND level0Gid IN ('AUS')) OR (speciesKey = 2979775 AND level0Gid IN ('AUS')) OR (speciesKey = 2984306 AND level0Gid IN ('ARG', 'BOL', 'BRA', 'CHL', 'COL', 'ECU', 'PER')) OR (speciesKey = 2986239 AND level0Gid IN ('AUS')) OR (speciesKey = 2986293 AND level0Gid IN ('NZL')) OR (speciesKey = 3003244 AND level0Gid IN ('CHN', 'JPN')) OR (speciesKey = 3033896 AND level0Gid IN ('JPN')) OR (speciesKey = 3033905 AND level0Gid IN ('ARG', 'CHL')) OR (speciesKey = 3034825 AND level0Gid IN ('AZE', 'GEO', 'RUS')) OR (speciesKey = 3089150 AND level0Gid IN ('CHL')) OR (speciesKey = 3109086 AND level0Gid IN ('BWA', 'LSO', 'MOZ', 'NAM', 'SWZ', 'ZAF')) OR (speciesKey = 3169137 AND level0Gid IN ('CHN', 'JPN', 'KOR')) OR (speciesKey = 3170823 AND level0Gid IN ('CHN')) OR (speciesKey = 3172294 AND level0Gid IN ('CHN', 'HKG', 'LAO', 'TWN', 'VNM')) OR (speciesKey = 3173338 AND level0Gid IN ('CHN')) OR (speciesKey = 3189843 AND level0Gid IN ('CHN', 'JPN', 'KOR', 'MNG', 'PRK', 'RUS')) OR (speciesKey = 3190653 AND level0Gid IN ('AUS', 'CHN')) OR (speciesKey = 4264680 AND level0Gid IN ('ARG', 'BOL', 'BRA', 'CHL', 'PRY', 'URY')) OR (speciesKey = 4933568 AND level0Gid IN ('ZAF')) OR (speciesKey = 4989904 AND level0Gid IN ('CHN', 'JPN', 'KOR', 'PRK', 'RUS')) OR (speciesKey = 5218987 AND level0Gid IN ('CAN', 'TUR', 'USA')) OR (speciesKey = 5219362 AND level0Gid IN ('AGO', 'BEN', 'BFA', 'BWA', 'CAF', 'CIV', 'CMR', 'DJI', 'DZA', 'EGY', 'ERI', 'ETH', 'GHA', 'GIN', 'GMB', 'KEN', 'LBY', 'LSO', 'MAR', 'MLI', 'NAM', 'NER', 'NGA', 'OMN', 'SAU', 'SDN', 'SEN', 'TCD', 'TUN', 'UGA', 'YEM', 'ZAF', 'ZMB', 'ZWE')) OR (speciesKey = 5219681 AND level0Gid IN ('CAN', 'USA')) OR (speciesKey = 5289833 AND level0Gid IN ('ARG')) OR (speciesKey = 5334240 AND level0Gid IN ('JPN')) OR (speciesKey = 5341784 AND level0Gid IN ('BOL', 'COL', 'ECU', 'PER', 'VEN')) OR (speciesKey = 5352251 AND level0Gid IN ('USA')) OR (speciesKey = 5361785 AND level0Gid IN ('ARG', 'BOL', 'BRA', 'CHL', 'ECU', 'PER', 'PRY')) OR (speciesKey = 5361889 AND level0Gid IN ('CHN')) OR (speciesKey = 5362054 AND level0Gid IN ('AUS', 'NZL')) OR (speciesKey = 5372639 AND level0Gid IN ('CHN')) OR (speciesKey = 5376648 AND level0Gid IN ('BLZ', 'CAN', 'CRI', 'GTM', 'HND', 'MEX', 'NIC', 'PAN', 'SLV', 'USA')) OR (speciesKey = 5384075 AND level0Gid IN ('BMU', 'CUB', 'MEX', 'USA')) OR (speciesKey = 5384931 AND level0Gid IN ('BTN', 'CHN', 'IND', 'JPN', 'KOR', 'NPL', 'PRK', 'TWN')) OR (speciesKey = 5914287 AND level0Gid IN ('AUS', 'CHN', 'IDN', 'IND', 'JPN', 'LKA', 'SLB')) OR (speciesKey = 8002952 AND level0Gid IN ('CAN', 'MEX', 'USA')) OR (speciesKey = 8149049 AND level0Gid IN ('CHN')) OR (speciesKey = 8170635 AND level0Gid IN ('CHN')) OR (speciesKey = 8424006 AND level0Gid IN ('JPN', 'PHL', 'THA')) OR (speciesKey = 8427624 AND level0Gid IN ('AUS', 'GUM', 'KIR', 'MNP', 'NFK', 'NRU', 'PLW', 'SLB', 'USA')) OR (speciesKey = 9326020 AND level0Gid IN ('BGD', 'BTN', 'CHN', 'IDN', 'IND', 'KHM', 'LAO', 'MMR', 'MYS', 'NPL', 'PAK', 'PHL', 'PRI', 'SGP', 'THA', 'TLS', 'VNM')))) )

 The dataset's 2531147 records were derived from 1417 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0000904-260119153935675/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.