cluster

cluster_num_id

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

13 rows where profile_Object = "Q111661474"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: num_records, recordedby_unique, recordnumber_unique, eventdate_day_offset_min, eventdate_day_offset_max, year_min, year_max, hascoordinate_count, hascoordinate_pct

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])
);