geonomia

Custom SQL query

Queries

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

240,213 rows

occ

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

11,287,350 rows

... and 5 hidden tables

Download SQLite DB: geonomia.db 4.5 GB