cometadata/datacite-titles-descriptions-related-identifiers huggingface dataset:
DOI: 10.15468/dl.bi845p
title: Occurrence Download

description: A dataset containing 2579 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Geometry POLYGON((-99.84324 20.73584,-99.984 20.72382,-100.06227 20.6864,-100.04271 20.65104,-99.93404 20.61344,-99.83912 20.61739,-99.74573 20.62323,-99.82023 20.73,-99.84324 20.73584))",
 "TaxonKey is Magnoliopsida"
 ]
}

 The dataset includes 2579 records from 45 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0041377-191105090559680/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.hsk659
title: Occurrence Download

description: A dataset containing 21 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Mikania rondonensis V.M.Badillo"
 ]
}

 The dataset includes 21 records from 10 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0113424-220831081235567/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.daiowb
title: Occurrence Download

description: A dataset containing 8 species occurrences available in GBIF matching the query:
{
 "DatasetKey" : [
 "is (Table 1) Proportion of Toxoplasma gondii seropositive arctic foxes (Alopex lagopus) by age group and geographic area"
 ]
}

 The dataset includes 8 records from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0013322-171219132708484/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.m1dygi
title: Occurrence Download

description: A dataset containing 8 species occurrences available in GBIF matching the query:
{
 "DatasetKey" : [
 "is (Table 1) Proportion of Toxoplasma gondii seropositive arctic foxes (Alopex lagopus) by age group and geographic area"
 ]
}

 The dataset includes 8 records from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0005303-160526112335914/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.uwnaqp
title: Occurrence Download

description: A dataset containing 16 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Psychotria soejartoi C.M.Taylor"
 ]
}

 The dataset includes 16 records from 4 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0113418-220831081235567/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.q2x8v7
title: Occurrence Download

description: A dataset containing 490807 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Numenius arquata (Linnaeus, 1758)",
 "CoordinateUncertaintyInMeters is less than 1000",
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "Year is greater than or equal to 1990",
 "OccurrenceStatus is Present",
 {
 "not" : {
 "BasisOfRecord" : [
 "is one of (Fossil, Living Specimen)"
 ]
 }
 }
 ]
}

 The dataset includes 490807 records from 165 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0149437-220831081235567/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.nxtxrk
title: Occurrence Download

description: A dataset containing 361429811 species occurrences available in GBIF matching the query:
{
 "DatasetKey" : [
 "is EOD – eBird Observation Dataset"
 ]
}

 The dataset includes 361429811 records from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0013295-171219132708484/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.pf1inn
title: Occurrence Download

description: A dataset containing 8 species occurrences available in GBIF matching the query:
{
 "DatasetKey" : [
 "is (Table 1) Proportion of Toxoplasma gondii seropositive arctic foxes (Alopex lagopus) by age group and geographic area"
 ]
}

 The dataset includes 8 records from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0002560-171113114016250/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.ndibfx
title: Occurrence Download

description: A dataset containing 32 species occurrences available in GBIF matching the query:
{
 "DatasetKey" : [
 "is (Table 1) Proportion of Toxoplasma gondii seropositive arctic foxes (Alopex lagopus) by age group and geographic area"
 ]
}

 The dataset includes 32 records from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0002972-190813142620410/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.cgpegu
title: Occurrence Download

description: A dataset containing 3 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Country is Venezuela (Bolivarian Republic of)",
 "OccurrenceStatus is Present",
 "TaxonKey is Pelagornithidae"
 ]
}

 The dataset includes 3 records from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0113429-220831081235567/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.h0ina7
title: Occurrence Download

description: A dataset containing 8 species occurrences available in GBIF matching the query:
{
 "DatasetKey" : [
 "is (Table 1) Proportion of Toxoplasma gondii seropositive arctic foxes (Alopex lagopus) by age group and geographic area"
 ]
}

 The dataset includes 8 records from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0095442-160910150852091/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.ayflyc
title: Occurrence Download

description: A dataset containing 8 species occurrences available in GBIF matching the query:
{
 "DatasetKey" : [
 "is (Table 1) Proportion of Toxoplasma gondii seropositive arctic foxes (Alopex lagopus) by age group and geographic area"
 ]
}

 The dataset includes 8 records from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0013279-171219132708484/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.vtxwxt
title: Occurrence Download

description: A dataset containing 32 species occurrences available in GBIF matching the query:
{
 "DatasetKey" : [
 "is (Table 1) Proportion of Toxoplasma gondii seropositive arctic foxes (Alopex lagopus) by age group and geographic area"
 ]
}

 The dataset includes 32 records from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0008028-190813142620410/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.jtb9u7
title: Occurrence Download

description: A dataset containing 65 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Isatis violascens Bunge"
 ]
}

 The dataset includes 65 records from 18 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0149458-220831081235567/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.lvqumr
title: Occurrence Download

description: A dataset containing 8 species occurrences available in GBIF matching the query:
{
 "DatasetKey" : [
 "is (Table 1) Proportion of Toxoplasma gondii seropositive arctic foxes (Alopex lagopus) by age group and geographic area"
 ]
}

 The dataset includes 8 records from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0008761-160623103540712/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.dv7ufb
title: Occurrence Download

description: A dataset containing 601992799 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Year 2000-2018",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

 The dataset includes 601992799 records from 7919 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0021699-180131172636756/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.agwydt
title: Occurrence Download

description: A dataset containing 134 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Continent is South America",
 "Country is Ecuador",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "TaxonKey is Vampyressa thyone"
 ]
}

 The dataset includes 134 records from 14 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0002801-260108223611665/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.25582/data.2024-04.3081316/2546643
title: Data for EMSL Project 60201 from April 2024
DOI: 10.25582/data.2024-04.3081317/2546644
title: Data for EMSL Project 60201 from April 2024
DOI: 10.5281/zenodo.15134339
title: Table 2 in Description of a new species of Loxosceles Heineken & Lowe (Araneae, Sicariidae) recluse spiders from Hidalgo, Mexico, under integrative taxonomy: morphological and DNA barcoding data (CO 1 + ITS 2)

description: Table 2. Primers used for each molecular marker for PCR.
GenePrimer namePrimer sequence (5′–3′)ReferenceCO1LCOGGT CAA CAA ATC ATA AAG ATA TTG GFolmer et al. (1994),HCOTAA ACT TCA GGG TGA CCA AAA AAT CALCO-JJCHA CWA AYC ATA AAG ATA TYG GAstrin & Stueben (2008)HCO-JJAWA CTT CVG GRT GCV CAA ARA ATC AITS25.8SCAC GGG TCG ATG AAG AAC GCJi et al. (2003), Planas & Ribera (2014)CAS28sB1dTTC TTT TCC TCC SCT TAY TRA TAT GCT TAA
description: Published as part of Navarro-Rodríguez, Claudia Isabel & Valdez-Mondragón, Alejandro, 2020, Description of a new species of Loxosceles Heineken & Lowe (Araneae, Sicariidae) recluse spiders from Hidalgo, Mexico, under integrative taxonomy: morphological and DNA barcoding data (CO 1 + ITS 2), pp. 6 in European Journal of Taxonomy 704 on page 6, DOI: 10.5852/ejt.2020.704, http://zenodo.org/record/3994411
DOI: 10.5281/zenodo.15134338
title: Table 2 in Description of a new species of Loxosceles Heineken & Lowe (Araneae, Sicariidae) recluse spiders from Hidalgo, Mexico, under integrative taxonomy: morphological and DNA barcoding data (CO 1 + ITS 2)

description: Table 2. Primers used for each molecular marker for PCR.
GenePrimer namePrimer sequence (5′–3′)ReferenceCO1LCOGGT CAA CAA ATC ATA AAG ATA TTG GFolmer et al. (1994),HCOTAA ACT TCA GGG TGA CCA AAA AAT CALCO-JJCHA CWA AYC ATA AAG ATA TYG GAstrin & Stueben (2008)HCO-JJAWA CTT CVG GRT GCV CAA ARA ATC AITS25.8SCAC GGG TCG ATG AAG AAC GCJi et al. (2003), Planas & Ribera (2014)CAS28sB1dTTC TTT TCC TCC SCT TAY TRA TAT GCT TAA
description: Published as part of Navarro-Rodríguez, Claudia Isabel & Valdez-Mondragón, Alejandro, 2020, Description of a new species of Loxosceles Heineken & Lowe (Araneae, Sicariidae) recluse spiders from Hidalgo, Mexico, under integrative taxonomy: morphological and DNA barcoding data (CO 1 + ITS 2), pp. 6 in European Journal of Taxonomy 704 on page 6, DOI: 10.5852/ejt.2020.704, http://zenodo.org/record/3994411
DOI: 10.25582/data.2024-04.3081320/2546645
title: Data for EMSL Project 60201 from April 2024
DOI: 10.5281/zenodo.15134340
title: Table 3. Genetic p in Description of a new species of Loxosceles Heineken & Lowe (Araneae, Sicariidae) recluse spiders from Hidalgo, Mexico, under integrative taxonomy: morphological and DNA barcoding data (CO 1 + ITS 2)

description: Table 3. Genetic p -distance matrix from the CO1 data among Loxosceles tolantongo sp. nov., L. tenango Gertsch, 1973 and L. jaca Gertsch & Ennik, 1983. Average p -distance = 6.7%.
Species1234567891. Ara0191 – L. tenango2. Ara0192 – L. tenango0.0003. Ara0186 – L. jaca0.0710.0684. Ara0048 – L. jaca0.0730.0700.0025. Ara0046 – L. jaca0.0700.0700.0020.0046. Ara0047 – L. jaca0.0670.0680.0020.0040.0057. Ara0183 – L. jaca0.0850.0850.0170.0180.0180.0208. Ara0175 – L. tolantongo sp. nov.0.0950.0940.1020.1050.1040.1020.1189. Ara0181 – L. tolantongo sp. nov.0.0960.0980.0980.1010.1040.1000.1230.00810. Ara0182 – L. tolantongo sp. nov.0.0940.0970.0970.1000.1030.0990.1230.0100.005
description: Published as part of Navarro-Rodríguez, Claudia Isabel & Valdez-Mondragón, Alejandro, 2020, Description of a new species of Loxosceles Heineken & Lowe (Araneae, Sicariidae) recluse spiders from Hidalgo, Mexico, under integrative taxonomy: morphological and DNA barcoding data (CO 1 + ITS 2), pp. 19 in European Journal of Taxonomy 704 on page 19, DOI: 10.5852/ejt.2020.704, http://zenodo.org/record/3994411
DOI: 10.5281/zenodo.15134341
title: Table 3. Genetic p in Description of a new species of Loxosceles Heineken & Lowe (Araneae, Sicariidae) recluse spiders from Hidalgo, Mexico, under integrative taxonomy: morphological and DNA barcoding data (CO 1 + ITS 2)

description: Table 3. Genetic p -distance matrix from the CO1 data among Loxosceles tolantongo sp. nov., L. tenango Gertsch, 1973 and L. jaca Gertsch & Ennik, 1983. Average p -distance = 6.7%.
Species1234567891. Ara0191 – L. tenango2. Ara0192 – L. tenango0.0003. Ara0186 – L. jaca0.0710.0684. Ara0048 – L. jaca0.0730.0700.0025. Ara0046 – L. jaca0.0700.0700.0020.0046. Ara0047 – L. jaca0.0670.0680.0020.0040.0057. Ara0183 – L. jaca0.0850.0850.0170.0180.0180.0208. Ara0175 – L. tolantongo sp. nov.0.0950.0940.1020.1050.1040.1020.1189. Ara0181 – L. tolantongo sp. nov.0.0960.0980.0980.1010.1040.1000.1230.00810. Ara0182 – L. tolantongo sp. nov.0.0940.0970.0970.1000.1030.0990.1230.0100.005
description: Published as part of Navarro-Rodríguez, Claudia Isabel & Valdez-Mondragón, Alejandro, 2020, Description of a new species of Loxosceles Heineken & Lowe (Araneae, Sicariidae) recluse spiders from Hidalgo, Mexico, under integrative taxonomy: morphological and DNA barcoding data (CO 1 + ITS 2), pp. 19 in European Journal of Taxonomy 704 on page 19, DOI: 10.5852/ejt.2020.704, http://zenodo.org/record/3994411
DOI: 10.25582/data.2024-04.3081321/2546646
title: Data for EMSL Project 60201 from April 2024
DOI: 10.5281/zenodo.15134342
title: Table 4. Genetic p - distance matrix from the ITS 2 in Description of a new species of Loxosceles Heineken & Lowe (Araneae, Sicariidae) recluse spiders from Hidalgo, Mexico, under integrative taxonomy: morphological and DNA barcoding data (CO 1 + ITS 2)

description: Table 4. Genetic p -distance matrix from the ITS2 data between Loxosceles tolantongo sp. nov. and L. jaca Gertsch & Ennik, 1983. Average p- distance = 1.8%.
Species123456789101. Ara0046 – L. jaca2. Ara0047 – L. jaca0.0033. Ara0186 – L. jaca0.0210.0184. Ara0183 – L. jaca0.0060.0030.0155. Ara0174 – L. tolantongo sp. nov.0.0160.0130.0200.0156. Ara0176 – L. tolantongo sp. nov.0.0150.0120.0190.0150.0067. Ara0177 – L. tolantongo sp. nov.0.0190.0150.0230.0180.0090.0098. Ara0178 – L. tolantongo sp. nov.0.0210.0180.0250.0200.0120.0060.0159. Ara0181 – L. tolantongo sp. nov.0.0120.0090.0150.0120.0030.0030.0060.00910. Ara0182 – L. tolantongo sp. nov.0.0170.0150.0210.0170.0090.0090.0060.0140.00611. Ara0175 – L. tolantongo sp. nov.0.0250.0210.0290.0240.0150.0150.0180.0210.0120.015
description: Published as part of Navarro-Rodríguez, Claudia Isabel & Valdez-Mondragón, Alejandro, 2020, Description of a new species of Loxosceles Heineken & Lowe (Araneae, Sicariidae) recluse spiders from Hidalgo, Mexico, under integrative taxonomy: morphological and DNA barcoding data (CO 1 + ITS 2), pp. 19 in European Journal of Taxonomy 704 on page 19, DOI: 10.5852/ejt.2020.704, http://zenodo.org/record/3994411
DOI: 10.5281/zenodo.15134343
title: Table 4. Genetic p - distance matrix from the ITS 2 in Description of a new species of Loxosceles Heineken & Lowe (Araneae, Sicariidae) recluse spiders from Hidalgo, Mexico, under integrative taxonomy: morphological and DNA barcoding data (CO 1 + ITS 2)

description: Table 4. Genetic p -distance matrix from the ITS2 data between Loxosceles tolantongo sp. nov. and L. jaca Gertsch & Ennik, 1983. Average p- distance = 1.8%.
Species123456789101. Ara0046 – L. jaca2. Ara0047 – L. jaca0.0033. Ara0186 – L. jaca0.0210.0184. Ara0183 – L. jaca0.0060.0030.0155. Ara0174 – L. tolantongo sp. nov.0.0160.0130.0200.0156. Ara0176 – L. tolantongo sp. nov.0.0150.0120.0190.0150.0067. Ara0177 – L. tolantongo sp. nov.0.0190.0150.0230.0180.0090.0098. Ara0178 – L. tolantongo sp. nov.0.0210.0180.0250.0200.0120.0060.0159. Ara0181 – L. tolantongo sp. nov.0.0120.0090.0150.0120.0030.0030.0060.00910. Ara0182 – L. tolantongo sp. nov.0.0170.0150.0210.0170.0090.0090.0060.0140.00611. Ara0175 – L. tolantongo sp. nov.0.0250.0210.0290.0240.0150.0150.0180.0210.0120.015
description: Published as part of Navarro-Rodríguez, Claudia Isabel & Valdez-Mondragón, Alejandro, 2020, Description of a new species of Loxosceles Heineken & Lowe (Araneae, Sicariidae) recluse spiders from Hidalgo, Mexico, under integrative taxonomy: morphological and DNA barcoding data (CO 1 + ITS 2), pp. 19 in European Journal of Taxonomy 704 on page 19, DOI: 10.5852/ejt.2020.704, http://zenodo.org/record/3994411
DOI: 10.25582/data.2024-04.3081322/2546647
title: Data for EMSL Project 60201 from April 2024
DOI: 10.25582/data.2024-04.3081323/2546648
title: Data for EMSL Project 60201 from April 2024
DOI: 10.25582/data.2024-04.3081324/2546649
title: Data for EMSL Project 60201 from April 2024
DOI: 10.25582/data.2024-04.3081325/2546650
title: Data for EMSL Project 60201 from April 2024
DOI: 10.25582/data.2024-04.3081326/2546651
title: Data for EMSL Project 60201 from April 2024
DOI: 10.5281/zenodo.15134361
title: Table 1 in New acoustic and molecular data shed light on the poorly known Amazonian frog Adenomera simonstuarti (Leptodactylidae): implications for distribution and conservation

description: Table 1. Uncorrected (lower diagonal) and corrected (Jukes-Cantor model; upper diagonal) pairwise genetic distances of a fragment from COI mtDNA gene among the lineages of the Adenomera simonstuarti species complex (named as sim1–8). Within-lineage distances (uncorrected/ corrected), when applicable, were highlighted in bold across the central diagonal (upper left to lower right). The lineage 3 corresponds to the nominal species. Values are presented as means (in %).
sim1sim2sim3sim4sim5sim6sim7sim8sim11.7 / 1.73.35.26.14.85.94.36.9sim23.20.2/ 0.25.37.05.45.85.47.2sim34.95.00.7/ 0.75.34.75.15.27.3sim45.86.75.10.0/ 0.03.87.35.68.0sim54.65.24.53.7–6.13.97.1sim65.75.65.07.05.9–6.07.5sim74.25.25.05.33.85.8–6.7sim86.66.97.07.66.87.16.3–
description: Published as part of Carvalho, Thiago R., Moraes, Leandro J. C. L., Angulo, Ariadne, Werneck, Fernanda P., Icochea, Javier & Lima, Albertina P., 2020, New acoustic and molecular data shed light on the poorly known Amazonian frog Adenomera simonstuarti (Leptodactylidae): implications for distribution and conservation, pp. 8 in European Journal of Taxonomy 682 on page 8, DOI: 10.5852/ejt.2020.682, http://zenodo.org/record/3939336
DOI: 10.5281/zenodo.15134362
title: Table 1 in New acoustic and molecular data shed light on the poorly known Amazonian frog Adenomera simonstuarti (Leptodactylidae): implications for distribution and conservation

description: Table 1. Uncorrected (lower diagonal) and corrected (Jukes-Cantor model; upper diagonal) pairwise genetic distances of a fragment from COI mtDNA gene among the lineages of the Adenomera simonstuarti species complex (named as sim1–8). Within-lineage distances (uncorrected/ corrected), when applicable, were highlighted in bold across the central diagonal (upper left to lower right). The lineage 3 corresponds to the nominal species. Values are presented as means (in %).
sim1sim2sim3sim4sim5sim6sim7sim8sim11.7 / 1.73.35.26.14.85.94.36.9sim23.20.2/ 0.25.37.05.45.85.47.2sim34.95.00.7/ 0.75.34.75.15.27.3sim45.86.75.10.0/ 0.03.87.35.68.0sim54.65.24.53.7–6.13.97.1sim65.75.65.07.05.9–6.07.5sim74.25.25.05.33.85.8–6.7sim86.66.97.07.66.87.16.3–
description: Published as part of Carvalho, Thiago R., Moraes, Leandro J. C. L., Angulo, Ariadne, Werneck, Fernanda P., Icochea, Javier & Lima, Albertina P., 2020, New acoustic and molecular data shed light on the poorly known Amazonian frog Adenomera simonstuarti (Leptodactylidae): implications for distribution and conservation, pp. 8 in European Journal of Taxonomy 682 on page 8, DOI: 10.5852/ejt.2020.682, http://zenodo.org/record/3939336
DOI: 10.15468/dl.3qxp3h
title: Occurrence Download

description: A dataset containing 79 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 "year",
 IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY kingdomkey, "year")) kingdomcount,
 IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY phylumkey, "year")) phylumcount,
 IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY classkey, "year")) classcount,
 IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY orderkey, "year")) ordercount,
 IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY familykey, "year")) familycount,
 IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey, "year")) genuscount,
 COUNT(*) occurrences,
 MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 occurrence.countrycode = 'BR'
 AND occurrence.hascoordinate = TRUE
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.occurrencestatus = 'PRESENT'
 AND GBIF_STRINGARRAYCONTAINS(occurrence.classifications['d7dddbf4-2cf0-4f39-9b2a-bb099caae36c'], '4277005', TRUE)
 AND NOT GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'TAXON_MATCH_FUZZY', TRUE)
 AND (occurrence.distancefromcentroidinmeters &gt;= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL)
 AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN')
 AND (occurrence.classificationdetails['d7dddbf4-2cf0-4f39-9b2a-bb099caae36c']['specieskey'] &lt;&gt; '' AND occurrence."year" IS NOT NULL)
GROUP BY
 occurrence.kingdom,
 occurrence.kingdomkey,
 occurrence.phylum,
 occurrence.phylumkey,
 occurrence.class,
 occurrence.classkey,
 occurrence."order",
 occurrence.orderkey,
 occurrence.family,
 occurrence.familykey,
 occurrence.genus,
 occurrence.genuskey,
 occurrence.species,
 occurrence.specieskey,
 occurrence."year"

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