taxons

Table actions

1 row where observations_count = 5960 and rank_level = 10

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date)

id ▼ rank rank_level iconic_taxon_id ancestor_ids is_active name parent_id ancestry extinct default_photo taxon_changes_count taxon_schemes_count observations_count flag_counts current_synonymous_taxon_ids atlas_id complete_species_count wikipedia_url iconic_taxon_name preferred_common_name complete_rank conservation_status min_species_ancestry endemic min_species_taxon_id threatened introduced native created_at photos_locked universal_search_rank
50639 species 10 47126 [48460, 47126, 211194, 47125, 47124, 48515, 48516, 634936, 634950, 50641, 1515383, 50639] 1 Solanum umbelliferum 1515383 48460/47126/211194/47125/47124/48515/48516/634936/634950/50641/1515383 0 {"id": 38552026, "license_code": "cc-by", "attribution": "(c) Ken-ichi Ueda, some rights reserved (CC BY), uploaded by Ken-ichi Ueda", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/38552026/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/38552026/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/38552026/medium.jpg"} 2 4 5960 {"resolved": 2, "unresolved": 0}       https://en.wikipedia.org/wiki/Solanum_umbelliferum Plantae bluewitch nightshade     48460,47126,211194,47125,47124,48515,48516,634936,634950,50641,1515383,50639 0 50639 0 0 1 2009-03-22T20:46:16+00:00 0 5960

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [taxons] (
   [id] INTEGER PRIMARY KEY,
   [rank] TEXT,
   [rank_level] INTEGER,
   [iconic_taxon_id] INTEGER,
   [ancestor_ids] TEXT,
   [is_active] INTEGER,
   [name] TEXT,
   [parent_id] INTEGER,
   [ancestry] TEXT,
   [extinct] INTEGER,
   [default_photo] TEXT,
   [taxon_changes_count] INTEGER,
   [taxon_schemes_count] INTEGER,
   [observations_count] INTEGER,
   [flag_counts] TEXT,
   [current_synonymous_taxon_ids] TEXT,
   [atlas_id] INTEGER,
   [complete_species_count] TEXT,
   [wikipedia_url] TEXT,
   [iconic_taxon_name] TEXT,
   [preferred_common_name] TEXT
, [complete_rank] TEXT, [conservation_status] TEXT, [min_species_ancestry] TEXT, [endemic] INTEGER, [min_species_taxon_id] INTEGER, [threatened] INTEGER, [introduced] INTEGER, [native] INTEGER, [created_at] TEXT, [photos_locked] INTEGER, [universal_search_rank] INTEGER);