DOI: 10.15468/dl.detxx7
title: Occurrence Download

description: A dataset containing 1813 records in GBIF matching the query:
SELECT taxonKey, COUNT(*) AS total_observations, SUM(CASE WHEN GBIF_StringArrayContains(mediaType, 'StillImage', FALSE) THEN 1 ELSE 0 END) AS total_images, SUM(CASE WHEN GBIF_StringArrayContains(mediaType, 'StillImage', FALSE) AND license = 'CC0_1_0' THEN 1 ELSE 0 END) AS cc0_1_0_images, SUM(CASE WHEN GBIF_StringArrayContains(mediaType, 'StillImage', FALSE) AND license = 'CC_BY_4_0' THEN 1 ELSE 0 END) AS cc_by_4_0_images, SUM(CASE WHEN GBIF_StringArrayContains(mediaType, 'StillImage', FALSE) AND license IN ('CC0_1_0', 'CC_BY_4_0') THEN 1 ELSE 0 END) AS commercial_ok_images, SUM(CASE WHEN GBIF_StringArrayContains(mediaType, 'StillImage', FALSE) AND license = 'CC_BY_NC_4_0' THEN 1 ELSE 0 END) AS cc_by_nc_4_0_images FROM occurrence WHERE taxonKey IN (5141764,5141771,1867546,1867552,1867547,1949004,5127921,5127926,5127874,5137794,1734851,11882779,1734863,1927360,1751139,1751136,1751144,1751142,1751135,1751141,1751138,1751140,1751137,1825511,1833409,1947729,1839530,10383220,1900918,1752639,1752637,1955225,1955169,1955126,1955207,1955054,1955212,1955124,1955155,1871439,1830834,1830817,1830819,1830820,11493225,1912064,1888987,1906563,1990135,5144058,5144116,5144128,1859026,1859022,1859024,1853839,1963854,9543086,1865869,1837802,1837778,1738006,1880867,1861359,1861365,1861353,1861362,1861367,1861356,1861363,1861368,1861358,1746366,1746367,1746365,1762216,1752889,1752890,1848942,1848933,1834752,1834759,1834751,1834754,5141512,5141513,1877513,11534306,1883942,1883944,1746434,1746480,1746482,1852890,1877395,1754497,5108946,1849298,1961183,1926708,1990391,1748148,1842832,1857753,1938198,1938207,1938199,1769302,4688049,1984652,11418376,11895519,1748888,1787023,1787032,1978272,1831082,1889202,9617411,10175639,1772759,1787259,9283380,1773743,1888238,1888202,1888241,1866980,1866979,1743249,1956424,5103179,1867806,1867295,1957051,1864850,1864866,12097473,1864842,1864852,1801430,1955992,1957500,1957498,1908353,1952605,1952606,1745013,1736803,1736808,1736826,1736809,1736819,1736820,1736825,1865797,5977357,1814971,1867961,1867944,1867957,1867942,1867964,1867934,1875218,12027925,1848211,1848214,1848210,1864576,1964151,1964144,1964141,12384095,9384105,10658692,9854169,10182473,1841124,1737321,1737319,1802276,11730990,11830442,9253630,5101623,5101631,5101624,5101632,5101614,1853511,1753213,11899283,1737681,1733806,5137970,1735557,9298635,1887026,1812227,8153403,1822663,1786465,1905331,1892320,1783302,5149214,1850505,1850507,1850508,1850487,1850500,1850481,10489775,1850497,1970443,1841080,1861449,5116538,1867781,1762226,1840249,5122303,12100940,1878332,1872195,1853472,1830900,1830902,1749543,5143316,5143315,1818638,1738659,5122464,1731875,5122461,1761769,1902880,1902911,10187235,1902949,1902917,1902925,5123315,5123286,5123196,1992102,1992106,4526933,10539702,5122457,1782233,1841333,1824424,1828169,1828188,1828171,1828182,5119156,5119148,1866715,1801503,1848193,1848200,1839451,1839457,1839453,1885702,1850513,1876267,1841221,1853217,1853216,1853218,1891583,1891584,1891537,1891576,1891533,1991751,1753059,1882884,1985061,1858557,1840229,1890553,1890934,1890775,1890944,1890491,1890788,1890599,1890508,1890670,1890962,1743184,1993036,1842093,1842097,1842120,1842108,1842112,1842098,1842149,1842090,11605212,1842110,1842151,1842117,1842106,1842092,1842132,1842096,11910029,1846066,1940135,4525891,4525899,4525866,4525877,4525903,4525879,4525884,4525906,11587331,1779638,1901804,1901794,1949152,1949244,1949219,1949220,1949154,1876249,5101609,5141901,10017342,11760440,1946019,1824777,1766285,6120487,6120485,1976311,1976314,11549995,6118304,6112116,1823672,1976235,1872021,9090117,11582359,1920981,1825406,1924797,1848592,1848591,1848594,11766498,4527910,1889249,1889239,1786711,1736309,1738895,1738897,9121422,11750746,9143376,12075053,1738892,11942811,9087275,8938654,5123714,6106716,6106709,1873303,1768210,1768215,1768207,1768217,1768218,1768212,1768213,5118878,1767896,11097510,1767891,1767883,1767899,9558947,1865837,1733061,1808639,6112005,1832380,5149833,1867994,7213994,1867991,1874320,1748743,1748742,1760282,1803545,6194854,1993358,1993305,1993186,1993284,1993231,1872308,1872300,1872304,1872317,1872286,1972033,1863810,11427182,11532260,1971779,1736319,1736322,1736320,1739034,1739035,1739009,1739011,11295372,5149455,1822287,1739360,1739349,1739339,1739378,1739370,1739385,1739376,1739367,1739350,11717411,1739392,1739383,1739356,1739362,1739354,1739345,1739374,1739365,1739387,1739368,1770170,1786137,1989157,1871038,1871036,1861195,8207819,1825600,10885351,1988888,1769944,6210973,1959139,1800559,1800562,1800572,1769851,10881384,1769908,1769888,8062447,5116423,5116440,11470655,1868417,1825394,5124542,5124582,5124575,11686197,5124589,5124561,5124598,5124585,5124606,5124587,5124590,5124560,5124564,5110070,1861592,1873614,1873616,1889330,9366463,1780227,1868203,1955012,1954973,1954933,1955008,1869918,1869938,1869930,1785464,1766324,1731783,1731777,1731785,1731787,5132846,1865732,1951227,8718724,5126101,5126114,5126095,5126147,5126109,5126080,5126068,5126100,1873377,1873382,1950679,1743393,1743392,1827362,5105902,6111682,5105895,1757644,10129011,9857679,1870395,1887051,1876504,11886987,1746204,1799017,1869661,1797030,1797027,1797032,11475978,1824410,1824409,1770566,1942497,1819310,1819308,1942925,1942932,1861411,1861424,1877492,1839938,1743466,10247309,5124980,5124939,11428819,10643830,11500793,9947701,9595676,10111738,6132605,10623428,10492194,11236077,10022170,1986704,1986721,1986650,1986743,1809499,5110609,9435845,1857216,1857228,1827228,1827230,7699548,1955284,1887576,1831709,1865645,9836597,1733239,1733237,1750308,1835396,9261458,9584150,9126987,8636289,8845984,9418024,4534663,8375515,9373309,7558165,9163659,9421444,8475976,9359660,9506065,11901871,9548788,9043287,9338701,9042018,9534429,9488551,8990774,9325699,9562236,9281907,9428750,9608887,9226244,9093671,9425627,9288185,8647523,9559019,9485070,1847890,1805044,4527938,1851657,1851655,1884967,4531706,5113015,1736271,1736270,1837699,1837706,1837703,1837714,1837708,1837709,1962162,1783692,1985456,1985451,1873786,1873781,1881294,1881228,1881229,1881254,1881257,1785426,1947803,1850766,1752849,1752869,1752864,1752872,1752874,1752875,1752868,1752860,5145470,5145396,5145068,5145564,5145168,5144806,5145859,5145624,5144983,1985339,5145318,5144870,5145817,5145334,8929539,5145480,1781877,1957824,1956277,1956269,1956284,1956262,1956292,1956265,1956281,1956297,1956301,1956290,1956263,1792614,1792630,1849867,1849913,1849739,1849761,1849690,1849782,1849805,1849756,1849911,1849873,1849855,1849828,1849817,1849863,1849803,1849799,1849734,1849689,1849976,1849670,1849801,1849846,10101635,1848806,1848787,11896737,1848811,10602994,1848834,1848823,1848797,11845006,8798308,1841974,1841825,1841732,1841664,1841545,1841998,1841792,1841679,4527497,1841807,1841788,1841654,1841926,1841840,1841784,1841764,1841672,11975215,1841636,1841976,1841594,1841627,1841812,1841697,1830633,1839109,8503184,1839137,8550765,1875858,1875864,4529978,1739440,4529976,5144248,5144273,1801170,1801188,1801150,1801155,1801160,1801180,1970243,1970259,1877526,1826515,1835433,9724183,1751123,1848249,1753595,1753649,5101599,5101591,6113886,5133701,5133702,10534945,1883020,1987643,1796984,1762413,1762355,1762403,1762388,1762365,1762356,1762357,1950362,11772177,11907349,10493589,11602568,11430696,11600680,11763645,1955757,5108640,1757955,1753753,11494086,11573134,11893572,1753749,1753755,10552362,1823674,1824390,1926809,1731494,1731480,10243863,5734276,1753833,1753873,1753848,1753861,1753845,1753864,1753880,1753871,1753889,1753859,1870497,1809585,1993627,5143978,5143960,5143967,1768384,1775112,1801080,1824160,6133058,5111031,5111054,5111029,5111007,6133057,5111043,5111052,5111047,6119965,4526979,1762264,1762248,1762271,1762262,1870558,1870557,1847868,6234487,12136917,1886577,1954852,1968723,1968768,1968727,1954273,1954274,1819683,1743660,1743662,1945318,1940485,1849993,1849988,1842185,1755183,1747667,1747660,1747688,1747682,1747649,1747680,1747659,1747663,1747697,1747687,1872213,1872210,1872215,1774334,4301276,1880505,1739672,1739619,1739661,1739641,1736837,1827649,1827650,1827644,1736426,1752217,1872590,1761188,6132979,1859929,11633657,11691944,11620008,11811100,11808623,1782304,1801421,1864183,1819266,1819270,1819257,12229721,12216494,1812388,1743162,5103014,5103056,5103054,1960540,1811773,1812297,1811892,1811969,1811990,1812115,1812096,1811958,1811847,1812212,1812202,1811828,5139937,1801770,9053908,1793698,1843741,9263757,1774028,5109899,5109853,8038868,1748965,1748959,1748954,1748960,1748962,1748967,1748956,1748957,11754048,1731081,1842742,1842242,12020325,1842730,11791092,1842734,1842738,1842722,9258904,1842248,1922024,9634400,1965069,1965055,1965066,1965082,1859063,1859061,1942148,1830539,1741571,8833193,1741559,1741698,9940829,1831654,1831627,1831458,1831571,1831481,1831602,1831585,1831471,1831659,10888628,1831522,1831496,1831450,1831483,1831466,1831641,1831610,1831593,1831584,1831514,1831506,1831599,11322712,1824642,12068262,1846858,1799770,6114933,6114660,6114692,1852425,1852421,1852423,1836232,1836584,1836455,1836425,1836411,1836835,1836468,1836327,1836199,1836415,1836436,1836590,1836854,1989083,1989090,1794032,1858744,1858851,5122032,8962018,8816100,9983472,1850690,1875585,1875534,1895154,1909319,5111784,5111753,5111740,5111795,5111814,5111790,5102472,9572844,9529648,9333068,9275915,9467801,9351897,9354958,8646311,9413651,5102468,9417128,9449246,9608585,5806381,9369870,7529101,7960076,9235687,9329013,9478647,5806385,9626971,8730785,5715268,8528570,5102552,9466625,8817025,9486283,9619624,9436605,8136372,5715269,9601692,5102517,9551569,9464669,5806377,9576046,9233678,5102524,9557768,5102496,9247121,9471353,9291549,5102563,8633704,9626406,8901518,9448853,5102532,7542398,9407109,8443221,8984932,9582193,5102530,9178686,9104595,9427435,9395514,8282333,5102536,9273499,9324487,5769754,8194296,6119909,1842967,1842969,10655311,1842978,1820103,1890020,6212999,1849530,1849613,1749239,1749245,1749253,1749240,1749246,1749254,1749241,1749257,1749243,1749250,1819209,1733673,1733756,1733721,1733737,1733729,1733687,1733678,1733753,1733709,1733674,1733699,1733757,1733740,1733755,1733738,1733677,1733778,1733708,1733742,1743333,1743321,6117673,9293743,5103003,1743324,7372375,1952501,1793592,1793589,1993515,1993484,1993521,1993485,1993493,1993459,1993478,1993514,6122573,11955236,8653121,9253999,1827857,1752211,1877616,1891502,1734543,1891245,1891240,1891239,1891253,1891250,5110247,1747022,1747025,1747021,1747023,1824736,1768512,1752307,11607938,10063228,1752363,11917039,1752371,1752365,5119535,5119536,1830361,5119528,1747114,1747100,6117659,1887821,1887768,1887744,1887948,1887964,1887730,1887769,1887729,1888021,1887799,1887939,1888007,1739723,1739719,1801415,1850179,1850159,1850180,1850146,1850184,1845886,10145421,1886100,1734987,1734986,1765653,9523595,9487538,1760179,9579889,1944940,1944942,1740874,10580997,10193155,12171102,1940561,11902698,1940688,1940643,9014089,1940614,11740975,8956742,11569233,1940541,10286565,1940506,1940612,1940602,1940571,1940728,1940620,1940530,9930604,12200447,1940906,6122620,1940517,10347220,1940666,12200663,11770773,10487332,1940673,1940651,10152171,1940606,11442940,1940776,11625411,11477927,1940678,11444963,1940752,1871212,1963209,1963210,1963212,1837773,1962090,1962118,1962100,1962111,1887082,12328282,1852627,1970089,1970038,1970079,1970070,1970073,10523304,1886015,1885968,1991031,1785945,1785932,1786027,1786014,1785934,1809138,1880353,8791833,11316303,1827936,1827993,1828033,1784783,9889514,10004121,11774041,10572213,9622987,9531432,10368183,10555583,11855063,9240588,10163856,1864905,9606779,10123854,9339840,1749012,1879028,1879025,1858624,1873585,1752500,1914959,1945694,7700604,1826912,1945419,1945421,1882359,1870425,1870428,1769411,1769424,6214679,1960174,1960181,1877471,11635845,1944168,1827408,1827417,11525950,1754545,1754623,1754627,1765753,1801339,1882266,1920611,1765446,6117510,11946508,1846493,1846485,1908205,10037299,10468484,1850651,1850662,1852895,1852896,5119055,5119053,5123610,5123612,1886619,5125780,10625553,6114162,1842794,1749080,1749081,1749079,1749082,1952858,1952837,10128995,1826815,1826814,1838084,1849642,1849638,1849645,1947949,1947925,1947920,1916772,1870637,1870639,1947478,1877499,9441888,1781233,5121889,5121906,5121894,5121907,5121887,5121885,5121839,5121863,1903607,1746502,1863528,1863515,1863561,1863505,1863494,1863552,1863575,1863544,1863490,1863537,1753423,1828262,1968990,1761387,1870940,1807946,1807938,1807924,1807930,1731341,1731345,1891936,1891937,1891938,1922633,11251648,1872052,1872044,1746188,1771879,1771877,1795045,5143022,5143007,5143030,1744640,1744641,8099064,11644672,11703026,11855431,1990164,1990173,1964335,1964339,1964311,1964357,1964365,1964316,1964305,1964367,1765883,11426231,1761191,1761192,1896915,1987145,1864197,1853383,1853384,1947524,10817011,1737625,1737627,1737629,1737630,12029777,5879782,1824091,1824107,1824121,1824114,1824130,1942370,1930096,1930423,1930026,1929809,1929955,6132706,1930155,1930137,1930145,1930304,1930760,1830637,1830643,1850674,1868371,5148432,1862495,1862433,1862446,11907754,1862437,1862503,1862434,1748816,1748813,1931509,1957303,1957286,1772571,1878432,1977184,5103863,8399654,1849522,1852304,1852234,1852248,1852254,1852288,1852279,1883444,1883457,1943458,1870017,1942697,11781983,11895593,1752604,11590714,1752558,1752628,1752556,1752610,1752598,1752570,11496117,1752611,11476537,1752603,11521108,1752612,8282996,1946934,1946925,1747931,1747924,1833788,1807202,1783313,9504222,5884243,5113387,5142838,1798000,1877287,1877291,1944030,1754136,10335011,1830297,1853312,1853307,1874922,1990998,1990994,1837946,1837948,1837925,1837943,1837936,10215679,6116034,11420352,1837750,1852449,8175582,5144465,1834382,1834387,1834396,6116110,5122871,7917732,5122997,1856408,1856409,1856405,1771977,1771975,1940287,1856832,1856819,1856827,1856820,6132957,1873855,1873868,1873861,1939481,1939448,12236636,1939489,1939475,5124866,5124873,1880797,1870003,6201570,1781292,5102352,5102320,5102365,5102335,5102316,5102363,5102387,5102302,5102390,11712654,5734268,5119836,5119830,5119846,5119848,1741687,1822106,1871924,1871923,1975383,1836934,1836943,1836940,1836945,1835128,1835124,1835121,5104344,5104348,5104487,1860424,1846279,1760398,1821330,1821329,1732126,1732098,1732124,1732096,1732137,1732129,1732114,1760597,1774079,1743679,1743676,1743677,1743680,1869656,1856316,1856324,1856315,1856322,1872187,1843672,1843676,1843654,1841170,1752931,1878188,1855717,1940858,1969588,1969581,1969576,1969589,11872473,1969598,9537469,5117593,5117581,1732457,1837658,1814581,1752243,1752247,1788058,1828336,6113767,1732923,1786404,1786339,1970321,1970340,5147644,5147631,5147609,5147636,5147621,11447171,1859017,1783372,1800149,1993423,1951857,5102588,8727868,8812665,8403994,9148047,9053549,5102594,8330283,5102583,9172651,5102577,7687803,1731292,1763761,1763701,8167743,1964691,1769934,1872765,9598514,1969978,1754128,1767555,1830608,1857799,10636095,1870485,7346237,1959488,6116946,1786542,1800186,1800191,1800187,1881346,6122747,1752355,1952965,1822293,1976366,10602416,1851318,1757655,1757660,1757657,1757662,1757658,1757652,1757659,1747935,8959303,1869554,1828261,1931179,1769483,1769479,4685557,1940087,1889043,1865748,1887147,1887195,1887186,1887206,1887183,1887266,1887217,1887165,1887151,1887237,1887209,1887150,1887127,1887201,1887166,1887137,1887124,8218441,1887110,1887174,1887119,1887185,1887111,1887205,1887156,1887265,1887138,1878205,1878209,1793425,1775006,1769724,1747965,1748158,1748156,1881305,1871875,1780089,1780102,1780079,1870072,1870071,1870076,4531061,5142213,1932890,1932897,1944285,4528844,1860118,1823294,1867673,1829637,1926422,1926424,1866423,1803198,1803203,1803156,1838212,1838214,5141959,1878146,1774283,1752708,1768858,6119896,1866631,1866629,1949481,5123581,1949137,1949108,1780049,1869619,1869611,9565980,9537326,12220236,1875617,1875602,1878521,1872822,1733208,1842168,1842167,1923833,1950392,11897069,1855501,5114499,5114464,5114468,5114508,5114500,5114515,5114470,9767946,1968304,10223106,5120063,5120058,1828402,1975805,1975806,1963511,1963519,5114409,5114400,1986192,1986520,8407291,11838650,1986231,1986508,1942855,1942854,1970346,1800722,10051064,5149991,11424222,1849490,11889656,1748020,1748740,5104144,1786808,6215926,1958574,1774257,11736529,5714976,5714999,5112229,5112294,5112160,5112230,5714966,10389996,1790376,1790367,1790357,6122521,1730648,1730521,1730510,1730517,1730580,1730519,1862078,1862123,1862083,1862129,1862159,1966255,1966238,1835223,1835295,1835235,1835261,4686297,11451085,1835194,4686287,1835247,1835294,1982197,1859854,1830764,1851619,11655590,1923496,1766910,1941782,1830414,1830389,1830382,1830394,1830401,1830437,1830427,1830453,1830398,1830458,1830451,1830406,10251108,6114188,1830480,1830472,1830419,1830477,1830435,1830436,1830384,1830484,1830476,1830434,1830425,1830407,1830474,1830465,4525508,9399481,9827302,4525564,9024735,9916066,10346267,4525525,4525553,9427334,9973591,10199298,4525538,4525517,10009080,4525521,9955666,1831009,4525519,4525523,12028826,1907519,1907433,1907534,1907580,1907430,1907511,1758291,5112907,5112965,1799183,1871379,1871377,1961780,1961789,1961744,1961952,1962016,1961829,1961796,1961947,1854484,1975196,9515675,1975072,4686587,1831337,1825595,1883124,9883210,11683453,10033723,1743709,1743693,11572605,1743700,9208048,5119495,5119500,5119509,5119498,10855444,5119511,8746645,8799947,5119365,1940008,1940014,1940017,1829178,1956716,1943644,1943645,1966978,6119635,1968158,1730995,1730948,9245604,1735845,1752386,1752388,1870972,1849510,1849509,7409980,11874381,10135190,1839323,1769095,1876419,1876402,1876409,1876416,1876435,1876392,1876423,1876430,1876421,1876429,1876442,1876440,1876450,1876396,1882347,1791010,5105941,1812771) GROUP BY taxonKey

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