Occurrence Download

A dataset containing 3504 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 (1845419,1845405,1845444,1845435,1845445,8954825,1845616,1845539,1845513,1845455,1845411,1845271,1845481,1845638,1845576,10259769,1870462,1870466,1926418,1985952,1980290,1864807,11991541,1797769,1797788,4532208,11651362,1797796,1772250,6132925,6117252,6132927,1797793,4532218,6115775,1797864,1797763,4532224,7946065,6115809,1768349,1797759,6115772,1797912,1797892,6115812,1796834,1852886,1830031,1830625,1871743,1830605,1973493,1831775,1810348,1810160,1810145,5116332,5147886,1954496,5117803,5117785,5117839,5117846,5117824,1891190,5127533,5105401,5105411,1833275,1798402,10623344,1745351,5103660,5103844,5103348,5103765,5103733,5103281,5103870,5103780,8034030,5103742,5103725,5103670,5103625,5103341,5103744,5103584,5103558,5103626,5103411,5103544,5103845,5103829,5103484,5103674,1745270,1749279,1732585,1732582,1732584,1732583,1968831,10210550,1967716,11862612,11416557,1868041,1855871,1743260,6117491,6132915,11513188,6117500,6132917,7924383,6132916,1986807,5112128,9914401,1967217,5131636,8814055,5131637,1985830,1731518,5101881,5101832,5102169,5101977,5101826,5101963,5102068,5102136,5101981,6132985,4533669,1738949,1738960,12224850,10537825,1940441,11244052,1827543,8875553,1830333,4300978,1763206,1763248,1885178,1885179,1965807,1965861,1965841,1761587,8851818,1731747,1731746,1960199,1960196,1960201,1990420,1768963,5139897,1853461,1957435,1957368,1957413,1842211,5122426,5122433,5122434,10240328,4706417,11453408,1850738,5141523,1863901,8067880,1842255,4300698,4300940,4300790,1952993,1753404,1965281,1965200,1983709,1983407,1983182,1982931,1982382,1983956,1983696,1983651,1983561,1982951,1982533,1982375,1982870,1983304,1982561,1983465,1983331,1983264,1984107,1983862,1983677,1983550,1982728,1983474,1983154,1983037,1983017,1982460,1983600,1983116,1983028,1983799,1983594,1983552,1983468,1983039,9267599,1982444,1984129,4302281,1983478,1982732,1983393,1982447,1776696,5136830,9251096,5137270,5136387,5137105,5103994,5104032,1821912,1821684,1821486,1821901,1821616,6121807,1821882,1821546,1821851,1821761,1822003,1821547,1821454,1822019,1821891,1821840,1821713,1822086,1821954,1821597,1821455,1822045,1821828,1822065,9143634,1821746,1821719,1821680,1822021,1821949,1821802,1821940,1821531,1821504,1821795,1821747,1821510,1821729,1821517,1821479,1821972,6121783,6121835,6121830,1753961,1960117,1838054,1803687,1758884,1758874,1868980,11432790,1868897,1868945,1868929,1868942,1868915,1868907,1868904,1868896,1868992,1868978,1868952,5132917,1806069,1806083,1806092,5805625,5137839,5137859,5137840,5137841,1734884,1889277,12368029,5141258,1745486,1848989,1876002,10039769,1783346,12218523,1827302,5149312,5149290,5149307,1733824,1777414,1777541,1777517,1777435,1777433,1777400,6115982,1777473,8753116,1777515,1777471,1777418,1777516,5130904,5130914,5102248,5102242,1839716,1967396,12091920,1768972,1944260,1944251,1734955,1773273,1773485,9369576,1773200,1773238,1773100,1773093,1773383,1773133,1773117,1773062,1773109,1773533,9470676,1773455,1773394,1773229,1773628,1773588,1773280,1773257,1773140,1773681,1773277,1773534,1773405,1773370,1773429,1875328,1875324,1875430,1875318,1875423,1875424,1875405,1876016,4532004,1891442,1891429,1891469,1839263,1839300,1839290,1839274,1839298,1839307,1839310,1981374,1744225,1859550,1859554,6114821,6133397,1859549,1742344,1852672,1787514,1787513,1787517,1848641,1848638,1778528,1811746,1811749,1811750,1911862,1774119,1774020,5123618,11798476,10060965,11587655,11610256,11856935,11704191,11762563,1785825,1987350,1987377,1987362,1894018,1874324,11449470,9942486,1931285,12083693,1931288,1931296,1765385,1765388,1765440,1765418,5118978,5118984,9564779,11983130,10616776,1848497,1848477,1848498,1848560,1848530,1848478,1848561,1848505,8780502,1848562,1848553,1848495,1848543,1848533,1848569,1848496,1848540,1885012,1931801,6132659,1931776,1931787,1931800,5734266,5110013,5109974,9291361,9281105,6119932,6119924,6119949,6119942,6119919,6119962,9332098,6119937,6119922,9459438,1895259,4302313,1850729,1846314,1846313,1991504,1991495,1991503,1743730,5125299,1858666,1800528,1802090,1992551,1962953,1827515,1813467,1865385,1823563,1868847,1973366,1973338,1800875,1801367,1801371,1823254,4685699,4685678,10548683,11794425,1732746,1732741,1732756,1746721,1746718,1746714,1746720,1953236,1874146,9864836,1825923,10297889,5123045,1850458,1850399,1850358,1850393,1850346,1850412,1850423,1850365,1850281,1850390,1850290,1850429,1850315,1850298,1850424,1850312,11576787,1850371,1850327,1850333,10083877,9960252,1871905,1873342,1873341,5144528,5144517,5144521,5144508,5144525,1786729,1786724,1857705,1761143,5110560,5110546,1889543,1866743,1802004,1802022,1743468,1749689,1749691,1749688,1749685,1749690,1973391,1859158,8561957,1732447,1843063,1842892,1850666,1993637,1993635,5127122,1973263,5102566,7569962,7546053,5102569,8002658,8772989,9345465,5102436,9623807,5102589,7810887,7501501,1924057,1965677,1965710,1965667,1965695,1789854,1940273,5101556,5101559,5101564,5101565,5101567,9630748,1829762,1829947,1829901,1829794,1829746,5127592,5127589,5127569,5127675,5127669,5127698,5127629,5127700,5127632,5127615,10147033,5127638,5127605,5127688,5127644,5127618,1790845,10014621,1869397,1748347,1775804,1851686,1851670,1851747,1851676,1851742,1851738,1851696,1851701,1851684,1851674,1851750,1851720,1851746,1851732,1851728,1736782,1828096,9176043,11512756,11548893,1834589,11503568,1922734,1866262,1866274,1866273,1866257,1866249,1801042,1761353,5120472,5120470,5120469,1838131,1837125,1837129,10610041,1737210,8831819,1732847,1770063,1770035,1770017,1770036,1770018,1770047,1770044,1770042,1975712,1732961,1732947,1732963,12039262,1951988,5124784,5124776,1768319,1768309,1749726,1749723,1749731,1789498,1789496,1806176,1806179,1787009,1733230,1769612,1769643,1769709,1769701,1769680,1750336,12295115,11554277,11832051,1736522,1736497,10248483,10457068,1736483,1736595,11442818,1736583,1736473,1736535,11926032,10792157,11734693,11429172,1736569,1736546,12360434,10040178,11737918,1895200,1736764,1736767,1736768,1736762,1736763,1736770,9860031,10033607,10046036,10161071,1861378,9940600,1861377,11672855,1939797,1878406,1959543,8461175,5125127,1805643,1833537,1833531,1833535,11635419,5149953,5149880,5149912,5149873,11735210,5149893,5149872,5149986,1868001,1858633,1736918,1736922,1736948,10638589,1736939,11529060,1802931,6132857,1787825,7917033,1787978,7694948,1824020,1824021,1878688,1878708,1753565,1753567,1753579,1814369,5129479,5129520,1977877,1786317,1827473,1822719,10045595,1843448,1843450,12211600,1733202,1768394,1768391,1786132,1921910,1745004,1745000,1847875,5118575,5105671,5105682,1789071,11582002,1761790,1761789,1881031,1881021,1881042,1880982,1752205,1737536,1737538,1737521,1737543,1737563,1737527,1737532,1737535,1850568,1850592,1850575,1850528,1850609,1850633,1850587,1850640,1852445,1850630,1850621,1850585,1850567,1850565,1850634,1737659,1737662,5142829,9846919,1900523,1900574,1900546,1900410,1900282,1900295,1900549,1900210,1900858,1792591,5883835,1831733,1831728,1831734,1831735,1831730,1831738,1831732,1780277,9436314,1780275,1780272,1791140,1791142,1838102,1973300,6116437,4534683,12018817,6116440,7929835,1861206,1861224,1861220,9795847,9746673,1859968,5123103,9686431,9709119,9711838,9700051,1859987,9662050,9747345,9718546,1879443,1786247,1786262,1819316,1819320,4685431,1837047,5118777,5118601,5118652,5118749,5118600,5118772,5118750,5118587,5118656,5118642,1980293,1786760,1786733,1883881,1991173,1991184,1991152,1991195,1991383,10077605,1991378,1737995,1867744,1733232,1899164,1743942,1743958,1743944,5111831,1768042,1767990,1768048,1824201,1871680,1871644,1871607,1992862,1992854,1925408,9925669,9962098,10643403,1882929,1882944,7799481,11708800,1882927,1739545,1745852,6116055,1920267,1960636,1960633,9265559,1898448,1757770,1977988,1875972,5112843,5149011,5149018,5148991,5149017,1873285,1818931,1818930,1779751,1754483,1975606,1987602,1918601,1989972,1989942,1989955,1989977,1843768,1752213,1778346,1778344,9607833,1854242,1770628,1748062,5113436,1828081,1837163,11722467,5118813,1862348,1862310,1862294,1862331,11959685,1941530,1754933,1843737,1852638,1852580,1852649,1852620,1852577,1852635,1852575,1852652,1852607,1852637,9153416,1852901,6113643,6113652,6113658,5885259,5103042,1789636,1846351,1846356,1992543,6116707,1832705,1832688,1818737,1967239,1798335,1798326,1798332,1798327,1798333,1798329,5125976,5126009,5126021,5125956,5125949,5126005,5126038,5125972,5126007,5126028,9455782,1793191,1793194,1745950,1745933,10714586,1745934,1745967,1745977,1745932,1745935,1745962,11501369,1745936,1768662,1741539,1741537,1741538,1801424,1754598,1754590,1767340,6115799,1874317,1738927,1738924,1869318,1790496,1790493,1790505,1806691,1952612,1833302,1752383,1798101,1878354,1822974,1822976,1854019,1854021,1885623,1885597,1891033,1960668,1853419,5125853,1942087,1942094,1804185,1917980,1992282,1992277,1992275,1992268,1796680,1796686,1796648,1766042,1766057,1979380,1979286,1979313,1979501,1979408,1979358,1979346,1979466,1979344,1879467,1752445,1752444,1887349,1832715,1858267,1822917,10031640,1822916,11483324,1862894,1862874,1867120,1867073,1867147,1867174,1867135,1867187,1867110,1867224,1867108,1867071,1867079,1867156,11700356,1920819,1749494,1749496,1749497,1749495,1802939,5141506,1975852,1771733,1851528,