A dataset containing 2911186 records in GBIF matching the query: SELECT specieskey, COUNT(specieskey), countrycode FROM occurrence WHERE specieskey IS NOT NULL AND countrycode IS NOT NULL -- AND countrycode = 'CA' 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') AND datasetkey NOT IN ('ebd01d3e-5e9a-4e80-8ae2-1dfe9a032bf7', '6276fa08-f762-11e1-a439-00145eb45e9a', 'c8fb4ced-0374-46f7-8c03-5eb5a6b70640', '12464931-e8ea-4437-b6df-c280e063b107', 'b7ef1d60-b0a0-11dd-aa14-b8a03c50a862', '10fe7809-00b8-45ed-b743-963520ea7680', '5bc157a5-d52f-4be1-918b-c2950c5e742c', '00cbf1a4-5437-4902-84c8-17643eac3c8c', '0360c673-20fc-420a-845a-05d20f185dcf', '2ddded16-5565-45ee-8aa1-1b8118fa361f') GROUP BY specieskey, countrycode The dataset's 2911186 records were derived from 44025 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0034922-251025141854904/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.