cluster

cluster_num_id

{'link': '/cluster/{value}'}

5 rows where profile_Object = "0000-0002-3407-8397"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: days_active_pct, habitat, itinerary, collecting_areas, placenames, regional_units

CREATE TABLE "cluster" (
   [cluster_stage1_id] INTEGER PRIMARY KEY,
   [num_records] INTEGER,
   [recordedby_unique] INTEGER,
   [recordedby_first_familyname] TEXT,
   [recordnumber_unique] INTEGER,
   [eventdate_unique] INTEGER,
   [eventdate_day_offset_min] FLOAT,
   [eventdate_day_offset_max] FLOAT,
   [year_min] FLOAT,
   [year_max] FLOAT,
   [countrycode_unique] INTEGER,
   [duration_days] FLOAT,
   [hascoordinate_count] INTEGER,
   [hascoordinate_pct] FLOAT,
   [days_active_pct] FLOAT,
   [habitat] TEXT,
   [itinerary] TEXT,
   [collecting_areas] TEXT,
   [placenames] TEXT,
   [regional_units] TEXT,
   [profile_Object] TEXT REFERENCES [profile]([Object])
);