geonomia
Queries
Tables
cluster
cluster_stage1_id, num_records, recordedby_unique, recordedby_first_familyname, recordnumber_unique, eventdate_unique, eventdate_day_offset_min, eventdate_day_offset_max, year_min, year_max, countrycode_unique, duration_days, hascoordinate_count, hascoordinate_pct, days_active_pct, habitat, itinerary, collecting_areas, placenames, regional_units, profile_Object
10,913 rows
occ
gbifid, institutionid, basisofrecord, catalognumber, recordnumber, recordnumber_contains_numerals, recordnumber_contains_year, recordedby, recordedby_has_personal_name, recordedbyid, georeferenceverificationstatus, othercatalognumbers, fieldnumber, fieldnumber_contains_numerals, eventdate, eventdate_day_offset, year, month, day, verbatimeventdate, habitat, fieldnotes, eventremarks, countrycode, locality, verbatimlocality, decimallatitude, decimallongitude, scientificname, datasetkey, elevation, elevationaccuracy, nontaxonomicissue, mediatype, v_associatedmedia, hascoordinate, hasgeospatialissues, issequenced, institutionkey, collectionkey, isincluster, recordnumber_mainnumber, recordedby_first_familyname, recordedby_team_familynames, eventdate_eligible, recordnumber_eligible, recordedby_eligible, cluster_stage1_id, coordinate_source_specimen_metadata, coordinate_source_collecting_event, coordinate_source_collector_day, coordinate_source, Subject, bionomia_profile_id
681,830 rows
... and 10 hidden tables
Download SQLite DB: geonomia.db 671.1 MB