home

geonomia

Custom SQL query

Tables

cluster

cluster_num_id, recordedBy_first_family, eventDate_min, eventDate_max, recordNumber_mainNumber_min, recordNumber_mainNumber_max, cluster_num_id_count, recordedBy_identity_nonnull_count, eventDate_unique_count, recordNumber_mainNumber_unique_count, countryCode_unique_count, family_unique_count, eventDate_diff_days, recordNumber_mainNumber_diff, completeness, georef_completeness

9,077 rows

occ

gbifID, family, scientificName, locality, decimalLatitude, decimalLongitude, elevation, eventDate, catalogNumber, recordedBy, recordedBy_first_family, recordNumber_mainNumber, has_coordinates, cluster_num_id, collectorNameNumber, collectorEventDate

675,975 rows

... and 5 hidden tables

Powered by Datasette · Queries took 153.373ms