taxons
6 rows where iconic_taxon_id = 20978
This data as json, CSV (advanced)
Suggested facets: taxon_changes_count, taxon_schemes_count, flag_counts
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24259 | species | 10 | 20978 | [48460, 1, 2, 355675, 20978, 20979, 23540, 787592, 24253, 24259] | 1 | Pseudacris regilla | 24253 | 48460/1/2/355675/20978/20979/23540/787592/24253 | 0 | {"id": 173430494, "license_code": "cc-by-nc", "attribution": "(c) Thomas Barbin, some rights reserved (CC BY-NC), uploaded by Thomas Barbin", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/173430494/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/173430494/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/173430494/medium.jpg"} | 3 | 5 | 55379 | {"resolved": 1, "unresolved": 0} | 234 | http://en.wikipedia.org/wiki/Pacific_tree_frog | Amphibia | Pacific chorus frog | |||||||||||||
26823 | species | 10 | 20978 | [48460, 1, 2, 355675, 20978, 26718, 26720, 26816, 26823] | 1 | Dicamptodon ensatus | 26816 | 48460/1/2/355675/20978/26718/26720/26816 | 0 | {"id": 202779, "license_code": "cc-by-nc", "attribution": "(c) J. Maughn, some rights reserved (CC BY-NC), uploaded by J. Maughn", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/202779/square.jpg", "original_dimensions": {"height": 1200, "width": 1600}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/202779/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/202779/medium.jpg"} | 0 | 8 | 2347 | {"resolved": 0, "unresolved": 0} | 237 | http://en.wikipedia.org/wiki/California_giant_salamander | Amphibia | California Giant Salamander | {"id": 11571, "place_id": null, "source_id": 37, "user_id": null, "authority": "IUCN Red List", "status": "nt", "status_name": "near threatened", "geoprivacy": "obscured", "iucn": 20} | ||||||||||||
27459 | species | 10 | 20978 | [48460, 1, 2, 355675, 20978, 26718, 26909, 787564, 27444, 27459] | 1 | Batrachoseps attenuatus | 27444 | 48460/1/2/355675/20978/26718/26909/787564/27444 | 0 | {"id": 1545, "license_code": "cc-by-nc-sa", "attribution": "(c) Steve Lew, some rights reserved (CC BY-NC-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1545/square.jpg", "original_dimensions": {"height": 1050, "width": 1154}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1545/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1545/medium.jpg"} | 0 | 8 | 19440 | {"resolved": 0, "unresolved": 0} | 228 | http://en.wikipedia.org/wiki/California_slender_salamander | Amphibia | California Slender Salamander | |||||||||||||
27826 | species | 10 | 20978 | [48460, 1, 2, 355675, 20978, 26718, 27701, 787591, 27816, 27826] | 1 | Taricha granulosa | 27816 | 48460/1/2/355675/20978/26718/27701/787591/27816 | 0 | {"id": 27604, "license_code": "cc-by-nc-nd", "attribution": "(c) matt knoth, some rights reserved (CC BY-NC-ND)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/27604/square.jpg", "original_dimensions": {"height": 1360, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/27604/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/27604/medium.jpg"} | 0 | 8 | 15802 | {"resolved": 0, "unresolved": 0} | 232 | http://en.wikipedia.org/wiki/Rough-skinned_newt | Amphibia | Rough-skinned Newt | |||||||||||||
65979 | species | 10 | 20978 | [48460, 1, 2, 355675, 20978, 20979, 25473, 60340, 65979] | 1 | Lithobates catesbeianus | 60340 | 48460/1/2/355675/20978/20979/25473/60340 | 0 | {"id": 4654051, "license_code": "cc-by-nc", "attribution": "(c) bubbacho, some rights reserved (CC BY-NC)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4654051/square.jpg", "original_dimensions": {"height": 1414, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4654051/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4654051/medium.jpg"} | 1 | 9 | 87750 | {"resolved": 3, "unresolved": 1} | 510 | http://en.wikipedia.org/wiki/American_bullfrog | Amphibia | American Bullfrog | |||||||||||||
67016 | species | 10 | 20978 | [48460, 1, 2, 355675, 20978, 20979, 25473, 25474, 67016] | 1 | Rana draytonii | 25474 | 48460/1/2/355675/20978/20979/25473/25474 | 0 | {"id": 1690776, "license_code": "cc-by-nc", "attribution": "(c) J. Maughn, some rights reserved (CC BY-NC), uploaded by J. Maughn", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1690776/square.jpg", "original_dimensions": {"height": 1363, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1690776/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1690776/medium.jpg"} | 0 | 9 | 2738 | {"resolved": 0, "unresolved": 0} | 434 | http://en.wikipedia.org/wiki/California_red-legged_frog | Amphibia | California Red-legged Frog | {"id": 21573, "place_id": null, "source_id": 37, "user_id": null, "authority": "IUCN Red List", "status": "vu", "status_name": "vulnerable", "geoprivacy": "obscured", "iucn": 30} |
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);