{"key":"0028643-241107131044228","doi":"10.15468/dl.9h5wu2","license":"http://creativecommons.org/publicdomain/zero/1.0/legalcode","request":{"sql":"SELECT specieskey, countrycode FROM occurrence WHERE specieskey IS NOT NULL AND countrycode IS NOT NULL AND occurrencestatus = 'PRESENT' AND (basisofrecord='HUMAN_OBSERVATION' OR basisofrecord='MACHINE_OBSERVATION' OR basisofrecord='OCCURRENCE' OR basisofrecord='LIVING_SPECIMEN' OR basisofrecord='MATERIAL_SAMPLE') AND NOT ARRAY_CONTAINS(issue, 'ZERO_COORDINATE') AND NOT ARRAY_CONTAINS(issue, 'COORDINATE_OUT_OF_RANGE') AND NOT ARRAY_CONTAINS(issue, 'COUNTRY_COORDINATE_MISMATCH') GROUP BY specieskey, countrycode","sendNotification":true,"format":"SQL_TSV_ZIP","type":"OCCURRENCE"},"created":"2024-11-22T15:01:47.755+00:00","modified":"2024-11-22T15:14:50.695+00:00","eraseAfter":"2025-05-22T15:01:47.700+00:00","status":"SUCCEEDED","downloadLink":"https://api.gbif.org/v1/occurrence/download/request/0028643-241107131044228.zip","size":52155266,"totalRecords":2624752,"numberDatasets":41578}