cometadata/datacite-titles-descriptions-related-identifiers huggingface dataset:
DOI: 10.25549/inscriptifact-ouc112017213
title: Cuneiform Tablet 1913.14.0227, Spurlock 1913.14.0227

description: [Text Description:] Administrative tablet ❧ [Text or Publication Number Note:] Spurlock 1913.14.0227; CDLI P420609 ❧ [Medium:] Clay ❧ [Script Note:] Non-Alphabetic Cuneiform ❧ [Physical Object Description:] Yellowish White (10YR 9/1.5) ❧ [Physical Object Note:] 3.6 x 3.3 x 2 cm (29g) ❧ [Physical Object Note:] Seal impressions
DOI: 10.15468/dl.wqmnyn
title: Occurrence Download

description: A dataset containing 6628 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Country is one of (Ireland, Svalbard and Jan Mayen, Portugal, Spain, France, Germany, Belgium, Netherlands, Switzerland, Austria, Italy, Greece, Cyprus, Poland, Czechia, Slovakia, Hungary, Albania, Serbia, Romania, Bulgaria, Türkiye, Russian Federation, Ukraine)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Sagina maritima Don"
 ]
}

 The dataset includes 6628 records from 160 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0065486-240506114902167/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.9dmmxt
title: Occurrence Download

description: A dataset containing 203 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Hemitriccus cohnhafti K.J.Zimmer, Whittaker, Sardelli, Guilherme & Aleixo, 2013"
 ]
}

 The dataset includes 203 records from 7 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0377438-210914110416597/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.25549/inscriptifact-ouc112017217
title: Cuneiform Tablet 1913.14.0227, Spurlock 1913.14.0227

description: [Text Description:] Administrative tablet ❧ [Text or Publication Number Note:] Spurlock 1913.14.0227; CDLI P420609 ❧ [Medium:] Clay ❧ [Script Note:] Non-Alphabetic Cuneiform ❧ [Physical Object Description:] Yellowish White (10YR 9/1.5) ❧ [Physical Object Note:] 3.6 x 3.3 x 2 cm (29g) ❧ [Physical Object Note:] Seal impressions
DOI: 10.15468/dl.2yaef6
title: Occurrence Download

description: A dataset containing 23 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Viola forrestiana W.Becker",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

 The dataset includes 23 records from 4 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0271930-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.8jbntb
title: Occurrence Download

description: A dataset containing 3251 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Micropteropus pusillus (Peters, 1868)"
 ]
}

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

description: A dataset containing 15 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Floscopa tuberculata C.B.Clarke"
 ]
}

 The dataset includes 15 records from 8 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0218529-230224095556074/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.25549/inscriptifact-ouc112017218
title: Cuneiform Tablet 1913.14.0227, Spurlock 1913.14.0227

description: [Text Description:] Administrative tablet ❧ [Text or Publication Number Note:] Spurlock 1913.14.0227; CDLI P420609 ❧ [Medium:] Clay ❧ [Script Note:] Non-Alphabetic Cuneiform ❧ [Physical Object Description:] Yellowish White (10YR 9/1.5) ❧ [Physical Object Note:] 3.6 x 3.3 x 2 cm (29g) ❧ [Physical Object Note:] Seal impressions
DOI: 10.15468/dl.4m8bnv
title: Occurrence Download

description: A dataset containing 313 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Hemitriccus spodiops (Berlepsch, 1901)"
 ]
}

 The dataset includes 313 records from 12 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0377439-210914110416597/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.25549/inscriptifact-ouc112043859
title: Cuneiform Tablet 1913.14.0146, Spurlock 1913.14.0146

description: [Text Description:] Administrative tablet ❧ [Text or Publication Number Note:] Spurlock 1913.14.0146; CDLI P420527 ❧ [Medium:] Clay ❧ [Script Note:] Non-Alphabetic Cuneiform ❧ [Physical Object Description:] Pale Orange Yellow (10YR 8/3) ❧ [Physical Object Note:] 8.2x4.9 x 2.5 cm (110g)
DOI: 10.15468/dl.qtsdxf
title: Occurrence Download

description: A dataset containing 7083 species occurrences available in GBIF matching the query:
{
 "and" : [
 "BasisOfRecord is one of (Observation, Machine Observation, Human Observation, Material sample, Material citation, Specimen, Living Specimen)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Taeniatherum caput-medusae (L.) Nevski"
 ]
}

 The dataset includes 7083 records from 154 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0014856-230224095556074/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.5nuvdd
title: Occurrence Download

description: A dataset containing 7918 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Mahonia repens (Lindl.) G.Don"
 ]
}

 The dataset includes 7918 records from 146 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0177378-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.np2jc4
title: Occurrence Download

description: A dataset containing 5 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Floscopa schweinfurthii C.B.Clarke"
 ]
}

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

description: A dataset containing 3959 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Hemitriccus griseipectus (E.Snethlage, 1907)"
 ]
}

 The dataset includes 3959 records from 13 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0377447-210914110416597/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.25549/inscriptifact-ouc112043783
title: Cuneiform Tablet 1913.14.0146, Spurlock 1913.14.0146

description: [Text Description:] Administrative tablet ❧ [Text or Publication Number Note:] Spurlock 1913.14.0146; CDLI P420527 ❧ [Medium:] Clay ❧ [Script Note:] Non-Alphabetic Cuneiform ❧ [Physical Object Description:] Pale Orange Yellow (10YR 8/3) ❧ [Physical Object Note:] 8.2x4.9 x 2.5 cm (110g)
DOI: 10.15468/dl.d298x9
title: Occurrence Download

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Platyhelminthes",
 "DatasetKey is Records of macrozoobenthos organisms in several water bodies of Ukraine during 2007-2021",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "Geometry POLYGON ((-25.03991 31.75, 41.65954 31.75, 41.65954 71.53037, -25.03991 71.53037, -25.03991 31.75))"
 ]
}

 The dataset includes 0 records from 0 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0218530-230224095556074/datasets/export for details.
DOI: 10.15468/dl.es3mxx
title: Occurrence Download

description: A dataset containing 565 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Alopias pelagicus Nakamura, 1935"
 ]
}

 The dataset includes 565 records from 45 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0014867-230224095556074/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.25549/inscriptifact-ouc112046319
title: Cuneiform Tablet 1913.14.0221, Spurlock 1913.14.0221

description: [Text Description:] Administrative tablet ❧ [Text or Publication Number Note:] Spurlock 1913.14.0221; CDLI P420603 ❧ [Medium:] Clay ❧ [Script Note:] Non-Alphabetic Cuneiform ❧ [Physical Object Description:] Yellowish Gray (10YR 8.5/2) ❧ [Physical Object Note:] 3.4 x 3 x 2,1 cm (25g) ❧ [Physical Object Note:] Seal impressions
DOI: 10.15468/dl.2bsfdu
title: Occurrence Download

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Platyhelminthes",
 "DatasetKey is Suivi Photographique des Insectes Pollinisateurs (SPIPOLL)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "Geometry POLYGON ((-25.03991 31.75, 41.65954 31.75, 41.65954 71.53037, -25.03991 71.53037, -25.03991 31.75))"
 ]
}

 The dataset includes 0 records from 0 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0218543-230224095556074/datasets/export for details.
DOI: 10.15468/dl.r75qne
title: Occurrence Download

description: A dataset containing 658 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Barbieria DC."
 ]
}

 The dataset includes 658 records from 84 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0349685-210914110416597/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.49mgrm
title: Occurrence Download

description: A dataset containing 4886 species occurrences available in GBIF matching the query:
{
 "and" : [
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Ateles geoffroyi Kuhl, 1820"
 ]
}

 The dataset includes 4886 records from 59 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0377448-210914110416597/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.25549/inscriptifact-ouc112046173
title: Cuneiform Tablet 1913.14.0221, Spurlock 1913.14.0221

description: [Text Description:] Administrative tablet ❧ [Text or Publication Number Note:] Spurlock 1913.14.0221; CDLI P420603 ❧ [Medium:] Clay ❧ [Script Note:] Non-Alphabetic Cuneiform ❧ [Physical Object Description:] Yellowish Gray (10YR 8.5/2) ❧ [Physical Object Note:] 3.4 x 3 x 2,1 cm (25g) ❧ [Physical Object Note:] Seal impressions
DOI: 10.15468/dl.h5kvc8
title: Occurrence Download

description: A dataset containing 84175 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is one of (Lagopus muta (Montin, 1781), Lagopus mutus (Montin, 1781))",
 "BasisOfRecord is one of (Specimen, Human Observation, Observation, Machine Observation)",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

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

description: A dataset containing 10 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Propithecus tattersalli Simons, 1988"
 ]
}

 The dataset includes 10 records from 5 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0349720-210914110416597/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.25549/inscriptifact-ouc112046360
title: Cuneiform Tablet 1913.14.0221, Spurlock 1913.14.0221

description: [Text Description:] Administrative tablet ❧ [Text or Publication Number Note:] Spurlock 1913.14.0221; CDLI P420603 ❧ [Medium:] Clay ❧ [Script Note:] Non-Alphabetic Cuneiform ❧ [Physical Object Description:] Yellowish Gray (10YR 8.5/2) ❧ [Physical Object Note:] 3.4 x 3 x 2,1 cm (25g) ❧ [Physical Object Note:] Seal impressions
DOI: 10.15468/dl.adzenh
title: Occurrence Download

description: A dataset containing 1642 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Hemitriccus iohannis (E.Snethlage, 1907)"
 ]
}

 The dataset includes 1642 records from 15 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0377453-210914110416597/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.25549/inscriptifact-ouc112046361
title: Cuneiform Tablet 1913.14.0221, Spurlock 1913.14.0221

description: [Text Description:] Administrative tablet ❧ [Text or Publication Number Note:] Spurlock 1913.14.0221; CDLI P420603 ❧ [Medium:] Clay ❧ [Script Note:] Non-Alphabetic Cuneiform ❧ [Physical Object Description:] Yellowish Gray (10YR 8.5/2) ❧ [Physical Object Note:] 3.4 x 3 x 2,1 cm (25g) ❧ [Physical Object Note:] Seal impressions
DOI: 10.15468/dl.srqbz7
title: Occurrence Download

description: A dataset containing 3304 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Eidolon helvum (Kerr, 1792)"
 ]
}

 The dataset includes 3304 records from 65 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0349723-210914110416597/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.25549/inscriptifact-ouc112046148
title: Cuneiform Tablet 1913.14.0221, Spurlock 1913.14.0221

description: [Text Description:] Administrative tablet ❧ [Text or Publication Number Note:] Spurlock 1913.14.0221; CDLI P420603 ❧ [Medium:] Clay ❧ [Script Note:] Non-Alphabetic Cuneiform ❧ [Physical Object Description:] Yellowish Gray (10YR 8.5/2) ❧ [Physical Object Note:] 3.4 x 3 x 2,1 cm (25g) ❧ [Physical Object Note:] Seal impressions
DOI: 10.15468/dl.mt6s3d
title: Occurrence Download

description: A dataset containing 589 species occurrences available in GBIF matching the query:
{
 "and" : [
 "BasisOfRecord is Specimen",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "TaxonKey is Torilis arvensis subsp. arvensis"
 ]
}

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

description: A dataset containing 26 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Asteroma microspermum (Peck) B.Sutton",
 {
 "not" : {
 "Country" : [
 "is United States of America"
 ]
 }
 },
 {
 "not" : {
 "Country" : [
 "is Canada"
 ]
 }
 },
 {
 "not" : {
 "DatasetKey" : [
 "is Global database of alien macrofungi"
 ]
 }
 }
 ]
}

 The dataset includes 26 records from 12 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0101097-230530130749713/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.25r48b
title: Occurrence Download

description: A dataset containing 145 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Platyhelminthes",
 "DatasetKey is naturgucker",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "Geometry POLYGON ((-25.03991 31.75, 41.65954 31.75, 41.65954 71.53037, -25.03991 71.53037, -25.03991 31.75))"
 ]
}

 The dataset includes 145 records from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0218531-230224095556074/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.25549/inscriptifact-ouc112045161
title: Cuneiform Tablet 1913.14.0169, Spurlock 1913.14.0169

description: [Text Description:] Administrative tablet ❧ [Text or Publication Number Note:] Spurlock 1913.14.0169; CDLI P420550 ❧ [Medium:] Clay ❧ [Script Note:] Non-Alphabetic Cuneiform ❧ [Physical Object Description:] Yellowish White (10YR 9/2) Brownish Pink (5YR 8/3) ❧ [Physical Object Note:] 7.5 x 4.5 x 2.3 cm (82g) ❧ [Physical Object Note:] Seal impressions
DOI: 10.15468/dl.anek9e
title: Occurrence Download

description: A dataset containing 1307 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Alasmidonta undulata",
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 {
 "not" : {
 "BasisOfRecord" : [
 "is Fossil"
 ]
 }
 },
 {
 "or" : [
 {
 "not" : {
 "EstablishmentMeans" : [
 "is MANAGED"
 ]
 }
 },
 {
 "not" : {
 "EstablishmentMeans" : [
 "is not null"
 ]
 }
 }
 ]
 },
 {
 "or" : [
 "OccurrenceStatus is Present",
 {
 "not" : {
 "OccurrenceStatus" : [
 "is not null"
 ]
 }
 }
 ]
 }
 ]
}

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

description: A dataset containing 50 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Tetragonopterus juruena",
 "DecimalLatitude is not null",
 "DecimalLongitude is not null"
 ]
}

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

description: A dataset containing 525 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Cariniana pyriformis"
 ]
}

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

description: A dataset containing 8999 species occurrences available in GBIF matching the query:
{
 "and" : [
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Delphinapterus leucas"
 ]
}

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

description: A dataset containing 54 species occurrences available in GBIF matching the query:
{
 "and" : [
 "HasGeospatialIssue is false",
 "HasCoordinate is true",
 "OccurrenceStatus is Present",
 {
 "not" : {
 "BasisOfRecord" : [
 "is one of (Fossil, Living Specimen)"
 ]
 }
 },
 "TaxonKey is Atriplex cryptocarpa"
 ]
}

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

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

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