taxons
3 rows where taxon_changes_count = 5
This data as json, CSV (advanced)
Suggested facets: taxon_schemes_count
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
63048 | species | 10 | 47115 | [48460, 1, 47115, 47429, 47428, 533431, 372790, 533483, 533539, 1067212, 63049, 63048] | 1 | Nuttallina californica | 63049 | 48460/1/47115/47429/47428/533431/372790/533483/533539/1067212/63049 | 0 | {"id": 40998095, "license_code": "cc-by-nc", "attribution": "(c) Kat Halsey, some rights reserved (CC BY-NC), uploaded by Kat Halsey", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/40998095/square.jpeg", "original_dimensions": {"height": 688, "width": 917}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/40998095/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/40998095/medium.jpeg"} | 5 | 1 | 4828 | {"resolved": 0, "unresolved": 0} | Mollusca | California Spiny Chiton | |||||||||||||||
143799 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 48526, 781703, 52689, 143799] | 1 | Sambucus cerulea | 52689 | 48460/47126/211194/47125/47124/48526/781703/52689 | 0 | {"id": 46738687, "license_code": "cc-by-nc", "attribution": "(c) Matthew Zlatunich, some rights reserved (CC BY-NC), uploaded by Matthew Zlatunich", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/46738687/square.jpg", "original_dimensions": {"height": 2048, "width": 1771}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/46738687/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/46738687/medium.jpg"} | 5 | 1 | 27779 | {"resolved": 3, "unresolved": 1} | 16744 | http://en.wikipedia.org/wiki/Sambucus_cerulea | Plantae | blue elder | |||||||||||||
348720 | species | 10 | 47170 | [48460, 47170, 47169, 492000, 50814, 1094814, 47167, 785522, 48420, 379669, 348720] | 1 | Volvopluteus gloiocephalus | 379669 | 48460/47170/47169/492000/50814/1094814/47167/785522/48420/379669 | 0 | {"id": 22624144, "license_code": "cc-by-nc", "attribution": "(c) Christian Schwarz, some rights reserved (CC BY-NC), uploaded by Christian Schwarz", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/22624144/square.jpg", "original_dimensions": {"height": 1357, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/22624144/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/22624144/medium.jpg"} | 5 | 2 | 15670 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Volvopluteus_gloiocephalus | Fungi | Stubble Rosegill |
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);