Occurrence Download

A dataset containing 3545 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 (1761535,5136066,5136192,5135787,5135590,1901127,5136067,5135826,5136029,1901032,1901192,10168709,10040130,5135966,5135896,5135873,1901055,5135833,5135784,1758331,1758333,1758327,9415669,1839461,1839465,1839463,1802256,1874273,1874235,1874168,1874213,11573582,1874176,1874180,1874249,1874293,1874169,1874190,1874239,1874240,1874262,1874260,1874278,1874241,1874155,1874245,1874265,1874184,1874251,1874294,1874269,1874233,1874153,1874280,1874171,1751082,1751018,1750942,1750862,1750849,1750822,1750792,1751063,1751003,1750974,1750885,1750870,1750773,1751116,1751087,1751073,1750919,1750908,1750894,1751083,1750995,1750982,1750944,1750864,1750837,1750809,1750779,1750765,1751066,1750953,1750832,1750819,1750805,1750760,1751089,1751075,1750949,1750937,1750910,1750896,1750884,1750857,1750801,1751049,1750997,1750971,1750917,1750811,1751109,1751094,1751068,1751032,1751017,1750992,1750967,1750941,1750791,1751041,1751002,1750987,1750950,1750897,1750869,1750802,1750772,1750972,1750907,1750768,1750890,1750850,1750808,1751107,1750989,1750975,1750925,1750872,1750859,1750845,1751088,1751074,1751038,1750961,1750936,1750909,1750883,1750841,1750786,1751113,1751099,1751084,1751022,4706371,1751010,1750958,1750932,1750891,1750852,1750825,1750780,1751044,1751031,1750966,1750940,1750902,1750874,1750847,1750833,1751090,1740723,1740721,4707776,1740719,1740699,1740697,1740714,1740753,1960416,1829506,1829583,1829482,1829590,1829522,1829490,1829478,1829518,1829514,1829532,1829580,1829479,1829588,1829554,1829515,1782802,1782714,1782885,1782793,1782917,1782869,1782756,1782708,1782757,1782741,1909417,10455359,4707711,10473056,10606887,5143241,1865671,1901001,1901202,9072828,1901184,1901034,1873245,1821444,1858705,9719382,9689122,1993032,1993016,1993012,1877406,1861030,1860987,1865754,1865775,1865774,1865763,1865778,1865764,1867668,1788037,1788034,6121000,5125936,5125939,1867426,1863714,1973537,1764542,1791594,1740477,1740457,1740447,1740464,1740448,1740437,1740461,1740496,1740485,1740501,1740450,1740452,1740498,1740490,5113911,1842020,1842029,1842026,1842023,1842028,5802412,1776568,1939850,1940889,8133084,5108634,5108636,10639943,10288636,10382051,10056999,11420003,9849109,10080067,11728097,1831836,1831839,1956963,11509802,1980559,1990139,5102773,1738528,1738318,1738481,7585476,1738499,1951615,1878744,1817149,1752469,1752687,1964957,1822928,1822933,6111800,1811916,1754081,10121804,1985158,1985184,1985152,1985167,1985247,5127098,5127085,5127096,1949523,1949525,1861385,1861386,1859402,1859404,4536175,1859444,1754180,1992921,1992936,1877950,1951412,11879500,1847975,11645467,1862541,1862540,1840451,1840378,1840653,1840637,1840539,1840594,1840565,1840558,1840543,1840452,1840401,1840308,1840293,1840638,1840611,1840577,1840519,1840471,1840456,1840414,1840397,1840350,1840343,1840586,1840515,1840591,1840562,1840520,1840424,1840375,1840658,1840635,1840530,1840509,1840492,1840395,1840381,1840348,1840317,1840624,1840613,10365668,1840415,1840361,1840306,1840285,1840636,1840575,1840641,1840625,1840535,1853139,1853140,1853138,1856272,1881339,1881320,1881336,1881335,1834533,1834524,1835598,1834516,4685593,1834534,9442902,5123634,9549153,1790067,9356643,9410414,9242065,1921590,1921579,1921498,9088852,1891339,1891340,1891329,1771232,1771326,1771201,1770716,1771308,1771023,1770926,1944579,5117991,1740971,5101408,1949320,1949312,1751932,1800622,1800612,1800619,1800636,1800606,1931055,1752966,10376685,1952147,10864093,1955240,1802119,1940109,1940117,1940120,9091793,5143493,5143583,5143415,5143523,5119271,5119268,1843703,1730728,1828142,1775913,1925350,5125306,1754671,1805840,1805832,1805835,1805837,1805827,1869644,5143957,5143942,1957496,5105248,5105255,5105256,5105257,1992378,1992448,1992434,1765603,1808278,1808232,1808448,1808312,6198302,1808528,1808409,5130278,11589215,10725629,10722702,1854225,1854133,1906042,1822379,1871506,1889135,1932877,12103237,1851200,1933809,1782038,1782037,1749388,6114972,9590272,1842839,5123850,5123870,1775301,6133297,1816614,1816694,1816685,1816670,1816632,1816700,1816687,1816644,1816661,6112536,1814182,1814181,5110593,1783090,1736839,1736853,1736838,1863829,1806913,1806906,1806916,1771421,1771373,1771370,1771416,1766140,1766162,1766152,1766144,1748780,1874906,1855572,11606791,1774797,1822952,1848344,1848279,1848333,1848296,1848262,1848254,1848350,1848331,1848260,1848348,1848329,1848293,1848268,1848343,1848307,1848297,9679847,1848341,1848330,1848322,5120229,1784761,1735042,1735050,1735046,10615394,1907190,9313457,1907286,6113205,10483983,9530406,8823068,1827774,1827780,1847594,1847675,1847664,1847649,1847619,1847654,11702662,1847629,1847665,1847620,1847607,1847671,1847655,1847626,1847621,1847667,1847622,11761243,1847657,1847641,6133371,1847632,1847604,1847637,1847633,1847618,1847683,1847624,1788235,1789588,7672027,1776824,1846345,1855368,1793370,6122841,1842804,4529740,10203493,1838229,1838230,1838241,1873936,5103204,5103245,5103230,5103094,5103255,5103252,5103088,5103112,5103205,5103134,5103145,5103108,5103095,5103082,5103118,5103209,5103166,11907194,5103177,5103163,5103232,5103160,10501190,5103229,1880970,1880968,1880973,1874728,1874878,1874875,1874705,1872493,1868523,1868525,1862905,8395510,1775731,1776406,1776393,1776397,1877220,9177344,1777855,1965901,1797720,1761891,1788826,1788812,1788822,1788809,1752987,1963072,11829956,12259151,9826405,1849010,1849008,1867035,1867024,1775685,1775678,1775673,1775675,1775679,1775690,1775681,1775693,5112627,5112599,5112602,1785088,1784947,1785011,1784929,1785014,1785095,1785007,1956918,1874622,1842661,1842664,1842660,8888137,1741320,1741324,1825771,9479184,1838451,1838434,1838360,1838586,1838342,1838339,1838422,9554034,1838393,1838578,1902680,1732030,1731968,1732031,1731963,1731914,1731923,1866496,1866477,1866480,1866555,1866573,1866575,1866549,1868115,1824950,1824979,1824962,1824985,1824944,1824935,1824957,1849248,12027747,5123537,5123452,6114144,5123481,5123500,11939628,11988845,1743483,9393552,1758077,1924044,1924037,1950024,5119141,5119142,1966297,1969521,4522956,1861311,1861298,1861313,1861328,10583093,1861317,1861332,1861292,1861320,1861312,1861316,1861319,1861293,1861325,1851926,1786301,1768254,1768255,1768256,1827145,5120039,1796123,1795934,1796154,1795896,1796132,1796032,1849044,1849063,5131880,5734605,1942080,1848383,5104597,1748303,7588222,11818401,11760130,11994154,1985881,1870279,4300902,1842879,1842870,1842862,1812693,1777261,10573580,1764496,1961075,10747388,11828714,1967582,1747213,5105335,1740575,1748622,1748618,1748621,1748619,1748620,1749699,1963629,5137768,4533255,1798050,1798054,1748665,9121406,1744724,1744701,1744750,1744705,1744736,1744729,1744732,4529892,1744722,1744697,1744734,1744704,1740430,6114944,5137959,5121956,5121946,5770871,12170283,8744774,9209227,12091595,1848220,12020568,10161669,8902993,1762315,1802130,1841101,1963594,1928732,1902538,1736358,1865593,10043358,1789898,1740872,1740871,1793848,1878818,1745244,12176303,1746831,1746903,1746887,1746769,1746809,1746765,1746907,1746823,1746816,1746871,1746855,11411684,1746778,1746931,1746893,1746793,1746948,1746843,1746874,1746851,1746840,1746942,1746863,1746811,1746785,1746930,1746792,1746951,1990357,1823088,1838679,1819413,1819500,1819460,1819490,1819506,1819493,1819537,1819471,1819421,1819467,1819416,1838335,1800975,10435153,1850019,10287001,1852461,11864541,10605756,9977181,10292172,6119964,1806013,5116525,1945498,1909369,1881702,1830146,1830132,1830272,1830217,1830168,1830140,1830293,1830137,1830254,1830150,1830155,1830141,1830127,1830246,1830252,1830275,1830159,1830170,1830256,1830245,1830278,1830194,1830250,1830142,1830248,1830216,1830167,5126700,1850755,1895867,6218206,1745262,1745130,1742115,1819172,1747130,1747168,1747135,1747123,9865837,8653434,1747137,1747142,1747193,1747124,1747173,1927025,1927079,1927225,1927210,1927120,1774041,1979746,4685802,1870897,6133441,1751175,1751181,1751178,1751182,1835185,4685489,5122105,5122092,5122080,5122170,5122148,5122082,5122121,5122072,5122115,5122108,5122095,5122151,5122127,5122103,5122090,5122111,9259123,5122155,5122143,5122063,5122130,5122096,5122036,5122175,5122235,1792313,5118422,5118429,5118421,1992969,5118219,5118246,5118223,5118206,5118240,5118245,1851216,1851248,1851234,11608628,1851249,1851240,1851254,1851241,1747628,1747632,10503495,1866320,1866330,1866307,1866331,1732886,1732903,1732900,1819349,1819337,1819354,5110232,5110238,1830739,1837733,1750306,1750303,1750302,1931774,10215065,1843058,1843043,1843013,1843017,1843055,1843064,1843012,1843031,1843048,1843015,1980533,1775046,1775041,1775043,1775035,1775036,1766431,1775049,1775050,1800212,1774744,1774682,1774583,1774626,1774598,1774712,1774661,1774618,1774616,1774702,1889036,11830762,10801696,1748898,1876877,1876878,1876868,1876881,1854537,1854539,1860597,1860606,5104572,1758723,1987735,1943830,1943895,1943913,1943832,1744934,9864303,9936381,1939443,1939411,10473276,1939418,1939423,1939480,1939465,1889522,11422500,10127050,6111685,1757979,1855614,1759348,10039350,12213597,11622241,10004845,1863455,12180578,1745027,1759159,1877005,1787296,1787272,1787197,9502395,1787335,1787219,1787226,1787388,1787199,1787169,11888311,1867043,1867044,1867039,5122204,5122194,5122223,5122225,1968686,1833254,1891103,1826150,512471