taxons
2 rows where flag_counts = "{"resolved": 8, "unresolved": 0}"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3017 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 2708, 2715, 3000, 3017] | 1 | Columba livia | 3000 | 48460/1/2/355675/3/2708/2715/3000 | 0 | {"id": 96934693, "license_code": "cc-by-nc", "attribution": "(c) Константин Самодуров, some rights reserved (CC BY-NC), uploaded by Константин Самодуров", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/96934693/square.jpg", "original_dimensions": {"height": 800, "width": 1200}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/96934693/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/96934693/medium.jpg"} | 0 | 11 | 245271 | {"resolved": 8, "unresolved": 0} | http://en.wikipedia.org/wiki/Rock_dove | Aves | Rock Pigeon | subspecies | |||||||||||||
47219 | species | 10 | 47158 | [48460, 1, 47120, 372739, 47158, 184884, 47201, 124417, 326777, 47222, 630955, 47221, 199939, 538904, 47220, 578086, 47219] | 1 | Apis mellifera | 578086 | 48460/1/47120/372739/47158/184884/47201/124417/326777/47222/630955/47221/199939/538904/47220/578086 | 0 | {"id": 2369526, "license_code": null, "attribution": "(c) Georges-Alexandre Cotnoir, all rights reserved, uploaded by Georges-Alexandre Cotnoir", "url": "https://static.inaturalist.org/photos/2369526/square.jpg", "original_dimensions": {"height": 1402, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/2369526/square.jpg", "medium_url": "https://static.inaturalist.org/photos/2369526/medium.jpg"} | 1 | 5 | 416906 | {"resolved": 8, "unresolved": 0} | 1233 | http://en.wikipedia.org/wiki/Western_honey_bee | Insecta | Western Honey Bee | 48460,1,47120,372739,47158,184884,47201,124417,326777,47222,630955,47221,199939,538904,47220,578086,47219 | 0 | 47219 | 0 | 1 | 0 | 2008-04-16T18:08:27+00:00 | 0 | 416906 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);